Specifications

Microsoft Excel Reports
PlantScape Server and Client Configuration Guide 265
Microsoft Excel Reports
With Microsoft Excel Reports you can:
• Get values from point parameters
• Perform calculations on those points
• Retrieve historical data to determine summations, maximums, minimums,
and standard deviations
• Retrieve alarms and events
• Generate graphs and tables
• Store new values or calculations in the server database, provided you
installed Microsoft Excel Data Exchange with the “write” option enabled.
Microsoft Excel reports enable you to design a custom report in Microsoft Excel,
which is configured and run from Station like other PlantScape reports. You can
use Microsoft Excel Data Exchange or the PlantScape ODBC Driver to access data
in the server database from Microsoft Excel. Refer to “Using PlantScape Data in
Other Applications” on page 391 for further information on these. When the
report runs this data is refreshed and a copy of the data is saved.
Note If you create a new spreadsheet for Integrated Microsoft Excel Reports prompts
and error messages are not visible in Station. You need to open the new
spreadsheet in Microsoft Excel using the mngr account before running the report
in Station.
Choosing between Microsoft Excel Data Exchange and ODBC
Microsoft Excel Data Exchange is a licensable option for PlantScape, and the
PlantScape ODBC driver is standard. Points to consider when choosing between
Microsoft Excel Data Exchange and the ODBC Driver are:
They have different installation requirements (for details, see the Installation
Guide).
• Microsoft Excel Data Exchange can access all information in the server
database, the ODBC Driver can only access point, history, event, and some
access control data.
• Microsoft Excel Data Exchange can write to the server database.
• The ODBC Driver follows the same security conventions as other reports,
while Microsoft Excel Data Exchange has no security.
plscpcg.book Page 265 Monday, May 28, 2001 10:11 AM