{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Übersicht","Hooghoudt&Ernst","1,2 homogen","3 Drän auf Sch.-Grenze","4 Drän in ob. Sch.","5 Drän in unt. Sch.","6 gespannter GWL","Ernst A","Ernst B","Ernst C","Instationär","Tabelle2","Tabelle3"],"not_rendered":{"charts":0,"images":26,"macros":1,"external_links":0,"defined_names":317,"comments":4,"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":"Übersicht","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,9,3,9],[4,9,5,9],[4,1,5,5],[7,2,11,5],[7,1,11,1],[4,7,5,7],[4,8,5,8],[7,8,11,8],[7,9,11,9],[2,7,3,7],[2,8,3,8],[2,1,3,5],[4,6,5,6],[7,7,11,7],[17,9,21,9],[17,8,21,8],[22,1,24,5],[6,1,6,5],[7,6,11,6],[12,9,16,9],[22,9,24,9],[12,1,16,1],[17,1,21,1],[12,2,16,5],[17,6,21,6],[17,7,21,7],[17,2,21,5],[12,6,16,6],[12,8,16,8],[12,7,16,7],[22,6,24,6],[22,7,24,7],[22,8,24,8]]}
[]
[]
[null,null,null,null,null,null,"DIN 1185","TGL 42 812 / 07","Ernst","Instationär, fallender Wasserspiegel"]
[null,null,null,null,null,null,"Hooghoudt / Ernst"]
[null,"Homogener Grundwasserleiter",null,null,null,null,"x","Ansatz 1/2","Fall A"]
[]
[null,"Zweischichtiger Grundwasserleiter"]
[null,"   Schichtgrenze in Dräntiefe",null,null,null,null,"x","Ansatz 3","Fall B"]
[]
[]
[]
[]
[null,"   Drän in unterer Schicht",null,null,null,null,"x ?","Ansatz 5","Fall B"]
[]
[]
[]
[]
[null,"   Drän in oberer Schicht",null,null,null,null,null,"Ansatz 4","Fall C"]
[]
[]
[]
[]
[null,"Homogene Deckschicht über gespanntem Grundwasserleiter",null,null,null,null,null,"Ansatz 6"]

{"sheet":"Hooghoudt&Ernst","index":1,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Dränabstandsberechnung nach DIN 1185 Blatt 2 (s. DIN TB Wasserbau 2)"]
["Ansatz","Bedingungen",null,"Berechnungsgleichungen",null,null,null,null,"geohydraulisches Schema"]
[]
["Hooghoudt","Schichtgrenze"]
["& Ernst","in oder oberhalb"]
[null,"Dräntiefe"]
[]
[null,"(Wenn die Schicht-"]
[null,"grenze unterhalb"]
[null,"der Dräntiefe liegt,"]
[null,"Berechnung"]
[null,"nach TGL 42 812/07"]
[null,"Ansatz 4 (Ernst))"]
[]
[]
[]
[]
[]
[null,null,null,null,"Die Variablen im grünen Feld sind einzugeben"]
[null,null,"wirksamer Außenradius","r_ = ",0.05," m"]
[null,null,"Abst. OKG - GW-Stauer D","D = ",6," m"]
[null,null,"Dräntiefe tD","tD = ",1," m"]
[null,null,"Entwässerungstiefe tE","tE = ",0.5," m"]
[null,null,"gesätt. hydraul. Leitf. ko ","ko = ",0.5," m/d"]
[null,null,"gesätt. hydraul. Leitf. ku ","ku = ",0.5," m/d"]
[null,null,"Dränabflußspende  q","q = ",6.4999999999999997E-3," m/d"]
[null,null,null,"lU = ",{"$f":"r_*PI()","v":0.15707963267948966}," m,   der benetzte Umfang muss hier eingetragen werden, falls er  "]
[null,null,null,null,null,"         anders berechnet werden soll als \"lU = r_*PI()\""]
[null,null,"geohydraul. Druckhöhe  hS ","hS = ",{"$f":"tD-tE-r_","v":0.45}," m"]
[null,null,"Abstand GW-Stauer - Drän  D0 ","D0 = ",{"$f":"D-tE-hS","v":5.05}," m"]
[null,null,"Kriterium a/4","kri = ",{"$f":"a/4","v":5.75}]
[]
[null,null,"Mächtigkeit der Äquivalentschicht","de = ",{"$f":"IF(D0<kri,D0/(8*D0/PI()/a*LN(D0/lU)+1),PI()*a/(8*LN(a/lU)))","v":1.7174775403024416}," m"]
[]
[null,null,"Iterative Lösung mit der ",null,"Zielzelle",null,"Zielwert"]
[null,null,"Zielwertsuche von EXCEL",null,{"$f":"(8*ku*de*hS/q+4*ko*hS^2/q)^0.5-ahe","v":0.1930346723864993}," = Null",0,null,null,"(8*ku*df*hS/q+4*ko*hS^2/q)^0.5-ahe"]
[null,null,null,null,"mögliche veränderbare Zelle"]
[null,"Dränabstand nach ",null,null,23]
[null,"Hooghoudt/Ernst:",null,"a = ",{"$f":"ahe","v":23},"m"]

{"sheet":"1,2 homogen","index":2,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Dränabstandsbestimmung nach TGL  42812/07 - Homogener Grundwasserleiter"]
["Ansatz","Bedingungen",null,"Berechnungsgleichungen",null,null,null,null,"geohydraulisches Schema"]
[]
["1)","Bed.1:  D0 = 0"]
[]
[null,"Bed.2:  k >= 0.2m/d"]
[]
[null,null,null,null,"Die Variablen im grünen Feld sind einzugeben"]
[null,null,"Abst. OKG - GW-Stauer = Dräntiefe","tD = ",1.1000000000000001,"m"]
[null,null,"Entwässerungstiefe tE","tE = ",0.6,"m"]
[null,null,"Dränabflußspende"," q = ",7.0000000000000001E-3,"m/d"]
[null,null,"gesätt. hydraul. Leitfähigkeit","k = ",1.5,"m/d"]
[null,null,"Dränrohrradius","r = ",0.1,"m"]
[null,null,"Redukt.fakt. f. benetzten Umf. ","gamma = ",0.1,"an Dränrohren"]
[null,null,"geohydraul. Druckhöhe  hS ","hS = ",{"$f":"tD-tE-_r*2","v":0.3000000000000001},"m"]
[null,null,null,null,{"$f":"hS/(1/2*SQRT(q/k)-q*LN(gamma)/(PI()*k))","v":7.9836348936991879}]
[null,null,"Dränabstand Ansatz 1","a = ",{"$f":"IF(k>=0.2,a_3,\"s.Bed.2!\")","v":7.9836348936991879},"m"]
[]
["2a)","Bed.1:  D0 <= 0.25a"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Abst. OKG - GW-Stauer D","D = ",4,"m"]
[null,null,"eff. benetzter Umfang  Ue ","Ue = ",{"$f":"(2*_r+2)*PI()*gamma","v":0.69115038378975457},"m"]
[null,null,"Mächtigkeit  D0 ","D0 = ",{"$f":"D-hS-tE","v":3.0999999999999996},"m"]
[null,null,null,"b = ",1]
[null,null,null,"D_1 = ",{"$f":"hS/2+D0","v":3.2499999999999996},"m"]
[null,null,null,"c = ",{"$f":"2/PI()*LN(b*D0/Ue)","v":0.95543892780406248}]
[]
[null,null,null,null,{"$f":"2*D_1*(SQRT(_c^2+hS/D_1*(2*k/q-1))-_c)","v":35.094574716393851}]
[null,null,"Dränabstand Ansatz 2a","a = ",{"$f":"IF(D0>0.25*a_4,\"s.Bed.1!\",a_4)","v":35.094574716393851},"m"]
[]
[]
[]
["2b)","Bed.1:  D0 > 0.25a"]
[]
[]
[]
[]
[]
[null,null,"Iterative Lösung mit der ",null,"Zielzelle",null,"Zielwert"]
[null,null,"Zielwertsuche von EXCEL","Null = ",{"$f":"PI()*k*hS/q/LN(a_5/Ue)-a_5","v":9.7648417682712818},null,0]
[]
[null,null,null,null,"veränderbare Zelle"]
[null,null,null,null,40]
[null,null,"Dränabstand Ansatz 2b","a = ",{"$f":"IF(D0>a_5/4,a_5,\"s.Bed.1!\")","v":"s.Bed.1!"},"m"]

{"sheet":"3 Drän auf Sch.-Grenze","index":3,"n_rows":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Dränabstandsbest. (TGL 42812/07) - zweischichtiger Grundwasserleiter, Schichtgrenze in Dräntiefe"]
["Ansatz","Bedingungen",null,"Berechnungsgleichungen",null,null,null,"           geohydraulisches Schema"]
[]
[null,null,null,null,"Die Variablen im grünen Feld sind eizugeben"]
[null,null,"Dränabflußspende","q ",7.0000000000000001E-3," m/d"]
[null,null,"Abst. OKG - GW-Stauer "," D ",4," m/d"]
[null,null,"Dräntiefe tD","tD ",1.1000000000000001," m"]
[null,null,"Entwässerungstiefe tE ","tE ",0.6," m"]
[null,null,"hydraul. Leitfähigkeit. ob. Sch.  ko ","ko ",2," m/d"]
[null,null,"hydraul. Leitfähigkeit unt. Sch. ku","ku ",1," m/d"]
[null,null,"Dränrohrradius r","r ",0.1," m"]
[null,null,"Red.fakt. f. benetzten Umf.","gamma ",1]
[null,null,"Mächtigkeit unt. Schicht  D0 ","D0 ",{"$f":"D-tE-hS","v":3.0999999999999996}," m"]
[null,null,"geohydraul. Druckhöhe  hS ","hS ",{"$f":"tD-tE-2*_r","v":0.3000000000000001}," m"]
[3.1,"Bed.1:  ko/ku >= 0.1  "]
["   3.1  a)","Bed.2:  D0 <= 0.25a"]
[]
[]
[]
[]
[null,null,"Iterative Lösung mit der ",null,"Zielzelle",null,"Zielwert"]
[null,null,"Zielwertsuche von EXCEL",null,{"$f":"2*SQRT(hS/q*(ko*hS+2*ku*D0/(1+4*D0/a_1*(_c+0.32))))-a_1","v":2.0424607782842941E-7}," = Null",0]
[null,null,"wegen D2=f(a)"]
[null,null,null,null,"veränderbare Zelle"]
[null,null,null,null,27.713691883342431]
[null,null,"Dränabstand Ansatz 3.1 a)","a = ",{"$f":"IF(ko/ku<0.1,\"s.Bed.1!\",IF(D0>0.25*a_1,\"s.Bed.2!\",a_1))","v":27.713691883342431}," m"]
[]
[3.2,"Bed.1:  ko/ku < 0.1"]
["   3.2  a)","Bed.2:  D0 <= 0.25a"]
[]
[]
[]
[]
[]
[null,null,"Iterative Lösung mit der ",null,"Zielzelle"]
[null,null,"Zielwertsuche von EXCEL",null,{"$f":"2*SQRT(2*D0/(1+4*D0/a_2*(_c+0.32))*hS*ku/ko*(ko/q-1))-a_2","v":-3.878763630650667}," = Null","Zielwert"]
[null,null,"wegen D2=f(a)",null,null,null,0]
[null,null,null,null,"veränderbare Zelle"]
[null,null,null,null,30]
[null,null,"Dränabstand Ansatz 3.2 a)","a = ",{"$f":"IF(ko/ku>=0.1,\"s.Bed.1.!\",IF(D0>0.25*a_2,\"s.Bed.2!\",a_2))","v":"s.Bed.1.!"},"m"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"eff. benetzter Umfang  Ue ","Ue ",{"$f":" 2*_r*PI()*gamma","v":0.62831853071795862}," m"]
[null,null,null,"b ",{"$f":"1","v":1}]
[null,null,null,"c ",{"$f":"2/PI()*LN(b*D0/Ue)","v":1.016115272775405}]
["3  b)","Bed.2:  D0 > 0.25a"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Iterative Lösung mit der ",null,"Zielzelle",null,"Zielwert"]
[null,null,"Zielwertsuche von EXCEL",null,{"$f":"PI()*ku*hS/q/LN(a_6/Ue)-a_6","v":4.8274649624461148}," = Null",0]
[]
[null,null,null,null,"veränderbare Zelle"]
[null,null,null,null,30]
[null,null,"Dränabstand Ansatz  3 b)","a ",{"$f":"IF(D0>a_6/4,a_6,\"s.Bed.2\")","v":"s.Bed.2"}," m"]

{"sheet":"4 Drän in ob. Sch.","index":4,"n_rows":74,"n_cols":12,"rows_kept":74,"cut":false,"hidden":false,"merged":[[31,3,31,11]]}
["Dränabstand (TGL 42812/07) - Zweischichtiger Grundwasserleiter, Schichtgrenze unterhalb Dräntiefe"]
["Ansatz","Bedingungen",null,"Berechnungsgleichungen",null,null,null,null,null,null,null,"      geohydraulisches Schema"]
[]
[]
[4.0999999999999996,"ko/ku >= 0.1  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Tab. 1        b-Werte:"]
[null,null,null,"Du/D0 "]
[null,null,"ku/ko ",0.1,0.25,0.5,1,2,4,7,10,16]
[null,null,0.1,1,1,1,1,1.5,2,4,15,120]
[null,null,0.25,1,1,1,1.5,2,4,10,20,90]
[null,null,0.5,1,1,1.5,1.5,2.5,5,10,20,40]
[null,null,1,1,1.5,1.5,2,3,5,8,10,15]
[null,null,2,1,1.5,2,2.5,3,5,6,8,8]
[null,null,4,1.5,1.5,2,2.5,3,4,5,5,6]
[null,null,10,2,2,3,3,4,4,5,5,4.5]
[null,null,30,3,3,3,4,4,4,4,4,4]
[]
[]
[null,null,null,null,null,null,null,"Die Variablen im grünen Feld sind einzugeben"]
[null,null,"Dränabflußspende",null,null,null,"q ",7.0000000000000001E-3," m/d"]
[null,null,"Mächtigkeit ob. Schicht  Dob",null,null,null,"Dob ",2," m"]
[null,null,"Mächtigkeit der unt. Schicht  Du ",null,null,null,"Du ",2," m"]
[null,null,"hydraul. Leitf. ob. Schicht   ko ",null,null,null,"ko ",2," m/d"]
[null,null,"hydraul. Leitf. unt. Schicht  ku ",null,null,null,"ku ",1," m/d","ku/ko =",{"$f":"ku/ko","v":0.5}]
[null,null,"Mächtigkeit  D0 ",null,null,null,"D0 ",{"$f":"Dob-hS-tE","v":1.1000000000000001}," m","Du/D0 =",{"$f":"Du/D0","v":1.8181818181818181}]
[null,null,"b-Wert nach Tab.1",null,null,null,"b ",5]
[null,null,"Dränrohrtiefe  tD",null,null,null,"tD ",1.1000000000000001," m"]
[null,null,"Entwässerungstiefe  tE",null,null,null,"tE ",0.6," m"]
[null,null,"Dränrohrradius  r",null,null,null,"r ",0.1," m"]
[null,null,"Red.fakt. ben. Umfang",null,null,null,"gamma ",0.2]
[null,null,"geohydraul. Druckhöhe  hS ",null,null,null,"hS",{"$f":"tD-tE-2*_r","v":0.3000000000000001}," m"]
[null,null,"eff. benetzter Umfang  Ue ",null,null,null,"Ue",{"$f":"2*_r*PI()*gamma","v":0.12566370614359174}," m"]
[4.0999999999999996,"ko/ku >= 0.1  ",null,null,null,null,"b ",1," nach Tab.1 auf Tabellenblatt \"Ernst C\""]
[null,null,null,null,null,null,"D_4 ",{"$f":"hS/2+D0+Du*ku/ko","v":2.25}]
[null,null,null,null,null,null,"c ",{"$f":"2/PI()*LN(b*D0/Ue)","v":2.405718657980187}]
[null,null,null,null,null,null,null,{"$f":"2*D_4*(SQRT(_c^2+hS/D_4*(2*ko/q-1))-_c)","v":29.884874713604965}]
[null,null,null,null,null,"Dränabstand Ansatz 4.1","a = ",{"$f":"IF(ko/ku<0.1,\"s.Bed.!\",a_7)","v":29.884874713604965}," m"]
[4.2,"ko/ku < 0.1"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"D_5 ",{"$f":"D0+Du*ku/ko","v":2.1}]
[null,null,null,null,null,null,null,{"$f":"2*D_5*(SQRT(_c^2+hS/D_5*(2*ko/q+q/ko-3))-_c)","v":29.069186854977715}]
[null,null,null,null,null,"Dränabstand Ansatz 4.2","a = ",{"$f":"IF(ko/ku>=0.1,\"s.Bed.\",a_8)","v":"s.Bed."},"m"]

{"sheet":"5 Drän in unt. Sch.","index":5,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Dränabstand (TGL 42812/07) - Zweischichtiger Grundwasserleiter, Schichtgrenze oberhalb Dräntiefe"]
["Ansatz","Bedingungen",null,"Berechnungsgleichungen",null,null,null,null,"geohydraulisches Schema"]
[]
[5,"ko/ku < 0.1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Die Variablen im grünen Feld sind einzugeben"]
[null,null,"Dränabflußspende",null,"q ",7.0000000000000001E-3," m/d"]
[null,null,"hydraul. Leitf. ob. Schicht  ko ",null,"ko ",0.1," m/d"]
[null,null,"hydraul. Leitf. unt. Schicht  ku ",null,"ku ",2," m/d"]
[null,null,"Mächtigkeit ob. Schicht  Dob",null,"Dob ",1," m"]
[null,null,"Mächtigkeit der unt. Schicht  Du ",null,"Du ",2," m"]
[null,null,"Dränrohrtiefe  tD",null,"tD ",1.2," m"]
[null,null,"Entwässerungstiefe  tE",null,"tE ",0.6," m"]
[null,null,"Dränrohrradius  r",null,"r ",0.1," m"]
[null,null,"Red.fakt. Ben. Umfang  ",null,"gamma ",0.2]
[null,null,"Mächtigkeit  D0 ",null,"D0 ",{"$f":"Dob+Du-tE-hS","v":2}," m"]
[null,null,"Mächtigkeit  D* ",null,"D* ",{"$f":"Du-D0","v":0}," m"]
[null,null,"geohydraul. Druckhöhe  hS ",null,"hS ",{"$f":"tD-tE-2*_r","v":0.39999999999999997}," m"]
[null,null,"eff. benetzter Umfang  Ue ",null,"Ue ",{"$f":"2*_r*PI()*gamma","v":0.12566370614359174}," m"]
[]
[null,null,null,null,"c ",{"$f":"2/PI()*LN(1*D0/Ue)","v":1.7617135158605954}]
[null,null,null,null,null,{"$f":"2*Du*(SQRT(_c^2+2*ku/ko*(hS*(ko/q-2)+D)/Du)-_c)","v":33.230057198009668}]
[null,null,null,"Dränabstand Ansatz 5","a = ",{"$f":"IF(ko/ku<0.1,a,\"s.Bed.!\")","v":33.230057198009668}," m"]

{"sheet":"6 gespannter GWL","index":6,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Dränabstand (TGL 42812/07) - Homogene Deckschicht über gespanntem Grundwasserleiter"]
["Ansatz","    Bedingungen",null,"Berechnungsgleichungen",null,null,null,null,null,null,"      geohydraulisches Schema"]
[]
[]
[]
[]
[6]
[6.1,"D0 <= 0.33a"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Die Variablen im grünen Feld sind einzugeben"]
[null,null,"Dränabflußspende",null,null,null,"q ",1.4999999999999999E-2," m/d"]
[null,null,"ges.hydraulische Leitfähigkeit",null,null,null,"k ",0.7," m/d"]
[null,null,"Mächtigkeit D0 ",null,null,null,"D0 ",5," m"]
[null,null,"Druckhöhe des gesp. GW über Drän DH ",null,null,null,"deltaH ",0.5," m"]
[null,null,"erwünschter GW-Spiegel über Drän  hS ",null,null,null,"hS ",0.5," m"]
[null,null,"Reduktionsfakt. f. ben. Umfang g ",null,null,null,"gamma",0.15," s. Tabellenblatt \"1,2 homogen\""]
[null,null,"Aussendurchmesser da ",null,null,null,"da ",0.2," m"]
[]
[null,null,null,null,null,null,"deltaHstern",{"$f":"(deltaH+q*D0/k)/hS","v":1.2142857142857144}]
[null,null,null,null,null,null,"QL ",{"$f":"PI()*k*deltaHstern*hS/LN(8*D0/PI()/SQRT(2*gamma*da*(hS+gamma*da)))","v":0.3128127673753161}]
[null,null,null,null,null,null,null,{"$f":"4*D0/PI()*LN(4/TANH((PI()*(deltaHstern-1)*k*hS/QL)))","v":11.695778111297185}]
[null,null,"Dränabstand Ansatz  6.1",null,null,null,"a = ",{"$f":"IF(D0>0.33*a_11,\"s.Bed.!\",a_11)","v":"s.Bed.!"}," m"]
[]
[]
[]
[]
[6.2,"D0 > 0.33a"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"dstern ",{"$f":"SQRT(2*gamma*da*(deltaH+gamma*da))","v":0.1783255450012701},"m"]
[]
[null,null,"Iterative Lösung mit der ",null,null,null,"Zielzelle",null,"Zielwert"]
[null,null,"Zielwertsuche von EXCEL",null,null,null,{"$f":"PI()*D0/(LN(2)+(deltaHstern-1)*LN(2*a_22/(PI()*dstern)))-a_22","v":-5.794493773692011E-10}," = Null",0]
[]
[null,null,null,null,null,null,"veränderbare Zelle"]
[null,null,"Dränabstand Ansatz  6.2",null,null,null,10.663770042515059]
[null,null,null,null,null,"a = ",{"$f":"IF(D0>0.33*a_22,a_22,\"s.Bed.!\")","v":10.663770042515059},"m"]

{"sheet":"Ernst A","index":7,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Dränabstandsberechnung nach Ernst (Studienblatt Nr. 12 1970, ETH Zürich)"]
["Ansatz","Bedingungen",null,"Berechnungsgleichungen",null,null,null,null,"geohydraulisches Schema"]
[]
["ERNST","homogen"]
["Fall A"]
[null,"D0 < 1/4 a"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Variablen in grünen Feldern eingeben !"]
[null,null,"Dränabflußspende  q",null,"q = ",7.0000000000000001E-3," m/d"]
[]
[null,null,"gesätt. hydraul. Leitf. k ",null,"k = ",1," m/d"]
[null,null,"Dräntiefe  tD",null,"tD = ",1.1000000000000001," m"]
[null,null,"Entwässerungstiefe  tE",null,"tE = ",0.6," m",null,"Ue = ",{"$f":"PI()*(2*_r)*gamma","v":0.12566370614359174}]
[null,null,"Dränrohrradius",null,"r = ",0.1," m"]
[null,null,"Reduktionsfaktor für benetz. Umfang",null,"gamma = ",0.2,null,null,"hh = ",{"$f":"q/(8*k*D1_)*ac^2","v":0.13818181729608517}]
[null,null,"Abst. OKG - GW-Stauer D",null,"D = ",4,"m",null,"hr = ",{"$f":"q/PI()/k*LN(D0/Ue)*ac","v":0.1618130569347184}]
[null,null,null,null,"D0 = ",{"$f":"D-tE-hS","v":3.0999999999999996}," m"]
[null,null,null,null,"D1_ =",{"$f":"hS/2+D0","v":3.2499999999999996}," m"]
[]
[null,null,"geohydraul. Druckhöhe  hS ",null,"hS = ",{"$f":"tD-tE-2*_r","v":0.3000000000000001}," m"]
[null,null,null,null,null,"Zielzelle",null,"Zielwert"]
[null,null,"Iterative Lösung mit der ",null,null,{"$f":"hh+hr-hS","v":-5.1257691965345131E-6}," = Null",0]
[null,null,"Zielwertsuche von EXCEL"]
[null,null,null,null,null,"veränderbare Zelle"]
[null,null,null,null,"ac = ",22.654949789326121]
[null,null,"Dränabstand  a",null,"a = ",{"$f":"ac","v":22.654949789326121},"m",{"$f":"IF(D0>ac/4,\"Bed. nicht erfüllt, anderen Ansatz benutzen!\",\"Bed. ist erfüllt\")","v":"Bed. ist erfüllt"}]

{"sheet":"Ernst B","index":8,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Dränabstandsberechnung nach Ernst (Studienblatt Nr. 12 1970, ETH Zürich)"]
["Ansatz","Bedingungen",null,"Berechnungsgleichungen",null,null,null,null,"geohydraulisches Schema"]
[null,"Schichtgrenze"]
["ERNST","in oder oberhalb"]
["Fall B","Dräntiefe"]
[]
[null,"1)   ko<<ku"]
[null,null,null,null,"Die Variablen im grünen Feld sind einzugeben"]
[null,"Dränabflußspende  q",null,"q = ",7.0000000000000001E-3," m/d"]
[null,"Dicke obere Schicht  Dob",null,"Dob = ",1.1000000000000001," m"]
[null,"Dicke untere Schicht  Du",null,"Du = ",2.9," m"]
[null,"gesätt. hydraul. Leitf. ko ",null,"ko = ",0.2," m/d"]
[null,"gesätt. hydraul. Leitf. ku ",null,"ku = ",2,{"$f":"IF(ko/ku>10,\" ko>>ku ---> Hoogh./Ernst benutzen !\",\"\")","v":""}]
[null,"Dräntiefe  tD",null,"tD = ",1.1000000000000001," m"]
[null,"Entwässerungstiefe  tE",null,"tE = ",0.6," m"]
[null,"Dränrohrradius",null,"r = ",0.1," m"]
[null,"Reduktionsfaktor für benetz. Umfang",null,"gamma = ",0.2]
[null,null,null,null,{"$f":"IF(tE>Dob,\"tE > Dob ===> evtl. Modell für homogenen GWL benutzen!\",\"\")","v":""}]
[null,"Abstand GW-Stauer - Drän  D0 ",null,"D0 = ",{"$f":"Dob+Du-tD+2*_r","v":3.1}]
[null,"massgeb. Dicke für vertikale"]
[null,"Strömungskomponente",null,"Dv = ",{"$f":"MAX(Dob-tE,0)","v":0.50000000000000011}]
[null,"geohydraul. Druckhöhe  hS ",null,"hS = ",{"$f":"tD-tE-2*_r","v":0.3000000000000001}]
[null,null,null,"D1_ = ",{"$f":"hS/2","v":0.15000000000000005}]
[]
[null,null,null,null,"Zielzelle","Zielwert"]
[null,"Iterative Lösung mit der ",null,null,{"$f":"hh_1+hr_1+hv-hS","v":2.5789618526117497E-5}," = 0"]
[null,"Zielwertsuche von EXCEL",null,null,"veränderbare Zelle",null,null,null,"Ue = ",{"$f":"PI()*2*_r*gamma","v":0.12566370614359174}]
[null,null,null,"a1_ = ",33.028501100398245]
[null,null,"Dränabstand  a","a = ",{"$f":"a1_","v":33.028501100398245}," m",null,"wenn 1) erfüllt ist:","hh_1 = ",{"$f":"q/(8*ku*Du)*a1_^2","v":0.1645726981589021}]
[null,null,null,null,null,null,null,null,"hr_1 = ",{"$f":"q/PI()/ku*LN(D0/Ue)*a1_","v":0.11795309145962408}]
[null,"2)   ko <> ku",null,null,null,null,null,null,"hv = ",{"$f":"q*Dv/ko","v":1.7500000000000005E-2}]
[]
[null,null,null,null,null,null,null,"wenn 2) erfüllt ist:","hh_2 = ",{"$f":"q/(8*(ko*D1_+ku*Du))*a2_^2","v":0.17721679211951782}]
[null,null,null,null,"Zielzelle","Zielwert",null,null,"hr_2 = ",{"$f":"q/PI()/ku*LN(D0/Ue)*a2_","v":0.12271655340089994}]
[null,null,null,null,{"$f":"hh_2+hr_2-hS","v":-6.6654479582317627E-5}," = 0"]
[null,null,null,null,"veränderbare Zelle"]
[null,null,null,"a2_ = ",34.362336492266628]
[null,null,"Dränabstand  a","a = ",{"$f":"a2_","v":34.362336492266628}," m"]

{"sheet":"Ernst C","index":9,"n_rows":38,"n_cols":23,"rows_kept":38,"cut":false,"hidden":false,"merged":[[25,14,25,22]]}
["Dränabstandsberechnung nach Ernst (Studienblatt Nr. 12 1970, ETH Zürich)"]
["Ansatz","Bedingungen",null,"Berechnungsgleichungen",null,null,null,null,"geohydraulisches Schema"]
[]
["ERNST","Schichtgrenze"]
["Fall C","unterhalb"]
[null,"Dräntiefe"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Die Variablen im grünen Feld sind einzugeben"]
[null,null,"Dränabflußspende  q",null,"q = ",7.0000000000000001E-3," m/d"]
[null,null,"Dicke obere Schicht  Dob",null,"Dob = ",1.5," m"]
[null,null,"Dicke untere Schicht  Du",null,"Du = ",2.5," m",null,"Dv = ",{"$f":"tD-tE","v":0.50000000000000011}]
[null,null,"gesätt. hydraul. Leitf. ko ",null,"ko = ",2," m/d",null,"D1 = ",{"$f":"D0+hS/2","v":0.74999999999999989}]
[null,null,"gesätt. hydraul. Leitf. ku ",null,"ku = ",1," m/d",null,"Ue = ",{"$f":"PI()*2*_r*gamma","v":0.12566370614359174},null,null,null,"Tab. 1        b-Werte:"]
[null,null,"Dräntiefe  tD",null,"tD = ",1.1000000000000001," m",null,null,null,null,null,null,null,"Du/D0 "]
[null,null,"Entwässerungstiefe  tE",null,"tE = ",0.6," m",null,"hh = ",{"$f":"q/(8*(ko*D1_+ku*Du))*ac^2","v":0.19323604204214992},null,null,null,"ku/ko ",0.1,0.25,0.5,1,2,4,7,10,16]
[null,null,"Dränrohrradius",null,"r = ",0.1," m",null,"hr = ",{"$f":"q/PI()/ko*LN(b*D0/Ue)*ac","v":0.10505704634567085},null,null,null,0.1,1,1,1,1,1.5,2,4,15,120]
[null,null,"Reduktionsfaktor für benetz. Umfang",null,"gamma = ",0.2,"ku/ko = ",{"$f":"ku/ko","v":0.5},"hv = ",{"$f":"q*Dv/ko","v":1.7500000000000005E-3},null,null,null,0.25,1,1,1,1.5,2,4,10,20,90]
[null,null,"Abstand GW-Stauer - Schichtgrenze  D0 ",null,"D0 = ",{"$f":"Dob-tE-hS","v":0.59999999999999987},"Du/D0 = ",{"$f":"Du/D0","v":4.1666666666666679},null,null,null,null,null,0.5,1,1,1.5,1.5,2.5,5,10,20,40]
[null,null,"b-Wert nach Tab.1  (s. rechts)",null,"b = ",5,null,null,null,null,null,null,null,1,1,1.5,1.5,2,3,5,8,10,15]
[null,null,"geohydraul. Druckhöhe  hS ",null,"hS = ",{"$f":"tD-tE-2*_r","v":0.3000000000000001}," m",null,null,null,null,null,null,2,1,1.5,2,2.5,3,5,6,8,8]
[null,null,null,null,null,"Zielzelle",null,"Zielwert",null,null,null,null,null,4,1.5,1.5,2,2.5,3,4,5,5,6]
[null,null,"Iterative Lösung mit der ",null,null,{"$f":"hh+hr+hv-hS","v":4.30883878206334E-5}," = Null",0,null,null,null,null,null,10,2,2,3,3,4,4,5,5,4.5]
[null,null,"Zielwertsuche von EXCEL",null,null,null,null,null,null,null,null,null,null,30,3,3,3,4,4,4,4,4,4]
[null,null,null,null,null,"veränderbare Zelle"]
[null,null,null,null,"ac = ",29.721452919082822]
[null,null,"Dränabstand  a",null,"a = ",{"$f":"ac","v":29.721452919082822}," m"]

{"sheet":"Instationär","index":10,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Instationäre Dränformel (Glover-Dumm-Formel) für fallenden Wasserspiegel"]
["Ansatz","Bedingungen",null,"Berechnungsgleichungen",null,null,null,null,"geohydraulisches Schema"]
[]
["Glover-","homogener"]
["Dumm","Grundwasser-"]
[null,"leiter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Die Variablen im grünen Feld sind einzugeben"]
[null,null,"Außenradius","r_ = ",0.05," m"]
[null,null,"Abst. OKG - GW-Stauer D","D = ",3," m"]
[null,null,"Dräntiefe tD","tD = ",1," m"]
[null,null,"dränbares Porenvolumen ndr","ndr = ",0.05," m3/m3"]
[null,null,"gesätt. hydraul. Leitf. ks ","ks = ",0.3," m/d"]
[null,null,"Entwässerungstiefe zur Zeit 0,  tE.0","tE.0 = ",0," m"]
[null,null,"Entwässerungstiefe zur Zeit t, tE.t","tE.t = ",0.5," m"]
[null,null,"Zeit t","t = ",2.2496409398128341," d"]
[null,null,"benetzter Umfang lU","lU = ",{"$f":"r_*PI()","v":0.15707963267948966}," m"," der benetzte Umfang muss hier eingetragen werden, falls er  "]
[null,null,null,null,null,null," anders berechnet werden soll als \"lU = r_*PI()\""]
[null,null,"Abst. GW-Stauer - Wassersp. im Drän  D0 ","D0 = ",{"$f":"D-tD+r_","v":2.0499999999999998}," m"]
[null,null,"geohydraul. Anfangsdruckhöhe  ht=0","ht0 = ",{"$f":"tD-tE.0-r_","v":0.95}," m"]
[null,null,"geohydraul. Druckhöhe bei t, ht","ht = ",{"$f":"tD-tE.t-r_","v":0.45}," m"]
[null,null,"Kriterium a/4","kri = ",{"$f":"a.smed/4","v":3}]
[null,null,null,"alpha = ",{"$f":"PI()^2*ks*de.smed/ndr/a.smed^2","v":0.39812326985079205}]
[null,null,"Mächtigkeit der Äquivalentschicht de","de = ",{"$f":"IF(D0<kri,D0/(8*D0/PI()/a.smed*LN(D0/lU)+1),PI()*a.smed/(8*LN(a.smed/lU)))","v":0.96811970248416246}," m"]
[]
[null,null,"Iterative Lösung mit der ",null,"Zielzelle",null,"Zielwert"]
[null,null,"Zielwertsuche von EXCEL",null,{"$f":"PI()^2*ks*de.smed*t/ndr/(LN(1.16*ht0/ht))-a.smed^2","v":0}," = Null",0]
[null,null,null,null,"mögliche veränderbare Zelle"]
[null,"Dränabstand aus",null,null,12]
[null,"instat. Formel",null,"a = ",{"$f":"a.smed","v":12}," m"]

{"sheet":"Tabelle2","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tabelle3","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}