none
How can I keep the actual user time sheet after I set that task was finish (set to 100%) RRS feed

  • Question

  • Hi,

         I have this problem, after I change task to 100%, the actual working hour was  replaced by the planed working hour. and when the actual working hour for that task in that day higher than the plan, the plan has been replaced by actual. Because it very important to my organize for evaluate the performance of the user by compare actual time and plan. so the question is , 

         -BI have any feature for report about variance of actual and plan?,

              -if not what its do with actual and plan working hours?

         - How can I config to make it do not replace each other (actual <=> plan)

    Thanks

    ARkom Lueng.

    Sunday, August 22, 2010 3:27 PM

Answers

  • gu_ange --
     
    Your problem is caused by how you are entering progress in Microsoft Project.  If you manually enter 100% in the % Complete or % Work Complete field for a task, the software does the following:
    • The software sets the Actual Start date to the current Start date (it assumes the task started as currently scheduled).
    • The software sets the Actual Finish date to the current Finish date (it assumes the task finished as currently scheduled).
    • The software sets the Actual Work to the current amount of planned Work.
    From this description, I think you can see that your method of tracking progress is the source of the problems you are having.  The only way around this is to use a different method of tracking progress.  If you are manually entering progress for each task, you might enter information like Actual Start, Actual Work, and Actual Finish.  If the task took less work than currently planned, you can enter Actual Work and then decrease the Remaining Work to 0 hours to show the task finished early.
     
    Regardless, there is NO WAY to stop the software from doing what it is doing.  It is doing what it is programmed to do and it is working correctly.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Sunday, August 22, 2010 5:12 PM
    Moderator

All replies

  • gu_ange --
     
    Your problem is caused by how you are entering progress in Microsoft Project.  If you manually enter 100% in the % Complete or % Work Complete field for a task, the software does the following:
    • The software sets the Actual Start date to the current Start date (it assumes the task started as currently scheduled).
    • The software sets the Actual Finish date to the current Finish date (it assumes the task finished as currently scheduled).
    • The software sets the Actual Work to the current amount of planned Work.
    From this description, I think you can see that your method of tracking progress is the source of the problems you are having.  The only way around this is to use a different method of tracking progress.  If you are manually entering progress for each task, you might enter information like Actual Start, Actual Work, and Actual Finish.  If the task took less work than currently planned, you can enter Actual Work and then decrease the Remaining Work to 0 hours to show the task finished early.
     
    Regardless, there is NO WAY to stop the software from doing what it is doing.  It is doing what it is programmed to do and it is working correctly.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Sunday, August 22, 2010 5:12 PM
    Moderator
  • Mr. Howard

         How about. I set the baseline and then use actual start, actual work and actual finish compare with baseline. Is BI or OLAP cube can show any report about the different of each baseline and actual?

     

    Best Regard

    Arkom Lueng

    Monday, August 23, 2010 2:11 AM
  • gu_ange --
     
    I would recommend you also use Remaining Work in your tracking.  This allows you to show when a task finishes in less work than originally planned.  And yes to your last question.  You can compare Work vs. Baseline Work in BI and OLAP cube reports.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Monday, August 23, 2010 12:04 PM
    Moderator
  • Thanks, It help me so much..
    Tuesday, August 24, 2010 2:21 AM
  • gu_ange --
     
    You are more than welcome for the help, my friend!

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Tuesday, August 24, 2010 12:24 PM
    Moderator
  • Dale,

    I understand that the software "is doing what it is programmed to do. . . " Nevertheless, I yearn for more flexibility in reporting resource costs in PS 2010. If I understand correctly, gu-ange needs a separate determination of planned work apart from subsequent actual-hours modification or percent-completed adjustments.

    Following good project management practice, MS Project uses the estimate to completion cost curve, which replaces forecasted work now in the past with actual work reported. Benefit is increased accuracy in estimating final costs.

    Additional cost curves in resource forecasting (beyond the stock ones currently in PS 2010) have a business case. 

    For example, please consider a cost curve that uses planned work without taking actual cost of work performed into account. As project templates change to reflect business model revisions, this curve offers considerable merit for bottom-up resource projections. It is more flexible than consulting a static baseline for forecasted work. In no way does planned-work-only cost curve replace the usefulness of EAC. I suggest this cost curve to augment EAC for resource planning.

    Are you aware of any custom work to add such a curve to the existing application?

    For R&D work, where projects enter stage gates over multi-year periods, we can also use cost curves that take into account individual weighting at the task level derived from probability of success calculations across the portfolio. 

    I'd appreciate your comments, Dale. Thanks.

    --John 

    Tuesday, August 24, 2010 4:07 PM
  • John --
     
    I am not aware of any custom add-ons to Project Server 2010 that would allow the cost calculations you are seeking, but perhaps someone else in this Forum would know of something.  Sorry I cannot be of more help.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Tuesday, August 24, 2010 9:11 PM
    Moderator