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.

Global change?

5 replies [Last post]
Tue, 2010-02-23 14:57
Carlos Arana
User offline. Last seen 5 years 33 weeks ago. Offline
Joined: 6 Jun 2009
Posts: 178
Groups: Civil Engineering
I’m trying to change all activities with DPH type "Duration" to "Productivity".

Any idea on how to change them all with a single command or do I need to change them one by one?

Saludos cordiales,
Carlos.
Top

Replies

Wed, 2010-02-24 03:29
#1
Vladimir Liberzon
User offline. Last seen 17 weeks 7 hours ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Carlos,
thank you for the movie.
We all need Global Change like this from time to time.
Saludos Cordiales,
Vladimir
Top
Tue, 2010-02-23 20:33
#2
Rafael Davila
User offline. Last seen 1 hour 49 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
Top
Tue, 2010-02-23 18:40
#3
Carlos Arana
User offline. Last seen 5 years 33 weeks ago. Offline
Joined: 6 Jun 2009
Posts: 178
Groups: Civil Engineering
Muchas Gracias Vladimir y Rafael!
I went with Vladimir solution but I think I will need to learn formulas and Reference books in the future.

Rafael:
Sure I can pay the Coronas, but have you tasted Negra Modelo? It is the "Créme de la Beer"

Saludos Cordiales,
Carlos.
Top
Tue, 2010-02-23 17:32
#4
Rafael Davila
User offline. Last seen 1 hour 49 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
If you want to be able to latter, at any time, to restore original values without resorting to the use of an older version:

1)     You can use formulas. Use one custom field to save actual values using a formula. Use another formula to set all values equal to productivity. Then by running at will your formulas you can switch back and forth.

2)     You can use Standard Reference Books, create a Standard Reference Book for Activities with the model as is make a copy to another version of your new Reference Book and apply your changes the way you want and then whenever you want you can restore your values. Be careful this is a powerful option that might restore other values. Recommend deleting from your Reference Book all fields except Activity Code and DPH Type. You can apply formulas to reference Books independently of your model. Once you learn how to use Reference books you will be hooked, it is more powerful than import/export to Excel.

Start with formulas, and then try with reference books as a learning exercise.

The following are Reference Books Screen print out.

Activties Ref Books

After that you pay the Coronas.
Top
Tue, 2010-02-23 17:17
#5
Vladimir Liberzon
User offline. Last seen 17 weeks 7 hours ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Very easy! Open Activity table and Select all by clicking left mouse button on the row numbers column header (it is empty). Then right click on any row number and select Properties. Now you can select those Properties that will be applied to all selected activities. Select DPH type Productivity and press OK. If you want to select only activities of Duration type apply Filter right clicking on DPH Type column header and then do what was described above. Saludos cordiales, Vladimir
Top