A quick calculator to calculate TCID50 based on different dilution infected and uninfected counts, provided in a csv (comma delimited) format.
Project description
TCID50_Calculator
Pip Package Reference
https://pypi.org/project/tcid50calculator/
What does this calculate?

Calculate cumulative infected and uninfected wells adding infected wells totaling everything under dilution and uninfected wells totaling everything above dilution.

Find PD. PD=(A50)/(AB)
A=% response above 50% closest to 50
B=% response below 50% closest to 50 
Find TCID 50
Log(10) TCID50 = Dilution giving above 50% response minus PD 
Take reciprocal of TCID50 and multiply by 100 to get TCID50/mL

Multiply by 0.69 to get pfu/mL

Output all the aforementioned step results per calculation to be executed.
How to run a new calculation?
Input
Input should be a csv with the following layout (start and end block per calculation in the file if you want one file to calculate multiple results):
START
Dilution,Infected,Uninfected
0.00001,8,0
0.000001,5,3
0.0000001,1,7
0.00000001,0,8
END
START
Dilution,Infected,Uninfected
0.00001,8,0
0.000001,5,3
0.0000001,1,7
0.00000001,0,8
END
How to run?

Install python 3.x: https://www.python.org/downloads/

Install pip: https://pip.pypa.io/en/stable/installing/

Install the pip package via command line: pip install tcid50_calculator

Execute the module via command line: tcid50_calculator calculate_tcid50 "FULL_PATH_TO_CSV"
Example Command:
python ./TCID50_Calculator/application/main.py calculate_tcid50 "C:\Users\USER\Desktop\Projects\TCID50_Calculator\test.csv"
Output
Output will match the same input csv in the same directory.
It will have the same name of the provided csv, with _result suffixed.
The result file will have additional columns for cumulative totals, Percent_Infected, PD, TCID50, TCID50/mL, and pfu/mL.
START
Dilution,Infected,Uninfected,Cumulative_Infected,Cumulative_Uninfected,Percent_Infected,BLANK_COLUMN,PD,TCID50,TCID50_per_mL,pfu_per_mL
0.00001,8,0,14,0,100,,0.29,0.000000512,0.0000000195,0.0000000134
0.000001,5,3,6,3,66.7
0.0000001,1,7,1,10,9.1
0.00000001,0,8,0,18,0
END
START
Dilution,Infected,Uninfected,Cumulative_Infected,Cumulative_Uninfected,Percent_Infected,BLANK_COLUMN,PD,TCID50,TCID50_per_mL,pfu_per_mL
0.00001,8,0,14,0,100,,0.29,0.000000512,0.0000000195,0.0000000134
0.000001,5,3,6,3,66.7
0.0000001,1,7,1,10,9.1
0.00000001,0,8,0,18,0
END
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Filename, size  File type  Python version  Upload date  Hashes 

Filename, size tcid50_calculator0.2.1py3noneany.whl (4.6 kB)  File type Wheel  Python version py3  Upload date  Hashes View 
Hashes for tcid50_calculator0.2.1py3noneany.whl
Algorithm  Hash digest  

SHA256  a779430393a238f000f432a2980bf0469122c7975db07358d95671a56e425990 

MD5  0d6f6d1bd25c14565ff89efc87d984a7 

BLAKE2256  078c53775e987dbf24df343cb4246605b8d168363e2a5d45dbe116dbc33db0f2 