Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Frame Analysis with Excel - 3, Continuous beam or frame
- Downloads
- Writing Arrays to the worksheet - VBA function
- Using Linest for non-linear curve fitting, examples, hints and warnings
Recent Comments
Author Archives: dougaj4
Danny Thompson by The Music Aficionado
I just discovered The Music Aficionado site, where Parts 1 and 2 of a series on the life and times of Danny Thompson have recently been posted: I have been toying with the idea of writing an article about Danny … Continue reading
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
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