{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Pooling"],"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":"Pooling","index":0,"n_rows":94,"n_cols":13,"rows_kept":94,"cut":false,"hidden":false,"merged":[[9,7,9,8]]}
["Directions: Enter information for each AOC and follow the recommended pooling guidelines. ",null,null,null,null,null,null,null,null,null,"RevC"]
["Information for columns C and D can be provided by BioLegend upon request.",null,null,null,null,null,null,null,null,null,"2024-12-18"]
["Do not enter anything in cells that are red. Blue columns indicate pipetting steps."]
["When the required pooling volume is < 1 uL, pipette from a 1:5 dilution as indicated in Column I."]
["If adding AOCs to a pre-titrated cocktail, resuspend the cocktail using the final AOC pool instead of CSB in step 1.25."]
["If not adding AOCs to a pre-titrated cocktail, pool as described and proceed from step 1.29."]
[]
[]
[]
[]
["AOC","Titration range available?","Max Test Conc. (μg/test)","Test volume (μL)                  (100 uL for TotalSeq-D tests, 50 uL for TotalSeq-A/B/C)","Stock Conc. (μg/μL)","Max Conc. (μg/μL)","Volume needed (μL)","Volume from stock (μL)","Volume from I:5 dilution (μL)           (First combine 1 μL AOC with 4 μL CSB)","Total volume AOCs (μL)","Volume CSB  (μL)"]
[null,null,null,null,0.5,{"$f":"IFERROR(100/D12*C12,\"\")","v":""},{"$f":"IF(ISBLANK(B12), \"\", IFERROR(IF(B12=\"Yes\",F12/E12,1),\"\"))","v":""},{"$f":"IF(G12>0.99,G12,\"\")","v":""},{"$f":"IFERROR(IF((1/G12)>1,IF((10*F12/1)=0,\"\",10*F12/1),\"\"),\"\")","v":""},{"$f":"SUM(H12:I93)","v":0},{"$f":"IF(J12<60, 60-J12,0)","v":60},{"$f":"IF($K$12=0, \"Note: If total pooled volume exceedes 60μL, there is no need to add any CSB.\", \"\")","v":""},"Constants"]
[null,null,null,null,0.5,{"$f":"IFERROR(100/D13*C13,\"\")","v":""},"",{"$f":"IF(G13>0.99,G13,\"\")","v":""},{"$f":"IFERROR(IF((1/G13)>1,IF((10*F13/1)=0,\"\",10*F13/1),\"\"),\"\")","v":""},null,null,{"$f":"IF($K$12=0, \"Vortex and quick spin the pool and use 60 uL for subsequent steps.\", \"\")","v":""}]
[null,null,null,null,0.5,"",{"$f":"IF(ISBLANK(B14), \"\", IFERROR(IF(B14=\"Yes\",F14/E14,1),\"\"))","v":""},{"$f":"IF(G14>0.99,G14,\"\")","v":""},"",null,null,null,"Yes"]
[null,null,null,null,0.5,"","","","",null,null,null,"No"]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","","",null,null,null,2]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"",{"$f":"IF(ISBLANK(B76), \"\", IFERROR(IF(B76=\"Yes\",F76/E76,1),\"\"))","v":""},"",""]
[null,null,null,null,0.5,{"$f":"IFERROR(100/D77*C77,\"\")","v":""},"","",{"$f":"IFERROR(IF((1/G77)>1,IF((10*F77/1)=0,\"\",10*F77/1),\"\"),\"\")","v":""}]
[null,null,null,null,0.5,"","",{"$f":"IF(G78>0.99,G78,\"\")","v":""},""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,0.5,"","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF((1/G94)>1,IF((10*F94/5)=0,\"\",10*F94/5),\"NA\"),\"\")","v":""}]