User manual
Using @aGlance with Excel A-9
SIMATIC PCS 7 OSx 4.1.1 @aGlance
Use the cold link macro Get to check the value(s) that should be
changing. If the value returned by the macro does not match that
displayed by the hot link, the hot link has failed. Refer to Section 1.5
for help.
If you notice that a hot link does not seem to be updating properly when you
open your spreadsheet, close the spreadsheet and reopen it to restart the
hot links. Sometimes a hot link is disabled because OSx has been set to the
Offline state and then back to the Operate state.
For Linux, UNIX and Windows (Excel) clients, it is recommended that you
process updates from the server at the rate that the server is sending them.
This helps prevent server/client communication problems that could cause
theservertoshutdown.
You have the option of using a configurable millisecond delay in the OSx
@aGlance server, which delays monitor update messages to the client. The
default is 500 ms (0.5 seconds), and the range is 0 to 999 ms. This delay
allows the client to remove incoming messages from the message buffer,
making room for the next message(s) from the server. This reduces the
possibility of the client’s becoming unable to keep up with the server
processing. For information about changing the length of the delay, contact
the Siemens Energy & Automation, Inc., Technical Services Group in the
U.S.A. at 423--461--2522. In other countries, call 49--911--895--7000.
When using hot links, reduce the number of points per hot link as the rate
of change of the points that you are monitoring increases. This allows the
server to keep up with rapidly changing data and to send that information
to the client.
Monitors (hot links) and Excel @aGlance macro requests for data (cold links)
may return different values for the same data point. Values greater than
32767 stored in the OSx database are displayed as negative values in a
monitor request, while displaying correctly in an Excel @aGlance macro
request.
For example, 32769 in the OSx database is displayed as 32769 in an Excel
@aGlance macro request for a data point, but is displayed as --32767 in a
monitor request for the same data point.
Version 3.2 of the Excel @aGlance Add-in corrects this problem.
To end an OSx @aGlance session, you can use the macro tool and select the
Disconnect function, or you can exit Excel. It is not necessary to log off OSx.
Hot Link Update
Delay
Different Values for
theSameData
Point
Closing a Session