{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["Start","Stammdaten","Mein Zuhause","Beleuchtung","Berechnung Beleuchtung","Beschatttung und Fenster","Berechnung Beschattung","Raumregelungen","Bilder1","Berechnung Raumreg","Mulitmedia","Berechnung Multi","Sicherheit","Berechnung Sicherheit","Komfort","Berechnung Komfort","Berechnung AnalogDigitalmodule","Ihr evon Smart Home","Ihr Schaltschrank","Schaltschrank","Zubehör","Sicherungskreise","Berechungen Schaltschrankmateri","Berechnungen Schaltschrankgröße","Berechnung TEs","Taster"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":"Start","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[24,1,24,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bereit für Ihr Zuhause"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Projekt"]
[null,"Name"]
[null,"Straße und Hausnummer"]
[null,"Postleitzahl / Ort"]
[]
[]
[null,"Auf den nächsten Seiten stellen wir Ihnen ein paar Fragen um das optimale evon Smart Home für Sie individuell zusammen zu stellen"]
[]
[]
[null,null,"los geht’s"]

{"sheet":"Stammdaten","index":1,"n_rows":78,"n_cols":9,"rows_kept":78,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Geschosse",null,"Räume","Verteiler",null,null,"Produkt","TE","Kanäle"]
["EG",null,"Bad","Hauptverteiler",null,null,"HC-iX800SD",7.8]
["UG",null,"Bad - Kinder","Subverteiler 1",null,null,"HC-iX840SD",7.8]
["OG",null,"Büro","Subverteiler 2",null,null,"HC-B1144",2.6,2]
["Außen",null,"Carport","Subverteiler 3",null,null,"HC-B1244",3.9,2]
["Außen EG",null,"Einfahrt","Subverteiler 4",null,null,"HC-B1344",2.6,2]
["Außen UG",null,"Eingang",null,null,null,"HC-L1144",2.6,4]
["Außen OG",null,"Essen",null,null,null,"HC-L1244",3.9,4]
[null,null,"Gang",null,null,null,"HC-L1424",3.9,2]
[null,null,"Grarage",null,null,null,"HC-L1544",2.6,4]
[null,null,"Haustechnik",null,null,null,"HC-L1644",3.9,1]
[null,null,"HWR",null,null,null,"HC-L1842",3.9,20]
[null,null,"Keller",null,null,null,"HC-C1144 ",2.6,4]
[null,null,"Kinderzimmer",null,null,null,"HC-C1244 ",2.6,4]
[null,null,"Kinderzimmer 2",null,null,null,"HC-C110X"]
[null,null,"Küche",null,null,null,"HC-C1109"]
[null,null,"Lager",null,null,null,"HC-C1010"]
[null,null,"Schlafzimmer",null,null,null,"HC-D1180",2.6,8]
[null,null,"Schleuse",null,null,null,"HC-D1208",2.6,8]
[null,null,"Schrankraum",null,null,null,"HC-D1344",2.6]
[null,null,"Speis",null,null,null,"HC-A1144",2.6]
[null,null,"Terrasse",null,null,null,"HC-A1240",2.6,4]
[null,null,"Vorraum",null,null,null,"HC-A1380",2.6]
[null,null,"WC",null,null,null,"HC-TS410",3.9]
[null,null,"Wohnen",null,null,null,"HC-TA200",2.6]
[null,null,null,null,null,null,"HC-S2200",1.3]
[null,null,null,null,null,null,"HC-S2300",1.3]
[null,null,null,null,null,null,"HC-S2400"]
[null,null,null,null,null,null,"HC-TE100",1.3]
[null,null,null,null,null,null,"HC-S100W",5.2]
[null,null,null,null,null,null,"HC-S1100",1.3]
[null,null,null,null,null,null,"HC-S1200",1.3]
[null,null,null,null,null,null,"HC-WSLRW"]
[null,null,null,null,null,null,"HC-SiPB10"]
[null,null,null,null,null,null,"HC-CAM12"]
[null,null,null,null,null,null,"HC-BCAMZ01"]
[null,null,null,null,null,null,"HC-DCAM20"]
[null,null,null,null,null,null,"HC-DCAMZ01"]
[null,null,null,null,null,null,"HC-ULUX"]
[null,null,null,null,null,null,"HC-ULUXEXT1"]
[null,null,null,null,null,null,"HC-ULUXEXT2"]
[null,null,null,null,null,null,"HC-ULUXEXT3"]
[null,null,null,null,null,null,"HC-ULUXEXT4"]
[null,null,null,null,null,null,"HC-KEYAP"]
[null,null,null,null,null,null,"HC-KEYAPR"]
[null,null,null,null,null,null,"HC-KEYUPE"]
[null,null,null,null,null,null,"HC-KEYUPER"]
[null,null,null,null,null,null,"HC-KEYUPI"]
[null,null,null,null,null,null,"HC-KEYUPIR"]
[null,null,null,null,null,null,"HC-KEYIN"]
[null,null,null,null,null,null,"HC-KEYINR"]
[null,null,null,null,null,null,"HC-SPOE42"]
[null,null,null,null,null,null,"HC-SPOE81"]
[null,null,null,null,null,null,"HC-IPOE1"]
[null,null,null,null,null,null,"HC-BRC15"]
[null,null,null,null,null,null,"HC-DIM400",1]
[null,null,null,null,null,null,"HC-KEYZ01"]
[null,null,null,null,null,null,"HC-KEYZ02"]
[null,null,null,null,null,null,"HC-KEYZ03"]
[null,null,null,null,null,null,"HC-KEYZ04"]
[null,null,null,null,null,null,"HC-KEYZ05"]
[null,null,null,null,null,null,"HC-KEYZ06"]
[null,null,null,null,null,null,"HC-KEYZ07"]
[null,null,null,null,null,null,"HC-KEYZ08"]
[null,null,null,null,null,null,"HC-KEYZ09"]
[null,null,null,null,null,null,"HC-KEYZ10 "]
[null,null,null,null,null,null,"HC-SIPZ01"]
[null,null,null,null,null,null,"HC-SIPZ02"]
[null,null,null,null,null,null,"HC-SIPZ03"]
[null,null,null,null,null,null,"HC-SIPZ04"]
[null,null,null,null,null,null,"HC-SIPZ05"]
[null,null,null,null,null,null,"HC-SIPZ06"]
[null,null,null,null,null,null,"HC-WIFIAP"]
[null,null,null,null,null,null,"HC-S2100"]
[null,null,null,null,null,null,"HC-CABP"]
[null,null,null,null,null,null,"HC-CABM"]

{"sheet":"Mein Zuhause","index":2,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[null,"Ihr Zuhause"]
[]
[null,"Zuerst bitten wir Sie um ein paar Informationen zu Ihrem Zuhause, damit wir die weitere Planung erleichtern können."]
[]
[null,null,"nächster Schritt"]
[]
[null,"Geschosse","Räume","Verteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]
[null,null,null,"Hauptverteiler"]

{"sheet":"Beleuchtung","index":3,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[3,1,3,5],[8,1,8,5],[5,4,5,6]]}
[]
[null,"Beleuchtung"]
[]
[null,"Licht ist wesentlich für Ihr Komfortempfinden. Und evon Smart Home sorgt dafür, dass Licht, unabhängig ob Tag oder Nacht, einfach für Sie im richtigen Moment da ist."]
[]
[null,null,null,null,"nächster Schritt"]
[]
[null,"Lichtmodule mit integriertem Leistungsteil",null,null,"Ja"]
[null,"Durch einen im Lichtmodul integrierten Leistungsteil sind keine zusätzlichen Relais für die Ansteuerung der Lampen nötig. Das spart Zeit, Platz und Geld."]
[]
[null,null,"Lichtkreise","Stimmungsbeleuchtung",null,null,null,null,null,"Bewegungsmelder"]
[null,"Raum","Normal","Dimmen","Art der Dimmung","LED mit Farbsteuerung","Dimmen 0-10","Dimmen Glühlampe","Dimmen DALI","24V","230V"]
[null,"SUMME",{"$f":"SUM(C14:C554)","v":0},{"$f":"SUM(D14:D554)","v":0},null,{"$f":"SUM(F14:F554)","v":0},{"$f":"SUM(G14:G46)","v":0},{"$f":"SUM(H14:H46)","v":0},{"$f":"SUM(I14:I46)","v":0},{"$f":"SUM(J14:J554)","v":0},{"$f":"SUM(K14:K554)","v":0}]
[null,{"$f":"IF('Mein Zuhause'!B9<>\"\",'Mein Zuhause'!B9&\" - \"&'Mein Zuhause'!C9,\"\")","v":""},null,null,null,null,{"$f":"IF($E14=\"0-10V\",$D14,0)","v":0},{"$f":"IF($E14=\"Glühlampe\",$D14,0)","v":0},{"$f":"IF($E14=\"DALI\",$D14,0)","v":0}]
[null,{"$f":"IF('Mein Zuhause'!B10<>\"\",'Mein Zuhause'!B10&\" - \"&'Mein Zuhause'!C10,\"\")","v":""},null,null,null,null,{"$f":"IF($E15=\"0-10V\",$D15,0)","v":0},{"$f":"IF($E15=\"Glühlampe\",$D15,0)","v":0},{"$f":"IF(E15=\"DALI\",D15,0)","v":0}]
[null,{"$f":"IF('Mein Zuhause'!B11<>\"\",'Mein Zuhause'!B11&\" - \"&'Mein Zuhause'!C11,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B12<>\"\",'Mein Zuhause'!B12&\" - \"&'Mein Zuhause'!C12,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B13<>\"\",'Mein Zuhause'!B13&\" - \"&'Mein Zuhause'!C13,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B14<>\"\",'Mein Zuhause'!B14&\" - \"&'Mein Zuhause'!C14,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B15<>\"\",'Mein Zuhause'!B15&\" - \"&'Mein Zuhause'!C15,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B16<>\"\",'Mein Zuhause'!B16&\" - \"&'Mein Zuhause'!C16,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B17<>\"\",'Mein Zuhause'!B17&\" - \"&'Mein Zuhause'!C17,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B18<>\"\",'Mein Zuhause'!B18&\" - \"&'Mein Zuhause'!C18,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B19<>\"\",'Mein Zuhause'!B19&\" - \"&'Mein Zuhause'!C19,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B20<>\"\",'Mein Zuhause'!B20&\" - \"&'Mein Zuhause'!C20,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B21<>\"\",'Mein Zuhause'!B21&\" - \"&'Mein Zuhause'!C21,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B22<>\"\",'Mein Zuhause'!B22&\" - \"&'Mein Zuhause'!C22,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B23<>\"\",'Mein Zuhause'!B23&\" - \"&'Mein Zuhause'!C23,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B24<>\"\",'Mein Zuhause'!B24&\" - \"&'Mein Zuhause'!C24,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B25<>\"\",'Mein Zuhause'!B25&\" - \"&'Mein Zuhause'!C25,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B26<>\"\",'Mein Zuhause'!B26&\" - \"&'Mein Zuhause'!C26,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B27<>\"\",'Mein Zuhause'!B27&\" - \"&'Mein Zuhause'!C27,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B28<>\"\",'Mein Zuhause'!B28&\" - \"&'Mein Zuhause'!C28,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B29<>\"\",'Mein Zuhause'!B29&\" - \"&'Mein Zuhause'!C29,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B30<>\"\",'Mein Zuhause'!B30&\" - \"&'Mein Zuhause'!C30,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B31<>\"\",'Mein Zuhause'!B31&\" - \"&'Mein Zuhause'!C31,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B32<>\"\",'Mein Zuhause'!B32&\" - \"&'Mein Zuhause'!C32,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B33<>\"\",'Mein Zuhause'!B33&\" - \"&'Mein Zuhause'!C33,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B34<>\"\",'Mein Zuhause'!B34&\" - \"&'Mein Zuhause'!C34,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B35<>\"\",'Mein Zuhause'!B35&\" - \"&'Mein Zuhause'!C35,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B36<>\"\",'Mein Zuhause'!B36&\" - \"&'Mein Zuhause'!C36,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B37<>\"\",'Mein Zuhause'!B37&\" - \"&'Mein Zuhause'!C37,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B38<>\"\",'Mein Zuhause'!B38&\" - \"&'Mein Zuhause'!C38,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B39<>\"\",'Mein Zuhause'!B39&\" - \"&'Mein Zuhause'!C39,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B40<>\"\",'Mein Zuhause'!B40&\" - \"&'Mein Zuhause'!C40,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B41<>\"\",'Mein Zuhause'!B41&\" - \"&'Mein Zuhause'!C41,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B42<>\"\",'Mein Zuhause'!B42&\" - \"&'Mein Zuhause'!C42,\"\")","v":""},null,null,null,null,0,0,{"$f":"IF(E47=\"DALI\",D47,0)","v":0}]
[null,{"$f":"IF('Mein Zuhause'!B43<>\"\",'Mein Zuhause'!B43&\" - \"&'Mein Zuhause'!C43,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B44<>\"\",'Mein Zuhause'!B44&\" - \"&'Mein Zuhause'!C44,\"\")","v":""},null,null,null,null,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B45<>\"\",'Mein Zuhause'!B45&\" - \"&'Mein Zuhause'!C45,\"\")","v":""},null,null,null,null,0,0,0]

{"sheet":"Berechnung Beleuchtung","index":4,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Verteileraufteilung",null,null,null,null,null,null,null,null,"MODULE"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"Stammdaten!G9","v":"HC-L1144"},{"$f":"Stammdaten!G10","v":"HC-L1244"},{"$f":"Stammdaten!G11","v":"HC-L1424"},{"$f":"Stammdaten!G12","v":"HC-L1544"},{"$f":"Stammdaten!G14","v":"HC-L1842"},{"$f":"Stammdaten!G13","v":"HC-L1644"},{"$f":"Stammdaten!G58","v":"HC-DIM400"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Stammdaten!H9","v":2.6},{"$f":"Stammdaten!H10","v":3.9},{"$f":"Stammdaten!H11","v":3.9},{"$f":"Stammdaten!H12","v":2.6},{"$f":"Stammdaten!H14","v":3.9},{"$f":"Stammdaten!H13","v":3.9},{"$f":"Stammdaten!H58","v":1},"TE"]
[null,null,"Funktion",null,null,null,null,null,null,{"$f":"Stammdaten!I9","v":4},{"$f":"Stammdaten!I10","v":4},{"$f":"Stammdaten!I11","v":2},{"$f":"Stammdaten!I12","v":4},{"$f":"Stammdaten!I14","v":20},{"$f":"Stammdaten!I13","v":1},1,"Anzahl Kanäle/Modul"]
["Zuordnung","Verteiler","Normal","Dimmen 0-10","Dimmen Glühlampe","Dimmen DALI","LED mit Farbsteuerung","24V","230V","Normal","Normal mit 230","Dimmen 0-10","Dimmen Glühlampe","Dimmen DALI","LED mit Farbsteuerung",null,"Teilungseinheiten"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J8:J12)","v":0},{"$f":"SUM(K8:K12)","v":0},{"$f":"SUM(L8:L12)","v":0},0,0,0,null,null,"Summe Module"]
[{"$f":"'Mein Zuhause'!$D9","v":"Hauptverteiler"},{"$f":"Stammdaten!$D4","v":"Hauptverteiler"},{"$f":"SUMIF($A$8:$A$44,$B8,Beleuchtung!C$14:C$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,Beleuchtung!G$14:G$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,Beleuchtung!H$14:H$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,Beleuchtung!I$14:I$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,Beleuchtung!F$14:F$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,Beleuchtung!J$14:J$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,Beleuchtung!K$14:K$50)","v":0},{"$f":"IF(Beleuchtung!$E$8=\"Ja\",0,ROUNDUP(C8/J$5,0))","v":0},{"$f":"IF(Beleuchtung!$E$8=\"Ja\",ROUNDUP(C8/K$5,0),0)","v":0},{"$f":"ROUNDUP(D8/L$5,0)","v":0},{"$f":"ROUNDUP(E8/M$5,0)","v":0},{"$f":"ROUNDUP(F8/N$5,0)","v":0},{"$f":"ROUNDUP(G8/O$5,0)","v":0},{"$f":"M8","v":0},{"$f":"$J8*$J$4+K8*$K$4+L8*$L$4+M8*M$4+N8*$N$4+O8*$O$4+P8*$P$4","v":0}]
[{"$f":"'Mein Zuhause'!$D10","v":"Hauptverteiler"},{"$f":"Stammdaten!$D5","v":"Subverteiler 1"},{"$f":"SUMIF($A$8:$A$44,$B9,Beleuchtung!C$14:C$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,Beleuchtung!G$14:G$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,Beleuchtung!H$14:H$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,Beleuchtung!I$14:I$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,Beleuchtung!F$14:F$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,Beleuchtung!J$14:J$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,Beleuchtung!K$14:K$50)","v":0},{"$f":"IF(Beleuchtung!$E$8=\"Ja\",0,ROUNDUP(C9/J$5,0))","v":0},{"$f":"IF(Beleuchtung!$E$8=\"Ja\",ROUNDUP(C9/K$5,0),0)","v":0},{"$f":"ROUNDUP(D9/L$5,0)","v":0},{"$f":"ROUNDUP(E9/M$5,0)","v":0},{"$f":"ROUNDUP(F9/N$5,0)","v":0},{"$f":"ROUNDUP(G9/O$5,0)","v":0},{"$f":"M9","v":0},{"$f":"$J9*$J$4+K9*$K$4+L9*$L$4+M9*M$4+N9*$N$4+O9*$O$4+P9*$P$4","v":0}]
[{"$f":"'Mein Zuhause'!$D11","v":"Hauptverteiler"},{"$f":"Stammdaten!$D6","v":"Subverteiler 2"},{"$f":"SUMIF($A$8:$A$44,$B10,Beleuchtung!C$14:C$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,Beleuchtung!G$14:G$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,Beleuchtung!H$14:H$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,Beleuchtung!I$14:I$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,Beleuchtung!F$14:F$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,Beleuchtung!J$14:J$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,Beleuchtung!K$14:K$50)","v":0},{"$f":"IF(Beleuchtung!$E$8=\"Ja\",0,ROUNDUP(C10/J$5,0))","v":0},{"$f":"IF(Beleuchtung!$E$8=\"Ja\",ROUNDUP(C10/K$5,0),0)","v":0},0,0,0,0,0,0]
[{"$f":"'Mein Zuhause'!$D12","v":"Hauptverteiler"},{"$f":"Stammdaten!$D7","v":"Subverteiler 3"},{"$f":"SUMIF($A$8:$A$44,$B11,Beleuchtung!C$14:C$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,Beleuchtung!G$14:G$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,Beleuchtung!H$14:H$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,Beleuchtung!I$14:I$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,Beleuchtung!F$14:F$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,Beleuchtung!J$14:J$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,Beleuchtung!K$14:K$50)","v":0},{"$f":"IF(Beleuchtung!$E$8=\"Ja\",0,ROUNDUP(C11/J$5,0))","v":0},{"$f":"IF(Beleuchtung!$E$8=\"Ja\",ROUNDUP(C11/K$5,0),0)","v":0},0,0,0,0,0,0]
[{"$f":"'Mein Zuhause'!$D13","v":"Hauptverteiler"},{"$f":"Stammdaten!$D8","v":"Subverteiler 4"},{"$f":"SUMIF($A$8:$A$44,$B12,Beleuchtung!C$14:C$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,Beleuchtung!G$14:G$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,Beleuchtung!H$14:H$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,Beleuchtung!I$14:I$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,Beleuchtung!F$14:F$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,Beleuchtung!J$14:J$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,Beleuchtung!K$14:K$50)","v":0},{"$f":"IF(Beleuchtung!$E$8=\"Ja\",0,ROUNDUP(C12/J$5,0))","v":0},{"$f":"IF(Beleuchtung!$E$8=\"Ja\",ROUNDUP(C12/K$5,0),0)","v":0},0,0,0,0,0,0]
[{"$f":"'Mein Zuhause'!$D14","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D15","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D16","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D17","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D18","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D19","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D20","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D21","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D22","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D23","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D24","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D25","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D26","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D27","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D28","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D29","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D30","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D31","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D32","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D33","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D34","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D35","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D36","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D37","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D38","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D39","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D40","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D41","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D42","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D43","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D44","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D45","v":"Hauptverteiler"}]

{"sheet":"Beschatttung und Fenster","index":5,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[10,6,10,7],[3,1,3,6],[5,4,5,6]]}
[]
[null,"Beschattung & Fenster"]
[]
[null,"Die Steuerung von Jalousien ist eine Kernaufgabe eines Smart Home Systems. Doch gerade Licht und Schatten kann Ihren Energieverbrauch über den Jahresverlauf relativ stark beeinflussen. "]
[]
[null,null,null,null,"nächster Schritt"]
[]
[null,"Zubehör"]
[null,"Wetterstation",{"$f":"IF(SUM(C14:G35)>0,1,0)","v":0},"Stk"]
[]
[null,null,"Raffstore",null,null,null,"Dachfenster"]
[null,"Raum","Normal","Schlotterer Retrolux","24V Antrieb","Rollo","ROTO","Velux","Fensterkontakt"]
[null,"SUMME",{"$f":"SUM(C14:C47)","v":0},0,0,0,0,0,{"$f":"SUM(I14:I46)","v":0}]
[null,{"$f":"IF('Mein Zuhause'!B9<>\"\",'Mein Zuhause'!B9&\" - \"&'Mein Zuhause'!C9,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B10<>\"\",'Mein Zuhause'!B10&\" - \"&'Mein Zuhause'!C10,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B11<>\"\",'Mein Zuhause'!B11&\" - \"&'Mein Zuhause'!C11,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B12<>\"\",'Mein Zuhause'!B12&\" - \"&'Mein Zuhause'!C12,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B13<>\"\",'Mein Zuhause'!B13&\" - \"&'Mein Zuhause'!C13,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B14<>\"\",'Mein Zuhause'!B14&\" - \"&'Mein Zuhause'!C14,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B15<>\"\",'Mein Zuhause'!B15&\" - \"&'Mein Zuhause'!C15,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B16<>\"\",'Mein Zuhause'!B16&\" - \"&'Mein Zuhause'!C16,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B17<>\"\",'Mein Zuhause'!B17&\" - \"&'Mein Zuhause'!C17,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B18<>\"\",'Mein Zuhause'!B18&\" - \"&'Mein Zuhause'!C18,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B19<>\"\",'Mein Zuhause'!B19&\" - \"&'Mein Zuhause'!C19,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B20<>\"\",'Mein Zuhause'!B20&\" - \"&'Mein Zuhause'!C20,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B21<>\"\",'Mein Zuhause'!B21&\" - \"&'Mein Zuhause'!C21,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B22<>\"\",'Mein Zuhause'!B22&\" - \"&'Mein Zuhause'!C22,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B23<>\"\",'Mein Zuhause'!B23&\" - \"&'Mein Zuhause'!C23,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B24<>\"\",'Mein Zuhause'!B24&\" - \"&'Mein Zuhause'!C24,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B25<>\"\",'Mein Zuhause'!B25&\" - \"&'Mein Zuhause'!C25,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B26<>\"\",'Mein Zuhause'!B26&\" - \"&'Mein Zuhause'!C26,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B27<>\"\",'Mein Zuhause'!B27&\" - \"&'Mein Zuhause'!C27,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B28<>\"\",'Mein Zuhause'!B28&\" - \"&'Mein Zuhause'!C28,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B29<>\"\",'Mein Zuhause'!B29&\" - \"&'Mein Zuhause'!C29,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B30<>\"\",'Mein Zuhause'!B30&\" - \"&'Mein Zuhause'!C30,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B31<>\"\",'Mein Zuhause'!B31&\" - \"&'Mein Zuhause'!C31,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B32<>\"\",'Mein Zuhause'!B32&\" - \"&'Mein Zuhause'!C32,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B33<>\"\",'Mein Zuhause'!B33&\" - \"&'Mein Zuhause'!C33,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B34<>\"\",'Mein Zuhause'!B34&\" - \"&'Mein Zuhause'!C34,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B35<>\"\",'Mein Zuhause'!B35&\" - \"&'Mein Zuhause'!C35,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B36<>\"\",'Mein Zuhause'!B36&\" - \"&'Mein Zuhause'!C36,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B37<>\"\",'Mein Zuhause'!B37&\" - \"&'Mein Zuhause'!C37,\"\")","v":""}]

{"sheet":"Berechnung Beschattung","index":6,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Verteileraufteilung",null,null,null,null,null,null,null,null,"MODULE","Anz. Kanäle"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"Stammdaten!G6","v":"HC-B1144"},{"$f":"Stammdaten!G8","v":"HC-B1344"},{"$f":"Stammdaten!G$10","v":"HC-L1244"},{"$f":"Stammdaten!G$6","v":"HC-B1144"},{"$f":"Stammdaten!G6","v":"HC-B1144"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Stammdaten!H6","v":2.6},{"$f":"Stammdaten!H8","v":2.6},{"$f":"Stammdaten!H$10","v":3.9},{"$f":"Stammdaten!H$6","v":2.6},{"$f":"Stammdaten!H6","v":2.6},"TE"]
[null,null,null,null,null,null,null,null,null,{"$f":"Stammdaten!I6","v":2},{"$f":"Stammdaten!I8","v":2},{"$f":"Stammdaten!I$10","v":4},{"$f":"Stammdaten!I$6","v":2},{"$f":"Stammdaten!I6","v":2},"Kanäle"]
["Zuordnung","Summen",{"$f":"'Beschatttung und Fenster'!C12","v":"Normal"},{"$f":"'Beschatttung und Fenster'!D12","v":"Schlotterer Retrolux"},{"$f":"'Beschatttung und Fenster'!E12","v":"24V Antrieb"},{"$f":"'Beschatttung und Fenster'!F12","v":"Rollo"},{"$f":"'Beschatttung und Fenster'!G12","v":"ROTO"},{"$f":"'Beschatttung und Fenster'!H12","v":"Velux"},{"$f":"'Beschatttung und Fenster'!I12","v":"Fensterkontakt"},{"$f":"'Beschatttung und Fenster'!C12","v":"Normal"},{"$f":"'Beschatttung und Fenster'!D12","v":"Schlotterer Retrolux"},{"$f":"'Beschatttung und Fenster'!E12","v":"24V Antrieb"},{"$f":"'Beschatttung und Fenster'!F12","v":"Rollo"},{"$f":"'Beschatttung und Fenster'!G12","v":"ROTO"},"Teilungseinheiten","SUMME Module Normal + Rollo + ROTO"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J8:J12)","v":0},{"$f":"SUM(K8:K12)","v":0},0,0,0,null,{"$f":"J7+M7+N7","v":0}]
[{"$f":"'Mein Zuhause'!$D9","v":"Hauptverteiler"},{"$f":"Stammdaten!$D4","v":"Hauptverteiler"},{"$f":"SUMIF($A$8:$A$44,$B8,'Beschatttung und Fenster'!C$14:C$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,'Beschatttung und Fenster'!D$14:D$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,'Beschatttung und Fenster'!E$14:E$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,'Beschatttung und Fenster'!F$14:F$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,'Beschatttung und Fenster'!G$14:G$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,'Beschatttung und Fenster'!H$14:H$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B8,'Beschatttung und Fenster'!I$14:I$50)","v":0},{"$f":"ROUNDUP(C8/J$5,0)","v":0},{"$f":"ROUNDUP(D8/K$5,0)","v":0},0,0,0,{"$f":"J8*$J$4+K8*$K$4+L8*$L$4+M8*$M$4+N8*$N$4","v":0}]
[{"$f":"'Mein Zuhause'!$D10","v":"Hauptverteiler"},{"$f":"Stammdaten!$D5","v":"Subverteiler 1"},{"$f":"SUMIF($A$8:$A$44,$B9,'Beschatttung und Fenster'!C$14:C$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,'Beschatttung und Fenster'!D$14:D$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,'Beschatttung und Fenster'!E$14:E$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,'Beschatttung und Fenster'!F$14:F$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,'Beschatttung und Fenster'!G$14:G$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,'Beschatttung und Fenster'!H$14:H$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B9,'Beschatttung und Fenster'!I$14:I$50)","v":0},{"$f":"ROUNDUP(C9/J$5,0)","v":0},{"$f":"ROUNDUP(D9/K$5,0)","v":0},{"$f":"ROUNDUP(E9/L$5,0)","v":0},{"$f":"ROUNDUP(F9/M$5,0)","v":0},{"$f":"ROUNDUP(G9/N$5,0)","v":0},{"$f":"J9*$J$4+K9*$K$4+L9*$L$4+M9*$M$4+N9*$N$4","v":0}]
[{"$f":"'Mein Zuhause'!$D11","v":"Hauptverteiler"},{"$f":"Stammdaten!$D6","v":"Subverteiler 2"},{"$f":"SUMIF($A$8:$A$44,$B10,'Beschatttung und Fenster'!C$14:C$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,'Beschatttung und Fenster'!D$14:D$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,'Beschatttung und Fenster'!E$14:E$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,'Beschatttung und Fenster'!F$14:F$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,'Beschatttung und Fenster'!G$14:G$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,'Beschatttung und Fenster'!H$14:H$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B10,'Beschatttung und Fenster'!I$14:I$50)","v":0},0,0,0,0,0,0]
[{"$f":"'Mein Zuhause'!$D12","v":"Hauptverteiler"},{"$f":"Stammdaten!$D7","v":"Subverteiler 3"},{"$f":"SUMIF($A$8:$A$44,$B11,'Beschatttung und Fenster'!C$14:C$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,'Beschatttung und Fenster'!D$14:D$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,'Beschatttung und Fenster'!E$14:E$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,'Beschatttung und Fenster'!F$14:F$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,'Beschatttung und Fenster'!G$14:G$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,'Beschatttung und Fenster'!H$14:H$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B11,'Beschatttung und Fenster'!I$14:I$50)","v":0},0,0,0,0,0,0]
[{"$f":"'Mein Zuhause'!$D13","v":"Hauptverteiler"},{"$f":"Stammdaten!$D8","v":"Subverteiler 4"},{"$f":"SUMIF($A$8:$A$44,$B12,'Beschatttung und Fenster'!C$14:C$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,'Beschatttung und Fenster'!D$14:D$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,'Beschatttung und Fenster'!E$14:E$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,'Beschatttung und Fenster'!F$14:F$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,'Beschatttung und Fenster'!G$14:G$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,'Beschatttung und Fenster'!H$14:H$50)","v":0},{"$f":"SUMIF($A$8:$A$44,$B12,'Beschatttung und Fenster'!I$14:I$50)","v":0},0,0,0,0,0,0]
[{"$f":"'Mein Zuhause'!$D14","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D15","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D16","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D17","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D18","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D19","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D20","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D21","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D22","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D23","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D24","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D25","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D26","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D27","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D28","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D29","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D30","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D31","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D32","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D33","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D34","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D35","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D36","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D37","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D38","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D39","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D40","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D41","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D42","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D43","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D44","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D45","v":"Hauptverteiler"}]

{"sheet":"Raumregelungen","index":7,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,1,3,6],[7,4,7,6],[13,2,13,4],[5,1,5,6]]}
[]
[null,"Klima und Wohnkomfort"]
[]
[null,"Bereit für wohlige Wärme, aber auch bereit, Sie beim Energiesparen zu unterstützen. So lassen sich die Vorteile von evon Smart Home im Bereich Klima zusammenfassen."]
[]
[null,"Beachten Sie auch, dass Sie die Integration Ihrer Heizung (Wärmepumpe oder dgl.) mitplanen. Für weitere Informationen kontaktieren Sie Ihren evon Smart Home Betreuer."]
[]
[null,null,null,null,"nächster Schritt"]
[]
[]
[null,"Zubehör"]
[null,"Raumbediengeräte","Nur Temperatursensor",{"$f":"C16","v":0},"Stk"]
[]
[]
[null,"Raum","Heizkreis","Kühldecke"]
[null,"SUMME",{"$f":"COUNTIF(C17:C54,\"X\")","v":0},{"$f":"COUNTIF(D17:D54,\"X\")","v":0}]
[null,{"$f":"IF('Mein Zuhause'!B9<>\"\",'Mein Zuhause'!B9&\" - \"&'Mein Zuhause'!C9,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B10<>\"\",'Mein Zuhause'!B10&\" - \"&'Mein Zuhause'!C10,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B11<>\"\",'Mein Zuhause'!B11&\" - \"&'Mein Zuhause'!C11,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B12<>\"\",'Mein Zuhause'!B12&\" - \"&'Mein Zuhause'!C12,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B13<>\"\",'Mein Zuhause'!B13&\" - \"&'Mein Zuhause'!C13,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B14<>\"\",'Mein Zuhause'!B14&\" - \"&'Mein Zuhause'!C14,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B15<>\"\",'Mein Zuhause'!B15&\" - \"&'Mein Zuhause'!C15,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B16<>\"\",'Mein Zuhause'!B16&\" - \"&'Mein Zuhause'!C16,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B17<>\"\",'Mein Zuhause'!B17&\" - \"&'Mein Zuhause'!C17,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B18<>\"\",'Mein Zuhause'!B18&\" - \"&'Mein Zuhause'!C18,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B19<>\"\",'Mein Zuhause'!B19&\" - \"&'Mein Zuhause'!C19,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B20<>\"\",'Mein Zuhause'!B20&\" - \"&'Mein Zuhause'!C20,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B21<>\"\",'Mein Zuhause'!B21&\" - \"&'Mein Zuhause'!C21,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B22<>\"\",'Mein Zuhause'!B22&\" - \"&'Mein Zuhause'!C22,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B23<>\"\",'Mein Zuhause'!B23&\" - \"&'Mein Zuhause'!C23,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B24<>\"\",'Mein Zuhause'!B24&\" - \"&'Mein Zuhause'!C24,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B25<>\"\",'Mein Zuhause'!B25&\" - \"&'Mein Zuhause'!C25,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B26<>\"\",'Mein Zuhause'!B26&\" - \"&'Mein Zuhause'!C26,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B27<>\"\",'Mein Zuhause'!B27&\" - \"&'Mein Zuhause'!C27,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B28<>\"\",'Mein Zuhause'!B28&\" - \"&'Mein Zuhause'!C28,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B29<>\"\",'Mein Zuhause'!B29&\" - \"&'Mein Zuhause'!C29,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B30<>\"\",'Mein Zuhause'!B30&\" - \"&'Mein Zuhause'!C30,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B31<>\"\",'Mein Zuhause'!B31&\" - \"&'Mein Zuhause'!C31,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B32<>\"\",'Mein Zuhause'!B32&\" - \"&'Mein Zuhause'!C32,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B33<>\"\",'Mein Zuhause'!B33&\" - \"&'Mein Zuhause'!C33,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B34<>\"\",'Mein Zuhause'!B34&\" - \"&'Mein Zuhause'!C34,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B35<>\"\",'Mein Zuhause'!B35&\" - \"&'Mein Zuhause'!C35,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B36<>\"\",'Mein Zuhause'!B36&\" - \"&'Mein Zuhause'!C36,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B37<>\"\",'Mein Zuhause'!B37&\" - \"&'Mein Zuhause'!C37,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B38<>\"\",'Mein Zuhause'!B38&\" - \"&'Mein Zuhause'!C38,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B39<>\"\",'Mein Zuhause'!B39&\" - \"&'Mein Zuhause'!C39,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B40<>\"\",'Mein Zuhause'!B40&\" - \"&'Mein Zuhause'!C40,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B41<>\"\",'Mein Zuhause'!B41&\" - \"&'Mein Zuhause'!C41,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B42<>\"\",'Mein Zuhause'!B42&\" - \"&'Mein Zuhause'!C42,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B43<>\"\",'Mein Zuhause'!B43&\" - \"&'Mein Zuhause'!C43,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B44<>\"\",'Mein Zuhause'!B44&\" - \"&'Mein Zuhause'!C44,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B45<>\"\",'Mein Zuhause'!B45&\" - \"&'Mein Zuhause'!C45,\"\")","v":""}]

{"sheet":"Bilder1","index":8,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Eco"]
["Touch"]
["Nur Temperatursensor"]

{"sheet":"Berechnung Raumreg","index":9,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[null,null,"Verteileraufteilung",null,null,null,"MODULE","Anz. Kanäle"]
[]
[null,null,null,null,null,null,{"$f":"Stammdaten!G15","v":"HC-C1144 "}]
[null,null,null,null,null,null,{"$f":"Stammdaten!H15","v":2.6}]
[null,null,null,null,null,null,{"$f":"Stammdaten!I15","v":4}]
[null,null,"Zuordnung","Summen",{"$f":"Raumregelungen!C15","v":"Heizkreis"},{"$f":"Raumregelungen!D15","v":"Kühldecke"},"Heiz + Kühldekce","Teilungseinheiten"]
[null,null,null,null,null,null,{"$f":"SUM(G8:G12)","v":0}]
[{"$f":"IF(Raumregelungen!C17=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D17=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D9","v":"Hauptverteiler"},{"$f":"Stammdaten!$D$4","v":"Hauptverteiler"},{"$f":"SUMIF($C$8:$C$44,$D8,$A$8:$A$44)","v":0},{"$f":"SUMIF($C$8:$C$44,$D8,$B$8:$B$44)","v":0},{"$f":"ROUNDUP((E8+F8)/$G$5,0)","v":0},{"$f":"G8*$G$4","v":0}]
[{"$f":"IF(Raumregelungen!C18=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D18=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D10","v":"Hauptverteiler"},{"$f":"Stammdaten!$D$5","v":"Subverteiler 1"},{"$f":"SUMIF($C$8:$C$44,$D9,$A$8:$A$44)","v":0},{"$f":"SUMIF($C$8:$C$44,$D9,$B$8:$B$44)","v":0},{"$f":"ROUNDUP((E9+F9)/$G$5,0)","v":0},{"$f":"G9*$G$4","v":0}]
[{"$f":"IF(Raumregelungen!C19=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D19=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D11","v":"Hauptverteiler"},{"$f":"Stammdaten!$D$6","v":"Subverteiler 2"},0,0,0,0]
[{"$f":"IF(Raumregelungen!C20=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D20=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D12","v":"Hauptverteiler"},{"$f":"Stammdaten!$D$7","v":"Subverteiler 3"},0,0,0,0]
[{"$f":"IF(Raumregelungen!C21=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D21=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D13","v":"Hauptverteiler"},{"$f":"Stammdaten!$D$8","v":"Subverteiler 4"},0,0,0,0]
[{"$f":"IF(Raumregelungen!C22=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D22=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D14","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C23=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D23=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D15","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C24=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D24=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D16","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C25=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D25=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D17","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C26=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D26=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D18","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C27=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D27=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D19","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C28=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D28=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D20","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C29=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D29=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D21","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C30=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D30=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D22","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C31=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D31=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D23","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C32=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D32=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D24","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C33=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D33=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D25","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C34=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D34=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D26","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C35=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D35=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D27","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C36=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D36=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D28","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C37=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D37=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D29","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C38=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D38=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D30","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C39=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D39=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D31","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C40=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D40=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D32","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C41=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D41=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D33","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C42=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D42=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D34","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C43=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D43=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D35","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C44=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D44=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D36","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C45=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D45=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D37","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C46=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D46=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D38","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C47=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D47=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D39","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C48=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D48=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D40","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C49=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D49=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D41","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C50=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D50=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D42","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C51=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D51=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D43","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C52=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D52=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D44","v":"Hauptverteiler"}]
[{"$f":"IF(Raumregelungen!C53=\"X\",1,0)","v":0},{"$f":"IF(Raumregelungen!D53=\"X\",1,0)","v":0},{"$f":"'Mein Zuhause'!$D45","v":"Hauptverteiler"}]

{"sheet":"Mulitmedia","index":10,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,6],[8,4,8,6],[10,2,10,4],[5,1,5,6]]}
[]
[null,"Multimedia"]
[]
[null,"Egal ob Hintergrundmusik und die Sprachausgabe, oder wenn Sie vergessen haben ein Fenster zu schließen. Mit evon Smart Home sind Sie bereit."]
[]
[null,"Beachten Sie die Verwendung von Passiv-Lautsprechern. Die Impedanz der Lautspecher sollte zwischen 4 und 8 Ohm liegen. Dies sind Standard Lautsprecherkennzahlen. Somit können Sie aus einer Vielzahl von Lautsprechern frei wählen (siehe https://doc.evon-smarthome.com/de/faq)"]
[]
[]
[null,null,null,null,"nächster Schritt"]
[]
[null,null,"Musik"]
[null,null,"Mono","Stereo","Taster"]
[null,"SUMME",{"$f":"COUNTIF(C14:C61,\"X\")","v":0},{"$f":"COUNTIF(D14:D61,\"X\")","v":0},0]
[null,{"$f":"IF('Mein Zuhause'!B9<>\"\",'Mein Zuhause'!B9&\" - \"&'Mein Zuhause'!C9,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B10<>\"\",'Mein Zuhause'!B10&\" - \"&'Mein Zuhause'!C10,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B11<>\"\",'Mein Zuhause'!B11&\" - \"&'Mein Zuhause'!C11,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B12<>\"\",'Mein Zuhause'!B12&\" - \"&'Mein Zuhause'!C12,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B13<>\"\",'Mein Zuhause'!B13&\" - \"&'Mein Zuhause'!C13,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B14<>\"\",'Mein Zuhause'!B14&\" - \"&'Mein Zuhause'!C14,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B15<>\"\",'Mein Zuhause'!B15&\" - \"&'Mein Zuhause'!C15,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B16<>\"\",'Mein Zuhause'!B16&\" - \"&'Mein Zuhause'!C16,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B17<>\"\",'Mein Zuhause'!B17&\" - \"&'Mein Zuhause'!C17,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B18<>\"\",'Mein Zuhause'!B18&\" - \"&'Mein Zuhause'!C18,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B19<>\"\",'Mein Zuhause'!B19&\" - \"&'Mein Zuhause'!C19,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B20<>\"\",'Mein Zuhause'!B20&\" - \"&'Mein Zuhause'!C20,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B21<>\"\",'Mein Zuhause'!B21&\" - \"&'Mein Zuhause'!C21,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B22<>\"\",'Mein Zuhause'!B22&\" - \"&'Mein Zuhause'!C22,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B23<>\"\",'Mein Zuhause'!B23&\" - \"&'Mein Zuhause'!C23,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B24<>\"\",'Mein Zuhause'!B24&\" - \"&'Mein Zuhause'!C24,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B25<>\"\",'Mein Zuhause'!B25&\" - \"&'Mein Zuhause'!C25,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B26<>\"\",'Mein Zuhause'!B26&\" - \"&'Mein Zuhause'!C26,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B27<>\"\",'Mein Zuhause'!B27&\" - \"&'Mein Zuhause'!C27,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B28<>\"\",'Mein Zuhause'!B28&\" - \"&'Mein Zuhause'!C28,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B29<>\"\",'Mein Zuhause'!B29&\" - \"&'Mein Zuhause'!C29,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B30<>\"\",'Mein Zuhause'!B30&\" - \"&'Mein Zuhause'!C30,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B31<>\"\",'Mein Zuhause'!B31&\" - \"&'Mein Zuhause'!C31,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B32<>\"\",'Mein Zuhause'!B32&\" - \"&'Mein Zuhause'!C32,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B33<>\"\",'Mein Zuhause'!B33&\" - \"&'Mein Zuhause'!C33,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B34<>\"\",'Mein Zuhause'!B34&\" - \"&'Mein Zuhause'!C34,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B35<>\"\",'Mein Zuhause'!B35&\" - \"&'Mein Zuhause'!C35,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B36<>\"\",'Mein Zuhause'!B36&\" - \"&'Mein Zuhause'!C36,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B37<>\"\",'Mein Zuhause'!B37&\" - \"&'Mein Zuhause'!C37,\"\")","v":""}]

{"sheet":"Berechnung Multi","index":11,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Verteileraufteilung",null,null,null,null,"MODULE","Anz. Kanäle"]
[]
[null,null,null,null,null,null,null,null,2,2]
[null,null,null,"Zuordnung","Summen",{"$f":"Mulitmedia!C12","v":"Mono"},{"$f":"Mulitmedia!D12","v":"Stereo"},{"$f":"Mulitmedia!E12","v":"Taster"},{"$f":"Mulitmedia!C12","v":"Mono"},{"$f":"Mulitmedia!D12","v":"Stereo"}]
[null,null,null,null,null,{"$f":"SUM(F6:F10)","v":0},{"$f":"SUM(G6:G10)","v":0}]
[{"$f":"IF(Mulitmedia!C14=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D14=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E14=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D9","v":"Hauptverteiler"},{"$f":"Stammdaten!$D4","v":"Hauptverteiler"},{"$f":"SUMIF($D$6:$D$42,$E6,$A$6:$A$42)","v":0},{"$f":"SUMIF($D$6:$D$42,$E6,$B$6:$B$42)","v":0},{"$f":"SUMIF($D$6:$D$42,$E6,$C$6:$C$42)","v":0}]
[{"$f":"IF(Mulitmedia!C15=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D15=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E15=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D10","v":"Hauptverteiler"},{"$f":"Stammdaten!$D5","v":"Subverteiler 1"},{"$f":"SUMIF($D$6:$D$42,$E7,$A$6:$A$42)","v":0},{"$f":"SUMIF($D$6:$D$42,$E7,$B$6:$B$42)","v":0},{"$f":"SUMIF($D$6:$D$42,$E7,$C$6:$C$42)","v":0},"keine aufteilung - immer im Hauptverteiler"]
[{"$f":"IF(Mulitmedia!C16=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D16=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E16=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D11","v":"Hauptverteiler"},{"$f":"Stammdaten!$D6","v":"Subverteiler 2"},0,0,0]
[{"$f":"IF(Mulitmedia!C17=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D17=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E17=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D12","v":"Hauptverteiler"},{"$f":"Stammdaten!$D7","v":"Subverteiler 3"},0,0,0]
[{"$f":"IF(Mulitmedia!C18=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D18=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E18=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D13","v":"Hauptverteiler"},{"$f":"Stammdaten!$D8","v":"Subverteiler 4"},0,0,0]
[{"$f":"IF(Mulitmedia!C19=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D19=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E19=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D14","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C20=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D20=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E20=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D15","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C21=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D21=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E21=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D16","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C22=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D22=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E22=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D17","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C23=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D23=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E23=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D18","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C24=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D24=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E24=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D19","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C25=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D25=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E25=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D20","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C26=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D26=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E26=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D21","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C27=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D27=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E27=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D22","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C28=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D28=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E28=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D23","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C29=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D29=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E29=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D24","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C30=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D30=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E30=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D25","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C31=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D31=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E31=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D26","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C32=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D32=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E32=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D27","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C33=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D33=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E33=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D28","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C34=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D34=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E34=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D29","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C35=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D35=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E35=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D30","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C36=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D36=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E36=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D31","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C37=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D37=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E37=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D32","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C38=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D38=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E38=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D33","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C39=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D39=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E39=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D34","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C40=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D40=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E40=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D35","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C41=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D41=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E41=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D36","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C42=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D42=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E42=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D37","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C43=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D43=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E43=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D38","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C44=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D44=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E44=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D39","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C45=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D45=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E45=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D40","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C46=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D46=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E46=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D41","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C47=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D47=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E47=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D42","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C48=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D48=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E48=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D43","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C49=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D49=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E49=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D44","v":"Hauptverteiler"}]
[{"$f":"IF(Mulitmedia!C50=\"X\",1,0)","v":0},{"$f":"IF(Mulitmedia!D50=\"X\",2,0)","v":0},{"$f":"IF(Mulitmedia!E50=\"X\",4,0)","v":0},{"$f":"'Mein Zuhause'!$D45","v":"Hauptverteiler"}]

{"sheet":"Sicherheit","index":12,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":false,"merged":[[9,6,10,6],[3,1,3,18],[5,17,5,18],[7,1,7,5]]}
[]
[null,"Sicherheit"]
[]
[null,"Heute versprechen eine Reihe von meist elektronischen Helfern mehr Sicherheit in Ihrem Zuhause: Ein Rauchmelder in der Küche, eine Alarmanlage oder eine Kamera an der Eingangstür. Alles für sich nützlich und sinnvoll. Spannender wird es, wenn die Vorteile aller Teilsysteme in einem Smart Home System zusammengefasst werden."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nächster Schritt"]
[]
[null,"Netzwerkkomponente zur Spannungsversorgung (POE) der Kameras mit berücksichtigen",null,null,null,null,"Ja"]
[]
[null,null,"Kameras",null,"Rauchmelder","Zutritt","mit Chip (RFID)",null,"Zutritt intern berechnung",null,null,null,null,null,null,null,"Sonstige"]
[null,"Raum","Dome","Bullet",null,"Fingerprint",null,"Montage","up normal","up mit chip","ap normal","ap chip","Türsprech","Türsprech mit chip","integra","integra mit chip","Türsprechanlage","Elektr. Haustür","Garagentor"]
[null,"Summe",{"$f":"SUM(C13:C43)","v":0},{"$f":"SUM(D13:D43)","v":0},0,null,null,null,{"$f":"SUM(I13:I45)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(Q13:Q40)","v":0},0,0]
[null,{"$f":"IF('Mein Zuhause'!B9<>\"\",'Mein Zuhause'!B9&\" - \"&'Mein Zuhause'!C9,\"\")","v":""},null,null,null,null,"-","-",{"$f":"IF($G13<>\"X\",IF($H13=\"Unterputz\",1,0),0)*IF($F13=\"X\",1,0)","v":0},{"$f":"IF($G13=\"X\",IF($H13=\"Unterputz\",1,0),0)*IF($F13=\"X\",1,0)","v":0},{"$f":"IF(G13=\"X\",IF($H13=\"Aufputz\",1,0),0)*IF(F13=\"X\",1,0)","v":0},{"$f":"IF(G13<>\"X\",IF($H13=\"Aufputz\",1,0),0)*IF(F13=\"X\",1,0)","v":0},{"$f":"IF($G13=\"-\",IF($H13=\"In Türsprechanlage\",1,0),0)*IF($F13=\"X\",1,0)","v":0},{"$f":"IF($G13=\"X\",IF($H13=\"In Türsprechanlage\",1,0),0)*IF($F13=\"X\",1,0)","v":0},{"$f":"IF($G13=\"-\",IF($H13=\"Integra\",1,0),0)*IF($F13=\"X\",1,0)","v":0},{"$f":"IF($G13=\"X\",IF($H13=\"Integra\",1,0),0)*IF($F13=\"X\",1,0)","v":0}]
[null,{"$f":"IF('Mein Zuhause'!B10<>\"\",'Mein Zuhause'!B10&\" - \"&'Mein Zuhause'!C10,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B11<>\"\",'Mein Zuhause'!B11&\" - \"&'Mein Zuhause'!C11,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B12<>\"\",'Mein Zuhause'!B12&\" - \"&'Mein Zuhause'!C12,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B13<>\"\",'Mein Zuhause'!B13&\" - \"&'Mein Zuhause'!C13,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B14<>\"\",'Mein Zuhause'!B14&\" - \"&'Mein Zuhause'!C14,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B15<>\"\",'Mein Zuhause'!B15&\" - \"&'Mein Zuhause'!C15,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B16<>\"\",'Mein Zuhause'!B16&\" - \"&'Mein Zuhause'!C16,\"\")","v":""},null,null,null,null,"-","-",{"$f":"IF($G20<>\"X\",IF($H20=\"Unterputz\",1,0),0)*IF($F20=\"X\",1,0)","v":0},{"$f":"IF($G20=\"X\",IF($H20=\"Unterputz\",1,0),0)*IF($F20=\"X\",1,0)","v":0},{"$f":"IF(G20=\"X\",IF($H20=\"Aufputz\",1,0),0)*IF(F20=\"X\",1,0)","v":0},{"$f":"IF(G20<>\"X\",IF($H20=\"Aufputz\",1,0),0)*IF(F20=\"X\",1,0)","v":0},{"$f":"IF($G20=\"-\",IF($H20=\"In Türsprechanlage\",1,0),0)*IF($F20=\"X\",1,0)","v":0},{"$f":"IF($G20=\"X\",IF($H20=\"In Türsprechanlage\",1,0),0)*IF($F20=\"X\",1,0)","v":0},{"$f":"IF($G20=\"-\",IF($H20=\"Integra\",1,0),0)*IF($F20=\"X\",1,0)","v":0},{"$f":"IF($G20=\"X\",IF($H20=\"Integra\",1,0),0)*IF($F20=\"X\",1,0)","v":0}]
[null,{"$f":"IF('Mein Zuhause'!B17<>\"\",'Mein Zuhause'!B17&\" - \"&'Mein Zuhause'!C17,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B18<>\"\",'Mein Zuhause'!B18&\" - \"&'Mein Zuhause'!C18,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B19<>\"\",'Mein Zuhause'!B19&\" - \"&'Mein Zuhause'!C19,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B20<>\"\",'Mein Zuhause'!B20&\" - \"&'Mein Zuhause'!C20,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B21<>\"\",'Mein Zuhause'!B21&\" - \"&'Mein Zuhause'!C21,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B22<>\"\",'Mein Zuhause'!B22&\" - \"&'Mein Zuhause'!C22,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B23<>\"\",'Mein Zuhause'!B23&\" - \"&'Mein Zuhause'!C23,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B24<>\"\",'Mein Zuhause'!B24&\" - \"&'Mein Zuhause'!C24,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B25<>\"\",'Mein Zuhause'!B25&\" - \"&'Mein Zuhause'!C25,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B26<>\"\",'Mein Zuhause'!B26&\" - \"&'Mein Zuhause'!C26,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B27<>\"\",'Mein Zuhause'!B27&\" - \"&'Mein Zuhause'!C27,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B28<>\"\",'Mein Zuhause'!B28&\" - \"&'Mein Zuhause'!C28,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B29<>\"\",'Mein Zuhause'!B29&\" - \"&'Mein Zuhause'!C29,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B30<>\"\",'Mein Zuhause'!B30&\" - \"&'Mein Zuhause'!C30,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B31<>\"\",'Mein Zuhause'!B31&\" - \"&'Mein Zuhause'!C31,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B32<>\"\",'Mein Zuhause'!B32&\" - \"&'Mein Zuhause'!C32,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B33<>\"\",'Mein Zuhause'!B33&\" - \"&'Mein Zuhause'!C33,\"\")","v":""},null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"-","-",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"-","-",0,0,0,0,0,0,0,0]

{"sheet":"Berechnung Sicherheit","index":13,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Verteileraufteilung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MODULE","Anz. Kanäle"]
[]
[null,null,null,null,null,"Zutritt intern ",null,null,null,null,null,null,null,null,null,null,"siehe digitalmodulberechnung"]
["Zuordnung","Summen",{"$f":"Sicherheit!C11","v":"Dome"},{"$f":"Sicherheit!D11","v":"Bullet"},{"$f":"Sicherheit!E10","v":"Rauchmelder"},{"$f":"Sicherheit!I11","v":"up normal"},{"$f":"Sicherheit!J11","v":"up mit chip"},{"$f":"Sicherheit!K11","v":"ap normal"},{"$f":"Sicherheit!L11","v":"ap chip"},{"$f":"Sicherheit!M11","v":"Türsprech"},{"$f":"Sicherheit!N11","v":"Türsprech mit chip"},{"$f":"Sicherheit!O11","v":"integra"},{"$f":"Sicherheit!P11","v":"integra mit chip"},{"$f":"Sicherheit!Q11","v":"Türsprechanlage"},{"$f":"Sicherheit!R11","v":"Elektr. Haustür"},{"$f":"Sicherheit!S11","v":"Garagentor"}]
[]
[{"$f":"'Mein Zuhause'!$D9","v":"Hauptverteiler"},{"$f":"Stammdaten!$D4","v":"Hauptverteiler"},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!C$13:C$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!D$13:D$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!E$13:E$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!I$13:I$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!J$13:J$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!K$13:K$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!L$13:L$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!M$13:M$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!N$13:N$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!O$13:O$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!P$13:P$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!Q$13:Q$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!R$13:R$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Sicherheit!S$13:S$45)","v":0}]
[{"$f":"'Mein Zuhause'!$D10","v":"Hauptverteiler"},{"$f":"Stammdaten!$D5","v":"Subverteiler 1"},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!C$13:C$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!D$13:D$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!E$13:E$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!I$13:I$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!J$13:J$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!K$13:K$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!L$13:L$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!M$13:M$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!N$13:N$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!O$13:O$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!P$13:P$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!Q$13:Q$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!R$13:R$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Sicherheit!S$13:S$45)","v":0}]
[{"$f":"'Mein Zuhause'!$D11","v":"Hauptverteiler"},{"$f":"Stammdaten!$D6","v":"Subverteiler 2"},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!C$13:C$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!D$13:D$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!E$13:E$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!I$13:I$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!J$13:J$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!K$13:K$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!L$13:L$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!M$13:M$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!N$13:N$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!O$13:O$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!P$13:P$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!Q$13:Q$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!R$13:R$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Sicherheit!S$13:S$45)","v":0},"Rest wird nicht aufgeteilt"]
[{"$f":"'Mein Zuhause'!$D12","v":"Hauptverteiler"},{"$f":"Stammdaten!$D7","v":"Subverteiler 3"},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!C$13:C$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!D$13:D$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!E$13:E$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!I$13:I$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!J$13:J$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!K$13:K$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!L$13:L$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!M$13:M$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!N$13:N$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!O$13:O$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!P$13:P$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!Q$13:Q$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!R$13:R$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Sicherheit!S$13:S$45)","v":0}]
[{"$f":"'Mein Zuhause'!$D13","v":"Hauptverteiler"},{"$f":"Stammdaten!$D8","v":"Subverteiler 4"},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!C$13:C$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!D$13:D$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!E$13:E$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!I$13:I$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!J$13:J$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!K$13:K$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!L$13:L$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!M$13:M$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!N$13:N$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!O$13:O$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!P$13:P$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!Q$13:Q$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!R$13:R$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Sicherheit!S$13:S$45)","v":0}]
[{"$f":"'Mein Zuhause'!$D14","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D15","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D16","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D17","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D18","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D19","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D20","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D21","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D22","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D23","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D24","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D25","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D26","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D27","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D28","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D29","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D30","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D31","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D32","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D33","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D34","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D35","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D36","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D37","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D38","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D39","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D40","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D41","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D42","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D43","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D44","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D45","v":"Hauptverteiler"}]

{"sheet":"Komfort","index":14,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[3,1,3,6],[5,4,5,6]]}
[]
[null,"Komfort"]
[]
[null,"Heute versprechen eine Reihe von meist elektronischen Helfern mehr Sicherheit in Ihrem Zuhause: Ein Rauchmelder in der Küche, eine Alarmanlage oder eine Kamera an der Eingangstür. Alles für sich nützlich und sinnvoll. Spannender wird es, wenn die Vorteile aller Teilsysteme in einem Smart Home System zusammengefasst werden."]
[]
[null,null,null,null,"fertig!"]
[]
[]
[null,"Raum","Bad/WC Lüfter","Steckdosen geschalten","Badheizkörper elektrisch","Zusätzliche Temperatur-\nmessung","Szenentaster"]
[null,"Summe",{"$f":"SUM(C11:C35)","v":0},{"$f":"SUM(D11:D35)","v":0},0,0,0]
[null,{"$f":"IF('Mein Zuhause'!B9<>\"\",'Mein Zuhause'!B9&\" - \"&'Mein Zuhause'!C9,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B10<>\"\",'Mein Zuhause'!B10&\" - \"&'Mein Zuhause'!C10,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B11<>\"\",'Mein Zuhause'!B11&\" - \"&'Mein Zuhause'!C11,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B12<>\"\",'Mein Zuhause'!B12&\" - \"&'Mein Zuhause'!C12,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B13<>\"\",'Mein Zuhause'!B13&\" - \"&'Mein Zuhause'!C13,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B14<>\"\",'Mein Zuhause'!B14&\" - \"&'Mein Zuhause'!C14,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B15<>\"\",'Mein Zuhause'!B15&\" - \"&'Mein Zuhause'!C15,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B16<>\"\",'Mein Zuhause'!B16&\" - \"&'Mein Zuhause'!C16,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B17<>\"\",'Mein Zuhause'!B17&\" - \"&'Mein Zuhause'!C17,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B18<>\"\",'Mein Zuhause'!B18&\" - \"&'Mein Zuhause'!C18,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B19<>\"\",'Mein Zuhause'!B19&\" - \"&'Mein Zuhause'!C19,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B20<>\"\",'Mein Zuhause'!B20&\" - \"&'Mein Zuhause'!C20,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B21<>\"\",'Mein Zuhause'!B21&\" - \"&'Mein Zuhause'!C21,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B22<>\"\",'Mein Zuhause'!B22&\" - \"&'Mein Zuhause'!C22,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B23<>\"\",'Mein Zuhause'!B23&\" - \"&'Mein Zuhause'!C23,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B24<>\"\",'Mein Zuhause'!B24&\" - \"&'Mein Zuhause'!C24,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B25<>\"\",'Mein Zuhause'!B25&\" - \"&'Mein Zuhause'!C25,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B26<>\"\",'Mein Zuhause'!B26&\" - \"&'Mein Zuhause'!C26,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B27<>\"\",'Mein Zuhause'!B27&\" - \"&'Mein Zuhause'!C27,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B28<>\"\",'Mein Zuhause'!B28&\" - \"&'Mein Zuhause'!C28,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B29<>\"\",'Mein Zuhause'!B29&\" - \"&'Mein Zuhause'!C29,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B30<>\"\",'Mein Zuhause'!B30&\" - \"&'Mein Zuhause'!C30,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B31<>\"\",'Mein Zuhause'!B31&\" - \"&'Mein Zuhause'!C31,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B32<>\"\",'Mein Zuhause'!B32&\" - \"&'Mein Zuhause'!C32,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B33<>\"\",'Mein Zuhause'!B33&\" - \"&'Mein Zuhause'!C33,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B34<>\"\",'Mein Zuhause'!B34&\" - \"&'Mein Zuhause'!C34,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B35<>\"\",'Mein Zuhause'!B35&\" - \"&'Mein Zuhause'!C35,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B36<>\"\",'Mein Zuhause'!B36&\" - \"&'Mein Zuhause'!C36,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B37<>\"\",'Mein Zuhause'!B37&\" - \"&'Mein Zuhause'!C37,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B38<>\"\",'Mein Zuhause'!B38&\" - \"&'Mein Zuhause'!C38,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B39<>\"\",'Mein Zuhause'!B39&\" - \"&'Mein Zuhause'!C39,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B40<>\"\",'Mein Zuhause'!B40&\" - \"&'Mein Zuhause'!C40,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B41<>\"\",'Mein Zuhause'!B41&\" - \"&'Mein Zuhause'!C41,\"\")","v":""}]
[null,{"$f":"IF('Mein Zuhause'!B42<>\"\",'Mein Zuhause'!B42&\" - \"&'Mein Zuhause'!C42,\"\")","v":""}]

{"sheet":"Berechnung Komfort","index":15,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Verteileraufteilung",null,null,null,null,null,null,"MODULE","Anz. Kanäle"]
[null,null,null,null,null,null,null,"siehe digitalmodulberechnung"]
[]
["Zuordnung","Summen",{"$f":"Komfort!C9","v":"Bad/WC Lüfter"},{"$f":"Komfort!D9","v":"Steckdosen geschalten"},{"$f":"Komfort!E9","v":"Badheizkörper elektrisch"},{"$f":"Komfort!F9","v":"Zusätzliche Temperatur-\nmessung"},{"$f":"Komfort!G9","v":"Szenentaster"}]
[]
[{"$f":"'Mein Zuhause'!$D9","v":"Hauptverteiler"},{"$f":"Stammdaten!$D4","v":"Hauptverteiler"},{"$f":"SUMIF($A$6:$A$42,$B6,Komfort!C$11:C$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Komfort!D$11:D$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Komfort!E$11:E$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Komfort!F$11:F$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B6,Komfort!$G$11:$G$44)","v":0}]
[{"$f":"'Mein Zuhause'!$D10","v":"Hauptverteiler"},{"$f":"Stammdaten!$D5","v":"Subverteiler 1"},{"$f":"SUMIF($A$6:$A$42,$B7,Komfort!C$11:C$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Komfort!D$11:D$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Komfort!E$11:E$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Komfort!F$11:F$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B7,Komfort!$G$11:$G$44)","v":0}]
[{"$f":"'Mein Zuhause'!$D11","v":"Hauptverteiler"},{"$f":"Stammdaten!$D6","v":"Subverteiler 2"},{"$f":"SUMIF($A$6:$A$42,$B8,Komfort!C$11:C$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Komfort!D$11:D$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Komfort!E$11:E$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Komfort!F$11:F$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B8,Komfort!$G$11:$G$44)","v":0}]
[{"$f":"'Mein Zuhause'!$D12","v":"Hauptverteiler"},{"$f":"Stammdaten!$D7","v":"Subverteiler 3"},{"$f":"SUMIF($A$6:$A$42,$B9,Komfort!C$11:C$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Komfort!D$11:D$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Komfort!E$11:E$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Komfort!F$11:F$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B9,Komfort!$G$11:$G$44)","v":0}]
[{"$f":"'Mein Zuhause'!$D13","v":"Hauptverteiler"},{"$f":"Stammdaten!$D8","v":"Subverteiler 4"},{"$f":"SUMIF($A$6:$A$42,$B10,Komfort!C$11:C$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Komfort!D$11:D$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Komfort!E$11:E$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Komfort!F$11:F$45)","v":0},{"$f":"SUMIF($A$6:$A$42,$B10,Komfort!$G$11:$G$44)","v":0}]
[{"$f":"'Mein Zuhause'!$D14","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D15","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D16","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D17","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D18","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D19","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D20","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D21","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D22","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D23","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D24","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D25","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D26","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D27","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D28","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D29","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D30","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D31","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D32","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D33","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D34","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D35","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D36","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D37","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D38","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D39","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D40","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D41","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D42","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D43","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D44","v":"Hauptverteiler"}]
[{"$f":"'Mein Zuhause'!$D45","v":"Hauptverteiler"}]

{"sheet":"Berechnung AnalogDigitalmodule","index":16,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["DIGITAL IN"]
["Verteileraufteilung"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Stammdaten!G20","v":"HC-D1180"}]
[null,"Sicherheit",null,null,"Beschattung",null,"Beleuchtung BWMs",null,"Komfort","Multimedia",null,{"$f":"Stammdaten!I20","v":8}]
["Summen",{"$f":"Sicherheit!E10","v":"Rauchmelder"},{"$f":"Sicherheit!R11","v":"Elektr. Haustür"},{"$f":"Sicherheit!S11","v":"Garagentor"},{"$f":"'Beschatttung und Fenster'!I12","v":"Fensterkontakt"},{"$f":"'Beschatttung und Fenster'!H12","v":"Velux"},{"$f":"Beleuchtung!J12","v":"24V"},{"$f":"Beleuchtung!K12","v":"230V"},{"$f":"Komfort!G9","v":"Szenentaster"},{"$f":"Mulitmedia!E12","v":"Taster"},null,{"$f":"Stammdaten!H20","v":2.6},"TEs"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7:L11)","v":0}]
[{"$f":"Stammdaten!$D$4","v":"Hauptverteiler"},{"$f":"'Berechnung Sicherheit'!E6","v":0},{"$f":"'Berechnung Sicherheit'!O6","v":0},{"$f":"'Berechnung Sicherheit'!P6","v":0},{"$f":"'Berechnung Beschattung'!I8","v":0},{"$f":"'Berechnung Beschattung'!H8*2","v":0},{"$f":"'Berechnung Beleuchtung'!H8","v":0},{"$f":"'Berechnung Beleuchtung'!I8","v":0},{"$f":"'Berechnung Komfort'!G6","v":0},{"$f":"'Berechnung Multi'!H6*4","v":0},null,{"$f":"ROUNDUP(SUM(B7:J7)/$L$4,0)","v":0},{"$f":"L7*$L$5","v":0}]
[{"$f":"Stammdaten!$D$5","v":"Subverteiler 1"},{"$f":"'Berechnung Sicherheit'!E7","v":0},{"$f":"'Berechnung Sicherheit'!O7","v":0},{"$f":"'Berechnung Sicherheit'!P7","v":0},{"$f":"'Berechnung Beschattung'!I9","v":0},{"$f":"'Berechnung Beschattung'!H9*2","v":0},{"$f":"'Berechnung Beleuchtung'!H9","v":0},{"$f":"'Berechnung Beleuchtung'!I9","v":0},{"$f":"'Berechnung Komfort'!G7","v":0},{"$f":"'Berechnung Multi'!H7*4","v":0},null,{"$f":"ROUNDUP(SUM(B8:J8)/$L$4,0)","v":0},{"$f":"L8*$L$5","v":0}]
[{"$f":"Stammdaten!$D$6","v":"Subverteiler 2"},{"$f":"'Berechnung Sicherheit'!E8","v":0},{"$f":"'Berechnung Sicherheit'!O8","v":0},{"$f":"'Berechnung Sicherheit'!P8","v":0},{"$f":"'Berechnung Beschattung'!I10","v":0},{"$f":"'Berechnung Beschattung'!H10*2","v":0},{"$f":"'Berechnung Beleuchtung'!H10","v":0},{"$f":"'Berechnung Beleuchtung'!I10","v":0},{"$f":"'Berechnung Komfort'!G8","v":0},{"$f":"'Berechnung Multi'!H8*4","v":0},null,0,0]
[{"$f":"Stammdaten!$D$7","v":"Subverteiler 3"},{"$f":"'Berechnung Sicherheit'!E9","v":0},{"$f":"'Berechnung Sicherheit'!O9","v":0},{"$f":"'Berechnung Sicherheit'!P9","v":0},{"$f":"'Berechnung Beschattung'!I11","v":0},{"$f":"'Berechnung Beschattung'!H11*2","v":0},{"$f":"'Berechnung Beleuchtung'!H11","v":0},{"$f":"'Berechnung Beleuchtung'!I11","v":0},{"$f":"'Berechnung Komfort'!G9","v":0},{"$f":"'Berechnung Multi'!H9*4","v":0},null,0,0]
[{"$f":"Stammdaten!$D$8","v":"Subverteiler 4"},{"$f":"'Berechnung Sicherheit'!E10","v":0},{"$f":"'Berechnung Sicherheit'!O10","v":0},{"$f":"'Berechnung Sicherheit'!P10","v":0},{"$f":"'Berechnung Beschattung'!I12","v":0},{"$f":"'Berechnung Beschattung'!H12*2","v":0},{"$f":"'Berechnung Beleuchtung'!H12","v":0},{"$f":"'Berechnung Beleuchtung'!I12","v":0},{"$f":"'Berechnung Komfort'!G10","v":0},{"$f":"'Berechnung Multi'!H10*4","v":0},null,0,0]
[]
[]
[]
[]
[]
[]
["DIGITAL OUT"]
["Verteileraufteilung"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Stammdaten!G21","v":"HC-D1208"}]
[null,"Sicherheit",null,null,"Komfort",null,null,null,null,null,null,{"$f":"Stammdaten!I21","v":8}]
["Summen",{"$f":"Sicherheit!E10","v":"Rauchmelder"},{"$f":"Sicherheit!R11","v":"Elektr. Haustür"},{"$f":"Sicherheit!S11","v":"Garagentor"},{"$f":"'Berechnung Komfort'!C4","v":"Bad/WC Lüfter"},{"$f":"'Berechnung Komfort'!D4","v":"Steckdosen geschalten"},{"$f":"'Berechnung Komfort'!E4","v":"Badheizkörper elektrisch"},null,null,null,null,{"$f":"Stammdaten!H21","v":2.6}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L24:L28)","v":0}]
[{"$f":"Stammdaten!$D$4","v":"Hauptverteiler"},null,{"$f":"'Berechnung Sicherheit'!O6","v":0},{"$f":"'Berechnung Sicherheit'!P6*2","v":0},{"$f":"'Berechnung Komfort'!C6","v":0},{"$f":"'Berechnung Komfort'!D6","v":0},{"$f":"'Berechnung Komfort'!E6","v":0},null,null,null,null,{"$f":"ROUNDUP(SUM(B24:J24)/$L$21,0)","v":0},{"$f":"L24*$L$22","v":0}]
[{"$f":"Stammdaten!$D$5","v":"Subverteiler 1"},null,{"$f":"'Berechnung Sicherheit'!O7","v":0},{"$f":"'Berechnung Sicherheit'!P7*2","v":0},{"$f":"'Berechnung Komfort'!C7","v":0},{"$f":"'Berechnung Komfort'!D7","v":0},{"$f":"'Berechnung Komfort'!E7","v":0},null,null,null,null,{"$f":"ROUNDUP(SUM(B25:J25)/$L$21,0)","v":0},{"$f":"L25*$L$22","v":0}]
[{"$f":"Stammdaten!$D$6","v":"Subverteiler 2"},null,{"$f":"'Berechnung Sicherheit'!O8","v":0},{"$f":"'Berechnung Sicherheit'!P8*2","v":0},{"$f":"'Berechnung Komfort'!C8","v":0},{"$f":"'Berechnung Komfort'!D8","v":0},{"$f":"'Berechnung Komfort'!E8","v":0},null,null,null,null,0,0]
[{"$f":"Stammdaten!$D$7","v":"Subverteiler 3"},null,{"$f":"'Berechnung Sicherheit'!O9","v":0},{"$f":"'Berechnung Sicherheit'!P9*2","v":0},{"$f":"'Berechnung Komfort'!C9","v":0},{"$f":"'Berechnung Komfort'!D9","v":0},{"$f":"'Berechnung Komfort'!E9","v":0},null,null,null,null,0,0]
[{"$f":"Stammdaten!$D$8","v":"Subverteiler 4"},null,{"$f":"'Berechnung Sicherheit'!O10","v":0},{"$f":"'Berechnung Sicherheit'!P10*2","v":0},{"$f":"'Berechnung Komfort'!C10","v":0},{"$f":"'Berechnung Komfort'!D10","v":0},{"$f":"'Berechnung Komfort'!E10","v":0},null,null,null,null,0,0]
[]
[]
[]
["PT 1000"]
["Verteileraufteilung",null,null,null,null,null,null,null,null,null,null,"PT1000"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Stammdaten!G24","v":"HC-A1240"}]
[null,"Komfort",null,null,null,null,null,null,null,null,null,{"$f":"Stammdaten!I24","v":4}]
["Summen",{"$f":"Komfort!F9","v":"Zusätzliche Temperatur-\nmessung"},null,null,null,null,null,null,null,null,null,{"$f":"Stammdaten!H24","v":2.6}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L38:L42)","v":0}]
[{"$f":"Stammdaten!$D$4","v":"Hauptverteiler"},{"$f":"'Berechnung Komfort'!F6","v":0},null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(SUM(B38:J38)/$L$21,0)","v":0},{"$f":"L38*$L$36","v":0}]
[{"$f":"Stammdaten!$D$5","v":"Subverteiler 1"},{"$f":"'Berechnung Komfort'!F7","v":0},null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(SUM(B39:J39)/$L$21,0)","v":0},{"$f":"L39*$L$36","v":0}]
[{"$f":"Stammdaten!$D$6","v":"Subverteiler 2"},{"$f":"'Berechnung Komfort'!F8","v":0},null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"Stammdaten!$D$7","v":"Subverteiler 3"},{"$f":"'Berechnung Komfort'!F9","v":0},null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"Stammdaten!$D$8","v":"Subverteiler 4"},{"$f":"'Berechnung Komfort'!F10","v":0},null,null,null,null,null,null,null,null,null,0,0]

{"sheet":"Ihr evon Smart Home","index":17,"n_rows":115,"n_cols":9,"rows_kept":115,"cut":false,"hidden":false,"merged":[[1,1,1,4],[96,1,96,3],[100,1,100,3],[101,1,101,3],[107,1,107,3],[103,1,103,3],[104,1,104,3],[102,1,102,3],[105,1,105,3],[106,1,106,3],[91,1,91,3],[92,1,92,3],[93,1,93,3],[94,1,94,3],[95,1,95,3],[90,1,90,3],[79,1,79,3],[80,1,80,3],[81,1,81,3],[82,1,82,3],[83,1,83,3],[84,1,84,3],[85,1,85,3],[86,1,86,3],[87,1,87,3],[88,1,88,3],[89,1,89,3],[78,1,78,3],[65,1,65,3],[66,1,66,3],[67,1,67,3],[68,1,68,3],[69,1,69,3],[70,1,70,3],[71,1,71,3],[72,1,72,3],[73,1,73,3],[75,1,75,3],[77,1,77,3],[74,1,74,3],[76,1,76,3],[64,1,64,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[55,1,55,3],[56,1,56,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[61,1,61,3],[62,1,62,3],[63,1,63,3],[54,1,54,3],[57,1,57,3],[50,1,50,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[42,1,42,3],[43,1,43,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[34,1,34,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[109,7,109,8],[114,1,114,8],[4,1,4,7],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[22,1,22,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3]]}
[]
[null,{"$f":"\"Zusammenfassung - \" &Start!$C$19","v":"Zusammenfassung - "}]
[null,{"$f":"\"für \"&Start!$C$20","v":"für "}]
[]
[null,"Wir sehen Smart Home als Herausforderung, die zwei Aufgaben erfüllen muss: Smart Home muss Ihr Leben einfacher machen und Smart Home darf nicht aufdringlich sein. Beides erreichen wir durch die Kombination moderner, vielfach erprobter Hardware und unserer App, die es Ihnen ganz ohne Programmierung ermöglicht, Ihr Zuhause an Ihre Wünsche anzupassen."]
[]
[]
[null,"Artikel",null,null,"Art.Nr.","Anzahl","Korrektur","Preis","Gesamt"]
[null,"Controller"]
[null,"evon Smart Home Controller mit SD-Karte (iX800SD-01)",null,null,"HC-iX800SD",{"$f":"IF(SUM(Mulitmedia!C13,Mulitmedia!D13*2)<5,1,0)+G10","v":1},null,594,{"$f":"IF(F10>0,H10*F10,\"\")","v":594}]
[null,"evon Smart Home Controller mit SD-Karte (iX840SD-00)",null,null,"HC-iX840SD",{"$f":"IF(SUM(Mulitmedia!C13,Mulitmedia!D13*2)>5,1,0)+G11","v":0},null,930,{"$f":"IF(F11>0,H11*F11,\"\")","v":""}]
[null,"Beschattungsmodule",null,null,null,null,null,null,{"$f":"IF(F12>0,H12*F12,\"\")","v":""}]
[null,"Beschattung Standard  (Blind 1144)",null,null,"HC-B1144",{"$f":"'Berechnung Beschattung'!P7+G13","v":0},null,216,""]
[null,"Beschattung mit Wendemotor (Blind 1244)",null,null,"HC-B1244",{"$f":"'Berechnung Beschattung'!K7+G14","v":0},null,216,""]
[null,"Beschattung für Schlotterer (Blind 1344)",null,null,"HC-B1344",{"$f":"'Berechnung Beschattung'!L7+G15","v":0},null,222,""]
[null,"Lichtmodule",null,null,null,null,null,null,""]
[null,"Lichtkreis mit externen Lastrelais (Light 1144)",null,null,"HC-L1144",{"$f":"'Berechnung Beleuchtung'!J7+G17","v":0},null,216,""]
[null,"Lichtkreis mit integriertem Lastrelais (Light 1244)",null,null,"HC-L1244",{"$f":"'Berechnung Beleuchtung'!K7+G18","v":0},null,255,""]
[null,"Lichtkreis dimmbar 0-10V 2 Kanal (Light 1424)",null,null,"HC-L1424",{"$f":"ROUNDUP('Berechnung Beleuchtung'!L7,0)+G19","v":0},null,255,""]
[null,"Lichtkreis dimmbar 0-10V 4 Kanal (Light 1544)",null,null,"HC-L1544",{"$f":"ROUNDUP('Berechnung Beleuchtung'!M7,0)+G20","v":0},null,312,""]
[null,"Lichtkreis LED  4 Kanal weiss / 1 Kanal RGBW (Light 1644)",null,null,"HC-L1644",{"$f":"'Berechnung Beleuchtung'!O7+G21","v":0},null,369,""]
[null,"Lichtkreis DALI 2 Kanal - pro Linie 16 DALI Leuchten (Light 1842)",null,null,"HC-L1842",{"$f":"'Berechnung Beleuchtung'!N7+G22","v":0},null,423,""]
[null,"Einzelraumregelmodule",null,null,null,null,null,null,""]
[null,"Heiz-/Kühlkreis für Raumbediengerät C110X ",null,null,"HC-C1144 ",{"$f":"ROUNDUP(IF(Raumregelungen!C12=\"nur Temperatursensor\",0,'Berechnung Raumreg'!G7),0)+G24","v":0},null,279,""]
[null,"Heiz-/Kühlkreis für Raumtemperatursensor C1010",null,null,"HC-C1244 ",{"$f":"ROUNDUP(IF(Raumregelungen!C12=\"nur Temperatursensor\",'Berechnung Raumreg'!G7,0),0)+G25","v":0},null,306,""]
[null,"Raumbediengeräte",null,null,null,null,null,null,""]
[null,"Raumbediengerät C110X",null,null,"HC-C110X",{"$f":"IF(Raumregelungen!C12=\"Eco\",Raumregelungen!D12,0)+G27","v":0},null,93,""]
[null,"Sensor Touch Raumbediengerät",null,null,"HC-C1109",{"$f":"IF(Raumregelungen!C12=\"Touch\",Raumregelungen!D12,0)+G28","v":0},null,150,""]
[null,"Raumtemperatursensor PT1000  C1010",null,null,"HC-C1010",{"$f":"IF(Raumregelungen!C12=\"nur Temperatursensor\",Raumregelungen!D12,0)+G29","v":0},null,33,""]
[null,"Digitalmodule",null,null,null,null,null,null,""]
[null,"Digitaleingang  (Digital 1180)",null,null,"HC-D1180",{"$f":"'Berechnung AnalogDigitalmodule'!L6+'Ihr evon Smart Home'!G31","v":0},null,222,""]
[null,"Digitalausgang  (Digital 1208)",null,null,"HC-D1208",{"$f":"'Berechnung AnalogDigitalmodule'!L23+'Ihr evon Smart Home'!G32","v":0},null,222,""]
[null,"Digital Ein/Ausgang  (Digital 1344)",null,null,"HC-D1344",{"$f":"G33","v":0},null,222,""]
[null,"Analogmodule",null,null,null,null,null,null,""]
[null,"Analogein-/ausgang 0-10V (Analog 1144)",null,null,"HC-A1144",{"$f":"G35","v":0},null,273,""]
[null,"Analogeingang PT1000 (Analog 1240)",null,null,"HC-A1240",{"$f":"'Berechnung AnalogDigitalmodule'!L37+G36","v":0},null,255,""]
[null,"Analogeingang PT1000 od. KTY (Analog 1380)",null,null,"HC-A1380",{"$f":"G37","v":0},null,363,""]
[null,"Technologiemodule",null,null,null,null,null,null,""]
[null,"Soundmodul 4 x 10W",null,null,"HC-TS410",{"$f":"ROUNDUP(SUM(Mulitmedia!C13,Mulitmedia!D13*2)/4,0)+G39","v":0},null,660,""]
[null,"Auxuiliary 2 x RS485 Erweiterung",null,null,"HC-TA200",{"$f":"IF(SUM(F64:F71)>0,1,0)+G40","v":0},null,288,""]
[null,"Erweiterungsmodul techCom abgehend",null,null,"HC-S2200",{"$f":"G41","v":0},null,72,""]
[null,"Erweiterungsmodul techCom eingehend",null,null,"HC-S2300",{"$f":"G42","v":0},null,72,""]
[null,"Verbindungskabel techCOM 1,5m",null,null,"HC-S2400",{"$f":"G43","v":0},null,21,""]
[null,"Netzwerk - Schnittstellenerweiterung 1fach",null,null,"HC-TE100",{"$f":"G44","v":0},null,177,""]
[null,"Systemmodule",null,null,null,null,null,null,""]
[null,"24V Schaltnetzteil 100W",null,null,"HC-S100W",{"$f":"1+G46","v":1},null,120,120]
[null,"Busabschluss smartCOM",null,null,"HC-S1100",{"$f":"SUM('Berechnung TEs'!G3:G7)+G47","v":2},null,42,84]
[null,"Busumsetzer smartCOM",null,null,"HC-S1200",{"$f":"SUM('Berechnung TEs'!D3:D7)+G48","v":0},null,42,""]
[null,null,null,null,null,"Summe Module",null,null,{"$f":"SUM(I10:I48)","v":798}]
[]
[null,"Artikel",null,null,"Art.Nr.","Menge",null,"Preis","Summe"]
[null,"Erweiterungen"]
[null,"evon Smart Home Wetterstation",null,null,"HC-WSLRW",{"$f":"'Beschatttung und Fenster'!C9+G53","v":0},null,387,{"$f":"IF(F53>0,H53*F53,\"\")","v":""}]
[null,"evon Smart Home Türsprechanlage",null,null,"HC-SiPB10",{"$f":"Sicherheit!Q12+G54","v":0},null,1149,{"$f":"IF(F54>0,H54*F54,\"\")","v":""}]
[null,"evon Smart Home IP Kamera Bullet",null,null,"HC-CAM12",{"$f":"Sicherheit!D12+G55","v":0},null,234,""]
[null,"evon Smart Home AP Gehäuse für Bullet Camera",null,null,"HC-BCAMZ01",{"$f":"F55+G56","v":0},null,30,""]
[null,"evon Smart Home IP Kamera Dome",null,null,"HC-DCAM20",{"$f":"Sicherheit!C12","v":0},null,234,""]
[null,"evon Smart Home AP Gehäuse für Dome Camera",null,null,"HC-DCAMZ01",{"$f":"F57+G58","v":0},null,30,{"$f":"IF(F58>0,H58*F58,\"\")","v":""}]
[null," U::LUX Schalter mit Datendose",null,null,"HC-ULUX",{"$f":"G59","v":0},null,297,""]
[null," U::LUX Schalter Erweiterung Temperatur",null,null,"HC-ULUXEXT1",{"$f":"G60","v":0},null,51,""]
[null," U::LUX Schalter Erweiterung Temperatur + Feuchte",null,null,"HC-ULUXEXT2",{"$f":"G61","v":0},null,66,""]
[null," U::LUX Schalter Erweiterung Temperatur + Feuchte + BWM",null,null,"HC-ULUXEXT3",{"$f":"G62","v":0},null,90,""]
[null," U::LUX Schalter Erweiterung Temperatur + Feuchte + CO2 Konzentration",null,null,"HC-ULUXEXT4",{"$f":"G63","v":0},null,189,""]
[null,"Fingerprint Zutritt AP",null,null,"HC-KEYAP",{"$f":"Sicherheit!K12+G64","v":0},null,375,""]
[null,"Fingerprint Zutritt AP RFID",null,null,"HC-KEYAPR",{"$f":"Sicherheit!L12+G65","v":0},null,549,""]
[null,"Fingerprint Zutritt UP",null,null,"HC-KEYUPE",{"$f":"Sicherheit!I12+G66","v":0},null,513,""]
[null,"Fingerprint Zutritt UP RFID",null,null,"HC-KEYUPER",{"$f":"Sicherheit!J12+G67","v":0},null,678,""]
[null,"Fingerprint Zutritt UP f. Sprechanlagenintegration",null,null,"HC-KEYUPI",{"$f":"Sicherheit!M12+G68","v":0},null,492,""]
[null,"Fingerprint Zutritt UP RFID f. Sprechanlagenintegration",null,null,"HC-KEYUPIR",{"$f":"Sicherheit!N12+G69","v":0},null,654,""]
[null,"Fingerprint Zutritt Integra",null,null,"HC-KEYIN",{"$f":"Sicherheit!O12+G70","v":0},null,381,""]
[null,"Fingerprint Zutritt Integra RFID",null,null,"HC-KEYINR",{"$f":"Sicherheit!P12+G71","v":0},null,558,""]
[null,"Switch 6 Port 10/100/1000T (4 x PoE)",null,null,"HC-SPOE42",{"$f":"IF(Sicherheit!$G$8=\"Ja\",IF(AND(SUM(Sicherheit!$C$12:$D$12)<=6,SUM(Sicherheit!$C$12:$D$12)>1),1,0),0)+G72","v":0},null,135,""]
[null,"Switch 9 Port 10/100/1000T (8 x PoE)",null,null,"HC-SPOE81",{"$f":"IF(Sicherheit!$G$8=\"Ja\",IF(SUM(Sicherheit!$C$12:$D$12)>6,1,0),0)+G73","v":0},null,245,""]
[null,"PoE Injector 1 Port",null,null,"HC-IPOE1",{"$f":"IF(Sicherheit!$G$8=\"Ja\",IF(SUM(Sicherheit!$C$12:$D$12)=1,1,0),0)+G74","v":0},null,54,""]
[null,"Schlotter Funk Erweiterung (15 Antriebe)",null,null,"HC-BRC15",{"$f":"G75","v":0},null,348,""]
[null,"Zubehör",null,null,null,null,null,null,""]
[null,"Universaldimmer 400W",null,null,"HC-DIM400",{"$f":"ROUNDUP(Beleuchtung!H13,0)+G77","v":0},null,63,{"$f":"IF(F77>0,H77*F77,\"\")","v":""}]
[null,"Dekorblende reinweiß RAL9010 (Kunststoff) für alle HC-KEYUP-Modelle",null,null,"HC-KEYZ01",{"$f":"G78","v":0},null,7.5,""]
[null,"Dekorblende aluminiumfarbig RAL9006 (Kunststoff) für alle HC-KEYUPModelle",null,null,"HC-KEYZ02",0,null,7.5,""]
[null,"Dekorblende anthrazitfarbig (Kunststoff) für alle HC-KEYUP-Modelle",null,null,"HC-KEYZ03",0,null,7.5,""]
[null,"Dekorblende Edelstahl für alle HC-KEYUP-Modelle",null,null,"HC-KEYZ04",0,null,54,""]
[null,"Sprechanlagen Einbaumodul, passend zu Sprechanlage HC-SIPB10-00",null,null,"HC-KEYZ05",0,null,111,""]
[null,"Wetterschutz für alle HC-KEYAP-Modelle",null,null,"HC-KEYZ06",0,null,63,""]
[null,"RFID-Schlüsselanhänger",null,null,"HC-KEYZ07",{"$f":"IF(SUM(F65+F67+F69+F71)>0,2,0)+G84","v":0},null,8.4,""]
[null,"RFID-Zutrittskarte",null,null,"HC-KEYZ08",{"$f":"G85","v":0},null,7.5,""]
[null,"Dekorblende Edelstahl für HC-KEYIN-00",null,null,"HC-KEYZ09",{"$f":"F70+G86","v":0},null,9.6,""]
[null,"Dekorblende Edelstahl für HC-KEYINR-00",null,null,"HC-KEYZ10 ",{"$f":"F71+G87","v":0},null,12.6,""]
[null,"Aufputzgehäuse für Sprechanlage HC-SiPB10-00",null,null,"HC-SIPZ01",{"$f":"G88","v":0},null,66,""]
[null,"Aufputzrahmen für Sprechanlage HC-SiPB10-00",null,null,"HC-SIPZ02",0,null,78,""]
[null,"Unterputzgehäuse 1fach für Sprechanlage HC-SiPB10-00",null,null,"HC-SIPZ03",{"$f":"F54+G90","v":0},null,25.5,""]
[null,"Unterputzrahmen 1fach für Sprechanlage HC-SiPB10-00",null,null,"HC-SIPZ04",{"$f":"F54+G91","v":0},null,78,""]
[null,"Unterputzrahmen 2fach für Sprechanlage HC-SiPB10-00",null,null,"HC-SIPZ05",0,null,105,""]
[null,"Unterputzgehäuse 2fach für Sprechanlage HC-SiPB10-00",null,null,"HC-SIPZ06",0,null,33,""]
[null,"evon Smart Home; WLAN Inbetriebnahme Accesspoint",null,null,"HC-WIFIAP",0,null,39,""]
[null,"Verbindungsstecker techCOM (Ersatzteil)",null,null,"HC-S2100",0,null,6.3,""]
[null,"Verkabelungsbrücken DC + (100 Anschlusspunkte)",null,null,"HC-CABP",{"$f":"1+G96","v":1},null,45,45]
[null,"Verkabelungsbrücken DC - (100 Anschlusspunkte)",null,null,"HC-CABM",{"$f":"1+G97","v":1},null,45,45]
[null,null,null,null,null,"Summe Zubehör",null,null,{"$f":"SUM(I53:I97)","v":90}]
[]
[]
[null,"Artikel",null,null,"Art.Nr.","Menge",null,"Preis","Summe"]
[null,"Zusatzpakete"]
[null,"Frei konfigurierbare Szenen um Ihr Smart Home an Ihre Bedürfnisse anzupassen - einfach übers App",null,null,null,"unbegrenzt",null,0,0]
[null,"App (iOS oder Android)",null,null,null,"unbegrenzt",null,0,0]
[null,"Benachrichtigungen aufs Handy",null,null,null,"unbegrenzt",null,0,0]
[null,"Laufende Software Updates mit Optimierungen, neuen Funktionen und neuen Anbindungen und Integrationen",null,null,null,"unbegrenzt",null,0,0]
[null,"Fernzugriff (Sie entscheiden selbst ob und wann)*",null,null,null,"unbegrenzt",null,0,0]
[null,"Automatisch generierbare Dokumentation",null,null,null,"unbegrenzt",null,0,0]
[null,null,null,null,null,"Summe Zusatzpakete",null,null,{"$f":"SUM(I102:I108)","v":0}]
[null,null,null,null,null,"Gesamtsumme",null,{"$f":"I49+I98+I109","v":888}]
[]
[]
[null,"*) derzeit Beta Version"]
[]
[null,"Preise gültig ab 1. April 2019. Nicht kartellierte unverbindlich empfohlenen Verkaufspreise inkl. der gesetzlich vorgeschriebenen MWSt. Es gelten unsere allgemeinen Vertrags- und Lieferbedingungen. Beachten Sie bitte bei Verwendung unserer Materialien die für den jeweiligen Einsatzbereich gültigen ÖNORMEN, Einbauvorschriften und Bauordnungen sowie unsere Werknormen und Verlegeanleitungen. Technische Änderungen vorbehalten. Alle Angaben ohne Gewähr. Detailierte technische Informationen erhalten Sie unter http://www.evon-smarthome.com"]

{"sheet":"Ihr Schaltschrank","index":18,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,1,13,3],[14,1,14,3],[4,1,4,7],[11,1,11,3],[12,1,12,3],[8,1,8,3],[9,1,9,3],[10,1,10,3]]}
[]
[null,{"$f":"\"Schaltschrankplanung \" &Start!$C$19","v":"Schaltschrankplanung "}]
[null,{"$f":"\"für \"&Start!$C$20","v":"für "}]
[]
[null,"Wir sehen Smart Home als Herausforderung, die zwei Aufgaben erfüllen muss: Smart Home muss Ihr Leben einfacher machen und Smart Home darf nicht aufdringlich sein. Beides erreichen wir durch die Kombination moderner, vielfach erprobter Hardware und unserer App, die es Ihnen ganz ohne Programmierung ermöglicht, Ihr Zuhause an Ihre Wünsche anzupassen."]
[]
[]
[null,null,null,null,null,"für evon Smart Home Komponenten"]
[null,"Artikel",null,null,"Breite (TE)","nötige Breite (TE)","Reihen"]
[null,"Schaltschrankplanung"]
[null,{"$f":"Stammdaten!D4","v":"Hauptverteiler"},null,null,35,{"$f":"'Berechnung TEs'!C3","v":14.3},{"$f":"'Berechnung TEs'!B3","v":0.40857142857142859}]
[null,{"$f":"Stammdaten!D5","v":"Subverteiler 1"},null,null,35,{"$f":"'Berechnung TEs'!C4","v":0},{"$f":"'Berechnung TEs'!B4","v":0}]
[null,{"$f":"Stammdaten!D6","v":"Subverteiler 2"},null,null,35,{"$f":"'Berechnung TEs'!C5","v":0},{"$f":"'Berechnung TEs'!B5","v":0}]
[null,{"$f":"Stammdaten!D7","v":"Subverteiler 3"},null,null,35,{"$f":"'Berechnung TEs'!C6","v":0},{"$f":"'Berechnung TEs'!B6","v":0}]
[null,{"$f":"Stammdaten!D8","v":"Subverteiler 4"},null,null,35,{"$f":"'Berechnung TEs'!C7","v":0},{"$f":"'Berechnung TEs'!B7","v":0}]

{"sheet":"Schaltschrank","index":19,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":true,"merged":[[15,0,15,2],[13,0,13,2],[9,0,9,2],[10,0,10,2],[14,0,14,2],[11,0,11,2],[12,0,12,2],[1,0,1,2],[4,0,4,2],[3,0,3,2],[8,0,8,2],[2,0,2,2]]}
[]
["Artikel",null,null,"Art.Nr.","Menge","Preis","Summe"]
["Schaltkasten"]
[{"$f":"ROUNDUP('Berechnungen Schaltschrankgröße'!B54,0)&\" Reihen\"","v":{"$error":"#REF!"}},null,null,null,1,0,{"$f":"F4*E4","v":0}]
["Klemmen"]
["Reihenklemmen Lastteil - Phoenix PTI 2,5-PE/L/N",null,null,3213950,{"$f":"'Berechungen Schaltschrankmateri'!C13","v":6.9},0,{"$f":"F6*E6","v":0}]
["Reihenklemmen Taster - Weidmüller PRV8",null,null,"PRV 8 BL 35X7.5 RT/W",{"$f":"'Berechungen Schaltschrankmateri'!C14","v":0},0,{"$f":"F7*E7","v":0}]
["Reihenklemmen 24V - Weidmüller PPV8",null,null,"PPV 8 GR 35X15 DGR",{"$f":"'Berechungen Schaltschrankmateri'!C15","v":0},null,{"$f":"F8*E8","v":0}]
["Koppelrelais"]
["230V auf 24V - Finder ?",null,null,"?",{"$f":"'Berechungen Schaltschrankmateri'!B17","v":0},0,{"$f":"F10*E10","v":0}]
["24V auf 230V - Finder ?",null,null,"?",{"$f":"'Berechungen Schaltschrankmateri'!B18","v":0},0,{"$f":"F11*E11","v":0}]
["Leitungsschutzschalter"]
[null,null,null,"?",{"$f":"'Berechungen Schaltschrankmateri'!B20","v":0},0,{"$f":"F13*E13","v":0}]
[null,null,null,"?",{"$f":"'Berechungen Schaltschrankmateri'!B21","v":0},0,{"$f":"F14*E14","v":0}]
[null,null,null,null,{"$f":"'Berechungen Schaltschrankmateri'!C19","v":0},null,{"$f":"F15*E15","v":0}]
[null,null,null,null,null,null,0]

{"sheet":"Zubehör","index":20,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[[6,0,6,2],[7,0,7,2],[3,0,3,2],[5,0,5,2],[1,0,1,2],[2,0,2,2],[4,0,4,2]]}
[]
["Artikel",null,null,"Art.Nr.","Menge","Preis","Summe"]
["Taster"]
["Berker S1 - 4 fach Taster oder …",null,null,null,{"$f":"Taster!G34","v":0},0,{"$f":"F4*E4","v":0}]
["Rauchmelder"]
["z.B XY",null,null,null,{"$f":"Sicherheit!E12","v":0},0,{"$f":"F6*E6","v":0}]
[null,null,null,null,{"$f":"'Berechungen Schaltschrankmateri'!C19","v":0},null,{"$f":"F7*E7","v":0}]
[null,null,null,null,null,null,{"$f":"F8*E8","v":0}]

{"sheet":"Sicherungskreise","index":21,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,"Steckdosen","Licht","Beschattung","Kraftsteckdosen","Backofen ","Ceranfeld","Geschirrspüler","Elektroauto","Heizung","Heizung Steuerspannung"]
["Gesamt",{"$f":"MAX(B3:B38)","v":6},{"$f":"MAX(C3:C38)","v":6},{"$f":"MAX(D3:D38)","v":2},{"$f":"MAX(E3:E38)","v":1},1,1,1,1,1,1]
[{"$f":"IF('Mein Zuhause'!B9<>\"\",'Mein Zuhause'!B9&\" - \"&'Mein Zuhause'!C9,\"\")","v":""},1,1,1]
[{"$f":"IF('Mein Zuhause'!B10<>\"\",'Mein Zuhause'!B10&\" - \"&'Mein Zuhause'!C10,\"\")","v":""},1,1,1]
[{"$f":"IF('Mein Zuhause'!B11<>\"\",'Mein Zuhause'!B11&\" - \"&'Mein Zuhause'!C11,\"\")","v":""},1,1,1]
[{"$f":"IF('Mein Zuhause'!B12<>\"\",'Mein Zuhause'!B12&\" - \"&'Mein Zuhause'!C12,\"\")","v":""},1,1,1]
[{"$f":"IF('Mein Zuhause'!B13<>\"\",'Mein Zuhause'!B13&\" - \"&'Mein Zuhause'!C13,\"\")","v":""},1,1,1]
[{"$f":"IF('Mein Zuhause'!B14<>\"\",'Mein Zuhause'!B14&\" - \"&'Mein Zuhause'!C14,\"\")","v":""},2,2,1]
[{"$f":"IF('Mein Zuhause'!B15<>\"\",'Mein Zuhause'!B15&\" - \"&'Mein Zuhause'!C15,\"\")","v":""},2,2,1]
[{"$f":"IF('Mein Zuhause'!B16<>\"\",'Mein Zuhause'!B16&\" - \"&'Mein Zuhause'!C16,\"\")","v":""},2,2,1]
[{"$f":"IF('Mein Zuhause'!B17<>\"\",'Mein Zuhause'!B17&\" - \"&'Mein Zuhause'!C17,\"\")","v":""},2,2,1]
[{"$f":"IF('Mein Zuhause'!B18<>\"\",'Mein Zuhause'!B18&\" - \"&'Mein Zuhause'!C18,\"\")","v":""},3,3,1]
[{"$f":"IF('Mein Zuhause'!B19<>\"\",'Mein Zuhause'!B19&\" - \"&'Mein Zuhause'!C19,\"\")","v":""},3,3,1,1,null,null,null,1]
[{"$f":"IF('Mein Zuhause'!B20<>\"\",'Mein Zuhause'!B20&\" - \"&'Mein Zuhause'!C20,\"\")","v":""},4,4]
[{"$f":"IF('Mein Zuhause'!B21<>\"\",'Mein Zuhause'!B21&\" - \"&'Mein Zuhause'!C21,\"\")","v":""},4,4]
[{"$f":"IF('Mein Zuhause'!B22<>\"\",'Mein Zuhause'!B22&\" - \"&'Mein Zuhause'!C22,\"\")","v":""},5,5,2]
[{"$f":"IF('Mein Zuhause'!B23<>\"\",'Mein Zuhause'!B23&\" - \"&'Mein Zuhause'!C23,\"\")","v":""},5,5,2,null,1,1,1]
[{"$f":"IF('Mein Zuhause'!B24<>\"\",'Mein Zuhause'!B24&\" - \"&'Mein Zuhause'!C24,\"\")","v":""},5,5,2]
[{"$f":"IF('Mein Zuhause'!B25<>\"\",'Mein Zuhause'!B25&\" - \"&'Mein Zuhause'!C25,\"\")","v":""},5,5,2]
[{"$f":"IF('Mein Zuhause'!B26<>\"\",'Mein Zuhause'!B26&\" - \"&'Mein Zuhause'!C26,\"\")","v":""},6,6,2]
[{"$f":"IF('Mein Zuhause'!B27<>\"\",'Mein Zuhause'!B27&\" - \"&'Mein Zuhause'!C27,\"\")","v":""},6,6,2]
[{"$f":"IF('Mein Zuhause'!B28<>\"\",'Mein Zuhause'!B28&\" - \"&'Mein Zuhause'!C28,\"\")","v":""},6,6,2,null,null,null,null,null,1,1]
[{"$f":"IF('Mein Zuhause'!B29<>\"\",'Mein Zuhause'!B29&\" - \"&'Mein Zuhause'!C29,\"\")","v":""},6,6,2]
[{"$f":"IF('Mein Zuhause'!B30<>\"\",'Mein Zuhause'!B30&\" - \"&'Mein Zuhause'!C30,\"\")","v":""},4,4]
[{"$f":"IF('Mein Zuhause'!B31<>\"\",'Mein Zuhause'!B31&\" - \"&'Mein Zuhause'!C31,\"\")","v":""}]
[{"$f":"IF('Mein Zuhause'!B32<>\"\",'Mein Zuhause'!B32&\" - \"&'Mein Zuhause'!C32,\"\")","v":""}]
[{"$f":"IF('Mein Zuhause'!B33<>\"\",'Mein Zuhause'!B33&\" - \"&'Mein Zuhause'!C33,\"\")","v":""}]
[{"$f":"IF('Mein Zuhause'!B34<>\"\",'Mein Zuhause'!B34&\" - \"&'Mein Zuhause'!C34,\"\")","v":""}]
[{"$f":"IF('Mein Zuhause'!B35<>\"\",'Mein Zuhause'!B35&\" - \"&'Mein Zuhause'!C35,\"\")","v":""}]
[{"$f":"IF('Mein Zuhause'!B36<>\"\",'Mein Zuhause'!B36&\" - \"&'Mein Zuhause'!C36,\"\")","v":""}]
[{"$f":"IF('Mein Zuhause'!B37<>\"\",'Mein Zuhause'!B37&\" - \"&'Mein Zuhause'!C37,\"\")","v":""}]
[{"$f":"IF('Mein Zuhause'!B38<>\"\",'Mein Zuhause'!B38&\" - \"&'Mein Zuhause'!C38,\"\")","v":""}]
[{"$f":"IF('Mein Zuhause'!B39<>\"\",'Mein Zuhause'!B39&\" - \"&'Mein Zuhause'!C39,\"\")","v":""}]
[{"$f":"IF('Mein Zuhause'!B40<>\"\",'Mein Zuhause'!B40&\" - \"&'Mein Zuhause'!C40,\"\")","v":""}]
[{"$f":"IF('Mein Zuhause'!B41<>\"\",'Mein Zuhause'!B41&\" - \"&'Mein Zuhause'!C41,\"\")","v":""}]
[{"$f":"IF('Mein Zuhause'!B42<>\"\",'Mein Zuhause'!B42&\" - \"&'Mein Zuhause'!C42,\"\")","v":""}]

{"sheet":"Berechungen Schaltschrankmateri","index":22,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["TE = mm",18]
["Reserve Klemmen",0.15]
[]
[null,null,null,"TE"]
["LS C16/3N",{"$f":"Sicherungskreise!J2+Sicherungskreise!E2","v":2},null,4]
["LS C16/N",{"$f":"Sicherungskreise!F2+Sicherungskreise!G2+Sicherungskreise!H2+Sicherungskreise!K2","v":4},null,2]
["LS C13/N",{"$f":"Sicherungskreise!B2","v":6},null,2]
["LS B13/N",{"$f":"Sicherungskreise!D2+Sicherungskreise!C2+1","v":9},null,2,"inkl eigene 24 V"]
["LS mit FI"]
["FI"]
["LS C25/3N",{"$f":"Sicherungskreise!I2","v":1}]
[]
["Reihenklemmen Last",{"$f":"SUM(Beleuchtung!C13:D13)+(SUM('Beschatttung und Fenster'!C13:G13)+SUM('Beschatttung und Fenster'!C13:G13)/2)+Sicherungskreise!B2+Komfort!C10+Komfort!E10+Komfort!D10","v":6},{"$f":"B13+$B$2*B13","v":6.9},{"$f":"I13/$B$1","v":0.28888888888888892},"(230V - Licht, Steckdosen etc.)",null,null,"Breite (mm)",5.2,"Phönix","Installationsschutzleiterklemme - PTI 2,5-PE/L/N - 3213950"]
["Reihenklemmen Taster",{"$f":"ROUNDUP(Taster!G34*5/8+Sicherheit!E12/8,0)","v":0},{"$f":"B14+$B$2*B14","v":0},{"$f":"I14/$B$1","v":0.51111111111111107},null,null,null,"Breite (mm)",9.1999999999999993,"Weidmüller PRV8",null,"PRV 8 BL 35X7.5 RT/W"]
["Reihenklemmen 24V",{"$f":"ROUNDUP(Taster!E3/4/15,0)","v":0},{"$f":"B15*2","v":0},0.51111111111111107,"reserve 100%",null,null,"Breite (mm)",9.1999999999999993,"Weidmüller PPV8",null,"PPV 8 GR 35X15 DGR"]
[]
["Koppelrelais 230/24V",{"$f":"Beleuchtung!K13","v":0},null,0.86111111111111116,null,null,null,"Breite (mm)",15.5,"finder"]
["Koppelrelais 24/230V",{"$f":"SUM(Komfort!E10+Komfort!D10+Komfort!C10)","v":0},null,0.34444444444444444,null,null,null,"Breite (mm)",6.2,"finder"]

{"sheet":"Berechnungen Schaltschrankgröße","index":23,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["Schaltschrankbreite (TE)",{"$f":"'Ihr evon Smart Home'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
["evon Home Module"]
["Platzbedarf evon home module (TE)",{"$f":"'Ihr evon Smart Home'!#REF!","v":{"$error":"#REF!"}}]
["Reihen ohne Umsetzer",{"$f":"ROUNDUP('Ihr evon Smart Home'!#REF!/35,0)","v":{"$error":"#REF!"}}]
["nötige Anzahl Umsetzer",{"$f":"(B7-1)*2","v":{"$error":"#REF!"}}]
["Platzbedarf Umsetzer",{"$f":"B8*'Ihr evon Smart Home'!#REF!","v":{"$error":"#REF!"}}]
["Platzbedarf mit Umsetzer",{"$f":"B6+B9","v":{"$error":"#REF!"}}]
["Reihen",{"$f":"ROUNDUP(B10/B1,1)","v":{"$error":"#REF!"}}]
["Tatsächliche Anzahl Umsetzer",{"$f":"(ROUNDUP(B11,0)-1)*2","v":{"$error":"#REF!"}}]
["Tatsächlicher Platzbedarf (TE)",{"$f":"B6+B12*'Ihr evon Smart Home'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
["Klemmen"]
["Reihenklemmen 230V"]
["anzahl mit Reserve",{"$f":"'Berechungen Schaltschrankmateri'!C13","v":6.9},null,null,null,"Preis",2.2999999999999998,"stk","Schäke Preis"]
["TE",{"$f":"B18*'Berechungen Schaltschrankmateri'!D13","v":1.9933333333333336},null,null,null,null,{"$f":"B19*G18","v":4.5846666666666671}]
["Platzbedarf Reihen",{"$f":"B19/$B$1","v":{"$error":"#REF!"}}]
[]
["Reihenklemmen Taster",null,null,null,null,"Preis",11.36,"stk","Schäke Preis"]
["anzahl",{"$f":"'Berechungen Schaltschrankmateri'!C14","v":0},null,null,null,null,{"$f":"B23*G22","v":0}]
["TE",{"$f":"B23*'Berechungen Schaltschrankmateri'!D14","v":0}]
["Platzbedarf Reihen",{"$f":"B24/$B$1","v":{"$error":"#REF!"}}]
[]
["Reihenklemmen 24V Verteilung",null,null,null,null,"Preis",12.5,"stk","Schäke Preis"]
["anzahl",{"$f":"'Berechungen Schaltschrankmateri'!C15","v":0},null,null,null,null,{"$f":"B28*G27","v":0}]
["TE",{"$f":"B28*'Berechungen Schaltschrankmateri'!D15","v":0}]
["Platzbedarf Reihen",{"$f":"B29/$B$1","v":{"$error":"#REF!"}}]
[]
["Reihen",{"$f":"ROUNDUP(B30+B25+B20,1)","v":{"$error":"#REF!"}},"Reihen"]
["Preis Klemmen Gesamt netto EK",{"$f":"G19+G23+G28","v":4.5846666666666671}]
[]
[]
["Leistungeteil"]
["TE",{"$f":"'Berechungen Schaltschrankmateri'!B5*'Berechungen Schaltschrankmateri'!D5+'Berechungen Schaltschrankmateri'!B6*'Berechungen Schaltschrankmateri'!D6+'Berechungen Schaltschrankmateri'!B7*'Berechungen Schaltschrankmateri'!D7+'Berechungen Schaltschrankmateri'!B8*'Berechungen Schaltschrankmateri'!D8","v":46}]
["Platzbedarf Reihen",{"$f":"B37/B1","v":{"$error":"#REF!"}}]
[]
["Koppelrelais"]
["230/24V"]
["Anzahl",{"$f":"'Berechungen Schaltschrankmateri'!B17","v":0}]
["reserve"]
["TE",{"$f":"B42*'Berechungen Schaltschrankmateri'!D17","v":0}]
["Platzbedarf",{"$f":"B44/B1","v":{"$error":"#REF!"}}]
["24V/230V"]
["Anzahl",{"$f":"'Berechungen Schaltschrankmateri'!B18","v":0}]
["reserve"]
["TE",{"$f":"B47*'Berechungen Schaltschrankmateri'!D18","v":0}]
["Platzbedarf",{"$f":"B49/B6","v":{"$error":"#REF!"}}]
[]
["Reihen",{"$f":"B50+B45","v":{"$error":"#REF!"}}]
[]
["Reihen Gesamt",{"$f":"B11+B32+B52+B38","v":{"$error":"#REF!"}},"Max 7"]

{"sheet":"Berechnung TEs","index":24,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Teilungsheinheiten"]
[null,"Summe gesamt","TEs gesamt","Anzahl Busverlängerungen","Reihen ohne verlängerung","Busabschlussmodul","Busabschlussmodule","TEs ohne Busverlängerung","CPU","Netzteil","Soundmodule","HC-TA200","HC-S2200","HC-S2300","HC-TE100","Beleuchtung","Beschattung","Raumregelung","Digitale/Analoge"]
[{"$f":"Stammdaten!D4","v":"Hauptverteiler"},{"$f":"IF(H3>0,C3/'Ihr Schaltschrank'!E11,0)","v":0.40857142857142859},{"$f":"IF(H3>0,H3+F3+D3*Stammdaten!$H$33,0)","v":14.3},{"$f":"IF(H3>1,ROUNDDOWN(E3,0)*2+IF(B13>0,1,0),0)","v":0},{"$f":"IF(H3>0,H3+F3*G3,0)/'Ihr Schaltschrank'!E11","v":0.40857142857142859},{"$f":"Stammdaten!$H$34","v":1.3},{"$f":"IF(B13>0,0,1)","v":1},{"$f":"SUM(I3:AQ3)","v":13},{"$f":"'Ihr evon Smart Home'!F10*Stammdaten!H4+'Ihr evon Smart Home'!F11*Stammdaten!H5","v":7.8},{"$f":"'Ihr evon Smart Home'!F46*Stammdaten!H32","v":5.2},{"$f":"'Ihr evon Smart Home'!F39*Stammdaten!H26","v":0},{"$f":"'Ihr evon Smart Home'!F40*Stammdaten!H27","v":0},{"$f":"'Ihr evon Smart Home'!F41*Stammdaten!H28","v":0},{"$f":"'Ihr evon Smart Home'!F42*Stammdaten!H29","v":0},{"$f":"'Ihr evon Smart Home'!F44*Stammdaten!H31","v":0},{"$f":"'Berechnung Beleuchtung'!Q8","v":0},{"$f":"'Berechnung Beschattung'!O8","v":0},{"$f":"'Berechnung Raumreg'!H8","v":0},{"$f":"'Berechnung AnalogDigitalmodule'!M7+'Berechnung AnalogDigitalmodule'!M24+'Berechnung AnalogDigitalmodule'!M38","v":0}]
[{"$f":"Stammdaten!D5","v":"Subverteiler 1"},{"$f":"IF(H4>0,C4/'Ihr Schaltschrank'!E12,0)","v":0},{"$f":"IF(H4>0,H4+F4+D4*Stammdaten!$H$33,0)","v":0},{"$f":"IF(H4>1,ROUNDDOWN(E4,0)*2+1,0)","v":0},{"$f":"IF(H4>0,H4+F4*G4,0)/'Ihr Schaltschrank'!E12","v":0},{"$f":"Stammdaten!$H$34","v":1.3},1,{"$f":"SUM(I4:AQ4)","v":0},null,null,null,null,null,null,null,{"$f":"'Berechnung Beleuchtung'!Q9","v":0},{"$f":"'Berechnung Beschattung'!O9","v":0},{"$f":"'Berechnung Raumreg'!H9","v":0},{"$f":"'Berechnung AnalogDigitalmodule'!M8+'Berechnung AnalogDigitalmodule'!M25+'Berechnung AnalogDigitalmodule'!M39","v":0}]
[{"$f":"Stammdaten!D6","v":"Subverteiler 2"},{"$f":"IF(H5>0,C5/'Ihr Schaltschrank'!E13,0)","v":0},{"$f":"IF(H5>0,H5+F5+D5*Stammdaten!$H$33,0)","v":0},{"$f":"IF(H5>1,ROUNDDOWN(E5,0)*2+1+IF(G5>0,0,1),0)","v":0},{"$f":"IF(H5>0,H5+F5*G5,0)/'Ihr Schaltschrank'!E13","v":0},{"$f":"Stammdaten!$H$34","v":1.3},{"$f":"IF(H6>0,0,IF(H5>0,1,0))","v":0},0,null,null,null,null,null,null,null,{"$f":"'Berechnung Beleuchtung'!Q10","v":0},{"$f":"'Berechnung Beschattung'!O10","v":0},{"$f":"'Berechnung Raumreg'!H10","v":0},{"$f":"'Berechnung AnalogDigitalmodule'!M9+'Berechnung AnalogDigitalmodule'!M26+'Berechnung AnalogDigitalmodule'!M40","v":0}]
[{"$f":"Stammdaten!D7","v":"Subverteiler 3"},{"$f":"IF(H6>0,C6/'Ihr Schaltschrank'!E14,0)","v":0},{"$f":"IF(H6>0,H6+F6+D6*Stammdaten!$H$33,0)","v":0},{"$f":"IF(H6>1,ROUNDDOWN(E6,0)*2+1+IF(G6>0,0,1),0)","v":0},{"$f":"IF(H6>0,H6+F6*G6,0)/'Ihr Schaltschrank'!E14","v":0},{"$f":"Stammdaten!$H$34","v":1.3},{"$f":"IF(H7=0,IF(H6>0,1,0),0)","v":0},0,null,null,null,null,null,null,null,{"$f":"'Berechnung Beleuchtung'!Q11","v":0},{"$f":"'Berechnung Beschattung'!O11","v":0},{"$f":"'Berechnung Raumreg'!H11","v":0},{"$f":"'Berechnung AnalogDigitalmodule'!M10+'Berechnung AnalogDigitalmodule'!M27+'Berechnung AnalogDigitalmodule'!M41","v":0}]
[{"$f":"Stammdaten!D8","v":"Subverteiler 4"},{"$f":"IF(H7>0,C7/'Ihr Schaltschrank'!E15,0)","v":0},{"$f":"IF(H7>0,H7+F7+D7*Stammdaten!$H$33,0)","v":0},{"$f":"IF(H7>1,ROUNDDOWN(E7,0)*2+1+IF(G7>0,0,1),0)","v":0},{"$f":"IF(H7>0,H7+F7*G7,0)/'Ihr Schaltschrank'!E15","v":0},{"$f":"Stammdaten!$H$34","v":1.3},{"$f":"IF(H7>0,1,0)","v":0},0,null,null,null,null,null,null,null,{"$f":"'Berechnung Beleuchtung'!Q12","v":0},{"$f":"'Berechnung Beschattung'!O12","v":0},{"$f":"'Berechnung Raumreg'!H12","v":0},{"$f":"'Berechnung AnalogDigitalmodule'!M11+'Berechnung AnalogDigitalmodule'!M28+'Berechnung AnalogDigitalmodule'!M42","v":0}]
[]
[]
[]
[]
["Subverteiler auf Smart Com",{"$f":"IF(H4>0,1,0)","v":0}]
["Subverteiler Hauptlinie verlängert",{"$f":"COUNTIF(H5:H7,\">0\")","v":0}]

{"sheet":"Taster","index":25,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[null,"Tastpunkte"]
[null,"Licht","Beschattung","Szenen","Gesamt",null,"Anzahl 4-fach Taster"]
[null,null,null,null,{"$f":"SUM(E4:E45)","v":0}]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C14:D14)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C14:G14)*2","v":0},{"$f":"Komfort!G11","v":0},{"$f":"SUM(B4:D4)","v":0},null,{"$f":"ROUNDUP(E4/4,0)","v":0}]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C15:D15)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C15:G15)*2","v":0},{"$f":"Komfort!G12","v":0},{"$f":"SUM(B5:D5)","v":0},null,{"$f":"ROUNDUP(E5/4,0)","v":0}]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C16:D16)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C16:G16)*2","v":0},{"$f":"Komfort!G13","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C17:D17)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C17:G17)*2","v":0},{"$f":"Komfort!G14","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C18:D18)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C18:G18)*2","v":0},{"$f":"Komfort!G15","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C19:D19)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C19:G19)*2","v":0},{"$f":"Komfort!G16","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C20:D20)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C20:G20)*2","v":0},{"$f":"Komfort!G17","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C21:D21)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C21:G21)*2","v":0},{"$f":"Komfort!G18","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C22:D22)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C22:G22)*2","v":0},{"$f":"Komfort!G19","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C23:D23)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C23:G23)*2","v":0},{"$f":"Komfort!G20","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C24:D24)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C24:G24)*2","v":0},{"$f":"Komfort!G21","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C25:D25)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C25:G25)*2","v":0},{"$f":"Komfort!G22","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C26:D26)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C26:G26)*2","v":0},{"$f":"Komfort!G23","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C27:D27)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C27:G27)*2","v":0},{"$f":"Komfort!G24","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C28:D28)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C28:G28)*2","v":0},{"$f":"Komfort!G25","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C29:D29)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C29:G29)*2","v":0},{"$f":"Komfort!G26","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C30:D30)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C30:G30)*2","v":0},{"$f":"Komfort!G27","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C31:D31)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C31:G31)*2","v":0},{"$f":"Komfort!G28","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C32:D32)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C32:G32)*2","v":0},{"$f":"Komfort!G29","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C33:D33)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C33:G33)*2","v":0},{"$f":"Komfort!G30","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C34:D34)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C34:G34)*2","v":0},{"$f":"Komfort!G31","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C35:D35)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C35:G35)*2","v":0},{"$f":"Komfort!G32","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C36:D36)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C36:G36)*2","v":0},{"$f":"Komfort!G33","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C37:D37)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C37:G37)*2","v":0},{"$f":"Komfort!G34","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C38:D38)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C38:G38)*2","v":0},{"$f":"Komfort!G35","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C39:D39)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C39:G39)*2","v":0},{"$f":"Komfort!G36","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(Beleuchtung!C40:D40)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C40:G40)*2","v":0},{"$f":"Komfort!G37","v":0},0,null,0]
[{"$f":"Start!B9&\" - \"&Start!C9","v":" - "},{"$f":"SUM(Beleuchtung!C41:D41)","v":0},{"$f":"SUM('Beschatttung und Fenster'!C41:G41)*2","v":0},{"$f":"Komfort!G38","v":0},0,null,0]
[{"$f":"Start!#REF!&\" - \"&Start!C24","v":{"$error":"#REF!"}}]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Start!#REF!&\" - \"&Start!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"SUM(G4:G31)","v":0}]