Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Remaining work in Task Usage screen

14 replies [Last post]
Mon, 2009-09-07 03:33
Willem Prinsloo
User offline. Last seen 10 years 8 weeks ago. Offline
Joined: 2 Jul 2009
Posts: 33
Groups: None
I want to see the remaining work in the task usage screen. It is not one of the fields available. Is it possible to view this anywhere?
Top

Replies

Tue, 2009-09-08 04:20
#1
Willem Prinsloo
User offline. Last seen 10 years 8 weeks ago. Offline
Joined: 2 Jul 2009
Posts: 33
Groups: None
I do use the schedule for cost. Thanks for that tip
Top
Tue, 2009-09-08 04:20
#2
Bo Johnsen
User offline. Last seen 8 years 6 weeks ago. Offline
Joined: 28 Feb 2006
Posts: 119
Groups: Building Information Modelling, Civil Engineering
...and change the column heading for "Cost" to "Remaining Work".

rgds,

Bo
Top
Tue, 2009-09-08 04:18
#3
Bo Johnsen
User offline. Last seen 8 years 6 weeks ago. Offline
Joined: 28 Feb 2006
Posts: 119
Groups: Building Information Modelling, Civil Engineering
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
Top
Mon, 2009-09-07 10:01
#4
Willem Prinsloo
User offline. Last seen 10 years 8 weeks ago. Offline
Joined: 2 Jul 2009
Posts: 33
Groups: None
I don’t have that function. Strange
Top
Mon, 2009-09-07 09:38
#5
Willem Prinsloo
User offline. Last seen 10 years 8 weeks ago. Offline
Joined: 2 Jul 2009
Posts: 33
Groups: None
prinsloowillem@yahoo.com I will mail you back with a screen shot
Top
Mon, 2009-09-07 09:28
#6
Willem Prinsloo
User offline. Last seen 10 years 8 weeks ago. Offline
Joined: 2 Jul 2009
Posts: 33
Groups: None
2007
Top
Mon, 2009-09-07 09:21
#7
Willem Prinsloo
User offline. Last seen 10 years 8 weeks ago. Offline
Joined: 2 Jul 2009
Posts: 33
Groups: None
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
Top
Mon, 2009-09-07 08:26
#8
Darren Kosa
User offline. Last seen 7 years 9 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
Willem,

OK I’m on the same page as you now, the simple answer is no I don’t 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
Top
Mon, 2009-09-07 07:06
#9
Willem Prinsloo
User offline. Last seen 10 years 8 weeks ago. Offline
Joined: 2 Jul 2009
Posts: 33
Groups: None
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.
Top
Mon, 2009-09-07 05:07
#10
Darren Kosa
User offline. Last seen 7 years 9 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
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
Top