The concrete ULS design spreadsheet last posted at: Concrete ULS spreadsheet update has been updated to fix a problem encountered with non-symmetrical reinforcement using the Eurocode 2 rectangular stress block.
Download from ULS Design Functions.
Typical input and output interaction diagram are shown below for a simple rectangular section with asymmetric reinforcement.
Umom Input
Umom Interaction Diagram
| More Python Traps |… on The meaning of = in Pytho… | |
| More Python Traps |… on Python Traps | |
| Using LINEST for non… on LinEstGap with non-linear… | |
 | dougaj4 on Using LinEst() on data with… |
| LinEstGap with non-l… on Fitting high order polyno… | |
| LinEstGap with non-l… on Using LinEst() on data with… | |
| dougaj4 on Using LinEst() on data with… |
 | Charlene Van Wyngaar… on Using LinEst() on data with… |
| dougaj4 on DigitGraph Spreadsheet and Web… |
 | dbwriting on DigitGraph Spreadsheet and Web… |
| dougaj4 on Biaxial bending update |
| dougaj4 on DigitGraph Spreadsheet and Web… |
 | Sergiu on Biaxial bending update |
 | Paul Halsema on DigitGraph Spreadsheet and Web… |
 | Patricio Galvan on DigitGraph Spreadsheet and Web… |
Pingback: Reinforced Concrete – ULS capacity under combined axial load and biaxial bending | Newton Excel Bach, not (just) an Excel Blog
Not able to download the second update.
LikeLike
Thanks for letting me know.
Now fixed
LikeLike
Hi,
Not sure if you will see it, since it is so old, but there is a bug in the spreadsheet. When you flip the tension face to the top, it doesn’t pick up the yield strength of the bar correctly (you have to copy the value down in the table). You can check by flipping the tension face on the sample circle section, the moment capacity reduces significantly, when it should remain the same.
Thanks for these spreadsheets, they come in very handy when I’m trying to squeeze the last bit out of a section!
Mike
LikeLike
Thanks for letting me know Michael. All comments get reported when they are posted, so no problem commenting on old posts.
Which version of the spreadsheet are you using (see the “about” sheet)? I ask because the download version is 2.04, which doesn’t have the problem, but my development version is 2.05, and has the problem you describe. I have fixed it, but I just need to check I haven’t un-fixed anything else.
If you could e-mail a copy of your version to dougaj4 at gmail, that would be helpful.
LikeLike
Pingback: ULS Design Functions – update for AS 3600 | Newton Excel Bach, not (just) an Excel Blog