User manual

Using @aGlance with Excel A-21
SIMATIC PCS 7 OSx 4.1.1 @aGlance
 IntervalTime field — enter a text string to represent the time interval
between samples of historical data. For correct syntax, refer to the
appendix on time strings in the SIMATIC PCS 7 OSx Reports Manual.
 TimeRange field (optional) — select the range of cells to display an
actual time string for each set of samples. OSx formats these values so
that you can use them as the StartTime in subsequent commands.
 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. You can, however, extend the size of these
cells; refer to the Excel manual for a procedure.
ai34
osxstation1
Cells C3 --D10 will display the
requested data points.
Cells B3--B10 will display the
appropriate time for each data point.
Cells E3--F10 will display error
messages, if any.
pv
pv
ai38
2:00:00
2:05:00
2:10:00
2:15:00
2:20:00
2:25:00
2:30:00
2:35:00
.0387
.9113
.9875
.4400
.3880
.2737
.6552
.1945
5467
.3434
.5657
.2509
.8966
.6778
.2045
.5858
A
BC D E F
GH
1
2
3
4
11
12
13
5
6
7
8
9
10
14
15
@aGlance/IT Macro Tool
AAG Functions...
Server Name...
TagRange...
OutputRange....
T
ry-it Paste-it Help Close
P
aste-it Cell...
Pause
StartTime...
IntervalTime...
[TimeRange]....
[StatusRange]....
“GetHistory”
=$A$3
=$C$1:$D$1
=$C$2:$D$2
=“2 pm Mon”
=$C$3:$C$10
=“5 min”
=$B$3:$B$10
[AttrRange]...
=$E$3:$F$10
Figure A-14 Ge tHistory Function