Tag Archives: Python

Solving non-linear equations with two or more unknowns – 5

Posted on 20/10/2015 by dougaj4

This will be the last of the series on solving non-linear equations (for now).  Up until now all the examples have had two unknown values, and two target values.  This can be extended by making three changes to the code: … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , , , , , , | 3 Comments

IP2 and IP2_py

Posted on 11/09/2015 by dougaj4

The IP2 spreadsheet provides functions to calculate: Intersection points of 2D lines or polylines Intersection points of 2 circles, or a line and a circle Intersection circle of two spheres and intersection points of 3 spheres 3D centre point of … Continue reading →

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , , | 5 Comments

A mystery curve links to Jupyter

Posted on 16/07/2015 by dougaj4

Reviewing some of my less visited links recently, I was intrigued by a post at The Math Less Travelled: The previous post at the site provides more details of the source of the curve, and some links to an interactive … Continue reading →

Posted in Charts, Charts, Excel, Maths, Newton | Tagged , , , , , , | 2 Comments

Conbeam – Python version

Posted on 24/06/2015 by dougaj4

I have converted the continuous beam analysis spreadsheet (last presented here) to Python code, linked to Excel VBA User Defined Functions (UDFs) with ExcelPython.  To run the Python version you will need an installed copy of Python, including Numpy and … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Reversing Bob

Posted on 31/05/2015 by dougaj4

Following our look at Weird Al Jankovic’s palindromic song, Bob, I have written two short VBA User Defined Functions (UDFs) to help writing palindromes (and possibly with other tasks as well). Reverse() will, as the name suggests, reverse any text entered as … Continue reading →

Posted in Excel, Link to Python, UDFs, VBA | Tagged , , , , , | Leave a comment