Project Management Central

Please login or join to subscribe to this thread

Topics: Scheduling
How To Prevent Estimated Work Hours to automatically change when adding Actual Work Hours in Project Server
Network:197



Can anyone tell me how to prevent Estimated Work Hours from changing when entering Actual Work hours for a resource in Project Server?

For example: I estimated that Richard would work 172.5 hours in November. But Richard actually worked 150 hours. I enter 150 hours under Actual Work Hours and the Estimated Work Hours changes to 150. I need that number to remain as 172.5 so that at the end year and I'm reporting projected vs. actuals - I can have a record of what was initially estimated.

One possible solution I thought about was creating a Baseline Work Hours.

Please let me know if any additional information is needed.
Sort By:
Page: 1 2 next>
Network:128149



Hi Lea, Is it something that you can program manually. I believe should be a constraint that you introduce to planned MHRS which keeps them the same all the way for comparison purposes. That's what crossed my mind ....
...
1 reply by Lea Bongiovanni
Jan 11, 2016 9:20 AM
Lea Bongiovanni
...
Dear Rami,

Thank you for the suggestion. I'm going to try it and see if it works.

Best regards,

Lea
Network:106219



Hi Lea, can you tell me what view your use to update your actuals? Usually, when you enter the actuals, the remaining hours should change to the difference between the estimated and the actuals. Is it possible that you enter the actuals after the projected Finish Date? If so, it could be that Project Server, assumes the task is over and, thus, completed.
...
1 reply by Lea Bongiovanni
Jan 11, 2016 9:28 AM
Lea Bongiovanni
...
Hi Stephane,

I use the Resource Usage view and click on Ctrl F - (enter Resource Name) to view and enter Actual Work. I'm not entering the actuals after the projected finish date. But that's a good question. Yes, the remaining hours are changing to the difference between the estimated and the actuals.

Please allow me to elaborate on my initial question:

If I estimate that Resource A is going to work 166 in a month for Dev testing but actually Resource A works 150 hours. When I enter 150 in Project Server, Estimated Work hours change to 150. I want Estimated Work hours to remain 166 so that at the end of the year, when I have to provide an Actuals for the year and projections for the next year I can refer back to the original # of Estimated Hours.

Please let me know if any additional information is needed.

Thank you,

Lea
Network:85056



I agree with Rami and Stephane and I also would suggest to baseline your plan before you can start entering actual progress. Moreover if there is a change in plan resultantly, plan must be re-baselined and everything will turn out right.
...
2 replies by Lea Bongiovanni and Suhail Iqbal
Jan 11, 2016 9:31 AM
Lea Bongiovanni
...
Hi Suhail,

The entire project has been baselined. In theory I am in full agreement that if you re-baseline the plan everything will work out however in this case, because the baseline has been set at the EPMO level - I can't re-baseline the project as it will affect all other projects.
Jan 11, 2016 3:26 PM
Suhail Iqbal
...
If your project is being baselined at EPMO level and it affects other projects then you have to seriously consider who is managing your project, it is definitely not you but someone sitting in EPMO who might not have any knowledge of lower level details you are handling but you are unable to change even through proper change management procedures. If you do not have a mechanism to entertain change request, then you are doomed.
Network:197



Jan 08, 2016 3:28 PM
Replying to Rami Kaibni
...
Hi Lea, Is it something that you can program manually. I believe should be a constraint that you introduce to planned MHRS which keeps them the same all the way for comparison purposes. That's what crossed my mind ....
Dear Rami,

Thank you for the suggestion. I'm going to try it and see if it works.

Best regards,

Lea
...
1 reply by Rami Kaibni
Jan 11, 2016 3:35 PM
Rami Kaibni
...
You're Welcome - Let me know if this works please.
Network:197



Jan 08, 2016 6:36 PM
Replying to Stéphane Parent
...
Hi Lea, can you tell me what view your use to update your actuals? Usually, when you enter the actuals, the remaining hours should change to the difference between the estimated and the actuals. Is it possible that you enter the actuals after the projected Finish Date? If so, it could be that Project Server, assumes the task is over and, thus, completed.
Hi Stephane,

I use the Resource Usage view and click on Ctrl F - (enter Resource Name) to view and enter Actual Work. I'm not entering the actuals after the projected finish date. But that's a good question. Yes, the remaining hours are changing to the difference between the estimated and the actuals.

Please allow me to elaborate on my initial question:

If I estimate that Resource A is going to work 166 in a month for Dev testing but actually Resource A works 150 hours. When I enter 150 in Project Server, Estimated Work hours change to 150. I want Estimated Work hours to remain 166 so that at the end of the year, when I have to provide an Actuals for the year and projections for the next year I can refer back to the original # of Estimated Hours.

Please let me know if any additional information is needed.

Thank you,

Lea
Network:197



Jan 09, 2016 12:06 AM
Replying to Suhail Iqbal
...
I agree with Rami and Stephane and I also would suggest to baseline your plan before you can start entering actual progress. Moreover if there is a change in plan resultantly, plan must be re-baselined and everything will turn out right.
Hi Suhail,

The entire project has been baselined. In theory I am in full agreement that if you re-baseline the plan everything will work out however in this case, because the baseline has been set at the EPMO level - I can't re-baseline the project as it will affect all other projects.
Network:106219



I take it you enter the actuals in the grid section of the view? If so, make sure that you enter the time against Actual Work.

By default the Resource Usage view only shows and accepts Work values - which are, of course, your estimates.

Right-click on the grid and select Actual Work. That's the grid cell you want to enter the values in.
Network:85056



Jan 09, 2016 12:06 AM
Replying to Suhail Iqbal
...
I agree with Rami and Stephane and I also would suggest to baseline your plan before you can start entering actual progress. Moreover if there is a change in plan resultantly, plan must be re-baselined and everything will turn out right.
If your project is being baselined at EPMO level and it affects other projects then you have to seriously consider who is managing your project, it is definitely not you but someone sitting in EPMO who might not have any knowledge of lower level details you are handling but you are unable to change even through proper change management procedures. If you do not have a mechanism to entertain change request, then you are doomed.
Network:128149



Jan 11, 2016 9:20 AM
Replying to Lea Bongiovanni
...
Dear Rami,

Thank you for the suggestion. I'm going to try it and see if it works.

Best regards,

Lea
You're Welcome - Let me know if this works please.
Network:570



The discussion has migrated into two threads - one regarding Project Server and one regarding EPMO. Here is my feedback.

While I do not use Project Server, more data needs to be reviewed in conjunction with recording actual hours used by Richard in a month. The data might emerge by asking questions on Richard's activity, such as What is the status of the activity. How many hours are required to complete the activity. Why is there a variance on the actuals manhours vs scheduled manhours.

EPMO is maintaining a Program Master Schedule, which includes resource management to assure project assignments and availability of manpower are aligned. As needed, the EPMO may shift resources to maximize utilization, thereby reducing any overhead expenses from resources without assigned work. If Richard did not complete his activity, his resource assignment will be adjusted to the next month so the activity can be completed. Of course, this may means that a new activity by Richard on this project or another project may be delayed.
Page: 1 2 next>  

Please login or join to reply

Content ID:
ADVERTISEMENTS

"Work is what you do for others . . . art is what you do for yourself."

- Stephen Sondheim

ADVERTISEMENT

Sponsors