Pablo Benvenuto

Learning Lab - Quality Control Report Part 2

Discussion created by Pablo Benvenuto Champion on Oct 17, 2012
In Part 1 of this learning lab we explained the problem that we are trying to solve and the approach we are going to take.  Now it is time to do the work.  Follow these instructions to complete the lab.

Step by Step Solution

Open the file called Quality_Control_Report_Template.xlsx.  In the Virtual Learning Environment this file is found in C:\Labs\Visuals\Quality Control Report\Workspace.  You can also find it here.
  • In cell
  • B4, enter the tag name 'BA:PHASE.1
  • In cell
  • B5, enter the expression: ''BA:CONC.1' / 100.     
  • In cell
  • B6, enter the expression: ''BA:TEMP.1' * 10.     
  • In cell
  • B9, build the filter expression to use: ''BA:PHASE.1'="Phase1" OR 'BA:PHASE.1'="Phase3" OR 'BA:PHASE.1'="Phase5"     
  • Select cell
  • A12 and Select PI > Compressed Data...     
  • In the dialog window click in the
  • Tagname(s) field and click on cell B4.     
  • Select the
  • Start Time field and click on cell B7.     
  • Select the
  • End Time field and click on cell B8.     
  • Selelct the
  • Filter Expression (optional) field and click on cell B9.     
  • Check the
  • hide count option to remove the number of values extracted.     
  • Check the
  • show timestamps option.     
  • Click on the
  • OK button.

Now to extract the conductivity measurement at the phase’s change, we need to use the individual timestamps returned by the Compressed Data function as input timestamps for the Archive Value function.
  • Let us start by selecting cell
  • C12.     
  • Select
  • PI > Archive Value...     
  • Select the
  • PI Expression radio button in the dialog window.     
  • Select the
  • Expression(s) field and click on cell B5.     
  • Select the
  • Timestamp field and click on cell A12.     
  • Select the
  • Output Cell field and click on cell C12     
  • Click on the
  • OK button.     
  • Select cell
  • C12. In the Formula Bar, localize the second argument (this will be a cell reference) and click on the text forming the cell address.

qcr2.png
     
Press on the F4 key on the keyboard two (2) times. This will transform the absolute cell reference into a row relative cell reference. It means the dollar sign in front of the row position will be removed. You will then see a reference like Sheet1!$A12 instead of Sheet1!$A$12.
Propagate the result down to cell C150 by dragging the cell’s handle at the cell’s lower-right corner.

To extract the temperature measurement at the phase’s change, we need to use the individual timestamps returned by the Compressed Data function as input timestamps for the Archive Value function.
  • Let us start by selecting cell
  • D12.     
  • On the Ribbon, Click
  • PI > Archive Value...     
  • Select the
  • PI Expression radio button in the task pane.     
  • Select the
  • Expression(s) field.     
  • Click on cell
  • B6.     
  • Select the
  • Timestamp field.     
  • Click on cell
  • A12.     
  • Click on the
  • OK button.

Select cell D12. In the Formula Bar, localize the second argument (this will be a cell reference) and click on the text forming the cell address.
Press on the F4 key on the keyboard two (2) times. This will transform the absolute cell reference into a row relative cell reference
Propagate the result down to cell D150 by dragging the cell’s handle at the lower-right corner.

Next, we will use the Advanced Calculated Data function to extract the conductivity.  Go to Part 3.

Outcomes