Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- XLDennis, the MSDN Library, and VBA rant
- Latex Maths Text in Excel
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Filling Blanks with Go To-Special (and local help rant)
- Retrieving unique values from a range or array ...
- Contour plots with Excel and Matplotlib
- Frame Analysis with Excel
- Beam actions and deflections by Macaulay's Method
Recent Comments
Category Archives: Frame Analysis
Continuous Beams With Cantilevers by Macaulay’s Method
Edit 13 Apr 2014: See Continuous Beam Spreadsheet with Moving Load for the latest version, which is now called ConBeamU. I have updated the Macaulay spreadsheet (described here) to allow the analysis of continuous beams with cantilevers at one or … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged Cantilever, continuous beam, Excel, Macauley's Method, UDF, VBA
12 Comments
Continuous Beam Analysis by Macaulay’s Method
The Macaulay spreadsheet now includes a ConBeam() function, analysing continuous beams with any number of segments of different stiffness, subject to any combination of distributed or point loads and moments. The spreadsheet also includes an example, together with output of … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macauley's Method, UDF, VBA
8 Comments
Beam Fixed End Actions by Macaulay’s Method
Following the previous post examples have been added to the Macaulay Spreadsheet illustrating the use of the method to find fixed end moments and reactions for a beam fixed at one or both ends, and subject to any number of … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged Excel, Fixed End Moments, Macauley's Method, UDF, VBA
2 Comments
Beam actions and deflections by Macaulay’s Method
Macaulay’s Method is a convenient method of applying beam slope-deflection equations to find the shear forces, bending moments, slopes and deflections of a structural beam subject to complex load conditions, including partial varying distributed loads and point loads and moments. It … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, Numerical integration, UDFs, VBA
Tagged Excel, Macaulay's Method, simply supported beam, UDF, VBA
15 Comments
Using the Strand7 API
Strand7 is a general purpose Finite Element Analysis program, which has an Application Programming Interface (API), allowing external programs to interact with Strand7, including reading and writing to data files, running analyses, and reading the results. The API is a comprehensive … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged API, Excel, Finite Element Analysis, Strand7, UDF, VBA
7 Comments