{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Long Skinny to Import","Instructions","Molecule or Synonym","Batch","External ID","Well ID","Conc","Raw Data"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Long Skinny to Import","index":0,"n_rows":193,"n_cols":10,"rows_kept":193}
["Molecule","Batch","External ID","Plate Name","Well ID","Concentration","Raw Data"]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!B2),\"\",'Molecule or Synonym'!B2)","v":""},{"$f":"IF(ISBLANK(Batch!B2),\"\",Batch!B2)","v":""},{"$f":"IF(ISBLANK('External ID'!B2),\"\",'External ID'!B2)","v":""},{"$f":"$J$2","v":"Plate 1"},{"$f":"'Well ID'!B2","v":"A1"},{"$f":"IF(ISBLANK(Conc!B2),\"\",Conc!B2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!B2),\"\",'Raw Data'!B2)","v":""},null,"Unique Plate Name:","Plate 1"]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!B3),\"\",'Molecule or Synonym'!B3)","v":""},{"$f":"IF(ISBLANK(Batch!B3),\"\",Batch!B3)","v":""},{"$f":"IF(ISBLANK('External ID'!B3),\"\",'External ID'!B3)","v":""},{"$f":"$J$2","v":"Plate 1"},{"$f":"'Well ID'!B3","v":"B1"},{"$f":"IF(ISBLANK(Conc!B3),\"\",Conc!B3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!B3),\"\",'Raw Data'!B3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!B4),\"\",'Molecule or Synonym'!B4)","v":""},{"$f":"IF(ISBLANK(Batch!B4),\"\",Batch!B4)","v":""},{"$f":"IF(ISBLANK('External ID'!B4),\"\",'External ID'!B4)","v":""},"Plate 1",{"$f":"'Well ID'!B4","v":"C1"},{"$f":"IF(ISBLANK(Conc!B4),\"\",Conc!B4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!B4),\"\",'Raw Data'!B4)","v":""},null,"a unique identifier for plate entered in cell J2"]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!B5),\"\",'Molecule or Synonym'!B5)","v":""},{"$f":"IF(ISBLANK(Batch!B5),\"\",Batch!B5)","v":""},{"$f":"IF(ISBLANK('External ID'!B5),\"\",'External ID'!B5)","v":""},"Plate 1",{"$f":"'Well ID'!B5","v":"D1"},{"$f":"IF(ISBLANK(Conc!B5),\"\",Conc!B5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!B5),\"\",'Raw Data'!B5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!B6),\"\",'Molecule or Synonym'!B6)","v":""},{"$f":"IF(ISBLANK(Batch!B6),\"\",Batch!B6)","v":""},{"$f":"IF(ISBLANK('External ID'!B6),\"\",'External ID'!B6)","v":""},"Plate 1",{"$f":"'Well ID'!B6","v":"E1"},{"$f":"IF(ISBLANK(Conc!B6),\"\",Conc!B6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!B6),\"\",'Raw Data'!B6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!B7),\"\",'Molecule or Synonym'!B7)","v":""},{"$f":"IF(ISBLANK(Batch!B7),\"\",Batch!B7)","v":""},{"$f":"IF(ISBLANK('External ID'!B7),\"\",'External ID'!B7)","v":""},"Plate 1",{"$f":"'Well ID'!B7","v":"F1"},{"$f":"IF(ISBLANK(Conc!B7),\"\",Conc!B7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!B7),\"\",'Raw Data'!B7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!B8),\"\",'Molecule or Synonym'!B8)","v":""},{"$f":"IF(ISBLANK(Batch!B8),\"\",Batch!B8)","v":""},{"$f":"IF(ISBLANK('External ID'!B8),\"\",'External ID'!B8)","v":""},"Plate 1",{"$f":"'Well ID'!B8","v":"G1"},{"$f":"IF(ISBLANK(Conc!B8),\"\",Conc!B8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!B8),\"\",'Raw Data'!B8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!B9),\"\",'Molecule or Synonym'!B9)","v":""},{"$f":"IF(ISBLANK(Batch!B9),\"\",Batch!B9)","v":""},{"$f":"IF(ISBLANK('External ID'!B9),\"\",'External ID'!B9)","v":""},"Plate 1",{"$f":"'Well ID'!B9","v":"H1"},{"$f":"IF(ISBLANK(Conc!B9),\"\",Conc!B9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!B9),\"\",'Raw Data'!B9)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!C2),\"\",'Molecule or Synonym'!C2)","v":""},{"$f":"IF(ISBLANK(Batch!C2),\"\",Batch!C2)","v":""},{"$f":"IF(ISBLANK('External ID'!C2),\"\",'External ID'!C2)","v":""},"Plate 1",{"$f":"'Well ID'!C2","v":"A2"},{"$f":"IF(ISBLANK(Conc!C2),\"\",Conc!C2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!C2),\"\",'Raw Data'!C2)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!C3),\"\",'Molecule or Synonym'!C3)","v":""},{"$f":"IF(ISBLANK(Batch!C3),\"\",Batch!C3)","v":""},{"$f":"IF(ISBLANK('External ID'!C3),\"\",'External ID'!C3)","v":""},"Plate 1",{"$f":"'Well ID'!C3","v":"B2"},{"$f":"IF(ISBLANK(Conc!C3),\"\",Conc!C3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!C3),\"\",'Raw Data'!C3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!C4),\"\",'Molecule or Synonym'!C4)","v":""},{"$f":"IF(ISBLANK(Batch!C4),\"\",Batch!C4)","v":""},{"$f":"IF(ISBLANK('External ID'!C4),\"\",'External ID'!C4)","v":""},"Plate 1",{"$f":"'Well ID'!C4","v":"C2"},{"$f":"IF(ISBLANK(Conc!C4),\"\",Conc!C4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!C4),\"\",'Raw Data'!C4)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!C5),\"\",'Molecule or Synonym'!C5)","v":""},{"$f":"IF(ISBLANK(Batch!C5),\"\",Batch!C5)","v":""},{"$f":"IF(ISBLANK('External ID'!C5),\"\",'External ID'!C5)","v":""},"Plate 1",{"$f":"'Well ID'!C5","v":"D2"},{"$f":"IF(ISBLANK(Conc!C5),\"\",Conc!C5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!C5),\"\",'Raw Data'!C5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!C6),\"\",'Molecule or Synonym'!C6)","v":""},{"$f":"IF(ISBLANK(Batch!C6),\"\",Batch!C6)","v":""},{"$f":"IF(ISBLANK('External ID'!C6),\"\",'External ID'!C6)","v":""},"Plate 1",{"$f":"'Well ID'!C6","v":"E2"},{"$f":"IF(ISBLANK(Conc!C6),\"\",Conc!C6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!C6),\"\",'Raw Data'!C6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!C7),\"\",'Molecule or Synonym'!C7)","v":""},{"$f":"IF(ISBLANK(Batch!C7),\"\",Batch!C7)","v":""},{"$f":"IF(ISBLANK('External ID'!C7),\"\",'External ID'!C7)","v":""},"Plate 1",{"$f":"'Well ID'!C7","v":"F2"},{"$f":"IF(ISBLANK(Conc!C7),\"\",Conc!C7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!C7),\"\",'Raw Data'!C7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!C8),\"\",'Molecule or Synonym'!C8)","v":""},{"$f":"IF(ISBLANK(Batch!C8),\"\",Batch!C8)","v":""},{"$f":"IF(ISBLANK('External ID'!C8),\"\",'External ID'!C8)","v":""},"Plate 1",{"$f":"'Well ID'!C8","v":"G2"},{"$f":"IF(ISBLANK(Conc!C8),\"\",Conc!C8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!C8),\"\",'Raw Data'!C8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!C9),\"\",'Molecule or Synonym'!C9)","v":""},{"$f":"IF(ISBLANK(Batch!C9),\"\",Batch!C9)","v":""},{"$f":"IF(ISBLANK('External ID'!C9),\"\",'External ID'!C9)","v":""},"Plate 1",{"$f":"'Well ID'!C9","v":"H2"},{"$f":"IF(ISBLANK(Conc!C9),\"\",Conc!C9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!C9),\"\",'Raw Data'!C9)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!D2),\"\",'Molecule or Synonym'!D2)","v":""},{"$f":"IF(ISBLANK(Batch!D2),\"\",Batch!D2)","v":""},{"$f":"IF(ISBLANK('External ID'!D2),\"\",'External ID'!D2)","v":""},"Plate 1",{"$f":"'Well ID'!D2","v":"A3"},{"$f":"IF(ISBLANK(Conc!D2),\"\",Conc!D2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!D2),\"\",'Raw Data'!D2)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!D3),\"\",'Molecule or Synonym'!D3)","v":""},{"$f":"IF(ISBLANK(Batch!D3),\"\",Batch!D3)","v":""},{"$f":"IF(ISBLANK('External ID'!D3),\"\",'External ID'!D3)","v":""},"Plate 1",{"$f":"'Well ID'!D3","v":"B3"},{"$f":"IF(ISBLANK(Conc!D3),\"\",Conc!D3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!D3),\"\",'Raw Data'!D3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!D4),\"\",'Molecule or Synonym'!D4)","v":""},{"$f":"IF(ISBLANK(Batch!D4),\"\",Batch!D4)","v":""},{"$f":"IF(ISBLANK('External ID'!D4),\"\",'External ID'!D4)","v":""},"Plate 1",{"$f":"'Well ID'!D4","v":"C3"},{"$f":"IF(ISBLANK(Conc!D4),\"\",Conc!D4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!D4),\"\",'Raw Data'!D4)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!D5),\"\",'Molecule or Synonym'!D5)","v":""},{"$f":"IF(ISBLANK(Batch!D5),\"\",Batch!D5)","v":""},{"$f":"IF(ISBLANK('External ID'!D5),\"\",'External ID'!D5)","v":""},"Plate 1",{"$f":"'Well ID'!D5","v":"D3"},{"$f":"IF(ISBLANK(Conc!D5),\"\",Conc!D5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!D5),\"\",'Raw Data'!D5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!D6),\"\",'Molecule or Synonym'!D6)","v":""},{"$f":"IF(ISBLANK(Batch!D6),\"\",Batch!D6)","v":""},{"$f":"IF(ISBLANK('External ID'!D6),\"\",'External ID'!D6)","v":""},"Plate 1",{"$f":"'Well ID'!D6","v":"E3"},{"$f":"IF(ISBLANK(Conc!D6),\"\",Conc!D6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!D6),\"\",'Raw Data'!D6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!D7),\"\",'Molecule or Synonym'!D7)","v":""},{"$f":"IF(ISBLANK(Batch!D7),\"\",Batch!D7)","v":""},{"$f":"IF(ISBLANK('External ID'!D7),\"\",'External ID'!D7)","v":""},"Plate 1",{"$f":"'Well ID'!D7","v":"F3"},{"$f":"IF(ISBLANK(Conc!D7),\"\",Conc!D7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!D7),\"\",'Raw Data'!D7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!D8),\"\",'Molecule or Synonym'!D8)","v":""},{"$f":"IF(ISBLANK(Batch!D8),\"\",Batch!D8)","v":""},{"$f":"IF(ISBLANK('External ID'!D8),\"\",'External ID'!D8)","v":""},"Plate 1",{"$f":"'Well ID'!D8","v":"G3"},{"$f":"IF(ISBLANK(Conc!D8),\"\",Conc!D8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!D8),\"\",'Raw Data'!D8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!D9),\"\",'Molecule or Synonym'!D9)","v":""},{"$f":"IF(ISBLANK(Batch!D9),\"\",Batch!D9)","v":""},{"$f":"IF(ISBLANK('External ID'!D9),\"\",'External ID'!D9)","v":""},"Plate 1",{"$f":"'Well ID'!D9","v":"H3"},{"$f":"IF(ISBLANK(Conc!D9),\"\",Conc!D9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!D9),\"\",'Raw Data'!D9)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!E2),\"\",'Molecule or Synonym'!E2)","v":""},{"$f":"IF(ISBLANK(Batch!E2),\"\",Batch!E2)","v":""},{"$f":"IF(ISBLANK('External ID'!E2),\"\",'External ID'!E2)","v":""},"Plate 1",{"$f":"'Well ID'!E2","v":"A4"},{"$f":"IF(ISBLANK(Conc!E2),\"\",Conc!E2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!E2),\"\",'Raw Data'!E2)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!E3),\"\",'Molecule or Synonym'!E3)","v":""},{"$f":"IF(ISBLANK(Batch!E3),\"\",Batch!E3)","v":""},{"$f":"IF(ISBLANK('External ID'!E3),\"\",'External ID'!E3)","v":""},"Plate 1",{"$f":"'Well ID'!E3","v":"B4"},{"$f":"IF(ISBLANK(Conc!E3),\"\",Conc!E3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!E3),\"\",'Raw Data'!E3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!E4),\"\",'Molecule or Synonym'!E4)","v":""},{"$f":"IF(ISBLANK(Batch!E4),\"\",Batch!E4)","v":""},{"$f":"IF(ISBLANK('External ID'!E4),\"\",'External ID'!E4)","v":""},"Plate 1",{"$f":"'Well ID'!E4","v":"C4"},{"$f":"IF(ISBLANK(Conc!E4),\"\",Conc!E4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!E4),\"\",'Raw Data'!E4)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!E5),\"\",'Molecule or Synonym'!E5)","v":""},{"$f":"IF(ISBLANK(Batch!E5),\"\",Batch!E5)","v":""},{"$f":"IF(ISBLANK('External ID'!E5),\"\",'External ID'!E5)","v":""},"Plate 1",{"$f":"'Well ID'!E5","v":"D4"},{"$f":"IF(ISBLANK(Conc!E5),\"\",Conc!E5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!E5),\"\",'Raw Data'!E5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!E6),\"\",'Molecule or Synonym'!E6)","v":""},{"$f":"IF(ISBLANK(Batch!E6),\"\",Batch!E6)","v":""},{"$f":"IF(ISBLANK('External ID'!E6),\"\",'External ID'!E6)","v":""},"Plate 1",{"$f":"'Well ID'!E6","v":"E4"},{"$f":"IF(ISBLANK(Conc!E6),\"\",Conc!E6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!E6),\"\",'Raw Data'!E6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!E7),\"\",'Molecule or Synonym'!E7)","v":""},{"$f":"IF(ISBLANK(Batch!E7),\"\",Batch!E7)","v":""},{"$f":"IF(ISBLANK('External ID'!E7),\"\",'External ID'!E7)","v":""},"Plate 1",{"$f":"'Well ID'!E7","v":"F4"},{"$f":"IF(ISBLANK(Conc!E7),\"\",Conc!E7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!E7),\"\",'Raw Data'!E7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!E8),\"\",'Molecule or Synonym'!E8)","v":""},{"$f":"IF(ISBLANK(Batch!E8),\"\",Batch!E8)","v":""},{"$f":"IF(ISBLANK('External ID'!E8),\"\",'External ID'!E8)","v":""},"Plate 1",{"$f":"'Well ID'!E8","v":"G4"},{"$f":"IF(ISBLANK(Conc!E8),\"\",Conc!E8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!E8),\"\",'Raw Data'!E8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!E9),\"\",'Molecule or Synonym'!E9)","v":""},{"$f":"IF(ISBLANK(Batch!E9),\"\",Batch!E9)","v":""},{"$f":"IF(ISBLANK('External ID'!E9),\"\",'External ID'!E9)","v":""},"Plate 1",{"$f":"'Well ID'!E9","v":"H4"},{"$f":"IF(ISBLANK(Conc!E9),\"\",Conc!E9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!E9),\"\",'Raw Data'!E9)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!F2),\"\",'Molecule or Synonym'!F2)","v":""},{"$f":"IF(ISBLANK(Batch!F2),\"\",Batch!F2)","v":""},{"$f":"IF(ISBLANK('External ID'!F2),\"\",'External ID'!F2)","v":""},"Plate 1",{"$f":"'Well ID'!F2","v":"A5"},{"$f":"IF(ISBLANK(Conc!F2),\"\",Conc!F2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!F2),\"\",'Raw Data'!F2)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!F3),\"\",'Molecule or Synonym'!F3)","v":""},{"$f":"IF(ISBLANK(Batch!F3),\"\",Batch!F3)","v":""},{"$f":"IF(ISBLANK('External ID'!F3),\"\",'External ID'!F3)","v":""},"Plate 1",{"$f":"'Well ID'!F3","v":"B5"},{"$f":"IF(ISBLANK(Conc!F3),\"\",Conc!F3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!F3),\"\",'Raw Data'!F3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!F4),\"\",'Molecule or Synonym'!F4)","v":""},{"$f":"IF(ISBLANK(Batch!F4),\"\",Batch!F4)","v":""},{"$f":"IF(ISBLANK('External ID'!F4),\"\",'External ID'!F4)","v":""},"Plate 1",{"$f":"'Well ID'!F4","v":"C5"},{"$f":"IF(ISBLANK(Conc!F4),\"\",Conc!F4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!F4),\"\",'Raw Data'!F4)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!F5),\"\",'Molecule or Synonym'!F5)","v":""},{"$f":"IF(ISBLANK(Batch!F5),\"\",Batch!F5)","v":""},{"$f":"IF(ISBLANK('External ID'!F5),\"\",'External ID'!F5)","v":""},"Plate 1",{"$f":"'Well ID'!F5","v":"D5"},{"$f":"IF(ISBLANK(Conc!F5),\"\",Conc!F5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!F5),\"\",'Raw Data'!F5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!F6),\"\",'Molecule or Synonym'!F6)","v":""},{"$f":"IF(ISBLANK(Batch!F6),\"\",Batch!F6)","v":""},{"$f":"IF(ISBLANK('External ID'!F6),\"\",'External ID'!F6)","v":""},"Plate 1",{"$f":"'Well ID'!F6","v":"E5"},{"$f":"IF(ISBLANK(Conc!F6),\"\",Conc!F6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!F6),\"\",'Raw Data'!F6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!F7),\"\",'Molecule or Synonym'!F7)","v":""},{"$f":"IF(ISBLANK(Batch!F7),\"\",Batch!F7)","v":""},{"$f":"IF(ISBLANK('External ID'!F7),\"\",'External ID'!F7)","v":""},"Plate 1",{"$f":"'Well ID'!F7","v":"F5"},{"$f":"IF(ISBLANK(Conc!F7),\"\",Conc!F7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!F7),\"\",'Raw Data'!F7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!F8),\"\",'Molecule or Synonym'!F8)","v":""},{"$f":"IF(ISBLANK(Batch!F8),\"\",Batch!F8)","v":""},{"$f":"IF(ISBLANK('External ID'!F8),\"\",'External ID'!F8)","v":""},"Plate 1",{"$f":"'Well ID'!F8","v":"G5"},{"$f":"IF(ISBLANK(Conc!F8),\"\",Conc!F8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!F8),\"\",'Raw Data'!F8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!F9),\"\",'Molecule or Synonym'!F9)","v":""},{"$f":"IF(ISBLANK(Batch!F9),\"\",Batch!F9)","v":""},{"$f":"IF(ISBLANK('External ID'!F9),\"\",'External ID'!F9)","v":""},"Plate 1",{"$f":"'Well ID'!F9","v":"H5"},{"$f":"IF(ISBLANK(Conc!F9),\"\",Conc!F9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!F9),\"\",'Raw Data'!F9)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!G2),\"\",'Molecule or Synonym'!G2)","v":""},{"$f":"IF(ISBLANK(Batch!G2),\"\",Batch!G2)","v":""},{"$f":"IF(ISBLANK('External ID'!G2),\"\",'External ID'!G2)","v":""},"Plate 1",{"$f":"'Well ID'!G2","v":"A6"},{"$f":"IF(ISBLANK(Conc!G2),\"\",Conc!G2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!G2),\"\",'Raw Data'!G2)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!G3),\"\",'Molecule or Synonym'!G3)","v":""},{"$f":"IF(ISBLANK(Batch!G3),\"\",Batch!G3)","v":""},{"$f":"IF(ISBLANK('External ID'!G3),\"\",'External ID'!G3)","v":""},"Plate 1",{"$f":"'Well ID'!G3","v":"B6"},{"$f":"IF(ISBLANK(Conc!G3),\"\",Conc!G3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!G3),\"\",'Raw Data'!G3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!G4),\"\",'Molecule or Synonym'!G4)","v":""},{"$f":"IF(ISBLANK(Batch!G4),\"\",Batch!G4)","v":""},{"$f":"IF(ISBLANK('External ID'!G4),\"\",'External ID'!G4)","v":""},"Plate 1",{"$f":"'Well ID'!G4","v":"C6"},{"$f":"IF(ISBLANK(Conc!G4),\"\",Conc!G4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!G4),\"\",'Raw Data'!G4)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!G5),\"\",'Molecule or Synonym'!G5)","v":""},{"$f":"IF(ISBLANK(Batch!G5),\"\",Batch!G5)","v":""},{"$f":"IF(ISBLANK('External ID'!G5),\"\",'External ID'!G5)","v":""},"Plate 1",{"$f":"'Well ID'!G5","v":"D6"},{"$f":"IF(ISBLANK(Conc!G5),\"\",Conc!G5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!G5),\"\",'Raw Data'!G5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!G6),\"\",'Molecule or Synonym'!G6)","v":""},{"$f":"IF(ISBLANK(Batch!G6),\"\",Batch!G6)","v":""},{"$f":"IF(ISBLANK('External ID'!G6),\"\",'External ID'!G6)","v":""},"Plate 1",{"$f":"'Well ID'!G6","v":"E6"},{"$f":"IF(ISBLANK(Conc!G6),\"\",Conc!G6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!G6),\"\",'Raw Data'!G6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!G7),\"\",'Molecule or Synonym'!G7)","v":""},{"$f":"IF(ISBLANK(Batch!G7),\"\",Batch!G7)","v":""},{"$f":"IF(ISBLANK('External ID'!G7),\"\",'External ID'!G7)","v":""},"Plate 1",{"$f":"'Well ID'!G7","v":"F6"},{"$f":"IF(ISBLANK(Conc!G7),\"\",Conc!G7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!G7),\"\",'Raw Data'!G7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!G8),\"\",'Molecule or Synonym'!G8)","v":""},{"$f":"IF(ISBLANK(Batch!G8),\"\",Batch!G8)","v":""},{"$f":"IF(ISBLANK('External ID'!G8),\"\",'External ID'!G8)","v":""},"Plate 1",{"$f":"'Well ID'!G8","v":"G6"},{"$f":"IF(ISBLANK(Conc!G8),\"\",Conc!G8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!G8),\"\",'Raw Data'!G8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!G9),\"\",'Molecule or Synonym'!G9)","v":""},{"$f":"IF(ISBLANK(Batch!G9),\"\",Batch!G9)","v":""},{"$f":"IF(ISBLANK('External ID'!G9),\"\",'External ID'!G9)","v":""},"Plate 1",{"$f":"'Well ID'!G9","v":"H6"},{"$f":"IF(ISBLANK(Conc!G9),\"\",Conc!G9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!G9),\"\",'Raw Data'!G9)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!H2),\"\",'Molecule or Synonym'!H2)","v":""},{"$f":"IF(ISBLANK(Batch!H2),\"\",Batch!H2)","v":""},{"$f":"IF(ISBLANK('External ID'!H2),\"\",'External ID'!H2)","v":""},"Plate 1",{"$f":"'Well ID'!H2","v":"A7"},{"$f":"IF(ISBLANK(Conc!H2),\"\",Conc!H2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!H2),\"\",'Raw Data'!H2)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!H3),\"\",'Molecule or Synonym'!H3)","v":""},{"$f":"IF(ISBLANK(Batch!H3),\"\",Batch!H3)","v":""},{"$f":"IF(ISBLANK('External ID'!H3),\"\",'External ID'!H3)","v":""},"Plate 1",{"$f":"'Well ID'!H3","v":"B7"},{"$f":"IF(ISBLANK(Conc!H3),\"\",Conc!H3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!H3),\"\",'Raw Data'!H3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!H4),\"\",'Molecule or Synonym'!H4)","v":""},{"$f":"IF(ISBLANK(Batch!H4),\"\",Batch!H4)","v":""},{"$f":"IF(ISBLANK('External ID'!H4),\"\",'External ID'!H4)","v":""},"Plate 1",{"$f":"'Well ID'!H4","v":"C7"},{"$f":"IF(ISBLANK(Conc!H4),\"\",Conc!H4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!H4),\"\",'Raw Data'!H4)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!H5),\"\",'Molecule or Synonym'!H5)","v":""},{"$f":"IF(ISBLANK(Batch!H5),\"\",Batch!H5)","v":""},{"$f":"IF(ISBLANK('External ID'!H5),\"\",'External ID'!H5)","v":""},"Plate 1",{"$f":"'Well ID'!H5","v":"D7"},{"$f":"IF(ISBLANK(Conc!H5),\"\",Conc!H5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!H5),\"\",'Raw Data'!H5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!H6),\"\",'Molecule or Synonym'!H6)","v":""},{"$f":"IF(ISBLANK(Batch!H6),\"\",Batch!H6)","v":""},{"$f":"IF(ISBLANK('External ID'!H6),\"\",'External ID'!H6)","v":""},"Plate 1",{"$f":"'Well ID'!H6","v":"E7"},{"$f":"IF(ISBLANK(Conc!H6),\"\",Conc!H6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!H6),\"\",'Raw Data'!H6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!H7),\"\",'Molecule or Synonym'!H7)","v":""},{"$f":"IF(ISBLANK(Batch!H7),\"\",Batch!H7)","v":""},{"$f":"IF(ISBLANK('External ID'!H7),\"\",'External ID'!H7)","v":""},"Plate 1",{"$f":"'Well ID'!H7","v":"F7"},{"$f":"IF(ISBLANK(Conc!H7),\"\",Conc!H7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!H7),\"\",'Raw Data'!H7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!H8),\"\",'Molecule or Synonym'!H8)","v":""},{"$f":"IF(ISBLANK(Batch!H8),\"\",Batch!H8)","v":""},{"$f":"IF(ISBLANK('External ID'!H8),\"\",'External ID'!H8)","v":""},"Plate 1",{"$f":"'Well ID'!H8","v":"G7"},{"$f":"IF(ISBLANK(Conc!H8),\"\",Conc!H8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!H8),\"\",'Raw Data'!H8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!H9),\"\",'Molecule or Synonym'!H9)","v":""},{"$f":"IF(ISBLANK(Batch!H9),\"\",Batch!H9)","v":""},{"$f":"IF(ISBLANK('External ID'!H9),\"\",'External ID'!H9)","v":""},"Plate 1",{"$f":"'Well ID'!H9","v":"H7"},{"$f":"IF(ISBLANK(Conc!H9),\"\",Conc!H9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!H9),\"\",'Raw Data'!H9)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!I2),\"\",'Molecule or Synonym'!I2)","v":""},{"$f":"IF(ISBLANK(Batch!I2),\"\",Batch!I2)","v":""},{"$f":"IF(ISBLANK('External ID'!I2),\"\",'External ID'!I2)","v":""},"Plate 1",{"$f":"'Well ID'!I2","v":"A8"},{"$f":"IF(ISBLANK(Conc!I2),\"\",Conc!I2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!I2),\"\",'Raw Data'!I2)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!I3),\"\",'Molecule or Synonym'!I3)","v":""},{"$f":"IF(ISBLANK(Batch!I3),\"\",Batch!I3)","v":""},{"$f":"IF(ISBLANK('External ID'!I3),\"\",'External ID'!I3)","v":""},"Plate 1",{"$f":"'Well ID'!I3","v":"B8"},{"$f":"IF(ISBLANK(Conc!I3),\"\",Conc!I3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!I3),\"\",'Raw Data'!I3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!I4),\"\",'Molecule or Synonym'!I4)","v":""},{"$f":"IF(ISBLANK(Batch!I4),\"\",Batch!I4)","v":""},{"$f":"IF(ISBLANK('External ID'!I4),\"\",'External ID'!I4)","v":""},"Plate 1",{"$f":"'Well ID'!I4","v":"C8"},{"$f":"IF(ISBLANK(Conc!I4),\"\",Conc!I4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!I4),\"\",'Raw Data'!I4)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!I5),\"\",'Molecule or Synonym'!I5)","v":""},{"$f":"IF(ISBLANK(Batch!I5),\"\",Batch!I5)","v":""},{"$f":"IF(ISBLANK('External ID'!I5),\"\",'External ID'!I5)","v":""},"Plate 1",{"$f":"'Well ID'!I5","v":"D8"},{"$f":"IF(ISBLANK(Conc!I5),\"\",Conc!I5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!I5),\"\",'Raw Data'!I5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!I6),\"\",'Molecule or Synonym'!I6)","v":""},{"$f":"IF(ISBLANK(Batch!I6),\"\",Batch!I6)","v":""},{"$f":"IF(ISBLANK('External ID'!I6),\"\",'External ID'!I6)","v":""},"Plate 1",{"$f":"'Well ID'!I6","v":"E8"},{"$f":"IF(ISBLANK(Conc!I6),\"\",Conc!I6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!I6),\"\",'Raw Data'!I6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!I7),\"\",'Molecule or Synonym'!I7)","v":""},{"$f":"IF(ISBLANK(Batch!I7),\"\",Batch!I7)","v":""},{"$f":"IF(ISBLANK('External ID'!I7),\"\",'External ID'!I7)","v":""},"Plate 1",{"$f":"'Well ID'!I7","v":"F8"},{"$f":"IF(ISBLANK(Conc!I7),\"\",Conc!I7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!I7),\"\",'Raw Data'!I7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!I8),\"\",'Molecule or Synonym'!I8)","v":""},{"$f":"IF(ISBLANK(Batch!I8),\"\",Batch!I8)","v":""},{"$f":"IF(ISBLANK('External ID'!I8),\"\",'External ID'!I8)","v":""},"Plate 1",{"$f":"'Well ID'!I8","v":"G8"},{"$f":"IF(ISBLANK(Conc!I8),\"\",Conc!I8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!I8),\"\",'Raw Data'!I8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!I9),\"\",'Molecule or Synonym'!I9)","v":""},{"$f":"IF(ISBLANK(Batch!I9),\"\",Batch!I9)","v":""},{"$f":"IF(ISBLANK('External ID'!I9),\"\",'External ID'!I9)","v":""},"Plate 1",{"$f":"'Well ID'!I9","v":"H8"},{"$f":"IF(ISBLANK(Conc!I9),\"\",Conc!I9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!I9),\"\",'Raw Data'!I9)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!J2),\"\",'Molecule or Synonym'!J2)","v":""},{"$f":"IF(ISBLANK(Batch!J2),\"\",Batch!J2)","v":""},{"$f":"IF(ISBLANK('External ID'!J2),\"\",'External ID'!J2)","v":""},"Plate 1",{"$f":"'Well ID'!J2","v":"A9"},{"$f":"IF(ISBLANK(Conc!J2),\"\",Conc!J2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!J2),\"\",'Raw Data'!J2)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!J3),\"\",'Molecule or Synonym'!J3)","v":""},{"$f":"IF(ISBLANK(Batch!J3),\"\",Batch!J3)","v":""},{"$f":"IF(ISBLANK('External ID'!J3),\"\",'External ID'!J3)","v":""},"Plate 1",{"$f":"'Well ID'!J3","v":"B9"},{"$f":"IF(ISBLANK(Conc!J3),\"\",Conc!J3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!J3),\"\",'Raw Data'!J3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!J4),\"\",'Molecule or Synonym'!J4)","v":""},{"$f":"IF(ISBLANK(Batch!J4),\"\",Batch!J4)","v":""},{"$f":"IF(ISBLANK('External ID'!J4),\"\",'External ID'!J4)","v":""},{"$f":"$J$2","v":"Plate 1"},{"$f":"'Well ID'!J4","v":"C9"},{"$f":"IF(ISBLANK(Conc!J4),\"\",Conc!J4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!J4),\"\",'Raw Data'!J4)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!J5),\"\",'Molecule or Synonym'!J5)","v":""},{"$f":"IF(ISBLANK(Batch!J5),\"\",Batch!J5)","v":""},{"$f":"IF(ISBLANK('External ID'!J5),\"\",'External ID'!J5)","v":""},"Plate 1",{"$f":"'Well ID'!J5","v":"D9"},{"$f":"IF(ISBLANK(Conc!J5),\"\",Conc!J5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!J5),\"\",'Raw Data'!J5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!J6),\"\",'Molecule or Synonym'!J6)","v":""},{"$f":"IF(ISBLANK(Batch!J6),\"\",Batch!J6)","v":""},{"$f":"IF(ISBLANK('External ID'!J6),\"\",'External ID'!J6)","v":""},"Plate 1",{"$f":"'Well ID'!J6","v":"E9"},{"$f":"IF(ISBLANK(Conc!J6),\"\",Conc!J6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!J6),\"\",'Raw Data'!J6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!J7),\"\",'Molecule or Synonym'!J7)","v":""},{"$f":"IF(ISBLANK(Batch!J7),\"\",Batch!J7)","v":""},{"$f":"IF(ISBLANK('External ID'!J7),\"\",'External ID'!J7)","v":""},"Plate 1",{"$f":"'Well ID'!J7","v":"F9"},{"$f":"IF(ISBLANK(Conc!J7),\"\",Conc!J7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!J7),\"\",'Raw Data'!J7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!J8),\"\",'Molecule or Synonym'!J8)","v":""},{"$f":"IF(ISBLANK(Batch!J8),\"\",Batch!J8)","v":""},{"$f":"IF(ISBLANK('External ID'!J8),\"\",'External ID'!J8)","v":""},"Plate 1",{"$f":"'Well ID'!J8","v":"G9"},{"$f":"IF(ISBLANK(Conc!J8),\"\",Conc!J8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!J8),\"\",'Raw Data'!J8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!J9),\"\",'Molecule or Synonym'!J9)","v":""},{"$f":"IF(ISBLANK(Batch!J9),\"\",Batch!J9)","v":""},{"$f":"IF(ISBLANK('External ID'!J9),\"\",'External ID'!J9)","v":""},"Plate 1",{"$f":"'Well ID'!J9","v":"H9"},{"$f":"IF(ISBLANK(Conc!J9),\"\",Conc!J9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!J9),\"\",'Raw Data'!J9)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!K2),\"\",'Molecule or Synonym'!K2)","v":""},{"$f":"IF(ISBLANK(Batch!K2),\"\",Batch!K2)","v":""},{"$f":"IF(ISBLANK('External ID'!K2),\"\",'External ID'!K2)","v":""},"Plate 1",{"$f":"'Well ID'!K2","v":"A10"},{"$f":"IF(ISBLANK(Conc!K2),\"\",Conc!K2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!K2),\"\",'Raw Data'!K2)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!K3),\"\",'Molecule or Synonym'!K3)","v":""},{"$f":"IF(ISBLANK(Batch!K3),\"\",Batch!K3)","v":""},{"$f":"IF(ISBLANK('External ID'!K3),\"\",'External ID'!K3)","v":""},"Plate 1",{"$f":"'Well ID'!K3","v":"B10"},{"$f":"IF(ISBLANK(Conc!K3),\"\",Conc!K3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!K3),\"\",'Raw Data'!K3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!K4),\"\",'Molecule or Synonym'!K4)","v":""},{"$f":"IF(ISBLANK(Batch!K4),\"\",Batch!K4)","v":""},{"$f":"IF(ISBLANK('External ID'!K4),\"\",'External ID'!K4)","v":""},"Plate 1",{"$f":"'Well ID'!K4","v":"C10"},{"$f":"IF(ISBLANK(Conc!K4),\"\",Conc!K4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!K4),\"\",'Raw Data'!K4)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!K5),\"\",'Molecule or Synonym'!K5)","v":""},{"$f":"IF(ISBLANK(Batch!K5),\"\",Batch!K5)","v":""},{"$f":"IF(ISBLANK('External ID'!K5),\"\",'External ID'!K5)","v":""},"Plate 1",{"$f":"'Well ID'!K5","v":"D10"},{"$f":"IF(ISBLANK(Conc!K5),\"\",Conc!K5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!K5),\"\",'Raw Data'!K5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!K6),\"\",'Molecule or Synonym'!K6)","v":""},{"$f":"IF(ISBLANK(Batch!K6),\"\",Batch!K6)","v":""},{"$f":"IF(ISBLANK('External ID'!K6),\"\",'External ID'!K6)","v":""},"Plate 1",{"$f":"'Well ID'!K6","v":"E10"},{"$f":"IF(ISBLANK(Conc!K6),\"\",Conc!K6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!K6),\"\",'Raw Data'!K6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!K7),\"\",'Molecule or Synonym'!K7)","v":""},{"$f":"IF(ISBLANK(Batch!K7),\"\",Batch!K7)","v":""},{"$f":"IF(ISBLANK('External ID'!K7),\"\",'External ID'!K7)","v":""},"Plate 1",{"$f":"'Well ID'!K7","v":"F10"},{"$f":"IF(ISBLANK(Conc!K7),\"\",Conc!K7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!K7),\"\",'Raw Data'!K7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!K8),\"\",'Molecule or Synonym'!K8)","v":""},{"$f":"IF(ISBLANK(Batch!K8),\"\",Batch!K8)","v":""},{"$f":"IF(ISBLANK('External ID'!K8),\"\",'External ID'!K8)","v":""},"Plate 1",{"$f":"'Well ID'!K8","v":"G10"},{"$f":"IF(ISBLANK(Conc!K8),\"\",Conc!K8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!K8),\"\",'Raw Data'!K8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!K9),\"\",'Molecule or Synonym'!K9)","v":""},{"$f":"IF(ISBLANK(Batch!K9),\"\",Batch!K9)","v":""},{"$f":"IF(ISBLANK('External ID'!K9),\"\",'External ID'!K9)","v":""},"Plate 1",{"$f":"'Well ID'!K9","v":"H10"},{"$f":"IF(ISBLANK(Conc!K9),\"\",Conc!K9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!K9),\"\",'Raw Data'!K9)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!L2),\"\",'Molecule or Synonym'!L2)","v":""},{"$f":"IF(ISBLANK(Batch!L2),\"\",Batch!L2)","v":""},{"$f":"IF(ISBLANK('External ID'!L2),\"\",'External ID'!L2)","v":""},"Plate 1",{"$f":"'Well ID'!L2","v":"A11"},{"$f":"IF(ISBLANK(Conc!L2),\"\",Conc!L2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!L2),\"\",'Raw Data'!L2)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!L3),\"\",'Molecule or Synonym'!L3)","v":""},{"$f":"IF(ISBLANK(Batch!L3),\"\",Batch!L3)","v":""},{"$f":"IF(ISBLANK('External ID'!L3),\"\",'External ID'!L3)","v":""},"Plate 1",{"$f":"'Well ID'!L3","v":"B11"},{"$f":"IF(ISBLANK(Conc!L3),\"\",Conc!L3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!L3),\"\",'Raw Data'!L3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!L4),\"\",'Molecule or Synonym'!L4)","v":""},{"$f":"IF(ISBLANK(Batch!L4),\"\",Batch!L4)","v":""},{"$f":"IF(ISBLANK('External ID'!L4),\"\",'External ID'!L4)","v":""},"Plate 1",{"$f":"'Well ID'!L4","v":"C11"},{"$f":"IF(ISBLANK(Conc!L4),\"\",Conc!L4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!L4),\"\",'Raw Data'!L4)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!L5),\"\",'Molecule or Synonym'!L5)","v":""},{"$f":"IF(ISBLANK(Batch!L5),\"\",Batch!L5)","v":""},{"$f":"IF(ISBLANK('External ID'!L5),\"\",'External ID'!L5)","v":""},"Plate 1",{"$f":"'Well ID'!L5","v":"D11"},{"$f":"IF(ISBLANK(Conc!L5),\"\",Conc!L5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!L5),\"\",'Raw Data'!L5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!L6),\"\",'Molecule or Synonym'!L6)","v":""},{"$f":"IF(ISBLANK(Batch!L6),\"\",Batch!L6)","v":""},{"$f":"IF(ISBLANK('External ID'!L6),\"\",'External ID'!L6)","v":""},"Plate 1",{"$f":"'Well ID'!L6","v":"E11"},{"$f":"IF(ISBLANK(Conc!L6),\"\",Conc!L6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!L6),\"\",'Raw Data'!L6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!L7),\"\",'Molecule or Synonym'!L7)","v":""},{"$f":"IF(ISBLANK(Batch!L7),\"\",Batch!L7)","v":""},{"$f":"IF(ISBLANK('External ID'!L7),\"\",'External ID'!L7)","v":""},"Plate 1",{"$f":"'Well ID'!L7","v":"F11"},{"$f":"IF(ISBLANK(Conc!L7),\"\",Conc!L7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!L7),\"\",'Raw Data'!L7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!L8),\"\",'Molecule or Synonym'!L8)","v":""},{"$f":"IF(ISBLANK(Batch!L8),\"\",Batch!L8)","v":""},{"$f":"IF(ISBLANK('External ID'!L8),\"\",'External ID'!L8)","v":""},"Plate 1",{"$f":"'Well ID'!L8","v":"G11"},{"$f":"IF(ISBLANK(Conc!L8),\"\",Conc!L8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!L8),\"\",'Raw Data'!L8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!L9),\"\",'Molecule or Synonym'!L9)","v":""},{"$f":"IF(ISBLANK(Batch!L9),\"\",Batch!L9)","v":""},{"$f":"IF(ISBLANK('External ID'!L9),\"\",'External ID'!L9)","v":""},"Plate 1",{"$f":"'Well ID'!L9","v":"H11"},{"$f":"IF(ISBLANK(Conc!L9),\"\",Conc!L9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!L9),\"\",'Raw Data'!L9)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!M2),\"\",'Molecule or Synonym'!M2)","v":""},{"$f":"IF(ISBLANK(Batch!M2),\"\",Batch!M2)","v":""},{"$f":"IF(ISBLANK('External ID'!M2),\"\",'External ID'!M2)","v":""},"Plate 1",{"$f":"'Well ID'!M2","v":"A12"},{"$f":"IF(ISBLANK(Conc!M2),\"\",Conc!M2)","v":""},{"$f":"IF(ISBLANK('Raw Data'!M2),\"\",'Raw Data'!M2)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!M3),\"\",'Molecule or Synonym'!M3)","v":""},{"$f":"IF(ISBLANK(Batch!M3),\"\",Batch!M3)","v":""},{"$f":"IF(ISBLANK('External ID'!M3),\"\",'External ID'!M3)","v":""},"Plate 1",{"$f":"'Well ID'!M3","v":"B12"},{"$f":"IF(ISBLANK(Conc!M3),\"\",Conc!M3)","v":""},{"$f":"IF(ISBLANK('Raw Data'!M3),\"\",'Raw Data'!M3)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!M4),\"\",'Molecule or Synonym'!M4)","v":""},{"$f":"IF(ISBLANK(Batch!M4),\"\",Batch!M4)","v":""},{"$f":"IF(ISBLANK('External ID'!M4),\"\",'External ID'!M4)","v":""},"Plate 1",{"$f":"'Well ID'!M4","v":"C12"},{"$f":"IF(ISBLANK(Conc!M4),\"\",Conc!M4)","v":""},{"$f":"IF(ISBLANK('Raw Data'!M4),\"\",'Raw Data'!M4)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!M5),\"\",'Molecule or Synonym'!M5)","v":""},{"$f":"IF(ISBLANK(Batch!M5),\"\",Batch!M5)","v":""},{"$f":"IF(ISBLANK('External ID'!M5),\"\",'External ID'!M5)","v":""},"Plate 1",{"$f":"'Well ID'!M5","v":"D12"},{"$f":"IF(ISBLANK(Conc!M5),\"\",Conc!M5)","v":""},{"$f":"IF(ISBLANK('Raw Data'!M5),\"\",'Raw Data'!M5)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!M6),\"\",'Molecule or Synonym'!M6)","v":""},{"$f":"IF(ISBLANK(Batch!M6),\"\",Batch!M6)","v":""},{"$f":"IF(ISBLANK('External ID'!M6),\"\",'External ID'!M6)","v":""},"Plate 1",{"$f":"'Well ID'!M6","v":"E12"},{"$f":"IF(ISBLANK(Conc!M6),\"\",Conc!M6)","v":""},{"$f":"IF(ISBLANK('Raw Data'!M6),\"\",'Raw Data'!M6)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!M7),\"\",'Molecule or Synonym'!M7)","v":""},{"$f":"IF(ISBLANK(Batch!M7),\"\",Batch!M7)","v":""},{"$f":"IF(ISBLANK('External ID'!M7),\"\",'External ID'!M7)","v":""},"Plate 1",{"$f":"'Well ID'!M7","v":"F12"},{"$f":"IF(ISBLANK(Conc!M7),\"\",Conc!M7)","v":""},{"$f":"IF(ISBLANK('Raw Data'!M7),\"\",'Raw Data'!M7)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!M8),\"\",'Molecule or Synonym'!M8)","v":""},{"$f":"IF(ISBLANK(Batch!M8),\"\",Batch!M8)","v":""},{"$f":"IF(ISBLANK('External ID'!M8),\"\",'External ID'!M8)","v":""},"Plate 1",{"$f":"'Well ID'!M8","v":"G12"},{"$f":"IF(ISBLANK(Conc!M8),\"\",Conc!M8)","v":""},{"$f":"IF(ISBLANK('Raw Data'!M8),\"\",'Raw Data'!M8)","v":""}]
[{"$f":"IF(ISBLANK('Molecule or Synonym'!M9),\"\",'Molecule or Synonym'!M9)","v":""},{"$f":"IF(ISBLANK(Batch!M9),\"\",Batch!M9)","v":""},{"$f":"IF(ISBLANK('External ID'!M9),\"\",'External ID'!M9)","v":""},"Plate 1",{"$f":"'Well ID'!M9","v":"H12"},{"$f":"IF(ISBLANK(Conc!M9),\"\",Conc!M9)","v":""},{"$f":"IF(ISBLANK('Raw Data'!M9),\"\",'Raw Data'!M9)","v":""}]
["","","","Plate 1","A1","","",null,"Unique Plate Name:","Plate 1"]
["","","","Plate 1","B1","",""]
["","","","Plate 1","C1","","",null,"a unique identifier for plate entered in cell J2"]
["","","","Plate 1","D1","",""]
["","","","Plate 1","E1","",""]
["","","","Plate 1","F1","",""]
["","","","Plate 1","G1","",""]
["","","","Plate 1","H1","",""]
["","","","Plate 1","A2","",""]
["","","","Plate 1","B2","",""]
["","","","Plate 1","C2","",""]
["","","","Plate 1","D2","",""]
["","","","Plate 1","E2","",""]
["","","","Plate 1","F2","",""]
["","","","Plate 1","G2","",""]
["","","","Plate 1","H2","",""]
["","","","Plate 1","A3","",""]
["","","","Plate 1","B3","",""]
["","","","Plate 1","C3","",""]
["","","","Plate 1","D3","",""]
["","","","Plate 1","E3","",""]
["","","","Plate 1","F3","",""]
["","","","Plate 1","G3","",""]
["","","","Plate 1","H3","",""]
["","","","Plate 1","A4","",""]
["","","","Plate 1","B4","",""]
["","","","Plate 1","C4","",""]
["","","","Plate 1","D4","",""]
["","","","Plate 1","E4","",""]
["","","","Plate 1","F4","",""]
["","","","Plate 1","G4","",""]
["","","","Plate 1","H4","",""]
["","","","Plate 1","A5","",""]
["","","","Plate 1","B5","",""]
["","","","Plate 1","C5","",""]
["","","","Plate 1","D5","",""]
["","","","Plate 1","E5","",""]
["","","","Plate 1","F5","",""]
["","","","Plate 1","G5","",""]
["","","","Plate 1","H5","",""]
["","","","Plate 1","A6","",""]
["","","","Plate 1","B6","",""]
["","","","Plate 1","C6","",""]
["","","","Plate 1","D6","",""]
["","","","Plate 1","E6","",""]
["","","","Plate 1","F6","",""]
["","","","Plate 1","G6","",""]
["","","","Plate 1","H6","",""]
["","","","Plate 1","A7","",""]
["","","","Plate 1","B7","",""]
["","","","Plate 1","C7","",""]
["","","","Plate 1","D7","",""]
["","","","Plate 1","E7","",""]
["","","","Plate 1","F7","",""]
["","","","Plate 1","G7","",""]
["","","","Plate 1","H7","",""]
["","","","Plate 1","A8","",""]
["","","","Plate 1","B8","",""]
["","","","Plate 1","C8","",""]
["","","","Plate 1","D8","",""]
["","","","Plate 1","E8","",""]
["","","","Plate 1","F8","",""]
["","","","Plate 1","G8","",""]
["","","","Plate 1","H8","",""]
["","","","Plate 1","A9","",""]
["","","","Plate 1","B9","",""]
["","","","Plate 1","C9","",""]
["","","","Plate 1","D9","",""]
["","","","Plate 1","E9","",""]
["","","","Plate 1","F9","",""]
["","","","Plate 1","G9","",""]
["","","","Plate 1","H9","",""]
["","","","Plate 1","A10","",""]
["","","","Plate 1","B10","",""]
["","","","Plate 1","C10","",""]
["","","","Plate 1","D10","",""]
["","","","Plate 1","E10","",""]
["","","","Plate 1","F10","",""]
["","","","Plate 1","G10","",""]
["","","","Plate 1","H10","",""]
["","","","Plate 1","A11","",""]
["","","","Plate 1","B11","",""]
["","","","Plate 1","C11","",""]
["","","","Plate 1","D11","",""]
["","","","Plate 1","E11","",""]
["","","","Plate 1","F11","",""]
["","","","Plate 1","G11","",""]
["","","","Plate 1","H11","",""]
["","","","Plate 1","A12","",""]
["","","","Plate 1","B12","",""]
["","","","Plate 1","C12","",""]
["","","","Plate 1","D12","",""]
["","","","Plate 1","E12","",""]
["","","","Plate 1","F12","",""]
["","","","Plate 1","G12","",""]
["","","","Plate 1","H12","",""]

{"sheet":"Instructions","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"merged":[[6,1,7,17],[13,1,14,17],[18,2,19,17],[20,2,21,17]]}
["Use this file to convert your plate-formatted data in 96-well format to  the long and skinny format to upload data into CDD Vault"]
[]
["Tabs"]
["1.","Compound - populate the wells with the Molecule/Compound name (prefix-XXXXXXX)"]
["2.","Batch - populate the wells with the Batch Name of the Molecule/Compound/Synonym name, i.e., 1, 2 or 3, etc."]
["3.","External ID - if you've created a batch user-defined field that aliases a specific batch of a molecule, instead of mapping both Molecule and Batch Name, you may just map External ID"]
["4.","Conc - input (number formatted) concentrations for each well, leave positive and negative control wells blank; note that this should all be in the same units and comply with your protocol definition"]
[]
["5.","Raw Data - copy and paste your plate-formatted raw data into the appropriate cells"]
[]
["Review and Import File"]
["1.","Once data is entered into the appropriate tabs, review the long and skinny table to import (first tab)"]
["2.","If you have more than one plate of data for a run, use this same template to enter new plate data by clicking the Add New Plate Data button"]
["3.","After clicking on the Add New Data button, new rows will be entered at the top for your new plate of data. Repeat previous steps to enter data for another plate; if needed, clear out the concentration data on the concentration tab"]
[]
["4.","Optional: delete any unwanted rows of data"]
["5.","Positive and Negative Control Data: In the Molecule, Batch and/or External ID columns, the cells should be empty. Your control data is determined by your control layout."]
["6.","Save the file and proceed to importing the file via the Data Import Wizard in CDD Vault"]
[null,"a.","Saving as an .xlsx file - Copy and paste the values of the Long and Skinny tab in place; this helps to avoid any errors that may come from formulas written into Excel; note that CDD Vault only looks at the first tab of the .xlsx file for import"]
[]
[null,"b.","Saving as a .csv file (recommended) - Go to File > save as and save as the csv (comma delimited) format; use this to avoid the error that may come from formulas written into Excel; use this format if you wish to attach this file in an ELN entry and import from the ELN; at current time import of the .xlsx format in not supported via the ELN"]

{"sheet":"Molecule or Synonym","index":2,"n_rows":11,"n_cols":13,"rows_kept":11}
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["A"]
["B"]
["C"]
["D"]
["E"]
["F"]
["G"]
["H"]
[]
["Prefix-XXXXXXX\ncompound or synonym"]

{"sheet":"Batch","index":3,"n_rows":11,"n_cols":13,"rows_kept":11}
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["A"]
["B"]
["C"]
["D"]
["E"]
["F"]
["G"]
["H"]
[]
["1, 2 , 3 etc\nbatch"]

{"sheet":"External ID","index":4,"n_rows":11,"n_cols":13,"rows_kept":11}
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["A"]
["B"]
["C"]
["D"]
["E"]
["F"]
["G"]
["H"]
[]
["external ID = batch of a molecule external ID (batch UDF)"]

{"sheet":"Well ID","index":5,"n_rows":9,"n_cols":13,"rows_kept":9,"hidden":true}
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["A",{"$f":"$A2&$B$1","v":"A1"},{"$f":"$A2&C$1","v":"A2"},"A3","A4","A5","A6","A7","A8","A9","A10","A11","A12"]
["B",{"$f":"$A3&$B$1","v":"B1"},{"$f":"$A3&C$1","v":"B2"},"B3","B4","B5","B6","B7","B8","B9","B10","B11","B12"]
["C","C1","C2","C3","C4","C5","C6","C7","C8","C9","C10","C11","C12"]
["D","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","D11","D12"]
["E","E1","E2","E3","E4","E5","E6","E7","E8","E9","E10","E11","E12"]
["F","F1","F2","F3","F4","F5","F6","F7","F8","F9","F10","F11","F12"]
["G",{"$f":"$A8&$B$1","v":"G1"},"G2","G3","G4","G5","G6","G7","G8","G9","G10","G11","G12"]
["H","H1","H2","H3","H4","H5","H6","H7","H8","H9","H10","H11","H12"]

{"sheet":"Conc","index":6,"n_rows":11,"n_cols":13,"rows_kept":11}
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["A"]
["B"]
["C"]
["D"]
["E"]
["F"]
["G"]
["H"]
[]
["consistent units (uM, nM)\nConc"]

{"sheet":"Raw Data","index":7,"n_rows":11,"n_cols":13,"rows_kept":11}
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["A"]
["B"]
["C"]
["D"]
["E"]
["F"]
["G"]
["H"]
[]
["Abs, RFU, OD, etc\nRaw Data"]