Forum Sponsor:

Portfolio Planner is software which improves portfolio, project and resource management.

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.

Weekly schedule % complete.

3 replies [Last post]
Mon, 2019-11-18 07:49
nadeem syed
User offline. Last seen 27 weeks 2 days ago. Offline
Joined: 15 Dec 2007
Posts: 10
Groups: None

Hi all,

Just wondering, in P6 if there is any way to get weekly planned schedule % complete in excel.

 

Thanks,

Kind Regards,

Syed

Top

Replies

Wed, 2019-11-20 14:55
#1
Zoltan Palffy
User offline. Last seen 22 hours 31 min ago. Offline
Joined: 13 Jul 2009
Posts: 2683
Groups: None

your scheduled % complete is  from your basline schedule it is the total planned mahours for the project divided by the cumulatived manhours up to that month

i.e. total planned manhours 100 

total cumulative manhours at the end of that month = 10 

therefore 100/10= planned 10% complete

Top
Tue, 2019-11-19 06:51
#2
nadeem syed
User offline. Last seen 27 weeks 2 days ago. Offline
Joined: 15 Dec 2007
Posts: 10
Groups: None

Hi, I have manhours assigned to each activity, what I'm trying to get in spreadsheet is literally Schedule % Complete, not budgeted units or remaining units or BL budgeted units.

Top
Mon, 2019-11-18 14:29
#3
Zoltan Palffy
User offline. Last seen 22 hours 31 min ago. Offline
Joined: 13 Jul 2009
Posts: 2683
Groups: None

planned of what ?

what is your measuring stick 

assign manhours to each activity then you will know the answer

Top