That warm, fuzzy, spreadsheet feeling

Secret Blogger Santa is ready to rumble with 41 participants! It’s all very exciting and I can’t wait to see what kinds of fun gifts people create in the next few weeks.

However, the excitement of the moment lies in the information within those 41 rows of the spreadsheet I created for this little endeavor, just waiting to be uncovered. Oh, sure, we could have just forwarded people’s sign-up e-mails to their Santas, but we would have missed the fun inherent in sorting! Trending! Graphing! Mail-merging!

Allow me to demonstrate (click for larger versions):

In the following graph, we see that peaks of sign-up occurred on the announcement day and the day before the deadline of November 16. We can see that SBSers are both quick on the draw and benefit from a last-minute reminder, if necessary.

SBS Sign-up Frequency

When we examine the geographical distribution of United States-based SBSers (of the 39 participants who identified location), the most gifts will travel to New York (5), Minnesota (4), and Virginia (4). We also have 2 participants from our nation’s capitol — which was eerily excluded from this map — and 3 from outside the country!

SBS by State

From the personal tidbits SBSers provided to assist in the gift-buying process, we see that our pool of participants has quite a bit in common. SBSers are:

  • To the point: 5 directed folks straight to their blogs for gift ideas
  • Literary: 15 like to read (2 specifically mentioned Us Weekly)
  • Busy:
    3 like crafty things (4 appreciate cards, especially)
    2 enjoy scrapbooking
    3 enjoy cooking (relatedly, 2 love wine)
    3 like to travel
    2 write
  • In shape:
    4 love sports
    5 go running regularly
    2 practice yoga
  • Family-oriented:
    3 mentioned their children
    8 love dogs
  • Fans of color: 11 shared favorite colors
    3: pink
    3: purple
    2: green
    2: yellow
    1
    : blue

See how handy a spreadsheet can be? How else would we have known all of this invaluable information?

Check out the complete list of SBSers after the jump and see how you match up!

#51

- - - - -

A Truth Universally Acknowledged

Alex Year One

All or Nothing

Alyndabear

And You Know What Else

Candy’s Corner

Canned Laughter

Definitely RA

Fluent Brittish

Green Duckies and Other Tales of Dana

Heidi’s World

Hollow Squirrel

I Don’t Think It’s Going to Rain

Jummy

Kellybeans!

Kristabella

La Dolce Vita

LizLand

Looking for the Silver Lining Since 1979

Love is Blonde

Made in Richmond

Marie Millard

More is Better

Musings of a Semi-Coherent Mind

My Life as a Hotfessional

Old Guys Dig Me

Perks of Being a JAP

Sangria Lover

Sass Attack

See Jane Blog

She Likes Purple

SoMi

SVR

The Good Kind of Dorky

The State that I Am In

The True Tales of a Caffeine Addict

Thirty Before 30

This Corner of the Earth

Titansphere

Unnaturally Blonde

WTF Have I Done??

17 comments

#1 Laurel on Tuesday, November 20, 2007 at 3:29 pm

I really hope that the blogger behind “She Likes Purple” is one of the two who listed purple as their favorite color!

Ha - I think she was, and I think it was the first thing she listed. :)

#2 Laurel on Tuesday, November 20, 2007 at 3:29 pm

Also, New York and Minnesota FOREVER.

Yeah, I knew you’d appreciate that.

#3 Jummy on Tuesday, November 20, 2007 at 3:46 pm

Wow! 41 people - I think i’m going to discover some new blogs.

Is it too late to include some of the things I like? I know how much I’ll appreciate knowing my blogger’s likes/dislikes so I’d like to return the favour!

Nope, as long as you can get it to me before Thanksgiving, that will be okay. As of Friday, ALL IS FINAL.

#4 Operation Pink Herring on Tuesday, November 20, 2007 at 4:19 pm

Holy cow! I love spreadsheets, but your graphs take it to a whole new level! So impressed.

Thank you, thank you very much.

#5 Erin on Tuesday, November 20, 2007 at 7:15 pm

41 bloggers! How exciting! This is going to be so much fun….and I just love those graphs. :)

I know, I’m so pleased at the great response!

#6 Lisa on Tuesday, November 20, 2007 at 8:17 pm

I LOVE DATA. I love data. This was quite enjoyable. (One thing though- people associate intensity of hue with higher numbers. So on the graph it looks like red is the highest). I love the matchingness of the colours you chose, though! Can;t wait to find out who my blogger santa is! Thanks for arranging this.

Yeah, I fiddled with the colors for longer than I should have, but then I just decided to chuck it all and go for the aesthetic. In hindsight, though, I could have just used shades of red since the other graph is all green. But at that point, it was just too late, you know? I had to cut my losses.

#7 Julie on Tuesday, November 20, 2007 at 8:49 pm

THIS IS SOOOOO EXCITING!!!

I love the graphs!!!

Yay!!! :)

#8 nicoleantoinette on Tuesday, November 20, 2007 at 10:16 pm

I’m SO EXCITED for Secret Blogger Santa! Weeee!

I’m so glad that people are so psyched!

#9 -R- on Tuesday, November 20, 2007 at 11:50 pm

Dude! I didn’t include a list of things I like. For future reference, my favorite color is yellow. Carry on!

No, problem, I’ll add that to the spreadsheet! Must update trends list, too…

#10 alyndabear on Wednesday, November 21, 2007 at 1:56 am

I LOVE that I now have a whole new batch of blogs to read/stalk.

Thanks for putting together the list!

Oh, stalk away! Please let me know if any of the links are wonky. Toward the end of it, my eyes were glazing over.

#11 Anna on Wednesday, November 21, 2007 at 8:42 am

While I may fall into the quick on the draw category, I certainly don’t do too well on the follow through - I forgot to say anything in terms of what I like or dislike.

Oh well, I’m pretty easy to please.

Hey, that works, too.

#12 janet on Thursday, November 22, 2007 at 12:35 am

RA, you are too cool. See, what makes you a nerd in the real world makes you cool in the blogging world! I can’t wait for SBS (yes, I said it, I am EXCITED)

Woo for nerdiness! I’m so glad you are excited! No one can call you a Scrooge now.

#13 Brittany on Sunday, November 25, 2007 at 11:27 pm

Wowie! 41 people! That’s fantastic.

(and I only know, like, 4 of them so I better get some new friends)

Isn’t it fun to have the prospect of all these new people? Love it.

#14 heidikins on Monday, November 26, 2007 at 1:56 pm

Ooooh! Love it! Am so excited for this! xoxox

Yay! I’m so glad that I cornered you into signing up! :)

#15 DM on Tuesday, November 27, 2007 at 7:35 am

Very, very excited and feeling like a complete dork. My blog is greenduckies.blogspot.com. My email address is greenduckiesgirl and so I get those mixed up all the time. Sorry about the mistake!

Oh, no problem. I’ll update the link for you!

#16 Audrey on Wednesday, November 28, 2007 at 4:21 pm

I am super impressed with your graphing skills. That’s a whole new level of SBS fun!

Which makes it superfun, right? Right?

#17 Scarlet on Saturday, December 1, 2007 at 11:53 pm

I guess now I should write something interesting. Hmm.

Love the spreadsheets!

Ha. Interesting is always good. :)

Leave a comment

  • Kitchen Crusader

    Testing driving new recipes this summer!

  • Favorites for July

  • A quiet snapshot
  • On the Plateau
  • Collecting and filing
  • ---
  • See all favorites
  • At this time last...

  • Week: Ted's new digs
  • Month: Lemon basil pasta salad
  • Year: Dog daze
  • Widget_logo
  • Google

  • Categories

  • Archives





  • 20sb