Go Back   EcoModder Forum > EcoModding > EcoModding Central
Register Now
 Register Now
 

Reply  Post New Thread
 
Submit Tools LinkBack Thread Tools
Old 09-18-2008, 08:23 PM   #1 (permalink)
Deadly Efficient
 
Tango Charlie's Avatar
 
Join Date: Jun 2008
Location: Goshen, Indiana
Posts: 1,234

Olivia - '03 Pontiac Vibe base
90 day: 36.01 mpg (US)

R2-D2 - '00 Honda Insight
90 day: 58.81 mpg (US)
Thanks: 132
Thanked 175 Times in 91 Posts
Payoff Calculator

I'm not good at math.

I've never made a spreadsheet.

If I understand spreadsheets correctly, they can calculate stuff. I was thinking a spreadsheet would be handy to calculate how long a mod would take to break even. You'd type in your current mpg, the cost of the mod, the cost of gas, the expected mpg improvement,...am I forgetting anything? And then, blammo, it'd spit out the answer as 'payoff in X miles' and it'd help you decide if the mod is worth it. Anybody here good with spreadsheets?

I've never made a spreadsheet.

I'm not good at math.


__________________
-Terry
  Reply With Quote
Alt Today
Popular topics

Other popular topics in this forum...

   
Old 09-18-2008, 09:04 PM   #2 (permalink)
Administrator
 
Daox's Avatar
 
Join Date: Dec 2007
Location: Germantown, WI
Posts: 11,179

CM400E - '81 Honda CM400E
90 day: 51.49 mpg (US)

Daox's Grey Prius - '04 Toyota Prius
Team Toyota
90 day: 49.53 mpg (US)

Daox's Insight - '00 Honda Insight
90 day: 64.33 mpg (US)

Swarthy - '14 Mitsubishi Mirage DE
Mitsubishi
90 day: 56.69 mpg (US)
Thanks: 2,477
Thanked 2,546 Times in 1,536 Posts
Here is something I came up with a while back. Input your info into the yellow fields to get the info. It tells you money saved via mpg increase. You could simply subtract the cost of the mod from the savings to get an estimated answer.

You can use or ignore the second set of info. I simply duplicated it because I have two main vehicles.

gas_calc.xls
__________________
Current project: A better alternator delete
  Reply With Quote
Old 09-18-2008, 11:25 PM   #3 (permalink)
Deadly Efficient
 
Tango Charlie's Avatar
 
Join Date: Jun 2008
Location: Goshen, Indiana
Posts: 1,234

Olivia - '03 Pontiac Vibe base
90 day: 36.01 mpg (US)

R2-D2 - '00 Honda Insight
90 day: 58.81 mpg (US)
Thanks: 132
Thanked 175 Times in 91 Posts
Thanks, Daox. That's along the lines of what I was thinking. I'll see if I can figure out how to tweak it to give a break even point. The old dog/new tricks thing, you know.
__________________
-Terry
  Reply With Quote
Old 09-19-2008, 06:24 AM   #4 (permalink)
Administrator
 
Daox's Avatar
 
Join Date: Dec 2007
Location: Germantown, WI
Posts: 11,179

CM400E - '81 Honda CM400E
90 day: 51.49 mpg (US)

Daox's Grey Prius - '04 Toyota Prius
Team Toyota
90 day: 49.53 mpg (US)

Daox's Insight - '00 Honda Insight
90 day: 64.33 mpg (US)

Swarthy - '14 Mitsubishi Mirage DE
Mitsubishi
90 day: 56.69 mpg (US)
Thanks: 2,477
Thanked 2,546 Times in 1,536 Posts
I tried to make a break even spreadsheet the other day for some stuff I'll be testing on EcoRenovator. I found it quite challenging to find a way to actually get it to just spit out a number for me. I ended up using two data sets and graphed the info on a chart. This seemed to be the easiest way to do it. It also gives you a good idea of your savings after the break even point which is nice.
__________________
Current project: A better alternator delete
  Reply With Quote
Old 09-19-2008, 12:55 PM   #5 (permalink)
METROANNOSAURUS REX
 
FunkSkunk's Avatar
 
Join Date: Aug 2008
Location: Marble, NC
Posts: 121

The Mach .05 - '98 Chevy Metro LSi
90 day: 48.88 mpg (US)
Thanks: 0
Thanked 1 Time in 1 Post
I made one myself, and I know there's a way to make two separate graphs interact... (I just to a course on this stuff!!!) But I can't remember. Guess it's time to get out the textbook. Wow, something I learned in class is actually applicable to real life!! woo hoo!!
__________________

  Reply With Quote
Old 09-19-2008, 01:02 PM   #6 (permalink)
METROANNOSAURUS REX
 
FunkSkunk's Avatar
 
Join Date: Aug 2008
Location: Marble, NC
Posts: 121

The Mach .05 - '98 Chevy Metro LSi
90 day: 48.88 mpg (US)
Thanks: 0
Thanked 1 Time in 1 Post
Here's my original spreadsheet, change the numbers as you wish, it's comparing my two main vehicles. The second chart is to see when my metro would pay for itself in gas savings (depending on how much I would pay for it, I made this before I bought my car)

Attached Files
File Type: xls Metro_vs_Ranger.xls (35.5 KB, 36 views)
__________________

  Reply With Quote
Reply  Post New Thread


Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paul & Sabrina's Cheap EV Conversion MPaulHolmes Fossil Fuel Free 542 11-12-2016 09:09 PM
Pulse and Glide Fuel Economy Calculator 4 valve / Cylinder newtonsfirstlaw DIY / How-to 25 11-04-2008 03:32 PM
Calculator: Determine Horsepower @ specific speed Daox Aerodynamics 3 08-22-2008 01:00 PM
mpg vs. speed - Metro graph MetroMPG Hypermiling / EcoDriver's Ed 26 06-05-2008 03:45 PM



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