{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet3","Sheet2","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":10,"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":"Sheet3","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[[10,1,10,2],[11,1,11,2],[13,1,13,2],[14,1,14,2],[12,1,12,2],[0,3,0,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[4,2,4,3],[4,4,4,5],[9,1,9,2],[5,0,5,5],[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4]]}
[null,null,null,null,null,null,"Quotation"]
[]
[]
[]
[]
[]
[]
[]
[]
["Service","Description",null,"Qty"]
["QC",{"$f":"IF(Sheet2!K1=TRUE,\"Initial QC \"&Sheet1!C23 &\" - Sample\",IF(Sheet2!K2,IF(Sheet1!C25=\"NO\",\"Initial QC - library\",\"Not Applicable\"),\"Not Applicable\"))","v":"Not Applicable"},null,{"$f":"IF(B11=\"Not Applicable\",0,IF(Sheet1!C23=\"Library\",Sheet1!I18,Sheet1!C24))","v":0},null,null,{"$f":"IF(Sheet1!D37=\"Sample\",\"Variant Calling & Annotation - Sample\",IF(Sheet1!D37=\"Tumor/Normal Pair\",\"Somatic Mutation Calling & Annotation - Tumor/Normal Pair\"))","v":false}]
["Library Preparation",{"$f":"IF(Sheet1!C23=\"Library\",\"Pre-made\",IF(Sheet2!K1=FALSE,\"Not Applicable\",Sheet1!B29))","v":"Not Applicable"},null,{"$f":"IF(Sheet2!K1=FALSE,0,Sheet1!C24)","v":0}]
["QC",{"$f":"IF(Sheet1!A26=\"\",\"Not Applicable\",IF(Sheet2!K1=FALSE,\"Pre- made library QC - Pool\",IF(Sheet1!C24>15.5,\"Initial QC & Pooling with MiSeq- Library\",\"Real-time PCR Library Quantification - Library\")))","v":"Not Applicable"},null,{"$f":"IF(Sheet1!A26=\"\",0,Sheet1!D26)","v":0}]
["Sequencing",{"$f":"IF(Sheet2!K2=FALSE,\"Not Applicable\",IF(Sheet1!B33=\"Not Sure\",\"\",IF(Sheet1!B33=\"\",\"\",Sheet1!B33)))","v":"Not Applicable"},null,{"$f":"IF(B14=\"Not Applicable\",0,Sheet1!E34)","v":0}]
["Data Analysis",{"$f":"SUBSTITUTE(H15,\" to \",\"-\")","v":"Not Applicable"},null,{"$f":"IF(Sheet1!D36=\"Yes\",Sheet1!C24,0)","v":0},null,null,{"$f":"IF(Sheet1!D36=\"No\",\"\",Sheet1!D36)","v":""},{"$f":"SUBSTITUTE(IF(G15=\"\",\"Not Applicable\",IF(VLOOKUP(Sheet1!B29,Sheet2!C:E,3,FALSE)=\"\",IF(Sheet1!A37=\"\",Sheet1!B29,IF(Sheet1!D36=\"YES\",LEFT(Sheet1!B29,SEARCH(\" - \",Sheet1!B29,1))&\"- \"&G11)),VLOOKUP(Sheet1!B29,Sheet2!C:E,3,FALSE))),\":\",\" -\")","v":"Not Applicable"}]

{"sheet":"Sheet2","index":1,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Sequencing","DataAnalysis","Library_Preparation",null,"Data_Analysis","SampleMaterial","Please_provide_the_Sample_Type_for_Analysis","-",null,null,false,null,"Quote request-chip2.xlsm"]
["Not Sure","Yes","Whole Genome Sequencing - Sample","Please provide the Sample Type for Analysis",null,"DNA","Tumor/Normal Pair",null,"Whole Genome Sequencing: Variant Calling & Annotation - Sample",null,false]
["HiSeq 4000 50 SR - Whole Flow Cell","No","Whole Genome Sequencing Human - Sample","Please provide the Sample Type for Analysis",null,"RNA","Sample",null,"Whole Genome Sequencing: Somatic Mutation Calling & Annotation - Tumor/Normal Pair",null,false]
["HiSeq 4000 75 PE",null,"Whole Exome Capture - Exons - Sample","Please provide the Sample Type for Analysis",null,"Cells",null,null,"Whole Exome Capture: Variant Calling & Annotation - Sample"]
["HiSeq 4000 100 PE - Whole Flow Cell",null,"Targeted Capture Agilent (Probes provided by coll.) - Sample","Please provide the Sample Type for Analysis",null,"Library",null,null,"Whole Exome Capture: Somatic Mutation Calling & Annotation - Tumor/Normal Pair"]
["HiSeq 4000 150 PE",null,"Whole Exome Capture - Exons + UTR - Sample","Please provide the Sample Type for Analysis",null,null,null,null,"Custom Target Capture: 1 to 499kb - Variant Calling & Annotation - Sample"]
["Next Seq 75 SR",null,"Whole Exome Capture - Exons + Custom Targets - Sample","Please provide the Sample Type for Analysis",null,null,null,null,"Custom Target Capture - 1-499kb - Somatic Mutation Calling & Annotation - Tumor/Normal Pair"]
["Next Seq 75 PE",null,"Custom Target Capture: 1 to 499kb - Sample","Please provide the Sample Type for Analysis",null,null,null,null,"Custom Target Capture - 0.5-2.9Mb - Variant Calling & Annotation - Sample"]
["Next Seq 150 PE",null,"Custom Target Capture: 0.5 to 2.9Mb - Sample","Please provide the Sample Type for Analysis",null,null,null,null,"Custom Target Capture - 0.5-2.9Mb - Somatic Mutation Calling & Annotation - Tumor/Normal Pair"]
["Next Seq 75 PE MID",null,"Custom Target Capture: 3 to 5.9Mb - Sample","Please provide the Sample Type for Analysis",null,null,null,null,"Custom Target Capture - 3-5.9Mb - Variant Calling & Annotation - Sample"]
["Next Seq 150 PE MID",null,"Custom Target Capture: 6 to 11.9Mb - Sample","Please provide the Sample Type for Analysis",null,null,null,null,"Custom Target Capture - 3-5.9Mb - Somatic Muation Calling & Annotation - Tumor/Normal Pair"]
["Miseq v2 50 SR",null,"Custom Target Capture: 12 to 24Mb - Sample","Please provide the Sample Type for Analysis",null,null,null,null,"Custom Target Capture - 6-11.9Mb - Variant Calling & Annotation - Sample"]
["Miseq v2 150 PE",null,"Amplicon Sequencing - Illumina TruSeq Custom Amplicon",null,"Amplicon Sequencing - Variant Calling & Annotation - Sample ",null,null,null,"Custom Target Capture - 6-11.9Mb - Somatic Mutation Calling & Annotation - Tumor/Normal Pair"]
["Miseq v2 250 PE",null,"Methylation Profiling - MBD-seq - Sample",null,"Methylation Profiling - MBD-seq - Differential Methylation Analysis & Annotation- Sample",null,null,null,"Custom Target Capture - 12-24Mb - Variant Calling & Annotation - Sample"]
["Miseq v2 150 PE micro",null,"Methylation Profiling - MeDIP-seq - Sample",null,"Methylation Profiling - MeDIP-seq - Differential Methylation Analysis & Annotation - Sample",null,null,null,"Custom Target Capture - 12-24Mb - Somatic Mutation Calling & Annotation - Tumor/Normal Pair"]
["Miseq v2 150 PE nano",null,"Methylation Profiling - RRBS-seq - Sample",null,"Methylation Profiling - RRBS-seq - Differential Methylation Analysis & Annotation - Sample",null,null,null,"RNA Sequencing - mRNA - Differential Expression Analysis & Annotation - Sample"]
["Miseq v2 250 PE nano",null,"Methylation Profiling - Whole Genome Bisulfite Sequencing - Sample","Please provide the Sample Type for Analysis",null,null,null,null,"RNA Sequencing - Total RNA - Differential Expression Analysis & Annotation - Sample"]
["Miseq v3 75 PE",null,"ChIP Sequencing - Sample",null,"ChIP Sequencing - Peak Calling - Sample",null,null,null,"RNA Sequencing - Ribosome Profiling - Differential Expression Analysis & Annotation - Sample"]
["Miseq v3 300 PE",null,"Metagenomic Profiling - 16s rRNA sequencing - Sample",null,"Metagenomic Profiling - 16s rRNA Sequencing - Sample",null,null,null,"RNA Sequencing - Small RNA - Differential Expression Analysis & Annotation - Sample"]
[null,null,"Custom Target Capture - TruSight Cardio - Sample",null,"N/A",null,null,null,"RNA Sequencing - hsRNA - Quantification & Annotation - Sample"]
[null,null,"ATAC Seq",null,"ChIP Sequencing - Peak Calling - Sample",null,null,null,"RNA Sequencing - 3' end RNA-seq"]
[null,null,"Other-Specify in comment box",null,"RNA Sequencing - mRNA - Differential Expression Analysis & Annotation - Sample",null,null,null,"Amplicon Sequencing - Variant Calling & Annotation - Sample "]
[null,null,"Automated mRNA library prep",null,"RNA Sequencing - mRNA - Differential Expression Analysis & Annotation - Sample",null,null,null,"Methylation Profiling - MBD-seq - Differential Methylation Analysis & Annotation- Sample"]
[null,null,"RNA Sequencing - mRNA stranded - Sample",null,"RNA Sequencing - Total RNA - Differential Expression Analysis & Annotation - Sample",null,null,null,"Methylation Profiling - MeDIP-seq - Differential Methylation Analysis & Annotation - Sample"]
[null,null,"RNA Sequencing - Total RNA with rRNA depletion - Sample",null,"RNA Sequencing - Ribosome Profiling - Differential Expression Analysis & Annotation - Sample",null,null,null,"Methylation Profiling - RRBS-seq - Differential Methylation Analysis & Annotation - Sample"]
[null,null,"RNA Sequencing - Ribosome Profiling - Sample",null,"RNA Sequencing - Small RNA - Differential Expression Analysis & Annotation - Sample",null,null,null,"ChIP Sequencing - Peak Calling - Sample"]
[null,null,"RNA Sequencing - Small RNA - Sample",null,"RNA Sequencing - hsRNA - Quantification & Annotation - Sample",null,null,null,"Metagenomic Profiling - 16s rRNA Sequencing - Sample"]
[null,null,"RNA Sequencing - Low Input with Ribodepletion ",null,"RNA Sequencing - Total RNA - Differential Expression Analysis & Annotation - Sample",null,null,null,"Exogenous Sequence Identification - Sample"]
[null,null,"RNA Sequencing - Total RNA with Globin depletion",null,"Please request a meeting to discuss your needs"]
[null,null,"RNA Sequencing - 3' end RNA-seq",null,"Please request a meeting to discuss your needs"]
[null,null,"Single Cell -3' RNAseq- Sample"]
[null,null,"Other-Specify in comment box"]

{"sheet":"Sheet1","index":2,"n_rows":46,"n_cols":20,"rows_kept":46,"cut":false,"hidden":false,"merged":[[34,0,34,5],[33,0,33,3],[24,0,24,1],[28,1,28,5],[32,1,32,3],[25,0,25,2],[45,0,45,5],[44,0,44,5],[36,0,36,2],[36,3,36,4],[35,0,35,2],[39,0,43,5],[38,0,38,5],[22,0,22,1],[0,4,0,5],[5,0,6,5],[12,3,12,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[13,2,13,3],[13,4,13,5],[18,0,18,5],[19,0,19,5],[21,0,21,5],[15,0,15,5],[16,2,16,3],[23,9,24,11],[23,12,24,12],[23,19,24,19],[23,0,23,1],[30,0,30,5],[26,0,26,5],[21,7,21,19],[22,7,22,19],[20,7,20,19],[45,7,46,19],[23,7,24,7],[23,8,24,8],[23,13,24,15],[23,16,24,18],[42,7,43,19],[34,8,38,8],[34,7,41,7],[29,8,31,8],[25,8,28,8],[25,7,28,7],[29,7,33,7],[32,8,33,8]]}
[null,null,null,null,"Quote Request"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A37=\"\",\"Empty\",A37)","v":"Empty"}]
["Imperial BRC Genomics Facility"]
["Integrated support for translational next-generation sequencing projects"]
[]
["Please send the completed form to igf@imperial.ac.uk"]
[]
[]
["Customer Details"]
["Principle Investigator*:",null,"Main Contact:"]
["Institution:",null,"Email:"]
["Department:",null,"Phone:"]
["Source of Funding:",null,"Grant Code*:"]
["Co-Investigator(s):",null,"Ethical Approval Ref. No*:"]
[null,null,null,null,null,null,null,null,null,null,"Library Preparation"]
["Requested Service",null,null,null,null,null,null,null,null,null,"Sequencing"]
["Library Preparation","Sequencing","Analysis",null,null,null,null,null,null,null,"Analysis"]
[null,null,null,null,null,null,null,null,null,null,"List for Application",{"$f":"IF(Sheet2!K1=TRUE,C23,\"Library\")","v":"Library"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(Sheet2!K2=TRUE,Sheet2!K3=TRUE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(Sheet2!K1=FALSE,Sheet2!K2=FALSE,Sheet2!K2=FALSE)","v":true}]
[null,null,null,null,null,null,null,"Useful Links to sequence coverage recommendations"]
["Sample Information ( whether samples to be prepped or pre-prepared libraries)",null,null,null,null,null,null,"Recommended number of reads per application"]
[{"$f":"IF(Sheet2!K1=FALSE,\"\",\"Sample material*\")","v":""},null,null,null,null,null,null,"Illumina Coverage Support"]
[{"$f":"IF(Sheet2!K1=TRUE,\"Number of samples*\",IF(Sheet2!K2=TRUE,\"Number of libraries*\",IF(Sheet2!K3=TRUE,\"Number of samples*\",\"\")))","v":""},null,null,null,null,null,null,"System","Mode","Read Length",null,null,"Chemistry","Fragments per Lane*",null,null,"Gb per Lane*",null,null,"Lanes per Flowcell"]
[{"$f":"IF(A24=\"Number of Libraries*\",\"Are the libraries pooled?*\",\"\")","v":""}]
[{"$f":"IF(Sheet2!K1=TRUE,\"Number of Pools to be prepared by IGF*\",IF(A24=\"\",\"\",IF(A24=\"Number of Libraries*\",IF(C25=\"YES\",\"Number of Pools submitted*\",IF(C25=\"NO\",\"Number of Pools to be prepared by IGF*\",\"Number of Pools to be prepared by IGF*\")),\"\")))","v":""},null,null,null,null,null,null,"HiSeq 4000","Standard",1,"x","50**",null,270,"-",312,13.5,"-",15.6,8]
[{"$f":"IF(Sheet2!K1=TRUE,\"Application\",IF(Sheet2!K3=TRUE,\"Application\",\"\"))","v":""},null,null,null,null,null,null,null,null,2,"x",75,null,270,"-",312,40.5,"-",46.800000000000004,8]
[null,null,null,null,null,null,null,null,null,2,"x","100**",null,270,"-",312,54,"-",62.4,8]
[{"$f":"IF(Sheet2!K1=TRUE,\"Library Preparation*\",IF(Sheet2!K3=TRUE,\"Library Preparation*\",\"\"))","v":""},null,null,null,null,null,null,null,null,2,"x",150,null,270,"-",312,81,"-",93.600000000000009,8]
[null,null,null,null,null,null,null,"NextSeq500","Hi Output",1,"x",75,null,333,"-",400,24.975000000000001,"-",30,"1¥"]
[{"$f":"IF(Sheet2!K2=TRUE,\"Sequencing\",\"\")","v":""},null,null,null,null,null,null,null,null,2,"x",75,null,333,"-",400,49.95,"-",60,"1¥"]
[null,null,null,null,null,null,null,null,null,2,"x",150,null,333,"-",400,99.9,"-",120,"1¥"]
[{"$f":"IF(Sheet2!K2=FALSE,\"\",\"Sequencing*\")","v":""},null,null,null,null,null,null,null,"Mid Output",2,"x",75,null,108,"-",130,16.2,"-",19.5,"1¥"]
[{"$f":"IF(Sheet2!K2=FALSE,\"\",IF(B33=\"Not Sure\",\"Provide number of reads or Gb per sample required in the 'Additional Information' box below*\",IF(ISNUMBER(SEARCH(\"Flow Cell\",B33)),\"Number of flowcells*\",\"Number of Lanes*\")))","v":""},null,null,null,null,null,null,null,null,2,"x",150,null,108,"-",130,32.4,"-",39,"1¥"]
[{"$f":"IF(Sheet2!K3=TRUE,\"Analysis\",\"\")","v":""},null,null,null,null,null,null,"MiSeq","Standard",1,"x",50,"v2",12,"-",15,0.6,"-",0.75,1]
[{"$f":"IF(ISNA(IF(Sheet2!K3=FALSE,\"\",IF(LEN(A37)>1,\"\",Sheet3!B15))),\"\",IF(Sheet2!K3=FALSE,\"\",IF(LEN(A37)>1,\"\",Sheet3!B15)))","v":""},null,null,{"$f":"IF(Sheet2!K3=TRUE,\"Yes\",\"No\")","v":"No"},null,null,null,null,null,2,"x",75,"v3",22,"-",25,3.3000000000000003,"-",3.75,1]
[{"$f":"IF(Sheet2!K3=FALSE,\"\",IF(B29=\"\",\"\",IF(VLOOKUP(B29,Sheet2!C:D,2,FALSE)=\"\",\"\",VLOOKUP(B29,Sheet2!C:D,2,FALSE)&\"*\")))","v":""},null,null,null,null,null,null,null,null,2,"x",150,"v2",12,"-",15,3.6,"-",4.5,1]
[null,null,null,null,null,null,null,null,null,2,"x",250,"v2",12,"-",15,6,"-",7.5,1]
["Additional Information",null,null,null,null,null,null,null,null,2,"x",300,"v3",22,"-",25,13.200000000000001,"-",15,1]
[null,null,null,null,null,null,null,null,"Micro",2,"x",150,"v2",3,"-",4,{"$f":"J40*L40*N40*10^-3","v":0.9},null,{"$f":"J40*L40*P40*10^-3","v":1.2},1]
[null,null,null,null,null,null,null,null,"Nano",2,"x",150,"v2",0.8,"-",1,0.24,null,0.3,1]
[null,null,null,null,null,null,null,null,null,2,"x",250,"v2",0.8,null,1,0.4,null,0.5,1]
[null,null,null,null,null,null,null,"*  Based on performance specification provided by the manufacturer. Output may vary depending on sample quality, cluster density and other experimental factors."]
[]
["Imperial College London, 4th Floor  Commonwealth Building, Du Cane Road, London, W12 0NN, UK",null,null,null,null,null,null,"** Only available for full flow cells"]
["  Phone +44 (0)20 3313 4766 - Email igf@imperial.ac.uk",null,null,null,null,null,null,"¥ NextSeq flowcells have 4 lanes but only one pool can be loaded per flowcells, therefore we consider NextSeq flowcells as having only one lane"]