You're browsing: KeithJamesLock.com » Make Money Online » Blog article: The Shuffled Entries Spreadsheet

The Shuffled Entries Spreadsheet

Mon, Jun 23, 2008

Make Money Online

As I've mentioned, there were a couple people that didn't do the basic requirements for the contest, but they did some of the advanced optional tasks. To be fair to everyone I didn't allow those entries in the contest but I emailed each of those people letting them know that I will give them a little extra time. Well...their time is up. It's time to get this show on the road. I apologize if you were one of the ones that missed out.

I added all the entries to an Excel spreadsheet. Each participant was given a cell in the spreadsheet for every entry that they had. For example, Big Blogger was given 605 cells, Barbara Baker was given 236 cells, etc.

I then ran a randomizer function on the spreadsheet to shuffle the entries. The way it works is it randomly grabs a name from column A and copies it to column B. It does that for every cell in column A making sure that every name was grabbed.

A snippet of the end result is shown in the image in this post. If you would like to see the actual spreadsheet you can click here to download it. It will only be available for a short time then I'm going to delete it.

There were a total of 2009 entries. What I'm going to do now is use http://www.random.org/integers/ and have it generate a random integer between 1 and 2009. Whatever the result is, I will match it with the spreadsheet and select a winner.

After the 1st place winner is chosen, I will randomly pick another integer until I pick a name that is different than the 1st.

Stay tuned. Won't be much longer! Do you have butterflies?

Related posts:

  1. KwikStart MMO Contest Entries
  2. Blog Giveaway Contest Winners
  3. Gain Additional Entries For The KwikStart MMO Contest
  4. Contest: Win A Money Making Blog And Domain Name
  5. The Winner of GoodSync Pro

© Earn a living online in your pj's

Share this post:
http://keithjameslock.com/wp-content/plugins/sociofluid/images/digg_48.png http://keithjameslock.com/wp-content/plugins/sociofluid/images/reddit_48.png http://keithjameslock.com/wp-content/plugins/sociofluid/images/stumbleupon_48.png http://keithjameslock.com/wp-content/plugins/sociofluid/images/delicious_48.png http://keithjameslock.com/wp-content/plugins/sociofluid/images/technorati_48.png http://keithjameslock.com/wp-content/plugins/sociofluid/images/google_48.png http://keithjameslock.com/wp-content/plugins/sociofluid/images/myspace_48.png http://keithjameslock.com/wp-content/plugins/sociofluid/images/facebook_48.png http://keithjameslock.com/wp-content/plugins/sociofluid/images/yahoobuzz_48.png http://keithjameslock.com/wp-content/plugins/sociofluid/images/sphinn_48.png http://keithjameslock.com/wp-content/plugins/sociofluid/images/mixx_48.png

If you enjoyed this post, make sure you subscribe to my RSS feed!

 

Enter your first name and email address below to receive exclusive money making tips.
First Name:
Your Email:
Spam protection; double opt-in:
Using AWeber Autoresponder


N1WAY

One Response to “The Shuffled Entries Spreadsheet”

  1. DotDriven Says:

    Butterflies, yes :). Got my lucky rabbits foot as well!

    DotDrivens last blog post..Milk A Cow and Win An Iphone 3G (the newest and bestest iphone)


Leave a Reply