Section 1 – Introduction 5-19
Information that you specified using the wizard are assigned to cells in the worksheet. The
following values will be returned based upon the type of Analysis you chose.
Analog values
Analog Tag Batch Scatter Discrete tag at discrete Analog/
analysis Analysis Analysis Analysis transition Discrete
Analysis
Server Server Server Server Server Server
Tag Tag Tag 1 Tag Discrete Tag Discrete Tag
Row or Start Time 1 Tag 2 Row or Analog Tag Analog Tag
Resolution Chart Legend Resolution
Start Time Row or Row or Start Time Row or Row or
Resolution Resolution Resolution Resolution
Duration Start Time Start Time 1 Duration Start Time Start Time
Low Limit Duration Duration Duration Duration
High Limit Start Time 2 Start Time 2 Row or
Chart Legend resolution to
use for the
discrete tag
Start Time 2
m. Click in the workbook to view the functions that are inserted to create the analysis report.
Wonderware System Platform Course - Part 2
5-20 Module 5 – ActiveFactory Workbook
– Intentionally left blank –
Wonderware Training
Lab 8 – Using ActiveFactory Workbook Basic Functions 5-21
Lab 8 – Using ActiveFactory Workbook Basic
Functions
Introduction
The following lab will demonstrate the basic functionality of ActiveFactory Workbook.
Objective
Upon completion of this lab you will be able to:
z Connect to the Server
z Insert a Live Value Function
z Insert a History Value Function
z Report Historian process data within the Excel spreadsheet environment
Wonderware System Platform Course - Part 2
5-22 Module 5 – ActiveFactory Workbook
Create a new ActiveFactory Workbook
1. From the Start button on the Windows Taskbar, select All Programs / Microsoft Office /
Microsoft Office Excel.
2. Enter a report heading in cell A1. For this lab, Meters is the heading.
3. Change the font face and size to Arial 14 Bold.
4. Enter =NOW() in cell A2. This cell will display the current date and time.
5. Press the Enter key.
6. Right-click cell A2 and select Format Cells from the submenu.
7. On the number tab, configure the format options as shown in the next figure.
8. Click OK.
The report should now look like the following figure:
Wonderware Training
Lab 8 – Using ActiveFactory Workbook Basic Functions 5-23
Insert a Live Value Function
9. Select cell A4.
10. Select ActiveFactory / Tag Selection / Tag Selection from the main menu.
The Tag Selection dialog box appears:
Wonderware System Platform Course - Part 2
5-24 Module 5 – ActiveFactory Workbook
11. Select the Historian icon.
12. In the Tag name: field of the Filter pane, enter %.PV.
13. Click the Exact match checkbox.
The Apply button becomes enabled.
14. Click Apply. All tags ending with .PV are displayed.
15. Pressing the Control key, select LIT_001.PV and TT_001.PV tags.
16. Ensure that the Select cell range to insert tags: field reads $A$4.
17. Click OK.
The tags appear from cells A4 through A5:
18. Select cell B3.
19. Select the Live Values button on the Workbook toolbar.
Wonderware Training
Lab 8 – Using ActiveFactory Workbook Basic Functions 5-25
Note: Binding Options (accessed using the Binding Options >> command button) are
explained in a subsequent lab. Do not click the Binding Options>> button.
20. Insert your cursor into the Select cell(s) containing tag name(s): field in the Live Values –
Step 1 of 3 dialog box.
21. Click on cell A4.
22. Press the left mouse button and drag the cursor over the remaining tagname cells.
23. Click Next.
24. Ensure the output location is cell B3 (using the previous steps).
25. Click Next.
Wonderware System Platform Course - Part 2
5-26 Module 5 – ActiveFactory Workbook
26. Leave the default settings in the Live Values - Step 3 of 3 dialog box.
27. Click Finish.
The data is displayed in the spreadsheet:
Note: To view the function that was created, click in any cell containing results (this does not
include the headings). The function appears in the formula bar.
{=wwAnalogLive("WWSYSPLATFORM2",Sheet1!$A$4:$A$6,TRUE,TRUE,FALSE,TRUE,
FALSE)}
28. Click the Refresh Sheet button in the Workbook toolbar to see the tag values change within
the cell fields. .
29. Save the report in C:\Wonderware Training\Labs as MyReport.xls.
Wonderware Training
Lab 8 – Using ActiveFactory Workbook Basic Functions 5-27
Insert a History Value Function
30. Select the Sheet 2 tab.
31. Click the History Values button in the Workbook toolbar.
Step 1 of the History Values function wizard appears. The Tag reference field should
reference the two tags used in the previous task (if not, use the previous steps to reference
LIT_001.PV and TT_001.PV).
32. Click Next.
33. Ensure the output cell is A1 on Sheet 2 in the History Values - Step 2 of 4 dialog box, using the
previous steps, and click Next.
Wonderware System Platform Course - Part 2
5-28 Module 5 – ActiveFactory Workbook
34. Click the More>> button to see all of the display options.
35. Select the wwRetrievalMode, wwCycleCount, and wwTimeZone options.
36. Click the Format tab.
37. In the Format tab, select the Tag based Criteria (wide tables) option.
38. Click the Retrieval tab.
39. Change the Retrieval mode to BestFit.
40. In the Cyclic attributes pane of the Retrieval / Main options tab change the Values over equal
time intervals to 100.
41. Click the Order tab.
Wonderware Training
