Free Template
Avails Data Quality Scorecard
Score your avails sheet across 7 checks: required fields, date coherence, exclusivity vocabulary. Paste once into the generic source tab, read the quality score.
excelgoogle-sheets
What’s Included
- Paste Generic Avails Here — the same 7-column OpenRights generic schema used across every avails template.
- Scorecard — 7 automated checks with traffic-light status + a 0–100 quality score.
- Rule Definitions — what each check tests for.
Checks Performed
- Blank Title / Territory / Right / Start / End
- End date before Start date
- Exclusive field not in {Yes, No}
How to Use
- Paste your avails into Paste Generic Avails Here.
- Open Scorecard — everything recalculates.
- Fix FAIL rows until the score is 100.
Related Tutorials
- Validate an Avails Sheet Against IFTA + EMA Rules (
/tutorials/validate-avails-ifta-ema-rules) - Normalize Territory Codes (
/tutorials/normalize-territory-codes)
Common Pitfalls
- Blank counts lie on mixed date formats. Text dates count as “not blank” but still break the end-before-start check. Use ISO dates.
- Territory vocabulary. The scorecard doesn’t enforce a territory whitelist — run the avails validator Apps Script for that.
Get New Templates
We release new templates regularly. Subscribe to get them in your inbox.