Professional tools for calculations and dimensioning of mechanical engineering problems using Excel spreadsheets.
This spreadsheet is to be used to check the adequacy of roof purlins for a specified combination of loads. The designis based on the maximum yeild strength (Mn = FySx) as stated in the AISC Manual 13th Ed. This spread sheet can only be used for load combinations with two variables. In most cases the worst case scenario is 0.6DL+W, so this should be adequate. Only the values in the highlighted cells need to be changed.
Calculation Reference
Roof Design
SIMPLY SUPPORTED PRECAST PLANK DESIGN to ACI318 & PCI SPECIFICATIONS
Calculation Reference
ACI318
Pole foundation design based on IBC 2003. Both Restrained and Unrestrained at top.
Calculation Reference
IBC 2003
DESIGN OF COLUMN FOUNDATION CONNECTIONS/BASE PLATE
Design Code: B.S. 8110 Part 1
Input Data:
Calculation Reference
Precast Concrete Design
This spreadsheet determines whether a steel beam with known loads, and hence known Moments and Shears, can have web openings added. The first worsheet will determine if an opening can be added at a specific location without reinforcement. The second worksheet goes through the same check as the first and then determines what reinforcing is necessary. The third spreadsheet is the steel data tables as made available by AISC.
Calculation Reference
AISC
Purpose of calculation: Calculate plate bending stress when subject to a point load.
Calculation Reference: First principles
Calculation Reference
Peterson’s Stress Concentration
Density Of Concrete
Density Of Soil
Depth Of Foundation
Soil Bearing Capacity
Length Of Footing
Width Of Footing
Thickness of Fdtn.
Width Of Pedestal
Length Of Pedestal
Height Of Pedestal
Coefficient Of Friction
Ground Water Table Ht.
1.0 Load Calculation for Footing & Soil:
Self Wt. Of Footing
Weight of Soil
Self Wt. Of Pedestal
Weight of Footing + Soil
2.0 Check Maximum and Minimum Pressure at Footing Base:
Area of Footing
Section Modulus
Section Modulus
Total Vertical Load
3.0 Check for Overturning:
Overturning Moment
Due to External Load
Due to wt. of Pedestal
Due to Self Wt. of Fdn
Due to Wt. of Soil
Total Stabilizing Moment
F.O.S. against Overturning
4.0 Check for Sliding:
Resultant Shear Force
Total Vertical Load
F.O.S. against Sliding
5.0 Load Case Check:
Check Max. & Mini. Pressure at Footing Base:
6.0 Check for Overturning & Sliding:
7.0 Check For Shear
a) Two Way Shear
b) One Way Shear
8.0 Design Of Foundation/Footing:
a) Calculation of Reinforcement at Bottom
b) Calculation of Reinforcement at Top
This presents the design of isolated spread footing using the results from Staad Support Reactions.
Calculation Reference
Reinforced Concrete Footings
This spreadsheet incorporates Vessel motion loading with Environmental Criteria in estimating stresses for mast designs. It covers both unstayed and stayed mast in SI unit and Imperia unit. Although it is being specifically doctored for mast, it could be adapted for estimating stresses of similar structures on floating unit such include Burner boom, Derricks etc. The calculation is referenced to Design of Ships masts R.W. Milliman published by the Association of Engineering and Shipbuilding Draughtsman AESA.
Calculation Reference
Design of Ships Masts
This spreadsheet defines the principle terms and ratios used in tubular joint design. It presents the classifications for T, Y, X, N, K and KT joints and the details of joint arrangements. It describes design methods for static strength.
The main structure of a topside consists of either an integrated deck or a module support frame and modules. Commonly tubular lattice frames are present, however a significant amount of rolled and built up sections are also used. This calculation sheet refers to the design of tubular joints. These are used extensively offshore, particularly for jacket structures.
Only static check is performed here, fatigue check shall be added in further revisions.
Calculation Reference
Tubular Steel Construction
