Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2012, 07:45 AM
iamthequinn iamthequinn is offline Part Time Resource Query Windows 7 32bit Part Time Resource Query Office 2010 32bit
Novice
Part Time Resource Query
 
Join Date: Feb 2012
Posts: 1
iamthequinn is on a distinguished road
Default Part Time Resource Query

A'noon all. Apologies if this is the umpteenth query about resourcing in MS Project, but I've had a hunt and can't seem to find the answer to my problem. I'm also a self-taught newbie to Project, so I'm probably missing something fairly obvious.



I'm running a project where there are a number of people who can only be available for a set amount of time each week: for instance my time on the project equates to one day a week, although that may be broken down to two hours on a Monday, half an hour on a Tuesday, etc The same would go for other people on the project, although the amount of time they can spare each week varies from half a day up to 3.5 days.

I initially assumed that, to make myself available for a day a week, I'd set the max time in the resource sheet to 20%, but I then find out that this means I can only assign myself to 20% of a task. So I tried to be clever and change my working time to being 1.5 hrs each day, so that if there was a task which took 2 hours, I would schedule it over two days. This didn't work either (Project would recalculate that as being on one day and say that I was over-allocated).

So what I'm looking for is a solution which tracks the amount of time I've spent on various tasks on a given week, and informs me when these aggregated tasks exceeds my allotted 7.5 hours a week. Is this possible in MS Project?

Many thanks for any suggestions passed my way.

Liam
Reply With Quote
  #2  
Old 02-06-2012, 08:15 AM
JulieS JulieS is offline Part Time Resource Query Windows 7 64bit Part Time Resource Query Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hello Liam,

A couple of questions/comments:

You write:
Quote:
I initially assumed that, to make myself available for a day a week, I'd set the max time in the resource sheet to 20%, but I then find out that this means I can only assign myself to 20% of a task.
You are correct, setting your maximum units to 20% means that Project will automatically assign you at 20%. Where you may be struggling is that Project wants to calculate the Work for your resources when you initially assign them. So, for example if you create a 1day duration task, and assign a resource at 20%, you'll only see 1.6 hours of work. If what you really intended was the task is 8 hours of work and you want the duration to increase to 1 week for you to get the 8 hours of work done, you'll want to use Project is a slightly different manner. Split your screen to show the Task Form in the lower pane. You can then assign resources, specify the work estimate and have Project calculate the duration based upon the Work and the resource's assignment units.

I'm also a bit baffled by your comment:
Quote:
So I tried to be clever and change my working time to being 1.5 hrs each day, so that if there was a task which took 2 hours, I would schedule it over two days. This didn't work either (Project would recalculate that as being on one day and say that I was over-allocated).
I don't know where things when awry, but if you have changed your working schedule to only allow 1.5 working hours per day, a 2hour duration task should still show 2 hours duration, but the finish date/time of the task should modify.

I see you are working with Project 2010 -- are you using Autoscheduled or manually scheduled tasks?

Julie
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook Appointment Query prashantkedare Outlook 0 05-18-2011 02:40 AM
create dataset from query TessaLee Word 0 03-08-2011 11:28 AM
MS Query IsNull issue tpcervelo Excel Programming 0 02-24-2011 10:23 AM
Text Box Query Meljord Word 3 12-15-2009 12:25 PM
Mail Merge Query kangabanga Mail Merge 0 09-25-2008 04:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:32 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