Pablo Benvenuto

Learning Lab - Operational Start Up Part 2

Discussion created by Pablo Benvenuto Champion on Sep 12, 2012
Latest reply on Jan 27, 2015 by Hemalatha
The most interesting part of this Learning Lab is the scenario, which you can read in Part 1.  If you have already done so, here is the solution.

Comparing Operational Start Up data

1. In the template select cell A10.
3. On the Ribbon, Click PI > Compressed Data.
4. In the task pane select the Number of Values radio button.
5. In the task pane click in the Tagname field, and click on cell B3.
7. In the task pane click in the Start Time field and click on cell B5.
9. In the task pane click in the Number of Values field and click on cell B6.
11. In the task pane select the Show Timestamps check box and click on the OK button.

pic9.png

13. Now select cell D10, and repeat the previous steps modifing the Start Time field for the today’s start time in cell B4.
15. Now we will compare the data.  Select cell K3.
16. In the Formula Bar, select all content except the single quote at the beginning of the expression.
17. Paste the expression without the single quote into cell G10.
18. Propagate the result down to cell G39 by dragging the cell by the lower-right corner (cursor will change to a black cross).
19. Select cell K6.
20. In the Formula Bar select all, except the single quote at the beginning of the expression.
21. Paste the expression without the single quote into cell I10.
22. Propagate the result down to cell I39 by dragging the cell’s handle at the lower-right corner.

You now have a nice little tool to compare Operational Start Up data.

MORE LEARNING OPTIONS

You can watch this Learning Lab in video format below. We also have an online PI DataLink Basic workshop. Check out the Workshop Outline.

http://youtu.be/DXzvKtYRJdc

Outcomes