Lab 8 – Using ActiveFactory Workbook Basic Functions 5-29
42. Order by DateTime by selecting the DateTime field and clicking the > button.
43. Click Next.
44. Accept the (default) last 10 minutes. This defines the relative time period of the query
function.
45. Click Finish.
Wonderware System Platform Course - Part 2
5-30 Module 5 – ActiveFactory Workbook
The query returns evenly spaced values for the specified time period.
46. Close MyReport.xls, leaving Excel running. Do not re-save the report; the version of the
report you saved earlier will be used in a subsequent lab.
Wonderware Training
Lab 9 – Use Other ActiveFactory Workbook Functions 5-31
Lab 9 – Use Other ActiveFactory Workbook
Functions
Introduction
The following lab will demonstrate the functionality of the ActiveFactory Workbook Aggregate,
Named Ranges and Query Functions.
Objective
Upon completion of this lab you will be able to:
z Insert an Aggregate Value Function
z Configure Named Ranges
z Report Historian process data within the Excel spreadsheet environment
Wonderware System Platform Course - Part 2
5-32 Module 5 – ActiveFactory Workbook
Insert an Aggregate Value Function
Aggregate values are calculated from Historical values of selected Analog or Discrete Tags.
In this section, we will return the average value of the SysTimeSec tag for the past 5 minutes. This
is useful because it is a known value that can easily be verified.
1. Press the Ctrl+N keys. This creates a new document.
2. Enter SysTimeSec in cell A1.
3. Enter the words Start Time and End Time in cells A3 and A4, respectively.
4. Insert a start time value in cell B3. An example of the format for the time value is 1/12/2007
12:00.
Your instructor will assist you with definition of a time range.
Be sure to press the Enter key after inputting the date value.
5. Place an End time value (5 minutes after the previous time value) in cell B4.
6. Press the Enter key.
The worksheet should now appear similar to the following figure:
7. Click the Aggregate Values button within the
ActiveFactory toolbar . Notice the Aggregate Values
icon in the ActiveFactory toolbar is identical to the AutoSum icon in the Excel toolbar. Be sure
to select the correct icon.
Wonderware Training
Lab 9 – Use Other ActiveFactory Workbook Functions 5-33
8. Select cell A1 to define the SysTimeSec tag.
9. Click Next.
Ensure the output cell is Sheet1!$A$7.
10. Click Next.
Wonderware System Platform Course - Part 2
5-34 Module 5 – ActiveFactory Workbook
11. Select the Calculations tab in the Aggregate Values Step 3 of 4 dialog box.
12. Select Average Calculation Type.
13. Click Next.
14. Select the Absolute Time option.
15. Click the first radio button after Absolute Time (upper field).
16. Insert your cursor into the left-hand Absolute Time (start) field.
17. Select cell B3 in the Excel worksheet. The cell animates and its address should appear in the
field.
18. Repeat the above steps to insert the End Time value into the second field. The end time is
contained in cell B4.
19. Click Finish.
The aggregate value appears in the worksheet:
20. Alter the times in cells B3 and B4. The tag Average should change accordingly.
Wonderware Training
Lab 9 – Use Other ActiveFactory Workbook Functions 5-35
Configure Named Ranges
Excel includes a useful feature called Named Range. You can assign a name to a group of cells,
and then refer to the name rather than the cell addresses. In this task we will reference a named
range containing several tagnames.
21. Highlight cell A1 on Sheet 2 of the Workbook.
22. Select ActiveFactory / Tag Selection / Tag Selection from the main menu.
Notice that the filter information is still applied.
23. Select the following tags using the Ctrl key:
LIT_001.PV
TT_001.PV
InletValve_001.PV
24. Click OK.
Wonderware System Platform Course - Part 2
5-36 Module 5 – ActiveFactory Workbook
25. Select the first cell of the series (A1).
26. Press the Ctrl+Shift+Down Arrow keys. The entire column of tagnames will be selected.
27. Insert your cursor into the Excel name box and enter AnalogTags (no spaces).
28. Press the Enter key to ensure the entire range has been named.
29. Click Sheet 3 of the Workbook.
30. Highlight cell A1 on Sheet 3 of the Workbook.
31. Select ActiveFactory / Tag Values / Live Values from the main menu.
The Live Values - Step 1 of 3 dialog box appears.
32. Enter AnalogTags in the Select cell(s) containing tag name(s): field.
33. Click Next.
34. Ensure the output cell location is correct ($A$1) in the Live Values - Step 2 of 3 dialog box.
35. Click Next.
36. Accept the default display options in the Step 3 of 3 dialog box: Click Finish.
The tag range is inserted into the worksheet.
Note: You can also name cells containing the start and end times, and then reference them by
name in history and aggregate functions.
Wonderware Training
Lab 10 – Use the Tag Analysis Wizard 5-37
Lab 10 – Use the Tag Analysis Wizard
Introduction
The following lab demonstrates the functionality of ActiveFactory Workbook’s Tag Analysis Wizard
in order to display various chart analyses.
Objective
Upon completion of this lab you will be able to:
z Use the Tag Analysis Wizard to add Process Data charts to an Excel report
z Create applied data representations within Excel
Wonderware System Platform Course - Part 2
5-38 Module 5 – ActiveFactory Workbook
Use the Tag Analysis Wizard
This task demonstrates configuration of a Scatter Analysis.
1. Click File / New to create a new Workbook.
2. Select ActiveFactory / Tag Analysis from the Excel main menu.
3. Select Scatter Analysis from the list in the Wizard.
4. Click Next.
5. Ensure that the server name displays your Historian within the Select Tags area.
6. Select the LIT_001.PV and TT_001.PV tags using the Ellipsis buttons in the dialog box to
open the Tag Selection control.
7. Click Next.
8. Select the time range you would like to use for the analysis.
For this task, your instructor will guide you in selecting an appropriate time range.
9. Click Next.
From this dialog box you can specify the resolution (number of rows and spacing).
Wonderware Training
