lingo.lol is one of the many independent Mastodon servers you can use to participate in the fediverse.
A place for linguists, philologists, and other lovers of languages.

Server stats:

69
active users

#spreadsheets

2 posts2 participants1 post today

A tip for spreadsheet users that I have learned from watching a mistake made by others:

When you use
=MAX(M2-X2/M2,0.1)
to place a floor of 10% on how low you want your calculation to be of a fractional positive gap to reduce M2 to X2 by, please try to remember that the X2 cell value could be *already greater* than the M2 cell value.

You probably want
=IF(X2<M2,MAX(M2-X2/M2,0.1),0)
or similar.

Because if (say) M2 is 6.81E+10 and X2 is 7.99E+10, then your calculation is going to come up with 10% instead of 0%, let alone the correct -17%.

Which might be embarrassing. (-:

If you're still manually parsing text in Excel with complex formulas, you're living in the past. (Un)Perplexed Spready uses AI to extract specific information from text cells with natural language commands. No regex needed, just results!
matasoft.hr/qtrendcontrol/inde

Tired of manually categorizing products one by one? (Un)Perplexed Spready's AI integration analyzes thousands of product descriptions and automatically sorts them into categories like "meat, dairy, bakery, or other" with just one formula. This is AI doing REAL work!
matasoft.hr/qtrendcontrol/inde

While everyone's playing with AI chatbots asking for jokes, (Un)Perplexed Spready is revolutionizing spreadsheet data. It extracts specific product measures from dirty product descriptions and converts them to metric units with a single formula. That's practical AI!
matasoft.hr/qtrendcontrol/inde

Replied in thread

@nixCraft

#LibreOffice

The #free and #private office suite is a powerful, free and private office suite the successor project to #OpenOffice used by people around the world. It's #compatible with Microsoft Office (#365) and is backed by a non-profit organization, The Document Foundation. LibreOffice includes Writer (word processing), Calc (#spreadsheets), Impress (presentations), Draw (vector graphics and #flowcharts), Base (#databases), and Math (formula editing).

libreoffice.org/discover/libre

www.libreoffice.orgWhat is LibreOffice? | LibreOffice - Free and private office suite - Based on OpenOffice - Compatible with MicrosoftLibreOffice, Free Office Suite, Fun Project, Fantastic People, Writer, Calc, Impress, Draw, Base, Charts, Diagrams, extensions, templates, word processor, text editor, spreadsheet, presentation, database, documents, Document Foundation