{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Metadata example","Metadata customer"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Metadata example","index":0,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[18,1,18,8],[21,1,21,8],[22,1,22,8],[23,1,23,8],[20,1,20,8],[19,1,19,8]]}
[]
[]
[]
[]
[null,"Metadata table:"]
[null,"SampleID","Treatment","Time","Treatment_Time"]
[null,"sample1-a","control","T1","control_T1"]
[null,"sample1-b","control","T1","control_T1"]
[null,"sample1-c","control","T1","control_T1"]
[null,"sample2-a","A","T2","A_T2"]
[null,"sample2-b","A","T2","A_T2"]
[null,"sample2-c","A","T2","A_T2"]
[null,"sample3-a","B","T3","B_T3"]
[null,"sample3-b","B","T3","B_T3"]
[null,"sample3-c","B","T3","B_T3"]
[]
[]
[null,"Guidelines:"]
[null,"Every column after the first one represents a variable (here: grouping of samples into categories) and is analyzed independently from any other non-SampleID columns."]
[null,"If variables need to be compared dependently from each other, a column that specifies the intended aggregation must be added (see \"Treatment_Time\" column)."]
[null,"The cells of the metadata table must contain categorical values (e.g. \"control\" or \"active\") and may not be numerical only."]
[null,"Only alpha-numerical characters (a-z and 0-9) and the \"_\" character are allowed. SampleIDs may also contain the \"-\" character."]
[null,"Empty cells are not allowed. The experiment must to be fully qualified. \"NA\" for \"not available\" will be treated as just another category and has no special meaning."]
[null,"Each subproject that encloses a certain number of samples that need to be analyzed separately from the other samples, needs also a separate metadata table."]
[]
[]
[null,"For each of the variables in the metadata table above, all possible combinations between the values will be analyzed. Variable \"Treatment\" is shown as an example below."]
[]
[null,null,"control","A","B"]
[null,"control"]
[null,"A","x"]
[null,"B","x","x"]
[]
[]
[null,"Important remarks:"]
[null,"A standard project consists of only one metadata table containing all samples of the project. No division into separate subprojects is allowed."]
[null,"If your project cannot be described in a single table and you would like to expand on a standard project, please get in touch with your sales representative."]
[]
[]
[null,"Microsynth AG"]
[null,"Schützenstrasse 15 · CH-9436 Balgach · Phone +41 71 722 83 33 · info@microsynth.ch · www.microsynth.com"]

{"sheet":"Metadata customer","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Please fill in a table with your samples and variables defining your experimental setup as described before on the sheet \"Metadata example\"."]