That all looks pretty good Phil. And a lot of work!! Thank you for sharing!
I too have been unable to discern any tendencies with the body type/style information. It's there, I just know it is - we probably are missing a couple key elements that they have hidden.
I've been working on a solution where it probably doesn't matter. Attached is my revised Tonka Toy functions, well, the work sheet, at any rate. As it shows, you can choose any SWR to any degree of accuracy that you care to, and you get the associated Total ARB and Rebound values back. Getting too squirrelly, like 46.17569%, is all for naught because the game can't use the results.
Putting these to work would go something like this...
You have three data entry points - the SWR, the Sb (Spring Bias), and the Curb Weight CW
Oh BTW, just for legacy's sake the value is Spring:Weight ratio. You are actually calculating a Weight:Spring ratio, so all your numbers are an inverse of mine - lest there be some confusion.To get the Total Spring simply multply the CW by the SWR.
TS = CW x SWR
To calculate the Front Spring...
FS = TS x Sb
...and the Rear Spring
RS = TS - FS
To calculate the Total ARB (TA), plug the SWR into a function like this...
TA = IF($C$15=0,0, ROUND(-1*$C$9^2+29*$C$9+6.63,2))
where $C$9 represents the entered SWR.
Now, to get the front ARB multiply the total by anything you want... 55% gets you what they are doing this year - last year it would be the inverse of the Sb...
FA = (1 - Sb) x TA
and the rear, again...
RA = TA - FA
It is another squirrelly function for the Total Rebound (TR)...
TR = =IF($C$15=0,0,ROUND(-1.58*$C$9^2+24.9*$C$9+4.226,1))
And the same treatment from there.
FR = TR * Sb
RR = TR - FR
To get the bump use the flavour that suits you, somewhere between 50% to 75% to be Kosher...
FB = FR * 50%
RB = RR * 50%
Once plugged into a spread sheet, these work pretty effortlessly. I have a worksheet for every car I build, and therefore a record of its settings. The Worksheet is a Boiler Plate, so I just copy files now.
The calcs still need a bit of tweekage... there is a slight bow in the middle of each and I am having the deb-bil's own time beating 'em down...

$