User manual

Using@aGlancewithExcelA-20
SIMATIC PCS 7 OSx 4.1.1 @aGlance
Using the @aGlance C old Link Functions (continued)
Use the GetHistory function (Figure A-14) to retrieve a list o f historical trend
values interpolated across a time period.
 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 historical data values.
 AttrRange field — this field is not optional for OSx. The AttrRange is a
range of cells that contain bit names or attribute names. 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.
 OutputRange field — select one or more cells to display the data
requested from OSx. If
#N/A appears in one or more output cells, the
previous cell value, if any, is the last trend value available for the
requested point.
 StartTime field — enter a character string with a maximum total
length of 21 characters to represent the starting point for the required
historical trend. This field requires both a time (such as 9:30AM or
1400) and a date (such as FRI, or TODAY, or OCT 14).
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. For examples
see the
GetHistEvent function.
GetHistory