Mpg Spreadsheet - Excel

Document Sample
Mpg Spreadsheet - Excel Powered By Docstoc
					2004 Prius - Year 6                                                                                   Location: MINNESOTA           Oil: SYNTHETIC      Driving: MIX of City, Suburb, and Highway

  Date       MPG shown   MPG calc'd   Lifetime MPG    Total Miles       Gallons     Total Gallons     Fuel: Low-Sulfur E10 (10% ethanol, 90% gas)     (the ethanol reduces efficiency by about 1.7 MPG)
10/31/2008     47.5         44.1          48.0         107,163          2,233.906     2,233.906
11/07/2008     49.9         50.4          48.0         107,535           7.377        2,241.283       Tires: Premium Grade at 44/42 PSI (these high-traction tires reduce efficiency by about 1.5 MPG)
11/11/2008     46.0         47.8          48.0         107,888           7.379        2,248.662
11/18/2008     46.5         44.4          48.0         108,221           7.504        2,256.166
11/25/2008     44.4         42.6          47.9         108,544           7.553        2,263.719
11/30/2008     44.8         42.8          47.9         108,715           3.995        2,267.714                     MPG       Miles     Gallons
12/08/2008     44.9         42.8          47.9         109,034           7.470        2,275.184       Nov - 08      45.9      1,552      33.808
12/14/2008     43.8         42.3          47.9         109,365           7.796        2,282.980       Dec - 08      42.3      1,552      36.706
12/21/2008     40.9         43.6          47.9         109,662           6.795        2,289.775       Jan - 09      42.0      1,616      38.515
12/25/2008     40.0         40.3          47.9         109,845           4.536        2,294.311       Feb - 09      44.0      1,396      31.697
12/25/2008     42.7         39.0          47.9         110,000           3.973        2,298.284       Mar - 09      44.2      1,638      37.038
12/31/2008     43.3         43.6          47.9         110,267           6.136        2,304.420       Apr - 09      46.2      1,869      40.419
1/06/2009      42.2         38.8          47.8         110,550           7.294        2,311.714       May - 09      51.1      1,399      27.351
1/09/2009      45.8         47.0          47.8         110,867           6.751        2,318.465       TOTAL         44.9     11,022     245.534
1/16/2009      38.9         40.8          47.8         111,111           5.996        2,324.461
1/22/2009      46.3         40.8          47.8         111,406           7.237        2,331.698
1/29/2009      40.8         41.7          47.8         111,698           6.981        2,338.679
1/31/2009      48.1         43.5          47.8         111,883           4.256        2,342.935
2/07/2009      41.9         41.1          47.7         112,158           6.668        2,349.603
2/14/2009      44.8         43.4          47.7         112,467           7.128        2,356.731
2/19/2009      44.0         48.7          47.7         112,745           5.703        2,362.434
2/21/2009      46.8         41.5          47.7         112,978           5.617        2,368.051
2/27/2009      45.1         45.7          47.7         113,279           6.581        2,374.632                                                                                  Month MPG Average
3/05/2009      44.2         39.2          47.7         113,574           7.527        2,382.159
3/12/2009      43.7         45.0          47.7         113,887           6.948        2,389.107     56.0
3/17/2009      47.8         44.4          47.7         114,226           7.656        2,396.763
3/24/2009      47.6         47.5          47.7         114,584           7.518        2,404.281     54.0
3/30/2009      46.8         45.1          47.7         114,917           7.389        2,411.670
4/05/2009      46.1         44.6          47.6         115,246           7.370        2,419.040     52.0                                                     51.1
4/11/2009      46.8         47.1          47.6         115,559           6.627        2,425.667
4/18/2009      42.1         43.3          47.6         115,772           4.877        2,430.544     50.0
4/19/2009      46.2         42.7          47.6         116,082           7.267        2,437.811
4/25/2009      51.0         49.6          47.6         116,465           7.704        2,445.515     48.0
4/30/2009      50.5         48.8          47.6         116,786           6.574        2,452.089                                                      46.2
                                                                                                             45.9
5/07/2009      52.2         50.8          47.6         117,175           7.643        2,459.732     46.0
5/13/2009      51.0         51.4          47.6         117,567           7.633        2,467.365                                              44.2
                                                                                                                                      44.0
5/21/2009      49.8         51.2          47.7         117,952           7.503        2,474.868     44.0
5/26/2009      51.9         51.0          47.7         118,185           4.572        2,479.440                       42.3   42.0
                                                                                                    42.0
                                          MPG shown        MPG calc'd            Lifetime MPG       40.0
 58.0                                                                                                           Dec 08
                                                                                                           Nov 08     Jan 09Feb 09    Apr 09 ay 09
                                                                                                                                 Mar 09    M                      Sep 09
                                                                                                                                                 Jun 09Jul 09Aug 09     Oct 09
 56.0
 54.0
 52.0
 50.0
 48.0
 46.0
 44.0
 42.0
 40.0
 38.0
        Nov 08
   Oct 08               Feb 09
             Dec 08Jan 09     Mar 09
                                   Apr 09    Jun 09Jul 09Aug 09
                                        May 09                Sep 09Oct 09

				
DOCUMENT INFO
Description: Mpg Spreadsheet document sample