Spreadsheet: 98548d1297410599-how-to-calculate-averages-and-totals-based-on-yearly-and-monthly-ranges-764007_exceleratorstuck
Sheet: gas mileage

GAS   MILEAGE |  |  |  |  |  |  |  | AND THE FUEL BUDGET IS…
<<<<<<<<<<   fill in section   >>>>>>>>>> |  |  |  |  | <<<  calculations  >>> |  |  | 2010 |  |  | 2011
YYYY ~ MM ~ DD | Mileage | Trip | Gallons | $$ | $ / G | M / G | $ / M | miles driven | gallons used | gas $ spent | miles driven | gallons used | gas $ spent |  |  |  |  | Data
2010-08-24 00:00:00 | 137869 | 1303.3 | 44.924 | 127.86 | 2.846140147805182 | 29.01121894755587 | 0.098104810864728 | 4073.900000000001 | 156.746 | 482.6200000000001 | 1771.6 | 78.372 | 248.65 |  | Years | Months | YYYY ~ MM ~ DD | Sum of Trip | Sum of Gallons | Sum of $$ | Sum of M/G | Sum of $ / M
2010-11-20 00:00:00 | 140735 | 367.9 | 15.084 | 46.13 | 3.058207372049854 | 24.39008220631132 | 0.125387333514542 | AVG   M/G |  | AVG   $/M | AVG   M/G |  | AVG   $/M |  | 2010 | Aug | 24-Aug | 1303.3 | 44.924 | 127.86 | 29.01121894755587 | 0.098104810864728
2010-11-26 00:00:00 | 141047 | 312 | 12.49 | 39.46 | 3.159327461969576 | 24.97998398718975 | 0.126474358974359 | 25.9904558968012 |  | 0.1184663344706547 | 22.60501199407951 |  | 0.1403533529013322 |  |  | Aug Total |  | 1303.3 | 44.924 | 127.86 | 29.01121894755587 | 0.098104810864728
2010-12-05 00:00:00 | 141415 | 368.3 | 16.458 | 51.59 | 3.134645764977519 | 22.378174747843 | 0.1400760249796362 |  |  |  |  |  |  |  |  | Nov | 20-Nov | 367.9 | 15.084 | 46.13 | 24.39008220631132 | 0.125387333514542
2010-12-24 00:00:00 | 142092 | 673.5 | 23.46 | 75 | 3.19693094629156 | 28.70843989769821 | 0.111358574610245 | monthly   average |  |  | monthly   average |  |  |  |  |  | 26-Nov | 312 | 12.49 | 39.46 | 24.97998398718975 | 0.126474358974359
2010-12-28 00:00:00 | 142467 | 1048.9 | 44.33 | 142.58 | 3.216332055041733 | 23.66117753214528 | 0.1359328820669272 | miles driven | gallons used | gas $ spent | miles driven | gallons used | gas $ spent |  |  | Nov Total |  | 679.9 | 27.574 | 85.59 | 24.65728584898818 | 0.125886159729372
2011-01-01 00:00:00 | 142700 | 233 | 9.88 | 32.2 | 3.259109311740891 | 23.582995951417 | 0.1381974248927039 |  |  |  |  |  |  |  |  | Dec | 05-Dec | 368.3 | 16.458 | 51.59 | 22.378174747843 | 0.1400760249796362
2011-01-01 00:00:00 | 142948 | 247.4 | 10.163 | 32.51 | 3.259109311740891 | 23.582995951417 | 0.1381974248927039 |  |  |  |  |  |  |  |  |  | 24-Dec | 673.5 | 23.46 | 75 | 28.70843989769821 | 0.111358574610245
2011-01-02 00:00:00 | 143129 | 181.2 | 7.245 | 21 | 3.198858604742694 | 24.34320574633474 | 0.1314066289409863 | weekly   average |  |  | weekly   average |  |  |  |  |  | 28-Dec | 1048.9 | 44.33 | 142.58 | 23.66117753214528 | 0.1359328820669272
2011-01-09 00:00:00 | 143511 | 382.6 | 17.16 | 56.16 | 2.898550724637681 | 25.0103519668737 | 0.1158940397350993 | miles driven | gallons used | gas $ spent | miles driven | gallons used | gas $ spent |  |  | Dec Total |  | 2090.7 | 84.24799999999999 | 269.17 | 24.81601937137974 | 0.1287463528961592
2011-01-13 00:00:00 | 143750 | 238.8 | 10.702 | 29.96 | 3.272727272727272 | 22.2960372960373 | 0.1467851542080502 | -- | -- | -- | -- | -- | -- |  | 2010 Total |  |  | 4073.9 | 156.746 | 482.62 | 25.9904558968012 | 0.1184663344706547
2011-01-20 00:00:00 | 143996 | 245.3 | 11.924 | 39.1 | 2.799476733320875 | 22.31358624556158 | 0.1254606365159129 |  |  |  |  |  |  |  | 2011 | Jan | 01-Jan | 480.4 | 20.043 | 64.71000000000001 | 23.96846779424238 | 0.1347002497918401
2011-02-04 00:00:00 | 144258 | 243.3 | 11.298 | 37.72 | 3.27910097282791 | 20.5719557195572 | 0.1593966571545047 |  |  |  |  |  |  |  |  |  | 02-Jan | 181.2 | 7.245 | 21 | 25.0103519668737 | 0.1158940397350993
 |  |  |  |  | 3.338644007788989 | 21.53478491768455 | 0.1550349362926428 |  |  |  |  |  |  |  |  |  | 09-Jan | 382.6 | 17.16 | 56.16 | 22.2960372960373 | 0.1467851542080502
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13-Jan | 238.8 | 10.702 | 29.96 | 22.31358624556158 | 0.1254606365159129
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20-Jan | 245.3 | 11.924 | 39.1 | 20.5719557195572 | 0.1593966571545047
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan Total |  | 1528.3 | 67.074 | 210.93 | 22.78528192742344 | 0.1380160963161683
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 04-Feb | 243.3 | 11.298 | 37.72 | 21.53478491768455 | 0.1550349362926428
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb Total |  | 243.3 | 11.298 | 37.72 | 21.53478491768455 | 0.1550349362926428
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 Total |  |  | 1771.6 | 78.372 | 248.65 | 22.60501199407951 | 0.1403533529013322
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  |  | 5845.500000000001 | 235.118 | 731.2700000000001 | 24.86198419517008 | 0.1250996493028826