Tech / Misc Tech topics that don't seem to go elsewhere.
Sponsored by:
Sponsored by:

Using excel to calculate tq from hp and mph?

Thread Tools
 
Search this Thread
 
Old Feb 24, 2003 | 11:33 AM
  #1  
Junglist's Avatar
Thread Starter
 
Joined: Feb 2002
Posts: 1,039
Likes: 0
From: The planet farthest from
Default Using excel to calculate tq from hp and mph?

I have a graph like this:


I've heard that you can make a table in excel and use a formula to calc the tq into a graph. Anyone know how to do this???

thanks,
b
Reply
Old Feb 24, 2003 | 01:58 PM
  #2  
JimBlake's Avatar
Honda-Tech Member
 
Joined: Jan 2003
Posts: 8,132
Likes: 5
Default Re: Using excel to calculate tq from hp and mph? (Junglist)

Torque = ( HP / RPM ) * 5252

That gives torque in lbf-ft. Trouble is, you (probably) don't know the engine RPM at any given road speed. You could look for specifications (rpm/mph) for the M3, & guess which gear the M3 was in during that test... unless the M3 had an automatic tranny.
Reply
Old Feb 24, 2003 | 02:04 PM
  #3  
keebler65's Avatar
Honda-Tech Member
 
Joined: Mar 2002
Posts: 2,314
Likes: 1
From: Midwest, USA
Default Re: Using excel to calculate tq from hp and mph? (JimBlake)

if you own the car, you could drive it in the gear used, hold it at a constant speed, and look at the tachometer. then use the mph and rpms to find a multiplier.
Reply
Old Feb 24, 2003 | 02:12 PM
  #4  
e36s52's Avatar
Junior Member
 
Joined: Sep 2002
Posts: 194
Likes: 0
From: Southern Chester Co, PA, USA
Default Re: Using excel to calculate tq from hp and mph? (JimBlake)

that's prolly a third gear pull. diff is 3.23:1 for '96-99 and '95 LTW ('95 was 3.15:1 otherwise), third gear is 1.66:1. rear tires are 245-40-17 for '96-99 and 235-40-17 for all '95.

using this info and the torque to hp conversion provided above, you can create a torque vs. rpm plot.
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Dudeliness
Tech / Misc
3
Mar 15, 2008 05:58 PM
gsr-HF
Honda Prelude
11
Dec 26, 2003 10:48 PM
cr-x si
Honda CRX / EF Civic (1988 - 1991)
5
Nov 20, 2002 07:17 PM
Superhatch
Honda CRX / EF Civic (1988 - 1991)
9
Jul 10, 2002 04:29 AM
ActiveAero
Tech / Misc
4
Jan 18, 2002 04:03 AM




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