OpenRights Entertainment Rights & Catalog Intelligence

Better Data. Fewer Conflicts.
Faster Licensing.

Completely free tools, templates, and unbiased guides for entertainment rights and catalog management — helping the industry modernise.

Free Templates Browse Tutorials
19+ Templates
24+ Tutorials

Latest Tutorials

View All
Data Cleaning beginner

Detect Invisible Blank Cells That Look Filled

A cell with just a non-breaking space LOOKS blank but ISBLANK returns FALSE, COUNTA counts it, and your required-field validation misses it. Two formulas to catch both.

· 4 min read
Data Cleaning intermediate

Normalize Quarter Codes: 'Q1 2026', '2026-Q1', '202601' in One Formula

Platforms encode quarters four different ways. One nested-IF formula normalizes all of them to canonical YYYY-Qn so reconciliation joins actually work.

· 5 min read
Data Cleaning intermediate

Spot an MG That's Already Fully Recouped in Your Contract Register

Licensor is owed post-recoupment royalties — but only if you know the MG is recouped. SUMIF across reported gross × royalty %, compare to MG balance, flag recouped rows.

· 6 min read

Insights

View All