Can be done in Spider, I was hoping P6 could. In the following portfolio each job have multiple calendars of their own as well as the portfolio. In this way non-work days such as Sept 24 will be considered as such in the calculation. CurTime is the field code for Project Data Date, not necesarily a code of my liking, but field name "Project data date" is. Creating a filter at the Activities View is a bit cumbersome so I would just sort Project Data Date and use earlier date for my filter start date, then sort field A and use latest date as my lookahead filter end date.
that does not matter that you only have one calendar what of you had multiple how would YOU program the software to use a specific calendar for a speciifc calculation it cant be done.
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Mon, 2020-09-28 14:39
that does not matter that you only have one calendar what of you had multiple how would YOU program the software to use a specific calendar for a speciifc calculation it cant be done.
There is only one standard calendar in all my projects so there should be no confusion on what is considered a working day. I thought there may be a setting in P6 that I was unaware of that distinguishes between using calendar vs working days when computing things like filters. All good. Thanks for all the answers.
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Thu, 2020-09-24 19:02
well thats doing what it should how could it posilbly use working days when you can have muiltiple calendars some 5 days some 6 days some 7 days. If you want working days then change it to DD+9d
Member for
21 years 8 months
Member for21 years8 months
Submitted by Rafael Davila on Thu, 2020-09-24 17:12
I used exactly as you have stated here DD(low value) DD+13d as the high value. The problem is that is counts 13 CALENDAR days rather than the 13 WORKING days that I expected from the calendar in our schedule (as we only work 5 days a week). I just thought it would automatically use the working days as the count.
Member for
21 years 8 months
Member for21 years8 months
Submitted by Rafael Davila on Wed, 2020-09-23 14:30
I am no longer a P6 user but suspect when you open multiple schedules at the same time the portfolio filters only can see a single data date, perhaps the earliest of the jobs opened. No matter what software you use portfolio management is more complicated than dealing with standalone jobs.
I suggest using DD as your look ahead start date while for the finish date of your look ahead filter use a fixed date. You can estimate the look ahead finish date as the latest DD + X(days) of the jobs to be opened and pluging it as a fixed date. Save the filter and any time you have to use it again consider changing the last date of your filter if need be. Maybe you can name it Portfolio Look Ahead + Xdays to distinguish it from your standard filter, mostly used for standalone jobs. Expect some of the activities/jobs included in your filter to show some progress. I hope this makes sense as I do not have access to P6.
Best Regards, Rafael
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Wed, 2020-09-23 13:49
Member for
21 years 8 monthsCan be done in Spider, I was
Can be done in Spider, I was hoping P6 could. In the following portfolio each job have multiple calendars of their own as well as the portfolio. In this way non-work days such as Sept 24 will be considered as such in the calculation. CurTime is the field code for Project Data Date, not necesarily a code of my liking, but field name "Project data date" is. Creating a filter at the Activities View is a bit cumbersome so I would just sort Project Data Date and use earlier date for my filter start date, then sort field A and use latest date as my lookahead filter end date.
An option can be to use SA Date Calculator.
http://scheduleanalyzer.com/sa_date_calculator.htm
Because calendars include exceptions such as holidays and vacations I do not use Excel for such calculations.
Member for
16 years 3 monthsthat does not matter that you
that does not matter that you only have one calendar what of you had multiple how would YOU program the software to use a specific calendar for a speciifc calculation it cant be done.
Member for
16 years 3 monthsthat does not matter that you
that does not matter that you only have one calendar what of you had multiple how would YOU program the software to use a specific calendar for a speciifc calculation it cant be done.
Member for
6 years 9 monthsThere is only one standard
There is only one standard calendar in all my projects so there should be no confusion on what is considered a working day. I thought there may be a setting in P6 that I was unaware of that distinguishes between using calendar vs working days when computing things like filters. All good. Thanks for all the answers.
Member for
16 years 3 monthswell thats doing what it
well thats doing what it should how could it posilbly use working days when you can have muiltiple calendars some 5 days some 6 days some 7 days. If you want working days then change it to DD+9d
Member for
21 years 8 monthsAny job can have many
Any job can have many calendars some global other project specific, so you have to tell the filter which, otherwise it would use consecutive days.
I do not believe P6 has a function to change the date by working day by calendar as Spider does.
Member for
6 years 9 monthsI used exactly as you have
I used exactly as you have stated here DD(low value) DD+13d as the high value. The problem is that is counts 13 CALENDAR days rather than the 13 WORKING days that I expected from the calendar in our schedule (as we only work 5 days a week). I just thought it would automatically use the working days as the count.
Member for
21 years 8 monthsI am no longer a P6 user but
I am no longer a P6 user but suspect when you open multiple schedules at the same time the portfolio filters only can see a single data date, perhaps the earliest of the jobs opened. No matter what software you use portfolio management is more complicated than dealing with standalone jobs.
https://docs.oracle.com/cd/E90748_01/client_help/en_US/helpmain.htm?toc.htm?schedule_a_project.htm
I suggest using DD as your look ahead start date while for the finish date of your look ahead filter use a fixed date. You can estimate the look ahead finish date as the latest DD + X(days) of the jobs to be opened and pluging it as a fixed date. Save the filter and any time you have to use it again consider changing the last date of your filter if need be. Maybe you can name it Portfolio Look Ahead + Xdays to distinguish it from your standard filter, mostly used for standalone jobs. Expect some of the activities/jobs included in your filter to show some progress. I hope this makes sense as I do not have access to P6.
Best Regards, Rafael
Member for
16 years 3 monthsyour filter should look like
your filter should look like this for DD + 1 week
any
where start is within the range of DD (low value) DD+1w (high value)
or finish is within the range of DD (low value) DD+1w (high value)
or activity status equals in progress
will be the same as DD+7 days
your filter should look like this for DD + 13 days
any
where start is within the range of DD (low value) DD+13d (high value)
or finish is within the range of DD (low value) DD+13d (high value)
or activity status equals in progress
will be the same as DD+ 13 days
Also make sure that your data date TIME is correct
can you please share the syntax in the filter that you used.