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.
Source Distributions
Built Distribution
Hashes for tcid50_calculator0.1.1py3noneany.whl
Algorithm  Hash digest  

SHA256  19223345d88c8fd738df4c09440fcf40548ce4223b80fdc145fb9e55dc97744c 

MD5  bc8ad33e18798b6d2738e3e2316cabfb 

BLAKE2b256  5e08def1fd86ff74aa76a6a1cd8ca3af1639bc8c8d5a28cfe7a6c57331aa6093 