#spreadsheetFormula

Matasoft

@matasoft.bsky.social

2 months ago

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

Matasoft

@matasoft.bsky.social

2 months ago

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

Matasoft

@matasoft.bsky.social

2 months ago

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.

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

Tiller

@tiller.com

9 months ago

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