Following the previous post I have updated the py_RC Elastic spreadsheet and code to work with the new solver function, and also add new functionality. The updated files can be downloaded from:
For details of the pyxll app required to conect the Python code to Excel see Python and pyxll.
As reported in the previous post, the py_CurveatMA function returns the curvature of a reinforced concrete section for a specified axial force and bending moment, with non-linear steel and concrete properties (in spite of the spreadsheet name!):
The py_CurveatMA function calls the functions py_SectForceMV, Stressatx and py_EC2ForceM, which can also be called directly from the spreadsheet:
New functions will calculate the development of shrinkage and creep over time, according to the AS 3600, AS 5100.5, Eurocode 2, or fib model code provisions:
Also “basic drying shrinkage” (to AS 3600) can be calculated from test results:
Finally the EC2Props function returns 13 concrete properties defined in Eurocode 2, for a specified compressive strength:
The other functions available with this spreadsheet are described at: SLS Concrete design with Python
Newton Excel Bach, not (just) an Excel Blog 