Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Alternative iterative solvers
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Latex Maths Text in Excel
- Beam actions and deflections by Macaulay's Method
- Retrieving unique values from a range or array ...
- Reinforced Concrete Moment-Curvature - 1
- Frame Analysis with Excel
- Biaxial bending update
- ConBeamU Update
Recent Comments
Category Archives: Newton
ConbeamU update
I recently discovered that the continuous beam function from the ConbeamU spreadsheet was giving incorrect results for cantilevers at the left hand end, if the cantilever had more than one segment and no point loads. The corrected version (Rel 4.16) … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, Fixed End Moments, moving load, Restrained End Moments, Strand7, UDF, VBA
4 Comments
More on Numba
Following my recent post Making Finite Element Analysis go faster … I have been having a closer look at the options in the Numba just-in-time compiler for improving the performance of Python code. The Numba docs include a series of short … Continue reading
Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Faster python code, Numba, Numpy, Python, PyXLL, UDFs
Leave a comment
Concrete 2021
Edit 12th August: Extended early-bird registrations are now finally closing tomorrow, Friday 13th August! Concrete 2021 (the 30th Biennial Conference of the Concrete Institute of Australia) is just around the corner, and this year will be all on-line: The virtual … Continue reading
Posted in Concrete, Newton
Tagged Concrete 2021, Concrete Institute of Australia, On-line conference
Leave a comment
A Numpy trap – correction
In my post of 30th May this year (here) I said that: As a check that the functions were working correctly, the Python functions were modified to return the sum of the largest array in the first row, revealing that … Continue reading
Posted in Arrays, Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs
Tagged arange data limit, int32, int64, Numpy, Numpy bug, Python
Leave a comment
ULS Design Functions 2.13
Update 17 May 2022: Following discussion on 10-11 May 22 the download file has been updated to version 2.15, fixing problems with the interaction diagram with a rectangular stress block under high axial loads. I have uploaded another update to … Continue reading
Posted in Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, Excel, Newton, non-rectangular concrete sections, Parabolic stress block, UDF, ULS design of concrete, VBA
25 Comments