油耗統(tǒng)計(jì)表格模板

油耗統(tǒng)計(jì)表格,,,,,,,,,,,

,,,,,,,,,,,,

總里程,12336,公里,統(tǒng)計(jì)天數(shù),345,天,平均油耗,7.28,升/百公里,,,

總油量,897.74,升,日均里程,35.76,公里,日均油費(fèi),￥17.39,元,,,

總油費(fèi),"￥6,000.00",元,平均油價(jià),￥6.68,元/升,平均油費(fèi),￥0.49,元/公里,,,

,,,,,,,,,,,,

序號(hào),日期,行駛天數(shù),里程表(km),行駛里程(km),加油金額,單價(jià),加油量(升),單次油耗,,,

1,2010/05/07,9,4839,331,￥150.00,￥6.63,22.62,6.84,,22.62443439,150

2,2010/05/16,8,5170,348,￥150.00,￥6.63,22.62,6.50,,22.62443439,150

3,2010/05/24,9,5518,312,￥150.00,￥6.63,22.62,7.25,,22.62443439,150

4,2010/06/02,9,5830,355,￥150.00,￥6.45,23.26,6.55,,23.25581395,150

5,2010/06/11,8,6185,312,￥150.00,￥6.45,23.26,7.45,,23.25581395,150

6,2010/06/19,8,6497,362,￥150.00,￥6.45,23.26,6.42,,23.25581395,150

7,2010/06/27,6,6859,220,￥100.00,￥6.45,15.50,7.05,,15.50387597,100

8,2010/07/03,6,7079,231,￥100.00,￥6.45,15.50,6.71,,15.50387597,100

9,2010/07/09,8,7310,210,￥100.00,￥6.45,15.50,7.38,,15.50387597,100

10,2010/07/17,4,7520,218,￥100.00,￥6.45,15.50,7.11,,15.50387597,100

11,2010/07/21,6,7738,206,￥100.00,￥6.45,15.50,7.53,,15.50387597,100

12,2010/07/27,4,7944,170,￥100.00,￥6.45,15.50,9.12,,15.50387597,100

13,2010/07/31,6,8114,235,￥100.00,￥6.45,15.50,6.60,,15.50387597,100

14,2010/08/06,7,8349,230,￥100.00,￥6.45,15.50,6.74,,15.50387597,100

15,2010/08/13,7,8579,245,￥100.00,￥6.45,15.50,6.33,,15.50387597,100

16,2010/08/20,7,8824,223,￥100.00,￥6.45,15.50,6.95,,15.50387597,100

17,2010/08/27,11,9047,449,￥200.00,￥6.45,31.01,6.91,,31.00775194,200

18,2010/09/07,12,9496,439,￥200.00,￥6.45,31.01,7.06,,31.00775194,200

19,2010/09/19,12,9935,387,￥200.00,￥6.45,31.01,8.01,,31.00775194,200

20,2010/10/01,9,10322,437,￥200.00,￥6.45,31.01,7.10,,31.00775194,200

21,2010/10/10,19,10759,436,￥200.00,￥6.45,31.01,7.11,,31.00775194,200

22,2010/10/29,22,11195,424,￥200.00,￥6.63,30.17,7.11,,30.16591252,200

23,2010/11/20,20,11619,607,￥300.00,￥6.63,45.25,7.45,,45.24886878,300

24,2010/12/10,9,12226,417,￥200.00,￥6.63,30.17,7.23,,30.16591252,200

25,2010/12/19,10,12643,390,￥200.00,￥6.63,30.17,7.73,,30.16591252,200

26,2010/12/29,5,13033,122,￥100.00,￥6.88,14.53,11.91,,14.53488372,100

27,2011/01/03,12,13155,545,￥300.00,￥6.88,43.60,8.00,,43.60465116,300

28,2011/01/15,6,13700,207,￥100.00,￥6.88,14.53,7.02,,14.53488372,100

29,2011/01/21,6,13907,329,￥200.00,￥6.88,29.07,8.84,,29.06976744,200

30,2011/01/27,27,14236,976,￥500.00,￥6.88,72.67,7.45,,72.6744186,500

31,2011/02/23,3,15212,196,￥100.00,￥7.15,13.99,7.14,,13.98601399,100

32,2011/02/26,12,15408,402,￥200.00,￥7.15,27.97,6.96,,27.97202797,200

33,2011/03/10,10,15810,607,￥300.00,￥7.15,41.96,6.91,,41.95804196,300

34,2011/03/20,11,16417,383,￥200.00,￥7.15,27.97,7.30,,27.97202797,200

35,2011/03/31,17,16800,375,￥200.00,￥7.15,27.97,7.46,,27.97202797,200

36,2011/04/17,,17175,,￥200