{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Auslegung","Tabelle1","Zusammenstellung","Karte Lage"],"not_rendered":{"charts":0,"images":41,"macros":1,"external_links":0,"defined_names":1,"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":"Auslegung","index":0,"n_rows":237,"n_cols":30,"rows_kept":237,"cut":false,"hidden":false,"merged":[[117,13,117,16],[118,13,121,13],[122,13,123,13],[118,14,119,14],[120,14,120,16],[121,14,121,16],[122,14,122,16],[123,14,123,16]]}
["NIBE Volumenstromberechnung nach DIN 1946-6"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Allgemeine Eingaben"]
[]
["Planungsnummer:","","Auftraggeber:",null,null,null,null,null,null,null,null,null,null,"Hausart","Ausgabe","Index",null,"Gebäudeh.","Ausgabe","Index",null,"Wärmeschutz","Ausgabe ","Index",null,"Inhalt Vorgabe n50","Inhalt Vorgabe n50",null,"Außenluftrate pro Person"]
["Bauvorhaben:",null,null,null,null,null,null,null,null,null,null,null,null,"Einfamilienhaus","Wohnung im Mehrfamilienhaus",1,null,"bis 15 m","bis 15 m",1,null,"hoch","hoch",1,null,null,"0,8"]
["Bearbeiter:",null,null,null,null,null,null,null,null,null,null,null,null,"Wohnung im Mehrfamilienhaus",null,null,null,"16 bis 50 m",null,null,null,"niedrig",null,null,null,0.6,null,null,"Zimmertüren mit obiger und seitlicher Dichtung:"]
["Datum:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"über 50 m",null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Gerät:",null,null,"n50-Wert",null,null,null,null,null,null,null,null,null,"Lage","Ausgabe","Index",null,"Wind","Ausgabe ","Index",null,"Installationsschacht","Ausgabe","Index",null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"offen","normal",2,null,"windschwach","windstark",1,null,"ja","nein",2]
["Anzahl der Bewohner:",4,null,"Kamin:",null,null,null,null,null,null,null,null,null,"normal",null,null,null,"windstark",null,null,null,"nein",null,null,null,"Rohrsystem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"geschützt",null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Kamin",true,null,"Mindestvolumenstrom","Gerät","Ausgabe","Index",null,"Festlegung Zu- oder Abluftgerät",null,"Luftwechsel bei Abluftwärmepumpen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,"",0,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,"F110"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Zimmertüren",true,null,90,"F130"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,90,"F135"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,"F730"]
["Abluft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,"F750"]
["Raum    Bezeichnung","Raum    Verwendung","Raum     Fläche             m²","Raum           Höhe                  m","Raum  Volumen                       m³","Volumenstrom am Ventil                   m³/h","Ventil               Typ","Anzahl Ventile","Anzahl Flexrohre pro Ventil","Überström- öffnung      cm²",null,null,null,null,null,null,75,"F750 + SAM 40"]
[null,null,0,2.5,{"$f":"C23*D23","v":0},{"$f":"ROUND(IF(E23>0,(S40/S55)*O146,0),0)","v":0},{"$f":"Q195","v":""},{"$f":"IF(C23>0,P195,0)","v":0},{"$f":"V195","v":0},{"$f":"IF(E23>0,((3.1*(F23/POWER(1.5,0.5)))-L19),0)","v":0},null,null,null,null,null,null,110,"F370"]
[null,null,0,2.5,0,{"$f":"ROUND(IF(E24>0,(S41/S55)*O146,0),0)","v":0},{"$f":"Q196","v":""},{"$f":"P196","v":0},{"$f":"V196","v":0},{"$f":"IF(E24>0,((3.1*(F24/POWER(1.5,0.5)))-L20),0)","v":0},null,null,null,null,null,null,110,"F470"]
[null,null,0,2.5,0,{"$f":"ROUND(IF(E25>0,(S42/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,null,null,null,90,"FLM"]
[null,null,0,2.5,0,{"$f":"ROUND(IF(E26>0,(S43/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,null,null,null,null,"ERS 10-500"]
[null,null,0,"2,50",0,{"$f":"ROUND(IF(E27>0,(S44/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,null,null,null,null,"ERS 10-400"]
[null,null,0,"2,50",0,{"$f":"ROUND(IF(E28>0,(S45/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,"Berechnung nach der Belegungszahl",null,null,null,"ERS 20-250"]
["",null,0,"2,50",0,{"$f":"ROUND(IF(E29>0,(S46/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,"20 m³/h",null,null,null,"GV-HR 110-250"]
["",null,0,"2,50",0,{"$f":"ROUND(IF(E30>0,(S47/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,"30 m³/h",null,null,null,"GV-HR 110-400"]
["",null,0,"2,50",0,{"$f":"ROUND(IF(E31>0,(S48/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,"30 m³/h"]
["",null,0,"2,50",0,{"$f":"ROUND(IF(E32>0,(S49/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,{"$f":"IF(N31=\"20 m³/h\",20,30)","v":30}]
["",null,0,"2,50",0,{"$f":"ROUND(IF(E33>0,(S50/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,{"$f":"B12*N32","v":120}]
["",null,0,"2,50",0,{"$f":"ROUND(IF(E34>0,(S51/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,null,1]
["",null,0,"2,50",0,{"$f":"ROUND(IF(E35>0,(S52/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,null,1]
["",null,0,"2,50",0,{"$f":"ROUND(IF(E36>0,(S53/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,"Berechnungen Abluft"]
["",null,0,"2,50",0,{"$f":"ROUND(IF(E37>0,(S54/S55)*O146,0),0)","v":0},"",0,0,0,null,null,null,null,1]
[null,null,{"$f":"SUM(C23:C37)","v":0},null,{"$f":"SUM(E23:E37)","v":0},{"$f":"SUM(F23:F37)","v":0},null,null,null,null,null,null,null,"Ausgabe Verwendung","Tabelle 7",null,null,"Abluft gem. Tab. 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Index","Raum","Volumenstrom"]
["Zuluft",null,null,null,null,null,null,null,null,null,null,null,null,"",1,1,null,0,{"$f":"VLOOKUP(O40,P40:R48,3)","v":0}]
["Raum   Bezeichnung","Raum  Verwendung","Aufteilung","Raum         Fläche             m²","Raum       Höhe                  m","Raum        Volumen                       m³","Volumenstrom des Raumes           m³/h","Volumenstr.    am Ventil                        m³/h","Ventilart","Ventil        Typ","Anzahl Ventile","Anzahl Flexrohre pro Ventil","Überström- öffnung       cm²","",1,2,"Küche",40,{"$f":"VLOOKUP(O41,P40:R48,3)","v":0}]
[null,null,null,0,2.5,{"$f":"D42*E42","v":0},{"$f":"IF(F42>0,(Z67/Z82)*Q143,0)","v":0},{"$f":"IF(F42>0,(Z67/Z82)*R143,0)","v":0},null,{"$f":"N176","v":""},{"$f":"Y176","v":0},{"$f":"AD176","v":0},{"$f":"IF(F42>0,((3.1*(G42/POWER(1.5,0.5)))-O19),0)","v":0},"",1,3,"Bad",40,{"$f":"VLOOKUP(O42,P40:R48,3)","v":0}]
[null,null,null,0,2.5,{"$f":"D43*E43","v":0},{"$f":"IF(F43>0,(Z68/Z82)*Q143,0)","v":0},{"$f":"IF(F43>0,(Z68/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F43>0,((3.1*(G43/POWER(1.5,0.5)))-O19),0)","v":0},"",1,4,"Dusche",40,{"$f":"VLOOKUP(O43,P40:R48,3)","v":0}]
[null,null,null,0,2.5,0,{"$f":"IF(F44>0,(Z69/Z82)*Q143,0)","v":0},{"$f":"IF(F44>0,(Z69/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F44>0,((3.1*(G44/POWER(1.5,0.5)))-O19),0)","v":0},"",1,5,"WC",20,{"$f":"VLOOKUP(O44,P40:R48,3)","v":0}]
[null,null,null,0,2.5,0,{"$f":"IF(F45>0,(Z70/Z82)*Q143,0)","v":0},{"$f":"IF(F45>0,(Z70/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F45>0,((3.1*(G45/POWER(1.5,0.5)))-O19),0)","v":0},"",1,6,"Hausarbeitsraum",20,{"$f":"VLOOKUP(O45,P40:R48,3)","v":0}]
[null,null,null,0,2.5,0,{"$f":"IF(F46>0,(Z71/Z82)*Q143,0)","v":0},{"$f":"IF(F46>0,(Z71/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F46>0,((3.1*(G46/POWER(1.5,0.5)))-O19),0)","v":0},"",1,7,"Keller",20,{"$f":"VLOOKUP(O46,P40:R48,3)","v":0}]
[null,null,null,0,2.5,0,{"$f":"IF(F47>0,(Z72/Z82)*Q143,0)","v":0},{"$f":"IF(F47>0,(Z72/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F47>0,((3.1*(G47/POWER(1.5,0.5)))-O19),0)","v":0},"",1,8,"Flur",20,{"$f":"VLOOKUP(O47,P40:R48,3)","v":0}]
[null,null,null,0,2.5,0,{"$f":"IF(F48>0,(Z73/Z82)*Q143,0)","v":0},{"$f":"IF(F48>0,(Z73/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F48>0,((3.1*(G48/POWER(1.5,0.5)))-O19),0)","v":0},"",1,9,"Sauna- bzw. Fittnessr.",40,{"$f":"VLOOKUP(O48,P40:R48,3)","v":0}]
[null,null,null,0,2.5,0,{"$f":"IF(F49>0,(Z74/Z82)*Q143,0)","v":0},{"$f":"IF(F49>0,(Z74/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F49>0,((3.1*(G49/POWER(1.5,0.5)))-O19),0)","v":0},"",1,null,null,null,{"$f":"VLOOKUP(O49,P40:R48,3)","v":0}]
["",null,null,0,2.5,0,{"$f":"IF(F50>0,(Z75/Z82)*Q143,0)","v":0},{"$f":"IF(F50>0,(Z75/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F50>0,((3.1*(G50/POWER(1.5,0.5)))-O19),0)","v":0},"",1,null,null,null,{"$f":"VLOOKUP(O50,P40:R48,3)","v":0}]
["",null,null,0,2.5,0,{"$f":"IF(F51>0,(Z76/Z82)*Q143,0)","v":0},{"$f":"IF(F51>0,(Z76/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F51>0,((3.1*(G51/POWER(1.5,0.5)))-O19),0)","v":0},"",1,null,null,null,{"$f":"VLOOKUP(O51,P40:R48,3)","v":0}]
["",null,null,0,2.5,0,{"$f":"IF(F52>0,(Z77/Z82)*Q143,0)","v":0},{"$f":"IF(F52>0,(Z77/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F52>0,((3.1*(G52/POWER(1.5,0.5)))-O19),0)","v":0},"",1,null,null,null,{"$f":"VLOOKUP(O52,P40:R48,3)","v":0}]
["",null,null,0,2.5,0,{"$f":"IF(F53>0,(Z77/Z82)*Q143,0)","v":0},{"$f":"IF(F53>0,(Z78/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F53>0,((3.1*(G53/POWER(1.5,0.5)))-O19),0)","v":0},"",1,null,null,null,{"$f":"VLOOKUP(O53,P40:R48,3)","v":0}]
["",null,null,0,2.5,0,{"$f":"IF(F54>0,(Z77/Z82)*Q143,0)","v":0},{"$f":"IF(F54>0,(Z79/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F54>0,((3.1*(G54/POWER(1.5,0.5)))-O19),0)","v":0},"",1,null,null,null,{"$f":"VLOOKUP(O54,P40:R48,3)","v":0}]
["",null,null,0,2.5,0,{"$f":"IF(F55>0,(Z77/Z82)*Q143,0)","v":0},{"$f":"IF(F55>0,(Z80/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F55>0,((3.1*(G55/POWER(1.5,0.5)))-O19),0)","v":0},null,null,null,null,null,{"$f":"SUM(S40:S54)","v":0}]
["",null,null,0,2.5,0,{"$f":"IF(F56>0,(Z77/Z82)*Q143,0)","v":0},{"$f":"IF(F56>0,(Z81/Z82)*R143,0)","v":0},null,"",0,0,{"$f":"IF(F56>0,((3.1*(G56/POWER(1.5,0.5)))-O19),0)","v":0}]
[null,null,null,{"$f":"SUM(D42:D56)","v":0},null,{"$f":"SUM(F42:F56)","v":0},{"$f":"SUM(G42:G56)","v":0},{"$f":"SUM(H42:H56)","v":0},null,null,null,null,null,"Feuchteschutz",{"$f":"(O59/O101)*O99","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduz. Lüftung",{"$f":"(O59/O101)*O100","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nennlüftung",{"$f":"S55","v":0}]
["Überströmbereich",null,null,null,null,null,null,null,null,null,null,null,null,"Intensivlüftung",{"$f":"(O59/O101)*O102","v":0}]
["Raum   Bezeichnung","Raum          fläche                    m²","Raum       Höhe                  m","Raum     Volumen                       m³"]
[null,0,2.5,{"$f":"B62*C62","v":0}]
[null,0,2.5,{"$f":"B63*C63","v":0},null,null,null,null,null,null,null,null,null,"Berechnung Zuluft"]
[null,0,"2,50",{"$f":"B64*C64","v":0}]
["","0,00","2,50",{"$f":"B65*C65","v":0},null,null,null,null,null,null,null,null,null,"Ausgabe Verwendung","Tabelle 14",null,null,"Verwendung Ausgabe","Aufteil. Gem. Tab. 14",null,null,"Index","Kor. Auteilung Inhalt","Kor. Aufteilung Ausgabe",null,"Aufteilung"]
["","0,00","2,50",{"$f":"B66*C66","v":0},null,null,null,null,null,null,null,null,null,1,"Index","Raum","Faktor Aufteilung"]
["","0,00","2,50",0,null,null,null,null,null,null,null,null,null,2,1,null,0,"",0,null,null,1,-1,"0",null,{"$f":"IF(S67>0,S67+X67,0)","v":0}]
["","0,00","2,50",0,null,null,null,null,null,null,null,null,null,7,2,"Wohnzimmer",3,"",0,null,null,2,-0.5,"0",null,{"$f":"IF(S68>0,S68+X68,0)","v":0}]
["","0,00","2,50",0,null,null,null,null,null,null,null,null,null,4,3,"Schlafzimmer",2,"",0,null,null,3,0,"0",null,0]
["","0,00","2,50",0,null,null,null,null,null,null,null,null,null,4,4,"Kinderzimmer",2,"",0,null,null,4,0.5,"0",null,0]
["","0,00","2,50",0,null,null,null,null,null,null,null,null,null,6,5,"Esszimmer",1.5,"",0,null,null,5,1,"0",null,0]
[null,{"$f":"SUM(B62:B71)","v":0},null,{"$f":"SUM(D62:D71)","v":0},null,null,null,null,null,null,null,null,null,3,6,"Arbeitszimmer",1.5,"",0,null,null,null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,7,"Gästezimmer",1.5,"",0,null,null,null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,"",0,null,null,null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,"",0,null,null,null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,"",0,null,null,null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,"0",null,0]
[null,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":"SUM(Z67:Z81)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Außenluftvolumenstrom nach Tab. 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Index",1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fläche der Nutzungseinheit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Feuchtsch. Wärmedämmung hoch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Feuchtesch. Wärmedämmung niedrig"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduzierte Lüftung",25,30,45,55,70,80,90,95,105,110,115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nennlüftung",35,45,65,80,100,115,125,140,150,155,165]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Intensivlüftung",45,55,85,105,130,145,165,180,195,205,215]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0-110 m²","130-210 m²"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Zuordnung des Index",{"$f":"IF(V144<=20,1,IF(AND(V144>20,V144<30),2,IF(AND(V144>30,V144<=50),2,IF(AND(V144>50,V144<=70),3,IF(AND(V144>70,V144<=90),4,IF(AND(V144>90,V144<=110),5,0))))))","v":1},{"$f":"IF(AND(V144>110,V144<=130),6,IF(AND(V144>130,V144<=150),7,IF(AND(V144>150,V144<=170),8,IF(AND(V144>170,V144<=190),9,IF(V144>190,10,0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Index",{"$f":"SUM(O95+P95)","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nach Tab. 5 mit Formel errechnet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Feuchteschutz","entfällt bei mechanischer Lüftung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Red. Lüftung ",{"$f":"0.7*((-0.002*V144*V144)+(1.15*V144)+11)","v":7.6999999999999993}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nennlüftung ",{"$f":"IF(V144<211,(-0.002*V144*V144)+(1.15*V144)+11,(((V144-210)/10)*4)+165)","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Intensivlüftung ",{"$f":"1.3*((-0.002*V144*V144)+(1.15*V144)+11)","v":14.3}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ermittlung der größten Wertes",null,"Nennvolumen anhand des 0,5 fachen Luftwechsels"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Feuchteschutz","entfällt bei mechanischer Lüftung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Red.-Lüftung",{"$f":"(O111/O101)*O100","v":83.999999999999986}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nennlüftung",{"$f":"IF(O59>(O101*1.2),O101*1.2,MAX(N33,O59,O101))","v":120},{"$f":"ROUND($V$145*0.5,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Intensivlüftung",{"$f":"(O111/O101)*O102","v":156}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"größter Wert",{"$f":"IF(X16=1,MAX(O111,P111),O111)","v":120}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Berechnung der Infiltration"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab. 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lüftungssystem",null,null,null,"Volumenstromkoeffizient"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventilatorgestützte Lüftung","Abluftsystem","ohne raumluftabhängige Feuerstätte",null,0.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mit raumluftabhängiger Feuerstätte",null,0.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zuluftsystem",null,null,0.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zu-/Abluftsystem",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Entlüftungssystem nach DIN 18017-3","ohne raumluftabhängige Feuerstätte",null,null,0.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mit raumluftabhängiger Feuerstätte",null,null,0.17]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Infiltration Abluft",{"$f":"IF(N16=2,R119*(E38+F57+D72)*AA6,R120*(E38+F57+D72)*AA6)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Infiltration Ventilator",{"$f":"IF(V16=2,P125*V145*N135*((P134*N129)/50)*EXP(2/3),O138)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Infiltration ALD",{"$f":"IF(V16=2,O127,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Infiltration ÜLD",{"$f":"IF(V16=2,P131*V145*N135*((P134*N129)/50)*EXP(2/3),O138)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lüfterstufen am Ventilator",null,null,"ÜLD Nennlüftung","ALD Nennlüftung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(O113-O139,2)","v":120},{"$f":"ROUND(IF(V16=2,O113-O138,O146),2)","v":120}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Feuchteschutz",{"$f":"ROUND((O111/O146)*O109,2)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"bel. Fläche",{"$f":"ROUND((SUM(C23:C37,D42:D56,B62:B66)),2)","v":0},"m²"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Red.-Lüftung",{"$f":"ROUND((O146/O111)*O110,2)","v":84},null,null,null,null,null,"bel. Volumen",{"$f":"SUM(E38,F57,D72)","v":0},"m³"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nennlüftung",{"$f":"ROUND(IF(X16=1,P146,O113-O137),2)","v":120},{"$f":"V144*(AVERAGE(D23:D37,E42:E56,C62:C66))*0.5","v":0},null,null,null,null,"Volumenstrom",{"$f":"IF(X16=2,MAX(N33,O59,O101,P111),MAX(N33,O59,O101))","v":120},"m³/h"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Intensivlüftung",{"$f":"ROUND((O146/O101)*O102,2)","v":156},null,null,null,null,null,"Luftwechsel",{"$f":"ROUND(V146/V145,2)","v":{"$error":"#DIV/0!"}},"1/h"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventilauslegung","Zuluft"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Zuluft"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventilarten bei zentraler Zuluft"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventilart Zu-/Abluft","Ventilart Abluft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Deckenventil","Standard",null,"",null,-1,null,null,null,1,"FRV-K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Wandventil","Standard mit Allergenfilter",null,"",null,-1,null,null,null,2,"FRV-K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bodenauslass","schallgedämmt",null,"",null,-1,null,null,null,3,"FRV-K-DB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"schallgedämmt mit Allergenfilter","Ventilart Ausgabe","",null,-1,null,null,null,4,"FRV-K-DB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zum Aufschrauben auf den Jalousienkasten",null,"",null,-1,null,null,null,5,"FRV-I"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zum Aufschrauben auf den Jalousienkasten mit Allergenfilter","","",null,-1,null,null,null,6,"FRV-I"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Bodenauslass",null,-1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Bodenauslass",null,-1]
[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,null,null,null,null,null,"","",null,-1]
[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,null,null,null,null,null,"","",null,-1]
[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,null,null,null,null,null,"","",null,-1]
[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,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventil Ausgabe","KTS-10","KTS-12","gew. Anzahl","gew. Dimension Deckenv.",null,"Zuluft","Abluft","Pollenfil.","zen. Zuluft","dez. Zuluft","Ausgabe","Flex 63","Oval 100x50","Flex 75","Oval 140x50","Ergebniss"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U176=\"\",T176=\"\"),\"\",IF(AND(V16=2,S158>0),U176,T176))","v":""},{"$f":"ROUNDUP(H42/30.1,0)","v":0},{"$f":"ROUNDUP(H42/50.1,0)","v":0},{"$f":"MIN(O176,P176)","v":0},{"$f":"IF(Q176=0,\"\",IF(O176<=P176,O175,P175))","v":""},null,null,null,{"$f":"IF(OR(S158=2,S158=4,S158=6),1,0)","v":0},{"$f":"IF(AND(V16=1,R158=1),Q176,IF(AND(V16=1,R158=2),ROUNDUP(H42/30,0),IF(AND(V16=1,R158=3),ROUNDUP(H42/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V176=1),ROUNDUP(H42/9,0),IF(AND(V16=2,N16=1,V176=0),ROUNDUP(H42/18,0),IF(AND(V16=2,N16=2,V176=0),ROUNDUP(H42/26,0),IF(AND(V16=2,N16=2,V176=1),ROUNDUP(H42/14,0),0))))","v":0},{"$f":"IF(AND(T176=0,U176=0),0,IF(W176=0,X176,IF(X176=0,W176,0)))","v":0},{"$f":"IF($Y$176=0,0,IF(OR($T$16=6,$T$16=8,$T$16=10,$T$16=11,$T$16=12,$T$16=13,$T$16=14,$T$16=15),IF(AND($H$42=0,$X$176=0),0,ROUNDUP($H$42/(23*$Y$176),0)),0))","v":0},{"$f":"IF($Y$176=0,0,IF(OR($T$16=6,$T$16=8,$T$16=10,$T$16=11,$T$16=12,$T$16=13,$T$16014),IF(AND($H$42=0,$Y$176=0),0,ROUNDUP($H$42/(32*$Y$176),0)),0))","v":0},{"$f":"IF(Y176=0,0,IF(OR($T$16=6,$T$16=8,$T$16=10,$T$16=11,$T$16=12,$T$16=13,$T$16=14,$T$16=15),IF(AND(H42=0,X176=0),0,ROUNDUP(H42/(34*Y176),0)),0))","v":0},{"$f":"IF(Y176=0,0,IF(OR($T$16=6,$T$16=8,$T$16=10,$T$16=11,$T$16=12,$T$16=13,$T$16014),IF(AND(H42=0,Y176=0),0,ROUNDUP(H42/(46*Y176),0)),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U177=\"\",T177=\"\"),\"\",IF(AND(V16=2,S159>0),U177,T177))","v":""},{"$f":"ROUNDUP(H43/30.1,0)","v":0},{"$f":"ROUNDUP(H43/50.1,0)","v":0},{"$f":"MIN(O177,P177)","v":0},{"$f":"IF(Q177=0,\"\",IF(O177<=P177,O175,P175))","v":""},null,null,null,{"$f":"IF(OR(S159=2,S159=4,S159=6),1,0)","v":0},{"$f":"IF(AND(V16=1,R159=1),Q177,IF(AND(V16=1,R159=2),ROUNDUP(H43/30,0),IF(AND(V16=1,R159=3),ROUNDUP(H43/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V177=1),ROUNDUP(H43/9,0),IF(AND(V16=2,N16=1,V177=0),ROUNDUP(H43/18,0),IF(AND(V16=2,N16=2,V177=0),ROUNDUP(H43/26,0),IF(AND(V16=2,N16=2,V177=1),ROUNDUP(H43/14,0),0))))","v":0},{"$f":"IF(AND(T177=0,U177=0),0,IF(W177=0,X177,IF(X177=0,W177,0)))","v":0},{"$f":"IF(Y177=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H43=0,X177=0),0,ROUNDUP(H43/(23*Y177),0)),0))","v":0},{"$f":"IF(Z177=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H43=0,X177=0),0,ROUNDUP(H43/(32*Y177),0)),0))","v":0},{"$f":"IF(Y177=0,0,IF(OR($T$16=6,$T$16=8,$T$16=10,$T$16=11,$T$16=12,$T$16=13,$T$16=14,$T$16=15),IF(AND(H43=0,X177=0),0,ROUNDUP(H43/(34*Y177),0)),0))","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U178=\"\",T178=\"\"),\"\",IF(AND(V16=2,S160>0),U178,T178))","v":""},0,0,0,{"$f":"IF(Q178=0,\"\",IF(O178<=P178,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R160=1),Q178,IF(AND(V16=1,R160=2),ROUNDUP(H44/30,0),IF(AND(V16=1,R160=3),ROUNDUP(H44/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V178=1),ROUNDUP(H44/9,0),IF(AND(V16=2,N16=1,V178=0),ROUNDUP(H44/18,0),IF(AND(V16=2,N16=2,V178=0),ROUNDUP(H44/26,0),IF(AND(V16=2,N16=2,V178=1),ROUNDUP(H44/14,0),0))))","v":0},0,{"$f":"IF(Y178=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H44=0,X178=0),0,ROUNDUP(H44/(23*Y178),0)),0))","v":0},{"$f":"IF(Z178=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H44=0,X178=0),0,ROUNDUP(H44/(32*Y178),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U179=\"\",T179=\"\"),\"\",IF(AND(V16=2,S161>0),U179,T179))","v":""},0,0,0,{"$f":"IF(Q179=0,\"\",IF(O179<=P179,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R161=1),Q179,IF(AND(V16=1,R161=2),ROUNDUP(H45/30,0),IF(AND(V16=1,R161=3),ROUNDUP(H45/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V179=1),ROUNDUP(H45/9,0),IF(AND(V16=2,N16=1,V179=0),ROUNDUP(H45/18,0),IF(AND(V16=2,N16=2,V179=0),ROUNDUP(H45/26,0),IF(AND(V16=2,N16=2,V179=1),ROUNDUP(H45/14,0),0))))","v":0},0,{"$f":"IF(Y179=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H45=0,X179=0),0,ROUNDUP(H45/(23*Y179),0)),0))","v":0},{"$f":"IF(Z179=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H45=0,X179=0),0,ROUNDUP(H45/(32*Y179),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U180=\"\",T180=\"\"),\"\",IF(AND(V16=2,S162>0),U180,T180))","v":""},0,0,0,{"$f":"IF(Q180=0,\"\",IF(O180<=P180,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R162=1),Q180,IF(AND(V16=1,R162=2),ROUNDUP(H46/30,0),IF(AND(V16=1,R162=3),ROUNDUP(H46/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V180=1),ROUNDUP(H46/9,0),IF(AND(V16=2,N16=1,V180=0),ROUNDUP(H46/18,0),IF(AND(V16=2,N16=2,V180=0),ROUNDUP(H46/26,0),IF(AND(V16=2,N16=2,V180=1),ROUNDUP(H46/14,0),0))))","v":0},0,{"$f":"IF(Y180=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H46=0,X180=0),0,ROUNDUP(H46/(23*Y180),0)),0))","v":0},{"$f":"IF(Z180=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H46=0,X180=0),0,ROUNDUP(H46/(32*Y180),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U181=\"\",T181=\"\"),\"\",IF(AND(V16=2,S163>0),U181,T181))","v":""},0,0,0,{"$f":"IF(Q181=0,\"\",IF(O181<=P181,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R163=1),Q181,IF(AND(V16=1,R163=2),ROUNDUP(H47/30,0),IF(AND(V16=1,R163=3),ROUNDUP(H47/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V181=1),ROUNDUP(H47/9,0),IF(AND(V16=2,N16=1,V181=0),ROUNDUP(H47/18,0),IF(AND(V16=2,N16=2,V181=0),ROUNDUP(H47/26,0),IF(AND(V16=2,N16=2,V181=1),ROUNDUP(H47/14,0),0))))","v":0},0,{"$f":"IF(Y181=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H47=0,X181=0),0,ROUNDUP(H47/(23*Y181),0)),0))","v":0},{"$f":"IF(Z181=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H47=0,X181=0),0,ROUNDUP(H47/(32*Y181),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U182=\"\",T182=\"\"),\"\",IF(AND(V16=2,S164>0),U182,T182))","v":""},0,0,0,{"$f":"IF(Q182=0,\"\",IF(O182<=P182,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R164=1),Q182,IF(AND(V16=1,R164=2),ROUNDUP(H48/30,0),IF(AND(V16=1,R164=3),ROUNDUP(H48/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V182=1),ROUNDUP(H48/9,0),IF(AND(V16=2,N16=1,V182=0),ROUNDUP(H48/18,0),IF(AND(V16=2,N16=2,V182=0),ROUNDUP(H48/26,0),IF(AND(V16=2,N16=2,V182=1),ROUNDUP(H48/14,0),0))))","v":0},0,{"$f":"IF(Y182=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H48=0,X182=0),0,ROUNDUP(H48/(23*Y182),0)),0))","v":0},{"$f":"IF(Z182=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H48=0,X182=0),0,ROUNDUP(H48/(32*Y182),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U183=\"\",T183=\"\"),\"\",IF(AND(V16=2,S165>0),U183,T183))","v":""},0,0,0,{"$f":"IF(Q183=0,\"\",IF(O183<=P183,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R165=1),Q183,IF(AND(V16=1,R165=2),ROUNDUP(H49/30,0),IF(AND(V16=1,R165=3),ROUNDUP(H49/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V183=1),ROUNDUP(H49/9,0),IF(AND(V16=2,N16=1,V183=0),ROUNDUP(H49/18,0),IF(AND(V16=2,N16=2,V183=0),ROUNDUP(H49/26,0),IF(AND(V16=2,N16=2,V183=1),ROUNDUP(H49/14,0),0))))","v":0},0,{"$f":"IF(Y183=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H49=0,X183=0),0,ROUNDUP(H49/(23*Y183),0)),0))","v":0},{"$f":"IF(Z183=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H49=0,X183=0),0,ROUNDUP(H49/(32*Y183),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U184=\"\",T184=\"\"),\"\",IF(AND(V16=2,S166>0),U184,T184))","v":""},0,0,0,{"$f":"IF(Q184=0,\"\",IF(O184<=P184,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R166=1),Q184,IF(AND(V16=1,R166=2),ROUNDUP(H50/30,0),IF(AND(V16=1,R166=3),ROUNDUP(H50/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V184=1),ROUNDUP(H50/9,0),IF(AND(V16=2,N16=1,V184=0),ROUNDUP(H50/18,0),IF(AND(V16=2,N16=2,V184=0),ROUNDUP(H50/26,0),IF(AND(V16=2,N16=2,V184=1),ROUNDUP(H50/14,0),0))))","v":0},0,{"$f":"IF(Y184=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H50=0,X184=0),0,ROUNDUP(H50/(23*Y184),0)),0))","v":0},{"$f":"IF(Z184=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H50=0,X184=0),0,ROUNDUP(H50/(32*Y184),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U185=\"\",T185=\"\"),\"\",IF(AND(V16=2,S167>0),U185,T185))","v":""},0,0,0,{"$f":"IF(Q185=0,\"\",IF(O185<=P185,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R167=1),Q185,IF(AND(V16=1,R167=2),ROUNDUP(H51/30,0),IF(AND(V16=1,R167=3),ROUNDUP(H51/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V185=1),ROUNDUP(H51/9,0),IF(AND(V16=2,N16=1,V185=0),ROUNDUP(H51/18,0),IF(AND(V16=2,N16=2,V185=0),ROUNDUP(H51/26,0),IF(AND(V16=2,N16=2,V185=1),ROUNDUP(H51/14,0),0))))","v":0},0,{"$f":"IF(Y185=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H51=0,X185=0),0,ROUNDUP(H51/(23*Y185),0)),0))","v":0},{"$f":"IF(Z185=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H51=0,X185=0),0,ROUNDUP(H51/(32*Y185),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U186=\"\",T186=\"\"),\"\",IF(AND(V16=2,S168>0),U186,T186))","v":""},0,0,0,{"$f":"IF(Q186=0,\"\",IF(O186<=P186,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R168=1),Q186,IF(AND(V16=1,R168=2),ROUNDUP(H52/30,0),IF(AND(V16=1,R168=3),ROUNDUP(H52/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V186=1),ROUNDUP(H52/9,0),IF(AND(V16=2,N16=1,V186=0),ROUNDUP(H52/18,0),IF(AND(V16=2,N16=2,V186=0),ROUNDUP(H52/26,0),IF(AND(V16=2,N16=2,V186=1),ROUNDUP(H52/14,0),0))))","v":0},0,{"$f":"IF(Y186=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H52=0,X186=0),0,ROUNDUP(H52/(23*Y186),0)),0))","v":0},{"$f":"IF(Z186=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H52=0,X186=0),0,ROUNDUP(H52/(32*Y186),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U187=\"\",T187=\"\"),\"\",IF(AND(V16=2,S169>0),U187,T187))","v":""},0,0,0,{"$f":"IF(Q187=0,\"\",IF(O187<=P187,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R169=1),Q187,IF(AND(V16=1,R169=2),ROUNDUP(H53/30,0),IF(AND(V16=1,R169=3),ROUNDUP(H53/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V187=1),ROUNDUP(H53/9,0),IF(AND(V16=2,N16=1,V187=0),ROUNDUP(H53/18,0),IF(AND(V16=2,N16=2,V187=0),ROUNDUP(H53/26,0),IF(AND(V16=2,N16=2,V187=1),ROUNDUP(H53/14,0),0))))","v":0},0,{"$f":"IF(Y187=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H53=0,X187=0),0,ROUNDUP(H53/(23*Y187),0)),0))","v":0},{"$f":"IF(Z187=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H53=0,X187=0),0,ROUNDUP(H53/(32*Y187),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U188=\"\",T188=\"\"),\"\",IF(AND(V16=2,S170>0),U188,T188))","v":""},0,0,0,{"$f":"IF(Q188=0,\"\",IF(O188<=P188,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R170=1),Q188,IF(AND(V16=1,R170=2),ROUNDUP(H54/30,0),IF(AND(V16=1,R170=3),ROUNDUP(H54/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V188=1),ROUNDUP(H54/9,0),IF(AND(V16=2,N16=1,V188=0),ROUNDUP(H54/18,0),IF(AND(V16=2,N16=2,V188=0),ROUNDUP(H54/26,0),IF(AND(V16=2,N16=2,V188=1),ROUNDUP(H54/14,0),0))))","v":0},0,{"$f":"IF(Y188=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H54=0,X188=0),0,ROUNDUP(H54/(23*Y188),0)),0))","v":0},{"$f":"IF(Z188=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H54=0,X188=0),0,ROUNDUP(H54/(32*Y188),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U189=\"\",T189=\"\"),\"\",IF(AND(V16=2,S171>0),U189,T189))","v":""},0,0,0,{"$f":"IF(Q189=0,\"\",IF(O189<=P189,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R171=1),Q189,IF(AND(V16=1,R171=2),ROUNDUP(H55/30,0),IF(AND(V16=1,R171=3),ROUNDUP(H55/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V189=1),ROUNDUP(H55/9,0),IF(AND(V16=2,N16=1,V189=0),ROUNDUP(H55/18,0),IF(AND(V16=2,N16=2,V189=0),ROUNDUP(H55/26,0),IF(AND(V16=2,N16=2,V189=1),ROUNDUP(H55/14,0),0))))","v":0},0,{"$f":"IF(Y189=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H55=0,X189=0),0,ROUNDUP(H55/(23*Y189),0)),0))","v":0},{"$f":"IF(Z189=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H55=0,X189=0),0,ROUNDUP(H55/(32*Y189),0)),0))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U190=\"\",T190=\"\"),\"\",IF(AND(V16=2,S172>0),U190,T190))","v":""},0,0,0,{"$f":"IF(Q190=0,\"\",IF(O190<=P190,O175,P175))","v":""},null,null,null,0,{"$f":"IF(AND(V16=1,R172=1),Q190,IF(AND(V16=1,R172=2),ROUNDUP(H56/30,0),IF(AND(V16=1,R172=3),ROUNDUP(H56/40,0),0)))","v":0},{"$f":"IF(AND(V16=2,N16=1,V190=1),ROUNDUP(H56/9,0),IF(AND(V16=2,N16=1,V190=0),ROUNDUP(H56/18,0),IF(AND(V16=2,N16=2,V190=0),ROUNDUP(H56/26,0),IF(AND(V16=2,N16=2,V190=1),ROUNDUP(H56/14,0),0))))","v":0},0,{"$f":"IF(Y190=0,0,IF(OR(T16=6,T16=8,T16=10,T16=11,T16=12,T16=13,T16=14,T16=15),IF(AND(H56=0,X190=0),0,ROUNDUP(H56/(23*Y190),0)),0))","v":0},{"$f":"IF(Z190=0,0,IF(OR(T16=3,T16=7,T16=8,T16=9,T16=10),IF(AND(H56=0,X190=0),0,ROUNDUP(H56/(32*Y190),0)),0))","v":0},0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Abluft"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"KSO-10","KSO-12","gew. Anzahl",null,"Flex 63","Oval 100x50","Flex 75","Flex 140x50","Ergebniss"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(F23/30.1,0)","v":0},{"$f":"ROUNDUP(F23/50.1,0)","v":0},{"$f":"IF(AND(N195=0,O195=0),0,MIN(N195,O195))","v":0},{"$f":"IF(AND(N195=0,O195=0),\"\",IF(AND(N195=0,O195=0),\"\",IF(N195=O195,\"KSO-10\",IF(N195>O195,\"KSO-12\",IF(N195<O195,\"KSO-10;\"\"\")))))","v":""},{"$f":"IF(AND($N$195=0,$O$195=0),0,ROUNDUP($F$23/($P$195*23),0))","v":0},{"$f":"IF(AND(N195=0,O195=0),0,ROUNDUP(F23/(P195*32),0))","v":0},{"$f":"IF(AND(N195=0,O195=0),0,ROUNDUP(F23/(P195*34),0))","v":0},{"$f":"IF(AND(N195=0,O195=0),0,ROUNDUP(F23/(P195*46),0))","v":0},{"$f":"IF($Z$13=1,R195,IF($Z$13=2,S195,IF($Z$13=3,T195,IF($Z$13=4,U195,0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(F24/30.1,0)","v":0},{"$f":"ROUNDUP(F24/50.1,0)","v":0},{"$f":"IF(AND(N196=0,O196=0),0,MIN(N196,O196))","v":0},{"$f":"IF(AND(N196=0,O196=0),\"\",IF(AND(N196=0,O196=0),\"\",IF(N196=O196,\"KSO-10\",IF(N196>O196,\"KSO-12\",IF(N196<O196,\"KSO-10;\"\"\")))))","v":""},{"$f":"IF(AND(N196=0,O196=0),0,ROUNDUP(F24/(P196*23),0))","v":0},0,{"$f":"IF(AND(N196=0,O196=0),0,ROUNDUP(F24/(P196*34),0))","v":0},0,{"$f":"IF($Z$13=1,R196,IF($Z$13=2,S196,IF($Z$13=3,T196,IF($Z$13=4,U196,0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"",0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Überströmdurchlässe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tür mit Dichtung seitlich und oben","Tür ohne Dichtung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,10,25,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,20,50,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30,75,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,40,100,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,50,125,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,60,150,125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,70,175,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,80,200,175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,90,225,200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,100,250,225]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bemerkungen:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mindestvolumenstr."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(T16=1,T16=2,T16=3,T16=9),(O146<90)),P229,IF(AND(OR(T16=4,T16=5,T16=6),O146<75),P229,IF(AND(OR(T16=7,T16=8),O146<145),P229,IF(AND(T16=7,O146<60),P229,\"\"))))","v":""},null,"Nennvolumenstrom zu gering !"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Außenluft F640",null,"Erhöhten Luftwechsel ggf. in der Heizlast berücksichtigen!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(T16=4,O146>200),P230,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Erhöhter Luftwechsel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V147>0.5,P231,\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Luftwechsel:",{"$f":"O113/(E38+F57+D72)","v":{"$error":"#DIV/0!"}},"1/h"]

{"sheet":"Tabelle1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Zusammenstellung","index":2,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":true,"merged":[[5,1,5,3],[4,1,4,3],[8,1,8,6]]}
[]
[]
[]
[]
["Planungsnummer:",{"$f":"IF(Auslegung!B5=\"\",\"\",Auslegung!B5)","v":""},null,null,"Datum:",{"$f":"IF(Auslegung!B8=\"\",\"\",Auslegung!B8)","v":""},"Kamin:",{"$f":"IF(Auslegung!N16=1,\"ja\",\"nein\")","v":"ja"}]
["Auftraggeber:",{"$f":"IF(Auslegung!D5=\"\",\"\",Auslegung!D5)","v":""},null,null,"Gerät:",{"$f":"IF(Auslegung!S16=\"\",\"\",Auslegung!S16)","v":""}]
["Bauvorhaben:",{"$f":"IF(Auslegung!B6=\"\",\"\",Auslegung!B6)","v":""},null,null,"Wohnfläche:",{"$f":"IF(Auslegung!C38=0,\"\",Auslegung!C38+Auslegung!D57+Auslegung!B72&\" \"&\"m²\")","v":""}]
["Bearbeiter:",{"$f":"IF(Auslegung!B7=\"\",\"\",Auslegung!B7)","v":""},null,null,"Luftwechsel:",{"$f":"IF(Auslegung!O237=0,\"\",(ROUND(Auslegung!O237,2))&\" \"&\"1/h\")","v":{"$error":"#DIV/0!"}}]
["Bemerkung:",{"$f":"Auslegung!N229&\" \"&Auslegung!N232&\" \"&Auslegung!N235","v":{"$error":"#DIV/0!"}}]
[]
[]
["Abluft"]
["Raum                Bezeichnung","Raum            Fläche                              m²","Raum    Luftwechsel               1/h ","Ventil                       Typ","Volumenstrom im Raum        m³/h","Anzahl         Ventile","Anzahl Flexrohre pro Ventil"]
[{"$f":"IF(Auslegung!A23<>0,Auslegung!A23,\"\")","v":""},{"$f":"IF(Auslegung!C23>0,Auslegung!C23,\"\")","v":""},{"$f":"IF(E14=\"\",\"\",(Auslegung!F23/Auslegung!E23))","v":""},{"$f":"IF(Auslegung!F23>0,Auslegung!G23,\"\")","v":""},{"$f":"IF(Auslegung!F23>0,Auslegung!F23,\"\")","v":""},{"$f":"IF(Auslegung!H23>0,Auslegung!H23,\"\")","v":""},{"$f":"IF(Auslegung!I23>0,Auslegung!I23,\"\")","v":""}]
[{"$f":"IF(Auslegung!A24<>0,Auslegung!A24,\"\")","v":""},{"$f":"IF(Auslegung!C24>0,Auslegung!C24,\"\")","v":""},{"$f":"IF(E15=\"\",\"\",(Auslegung!F24/Auslegung!E24))","v":""},{"$f":"IF(Auslegung!F24>0,Auslegung!G24,\"\")","v":""},{"$f":"IF(Auslegung!F24>0,Auslegung!F24,\"\")","v":""},{"$f":"IF(Auslegung!H24>0,Auslegung!H24,\"\")","v":""},{"$f":"IF(Auslegung!I24>0,Auslegung!I24,\"\")","v":""}]
[{"$f":"IF(Auslegung!A25<>0,Auslegung!A25,\"\")","v":""},{"$f":"IF(Auslegung!C25>0,Auslegung!C25,\"\")","v":""},{"$f":"IF(E16=\"\",\"\",(Auslegung!F25/Auslegung!E25))","v":""},{"$f":"IF(Auslegung!F25>0,Auslegung!G25,\"\")","v":""},{"$f":"IF(Auslegung!F25>0,Auslegung!F25,\"\")","v":""},{"$f":"IF(Auslegung!H25>0,Auslegung!H25,\"\")","v":""},{"$f":"IF(Auslegung!I25>0,Auslegung!I25,\"\")","v":""}]
[{"$f":"IF(Auslegung!A26<>0,Auslegung!A26,\"\")","v":""},{"$f":"IF(Auslegung!C26>0,Auslegung!C26,\"\")","v":""},{"$f":"IF(E17=\"\",\"\",(Auslegung!F26/Auslegung!E26))","v":""},{"$f":"IF(Auslegung!F26>0,Auslegung!G26,\"\")","v":""},{"$f":"IF(Auslegung!F26>0,Auslegung!F26,\"\")","v":""},{"$f":"IF(Auslegung!H26>0,Auslegung!H26,\"\")","v":""},{"$f":"IF(Auslegung!I26>0,Auslegung!I26,\"\")","v":""}]
[{"$f":"IF(Auslegung!A27<>0,Auslegung!A27,\"\")","v":""},{"$f":"IF(Auslegung!C27>0,Auslegung!C27,\"\")","v":""},{"$f":"IF(E18=\"\",\"\",(Auslegung!F27/Auslegung!E27))","v":""},{"$f":"IF(Auslegung!F27>0,Auslegung!G27,\"\")","v":""},{"$f":"IF(Auslegung!F27>0,Auslegung!F27,\"\")","v":""},{"$f":"IF(Auslegung!H27>0,Auslegung!H27,\"\")","v":""},{"$f":"IF(Auslegung!I27>0,Auslegung!I27,\"\")","v":""}]
[{"$f":"IF(Auslegung!A28<>0,Auslegung!A28,\"\")","v":""},{"$f":"IF(Auslegung!C28>0,Auslegung!C28,\"\")","v":""},{"$f":"IF(E19=\"\",\"\",(Auslegung!F28/Auslegung!E28))","v":""},{"$f":"IF(Auslegung!F28>0,Auslegung!G28,\"\")","v":""},{"$f":"IF(Auslegung!F28>0,Auslegung!F28,\"\")","v":""},{"$f":"IF(Auslegung!H28>0,Auslegung!H28,\"\")","v":""},{"$f":"IF(Auslegung!I28>0,Auslegung!I28,\"\")","v":""}]
[{"$f":"IF(Auslegung!A29<>0,Auslegung!A29,\"\")","v":""},{"$f":"IF(Auslegung!C29>0,Auslegung!C29,\"\")","v":""},{"$f":"IF(E20=\"\",\"\",(Auslegung!F29/Auslegung!E29))","v":""},{"$f":"IF(Auslegung!F29>0,Auslegung!G29,\"\")","v":""},{"$f":"IF(Auslegung!F29>0,Auslegung!F29,\"\")","v":""},{"$f":"IF(Auslegung!H29>0,Auslegung!H29,\"\")","v":""},{"$f":"IF(Auslegung!I29>0,Auslegung!I29,\"\")","v":""}]
[{"$f":"IF(Auslegung!A30<>0,Auslegung!A30,\"\")","v":""},{"$f":"IF(Auslegung!C30>0,Auslegung!C30,\"\")","v":""},{"$f":"IF(E21=\"\",\"\",(Auslegung!F30/Auslegung!E30))","v":""},{"$f":"IF(Auslegung!F30>0,Auslegung!G30,\"\")","v":""},{"$f":"IF(Auslegung!F30>0,Auslegung!F30,\"\")","v":""},{"$f":"IF(Auslegung!H30>0,Auslegung!H30,\"\")","v":""},{"$f":"IF(Auslegung!I30>0,Auslegung!I30,\"\")","v":""}]
[{"$f":"IF(Auslegung!A31<>0,Auslegung!A31,\"\")","v":""},{"$f":"IF(Auslegung!C31>0,Auslegung!C31,\"\")","v":""},{"$f":"IF(E22=\"\",\"\",(Auslegung!F31/Auslegung!E31))","v":""},{"$f":"IF(Auslegung!F31>0,Auslegung!G31,\"\")","v":""},{"$f":"IF(Auslegung!F31>0,Auslegung!F31,\"\")","v":""},{"$f":"IF(Auslegung!H31>0,Auslegung!H31,\"\")","v":""},{"$f":"IF(Auslegung!I31>0,Auslegung!I31,\"\")","v":""}]
[{"$f":"IF(Auslegung!A32<>0,Auslegung!A32,\"\")","v":""},{"$f":"IF(Auslegung!C32>0,Auslegung!C32,\"\")","v":""},{"$f":"IF(E23=\"\",\"\",(Auslegung!F32/Auslegung!E32))","v":""},{"$f":"IF(Auslegung!F32>0,Auslegung!G32,\"\")","v":""},{"$f":"IF(Auslegung!F32>0,Auslegung!F32,\"\")","v":""},{"$f":"IF(Auslegung!H32>0,Auslegung!H32,\"\")","v":""},{"$f":"IF(Auslegung!I32>0,Auslegung!I32,\"\")","v":""}]
[{"$f":"IF(Auslegung!A33<>0,Auslegung!A33,\"\")","v":""},{"$f":"IF(Auslegung!C33>0,Auslegung!C33,\"\")","v":""},{"$f":"IF(E24=\"\",\"\",(Auslegung!F33/Auslegung!E33))","v":""},{"$f":"IF(Auslegung!F33>0,Auslegung!G33,\"\")","v":""},{"$f":"IF(Auslegung!F33>0,Auslegung!F33,\"\")","v":""},{"$f":"IF(Auslegung!H33>0,Auslegung!H33,\"\")","v":""},{"$f":"IF(Auslegung!I33>0,Auslegung!I33,\"\")","v":""}]
[{"$f":"IF(Auslegung!A34<>0,Auslegung!A34,\"\")","v":""},{"$f":"IF(Auslegung!C34>0,Auslegung!C34,\"\")","v":""},{"$f":"IF(E25=\"\",\"\",(Auslegung!F34/Auslegung!E34))","v":""},{"$f":"IF(Auslegung!F34>0,Auslegung!G34,\"\")","v":""},{"$f":"IF(Auslegung!F34>0,Auslegung!F34,\"\")","v":""},{"$f":"IF(Auslegung!H34>0,Auslegung!H34,\"\")","v":""},{"$f":"IF(Auslegung!I34>0,Auslegung!I34,\"\")","v":""}]
[{"$f":"IF(Auslegung!A35<>0,Auslegung!A35,\"\")","v":""},{"$f":"IF(Auslegung!C35>0,Auslegung!C35,\"\")","v":""},{"$f":"IF(E26=\"\",\"\",(Auslegung!F35/Auslegung!E35))","v":""},{"$f":"IF(Auslegung!F35>0,Auslegung!G35,\"\")","v":""},{"$f":"IF(Auslegung!F35>0,Auslegung!F35,\"\")","v":""},{"$f":"IF(Auslegung!H35>0,Auslegung!H35,\"\")","v":""},{"$f":"IF(Auslegung!I35>0,Auslegung!I35,\"\")","v":""}]
[{"$f":"IF(Auslegung!A36<>0,Auslegung!A36,\"\")","v":""},{"$f":"IF(Auslegung!C36>0,Auslegung!C36,\"\")","v":""},{"$f":"IF(E27=\"\",\"\",(Auslegung!F36/Auslegung!E36))","v":""},{"$f":"IF(Auslegung!F36>0,Auslegung!G36,\"\")","v":""},{"$f":"IF(Auslegung!F36>0,Auslegung!F36,\"\")","v":""},{"$f":"IF(Auslegung!H36>0,Auslegung!H36,\"\")","v":""},{"$f":"IF(Auslegung!I36>0,Auslegung!I36,\"\")","v":""}]
[{"$f":"IF(Auslegung!A37<>0,Auslegung!A37,\"\")","v":""},{"$f":"IF(Auslegung!C37>0,Auslegung!C37,\"\")","v":""},{"$f":"IF(E28=\"\",\"\",(Auslegung!F37/Auslegung!E37))","v":""},{"$f":"IF(Auslegung!F37>0,Auslegung!G37,\"\")","v":""},{"$f":"IF(Auslegung!F37>0,Auslegung!F37,\"\")","v":""},{"$f":"IF(Auslegung!H37>0,Auslegung!H37,\"\")","v":""},{"$f":"IF(Auslegung!I37>0,Auslegung!I37,\"\")","v":""}]
[]
["Überströmbereich"]
["Raum            Bezeichnung","Raum             Fläche               m²"]
[{"$f":"IF(Auslegung!A62<>\"\",Auslegung!A62,\"\")","v":""},{"$f":"IF(Auslegung!A62=\"\",\"\",Auslegung!B62)","v":""}]
[{"$f":"IF(Auslegung!A63<>\"\",Auslegung!A63,\"\")","v":""},{"$f":"IF(Auslegung!A63=\"\",\"\",Auslegung!B63)","v":""}]
[{"$f":"IF(Auslegung!A64<>\"\",Auslegung!A64,\"\")","v":""},{"$f":"IF(Auslegung!A64=\"\",\"\",Auslegung!B64)","v":""}]
[{"$f":"IF(Auslegung!A65<>\"\",Auslegung!A65,\"\")","v":""},{"$f":"IF(Auslegung!A65=\"\",\"\",Auslegung!B65)","v":""}]
[{"$f":"IF(Auslegung!A66<>\"\",Auslegung!A66,\"\")","v":""},{"$f":"IF(Auslegung!A66=\"\",\"\",Auslegung!B66)","v":""}]
[]
["Zuluft"]
["Raum               Bezeichnung","Raum             Fläche                       m²","Raum   Luftwechsel           1/h ","Ventil                        Typ","Gesamtvolumen-strom an den Ventilen\nm³/h","Anzahl             Ventile","Anzahl Flexrohre pro Ventil"]
[{"$f":"IF(Auslegung!A42<>0,Auslegung!A42,\"\")","v":""},{"$f":"IF(Auslegung!D42>0,Auslegung!D42,\"\")","v":""},{"$f":"IF(E40=\"\",\"\",(Auslegung!G42/Auslegung!F42))","v":""},{"$f":"IF(Auslegung!H42>0,Auslegung!J42,\"\")","v":""},{"$f":"IF(Auslegung!H42>0,Auslegung!H42,\"\")","v":""},{"$f":"IF(Auslegung!H42>0,Auslegung!K42,\"\")","v":""},{"$f":"IF(Auslegung!H42>0,Auslegung!L42,\"\")","v":""}]
[{"$f":"IF(Auslegung!A43<>0,Auslegung!A43,\"\")","v":""},{"$f":"IF(Auslegung!D43>0,Auslegung!D43,\"\")","v":""},{"$f":"IF(E41=\"\",\"\",(Auslegung!G43/Auslegung!F43))","v":""},{"$f":"IF(Auslegung!H43>0,Auslegung!J43,\"\")","v":""},{"$f":"IF(Auslegung!H43>0,Auslegung!H43,\"\")","v":""},{"$f":"IF(Auslegung!H43>0,Auslegung!K43,\"\")","v":""},{"$f":"IF(Auslegung!H43>0,Auslegung!L43,\"\")","v":""}]
[{"$f":"IF(Auslegung!A44<>0,Auslegung!A44,\"\")","v":""},{"$f":"IF(Auslegung!D44>0,Auslegung!D44,\"\")","v":""},{"$f":"IF(E42=\"\",\"\",(Auslegung!G44/Auslegung!F44))","v":""},{"$f":"IF(Auslegung!H44>0,Auslegung!J44,\"\")","v":""},{"$f":"IF(Auslegung!H44>0,Auslegung!H44,\"\")","v":""},{"$f":"IF(Auslegung!H44>0,Auslegung!K44,\"\")","v":""},{"$f":"IF(Auslegung!H44>0,Auslegung!L44,\"\")","v":""}]
[{"$f":"IF(Auslegung!A45<>0,Auslegung!A45,\"\")","v":""},{"$f":"IF(Auslegung!D45>0,Auslegung!D45,\"\")","v":""},{"$f":"IF(E43=\"\",\"\",(Auslegung!G45/Auslegung!F45))","v":""},{"$f":"IF(Auslegung!H45>0,Auslegung!J45,\"\")","v":""},{"$f":"IF(Auslegung!H45>0,Auslegung!H45,\"\")","v":""},{"$f":"IF(Auslegung!H45>0,Auslegung!K45,\"\")","v":""},{"$f":"IF(Auslegung!H45>0,Auslegung!L45,\"\")","v":""}]
[{"$f":"IF(Auslegung!A46<>0,Auslegung!A46,\"\")","v":""},{"$f":"IF(Auslegung!D46>0,Auslegung!D46,\"\")","v":""},{"$f":"IF(E44=\"\",\"\",(Auslegung!G46/Auslegung!F46))","v":""},{"$f":"IF(Auslegung!H46>0,Auslegung!J46,\"\")","v":""},{"$f":"IF(Auslegung!H46>0,Auslegung!H46,\"\")","v":""},{"$f":"IF(Auslegung!H46>0,Auslegung!K46,\"\")","v":""},{"$f":"IF(Auslegung!H46>0,Auslegung!L46,\"\")","v":""}]
[{"$f":"IF(Auslegung!A47<>0,Auslegung!A47,\"\")","v":""},{"$f":"IF(Auslegung!D47>0,Auslegung!D47,\"\")","v":""},{"$f":"IF(E45=\"\",\"\",(Auslegung!G47/Auslegung!F47))","v":""},{"$f":"IF(Auslegung!H47>0,Auslegung!J47,\"\")","v":""},{"$f":"IF(Auslegung!H47>0,Auslegung!H47,\"\")","v":""},{"$f":"IF(Auslegung!H47>0,Auslegung!K47,\"\")","v":""},{"$f":"IF(Auslegung!H47>0,Auslegung!L47,\"\")","v":""}]
[{"$f":"IF(Auslegung!A48<>0,Auslegung!A48,\"\")","v":""},{"$f":"IF(Auslegung!D48>0,Auslegung!D48,\"\")","v":""},{"$f":"IF(E46=\"\",\"\",(Auslegung!G48/Auslegung!F48))","v":""},{"$f":"IF(Auslegung!H48>0,Auslegung!J48,\"\")","v":""},{"$f":"IF(Auslegung!H48>0,Auslegung!H48,\"\")","v":""},{"$f":"IF(Auslegung!H48>0,Auslegung!K48,\"\")","v":""},{"$f":"IF(Auslegung!H48>0,Auslegung!L48,\"\")","v":""}]
[{"$f":"IF(Auslegung!A49<>0,Auslegung!A49,\"\")","v":""},{"$f":"IF(Auslegung!D49>0,Auslegung!D49,\"\")","v":""},{"$f":"IF(E47=\"\",\"\",(Auslegung!G49/Auslegung!F49))","v":""},{"$f":"IF(Auslegung!H49>0,Auslegung!J49,\"\")","v":""},{"$f":"IF(Auslegung!H49>0,Auslegung!H49,\"\")","v":""},{"$f":"IF(Auslegung!H49>0,Auslegung!K49,\"\")","v":""},{"$f":"IF(Auslegung!H49>0,Auslegung!L49,\"\")","v":""}]
[{"$f":"IF(Auslegung!A50<>0,Auslegung!A50,\"\")","v":""},{"$f":"IF(Auslegung!D50>0,Auslegung!D50,\"\")","v":""},{"$f":"IF(E48=\"\",\"\",(Auslegung!G50/Auslegung!F50))","v":""},{"$f":"IF(Auslegung!H50>0,Auslegung!J50,\"\")","v":""},{"$f":"IF(Auslegung!H50>0,Auslegung!H50,\"\")","v":""},{"$f":"IF(Auslegung!H50>0,Auslegung!K50,\"\")","v":""},{"$f":"IF(Auslegung!H50>0,Auslegung!L50,\"\")","v":""}]
[{"$f":"IF(Auslegung!A51<>0,Auslegung!A51,\"\")","v":""},{"$f":"IF(Auslegung!D51>0,Auslegung!D51,\"\")","v":""},{"$f":"IF(E49=\"\",\"\",(Auslegung!G51/Auslegung!F51))","v":""},{"$f":"IF(Auslegung!H51>0,Auslegung!J51,\"\")","v":""},{"$f":"IF(Auslegung!H51>0,Auslegung!H51,\"\")","v":""},{"$f":"IF(Auslegung!H51>0,Auslegung!K51,\"\")","v":""},{"$f":"IF(Auslegung!H51>0,Auslegung!L51,\"\")","v":""}]
[{"$f":"IF(Auslegung!A52<>0,Auslegung!A52,\"\")","v":""},{"$f":"IF(Auslegung!D52>0,Auslegung!D52,\"\")","v":""},{"$f":"IF(E50=\"\",\"\",(Auslegung!G52/Auslegung!F52))","v":""},{"$f":"IF(Auslegung!H52>0,Auslegung!J52,\"\")","v":""},{"$f":"IF(Auslegung!H52>0,Auslegung!H52,\"\")","v":""},{"$f":"IF(Auslegung!H52>0,Auslegung!K52,\"\")","v":""},{"$f":"IF(Auslegung!H52>0,Auslegung!L52,\"\")","v":""}]
[{"$f":"IF(Auslegung!A53<>0,Auslegung!A53,\"\")","v":""},{"$f":"IF(Auslegung!D53>0,Auslegung!D53,\"\")","v":""},{"$f":"IF(E51=\"\",\"\",(Auslegung!G53/Auslegung!F53))","v":""},{"$f":"IF(Auslegung!H53>0,Auslegung!J53,\"\")","v":""},{"$f":"IF(Auslegung!H53>0,Auslegung!H53,\"\")","v":""},{"$f":"IF(Auslegung!H53>0,Auslegung!K53,\"\")","v":""},{"$f":"IF(Auslegung!H53>0,Auslegung!L53,\"\")","v":""}]
[{"$f":"IF(Auslegung!A54<>0,Auslegung!A54,\"\")","v":""},{"$f":"IF(Auslegung!D54>0,Auslegung!D54,\"\")","v":""},{"$f":"IF(E52=\"\",\"\",(Auslegung!G54/Auslegung!F54))","v":""},{"$f":"IF(Auslegung!H54>0,Auslegung!J54,\"\")","v":""},{"$f":"IF(Auslegung!H54>0,Auslegung!H54,\"\")","v":""},{"$f":"IF(Auslegung!H54>0,Auslegung!K54,\"\")","v":""},{"$f":"IF(Auslegung!H54>0,Auslegung!L54,\"\")","v":""}]
[{"$f":"IF(Auslegung!A55<>0,Auslegung!A55,\"\")","v":""},{"$f":"IF(Auslegung!D55>0,Auslegung!D55,\"\")","v":""},{"$f":"IF(E53=\"\",\"\",(Auslegung!G55/Auslegung!F55))","v":""},{"$f":"IF(Auslegung!H55>0,Auslegung!J55,\"\")","v":""},{"$f":"IF(Auslegung!H55>0,Auslegung!H55,\"\")","v":""},{"$f":"IF(Auslegung!H55>0,Auslegung!K55,\"\")","v":""},{"$f":"IF(Auslegung!H55>0,Auslegung!L55,\"\")","v":""}]
[{"$f":"IF(Auslegung!A56<>0,Auslegung!A56,\"\")","v":""},{"$f":"IF(Auslegung!D56>0,Auslegung!D56,\"\")","v":""},{"$f":"IF(E54=\"\",\"\",(Auslegung!G56/Auslegung!F56))","v":""},{"$f":"IF(Auslegung!H56>0,Auslegung!J56,\"\")","v":""},{"$f":"IF(Auslegung!H56>0,Auslegung!H56,\"\")","v":""},{"$f":"IF(Auslegung!H56>0,Auslegung!K56,\"\")","v":""},{"$f":"IF(Auslegung!H56>0,Auslegung!L56,\"\")","v":""}]
[]
[]
[]
[]
["Lüfterstufen"]
["Reduzierte Lüftung:",{"$f":"Auslegung!O145","v":84},null,"m³/h"]
["Nennlüftung:",{"$f":"Auslegung!O113","v":120},null,"m³/h"]
["Intensivlüftung:",{"$f":"Auslegung!O147","v":156},null,"m³/h"]

{"sheet":"Karte Lage","index":3,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[null,"Windstarke Landkreise"]
[null,"alle nicht genannten Landkreise gelten als windschwach"]
[null,"Landkreis","Sitz","Landkreis","Sitz","Landkreis","Sitz","Landkreis","Sitz"]
[null,"Aachen","Aachen","Friesland","Jever","Miesbach","Miesbach","Salzgitter; Stadt","Salzgitter"]
[null,"Aachen; Stadt","Aachen","Fulda","Fulda","Minden-Lübbecke","Minden","Salzlandkreis","Bernburg (Saale)"]
[null,"Ahrweiler","Bad Neuenahr-Ahrweiler","Garmisch-Partenkirchen","Garmisch-Partenkirchen","Mittlerer Erzgebirgskreis","Marienburg","Schaumburg","Stadthagen"]
[null,"Alb-Donau-Kreis","Ulm","Gidhorn","Gifhorn","Mittweida","Mittweida","Schleswig-Flensburg","Schleswig"]
[null,"Altmarkkreis Salzwedel","Salzwedel","Görlitz; Stadt","Görlitz","Mönchengladbach; Stadt","Mönchengladbach","Schmalkalden-Meiningen","Meiningen"]
[null,"Alzey-Worms","Alzey","Goslar","Goslar","Münster; Stadt","Münster","Schwalm-Eder-Kreis","Hornberg (Efze)"]
[null,"Ammerland","Westerstede","Gotha","Gotha","Müritz","Waren (Müritz)","Schwerin","Schwerin"]
[null,"Annaberg","Annaberg-Buchholz","Grafschaft Bentheim","Nordhorn","Neubrandenburg","Neubrandenburg","Segeberg","Bad Segeberg"]
[null,"Aue-Schwarzenberg","Aue","Greifswald","Greifswald","Neumünster; Stadt","Neumünster","Siegen-Wittgenstein","Siegen"]
[null,"Aurich","Aurich","Güstrow","Güstrow","Nienburg (Weser)","Nienburg/Weser","Soest","Soest"]
[null,"Bad Doberan","Bad Doberan","Gütersloh","Gütersloh","Nordfriesland","Husum","Soltau-Fallingbostel","Fallingbostel"]
[null,"Bad Kreuznach","Bad Kreuznach","Hamburg; Freie und Hansestadt","Hamburg","Nordvorpommern","Grimmen","Sonneberg","Sonneberg"]
[null,"Barnim ","Eberswalde","Hameln-Pyrmont","Hameln","Nordwestmecklenburg","Grevesmühlen","St. Wendel","St. Wendel; Kreisstadt"]
[null,"Bautzen","Bautzen","Hamm; Stadt","Hamm","Oberallgäu","Sonthofen","Stade","Stade"]
[null,"Berchtesgadener Land","Bad Reichenhall","Harburg","Winsen/Luhe","Oberbergischer Kreis","Gummersbach","Steinberg","Itzehoe"]
[null,"Bernkastel-Wittlich","Wittlich","Harz","Halberstadt","Oberhavel","Oranienburg","Steinfurt","Steinfurt"]
[null,"Bielefeld; Stadt","Bielefeld","Havelland","Rathenow","Oldenburg","Wildeshausen","Stendal","Stendal"]
[null,"Birkenfeld","Birkenfeld","Heinsberg","Heinsberg","Oldenburg (Oldenburg); Stadt","Oldenburg/Oldenburg","Stollberg","Stollberg"]
[null,"Börde","Haldensleben","Helmstedt","Helmstedt","Olpe","Olpe","Stormarn","Bad Oldesloe"]
[null,"Borken","Borken","Herfod","Herford","Osnabrück","Osnabrück","Stralsund","Stralsund"]
[null,"Bttrop; Stadt","Bottrop","Herzogtum Lauenburg","Ratzeburg","Osnabrück; Stadt","Osnabrück","Tirschenreuth","Tirschenreuth"]
[null,"Breisgau-Hochschwarzwald","Freiburg im Breisgau","Hildesheim","Hildesheim","Ostallgäu","Marktoberdorf","Trier-Saarburg","Trier"]
[null,"Bremen; Stadt","Bremen","Hochsauerlandkreis","Mschede","Osterholz","Osterholz-Scharmbeck","Uckermark","Prenzlau"]
[null,"Bremerhaven; Stadt","Bremerhaven","Hof","Hof","Ostholstein","Eutin","Uecker-Randow","Passewalk"]
[null,"Cloppenburg","Cloppenburg","Hof; Stadt","Hof","Ostprignitz-Rupplin","Neuruppln","Uelzen","Uelzen"]
[null,"Cohem-Zell","Cochem","Höxter","Höxter","Ostvorpommern","Anklam","Unna","Unna"]
[null,"Cosesfeld","Cosesfeld","Ilm-Kreis","Arnstadt","Paderborn","Paderborn","Unstrut-Hainich-Kreis","Mühlhausen"]
[null,"Cuxhaven","Cuxhaven","Kempten (Allgäu); Stadt","Kempten (Allgäu)","Parchim","Parchim","Vechta","Vechta"]
[null,"Delitzsch","Delitzsch","Kiel; Landeshauptstadt","Kiel","Peine","Peine","Verden","Verden/Aller"]
[null,"Delmenhorst; Stadt","Delmenhorst","Kleve","Kleve","Pinneberg","Pinneberg","Viersen","Viersen"]
[null,"Demmin","Demmin","Kusel","Kusel","Plön","Plön","Vogelsbergkreis","Lauterbach"]
[null,"Diepholz","Diepholz","Leer","Leer/Ostfriesland","Prignitz","Perleberg","Vogtlandkreis","Plauen"]
[null,"Dithmarschen","Heide","Lippe","Detmold","Recklinghausen","Recklinghausen","Vulkaneifel","Daun"]
[null,"Döbeln","Döbeln","Löbau-Zittau","Zittau","Regen","Regen","Waldeck-Frankenberg","Korbach"]
[null,"Donnersbergkreis","Kirchheimbolanden","Lörrach","Lörrach","Region Hannover","Hannover","Waldshut","Waldshut-Tiengen"]
[null,"Düren","Düren","Lübeck; Hansestadt","Lübeck","Rendsburg-Eckernförde","Rensburg","Warendorf","Warendorf"]
[null,"Eichsfeld","Heilbad Heiligenstadt","Lüchow-Dannenberg","Lüchow; Wendland","Reutlingen","Reutlingen","Weißeritzkreis","Dippoldiswalde"]
[null,"Eifelkreis Bitburg-Prüm","Bitburg","Ludwigslust","Ludwigslust","Rhein-Erft-Kreis","Bergheim","Wesel","Wesel"]
[null,"Emden; Stadt","Emden/Ostfriedland","Lüneburg","Lüneburg","Rhein-Hunsrück-Kreis","Simmern/Hunsrück","Wesemarsch","Brake/Unterweser"]
[null,"Emsland","Meppen","Mainz-Bingen","Ingelheim","Rhein-Kreis Neuss","Neuss","Westerwaldkreis","Montabaur"]
[null,"Ennepe-Ruhr-Kreis","Schwelm","Märkischer Kreis","Lüdenscheid","Riesa-Großenhain","Großenhain","Wilhelmshaven; Stadt","Wilhelmshaven"]
[null,"Euskirchen","Euskirchen","Märkisch-Oberland","Seelow","Rostock","Rostock","Wismar","Wismar"]
[null,"Flensburg; Stadt","Flensburg","Mayen-Koblenz","Koblenz","Rotenburg (Wümme)","Rotenburg/Wümme","Wittmund","Wittmund"]
[null,"Frankfurt (Oder); Stadt","Frankfurt (Oder)","Meckenburg-Streltiz","Neustrelitz","Rügen","Bergen auf Rügen","Wolfenbüttel","Wolfenbüttel"]
[null,"Freiberg","Freiberg","Meißen","Meißen","Saalekreis","Merseburg","Wunsiedel i. Fichtelgebirge","Wunsiedel"]
[null,"Freyung-Grafenau","Freyung","Mettmann","Mettmann","Sächsische Schweiz","Pirna"]