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.

Conditional formating

6 replies [Last post]
Thu, 2008-12-04 12:01
Glenn Douglas
User offline. Last seen 1 year 40 weeks ago. Offline
Joined: 22 Apr 2006
Posts: 39
Groups: Petro-Chem / Oil & Gas
Hi,

Is it possible ’in P6’ to set up a conditional format (similar to in Excel).
For e.g. when activity with Action Code ’P’ is 100% traffic light changes to green.

Cheers
G
Top

Replies

Mon, 2008-12-08 04:05
#1
Charleston-Joseph...
User offline. Last seen 2 years 39 weeks ago. Offline
Joined: 10 Jul 2005
Posts: 1347
Groups: None
Dieter,

There will be P7.

Oh my.

Then there might be some oracle influence in P7 considering that oracle completed the acquisiiton of Primavera

Cheers,
happy planning and scheduling
Top
Sun, 2008-12-07 06:08
#2
Ali Farhat
User offline. Last seen 13 years 42 weeks ago. Offline
Joined: 23 Oct 2008
Posts: 120
Groups: None
Glen, Dieter just gave me an idea
you can use job services to batch a report of all completed activities.
it is not visual but it might help
Top
Sat, 2008-12-06 03:13
#3
Dieter Wambach
User offline. Last seen 7 years 5 days ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Glenn
Just curious what you’ll do with the cat after...

Filters, bars can be attached to a layout - you’ll just have to open it. Reports can be saved.
Global change you’ll have to run each time you’ll need it. You are not the only to see a missing function.
Major German EPC-contractors and some construction companies asked Primavera to make a batch run possible for Global Changes which then can atomatically be started by "Job Services". Ask Primavera as well and you’ll raise the chance to include this in P7.

Regards
Dieter
Top
Sat, 2008-12-06 02:44
#4
Glenn Douglas
User offline. Last seen 1 year 40 weeks ago. Offline
Joined: 22 Apr 2006
Posts: 39
Groups: Petro-Chem / Oil & Gas
Thanks for your replies.
I’m sure there are various ways it can be done, (multae viae Romam meunt) or as we say in Yorkshire ’there’s more than one way to skin a cat’.

I was looking for a way that it would automatically update, mainly so that it can’t be missed and also would save a couple of minutes per week.

G
Top
Thu, 2008-12-04 17:22
#5
Dieter Wambach
User offline. Last seen 7 years 5 days ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Glenn
Traffic light.
- This might be a special bar in the Gantt chart: When you’ll add a new bar, you’ll have to assign a filter: if code = xx AND actual finish not= (blank).
- It might be a a special colour in a report. The technique will be equivalent but will require a little knowledge about reporting, because you’ll have to use the editor.
- With a user defined field type indicator: Use a global change equivalent to the bars.
- The traffic light function of myprimavera or P6web: There I don’t know a solution.

I’m sure, multae viae Romam meunt (Many streets lead you to Roma), i.e. there might be more solutions.

Hope, I understood your question.

Dieter
Top
Thu, 2008-12-04 16:20
#6
Ali Farhat
User offline. Last seen 13 years 42 weeks ago. Offline
Joined: 23 Oct 2008
Posts: 120
Groups: None
if i got you right, you can do it using global change
Top