Allan Morrison talks about how to log abiotic and biotic data on biodiversity assessments using the Excel spreadsheets. Graphs are automatically generated.(3:43 mins)
Download the Data Logging Using Spreadsheets transcript. (PDF, 47 KB)
Data Collation User Manual (PDF, 1 MB)
This manual guides the user to setup and enter data on the data collation tool spreadsheet. The manual includes screen shots and explanatory notes on how each data sheet is used. There is a troubleshooting guide for each sheet.
Data Collation Sheet (XLS, 1.5 MB)
This data spreadsheet tool can be used to collate data from a collection event. You can enter and record location data, abiotic conditions and population counts of invertebrate orders.
Data Collation Sheet (Sample) (XLS, 1.7 MB)
This data spreadsheet tool can be used to collate data from a collection event. This a sheet with some sample data entered to a give an overview of how it can be used.