[archer000001]

Hello,

I got tired of trying to compare engine/transmission/axle/wheel specs to understand what HP and torque I'd get under my driving and towing conditions. So I wrote a simple Excel simulation model to compare vehicles head-on. Give it a try -- the Tundra looks pretty good!

Note: When opening, if Excel asks about macro security, reply "Enable macros". My custom functions are written as a macro.

Enjoy!
Jim
:tu:

 

[GGWOODY]

HOLY F"n CRAP!!! That is a cool little simulater

good on ya!!!!!11

 

[GGWOODY]

TTT...a lot of smarts went into this, and it's sweeet!:tu:

 

[archer000001]

GGWOODY --

Glad to hear you're enjoying it. It helped me understand the 4.30 axle gearing enough to place an order for a 5.7 4x4 reg cab long bed.

Jim

 

[Rustywrenches]

Very impressive! You are a genius! :tu: :tu: :tu: :ts:

 

[MilesToGo]

I think someone has too much time on their hands.

 

[Afterimage]

This is a cool piece of work Archer.

One question, though: If you go over to the Alternatives columns in order to make a custom graph, how do you get the Torque @ **** cells to be calculated from a known Peak Torque cell entry?

In this instance I was trying to put in the data for the GM LY6 engine which makes 373lb-ft torque @ 4400rpm and 353hp @ 5400rpm.

I don't have the data for the individual torque values at 1000rpm, 1500rpm, etc, and the app doesn't auto-calculate them from the Peak Torque cell.

Thanks

 

[archer000001]

For the torque data at specified RPM steps, you can interpolate torque values using a pencil and ruler on printed torque curves:

GM: (pick your engine, select SAE or PL icons for the torque curve)
GM Media Online: English

Dodge: Sales brochure shows torque curve

Toyota: Sales brochure shows torque curve

Ford: Claims that "it's confidential data, and we won't release it". Poor decision, Ford. Very poor.

 

[mln]

Jim

Cool spread sheet! Can we unlock the sheet, if so what is the password? I'd like to compare my old truck to this one. It uses a different tire and rear gear than the default.

 

[archer000001]

mln --

You can customize the model as is, to your heart's content. Any gray cell is for your input values. Just input your own engine torque curve, trans gearing, axle gearing, and tire choice. Change out any row in the tire rack with your own tire size, and select that row number in the input table.

Enjoy!
Jim
:tu:

 

[mln]

Jim

Thanks for that info. I was trying to make the changes in the wrong place. Is there any way to make the charts bigger so I can see them easier?

I know my 2001 5.3 didn't put out 315 HP, it was 275 I believe. Any idea where I might get that info and how would I input it?


Thanks

 

[archer000001]

mln --

To see larger graphs, use Excel's menu View..Zoom to adjust.

HP is a direct function of RPM and torque. So if you input the torque curve, the model calculates the HP as needed. If you are trying to calibrate to an older engine, you might try Googling to find any site with an older torque curve. I know it worked for my '98 Dodge -- just can't remember the Dodge-related site.

Jim
:tu:

 

[mln]

Thanks

I see that it's still the same at a larger size (200%). It's the fact that it all works out to about the same line that makes it busy at either size. I found I could look above the graph and see the numbers there and get the needed info.

I'll look for an older HP/TQ chart soon. I'm trying to figure out why my Toyota and Chevy are so different in operation when the initial glance at your simulator show they are very similar in a lot of ways.

Thanks again.

 

[lmychajluk]

Great little tool! Thanks!

One possible minor correction - I think the 4L70 GM Tranny has a 4th gear ratio of .63, not .70.

 

[archer000001]

Thanks for the compliment!

On the OD trans ratio, my data came from:

GM Media Online: English

They claim 0.70 for 4th gear.

Of course, feel free to edit whatever input assumptions you trust.

Thanks!
Jim
:tu: