User manual

Using @aGlance with Excel A-19
SIMATIC PCS 7 OSx 4.1.1 @aGlance
You can specify time using a number with one to six digits. The system
acceptsaoneortwodigitnumberashours;athreeorfourdigit
number as hours and minutes; and a five or six digit number as hours,
minutes, and seconds. A colon between fields is optional. If AM or PM
is not specified, the system defaults to a 24-hour clock.
The following are examples of legitimate start or end times:
10AM FRI
10AM FRI + 2 DAYS
10:10:00 MON NEXT DAY
For more information, 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.
osxstation1
pv
Cells C3 --C10 will display the
requested data points.
Cells B3--B10 will display the
appropriate time for each data point.
Cells D3 --D10 will display error
messages, if any.
loop1
10:00:00 Error 10300: Invalid tag specified.#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
A
BC D E F
1
2
3
4
11
12
13
5
6
7
8
9
10
14
@aGlance/IT Macro Tool
AAG Functions...
Server Name...
TagRange...
AttrRange...
OutputRange....
T
ry-it Paste-it Help Close
P
aste-it Cell...
Pause
[StartIndex]...
StartTime...
EndTime...
[TimeRange]....
[StatusRange]....
“GetHistEvent”
=$A$3
=$C$1
=$C$2
=0
=$C$3:$C$10
=“10AM FRI”
=“12PM FRI”
=$B$3:$B$10
=$D$3:$D$10
Figure A-13 GetHis tEvent Function