Tag Archives: VBA

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

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 … 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