Spreadsheet for Fuel Economy calculations - Fuelly Forums

Click here to see important news regarding the aCar App

Thread Tools Display Modes
Old 12-08-2006, 06:32 AM   #1
Team GasMisers5!
landspeed's Avatar
Join Date: Nov 2006
Posts: 440
Country: United States
Spreadsheet for Fuel Economy calculations

Based on a spreadsheet I found on this site:


(thread link), and some formulas from the site, and info I have found on the
web, I have created a spreadsheet that can show the effect of rolling resistance and aerodynamic drag on MPG (thereby showing you the best MPG
you could ever get withour LRR tyres or Aero mods), and also the MPG while
in gear, and in particular, the effect of the alternator.

There is a lot of room for expansion. In particular, does anyone know of any
formulas for how much power a power steering pump / water pump might
use?. The spreadsheet includes the ability for these items to take a constant
power (e.g. if you put an electric motor, driven via the alternator, so that they
turned at the minimum possible speed). Once the correct formulas are in place,
this would allow you to compare different options of e.g. running them
electronically, or running them via the ICE (as usual). It also lets you add up
the electrical current of the alternator, and see the effect of disconnecting it
on MPG.

Any comments? Any ideas on where to find the appropriate formulas for the

P.S. I will find a better way to include ICE efficiency, but this depends on
so much, including throtttle position, and speed, that I just used the same
value from the old spreadsheet!

P.S. This is a fresh install of windows, and I have a virus scanner, but can
someone scan it to make sure?
Attached Files
File Type: zip zipped spreadsheet.zip (6.5 KB, 89 views)


Team GasMisers5 - #1 for first three rounds of the original GS Fuel Economy Challenge
Miles displaced by e-bike since 1 Jan 2008: 62.6 (0 kWh used)
landspeed is offline   Reply With Quote
Old 07-14-2007, 06:35 AM   #2
Registered Member
skewbe's Avatar
Join Date: Jan 2007
Posts: 771
Country: United States
mCaffee (dat file dated yesterday) says it is ok.
Standard Disclaimer
skewbe is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Missing Fuelup jmonty Fuelly Web Support and Community News 3 05-27-2009 04:10 AM
fuel-up entry suggestion fugalaya Fuelly Web Support and Community News 3 04-12-2009 08:29 AM
Pulse and Glide? Pete7874 General Fuel Topics 24 02-26-2009 11:11 AM
MID Install SVOboy Experiments, Modifications and DIY 33 06-04-2007 10:27 AM
State of the Union address touches on "oil addiction." Matt Timion General Discussion (Off-Topic) 31 02-06-2006 03:38 PM

Powered by vBadvanced CMPS v3.2.3

All times are GMT -8. The time now is 06:58 AM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2018, vBulletin Solutions, Inc.