{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Info D","Info F","Info I","Calc","Tab-387-4","Language","Log","Tabelle2","Zielwert","Minergie","Grenzwert"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":14,"comments":4,"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":"Info D","index":0,"n_rows":127,"n_cols":12,"rows_kept":127,"cut":false,"hidden":true,"merged":[[54,0,86,0],[73,7,73,12],[88,0,102,0],[104,0,116,0],[27,1,27,12],[31,2,31,12],[38,0,49,0],[51,0,52,0],[110,2,110,12],[112,2,112,12],[114,2,114,12],[116,2,116,12],[69,2,69,12],[100,1,100,12],[102,2,102,12],[105,1,105,12],[106,1,106,12],[108,2,108,12],[89,1,89,12],[90,1,90,12],[92,2,92,12],[94,2,94,12],[96,2,96,12],[98,2,98,12],[79,7,79,8],[79,9,79,10],[79,11,79,12],[80,7,80,8],[80,9,80,10],[80,11,80,12],[86,2,86,12],[81,7,81,8],[81,9,81,10],[81,11,81,12],[82,7,82,8],[82,9,82,10],[82,11,82,12],[83,7,83,8],[83,9,83,10],[83,11,83,12],[78,11,78,12],[75,7,75,8],[75,9,75,10],[75,11,75,12],[76,7,76,8],[76,9,76,10],[76,11,76,12],[77,7,77,8],[77,9,77,10],[77,11,77,12],[78,7,78,8],[78,9,78,10],[66,2,66,12],[71,2,71,12],[67,1,67,12],[74,11,74,12],[74,9,74,10],[74,7,74,8],[74,4,74,6],[74,2,74,3],[64,2,64,12],[52,2,52,12],[55,1,55,12],[58,2,58,12],[60,2,60,12],[62,2,62,12],[56,1,56,12],[49,2,49,12],[29,2,29,12],[33,2,33,12],[35,2,35,12],[39,1,39,12],[41,2,41,12],[43,2,43,12],[45,2,45,12],[47,2,47,12]]}
[]
[null,"Bedienung des Formulars"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Allgemeines"]
[null,"Das Nachweisformular ist in vier Teile aufgeteilt:"]
[null,"❶","Formularkopf"]
[null,null,"Hier werden allgemeine Informationen zum Projekt und Status des Nachweises eingegeben."]
[null,"❷","Zusammenstellung / Ergebnis"]
[null,null,"Hier werden die Resultate der Berechnungen zusammengefasst und angezeigt, ob der Nachweis erfüllt ist."]
[null,"❸","Bestimmung Nettogeschossfläche und einzuhaltende Anforderungen"]
[null,null,"In dieser Tabelle werden die Nettogeschossflächen des Projektes eingegeben. Je nach Nutzung und vorgesehener Beleuchtungssteuerung werden die Anforderungen an die maximal zulässige installierte Leistung für die Beleuchtung festgelegt. \nAus den Anforderungen pro Raum oder Raumgruppe wird dann ein flächengewichteter Mittelwert der Einzelanforderungen berechnet. Dies ist die Anforderung für das gesamte Projekt.  "]
[null,"❹","Leistung Leuchten, Projektwert"]
[null,null,"In dieser Tabelle werden die Leistungsdaten aller im Projekt verwendeten Leuchten eingegeben. Daraus wird dann der Projektwert der installierten spezifischen Leistung berechnet. Dieser wird dann für den Nachweis mit der projektspezifischen Anforderung verglichen."]
[null,"❺","Beilagen"]
[]
["❶","Formularkopf"]
[null,"Eingabefelder:"]
[null,"à","Projektbezeichnung"]
[null,null,"Bezeichnung des Projekts, freie Eingabe ohne Vorgabe"]
[null,"à","Bearbeitet durch"]
[null,null,"Angabe des Sachbearbeiters. Am besten mit Telefon Nr.oder e-mail Adresse, falls Rückfragen erforderlich sind."]
[null,"à","Datum / Revisionen"]
[null,null,"Erstellungsdatum des Nachweises und Datum allfälliger Revisionen\nTipp:\nZum Fixieren des Datums: Datum von Hand einfügen oder [F2] und dann [F9] und [Enter] drücken."]
[null,"à","Status"]
[null,null,"Auswahlfeld:\n- Nachweis in Bearbeitung\n- Nachweis vollständig und in abgeschlossen\nDer Nachweis soll erst eingereicht werden, wenn er vollständig und abgeschlossen ist."]
[null,"à","Bemerkungen/Begründungen für Abweichungen etc."]
[null,null,"Hier können Anmerkungen zum Nachweis gemacht werden.\nTipp:\nZeilenumbruch mit ALT + ENTER"]
[]
["❺","à","Beilagen"]
[null,null,"Ankreuzen, welche Beilagen dem Nachweis angehängt werden."]
[]
["❸","Bestimmung der Nettogeschossfläche und einzuhaltende Anforderungen"]
[null,"Grundsätzlich ist es dem Anwender freigestellt, ob er jeden Raum einzeln eingibt oder ob er Räume gleicher Nutzung zu Raumgruppen zusammenfasst. Es dürfen jedoch nur Räume zusammengefasst werden, die die selbe Nutzung gemäss SIA 2024 aufweisen und im Projekt eine gleichwertige Steuerung aufweisen."]
[null,"Eingabefelder:"]
[null,"à","Nr."]
[null,null,"Nummerierung der Räume oder Raumgruppen. Kann frei gestaltet werden."]
[null,"à","Raum/Räume"]
[null,null,"Freie Angabe. Es ist jedoch von Vorteil, wenn die Bezeichnung eine Entsprechung in den beigefügten Unterlagen (z.B. Pläne) hat."]
[null,"à","Flächen"]
[null,null,"Eingabe der gesamten Nettogeschossfläche des Raums oder der Raumgruppe.\nTipp: \nBesteht die Gesamtfläche aus mehreren Teilflächen, so kann in der Zelle auch eine Formel mit der Additon der Teilflächen eingegeben werden (z.B. \"=150+20+145\")."]
[null,"à","Automatische Steuerung nach Präsenz / nach Tageslicht"]
[null,null,"Je nach Nutzung hat die Beleuchtungssteuerung einen Einfluss auf die Anforderung PV. Ist das Eingabefeld gelb markiert, muss angegeben werden ob eine Entsprechende Beleuchtungssteuerung vorgesehen ist."]
[null,"à","Nutzung gemäss SIA 2024, Nr."]
[null,null,"Auswahlfeld: Wählen Sie die Nummer der entsprechend Gebäudekategorie aus. Eine Liste der verfügbaren Nutzungskategorien ist im Tabellenblatt \"Tab-387-4\" zu finden."]
[null,"Infofelder:"]
[null,"à","Nutzung gemäss SIA 2024, Bezeichnung"]
[null,null,"Ausschreibung der Nutzungskategorie. Wird aufgrund der Kategorienummer automatisch dargestellt."]
[null,"à","Anforderungen"]
[null,null,"Anforderung an die Maximal zulässige spezifische Leistung für den jeweiligen Raum oder die Raumgruppe.\nDer Wert ist Abhängig von der Nutzung und der vorgesehenen Beleuchtungssteuerung. Basis für die Anforderungen ist die Norm SIA 387/4, Tabelle in Anhang A. In dieser Tabelle ist pro Nutzungskategorie ein Grenz- und ein Zielwert definiert (siehe auch Tabellenblatt \"Tab-387-4\").\nWelchen Einluss die Beleuchtungssteuerung auf die Anforderung hat, hängt von der Standardnutzung zugrunde gelegten Präsenz ab. Die untenstehnde Tabelle zeigt den Einfluss der Beleuchtungssteuerung in abhängigkeit der Präsenz auf"]
[]
[null,null,null,null,null,null,null,"Massgebende Anforderung"]
[null,null,"Präsenz gemäss Norm 387/4",null,"Beleuchtungssteuerung gemäss Projekt",null,null,"Grenzwert.",null,"Mittelwert\nGrenz-/Zielwert",null,"Zielwert"]
[null,null,"dauernd",null,"keine",null,null,"✔"]
[null,null,"normal",null,"keine",null,null,null,null,null,null,"✔"]
[null,null,null,null,"Präsenzmelder",null,null,null,null,"✔"]
[null,null,null,null,"Tageslichtsteuerung",null,null,null,null,"✔"]
[null,null,null,null,"beides",null,null,"✔"]
[null,null,"sporadisch",null,"keine",null,null,null,null,null,null,"✔"]
[null,null,null,null,"Präsenzmelder",null,null,"✔"]
[null,null,null,null,"Tageslichtsteuerung",null,null,null,null,null,null,"✔"]
[null,null,null,null,"beides",null,null,"✔"]
[]
[null,"à","Summe Anforderung"]
[null,null,"Maximal zulässige installierte Leistung für den Raum oder die Raumgruppe.\nSumme Anforderung = Anforderung * Fläche"]
[]
["❹","Leistung Leuchten, Projektwert"]
[null,"In dieser Tabelle wird die Anzahl und die Systemleistung der im Projekt effektiv vorgesehenen Leuchten angegeben. Dabei ist bei der Angabe der Leuchten Leistung die Verlustleistung des Betriebsgeräts (Vorschaltgerät) zu berücksichtigen.\nGrundsätzlich ist es dem User freigestelt die Angaben zu den Leuchten raum- oder raumgruppenweise zu machen oder zusammenfassend pro Leuchtentyp. \nWichtig ist, dass alle im Projekt vorkommenden Leuchten in der korrekten Anzahl angegeben werden."]
[null,"Eingabefelder:"]
[null,"à","Nr."]
[null,null,"Nummerierung der Leuchten. Kann frei gestaltet werden."]
[null,"à","Leuchten-Typ "]
[null,null,"Freie Angabe. Es ist jedoch von Vorteil, wenn die Bezeichnung eine Entsprechung in den beigefügten Unterlagen (z.B. Leuchtenspezifikation) hat."]
[null,"à","Anzahl Leuchten"]
[null,null,"Eingabe der Anzahl Leuchten.\nTipp: \nSollen mehrere Leuchten aus verschieden Räumen zusammengefasst werden, so kann in der Zelle auch eine Formel mit der Additon der Teilmengen eingegeben werden (z.B. \"=150+20+145\")."]
[null,"à","Leistung pro Leuchte"]
[null,null,"Angabe der Systemleistung der Leuchte (inkl. Betriebsgerät)"]
[]
[null,"Infofeld:"]
[null,"à","Pel"]
[null,null,"Gesamte eletrische Leistung der angegebenen Leuchten\nPel = Anzahl Leuchten * Leistung pro Leuchte"]
[]
["❷","Ergebnis"]
[null,"Hier werden die Resultate des Nachweises ausgegeben und aufgezeigt ob der Nachweis erfüllt ist."]
[null,"Resultate:"]
[null,"à","Summe aller Netogeschossflächen"]
[null,null,"Summe aller Netogeschossflächen des Projekts"]
[null,"à","Summe der elektrischen Leistung"]
[null,null,"Summe der elektrischen Leistung aller Leuchtenh im Projekt."]
[null,"à","Projektwert Beleuchtung"]
[null,null,"Spezifische Leistung der Beleuchtung für das Projekt.\nProjektwert Beleuchtung =  Summe der elektrischen Leistung / Summe aller Nettogeschossflächen"]
[null,"à","Anforderung Beleuchtung"]
[null,null,"Flächengewichteter Mittelwert aller Einzelanforderungen aus Tabelle \"Bestimmung Nettogeschossfläche und einzuhaltende Anforderung\".\n"]
[null,"à","Anforderung Eingehalten?"]
[null,null,"\"Projektwert Beleuchtung\" muss kleiner gleich als \"Anforderung Beleuchtung\" damit der Nachweis erfüllt ist."]
[]
[]
[null,"Abkürzungen, Formelzeichen"]
[]
[null,"Abkürzung",null,"Beschreibung"]
[]
[null,"PV",null,"Anforderung an die Beleuchtung (max. spezifische Leistung) [W/m²]"]
[null,"Pel",null,"elektrische Leistung [W]"]
[null,"W/Stk.",null,"elektrische Systemleistung (inkl. Betriebsgerät) pro Leuchte "]
[null,"Stk.",null,"Stück"]

{"sheet":"Info F","index":1,"n_rows":127,"n_cols":12,"rows_kept":127,"cut":false,"hidden":false,"merged":[[104,0,116,0],[105,1,105,12],[106,1,106,12],[108,2,108,12],[110,2,110,12],[112,2,112,12],[114,2,114,12],[116,2,116,12],[86,2,86,12],[88,0,102,0],[89,1,89,12],[90,1,90,12],[92,2,92,12],[94,2,94,12],[96,2,96,12],[98,2,98,12],[100,1,100,12],[102,2,102,12],[82,7,82,8],[82,9,82,10],[82,11,82,12],[83,7,83,8],[83,9,83,10],[83,11,83,12],[80,7,80,8],[80,9,80,10],[80,11,80,12],[81,7,81,8],[81,9,81,10],[81,11,81,12],[78,7,78,8],[78,9,78,10],[78,11,78,12],[79,7,79,8],[79,9,79,10],[79,11,79,12],[76,7,76,8],[76,9,76,10],[76,11,76,12],[77,7,77,8],[77,9,77,10],[77,11,77,12],[75,9,75,10],[75,11,75,12],[64,2,64,12],[66,2,66,12],[67,1,67,12],[69,2,69,12],[71,2,71,12],[73,7,73,12],[74,2,74,3],[74,4,74,6],[74,7,74,8],[74,9,74,10],[74,11,74,12],[47,2,47,12],[49,2,49,12],[51,0,52,0],[52,2,52,12],[54,0,86,0],[55,1,55,12],[56,1,56,12],[58,2,58,12],[60,2,60,12],[62,2,62,12],[38,0,49,0],[39,1,39,12],[41,2,41,12],[43,2,43,12],[45,2,45,12],[75,7,75,8],[27,1,27,12],[29,2,29,12],[31,2,31,12],[33,2,33,12],[35,2,35,12]]}
[]
[null,"Utilisation du formulaire"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Généralités"]
[null,"Le formulaire de justification est divisé en quatre parties"]
[null,"❶","Entête"]
[null,null,"Les informations générales sur le projet et le statut de la justification sont à saisir ici"]
[null,"❷","Récapitulation/ résultats"]
[null,null,"Les résultats des calculs sont résumés ici. Il est précisé si l'exigence est respectée ou non."]
[null,"❸","Détermination de la surface nette de plancher et des exigences à respecter"]
[null,null,"Dans ce tableau, les surfaces nettes de plancher du projet doivent être renseignées. Les exigences relatives à la puissance installée maximale autorisée pour l'éclairage sont définies en fonction de l'affectation des locaux et du système de régulation prévus.\nÀ partir des exigences par pièce ou groupe de pièces, la puissance moyenne spécifique est calculée. Cette moyenne correspond à l'exigence pour l'ensemble du projet."]
[null,"❹","Puissance des luminaires, valeur de projet"]
[null,null,"Dans ce tableau, les données de puissance de tous les luminaires utilisés dans le projet sont saisies. À partir de cela, la valeur de la puissance spécifique installée projetée est calculée. Celle-ci est ensuite comparée  avec l'exigence spécifique requise."]
[null,"❺","Annexes"]
[]
["❶","Entête"]
[null,"Champs à remplir:"]
[null,"à","Nom du projet"]
[null,null,"Nom du projet, entrées sans spécification"]
[null,"à","Auteur du justificatif"]
[null,null,"Données du collaborateur. De préférence le Nr. de téléphone ou l'adressse e-mail, en cas de questions complémentaires"]
[null,"à","Date / Révision"]
[null,null,"Date d'établissement du justificatif et des révisions\nAstuce:\nPour définir la date: introduire la date manuellement ou [F2] et ensuite [F9] et [Enter]."]
[null,"à","Statut"]
[null,null,"Champ à sélectionner:\n- Justification en cours\n- Justification complète et terminée\nLa justification ne doit pas être soumise avant d'avoir été complétée et terminée"]
[null,"à","Remarques / Justification des écarts, etc."]
[null,null,"Ajout de commentaires à la justification.\nAstuce:\nRetour à la ligne avec  ALT + ENTER"]
[]
["❺","à","Annexes"]
[null,null,"Cocher les annexes qui sont jointes à la justification."]
[]
["❸","Détermination de la surface nette de plancher et des exigences à respecter"]
[null,"En principe, il appartient à l'utilisateur d'entrer chaque pièce individuellement ou de regrouper les pièces avec une affectation identique dans des groupes de pièces. Toutefois, seules les pièces ayant la même affectation conformément à la SIA 2024 et le même type de régulation peuvent être regroupées."]
[null,"Champs à remplir:"]
[null,"à","Nr."]
[null,null,"La numérotation des pièces ou des groupes de pièces est libre"]
[null,"à","Pièce / Pièces"]
[null,null,"La nomination des pièces est libre mais il est toutefois important que celle-ci soit identique à celle utilisée sur les documents d'accompagnement (par exemple, des plans).\n"]
[null,"à","Surfaces"]
[null,null,"Saisir la surface nette totale de la pièce ou du groupe de pièces.\nAstuce: \nSi la surface totale est constituée de plusieurs surfaces partielles, une formule avec l'ajout des surfaces partielles peut également être saisie dans la cellule (par exemple, \"= 150 + 20 + 145\")."]
[null,"à","Régulation en fonction de la présence / de la lumière naturelle"]
[null,null,"En fonction de l'utilisation, la régulation de l'éclairage a une influence sur l'exigence PV. Si le champ de saisie est jaune, il faut spécifier la commande d'éclairage correspondante."]
[null,"à","Conditions d'utilisation selon SIA 2024, Nr."]
[null,null,"Champ de sélection: Sélectionnez le numéro du type d'utilisation correspondant. Une liste des catégories d'utilisation disponibles se trouve dans la feuille de travail \"Tab-387-4\"."]
[null,"Champs d'information"]
[null,"à","Conditions d'utilisation selon SIA 2024, désignation"]
[null,null,"La description des conditions d'utilisation est définie automatiquement sur la base du Nr. du type d'utilisation."]
[null,"à","Exigences"]
[null,null,"L'exigence relative à la puissance spécifique maximale admissible pour la pièce ou le groupe de pièces respectif.\nLa valeur dépend de l'utilisation et du contrôle d'éclairage souhaité. Les exigences sont basées sur les tableaux SIA 387/4 (voir l’annexe A). Dans ces tableaux, une valeur limite et une valeur cible sont définies pour chaque affectation (voir aussi la feuille de calcul \"Onglet 387-4\").\nL'influence de la régulation de l'éclairage sur l'exigence dépend de la présence pour laquelle est basée l'utilisation standard. Le tableau ci-dessous montre l’influence de  la commande de l’éclairage en fonction de la présence."]
[]
[null,null,null,null,null,null,null,"Exigences à prendre en compte"]
[null,null,"Présence selon norme 387/4",null,"Régulation de l'éclairage selon projet",null,null,"Valeur limite",null,"Valeur moyenne\n limite / cible",null,"Valeur cible"]
[null,null,"permanante",null,"Pas d'influence",null,null,"✔"]
[null,null,"normale",null,"Aucune",null,null,null,null,null,null,"✔"]
[null,null,null,null,"Détecteur de présence",null,null,null,null,"✔"]
[null,null,null,null,"Lumière naturelle",null,null,null,null,"✔"]
[null,null,null,null,"Les deux",null,null,"✔"]
[null,null,"sporadique",null,"Aucune",null,null,null,null,null,null,"✔"]
[null,null,null,null,"Détecteur de présence",null,null,"✔"]
[null,null,null,null,"Lumière naturelle",null,null,null,null,null,null,"✔"]
[null,null,null,null,"Les deux",null,null,"✔"]
[]
[null,"à","Exigence globale"]
[null,null,"Puissance installée maximale autorisée pour la pièce ou le groupe de pièces.\nExigence globale = exigence * surface"]
[]
["❹","Puissance des luminaires, valeur du projet"]
[null,"Ce tableau indique le nombre et les performances des luminaires prévus dans le projet. Lors de la spécification de la puissance du luminaire, il convient de prendre en compte la perte de puissance du ballast.\nEn principe, l’utilisateur est libre de regrouper les informations par pièce ou groupe de pièces  ou de les résumer par type de luminaire.\nIl est important que tous les luminaires du projet soient indiqués avec le numéro correct."]
[null,"Champ à remplir:"]
[null,"à","Nr."]
[null,null,"Numérotation des lumières. Le choix de la numérotation est libre."]
[null,"à","Type de luminaires"]
[null,null,"Indication facultative. Cependant, il est préférable que la désignation ait une correspondance dans les documents d'accompagnement (par exemple, spécification des luminaires)."]
[null,"à","Nombre de luminaires"]
[null,null,"Entrez le nombre de lumières.\nAstuce: \nSi plusieurs luminaires de différentes pièces doivent être combinés, une formule avec addition des sous-ensembles peut également être entrée dans la cellule (par exemple, \"= 150 + 20 + 145\")."]
[null,"à","Puissance par luminaire"]
[null,null,"Indication de la puissance du luminaire (y compris le ballast)"]
[]
[null,"Champ d'information:"]
[null,"à","Pel"]
[null,null,"Puissance électrique totale des luminaires spécifiés\nPel = nombre de luminiares* puissance par luminaire"]
[]
["❷","Puissance des luminaires, valeur de projet"]
[null,"Les résultats de la justification sont indiqués et il est précisé si l'exigence est remplie ou non."]
[null,"Résultat:"]
[null,"à","Somme des surfaces nettes de plancher"]
[null,null,"Somme des surfaces nettes de plancher du projet"]
[null,"à","Somme de la puissance électrique"]
[null,null,"Somme de la puissance électrique des luminaires du projet"]
[null,"à","Eclairage, valeur du projet"]
[null,null,"Puissance électrique spécifique de l'éclairage du projet.\nValeur de projet de l'éclairage =  somme de la puissance électrique / somme des surfaces nettes de plancher"]
[null,"à","Exigence pour l'éclairage"]
[null,null,"Moyenne pondérée en fonction de la surface de toutes les exigences individuelles du tableau \"Détermination de la surface de plancher nette et de l'exigence à respecter\".\n"]
[null,"à","Exigence requise"]
[null,null,"\"La valeur du projet de l'éclairage\" doit être inférieure ou égal à \"l'exigence requise\" pour que la justification soit acceptée.\n"]
[]
[]
[null,"Abréviations, symboles"]
[]
[null,"Abréviation",null,"Description"]
[]
[null,"PV",null,"Exigence pour l'éclairage (puissance spécifique maximale) en [W/m²]"]
[null,"Pel",null,"puissance électrique en [W]"]
[null,"W/Stk.",null,"puissance électrique (inclus ballast) par luminaire"]
[null,"Stk.",null,"nombre"]

{"sheet":"Info I","index":2,"n_rows":127,"n_cols":12,"rows_kept":127,"cut":false,"hidden":true,"merged":[[27,1,27,12],[29,2,29,12],[31,2,31,12],[33,2,33,12],[35,2,35,12],[47,2,47,12],[49,2,49,12],[51,0,52,0],[52,2,52,12],[54,0,86,0],[55,1,55,12],[56,1,56,12],[58,2,58,12],[60,2,60,12],[62,2,62,12],[38,0,49,0],[39,1,39,12],[41,2,41,12],[43,2,43,12],[45,2,45,12],[75,7,75,8],[75,9,75,10],[75,11,75,12],[64,2,64,12],[66,2,66,12],[67,1,67,12],[69,2,69,12],[71,2,71,12],[73,7,73,12],[74,2,74,3],[74,4,74,6],[74,7,74,8],[74,9,74,10],[74,11,74,12],[76,7,76,8],[76,9,76,10],[76,11,76,12],[77,7,77,8],[77,9,77,10],[77,11,77,12],[78,7,78,8],[78,9,78,10],[78,11,78,12],[79,7,79,8],[79,9,79,10],[79,11,79,12],[80,7,80,8],[80,9,80,10],[80,11,80,12],[81,7,81,8],[81,9,81,10],[81,11,81,12],[82,7,82,8],[82,9,82,10],[82,11,82,12],[83,7,83,8],[83,9,83,10],[83,11,83,12],[86,2,86,12],[88,0,102,0],[89,1,89,12],[90,1,90,12],[92,2,92,12],[94,2,94,12],[96,2,96,12],[98,2,98,12],[100,1,100,12],[102,2,102,12],[104,0,116,0],[105,1,105,12],[106,1,106,12],[108,2,108,12],[110,2,110,12],[112,2,112,12],[114,2,114,12],[116,2,116,12]]}
[]
[null,"Utilizzo del formulario"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Generale"]
[null,"Il formulario di verifica è suddiviso in quattro parti"]
[null,"❶","Intestazione"]
[null,null,"Qui si inseriscono le informazioni generali sul progetto e sullo stato della verifica."]
[null,"❷","Riassunto / Risultato"]
[null,null,"Qui vengono riassunti i risultati dei calcoli e viene indicato se la verifica è soddisfatta."]
[null,"❸","Definizione delle superfici nette e dei requisiti da rispettare"]
[null,null,"In questa tabella si definiscono le superfici nette del progetto. I requisiti per la potenza massima consentita vengono stabiliti in base all'utilizzo dei locali e alla regolazione prevista per l'illuminazione.\nDai requisiti per ogni singolo locale o per gruppi di locali viene estrapolato un valore medio ponderato sulle superfici. Questo valore corrisponde all'esigenza da rispettare per l'intero progetto."]
[null,"❹","Potenza dei corpi illuminanti, valori di progetto"]
[null,null,"In questa tabella si inseriscono le potenze di tutti i corpi illuminanti utilizzati nel progetto, da cui viene calcolata la potenza specifica installata. Questo valore viene poi confrontato con il valore limite da rispettare per il progetto."]
[null,"❺","Allegati"]
[]
["❶","Intestazione"]
[null,"Campi da compilare:"]
[null,"à","Titolo del progetto"]
[null,null,"Nome del progetto (descrizione libera)"]
[null,"à","Elaborato da"]
[null,null,"Dati dell'esecutore della verifica. Indicare nr. di telefono o indirizzo mail a cui rivolgersi in caso di domande"]
[null,"à","Data / Revisione"]
[null,null,"Data di creazione della verifica e date delle eventuali revisioni\nSuggerimento:\nInserire la data a mano oppure premere [F2] seguito da [F9] e [Enter]"]
[null,"à","Stato"]
[null,null,"Campo di selezione:\n- Verifica in allestimento\n- Verifica completata\nLa verifica può essere trasmessa solo se completata."]
[null,"à","Note / Motivazioni per scostamenti, ecc."]
[null,null,"Qui si possono inserire annotazioni alla verifica.\nSuggerimento:\nPer andare a capo premere ALT + ENTER"]
[]
["❺","à","Allegati"]
[null,null,"Selezionare gli allegati"]
[]
["❸","Definizione delle superfici nette e dei requisiti da rispettare"]
[null,"Di principio spetta all'esecutore della verifica scegliere se inserire ogni singolo locale o raggruppare i locali con lo stesso utilizzo. In ogni caso è possibile raggruppare unicamente i locali con lo stesso utilizzo definito secondo la SIA 2024 e che all'interno del progetto sono soggetti allo stesso tipo di regolazione."]
[null,"Campi da compilare:"]
[null,"à","Nr."]
[null,null,"Numerazione dei locali o dei gruppi di locali. La numerazione è libera."]
[null,"à","Locale/Locali"]
[null,null,"Testo libero. E' in ogni caso utile che la descrizione trovi una corrispondenza negli allegati (es. planimetrie)."]
[null,"à","Superfici"]
[null,null,"Indicazione della superficie netta totale del locale o dei gruppi di locali.\nSuggerimento: \nSe la superficie totale è composta da più superfici parziali, nella cella può essere inserita una formula con la somma delle superfici parziali (es. \"=150+20+145\")."]
[null,"à","Regolazione automatica a seconda del movimento / luce naturale"]
[null,null,"A seconda dell'utilizzo, la regolazione dell'illluminazione ha un influsso sull'esigenza PV. Se il campo è giallo bisogna indicare se è prevista una regolazione dell'illuminazione."]
[null,"à","Utilizzo secondo la SIA 2024, Numero"]
[null,null,"Menu a tendina: Selezionare il numero corrispondente alla categoria di edificio. Nel foglio Excel \"Tab-387-4\" è riportata una lista delle categorie di utilizzo disponibili."]
[null,"Campi informativi:"]
[null,"à","Utilizzo secondo la SIA 2024, Descrizione"]
[null,null,"Indicazione della categoria di utilizzo. Viene visualizzato automaticamente in base al numero di categoria."]
[null,"à","Requisiti"]
[null,null,"Requisiti per la potenza specifica massima consentita per il rispettivo locale o gruppo di locali.\nIl valore dipende dall'utilizzo e dalla regolazione prevista. La base per la definizione dei requisiti è la norma SIA 387/4, Allegato A, nella quale sono riportati i valori limite e i valori mirati per le diverse categorie di utilizzo (cfr. anche foglio Excel \"Tab-387-4\").\nL'influsso della regolazione dell'illuminazione sui requisiti dipende dalla presenza definita secondo l'utilizzo standard. La tabella sottostante mostra l'influsso della regolazione dell'illuminazione a dipendenza della presenza."]
[]
[null,null,null,null,null,null,null,"Requisito determinante"]
[null,null,"Presenza secondo la 387/4",null,"Regolaz. dell'illuminazione secondo progetto",null,null,"Valore limite",null,"Valore medio\nlimite/mirato",null,"Valore mirato"]
[null,null,"continua",null,"nessuna",null,null,"✔"]
[null,null,"normale",null,"nessuna",null,null,null,null,null,null,"✔"]
[null,null,null,null,"rilevatori movimento",null,null,null,null,"✔"]
[null,null,null,null,"rilevatori luce naturale",null,null,null,null,"✔"]
[null,null,null,null,"entrambi",null,null,"✔"]
[null,null,"sporadica",null,"nessuna",null,null,null,null,null,null,"✔"]
[null,null,null,null,"rilevatori movimento",null,null,"✔"]
[null,null,null,null,"rilevatori luce naturale",null,null,null,null,null,null,"✔"]
[null,null,null,null,"entrambi",null,null,"✔"]
[]
[null,"à","Somma requisiti"]
[null,null,"Potenza massima consentita per il locale o gruppo di locali.\nSomma requisiti =  Requisiti * Superficie"]
[]
["❹","Potenza dei corpi illuminanti, valori di progetto"]
[null,"In questa tabella viene riportato il numero e la potenza dei corpi illuminanti effettivamente previsti dal progetto. Nell'inserimento delle potenze dei corpi illuminanti vanno incluse le potenze richieste dagli alimentatori (reattori).\nL'esecutore ha libera scelta di effettuare un raggruppamento per corpi illuminanti o per locali o gruppi di locali.\nL'importante è che venga inserita la quantità corretta dei corpi illuminanti previsti dal progetto."]
[null,"Campi da compilare:"]
[null,"à","Nr."]
[null,null,"Numerazione dei corpi illuminanti. La numerazione è libera."]
[null,"à","Corpi illuminanti"]
[null,null,"Testo libero. E' in ogni caso utile che la descrizione trovi una corrispondenza negli allegati (es. specifiche tecniche)."]
[null,"à","Quantità corpi illuminanti"]
[null,null,"Indicazione della quantità dei corpi illuminanti.\nSuggerimento: \nSe si raggruppano più corpi illuminanti di locali diversi, nella cella può essere inserita una formula con le somme parziali dei corpi illuminanti (es. \"=150+20+145\")."]
[null,"à","Potenza dei corpi illuminanti"]
[null,null,"Indicazione della potenza dei corpi illuminanti (incl. alimentatore)"]
[]
[null,"Campi informativi:"]
[null,"à","Pel"]
[null,null,"Potenza elettrica totale dei corpi illuminanti\nPel = Quantità corpi illuminanti * Potenza del corpo illuminante"]
[]
["❷","Riassunto / Risultato"]
[null,"Qui vengono riassunti i risultati dei calcoli e viene indicato se la verifica è soddisfatta."]
[null,"Risultati:"]
[null,"à","Somma di tutte le superfici nette"]
[null,null,"Somma di tutte le superfici nette del progetto"]
[null,"à","Somma delle potenze elettriche"]
[null,null,"Somma delle potenze elettriche di tutti i corpi illuminanti del progetto."]
[null,"à","Valore di progetto per l'illuminazione"]
[null,null,"Potenza specifica dell'illuminazione per il progetto.\nValore di progetto per l'illuminazione = Somma delle potenze elettriche / Somma delle superfici nette"]
[null,"à","Requisito illuminazione"]
[null,null,"Valore medio dei singoli requisiti ponderato sulle superfici secondo la tabella \"Definizione delle superfici nette e dei requisiti da rispettare\".\n"]
[null,"à","Requisiti rispettati?"]
[null,null,"Affinché la verifica sia soddisfatta il \"Valore di progetto per l'illuminazione\" deve essere inferiore al \"Requisito per l'illuminazione\"."]
[]
[]
[null,"Abbreviazioni, simbologia"]
[]
[null,"Abbreviaz.",null,"Descrizione"]
[]
[null,"PV",null,"Requisito per l'illuminazione (potenza specifica massima) [W/m²]"]
[null,"Pel",null,"Potenza elettrica [W]"]
[null,"W/Pz.",null,"Potenza dei singoli corpi illuminanti (incl. alimentatore)"]
[null,"Pz.",null,"Pezzo"]

{"sheet":"Calc","index":3,"n_rows":106,"n_cols":20,"rows_kept":106,"cut":false,"hidden":false,"merged":[[20,3,20,4],[0,13,0,18],[17,19,19,19],[19,5,19,7],[3,13,6,19],[3,2,3,7],[5,2,5,7],[6,2,6,7],[7,2,7,7],[17,3,17,4],[20,6,20,7],[17,0,17,1],[18,0,18,1],[10,13,10,19],[11,13,11,19],[12,13,12,19],[13,13,13,19],[14,13,14,19]]}
[{"$f":"Language!D10","v":"EN-111a"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G11>0,IF(G13<=G14,T_erfüllt_2,T_n_erfüllt_2),\"\")","v":""},null,null,null,null,null,{"$f":"Log!H2","v":"V 1.04"}]
[{"$f":"OFFSET(Language!D12,Anfind,0)","v":"Justification de l'éclairage Performances pontuelles"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Language!D14&\" \"&TEXT(Log!H4,\"TT.MM.JJJJ\")","v":"Valable jusqu'à 31.12.2024"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Language!D35","v":"Remarques / justification des écarts etc."}]
[{"$f":"Language!D15","v":"Description du projet"}]
[]
[{"$f":"Language!D16","v":"Etabli par:"}]
[{"$f":"Language!D17","v":"Date / révision "},null,{"$f":"TODAY()","v":"2022-12-15"}]
["Status:",null,"Justification en cours"]
[]
[{"$f":"Language!D20","v":"Récapitulation / Résultat:"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Language!D36","v":"Annexes:"}]
[{"$f":"Language!D21","v":"Somme des surfaces nettes de plancher"},null,null,{"$f":"Language!D26","v":"① Somme colonne C"},null,null,{"$f":"SUM(C22:C106)","v":0}," m²",null,null,null,null,null,{"$f":"Language!D37","v":"Plans avec les données du concept d'éclairage (A3/A4)"}]
[{"$f":"Language!D22","v":"Somme des puissances électriques"},null,null,{"$f":"Language!D27","v":"② Somme colonne T"},null,null,{"$f":"SUM(T22:T106)","v":0}," W",null,null,null,null,null,{"$f":"Language!D38","v":"Plans avec les données des surfaces nettes de plancher (A3/A4)"}]
[{"$f":"Language!D23","v":"Eclairage valeur du projet"},null,null,{"$f":"Language!D28","v":"③ = ②/①"},null,null,{"$f":"IF(G11>0,ROUND(G12/G11,2),\"--\")","v":"--"}," W/m²",null,null,null,null,null,{"$f":"Language!D39","v":"Données des luminaires"}]
[{"$f":"Language!D24","v":"Exigence éclairage"},null,null,{"$f":"Language!D29","v":"④ Valeur moyenne pondérée par les surfaces"},null,null,{"$f":"IF(G11>0,ROUND(SUMPRODUCT(C22:C106,M22:M106)/G11,2),\"--\")","v":"--"}," W/m²"]
[{"$f":"Language!D25","v":"Exigence respectée ?"},null,null,{"$f":"Language!D30","v":"Contrôle: ③ inférieur ou égal à ④"},null,null,{"$f":"IF(G11>0,IF(G13<G14,T_erfüllt,T_n_erfüllt),\"\")","v":""}]
[]
[{"$f":"Language!D44","v":"Détermination de la surface nette de plancher et exigence à remplir"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Language!D73","v":"Puissance luminaire, valeur du projet"}]
[{"$f":"Language!D45","v":""},null,{"$f":"Language!D49","v":"①"},{"$f":"Language!D52","v":"Commande automatique"},null,{"$f":"Language!D58","v":""},null,null,null,null,{"$f":"Language!D61","v":"système de"},{"$f":"Language!D64","v":"système de "},{"$f":"Language!D67","v":"④"},{"$f":"Language!D69","v":"somme"},null,{"$f":"Language!D75","v":"Type de luminaire"},null,{"$f":"Language!D78","v":""},{"$f":"Language!D82","v":"Puissance"},"②\n\nPel"]
[{"$f":"Language!D46","v":"Pièce/pièces"},null,{"$f":"Language!D50","v":""},{"$f":"Language!D53","v":"par "},{"$f":"Language!D56","v":"par "},{"$f":"Language!D59","v":"Condition d'utilisation selon SIA 2024"},null,null,"Text",null,{"$f":"Language!D62","v":"régulation "},{"$f":"Language!D65","v":"régulation"},{"$f":"Language!D68","v":"Exigence"},{"$f":"Language!D70","v":"exigence"},null,{"$f":"Language!D76","v":"Luminaire par utilisation"},null,{"$f":"Language!D79","v":"nombre"},{"$f":"Language!D83","v":"par "}]
[{"$f":"Language!D47","v":"Nr."},{"$f":"Language!D48","v":"Désignation"},{"$f":"Language!D51","v":"Surface"},{"$f":"Language!D54","v":"présence"},{"$f":"Language!D57","v":"lumière naturelle"},{"$f":"Language!D60","v":"(voir onglet \"Tab-387-4\")"},null,null,"Glätten","Index",{"$f":"Language!D63","v":"selon norme"},{"$f":"Language!D66","v":"installée"},"PV","Pel",null,{"$f":"Language!D74","v":"Nr."},null,{"$f":"Language!D80","v":"luminaire"},{"$f":"Language!D84","v":"Luminaire"}]
[null,null,"m²",{"$f":"Language!D71","v":"0 = non; 1 =oui"},null,{"$f":"Language!D74","v":"Nr."},{"$f":"Language!D48","v":"Désignation"},null,null,null,null,null,"W/m²","W",null,null,null,{"$f":"Language!D81","v":"pièce"},{"$f":"Language!D85","v":"W/pièce"},"W"]
["1",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J22,0)","v":""},null,{"$f":"TRIM(F22)","v":""},{"$f":"IF(I22=\"\",0,MATCH(I22,L_Raumnutzung_Vergl,0))","v":0},{"$f":"OFFSET('Tab-387-4'!$I$13,J22,0)","v":0},{"$f":"IF(K22=1,D22,IF(K22=2,(D22+E22),0))","v":0},{"$f":"OFFSET('Tab-387-4'!$J$13,J22,IF(K22=1,(K22-L22)*2,IF(K22=2,K22-L22,0)))","v":0},{"$f":"M22*C22","v":0},null,null,null,null,null,{"$f":"R22*S22","v":0}]
[2,null,null,null,null,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J23,0)","v":""},null,{"$f":"TRIM(F23)","v":""},0,{"$f":"OFFSET('Tab-387-4'!$I$13,J23,0)","v":0},{"$f":"IF(K23=1,D23,IF(K23=2,(D23+E23),0))","v":0},{"$f":"OFFSET('Tab-387-4'!$J$13,J23,IF(K23=1,(K23-L23)*2,IF(K23=2,K23-L23,0)))","v":0},{"$f":"M23*C23","v":0},null,null,null,null,null,{"$f":"R23*S23","v":0}]
[3,null,null,null,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J24,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J24,0)","v":0},{"$f":"IF(K24=1,D24,IF(K24=2,(D24+E24),0))","v":0},{"$f":"OFFSET('Tab-387-4'!$J$13,J24,IF(K24=1,(K24-L24)*2,IF(K24=2,K24-L24,0)))","v":0},0,null,null,null,null,null,0]
["4",null,null,null,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J25,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J25,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J25,IF(K25=1,(K25-L25)*2,IF(K25=2,K25-L25,0)))","v":0},0,null,null,null,null,null,0]
["5",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J26,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J26,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J26,IF(K26=1,(K26-L26)*2,IF(K26=2,K26-L26,0)))","v":0},0,null,null,null,null,null,0]
["6",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J27,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J27,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J27,IF(K27=1,(K27-L27)*2,IF(K27=2,K27-L27,0)))","v":0},0,null,null,null,null,null,0]
["7",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J28,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J28,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J28,IF(K28=1,(K28-L28)*2,IF(K28=2,K28-L28,0)))","v":0},0,null,null,null,null,null,0]
["8",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J29,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J29,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J29,IF(K29=1,(K29-L29)*2,IF(K29=2,K29-L29,0)))","v":0},0,null,null,null,null,null,0]
["9",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J30,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J30,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J30,IF(K30=1,(K30-L30)*2,IF(K30=2,K30-L30,0)))","v":0},0,null,null,null,null,null,0]
["10",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J31,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J31,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J31,IF(K31=1,(K31-L31)*2,IF(K31=2,K31-L31,0)))","v":0},0,null,null,null,null,null,0]
["11",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J32,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J32,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J32,IF(K32=1,(K32-L32)*2,IF(K32=2,K32-L32,0)))","v":0},0,null,null,null,null,null,0]
["12",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J33,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J33,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J33,IF(K33=1,(K33-L33)*2,IF(K33=2,K33-L33,0)))","v":0},0,null,null,null,null,null,0]
["13",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J34,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J34,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J34,IF(K34=1,(K34-L34)*2,IF(K34=2,K34-L34,0)))","v":0},0,null,null,null,null,null,0]
["14",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J35,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J35,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J35,IF(K35=1,(K35-L35)*2,IF(K35=2,K35-L35,0)))","v":0},0,null,null,null,null,null,0]
["15",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J36,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J36,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J36,IF(K36=1,(K36-L36)*2,IF(K36=2,K36-L36,0)))","v":0},0,null,null,null,null,null,0]
["16",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J37,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J37,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J37,IF(K37=1,(K37-L37)*2,IF(K37=2,K37-L37,0)))","v":0},0,null,null,null,null,null,0]
["17",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J38,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J38,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J38,IF(K38=1,(K38-L38)*2,IF(K38=2,K38-L38,0)))","v":0},0,null,null,null,null,null,0]
["18",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J39,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J39,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J39,IF(K39=1,(K39-L39)*2,IF(K39=2,K39-L39,0)))","v":0},0,null,null,null,null,null,0]
["19",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J40,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J40,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J40,IF(K40=1,(K40-L40)*2,IF(K40=2,K40-L40,0)))","v":0},0,null,null,null,null,null,0]
["20",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J41,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J41,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J41,IF(K41=1,(K41-L41)*2,IF(K41=2,K41-L41,0)))","v":0},0,null,null,null,null,null,0]
["21",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J42,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J42,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J42,IF(K42=1,(K42-L42)*2,IF(K42=2,K42-L42,0)))","v":0},0,null,null,null,null,null,0]
["22",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J43,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J43,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J43,IF(K43=1,(K43-L43)*2,IF(K43=2,K43-L43,0)))","v":0},0,null,null,null,null,null,0]
["23",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J44,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J44,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J44,IF(K44=1,(K44-L44)*2,IF(K44=2,K44-L44,0)))","v":0},0,null,null,null,null,null,0]
["24",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J45,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J45,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J45,IF(K45=1,(K45-L45)*2,IF(K45=2,K45-L45,0)))","v":0},0,null,null,null,null,null,0]
["25",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J46,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J46,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J46,IF(K46=1,(K46-L46)*2,IF(K46=2,K46-L46,0)))","v":0},0,null,null,null,null,null,0]
["26",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J47,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J47,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J47,IF(K47=1,(K47-L47)*2,IF(K47=2,K47-L47,0)))","v":0},0,null,null,null,null,null,0]
["27",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J48,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J48,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J48,IF(K48=1,(K48-L48)*2,IF(K48=2,K48-L48,0)))","v":0},0,null,null,null,null,null,0]
["28",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J49,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J49,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J49,IF(K49=1,(K49-L49)*2,IF(K49=2,K49-L49,0)))","v":0},0,null,null,null,null,null,0]
["29",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J50,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J50,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J50,IF(K50=1,(K50-L50)*2,IF(K50=2,K50-L50,0)))","v":0},0,null,null,null,null,null,0]
["30",null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J51,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J51,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J51,IF(K51=1,(K51-L51)*2,IF(K51=2,K51-L51,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J52,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J52,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J52,IF(K52=1,(K52-L52)*2,IF(K52=2,K52-L52,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J53,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J53,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J53,IF(K53=1,(K53-L53)*2,IF(K53=2,K53-L53,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J54,0)","v":""},null,"",{"$f":"IF(I54=\"\",0,MATCH(I54,L_Raumnutzung_Vergl,0))","v":0},{"$f":"OFFSET('Tab-387-4'!$I$13,J54,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J54,IF(K54=1,(K54-L54)*2,IF(K54=2,K54-L54,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J55,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J55,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J55,IF(K55=1,(K55-L55)*2,IF(K55=2,K55-L55,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J56,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J56,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J56,IF(K56=1,(K56-L56)*2,IF(K56=2,K56-L56,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J57,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J57,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J57,IF(K57=1,(K57-L57)*2,IF(K57=2,K57-L57,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J58,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J58,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J58,IF(K58=1,(K58-L58)*2,IF(K58=2,K58-L58,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J59,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J59,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J59,IF(K59=1,(K59-L59)*2,IF(K59=2,K59-L59,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J60,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J60,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J60,IF(K60=1,(K60-L60)*2,IF(K60=2,K60-L60,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J61,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J61,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J61,IF(K61=1,(K61-L61)*2,IF(K61=2,K61-L61,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J62,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J62,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J62,IF(K62=1,(K62-L62)*2,IF(K62=2,K62-L62,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J63,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J63,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J63,IF(K63=1,(K63-L63)*2,IF(K63=2,K63-L63,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J64,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J64,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J64,IF(K64=1,(K64-L64)*2,IF(K64=2,K64-L64,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J65,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J65,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J65,IF(K65=1,(K65-L65)*2,IF(K65=2,K65-L65,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J66,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J66,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J66,IF(K66=1,(K66-L66)*2,IF(K66=2,K66-L66,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J67,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J67,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J67,IF(K67=1,(K67-L67)*2,IF(K67=2,K67-L67,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J68,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J68,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J68,IF(K68=1,(K68-L68)*2,IF(K68=2,K68-L68,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J69,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J69,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J69,IF(K69=1,(K69-L69)*2,IF(K69=2,K69-L69,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J70,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J70,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J70,IF(K70=1,(K70-L70)*2,IF(K70=2,K70-L70,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J71,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J71,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J71,IF(K71=1,(K71-L71)*2,IF(K71=2,K71-L71,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J72,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J72,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J72,IF(K72=1,(K72-L72)*2,IF(K72=2,K72-L72,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J73,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J73,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J73,IF(K73=1,(K73-L73)*2,IF(K73=2,K73-L73,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J74,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J74,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J74,IF(K74=1,(K74-L74)*2,IF(K74=2,K74-L74,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J75,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J75,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J75,IF(K75=1,(K75-L75)*2,IF(K75=2,K75-L75,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J76,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J76,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J76,IF(K76=1,(K76-L76)*2,IF(K76=2,K76-L76,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J77,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J77,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J77,IF(K77=1,(K77-L77)*2,IF(K77=2,K77-L77,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J78,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J78,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J78,IF(K78=1,(K78-L78)*2,IF(K78=2,K78-L78,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J79,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J79,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J79,IF(K79=1,(K79-L79)*2,IF(K79=2,K79-L79,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J80,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J80,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J80,IF(K80=1,(K80-L80)*2,IF(K80=2,K80-L80,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J81,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J81,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J81,IF(K81=1,(K81-L81)*2,IF(K81=2,K81-L81,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J82,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J82,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J82,IF(K82=1,(K82-L82)*2,IF(K82=2,K82-L82,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J83,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J83,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J83,IF(K83=1,(K83-L83)*2,IF(K83=2,K83-L83,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J84,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J84,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J84,IF(K84=1,(K84-L84)*2,IF(K84=2,K84-L84,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J85,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J85,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J85,IF(K85=1,(K85-L85)*2,IF(K85=2,K85-L85,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J86,0)","v":""},null,"",{"$f":"IF(I86=\"\",0,MATCH(I86,L_Raumnutzung_Vergl,0))","v":0},{"$f":"OFFSET('Tab-387-4'!$I$13,J86,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J86,IF(K86=1,(K86-L86)*2,IF(K86=2,K86-L86,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J87,0)","v":""},null,{"$f":"TRIM(F87)","v":""},0,{"$f":"OFFSET('Tab-387-4'!$I$13,J87,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J87,IF(K87=1,(K87-L87)*2,IF(K87=2,K87-L87,0)))","v":0},{"$f":"M87*C87","v":0},null,null,null,null,null,{"$f":"R87*S87","v":0}]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J88,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J88,0)","v":0},{"$f":"IF(K88=1,D88,IF(K88=2,(D88+E88),0))","v":0},{"$f":"OFFSET('Tab-387-4'!$J$13,J88,IF(K88=1,(K88-L88)*2,IF(K88=2,K88-L88,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J89,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J89,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J89,IF(K89=1,(K89-L89)*2,IF(K89=2,K89-L89,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J90,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J90,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J90,IF(K90=1,(K90-L90)*2,IF(K90=2,K90-L90,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J91,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J91,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J91,IF(K91=1,(K91-L91)*2,IF(K91=2,K91-L91,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J92,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J92,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J92,IF(K92=1,(K92-L92)*2,IF(K92=2,K92-L92,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J93,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J93,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J93,IF(K93=1,(K93-L93)*2,IF(K93=2,K93-L93,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J94,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J94,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J94,IF(K94=1,(K94-L94)*2,IF(K94=2,K94-L94,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J95,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J95,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J95,IF(K95=1,(K95-L95)*2,IF(K95=2,K95-L95,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J96,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J96,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J96,IF(K96=1,(K96-L96)*2,IF(K96=2,K96-L96,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J97,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J97,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J97,IF(K97=1,(K97-L97)*2,IF(K97=2,K97-L97,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J98,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J98,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J98,IF(K98=1,(K98-L98)*2,IF(K98=2,K98-L98,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J99,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J99,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J99,IF(K99=1,(K99-L99)*2,IF(K99=2,K99-L99,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J100,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J100,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J100,IF(K100=1,(K100-L100)*2,IF(K100=2,K100-L100,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J101,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J101,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J101,IF(K101=1,(K101-L101)*2,IF(K101=2,K101-L101,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J102,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J102,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J102,IF(K102=1,(K102-L102)*2,IF(K102=2,K102-L102,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J103,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J103,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J103,IF(K103=1,(K103-L103)*2,IF(K103=2,K103-L103,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J104,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J104,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J104,IF(K104=1,(K104-L104)*2,IF(K104=2,K104-L104,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J105,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J105,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J105,IF(K105=1,(K105-L105)*2,IF(K105=2,K105-L105,0)))","v":0},0,null,null,null,null,null,0]
[null,null,null,0,0,null,{"$f":"OFFSET('Tab-387-4'!$C$13,Calc!J106,0)","v":""},null,"",0,{"$f":"OFFSET('Tab-387-4'!$I$13,J106,0)","v":0},0,{"$f":"OFFSET('Tab-387-4'!$J$13,J106,IF(K106=1,(K106-L106)*2,IF(K106=2,K106-L106,0)))","v":0},0,null,null,null,null,null,0]

{"sheet":"Tab-387-4","index":4,"n_rows":56,"n_cols":21,"rows_kept":56,"cut":false,"hidden":false,"merged":[[8,3,8,4],[8,5,8,7],[8,9,8,11],[9,3,9,4],[9,5,9,7],[9,9,9,11],[8,13,8,15],[8,16,8,18],[9,13,9,15],[9,16,9,18],[0,8,5,11]]}
[null,null,null,null,null,null,null,null,{"$f":"Language!D91","v":"Retour au calcul"}]
[]
[]
[]
[]
[null,{"$f":"Language!D88","v":"Données liées aux conditions d'utilisation"}]
[null,{"$f":"Language!D89","v":"pour le calcul de l'exigence:"}]
[null,{"$f":"Language!D90","v":"(selon SIA 387/4, tableau Annexe A)"},null,null,null,null,null,null,null,{"$f":"IF(U13=1,Q8,\"\")","v":""},null,null,null,{"$f":"Language!D112","v":"Exigence légale requise"},null,null,{"$f":"Language!D113","v":"Exigence accrue"}]
["Nr ohne ",{"$f":"Language!D92","v":"Nr."},{"$f":"Language!D117","v":"Conditions d'utilisation"},{"$f":"Language!D94","v":"Puissance spécifique"},null,{"$f":"Language!D96","v":"Conditions d'utilisation standard avec présence"},null,null,{"$f":"Language!D108","v":"Exigence"},{"$f":"Language!D114","v":"Influence de la régulation"},null,null,null,{"$f":"J9","v":"Influence de la régulation"},null,null,{"$f":"N9","v":"Influence de la régulation"}]
["Leerschläge",{"$f":"Language!D93","v":""},{"$f":"Language!D118","v":""},{"$f":"Language!D95","v":"W/m²"},null,{"$f":"Language!D97","v":""},null,null,{"$f":"Language!D109","v":"commance"},{"$f":"Language!D115","v":"W/m²"},null,null,null,{"$f":"J10","v":"W/m²"},null,null,{"$f":"N10","v":"W/m²"}]
["Text",null,null,{"$f":"Language!D98","v":"pour la valeur limite"},{"$f":"Language!D100","v":"pour la valeur cible"},{"$f":"Language!D102","v":"Présence"},{"$f":"Language!D104","v":"Présence"},{"$f":"Language!D106","v":"Présence"},{"$f":"Language!D110","v":""},0,1,2,null,0,1,2,0,1,2]
[null,null,null,{"$f":"Language!D99","v":""},{"$f":"Language!D101","v":""},{"$f":"Language!D103","v":"permanente"},{"$f":"Language!D105","v":"usuelle"},{"$f":"Language!D107","v":"sporadique"},{"$f":"Language!D111","v":""}]
[{"$f":"TRIM(B13)","v":"Leerzeile"},"Leerzeile",{"$f":"\"\"","v":""},null,null,null,null,null,0,0,0,0,null,0,0,0,0,0,0,"Index Anforderung",{"$f":"Anfind","v":0}]
[{"$f":"TRIM(B14)","v":"2.1"},"  2.1",{"$f":"Language!D119","v":"Chambre d’hôtel"},7.7,5,"x",null,null,0,{"$f":"OFFSET(N14,0,Anfind*3)","v":7.7},{"$f":"OFFSET(O14,0,Anfind*3)","v":6.4},{"$f":"OFFSET(P14,0,Anfind*3)","v":5},null,{"$f":"D14","v":7.7},{"$f":"ROUND((N14+P14)/2,1)","v":6.4},{"$f":"E14","v":5},{"$f":"P14","v":5},{"$f":"ROUND((Q14+S14)/2,1)","v":4.3},{"$f":"Q14-(O14-P14)","v":3.5999999999999996}]
[{"$f":"TRIM(B15)","v":"2.2"},"  2.2",{"$f":"Language!D120","v":"Réception, zone d’accueil"},6.6,4.3,"x",null,null,0,6.6,5.5,4.3,null,{"$f":"D15","v":6.6},{"$f":"ROUND((N15+P15)/2,1)","v":5.5},{"$f":"E15","v":4.3},{"$f":"P15","v":4.3},{"$f":"ROUND((Q15+S15)/2,1)","v":3.7},{"$f":"Q15-(O15-P15)","v":3.0999999999999996}]
["3.1","  3.1",{"$f":"Language!D121","v":"Bureau individuel, collectif"},12.5,8.1,null,"x",null,2,12.5,10.3,8.1,null,12.5,10.3,8.1,8.1,7,5.8999999999999986]
["3.2","  3.2",{"$f":"Language!D122","v":"Bureau paysagé"},9.8000000000000007,6.4,null,"x",null,2,9.8000000000000007,8.1,6.4,null,9.8000000000000007,8.1,6.4,6.4,5.6,4.7000000000000011]
["3.3","  3.3",{"$f":"Language!D123","v":"Salle de réunion"},12.5,8.1,null,"x",null,2,12.5,10.3,8.1,null,12.5,10.3,8.1,8.1,7,5.8999999999999986]
["3.4","  3.4",{"$f":"Language!D124","v":"Hall des guichets, zone clientèle"},7.1,4.5999999999999996,"x",null,null,0,7.1,5.9,4.5999999999999996,null,7.1,5.9,4.5999999999999996,4.5999999999999996,4,3.2999999999999989]
["4.1","  4.1",{"$f":"Language!D125","v":"Salle d’école"},11,7.2,null,"x",null,2,11,9.1,7.2,null,11,9.1,7.2,7.2,6.3,5.3000000000000007]
["4.2","  4.2",{"$f":"Language!D126","v":"Salle des maîtres"},7.5,4.9000000000000004,null,"x",null,2,7.5,6.2,4.9000000000000004,null,7.5,6.2,4.9000000000000004,4.9000000000000004,4.3,3.6000000000000005]
["4.3","  4.3",{"$f":"Language!D127","v":"Bibliothèque"},5.9,3.8,null,"x",null,2,5.9,4.9000000000000004,3.8,null,5.9,4.9000000000000004,3.8,3.8,3.3,2.6999999999999993]
["4.4","  4.4",{"$f":"Language!D128","v":"Auditoire"},9.8000000000000007,6.4,null,"x",null,2,9.8000000000000007,8.1,6.4,null,9.8000000000000007,8.1,6.4,6.4,5.6,4.7000000000000011]
["4.5","  4.5",{"$f":"Language!D129","v":"Locaux spéciaux"},11,7.2,null,"x",null,2,11,9.1,7.2,null,11,9.1,7.2,7.2,6.3,5.3000000000000007]
["5.1","  5.1",{"$f":"Language!D130","v":"Magasin d’alimentation"},14.9,9.6999999999999993,"x",null,null,0,14.9,12.3,9.6999999999999993,null,14.9,12.3,9.6999999999999993,9.6999999999999993,8.4,7.0999999999999979]
["5.2","  5.2",{"$f":"Language!D131","v":"Magasin spécialisé"},14.9,9.6999999999999993,"x",null,null,0,14.9,12.3,9.6999999999999993,null,14.9,12.3,9.6999999999999993,9.6999999999999993,8.4,7.0999999999999979]
["5.3","  5.3",{"$f":"Language!D132","v":"Magasin meubles, bricolage, jardin"},12,7.8,"x",null,null,0,12,9.9,7.8,null,12,9.9,7.8,7.8,6.8,5.6999999999999993]
["6.1","  6.1",{"$f":"Language!D133","v":"Restaurant"},5.9,3.8,null,"x",null,2,5.9,4.9000000000000004,3.8,null,5.9,4.9000000000000004,3.8,3.8,3.3,2.6999999999999993]
["6.2","  6.2",{"$f":"Language!D134","v":"Restaurant self-service"},5.3,3.4,null,"x",null,2,5.3,4.4000000000000004,3.4,null,5.3,4.4000000000000004,3.4,3.4,2.9,2.3999999999999995]
["6.3","  6.3",{"$f":"Language!D135","v":"Cuisine de 6.1"},12.5,8.1,null,null,null,0,12.5,10.3,8.1,null,12.5,10.3,8.1,8.1,7,5.8999999999999986]
["6.4","  6.4",{"$f":"Language!D136","v":"Cuisine de 6.2"},9.8000000000000007,6.4,null,null,null,0,9.8000000000000007,8.1,6.4,null,9.8000000000000007,8.1,6.4,6.4,5.6,4.7000000000000011]
["7.1","  7.1",{"$f":"Language!D137","v":"Salle de spectacles"},7,4.5,null,null,null,0,7,5.8,4.5,null,7,5.8,4.5,4.5,3.9,3.2]
["7.2","  7.2",{"$f":"Language!D138","v":"Salle polyvalente"},7,4.5,null,null,null,0,7,5.8,4.5,null,7,5.8,4.5,4.5,3.9,3.2]
["7.3","  7.3",{"$f":"Language!D139","v":"Halle d’exposition"},13.9,9,null,null,null,0,13.9,11.5,9,null,13.9,11.5,9,9,7.8,6.5]
["8.1","  8.1",{"$f":"Language!D140","v":"Chambre d’hôpital"},6.8,4.4000000000000004,null,null,null,0,6.8,5.6,4.4000000000000004,null,6.8,5.6,4.4000000000000004,4.4000000000000004,3.8,3.2000000000000011]
["8.2","  8.2",{"$f":"Language!D141","v":"Bureau de service hospitalier"},12.5,8.1,null,null,null,0,12.5,10.3,8.1,null,12.5,10.3,8.1,8.1,7,5.8999999999999986]
["8.3","  8.3",{"$f":"Language!D142","v":"Locaux médicaux"},18.8,12.2,null,null,null,0,18.8,15.5,12.2,null,18.8,15.5,12.2,12.2,10.6,8.8999999999999986]
["9.1","  9.1",{"$f":"Language!D143","v":"Production (travail lourd)"},7,4.5,null,"x",null,2,7,5.8,4.5,null,7,5.8,4.5,4.5,3.9,3.2]
["9.2","  9.2",{"$f":"Language!D144","v":"Production (travail fin)"},11.6,7.5,null,"x",null,2,11.6,9.6,7.5,null,11.6,9.6,7.5,7.5,6.5,5.4]
["9.3","  9.3",{"$f":"Language!D145","v":"Laboratoire"},12.8,8.3000000000000007,"x",null,null,0,12.8,10.6,8.3000000000000007,null,12.8,10.6,8.3000000000000007,8.3000000000000007,7.2,6.0000000000000018]
["10.1","10.1",{"$f":"Language!D146","v":"Entrepôt"},7.3,4.7,null,"x",null,2,7.3,6,4.7,null,7.3,6,4.7,4.7,4.0999999999999996,3.4000000000000004]
["11.1","11.1",{"$f":"Language!D147","v":"Salle de gymnastique"},11.3,7.3,null,"x",null,2,11.3,9.3000000000000007,7.3,null,11.3,9.3000000000000007,7.3,7.3,6.3,5.2999999999999989]
["11.2","11.2",{"$f":"Language!D148","v":"Salle de fitness"},6.4,4.0999999999999996,null,"x",null,2,6.4,5.3,4.0999999999999996,null,6.4,5.3,4.0999999999999996,4.0999999999999996,3.5,2.8999999999999995]
["11.3","11.3",{"$f":"Language!D149","v":"Piscine couverte"},7.3,4.7,null,"x",null,2,7.3,6,4.7,null,7.3,6,4.7,4.7,4.0999999999999996,3.4000000000000004]
["12.1","12.1",{"$f":"Language!D150","v":"Surfaces de dégagement"},3.5,2.2999999999999998,null,null,"x",1,3.5,2.9,2.2999999999999998,null,3.5,2.9,2.2999999999999998,2.2999999999999998,2,1.6999999999999997]
["12.2","12.2",{"$f":"Language!D151","v":"Surfaces de dégagement 24h"},7.1,4.5999999999999996,null,null,"x",1,7.1,5.9,4.5999999999999996,null,7.1,5.9,4.5999999999999996,4.5999999999999996,4,3.2999999999999989]
["12.3","12.3",{"$f":"Language!D152","v":"Cage d’escalier"},3.5,2.2999999999999998,null,null,"x",1,3.5,2.9,2.2999999999999998,null,3.5,2.9,2.2999999999999998,2.2999999999999998,2,1.6999999999999997]
["12.4","12.4",{"$f":"Language!D153","v":"Locaux secondaires"},3,1.9,null,null,"x",1,3,2.5,1.9,null,3,2.5,1.9,1.9,1.6,1.2999999999999998]
["12.5","12.5",{"$f":"Language!D154","v":"Cuisine, cuisine à thé"},5.0999999999999996,3.3,null,null,"x",1,5.0999999999999996,4.2,3.3,null,5.0999999999999996,4.2,3.3,3.3,2.9,2.3999999999999995]
["12.6","12.6",{"$f":"Language!D155","v":"WC, salle de bain, douche"},6,3.9,null,null,"x",1,6,5,3.9,null,6,5,3.9,3.9,3.4,2.8]
["12.7","12.7",{"$f":"Language!D156","v":"WC"},9.9,6.4,null,null,"x",1,9.9,8.1999999999999993,6.4,null,9.9,8.1999999999999993,6.4,6.4,5.5,4.6000000000000014]
["12.8","12.8",{"$f":"Language!D157","v":"Vestiaires, douches"},5.7,3.7,null,null,"x",1,5.7,4.7,3.7,null,5.7,4.7,3.7,3.7,3.2,2.7]
["12.9","12.9",{"$f":"Language!D158","v":"Garage collectif"},1.4,0.9,null,null,"x",1,1.4,1.2,0.9,null,1.4,1.2,0.9,0.9,0.8,0.60000000000000009]
["12.10","12.10",{"$f":"Language!D159","v":"Buanderie, séchoir"},8.5,5.5,null,null,"x",1,8.5,7,5.5,null,8.5,7,5.5,5.5,4.8,4]
["12.11","12.11",{"$f":"Language!D160","v":"Chambre froide"},2.8,1.8,null,null,"x",1,2.8,2.2999999999999998,1.8,null,2.8,2.2999999999999998,1.8,1.8,1.6,1.3000000000000003]
["12.12","12.12",{"$f":"Language!D161","v":"Salle de serveurs"},3.3,2.2000000000000002,"x",null,null,0,3.3,2.8,2.2000000000000002,null,3.3,2.8,2.2000000000000002,2.2000000000000002,1.9,1.6000000000000005]

{"sheet":"Language","index":5,"n_rows":445,"n_cols":9,"rows_kept":445,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Anforderungen","Sprachversion"]
[null,null,"gesetzliche Anforderungen","français"]
[null,null,{"$f":"IF(C3=D113,1,0)","v":0},{"$f":"MATCH(D3,L_Sprachen,0)-1","v":1}]
[]
[]
[null,"Betrifft Zelle","Hilfsformeln/Bem.","Auswahl","deutsch","français","italiano","english","rumantsch"]
[]
[null,"Blatt \"Calc\""]
[{"$f":"CELL(\"address\",Calc!A1)","v":"'[EN-111a_F.xlsm]Calc'!$A$1"},{"$f":"MID(A10,SEARCH(\"]\",A10)+1,30)","v":"Calc'!$A$1"},null,{"$f":"OFFSET(E10,0,Spind)&\"\"","v":"EN-111a"},"EN-111a","EN-111a","EN-111a","EN-111a","EN-111a"]
[null,null,null,"fr","de","fr","it","en","ro"]
[{"$f":"CELL(\"address\",Calc!A2)","v":"'[EN-111a_F.xlsm]Calc'!$A$2"},{"$f":"MID(A12,SEARCH(\"]\",A12)+1,30)","v":"Calc'!$A$2"},null,"Justification de l'éclairage Performances pontuelles","Beleuchtungsnachweis Einzelanforderung gemäss SIA 387/4","Justification de l'éclairage Performances pontuelles","Verifica puntuale dell'illuminazione"]
[{"$f":"CELL(\"address\",Calc!A2)","v":"'[EN-111a_F.xlsm]Calc'!$A$2"},"Calc'!$A$2",null,{"$f":"OFFSET(E13,0,Spind)&\"\"","v":"Exigence accrue, selon les valeurs cibles de la norme SIA 387/4, annexe A"},"(Erhöhte Anforderung auf Basis der Zielwerte der Norm SIA 387/4, Anhang A)","Exigence accrue, selon les valeurs cibles de la norme SIA 387/4, annexe A","(esigenze elevate su base dei valori mirati della norma SIA 387/4, allegato A)"]
[{"$f":"CELL(\"address\",Calc!T2)","v":"'[EN-111a_F.xlsm]Calc'!$T$2"},{"$f":"MID(A14,SEARCH(\"]\",A14)+1,30)","v":"Calc'!$T$2"},null,{"$f":"OFFSET(E14,0,Spind)&\"\"","v":"Valable jusqu'à"},"Gültig bis","Valable jusqu'à","Valevole fino a "]
[{"$f":"CELL(\"address\",Calc!A4)","v":"'[EN-111a_F.xlsm]Calc'!$A$4"},"Calc'!$A$4",null,"Description du projet","Projektbezeichnung:","Description du projet","Titolo del progetto:"]
[{"$f":"CELL(\"address\",Calc!A6)","v":"'[EN-111a_F.xlsm]Calc'!$A$6"},"Calc'!$A$6",null,"Etabli par:","Bearbeitet durch:","Etabli par:","Elaborato da:"]
[{"$f":"CELL(\"address\",Calc!A7)","v":"'[EN-111a_F.xlsm]Calc'!$A$7"},"Calc'!$A$7",null,"Date / révision ","Datum / Revisionen:","Date / révision ","Data / Revisione:"]
[{"$f":"CELL(\"address\",Calc!C8)","v":"'[EN-111a_F.xlsm]Calc'!$C$8"},"Calc'!$C$8","L_Status","Justification en cours","Nachweis in Bearbeitung","Justification en cours","Verifica in allestimento"]
[null,null,"F_Status","Justification complète et terminée","Nachweis vollständig und abgeschlossen","Justification complète et terminée","Verifica completata"]
[{"$f":"CELL(\"address\",Calc!A10)","v":"'[EN-111a_F.xlsm]Calc'!$A$10"},"Calc'!$A$10",null,"Récapitulation / Résultat:","Zusammenstellung / Ergebnis:","Récapitulation / Résultat:","Riassunto / Risultato"]
[{"$f":"CELL(\"address\",Calc!A11)","v":"'[EN-111a_F.xlsm]Calc'!$A$11"},"Calc'!$A$11",null,"Somme des surfaces nettes de plancher","Summe aller Nettogeschossflächen","Somme des surfaces nettes de plancher","Somma di tutte le superfici nette"]
[{"$f":"CELL(\"address\",Calc!A12)","v":"'[EN-111a_F.xlsm]Calc'!$A$12"},"Calc'!$A$12",null,"Somme des puissances électriques","Summe der elektrischen Leistungen","Somme des puissances électriques","Somma delle potenze elettriche"]
[{"$f":"CELL(\"address\",Calc!A13)","v":"'[EN-111a_F.xlsm]Calc'!$A$13"},"Calc'!$A$13",null,"Eclairage valeur du projet","Projektwert Beleuchtung","Eclairage valeur du projet","Valore di progetto per l'illuminazione"]
[{"$f":"CELL(\"address\",Calc!A14)","v":"'[EN-111a_F.xlsm]Calc'!$A$14"},"Calc'!$A$14",null,"Exigence éclairage","Anforderung Beleuchtung","Exigence éclairage","Requisito per l'illuminazione"]
[{"$f":"CELL(\"address\",Calc!A15)","v":"'[EN-111a_F.xlsm]Calc'!$A$15"},"Calc'!$A$15",null,"Exigence respectée ?","Anforderung eingehalten?","Exigence respectée ?","Requisito rispettato?"]
[{"$f":"CELL(\"address\",Calc!D11)","v":"'[EN-111a_F.xlsm]Calc'!$D$11"},"Calc'!$D$11",null,"① Somme colonne C","① Summe aus Spalte C","① Somme colonne C","① Somma dalla colonna C"]
[{"$f":"CELL(\"address\",Calc!D12)","v":"'[EN-111a_F.xlsm]Calc'!$D$12"},"Calc'!$D$12",null,"② Somme colonne T","② Summe aus Spalte T","② Somme colonne T","② Somma dalla colonna T"]
[{"$f":"CELL(\"address\",Calc!D13)","v":"'[EN-111a_F.xlsm]Calc'!$D$13"},"Calc'!$D$13",null,"③ = ②/①","③ = ②/①","③ = ②/①","③ = ②/①","③ = ②/①","③ = ②/①"]
[{"$f":"CELL(\"address\",Calc!D14)","v":"'[EN-111a_F.xlsm]Calc'!$D$14"},"Calc'!$D$14",null,"④ Valeur moyenne pondérée par les surfaces","④ flächengewichteter Mittelwert","④ Valeur moyenne pondérée par les surfaces","④ Valore medio ponderato"]
[{"$f":"CELL(\"address\",Calc!D15)","v":"'[EN-111a_F.xlsm]Calc'!$D$15"},{"$f":"MID(A30,SEARCH(\"]\",A30)+1,30)","v":"Calc'!$D$15"},null,"Contrôle: ③ inférieur ou égal à ④","Prüfung: ③ kleiner gleich ④","Contrôle: ③ inférieur ou égal à ④","Verifica: ③ minore uguale ④"]
[{"$f":"CELL(\"address\",Calc!G15)","v":"'[EN-111a_F.xlsm]Calc'!$G$15"},{"$f":"MID(A31,SEARCH(\"]\",A31)+1,30)","v":"Calc'!$G$15"},"T_n_erfüllt","pas correct","nicht i.O.","pas correct","Non rispettato"]
[null,null,"T_erfüllt","respecté","erfüllt","respecté","Rispettato"]
[{"$f":"CELL(\"address\",Calc!N1)","v":"'[EN-111a_F.xlsm]Calc'!$N$1"},{"$f":"MID(A33,SEARCH(\"]\",A33)+1,30)","v":"Calc'!$N$1"},"T_n_erfüllt_2",{"$f":"OFFSET(E33,0,Spind)&\"\"","v":"Exigence pas respectée"},"Nachweis nicht erfüllt","Exigence pas respectée","Verifica non soddisfatta"]
[null,null,"T_erfüllt_2",{"$f":"OFFSET(E34,0,Spind)&\"\"","v":"Exigence respectée"},"Nachweis erfüllt","Exigence respectée","Verifica soddisfatta"]
[{"$f":"CELL(\"address\",Calc!N3)","v":"'[EN-111a_F.xlsm]Calc'!$N$3"},{"$f":"MID(A35,SEARCH(\"]\",A35)+1,30)","v":"Calc'!$N$3"},null,"Remarques / justification des écarts etc.","Bemerkungen/Begründungen für Abweichungen etc.:","Remarques / justification des écarts etc.","Note / Motivazioni per scostamenti, ecc."]
[{"$f":"CELL(\"address\",Calc!N10)","v":"'[EN-111a_F.xlsm]Calc'!$N$10"},{"$f":"MID(A36,SEARCH(\"]\",A36)+1,30)","v":"Calc'!$N$10"},null,"Annexes:","Beilagen:","Annexes:","Allegati:"]
[{"$f":"CELL(\"address\",Calc!N11)","v":"'[EN-111a_F.xlsm]Calc'!$N$11"},{"$f":"MID(A37,SEARCH(\"]\",A37)+1,30)","v":"Calc'!$N$11"},null,"Plans avec les données du concept d'éclairage (A3/A4)","Pläne mit Angaben zum Beleuchtungskonzept (A3/A4)","Plans avec les données du concept d'éclairage (A3/A4)","Planimetrie con indicazioni sul concetto di illuminazione (A3/A4)"]
[{"$f":"CELL(\"address\",Calc!N12)","v":"'[EN-111a_F.xlsm]Calc'!$N$12"},"Calc'!$N$12",null,"Plans avec les données des surfaces nettes de plancher (A3/A4)","Pläne mit Angaben zur Nettogeschossfläche (A3/A4)","Plans avec les données des surfaces nettes de plancher (A3/A4)","Planimetrie con indicazioni sulle superfici nette (A3/A4)"]
[{"$f":"CELL(\"address\",Calc!N13)","v":"'[EN-111a_F.xlsm]Calc'!$N$13"},"Calc'!$N$13",null,"Données des luminaires","Leuchtendatenblätter","Données des luminaires","Dati tecnici corpi illuminanti"]
[{"$f":"CELL(\"address\",Calc!N14)","v":"'[EN-111a_F.xlsm]Calc'!$N$14"},"Calc'!$N$14",null,""]
[{"$f":"CELL(\"address\",Calc!N15)","v":"'[EN-111a_F.xlsm]Calc'!$N$15"},"Calc'!$N$15",null,""]
[{"$f":"CELL(\"address\",Calc!N16)","v":"'[EN-111a_F.xlsm]Calc'!$N$16"},"Calc'!$N$16",null,""]
[null,null,null,""]
[{"$f":"CELL(\"address\",Calc!A17)","v":"'[EN-111a_F.xlsm]Calc'!$A$17"},{"$f":"MID(A44,SEARCH(\"]\",A44)+1,30)","v":"Calc'!$A$17"},null,"Détermination de la surface nette de plancher et exigence à remplir","Bestimmung Nettogeschossfläche und einzuhaltende Anforderung","Détermination de la surface nette de plancher et exigence à remplir","Definizione delle superfici nette e dei requisiti da rispettare"]
[{"$f":"CELL(\"address\",Calc!A18)","v":"'[EN-111a_F.xlsm]Calc'!$A$18"},"Calc'!$A$18",null,""]
[{"$f":"CELL(\"address\",Calc!A19)","v":"'[EN-111a_F.xlsm]Calc'!$A$19"},{"$f":"MID(A46,SEARCH(\"]\",A46)+1,30)","v":"Calc'!$A$19"},null,"Pièce/pièces","Raum/Räume","Pièce/pièces","Locale/Locali"]
[{"$f":"CELL(\"address\",Calc!A20)","v":"'[EN-111a_F.xlsm]Calc'!$A$20"},{"$f":"MID(A47,SEARCH(\"]\",A47)+1,30)","v":"Calc'!$A$20"},null,{"$f":"OFFSET(E47,0,Spind)&\"\"","v":"Nr."},"Nr.","Nr.","Nr."]
[{"$f":"CELL(\"address\",Calc!B20)","v":"'[EN-111a_F.xlsm]Calc'!$B$20"},{"$f":"MID(A48,SEARCH(\"]\",A48)+1,30)","v":"Calc'!$B$20"},null,"Désignation","Bezeichnung","Désignation","Descrizione"]
[{"$f":"CELL(\"address\",Calc!C18)","v":"'[EN-111a_F.xlsm]Calc'!$C$18"},"Calc'!$C$18",null,"①","①","①","①","①","①"]
[{"$f":"CELL(\"address\",Calc!C19)","v":"'[EN-111a_F.xlsm]Calc'!$C$19"},{"$f":"MID(A50,SEARCH(\"]\",A50)+1,30)","v":"Calc'!$C$19"},null,""]
[{"$f":"CELL(\"address\",Calc!C20)","v":"'[EN-111a_F.xlsm]Calc'!$C$20"},{"$f":"MID(A51,SEARCH(\"]\",A51)+1,30)","v":"Calc'!$C$20"},null,"Surface","Flächen","Surface","Superf."]
[{"$f":"CELL(\"address\",Calc!D18)","v":"'[EN-111a_F.xlsm]Calc'!$D$18"},"Calc'!$D$18",null,"Commande automatique","Automatische Steuerung","Commande automatique","Ragolaz. automatizzata"]
[{"$f":"CELL(\"address\",Calc!D19)","v":"'[EN-111a_F.xlsm]Calc'!$D$19"},{"$f":"MID(A53,SEARCH(\"]\",A53)+1,30)","v":"Calc'!$D$19"},null,"par ","nach","par "]
[{"$f":"CELL(\"address\",Calc!D20)","v":"'[EN-111a_F.xlsm]Calc'!$D$20"},{"$f":"MID(A54,SEARCH(\"]\",A54)+1,30)","v":"Calc'!$D$20"},null,"présence","Präsenz","présence","movimento"]
[{"$f":"CELL(\"address\",Calc!E18)","v":"'[EN-111a_F.xlsm]Calc'!$E$18"},"Calc'!$E$18",null,""]
[{"$f":"CELL(\"address\",Calc!E19)","v":"'[EN-111a_F.xlsm]Calc'!$E$19"},{"$f":"MID(A56,SEARCH(\"]\",A56)+1,30)","v":"Calc'!$E$19"},null,"par ","nach ","par ","luce"]
[{"$f":"CELL(\"address\",Calc!E20)","v":"'[EN-111a_F.xlsm]Calc'!$E$20"},{"$f":"MID(A57,SEARCH(\"]\",A57)+1,30)","v":"Calc'!$E$20"},null,"lumière naturelle","Tageslicht","lumière naturelle","naturale"]
[{"$f":"CELL(\"address\",Calc!F18)","v":"'[EN-111a_F.xlsm]Calc'!$F$18"},"Calc'!$F$18",null,"","  "]
[{"$f":"CELL(\"address\",Calc!F19)","v":"'[EN-111a_F.xlsm]Calc'!$F$19"},{"$f":"MID(A59,SEARCH(\"]\",A59)+1,30)","v":"Calc'!$F$19"},null,{"$f":"OFFSET(E59,0,Spind)&\"\"","v":"Condition d'utilisation selon SIA 2024"},"Nutzung gemäss SIA 2024","Condition d'utilisation selon SIA 2024","Utilizzo secondo SIA 2024"]
[{"$f":"CELL(\"address\",Calc!F20)","v":"'[EN-111a_F.xlsm]Calc'!$F$20"},"Calc'!$F$20",null,"(voir onglet \"Tab-387-4\")","(siehe Blatt \"Tab-387-4\")","(voir onglet \"Tab-387-4\")","(cfr. foglio \"Tab-387-4\")"]
[{"$f":"CELL(\"address\",Calc!K18)","v":"'[EN-111a_F.xlsm]Calc'!$K$18"},{"$f":"MID(A61,SEARCH(\"]\",A61)+1,30)","v":"Calc'!$K$18"},null,{"$f":"OFFSET(E61,0,Spind)&\"\"","v":"système de"},"Steuerungs-","système de","Punteggio"]
[{"$f":"CELL(\"address\",Calc!K19)","v":"'[EN-111a_F.xlsm]Calc'!$K$19"},"Calc'!$K$19",null,"régulation ","punkte ge-","régulation ","regolaz."]
[{"$f":"CELL(\"address\",Calc!K20)","v":"'[EN-111a_F.xlsm]Calc'!$K$20"},"Calc'!$K$20",null,"selon norme","mäss Norm","selon norme","da norma"]
[{"$f":"CELL(\"address\",Calc!L18)","v":"'[EN-111a_F.xlsm]Calc'!$L$18"},"Calc'!$L$18",null,"système de ","installierte","système de ","Regolaz.","  ","  "]
[{"$f":"CELL(\"address\",Calc!L19)","v":"'[EN-111a_F.xlsm]Calc'!$L$19"},"Calc'!$L$19",null,"régulation","Steue-","régulation","installata"]
[{"$f":"CELL(\"address\",Calc!L20)","v":"'[EN-111a_F.xlsm]Calc'!$L$20"},"Calc'!$L$20",null,"installée","rung","installée"]
[{"$f":"CELL(\"address\",Calc!M18)","v":"'[EN-111a_F.xlsm]Calc'!$M$18"},"Calc'!$M$18",null,"④","④","④","④","④","④"]
[{"$f":"CELL(\"address\",Calc!M19)","v":"'[EN-111a_F.xlsm]Calc'!$M$19"},{"$f":"MID(A68,SEARCH(\"]\",A68)+1,30)","v":"Calc'!$M$19"},null,"Exigence","Anforderung","Exigence","Requisiti"]
[{"$f":"CELL(\"address\",Calc!N18)","v":"'[EN-111a_F.xlsm]Calc'!$N$18"},"Calc'!$N$18",null,"somme","Summe","somme","Somma"]
[{"$f":"CELL(\"address\",Calc!N19)","v":"'[EN-111a_F.xlsm]Calc'!$N$19"},{"$f":"MID(A70,SEARCH(\"]\",A70)+1,30)","v":"Calc'!$N$19"},null,{"$f":"OFFSET(E70,0,Spind)&\"\"","v":"exigence"},"Anforderung","exigence","requisiti"]
[{"$f":"CELL(\"address\",Calc!D21)","v":"'[EN-111a_F.xlsm]Calc'!$D$21"},"Calc'!$D$21",null,"0 = non; 1 =oui","0 = Nein; 1 =Ja","0 = non; 1 =oui","0 = No; 1 = Si"]
[{"$f":"CELL(\"address\",Calc!G21)","v":"'[EN-111a_F.xlsm]Calc'!$G$21"},{"$f":"MID(A72,SEARCH(\"]\",A72)+1,30)","v":"Calc'!$G$21"},null,{"$f":"OFFSET(E72,0,Spind)&\"\"","v":"Désignation"},"Bezeichnung","Désignation","Descrizione"]
[{"$f":"CELL(\"address\",Calc!P17)","v":"'[EN-111a_F.xlsm]Calc'!$P$17"},{"$f":"MID(A73,SEARCH(\"]\",A73)+1,30)","v":"Calc'!$P$17"},null,{"$f":"OFFSET(E73,0,Spind)&\"\"","v":"Puissance luminaire, valeur du projet"},"Leistung Leuchten, Projektwert","Puissance luminaire, valeur du projet","Potenza dei corpi illuminanti, valori di progetto"]
[{"$f":"CELL(\"address\",Calc!F21)","v":"'[EN-111a_F.xlsm]Calc'!$F$21"},"Calc'!$F$21",null,"Nr.","Nr.","Nr.","Nr."]
[{"$f":"CELL(\"address\",Calc!P18)","v":"'[EN-111a_F.xlsm]Calc'!$P$18"},"Calc'!$P$18",null,"Type de luminaire","Leuchten-Typ /","Type de luminaire","Tipo di corpo illuminante /"]
[{"$f":"CELL(\"address\",Calc!P19)","v":"'[EN-111a_F.xlsm]Calc'!$P$19"},{"$f":"MID(A76,SEARCH(\"]\",A76)+1,30)","v":"Calc'!$P$19"},null,{"$f":"OFFSET(E76,0,Spind)&\"\"","v":"Luminaire par utilisation"},"Leuchten pro Nutzung","Luminaire par utilisation","Corpi illuminanti per utilizzo"]
[{"$f":"CELL(\"address\",Calc!Q20)","v":"'[EN-111a_F.xlsm]Calc'!$Q$20"},{"$f":"MID(A77,SEARCH(\"]\",A77)+1,30)","v":"Calc'!$Q$20"},null,{"$f":"OFFSET(E77,0,Spind)&\"\"","v":"Condition d'utilisation "},"Nutzung","Condition d'utilisation ","Utilizzo"]
[{"$f":"CELL(\"address\",Calc!R18)","v":"'[EN-111a_F.xlsm]Calc'!$R$18"},"Calc'!$R$18",null,"",null,null,"Quantità"]
[{"$f":"CELL(\"address\",Calc!R19)","v":"'[EN-111a_F.xlsm]Calc'!$R$19"},{"$f":"MID(A79,SEARCH(\"]\",A79)+1,30)","v":"Calc'!$R$19"},null,{"$f":"OFFSET(E79,0,Spind)&\"\"","v":"nombre"},"Anzahl","nombre","corpi"]
[{"$f":"CELL(\"address\",Calc!R20)","v":"'[EN-111a_F.xlsm]Calc'!$R$20"},{"$f":"MID(A80,SEARCH(\"]\",A80)+1,30)","v":"Calc'!$R$20"},null,{"$f":"OFFSET(E80,0,Spind)&\"\"","v":"luminaire"},"Leuchten","luminaire","illumin."]
[{"$f":"CELL(\"address\",Calc!R21)","v":"'[EN-111a_F.xlsm]Calc'!$R$21"},"Calc'!$R$21",null,"pièce","Stück","pièce","Qtà"]
[{"$f":"CELL(\"address\",Calc!S18)","v":"'[EN-111a_F.xlsm]Calc'!$S$18"},"Calc'!$S$18",null,"Puissance","Leistung","Puissance","Potenza"]
[{"$f":"CELL(\"address\",Calc!S19)","v":"'[EN-111a_F.xlsm]Calc'!$S$19"},{"$f":"MID(A83,SEARCH(\"]\",A83)+1,30)","v":"Calc'!$S$19"},null,{"$f":"OFFSET(E83,0,Spind)&\"\"","v":"par "},"pro","par ","per corpo"]
[{"$f":"CELL(\"address\",Calc!S20)","v":"'[EN-111a_F.xlsm]Calc'!$S$20"},{"$f":"MID(A84,SEARCH(\"]\",A84)+1,30)","v":"Calc'!$S$20"},null,{"$f":"OFFSET(E84,0,Spind)&\"\"","v":"Luminaire"},"Leuchte","Luminaire","illlumin."]
[{"$f":"CELL(\"address\",Calc!S21)","v":"'[EN-111a_F.xlsm]Calc'!$S$21"},{"$f":"MID(A85,SEARCH(\"]\",A85)+1,30)","v":"Calc'!$S$21"},null,{"$f":"OFFSET(E85,0,Spind)&\"\"","v":"W/pièce"},"W/Stk.","W/pièce","W/Pz."]
[null,null,null,""]
[null,"Blatt \"Tab-387-4\"",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!B6)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$B$6"},"Tab-387-4'!$B$6",null,"Données liées aux conditions d'utilisation","Daten der Raumnutzungen","Données liées aux conditions d'utilisation","Dati delle tipologie di utilizzo"]
[{"$f":"CELL(\"address\",'Tab-387-4'!B7)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$B$7"},"Tab-387-4'!$B$7",null,"pour le calcul de l'exigence:","für die Berechnung der Anforderung:","pour le calcul de l'exigence:","per il calcolo deli requisiti:"]
[{"$f":"CELL(\"address\",'Tab-387-4'!B8)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$B$8"},{"$f":"MID(A90,SEARCH(\"]\",A90)+1,30)","v":"Tab-387-4'!$B$8"},null,{"$f":"OFFSET(E90,0,Spind)&\"\"","v":"(selon SIA 387/4, tableau Annexe A)"},"(Auf Basis SIA 387/4, Tabelle Anhang A)","(selon SIA 387/4, tableau Annexe A)","(su base SIA 387/4, tabella in Allegato A)"]
[{"$f":"CELL(\"address\",'Tab-387-4'!I6:K6)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$I$6"},{"$f":"MID(A91,SEARCH(\"]\",A91)+1,30)","v":"Tab-387-4'!$I$6"},null,{"$f":"OFFSET(E91,0,Spind)&\"\"","v":"Retour au calcul"},"Zurück zur Berechnung","Retour au calcul","Ritorna alla verifica"]
[{"$f":"CELL(\"address\",'Tab-387-4'!B9)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$B$9"},"Tab-387-4'!$B$9",null,"Nr.","Nr.","Nr.","Nr."]
[{"$f":"CELL(\"address\",'Tab-387-4'!B10)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$B$10"},{"$f":"MID(A93,SEARCH(\"]\",A93)+1,30)","v":"Tab-387-4'!$B$10"},null,{"$f":"OFFSET(E93,0,Spind)&\"\"","v":""}]
[{"$f":"CELL(\"address\",'Tab-387-4'!D9)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$D$9"},"Tab-387-4'!$D$9",null,"Puissance spécifique","spezifische Leistung ","Puissance spécifique","Potenza specifica"]
[{"$f":"CELL(\"address\",'Tab-387-4'!D10)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$D$10"},{"$f":"MID(A95,SEARCH(\"]\",A95)+1,30)","v":"Tab-387-4'!$D$10"},null,{"$f":"OFFSET(E95,0,Spind)&\"\"","v":"W/m²"},"W/m²","W/m²","W/m²","W/m²","W/m²"]
[{"$f":"CELL(\"address\",'Tab-387-4'!F9)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$F$9"},"Tab-387-4'!$F$9",null,"Conditions d'utilisation standard avec présence","Standardnutzungen mit Präsenz","Conditions d'utilisation standard avec présence","Utilizzo standard con presenza"]
[{"$f":"CELL(\"address\",'Tab-387-4'!F10)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$F$10"},{"$f":"MID(A97,SEARCH(\"]\",A97)+1,30)","v":"Tab-387-4'!$F$10"},null,{"$f":"OFFSET(E97,0,Spind)&\"\"","v":""}]
[{"$f":"CELL(\"address\",'Tab-387-4'!D11)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$D$11"},"Tab-387-4'!$D$11",null,"pour la valeur limite","für Grenzwert","pour la valeur limite","per valore"]
[{"$f":"CELL(\"address\",'Tab-387-4'!D12)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$D$12"},{"$f":"MID(A99,SEARCH(\"]\",A99)+1,30)","v":"Tab-387-4'!$D$12"},null,{"$f":"OFFSET(E99,0,Spind)&\"\"","v":""},null,null,"limite"]
[{"$f":"CELL(\"address\",'Tab-387-4'!E11)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$E$11"},"Tab-387-4'!$E$11",null,"pour la valeur cible","für Zielwert","pour la valeur cible","per valore"]
[{"$f":"CELL(\"address\",'Tab-387-4'!E12)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$E$12"},{"$f":"MID(A101,SEARCH(\"]\",A101)+1,30)","v":"Tab-387-4'!$E$12"},null,{"$f":"OFFSET(E101,0,Spind)&\"\"","v":""},null,null,"mirato"]
[{"$f":"CELL(\"address\",'Tab-387-4'!F11)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$F$11"},"Tab-387-4'!$F$11",null,"Présence","dauernde","Présence","presenza"]
[{"$f":"CELL(\"address\",'Tab-387-4'!F12)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$F$12"},{"$f":"MID(A103,SEARCH(\"]\",A103)+1,30)","v":"Tab-387-4'!$F$12"},null,{"$f":"OFFSET(E103,0,Spind)&\"\"","v":"permanente"},"Präsenz","permanente","continua"]
[{"$f":"CELL(\"address\",'Tab-387-4'!G11)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$G$11"},"Tab-387-4'!$G$11",null,"Présence","normale","Présence","presenza"]
[{"$f":"CELL(\"address\",'Tab-387-4'!G12)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$G$12"},{"$f":"MID(A105,SEARCH(\"]\",A105)+1,30)","v":"Tab-387-4'!$G$12"},null,{"$f":"OFFSET(E105,0,Spind)&\"\"","v":"usuelle"},"Präsenz","usuelle","normale"]
[{"$f":"CELL(\"address\",'Tab-387-4'!H11)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$H$11"},"Tab-387-4'!$H$11",null,"Présence","sporadische","Présence","presenza"]
[{"$f":"CELL(\"address\",'Tab-387-4'!H12)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$H$12"},{"$f":"MID(A107,SEARCH(\"]\",A107)+1,30)","v":"Tab-387-4'!$H$12"},null,{"$f":"OFFSET(E107,0,Spind)&\"\"","v":"sporadique"},"Präsenz","sporadique","sporadica"]
[{"$f":"CELL(\"address\",'Tab-387-4'!I9)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$I$9"},{"$f":"MID(A108,SEARCH(\"]\",A108)+1,30)","v":"Tab-387-4'!$I$9"},null,"Exigence","Anforderung","Exigence","Esigenza"]
[{"$f":"CELL(\"address\",'Tab-387-4'!I10)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$I$10"},{"$f":"MID(A109,SEARCH(\"]\",A109)+1,30)","v":"Tab-387-4'!$I$10"},null,"commance","Steuerung","commance","regolazione"]
[{"$f":"CELL(\"address\",'Tab-387-4'!I11)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$I$11"},"Tab-387-4'!$I$11",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!I12)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$I$12"},"Tab-387-4'!$I$12",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!N8)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$N$8"},"Tab-387-4'!$N$8","L_Anforderung",{"$f":"OFFSET(E112,0,Spind)&\"\"","v":"Exigence légale requise"},"gesetzliche Anforderungen","Exigence légale requise","Esigenze secondo norma"]
[{"$f":"CELL(\"address\",'Tab-387-4'!Q8)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$Q$8"},"Tab-387-4'!$Q$8",null,{"$f":"OFFSET(E113,0,Spind)&\"\"","v":"Exigence accrue"},"erhöhte Anforderungen","Exigence accrue","Esigenze elevate"]
[{"$f":"CELL(\"address\",'Tab-387-4'!J9:L9)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$J$9"},"Tab-387-4'!$J$9",null,"Influence de la régulation","Einfluss Steuerung","Influence de la régulation","Influsso regolazione"]
[{"$f":"CELL(\"address\",'Tab-387-4'!J10:L10)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$J$10"},{"$f":"MID(A115,SEARCH(\"]\",A115)+1,30)","v":"Tab-387-4'!$J$10"},null,"W/m²","W/m²","W/m²","W/m²","W/m²","W/m²"]
[null,null,null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C9)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$9"},{"$f":"MID(A117,SEARCH(\"]\",A117)+1,30)","v":"Tab-387-4'!$C$9"},null,"Conditions d'utilisation","Raumnutzung","Conditions d'utilisation","Tipologia d'utilizzo"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C10)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$10"},{"$f":"MID(A118,SEARCH(\"]\",A118)+1,30)","v":"Tab-387-4'!$C$10"},null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C14)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$14"},"Tab-387-4'!$C$14",null,"Chambre d’hôtel","Hotelzimmer","Chambre d’hôtel","Camera d’albergo"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C15)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$15"},"Tab-387-4'!$C$15",null,"Réception, zone d’accueil","Empfang, Lobby","Réception, zone d’accueil","Ricezione, lobby"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C16)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$16"},"Tab-387-4'!$C$16",null,"Bureau individuel, collectif","Einzel-, Gruppenbüro","Bureau individuel, collectif","Ufficio individuale, collettivo"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C17)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$17"},"Tab-387-4'!$C$17",null,"Bureau paysagé","Grossraumbüro","Bureau paysagé","Open space"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C18)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$18"},"Tab-387-4'!$C$18",null,"Salle de réunion","Sitzungszimmer","Salle de réunion","Sala riunioni"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C19)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$19"},"Tab-387-4'!$C$19",null,"Hall des guichets, zone clientèle","Schalterhalle, Empfang","Hall des guichets, zone clientèle","Sala sportelli, accoglienza"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C20)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$20"},"Tab-387-4'!$C$20",null,"Salle d’école","Schulzimmer","Salle d’école","Locale d’insegnamento"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C21)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$21"},"Tab-387-4'!$C$21",null,"Salle des maîtres","Lehrerzimmer","Salle des maîtres","Sala docenti"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C22)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$22"},"Tab-387-4'!$C$22",null,"Bibliothèque","Bibliothek","Bibliothèque","Biblioteca"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C23)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$23"},"Tab-387-4'!$C$23",null,"Auditoire","Hörsaal","Auditoire","Auditorio"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C24)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$24"},"Tab-387-4'!$C$24",null,"Locaux spéciaux","Schulfachraum","Locaux spéciaux","Aula speciale"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C25)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$25"},"Tab-387-4'!$C$25",null,{"$f":"OFFSET(E130,0,Spind)&\"\"","v":"Magasin d’alimentation"},"Lebensmittelverkauf","Magasin d’alimentation","Negozio alimentare"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C26)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$26"},"Tab-387-4'!$C$26",null,"Magasin spécialisé","Fachgeschäft","Magasin spécialisé","Negozio specializzato"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C27)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$27"},"Tab-387-4'!$C$27",null,"Magasin meubles, bricolage, jardin","Verkauf Möbel, Bau, Garten","Magasin meubles, bricolage, jardin","Vendita mobili, materiali da costruzione e giardinaggio"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C28)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$28"},"Tab-387-4'!$C$28",null,"Restaurant","Restaurant","Restaurant","Ristorante"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C29)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$29"},"Tab-387-4'!$C$29",null,"Restaurant self-service","Selbstbedienungsrestaurant","Restaurant self-service","Ristorante self-service"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C30)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$30"},"Tab-387-4'!$C$30",null,"Cuisine de 6.1","Küche zu Restaurant","Cuisine de 6.1","Cucina da ristorante"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C31)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$31"},"Tab-387-4'!$C$31",null,"Cuisine de 6.2","Küche zu SB-Restaurant","Cuisine de 6.2","Cucina da ristorante self-service "]
[{"$f":"CELL(\"address\",'Tab-387-4'!C32)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$32"},"Tab-387-4'!$C$32",null,"Salle de spectacles","Vorstellungsraum","Salle de spectacles","Sala spettacoli"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C33)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$33"},"Tab-387-4'!$C$33",null,"Salle polyvalente","Mehrzweckhalle","Salle polyvalente","Sala multiuso"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C34)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$34"},"Tab-387-4'!$C$34",null,"Halle d’exposition","Ausstellungshalle","Halle d’exposition","Padiglione d’esposizione"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C35)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$35"},"Tab-387-4'!$C$35",null,"Chambre d’hôpital","Bettenzimmer","Chambre d’hôpital","Camera d’ospedale"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C36)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$36"},"Tab-387-4'!$C$36",null,"Bureau de service hospitalier","Stationszimmer","Bureau de service hospitalier","Camera di reparto"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C37)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$37"},"Tab-387-4'!$C$37",null,"Locaux médicaux","Behandlungsraum","Locaux médicaux","Ambulatorio"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C38)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$38"},"Tab-387-4'!$C$38",null,"Production (travail lourd)","Produktion (grobe Arbeit)","Production (travail lourd)","Produzione (lavoro pesante)"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C39)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$39"},"Tab-387-4'!$C$39",null,"Production (travail fin)","Produktion (feine Arbeit)","Production (travail fin)","Produzione (lavoro fine)"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C40)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$40"},"Tab-387-4'!$C$40",null,"Laboratoire","Laborraum","Laboratoire","Laboratorio"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C41)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$41"},{"$f":"MID(A146,SEARCH(\"]\",A146)+1,30)","v":"Tab-387-4'!$C$41"},null,"Entrepôt","Lagerhalle","Entrepôt","Magazzino"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C42)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$42"},"Tab-387-4'!$C$42",null,"Salle de gymnastique","Turnhalle","Salle de gymnastique","Palestra"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C43)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$43"},"Tab-387-4'!$C$43",null,"Salle de fitness","Fitnessraum","Salle de fitness","Locale fitness"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C44)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$44"},"Tab-387-4'!$C$44",null,"Piscine couverte","Schwimmhalle","Piscine couverte","Piscina coperta"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C45)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$45"},"Tab-387-4'!$C$45",null,"Surfaces de dégagement","Verkehrsfläche","Surfaces de dégagement","Superficie di circolazione"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C46)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$46"},"Tab-387-4'!$C$46",null,"Surfaces de dégagement 24h","Verkehrsfläche 24h","Surfaces de dégagement 24h","Superficie di circolazione 24h"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C47)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$47"},"Tab-387-4'!$C$47",null,"Cage d’escalier","Treppenhaus","Cage d’escalier","Vano scala"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C48)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$48"},"Tab-387-4'!$C$48",null,"Locaux secondaires","Nebenraum","Locaux secondaires","Locale secondario"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C49)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$49"},"Tab-387-4'!$C$49",null,"Cuisine, cuisine à thé","Küche, Teeküche","Cuisine, cuisine à thé","Cucina, piano cottura"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C50)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$50"},"Tab-387-4'!$C$50",null,"WC, salle de bain, douche","WC, Bad, Dusche","WC, salle de bain, douche","WC, bagno, doccia"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C51)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$51"},"Tab-387-4'!$C$51",null,"WC","WC","WC","WC"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C52)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$52"},"Tab-387-4'!$C$52",null,"Vestiaires, douches","Garderobe, Dusche","Vestiaires, douches","Vestiario, doccia"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C53)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$53"},"Tab-387-4'!$C$53",null,"Garage collectif","Parkhaus","Garage collectif","Autorimessa"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C54)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$54"},"Tab-387-4'!$C$54",null,"Buanderie, séchoir","Wasch- und Trockenraum","Buanderie, séchoir","Lavanderia e stenditoio"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C55)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$55"},"Tab-387-4'!$C$55",null,"Chambre froide","Kühlraum","Chambre froide","Cella frigorifera"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C56)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$56"},"Tab-387-4'!$C$56",null,"Salle de serveurs","Serverraum","Salle de serveurs","Locale server"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C13)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$13"},"Tab-387-4'!$C$13","   (Platz frei halten)"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C57)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$57"},"Tab-387-4'!$C$57"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C58)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$58"},"Tab-387-4'!$C$58"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C59)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$59"},"Tab-387-4'!$C$59"]
[{"$f":"CELL(\"address\",'Tab-387-4'!C60)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$60"},"Tab-387-4'!$C$60",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C61)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$61"},"Tab-387-4'!$C$61",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C62)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$62"},"Tab-387-4'!$C$62",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C63)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$63"},"Tab-387-4'!$C$63",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C64)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$64"},"Tab-387-4'!$C$64",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C65)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$65"},"Tab-387-4'!$C$65",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C66)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$66"},"Tab-387-4'!$C$66",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C67)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$67"},"Tab-387-4'!$C$67",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C68)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$68"},"Tab-387-4'!$C$68",null,{"$f":"OFFSET(E174,0,Spind)&\"\"","v":""}]
[{"$f":"CELL(\"address\",'Tab-387-4'!C69)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$69"},"Tab-387-4'!$C$69",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C70)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$70"},"Tab-387-4'!$C$70",null,""]
[{"$f":"CELL(\"address\",'Tab-387-4'!C71)","v":"'[EN-111a_F.xlsm]Tab-387-4'!$C$71"},"Tab-387-4'!$C$71",null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"OFFSET(E194,0,Spind)&\"\"","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"OFFSET(E258,0,Spind)&\"\"","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"OFFSET(E322,0,Spind)&\"\"","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"OFFSET(E386,0,Spind)&\"\"","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]

{"sheet":"Log","index":6,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,"aktuelle Version"]
[null,"Update Log",null,null,null,null,null,{"$f":"OFFSET(H6,H5,0)","v":"V 1.04"}]
[null,null,null,null,null,null,null,"Gültig Bis"]
[null,null,null,null,null,null,null,"2024-12-31"]
[null,null,null,null,null,null,null,{"$f":"COUNTA(H7:H1087)","v":6}]
[null,"von","Datum","Problem","Lösung","erledigt durch","datum","Version"]
[null,null,"2018-08-29",null,"Erstpublikation","SGe ","2018-08-29","V 1.00"]
[null,null,"2018-09-18",null,"Übersetzung italienisch","MFa",null,"V 1.00"]
[null,null,"2018-11-07","Bereitstellung für öffentliche Publikation","Passwortschutz eingeschaltet","CG","2018-11-07","V 1.01"]
[null,null,"2018-12-04","Bereitstellung für öffentliche Publikation","Passwortschutz eingeschaltet","SGe ","2018-12-04","V 1.02"]
[null,null,"2019-01-09","Korrigenda SIA 387/4, Werte der spez. Leistung (Tab. 387/4) angepasst. ","Passwortschutz eingeschaltet","SGe ","2019-01-09","V 1.03"]
[null,null,"2019-12-06","Ablauf des Tools","Laufzeit um 3 Jahre verlängert","SGe ","2019-12-06","V 1.04"]

{"sheet":"Tabelle2","index":7,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Haftungsausschluss"]
[]
["Diese Exceltabelle steht zur freien Verfügung. Die Excelfunktionen sind nicht gesperrt, so dass Manipulationen an der Tabelle möglich sind. Für die Anwendung kann deshalb keine Haftung übernommen werden."]
[]
["Fehler sind per Email zu melden an:"]
["mailto:energie@bd.zh.ch?body=Fehlermeldung%20%0A%0AFehlerart%3A%20%0A%0AZelle%3A%20%0A%0ABeschreibung%3A%20%0A%0AName%2FVorname%3A%0A%0AFirma%2FAdresse%3A%0A%0ATelefon-Nr.%3A%20%0A%0A&subject=Fehlermeldung%20an%20Ch.%20Gm%C3%BCr"]
[]
["Zürich, 01.02.2018"]

{"sheet":"Zielwert","index":8,"n_rows":103,"n_cols":29,"rows_kept":103,"cut":false,"hidden":true,"merged":[[0,0,0,9],[0,10,0,16],[2,2,2,6],[3,23,3,24],[3,25,3,27],[4,2,4,6],[5,2,5,6],[15,15,15,17],[17,3,17,4]]}
["Nachweis spezifische Leistung für Beleuchtungsanlagen \n(Anforderung im Sinne der Norm SIA 387/4)",null,null,null,null,null,null,null,null,null,{"$f":"IF(H12=0,\"\",IF(H12<H13,\"Nachweis erfüllt\",\"Nachweis nicht erfüllt.\"))","v":""},null,null,null,null,null,null,null,null,null,null,"Daten der Raumnutzungen:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"für die Berechnung der Anforderung:"]
["Projektbezeichnung:",null,"Beispiel Präsentation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nr.","Raumnutzung","spezif. Leistung W/m2",null,"Standardnutzungen mit Präsenz"]
["Verantwortlich für Nachweis:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"für Grenzwert","für Zielwert","Dauernde Präsenz","normale Präsenz","sporadische Präsenz"]
["Datum / Unterschrift:",null,{"$f":"TODAY()","v":"2022-12-15"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1,"Hotelzimmer",7.7,5,"x",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,"Empfang, Lobby",6.6,4.3,"x",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1,"Einzel-, Gruppenbüro",12.5,8.1,null,"x",null,2]
["Zusammenstellung / Ergebnis:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2,"Grossraumbüro",9.8000000000000007,6.4,null,"x",null,2]
["Summe aller Nettogeschossflächen",null,null,null,null,null,"① Summe aus Spalte C",null,null,{"$f":"SUM(C19:C103)","v":300}," m²",null,null,null,null,null,null,null,null,null,null,3.3,"Sitzungszimmer",12.5,8.1,null,"x",null,2]
["Summe der elektrischen Leistungen",null,null,null,null,null,"② Summe aus Spalte P",null,null,{"$f":"SUM(P19:P103)","v":2020}," W",null,null,null,null,null,null,null,null,null,null,3.4,"Schalterhalle, Empfang",7.1,4.5999999999999996,"x",null,null,0]
["Projektwert Beleuchtung",null,null,null,null,null,"③ = ②/①",null,null,{"$f":"J11/J10","v":6.7333333333333334}," W/ m²",null,null,null,null,null,null,null,null,null,null,"x",null,0,0]
["Anforderung Beleuchtung",null,null,null,null,null,"④ flächengewichteter Mittelwert",null,null,{"$f":"SUMPRODUCT(C19:C103,J19:J103)/J10","v":4.9000000000000004}," W/ m²",null,null,null,null,null,null,null,null,null,null,4.0999999999999996,"Schulzimmer",11,7.2,null,"x",null,2]
["Anforderung eingehalten?",null,null,null,null,null,"Prüfung ③ kleiner gleich ④",null,null,{"$f":"IF(J12=0,\"\",IF(J12<J13,\"erfüllt\",\"nicht i.O.\"))","v":"nicht i.O."},null,null,null,null,null,null,null,null,null,null,null,4.2,"Lehrerzimmer",7.5,4.9000000000000004,null,"x",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3,"Bibliothek",5.9,3.8,null,"x",null,2]
["Bestimmung Nettogeschossfläche und Grenzwert:",null,null,null,null,null,null,null,null,null,null,null,"Leuchten ",null,null,"evtl. Berechnung der Leistung",null,null,null,null,null,4.4000000000000004,"Hörsaal",9.8000000000000007,6.4,null,"x",null,2]
["Nr.","Raum/Räume","①\nFlächen","\nPräsenz-\nmelder","\nTages-\nlicht-\nsteuerung","Nutzung gemäss SIA 2024",null,"Steuerungs\npunkt gemäss Norm","installierte Steuerung","④\nAnforderung \npV","\nSumme Anforderung\nP_el",null,"Nr.","Leuchten-Typ /\nLeuchten pro Nutzung","Leistung \nPel Total","②\nPel","Anzahl\nLeuchten","Leistung\nLeuchte","Projekt\nwert",null,null,4.5,"Schulfachraum",11,7.2,null,"x",null,2]
[null,null,"m²","0 = Nein; 1 =Ja",null,"Nr.","Bezeichnung",null,null,"W/m²","W",null,null,null,"W","W","Stück","W","W/m2",null,null,5.0999999999999996,"Lebensmittelverkauf",14.9,9.6999999999999993,"x",null,null,0]
[1,"Empfang",100,1,0,2.2000000000000002,{"$f":"VLOOKUP(F19,$V$6:$Y$49,2,FALSE)","v":"Empfang, Lobby"},{"$f":"VLOOKUP(F19,$V$6:$AC$49,8,FALSE)","v":0},{"$f":"IF(H19=1,H19+1-(2*D19+E19),H19-(D19+E19))","v":-1},{"$f":"VLOOKUP(F19,$V$6:$Y$49,4,FALSE)","v":4.3},{"$f":"J19*C19","v":430},null,1.1000000000000001,"Stehleuchte",null,{"$f":"IF(O19<=0,Q19*R19,O19)","v":1000},10,100,{"$f":"IF(C19=0,0,P19/C19)","v":10},null,null,5.2,"Fachgeschäft",14.9,9.6999999999999993,"x",null,null,0]
[2,"Gang",100,0,0,12.1,"Verkehrsfläche",1,{"$f":"IF(H20=1,H20+1-(2*D20+E20),H20-(D20+E20))","v":2},{"$f":"VLOOKUP(F20,$V$6:$Y$49,4,FALSE)","v":2.2999999999999998},229.99999999999997,null,1.2,"Empfangleuchten",600,600,null,null,6,null,null,5.3,"Verkauf Möbel, Bau, Garten",12,7.8,"x",null,null,0]
[3,"Büro",100,0,0,3.1,"Einzel-, Gruppenbüro",2,2,{"$f":"VLOOKUP(F21,$V$6:$Y$49,4,FALSE)","v":8.1},810,null,1.3,"Downlight",null,420,20,21,4.2,null,null,6.1,"Restaurant",5.9,3.8,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,{"$f":"IF(I22<=0,VLOOKUP(F22,$V$6:$Y$49,3,FALSE),IF(I22=2,(VLOOKUP(F22,$V$6:$Y$49,4,FALSE)),IF(I22=1,(((VLOOKUP(F22,$V$6:$Y$49,3,FALSE))-(VLOOKUP(F22,$V$6:$Y$49,4,FALSE)))/2+(VLOOKUP(F22,$V$6:$Y$49,4,FALSE))))))","v":0},0,null,null,null,null,0,null,null,0,null,null,6.2,"Selbstbedienungsrestaurant",3.5,2.2999999999999998,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,6.3,"Küche zu Restaurant",18.8,12.2,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,6.4,"Küche zu SB-Restaurant",14.7,9.5,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,7.1,"Vorstellungsraum",7,4.5,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,7.2,"Mehrzweckhalle",7,4.5,null,null,null,0]
[null,null,null,0,0,"x",0,null,0,0,0,null,null,null,null,0,null,null,0,null,null,7.3,"Ausstellungshalle",7,4.5,null,null,null,0]
[null,null,null,0,0,"x",0,{"$f":"VLOOKUP(F28,$V$6:$AC$49,8,FALSE)","v":0},0,0,0,null,null,null,null,{"$f":"IF(O28>=0,Q28*R28,O28)","v":0},null,null,0,null,null,8.1,"Bettenzimmer",6.8,4.4000000000000004,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,8.1999999999999993,"Stationszimmer",12.5,8.1,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,8.3000000000000007,"Behandlungsraum",12.5,8.1,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,9.1,"Produktion (grobe Arbeit)",7,4.5,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,9.1999999999999993,"Produktion (feine Arbeit)",11.6,7.5,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,9.3000000000000007,"Laborraum",12.8,8.3000000000000007,"x",null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,10.1,"Lagerhalle",7.3,4.7,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,11.1,"Turnhalle",11.3,7.3,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,11.2,"Fitnessraum",6.4,4.0999999999999996,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,11.3,"Schwimmhalle",7.3,4.7,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.1,"Verkehrsfläche",3.5,2.2999999999999998,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.2,"Verkehrsfläche 24h (Spitäler)",7.1,4.5999999999999996,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.3,"Treppenhaus",7.1,4.5999999999999996,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.4,"Nebenraum",3,1.9,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.5,"Küche, Teeküche",5.0999999999999996,3.3,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.6,"WC, Bad, Dusche",6,3.9,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.7,"WC",9.9,6.4,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.8,"Garderobe, Dusche",5.7,3.7,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.9,"Parkhaus",1.4,0.9,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,13.1,"Wasch- und Trockenraum",8.5,5.5,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.11,"Kühlraum",2.8,1.8,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.12,"Serverraum",3.3,2.2000000000000002,"x",null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",{"$f":"VLOOKUP(F83,$V$6:$Y$49,2,FALSE)","v":0},0,0,{"$f":"IF(I83<=0,VLOOKUP(F83,$V$6:$Y$49,3,FALSE),IF(I83=2,(VLOOKUP(F83,$V$6:$Y$49,4,FALSE)),IF(I83=1,(((VLOOKUP(F83,$V$6:$Y$49,3,FALSE))-(VLOOKUP(F83,$V$6:$Y$49,4,FALSE)))/2+(VLOOKUP(F83,$V$6:$Y$49,4,FALSE))))))","v":0},{"$f":"J83*C83","v":0},null,null,null,null,0,null,null,{"$f":"IF(C83=0,0,P83/C83)","v":0}]
[null,null,null,0,0,"x",0,0,{"$f":"IF(H84=1,H84+1-(2*D84+E84),H84-(D84+E84))","v":0},0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,{"$f":"VLOOKUP(F92,$V$6:$AC$49,8,FALSE)","v":0},0,0,0,null,null,null,null,{"$f":"IF(O92>=0,Q92*R92,O92)","v":0},null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]

{"sheet":"Minergie","index":9,"n_rows":103,"n_cols":29,"rows_kept":103,"cut":false,"hidden":true,"merged":[[0,0,0,9],[0,10,0,16],[2,2,2,6],[3,23,3,24],[3,25,3,27],[4,2,4,6],[5,2,5,6],[15,15,15,17],[17,3,17,4]]}
["Nachweis spezifische Leistung für Beleuchtungsanlagen \n(Anforderung im Sinne der Norm SIA 387/4)",null,null,null,null,null,null,null,null,null,{"$f":"IF(H12=0,\"\",IF(H12<H13,\"Nachweis erfüllt\",\"Nachweis nicht erfüllt.\"))","v":""},null,null,null,null,null,null,null,null,null,null,"Daten der Raumnutzungen:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"für die Berechnung der Anforderung:"]
["Projektbezeichnung:",null,"Beispiel Präsentation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nr.","Raumnutzung","spezif. Leistung W/m2",null,"Standardnutzungen mit Präsenz"]
["Verantwortlich für Nachweis:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"für Grenzwert","für Zielwert","Dauernde Präsenz","normale Präsenz","sporadische Präsenz"]
["Datum / Unterschrift:",null,{"$f":"TODAY()","v":"2022-12-15"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1,"Hotelzimmer",7.7,5,"x",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,"Empfang, Lobby",6.6,4.3,"x",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1,"Einzel-, Gruppenbüro",12.5,8.1,null,"x",null,2]
["Zusammenstellung / Ergebnis:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2,"Grossraumbüro",9.8000000000000007,6.4,null,"x",null,2]
["Summe aller Nettogeschossflächen",null,null,null,null,null,"① Summe aus Spalte C",null,null,{"$f":"SUM(C19:C103)","v":300}," m²",null,null,null,null,null,null,null,null,null,null,3.3,"Sitzungszimmer",12.5,8.1,null,"x",null,2]
["Summe der elektrischen Leistungen",null,null,null,null,null,"② Summe aus Spalte P",null,null,{"$f":"SUM(P19:P103)","v":2020}," W",null,null,null,null,null,null,null,null,null,null,3.4,"Schalterhalle, Empfang",7.1,4.5999999999999996,"x",null,null,0]
["Projektwert Beleuchtung",null,null,null,null,null,"③ = ②/①",null,null,{"$f":"J11/J10","v":6.7333333333333334}," W/ m²",null,null,null,null,null,null,null,null,null,null,"x",null,0,0]
["Anforderung Beleuchtung",null,null,null,null,null,"④ flächengewichteter Mittelwert",null,null,{"$f":"SUMPRODUCT(C19:C103,J19:J103)/J10","v":6.2166666666666668}," W/ m²",null,null,null,null,null,null,null,null,null,null,4.0999999999999996,"Schulzimmer",11,7.2,null,"x",null,2]
["Anforderung eingehalten?",null,null,null,null,null,"Prüfung ③ kleiner gleich ④",null,null,{"$f":"IF(J12=0,\"\",IF(J12<J13,\"erfüllt\",\"nicht i.O.\"))","v":"nicht i.O."},null,null,null,null,null,null,null,null,null,null,null,4.2,"Lehrerzimmer",7.5,4.9000000000000004,null,"x",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3,"Bibliothek",5.9,3.8,null,"x",null,2]
["Bestimmung Nettogeschossfläche und Grenzwert:",null,null,null,null,null,null,null,null,null,null,null,"Leuchten ",null,null,"evtl. Berechnung der Leistung",null,null,null,null,null,4.4000000000000004,"Hörsaal",9.8000000000000007,6.4,null,"x",null,2]
["Nr.","Raum/Räume","①\nFlächen","\nPräsenz-\nmelder","\nTages-\nlicht-\nsteuerung","Nutzung gemäss SIA 2024",null,"Steuerungs\npunkt gemäss Norm","installierte Steuerung","④\nAnforderung \npV","\nSumme Anforderung\nP_el",null,"Nr.","Leuchten-Typ /\nLeuchten pro Nutzung","Leistung \nPel Total","②\nPel","Anzahl\nLeuchten","Leistung\nLeuchte","Projekt\nwert",null,null,4.5,"Schulfachraum",11,7.2,null,"x",null,2]
[null,null,"m²","0 = Nein; 1 =Ja",null,"Nr.","Bezeichnung",null,null,"W/m²","W",null,null,null,"W","W","Stück","W","W/m2",null,null,5.0999999999999996,"Lebensmittelverkauf",14.9,9.6999999999999993,"x",null,null,0]
[1,"Empfang",100,1,0,2.2000000000000002,{"$f":"VLOOKUP(F19,$V$6:$Y$49,2,FALSE)","v":"Empfang, Lobby"},{"$f":"VLOOKUP(F19,$V$6:$AC$49,8,FALSE)","v":0},{"$f":"IF(H19=1,H19+1-(2*D19+E19),H19-(D19+E19))","v":-1},{"$f":"(((VLOOKUP(F19,$V$6:$Y$49,3,FALSE))-(VLOOKUP(F19,$V$6:$Y$49,4,FALSE)))/2+(VLOOKUP(F19,$V$6:$Y$49,4,FALSE)))","v":5.4499999999999993},{"$f":"J19*C19","v":544.99999999999989},null,1.1000000000000001,"Stehleuchte",null,{"$f":"IF(O19<=0,Q19*R19,O19)","v":1000},10,100,{"$f":"IF(C19=0,0,P19/C19)","v":10},null,null,5.2,"Fachgeschäft",14.9,9.6999999999999993,"x",null,null,0]
[2,"Gang",100,0,0,12.1,"Verkehrsfläche",1,{"$f":"IF(H20=1,H20+1-(2*D20+E20),H20-(D20+E20))","v":2},{"$f":"(((VLOOKUP(F20,$V$6:$Y$49,3,FALSE))-(VLOOKUP(F20,$V$6:$Y$49,4,FALSE)))/2+(VLOOKUP(F20,$V$6:$Y$49,4,FALSE)))","v":2.9},290,null,1.2,"Empfangleuchten",600,600,null,null,6,null,null,5.3,"Verkauf Möbel, Bau, Garten",12,7.8,"x",null,null,0]
[3,"Büro",100,0,0,3.1,"Einzel-, Gruppenbüro",2,2,{"$f":"(((VLOOKUP(F21,$V$6:$Y$49,3,FALSE))-(VLOOKUP(F21,$V$6:$Y$49,4,FALSE)))/2+(VLOOKUP(F21,$V$6:$Y$49,4,FALSE)))","v":10.3},1030,null,1.3,"Downlight",null,420,20,21,4.2,null,null,6.1,"Restaurant",5.9,3.8,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,{"$f":"IF(I22<=0,VLOOKUP(F22,$V$6:$Y$49,3,FALSE),IF(I22=2,(VLOOKUP(F22,$V$6:$Y$49,4,FALSE)),IF(I22=1,(((VLOOKUP(F22,$V$6:$Y$49,3,FALSE))-(VLOOKUP(F22,$V$6:$Y$49,4,FALSE)))/2+(VLOOKUP(F22,$V$6:$Y$49,4,FALSE))))))","v":0},0,null,null,null,null,0,null,null,0,null,null,6.2,"Selbstbedienungsrestaurant",3.5,2.2999999999999998,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,6.3,"Küche zu Restaurant",18.8,12.2,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,6.4,"Küche zu SB-Restaurant",14.7,9.5,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,7.1,"Vorstellungsraum",7,4.5,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,7.2,"Mehrzweckhalle",7,4.5,null,null,null,0]
[null,null,null,0,0,"x",0,null,0,0,0,null,null,null,null,0,null,null,0,null,null,7.3,"Ausstellungshalle",7,4.5,null,null,null,0]
[null,null,null,0,0,"x",0,{"$f":"VLOOKUP(F28,$V$6:$AC$49,8,FALSE)","v":0},0,0,0,null,null,null,null,{"$f":"IF(O28>=0,Q28*R28,O28)","v":0},null,null,0,null,null,8.1,"Bettenzimmer",6.8,4.4000000000000004,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,8.1999999999999993,"Stationszimmer",12.5,8.1,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,8.3000000000000007,"Behandlungsraum",12.5,8.1,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,9.1,"Produktion (grobe Arbeit)",7,4.5,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,9.1999999999999993,"Produktion (feine Arbeit)",11.6,7.5,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,9.3000000000000007,"Laborraum",12.8,8.3000000000000007,"x",null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,10.1,"Lagerhalle",7.3,4.7,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,11.1,"Turnhalle",11.3,7.3,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,11.2,"Fitnessraum",6.4,4.0999999999999996,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,11.3,"Schwimmhalle",7.3,4.7,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.1,"Verkehrsfläche",3.5,2.2999999999999998,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.2,"Verkehrsfläche 24h (Spitäler)",7.1,4.5999999999999996,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.3,"Treppenhaus",7.1,4.5999999999999996,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.4,"Nebenraum",3,1.9,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.5,"Küche, Teeküche",5.0999999999999996,3.3,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.6,"WC, Bad, Dusche",6,3.9,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.7,"WC",9.9,6.4,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.8,"Garderobe, Dusche",5.7,3.7,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.9,"Parkhaus",1.4,0.9,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,13.1,"Wasch- und Trockenraum",8.5,5.5,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.11,"Kühlraum",2.8,1.8,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.12,"Serverraum",3.3,2.2000000000000002,"x",null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",{"$f":"VLOOKUP(F83,$V$6:$Y$49,2,FALSE)","v":0},0,0,{"$f":"IF(I83<=0,VLOOKUP(F83,$V$6:$Y$49,3,FALSE),IF(I83=2,(VLOOKUP(F83,$V$6:$Y$49,4,FALSE)),IF(I83=1,(((VLOOKUP(F83,$V$6:$Y$49,3,FALSE))-(VLOOKUP(F83,$V$6:$Y$49,4,FALSE)))/2+(VLOOKUP(F83,$V$6:$Y$49,4,FALSE))))))","v":0},{"$f":"J83*C83","v":0},null,null,null,null,0,null,null,{"$f":"IF(C83=0,0,P83/C83)","v":0}]
[null,null,null,0,0,"x",0,0,{"$f":"IF(H84=1,H84+1-(2*D84+E84),H84-(D84+E84))","v":0},0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,{"$f":"VLOOKUP(F92,$V$6:$AC$49,8,FALSE)","v":0},0,0,0,null,null,null,null,{"$f":"IF(O92>=0,Q92*R92,O92)","v":0},null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]

{"sheet":"Grenzwert","index":10,"n_rows":103,"n_cols":29,"rows_kept":103,"cut":false,"hidden":true,"merged":[[0,0,0,9],[0,10,0,16],[2,2,2,6],[3,23,3,24],[3,25,3,27],[4,2,4,6],[5,2,5,6],[15,15,15,17],[17,3,17,4]]}
["Nachweis spezifische Leistung für Beleuchtungsanlagen \n(Anforderung im Sinne der Norm SIA 387/4)",null,null,null,null,null,null,null,null,null,{"$f":"IF(H12=0,\"\",IF(H12<H13,\"Nachweis erfüllt\",\"Nachweis nicht erfüllt.\"))","v":""},null,null,null,null,null,null,null,null,null,null,"Daten der Raumnutzungen:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"für die Berechnung der Anforderung:"]
["Projektbezeichnung:",null,"Beispiel Präsentation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nr.","Raumnutzung","spezif. Leistung W/m2",null,"Standardnutzungen mit Präsenz"]
["Verantwortlich für Nachweis:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"für Grenzwert","für Zielwert","Dauernde Präsenz","normale Präsenz","sporadische Präsenz"]
["Datum / Unterschrift:",null,{"$f":"TODAY()","v":"2022-12-15"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1,"Hotelzimmer",7.7,5,"x",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,"Empfang, Lobby",6.6,4.3,"x",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1,"Einzel-, Gruppenbüro",12.5,8.1,null,"x",null,2]
["Zusammenstellung / Ergebnis:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2,"Grossraumbüro",9.8000000000000007,6.4,null,"x",null,2]
["Summe aller Nettogeschossflächen",null,null,null,null,null,"① Summe aus Spalte C",null,null,{"$f":"SUM(C19:C103)","v":300}," m²",null,null,null,null,null,null,null,null,null,null,3.3,"Sitzungszimmer",12.5,8.1,null,"x",null,2]
["Summe der elektrischen Leistungen",null,null,null,null,null,"② Summe aus Spalte P",null,null,{"$f":"SUM(P19:P103)","v":2020}," W",null,null,null,null,null,null,null,null,null,null,3.4,"Schalterhalle, Empfang",7.1,4.5999999999999996,"x",null,null,0]
["Projektwert Beleuchtung",null,null,null,null,null,"③ = ②/①",null,null,{"$f":"J11/J10","v":6.7333333333333334}," W/ m²",null,null,null,null,null,null,null,null,null,null,"x",null,0,0]
["Anforderung Beleuchtung",null,null,null,null,null,"④ flächengewichteter Mittelwert",null,null,{"$f":"SUMPRODUCT(C19:C103,J19:J103)/J10","v":7.5333333333333332}," W/ m²",null,null,null,null,null,null,null,null,null,null,4.0999999999999996,"Schulzimmer",11,7.2,null,"x",null,2]
["Anforderung eingehalten?",null,null,null,null,null,"Prüfung ③ kleiner gleich ④",null,null,{"$f":"IF(J12=0,\"\",IF(J12<J13,\"erfüllt\",\"nicht i.O.\"))","v":"erfüllt"},null,null,null,null,null,null,null,null,null,null,null,4.2,"Lehrerzimmer",7.5,4.9000000000000004,null,"x",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3,"Bibliothek",5.9,3.8,null,"x",null,2]
["Bestimmung Nettogeschossfläche und Grenzwert:",null,null,null,null,null,null,null,null,null,null,null,"Leuchten ",null,null,"evtl. Berechnung der Leistung",null,null,null,null,null,4.4000000000000004,"Hörsaal",9.8000000000000007,6.4,null,"x",null,2]
["Nr.","Raum/Räume","①\nFlächen","\nPräsenz-\nmelder","\nTages-\nlicht-\nsteuerung","Nutzung gemäss SIA 2024",null,"Steuerungs\npunkt gemäss Norm","installierte Steuerung","④\nAnforderung \npV","\nSumme Anforderung\nP_el",null,"Nr.","Leuchten-Typ /\nLeuchten pro Nutzung","Leistung \nPel Total","②\nPel","Anzahl\nLeuchten","Leistung\nLeuchte","Projekt\nwert",null,null,4.5,"Schulfachraum",11,7.2,null,"x",null,2]
[null,null,"m²","0 = Nein; 1 =Ja",null,"Nr.","Bezeichnung",null,null,"W/m²","W",null,null,null,"W","W","Stück","W","W/m2",null,null,5.0999999999999996,"Lebensmittelverkauf",14.9,9.6999999999999993,"x",null,null,0]
[1,"Empfang",100,1,0,2.2000000000000002,{"$f":"VLOOKUP(F19,$V$6:$Y$49,2,FALSE)","v":"Empfang, Lobby"},{"$f":"VLOOKUP(F19,$V$6:$AC$49,8,FALSE)","v":0},{"$f":"IF(H19=1,H19+1-(2*D19+E19),H19-(D19+E19))","v":-1},{"$f":"VLOOKUP(F19,$V$6:$Y$49,3,FALSE)","v":6.6},{"$f":"J19*C19","v":660},null,1.1000000000000001,"Stehleuchte",null,{"$f":"IF(O19<=0,Q19*R19,O19)","v":1000},10,100,{"$f":"IF(C19=0,0,P19/C19)","v":10},null,null,5.2,"Fachgeschäft",14.9,9.6999999999999993,"x",null,null,0]
[2,"Gang",100,0,0,12.1,"Verkehrsfläche",1,{"$f":"IF(H20=1,H20+1-(2*D20+E20),H20-(D20+E20))","v":2},{"$f":"VLOOKUP(F20,$V$6:$Y$49,3,FALSE)","v":3.5},350,null,1.2,"Empfangleuchten",600,600,null,null,6,null,null,5.3,"Verkauf Möbel, Bau, Garten",12,7.8,"x",null,null,0]
[3,"Büro",100,0,0,3.1,"Einzel-, Gruppenbüro",2,2,12.5,1250,null,1.3,"Downlight",null,420,20,21,4.2,null,null,6.1,"Restaurant",5.9,3.8,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,6.2,"Selbstbedienungsrestaurant",3.5,2.2999999999999998,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,6.3,"Küche zu Restaurant",18.8,12.2,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,6.4,"Küche zu SB-Restaurant",14.7,9.5,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,7.1,"Vorstellungsraum",7,4.5,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,7.2,"Mehrzweckhalle",7,4.5,null,null,null,0]
[null,null,null,0,0,"x",0,null,0,0,0,null,null,null,null,0,null,null,0,null,null,7.3,"Ausstellungshalle",7,4.5,null,null,null,0]
[null,null,null,0,0,"x",0,{"$f":"VLOOKUP(F28,$V$6:$AC$49,8,FALSE)","v":0},0,{"$f":"IF(I28<=0,VLOOKUP(F28,$V$6:$Y$49,3,FALSE),IF(I28=2,(VLOOKUP(F28,$V$6:$Y$49,4,FALSE)),IF(I28=1,(((VLOOKUP(F28,$V$6:$Y$49,3,FALSE))-(VLOOKUP(F28,$V$6:$Y$49,4,FALSE)))/2+(VLOOKUP(F28,$V$6:$Y$49,4,FALSE))))))","v":0},0,null,null,null,null,{"$f":"IF(O28>=0,Q28*R28,O28)","v":0},null,null,0,null,null,8.1,"Bettenzimmer",6.8,4.4000000000000004,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,8.1999999999999993,"Stationszimmer",12.5,8.1,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,8.3000000000000007,"Behandlungsraum",12.5,8.1,null,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,9.1,"Produktion (grobe Arbeit)",7,4.5,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,9.1999999999999993,"Produktion (feine Arbeit)",11.6,7.5,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,9.3000000000000007,"Laborraum",12.8,8.3000000000000007,"x",null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,10.1,"Lagerhalle",7.3,4.7,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,11.1,"Turnhalle",11.3,7.3,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,11.2,"Fitnessraum",6.4,4.0999999999999996,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,11.3,"Schwimmhalle",7.3,4.7,null,"x",null,2]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.1,"Verkehrsfläche",3.5,2.2999999999999998,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.2,"Verkehrsfläche 24h (Spitäler)",7.1,4.5999999999999996,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.3,"Treppenhaus",7.1,4.5999999999999996,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.4,"Nebenraum",3,1.9,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.5,"Küche, Teeküche",5.0999999999999996,3.3,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.6,"WC, Bad, Dusche",6,3.9,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.7,"WC",9.9,6.4,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.8,"Garderobe, Dusche",5.7,3.7,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.9,"Parkhaus",1.4,0.9,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,13.1,"Wasch- und Trockenraum",8.5,5.5,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.11,"Kühlraum",2.8,1.8,null,null,"x",1]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0,null,null,12.12,"Serverraum",3.3,2.2000000000000002,"x",null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",{"$f":"VLOOKUP(F83,$V$6:$Y$49,2,FALSE)","v":0},0,0,0,{"$f":"J83*C83","v":0},null,null,null,null,0,null,null,{"$f":"IF(C83=0,0,P83/C83)","v":0}]
[null,null,null,0,0,"x",0,0,{"$f":"IF(H84=1,H84+1-(2*D84+E84),H84-(D84+E84))","v":0},0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,{"$f":"IF(I86<=0,VLOOKUP(F86,$V$6:$Y$49,3,FALSE),IF(I86=2,(VLOOKUP(F86,$V$6:$Y$49,4,FALSE)),IF(I86=1,(((VLOOKUP(F86,$V$6:$Y$49,3,FALSE))-(VLOOKUP(F86,$V$6:$Y$49,4,FALSE)))/2+(VLOOKUP(F86,$V$6:$Y$49,4,FALSE))))))","v":0},0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,{"$f":"VLOOKUP(F92,$V$6:$AC$49,8,FALSE)","v":0},0,0,0,null,null,null,null,{"$f":"IF(O92>=0,Q92*R92,O92)","v":0},null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]
[null,null,null,0,0,"x",0,0,0,0,0,null,null,null,null,0,null,null,0]