Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2013, 07:30 AM
cineasta cineasta is offline Auto-level resources for parallel tasks with fixed work Windows 7 64bit Auto-level resources for parallel tasks with fixed work Office 2010 64bit
Novice
Auto-level resources for parallel tasks with fixed work
 
Join Date: Nov 2013
Posts: 3
cineasta is on a distinguished road
Default Auto-level resources for parallel tasks with fixed work

Hi all,

I try to find a way to auto-level resources based on their available working hours per day.

There are two tasks starting at the same time (see Screenshot "problem"):
Task A takes 2 days
Task B takes 4 days

Both tasks start at the same time and have to be completed by the same resource. Work is fixed, so duration can vary.
I want the resource "User A" to work 50% for two days on both task. As soon as Task A is completed, User A should work a 100% on Task B.

Project either moves the task to resolve the problem or assigns the resource for 50% until the end of Task B (although 100% would be possible).

I want to achieve the result shown in screenshot "goal". Is there a way to do this without entering the values day by day in Resource Usage Sheet?

Thanks


cineasta
Attached Images
File Type: jpg Problem.JPG (70.1 KB, 14 views)
File Type: jpg Goal.JPG (72.1 KB, 14 views)
Reply With Quote
  #2  
Old 11-19-2013, 10:27 AM
JulieS JulieS is offline Auto-level resources for parallel tasks with fixed work Windows 7 64bit Auto-level resources for parallel tasks with fixed work Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

No, sorry. The resource leveling command will never alter assignment units nor assign resources. Its only job is to move tasks so the resource's Peak Units are less than or equal to Max. Units.

Assign your resource at 100% to task A to get the 8 hours of work done in one day and then assign at 100% to task B to accomplish to 32 hours of work in 4 days. We are not as efficient at multi-tasking as we would like to think
Reply With Quote
  #3  
Old 11-20-2013, 02:21 AM
cineasta cineasta is offline Auto-level resources for parallel tasks with fixed work Windows 7 64bit Auto-level resources for parallel tasks with fixed work Office 2010 64bit
Novice
Auto-level resources for parallel tasks with fixed work
 
Join Date: Nov 2013
Posts: 3
cineasta is on a distinguished road
Default Thank you

Hi,

thanks a lot for your reply. I thought so...
In reality, two guys work on Task A 50% because the task can only be done by both of them together. They do this for two days in the morning. So the afternoon is free for the second task. After two days the entire day is available for the second task.

I will try a different approach in setting up my tasks. Maybe split the longer tasks in additional sub tasks.

Thanks for the feedback!
Reply With Quote
  #4  
Old 11-20-2013, 05:05 AM
JulieS JulieS is offline Auto-level resources for parallel tasks with fixed work Windows 7 64bit Auto-level resources for parallel tasks with fixed work Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

If you need to restrict Task A to be worked on during specific times, consider creating a task calendar restricting work to only the morning hours. Assign that task calendar to Task A. Then resource leveling will do what you want it to. It will assign only 4 hours (at 100%) for Task B during the duration of Task A then 8 hours per day for the end of Task B.
Reply With Quote
  #5  
Old 11-21-2013, 05:57 AM
cineasta cineasta is offline Auto-level resources for parallel tasks with fixed work Windows 7 64bit Auto-level resources for parallel tasks with fixed work Office 2010 64bit
Novice
Auto-level resources for parallel tasks with fixed work
 
Join Date: Nov 2013
Posts: 3
cineasta is on a distinguished road
Default

Yeah, awesome! I wasn't really aware of the calendar per task option.
Now I got the exact result that I tried to achieve.

I assigned a 4hrs calendar to Task A. When I assigned resources and used the resource leveling function, Task B was split at the end of Task A. First part assigned the resource 50%, the second part 100%.
See the result attached.

Thanks a lot!
Attached Images
File Type: jpg solution.jpg (30.1 KB, 16 views)
Reply With Quote
  #6  
Old 11-21-2013, 01:03 PM
JulieS JulieS is offline Auto-level resources for parallel tasks with fixed work Windows 7 64bit Auto-level resources for parallel tasks with fixed work Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Great. I'm glad the task calendar accomplishes what you need.
Reply With Quote
Reply

Tags
level, resources

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-level resources for parallel tasks with fixed work Assigning Resources to Tasks rickw262 Project 1 01-18-2013 04:46 AM
Auto-level resources for parallel tasks with fixed work Fixed duration, fixed units, fixed work, effort driven. How, why and when use it all Evgeny Project 3 01-03-2013 06:45 AM
Changing resources against tasks with actual values joday48 Project 3 06-28-2012 05:13 AM
Auto-level resources for parallel tasks with fixed work How to use fixed duration, fixed work and have resources/units leveled automatically? Joeb Project 3 06-25-2012 04:18 PM
Constraining a fixed interval between two tasks Doug Sanderson Project 3 08-30-2011 09:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:04 PM.


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