Tag Archives: Excel

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

Daily Download 3: ULS design of reinforced concrete sections

Posted on 19/09/2012 by dougaj4

Today’s downloads provide a spreadsheet providing Ultimate Limit State (ULS) analysis of reinforced or prestressed concrete sections, and an iterative method for finding the depth of the Neutral Axis in a circular reinforced concrete section. The ULS analysis spreadsheet is described at: … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 23 Comments