Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- Downloads
- About Newton Excel Bach
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Daily Download 2: SLS design of reinforced concrete sections ...
- Daily Download 3: ULS design of reinforced concrete sections
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Frame Analysis with Excel – 7; Shear deflections and support displacements
Recent Comments
Category Archives: Newton
Making Finite Element Analysis go faster …
… with Numba and Scipy sparse matrix functions. As promised in the previous post in this series, I will be looking at speeding up the formation and solving of matrix functions for the analysis of structural frames, using Excel and … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, NumPy and SciPy, PyXLL
Tagged Excel, Finite Element Analysis, Iterative solvers, Numba, Numpy, Python, PyXLL, SciPy, sparse matrices
4 Comments
A Very Short Article
I have previously written of Boris Peon’s very short proof that Hinchcliffe’s Rule is true (but only if it is false): Is Hinchliffe’s Rule True? … I have now been told of an even shorter scientific paper, which can be found … Continue reading
Using Numba with Excel and pyxll …
… and a Numpy trap. I last looked at using the just-in-time compiler Numba with Python some time ago (Two Timers), but I was prompted to take another look by an article in Medium that claimed Python Can Be Faster … Continue reading
Posted in Arrays, Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, Just-in-time, Numba, Numpy, Numpy bug, Python, timers, VBA
2 Comments
ULS Design Functions update
The ULS Design Functions spreadsheet has been updated with further changes related to the new Australian Standard for concrete structures; AS 3600-2018, and with some other fixes. The new version can be downloaded from: ULS Design Functions.zip The changes in … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, Eurocode 2, Excel, Non-rectangular sections, Reinforced Concrete, Section Analysis, UDF, VBA
13 Comments
3D Frame Update
Following a comment here I have updated the code for the 3DFrame spreadsheet to calculate shear deflections correctly for sections with a different shear area for each transverse principal axis. The updated files can be downloaded from: 3DFrame.zip A note … Continue reading
Posted in Excel, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged 3DFrame, Excel, section property definitions, Shear area, shear deflections, VBA
2 Comments