Spreadsheet: 594413d1539759066-best-way-to-input-data-profitcalc2017
Sheet: Maintenance

 |  | 2016-10-31 00:00:00 | 2016-11-07 00:00:00 | 2016-11-14 00:00:00
DAF |  | 835 | 7.37 | 109 |  |  | 95 | 145.62 |  | 27.94 | 11.8 | 450 | 725 | 330 |  | 359.38 | 408 | 160 | 66.13 | 138.27 | 75 |  | 575.93 | 148.5 | 380.54 | 240 | 275.5 | 270 |  | 357 | 54.6 | 12.26 | 416 | 132 | 107.34 | 96.08
 |  | 60.35 | 460 | 55 |  |  | 3.82 | 75.35 |  | 7 | 166.21 | 137.23 | 263.34 | 53.53 |  | 8.96 | 155.18 | 13.98 | 325 | 199.4 | 49.2 |  | 130 | 42.24 | 9.99 | 240 | 275.5 |  |  |  |  |  | 26 | 6.1 | 235.5 | 653.06
 |  | 80.43 | 59 | 1.15 |  |  | 130 | 273.47 |  | 73.66 | 25.87 | 52.44 | 12.73 | 22.45 |  |  | 93.16 | 82.45 | 287.75 | 9.38 | 20.51 |  | 338.64 | 113.03 | 225 | 10.29 | 61.93 |  |  |  |  |  | 243 | 132 |  | 148.5
 |  | 585 |  | 6.7 |  |  | 171 | 723.6 |  | 8.96 | 15.73 |  | 7.04 | 24.15 |  |  | 52.5 | 2.21 | 220.43 | 21.43 | 27.77 |  | 51.41 | 52.8 | 1767.18 |  | 0 |  |  |  |  |  | 420 | 502.4
 |  | 114.33 |  |  |  |  | 325 | 86.94 |  | 21.05 | 2.46 |  | 98.39 | 142.43 |  |  |  |  | 19 |  |  |  |  |  | 270.95 |  |  |  |  |  |  |  | 130
 |  | 48.4 |  |  |  |  |  |  |  | 15.17 |  |  | 98.39 | 8.06 |  |  |  |  | 37.5 |  |  |  |  |  | 40 |  |  |  |  |  |  |  | 35.98
 |  | 69.82 |  |  |  |  |  |  |  |  |  |  |  | 23.12 |  |  |  |  | 14.8 |  |  |  |  |  | 1388.21 |  |  |  |  |  |  |  | 41.25
 |  | 13.82 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 325
Total DAF
NLC |  | 107 | 572 | 645.41 | 87 | 308.22 | 53.75 | 22 | 0 | 0 | 828.21 | 533.76 | 254.76 |  | 0 | 33.96 | 239.24 | 22.28 | 231.08 | 0 | 606.42 | 568.8 | 62 | 347.4 | 879.12 | 376.5 | 59.8 | 52.2 | 91.5 | 428.18 | 384.6 | 0 | 68.9 | 78.26 | 52.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 89 | 23 |  | 137.2 | 720.6 | 720.6 | 169.03 |  |  | 174.2 | 149.8 | 628.8 |  |  | 128.2 | 422.71 | 276.64 | 210.75 |  | 215.34 | 252.33 | 242.3 | 60 | 386.76 | 533.88 | 598.36 | 341.42 | 101.8 | 379.2 | 148.52 |  | 279.76 | 43 | 362.71
 |  | 104 | 411 |  | 313.2 | 53.75 | 269.94 | 104.08 |  |  | 318.4 | 95.76 | 957.88 |  |  | 48.52 | 845.42 | 935.1 |  |  | 58.47 | 463.2 | 200.6 | 347.46 |  | 221.2 | 475.53 | 52 | 223.36 | 628.8 | 1021.18 |  | 542.12 | 55.26 | 619.32
 |  |  | 105 |  | 296.64 | 269.94 | 616.44 |  |  |  | 249.21 |  | 54.32 |  |  | 535.2 | 23.66 |  |  |  |  | 384.6 | 504.66 | 160 |  | 730.44 | 581.64 | 93.98 | 361 |  | 532.08 |  | 189.6 |  | 190.1
 |  |  |  |  | 43.6 | 616.44 | 308 |  |  |  | 289.05 |  | 414.43 |  |  | 96.5 |  |  |  |  |  | 159.25 | 47.5 | 112.4 |  | 888.72 | 40.75 | 548.33 | 92.74 |  | 344.64 |  | 468.2 |  | 581.64
 |  |  |  |  | 103.2 |  |  |  |  |  | 340.88 |  |  |  |  |  |  |  |  |  |  |  | 42.46 | 609.2 |  | 847.92 | 279.12 | 572.38 | 530.72 |  |  |  |  |  | 820.82
Total NLC
Tyres Other |  |  |  |  |  | 53.75 | 302 | 481.2 | 231.6 | 498.62
TW |  | 1308 | 945 | 300 | 7174 | 810 | 282 | 261.32 | 480.4 | 1174.84 | 983 | 2163 | 1670 | 1251 | 529 | 157 | 762 | 1541 | 793 | 1155 | 775 | 3468 | 543 | 2318 | 1224 | 1156 | 1867 | 908 | 1451 | 1770 | 1399 | 2506 | 2893 |  |  | 2.089 |  |  | 2487
Jet |  |  |  |  |  | 247.28 | 399 | 160 | 1077.12 | 251.12 |  |  |  |  |  | 188 | 404
[NAME] |  |  |  |  |  | 43.6 | 720.6 |  | 454.31 | 135.3
[NAME] |  |  |  |  |  | 308.21 | 616.44 |  | 233.92 | 553.28
ATS |  |  |  |  |  |  | 269.9 |  |  | 107.5 |  |  |  |  |  | 239.63
Universal
Total Tyres
Truckcare |  | 2707.5 | 1795.92 | 2436.43 | 902.1 | 2315 | 1715 | 1882 | 2560 | 2532 | 3423.6 | 1712.72 | 1718.63 | 2210.2 | 2516.37 | 2433.53 | 1845.1 | 1544.47 | 1367.12 | 2106.76 | 2290.46 | 876.03 | 1810.49 | 1576.97 |  |  |  | 1445.4 | 997 | 1650.91 |  |  | 519.08 | 1172.14 | 386.79
Electrical |  |  | 480 |  |  |  |  |  |  |  |  |  |  |  |  | 82 |  |  |  |  |  |  |  |  | 265 | 1080 |  | 135 | 378 | 1302.54 |  | 157.2
NTB/Boleyn |  |  |  |  |  |  |  |  | 266.7 |  |  |  |  |  |  | 416 |  | 86.11 |  |  |  |  |  |  |  |  | 112 |  |  |  |  | 223.99 |  |  | 168 | 162
Other |  |  | 390.6 | 435.8 |  |  |  | 446.9 | 68 |  |  |  | 64 |  | 1431.9 |  | 279 |  | 239.25 |  |  |  |  | 270 |  |  |  |  |  |  |  | 1370 |  | 465.16
Other |  |  |  | 519.56 |  |  |  |  | 500.9 | 520 |  |  | 1645 |  | 80 |  | 805.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 217
Other |  |  |  |  |  |  |  |  |  |  |  |  | 257.54 |  |  | 1340 | 404
Trailers |  |  |  | 125 |  |  |  |  |  |  |  |  |  |  | 220 |  | 3140 |  |  |  |  |  |  |  | 2070 | 1820
Total Service
Total Maintenance
 | Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53
 |  | 2016-10-31 00:00:00 | 2016-11-07 00:00:00 | 2016-11-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  | xba -10 | EVW - 9 | DKX - 3.5 | VRG - 3 | DDJ - 5 | T12-3 | OFN-4.5 | EVW-5 | T5-9 | DDK-8 | GUA-3.5 | DXV-4 | [NAME] | T17-2 | t15-2.5 |  | WXR-3 | DKX 15.5 M | FDP- 3 | FAO 16.5 M |  |  | T23- 2 | ODL-10 | T17-2.5
 |  |  |  |  |  |  |  |  |  |  | T7 - 8.5 | T17 - 2.5 | T15 - 2 | T4- 2 | T19 - 3 | DXV-3 | T01-4 | GPZ-4.5 | HKL-6.5 | VRG-3 | T03-3.5 | T10-3 | T21-4 | EVW-3 | DKX-3.0 |  | T22- | OAZ - 3 | T21- 2 | EVW - 3.5 |  |  | WXR-5 | T22-2 | FDP-3.5
 |  |  |  |  |  |  |  |  |  |  | OFN - 6.5 | WXR - 4 | [NAME] | AFZ-4 | GPZ - 16.5 M | WXS- 3 | DKE-3.5 | T17-2 | AVF-5 | [NAME] | DKE-15.5 M | T04-2.5 | T09-5.5 | T18-0 | AVF-4 |  |  | T22 - 1.5 |  | T17 - 3.0 |  |  |  | OAZ-3
 |  |  |  |  |  |  |  |  |  |  | T1- 2 | T24-4 | T48- 5 | T11 -2.5 | GUA - 8 | OAZ-12 M | T14-2.5 | T50-2.5 | T20-2 | T18-2 | WXR-4 | WXS-3.5 | DDK-3 | DDJ-10 M | T05-3.5
 |  |  |  |  |  |  |  |  |  |  | HKL -MOT 20 | DYH-4.5 | AVF-3 | PX60- 3.5 | T51 - 4 | T22- 3 | T10-3 | DYH-4 |  | WXP-6.5 | T23-2 |  | FDP-2.5 | GPZ-3
 |  |  |  |  |  |  |  |  |  |  | DDK -3 | T6-3.5 | [NAME] -5 | T18-3 | T | OBG- 5.5 | FDP-3.5 | t16- 3.5 |  | T7-3.5 | T51-3 |  | T22-2.0 | T50 -3
 |  |  |  |  |  |  |  |  |  |  | T10 - 4 |  | HKL - 3 | YR0-5.0 |  | T4- 3 |  | T15 2.5 |  |  |  |  | OAZ-3.0 | T6-2.5
 |  |  |  |  |  |  |  |  |  |  |  |  | T-49 2.5 | T3-2 |  | T12-3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | WXR-2.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | T24-3