×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Continious beam analysis spreadsheet
9

Continious beam analysis spreadsheet

Continious beam analysis spreadsheet

(OP)
Finally, I took time and nailed it down. It's the easiest beam program ever, check it out on www.yakpol.net (it's marked new).

RE: Continious beam analysis spreadsheet

2
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!!

RE: Continious beam analysis spreadsheet

7
(OP)
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

RE: Continious beam analysis spreadsheet

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.

RE: Continious beam analysis spreadsheet

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

RE: Continious beam analysis spreadsheet

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.

RE: Continious beam analysis spreadsheet

(OP)
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.

RE: Continious beam analysis spreadsheet

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

Dik

RE: Continious beam analysis spreadsheet

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

RE: Continious beam analysis spreadsheet

Your new and improved version is even better!

thanks, Dik

RE: Continious beam analysis spreadsheet

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

RE: Continious beam analysis spreadsheet

(OP)
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.

RE: Continious beam analysis spreadsheet

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources