Tag Archives: UDF

py_RC Elastic update 2

Posted on 12/06/2024 by dougaj4

Following the previous post, I have added a further new function, and in the process discovered that the py_Estress function was not handling tensile axial loads correctly. That has now been fixed, and the updated spreadsheet and Python files can … Continue reading →

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

Creating sequential lists in Excel

Posted on 08/05/2024 by dougaj4

I recently discovered that Excel has a new SEQUENCE function that will return a sequence of increasing numbers in a column, row, or 2D range. Use of the new function is shown in the screenshot below, with some old and … Continue reading →

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

Let, Lambda, and py_Eval

Posted on 21/04/2024 by dougaj4

I have covered the new Excel Let and Lambda functions before at: Two New Functions; Let and Lambda Eval and Let examples Lambda and VBA The Lambda function is now available to all Microsoft 365 subscribers, so I have now looked at … Continue reading →

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

Python Code Updates – py_UMom

Posted on 18/11/2023 by dougaj4

Further to the previous post the py_UMom spreadsheet has now been updated for the latest Python and Numpy versions. The latest version can be downloaded from: py_UMom.zip In addition to the Python code changes, the example of the OptShearCap3600 function … Continue reading →

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

Counting words in a list and dictionary links

Posted on 26/09/2023 by dougaj4

This post presents two methods for extracting all the different words from a list and counting the number of occurrences of each word. The spreadsheet, including full open-source VBA code, can be downloaded from: CountWords.zip As an example, I have … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , , | Leave a comment