Daily Download 5: Frame Analysis

Leading on from yesterday’s continuous beam functions, today’s download covers four frame analysis spreadsheets, with increasing levels of complexity.  For those interested in the workings of the program I recommend working through each spreadsheet, but for practical applications the final two versions (Frame4.xlsb and 3DFrame.xlsb) provides the best functionality.

The spreadsheets may be downloaded from:


For instructions on linking to the compiled solver routines (provided with Frame4 and 3DFrame) see:
If you are using 64 bit Windows first see:
For 32 bit Windows go straight to:

The last blog posts on Frame4.xlsb are: Extending Frame4 with on sheet formulas, and Using Frame4 for truss analysis.
The latest on 3DFrame.xlsb are: 3DFrame – 3D Frame analysis for Excel and 3DFrame v1.01

Beam results from Beam4.xls

Deflected shape plot

Bending moment results for selected beams

This entry was posted in Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA and tagged , , , . Bookmark the permalink.

6 Responses to Daily Download 5: Frame Analysis

  1. Achille says:

    Dear Sir,
    I have downloaded Fram4.zip.
    It does not work, or better I cannot make it work as, I honestly admit, I do not know what to do or where to copy the 2 dll and the 1 tlb files.
    I understand that those files are necessary to make it work, but I am not very clever in VBA or MACRO and therefore I kindly ask you how to solve my problem.
    Thanks (and congratulations for your work with excel),


  2. napster says:

    Dear Sir,

    I was hoping if you could help me out with my problem. Do you have any reference regarding partial end releases for beams that i can use for my thesis please. For instance. node1 of a beam will be released by 10% in the mx or 90% release in the dz displacement? I believe, that the beam releases on the frame spreadsheets given above are 100%. which means that the released ends are transferred to another extra node.

    Thanks in advance



  3. Pingback: 2D non-linear FEA 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