Check a multi-recipe grocery total against the source spreadsheet
At a glance
A cook tested ChatGPT's ingredient totals against an Excel recipe database and found a missing onion entry. This workflow is listed under Groceries, Cooking, Spreadsheets.
- Agents / tools
- ChatGPT, Microsoft Excel
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Prepare an Excel spreadsheet containing the ingredients for a variety of meals; the author's file contained 700 rows. Upload the spreadsheet to ChatGPT. 2) Ask for a consolidated ingredient list for four chosen meals. ChatGPT returned totals, but the author noticed that one meal's onions were missing. 3) Ask how it calculated the onion total and compare its explanation with the source spreadsheet. It named the other three meals. 4) Point ChatGPT to the row containing onions for the fourth meal and inspect its response: it acknowledged that it had missed that row.
How it went
The check exposed an omitted ingredient in the proposed total. The post does not report a verified corrected total.
Worth knowing
Providing the spreadsheet did not guarantee that ChatGPT included every relevant row; the author checked its explanation against the original data.