Retaining
Retaining
  15.00
  14.00
  13.00
  12.00
  11.00
  10.00
   9.00
   8.00
   7.00
   6.00
   5.00
   4.00
   3.00
   2.00
   1.00
   0.00
  -1.00.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
      0    1   2   3   4   5   6   7   8   9 10 11 12 13 14 15
  -2.00
  -3.00
1   0.00   0.00
2   0.00   1.00
3   0.50   1.00
4   0.60   5.62
5   1.30   5.62
6   2.40   1.00
7   3.80   1.00
8   3.80   0.00
9   0.00   0.00
1   0.00   1.00
2   0.50   1.00
1   0.50   -1.91
2   3.80   -1.91
1   0.00   4.62
2   0.50   4.62
                Location                                               : SUNGAI CIRASEA KAB. BANDUNG
395816038.xls-08/30/2018
          STABILITY
          S
                                 : D1 - Hulu
             |e| = 0.56 m < B/6 = 0.63 m              OK!                 |e| = 0.48 m < B/3 = 1.27 m             OK!
                                                                                                                              35.583
             q1 =    17.27   t/m2     > qa =       5.59   t/m2   Check!   q1 =    16.14   t/m2   > qae =       9.26   t/m2   Check!
             q2 =     1.47   t/m2     < qa =       5.59   t/m2   OK!      q2 =     2.19   t/m2   < qae =       9.26   t/m2   OK!
Use Wooden pile = 0.35 m (spacing) Use Wooden pile = 0.35 m (spacing)
395816038.xls-08/30/2018
                                                                                                                                                                       Stability5/35
  1. Design Data
  1.1 Dimensions                                                                    q (t/m2)
                                                                                                                     b11     b12   b13
      B     =     3.80      m         H      =      5.62        m
      L     =     1.00      m (unit length)
     h1     =     5.62      m         h4     =      1.00        m
     h31    =     1.00      m         hw1    =      -1.91       m
                                                                                    hw1
     h32    =     0.00      m         hw2    =      4.62        m
                                                                                                                                                         h32          hw2
                                                                                                                                                                h4
  1.2 Parameters                                                                                                                                         h31
  2. Stability Calculation
  2.1 Case 1 (Normal condition, with vertical live load)
                                                                                          1.00
                                            q =      0.30       t/m2                                  0.70
                                                                                                                     0.10
                                                        qa1
                                                                                              9
Pa1
                                                  Pa2                        10                        7
                  5.62                                                                                                                          4.62
                                                     qa2                     11
                                                                                                                 8
                                                                                                                                         0.00
                                                          Pa3                                     6
                    -1.91                                              12                                            5
                                Pw1                                                       4
                                            Pa4
                                                                                                                                                       1.00           4.62
                                                                               1                       2                 3               Pp1    1.00                 Pw2
                                                                       Pu1                                                    O
                                  qw1         qa4       qa3                                                                        qp1                         qw2
                                                                                                        qu2            Pu2
                                                                                    qu1
                                                                             1.50                     1.80           0.50
395816038.xls-08/30/2018
                                                                                                                   Stability6/35
  (1) Vertical Load
                                       Cos2(f -a)
       Ka =
                                                          Sin(f+d) x Sinf       2
                 Cos2a x Cos(a+d) x           1+
                                                     Cos(a+d) x Cosa
    (for stability analysis)
                    a       =     0.000   o
                                                                     d      =       0.000   o
                                       Cos2(f+a)
       Kp =
                                                          Sin(f+d) x Sinf       2
                 Cos2a x Cos(a -d) x          1-
                                                      Cos(a -d) x Cosa
                 a    =           0.000   o
                                                                   d        =       0.000   o
            Cos (f+a) =
                2
                                  0.993                      Sin(f+d)       =       0.083
            Cos2a     =           1.000                      Sinf           =       0.083
            Cos(a -d) =           1.000                      Cosa           =       1.000
Kp = 1.181
395816038.xls-08/30/2018
                                                                                                                                              Stability7/35
                  B                              3.80
        e =              -        X        =               -       1.366   =      0.534     m       < B/6      =     0.633     m       OK !
                 2                                 2
   a) -2 With Uplift
         B = 3.80        m
                  B                              3.80
        e =              -        X        =               -       1.534   =      0.366     m       < B/6      =     0.633     m       OK !
                  2                                2
                 HR           17.792
       Fs =              =                 =     1.653     >       1.50        OK !
                 SH           10.761
              35.583                  6x        0.534
       q1 =              x (1 +                          ) =   17.259 t/m2                  >        qa        =     5.588     t/m2   Check !
                 3.80                    3.80
              35.583                  6x        0.534
       q2 =              x (1 -                          ) =       1.469   t/m2             <        qa        =     5.588     t/m2    OK !
                 3.80                   3.80
                                      Reaction of Foundation Soil in Case 1
395816038.xls-08/30/2018
                                                                                                                                                                Stability8/35
  2.2 Case 2 (Normal condition, without vertical live load)
                                                                                       1.00
                           q =     0.30    t/m2                                                  0.70
                                                                                                            0.10
                                                      qa1
                                                                                            9
Pa1
                                                Pa2                     10                        7
                  5.62                                                                                                                    4.62
                                                   qa2                  11
                                                                                                        8
                                                                                                                                   0.00
                                                        Pa3                                 6
                     -1.91                                        12                   4                    5
                             Pw1          Pa4
                                                                                                                                                 1.00          4.62
                                                                             1                    2             3              Pp1        1.00                Pw2
       Kp =        1.181
      qa1 = Ka x q                                                               =              0.254 ton/m
      qa2 = Ka x (h1- hw1) x gsoil                                               =              9.499 ton/m
      qa3 = qa1 + qa2                                                            =              9.753 ton/m
      qa4 = Ka x hw1 x (gsat - gw)                                               =          -0.951 ton/m
      qw 1 = hw1 x gw                                                            =          -1.910 ton/m
       qw2 = hw2 x gw                                                            =              4.620 ton/m
      qp1 = Kp x h4 x (gsat - gw)                                                =              0.694 ton/m
395816038.xls-08/30/2018
                                            Stability9/35
  Total                    10.761   24.50
395816038.xls-08/30/2018
                                                                                                                                        Stability10/35
  (3) Stability Calculation
                 HR           17.417
       Fs =              =                 =        1.62     >      1.50        OK !
                 SH           10.761
                 SW                   6xe
     q1,2 =              x (1 +                )
                  B                    B
              34.833                  6x        0.560
       q1 =              x (1 +                            ) =   17.272 t/m2                 >        qa      =     5.588    t/m2    OK !
                 3.80                    3.80
              34.833                  6x        0.560
       q2 =              x (1 -                            ) =      1.061   t/m2             <        qa      =     5.588    t/m2    OK !
                 3.80                    3.80
395816038.xls-08/30/2018
                                                                                                                                                                    Stability11/35
  2.3 Case 3 (Seismic condition)
                                                                                        1.00
                                                                                                    0.70
                                                                                                                  0.10
                                                                             10                       7
                    5.62                          Pa1                                                                                          4.62
                                                        qa1                  11
                                                                                                              8
                                                                                                                                        0.00
                                                                                                6
                      -1.91                   Pa2
                                                                    12                  4                         5
                               Pw1
                                             Pa3                                                                                                      1.00          4.62
                                                                               1                     2                3             Pp1        1.00                Pw2
                                                    Cos2(f-F-a)
     Kae =
                                                                                                                      2
                                                                     Sin(f+d) x Sin(f-b-F)
                CosF x Cos2a x Cos(a+d+F) x 1+
                                                                Cos(a+d+F) x Cos(a-b)
                                                                                                                                                                         0
           tan d =            Sin f Sin ( F + D - b )
                              1 - Sin f Cos ( F + D - b )
           sin D=             Sin ( F + b )
                              Sin f
                     a        =      12.213   o
                                                                         d          =               2.38      o
           Cos (f-F-a)=
                2
                                      0.977                   Sin(f+d)              =           0.124
           CosF               =       1.000                   Sin(f-b-F)            =           0.060
           Cos2a              =       0.955                   Cos(a-b)              =           0.977
           Cos(a+d+F)=                0.962
395816038.xls-08/30/2018
                                                                                                                            Stability12/35
     Kae =     0.897       (for structural analysis)
                                              Cos2(f-F+a)
     Kpe =
                                                                                          2
                                                                Sin(f-d) x Sin(f+b-F)
               CosF x Cos2a x Cos(a+d-F) x 1-
                                                             Cos(a+d-F) x Cos(a-b)
                 a    =           0.000   o
                                                               d    =        1.00     o
           Cos (f-F+a)=
               2
                                  0.996                  Sin(f-d)   =        0.065
           CosF       =           1.000                  Sin(f+b-F) =        0.060
           Cos2a      =           1.000                  Cos(a-b)   =        1.000
           Cos(a+d-F)=            1.000
Kpe = 1.133
395816038.xls-08/30/2018
                                                                                                                                       Stability13/35
   b) Stability against sliding
   b)-1 Without Uplift
      Sliding force :        SH           =       10.103 ton
      Resistance :            HR = m x S W                 =       0.50    x      34.833     =      17.417   ton
           (friction coefficient : m =             0.50    )
                  HR           17.417
       Fs =              =                =        1.72    >       1.25        OK !
                 SH            10.103
   b)-2 With Uplift
      Sliding force :           SH        =       10.103 ton
      Resistance :            HR = m x S W                 =       0.50    x      29.684     =      14.842   ton
           (friction coefficient : m =             0.50    )
                  HR           14.842
       Fs =              =                =        1.47    >       1.25        OK !
                  SH           10.103
   c) Reaction of foundation soil
              2xSW
       q1' =              =                                =         -     t/m2                      qae     =       -      t/m2
            3 x (B/2-|e|)
2.190 t/m2
- t/m2
         - t/m2                                                                            - t/m2
                   in case, e < 0 and |e| < B/6                                   in case, e < 0 and B/6 < |e| < B/3
                        (not applicable)                                                   (not applicable)
395816038.xls-08/30/2018
                                                                                                                                       Stability14/35
  2.4 Bearing Capacity of soil
(a x c x Nc) = 18.525
395816038.xls-08/30/2018
                                                                                                                                Structure15/35
  3. Structure Calculation
  3.1 Normal Condition
qa1
                                                   Pa1
               4.62                               Pa2
                                                                                  A               A                       0.9
                                                        qa2
                       0.00   Pw1        Pa4                                                                            Pw2         3.62
                                                         Pa3                  B                   B
               0.00                                                                                                           qw2
                                  qw1            qa4     qa3
               1.00                                                                                              1.00
d = 3.17 o
a) Section A - A
         h = 4.62      m
            K
      qa1 = ha  x q                                                           =          0.251 ton/m
      qa2 = Kha x h x gsoil                                                   =          5.749 ton/m
b) Section B - B
395816038.xls-08/30/2018
                                                                                                                                              Structure16/35
  (2) Footing
                              Case 1 (with vertical live load)                                         Case 2 (without vertical live load)
          q =      0.30       t/m2                                                                 q =         0.30          t/m2
                4.62                                                                    4.62
                                           4                                                                      4
                0.00                                                                    0.00
                                                     D            C                                                             D             C
                0.00                                                                    0.00
                1.00                                                                    1.00
                                           3                            1                                         3                                 1
                                                     D            C                                                             D             C
                                       1.50                1.80       0.50                                            1.50           1.80         0.50
                          5
                          4                                                                        4
                          3                                                                        3                                                     1
                                                                                   1
                                           6                                                                          6
     15.790                                                             2                                                                           2
     14.496            1.469 t/m2                                                              1.061 t/m2
                                      7.702 t/m2                                                                 7.460 t/m2
                                     15.181 t/m2                                                                15.139 t/m2
                                                         17.259 t/m2                                                                  17.272 t/m2
                                                                        2                                                                           2
                                       6                                                                         6
a) Section C - C
395816038.xls-08/30/2018
                                                                                                                                    Structure17/35
b) Section D - D
                                               Pa1                                  1        2   3
              4.62
                                                                                                                       4.62
                                                                                A                    A
                                                    qa1
                                                               Pa2
                      0.00   Pw1        Pa3                                                                                  Pw2         3.62
                                                                                B                    B
              0.00                                                                                                                 qw2
              1.00             qw1            qa3    qa2                                                               1.00
d = 2.38 o
a) Section A - A
        h =   4.62 m
     qa1 = hae x h x gsoil
           K                                                                =            5.976 t/m
    No.                           Description                                                                Hae       Y (from A-A) Hae x Y
     1       0.500 x          4.620 x 1.000                x     2.200      x       0.023                    0.117         1.540      0.180
     2       4.620 x          0.700 x 2.200                x     0.023                                       0.164         2.310      0.378
     3       0.500 x          4.620 x 0.100                x     2.200      x       0.023                    0.012         1.540      0.018
    Pa1      5.976 x          4.620 x 0.500                                                                 13.804         1.540     21.258
   Total                                                                                                    14.096                   21.834
395816038.xls-08/30/2018
                                                                                                                                        Structure18/35
b) Section B - B
  (2) Footing
                           in case, e < B/6                                                            in case, B/6 < e < B/3
             4.62                                                                       4.62
                                       4                                                                        4
             0.00                                                                       0.00
                                                 D             C                                                           D           C
             0.00                                                                       0.00
             1.00                                                                       1.00
                                       3                             1                                          3                           1
                                                 D             C                                                        D               C
                                    1.50                1.80       0.50                                      1.50              1.80         0.50
                       4                                                                          4
                       3                                                        1                 3                                                1
in case, e > 0 ande < B/6 in case, e > 0 and B/6 < e < B/3
                                       5                                                                               6
                                                                     2                                                                      2
                    2.190 t/m2                                                                                      - t/m2
                                  7.698 t/m2
                                 14.307 t/m2                                                                        - t/m2
                                                      16.143 t/m2                                                                     - t/m2
             in case, e < 0 and |e| < B/6                                               in case, e < 0 and B/6 < |e| < B/3
                                                                                                                                        2
                                                                     2                                          6
                                   6
395816038.xls-08/30/2018
                                                                                                       Structure19/35
a) Section C - C
b) Section D - D
395816038.xls-08/30/2018
                                                                                                                              Structure (2)20/35
  3. Structure Calculation
  3.1 Normal Condition
qa1
                                                   Pa1
               4.62                               Pa2
                                                                                  A               A                       0.9
                                                        qa2
                       0.00   Pw1        Pa4                                                                            Pw2           3.62
                                                         Pa3                  B                   B
               0.00                                                                                                            qw2
                                  qw1            qa4     qa3
               1.00                                                                                              1.00
d = 3.17 o
a) Section A - A
         h = 4.62      m
            K
      qa1 = ha  x q                                                           =          0.251 ton/m
      qa2 = Kha x h x gsoil                                                   =          5.749 ton/m
b) Section B - B
395816038.xls-08/30/2018
                                                                                                                                                Structure (2)21/35
  (2) Footing
                              Case 1 (with vertical live load)                                           Case 2 (without vertical live load)
          q =      0.30       t/m2                                                                   q =         0.30            t/m2
                4.62                                                                      4.62
                                             4                                                                        4
                0.00                                                                      0.00
                                                       D            C                                             E                 D              C
                0.00                 E                                                    0.00
                1.00                                                                      1.00
                                             3                            1                                           3                                 1
                                     E                 D            C                                             E                 D              C
                                         1.50                1.80       0.50                                              1.50           1.80          0.50
                          5
                          4                                                                          4
                          3                                                                          3                                                        1
                                                                                     1
                                             6                                                                            6
     15.790                                                               2                                                                             2
     14.496            1.469 t/m2                                                                1.061 t/m2
                                      7.702 t/m2                                                                   7.460 t/m2
      4.585                          15.181 t/m2                                                 4.261            15.139 t/m2
                                                           17.259 t/m2                                                                    17.272 t/m2
                                                                          2                                                                             2
                                         6                                                                            6
a) Section C - C
395816038.xls-08/30/2018
                                                                                                                                   Structure (2)22/35
c) Section E - E
                                               Pa1                                  1        2   3
              4.62
                                                                                                                       4.62
                                                                                A                    A
                                                    qa1
                                                               Pa2
                      0.00   Pw1        Pa3                                                                                  Pw2           3.62
                                                                                B                    B
              0.00                                                                                                                  qw2
              1.00             qw1            qa3    qa2                                                               1.00
d = 2.38 o
a) Section A - A
        h =   4.62 m
     qa1 = hae x h x gsoil
           K                                                                =           5.976 t/m
    No.                           Description                                                                Hae       Y (from A-A) Hae x Y
     1       0.500 x          4.620 x 1.000                x     2.200      x       0.023                    0.117         1.540      0.180
     2       4.620 x          0.700 x 2.200                x     0.023                                       0.164         2.310      0.378
     3       0.500 x          4.620 x 0.100                x     2.200      x       0.023                    0.012         1.540      0.018
    Pa1      5.976 x          4.620 x 0.500                                                                 13.804         1.540     21.258
   Total                                                                                                    14.096                   21.834
395816038.xls-08/30/2018
                                                                                                                                       Structure (2)23/35
b) Section B - B
  (2) Footing
                            in case, e < B/6                                                            in case, B/6 < e < B/3
             4.62                                                                        4.62
                                        4                                                                        4
             0.00                                                                        0.00
                                                  D             C                                                           D            C
             0.00                                                                        0.00
             1.00                                                                        1.00
                                        3                             1                                          3                            1
                                                  D             C                                                        D                C
                                    1.50                 1.80       0.50                                      1.50              1.80          0.50
                       4                                                                           4
                       3                                                         1                 3                                                 1
in case, e > 0 ande < B/6 in case, e > 0 and B/6 < e < B/3
                                        5                                                                               6
                                                                      2                                                                       2
                    2.190 t/m2                                                                                       - t/m2
                                   7.698 t/m2
                    4.944         14.307 t/m2                                                                        - t/m2
                                                       16.143 t/m2                                                                      - t/m2
             in case, e < 0 and |e| < B/6                                                in case, e < 0 and B/6 < |e| < B/3
                                                                                                                                          2
                                                                      2                                          6
                                    6
395816038.xls-08/30/2018
                                                                                                 Structure (2)24/35
a) Section C - C
b) Section E - E
395816038.xls-08/30/2018
                                                                                                                                  Re-bar 25/35
 Normal Condition
Name of Structure            :     D1 - Hulu
Location                     :     SUNGAI CIRASEA KAB. BANDUNG
R-bar arrangement 25~200 16~250 25~100 16~125 16~250 16~250 25~100 16~250
Reinforcement               As      cm2        24.54         8.04        49.09          16.08    8.04           8.04      49.09         8.04
Perimeter of R-bar          U        cm        39.27          ok         78.54           ok      20.11           ok       78.54          ok
395816038.xls-08/30/2018
                                                                                                                               Re-bar 26/35
Seismic Condition
Name of Structure            :     D1 - Hulu
Location                     :     SUNGAI CIRASEA KAB. BANDUNG
R-bar arrangement 25~200 16~250 25~100 16~125 16~250 16~250 25~100 16~250
Reinforcement               As      cm2        24.54          8.04      49.09        16.08     8.04          8.04      49.09         8.04
Perimeter of R-bar          U        cm        39.27                    78.54                  20.11                   78.54
Distribution bar (>As/6 and >Asmin)           16~250         16~250    16~125        16~250   16~200        16~200    16~200        16~200
Reinforcement              As     cm2          8.04           8.04      16.08         8.04     10.05         10.05     10.05         10.05
395816038.xls-08/30/2018
                                                                                                        Re-bar 27/35
395816038.xls-08/30/2018
                                                                                          Re-bar 28/35
                                                                           100.0
                                                                             7.0
                                                                            93.0
                                                                           100.0
                                                                              16
0.71
25~200 16~250
                                                                        24.54          8.04
                                                                        39.27
23.38
                                                                                1.7
                                                                               90.0
                                                                         ok
                                                                             80
                                                                          2,775
                                                                         ok
                                                                            0.44
                                                                            8.25
                                                                         ok
                                                                       3,264,561
                                                                       3,264,561
                                                                              16
                                                                           2,984
                                                                       4,895,978
                                                                              20
                                                                             114
                                                                       16~200         16~300
                                                                        10.05          6.70
395816038.xls-08/30/2018
                           Reinforcement Bar Arrangement
                            (        D1 - Hulu       )
+ 672.53
                                D25~200
                   7.53                                            D16~250
                                                                     D16~250
          5.62                D16~250
                                        A                    A
                              D25~100                            D16~125
                                                                   D16~250
                           D16~125
                       D16~200                                   D16~200
           -1.91   D25~100                               C           D16~250          + 667.91
                                            D
                                        B                        B             0.00
                                                                               1.00
                                                                                      + 666.91
                   D16~250                  D          C
                       D16~200                   D16~250                 D16~200
3.80
                                concrete         =      10    m3
                                reinforcement    =     484 kg
                                cost estimate    =     3,830,000
395816038.xls-08/30/2018
4. Wooden Pile
(safety factor : n = 2)
                                     Ha            0.000
      Spacing of pile        =                =             =      0.00         m
                                      Hr           8.792
                                     qa            6.042
      Spacing of pile        =                =             =      0.35         m
                                       V           17.259
                                     qa            6.042
      Spacing of pile        =                =             =      0.25         m
                                     Vp            24.063
ton/m
m ),
m ),
12th Oct, Stability Analysis
            Uplift pressure are added for stability analysis.
           Structure
             Calculation formula in case of (B/6 < e < B/3) under seismic condition are corrected.
             (distributed width of reaction of foundation soil)
https://dokumen.tips/documents/perhitungan-koefisien-gempa.html