We describe the tabs that you will find in the GAZP contribution data sheet in more detail below. Please use these steps to help format your data.
The 'Site Details' tab will contain all of the information about your site. Each site should be a single row in the datasheet.
The 'Treatment Details' tab outlines the restoration treatment details. Each treatment should be a single row in the datasheet.
This step details all species added or found in the project. There are three worksheets within the workbook for this step: “Seeded species”; “Planted species”; and “Full species list”. Only the third is required for submission. If species were added in any form, the first and/or second sheets are also required.
The first details seeded species, including all information about seedmix design. The second sheet details similar information but for any species that were planted. The third sheet details all species found in the contributed data.
This step details key monitoring components and has two worksheets. Both worksheets are required for submission.
The first worksheet, “Monitoring details”, captures monitoring methods relevant to how we scale and process the contributed data.
The second worksheet, “Time point details”, captures monitoring times, split by treatment if the monitoring occurred at different time points by treatment or site. There are columns for day, month, and year. If day and/or month is unknown, please leave it blank.
This step is represented by two worksheets, only one of which is required depending on your original data format. This data includes the vegetation outcomes captured in the monitoring. There are two potential options, “long” and “wide” format (
“Monitoring results_opt1” and
“Monitoring results_opt2”, respectively).
Please note that this is designed for species-level measurements (total cover; total density). If you have individual-based measurements, please
contact the organizers to finalize this stage of the submission process.
In each worksheet, there are two columns for spatial replicates (to capture, for example: block and plot within block). If there are more spatial levels (for example: block, transect within block, and plot within transect within block), please add columns as needed.
Option 1 - Long Format:
Long format is when species are all included within one column. Final data looks similar to: