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