Starting from 2009 I have posted a series on frame analysis using Excel, starting from a simple “on-sheet” solution and working through to applications able to solve large 2D or 3D problems. To follow the analysis process it is best to read these posts in sequence, but the links between them are hidden in the comments, and in one case the link seems to be missing, so here is a list of all the frame analysis related posts, in date order:

• Frame Analysis with Excel 1 – Single beam
• Frame Analysis with Excel 2 – Single inclined beam
• Frame Analysis with Excel – 3, Continuous beam or frame
• Frame Analysis with Excel – 4, 2D frame analysis
• Frame Analysis with Excel – 5; Large frames in Excel 2003
• Frame Analysis with Excel – 6; Beam end releases and actions
• Frame Analysis with Excel – 7; Shear deflections and support displacements
• Update to Frame4.xls
• Frame4.xls – Update2
• Frame4 – with intermediate beam results
• Frame4; now with added Alglib
• Frame4 Version 3.04
• Frame4 Version 3.05; with support displacements
• Extending Frame4 with on sheet formulas
• 3DFrame – 3D Frame analysis for Excel
• 3DFrame v1.01
• Using Frame4 for truss analysis
• 3DFrame Ver 1.03 and Frame4 Ver 3.07

This covers all the posts here directly related to the frame analysis spreadsheets.  There are also many related posts covering analysis of continuous beams, and on-going work on linking the frame analysis spreadsheets to Python based solver routines, and these may be found by selecting Frame Analysis in the Categories drop-down box in the top-right corner.