For those who wish to double-check their Royalties and Referrals using Excel (or equivalent), I created a quick-and-dirty file which can be downloaded on Limewire at limewire [dot] com/d/7nXSf#gauGX36xTG
Quite sure the link wouldn't be allowed here and not even sure if ^that text is allowed, but if Mods are cool and leave it, remember the disclaimer: Don't take candy or files from strangers. I know it's just a simple spreadsheet, but download at your risk, scan it with virucide, or use your ex's computer to get back at him to give it a whirl.
If you're risk averse, you can recreate it using the JPG below.
Column A is just description;
Column B is numbers and math;
Column C tells you the designation/name of the cells in Column B to the left of C; and
Column D is part description and, where applicable, actual formulas in Column B.
Where you see YELLOW highlight, you drop in numbers.
Where you see NO COLOR or ORANGE, those are calculated for you or picked up from your Yellows.
You'll grab your Selling Price from the top number of a Royalty paid; you'll grab your Upgrades/Options Price from the bottom number of a Royalty paid (think envelopes and extras where we only get paid 5%; sometimes there is nothing at 5% -- just enter ZERO). Your Royalty Rate you know, of course, and your Department Rates are there to the right in gloomy gray for easy reference.
All that said, it's way past my bedtime -- if anyone sees any mistakes, please tell me (be gentle... or funny -- I'll take either 😏).
Hope it's helpful. 😊 Generally speaking we are, after all, creatives and not mathletes, so it may take a thing off your plate.
@idraw > In response to your message that I can *read* but not respond to because I might be a bot. 😁
