Made an excel file for calculating top speed

[kwong2001]

Since i'm planning on entering R/C Car Action's Speed Challenge this summer, I made a template file on excel for calculating gear ratios. Currently i've made one for an HPI RS4 1/2, Nitro TC3, and a Nitro 4-tec.

It only takes me about 10 minutes to fill out the whole chart for a car. I could make one for a monster truck, but it'd take awhile to calculate the drivetrain ratios, and the format would be a bit different.

I'd like to use this thread for requests for different cars. I've attached the files already made so you can check it out.

Feel free to ask any questions on how to use it. A lot of the stuff is designed for calculating custom gears, so it won't apply to most people.

edit: Below is a list of the one's i've done for ppl on this thread
RS4 3 http://rcnitrotalk.com/forum/attachment.php?attachmentid=2226
MTX-3 http://rcnitrotalk.com/forum/attachment.php?attachmentid=2227
Savage http://rcnitrotalk.com/forum/attachment.php?attachmentid=2230
T-Maxx http://rcnitrotalk.com/forum/attachment.php?attachmentid=2231

 

[Team 17]

Can u make one for the Mugen MTX-3?

 

[kwong2001]

Can do. I'm trying to find the drivetrain ratios for the car. Is the smaller pulley 16T? Also, I can't find the size of the diff pulley? It's part number "T0220"

 

[NCNitro]

What about the rs4 3 with the three different two speed set ups.

 

[Team 17]

The 1st pully is 16T and the second is 20T. The 1st gear is 47T & 2nd is 43T.

 

[kwong2001]

NCNitro, here you go. I did all the gear ratios I could find for the RS4 3. I wasn't sure what the gear options are for the 2-speed though. I could tweak it a little if you told me the exact gear sizes.

 

[DarthRacer]

Dude, if you knew visual basic you could write a little EXE, make an info file for the ratios and sell the sucker on ebay.

 

[kwong2001]

Dude, if you knew visual basic you could write a little EXE, make an info file for the ratios and sell the sucker on ebay.

lol, if only i knew how to program stuff. Ghetto fabulous excel works great, it just takes a little longer to calculate the stuff out.

=========================================================

Team 17, here ya go.

 

[Digital Liquid]

Ok, I know there will be some requests for an MT, so I will go ahead and ask for one for the savage. Here is some info that might help you out:

---The transmission ratio is (1.0)
---Gear chart if you need to look at one
http://www.hpiracing.com/graphics/instr/savagegears.jpg
---Stock Tire Diameter (150mm or 5.9")
---Stock S-25 engine specs: 2.5hp @ 29,000 RPM - Max RPM: 38,000

Hopefully that will be enough info for you.

 

[Team 17]

Thanx. Will come in handy .

 

[sl0eg1n]

i have been using a spreadsheet for years. it makes life easier when figuring out what gear ratio to use and calculate my rollout after a set of foams wears down after each heat during race days.

 

[kwong2001]

Ok, I know there will be some requests for an MT, so I will go ahead and ask for one for the savage. Here is some info that might help you out:

---The transmission ratio is (1.0)
---Gear chart if you need to look at one
http://www.hpiracing.com/graphics/instr/savagegears.jpg
---Stock Tire Diameter (150mm or 5.9")
---Stock S-25 engine specs: 2.5hp @ 29,000 RPM - Max RPM: 38,000

Hopefully that will be enough info for you.

Okay, here's the file. I think I learned a lot after calculating it all out. But man, it was a bare. lol

 

[DarthRacer]

Okay, here's the file. I think I learned a lot after calculating it all out. But man, it was a bare. lol

"save As"

Thanks man. I'll take a look and try it out.

 

[Lessen]

sweet Kwong! What about a T-Maxx with a 52T spur and 18T CB? (stock diffs)

 

[kwong2001]

sweet Kwong! What about a T-Maxx with a 52T spur and 18T CB? (stock diffs)

Here ya go

 

[NCNitro]

Thanks Kwong, I will see if I can find the other gear info.

 

[wannarunem]

for some reason...i can't get the savage one to open...i right clicked..and it wont open..I've tried IE and Firefox....strange

 

[kwong2001]

for some reason...i can't get the savage one to open...i right clicked..and it wont open..I've tried IE and Firefox....strange

You'll need to download winzip. Just goto www.winzip.com. It's a free program. If you still have trouble hit me up on aim (kwong3000) or msn ([email protected]) and i'll send you the excel file instead of the compressed version.

 

[wannarunem]

You'll need to download winzip. Just goto www.winzip.com. It's a free program. If you still have trouble hit me up on aim (kwong3000) or msn ([email protected]) and i'll send you the excel file instead of the compressed version.

thanks kwong...going to winzip now


That worked...winzip did the trick!!!

 

[kwong2001]

Just for shits and giggles, I modified my template to suit my 1:1. It's only meant for calculating the changes to MPH through tires and RPM capabilities.