Spreadsheet: 539887d1506421247-calculating-car-daily-consumption-book2aa
Sheet: Sheet1

Date | Km | Lt. Filled | Consumtion Distance | Lt/Km
2017-06-19 00:00:00 | 41641 | 45.24 | noData | noData
2017-07-02 00:00:00 | 42469 | 44.62 | 828 | 0.05388888888888889
2017-07-03 00:00:00 | 42556 | 7.59 | 87 | 0.08724137931034483
 | 43110 | 35.54 | 554 | 0.06415162454873646
 | 43152 | 3.23 | 42 | 0.0769047619047619
 | 43670 | 39.51 | 518 | 0.07627413127413127
 | 44075 | 28.11 | 405 | 0.0694074074074074
 | 44824 | 60.29 | 749 | 0.08049399198931909
 | 45251 | 33.65 | 427 | 0.0788056206088993
 | 45732 | 37 | 481 | 0.07692307692307693
 | 45764 | 5.65 | 32 | 0.1765625
 | 46168 | 27.24 | 404 | 0.06742574257425742
 | 46265 | 5.73 | 97 | 0.05907216494845361
 | 46721 | 32.05 | 456 | 0.07028508771929824
 | 46780 | 4.59 | 59 | 0.07779661016949152
 | 46805 | 1.61 | 25 | 0.0644
 | 46888 | 6.41 | 83 | 0.07722891566265061
 | 47160 | 21.24 | 272 | 0.07808823529411764
 | 47206 | 5.62 | 46 | 0.1221739130434783
 | 47648 | 27.24 | 442 | 0.06162895927601809
 | 47706 | 4.42 | 58 | 0.07620689655172413
 | - | - | - | -
 |  |  |  |  |  |  | wrong
 |  |  |  |  |  |  | right (manual calc)
 |  |  | manual calc |  | nfSales1 | nfSales2 | nfsales3 | Glen1
Date | [NAME] | End Km | Lt. Consumed
2017-06-16 00:00:00 | 41521 | 41613 | noData |  | noData | noData | noData | noData
2017-06-20 00:00:00 | 41782 | 41782 | 0 |  | 0 | 0 | 0 | 0
2017-06-21 00:00:00 | 41782 | 41800 | 0.97 |  | 0.97 | 0.97 | 0.97 | 0.97
2017-06-22 00:00:00 | 41800 | 41950 | 8.083333333333334 |  | 8.083333333333334 | 8.083333333333334 | 8.083333333333334 | 8.083333333333334
2017-06-23 00:00:00 | 41950 | 42029 | 4.257222222222222 |  | 4.257222222222222 | 4.257222222222222 | 4.257222222222222 | 4.257222222222222
2017-06-26 00:00:00 | 42053 | 42077 | 1.293333333333333 |  | 1.293333333333333 | 1.293333333333333 | 1.293333333333333 | 1.293333333333333
2017-06-27 00:00:00 | 42100 | 42170 | 3.772222222222222 |  | 3.772222222222222 | 3.772222222222222 | 3.772222222222222 | 3.772222222222222
2017-06-28 00:00:00 | 42170 | 42229 | 3.179444444444445 |  | 3.179444444444445 | 3.179444444444445 | 3.179444444444445 | 3.179444444444445
2017-06-29 00:00:00 | 42229 | 42298 | 3.718333333333333 |  | 3.718333333333333 | 3.718333333333333 | 3.718333333333333 | 3.718333333333333
2017-06-30 00:00:00 | 42298 | 42365 | 3.610555555555556 |  | 3.610555555555556 | 3.610555555555556 | 3.610555555555556 | 3.610555555555556
2017-07-03 00:00:00 | 42410 | 42429 | 1.023888888888889 |  | 1.023888888888889 | 1.023888888888889 | 1.023888888888889 | 1.023888888888889
2017-07-04 00:00:00 | 42554 | 42633 | 5.114157848873398 |  | 5.114157848873398 | 5.114157848873398 | 5.114157848873398 | 5.114157848873398
 | 42633 | 42754 | 7.762346570397112 |  | 7.762346570397112 | 7.762346570397112 | 7.762346570397112 | 7.762346570397112
 | 42754 | 42908 | 9.879350180505416 |  | 9.879350180505416 | 9.879350180505416 | 9.879350180505416 | 9.879350180505416
 | 42908 | 43023 | 7.377436823104693 |  | 7.377436823104693 | 7.377436823104693 | 7.377436823104693 | 7.377436823104693
 | 43023 | 43051 | 1.796245487364621 |  | 1.796245487364621 | 1.796245487364621 | 1.796245487364621 | 1.796245487364621
 | 43154 | 43212 | 4.423899613899613 |  | 4.423899613899613 | 4.423899613899613 | 4.423899613899613 | 4.423899613899613
 | 43212 | 43287 | 5.720559845559845 |  | 5.720559845559845 | 5.720559845559845 | 5.720559845559845 | 5.720559845559845
 | 43287 | 43434 | 11.2122972972973 |  | 11.2122972972973 | 11.2122972972973 | 11.2122972972973 | 11.2122972972973
 | 43485 | 43563 | 5.949382239382239 |  | 5.949382239382239 | 5.949382239382239 | 5.949382239382239 | 5.949382239382239
 | 43563 | 43586 | 1.754305019305019 |  | 1.754305019305019 | 1.754305019305019 | 1.754305019305019 | 1.754305019305019
 | 43667 | 43755 | 6.128452023452023 |  | 6.128452023452023 | 6.128452023452023 | 6.128452023452023 | 6.128452023452023
 | 43755 | 43819 | 4.442074074074074 |  | 4.442074074074074 | 4.442074074074074 | 4.442074074074074 | 4.442074074074074
 | 43819 | 43933 | 7.912444444444444 |  | 7.912444444444444 | 7.912444444444444 | 7.912444444444444 | 7.912444444444444
 | 43933 | 44049 | 8.05125925925926 |  | 8.05125925925926 | 8.05125925925926 | 8.05125925925926 | 8.05125925925926
 | 44049 | 44072 | 1.59637037037037 |  | 1.59637037037037 | 1.59637037037037 | 1.59637037037037 | 1.59637037037037
 | 44228 | 44290 | 4.990627503337783 |  | 4.990627503337783 | 4.990627503337783 | 4.990627503337783 | 4.990627503337783
 | 44290 | 44379 | 7.163965287049399 |  | 7.163965287049399 | 7.163965287049399 | 7.163965287049399 | 7.163965287049399
 | 44379 | 44540 | 12.95953271028037 |  | 12.95953271028037 | 12.95953271028037 | 12.95953271028037 | 12.95953271028037
 | 44540 | 44600 | 4.829639519359145 |  | 4.829639519359145 | 4.829639519359145 | 4.829639519359145 | 4.829639519359145
 | 44660 | 44680 | 1.609879839786382 |  | 1.609879839786382 | 1.609879839786382 | 1.609879839786382 | 1.609879839786382
 | 45251 | 45328 | 5.923076923076923 |  | 6.068032786885246 | 5.923076923076923 | 6.068032786885246 | 5.923076923076923
 | 45328 | 45403 | 5.769230769230769 |  | 5.769230769230769 | 5.769230769230769 | 5.769230769230769 | 5.769230769230769
 | 45403 | 45563 | 12.30769230769231 |  | 12.30769230769231 | 12.30769230769231 | 12.30769230769231 | 12.30769230769231
 | 45563 | 45711 | 11.38461538461539 |  | 11.38461538461539 | 11.38461538461539 | 11.38461538461539 | 11.38461538461539
 | 45711 | 45732 | 1.615384615384615 |  | 1.615384615384615 | 1.615384615384615 | 1.615384615384615 | 1.615384615384615
 | 45764 | 45817 | 3.573564356435643 |  | 9.357812500000001 | 3.573564356435643 | 9.357812500000001 | 3.573564356435643
 | 45817 | 45936 | 8.023663366336633 |  | 8.023663366336633 | 8.023663366336633 | 8.023663366336633 | 8.023663366336633
 | 45936 | 46038 | 6.877425742574257 |  | 6.877425742574257 | 6.877425742574257 | 6.877425742574257 | 6.877425742574257
 | 46038 | 46138 | 6.742574257425741 |  | 6.742574257425741 | 6.742574257425741 | 6.742574257425741 | 6.742574257425741
 | 46138 | 46168 | 2.022772277227722 |  | 2.022772277227722 | 2.022772277227722 | 2.022772277227722 | 2.022772277227722
 | 46265 | 46325 | 4.217105263157895 |  | 3.544329896907217 | 4.217105263157895 | 3.544329896907217 | 4.217105263157895
 | 46325 | 46435 | 7.731359649122806 |  | 7.731359649122806 | 7.731359649122806 | 7.731359649122806 | 7.731359649122806
 | 46435 | 46631 | 13.77587719298246 |  | 13.77587719298246 | 13.77587719298246 | 13.77587719298246 | 13.77587719298246
 | 46631 | 46706 | 5.271381578947368 |  | 5.271381578947368 | 5.271381578947368 | 5.271381578947368 | 5.271381578947368
 | 46779 | 46805 | 1.687796610169491 |  | 1.687796610169491 | 2.008519501735757 | 1.687796610169491 | 2.008519501735757
 | 46888 | 46952 | 4.997647058823529 |  | 4.942650602409639 | 4.997647058823529 | 4.942650602409639 | 4.997647058823529
 | 46952 | 47072 | 9.370588235294116 |  | 9.370588235294116 | 9.370588235294116 | 9.370588235294116 | 9.370588235294116
 | 47072 | 47115 | 3.357794117647058 |  | 3.357794117647058 | 3.357794117647058 | 3.357794117647058 | 3.357794117647058
 | 47115 | 47140 | 1.952205882352941 |  | 1.952205882352941 | 1.952205882352941 | 1.952205882352941 | 1.952205882352941
 | 47140 | 47160 | 1.561764705882353 |  | 1.561764705882353 | 1.561764705882353 | 1.561764705882353 | 1.561764705882353
 | 47206 | 47267 | 3.759366515837104 |  | 7.452608695652174 | 3.759366515837104 | 7.452608695652174 | 3.759366515837104
 | 47267 | 47352 | 5.238461538461538 |  | 5.238461538461538 | 5.238461538461538 | 5.238461538461538 | 5.238461538461538
 | 47352 | 47510 | 9.73737556561086 |  | 9.73737556561086 | 9.73737556561086 | 9.73737556561086 | 9.73737556561086
 | 47510 | 47624 | 7.025701357466063 |  | 7.025701357466063 | 7.025701357466063 | 7.025701357466063 | 7.025701357466063
 | 47624 | 47648 | 1.479095022624434 |  | 1.479095022624434 | 1.479095022624434 | 1.479095022624434 | 1.479095022624434
 | 47706 | 47777 | noData |  | 5.410689655172414 | No Data | No Data | noData
 | - | - | - | - | - | - | - | -
 | 40716 | 40851 | noData |  | noData | noData | noData | noData
 | 41152 | 41278 | noData |  | noData | noData | noData | noData
 | 41613 | 41782 | noData |  | noData | noData | noData | noData
 | 42029 | 42053 | 1.293333333333333 |  | 1.293333333333333 | 1.293333333333333 | 1.293333333333333 | 1.293333333333333
 | 42077 | 42100 | 1.239444444444444 |  | 1.239444444444444 | 1.239444444444444 | 1.239444444444444 | 1.239444444444444
 | 42365 | 42410 | 2.425 |  | 2.425 | 2.425 | 2.425 | 2.425
 | 42429 | 42554 | 9.571072796934866 |  | 9.571072796934866 | 9.571072796934866 | 9.571072796934866 | 9.571072796934866
 | 43051 | 43154 | 7.167494110923713 |  | 7.141007624437227 | 7.141007624437227 | 7.141007624437227 | 7.141007624437227
 | 43434 | 43485 | 3.889980694980695 |  | 3.889980694980695 | 3.889980694980695 | 3.889980694980695 | 3.889980694980695
 | 43586 | 43667 | 6.178204633204633 |  | 6.178204633204633 | 6.178204633204633 | 6.178204633204633 | 6.178204633204633
 | 44072 | 44228 | 12.52380299658804 |  | 12.52380299658804 | 12.52380299658804 | 12.52380299658804 | 12.52380299658804
 | 44600 | 44660 | 4.829639519359145 |  | 4.829639519359145 | 4.829639519359145 | 4.829639519359145 | 4.829639519359145
 | 44680 | 45251 | 45.24113484646195 |  | 45.24113484646195 | 44.43728869261579 | 45.24113484646195 | 44.43728869261579
 | 45732 | 45764 | 5.65 |  | 5.65 | 5.65 | 5.65 | 5.65
 | 46168 | 46265 | 5.73 |  | 5.73 | 5.73 | 5.73 | 5.73
 | 46706 | 46779 | 5.566479705619981 |  | 5.566479705619981 | 5.566479705619981 | 5.566479705619981 | 5.566479705619981
 | 46805 | 46888 | 6.410000000000001 |  | 6.410000000000001 | 6.410000000000001 | 6.410000000000001 | 6.410000000000001
 | 47160 | 47206 | 5.62 |  | 5.62 | 5.62 | 5.62 | 5.62
 | 47648 | 47706 | 4.42 |  | 4.42 | noData | 4.42 | 4.42