### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Cubic Splines
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Problems with UCase and LCase in VBA
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Retrieving unique values from a range or array ...

### Recent Comments

More Numpy with Exce… on Using Array Functions and… More Numpy with Exce… on Sorting with Python and N… Office Insiders and… on JavaScript UDFs in Excel Sorting with Python… on Sorting with VBA and Pyth… Sorting with VBA and… on Dynamic sorting with Excel, VB… Luis on Okenyo dougaj4 on Drawing in Excel 7 – Cre… rva on Drawing in Excel 7 – Cre… dougaj4 on Numerical Integration; Tanh-Si… srabutdotcom on Numerical Integration; Tanh-Si… dougaj4 on Converting from global to loca… Joan Gonzalez on Converting from global to loca… dougaj4 on Beam geometric non-linear… Bob Jordan on Beam geometric non-linear… David Lim on Frame Analysis Resources

# Tag Archives: Reinforced Concrete

## Evaluating text with units and finding the neutral axis

A few weeks ago a comment asked for guidance on finding the moment capacity of a reinforced concrete section. This post will look at finding the depth of the neutral axis (NA) in a rectangular section, with a single layer of … Continue reading

Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged depth of neutral axis, elastic analysis, EvalU, evaluate text strings, evaluate units, Excel, Reinforced Concrete, UDF, ULS analyis, unit aware, VBA
2 Comments

## Composite Beam Spreadsheet Update 1.01

Following a comment here, I have modified the Composite Beam spreadsheet to correct the stage 1 stresses forces in the reinforcement as listed in Columns 6 and 7, when the tensile face is the top. The output has also been … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, Composite beam design, Excel, Prestressed concrete, Reinforced Concrete, UDF, VBA
Leave a comment

## RCInteract and RC Design Functions 7.03

Since the previous post, I have updated the notes in the RC Design Functions spreadsheet to reflect the fact that with the recent update to the Bridge Design Code (AS 5100) the reinforced concrete strength design requirements for beam bending … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged ACI318, AS3600, AS5100, Combined bending and axial load, Eurocode2, Excel, Interaction Diagram, RC Design Functions, Reinforced Concrete, UDF, VBA
16 Comments

## Automating Goal Seek with RC Design Functions

As promised in the previous post, I will now look in more detail at the process for automating the Excel Goal Seek function with the RC Design Functions spreadsheet, to calculate reinforcement area or section depth for a range of bending … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Excel, Goal Seek, Reinforced Concrete, Reinforced Concrete Design Functions, Section capacity, VBA. UDF
10 Comments

## RC Design Functions update

Following a comment here I have updated my RC Design Functions spreadsheet, which is available for free download (including full open-source code) from: RC Design Functions7.zip The main new features in the latest version are: The existing optional “depth” argument has … Continue reading

Posted in Arrays, Beam Bending, Concrete, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged EStress function, Excel, Goal Seek, Reinforced Concrete, UDF, UMom function, VBA
1 Comment

## Reinforced Concrete Moment Curvature – Development over time

I recently noticed that in the RC Design Functions spreadsheet the TimeCurve function had stopped working. The function calculates the development of reinforced concrete section curvature over time, and was previously presented in Reinforced Concrete Moment-Curvature – 3; Restrained Shrinkage and Creep and Reinforced … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged creep, development over time, Excel, moment curvature, RC Design Functions, Reinforced Concrete, shrinkage, TimeCurve function, UDF, VBA
Leave a comment

## Faster Biaxial Bending

The spreadsheet to calculate ultimate moment capacity of a reinforced or prestressed concrete section under combined axial load and biaxial bending, last presented here, has been updated to use the QuadBrent solver, rather than the Excel Goal Seek function, for … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged biaxial bending, Brents method, Combined bending and axial load, Excel, Prestressed concrete, Reinforced Concrete, UDF, ultimate moment capacity, VBA
1 Comment