Pablo Benvenuto

Learning Lab - Quality Control Report Part 3

Discussion created by Pablo Benvenuto Champion on Oct 17, 2012
If you completed Part 2 of this lab, your are ready to continue where you left of.

To extract the conductivity peak we need to use the Advanced Calculated Data function and put the result on cell F13;
  • select cell
  • F13.
  • Select
  • PI > Advanced Calculated Data...
  • Select the
  • PI Expression radio button in the dialog window and click on cell B5
  • Select the
  • Start Time field and click on cell B7.
  • Select the
  • End Time field and click on cell B8.
  • Select the
  • Filter Expression (Optional) field and click on cell B9.
  • In the
  • Calculation Mode drop-down select maximum.
  • Check the
  • show min/max time option.
  • Click on the
  • OK button.

To extract the temperature peak we need to use the Advanced Calculated Data function and put the result on cell F17;

select cell F17.
Select PI > Advanced Calculated Data...
Select the PI Expression radio button in the dialog window and click on cell B6.
Select the Start Time field and click on cell B7.
Select the End Time field and click on cell B8.
In the task pane click in the Filter Expression (Optional) field.
Click on cell B9.
In the Calculation Mode drop-down select maximum.
Check the show min/max time option.
Click on the OK button.

We need to make this report more appealing for the verification; we will use the Conditional Formatting capabilities of MS Excel to make it through. Select cell range from C12 to C150.

Select Format > Conditional Formatting...

qcr3.png

In the entry for Condition 1, set the lists to Cell Value Is and greater than, and in the last field, enter the number 0.49. Select Format, and on the Patterns tab, select a red for the cell fill. Click on the OK button. The first condition is defined.
Click on the OK button.

Select cell range from D12 to D150.
Select Format > Conditional Formatting...

qcr4.png

In the entry for Condition 1, set the lists to Cell Value Is and between. Then enter the range from 0 to 500. Select Format, and on the Patterns tab, select a blue for the cell fill. Click on the OK button. The first condition is defined.

Now select Add from the Conditional Formatting dialog box. For this condition, when the cell is greater than 500, change its color pattern to red. Click on the OK button to save the conditional formatting.

Click on the OK button.

The resulting report should look like the one shown in Part 1 of this lab.

Outcomes