Still Building Production Schedules in Excel?
By Britta Alexander / February 25, 2009
Confession: Up until this week, I’ve been building production schedules in Excel. It’s something I started in my early 20’s at Ammirati Puris Lintas, where I wore miniskirts and three-inch heels and tracked 100 unique print ads a month for the Dell account.
(That was before my eventual transition down to the creative floor, where, as a copywriter, I wore red corduroys and green Nikes and got to hang out in the creative lounge dreaming up campaigns for Montblanc and Marriott. Life was much better on the 35th floor.)
After hammering out dates for a July launch only to realize that a September launch would make much more sense, I loathed the thought of reworking the entire schedule. Which is when my brilliant partner Ian informed me that everyone else in the office uses ConceptDraw to build their production schedules.
Is this a print vs. web thing?
Lured in by the pretty colored lines that show intersecting milestones, I downloaded ConceptDraw and got to work. I endured multiple crashes and some annoying usability issues, but I got through it. And the launch date still wasn’t quite right.
Which is when I realized just how much extra work I had been creating for myself as an Excel devotee (er, dinosaur). Because a Gantt chart calculates the total number of days for each project phase, all I had to do was plug in the new launch date and—presto magic!—the schedule updated itself. It even knew the difference between work days and weekends.
Sometimes it’s shocking to realize ways in which you are (i.e. I am) behind the times. I use Mint.com on my iPhone. I Twitter occasionally. We play Pandora in the office on our George. I’m a slave to Basecamp and Backpack for project management, and can even work my way around Dreamweaver. So why was I still using Excel for my production schedules?
Because that’s the way I’d always done it.
Which goes to show that just like our clothes closets (i.e. miniskirts and chunky heels), our Applications folders could use a seasonal assessment.
Meanwhile, I wonder if could still rock the red cords?
–Britta

April 30th, 2010 at 6:41 pm
One point I must make about choosing a web host or testing web hosting. Do not assume because your site has problems when you switch to a new host that there service is the problem. And don’t assume that your monthly fee of what ever will cover the time a host must spend on your transition. Sometimes database, php, apache, and apache mods, etc. are different versions and may cause different problems. In all seriousness you get what you pay for.