Spreadsheet for Fuel Economy calculations - Fuelly Forums

Click here to see important news regarding the aCar App

Go Back   Fuelly Forums > Fuel Talk > General Fuel Topics
Today's Posts Search Click Here to Login
Reply
 
Thread Tools Display Modes
 
Old 12-08-2006, 07: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:

http://www.gassavers.org/showthread....highlight=tool

(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
pumps?

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, 152 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)
Hypomiler
landspeed is offline   Reply With Quote
Old 07-14-2007, 07: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
Reply


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 05:10 AM
fuel-up entry suggestion fugalaya Fuelly Web Support and Community News 3 04-12-2009 09:29 AM
Pulse and Glide? Pete7874 General Fuel Topics 24 02-26-2009 12:11 PM
MID Install SVOboy Experiments, Modifications and DIY 33 06-04-2007 11:27 AM
State of the Union address touches on "oil addiction." Matt Timion General Discussion (Off-Topic) 31 02-06-2006 04:38 PM

» Fuelly iOS Apps
» Fuelly Android Apps
Powered by vBadvanced CMPS v3.2.3


All times are GMT -8. The time now is 07:55 PM.


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