{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["TOOL","INSTRUCTIONS","VERSION_HISTORY"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"TOOL","index":0,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,2,0,7],[1,2,1,7],[44,16,51,16],[14,16,21,16],[4,16,11,16],[24,16,31,16],[34,16,41,16]]}
[null,"version 2.6"]
[null,"File Name"]
[null,"Sample_ID","Tumor_Type","Description","Sample_Well","I7_Index_ID","I5_Index_ID","Control"]
["A1",null,"select","BATCH_1","A01","A701","A501",null,{"$f":"F4&\"|\"&G4","v":"A701|A501"},"",1,2,3,4,5,6]
["B1",null,"select","BATCH_1","B01","A701","A502",null,{"$f":"F5&\"|\"&G5","v":"A701|A502"},"A",{"$f":"IF($B4=\"\",\"-\",$B4)","v":"-"},{"$f":"IF($B12=\"\",\"-\",$B12)","v":"-"},{"$f":"IF($B20=\"\",\"-\",$B20)","v":"-"},{"$f":"IF($B28=\"\",\"-\",$B28)","v":"-"},{"$f":"IF($B36=\"\",\"-\",$B36)","v":"-"},{"$f":"IF($B44=\"\",\"-\",$B44)","v":"-"},"SAMPLE ID"]
["C1",null,"select","BATCH_1","C01","A701","A503",null,"A701|A503","B","-","-","-","-","-","-"]
["D1",null,"select","BATCH_1","D01","A701","A504",null,"A701|A504","C","-","-","-","-","-","-"]
["E1",null,"select","BATCH_1","E01","A701","A505",null,"A701|A505","D","-","-","-","-","-","-"]
["F1",null,"select","BATCH_1","F01","A701","A506",null,"A701|A506","E","-","-","-","-","-","-"]
["G1",null,"select","BATCH_1","G01","A701","A507",null,"A701|A507","F","-","-","-","-","-","-"]
["H1",null,"select","BATCH_1","H01","A701","A508",null,"A701|A508","G","-","-","-","-","-","-"]
["A2",null,"select","BATCH_1","A02","A702","A501",null,"A702|A501","H","-","-","-","-","-","-"]
["B2",null,"select","BATCH_1","B02","A702","A502",null,"A702|A502"]
["C2",null,"select","BATCH_1","C02","A702","A503",null,"A702|A503","",1,2,3,4,5,6]
["D2",null,"select","BATCH_1","D02","A702","A504",null,"A702|A504","A",{"$f":"IF($B4=\"\",\"-\",$C4)","v":"-"},{"$f":"IF($B12=\"\",\"-\",$C12)","v":"-"},{"$f":"IF($B20=\"\",\"-\",$C20)","v":"-"},{"$f":"IF($B28=\"\",\"-\",$C28)","v":"-"},{"$f":"IF($B36=\"\",\"-\",$C36)","v":"-"},{"$f":"IF($B44=\"\",\"-\",$C44)","v":"-"},"TUMOR TYPE"]
["E2",null,"select","BATCH_1","E02","A702","A505",null,"A702|A505","B",{"$f":"IF($B5=\"\",\"-\",$C5)","v":"-"},{"$f":"IF($B13=\"\",\"-\",$C13)","v":"-"},{"$f":"IF($B21=\"\",\"-\",$C21)","v":"-"},{"$f":"IF($B29=\"\",\"-\",$C29)","v":"-"},{"$f":"IF($B37=\"\",\"-\",$C37)","v":"-"},{"$f":"IF($B45=\"\",\"-\",$C45)","v":"-"}]
["F2",null,"select","BATCH_1","F02","A702","A506",null,"A702|A506","C","-","-","-","-","-","-"]
["G2",null,"select","BATCH_1","G02","A702","A507",null,"A702|A507","D","-","-","-","-","-","-"]
["H2",null,"select","BATCH_1","H02","A702","A508",null,"A702|A508","E","-","-","-","-","-","-"]
["A3",null,"select","BATCH_1","A03","A703","A501",null,"A703|A501","F","-","-","-","-","-","-"]
["B3",null,"select","BATCH_1","B03","A703","A502",null,"A703|A502","G","-","-","-","-","-","-"]
["C3",null,"select","BATCH_1","C03","A703","A503",null,"A703|A503","H","-","-","-","-","-","-"]
["D3",null,"select","BATCH_1","D03","A703","A504",null,"A703|A504"]
["E3",null,"select","BATCH_1","E03","A703","A505",null,"A703|A505","",1,2,3,4,5,6]
["F3",null,"select","BATCH_1","F03","A703","A506",null,"A703|A506","A",{"$f":"IF($B4=\"\",\"-\",IF($D4=\"\",\"\",$D4))","v":"-"},{"$f":"IF($B12=\"\",\"-\",IF($D12=\"\",\"\",$D12))","v":"-"},{"$f":"IF($B20=\"\",\"-\",IF($D20=\"\",\"\",$D20))","v":"-"},{"$f":"IF($B28=\"\",\"-\",IF($D28=\"\",\"\",$D28))","v":"-"},{"$f":"IF($B36=\"\",\"-\",IF($D36=\"\",\"\",$D36))","v":"-"},{"$f":"IF($B44=\"\",\"-\",IF($D44=\"\",\"\",$D44))","v":"-"},"SAMPLE BATCH"]
["G3",null,"select","BATCH_1","G03","A703","A507",null,"A703|A507","B","-","-","-","-","-","-"]
["H3",null,"select","BATCH_1","H03","A703","A508",null,"A703|A508","C","-","-","-","-","-","-"]
["A4",null,"select","BATCH_1","A04","A704","A501",null,"A704|A501","D","-","-","-","-","-","-"]
["B4",null,"select","BATCH_1","B04","A704","A502",null,"A704|A502","E","-","-","-","-","-","-"]
["C4",null,"select","BATCH_1","C04","A704","A503",null,"A704|A503","F","-","-","-","-","-","-"]
["D4",null,"select","BATCH_1","D04","A704","A504",null,"A704|A504","G","-","-","-","-","-","-"]
["E4",null,"select","BATCH_1","E04","A704","A505",null,"A704|A505","H","-","-","-","-","-","-"]
["F4",null,"select","BATCH_1","F04","A704","A506",null,"A704|A506"]
["G4",null,"select","BATCH_1","G04","A704","A507",null,"A704|A507","",1,2,3,4,5,6]
["H4",null,"select","BATCH_1","H04","A704","A508",null,"A704|A508","A",{"$f":"IF($B4=\"\",\"-\",IF($F4=\"\",\"\",IF($G4=\"\",\"\",$F4&\"|\"&$G4)))","v":"-"},{"$f":"IF($B12=\"\",\"-\",IF($F12=\"\",\"\",IF($G12=\"\",\"\",$F12&\"|\"&$G12)))","v":"-"},{"$f":"IF($B20=\"\",\"-\",IF($F20=\"\",\"\",IF($G20=\"\",\"\",$F20&\"|\"&$G20)))","v":"-"},{"$f":"IF($B28=\"\",\"-\",IF($F28=\"\",\"\",IF($G28=\"\",\"\",$F28&\"|\"&$G28)))","v":"-"},{"$f":"IF($B36=\"\",\"-\",IF($F36=\"\",\"\",IF($G36=\"\",\"\",$F36&\"|\"&$G36)))","v":"-"},{"$f":"IF($B44=\"\",\"-\",IF($F44=\"\",\"\",IF($G44=\"\",\"\",$F44&\"|\"&$G44)))","v":"-"},"INDEX PAIR"]
["A5",null,"select","BATCH_1","A05","A705","A501",null,"A705|A501","B","-","-","-","-","-","-"]
["B5",null,"select","BATCH_1","B05","A705","A502",null,"A705|A502","C","-","-","-","-","-","-"]
["C5",null,"select","BATCH_1","C05","A705","A503",null,"A705|A503","D","-","-","-","-","-","-"]
["D5",null,"select","BATCH_1","D05","A705","A504",null,"A705|A504","E","-","-","-","-","-","-"]
["E5",null,"select","BATCH_1","E05","A705","A505",null,"A705|A505","F","-","-","-","-","-","-"]
["F5",null,"select","BATCH_1","F05","A705","A506",null,"A705|A506","G","-","-","-","-","-","-"]
["G5",null,"select","BATCH_1","G05","A705","A507",null,"A705|A507","H","-","-","-","-","-","-"]
["H5",null,"select","BATCH_1","H05","A705","A508",null,"A705|A508"]
["A6",null,"select","BATCH_1","A06","A706","A501",null,"A706|A501","",1,2,3,4,5,6]
["B6",null,"select","BATCH_1","B06","A706","A502",null,"A706|A502","A",{"$f":"IF($B4=\"\",\"-\",IF($H4=\"\",\"S\",$H4))","v":"-"},{"$f":"IF($B12=\"\",\"-\",IF($H12=\"\",\"S\",$H12))","v":"-"},{"$f":"IF($B20=\"\",\"-\",IF($H20=\"\",\"S\",$H20))","v":"-"},{"$f":"IF($B28=\"\",\"-\",IF($H28=\"\",\"S\",$H28))","v":"-"},{"$f":"IF($B36=\"\",\"-\",IF($H36=\"\",\"S\",$H36))","v":"-"},{"$f":"IF($B44=\"\",\"-\",IF($H44=\"\",\"S\",$H44))","v":"-"},"CONTRO TYPE"]
["C6",null,"select","BATCH_1","C06","A706","A503",null,"A706|A503","B","-","-","-","-","-","-"]
["D6",null,"select","BATCH_1","D06","A706","A504",null,"A706|A504","C","-","-","-","-","-","-"]
["E6",null,"select","BATCH_1","E06","A706","A505",null,"A706|A505","D","-","-","-","-","-","-"]
["F6",null,"select","BATCH_1","F06","A706","A506",null,"A706|A506","E","-","-","-","-","-","-"]
["G6",null,"select","BATCH_1","G06","A706","A507",null,"A706|A507","F","-","-","-","-","-","-"]
["H6",null,"select","BATCH_1","H06","A706","A508",null,"A706|A508","G","-","-","-","-","-","-"]
[null,null,null,null,null,null,null,null,null,"H","-","-","-","-","-","-"]

{"sheet":"INSTRUCTIONS","index":1,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"General Information about Excel VBA Macros"]
[1,null,"This tool is powered by Microsoft Visual Basic for Applications (VBA) and requires VBA macros to be enabled to function properly.  You can test whether VBA macros are enabled by clicking on the Pillar logo above."]
[2,null,"If VBA macros are not enabled, click the \"File\" menu in the Excel menu bar and select \"Options\".  In the \"Options\" menu, select \"Trust Center\" and then click the \"Trust Center Settings\" button.  In the \"Trust Center\", select the \"Macro Settings\" menu.  From the \"Macro Settings\" menu, chose \"Disable all macros with notification\".  This will give you a prompt to allow VBA macros to run each time one is detected."]
[3,null,"Or, also in the \"Trust Center\", one can select the \"Trusted Locations\" menu and add the location where this tool is stored.  This will allow the macro code to run without prompts."]
[null,null,"About This Tool"]
[4,null,"The Pillar Sample Sheet Tool is designed to be a user-friendly interface that creates a properly formatted CSV output file for import into the Pillar Module of an appropriately equipped MiSeqDx sequencer"]
[5,null,"The Pillar Sample Sheet Tool is designed to help \"batching\" of up to six independently prepared batches of sample libraries onto a single MiSeq v3 chip"]
[6,null,"The Pillar Sample Sheet Tool allows visualization of various aspects of the plate layout such as sample ID, batches, index use, and position of controls"]
[7,null,"  n The Tool will prevent the use of overlapping index pairs, avoiding issues during sequencing"]
[8,null,"  n The Tool will prevent sequencing of batches lacking PosCtrl and NTC controls"]
[null,null,"Using This Tool"]
[9,null,"The following data columns must contain entries for the Tool to create a sample sheet for import into the Pillar Module of a MiSeqDx sequencer"]
[10,null,"  n FILE NAME [optional-free text] - supply a name for the output file that describes the analysis - \n            NEVER USE ANY PATIENT IDENTIFIER INFORMATION TO NAME FILES"]
[11,null,"  n SAMPLE_ID [free text] - supply a name for the sample that describes that sample - \n            NEVER USE ANY PATIENT IDENTIFIER INFORMATION TO DESIGNATE SAMPLES"]
[12,null,"  n TUMOR_TYPE [drop down] - select sample type from allowed values: CRC for colorectal cancer \n             samples, and NSCLC for non-small cell lung cancer samples; if controls are selected in the \n             CONTROL column (PosCtrl or NTC) then a value of Control will be present"]
[13,null,"  n DESCRIPTION [drop down] - allows selection from up to 6 pre-configured Batches"]
[14,null,"  n I7_INDEX_ID [drop down] - allows selection from up to 6 pre-configured A70x indices"]
[15,null,"  n I5_INDEX_ID [drop down] - allows selection from up to 8 pre-configured A50x indices"]
[16,null,"  n CONTROL [drop down] - default blank value indicates that the sample is not a control; allows \n            selection of NTC and PosCtrl control samples"]
[17,null,"After all of the required information has been entered, the CSV output file will be created automatically and saved to your Desktop"]
[18,null,"If there is missing content or there are logical inconsistencies, the Tool will automatically give instructions regarding required actions"]
[19,null,"NOTE: Only content in rows where Sample_ID information is provided will be transferred to output"]
[20,null,"Move the CSV output from your Desktop to a location where the Pillar Module of the MiSeqDX sequencer can access it"]
[21,null,"From the Pillar Module of the MiSeqDX, import the CSV file into the Local Run Manager (LRM) of Pillar Module using the \"Create Run\" feature"]
[22,null,"You should see the layout of the samples in the LRM with sample names and control designations (o = NTC and + = PosCtrl"]
[23,null,"In the LRM, click \"Save\" to proceed with sequencing"]
[]
[]
[19]
[20]

{"sheet":"VERSION_HISTORY","index":2,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
["Version","Date","Notes"]
["0.0","2018-12-19","n Initial release candidate"]
["0.1","2019-01-07","n Added check to ensure that each batch has both NTC and PosCtrl assigned to it"]
["0.2","2019-02-19","n Added instructions page"]
["0.3","2019-04-30","n  Added check to ensure absence of forbidden characters from sample names"]
["1.0","2019-05-10","n  First released version"]
["2.0","2020-11-23","n  Added feature to collect and transmit tumor type information for sample libraries"]
["2.1","2021-02-03","n  Added GUID stamp to description field"]
["2.2","2021-02-04","n  Release candidate version"]
["2.3","2021-02-11","n  Corrected order of items in the output SampleSheet.csv Description field; corrected typo on Instructions sheet."]
["2.4","2021-02-26","n  Corrected  validation formula in Cell(4,3) of TOOL sheet. Added code to disallow deletion of worksheets from the tool."]
["2.5","2021-03-03","n  Corrected a bug that allows creation of a SampleSheet.csv upload template without tumor type information being present for all samples."]
["2.6"]
["2.7"]
["2.8"]
["2.9"]
["2.6","2021-03-05","n  Added code to create a different tumor type drop-down values for users inside and outside of Pillar network.  Internal users will have available additional tumor types in addition to CRC and NSCLC, the option for \"Reference\", external users will not. In addition to the LRM upload template produced for external users, the tool will also generate a traditional SampleSheet.csv output exclusively for internal users."]