This is a long post but hopefully of interest. Below is an analysis of Membership List counts taken at intervals of a week.
Attachment:
MembershipCounts-8.png [ 72.63 KiB | Viewed 95 times ]
Notes:
1. All counts except those for stats 1, 3, 4 and 5 exclude memberships with a Due Date which is prior to the date of the source Membership List.
2. All counts are membership counts except those for stats 31 and 32. See below for further info on those stats.
3. Some counts were produced with reference to the Grading List. For stats up to 25 Sep, the Grading List used is the September 2012 revision, released on 26 Sep. For stats from 2 Oct onwards, the Grading List used is the October 2012 revision, released on 26 Oct.
4. 'Platinum - Old' (stat 6), for example, means membership taken out prior to introduction of new scheme and converted to 'Platinum'.
5. 'All excluding prior Due Date' (stat 2), 'Bronze - Old' (stat 23) and 'Bronze - Total' (stat 29). The 4 Sep figures look like aberations - 1,377 memberships had a Due Date of 6 Sep 2012.
6. 'Grade Ref appears more than once' (stat 31) is the count of Grade Refs which are shared by more than one membership.
- Where a Grade Ref appears more than once, usually it's because a member has more than one active membership (sometimes one of these is pre the new scheme and close to expiry). In a few cases a member has another member's Grade Ref!
7. 'Membership Number appears more than once' (stat 32) is the count of Membership Numbers which are shared by more than one membership.
8. 'Membership has no Grade Ref' (stat 33).
- Counts include memberships with a Grade Ref of 'None', 'N/A' etc.
- On inspection it appears that in many cases a member is listed in the Grading List but Grade Ref has not been set in the Membership List.
9. 'Membership has a Grade Ref which isn't in the Grading List' (stat 34).
- Memberships with a Grade Ref of 'None', 'N/A' etc. are not counted.
- A few members have their grade rather their Grade Ref recorded. Many values don't conform to the format: six digits followed by a letter.
10. 'Member's last name doesn't match last name in Grading List' (stat 35).
- The Membership List was linked to the Grading List through Grade Ref.
- In many cases there is a difference in spelling. For example, 'Bennet' vs. 'Bennett', 'Plum' vs 'Plumb'. Sometimes the Membership List name will be correct; sometimes the Grading List name.
- In many cases, the First Name and Last Name appear to have been inverted.
- In a few cases, it appears that an incorrect Grade Ref has been recorded against a membership.
Comments:
11. The are almost 7,000 new memberships - not bad going.
12. Work is needed on data quality (see counts for stats 31 to 36 and for stat 2 vs. stat 1).
Edit: Fixed error pointed out by David Gilbert.
Edit2: Stats updated to include counts for 23 Oct.
Edit3: Stats updated to include counts for 24 Oct and 25 Oct. Further stats in attached spreadsheet.
Edit4: Stats for 24 and 25 Oct removed; stats for 30 Oct added.
Edit5: Recalculated stats for 2 Oct to 30 Oct as previously dates with a year of '50' or '51' were interpretted as being for 1950 or 1951 rather than 2050 or 2051. Added stat for 'Membership No incorrectly formatted' (#36).
Edit6: Added stats for 13 Nov