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

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

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

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