{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Info","Sondenauslegung","Daten"],"not_rendered":{"images":1,"defined_names":52,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Info","index":0,"n_rows":29,"n_cols":5,"rows_kept":29}
[]
[null,"Dimensionierungshilfe für Umwälzpumpen in geschlossenen Erdwärmesonden:"]
[null,"Programm   E W S D R U C K"]
[null,"Hergestellt im Rahmen des UAW-Forschungsprojektes: \"Kostengünstige Niedrigtemperaturheizung mit Wärmepumpe\""]
{"$rows_empty":10}
[null,"Hergestellt von:",null,"Arthur Huber, Markus Ochs"]
[{"$nulls":3},"Huber Energietechnik AG, Zürich"]
[]
[{"$nulls":3},"Michael Wetter"]
[{"$nulls":3},"Hochschule Technik+Architektur Luzern (HTA)"]
[]
[{"$nulls":3},"Felix Kaufmann"]
[{"$nulls":3},"Hochschule Technik+Architektur Luzern (HTA)"]
[]
[null,"Version:",null,"2.0","August 2007"]
[]
[]
[]
[{"$nulls":4},"Diese Arbeit ist im Auftrag des Bundesamtes für Energie entstanden. Für den Inhalt "]
[{"$nulls":4},"und die Schlussfolgerungen ist ausschliesslich der Autor dieses Berichts verantwortlich."]

{"sheet":"Sondenauslegung","index":1,"n_rows":86,"n_cols":12,"rows_kept":86,"merged":[[1,2,1,3]]}
[null,"Pumpen-Auslegungsprogramm für Erdsonden"]
[null,"Objekt:"]
[]
[null,"Gebäude und Standort",{"$nulls":5},"Stoffwerte Sondenfluid"]
[{"$nulls":9},{"$f":"IF(dt<>\"\",IF(Fluid=1,\"\",IF(OR(INDEX(Daten!H12:H16,H6-1,1)>=INDEX(Daten!K12:K22,J6,1),TR-0.5<=INDEX(Daten!H12:H16,H6-1,1)),\"Frostwarnung!\",\"\")),\"\")","v":""}]
[null,"Wärmebedarf",null,null,"kW",null,null,2,null,4]
[null,"Warmwasserbedarf",null,null,"kW",null,null,"Dichte  r",null,{"$f":"INDEX(Daten!C11:C17,H6,1)","v":1000},"kg/m3"]
[null,"Andere",null,null,"kW",null,null,"Kinematische Viskosität n",null,{"$f":"INDEX(Daten!L12:L22,J6,1)*1000000","v":1.6039999999999999},"mm2/s"]
[null,"Gebäude Total",null,{"$f":"SUM(D6:D8)","v":{"v":0,"d":"0.0"}},"kW",null,null,"spez. Wärmekapazität cp",null,{"$f":"INDEX(Daten!G11:G17,H6,1)","v":4.22},"kJ/(kg*K)"]
[null,"Lage",null,{"v":1,"d":"1.0"},{"$nulls":3},"Frost bei",null,{"$f":"INDEX(Daten!H11:H17,H6,1)","v":0},"°C"]
[null,"Jahresmitteltemperatur",null,null,"°C",null,null,"Wärmeübergangskoeffizient a",null,{"$f":"alpha","v":0},"W/m²K"]
[null,"Wärmeleitfähigkeit der  Erde",null,null,"W/mK"]
[null,"mittlere Erdreichtemperatur",null,{"$f":"IF(H<>\"\",(INDEX(Daten!C32:C35,D10,1))+D11+H/2*(0.035),\"\")","v":""},"°C",null,null,"Druckverluste in Verteiler, Zuleitung und Sonde"]
[]
[null,"Wärmepumpe",{"$nulls":5},"Verteiler Nenndruckverlust",null,null,"kPa"]
[null,null,{"$f":"IF(AND(OR(Qh<(D9*0.75),Qh>(D9*1.25)),Qh<>\"\",Qh<>0),\"Wärmepumpenleistung überprüfen!\",\"\")","v":""},{"$nulls":4},"Verteiler Nennmassenstrom",null,null,"kg/h"]
[null,"Fabrikat:",null,"Typ:",{"$nulls":3},"Vol.strommesser Nenndruckverlust",null,null,"kPa"]
[null,"Nennleistung Wärmepumpe",null,null,"kW",null,null,"Vol.strommesser Nennmassenstrom",null,null,"kg/h"]
[null,"COP bei obiger Nennleistung",null,null,"-",null,null,"Sonstige Elemente Nenndruckverlust",null,null,"kPa"]
[null,"Nenndruckverlust Verdampfer",null,null,"kPa",null,null,"Sonstige Elemente Nennmassenstrom",null,null,"kg/h"]
[null,"Nennmassenstrom Verdampfer",null,null,"kg/h",null,null,"Sondenanschlüsse Innendurchmesser",null,null,"mm"]
[null,"Entzugsprofil / Schaltintervall",null,{"v":2,"d":"2.0"},{"$nulls":3},"Sondenanschlüsse Länge horizontale",null,null,"m"]
[null,"Leistungsaufnahme (elektrisch) ",null,{"$f":"IF(Qh>0,IF(COP>0,(Qh/COP),Qh),\"\")","v":""},"kW",null,null,"Sonden am Bohrkopf zusammengefasst",null,1]
[null,"Massenstrom Verdampfer",null,{"$f":"IF(dt>0,IF(COP>0,Qh*(1-1/COP)/cp/dt*3600,\"\"),\"\")","v":""},"kg/h",null,null,"Bogen 90° (z = 2)",null,null,"Stk."]
[null,{"$f":"IF(Daten!G40>15,\" hoher Druckabfall im Verdampfer!\",\"\")","v":""},null,{"$f":"IF(AND(qspez<>\"\",dt<>\"\"),IF((D24/3600)>(1.3*(Qe/qspez)/(2*cp*ra)),\" Massenstrom zu gross!\",\"\"),\"\")","v":""},{"$nulls":3},"Tauchhülsen (z = 1)",null,null,"Stk."]
[null,"Sondenparameter",null,"  ",{"$nulls":3},"Sonstige z-Werte oder Sz",null,null,"-"]
[null,{"$f":"IF(AND(D29>0,D28>0),\"doppelte Eingabe!   Spez. Sondenleistung löschen!\",IF(qspez=\"\",\"\",IF(qspez>(1.1*qspezmax),\"sehr grosse Sondenbelastung!\",IF(qspez>qspezmax,\"grosse Sondenbelastung!\",\"\"))))","v":""},{"$nulls":5},"Methode Berechg. Druckverlustkoeff. x",null,1]
[null,"spezifische Sondenleistung",null,null,{"$f":"IF(AND(D28=0,D29=0),\"\",IF(D28=0,(IF(COP>0,IF(Qh>0,Qh*(1-1/COP),0),D20))*1000/AnzahlSonden/H,D28))","v":""},"W/m"]
[null,"Bohrtiefe",null,null,{"$f":"IF(AND(D28=0,D29=0),\"\",IF(D29=0,Qh*1000*(1-1/COP)/(qspez*AnzahlSonden),D29))","v":""},"m",null,"Sonden - Umwälzpumpe"]
[null,"Anzahl Sonden",null,null,{"$f":"IF(D30>0,D30,1)","v":1}]
[null,"Temperaturdifferenz Vorl./Rückl.",null,null,"K",null,null,"Fabrikat:",null,"Typ:"]
[null,"Bohrlochdurchmesser",null,null,"cm",null,null,"Totaler Druckabfall",null,{"$f":"IF(dt<>\"\",D41+pext,\"\")","v":""},"kPa"]
[null,"Rohrdimension",null,2,{"$nulls":5},{"$f":"IF(dt<>\"\",IF(rho>0,J32*1000/(rho*9.81),0),\"\")","v":""},"m"]
[{"$nulls":7},"Volumenstrom",null,{"$f":"IF(dt<>\"\",J35/3600,\"\")","v":""},"m³/s"]
[null,"Strömungswerte (für 1 Sonden-Rohr)",{"$nulls":7},{"$f":"IF(dt<>\"\",IF(rho>0,$D$24/rho,0),\"\")","v":""},"m³/h"]
[null,{"$f":"IF(dt<>\"\",IF(AND(D38>0.55,re>3000),\"grosse Fliessgeschwindigkeit!\",\"\"),\"\")","v":""},{"$nulls":5},"benötigte Leistung der Pumpe",null,{"$f":"IF(dt<>\"\",J32*1000*J34,\"\")","v":""},"W"]
[null,"Massenstrom in Sondenrohr",null,{"$f":"IF(dt<>\"\",IF(Fluid=1,\"\",$D$24/2/AnzahlSonden),\"\")","v":""},"kg/h",null,null,"Wirkungsgrad der Pumpe",null,null,{"$f":"IF(AND(J38=\"\",J37=\"\"),\"\",IF(J37=\"\",J36/J38*100,J37))","v":""},"%"]
[null,"Geschwindigkeit in Sondenrohr",null,{"$f":"IF(dt<>\"\",IF(Fluid=1,,mSonde/3600*4/rho/(dinnen)^2/PI()),\"\")","v":""},"m/s",null,null,"Leistungsaufnahme Pumpe",null,null,{"$f":"IF(AND(J37=\"\",J38=\"\"),\"\",IF(J38=\"\",J36/J37*100,J38))","v":""},"W"]
[null,"Art der Strömung (laminar/turbul.)",null,{"$f":"IF(dt<>\"\",IF(re<2300,\"laminar\",\"turbulent\"),\"\")","v":""},{"$nulls":3},{"$f":"IF(eta<>\"\",IF(AND(J37>0,J38>0),\"doppelte Eingabe! Wirkungsgrad oder Leistungsaufnahme löschen!\",IF(eta<20,\"schlechter Pumpenwirkungsgrad!\",IF(eta>40,\"sehr guter Pumpenwirkungsgrad!\",\"\"))),\"\")","v":""}]
[null,"mittlerer spezifischer Druckverlust",null,{"$f":"IF(dt<>\"\",rho/2 * wSonde^2 / dinnen * Daten!G49,\"\")","v":""},"Pa/m",null,null,"Anteil  der Pumpenenergie am Stromverbrauch"]
[null,"Druckverlust im Sondenrohr",null,{"$f":"IF(dt<>\"\",D40*2*H/1000,\"\")","v":""},"kPa",null,null,"  Anteil Sondenpumpe:",null,{"$f":"IF(K38<>\"\",K38/(K38+D23*1000)*100,0)","v":{"v":0,"d":"0.0"}},"%"]
[]
[]
[]
[{"$nulls":5},"Diese Arbeit ist im Auftrag des Bundesamtes für Energie entstanden. Für den Inhalt "]
[{"$nulls":5},"und die Schlussfolgerungen ist ausschliesslich der Autor dieses Berichts verantwortlich."]
[]
[]
[null,{"$f":"B2","v":"Objekt:"},null,{"$f":"IF(C2<>\"\",C2,\"\")","v":""}]
[]
[]
[null,{"$f":"B4","v":"Gebäude und Standort"}]
[]
[null,"Wärmebedarf (total):",null,null,{"$f":"IF(D9=\"\",\"\",D9)","v":0},"kW"]
[]
[]
[null,"Wärmepumpe"]
[]
[null,"Fabrikat:",null,null,{"$f":"IF(C17=\"\",\"\",C17)","v":""}]
[null,"Typ:",null,null,{"$f":"IF(E17=\"\",\"\",E17)","v":""}]
[null,"COP:",null,null,{"$f":"IF(COP=\"\",\"\",COP)","v":""},"-"]
[null,"Leistungsaufnahme:",null,null,{"$f":"IF(D23=\"\",\"\",D23)","v":""},"kW"]
[]
[]
[null,"Sonden"]
[]
[null,"Bohrtiefe:",null,null,{"$f":"IF(H=\"\",\"\",H)","v":""},"m"]
[null,"Bohrdurchmesser:",null,null,{"$f":"db","v":0},"cm"]
[null,"Sondendurchmesser:",null,null,{"$f":"INDEX(Daten!A23:A25,D33,1)","v":"DN 32"}]
[null,"Medium:",null,null,{"$f":"INDEX(Daten!B11:B17,H6,1)","v":"Wasser"}]
[]
[]
[null,"Umwälzpumpe"]
[]
[null,"Fabrikat:",null,null,{"$f":"IF(I31=\"\",\"\",I31)","v":""}]
[null,"Typ:",null,null,{"$f":"IF(K31=\"\",\"\",K31)","v":""}]
[null,"Volumenstrom:",null,null,{"$f":"IF(J35=\"\",\"\",J35)","v":""},"m³/h"]
[null,"Förderhöhe:",null,null,{"$f":"IF(J33=\"\",\"\",J33)","v":""},"m"]
[null,"Wirkungsgrad:",null,null,{"$f":"IF(eta=\"\",\"\",eta)","v":""},"%"]
[null,"Leistungsaufnahme:",null,null,{"$f":"IF(K38=\"\",\"\",K38)","v":""},"W"]
[]
[]
[null,"Anteil der Umwälzpumpe am gesamten Energieverbrauch"]
[]
[]
[{"$nulls":7},{"$f":"IF(J41=\"\",\"\",J41)","v":{"v":0,"d":"0.0"}},"%"]

{"sheet":"Daten","index":2,"n_rows":53,"n_cols":28,"rows_kept":53,"hidden":true}
[]
[null,"spez. Wärmekapazität der Erde",null,"cp Erde",800,"J/(kg*K)","qspez."]
[null,"mittlere Dichte der Erde",null,"r Erde",2600,"kg/m³","max."]
[null,"thermischer Sondenwiderstand",null,"Rc",0.08,"Km/W",{"$f":"IF(lambdaErde>3,80,IF(lambdaErde>2,55,IF(lambdaErde>1.5,50,40)))","v":40}]
[]
[]
[null,"Sole","Stoffwerte nach: Höchst, Antifrogen N / L"]
[{"$nulls":3},"Viskosität"]
[null,"Medium","Dichte","bei -10°C","0°C","bei 10°C","cp","Frost"]
[null,null,"kg/m3","m2/s","m2/s","m2/s","kJ/(kg*K)","°C",null,"Temperaturen:",null,"Viskosität",null,{"$f":"B12","v":"Wasser"},{"$f":"B13","v":"Monoethylenglykol 25%"},{"$f":"B14","v":"Monoethylenglykol 33%"},{"$f":"B15","v":"Monopropylenglykol 25%"},{"$f":"B16","v":"Monopropylenglykol 33%"},null,null,"Prandtl",null,null,"Wasser"]
[]
[null,"Wasser",1000,1.8e-06,1.8e-06,1.31E-6,4.22,0,null,"10 °C",10,{"$f":"INDEX(M12:R12,1,Sondenauslegung!$H$6)","v":{"v":1.31E-6,"d":"0.000001310"}},null,{"$f":"F12","v":{"v":1.31E-6,"d":"0.000001310"}},{"$f":"F13","v":{"v":2.91e-06,"d":"0.000002910"}},{"$f":"F14","v":{"v":3.73e-06,"d":"0.000003730"}},{"$f":"F15","v":{"v":3.94e-06,"d":"0.000003940"}},{"$f":"F16","v":{"v":5.58e-06,"d":"0.000005580"}},10,null,{"$f":"INDEX(W22:AB22,1,Sondenauslegung!$H$6)","v":9.34},null,-10,13.01,49.53,67.57,85.64,140.29]
[null,"Monoethylenglykol 25%",1053,6.27e-06,4.15e-06,2.91e-06,3.8,-14,null,"8 °C",8,{"$f":"INDEX(M13:R13,1,Sondenauslegung!$H$6)","v":{"v":1.408e-06,"d":"0.000001408"}},null,{"$f":"N$12+(N$17-N$12)/5","v":{"v":1.408e-06,"d":"0.000001408"}},{"$f":"O$12+(O$17-O$12)/5","v":{"v":3.158e-06,"d":"0.000003158"}},{"$f":"P$12+(P$17-P$12)/5","v":{"v":4.078e-06,"d":"0.000004078"}},{"$f":"Q$12+(Q$17-Q$12)/5","v":{"v":4.3480000000000006E-6,"d":"0.000004348"}},{"$f":"R$12+(R$17-R$12)/5","v":{"v":6.236e-06,"d":"0.000006236"}},8,null,{"$f":"INDEX(W21:AB21,1,Sondenauslegung!$H$6)","v":9.94},null,-8,13.01,45.26,61.51,76.91,124.79]
[null,"Monoethylenglykol 33%",1067,8.51e-06,5.47e-06,3.73e-06,3.56,-21,null,"6 °C",6,{"$f":"INDEX(M14:R14,1,Sondenauslegung!$H$6)","v":{"v":1.5059999999999999E-6,"d":"0.000001506"}},null,{"$f":"N$12+(N$17-N$12)/5*2","v":{"v":1.5059999999999999E-6,"d":"0.000001506"}},{"$f":"O$12+(O$17-O$12)/5*2","v":{"v":3.406e-06,"d":"0.000003406"}},{"$f":"P$12+(P$17-P$12)/5*2","v":{"v":4.426e-06,"d":"0.000004426"}},{"$f":"Q$12+(Q$17-Q$12)/5*2","v":{"v":4.7560000000000007E-6,"d":"0.000004756"}},{"$f":"R$12+(R$17-R$12)/5*2","v":{"v":6.8919999999999994E-6,"d":"0.000006892"}},6,null,{"$f":"INDEX(W20:AB20,1,Sondenauslegung!$H$6)","v":10.61},null,-6,13.01,41.47,56.15,69.27,111.36]
[null,"Monopropylenglykol 25%",1032,9.67e-06,5.98e-06,3.94e-06,3.92,-10,null,"4 °C",4,{"$f":"INDEX(M15:R15,1,Sondenauslegung!$H$6)","v":{"v":1.6039999999999998E-6,"d":"0.000001604"}},null,{"$f":"N$12+(N$17-N$12)/5*3","v":{"v":1.6039999999999998E-6,"d":"0.000001604"}},{"$f":"O$12+(O$17-O$12)/5*3","v":{"v":3.654e-06,"d":"0.000003654"}},{"$f":"P$12+(P$17-P$12)/5*3","v":{"v":4.774e-06,"d":"0.000004774"}},{"$f":"Q$12+(Q$17-Q$12)/5*3","v":{"v":5.164E-6,"d":"0.000005164"}},{"$f":"R$12+(R$17-R$12)/5*3","v":{"v":7.5479999999999996E-6,"d":"0.000007548"}},4,null,{"$f":"INDEX(W19:AB19,1,Sondenauslegung!$H$6)","v":11.33},null,-4,13.01,{"v":38.1,"d":"38.10"},51.38,62.57,{"v":99.7,"d":"99.70"}]
[null,"Monopropylenglykol 33%",1040,1.515e-05,8.86e-06,5.58e-06,3.72,-17,null,"2 °C",2,{"$f":"INDEX(M16:R16,1,Sondenauslegung!$H$6)","v":{"v":1.702E-6,"d":"0.000001702"}},null,{"$f":"N$12+(N$17-N$12)/5*4","v":{"v":1.702E-6,"d":"0.000001702"}},{"$f":"O$12+(O$17-O$12)/5*4","v":{"v":3.902e-06,"d":"0.000003902"}},{"$f":"P$12+(P$17-P$12)/5*4","v":{"v":5.122e-06,"d":"0.000005122"}},{"$f":"Q$12+(Q$17-Q$12)/5*4","v":{"v":5.572e-06,"d":"0.000005572"}},{"$f":"R$12+(R$17-R$12)/5*4","v":{"v":8.204e-06,"d":"0.000008204"}},2,null,{"$f":"INDEX(W18:AB18,1,Sondenauslegung!$H$6)","v":12.13},null,-2,13.01,35.08,47.15,56.67,89.53]
[{"$nulls":9},"0 °C",0,{"$f":"INDEX(M17:R17,1,Sondenauslegung!$H$6)","v":{"v":1.8e-06,"d":"0.000001800"}},null,{"$f":"E12","v":{"v":1.8e-06,"d":"0.000001800"}},{"$f":"E13","v":{"v":4.15e-06,"d":"0.000004150"}},{"$f":"E14","v":{"v":5.47e-06,"d":"0.000005470"}},{"$f":"E15","v":{"v":5.98e-06,"d":"0.000005980"}},{"$f":"E16","v":{"v":8.86e-06,"d":"0.000008860"}},0,null,{"$f":"INDEX(W17:AB17,1,Sondenauslegung!$H$6)","v":13.01},null,0,13.01,32.37,43.37,51.47,80.63]
[{"$nulls":9},"-2 °C",-2,{"$f":"INDEX(M18:R18,1,Sondenauslegung!$H$6)","v":{"v":1.8e-06,"d":"0.000001800"}},null,{"$f":"N17+(N22-N17)/5","v":{"v":1.8e-06,"d":"0.000001800"}},{"$f":"O17+(O22-O17)/5","v":{"v":4.574e-06,"d":"0.000004574"}},{"$f":"P17+(P22-P17)/5","v":{"v":6.078e-06,"d":"0.000006078"}},{"$f":"Q17+(Q22-Q17)/5","v":{"v":6.7180000000000007E-6,"d":"0.000006718"}},{"$f":"R17+(R22-R17)/5","v":{"v":1.0118E-5,"d":"0.000010118"}},-2,null,{"$f":"INDEX(W16:AB16,1,Sondenauslegung!$H$6)","v":13.01},null,2,12.13,29.95,39.98,46.87,72.83]
[null,"Sonde",{"$nulls":4},"Wärmeübergang",null,null,"-4 °C",-4,{"$f":"INDEX(M19:R19,1,Sondenauslegung!$H$6)","v":{"v":1.8e-06,"d":"0.000001800"}},null,{"$f":"N17+(N22-N17)/5*2","v":{"v":1.8e-06,"d":"0.000001800"}},{"$f":"O17+(O22-O17)/5*2","v":{"v":4.998e-06,"d":"0.000004998"}},{"$f":"P17+(P22-P17)/5*2","v":{"v":6.686E-6,"d":"0.000006686"}},{"$f":"Q17+(Q22-Q17)/5*2","v":{"v":7.456e-06,"d":"0.000007456"}},{"$f":"R17+(R22-R17)/5*2","v":{"v":1.1376000000000001E-5,"d":"0.000011376"}},-4,null,{"$f":"INDEX(W15:AB15,1,Sondenauslegung!$H$6)","v":13.01},null,4,11.33,27.76,36.95,42.78,65.97]
[null,null,"Aussendurch.","Wandst.","Innendurch.",null,"nach Cerbe-",null,null,"-6 °C",-6,{"$f":"INDEX(M20:R20,1,Sondenauslegung!$H$6)","v":{"v":1.8e-06,"d":"0.000001800"}},null,{"$f":"N17+(N22-N17)/5*3","v":{"v":1.8e-06,"d":"0.000001800"}},{"$f":"O17+(O22-O17)/5*3","v":{"v":5.422e-06,"d":"0.000005422"}},{"$f":"P17+(P22-P17)/5*3","v":{"v":7.294E-6,"d":"0.000007294"}},{"$f":"Q17+(Q22-Q17)/5*3","v":{"v":8.194e-06,"d":"0.000008194"}},{"$f":"R17+(R22-R17)/5*3","v":{"v":1.2634E-5,"d":"0.000012634"}},-6,null,{"$f":"INDEX(W14:AB14,1,Sondenauslegung!$H$6)","v":13.01},null,6,10.61,25.79,34.22,39.15,59.91]
[null,null,"m","m","m",null,"Hoffmann",null,null,"-8 °C",-8,{"$f":"INDEX(M21:R21,1,Sondenauslegung!$H$6)","v":{"v":1.8e-06,"d":"0.000001800"}},null,{"$f":"N17+(N22-N17)/5*4","v":{"v":1.8e-06,"d":"0.000001800"}},{"$f":"O17+(O22-O17)/5*4","v":{"v":5.846e-06,"d":"0.000005846"}},{"$f":"P17+(P22-P17)/5*4","v":{"v":7.902e-06,"d":"0.000007902"}},{"$f":"Q17+(Q22-Q17)/5*4","v":{"v":8.932e-06,"d":"0.000008932"}},{"$f":"R17+(R22-R17)/5*4","v":{"v":1.3892E-5,"d":"0.000013892"}},-8,null,{"$f":"INDEX(W13:AB13,1,Sondenauslegung!$H$6)","v":13.01},null,8,9.94,24,31.76,35.91,54.55]
[{"$nulls":9},"-10 °C",-10,{"$f":"INDEX(M22:R22,1,Sondenauslegung!$H$6)","v":{"v":1.8e-06,"d":"0.000001800"}},null,{"$f":"D12","v":{"v":1.8e-06,"d":"0.000001800"}},{"$f":"D13","v":{"v":6.27e-06,"d":"0.000006270"}},{"$f":"D14","v":{"v":8.51e-06,"d":"0.000008510"}},{"$f":"D15","v":{"v":9.67e-06,"d":"0.000009670"}},{"$f":"D16","v":{"v":1.515e-05,"d":"0.000015150"}},-10,null,{"$f":"INDEX(W12:AB12,1,Sondenauslegung!$H$6)","v":13.01},null,10,9.34,22.39,29.55,33.02,49.8]
["DN 25","25 mm Doppel-U",0.025,2.3E-3,0.0204,null,"Nusselt turb.",{"$f":"IF(H<>\"\",0.012*(re^0.87-280)*prandtl^0.4*(1+(dinnen/2/H)^(2/3)),0)","v":{"v":0,"d":"0.00"}}]
["DN 32","32 mm Doppel-U",0.032,0.003,0.026,null,"Nusselt lam.",{"$f":"IF(H<>\"\",4.36,0)","v":{"v":0,"d":"0.00"}}]
["DN 40","40 mm Doppel-U",0.04,0.0037,0.0326,null,"lambda Fluid",{"$f":"rho*nue*cp/1000/prandtl","v":{"v":0.5974298323036186,"d":"0.60"}}]
[{"$nulls":6},"Alpha",{"$f":"IF(re<2300,H24*H25/dinnen,H23*H25/dinnen)","v":0}]
[]
[null,"Standort",null,null,"Entzugsprofil"]
[null,null,"Faktor",null,null,"Zeit","g(t,H)"]
[null,null,"K",null,null,"s","-"]
[]
[null,"Mittelland 500m",0.8,null,"Schnell              (2 Tage)",172800,{"$f":"IF(H<>\"\",LN(H/(db/100))+0.5*LN(9*F32*lambdaErde/H^2/cpErde/rhoErde),0)","v":0}]
[null,"Voralpen 1000m",1.4,null,"Mittel                   (5 Tage)",432000,{"$f":"IF(H<>\"\",LN(H/(db/100))+0.5*LN(9*F33*lambdaErde/H^2/cpErde/rhoErde),0)","v":0},null,null,"Druckverlust-Berechnung:",{"$nulls":3},"Am Bohrkopf zusammengefasst?",null,2]
[null,"Alpen 1500m",2,null,"Lang                      (20 Tage)",1728000,{"$f":"IF(H<>\"\",LN(H/(db/100))+0.5*LN(9*F34*lambdaErde/H^2/cpErde/rhoErde),0)","v":0},null,null,"Petukhov (empfohlen)",{"$nulls":3},"ja"]
[{"$nulls":9},"Blasius",{"$nulls":3},"nein"]
[]
[null,"Aktuelle Werte:"]
[null,"dinnen",{"$f":"INDEX(E23:E25,Sondenauslegung!D33,1)","v":0.026},"m","externe Druckverluste:"]
[null,"Reynoldszahl Sonde",{"$f":"IF(wSonde<>\"\",IF(Fluid=1,,wSonde*dinnen/nue*1000000),\"\")","v":""},null,"horizontale Sondenzuleitung",null,{"$f":"IF(AND(Sondenauslegung!J22>0,Sondenauslegung!D24<>\"\"),2*Sondenauslegung!J22*ZetaAnschluss*rho*wAnschluss*wAnschluss/2/dAnschluss,0)","v":{"v":0,"d":"0.00"}},"kPa"]
[null,"Prandtl-Zahl",{"$f":"(INDEX(U12:U22,Sondenauslegung!J6,1))","v":11.33},null,"WP-Verdampfer",null,{"$f":"IF(AND(Sondenauslegung!D21>0,Sondenauslegung!D24<>\"\"),Sondenauslegung!D20/(Sondenauslegung!D21/Sondenauslegung!D24)^2,Sondenauslegung!D20)","v":{"v":0,"d":"0.00"}},"kPa"]
[null,"g-funktion",{"$f":"INDEX(G32:G34,Sondenauslegung!D22,1)","v":{"v":0,"d":"0.00000"}},null,"Verteiler",null,{"$f":"IF(AND(Sondenauslegung!J16>0,Sondenauslegung!D24<>\"\"),Sondenauslegung!J15/(Sondenauslegung!J16/Sondenauslegung!D24)^2,Sondenauslegung!J15)","v":{"v":0,"d":"0.00"}},"kPa"]
[null,"a-Wert",{"$f":"IF(dinnen<>\"\",IF(re<2300,H24*H25/dinnen,H23*H25/dinnen),0)","v":0},"W/m2K","Volumenstrommesser",null,{"$f":"IF(AND(Sondenauslegung!J18>0,Sondenauslegung!D24<>\"\"),Sondenauslegung!J17/(Sondenauslegung!J18/Sondenauslegung!D24)^2,Sondenauslegung!J17)","v":{"v":0,"d":"0.00"}},"kPa"]
[null,"\"Ra\"",{"$f":"IF(alpha>0,1/(8*PI()*alpha*(dinnen/2)),0)","v":{"v":0,"d":"0.0000"}},"Km/W","Bögen und Tauchhülsen",null,{"$f":"IF(pd<>\"\",pd*(Sondenauslegung!J24*2+Sondenauslegung!J25*1)/1000,0)","v":{"$error":"#VALUE!"}},"kPa"]
[null,"p_dyn,Sonde",{"$f":"IF(wSonde<>\"\",rho/2*(IF(Fluid=1,,mSonde/3600*4/rho/(dinnen)^2/PI()))^2,\"\")*(3-P33)","v":{"$error":"#VALUE!"}},"Pa","aus eingegebenem z- oder Sz",null,{"$f":"IF(pd<>\"\",pd*(Sondenauslegung!J26)/1000,0)","v":{"$error":"#VALUE!"}},"kPa"]
[null,"R-Wert",{"$f":"IF(wSonde<>\"\",(IF(re>0,G49,0))/dinnen*rho/2*wSonde^2,\"\")","v":""},"Pa/m","Sonstige Elemente",null,{"$f":"IF(AND(Sondenauslegung!J20>0,Sondenauslegung!D24<>\"\"),Sondenauslegung!J19/(Sondenauslegung!J20/Sondenauslegung!D24)^2,Sondenauslegung!J19)","v":{"v":0,"d":"0.00"}},"kPa"]
[null,"\"Rg\"",{"$f":"IF(lambdaErde>0,gfunk/(2*PI()*lambdaErde),0)","v":{"v":0,"d":"0.0000"}},"Km/W","Sondenfuss",null,{"$f":"IF(pd<>\"\",4*pd/1000,0)/(3-P33)","v":{"$error":"#VALUE!"}},"kPa"]
[null,"\"Rm\"",{"$f":"IF(mSonde<>\"\",H/(2*mSonde/3.6*cp),0)","v":{"v":0,"d":"0.0000"}},"Km/W","Total externe Druckverluste:",null,{"$f":"SUM(G39:G46)","v":{"$error":"#VALUE!"}},"kPa"]
[null,"T_Sink (Rücklauf)",{"$f":"IF(qspez<>\"\",Sondenauslegung!D13-(C46+ra+_rc+C47)*qspez,0)","v":{"v":0,"d":"0.00"}},"°C"]
[null,"Entzugsleistung Qerde",{"$f":"IF(COP>0,Qh*(1-1/COP),0)","v":{"v":0,"d":"0.00"}},"W","Druckverlustkoeff. x Sonde",null,{"$f":"IF(re<>\"\",IF(re<2300,64/re,IF(petukhov=1,(0.79*LN(re)-1.64)^(-2),0.3164/(re^(1/4)))),\"\")","v":""}]
[null,"\"Rb\"",{"$f":"0.08+ra","v":{"v":0.08,"d":"0.080"}},"Km/W"]
[null,"mittlere Geschw. in Zuleitung",{"$f":"IF(dAnschluss<>\"\",IF(Fluid=1,,mSonde/3600*4/rho/(dAnschluss/1000)^2/PI()),\"\")*(3-P33)","v":{"$error":"#VALUE!"}},"m/s"]
[null,"Reynoldszahl Zuleitung",{"$f":"IF(dAnschluss<>\"\",IF(Fluid=1,,wAnschluss*dAnschluss/nue*1000),\"\")","v":""}]
[null,"Druckverlustkoeff. x Zuleitg.",{"$f":"IF(dAnschluss>0,IF(ReAnschluss>0,IF(ReAnschluss<2300,64/ReAnschluss,IF(petukhov=1,(0.79*LN(ReAnschluss)-1.64)^(-2),0.3164/(ReAnschluss^(1/4)))),0),0)","v":0}]