How do I recalculate a published rate from its underlying counts and flag rounding deviations?
The tolerance is measured in percentage points. No rate can be validated against a zero base.
Open Rate Claim AuditTry the worked example
These are the example inputs from Rate Claim Audit. Replace them in the tool to run your own case.
| Metric | Numerator | Denominator | Published % | Tolerance pp |
|---|---|---|---|---|
| Book rate | 13 | 25 | 52 | 0.1 |
| Show rate | 16 | 20 | 79 | 0.2 |
Example result
1 published rate to revisit
Who uses this?
Performance reporting lead. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
Recalculate a published rate from its underlying counts and flag rounding deviations. The episode follows a service-business audit and the points where a booking journey can be measured. Benchcraft designed this tool’s inputs, decision rule and example for this office task.
Original video