Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Cubic Splines
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Drawing in Excel 7 - Creating drawings from coordinates
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Buckling of rings and arches
Recent Comments
Clive James and Pete… on The Barrow Poets dougaj4 on Excel to Alglib via xlwin… Roulior Halder on Excel to Alglib via xlwin… dougaj4 on Excel to Alglib via xlwin… dougaj4 on Excel to Alglib via xlwin… dougaj4 on How to digitise a scanned… Gabriel on How to digitise a scanned… Gabriel on How to digitise a scanned… Gabriel on How to digitise a scanned… Roulior Halder on Excel to Alglib via xlwin… Roulior Halder on Excel to Alglib via xlwin… Angelo on Biaxial bending update dougaj4 on Excel to Alglib via xlwin… dougaj4 on Biaxial bending update Roulior Halder on Excel to Alglib via xlwin…
Category Archives: Beam Bending
Biaxial bending update
The reinforced concrete biaxial bending spreadsheet has now been updated: Stress block and capacity reduction factors updated for AS 3600-2018 ACI factors for US customary units used when stress is entered in ksi or psi units Example data updated The … Continue reading
Posted in Beam Bending, Concrete, Newton
Tagged ACI 318, AS 3600, biaxial bending, Eurocode 2, Excel, Reinforced Concrete, UDFs, ULS Design Functions, VBA
3 Comments
ULS design of circular reinforced concrete columns
The RC Design Functions spreadsheet has been updated (to Version 8.04) with the addition of a CircU function for ULS design of circular reinforced concrete sections under combined bending and axial load. The new version, including full open-source code, may … Continue reading
ULS Design Functions – update for AS 3600
The ULS Design Functions spreadsheet (last posted here) has been updated to the new Australian Standard for concrete structures; AS 3600-2018. The new version can be downloaded from: ULS Design Functions.zip Note that the biaxial version included in the download … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, circular section, Excel, Reinforced Concrete, UDF, ULS Design Functions, VBA
2 Comments
RC Design Functions 8_03
The RC Design Functions 8_03 spreadsheet is now available for free download from: RC Design Functions8.zip The main changes are: The NA layer check has been corrected for compression steel in tension The new AS 3600 crack width and curvature … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, crack width, Curvature, Excel, RC Design Functions, Reinforced Concrete, UDF, VBA
9 Comments
3D Frame with zero stiffness hinges
The previous version of 3DFrame allowed for spring releases at beam ends, but if the release stiffness was entered as zero it was treated as a rigid connection for that freedom. Effectively zero stiffness releases could be modelled by entering … Continue reading
AS 3600 and RC Design Functions 8.01
The updated RC Design Functions spreadsheet (presented here) included an updated UMom function to find the ultimate strength of a rectangular section under combined bending and axial load; but I omitted to include the revisions to the alpha2 and Gamma … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, Excel, Rectangular stress block factors, Reinforced Concrete Design Functions, UDF, ULS design, VBA
Leave a comment
More iterative solvers
Following the recent post on using Brent’s Method solvers on an array (Iterative solvers and arrays), here is another example with an engineering related problem. The example is included in the xlScipy3 spreadsheet, which can be downloaded from: xlScipy3.zip The depth … Continue reading
Posted in Arrays, Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Brents method, depth of neutral axis, Excel, Python, Reinforced Concrete, SciPy, UDFs, VBA, xlwings
Leave a comment