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; Spreadsheet results

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

Building Frame, Strand7 Results

Building Frame; Spreadsheet results

### Like this:

Like Loading...

*Related*

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

LikeLike

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!

LikeLike

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

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