Converting man-hours in bodies

[Big_Bad_Yellow_Eskimo]

Is there an esay way to convert "man-hours" in bodies. I'm using MSP2003
grouping feature extensively. The reports generated are great but I was
recently asked to give a better (i.e. simpler) way of looking at the data. I
have proposed the obvious: converting "man-hours" in "bodies" (number of men)
required to do a job for example. Is this possible easily without having to
use a macro?

Regards,

 

[davegb]

Is there an esay way to convert "man-hours" in bodies. I'm using MSP2003
grouping feature extensively. The reports generated are great but I was
recently asked to give a better (i.e. simpler) way of looking at the data. I
have proposed the obvious: converting "man-hours" in "bodies" (number of men)
required to do a job for example. Is this possible easily without having to
use a macro?

Regards,

You could probably use a formula in a custom field to calculate FTE's
(bodies) from manhours. Depends on how complex you want to get.

 

[Big_Bad_Yellow_Eskimo]

OK. Then I need an example to start me up. What I would do is: use a text
field (Text20), customize it with a formula to perform the following:
Text20 => when a task is assigned to a specific [Resource Names], then take
the work hours assigned to that resource and divide it by 8. Does it sound
possible or am I dreaming?

Regards,

 

[MSPLearner]

As previously suggested, use a custom field to calculate FTE (Full-time
equivalent) by dividing hrs by say 2034 (approx work hrs in year or similar).

MSPLearner

 

[davegb]

OK. Then I need an example to start me up. What I would do is: use a text
field (Text20), customize it with a formula to perform the following:
Text20 => when a task is assigned to a specific [Resource Names], then take
the work hours assigned to that resource and divide it by 8. Does it sound
possible or am I dreaming?

Regards,

I don't have Project on this computer, so I can't check it now. I'm not
so sure about filtering by Resource Name before applying the formula.
That would be, if possible at all, the tricky part. Maybe someone else
more familiar with formulas could chime in here?

 

[John]

OK. Then I need an example to start me up. What I would do is: use a text
field (Text20), customize it with a formula to perform the following:
Text20 => when a task is assigned to a specific [Resource Names], then take
the work hours assigned to that resource and divide it by 8. Does it sound
possible or am I dreaming?

Regards,

Big_Bad,
As Dave said, it depends on how complex you want to go. First of all, if
you want to pull out the data for individual resources the formula will
get very complex in a hurry because you will need a nested "if"
statement to "dig" out each resource. Second, if there are multiple
resources assigned to a given task, a simple (or complex) formula will
not work because the assignment data (the part that tells you how many
hours applies to which resource) is not available in a task view (e.g.
Gantt Chart view).

Given those caveats a formula in a custom field may be possible, but,
for what you want to do, VBA would be much more efficient.

John
Project MVP