Metric Rollup Lab
Compare a weighted completion rate with a simple average of team rates.
Prepare your sheet
Use one row per team observation. Enter Eligible, Complete. Check that every row belongs to the same review scope.
Decision rule
Completed records must be a subset of eligible records. Empty teams are excluded from the unweighted average.
Worked result
The fictional example contains 2 input rows. Its result is 64% pooled · 80% team mean.
| Team | Eligible | Complete | Rate |
|---|---|---|---|
| North | 90 | 54 | 60% |
| South | 10 | 10 | 100% |
Run it on your own inputs
- Open the tool and choose Start empty or edit the example.
- Enter the inputs, resolve validation messages and review the decision sheet.
- Download the text report or print the summary for the responsible person.
Source and support
Compare a weighted completion rate with a simple average of team rates. 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. Reviewed source · Greg Isenberg at 15:02.
Request a custom workflow. €149 one-time pilot after written scope agreement. JB Codex adapts one repeated job with a worked example and owner review.