Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Deflections and Moments in Rectangular Plates
- Writing Arrays to the worksheet - VBA function
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 4: Continuous Beam Analysis
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
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…
Tag Archives: beam analysis
py_ConBeam – 2
Continuing from the previous post, today I will be looking at the Macaulay function, that performs the underlying analysis, and the application of this function to cantilevers and single span beams. There have been some significant changes to the Python … Continue reading
py_ConBeamU
I have now converted the VBA code in the ConBeamU spreadsheet to Python, connected to Excel via pyxll. The new spreadsheet and associated Python code can be downloaded from: py_ConBeamU.zip In addition to the provided files, the pyxll application is … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged beam analysis, Excel, Fixed-end moments, Python, PyXLL, py_Conbeamu, Restrained End Moments, UDFs
4 Comments
Beam actions and deflections, 3D or 2D
Two new functions have been added to the ConBeamU spreadsheet, last discussed here. The new version can be downloaded from ConBeamU.zip, including full open-source code. The new functions, BeamAct3D and BeamAct2D calculate forces, moments, deflections and rotations along a 3D … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged 2D beam, 3D beam, beam analysis, BeamAct functions, Excel, UDF, VBA
2 Comments
Update to Beam1 and Beam2
It has just been pointed out that the single span beam spreadsheet presented at Frame Analysis with Excel 1 does not work for a propped cantilever. The same applies to the spreadsheet for single span sloping beams at Frame Analysis with … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton
Tagged beam analysis, Excel, Frame Analysis
3 Comments