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.)
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.)
Last edited by TheMidasTouch; Nov 19, 2008 at 01:53 PM.
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)
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.
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.
Thread
Thread Starter
Forum
Replies
Last Post




