Welcome to the Australian Ford Forums forum.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and inserts advertising. By joining our free community you will have access to post topics, communicate privately with other members, respond to polls, upload content and access many other special features without post based advertising banners. Registration is simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Please Note: All new registrations go through a manual approval queue to keep spammers out. This is checked twice each day so there will be a delay before your registration is activated.

Go Back   Australian Ford Forums > General Topics > The Pub

The Pub For General Automotive Related Talk

Reply
 
Thread Tools Display Modes
Old 29-05-2006, 11:43 AM   #1
4.9 EF Futura
Official AFF conservative
 
4.9 EF Futura's Avatar
 
Join Date: Dec 2004
Location: Adelaide, SA
Posts: 3,549
Default Dyno calcs worksheet

Guys,

Just a little something I knocked up for *another* site with contributions by other members there... but I thought anyone here who is bored and has a dyno graph at hand might enjoy having a play around. Nothing terribly interesting but may give people a further insight into the way which their particular combination is making its power/ET/MPH.

Basically take your dyno sheet with km/hr plotted against rwkw/rwhp and plug the data in. Enter a few details about tyre size/drivetrain and away you go.

If you enter it as RWHP - don't enter any RWKW amounts. If you enter RWKW amounts, leave the RWHP fields blank...

Happy to take feedback on board - so long as its not to do with drivetrain losses - the "assumption factor" is addressed adequately within the worksheet IMO...

The "dyno dynamics graph helper" is a neat little calculation that will allow you to determine what each line on a dyno dynamics graph represents. i.e. what for each small line across the X-Axis represents (in km/hr) and what each small line on the Y-axis represents (in rwkw or rwhp depending on your operator)....

Basic instructions are included. Tyre circumference will be calculated automatically from width/profile/size info... a few basic gear ratios (ef/el and BA) are provided. Will add more if people can provide the ratios (i.e. EA auto, EA manual etc).

http://www.myfilestash.com/userfiles...s%20Ver3.1.xls

Any questions just ask.

__________________
A cup half empty... but full of euphoria.
4.9 EF Futura is offline   Reply With Quote Multi-Quote with this Post
Old 29-05-2006, 05:12 PM   #2
mcflux
Banned
Donating Member1
 
mcflux's Avatar
 
Join Date: Dec 2004
Posts: 8,303
Default

ÿ  $ ÿ  $( ÿ  $( ÿ  $( ÿ  $( ÿ  $( ÿ  $( ÿ   $( ÿ  $( ÿ  $( ÿ  $( ÿ  $( ÿ  $( ÿ  $( ÿ  $( ÿ   $( ÿ  $( ÿ  $( ÿ  !$( ÿ  "$( !ÿ  #$( "ÿ  $$( #ÿ  %$( $ÿ  &$ %ÿ  '$ &ÿ  ($ 'ÿ  ) $ (ÿ  *$ )ÿ $ +$ 3þD

(random cell copy/pasted to here)

I think I have an excel compatability issue!

Great idea though.
mcflux is offline   Reply With Quote Multi-Quote with this Post
Reply


Forum Jump


All times are GMT +11. The time now is 01:53 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Other than what is legally copyrighted by the respective owners, this site is copyright www.fordforums.com.au
Positive SSL