{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SPT-N Düzeltmesi","sk-1"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":0,"defined_names":16,"comments":1,"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,55,40,55],[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],[37,31,37,33],[37,34,37,36],[37,27,37,30],[34,31,34,33],[34,34,34,36],[39,1,40,3],[39,23,40,39],[38,1,38,3],[36,27,36,30],[36,31,36,33],[36,34,36,36],[36,37,36,39],[39,12,40,19],[39,8,40,11],[39,5,40,5],[39,4,40,4],[39,6,40,7],[16,65,17,65],[32,50,32,53],[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],[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],[41,40,41,53],[42,40,42,53],[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],[4,1,4,9],[15,40,16,42],[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],[5,19,6,31],[6,42,6,53],[15,8,16,8],[15,54,16,59],[8,36,8,44],[12,1,13,21],[5,57,5,59],[17,40,17,42],[18,43,18,45],[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],[18,27,18,30],[17,50,17,53],[14,27,16,30],[17,34,17,36],[14,40,14,42],[14,14,16,14],[17,43,17,45],[7,57,7,59],[15,34,16,36],[17,23,17,26],[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],[8,45,8,53],[15,21,16,21],[15,22,16,22],[18,15,18,17],[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],[21,1,21,3],[23,34,23,36],[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],[20,9,20,13],[20,23,20,26],[19,9,19,13],[18,31,18,33],[22,15,22,17],[17,37,17,39],[18,34,18,36],[18,37,18,39],[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],[30,9,30,13],[28,9,28,13],[27,15,27,17],[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],[32,46,32,49],[35,43,35,45],[34,43,34,45],[27,27,27,30],[29,1,29,3],[29,9,29,13],[29,27,29,30],[31,9,31,13],[43,40,43,53],[44,40,44,53],[45,40,45,53],[34,40,34,42],[33,40,33,42],[37,40,37,42],[35,40,35,42],[27,9,27,13],[33,31,33,33],[33,34,33,36],[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],[27,37,27,39],[20,50,20,53],[29,50,29,53],[21,43,21,45],[22,46,22,49],[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],[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],[29,40,29,42],[27,31,27,33],[27,40,27,42],[24,43,24,45],[29,31,29,33],[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],[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],[39,56,40,56],[39,54,40,54],[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],[39,57,40,59],[39,40,40,53],[39,20,40,22],[20,46,20,49],[27,46,27,49],[25,46,25,49],[26,46,26,49],[31,40,31,42],[30,40,30,42],[30,37,30,39],[31,23,31,26],[35,37,35,39],[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],[25,34,25,36],[24,27,24,30]]}
[]
[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,"Lütfen sorunları ve önerilerinizi gurelozdemir2@gmail.com adresine iletiniz."]
[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,2.9999999999999991]
[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",8.5,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":27},null,null,null,{"$f":"IF(E19=\"\",\"\",IF($E$40<E19,\"\",(X19-MAX($E$19-$BF$24,0)*9.81)))","v":27},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,13,45,23,22,{"$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":51.75},null,null,null,{"$f":"(IF(E20=\"\",\"\",(X20-MAX(E20-$BG$24,0)*9.81)))","v":51.749999999999993},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.3595139796521274},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,10.400281944338774,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",5.6,null,null,18,16,35,25,10,{"$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":75.75},null,null,null,61.034999999999989,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.2518416023582766},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,11.704718982049885,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,41,28,13,{"$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":104.25},null,null,null,74.819999999999993,null,null,null,1.1306547272573739,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":22.556561808784608},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,33,22,11,{"$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":134.25},null,null,null,90.10499999999999,null,null,null,1.0303016830919578,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":16.639372181935116},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,null,null,"",164.25,null,null,null,105.38999999999999,null,null,null,0.95266268046448965,null,null,1,null,null,1,null,null,1,null,null,1,null,null,18,null,null,null,17.147928248360813,null,null,null,9,18,{"$error":"#N/A"},{"$f":"IF(BF20=TRUE,E40,BC8)","v":2.9999999999999991},{"$f":"IF(BF20=TRUE,E40,BC8)","v":2.9999999999999991}]
[null,{"$f":"IF(E25>0,\"7-\",\"\")","v":"7-"},null,null,10.5,9,9,11,20,"Kohezyonlu",null,null,null,null,"SC",10.8,null,null,19,20,25,19,6,194.25,null,null,null,120.67499999999998,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,null,null,"",222.75,null,null,null,134.45999999999998,null,null,null,0.8434169046008817,null,null,1,null,null,1,null,null,1,null,null,1,null,null,18,null,null,null,15.181504282815871,null,null,null,12,18,{"$error":"#N/A"},0,50]
[null,{"$f":"IF(E27>0,\"9-\",\"\")","v":"9-"},null,null,13.5,16.666666666666668,8,15,23,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,30,19,11,251.25,null,null,null,148.245,null,null,null,0.80324647356735468,null,null,1,null,null,1,null,null,1,null,null,1,null,null,23,null,null,null,18.474668892049159,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,14,12,26,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,null,"np","",279.75,null,null,null,162.03,null,null,null,0.7683182316056214,null,null,1,null,null,1,null,null,1,null,null,1,null,null,26,null,null,null,19.976274021746157,null,null,null,15,26,{"$error":"#N/A"}]
[null,{"$f":"IF(E29>0,\"11-\",\"\")","v":"11-"},null,null,16.5,16.666666666666668,16,17,33,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,null,null,"",308.25,null,null,null,175.815,null,null,null,0.73758298956526436,null,null,1,null,null,1,null,null,1,null,null,1,null,null,33,null,null,null,24.340238655653724,null,null,null,16.5,33,{"$error":"#N/A"},0,50]
[null,{"$f":"IF(E30>0,\"12-\",\"\")","v":"12-"},null,null,18,18,19,21,40,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,null,null,"",336.75,null,null,null,189.6,null,null,null,0.71026381263886995,null,null,1,null,null,1,null,null,1,null,null,1,null,null,40,null,null,null,28.410552505554797,null,null,null,18,40,{"$error":"#N/A"},{"$f":"BF42","v":8},{"$f":"BF30","v":8}]
[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,null,null,"",365.25,null,null,null,203.38499999999999,null,null,null,0.68577144093979558,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,null,"",393.75,null,null,null,217.17,null,null,null,0.66364975608880794,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-GM",null,null,null,19,19,null,null,"",412.75,null,null,null,226.35999999999999,null,null,null,0.65003839923549922,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,null,"",452.75,null,null,null,246.73999999999998,null,null,null,0.62261427619470455,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,null,null,"",471.75,null,null,null,255.92999999999998,null,null,null,0.61133358647808633,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.453343459123452,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,"",513.75,null,null,null,278.31,null,null,null,0.58623865212821868,null,null,1,null,null,1,null,null,1,null,null,1,null,null,45,null,null,null,26.38073934576984,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,"",545.25,null,null,null,295.09500000000003,null,null,null,0.56932195142067044,null,null,1,null,null,1,null,null,1,null,null,1,null,null,"+50",null,null,null,42.69914635655028,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,"mmm",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":"-"},8,{"$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,"kk ll",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO43=\"\",\"\",\"-..-..\")","v":"-..-.."},{"$f":"IF(BF43=\"\",\"\",BF42)","v":8},{"$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,null,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,null,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,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ı"}]

{"sheet":"sk-1","index":1,"n_rows":46,"n_cols":60,"rows_kept":46,"cut":false,"hidden":false,"merged":[[47,63,47,65],[43,40,43,53],[43,58,43,59],[44,40,44,53],[44,58,44,59],[45,40,45,53],[45,58,45,59],[39,40,40,53],[39,54,40,54],[39,55,40,55],[39,56,40,56],[39,57,40,59],[41,1,45,39],[41,40,41,53],[41,58,41,59],[42,40,42,53],[42,58,42,59],[38,1,38,3],[38,8,38,59],[39,1,40,3],[39,4,40,4],[39,5,40,5],[39,6,40,7],[39,8,40,11],[39,12,40,19],[39,20,40,22],[39,23,40,39],[37,34,37,36],[37,37,37,39],[37,40,37,42],[37,43,37,45],[37,46,37,49],[37,50,37,53],[36,37,36,39],[36,40,36,42],[36,43,36,45],[36,46,36,49],[36,50,36,53],[37,1,37,3],[37,9,37,13],[37,23,37,26],[37,27,37,30],[37,31,37,33],[36,1,36,3],[36,9,36,13],[36,23,36,26],[36,27,36,30],[36,31,36,33],[36,34,36,36],[35,34,35,36],[35,37,35,39],[35,40,35,42],[35,43,35,45],[35,46,35,49],[35,50,35,53],[34,37,34,39],[34,40,34,42],[34,43,34,45],[34,46,34,49],[34,50,34,53],[35,1,35,3],[35,9,35,13],[35,23,35,26],[35,27,35,30],[35,31,35,33],[34,1,34,3],[34,9,34,13],[34,23,34,26],[34,27,34,30],[34,31,34,33],[34,34,34,36],[33,34,33,36],[33,37,33,39],[33,40,33,42],[33,43,33,45],[33,46,33,49],[33,50,33,53],[33,1,33,3],[33,9,33,13],[33,15,33,17],[33,23,33,26],[33,27,33,30],[33,31,33,33],[32,34,32,36],[32,37,32,39],[32,40,32,42],[32,43,32,45],[32,46,32,49],[32,50,32,53],[32,1,32,3],[32,9,32,13],[32,15,32,17],[32,23,32,26],[32,27,32,30],[32,31,32,33],[31,34,31,36],[31,37,31,39],[31,40,31,42],[31,43,31,45],[31,46,31,49],[31,50,31,53],[31,1,31,3],[31,9,31,13],[31,15,31,17],[31,23,31,26],[31,27,31,30],[31,31,31,33],[30,34,30,36],[30,37,30,39],[30,40,30,42],[30,43,30,45],[30,46,30,49],[30,50,30,53],[30,1,30,3],[30,9,30,13],[30,15,30,17],[30,23,30,26],[30,27,30,30],[30,31,30,33],[29,34,29,36],[29,37,29,39],[29,40,29,42],[29,43,29,45],[29,46,29,49],[29,50,29,53],[29,1,29,3],[29,9,29,13],[29,15,29,17],[29,23,29,26],[29,27,29,30],[29,31,29,33],[28,34,28,36],[28,37,28,39],[28,40,28,42],[28,43,28,45],[28,46,28,49],[28,50,28,53],[28,1,28,3],[28,9,28,13],[28,15,28,17],[28,23,28,26],[28,27,28,30],[28,31,28,33],[27,34,27,36],[27,37,27,39],[27,40,27,42],[27,43,27,45],[27,46,27,49],[27,50,27,53],[27,1,27,3],[27,9,27,13],[27,15,27,17],[27,23,27,26],[27,27,27,30],[27,31,27,33],[26,34,26,36],[26,37,26,39],[26,40,26,42],[26,43,26,45],[26,46,26,49],[26,50,26,53],[26,1,26,3],[26,9,26,13],[26,15,26,17],[26,23,26,26],[26,27,26,30],[26,31,26,33],[25,34,25,36],[25,37,25,39],[25,40,25,42],[25,43,25,45],[25,46,25,49],[25,50,25,53],[25,1,25,3],[25,9,25,13],[25,15,25,17],[25,23,25,26],[25,27,25,30],[25,31,25,33],[24,34,24,36],[24,37,24,39],[24,40,24,42],[24,43,24,45],[24,46,24,49],[24,50,24,53],[24,1,24,3],[24,9,24,13],[24,15,24,17],[24,23,24,26],[24,27,24,30],[24,31,24,33],[23,34,23,36],[23,37,23,39],[23,40,23,42],[23,43,23,45],[23,46,23,49],[23,50,23,53],[23,1,23,3],[23,9,23,13],[23,15,23,17],[23,23,23,26],[23,27,23,30],[23,31,23,33],[22,34,22,36],[22,37,22,39],[22,40,22,42],[22,43,22,45],[22,46,22,49],[22,50,22,53],[22,1,22,3],[22,9,22,13],[22,15,22,17],[22,23,22,26],[22,27,22,30],[22,31,22,33],[21,34,21,36],[21,37,21,39],[21,40,21,42],[21,43,21,45],[21,46,21,49],[21,50,21,53],[21,1,21,3],[21,9,21,13],[21,15,21,17],[21,23,21,26],[21,27,21,30],[21,31,21,33],[20,34,20,36],[20,37,20,39],[20,40,20,42],[20,43,20,45],[20,46,20,49],[20,50,20,53],[20,1,20,3],[20,9,20,13],[20,15,20,17],[20,23,20,26],[20,27,20,30],[20,31,20,33],[19,34,19,36],[19,37,19,39],[19,40,19,42],[19,43,19,45],[19,46,19,49],[19,50,19,53],[19,1,19,3],[19,9,19,13],[19,15,19,17],[19,23,19,26],[19,27,19,30],[19,31,19,33],[18,37,18,39],[18,40,18,42],[18,43,18,45],[18,46,18,49],[18,50,18,53],[18,68,18,72],[17,46,17,49],[17,50,17,53],[17,54,17,59],[18,1,18,3],[18,9,18,13],[18,15,18,17],[18,23,18,26],[18,27,18,30],[18,31,18,33],[18,34,18,36],[17,27,17,30],[17,31,17,33],[17,34,17,36],[17,37,17,39],[17,40,17,42],[17,43,17,45],[16,64,17,64],[16,65,17,65],[16,79,17,79],[16,88,17,88],[17,1,17,3],[17,5,17,7],[17,9,17,13],[17,15,17,17],[17,20,17,22],[17,23,17,26],[15,37,16,39],[15,40,16,42],[15,43,16,45],[15,46,16,49],[15,50,16,53],[15,54,16,59],[14,37,14,39],[14,40,14,42],[14,43,14,45],[14,46,14,49],[14,50,14,53],[15,8,16,8],[15,20,16,20],[15,21,16,21],[15,22,16,22],[15,31,16,33],[14,19,16,19],[14,20,14,22],[14,23,16,26],[14,27,16,30],[14,31,14,33],[14,34,14,36],[15,34,16,36],[10,94,10,103],[12,1,13,21],[12,23,13,59],[14,1,16,3],[14,4,16,4],[14,5,14,8],[14,9,16,13],[14,14,16,14],[14,15,16,17],[14,18,16,18],[9,36,9,53],[9,54,9,59],[10,10,10,18],[10,19,10,35],[10,36,10,53],[10,54,10,59],[7,57,7,59],[7,116,7,126],[8,1,10,9],[8,10,8,18],[8,19,8,35],[8,36,8,44],[8,45,8,53],[8,54,8,59],[9,10,9,18],[9,19,9,35],[7,1,7,9],[7,10,7,18],[7,19,7,27],[7,28,7,35],[7,36,7,53],[7,54,7,56],[5,57,5,59],[5,81,5,88],[6,1,6,9],[6,10,6,18],[6,32,6,41],[6,42,6,53],[6,54,6,56],[6,57,6,59],[1,1,3,9],[1,10,3,59],[4,1,4,9],[4,10,4,59],[5,1,5,9],[5,10,5,18],[5,19,6,31],[5,32,5,41],[5,42,5,53],[5,54,5,56]]}
[]
[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,"Lütfen sorunları ve önerilerinizi gurelozdemir2@gmail.com adresine iletiniz."]
[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,2.9999999999999991]
[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",8.5,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":27},null,null,null,{"$f":"IF(E19=\"\",\"\",IF($E$40<E19,\"\",(X19-MAX($E$19-$BF$24,0)*9.81)))","v":27},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,13,45,23,22,{"$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":51.75},null,null,null,{"$f":"(IF(E20=\"\",\"\",(X20-MAX(E20-$BG$24,0)*9.81)))","v":51.749999999999993},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.3595139796521274},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,10.400281944338774,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",5.6,null,null,18,16,35,25,10,{"$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":75.75},null,null,null,61.034999999999989,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.2518416023582766},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,11.704718982049885,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,41,28,13,{"$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":104.25},null,null,null,74.819999999999993,null,null,null,1.1306547272573739,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":22.556561808784608},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,33,22,11,{"$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":134.25},null,null,null,90.10499999999999,null,null,null,1.0303016830919578,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":16.639372181935116},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,null,null,"",164.25,null,null,null,105.38999999999999,null,null,null,0.95266268046448965,null,null,1,null,null,1,null,null,1,null,null,1,null,null,18,null,null,null,17.147928248360813,null,null,null,9,18,{"$error":"#N/A"},{"$f":"IF(BF20=TRUE,E40,BC8)","v":2.9999999999999991},{"$f":"IF(BF20=TRUE,E40,BC8)","v":2.9999999999999991}]
[null,{"$f":"IF(E25>0,\"7-\",\"\")","v":"7-"},null,null,10.5,9,9,11,20,"Kohezyonlu",null,null,null,null,"SC",10.8,null,null,19,20,25,19,6,194.25,null,null,null,120.67499999999998,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,null,null,"",222.75,null,null,null,134.45999999999998,null,null,null,0.8434169046008817,null,null,1,null,null,1,null,null,1,null,null,1,null,null,18,null,null,null,15.181504282815871,null,null,null,12,18,{"$error":"#N/A"},0,50]
[null,{"$f":"IF(E27>0,\"9-\",\"\")","v":"9-"},null,null,13.5,16.666666666666668,8,15,23,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,30,19,11,251.25,null,null,null,148.245,null,null,null,0.80324647356735468,null,null,1,null,null,1,null,null,1,null,null,1,null,null,23,null,null,null,18.474668892049159,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,14,12,26,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,null,"np","",279.75,null,null,null,162.03,null,null,null,0.7683182316056214,null,null,1,null,null,1,null,null,1,null,null,1,null,null,26,null,null,null,19.976274021746157,null,null,null,15,26,{"$error":"#N/A"}]
[null,{"$f":"IF(E29>0,\"11-\",\"\")","v":"11-"},null,null,16.5,16.666666666666668,16,17,33,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,null,null,"",308.25,null,null,null,175.815,null,null,null,0.73758298956526436,null,null,1,null,null,1,null,null,1,null,null,1,null,null,33,null,null,null,24.340238655653724,null,null,null,16.5,33,{"$error":"#N/A"},0,50]
[null,{"$f":"IF(E30>0,\"12-\",\"\")","v":"12-"},null,null,18,18,19,21,40,"Kohezyonsuz",null,null,null,null,"GW",null,null,null,19,19,null,null,"",336.75,null,null,null,189.6,null,null,null,0.71026381263886995,null,null,1,null,null,1,null,null,1,null,null,1,null,null,40,null,null,null,28.410552505554797,null,null,null,18,40,{"$error":"#N/A"},{"$f":"BF42","v":8},{"$f":"BF30","v":8}]
[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,null,null,"",365.25,null,null,null,203.38499999999999,null,null,null,0.68577144093979558,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,null,"",393.75,null,null,null,217.17,null,null,null,0.66364975608880794,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-GM",null,null,null,19,19,null,null,"",412.75,null,null,null,226.35999999999999,null,null,null,0.65003839923549922,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,null,"",452.75,null,null,null,246.73999999999998,null,null,null,0.62261427619470455,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,null,null,"",471.75,null,null,null,255.92999999999998,null,null,null,0.61133358647808633,null,null,1,null,null,1,null,null,1,null,null,1,null,null,40,null,null,null,24.453343459123452,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,"",513.75,null,null,null,278.31,null,null,null,0.58623865212821868,null,null,1,null,null,1,null,null,1,null,null,1,null,null,45,null,null,null,26.38073934576984,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,"",545.25,null,null,null,295.09500000000003,null,null,null,0.56932195142067044,null,null,1,null,null,1,null,null,1,null,null,1,null,null,"+50",null,null,null,42.69914635655028,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,"mmm",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":"-"},8,{"$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,"kk ll",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO43=\"\",\"\",\"-..-..\")","v":"-..-.."},{"$f":"IF(BF43=\"\",\"\",BF42)","v":8},{"$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,null,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,null,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,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ı"}]