Project Schedules With Google Spreadsheets

Creating software without a project schedule is likethe 'catch-all' for tasks which don't neatly fit into any of
driving a car without a seatbelt; it can be done, but thatthe other categories.
doesn't mean it's a good idea. Before we go anyI also like to create a 'summary and charts' page, but
further, I should say that this article isn't about why youthis is gilding the lily. I find that it's handy when my boss
should have a project schedule. If you need that kindasks me "how is the Widgets project going?" I can
of convincing, may I suggest a great article by Joelanswer "overall, its 92% done - we are on track". Its
Spolsky called Painless Project Schedules. In fact, thealso helpful knowing how many hours have been
style of project schedule I use is derived from hisallocated to different team members. One reason I do
method.this is because I have a bad habit of taking on too
What I would like to talk about is how Googlemany technical tasks which really should be going to
spreadsheets can be a real treasure when it comesthe production team (what can I say, I used to be a
to making your project schedules. Like many tales, thisprogrammer).
one begins with a cause to be championed. Not soHaving a project schedule is great, but the unfortunate
long ago, I worked at a company with threereality is that most people could care less about it.
programmers. It was my job to make sure projectsFrom my experience, upper management generally
were delivered on time and to spec. Resources at thisaren't that interested in the detail of the schedule, but
company were very tight. This meant that any timethey do appreciate its existence. They will more often
savings I could get by streamlining a process, I wouldbe interested in milestones and delivery dates.
go for.The other hurdle is getting programmers to use the
In the past I had used either Microsoft Project orschedule. Most of the time I've found programmers
Microsoft Excel for scheduling. Putting my projectaren't too keen on directly participating in the
schedules in Google spreadsheets offered a numbermaintenance of the schedule, but you must bring them
of perks. For one, the schedule was accessible frominto the fold. Programmers are far more interested in
anywhere anytime (home, office, mobile, etc). Anothercutting code, which is good - it's what they love to do
bonus was that multiple programmers could edit theirand what they are there for. So how do you get your
relevant areas without any sharing issues. Also gonetechnical people involved in the project schedule?
were concerns about backups and where on theBasic people management skills really. People will be
company server the file should reside.far more inclined to do something if you ask them to
If you look at the structure of the project schedule Ido it rather then order them to do it, and people are
use, you may think to yourself "it's so simplistic, surelymore inclined to do something if they are given some
that isn't enough to cover a complex project?" Butchoice in the matter. To a lesser extend, that often
really, what more do you need? You write down whatvague concept of 'ownership' comes into play here.
the task is, an estimate for how long it will take, who'sWhat I often say to the programmers I am working
meant to be doing it, and how much of it has beenwith is something along these lines; "Tony, when you
done.have time, can you please go into the project schedule
OK, you got me - this style of project schedule doesand update your areas. Also, for the life of this project,
have two major flaws. For starters, it's hard to figureI need you to go in at least once a week to update
out delivery dates, another problem is that its toughyour areas".
carving out distinct milestone. But where this style orOver the years, I've found this approach works very
project schedule shines is in task management, youwell for a number of reasons; there is 'choice' in there;
won't miss things, and as the saying goes "the devil issaying "when you have time" and "at least once a
in the detail". It's an excellent way for distributing tasksweek" leaves some breathing room for people to
to team members. It also provides a very goodmanage themselves. People are always happier when
overview of where you are at any given time within athey have options. The subtle wording; "your areas"
project.connects to ownership. It means the project schedule
Personally, I tend to create my project schedules withbelongs to them as well. Of course, never
only five phases (you can have more if you like). I'veunderestimate the power of manors - "thank you" and
found all tasks will fit into one of these categories:"please" always go a long way. There is a caveat with
wireframes/mockups, coding, project management,this approach however, it requires sincerity. People will
quality assurance, auxiliary tasks. Auxiliary tasks beingspot it if you are saying something you don't believe in.