DeltaV入门教程 翻译：李俊峰
4. Click the Add button and then click the Browse button on the Parameter Reference Entry dialog box.
5. Select Module Parameters in the Object Type field and browse in the TANK-101 area for FIC-101/PID1/PV.CV to plot the value of the outlet flow.
6. Click OK in the Parameter Reference Entry dialog.
7. Back in the Configure Chart dialog, click Add and browse for LI-101/AI1/ PV.CV to plot the value of the tank level in the tank process. 8. Click OK.
9. Click in the New Axis check box for LI-101/AI1/PV.CV.
10. Click the Multiple Y-Axes tab.
11. Click the down arrow and select 50/50 in Axes Styles box to create two Y scales to plot the data values.
DeltaV入门教程 翻译：李俊峰
12. Click the Configure Chart tab, and enter MYGRAPH as the Graph Title. 13. Click OK to close the Configure Chart dialog.
The graph appears, showing module trends for the two parameter references, as well as the events in area TANK-101.
The Process History View application has numerous graph configuration options and event filtering options that are described in the Online Help. Tip Click Trend | Plot Method to change the line style. 14. Close the Process History View application. Excel Add-In
The Excel Add-In lets you read and write DeltaV parameters through Microsoft Excel. You can use the reporting and database management power of Excel to generate reports, create charts, and customize tasks.
In this exercise, you will set up an Excel worksheet to read a parameter value from the control strategy you installed in your controller. This includes setting up the Add-In,
DeltaV入门教程 翻译：李俊峰
setting an update interval, and reading a parameter. This exercise assumes that you have Excel installed on this workstation, that you are familiar with Excel, and that you have installed your control strategy in the controller.
Setting up the Excel Add-In
In order to use the Add-In, you must select the Add-In from Excel. This makes the Add-In functions available to you any time you use Excel. If the Add-In is loaded when Excel is shut down, it will still be loaded when Excel is started again. To set up the DeltaV Excel Add-In 1. Start Excel.
2. Select Tools | Add-Ins.
3. In the Add-Ins dialog box, select Browse and navigate to the Excel directory in your root DeltaV directory. For example, C:\\DeltaV\\Excel
4. Select DeltaV.xla and click OK.
The Add-Ins dialog box now has an entry for DeltaV Real-time Data that is checked. Using the Excel Add-In
After you load the DeltaV Excel Add-In, Excel shows a floating toolbar with two DeltaV function wizard buttons on the worksheet. The function wizard helps you create DeltaV functions on your worksheet that let you read and write real-time data and execute write functions. To set the update interval
1. Select a cell in the workbook where you want to store the update interval. The update interval is the rate at which the workbook data is refreshed. 2. Click the Create DeltaV function wizard button. The first function wizard dialog appears.
3. Click Set Shortest Update Interval and click Next. The Set Minimum Update Interval dialog appears.
DeltaV入门教程 翻译：李俊峰
4. Click Selected so the update interval is stored in the currently selected cell. 5. Select an update interval.
The smallest recommended update interval is 5 seconds. 6. Click OK.
To read a parameter value
1. On the worksheet, select a cell to contain a DeltaV read function. (Select a different cell than the one containing the update interval.)
This is where the Add-In will write the parameter value. Choose a cell with at least one blank cell to the left. The blank cell will be used to display the parameter name you are reading.
2. Click the Create DeltaV function wizard button.
3. On the Function Wizard dialog, click Read Real-Time Data and click Next. 4. On the Read Real-Time Data dialog, click Browse to select a parameter.
The Browse Parameters dialog appears. To read the value of the tank level in the tank process, browse for the PV of LI-101.
5. In the TANK-101 area, double-click LI-101, double-click the PV parameter, and double-click the CV field.
6. Make sure the data type is set to numerical to return a numeric value.
7. Select the check box to have the parameter path pasted to the left of the function that is being created.
DeltaV入门教程 翻译：李俊峰
8. Click Finish.
Note Because this is not a working process, the read cell will not return a process value. If the process were running, this cell would show the value of the tank PV and would update at the update interval.
9. Close Microsoft Excel without saving the workbook.
Continuous Historian Excel Add-In
The Continuous Historian Excel Add-In provides four functions (to configure single value, raw, interpolated, and calculated data) that aid in the creation of detailed Excel workbooks containing historical data read from the Continuous Historian database. Refer to the Continuous Historian Excel Add-In topic in the Books Online Configuration book for more information on this add-in.
8 配置网络、下载和分配许可、设置用户权限