Excel configuration

In general, the configuration can be done entirely via the visualization.

With larger systems it is recommended to carry out the configuration via 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 2. You can copy these files to the USB flash drive 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://192.168.2.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
Switch_Dali_Data.csv
Schedule_Data.csv
HCL_Data.csv
Energy_Data.csv
Scenes_Data.cxv
Scene_Group_Data.csv

Note

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
Set Value	Lowest value (see Settings).. 254
Basic Value	Lowest value (see Settings).. 254
Setpoint	5..5000
Overrun time 1 (Delay time 1)	1..600 in minutes.
Overrun time 2 (Delay time 2)	0..600 in minutes
Parameters blocked	0: Free 1: Blocked
Area	0..10
Light mode	1: Fixed Control 2: Daylight Control
Control mode	0: Sensor, push button or schedule 1: Sensor with activation via schedule or push button 2: Daylight Control 3: Fully automatic 4: Semi-automatic 5: Manual push button 6: Manual push button with overrun
HCL dimming position	0: Disabled 1: Enabled
Slave Gr.1-Gr.8	0..200
Activate	0: Disabled 1: Enabled

Circuit_Data:

Parameter	Input
Name	Naming
Group 1.. 4	0..200
Activate	0: Disabled 1: Enabled

Lamp_Data:

Parameter	Input
Name	Naming
Group 1.. 8	0..200
Activate	0: Disabled 1: Enabled

Sensor_Data:

Parameter	Input
Name	Naming
Group 1.. 4	0..200
Scene	0: Disabled 1..30: Enabled
Sensor type	1: Steinel Dali-2 IR 2: Steinel LiveLink HF/IR 3: Steinel LiveLink light sensor 4: Steinel LiveLink US 5: BEG Dali-2 Luxomat, Osram Dali-2 6: Tridonic MSensor 7: Extern Input 8: Esylux Dali-2 9: Lunatone CS
Range	0..255 (low - high)
Sensitivity	1..15 (high - low)
Activate	0: Disabled 1: Enabled

Switch_Data:

Parameter	Input
Name	Naming
Group 1...8	1..200
Scene	0: Disabled 1..30: Enabled
Area	0: Disabled 1..10: Enabled
Central off	0: Disabled 1: Enabled
Function as	0: Disabled 1 .. 100: Enabled
Activate	0: Disabled 1: Enabled

Switch_Dali_Data:

Parameter	Input
Name	Naming
Switch type	1: Lunatone MC+ Dali-2, Osram Push Coupler 2: Esylux Sensor
Groups 1&2 T1-T4	1..200
Scene T1-T4	0: Disabled 1..30: Enabled
Area T1-T4	0: Disabled 1..10: Enabled
Central off T1-T4	0: Disabled 1: Enabled
Activate	0: Disabled 1: Enabled

Schedule_Data:

Parameter	Input
Name	Naming
Mo-Su	0: Disabled 1: Enabled
Group 1.. 8	0..200
Scene	0: Disabled 1..30: Enabled
Scene Off	0: Disabled 1: Enabled
Area	0: Disabled 1..10: Enabled
On h On m On s	0..23 0..59 0..59
Off h Off m Off s	0..23 0..59 0..59
Activate	0: Disabled 1: Enabled

HCL_Data:

Parameter	Input
Time Hour	0..23
Time Minute	0..59
Color	2700..6500
Dimming position	10..100
Sunrise	0: Disabled 1: Enabled
Sunset	0: Disabled 1: Enabled
Drive time in min	3..240
Activate	0: Disabled 1: Enabled

Energy_Data:

Parameter	Input
Name	Naming
ct ratio	1..10000
Activate	0: Disabled 1: Enabled

Scenes_Data:

Parameter	Input
Name	Naming
Dimming	0: Disabled 1: Enabled
Scene off	0: Disabled 1: Enabled
Scene first off (Scene first off)	0: Disabled 1: Enabled
Activate	0: Disabled 1: Enabled

Scene_Group_Data:

Parameter	Input
Group	(Display only: described by Scenes_Data)
Scene S1..S30	0: Disabled 1: Enabled
Value input	0..254

Parameter

Input

Group

(Display only: described by Scenes_Data)

Scene S1..S30

0: Disabled

1: Enabled

Value input

0..254