Filtering for split tasks

M

MarkLNash

I have a large file which has been hacked by lots of different people. As a
result it is riddled with split tasks, which I am trying to sort out.

Is there an easy way to filter split tasks only?

There doesn't seem to be a field called "Split" and I can't find any other
useful field. I notice that the bar styles box allows styles to be filtered
for split tasks - so it can be done!

Any help would be appreciated.
 
G

Gérard Ducouret

Hello Mark,
The following formula works well for me (if you don't use "fixed duration"
as task type) :
IIf(ProjDateDiff([Start];[Finish])<>[Duration];1;0)
Introduce this formula in a number(x) field. Then create a filter to select
all the values = 1
May be some other people in this NG have a better idea?
Hope this helps,

Gérard Ducouret
 
M

MarkLNash

Thanks Gérard - works perfectly on a test file.

The problem is (there's always a problem isn't there), the file is set up as
fixed duration throughout, which sets the duration as the difference between
start and finish regardless of split or not.

Any other ideas? Anyone?

What I will do is set the type to fixed work, find the splits, set back to
fixed duration and correct the split tasks - but I am a bit worried about
finding unexpected changes going on. Or just print out the list of filtered
tasks and start again and cean up the original file.

Thanks again



Gérard Ducouret said:
Hello Mark,
The following formula works well for me (if you don't use "fixed duration"
as task type) :
IIf(ProjDateDiff([Start];[Finish])<>[Duration];1;0)
Introduce this formula in a number(x) field. Then create a filter to select
all the values = 1
May be some other people in this NG have a better idea?
Hope this helps,

Gérard Ducouret

MarkLNash said:
I have a large file which has been hacked by lots of different people. As a
result it is riddled with split tasks, which I am trying to sort out.

Is there an easy way to filter split tasks only?

There doesn't seem to be a field called "Split" and I can't find any other
useful field. I notice that the bar styles box allows styles to be filtered
for split tasks - so it can be done!

Any help would be appreciated.
Click to expand...
Click to expand...
 
J

John

MarkLNash said:
Thanks Gérard - works perfectly on a test file.

The problem is (there's always a problem isn't there), the file is set up as
fixed duration throughout, which sets the duration as the difference between
start and finish regardless of split or not.

Any other ideas? Anyone?

What I will do is set the type to fixed work, find the splits, set back to
fixed duration and correct the split tasks - but I am a bit worried about
finding unexpected changes going on. Or just print out the list of filtered
tasks and start again and cean up the original file.

Thanks again
Click to expand...

MarkLNash,
Unfortunately the split task property is not a field directly available
in a Project view. However, it is available via VBA. The following
simple VBA macro will do what you need (this assumes of course that you
don't use spare task Flag1 for anything else).

Sub Split_Finder()
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
t.Flag1 = False
If t.SplitParts.Count > 1 Then t.Flag1 = True
End If
Next t
FilterEdit Name:="SpltTsk", TaskFilter:=True, Create:=True, _
overwriteexisting:=True, FieldName:="flag1", Test:="equals", _
Value:="yes", ShowInMenu:=False, showsummarytasks:=False
FilterApply Name:="SpltTsk"
End Sub

Hope this helps.
John
Project MVP
Gérard Ducouret said:
Hello Mark,
The following formula works well for me (if you don't use "fixed duration"
as task type) :
IIf(ProjDateDiff([Start];[Finish])<>[Duration];1;0)
Introduce this formula in a number(x) field. Then create a filter to select
all the values = 1
May be some other people in this NG have a better idea?
Hope this helps,

Gérard Ducouret

MarkLNash said:
I have a large file which has been hacked by lots of different people. As a
result it is riddled with split tasks, which I am trying to sort out.

Is there an easy way to filter split tasks only?

There doesn't seem to be a field called "Split" and I can't find any other
useful field. I notice that the bar styles box allows styles to be filtered
for split tasks - so it can be done!

Any help would be appreciated.
Click to expand...
Click to expand...
Click to expand...
 
M

MarkLNash

Thanks John - that looks good. I will try it out immediately.

Thanks for your help.

John said:
MarkLNash said:
Thanks Gérard - works perfectly on a test file.

The problem is (there's always a problem isn't there), the file is set up as
fixed duration throughout, which sets the duration as the difference between
start and finish regardless of split or not.

Any other ideas? Anyone?

What I will do is set the type to fixed work, find the splits, set back to
fixed duration and correct the split tasks - but I am a bit worried about
finding unexpected changes going on. Or just print out the list of filtered
tasks and start again and cean up the original file.

Thanks again
Click to expand...

MarkLNash,
Unfortunately the split task property is not a field directly available
in a Project view. However, it is available via VBA. The following
simple VBA macro will do what you need (this assumes of course that you
don't use spare task Flag1 for anything else).

Sub Split_Finder()
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
t.Flag1 = False
If t.SplitParts.Count > 1 Then t.Flag1 = True
End If
Next t
FilterEdit Name:="SpltTsk", TaskFilter:=True, Create:=True, _
overwriteexisting:=True, FieldName:="flag1", Test:="equals", _
Value:="yes", ShowInMenu:=False, showsummarytasks:=False
FilterApply Name:="SpltTsk"
End Sub

Hope this helps.
John
Project MVP
Gérard Ducouret said:
Hello Mark,
The following formula works well for me (if you don't use "fixed duration"
as task type) :
IIf(ProjDateDiff([Start];[Finish])<>[Duration];1;0)
Introduce this formula in a number(x) field. Then create a filter to select
all the values = 1
May be some other people in this NG have a better idea?
Hope this helps,

Gérard Ducouret

"MarkLNash" <[email protected]> a écrit dans le message de
I have a large file which has been hacked by lots of different people. As
a
result it is riddled with split tasks, which I am trying to sort out.

Is there an easy way to filter split tasks only?

There doesn't seem to be a field called "Split" and I can't find any other
useful field. I notice that the bar styles box allows styles to be
filtered
for split tasks - so it can be done!

Any help would be appreciated.
Click to expand...
Click to expand...
Click to expand...
 
J

John

MarkLNash said:
Thanks John - that looks good. I will try it out immediately.

Thanks for your help.
Click to expand...

Mark,
You're welcome.
John
John said:
MarkLNash said:
Thanks Gérard - works perfectly on a test file.

The problem is (there's always a problem isn't there), the file is set up
as
fixed duration throughout, which sets the duration as the difference
between
start and finish regardless of split or not.

Any other ideas? Anyone?

What I will do is set the type to fixed work, find the splits, set back
to
fixed duration and correct the split tasks - but I am a bit worried about
finding unexpected changes going on. Or just print out the list of
filtered
tasks and start again and cean up the original file.

Thanks again
Click to expand...

MarkLNash,
Unfortunately the split task property is not a field directly available
in a Project view. However, it is available via VBA. The following
simple VBA macro will do what you need (this assumes of course that you
don't use spare task Flag1 for anything else).

Sub Split_Finder()
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
t.Flag1 = False
If t.SplitParts.Count > 1 Then t.Flag1 = True
End If
Next t
FilterEdit Name:="SpltTsk", TaskFilter:=True, Create:=True, _
overwriteexisting:=True, FieldName:="flag1", Test:="equals", _
Value:="yes", ShowInMenu:=False, showsummarytasks:=False
FilterApply Name:="SpltTsk"
End Sub

Hope this helps.
John
Project MVP
:

Hello Mark,
The following formula works well for me (if you don't use "fixed
duration"
as task type) :
IIf(ProjDateDiff([Start];[Finish])<>[Duration];1;0)
Introduce this formula in a number(x) field. Then create a filter to
select
all the values = 1
May be some other people in this NG have a better idea?
Hope this helps,

Gérard Ducouret

"MarkLNash" <[email protected]> a écrit dans le
message de
I have a large file which has been hacked by lots of different
people. As
a
result it is riddled with split tasks, which I am trying to sort out.

Is there an easy way to filter split tasks only?

There doesn't seem to be a field called "Split" and I can't find any
other
useful field. I notice that the bar styles box allows styles to be
filtered
for split tasks - so it can be done!

Any help would be appreciated.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking split tasks 2
Resource graph/total for a filtered set of tasks 0
How can I have only some tasks split by leveling? 6
Import split tasks 0
How to constraint parallel tasks execution 0
split almost all tasks on weekend 1
Filtering data from a non-continuous list 3
Split Task 9

Top