Tag Archives: UDFs

Python functions for rotation

Posted on 22/08/2025 by dougaj4

I have recently needed code to rotate 2D coordinates, either about the origin, or some specified other point, using pyxll to call the code from Excel. My first attempt was a direct translation of some VBA code, that also worked … Continue reading →

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, PyXLL | 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

Random numbers, palindromes and Numpy update

Posted on 09/06/2025 by dougaj4

This post looks at some of the options for generating random numbers in Excel and Python. The code and example spreadsheets can be downloaded from: Updated Numpy files at: py_SciPy.zipCode added to the Pandigital files at: Pandigitals.zip The py_SciPy download … Continue reading →

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