{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Directions: From left to right, enter information for each panel and follow the recommended pooling guidelines. "]
["Do not enter anything in cells that are red. Blue columns indicate pipetting steps."]
["If using a panel that targets non-genomic DNA (e.g., mitochondrial DNA or a plasmid/vector), please contact support@missionbio.com."]
["NOTE: Some Mission Bio catalog panels have unequal numbers of FWD and REV primers, and pooling volumes will vary accordingly."]
[]
[]
[]
[]
[]
["Number of runs -->",8]
[]
[]
[null,"Panel Name [optional]","Panel ID","Panel Size","Custom Panel Size","FWD Primers","REV Primers","FWD Primer Volume","REV Primer Volume"]
["Panel 1",null,null,{"$f":"IF(ISBLANK(C14), \"\", VLOOKUP(C14,$O$18:$P$26,2,FALSE))","v":""},null,{"$f":"IF(ISBLANK(C14),\"\",IF(AND(C14=\"Custom\", E14<>0),E14,IF(AND(C14=\"Custom\",E14=0),\"\", VLOOKUP(C14,$O$18:$R$26,3,FALSE))))","v":""},{"$f":"IF(ISBLANK(C14),\"\",IF(AND(C14=\"Custom\", E14<>0),E14,IF(AND(C14=\"Custom\",E14=0),\"\", VLOOKUP(C14,$O$18:$R$26,4,FALSE))))","v":""},{"$f":"IF(ISBLANK($B$10), \"\", IF(ISBLANK(C14),\"\",IF(F14=\"\", \"\", ((F14/$F$16)*5)*1.15*$B$10)))","v":""},{"$f":"IF(ISBLANK($B$10), \"\", IF(ISBLANK(D14),\"\",IF(G14=\"\", \"\", ((G14/$G$16)*5)*1.15*$B$10)))","v":""}]
["Panel 2",null,null,{"$f":"IF(ISBLANK(C15), \"\", VLOOKUP(C15,$O$18:$P$26,2,FALSE))","v":""},null,{"$f":"IF(ISBLANK(C15),\"\",IF(AND(C15=\"Custom\", E15<>0),E15,IF(AND(C15=\"Custom\",E15=0),\"\", VLOOKUP(C15,$O$18:$R$26,3,FALSE))))","v":""},{"$f":"IF(ISBLANK(C15),\"\",IF(AND(C15=\"Custom\", E15<>0),E15,IF(AND(C15=\"Custom\",E15=0),\"\", VLOOKUP(C15,$O$18:$R$26,4,FALSE))))","v":""},{"$f":"IF(ISBLANK($B$10), \"\", IF(ISBLANK(C15),\"\",IF(F15=\"\", \"\", ((F15/$F$16)*5)*1.15*$B$10)))","v":""},{"$f":"IF(ISBLANK($B$10), \"\", IF(ISBLANK(D15),\"\",IF(G15=\"\", \"\", ((G15/$G$16)*5)*1.15*$B$10)))","v":""}]
[null,null,null,null,null,{"$f":"SUM(F14:F15)","v":0},{"$f":"SUM(G14:G15)","v":0}]
[]
[null,null,null,null,"Total volumes:",null,null,{"$f":"IF(OR(ISBLANK(C14),ISBLANK(C15)),\"\",SUM(H14:H15))","v":""},{"$f":"IF(OR(ISBLANK(C14),ISBLANK(C15)),\"\",SUM(I14:I15))","v":""},null,null,null,null,null,"Panel","Size","Fwd Primers","Rev Primers","Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AML v2",127,129,130,"129, one repeated for REV"]
[null,null,null,null,"Effective panel size:",null,null,{"$f":"IF(OR(ISBLANK(C14),ISBLANK(C15)),\"\",SUM(IF(C14=\"Custom\", E14,D14), IF(C15=\"Custom\", E15,D15)))","v":""},null,null,null,null,null,null,"Myeloid",312,320,342,"320, 22 doubled for REV (some also at lower than 1x, no adjustment)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MRD AML v1",321,331,375,"331, 44 doubuled for REV "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MRD AML v2",323,338,382,"two added to v1, at ~3x and 4x concentration respectively"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MM",345,658,420,"339, one repeated, 29 doubled, 41 at 30% (no adjustment) plus VDJ panel "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wgCNV",500,514,514,"500, 14 doubled"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BCR VDJ",6,289,51,"16 REV with 51x total, 77 FWD with 289x total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom","Enter here -->"]