Now that you completed Part 2 of this learning lab you are ready to finish the last part.

With the cursor in cell

With the cursor in cell

The final spreadsheet should look like the figure presented in Part 1.

With the cursor in cell

**C16**, select**. To fill in the various boxes, use these guidelines to calculate the average length of saleable boards produced:***PI > Advanced Calculated Data*- With
*PI Tag*selected reference to the appropriate cells for the.*Tagname*,*Start**Time*,*End**Time*and*Time**Interval*- In the
field enter a reference to*Filter Expression***B9**. This will limit the average of saleable boards to those above 5 feet.- We are performing an average of the value of the events that have been written to the server, so set the
. The conversion factor must, therefore, be equal to 1.*Calc. Mode*to*Average*- Set
. This will assure that only the archived values are averaged.*Expression Sampling*to*pt. compressed*- Since we are looking for the average of the event values (a.k.a. boards produced), select
in the*event-weighted*box.*Calculation Basis*- Do not show timestamps, they are identical to those produced in Column
**A**.- Press the
button to see the results.*OK*

With the cursor in cell

**D16**, select PI*> Advanced Calculated Data*. To fill in the various boxes, use these guidelines to calculate the total value of scrap produced:- With
selected reference to the appropriate cells for the Expression, Start Time, End Time and Time Interval. The Expression is the cost of a foot of scrap multiplied by the measurement for each board.*PI Expression*- In the
field, enter a reference to*Filter Expression***B10**. We want the value of all boards less than 5 feet to calculate the scrap value.- We are performing a
of the value of the expression every time a board less than 5 feet is produced, so set the*Total*. The conversion factor is equal to 1 since these are not “per time” measurements.*Calc. Mode*to*Total***Set**. This will assure that the expression is only evaluated when a board has actually been produced.*Expression Sampling*to*Compressed*- Since we are looking for the total based upon event values (i.e. boards produced), select
.*event-weighted*in the*Calculation Basis*box- Do not show timestamps, they are identical to those produced in Column
**A**.- Press the
button to see the results.*OK*

The final spreadsheet should look like the figure presented in Part 1.