#spreadsheetFormula
LightNews LightNews
matasoft.bsky.social
GLM-4.7 is used for this demo—currently one of the best open-source LLMs, surpassing models like kimi-k2. See what it can do in a practical spreadsheet task of products taxonomy classification.
matasoft.hr/QTrendContro...
#GLM4 #OpenSourceAI #Benchmarks
#AIAdvantage #SpreadsheetFormula #AI #LLM
An example of using (Un)Perplexed Spready in a real life use case - Furniture catalog taxonomy classification
AI-driven spreadsheet software (Un)Perplexed Spready automates complex data tasks by integrating advanced AI models directly into spreadsheets. This article demonstrates how (Un)Perplexed Spready, com...
matasoft.hr
January 10, 2026 at 10:07 AM
mortimerroot.bsky.social
The Wandering Formula

A working spreadsheet formula breaks when copied down a column. Mort discovers that one cell reference was allowed to move with it.

#MortRoot #SpreadsheetFormula #Helpdesk #SysAdmin #TechHumor #TechSupport #fyp #deadinside #ComputerProblems #ITProblems
September 12, 2026 at 6:56 PM
tiller.com
Go beyond SUMIF!

Use =IF within an ARRAYFORMULA for flexible, multi-criteria sums without helper columns.

=ARRAYFORMULA(SUM(IF((A:A="Project X")*(B:B="Completed"),C:C,0))).

This sums 'C' only if 'A' is "Project X" AND 'B' is "Completed."

#spreadsheets #spreadsheetFormula

🧵7/8
June 8, 2025 at 2:41 PM
matasoft.bsky.social
AI doesn't just replace the manual lookup; it improves it. It can find multiple correct categories a human might miss and perform external research for ambiguous items. #AIAdvantage #SpreadsheetFormula #AIIntegration #DataMapping #AIProductivity #DataQuality #ProductInfo
matasoft.hr/QTrendContro...
An example of using (Un)Perplexed Spready in a real life use case - Furniture catalog taxonomy classification
AI-driven spreadsheet software (Un)Perplexed Spready automates complex data tasks by integrating advanced AI models directly into spreadsheets. This article demonstrates how (Un)Perplexed Spready, com...
matasoft.hr
January 9, 2026 at 9:19 PM
matasoft.bsky.social
See the exact ASK_LOCAL3 formula that connects product data, a taxonomy range, and an AI prompt to perform intelligent classification inside a spreadsheet cell. #SpreadsheetFormula #AIIntegration #DataMapping #AIProductivity #DataQuality #ProductInfo #HierarchicalData #AI
matasoft.hr/QTrendContro...
An example of using (Un)Perplexed Spready in a real life use case - Furniture catalog taxonomy classification
AI-driven spreadsheet software (Un)Perplexed Spready automates complex data tasks by integrating advanced AI models directly into spreadsheets. This article demonstrates how (Un)Perplexed Spready, combined with SearXNG, Matasoft Web Search tool and Ollama Cloud provided GLM-4.7 LLM model, can perform advanced AI-driven mapping and categorization of products to appropriate hierarchical product taxonomy.
matasoft.hr
January 9, 2026 at 8:41 PM