{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SPT-N Düzeltmesi"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SPT-N Düzeltmesi","index":0,"n_rows":46,"n_cols":60,"rows_kept":46,"cut":false,"hidden":false,"merged":[[39,1,39,3],[38,1,38,3],[39,8,39,11],[39,12,39,19],[39,40,39,53],[39,23,39,39],[36,27,36,30],[36,31,36,33],[36,34,36,36],[36,37,36,39],[36,40,36,42],[36,43,36,45],[38,8,38,59],[36,46,36,49],[37,1,37,3],[37,9,37,13],[37,23,37,26],[37,43,37,45],[39,6,39,7],[37,31,37,33],[37,34,37,36],[37,27,37,30],[34,37,34,39],[33,1,33,3],[33,9,33,13],[33,15,33,17],[32,9,32,13],[32,15,32,17],[34,23,34,26],[33,23,33,26],[32,23,32,26],[35,23,35,26],[34,1,34,3],[35,1,35,3],[34,9,34,13],[35,9,35,13],[36,1,36,3],[36,9,36,13],[36,23,36,26],[19,43,19,45],[33,43,33,45],[31,43,31,45],[32,43,32,45],[32,1,32,3],[32,34,32,36],[32,31,32,33],[32,27,32,30],[32,37,32,39],[30,23,30,26],[30,27,30,30],[33,37,33,39],[32,40,32,42],[30,43,30,45],[33,31,33,33],[33,34,33,36],[16,88,17,88],[43,58,43,59],[24,50,24,53],[23,46,23,49],[27,50,27,53],[18,68,18,72],[16,64,17,64],[17,54,17,59],[31,50,31,53],[21,46,21,49],[19,46,19,49],[17,46,17,49],[25,50,25,53],[23,50,23,53],[26,50,26,53],[22,50,22,53],[33,46,33,49],[33,50,33,53],[30,50,30,53],[30,46,30,49],[31,46,31,49],[16,79,17,79],[16,65,17,65],[32,50,32,53],[31,34,31,36],[31,31,31,33],[31,27,31,30],[35,27,35,30],[35,31,35,33],[35,34,35,36],[33,27,33,30],[30,34,30,36],[30,31,30,33],[34,27,34,30],[34,31,34,33],[34,34,34,36],[35,37,35,39],[35,40,35,42],[34,43,34,45],[1,1,3,9],[1,10,3,59],[6,10,6,18],[7,36,7,53],[14,23,16,26],[14,43,14,45],[14,18,16,18],[14,19,16,19],[14,50,14,53],[14,46,14,49],[15,46,16,49],[7,10,7,18],[8,54,8,59],[5,54,5,56],[4,10,4,59],[5,42,5,53],[5,32,5,41],[6,54,6,56],[6,57,6,59],[9,54,9,59],[7,19,7,27],[7,57,7,59],[4,1,4,9],[17,1,17,3],[5,10,5,18],[14,5,14,8],[15,37,16,39],[7,28,7,35],[6,32,6,41],[6,1,6,9],[14,1,16,3],[14,4,16,4],[9,10,9,18],[8,10,8,18],[10,19,10,35],[9,36,9,53],[8,19,8,35],[9,19,9,35],[12,23,13,59],[12,1,13,22],[5,19,6,31],[6,42,6,53],[15,8,16,8],[15,54,16,59],[8,36,8,44],[8,45,8,53],[15,21,16,21],[15,22,16,22],[5,57,5,59],[17,40,17,42],[18,9,18,13],[14,31,14,33],[14,34,14,36],[17,31,17,33],[14,9,16,13],[14,15,16,17],[15,20,16,20],[15,31,16,33],[14,20,14,22],[15,40,16,42],[18,27,18,30],[17,37,17,39],[18,34,18,36],[17,50,17,53],[14,27,16,30],[17,34,17,36],[14,40,14,42],[14,14,16,14],[17,43,17,45],[21,1,21,3],[23,34,23,36],[19,9,19,13],[15,34,16,36],[5,81,5,88],[21,9,21,13],[22,9,22,13],[21,40,21,42],[22,31,22,33],[5,1,5,9],[17,5,17,7],[17,20,17,22],[15,43,16,45],[15,50,16,53],[14,37,14,39],[22,34,22,36],[18,46,18,49],[8,1,10,9],[7,1,7,9],[18,1,18,3],[22,1,22,3],[21,23,21,26],[10,54,10,59],[10,36,10,53],[20,9,20,13],[20,23,20,26],[7,116,7,126],[10,94,10,103],[26,9,26,13],[19,1,19,3],[23,1,23,3],[26,1,26,3],[24,1,24,3],[25,1,25,3],[25,9,25,13],[24,9,24,13],[20,1,20,3],[23,27,23,30],[23,9,23,13],[23,31,23,33],[19,23,19,26],[18,50,18,53],[18,40,18,42],[10,10,10,18],[7,54,7,56],[17,27,17,30],[20,37,20,39],[24,34,24,36],[31,23,31,26],[29,31,29,33],[30,9,30,13],[28,9,28,13],[27,15,27,17],[18,31,18,33],[18,15,18,17],[17,23,17,26],[18,37,18,39],[20,27,20,30],[21,37,21,39],[22,23,22,26],[19,15,19,17],[17,9,17,13],[20,15,20,17],[21,15,21,17],[17,15,17,17],[19,37,19,39],[19,34,19,36],[18,23,18,26],[19,31,19,33],[22,27,22,30],[21,27,21,30],[20,34,20,36],[31,9,31,13],[27,9,27,13],[25,15,25,17],[26,15,26,17],[28,1,28,3],[30,1,30,3],[31,1,31,3],[30,15,30,17],[31,15,31,17],[29,15,29,17],[27,1,27,3],[20,50,20,53],[29,50,29,53],[41,40,41,53],[42,40,42,53],[43,40,43,53],[44,40,44,53],[45,40,45,53],[34,40,34,42],[33,40,33,42],[37,40,37,42],[26,43,26,45],[27,43,27,45],[28,43,28,45],[37,46,37,49],[34,46,34,49],[35,46,35,49],[34,50,34,53],[35,50,35,53],[36,50,36,53],[21,43,21,45],[22,46,22,49],[24,43,24,45],[32,46,32,49],[35,43,35,45],[47,63,47,65],[37,50,37,53],[45,58,45,59],[41,58,41,59],[42,58,42,59],[44,58,44,59],[21,50,21,53],[22,37,22,39],[37,37,37,39],[41,1,45,39],[39,20,39,22],[28,50,28,53],[28,46,28,49],[29,46,29,49],[28,23,28,26],[28,34,28,36],[28,31,28,33],[28,15,28,17],[29,23,29,26],[28,27,28,30],[27,27,27,30],[29,1,29,3],[29,9,29,13],[29,27,29,30],[31,40,31,42],[30,40,30,42],[30,37,30,39],[27,40,27,42],[19,50,19,53],[24,46,24,49],[26,37,26,39],[31,37,31,39],[29,37,29,39],[28,37,28,39],[29,43,29,45],[19,40,19,42],[20,40,20,42],[22,40,22,42],[23,43,23,45],[23,37,23,39],[22,43,22,45],[23,40,23,42],[25,37,25,39],[25,43,25,45],[28,40,28,42],[24,37,24,39],[25,40,25,42],[27,37,27,39],[18,43,18,45],[20,43,20,45],[25,27,25,30],[26,31,26,33],[29,34,29,36],[24,31,24,33],[27,23,27,26],[25,23,25,26],[23,23,23,26],[26,27,26,30],[24,23,24,26],[27,34,27,36],[25,31,25,33],[26,23,26,26],[26,34,26,36],[25,34,25,36],[24,27,24,30],[29,40,29,42],[27,31,27,33],[20,46,20,49],[27,46,27,49],[25,46,25,49],[26,46,26,49],[22,15,22,17],[23,15,23,17],[19,27,19,30],[26,40,26,42],[20,31,20,33],[21,34,21,36],[21,31,21,33],[24,40,24,42],[24,15,24,17]]}
[]
[null,"TMMOB JEOLOJİ MÜHENDİSLERİ ODASI",null,null,null,null,null,null,null,null,"SPT-N DÜZELTMESİ"]
[]
[]
[null,"PROJENİN ADI :",null,null,null,null,null,null,null,null,"ABC"]
[null,"Pafta No :",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,"Koordinatlar :",null,null,null,null,null,null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,"Y",null,null,null,null,null,null,null,null,null,null,null,"Kot",null,null,"Datum"]
[null,"Ada / Parsel No :",null,null,null,null,null,null,null,null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123456.2,null,null,null,null,null,null,null,null,null,12345.3,null,null,null,null,null,null,null,null,null,null,null,525,null,null,"WGS 84"]
[null,"Sondaj Kuyu No :",null,null,null,null,null,null,null,null,"SK-1",null,null,null,null,null,null,null,null,"Kuyu Derinliği :",null,null,null,null,null,null,null,null,30,null,null,null,null,null,null,null,"Yeraltı Suyu Seviyesi :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null," DÜZELTME FAKTÖRLERİ                                           [Veri girişi ve seçimi  yapınız]",null,null,null,null,null,null,null,null,"Numune Alıcı Tipi :",null,null,null,null,null,null,null,null,"Standart (iç tüpü olan)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enerji Oranı (%) :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,"Sondaj Delgi Çapı :",null,null,null,null,null,null,null,null,"Çap 65mm-115mm arasında",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPT Kılavuz Tij Boyu (Yerden):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,"Tokmak Tipi :",null,null,null,null,null,null,null,null,"Güvenli tokmak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hesaplama Metodu :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TBDY-2018'e uygundur"]
[null,"GW","GP","GM","GC","SW","SP","SM","SC","ML","CL","MH","CH","SW-SC","SW-SM","SP-SC","SP-SM","GW-GC","GW-GM","GP-GC","GP-GM","OL","OH","Pt","-",null,null,null,null,null,null,"ED 50-3°","ED 50-6°","WGS 84","ITRF-3°","ITRF-6°"]
[null,"SPT ve Laboratuvar Deneylerinden Alınan Veriler                                                                     [Renkli hücrelerde veri girişi veya seçim yapınız]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPT-N Düzeltmesi"]
[]
[null,"Sıra No",null,null," Derinlik (m)","SPT VERİLERİ",null,null,null,"Zemin Davranışı   [Seçim yapınız]",null,null,null,null,"Zemin Tipi   [USCS]  Birleştirilmiş zemin sınıflaması","İnce Tane İçeriği [İTİ] (%)",null,null,"gn  (kN/m3)","gdoygun  (kN/m3)","*Kıvam Limitleri",null,null,"Toplam gerilme                         σvo (kN/m2)",null,null,null,"Efektif gerilme                   σ'vo (kN/m2)",null,null,null,"*CN",null,null,"CR",null,null,"CS",null,null,"CB",null,null,"CE",null,null,"N60 ",null,null,null,"N1,60 "]
[null,null,null,null,null,"1","2","3","SPT - N [darbe/30 cm]",null,null,null,null,null,null,null,null,null,null,null,"   Likit limit"," Plastik limit","Plastisite indisi (PI)",null,null,null,null,null,null,null,null,"Örtü Yükü                      Düzeltme Katsayısı",null,null,"Tij Boyu               Düzeltme Katsayısı",null,null,"Numune Alıcı Tipi Düzeltme Katsayısı",null,null,"Sondaj Delgi Çapı Düzeltme Katsayısı",null,null,"Enerji Oranı                  Düzeltme Katsayısı",null,null,"Düzeltilmiş SPT-N Değ. N60= CR*CS*CB*CE",null,null,null,"Düzeltilmiş SPT-N Değ. N1,60= CN*N60",null,null,null,"SPT (N) - Derinlik Grafiği                          [Seçiminizi yapınız]"]
[null,null,null,null,null,"0 - 15 cm","15 - 30 cm","30 - 45 cm"]
[null,"-1-",null,null,"-2-","-3-",null,null,"-4-","-5-",null,null,null,null,"-6-","-7-",null,null,"-8-","-9-","-10-",null,null,"-11-",null,null,null,"-12-",null,null,null,"-13-",null,null,"-14-",null,null,"-15-",null,null,"-16-",null,null,"-17-",null,null,"-18-",null,null,null,"-19-",null,null,null,"-20-"]
[null,{"$f":"IF(E19>0,\"1-\",\"\")","v":"1-"},null,null,1.5,7,5,6,{"$f":"IF(F19=\"\",\"\",IF(F19=\"r\",\"refü\",IF((COUNTIF(F19,\"50/*\"))>=1,\"refü\",IF((COUNTIF(G19,\"50/*\"))>=1,\"refü\",IF((COUNTIF(H19,\"50/*\"))>=1,\"refü\",IF(F19+G19>=100,\"refü\",IF(G19+H19>=100,\"refü\",G19+H19)))))))","v":11},"Kohezyonsuz",null,null,null,null,"GP",null,null,null,18,20,null,"np",{"$f":"IF(V19=\"NP\",\"\",IF(U19=\"NP\",\"\",IF(U19=\"\",\"\",U19-V19)))","v":""},{"$f":"IF(E19=\"\",\"\",IF(E19<$BF$24,E19*S19,(($BF$24-0)*S19+(E19-$BF$24)*T19)))","v":28},null,null,null,{"$f":"IF(E19=\"\",\"\",IF($E$40<E19,\"\",(X19-MAX($E$19-$BF$24,0)*9.81)))","v":23.094999999999999},null,null,null,{"$f":"IF(E19=\"\",\"\",IF(J19=\"Kohezyonlu\",\"\",IF(AND(9.78*SQRT(1/AB19)<=1.7),(9.78*SQRT(1/AB19)),IF(9.78*SQRT(1/AB19)>1.7,1.7,1))))","v":1.7},null,null,{"$f":"IF(E19=\"\",\"\",IF(E19+$BC$10<4,0.75,IF((E19+$BC$10)<6,0.85,IF((E19+$BC$10)<10,0.95,1))))","v":0.75},null,null,{"$f":"IF(E19=\"\",\"\",IF($T$9=\"Standart (iç tüpü olan)\",1,1.2))","v":1},null,null,{"$f":"IF(E19=\"\",\"\",IF($T$10=\"Çap 65mm-115mm arasında\",1,IF($T$10=\"Çap 150mm\",1.05,IF($T$10=\"Çap 200mm\",1.15))))","v":1},null,null,{"$f":"IF(I19=\"\",\"\",IF(I19=\"r\",\"-\",$BC$9/60))","v":1},null,null,{"$f":"IF(E19=\"\",\"\",IF(I19=\"refü\",\"+50\",IF(PRODUCT(I19,AI19,AL19,AO19,AR19)<=50,(PRODUCT(I19,AI19,AL19,AO19,AR19)),\"+50\")))","v":8.25},null,null,null,{"$f":"IF(E19=\"\",\"\",IF(J19=\"Kohezyonlu\",\"\",IF(I19=\"refü\",\"+50\",IF(PRODUCT(I19,AF19,AI19,AL19,AO19,AR19)<=50,(PRODUCT(I19,AF19,AI19,AL19,AO19,AR19)),\"+50\"))))","v":14.024999999999999},null,null,null,{"$f":"E19","v":1.5},{"$f":"IF(AU19=\"\",NA(),IF($BF$19=2,NA(),IF($BF$19=1,IF(AU19=\"+50\",50,AU19))))","v":8.25},{"$f":"IF(AY19=\"\",NA(),IF($BF$19=1,NA(),IF($BF$19=2,IF(AY19=\"+50\",50,AY19))))","v":{"$error":"#N/A"}},1,{"$f":"IF(BF19=1,BG20,BG21)","v":"SPT-N(60)"}]
[null,{"$f":"IF(E20>0,\"2-\",\"\")","v":"2-"},null,null,3,8,4,5,{"$f":"IF(F20=\"\",\"\",IF(F20=\"r\",\"refü\",IF((COUNTIF(F20,\"50/*\"))>=1,\"refü\",IF((COUNTIF(G20,\"50/*\"))>=1,\"refü\",IF((COUNTIF(H20,\"50/*\"))>=1,\"refü\",IF(F20+G20>=100,\"refü\",IF(G20+H20>=100,\"refü\",G20+H20)))))))","v":9},"Kohezyonsuz",null,null,null,null,"GW",null,null,null,16.5,20,65,30,35,{"$f":"IF(E20=\"\",\"\",IF(E20<$BF$24,X19+((E20-E19)*S20),IF($BF$24<=E19,X19+((E20-E19)*T20),IF(AND($BF$24>E19,$BF$24<=E20),(X19+(($BF$24-E19)*S20)+(E20-$BF$24)*T20),\"-\"))))","v":58},null,null,null,{"$f":"(IF(E20=\"\",\"\",(X20-MAX(E20-$BG$24,0)*9.81)))","v":38.379999999999995},null,null,null,{"$f":"IF(E20=\"\",\"\",IF(J20=\"Kohezyonlu\",\"\",IF(9.78*SQRT(1/AB20)<=1.7,(9.78*SQRT(1/AB20)),IF(9.78*SQRT(1/AB20)>1.7,1.7,1))))","v":1.5786518743820115},null,null,{"$f":"IF(E20=\"\",\"\",IF(E20+$BC$10<4,0.75,IF((E20+$BC$10)<6,0.85,IF((E20+$BC$10)<10,0.95,1))))","v":0.85},null,null,1,null,null,1,null,null,1,null,null,{"$f":"IF(E20=\"\",\"\",IF(I20=\"refü\",\"+50\",IF(PRODUCT(I20,AI20,AL20,AO20,AR20)<=50,(PRODUCT(I20,AI20,AL20,AO20,AR20)),\"+50\")))","v":7.6499999999999995},null,null,null,12.076686839022388,null,null,null,3,7.6499999999999995,{"$error":"#N/A"},false,"SPT-N(60)"]
[null,{"$f":"IF(E21>0,\"3-\",\"\")","v":"3-"},null,null,4.5,9,5,6,{"$f":"IF(F21=\"\",\"\",IF(F21=\"r\",\"refü\",IF((COUNTIF(F21,\"50/*\"))>=1,\"refü\",IF((COUNTIF(G21,\"50/*\"))>=1,\"refü\",IF((COUNTIF(H21,\"50/*\"))>=1,\"refü\",IF(F21+G21>=100,\"refü\",IF(G21+H21>=100,\"refü\",G21+H21)))))))","v":11},"Kohezyonsuz",null,null,null,null,"GW",null,null,null,18,20,57,26,31,{"$f":"IF(E21=\"\",\"\",IF(E21<$BF$24,X20+((E21-E20)*S21),IF($BF$24<=E20,X20+((E21-E20)*T21),IF(AND($BF$24>E20,$BF$24<=E21),(X20+(($BF$24-E20)*S21)+(E21-$BF$24)*T21),\"-\"))))","v":88},null,null,null,53.664999999999999,null,null,null,{"$f":"IF(E21=\"\",\"\",IF(J21=\"Kohezyonlu\",\"\",IF(9.78*SQRT(1/AB21)<=1.7,(9.78*SQRT(1/AB21)),IF(9.78*SQRT(1/AB21)>1.7,1.7,1))))","v":1.3350369562855855},null,null,{"$f":"IF(E21=\"\",\"\",IF(E21+$BC$10<4,0.75,IF((E21+$BC$10)<6,0.85,IF((E21+$BC$10)<10,0.95,1))))","v":0.85},null,null,1,null,null,1,null,null,1,null,null,9.35,null,null,null,12.482595541270225,null,null,null,4.5,9.35,{"$error":"#N/A"},null,"SPT-N(1,60)"]
[null,{"$f":"IF(E22>0,\"4-\",\"\")","v":"4-"},null,null,6,12,10,11,21,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,18,19,23,19,{"$f":"IF(V22=\"NP\",\"\",IF(U22=\"NP\",\"\",IF(U22=\"\",\"\",U22-V22)))","v":4},{"$f":"IF(E22=\"\",\"\",IF(E22<$BF$24,X21+((E22-E21)*S22),IF($BF$24<=E21,X21+((E22-E21)*T22),IF(AND($BF$24>E21,$BF$24<=E22),(X21+(($BF$24-E21)*S22)+(E22-$BF$24)*T22),\"-\"))))","v":116.5},null,null,null,67.449999999999989,null,null,null,1.1908248195795268,null,null,{"$f":"IF(E22=\"\",\"\",IF(E22+$BC$10<4,0.75,IF((E22+$BC$10)<6,0.85,IF((E22+$BC$10)<10,0.95,1))))","v":0.95},null,null,1,null,null,1,null,null,1,null,null,19.95,null,null,null,{"$f":"IF(E22=\"\",\"\",IF(J22=\"Kohezyonlu\",\"\",IF(I22=\"refü\",\"+50\",IF(PRODUCT(I22,AF22,AI22,AL22,AO22,AR22)<=50,(PRODUCT(I22,AF22,AI22,AL22,AO22,AR22)),\"+50\"))))","v":23.756955150611557},null,null,null,6,19.95,{"$error":"#N/A"},null,{"$f":"IF(BF20=TRUE,\"\",\"YASS\")","v":"YASS"}]
[null,{"$f":"IF(E23>0,\"5-\",\"\")","v":"5-"},null,null,7.5,13,8,9,17,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,17,20,32,18,{"$f":"IF(V23=\"NP\",\"\",IF(U23=\"NP\",\"\",IF(U23=\"\",\"\",U23-V23)))","v":14},{"$f":"IF(E23=\"\",\"\",IF(E23<$BF$24,X22+((E23-E22)*S23),IF($BF$24<=E22,X22+((E23-E22)*T23),IF(AND($BF$24>E22,$BF$24<=E23),(X22+(($BF$24-E22)*S23)+(E23-$BF$24)*T23),\"-\"))))","v":146.5},null,null,null,82.734999999999999,null,null,null,1.0752122883031572,null,null,0.95,null,null,1,null,null,1,null,null,1,null,null,16.149999999999999,null,null,null,{"$f":"IF(E23=\"\",\"\",IF(J23=\"Kohezyonlu\",\"\",IF(I23=\"refü\",\"+50\",IF(PRODUCT(I23,AF23,AI23,AL23,AO23,AR23)<=50,(PRODUCT(I23,AF23,AI23,AL23,AO23,AR23)),\"+50\"))))","v":17.364678456095987},null,null,null,7.5,16.149999999999999,{"$error":"#N/A"},0,50]
[null,{"$f":"IF(E24>0,\"6-\",\"\")","v":"6-"},null,null,9,2,8,10,18,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,20,57,31,26,176.5,null,null,null,98.02,null,null,null,0.98782839489852803,null,null,1,null,null,1,null,null,1,null,null,1,null,null,18,null,null,null,17.780911108173505,null,null,null,9,18,{"$error":"#N/A"},{"$f":"IF(BF20=TRUE,E40,BC8)","v":1},{"$f":"IF(BF20=TRUE,E40,BC8)","v":1}]
[null,{"$f":"IF(E25>0,\"7-\",\"\")","v":"7-"},null,null,10.5,9,9,11,20,"Kohezyonlu",null,null,null,null,"GW",null,null,null,19,20,null,"np","",206.5,null,null,null,113.30499999999999,null,null,null,"",null,null,1,null,null,1,null,null,1,null,null,1,null,null,20,null,null,null,"",null,null,null,10.5,20,{"$error":"#N/A"},"Kuyu sonu"]
[null,{"$f":"IF(E26>0,\"8-\",\"\")","v":"8-"},null,null,12,11,8,10,18,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,48,23,25,235,null,null,null,127.08999999999999,null,null,null,0.86752732907551378,null,null,1,null,null,1,null,null,1,null,null,1,null,null,18,null,null,null,15.615491923359247,null,null,null,12,18,{"$error":"#N/A"},0,50]
[null,{"$f":"IF(E27>0,\"9-\",\"\")","v":"9-"},null,null,13.5,10,8,15,23,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,46,22,24,263.5,null,null,null,140.875,null,null,null,0.82398990353993939,null,null,1,null,null,1,null,null,1,null,null,1,null,null,23,null,null,null,18.951767781418607,null,null,null,13.5,23,{"$error":"#N/A"},{"$f":"E40","v":30},{"$f":"BF27","v":30}]
[null,{"$f":"IF(E28>0,\"10-\",\"\")","v":"10-"},null,null,15,15,10,12,22,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,44,22,22,292,null,null,null,154.66,null,null,null,0.78641149300971758,null,null,1,null,null,1,null,null,1,null,null,1,null,null,22,null,null,null,17.301052846213786,null,null,null,15,22,{"$error":"#N/A"}]
[null,{"$f":"IF(E29>0,\"11-\",\"\")","v":"11-"},null,null,16.5,16,16,17,33,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,null,"np","",320.5,null,null,null,168.44499999999999,null,null,null,0.75354604135327641,null,null,1,null,null,1,null,null,1,null,null,1,null,null,33,null,null,null,24.86701936465812,null,null,null,16.5,33,{"$error":"#N/A"},0,50]
[null,{"$f":"IF(E30>0,\"12-\",\"\")","v":"12-"},null,null,18,17,null,18,18,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,65,30,35,349,null,null,null,182.23,null,null,null,0.72448419775445572,null,null,1,null,null,1,null,null,1,null,null,1,null,null,18,null,null,null,13.040715559580203,null,null,null,18,18,{"$error":"#N/A"},{"$f":"BF42","v":5},{"$f":"BF30","v":5}]
[null,{"$f":"IF(E31>0,\"13-\",\"\")","v":"13-"},null,null,19.5,"r",null,null,"refü","Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,65,30,35,377.5,null,null,null,196.01499999999999,null,null,null,0.69854469905607575,null,null,1,null,null,1,null,null,1,null,null,1,null,null,"+50",null,null,null,"+50",null,null,null,19.5,50,{"$error":"#N/A"},{"$f":"BF43","v":16},{"$f":"BF31","v":16}]
[null,{"$f":"IF(E32>0,\"14-\",\"\")","v":"14-"},null,null,21,35,"50/10",null,"refü","Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,null,"np","",406,null,null,null,209.79999999999998,null,null,null,0.67520572016064462,null,null,1,null,null,1,null,null,1,null,null,1,null,null,"+50",null,null,null,"+50",null,null,null,21,50,{"$error":"#N/A"},{"$f":"BF44","v":24},{"$f":"BF32","v":24}]
[null,{"$f":"IF(E33>0,\"15-\",\"\")","v":"15-"},null,null,22,"50/12",null,null,"refü","Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,null,null,"",425,null,null,null,218.98999999999998,null,null,null,0.66088624497400106,null,null,1,null,null,1,null,null,1,null,null,1,null,null,"+50",null,null,null,"+50",null,null,null,22,50,{"$error":"#N/A"},{"$f":"BF45","v":27},{"$f":"BF33","v":27}]
[null,{"$f":"IF(E34>0,\"16-\",\"\")","v":"16-"},null,null,24,10,12,"50/10","refü","Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,20,null,"np","",465,null,null,null,239.36999999999998,null,null,null,0.63212649664277187,null,null,1,null,null,1,null,null,1,null,null,1,null,null,"+50",null,null,null,"+50",null,null,null,24,50,{"$error":"#N/A"},{"$f":"BF46","v":30},{"$f":"BF34","v":30}]
[null,{"$f":"IF(E35>0,\"17-\",\"\")","v":"17-"},null,null,25,15,18,22,40,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,55,23,32,484,null,null,null,248.56,null,null,null,0.62033064265098159,null,null,1,null,null,{"$f":"IF(E35=\"\",\"\",IF($T$9=\"Standart (iç tüpü olan)\",1,1.2))","v":1},null,null,{"$f":"IF(E35=\"\",\"\",IF($T$10=\"Çap 65mm-115mm arasında\",1,IF($T$10=\"Çap 150mm\",1.05,IF($T$10=\"Çap 200mm\",1.15))))","v":1},null,null,{"$f":"IF(I35=\"\",\"\",IF(I35=\"r\",\"-\",$BC$9/60))","v":1},null,null,40,null,null,null,24.813225706039262,null,null,null,25,40,{"$error":"#N/A"},"Standart (iç tüpü olan)","Çap 65mm-115mm arasında","Halkalı tokmak"]
[null,{"$f":"IF(E36>0,\"18-\",\"\")","v":"18-"},null,null,27,20,22,23,45,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,20,21,null,null,"",526,null,null,null,270.94,null,null,null,0.59415846860895505,null,null,1,null,null,1,null,null,1,null,null,1,null,null,45,null,null,null,26.737131087402979,null,null,null,27,45,{"$error":"#N/A"},"İç tüpü olmayan","Çap 150mm","Güvenli tokmak"]
[null,{"$f":"IF(E37>0,\"19-\",\"\")","v":"19-"},null,null,28.5,30,35,40,75,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,20,21,null,null,"",557.5,null,null,null,287.72499999999997,null,null,null,0.57656736328636038,null,null,1,null,null,1,null,null,1,null,null,1,null,null,"+50",null,null,null,43.242552246477025,null,null,null,28.5,50,{"$error":"#N/A"},null,"Çap 200mm","Otomatik darbeli tokmak"]
[null,{"$f":"IF(E38>0,\"20-\",\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,null,"",null,null,null,0,{"$error":"#N/A"},{"$error":"#N/A"},"Kohezyonlu","Kohezyonsuz"]
[]
[null,"Þ",null,null,{"$f":"AC8","v":30},"Ü  "," Kuyu Derinliği",null,"Hatalı durum",null,null,null,"Kırmızı çerçeveli kutu:                       Veri giriş uyarısı",null,null,null,null,null,null,null,"* Bilgi amaçlıdır.",null,null,"*CN düzeltmesi kohezyonlu zeminlere uygulanmamıştır.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zemin Birimlerinin Açıklaması                [Elle giriş yapınız]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sınır çizgisi","Başl.","-","Bitiş derinliği"]
[]
[null,"NOT : Hesaplamaların sorumluluğu kullanıcıya aittir. Hesap cetveline ait telif hakları, 5846 sayılı Fikir ve Sanat Eserleri Kanunu gereğince TMMOB Jeoloji Mühendisleri Odasına ait olup, izin almaksızın içeriğinde herhangi bir değişiklik yapılamaz.                                                                                                                                                                                                                                                                                                                                                                          Hesap cetveli JMO logolu kullanılmak kaydıyla  ücretsiz olarak herkesin kullanımına açıktır. Ancak Oda logosunun hesap cetvelinden çıkarılarak kullanılmasının tespit edilmesi durumunda 5846 sayılı kanun gereğince ilgili kişi hakkında gerekli hukuki yollara başvurulacaktır.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Siltli kum",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BF42=\"\",\"\",\"-----\")","v":"-----"},{"$f":"IF(BF42=\"\",\"\",0)","v":0},{"$f":"IF(AO42=\"\",\"\",\"-\")","v":"-"},5,{"$f":"IF(ISBLANK(BF42),\"\",\"m arası\")","v":"m arası"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orta sıkı-sıkı kum",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO43=\"\",\"\",\"-..-..\")","v":"-..-.."},{"$f":"IF(BF43=\"\",\"\",BF42)","v":5},{"$f":"IF(AO43=\"\",\"\",\"-\")","v":"-"},16,{"$f":"IF(ISBLANK(BF43),\"\",\"m arası\")","v":"m arası"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kil",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO44=\"\",\"\",\"-.-.-\")","v":"-.-.-"},{"$f":"IF(BF44=\"\",\"\",BF43)","v":16},{"$f":"IF(AO44=\"\",\"\",\"-\")","v":"-"},24,{"$f":"IF(ISBLANK(BF44),\"\",\"m arası\")","v":"m arası"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xxx silt",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO45=\"\",\"\",\"- - -\")","v":"- - -"},24,null,27,{"$f":"IF(ISBLANK(BF45),\"\",\"m arası\")","v":"m arası"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"şşş",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO46=\"\",\"\",\"----\")","v":"----"},{"$f":"IF(BF46=\"\",\"\",BF45)","v":27},{"$f":"IF(AI46=\"\",\"\",\"-\")","v":""},30,{"$f":"IF(ISBLANK(BF46),\"\",\"m arası\")","v":"m arası"}]