Category Archives: UDFs

Daily Download 10: Excel Digitiser

Posted on 26/09/2012 by dougaj4

See How to digitise a scanned image and Digitising logarithmic scales.  This spreadsheet provides a function to retrieve coordinates of lines traced over a scanned image. Download from: http://interactiveds.com.au/software/DigitGraph.zip Example images:

Posted in Drawing, Excel, Newton, UDFs, VBA | Tagged , , , , | Leave a comment

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 … Continue reading →

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 … Continue reading →

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

Daily Download 5: Frame Analysis

Posted on 21/09/2012 by dougaj4

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 … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , | 12 Comments

Daily Download 4: Continuous Beam Analysis

Posted on 20/09/2012 by dougaj4

Today’s download files contain several alternative functions for analysing continuous beams. The most flexible is the ConBeamU spreadsheet, which in addition to the continuous beam function also contains functions for single span beams and cantilevers, and for fixed end moments and … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , | 15 Comments