Go Back   EcoModder Forum > EcoModding > General Efficiency Discussion
Register Now
 Register Now
 

Reply  Post New Thread
 
Submit Tools LinkBack Thread Tools
Old 06-26-2009, 01:44 PM   #1 (permalink)
Speedboy turned MPGman
 
kstruve's Avatar
 
Join Date: Jun 2009
Location: Arizona
Posts: 24

Platinum Bullet - '04 Subaru Impreza WRX
90 day: 27.53 mpg (US)
Thanks: 0
Thanked 4 Times in 4 Posts
Spreadsheet for tracking all kinds of mileage stuff!

Hello everyone,

I've been working on this spreadsheet for a week or two and I keep on noodling it and refining it, but I think I'm ready to share it. I had been looking for more and more statistics on my gas mileage and other ways of looking at it, so I starting putting this together. It's based loosely on another spreadsheet I found on the internet by someone named "f1ip", but it's been heavily modified. It shows fuel efficiency not only in MPG, but gals/100 miles. I've also added several other cost breakdowns and fuel usage stats, maximum range per tank, overall averages and running (last 3) averages.

I also wanted a way to track how much money I had been saving since I started hypermiling, so I created this to keep a running total of that, plus how many gallons I've saved and how many pounds of CO2 I've prevented from entering the atmosphere. There are cells in which you can enter your car's EPA combined MPG and your "pre-hypermiling" MPG, if you know what that was, so you can see how much you're saving. I also put in a trip fuel cost estimator based on your last 3 MPGs and most recent fuel cost per gallon.

Let me know what you think of it and if you find any errors or ways of improving it. I'm not that great at Excel, so this was a learning experience for me, and my wife had to help me a lot. By the way, only enter data in the light turquoise cells.

Thanks!

Attached Files
File Type: xls Mileage Calculator.xls (176.0 KB, 1029 views)
__________________


www.kurtstruve.com
  Reply With Quote
Alt Today
Popular topics

Other popular topics in this forum...

   
Old 06-26-2009, 01:52 PM   #2 (permalink)
Master EcoModder
 
Matt Herring's Avatar
 
Join Date: Jun 2008
Location: North Andover, MA
Posts: 857

Bone's 2010 Prius - '10 Toyota Prius Black
90 day: 56.78 mpg (US)
Thanks: 5
Thanked 23 Times in 19 Posts
Fancy! Nice work bro!
  Reply With Quote
Old 06-26-2009, 01:55 PM   #3 (permalink)
Pokémoderator
 
cfg83's Avatar
 
Join Date: Dec 2007
Location: Southern California
Posts: 5,864

1999 Saturn SW2 - '99 Saturn SW2 Wagon
Team Saturn
90 day: 40.49 mpg (US)
Thanks: 439
Thanked 530 Times in 356 Posts
kstruve -

WOW, I'm gonna have to play around with this for awhile.

CarloSW2
__________________

What's your EPA MPG? Go Here and find out!
American Solar Energy Society
  Reply With Quote
Old 06-27-2009, 12:16 AM   #4 (permalink)
Speedboy turned MPGman
 
kstruve's Avatar
 
Join Date: Jun 2009
Location: Arizona
Posts: 24

Platinum Bullet - '04 Subaru Impreza WRX
90 day: 27.53 mpg (US)
Thanks: 0
Thanked 4 Times in 4 Posts
Thanks! I think it works pretty well.
__________________


www.kurtstruve.com
  Reply With Quote
Old 06-27-2009, 12:36 PM   #5 (permalink)
EcoModding Lurker
 
Join Date: Mar 2008
Location: Wisconsin
Posts: 33
Thanks: 0
Thanked 1 Time in 1 Post
Quote:
Originally Posted by kstruve View Post
Hello everyone,

By the way, only enter data in the light turquoise cells.
I made my own Excel sheet too. Here is a trick to keep from accidentally destroying a cell with a formula in it.

Right click on the cells that you need to enter data.
Click Format Cells
Click on the Protection tab
Uncheck Locked and click OK
Click on Tools in the menu bar
click protection and select Protect Sheet...
Uncheck Select locked cells - if you don't want them to be selected
Enter a simple password
__________________
  Reply With Quote
Old 06-28-2009, 02:34 PM   #6 (permalink)
Speedboy turned MPGman
 
kstruve's Avatar
 
Join Date: Jun 2009
Location: Arizona
Posts: 24

Platinum Bullet - '04 Subaru Impreza WRX
90 day: 27.53 mpg (US)
Thanks: 0
Thanked 4 Times in 4 Posts
Quote:
Originally Posted by Jetta90GL View Post
I made my own Excel sheet too. Here is a trick to keep from accidentally destroying a cell with a formula in it.

Right click on the cells that you need to enter data.
Click Format Cells
Click on the Protection tab
Uncheck Locked and click OK
Click on Tools in the menu bar
click protection and select Protect Sheet...
Uncheck Select locked cells - if you don't want them to be selected
Enter a simple password
Good Excel tips. Thanks!

P.S. Here's "v.1.2" of the spreadsheet. I added savings per day/week/month.

Attached Files
File Type: xls Mileage Calculator v.1.2.xls (178.0 KB, 306 views)
__________________


www.kurtstruve.com

Last edited by kstruve; 06-28-2009 at 02:42 PM.. Reason: Added File
  Reply With Quote
The Following User Says Thank You to kstruve For This Useful Post:
cornell (06-01-2011)
Reply  Post New Thread


Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
My New 4cyl Compact Doesn't Get Good Mileage Stone Axe Introductions 13 02-08-2013 12:06 PM
EcoModding for Beginners: Getting great gas mileage. SVOboy EcoModding Central 55 08-20-2012 11:34 PM
In a world where Jeeps get horrible gas mileage.... EcoJeeper Introductions 16 03-26-2009 12:09 PM
mileage is mileage, right? (question about accuracy of small fill) Chris D. General Efficiency Discussion 16 10-21-2008 07:59 PM



Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Content Relevant URLs by vBSEO 3.5.2
All content copyright EcoModder.com