{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":15,"n_cols":6,"rows_kept":15}
[]
["Item","Source","Cost (each)","Quantity","Total","Notes"]
["4 Skink-specific PCR primers with 3' universal overhang","Integrated DNA Technologies",90,4,{"$f":"C3*D3","v":{"v":360,"d":"$360.00"}},"HPLC purified"]
["24 x 24 barcoded universal primers","UC Davis DNA Technologies core",100,1,{"$f":"C4*D4","v":{"v":100,"d":"$100.00"}}]
["Additional barcoded primers","Integrated DNA Technologies",12.5,8,{"v":100,"d":"$100.00"}]
["PCR costs/plate","Evolutionary Genetics Laboratory (MVZ, UC Berkeley)",80,14.25,{"v":1140,"d":"$1,140.00"},"Includes NEB LongAmp taq, other PCR reagents and consumables, agarose gel costs, SPRI bead cleaning, nanodrop assessment"]
["QC and excision costs","Functional Genomics Laboratory (UC Berkeley)",55,13,{"v":715,"d":"$715.00"},"Qubit assessment of pools, BluePippin size selection runs, Bioanalyzer traces"]
["SMRT Library Prep (2021)","UC Davis DNA Technologies core",288,1,{"v":288,"d":"$288.00"},"Can accommodate significantly more than 677 samples, if barcodes are available to incrase multiplexing"]
["SMRT sequencing Sequel II (2021)","UC Davis DNA Technologies core",1900,1,{"v":1900,"d":"$1,900.00"},"Can accommodate significantly more than 677 samples, if barcodes are available to incrase multiplexing"]
[]
[]
[{"$nulls":4},{"$f":"SUM(E3:E9)","v":{"v":4603,"d":"$4,603.00"}},"Total projected cost for the project"]
[{"$nulls":4},{"$f":"E12/677","v":{"v":6.7991137370753325,"d":"$6.80"}},"Projected per sample cost"]
[]
[{"$nulls":4},{"v":8.27,"d":"$8.27"},"Actual real world cost per sample due to increased expenses for \"PCR costs/plate\". This includes optimization costs, repeating failed samples, partially used reagents, etc. "]