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

 

 

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

  

Good day

 

Do any one have a formula for plan%

thank you

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

How do i calculate planned % of an activity (Based on what). is it Quantum of work ,Manhours, Cost or Duration.

Sandip,

actually i don’t 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.

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.