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

{"sheet":"Sheet1","index":0,"n_rows":19,"n_cols":11,"rows_kept":19}
[null,"Reed & Muench Calculator",{"$nulls":8},"Created November 20, 2004 by Brett D. Lindenbach, PhD"]
[{"$nulls":10},"Modified June 2011 to incorporate suggestions from Stefan J. Halbherr, PhD"]
[null,"1. Enter the starting dilution","initial dilution:",0.1]
[null,"2. Enter the dilution factor","dilution factor:",10]
[null,"3. Enter the volume tested per well","ml:",0.1]
[{"$nulls":3},"A","B","C","D","E","F","G","H"]
[null,"    This is your calculated dilution series:",null,{"$f":"D3","v":{"v":0.1,"d":"1.00E-01"}},{"$f":"D7/D4","v":{"v":0.01,"d":"1.00E-02"}},{"$f":"E7/D4","v":{"v":1E-3,"d":"1.00E-03"}},{"$f":"F7/D4","v":{"v":1E-4,"d":"1.00E-04"}},{"$f":"G7/D4","v":{"v":1e-05,"d":"1.00E-05"}},{"$f":"H7/$D$4","v":{"v":1.0000000000000002E-6,"d":"1.00E-06"}},{"$f":"I7/D4","v":{"v":1.0000000000000002E-7,"d":"1.00E-07"}},{"$f":"J7/D4","v":{"v":1.0000000000000002E-8,"d":"1.00E-08"}}]
[null,"4. Enter the total # of wells examined per dilution","total wells:",4,4,4,4,4,4,4,4]
[null,"5. Enter the # of positive wells for each dilution","positive wells:",4,4,4,4,3,2,0,0]
[null,"    These values are calculated automatically:","negative wells:",{"$f":"D8-D9","v":0},0,0,0,1,2,{"$f":"J8-J9","v":4},4]
[null,null,"cum pos:",{"$f":"D9+E9+F9+G9+H9+I9+J9+K9","v":21},{"$f":"E9+F9+G9+H9+I9+J9+K9","v":17},{"$f":"F9+G9+H9+I9+J9+K9","v":13},{"$f":"G9+H9+I9+J9+K9","v":9},{"$f":"H9+I9+J9+K9","v":5},{"$f":"I9+J9+K9","v":2},{"$f":"J9+K9","v":0},{"$f":"K9","v":0}]
[null,null,"cum neg:",{"$f":"D10","v":0},{"$f":"D10+E10","v":0},{"$f":"D10+E10+F10","v":0},{"$f":"D10+E10+F10+G10","v":0},{"$f":"D10+E10+F10+G10+H10","v":1},{"$f":"D10+E10+F10+G10+H10+I10","v":3},{"$f":"D10+E10+F10+G10+H10+I10+J10","v":7},{"$f":"D10+E10+F10+G10+H10+I10+J10+K10","v":11}]
[null,null,"% infected:",{"$f":"100*D11/(D11+D12)","v":{"v":100,"d":"100.00"}},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":83.33333333333333,"d":"83.33"},{"v":40,"d":"40.00"},{"$f":"100*J11/(J11+J12)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[null,null,"prop dist:",{"$f":"IF(D13=100,IF(E13<51,(D13-50)/(D13-E13),0),IF(D13=0,0,(D13-50)/(D13-E13)))","v":0},0,0,0,0.7692307692307692,-0.25,{"$f":"IF(J13=100,IF(K13<51,(J13-50)/(J13-K13),0),IF(J13=0,0,(J13-50)/(J13-K13)))","v":0},{"$f":"IF(K13=100,IF(L13<51,(K13-50)/(K13-L13),0),IF(K13=0,0,(K13-50)/(K13-L13)))","v":0}]
[null,"6. This is your TCID50","TCID50:",{"$f":"IF(D14>0,10^(LOG10(1/D7)+LOG10($D$4)*((((D13/100+E13/100+F13/100+G13/100+H13/100+I13/100+J13/100+K13/100))-0.5))),\" \")","v":" "},{"$f":"IF(E14>0,10^(LOG10(1/E7)+LOG10($D$4)*((((E13/100+F13/100+G13/100+H13/100+I13/100+J13/100+K13/100))-0.5))),\" \")","v":" "},{"$f":"IF(F14>0,10^(LOG10(1/F7)+LOG10($D4)*((((F13/100+G13/100+H13/100+I13/100+J13/100+K13/100))-0.5))),\" \")","v":" "},{"$f":"IF(G14>0,10^(LOG10(1/G7)+LOG10($D$4)*((((G13/100+H13/100+I13/100+J13/100+K13/100))-0.5))),\" \")","v":" "},{"$f":"IF(H14>0,10^(LOG10(1/H7)+LOG10($D$4)*((((H13/100+I13/100+J13/100+K13/100))-0.5))),\" \")","v":{"v":541169.5265464642,"d":"5.41E+05"}},{"$f":"IF(I14>0,10^(LOG10(1/I7)+LOG10($D4)*((((I13/100+J13/100+K13/100+L13/100))-0.5))),\" \")","v":" "},{"$f":"IF(J14>0,10^(LOG10(1/J7)+LOG10($D$4)*((((J13/100+K13/100))-0.5))),\" \")","v":" "},{"$f":"IF(K14>0,10^(LOG10(1/K7)+LOG10($D4)*((((K13/100))-0.5))),\" \")","v":" "}]
[null,"7. This is your TCID50/ml","TCID50/ml:",{"$f":"IF(D14>0,1/D5*1/D15,\" \")","v":" "},{"$f":"IF(E14>0,1/D5*1/E15,\" \")","v":" "},{"$f":"IF(F14>0,1/D5*1/F15,\" \")","v":" "},{"$f":"IF(G14>0,1/D5*1/G15,\" \")","v":" "},{"$f":"IF(H14>0,1/D5*1/H15,\" \")","v":{"v":1.8478497974222891E-5,"d":"1.85E-05"}},{"$f":"IF(I14>0,1/D5*1/I15,\" \")","v":" "},{"$f":"IF(J14>0,1/D5*1/J15,\" \")","v":" "},{"$f":"IF(K14>0,1/D5*1/K15,\" \")","v":" "}]
[]
[null,"This calculator may be freely distributed in an unmodified form.  If you find it useful or have a suggestion, please:",{"$nulls":4},"send me feedback."]
[null,"If you use this calculator, please cite: Lindenbach BD \"Measuring HCV infectivity produced in cell culture and in vivo\"  Methods Mol Biol. (2009) 510:329-36:",{"$nulls":7},"PMID 19009272"]