New Version of my 4-link Analyzer / Calculator
Edit 28 December, 2008
Here is the link to the latest 4-link calculator w/ Vetteboy79's travel mod.
http://mysite.verizon.net/triaged/files/4BarLinkV3.1d.zip
Edit 13 April, 2006
Link to the 3-link + Panhard Bar calculator.
http://mysite.verizon.net/triaged/files/3LinkV1.0bBETA.zip
Please note that this is a BETA version. I have not checked everything and it is possible that there is a mistake in there somewhere. I haven't taken the time to do a more up to date version.
Edit 12 November, 2005
I got the V1.5 HTML from Benjamin Porter (aka MNBen here).
I posted it up on my server. I am going to try and update it sometime to make sure I know what I am doing...and will then attempt to get the travel stuff in there as well as some more features for the next version.
http://mysite.verizon.net/triaged/4linkcalcv15html/index.html
Edit 12/4/2004
Version 3.0 is posted.
Top new features:
-Travel Worksheet that finds the geometry at bump/droop
-Calculates sprung mass CG and "anti-squat CG" (vehicle CG - rear axle CG)
-Fixed errors when bars are parallel (all that is required now is one set of bars to be non-parallel in top view)
-Made the material spec's customizable (you can add to the list if you want)
-Added a text file that explains some of the spreadsheet.
-More color coding
-Moved all the calc's to another page to make room for the drawing on the main page.
-Saved it is an Excel 5.0/97 file so people with old software can use it (doing so made the file HUGE so you might want to save it as the newer version if you have it).
-Name changed to be more "proper"
http://mysite.verizon.net/triaged/files/4BarLinkV3.0.zip
Edit 1/10/2004
I just finished V 2.0. This one draws a picture of your suspension for you. As always if you want to screw with it there is no password to the protection...it is just there to keep you from screwing it up if you don't know what you are doing. I added some more input cells but haven't done anything with them yet...mostly I wanted to draw tires in the top view and position the CG but it is starting to look cluttered anyway.
http://mysite.verizon.net/triaged/files/4LinkCalculatorV2.0a.zip
\Edit
Just uploaded V1.5. Greg72 from CK5 has helped me get it looking a lot better with everything layed out in a more fluent manner. He also added some pull down menus for the link materials. If you click on the cell a little down arrow will pop up next to it. Just click on the down arrow and you will be able to pick from a list of choices. I also added an extra sheet with the coordinate system on it for reference.
http://mysite.verizon.net/triaged/files/4LinkCalculatorV1.5.xls
V2.0 is being worked on (by Greg) that will draw a picture of your suspension geometry automatically. He has already drawn up one for the 2D anti-squat excel program he made and is trying to update it for the new 3D spreadsheet (which doesn't sound easy to me!).
I am working on making it cycle your suspension so you can see how some of these values change as your suspension compresses or droops (articulation would be nice as well but I have no idea even where to start on that).
I am also looking for some other people to help out.
I need someone who knows all this math stuff (most likely another mechanical engineer) to check my work and see if my assumptions are valid.
I would also like to have someone actually use it to analyze their suspension with it and give any notes on how it works in real life.
Take a look at the entire discussion and some other important info in the original CK5 thread
http://coloradok5.com/forums/showfl...6301/page/0/view/collapsed/sb/5/o/all/fpart/1
Also jeepboyben has put my version 1.0 into html/java for those who don't have excel. It still has some bugs to it so I would still recommend the excel version for now. You can check it out here
http://www.isd623.org/ben/jp/fourlink/
Edit 28 December, 2008
Here is the link to the latest 4-link calculator w/ Vetteboy79's travel mod.
http://mysite.verizon.net/triaged/files/4BarLinkV3.1d.zip
Edit 13 April, 2006
Link to the 3-link + Panhard Bar calculator.
http://mysite.verizon.net/triaged/files/3LinkV1.0bBETA.zip
Please note that this is a BETA version. I have not checked everything and it is possible that there is a mistake in there somewhere. I haven't taken the time to do a more up to date version.
Edit 12 November, 2005
I got the V1.5 HTML from Benjamin Porter (aka MNBen here).
I posted it up on my server. I am going to try and update it sometime to make sure I know what I am doing...and will then attempt to get the travel stuff in there as well as some more features for the next version.
http://mysite.verizon.net/triaged/4linkcalcv15html/index.html
Edit 12/4/2004
Version 3.0 is posted.
Top new features:
-Travel Worksheet that finds the geometry at bump/droop
-Calculates sprung mass CG and "anti-squat CG" (vehicle CG - rear axle CG)
-Fixed errors when bars are parallel (all that is required now is one set of bars to be non-parallel in top view)
-Made the material spec's customizable (you can add to the list if you want)
-Added a text file that explains some of the spreadsheet.
-More color coding
-Moved all the calc's to another page to make room for the drawing on the main page.
-Saved it is an Excel 5.0/97 file so people with old software can use it (doing so made the file HUGE so you might want to save it as the newer version if you have it).
-Name changed to be more "proper"
http://mysite.verizon.net/triaged/files/4BarLinkV3.0.zip
Edit 1/10/2004
I just finished V 2.0. This one draws a picture of your suspension for you. As always if you want to screw with it there is no password to the protection...it is just there to keep you from screwing it up if you don't know what you are doing. I added some more input cells but haven't done anything with them yet...mostly I wanted to draw tires in the top view and position the CG but it is starting to look cluttered anyway.
http://mysite.verizon.net/triaged/files/4LinkCalculatorV2.0a.zip
\Edit
Just uploaded V1.5. Greg72 from CK5 has helped me get it looking a lot better with everything layed out in a more fluent manner. He also added some pull down menus for the link materials. If you click on the cell a little down arrow will pop up next to it. Just click on the down arrow and you will be able to pick from a list of choices. I also added an extra sheet with the coordinate system on it for reference.
http://mysite.verizon.net/triaged/files/4LinkCalculatorV1.5.xls
V2.0 is being worked on (by Greg) that will draw a picture of your suspension geometry automatically. He has already drawn up one for the 2D anti-squat excel program he made and is trying to update it for the new 3D spreadsheet (which doesn't sound easy to me!).
I am working on making it cycle your suspension so you can see how some of these values change as your suspension compresses or droops (articulation would be nice as well but I have no idea even where to start on that).
I am also looking for some other people to help out.
I need someone who knows all this math stuff (most likely another mechanical engineer) to check my work and see if my assumptions are valid.
I would also like to have someone actually use it to analyze their suspension with it and give any notes on how it works in real life.
Take a look at the entire discussion and some other important info in the original CK5 thread
http://coloradok5.com/forums/showfl...6301/page/0/view/collapsed/sb/5/o/all/fpart/1
Also jeepboyben has put my version 1.0 into html/java for those who don't have excel. It still has some bugs to it so I would still recommend the excel version for now. You can check it out here
http://www.isd623.org/ben/jp/fourlink/