Spreadsheet program written in MS-Excel for the purpose of determining the allowable beam end reaction and the allowable end moment for the purpose of end connection design.

It uses the database of member dimensions and section properties from the "AISC Shapes Database", Version 3.0 (2001) as well as the AISC 9th Edition (ASD) Manual (1989).

W, S, M, C, and MC shapes may be selected.

It utilizes the procedure which a steel fabricator would typically use to determine end connection design loads when end reaction values are not specified on the design and construction drawings by the engineer. This procedure is based on the AISC 9th Edition (ASD) Manual (1989) Allowable Uniform Load Tables on pages 2-36 to 2-140 and AISC Specification Chapter K, pages 5-80 and 5-81.

Contains “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc.

Spreadsheet program written in MS-Excel for the purpose of analysis of rigid rectangular spread footings with up to 8 total piers, and for either uniaxial or biaxial resultant eccentricities. Overturning sliding, and uplift stability checks are made when applicable, and resulting gross soil bearing pressures at the four (4) corners of the footing are calculated. The maximum net soil bearing pressure is also determined.

- Individual rectangular spread footing analysis (with net pier loadings)
- Individual rectangular spread footing analysis (with breakdown of loadings)
- Multiple rectangular spread footings analysis and design (table format)
- Multiple rectangular spread footings - pier analysis (table format)

This spreadsheet assumes that the spread footing is in fact "rigid", so that the bearing pressure is distributed linearly on a homogeneous soil. (Note: the actual footing is generally not "rigid", nor is the pressure beneath it distributed linearly. However, it has been found that solutions using the assumed "rigid" concept are adequate and generally result in a conservative design.)

Spreadsheet program written in MS-Excel for the purpose of flat roof snow loading analysis for buildings and structures per the ASCE 7-02 Code. Specifically, coefficients and related and required parameters are selected or calculated in order to compute the net design snow loads, including snow drift due on lower roofs and rain-on-snow surcharge.

Spreadsheet program written in MS-Excel for the purpose of analysis of concrete slabs on grade. Specifically, a concrete slab on grade may be subjected to concentrated post or wheel loading. Then for the given parameters, the slab flexural, bearing, and shear stresses are checked, the estimated crack width is determined, the minimum required distribution reinforcing is determined, and the bearing stress on the dowels at construction joints is checked. Also, design charts from the Portland Cement Association (PCA) are included to provide an additional method for determining/checking required slab thickness for flexure. The ability to analyze the capacity of a slab on grade subjected to continuous wall (line-type) load as well as stationary, uniformly distributed live loads is also provided.