District 5 may not fare well in the Hunger games but we had an awesome prize to give away. The folks behind the blog tour conjured up an embroidered, one of a kind, messenger bag for one lucky winner. For our contest, you needed to only proclaim your allegiance for one of the possible matchups for Katniss instead of dying during a sensationalized broadcasting of a post apocalyptic Lord of the Flies. The winner, based on an integer generation by random.org, is Anna Swenson.
There was some concern about how we pick a winner so I’ll let you in on the process. WordPress, the software that runs this blog, is based on a database program. I logged into the backend of the site and downloaded all of the comments related to the giveaway post into a CSV file. There were over 1100 of them:
Once the list is downloaded, I open the document in Excel and I do a sort by IP addresses so I can get rid of any posts by myself or Jia or any of the DA crew. I also look to see if there is any, ah, overeager commenters because we have so many people who want just one prize. This culled my list down to 1087 commenters.
I then sort the commenters by date so that CSV file matches up with the comments on the site. The first commenter was JMC and the last was Leigh:
Once I have my comments properly sorted, I go to Random.org and get the computer program to generate a random number between 1 and 1087.
That’s how we pick the winners of our giveaways here at Dear Author, District 5. Go Team Gale!