{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Allgemeine Daten","Technische Daten","Verbrauchserfassung","Gebäudesteckbrief","Check-Liste"],"not_rendered":{"charts":1,"images":9,"macros":1,"external_links":0,"defined_names":13,"comments":0,"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":"Allgemeine Daten","index":0,"n_rows":74,"n_cols":27,"rows_kept":74,"cut":false,"hidden":false,"merged":[[37,2,37,3],[37,4,37,5],[1,1,1,5],[3,1,3,3],[6,2,6,5],[13,2,13,3],[10,1,11,1],[27,1,32,1],[20,1,22,1],[23,2,23,5],[24,1,25,1],[25,2,25,3],[17,1,19,1],[9,2,9,3],[34,1,35,1],[14,2,14,3],[41,2,41,5],[42,2,42,5],[43,2,43,5],[44,2,44,5],[40,2,40,5]]}
[]
[null,"Erfassung Gebäudedaten"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pfarrkirche",null,"Pfarrkirche",null,null,null,"Abensberg-Mainburg"]
[null,"Allgemeine Daten",null,null,null,null,null,null,null,null,null,null,"Sonstige bestehende Kirche",null,"Sonstige bestehende Kirche",null,null,null,"Alteglofsheim-Schierling"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pfarrhaus",null,"Pfarrhaus",null,null,null,"Amberg-Ensdorf"]
[null,"Region ",null,null,null,null,null,null,null,null,null,null,"Wohnhaus (Mietobjekt)",null,"Pfarr- und Jugendheim",null,null,null,"Bogenberg-Pondorf"]
[null,"Dekanat",null,null,null,null,null,null,null,null,null,null,"Pfarr- und Jugendheim",null,"Kirchenzentrum / Pfarrzentrum",null,null,null,"Cham"]
[null,"Landkreis",null,null,null,null,null,null,null,null,null,null,"Kindertagesstätte",null,"Kindertagesstätte",null,null,null,"Deggendorf-Plattling"]
[null,"Katholische Kirchenstiftung",null,null,null,null,null,null,null,null,null,null,"Altenheim / Seelsorgeinrichtungen",null,"Altenheim / Seelsorgeinrichtungen",null,null,null,"Dingolfing"]
[null,"Bauwerk: Bezeichnung",null,null,null,null,null,null,null,null,null,null,"Schwesternheim",null,"Sonstige Gebäude",null,null,null,"Donaustauf"]
[null,"Anschrift des Gebäudes",null,null,null,null,null,null,null,null,null,null,"Bibliothek",null,null,null,null,null,"Eggenfelden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Wohngebäude",null,"Hauptgebäude",null,null,null,"Frontenhausen-Pilsting"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pfarrzentrum",null,"Anbau",null,null,null,"Geiselhöring"]
[null,"Datum",{"$f":"TODAY()","v":"2016-06-08"},null,null,null,null,null,null,null,null,null,"Sonstige",null,"UG Keller",null,null,null,"Geisenfeld"]
[null,"Erfassungsjahr",{"$f":"IF(Verbrauchserfassung!C6=\"\",\"\",Verbrauchserfassung!C6)","v":2014},null,null,null,null,null,null,null,null,null,null,null,"1. Geschoss",null,null,null,"Kelheim"]
[null,"Bauwerk: Typ",null,null,null,null,null,null,"Mehrfachnutzung",false,null,null,null,null,"2. Geschoss",null,null,null,"Kemnath-Wunsiedel"]
[null,"Bemerkungen zum Nutzerverhalten",null,null,null,null,null,null,"Vermietung",false,null,null,null,null,"3. Geschoss",null,null,null,"Kötzting"]
[null,"Mehrfachnutzung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Laaber"]
[null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"Landshut-Altheim"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leuchtenberg"]
[null,"Vermietung",null,null,null,null,null,"ja",null,null,null,null,null,null,null,null,null,null,"Nabburg"]
[null,null,null,null,null,null,null,"nein",null,null,null,null,null,null,null,null,null,null,"Neunburg-Oberviechtach"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Neustadt/Waldnaab"]
[null,"Gebäudeform","Lageplan beifügen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pförring",null,null,null,null,"Anlage: Pdf-Datei"]
[null,"Baualter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regensburg (Land)"]
[null,null,"Baualtersklasse",null,{"$f":"IF(C25=O27,P29,0)+IF(O28=C25,P30,0)+IF(O29=C25,P31,0)+IF(O30=C25,P32,0)+IF(O31=C25,P33,0)+IF(O32=C25,P34,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Regenstauf"]
[null,"Baujahr",null,null,null,null,null,null,null,null,null,null,null,null,"bis 1918",null,null,null,"Roding"]
[null,"Durchgeführte Sanierungsmaßnahmen: Gebäudehülle",null,null,null,"Jahr der Sanierung",null,null,null,null,null,null,null,null,"1919 bis 1948",null,null,null,"Rottenburg"]
[null,null,"Kellerdecken",null,null,null,null,null,null,null,null,null,null,null,"1949 bis 1978",1,null,null,"Schwandorf",null,null,null,"mit Dämmung ","Jahr der San."]
[null,null,"Außen/Innenwand",null,null,null,null,null,null,null,null,null,null,null,"1979 bis 1994",2,null,null,"Stadt Amberg",null,null,null,"ohne Dämmung"]
[null,null,"Dach/Decke",null,null,null,null,null,null,null,null,null,null,null,"1995 bis 2001",3,null,null,"Stadt Landshut",null,null,null,"k.A"]
[null,null,"Fenster",null,null,null,null,null,null,null,null,null,null,null,"ab 2002",4,null,null,"Stadt Regensburg",null,null,null,"Wärmedämmverbundsystem "]
[null,null,"Türen",null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,"Stadt Straubing",null,null,null,"Vorhangfassade"]
[null,"Anmerkungen zu den Sanierungsmaßnahmen",null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,"Stadt Weiden",null,null,null,"Innenwanddämmung"]
[null,"Durchgeführte Sanierungsmaßnahmen: Anlagentechnik","Pumpen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Straubing (Land)",null,null,null,"k.A."]
[null,null,"Heizungsanlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sulzbach-Hirschau",null,null,null,"Aufsparrendämmung"]
[null,"Beheizte Fläche in m2",null,"m2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tirschenreuth",null,null,null,"Zwischensparrendämmung "]
[null,"Berechnung Nutzfläche über…","Detaillierte Grundrisspläne",null,"Gebäudeumrisse                         (keine Pläne vorhanden)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Viechtach",null,null,null,"Untersparrendämmung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Denkmalschutz",null,null,null,"Vilsbiburg",null,null,null,"Kombination"]
[null,"Besonderheit (z.B. Denkmalschutz)",null,null,null,null,null,null,null,null,null,null,null,null,"Ensembleschutz",null,null,null,"Weiden",null,null,null,"unbekannt"]
[null,"Kontaktperson:",null,null,null,null,null,null,null,null,null,null,null,null,"Keine Besonderheiten",null,null,null,null,null,null,null,"Dämmung oberste Geschossdecke begehbar"]
[null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k.A."]
[null,"Anschrift",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Restaurierung Fenster"]
[null,"Telefon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Komplettaustausch Fenster"]
[null,"E-Mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k.A."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Restaurierung Türen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Komplettaustausch Türen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k.A.",null,"Nach Energieträger sortieren --> Untereinander"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heizzentrale","Weitere Boiler vorhanden? Ja/Nein --> Anzahl und Leistung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eigenes Feld: Solarthermie und PV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fläche "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Installierte Leistung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jährliche Stromeinspeisung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stromeigennutzung --> Ja/Nein"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eigenes Feld: Lüftungsanlagen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vorhanden?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wird sie genutzt?",null,"Heizung --> Ja/Nein"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kühlung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Be-/Entfeuchtung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eigenes Feld: Beleuchtung",null,null,"Wärmerückgewinnung"]

{"sheet":"Technische Daten","index":1,"n_rows":72,"n_cols":15,"rows_kept":72,"cut":false,"hidden":false,"merged":[[24,1,24,2],[42,3,42,5],[23,1,23,5],[21,4,21,5],[37,1,37,3],[1,1,1,5],[62,1,62,3],[15,2,15,5],[46,1,46,3],[3,1,3,3],[7,2,7,5],[12,1,12,5],[26,1,26,5],[27,3,27,5],[27,1,27,2],[30,1,30,3],[20,1,20,5],[24,4,24,5]]}
[]
[null,"Erfassung Technische Daten"]
[]
[null,"Technische Daten Heizungssystem",null,null,null,null,null,null,null,null,null,null,null,null,"Heizöl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erdgas"]
[null,"Energieträger I",null,null,null,null,null,null,null,null,null,null,null,null,"Flüssiggas"]
[null,"Nennwärmeleistung I",null,"kW",null,null,null,null,null,null,null,null,null,null,"Pflanzenöl"]
[null,null,"Energieträger I",null,null,null,null,null,null,null,null,null,null,null,"Hackschnitzel"]
[null,"Hersteller",null,null,null,null,null,null,null,null,null,null,null,null,"Pellets"]
[null,"Typenbezeichnung",null,null,null,null,null,null,null,null,null,null,null,null,"Holz"]
[null,"Baujahr",null,null,null,null,null,null,null,null,null,null,null,null,"Strom"]
[null,"Anmerkungen",null,null,null,null,null,null,null,null,null,null,null,null,"Wärmepumpe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solarthermie"]
[null,"Energieträger II",null,null,null,null,null,null,null,null,null,null,null,null,"Strom"]
[null,"Nennwärmeleistung II",null,"kW",null,null,null,null,null,null,null,null,null,null,"Fernwärme"]
[null,null,"Energieträger II",null,null,null,null,null,null,null,null,null,null,null,"Liter Öl "]
[null,"Hersteller",null,null,null,null,null,null,null,null,null,null,null,null,"Liter Fl.Gas"]
[null,"Typenbezeichnung",null,null,null,null,null,null,null,null,null,null,null,null,"m³ Gas"]
[null,"Baujahr",null,null,null,null,null,null,null,null,null,null,null,null,"m³ Hackgut"]
[null,"Anmerkungen",null,null,null,null,null,null,null,"Heizkörper",null,null,null,null,"kWh Gas"]
[null,null,null,null,null,null,null,null,null,"Fußbodenheizung",null,null,null,null,"kWh Strom"]
[null,null,"Übergabe 1","Übergabe 2","Anmerkungen",null,null,null,null,"Wandheizung",null,null,null,null,"kg Pellets"]
[null,"Art der Wärmeübergabe",null,null,null,null,null,null,null,"Umluftheizung",null,null,null,null,"kg Hackgut"]
[null,null,null,null,null,null,null,null,null,"Unterbankheizung",null,null,null,null,"kg Fl.Gas"]
[null,null,null,"Anzahl","Anmerkungen",null,null,null,null,"Sonstiges",null,null,null,null,"Ster"]
[null,"Dezentrale WW-Erzeuger (Boiler)",null,null,null,null,null,null,null,null,null,null,null,null,"kWh Fernw."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ja"]
[null,null,null,"Anmerkungen",null,null,null,null,null,null,null,null,null,null,"nein"]
[null,"Heizzentrale für mehrere Gebäude vorhanden?"]
[]
[null,"Technische Daten Solaranlage"]
[null,null,null,null,null,null,"Verwendungsarten",null,"Heizungsunterstützung"]
[null,"Zeitpunkt der Inbetriebnahme",null,null,null,null,null,null,"WW-Bereitung"]
[null,"Installierte Fläche",null,"m²",null,null,null,null,"keine Angaben"]
[null,"Verwendung"]
[null,"Anmerkungen"]
[]
[null,"Technische Daten Photovoltaikanlage"]
[]
[null,"Zeitpunkt der Inbetriebnahme"]
[null,"Installierte Fläche",null,"m²"]
[null,"Installierte Leistung",null,"kW"]
[null,"Stromeigennutzung"]
[null,"jährliche Netzeinspeisung",null,"kWh"]
[null,"Anmerkungen"]
[]
[null,"Technische Daten Umwälzpumpen"]
[]
[null,null,"Hersteller","Typ","max. Leistung","Regelart"]
[null,null,"[-]","[-]","[W]","[u / s / e / d]"]
[null,"Heizungspumpe 1"]
[null,"Heizungspumpe 2"]
[null,"Heizungspumpe 3"]
[null,"Heizungspumpe 4",null,null,null,null,"u"]
[null,"Heizungspumpe 5",null,null,null,null,"s"]
[null,"Heizungspumpe 6",null,null,null,null,"e"]
[null,"Heizungspumpe 7",null,null,null,null,"d"]
[null,"Heizungspumpe 8"]
[null,"Heizungspumpe 9"]
[null,"Heizungspumpe 10"]
[null,null,"u = ungeregelt","s = stufen-geregelt","e = elektronisch geregelt","d = Differenzdruck geregelt"]
[]
[null,"Technische Daten Lüftungsanlage"]
[]
[null,"Lüftunsanlage vorhanden"]
[null,"Nutzung: Heizung"]
[null,"Nutzung: Kühlung",null,null,null,null,null,"ja"]
[null,"Nutzung: Be-/Entfeuchtung",null,null,null,null,null,"nein"]
[null,"Wärmerückgewinnung vorhanden"]
[null,"Luftmenge",null,"m³/h"]
[null,"Regelmäßige Nutzung"]
[null,"Anmerkungen"]

{"sheet":"Verbrauchserfassung","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5],[6,1,6,5],[9,1,9,5],[3,1,3,3],[3,4,3,5],[17,1,18,1],[11,2,11,3],[15,1,15,3],[15,4,15,5],[7,2,7,3],[10,2,10,3],[12,1,12,5],[13,2,13,3]]}
[]
[null,"Erfassung Verbrauchsdaten"]
[]
[null,"Verbrauchserfassung"]
[]
[null,"Bezugsjahr Verbrauchsdaten",2014]
[]
[null,"Elektrischer Energieverbauch (Strom)",null,null,"kWh/a"]
[null,"Stromanbieter"]
[]
[null,"thermischer Energieverbrauch (Energieträger I)",null,null,"kWh Fernw."]
[null,"thermischer Energieverbrauch (Energieträger II)",null,null,"Liter Öl "]
[]
[null,"Wasserverbrauch",null,null,"m³"]
[]
[null,"Sonstige Angaben"]
[]
[null,"Schwachstellenanalyse","Gebäudehülle"]
[null,null,"Anlagentechnik"]

{"sheet":"Gebäudesteckbrief","index":3,"n_rows":151,"n_cols":23,"rows_kept":151,"cut":false,"hidden":false,"merged":[[123,7,124,8],[140,0,140,1],[83,0,83,1],[57,0,57,5],[85,2,85,5],[86,2,86,5],[64,1,64,5],[59,1,59,5],[69,1,69,5],[71,1,71,5],[73,4,73,5],[97,0,97,5],[150,0,150,5],[89,0,89,1],[94,2,94,5],[116,0,116,1],[119,2,119,5],[55,0,55,1],[55,2,55,5],[61,1,61,5],[62,1,62,5],[80,0,80,1],[77,0,77,1],[74,0,74,1],[74,4,74,5],[76,4,76,5],[79,3,79,5],[77,4,77,5],[80,3,80,5],[52,1,52,3],[53,1,53,3],[52,4,52,5],[53,4,53,5],[2,2,17,5],[48,0,48,5],[40,4,40,5],[45,1,45,5],[47,0,47,1],[47,2,47,5],[51,4,51,5],[29,3,29,4],[30,3,30,4],[31,3,31,4],[9,0,9,1],[170,0,170,5],[34,3,34,4],[35,3,35,4],[36,3,36,4],[39,4,39,5],[40,1,40,3],[41,1,41,3],[44,4,44,5],[43,4,43,5],[41,4,41,5],[42,4,42,5],[68,1,68,5],[66,1,66,5],[44,1,44,3],[43,1,43,3],[42,1,42,3],[1,1,1,4],[0,0,1,0],[23,4,23,5],[0,1,0,4],[27,0,27,5]]}
["Gebäude-steckbrief",{"$f":"'Allgemeine Daten'!C9","v":0}]
[null,{"$f":"'Allgemeine Daten'!C10","v":0}]
["Datum",null,null,null,null,null,null,"Button einfügen: Funktion zum Erzeugen eines neuen Tabellenblattes"]
[{"$f":"'Allgemeine Daten'!C14","v":"2016-06-08"}]
[]
["Erfassungsjahr"]
[{"$f":"'Allgemeine Daten'!C15","v":2014}]
[]
["Nutzungsart"]
[{"$f":"'Allgemeine Daten'!C16","v":0}]
[]
["Gebäudebaujahr"]
[{"$f":"'Allgemeine Daten'!C27","v":0}]
["Baualtersklasse",{"$f":"'Allgemeine Daten'!E26","v":0}]
[]
["Beheizte Grundfläche"]
[{"$f":"'Allgemeine Daten'!C37","v":0},"m²"]
[null,null,null,null,null,null,"ja"]
["Energieverbrauch",null,null,null,null,null,"nein"]
["Stromverbrauch",null,{"$f":"Verbrauchserfassung!C8","v":0},{"$f":"Verbrauchserfassung!E8","v":"kWh/a"}]
["thermischer Energieverbrauch I",null,{"$f":"Verbrauchserfassung!C11","v":0},{"$f":"Verbrauchserfassung!E11","v":"kWh Fernw."},{"$f":"IF(Gebäudesteckbrief!D21=Gebäudesteckbrief!$J$24,Gebäudesteckbrief!C21*Gebäudesteckbrief!$K$24,IF(Gebäudesteckbrief!D21=Gebäudesteckbrief!$J$26,Gebäudesteckbrief!C21*$K$26,IF(D21=$J$27,C21*$K$27,IF(D21=$J$28,C21*$K$28,IF(D21=$J$29,C21*$K$29,IF(D21=$J$30,C21*$K$30,IF(D21=$J$31,C21*$K$31,IF(D21=$J$32,C21*$K$32,IF(D21=$J$33,C21*$K$33,IF(D21=$J$25,C21*$K$25,IF(D21=$J$34,C21*$K$34,0)))))))))))","v":0},"kWh/a"]
["thermischer Energieverbrauch II",null,{"$f":"Verbrauchserfassung!C12","v":0},{"$f":"Verbrauchserfassung!E12","v":"Liter Öl "},{"$f":"IF(Gebäudesteckbrief!D22=Gebäudesteckbrief!$J$24,Gebäudesteckbrief!C22*Gebäudesteckbrief!$K$24,IF(Gebäudesteckbrief!D22=Gebäudesteckbrief!$J$26,Gebäudesteckbrief!C22*$K$26,IF(D22=$J$27,C22*$K$27,IF(D22=$J$28,C22*$K$28,IF(D22=$J$29,C22*$K$29,IF(D22=$J$30,C22*$K$30,IF(D22=$J$31,C22*$K$31,IF(D22=$J$32,C22*$K$32,IF(D22=$J$33,C22*$K$33,IF(D22=$J$25,C22*$K$25,IF(D22=$J$34,C22*$K$34,0)))))))))))","v":0},"kWh/a"]
[null,null,null,null,null,null,"Umrechnung Energieträger",null,null,null,null,null,null,null,null,"Thermisch","Elektrisch"]
["Spezifische Energieverbrauchswerte",null,null,null,"Vergleichskennwerte",null,null,null,null,"Liter Öl ",10.08,"kWh/ltr",null,null,"Pfarrkirche",30,8]
["Stromverbrauchswert",null,{"$f":"C20/A17","v":{"$error":"#DIV/0!"}},"kWh/m²a",{"$f":"VLOOKUP(A10,O24:Q37,3,FALSE)","v":{"$error":"#N/A"}},"kWh/m²a",null,null,null,"Liter Fl.Gas",6.9660000000000002,"kWh/ltr",null,null,"Sonstige bestehende Kirche",30,8]
["Heizenergieverbrauchswert (I+II)",null,{"$f":"(E21+E22)/A17","v":{"$error":"#DIV/0!"}},"kWh/m²a",{"$f":"VLOOKUP(A10,O24:Q37,2,FALSE)","v":{"$error":"#N/A"}},"kWh/m²a",null,null,null,"m³ Gas",10.1,"kWh/m³",null,null,"Pfarrerhaus",110,30]
[null,null,null,null,null,null,null,null,null,"m³ Hackgut",770,"kWh/m³",null,null,"Pfarrvikar-Haus",110,30]
["Allgemeine Angaben",null,null,null,null,null,null,null,null,"kWh Gas",0.90100000000000002,null,null,null,"Wohnhaus (Mietobjekt)",110,30]
["Mehrfachnutzung",null,null,null,null,null,null,null,null,"kWh Strom",1,null,null,null,"Pfarr- und Jugendheim",105,20]
[{"$f":"IF('Allgemeine Daten'!J16=FALSE,G19,G18)","v":"nein"},null,{"$f":"'Allgemeine Daten'!C18","v":0},{"$f":"'Allgemeine Daten'!D18","v":0},null,null,null,null,null,"kg Pellets",5,"kWh/kg",null,null,"Kindertagesstätte",110,20]
[null,null,{"$f":"'Allgemeine Daten'!C19","v":0},{"$f":"'Allgemeine Daten'!D19","v":0},null,null,null,null,null,"kg Hackgut",3.5,"kWh/kg",null,null,"Altenheim / Seelsorgeinrichtungen",145,84,null,"AGES Kennwerte"]
[null,null,{"$f":"'Allgemeine Daten'!C20","v":0},{"$f":"'Allgemeine Daten'!D20","v":0},null,null,null,null,null,"kg Fl.Gas",12.9,"kWh/kg",null,null,"Schwesternheim",135,30]
[null,null,null,null,null,null,null,null,null,"Ster",1500,"kWh/Ster",null,null,"Bibliothek",55,40]
["Vermietung",null,null,null,null,null,null,null,null,"kWh Fernw.",1,null,null,null,"Wohngebäude",110,30]
[{"$f":"IF('Allgemeine Daten'!J17=FALSE,G19,G18)","v":"nein"},null,{"$f":"'Allgemeine Daten'!C21","v":0},{"$f":"'Allgemeine Daten'!D21","v":0},null,null,null,null,null,null,null,null,null,null,"Benefiziatenhaus",135,30]
[null,null,{"$f":"'Allgemeine Daten'!C22","v":0},{"$f":"'Allgemeine Daten'!D22","v":0},null,null,null,null,null,null,null,null,null,null,"Pfarrzentrum",{"$f":"+(P34+P29)/2","v":107.5},{"$f":"+(Q34+Q29)/2","v":25}]
[null,null,{"$f":"'Allgemeine Daten'!C23","v":0},{"$f":"'Allgemeine Daten'!D23","v":0},null,null,null,null,null,null,null,null,null,null,"Sonstige","k.A.","k.A."]
[]
["Sanierungsmaßnahmen: Gebäudehülle"]
[null,null,null,null,"Jahr der Sanierung"]
["Kellerdecken",{"$f":"'Allgemeine Daten'!D29","v":0},null,null,{"$f":"'Allgemeine Daten'!F29","v":0}]
["Außen/Innenwand",{"$f":"'Allgemeine Daten'!D30","v":0},null,null,{"$f":"'Allgemeine Daten'!F30","v":0}]
["Dach/Decke",{"$f":"'Allgemeine Daten'!D31","v":0},null,null,{"$f":"'Allgemeine Daten'!F31","v":0}]
["Fenster",{"$f":"'Allgemeine Daten'!D32","v":0},null,null,{"$f":"'Allgemeine Daten'!F32","v":0}]
["Türen",{"$f":"'Allgemeine Daten'!D33","v":0},null,null,{"$f":"'Allgemeine Daten'!F33","v":0}]
["Anmerkungen",{"$f":"'Allgemeine Daten'!C34","v":0}]
[]
["Schwachstellenanalyse: Gebäudehülle",null,{"$f":"Verbrauchserfassung!D18","v":0}]
["Seite 1/3"]
[]
["Sanierungsmaßnahmen: Anlagentechnik"]
[null,null,null,null,"Jahr der Sanierung"]
["Pumpen",{"$f":"'Allgemeine Daten'!D35","v":0},null,null,{"$f":"'Allgemeine Daten'!F35","v":0}]
["Heizungsanlage",{"$f":"'Allgemeine Daten'!D36","v":0},null,null,{"$f":"'Allgemeine Daten'!F36","v":0}]
[]
["Schwachstellenanalyse: Anlagentechnik",null,{"$f":"Verbrauchserfassung!D19","v":0}]
[]
["Technische Angaben"]
["Technische Daten Heizungssystem"]
["Energieträger I",{"$f":"'Technische Daten'!C6","v":0}]
["Nennwärmeleistung I",{"$f":"'Technische Daten'!C7","v":0},"kW"]
["Hersteller",{"$f":"'Technische Daten'!C9","v":0}]
["Typenbezeichnung",{"$f":"'Technische Daten'!C10","v":0}]
["Baujahr",{"$f":"'Technische Daten'!C11","v":0}]
["Anmerkungen",{"$f":"'Technische Daten'!C12","v":0}]
[]
["Energieträger II",{"$f":"'Technische Daten'!C14","v":0}]
["Nennwärmeleistung II",{"$f":"'Technische Daten'!C15","v":0},"kW"]
["Hersteller",{"$f":"'Technische Daten'!C17","v":0}]
["Typenbezeichnung",{"$f":"'Technische Daten'!C18","v":0}]
["Baujahr",{"$f":"'Technische Daten'!C19","v":0}]
["Anmerkungen",{"$f":"'Technische Daten'!C20","v":0}]
[]
[null,null,null,null,"Anmerkungen"]
["Art der Wärmeübergabe",null,{"$f":"'Technische Daten'!C23","v":0},{"$f":"'Technische Daten'!D23","v":0},{"$f":"'Technische Daten'!E23","v":0}]
[]
[null,null,null,"Anzahl","Anmerkungen"]
["Dezentrale WW-Erzeuger (Boiler)",null,{"$f":"'Technische Daten'!C26","v":0},{"$f":"'Technische Daten'!D26","v":0},{"$f":"'Technische Daten'!E26","v":0}]
[]
[null,null,null,"Anmerkungen"]
["Heizzentrale für mehrere Gebäude vorhanden?",null,{"$f":"'Technische Daten'!C29","v":0},{"$f":"'Technische Daten'!D29","v":0}]
[]
["Technische Daten Solaranlage"]
["Zeitpunkt der Inbetriebnahme",null,{"$f":"'Technische Daten'!C33","v":0}]
["Installierte Fläche",null,{"$f":"'Technische Daten'!C34","v":0},"m²"]
["Verwendung",null,{"$f":"'Technische Daten'!C35","v":0}]
["Anmerkungen",null,{"$f":"'Technische Daten'!C36","v":0}]
[]
["Technische Daten Photovoltaikanlage"]
["Zeitpunkt der Inbetriebnahme",null,{"$f":"'Technische Daten'!C40","v":0}]
["Installierte Fläche",null,{"$f":"'Technische Daten'!C41","v":0},"m²"]
["Installierte Leistung",null,{"$f":"'Technische Daten'!C42","v":0},"kW"]
["Stromeigennutzung",null,{"$f":"'Technische Daten'!C43","v":0}]
["jährliche Einspeisung",null,{"$f":"'Technische Daten'!C44","v":0},"kWh"]
["Anmerkungen",null,{"$f":"'Technische Daten'!C45","v":0}]
[]
[]
["Seite 2/3"]
[]
[]
["Technische Daten Umwälzpumpen",null,"Hersteller","Typ","max. Leistung","Regelart"]
[null,null,"[-]","[-]","[W]","[u/s/e/d]"]
["Umwälzpumpe 1",null,{"$f":"'Technische Daten'!C51","v":0},{"$f":"'Technische Daten'!D51","v":0},{"$f":"'Technische Daten'!E51","v":0},{"$f":"'Technische Daten'!F51","v":0}]
["Umwälzpumpe 2",null,{"$f":"'Technische Daten'!C52","v":0},{"$f":"'Technische Daten'!D52","v":0},{"$f":"'Technische Daten'!E52","v":0},{"$f":"'Technische Daten'!F52","v":0}]
["Umwälzpumpe 3",null,{"$f":"'Technische Daten'!C53","v":0},{"$f":"'Technische Daten'!D53","v":0},{"$f":"'Technische Daten'!E53","v":0},{"$f":"'Technische Daten'!F53","v":0}]
["Umwälzpumpe 4",null,{"$f":"'Technische Daten'!C54","v":0},{"$f":"'Technische Daten'!D54","v":0},{"$f":"'Technische Daten'!E54","v":0},{"$f":"'Technische Daten'!F54","v":0}]
["Umwälzpumpe 5",null,{"$f":"'Technische Daten'!C55","v":0},{"$f":"'Technische Daten'!D55","v":0},{"$f":"'Technische Daten'!E55","v":0},{"$f":"'Technische Daten'!F55","v":0}]
["Umwälzpumpe 6",null,{"$f":"'Technische Daten'!C56","v":0},{"$f":"'Technische Daten'!D56","v":0},{"$f":"'Technische Daten'!E56","v":0},{"$f":"'Technische Daten'!F56","v":0}]
["Umwälzpumpe 7",null,{"$f":"'Technische Daten'!C57","v":0},{"$f":"'Technische Daten'!D57","v":0},{"$f":"'Technische Daten'!E57","v":0},{"$f":"'Technische Daten'!F57","v":0}]
["Umwälzpumpe 8",null,{"$f":"'Technische Daten'!C58","v":0},{"$f":"'Technische Daten'!D58","v":0},{"$f":"'Technische Daten'!E58","v":0},{"$f":"'Technische Daten'!F58","v":0}]
["Umwälzpumpe 9",null,{"$f":"'Technische Daten'!C59","v":0},{"$f":"'Technische Daten'!D59","v":0},{"$f":"'Technische Daten'!E59","v":0},{"$f":"'Technische Daten'!F59","v":0}]
["Umwälzpumpe 10",null,{"$f":"'Technische Daten'!C60","v":0},{"$f":"'Technische Daten'!D60","v":0},{"$f":"'Technische Daten'!E60","v":0},{"$f":"'Technische Daten'!F60","v":0}]
[]
["Technische Daten Lüftungsanlage"]
["Nutzung: Heizung",null,{"$f":"'Technische Daten'!C66","v":0}]
["Nutzung: Kühlung",null,{"$f":"'Technische Daten'!C67","v":0}]
["Nutzung: Be-/Entfeuchtung",null,{"$f":"'Technische Daten'!C68","v":0}]
["Wärmerückgewinnung",null,{"$f":"'Technische Daten'!C69","v":0}]
["Regelmäßige Nutzung",null,{"$f":"'Technische Daten'!C71","v":0}]
["Anmerkungen",null,{"$f":"'Technische Daten'!C72","v":0}]
[]
[]
["Energetische Bewertung"]
[null,null,null,null,null,null,null,"Abweichung in Prozent vom Referenzwert"]
[null,null,null,null,null,null,null,null,null,null,null,"Grün","Orange","Orange","Rot",null,null,null,null,null,null,null,"Vergleichswert"]
[null,null,null,null,null,null,"Stromverbrauch",{"$f":"C25/E25","v":{"$error":"#DIV/0!"}},{"$f":"H126*100","v":{"$error":"#DIV/0!"}},"%",{"$f":"I126-100","v":{"$error":"#DIV/0!"}},{"$f":"IF(K126<30,0,-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(K126>29,1,-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(K126<50,2,-2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(K126>49,4,-1)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"E25","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Heizenergie",{"$f":"C26/E26","v":{"$error":"#DIV/0!"}},{"$f":"H127*100","v":{"$error":"#DIV/0!"}},"%",{"$f":"I127-100","v":{"$error":"#DIV/0!"}},{"$f":"IF(K127<30,0,-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(K127>29,1,-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(K127<50,2,-2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(K127>49,4,-1)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"E26","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,null,"IST-Zustand"]
[null,null,"Strom",{"$f":"C25","v":{"$error":"#DIV/0!"}}]
[null,null,"Heizenergie",{"$f":"C26","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
["Energieampel"]
["Abweichung vom Referenzwert",null,null,"Heizenergie","Strom"]
[]
["über 50%",null,null,{"$f":"IF(ISERROR($O$127),\"\",Gebäudesteckbrief!O127)","v":""},{"$f":"IF(ISERROR($O$126),\"\",Gebäudesteckbrief!O126)","v":""}]
["zwischen 30% und 50%",null,null,{"$f":"IF(OR(ISERROR($M$127),ISERROR($N$127)),\"\",Gebäudesteckbrief!M127+Gebäudesteckbrief!N127)","v":""},{"$f":"IF(OR(ISERROR($M$126),ISERROR($N$126)),\"\",Gebäudesteckbrief!M126+Gebäudesteckbrief!N126)","v":""}]
["kleiner 30%",null,null,{"$f":"IF(ISERROR($L$127),\"\",Gebäudesteckbrief!L127)","v":""},{"$f":"IF(ISERROR($L$126),\"\",Gebäudesteckbrief!L126)","v":""}]
[]
[]
[{"$f":"IF(OR($A$10=$O$24,$A$10=$O$25),\"Hinweis: Kennwerte anhand einer Referenzkirche ermittelt\",IF($A$10=$O$37,\"Hinweis: Für die Gebäudekategorie 'Sonstige' ist kein Referenzwert vorhanden\",\"\"))","v":""}]
[]
[]
["Seite 3/3"]

{"sheet":"Check-Liste","index":4,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,1,null,"Überprüfen Sie mit Hilfe eines Thermometers die richtige Raumtemperatur. In Büroräumen beträgt diese zwischen 19 und 22°C",null,null,"Die Heizkörper sind regelmäßig zu entlüften. Nur so können diese die maximale Wärme an den Raum abgeben.",null,5]
[null,2,null,"Eine Optimierung der Heizungssteuerung bringt weitere Einsparungen.                                      Aber Vorsicht: Da muss ein Fachmann ran!",null,null,"Richtiges Lüften spart zusätzliche Energie. Zu empfehlen ist das Stoßlüften. Wichtig dabei: Immer das Heizkörperthermostat auf Stellung 0 zu drehen. ",null,6]
[null,3,null,"Eine regelmäßige Wartung der Heizungsanlage ist für einen effizienten Betrieb unerlässlich",null,null,"Überprüfen Sie die Leuchtmittel in Ihrem Gebäude. Auch die Beleuchtungssteuerung sollte genau unter die Lupe genommen werden.",null,7]
[null,4,null,"Die jährlichen Wartung der Anlage kann mit einem hydraulischen Abgleich der Heizung verbunden werden.  Auch hier gilt: Lass den Fachmann ran!",null,null,"Schalten Sie die elektrischen Geräte in Ihrem Gebäude komplett aus. Auch im Stand-By-Zustand verbrauchen diese nämlich Unmengen an Energie!",null,8]
[null,null,null,"Kann selbst erledigt werden"]
[null,null,null,"Kann zum Teil selbst erledigt werden"]
[null,null,null,"Muss von einem Fachmann durchgeführt werden"]