Articles, Blog

Beam Deflection Calculator Excel Sheet | Spreadsheet Download

September 9, 2019

Start with entering the values regarding the situation. Enter the load… The E-modulus or Youngs modulus can be found on the second tab of the sheet for a lot of materials. You will still have to manually calculate the Moment of Inertia. Or download a sheet for that too. The value ‘X’ is the distance from the wall to the point from which you want to know the deflection/gradient. The sheet will convert values to the right expression. It will calculate the deflection at X, the gradient at X, and the deflection at the end of the beam. There are four different situations/loads that can be calculated.

You Might Also Like


  • Reply Prashant More July 16, 2017 at 2:31 am

    will you plz help me ?
    Im trying to build an ultralight aircraft's wing but i dint find tool to calculate tube sizes for handle particular load for different material…
    im searching a spreadsheet for Selecting tube beam size depend on different forces like Distributed lad, Shear forces, point load etc, plz let me know if you found any ..

  • Reply Dinesh Wick August 4, 2017 at 4:35 am


  • Reply telelaci2 August 5, 2017 at 3:33 am

    This is nice thanks, but I think its faulty.
    At least its impossible to figure out what is Moment of Inertia [mm4]
    If I write 1E6 in that field, then I get 1 m4 Moment of Inertia at few fields below. And that is impossible 1 m4 is not equal with 1E6 mm4.
    1 m4 = 1E4 dm4
    1 m4 = 1E8 cm4
    1 m4 = 1E12 mm4
    So how will we get 1 m4 from 1E6 mm4 ?
    A simple 20/80 – 20mm square aluminum extrusion has about 3 cm4 inertia Ix=Iy , which is much-much bigger than the 65 mm4 in the above example in the video. So you are calculating a very tiny rod, much smaller than 2cm and you put 6 tons on it and its 3 meter long but deflects only 8 mm. But 65 mm4 moment of inertia means a much smaller beam than an ice-cream rod. Thats a hell of good super beam, if doesn't move from 6 tons, thats a weight of 2 Hummer SUV's

    And the sheet is password protected, so we can't fix it, neither check it. What's the purpose of protecting it ? Is this a huge secret or what ? Calculating the deflection of a rod is the most basic engineering calculation. Someone wanna steal this, you think so ? Its not working and you are obviously not a mechanical engineer if you can't see such a fatal error.
    You put lot of work, long hours to make it fancy, and you think it is worth a lot because of that. Hmmmm.

  • Reply Ex-cell August 17, 2017 at 3:03 pm

    UPDATE: Fixed a conversion typo [mm4 to m4] and changed something that was still in Dutch to English.

  • Reply Soarin Gaming February 9, 2018 at 2:33 pm

    How would we go about making this if the beam had steps

  • Leave a Reply