The quickest way is software that writes the Word file for you: BioSonic exports a Word report with editable text and tables, plus maps and activity graphs as images. With any other auto ID program, export the results as CSV, make a pivot table in Excel of passes by night and species, include nights with zero bats, then chart it and paste the chart into Word.

We make BioSonic. The method on this page works with any bat analysis software.

Option 1: export the report from BioSonic

  1. Finish reviewing the identifications.
  2. Open the report and choose the survey nights, detectors and species to include.
  3. Press Download Word, then edit the text and tables in Word.

The charts in the file are images. If you need a chart that can be edited in Office, export the data from Graphs to Excel and draw it there.

Option 2: Excel, from any software

  1. Export the validated results with detector, date, time and species.
  2. Add a survey night column: the date and time minus 12 hours. Records after midnight then stay with the night they belong to.
  3. Make a pivot table with survey night as rows, species as columns and the number of records as values.
  4. Add the nights when the detector worked and recorded no bats. Leave out nights when it failed, and say so.
  5. Draw a stacked column chart, copy it and paste it into Word, linked if you expect the numbers to change.

What a reader needs under each graph

Common question

Can I report raw auto ID counts in a graph?

BCT says auto ID output is unlikely to be suitable for reporting directly. Validate and verify first, then say in the caption which records the graph shows.

Sources

Related: The BioSonic product · Cut the time spent checking calls · What BCT says about auto ID