Spreadsheet: 537384d1505035551-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
 | - | - | - | -
 |  |  | formula1
Date | [NAME] | End Km | Lt. Consumed | manual calc |  |  |  |  |  |  |  | formula2 | formula3
2017-06-16 00:00:00 | 41521 | 41613 | noData | noData |  |  |  |  |  |  |  | noData | noData
2017-06-20 00:00:00 | 41782 | 41782 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0
2017-06-21 00:00:00 | 41782 | 41800 | 0.97 | 0.97 |  |  |  |  |  |  |  | 0.97 | 0.97
2017-06-22 00:00:00 | 41800 | 41950 | 8.083333333333334 | 8.083333333333334 |  |  |  |  |  |  |  | 8.083333333333334 | 8.083333333333334
2017-06-23 00:00:00 | 41950 | 42029 | 4.257222222222222 | 4.257222222222222 |  |  |  |  |  |  |  | 4.257222222222222 | 4.257222222222222
2017-06-26 00:00:00 | 42053 | 42077 | 1.293333333333333 | 1.293333333333333 |  |  |  |  |  |  |  | 1.293333333333333 | 1.293333333333333
2017-06-27 00:00:00 | 42100 | 42170 | 3.772222222222222 | 3.772222222222222 |  |  |  |  |  |  |  | 3.772222222222222 | 3.772222222222222
2017-06-28 00:00:00 | 42170 | 42229 | 3.179444444444445 | 3.179444444444445 |  |  |  |  |  |  |  | 3.179444444444445 | 3.179444444444445
2017-06-29 00:00:00 | 42229 | 42298 | 3.718333333333333 | 3.718333333333333 |  |  |  |  |  |  |  | 3.718333333333333 | 3.718333333333333
2017-06-30 00:00:00 | 42298 | 42365 | 3.610555555555556 | 3.610555555555556 |  |  |  |  |  |  |  | 3.610555555555556 | 3.610555555555556
2017-07-03 00:00:00 | 42410 | 42429 | 1.023888888888889 | 1.023888888888889 |  |  |  |  |  |  |  | 1.023888888888889 | 1.023888888888889
2017-07-04 00:00:00 | 42554 | 42633 | 5.114157848873398 | 5.114157848873398 |  |  |  |  |  |  |  | 5.114157848873398 | 5.114157848873398
 | 42633 | 42754 | 7.762346570397112 | 7.762346570397112 |  |  | wrong |  |  |  |  | 7.762346570397112 | 7.762346570397112
 | 42754 | 42908 | 9.879350180505416 | 9.879350180505416 |  |  | right (manual calc) |  |  |  |  | 9.879350180505416 | 9.879350180505416
 | 42908 | 43023 | 7.377436823104693 | 7.377436823104693 |  |  |  |  |  |  |  | 7.377436823104693 | 7.377436823104693
 | 43023 | 43051 | 1.796245487364621 | 1.796245487364621 |  |  |  |  |  |  |  | 1.796245487364621 | 1.796245487364621
 | 43154 | 43212 | 4.423899613899613 | 4.423899613899613 |  |  |  |  |  |  |  | 4.423899613899613 | 4.423899613899613
 | 43212 | 43287 | 5.720559845559845 | 5.720559845559845 |  |  |  |  |  |  |  | 5.720559845559845 | 5.720559845559845
 | 43287 | 43434 | 11.2122972972973 | 11.2122972972973 |  |  |  |  |  |  |  | 11.2122972972973 | 11.2122972972973
 | 43485 | 43563 | 5.949382239382239 | 5.949382239382239 |  |  |  |  |  |  |  | 5.949382239382239 | 5.949382239382239
 | 43563 | 43586 | 1.754305019305019 | 1.754305019305019 |  |  |  |  |  |  |  | 1.754305019305019 | 1.754305019305019
 | 43667 | 43755 | 6.128452023452023 | 6.128452023452023 |  |  |  |  |  |  |  | 6.128452023452023 | 6.128452023452023
 | 43755 | 43819 | 4.442074074074074 | 4.442074074074074 |  |  |  |  |  |  |  | 4.442074074074074 | 4.442074074074074
 | 43819 | 43933 | 7.912444444444444 | 7.912444444444444 |  |  |  |  |  |  |  | 7.912444444444444 | 7.912444444444444
 | 43933 | 44049 | 8.05125925925926 | 8.05125925925926 |  |  |  |  |  |  |  | 8.05125925925926 | 8.05125925925926
 | 44049 | 44072 | 1.59637037037037 | 1.59637037037037 |  |  |  |  |  |  |  | 1.59637037037037 | 1.59637037037037
 | 44228 | 44290 | 4.990627503337783 | 4.990627503337784 |  |  |  |  |  |  |  | 4.990627503337783 | 4.990627503337783
 | 44290 | 44379 | 7.163965287049399 | 7.163965287049399 |  |  |  |  |  |  |  | 7.163965287049399 | 7.163965287049399
 | 44379 | 44540 | 12.95953271028037 | 12.95953271028037 |  |  |  |  |  |  |  | 12.95953271028037 | 12.95953271028037
 | 44540 | 44600 | 4.829639519359145 | 4.829639519359146 |  |  |  |  |  |  |  | 4.829639519359145 | 4.829639519359145
 | 44660 | 44680 | 1.609879839786382 | 1.609879839786382 |  |  |  |  |  |  |  | 1.609879839786382 | 1.609879839786382
 | 45251 | 45328 | 6.068032786885246 | 5.923076923076923 |  |  | wrong |  |  |  |  | 5.923076923076923 | 6.068032786885246
 | 45328 | 45403 | 5.769230769230769 | 5.769230769230769 |  |  | right (manual calc) |  |  |  |  | 5.769230769230769 | 5.769230769230769
 | 45403 | 45563 | 12.30769230769231 | 12.30769230769231 |  |  |  |  |  |  |  | 12.30769230769231 | 12.30769230769231
 | 45563 | 45711 | 11.38461538461539 | 11.38461538461539 |  |  |  |  |  |  |  | 11.38461538461539 | 11.38461538461539
 | 45711 | 45732 | 1.615384615384615 | 1.615384615384615 |  |  |  |  |  |  |  | 1.615384615384615 | 1.615384615384615
 | 45764 | 45817 | 9.357812500000001 | 9.3578125 |  |  |  |  |  |  |  | 3.573564356435643 | 9.357812500000001
 | 45817 | 45936 | 8.023663366336633 | 8.023663366336633 |  |  |  |  |  |  |  | 8.023663366336633 | 8.023663366336633
 | 45936 | 46038 | 6.877425742574257 | 6.877425742574257 |  |  |  |  |  |  |  | 6.877425742574257 | 6.877425742574257
 | 46038 | 46138 | 6.742574257425741 | 6.742574257425741 |  |  |  |  |  |  |  | 6.742574257425741 | 6.742574257425741
 | 46138 | 46168 | 2.022772277227722 | 2.022772277227722 |  |  |  |  |  |  |  | 2.022772277227722 | 2.022772277227722
 | 46265 | 46325 | 3.544329896907217 | 4.217105263157895 |  |  |  |  |  |  |  | 4.217105263157895 | 3.544329896907217
 | 46325 | 46435 | 7.731359649122806 | 7.731359649122806 |  |  |  |  |  |  |  | 7.731359649122806 | 7.731359649122806
 | 46435 | 46631 | 13.77587719298246 | 13.77587719298246 |  |  |  |  |  |  |  | 13.77587719298246 | 13.77587719298246
 | 46631 | 46706 | 5.271381578947368 | 5.271381578947368 |  |  |  |  |  |  |  | 5.271381578947368 | 5.271381578947368
 | 46779 | 46805 | 1.687796610169491 | 1.687796610169491 |  |  |  |  |  |  |  | noData | 1.687796610169491