Category Archives: PyXLL

More long numbers with Python

Posted on 08/04/2023 by dougaj4

In A not so easy problem I looked at using Python with Excel (via pyxll) to work with very long integers, using the MPMath package. For high precision calculations involving decimal values MPMath is required, but for simple operations entirely … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, PyXLL, UDFs | Tagged , , , , , | 1 Comment

ULS Design Functions – Python version

Posted on 02/04/2023 by dougaj4

I have now converted my ULS Design Functions spreadsheet (last presented here) to Python. The new spreadsheet and open source Python code can be downloaded from: py_ULS Design Functions The spreadsheet has the same functionality as the VBA version, providing … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , , , , , , | 3 Comments

A not so easy problem

Posted on 12/03/2023 by dougaj4

A seemingly simple problem was posted in my Quora feed: or to put it more mathematically, what three positive integers satisfy the equation: It turns out the answer is not so simple. A full and detailed derivation can be found … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, PyXLL, UDFs | Tagged , , , , | 1 Comment

More on combined shear and bending design to AS 3600

Posted on 15/12/2022 by dougaj4

Further to the last post on this subject I have been looking at procedures to speed up design for shear to AS 3600 when the “refined” analysis procedure is used. The issues that need to be addressed are: I have … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , | 4 Comments

Latex Maths Text in Excel

Posted on 27/11/2022 by dougaj4

There have been many posts here looking at alternative ways of working with functions entered as text on a spreadsheet, and working with units, most recently here. One drawback with this approach is that text in an Excel cell must … Continue reading →

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