Welcome to the THE H.A.M.B. forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

Go Back   THE H.A.M.B. > General Discussion > The Hokey Ass Message Board

Reply
 
Thread Tools Display Modes
Old 08-17-2007, 12:04 PM   #1
Paul
Editor
 
Paul's Avatar
 
Join Date: Aug 2002
Location: Lahar Valley, WA
Posts: 12,177
Default leaf spring rate calculator for EXCEL

alternate thread title;
slow day at work

flipping through my copy of Chassis Engineering I see a basic formula for calculating spring rates for leaf springs

leaf width times number of leaves devided by 12 times 1000 times leaf thickness devided by leaf length to the third power

and wrote this short excel formula to have a calculator on hand just in case I want to do some quick syferin'

anybody else got any nifty excel formula?
Attached Thumbnails
Click image for larger version

Name:	leaf spring rate calculator.JPG
Views:	1123
Size:	65.2 KB
ID:	344715  
offline   Reply With Quote
Old 08-17-2007, 02:01 PM   #2
enginebloch
Grenade Inspector
 
Join Date: Feb 2006
Location: norfolk va
Posts: 114
Default Re: leaf spring rate calculator for EXCEL

I made one that figures out optimum intake and exhaust runner length and graphs the results so you can tune your custom manifolds easier. Its based on Helmholtz Resonator equations.
If anybody wants a copy, just shoot me a pm.
__________________
Flatlanders Media Blasting
Specializing in Antique sheetmetal cleaning, and general hot rod repair.
offline   Reply With Quote
Old 08-17-2007, 02:50 PM   #3
blown49
Member Emeritus
 
blown49's Avatar
 
Join Date: Jul 2004
Location: West Union, OH.
Posts: 2,230
Default Re: leaf spring rate calculator for EXCEL

I made one for figuring out rear end ratio required for a drag car based on desired max engine rpm at the end of the quarter mile. (Didn't want to over-rev our flatty in the HA/GR car.)
__________________
My Blown Flathead '49 Merc Website @: http://www.blown49.com
offline   Reply With Quote
Sponsored Links (Register now to hide all advertisements)
Old 08-17-2007, 03:03 PM   #4
Sour Kraut
Newbie
 
Join Date: Jun 2007
Location: Slate Hill N.Y.
Posts: 72
Default Re: leaf spring rate calculator for EXCEL

I have one to compute compression ratio, if you want it P.M. me. If someone knows how to post an excel file, please post instructions and I will post the file.
__________________
"Cheap ain't safe and Safe ain't cheap!
Do it right and live to do it again!"
offline   Reply With Quote
Old 08-17-2007, 03:09 PM   #5
Paul
Editor
 
Paul's Avatar
 
Join Date: Aug 2002
Location: Lahar Valley, WA
Posts: 12,177
Default Re: leaf spring rate calculator for EXCEL

testing, attach as zip
Attached Files
File Type: zip leaf spring rate calculator.zip (1.4 KB, 1302 views)
offline   Reply With Quote
Old 08-17-2007, 03:37 PM   #6
Sour Kraut
Newbie
 
Join Date: Jun 2007
Location: Slate Hill N.Y.
Posts: 72
Default Re: leaf spring rate calculator for EXCEL

Spring rate zip works, hope this does.
Attached Files
File Type: zip Compression Ratio Calculator.zip (2.5 KB, 475 views)
__________________
"Cheap ain't safe and Safe ain't cheap!
Do it right and live to do it again!"
offline   Reply With Quote
Old 08-17-2007, 03:56 PM   #7
Stude350guy
Member
 
Stude350guy's Avatar
 
Join Date: Jun 2005
Location: Travelers Rest, South Carolina
Posts: 561
Default Re: leaf spring rate calculator for EXCEL

Thanks, everyone. When I get home I'll try to download all this. It looks like really helpful stuff. Appreciate it!
__________________
"Ain't no replacement for displacement!"
offline   Reply With Quote
Old 08-17-2007, 09:59 PM   #8
Flat Ernie
Tech Editor
 
Flat Ernie's Avatar
 
Join Date: Jun 2002
Location: Ft Walton Bch
Posts: 8,293
Default Re: leaf spring rate calculator for EXCEL

I've got one for tire diameter, rpm, gear ratio, & speed...it's clunky, but I like it.. I'll try to attach later..

EDIT - Attached it - it's got tabs for the common early Ford rear ratios along with each of the various trans cluster ratios - you can input tire size at the top & it populates the rest of the sheet with rpm. First sheet has some various gear ratio/rpm/mph calculators
Attached Files
File Type: zip Ratio-RPM-MPH-Tire.zip (14.7 KB, 234 views)
__________________
Daddy always said, If yer gonna be dumb, ya gotta be tough! - And I'm one tough sumbitch!

T5 Tech

Last edited by Flat Ernie; 08-18-2007 at 09:58 AM.
offline   Reply With Quote
Old 08-18-2007, 08:49 AM   #9
40Tudor
Alliance Member
 
40Tudor's Avatar
 
Join Date: Jan 2002
Location: Shoreweed, MN
Posts: 629
Default Re: leaf spring rate calculator for EXCEL

Here's a few that I've made over the years. I have others, but these are probably the most useful and easy to comprehend.

Ratio - Shows relationship between road speed and rpm on a graph based on rear wheel size (accounting for tire crush), rear end gears and tranny gears. I made a table of trans gears for comparison purposes.

Carbsize - This one was based on info from an Edelbrock catalog a few years ago. Might be useful in selecting carbs.

Suicide tube strength - a quick and dirty one showing deflection for different diameters and wall thicknesses of round tubing.
Attached Files
File Type: zip Ratio.zip (10.4 KB, 191 views)
File Type: zip carbsize.zip (6.3 KB, 160 views)
File Type: zip Suicide Tube Strength.zip (2.1 KB, 187 views)
offline   Reply With Quote
Old 08-21-2007, 04:14 PM   #10
Paul
Editor
 
Paul's Avatar
 
Join Date: Aug 2002
Location: Lahar Valley, WA
Posts: 12,177
Default Re: leaf spring rate calculator for EXCEL

'nuther super basic one
this could be adapter for any motor,
just change the stock bore and stroke columns to match your motor's stoke numbers

to use this just put your desired over bore and over stroke numbers in the blue column

and check out the new cubes in the red column
Attached Files
File Type: zip Olds Cubic inch calculator.zip (1.8 KB, 135 views)
offline   Reply With Quote
Old 08-21-2007, 06:13 PM   #11
telecaster_6
Member
 
telecaster_6's Avatar
 
Join Date: Dec 2001
Location: Dorr, Mi
Posts: 565
Default Re: leaf spring rate calculator for EXCEL

Alright guys....most of the hard work has been done for you already....

http://www.wallaceracing.com/Calculators.htm
__________________
Gotta mind like Charlie Manson, and a mouth like Johnny Cash....
offline   Reply With Quote
Old 08-25-2007, 10:22 PM   #12
30dodgeboy
Member
 
30dodgeboy's Avatar
 
Join Date: Nov 2004
Location: usually in the garage - somewhere in WI
Posts: 952
Default Re: leaf spring rate calculator for EXCEL

Quote:
Originally Posted by Paul View Post
flipping through my copy of Chassis Engineering I see a basic formula for calculating spring rates for leaf springs

Does this assume the center bolt (and point of spring rate measurement) is equidistant from each end?

Of course, most MoPars have shorter spring segments ahead of the rear axle than behind the rear axle...
__________________
WANTED: 1930 Dodge parts
Vintage drag meet!
July 18 19 20, 2014 Bryon, IL
www.meltdowndrags.com
offline   Reply With Quote
Reply

Thread Tools
Display Modes

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 On

Forum Jump

Sponsored Links (Register now to hide all advertisements)


All times are GMT -5. The time now is 03:57 PM.