Spreadsheet: 745376d1629890932-sum-if-vlookup-matches-criteria-copy-of-raw-data
Sheet: Data_Input (2)

 |  | Date | [NAME] | Vehicle Fleet Number | Driver | Volume | Volume from D-Bowser | Destination | Initial KM | Float | Final KM | Total KM/HRS | Float Variance | [NAME] in LTRS | Actual Volume Used | Average LITRE/KM-HR | Reg Number | Vehicle Type | [NAME] | Cost | Price per Liter | Destination | Cost/KM
 |  | 2021-08-23 00:00:00 | STATION 1 | SWEEPER |  | 68 |  | PLANT | 2873012 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | Bus 5 |  | 40 |  | [NAME] | 75745 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-38 | [NAME] | 25 |  | READY MIX | 148043 | 13.3
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-30 | [NAME] | 148 |  | NDOLA | 47287 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | LD 02 |  | 230 |  | PROCESS | 40147.8 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | Ready mix 01 |  | 230 |  | READY MIX | 14284 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | ABH 7490 |  | 40 |  | [NAME] | 0 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | Coster bus-2 |  | 46 |  | [NAME] | 65825 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | CCR Van |  | 31 |  | [NAME] | 307666 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | Ready mix 07 |  | 150 |  | READY MIX | 15574 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-67 | [NAME] | 70 |  | KITWE | 1016590 | 11.8
 |  | 2021-08-23 00:00:00 | STATION 1 | Coster bus-1 |  | 41 |  | [NAME] | 42399 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | BAE6956 |  | 40 |  | [NAME] | 91776 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | DT-740-10 |  | 200 |  | PROCESS | 597.1 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | LD 05 |  | 154 |  | QUARRY | 5037.6 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | D.BOWSER |  | 1100 |  | QUARRY | 0 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-52 | [NAME] | 25 |  | NDOLA | 965082 | 11.2
 |  | 2021-08-23 00:00:00 | STATION 1 | WORKSHOP REQ. |  | 5 |  | W.SHOP | 0 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-06 |  | 35 |  | READY MIX | 39369 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | GRADER 140k |  | 231 |  | QUARRY | 9588.8 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-53 | [NAME] | 25 |  | NDOLA | 896599 | 12.3
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-66 | [NAME] | 70 |  | KITWE | 1049011 | 6.9
 |  | 2021-08-23 00:00:00 | STATION 1 | [NAME] | [NAME] | 286 |  | SOLWEZI | 114335 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | [NAME]'s truck | [NAME] | 110 |  | KAPIRI | 59042 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-07 | [NAME] | 70 |  | KITWE | 64550 | 7.4
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-40 | Mabvuto Musukwa | 170 |  | KABWE | 943947 | 10.2
 |  | 2021-08-23 00:00:00 | STATION 1 | BAA-2877 |  | 57 |  | [NAME] | 233866 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | Ready mix 05 |  | 175 |  | READY MIX | 13924 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | Ready mix 04 |  | 194 |  | READY MIX | 15975 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-90 | [NAME] | 285 |  | SOLWEZI | 1284914 | 11.8
 |  | 2021-08-23 00:00:00 | STATION 1 | WORKSHOP REQ. |  | 5 |  | W.SHOP | 0 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | W.BOWSER-740 |  | 218 |  | [NAME] | 9676.4 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-27 | [NAME] | 20 |  | NDOLA | 1104089 | 10.2
 |  | 2021-08-23 00:00:00 | STATION 1 | [NAME] |  | 110 |  | KAPIRI | 896357 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | ABZ-6320 |  | 39 |  | LOCAL | 260825 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | DG@MD's Resi. |  | 60 |  | LOCAL | 0 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-64 | [NAME] | 125 |  | MOKAMBO | 910562 | 12.1
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-89 | [NAME] | 40 |  | SAKANYA | 1180328 | 11.9
 |  | 2021-08-23 00:00:00 | STATION 1 | Inter-bus-1 |  | 20 |  | [NAME] | 26969 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-22 | Mukonde Sondashi | 40 |  | FLOAT | 133381 | 9
 |  | 2021-08-23 00:00:00 | STATION 1 | LD 06 |  | 280 |  | PROCESS | 3679 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | BAA-8316 |  | 60 |  | [NAME] | 111256 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | DT-730-09 |  | 132 |  | PROCESS | 34541.1 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-84 | [NAME] | 310 |  | LUSAKA | 943309 | 5.3
 |  | 2021-08-23 00:00:00 | STATION 1 | LD 03 |  | 157 |  | PROCESS | 4795.3 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | DT-725 |  | 164 |  | PROCESS | 28192.9 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-68 | [NAME] | 160 |  | KASUMBALESA | 985440 | 4.4
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-41 | [NAME] | 350 |  | [NAME] | 973533 | 9
 |  | 2021-08-23 00:00:00 | STATION 1 | [NAME] | [NAME] | 285 |  | SERENJE | 952365 | 12.6
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-65 | [NAME] | 160 |  | KASUMBALESA | 958078 | 12.7
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-45 | [NAME] | 160 |  | KASUMBALESA | 1086824 | 7.9
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-11 | [NAME] | 160 |  | KASUMBALESA | 55267 | 8.3
 |  | 2021-08-23 00:00:00 | STATION 1 | Silicosis |  | 78 |  | [NAME] | 22162 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-22 | Mukonde Sondashi | 40 |  | SAKANYA | 133381 | 9
 |  | 2021-08-23 00:00:00 | STATION 1 | LD 02 |  | 80 |  | PROCESS | 40153.3 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-33 | Bright Mazila | 160 |  | KASUMBALESA | 49815 | 10.2
 |  | 2021-08-23 00:00:00 | STATION 1 | [NAME] | [NAME] | 160 |  | KASUMBALESA | 704463 | 8.8
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-60 | [NAME] | 285 |  | SOLWEZI | 909310 | 5.7
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-78 | [NAME] | 160 |  | KASUMBALESA | 815944 | 9.7
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-36 | [NAME] | 70 |  | KITWE | 865185 | 5.6
 |  | 2021-08-23 00:00:00 | STATION 1 | LD 05 |  | 85 |  | PROCESS | 5042.2 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-72 | Borniface Tembo | 160 |  | KASUMBALESA | 962145 | 9.3
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-44 | [NAME] | 40 |  | SAKANYA | 1091452 | 9.1
 |  | 2021-08-23 00:00:00 | STATION 1 | [NAME] | [NAME] | 40 |  | SAKANYA | 1035256 | 10.9
 |  | 2021-08-23 00:00:00 | STATION 1 | MT-74 | [NAME] | 870 |  | NAKONDE | 786833 | 8.8
 |  | 2021-08-23 00:00:00 | STATION 1 | LD 01 |  | 170 |  | PROCESS | 46404.5 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | LD 07 |  | 50 |  | PROCESS | 7524.5 | 0
 |  | 2021-08-23 00:00:00 | STATION 1 | [NAME] | [NAME] | 160 |  | KASUMBALESA | 952372 | 8.1
 |  | 2021-08-23 00:00:00 | DIESEL BOWSER | EX-345 |  |  | 469 | QUARRY | 14990.8 | 0
 |  | 2021-08-23 00:00:00 | DIESEL BOWSER | D6 |  |  | 365 | QUARRY | 9824 | 0
 |  | 2021-08-23 00:00:00 | DIESEL BOWSER | DRILL 14 |  |  | 225 | QUARRY | 11132 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | MT-46 | [NAME] | 285 |  | SOLWEZI | 1168610 | 9.8
 |  | 2021-08-24 00:00:00 | STATION 1 | MT-27 | [NAME] | 285 |  | SOLWEZI | 1104128 | 9.3
 |  | 2021-08-24 00:00:00 | STATION 1 | MT-71 | [NAME] | 160 |  | KASUMBALESA | 918454 | 6.2
 |  | 2021-08-24 00:00:00 | STATION 1 | W.BOWSER-740 |  | 171 |  | [NAME] | 9682.2 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | Bus 5 |  | 40 |  | [NAME] | 76108 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | Bonano 1 | [NAME] | 160 |  | KASUMBALESA | 890577 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | Coster bus-1 |  | 40 |  | [NAME] | 42725 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | CCR Van |  | 34 |  | [NAME] | 307947 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | LD 07 |  | 133 |  | PROCESS | 7536.5 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | ALR-6422 |  | 60 |  | [NAME] | 110533 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | LD 05 |  | 142 |  | QUARRY | 5053.4 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | MT-58 | [NAME] | 280 |  | MANSA | 950362 | 11.7
 |  | 2021-08-24 00:00:00 | STATION 1 | LD 03 |  | 130 |  | PROCESS | 4805.9 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | Coster bus-2 |  | 45 |  | [NAME] | 66030 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | Coster bus-3 |  | 4 |  | [NAME] | 253474 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | MT-54 | [NAME] | 340 |  | LUSAKA | 894348 | 6.8
 |  | 2021-08-24 00:00:00 | STATION 1 | LD 06 |  | 130 |  | PROCESS | 3686.9 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | MT-16 | Given Mweemba | 110 |  | KAPIRI | 47839 | 7.7
 |  | 2021-08-24 00:00:00 | STATION 1 | DT-730-09 |  | 60 |  | PROCESS | 34546.7 | 0
 |  | 2021-08-24 00:00:00 | STATION 1 | MT-24 | [NAME] | 170 |  | KABWE | 758114 | 8
 |  | 2021-08-24 00:00:00 | STATION 1 | DT-730-10 |  | 76 |  | PROCESS | 30012.6 | 0
 |  | 2021-08-25 00:00:00 | STATION 1 | LD 02 |  | 231 |  | PROCESS | 40169.9 | 0
 |  |  |  | DT-740-04 |  | 383 |  | QUARRY | 4139.2 | 0
 |  |  |  | DT-740-07 |  | 406 |  | QUARRY | 1480.4 | 0
 |  |  |  | DT-740-01 |  | 419 |  | QUARRY | 2721.4 | 0
 |  |  |  | DT-740-09 |  | 316 |  | QUARRY | 31539.9 | 0
 |  |  |  | DT-740-02 |  | 420 |  | QUARRY | 1746.1 | 0
 |  |  |  | LD 05 |  | 140 |  | QUARRY | 5066 | 0
 |  |  |  | Ready mix 03 |  | 150 |  | READY MIX | 15858 | 0
 |  |  |  | LD 01 |  | 153 |  | PROCESS | 6701.1 | 0
 |  |  |  | MT-91 | Recent Mweemba | 280 |  | MANSA | 1615686 | 6.1
 |  |  |  | Coster bus-2 |  | 45 |  | [NAME] | 66257 | 0
 |  |  |  | Inter-bus-1 |  | 20 |  | [NAME] | 27028 | 0
 |  |  |  | Bus 5 |  | 48 |  | [NAME] | 76336 | 0
 |  |  |  | MT-80 |  | 192 |  | MOKAMBO | 761490 | 8.3
 |  |  |  | [NAME] LIFT-3 |  | 35 |  | MOBILE | 1228 | 0
 |  |  |  | CCR Van |  | 33 |  | [NAME] | 308219 | 0
 |  |  |  | MT-57 | [NAME] | 170 |  | KABWE | 756007 | 10.5
 |  |  |  | [NAME] |  | 450 |  | QUARRY | 0 | 0
 |  |  |  | [NAME] | [NAME] | 285 |  | SOLWEZI | 1032604 | 9.4