{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["SNP"],"not_rendered":{"macros":1,"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"SNP","index":0,"n_rows":58,"n_cols":12,"rows_kept":58,"merged":[[4,0,4,1],[8,2,8,5],[8,6,8,9],[9,2,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[15,2,15,6],[15,8,15,10],[21,1,21,10],[23,0,23,1],[27,2,27,5],[27,6,27,9],[27,10,27,11],[28,2,28,3],[28,4,28,5],[32,4,32,5],[35,7,35,11],[36,9,36,11],[37,9,37,11],[38,9,38,11],[43,2,43,5],[43,6,43,9],[43,10,43,11],[44,2,44,3],[44,4,44,5],[51,4,51,5],[54,7,54,11],[55,9,55,11],[56,9,56,11],[57,9,57,11]]}
["Species"]
[".plt Filename"]
["Date"]
[]
["SNP Preamp Protocol"]
[]
[{"$nulls":5},"# of  Primers",192]
[]
[null,"LSP+STA","Concentration",{"$nulls":3},"Volume"]
[null,null,"Stock",null,"Final",null,"Each Primer",null,"Total"]
[null,"Primer storage stock",100,"uM",{"$f":"0.2*10/5","v":0.4},"uM",{"$f":"E11*I13/C11","v":2.4},"uL",{"$f":"G7*G11","v":460.79999999999995},"uL"]
[null,"H2O or low TE",{"$nulls":6},{"$f":"I13-I11","v":139.20000000000005},"uL"]
[{"$nulls":7},"total",600,"uL"]
[]
[]
[null,null,"Reactions",{"$nulls":5},"Cycling"]
[null,"Number of Reactions",1,110,null,220,null,null,"95°","15 min"]
[null,"Qiagen 2X PCR MM (uL)",5,{"$f":"C18*$D$17","v":550},"uL",{"$f":"C18*$F$17","v":1100},"uL",null,"94°","30 s"]
[null,"Primers [0.2uM each/ reaction] (uL)",5,{"$f":"C19*$D$17","v":550},"uL",{"$f":"C19*$F$17","v":1100},"uL",null,"57°","90 s","14 cycles"]
[null,"Total (uL)",{"$f":"SUM(C18:C19)","v":10},{"$f":"SUM(D18:D19)","v":1100},"uL",{"$f":"SUM(F18:F19)","v":2200},"uL",null,"72°","90 s"]
[{"$nulls":8},"72°","10 min"]
[null,"Note: For EP1 dilute PreAmp 1:20, for 7900 dilute PreAmp 1:600"]
[]
["Assay Loading Protocol"]
[null,"Volume per inlet",5,"uL",null,"# of chips",1]
[{"$nulls":5},"# of assays",110]
[]
[null,null,"Concentration",{"$nulls":3},"Volume for 1 well",{"$nulls":3},"Assay Loading Mix"]
[null,null,"Stock",null,"Final",null,1,"chip",{"$f":"G25","v":1},"chips",{"$f":"G26","v":110},"assays"]
[null,"Assay primer Mix",40,"x",8,"x",{"$f":"(E30*$C$25)/C30","v":{"v":1,"d":"1.00"}},"uL",{"$f":"G30*$G$25","v":{"v":1,"d":"1.00"}},"uL"]
[null,"2X Assay Loading Reagent",2,"x",1,"x",{"$f":"(E31*$C$25)/C31","v":{"v":2.5,"d":"2.50"}},"uL",{"$f":"G31*$G$25","v":{"v":2.5,"d":"2.50"}},"uL",{"$f":"I31*($G$26)","v":{"v":275,"d":"275.00"}},"uL"]
[null,"dH2O","N/A",null,"N/A",null,{"$f":"$C$25-SUM(G30:G31)","v":{"v":1.5,"d":"1.50"}},"uL",{"$f":"G32*$G$25","v":{"v":1.5,"d":"1.50"}},"uL",{"$f":"I32*($G$26)","v":{"v":165,"d":"165.00"}},"uL"]
[{"$nulls":4},"Total",null,{"$f":"SUM(G30:G32)","v":{"v":5,"d":"5.00"}},"uL",{"$f":"SUM(I30:I32)","v":{"v":5,"d":"5.00"}},"uL",{"$f":"SUM(K31:K32)","v":{"v":440,"d":"440.00"}},"uL"]
[{"$nulls":10},{"$f":"K33/1000","v":0.44},"mL"]
[]
[{"$nulls":7},"Assay Plate Loading"]
[{"$nulls":8},{"$f":"SUM(I31:I32)","v":{"v":4,"d":"4.00"}},"uL Assay Loading Mix/well"]
[{"$nulls":7},"+",{"$f":"I30","v":{"v":1,"d":"1.00"}},"uL of each assay/well"]
[{"$nulls":8},{"$f":"SUM(I37:I38)","v":{"v":5,"d":"5.00"}},"uL total volume"]
[null,"*At this point, prime chip. Takes ~18 min."]
["Sample Loading Protocol","Volume per inlet",6,"uL",null,"# of chips",1]
[null,null,"  ",null,null,"# of samples",110]
[]
[null,null,"Concentration",{"$nulls":3},"Volume",{"$nulls":3},"Sample Loading Mix"]
[null,null,"Stock",null,"Final",null,1,"chip",{"$f":"G42","v":110},"samples",{"$f":"G41","v":1},"chips"]
[null,"Biotium 2X Fast Probe MM",2,"x",1,"x",{"$f":"(E46*$C$41)/C46","v":{"v":3,"d":"3.000"}},"uL",{"$f":"G46*$G$42","v":{"v":330,"d":"330.00"}},"uL",{"$f":"I46*($G$41)","v":{"v":330,"d":"330.00"}},"uL"]
[null,"20X SNP Type Sample Loading Reagent",20,"x",1,"x",{"$f":"(E47*$C$41)/C47","v":{"v":0.3,"d":"0.300"}},"uL",{"$f":"G47*$G$42","v":{"v":33,"d":"33.00"}},"uL",{"$f":"I47*($G$41)","v":{"v":33,"d":"33.00"}},"uL"]
[null,"60X SNP Type Reagent",60,"x",1,"x",{"$f":"(E48*$C$41)/C48","v":{"v":0.1,"d":"0.100"}},"uL",{"$f":"G48*$G$42","v":{"v":11,"d":"11.00"}},"uL",{"$f":"I48*($G$41)","v":{"v":11,"d":"11.00"}},"uL"]
[null,"diH2O",50,"x",0.53,"x",{"$f":"(E49*$C$41)/C49","v":{"v":0.0636,"d":"0.064"}},"uL",{"$f":"G49*$G$42","v":{"v":6.996,"d":"7.00"}},"uL",{"$f":"I49*($G$41)","v":{"v":6.996,"d":"7.00"}},"uL"]
[null,"ROX Reference Dye (50X)",50,"x",0.3,"x",{"$f":"(E50*$C$41)/C50","v":0.036},"uL",{"$f":"G50*$G$42","v":{"v":3.9599999999999995,"d":"3.96"}},"uL",{"$f":"I50*($G$41)","v":{"v":3.9599999999999995,"d":"3.96"}},"uL"]
[null,"DNA","N/A",null,"N/A",null,{"$f":"C41-SUM(G46:G50)","v":{"v":2.5004,"d":"2.50"}},"uL"]
[{"$nulls":4},"Total",null,{"$f":"SUM(G46:G51)","v":{"v":6,"d":"6.00"}},"uL",{"$f":"SUM(I46:I50)","v":{"v":384.95599999999996,"d":"384.96"}},"uL",{"$f":"SUM(K46:K50)","v":{"v":384.95599999999996,"d":"384.96"}},"uL"]
[{"$nulls":10},{"$f":"K52/1000","v":{"v":0.38495599999999996,"d":"0.38"}},"mL"]
[]
[{"$nulls":7},"Chip Loading"]
[{"$nulls":8},{"$f":"SUM(G46:G50)","v":{"v":3.4996,"d":"3.50"}},"uL Sample Loading Mix/well"]
[{"$nulls":7},"+",{"$f":"G51","v":{"v":2.5004,"d":"2.50"}},"uL of each sample"]
[{"$nulls":8},{"$f":"SUM(I56:I57)","v":{"v":6,"d":"6.00"}},"uL total volume"]