How’s your district doing with the DCP?

The new Distinguished District Program requires 40% of base clubs to be distinguished (goes into effect July 1, 2012).  How’s your district doing so far this year, 1/4 of the way through?  Here’s the answer:

http://mikeraffety.com/DDP-DCP.html

I believe I have a reasonable way to measure that success, without having to wait for April dues to post, and it’s really surprising how well districts are doing with this goal.  I’ve written a program to:

  1. Calculate the number of distinguished clubs needed for each district (40% of start-of-year club base)
  2. Identify the clubs farthest along in the DCP (most goals earned to date)
  3. Add up their goals (but capped at 5 goals per club, since a club with 7 goals doesn’t help a club with 3 goals be distinguished)
  4. Divide that total goals by 5 times the number of distinguished clubs needed
  5. The resulting percentage should hit 100% exactly when the district achieves the 40% distinguished clubs goal.

Except that there’s also that membership requirement for the DCP.  So I’ve counted up the number of members that those clubs (making up the 40%) are short of whatever is required for them to be distinguished (+5 or >=20 members) and show that as well.  This number isn’t terribly meaningful until April dues are posted, of course; we only lose members twice a year, April 1 and Oct. 1.

D84 (north and central Florida) is already 63% of the way there!  11 districts are at least halfway there, and almost every district (80 of 82) is over 25%.  It will be very interesting to see how these numbers evolve in the coming months!

Feedback and comments are appreciated!