Look up supplier rates and totals
FormulasEasyDeterministic scoringLatest run
Passed by 11 of 12 products on their best model. Failed: Gemini in Sheets.
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| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | ||
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | ||
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | ||
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | ||
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | ||
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | ||
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | ||
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | ||
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | ||
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | ||
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | ||
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | ||
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | ||
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | ||
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | ||
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | ||
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | ||
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | ||
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | ||
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 |
RateCard
Starting sheet| A | B | C | |
|---|---|---|---|
| 1 | SupplierName | Material | UnitRate |
| 2 | Apex Materials | Steel Sheet | 4.8 |
| 3 | Apex Materials | Aluminum Bar | 7.25 |
| 4 | Granite Supply Co | Concrete Mix | 0.95 |
| 5 | Granite Supply Co | Rebar | 1.3 |
| 6 | Pacific Timber | Oak Plank | 12.5 |
| 7 | Pacific Timber | Pine Board | 8.75 |
| 8 | Pacific Timber | Bamboo Panel | 6.4 |
| 9 | Granite Supply Co | Sand Aggregate | 0.55 |
A passing output
Autosheet in Excel · Opus 5.5E2=XLOOKUP(1, (RateCard!$A$2:$A$10=B2) * (RateCard!$B$2:$B$10=C2), RateCard!$C$2:$C$10, "N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
Pass criteria
All must be met, checked automatically.PurchaseOrders!E2:F21hold the expected values, from formulas
Passed 21
Autosheet in Excel Opus 5.5 · Medium
E2=XLOOKUP(1, (RateCard!$A$2:$A$10=B2) * (RateCard!$B$2:$B$10=C2), RateCard!$C$2:$C$10, "N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
Autosheet in Excel GPT-6 Astra · Low
E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960.00 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475.00 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.50 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000.00 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390.00 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576.00 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.50 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380.00 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125.00 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234.00 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450.00 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384.00 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440.00 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.50 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512.00 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286.00 |
Autosheet in Sheets Opus 5.5 · Medium
E2=XLOOKUP(B2&"|"&C2, RateCard!$A$2:$A$9&"|"&RateCard!$B$2:$B$9, RateCard!$C$2:$C$9, "N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | $4.80 | $960.00 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | $0.95 | $475.00 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | $7.25 | $1,087.50 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | $12.50 | $1,000.00 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | $1.30 | $390.00 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | $4.80 | $576.00 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | $8.75 | $2,187.50 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | $0.95 | $380.00 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | $12.50 | $1,125.00 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | $1.30 | $234.00 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | $7.25 | $1,450.00 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | $6.40 | $384.00 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | $4.80 | $1,440.00 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | $8.75 | $1,531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | $0.95 | $237.50 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | $6.40 | $512.00 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | $1.30 | $286.00 |
Autosheet in Excel Sonnet 5.5 · Medium
E2=XLOOKUP(B2&"|"&C2,RateCard!$A$2:$A$10&"|"&RateCard!$B$2:$B$10,RateCard!$C$2:$C$10,"N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
Claude in Excel Opus 5.5 · High
E2=XLOOKUP(1,(RateCard!$A$2:$A$100=B2)*(RateCard!$B$2:$B$100=C2),RateCard!$C$2:$C$100,"N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.80 | 960.00 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475.00 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1,087.50 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.50 | 1,000.00 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.30 | 390.00 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.80 | 576.00 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2,187.50 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380.00 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.50 | 1,125.00 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.30 | 234.00 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1,450.00 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.40 | 384.00 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.80 | 1,440.00 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1,531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.50 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.40 | 512.00 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.30 | 286.00 |
Autosheet in Excel Haiku 5.5 · High
E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
Claude in Sheets Opus 5.5 · Medium
E2=XLOOKUP($B2&"|"&$C2, RateCard!$A$2:$A$9&"|"&RateCard!$B$2:$B$9, RateCard!$C$2:$C$9, "N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | $4.80 | $960.00 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | $0.95 | $475.00 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | $7.25 | $1,087.50 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | $12.50 | $1,000.00 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | $1.30 | $390.00 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | $4.80 | $576.00 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | $8.75 | $2,187.50 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | $0.95 | $380.00 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | $12.50 | $1,125.00 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | $1.30 | $234.00 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | $7.25 | $1,450.00 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | $6.40 | $384.00 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | $4.80 | $1,440.00 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | $8.75 | $1,531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | $0.95 | $237.50 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | $6.40 | $512.00 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | $1.30 | $286.00 |
Claude Code + Sheets MCP Opus 5.5 · Medium
E2=IFNA(INDEX(RateCard!$C$2:$C1000, MATCH(1, INDEX((RateCard!$A$2:$A1000=B2)*(RateCard!$B$2:$B1000=C2), 0), 0)), "N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
Autosheet in Excel GPT-6.1 Sol · Medium
E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960.00 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475.00 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.50 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000.00 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390.00 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576.00 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.50 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380.00 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125.00 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234.00 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450.00 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384.00 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440.00 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.50 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512.00 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286.00 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
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)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | $4.80 | $960.00 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | $0.95 | $475.00 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | $7.25 | $1,087.50 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | $12.50 | $1,000.00 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | $1.30 | $390.00 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | $4.80 | $576.00 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | $8.75 | $2,187.50 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | $0.95 | $380.00 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | $12.50 | $1,125.00 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | $1.30 | $234.00 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | $7.25 | $1,450.00 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | $6.40 | $384.00 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | $4.80 | $1,440.00 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | $8.75 | $1,531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | $0.95 | $237.50 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | $6.40 | $512.00 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | $1.30 | $286.00 |
ChatGPT + Autosheet MCP GPT-6 · Medium
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)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
Autosheet in Sheets Haiku 5.5 · High
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))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
ChatGPT in Excel GPT-6 Astra · Medium
E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
Claude in Excel Haiku 5.5 · High
E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.80 | 960.00 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475.00 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1,087.50 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.50 | 1,000.00 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.30 | 390.00 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.80 | 576.00 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2,187.50 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380.00 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.50 | 1,125.00 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.30 | 234.00 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1,450.00 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.40 | 384.00 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.80 | 1,440.00 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1,531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.50 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.40 | 512.00 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.30 | 286.00 |
Claude in Sheets Haiku 5.5 · High
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))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
Autosheet in Excel GPT-6 Luna · High
E2=XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9,"N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
Copilot in Excel Auto
E2=IFNA(XLOOKUP(1,(RateCard!$A$2:$A$9=B2)*(RateCard!$B$2:$B$9=C2),RateCard!$C$2:$C$9),"N/A")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | €4.80 | €960.00 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | €0.95 | €475.00 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | €7.25 | €1,087.50 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | €12.50 | €1,000.00 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | €1.30 | €390.00 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | €4.80 | €576.00 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | €8.75 | €2,187.50 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | €0.95 | €380.00 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | €12.50 | €1,125.00 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | €1.30 | €234.00 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | €7.25 | €1,450.00 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | €6.40 | €384.00 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | €4.80 | €1,440.00 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | €8.75 | €1,531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | €0.95 | €237.50 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | €6.40 | €512.00 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | €1.30 | €286.00 |
ChatGPT + Drive MCP GPT-6 · Medium
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)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
ChatGPT in Excel GPT-6 Luna · High
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))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
ChatGPT in Sheets GPT-6 Astra · Medium
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))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
ChatGPT in Sheets GPT-6 Luna · High
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))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | 4.8 | 960 |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | 0.95 | 475 |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | 7.25 | 1087.5 |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | 12.5 | 1000 |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | 1.3 | 390 |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | 4.8 | 576 |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | 8.75 | 2187.5 |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | 0.95 | 380 |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | N/A | N/A |
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | 12.5 | 1125 |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | 1.3 | 234 |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | 7.25 | 1450 |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | 6.4 | 384 |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | N/A | N/A |
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | 4.8 | 1440 |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | 8.75 | 1531.25 |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | 0.95 | 237.5 |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | N/A | N/A |
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | 6.4 | 512 |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | 1.3 | 286 |
Failed 1
Gemini in Sheets Auto
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)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | OrderID | SupplierName | Material | Quantity | UnitCost | TotalCost |
| 2 | PO-3001 | Apex Materials | Steel Sheet | 200 | $4.80 | |
| 3 | PO-3002 | Granite Supply Co | Concrete Mix | 500 | $0.95 | |
| 4 | PO-3003 | Apex Materials | Aluminum Bar | 150 | $7.25 | |
| 5 | PO-3004 | Pacific Timber | Oak Plank | 80 | $12.50 | |
| 6 | PO-3005 | Granite Supply Co | Rebar | 300 | $1.30 | |
| 7 | PO-3006 | Apex Materials | Steel Sheet | 120 | $4.80 | |
| 8 | PO-3007 | Pacific Timber | Pine Board | 250 | $8.75 | |
| 9 | PO-3008 | Granite Supply Co | Concrete Mix | 400 | $0.95 | |
| 10 | PO-3009 | Apex Materials | Carbon Fiber | 50 | ||
| 11 | PO-3010 | Pacific Timber | Oak Plank | 90 | $12.50 | |
| 12 | PO-3011 | Granite Supply Co | Rebar | 180 | $1.30 | |
| 13 | PO-3012 | Apex Materials | Aluminum Bar | 200 | $7.25 | |
| 14 | PO-3013 | Pacific Timber | Bamboo Panel | 60 | $6.40 | |
| 15 | PO-3014 | Granite Supply Co | Limestone Block | 100 | ||
| 16 | PO-3015 | Apex Materials | Steel Sheet | 300 | $4.80 | |
| 17 | PO-3016 | Pacific Timber | Pine Board | 175 | $8.75 | |
| 18 | PO-3017 | Granite Supply Co | Concrete Mix | 250 | $0.95 | |
| 19 | PO-3018 | Apex Materials | Carbon Fiber | 35 | ||
| 20 | PO-3019 | Pacific Timber | Bamboo Panel | 80 | $6.40 | |
| 21 | PO-3020 | Granite Supply Co | Rebar | 220 | $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.