Help in resource pool and formula's

[barrymoss]

I am having trouble with my IMS resource sheet. What is happening is that
when I roll several projects up into one IMS I get compunded resources. For
instance I have four seperate schedules that I would like to roll up into one
IMS. When I insert the four schedules and go and check the resource sheet it
has the same resource four or five times. Once for each of the four schedules
and then sometimes one more for the IMS schedule. This happens whether I
copy and paste a common resource pool into each schedule or whether I link
the schedules to the common resource pool. Any ideas on how to correct this?
My thoughts are to show the resource once and it would show me the total
hours of all four schedules for this resource. I think this should be an
easy fix. The only way around this I can think is to create an if then
statement saying if John Doe is found in the resource column, then add work
for all the times John Doe shows up. I am not sure on how do this either, I
have never done a formula in Project. Is this possible?

 

[Mike Glen]

Hi Barry,

Welcome to this Microsoft Project newsgroup

The trick here is to share resources with the pool: in each project
Tools/Resource Sharing/Share resources... and in the dialog, select to share
with the pool.

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #17 & 18 on multiple projects, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the articles before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP