Simply Supported Precast Plank Design Spreadsheet
SIMPLY SUPPORTED PRECAST PLANK DESIGN to ACI318 & PCI SPECIFICATIONS
Calculation Reference
ACI318
Pole Foundation Design and Calculation Spreadsheet (IBC 2003)
Pole Foundation Design and Calculation Spreadsheet (IBC 2003)
Pole foundation design based on IBC 2003. Both Restrained and Unrestrained at top.
Calculation Reference
IBC 2003
Design Of Column Foundation Connections Spreadsheet
Design Of Column Foundation Connections Spreadsheet
DESIGN OF COLUMN FOUNDATION CONNECTIONS/BASE PLATE
Design Code: B.S. 8110 Part 1
Input Data:
- Columns Size
- column width
- column depth
- Column Loads
- Axial Load
- Column Moment(major axis)
- projection length
- dist from plate edge to holding down bolts
- yeild strength of plate
- yeild strength of bolts
Calculation Reference
Precast Concrete Design
Steel Beams With Web Openings Calculation Spreadsheet
Steel Beams With Web Openings Calculation Spreadsheet
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
Stress In a Plate Due To a Point Load Spreadsheet
Stress In a Plate Due To a Point Load Spreadsheet
Purpose of calculation: Calculate plate bending stress when subject to a point load.
Calculation Reference: First principles
Calculation Reference
Peterson’s Stress Concentration
Design Of Spread Footing As Per ACI 318-07 Spreadsheet
Design Of Spread Footing As Per ACI 318-07 Spreadsheet
- PIPE SUPPORT FOUNDATION
- DESIGN OF SPREAD FOOTING TO ACI 318-07
- DESIGN OF ISOLATED FOOTING
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 + Soil2.0 Check Maximum and Minimum Pressure at Footing Base:
Area of Footing
Section Modulus
Section Modulus
Total Vertical Load3.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 Overturning4.0 Check for Sliding:
Resultant Shear Force
Total Vertical Load
F.O.S. against Sliding5.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 Shear8.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
Moment Connection Of Portal Frame Spreadsheet (Eurocode 3)
Design Of Ships Masts Spreadsheet
Design Of Ships Masts Spreadsheet
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
Tubular Joints in Offshore Structures As Per API RP2A (WSD) Spreadsheet
Tubular Joints in Offshore Structures As Per API RP2A (WSD) Spreadsheet
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
