my mistake!"Remaining work" field does not exist in the Task Usage or Resource Usage details
and it is not possible to use a custom field instead
the only way to distribute the remaining work across the project duration is to export the data to Excel by using either File, Save As, Excel crosstab or MS Projects new Visual Reports
Alexandre
Member for
16 years 4 months
Member for16 years4 months
Submitted by Willem Prinsloo on Mon, 2009-09-07 11:01
Right click in the right hand pane of the screen, and select Remaining Work in the pop up menu; or select Details and set up the fields in a particular order from top to bottom
I would like to see it spread out over the project. In the columns to the rights. What I do now is subtract Actual Work from Work and that gives you the remaining work. The problem with this is that I have to do everything via excel witch leaves me vulnerable for mistakes.
Member for
16 years 4 monthsRE: Remaining work in Task Usage screen
I do use the schedule for cost. Thanks for that tip
Member for
19 years 8 monthsRE: Remaining work in Task Usage screen
...and change the column heading for "Cost" to "Remaining Work".
rgds,
Bo
Member for
19 years 8 monthsRE: Remaining work in Task Usage screen
Willem,
There is one way of doing it, although it is not "nice".
If you do not cost load your programme, i.e. the cost fields are empty, you can do like the following in the Task Usage view:
1) Introduce "Number1" being customized to "([Work]-[Actual Work])/60", also calculating for summaries
2) Copy "Number1" values into "Cost"-column by Paste Speciel / Paste Links
3) Change symbol for currency to "hrs" under Tools / Options / View
This should do the trick.
Regards,
Bo
Member for
22 years 9 monthsRE: Remaining work in Task Usage screen
Willem,
my mistake!"Remaining work" field does not exist in the Task Usage or Resource Usage details
and it is not possible to use a custom field instead
the only way to distribute the remaining work across the project duration is to export the data to Excel by using either File, Save As, Excel crosstab or MS Projects new Visual Reports
Alexandre
Member for
16 years 4 monthsRE: Remaining work in Task Usage screen
I dont have that function. Strange
Member for
16 years 4 monthsRE: Remaining work in Task Usage screen
prinsloowillem@yahoo.com I will mail you back with a screen shot
Member for
22 years 9 monthsRE: Remaining work in Task Usage screen
Willem,
very strange indeed!
are you sure you cannot display the Task Usage screen and right click on the word "Work" in the right hand pane? or double click on it?
Give me your email by Private Mail (click on the gray envelope close to my name) and I will send screen shots to you
Alexandre
Member for
16 years 4 monthsRE: Remaining work in Task Usage screen
2007
Member for
22 years 9 monthsRE: Remaining work in Task Usage screen
Willem,
which version of MS Project are you working with?
Alexandre
Member for
16 years 4 monthsRE: Remaining work in Task Usage screen
Alexandre
That specific option is not available. That is why I take Work and subtract actual work. Please send a screen shot if possible of it.
Regards
Member for
22 years 9 monthsRE: Remaining work in Task Usage screen
Willem and Darren,
"Yes you can" !
Right click in the right hand pane of the screen, and select Remaining Work in the pop up menu; or select Details and set up the fields in a particular order from top to bottom
Alexandre
Member for
17 years 9 monthsRE: Remaining work in Task Usage screen
Willem,
OK Im on the same page as you now, the simple answer is no I dont believe you can.
Unfortunately I think the only option you have is to keep on using Excel to generate the information you require.
Regards,
Darren
Member for
16 years 4 monthsRE: Remaining work in Task Usage screen
I would like to see it spread out over the project. In the columns to the rights. What I do now is subtract Actual Work from Work and that gives you the remaining work. The problem with this is that I have to do everything via excel witch leaves me vulnerable for mistakes.
Member for
17 years 9 monthsRE: Remaining work in Task Usage screen
Hi Willem,
Insert > Column and select Remaining Work from the Field name drop-down menu.
You can customise and alter any view this way.
Regards,
Darren