Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Using Goal Seek on Multiple Cells
- Fitting high order polynomials
- SectionProperties update
Recent Comments
Tag Archives: UDF
Rounding to significant figures
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 Excel, Python, PyXLL, Round, Significant figures, UDF, VBA
7 Comments
ConbeamU update
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 ConBeamU, continuous beam analysis, Excel, Fixed End Moments, moving load, Restrained End Moments, Strand7, UDF, VBA
4 Comments
On long and short formulas and VBA
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 Creating a VBA module, Declaring integers, Excel, Extracting text, UDF, VBA
Leave a comment
ULS Design Functions 2.13
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 AS 3600, AS 5100, Excel, Newton, non-rectangular concrete sections, Parabolic stress block, UDF, ULS design of concrete, VBA
23 Comments
ULS Design Functions update
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 AS 3600, Eurocode 2, Excel, Non-rectangular sections, Reinforced Concrete, Section Analysis, UDF, VBA
13 Comments