Create formula that uses resource assignment units in Project?

[SixSigmaGuy]

Hi,

I want to create a formula that uses the assignment units for a resource.
I.e., if Joe is the resource on a task and I've set his units to 10%, I want
to be able to make the units a parameter in my formula. For example,

Number1 = Duration * Units

I'm refering to the functionality that I get to when I go to
Tools.Customize.Fields and then click the "Formula" button.

I can use every other value that I know of, but I can't seem to find Units
(aka Assignment Units).

Anyone know how to do this? I need to perform calculations based on the
units.

Thanks,

 

[SixSigmaGuy]

Well I came up with a really clunky work-around where I parse the "Resource
Names" field to get the Assignment units, so I can more forward. Would still
love to see a better solution. Here's what I had:

Number1=IIf(InStr(1,[Resource Names],"["),mid([Resource
Names],instr(1,[Resource Names],"[")+1,instr(1,[Resource
Names],"]")-instr(1,[Resource Names],"[")-2),100)/100

Pretty ugly, huh?

 

[John]

Well I came up with a really clunky work-around where I parse the "Resource
Names" field to get the Assignment units, so I can more forward. Would still
love to see a better solution. Here's what I had:

Number1=IIf(InStr(1,[Resource Names],"["),mid([Resource
Names],instr(1,[Resource Names],"[")+1,instr(1,[Resource
Names],"]")-instr(1,[Resource Names],"[")-2),100)/100

Pretty ugly, huh?

Hi,

I want to create a formula that uses the assignment units for a resource.
I.e., if Joe is the resource on a task and I've set his units to 10%, I
want
to be able to make the units a parameter in my formula. For example,

Number1 = Duration * Units

I'm refering to the functionality that I get to when I go to
Tools.Customize.Fields and then click the "Formula" button.

I can use every other value that I know of, but I can't seem to find Units
(aka Assignment Units).

Anyone know how to do this? I need to perform calculations based on the
units.

Thanks,

SixSigmaGuy,
I think you came up with the only way to do it with a formula (i.e.
parse the Resource Names string). It may be clunky but if it works. . .

Personally I would use VBA, but then VBA isn't always an option for many
users.

John
Project MVP

 

[Jan De Messemaeker]

Hi,

When there's only one resource you could use Work/Duration
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

Well I came up with a really clunky work-around where I parse the "Resource
Names" field to get the Assignment units, so I can more forward. Would still
love to see a better solution. Here's what I had:

Number1=IIf(InStr(1,[Resource Names],"["),mid([Resource
Names],instr(1,[Resource Names],"[")+1,instr(1,[Resource
Names],"]")-instr(1,[Resource Names],"[")-2),100)/100

Pretty ugly, huh?

Hi,

I want to create a formula that uses the assignment units for a resource.
I.e., if Joe is the resource on a task and I've set his units to 10%, I want
to be able to make the units a parameter in my formula. For example,

Number1 = Duration * Units

I'm refering to the functionality that I get to when I go to
Tools.Customize.Fields and then click the "Formula" button.

I can use every other value that I know of, but I can't seem to find Units
(aka Assignment Units).

Anyone know how to do this? I need to perform calculations based on the
units.

Thanks,