{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["24x1 Design","WorkSheet 12x2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"24x1 Design","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,3,6],[1,0,1,6],[11,1,11,5]]}
["24 Palladium Precatalyst Screen"]
["24  x 1  Design"]
["                                         1. Enter molecular weights in green boxes (some are preloaded) 2. adjust ratios in yellow boxes 3. use only one base type in pink boxes"]
[]
[null,null,"Name","MW","umol","rxn conc"]
[null,null,"coupling partner 1",200,10,"0.1 M"]
[null,null,"coupling partner 2",100,15]
[null,null,"Solid Base","MW","Density","Equivalents"]
[null,"Solid Base: Choose base from dropdown -select none if liquid base","None",{"$f":"VLOOKUP(C9,'WorkSheet 12x2'!E27:G31,2,FALSE)","v":0},{"$f":"VLOOKUP(D9,'WorkSheet 12x2'!F27:H31,2,FALSE)","v":0},2]
[null,null,"Liquid Base",null,"uL per RXN vial (base solution)","neat base"]
[null,"Solution of Base: Select Molarity (0 if using solid)",0,null,{"$f":"IF(C11=0, \"None\", F9/C11*10)","v":"None"},"if using neat base, add 5 uL DIRECT to each reaction vial"]
[null,"                  make one vial (1) of stock solution to fill the entire plate"]
[null,null,"                                                   Add liquid bases (neat or solution) DIRECTLY to each reaction vial after all substrate solution has been stocked-do not add it to the substrate solution"]
[null,"partner 1 (mg)","partner 2 (mg)","Base","Base Amount (mg or uL) ","Solvent","Solvent Amount (uL)"]
["Vial One",{"$f":"('WorkSheet 12x2'!D20)","v":57.6},{"$f":"('WorkSheet 12x2'!$D$21)","v":43.2},{"$f":"C9","v":"None"},{"$f":"'WorkSheet 12x2'!C28","v":0},"Dioxane",{"$f":"'WorkSheet 12x2'!A34","v":2779.2}]
[]
[]
["Supplies to load Inertion Box: ","ampules of solvent","substrates/bases weighed in vials"]
["Equipment Needed:","2 syringes with needle ","pipette with tips"]
[]
["1. Place reaction block and lid in inertion box, \"purge\" 5 minutes. Leave heavy flow of gas on"]
["2. Weigh substrates and solid bases into substrate vial; omit neat liquid or base solution  ADD STIRBAR!"]
["3. Load inertion box with sealed catalysts, ampules, and substrate vial.\"purge\" 5 minutes. Leave heavy flow of gas on. ",null,null,null,null,"print as pdf to append to ELN"]
["4. Make stock solutions according to recipe above. "]
["5. Add 100 uL of stock solution to each vial"]
["6. Add liquid bases (solutions or neat) if using "]
["6. Seal block and heat"]
[]
[]
[]
[null,1,2,3,4,5,6]
["Vial 1: Row A","AdBrettPhos Pd G3","APhos Pd G3","rac-BINAP-Pd-G3","BrettPhos Pd G4","cataCXium® A Pd G3","CPhos-Pd-G3"]
["Vial 1: Row B","CyJohnPhos Pd G3","DavePhos-Pd-G3","DPPF Pd G3","JackiePhos Pd G3","JosiPhos-SL-J009-1-Pd-G3 ","meCgPPh Pd G3"]
["Vial 1: Row C","Me4tBuXPhos Pd G3","MorDalphos Pd G3","P(Cy3) Pd G3","P(t-Bu)3 Pd G2","Pd-PEPPSI™-IPent ","RuPhos Pd G4"]
["Vial 1: Row D","SPhos Pd G4","tBuBrettPhos Pd G3","tBuXPhos Pd G3","XantPhos Pd G3","XPhos Pd G4","PdCl2(PPh3)2"]

{"sheet":"WorkSheet 12x2","index":1,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":true,"merged":[[0,0,0,6],[2,0,2,6],[4,0,6,0],[7,0,9,0],[10,0,12,0],[24,4,24,6],[16,0,16,6],[19,0,20,0],[21,0,22,0],[13,0,15,0]]}
["24 Catalysts x 1 Base/Solvent"]
["1.) The 24 well plate has 24 predosed catalysts arranged below:"]
["24 Well Plate"]
[null,1,2,3,4,5,6]
["A"]
[null,"AdBrettPhos Pd G3","APhos Pd G3","rac-BINAP-Pd-G3","BrettPhos Pd G4","cataCXium® A Pd G3","CPhos-Pd-G3"]
[]
["B"]
[null,"CyJohnPhos Pd G3","DavePhos-Pd-G3","DPPF Pd G3","JackiePhos Pd G3","JosiPhos-SL-J009-1-Pd-G3 ","meCgPPh Pd G3"]
[]
["C"]
[null,"Me4tBuXPhos Pd G3","MorDalphos Pd G3","P(Cy3) Pd G3","P(t-Bu)3 Pd G2","Pd-PEPPSI™-IPent ","RuPhos Pd G4"]
[]
["D"]
[null,"SPhos Pd G4","tBuBrettPhos Pd G3","tBuXPhos Pd G3","XantPhos Pd G3","XPhos Pd G4","PdCl2(PPh3)2"]
[]
[]
["Substrate Calculator"]
["Vial","Substrate","Name","mg"]
[1,1,{"$f":"'24x1 Design'!$C$6","v":"coupling partner 1"},{"$f":"'24x1 Design'!E$6*'24x1 Design'!D$6*1.2*24/1000","v":57.6}]
[null,2,{"$f":"'24x1 Design'!$C$7","v":"coupling partner 2"},{"$f":"'24x1 Design'!E$7*'24x1 Design'!D7*1.2*24/1000","v":43.2}]
[]
[]
[]
["Base Calculator",null,null,null,"DropDown Lists"]
[null,null,null,null,"Bases","MW","Density"]
["Equivalents Base","umol base","Amount/ Stock Solution",null,"Cs2CO3",325.82,1]
[{"$f":"'24x1 Design'!F9","v":2},{"$f":"A28*'24x1 Design'!E6","v":20},{"$f":"('WorkSheet 12x2'!B28*'24x1 Design'!D9*24*1.2)/1000","v":0},null,"K3PO4",212.27,1]
[null,null,null,null,"K2CO3",138.19999999999999,1]
[null,null,null,null,"Et3N",101.19,0.72]
[null,null,null,null,"None",0,0]
["Solvent Calculator"]
[null,null,null,null,"Molarity","Dose uL"]
[{"$f":"2400*1.2-(D20+D21+'24x1 Design'!E15)","v":2779.2},null,null,null,1,30]
[null,null,null,null,1.5,20]
[null,null,null,null,2,15]
[null,null,null,null,0,0]