User manual

Using@aGlancewithExcelA-16
SIMATIC PCS 7 OSx 4.1.1 @aGlance
Using the @aGlance C old Link Functions (continued)
Use the Get function (Figure A-11) to retrieve a list or a table of individual
tag:attribute or tag:attribute:bit data values.
 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 requested data values.
 AttrRange field — this field is not optional for OSx. The AttrRange is a
range of cells that contain tag:attribute names or tag:attribute:bit
names. The bit specified must be in the
bit_defs relation for that
attribute.
 OutputRange field — select one or more cells to display the data
requested from OSx.
 StatusRange field (optional) — select the range of cells to display any
error messages that occur. This range must contain the same number of
cells as the OutputRange.
osxstation1
h_range
l_range
loop1 loop2 ai23
Cells C2--C4, D2--D4, and E2--E4
will display the requested values.
Cells C6--C8, D6--D8, and E6--E8
will display error messages, if any.
pv .5769
.8500
.3400
7800
.8000
.5000
.4423
.2010
.7350
A
BC D E F
GH
1
2
3
4
5
6
7
8
9
10
11
12
13
14
@aGlance/IT Macro Tool
AAG Functions...
ServerName....
TagRange...
AttrRange...
[StatusRange]....
T
ry-it Paste-it Help Close
P
aste-it Cell...
Pause
OutputRange....
“Get”
=$A$2
=$C$1:$E$1
=$B$2:$B$4
=$C$2:$E$4
=$C$6:$E$8
Figure A-11 Get Function
Get