Laserfiche WebLink
LIQUEFY-v 2.3.XLS - A SPREADSHEET FOR EMPIRICAL ANALYSIS OF LIQUEFACTION POTENTIAL AND INDUCED GROUND SUBSIDENCECoryright & Developed 2007 by Shelton L. Stringer, PE, GE, PG , EG - Earth Systems SouthwestProjecc 353 Ma¡n Street ApartmentsJobNo: SH-13131-SADate: 11129n016Boring: 94 1Methods: Liquefaction Analysis using 1 996 & I 998 NCEER workshop method (Youd & ldr¡ss, ed¡tors)Journal of Geotechnical and Enviromental Engineer¡ng (JGEE), October 2001, Vol 127, No. 10, ASCESettlêment Analysis from Tok¡matsu and Seed (1987), JGEE,VoI I 13, No.8, ASCEMoiimed by Pradel, JGEE, Vol 124, No.4, ASCEEARTHQUAKE INFORMATION:Magn¡tude: 8-05 7.5PGA, g: o.sss o.71MSF: 0.83GWT: 18.0 feetCalc GWT: 5.0 feetlemed¡ateto: 2,0 feetSPT N VALUE CORRECTIONS:Energy Correction to N60 (Cd:Drive Rod Corr. (CR):Rod Length above ground (feet):Borehole Dia. Corr. (CB):Sampler Liner Corection for SPT?:'1.0010DefaultNo0.66Totaf {in.,lnducedSúbsldeæô1.4upper 50 fiRequired SF:1.30o.39SETTLEMENT (SUBSIDENCE} OF DRY SANDSNc = 20.8Totår (frfL¡quêf¡edThich66Tot.Stress Eff.StEssatSPT atSPT rdpo (tsf) p'o (tsÐRel Tr¡gger Equ¡v. M = 7.5 M =7.5 Liquefac. Post volumelr¡cCN Cn Cs Nr(oo) oens. FC AdJ. Sand Ko Avâ¡lâble lnduced Safety Fc AdJ: Sfra,hDr(ô/o ÁN16s¡ N116¡ç¡ CRR CSR. Factor ÀNrtælNrtæps l7o)lnduced llsuosioence ll(in.) llP Gr", trav(tsD (tsf) (tsDShear Stra¡nStra¡n ErsvStra¡n Dry SandEnc Subs¡denc((in.)0.0000.0620.2660.3540.451o.8771.1701.5931 .9182.2432.4492.8263.0140.0620.2660.3540.451o.877'1.123't.3901.5591.728't.778'L9992.0461.000.990.990.980.970.96o.94o.920.890.860.810.761.001.001.001.001.001.000-87o.820.781.00'1.001.00o.75o.750.75o.750.860.93o_981.001.001.001.001.001.001.001.001.001.001.001.00'1.001.001.00'1.001.0014.'l9.89.82.210.511.424.632.228.8'18.824.614.51.001.001.001.001.001 001,000.970.940.95o.920.92lnfin.lnfin.lnfin.lnfin.lnfin.lnfn.o.2761.200't.200lnfin.lnf¡n.lnf¡n.0.4640.4600.5020.6600.679o.7240.7080.730o.7520.7460.7220.709Non-Liq.Non-L¡q,Non-L¡q,Non-Liq.Non-Liq.Non-L¡q.0.391,641.60Non-L¡q.Non-Liq.Non-Liq.14.1 0.009.8 0.009.8 0.002.2 0.0010.5 0.0011.4 0.000.0 24.6 '1.260.0 32.2 0.52'1.5 30.3 0.75't8.8 0.0024.6 0.0014.5 0.000.000.000.000.000.000.000.980.31o.140.000.000.0059 0.0 24.668 0.0 32.264 1.5 30.3Base Cal Liquef. Total Fines Depth RodDepth Mod SPT Suscept. Unitwt. Content ofSPT Lengtt(feet) N N (0 or 1) (pc0 ("/") (feet) (feet)5.06.514.018.022.O24.533.535.043.548.550.026 1618 11l8 114317 11't7 1125343226 1634 2120 1312311811895121l¿u13013013012412712390909010090904410'1001001001.04.56.014.519.524.529.534.5âôË44.549.04.07.59.012.517.522.527.532.537.542.547.552.0o.23Câlculâted SF:0.o410,178o.2370.3020.588o.7841.0671.2451.5021.6411.8932.0191,342 0.581 1.3E-031,612 0.685 1.0E-03'I,708 0.775 1.1E-030.50.40.30.20.10.0cìf=ÉoNCEER (1997) Curueof Liquefaction Res¡stancePost-Liquefact¡onRef: TokimatsuVolumetric Strâin& Seed (1987)Iø,#0.50.40.30.20.10.0N.^^ = C"-C..C"'C"-C.-NCn = 0.75 for Rod lengths < 3m, 1.0 for > lom= min( l,max(o.75, 1.4666-2.556(z(ft))""))6" = ('l atm/p'o)'", max 1.7Cs - max(Í.1,min(l.3,1+Ni{æ)/100)) for SPT without linersMSF = 10"'"/M'*z = Depth (m)pa = I atm = 101 KPa = 1.058 tsfp = O.67.po frlc = (MAG4)' ''tav = 0.65*PGA"Po*rdG,* = 447*N,rælcs(1ß)"posa = 0.0389"(p/'1)+0.1245 = 6400"(Pf |'q1 = [1 +a*EXP(b.rå'/G.*)]{(1 +a)*r""/G'lEru = 1*(N1p¡¿s/20)-1 2E""= (N€/15)v*.E15 S= 2*H,E*ÉIÉo+E! - O.2%**Êv= 0.5%**Ev=2%+Êv:3%+Ev=5%. SPT DâÞrd : (1 -0.41 1 3'2^0.5+0.04052.2+0.001 753*2^1.Sy(1.0.4177'2^0.5+0.05729'2-0.006205'2^1 5+0.00121)2^2))ÄN116¡ =6¡¡11¡,¡¡1¡c<35,exp(1.76-(190/Fc^2)),5)+lF(Fc<=s,1,1F(Fc<35,0.99+(Fc^1.5/1ooo),1.2)'N1(60)-N1(60)Nrrcqcs = N116¡ç5+ AN16¡¡Ko = m¡n of 1 .0 or (p'o/l .o58flF(oÞo 7'0 6'lF(Þr<0 s'0 8'0 7))-1 )Dr = (N¡156y'70)orCSReq = ¡,65*P64.(Po/P'o)TdCSR. = CSReq/MSF/|GCRR7.5 = (0.048-0.004721'N+0.0006136-N^2-0.00001673'N^3y(1-0.1248.N+0.009578-N^2-0.0003285-N^3+0.000003714-N^4))N = Nr€o)cs505/T1015 20 25Nlf60l clean sand354015 20 25Clean Sand Nl(60)30 35 40SF = CRRz.s,raJCSR"7.B. - Page 107