Moog Spring Excel Sheet for Coil Spring Selection - Great Lakes 4x4. The largest offroad forum in the Midwest

Go Back   Great Lakes 4x4. The largest offroad forum in the Midwest > 4x4 Talk > General Tech
GL4x4 Live! GL4x4 Casino

greatlakes4x4.com is the premier Great Lakes 4x4 Forum on the internet. Registered Users do not see the above ads.
Search
Reply
 
Thread Tools Search this Thread
Old April 3rd, 2013, 04:15 PM   #1
feva4u
LCG
 
feva4u's Avatar
 
Join Date: 04-01-07
Location: Petoskey, MI
Posts: 10,345
iTrader: (12)
Mentioned: 6 Post(s)
Default 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
http://www.fme-cat.com/TechnicalInformation.aspx

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.
Attached Files
File Type: xlsx MOOG_Coil_Springs_Spec.xlsx (84.6 KB, 31 views)
File Type: xls MOOG_Coil_Springs_Spec-97.xls (170.5 KB, 57 views)
File Type: pdf MOOG_Coil_Springs_Spec.pdf (802.0 KB, 24 views)
__________________
My Jeep
feva4u is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old April 3rd, 2013, 04:51 PM   #2
s.hembree
Senior Member
 
s.hembree's Avatar
 
Join Date: 03-16-07
Location: Grand Rapids, MI
Posts: 1,399
iTrader: (4)
Mentioned: 0 Post(s)
Default

nerd.
s.hembree is online now   Reply With Quote
Old April 3rd, 2013, 05:16 PM   #3
feva4u
LCG
 
feva4u's Avatar
 
Join Date: 04-01-07
Location: Petoskey, MI
Posts: 10,345
iTrader: (12)
Mentioned: 6 Post(s)
Default

Quote:
Originally Posted by s.hembree View Post
nerd.
Maybe I should have bought air shocks instead?
__________________
My Jeep
feva4u is offline   Reply With Quote
Old April 3rd, 2013, 08:05 PM   #4
CheapThrillB2
FAWK YEAH!!
 
CheapThrillB2's Avatar
 
Join Date: 09-06-06
Location: Middleville, MI
Posts: 30,996
iTrader: (61)
Mentioned: 3 Post(s)
Default

ORI's
CheapThrillB2 is offline   Reply With Quote
Old April 3rd, 2013, 08:15 PM   #5
xj4life
Senior Member
 
xj4life's Avatar
 
Join Date: 11-09-05
Location: LaPorte, IN
Posts: 7,615
iTrader: (15)
Mentioned: 2 Post(s)
Default



thank you! i was going to run leafs for my next budget build but now i might just have to link it instead
__________________
This is my Jeep. There are many like it, but this one is mine. My Jeep is my best friend. It is my life. I must master it as I master my life. My Jeep, without me, is useless. Without my Jeep, I am useless.
xj4life is offline   Reply With Quote
Reply
Great Lakes 4x4. The largest offroad forum in the Midwest > 4x4 Talk > General Tech

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 09:12 AM.


Powered by: vBulletin, Copyright 2000 - 2012, Jelsoft Enterprises Ltd.
User Alert System provided by Advanced User Tagging (Lite) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd. Runs best on HiVelocity Hosting.
Page generated in 0.10951 seconds with 37 queries