Prev: Summing colum content
Next: Project Queue
From: JRCB on 15 Feb 2010 19:19
I'm trying to create simple health checks for projects and want to detect
1) links to/from summary tasks and
2) resources allocated to summary tasks
I appreciate the summary tasks are 'virtual tasks' but it IS possible to add
links to them and allocate resources to them, both practices I want to detect
and discourage.
I would like to count instances and had envisaged using custom number fields
with formulae like
iif([resource name]<>"",1,0) or iif(Predecessor]<>"",1,0) to id resource /
links
but the values in resource name / predecessors aren't detected in this sort
of formula. Can anyone tell me a way round this please? (I have no vba
knowledge and would like a simple 'user interface' solution if possible thta
I can then use on Proj Svr 2007 environment.
Thanks in anticipation
From: JulieS on 15 Feb 2010 19:41
Hello JRGB,

I just did a quick test in two Flag fields:

IIf([Predecessors]<>"",Yes,No)

and

IIf([Resource Names]<>" ",Yes,No)

They both show what I think you are trying to test. The first
formula shows "Yes" if the task has a predecessor. The second
formula shows "Yes" if there are resources assigned.

I think the problem with your scenario is that you may not have
set the summary tasks to use the formula. Double check the
Customize Fields dialog and ensure you have set the option for
"Calculation for task group or summary rows" to use formula.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

On 2/15/2010 7:19 PM, JRCB wrote:
> I'm trying to create simple health checks for projects and want to detect
> 1) links to/from summary tasks and
> 2) resources allocated to summary tasks
> I appreciate the summary tasks are 'virtual tasks' but it IS possible to add
> links to them and allocate resources to them, both practices I want to detect
> and discourage.
> I would like to count instances and had envisaged using custom number fields
> with formulae like
> iif([resource name]<>"",1,0) or iif(Predecessor]<>"",1,0) to id resource /
> links
> but the values in resource name / predecessors aren't detected in this sort
> of formula. Can anyone tell me a way round this please? (I have no vba
> knowledge and would like a simple 'user interface' solution if possible thta
> I can then use on Proj Svr 2007 environment.
> Thanks in anticipation
From: John on 15 Feb 2010 19:54
In article <21DE0559-A697-4FB8-BAC3-0D6E41A7E048(a)microsoft.com>,
JRCB <JRCB(a)discussions.microsoft.com> wrote:

> I'm trying to create simple health checks for projects and want to detect
> 1) links to/from summary tasks and
> 2) resources allocated to summary tasks
> I appreciate the summary tasks are 'virtual tasks' but it IS possible to add
> links to them and allocate resources to them, both practices I want to detect
> and discourage.
> I would like to count instances and had envisaged using custom number fields
> with formulae like
> iif([resource name]<>"",1,0) or iif(Predecessor]<>"",1,0) to id resource /
> links
> but the values in resource name / predecessors aren't detected in this sort
> of formula. Can anyone tell me a way round this please? (I have no vba
> knowledge and would like a simple 'user interface' solution if possible thta
> I can then use on Proj Svr 2007 environment.
> Thanks in anticipation

JRCB,
Does it really matter how many there are? Any is to many, right? So
instead of messing around with customized fields why not set your view
to show the Predecessor, Successor and Resource Names fields and then
apply the built-in Summary Tasks filter. If there are any entries in
those fields, have a chat with the user responsible for the file.

That's my two cents.

John
Project MVP
From: Trevor Rabey on 15 Feb 2010 19:53
Yes. Some people think that just because the software allows bad modeling
they should do bad modeling.

No formula needed.
You don't just want to count them. You also want to find 'em and fix 'em.
Just use a custom filter (Project, Filtered For, More Filters, etc).
Best to give custom filters a prefix such as "AA..."
I have a number of diagnostic filters that I use all the time to untangle
and fix other peoples' mess, eg:

AA Tasks with no predecessors
AA Tasks with no successors
AA Tasks with predecessors with negative lag
AA Tasks with predecessors with positive lag
AA Summaries with predecessors - needs a two-condition filter, Summary =
Yes, AND predecessor not equal blank
AA Summaries with successors - similar as above
AA Summaries with resources

--
Trevor Rabey
0407213955
61 8 92727485
PERFECT PROJECT PLANNING
www.perfectproject.com.au

"JRCB" <JRCB(a)discussions.microsoft.com> wrote in message
news:21DE0559-A697-4FB8-BAC3-0D6E41A7E048(a)microsoft.com...
> I'm trying to create simple health checks for projects and want to detect
> 1) links to/from summary tasks and
> 2) resources allocated to summary tasks
> I appreciate the summary tasks are 'virtual tasks' but it IS possible to
> add
> links to them and allocate resources to them, both practices I want to
> detect
> and discourage.
> I would like to count instances and had envisaged using custom number
> fields
> with formulae like
> iif([resource name]<>"",1,0) or iif(Predecessor]<>"",1,0) to id resource /
> links
> but the values in resource name / predecessors aren't detected in this
> sort
> of formula. Can anyone tell me a way round this please? (I have no vba
> knowledge and would like a simple 'user interface' solution if possible
> thta
> I can then use on Proj Svr 2007 environment.
> Thanks in anticipation


 | 
Pages: 1
Prev: Summing colum content
Next: Project Queue