All AutosheetBench tasks

Show a chart's labels as whole percentages

ChartsMediumLLM judge scoringLatest run

Passed by 9 of 12 products on their best model. Failed: ChatGPT in Excel, Copilot in Excel and ChatGPT in Sheets.

Prompt and starting spreadsheet

Task files

Prompt

Make Chart 2 labels whole percentage

Data

Starting sheet · rows 1–21 of 1,000 and columns A–J of 21
ABCDEFGHIJ
1RO NumberBooked DateClosed DateStore/AreaTech NumberLineSequenceMHTSC
23594704612746163S1309A1*ST
33594704616346163S1309A1*ST
43594754616946169S1309A1ST
53594754616946169S1309C3ST
63599164611546147S1309A1*ST
73599164614746147S1309A1*ST
83599334616046160S1309A1*ST
93599734615746157S1309B2ST
103600314615746157S1309B2ST
113600314615746157S1309C3ST
123600314615746157S1309D4ST
133602764615046150S1309A1ST
143602764615046150S1309A2ST
153602774615046153S1309A1*ST
163602774615346153S1309A1*ST
173602774615046153S1309B2*ST
183602774615346153S1309B2*ST
193602794616246162S1309A1*ST
203603104614746147S1309A1ST
213603104614746147S1309B2ST

Manual Inputs

Starting sheet
ABCDE
1Store Manual Inputs
2
3Tech NumberTech NameTotal A/T Clock HoursTraining HoursShop Hours
4309Tech 309165.120.202.50
5313Tech 313123.3015.902.20
6314Tech 314159.040.002.50
7327Tech 327163.292.502.50
8329Tech 329158.022.602.50
9331Tech 331153.420.002.50
10332Tech 33233.160.000.00
11
12Enter/change the yellow cells above. Each tech dashboard pulls from this tab automatically.
13
14Each tech dashboard now includes an Actual Time Capture chart comparing Total A/T Clock Hours to Actual Hours recorded on repair orders.

Store Summary

Starting sheet · rows 1–73 of 113 and columns A–N of 24
ABCDEFGHIJKLMN
1Store Summary - May 2026
2Combined Shop Dashboard
3
4MetricSold Hours BreakdownHoursManual / Payroll HoursValue
5Total Number of ROs Closed339RO Sold Hours569.2Total A/T Clock Hours955.4
6Total Repair Lines Completed541Training Hours21.2Training Hours for Month21.2
7RO Actual Hours574.5Shop Hours14.7Shop Hours for Month14.7
8RO Sold Hours569.2Total Sold + Training + Shop605.1Paid Hours Not on RO380.9
9RO Gain/Loss Hours-5.3Unaccounted Paid Hours345.0
10RO Efficiency %99%Combined Efficiency %63%
11
12
13Pay Type Detail
14Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
15Customer Pay236158197.8221.423.734.4%38.9%47.3%
16Internal12479122.8133.010.121.4%23.4%23.7%
17PDI212126.626.4-0.24.6%4.6%6.3%
18Warranty14076156.4108.0-48.327.2%19.0%22.8%
19Ext Warranty000.00.00.00.0%0.0%0.0%
20Technician Breakdown
21TechTech NoROs ClosedJobs PerformedRO ActualRO SoldGain/LossEfficiencyClock HoursRO Actual Capture %Combined Efficiency
22Tech 30930973135.097.792.6-5.0594.8%165.120%58%
23Tech 3133131726.065.076.611.60117.8%123.353%77%
24Tech 31431482121.0100.693.0-7.6292.4%159.0463%60%
25Tech 327327102161.096.0119.523.55124.5%163.2959%76%
26Tech 3293293759.0101.8115.813.97113.7%158.0264%77%
27Tech 3313312026.0107.464.7-42.7460.2%153.4270%44%
28Tech 332332813.05.96.91.00116.9%33.1618%21%
29
30
31Charts
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53Technician Work Mix by Pay Group (% of Closed ROs)Actual Time Capture
54Customer PayInternalPDIWarrantyExtended WarrantyTotal A/T HoursActual Hours on ROsDifference: Clocked - RO ActualRO Act Capture %
55ROs Closed1587921760955.4574.5-380.960.1%
56Work Mix %47.31%23.65%6.29%22.75%0.00%
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72Actual vs Sold Hours by Pay Group
73MetricCust PayInternalPDIWarrantyExt Warranty

Tech 309

Starting sheet · rows 1–62 of 136 and columns A–M of 18
ABCDEFGHIJKLM
1Tech 309 Dashboard
2
3MetricValueSold Hours BreakdownHoursManual / Payroll HoursValue
4Total Number of ROs Closed73RO Sold Hours92.6Total A/T Clock Hours165.1
5Total Repair Lines Completed135Training Hours0.2Training Hours for Month0.2
6RO Actual Hours97.7Shop Hours2.5Shop Hours for Month2.5
7RO Sold Hours92.6Total Sold + Training + Shop95.3Paid Hours Not on RO67.5
8RO Gain/Loss Hours-5.0Unaccounted Paid Hours64.8
9RO Efficiency %95%Combined Efficiency %58%
10
11
12Pay Type Detail
13Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
14Customer Pay8816.814.6-2.217.2%15.8%11.0%
15Internal452239.840.20.440.8%43.4%30.1%
16PDI131316.716.1-0.617.1%17.4%17.8%
17Warranty693024.421.7-2.725.0%23.4%41.1%
18Extended Warranty000.00.00.00.0%0.0%0.0%
19Charts
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41Technician Work Mix by Pay GroupActual Time Capture
42MetricCustomer PayInternalPDIWarrantyExtended WarrantyTotal A/T HoursActual Hours on ROsDifference: Clocked - RO ActualRO Act Capture %
43ROs Closed82213300165.197.7-67.559.1%
44% of Closed ROs11%30%18%41%0%
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62Actual vs Sold Hours by Pay Group

Tech 313 Backup

Starting sheet · rows 1–82 of 91 and columns A–J of 15
ABCDEFGHIJ
1Tech 313 Dashboard
2
3May 2026 Closed RO Breakdown
4Tech 313313
5
6MetricValueManual / Payroll HoursValue
7Total Number of ROs Closed17.00Total A/T Clock Hours123.30
8Total Repair Lines Completed26.00Training Hours for Month15.90
9RO Actual Hours65.04Shop Hours for Month2.20
10RO Sold Hours76.64Paid Hours Not on RO58.26
11RO Gain/Loss Hours11.60Unaccounted Paid Hours40.16
12RO Efficiency %117.8%Combined Efficiency %76.8%
13
14
15Sold Hours BreakdownHours
16RO Sold Hours76.64
17Training Hours15.90
18Shop Hours2.20
19Total Sold + Training + Shop94.74
20
21
22Actual Time Capture
23Total A/T Clock HoursActual Hours on ROsDifference: Clocked - RO Actual
24123.3065.0458.26
25
26
27Pay Group Detail
28Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
29Customer Pay7.0067.6015.808.2011.7%20.6%35.3%
30Internal4.0048.548.540.0013.1%11.1%23.5%
31PDI0.0000.000.000.000.0%0.0%0.0%
32Warranty12.00646.9029.50-17.4072.1%38.5%35.3%
33Extended Warranty3.0022.0022.8020.803.1%29.7%11.8%
34
35Charts
36Work Mix chart shows each pay group's share of this tech's closed RO count. Actual vs Sold compares hours by pay group.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58Technician Work Mix by Pay Group
59MetricCustomer PayInternalPDIWarrantyExtended Warranty
60ROs Closed64062
61% of Closed ROs35.3%23.5%0.0%35.3%11.8%
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82

Tech 332

Starting sheet · rows 1–63 of 136 and columns A–M of 18
ABCDEFGHIJKLM
1Tech 332 Dashboard
2
3MetricValueSold Hours BreakdownHoursManual / Payroll HoursValue
4Total Number of ROs Closed8332RO Sold Hours6.9Total A/T Clock Hours33.2
5Total Repair Lines Completed13Training Hours0.0Training Hours for Month0.0
6RO Actual Hours5.9Shop Hours0.0Shop Hours for Month0.0
7RO Sold Hours6.9Total Sold + Training + Shop6.9Paid Hours Not on RO27.3
8RO Gain/Loss Hours1.0Unaccounted Paid Hours27.3
9RO Efficiency %117%Combined Efficiency %21%
10
11
12Pay Group Detail
13Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
14Customer Pay1165.106.101.0086.4%88.4%75.0%Metric
15Internal110.400.400.006.8%5.8%12.5%Total A/T Clock Hours
16PDI000.000.000.000.0%0.0%0.0%Actual Hours on ROs
17Warranty110.400.400.006.8%5.8%12.5%
18Extended Warranty000.000.000.000.0%0.0%0.0%
19Charts
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41Technician Work Mix by Pay GroupActual Time Capture
42MetricCustomer PayInternalPDIWarrantyExtended WarrantyTotal A/T HoursActual Hours on ROsDifference: Clocked - RO ActualRO Act Capture %
43ROs Closed6101033.25.9-27.318%
44% of Closed ROs75%13%0%13%0%
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62Actual vs Sold Hours by Pay Group
63MetricCustomer PayInternalPDIWarrantyExt Warranty

Tech 331

Starting sheet · rows 1–63 of 136 and columns A–M of 18
ABCDEFGHIJKLM
1Tech 331 Dashboard
2
3MetricValueSold Hours BreakdownHoursManual / Payroll HoursValue
4Total Number of ROs Closed20.00331RO Sold Hours64.70Total A/T Clock Hours153.42
5Total Repair Lines Completed26.00Training Hours0.00Training Hours for Month0.00
6RO Actual Hours107.44Shop Hours2.50Shop Hours for Month2.50
7RO Sold Hours64.70Total Sold + Training + Shop67.20Paid Hours Not on RO45.98
8RO Gain/Loss Hours-42.74Unaccounted Paid Hours43.48
9RO Efficiency %60.2%Combined Efficiency %43.8%
10
11
12Pay Group Detail
13Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
14Customer Pay12822.6720.30-2.3721.1%31.4%40.0%Metric
15Internal666.268.402.145.8%13.0%30.0%Total A/T Clock Hours
16PDI111.301.300.001.2%2.0%5.0%Actual Hours on ROs
17Warranty5449.3023.80-25.5045.9%36.8%20.0%
18Extended Warranty2227.9110.90-17.0126.0%16.8%10.0%
19Charts
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41Technician Work Mix by Pay Group
42MetricCustomer PayInternalPDIWarrantyExtended WarrantyTotal A/T HoursActual Hours on ROsDifference: Clocked - RO ActualRO Act Capture %
43ROs Closed86142153.4107.4-46.070%
44% of Closed ROs40%30%5%20%10%
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62Actual vs Sold Hours by Pay Group
63MetricCustomer PayInternalPDIWarrantyExt Warranty

Tech 329

Starting sheet · rows 1–63 of 136 and columns A–M of 18
ABCDEFGHIJKLM
1Tech 329 Dashboard
2
3MetricValueSold Hours BreakdownHoursManual / Payroll HoursValue
4Total Number of ROs Closed37.00329RO Sold Hours115.80Total A/T Clock Hours158.02
5Total Repair Lines Completed59.00Training Hours2.60Training Hours for Month2.60
6RO Actual Hours101.83Shop Hours2.50Shop Hours for Month2.50
7RO Sold Hours115.80Total Sold + Training + Shop120.90Paid Hours Not on RO56.19
8RO Gain/Loss Hours13.97Unaccounted Paid Hours51.09
9RO Efficiency %113.7%Combined Efficiency %76.5%
10
11
12Pay Group Detail
13Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
14Customer Pay251738.8444.405.5638.1%38.3%45.9%Metric
15Internal221432.7038.505.8032.1%33.2%37.8%Total A/T Clock Hours
16PDI000.000.000.000.0%0.0%0.0%Actual Hours on ROs
17Warranty1078.028.300.287.9%7.2%18.9%
18Extended Warranty2222.2724.602.3321.9%21.2%5.4%
19Charts
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41Technician Work Mix by Pay Group
42MetricCustomer PayInternalPDIWarrantyExtended WarrantyTotal A/T HoursActual Hours on ROsDifference: Clocked - RO ActualRO Act Capture %
43ROs Closed1714072158.0101.8-56.264%
44% of Closed ROs46%38%0%19%5%
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62Actual vs Sold Hours by Pay Group
63MetricCustomer PayInternalPDIWarrantyExt Warranty

Tech 327

Starting sheet · rows 1–63 of 136 and columns A–M of 18
ABCDEFGHIJKLM
1Tech 327 Dashboard
2
3MetricValueSold Hours BreakdownHoursManual / Payroll HoursValue
432773.00309RO Sold Hours92.61Total A/T Clock Hours165.12
5Total Repair Lines Completed135.00Training Hours0.20Training Hours for Month0.20
6RO Actual Hours97.66Shop Hours2.50Shop Hours for Month2.50
7RO Sold Hours92.61Total Sold + Training + Shop95.31Paid Hours Not on RO67.46
8RO Gain/Loss Hours-5.05Unaccounted Paid Hours64.76
9RO Efficiency %94.8%Combined Efficiency %57.7%
10
11
12Pay Group Detail
13Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
14Customer Pay8816.7814.60-2.1817.2%15.8%11.0%Metric
15Internal452239.8040.200.4040.8%43.4%30.1%Total A/T Clock Hours
16PDI131316.7016.10-0.6017.1%17.4%17.8%Actual Hours on ROs
17Warranty693024.3821.71-2.6725.0%23.4%41.1%
18Extended Warranty000.000.000.000.0%0.0%0.0%
19Charts
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41Technician Work Mix by Pay Group
42MetricCustomer PayInternalPDIWarrantyExtended WarrantyTotal A/T HoursActual Hours on ROsDifference: Clocked - RO ActualRO Act Capture %
43ROs Closed82213300165.197.7-67.559%
44% of Closed ROs11%30%18%41%0%
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62Actual vs Sold Hours by Pay Group
63MetricCustomer PayInternalPDIWarrantyExt Warranty

Tech 313

Starting sheet · rows 1–63 of 136 and columns A–M of 18
ABCDEFGHIJKLM
1Tech 313 Dashboard
2
3MetricValueSold Hours BreakdownHoursManual / Payroll HoursValue
4Total Number of ROs Closed17RO Sold Hours76.6Total A/T Clock Hours123.3
5Total Repair Lines Completed26Training Hours15.9Training Hours for Month15.9
6RO Actual Hours65.0Shop Hours2.2Shop Hours for Month2.2
7RO Sold Hours76.6Total Sold + Training + Shop94.7Paid Hours Not on RO58.3
8RO Gain/Loss Hours11.6Unaccounted Paid Hours40.2
9RO Efficiency %118%Combined Efficiency %77%
10
11
12Pay Type Detail
13Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
14Customer Pay767.615.88.211.7%20.6%35.3%
15Internal448.58.50.013.1%11.1%23.5%
16PDI000.00.00.00.0%0.0%0.0%
17Warranty12646.929.5-17.472.1%38.5%35.3%
18Extended Warranty322.022.820.83.1%29.7%11.8%
19Charts
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41Technician Work Mix by Pay GroupActual Time Capture
42MetricCustomer PayInternalPDIWarrantyExtended WarrantyTotal A/T HoursActual Hours on ROsDifference: Clocked - RO ActualRO Act Capture %
43ROs Closed64062123.365.0-58.353%
44% of Closed ROs35.3%23.5%0.0%35.3%11.8%
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62Actual vs Sold Hours by Pay Group
63MetricCustomer PayInternalPDIWarrantyExt Warranty

Tech 314

Starting sheet · rows 1–63 of 136 and columns A–M of 18
ABCDEFGHIJKLM
1Tech 314 Dashboard
2
3MetricValueSold Hours BreakdownHoursManual / Payroll HoursValue
4Total Number of ROs Closed82.00314RO Sold Hours93.02Total A/T Clock Hours159.04
5Total Repair Lines Completed121.00Training Hours0.00Training Hours for Month0.00
6RO Actual Hours100.64Shop Hours2.50Shop Hours for Month2.50
7RO Sold Hours93.02Total Sold + Training + Shop95.52Paid Hours Not on RO58.40
8RO Gain/Loss Hours-7.62Unaccounted Paid Hours55.90
9RO Efficiency %92.4%Combined Efficiency %60.1%
10
11
12Pay Group Detail
13Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
14Customer Pay855859.8160.300.4959.4%64.8%70.7%Metric
15Internal181220.2818.02-2.2620.2%19.4%14.6%Total A/T Clock Hours
16PDI444.605.000.404.6%5.4%4.9%Actual Hours on ROs
17Warranty13912.956.30-6.6512.9%6.8%11.0%
18Extended Warranty113.003.400.403.0%3.7%1.2%
19Charts
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41Technician Work Mix by Pay Group
42MetricCustomer PayInternalPDIWarrantyExtended WarrantyTotal A/T HoursActual Hours on ROsDifference: Clocked - RO ActualRO Act Capture %
43ROs Closed5812491159.0100.6-58.463%
44% of Closed ROs71%15%5%11%1%
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62Actual vs Sold Hours by Pay Group
63MetricCustomer PayInternalPDIWarrantyExt Warranty

Tech 314 Backup

Starting sheet · rows 1–82 of 91 and columns A–J of 15
ABCDEFGHIJ
1Tech 314 Dashboard
2
3May 2026 Closed RO Breakdown
4Tech 314314
5
6MetricValueManual / Payroll HoursValue
7Total Number of ROs Closed82.00Total A/T Clock Hours159.04
8Total Repair Lines Completed121.00Training Hours for Month0.00
9RO Actual Hours100.64Shop Hours for Month2.50
10RO Sold Hours93.02Paid Hours Not on RO58.40
11RO Gain/Loss Hours-7.62Unaccounted Paid Hours55.90
12RO Efficiency %92.4%Combined Efficiency %60.1%
13
14
15Sold Hours BreakdownHours
16RO Sold Hours93.02
17Training Hours0.00
18Shop Hours2.50
19Total Sold + Training + Shop95.52
20
21
22Actual Time Capture
23Total A/T Clock HoursActual Hours on ROsDifference: Clocked - RO Actual
24159.04100.6458.40
25
26
27Pay Group Detail
28Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
29Customer Pay85.005859.8160.300.4959.4%64.8%70.7%
30Internal18.001220.2818.02-2.2620.2%19.4%14.6%
31PDI4.0044.605.000.404.6%5.4%4.9%
32Warranty13.00912.956.30-6.6512.9%6.8%11.0%
33Extended Warranty1.0013.003.400.403.0%3.7%1.2%
34
35Charts
36Work Mix chart shows each pay group's share of this tech's closed RO count. Actual vs Sold compares hours by pay group.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58Technician Work Mix by Pay Group
59MetricCustomer PayInternalPDIWarrantyExtended Warranty
60ROs Closed5812491
61% of Closed ROs70.7%14.6%4.9%11.0%1.2%
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82

Tech 327 Backup

Starting sheet · rows 1–82 of 91 and columns A–J of 15
ABCDEFGHIJ
1Tech 327 Dashboard
2
3May 2026 Closed RO Breakdown
4Tech 327327
5
6MetricValueManual / Payroll HoursValue
7Total Number of ROs Closed102.00Total A/T Clock Hours163.29
8Total Repair Lines Completed161.00Training Hours for Month2.50
9RO Actual Hours95.97Shop Hours for Month2.50
10RO Sold Hours119.52Paid Hours Not on RO67.32
11RO Gain/Loss Hours23.55Unaccounted Paid Hours62.32
12RO Efficiency %124.5%Combined Efficiency %76.3%
13
14
15Sold Hours BreakdownHours
16RO Sold Hours119.52
17Training Hours2.50
18Shop Hours2.50
19Total Sold + Training + Shop124.52
20
21
22Actual Time Capture
23Total A/T Clock HoursActual Hours on ROsDifference: Clocked - RO Actual
24163.2995.9767.32
25
26
27Pay Group Detail
28Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
29Customer Pay88.005546.9559.9012.9548.9%50.1%53.9%
30Internal28.002014.8618.904.0415.5%15.8%19.6%
31PDI3.0034.004.000.004.2%3.3%2.9%
32Warranty30.001914.4018.023.6215.0%15.1%18.6%
33Extended Warranty12.001115.7618.702.9416.4%15.6%10.8%
34
35Charts
36Work Mix chart shows each pay group's share of this tech's closed RO count. Actual vs Sold compares hours by pay group.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58Technician Work Mix by Pay Group
59MetricCustomer PayInternalPDIWarrantyExtended Warranty
60ROs Closed552031911
61% of Closed ROs53.9%19.6%2.9%18.6%10.8%
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82

Tech 329 Backup

Starting sheet · rows 1–82 of 91 and columns A–J of 15
ABCDEFGHIJ
1Tech 329 Dashboard
2
3May 2026 Closed RO Breakdown
4Tech 329329
5
6MetricValueManual / Payroll HoursValue
7Total Number of ROs Closed37.00Total A/T Clock Hours158.02
8Total Repair Lines Completed59.00Training Hours for Month2.60
9RO Actual Hours101.83Shop Hours for Month2.50
10RO Sold Hours115.80Paid Hours Not on RO56.19
11RO Gain/Loss Hours13.97Unaccounted Paid Hours51.09
12RO Efficiency %113.7%Combined Efficiency %76.5%
13
14
15Sold Hours BreakdownHours
16RO Sold Hours115.80
17Training Hours2.60
18Shop Hours2.50
19Total Sold + Training + Shop120.90
20
21
22Actual Time Capture
23Total A/T Clock HoursActual Hours on ROsDifference: Clocked - RO Actual
24158.02101.8356.19
25
26
27Pay Group Detail
28Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
29Customer Pay25.001738.8444.405.5638.1%38.3%45.9%
30Internal22.001432.7038.505.8032.1%33.2%37.8%
31PDI0.0000.000.000.000.0%0.0%0.0%
32Warranty10.0078.028.300.287.9%7.2%18.9%
33Extended Warranty2.00222.2724.602.3321.9%21.2%5.4%
34
35Charts
36Work Mix chart shows each pay group's share of this tech's closed RO count. Actual vs Sold compares hours by pay group.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58Technician Work Mix by Pay Group
59MetricCustomer PayInternalPDIWarrantyExtended Warranty
60ROs Closed1714072
61% of Closed ROs45.9%37.8%0.0%18.9%5.4%
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82

Tech 331 Backup

Starting sheet · rows 1–82 of 91 and columns A–J of 15
ABCDEFGHIJ
1Tech 331 Dashboard
2
3May 2026 Closed RO Breakdown
4Tech 331331
5
6MetricValueManual / Payroll HoursValue
7Total Number of ROs Closed20.00Total A/T Clock Hours153.42
8Total Repair Lines Completed26.00Training Hours for Month0.00
9RO Actual Hours107.44Shop Hours for Month2.50
10RO Sold Hours64.70Paid Hours Not on RO45.98
11RO Gain/Loss Hours-42.74Unaccounted Paid Hours43.48
12RO Efficiency %60.2%Combined Efficiency %43.8%
13
14
15Sold Hours BreakdownHours
16RO Sold Hours64.70
17Training Hours0.00
18Shop Hours2.50
19Total Sold + Training + Shop67.20
20
21
22Actual Time Capture
23Total A/T Clock HoursActual Hours on ROsDifference: Clocked - RO Actual
24153.42107.4445.98
25
26
27Pay Group Detail
28Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
29Customer Pay12.00822.6720.30-2.3721.1%31.4%40.0%
30Internal6.0066.268.402.145.8%13.0%30.0%
31PDI1.0011.301.300.001.2%2.0%5.0%
32Warranty5.00449.3023.80-25.5045.9%36.8%20.0%
33Extended Warranty2.00227.9110.90-17.0126.0%16.8%10.0%
34
35Charts
36Work Mix chart shows each pay group's share of this tech's closed RO count. Actual vs Sold compares hours by pay group.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58Technician Work Mix by Pay Group
59MetricCustomer PayInternalPDIWarrantyExtended Warranty
60ROs Closed86142
61% of Closed ROs40.0%30.0%5.0%20.0%10.0%
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82

Tech 332 Backup

Starting sheet · rows 1–82 of 91 and columns A–J of 15
ABCDEFGHIJ
1Tech 332 Dashboard
2
3May 2026 Closed RO Breakdown
4Tech 332332
5
6MetricValueManual / Payroll HoursValue
7Total Number of ROs Closed8.00Total A/T Clock Hours33.16
8Total Repair Lines Completed13.00Training Hours for Month0.00
9RO Actual Hours5.90Shop Hours for Month0.00
10RO Sold Hours6.90Paid Hours Not on RO27.26
11RO Gain/Loss Hours1.00Unaccounted Paid Hours27.26
12RO Efficiency %116.9%Combined Efficiency %20.8%
13
14
15Sold Hours BreakdownHours
16RO Sold Hours6.90
17Training Hours0.00
18Shop Hours0.00
19Total Sold + Training + Shop6.90
20
21
22Actual Time Capture
23Total A/T Clock HoursActual Hours on ROsDifference: Clocked - RO Actual
2433.165.9027.26
25
26
27Pay Group Detail
28Pay GroupJobs PerformedROs ClosedActual HrsSold HrsGain/Loss% of Actual% of SoldWork Mix
29Customer Pay11.0065.106.101.0086.4%88.4%75.0%
30Internal1.0010.400.400.006.8%5.8%12.5%
31PDI0.0000.000.000.000.0%0.0%0.0%
32Warranty1.0010.400.400.006.8%5.8%12.5%
33Extended Warranty0.0000.000.000.000.0%0.0%0.0%
34
35Charts
36Work Mix chart shows each pay group's share of this tech's closed RO count. Actual vs Sold compares hours by pay group.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58Technician Work Mix by Pay Group
59MetricCustomer PayInternalPDIWarrantyExtended Warranty
60ROs Closed61010
61% of Closed ROs75.0%12.5%0.0%12.5%0.0%
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82

Expected result

How each AI configuration did

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

Pass criteria

All must be met, checked by an LLM judge.
  • Chart 2's labels show whole percentages, like 47%
  • The chart's data is unchanged, however the format is set
  • The other charts and data are untouched

In Google Sheets, importing the workbook already shows Chart 2's labels as whole percentages, so every Sheets output shows the same chart whatever the assistant did. Sheets verdicts rest on what each assistant changed and said, not on the chart.

Passed 12

Autosheet in Excel Opus 5.5 · Medium

Passed46s · 24¢

Autosheet in Sheets Opus 5.5 · Medium

Passed31s · 24¢

Claude in Excel Opus 5.5 · High

Passed1m 5s · 49¢

Claude in Sheets Opus 5.5 · Medium

Passed33s · 10¢

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed36s · N/A

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed57s · N/A

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed40s · N/A

Autosheet in Sheets Haiku 5.5 · High

Passed24s · 0.3¢

Claude in Excel Haiku 5.5 · High

Passed37s · 2¢

Claude in Sheets Haiku 5.5 · High

Passed1m 6s · 2¢

ChatGPT + Drive MCP GPT-6 · Medium

Passed58s · N/A

Gemini in Sheets Auto

Passed3m 41s · N/A

Failed 10

Autosheet in Excel GPT-6 Astra · Low

Failed41s · 24¢

Why it failed: Chart 2 still displays labels with two decimal places (47.31%, 23.65%, 6.29%, 22.75%, 0.00%) as visible in the final chart and document images.

Autosheet in Excel Sonnet 5.5 · Medium

Failed7s · 3¢

Why it failed: Actual chart image Chart 1 still displays labels with two decimal places (47.31%, 23.65%, 6.29%, 22.75%, 0.00%) rather than whole percentages.

Autosheet in Excel Haiku 5.5 · High

Failed41s · 0.6¢

Why it failed: Chart 2 labels still show two decimal places ('47.31%', '23.65%', '6.29%', '22.75%', '0.00%') rather than whole percentages.

Autosheet in Excel GPT-6.1 Sol · Medium

Failed12s · 4¢

Why it failed: Chart 2 continues to display percentages with two decimal places (47.31%, 23.65%, 6.29%, 22.75%, 0.00%) rather than whole percentages.

ChatGPT in Excel GPT-6 Astra · Medium

Failed25s · 47¢

Why it failed: Chart 2 labels still display two decimal places ('47,31%', '23,65%', '6,29%', '22,75%', '0,00%') instead of whole percentages.

Autosheet in Excel GPT-6 Luna · High

Failed27s · 0.6¢

Why it failed: The data labels on Chart 2 still show two decimal places (47,31%, 23,65%, 6,29%, 22,75%, 0,00%) instead of whole percentages.

Copilot in Excel Auto

Failed19s · N/A

Why it failed: Actual chart image 'Chart 1' clearly shows labels with two decimal places (47,31%, 23,65%, 6,29%, 22,75%, 0,00%) rather than whole percentages.

ChatGPT in Excel GPT-6 Luna · High

Failed39s · 0.6¢

Why it failed: Chart 2 still displays labels with two decimal places (47,31%, 23,65%, 6,29%, 22,75%, 0,00%) rather than whole percentages (47%, 24%, 6%, 23%, 0%).

ChatGPT in Sheets GPT-6 Astra · Medium

Failed20s · 27¢

Why it failed: The agent explicitly refused to perform the chart label formatting, stating it lacked the tools to do so.

ChatGPT in Sheets GPT-6 Luna · High

Failed47s · 0.5¢

Why it failed: The assistant refused the request stating available controls did not expose data-label formatting and explicitly confirmed no changes were made.