Horsepower calculation spreadsheet showing 25% higher than expected

  • Context: Undergrad 
  • Thread starter Thread starter soundengineer
  • Start date Start date
  • Tags Tags
    Check my work Work
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
1 reply · 2K views
soundengineer
Messages
33
Reaction score
0
I need somebody to double check my work...I think my math is wrong somewhere..

so I've been working on a spreadsheet to take some data from a vehicle's data port...
and to transfer it into a Horsepower chart...
basically making a street Dyno...

I've gotten everything to work together...including graphing
but I know that my math has to be wrong somewhere and I need some help to get it right...

I think I've done all the conversions correctly...
I know I've done all the lookup from my data page correctly...

The Data I used is from a vehcile on the dyno...this vehicle made 447HorsePower and 396 Torque
but my excel math seems to say it s a lot higher...a lot higher..my end result is 25% or so higher than what it should be...
I've even added in dyno correction factor that every dynomometer uses to get an SAE corrected valueMy link to my excel spreadsheet...in a zip file...
too big for me to post it...
http://www.audiohelix.com/physics/
 
Last edited:
Physics news on Phys.org


In a consistent system of units we have:

Power = Torque * (rotational speed)

You stated that your are measuring power in units of horsepower (instead of, for example, watts).

When you say 396 Torque, you are ommiting the units. The most likely possibility in America is foot-lbs, whereas with the metric system torque is measured in Newton-meters.

The metric unit for angular speed is radians per second (not revolutions per second, as engines are often quoted). To convert revolutions per second to radians per second multiply by 2*pi = 6.28.