Excel formula checks with AI
Trace a suspicious total to a worksheet and cell. A local checker flags broken references, shortened sums and numbers pasted over neighbouring formulas.
Excel formula checks with AI give you somewhere to start when a workbook still looks tidy after someone has added another month of sales. The formula-first-workbook skill includes a Python checker that reads a saved Excel file. A finding points to a sheet and a cell, so you can see which rows the total actually includes.
For a new workbook, the guide asks the agent to separate assumptions from calculations. Put the unit and source beside a figure such as a monthly rate. A separate check can then compare the sum of departments with the company total. Later, anyone changing the rate knows where it belongs.
What it does
- Find a sum that stops just before the newest figures.
- Check a reference to a sheet that has since been renamed or removed.
- Spot a typed number partway down a column filled with formulas.
- Keep source notes with input cells when several people maintain the workbook.
- Ask for an explanation of the most serious finding before investigating warnings.
Install and use
- Use a local Excel file and an agent with Python and openpyxl. The checker requires no separate account.
- Ask, “Find any totals in this budget that miss the two rows I added, and give me the cell addresses.”
- Open those cells in your spreadsheet editor. After fixing a genuine mistake, save the file and check it again.
FAQ
Source
Made by Hearthbook Labs. Original skill: formula-first-workbook, published on GitHub under the MIT licence.
View on GitHub