The Abundance Report under Larval Reporting allows you to create a range of reports, including graphs and the ability to download subsets of data into excel.
The Abundance Report allows users to filter data by choosing the desired Local government Areas (LGAs) or Transects, date ranges and trap locations. This is a step by step process and is described below.
To get started, select the “Report” menu, scroll down to the Larval Reporting sub-heading and click Abundance Report (please note there are two Abundance Report headings – ensure you select the one under the Larval Reporting sub-heading).
The Reports Menu with the Larval Reporting Abundance Report highlighted
You will be taken to the first of a series of fields that allow you to narrow down the subset of data you may be interested in. The first field includes all the Local Government Areas that you have access to. Multiple LGA’s can be selected by holding down the SHIFT key and selecting the first and last LGA if they are in consecutive order. Alternatively, you can hold the Ctrl key to select multiple LGA’s that are not in consecutive order. In this instance, Ballarat, Horsham and Moira have been selected, so only data from these three Local Governments will be presented in the report.
Please note: Only Local Governments within Contiguous Local Authority Groups (CLAG’s) are able to select multiple LGA’s from within the list. If you are not part of a CLAG, the only option in this list will be your current LGA.
Selecting the Local Government Areas to generate a report
In most cases, this list will only include the LGA you currently work within. Once you have chosen your Local Government Area/s, click on the blue “Select” button to confirm your selection and move to the next field.
Select the Start and End dates you wish to be included in your report by typing it in DD/MM/YYYY format or clicking the calendar icon and finding your dates.
The LGAs that will be included in the report are listed above the date boxes.
The Start and End dates to generate the report
All sites that have larval records within the selected LGAs and date range are displayed in the “Site” list. Please note the Start and End date displayed may differ slightly to the date range you requested as they will be indicative of the range in which mosquito larvae were recorded.
Choose the sites you wish to be included in the report. Once again, multiple sites can be selected by holding down the SHIFT key or Ctrl key.
Select the sites containing larvae records you wish to be included in the report
You can also adjust the scale of the chart:
There are three options to choose from:
- Chart Site Abundance: Generates an interactive chart of average abundance of larvae by site
- Instar Chart Site Abundance: Generates
- Abundance Map
Chart Site Abundance
Clicking on the Chart Site Abundance button will generate an interactive chart of average abundance of larvae by site.
You can toggle sites on and off using the check boxes below the chart.
Example of a custom chart showing abundance of larvae by site, with sites that can be toggled.
Instar Chart Site Abundance
Clicking on the Instar Chart Site Abundance button will generate an interactive chart of Average Abundance of Larvae by Site and Instar Stage. If a treatment was performed on a site it will be indicated with a red line.
You can toggle treatments and dry sites on and off using the check boxes below the chart. If you chose multiple sites for the report you can also select an individual site to chart by using the drop-down menu above the chart.
Example of a custom chart showing average abundance of larvae by site and instar stage, with sites and treatments that can be toggled.
Clicking on the Abundance Map button will generate points over a map which indicate the abundance of larvae recorded at each of your selected sites. There are three symbols representing larvae numbers – <200, 200-1000, and >1000.
Exporting Data and Images
To the top right of the graph are two functions available to the user to save their reports:
- Saves the current graph as a .png file. The graph cannot be edited from this image, but you can produce multiple images from your report in the web form using the toggles.
- Allows you to save the current data set behind the figure based on each field site within an Excel spreadsheet. Each site will be loaded into a separate sheet within an Excel workbook and each site can be examined in detail by clicking on each sheet at the bottom of the Excel table. This data can be saved and edited as per any normal excel spreadsheet.
An example of the data produced in Excel when you click the “Download Site XLSX” link