Gear Ratio For the Car enthusiasts

[wlee2]

ok Unlike what the title says this Spreadsheet is not for Street racing.

Use it at your own risk and Dont go speeding down the Freeway to prove that the values are correct =P..

Disclaimer: Neither I nor Ozhonda holds any responsibility if you drive off a cliff while atempting to prove or disapprove that the formular does infact work.


The Spread Sheet includes many of our favorite Hondas (save the DA integra which will be soon incorporated) and tells give you the option to see your speed in KMPH at high RPm in a large range of cars and Gearboxes, with variables such as Tire size Gearbox swaps rim size and so and so..

Quick run through of how to use the Spread Sheet

Open the Spreadsheet

At the Bottom there are tabs
http://www.ozhonda.com/forum/attachment.php?attachmentid=9841&d=1215992898

you can use the Tyre Size comparison table
http://www.ozhonda.com/forum/attachment.php?attachmentid=9842&d=1215992898

and before you begin.. at the top of each tab there is a Table you need to enter your specific variables (ie, Tire size, Rpm Shiftpoints)
http://www.ozhonda.com/forum/attachment.php?attachmentid=9843&d=1215992898

but anyway words only speak so much why not take a Gawk at the Spreadsheet itself and tell me what u think.

If you have any cars/gearboxes you wish to add to this SS (short for SpreadSheet) Just Email me at wayewynn@gmail.com

Tiresize can be changed for each car type. as well as RPM shift point all changable values are in the red boxes..

Anyway here it is..

Download Gear Ratio.xls (http://members.iinet.net.au/%7Echenglee/GearRatio.xls) (Mirror 1 iinet) LAST UPDATED 3rd July 2008
Download Gear Ratio.xls (http://www.ozhonda.com/forum/attachment.php?attachmentid=9719&d=1215059603) (Ozhonda File) LAST UPDATED 3rd July 2008



please tell me what u think your opinions are much appreciated Unless your just going to flame me in which case Pft!!..

[revNhevN]

this is great. thanks.

[wlee2]

^^ i guess not as popular as i thought it would be =(..

[wynode]

Nice work man good stuff! I'll add it to the sticky.

Will the file be safe hosted there (as in can someone find it in say 1-2 years?

[wlee2]

well the site is my internet account website so i dont plan on disconnecting from iinet so i guess its safe there if it changes ill move it somewhere else but for now im sure i will be with iinet for a very long time yet (atleast till i get a iiSLAM in my AREA DANG IT IINET!!!!)

[wynode]

Ok cool but don't forget to update it if you move. Can I attach the original here 'just in case' ?

[wlee2]

mm just for those that dont know much about spread sheets..

if you want to change cars theres a whole lot of tabs down the bottom you select your car there. then within the spreadsheet you can alter the shiftpoint and tiresize at the top in the red box area.. the rest of it will work itself out and you just read the values you want.

if you just add suggestions i will consider them and most likely add them in. i have yet to recieve any responces from DC5 owners about gearbox mods.

[wlee2]

Ok cool but don't forget to update it if you move. Can I attach the original here 'just in case' ?

if you attach the original here then it wont get updated along with the spreadsheet.. as it still gets new things put in.. if your willing i usually post my updates quite frequently you can just update your file everytime i update.

[doriemon]

nice work
thanks
but just a question
is the dc2r in there a JDM model or ADM? or they are the same?

[wynode]

Well I figured that incase your hosted file dissapers for whatever reason.........at least we will have one copy on here hosted on the OH server?

[wlee2]

nice work
thanks
but just a question
is the dc2r in there a JDM model or ADM? or they are the same?


AFAIK they are they same.. and i took the gear ratio of the jap website it was only for a few strange ones that i had to find else where..


and wyn your more than welcome to host a copy on the OH server. just know that the file itself will change over time =P

[wlee2]

umm wyn if you do host it on OH could you maybee edit my first post and add another HERE after my original link and say something like or HERE if the above website is down ?

thx =P u have my permision to edit my post =P not that you need my permission =P

[wlee2]

Added Tire Comparison and Effect on your Speedometer

Fill in Tire Sizes Rim Sizes and Speed at the Speedometer and see how your new tires and Rims will affect your actual Speed VS the Speedo Speed..

Have fun =P


Added Other cool stuff ie tire Outer Circumference thingy..

can i just confirm that the formular for the outer Circumferance of a circle is 2*pi*R ???

thx =P

[Farkis]

here is another good link for this sort of thing
http://www.1010tires.com/tech.asp

[BiLL|z0r]

I think the Euro page isn't for our Euro as redline is 7150rpm, so we can't reach the 7800rpm is tells us is the shift point.

[wlee2]

I think the Euro page isn't for our Euro as redline is 7150rpm, so we can't reach the 7800rpm is tells us is the shift point.


noted and will be changed.. although the shift point can be changed for individual purposes it is infact a variable =P

and sometimes its going to be like that

eg. right now the civic page has both some B series and D series engines in it but theres only one variable for shift point and it changes all of them. might seperate them one day...

but yeh B16 reved higher than its civic counter part the D series so..

but its good you noticed it that meen someone is looking in the other areas besides the integra section =P

[wlee2]

heh i just relooked at it.. the reason for the 7800 redline as i stated previously was because the Euro TL was in the same page as the Euro R.

just like the civics..

but then again dont base your redline stats against my SS since there are so many types of engines and gearboxes some of this stuff will have to remain as variables.. so they are forever changing =P..

and also that was my reasoning for not callling the variable redline aka RPM shift point

hehe enjoy the SS neway..

if you know of any mods for the Euro Gearbox tell me ill add them in

[wlee2]

Added Gear ratios for Honda JAzz..

I have been somewhat slow adding new cars ehh?

Just as a Note Jazz AFAIK all the GLI Vti Vti-S uses the same manual or Auto gearbox its just different engines

[barefootbonzai]

cheers man, i was looking for the thread on crsx but no luck cause it got removed.

[wynode]

wlee2, you can now attach files so might make things easier :)

[wlee2]

Ahh Ignore previous statement.. i attached it as a Zip File onto post 1!

[wynode]

Nice work! Should be easier to manage/update from now on

[wlee2]

Added the Gear Ratios for The new Honda Civic Fd series

I would like someone to "confirm" if the K series Gearbox from a DC5R can be fitted onto the civic i just assumed it can since it is the "same" engine

also the gear ratio information i got seems strange the civic gears are geared lower and well in 5th gear the civic in theory at max RPM and final gear can go 300+ km/h

i would just like someone to confirm that the gear ratios for the new honda civic is correct.

[WhiteAP1]

The S2000 page reads MY00 but the tires are from MY04+ heres a gear calculator that also includes final drive calcualtions, for comparison perhaps.

http://www.turnzero.com/technical_resources.php?resource=gear_calculator

[wlee2]

The S2000 page reads MY00 but the tires are from MY04+ heres a gear calculator that also includes final drive calcualtions, for comparison perhaps.

http://www.turnzero.com/technical_resources.php?resource=gear_calculator


Will Fix that up when i get home tonight!

Might add a bit more tot he s2000 section seems rather empty at the moment

ITs nice to get some feedback.

Cheers

[WhiteAP1]

Forgot to mention great thread by the way, it should help quite a few ppl :thumbsup:

[wynode]

Forgot to mention great thread by the way, it should help quite a few ppl :thumbsup:
Yup agreed!

And good work keeping it updated too.

[SIR GSR]

I can't change the values to suit my car? Help....serious computer newbie here

[wlee2]

what did you need to change to suit your car ? most of the gears are all predefined..

eg if you have a dc2 Vtir goto the DC2 tab and use the Integra vtir section and just change the RPM and tire size to suit.

[wlee2]

Added in a tab for Fully Custom Built GEarboxes So that you can PLay around with the gear Ratios and Final Drives

All stock and aftermarket Additions to the rest of the gearboxes still use the Car make and type for referance..

[WhiteAP1]

improvements look good. But i though i should mention that the standard MPH/KMPH on the s2000 page are a little out. There too high (ie 6th 322kmph) The gear conversion equation seems to work well, u just have to adjust your base figures (i think). The link i mentioned at the top of the page may be a comparison. Keep up the good work.

[wlee2]

improvements look good. But i though i should mention that the standard MPH/KMPH on the s2000 page are a little out. There too high (ie 6th 322kmph) The gear conversion equation seems to work well, u just have to adjust your base figures (i think). The link i mentioned at the top of the page may be a comparison. Keep up the good work.

yeh i noticed that as well..

but!

Do all that and set your RPM at 3000 RPM and 6th gear it sits above 100kmph

it actually sits on 107 kmph

which sounds right.. (if someone with a s2k would kindaly confirm what rpm it sits at 100)

now to me that sounds right. i agree 322 KMph sounds insane.. but remember thats at 9000 rpms (as if it can reach those RPM in final gear)

[WhiteAP1]

http://www.turnzero.com/technical_resources.php?resource=gear_calculator

Should have all the info u need here ^

[wlee2]

i have fixed it up to my best abbility for s2000.

but i can only seem to get it as close as this (maybee i dont use enough decimal points)

but it seem that my formular only doesnt work for the s2000 (I DONT KNOW WHY!!!!)

but it came down to something the S2000 has is like 2 final drives that multiply up together to get their Final Drive..

But either way its pretty close now..
the website was usefull WhiteAP1.. but its hard to tell how accurate their figures are if they dont show me how they got the values.. (granted they could be more accurate than mine but i cant replicate it)

but its much more accurate now than a insane top speed of a s2000 i previously had =P.

also added a seperate TYre dimention for the 00-03 and the 04 S2000 since they are soo different

Thx WhiteAP1.. ++ Rep again.. bt i might not be able too..

[wlee2]

just a few minor fixes..

[wynode]

Is the latest version the attachment or the one linked to?

[wlee2]

they both should be updated !.. i uploaded a new zip file and updated the one on my server..

[Bayani]

Any possibilty for CRXs to be added? ^_^

[wlee2]

Any possibilty for CRXs to be added? ^_^

CRX = civic...

vtir civic is the delsol with the B16A

[Dray_Templar]

great work thanks for the download and link. love ya work.

[Bayani]

Would it be possible to get engine types next to car names for those with conversions, and for clarification? ;)

[wlee2]

Would it be possible to get engine types next to car names for those with conversions, and for clarification? ;)


ill look into that =P..

[Bayani]

Thank you!

[WhiteAP1]

The calcualtor comming along nicely. :thumbsup:

In the S2000 section u've got 6th topping out at over 300 kph.

These figures might be a bit better to go by.


1st 42.8 mph
2nd 65.6 mph
3rd 90.6 mph
4th 115.5 mph
5th 138.1 mph
6th 165.4 mph

keep up the good work.

[wynode]

I haven't checked all the numbers but definitely a lot of work put into it. Good stuff!

[wlee2]

The calcualtor comming along nicely. :thumbsup:

In the S2000 section u've got 6th topping out at over 300 kph.

These figures might be a bit better to go by.


1st 42.8 mph
2nd 65.6 mph
3rd 90.6 mph
4th 115.5 mph
5th 138.1 mph
6th 165.4 mph

keep up the good work.
I swear i changed this already...

am i just uploading the wrong file everytime...

OMG i just relised !!!.. some reason the file wasent uploading.. but fixed it now! was wondering why in FTP it kept saying last updated 2 months ago =P..

[wlee2]

With the New Civic Type R comming out as soon as i find a good source for gear ratios i am going to update this =P..

anyone got any recommendation on what to add or change?

[wynode]

NOt at the moment........a good job so far!

[wlee2]

mm didnt get any replies Re the new Civic Type R or newer FD civics.. anyone sourced a reliable site to find ratios for either?

would be nice to get something to update my spreadsheet with =P

[aaronng]

mm didnt get any replies Re the new Civic Type R or newer FD civics.. anyone sourced a reliable site to find ratios for either?

would be nice to get something to update my spreadsheet with =P

www.carsales.com.au's research section.

FD2R: www.honda.co.jp or www.honda.com.my

[wlee2]

found it else where..

but neway

updated with alot of new stuff..

07+ CTR
EP3R +EP3
FG2, FA5, FD5, CL9, CM5 and CP2

[SiReal]

it says my 98-01 accord shifts at 7800. That is hardly the case, moreso 6200 rpm :)

[wlee2]

it says my 98-01 accord shifts at 7800. That is hardly the case, moreso 6200 rpm :)


you can actually modify that.. since every engine is slightly different =P

its almost impossible to cover all bases in terms of shift point =P

also because the F series shares the same page as the H series =P.. so i covered for the higher reving engine =P

[Klayemore]

That's some nice work mate.

[wynode]

Minor edit to the title made.

[mocchi]

bumpo for good info! i just learned what powerband is lol.. such a noob i am. after knowing what powerband is, this info is somehow much more interesting now.

before i knew what it was... this info was just like... nnyeh.

anyways... come get some!

[nd55]

> I think the Euro page isn't for our Euro as redline is 7150rpm, so we can't reach the 7800rpm is tells us is the shift point.

I don't think the GLi and CXi EK civic stuff is correct either.

3.0 1st, 2.070 2nd and 1.5 3rd gear, 4.8 final drive and 8000rpm shift point.

I wish.


Maybe 3.2, 1.7 & 1.2ish and 7000rpm redline.

Nick.

[wlee2]

> I think the Euro page isn't for our Euro as redline is 7150rpm, so we can't reach the 7800rpm is tells us is the shift point.

I don't think the GLi and CXi EK civic stuff is correct either.

3.0 1st, 2.070 2nd and 1.5 3rd gear, 4.8 final drive and 8000rpm shift point.

I wish.


Maybe 3.2, 1.7 & 1.2ish and 7000rpm redline.

Nick.

the redline is a "VARIABLE"

please peoeple read the first page.

civic has to cater for anywhere from the D series engines to the B series even a Euro K series which B and K have 8000+ Redline..

same for some of the other cars.. you can change it!