This spreadsheet combines some of the spreadsheet functions found on previous pages. Specifically, the effects
of static weight distribution, preloading, changes in roll stiffness distribution, 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.
Unfortunately, the "percent of roll stiffness at front" is a bit nebulous. The initial value of "60" is probably close
for a production car and will certainly get you "within the ballpark." The addition of that which is called an "anti-roll
bar" and the deletion of the front swaybar, however, reduces this value considerably. My present estimate would be that the
input value should be about "40" with these changes, but I'm hoping that better information will soon be available.
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.