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.

Calender ( HELP !!! )

3 replies [Last post]
Question Answer
User offline. Last seen 9 years 7 weeks ago. Offline
Joined: 6 Mar 2014
Posts: 7
Groups: None

I actually need your help, How can i change my project Calendar ( Of Each activities ) from 10 hours to 8 hours without affecting the activities duration( Start & Finish date for each activities & the entire project ).i.e All activities will remain with the same start date & the same Finish date. My program initially should have a 8 h/day calendar but somehow i overlooked it and carried out on preparing my program based on 10 h/day calendar. Now due to the client’s requirement i have to change it to 8h/day calendar but i cant change the duration for activities as they have been agreed upon. I want the start date of each activities to remain the same likewise the finish date.

Replies

Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

unless you are looking at the TIMES meaning what time an activity starts and what TIME an activity finishes it really does not matter becasue a 1 day activty starts on that day and finishes on that day it does not matter if you work 8 hours per day or 10 hours per day it is all still that same day. 

Now the difference comes into play if you are using manhours to determine hoow many men that you need per day.

if you are using the duration type of fixed duration/units time then all lyou have to do is to make sure that you have a calendar that is 8 hours then filter for all activiites then add a column for the calendar (under general) then assign the firat activity to that clanedar in the column then do a fill down for teh rmainder of teh activities. This assigns your activities to the proper calendar.

The other thing that you need to do is to go to the project directory and and make sure that you project is highigthed click on the defaults tab and on the right had side choose the 8 hours per day calendar. This way any new activities added to the scheudle wil automatically be assigend to the correct calendar.

if you are using an duration type that that determines your duration based on manhours then you have anotehr problem. 

Tim Neobard
User offline. Last seen 7 years 18 weeks ago. Offline
Joined: 23 Apr 2013
Posts: 15
Groups: None

<ignore this, repeated below>

Tim Neobard
User offline. Last seen 7 years 18 weeks ago. Offline
Joined: 23 Apr 2013
Posts: 15
Groups: None

Do you have resources as well? If not, then you can do a global change.  Please make sure you backup a copy of the programme and baselines before doing this.  You will also need to manually extract the baseline.  If you do have resources etc, you will need to extract the programme to excel and manually change it there - I've personally not been in that situation as yet so I've not made a work around.

10/8 = 1.25

Therefore we need to divide all activities by 1.25.  But you cannot divide/multiple by fractions in P6 v8.2 (integers only, not floating point numbers).  Therefore we have to increase the original duration by a factor of 100 so that we can divide by 125.

Under the 'Where' section, you need to save the remaining duration after the first calculation.  You need to use the {custom} field to allow you to do maths.

I have used duration 1

Line 1 of "Then" section of global change.

Parameter:  Duration 1

Is: =

Parameter/Value: Remaining duration

Operator: *

Parameter/Value: {custom} (see below for value)

custom in this case is 100

2nd line

Then

Parameter: Remaining duration

Is: =

Parameter/Value: remaining duration

Operator: /

Parameter/Value: {Custom} set to 125

Apply the global change

You can now change the calendar to 8hrs and reschedule.

 

Anyone got a better way of doing it, give me a shout I always like to learn new things...

 

I've not played with changing units etc, but the below seems to work - I've bound to have forgotten something though...

You could change subject area in the global change to 'activity resource assignments' (top left box when you've created a new global change) - don't forget to backup just in case and make sure you check it's applied properly before doing lots of major changes.

Where (nothing)

Then:

Parameter: Number 1

Is: =

Parameter/value: Remaining units/time

Operator: *

Parameter/Value: 0.80 (numbers are floating point, durations are not)

AND

Parameter: Remaining units/time

Is: =

Parameter/Value: Number 1

 

Should do the trick assuming you've not progressed anything.