Spreadsheet: 758810d1639073186-excel-division-question-example
Sheet: Sheet1

Sche Date | Date | Customer | Description | TC WO# | EST | Status | Vendor | Tech | Hours | Crane | Sales Revenue | Business Revenue | [NAME] | BRT | SRT | AWOT
 | 2021-10-28 00:00:00 | Advantage Metals | Replace 3 Wallmount Units | 140378 | [NAME] | Equipment at [NAME] | n/a | [NAME], [NAME], [NAME] | 1 Day + 1 Day Ed or [NAME] | n/a | 21029.01 | 19919.25
 | 2021-03-12 00:00:00 | Pizza Hut 4726 | Fryer Repair | 142571 |  | Parts Ordered on 3/18/2021 |  | [NAME] | 4 |  | 2742.71 | 2595.43
 | 2021-04-09 00:00:00 | Frontier Justice, [NAME]'s Summit | South Range Unit | 142892 | B.Meyer | Parts ordered 4/26/2021 |  | [NAME] | 3 | N/A | 3186.48 | 3129.25
 | 2021-03-17 00:00:00 | Hometown Pie Company | [NAME] Install | 142902 | [NAME] | Equipment Ordered 2/4/2021 | N/a | 4 Man Crew. Nate, [NAME], [NAME], Sergio | 4 guys for 2 days then 2 guys for five days | n/a | 28034 | 26323
 | 2021-03-01 00:00:00 | [NAME] | Replace RTU #6 | 142932 | J. | Approved, waiting on equipment. 4/22/2021 |  | Joel |  |  | 6203.77 | 6155
 | 2021-03-25 00:00:00 | Jason's Deli | WIF Receiver | 142982 | B.Meyer | Part ordered 3/29/2021 | n/a | Nate C | 8 | N/A | 1966.08 | 1924.85
 |  | [NAME] | Remove and clean evap coil | 142983 | B.Meyer | Approved 3/23/2021 | n/a | Sergio | 6.5 | N/A | 904.33 | 885
 | 2021-03-24 00:00:00 | Pizza Hut 4726 | Make Table | 143307 | B.Meyer | parts ordered 4/6/2021 |  | [NAME] | 8 | N/A | 2389.64 | 2285.55
 | 2021-04-09 00:00:00 | Cheesecake Factory Overland Park | Line Refrigeration Repair | 143329 | B.Meyer | Parts in at Flint. 4/20/21 |  | Chanler and Sean | Overnight 8 hours | N/A | 9015.5 | 8263.52
 | 2021-03-19 00:00:00 | Saints Pub and Patio | Replace RTU Bar Area | 143336 | J. | Equipment ordered 3/26/2021 | n/a | [NAME], [NAME] and [NAME] truck | 1 Day | n/a | 12155.22 | 11552.55
 | 2021-03-19 00:00:00 | Saints Pub and Patio | Replace [NAME] Room | 143339 | J. | Equipment ordered 3/26/2021 | n/a | [NAME], [NAME] and [NAME] truck | 1 Day | n/a | 12156 | 11553.24
 | 2021-03-25 00:00:00 | North Italian Restaurant | Ice Machine Repair | 143350 | B.Meyer | Parts in will call at Tresko 3/26/2021 |  | [NAME] | 5 | N/A | 1230.98 | 1128
 | 2021-03-22 00:00:00 | Hardee's Gladstone | RIC Repair | 143393 | B.Meyer | Parts in at Flint. 3/29/21 | n/a | [NAME] | 8 | N/A | 649.77 | 630.4
 |  | [NAME] | Replace heat exchanger | 143396 | [NAME] | parts at lennox NKC 3/26/2021 | n/a | Tech and [NAME] | 1 Day | N/A | 1592.87 | 1455
 | 2021-03-30 00:00:00 | Frontier Justice | Exhaust Fan | 143421 | B.Meyer | Equipment ordered 3/31/2021 |  | [NAME] | 4.5 | N/A | 1587.77 | 1455
 | 2021-03-29 00:00:00 | Pizza Hut 4747 | Hot Hold | 143434 | B.Meyer | Parts ordered 4/5/2021 |  | [NAME] | 4 | N/A | 1593.4 | 1558.31
 |  | Ferguson KCK | Balance Supply Dampers | 143462 |  | Approved 3/29/2021 | 175636415 | [NAME] and [NAME] | 6 | n/a | 1244.03 | 1140
 | 2021-03-30 00:00:00 | Pizza Hut 2655, Topeka | Make Table Compressor | 143471 | J. | Some parts are at Key in lenexa, waiting on one more from parts town 3/31/2021 |  | Zach B | 10 | N/A | 2527.94 | 2316.03
 |  | Scheels | Turbo Chef Repair | 143569 |  | Parts ordered 3/31/2021 | n/a | Zach B | 6 | N/A | 1777.94 | 1607.54
 | 2021-04-01 00:00:00 | Pizza Hut 4720 | Top Oven | 143573 | B.Meyer | Parts in at Flint. 4/6/21 |  | Zach | 4 | N/A | 908.46 | 832.5
Coordinate with ductless change out. |  | Steple Chase Holdings LLC | Trouble shoot zoning | 143604 | [NAME] | Approved 3/30/2021 | n/a | [NAME] and Tech | 2021-04-08 00:00:00 | N/A | 2072.62 | 2035
4/14 tentatively |  | [NAME] | Replace MAU | 143621 | J. | Equipment at [NAME] | Needed | Zach B, Oscar P, [NAME] | 2 Days | 6:00 am 50 ton Polk Crane | 7913.75 | 7240.39
 | 2021-03-31 00:00:00 | McAlister's Deli, Lawrence | WIF Box Repair Quote NO CTD | 143663 |  | Sent Repair Quote on 4/2/2021. [NAME] sent changeout quote last week. |  | Zach | 8 | N/A | 1777.05 | 1625.85
 | 2021-04-05 00:00:00 | Discount Tire - 1934 [NAME] | T Stat | 143682 |  | Parts ordered 4/8/2021 |  | [NAME] | 2.5 | N/A | 801.42 | 779.5
CHECK SERVICE COST |  | Element Medical imaging | Replace Blower Motor | 143694 | [NAME] | Parts ordered 4/5/2021 |  | Tech and a helper | 4 | n/a | 2093.08 | 1918.5
CHECK SERVICE COST |  | Element Medical imaging | Replace Inducer Motor | 143698 | B.Meyer | Parts in will call Lennox Lenexa 4/5/2021 |  | [NAME] | 3.5 | N/A | 723.6 | 663.25
 | 2021-04-06 00:00:00 | [NAME], PraireVillage | Econ Module | 143724 | B.Meyer | Parts ordered to wil |  | [NAME] | 3.5 | N/A | 1154.27 | 1049.58
Please do 143734 and 143735 together |  | Pizza Hut 4715 | [NAME] | 143734 | J. | Approved 4/6/2021 | 4147129 | Mid Level Tech | 3 | n/a | 250.39 | 244.92
 |  | Pizza hut 4737 | Replace 3 Contactors | 143736 | [NAME] | parts ordered 4/6/2021 |  | [NAME] | 3.5 | n/a | 627.9 | 572.9
 |  | Pizza Hut 4724 | Replace Retarder | 143742 |  | Equipment at Keeler 4/6/2021 |  | [NAME] or [NAME] and Helper | 5 |  | 1020 | 1020
 |  | Frontier Justice | Repair North Range Unit | 143754 |  | Parts Orderd 4/6/2021 | n/a | [NAME] | 10 | n/a | 2760.11 | 2688.25
 | 2021-04-06 00:00:00 | Chipotle - North KC | [NAME] | 143766 | B.Meyer | Parts in at Flint 6/10/21 |  | Nate. and helper | 4.5 each | N/A | 5610.34 | 5567.56
 |  | First Watch Blue Springs | Replace 2 Crankcase Heaters | 143784 |  | Parts Ordered 4/7/2021 | 176352510 | [NAME] | 3 | n/a | 468.44 | 461
 | 2021-04-07 00:00:00 | KinderCare, St. Joseph | replace [NAME] | 143785 | B.Meyer | Parts in will Call CFM KC 4/8/2021 |  | Any Tech | 8 | N/A | 3455.33 | 3312.53