Author Archives: dougaj4

SectionProperties update

Posted on January 16, 2022 by dougaj4

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 , , , , | Leave a comment

Contour plots with Excel and Matplotlib – 2 

Posted on December 30, 2021 by dougaj4

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 , , , , | Leave a comment

Contour plots with Excel and Matplotlib

Posted on December 28, 2021 by dougaj4

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 , , , , , | Leave a comment

Plotting Mandelbrot in Excel with Matplotlib

Posted on December 17, 2021 by dougaj4

The functions used in the previous post generate an array of integers, the number of iterations for the function return value to exceed 2. This post looks in more detail at how this data can be plotted in Excel using … Continue reading →

Posted in Charts, Charts, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | Leave a comment

Computing and plotting the Mandelbrot set in Excel …

Posted on December 7, 2021 by dougaj4

… with Python, Numba and pyxll. As promised in the previous post, this post will look at alternative procedures for calculating and plotting the Mandelbrot set with Python based code. The spreadsheet presented here and the associated Python code may … Continue reading →

Posted in Charts, Charts, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | Leave a comment