Pablo Benvenuto

Learning Lab - PI DataLink Calculations Part 2

Discussion created by Pablo Benvenuto Champion on Sep 14, 2012
After reading the scenario for this Learning Lab in Part 1, you are now ready to follow the step by step instructions below.

Build an Expression Calculation with PI DataLink

1. Open the template.
2. In cell B9, Enter this expression: TagAvg('sinusoid','*-1h','*')
3. In cell B16, Enter this expression: SGN(TagAvg('sinusoid','*-1h','*')-TagAvg('sinusoid','*-4h','*-1h'))
4. Select the cell B11.
5. On the Ribbon, Click PI > Archive Value.

pic6.png

6. In the task pane select the PI Expression radio button.
7. In the task pane click in the Expression field.
8. Click on cell B9.
9. Enter * in the Timestamp field.
10. Click on the OK button.

pic7.png

11. Select cell B18.
12. On the Ribbon, Click PI > Archive Value.
13. In the task pane select the PI Expression radio button.
14. In the task pane click in the Expression field.
15. Click on cell B16.
16. Enter * in the Timestamp field.
17. Click on the OK button.
18. Select cell H2 in its upper left hand corner.
19. On the Ribbon, Click Home > Conditional Formatting > Highlight Cells Rules > Equal To…

pic8.png

20. Select Custom Format… from the with drop-down option.

pic9.png

21. Choose a green color for the filling of the cell.
22. Click on the OK button.
23. Repeat steps 18 – 22 while in the same Conditional Formatting window but for the association between the red color and value -1.
24. Press CTRL+Alt+F9 to refresh the spreadsheet.

You now have a nice report to compare production speeds with a quick indication of whether the trend is improving or not.

Outcomes