Tag Archives: Excel

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

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