I have a C4 with non-oem wheels that Im looking to put slicks on, and I didnt really like the calculators that I could find online, and TireRack's matching doesnt quite work for my application so I made an excel sheet that calculates the rolling circumference for a staggered setup, variances between the rolling circumferences, and if the tire should fit a specific rim width and if it falls within the ideal sizing. Should be useful for people with AWD staggered setups, or just people looking for different sizing options just to check for wheel fitment.
For some reason I cant upload the zip file, even though the additional options say its supported, it keeps saying its an invalid file when I try to upload it. Here are the formulas though, you may need to remove spaces if it adds them inside the formula when copy pasting it, and youll have to setup the excel sheet to look exactly like the screenshot but the hardest part is done. Most calculators online use 96% as the rolling load circumference, but I used 96.5% (change in first formula).
OEM front rolling: =2*PI()*(((C3/100)*(B3)+(D3*25.4)/2)*0.965) variance is 1-(F3/F4)
Tires Fit?: =IF(AND(VLOOKUP(E3,$N$3:$R$25,3,FALSE)<=B3,VLOOKUP(E3,$N$3:$R$25,4,FALSE)>=B3),"Ideal",IF(AND(VLOOKUP(E3,$N$3:$R$25,2,FALSE)<=B3,VLOOKUP(E3,$N$3:$R$25,5,FALSE)>=B3),"Yes","No"))
Front OEM to New Variance: =1-(F3/F8)
Actual Speed @ Speedometer Reading: =70+(70*K6)
I put conditional formatting on the front oem to new variances to highlight when outside of -1% and 1%.
Bookmarks