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
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Automating chart scale limits - update
- Frame Analysis with Excel - 3, Continuous beam or frame
- Downloads
- Writing Arrays to the worksheet - VBA function
Recent Comments
Author Archives: dougaj4
Free resources for earthquake design in Australia
… and other regions with low to moderate seismicity: The SRIA’s free pdf Guide to Seismic design and detailing of Reinforced Concrete Buildings in Australia is available from the link below. It was published in 2016 and was a precursor … Continue reading
Posted in Concrete, Newton
Tagged AEES, AS 1170.4, AS 3600, free publications, Quake-Advice, Seismic design, SRIA
Leave a comment
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
Clearing OneDrive download files in Android
I recently found that downloaded files on OneDrive on my Android pad had almost filled my storage space to capacity, and that the procedure to delete them was not at all obvious. I eventually found a link with detailed instructions … Continue reading
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