Welcome to Our Community

Some features disabled for guests. Register Today.

Excel Sheet to calculate Deflection V3

deflection, v-slot, excel

  1. maleuffy

    maleuffy New
    Builder

    Joined:
    Jan 16, 2016
    Messages:
    8
    Likes Received:
    1
  2. maleuffy

    maleuffy New
    Builder

    Joined:
    Jan 16, 2016
    Messages:
    8
    Likes Received:
    1
  3. Mark Carew

    Mark Carew OpenBuilds Team
    Staff Member Moderator Resident Builder Project Maker Builder

    Joined:
    Jun 28, 2013
    Messages:
    2,212
    Likes Received:
    1,536
    Very nice thank you for putting this together @maleuffy
     
  4. maleuffy

    maleuffy New
    Builder

    Joined:
    Jan 16, 2016
    Messages:
    8
    Likes Received:
    1
  5. David Klug

    Builder

    Joined:
    Jan 21, 2016
    Messages:
    4
    Likes Received:
    0
    This is amazingly useful. Helped me decide what size v-slot to get. Thanks
     
  6. maleuffy

    maleuffy New
    Builder

    Joined:
    Jan 16, 2016
    Messages:
    8
    Likes Received:
    1
    Glad it helped!
     
  7. rwensley

    rwensley Well-Known
    Builder

    Joined:
    Nov 30, 2015
    Messages:
    4
    Likes Received:
    4
    @maleuffy I am looking at a build that would either stack two c-beams or place them back to back, or both, and I am looking at your spreadsheet for aid in calculating the sag. Your spreadsheet is very nicely done and extremely useful by the way.

    So I am wondering how you calculated the moments for the complex shape of the beams? I see that the X axis I for the C-Beam is 1.1774E-07. How is this derived?
    Electrical engineers know little about this gear head stuff;)

    Thanks for your work on this.
    Ron
     
  8. maleuffy

    maleuffy New
    Builder

    Joined:
    Jan 16, 2016
    Messages:
    8
    Likes Received:
    1
    Hello,

    I wish I could help you more on this but the Excel sheet is actually an interpretation of this guide.
     
  9. Art melanson

    Builder

    Joined:
    Dec 5, 2017
    Messages:
    3
    Likes Received:
    0
    Hello. I am not sure but I think there is a mistake in your conversions for I in your deflection spreadsheet. You use powerE -9 in the spread sheet. It shoud be power E-8
    Hello.
    I have tried your deflection calculation and cannot get the same results as I get in other calculators.

    It seems your deflections are 10 times too high.

    you do not put your units in so it is hard for me to confirm which calculator is right.

    I believe the issue is with your conversion of I.

    For instance: simple beam deflection calculation.
    for the 40x40 beam I= 81.407 cm^4 (i assume units)

    Your speadsheet converts this to

    Inertia on X : 8.141E-08 m^4 (i assume units again)

    my conversion would be to 8.14E-07 m^4 or 81.4E-08


    Am I missing something??
     
  10. Rob Stehlik

    Rob Stehlik Journeyman
    Builder

    Joined:
    Apr 20, 2015
    Messages:
    10
    Likes Received:
    59
    Art,

    I did not create this spreadsheet, but it is based on a guide I wrote a while back:
    How to calculate V-Slot® deflection

    The units for the area moment of inertia in the table are m^4. This is shown at the top of the table, but perhaps it would be best to show units next to the values as well.

    I took a quick look and it appears that the spreadsheet matches the results I got. It's quite possible I made a mistake in my document, please take a look and let me know if you find anything.

    Rob
     
  11. Art melanson

    Builder

    Joined:
    Dec 5, 2017
    Messages:
    3
    Likes Received:
    0
    OK Rob
    I see your calculations now from the guide. The spead sheet is right in its calculations, but is giving the wrong number for inertia in the table (then corrects it with the calculations). The numbers shown for the inertia should be corrected adding the power and showing the units.
    Great help though. thanks.
    Art.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice