Excel configuration
The configuration can be done entirely via the visualization, which is recommended from version 2.0 onwards.
For larger systems, however, it can be helpful to carry out the configuration using Excel. In general, all worksheets are already available on the controller on delivery. Otherwise, you can save them on the end device via Save basic settings on Settings page. You can copy these files to the USB stick using the Export USB function. All files are then located in the subfolder "Beckhoff" (the USB stick must not be write-protected). With network knowledge, the FTP directory ftp://172.16.17.10/ also lends itself. This is an example link; first adapt the IP to the corresponding device settings.
The limits of the input table must be adhered to!
The following files are created:
- Group_Data.csv
- Circuit_Data.csv
- Lamp_Data.csv
- Sensor_Data.csv
- Switch_Data.csv
- Schedule_Data.csv
- HCL_Data.csv
- Energy_Data.csv
- Scenes_Data.csv
- Scene_Group_Data.csv
- Scene_Group_Data2.csv
The following files are saved, but should not be adapted externally:
- General_Settings.csv
- Logics_Data.csv
- GroupTemplate_Data.csv
- LampTemplate_Data.csv
Notice | |
Do not change the table names or the file format! Do not change the table names or the file format ".csv". All files must always be available – even if they aren't used. |
Group_Data:
Parameter | Input |
Name | Naming |
Activate | 0: deactivated 1: activated |
Set Value | 0…100% |
Basic Value | 0…100% |
Setpoint | 5..5000 |
Delay time 1 "OR 1 min" | 0..600 in minutes |
Delay time 1 "OR 1 sec" | 0..60 seconds |
Delay time 2 "OR 2 min" | 0..600 in minutes |
Delay time 2 "OR 2 sec" | 0..60 seconds |
Automatic delay time optimization "OR Autoadjust" | 0: deactivated 1: activated |
Parameters blocked | 0: Free 1: Blocked |
Area | 0..10 |
Light mode | 1: Fixed Control 2: Daylight Control |
Control mode | 0: Sensor, button or schedule 1: Sensor with activation via schedule or button 2: Daylight Control 3: Full Automatic 4: Semi-automatic 5: Manual button 6: Manual button with delay time |
HCL dimming position | 0: deactivated 1: activated |
RGB (no function yet) | Color value in hexadecimal |
Disable Central off
| 0: Central off active 1: Central off is ignored |
Slave Gr.1-Gr.8 | 0..250 |
Circuit_Data:
Parameter | Input |
Name | Naming |
Group 1 .. 4 | 0..250 |
Activate | 0: deactivated 1: activated |
Lamp_Data:
Parameter | Input |
Name | Naming |
Activate | 0: deactivated 1: activated |
Group 1.. 8 | 0..250 |
Type | 0: Standard 1: Emergency lighting 2: Switching actuator |
Template "Model" | 0..10 |
MinLevel | 0..254 |
MaxLevel | 0..254 |
Rated power | 1-3500 |
Tunable White | 0: deactivated 1: activated |
RGB (no function yet) | Color value in hexadecimal |
Operating hours | Not changeable |
Sensor_Data:
Parameter | Input |
Name | Naming |
Activate | 0: deactivated 1: activated |
Group presence 1: G1.1 - G1.4 | 0..250 |
Scene Presence 1: S1 | 0: deactivated 1..60: activated |
Group presence 2: G2.1 – G2.4 | 0..250 |
Scene Presence 2: S2 | 0: deactivated 1..60: activated |
Auto-detection (Auto-Detect): "AD" | 0: deactivated 1: activated |
Input Type: "IT" | 0: DALI-2 1: External input (GVL_LS_IO.bIn_Sensor_Presence, GVL_LS_IO.nIn_Sensor_Brightness) 2: KNX |
Manufacturer: "M" | 0…20 |
Type: "T" | 0…60 |
Enable brightness: "En_BR" | 0: Disable 1: Enable |
Enable Presence "En_PIR" | 0: Disable 1: Enable |
Report false presence "EN_FP" | 0: Disable 1: Enable |
Brightness scale factor "SF" | 0.1 – 10.0 |
Range | 0..255 (low - high) |
Sensitivity | 1..15 (high - low) |
Button configuration B1-8: Group "G" Scene "S" Area "A" Special function “Z” | G: 0 – 250 S: 0 – 60 A: 0 – 10
Z: 0: deactivated 1: Reset Manual Mode 2: Central off |
KNX line | 1…10 |
KNX-Main Presence "PM" | 0-31 |
KNX-Submain Presence Presence "PS" | 0-7 |
KNX-Number Presence Presence "PN" | 0-255 |
KNX-Main Brightness "BM" | 0-31 |
KNX-Submain Brightness "BS" | 0-7 |
KNX-Number Brightness "BN" | 0-255 |
Switch_Data:
Parameter | Input |
Name | Naming |
Activate | 0: deactivated 1: activated |
Group 1...8 | 1..250 |
Scene | 0: deactivated 1..30: activated |
Area | 0: deactivated 1..10: activated |
Special function | 0: deactivated 1: Reset Manual Mode 2: Central off |
Function as | 0: deactivated 1 .. 100: activated |
Type | 0: Hardware Input (GVL_LS_IO.bSwitch[x]) 1: KNX 2: EnOcean® |
KNX-Line | 1-10 |
KNX-Main | 0-31 |
KNX-Submain | 0-7 |
KNX-Number | 0-255 |
EnOcean® Remote | 1-10 |
EnOcean® DeviceID | ID of the button as a decimal value |
ID2 | 2nd part of the ID (button pressed) |
Icon | 0…19 |
Visibility | 0: Invisible 1: Text only 2: Icon only 3: Text + icon |
Page | 0: No selection 1...4: Button displayed on page x |
Row | 0: No selection 1...5: Button displayed in row x |
Column | 0: No selection 1..6: Button displayed in column x |
Schedule_Data:
Parameter | Input |
Name | Naming |
Activate | 0: deactivated 1: activated |
Mo-Su | 0: deactivated 1: activated |
Group 1...8 | 0..200 |
Scene | 0: deactivated 1..30: activated |
Scene Off | 0: deactivated 1: activated |
Area | 0: deactivated 1..10: activated |
On h On m On s | 0..23 0..59 0..59 |
Off h Off m Off s | 0..23 0..59 0..59 |
Same as | 0: deactivated 1…50 activated |
Astro On | 0: Time 1: Dawn 2: Dusk |
Astro Off | 0: Time 1: Dawn 2: Dusk |
HCL_Data:
Parameter | Input |
Time Hour | 0..23 |
Time Minute | 0..59 |
Color | 2700..6500 |
Dimming position | 10..100 |
Sunrise | 0: deactivated 1: activated |
Sunset | 0: deactivated 1: activated |
Drive time by min | 3..240 |
Activate | 0: deactivated 1: activated |
Energy_Data:
Parameter | Input |
Name | Naming |
ct ratio | 1..10000 |
Activate | 0: deactivated 1: activated |
Scenes_Data:
Parameter | Input |
Name | Naming |
Dimming | 0: deactivated 1: activated |
Scene off | 0: deactivated 1: activated |
Scene first off
| 0: deactivated 1: activated |
Manual Mode Reset | 0: deactivated 1: activated |
Activate | 0: deactivated 1: activated |
Scene_Group_Data and Scene_Group_Data2:
Parameter | Input |
|---|---|
Group | (Display only: described by Scenes_Data) |
Scene S1...S30 Scene S31...S60
| 0: deactivated 1: activated |
Value | 0..254 |