Category Archives: Newton

3D Matplotlib Plots in Excel

Posted on 17/04/2022 by dougaj4

As well as Excel, the code shown in this post requires current versions of Python, Numpy, Matplotlib, and pyxll. The required import statements at the head of the Python code are: The spreadsheets and Python code described below may be … Continue reading →

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | 2 Comments

Free and Simple Tools for Editing Videos

Posted on 08/04/2022 by dougaj4

I recently needed to extract 15 minutes from a 45 minute long video, in 5 separate clips. I discovered that there are free tools to do this simply and efficiently, although they are not widely advertised. Here’s how: By default, … Continue reading →

Posted in Bach, Computing - general, Newton | Tagged , , , | 2 Comments

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

Free resources for earthquake design in Australia

Posted on 27/02/2022 by dougaj4

… and other regions with low to moderate seismicity: The SRIA’s free pdf Guide to Seismic design and detailing of Reinforced Concrete Buildings in Australia is available from the link below. It was published in 2016 and was a precursor … Continue reading →

Posted in Concrete, Newton | Tagged , , , , , , | Leave a comment