Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Downloads by category
- Latex Maths Text in Excel
- Deflections and Moments in Rectangular Plates
- The history of the theory of beam bending - Part 1
- Retrieving unique values from a range or array ...
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads
Recent Comments
Tag Archives: UDF
RC Design Functions 9.02; DevLength function
The RC Design Functions spreadsheet has now been updated to Version 9.02, and is available for free download from: RC Design Functions9.zip Changes in the new version include: The new DevLength function returns reinforcement development length to AS 3600, AS … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged array functions, AS 3600, AS 5100, BS 5400, Devlength, Eurocode 2, Excel, RC Design Functions, UDF, UMom, VBA
Leave a comment
RC Design Functions 9.01; Shear for Eurocode 2 and BS 5400
The RC Design Functions spreadsheet has now been updated to Version 9.01, and is available for free download from: RC Design Functions9.zip The UMomPF function returns ultimate bending and axial load capacity to the Eurocode 2 and BS 5400 design … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged BS 5400, Eurocode 2, Excel, RC Design Functions, shear capacity, UDF, UMomPF, VBA
Leave a comment
RC Design Functions 9.0
The RC Design Functions 9.0 spreadsheet is now available for free download from: RC Design Functions9.zip The main change is update of shear capacity calculations for the latest versions of the Australian codes; AS 3600 and AS 5100. Shear data … Continue reading
Posted in Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100.5, Combined Shear and Torsion, Excel, Reinforced Design Functions, shear capacity, UDF, UMom, VBA
Leave a comment
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