How to work with excel to create alias and variable name
What is the Shows how easy to configure PLC data variable using excel
purpose
What units are 1. Unity Pro
effected
Details This application is divided into several parts
Section Title
1 Parts List
2 Step by Step
3 Online Testing
4 Remarks
Section 1: Parts list
Parts List table Items used in the test
Items Part numbers Description
Software UNYSFUPUV1X Unity Pro XL
Section 1: Parts liststep by step
Step by step configuration software on Unity Pro :
Software Configuration:
1. Configure the Variables ( DDT or Elementary,etc ) :
2. Export the variable to *.xsy file
3. Open the excel tool name Unity pro variable [Link] file on folder
Documents\Schneider Electric\Unity Pro\Extras\Excel Import Export Tool
4. Import the variable file *.xsy using excel tool
5. After finished edited the variable ( add variable, create alias, create DDT variable, etc ),
save the file in *.xsy file and import back to unity pro :
Section 3: Online Testing
Online testing :
1. Simulate the export and import variable in variable window editor
2. Test the program
3. Here the sample program attributes of unity pro software to check if
the edited using excel sucessfull
Section 4: Remark
The Unity pro excel tool will help the engineer to do check and create variable
uickly using Microsoft excel program, this feature will reduce the engineer time to do
commissioning offline and also avoid the human error.
This feature is available on unity pro V10. With the newest version now the
engineer can get many benefits.