{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Reed-Muench 2sm.11dil.4reps","Spearman-Karber 2sm.11dil.4reps"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Reed-Muench 2sm.11dil.4reps","index":0,"n_rows":42,"n_cols":14,"rows_kept":42,"flags":["formulas_cached_only"]}
["TCID50 calculator draft by Shi-Hsia HWA 2014"]
["This work is licensed under the Creative Commons Attribution-ShareAlike 4.0 International License. To view a copy of this license, visit http://creativecommons.org/licenses/by-sa/4.0/."]
[]
["Reed-Muench method, referencing WHO Monograph 23 Appendix p.330-331 (p.331 footnote variation to allow for plates that endpoint in column 1)"]
[]
["PASTE ABSORBANCE DATA FOR 1 PLATE IN THE TABLE IMMEDIATELY BELOW ONLY"]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["A",2.897,2.632,2.619,2.598,2.557,2.639,2.453,2.368,0.248,0.263,0.259,0.17900000000000002]
["B",2.758,2.609,2.634,2.74,2.758,2.686,2.59,2.268,1.632,0.253,0.261,0.23600000000000002]
["C",2.276,2.677,2.736,2.741,2.758,2.667,2.659,2.498,0.9380000000000001,0.259,0.254,0.23900000000000002]
["D",2.649,2.577,2.712,2.657,2.786,2.698,2.721,2.398,1.536,0.24300000000000002,0.249,0.219]
["E",2.886,2.619,2.631,2.618,2.651,2.53,2.429,2.344,1.907,0.245,0.255,0.217]
["F",2.714,2.696,2.66,2.728,2.672,2.695,2.607,2.001,1.178,0.247,0.25,0.202]
["G",2.385,2.459,2.614,2.769,2.657,2.576,2.646,0.223,0.227,0.5990000000000001,0.24400000000000002,0.232]
["H",2.89,2.493,2.634,2.519,2.34,1.887,1.352,0.3420000000000001,0.203,0.20800000000000002,0.217,0.187]
["Average(negative controls) + 3*SD(negative controls) cut-off",{"$nulls":11},0.281575891532429]
[]
["Positive/negative scoring"]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["A",1,1,1,1,1,1,1,1,0,0,0,0]
["B",1,1,1,1,1,1,1,1,1,0,0,0]
["C",1,1,1,1,1,1,1,1,1,0,0,0]
["D",1,1,1,1,1,1,1,1,1,0,0,0]
["E",1,1,1,1,1,1,1,1,1,0,0,0]
["F",1,1,1,1,1,1,1,1,1,0,0,0]
["G",1,1,1,1,1,1,1,0,0,1,0,0]
["H",1,1,1,1,1,1,1,1,0,0,0,0]
[]
["TCID50 calculations, sample in rows A--D:"]
["Column 1 dilution",0.0008,"Enter as decimal e.g. dilution factor of 1:1250 = dilution of 0.0008"]
["Serial dilution factor",5,"Enter as an integer e.g. 1:5 = 5"]
["Wells per dilution",4,"Reed-Muench only valid when replicates per dilution are constant, do not use for plates with missing wells"]
["Volume per well",0.1,"mL",{"$nulls":10},"COMMENTS"]
["Dilutions",0.0008,0.00016,3.2000000000000005e-05,6.400000000000001e-06,1.2800000000000002e-06,2.5600000000000007e-07,5.1200000000000015e-08,1.0240000000000003e-08,2.0480000000000004e-09,4.0960000000000006e-10,8.192000000000001e-11,"NA","Previous dilution/Serial dilution factor"]
["No. positive wells",4,4,4,4,4,4,4,4,3,0,0,"NA","Sum of pos/neg well scores at each dilution"]
["No. negative wells",0,0,0,0,0,0,0,0,1,4,4,"NA","Wells per dilution minus Positive wells (NOTE: R-M not valid for datasets missing replicates!)"]
["Cumulative positive (right-left)",35,31,27,23,19,15,11,7,3,0,0,"NA"]
["Cumulative negative (left-right)",0,0,0,0,0,0,0,0,1,5,9,"NA"]
["Proportion positive",1,1,1,1,1,1,1,1,0.75,0,0,"NA","Did not bother converting to percentage. Cumulative; different than Spearman-Karber version."]
["Difference of logarithms",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1.3979400086720375,0.23299000144533957,{"$error":"#DIV/0!"},{"$error":"#VALUE!"},"NA","Due to above, used \"0.5\" instead of \"50\"%"]
["TCID50 as sample dilution","","","","","","","","",{"v":1.1976776655719933e-09,"d":"1.20E-09"},"","","NA","Conditional on this col >= endpoint and next col < endpoint (Corrected 30 May 14)"]
["TCID50/mL","","","","","","","","",{"v":8349491927.132286,"d":"8.35E+09"},"","","NA","Conditional on above being valid number"]

{"sheet":"Spearman-Karber 2sm.11dil.4reps","index":1,"n_rows":40,"n_cols":14,"rows_kept":40,"flags":["formulas_cached_only"]}
["TCID50 calculator draft by Shi-Hsia HWA 2014"]
["This work is licensed under the Creative Commons Attribution-ShareAlike 4.0 International License. To view a copy of this license, visit http://creativecommons.org/licenses/by-sa/4.0/."]
[]
["Spearman-Karber method, referencing WHO Monograph 23 Appendix p.327"]
[]
["PASTE ABSORBANCE DATA FOR 1 PLATE IN THE TABLE IMMEDIATELY BELOW ONLY"]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["A",2.897,2.632,2.619,"bacteria",2.557,2.639,2.453,2.368,0.248,0.263,0.259,0.17900000000000002]
["B",2.758,2.609,2.634,"bacteria",2.758,2.686,2.59,2.268,1.632,0.253,0.261,0.23600000000000002]
["C",2.276,2.677,2.736,2.741,2.758,2.667,2.659,2.498,0.9380000000000001,0.259,0.254,0.23900000000000002]
["D",2.649,2.577,2.712,2.657,2.786,2.698,2.721,2.398,1.536,0.24300000000000002,0.249,0.219]
["E",2.886,2.619,2.631,2.618,2.651,2.53,2.429,2.344,1.907,0.245,0.255,0.217]
["F",2.714,2.696,2.66,2.728,2.672,2.695,2.607,2.001,1.178,0.247,0.25,0.202]
["G",2.385,2.459,2.614,2.769,2.657,2.576,2.646,0.223,0.227,0.5990000000000001,0.24400000000000002,0.232]
["H",2.89,2.493,2.634,2.519,2.34,1.887,1.352,0.3420000000000001,0.203,0.20800000000000002,0.217,0.187]
["Average(negative controls) + 3*SD(negative controls) cut-off",{"$nulls":11},0.281575891532429]
[]
["Positive/negative scoring"]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["A",1,1,1,1,1,1,1,1,0,0,0,0]
["B",1,1,1,1,1,1,1,1,1,0,0,0]
["C",1,1,1,1,1,1,1,1,1,0,0,0]
["D",1,1,1,1,1,1,1,1,1,0,0,0]
["E",1,1,1,1,1,1,1,1,1,0,0,0]
["F",1,1,1,1,1,1,1,1,1,0,0,0]
["G",1,1,1,1,1,1,1,0,0,1,0,0]
["H",1,1,1,1,1,1,1,1,0,0,0,0]
[]
["TCID50 calculations, sample in rows A--D:"]
["Column 1 dilution",0.0008,"Enter as decimal e.g. dilution factor of 1:1250 = dilution of 0.0008"]
["Serial dilution factor",5,"Enter as an integer e.g. 1:5 = 5"]
["Volume per well",0.1,"mL",{"$nulls":10},"COMMENTS"]
["Dilutions",0.0008,0.00016,3.2000000000000005e-05,6.400000000000001e-06,1.2800000000000002e-06,2.5600000000000007e-07,5.1200000000000015e-08,1.0240000000000003e-08,2.0480000000000004e-09,4.0960000000000006e-10,8.192000000000001e-11,"NA","Previous dilution/Serial dilution factor"]
["Log10 dilutions",-3.096910013008056,-3.795880017344075,-4.494850021680093,-5.1938200260161125,-5.892790030352131,-6.59176003468815,-7.290730039024169,-7.9897000433601875,-8.688670047696206,-9.387640052032225,-10.086610056368242,"NA"]
["Wells per dilution",4,4,4,4,4,4,4,4,4,4,4,"NA","Excel COUNT()s only numerical values"]
["No. positive wells",4,4,4,4,4,4,4,4,3,0,0,"NA","Sum of pos/neg well scores at each dilution"]
["Proportion positive",1,1,1,1,1,1,1,1,0.75,0,0,"NA","Per dilution; different than Reed-Muench version"]
["log10 TCID50",-8.863412548780211,-8.863412548780211,-8.863412548780211,-8.863412548780211,-8.863412548780211,-8.863412548780211,-8.863412548780211,-8.863412548780211,-8.863412548780211,-9.038155049864216,-9.737125054200233,"NA"]
["TCID50 as sample dilution",0,0,0,0,0,0,0,1.3695801445917145e-09,0,0,0,"NA","If prop pos at this dilution is 1 and prop pos at dilution below is < 1, return 10^(row above)"]
["TCID50/mL",0,0,0,0,0,0,0,7301507720.806728,0,0,0,"NA","Conditional on above being valid number"]