ExcelSummarizer

ExcelSummarizer is a Yeager Workflow that automates the process of extracting insights from an Excel workbook, analyzing formulas, and generating a summary report in the form of a Word document. The workflow consists of five key steps, which are as follows: 1) Accept an Excel workbook uploaded by the user. 2) Extract relevant data trends, patterns, and anomalies from the workbook using appropriate Excel APIs or data sources. 3) Generate a summary of the workbook using natural language processing or machine learning techniques, and create visual aids that highlight key insights. 4) Analyze all formulas used in the workbook and generate a detailed report on their purpose and function. 5) Generate a professional, readable Word document that summarizes the workbook and includes the detailed report on formulas used, a table of contents, and relevant visual aids.

Initial generation prompt

A workflow named ExcelSummarizer that performs the following steps: First, a component that accepts an Excel workbook file as input from the user. Then, a component that extracts relevant data from the input workbook, such as data trends, patterns, and anomalies, using appropriate Excel APIs or data sources. Next, a component that generates a summary of the workbook, including key insights and relevant visual aids, using natural language processing or machine learning techniques. After that, a component that analyzes all formulas used in the workbook and generates a detailed report on their purpose and function. Finally, a component that generates a formal Word document summarizing the workbook and includes the detailed report on formulas used. The Word document should be professional, readable, and include a table of contents and appropriate visual aids to enhance understanding. The user should be able to customize the format and structure of the Word document as needed.

Authors:

  • yWorkflows
  • Johnathan#2005