Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- About Newton Excel Bach
- Using LINEST for non-linear curve fitting
- Downloads
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Contour plots with Excel and Matplotlib
- Daily Download 2: SLS design of reinforced concrete sections ...
- Retrieving unique values from a range or array ...
- Writing Arrays to the worksheet - VBA function
- Beam actions and deflections by Macaulay's Method
Recent Comments

Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Installing Adobe Reader non-DC… 
Z on Downloads 
Z on Daily Download 8: Drawing in… py_ConBeamU and Stra… on py_ConBeamU and Strand7 check… 
dougaj4 on Daily Download 8: Drawing in… 
Z on Daily Download 8: Drawing in…
Category Archives: Finite Element Analysis
Beam geometric non-linear effects – Python version
In 2018 I posted Beam geometric non-linear effects with a VBA based spreadsheet to calculate beam actions and deflections under combined transverse and axial load, allowing for geometric non-linear effects. I have now converted the code to Python, linking to Excel … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged Excel, Frame Analysis, Non-linear geometry, Python, PyXLL, Second order effects, UDFs
1 Comment
Continuous beam analysis from first principles
This post was prompted by an Eng-Tips question: Statically Indeterminant Beam Problem, asking for reactions due to a triangular distributed load on the middle span of a continuous beam with 3 equal simply supported spans. This could be simply solved … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, py_Conbeamu, Slope-deflection method
3 Comments
py_Conbeam – 5
… or perhaps one more. Following the previous post I have modified the py_BeamAct3D function to fix some problems with the non-linear analysis. The latest version, together with an additional spreadsheet comparing results with Strand7, can be downloaded from: py_ConBeamU.zip … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs
Tagged beam analysis, Cantilever beams, continuous beams, Excel, Python, PyXLL, py_BeamAct3D, py_Conbeam, Strand7, UDFs
Leave a comment
py_Conbeam – 4
The last post in the current series compares results from the py_Conbeam function with beam analysis results from the Strand7 FEA software. There have been further significant changes to the Python code and the spreadsheet, so please download the latest … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged beam analysis, Cantilever beams, continuous beams, Deflection due to shear, Excel, Python, PyXLL, py_Conbeam, Strand7, UDFs
1 Comment
py_Conbeam – 3
Continuing from the previous post, we will move on to the py_Conbeam and py_MovLoad functions, that combine with the previous functions to analyse continuous beams with any number of spans and section types, under static or moving loads. As before, there … Continue reading