All AutosheetBench tasks

Compute pay with overtime

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in E2:G21 to calculate regular pay, overtime pay, and total pay. Regular hours are capped at 40, and additional hours pay 1.5 times the hourly rate.

Starting spreadsheet

Sheet1 · rows 1–21 of 22
ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering5245
3Priya SharmaSales3828.5
4DeShawn WilliamsOperations4532
5Anika PatelEngineering4048
6Tomasz KowalskiWarehouse5522.75
7Fatima Al-RashidSales3731
8Javier MoralesOperations4329.5
9Yuki TanakaEngineering6052
10Brianna JohnsonHR4035
11Rafael SantosWarehouse4821
12Ngozi OkonkwoSales3627.75
13Liam O'BrienEngineering5046.5
14Amara DialloOperations4030
15Svetlana IvanovaHR4238
16Kofi MensahWarehouse5820.5
17Mei-Ling ZhangSales3533
18David NakamuraEngineering4749
19Isabelle DupontOperations4428
20Tariq HassanWarehouse3923.25
21Rosa HernandezSales5126.5

A passing output

Autosheet in Excel · Opus 5.5
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering5245€1,800.00€810.00€2,610.00
3Priya SharmaSales3828.5€1,083.00€0.00€1,083.00
4DeShawn WilliamsOperations4532€1,280.00€240.00€1,520.00
5Anika PatelEngineering4048€1,920.00€0.00€1,920.00
6Tomasz KowalskiWarehouse5522.75€910.00€511.88€1,421.88
7Fatima Al-RashidSales3731€1,147.00€0.00€1,147.00
8Javier MoralesOperations4329.5€1,180.00€132.75€1,312.75
9Yuki TanakaEngineering6052€2,080.00€1,560.00€3,640.00
10Brianna JohnsonHR4035€1,400.00€0.00€1,400.00
11Rafael SantosWarehouse4821€840.00€252.00€1,092.00
12Ngozi OkonkwoSales3627.75€999.00€0.00€999.00
13Liam O'BrienEngineering5046.5€1,860.00€697.50€2,557.50
14Amara DialloOperations4030€1,200.00€0.00€1,200.00
15Svetlana IvanovaHR4238€1,520.00€114.00€1,634.00
16Kofi MensahWarehouse5820.5€820.00€553.50€1,373.50
17Mei-Ling ZhangSales3533€1,155.00€0.00€1,155.00
18David NakamuraEngineering4749€1,960.00€514.50€2,474.50
19Isabelle DupontOperations4428€1,120.00€168.00€1,288.00
20Tariq HassanWarehouse3923.25€906.75€0.00€906.75
21Rosa HernandezSales5126.5€1,060.00€437.25€1,497.25

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 automatically.
  • E2:G21 hold the expected values, from formulas

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed16s · 5¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering5245€1,800.00€810.00€2,610.00
3Priya SharmaSales3828.5€1,083.00€0.00€1,083.00
4DeShawn WilliamsOperations4532€1,280.00€240.00€1,520.00
5Anika PatelEngineering4048€1,920.00€0.00€1,920.00
6Tomasz KowalskiWarehouse5522.75€910.00€511.88€1,421.88
7Fatima Al-RashidSales3731€1,147.00€0.00€1,147.00
8Javier MoralesOperations4329.5€1,180.00€132.75€1,312.75
9Yuki TanakaEngineering6052€2,080.00€1,560.00€3,640.00
10Brianna JohnsonHR4035€1,400.00€0.00€1,400.00
11Rafael SantosWarehouse4821€840.00€252.00€1,092.00
12Ngozi OkonkwoSales3627.75€999.00€0.00€999.00
13Liam O'BrienEngineering5046.5€1,860.00€697.50€2,557.50
14Amara DialloOperations4030€1,200.00€0.00€1,200.00
15Svetlana IvanovaHR4238€1,520.00€114.00€1,634.00
16Kofi MensahWarehouse5820.5€820.00€553.50€1,373.50
17Mei-Ling ZhangSales3533€1,155.00€0.00€1,155.00
18David NakamuraEngineering4749€1,960.00€514.50€2,474.50
19Isabelle DupontOperations4428€1,120.00€168.00€1,288.00
20Tariq HassanWarehouse3923.25€906.75€0.00€906.75
21Rosa HernandezSales5126.5€1,060.00€437.25€1,497.25

Autosheet in Excel GPT-6 Astra · Low

Passed7s · 5¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

Autosheet in Sheets Opus 5.5 · Medium

Passed11s · 3¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering5245$1,800.00$810.00$2,610.00
3Priya SharmaSales3828.5$1,083.00$0.00$1,083.00
4DeShawn WilliamsOperations4532$1,280.00$240.00$1,520.00
5Anika PatelEngineering4048$1,920.00$0.00$1,920.00
6Tomasz KowalskiWarehouse5522.75$910.00$511.88$1,421.88
7Fatima Al-RashidSales3731$1,147.00$0.00$1,147.00
8Javier MoralesOperations4329.5$1,180.00$132.75$1,312.75
9Yuki TanakaEngineering6052$2,080.00$1,560.00$3,640.00
10Brianna JohnsonHR4035$1,400.00$0.00$1,400.00
11Rafael SantosWarehouse4821$840.00$252.00$1,092.00
12Ngozi OkonkwoSales3627.75$999.00$0.00$999.00
13Liam O'BrienEngineering5046.5$1,860.00$697.50$2,557.50
14Amara DialloOperations4030$1,200.00$0.00$1,200.00
15Svetlana IvanovaHR4238$1,520.00$114.00$1,634.00
16Kofi MensahWarehouse5820.5$820.00$553.50$1,373.50
17Mei-Ling ZhangSales3533$1,155.00$0.00$1,155.00
18David NakamuraEngineering4749$1,960.00$514.50$2,474.50
19Isabelle DupontOperations4428$1,120.00$168.00$1,288.00
20Tariq HassanWarehouse3923.25$906.75$0.00$906.75
21Rosa HernandezSales5126.5$1,060.00$437.25$1,497.25

Autosheet in Excel Sonnet 5.5 · Medium

Passed4s · 1¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

Claude in Excel Opus 5.5 · High

Passed14s · 15¢
Sheet164 cells changed

E2=MIN(C2,$J$1)*D2

ABCDEFGHIJ
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal PayRegular Hours Cap40
2Marcus ChenEngineering52451,800.00810.002,610.00Overtime Multiplier1.5x
3Priya SharmaSales3828.51,083.000.001,083.00
4DeShawn WilliamsOperations45321,280.00240.001,520.00
5Anika PatelEngineering40481,920.000.001,920.00
6Tomasz KowalskiWarehouse5522.75910.00511.881,421.88
7Fatima Al-RashidSales37311,147.000.001,147.00
8Javier MoralesOperations4329.51,180.00132.751,312.75
9Yuki TanakaEngineering60522,080.001,560.003,640.00
10Brianna JohnsonHR40351,400.000.001,400.00
11Rafael SantosWarehouse4821840.00252.001,092.00
12Ngozi OkonkwoSales3627.75999.000.00999.00
13Liam O'BrienEngineering5046.51,860.00697.502,557.50
14Amara DialloOperations40301,200.000.001,200.00
15Svetlana IvanovaHR42381,520.00114.001,634.00
16Kofi MensahWarehouse5820.5820.00553.501,373.50
17Mei-Ling ZhangSales35331,155.000.001,155.00
18David NakamuraEngineering47491,960.00514.502,474.50
19Isabelle DupontOperations44281,120.00168.001,288.00
20Tariq HassanWarehouse3923.25906.750.00906.75
21Rosa HernandezSales5126.51,060.00437.251,497.25

Autosheet in Excel Haiku 5.5 · High

Passed11s · 0.2¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

Claude in Sheets Opus 5.5 · Medium

Passed34s · 9¢
Sheet164 cells changed

E2=MIN(C2,$J$1)*D2

ABCDEFGHIJ
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal PayRegular Hours Cap40
2Marcus ChenEngineering5245$1,800.00$810.00$2,610.00Overtime Multiplier1.5x
3Priya SharmaSales3828.5$1,083.00$0.00$1,083.00
4DeShawn WilliamsOperations4532$1,280.00$240.00$1,520.00
5Anika PatelEngineering4048$1,920.00$0.00$1,920.00
6Tomasz KowalskiWarehouse5522.75$910.00$511.88$1,421.88
7Fatima Al-RashidSales3731$1,147.00$0.00$1,147.00
8Javier MoralesOperations4329.5$1,180.00$132.75$1,312.75
9Yuki TanakaEngineering6052$2,080.00$1,560.00$3,640.00
10Brianna JohnsonHR4035$1,400.00$0.00$1,400.00
11Rafael SantosWarehouse4821$840.00$252.00$1,092.00
12Ngozi OkonkwoSales3627.75$999.00$0.00$999.00
13Liam O'BrienEngineering5046.5$1,860.00$697.50$2,557.50
14Amara DialloOperations4030$1,200.00$0.00$1,200.00
15Svetlana IvanovaHR4238$1,520.00$114.00$1,634.00
16Kofi MensahWarehouse5820.5$820.00$553.50$1,373.50
17Mei-Ling ZhangSales3533$1,155.00$0.00$1,155.00
18David NakamuraEngineering4749$1,960.00$514.50$2,474.50
19Isabelle DupontOperations4428$1,120.00$168.00$1,288.00
20Tariq HassanWarehouse3923.25$906.75$0.00$906.75
21Rosa HernandezSales5126.5$1,060.00$437.25$1,497.25

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed30s · N/A
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

Autosheet in Excel GPT-6.1 Sol · Medium

Passed13s · 3¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed49s · N/A
Sheet160 cells changed

E2=IF(OR(C2="",D2=""),"",MIN(C2,40)*D2)

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering5245$1,800.00$810.00$2,610.00
3Priya SharmaSales3828.5$1,083.00$0.00$1,083.00
4DeShawn WilliamsOperations4532$1,280.00$240.00$1,520.00
5Anika PatelEngineering4048$1,920.00$0.00$1,920.00
6Tomasz KowalskiWarehouse5522.75$910.00$511.88$1,421.88
7Fatima Al-RashidSales3731$1,147.00$0.00$1,147.00
8Javier MoralesOperations4329.5$1,180.00$132.75$1,312.75
9Yuki TanakaEngineering6052$2,080.00$1,560.00$3,640.00
10Brianna JohnsonHR4035$1,400.00$0.00$1,400.00
11Rafael SantosWarehouse4821$840.00$252.00$1,092.00
12Ngozi OkonkwoSales3627.75$999.00$0.00$999.00
13Liam O'BrienEngineering5046.5$1,860.00$697.50$2,557.50
14Amara DialloOperations4030$1,200.00$0.00$1,200.00
15Svetlana IvanovaHR4238$1,520.00$114.00$1,634.00
16Kofi MensahWarehouse5820.5$820.00$553.50$1,373.50
17Mei-Ling ZhangSales3533$1,155.00$0.00$1,155.00
18David NakamuraEngineering4749$1,960.00$514.50$2,474.50
19Isabelle DupontOperations4428$1,120.00$168.00$1,288.00
20Tariq HassanWarehouse3923.25$906.75$0.00$906.75
21Rosa HernandezSales5126.5$1,060.00$437.25$1,497.25

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed29s · N/A
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

Autosheet in Sheets Haiku 5.5 · High

Passed13s · 0.3¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

ChatGPT in Excel GPT-6 Astra · Medium

Passed20s · 44¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

Claude in Excel Haiku 5.5 · High

Passed16s · 1¢
Sheet165 cells changed

E2=MIN(C2,$J$2)*D2

ABCDEFGHIJ
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal PayAssumptions
2Marcus ChenEngineering52451,800.00810.002,610.00Regular hours cap40
3Priya SharmaSales3828.51,083.000.001,083.00Overtime multiplier1.5
4DeShawn WilliamsOperations45321,280.00240.001,520.00
5Anika PatelEngineering40481,920.000.001,920.00
6Tomasz KowalskiWarehouse5522.75910.00511.881,421.88
7Fatima Al-RashidSales37311,147.000.001,147.00
8Javier MoralesOperations4329.51,180.00132.751,312.75
9Yuki TanakaEngineering60522,080.001,560.003,640.00
10Brianna JohnsonHR40351,400.000.001,400.00
11Rafael SantosWarehouse4821840.00252.001,092.00
12Ngozi OkonkwoSales3627.75999.000.00999.00
13Liam O'BrienEngineering5046.51,860.00697.502,557.50
14Amara DialloOperations40301,200.000.001,200.00
15Svetlana IvanovaHR42381,520.00114.001,634.00
16Kofi MensahWarehouse5820.5820.00553.501,373.50
17Mei-Ling ZhangSales35331,155.000.001,155.00
18David NakamuraEngineering47491,960.00514.502,474.50
19Isabelle DupontOperations44281,120.00168.001,288.00
20Tariq HassanWarehouse3923.25906.750.00906.75
21Rosa HernandezSales5126.51,060.00437.251,497.25

Claude in Sheets Haiku 5.5 · High

Passed28s · 1¢
Sheet165 cells changed

E2=MIN(C2,$J$2)*D2

ABCDEFGHIJ
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal PayAssumptions
2Marcus ChenEngineering5245$1,800.00$810.00$2,610.00Overtime threshold (hours/week)40
3Priya SharmaSales3828.5$1,083.00$0.00$1,083.00Overtime multiplier1.5x
4DeShawn WilliamsOperations4532$1,280.00$240.00$1,520.00
5Anika PatelEngineering4048$1,920.00$0.00$1,920.00
6Tomasz KowalskiWarehouse5522.75$910.00$511.88$1,421.88
7Fatima Al-RashidSales3731$1,147.00$0.00$1,147.00
8Javier MoralesOperations4329.5$1,180.00$132.75$1,312.75
9Yuki TanakaEngineering6052$2,080.00$1,560.00$3,640.00
10Brianna JohnsonHR4035$1,400.00$0.00$1,400.00
11Rafael SantosWarehouse4821$840.00$252.00$1,092.00
12Ngozi OkonkwoSales3627.75$999.00$0.00$999.00
13Liam O'BrienEngineering5046.5$1,860.00$697.50$2,557.50
14Amara DialloOperations4030$1,200.00$0.00$1,200.00
15Svetlana IvanovaHR4238$1,520.00$114.00$1,634.00
16Kofi MensahWarehouse5820.5$820.00$553.50$1,373.50
17Mei-Ling ZhangSales3533$1,155.00$0.00$1,155.00
18David NakamuraEngineering4749$1,960.00$514.50$2,474.50
19Isabelle DupontOperations4428$1,120.00$168.00$1,288.00
20Tariq HassanWarehouse3923.25$906.75$0.00$906.75
21Rosa HernandezSales5126.5$1,060.00$437.25$1,497.25

Autosheet in Excel GPT-6 Luna · High

Passed8s · 0.1¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

Copilot in Excel Auto

Passed31s · N/A
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering52€45.00€1,800.00€810.00€2,610.00
3Priya SharmaSales38€28.50€1,083.00€0.00€1,083.00
4DeShawn WilliamsOperations45€32.00€1,280.00€240.00€1,520.00
5Anika PatelEngineering40€48.00€1,920.00€0.00€1,920.00
6Tomasz KowalskiWarehouse55€22.75€910.00€511.88€1,421.88
7Fatima Al-RashidSales37€31.00€1,147.00€0.00€1,147.00
8Javier MoralesOperations43€29.50€1,180.00€132.75€1,312.75
9Yuki TanakaEngineering60€52.00€2,080.00€1,560.00€3,640.00
10Brianna JohnsonHR40€35.00€1,400.00€0.00€1,400.00
11Rafael SantosWarehouse48€21.00€840.00€252.00€1,092.00
12Ngozi OkonkwoSales36€27.75€999.00€0.00€999.00
13Liam O'BrienEngineering50€46.50€1,860.00€697.50€2,557.50
14Amara DialloOperations40€30.00€1,200.00€0.00€1,200.00
15Svetlana IvanovaHR42€38.00€1,520.00€114.00€1,634.00
16Kofi MensahWarehouse58€20.50€820.00€553.50€1,373.50
17Mei-Ling ZhangSales35€33.00€1,155.00€0.00€1,155.00
18David NakamuraEngineering47€49.00€1,960.00€514.50€2,474.50
19Isabelle DupontOperations44€28.00€1,120.00€168.00€1,288.00
20Tariq HassanWarehouse39€23.25€906.75€0.00€906.75
21Rosa HernandezSales51€26.50€1,060.00€437.25€1,497.25

ChatGPT + Drive MCP GPT-6 · Medium

Passed30s · N/A
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

ChatGPT in Excel GPT-6 Luna · High

Passed22s · 0.4¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

Gemini in Sheets Auto

Passed1m 46s · N/A
Sheet160 cells changed

E2=MIN(C2, 40) * D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

ChatGPT in Sheets GPT-6 Astra · Medium

Passed20s · 35¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25

ChatGPT in Sheets GPT-6 Luna · High

Passed29s · 0.4¢
Sheet160 cells changed

E2=MIN(C2,40)*D2

ABCDEFG
1EmployeeDepartmentHours WorkedHourly RateRegular PayOvertime PayTotal Pay
2Marcus ChenEngineering524518008102610
3Priya SharmaSales3828.5108301083
4DeShawn WilliamsOperations453212802401520
5Anika PatelEngineering4048192001920
6Tomasz KowalskiWarehouse5522.75910511.8751421.875
7Fatima Al-RashidSales3731114701147
8Javier MoralesOperations4329.51180132.751312.75
9Yuki TanakaEngineering6052208015603640
10Brianna JohnsonHR4035140001400
11Rafael SantosWarehouse48218402521092
12Ngozi OkonkwoSales3627.759990999
13Liam O'BrienEngineering5046.51860697.52557.5
14Amara DialloOperations4030120001200
15Svetlana IvanovaHR423815201141634
16Kofi MensahWarehouse5820.5820553.51373.5
17Mei-Ling ZhangSales3533115501155
18David NakamuraEngineering47491960514.52474.5
19Isabelle DupontOperations442811201681288
20Tariq HassanWarehouse3923.25906.750906.75
21Rosa HernandezSales5126.51060437.251497.25