{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Rooms and Devices","Default values","Helper{FuncTypes}","Helper{DataPoints}","Helper{LocationTypes}"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Introduction","index":0,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Example of use\nStatus 09/2020"]
[null,"“Excel export” for a GPA project template file"]
[null,"Example of use for exporting a project template file for the Gira Project Assistant (GPA) from an Excel workbook with the aid of a macro in Visual Basic."]
[]
[null,"This file contains a sample structure of an Excel workbook from which you can automatically generate a GPA project template file. You then import this project template in the Gira Project Assistant (from version 4.5 onwards). This way you create GPA projects very quickly and efficiently, which can then be finalised (e.g. provided with ETS group addresses) and put into operation."]
[]
[null,"Procedure"]
[null,"1) Enter the number of functions for each respective room in the “Rooms and Devices” table.\n    If you enter a “0” or do not fill in a field, the function is not used in the room."]
[null,"2) Start the export of the GPA project template file by clicking the “Start export” button."]
[null,"3) Import the exported GPA project template file into the GPA."]
[null,"4) Import your ETS project into the GPA and then assign the group addresses to the applicable data points."]
[null,"5) Transfer the project to the Gira X1 by starting up."]
[]
[]
[null,"Viewing and changing macros"]
[null,"The export functionality is enabled via an Excel macro."]
[null,"To view this macro, select the “Macros” command on the “View” tab. In the following dialogue, select any entry and then click on “Edit”."]
[null,"Under “RoomsAndDevices (Rooms and Devices)” is the entry point of the macro, which performs its function when the “Export” button in the “Export” table is clicked."]
[null,"The rest of the program flow is divided into the named modules “a01_export”, “a02_locations”, “a03_functions” and “a04_datapoints”, which roughly corresponds to the order of the program flow."]
[]
[null,"The macro uses three help tables"]
[null,"“Helper{FuncTypes}” provides a translation of the function names in the column headings of the “Rooms and Devices” table for the function and channel types that must be used in the GPA project template file."]
[null,"“Helper{DataPoints}” breaks down for which function types which data points of which type must be created and assigned to the function. The initial value of the data point can also be specified here."]
[null,"“Helper{LocationTypes}” provides a translation of the building part types from the first two columns of the “Rooms and Devices” table for the LocationTypes that must be used in the GPA project template file."]
[]
[null,"Note: Some sheets and cells in this Excel workbook are read-only to avoid any accidental changes. The password for removing the write protection is “Gira”."]

{"sheet":"Rooms and Devices","index":1,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,1,30,7],[31,1,31,7]]}
["Division","Room","Ceiling light switching","Ceiling light dimming","Dimming RGB","Dimming RGBW","Heating/Cooling","Socket switching","Miscellaneous switching","Shutter","Blinds","IP Camera"]
["Outdoor area","Front"]
["Outdoor area","Patio"]
["Outdoor area","Garden"]
["Basement","Hall"]
["Basement","Workshop"]
["Basement","Laundry"]
["Basement","Plant room"]
["Ground floor","Hall"]
["Ground floor","Living room"]
["Ground floor","Kitchen"]
["Ground floor","Living/dining area"]
["Ground floor","Bathroom"]
["Ground floor","Guest WC"]
["Ground floor","Bedroom"]
["Ground floor","Children's room 1"]
["Ground floor","Children's room 2"]
["Ground floor","Office"]
["Ground floor","Laundry"]
["Ground floor","Storeroom"]
["Ground floor","Plant room"]
["Upper floor","Hall"]
["Upper floor","Living room"]
["Upper floor","Bathroom"]
["Upper floor","Bedroom"]
["Upper floor","Children's room 1"]
["Upper floor","Children's room 2"]
["Upper floor","Office"]
["Upper floor","Storeroom"]
[]
[null,"Instructions for use"]
[null,"Enter the desired number of the respective functions for each room in the cells.\nIf you enter a “0” or do not fill in a cell, the function is not used in the room.\nWhen exporting the project template file, the following is created for you:\n- A building structure consisting of all rooms in which at least one function is used.\n- A control cabinet, in which a Gira X1 is located, is fitted in the basement.\n- Each function is added to the number entered in the respective room. If a function appears more than once, the function name is extended with (2), (3), etc. You can assign the final name in the GPA.\n- For each function located, all required data points are created and assigned to the function. If necessary, you can delete data points that are not required in the GPA."]

{"sheet":"Default values","index":2,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["exportToolName","Gira Export Demo Tool"]
["exportToolVersion","0.0.1"]
["exportToolManufacturer","Gira Giersiepen GmbH &amp; Co KG"]
["Gira X1 Firmware Version","2.5.373"]

{"sheet":"Helper{FuncTypes}","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Excel Functionname","FunctionType","ChannelType"]
["Ceiling light switching","de.gira.schema.functions.Switch","de.gira.schema.channels.Switch"]
["Ceiling light dimming","de.gira.schema.functions.KNX.Light","de.gira.schema.channels.KNX.Dimmer"]
["Dimming RGB","de.gira.schema.functions.ColoredLight","de.gira.schema.channels.DimmerRGBW"]
["Dimming RGBW","de.gira.schema.functions.ColoredLight","de.gira.schema.channels.DimmerRGBW"]
["Heating/Cooling","de.gira.schema.functions.KNX.HeatingCooling","de.gira.schema.channels.KNX.HeatingCoolingSwitchable"]
["Socket switching","de.gira.schema.functions.Switch","de.gira.schema.channels.Switch"]
["Miscellaneous switching","de.gira.schema.functions.Switch","de.gira.schema.channels.Switch"]
["Shutter","de.gira.schema.functions.Covering","de.gira.schema.channels.BlindWithPos"]
["Blinds","de.gira.schema.functions.Covering","de.gira.schema.channels.BlindWithPos"]
["IP Camera","de.gira.schema.functions.Camera","de.gira.schema.channels.Camera"]

{"sheet":"Helper{DataPoints}","index":4,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Excel-Funktionsname","Index","Name","Type","Initial Value"]
["Ceiling light switching",0,"On/Off (switch)","1.001","readonstart"]
["Ceiling light dimming",0,"On/Off (switch)","1.001","readonstart"]
["Ceiling light dimming",1,"Dimming (lighter/darker)","3.007","none"]
["Ceiling light dimming",2,"Brightness value","5.001","readonstart"]
["Dimming RGB",0,"On/Off (switch)","1.001","readonstart"]
["Dimming RGB",1,"Brightness value","5.001","readonstart"]
["Dimming RGB",2,"Red","5.001","readonstart"]
["Dimming RGB",3,"Green","5.001","readonstart"]
["Dimming RGB",4,"Blue","5.001","readonstart"]
["Dimming RGBW",0,"On/Off (switch)","1.001","readonstart"]
["Dimming RGBW",1,"Brightness value","5.001","readonstart"]
["Dimming RGBW",2,"Red","5.001","readonstart"]
["Dimming RGBW",3,"Green","5.001","readonstart"]
["Dimming RGBW",4,"Blue","5.001","readonstart"]
["Dimming RGBW",5,"White","5.001","readonstart"]
["Heating/Cooling",0,"Actual temperature","9.001","readonstart"]
["Heating/Cooling",1,"Setpoint temperature","9.001","readonstart"]
["Socket switching",0,"On/Off (switch)","1.001","readonstart"]
["Miscellaneous switching",0,"On/Off (switch)","1.001","readonstart"]
["Shutter",0,"Up/Down (short-term operation)","1.001","none"]
["Shutter",1,"Raise/Lower (long-term operation)","1.001","none"]
["Shutter",2,"Curtain moving","1.001","none"]
["Shutter",3,"Position","5.001","readonstart"]
["Blinds",0,"Up/Down (short-term operation)","1.001","none"]
["Blinds",1,"Raise/Lower (long-term operation)","1.001","none"]
["Blinds",2,"Curtain moving","1.001","none"]
["Blinds",3,"Position","5.001","readonstart"]
["Blinds",4,"Slat position","5.001","readonstart"]
["IP Camera",0,"Camera active in app","1.001","none"]

{"sheet":"Helper{LocationTypes}","index":5,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Excel-Location","LocationType"]
["Outdoor area","BuildingPart"]
["Basement","Floor"]
["Ground floor","Floor"]
["Upper floor","Floor"]
["Front","BuildingPart"]
["Hall","Corridor"]
["Plant room","ControlCabinet"]