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
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- Linking Excel to C - 2
- Daily Download 5: Frame Analysis
- Finding Prime Numbers with Excel, and using Array Formulas
Recent Comments
Author Archives: dougaj4
Python Code Updates – py_UMom
Further to the previous post the py_UMom spreadsheet has now been updated for the latest Python and Numpy versions. The latest version can be downloaded from: py_UMom.zip In addition to the Python code changes, the example of the OptShearCap3600 function … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Design for Shear, Excel, longitudinal force due to shear, Python, PyXLL, py_UMom, RC Design Functions, Reinforced Concrete, UDF
1 Comment
Python code updates – 3DFrame-py
Recent changes to how Python treats comparing a Numpy array to an empty list have resulted in some of my functions returning errors and I am in the process of updating them. Specifically, when an optional argument to a function … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged 3DFrame-py, Excel, Frame Analysis, Numba, Numpy, PyPardiso, Python, PyXLL, SciPy.
2 Comments
SectionProperties Release 3
Robbie van Leeuwen’s SectionProperties program, (last featured here) has recently been updated to Release 3 with some major changes to the code, including: Full documentation can be found at: SectionProperties docs Changes to the code have required updates to my Excel … Continue reading
Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged Excel, Python, PyXLL, sectionproperties
Leave a comment
Happy Birthday, Sydney Opera House
The book “Developments in Structural Form” by Rowland Mainstone is a history of the development of structural design over thousands of years. The very first 20th Century building structure appearing in that book is the Sydney Opera House, which was … Continue reading
Posted in Arch structures, Bach, Concrete, Newton
Tagged 50th Anniversary, Peter Thompson, Sydney Opera House, Tim Minchin
Leave a comment
Longitudinal force due to shear – update
In the post RC Design Functions 9.03; compression strut angle adjustment I recommended that when finding the longitudinal force due to shear according to AS 5100.5 (Amendment 1), the effect of increased vertical shear reinforcement should be limited in accordance … Continue reading
Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs, VBA
Tagged Concrete, Design for Shear, Excel, longitudinal force due to shear, Python, PyXLL, py_UMom, RC Design Functions, VBA
1 Comment