Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Retrieving unique values from a range or array ...
- Latex Maths Text in Excel
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Automatic download of csv files
- Cubic Splines
- Contour plots with Excel and Matplotlib
- 3D Matplotlib Plots in Excel
- Downloads by category
Recent Comments
Category Archives: Concrete
More on combined shear and bending design to AS 3600
Further to the last post on this subject I have been looking at procedures to speed up design for shear to AS 3600 when the “refined” analysis procedure is used. The issues that need to be addressed are: I have … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Brents method, Combined shear and bending, Excel, Longitudinal shear force, Python, PyXLL, SciPy, shear capacity, UDFs
4 Comments
RC Design Functions 9.03; compression strut angle adjustment
The RC Design Functions spreadsheet has now been updated to Version 9.03, and is available for free download from: RC Design Functions9.zip The new version includes a number of corrections to the calculation of beam shear and torsion capacity to … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100.5, Compression block angle, Design for Shear, Excel, Longitudinal shear force, Reinforced Concrete Design Functions, UDFs, VBA
2 Comments
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