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.

% Complete as seperate bar

15 replies [Last post]
Wed, 2005-06-15 04:31
Mary JoAnn
User offline. Last seen 17 years 11 weeks ago. Offline
Joined: 3 Mar 2003
Posts: 35
Groups: None
Forum Colleagues,

Here’s a brain tickler. This is not a planning question, but more software specific.

To answer my question, a brief intro & cross reference to MS Project is necessary.

In MS project, if we go to FORMAT > BAR STYLES, it is possible to make the % Complete for each activity appear below the activity bar ( Specify ‘Row’ = 2 for ‘Progress’) .

My problem is that I have been asked to produce a similar layout in Primavera (Activity bar on top & % complete as a bar below the Activity bar).

I would really appreciate a prompt response, as I need to produce the first report by tomorrow.

Many thanks in advance !
Top

Replies

Wed, 2005-08-31 03:12
#1
Milind Pandhare
User offline. Last seen 8 years 10 weeks ago. Offline
Joined: 29 Aug 2005
Posts: 54
Groups: None
HELLO FRIEND I AM MILIND
WHAT TYPE OF DOUBT U FOUNF IN PROGRESS CANTROL
U CAN COMPARE THE % COMPLITION IN PRIMAVERA P3
MAKE A CDI(COSTUM DATA ITEM) FOR EG PPC(pLAANNED % cOMPLETE) IN ACTIVITY COSTUM DATA

FOR / IN URS CURRENT PROJECT
GO FOR GLOBAL CHANGE
MAKE 3 GLOBAL CHANGES Tar 1 is urs Baseline program
1)PPC= 0 %
URS FORMULA IS
IF DD(Data Date) is less than T1ES (Target1 ES)
then PPC =0

2) PPC =100 %

IF DD IS Grater than T1EF (Target 1 EF )
Then ppc =100

3 If DD is Grater than TAR1 ES
& DD is Less than TAR1EF

(make &Q1 ,&Q2 to variable)

Then &Q1 = DD - TAR1 ES
&Q2 = &Q1 / T1OD ( tar 1 orignal duration)
PPC = &Q1 *100

After running all 3 sets of global change u will deffinatelty get the planned percentage complition at centen data date
or it is the estimated percentage comption to the baseline project
then u can campare the progress of the current project
with baseline Planned percentage complition
or mail me pandhare_milind@yahoo.co.in
i will explain u in brif how to do this in primavera
Top
Mon, 2005-06-20 07:12
#2
Mary JoAnn
User offline. Last seen 17 years 11 weeks ago. Offline
Joined: 3 Mar 2003
Posts: 35
Groups: None
Jaco,

You have been very helpful.

Thankyou very much.
Top
Thu, 2005-06-16 00:56
#3
Jaco Stadler
User offline. Last seen 17 years 30 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
Well just to Close this Thread and publish the Answer to all the Unbelievers.

Step 1 = Assign a Target Schedule
Step 2 = Format Bars (Delete All Existing Bars)
Step 3 = Create 2 New target Early bars (Position 1 & Poistion 2)
Step 4 = Bar 1 Remove Progress / Criticcal etc
Step 5 = Bar 2 Make Colour White & Show Progress
Step 6 = Show Progress By % Complete

And you have two bars just like MS.

If you want a Status Line (Go Out and Buy yourelf a Ruler/stencil/Pen)

Cheers

Top
Wed, 2005-06-15 14:23
#4
Philip Jonker
User offline. Last seen 15 years 23 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi Mary Jo,

Watch out fotr Jaco, the age old question, "does size count?", 740 kb
Top
Wed, 2005-06-15 06:35
#5
Jaco Stadler
User offline. Last seen 17 years 30 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
Hi Mary Jo check your email you should have an email with my email address in. Send me an email from this.

As to how to pp (private mesage) Next to my Name (Or any other )is a little envelope click on it and you send a short note to me (The person) the problem is you can not attache a File

740 KB

Cheers
Top
Wed, 2005-06-15 06:29
#6
Mary JoAnn
User offline. Last seen 17 years 11 weeks ago. Offline
Joined: 3 Mar 2003
Posts: 35
Groups: None
Thanks Jaco,

Now I am beginning to get confused. I better see your xls file.

How do I PP u my email id (can u give me yours & I send u a blank email). Whats the size of the file?

Thanks
Top
Wed, 2005-06-15 06:08
#7
Jaco Stadler
User offline. Last seen 17 years 30 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
Hi Mary

No one will not overwrite 2 because remember you apply different filters to them. (Filter 1 = Actualy Complete) Filter 2 In Progress.

% Complete (If % & RDU is Linked) will be up to data Date. Remember P3 Schedule your Current schedule (Recalculate your schedule). And your baseline is in a Target Schedule.


Cheers

If you want PP me your email and I can send you an XL file with Pictures


Top
Wed, 2005-06-15 06:00
#8
Mary JoAnn
User offline. Last seen 17 years 11 weeks ago. Offline
Joined: 3 Mar 2003
Posts: 35
Groups: None
Jaco,

I have 2 quick questions:

- wouldn’t doing 1.2 overwrite 1.1 ?

- As per your suggestions, it does appear that there is a possibility to show all ’progress’ upto Data date line for all -in progress activities. The idea here is to show actual % complete - it could be less than as required on data date.

Any suggestions ?
Top
Wed, 2005-06-15 05:41
#9
Jaco Stadler
User offline. Last seen 17 years 30 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
Hi Mary

It Takes you Five Minutes and you save the Layout. (Rememeber you use Global Change to do the date MODS once You have done it then in Future you Just Transfer it. (You don do it per Activity.)

PP me your email address and I will send you an Detail Explanition (With Pictures (Print SCreen) in xls)

Cheers
Top
Wed, 2005-06-15 05:38
#10
Mary JoAnn
User offline. Last seen 17 years 11 weeks ago. Offline
Joined: 3 Mar 2003
Posts: 35
Groups: None
Thanks for the reply Jaco.

You are absolutely right (and i fully agree with you) this requirement to have % Complete as a seperate ’bar’ BELOW the activity bar and not within the activity bar is purely an aesthetic need by a Non-technical person sitting in the chair of the BOSS.

An excuse like ’Software limitation’ is out of their disctionary.

The Custom bar option is too time consuming and difficult to implement for bigger schedules.

Does anybody have other ideas ??

I use P3 (not P3e).

Thank you
Top
Wed, 2005-06-15 05:19
#11
Jaco Stadler
User offline. Last seen 17 years 30 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
Hi Mary
This Function does actualy not make sense because in P3 Progress is between your actual start & DATA Date. (Schedule). IN MS it does not work this way except.

MAKE A COPY FIRST

But How to fix this (if you insist)

1) Make Two Global Changes.

1.1 = Make all completed activity
Planned Start = Actual Start
Planned Finish = Actual Finish

1.2) Make all Activity in Progress
Planned Start = Actual Start
Planned Finish = Data Date

2) Then you Create a bar Move it to Desired Position Make Start = PLST Make Finish = PLFN

And you have your second Progress Line

Then all you need to do is play with the Bars (Size & Position) until you have the required effect.

I hope this helps. (I Still think It Does not Make sense)
Top
Wed, 2005-06-15 05:05
#12
Mary JoAnn
User offline. Last seen 17 years 11 weeks ago. Offline
Joined: 3 Mar 2003
Posts: 35
Groups: None
How do u show % Comp as a ’custom bar’ ?
Top
Wed, 2005-06-15 05:02
#13
Mary JoAnn
User offline. Last seen 17 years 11 weeks ago. Offline
Joined: 3 Mar 2003
Posts: 35
Groups: None
Thanks for your prompt reply.

Can you elaborate more on what u mean as ’customizing the bar’ ??
Top
Wed, 2005-06-15 04:56
#14
Steven Oliver
User offline. Last seen 11 years 25 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
You could define a custom bar.

HTH
Top
Wed, 2005-06-15 04:52
#15
Jihad Daniel
User offline. Last seen 8 years 9 weeks ago. Offline
Joined: 7 May 2005
Posts: 99
Groups: None
Dear Mary,

If you are working on P3, it doesn’t have this option as the structure is fixed and defined for bars with dates (start & finish). What you can do only is to label below the activity bar with %.
However in P3e, this option is available and you can do it easily in the bar feature.

Hope this will help you completing your job.

Regards,
J. Daniel
Top