Online Journalism Blog: Google Sheets has a new AI function — how does it perform on classification tasks?. “AI has been built into Google Sheets for some time now in the Clippy-like form of Gemini in Sheets. But Google Sheets’s AI function is different. Available to a limited number of users for now, it allows you to incorporate AI prompts directly into a formula rather than having to […]

https://rbfirehose.com/2025/04/13/online-journalism-blog-google-sheets-has-a-new-ai-function-how-does-it-perform-on-classification-tasks/

#ScribesAndMakers Apr 11: Do you use spreadsheets to help in your process? If so, how do you use them, and what makes them better than other tools?

The road to hell is paved with spreadsheets.

I don't like it hot. For this reason, I do not use them for my writing. ;-)

Turn numbers into insights—instantly!

Sparklines in Collabora Online let you visualize trends right inside your spreadsheet—no bulky charts needed!

Swipe through to see how easy it is to insert, customize, and format them in just 3 simple steps.

Want more details? Check out the full blog post: https://www.collaboraonline.com/blog/how-to-use-sparklines-in-collabora-online/?utm_campaign=Blog&utm_medium=Social&utm_source=Mastodon&utm_content=Sparklines

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. (-:

TOTALLY getting a set of these
#spreadsheets #lol #infosec https://vis.social/@infobeautiful/114274133861273281

Data categorization doesn't need hours of tedious work anymore. (Un)Perplexed Spready analyzes context and automatically classifies items with formulas like =PERPLEXITY1(A2, "Is this electronics, clothing, or home goods?").
https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready/un-perplexed-spready-various-articles/135-un-perplexed-spready-when-spreadsheets-finally-learn-to-think

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!
https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready/un-perplexed-spready-various-articles/144-say-goodbye-to-spreadsheet-chaos-un-perplexed-spready-brings-ai-to-the-rescue

Fascinating how people use AI to generate cute images while businesses waste hours on manual data extraction. (Un)Perplexed Spready lets you connect directly to AI models through Ollama to extract, categorize, and analyze data right in your spreadsheet.
https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready/44-un-perplexed-spready

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!
https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready/un-perplexed-spready-various-articles/135-un-perplexed-spready-when-spreadsheets-finally-learn-to-think

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!
https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready/un-perplexed-spready-various-articles/139-unlocking-efficiency-how-un-perplexed-spready-transforms-spreadsheets-into-ai-powerhouses

With (Un)Perplexed Spready, you can classify inputs based on any criteria using simple formulas! This takes data organization to a whole new level. Say goodbye to chaos in your spreadsheets! Find out more: https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready
#DataManagement #TimeSaver #Automation
#AI #Spreadsheets #DataExtraction #DataLabeling #DataAnotation #DataCategorization #DataClassification #SmartData #AItools #ProductComparison #SmartSpreadsheets #DataStandardization #ProductivityTools #SpreadsheetRevolution

Tired of wasting hours on data entry? Let (Un)Perplexed Spready automate those tasks with AI integration! Spend less time crunching numbers and more time making decisions. Discover how: https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready

Why settle for basic formulas when you can use AI-driven ones? (Un)Perplexed Spready offers innovative functions that expand what’s possible in spreadsheets. Get ready for a productivity boost! Explore now: https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready

Want to compare products effortlessly? Use the ASK_LOCAL function in (Un)Perplexed Spready to analyze attributes side by side. No more manual checks—let AI handle it! Check out this feature: https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready

Let’s face it, spreadsheets can be boring! But with (Un)Perplexed Spready, you can turn data analysis into an engaging experience. Integrate AI and make your work fun again! Find out how: https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready

Join the spreadsheet revolution! (Un)Perplexed Spready is changing the way people work with data.  Claim your free evaluation license and experience the power of AI in your formulas.   Download now: https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready

(Un)Perplexed Spready: It's not just a regular spreadsheet software, it's an AI-powered data miner! Extract valuable insights, automate tasks, and conquer your data challenges. Start your journey: https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready

Unleash the full potential of your spreadsheets! (Un)Perplexed Spready combines familiar spreadsheet software features with cutting-edge AI. It's powerful, fun, and ready to transform your data! Explore now: https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready

Don't let low-spec hardware hold you back! (Un)Perplexed Spready works with Ollama models like Mistral 7b, OLMo2:7b, DeepSeek-1:7b, Gemma3:1b even on older laptops. Get AI power without breaking the bank!   See how: https://matasoft.hr/qtrendcontrol/index.php/un-perplexed-spready