Civil MDC

Excel Spreadsheets Engineering

CONCRETE SLAB ON GRADE ANALYSIS 2

CONCRETE SLAB ON GRADE ANALYSIS

“GRDSLAB” — CONCRETE SLAB ON GRADE ANALYSIS Program Description: “GRDSLAB” is a spreadsheet program written in MS-Excel for the purpose of analysis of concrete slabs ongrade. Specifically, a concrete slab on grade may be subjected to concentrated post or wheel loading. Thenfor the given parameters, the slab flexural, bearing, and shear stresses are checked, the

CONCRETE SLAB ON GRADE ANALYSIS Read More »

SLAB ON METAL DECK ANALYSIS DESIGN 4

SLAB ON METAL DECK ANALYSIS DESIGN

“DECKSLAB” — SLAB ON METAL DECK ANALYSIS / DESIGN Program Description: “DECKSLAB” is a spreadsheet program written in MS-Excel for the purpose of analysis and design of slabs onmetal deck. Both composite deck slabs and form deck slabs can be analyzed and designed for 3 differentloading conditions. Specifically, the flexural moment capacity for both positive

SLAB ON METAL DECK ANALYSIS DESIGN Read More »

SEISMIC DESIGN SPECTRAL ACCELERATION VALUES 5

SEISMIC DESIGN SPECTRAL ACCELERATION VALUES

“USGS96SA” — USGS 1996 SPECTRAL ACCELERATION VALUES Program Description: “USGS96SA” is a spreadsheet program written in MS-Excel for the purpose of determining the mappedspectral acceleration values Ss and S1 to be used for seismic analysis and design in either the IBC 2000or IBC 2003 Codes. Results may be obtained by input of location Zip Code

SEISMIC DESIGN SPECTRAL ACCELERATION VALUES Read More »

IBC 2003 SEISMIC ANALYSIS PROGRAM 6

IBC 2003 SEISMIC ANALYSIS PROGRAM

“IBC2003E” — IBC 2003 SEISMIC ANALYSIS PROGRAM Program Description: “IBC2003E” is a spreadsheet program written in MS-Excel for the purpose of seismic loading analysis forbuildings and various nonbuilding structures, as well as architectural, mechanical, and electrical componentsper the IBC 2003 and ASCE 7-02 Codes. Specifically, the total base seismic shear for buildings and nonbuildingstructures is

IBC 2003 SEISMIC ANALYSIS PROGRAM Read More »

IBC 2000 SEISMIC ANALYSIS PROGRAM 7

IBC 2000 SEISMIC ANALYSIS PROGRAM

“IBC2000E” — IBC 2000 SEISMIC ANALYSIS PROGRAM Program Description: “IBC2000E” is a spreadsheet program written in MS-Excel for the purpose of seismic loading analysis forbuildings and various nonbuilding structures, as well as architectural, mechanical, and electrical componentsper the IBC 2000 Code. Specifically, the total base seismic shear for buildings and nonbuilding structures iscalculated. For Multi-Level

IBC 2000 SEISMIC ANALYSIS PROGRAM Read More »

PIPE AND TANK WEIGHT CALCULATION PROGRAM 14

PIPE AND TANK WEIGHT CALCULATION PROGRAM

“WEIGHTS” — PIPE AND TANK WEIGHT CALCULATION PROGRAM Program Description: “WEIGHTS” is a spreadsheet program written in MS-Excel for the purpose of calculating the weights of pipes and tanksor vessels. Specifically, the weight of pipes either empty or full of contents, with/without insulation, and with/without icebuildup is determined. The volume and weight of tanks or

PIPE AND TANK WEIGHT CALCULATION PROGRAM Read More »

AXIAL LOAD CAPACITIES FOR SINGLE PLATES 19

AXIAL LOAD CAPACITIES FOR SINGLE PLATES

“PLATECAP” — AXIAL LOAD CAPACITIES FOR SINGLE PLATES Program Description: “PLATECAP” is a spreadsheet program written in MS-Excel for the purpose of determining the gross tensionand compression axial load capacities of single plates. The results of the calculations are presented in atabular format. This program is a workbook consisting of two (2) worksheets, described as

AXIAL LOAD CAPACITIES FOR SINGLE PLATES Read More »

LOAN MONTHLY PAYMENTS AND AMORTIZATION SCHEDULE 20

LOAN MONTHLY PAYMENTS AND AMORTIZATION SCHEDULE

“LOAN MONTHLY PAYMENTS AND AMORTIZATION SCHEDULE” Program Description: “Loan Amortization” is a spreadsheet program written in MS-Excel for the purpose of determining the monthlypayments (principal and interest) for a loan, as well as developing a complete amortization schedule for thegiven loan. The ability to input additional monthly uniform or varied/random direct principal payments is alsoprovided,

LOAN MONTHLY PAYMENTS AND AMORTIZATION SCHEDULE Read More »

Scroll to Top