Civil MDC

Excel Spreadsheets Engineering

SIMPLIFIED TORSION ANALYSIS FOR STEEL BEAMS 3

SIMPLIFIED TORSION ANALYSIS FOR STEEL BEAMS

“TORSION9” — SIMPLIFIED TORSION ANALYSIS FOR STEEL BEAMS Program Description: “TORSION9” is a spreadsheet program written in MS-Excel for the purpose of simplified analysis and codechecking of steel beams subjected to torsional loading. Specifically, six (6) different beam and loadingconfigurations can be analyzed / code checked per the AISC 9th Edition Allowable Stress Design (ASD)

SIMPLIFIED TORSION ANALYSIS FOR STEEL BEAMS Read More »

STEEL BEAM WEB STIFFENER ANALYSIS 5

STEEL BEAM WEB STIFFENER ANALYSIS

“STIFFNER” — STEEL BEAM WEB STIFFENER ANALYSIS Program Description: “STIFFNER” is a spreadsheet program written in MS-Excel for the purpose of analysis of steel beams subjectto concentrated loads. Specifically, web yielding, web crippling, and web buckling criteria are checked todetermine if web stiffeners are required to resist the concentrated load. If stiffeners are required, the

STEEL BEAM WEB STIFFENER ANALYSIS Read More »

SECTION PROPERTIES ANALYSIS PROGRAM 7

SECTION PROPERTIES ANALYSIS PROGRAM

“SECTPROP” — SECTION PROPERTIES ANALYSIS PROGRAM Program Description: “SECTPROP” is a spreadsheet program written in MS-Excel for the purpose of calculating section properties.Two methods of input data are provided, either by adding of deleting “shapes” or by defining a polygon by aseries of “points”. Specifically, the centroid location and total area are determined, as well

SECTION PROPERTIES ANALYSIS PROGRAM Read More »

Web-Tapered Cantilever Frame Design Based on AISC-ASD 9th, Appendix F and/or AISC Design Guide 25 9

Web-Tapered Cantilever Frame Design Based on AISC-ASD 9th, Appendix F and/or AISC Design Guide 25

To achieve greater economy in material use, web-tapered steel members, where deeper cross-sections are used within the regions subjected to larger internal forces, are commonly employed within steel structures. However, the methods provided in current structural steel design specifications for the instability assessment of web-tapered steel members are based largely on those developed for prismatic

Web-Tapered Cantilever Frame Design Based on AISC-ASD 9th, Appendix F and/or AISC Design Guide 25 Read More »

CONVERSION CALCULATOR 11

CONVERSION CALCULATOR

“CONVCALC” — CONVERSION CALCULATOR Program Description: “CONVCALC” is a spreadsheet program written in MS-Excel for the purpose of facilitating the adding andsubtracting of numbers (dimensions) represented in English “ft.-in. & fraction” format, as well as convertingthose numbers to Metric (millimeter) equivalents. Also included are some miscellaneous English/Metricconversions pertaining specifically to mass, force, and unit length

CONVERSION CALCULATOR Read More »

Cellular Beam Design Based on AISC 360-10 15

Cellular Beam Design Based on AISC 360-10

Designing cellular beams based on the American Institute of Steel Construction (AISC) 360-10 specification involves following the provisions outlined in the code. Cellular beams, also known as castellated or cellular composite beams, are steel members with regularly spaced openings or cells along the length of the beam. These openings reduce the weight of the beam

Cellular Beam Design Based on AISC 360-10 Read More »

BEAM REACTION ANALYSIS 16

BEAM REACTION ANALYSIS

“BMREACT” — ALLOWABLE STEEL BEAM END REACTION Program Description: “BMREACT” is a spreadsheet program written in MS-Excel for the purpose of determining the allowable beamend reaction and the allowable end moment for the purpose of end connection design. This program is a workbook consisting of two (2) worksheets, described as follows: Worksheet Name DescriptionDoc This

BEAM REACTION ANALYSIS Read More »

WIND LOADING ANALYSIS - MWFRS and Components/Cladding 17

WIND LOADING ANALYSIS – MWFRS and Components/Cladding

“ASCE702W” — ASCE 7-02 CODE WIND ANALYSIS PROGRAM Program Description: “ASCE702W” is a spreadsheet program written in MS-Excel for the purpose of wind loading analysis for buildingsand structures per the ASCE 7-02 Code. Specifically, wind pressure coefficients and related and requiredparameters are selected or calculated in order to compute the net design wind pressures. This

WIND LOADING ANALYSIS – MWFRS and Components/Cladding Read More »

Scroll to Top