Tag Archives: UDF

Rounding to significant figures

Posted on February 17, 2022 by dougaj4

Edited 19th Feb 22, following comment from Larry Schuster Excel does not have a function to round numbers to a specified number of significant numbers, and (rather to my surprise) neither does Python. It is not too hard to write … Continue reading →

Posted in Excel, Link to Python, Maths, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , | 7 Comments

ConbeamU update

Posted on September 28, 2021 by dougaj4

I recently discovered that the continuous beam function from the ConbeamU spreadsheet was giving incorrect results for cantilevers at the left hand end, if the cantilever had more than one segment and no point loads. The corrected version (Rel 4.16) … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , , , | 4 Comments

On long and short formulas and VBA

Posted on July 17, 2021 by dougaj4

A recent thread at Eng-Tips asked the following apparently simple question: Starting with a string consisting of numbers with a single central group of letters, how can this string be truncated at the end of the letters, so that for … Continue reading →

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

ULS Design Functions 2.13

Posted on July 11, 2021 by dougaj4

Update 17 May 2022: Following discussion on 10-11 May 22 the download file has been updated to version 2.15, fixing problems with the interaction diagram with a rectangular stress block under high axial loads. I have uploaded another update to … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 23 Comments

ULS Design Functions update

Posted on May 23, 2021 by dougaj4

The ULS Design Functions spreadsheet has been updated with further changes related to the new Australian Standard for concrete structures; AS 3600-2018, and with some other fixes.  The new version can be downloaded from: ULS Design Functions.zip The changes in … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 13 Comments