How do I detect overlaps and gaps between numeric reporting bands?
Bands are half-open intervals [lower, upper). Only gaps inside the defined range are checked.
Open Band Boundary AuditTry the worked example
These are the example inputs from Band Boundary Audit. Replace them in the tool to run your own case.
| Band | Lower bound | Upper bound |
|---|---|---|
| Low | 0 | 10 |
| Mid | 8 | 20 |
| High | 25 | 40 |
Example result
2 boundary exceptions
Who uses this?
Reporting analyst. 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
Detect overlaps and gaps between numeric reporting bands. The demonstration requires actual execution before work can be marked complete. Benchcraft designed this tool’s inputs, decision rule and example for this office task.
Original video