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

Gearing/Powerband/Thrustcurve calculator for the masses.

Thread Tools
 
Search this Thread
 
Old Nov 17, 2008 | 10:03 PM
  #1  
TheMidasTouch's Avatar
Thread Starter
Honda-Tech Member
iTrader: (2)
 
Joined: Nov 2006
Posts: 299
Likes: 2
From: CO
Icon6 Gearing/Powerband/Thrustcurve calculator for the masses.

Check this out, something I threw together really quick. It's something I've been wanting to do for awhile, but haven't had a good reason too(in other words, I'm lazy...)

It's basically just a graphing and comparison tool based on inputs you give it. You plug your torque numbers, gearing, tire diameter, and weight in on Sheet 1, and on Sheet 2 the graphs automatically render.

The values in there now are a comparison of a shops race car and my Integra.

To better understand thrust curves, check out this T-I thread here.

The general idea behind what I attached is that it will allow me to compare how well gearing, tire size, torque curves, etc... all lines up for a given setup or vs another setup. You can plug in the values you want it to calculate off of, and analyze away if that's your gig. Some more examples of what this would be useful for:

Choosing a transmission(My current gearing vs the tranny i want)
Setting a red line per gear(if the thrust curves intersect, that's your shift point)
Choosing tire size/red line/gearing for drag racing(you normally want to cross the quarter at the very top of 4th)
Dialing in boost by gear/rpm(if Tire A only has traction to thrust amount X...)

and so on. I've been needing one of these for a very long time for myself so if anyone else can make use of it feel free.

It's not very robust(Microsoft coupled with my laziness), so it is easy to break. However, if you find any bugs that hinder the accuracy of it, please feel free to let me know, or make suggestions.

If you'd only like to gauge a single cars graph sets you can just plug "0" into the tire size or final drive calc. It also has an option to gauge difference in weight. It will apply a percentage multiplier to the second car in the comparison.

Edit: I uploaded a slightly revised version. The issue before was the inability to reflect lower red lines then 8000rpm. Now, you plug in the rpm and torque values starting with red line and work your way up. I know this is ghetto, but is the best I can come up with in a crunch. If you don't have enough values to fill the selection, make sure the remaining all match the last(as in the example values provided.)
Attached Files
File Type: zip
ThrustCurveCalcV1-3.zip (28.3 KB, 291 views)

Last edited by TheMidasTouch; Nov 19, 2008 at 01:53 PM.
Reply
Old Nov 18, 2008 | 12:53 PM
  #2  
eluzionzEM1's Avatar
Junior Member
 
Joined: May 2007
Posts: 15
Likes: 0
From: Millbrook, Al, USA
Default

why are you so smart? you are ****ing amazing man.thanks dude this will help out alot after you get me on the dyno. my new distributor will be in tomorrow for free
Reply
Old Nov 18, 2008 | 12:58 PM
  #3  
TheMidasTouch's Avatar
Thread Starter
Honda-Tech Member
iTrader: (2)
 
Joined: Nov 2006
Posts: 299
Likes: 2
From: CO
Default

Originally Posted by eluzionzEM1
why are you so smart? you are ****ing amazing man.thanks dude this will help out alot after you get me on the dyno. my new distributor will be in tomorrow for free
Actually I'm pretty dumb man... if your car doesn't rev to 8000-8500, the red line graphing side wigs out hard... I'll get it fixed later(going back to my laziness.. lol)
Reply
Old Nov 18, 2008 | 06:33 PM
  #4  
ddd4114's Avatar
Honda-Tech Member
 
Joined: Mar 2006
Posts: 2,062
Likes: 1
From: Columbus, OH
Default

Thrust is a force, so you should divide your "thrust" cells by the loaded tire radius (in feet). Then you'll have the reaction force on the road, and you'll be able to see how it changes with tire radius.

Aside from that, it's a great spreadsheet. Good work.
Reply
Old Nov 19, 2008 | 07:08 AM
  #5  
TheMidasTouch's Avatar
Thread Starter
Honda-Tech Member
iTrader: (2)
 
Joined: Nov 2006
Posts: 299
Likes: 2
From: CO
Default

Originally Posted by ddd4114
Thrust is a force, so you should divide your "thrust" cells by the loaded tire radius (in feet). Then you'll have the reaction force on the road, and you'll be able to see how it changes with tire radius.

Aside from that, it's a great spreadsheet. Good work.
That's actually something I regret not adding. It would be very helpful, and it's almost inaccurate without it. I'll see if I can't get something figured out with these god forsaken Excel formulas that is easy to add.
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
HPgonewild
Drag Racing
13
Jul 29, 2011 10:00 AM
kxrider25
Wheel and Tire
7
Feb 28, 2011 11:16 AM
cilvia
Wheel and Tire
4
May 4, 2007 05:01 AM
GSblueRacing
Acura Integra
22
Jun 30, 2005 05:54 AM
type r 01-1063
Acura Integra Type-R
13
Jan 14, 2002 10:14 AM




All times are GMT -8. The time now is 06:10 AM.