Notification flags

I'd like to create a schedule of dates that move with the programme for notification periods flagging when to submit documentation. Example would be a method statement that needs submitting 20 days before the planned date that work starts. As the the programme moves with progress I want the submission date to move as well, but I don't want to clutter the programme as there will be many docs to submit at various times.

 

I don't want to use ALAP constraints with lags as they degrade the programme score, so I'm hoping P6 has a tool to generate this schedule elsewhere.

 

Alternative I guess is to export to Excel and manage it there, but I'd prefer not to do that as its extra steps where things can go wrong in translation.

 

Any ideas?

R
Rafael Davila 👤 Member for 22 years 3 months

I gave it a try using my software of choice and it worked as expected. The notification type is selected from a pull down of 3 values (empty/S/F) and the formula is applied automatically as specified, whenever a schedule run is executed.

Notifications01 photo Notifications01_zpsf9zesppc.jpg

Notifications03 photo Notifications03_zps31wtll4e.jpg

Notifications04 photo Notifications04_zpsvacoydkh.jpg

The formula is a bit tricky as I had to convert B into seconds, this you shall figure out.

Notifications02 photo Notifications02_zpspiqwntrp.jpg

Good Luck

R
Rafael Davila 👤 Member for 22 years 3 months

I do not use P6 but maybe you can try using a few User Defined Fields [UDF] along with a Global Change ...

    UDF1 UDF2 UDF3
Start Finish Notification_Type Notification_Lag Notification_Date
        To be updated using Global Change
    S/F/empty X(days) IF(Notification_Type ="S",Start-Notification_Lag,IF(Notification_Type ="F",Finish-Notification_Lag, ""))

You will have to figure it out the details on the global change formula.  Maybe P6 provides for UDF data validation and you can define it to be as per a pull down menu.

If it works as expected then you can filter Notification_Date by any date range.

Good luck

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts