If you are not using resource curves, fancy calendars and your activity durations are not high, then you can use a custom data item and global changes formula below to have an approximate planned % for activity for schedule layouts.
Custom Data Item: PL%
GC1
PL% = (DD – PLST) / (PLFN – PLST)*100
GC2
If PL% < 0 then PL% = 0
GC3
If PL% > 100 hen PL% = 100
Assign a letter (“P” maybe) in tools-tabular reports-production
Assign PL% to a column in your layout. After every update run report series “P” and reorganize your layout.
I recommend having a second target and updating it manually which is much more accurate (This method neglects resource profile distortion due to calendars) but this is a quick solution. This algorithm can be also used in report writer and other stuff to have planned % for an activity for a specific data date.
Regards,
Safak
Member for
14 years 9 months
Member for14 years9 months
Submitted by walterjoy1978 on Mon, 2011-04-18 01:43
Its very simple. Here's how to generate % planned for each activity.
There are two schedules that you are actually managing in any given project who uses P3. First is the Baseline Schedule also known as theTarget schedule and the second is the Actual Schedule also known as the Current Schedule. In other words, your target/baseline schedule is your PLAN and the current schedule is your ACTUAL and FORECAST schedule. BEfore the DATA DATE your Actual Schedule and after the DATA DATE your forecast schedule So, below are the steps, just follow the following:
1. Close the current schedule and open the target schedule by clicking file, open and then click the file name of the target schedule in the file opening dialogue box.
2. Once the file opens, click Tools> update progress and enter the data date, Then choose all activities and click UPDATE.
3. After the progress was updated, click format column tool bar, and add a column named Percent Complete.
4. On this column the percent complete of every activity will appear. Since this is you target SCHEDULE or YOUR PLAN SCHEDULE, every percent COMPLETE therefore that appear on every activity is the % plan of every activity on this DATA DATE.
The Budget Summary form displays the planned value (BCWS) and earned value (BCWP). In earned value analysis, you can compare BCWP to the BCWS and to
the actual to date (ACWP).
The planned value reflects the work that should have been finished as of the data date according to the target plan; earned value measures the value of the work
actually accomplished as of the data date. The difference between these two figures is called schedule variance (favorable if the earned value exceeds the
planned value). The difference between ACWP and earned value is called cost variance (favorable if the earned value exceeds the actual cost).
copy past from P3 help ;)
regards
mimoune
Member for
16 years 10 months
Member for16 years10 months
Submitted by Althaf Mohamed on Tue, 2009-04-07 07:37
to get the accurate Planned % you have your schedule loaded with manhrs..then go to tools/reports/resources/tabular ..and choose all the resources,export this file to excel,then find your planned percentage by dividing the early usage(Cumm.) by the total man hrs then multiply by 100 %,you will get your planned percentage accurately based on physical progress,,also you can find the planned % for late schedule in the same way.
Member for
19 years
Member for19 years1 month
Submitted by Sandip Chakraborty on Tue, 2006-10-10 11:25
Take a copy of your project with no progress, a copy of the original baseline will do.
Then progress that project using the "update progtress" facility to the current data date. That means that every activity in the project will have a percent complete as if the project had been executed exactly as the baseline proposed.
Now make that project a Target, e.g. Target 2, of the current plan.
The field "Target 2 percent complete" is Planned percent complete.
Member for
19 years 7 months
Member for19 years7 months
Submitted by Karim Mounir on Mon, 2006-10-09 08:00
actually i dont know about the % planned which is automatically generated in MSP.
What i meant is that u have to monitor the actual progress in the same way u have planned for.
eg. if u want to monitor progress based on "Units of measure" then u have to load your baseline & updated schedule with the same "Units of measure".
Then after u completed your baseline u make for example S-Curve or a report for some activities having same "Units of measure" which will give u the planned % at a certian data date.
Member for
19 years
Member for19 years1 month
Submitted by Sandip Chakraborty on Mon, 2006-10-09 07:30
It depends on the method that u will use to measure the actual progress % (eg. u will measure the actual progress in the same way u will measure the planned progress of the baseline).
Member for
16 years 1 month<
<
Member for
17 years 5 monthsDear planners,If you are not
Dear planners,
If you are not using resource curves, fancy calendars and your activity durations are not high, then you can use a custom data item and global changes formula below to have an approximate planned % for activity for schedule layouts.
Custom Data Item: PL%
GC1
PL% = (DD – PLST) / (PLFN – PLST)*100
GC2
If PL% < 0 then PL% = 0
GC3
If PL% > 100 hen PL% = 100
Assign a letter (“P” maybe) in tools-tabular reports-production
Assign PL% to a column in your layout. After every update run report series “P” and reorganize your layout.
I recommend having a second target and updating it manually which is much more accurate (This method neglects resource profile distortion due to calendars) but this is a quick solution. This algorithm can be also used in report writer and other stuff to have planned % for an activity for a specific data date.
Regards,
Safak
Member for
14 years 9 monthsIt stands for Actual cost of
It stands for Actual cost of work scheduled.Its self explanatory .
Member for
16 years 1 monthGentlmen, Its very simple.
Gentlmen,
Its very simple. Here's how to generate % planned for each activity.
There are two schedules that you are actually managing in any given project who uses P3. First is the Baseline Schedule also known as theTarget schedule and the second is the Actual Schedule also known as the Current Schedule. In other words, your target/baseline schedule is your PLAN and the current schedule is your ACTUAL and FORECAST schedule. BEfore the DATA DATE your Actual Schedule and after the DATA DATE your forecast schedule So, below are the steps, just follow the following:
1. Close the current schedule and open the target schedule by clicking file, open and then click the file name of the target schedule in the file opening dialogue box.
2. Once the file opens, click Tools> update progress and enter the data date, Then choose all activities and click UPDATE.
3. After the progress was updated, click format column tool bar, and add a column named Percent Complete.
4. On this column the percent complete of every activity will appear. Since this is you target SCHEDULE or YOUR PLAN SCHEDULE, every percent COMPLETE therefore that appear on every activity is the % plan of every activity on this DATA DATE.
Hope this help. GOod Luck.
Pio
Member for
14 years 7 monthsGood day Do any one have a
Good day
Do any one have a formula for plan%
thank you
Member for
22 years 5 monthsRE: How to get % Planned for the baseline ?
If your schedule is resource loaded.
say cost: review your EVMS. Also you can generate in your resouce loading using cost.(use your baseline to generate this)
if using Manhours/mandays and its loaded in the BQ. lso you can generate in your resouce loading using resource.
Member for
19 yearsRE: How to get % Planned for the baseline ?
Review earned value
The Budget Summary form displays the planned value (BCWS) and earned value (BCWP). In earned value analysis, you can compare BCWP to the BCWS and to
the actual to date (ACWP).
The planned value reflects the work that should have been finished as of the data date according to the target plan; earned value measures the value of the work
actually accomplished as of the data date. The difference between these two figures is called schedule variance (favorable if the earned value exceeds the
planned value). The difference between ACWP and earned value is called cost variance (favorable if the earned value exceeds the actual cost).
copy past from P3 help ;)
regards
mimoune
Member for
16 years 10 monthsRE: How to get % Planned for the baseline ?
hi All,
Can anybody tell me What ACWS means Actual Cost of Work Scheduled.
PLZ do let me know if there is any thing like ACWS
Member for
16 years 10 monthsRE: How to get % Planned for the baseline ?
How do i calculate planned % of an activity (Based on what). is it Quantum of work ,Manhours, Cost or Duration.
Member for
20 years 6 monthsRE: How to get % Planned for the baseline ?
Dear all :
to get the accurate Planned % you have your schedule loaded with manhrs..then go to tools/reports/resources/tabular ..and choose all the resources,export this file to excel,then find your planned percentage by dividing the early usage(Cumm.) by the total man hrs then multiply by 100 %,you will get your planned percentage accurately based on physical progress,,also you can find the planned % for late schedule in the same way.
Member for
19 yearsRE: How to get % Planned for the baseline ?
Thanks a lot David...Got it now....
Member for
21 yearsRE: How to get % Planned for the baseline ?
Gosh, thought everybody knew how to do this.
Take a copy of your project with no progress, a copy of the original baseline will do.
Then progress that project using the "update progtress" facility to the current data date. That means that every activity in the project will have a percent complete as if the project had been executed exactly as the baseline proposed.
Now make that project a Target, e.g. Target 2, of the current plan.
The field "Target 2 percent complete" is Planned percent complete.
Member for
19 years 7 monthsRE: How to get % Planned for the baseline ?
Sandip,
actually i dont know about the % planned which is automatically generated in MSP.
What i meant is that u have to monitor the actual progress in the same way u have planned for.
eg. if u want to monitor progress based on "Units of measure" then u have to load your baseline & updated schedule with the same "Units of measure".
Then after u completed your baseline u make for example S-Curve or a report for some activities having same "Units of measure" which will give u the planned % at a certian data date.
Member for
19 yearsRE: How to get % Planned for the baseline ?
Hi Karim,
What i was asking was can P3 generate on its own the % Planned for each activity as per the baseline schedule ? Like MSP can do ?
Actual progress i will feed manually .....Hope am able to make my question clear to you ....
Regards
Sandip
Member for
19 years 7 monthsRE: How to get % Planned for the baseline ?
Sandip,
It depends on the method that u will use to measure the actual progress % (eg. u will measure the actual progress in the same way u will measure the planned progress of the baseline).
Regards.