Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 word and bit addresses for real tags follow the correct device address format.

...

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
Virtual Tag = 0

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: UINT16
5: UINT32
6: BCD8
7: BCD16
8: BCD32
9: UBCD8
10 UBCD16
11: UBCD32
12: Float

String Length

 

J

 

 

 

 

 Unused

K

 

 

 

 

 Unused

L

 

 

 

 

 Unused

M

 

 

Scale Mode

 

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

...