Frame Analysis with Excel – 6; Beam end releases and actions

Continuing from: Frame Analysis with Excel – 5; Large frames in Excel 2003

Download Frame3.zip – the download file includes complete open source code.

The frame analysis spreadsheet presented previously has now been revised to deal with beam end releases (either rotation or translation) and to produce a table of member end actions, as well as node deflections and reactions.

In addition, all of the calculations, including formation and solution of the required matrices, are now performed in the VBA routines, with the spreadsheet being used for data entry, and presentation of the results.

Shown below are results for two example frames, with results from the same frames analysed in Strand7.

Example 1: Simple frame with inclined member and 1 beam end release.

Simple Frame; Strand7 Results

Simple Frame; Strand7 Results

Simple frame; Spreadsheet results

Simple frame; Spreadsheet results

Example 2: Building frame with vertical and horizontal loads, and 2 beam end releases.

Building Frame, Strand7 Results

Building Frame, Strand7 Results

Building Frame; Spreadsheet results

Building Frame; Spreadsheet results

This entry was posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA. Bookmark the permalink.

4 Responses to Frame Analysis with Excel – 6; Beam end releases and actions

  1. xm carreira says:

    Thank you very much. I will give it a try.

    Like

  2. CroAxis says:

    This frame analysis add-on looks like an excellent tool, I will definetly use it for my studies in the future…if I ever need to go that far!

    Like

  3. Pingback: Frame Analysis with Excel – 7; Shear deflections and support displacements « Newton Excel Bach, not (just) an Excel Blog

  4. Pingback: Frame Analysis with Excel | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s