### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Latex Maths Text in Excel
- Using LINEST for non-linear curve fitting
- Commenting a block of code in VBA
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Deflections and Moments in Rectangular Plates
- Taming Symbols in Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Pint, MPmath and implied units, working with Excel

### Recent Comments

Latex Maths Text in… on Pint, MPmath and implied units… dougaj4 on The VBA Decimal data type Ludek on The VBA Decimal data type dougaj4 on The VBA Decimal data type Ludek on The VBA Decimal data type dougaj4 on About Newton Excel Bach Reinaldo Chohfi Jr. on About Newton Excel Bach Solving cubic equati… on Solving Quadratic, Cubic, Quar… David N on A Match Function Bug … dougaj4 on A Match Function Bug … SectionProperties up… on SectionProperties update updat… David N on A Match Function Bug … dougaj4 on Fitting 3D circles to scattere… Aaron on Fitting 3D circles to scattere… dougaj4 on 3D plots with the latest …

# Tag Archives: elastic analysis

## Elastic Biaxial Bending

Spreadsheets performing Ultimate Limit State analysis with biaxial moments have been presented previously, most recently here: Biaxial bending update I have now modified the Beam Design Functions spreadsheet to carry out a biaxial moment analysis with linear elastic material properties. … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged biaxial bending, elastic analysis, Excel, Reinforced Concrete, UDFs, VBA
Leave a comment

## 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
7 Comments

## Using Beam Design Functions

“Beam Design Functions” is an Excel spreadsheet providing a User Defined Function (UDF) that will calculate the stresses, strains, forces and moments in a reinforced or prestressed concrete section subject to any specified bending moment and axial load, using an … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Beam Bending, elastic analysis, Excel, Prestressed concrete, Reinforced Concrete, Section Analysis, UDF, VBA
12 Comments

## Analysis of RC circular sections – theory and code

The basic tasks involved in analysing the stresses and strains in a reinforced concrete section under combined bending and axial load are: Assuming a horizontal beam with the top of the beam in compression and the bottom in tension Find … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Brents method, circular section, elastic analysis, Excel, Reinforced Concrete, UDF, VBA
Leave a comment

## Reinforced concrete elastic analysis; Circular section

Previous posts have presented the theoretical background to finding stresses and strains in a reinforced concrete section built up of trapezoidal layers and subject to combined bending and axial loads. A spreadsheet with User Defined Functions (UDFs) and open source code … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Beam Bending, circular section, elastic analysis, Excel, Reinforced Concrete, UDF, VBA
1 Comment