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

Now available from EcoModder: ScanGauge II fuel economy gauge.  Click for details.  

Reply  Post New Thread
 
Submit Tools LinkBack Thread Tools
Old 01-02-2013, 01:35 PM   #1 (permalink)
EcoModding Apprentice
 
HypermilerAX's Avatar
 
Join Date: Apr 2011
Location: Southern France
Posts: 151

Peugeot 205 - '91 Peugeot 205 turbo D
90 day: 65.63 mpg (US)

CitroŽn AX - '95 CitroŽn AX 1.5D
90 day: 80.81 mpg (US)
Thanks: 11
Thanked 57 Times in 34 Posts
"Do-it-all" excel calculator

Hello,

I decided to share this excel sheet I have progressively made for myself.
I had post this in the online tool calculator thread but since it has other features, I thought it deserves its own thread.
It's an excel sheet to calculate lots of things, including the features of the online tool. At the beginning, I made the sheet to calculate my wattage on the bike and used it for the car when I began driving.
It's all metric for now, maybe I'll do a US-version if there are many requests. Only the fields squared in red should be changed according to your car.
To calculate the required power, it asks for mass, Crr, CdA, speed, air density but also slope. Air density can be either entered directly or calculated with temperature, pressure and humidity.
It, then, displays :
- each force and power (rolling, aero, gravity) with their respective part
- power needed (watt and hp)
- torque according to your gearing ratio (to be entered)
- RPM
- BMEP in bar for BSFC (according to torque and engine displacement to be entered)
- fuel consumption in both l/100 km or mpg (US) according to either efficiency in % or BSFC in g/kWh

The next tab is an acceleration calculator that can be used for P&G for example. You have to enter the power of your engine at each RPM. It would be ideal to have the power curve of your engine. By default, it's an engine giving 58 hp at 5000 rpm (power output is roughly supposed linear with RPM).
For each speed by 1 km/h increments, it displays :
- RPM (can be used with any of your gears if your enter the ratio)
- power to maintain speed
- spare power available to accelerate
- acceleration
- time to accelerate by 1 km/h
- 'instant' consumption (to be precise, you should have the exact power curve and BSFC map of your engine, values entered by default are random). It is constant because I chose a constant BSFC with RPM (at full load) which is not true and a linear power curve which might not be true as well.

You can then manually calculate the consumption during the pulse/glide phase and compare with constant speed or different speeds for P&G. You can calculate theoretical coastdown time during the glide phase with the next tab.
It works not bad. I tested a 0 to 100 km/h for my car. The calculator gives me 13,45 sec + 2 seconds for 2 gear changes, that's 15,45 sec. The official time is 15,7.
P&G between 85 and 95 km/h gives me 2,95 l/100 km vs 3,6 at 90 constant speed. But thatís ideal, I have observed that real life coastdowns are always worse than the theory.

Next tab is a Cd, Cr calculator with car and coastdown info.

Any feedback, critics, questions or new ideas are welcome. Have fun !


EDIT : little error. In second tab, column H : unit is L/100 km and not L/h.

Attached Files
File Type: xls calculator.xls (116.5 KB, 170 views)
__________________
CitroŽn AX 1.5 D 310.000 km
AX Eco Project : 100 mpg target !

Last edited by HypermilerAX; 01-09-2013 at 12:40 AM..
  Reply With Quote
The Following 3 Users Say Thank You to HypermilerAX For This Useful Post:
AndrzejM (01-02-2013), DieselX (01-02-2013), ECONORAM (01-02-2013)
Old 01-09-2013, 12:42 AM   #2 (permalink)
EcoModding Apprentice
 
HypermilerAX's Avatar
 
Join Date: Apr 2011
Location: Southern France
Posts: 151

Peugeot 205 - '91 Peugeot 205 turbo D
90 day: 65.63 mpg (US)

CitroŽn AX - '95 CitroŽn AX 1.5D
90 day: 80.81 mpg (US)
Thanks: 11
Thanked 57 Times in 34 Posts
Update : I just realized I could host the file directly on ecomodder. I guess people will be less reluctant to download it.
__________________
CitroŽn AX 1.5 D 310.000 km
AX Eco Project : 100 mpg target !
  Reply With Quote
Old 01-09-2013, 04:26 PM   #3 (permalink)
...beats walking...
 
Old Tele man's Avatar
 
Join Date: Jul 2009
Location: Tucson, AZ
Posts: 5,120

'04 Vibe - '04 Pontiac Vibe Base (1ZZ-FE)
90 day: 29.19 mpg (US)

'14 Prius - '14 Toyota Prius Four (2XR-FXE)
90 day: 46.43 mpg (US)
Thanks: 97
Thanked 838 Times in 628 Posts
IDEA -- instead of completely making a "new" IP-units version, why not simply make a simple "add-on" applet that accepts IP-unit inputs and outputs SI-units that are needed by the original program? Just advise the users to "input" their IP-values to the translator applet and then to "input" those 'new' translated SI-values into the original program...and LEAVE the final results in SI-format.

__________________
ē 2014 Toyota Prius 1.8L eCVT < new >
ē 2009 Pontiac Vibe 1.8L/SFI 4A
ē 2004 Pontiac Vibe 1.8L/MFI 4A

ē 2011 Chevrolet LTZ Cruze 1.4LT 6A < old >
ē 1971 Dodge Charger 318 3A
ē 1970Ĺ Plymouth AAR 'Cuda 340/6BBL 4M
ē 1968 Dodge Charger 383 3A
ē 1967 Plymouth Barracuda Formula S 383 4M
ē 1965 Plymouth Barracuda Formula S 273 4M
  Reply With Quote
Reply  Post New Thread

Thread Tools





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