Spreadsheet: 716364d1612187462-preventative-maintenance-spreadsheet-using-kms-driven-to-determine-next-service-date-maintenance-tracking-spreadsheet
Sheet: Vehicle log

Vehicle # | License Plate | Last Service KMs | Date of Service | KMs Current | Date | KMs Current | Date Entered | Previous KMs | Date of Previous KMs | Difference
3-19 | 7050PK | 94160 | 2020-11-10 00:00:00 | 101440 | 2021-01-11 00:00:00 | 98096 | 2020-12-09 00:00:00 | 97851 | 2020-12-07 00:00:00 |  | 3-19 | 103244 | 2021-01-22 00:00:00
7-15 | BC97940 | 256068 | 2020-09-16 00:00:00 | 259015 | 2021-01-12 00:00:00 | 258047 | 2020-12-02 00:00:00 | 258106 | 2020-12-08 00:00:00 |  | 7-15 | 259384 | 2021-01-26 00:00:00
9-20 | BD99775 | 0 |  | 2356 | 2021-01-02 00:00:00 | 1627 | 2020-12-09 00:00:00 | 1475 | 2020-12-09 00:00:00 |  | 9-20 | 3475 | 2021-01-21 00:00:00
11-11 | AT22046 | 246090 | 2020-11-04 00:00:00 | 246425 | 2020-12-08 00:00:00 | 246425 | 2020-12-08 00:00:00 | 246244 | 2020-12-03 00:00:00 |  | 11-11 | 246827 | 2021-01-22 00:00:00
10-90 | AD88888 | 921510 | 2019-07-23 00:00:00 | 926147 | 2019-09-16 00:00:00 | 926147 | 2019-09-16 00:00:00 | 926147 | 2019-09-16 00:00:00 |  | 10-90 | 926147 | 2019-09-16 00:00:00
20-20 | PA16082 | 80000 | 2020-10-26 00:00:00 | 94851 | 2021-01-12 00:00:00 | 90266 | 2020-12-11 00:00:00 | 89290 | 2020-12-08 00:00:00 |  | 20-20 | 96551 | 2021-01-22 00:00:00
58-20 | BC82040 | 41387 | 2020-11-02 00:00:00 | 53688 | 2021-01-13 00:00:00 | 49825 | 2020-12-10 00:00:00 | 49500 | 2020-12-08 00:00:00 |  | 58-20 | 56011 | 2021-01-21 00:00:00
60-20 | BC82042 | 38833 | 2020-11-09 00:00:00 | 49465 | 2021-01-13 00:00:00 | 45267 | 2020-12-10 00:00:00 | 44330 | 2020-12-07 00:00:00 |  | 60-20 | 52500 | 2021-01-25 00:00:00
62-20 | AZ92464 | 72083 | 2020-11-05 00:00:00 | 74790 | 2021-01-14 00:00:00 | 73114 | 2020-12-09 00:00:00 | 73011 | 2020-12-07 00:00:00 |  | 62-20 | 76389 | 2021-01-22 00:00:00
64-20 | BE21121 | 10178 | 2020-11-11 00:00:00 | 19708 | 2021-01-13 00:00:00 | 16038 | 2020-12-11 00:00:00 | 15407 | 2020-12-08 00:00:00 |  | 64-20 | 21927 | 2021-01-25 00:00:00
66-18 | AW47189 | 152755 | 2020-11-19 00:00:00 | 161131 | 2021-01-13 00:00:00 | 157450 | 2020-12-11 00:00:00 | 157179 | 2020-12-10 00:00:00 |  | 66-18 | 163680 | 2021-01-25 00:00:00
68-18 | AW47190 | 158879 | 2020-10-28 00:00:00 | 172871 | 2021-01-13 00:00:00 | 168405 | 2020-12-11 00:00:00 | 168554 | 2020-12-10 00:00:00 |  | 68-18 | 175918 | 2021-01-25 00:00:00
72-07 | BC97936 | 704823 | 2020-10-26 00:00:00 | 717543 | 2021-01-13 00:00:00 | 713569 | 2020-12-11 00:00:00 | 713153 | 2020-12-09 00:00:00 |  | 72-07 | 719122 | 2021-01-20 00:00:00
74-20 | BE55405 | 0 |  | 4131 | 2021-01-14 00:00:00 | 2460 | 2020-12-09 00:00:00 | 2410 | 2020-12-09 00:00:00 |  | 74-20 | 5100 | 2021-01-22 00:00:00
76-18 | AY69733 | 57657 | 2020-10-20 00:00:00 | 58690 | 2021-01-04 00:00:00 | 58280 | 2020-11-26 00:00:00 | 58280 | 2020-11-26 00:00:00 |  | 76-18 | 59665 | 2021-01-22 00:00:00
80-08 | 1531PC | 773182 | 2020-11-18 00:00:00 | 775702 | 2020-12-09 00:00:00 | 775702 | 2020-12-09 00:00:00 | 775702 | 2020-12-09 00:00:00 |  | 80-08 | 775996 | 2021-01-15 00:00:00
82-11 | 9577PF | 785596 | 2020-10-28 00:00:00 | 795850 | 2021-01-11 00:00:00 | 793053 | 2020-12-11 00:00:00 | 791709 | 2020-12-08 00:00:00 |  | 82-11 | 796904 | 2021-01-22 00:00:00
84-07 | BC22575 | 111461 | 2020-10-26 00:00:00 | 115600 | 2021-01-08 00:00:00 | 115064 | 2020-12-08 00:00:00 | 115223 | 2020-12-11 00:00:00 |  | 84-07 | 115600 | 2021-01-18 00:00:00
90-10 | 4042PF | 927614 | 2020-10-16 00:00:00 | 932134 | 2020-12-17 00:00:00 | 931650 | 2020-12-11 00:00:00 | 931650 | 2020-12-11 00:00:00 |  | 90-10 | 932624 | 2021-01-19 00:00:00
92-10 | BC97938 | 705486 | 2020-10-26 00:00:00 | 717310 | 2021-01-13 00:00:00 | 714423 | 2020-12-09 00:00:00 | 712125 | 2020-11-30 00:00:00 |  | 92-10 | 719495 | 2021-01-25 00:00:00
98-14 | BB12632 | 196564 | 2020-10-13 00:00:00 | 199682 | 2021-01-14 00:00:00 | 199273 | 2020-12-09 00:00:00 | 198171 | 2020-12-07 00:00:00 |  | 98-14 | 200202 | 2021-01-21 00:00:00
100-14 | PA16083 | 150005 | 2020-11-12 00:00:00 | 152067 | 2021-01-14 00:00:00 | 150980 | 2020-11-26 00:00:00 | 150980 | 2020-11-26 00:00:00 |  | 100-14 | 153457 | 2021-01-22 00:00:00
102-12 | AP91106 | 177045 | 2019-10-07 00:00:00 | 185780 | 2021-01-12 00:00:00 | 185251 | 2020-12-10 00:00:00 | 185010 | 2020-12-07 00:00:00 |  | 102-12 | 186254 | 2021-01-22 00:00:00
104-12 | AV63263 | 214061 | 2020-02-11 00:00:00 | 221188 | 2021-01-02 00:00:00 | 220833 | 2020-12-10 00:00:00 | 220644 | 2020-12-07 00:00:00 |  | 104-12 | 221780 | 2021-01-22 00:00:00
106-14 | AY22491 | 90511 | 2020-09-17 00:00:00 | 94047 | 2021-01-14 00:00:00 | 91863 | 2020-12-09 00:00:00 | 91701 | 2020-12-07 00:00:00 |  | 106-14 | 95420 | 2021-01-22 00:00:00