Create submission.xlsx

Background

Under this feature, SODA lets you rapidly prepare the submission metadata file for your dataset. This feature is designed to avoid commonly found errors when preparing this file. The expected structure of this file, generated automatically by SODA, is explained in our corresponding "How to" page if you would like to learn about it.

SODA makes use of two resources to help you prepare the submission file rapidly and without errors:

1. The SPARC Airtable sheet as explained here.
2. The Data Deliverables document associated with your award. This document list the milestones and associated datasets as agreed between awardees and SPARC. In the submission metadata file, it is necessary to provide milestone and milestone completion dates associated with your dataset exactly as specified in the Data Deliverables document. This document is usually kept by the PI of the SPARC award or the award manager. Click here to find out more about it.

How to

1. Choose how to start generating your submission.xlsx file:

• Start a new submission.xlsx file

• Continue working on an existing submission.xlsx file

2. Enter your SPARC award number, milestone(s), and completion date for the milestone(s)

3. Choose a milestone from the list compiled from the Data Deliverables document or type it manually. Choose/type "Not specified in the Data Deliverables document" if this dataset isn't associated with any milestone initially planned.

4. Choose/type the date associated with this milestone

5. Review and click on "Generate" to generate your submission file. The generated file will be ready to be included in your dataset.

Note:

• If you need help with your SPARC Award number: click on "Click here to import my SPARC award from Airtable". Connecting your Airtable account with SODA will help SODA retrieve your SPARC award and related contributor information for your convenience at generating the submission and dataset description files.

• If you need help with your milestone information: click on "Click here to import milestones from my Data Deliverables document". Import your Data Deliverable document. SODA will automatically extract milestones and associated information which will be used to help you prepare the submission metadata file. You will have to do this only once and it will be then remembered by SODA during subsequent uses. Note that the information from your Data Deliverables document will be saved locally on your computer so only visible to you.