SPI and CPI

[Procekt]

Hi:

I am stuck in 2 issues. Any kind of help is greatly appreciated.

1. I am trying to calculate CPI and SPI through creating a new column and
then creating the formula manually. (I don't have version 2003). No problem
until here.
However, after calculating the values for each task, MS Project displays an
integer value which is either 1 or 0. Does anybody know how to display these
value up to 2 decimals, somehting lik 1.00 or 0.94 or 1.03 etc.

2. As a resource I am using a group of people instead of a single person.
(Since their payment is made accordingly). This group of people are assigned
multiple tasks in any given duration. They have the capacity to perform
multiple tasks in any specific day. By default, MS Project thinks that if you
assign doble task to this group they overallocated. ( by %200, %400 or %800).
Thus, Their total cost overall sums up to $80000 instead of $40000. I tried
to manipulate this manually by changing the max unit levels to higher values
or assigning a %50 workload if they have two different tasks in a single they
but could not overcome the problem.

I hope I was clear enough.
Thanks

 

[Gérard Ducouret]

Hello,

Question 1 :

Try to put your formula in a Text(x) field and use the function Format such
as :
Format([SPI];'0.00')
It works for me. But your list separator may be "," instead of my ';'

Question 2 :
??
I could look at your resource's problem if you send me the mpp file.

Gérard Ducouret

 

[Procekt]

Thanks for the help!
can you please send me an e mail at : (e-mail address removed) so that I can get
back to you in more details.

Tkank you

Hello,

Question 1 :

Try to put your formula in a Text(x) field and use the function Format such
as :
Format([SPI];'0.00')
It works for me. But your list separator may be "," instead of my ';'

Question 2 :
??
I could look at your resource's problem if you send me the mpp file.

Gérard Ducouret

Hi:

I am stuck in 2 issues. Any kind of help is greatly appreciated.

1. I am trying to calculate CPI and SPI through creating a new column and
then creating the formula manually. (I don't have version 2003). No problem
until here.
However, after calculating the values for each task, MS Project displays an
integer value which is either 1 or 0. Does anybody know how to display these
value up to 2 decimals, somehting lik 1.00 or 0.94 or 1.03 etc.

2. As a resource I am using a group of people instead of a single person.
(Since their payment is made accordingly). This group of people are assigned
multiple tasks in any given duration. They have the capacity to perform
multiple tasks in any specific day. By default, MS Project thinks that if you
assign doble task to this group they overallocated. ( by %200, %400 or %800).
Thus, Their total cost overall sums up to $80000 instead of $40000. I tried
to manipulate this manually by changing the max unit levels to higher values
or assigning a %50 workload if they have two different tasks in a single they
but could not overcome the problem.

I hope I was clear enough.
Thanks

 

[Steve House [MVP]]

If your "resource" is a group rather than an individual, the maximum
available allocation, the assignment level above which the resource is
considered overallocated, should be higher than 100%. If your resource is
"carpenters" and you have 5 of them who are indistinguishable, their Maximum
Availability woul be 500%. That indicated you can assign anywhere from,
say, 25% - one guy for a couple of hours a day - all the way up to 500% -
all five of them full time on the task. Using that sort of grouping assumes
the members of your group are really and truly completely interchangeable.
If they represent unique skills and services you really should be listing
and scheduling them as individuals. IF you need to group them for reporting
and budgeting purposes, that's the purpose of the "group" column in the
resource sheet.