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.

Weekly schedule % complete.

3 replies [Last post]
nadeem syed
User offline. Last seen 40 weeks 3 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

Replies

Zoltan Palffy
User offline. Last seen 3 days 20 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
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

nadeem syed
User offline. Last seen 40 weeks 3 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.

Zoltan Palffy
User offline. Last seen 3 days 20 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

planned of what ?

what is your measuring stick 

assign manhours to each activity then you will know the answer