{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Diagramm1","Diagramm2","Tabelle1","Tabelle2","Tabelle3","Tabelle4"],"not_rendered":{"charts":4,"images":12,"macros":1,"defined_names":1},"unopened":[{"sheet":"Diagramm1","index":0,"reason":"not_a_worksheet"},{"sheet":"Diagramm2","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":2,"n_rows":114,"n_cols":249,"rows_kept":114,"merged":[[0,1,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[27,2,27,3],[29,2,29,3],[39,0,41,2],[39,3,41,7],[50,1,50,6],[63,2,63,5],[84,0,84,2],[84,5,84,6]]}
["Firma"]
["Anrede",{"$f":"INDEX(Tabelle2!G10:G11,Tabelle2!H10)","v":"Herr"}]
["Name"]
["Email",{"$nulls":5},"V. 2023"]
["Tel./Fax:"]
["Strasse"]
["PLZ/Ort"]
["Bauvorhaben"]
[]
[]
["Allgemeine Angaben"]
[]
["Heizwärmebedarf (Gebäude)",{"$nulls":3},"kW",{"$f":"IF(D13<1,\"Bitte Wärmebedarf eingeben\",\" \")","v":"Bitte Wärmebedarf eingeben"}]
["Wärmepumpenleistungszahl",{"$nulls":4},{"$f":"IF(D14<1,\"Bitte Leistungszahl eingeben\",\" \")","v":"Bitte Leistungszahl eingeben"}]
[{"$nulls":6},"Sonderlänge"]
["Typ VTP",null,null,{"$f":"INDEX(Tabelle2!C72:C73,Tabelle2!D72)","v":"Typ 260"},"Länge",{"$f":"Tabelle2!G70","v":6},10]
["Anordnung",null,null,{"$f":"INDEX(Tabelle2!A77:A78,Tabelle2!B77)","v":"Gruppen"},{"$f":"IF(Tabelle2!$P$10=2,\"Mittelpunktabstand  > 4m\",\" \")","v":" "},"Wenn abweichende Länge, bitte"]
[{"$nulls":5},"Sonderlänge wählen"]
["Einbau im Grundwasser",{"$nulls":23},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben",{"$nulls":7},"Allgemeine Angaben"]
[]
[{"$nulls":4},{"$f":"IF(Tabelle2!B77=1,1,\" \" )","v":" "}]
["Einbau im Grundwasser ",{"$nulls":3},{"$f":"IF(Tabelle2!A79=TRUE,\"VTP müssen vollständig  im Grundwasser stehen\",\" \" )","v":" "}]
["Grundwasser Fließgeschwindigkeit",null,null,{"$f":"INDEX(Tabelle2!C77:C78,Tabelle2!D79)","v":"1 m/d"}]
[{"$nulls":3},"Angabe der Grundwasserfließgeschwindigkeit"]
["Klimazone"]
[]
["Klimazone durch \"click\" in der Karte auswählen"]
["Klimazone",null,"Klimazone laut Karte",null,"Bodenbeschaffenheit"]
[{"$f":"Tabelle2!E3","v":"Rostock-Warnemünde"},null,{"$f":"Tabelle2!D3","v":2},null,{"$f":"Tabelle2!I3","v":"Sand"}]
[null,null,"(nach DIN 4710: 2003-01)"]
[]
["Berechnung",null,"Die Bemessung erfolgt angelehnt an das BDH Infoblatt Nr.:43"]
[]
[]
["erforderliche Entzugsleistung",null,null,{"$f":"ROUND(Tabelle2!D32,0)","v":0},"W"]
["Wärmeleistung VTP gesamt.",null,null,{"$f":"ROUND(B47*Tabelle2!A115,0)","v":0},"W","pro VTP",{"$f":"ROUND(Tabelle2!A115,0)","v":275},"W"]
[{"$nulls":3},{"$f":"IF(Tabelle2!B77=1,Tabelle1!D36/Tabelle1!B47,\" \")","v":" "}]
[]
[]
[{"$f":"IF(Tabelle2!A79=TRUE,\"Anordnung der VTP senkrecht zur      Grundwasserfließrichtung\",\" \")","v":" "},null,null,{"$f":"IF(AND(Tabelle2!B77=1,($D$36/B47)<$D$35),\"Die Berechnung erfolgt mit Werten für ein einzel stehendes VTP. Für die angegebene Leistung sind jedoch mehrere VTP erforderlich. Bitte neu berechnen mit Anordnung Gruppe oder beim Einbau einen Mindestabstand zwischen den VTP von 10 m sicherstellen. \",\" \" )","v":{"$error":"#DIV/0!"}}]
[]
[]
["Ausgabe",null,null," "]
[{"$nulls":13},{"$f":"IF(#REF!>Tabelle2!B56,\"Entzugsleistung zu groß\",\" \")","v":{"$error":"#REF!"}}]
["VTP Typ :",{"$f":"Tabelle2!G78","v":"Typ 260"},null,{"$f":"IF(F16=0,\"Länge gewählt (m) =\",\" \")","v":" "},null,{"$f":"IF(F16=0,G16,\" \")","v":" "},{"$f":"IF(F16=0,\"Sonderlänge\",\" \" )","v":" "},null,{"$f":"IF(Tabelle1!D45>Tabelle2!B56,1,\" \")","v":1}]
[{"$nulls":3},{"$f":"IF(Tabelle2!$P$10=2,\" Mittelpunktabstand > 4m\",\" \")","v":" "}]
["Anzahl VTP:",{"$f":"ROUNDUP((D35/Tabelle2!A115),0)","v":0},"St"]
[]
[]
["Artikel"]
[null,{"$f":"Tabelle2!A130","v":"Vertical Thermpipe PE 100 Typ 260  Länge:6 m, Außendurchmesser d:260mm,  Medienrohr: d 25x2,3"}]
[null,"Art.Nr.:",{"$f":"IF(Tabelle2!B127<1,\" \",Tabelle2!B127)","v":400200256},null,"Nettopreis /St. ",{"$f":"IF(Tabelle2!C127<1,\" \",Tabelle2!C127)","v":779.65},"€"]
[]
[]
["Prinzipskizze"]
[]
[null,null,{"$f":"Tabelle2!M3","v":0.1},null,{"$f":"Tabelle2!E56","v":0.48},{"$f":"IF(F45=\"Entzugsleistung zu groß!!\",\" \",ROUNDUP(G45/100,0))","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF(#REF!=0.1,0,IF(F45=\"Entzugsleistung zu groß!!\",\" \",ROUNDUP(G45/100,0)))","v":{"$error":"#REF!"}},null,{"$f":"IF(#REF!>0.11,\" \",ROUNDUP(#REF!/100,0))","v":{"$error":"#REF!"}},{"$f":"IF(F43>0,F57,C58)","v":{"$error":"#REF!"}}]
[]
[]
[]
[{"$nulls":3},{"$f":"IF(Tabelle2!B77=1,\"Mindestabstand 10 m\",\"Mindestabstand 4 m\")","v":"Mindestabstand 4 m"}]
[]
[null,null,{"$f":"IF(Tabelle2!A79=TRUE,CONCATENATE(\"Grundwasser Fließgeschwindigkeit \",Tabelle2!D77),\" \" )","v":" "}]
{"$rows_empty":8}
[null,null,{"$f":"CONCATENATE(IF(Tabelle2!G70>0,Tabelle2!G70,Tabelle2!F75),\" m\")","v":"6 m"},{"$nulls":3},{"$f":"C73","v":"6 m"}]
[{"$nulls":3},"Benötigte VTP (St.)",null,{"$f":"B47","v":0}]
[]
[{"$nulls":3},"Anordnung:",{"$f":"INDEX(Tabelle2!A77:A78,Tabelle2!B77)","v":"Gruppen"}]
{"$rows_empty":8}
[{"$f":"CONCATENATE(\"d \",Tabelle2!G79)","v":"d 260"},{"$nulls":4},{"$f":"CONCATENATE(\"d \",Tabelle2!G79)","v":"d 260"}]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},1]
{"$rows_empty":21}
[{"$f":"IF(Tabelle1!$J$45=0,Tabelle1!$D$37/Tabelle1!#REF!,\" \" )","v":{"$error":"#VALUE!"}}]

{"sheet":"Tabelle2","index":3,"n_rows":133,"n_cols":15,"rows_kept":133,"hidden":true}
["Klimazonen","Auswahl ","! Diese Tabelle wird für Makros vewendet !",null,null,"Boden  Auswahl für Dropdownfeld",{"$nulls":3},"Auswahl Verlegeabstand manuelle Berechnung",{"$nulls":3},"In diesen Tabellen werden die Werte durch eine Index Funktion ausgewählt"]
["Auswahltabelle für Dropdownfeld",{"$nulls":9},6,null,null,"Die Index Funktion liegt in den Eigenschaften des Dropdownfeldes."]
[1,"Bremerhaven",null,2,{"$f":"INDEX(B3:B17,D3)","v":"Rostock-Warnemünde"},null,"Sand",1,{"$f":"INDEX(G3:G6,H3)","v":"Sand"},50,null,{"$f":"IF(K2=6,0,INDEX(J3:J8,K2))","v":0},{"$f":"IF(L3>1,L3/100,0.1)","v":0.1},"Die Klimazone für die Karte wird in dem Makro Elipse 0-15 im Modul 1 ermittelt"]
[2,"Rostock-Warnemünde",{"$nulls":4},"Lehm",null,null,60]
[3,"Hamburg-Fuhlsbüttel",{"$nulls":4},"Schluff",null,null,70]
[4,"Potsdam",{"$nulls":4},"Sandiger Ton",null,null,80]
[5,"Essen",{"$nulls":7},100]
[6,"Bad Marienberg"]
[7,"Kassel"]
[8,"Braunlage",{"$nulls":4},"Frau",2]
[9,"Chemnitz",{"$nulls":4},"Herr"]
[10,"Hof"]
[11,"Fichtelberg "]
[12,"Mannheim"]
[13,"Passau"]
[14,"Stötten"]
[15,"Garmisch Patenkirchen"]
[]
[]
["Berechnungsbasis"]
[1,"Heizwärmebedarf"]
[2,"Wärmepumpenleistungszahl"]
[3,"Volumenstrom"]
[4,"Entzugleistung Erdreich"]
[]
[]
[null,"Kälteentzugsleistung '=Heizleistung x (Leistungszahl-1) /Leistungszahl"]
[null,"Kollektorfläche'=Kälteentzugleistung in watt /Entzugleistung in Watt/m²"]
[null,"Rohrlänge='Kollektorfläche in m² /Abstand in m",{"$nulls":3},"(max 100m /Kreis)"]
["Berechnung",{"$nulls":4},"Wird im VTP Programm nicht benötigt"]
[null,"Kälteentzugsleistung",{"$nulls":3},"Kolektorfläche",null,"Rohrlänge",null,"Rohrlänge eff.","Kolektorfläche eff"]
["Tabelle1!D13",{"$f":"Tabelle1!D13*1000","v":0},null,{"$f":"IF(B32=0,0,B32*((B33-1)/B33))","v":0},null,{"$f":"D32/B56","v":0},null,{"$f":"F32/E56","v":0},null,{"$f":"Tabelle1!B47*100","v":0},{"$f":"J32*E56","v":0}]
["Tabelle1!D14",{"$f":"Tabelle1!D14","v":0}]
[]
["Wertetabellen Bezug B54-B57 / F54-F57"]
[{"$nulls":3},"Sand ","Lehm","Schluff","Sandiger Ton",{"$nulls":4},"Sand ","Lehm","Schluff","Sandiger Ton"]
[1,"Bremerhaven",null,184,300,324,350,null,1,"Bremerhaven",null,0.34,0.51,0.54,0.51]
[2,"Rostock-Warnemünde",null,158,264,288,316,null,2,"Rostock-Warnemünde",null,0.48,0.58,0.62,0.58]
[3,"Hamburg-Fuhlsbüttel",null,182,300,324,350,null,3,"Hamburg-Fuhlsbüttel",null,0.38,0.53,0.56,0.53]
[4,"Potsdamm",null,170,288,314,348,null,4,"Potsdamm",null,0.44,0.56,0.59,0.57]
[5,"Essen",null,188,306,330,356,null,5,"Essen",null,0.32,0.47,0.52,0.47]
[6,"Bad Marienberg",null,162,272,294,310,null,6,"Bad Marienberg",null,0.76,0.7,0.7,0.68]
[7,"Kassel",null,174,292,316,344,null,7,"Kassel",null,0.4,0.54,0.57,0.54]
[8,"Braunlage",null,152,256,276,290,null,8,"Braunlage",null,1,0.88,0.77,0.84]
[9,"Chemnitz",null,156,266,292,320,null,9,"Chemnitz",null,0.64,0.64,0.67,0.64]
[10,"Hof",null,152,264,290,314,null,10,"Hof",null,1.01,0.84,0.76,0.78]
[11,"Fichtelberg ",null,102,166,210,194,null,11,"Fichtelberg ",null,1,1,1,1]
[12,"Mannheim",null,204,338,366,402,null,12,"Mannheim",null,0.26,0.45,0.48,0.45]
[13,"Passau",null,160,272,298,320,null,13,"Passau",null,0.76,0.7,0.71,0.7]
[14,"Stötten",null,166,284,308,328,null,14,"Stötten",null,0.82,0.7,0.71,0.69]
[15,"Garmisch Patenkirchen",null,170,292,318,338,null,15,"Garmisch Patenkirchen",null,0.88,0.72,0.72,0.71]
[{"$nulls":4},290]
["Berechnung mit Werten aus Klimatabelle und Verlegeabstand"]
[null,{"$f":"MATCH(E3,B3:B17,0)","v":2},"Bezug E3",null,{"$f":"MATCH(E3,B3:B17,0)","v":2},"Bezug E3",null,null,{"$f":"IF(Tabelle1!F43>0,Tabelle2!I56,Tabelle2!J56)","v":0},null,null,{"$f":"(180/2)/5","v":18}]
[null,{"$f":"MATCH(I3,G3:G6,0)","v":1},"Bezug I3",null,{"$f":"MATCH(I3,G3:G6,0)","v":1},"Bezug I3",{"$nulls":5},{"$f":"18*2.6","v":46.800000000000004}]
["Wärmeleistung",{"$f":"INDEX(D37:G51,B54,B55)","v":158},"W/m²","Verlegeabstand",{"$f":"INDEX(L37:O51,E54,E55)","v":0.48},null,null,{"$f":"IF(K2=6,\" \",K2)","v":" "},{"$f":"Tabelle1!F43","v":0}]
["abhängig",{"$nulls":6},{"$f":"IF(K2=6,\" \",K2)","v":" "},{"$nulls":3},{"$f":"2*3.14*(0.5/2)","v":1.57}]
["von Klimazone"]
["und Boden"]
[]
[]
[]
[null,{"$f":"Tabelle1!M13/Tabelle2!B56","v":0}]
[]
["Auswahlfelder"]
["für Dropdownfelder aus Tabelle 1",{"$nulls":3},"auswahl Länge"]
[{"$nulls":4},6]
[{"$nulls":4},9]
[{"$nulls":4},12,null,"Rückmeldung für Sonderlänge anzeigen"]
[{"$nulls":4},0,null,{"$f":"INDEX(E67:E70,F72)","v":6},"Tabelle 1 G16"]
["Auswahl Anrede",null,"Auswahl Typ"]
["Herr",1,"Typ 260",1,"6m",1]
["Frau",null,"Typ 360",null,"9m",null,{"$f":"IF(D73<3,1,0)","v":1}]
[{"$nulls":4},"12m"]
[{"$nulls":4},"Sonderlänge",{"$f":"Tabelle1!G16","v":10}]
["Auswahl Einzel oder Gruppen VTP",null,"Auswahl Grundwasser Geschwindigkeit"]
["Einzel VTP",2,"1 m/d",{"$f":"INDEX(C77:C78,D79)","v":"1 m/d"},{"$f":"IF(E80=1,Makro1_start(),0)","v":{"$error":"#NAME?"}},null,"Für Textauswahl  Bezug zu Zelle A124"]
["Gruppen",null,"5 m/d",null,"Länge",null,{"$f":"INDEX(C72:C73,D72)","v":"Typ 260"}]
[false,null,null,1,{"$f":"IF(F72=1,6,IF(F72=2,9,IF(F72=3,12,F75)))","v":6},null,{"$f":"IF(D72=1,260,360)","v":260},{"$f":"IF(D72=1,\"d 25x2,3\",\"d 32x3,0\")","v":"d 25x2,3"}]
["Auswahl Grundwasser JA/NEIN",null,{"$f":"IF(A79=TRUE,1,0)","v":0},{"$f":"IF(A79=TRUE,0,0)","v":0},{"$f":"IF(B77=2,1)","v":1}]
[{"$nulls":5},{"$f":"IF(AND(A79=TRUE,D79<>1),1,0)","v":0}]
["Berechnung","VTP ohne Grundwasser"]
["Faktoren VTP Typ",{"$nulls":3},"Die Gelben Felder sind änderbar"]
[0.58,"Typ 260",null,null,"Je nach dem welcher Faktor für die Berechnung benötigt wird"]
[0.7,"Typ 360",null,null,"Rote Felder sind Berechnungsfelder nicht andern !3"]
[{"$f":"IF(D72=1,A84,A85)","v":0.58},"Auswahl"]
["Korr,Faktor VTP einzel"]
[1.6,"Einzel VTP"]
[1,"Gruppen VTP"]
[{"$f":"IF(B77=1,A88,A89)","v":1},"Auswahl"]
["Tabellenwert aus B56"]
["Länge VTP"]
[{"$f":"IF(F72=1,6,IF(F72=2,9,IF(F72=3,12,F75)))","v":6}]
["Korr,Faktor "]
[1]
[{"$f":"(B56/2*A93)*(A86*A90*A95)","v":274.91999999999996},"Ergebnis Berechnung ohne Grundwasser",null,null,"Hier endet die Berechnung für VTP ohne Grundwasser"]
["Berechnung VTP im Grundwasser"]
["Korr,Faktoren für Grundwasser"]
[]
[1.1,"1L/D GW1"]
[1,"5L/D GW5"]
[{"$f":"IF(D79=1,A100,A101)","v":1.1},"Auswahl",{"$f":"IF(F79=1,C99,IF(F79=2,C100,C101))","v":0}]
["Festwert für VTP 360/6m bei 5 m/D "]
[2200,"W/VTP"]
["Faktor 2 VTP Typ 360/Typ260"]
[1]
[0.82]
[{"$f":"IF(D72=1,A107,A106)","v":0.82}]
[]
[]
["Ergebnis Berechnung Grundwasser "]
[{"$f":"IF(A102=1.1,(B56/2)*(A93*A86*A95*A102*A90),((A104/6)*(A93*A108*A102)))","v":302.412},{"$nulls":3},"Hier endet die Berechnung für VTP im Grundwasser"]
[]
["Ergebniss Auswahl Kein Grundwasser /Grundwasser"]
[{"$f":"IF(A79=TRUE,A112,A96)","v":274.91999999999996},"Bezug zu Tabelle 1 Zelle D36 und D47",null,null,"Hier wird die Auswahl getroffen ob es sich um ein VTP mit oder ohne Grundwasser handelt"]
[{"$nulls":4},"auswahlkriterium ist der Wert aus Zelle A77"]
[]
[null,"Art Nr. VTP","Preise"]
["260 6",400200256,779.65]
["260 9",400200259,{"v":890.7,"d":"890.70"}]
["260 12",400200257,967.05]
["360 6",400280326,{"v":955.5,"d":"955.50"}]
["360 9",400250329,1186.85]
["360 12",400280327,1314.05]
[]
[{"$f":"IF(AND(D72=1,F72=1),1,IF(AND(D72=1,F72=2),2,(IF(AND(D72=1,F72=3),3,IF(AND(D72=2,F72=1),4,IF(AND(D72=2,F72=2),5,IF(AND(D72=2,F72=3),6,0)))))))","v":1}]
["Hilfszelle für Auswahl",{"$f":"IF(A126>0,INDEX(B119:B124,$A$126),\"Auf Anfrage\")","v":400200256},{"$f":"IF(A126>0,INDEX(C119:C124,$A$126),\"Auf Anfrage\")","v":779.65},null,"hier findet die Auswahl aus ober stehender Liste statt"]
[{"$nulls":4},"Bezug ist Zelle A122"]
["Artikeltext  (verkettung)",null,"Bezug zu Tabelle 1 B50"]
[{"$f":"CONCATENATE(\"Vertical Thermpipe PE 100 \",G78,IF(F72=4,\" Sonder-\",\" \" ),\" Länge:\",E79,\" m, \",\"Außendurchmesser d:\",G79,\"mm, \",\" Medienrohr: \",H79)","v":"Vertical Thermpipe PE 100 Typ 260  Länge:6 m, Außendurchmesser d:260mm,  Medienrohr: d 25x2,3"},{"$nulls":6},"hier wird der Text verknüpft aus Werten"]
[{"$nulls":7},"aus den Zellen F77,G76, H77,G77,G68"]
[]
["df"]

{"sheet":"Tabelle3","index":4,"n_rows":53,"n_cols":7,"rows_kept":53,"hidden":true}
[]
[]
[]
[]
[{"$nulls":5},{"$f":"IF(Tabelle2!B77=1,1,0)","v":0}]
[]
[]
[]
[null,{"$f":"IF(F5=1,Makro1_start(),\"nichts\")","v":"nichts"}]
{"$rows_empty":28}
[{"$nulls":3},"Sand ","Lehm","Schluff","Sandiger Ton"]
[1,"Bremerhaven",null,180,300,320,350]
[2,"Rostock-Warnemünde",null,150,260,280,310]
[3,"Hamburg-Fuhlsbüttel",null,180,300,320,350]
[4,"Potsdamm",null,170,280,310,340]
[5,"Essen",null,180,300,330,350]
[6,"Bad Marienberg",null,160,270,290,310]
[7,"Kassel",null,170,290,310,340]
[8,"Braunlage",null,150,250,270,290]
[9,"Chemnitz",null,150,260,290,320]
[10,"Hof",null,150,260,290,310]
[11,"Fichtelberg ",null,100,160,210,190]
[12,"Mannheim",null,200,330,360,400]
[13,"Passau",null,160,270,290,320]
[14,"Stötten",null,160,280,300,320]
[15,"Garmisch Patenkirchen",null,170,290,310,330]

{"sheet":"Tabelle4","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"merged":[[39,14,115,15]]}