Page 33

This spreadsheet combines some of the spreadsheet functions found on previous pages. Specifically, the effects of static weight distribution, preloading, different front spring rates, and asymmetric adjustment of the rear suspension links can all be examined within this one spreadsheet.

To use the spreadsheet, you must first calculate some percentages based on the results of scaling your car. I could have allowed you to simply input the wheel loads, but that would have required some tests to see that your inputs are reasonable, so I'm asking you to do some of the work.

Only the "percent of rear on left rear" is affected by the usual preload adjustments. These include, for instance, adjustable coilovers, adjustable anti-roll bar links, adjustable 4links, and air bags. To change "percent on left side" and "percent at rear," it is necessary to change component locations and/or weights.

If the trailing links are symmetrical, the "lateral spacing" number can be any number greater than zero. The sum of anti-squat percentages might seem strange, but it's necessary to determine the effect of asymmetric adjustment. The same is true for the sum of the front spring rates.

The point of the spreadsheet, of course, is to adjust your inputs until that ratio...the final result in the "answers" box...has a value of one. That will mean the rear tires are equally loaded and maximum performance will be achieved.

total weight =

percent on left side =

percent at rear =

percent of rear on left rear =

CG height =

wheelbase =

lateral spacing between links =


rear tire radius =

axle ratio =

left front spring rate =

total front spring rate =

left side percent anti-squat =

total percent anti-squat =

rear track =


Static Weight Distribution
Left FrontRight Front
Left RearRight Rear
Left Rear to Right Rear Ratio at Launch