On-going tasks vs. a project....
Posted on 2006-05-09
I have been asked to help one of our project managers better manage their resources. Currently they put their tasks/people into an Excel spreadsheet in order to manage them. Naturally I cringe at this, because a spreadsheet is nothing more then an electronic piece of paper. So all they do is shuffle the pieces around manually via cut & paste. Ugly to say the least.
What I would like to do is put into MS Project, for managing projects and schedules I cannot think of any better tool. Years ago I used MS Project as a scheduler, and somehow I have been sucked back into again. I guess you cannot escape your past.
The problem I am having is that this on going process, not a project with any particular end point. The tasks are grouped by individual and the week they are slated to be done. I know that the formatting/grouping is beside the point as you can apply filters, sorting different ways etc. So I am not necessarily as concerned about the formatting of it. But I am not sure how to lay it out because of the on-going nature of this as opposed to a project.
The tasks themselves come in several forms:
- The first is a ticket, to do a particular task and be done with it.
- The second is a project that may go on for a while but the
resource works on it for x hours a week
- The third is a repetitive task such as support (15% of each resource’s
time is devoted to a particular area of support)
Any ideas would be appreciated.