Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Latex Maths Text in Excel
- Beam actions and deflections by Macaulay's Method
- Frame Analysis with Excel
- ConBeamU Update
- Reinforced Concrete Moment-Curvature - 1
- Retrieving unique values from a range or array ...
- Unit aware continuous beam spreadsheet update
- Frame Analysis with Excel – 7; Shear deflections and support displacements
Recent Comments
Category Archives: Newton
Rounding to significant figures
Edited 19th Feb 22, following comment from Larry Schuster Excel does not have a function to round numbers to a specified number of significant numbers, and (rather to my surprise) neither does Python. It is not too hard to write … Continue reading
Posted in Excel, Link to Python, Maths, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, Python, PyXLL, Round, Significant figures, UDF, VBA
7 Comments
SectionProperties update 3
The SectionProperties spreadsheets previously posted had limited graphics capabilities due to problems with the plotting routines causing Excel to crash. I have now fixed that problem by updating some Python libraries with pip: installing mkl-service numpy 1.21.2 -> 1.22.1 Pillow … Continue reading
Posted in Beam Bending, Charts, Charts, Coordinate Geometry, Excel, Finite Element Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL
Tagged Excel, Python, PyXLL, Section-Properties, Torsion, Warping
3 Comments
SectionProperties update update
Since my previous post on the Python SectionProperties program it has been updated to Rel. 2.02, with some major changes: The mesh generation library has been changed from MeshPY to Triangle New functions have been added for: Steel sections Concrete … Continue reading
Posted in Concrete, Excel, Finite Element Analysis, Link to Python, Newton, PyXLL, Strand7
Tagged Excel, Python, PyXLL, Section-Properties, Torsion
2 Comments
Embedding OneDrive in WordPress
Every time I try to add a new link to a file on OneDrive in WordPress, it seems they have changed the system to stop it working. After much trial and error, the procedure given below works, for now. Open … Continue reading
Publications
I have recently updated my list of publications. Click on the “view full-size” icon in the bottom right corner for a full screen view, or click any link to download.
Posted in Concrete, Geotechnical Engineering, Newton, Strand7
Tagged Austroads Bridge Conference, Concrete Conference, Publications
4 Comments