{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Diagramm1","Diagramm2","Tabelle1","Tabelle2","Tabelle3","Tabelle4"],"not_rendered":{"charts":4,"images":9,"macros":1,"defined_names":1,"comments":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":72,"n_cols":14,"rows_kept":72,"merged":[[1,1,1,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],[15,2,15,3],[17,2,17,3],[51,1,51,6],[52,1,52,6],[53,0,56,6]]}
["Anrede",{"$f":"INDEX(Tabelle2!O2:O5,Tabelle2!P2)","v":0}]
["Name"]
["Email"]
["Fax",{"$nulls":5},"       V. 2023"]
["Strasse"]
["PLZ/Ort"]
["Land"]
["Bauvorhaben"]
[]
[]
["Allgemeine Angaben"]
[]
["Heizwärmebedarf (Gebäude)",null,null,0,"kW"]
["Wärmepumpenleistungszahl",null,null,0]
["Klimazone durch \"click\" in der Karte auswählen"]
["Klimazone",null,"Klimazone laut Karte",null,"Bodenbeschaffenheit"]
[{"$f":"Tabelle2!E3","v":"Bremerhaven"},null,{"$f":"Tabelle2!D3","v":1},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":"Tabelle2!D32","v":{"$error":"#DIV/0!"}},"W"]
["Wärmeleistung /Klimazone/Erdreich",null,null,{"$f":"Tabelle2!B56","v":{"v":29,"d":"29.00"}},"W/ m²"]
["Kollektorfläche",null,null,{"$f":"Tabelle2!F32","v":{"$error":"#DIV/0!"}},"m²"]
["Rohrlänge",null,null,{"$f":"Tabelle2!H32","v":{"$error":"#DIV/0!"}},"m","Anzahl Kreise",{"$f":"IF(F35>0,\" \",E59)","v":{"$error":"#DIV/0!"}},"St"]
["Wärmeleistung Kollektorfläche eff.",null,null,{"$f":"IF(D38>0.11,\" \",D23*Tabelle2!K32)","v":{"$error":"#DIV/0!"}},"W","max.Länge /Kreis 100m"]
["Verlegeabstand (mindestens)",null,null,{"$f":"E58","v":0.34},"m"]
["Wärmeleistung /m",null,null,{"$f":"D27*D23","v":{"v":9.860000000000001,"d":"9.86"}},"Watt/m"]
[]
[]
[]
["Bei verändertem Verlegeabstand"]
[]
["geänderter Verlegeabstand (cm)"]
[{"$nulls":3}," "]
[]
[{"$nulls":3},{"$f":"IF(AND(D38>0.1,D40>D23),\"- Bitte Wärmeleistung/m² überprüfen -\",\" \")","v":" "},{"$nulls":9},{"$f":"IF(M19>Tabelle2!B56,\"Entzugsleistung zu groß\",\" \")","v":" "}]
["Verlegeabstand (gewählt)",null,null,{"$f":"C58","v":{"v":0.1,"d":"0.10"}},"m",{"$f":"IF(D38>0.1,\"Abstand selbst gewählt\", \" \")","v":" "}]
["Wärmeleistung ",null,null,{"$f":"D22","v":{"$error":"#DIV/0!"}},"W",{"$f":"IF(AND(D38>0.1,D38<D27),\"Verlegeabstand zu gering\",\" \")","v":" "}]
["Wärmeleistung pro m²",null,null,{"$f":"A72","v":{"v":98.60000000000001,"d":"98.60"}},"W/m²",{"$f":"IF(D40<>A72,\"Wärmeleistung Direkteingabe\",\"Zur Direkteingabe Doppellklick \")","v":"Zur Direkteingabe Doppellklick "},null,null,{"$f":"IF(Tabelle1!D40>Tabelle2!B56,1,\" \")","v":1}]
["Kollektorfläche (benötigt)",null,null,{"$f":"D39/D40","v":{"$error":"#DIV/0!"}},"m²"]
["Rohrlänge",null,null,{"$f":"D41/D38","v":{"$error":"#DIV/0!"}},"m","Anzahl Kreise",{"$f":"F59","v":0},"St"]
[{"$nulls":5},"max.Länge /Kreis 100m"]
[]
[]
[]
[]
[]
["Flächenkollektor Paket Nr.:",null,null,{"$f":"Tabelle2!G69","v":{"$error":"#DIV/0!"}},"Artikel Nr.:",{"$f":"Tabelle2!F76","v":{"$error":"#DIV/0!"}}]
[]
[]
["Inhalt:\nPaket\nListen-\npreis:",{"$f":"Tabelle2!A78","v":{"$error":"#DIV/0!"}}]
[{"$f":"Tabelle2!H76","v":{"$error":"#DIV/0!"}},{"$f":"Tabelle2!A79","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,null,{"$f":"Tabelle2!M3","v":0.1},null,{"$f":"Tabelle2!E56","v":0.34},{"$f":"IF(F40=\"Entzugsleistung zu groß!!\",\" \",ROUNDUP(D42/100,0))","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(D38=0.1,0,IF(F40=\"Entzugsleistung zu groß!!\",\" \",ROUNDUP(D42/100,0)))","v":0},null,{"$f":"IF(D38>0.11,\" \",ROUNDUP(D25/100,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(F35>0,F58,C59)","v":0}]
{"$rows_empty":12}
[{"$f":"IF(Tabelle1!$J$40=0,Tabelle1!$D$28/Tabelle1!$D$38,\"\")","v":{"v":98.60000000000001,"d":"98.60"}}]

{"sheet":"Tabelle2","index":3,"n_rows":79,"n_cols":16,"rows_kept":79,"hidden":true}
["Klimazonen"]
[{"$nulls":10},6,{"$nulls":3},"Herr",3]
[1,"Bremerhaven",null,1,{"$f":"INDEX(B3:B17,D3)","v":"Bremerhaven"},null,"Sand",1,{"$f":"INDEX(G3:G6,H3)","v":"Sand"},50,null,{"$f":"IF(K2=6,0,INDEX(J3:J13,K2))","v":0},{"$f":"IF(L3>1,L3/100,0.1)","v":0.1},null,"Frau"]
[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",{"$nulls":7},120]
[7,"Kassel",{"$nulls":7},140]
[8,"Braunlage",{"$nulls":7},160]
[9,"Chemnitz",{"$nulls":7},180]
[10,"Hof",{"$nulls":7},200]
[11,"Fichtelberg "]
[12,"Mannheim"]
[13,"Passau"]
[14,"Stötten"]
[15,"Garmisch Patenkirchen"]
[]
[]
[]
[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)"]
[]
[null,"Kälteentzugsleistung",{"$nulls":3},"Kolektorfläche",null,"Rohrlänge",null,"Rohrlänge eff.","Kolektorfläche eff"]
["Tabelle1!D5",{"$f":"Tabelle1!D13*1000","v":0},null,{"$f":"B32*((B33-1)/B33)","v":{"$error":"#DIV/0!"}},null,{"$f":"D32/B56","v":{"$error":"#DIV/0!"}},null,{"$f":"F32/E56","v":{"$error":"#DIV/0!"}},null,{"$f":"Tabelle1!G25*100","v":{"$error":"#DIV/0!"}},{"$f":"J32*E56","v":{"$error":"#DIV/0!"}}]
["Tabelle1!D6",{"$f":"Tabelle1!D14","v":0}]
[]
[]
[{"$nulls":3},"Sand ","Lehm","Schluff","Sandiger Ton",{"$nulls":4},"Sand ","Lehm","Schluff","Sandiger Ton"]
[1,"Bremerhaven",null,29,38,39,43,null,1,"Bremerhaven",null,0.34,0.51,0.54,0.51]
[2,"Rostock-Warnemünde",null,22,32,34,37,null,2,"Rostock-Warnemünde",null,0.48,0.58,0.62,0.58]
[3,"Hamburg-Fuhlsbüttel",null,26,36,38,41,null,3,"Hamburg-Fuhlsbüttel",null,0.38,0.53,0.56,0.53]
[4,"Potsdamm",null,23,33,35,38,null,4,"Potsdamm",null,0.44,0.56,0.59,0.57]
[5,"Essen",null,30,40,41,45,null,5,"Essen",null,0.32,0.47,0.52,0.47]
[6,"Bad Marienberg",null,16,28,31,32,null,6,"Bad Marienberg",null,0.76,0.7,0.7,0.68]
[7,"Kassel",null,25,35,37,40,null,7,"Kassel",null,0.4,0.54,0.57,0.54]
[8,"Braunlage",null,13,23,28,26,null,8,"Braunlage",null,1,0.88,0.77,0.84]
[9,"Chemnitz",null,17,29,31,34,null,9,"Chemnitz",null,0.64,0.64,0.67,0.64]
[10,"Hof",null,12,23,28,28,null,10,"Hof",null,1.01,0.84,0.76,0.78]
[11,"Fichtelberg ",null,5,9,12,10,null,11,"Fichtelberg ",null,1,1,1,1]
[12,"Mannheim",null,33,41,43,47,null,12,"Mannheim",null,0.26,0.45,0.48,0.45]
[13,"Passau",null,16,28,30,32,null,13,"Passau",null,0.76,0.7,0.71,0.7]
[14,"Stötten",null,15,27,30,32,null,14,"Stötten",null,0.82,0.7,0.71,0.69]
[15,"Garmisch Patenkirchen",null,14,27,30,31,null,15,"Garmisch Patenkirchen",null,0.88,0.72,0.72,0.71]
[]
[]
[null,{"$f":"MATCH(E3,B3:B17,0)","v":1},null,null,{"$f":"MATCH(E3,B3:B17,0)","v":1},{"$nulls":3},{"$f":"IF(Tabelle1!F35>0,Tabelle2!I56,Tabelle2!J56)","v":0}]
[null,{"$f":"MATCH(I3,G3:G6,0)","v":1},null,null,{"$f":"MATCH(I3,G3:G6,0)","v":1}]
["Wärmeleistung",{"$f":"INDEX(D37:G51,B54,B55)","v":29},"W/m²","Verlegeabstand",{"$f":"INDEX(L37:O51,E54,E55)","v":0.34},null,null,{"$f":"IF(K2=6,\" \",K2)","v":" "},{"$f":"Tabelle1!F35","v":0}]
["abhängig",{"$nulls":6},{"$f":"IF(K2=6,\" \",K2)","v":" "}]
["von Klimazone"]
["und Boden"]
[]
[]
[]
[null,{"$f":"Tabelle1!M13/Tabelle2!B56","v":0}]
[]
[]
[{"$nulls":8},"Kreise (1)","Kreise (2)"]
[{"$nulls":7},{"$f":"Tabelle1!D22/1000","v":{"$error":"#DIV/0!"}},{"$f":"Tabelle1!G25","v":{"$error":"#DIV/0!"}},{"$f":"Tabelle1!G42","v":0}]
["Paket","KW",{"$nulls":5},{"$f":"IF(AND(H67<6.01,H67>1),1,IF(AND(H67>6.01,H67<8.01),2,IF(AND(H67>8.01,H67<10.01),3,IF(AND(H67>10.01,H67<12.01),4,IF(AND(H67>12.01,H67<14.01),5,IF(H67>14.01,6))))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(I67<3.01,I67>1),1,IF(AND(I67>3.01,I67<4.01),2,IF(AND(I67>4.01,I67<5.01),3,IF(AND(I67>5.01,I67<6.01),4,IF(AND(I67>6.01,I67<7.01),5,IF(AND(I67>7.01,I67<8.01),6,A75))))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(J67<3.01,J67>1),1,IF(AND(J67>3.01,J67<4.01),2,IF(AND(J67>4.01,J67<5.01),3,IF(AND(J67>5.01,J67<6.01),4,IF(AND(J67>6.01,J67<7.01),5,IF(AND(J67>7.01,J67<8.01),6,IF(J67>8.01,7,\" \")))))))","v":" "}]
[1,6,{"$f":"J70","v":{"$error":"#DIV/0!"}},3,null,4023285307,{"$f":"IF(C69>6,\" \",C69)","v":{"$error":"#DIV/0!"}},1432.9]
[2,8,null,4,null,4023285407,null,1715.7,null,{"$f":"IF(J67>0,J68,I68)","v":{"$error":"#DIV/0!"}}]
[3,10,null,5,null,4023285507,null,1975.15]
[4,12,null,6,null,4023285607,null,2270.85]
[5,14,null,7,null,4023285707,null,2566.55,null,"Frank Erdwärmekollektor Set"]
[6,16,null,8,null,4023285807,null,2864.55]
[7,"mehrere Pakete werden benötigt",{"$nulls":3},{"$f":"\"\"","v":""},null,"\"auf Anfrage\"",null,"Ringbunden d 32 SDR 11 PE 100- RC, L =100m,"]
[null,{"$f":"INDEX(B69:B75,C69)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C69>6,\" \",INDEX(D69:D75,C69))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"INDEX(F69:F75,C69)","v":{"$error":"#DIV/0!"}},null,{"$f":"INDEX(H69:H75,C69)","v":{"$error":"#DIV/0!"}},null,"x PE 100 Elektroschweißmuffe d 32 SDR 11, PE- Verteilerschacht\nTyp WM ","fach für Wandmontage mit \nvormontierten Kunststoffsoleverteiler","Typ 2065 und\nDurchflussmengenmesser \nAnzeige 4-20 l/min","Kreisanschlüsse mit Schweißstutzen PE 100 d32 mm SDR 11 ","Wärmepumpenanschluss mit Schweißstutzen PE 100 d 40 mm SDR 11","Vorlauf und Rücklaufstamm mit Absperr-/ Regulierventilen und 1/2\" KFE Hahn, aufklappbarer Schachtdeckel aus PE"]
[]
[{"$f":"IF(J70=7,B76,CONCATENATE(J73,\" \",J70,\" \",\"mit \",\n C76,\" \",J75,\" \",C76*2,J76,\" \",\n C76,\"-\", K76,L76,\" \",M76, N76))","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(J70=7,\" \",CONCATENATE(O76))","v":{"$error":"#DIV/0!"}}]

{"sheet":"Tabelle3","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

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