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:

Select

 

Click this option to open a form with which you can select the types of reports you wish to generate.  You must then also select at least one report from an Annual or Roll-Up view before clicking on the Create Reports toolbar button.

Create

Use this option to generate the reports you have selected.

Finished Reports

This option opens a file exploring window that shows you where your finished reports are stored.

Cancel

Click this option to abort the report generation process.

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:

Graphs

Graphical representation of the run results for the scenario, year and species/performance measure selected for reporting; shows the distribution of good, fair and poor performance for the year(s) plotted.

Metadata

Details about the model run that forms the basis for the report that has been generated, including scenario information and assumptions.

Data

 

Tabular representation of the run results for the scenario, year and species/performance measure selected for reporting; shows the distribution of good, fair and poor performance for the year(s) plotted.

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:

Window menu

Arranges multiple spatial reports in the reporting window.  The options are: Cascade (as in the image above), Tile Vertically, and Tile Horizontally.   You can also use the re-sizing icons in the upper right corner of each report to enlarge/restore individual reports within the report window.

Select

This option is on by default when a spatial report opens.  Select allows you to click on a data point, line, polygon, or pie chart to open a pop-up window of additional information.  Click anywhere else on the map to close the pop-up.

Pop-up Details

Click on a data point, line, polygon, or pie chart to view details about the data for that location.  From the drop-down list at the top of the pop-up, select the kind of detail you want to view.  All pop-ups contain a location name, and show the values used to create the data on the map (PM Summary).  For some indicators, additional information is also available, e.g., charts showing changes in various parameters over time such as salinity, temperature, weight gain in fish, passage time, thermal stress, etc.


 

Pan

Use this tool to move the map around within the report window, e.g., you may need to move a data point downward in order to see the associated pop-up window in its entirety.

Zoom In

To zoom in on a specific area of the map, click on the Zoom In tool and then left-click to draw a box around the area you want to enlarge.  You can also zoom in with small increments by rolling the wheel forward on your mouse.  Re-position the map as needed using the Pan tool.

Zoom Out

To zoom out, click on the Zoom Out tool and then left-click on the map.  Alternatively, you can zoom out by rolling the wheel on your mouse backwards. Re-position the map as needed using the Pan tool.

Spatial reports cannot be saved.

Diagnostic Reports

The EFT can generate four different non-spatial diagnostic reports, and one spatial time series animation report.  Diagnostic reports are annual, i.e., one report for each year selected in an Annual view, and include reports for flow, water temperature, wetland inundation regime, and salinity.  Non-spatial salinity results are expressed as X2, where X2 is defined as the location, in number of kilometers from the Golden Gate Bridge, at which bottom salinity measures 2 ppt.  Non-spatial diagnostic reports are generated in MS Excel, and are saved by the EFT at a location specified by the user on the Reports tab in Preferences (Edit menu).

The spatial diagnostic report is a time series animation of the X2 data.  Click on the Play button () in the lower right corner to start the animation.  

The data point for X2 will move up and down the river as the days of the water year (shown in the lower left corner of the report) advance.  You can adjust the speed of the animation using the Animation Speed sliding scale on the Spatial Reports tab in Preferences (Edit menu).  

You can Pause the animation () at any time, and "rewind" by moving the marker on the progress bar.

As with the annual and multi-year roll-up spatial reports, you can arrange multiple reports in the report window (Window menu), and you can adjust your view with the Pan and Zoom tools.

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.  

Comments