I know there are a bunch of online tire calculators to convert from metric to inches and all but it’s kinda of a pain to go back and forth and not be able to keep track of the numbers.

 

Besides I work at a place that times your internet usage.

 

So here are the formulas.

(btw .03937001 is the conversion from inches to mm.)

For metric to inches:

 

Best way to set up the table is to have the titles in the following order

Column A _______________________|Column B _____________|Column C

1 Width _________________________|Ratio ________________|Rim

2 205 ___________________________|55 __________________|16

3

4 Diameter _______________________|Width _______________|Rim

5 =sum(widthXratio)X(.03937001)X2+rim |=sum(widthX.03937001) |=sum(rim)

 

You have to change the formula values for width, ratio, rim according to the cells that you have the values in. example. Values are entered on line 2 of a spreadsheet. So formula would be

=sum(A2XB2)X(.03937001)X2+C2.

 

For inches to metric

Column A ___________|Column B _________________________|Column C

1 Diameter __________|Width ____________________________|Rim

2 24.87794__________| 8.0708521 ________________________|16

3

4 Width ____________|Ratio _____________________________|Rim

=sum(width/.03937001)| =sum(diameter-rim)/(.03937001)/2/width*_|=sum(rim)

 

*the width here is the value to the left of the ratio field. This is easier to use b/c the number you are getting the inch width/.03937001. Since you already have that figure in field A4. No sense in typing more that you have to.

So for ratio the formula would be

=sum(A2-C2)/(.03937001)/2/A4

 

Well hope this is useful.

 

BW

 

just found out you can upload xls files, just click on what I made and enjoy.

Thanks! You rock!

I made some changes to the excel file.

 

it's a protected workbook now so you can't mess the formulas up.

 

if you want to tweak the workbook, click tools at the top menu bar and go to protection and select unprotect.

 

The formulas are also put into the comments section of the cell.

place mouse over cell w/red triangles.

 

Enjoy.

 

BW

The only thing better would be to build it into an Access DB. Nice work, Tim