User manual

Using@aGlancewithExcelA-18
SIMATIC PCS 7 OSx 4.1.1 @aGlance
Using the @aGlance C old Link Functions (continued)
Use the GetHistEvent function (Figure A-13) to retrieve a list of actual
historical trend points for a time period.
 ServerName field — the prefix osx must appear in front of the OSx
station name.
 Tag Range field — select the cell that contains the tag name for the
requested historical data values.
 AttrRange field — this field is not optional for OSx. The AttrRange is a
cell that contains a bit name or an attribute name. For example, you
can use a bit name such as status.active or status.1, or you can use the
status attribute alone. If you specify an attribute name, OSx @aGlance
attempts to retrieve analog trend data. If you specify a bit name,
@aGlance attempts to retrieve digital trend data.
The text following the dot is the bit name. The number following the
dot is a number from 1 to 16 corresponding to the bit number in the
status attribute. Refer to the chapter on defining tags in the SIMATIC
PCS 7 OSx Process Configuration Manual for more information about
bit names.
 StartIndex field (optional) — specify a spreadsheet cell where the index
sent by the server will appear. The server uses this index as a
placeholder when there is more data to return than there are output
cells. By default, the server returns values starting at the beginning of
its database and uses the start index to update additional sets of
values. If you do not specify a spreadsheet cell in this field, or if you
specify a constant, the server sends only the first set of data that fits in
the output range.
 OutputRange field — select one or more cells to display the data
requested from OSx. If
#N/A appears in one or more output cells, there
are no trend values for those cells. This o ccurs if the number of output
cells exceeds the number of trend values for the requested time period.
 StartTime and EndTime fields — enter a character string with a
maximum total length of 21 characters to represent the starting and
ending points for the required historical trend. These two fields require
both a time (such as 9:30AM or 1400) and a date (such as FRI, or
TODAY, or OCT 14).
GetHistEvent