Build a cash-flow waterfall chart
ChartsMediumLLM judge scoringLatest run
Passed by 8 of 12 products on their best model. Failed: Claude Code + Sheets MCP, Claude Code + Autosheet MCP, Gemini in Sheets and ChatGPT in Sheets.
Prompt
Build a waterfall showing the cash-flow bridge.
Starting spreadsheet
Cash Flow| A | B | |
|---|---|---|
| 1 | Stage | Amount |
| 2 | Starting cash | 500000 |
| 3 | Operating cash flow | 185000 |
| 4 | Capital expenditure | -120000 |
| 5 | Debt repayment | -75000 |
| 6 | New financing | 90000 |
| 7 | Ending cash | 580000 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- A waterfall from starting to ending cash
- Each movement goes the right way; it ends at 580,000
- Readable and titled; the data is unchanged
Passed 16
Autosheet in Excel Opus 5.5 · Medium
Autosheet in Excel GPT-6 Astra · Low
Autosheet in Sheets Opus 5.5 · Medium
Autosheet in Excel Sonnet 5.5 · Medium
Claude in Excel Opus 5.5 · High
Autosheet in Excel Haiku 5.5 · High
Claude in Sheets Opus 5.5 · Medium
Autosheet in Excel GPT-6.1 Sol · Medium
ChatGPT + Autosheet MCP GPT-6 · Medium
Autosheet in Sheets Haiku 5.5 · High
ChatGPT in Excel GPT-6 Astra · Medium
Claude in Excel Haiku 5.5 · High
Claude in Sheets Haiku 5.5 · High
Copilot in Excel Auto
ChatGPT + Drive MCP GPT-6 · Medium
ChatGPT in Excel GPT-6 Luna · High
Failed 6
Claude Code + Sheets MCP Opus 5.5 · Medium
Why it failed: The chart includes 'Stage' as an x-axis point, treats 'Ending cash' as an intermediate incremental step of +580,000, and fails to establish a proper bridge from starting cash to ending cash.
Claude Code + Autosheet MCP Opus 5.5 · Medium
Why it failed: The waterfall chart does not properly bridge starting cash to ending cash; it includes 'Stage' as a data category and adds 'Ending cash' as a movement instead of a final total.
Autosheet in Excel GPT-6 Luna · High
Why it failed: Ending cash is plotted as an addition rather than the closing balance of the bridge.
Gemini in Sheets Auto
Why it failed: The chart is placed across A1:H20, directly obscuring the source data table in A1:B7.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: No native waterfall chart was inserted into the workbook.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: No waterfall chart was created.