Spreadsheet: 274932d1383268344-add-cells-together-that-have-a-certain-name-associated-with-them-excel-help-2
Sheet: Sheet1

 |  |  |  |  |  | To Date | Mechanic | [NAME] | Price Type | Hours Worked | Hours Overtime | Hours Charged | Total Sell | Cost | Margin | Avg. Margin per Hours Worked
 |  |  |  |  |  | 2013-10-29 00:00:00 | 281 | [NAME] | Fleet | 15.07 | 0.3 | 25.7375 | 2367.37 | 414.99 | 1952.38 | 129.5540809555
 |  |  |  |  |  | 2013-10-29 00:00:00 | 281 | [NAME] | Internal N | 6.46 | 0.13 | 1.1051 | 101.67 | 177.93 | -76.26 | -11.8049535604
 |  |  |  |  |  | 2013-10-29 00:00:00 | 281 | [NAME] | Workshop | 28.21 | 0.12 | 33.2736 | 4353.87 | 764.91 | 3588.96 | 127.2229705778
 |  |  |  |  |  | 2013-10-29 00:00:00 | 281 | [NAME] | Warranty | 5.57 | 0 | 4.6 | 469.33 | 150.39 | 318.94 | 57.2603231598
 |  |  |  |  |  | 2013-10-29 00:00:00 | 3003 | [NAME] | Fleet | 18 | 0.13 | 24.3302 | 2270.16 | 442.55 | 1827.61 | 101.5338888889
 |  |  |  |  |  | 2013-10-29 00:00:00 | 3003 | [NAME] | Internal N | 4.44 | 0.07 | 0.748 | 96.49 | 110.09 | -13.6 | -3.0630630631
 |  |  |  |  |  | 2013-10-29 00:00:00 | 3003 | [NAME] | Workshop | 113.97 | 0.51 | 106.1148 | 13295.74 | 2794.5 | 10501.24 | 92.1403878214
 |  |  |  |  |  | 2013-10-29 00:00:00 | 3003 | [NAME] | Warranty | 1.78 | 0.03 | 1.1 | 118.08 | 44.18 | 73.9 | 41.5168539326
 |  |  |  |  |  | 2013-10-29 00:00:00 | 357 | [NAME] | Fleet | 18.16 | 0 | 18.927 | 1771.87 | 472.16 | 1299.71 | 71.5699339207
 |  |  |  |  |  | 2013-10-29 00:00:00 | 357 | [NAME] | Internal N | 5.16 | 0.03 | 2.4996 | 353.44 | 134.94 | 218.5 | 42.3449612403
 |  |  |  |  |  | 2013-10-29 00:00:00 | 357 | [NAME] | Workshop | 31.91 | 0.75 | 42.0282 | 5406.22 | 849.16 | 4557.06 | 142.8097774992
 |  |  |  |  |  | 2013-10-29 00:00:00 | 357 | [NAME] | Warranty | 3.36 | 0 | 6.027 | 704.54 | 87.36 | 617.18 | 183.6845238095
 |  |  |  |  |  | 2013-10-29 00:00:00 | 365 | [NAME] | Fleet | 23.6 | 0 | 34.8871 | 3375.74 | 381.65 | 2994.09 | 126.868220339
 |  |  |  |  |  | 2013-10-29 00:00:00 | 365 | [NAME] | Internal N | 2.59 | 0 | 1.9564 | 263.98 | 41.89 | 222.09 | 85.749034749
 |  |  |  |  |  | 2013-10-29 00:00:00 | 365 | [NAME] | Workshop | 49.24 | 0.31 | 56.4104 | 6890.25 | 801.27 | 6088.98 | 123.6592201462
 |  |  |  |  |  | 2013-10-29 00:00:00 | 365 | [NAME] | Warranty | 3.87 | 0 | 9.9 | 1087.78 | 62.57 | 1025.21 | 264.9121447028
 |  |  |  |  |  | 2013-10-29 00:00:00 | 366 | [NAME] | Fleet | 14.01 | 0 | 14.3471 | 1338.39 | 350.25 | 988.14 | 70.5310492505
 |  |  |  |  |  | 2013-10-29 00:00:00 | 366 | [NAME] | Internal N | 15.68 | 0.09 | 14.0526 | 1541.77 | 394.25 | 1147.52 | 73.1836734694
 |  |  |  |  |  | 2013-10-29 00:00:00 | 366 | [NAME] | Workshop | 43.28 | 0 | 41.1635 | 5207.76 | 1082 | 4125.76 | 95.3271719039
 |  |  |  |  |  | 2013-10-29 00:00:00 | 366 | [NAME] | Warranty | 1.01 | 0 | 2.1 | 231.16 | 25.25 | 205.91 | 203.8712871287
 |  |  |  |  |  | 2013-10-29 00:00:00 | 458 | [NAME] | Fleet | 24.95 | 0.08 | 29.124 | 2674.45 | 675.81 | 1998.64 | 80.1058116232
 |  |  |  |  |  | 2013-10-29 00:00:00 | 458 | [NAME] | Internal N | 2.65 | 0 | 0 | 0 | 71.55 | -71.55 | -27
 |  |  |  |  |  | 2013-10-29 00:00:00 | 458 | [NAME] | Workshop | 31.28 | 0.03 | 32.3267 | 4212.76 | 845.37 | 3367.39 | 107.6531329923
 |  |  |  |  |  | 2013-10-29 00:00:00 | 458 | [NAME] | Warranty | 1.9 | 0 | 1.3 | 139.1 | 51.3 | 87.8 | 46.2105263158
 |  |  |  |  |  | 2013-10-29 00:00:00 | 50 | [NAME] | 55 Plus | 0.8 | 0 | 1.1057 | 105.04 | 20.8 | 84.24 | 105.3
 |  |  |  |  |  | 2013-10-29 00:00:00 | 50 | [NAME] | Fleet | 36.07 | 0.1 | 41.5477 | 4068.56 | 940.42 | 3128.14 | 86.724147491
 |  |  |  |  |  | 2013-10-29 00:00:00 | 50 | [NAME] | Internal N | 5.75 | 0 | 4.1214 | 529.67 | 149.5 | 380.17 | 66.1165217391
 |  |  |  |  |  | 2013-10-29 00:00:00 | 50 | [NAME] | Workshop | 95.69 | 0.46 | 120.6756 | 14082.2 | 2499.9 | 11582.3 | 121.0398160727
 |  |  |  |  |  | 2013-10-29 00:00:00 | 50 | [NAME] | Warranty | 2.12 | 0 | 3.8 | 408.29 | 55.12 | 353.17 | 166.5896226415
 |  |  |  |  |  | 2013-10-29 00:00:00 | 515 | [NAME] | 55 Plus | 1.88 | 0.03 | 1.1 | 148.5 | 51.57 | 96.93 | 51.5585106383
 |  |  |  |  |  | 2013-10-29 00:00:00 | 515 | [NAME] | Fleet | 25.15 | 0.05 | 23.3503 | 2242.64 | 680.4 | 1562.24 | 62.1168986083
 |  |  |  |  |  | 2013-10-29 00:00:00 | 515 | [NAME] | Internal N | 2.57 | 0.03 | 1.67 | 179.28 | 70.2 | 109.08 | 42.4435797665
 |  |  |  |  |  | 2013-10-29 00:00:00 | 515 | [NAME] | Workshop | 90.2 | 0.79 | 80.7975 | 10025.14 | 2456.73 | 7568.41 | 83.9069844789
 |  |  |  |  |  | 2013-10-29 00:00:00 | 515 | [NAME] | Warranty | 1.51 | 0 | 3.3 | 400.64 | 40.77 | 359.87 | 238.3245033113
 |  |  |  |  |  | 2013-10-29 00:00:00 | 519 | [NAME] | Fleet | 32.32 | 0.15 | 43.9985 | 4219.36 | 844.87 | 3374.49 | 104.4087252475
 |  |  |  |  |  | 2013-10-29 00:00:00 | 519 | [NAME] | Internal N | 10.15 | 0.49 | 4.9806 | 679.41 | 276.86 | 402.55 | 39.6600985222
 |  |  |  |  |  | 2013-10-29 00:00:00 | 519 | [NAME] | Workshop | 90.29 | 2.1 | 92.4919 | 11637.31 | 2404 | 9233.31 | 102.2628198029
 |  |  |  |  |  | 2013-10-29 00:00:00 | 519 | [NAME] | Warranty | 5.88 | 0 | 4.823 | 492.37 | 153.01 | 339.36 | 57.7142857143
 |  |  |  |  |  | 2013-10-29 00:00:00 | 522 | [NAME] | Fleet | 25.95 | 0 | 33.4328 | 3138.95 | 700.65 | 2438.3 | 93.9614643545
 |  |  |  |  |  | 2013-10-29 00:00:00 | 522 | [NAME] | Internal N | 4.02 | 0 | 2.83 | 372.07 | 108.54 | 263.53 | 65.5547263682
 |  |  |  |  |  | 2013-10-29 00:00:00 | 522 | [NAME] | Workshop | 99.83 | 0.69 | 107.5307 | 13921.55 | 2714.04 | 11207.51 | 112.2659521186
 |  |  |  |  |  | 2013-10-29 00:00:00 | 522 | [NAME] | Warranty | 9.76 | 0 | 15.5 | 1700.22 | 263.52 | 1436.7 | 147.2028688525
 |  |  |  |  |  | 2013-10-29 00:00:00 | 538 | [NAME] | Fleet | 35.14 | 0.64 | 43.9402 | 4198 | 941.36 | 3256.64 | 92.6761525327
 |  |  |  |  |  | 2013-10-29 00:00:00 | 538 | [NAME] | Internal N | 11.3 | 0.25 | 3.6165 | 376.45 | 303.89 | 72.56 | 6.4212389381
 |  |  |  |  |  | 2013-10-29 00:00:00 | 538 | [NAME] | Workshop | 73.54 | 1.1 | 90.1352 | 11882.46 | 1963.78 | 9918.68 | 134.8746260538
 |  |  |  |  |  | 2013-10-29 00:00:00 | 538 | [NAME] | Warranty | 4.6 | 0 | 7 | 770.56 | 121.03 | 649.53 | 141.202173913
 |  |  |  |  |  | 2013-10-29 00:00:00 | 565 | [NAME] | Internal N | 0 | 0 | 0.7777 | 100.32 | 0 | 100.32 | 0
 |  |  |  |  |  | 2013-10-29 00:00:00 | 583 | Harley sprunt | Internal N | 0.05 | 0 | 0.0101 | 1.3 | 0 | 1.3 | 26
 |  |  |  |  |  | 2013-10-29 00:00:00 | 583 | Harley sprunt | Workshop | 2.06 | 0 | 4.3444 | 508.42 | 0 | 508.42 | 246.8058252427
 |  |  |  |  |  | 2013-10-29 00:00:00 | 602 | [NAME] | 55 Plus | 0.43 | 0 | 0.5943 | 61.31 | 4.68 | 56.63 | 131.6976744186
 |  |  |  |  |  | 2013-10-29 00:00:00 | 602 | [NAME] | Fleet | 2.7 | 0 | 3.6011 | 392.13 | 29.41 | 362.72 | 134.3407407407
 |  |  |  |  |  | 2013-10-29 00:00:00 | 602 | [NAME] | Internal N | 13.83 | 0.08 | 5.1048 | 767.02 | 151.47 | 615.55 | 44.5083152567
 |  |  |  |  |  | 2013-10-29 00:00:00 | 602 | [NAME] | Workshop | 26.93 | 0 | 33.3283 | 3959.86 | 293.28 | 3666.58 | 136.1522465652
 |  |  |  |  |  | 2013-10-29 00:00:00 | 602 | [NAME] | Warranty | 3.98 | 0.11 | 10.6 | 1166.81 | 44.54 | 1122.27 | 281.9773869347
 |  |  |  |  |  | 2013-10-29 00:00:00 | 604 | Trent Scott | Fleet | 2.93 | 0 | 4.0381 | 371.77 | 31.9 | 339.87 | 115.9965870307
 |  |  |  |  |  | 2013-10-29 00:00:00 | 604 | Trent Scott | Internal N | 1 | 0 | 0.8008 | 73.67 | 10.89 | 62.78 | 62.78
 |  |  |  |  |  | 2013-10-29 00:00:00 | 604 | Trent Scott | Workshop | 5.8 | 0 | 4.1693 | 528.84 | 63.16 | 465.68 | 80.2896551724
 |  |  |  |  |  | 2013-10-29 00:00:00 | 604 | Trent Scott | Warranty | 1.05 | 0 | 2.6 | 286.2 | 11.43 | 274.77 | 261.6857142857
 |  |  |  |  |  | 2013-10-29 00:00:00 | 605 | [NAME] | Fleet | 19.01 | 0 | 21.6124 | 2121.17 | 207.01 | 1914.16 | 100.6922672278
 |  |  |  |  |  | 2013-10-29 00:00:00 | 605 | [NAME] | Internal N | 2.18 | 0.08 | 3.0898 | 465.76 | 24.61 | 441.15 | 202.3623853211
 |  |  |  |  |  | 2013-10-29 00:00:00 | 605 | [NAME] | Workshop | 50.37 | 0 | 50.648 | 5973.86 | 548.54 | 5425.32 | 107.7093508041
 |  |  |  |  |  | 2013-10-29 00:00:00 | 605 | [NAME] | Warranty | 0.57 | 0 | 2.1 | 231.16 | 6.21 | 224.95 | 394.649122807
 |  |  |  |  |  | 2013-10-29 00:00:00 | 606 | [NAME] | Fleet | 22.66 | 0.01 | 17.2854 | 1618.55 | 612.09 | 1006.46 | 44.4157105031
 |  |  |  |  |  | 2013-10-29 00:00:00 | 606 | [NAME] | HARRIER | 1.02 | 0 | 1.6993 | 229.41 | 27.54 | 201.87 | 197.9117647059
 |  |  |  |  |  | 2013-10-29 00:00:00 | 606 | [NAME] | Internal N | 4.12 | 0 | 0 | 0 | 111.24 | -111.24 | -27
 |  |  |  |  |  | 2013-10-29 00:00:00 | 606 | [NAME] | Workshop | 87.67 | 1.17 | 81.5945 | 10022.43 | 2398.68 | 7623.75 | 86.9596213072
 |  |  |  |  |  | 2013-10-29 00:00:00 | 606 | [NAME] | Warranty | 12.87 | 0.03 | 4.7267 | 494.02 | 348.3 | 145.72 | 11.3224553225
 |  |  |  |  |  | 2013-10-29 00:00:00 | 607 | [NAME] | Fleet | 5.09 | 2.55 | 5.6495 | 527.45 | 112.33 | 415.12 | 81.5559921415
 |  |  |  |  |  | 2013-10-29 00:00:00 | 607 | [NAME] | Internal N | 5.64 | 2.82 | 3.7561 | 484.52 | 124.38 | 360.14 | 63.8546099291
 |  |  |  |  |  | 2013-10-29 00:00:00 | 607 | [NAME] | Workshop | 43.71 | 21.87 | 54.8273 | 7142.84 | 964.12 | 6178.72 | 141.3571265157
 |  |  |  |  |  | 2013-10-29 00:00:00 | 607 | [NAME] | Warranty | 0.73 | 0.37 | 2.1 | 231.16 | 16.17 | 214.99 | 294.5068493151
 |  |  |  |  |  | 2013-10-29 00:00:00 | 8 | [NAME] | Fleet | 11.92 | 0 | 15.4615 | 1426.14 | 429.73 | 996.41 | 83.591442953
 |  |  |  |  |  | 2013-10-29 00:00:00 | 8 | [NAME] | Internal N | 17.72 | 0.07 | 5.1093 | 696.59 | 641.32 | 55.27 | 3.1190744921
 |  |  |  |  |  | 2013-10-29 00:00:00 | 8 | [NAME] | Workshop | 64.73 | 0.09 | 62.5764 | 8215.38 | 2336.78 | 5878.6 | 90.8172408466
 |  |  |  |  |  | 2013-10-29 00:00:00 | 8 | [NAME] | Warranty | 16.28 | 0 | 13.5122 | 1246.96 | 586.89 | 660.07 | 40.5448402948
 |  |  |  |  |  | 2013-10-29 00:00:00 | 806 | [NAME] | Fleet | 11.47 | 0.2 | 8.714 | 811.16 | 126.73 | 684.43 | 59.6713164778
 |  |  |  |  |  | 2013-10-29 00:00:00 | 806 | [NAME] | Internal N | 3.49 | 0 | 1.868 | 287.47 | 37.91 | 249.56 | 71.5071633238
 |  |  |  |  |  | 2013-10-29 00:00:00 | 806 | [NAME] | Workshop | 15.33 | 0 | 7.9759 | 951.56 | 166.5 | 785.06 | 51.2106979778
 |  |  |  |  |  | 2013-10-29 00:00:00 | 806 | [NAME] | Warranty | 0.05 | 0 | 0.0111 | 1.11 | 0.55 | 0.56 | 11.2
 |  |  |  |  |  |  |  | Name | Total Sell