My Transmission spreadsheet

Dave-R · Post by **Dave-R** » Thu Feb 24, 05 6:23 pm

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.

Dave-R · Post by **Dave-R** » Thu Feb 24, 05 6:27 pm

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?

MrNorm · Post by **MrNorm** » Thu Feb 24, 05 10:11 pm

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

. 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

Guy · Post by **Guy** » Fri Feb 25, 05 10:48 am

Thats fantastic Dave

Dave-R · Post by **Dave-R** » Fri Feb 25, 05 1:49 pm

Thanks Guy(s).

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.

MrNorm · Post by **MrNorm** » Fri Feb 25, 05 5:52 pm

Good strategy Dave, I think you'll succeed!