Show a column as percentages
FormattingEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Show the margin column as percentages with one decimal place.
Starting spreadsheet
Products| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Revenue | Cost | Margin |
| 2 | Atlas | 125000 | 81000 | 0.352 |
| 3 | Beacon | 98000 | 69000 | 0.295918 |
| 4 | Comet | 154000 | 94000 | 0.38961 |
| 5 | Delta | 72000 | 55000 | 0.236111 |
Expected result
Excel and Sheets · All types · All models · All outputs
Pass criteria
All must be met, checked automatically.D2:D5use the number format0.0%
Passed 22
Autosheet in Excel Opus 5.5 · Medium
Passed6s · 2¢
Autosheet in Excel GPT-6 Astra · Low
Passed5s · 4¢
Autosheet in Sheets Opus 5.5 · Medium
Passed7s · 2¢
Autosheet in Excel Sonnet 5.5 · Medium
Passed3s · 0.8¢
Claude in Excel Opus 5.5 · High
Passed8s · 6¢
Autosheet in Excel Haiku 5.5 · High
Passed5s · 0.1¢
Claude in Sheets Opus 5.5 · Medium
Passed14s · 3¢
Claude Code + Sheets MCP Opus 5.5 · Medium
Passed28s · N/A
Autosheet in Excel GPT-6.1 Sol · Medium
Passed8s · 0.9¢
Claude Code + Autosheet MCP Opus 5.5 · Medium
Passed25s · N/A
ChatGPT + Autosheet MCP GPT-6 · Medium
Passed24s · N/A
Autosheet in Sheets Haiku 5.5 · High
Passed15s · 0.1¢
ChatGPT in Excel GPT-6 Astra · Medium
Passed19s · 39¢
Claude in Excel Haiku 5.5 · High
Passed6s · 0.3¢
Claude in Sheets Haiku 5.5 · High
Passed19s · 0.4¢
Autosheet in Excel GPT-6 Luna · High
Passed6s · 0.1¢
Copilot in Excel Auto
Passed15s · N/A
ChatGPT + Drive MCP GPT-6 · Medium
Passed38s · N/A
ChatGPT in Excel GPT-6 Luna · High
Passed21s · 0.4¢
Gemini in Sheets Auto
Passed38s · N/A
ChatGPT in Sheets GPT-6 Astra · Medium
Passed18s · 31¢
ChatGPT in Sheets GPT-6 Luna · High
Passed18s · 0.3¢