locked
Ms project 2007 RRS feed

  • Question

  • The % complete for tasks in Ms project 2007, is it something that i manually should update or it should be auto as the project is progressing in time regardless of any intervention from my side?

    Thanks,

    Tuesday, June 7, 2011 4:44 AM

Answers

  • Roger,

    If you are not using Project Server and are using MS Project 2007 as a stand-alone product, then your options are limited to updating it manually, or using any third-party product to sync it to a sharepoint list or a central web application. You could also post an excel sheet, get it updated by team members, and then import it to MS Project.

    However, in my personal opinion, the key pieces to update the project schedule are the Actual Start, Actual Finish, and Remaining Duration (or work if you are measuring hours). Input these three and let the software calculate % complete for you. A team member is more likely to give you a better estimate of Remaining Duration, than an estimate of % complete.

    Also, refer to this link for some more ideas: http://amakar.com/microsoftproject-tips/50-how-to-update-the-project-schedule-objectively-in-ms-project

    http://www.gantthead.com/article.cfm?ID=220690


    Prasanna Adavi, PMP, MCTS Blog: http://thinkepm.blogspot.com
    Wednesday, June 8, 2011 4:55 PM

All replies

  • Hi Rdge,

    As you said, That you are using Project 2007. It all depends on the organization needs. If you are using My Time sheets & don't want to import them in project, You can manually update the progress of the tasks.

    If you are using My Task functionality, The task progress will be updated when a status manager approves the task updates & publishes the plan.

    If you are using both, I mean ..Importing timesheet in my task & then status manager is updating those in plan, It will be auto.

    Just for the ref a good article (Marc S - MVP) of pros n cons of the usages of both functionalities:

    http://marcsoester.blogspot.com/2008/03/project-server-2007-timesheets-goods.html

    Does that help?

     


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Tuesday, June 7, 2011 5:42 AM
  • Thanks Amit for your reply.

    What I need is that Ms project the software calculate the % complete while time is progressing and I can monitor accordingly.

    What I'm doing currently which is confusing on long term projects is that I'm updating the remaining duration which is reflecting the % complete and actual duration. Can you guide me to an auto calculation method for the % complete following the baseline duration or similar you may suggest?

    Cheers,

    Tuesday, June 7, 2011 6:14 AM
  • Hello Rdge,

    If you open MS project > File > Options> In project Options Window >Schedule > Calculate project After each edit (On /off),

    If you are updating the remaining duration of the task, The Project Engine will calculate the others on the basis of the formula:

    Percent Complete is a measure based on duration and Percent Work Complete is based on work. The two fields are calculated as follows:

    Percent Complete = Actual Duration/Duration (PC=AD/D)
    Percent Work Complete = Actual Work/Work (PWC=AW/W)

    If you are updating the Tasks in MS project (Only by My Tasks functionality with modifcation of renaming work by resources or importing TS in My tasks & status manager updating project), It will automatically update the project progress.

     


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Tuesday, June 7, 2011 6:52 AM
  • Rdge,

    If I understand you correctly. you want MSP to automatically update % complete, WITHOUT any input from your side? Please correct me if I am wrong.

    There is no way for the Project to 'automatically' update % Complete, without you supplying SOME kind of information ( Remaining Duration, Actual Work, Remaining work and so on).

    You probably could write a macro to do this, but do you really want Project to Show some % complete, without any connection to reality?

    Alternatively, if you are looking for a % Planned (Where I Should be), you can take a look at this: http://www.advisiconblog.com/2008/10/21/creating-a-standard-indicator-based-on-the-baseline/


    Prasanna Adavi, PMP, MCTS Blog: http://thinkepm.blogspot.com
    Tuesday, June 7, 2011 4:18 PM
  • Thanks Prasanna,

    I used the formula from your doc and it is helpful as it calculates the elapsed time and convert it into the % status supposed to be referring to baseline schedule. If you can help in clarifying the following that would be great.

    Current status:

    My tasks are scheduled and while project is progressing in time, I'm engaging the team on calls and assessing the percent completed of the tasks and how much time and work is left to close it and according I manually  update my project schedule and the % complete.  This is still manual and assumptions,

    Required:

    A better concept in managing and controlling my tasks progress for schedule & work accomplished?.

    Cheers, Roger.

    Wednesday, June 8, 2011 2:33 AM
  • Roger,

    If you are not using Project Server and are using MS Project 2007 as a stand-alone product, then your options are limited to updating it manually, or using any third-party product to sync it to a sharepoint list or a central web application. You could also post an excel sheet, get it updated by team members, and then import it to MS Project.

    However, in my personal opinion, the key pieces to update the project schedule are the Actual Start, Actual Finish, and Remaining Duration (or work if you are measuring hours). Input these three and let the software calculate % complete for you. A team member is more likely to give you a better estimate of Remaining Duration, than an estimate of % complete.

    Also, refer to this link for some more ideas: http://amakar.com/microsoftproject-tips/50-how-to-update-the-project-schedule-objectively-in-ms-project

    http://www.gantthead.com/article.cfm?ID=220690


    Prasanna Adavi, PMP, MCTS Blog: http://thinkepm.blogspot.com
    Wednesday, June 8, 2011 4:55 PM
  •  

    Thanks Prasanna, this was helpful.

    Roger.

    Thursday, June 9, 2011 1:05 AM