Specifications

20 – Using PlantScape Data in Other Applications
454 R400
Using Microsoft Excel Data Exchange
Using the Microsoft Excel Data Exchange option, you can capture real time point
value and history information from PlantScape and display the data in an Excel
spreadsheet.
Data can be retrieved from PlantScape by using either the Microsoft Excel Data
Exchange Wizard, or through cell formulas. The captured data can be static or
dynamically updating, and can consist of either point parameter or historical data
from any PlantScape server database on the network.
Once the data has been captured you can create charts to display and analyze
data with Microsoft Excel’s toolset. You can also link the values into other
OLE-enabled applications.
Microsoft Excel Data Exchange gives:
• Read/write access to point parameter values (for example, read the PV of
point ID=T1C123)
• Read access to history data
• Read/write access to PlantScape database files (user files)
Using the Microsoft Excel Data Exchange Wizard
The following procedures explain how to capture point or history values and
display them in Microsoft Excel using the Microsoft Excel Data Exchange Wizard.
Before beginning any of these procedures:
1 Start Microsoft Excel.
2 Open the worksheet in which you want your data displayed.
3 Highlight the cell that is to be the starting point for the data.
Retrieving Point Parameters
A cell in a Microsoft Excel worksheet can display the value of a parameter of a
point configured on a particular PlantScape server, for example, the PV of point
01T1LEVEL from the server hsserv.
To display a particular point parameter:
1 Select Tools
⇒
Microsoft Excel Data Exchange
⇒
Wizard.
2 Select Get point values from server(s).
Specify the target point parameters:
a) Enter the name of the PlantScape server.
plscpcg.book Page 454 Monday, May 28, 2001 10:11 AM