Reports Menu

Overview

Use the Reports menu to select, generate and open reports of model output by species, indicator, and for certain diagnostics (e.g., flows, water temperature).

All of these options can also be accessed using buttons on the EFT Reader toolbar (Select Reports, Create Reports, Finished Reports).

The options under the Reports menu are:

Report Types

The EFT can generate reports by species (e.g., Fall Chinook), by indicator (e.g., Fall Chinook WUA Spawning), and for selected diagnostics (e.g., water temperature). Species and Indicator reports can be based on Annual or multi-year Roll-up views. Diagnostic reports are all annual. Both non-spatial and spatial reports can be generated. However, not every type of report can be generated for every species/indicator. Consult the Select Reports form to see which report types are available for each species, indicator, and diagnostic.

Non-spatial Reports

Non-spatial reports can be created from both Annual and multi-year Roll-up views. These reports are generated in MS Excel. At a minimum, non-spatial EFT reports contain 3 worksheets of information:

Additional tabular data are included on separate worksheets, as appropriate and relevant, for certain indicators, e.g., flow and entrainment data for Smelt entrainment risk. Non-spatial reports are saved by the EFT at a location specified by the user on the Reports tab in Preferences (Edit menu).

Spatial Reports (DeltaEFT only)

Spatial reports can be generated for the Delta EFT eco-region from both Annual and multi-year Roll-up views. For annual spatial reports, the data are shown as colored points (as in the example below), lines, or polygons - depending on the indicator being mapped - for the selected year. For multi-year roll-up spatial reports, data for the full range of years you selected in Show Criteria are represented in pie charts that show the proportion of good, fair, and poor performance years. In all spatial reports, performance is represented by colour, based on the scheme defined on the Viewers tab in Preferences (Edit menu). The colored dot in the upper left corner of each report represents the overall performance rating for the indicator for the year (annual report) or years (roll-up report) specified.

For spatial reports that display point or pie chart data, the size of the point or pie chart indicates the weight (based on sample size) of the data at that location.

You can configure your spatial reports, e.g., change the base map, using the options available on the Spatial Reports tab in Preferences (Edit menu).

The menus and options on the spatial report window are:

The spatial diagnostic report cannot be saved.

Select Reports

Click on the Select option under the Reports menu to open a form that lists the types reports that can be generated based on model output stored in the EFT database. The same form can be opened by clicking on the Select Reports button in the toolbar at the top of the screen. This form can be sized by left-clicking and dragging any corner or side of the form.

The Select Reports form lists all of the report types that are available for each species and indicator, and it lists the diagnostic reports that can be run. The reports are organized on three tabs: By Species, By Indicator and Diagnostic reports. Selecting reports to generate is a two-step process. The recommended practice is to select the types of reports you wish to generate here, and then select specific reports (e.g., certain years in an annual view) on the Annual and/or Roll-Up views. It is possible, however, to select specific reports from the Annual and Roll-Up views without first selecting report types from the Select Reports form (see below).

To specify the types of reports to generate:

1. Open the Select Reports form either by clicking on the toolbar button of the same name, or by choosing Select under the Reports menu.
2. Expand the list of reports for the species or indicator of choice by clicking on the + sign at left.
3. Click in the checkboxes to select individual reports; a right-click menu is available on this form to quickly show you what reports you have already selected, and to clear all current selections.
4. In the example below, all report types for Delta Smelt have been selected.

To select specific Annual reports to generate:

1. Specify the type of report you wish to generate using the Select Reports form (see above).
2. With your output displayed in an Annual view, left-click in the cells that correspond to the years you wish to report for each scenario.

1. Click on the Create Reports toolbar button to see a list of the reports that will be generated by your selections.

1. Click Cancel to close the Reports Preview form and return to the Annual view to edit your choices.

To select specific Roll-Up reports to generate:

1. Specify the type of report you wish to generate using the Select Reports form (see above).
2. With your output displayed in a Roll-Up view, left-click in the checkboxes that correspond to the roll-up reports you wish to generate for each scenario.

1. Click on the Create Reports toolbar button to see a list of the reports that will be generated by your selections. Note that the list below reflects choices for both annual and roll-up reports.

1. At this point in the process, you can click on Continue to generate the selected reports (see the Create Reports topic for details), or Cancel to close the Reports Preview form and return to the Roll-Up view to edit your choices if necessary.

You can also select reports directly from an Annual or Roll-up view, without first specifying which reports you wish to generate on the Select Reports form.

To select reports directly from an Annual view:

1. With an Annual view open, left-click to select a year for one of the indicators in your view, e.g., 1980 for DS1 (as in the Annual view image below).
2. If you have no reports already selected on the main Select Reports list, a small Select Reports form will open that shows you the types of reports that you can generate for the indicator and view you have selected (e.g., a non-spatial annual report and a spatial annual report for DS1).
3. Click in the checkboxes to select the report type, and click OK; this selection will now be reflected on the main Select Reports list.

1. Select additional years to report for the same indicator, and/or select a year for another indicator in your Annual view (e.g., DS4). If you select a year for another indicator, the small Select Reports form will open again, and you will need to indicate which of the available report types you wish to generate for the indicator.
2. When you have finished selecting reports on the Annual view, click on Create Reports to proceed through the report generation process (see Create Reports topic).

To select reports directly from a Roll-up view:

1. With a Roll-up view open, click in the Create Report check-box for the indicator you want to report on.
2. If you have no reports already selected on the main Select Reports list, a small Select Reports form will open that shows you the types of reports that you can generate for the indicator and view you have selected (e.g., a non-spatial multi-year roll-up report and a spatial multi-year roll-up report).
3. Click in the checkboxes to select the report type, and click OK; this selection will now be reflected on the main Select Reports list.
4. Repeat this process for each indicator you want to report on.
5. When you have finished selecting reports on the Roll-up view, click on Create Reports to proceed through the report generation process (see Create Reports topic, below).

Create Reports

Click on the Create option under the Reports menu, or on the Create Reports toolbar button, to generate reports of model output based on your selections.

Note: You must select at least one Annual or Roll-Up report before clicking on Create Reports.

To create reports:

1. With your report selections in place, click on Create under the Reports menu (or click on the Create Reports toolbar button).
2. A Reports Preview form will open that lists all of the reports that will be generated based on your selections; the maximum number of reports you can generate is user-defined on the Preferences form (Edit menu). the default number of reports is 10; the maximum capacity is 50.
3. On the Reports Preview form you can uncheck selected reports as needed, or you can Cancel to close the form and edit your report selections.
4. When you are ready to generate your reports, click on the Continue button at the bottom of the Reports Preview form; a warning message will display if the number of reports you checked is greater than the limit you set on the Preferences form.

A report generation status bar will display in the bottom left corner of your screen; you can continue working with the EFT Reader while reports are being generated.

When the report generation process is completed, a separate instance of Excel will open for each non-spatial report, and spatial reports will open in a separate window on your screen.

Finished Reports

Choose Finished Reports from the Reports menu, or click on the toolbar button of the same name, to see where the EFT Reader stores finished non-spatial reports on your computer. A list of the reports you have generated will display in the Reports form, including information about file size and date modified. You can open or delete any of these files, and perform other standard operations with them, e.g., convert to PDF, or zip and email to a colleague.