Microsoft includes some columns in Project to help the user to keep track of things. The Unique ID (UID) column is included to to uniquely identify a task within a Project file. The GUID column uniquely identifies a task across all files. Both can be very useful when needed.
Subscribe To my Blog
Posts
All Comments
Sunday, December 28, 2014
Monday, December 22, 2014
Using the Compare feature of Microsoft Project.
One of the most useful features of MS Project I have found is the Compare feature. Compare is as you can guess, it compares one .mpp file with another. This is most useful when comparing two versions of the same file. The Compare feature is in Project 2010 and 2013. Project 2007 does not have a Compare feature. Project 2003 has a Compare, but it was removed in 2007. I have learned recently that there are situations where the Compare feature does not work in 2013. The fix seems to be to ensure that the Microsoft Patches are applied.
Monday, December 15, 2014
Why does Project move my tasks around when I assign a resource?
Some time ago, one of my colleagues came to me with a problem. He was updating a MS Project schedule (plan) by adding resources to the project tasks and every time a resource was added to the task, Project would physically move the task up or down in the schedule. This of course was very frustrating and wreaked havoc on the schedule. For Example; Adding a resource to the task in the 4th row, would move the task to the 10th row and renumber the Work Breakdown Structure (WBS) number and the ID number. It would also shift to another Summary task. Not a good thing.
I am often a asked questions on how Project works. I have used it for more than 20 years and over time I have become an expert. I often say that Project is un-intuitive and this case is a good example. "Why is Project moving my tasks around?" was his question to me. "I have never had this happen before." He added.
It took a while to find the answer. As I usually do, I asked for a copy of the file and went off by myself to investigate. I remembered that within Project one can sort on any column that one want to. When I checked the file sure enough, someone had sorted the file on the resource column. As resources were added Project would rearrange the tasks in Resource name order. Once I resorted the file using the ID column, everything worked fine. Resources could be added without changing the sequence of the tasks. My colleague was very happy. Here is an image of the fix.
First insert the ID column if it is not in the table and view. Then click on the down arrow at the top of the ID column and select "Sort smallest to largest" option - circled below. This will resolve the issue.
I offer this post as a help to other users of Project. I have learned a lot of what I know about Project the hard way; by making mistakes and trying different things. Project can be unintuitive, so remember that the learning curve is long and steep at times.
Some time ago, one of my colleagues came to me with a problem. He was updating a MS Project schedule (plan) by adding resources to the project tasks and every time a resource was added to the task, Project would physically move the task up or down in the schedule. This of course was very frustrating and wreaked havoc on the schedule. For Example; Adding a resource to the task in the 4th row, would move the task to the 10th row and renumber the Work Breakdown Structure (WBS) number and the ID number. It would also shift to another Summary task. Not a good thing.
I am often a asked questions on how Project works. I have used it for more than 20 years and over time I have become an expert. I often say that Project is un-intuitive and this case is a good example. "Why is Project moving my tasks around?" was his question to me. "I have never had this happen before." He added.
It took a while to find the answer. As I usually do, I asked for a copy of the file and went off by myself to investigate. I remembered that within Project one can sort on any column that one want to. When I checked the file sure enough, someone had sorted the file on the resource column. As resources were added Project would rearrange the tasks in Resource name order. Once I resorted the file using the ID column, everything worked fine. Resources could be added without changing the sequence of the tasks. My colleague was very happy. Here is an image of the fix.
First insert the ID column if it is not in the table and view. Then click on the down arrow at the top of the ID column and select "Sort smallest to largest" option - circled below. This will resolve the issue.
I offer this post as a help to other users of Project. I have learned a lot of what I know about Project the hard way; by making mistakes and trying different things. Project can be unintuitive, so remember that the learning curve is long and steep at times.
Subscribe to:
Posts (Atom)