Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- ULS Design Functions 2.13
- Continuous Beams With Spring Supports by Macaulay’s Method
- About Newton Excel Bach
- Buckling of columns with varying cross section
- Intersections, interpolations, and rotations
- Downloads
- Fitting high order polynomials
Recent Comments
Category Archives: Frame Analysis
py_ConBeamU and Strand7 check updates
Following the previous post, I have updated the py_ConBeamU spreadsheet, and the associated check against Strand7 results. The new files can be downloaded from: py_ConBeamU.zip The download file now includes: For more details of the spreadsheet and included functions see … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged beam analysis, Excel, Fixed-end moments, Python, PyXLL, py_Conbeamu, Restrained End Moments, UDFs
Leave a comment
ConBeamU and Strand7 check update
Results of the continuous beam spreadsheet were last checked against Strand7 results 10 years ago. I have now updated this check with the latest version (4.19), which can be downloaded from: ConBeamU.zip The download file now includes: The Strand7 check … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Excel Solver, Maximum deflection, Maximum moment, Strand7 check, UDFs, Units, VBA, Working with units.
1 Comment
3DFrame-py rel. 0.50
Following the recent post on the Python lru_cache function (Python functools and the Fibonacci Sequence) I have had a look at using lru_cache in the 3DFrame-py spreadsheet. So far using lru_cache in this code has provided little to no speed improvement, … Continue reading
Posted in Beam Bending, Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged 3D plots, Excel, Frame Analysis, MatPlotlib, Numba, PyPardiso, Python, PyXLL
Leave a comment
3DFrame-NLGeom
The VBA version of the 3DFrame spreadsheet has now been updated to allow geometric non-linear effects to be included. The new version can be downloaded from: 3DFrame.zip For more details of the VBA 3DFrame see 3DFrame update, and for the … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA
Tagged 3D frame analysis, Excel, Geometric non-linearity, non-linear analysis, Strand7, VBA
3 Comments
3DFrame-py-comb
The 3DFrame-py spreadsheet has now been updated with provisions for saving multiple load cases and the associated results, and analysis with factored combinations of multiple load cases. The new files can be downloaded from: 3DFrame-py.zip See Installing 3DFrame-py for installation details, and … Continue reading