{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["0_Anwendung","Input","Vorbereitung","Archiv","Katalog"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":12,"n_cols":49,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["RMB Kelpy | BML nach SGK"]
["Anleitung für die Nutzung der BML"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"2024-12-02"}]
[]
[]
[null,"Version: 02.12.2024"]
[]
["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"]
[3,"Daten im Register \"Vorbereitung\" nach Bedarf bearbeiten"]
[4,"Blauen Button für Erstellung BML drücken"]

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

{"sheet":"Vorbereitung","index":2,"n_rows":13,"n_cols":64,"rows_kept":13,"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,null,"2 | Auslegedaten",null,null,null,"3 | Spezifikationen",null,null,null,null,null,null,"4 | Elektroanschlussdaten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 | Standort",null,null,null,"6 | MSR",null,null,null,null,null,"7 | weitere Details",null,null,null,null,null,null,null,"8 | Datenherkunft"]
["RMB ID","Komponenten-Typ","Gelöscht",null,"Anlagenummer","Artikelnummer RMB","Laufnummer","Anlagenummer Bauherr","Anlage","Komponentenbezeichnung","Feldgerät","Nachtext Feldgerät",null,"Leistung 1","Volumenstrom 1","Medium",null,"Fabrikat","Typ / Messweraufnehmer","Fabrikat Antrieb","Typ Antrieb / Rechenwerk","Ausführung","Messart (Ausführung)",null,"Phasen","Spannung","Strom","Anlaufstrom","Leistung el.","Einsatzbereich","Steuersignal","Regelung","Schutzart","Ex Schutzart","Kommunikation","Datenpunkt","Datenpunkt","Datenpunk","Datenpunkt","Datenpunkt","Datenpunkt","Datenpunkt",null,"Geschoss","Raumnummer","Klartextraum",null,"Bezeichnug GA","Bezeichnung Elektroschema","SGK Nummer","SGK Zuordnung","Anlage funktional",null,"Hub","Stellkraft","Artikelnummer","Lieferung","Energieeffizienzklasse","Gesamtwirkungsgrad Vollast","Kommentrar Technisch",null,"Prinzipschema","Strangschema","Modell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"[kW]","[m3/h]",null,null,null,null,null,null,null,null,null,null,"[V]","[A]","[A]","[W]","[%]",null,null,"IP",null,null,"DI","DO","AI","AO","Mbus","VA","VD",null,null,null,null,null,"AKS","BMK",null,null,null,null,"[mm]","[N]",null,"bauseits"]
[]
["RMB_ID","KomponenteType","Gelöscht",null,"Anlagenummer (BKP-XXX)","Artikelnummer RMB","Laufnummer","Anlagenummer Bauherr","Klartext Anlage",null,"Klartext Feldgerät","Klartext Feldgerät Nachtext",null,"Leistung 1 (hyd) [kW]","Volumenstrom 1 [m3/h]","Medium 1",null,"Fabrikat","Typ","Fabrikat (Antrieb)","Typ (Antrieb)","Ausführung 1","Messart (Ausführung)",null,"Phasen","Spannung [V]","Strom [A]","Anlaufstrom [A]","Leistung elektrisch [W]","Einsatzbereich [%]","Steuersignal","Regelungsart","Schutzart IP","Ex-Schutz","Integration Kommunikation","Datenpunkte DI","Datenpunkte DO","Datenpunkte AI","Datenpunkte AO","Datenpunkte MBus","Datenpunkte VA","Datenpunkte VD",null,"Geschoss","Raumnummer","Klartext Raum",null,"Bezeichnung GA (AKS)","Bezeichnung Elektroschema (BMK)","SGK Nummer","SGK Zuordnung","Anlage funktional (BKP-XXX)",null,"Hub [mm]","Stellkraft [N]","Artikelnummer","Lieferung bauseits","Energieeffizienzklasse","Gesamtwirkungsgrad Vollast","Kommentar technisch",null,"Prinzipschema","Strangschema","Modell"]
[{"$f":"E13&\"_\"&F13&\"_\"&G13","v":"__"},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F13,Katalog!A:B,2,FALSE),\"\")","v":""}]

{"sheet":"Archiv","index":3,"n_rows":1,"n_cols":64,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["RMB_ID","KomponenteType","Gelöscht",null,"Anlagenummer (BKP-XXX)","Artikelnummer RMB","Laufnummer","Anlagenummer Bauherr","Klartext Anlage",null,"Klartext Feldgerät","Klartext Feldgerät Nachtext",null,"Leistung 1 (hyd) [kW]","Volumenstrom 1 [m3/h]","Medium 1",null,"Fabrikat","Typ","Fabrikat (Antrieb)","Typ (Antrieb)","Ausführung 1","Messart (Ausführung)",null,"Phasen","Spannung [V]","Strom [A]","Anlaufstrom [A]","Leistung elektrisch [W]","Einsatzbereich [%]","Steuersignal","Regelungsart","Schutzart IP","Ex-Schutz","Integration Kommunikation","Datenpunkte DI","Datenpunkte DO","Datenpunkte AI","Datenpunkte AO","Datenpunkte MBus","Datenpunkte VA","Datenpunkte VD",null,"Geschoss","Raumnummer","Klartext Raum",null,"Bezeichnung GA (AKS)","Bezeichnung Elektroschema (BMK)","SGK Nummer","SGK Zuordnung","Anlage funktional (BKP-XXX)",null,"Hub [mm]","Stellkraft [N]","Artikelnummer","Lieferung bauseits","Energieeffizienzklasse","Gesamtwirkungsgrad Vollast","Kommentar technisch",null,"Prinzipschema","Strangschema","Modell"]

{"sheet":"Katalog","index":4,"n_rows":115,"n_cols":2,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
["Artikelnummer","Bezeichnung"]
["0-003","Entgaser"]
["0-004","Automatische Nachfüllstation"]
["0-009","Umluftkühlgerät"]
["0-010","Luftregister"]
["0-011","Heizkörper"]
["0-013","Bodenkonvektor"]
["0-014","Türluftschleier"]
["0-015","Ölheizkessel"]
["0-016","Gasheizkessel"]
["0-017","Wärmepumpenspeicher"]
["0-018","Feststoffheizkessel"]
["0-019","Wärmepumpe"]
["0-020","Wärmepumpe (l-w)"]
["0-021","Kältemaschine"]
["0-022","Kältemaschine (l-w)"]
["0-023","AWN-Wärmepumpe"]
["0-024","Rückkühlung hybrid"]
["0-025","Rückkühlung trocken"]
["0-026","Rückkühlung nass"]
["0-036","Elektroheizeinsatz"]
["0-039","Blockheizkraftwerk"]
["0-043","Expansionsgefäss mit Kompressor"]
["0-050","Feinstaubfilter"]
["0-051","Mobile Nachfüllstation"]
["0-052","Demineralisationsanlage"]
["0-101","Lüftungsgerät"]
["0-102","Lüftungsgerät: Ventilator"]
["0-112","Lüftungsgerät: Rotationswärmerückgewinnung"]
["0-113","Lüftungsgerät: Befeuchter"]
["0-404","Osmoseanlage"]
["0-406","Steuerelement"]
["0-407","Enthärtung"]
["0-408","Hygienespühlung"]
["0-409","Druckerhöhung"]
["0-436","Elektrisches Wärmeband"]
["0-438","el. Wärmeband End"]
["0-439","el. Wärmeband Schlaufung"]
["0-506","WC AP"]
["0-507","WC UP"]
["0-508","WC Dusch"]
["0-510","Urinal"]
["0-520","Wäschetrockner"]
["0-521","Tumbler"]
["0-522","Waschmaschine"]
["0-523","Trinkwasserspender"]
["0-529","Wandmischer"]
["0-530","Standmischer"]
["0-554","Händetrockner"]
["0-901","Provisorium Heizung"]
["0-902","Provisorium Kälte"]
["0-903","Provisorium Lüftung"]
["0-904","Provisorium Sanitär"]
["0-999","Preisposition"]
["3-001","Druckunabhängiges Regelventil"]
["3-002","2-Weg Regulierventil"]
["3-003","3-Weg Regulierventil"]
["3-004","Magnetventil"]
["3-005","Motorabsperrklappe"]
["3-006","2-Weg Motorkugelhahn"]
["3-007","Umwälzpumpe"]
["3-008","Wärmezähler"]
["3-009","Temperaturfühler"]
["3-010","Raumtemperaturfühler"]
["3-011","Aussentemperaturfühler"]
["3-013","Strömungswächter"]
["3-014","Sicherheitstemperaturbegrenzer"]
["3-015","Kondensatwächter"]
["3-016","Druckfühler (abs)"]
["3-017","Differenzdruckfühler"]
["3-018","Lecküberwachung"]
["3-019","Kältemittelfühler"]
["3-020","Anlegetemperaturfühler"]
["3-021","Ventilantrieb"]
["3-022","6-Weg Regulierventil"]
["3-023","Gasfühler"]
["3-025","Temperaturfühler Wärmezähler"]
["3-028","Durchflussfühler"]
["3-029","Wassermelder"]
["3-030","Warnsignal optisch"]
["3-031","Warnsignal akustisch"]
["3-032","Motorumstellventil"]
["3-033","Energy Valve"]
["3-034","3-Weg Magnetventil"]
["3-036","3 Weg Motorkugelhahn"]
["3-101","Temperaturfühler Kanal"]
["3-104","Temperaturfühler Kapillarrohr"]
["3-105","Frostschutzwächter"]
["3-115","Druckfühler Luft"]
["3-116","Differenzdruckfühler Luft"]
["3-117","Druckwächter Luft"]
["3-118","Differenzdruckwächter"]
["3-122","Mischgasfühler"]
["3-130","Volumenstrommessung"]
["3-140","Kanalrauchmelder"]
["3-150","Frequenzumformer"]
["3-151","Klappenantrieb"]
["3-152","Schalter"]
["3-153","Schaltuhr"]
["3-161","Brandschutzklappe"]
["3-162","Entrauchungsklappe"]
["3-171","Volumenstromregler"]
["3-172","Ventilator"]
["3-180","Luftfeuchtefühler"]
["3-181","CO2 Fühler"]
["3-182","VOC Fühler"]
["3-183","Thermostat"]
["3-184","Hygrostat"]
["3-185","Kombifühler"]
["3-199","Volumenstrom Messkreuz"]
["3-407","Schmutzwasserpumpe"]
["3-408","Wasserzähler"]
["3-409","Kompakthebeanlage"]
["3-910","Demontage Regel- und Messorgane"]
["3-999","Preisposition"]