Tag Archives: PyXLL

Downloads update

Posted on March 19, 2023 by dougaj4

A list of files available for free download can be found under the Downloads link at the top of the page: The list has now been updated and there are now 189 files available for download, most with open source … Continue reading →

Posted in Computing - general, Excel | Tagged , , , , , , | Leave a comment

A not so easy problem

Posted on March 12, 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 December 15, 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 November 27, 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

Linking to Python help from Excel

Posted on November 6, 2022 by dougaj4

The py_Numpy spreadsheet presented in the previous post has been updated: The new version can be downloaded from: py_Numpy.zip As before, the pyxll add-in is required for the connection from Excel to Python. All the available functions are listed on … Continue reading →

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