Category Archives: Excel

Daily Download 11: Perspective Projection

Posted on 27/09/2012 by dougaj4

The last of the daily downloads dealing with drawing is an extension of the drawing spreadsheet providing 3D perspective projection of wireframes defined by lists of 3D coordinates and connected points.  The spreadsheet was described in:Drawing in Excel 9 – … Continue reading →

Posted in Drawing, Excel, VBA | 1 Comment

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