Category Archives: Maths

VBA procedures for the Numerical Analysis of Tabular Functions

Posted on 12/03/2022 by dougaj4

Long time on-line friend Alfred Vachris has recently been converting Fortran code developed through his working career into VBA: I had the opportunity to work at Grumman while going to Graduate School and they gave me a part-time job as … Continue reading →

Posted in Coordinate Geometry, Curve fitting, Excel, Fortran, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment

Display Matplotlib animations in Excel

Posted on 28/02/2022 by dougaj4

The latest version of pyxll (5.4.0) allows animations generated in Matplotlib to be simply copied to Excel. A spreadsheet with the examples shown below, and the associated Python code can be downloaded from: Animations2.zip The screenshot below shows the simple … Continue reading →

Posted in Animation, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | 3 Comments

Rounding to significant figures

Posted on 17/02/2022 by dougaj4

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 , , , , , , | 7 Comments

SectionProperties update 3

Posted on 09/02/2022 by dougaj4

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 , , , , , | 3 Comments

Plotting Mandelbrot in Excel with Matplotlib

Posted on 17/12/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 , , , , , , , | 1 Comment