Define data references for the temperature attribute

Before you can define data references, you need to complete the following tasks:

• Create PI points for reactors.

• Retrieve the reactor elements.

To create a PI point data reference with PI Builder, you must define an attribute configuration that references the PI point. Follow this procedure to define a data-reference configuration for the temperature attribute of elements in the reactor template. You will reference the PI points you created previously for reactors.

1. In a new worksheet, retrieve the PI points that you created for reactors, and sort the points by name:

   1. Click PI Points > Find PI Points to open the Tag Search window.

   2. In the text box, type Data_React* and click Search to retrieve the points into the results table.

   3. Select the ten points that you created and click OK.

   4. In the Select Object Types and Column Headers window, click Clear All to clear all columns other than the required columns, and then click OK to retrieve the points into the worksheet.

   5. Sort the Name column by ascending values.

   6. Copy the cells that contain the names.

2. In the worksheet with the retrieved reactor elements, add the PI points next to the retrieved columns:

   1. In rows 2 through 11 of column G, paste the names of the PI points you created for the reactors.

   2. Leave the column header blank.

   3. Leave at least one column empty between the retrieved PI AF columns and the points that you added.

   The worksheet should look something like this:

   

3. For the first element, define the configuration string of the temperature attribute and link to a point:

   1. On the Home tab, verify that the cell format for cell E2 is set to General.

   (PI Builder reformats many cells as text.)

   1. In cell E2 (the |Temperature Attribute column of the React1 element), type the configuration string ="=\\%Server%\"& and then click cell G2 to link to the point.

      Note: %Server% is a substitution parameter that PI Builder will replace with the name of the default Data Archive of the PI AF database in which the attribute resides. See Learn about attribute configuration strings for more information.

   2. Press Enter.

      The full formula should be:

      ="=\\%Server%\"&G2

4. Click cell E2 and drag the fill handle across the remaining cells in the column to copy the configuration of the first element with the row-relative point reference.

   The worksheet will show the appropriate point in each temperature attribute configuration.

   

   For more information on the format of data references in attribute columns, see Understand how to view data references.