Analysis of a sheet pilewall.xls

Purpose of calculation: The soil conditions adjacent to the sheet pile wall are given below, find the active pressure behind the wall and passive pressure in front of the wall.
Calculation Reference: Craig Soil Mechanics. R.F. Craig
Calculation Validation: Check against a worked example in the reference above.
Calculation Parameters
        Height above the water table
        Height from water table to the base of the wall
        Height of soil in front of the wall above the water table
        Unit weight of Water
        Surface Load
        Characteristics of Soil 1
        Drained (effective stress) shear strength parameter
        Unit weight of Soil 1
        Drained (effective stress) shear strength parameter
        Characteristics of Soil 2
        Drained (effective stress) shear strength parameter
        Saturated Unit Weight of Soil 2
        Drained (effective stress) shear strength parameter
        Buoyant Unit Weight
        Active earth pressure coefficient for soil 1
        Passive earth pressure coefficient for soil 1
        Active earth pressure coefficient for soil 2
        Passive earth pressure coefficient for soil 2

Calculation Reference
Geotechnics
Soil Mechanics
Craig's Soil Mechanics