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 |