Dismiss Notice

Welcome To CK5!

Registering is free and easy! Hope to see you on the forums soon.

Score a FREE t-shirt and membership sticker when you sign up for a Premium Membership and choose the recurring plan.

ExcelCAD v2.1

Discussion in 'Center Of Gravity' started by Greg72, Mar 5, 2004.

  1. Greg72

    Greg72 "Might As Well..." Staff Member Super Moderator

    Joined:
    Mar 5, 2001
    Posts:
    15,681
    Likes Received:
    1,392
    Location:
    642 Days to BB2018
    It's been a while since I posted any updates to the program, so I thought I'd at least put a link here for one of the "newer" ones.....

    There's more to come but this one has a cleaner interface and should be a little easier to understand and use.

    :usaflag: Enjoy! :usaflag:


    Click Here: It's on my Uber Fancy Website.....




    .
     
    Last edited: Feb 14, 2005
  2. BlazerGuy

    BlazerGuy 3/4 ton status

    Joined:
    Apr 20, 2000
    Posts:
    9,206
    Likes Received:
    0
    Location:
    abcde
    Damn, it doesn't work with MS Works... /forums/images/graemlins/doah.gif
     
  3. Greg72

    Greg72 "Might As Well..." Staff Member Super Moderator

    Joined:
    Mar 5, 2001
    Posts:
    15,681
    Likes Received:
    1,392
    Location:
    642 Days to BB2018
    [ QUOTE ]
    Damn, it doesn't work with MS Works... /forums/images/graemlins/doah.gif

    [/ QUOTE ]

    Once you find a machine to open it with....you'll understand why! /forums/images/graemlins/cool.gif
     
  4. jjlaughner

    jjlaughner 3/4 ton status

    Joined:
    Jan 12, 2001
    Posts:
    7,406
    Likes Received:
    0
    Location:
    Indiana
    That is just downright sweet! Now if I could figure it out /forums/images/graemlins/histerical.gif
    I get the idea, but most of its greek to me /forums/images/graemlins/whistling.gif
     
  5. heavy4x4

    heavy4x4 1/2 ton status

    Joined:
    Aug 28, 2002
    Posts:
    3,270
    Likes Received:
    0
    Location:
    Delafield, Wisconsin
    WOW, nice upgrade!

    Thanks. /forums/images/graemlins/waytogo.gif /forums/images/graemlins/peace.gif
     
  6. az-k5

    az-k5 1/2 ton status

    Joined:
    Oct 15, 2003
    Posts:
    2,774
    Likes Received:
    0
    Location:
    Phoenix AZ
    Very nice. How do you apply it to figure out the front links?
    Thanx for the file.
     
  7. Greg72

    Greg72 "Might As Well..." Staff Member Super Moderator

    Joined:
    Mar 5, 2001
    Posts:
    15,681
    Likes Received:
    1,392
    Location:
    642 Days to BB2018
    [ QUOTE ]
    Very nice. How do you apply it to figure out the front links?
    Thanx for the file.

    [/ QUOTE ]


    Just flip your monitor around.... /forums/images/graemlins/histerical.gif

    Seriously, I think it's the same calcs....just substitute the word "AntiDive" for "AntiSquat" whereever you see it. The prepopulated data in that sheet is actually a design for my FRONT suspension, and it seems to work fine.
     
  8. willyswanter

    willyswanter 1/2 ton status GMOTM Winner

    Joined:
    Dec 24, 2000
    Posts:
    2,690
    Likes Received:
    0
    Location:
    Bakersfield, CA
    Greg, I thought there was something in there that calculated the safety factor on links and all that and I'm not seeing it? I see the forces applied to the links and all but nothing about tube diameter and wall thickness and such. FYI, I ran all my specs of my truck and came up with exactly what I had figured out on my own the hard way /forums/images/graemlins/cool.gif
     
  9. Sandman

    Sandman 3/4 ton status Author

    Joined:
    Apr 15, 2002
    Posts:
    5,653
    Likes Received:
    0
    Location:
    Pocatello, ID
    This is seriously nice work man! /forums/images/graemlins/eek.gif

    Thank you for making this available. /forums/images/graemlins/thumb.gif
     
  10. BIGJ

    BIGJ 1/2 ton status Author

    Joined:
    Feb 17, 2000
    Posts:
    896
    Likes Received:
    0
    Location:
    Central Arkansas
    Finally got Excel for my Mac so I could open this thing. Very nice work Greg... /forums/images/graemlins/thumb.gif /forums/images/graemlins/thumb.gif /forums/images/graemlins/thumb.gif

    BIGJ
     
  11. Bubba Ray Boudreaux

    Bubba Ray Boudreaux 1 ton status

    Joined:
    Jan 21, 2001
    Posts:
    20,716
    Likes Received:
    2
    Location:
    Undisclosed Location
    Looks good

    /forums/images/graemlins/peace.gif

    Now I may actually educate myself on this four link stuff so I can actually answer a question or two when I get PM'ed with them...................

    Or just go into the drug test kit selling business..............


    Looks good, thanks /forums/images/graemlins/peace.gif /forums/images/graemlins/peace.gif /forums/images/graemlins/peace.gif
     
  12. Greg72

    Greg72 "Might As Well..." Staff Member Super Moderator

    Joined:
    Mar 5, 2001
    Posts:
    15,681
    Likes Received:
    1,392
    Location:
    642 Days to BB2018
    Jason,

    It's a multi-tab worksheet....click on the tabs at the bottom to flip to the other info you seek. /forums/images/graemlins/cool.gif
     
  13. white-rhyno

    white-rhyno 1/2 ton status

    Joined:
    Jan 27, 2002
    Posts:
    942
    Likes Received:
    0
    Location:
    Ellensburg Washington
    Greg,
    DO you make the program yourself? I played with it a little last night. Very nicely done. Isnt there a way in excell to see the equations? Thanks for the great stuff.
     
  14. az-k5

    az-k5 1/2 ton status

    Joined:
    Oct 15, 2003
    Posts:
    2,774
    Likes Received:
    0
    Location:
    Phoenix AZ
    To switch from numbers to equations you hit Ctrl + `
    (note - left side of keyboard above tab)
     
  15. Triaged

    Triaged 1/2 ton status

    Joined:
    Feb 21, 2001
    Posts:
    3,808
    Likes Received:
    0
    Location:
    CA (LA/OC area)
    [ QUOTE ]
    Greg,
    DO you make the program yourself?

    [/ QUOTE ]

    He had some help /forums/images/graemlins/whistling.gif

    [ QUOTE ]
    Isnt there a way in excell to see the equations? Thanks for the great stuff.

    [/ QUOTE ]

    Do you really want to see all the calculations? /forums/images/graemlins/ignore.gif

    Allot of head scratching went into those! /forums/images/graemlins/thinking.gif
     
  16. Greg72

    Greg72 "Might As Well..." Staff Member Super Moderator

    Joined:
    Mar 5, 2001
    Posts:
    15,681
    Likes Received:
    1,392
    Location:
    642 Days to BB2018
    [ QUOTE ]
    Greg,
    DO you make the program yourself? I played with it a little last night. Very nicely done. Isnt there a way in excell to see the equations? Thanks for the great stuff.

    [/ QUOTE ]



    From Cell W3:

    "Created 2003.12.01 by Dan Barcroft & Greg Blanchette"



    Most good ideas require more than one brain!!! /forums/images/graemlins/peace.gif
     
  17. yunit

    yunit 1/2 ton status

    Joined:
    Feb 24, 2000
    Posts:
    3,068
    Likes Received:
    0
    Location:
    Oakland, NJ
    Right Click...
    Save Target As...
    ExcelCAD v2.1.xls...
    Click Save...
    Done! /forums/images/graemlins/waytogo.gif

    Thanks for all your hard work Dan & Greg; this will be a big help towards the end of the summer when I finally install my rear triangulated 4 link. /forums/images/graemlins/woot.gif
     
  18. KRAZIE87K5

    KRAZIE87K5 1/2 ton status

    Joined:
    Feb 23, 2001
    Posts:
    3,369
    Likes Received:
    0
    Location:
    Chicago, IL
    Greg-

    I work in a marketing research company that has a dedicated team of people who work MS Office products like no one I've ever seen... until now. I have to say this is one very impressive piece of work. Thanks very much for creating this excellent tool for everyone who has little to no clue about the math behind this spreadsheet. /forums/images/graemlins/bow.gif

    -Dan
     
  19. KRAZIE87K5

    KRAZIE87K5 1/2 ton status

    Joined:
    Feb 23, 2001
    Posts:
    3,369
    Likes Received:
    0
    Location:
    Chicago, IL
    One question for you... when using the materials selection tool, I'm looking to better understand the F.S. #'s that change when changing (for example) the outside diameter from 2" down to 1.75". I can see the lb ratings change in the I column, but I don't really grasp what the changes in the Factorys of Safty are about. Seems like the higher the number the better... Any help for the meager?

    Thanks,
    -Dan
     
  20. Greg72

    Greg72 "Might As Well..." Staff Member Super Moderator

    Joined:
    Mar 5, 2001
    Posts:
    15,681
    Likes Received:
    1,392
    Location:
    642 Days to BB2018
    [ QUOTE ]
    One question for you... when using the materials selection tool, I'm looking to better understand the F.S. #'s that change when changing (for example) the outside diameter from 2" down to 1.75". I can see the lb ratings change in the I column, but I don't really grasp what the changes in the Factorys of Safty are about. Seems like the higher the number the better... Any help for the meager?

    Thanks,
    -Dan

    [/ QUOTE ]





    The FS values are "dimensionless"....they have no units, so they are only useful in comparing to other FS values. In some ways it's better because it "normalizes" everything down to a value that can be compared.

    I remember Triaged gave some general guidlines for what the values should be for a front suspension design vs. rear (hint: a steering suspension should have a higher safety factor since it can KILL you!)

    If you play with the numbers for a while you will see that getting certain FS values higher is pretty hard to do. For example, a Bending FS is mostly a function of the length of the tube you use. You can change the thickness or OD of the tube and get minor improvements, but to really make the FS climb, you need to shorten the link. Stuff like that can be really insightful when you come up with a design you like..... it really is all about compromises in link design, and the more you understand it, the better able you are to choose your compromises wisely!!! /forums/images/graemlins/thumb.gif
     

Share This Page