A Microsoft Office Excel spreadsheet which can be used to check the
capacity of a rectangular, reinforced concrete beam.
This spreadsheet file checks the bending capacity of a rectangular
concrete beam with the reinforcement already laid out. The capacity is checked against
the maximum sagging moment produced from a series of load cases. The beam is analyzed in
STAAD.Pro. The results are extracted and linked into Excel using OpenSTAAD and VBA.
In STAAD.Pro, select the Sample Models link
on the Open tab of the Start page.
Select US/US-8 Concrete Design for a Space Frame.STD and the
click Open.
Selet the Run Analysis tool in the
Analysis group on the Analysis and
Design ribbon tab.
The macro relies on having analysis results.
Open the C:\Users\Public\Public Documents\STAAD.Pro
2024\SamplesSample
Models\OpenSTAAD\Rectangle-Beam.xls file in Microsoft Office
Excel.
Note: Excel will warn of macros
present in the file. Simply click the Options… button in
the Security Warning message area to open the Microsoft Office Security
Options dialog, where you will select the Enable this
Content option and click OK.
Select the STAAD.Pro Output worksheet.
The calculations for checking the capacity are located on the sheet
marked Concrete while the extraction of the values from STAAD
occurs on the sheet marked STAAD.Pro Output.
Type a member number in cell B7.
Member 14 is entered by default.
Click Results.
The STAAD.Pro results are read into the spreadsheet along with the beam
size. Then the Concrete worksheet is selected for you.
The rest of the Concrete worksheet performs concrete beam
design for the selected member based on the moment and dimensions.