Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Contour plots with Excel and Matplotlib
- Filling Blanks with Go To-Special (and local help rant)
- 3DFrame - 3D Frame analysis for Excel
- Latex Maths Text in Excel
Recent Comments
Category Archives: Beam Bending
Section Properties with MeshPY, including torsion and warping
I recently discovered robbie van leeuwen’s structural engineering blog, which has an open-source set of Python routines for calculation of section properties, including torsion and warping constants. The program uses the MeshPY Library for generating the finite element meshes required … Continue reading
Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Strand7, UDFs, VBA, xlwings
Tagged Excel, MatPlotlib, MeshPY, Python, section properties, Torsion, UDF, VBA, Warping
11 Comments
Composite Beam Spreadsheet Update 1.01
Following a comment here, I have modified the Composite Beam spreadsheet to correct the stage 1 stresses forces in the reinforcement as listed in Columns 6 and 7, when the tensile face is the top. The output has also been … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, Composite beam design, Excel, Prestressed concrete, Reinforced Concrete, UDF, VBA
3 Comments
Stepping through 3DFrame
Following a recent comment this post looks at the code for setting up the stiffness matrix for a 3D frame, and how to step through any selected part of the code. The general procedure for setting up a 3D stiffness matrix, … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged 3DFrame, Debugging UDFs, Debuging VBA, Excel, UDF, VBA
Leave a comment
Setting up UDF Applications
Following a recent comment, this post looks at setting up a user defined function (UDF) on a blank worksheet, using the ConBeamU function as an example. To use a UDF, the VBA code for the function must either be included … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, resize array functions, UDF, VBA
2 Comments
Stress increments in prestressed concrete beams
The two main Australian Standards covering prestressed concrete structures (AS 3600, Concrete Structures, and AS 5100 Part 5, Concrete Bridges) put a limit on the allowable increase in stress in reinforcement and prestressing strands and tendons, when the load increases from … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, Excel, Prestressed Concrete Design, Stress increment, UDF, VBA
2 Comments