User manual

Using@aGlancewithExcelA-24
SIMATIC PCS 7 OSx 4.1.1 @aGlance
Using the @aGlance C old Link Functions (continued)
See the Command function.
See the
Command function.
Use the
Put function (Figure A-16) to write a list or a table of individual
tag:attribute data values. OSx logs all tag value changes to the OSx
database in the Operator Change Log with the last eight characters of the
IP address in the place of the User ID.
 AttrRange field — this field is not optional for OSx. The AttrRange is a
range of cells that contain attribute names. Write data only to
attributes of process I/O tag types (for example: LOOP or AI). The
process I/O tag types are described in the chapter on defining tags in
the SIMATIC PCS 7 OSx Process Configuration Manual.
 ServerName field — the prefix osx must appear in front of the OSx
station name.
 Tag Range field — select the range of cells that contain the tag names
for the data values being written to the server.
!
WARNING
Writing data to tags other than process I/O tags may result in database values
that could cause unpredictable operation by the controller.
Unpredictable operation by the controller can cause death or serious injury to
personnel, and/or damage to equipment.
When you write data, write only to one of the process I/O tags.
 InputRange field — select a range of cells that contain a set of values to
be sent to the server.
NOTE: Because Excel and Lotus 1-2-3 convert all integer values to floating
point values, you can only write floating point data. This means that you
cannot write integer or bit values to attributes of selected tags from these
applications; a data type mismatch would occur.
Affected tags are the following: CTR, IVAR, DO, DO10, and all of the device
tag types. You can only write to attributes having a domain of FLOAT32,
STRING,orCISTRING.Refertothechapterondefiningtaginthe
SIMATIC PCS 7 OSx Process Configuration Manual for valid attributes.
Node_Roles
Null2Blank
Put