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.

The way Spider calculates phase duration

12 replies [Last post]
Evgeny Z.
User offline. Last seen 39 weeks 5 days ago. Offline
Joined: 13 Jan 2008
Posts: 442
Groups: None

Dear all,

I just noticd, that the way Spider calculates the duration of a phase is a bit strange for me, or at least this is not what I am used at MSP. 

 photo Project9_1_zpsva4oql63.png  photo Project9_1_MPP_zpspeuttpl8.png

1) Is there a way to show phase duration as the [date of latest activity] - [date of earliest activity]?

2) What is the definition of "Number of working days remaining?"

Replies

Evgeny Z.
User offline. Last seen 39 weeks 5 days ago. Offline
Joined: 13 Jan 2008
Posts: 442
Groups: None

Vladimir,

I upgraded to the latest version (11.03.103) and it works fine now

Regards.

Evgeny

Evgeny, I downloaded your project but can not repeat your results.

In my notebook everything works as expected. Very strange. Did you try Demo with this project?

Evgeny Z.
User offline. Last seen 39 weeks 5 days ago. Offline
Joined: 13 Jan 2008
Posts: 442
Groups: None

Vladimir,

thare was a typo in my original post. It is " In activity Gantt after scheduling". But the problem, that user filed displays results of the previous step calculation is still there

https://drive.google.com/file/d/0B1FBt_G3gCVqTUxVd2NlYjNmLWs/view?usp=sharing 

Why cost calculation? It should be schedule calculation. Duration is changing when project is rescheduled.

Evgeny Z.
User offline. Last seen 39 weeks 5 days ago. Offline
Joined: 13 Jan 2008
Posts: 442
Groups: None

Vladimir,

Ok, thanks. It works now.

I also set the flag for "Execute automatically => In activity Gantt after scheduling". But the strange thing, is that it shows the result of a previous calculation (of a calculation one step behind).

what I mean:

step 1; do scheduling 2 times

step 2: do resource constrained scheduling. Result: the user filed still shows previous value

step 3: do normal scheduling again. Result: user field now shows the value, which should have been shown in step 2

step 4:  do normal scheduling again. Result: now it shows correct value

 

Does it work the way it is supposed t?

Set My Duration field type to Numerical (yours is Date-Time).

Formula: A=Diff_Days_Calen (Fin ; Start ; "A")

Evgeny Z.
User offline. Last seen 39 weeks 5 days ago. Offline
Joined: 13 Jan 2008
Posts: 442
Groups: None

Vladimir, Rafael,

thank you for your responses.

 

RE "Elapsed duration may be easily calculated using formula (manually or automatically), so it does not make sense to create separate field for this data."

I must be doing something wrong, because I have created a user-defined field (myDuration) to automatically calculate such elapsed duration, but I can't make it work.

I use formula:

Diff_Days_Calen ( Fin ; Start ;A  )

Would anybody be able to have a look at it?

https://drive.google.com/file/d/0B1FBt_G3gCVqZV9TM0ktWGp1QVU/view?usp=sharingRegards.

Regards.

Evgeny

Rafael Davila
User offline. Last seen 16 hours 22 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

I hope my few illustrations add some visualization to Vladimir's words.

Best Regards,

Rafael

Rafael Davila
User offline. Last seen 16 hours 22 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

One way to visualize summary bar duration is to think abut Phase Detailed Bar that rolls up all activity bars within the phase.

Rafael Davila
User offline. Last seen 16 hours 22 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

Because Phase Calendar is the union set of all work hours it will be special and can be different to any child activity calendar, so it won't matte what it reads or to what you change it.  Take some time to create a 24-7 calendar assign it to the hammock ans see what happens to the phase duration, then change phase calendars and see what does not happens.

It works as intended but because of this maybe at phase level no calendar name shall be available.

PHASE DURATION 02 photo DPHASE02_zpsjx5rwcjz.jpg

Rafael Davila
User offline. Last seen 16 hours 22 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
  • 1) Is there a way to show phase duration as the [date of latest activity] - [date of earliest activity]?

Just add a Hammoack and you will get the following figure, it should not be difficult to figure it out Phase Duration represents the count of hours [not sum] during which any activity was performed during the phase.

If you look at Activity 1 Phase after adding the hammock additional hour count happened yielding 88 hours.

If you have a particular need for phase duration calculation add a user defined field and a formula, easier than creating hammocks, in this case it was just for illustration purposes.

phase hammock photo phase hammock_zpsg3umgbpf.jpg

By default phase duration is calculated basing on phase calendars and may differ from actual phase duration based on calendars of all activities and resources that belong to this phase. In any case hours and days when no activity of this phase is executed are not counted.

Spider also calculates total number of work days when the phase activities are excuted. This number is reflected in the field Number of working days. If an activity worked one hour in one day and another hour in the different day then the number of working days will be two. And again periods when no phase activity is executed are not counted.

Elapsed duration may be easily calculated using formula (manually or automatically), so it does not make sense to create separate field for this data.

I see that MSP shows elapsed duration and I don't see much sense in phase duration equal to 128 when total duration of all phase activities is 48. We try to apply the same approach to calculating both activity and phase duration counting work time only.