my idea is to visualize the predecessors status in a column, in order to sort the tasks by this predecessors status (first 100% complete, next 0%). On this way, the user could see quickly the work which really can be started.
I am still trying different methods to solve this problem, such as macros Alexandre suggest.
Why are you not trying with Network diagram? I think that will help you to show the progress as well. Only thing you need to filter the required activity.
Member for
22 years 9 months
Member for22 years9 months
Submitted by Alexandre Faul… on Mon, 2005-05-16 09:30
MS Project does not have such a view that you wish.
It would take a macro to copy predecessor "name" and "%complete" fields in text fields on a specified task row where the resource is working on.
Philip,
MS Project slack is what makes the difference between critical and not critical tasks; I dont understand how a slack zero would make a task being completed: what about not started or not completed critical tasks?
A task is completed if it has a actual finish date or a %complete = 100, as MSP does not distinguish actual finish and %complete.
All the best
Member for
21 years
Member for21 years
Submitted by Philip Jonker on Fri, 2005-05-13 13:01
The normal way to see if an activity is completed, is to look at the float, or slack as referred to in MPS, I do not recall if they have this function. If the slack is blank, the activity is completed
Member for
20 years 6 monthsRE: Predecessors status on the same view
some activities may have more than one predecessor,you should think about how to sort by preducessors status.
I think you can save the project as Access database,then do it in ACCESS,it is more powerful than PROJECT for data processing.
Member for
22 years 9 monthsRE: Predecessors status on the same view
Alvaro,
If you want to sort the tasks by their predecessors being completed or not, you would better export data to Excel and finish your work there.
Hasta luego
Member for
20 years 5 monthsRE: Predecessors status on the same view
Thanks all,
my idea is to visualize the predecessors status in a column, in order to sort the tasks by this predecessors status (first 100% complete, next 0%). On this way, the user could see quickly the work which really can be started.
I am still trying different methods to solve this problem, such as macros Alexandre suggest.
Regards.
Álvaro.
Member for
21 years 3 monthsRE: Predecessors status on the same view
Alvaro,
Why are you not trying with Network diagram? I think that will help you to show the progress as well. Only thing you need to filter the required activity.
Member for
22 years 9 monthsRE: Predecessors status on the same view
I still dont understand.
When you set a non-critical task (one with free slack or one with total slack) to 100% complete,
a) the slack remains the same until the 1st successor has started
b) once the 1st successor has started, the slack is 0 (zero)
c) I tried several times with MSP 2002 US, you cannot have a "blank" Slack field, the NULL value is ZERO.
Did you get another result?
I would be interested to know.
I could send my test file to your email address if you want.
Alexandre
Member for
21 yearsRE: Predecessors status on the same view
Hi, I did not say zero slack, but the slack should be blank, ie no value in the column.
Member for
22 years 9 monthsRE: Predecessors status on the same view
Hi there,
Alvaro,
MS Project does not have such a view that you wish.
It would take a macro to copy predecessor "name" and "%complete" fields in text fields on a specified task row where the resource is working on.
Philip,
MS Project slack is what makes the difference between critical and not critical tasks; I dont understand how a slack zero would make a task being completed: what about not started or not completed critical tasks?
A task is completed if it has a actual finish date or a %complete = 100, as MSP does not distinguish actual finish and %complete.
All the best
Member for
21 yearsRE: Predecessors status on the same view
The normal way to see if an activity is completed, is to look at the float, or slack as referred to in MPS, I do not recall if they have this function. If the slack is blank, the activity is completed