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 spread in Resource Assignments

No replies
Luke Charet
User offline. Last seen 10 years 44 weeks ago. Offline
Joined: 25 Aug 2009
Posts: 18
Groups: None

It feels as though I have learnt 2 years of planning skills in 2 days reading through these forums, so I thought I would try my luck with another query.

In resource assignments I am trying to ascertain % complete instead of units using resource assignments. for example I currently have a bulk ew material resource, the resource assignment then allows me to see how many units (bcm) will be expended over time however I want to see % of remaining. I am currently using excel to do the spreading. I am expecting something like the top table, instead of the qtys on the bottom. Mind you it is not hard to do in excel but would be nice to use P6 instead

 

Activity 30-Apr-12 7-May-12 14-May-12 21-May-12 28-May-12 4-Jun-12 11-Jun-12 18-Jun-12 25-Jun-12 2-Jul-12 9-Jul-12
GLNG 651 (Day/Night) 1.95% 1.91% 1.82% 2.53% 2.53% 1.66% 1.89% 1.98% 1.55% 1.56% 1.38%
                       
Activity 30-Apr-12 7-May-12 14-May-12 21-May-12 28-May-12 4-Jun-12 11-Jun-12 18-Jun-12 25-Jun-12 2-Jul-12 9-Jul-12
GLNG 651 (Day/Night) 28800 36000 33300 43200 47634 30600 36000 43200 43200 43200 43200