What this is for: Time-course analysis for up to 4 conditions × 3 replicates: means ± SD with a live chart, AUC per condition, and doubling time between two points.
The formula: AUC = trapezoid sum Σ (t2 − t1) × (y1 + y2) ÷ 2; doubling time = (t2 − t1) × ln 2 ÷ ln(y2/y1)
How to use:
- Enter one row per time point: the time, then Condition 1's 3 replicates, Condition 2's 3, Condition 3's 3 and Condition 4's 3, separated by spaces or commas.
- Read the mean ± SD table and line chart, and the AUC for each condition, to compare total growth.
- In the Doubling Time section, pick a condition (1–4) and two time points in its exponential phase — both times must match rows you entered.
- Read N at t1, N at t2 and the doubling time in hours.
Growth Curve — time course, up to 4 conditions × 3 replicates
Enter time points and replicate values (e.g. cell counts or OD600) per condition. One row per time point: time, then Condition 1 (3 replicates), Condition 2 (3), Condition 3 (3), Condition 4 (3) — values separated by spaces or commas. Means ± SD, the line chart, AUC and doubling time update automatically.
AUC condition 1 (trapezoid)
AUC condition 2
AUC condition 3
AUC condition 4
Doubling Time
Pick a condition and two time points in exponential phase.
N at t1 (condition mean)
N at t2 (condition mean)
Doubling time (h)
Prefer to work offline or keep a copy? The download link is right below.
Download the Growth Curves workbook (.xlsx)
Download the Growth Curves workbook (.xlsx)
Notes & limits (from the workbook): AUC is the trapezoid sum over the condition means between consecutive entered time points, exactly as the workbook's SUMPRODUCT formula computes it for its rows. Doubling time = (t2 − t1) × ln 2 / ln(N2/N1) from the condition means at the two chosen times — pick both times inside the exponential phase, as the workbook instructs. SD is the sample SD (Excel STDEV) over the replicates entered.