Number of Pile Calculation
Number of Pile Calculation
                                                         Allowable geotechnical Capacityagainst uplif = (shaf fiction in soil + shalf friction in rock )/2.5 + pile self weigth /1.2                                                                                                                                                                                                     7917
                                           Note :        * Base on bore Hole 3
                                                         ** friction + pile self weigth/1.2
              (1)       (2)      (3)       (4)                                (5)            (6) (7)       (8)        (9)                           (10)                          (11)           (12)            (13)            (14)         (15)        (16)       (17)                       (18)         (19)        (20)       (21)                       (22)
Column      Imposed Dead Load Imposed Live Load                                               Load From Base Slab                                                             No of Pile Required Base on                      No of Piles with uplif force considere                         No of Piles with uplif force considere
Pile group Roof to   Roof to  Roof to Roof to                            Tributary Slab      Imposed Imposed Ground                              Uplif             Proposed         buiding Load only                          (Tube well dismantle when building completed)                  (Tube well dismantle upon G.F. completed)
           B3        GF       B3      GF                                 area      Thickness Dead      Live       Water                          Force                Pile  Total      Pile       No                           Net            capacity      No of            No of            Dead          Net           capacity         No of            No of
                                                                                             load      Load       Pressure                                            dia   Service    Capacity of Pile                        uplif          against       Tension          Piles            Load          Up lif        against          Tension          Piles
               kN            kN            kN            kN              m2           mm              kN           kN              Head                                        Load                           required force        Uplif                   Piles    Required kN            Force     Uplif                                Piles     Required
                                                                                                      (5)x(6)x24   (5)x2.5         m             (5)x(9)x9.8                   (1)+(3)+(7)+(8)                (11)/(12) (10)-((1)+(7))0.75                  Required (larger of (1)-(2)+(7) (10)-(18) (15)                                 (19)/(20) (larger of
                                                                                                                                                                                                                                                            (14)/(15)        (13) and (16)            75%                                                   (13) and (21)
1C67                  6516          6279          2203         2178               0             500            0             0             9.9              0      1050-1%           8719          5196                 1.68        -4887           1732          -2.82                2.00           178         -178          1732               -0.10            1.68
1C68                  6237          6083          2146         2118               0             500            0             0             9.9              0      1050-1%           8383          5196                 1.61        -4678           1732          -2.70                2.00           116         -116          1732               -0.07            1.61
1C69                  4616          3915          1670         1395           41.59             500          499           104             9.9           4035      900-1%            6889          3959                 1.74          199           1273           0.16                2.00           900         3135          1273                2.46            2.46
1C71                  4412          3810          1573         1357           41.59             500          499           104             9.9           4035      900-1%            6588          3959                 1.66          352           1273           0.28                2.00           826         3209          1273                2.52            2.52
1C70                  6364          5528          2368         2037              44             500          528           110             9.9           4269      1050-1%           9370          5196                 1.80         -900           1732          -0.52                2.00          1023         3246          1732                1.87            1.87
1CW20                11493          9589          3989         3421           64.57             500          775           161             9.9           6265      1050-1%          16418          5196                 3.16        -2936           1732          -1.70                4.00          2009         4255          1732                2.46            3.16
1C72                  6272          5617          2268         2049              44             500          528           110             9.9           4269                                                                        -831                                                             887                                                           0.00
1C40                  3279          2727           882          751           24.34             500          292            61             9.9           2361      900-1%            4514          3959                1.14          -317           1273          -0.25                2.00           633         1728          1273                 1.36           1.36
1C41                  4217          3663          1224         1103           24.34             500          292            61             9.9           2361      900-1%            5794          3959                1.46         -1020           1273          -0.80                2.00           635         1727          1273                 1.36           1.46
1C83                  6227          5768          2259         2177            21.1             500          253            53            11.4           2357      1050-1%           8792          5196                1.69         -2503           1732          -1.44                2.00           534         1823          1732                 1.05           1.69
1C137                 3189          2772           889          807           11.38             500          137            28            11.4           1271      900-1%            4243          3959                1.07         -1223           1273          -0.96                2.00           416          856          1273                 0.67           1.07
1C84                  6168          5844          2292         2295           15.53             500          186            39            11.4           1735      1050-1%           8685          5196                1.67         -3030           1732          -1.75                2.00           383         1353          1732                 0.78           1.67
1C76                  6964          6083          2428         2153           32.35             500          388            81            11.4           3614      1050-1%           9861          5196                1.90         -1900           1732          -1.10                2.00           952         2662          1732                 1.54           1.90
1C80                  2980          2697           724          603           18.98             500          228            47            11.4           2120      900-1%            3979          3959                1.01          -286           1273          -0.22                2.00           383         1737          1273                 1.36           1.36
1C86                  4541          4452          1260         1199           18.98             500          228            47            11.4           2120      900-1%            6076          3959                1.53         -1456           1273          -1.14                2.00           238         1883          1273                 1.48           1.53
1C87                  6562          5838          2423         2223           32.35             500          388            81            11.4           3614      1050-1%           9454          5196                1.82         -1598           1732          -0.92                2.00           834         2780          1732                 1.61           1.82
1C24                  5790          4965          1731         1247           33.47             500          402            84            11.4           3739      1050-1%           8007          5196                1.54          -905           1732          -0.52                2.00           920         2819          1732                 1.63           1.63
1C47                  6450          5803          1550         1295           26.32             500          316            66            11.4           2940      1050-1%           8382          5196                1.61         -2134           1732          -1.23                2.00           722         2218          1732                 1.28           1.61
1C48                  6296          5737          1532         1289           26.32             500          316            66            11.4           2940      1050-1%           8210          5196                1.58         -2019           1732          -1.17                2.00           656         2284          1732                 1.32           1.58
1C25                  5471          4844          1694         1423           33.47             500          402            84            11.4           3739      900-1%            7651          3959                1.93          -665           1273          -0.52                2.00           772         2968          1273                 2.33           2.33
1C26                  5720          5486          1926         1869            20.4             500          245            51            11.4           2279      900-1%            7942          3959                2.01         -2195           1273          -1.72                3.00           359         1920          1273                 1.51           2.01
1C27                  4881          4559          1375         1309              13             500          156            33            11.4           1452      900-1%            6445          3959                1.63         -2325           1273          -1.83                2.00           359         1094          1273                 0.86           1.63
1C28                  4764          4532          1365         1311              13             500          156            33            11.4           1452      900-1%            6318          3959                1.60         -2238           1273          -1.76                2.00           291         1161          1273                 0.91           1.60
1C29                  5484          5291          1943         1873            20.4             500          245            51            11.4           2279      900-1%            7723          3959                1.95         -2018           1273          -1.58                2.00           329         1951          1273                 1.53           1.95
1C82                  6010          5288          1877         1605              28             500          336            70            11.4           3128      1050-1%           8293          5196                1.60         -1631           1732          -0.94                2.00           794         2335          1732                 1.35           1.60
1C81                  8618          7293          3060         2535           52.64             500          632           132            11.4           5881      1050-1%          12442          5196                2.39         -1057           1732          -0.61                3.00          1468         4413          1732                 2.55           2.55
1C85                  9251          7177          3820         2562           52.64             500          632           132            11.4           5881      1050-1%          13835          5196                2.66         -1531           1732          -0.88                3.00          2030         3851          1732                 2.22           2.66
1C88                  6423          5416          2338         1700              30             500          360            75            11.4           3352      1050-1%           9196          5196                1.77         -1736           1732          -1.00                2.00          1025         2326          1732                 1.34           1.77
1C43                  3146          2725           724          595           24.87             500          298            62            11.4           2778      900-1%            4230          3959                1.07           195           1273           0.15                2.00           539         2239          1273                 1.76           1.76
1C44                  3324          2764           690          603           24.87             500          298            62            11.4           2778      900-1%            4374          3959                1.10            62           1273           0.05                2.00           644         2135          1273                 1.68           1.68
                                                                                                                                                                                                                      49.40
1W9      2396    2213    491    555                                                        2887                  -1797   1273   -1.41             137
1W10     5636    4263   1124    880                                                        6760                  -4227   1273   -3.32            1030
1W11     2420    1624    475    245                                                        2895                  -1815   1273   -1.43             597
1W12     5498    4613   1110    972                                                        6608                  -4124   1273   -3.24             664
        15950   12713   3200   2652   57.44   800   1103   144   13.6   7656 900-1%       20397   3959    5.15   -5134   1273   -4.03    6.00    3237   4419    1273   3.47     5.15
1W33     1898            175          17.48   800    336    44    9.9   1696               2453   1979    1.24      20   566     0.04    1.24    1676      20    566    0.04    1.24
1W34     2028            244          18.83   800    362    47    9.9   1827 600 -1%       2681   1979    1.35      34   566     0.06    1.35    1793      34    566    0.06    1.35
1W35     2278            276          17.48   800    336    44    9.9   1696 600 -1%       2934   1979    1.48    -265   566    -0.47    1.48    1961    -265    566   -0.47    1.48
                                                                                                          4.08                           4.08
1W36     2124            191          10.94   800    210    27    9.9   1061   600 -1%     2552   1979    1.29    -689   566    -1.22    1.29    1751    -689    566   -1.22    1.29
1W37     2992            264          20.01   800    384    50    9.9   1941   600 -1%     3690   1979    1.86    -591   566    -1.04    1.86    2532    -591    566   -1.04    1.86
1W71     1722            156          12.57   800    241    31    9.9   1220   600 -1%     2150   1979    1.09    -253   566    -0.45    1.09    1472    -253    566   -0.45    1.09
1W69     1890            180          12.61   800    242    32   11.4   1409   600 -1%     2344   1979    1.18    -190   566    -0.34    1.18    1599    -190    566   -0.34    1.18
1W70     3522            376             24   800    461    60   11.4   2681   600 -1%     4419   1979    2.23    -306   566    -0.54    2.23    2987    -306    566   -0.54    2.23
1W93     3907            490           23.4   800    449    59   11.4   2614   600 -1%     4905   1979    2.48    -653   566    -1.15    2.48    3267    -653    566   -1.15    2.48
                                                                                          20060          10.14   -2681                  10.14   13608   -2681                  10.14
1C104 2205 298 0 800 0 0 11.4 0 600 -1% 2503 1979 1.26 -1654 566 -2.92 2.00 1654 -1654 566 -2.92 1.26
1W94      449             60          11.03   800    212    28   11.4   1232 600 -1%        749   1979    0.38     737   566     1.30    1.30     496     737    566    1.30    1.30
1W95     3596            472          18.18   800    349    45   11.4   2031 600 -1%       4462   1979    2.25    -928   566    -1.64    2.25    2959    -928    566   -1.64    2.25
1C101 479 60.6 0 800 0 0 11.4 0 600 -1% 540 1979 0.27 -359 566 -0.63 0.27 359 -359 566 -0.63 0.27
1W96     3180            383             16   800    307    40   11.4   1788 600 -1%       3910   1979    1.98    -828   566    -1.46    1.98    2615    -828    566   -1.46    1.98
1W92     2518            269          15.91   800    305    40   11.4   1777 600 -1%       3132   1979    1.58    -340   566    -0.60    1.58    2117    -340    566   -0.60    1.58
1W91     2369            214          13.42   800    258    34   11.4   1499 600 -1%       2875   1979    1.45    -471   566    -0.83    1.45    1970    -471    566   -0.83    1.45
                                                                                           9916           5.01   -1638          -2.89            6703   -1638          -2.89    5.01
1W90     2012            171          11.95   800    229    30   11.4   1335   600 -1%     2442   1979    1.23    -346   566    -0.61    1.23    1681    -346    566   -0.61    1.23
1W89     1885            174          14.11   800    271    35   11.4   1576   600 -1%     2365   1979    1.20     -41   566    -0.07    1.20    1617     -41    566   -0.07    1.20
1W88     1915            186          14.84   800    285    37   11.4   1658   600 -1%     2423   1979    1.22       8   566     0.01    1.22    1650       8    566    0.01    1.22
1W87     3155            315          24.78   800    476    62   11.4   2768   600 -1%     4008   1979    2.03      45   566     0.08    2.03    2723      45    566    0.08    2.03
1W86     2000            196          16.11   800    309    40   11.4   1800   600 -1%     2545   1979    1.29      68   566     0.12    1.29    1732      68    566    0.12    1.29
                                                                                          13783           6.96    -265          -0.47    6.96    9403    -265                   6.96
1W85     1339            125          10.33   800    198    26   11.4   1154   600 -1%     1688   1979    0.85       1   566     0.00    0.85    1153       1    566    0.00    0.85
1W84     1683            143          12.82   800    246    32   11.4   1432   600 -1%     2104   1979    1.06     -14   566    -0.03    1.06    1447     -14    566   -0.03    1.06
1W83     1678            120           8.95   800    172    22   11.4   1000   600 -1%     1992   1979    1.01    -388   566    -0.68    1.01    1388    -388    566   -0.68    1.01
1W82     1122             62           8.96   800    172    22   11.4   1001   600 -1%     1378   1979    0.70      31   566     0.05    0.70     971      31    566    0.05    0.70
                                                                                           7163           3.62    -370          -0.65    3.62    4958    -370          -0.65    3.62
1W81     1480             96          10.08   800    194    25   11.4   1126   600 -1%     1795   1979    0.91    -129   566    -0.23    0.91    1256    -129    566   -0.23    0.91
1W80     1439            130           9.03   800    173    23   11.4   1009   600 -1%     1765   1979    0.89    -200   566    -0.35    0.89    1209    -200    566   -0.35    0.89
1W79     1352            142           9.13   800    175    23   11.4   1020   600 -1%     1692   1979    0.85    -125   566    -0.22    0.85    1145    -125    566   -0.22    0.85
1W78     1467            169           7.89   800    151    20   11.4    881   600 -1%     1807   1979    0.91    -332   566    -0.59    0.91    1214    -332    566   -0.59    0.91
1W77     1813            222           9.36   800    180    23   11.4   1046   600 -1%     2238   1979    1.13    -449   566    -0.79    1.13    1495    -449    566   -0.79    1.13
                                                                                           9297           4.70   -1236          -2.18    4.70    6318   -1236          -2.18    4.70
1C106    474     59      0    800     0     0   11.4      0 600 -1%       533   1979   0.27    -356   566    -0.63    0.27   356     -356    566   -0.63     0.27
1W76 4012 522 22.22 800 427 56 11.4 2482 600 -1% 5017 1979 2.53 -847 566 -1.50 2.53 3329 -847 566 -1.50 2.53
1CW97   1134    155     7.1   800   136    18   11.4    793 600 -1%      1443   1979   0.73    -159   566    -0.28    0.73   953     -159    566   -0.28     0.73
1CW74    630     87       2   800    38     5   11.4    223 600 -1%       760   1979   0.38    -278   566    -0.49    0.38   501     -278    566   -0.49     0.38
1W73    3754    500   16.95   800   325    42   11.4   1894 600 -1%      4621   1979   2.34   -1166   566    -2.06    2.34   3059   -1166    566   -2.06     2.34
1W72    3859    476    21.9   800   420    55   11.4   2447 600 -1%      4810   1979   2.43    -763   566    -1.35    2.43   3209    -763    566   -1.35     2.43
1W75    2098    242   11.97   800   230    30   11.4   1337 600 -1%      2600   1979   1.31    -409   566    -0.72    1.31   1746    -409    566   -0.72     1.31
                                                                        12031          6.08   -2337                   6.08   8015   -2337          -4.13     6.08
1C90     293     33      0    800     0     0   11.4      0 600 -1%       326   1979   0.16    -220   566    -0.39    0.16   220     -220    566   -0.39     0.16
1C91     252     10      0    800     0     0   11.4      0 600 -1%       262   1979   0.13    -189   566    -0.33    0.13   189     -189    566   -0.33     0.13
1W68    1622     70   12.27   800   236    31    9.9   1190 600 -1%      1959   1979   0.99    -203   566    -0.36    0.99   1394    -203    566   -0.36     0.99
1W67    2902    184    20.1   800   386    50    9.9   1950 600 -1%      3522   1979   1.78    -516   566    -0.91    1.78   2466    -516    566   -0.91     1.78
1W66    2157    206   11.31   800   217    28    9.9   1097 600 -1%      2608   1979   1.32    -683   566    -1.21    1.32   1781    -683    566   -1.21     1.32
                                                                         8089          4.09   -1402          -2.48    4.09   5640   -1402          -2.48     4.09
1C103   6233   2063      40   800   768   100   11.4   4469   1050-1%    9164   5196   1.76   -782    1732   -0.45    1.76   5251   -782    1732   -0.45     1.76
1C100   5647   1967      40   800   768   100   11.4   4469   1050-1%    8482   5196   1.63   -342    1732   -0.20    1.63   4811   -342    1732   -0.20     1.63
1C102   3476   1080      23   800   442    58   11.4   2570   900-1%     5056   3959   1.28   -369    1273   -0.29    1.28   2939   -369    1273   -0.29     1.28
1C99    3693   1307      23   800   442    58   11.4   2570   900-1%     5500   3959   1.39   -532    1273   -0.42    1.39   3101   -532    1273   -0.42     1.39
1C129   1192    522    29.7   800   570    74   11.4   3318   600 -2%    2358   1979   1.19   1997    1131    1.77    1.77   1322   1997    1131    1.77     1.77
1C125   1752    748    40.4   800   776   101   11.4   4513   600 -2%    3377   1979   1.71   2617    1131    2.31    2.31   1896   2617    1131    2.31     2.31
1C126   1047    394      25   800   480    63   11.4   2793   600 -2%    1984   1979   1.00   1648    1131    1.46    1.46   1145   1648    1131    1.46     1.46
1C127    911    343      25   800   480    63   11.4   2793   600 -2%    1797   1979   0.91   1750    1131    1.55    1.55   1043   1750    1131    1.55     1.55
1C128   1877   1193    40.4   800   776   101   11.4   4513   600 -2%    3947   1979   1.99   2524    1131    2.23    2.23   1990   2524    1131    2.23     2.23
1C130   1225    820    29.7   800   570    74   11.4   3318   600 -2%    2689   1979   1.36   1972    1131    1.74    1.74   1346   1972    1131    1.74     1.74
1C117   1443    623    33.5   800   643    84   11.4   3743   600 -2%    2793   1979   1.41   2178    1131    1.93    1.93   1565   2178    1131    1.93     1.93
1C142   1280    552    33.7   800   647    84   11.4   3765   600 -2%    2563   1979   1.30   2320    1131    2.05    2.05   1445   2320    1131    2.05     2.05
1C134   1068    430    25.1   800   482    63   11.4   2804   600 -2%    2043   1979   1.03   1642    1131    1.45    1.45   1163   1642    1131    1.45     1.45
1C131   1732    772      49   800   941   123   11.4   5474   600 -2%    3568   1979   1.80   3470    1131    3.07    3.07   2005   3470    1131    3.07     3.07
1C49    1544    588   41.23   800   792   103   11.4   4606   600 -2%    3027   1979   1.53   2854    1131    2.52    2.52   1752   2854    1131    2.52     2.52
1C133   2478    804    51.5   800   989   129   11.4   5754   600 -2%    4400   1979   2.22   3153    1131    2.79    2.79   2600   3153    1131    2.79     2.79
1C141    853    350   20.71   800   398    52   11.4   2314   600 -2%    1653   1979   0.84   1375    1131    1.22    1.22    938   1375    1131    1.22     1.22
1C139    491    125   25.37   800   487    63   11.4   2834   600 -2%    1166   1979   0.59   2101    1131    1.86    1.86    734   2101    1131    1.86     1.86
1C89    1549    835   44.75   800   859   112    9.9   4342   600 -2%    3355   1979   1.70   2536    1131    2.24    2.24   1806   2536    1131    2.24     2.24
1C138    626    170   25.37   800   487    63   11.4   2834   600 -2%    1346   1979   0.68   2000    1131    1.77    1.77    835   2000    1131    1.77     1.77
1C58     283     72   21.08   800   405    53   11.4   2355   600 -2%     813   1979   0.41   1839    1131    1.63    1.63    516   1839    1131    1.63     1.63
1C59     290     76   13.63   800   262    34   11.4   1523   600 -2%     662   1979   0.33   1109    1131    0.98    0.98    414   1109    1131    0.98     0.98
1C60     322     96   20.53   800   394    51   11.4   2294   600 -2%     863   1979   0.44   1757    1131    1.55    1.55    537   1757    1131    1.55     1.55
1C61     450    131   13.14   800   252    33   11.4   1468   600 -2%     866   1979   0.44    942    1131    0.83    0.83    527    942    1131    0.83     0.83
1C62     690    350   38.41   800   737    96   11.4   4291   600 -2%    1873   1979   0.95   3221    1131    2.85    2.85   1070   3221    1131    2.85     2.85
1C63     639    325   38.41   800   737    96   11.4   4291   600 -2%    1797   1979   0.91   3259    1131    2.88    2.88   1032   3259    1131    2.88     2.88
                                                                                                                     48.73                                 143.31