Page 1 of 1

My Transmission spreadsheet

Posted: Thu Feb 24, 05 6:23 pm
by Dave-R
Don't know if all have you have seen these spreadsheets that i have used for the last couple of years?

I just added a speedo drive gear calculation to it so you know how many teeth the drive gear should have to correct your speedo reading when you have changed rear tyre or axle gear sizes.

http://challenger.mpoli.fi/web/4SPEEDchart.xls is for 4-speed users.

http://challenger.mpoli.fi/web/AUTOMATICchart.xls is for automatic users.

Posted: Thu Feb 24, 05 6:27 pm
by Dave-R
Oh and just to say it is better to round the teeth number down rather than up unless the fraction is very near the higher number. This is because it is safer for your speedo to read high rather than low.
You don't want to get caught out by a speed camera do you?

Posted: Thu Feb 24, 05 10:11 pm
by MrNorm
Nice one Dave, I have a v similar one I knocked up while thinking about rear gear ratios - but without the in-gear numbers, good job!

I see you have been educating our American friends as well :D. No-one bit on your 'spelling' comment!!
I noticed you'd joined up on Moparts recently and been posting like a madman, now don't go upsetting them will you, you know they are thin-skinned :wink:

Posted: Fri Feb 25, 05 10:48 am
by Guy
Thats fantastic Dave

Posted: Fri Feb 25, 05 1:49 pm
by Dave-R
Thanks Guy(s). :D

Yeah Gav I have been on Moparts before but years ago. Gave it up. But I thought if I made a few posts here and there I might attract a few more users to my board. :wink:

Posted: Fri Feb 25, 05 5:52 pm
by MrNorm
Good strategy Dave, I think you'll succeed!