Summary Reporting | | FlowWorksFlowWorks

This video shows how to use Summary Reporting.

Summary Report Instructions

This section explains how to use the Summary Reports tool. Summary Reports can be generated for nearly every type of measurement that can be stored in FlowWorks.

Once you have logged in and selected ‘Reporting’ in ‘My Network’ you will see ‘Summary Reports’ in the lower half of the ‘My Network’ task bar.

Summary Reports Tool

The summary reports can be created in a ‘Yearly’ mode, in which only one measurement can be selected, or a ‘Monthly’ mode, in which up to three measurements can be selected.
For Yearly Summary Reports

Select a Mode
Select a Site
Select the Year for Report
Select the Measurement to Report
Generate Report Table
Interpreting Results
Printing and Extracting Report Table

For Monthly Summary Reports

Select a Mode
Select a Site
Select the Month and Year for Report
Select the Measurement(s) to Report
Generate Report Table
Interpreting Results
Printing and Extracting Report Table

Yearly Summary Report

1. Select a Mode

Select the Mode that you would like to use for the report. For this example we will select the ‘Yearly’ mode.

Yearly Summary Mode Selection

2. Select a station

Select the station site you want a report for from the dropdown menu. For this example we will select the station Demo AV Meter- Metric. 3. Select the Year for the Report

Select the Year you want the report to be for. For this example we will select 2009.

Year Selection

4. Select the Measurement to Report

Select the measurement you want to be reported. For the ‘Yearly’ mode only one measurement can be selected for each report. For this example we will select ‘Level’.

Measurement Selection

5. Generate Report Table

Once you have selected the station, year, and measurement click on ‘Veiw Summary Report’ and a report table should appear showing the Report Table for the measurement selected. If the report table does not appear, you may have pop-ups blocked. Please see the XX tutorial to learn how to unblock pop-ups.

Generating Yearly Summary Report

6. Interpreting Results

The report table reports the daily average of the selected measurement for each day of each month of the selected year. The summary table at the bottom reports the mean, maximum daily average and minimum daily average for each month. The peak 5 minute value for each month is also reported. This is indicated in the table by a ‘PK’ beside a daily average value in each month. The ‘PK’ indicates that the peak 5 minute value occurred on this day. In the example below we can see that January 14^th has a daily average of 1.1 with ‘PK’ next to it indicating that the peak 5 minute value of 1.7 occurred during this day. If a plus sign is present next to the peak 5 minute value, this indicates that the 5 minute peak value occurred more then once on that day. In the example below we can see that in June the peak 5 minute value of 1.3 occurred more then once on June 9^th.

Summary Report Table

7. Printing Report Table

The report table can be printed like any other page in Internet Explorer.

Printing Yearly Summary Report

The report can also be extracted to Excel by selecting the cell with year and dragging your cursor to the opposite corner of the table. Copy by using Ctrl+C or ‘Page- Copy’.

Exporting Data to Excel

Open Excel and paste the table in using Ctrl+V or ‘Edit- Paste’. The table will be pasted in to Excel for further data manipulation.

Yearly Summary Data in Excel