The recent posts on the Inverse Quadratic Method and Brent’s Method, and on calling a function as a variable, are leading towards a user defined function (UDF) to analyse circular reinforced concrete sections under combined bending and axial load, but since these methods are of general use, and (strangely) not everyone is interested in reinforced concrete, this post will look at how these methods are used to solve a complex equation, and the specifics of reinforced concrete beam bending theory will be saved for another post. A spreadsheet with full open source code of the functions discussed here may be downloaded from DepthNA.zip

In order to find the stresses and strains in a reinforced concrete section we need to find the location of a line known as the Neutral Axis:

The Neutral Axis is the base of the area in compression, shaded blue

To do this we must find the value of X such that the function CirclQxoI evaluates to zero:

See DepthNA.xls for full code

This is simply done by evaluating the data required by CircleQxoI (R, Ast, Xsc, Istc and Ecc) and passing this to the QuadBrent function together with the name of the function to be solved (CircleQxol) and the range within which the desired X value will lie:

Click for full size view

The screenshot below shows an example of the function in use:

Click for full size view

### Like this:

Like Loading...

*Related*

Pingback: Daily Download 3: ULS design of reinforced concrete sections | Newton Excel Bach, not (just) an Excel Blog

Hello,

What to do if Value Coefficients not possible to define with one range?

I mean, how to solve it if in function I use more than 1 range with data?

THanks

LikeLike

There are (at least) three options:

Simplest – Use spreadsheet formulas to collect all your data into a single column range

Less Simple – Write a function to collect the data from a number of ranges into a single array, then pass that to the Quadbrent function.

Even less simple – Change the Quadbrent function to accept more than one “Coefficients” range.

LikeLike