|April 3rd, 2013, 05:15 PM||#1|
Join Date: 04-01-07
Location: Petoskey, MI
Moog Spring Excel Sheet for Coil Spring Selection
CC finally put excel files on the attachment list so here's a write-up on using the spreadsheet to find coil springs in different rates that will ride at about the same height. Microsoft excel is needed, or you can probably use google's ripoff of it....haven't tried it though. Use at your own risk, "CC" springs are variable rate and the spreadsheet won't be accurate for ride height because the spring rates are not constant. The spreadsheet also assumes your springs are mounted vertical.
Download and open the spreadsheet. Enter your corner weight for the vehicle for the corner you want to find a spring for. If you don't know your current corner weight, you will have to look up what spring you currently have using the application lookup on the fme website mentioned later, find the spring rate, find the free length, and measure the length at ride height.
Corner weight* = (Free length -measured ride height length) x spring rate.
*for constant rate springs, variable rate won't work correctly with that calculation.
Once you enter your corner weight in the green box, you'll want to highlight all the info below the black boxes and then go to "Sort & Filter"........then "Custom Sort".......then sort column J from largest to smallest(or smallest to largest if you prefer). This will put the springs in order of "Installed Spring Height" using the corner weight you entered. From there you can scroll down to the height you want to sit at and start looking for springs that suit what you want to achieve.
Looking at what I want at 640lbs/rear corner on my TJ, Spring 3224 has the right ends (PT, TG), 134lb spring rate, and a ride height of 11.61 in which is about where I want the rear of my TJ to sit.
Click the hyperlink in the excel file that will take you to
Enter your spring number in the "Part Number/Interchange" box and hit go. "3224" in this instance.
Click on the link for the part number for application info
The description tab should match the info in the spreadsheet but has more information for those that want it
The applications tab shows the "Passenger Car & Light Truck" drop down menu, click on that to show vehicle applications. In this case it happens to be 1997-2006 Jeep TJ spring.
I can look for the pricing for 3224 springs, or go look for them in the junkyard now that I know the application. If I don't like the price, I can look back in the spreadsheet for similar spring rates with about the same ride height and check the pricing on those instead.
If you want to figure out how to use excel, try youtube, I'm no expert. I attached the .xls, .xlsx, and the pdf the info came from originally.