Solved

Help with MS Project. Tasks which take longer than actual working days.

Posted on 2008-10-15
4
379 Views
Last Modified: 2013-11-15
I am trying to get MS Project set up to work with my system of testing "tasks". Basically, each task is assigned a number, and takes XX amount of technician time. The problem is that the technician doesn't spend 100% of each day on the tasks, and sometimes there are gaps of weeks between when he works on tasks so that a task could go for months, but really only require a few days of labor.
Trying to get this to work out in Project so I can see what a persons work load is, plus provide estimates for when the work will be completed.
It's a special case.
This is sort of a continuation for bobsegrest.

Jeff
0
Comment
Question by:jeffrey_m_scharpf
  • 3
4 Comments
 
LVL 13

Accepted Solution

by:
bobsegrest earned 500 total points
ID: 22732910
Hi Jeff,

To figure this out we need to review what you are doing and the precise process you are following to get it done.

Start with the project plan that I reworked for you so that we will have a common reference point to start from.  If you don't have a copy of this file you can probably still download it from the previous question.

Now, starting with this reference point, tell me which line in your spread sheet you are trying to add as a new testing task to the project plan.

With these data points I should be able to talk you through the steps you need to take to create the new testing task.

If this isn't what you are trying to do, please explain what it is you are trying to do using the same two reference points.

Bob Segrest, PMP
MCITP, Miccrosoft Project Blackbelt
0
 

Author Comment

by:jeffrey_m_scharpf
ID: 22746977
Hi Bob.
Thanks for the response. I still have your project. I will start fresh with it and try to see what my first step is. I had a busy last few days so I will try to look at it this weekend.

Jeff
0
 

Author Comment

by:jeffrey_m_scharpf
ID: 22748075
Ok here it goes. I'm starting over with the file you provided. As I look at it now, it's viewing the "TR".
I will focus on the very first task that I am looking at.
So the first line item is technician "Stephan Blockel", TR27303.
So lets say we take just this TR.. Let me see..
1) Steve will spend 6 working days on this but I know that he won't spend 6 consecutive days at 100% of his time on this. Therefore, he may actually start a day earlier, or later, not sure yet. once he starts it, he may spend 20% of his day on this TR. Lets say he works one full day on this on the 24th.. then he works on other things for two days.. then on the 27th he works on it again for 1/2 day..

2) I want to look at Steves time his workload, what I've got schedule for him, so I want to sort by technician, and view resources if possible. All I ever see is some % that are insane..

3) Since I am trying to publish a schedule for the requestors, I don't want to tell them that it will finish on the 30th of October because I know it won't be done by then, even though it will only take 6 working days. Does this make sense?

4) The numbers in the left column. What are they? THe first line says "64".

5) Now lets say I want to sort by requestor so I can take just one section of tasks (for each requestor) and send them a report showing their specific tasks and when we expect to complete them.

Mainly my confusions are putting in finish dates that are farther out than what project calculates, checking a particular technicians workload (not sure if resources is what I should be looking at), then sorting by groups and moving columns if possible to group tasks by requestor (only for reporting, I don't need to link anything).
So that's where I'm at.  I think if I can understand these things better, I should be able to do the next thing which is adding new tasks and changing dates as time goes by and we have to adjust.

Jeff
0
 

Author Closing Comment

by:jeffrey_m_scharpf
ID: 31506594
THanks for all the help! I think I've got it covered now
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
When we talk about DevOps toolchains, I sometimes wonder how many people really get what we’re talking about. I don’t know if it’s just semantics or tone or something else, but sometimes I think it just sounds like buzzword sausage. So it’s always …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now