Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-01-2014, 09:13 AM
Sherry Sherry is offline Multiple resource Dependencies / Mapping Windows 7 64bit Multiple resource Dependencies / Mapping Office 2013
Novice
Multiple resource Dependencies / Mapping
 
Join Date: Apr 2014
Posts: 2
Sherry is on a distinguished road
Default Multiple resource Dependencies / Mapping


When adding multiple resources to a given task I need them to be ‘mapped’ somehow to each other so that the certain task cannot start or finish unless all of the assigned resources are available at a given time. For instance: I have an operator, a machine, and a tool as resources that are assigned to a task. However, the operator must have the machine and also the tool available in order to even operate…..and vice versa…..the machine cannot perform work without the tool or the operator…they all must run at the same exact time! I also need to do this between multiple ‘sub-projects’ that are all linked to using the same resource pool and I use the leveling option to schedule them among each other.

I know in Access you can ‘map’ dependencies…so one this cannot happen unless another is in place….not sure if Project does it this way…

I am struggling sooooo bad to figure out how to accomplish this…please help!!!!
Reply With Quote
  #2  
Old 04-01-2014, 12:39 PM
JulieS JulieS is offline Multiple resource Dependencies / Mapping Windows 7 64bit Multiple resource Dependencies / Mapping Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hi Sherry,
I'm afraid there is no fool-proof method of doing this. You have two broad choices: define the three resources at one unit: for example - operator, machine, tool is one resource. When setting up the resource sheet - carry the cost for all three 'parts' to the one resource.

The second option is a work around of creating a task calendar that carries all non-working time from all three resources. The task calendar is then assigned to the task and it will schedule the task to occur during common working time.

If you are going to use the second option and use resource leveling - ensure you have the option "leveling can adjust individual assignments on a task" unchecked.

The ability to define equipment resources and "tie" them to work resources has been on the request list for many users for many years.

I hope this helps.
Reply With Quote
  #3  
Old 04-01-2014, 01:41 PM
Sherry Sherry is offline Multiple resource Dependencies / Mapping Windows 7 64bit Multiple resource Dependencies / Mapping Office 2013
Novice
Multiple resource Dependencies / Mapping
 
Join Date: Apr 2014
Posts: 2
Sherry is on a distinguished road
Default

Thanks I am going to use the second option - this should work fine!
Reply With Quote
  #4  
Old 04-03-2014, 08:03 AM
JulieS JulieS is offline Multiple resource Dependencies / Mapping Windows 7 64bit Multiple resource Dependencies / Mapping Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome and thanks for the feedback.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Cross Project Dependencies OTPM Project 6 01-18-2014 07:52 AM
Multiple resource Dependencies / Mapping moving tasks - retaining dependencies Andy Francis Project 5 07-25-2013 10:24 AM
Master Schedule and Multiple Resource Pools calebhuzzah Project 1 06-23-2013 10:10 AM
Replacing a Resource in Multiple Tasks Simultaneously taffytron Project 3 12-31-2012 02:21 PM
Filter indirect dependencies SirPercival Project 1 07-04-2012 01:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft