perhitungan excel

Upload: nadi-kurnia-a-f

Post on 09-Jan-2016

144 views

Category:

Documents


22 download

DESCRIPTION

Apa aja bole

TRANSCRIPT

Sheet1Non Gempafy420MpaH14mNo.z (m)Output Stress AbaqusTmax Abaqus (kN)SFSyarat (>1,8)Preliminary Designc11kPaSpesifikasiSimbolNilaiSatuanTinggi DindingH14m30derajatTinggi dindingH14m11.519020.412.56335460827.3390675275OKSpacingSh1mGaya Aksial yang DibutuhkanJenis Nailing-Grouting-2319252.712.71679340427.0091987098OKSv1.5mKa0.422170.333Jarak antar nail barsSv1,5m34.549470.432.67618860810.5113360717OKNail Inclinationi20derajatT maxERROR:#REF!kNSh1m4660919.140.2382839328.5359107406OKNail Materialfy420MpaAtERROR:#REF!Kemiringan nail barsi20derajat5889921.559.394949185.7828216834OKSurchargeq31.2kPaERROR:#REF!mm2660.5198554173Diameter lubang drillDdh100mm69.513610189.897432523.8206919861OKrERROR:#REF!mm14.5Surchargeqs31,2kN71114429895.311714963.6036535503OKDERROR:#REF!mm812.5235491155.546515322.2081523285OKDpakai29mm0.00066052Panjang pakai9.8m10m343.4704Sudut inklinasi20derajat1,15Gempa43.98No.z (m)Output Stress AbaqusTmax Abaqus (kN)SFSyarat (>1,35)No.z (m)LP (m)RP (kN)Output Stress AbaqusTmax Abaqus (kN)SFSyarat (>2)Material nail barsfy517MPaMaterial nail headfy250MPaKeteranganMass density (ton/m3)Modulus Young (E) - kPaPoisson's Ratio (v)Mohr - Coulomb11.540808.926.95509462812.7423184648OK11.53.0216338036132.891454680219020.412.56335460810.5777046678OKMaterial beton groutingfc'20,75MPac (kPa)'2369294.245.7702049847.5042355637OK234.4590377471196.108480118619252.712.71679340415.4212208918OKEekivClayey Sand (SC)1,8300000,3113034.584357.855.7200140566.1642195505OK34.55.8964416907259.325505556949470.432.6761886087.9362225708OKTimbunan (Gravelly Sand/SW)2,030000 (loose)0,355404610550669.688823124.9286296514OK467.3338456343322.542530995360919.140.2382839328.0158122931OKDia. Lubang10cmRock2,01,4 x 1060,32505058156005103.04442263.3332264992OK589.2503842257406.831898246589921.559.394949186.8496042822OK0.1m69.5223620147.70548242.3253734013OK69.510.6877881693470.048923684913610189.897432525.2287246755OKLuas lubang0.0078539816m2711218947144.618872442.3750039964OK71112.1251921129533.265949123214429895.311714965.5949675163OKAgERROR:#REF!m2Line Loadx (dari tepi)zqz812.5313581207.126522121.6582637341OK812.513.5625960564596.4829745616235491155.546515323.8347562678OKAn0.0006605199m2A5.8514.531.215.00197781011.3522AERROR:#REF!m2B9.6214.531.22.3514325284OKEg30000000kPaTotal17.3534103385not OKEn200000000kPa0.3331810EekivERROR:#REF!zx1x2z1z1za1.55.859.62145.019118830922.7305144417167.749633272594.4886278798201514602.55.859.6287.011471298513.638308665100.649779963572.1443767279No.z (m)LP (m)RP (kN)Output Stress AbaqusTmax Abaqus (kN)SFSyarat (>1,5)Gempa3.55.859.6262.15105092759.741649046471.892699973962.5682690913No.z (m)Output Stress AbaqusTmax Abaqus (kN)SF4.55.859.6248.3397062777.576838147255.916544424257.248209293311.53.0216338036132.891454680240808.926.9550946284.9301052923OK5.55.859.6239.55066877216.199231211445.749899983453.8627166945234.4590377471196.108480118669294.245.7702049844.2846318951OK11.540808.926.95509462812.74231846481814.56.55.859.6233.46595049945.245503332738.711453832151.518914126134.55.8964416907259.325505556984357.855.7200140564.6540818403OK2369294.245.7702049847.5042355637ae56.2978092426Pae408.159117009kN7.55.859.6229.00382376624.546102888333.549926654549.800125576467.3338456343322.542530995310550669.688823124.6283251252OK34.584357.855.7200140566.1642195505ue68.5407392426Pue496.920359509kN8.55.859.6225.59160920544.011267254429.602876459948.4857578611589.2503842257406.8318982465156005103.04442263.9481214799OK4610550669.688823124.9286296514Pae total905.079476518kN9.55.859.6222.89775560493.589028596126.486784200947.448099138969.510.6877881693470.0489236849223620147.70548243.1823390442OK58156005103.04442263.3332264992Momen Pae1972.7690655435kN.m10.55.859.6220.71701697583.247216348823.964233324646.608089697171112.1251921129533.2659491232218947144.618872443.6873883756OK69.5223620147.70548242.3253734013Momen Pue2401.7817376268kN.mMa1972.769065543511.55.859.6218.91553723882.964849709821.880386948645.9141688539812.513.5625960564596.4829745616313581207.126522122.879800078OK711218947144.618872442.3750039964 Mtotal4374.5508031703kN.mMu2401.781737626812.55.859.6217.40229425972.72766173320.129955992745.3312753456812.5313581207.126522121.65826373415.8324968315da5.8324968315mM04374.550803170313.55.859.6216.11323542572.525612715718.638848141444.834736431114.55.859.6215.00197781012.351432528417.353410338544.4066856427 air10kN/m3 tanah saturated18kN/m3Ka0,333

Sheet2BarisKolom 1BarisKolom 2BarisKolom 3BarisKolom 4BarisKolom 5BarisKolom 6BarisKolom 7BarisKolom 811111111211489.12216463.322222333317825.2333344444444555517758.45555611469.7666666677716461.1777778888888822254.199999999KolomS11Tmax (kN)123456789

Sheet3No.H (m)L (m)A (m2) gabion (kN/m3)Wg (kN)xiAxi111.523206013.540.52122204012.5253122204011.523KeteranganSimbolNilaiSatuan4122204010.521Tebal DindingT2m512220409.519Panjang ReinforcemenetB10m612220408.517Backfill Slope Angle0derajat712220407.515Soil Backfill Friction Angle'40derajat812220406.513Soil Backfill Cohesionc5kN/m2912220405.5111012220404.591112220403.571212220402.55KeteranganSimbolNilaiSatuan1312220401.53Modulus ElastisitasE1,4 x 105kPa1412220400.51Poisson Ratio0,3-Total14.52958098209.5Berat Jenis20kN/m3L penanaman wiremeshLp14mH gabionHg1mL gabionLg2mH susunan gabion (tinggi dinding)H14,5mNo.A tanah WsxiAxi

114.42818259.7047.764112.018992214.42818259.7047.764112.018992Tipe8 x 10/ZN314.42818259.7047.764112.018992D in. (mm)3,25 (83)414.42818259.7047.764112.018992Tolerance10%514.42818259.7047.764112.018992Wire Dia in. (mm)0,12 (3,05)614.42818259.7047.764112.018992Lacing Wire in. (mm)0,087 (2,2)714.42818259.7047.764112.018992Mesh Wire in. (mm)0,12 (3,05)814.42818259.7047.764112.018992Mesh Tensile Strength 51,1 kN/m (3500 lb/ft)914.42818259.7047.764112.018992Punch Test26,7 kN (6000 lb)1014.42818259.7047.764112.018992Connecion to Selvedges 20,4 kN/m (1400 lb/ft)1114.42818259.7047.764112.0189921214.42818259.7047.764112.0189921314.42818259.7047.764112.0189921414.42818259.7047.764112.018992Total201.9923635.856108.6961568.265888

Sheet451.50.0000502655180.33314,510OKnot OKNo.z (m)Stress AbaqusTmaxSFNo.z (m)FvTmax LLa1La2LeLemLe>Lem11.543567321.89931353872.351671887311.52721.8993135387140.8314.356.8192.2309132299OK22.543214621.72202718212.370865277422.54521.7220271821141.3854.356.2651.3277116948OK33.542768121.49759180292.395617168333.56321.4975918029141.944.355.710.9385668358OK44.542349021.28692916592.419325004544.58121.2869291659142.4944.355.1560.7228429302OK55.548217024.23650767652.12489359855.59924.2365076765143.0484.354.6020.673365386OK66.555696927.99631549881.839527776566.511727.9963154988143.6034.354.0470.6581592038OK77.562880131.60698563471.629386636177.513531.6069856347144.1574.353.4930.6439694311OK88.568522134.4429641551.495225549488.515334.442964155144.7113.63.6890.6191915635OK99.562410331.37083839811.641652012899.517131.3708383981145.26633.7340.5045985018OK1010.560896930.61012058661.68245008561010.518930.6101205866145.822.43.780.4454707343OK1111.559331329.82316419331.72684560451111.520729.8231641933146.3741.83.8260.3962774098OK1212.552222126.24969051441.96192789291212.522526.2496905144146.9281.23.8720.3208910549OK1313.535655017.92215777022.87353792221313.524317.9221577702147.4830.63.9170.2028616549OK1414.523736511.93126624354.31639014241414.526111.9312662435148.03703.9630.1257366749OK

Stress Abaqus352879354155348803370874404262433217467351518660544409613384638315651591668601676612

Sheet5

Tipe PekuatanSF GlobalStatikSeismikSoil Nailing2,61,13Reinforced Gabion1,721,24

Tipe PerkuatanKeteranganKeuntunganKekuranganReinforced GabionHasil analisis perhitungan dan output Abaqus CAE 6.14Pada kondisi gempa, memberikan angka keamanan yang lebih aman, yakni 1,24Pada kondisi statik saja, memberikan angka keamanan yang lebih kecil, yakni 1,72

Soil Nailing