Your data contribution is what makes GRP a growing resource for restoration ecologists. In order to facilitate rapid processing and database updates, we are trialing a streamlined process where contributors format their data in a standardized structure for submission. This page is a resource to help you send your data in in the smoothest way possible, and prevent misunderstandings or lots of questions in the process. Each step below describes the key components for data contribution.
There are two downloadable files: the first is a PDF document that provides a legend for each of the worksheets. All columns are explained in detail. Please look at the legend in detail as you work through each sheet.
The second downloadable file is the Excel workbook that should be filled out for your data submission. Each step below is represented in that workbook as one or more individual worksheets. Please go sheet by sheet and fill in all relevant data.
Fill the data contribution workbook out using the instructions below, in the legend and the spreadsheets, and send it to us via email once the sheets are filled in. If this work is published, either in a scientific journal or other type of report, please include any relevant files to us in the Data Submission step at the bottom of the page.
If you have reference data (intact vegetation monitoring data, or degraded untreated vegetation monitoring data), please include that data and treat it as a treatment in the data. Thus, it will be included in the same single data contribution workbook.
If processing data in this way is a significant barrier to your involvement, please contact the project leadership team at email@example.com and discuss alternatives. Also please reach out at anytime with feedback or questions on this process.
GRP Data Contribution Legend
This is the Excel file required for data contribution. Please download it and fill out all relevant sections. Please do NOT alter column headers (with one exception in “Monitoring results_opt2”). Please do NOT skip worksheets unless the instructions below explicitly say they are optional.
GRP Data Contribution File
This is the PDF document providing a detailed legend for each worksheet in the data contribution workbook.
Step 1: Site details
This worksheet outlines the overarching site details, with each site as a single row in the data sheet.
Step 2: Treatment details
This worksheet outlines restoration treatments implemented, with each treatment as a single row in the data sheet.
Step 3: Species details
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.
Step 4: Monitoring details
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.
Step 5: Monitoring results
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 (abundance; total cover; total density; total biomass) or individual-based metrics (eg. biomass per species). For individual -based metrics ‘Option 1- Long format data’ is probably, your best bet. But of course, if you have any questions about this, contact project organizers to discuss!
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:
|Treatment name||Block||Plot||Timepoint||Species code||Value|
Option 2: Wide format
Wide format is when species are included as columns. Final data looks similar to:
Step 6: Your Details & Submit Data!
Enter all your personal and Project details in the ‘Your Details’ sheet.
If you are concerned about your submission once it has been sent, or have any questions at any time, please email firstname.lastname@example.org and we will respond as quickly as possible.
This is also a TRIAL process and we are looking for feedback on how we can make this easier on everyone! There is a spot in the sheet for feedback, but you might want to include it when you send in the data in your email instead. Up to you!
Last step; send the completed data sheet in with a .pdf of the associated paper and/or report to us at email@example.com !