Files-Specifications.md

@@ -15,3 +15,27 @@ The **modified** schema of the **Table Schema** JSON object can be found [HERE](
 # CDE Dictionary Excel file
 
 # Data Catalogue Excel file
+
+## Necessary Conventions
+
+!NOTE: the name of the uploaded file should be in the following format: "pathology name"_cdes_"version number".xlsx (e.g. demencia_cdes_v1.xlsx).
+!NOTE: all the columns described below should be present in the uploaded file.
+!NOTE: a template with the appropriate file name and columns can be downloaded from the 'XLSX template'. In order to avoid naming inconsistencies we encourage users to use the provided template and fill-in their data.
+
+## DC Excel columns
+
+The spreadsheet **MUST** have the following columns with the same order:
+
+1. csvFile: The name of the dataset file the variable is in.
+2. name: The name of the variable.
+3. code: The variable’s code.
+4. type: The variable’s type.
+5. values: The variable’s values. It may have an enumeration or a range of values. For enumerations, for every value please provide code and label in brackets.
+Example (for ADNI category): {“AD”,”Alzheimer’s Disease”},{”MCI”,”Mild Cognitive Impairment”},{”CN”,”Cognitively Normal”}
+For range of values simply state the min and max values with '-' in between. Example (for MMSE Total scores): 0-30.
+6. unit: The variable’s measurement unit.
+7. canBeNull: Whether the variable is allowed to be null or not: Y/N.
+8. description: The variable’s description.
+9. comments: Comments about the variable’s nature.
+10. conceptPath: The variable’s concept path. Example (for ApoE4): /root/genetic/polymorphism/apoe4.
+11. methodology: The methodology the variable has come from. Example (for rs10498633_T): lren-nmm-volumes. 
\ No newline at end of file