Weight a workload by its case counts
Your goal: Combine per-case estimates using the number of cases instead of giving every service the same influence.
Full task requirements
In G2, calculate case-weighted minutes from B2:B7 and C2:C7. Show Review weights for a negative case count or zero total volume.
An uneven service workloadInspect negative case counts
- Case count
- Negative
| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 |
Step 1 of 2
Inspect negative case counts
How the Excel rule works
Find any negative case counts before averaging. A negative count requires Review weights, even if the other rows would produce a plausible average.
Inspect selected records
No records selected yet.