Predecessors status on the same view

Member for

20 years 6 months
Permalink

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 months
Permalink

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 months
Permalink

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 months
Permalink

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 months
Permalink

I still don’t 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

22 years 9 months
Permalink

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 don’t 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

20 years 11 months
Permalink

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