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
Make Chart 2 labels whole percentage
Data
Starting sheet · rows 1–21 of 1,000 and columns A–J of 21| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | RO Number | Booked Date | Closed Date | Store/Area | Tech Number | Line | Sequence | M | HT | SC |
| 2 | 359470 | 46127 | 46163 | S1 | 309 | A | 1 | * | ST | |
| 3 | 359470 | 46163 | 46163 | S1 | 309 | A | 1 | * | ST | |
| 4 | 359475 | 46169 | 46169 | S1 | 309 | A | 1 | ST | ||
| 5 | 359475 | 46169 | 46169 | S1 | 309 | C | 3 | ST | ||
| 6 | 359916 | 46115 | 46147 | S1 | 309 | A | 1 | * | ST | |
| 7 | 359916 | 46147 | 46147 | S1 | 309 | A | 1 | * | ST | |
| 8 | 359933 | 46160 | 46160 | S1 | 309 | A | 1 | * | ST | |
| 9 | 359973 | 46157 | 46157 | S1 | 309 | B | 2 | ST | ||
| 10 | 360031 | 46157 | 46157 | S1 | 309 | B | 2 | ST | ||
| 11 | 360031 | 46157 | 46157 | S1 | 309 | C | 3 | ST | ||
| 12 | 360031 | 46157 | 46157 | S1 | 309 | D | 4 | ST | ||
| 13 | 360276 | 46150 | 46150 | S1 | 309 | A | 1 | ST | ||
| 14 | 360276 | 46150 | 46150 | S1 | 309 | A | 2 | ST | ||
| 15 | 360277 | 46150 | 46153 | S1 | 309 | A | 1 | * | ST | |
| 16 | 360277 | 46153 | 46153 | S1 | 309 | A | 1 | * | ST | |
| 17 | 360277 | 46150 | 46153 | S1 | 309 | B | 2 | * | ST | |
| 18 | 360277 | 46153 | 46153 | S1 | 309 | B | 2 | * | ST | |
| 19 | 360279 | 46162 | 46162 | S1 | 309 | A | 1 | * | ST | |
| 20 | 360310 | 46147 | 46147 | S1 | 309 | A | 1 | ST | ||
| 21 | 360310 | 46147 | 46147 | S1 | 309 | B | 2 | ST |
Manual Inputs
Starting sheet| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Store Manual Inputs | ||||
| 2 | |||||
| 3 | Tech Number | Tech Name | Total A/T Clock Hours | Training Hours | Shop Hours |
| 4 | 309 | Tech 309 | 165.12 | 0.20 | 2.50 |
| 5 | 313 | Tech 313 | 123.30 | 15.90 | 2.20 |
| 6 | 314 | Tech 314 | 159.04 | 0.00 | 2.50 |
| 7 | 327 | Tech 327 | 163.29 | 2.50 | 2.50 |
| 8 | 329 | Tech 329 | 158.02 | 2.60 | 2.50 |
| 9 | 331 | Tech 331 | 153.42 | 0.00 | 2.50 |
| 10 | 332 | Tech 332 | 33.16 | 0.00 | 0.00 |
| 11 | |||||
| 12 | Enter/change the yellow cells above. Each tech dashboard pulls from this tab automatically. | ||||
| 13 | |||||
| 14 | Each 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| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Store Summary - May 2026 | |||||||||||||
| 2 | Combined Shop Dashboard | |||||||||||||
| 3 | ||||||||||||||
| 4 | Metric | Sold Hours Breakdown | Hours | Manual / Payroll Hours | Value | |||||||||
| 5 | Total Number of ROs Closed | 339 | RO Sold Hours | 569.2 | Total A/T Clock Hours | 955.4 | ||||||||
| 6 | Total Repair Lines Completed | 541 | Training Hours | 21.2 | Training Hours for Month | 21.2 | ||||||||
| 7 | RO Actual Hours | 574.5 | Shop Hours | 14.7 | Shop Hours for Month | 14.7 | ||||||||
| 8 | RO Sold Hours | 569.2 | Total Sold + Training + Shop | 605.1 | Paid Hours Not on RO | 380.9 | ||||||||
| 9 | RO Gain/Loss Hours | -5.3 | Unaccounted Paid Hours | 345.0 | ||||||||||
| 10 | RO Efficiency % | 99% | Combined Efficiency % | 63% | ||||||||||
| 11 | ||||||||||||||
| 12 | ||||||||||||||
| 13 | Pay Type Detail | |||||||||||||
| 14 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | |||||
| 15 | Customer Pay | 236 | 158 | 197.8 | 221.4 | 23.7 | 34.4% | 38.9% | 47.3% | |||||
| 16 | Internal | 124 | 79 | 122.8 | 133.0 | 10.1 | 21.4% | 23.4% | 23.7% | |||||
| 17 | PDI | 21 | 21 | 26.6 | 26.4 | -0.2 | 4.6% | 4.6% | 6.3% | |||||
| 18 | Warranty | 140 | 76 | 156.4 | 108.0 | -48.3 | 27.2% | 19.0% | 22.8% | |||||
| 19 | Ext Warranty | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0% | 0.0% | 0.0% | |||||
| 20 | Technician Breakdown | |||||||||||||
| 21 | Tech | Tech No | ROs Closed | Jobs Performed | RO Actual | RO Sold | Gain/Loss | Efficiency | Clock Hours | RO Actual Capture % | Combined Efficiency | |||
| 22 | Tech 309 | 309 | 73 | 135.0 | 97.7 | 92.6 | -5.05 | 94.8% | 165.12 | 0% | 58% | |||
| 23 | Tech 313 | 313 | 17 | 26.0 | 65.0 | 76.6 | 11.60 | 117.8% | 123.3 | 53% | 77% | |||
| 24 | Tech 314 | 314 | 82 | 121.0 | 100.6 | 93.0 | -7.62 | 92.4% | 159.04 | 63% | 60% | |||
| 25 | Tech 327 | 327 | 102 | 161.0 | 96.0 | 119.5 | 23.55 | 124.5% | 163.29 | 59% | 76% | |||
| 26 | Tech 329 | 329 | 37 | 59.0 | 101.8 | 115.8 | 13.97 | 113.7% | 158.02 | 64% | 77% | |||
| 27 | Tech 331 | 331 | 20 | 26.0 | 107.4 | 64.7 | -42.74 | 60.2% | 153.42 | 70% | 44% | |||
| 28 | Tech 332 | 332 | 8 | 13.0 | 5.9 | 6.9 | 1.00 | 116.9% | 33.16 | 18% | 21% | |||
| 29 | ||||||||||||||
| 30 | ||||||||||||||
| 31 | Charts | |||||||||||||
| 32 | ||||||||||||||
| 33 | ||||||||||||||
| 34 | ||||||||||||||
| 35 | ||||||||||||||
| 36 | ||||||||||||||
| 37 | ||||||||||||||
| 38 | ||||||||||||||
| 39 | ||||||||||||||
| 40 | ||||||||||||||
| 41 | ||||||||||||||
| 42 | ||||||||||||||
| 43 | ||||||||||||||
| 44 | ||||||||||||||
| 45 | ||||||||||||||
| 46 | ||||||||||||||
| 47 | ||||||||||||||
| 48 | ||||||||||||||
| 49 | ||||||||||||||
| 50 | ||||||||||||||
| 51 | ||||||||||||||
| 52 | ||||||||||||||
| 53 | Technician Work Mix by Pay Group (% of Closed ROs) | Actual Time Capture | ||||||||||||
| 54 | Customer Pay | Internal | PDI | Warranty | Extended Warranty | Total A/T Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | RO Act Capture % | |||||
| 55 | ROs Closed | 158 | 79 | 21 | 76 | 0 | 955.4 | 574.5 | -380.9 | 60.1% | ||||
| 56 | Work 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 | ||||||||||||||
| 72 | Actual vs Sold Hours by Pay Group | |||||||||||||
| 73 | Metric | Cust Pay | Internal | PDI | Warranty | Ext Warranty |
Tech 309
Starting sheet · rows 1–62 of 136 and columns A–M of 18| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 309 Dashboard | ||||||||||||
| 2 | |||||||||||||
| 3 | Metric | Value | Sold Hours Breakdown | Hours | Manual / Payroll Hours | Value | |||||||
| 4 | Total Number of ROs Closed | 73 | RO Sold Hours | 92.6 | Total A/T Clock Hours | 165.1 | |||||||
| 5 | Total Repair Lines Completed | 135 | Training Hours | 0.2 | Training Hours for Month | 0.2 | |||||||
| 6 | RO Actual Hours | 97.7 | Shop Hours | 2.5 | Shop Hours for Month | 2.5 | |||||||
| 7 | RO Sold Hours | 92.6 | Total Sold + Training + Shop | 95.3 | Paid Hours Not on RO | 67.5 | |||||||
| 8 | RO Gain/Loss Hours | -5.0 | Unaccounted Paid Hours | 64.8 | |||||||||
| 9 | RO Efficiency % | 95% | Combined Efficiency % | 58% | |||||||||
| 10 | |||||||||||||
| 11 | |||||||||||||
| 12 | Pay Type Detail | ||||||||||||
| 13 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | ||||
| 14 | Customer Pay | 8 | 8 | 16.8 | 14.6 | -2.2 | 17.2% | 15.8% | 11.0% | ||||
| 15 | Internal | 45 | 22 | 39.8 | 40.2 | 0.4 | 40.8% | 43.4% | 30.1% | ||||
| 16 | PDI | 13 | 13 | 16.7 | 16.1 | -0.6 | 17.1% | 17.4% | 17.8% | ||||
| 17 | Warranty | 69 | 30 | 24.4 | 21.7 | -2.7 | 25.0% | 23.4% | 41.1% | ||||
| 18 | Extended Warranty | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0% | 0.0% | 0.0% | ||||
| 19 | Charts | ||||||||||||
| 20 | |||||||||||||
| 21 | |||||||||||||
| 22 | |||||||||||||
| 23 | |||||||||||||
| 24 | |||||||||||||
| 25 | |||||||||||||
| 26 | |||||||||||||
| 27 | |||||||||||||
| 28 | |||||||||||||
| 29 | |||||||||||||
| 30 | |||||||||||||
| 31 | |||||||||||||
| 32 | |||||||||||||
| 33 | |||||||||||||
| 34 | |||||||||||||
| 35 | |||||||||||||
| 36 | |||||||||||||
| 37 | |||||||||||||
| 38 | |||||||||||||
| 39 | |||||||||||||
| 40 | |||||||||||||
| 41 | Technician Work Mix by Pay Group | Actual Time Capture | |||||||||||
| 42 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | Total A/T Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | RO Act Capture % | |||
| 43 | ROs Closed | 8 | 22 | 13 | 30 | 0 | 165.1 | 97.7 | -67.5 | 59.1% | |||
| 44 | % of Closed ROs | 11% | 30% | 18% | 41% | 0% | |||||||
| 45 | |||||||||||||
| 46 | |||||||||||||
| 47 | |||||||||||||
| 48 | |||||||||||||
| 49 | |||||||||||||
| 50 | |||||||||||||
| 51 | |||||||||||||
| 52 | |||||||||||||
| 53 | |||||||||||||
| 54 | |||||||||||||
| 55 | |||||||||||||
| 56 | |||||||||||||
| 57 | |||||||||||||
| 58 | |||||||||||||
| 59 | |||||||||||||
| 60 | |||||||||||||
| 61 | |||||||||||||
| 62 | Actual vs Sold Hours by Pay Group |
Tech 313 Backup
Starting sheet · rows 1–82 of 91 and columns A–J of 15| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 313 Dashboard | |||||||||
| 2 | ||||||||||
| 3 | May 2026 Closed RO Breakdown | |||||||||
| 4 | Tech 313 | 313 | ||||||||
| 5 | ||||||||||
| 6 | Metric | Value | Manual / Payroll Hours | Value | ||||||
| 7 | Total Number of ROs Closed | 17.00 | Total A/T Clock Hours | 123.30 | ||||||
| 8 | Total Repair Lines Completed | 26.00 | Training Hours for Month | 15.90 | ||||||
| 9 | RO Actual Hours | 65.04 | Shop Hours for Month | 2.20 | ||||||
| 10 | RO Sold Hours | 76.64 | Paid Hours Not on RO | 58.26 | ||||||
| 11 | RO Gain/Loss Hours | 11.60 | Unaccounted Paid Hours | 40.16 | ||||||
| 12 | RO Efficiency % | 117.8% | Combined Efficiency % | 76.8% | ||||||
| 13 | ||||||||||
| 14 | ||||||||||
| 15 | Sold Hours Breakdown | Hours | ||||||||
| 16 | RO Sold Hours | 76.64 | ||||||||
| 17 | Training Hours | 15.90 | ||||||||
| 18 | Shop Hours | 2.20 | ||||||||
| 19 | Total Sold + Training + Shop | 94.74 | ||||||||
| 20 | ||||||||||
| 21 | ||||||||||
| 22 | Actual Time Capture | |||||||||
| 23 | Total A/T Clock Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | |||||||
| 24 | 123.30 | 65.04 | 58.26 | |||||||
| 25 | ||||||||||
| 26 | ||||||||||
| 27 | Pay Group Detail | |||||||||
| 28 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | |
| 29 | Customer Pay | 7.00 | 6 | 7.60 | 15.80 | 8.20 | 11.7% | 20.6% | 35.3% | |
| 30 | Internal | 4.00 | 4 | 8.54 | 8.54 | 0.00 | 13.1% | 11.1% | 23.5% | |
| 31 | PDI | 0.00 | 0 | 0.00 | 0.00 | 0.00 | 0.0% | 0.0% | 0.0% | |
| 32 | Warranty | 12.00 | 6 | 46.90 | 29.50 | -17.40 | 72.1% | 38.5% | 35.3% | |
| 33 | Extended Warranty | 3.00 | 2 | 2.00 | 22.80 | 20.80 | 3.1% | 29.7% | 11.8% | |
| 34 | ||||||||||
| 35 | Charts | |||||||||
| 36 | Work 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 | ||||||||||
| 58 | Technician Work Mix by Pay Group | |||||||||
| 59 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | ||||
| 60 | ROs Closed | 6 | 4 | 0 | 6 | 2 | ||||
| 61 | % of Closed ROs | 35.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| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 332 Dashboard | ||||||||||||
| 2 | |||||||||||||
| 3 | Metric | Value | Sold Hours Breakdown | Hours | Manual / Payroll Hours | Value | |||||||
| 4 | Total Number of ROs Closed | 8 | 332 | RO Sold Hours | 6.9 | Total A/T Clock Hours | 33.2 | ||||||
| 5 | Total Repair Lines Completed | 13 | Training Hours | 0.0 | Training Hours for Month | 0.0 | |||||||
| 6 | RO Actual Hours | 5.9 | Shop Hours | 0.0 | Shop Hours for Month | 0.0 | |||||||
| 7 | RO Sold Hours | 6.9 | Total Sold + Training + Shop | 6.9 | Paid Hours Not on RO | 27.3 | |||||||
| 8 | RO Gain/Loss Hours | 1.0 | Unaccounted Paid Hours | 27.3 | |||||||||
| 9 | RO Efficiency % | 117% | Combined Efficiency % | 21% | |||||||||
| 10 | |||||||||||||
| 11 | |||||||||||||
| 12 | Pay Group Detail | ||||||||||||
| 13 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | ||||
| 14 | Customer Pay | 11 | 6 | 5.10 | 6.10 | 1.00 | 86.4% | 88.4% | 75.0% | Metric | |||
| 15 | Internal | 1 | 1 | 0.40 | 0.40 | 0.00 | 6.8% | 5.8% | 12.5% | Total A/T Clock Hours | |||
| 16 | PDI | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.0% | 0.0% | 0.0% | Actual Hours on ROs | |||
| 17 | Warranty | 1 | 1 | 0.40 | 0.40 | 0.00 | 6.8% | 5.8% | 12.5% | ||||
| 18 | Extended Warranty | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.0% | 0.0% | 0.0% | ||||
| 19 | Charts | ||||||||||||
| 20 | |||||||||||||
| 21 | |||||||||||||
| 22 | |||||||||||||
| 23 | |||||||||||||
| 24 | |||||||||||||
| 25 | |||||||||||||
| 26 | |||||||||||||
| 27 | |||||||||||||
| 28 | |||||||||||||
| 29 | |||||||||||||
| 30 | |||||||||||||
| 31 | |||||||||||||
| 32 | |||||||||||||
| 33 | |||||||||||||
| 34 | |||||||||||||
| 35 | |||||||||||||
| 36 | |||||||||||||
| 37 | |||||||||||||
| 38 | |||||||||||||
| 39 | |||||||||||||
| 40 | |||||||||||||
| 41 | Technician Work Mix by Pay Group | Actual Time Capture | |||||||||||
| 42 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | Total A/T Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | RO Act Capture % | |||
| 43 | ROs Closed | 6 | 1 | 0 | 1 | 0 | 33.2 | 5.9 | -27.3 | 18% | |||
| 44 | % of Closed ROs | 75% | 13% | 0% | 13% | 0% | |||||||
| 45 | |||||||||||||
| 46 | |||||||||||||
| 47 | |||||||||||||
| 48 | |||||||||||||
| 49 | |||||||||||||
| 50 | |||||||||||||
| 51 | |||||||||||||
| 52 | |||||||||||||
| 53 | |||||||||||||
| 54 | |||||||||||||
| 55 | |||||||||||||
| 56 | |||||||||||||
| 57 | |||||||||||||
| 58 | |||||||||||||
| 59 | |||||||||||||
| 60 | |||||||||||||
| 61 | |||||||||||||
| 62 | Actual vs Sold Hours by Pay Group | ||||||||||||
| 63 | Metric | Customer Pay | Internal | PDI | Warranty | Ext Warranty |
Tech 331
Starting sheet · rows 1–63 of 136 and columns A–M of 18| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 331 Dashboard | ||||||||||||
| 2 | |||||||||||||
| 3 | Metric | Value | Sold Hours Breakdown | Hours | Manual / Payroll Hours | Value | |||||||
| 4 | Total Number of ROs Closed | 20.00 | 331 | RO Sold Hours | 64.70 | Total A/T Clock Hours | 153.42 | ||||||
| 5 | Total Repair Lines Completed | 26.00 | Training Hours | 0.00 | Training Hours for Month | 0.00 | |||||||
| 6 | RO Actual Hours | 107.44 | Shop Hours | 2.50 | Shop Hours for Month | 2.50 | |||||||
| 7 | RO Sold Hours | 64.70 | Total Sold + Training + Shop | 67.20 | Paid Hours Not on RO | 45.98 | |||||||
| 8 | RO Gain/Loss Hours | -42.74 | Unaccounted Paid Hours | 43.48 | |||||||||
| 9 | RO Efficiency % | 60.2% | Combined Efficiency % | 43.8% | |||||||||
| 10 | |||||||||||||
| 11 | |||||||||||||
| 12 | Pay Group Detail | ||||||||||||
| 13 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | ||||
| 14 | Customer Pay | 12 | 8 | 22.67 | 20.30 | -2.37 | 21.1% | 31.4% | 40.0% | Metric | |||
| 15 | Internal | 6 | 6 | 6.26 | 8.40 | 2.14 | 5.8% | 13.0% | 30.0% | Total A/T Clock Hours | |||
| 16 | PDI | 1 | 1 | 1.30 | 1.30 | 0.00 | 1.2% | 2.0% | 5.0% | Actual Hours on ROs | |||
| 17 | Warranty | 5 | 4 | 49.30 | 23.80 | -25.50 | 45.9% | 36.8% | 20.0% | ||||
| 18 | Extended Warranty | 2 | 2 | 27.91 | 10.90 | -17.01 | 26.0% | 16.8% | 10.0% | ||||
| 19 | Charts | ||||||||||||
| 20 | |||||||||||||
| 21 | |||||||||||||
| 22 | |||||||||||||
| 23 | |||||||||||||
| 24 | |||||||||||||
| 25 | |||||||||||||
| 26 | |||||||||||||
| 27 | |||||||||||||
| 28 | |||||||||||||
| 29 | |||||||||||||
| 30 | |||||||||||||
| 31 | |||||||||||||
| 32 | |||||||||||||
| 33 | |||||||||||||
| 34 | |||||||||||||
| 35 | |||||||||||||
| 36 | |||||||||||||
| 37 | |||||||||||||
| 38 | |||||||||||||
| 39 | |||||||||||||
| 40 | |||||||||||||
| 41 | Technician Work Mix by Pay Group | ||||||||||||
| 42 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | Total A/T Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | RO Act Capture % | |||
| 43 | ROs Closed | 8 | 6 | 1 | 4 | 2 | 153.4 | 107.4 | -46.0 | 70% | |||
| 44 | % of Closed ROs | 40% | 30% | 5% | 20% | 10% | |||||||
| 45 | |||||||||||||
| 46 | |||||||||||||
| 47 | |||||||||||||
| 48 | |||||||||||||
| 49 | |||||||||||||
| 50 | |||||||||||||
| 51 | |||||||||||||
| 52 | |||||||||||||
| 53 | |||||||||||||
| 54 | |||||||||||||
| 55 | |||||||||||||
| 56 | |||||||||||||
| 57 | |||||||||||||
| 58 | |||||||||||||
| 59 | |||||||||||||
| 60 | |||||||||||||
| 61 | |||||||||||||
| 62 | Actual vs Sold Hours by Pay Group | ||||||||||||
| 63 | Metric | Customer Pay | Internal | PDI | Warranty | Ext Warranty |
Tech 329
Starting sheet · rows 1–63 of 136 and columns A–M of 18| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 329 Dashboard | ||||||||||||
| 2 | |||||||||||||
| 3 | Metric | Value | Sold Hours Breakdown | Hours | Manual / Payroll Hours | Value | |||||||
| 4 | Total Number of ROs Closed | 37.00 | 329 | RO Sold Hours | 115.80 | Total A/T Clock Hours | 158.02 | ||||||
| 5 | Total Repair Lines Completed | 59.00 | Training Hours | 2.60 | Training Hours for Month | 2.60 | |||||||
| 6 | RO Actual Hours | 101.83 | Shop Hours | 2.50 | Shop Hours for Month | 2.50 | |||||||
| 7 | RO Sold Hours | 115.80 | Total Sold + Training + Shop | 120.90 | Paid Hours Not on RO | 56.19 | |||||||
| 8 | RO Gain/Loss Hours | 13.97 | Unaccounted Paid Hours | 51.09 | |||||||||
| 9 | RO Efficiency % | 113.7% | Combined Efficiency % | 76.5% | |||||||||
| 10 | |||||||||||||
| 11 | |||||||||||||
| 12 | Pay Group Detail | ||||||||||||
| 13 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | ||||
| 14 | Customer Pay | 25 | 17 | 38.84 | 44.40 | 5.56 | 38.1% | 38.3% | 45.9% | Metric | |||
| 15 | Internal | 22 | 14 | 32.70 | 38.50 | 5.80 | 32.1% | 33.2% | 37.8% | Total A/T Clock Hours | |||
| 16 | PDI | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.0% | 0.0% | 0.0% | Actual Hours on ROs | |||
| 17 | Warranty | 10 | 7 | 8.02 | 8.30 | 0.28 | 7.9% | 7.2% | 18.9% | ||||
| 18 | Extended Warranty | 2 | 2 | 22.27 | 24.60 | 2.33 | 21.9% | 21.2% | 5.4% | ||||
| 19 | Charts | ||||||||||||
| 20 | |||||||||||||
| 21 | |||||||||||||
| 22 | |||||||||||||
| 23 | |||||||||||||
| 24 | |||||||||||||
| 25 | |||||||||||||
| 26 | |||||||||||||
| 27 | |||||||||||||
| 28 | |||||||||||||
| 29 | |||||||||||||
| 30 | |||||||||||||
| 31 | |||||||||||||
| 32 | |||||||||||||
| 33 | |||||||||||||
| 34 | |||||||||||||
| 35 | |||||||||||||
| 36 | |||||||||||||
| 37 | |||||||||||||
| 38 | |||||||||||||
| 39 | |||||||||||||
| 40 | |||||||||||||
| 41 | Technician Work Mix by Pay Group | ||||||||||||
| 42 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | Total A/T Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | RO Act Capture % | |||
| 43 | ROs Closed | 17 | 14 | 0 | 7 | 2 | 158.0 | 101.8 | -56.2 | 64% | |||
| 44 | % of Closed ROs | 46% | 38% | 0% | 19% | 5% | |||||||
| 45 | |||||||||||||
| 46 | |||||||||||||
| 47 | |||||||||||||
| 48 | |||||||||||||
| 49 | |||||||||||||
| 50 | |||||||||||||
| 51 | |||||||||||||
| 52 | |||||||||||||
| 53 | |||||||||||||
| 54 | |||||||||||||
| 55 | |||||||||||||
| 56 | |||||||||||||
| 57 | |||||||||||||
| 58 | |||||||||||||
| 59 | |||||||||||||
| 60 | |||||||||||||
| 61 | |||||||||||||
| 62 | Actual vs Sold Hours by Pay Group | ||||||||||||
| 63 | Metric | Customer Pay | Internal | PDI | Warranty | Ext Warranty |
Tech 327
Starting sheet · rows 1–63 of 136 and columns A–M of 18| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 327 Dashboard | ||||||||||||
| 2 | |||||||||||||
| 3 | Metric | Value | Sold Hours Breakdown | Hours | Manual / Payroll Hours | Value | |||||||
| 4 | 327 | 73.00 | 309 | RO Sold Hours | 92.61 | Total A/T Clock Hours | 165.12 | ||||||
| 5 | Total Repair Lines Completed | 135.00 | Training Hours | 0.20 | Training Hours for Month | 0.20 | |||||||
| 6 | RO Actual Hours | 97.66 | Shop Hours | 2.50 | Shop Hours for Month | 2.50 | |||||||
| 7 | RO Sold Hours | 92.61 | Total Sold + Training + Shop | 95.31 | Paid Hours Not on RO | 67.46 | |||||||
| 8 | RO Gain/Loss Hours | -5.05 | Unaccounted Paid Hours | 64.76 | |||||||||
| 9 | RO Efficiency % | 94.8% | Combined Efficiency % | 57.7% | |||||||||
| 10 | |||||||||||||
| 11 | |||||||||||||
| 12 | Pay Group Detail | ||||||||||||
| 13 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | ||||
| 14 | Customer Pay | 8 | 8 | 16.78 | 14.60 | -2.18 | 17.2% | 15.8% | 11.0% | Metric | |||
| 15 | Internal | 45 | 22 | 39.80 | 40.20 | 0.40 | 40.8% | 43.4% | 30.1% | Total A/T Clock Hours | |||
| 16 | PDI | 13 | 13 | 16.70 | 16.10 | -0.60 | 17.1% | 17.4% | 17.8% | Actual Hours on ROs | |||
| 17 | Warranty | 69 | 30 | 24.38 | 21.71 | -2.67 | 25.0% | 23.4% | 41.1% | ||||
| 18 | Extended Warranty | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.0% | 0.0% | 0.0% | ||||
| 19 | Charts | ||||||||||||
| 20 | |||||||||||||
| 21 | |||||||||||||
| 22 | |||||||||||||
| 23 | |||||||||||||
| 24 | |||||||||||||
| 25 | |||||||||||||
| 26 | |||||||||||||
| 27 | |||||||||||||
| 28 | |||||||||||||
| 29 | |||||||||||||
| 30 | |||||||||||||
| 31 | |||||||||||||
| 32 | |||||||||||||
| 33 | |||||||||||||
| 34 | |||||||||||||
| 35 | |||||||||||||
| 36 | |||||||||||||
| 37 | |||||||||||||
| 38 | |||||||||||||
| 39 | |||||||||||||
| 40 | |||||||||||||
| 41 | Technician Work Mix by Pay Group | ||||||||||||
| 42 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | Total A/T Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | RO Act Capture % | |||
| 43 | ROs Closed | 8 | 22 | 13 | 30 | 0 | 165.1 | 97.7 | -67.5 | 59% | |||
| 44 | % of Closed ROs | 11% | 30% | 18% | 41% | 0% | |||||||
| 45 | |||||||||||||
| 46 | |||||||||||||
| 47 | |||||||||||||
| 48 | |||||||||||||
| 49 | |||||||||||||
| 50 | |||||||||||||
| 51 | |||||||||||||
| 52 | |||||||||||||
| 53 | |||||||||||||
| 54 | |||||||||||||
| 55 | |||||||||||||
| 56 | |||||||||||||
| 57 | |||||||||||||
| 58 | |||||||||||||
| 59 | |||||||||||||
| 60 | |||||||||||||
| 61 | |||||||||||||
| 62 | Actual vs Sold Hours by Pay Group | ||||||||||||
| 63 | Metric | Customer Pay | Internal | PDI | Warranty | Ext Warranty |
Tech 313
Starting sheet · rows 1–63 of 136 and columns A–M of 18| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 313 Dashboard | ||||||||||||
| 2 | |||||||||||||
| 3 | Metric | Value | Sold Hours Breakdown | Hours | Manual / Payroll Hours | Value | |||||||
| 4 | Total Number of ROs Closed | 17 | RO Sold Hours | 76.6 | Total A/T Clock Hours | 123.3 | |||||||
| 5 | Total Repair Lines Completed | 26 | Training Hours | 15.9 | Training Hours for Month | 15.9 | |||||||
| 6 | RO Actual Hours | 65.0 | Shop Hours | 2.2 | Shop Hours for Month | 2.2 | |||||||
| 7 | RO Sold Hours | 76.6 | Total Sold + Training + Shop | 94.7 | Paid Hours Not on RO | 58.3 | |||||||
| 8 | RO Gain/Loss Hours | 11.6 | Unaccounted Paid Hours | 40.2 | |||||||||
| 9 | RO Efficiency % | 118% | Combined Efficiency % | 77% | |||||||||
| 10 | |||||||||||||
| 11 | |||||||||||||
| 12 | Pay Type Detail | ||||||||||||
| 13 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | ||||
| 14 | Customer Pay | 7 | 6 | 7.6 | 15.8 | 8.2 | 11.7% | 20.6% | 35.3% | ||||
| 15 | Internal | 4 | 4 | 8.5 | 8.5 | 0.0 | 13.1% | 11.1% | 23.5% | ||||
| 16 | PDI | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0% | 0.0% | 0.0% | ||||
| 17 | Warranty | 12 | 6 | 46.9 | 29.5 | -17.4 | 72.1% | 38.5% | 35.3% | ||||
| 18 | Extended Warranty | 3 | 2 | 2.0 | 22.8 | 20.8 | 3.1% | 29.7% | 11.8% | ||||
| 19 | Charts | ||||||||||||
| 20 | |||||||||||||
| 21 | |||||||||||||
| 22 | |||||||||||||
| 23 | |||||||||||||
| 24 | |||||||||||||
| 25 | |||||||||||||
| 26 | |||||||||||||
| 27 | |||||||||||||
| 28 | |||||||||||||
| 29 | |||||||||||||
| 30 | |||||||||||||
| 31 | |||||||||||||
| 32 | |||||||||||||
| 33 | |||||||||||||
| 34 | |||||||||||||
| 35 | |||||||||||||
| 36 | |||||||||||||
| 37 | |||||||||||||
| 38 | |||||||||||||
| 39 | |||||||||||||
| 40 | |||||||||||||
| 41 | Technician Work Mix by Pay Group | Actual Time Capture | |||||||||||
| 42 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | Total A/T Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | RO Act Capture % | |||
| 43 | ROs Closed | 6 | 4 | 0 | 6 | 2 | 123.3 | 65.0 | -58.3 | 53% | |||
| 44 | % of Closed ROs | 35.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 | |||||||||||||
| 62 | Actual vs Sold Hours by Pay Group | ||||||||||||
| 63 | Metric | Customer Pay | Internal | PDI | Warranty | Ext Warranty |
Tech 314
Starting sheet · rows 1–63 of 136 and columns A–M of 18| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 314 Dashboard | ||||||||||||
| 2 | |||||||||||||
| 3 | Metric | Value | Sold Hours Breakdown | Hours | Manual / Payroll Hours | Value | |||||||
| 4 | Total Number of ROs Closed | 82.00 | 314 | RO Sold Hours | 93.02 | Total A/T Clock Hours | 159.04 | ||||||
| 5 | Total Repair Lines Completed | 121.00 | Training Hours | 0.00 | Training Hours for Month | 0.00 | |||||||
| 6 | RO Actual Hours | 100.64 | Shop Hours | 2.50 | Shop Hours for Month | 2.50 | |||||||
| 7 | RO Sold Hours | 93.02 | Total Sold + Training + Shop | 95.52 | Paid Hours Not on RO | 58.40 | |||||||
| 8 | RO Gain/Loss Hours | -7.62 | Unaccounted Paid Hours | 55.90 | |||||||||
| 9 | RO Efficiency % | 92.4% | Combined Efficiency % | 60.1% | |||||||||
| 10 | |||||||||||||
| 11 | |||||||||||||
| 12 | Pay Group Detail | ||||||||||||
| 13 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | ||||
| 14 | Customer Pay | 85 | 58 | 59.81 | 60.30 | 0.49 | 59.4% | 64.8% | 70.7% | Metric | |||
| 15 | Internal | 18 | 12 | 20.28 | 18.02 | -2.26 | 20.2% | 19.4% | 14.6% | Total A/T Clock Hours | |||
| 16 | PDI | 4 | 4 | 4.60 | 5.00 | 0.40 | 4.6% | 5.4% | 4.9% | Actual Hours on ROs | |||
| 17 | Warranty | 13 | 9 | 12.95 | 6.30 | -6.65 | 12.9% | 6.8% | 11.0% | ||||
| 18 | Extended Warranty | 1 | 1 | 3.00 | 3.40 | 0.40 | 3.0% | 3.7% | 1.2% | ||||
| 19 | Charts | ||||||||||||
| 20 | |||||||||||||
| 21 | |||||||||||||
| 22 | |||||||||||||
| 23 | |||||||||||||
| 24 | |||||||||||||
| 25 | |||||||||||||
| 26 | |||||||||||||
| 27 | |||||||||||||
| 28 | |||||||||||||
| 29 | |||||||||||||
| 30 | |||||||||||||
| 31 | |||||||||||||
| 32 | |||||||||||||
| 33 | |||||||||||||
| 34 | |||||||||||||
| 35 | |||||||||||||
| 36 | |||||||||||||
| 37 | |||||||||||||
| 38 | |||||||||||||
| 39 | |||||||||||||
| 40 | |||||||||||||
| 41 | Technician Work Mix by Pay Group | ||||||||||||
| 42 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | Total A/T Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | RO Act Capture % | |||
| 43 | ROs Closed | 58 | 12 | 4 | 9 | 1 | 159.0 | 100.6 | -58.4 | 63% | |||
| 44 | % of Closed ROs | 71% | 15% | 5% | 11% | 1% | |||||||
| 45 | |||||||||||||
| 46 | |||||||||||||
| 47 | |||||||||||||
| 48 | |||||||||||||
| 49 | |||||||||||||
| 50 | |||||||||||||
| 51 | |||||||||||||
| 52 | |||||||||||||
| 53 | |||||||||||||
| 54 | |||||||||||||
| 55 | |||||||||||||
| 56 | |||||||||||||
| 57 | |||||||||||||
| 58 | |||||||||||||
| 59 | |||||||||||||
| 60 | |||||||||||||
| 61 | |||||||||||||
| 62 | Actual vs Sold Hours by Pay Group | ||||||||||||
| 63 | Metric | Customer Pay | Internal | PDI | Warranty | Ext Warranty |
Tech 314 Backup
Starting sheet · rows 1–82 of 91 and columns A–J of 15| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 314 Dashboard | |||||||||
| 2 | ||||||||||
| 3 | May 2026 Closed RO Breakdown | |||||||||
| 4 | Tech 314 | 314 | ||||||||
| 5 | ||||||||||
| 6 | Metric | Value | Manual / Payroll Hours | Value | ||||||
| 7 | Total Number of ROs Closed | 82.00 | Total A/T Clock Hours | 159.04 | ||||||
| 8 | Total Repair Lines Completed | 121.00 | Training Hours for Month | 0.00 | ||||||
| 9 | RO Actual Hours | 100.64 | Shop Hours for Month | 2.50 | ||||||
| 10 | RO Sold Hours | 93.02 | Paid Hours Not on RO | 58.40 | ||||||
| 11 | RO Gain/Loss Hours | -7.62 | Unaccounted Paid Hours | 55.90 | ||||||
| 12 | RO Efficiency % | 92.4% | Combined Efficiency % | 60.1% | ||||||
| 13 | ||||||||||
| 14 | ||||||||||
| 15 | Sold Hours Breakdown | Hours | ||||||||
| 16 | RO Sold Hours | 93.02 | ||||||||
| 17 | Training Hours | 0.00 | ||||||||
| 18 | Shop Hours | 2.50 | ||||||||
| 19 | Total Sold + Training + Shop | 95.52 | ||||||||
| 20 | ||||||||||
| 21 | ||||||||||
| 22 | Actual Time Capture | |||||||||
| 23 | Total A/T Clock Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | |||||||
| 24 | 159.04 | 100.64 | 58.40 | |||||||
| 25 | ||||||||||
| 26 | ||||||||||
| 27 | Pay Group Detail | |||||||||
| 28 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | |
| 29 | Customer Pay | 85.00 | 58 | 59.81 | 60.30 | 0.49 | 59.4% | 64.8% | 70.7% | |
| 30 | Internal | 18.00 | 12 | 20.28 | 18.02 | -2.26 | 20.2% | 19.4% | 14.6% | |
| 31 | PDI | 4.00 | 4 | 4.60 | 5.00 | 0.40 | 4.6% | 5.4% | 4.9% | |
| 32 | Warranty | 13.00 | 9 | 12.95 | 6.30 | -6.65 | 12.9% | 6.8% | 11.0% | |
| 33 | Extended Warranty | 1.00 | 1 | 3.00 | 3.40 | 0.40 | 3.0% | 3.7% | 1.2% | |
| 34 | ||||||||||
| 35 | Charts | |||||||||
| 36 | Work 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 | ||||||||||
| 58 | Technician Work Mix by Pay Group | |||||||||
| 59 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | ||||
| 60 | ROs Closed | 58 | 12 | 4 | 9 | 1 | ||||
| 61 | % of Closed ROs | 70.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| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 327 Dashboard | |||||||||
| 2 | ||||||||||
| 3 | May 2026 Closed RO Breakdown | |||||||||
| 4 | Tech 327 | 327 | ||||||||
| 5 | ||||||||||
| 6 | Metric | Value | Manual / Payroll Hours | Value | ||||||
| 7 | Total Number of ROs Closed | 102.00 | Total A/T Clock Hours | 163.29 | ||||||
| 8 | Total Repair Lines Completed | 161.00 | Training Hours for Month | 2.50 | ||||||
| 9 | RO Actual Hours | 95.97 | Shop Hours for Month | 2.50 | ||||||
| 10 | RO Sold Hours | 119.52 | Paid Hours Not on RO | 67.32 | ||||||
| 11 | RO Gain/Loss Hours | 23.55 | Unaccounted Paid Hours | 62.32 | ||||||
| 12 | RO Efficiency % | 124.5% | Combined Efficiency % | 76.3% | ||||||
| 13 | ||||||||||
| 14 | ||||||||||
| 15 | Sold Hours Breakdown | Hours | ||||||||
| 16 | RO Sold Hours | 119.52 | ||||||||
| 17 | Training Hours | 2.50 | ||||||||
| 18 | Shop Hours | 2.50 | ||||||||
| 19 | Total Sold + Training + Shop | 124.52 | ||||||||
| 20 | ||||||||||
| 21 | ||||||||||
| 22 | Actual Time Capture | |||||||||
| 23 | Total A/T Clock Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | |||||||
| 24 | 163.29 | 95.97 | 67.32 | |||||||
| 25 | ||||||||||
| 26 | ||||||||||
| 27 | Pay Group Detail | |||||||||
| 28 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | |
| 29 | Customer Pay | 88.00 | 55 | 46.95 | 59.90 | 12.95 | 48.9% | 50.1% | 53.9% | |
| 30 | Internal | 28.00 | 20 | 14.86 | 18.90 | 4.04 | 15.5% | 15.8% | 19.6% | |
| 31 | PDI | 3.00 | 3 | 4.00 | 4.00 | 0.00 | 4.2% | 3.3% | 2.9% | |
| 32 | Warranty | 30.00 | 19 | 14.40 | 18.02 | 3.62 | 15.0% | 15.1% | 18.6% | |
| 33 | Extended Warranty | 12.00 | 11 | 15.76 | 18.70 | 2.94 | 16.4% | 15.6% | 10.8% | |
| 34 | ||||||||||
| 35 | Charts | |||||||||
| 36 | Work 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 | ||||||||||
| 58 | Technician Work Mix by Pay Group | |||||||||
| 59 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | ||||
| 60 | ROs Closed | 55 | 20 | 3 | 19 | 11 | ||||
| 61 | % of Closed ROs | 53.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| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 329 Dashboard | |||||||||
| 2 | ||||||||||
| 3 | May 2026 Closed RO Breakdown | |||||||||
| 4 | Tech 329 | 329 | ||||||||
| 5 | ||||||||||
| 6 | Metric | Value | Manual / Payroll Hours | Value | ||||||
| 7 | Total Number of ROs Closed | 37.00 | Total A/T Clock Hours | 158.02 | ||||||
| 8 | Total Repair Lines Completed | 59.00 | Training Hours for Month | 2.60 | ||||||
| 9 | RO Actual Hours | 101.83 | Shop Hours for Month | 2.50 | ||||||
| 10 | RO Sold Hours | 115.80 | Paid Hours Not on RO | 56.19 | ||||||
| 11 | RO Gain/Loss Hours | 13.97 | Unaccounted Paid Hours | 51.09 | ||||||
| 12 | RO Efficiency % | 113.7% | Combined Efficiency % | 76.5% | ||||||
| 13 | ||||||||||
| 14 | ||||||||||
| 15 | Sold Hours Breakdown | Hours | ||||||||
| 16 | RO Sold Hours | 115.80 | ||||||||
| 17 | Training Hours | 2.60 | ||||||||
| 18 | Shop Hours | 2.50 | ||||||||
| 19 | Total Sold + Training + Shop | 120.90 | ||||||||
| 20 | ||||||||||
| 21 | ||||||||||
| 22 | Actual Time Capture | |||||||||
| 23 | Total A/T Clock Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | |||||||
| 24 | 158.02 | 101.83 | 56.19 | |||||||
| 25 | ||||||||||
| 26 | ||||||||||
| 27 | Pay Group Detail | |||||||||
| 28 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | |
| 29 | Customer Pay | 25.00 | 17 | 38.84 | 44.40 | 5.56 | 38.1% | 38.3% | 45.9% | |
| 30 | Internal | 22.00 | 14 | 32.70 | 38.50 | 5.80 | 32.1% | 33.2% | 37.8% | |
| 31 | PDI | 0.00 | 0 | 0.00 | 0.00 | 0.00 | 0.0% | 0.0% | 0.0% | |
| 32 | Warranty | 10.00 | 7 | 8.02 | 8.30 | 0.28 | 7.9% | 7.2% | 18.9% | |
| 33 | Extended Warranty | 2.00 | 2 | 22.27 | 24.60 | 2.33 | 21.9% | 21.2% | 5.4% | |
| 34 | ||||||||||
| 35 | Charts | |||||||||
| 36 | Work 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 | ||||||||||
| 58 | Technician Work Mix by Pay Group | |||||||||
| 59 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | ||||
| 60 | ROs Closed | 17 | 14 | 0 | 7 | 2 | ||||
| 61 | % of Closed ROs | 45.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| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 331 Dashboard | |||||||||
| 2 | ||||||||||
| 3 | May 2026 Closed RO Breakdown | |||||||||
| 4 | Tech 331 | 331 | ||||||||
| 5 | ||||||||||
| 6 | Metric | Value | Manual / Payroll Hours | Value | ||||||
| 7 | Total Number of ROs Closed | 20.00 | Total A/T Clock Hours | 153.42 | ||||||
| 8 | Total Repair Lines Completed | 26.00 | Training Hours for Month | 0.00 | ||||||
| 9 | RO Actual Hours | 107.44 | Shop Hours for Month | 2.50 | ||||||
| 10 | RO Sold Hours | 64.70 | Paid Hours Not on RO | 45.98 | ||||||
| 11 | RO Gain/Loss Hours | -42.74 | Unaccounted Paid Hours | 43.48 | ||||||
| 12 | RO Efficiency % | 60.2% | Combined Efficiency % | 43.8% | ||||||
| 13 | ||||||||||
| 14 | ||||||||||
| 15 | Sold Hours Breakdown | Hours | ||||||||
| 16 | RO Sold Hours | 64.70 | ||||||||
| 17 | Training Hours | 0.00 | ||||||||
| 18 | Shop Hours | 2.50 | ||||||||
| 19 | Total Sold + Training + Shop | 67.20 | ||||||||
| 20 | ||||||||||
| 21 | ||||||||||
| 22 | Actual Time Capture | |||||||||
| 23 | Total A/T Clock Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | |||||||
| 24 | 153.42 | 107.44 | 45.98 | |||||||
| 25 | ||||||||||
| 26 | ||||||||||
| 27 | Pay Group Detail | |||||||||
| 28 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | |
| 29 | Customer Pay | 12.00 | 8 | 22.67 | 20.30 | -2.37 | 21.1% | 31.4% | 40.0% | |
| 30 | Internal | 6.00 | 6 | 6.26 | 8.40 | 2.14 | 5.8% | 13.0% | 30.0% | |
| 31 | PDI | 1.00 | 1 | 1.30 | 1.30 | 0.00 | 1.2% | 2.0% | 5.0% | |
| 32 | Warranty | 5.00 | 4 | 49.30 | 23.80 | -25.50 | 45.9% | 36.8% | 20.0% | |
| 33 | Extended Warranty | 2.00 | 2 | 27.91 | 10.90 | -17.01 | 26.0% | 16.8% | 10.0% | |
| 34 | ||||||||||
| 35 | Charts | |||||||||
| 36 | Work 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 | ||||||||||
| 58 | Technician Work Mix by Pay Group | |||||||||
| 59 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | ||||
| 60 | ROs Closed | 8 | 6 | 1 | 4 | 2 | ||||
| 61 | % of Closed ROs | 40.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| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tech 332 Dashboard | |||||||||
| 2 | ||||||||||
| 3 | May 2026 Closed RO Breakdown | |||||||||
| 4 | Tech 332 | 332 | ||||||||
| 5 | ||||||||||
| 6 | Metric | Value | Manual / Payroll Hours | Value | ||||||
| 7 | Total Number of ROs Closed | 8.00 | Total A/T Clock Hours | 33.16 | ||||||
| 8 | Total Repair Lines Completed | 13.00 | Training Hours for Month | 0.00 | ||||||
| 9 | RO Actual Hours | 5.90 | Shop Hours for Month | 0.00 | ||||||
| 10 | RO Sold Hours | 6.90 | Paid Hours Not on RO | 27.26 | ||||||
| 11 | RO Gain/Loss Hours | 1.00 | Unaccounted Paid Hours | 27.26 | ||||||
| 12 | RO Efficiency % | 116.9% | Combined Efficiency % | 20.8% | ||||||
| 13 | ||||||||||
| 14 | ||||||||||
| 15 | Sold Hours Breakdown | Hours | ||||||||
| 16 | RO Sold Hours | 6.90 | ||||||||
| 17 | Training Hours | 0.00 | ||||||||
| 18 | Shop Hours | 0.00 | ||||||||
| 19 | Total Sold + Training + Shop | 6.90 | ||||||||
| 20 | ||||||||||
| 21 | ||||||||||
| 22 | Actual Time Capture | |||||||||
| 23 | Total A/T Clock Hours | Actual Hours on ROs | Difference: Clocked - RO Actual | |||||||
| 24 | 33.16 | 5.90 | 27.26 | |||||||
| 25 | ||||||||||
| 26 | ||||||||||
| 27 | Pay Group Detail | |||||||||
| 28 | Pay Group | Jobs Performed | ROs Closed | Actual Hrs | Sold Hrs | Gain/Loss | % of Actual | % of Sold | Work Mix | |
| 29 | Customer Pay | 11.00 | 6 | 5.10 | 6.10 | 1.00 | 86.4% | 88.4% | 75.0% | |
| 30 | Internal | 1.00 | 1 | 0.40 | 0.40 | 0.00 | 6.8% | 5.8% | 12.5% | |
| 31 | PDI | 0.00 | 0 | 0.00 | 0.00 | 0.00 | 0.0% | 0.0% | 0.0% | |
| 32 | Warranty | 1.00 | 1 | 0.40 | 0.40 | 0.00 | 6.8% | 5.8% | 12.5% | |
| 33 | Extended Warranty | 0.00 | 0 | 0.00 | 0.00 | 0.00 | 0.0% | 0.0% | 0.0% | |
| 34 | ||||||||||
| 35 | Charts | |||||||||
| 36 | Work 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 | ||||||||||
| 58 | Technician Work Mix by Pay Group | |||||||||
| 59 | Metric | Customer Pay | Internal | PDI | Warranty | Extended Warranty | ||||
| 60 | ROs Closed | 6 | 1 | 0 | 1 | 0 | ||||
| 61 | % of Closed ROs | 75.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
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
Autosheet in Sheets Opus 5.5 · Medium
Claude in Excel Opus 5.5 · High
Claude in Sheets Opus 5.5 · Medium
Claude Code + Sheets MCP Opus 5.5 · Medium
Claude Code + Autosheet MCP Opus 5.5 · Medium
ChatGPT + Autosheet MCP GPT-6 · Medium
Autosheet in Sheets Haiku 5.5 · High
Claude in Excel Haiku 5.5 · High
Claude in Sheets Haiku 5.5 · High
ChatGPT + Drive MCP GPT-6 · Medium
Gemini in Sheets Auto
Failed 10
Autosheet in Excel GPT-6 Astra · Low
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
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
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
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
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
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
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
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
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
Why it failed: The assistant refused the request stating available controls did not expose data-label formatting and explicitly confirmed no changes were made.