When you use Tools, Tracking, update project MSP assumes, because you have not told it otherwise, that all Tasks started as planned (on the Earliest Start Date) and continued up to the Status Date.
It is the wrong approach for what you are trying to do.
Use the Tracking Gantt and the Tracking Table so you can see what you are doing.
Use the Tracking Toolbar (the word Tracking for Gantt, Table and Toolbar is a giveaway).
Assuming your task started as planned and 10 days later, ie now or the status date, there is 10 Days of Actual Duration and 10 Days of Remaining Duration. Just type these into the Act Dur and Rem Dur fields. MSP will calculate 50% Complete for you.
If instead you just type in 50% Complete (recommendation: never do this), MSP assumes, because, as far as it knows, this is a 8 Day Task, you have done 4 Days so 4 days remain. Obvious?
This is going to feel like Project Planning 101, but I asked the questions so I could first get an understanding of how you update your project schedule with progress.
Personally speaking I don’t update MS Project using Tools > Tracking > Update Tasks/Project, because it doesn’t allow me to have total control over actual and remaining duration/work (effort) and I haven’t got the ’Split in-progress tasks’ option selected for similar reasons.
I find it important to differentiate between the duration and work/effort, because apart from cost, I always try and track project progress from two points of reference.
Duration - The period of time required to complete the task
and
Work or Effort - The total labour required to complete the task
To this end I tend to create a MS Project View to update progress and customise a copy of the Tracking table so it shows the following fields:
Name
Actual Start
Actual Duration
Remaining Duration
Physical % Complete
This way the actual start, the actual duration and remaining duration will always be correct. (I also use the same theory for updating actual remaining work, but in a slightly different manner) Have you thought about using a view like this?
I don’t pay much attention to % Complete either because as it uses duration as the basis for determining how far through a task you are, in my mind the only true % Completes are:
0% - The task hasn’t started
or
100% - The task is complete
Many of my current and previous project managers want to display progress as a %, so I use the Physical % Complete field for this purpose as it doesn’t change actual or remaining duration/work.
I’m not saying this is the only way to do a progress update, but MS Project can throw so many spanners in the works that I find if I keep it simple, I usually get the required results.
Spider Project is most functional and powerful professional project management software.
The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.
The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.
Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.
The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.
P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
Unifier-Loader - Load data into and out of Unifier via Excel
PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease
Create Radically Better Construction Schedules with ALICE Technologies
Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.
Thanks lads for your help
Rod,
When you use Tools, Tracking, update project MSP assumes, because you have not told it otherwise, that all Tasks started as planned (on the Earliest Start Date) and continued up to the Status Date.
It is the wrong approach for what you are trying to do.
Use the Tracking Gantt and the Tracking Table so you can see what you are doing.
Use the Tracking Toolbar (the word Tracking for Gantt, Table and Toolbar is a giveaway).
Assuming your task started as planned and 10 days later, ie now or the status date, there is 10 Days of Actual Duration and 10 Days of Remaining Duration. Just type these into the Act Dur and Rem Dur fields. MSP will calculate 50% Complete for you.
If instead you just type in 50% Complete (recommendation: never do this), MSP assumes, because, as far as it knows, this is a 8 Day Task, you have done 4 Days so 4 days remain. Obvious?
Hope the helps
Rod,
This is going to feel like Project Planning 101, but I asked the questions so I could first get an understanding of how you update your project schedule with progress.
Personally speaking I don’t update MS Project using Tools > Tracking > Update Tasks/Project, because it doesn’t allow me to have total control over actual and remaining duration/work (effort) and I haven’t got the ’Split in-progress tasks’ option selected for similar reasons.
I find it important to differentiate between the duration and work/effort, because apart from cost, I always try and track project progress from two points of reference.
Duration - The period of time required to complete the task
and
Work or Effort - The total labour required to complete the task
To this end I tend to create a MS Project View to update progress and customise a copy of the Tracking table so it shows the following fields:
Name
Actual Start
Actual Duration
Remaining Duration
Physical % Complete
This way the actual start, the actual duration and remaining duration will always be correct. (I also use the same theory for updating actual remaining work, but in a slightly different manner) Have you thought about using a view like this?
I don’t pay much attention to % Complete either because as it uses duration as the basis for determining how far through a task you are, in my mind the only true % Completes are:
0% - The task hasn’t started
or
100% - The task is complete
Many of my current and previous project managers want to display progress as a %, so I use the Physical % Complete field for this purpose as it doesn’t change actual or remaining duration/work.
I’m not saying this is the only way to do a progress update, but MS Project can throw so many spanners in the works that I find if I keep it simple, I usually get the required results.
Regards,
Darren
Did the task start when it was planned to have started? Yes
How do you ’reschedule’ a programme? Tools, Tracking, update project
What is the remaining duration? 4 days
Do you use actual and remaining work? (Effort? Please expand on this???
Is work on your project the same as duration? For most activities yes
Do you split in-progress tasks? I do not, but MSP does on reschedule
When MS Project calculates %Complete does it also update actual/remaining work? The formula is mathmatical rather than lets call it physical!
e.g. 8 days (1st Jun to 8 Jun) planned 10 days actual (1 Jun to 10 Jun) 50% complete
MSP schedules 4 days remaining, but the actual duration does not state 10 days, but 4 days!!!
Hi Rod,
A few of questions first and then Ill throw my two penneth in.
Did the task start when it was planned to have started?
How do you reschedule a programme?
What is the remaining duration?
Do you use actual and remaining work? (Effort)
Is work on your project the same as duration?
Do you split in-progress tasks?
When MS Project calculates %Complete does it also update actual/remaining work?
Regards,
Darren