The Rights Grabbing statistics are calulated by a spreadsheet. The input to the spreadsheet is the Competition Notice List and each line in the competition notice list contains the following fields, each separated by a comma -
Each character in the Rights Code has the following meaning;
Note that a rights code = xxxxxx means that no rules regarding rights have been published for the competition.
Type of organisation can be -
Note that some competitions attract a huge volume of entries and to prevent the few such contests distorting the average calculations and the overall analysis they are identified by a double # at the beginning of the type of organisation code. The spreadsheet analyses such contests separately.
Some contests publish the number of entries submitted by entrants but many others don't. In order to estimate the number of entries submitted to all contests on the competition notice list the spreadsheet has to make an estimate for each contest where the number of entries are not known.
Different estimates are used based on a competitions frequency;
Weekly Contest 149 entries
Monthly Contest 319 entries
The above are conservative estimates based on existing contests to ensure the analysis understates rather than overstates.
For all other competitions (including annual) entries are calculated based on an average of those contests for which the number of entries are known.
You can easily import the data in the Competition Notice List into a spreadsheet for analysis purposes. On a PC you can do this is as follows (we assume it's similar for Mac users) -
1. Select every row of the list then right click and select 'copy'.
2. Open a new Notepad document and paste the data copied at one above.
3. Save the Notepad document to your hard drive and close the document.
4. Open the Notepad document with Excel and follow the instructions, choose the 'fields delimited by commas' option.
5. You now have a spreadsheet of rights grabbing competitions. Have fun and if you discover anything interesting do let us know!
Note this table may be extended from time to time to deal with new business categories but existing categories will not be changed.
P003 Business Association
P009 Other Media
P010 Transport, airlines etc
P011 Accomodation, Hotels etc
P012 Travel Guides
P013 Travel Agents
P014 Private Tourist Association
P020 Manufacturer, cameras/lemses
P021 Manufacturer, other equipment
P022 Supplies, including software
P023 Stock Agency
P024 Specialist publisher e.g. photography magazines/books
P042 Property Agent
P052 Outdoor Clothing/Products
P055 Warehouse Store/Club or Department Store
P070-079 Community Websites
P090 Visitor Attractions
P109 Specialist Finance
P110 Private Medical Association
P120 Commercial Arts Organisation