Recent Comments
Author Archives: dougaj4
py_ConBeamU and Strand7 check updates
Following the previous post, I have updated the py_ConBeamU spreadsheet, and the associated check against Strand7 results. The new files can be downloaded from: py_ConBeamU.zip The download file now includes: py_ConBeamU.xlsb: The complete spreadsheet, including examples of all functions py_ConBeamU-Check25-2.xlsb: … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged beam analysis, Excel, Fixed-end moments, Python, PyXLL, py_Conbeamu, Restrained End Moments, UDFs
1 Comment
ConBeamU and Strand7 check update
Results of the continuous beam spreadsheet were last checked against Strand7 results 10 years ago. I have now updated this check with the latest version (4.19), which can be downloaded from: ConBeamU.zip The download file now includes: ConBeamU.xlsb: The complete … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Excel Solver, Maximum deflection, Maximum moment, Strand7 check, UDFs, Units, VBA, Working with units.
1 Comment
More on TrimRange and the Drop Function
A comment on my previous post links to a helpful YouTube video on using TrimRange and the Dot operator: It also looks at using the Drop Function to exclude a specified number of rows and/or columns from the top or … Continue reading
Posted in Arrays, Excel
Tagged array functions, Drop function, Excel, Selecting a trimmed range, TrimRange function
Leave a comment
The TrimRange Function
I have just discovered the TRIMRANGE function, and its very useful shortcut version, which were introduced to Excel 365 about a year ago. The function excludes all empty rows and/or columns from the outer edges of a range or array, … Continue reading
Posted in Arrays, Excel
Tagged array functions, Excel, Selecting a trimmed range, TrimRange function
2 Comments
py_UMom 1-05
Following the previous post the OptShearCap3600 function has been modified to give correct results with negative bending moments. The revised spreadsheet and Python code can be downloaded from: py_UMom.zip Typical output with negative moment input:
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged Design for Shear, Excel, longitudinal force due to shear, Python, PyXLL, py_UMom, RC Design Functions, Reinforced Concrete
1 Comment
