{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["0_Anwendung","Katalog","Input","Vorbereitung"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"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":"0_Anwendung","index":0,"n_rows":14,"n_cols":49,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["RMB Kelpy | GA Automatisierung"]
["Anleitung für die Nutzung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand:",{"$f":"TODAY()","v":"2025-10-09"}]
[]
[]
[null,"Version: 19.08.2025"]
[]
["Anwendung"]
[1,"Gewünschte Daten aus Kelpy ganz oben links in das Register \"Input\" kopieren."]
[2,"Orangen Button für Übertrag nach Register \"Vorbereitung\" drücken, nicht relevante Komponenten werden aus beiden Registern entfernt. Register \"SGK-Übersicht\" und \"ImportToKelpy\" werden gelöscht."]
[3,"Daten im Register \"Vorbereitung\" nach Bedarf bearbeiten"]
[4,"Blauen Button für Übertrag von Datenpunkten gemäss Register \"Katalog\" starten. Die Werte werden nur übertragen, wenn die Datenpunkteinträge inkl. Kommunikation für die entsprechende Komponente komplett leer sind!"]
[5,"Grünen Button für Zusammenstellung der Anlagen nach SGK"]
[6,"Grauen Button für Aufbereitung der Daten für den Import in Kelpy (Datenpunkt-Abgleich)"]

{"sheet":"Katalog","index":1,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
["Artikelnummer RMB","Komponentenbezeichnung","Ausführung 1","Integration Kommunikation","Datenpunkte DI","Datenpunkte DO","Datenpunkte AI","Datenpunkte AO","Datenpunkte MBus","Datenpunkte VA","Datenpunkte VD"]
["0-002","Expansionsgefäss",null,"konventionell",1]
["0-003","Entgaser",null,"konventionell",2]
["0-004","Automatische Nachfüllstation",null,"konventionell",1]
["0-009","Umluftkühlgerät",null,"konventionell",2,1,null,1]
["0-011","Heizkörper","2 Punkt Thermoantrieb","konventionell",null,1]
["0-014","Türluftschleier",null,"konventionell",2,1,null,1]
["0-015","Ölheizkessel",null,"konventionell",3,1,null,1]
["0-016","Gasheizkessel",null,"konventionell",3,1,null,1]
["0-017","Wärmepumpenspeicher",null,"konventionell",1,1]
["0-018","Feststoffheizkessel",null,"konventionell",3,1,null,1]
["0-019","Wärmepumpe",null,"Modbus/BACnet IP",3,1,null,2,null,10,10]
["0-020","Wärmepumpe (l-w)",null,"Modbus/BACnet IP",3,1,null,2,null,10,10]
["0-021","Kältemaschine",null,"Modbus/BACnet IP",3,1,null,2,null,10,10]
["0-022","Kältemaschine (l-w)",null,"Modbus/BACnet IP",3,1,null,2,null,10,10]
["0-023","AWN-Wärmepumpe",null,"Modbus/BACnet IP",3,1,null,1,null,8,8]
["0-024","Rückkühlung hybrid",null,"konventionell",2,1,null,1]
["0-025","Rückkühlung trocken",null,"konventionell",2,1,null,1]
["0-026","Rückkühlung nass",null,"konventionell",2,1,null,1]
["0-032","Mikrofilteranlage",null,"konventionell",1]
["0-036","Elektroheizeinsatz",null,"konventionell",2,1]
["0-039","Blockheizkraftwerk",null,"Modbus/BACnet IP",3,1,null,1,null,4,4]
["0-043","Expansionsgefäss mit Kompressor",null,"konventionell",2]
["0-102","Lüftungsgerät: Ventilator",null,"konventionell",2,1,null,1]
["0-402","Frischwasserstation",null,"konventionell",1]
["0-404","Osmoseanlage",null,"konventionell",1]
["0-407","Enthärtung",null,"konventionell",2]
["0-408","Hygienespühlung",null,"konventionell",1]
["0-409","Druckerhöhung",null,"konventionell",2]
["0-436","Elektrisches Wärmeband",null,"konventionell",1,1]
["3-001","Druckunabhängiges Regelventil",null,"konventionell",null,null,null,1]
["3-002","2-Weg Regulierventil",null,"konventionell",null,null,null,1]
["3-003","3-Weg Regulierventil",null,"konventionell",null,null,null,1]
["3-004","Magnetventil",null,"konventionell",null,1]
["3-005","Motorabsperrklappe","mit Endschalter Auf/Zu","konventionell",2,1]
["3-006","2-Weg Motorkugelhahn",null,"konventionell",null,null,null,1]
["3-007","Umwälzpumpe",null,"konventionell",2,1]
["3-008","Wärmezähler",null,"MBus",null,null,null,null,3]
["3-009","Temperaturfühler",null,"konventionell",null,null,1]
["3-010","Raumtemperaturfühler",null,"konventionell",null,null,1]
["3-011","Aussentemperaturfühler",null,"konventionell",null,null,1]
["3-012","Wassermangelsicherung",null,"konventionell",1]
["3-013","Strömungswächter",null,"konventionell",1]
["3-014","Sicherheitstemperaturbegrenzer",null,"konventionell",1]
["3-015","Kondensatwächter",null,"konventionell",1]
["3-016","Druckfühler (abs)",null,"konventionell",null,null,1]
["3-017","Differenzdruckfühler",null,"konventionell",null,null,1]
["3-018","Lecküberwachung",null,"konventionell",1]
["3-019","Kältemittelfühler","Gaswarnanlage","konventionell",3,1]
["3-020","Anlegetemperaturfühler",null,"konventionell",null,null,1]
["3-021","Ventilantrieb","stetig","konventionell",null,null,null,1]
["3-022","6-Weg Regulierventil",null,"Modbus/BACnet",null,null,1,null,null,4,2]
["3-023","Gasfühler","Gaswarnanlage","konventionell",3,1]
["3-025","Temperaturfühler Wärmezähler","Anschlus auf Rechenwerk"]
["3-028","Durchflussfühler","Anschlus auf Rechenwerk"]
["3-029","Wassermelder",null,"konventionell",1]
["3-030","Warnsignal optisch",null,"konventionell",null,1]
["3-031","Warnsignal akustisch",null,"konventionell",null,1]
["3-032","Motorumstellventil","2 Punkt ohne Endschalter","konventionell",null,1]
["3-033","Energy Valve",null,"Modbus/BACnet",null,null,1,null,null,6,2]
["3-034","3-Weg Magnetventil",null,"konventionell",null,1]
["3-036","3 Weg Motorkugelhahn","stetig","konventionell",null,null,null,1]
["3-101","Temperaturfühler Kanal",null,"konventionell",null,null,1]
["3-104","Temperaturfühler Kapillarrohr",null,"konventionell",null,null,1]
["3-105","Frostschutzwächter","2 Punkt","konventionell",1]
["3-115","Druckfühler Luft",null,"konventionell",null,null,1]
["3-116","Differenzdruckfühler Luft",null,"konventionell",null,null,1]
["3-117","Druckwächter Luft",null,"konventionell",1]
["3-118","Differenzdruckwächter",null,"konventionell",1]
["3-122","Mischgasfühler","VOC","konventionell",null,null,1]
["3-130","Volumenstrommessung",null,null,null,null,1]
["3-140","Kanalrauchmelder","inkl. Fernquittierung",null,2,1]
["3-150","Frequenzumformer",null,"konventionell",2,1,null,1]
["3-151","Klappenantrieb","2/3 Punkt mit Endschalter ZU/AUF","konventionell",2,1]
["3-152","Schalter","Revision","konventionell",1]
["3-153","Schaltuhr","wenn nicht im System","konventionell",1]
["3-161","Brandschutzklappe",null,"Modbus/BACnet",null,null,null,null,null,2,3]
["3-162","Entrauchungsklappe",null,"Modbus/BACnet",null,null,null,null,null,2,3]
["3-171","Volumenstromregler",null,"Modbus/BACnet",null,null,null,null,null,4,2]
["3-172","Ventilator","1-stufig","konventionell",2,1]
["3-173","Wohnungslüftungsbox",null,"Einbindung Anschauen",2,1,null,1]
["3-180","Luftfeuchtefühler",null,"konventionell",null,null,1]
["3-181","CO2 Fühler",null,"konventionell",null,null,1]
["3-182","VOC Fühler",null,"konventionell",null,null,1]
["3-183","Thermostat",null,"konventionell",1]
["3-184","Hygrostat",null,"konventionell",1]
["3-185","Kombifühler","Temp/Feuchte","konventionell",null,null,2]
["3-199","Volumenstrom Messkreuz",null,"konventionell",null,null,1]
["3-407","Schmutzwasserpumpe","nur Meldungen","konventionell",2]
["3-408","Wasserzähler",null,"Mbus",null,null,null,null,2]
["3-409","Kompakthebeanlage","nur Meldungen","konventionell",2]
["3-910","Demontage Regel- und Messorgane"]
["4-001","Schaltschrank",null,"konventionell",8,4,2,1]

{"sheet":"Input","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Vorbereitung","index":3,"n_rows":14,"n_cols":24,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Objekt-/Pojektname"]
["Zweite Zeile | Zusatz Objekt-/Projektname"]
[]
[]
[]
["Vorbereiten BML"]
[]
["0 | Allgemein",null,null,null,"1 | Bezeichnung",null,null,null,null,null,null,null,"2 | MSR",null,null,null,null,null,null,null,null,null,null,"3 | Diskussion"]
["RMB ID","Komponenten-Typ","Gelöscht",null,"Anlagenummer","Artikelnummer RMB","Laufnummer","Anlagenummer Bauherr","Anlage","Komponentenbezeichnung","Ausführung",null,"Kommunikation","Datenpunkt","Datenpunkt","Datenpunk","Datenpunkt","Datenpunkt","Datenpunkt","Datenpunkt","SGK Nummer","SGK Zuordnung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DI","DO","AI","AO","Mbus","VA","VD"]
[]
["RMB_ID","KomponenteType","Gelöscht",null,"Anlagenummer (BKP-XXX)","Artikelnummer RMB","Laufnummer","Anlagenummer Bauherr","Klartext Anlage","Komponentenbezeichnung","Ausführung 1",null,"Integration Kommunikation","Datenpunkte DI","Datenpunkte DO","Datenpunkte AI","Datenpunkte AO","Datenpunkte MBus","Datenpunkte VA","Datenpunkte VD","SGK Nummer","SGK Zuordnung"]
[{"$f":"E13&\"_\"&F13&\"_\"&G13","v":"__"}]
["__"]