All AutosheetBench tasks

Total the committed capital

FormulasEasyLLM judge scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

In the investors table, what's the total committed capital?

Starting spreadsheet

Analysis
ABCDEFGHI
1ProductSalesCalculationTotalCountryCommitted CapitalLookup ProductLookup Value
2Alpha10Germany1250000Alpha100
3Bravo48199638France2500000Bravo200
4Charlie250Germany1750000Charlie300
5Delta900#DIV/0!5000Germany500000Delta400
6Echo1200Spain900000Echo500
7Foxtrot775#DIV/0!Italy650000

A passing output

Autosheet in Excel · Opus 5.5
Transcript excerptExpected answer
The total committed capital is 7,550,000. That's the sum of F2:F7: Product Country Committed Capital Alpha Germany 1,250,000 Bravo France 2,500,000 Charlie 1,750,000 Delta 500,000 Echo Spain 900,000 Foxtrot Italy 650,000 Total 7,550,000 This sheet has no table called "investors," so I used the Committed Capital column (F) in the main table (A1:F7), which I assume is what you meant. I didn't change the sheet. If you want the total in a cell, you could use this formula: =SUM(F2:F7)

How each AI configuration did

22 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked by an LLM judge.
  • Answers $7,550,000

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed12s · 3¢
Transcript excerptExpected answer
The total committed capital is 7,550,000. That's the sum of F2:F7: Product Country Committed Capital Alpha Germany 1,250,000 Bravo France 2,500,000 Charlie 1,750,000 Delta 500,000 Echo Spain 900,000 Foxtrot Italy 650,000 Total 7,550,000 This sheet has no table called "investors," so I used the Committed Capital column (F) in the main table (A1:F7), which I assume is what you meant. I didn't change the sheet. If you want the total in a cell, you could use this formula: =SUM(F2:F7)

Autosheet in Excel GPT-6 Astra · Low

Passed7s · 6¢
Transcript excerptExpected answer
I’ll add a total for the Committed Capital amounts and check the result. Format and verify committed capital total The total committed capital is 7,550,000. Added the total in Analysis!K2.

Autosheet in Sheets Opus 5.5 · Medium

Passed10s · 2¢
Transcript excerptExpected answer
The total committed capital is 7,550,000. That's the sum of the six investors in F2:F7: | Country | Committed Capital | |---|---| | Germany | 1,250,000 | | France | 2,500,000 | | Germany | 1,750,000 | | Germany | 500,000 | | Spain | 900,000 | | Italy | 650,000 | To keep a live total in the sheet, you could put this in a cell: Formula =SUM(F2:F7)

Autosheet in Excel Sonnet 5.5 · Medium

Passed6s · 1¢
Transcript excerptExpected answer
The total committed capital is 7,550,000. That's the sum of F2:F7, and I added it in F8 with a "Total" label in E8. The sheet has no table named "investors", so I used the Committed Capital column in the main table.

Claude in Excel Opus 5.5 · High

Passed6s · 4¢
Transcript excerptExpected answer
The total committed capital is 7,550,000, from F2:F7. The sheet has no table called "investors", so I used the Committed Capital column in F1:F7. The rows in that block are labelled with product names (Alpha to Foxtrot) rather than investor names, so check this is the data you meant. Country Committed Capital Germany (3 rows) 3,500,000 France 2,500,000 Spain 900,000 Italy 650,000 Total 7,550,000 I didn't change the workbook. If you want the total in the sheet, I can add =SUM(F2:F7) in F8. There are also errors in other columns on this sheet. C5 and D7 show #DIV/0!, and C7 shows #N/A because Foxtrot isn't in the lookup list. None of these affect the committed capital total.

Autosheet in Excel Haiku 5.5 · High

Passed7s · 0.1¢
Transcript excerptExpected answer
The total committed capital is 7,550,000. This is the sum of the Committed Capital column ( Analysis!F2:F7), which is the only investor-related data on the sheet. I didn't change the sheet.

Claude in Sheets Opus 5.5 · Medium

Passed11s · 4¢
Transcript excerptExpected answer
Total committed capital is $7,550,000. That's the sum of F2:F7. There's no table called "investors" in this workbook. The only committed-capital figures are in the "Committed Capital" column on the Analysis sheet, and those rows are labelled by product (Alpha through Foxtrot) and country, not by investor. If you meant a different table, tell me where it is. By country: - Germany: $3.5M (Alpha, Charlie, Delta) - France: $2.5M - Spain: $0.9M - Italy: $0.65M I didn't change the sheet. I can add a =SUM(F2:F7) total below the column if you'd like.

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed24s · N/A
Transcript excerptExpected answer
The total committed capital is 7,550,000. The spreadsheet has only one tab, "Analysis", and no table actually named "investors". I took the "Committed Capital" column (F2:F7) as the table you meant: Row Country Committed Capital Alpha Germany 1,250,000 Bravo France 2,500,000 Charlie Germany 1,750,000 Delta Germany 500,000 Echo Spain 900,000 Foxtrot Italy 650,000 Total 7,550,000 Total 7,550,000 The rows are labelled with product names (Alpha, Bravo…), not investor names, and the sheet doesn't show a currency. The sum is just the six values added together. I didn't change anything in the sheet. Some other columns contain #DIV/0! and #N/A errors, but none of them are in Committed Capital, so they don't affect this total.

Autosheet in Excel GPT-6.1 Sol · Medium

Passed10s · 2¢
Transcript excerptExpected answer
I’ll total the Committed Capital amounts in Analysis and add a labeled summary beside the data. Format and verify total committed capital The total committed capital is 7,550,000. I added the total in Analysis!K2.

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed56s · N/A
Transcript excerptExpected answer
The agent read only the Analysis tab, so I'll have it check the other tabs before I trust "there's no investors table." The total committed capital is 7,550,000. I didn't change anything in the spreadsheet. It's the sum of the "Committed Capital" column, Analysis!F2:F7: Row Committed Capital Alpha 1,250,000 Bravo 2,500,000 Charlie 1,750,000 Delta 500,000 Echo 900,000 Foxtrot 650,000 Total 7,550,000 Total 7,550,000 It isn't really an investors table. The spreadsheet has one tab, Analysis, and this column is the only committed capital data in it. The rows are named Alpha to Foxtrot, not after investors, and the table also holds product/sales test columns. If your investors table lives in another file, send me the link and I'll total that. No currency is given. The second check reported "$7,550,000", but nothing in the sheet names a currency. Number vs. text is unconfirmed. The first check said all six values are real numbers. The second said it couldn't tell. If any were stored as text, a =SUM(F2:F7) in the sheet would come out short. The 7,550,000 above is the six values added together. There are errors in other columns, outside the total: #DIV/0! in C5 and D7, #N/A in C7, and the "Total" formulas in column D add up the wrong rows. I can fix these if you want.

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed22s · N/A
Transcript excerptExpected answer
TOTAL COMMITTED CAPITAL 7,550,000 Across 6 records in the spreadsheet. I summed the Committed Capital column in Analysis!F2:F7. Note: The spreadsheet does not specify a currency. The records are labeled Alpha through Foxtrot under a "Product" header, rather than explicitly as investors. No changes were made to the spreadsheet.

Autosheet in Sheets Haiku 5.5 · High

Passed12s · 0.1¢
Transcript excerptExpected answer
The total committed capital is 7,550,000. This comes from the Committed Capital column ('Analysis'!F2:F7), which I'm treating as the investors table. You can get the same result with: Formula =SUM(F2:F7)

ChatGPT in Excel GPT-6 Astra · Medium

Passed11s · 37¢
Transcript excerptExpected answer
Total committed capital is 7,550,000 (7.55 million). No currency is specified. (Analysis!F2:F7)

Claude in Excel Haiku 5.5 · High

Passed6s · 0.2¢
Transcript excerptExpected answer
The workbook has no investors table. It has one sheet, Analysis, and the closest match is the Committed Capital column in F1:F7, which sits beside a Country column. Summing F2:F7 gives a total committed capital of $7,550,000. If that column is the one you meant, I can add a =SUM(F2:F7) total to the sheet. I haven't changed anything yet.

Claude in Sheets Haiku 5.5 · High

Passed12s · 0.2¢
Transcript excerptExpected answer
The total committed capital is 7,550,000. There's no table labeled "investors" in this workbook. The closest match is the Committed Capital column in F2:F7 on the Analysis sheet, and I summed those six values by hand. I haven't added a formula to the sheet. If you'd like a live total, I can put =SUM(F2:F7) in a cell.

Autosheet in Excel GPT-6 Luna · High

Passed6s · 0.1¢
Transcript excerptExpected answer
I’ll check the full committed-capital values in the investors table and total them. The total committed capital is 7,550,000.

Copilot in Excel Auto

Passed12s · N/A
Transcript excerptExpected answer
The total committed capital is $7,550,000, from Analysis!F2:F7. The total committed capital is $7,550,000, from Analysis!F2:F7.

ChatGPT + Drive MCP GPT-6 · Medium

Passed17s · N/A
Transcript excerptExpected answer
The total committed capital is 7,550,000 (7.55 million), summed across 6 entries in the Committed Capital column (Analysis!F2:F7). Source: Google Spreadsheet The spreadsheet was not modified.

ChatGPT in Excel GPT-6 Luna · High

Passed10s · 0.3¢
Transcript excerptExpected answer
Total committed capital is $7,550,000 across the investors listed in the table. (Analysis!F2:F7)

Gemini in Sheets Auto

Passed15s · N/A
Transcript excerptExpected answer
The total committed capital is 7,550,000. Supporting Records This total is calculated from the following 6 entries in the table: Germany (Alpha): 1,250,000 France (Bravo): 2,500,000 Germany (Charlie): 1,750,000 Germany (Delta): 500,000 Spain (Echo): 900,000 Italy (Foxtrot): 650,000 Assumption: It is assumed that the data range containing the Country and Committed Capital columns represents the investors table.

ChatGPT in Sheets GPT-6 Astra · Medium

Passed21s · 30¢
Transcript excerptExpected answer
I’ll check the investors table and total committed capital. Thought for a few seconds Total committed capital is 7,550,000 (7.55 million). No currency is specified in the table. AnalysisF2:F7

ChatGPT in Sheets GPT-6 Luna · High

Passed13s · 0.3¢
Transcript excerptExpected answer
Total committed capital is $7,550,000 across the six investors. AnalysisF2:F7