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.

Look Ahead Schedule Presentation

13 replies [Last post]
Henry Chiu
User offline. Last seen 10 years 42 weeks ago. Offline
Joined: 15 Jul 2011
Posts: 22
Groups: None

Dear Planners,

I have encountered a problem in filtering the  Look Ahead schedules wherein some of the activities that is ongoing does not appear on the look ahead schedule. in principle this must be shown. Tried to look into the samples of the look ahead schedule in P6 but seems it is not working.

Any help please.

 

Thanks

Replies

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

Timo,

What you are describing seems like project truncation, a functionality to my understanding not available in P6. Similar but not equal functionalities, one complement the other but are not a substitute of the other.

Activities in progress mean activities scheduled to happen on DD, can finish within the lookahead range or after.

When you are filtering for a lookahead you want to see the portion of the bars of these activities that occur before and or after the DD range. You want to know their past performance and future projection, different than when interested in truncation.

For a 14 days lookahead you need to filter for:

A) Activities in progress (starting before DD and finishing after DD)

........1. In progress (I believe it to be a predefined filter in P6 perhaps Activity % Complete is less than 100%), or

B) Activities starting within 2 weeks (does not matter when do finish); DD </= Start </= DD+14

........2. Start >/= DD, and 

........3. Start </= DD+14

Roger suggestion seems like will do it, he uses P6 and is following the functionality of the software.

I use Spider Project and use a filter to exclude [NOR] activities finishing before DD or activities starting after DD+14. This makes it easy to create a filter for any date range, an interactive filter available in some software but in this way you do not have to enter the dates every time, convenient to automate printing of report groups.

With truncation you isolate the duration, cost and resource usage outside the truncation range.

The following illustrates some of the differences between a range filter and truncation for Nov 14 to Nov 20 [ DD 11/07/2011  16:00]. Take a look not only at costs but also to remaining duration.

Photobucket

Best regards,

Rafael

Roger Booth
User offline. Last seen 4 years 14 weeks ago. Offline
Joined: 26 Oct 2006
Posts: 74
Groups: None

For lookahead schedules, I use the following filter

 

Where Early Start is less than or equals data date +2w (Change to what ever lookahead you wish)

and Activity % Complete is less than 100%

 

Hope that helps

 

Regards

AB Timo
User offline. Last seen 9 years 2 weeks ago. Offline
Joined: 22 Jun 2011
Posts: 108
Groups: None

hi jilani,

what You have Mentioned here is not for two weeks look ahead because when you Look at your 2nd condition "Activity Status=in Progress".It will show all the activities that are in progress till the end of the project.

 

Regards

Jeelani amin
User offline. Last seen 6 years 34 weeks ago. Offline
Joined: 4 May 2011
Posts: 6
Groups: GPC Qatar

Salam,

 

 

I hope u all r fine by the will of Almighty.Here is the filter formula for 3 weeks lookahead.

 

 

                 Parameter                        Is                                 Value                                

        Remaining Early start           in the range of                        DD                  

            High Value  

            DD+3w            

0R    Activity Staus                      Equlas                                  IN Progress.

( if u want to show on going activities in progress)

 

 

Regards

Jeelani

                                                 

Alex Alex
User offline. Last seen 6 years 22 weeks ago. Offline
Joined: 1 Jul 2008
Posts: 17

Hi Ashik

A 15 day lookahead filter can be:

Where Early Start is Within Range of |  CD  | CD+15d
Or Late Start is Within Range of | CD | CD+15

Ashik GB
User offline. Last seen 6 years 45 weeks ago. Offline
Joined: 10 Dec 2010
Posts: 27
Groups: None

Hello Planners,

 

Please help me out the filter formula for 3week or 2 week look ahead

 

Regards,

 

Ashik

Ron Beechey
User offline. Last seen 5 years 4 weeks ago. Offline
Joined: 13 Jun 2002
Posts: 61

Henry

 

Above is what we use and it will give the work through tasks that start before the start date and then have a duration longe than the 3 weeks.   It is 2 filters

T0-T2 - Date Range:


    Where (Any of the following)   
      Where Finish is greater than DD-20H 
    And Start is less than or equals DD+508H 

Simply sets thedate range

T0-T2 - Core:

    Where (Any of the following)   
      Where Activity Status equals In Progress 
      Or Activity Status equals Not Started 
    And (Any of the following)   
      Where Activity Type equals Resource Dependent 
      Or Activity Type equals Task Dependent 
      Or Activity Type equals Finish Milestone 
      Or Activity Type equals Start Milestone 
   

Try this and you may want to adjust as needed

 

Shah. HB
User offline. Last seen 15 weeks 1 day ago. Offline
Joined: 25 Nov 2008
Posts: 773

Hi Henry Chiu

 

You can try out by using following condition (If you are looking for 3 Weeks Look Ahead layout)

All of the following

Start Within range of DD DD+3W

Activity % Complete less than 100%

 

Cheer's

Shahul

Alex Alex
User offline. Last seen 6 years 22 weeks ago. Offline
Joined: 1 Jul 2008
Posts: 17

Henry, i guess your filter conditions to identify ongoing activities are not correct. For example,  your condition "Where Early Start is within range  DD  DD+3W"  will exclude many activities which had an early start before the data date but presently ongoing.

 

Gary Whitehead
User offline. Last seen 4 years 42 weeks ago. Offline

Henry,

 

Are you preserving early dates when resource levelling? If not, I don't see the need for both early and remaining ealry start in your filter?

An obvious thing to do would be to find one of the offending activities which is not being shown but should be, and investigate it's physical percent complete, early start, and remaining early start to see which condition it is failing on.

Marcus Love
User offline. Last seen 6 years 33 weeks ago. Offline

Hi Henry,

maybe try

Filter: All of the following

Activity Status is not equal to completed

remaining early start is less than  DD+xweeks

Henry Chiu
User offline. Last seen 10 years 42 weeks ago. Offline
Joined: 15 Jul 2011
Posts: 22
Groups: None

Hi Shahul,

 

Following filter is my condition

Where Early Start is within range  DD  DD+3W

Physical % Complete is not equal to 100%

Remaining Early Start within range DD+0D  DD+3W

With All of the Following is the condition

After imposing this filter some activities with progress and is ongoing is not shown. Our client planner noticed my presentation as incomplete. After our planning meeting, I then study how to show the ongoing activities but failed.

If I will add another condition Activity Status in progress - activity is empty

Thanks

 

 

Shah. HB
User offline. Last seen 15 weeks 1 day ago. Offline
Joined: 25 Nov 2008
Posts: 773

Hi Henry Chiu

Have a look at  filter condition you defined for look ahead layout.May i know the condition you defined ?

Cheer's

Shahul