Musical Interlude – John Martyn and Danny Thopmpson

Posted on 26/09/2012 by dougaj4

This clip was published on YouTube in June of this year and had just 300 views so far.

From Series 1 of the “Transatlantic Sessions” recorded in 1995: http://en.wikipedia.org/wiki/Transatlantic_Sessions

Posted in Bach | Tagged , , , | Leave a comment

Daily Download 9: Animation in Excel

Posted on 25/09/2012 by dougaj4

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

Posted in Animation, Excel, Javascript, VBA | Tagged , , | 9 Comments

Daily Download 8: Drawing in Excel

Posted on 24/09/2012 by dougaj4

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

Posted in Drawing, Excel, VBA | Tagged , , , | 5 Comments

Daily Download 7: Lateraly loaded pile analysis

Posted on 23/09/2012 by dougaj4

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

Posted in Beam Bending, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , , | 3 Comments

Daily Download 6: Working with FEA programs

Posted on 22/09/2012 by dougaj4

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

Posted in Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | Leave a comment