...
Copying from the database to Excel
a) Select the tag or tags to be copied to Excel. You can select multiple tags using [Shift + Left-click] or [Ctrl + Left-click]. When you select a group tag, the subordinate tags are also selected.
...
d) Edit the database in Excel. You can automatically create consecutive tags with Excel’s increment/decrement feature. Note: Excel’s auto-increment feature does not work for hexadecimal values. Please double-check that bit addresses for real tags follow the correct device address format.
...
Pasting from Excel to the database
...
Column | Group Tag | Digital Tag | Analog Tag | String Tag | Note |
A | Tag Name | Tag Name | Tag Name | Tag Name |
|
B | Tag Type (0) | Tag Type (1) | Tag Type (2) | Tag Type (3) |
|
C | Description | Description | Description | Description |
|
D |
| Real/Virtual Tag | Real/Virtual Tag | Real/Virtual Tag | Real Tag = 1 |
E |
| I/O Device | I/O Device | I/O Device | Stored as a string |
F |
| I/O Address | I/O Address | I/O Address | Stored as a string |
G |
| Initial Value | Initial Value | Initial Value |
|
H |
|
|
| Unused | |
I |
| Data Type 0: INT8 1: INT16 2: INT32 3: UINT8 4 4: UINT16 4 5: UINT32 4 6: BCD8 7: BCD16 8: BCD32 9: UBCD8 10 : UBCD16 11: UBCD32 12: Float | String Length |
| |
J |
|
|
|
| Unused |
K |
|
|
|
| Unused |
L |
|
|
|
| Unused |
M |
|
| Scale |
| Scale/Offset=1 Min./Max. = 0 |
N |
|
| Eng. Data Min. Value |
|
|
O |
|
| Eng. Data Max. Value |
|
|
P |
|
| Raw data Min. Value |
| SCALE value if SCALE/OFFSET is applied |
Q |
| Raw data Max. Value | OFFSET value if SCALE/OFFSET is applied |
...