All AutosheetBench tasks

Look up supplier rates and totals

FormulasEasyDeterministic scoringLatest run

Passed by 11 of 12 products on their best model. Failed: Gemini in Sheets.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in E2:E21 to match each unit cost from the rate card.

Use formulas in F2:F21 to calculate total cost, and show N/A in both columns when a supplier-material combination is missing from the rate card.

PurchaseOrders

Starting sheet · rows 1–21 of 22
ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet200
3PO-3002Granite Supply CoConcrete Mix500
4PO-3003Apex MaterialsAluminum Bar150
5PO-3004Pacific TimberOak Plank80
6PO-3005Granite Supply CoRebar300
7PO-3006Apex MaterialsSteel Sheet120
8PO-3007Pacific TimberPine Board250
9PO-3008Granite Supply CoConcrete Mix400
10PO-3009Apex MaterialsCarbon Fiber50
11PO-3010Pacific TimberOak Plank90
12PO-3011Granite Supply CoRebar180
13PO-3012Apex MaterialsAluminum Bar200
14PO-3013Pacific TimberBamboo Panel60
15PO-3014Granite Supply CoLimestone Block100
16PO-3015Apex MaterialsSteel Sheet300
17PO-3016Pacific TimberPine Board175
18PO-3017Granite Supply CoConcrete Mix250
19PO-3018Apex MaterialsCarbon Fiber35
20PO-3019Pacific TimberBamboo Panel80
21PO-3020Granite Supply CoRebar220

RateCard

Starting sheet
ABC
1SupplierNameMaterialUnitRate
2Apex MaterialsSteel Sheet4.8
3Apex MaterialsAluminum Bar7.25
4Granite Supply CoConcrete Mix0.95
5Granite Supply CoRebar1.3
6Pacific TimberOak Plank12.5
7Pacific TimberPine Board8.75
8Pacific TimberBamboo Panel6.4
9Granite Supply CoSand Aggregate0.55

A passing output

Autosheet in Excel · Opus 5.5
PurchaseOrders40 cells changed

E2=XLOOKUP(1, (RateCard!$A$2:$A$10=B2) * (RateCard!$B$2:$B$10=C2), RateCard!$C$2:$C$10, "N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

How each AI configuration did

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

Pass criteria

All must be met, checked automatically.
  • PurchaseOrders!E2:F21 hold the expected values, from formulas

Passed 21

Autosheet in Excel Opus 5.5 · Medium

Passed41s · 15¢
PurchaseOrders40 cells changed

E2=XLOOKUP(1, (RateCard!$A$2:$A$10=B2) * (RateCard!$B$2:$B$10=C2), RateCard!$C$2:$C$10, "N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

Autosheet in Excel GPT-6 Astra · Low

Passed26s · 22¢
PurchaseOrders40 cells changed

E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960.00
3PO-3002Granite Supply CoConcrete Mix5000.95475.00
4PO-3003Apex MaterialsAluminum Bar1507.251087.50
5PO-3004Pacific TimberOak Plank8012.51000.00
6PO-3005Granite Supply CoRebar3001.3390.00
7PO-3006Apex MaterialsSteel Sheet1204.8576.00
8PO-3007Pacific TimberPine Board2508.752187.50
9PO-3008Granite Supply CoConcrete Mix4000.95380.00
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125.00
12PO-3011Granite Supply CoRebar1801.3234.00
13PO-3012Apex MaterialsAluminum Bar2007.251450.00
14PO-3013Pacific TimberBamboo Panel606.4384.00
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440.00
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.50
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512.00
21PO-3020Granite Supply CoRebar2201.3286.00

Autosheet in Sheets Opus 5.5 · Medium

Passed47s · 23¢
PurchaseOrders40 cells changed

E2=XLOOKUP(B2&"|"&C2, RateCard!$A$2:$A$9&"|"&RateCard!$B$2:$B$9, RateCard!$C$2:$C$9, "N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet200$4.80$960.00
3PO-3002Granite Supply CoConcrete Mix500$0.95$475.00
4PO-3003Apex MaterialsAluminum Bar150$7.25$1,087.50
5PO-3004Pacific TimberOak Plank80$12.50$1,000.00
6PO-3005Granite Supply CoRebar300$1.30$390.00
7PO-3006Apex MaterialsSteel Sheet120$4.80$576.00
8PO-3007Pacific TimberPine Board250$8.75$2,187.50
9PO-3008Granite Supply CoConcrete Mix400$0.95$380.00
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank90$12.50$1,125.00
12PO-3011Granite Supply CoRebar180$1.30$234.00
13PO-3012Apex MaterialsAluminum Bar200$7.25$1,450.00
14PO-3013Pacific TimberBamboo Panel60$6.40$384.00
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet300$4.80$1,440.00
17PO-3016Pacific TimberPine Board175$8.75$1,531.25
18PO-3017Granite Supply CoConcrete Mix250$0.95$237.50
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel80$6.40$512.00
21PO-3020Granite Supply CoRebar220$1.30$286.00

Autosheet in Excel Sonnet 5.5 · Medium

Passed16s · 6¢
PurchaseOrders40 cells changed

E2=XLOOKUP(B2&"|"&C2,RateCard!$A$2:$A$10&"|"&RateCard!$B$2:$B$10,RateCard!$C$2:$C$10,"N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

Claude in Excel Opus 5.5 · High

Passed25s · 25¢
PurchaseOrders40 cells changed

E2=XLOOKUP(1,(RateCard!$A$2:$A$100=B2)*(RateCard!$B$2:$B$100=C2),RateCard!$C$2:$C$100,"N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.80960.00
3PO-3002Granite Supply CoConcrete Mix5000.95475.00
4PO-3003Apex MaterialsAluminum Bar1507.251,087.50
5PO-3004Pacific TimberOak Plank8012.501,000.00
6PO-3005Granite Supply CoRebar3001.30390.00
7PO-3006Apex MaterialsSteel Sheet1204.80576.00
8PO-3007Pacific TimberPine Board2508.752,187.50
9PO-3008Granite Supply CoConcrete Mix4000.95380.00
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.501,125.00
12PO-3011Granite Supply CoRebar1801.30234.00
13PO-3012Apex MaterialsAluminum Bar2007.251,450.00
14PO-3013Pacific TimberBamboo Panel606.40384.00
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.801,440.00
17PO-3016Pacific TimberPine Board1758.751,531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.50
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.40512.00
21PO-3020Granite Supply CoRebar2201.30286.00

Autosheet in Excel Haiku 5.5 · High

Passed23s · 0.6¢
PurchaseOrders40 cells changed

E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

Claude in Sheets Opus 5.5 · Medium

Passed59s · 15¢
PurchaseOrders40 cells changed

E2=XLOOKUP($B2&"|"&$C2, RateCard!$A$2:$A$9&"|"&RateCard!$B$2:$B$9, RateCard!$C$2:$C$9, "N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet200$4.80$960.00
3PO-3002Granite Supply CoConcrete Mix500$0.95$475.00
4PO-3003Apex MaterialsAluminum Bar150$7.25$1,087.50
5PO-3004Pacific TimberOak Plank80$12.50$1,000.00
6PO-3005Granite Supply CoRebar300$1.30$390.00
7PO-3006Apex MaterialsSteel Sheet120$4.80$576.00
8PO-3007Pacific TimberPine Board250$8.75$2,187.50
9PO-3008Granite Supply CoConcrete Mix400$0.95$380.00
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank90$12.50$1,125.00
12PO-3011Granite Supply CoRebar180$1.30$234.00
13PO-3012Apex MaterialsAluminum Bar200$7.25$1,450.00
14PO-3013Pacific TimberBamboo Panel60$6.40$384.00
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet300$4.80$1,440.00
17PO-3016Pacific TimberPine Board175$8.75$1,531.25
18PO-3017Granite Supply CoConcrete Mix250$0.95$237.50
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel80$6.40$512.00
21PO-3020Granite Supply CoRebar220$1.30$286.00

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed1m 41s · N/A
PurchaseOrders40 cells changed

E2=IFNA(INDEX(RateCard!$C$2:$C1000, MATCH(1, INDEX((RateCard!$A$2:$A1000=B2)*(RateCard!$B$2:$B1000=C2), 0), 0)), "N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

Autosheet in Excel GPT-6.1 Sol · Medium

Passed33s · 7¢
PurchaseOrders40 cells changed

E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960.00
3PO-3002Granite Supply CoConcrete Mix5000.95475.00
4PO-3003Apex MaterialsAluminum Bar1507.251087.50
5PO-3004Pacific TimberOak Plank8012.51000.00
6PO-3005Granite Supply CoRebar3001.3390.00
7PO-3006Apex MaterialsSteel Sheet1204.8576.00
8PO-3007Pacific TimberPine Board2508.752187.50
9PO-3008Granite Supply CoConcrete Mix4000.95380.00
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125.00
12PO-3011Granite Supply CoRebar1801.3234.00
13PO-3012Apex MaterialsAluminum Bar2007.251450.00
14PO-3013Pacific TimberBamboo Panel606.4384.00
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440.00
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.50
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512.00
21PO-3020Granite Supply CoRebar2201.3286.00

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed1m 39s · N/A
PurchaseOrders40 cells changed

E2=XLOOKUP(LOWER(TRIM(B2))&"|"&LOWER(TRIM(C2)), LOWER(TRIM(RateCard!$A$2:$A1000))&"|"&LOWER(TRIM(RateCard!$B$2:$B1000)), RateCard!$C$2:$C1000, "N/A", 0)

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet200$4.80$960.00
3PO-3002Granite Supply CoConcrete Mix500$0.95$475.00
4PO-3003Apex MaterialsAluminum Bar150$7.25$1,087.50
5PO-3004Pacific TimberOak Plank80$12.50$1,000.00
6PO-3005Granite Supply CoRebar300$1.30$390.00
7PO-3006Apex MaterialsSteel Sheet120$4.80$576.00
8PO-3007Pacific TimberPine Board250$8.75$2,187.50
9PO-3008Granite Supply CoConcrete Mix400$0.95$380.00
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank90$12.50$1,125.00
12PO-3011Granite Supply CoRebar180$1.30$234.00
13PO-3012Apex MaterialsAluminum Bar200$7.25$1,450.00
14PO-3013Pacific TimberBamboo Panel60$6.40$384.00
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet300$4.80$1,440.00
17PO-3016Pacific TimberPine Board175$8.75$1,531.25
18PO-3017Granite Supply CoConcrete Mix250$0.95$237.50
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel80$6.40$512.00
21PO-3020Granite Supply CoRebar220$1.30$286.00

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed1m 14s · N/A
PurchaseOrders40 cells changed

E2=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(INDEX(FILTER(RateCard!$C$2:$C1000, RateCard!$A$2:$A1000=B2, RateCard!$B$2:$B1000=C2), 1), ""N/A"")"),4.8)

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

Autosheet in Sheets Haiku 5.5 · High

Passed40s · 0.4¢
PurchaseOrders40 cells changed

E2=IF(COUNTIFS(RateCard!$A$2:$A$1000,B2,RateCard!$B$2:$B$1000,C2)=0,"N/A",SUMIFS(RateCard!$C$2:$C$1000,RateCard!$A$2:$A$1000,B2,RateCard!$B$2:$B$1000,C2))

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

ChatGPT in Excel GPT-6 Astra · Medium

Passed32s · 88¢
PurchaseOrders40 cells changed

E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

Claude in Excel Haiku 5.5 · High

Passed28s · 1¢
PurchaseOrders40 cells changed

E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.80960.00
3PO-3002Granite Supply CoConcrete Mix5000.95475.00
4PO-3003Apex MaterialsAluminum Bar1507.251,087.50
5PO-3004Pacific TimberOak Plank8012.501,000.00
6PO-3005Granite Supply CoRebar3001.30390.00
7PO-3006Apex MaterialsSteel Sheet1204.80576.00
8PO-3007Pacific TimberPine Board2508.752,187.50
9PO-3008Granite Supply CoConcrete Mix4000.95380.00
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.501,125.00
12PO-3011Granite Supply CoRebar1801.30234.00
13PO-3012Apex MaterialsAluminum Bar2007.251,450.00
14PO-3013Pacific TimberBamboo Panel606.40384.00
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.801,440.00
17PO-3016Pacific TimberPine Board1758.751,531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.50
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.40512.00
21PO-3020Granite Supply CoRebar2201.30286.00

Claude in Sheets Haiku 5.5 · High

Passed53s · 0.9¢
PurchaseOrders40 cells changed

E2=IF(COUNTIFS(RateCard!$A$2:$A$9,$B2,RateCard!$B$2:$B$9,$C2)=0,"N/A",SUMIFS(RateCard!$C$2:$C$9,RateCard!$A$2:$A$9,$B2,RateCard!$B$2:$B$9,$C2))

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

Autosheet in Excel GPT-6 Luna · High

Passed39s · 0.9¢
PurchaseOrders40 cells changed

E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

Copilot in Excel Auto

Passed40s · N/A
PurchaseOrders40 cells changed

E2=IFNA(XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9),"N/A")

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet200€4.80€960.00
3PO-3002Granite Supply CoConcrete Mix500€0.95€475.00
4PO-3003Apex MaterialsAluminum Bar150€7.25€1,087.50
5PO-3004Pacific TimberOak Plank80€12.50€1,000.00
6PO-3005Granite Supply CoRebar300€1.30€390.00
7PO-3006Apex MaterialsSteel Sheet120€4.80€576.00
8PO-3007Pacific TimberPine Board250€8.75€2,187.50
9PO-3008Granite Supply CoConcrete Mix400€0.95€380.00
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank90€12.50€1,125.00
12PO-3011Granite Supply CoRebar180€1.30€234.00
13PO-3012Apex MaterialsAluminum Bar200€7.25€1,450.00
14PO-3013Pacific TimberBamboo Panel60€6.40€384.00
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet300€4.80€1,440.00
17PO-3016Pacific TimberPine Board175€8.75€1,531.25
18PO-3017Granite Supply CoConcrete Mix250€0.95€237.50
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel80€6.40€512.00
21PO-3020Granite Supply CoRebar220€1.30€286.00

ChatGPT + Drive MCP GPT-6 · Medium

Passed53s · N/A
PurchaseOrders40 cells changed

E2=IFERROR(__xludf.DUMMYFUNCTION("IFNA(INDEX(FILTER(RateCard!$C$2:$C$9,RateCard!$A$2:$A$9=B2,RateCard!$B$2:$B$9=C2),1),""N/A"")"),4.8)

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

ChatGPT in Excel GPT-6 Luna · High

Passed52s · 1¢
PurchaseOrders40 cells changed

E2=IF(COUNTIFS(RateCard!$A$2:$A$10,B2,RateCard!$B$2:$B$10,C2)=0,"N/A",SUMIFS(RateCard!$C$2:$C$10,RateCard!$A$2:$A$10,B2,RateCard!$B$2:$B$10,C2))

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

ChatGPT in Sheets GPT-6 Astra · Medium

Passed1m 7s · 97¢
PurchaseOrders40 cells changed

E2=IF(COUNTIFS(RateCard!$A$2:$A$9,B2,RateCard!$B$2:$B$9,C2)=0,"N/A",SUMIFS(RateCard!$C$2:$C$9,RateCard!$A$2:$A$9,B2,RateCard!$B$2:$B$9,C2))

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

ChatGPT in Sheets GPT-6 Luna · High

Passed1m 12s · 1¢
PurchaseOrders40 cells changed

E2=IF(COUNTIFS(RateCard!$A$2:$A$9,B2,RateCard!$B$2:$B$9,C2)=0,"N/A",SUMIFS(RateCard!$C$2:$C$9,RateCard!$A$2:$A$9,B2,RateCard!$B$2:$B$9,C2))

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet2004.8960
3PO-3002Granite Supply CoConcrete Mix5000.95475
4PO-3003Apex MaterialsAluminum Bar1507.251087.5
5PO-3004Pacific TimberOak Plank8012.51000
6PO-3005Granite Supply CoRebar3001.3390
7PO-3006Apex MaterialsSteel Sheet1204.8576
8PO-3007Pacific TimberPine Board2508.752187.5
9PO-3008Granite Supply CoConcrete Mix4000.95380
10PO-3009Apex MaterialsCarbon Fiber50N/AN/A
11PO-3010Pacific TimberOak Plank9012.51125
12PO-3011Granite Supply CoRebar1801.3234
13PO-3012Apex MaterialsAluminum Bar2007.251450
14PO-3013Pacific TimberBamboo Panel606.4384
15PO-3014Granite Supply CoLimestone Block100N/AN/A
16PO-3015Apex MaterialsSteel Sheet3004.81440
17PO-3016Pacific TimberPine Board1758.751531.25
18PO-3017Granite Supply CoConcrete Mix2500.95237.5
19PO-3018Apex MaterialsCarbon Fiber35N/AN/A
20PO-3019Pacific TimberBamboo Panel806.4512
21PO-3020Granite Supply CoRebar2201.3286

Failed 1

Gemini in Sheets Auto

Failed5m · N/A
PurchaseOrders20 cells changedWrong or missing value

E2=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(FILTER(RateCard!$C$2:$C$9, RateCard!$A$2:$A$9=B2, RateCard!$B$2:$B$9=C2), """")"),4.8)

ABCDEF
1OrderIDSupplierNameMaterialQuantityUnitCostTotalCost
2PO-3001Apex MaterialsSteel Sheet200$4.80
3PO-3002Granite Supply CoConcrete Mix500$0.95
4PO-3003Apex MaterialsAluminum Bar150$7.25
5PO-3004Pacific TimberOak Plank80$12.50
6PO-3005Granite Supply CoRebar300$1.30
7PO-3006Apex MaterialsSteel Sheet120$4.80
8PO-3007Pacific TimberPine Board250$8.75
9PO-3008Granite Supply CoConcrete Mix400$0.95
10PO-3009Apex MaterialsCarbon Fiber50
11PO-3010Pacific TimberOak Plank90$12.50
12PO-3011Granite Supply CoRebar180$1.30
13PO-3012Apex MaterialsAluminum Bar200$7.25
14PO-3013Pacific TimberBamboo Panel60$6.40
15PO-3014Granite Supply CoLimestone Block100
16PO-3015Apex MaterialsSteel Sheet300$4.80
17PO-3016Pacific TimberPine Board175$8.75
18PO-3017Granite Supply CoConcrete Mix250$0.95
19PO-3018Apex MaterialsCarbon Fiber35
20PO-3019Pacific TimberBamboo Panel80$6.40
21PO-3020Granite Supply CoRebar220$1.30

Why it failed: Still working at the 5-minute time limit. 23 cells are wrong, such as F2: empty instead of 960. F2:F21 hold no formula.