|  | ||||||
Spreadsheet to Keep Track of MPG
 |
| | Tweet | LinkBack | Thread Tools |
02-03-2012, 05:47 AM
| #1 |
| Senior Member  Join Date: Jun 2011 Location: Monroe, GA
Posts: 267
My Car: 2011 Prius Model: Three Package: Navigation Thanks: 32
Thanked 172 Times in 124 Posts
Friends: 0 |  Spreadsheet to Keep Track of MPG Let me first say that I have a spreadsheet for EVERYTHING. I live by the axiom, "If you can measure it, you can manage it.". This spreadsheet evolved as I was measuring the mpg of my 2000 Honda Insight then the 2008 Toyota Prius and now my 2011 Toyota Prius. It was created on a Mac using Excel 2011 and this forum only allows xls extensions and not xlsx extensions so I had to remove the three charts that appear at the top. They are just spark lines if anyone wants to add them back or you could PM me your email and I'll send you the xlsx file. Last edited by Southern Dad; 02-03-2012 at 06:03 AM. Reason: Correct Format of Cells in Spreadsheet |
|      |
|
02-03-2012, 08:18 AM
| #2 |
| Senior Member  Join Date: Aug 2009 Location: OKC
Posts: 1,033
My Car: 2010 Prius Model: II Package: #2 Thanks: 102
Thanked 134 Times in 117 Posts
Friends: 12 | Re: Spreadsheet to Keep Track of MPG Very nice job on your spreadsheet! I like your "If you can measure it, you can manage it" axiom although sometimes on somethings I can't manage to measure it.  |
|
| |
|
02-03-2012, 08:51 AM
| #3 |
| EditProfOptInfoCustomUser Title Join Date: Jul 2009 Location: Maine
Posts: 1,676
My Car: 2010 Prius Model: II Package: No Package Thanks: 52
Thanked 240 Times in 204 Posts
Friends: 1 | Re: Spreadsheet to Keep Track of MPG I have lots of spreadsheets too. The only problem is that spreadsheets don't scale, so my intention is to convert them all into web-fronted databases using a LAPP set-up. But that's not my sphere, so I need to motivate myself to get started. |
|
| |
|
02-03-2012, 10:11 AM
| #4 |
| Senior Member Join Date: Jun 2011 Location: Monroe, GA
Posts: 267
My Car: 2011 Prius Model: Three Package: Navigation Thanks: 32
Thanked 172 Times in 124 Posts
Friends: 0 | Re: Spreadsheet to Keep Track of MPG Actually, I put all the spreadsheets together and have a large multipage one that is just termed Bell Budget with pages for everything. I can usually calculate my utility bills within a dollar or two as well as keep up with everything else. I just like keeping up with the Prius MPG in a way that is pretty easy. |
|
| |
|
02-03-2012, 11:30 AM
| #5 |
| wretched  Join Date: Jul 2009 Location: Alaska
Posts: 5,598
My Car: 2010 Prius Model: II Package: Base Thanks: 951
Thanked 799 Times in 642 Posts
Friends: 24 | Re: Spreadsheet to Keep Track of MPG I use fuelly.com. Don't have to worry about losing my sheets when the drive crashes. Last edited by spiderman; 02-03-2012 at 11:33 AM. |
| |
|
02-03-2012, 12:39 PM
| #6 |
| Senior Member Join Date: Jun 2011 Location: Monroe, GA
Posts: 267
My Car: 2011 Prius Model: Three Package: Navigation Thanks: 32
Thanked 172 Times in 124 Posts
Friends: 0 | Re: Spreadsheet to Keep Track of MPG I use Fuelly as well. I wanted to be able to break it down by month and check the accuracy of the mpg the vehicle shows. Plus a few other things. |
|
| |
|
02-03-2012, 08:03 PM
| #7 |
| Senior Member  Join Date: Jul 2009 Location: Long Island, NY
Posts: 408
My Car: 2010 Prius Model: IV Package: No Package Thanks: 65
Thanked 117 Times in 76 Posts
Friends: 1 | Re: Spreadsheet to Keep Track of MPG Nice job, but your monthly averages won't be 100% accurate unless you fill it up on the last day of each month and leave the car at the gas station overnight. |
|
| |
|
02-04-2012, 10:09 PM
| #8 |
| Senior Member Join Date: Jun 2011 Location: Monroe, GA
Posts: 267
My Car: 2011 Prius Model: Three Package: Navigation Thanks: 32
Thanked 172 Times in 124 Posts
Friends: 0 | Re: Spreadsheet to Keep Track of MPG Hmm, good thought. It is exactly 2.5 miles from the station to my home. If I travel at a slow enough speed, I am able to make it home without ever engaging the ICE. My daughter and I sometimes try and get 99.9 mpg doing this on the way home from the station. |
|
| |
|
| Tags |
| mpg, spreadsheet, track |
LinkBacks (?)
LinkBack to this Thread: http://priuschat.com/forums/gen-iii-2010-prius-fuel-economy/102988-spreadsheet-keep-track-mpg.html | ||||
| Posted By | For | Type | Date | |
| Spreadsheet to Keep Track of MPG - PriusChat Forums | This thread | Refback | 02-04-2012 03:52 AM | |
| Spreadsheet to Keep Track of MPG - PriusChat Forums | This thread | Refback | 02-03-2012 07:55 AM | |
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Spreadsheet? | rstark18 | Gen III 2010+ Prius Care, Maintenance and Troubleshooting | 0 | 02-03-2010 08:36 PM |
| MPG - mfd vs spreadsheet | sleonardelli | Gen II Prius Technical Discussion | 18 | 06-30-2008 07:34 PM |
| My poor spreadsheet | kdmorse | Gen II Prius Fuel Economy | 0 | 07-24-2006 05:00 AM |
| Fuel Use Spreadsheet? | bandgeek | Gen II Prius Fuel Economy | 3 | 07-05-2005 12:39 AM |
| Anyone ever see this Prius spreadsheet before? | Eug | Gen II Prius Main Forum | 1 | 03-18-2004 07:45 PM |
| Bookmarks |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| |
