Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- XLDennis, the MSDN Library, and VBA rant
- Cubic Splines
- Daily Download 4: Continuous Beam Analysis
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Daily Download 5: Frame Analysis
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- About Newton Excel Bach
- Downloads
Recent Comments
Category Archives: Beam Bending
Daily Download 22: Splines and Curves
Since it was first published in 2009 my CSpline function has been the most popular download from this site. CSpline (and various associated functions) is used to fit a series of cubic curves through specified points, allowing interpolation along a smooth … Continue reading
Posted in AlgLib, Beam Bending, Charts, Charts, Coordinate Geometry, Excel, Newton, Numerical integration, UDFs, VBA
Tagged Cardinal spline, catenary curve, Cubic spline, curve fitting, Excel, Hermite Spline, Interpolation, UDF, VBA
7 Comments
Daily Download 21: Assorted Solvers
Today’s download starts with some simple linear interpolation methods used to solve polynomial equations, leading on to more sophisticated methods using quadratic or inverse quadratic interpolation. Also included is a solver for differential equations using the Cash-Karp Method, which is … Continue reading
Daily Download 7: Lateraly loaded pile analysis
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 Beam on elastic foundations, COM624, Excel, laterally loaded piles, PY curves, UDF, VBA
3 Comments
Daily Download 5: Frame Analysis
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 Excel, Frame Analysis, UDF, VBA
12 Comments
Daily Download 4: Continuous Beam Analysis
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 continuous beams, Cubic splines, Excel, Macaulay's Method, UDF, VBA
15 Comments