Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Linking Excel to C - 2
- Daily Download 4: Continuous Beam Analysis
- Writing Arrays to the worksheet - VBA function
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC…
Category Archives: Strand7
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
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
SectionProperties update
In late 2017 I posted Section Properties with MeshPY, including torsion and warping which looked at an Excel front end for Robbie van Leeuwen’s SectionProperties program, which provides facilities for calculation of section properties of complex shapes, including torsion and warping constants. … Continue reading
Posted in Charts, Excel, Finite Element Analysis, Link to Python, Newton, Numerical integration, NumPy and SciPy, PyXLL, Strand7
Tagged Excel, Python, PyXLL, Section-Properties, Torsion
1 Comment
Contour plots with Excel and Matplotlib – 2
The procedures discussed in the previous post required the contour data to be arranged on a regular rectangular grid, with the data points listed in a 2D array. As far as I know there is no built in alternative in … Continue reading
Posted in Arrays, Charts, Excel, Finite Element Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged Contour plots, Excel, MatPlotlib, Python, PyXLL
1 Comment
Contour plots with Excel and Matplotlib
Contour plots are widely used for a great variety of purposes, but facilities for producing them in Excel are very limited, and those that are provided are very well hidden. In this post I will look at some simple examples … Continue reading
Posted in Arrays, Charts, Charts, Excel, Finite Element Analysis, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged Contour plots, Excel, MatPlotlib, Python, PyXLL, UDFs
1 Comment