The new DevLength function returns reinforcement development length to AS 3600, AS 5100, Eurocode 2, or BS 5400 requirements. An example of the function can be found on the “UMom Out” sheet:
The function output returns the development length followed by the required code factors, which are different for each code:
On the same sheet, the MaxAx function has been updated to return all values:
On the “UShear” sheet examples have been added of the ShearCapEC2 and ShearCapBS5400 functions, which can also be called from the UMomPF function. There is also a correction to the shear capacity results to AS 3600 and AS 5100:
Finally, the shear results from the UMom function have been updated so that the full results are returned with array input of applied actions. See the “Array exmples” sheet for an example:
As well as a very simple tool to create your own stereograms, there are many excellent examples, and background information on ways to see the hidden image.
The UMomPF function returns ultimate bending and axial load capacity to the Eurocode 2 and BS 5400 design codes. It has now been updated to also return shear capacity, and modified bending capacity, allowing for the additional tensile force in the longitudinal steel due to the shear force. Note that in the current version there is no provision for design for torsion.
The main data input array is the same as for the UMom function:
Shear reinforcement and related data input is different to UMom:
The last two input values are only required for Eurocode 2:
The shear capacity in Eurocode 2 is calculated with a strut and tie model. The angle of the compression strut to the horizontal is specified by the Cotangent of the angle, which must be in the range 1.0 to 2.5.
The additional longitudinal tension is limited to the force that would increase the applied bending moment at the section to more than the maximum moment along the beam.
If the Cot(strut angle) input is not entered (or is outside the range 1.0 to 2.5) the function adjusts the angle so that the maximum shear controlled by concrete compression is equal to the shear capacity of the shear reinforcement:
In this example the shear capacity (712 kN) is well over the applied shear, but the adjusted moment capacity (492 kNm) is less than the applied moment.
Entering a Cot Theta value of 1.2 reduces the shear capacity and also reduces the additional longitudinal force:
The reduced shear capacity of 508 kN is greater than the applied shear (500 kN), but the adjusted moment capacity (547 kNm) is still just under the bending moment at the section.
Entering a moment of 650 kNm as the maximum moment along the beam reduces the additional longitudinal force to 207 kN, and the adjusted bending capacity increases to 589 kNm:
The shear capacity calculation in BS 5400 is simpler, and the Cot Theta and maximum moment values input have no effect on the results:
In this case the shear capacity is greater than the final value found using Eurocode 2, but the bending capacity is significantly lower, and after adjustment for shear it is below the required value.
The main change is update of shear capacity calculations for the latest versions of the Australian codes; AS 3600 and AS 5100.
Shear data input now includes:
The option to use the simplified or refined design process
Provision for input of external and internal ties of different diameter
Provision for combined shear and torsion
Shear results can be returned from the UMom function with the output index (offs1) 11 or 12, with 11 returning a summary of shear capacities and 12 a detailed listing of data from the shear caalculation:
If the “Use Simplified” option is set to “False” (default) the bending capacities are also re-calculated with the available longitudinal reinforcement area reduced by the area required for the input shear and torsion:
The UMom function calls a new function, ASShear, for the shear capacity calculation. This function may also be called directly as a user defined function, which returns the full output listing as a single column:
Note that the provisions of the current versions of AS 3600 and AS 5100.5 are sometimes inconsistent, and a further revision of AS 5100.5 is expected later this year. Further details of the new requirements for shear and torsion calculations will be published in future posts.
The function returns my interpretation of the current requirements of each code. As always, the results must be independently checked before using for any real appication.
Newton Excel Bach, not (just) an Excel Blog 