Recent work with the py_ConBeamU spreadsheet found that it was returning incorrect results when the last support had a rotation spring restraint. In spite of the checks against Strand7 having 90 different support conditions, none of them included this one, so I have modified the check files to include it. The modified Python code (version 1.05), and the new check runs, can be downloaded from:
See py_ConBeamU and Strand7 check updates for more details of the download files.
The VBA version did not have this problem, but I have updated the check runs to be consistent with the Python version, and these can be downloaded from:
The results from the previous version of py_ConbeamU and the latest version are shown below for the restraint case causing the problem:
The updated file now agrees almost exactly with the Strand7 results for this load case (Span Type 14 on “Sheet 6”):
Newton Excel Bach, not (just) an Excel Blog 