Examples of working mechanisms and applications of AI formulas
Melder revolutionizes Excel's handling of unstructured documents by introducing special AI formulas. These formulas retain the ease-of-use characteristics of Excel's native functions, while adding intelligent analysis capabilities. For example, =EXTRACT(A2,'Company Name') can automatically extract the company name from the PDF contract, =CATEGORIZE(A2,'payment frequency',{ 'Monthly','Quarterly','Yearly'}) is able to recognize the payment frequency and categorize it automatically.
Compared with traditional methods that require VBA programming, AI formula has three significant advantages: 1) simple operation and complete visualization; 2) wide processing range, supporting unstructured data sources such as PDF and web pages; 3) verifiable results, with data traceability markers for each output. Tests show that when processing 100 contracts, traditional methods take an average of 8 hours, while using AI formulas takes only 15 minutes and is more accurate. This seamless integration of structured and unstructured data makes Excel a truly all-purpose data processing platform.
This answer comes from the articleMelder: Add-in to add AI formula and document processing power to Excel tablesThe
