Skip to main content
. 2017 Apr 13;9(2):14. doi: 10.3390/pharmaceutics9020014

Table 7.

Excel spreadsheet code for estimating bacterial growth rate.

Data Row Column A Column B Column C Column D Column E
Doubling time or halving time Time duration Value of “X Relative change Resulting # bacteria (Y)
Row 1 10 20 100 2B1/A1 C1 × D1
Row 2 35 120 400 0.5B2/A2 C2 × D2
Row 3 10 60 37.15 2B3/A3 C3 × D3