form sudut geser tanah fix (recovered)

Post on 15-Sep-2015

313 Views

Category:

Documents

20 Downloads

Preview:

Click to see full reader

DESCRIPTION

form excel mekanika tanah bab sudu geser tanah

TRANSCRIPT

Sheet1UJI GESER LANGSUNG

DIAMETER CINCIN (cm) =6.350TINGGI CINCIN (cm) =2.200Waktu (detik)SAMPEL SAMPEL 2SAMPEL 3P = 3 kgP = 6 kgP = 9 kgP = 3 kgP = 6 kgP = 9 kgP = 3 kgP = 6 kgP = 9 kgPembacaan arloji beban geserPembacaan arloji beban geserPembacaan arloji beban geser0.0000.0000.0000.0000.0000.0000.0000.0000.0000.00015.0002.2082.7183.1157.0008.0008.0006.0007.0008.00030.0002.2662.8313.1727.5008.0009.0007.0008.0009.00045.0002.4352.8313.1728.0008.5009.5008.0009.0009.50060.0002.4352.8883.2858.5009.00010.0008.5009.50010.00075.0002.6612.9453.2859.0009.50011.0009.0009.50011.00090.0002.7192.9453.2859.50010.00012.0009.80010.00012.000105.0002.7193.1153.4459.50011.00013.00010.00010.00013.000120.0002.8883.1723.45510.00011.00014.00010.00011.00014.000135.0002.9453.2853.68110.00011.50015.00011.00012.00015.000150.0002.9453.4453.96510.00011.00014.00010.50011.00014.000165.0002.7193.4454.24810.00011.00014.00010.50011.00014.000180.0003.5684.644195.0003.2854.644210.0004.136225.000240.000255.000270.000285.000300.000315.000330.000BERAT SAMPEL+ CINCIN (gr)183.21183.28183.15167.27167.13167.22167.27167.13167.22BERAT CINCIN (gr)39.6439.6439.6441.3641.3641.3641.3641.3641.36

UJI GESER LANGSUNG

DIAMETER CINCIN (cm) =6.350TINGGI CINCIN (cm) =2.200Waktu (detik)SAMPELGAYA GESER (v)TEGANGAN GESER (t)P = 3 kgP = 6 kgP = 9 kgP = 3 kgP = 6 kgP = 9 kgP = 3 kgP = 6 kgP = 9 kgPembacaan arloji beban geserkgkg/cm20.0000.0000.0000.0000.0000.0000.0000.0000.0000.00015.0002.2082.7183.1153.4254.1814.7660.1080.1320.15030.0002.2662.8313.1723.5114.3484.8500.1110.1370.15345.0002.4352.8313.1723.7634.3484.8500.1190.1370.15360.0002.4352.8883.2853.7634.4325.0160.1190.1400.15875.0002.6612.9453.2854.0974.5165.0160.1290.1430.15890.0002.7192.9453.2854.1834.5165.0160.1320.1430.158105.0002.7193.1153.4454.1834.7665.2500.1320.1500.166120.0002.8883.1723.4554.4324.8505.2640.1400.1530.166135.0002.9453.2853.6814.5165.0165.5950.1430.1580.177150.0002.9453.4453.9654.5165.2506.0080.1430.1660.190165.0002.7193.4454.2484.1835.2506.4190.1320.1660.203180.0003.5684.6440.0005.4306.9930.0000.1710.221195.0003.2854.6440.0005.0166.9930.0000.1580.221210.0004.1360.0000.0006.2570.0000.0000.197MAKSIMUM0.1430.1710.221

PERSAMAAN KALIBRASI ALAT (dalam satuan lbf) = a.xb.ka =3.5300b =0.9600faktor konversi ke kg/cm2 k =0.4536A31.6532

UJI GESER LANGSUNG

JUDUL PEKERJAAN : PRAKTIKUM MEKANIKA TANAHLOKASI PEKERJAAN: LABORATORIUM MEKANIKA TANAH UNNESNOMOR BORING: JENIS SAMPEL: TANAH ASLI / HASIL PEMADATANDESKRIPSI TANAH: KEDALAMAN: TANGGAL PENGUJIAN: DIUJI OLEH: KELOMPOK 9

DIAMETER CINCIN (cm) =6.35No. PENGUJIAN123GAYA NORMAL P (kg)3.00006.00009.0000TEG. NORMAL s (kg/cm2)0.0950.1900.284TEG. GESER t (kg/cm2)0.1430.1710.221 PERSAMAAN REGRESI y = ax + ba =0.4124b =0.9976KOHESI (c) 0.9976kg/cm2SUDUT GESER DALAM (j)22.41

Sheet2UJI GESER LANGSUNG

DIAMETER CINCIN (cm) =6.350TINGGI CINCIN (cm) =ERROR:#REF!Waktu (detik)SAMPELGAYA GESER (v)TEGANGAN GESER (t)3 kg6 kg9 kgERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!Pembacaan arloji beban geserkgkg/cm20.0000.0000.0000.000ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!15.0002.2082.7183.1150.0000.0000.000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!30.0002.2662.8313.1720.0000.0000.000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!45.0002.4352.8313.1720.0000.0000.000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!60.0002.4352.8883.2850.0000.0000.000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!75.0002.6612.9453.2850.0000.0000.000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!90.0002.7192.9453.2850.0000.0000.000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!105.0002.7193.1153.4450.0000.0000.000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!120.0002.8883.1723.4550.0000.0000.000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!135.0002.9453.2853.6810.0000.0000.000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!150.0002.9453.4453.9650.0000.0000.000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!165.0002.7193.4454.2480.0000.0000.000ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!180.0003.5684.644ERROR:#NUM!0.0000.000ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!195.0003.2854.644ERROR:#NUM!0.0000.000ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!210.0004.136ERROR:#NUM!ERROR:#NUM!0.000ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!MAKSIMUMERROR:#NUM!ERROR:#NUM!ERROR:#NUM!

PERSAMAAN KALIBRASI ALAT (dalam satuan lbf) = a.xb.ka =3.5300b =0.9600faktor konversi ke kg/cm2 k =0.4536A31.6532

UJI GESER LANGSUNG

JUDUL PEKERJAAN : PRAKTIKUM MEKANIKA TANAHLOKASI PEKERJAAN: LABORATORIUM MEKANIKA TANAH UNNESNOMOR BORING: JENIS SAMPEL: TANAH ASLI / HASIL PEMADATANDESKRIPSI TANAH: KEDALAMAN: TANGGAL PENGUJIAN: DIUJI OLEH: KELOMPOK 9

DIA. CINCIN (cm) =ERROR:#REF!No. PENGUJIAN123GAYA NORMAL P (kg)3.04656.04659.6100TEG. NORMAL s (kg/cm2)0.0960.1910.304TEG. GESER t (kg/cm2)ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!PERSAMAAN REGRESI y = ax + ba =0.3789b =0.1036KOHESI (c) 0.1036kg/cm2SUDUT GESER DALAM (j)20.75

top related