Completed records must be a subset of eligible records. Empty teams are excluded from the unweighted average.
Data integrity / Business operations analyst
Metric Rollup Lab
Compare a weighted completion rate with a simple average of team rates.
01 / Inputs
Working sheet
Edit any cell to recalculate. Use anonymous references. Data stays in this browser tab and clears when you reload.
| Team | Eligible | Complete | Row |
|---|
02 / Review
Decision sheet
| Team | Eligible | Complete | Rate |
|---|---|---|---|
| North | 90 | 54 | 60% |
| South | 10 | 10 | 100% |
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.
The free tool runs independently on your device.