I was able to get a copy of the Brunton worksheet for GAZ coilovers. I don't think I fully understand it yet. Here are two screenshot graphics from the working copy I have.
Attachment:
My Settings 2.jpg
Attachment:
My Settings 1.jpg
The green fields are ones you can alter to suit. The documentation says the use 33.333 Droop% as a start, which isn't really explained. It also says the red cell droop number (D17) is the amount the suspension will compress with any given frequency. Why that is true isn't clear to me.
I chose Droop% = 40 because that's what gave me 2" droop and 3" bump, which is the standard Locost assumption. My coilover angle is 45 degrees. Looking at the part of the spreadsheet that gives "Spring corrected for tilt and motion ratio", i.e., the spring you would actually buy (?), I get 757 lb which is about twice what most guys seem to run. So, I'm not sure I'm understanding this worksheet correctly.
My weight estimate is pretty conservative, and likely on the high side. It includes 2 passengers, full interior, luggage, insulation and the spare tire and it's carrier. So, I'm going to go back and re-examine it and alter values if indicated. I've used 80% of estimated weight at the tire contact patch as the sprung weight figure. That's the 378 input.
The other confusing thing is the rightmost table, "Available Shock lengths and specs." For the coilover with 5" of travel (the amount of travel I'd need) it says Rideheight = 13.0. Is that the length of the the coilover at ride height? It would seem to fit with a 2" droop (extended) and a 3" bump (compression), but not explicitly clear here.
I'm confused.
Is anyone more familiar with this worksheet than I am?