Predecessors status on the same view
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
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.
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
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.
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.
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
Hi, I did not say zero slack, but the slack should be blank, ie no value in the column.
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
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