{"text_format":"2","workbook":"xls","n_sheets":6,"sheets":["Slide 6","Slide 7","Slide 8","Slide 9","Slide 10","Slide 11"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Slide 6","index":0,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"B","C","D"]
[2]
[3,"No =",10000,null,null,null,"1pmole primer = 1e-12mole"]
[4,"Efficiency",0.9,null,null,null,"6.02e11 molecules of primer"]
[7]
[8,"Cycle","Copies of DNA"]
[9,0,10000]
[10,1,19000]
[11,2,36100]
[12,3,68590]
[13,4,130321]
[14,5,247609.90000000002]
[15,6,470458.81000000006]
[16,7,893871.7390000001]
[17,8,1698356.3041000003]
[18,9,3226876.977790001]
[19,10,6131066.257801002]
[20,11,11649025.889821904]
[21,12,22133149.190661617]
[22,13,42052983.46225707]
[23,14,79900668.57828844]
[24,15,151811270.29874802]
[25,16,288441413.56762123]
[26,17,548038685.7784803]
[27,18,1041273502.9791126]
[28,19,1978419655.660314]
[29,20,3758997345.7545967]
[30,21,7142094956.933734]
[31,22,13569980418.174095]
[32,23,25782962794.53078]
[33,24,48987629309.60848]
[34,25,93076495688.25612]
[35,26,176845341807.68665]
[36,27,336006149434.6046]
[37,28,638411683925.7488]
[38,29,1212982199458.9229]
[39,30,2304666178971.9536]

{"sheet":"Slide 7","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"B","C","D"]
[2]
[3,"No =",10000]
[4,"Efficiency",0.9]
[7]
[8,"Cycle","Copies of DNA"]
[9,0,10000]
[10,1,19000]
[11,2,36100]
[12,3,68590]
[13,4,130321]
[14,5,247609.90000000002]
[15,6,470458.81000000006]
[16,7,893871.7390000001]
[17,8,1698356.3041000003]
[18,9,3226876.977790001]
[19,10,6131066.257801002]
[20,11,11649025.889821904]
[21,12,22133149.190661617]
[22,13,42052983.46225707]
[23,14,79900668.57828844]
[24,15,151811270.29874802]
[25,16,288441413.56762123]
[26,17,548038685.7784803]
[27,18,1041273502.9791126]
[28,19,1978419655.660314]
[29,20,3758997345.7545967]
[30,21,7142094956.933734]
[31,22,13569980418.174095]
[32,23,25782962794.53078]
[33,24,48987629309.60848]
[34,25,93076495688.25612]
[35,26,176845341807.68665]
[36,27,336006149434.6046]
[37,28,638411683925.7488]
[38,29,1212982199458.9229]
[39,30,2304666178971.9536]

{"sheet":"Slide 8","index":2,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"B","C","D"]
[2]
[3,"No =",10000]
[4,"Efficiency",0.9]
[7]
[8,"Cycle","Copies of DNA"]
[9,0,10000]
[10,1,19000]
[11,2,36100]
[12,3,68590]
[13,4,130321]
[14,5,247609.90000000002]
[15,6,470458.81000000006]
[16,7,893871.7390000001]
[17,8,1698356.3041000003]
[18,9,3226876.977790001]
[19,10,6131066.257801002]
[20,11,11649025.889821904]
[21,12,22133149.190661617]
[22,13,42052983.46225707]
[23,14,79900668.57828844]
[24,15,151811270.29874802]
[25,16,288441413.56762123]
[26,17,548038685.7784803]
[27,18,1041273502.9791126]
[28,19,1978419655.660314]
[29,20,3758997345.7545967]
[30,21,7142094956.933734]
[31,22,13569980418.174095]
[32,23,25782962794.53078]
[33,24,48987629309.60848]
[34,25,93076495688.25612]
[35,26,176845341807.68665]
[36,27,336006149434.6046]
[37,28,638411683925.7488]
[38,29,1212982199458.9229]
[39,30,2304666178971.9536]

{"sheet":"Slide 9","index":3,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"B","C","D"]
[2]
[3,"No =",10000]
[4,"Efficiency",0.9]
[7]
[8,"Cycle","Copies of DNA"]
[9,0,10000]
[10,1,19000]
[11,2,36100]
[12,3,68590]
[13,4,130321]
[14,5,247609.90000000002]
[15,6,470458.81000000006]
[16,7,893871.7390000001]
[17,8,1698356.3041000003]
[18,9,3226876.977790001]
[19,10,6131066.257801002]
[20,11,11649025.889821904]
[21,12,22133149.190661617]
[22,13,42052983.46225707]
[23,14,79900668.57828844]
[24,15,151811270.29874802]
[25,16,288441413.56762123]
[26,17,548038685.7784803]
[27,18,1041273502.9791126]
[28,19,1978419655.660314]
[29,20,3758997345.7545967]
[30,21,7142094956.933734]
[31,22,13569980418.174095]
[32,23,25782962794.53078]
[33,24,48987629309.60848]
[34,25,93076495688.25612]
[35,26,176845341807.68665]
[36,27,336006149434.6046]
[37,28,638411683925.7488]
[38,29,1212982199458.9229]
[39,30,2304666178971.9536]

{"sheet":"Slide 10","index":4,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"B","C","D"]
[2]
[3,"No =",10000,5000]
[4,"Efficiency",0.9,0.9]
[5]
[6,"Cycle","Copies of DNA","Copies of DNA"]
[7,0,10000,5000]
[8,1,19000,9500]
[9,2,36100,18050]
[10,3,68590,34295]
[11,4,130321,65160.5]
[12,5,247609.9,123804.95]
[13,6,470458.80999999994,235229.40499999997]
[14,7,893871.7389999998,446935.8694999999]
[15,8,1698356.3040999996,849178.1520499998]
[16,9,3226876.977789999,1613438.4888949995]
[17,10,6131066.257800998,3065533.128900499]
[18,11,11649025.889821896,5824512.944910948]
[19,12,22133149.1906616,11066574.5953308]
[20,13,42052983.46225704,21026491.73112852]
[21,14,79900668.57828838,39950334.28914419]
[22,15,151811270.2987479,75905635.14937395]
[23,16,288441413.567621,144220706.7838105]
[24,17,548038685.7784798,274019342.8892399]
[25,18,1041273502.9791116,520636751.4895558]
[26,19,1978419655.660312,989209827.830156]
[27,20,3758997345.7545924,1879498672.8772962]
[28,21,7142094956.933725,3571047478.4668627]
[29,22,13569980418.174078,6784990209.087039]
[30,23,25782962794.530746,12891481397.265373]
[31,24,48987629309.60841,24493814654.804207]
[32,25,93076495688.25598,46538247844.12799]
[33,26,176845341807.68637,88422670903.84319]
[34,27,336006149434.60406,168003074717.30203]
[35,28,638411683925.7477,319205841962.87384]
[36,29,1212982199458.9207,606491099729.4603]
[37,30,2304666178971.949,1152333089485.9746]

{"sheet":"Slide 11","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"B","C","D","E","F"]
[2]
[3,"N0 =",10,100,1000]
[4,"Efficiency =",0.9,0.9,0.9]
[5]
[7,"Divide by N0, and set N=1E9"]
[8,"Take the ln of both sides"]
[9,"Calculate k = ln(1+Efficiency)"]
[10,"Solve for c (cycles)",null,null,21.52]
[]
[null,null,100000000,10000000,1000000]
[null,null,18.420680743952367,16.11809565095832,13.815510557964274]
[null,null,28.699180827277534,25.111783223867842,21.524385620458148]