The missing post from yesterday’s list was: Drawing in Excel – 2 , with download file:
http://www.interactiveds.com.au/software/animate.zip
Other animation related posts include:
By Jingo
Dancing Pendulums
Yet more pendulums
Rotating Hypercubes
Animated Pythagoras
Today’s download includes all download files and posts relating to drawing in Excel, other than those dealing with animation, digitising, or 3D perspective projection, which will be covered in the next three days.
Blog posts dealing with drawing in Excel:
Associated download files are:
A random selection of images from the listed posts are shown below:
Shape List
Getting shape properties
Drawing from coordinates
Bat skull image created in Excel from FEA data
Scaled and trimmed bridge beam
Today’s downloads (the last in the Engineering category) are related to the analysis of piles subject to lateral loads:
LatPile – Analysis of Lateral Loads on Piles describes the principles of the analysis.
Download file: http://interactiveds.com.au/software/LatPile.zip
P-Y Curve function describes function to return non-linear “P-Y” curves, describing soil load-deflection behaviour, based on the manual for the program COM-624.
Download file: http://interactiveds.com.au/software/PY-COM624.zip
Beam on Elastic Foundations Analysis describes a more refined analysis of members with soil support, that can be used for both laterally loaded piles and beams on elastic foundations.
Download file: http://interactiveds.com.au/software/LatPileB.zip
The latest version of the LatPilePY spreadsheet is described at: LatPilePY 1.04
Download file: http://interactiveds.com.au/software/LatPilePY.zip
PY Curve function output
LatPileB input and output
Latest version compared with COM624 program output
Today’s downloads are three programs for working with Finite Element Analysis (FEA) programs. The first use the Scripting Dictionary Object to count the number of different element types (beams, plates, bricks and links) and the number of node restraints at each end of listed beams from a finite element model. For more details see:
Working with FEM data and using the dictionary object
Download a spreadsheet including UDF with open-source code from:
http://interactiveds.com.au/software/BeamEnds.xls
The other two files are for use with the Strand7 FEA program:
Using the Strand7 API and Strand7 API GetNode functions
The associated download files are:
http://www.interactiveds.com.au/software/S7%20API%20Tools3.zip
http://www.interactiveds.com.au/software/Getnode.zip
BeamEndA Function
S7API-Tools Functions
GetNode Function
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:
http://interactiveds.com.au/software/Frame1.zip
http://interactiveds.com.au/software/Frame2.zip
http://interactiveds.com.au/software/Frame3.zip
http://interactiveds.com.au/software/Frame4.zip
http://interactiveds.com.au/software/3DFrame.zip
For instructions on linking to the compiled solver routines (provided with Frame4 and 3DFrame) see:
If you are using 64 bit Windows first see:
https://newtonexcelbach.wordpress.com/2013/03/28/installing-dlls-on-64-bit-windows/
For 32 bit Windows go straight to:
https://newtonexcelbach.wordpress.com/2012/11/13/using-regasm-exe/
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
Newton Excel Bach, not (just) an Excel Blog 