{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Readme","Chromium Connect Library Pool","Example Library Pool"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":12,"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":"Readme","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[36,1,36,11],[37,0,37,12],[38,1,38,11],[39,0,39,12],[31,0,31,12],[32,0,32,12],[33,1,33,11],[34,1,34,11],[35,1,35,11],[26,2,26,11],[27,2,27,11],[28,2,28,11],[29,2,29,11],[30,2,30,11],[21,2,21,11],[22,0,22,12],[23,0,23,12],[24,2,24,11],[25,2,25,11],[16,2,16,11],[17,2,17,11],[18,2,18,11],[19,2,19,11],[20,2,20,11],[12,1,12,2],[12,3,12,11],[13,0,13,12],[14,0,14,12],[15,2,15,11],[9,1,9,2],[9,3,9,11],[10,1,10,2],[10,3,10,11],[11,1,11,2],[11,3,11,11],[0,0,3,2],[0,3,0,8],[0,9,0,11],[0,12,3,12],[1,3,1,8],[1,10,1,11],[2,3,2,8],[2,10,2,11],[3,3,3,8],[3,9,3,11],[5,1,5,11],[6,0,6,12],[7,0,7,12],[8,1,8,2],[8,3,8,11]]}
[]
[null,null,null,"Chromium Connect",null,null,null,null,null,"Doc","CG000156"]
[null,null,null,"Pooling Worksheet ",null,null,null,null,null,"Rev","C"]
[]
["Scope"]
[null,"Use this spreadsheet to calculate the library dilutions and volumes required to assemble a final library pool for sequencing using component libraries generated from the Chromium Connect Instrument. \nSave and export data to a csv file using the \"8 Library Pool\" tab in this spreadsheet. If you have your own LIMS system, use CG000310 instead."]
[]
["Associated Documents"]
[null,"Refer to",null,"Description"]
[null,"CG000180",null,"Chromium Connect Instrument User Guide"]
[null,"CG000286",null,"Chromium Next GEM Automated Single Cell 3' Reagent Kits v3.1 User Guide"]
[null,"CG000384",null,"Chromium Next GEM Automated Single Cell 5' Reagent Kits v2 User Guide"]
[null,"CG000310",null,"ChromiumConnect_Pooling-8Libraries_InputSampleInfo_Template.csv"]
[]
["Required Information"]
[null,"1.","Library IDs"]
[null,"2.","Average Library Size (bp)"]
[null,"3.","Library Concentration (nM)"]
[null,"4.","Cells/sample"]
[null,"5.","Reads/cell"]
[null,"6.","Target Library Pool Concentration"]
[null,"7.","Target Library Pool Volume"]
[]
["Considerations"]
[null,"•","Enter the information above into cells highlighted in blue for each library in the \"Chromium Connect Library Pool\" tab. Enter the targeted concentration and volume of the final library pool. "]
[null,"•","The \"Example Library Pool\" tab has example data to demonstrate what final dilutions and volumes may look like."]
[null,"•","To ensure that volumes adhere to conditions mentioned at the top of the sheet, manually adjust the Dilution Factor for each library using whole integers (1-10)."]
[null,"•","Other values in red font may need adjustment to achieve final volumes that adhere to all conditions. "]
[null,"•","If final volumes are do not adhere to conditions, adjust Target Pool Concentration, Target Pool Volume, Dilution Factor, Cells/sample, or Reads/cell."]
[null,"•","Input values in green boxes onto the Chromium Connect touchscreen."]
[null,"•","To omit a sample from analysis, enter \"0\" in the Reads/cell column."]
[]
["Contact"]
[null,"support@10xgenomics.com"]
[null,"10x Genomics"]
[null,"6230 Stoneridge Mall Road"]
[null,"Pleasanton, CA 94588 USA"]
[]
[null,"© 2021 10X Genomics, Inc. FOR RESEARCH USE ONLY. NOT FOR USE IN DIAGNOSTIC PROCEDURES."]

{"sheet":"Chromium Connect Library Pool","index":1,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,7,2,10],[1,13,1,15],[2,12,2,15],[2,11,7,11],[22,5,33,15],[20,11,20,14],[21,11,21,14],[21,1,21,10],[7,1,7,6],[2,1,2,6],[3,8,3,10],[4,8,4,10],[5,8,5,10],[6,8,6,10],[7,8,7,10],[1,1,1,12],[34,1,34,15],[9,12,9,14],[20,7,20,8],[20,1,20,2],[20,4,20,6],[9,1,9,11],[8,1,8,15],[5,12,7,15],[22,1,22,4],[3,1,3,6],[4,1,4,6],[5,1,5,6],[6,1,6,6],[3,12,3,13],[4,12,4,13]]}
[null,"Chromium Connect Pooling Worksheet  |  10xgenomics.com"]
[null,"After entering library information below, click this button to autofill Library Pool tabs ----------------------------------------------------------------------------------"]
[null,"Conditions",null,null,null,null,null,"Legend"]
[null," •  Sample Transfer Volume must be between 3-20 µl",null,null,null,null,null,"Blue"," Fields where data must be entered manually",null,null,null,"Target Pool Conc =_",null,null,"nM"]
[null," •  Pool Diluent Volume cannot be negative",null,null,null,null,null,"Green"," Volumes to enter on Chromium Connect",null,null,null,"Target Pool Volume =_",null,null,"µl"]
[null," •  Target Pool Volume must be between 50-300 µl",null,null,null,null,null,"Red"," Cannot proceed without changing the value"]
[null," •  Dilution factors must be integers between 1-10",null,null,null,null,null,"Red Text"," Value may need adjustment"]
[null," •  Sample Transfer Volume for diluted samples cannot be above Total Dilution Volume",null,null,null,null,null,"Pink"," Changed from default"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Intermediate Dilution on Deck"]
[null,"Library ID","Average Library Size (bp)","Prorated Size","Library Concentration (nM)","Dilution Factor","Working  concentration (nM)","Cells/ Sample","Reads/Cell (enter \"0\" to omit sample)","Reads/\nSample","Fraction of Total Pool Reads","Individual Library Concentration (nM)","Library Dilution Volume (µl)","Diluent Dilution Volume (µl)","Total Volume (µl)","Final Transfer Volume (µl)"]
[null,null,null,{"$f":"C12*K12","v":{"$error":"#DIV/0!"}},null,1,{"$f":"E12/F12","v":0},null,null,{"$f":"H12*I12","v":0},{"$f":"J12/$J$21","v":{"$error":"#DIV/0!"}},{"$f":"K12*O$4","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($F12,$B$24:$E$34,2)","v":0},{"$f":"VLOOKUP($F12,$B$24:$E$34,3)","v":0},{"$f":"M12+N12","v":0},{"$f":"($O$5*L12)/G12","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$error":"#DIV/0!"},null,1,0,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},null,1,0,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},null,1,0,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},null,1,0,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},null,1,0,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},null,1,0,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"},null,1,0,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[]
[null,"Pro-rated size (bp) for__. \npool level quantification =_",null,{"$f":"SUM(D12:D19)","v":{"$error":"#DIV/0!"}},null,null,null,"Total Reads =_",null,{"$f":"SUM(J12:J19)","v":0},{"$f":"SUM(K12:K19)","v":{"$error":"#DIV/0!"}},"Total Sample Volume = ",null,null,null,{"$f":"SUM(P12:P19)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Pool Diluent Volume = ",null,null,null,{"$f":"O5-P21","v":{"$error":"#DIV/0!"}}]
[null,"Dilution Table - Do Not Modify"]
[null,"Dilution Factor","Sample Volume","Diluent Volume","Total Volume"]
[null,1,0,0,{"$f":"B25*C25","v":0}]
[null,2,10,{"$f":"E26-C26","v":10},20]
[null,3,7,14,21]
[null,4,5,15,20]
[null,5,5,20,25]
[null,6,5,25,30]
[null,7,5,30,35]
[null,8,5,35,40]
[null,9,5,40,45]
[null,10,5,45,50]

{"sheet":"Example Library Pool","index":2,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[20,4,20,6],[9,1,9,11],[7,1,7,6],[7,8,7,10],[5,12,7,15],[6,1,6,6],[6,8,6,10],[1,0,34,0],[1,16,34,16],[23,5,33,15],[34,1,34,15],[22,5,22,15],[21,1,21,10],[20,11,20,14],[21,11,21,14],[8,1,8,15],[9,12,9,14],[22,1,22,4],[20,1,20,2],[20,7,20,8],[3,11,7,11],[1,1,1,12],[1,13,1,15],[2,1,2,6],[2,7,2,10],[2,12,2,15],[3,1,3,6],[3,8,3,10],[3,12,3,13],[4,1,4,6],[4,8,4,10],[4,12,4,13],[5,1,5,6],[5,8,5,10]]}
[null,"Chromium Connect Pooling Worksheet  |  10xgenomics.com"]
[]
[null,"Conditions",null,null,null,null,null,"Legend"]
[null," •  Sample Transfer Volume must be between 3-20 µl",null,null,null,null,null,"Blue"," Fields where data must be entered manually",null,null,null,"Target Pool Conc =_",null,5,"nM"]
[null," •  Pool Diluent Volume cannot be negative",null,null,null,null,null,"Green"," Volumes to enter on Chromium Connect",null,null,null,"Target Pool Volume =_",null,100,"uL"]
[null," •  Target Pool Volume must be between 50-300 µl",null,null,null,null,null,"Red"," Cannot proceed without changing the value"]
[null," •  Dilution factors must be integers between 1-10",null,null,null,null,null,"Red Text"," Value may need adjustment"]
[null," •  Sample Transfer Volume for diluted samples cannot be above Total Dilution Volume",null,null,null,null,null,"Pink"," Changed from default"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Intermediate Dilution on Deck"]
[null,"Library ID","Average Library Size (bp)","Prorated Size","Library Concentration (nM)","Dilution Factor","Working  concentration (nM)","Cells/ Sample","Reads/Cell (enter \"0\" to omit sample)","Reads/\nSample","Fraction of Total Pool Reads","Individual Library Concentration (nM)","Library Dilution Volume (µl)","Diluent Dilution Volume (µl)","Total Volume (µl)","Final Transfer Volume (µl)"]
[null,"PHX309_1-1",428,{"$f":"C12*K12","v":53.5},15.189049998527603,1,{"$f":"E12/F12","v":15.189049998527603},5000,60000,{"$f":"H12*I12","v":300000000},{"$f":"J12/$J$21","v":0.125},{"$f":"K12*O$4","v":0.625},{"$f":"VLOOKUP($F12,$B$24:$E$34,2)","v":0},{"$f":"VLOOKUP($F12,$B$24:$E$34,3)","v":0},{"$f":"M12+N12","v":0},{"$f":"($O$5*L12)/G12","v":4.1148063905286127}]
[null,"PHX309_1-2",436,54.5,40,2,20,5000,60000,300000000,0.125,0.625,10,10,20,3.125]
[null,"PHX309_1-3",455,56.875,14.094775079193781,1,14.094775079193781,5000,60000,300000000,0.125,0.625,0,0,0,4.434267283360934]
[null,"PHX309_1-4",444,55.5,60,3,20,5000,60000,300000000,0.125,0.625,7,14,21,3.125]
[null,"PHX309_1-5",433,54.125,5,1,5,5000,60000,300000000,0.125,0.625,0,0,0,12.5]
[null,"PHX309_1-6",427,53.375,15.84859329194177,1,15.84859329194177,5000,60000,300000000,0.125,0.625,0,0,0,3.9435676623601776]
[null,"PHX309_1-7",429,53.625,4,1,4,5000,60000,300000000,0.125,0.625,0,0,0,15.625]
[null,"PHX309_1-8",428,53.5,14.803040138681059,1,14.803040138681059,5000,60000,300000000,0.125,0.625,0,0,0,4.2221056900794647]
[]
[null,"Pro-rated size (bp) for__.\npool level quantification =_",null,{"$f":"SUM(D12:D19)","v":435},null,null,null,"Total Reads =_",null,{"$f":"SUM(J12:J19)","v":2400000000},{"$f":"SUM(K12:K19)","v":1},"Total Sample Volume = ",null,null,null,{"$f":"SUM(P12:P19)","v":51.089747026329185}]
[null,null,null,null,null,null,null,null,null,null,null,"Pool Diluent Volume = ",null,null,null,{"$f":"O5-P21","v":48.910252973670815}]
[null,"Dilution Table - Do Not Modify"]
[null,"Dilution Factor","Sample Volume","Diluent Volume","Total Volume"]
[null,1,0,0,{"$f":"B25*C25","v":0}]
[null,2,10,{"$f":"E26-C26","v":10},20]
[null,3,7,14,21]
[null,4,5,15,20]
[null,5,5,20,25]
[null,6,5,25,30]
[null,7,5,30,35]
[null,8,5,35,40]
[null,9,5,40,45]
[null,10,5,45,50]