A plain-language guide to what Precision Repeatability is for Assay, Dissolution, Content Uniformity, and Impurity, why every sample must keep its own weight in the calculation, the exact spreadsheet mistake that silently breaks it, and the ICH Q2(R1)/USP <1225> theory behind %RSD acceptance criteria — plus tips for filling in the calculator correctly.
Locking the sample weight cell. When building this calculation in Excel, it's extremely common to write the first row's formula correctly, then drag-fill it down — but accidentally leave the sample weight cell reference absolute (e.g. $F$34) instead of relative (F34, F35, F36...). Every row after the first then silently reuses the first sample's weight instead of its own.
Why it matters: dosage units are never perfectly uniform in weight. Using the wrong sample's weight introduces a small but real error into both the individual % Result and the overall %RSD — sometimes enough to change a borderline pass into a fail. This calculator asks for each sample's own weight in its own row on purpose, so this error can't happen here.
| Parameter | Typical Limit* |
|---|---|
| %RSD of 6 replicate results (Assay / Dissolution / CU) | ≤ 2.0% |
| %RSD of 6 replicate results (Impurity / trace-level) | Often wider — per protocol, commonly ≤ 5.0–10.0% |
| Individual result vs. label claim | Per monograph / protocol, commonly 98.0–102.0% |
| Term | What Varies |
|---|---|
| Repeatability | Nothing — same analyst, instrument, day (this calculator) |
| Intermediate Precision | Day, analyst, or instrument within the same lab |
| Reproducibility | Different laboratories entirely |