Continious beam analysis spreadsheet 9

[yakpol]

Finally, I took time and nailed it down. It's the easiest beam program ever, check it out on

http://www.yakpol.net

(it's marked [red]new[/red]).

 

[TampaBridgeDesign]

Thanks for your hard work on this spreadsheet! I know this might be asking a lot since what you're doing is completely free but how hard would it be to modify your spreadsheet to include vertical members? Florida DOT uses an end bent cap on prestressed piles so that would enable us to get pile loads. They have a MathCAD sheet that calculates this for you but not everyone out there has MathCAD. Thanks!!

 

[yakpol]

TampaBridge,
To include vertical members will require to change force method to displacement method to solve statically undetermined structures. I have no intentions to complicate this spreadsheet, may include elastic supports, thats all. My main goal was: quick and easy.

Yakpol

 

[electricpete]

Thanks for sharing. I've been learning beams a little lately (very little). I'm used to seeing moment, shear, slope, and deflection (obtained by successive integrations of the load profile). Instead of slope you have rotation. What is rotation?

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[yakpol]

electricpete,
Rotation is a slope, different words. Successive integrations method is good for textbook only, very cumbersome to code.

 

[electricpete]

I see that now. I was looking to verify that the max/mins of deflection occurred at the zeroe's of rotation. I incorrectly assumed the heavy bar horiziontal axis at 0 level for displacement was also zero level for rotation.

Did you use a technique other than integrations?

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[yakpol]

electricpete,
The integration is a general method, that you may use only after statical undeterminancy is solved. To solve it I used force method, as the easiest to program for cont. beams. Basic idea of the force method for beams is to release joints at the supports and to find restraining moments from the system of linear equations. For some reasons I could not find implementation of this mehtod specifically for cont. beams in the US published text books (not like I looked through all of them), so I just had to recall what I learned 20 years ago back in Russia.

 

[dik]

Thanks for the great and useful program... quick and dirty...

Dik

 

[markwazzzzzz]

Yakpol... This is a wonderful spreadsheet!!! I have been looking for a something like this for a long time. I feel like I have finally found the the Holy Grail of beam analysis spreadsheets. What a wonderful piece of work. Thank you so much!!! Mark

 

[dik]

Your new and improved version is even better!

thanks, Dik

 

[BurgoEng]

It looks like the sheet can analyze only down to 3 span members. Is this correct?

 

[yakpol]

Currently there're two spreadsheets in zip file, one is good for 10 spans and another is for 100. Spreadsheet calculates number of spans based on span length you input.

 

[TampaBridgeDesign]

Thanks for including the option of using elastic supports! This spreadsheet you've developed is priceless!!