Very Scary Fall Giveaway for Excel Nerds Winners

Thanks for participating in the Very Scary Fall Giveaway for Excel Nerds! Your Excel horror stories were truly frightening, and the costume ideas were very creative. Thanks again to the generous prize donors:

A Bonus Prize for Every Participant

As a bonus for everyone who entered the giveaway, Patrick O’Beirne has an entertaining pdf file — “The Devil’s guide to creating spreadsheets.” If you’d like a copy, send me an email at ddalgleish @ and I’ll email you a link to the download.

And the Winners Are…

I did a random draw of prizes and entries, using the macro that I created for the Summer Giveaway for Excel Nerds. You can see the Summer video there, and download the macro sample file.
After the numbers were selected, I used VLOOKUP formulas to pull the prize names and winner names from the original lists of numbered prizes and entries. Congratulations to all the winners! Here’s the list:

Collect Your Prize

I’ll send an email to all the winners today, with instructions for claiming your prize. If you’re on the list of winners, and don’t receive an email by end of today, please let me know at ddalgleish @ or add a comment here.
Please reply by 5 PM (Eastern time zone) on Monday November 9, 2009, or your prize will be forfeited.

Very Scary Fall Giveaway For Excel Nerds

It’s time for another Excel giveaway! Hallowe’en is just around the corner, so let’s find out what Excel Nerds do to celebrate. I’ve been given some awesome Excel utilities, books, and ebooks to give away, so let’s have some fun. Rules are at the end of this article.
To enter, write an original (and suitable for work!) comment below, describing either:

  • A) an Excel related costume (real or imagined). For example, here’s a picture of my daughter and son, many years ago, ready for some trick-or-treating. My daughter was dressed as The Formula Doctor and my son was an early prototype of an Excel Web app. I’m sure they won’t mind me posting this picture, but if you see them, maybe you shouldn’t mention it. 😉


  • B) your scariest Excel related experience. I’m sure you’ve had horrifying days, buried under spreadsheets, and workbooks that come back to haunt you. Tell the other readers about one of those gruesome times. Remember, misery loves company. We’ll feel sorry for you, as soon as we stop laughing.

The submission deadline is 12:00 noon (Eastern Daylight Time) on Tuesday, October 27, 2009. Winners will be announced here on October 28th.
Note: You can make as many comments as you like, but only the first one will count as your entry.

The Ghastly Goodies

Some scarily smart Excel authors, developers and publishers have contributed a monstrous mound of books and utilities for me to give away as treats.
Thanks to all the contributors – Patrick “Ogre” O’Beirne, Jan Karel “The Creeper” Pieterse, Charley “Crypt-Kicker” Kyd, John “Walking Dead” Walkenbach, Jon “Petrifier” Peltier, “Chiller” Chandoo and Matt “Killer” Kennedy.

Systems Modelling Ltd

From Patrick O’Beirne of Systems Modelling Ltd


  • PATRICK’S TREAT for everyone who enters, a pdf file — “The Devil’s guide to creating spreadsheets” (I’ll email you a link to the download.)

JKP Application Development Services

From Jan Karel Pieterse, of JKP Application Development Services:

ProExcel2 VBA2007Dummies jkpDrive

ExcelUser, Inc.

From Charley Kyd of ExcelUser, Inc.


J-Walk & Associates, Inc.

From John Walkenbach of J-Walk & Associates, Inc.

  • one copy of the Power Utility Pak (PUP). — “Power Utility Pak Version 6 (PUP v6) is a useful collection of add-ins that brings significant new functionality to Excel. When PUP is installed, you can do things with Excel that you never thought were possible.”
  • The winner can select one of the two versions available:


Peltier Technical Services

From Jon Peltier, of Peltier Technical Services:

ptstilemekko ptstileboxplot ptstilecluster
ptstilewaterfall ptstiledot

Pointy Haired Dilbert

From Chandoo of Pointy Haired Dilbert

  • one copy of the newly released Project Management Bundle of templates for Excel — “The bundle contains 24 highly reusable excel templates for project planning, task management, timesheets, issue tracking, risk logging, status reporting and more.”
  • The winner can select one of the two versions available:


Apress Publishers

From Matt Kennedy of Apress, 2 prizes – e-books that you can download from the Apress website:

ProExcelVBA ProExcelFinMod


And finally, from Contextures – 3 prizes. The 3 winners can each select one of my pivot table books:

  • Beginning Pivot Tables in Excel 2007
  • Excel 2007 PivotTables Recipes
  • Excel Pivot Tables Recipe Book

BeginPT_2007 PTRec2007 PTRec

The Rigid Rules

  • To enter, submit an original (and suitable for work!) comment below, describing either an Excel-related costume or horrifying Excel-related experience
  • The comment must be submitted before the deadline of 12:00 noon (Eastern Daylight Time) on Tuesday, October 27, 2009
  • One entry per person – any additional entries will be deleted from the draw
  • A random draw will select each prize and its winner. No substitution of prizes.
  • Winners will be notified by email, so please provide a valid email address. This will not be publicly visible, but may be shared with the contest sponsors, so they can contact prize winners to arrange delivery.
  • Physical prizes will be shipped, postage paid, but taxes or other charges (if any) will be the responsibility of the recipient.