How to add/modify columns in "view my tasks" of PWA

[Brian_of_WG]

Currently in our application task owners update their "% complete" in the
"view my tasks" screen. To help implement an earned value analysis approach,
I would like for a task owner to be able to enter both actual work (in
hours), and % complete. The % percent complete most likely will not be the
same as the actual work divided by scheduled work, but rather an estimate
based on the current situation and experience.
For example, a task owner may have just completed 8 hours of work on a task
scheduled for 16 total hours. However, if problems occured, the task may
actually only be 20% complete, not 50% as Project would automatically
calculate. I would like the task owner to be able to enter 8 hours actual
work completed AND 20% work completed.

 

[Dale Howard [MVP]]

Brian --

Project Server allows you to use one of three methods of tracking progress.
The Percent of Work Complete method allows team members to enter values in
the % Work Complete and Remaining Work fields. The Actual Work Done and
Work Remaining method allows team members to enter values in the Actual Work
and Remaining Work fields. The Hours of Work Done Per Day or Per Week
method allows team members to enter values in the Actual Work field in the
timesheet grid and in the Remaining Work field. You will notice that none
of these three methods of tracking will allow you to enter both Actual Work
and % Work Complete. Therefore, you cannot use Project Server as you wish.
Sorry.

 

[Marc Soester]

Hi Brain,

The work and % completed are linked, meaning that if you update the work the
% completed will also update. I understand your dilemma, but I dont think you
will be able to seperate the 2 fields. BUT you may have 2 different options
which are based on custom fields.

Option 1: ( should you like a visual indicator)
We have generated a PM flag ( based on traffic lights) that allows the PM to
give his opinion on the Project. The PM has the abillity to change the flag
from green to yellow or red if he believes that the Project ( or task) will
overrun.

Option 2: (should you like a value)
You can set up a custom field (maybe use number) allowing the PM to update
this custom field, which can of course be displayed in the Project Center of
Project Server. Since the custom field and % completed ( or actual work) do
not have a link, the PM can update the actual work and still update this
custom field ( you may want to call this something like "PM %complete").

Obiously both options are based on custom fields within Project ( and / or
Project Server).

I hope this will help

 

[Brian_of_WG]

Dale,
Using the administrative settings, I've tried setting the mode to actual and
remaining work as you've stated, I get a confirmation that settings were
accepted, but when i go back to the task page I can still only enter values
in the % and remaining work fields.
Assuming I can get this method to work, I could in my example put 8 hours in
actual, 32 hours in remaining and thus get a 20% completion. But what does
this do to the actual schedule and associated links? Project is fat dumb and
happy thinking everything is on schedule, but in fact the real project is
behind schedule.

 

[Brian_of_WG]

Thanks for your suggestions Marc. I like your 2nd option and that is in fact
what I was trying to do, but I'll be d__ned if I can figure out how to add a
clolumn to the task view. I've set up custom columns in Project itself, no
big deal. But PWA seems to fight me every step of the way. Any ideas?

 

[Gary L. Chefetz [MVP]]

Brian:

Project is, at its heart, a scheduling tool. A lot of folks do everything
they can to prevent Project from doing its job, because they don't
understand the scheduling algorithms.

To learn about changing the default tracking method, see:
http://www.projectserverexperts.com/Shared Documents/ChangeTrackingMethod.htm

 

[Dale Howard [MVP]]

Brian --

I did not recommend you change anything. I simply gave you an overview of
how the three tracking methods work. Since you changed the default method
of tracking, refer to the following link for information on how to proceed
from here:

http://www.projectserverexperts.com/Shared Documents/ChangeTrackingMethod.htm

If the % Complete is behind schedule, Microsoft Project does not
automatically reschedule uncompleted work from the past into the current
time period. You need to manually reschedule uncompleted work by following
the steps detailed in this link:

http://www.projectserverexperts.com/Shared Documents/RescheduleUncompletedWork.htm

Hope this helps.

 

[Dale Howard [MVP]]

Brian --

Refer to the following link for the steps needed to add columns to the
timesheet page in PWA:

http://www.projectserverexperts.com/Shared Documents/changetimesheet.htm

Hope this helps.

 

[Brian_of_WG]

It worked! Thanks Dale.

Brian --

Refer to the following link for the steps needed to add columns to the
timesheet page in PWA:

http://www.projectserverexperts.com/Shared Documents/changetimesheet.htm

Hope this helps.

 

[Brian_of_WG]

Gary, the info in the link seems to have worked. Thanks!

With regards to the scheduling algorithms: common sense and Microsoft are
mutually exclusive ideas, but I won't go there!

Cheers

 

[PedroJose]

Any ideas on how to do this (add a column to the timesheet view in PS2007)?
I actually got it done via custom fields, problem is that the data can be
entered but
it does not get saved (or may it does but i dont know where) and therefore
it does not flow through the project plan via the submit and approve and
submit process in PS2007... help!

 

[TLBartz]

How did you modify the timesheet view to add or remove a column in PS2007? I
am interested in knowing how this is done and how to make sur ehte data is
saved correclty and passed thru to the project.

 

[Joe]

How did you modify thetimesheetviewto add or remove a column in PS2007? I
am interested in knowing how this is done and how to make sur ehte data is
saved correclty and passed thru to the project.






- Show quoted text -

I have a enterprise custom field added to My Timesheet view:
1. Server settings > Enterprise Custom Field Definition > New Field >
Name the field, add it to a lookup table, etc...
2. Server settings > Manage Views > My Timesheet > Add Available Field

It shows up fine in the My Timesheet. In my case, we're using it to
keep track of Budget Codes for tasks.

However, recently the values of this column are not showing up in the
My Timesheet view. Values appear in the My Tasks column (where it was
also added to that view), and the column itself is present in the My
Timesheet view, but I can't seem to get the values to show up.

Any ideas would be greatly appreciated.