Civil MDC

Excel Spreadsheets Engineering

JOIST --- STEEL JOIST ANALYSIS 9

JOIST — STEEL JOIST ANALYSIS

“JOIST” — STEEL JOIST ANALYSIS Program Description: “JOIST” is a spreadsheet program written in MS-Excel for the purpose of analysis of steel joists considered assimple-span beams subjected to virtually any type of loading configuration. Specifically, beam end reactions as wellas the maximum moments and deflections are calculated. Plots of both the shear and moment diagrams

JOIST — STEEL JOIST ANALYSIS Read More »

"FLRPLATE" --- STEEL CHECKERED FLOOR PLATE DESIGN 10

“FLRPLATE” — STEEL CHECKERED FLOOR PLATE DESIGN

“FLRPLATE” — STEEL CHECKERED FLOOR PLATE DESIGN Program Description: “FLRPLATE” is a spreadsheet program written in MS-Excel for the purpose of designing steel checkered floorplate subjected to uniformly distributed loading. This program is a workbook consisting of two (2) worksheets, described as follows: Worksheet Name DescriptionDoc This documentation sheetSteel Floor Plate Design Steel checkered floor

“FLRPLATE” — STEEL CHECKERED FLOOR PLATE DESIGN Read More »

ENDPLMC9 --- END PLATE MOMENT CONNECTIONS 11

ENDPLMC9 — END PLATE MOMENT CONNECTIONS

“ENDPLMC9” — END PLATE MOMENT CONNECTIONS Program Description: “ENDPLMC9” is a spreadsheet program written in MS-Excel for the purpose of analysis and design of end platemoment connections per the AISC 9th Edition (ASD) Manual. Specifically the program can analyze both single4-tension bolt and 8-tension bolt configurations, as well as the conditions of having moment connections

ENDPLMC9 — END PLATE MOMENT CONNECTIONS Read More »

"BOLTGRP" --- BOLT GROUP and BOLT STRESS ANALYSIS PROGRAM 12

“BOLTGRP” — BOLT GROUP and BOLT STRESS ANALYSIS PROGRAM

“BOLTGRP” — BOLT GROUP and BOLT STRESS ANALYSIS PROGRAM Program Description: “BOLTGRP” is a spreadsheet program written in MS-Excel for the purpose of analysis of bolt groups usingeither the ultimate strength method (also known as “instantaneous center of rotation” method) or the “elastic”(vector) method (“Alternate Method 1” in AISC Manual). There is also a worksheet

“BOLTGRP” — BOLT GROUP and BOLT STRESS ANALYSIS PROGRAM Read More »

"BMREINF9" --- STEEL MEMBER REINFORCEMENT ANALYSIS 13

“BMREINF9” — STEEL MEMBER REINFORCEMENT ANALYSIS

“BMREINF9” — STEEL MEMBER REINFORCEMENT ANALYSIS Program Description: “BMREINF9” is a spreadsheet program written in MS-Excel for the purpose of analysis and code checking ofsteel members with various types of reinforcement configurations. Specifically, members are analyzed / codechecked per the AISC 9th Edition Allowable Stress Design (ASD) Manual. Both actual and allowable stressesare computed, with

“BMREINF9” — STEEL MEMBER REINFORCEMENT ANALYSIS Read More »

"BMREACT" --- ALLOWABLE STEEL BEAM END REACTION 14

“BMREACT” — ALLOWABLE STEEL BEAM END REACTION

“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

“BMREACT” — ALLOWABLE STEEL BEAM END REACTION Read More »

BEAMCOL9 --- STEEL BEAM AND COLUMN ANALYSIS CODE CHECK 15

BEAMCOL9 — STEEL BEAM AND COLUMN ANALYSIS CODE CHECK

“BEAMCOL9” — STEEL BEAM AND COLUMN ANALYSIS / CODE CHECK Program Description: “BEAMCOL9” is a spreadsheet program written in MS-Excel for the purpose of analysis and code checking ofsteel beams and columns. Specifically, beams and columns are analyzed / code checked per the AISC 9thEdition Allowable Stress Design (ASD) Manual. Both actual and allowable stresses

BEAMCOL9 — STEEL BEAM AND COLUMN ANALYSIS CODE CHECK Read More »

"BASEPLT9" --- STEEL COLUMN BASE PLATE ANALYSIS 16

“BASEPLT9” — STEEL COLUMN BASE PLATE ANALYSIS

“BASEPLT9” — STEEL COLUMN BASE PLATE ANALYSIS Program Description: “BASEPLT9” is a spreadsheet program written in MS-Excel for the purpose of analysis of steel column baseplates. Specifically, wide flange column base plates may be subjected to axial loads (compression or tension),with or without major-axis column bending, plus major-axis shear. Base plate bearing pressure is checked

“BASEPLT9” — STEEL COLUMN BASE PLATE ANALYSIS Read More »

Scroll to Top