Compute each row's share of the total
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Use formulas in H2:H8 to calculate each row's Revenue as a share of total Revenue.
Starting spreadsheet
Orders| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | ||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
A passing output
Autosheet in Excel · Opus 5.5H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
Excel and Sheets · All types · All models · All outputs
Pass criteria
All must be met, checked automatically.H2:H8hold the expected values, from formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
Passed13s · 3¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
Autosheet in Excel GPT-6 Astra · Low
Passed11s · 7¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.22% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.15% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.67% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.06% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.30% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.49% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.11% |
Autosheet in Sheets Opus 5.5 · Medium
Passed11s · 3¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
Autosheet in Excel Sonnet 5.5 · Medium
Passed9s · 2¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
Claude in Excel Opus 5.5 · High
Passed9s · 6¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
Autosheet in Excel Haiku 5.5 · High
Passed8s · 0.1¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.22% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.15% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.67% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.06% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.30% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.49% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.11% |
Claude in Sheets Opus 5.5 · Medium
Passed30s · 7¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
Claude Code + Sheets MCP Opus 5.5 · Medium
Passed27s · N/A
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
Autosheet in Excel GPT-6.1 Sol · Medium
Passed16s · 2¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.22% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.15% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.67% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.06% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.30% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.49% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.11% |
Claude Code + Autosheet MCP Opus 5.5 · Medium
Passed49s · N/A
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.22% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.15% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.67% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.06% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.30% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.49% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.11% |
ChatGPT + Autosheet MCP GPT-6 · Medium
Passed48s · N/A
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.22% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.15% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.67% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.06% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.30% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.49% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.11% |
Autosheet in Sheets Haiku 5.5 · High
Passed17s · 0.1¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.22% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.15% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.67% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.06% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.30% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.49% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.11% |
ChatGPT in Excel GPT-6 Astra · Medium
Passed19s · 41¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
Claude in Excel Haiku 5.5 · High
Passed7s · 0.3¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
Claude in Sheets Haiku 5.5 · High
Passed23s · 0.4¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
Autosheet in Excel GPT-6 Luna · High
Passed9s · 0.1¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 0.142222222 | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 0.081481481 | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 0.186666667 | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 0.110617284 | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 0.162962963 | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 0.244938272 | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 0.071111111 |
Copilot in Excel Auto
Passed17s · N/A
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.22% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.15% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.67% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.06% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.30% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.49% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.11% |
ChatGPT + Drive MCP GPT-6 · Medium
Passed32s · N/A
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.22% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.15% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.67% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.06% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.30% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.49% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.11% |
ChatGPT in Excel GPT-6 Luna · High
Passed17s · 0.4¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 0.142222222 | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 0.081481481 | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 0.186666667 | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 0.110617284 | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 0.162962963 | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 0.244938272 | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 0.071111111 |
Gemini in Sheets Auto
Passed52s · N/A
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
ChatGPT in Sheets GPT-6 Astra · Medium
Passed22s · 33¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 14.2% | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 8.1% | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 18.7% | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 11.1% | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 16.3% | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 24.5% | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 7.1% |
ChatGPT in Sheets GPT-6 Luna · High
Passed21s · 0.3¢
H2=F2/SUM($F$2:$F$8)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 0.142222222 | |
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | 0.081481481 | |
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | 0.186666667 | |
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | 0.110617284 | |
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | 0.162962963 | |
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | 0.244938272 | |
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 | 0.071111111 |