I hope I can be clear on this. I would like to use MS Project to track tests in our lab. We have what we call "Test Requests". I have several employees that will perform the work. I am trying to set up MS Project such that I can estimate completion dates, provide a view of what my people are working on, and their progress.
Here's the catch. I have about 130 of these Test Requests already in the queue. Some have been started, others are still waiting to be worked on. There will be more coming in on a daily basis.
The person who submits the request provides a desired completion date. I provide them with an estimate.
On MOST of the tests that we do, the completion DATE is always late because changes are asked for in the middle of the test. So for example if I enter Test 1234, it was requested back in Decemberr of 2007. Even though it will only take my worker about 14 working days to do the work, we still have this test open with an expected completion date of October of 2008. The reason is beyond our control, so it's not an issue, but when trying to show this in Project, it shows up as a project lasting 3 hundred or so days and when I try to show resources it shows this worker needing 300 days of work.
Is there a way to show his actual needed working days (let's say he's completed 25% of the job, so he's done 4 working days out of the 14, then he pauses for two months to do other things), can I show this in project, showing his actual work completed, but still show that the project won't be completed until some other date farther down the road?
I am looking at each project as unrelated to all the others. The only thing I might do in the future is link all projects from one technician.
I'm hoping for some advice. I have the project built up to a point in case anyone wants to see what I have.
Any advice or tips is greatly appreciated!