All AutosheetBench tasks

Consolidate plant data onto one sheet

Spreadsheet manipulationEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Consolidate all production data onto a single summary sheet called "Consolidated"

Add a Source Plant column so we know where each record came from

Plant_A

Starting sheet · rows 1–21 of 27
ABCDE
1PartNumberProductLineUnitsProducedDefectCountDate
2PA-1001Engine Parts42032024-01-08
3PA-1002Chassis Components31072024-01-09
4PA-1003Engine Parts50522024-01-10
5PA-1004Electrical Systems280112024-01-11
6PA-1005Chassis Components39552024-01-12
7PA-1006Engine Parts46042024-01-15
8PA-1007Transmission34082024-01-16
9PA-1008Electrical Systems265142024-01-17
10PA-1009Engine Parts49012024-01-18
11PA-1010Transmission31562024-01-19
12PA-1011Chassis Components37092024-01-22
13PA-1012Engine Parts44032024-01-23
14PA-1013Electrical Systems295122024-01-24
15PA-1014Transmission35072024-01-25
16PA-1015Chassis Components40542024-01-26
17PA-1016Engine Parts47522024-01-29
18PA-1017Electrical Systems270152024-01-30
19PA-1018Chassis Components38562024-01-31
20PA-1019Engine Parts51012024-02-01
21PA-1020Transmission33082024-02-02

Plant_B

Starting sheet · rows 1–21 of 22
ABCDE
1PartNumberProductLineUnitsProducedDefectCountDate
2PB-2001Engine Parts38052024-01-08
3PB-2002Body Panels51022024-01-09
4PB-2003Transmission29592024-01-10
5PB-2004Body Panels47032024-01-11
6PB-2005Engine Parts34062024-01-12
7PB-2006Suspension42042024-01-15
8PB-2007Body Panels49012024-01-16
9PB-2008Transmission310102024-01-17
10PB-2009Suspension40572024-01-18
11PB-2010Engine Parts36552024-01-19
12PB-2011Body Panels44522024-01-22
13PB-2012Suspension38082024-01-23
14PB-2013Engine Parts35042024-01-24
15PB-2014Body Panels50032024-01-25
16PB-2015Transmission290112024-01-26
17PB-2016Suspension41562024-01-29
18PB-2017Engine Parts37052024-01-30
19PB-2018Body Panels45522024-01-31
20PB-2019Transmission30592024-02-01
21PB-2020Suspension43042024-02-02

Plant_C

Starting sheet
ABCDE
1PartNumberProductLineUnitsProducedDefectCountDate
2PC-3001Braking Systems27542024-01-08
3PC-3002Engine Parts43022024-01-09
4PC-3003Braking Systems26062024-01-10
5PC-3004Transmission32082024-01-11
6PC-3005Braking Systems29052024-01-12
7PC-3006Engine Parts41032024-01-15
8PC-3007Braking Systems28572024-01-16
9PC-3008Transmission335102024-01-17
10PC-3009Braking Systems27042024-01-18
11PC-3010Engine Parts40022024-01-19
12PC-3011Braking Systems29562024-01-22
13PC-3012Transmission31092024-01-23
14PC-3013Engine Parts42512024-01-24
15PC-3014Braking Systems28052024-01-25
16PC-3015Transmission30082024-01-26

A passing output

Autosheet in Excel · Opus 5.5
ConsolidatedNew sheet · 391 cells changed

I2=COUNTIF($A$2:$A$61,H2)

ABCDEFGHIJKL
1Source PlantPartNumberProductLineUnitsProducedDefectCountDateSource PlantRecordsUnits ProducedDefectsDefect Rate
2Plant_APA-1001Engine Parts42032024-01-08Plant_A259,5901551.62%
3Plant_APA-1002Chassis Components31072024-01-09Plant_B207,9251061.34%
4Plant_APA-1003Engine Parts50522024-01-10Plant_C154,885801.64%
5Plant_APA-1004Electrical Systems280112024-01-11Total6022,4003411.52%
6Plant_APA-1005Chassis Components39552024-01-12
7Plant_APA-1006Engine Parts46042024-01-15
8Plant_APA-1007Transmission34082024-01-16
9Plant_APA-1008Electrical Systems265142024-01-17
10Plant_APA-1009Engine Parts49012024-01-18
11Plant_APA-1010Transmission31562024-01-19
12Plant_APA-1011Chassis Components37092024-01-22
13Plant_APA-1012Engine Parts44032024-01-23
14Plant_APA-1013Electrical Systems295122024-01-24
15Plant_APA-1014Transmission35072024-01-25
16Plant_APA-1015Chassis Components40542024-01-26
17Plant_APA-1016Engine Parts47522024-01-29
18Plant_APA-1017Electrical Systems270152024-01-30
19Plant_APA-1018Chassis Components38562024-01-31
20Plant_APA-1019Engine Parts51012024-02-01
21Plant_APA-1020Transmission33082024-02-02

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.
  • Consolidated!A1:F61 match the expected answers
  • A Consolidated sheet exists

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed33s · 14¢
ConsolidatedNew sheet · 391 cells changed

I2=COUNTIF($A$2:$A$61,H2)

ABCDEFGHIJKL
1Source PlantPartNumberProductLineUnitsProducedDefectCountDateSource PlantRecordsUnits ProducedDefectsDefect Rate
2Plant_APA-1001Engine Parts42032024-01-08Plant_A259,5901551.62%
3Plant_APA-1002Chassis Components31072024-01-09Plant_B207,9251061.34%
4Plant_APA-1003Engine Parts50522024-01-10Plant_C154,885801.64%
5Plant_APA-1004Electrical Systems280112024-01-11Total6022,4003411.52%
6Plant_APA-1005Chassis Components39552024-01-12
7Plant_APA-1006Engine Parts46042024-01-15
8Plant_APA-1007Transmission34082024-01-16
9Plant_APA-1008Electrical Systems265142024-01-17
10Plant_APA-1009Engine Parts49012024-01-18
11Plant_APA-1010Transmission31562024-01-19
12Plant_APA-1011Chassis Components37092024-01-22
13Plant_APA-1012Engine Parts44032024-01-23
14Plant_APA-1013Electrical Systems295122024-01-24
15Plant_APA-1014Transmission35072024-01-25
16Plant_APA-1015Chassis Components40542024-01-26
17Plant_APA-1016Engine Parts47522024-01-29
18Plant_APA-1017Electrical Systems270152024-01-30
19Plant_APA-1018Chassis Components38562024-01-31
20Plant_APA-1019Engine Parts51012024-02-01
21Plant_APA-1020Transmission33082024-02-02

Autosheet in Excel GPT-6 Astra · Low

Passed23s · 19¢
ConsolidatedNew sheet · 366 cells changed
ABCDEF
1PartNumberProductLineUnitsProducedDefectCountDateSource Plant
2PA-1001Engine Parts42032024-01-08Plant_A
3PA-1002Chassis Components31072024-01-09Plant_A
4PA-1003Engine Parts50522024-01-10Plant_A
5PA-1004Electrical Systems280112024-01-11Plant_A
6PA-1005Chassis Components39552024-01-12Plant_A
7PA-1006Engine Parts46042024-01-15Plant_A
8PA-1007Transmission34082024-01-16Plant_A
9PA-1008Electrical Systems265142024-01-17Plant_A
10PA-1009Engine Parts49012024-01-18Plant_A
11PA-1010Transmission31562024-01-19Plant_A
12PA-1011Chassis Components37092024-01-22Plant_A
13PA-1012Engine Parts44032024-01-23Plant_A
14PA-1013Electrical Systems295122024-01-24Plant_A
15PA-1014Transmission35072024-01-25Plant_A
16PA-1015Chassis Components40542024-01-26Plant_A
17PA-1016Engine Parts47522024-01-29Plant_A
18PA-1017Electrical Systems270152024-01-30Plant_A
19PA-1018Chassis Components38562024-01-31Plant_A
20PA-1019Engine Parts51012024-02-01Plant_A
21PA-1020Transmission33082024-02-02Plant_A

Autosheet in Sheets Opus 5.5 · Medium

Passed1m 9s · 26¢
ConsolidatedNew sheet · 452 cells changed

B2=Plant_A!A2

ABCDEFGHIJKLM
1Source PlantPartNumberProductLineUnitsProducedDefectCountDateDefectRatePlantRecordsTotal UnitsTotal DefectsDefect Rate
2Plant APA-1001Engine Parts42032024-01-080.71%Plant A259,5901551.62%
3Plant APA-1002Chassis Components31072024-01-092.26%Plant B207,9251061.34%
4Plant APA-1003Engine Parts50522024-01-100.40%Plant C154,885801.64%
5Plant APA-1004Electrical Systems280112024-01-113.93%Total6022,4003411.52%
6Plant APA-1005Chassis Components39552024-01-121.27%
7Plant APA-1006Engine Parts46042024-01-150.87%
8Plant APA-1007Transmission34082024-01-162.35%
9Plant APA-1008Electrical Systems265142024-01-175.28%
10Plant APA-1009Engine Parts49012024-01-180.20%
11Plant APA-1010Transmission31562024-01-191.90%
12Plant APA-1011Chassis Components37092024-01-222.43%
13Plant APA-1012Engine Parts44032024-01-230.68%
14Plant APA-1013Electrical Systems295122024-01-244.07%
15Plant APA-1014Transmission35072024-01-252.00%
16Plant APA-1015Chassis Components40542024-01-260.99%
17Plant APA-1016Engine Parts47522024-01-290.42%
18Plant APA-1017Electrical Systems270152024-01-305.56%
19Plant APA-1018Chassis Components38562024-01-311.56%
20Plant APA-1019Engine Parts51012024-02-010.20%
21Plant APA-1020Transmission33082024-02-022.42%

Autosheet in Excel Sonnet 5.5 · Medium

Passed13s · 4¢
ConsolidatedNew sheet · 366 cells changed
ABCDEF
1Source PlantPartNumberProductLineUnitsProducedDefectCountDate
2Plant_APA-1001Engine Parts42031/8/24
3Plant_APA-1002Chassis Components31071/9/24
4Plant_APA-1003Engine Parts50521/10/24
5Plant_APA-1004Electrical Systems280111/11/24
6Plant_APA-1005Chassis Components39551/12/24
7Plant_APA-1006Engine Parts46041/15/24
8Plant_APA-1007Transmission34081/16/24
9Plant_APA-1008Electrical Systems265141/17/24
10Plant_APA-1009Engine Parts49011/18/24
11Plant_APA-1010Transmission31561/19/24
12Plant_APA-1011Chassis Components37091/22/24
13Plant_APA-1012Engine Parts44031/23/24
14Plant_APA-1013Electrical Systems295121/24/24
15Plant_APA-1014Transmission35071/25/24
16Plant_APA-1015Chassis Components40541/26/24
17Plant_APA-1016Engine Parts47521/29/24
18Plant_APA-1017Electrical Systems270151/30/24
19Plant_APA-1018Chassis Components38561/31/24
20Plant_APA-1019Engine Parts51012/1/24
21Plant_APA-1020Transmission33082/2/24

Claude in Excel Opus 5.5 · High

Passed39s · 31¢
ConsolidatedNew sheet · 452 cells changed

B2=Plant_A!A2

ABCDEFGHIJKLM
1Source PlantPartNumberProductLineUnitsProducedDefectCountDateDefect RateSource PlantPart CountTotal UnitsTotal DefectsDefect Rate
2Plant APA-1001Engine Parts42032024-01-080.7%Plant A259,5901551.6%
3Plant APA-1002Chassis Components31072024-01-092.3%Plant B207,9251061.3%
4Plant APA-1003Engine Parts50522024-01-100.4%Plant C154,885801.6%
5Plant APA-1004Electrical Systems280112024-01-113.9%Total6022,4003411.5%
6Plant APA-1005Chassis Components39552024-01-121.3%
7Plant APA-1006Engine Parts46042024-01-150.9%
8Plant APA-1007Transmission34082024-01-162.4%
9Plant APA-1008Electrical Systems265142024-01-175.3%
10Plant APA-1009Engine Parts49012024-01-180.2%
11Plant APA-1010Transmission31562024-01-191.9%
12Plant APA-1011Chassis Components37092024-01-222.4%
13Plant APA-1012Engine Parts44032024-01-230.7%
14Plant APA-1013Electrical Systems295122024-01-244.1%
15Plant APA-1014Transmission35072024-01-252.0%
16Plant APA-1015Chassis Components40542024-01-261.0%
17Plant APA-1016Engine Parts47522024-01-290.4%
18Plant APA-1017Electrical Systems270152024-01-305.6%
19Plant APA-1018Chassis Components38562024-01-311.6%
20Plant APA-1019Engine Parts51012024-02-010.2%
21Plant APA-1020Transmission33082024-02-022.4%

Autosheet in Excel Haiku 5.5 · High

Passed20s · 0.4¢
ConsolidatedNew sheet · 366 cells changed
ABCDEF
1Source PlantPartNumberProductLineUnitsProducedDefectCountDate
2Plant_APA-1001Engine Parts42031/8/24
3Plant_APA-1002Chassis Components31071/9/24
4Plant_APA-1003Engine Parts50521/10/24
5Plant_APA-1004Electrical Systems280111/11/24
6Plant_APA-1005Chassis Components39551/12/24
7Plant_APA-1006Engine Parts46041/15/24
8Plant_APA-1007Transmission34081/16/24
9Plant_APA-1008Electrical Systems265141/17/24
10Plant_APA-1009Engine Parts49011/18/24
11Plant_APA-1010Transmission31561/19/24
12Plant_APA-1011Chassis Components37091/22/24
13Plant_APA-1012Engine Parts44031/23/24
14Plant_APA-1013Electrical Systems295121/24/24
15Plant_APA-1014Transmission35071/25/24
16Plant_APA-1015Chassis Components40541/26/24
17Plant_APA-1016Engine Parts47521/29/24
18Plant_APA-1017Electrical Systems270151/30/24
19Plant_APA-1018Chassis Components38561/31/24
20Plant_APA-1019Engine Parts51012/1/24
21Plant_APA-1020Transmission33082/2/24

Claude in Sheets Opus 5.5 · Medium

Passed55s · 15¢
ConsolidatedNew sheet · 391 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("VSTACK(FILTER({IF(Plant_A!A2:A1000<>"""",""Plant_A"",""""),Plant_A!A2:E1000},Plant_A!A2:A1000<>""""),FILTER({IF(Plant_B!A2:A1000<>"""",""Plant_B"",""""),Plant_B!A2:E1000},Plant_B!A2:A1000<>""""),FILTER({IF(Plant_C!A2:A1000<>"""",""Plant_C"",""""),Plant_C!"&"A2:E1000},Plant_C!A2:A1000<>""""))"),"Plant_A")

ABCDEFGHIJKL
1Source PlantPartNumberProductLineUnitsProducedDefectCountDateSource PlantPartsUnits ProducedDefectsDefect Rate
2Plant_APA-1001Engine Parts42032024-01-08Plant_A259,5901551.6%
3Plant_APA-1002Chassis Components31072024-01-09Plant_B207,9251061.3%
4Plant_APA-1003Engine Parts50522024-01-10Plant_C154,885801.6%
5Plant_APA-1004Electrical Systems280112024-01-11Total6022,4003411.5%
6Plant_APA-1005Chassis Components39552024-01-12
7Plant_APA-1006Engine Parts46042024-01-15
8Plant_APA-1007Transmission34082024-01-16
9Plant_APA-1008Electrical Systems265142024-01-17
10Plant_APA-1009Engine Parts49012024-01-18
11Plant_APA-1010Transmission31562024-01-19
12Plant_APA-1011Chassis Components37092024-01-22
13Plant_APA-1012Engine Parts44032024-01-23
14Plant_APA-1013Electrical Systems295122024-01-24
15Plant_APA-1014Transmission35072024-01-25
16Plant_APA-1015Chassis Components40542024-01-26
17Plant_APA-1016Engine Parts47522024-01-29
18Plant_APA-1017Electrical Systems270152024-01-30
19Plant_APA-1018Chassis Components38562024-01-31
20Plant_APA-1019Engine Parts51012024-02-01
21Plant_APA-1020Transmission33082024-02-02

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed1m 32s · N/A
ConsolidatedNew sheet · 386 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("ARRAYFORMULA(VSTACK(LET(d,FILTER(Plant_A!A2:E1000,Plant_A!A2:A1000<>""""),HSTACK(IF(SEQUENCE(ROWS(d)),""Plant_A""),d)),LET(d,FILTER(Plant_B!A2:E1000,Plant_B!A2:A1000<>""""),HSTACK(IF(SEQUENCE(ROWS(d)),""Plant_B""),d)),LET(d,FILTER(Plant_C!A2:E1000,Plant_C"&"!A2:A1000<>""""),HSTACK(IF(SEQUENCE(ROWS(d)),""Plant_C""),d))))"),"Plant_A")

ABCDEFGHIJK
1Source PlantPartNumberProductLineUnitsProducedDefectCountDateSource PlantUnitsProducedDefectCountDefect Rate
2Plant_APA-1001Engine Parts42032024-01-08Plant_A95901551.6%
3Plant_APA-1002Chassis Components31072024-01-09Plant_B79251061.3%
4Plant_APA-1003Engine Parts50522024-01-10Plant_C4885801.6%
5Plant_APA-1004Electrical Systems280112024-01-11Total224003411.5%
6Plant_APA-1005Chassis Components39552024-01-12
7Plant_APA-1006Engine Parts46042024-01-15
8Plant_APA-1007Transmission34082024-01-16
9Plant_APA-1008Electrical Systems265142024-01-17
10Plant_APA-1009Engine Parts49012024-01-18
11Plant_APA-1010Transmission31562024-01-19
12Plant_APA-1011Chassis Components37092024-01-22
13Plant_APA-1012Engine Parts44032024-01-23
14Plant_APA-1013Electrical Systems295122024-01-24
15Plant_APA-1014Transmission35072024-01-25
16Plant_APA-1015Chassis Components40542024-01-26
17Plant_APA-1016Engine Parts47522024-01-29
18Plant_APA-1017Electrical Systems270152024-01-30
19Plant_APA-1018Chassis Components38562024-01-31
20Plant_APA-1019Engine Parts51012024-02-01
21Plant_APA-1020Transmission33082024-02-02

Autosheet in Excel GPT-6.1 Sol · Medium

Passed39s · 10¢
ConsolidatedNew sheet · 366 cells changed
ABCDEF
1PartNumberProductLineUnitsProducedDefectCountDateSource Plant
2PA-1001Engine Parts42032024-01-08Plant_A
3PA-1002Chassis Components31072024-01-09Plant_A
4PA-1003Engine Parts50522024-01-10Plant_A
5PA-1004Electrical Systems280112024-01-11Plant_A
6PA-1005Chassis Components39552024-01-12Plant_A
7PA-1006Engine Parts46042024-01-15Plant_A
8PA-1007Transmission34082024-01-16Plant_A
9PA-1008Electrical Systems265142024-01-17Plant_A
10PA-1009Engine Parts49012024-01-18Plant_A
11PA-1010Transmission31562024-01-19Plant_A
12PA-1011Chassis Components37092024-01-22Plant_A
13PA-1012Engine Parts44032024-01-23Plant_A
14PA-1013Electrical Systems295122024-01-24Plant_A
15PA-1014Transmission35072024-01-25Plant_A
16PA-1015Chassis Components40542024-01-26Plant_A
17PA-1016Engine Parts47522024-01-29Plant_A
18PA-1017Electrical Systems270152024-01-30Plant_A
19PA-1018Chassis Components38562024-01-31Plant_A
20PA-1019Engine Parts51012024-02-01Plant_A
21PA-1020Transmission33082024-02-02Plant_A

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed2m 10s · N/A
ConsolidatedNew sheet · 366 cells changed
ABCDEF
1Source PlantPartNumberProductLineUnitsProducedDefectCountDate
2Plant_APA-1001Engine Parts42032024-01-08
3Plant_APA-1002Chassis Components31072024-01-09
4Plant_APA-1003Engine Parts50522024-01-10
5Plant_APA-1004Electrical Systems280112024-01-11
6Plant_APA-1005Chassis Components39552024-01-12
7Plant_APA-1006Engine Parts46042024-01-15
8Plant_APA-1007Transmission34082024-01-16
9Plant_APA-1008Electrical Systems265142024-01-17
10Plant_APA-1009Engine Parts49012024-01-18
11Plant_APA-1010Transmission31562024-01-19
12Plant_APA-1011Chassis Components37092024-01-22
13Plant_APA-1012Engine Parts44032024-01-23
14Plant_APA-1013Electrical Systems295122024-01-24
15Plant_APA-1014Transmission35072024-01-25
16Plant_APA-1015Chassis Components40542024-01-26
17Plant_APA-1016Engine Parts47522024-01-29
18Plant_APA-1017Electrical Systems270152024-01-30
19Plant_APA-1018Chassis Components38562024-01-31
20Plant_APA-1019Engine Parts51012024-02-01
21Plant_APA-1020Transmission33082024-02-02

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed1m 37s · N/A
ConsolidatedNew sheet · 390 cells changed

B2=Plant_A!A2

ABCDEFGHIJK
1Source PlantPartNumberProductLineUnitsProducedDefectCountDateCheckConsolidatedSourcesMatch?
2Plant_APA-1001Engine Parts42032024-01-08Record count6060TRUE
3Plant_APA-1002Chassis Components31072024-01-09Total units2240022400TRUE
4Plant_APA-1003Engine Parts50522024-01-10Total defects341341TRUE
5Plant_APA-1004Electrical Systems280112024-01-11Duplicate PartNumbers00TRUE
6Plant_APA-1005Chassis Components39552024-01-12Source Plant check6060TRUE
7Plant_APA-1006Engine Parts46042024-01-15
8Plant_APA-1007Transmission34082024-01-16
9Plant_APA-1008Electrical Systems265142024-01-17
10Plant_APA-1009Engine Parts49012024-01-18
11Plant_APA-1010Transmission31562024-01-19
12Plant_APA-1011Chassis Components37092024-01-22
13Plant_APA-1012Engine Parts44032024-01-23
14Plant_APA-1013Electrical Systems295122024-01-24
15Plant_APA-1014Transmission35072024-01-25
16Plant_APA-1015Chassis Components40542024-01-26
17Plant_APA-1016Engine Parts47522024-01-29
18Plant_APA-1017Electrical Systems270152024-01-30
19Plant_APA-1018Chassis Components38562024-01-31
20Plant_APA-1019Engine Parts51012024-02-01
21Plant_APA-1020Transmission33082024-02-02

Autosheet in Sheets Haiku 5.5 · High

Passed53s · 0.5¢
ConsolidatedNew sheet · 366 cells changed

B2=Plant_A!A2

ABCDEF
1Source PlantPartNumberProductLineUnitsProducedDefectCountDate
2Plant_APA-1001Engine Parts42032024-01-08
3Plant_APA-1002Chassis Components31072024-01-09
4Plant_APA-1003Engine Parts50522024-01-10
5Plant_APA-1004Electrical Systems280112024-01-11
6Plant_APA-1005Chassis Components39552024-01-12
7Plant_APA-1006Engine Parts46042024-01-15
8Plant_APA-1007Transmission34082024-01-16
9Plant_APA-1008Electrical Systems265142024-01-17
10Plant_APA-1009Engine Parts49012024-01-18
11Plant_APA-1010Transmission31562024-01-19
12Plant_APA-1011Chassis Components37092024-01-22
13Plant_APA-1012Engine Parts44032024-01-23
14Plant_APA-1013Electrical Systems295122024-01-24
15Plant_APA-1014Transmission35072024-01-25
16Plant_APA-1015Chassis Components40542024-01-26
17Plant_APA-1016Engine Parts47522024-01-29
18Plant_APA-1017Electrical Systems270152024-01-30
19Plant_APA-1018Chassis Components38562024-01-31
20Plant_APA-1019Engine Parts51012024-02-01
21Plant_APA-1020Transmission33082024-02-02

ChatGPT in Excel GPT-6 Astra · Medium

Passed58s · $1.13
ConsolidatedNew sheet · 380 cells changed

A4=COUNTA(ConsolidatedProduction[PartNumber])

ABCDEF
1Consolidated Production
2Sources: Plant_A, Plant_B, Plant_C | Snapshot as of 2026-11-13
3Production RecordsUnits ProducedDefect CountDefect Rate
46022,4003411.5%
5
6
7PartNumberProductLineUnitsProducedDefectCountDateSource Plant
8PA-1001Engine Parts42032024-01-08Plant_A
9PA-1002Chassis Components31072024-01-09Plant_A
10PA-1003Engine Parts50522024-01-10Plant_A
11PA-1004Electrical Systems280112024-01-11Plant_A
12PA-1005Chassis Components39552024-01-12Plant_A
13PA-1006Engine Parts46042024-01-15Plant_A
14PA-1007Transmission34082024-01-16Plant_A
15PA-1008Electrical Systems265142024-01-17Plant_A
16PA-1009Engine Parts49012024-01-18Plant_A
17PA-1010Transmission31562024-01-19Plant_A
18PA-1011Chassis Components37092024-01-22Plant_A
19PA-1012Engine Parts44032024-01-23Plant_A
20PA-1013Electrical Systems295122024-01-24Plant_A
21PA-1014Transmission35072024-01-25Plant_A

Claude in Excel Haiku 5.5 · High

Passed24s · 0.9¢
ConsolidatedNew sheet · 369 cells changed

B2=Plant_A!A2

ABCDEF
1Source PlantPartNumberProductLineUnitsProducedDefectCountDate
2Plant APA-1001Engine Parts42032024-01-08
3Plant APA-1002Chassis Components31072024-01-09
4Plant APA-1003Engine Parts50522024-01-10
5Plant APA-1004Electrical Systems280112024-01-11
6Plant APA-1005Chassis Components39552024-01-12
7Plant APA-1006Engine Parts46042024-01-15
8Plant APA-1007Transmission34082024-01-16
9Plant APA-1008Electrical Systems265142024-01-17
10Plant APA-1009Engine Parts49012024-01-18
11Plant APA-1010Transmission31562024-01-19
12Plant APA-1011Chassis Components37092024-01-22
13Plant APA-1012Engine Parts44032024-01-23
14Plant APA-1013Electrical Systems295122024-01-24
15Plant APA-1014Transmission35072024-01-25
16Plant APA-1015Chassis Components40542024-01-26
17Plant APA-1016Engine Parts47522024-01-29
18Plant APA-1017Electrical Systems270152024-01-30
19Plant APA-1018Chassis Components38562024-01-31
20Plant APA-1019Engine Parts51012024-02-01
21Plant APA-1020Transmission33082024-02-02

Claude in Sheets Haiku 5.5 · High

Passed1m 19s · 3¢
ConsolidatedNew sheet · 393 cells changed

B4=COUNTIF($A$10:$A$69,A4)

ABCDEF
1Consolidated Production Summary
2
3PlantRecordsUnitsProducedDefectCountDefect Rate
4Plant_A259,5901551.62%
5Plant_B207,9251061.34%
6Plant_C154,885801.64%
7Total6022,4003411.52%
8Detail — all records (linked to Plant_A, Plant_B, Plant_C)
9Source PlantPartNumberProductLineUnitsProducedDefectCountDate
10Plant_APA-1001Engine Parts42032024-01-08
11Plant_APA-1002Chassis Components31072024-01-09
12Plant_APA-1003Engine Parts50522024-01-10
13Plant_APA-1004Electrical Systems280112024-01-11
14Plant_APA-1005Chassis Components39552024-01-12
15Plant_APA-1006Engine Parts46042024-01-15
16Plant_APA-1007Transmission34082024-01-16
17Plant_APA-1008Electrical Systems265142024-01-17
18Plant_APA-1009Engine Parts49012024-01-18
19Plant_APA-1010Transmission31562024-01-19
20Plant_APA-1011Chassis Components37092024-01-22
21Plant_APA-1012Engine Parts44032024-01-23

Autosheet in Excel GPT-6 Luna · High

Passed1m 2s · 1¢
ConsolidatedNew sheet · 366 cells changed
ABCDEF
1Source PlantPartNumberProductLineUnitsProducedDefectCountDate
2Plant_APA-1001Engine Parts42031/8/24
3Plant_APA-1002Chassis Components31071/9/24
4Plant_APA-1003Engine Parts50521/10/24
5Plant_APA-1004Electrical Systems280111/11/24
6Plant_APA-1005Chassis Components39551/12/24
7Plant_APA-1006Engine Parts46041/15/24
8Plant_APA-1007Transmission34081/16/24
9Plant_APA-1008Electrical Systems265141/17/24
10Plant_APA-1009Engine Parts49011/18/24
11Plant_APA-1010Transmission31561/19/24
12Plant_APA-1011Chassis Components37091/22/24
13Plant_APA-1012Engine Parts44031/23/24
14Plant_APA-1013Electrical Systems295121/24/24
15Plant_APA-1014Transmission35071/25/24
16Plant_APA-1015Chassis Components40541/26/24
17Plant_APA-1016Engine Parts47521/29/24
18Plant_APA-1017Electrical Systems270151/30/24
19Plant_APA-1018Chassis Components38561/31/24
20Plant_APA-1019Engine Parts51012/1/24
21Plant_APA-1020Transmission33082/2/24

Copilot in Excel Auto

Passed1m 19s · N/A
ConsolidatedNew sheet · 368 cells changed
ABCDEF
1Consolidated Production Data
260 production records combined from 3 plants
3
4Source PlantPartNumberProductLineUnitsProducedDefectCountDate
5Plant APA-1001Engine Parts42032024-01-08
6Plant APA-1002Chassis Components31072024-01-09
7Plant APA-1003Engine Parts50522024-01-10
8Plant APA-1004Electrical Systems280112024-01-11
9Plant APA-1005Chassis Components39552024-01-12
10Plant APA-1006Engine Parts46042024-01-15
11Plant APA-1007Transmission34082024-01-16
12Plant APA-1008Electrical Systems265142024-01-17
13Plant APA-1009Engine Parts49012024-01-18
14Plant APA-1010Transmission31562024-01-19
15Plant APA-1011Chassis Components37092024-01-22
16Plant APA-1012Engine Parts44032024-01-23
17Plant APA-1013Electrical Systems295122024-01-24
18Plant APA-1014Transmission35072024-01-25
19Plant APA-1015Chassis Components40542024-01-26
20Plant APA-1016Engine Parts47522024-01-29
21Plant APA-1017Electrical Systems270152024-01-30

ChatGPT + Drive MCP GPT-6 · Medium

Passed1m 3s · N/A
ConsolidatedNew sheet · 366 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("QUERY({ARRAYFORMULA(IF(Plant_A!A2:A1000<>"""",""Plant_A"","""")),Plant_A!A2:E1000;ARRAYFORMULA(IF(Plant_B!A2:A1000<>"""",""Plant_B"","""")),Plant_B!A2:E1000;ARRAYFORMULA(IF(Plant_C!A2:A1000<>"""",""Plant_C"","""")),Plant_C!A2:E1000},""select * where Col2 "&"is not null"",0)"),"Plant_A")

ABCDEF
1Source PlantPartNumberProductLineUnitsProducedDefectCountDate
2Plant_APA-1001Engine Parts42032024-01-08
3Plant_APA-1002Chassis Components31072024-01-09
4Plant_APA-1003Engine Parts50522024-01-10
5Plant_APA-1004Electrical Systems280112024-01-11
6Plant_APA-1005Chassis Components39552024-01-12
7Plant_APA-1006Engine Parts46042024-01-15
8Plant_APA-1007Transmission34082024-01-16
9Plant_APA-1008Electrical Systems265142024-01-17
10Plant_APA-1009Engine Parts49012024-01-18
11Plant_APA-1010Transmission31562024-01-19
12Plant_APA-1011Chassis Components37092024-01-22
13Plant_APA-1012Engine Parts44032024-01-23
14Plant_APA-1013Electrical Systems295122024-01-24
15Plant_APA-1014Transmission35072024-01-25
16Plant_APA-1015Chassis Components40542024-01-26
17Plant_APA-1016Engine Parts47522024-01-29
18Plant_APA-1017Electrical Systems270152024-01-30
19Plant_APA-1018Chassis Components38562024-01-31
20Plant_APA-1019Engine Parts51012024-02-01
21Plant_APA-1020Transmission33082024-02-02

ChatGPT in Excel GPT-6 Luna · High

Passed1m 12s · 2¢
ConsolidatedNew sheet · 366 cells changed
ABCDEF
1Source PlantPartNumberProductLineUnitsProducedDefectCountDate
2Plant_APA-1001Engine Parts42032024-01-08
3Plant_APA-1002Chassis Components31072024-01-09
4Plant_APA-1003Engine Parts50522024-01-10
5Plant_APA-1004Electrical Systems280112024-01-11
6Plant_APA-1005Chassis Components39552024-01-12
7Plant_APA-1006Engine Parts46042024-01-15
8Plant_APA-1007Transmission34082024-01-16
9Plant_APA-1008Electrical Systems265142024-01-17
10Plant_APA-1009Engine Parts49012024-01-18
11Plant_APA-1010Transmission31562024-01-19
12Plant_APA-1011Chassis Components37092024-01-22
13Plant_APA-1012Engine Parts44032024-01-23
14Plant_APA-1013Electrical Systems295122024-01-24
15Plant_APA-1014Transmission35072024-01-25
16Plant_APA-1015Chassis Components40542024-01-26
17Plant_APA-1016Engine Parts47522024-01-29
18Plant_APA-1017Electrical Systems270152024-01-30
19Plant_APA-1018Chassis Components38562024-01-31
20Plant_APA-1019Engine Parts51012024-02-01
21Plant_APA-1020Transmission33082024-02-02

Gemini in Sheets Auto

Passed5m · N/A
ConsolidatedNew sheet · 366 cells changed
ABCDEF
1Source PlantPartNumberProductLineUnitsProducedDefectCountDate
2Plant_APA-1001Engine Parts42032024-01-08
3Plant_APA-1002Chassis Components31072024-01-09
4Plant_APA-1003Engine Parts50522024-01-10
5Plant_APA-1004Electrical Systems280112024-01-11
6Plant_APA-1005Chassis Components39552024-01-12
7Plant_APA-1006Engine Parts46042024-01-15
8Plant_APA-1007Transmission34082024-01-16
9Plant_APA-1008Electrical Systems265142024-01-17
10Plant_APA-1009Engine Parts49012024-01-18
11Plant_APA-1010Transmission31562024-01-19
12Plant_APA-1011Chassis Components37092024-01-22
13Plant_APA-1012Engine Parts44032024-01-23
14Plant_APA-1013Electrical Systems295122024-01-24
15Plant_APA-1014Transmission35072024-01-25
16Plant_APA-1015Chassis Components40542024-01-26
17Plant_APA-1016Engine Parts47522024-01-29
18Plant_APA-1017Electrical Systems270152024-01-30
19Plant_APA-1018Chassis Components38562024-01-31
20Plant_APA-1019Engine Parts51012024-02-01
21Plant_APA-1020Transmission33082024-02-02

ChatGPT in Sheets GPT-6 Astra · Medium

Passed1m 28s · $1.34
ConsolidatedNew sheet · 391 cells changed

A2=Plant_A!A2

ABCDEFGHIJK
1PartNumberProductLineUnitsProducedDefectCountDateSource PlantProduction Summary
2PA-1001Engine Parts42032024-01-08Plant_APlantRecordsUnitsProducedDefectCount
3PA-1002Chassis Components31072024-01-09Plant_APlant_A259590155
4PA-1003Engine Parts50522024-01-10Plant_APlant_B207925106
5PA-1004Electrical Systems280112024-01-11Plant_APlant_C15488580
6PA-1005Chassis Components39552024-01-12Plant_ATotal6022400341
7PA-1006Engine Parts46042024-01-15Plant_A
8PA-1007Transmission34082024-01-16Plant_ASource links
9PA-1008Electrical Systems265142024-01-17Plant_AAs of 2026-11-13
10PA-1009Engine Parts49012024-01-18Plant_A
11PA-1010Transmission31562024-01-19Plant_AValidationOK
12PA-1011Chassis Components37092024-01-22Plant_A
13PA-1012Engine Parts44032024-01-23Plant_A
14PA-1013Electrical Systems295122024-01-24Plant_A
15PA-1014Transmission35072024-01-25Plant_A
16PA-1015Chassis Components40542024-01-26Plant_A
17PA-1016Engine Parts47522024-01-29Plant_A
18PA-1017Electrical Systems270152024-01-30Plant_A
19PA-1018Chassis Components38562024-01-31Plant_A
20PA-1019Engine Parts51012024-02-01Plant_A
21PA-1020Transmission33082024-02-02Plant_A

ChatGPT in Sheets GPT-6 Luna · High

Passed1m 43s · 1¢
ConsolidatedNew sheet · 366 cells changed

A2="Plant_A"

ABCDEF
1Source PlantPartNumberProductLineUnitsProducedDefectCountDate
2Plant_APA-1001Engine Parts42032024-01-08
3Plant_APA-1002Chassis Components31072024-01-09
4Plant_APA-1003Engine Parts50522024-01-10
5Plant_APA-1004Electrical Systems280112024-01-11
6Plant_APA-1005Chassis Components39552024-01-12
7Plant_APA-1006Engine Parts46042024-01-15
8Plant_APA-1007Transmission34082024-01-16
9Plant_APA-1008Electrical Systems265142024-01-17
10Plant_APA-1009Engine Parts49012024-01-18
11Plant_APA-1010Transmission31562024-01-19
12Plant_APA-1011Chassis Components37092024-01-22
13Plant_APA-1012Engine Parts44032024-01-23
14Plant_APA-1013Electrical Systems295122024-01-24
15Plant_APA-1014Transmission35072024-01-25
16Plant_APA-1015Chassis Components40542024-01-26
17Plant_APA-1016Engine Parts47522024-01-29
18Plant_APA-1017Electrical Systems270152024-01-30
19Plant_APA-1018Chassis Components38562024-01-31
20Plant_APA-1019Engine Parts51012024-02-01
21Plant_APA-1020Transmission33082024-02-02