Category Archives: UDFs

ConBeamU update

Posted on 20/09/2025 by dougaj4

Following a comment at https://newtonexcelbach.com/2023/01/20/using-conbeamu/ I have updated the ConBeamU-Template file so that the function to select the input range works the same as in the main spreadsheet. For more details of how the spreadsheet works, see the link above, … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Long integers in Python and Excel and py_Fact

Posted on 27/08/2025 by dougaj4

I have added a new py_Fact function to the py_Scipy module, that returns the factorial of an integer as a float if it is up to 15 digits long, or a string for longer numbers. The revised code, and the … Continue reading →

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

Evaluate and display definite integrals in Excel with Latex and Matplotlib

Posted on 09/08/2025 by dougaj4

The py_Evalu spreadsheet was last presented at Scipy Functions with Excel and pyxll 5 – Evaluate with Units and included the Plot_Math function, which converts a text string to Latex format, then uses Matplotlib to convert this to a graphic image, … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, Numerical integration, PyXLL, UDFs | Tagged , , , , , , , , , , , , | Leave a comment

py_RC Elastic 1.04 and fatigue to AS 3600

Posted on 06/08/2025 by dougaj4

The py_RC Elastic spreadsheet (last discussed here) has been updated with a new function py_Fatigue3600, providing design for fatigue to the latest AS 3600 concrete structures code. The new spreadsheet and associated Python code can be downloaded from: py_RC Elastic.zip … Continue reading →

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

Importing text files with Python and pyxll

Posted on 02/08/2025 by dougaj4

VBA code to import text files to Excel was presented at Importing text files with VBA – 2 and following posts. We now look at Python code for a user defined function (UDF) for the same task. The code requires Python … Continue reading →

Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , | Leave a comment