Bimmerforums Upgrade Garage The Tire Rack
Results 1 to 1 of 1

Thread: Rolling Circumference and Tire Fitment

  1. #1
    Join Date
    Jul 2008
    Location
    MD
    Posts
    152
    My Cars
    964C4

    Rolling Circumference and Tire Fitment

    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%.
    Attached Images Attached Images

Similar Threads

  1. Wheel and Tire Fitment FAQ
    By wbm535i in forum 1982 - 1988 (E28)
    Replies: 12
    Last Post: 08-19-2021, 02:03 PM
  2. 2000 328i Sport Suspension wheel and tire fitment
    By Majorp in forum Tire & Wheel Forum sponsored by The Tire Rack
    Replies: 3
    Last Post: 08-23-2007, 01:22 PM
  3. Ready to order...Quick help with rim and tire fitment
    By Veloce1 in forum 2002 - 2008 Z4 (E85, E86)
    Replies: 2
    Last Post: 06-15-2007, 08:57 AM
  4. Wheel and Tire Fitment Question
    By M3Alpine99 in forum Tire & Wheel Forum sponsored by The Tire Rack
    Replies: 0
    Last Post: 08-22-2006, 02:15 PM
  5. Wheel and tire fitment question.
    By DTM Derek in forum 1991 - 1999 (E36)
    Replies: 0
    Last Post: 04-24-2006, 03:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •