Sheet pile walls

Example 7.3Elements of Soil Mechanics, 8th EditionExample 7.3

The worksheets in this spreadsheet illustrate the use of the BS8002 and Eurocode 7 methods of design for cantilever sheet pile walls.

Although the sheets contain the data for Example 7.3 from the book, the data may be changed so that the reader can see the effect of varying the soil properties, retained height etc.

Instructions:1. On opening the spreadsheet, the user must click "Enable Macros" in the opening dialog box. (The macros contain the algorithms used to determine the design depth.)

2. As the routines call data from the partial factors spreadsheet, a second dialog box asking whether to update the data will appear. To use the default Eurocode 7 partial factor values, click "Don't Update". If, however, you have changed values in the partial factors spreadsheet, click "Update".

3. Select appropriate sheet to enter data and view results.

Ian Smith, Sept 2005

BS8002 full - cantileverExample 7.3: CANTILEVER Sheet pile wallBS8002 - Full lateral earth pressure approachphi =30.00gamma =20.00kN/m3Min exc =0.5mh =10.00mDesign phi =25.7M =1.20Surcharge =10.00kPaKa =0.395Kp =2.531Enter values into fields above, then click Solve.FORCES:Pp1 =1049.61kNPp2 =738.10kNPa1 =1133.89kNPa2 =45.54kNPq1 =66.94kNDesign Results:Pq2 =21.26kNd0 =6.44mLEVER ARM:d =7.28mlp1 =2.15mlp2 =0.42mla1 =5.65mImportant: Please read the comment attached to this cell.la2 =0.43mlq1 =8.47mlq2 =0.42mMOMENTS:Mp1 =2253.16kNmMp2 =312.50kNmMa1 =6402.69kNmMa2 =19.52kNmMq1 =566.94kNmMq2 =8.93kNmCHECK (M=0) & (P=0)(M=0)-4414.55(1)(P=0)-865.03(2)ABS[(1)-(2)]3549.519413

&APage &PMobilisation Factor. Default is M=1.2Disclaimer:The iterative procedure used to solve d0 and d in this spreadsheet is a rather simplistic one and may not yield the exact solutions. Instead, the algorithm will stop when it finds d0 and d values that yield "approximate" solutions to the moment and force equilibrium equations (M=0 and P=0). (Check cell D42 to see how close the solution is to zero.) To this end, this spreadsheet should not be used for a real design. Its purpose is purely to enable the reader of the book to follow the stages of calculations in the full BS8002 approach. The limits of the algorithm may also lead to failure to find a solution for some walls.Solve!surcharge, qhmin excd0dPa1Pp1Pq1Pq2Pp2Pa2

BS8002 simplified - cantilvrExample 7.3: CANTILEVER Sheet pile wallBS8002 - Simplified approachphi =30.00gamma =20.00kN/m3Min exc =0.5mh =5.00mDesign phi =25.7M =1.20Surcharge =10.00kPaKa =0.395Kp =2.531Enter values into fields above, then click Solve.FORCES:Pp =1232.42kNPa =615.26kNPq =49.31kNR=567.86kNDesign Results:LEVER ARM:lp =2.33md0 =6.98mla =4.16md = d0*1.2 =8.37mlq =6.24mMOMENTS:Mp =2866.76kNmMa =2559.13kNmMq =307.63kNmCHECK (M=0)Mp - Ma - Mq =-0.0000-335544.32

&APage &PMobilisation Factor. Default is M=1.2Solve!surcharge, qhmin excd0dPaPpRPq

Eurocode 7, DA1, C1 - cantilvrExample 7.3: CANTILEVER Sheet pile wallEurocode 7 - GEO limit state, Design Approach 1 - Combination 1Partial factorsMin exc =0.5mphi =30.00Design phi =30.0On unfavourable actions/action effectsgamma =20.00kN/m3Design gamma =20kN/m3Permanent actionsG =1.35h =5.00mVariable actionsQ =1.50Surcharge =0.00kPaOn material propertiesKa =0.333Coef. of shearing resistance =1.00Kp =3.000Weight density =1.00Enter values into fields above, then click Solve.Actions:(Rep.)(Design)FORCES (kN):Pp1 =820.591107.79(unfav, permanent)Pp2 =322.66435.60(unfav, permanent)Pa1 =383.78518.10(unfav, permanent)Pa2 =17.8824.14(unfav, permanent)Design Results:Pq1 =0.000.00(unfav, variable)Pq2 =0.000.00(unfav, variable)d0 =5.23md =5.72mDesign effect of actions (rotation of wall):LEVER ARM:lp1 =1.74mImportant: Please read the comment attached to this cell.lp2 =0.25mla1 =3.58mla2 =0.25mlq1 =5.37mlq2 =0.24mMOMENTS:Mp1 =1931.25kNmMp2 =107.52kNmMa1 =1853.06kNmMa2 =6.00kNmMq1 =0.00kNmMq2 =0.00kNmCHECK (M=0) & (P=0)(M=0)179.70(1)(P=0)178.24(2)ABS[(1)-(2)]1.457958

&APage &PDisclaimer:The iterative procedure used to solve d0 and d in this spreadsheet is a rather simplistic one and may not yield the exact solutions. Instead, the algorithm will stop when it finds d0 and d values that yield "approximate" solutions to the moment and force equilibrium equations (M=0 and P=0). (Check cell D44 to see how close the solution is to zero.) To this end, this spreadsheet should not be used for a real design. Its purpose is purely to enable the reader of the book to follow the stages of calculations in the full Eurocode 7 approach. The limits of the algorithm may also lead to failure to find a solution for some walls.Although Example 7.3 has no surcharge, this function is included in case the reader wishes to use the template for cases where a surcharge is present.Don't consider Pq2 as being favourable. NB Effects of actions should be considered as either favourable or unfavourable, not a bit of both!Solve!surcharge, qhmin excd0dPa1Pp1Pq1Pq2Pp2Pa2

Eurocode 7, DA1, C2 - cantilvrExample 7.3: CANTILEVER Sheet pile wallEurocode 7 - GEO limit state, Design Approach 1 - Combination 2Partial factorsMin exc =0.5mphi =30.00Design phi =24.8On unfavourable actions/action effectsgamma =20.00kN/m3Design gamma =20kN/m3Permanent actionsG =1.00h =5.00mVariable actionsQ =1.30Surcharge =0.00kPaOn material properties/resistancesKa =0.409Coef. of shearing resistance =1.25Kp =2.444Weight density =1.00Enter values into fields above, then click Solve.Actions:(Rep.)(Design)FORCES (kN):Pp1 =799.70799.70(unfav, permanent)Pp2 =519.36519.36(unfav, permanent)Pa1 =515.05515.05(unfav, permanent)Pa2 =45.9845.98(unfav, permanent)Design Results:Pq1 =0.000.00(unfav, variable)Pq2 =0.000.00(unfav, variable)d0 =5.72md =6.63mDesign effect of actions (rotation of wall):LEVER ARM:lp1 =1.91mImportant: Please read the comment attached to this cell.lp2 =0.46mla1 =3.74mla2 =0.47mlq1 =5.61mlq2 =0.45mMOMENTS:Mp1 =1524.77kNmMp2 =239.38kNmMa1 =1926.28kNmMa2 =21.43kNmMq1 =0.00kNmMq2 =0.00kNmCHECK (M=0) & (P=0)(M=0)-183.57(1)(P=0)-188.72(2)ABS[(1)-(2)]5.148113

&APage &PDisclaimer:The iterative procedure used to solve d0 and d in this spreadsheet is a rather simplistic one and may not yield the exact solutions. Instead, the algorithm will stop when it finds d0 and d values that yield "approximate" solutions to the moment and force equilibrium equations (M=0 and P=0). (Check cell D44 to see how close the solution is to zero.) To this end, this spreadsheet should not be used for a real design. Its purpose is purely to enable the reader of the book to follow the stages of calculations in the full Eurocode 7 approach. The limits of the algorithm may also lead to failure to find a solution for some walls.Although Example 7.3 has no surcharge, this function is included in case the reader wishes to use the template for cases where a surcharge is present.Don't consider Pq2 as being favourable. NB Effects of actions should be considered as either favourable or unfavourable, not a bit of both!Solve!surcharge, qhmin excd0dPa1Pp1Pq1Pq2Pp2Pa2

About...This spreadsheet has been downloaded from the website that supportsSmith's Elements of Soil Mechanics, 8th EditionPublished by Blackwell Publishing, May 2006ISBN: 1-4051-3370-8Visit the website:http://sbe.napier.ac.uk/esmPurchase the book:(Blackwell Publishing website)http://sbe.napier.ac.uk/esm

Please note:This spreadsheet is an aid for learning and should really only be used in conjunction with the relevant section in the book.

It is not intended for use in geotechnical design.

Ian Smith, May 2006http://sbe.napier.ac.uk/esm