resourcing
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training Sitemap add this page to your favourites/bookmarksBookmark page
 
view a printable version of this pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Project Training and help » Resourcing

Resourcing

resolvedResolved · Medium Priority · Version 2003

replyReplyMon 1 Jun 2009, 08:56Delegate Bradley said...

Resourcing

I manage a programme of road maintenance schemes. I have set up a separate project for each scheme (some 40+ schemes in total). Each scheme is relatively small in size and as such, for the purpose of this programme, only one engineer will be working on each scheme. I have created a master project which will read all the separate individual schemes and put them into one main programme.

I have also created a 'resource pool' which is also fed into the master programme. Typically each engineer will have about 3-4 schemes active at any one time. Any more will be excessive and any less will probably leave them under-resourced. The problem is that when I am in the master project and click on 'View > Resouce Graph' the engineer's time is often at 200, 500, 600% or more. I have tried to level the resources but this only moves the dates out considerably. The engineer might only be spending a hour or two a day at the most on a particular scheme. How can I make the resource alocation more realistic?

For upcoming training course dates see: Pricing & availability

replyReplyMon 1 Jun 2009, 09:44Trainer Andrew said...

RE: Resourcing

Hi Bradley

Thank you for your question. Here's one thing you might like to try.

When you have assigned your resource to a task switch to Resource Usage view. This will show you the planned work that will take place during a task. By default MS Project assumes your resource is working full on the tasks. If this is not the case then adjust the planned work to represent the correct amount. For example a resource following the default calendar assigned to a one day task would have 8 hours work calculated for that day. Use the Usage view to drop this down to 1 hour.

You will see all the tasks assigned to your resource in Resource Usage view, even if they are in other projects so you can balanced the planned work across all their tasks resulting in a more realistic peak units percentage.

Assignment of resources is one of the topics we look at on our 2 day MS Project course. You can find more information online at http://www.microsofttraining.net/ms-project-training-london-2003-intro-inter.php

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

replyReplyWed 3 Jun 2009, 09:28Delegate Bradley said...

RE: Resourcing

Hi Andrew

Thanks for your guidance. I was just wondering how in 'Resource Usage' I can change all entires which read 8h with 2h. There are quite a few so I would prefer to find a shortcut rather than go through and change each 8h to 2h individually. I've tried doing it via the 'Edit > Replace' route but it seems a bit complicated!

Please help.

Regards,
Bradley

replyReplyWed 3 Jun 2009, 09:45Trainer Andrew said...

RE: Resourcing

Hi Bradley

Rather than change all the tasks after the event you could create the tasks with the correct duration and work first. One way to do this is to add the Work column to the Entry table, set the work hours per task and then set Duration. Once you have done that assign your resource to the task. Using this method you can set up a resource working on a one day task which consists of two hours of work.

Be careful about editing the Work value in the Entry table (i.e. in Gantt Chart view) after a resource has been assigned to a task. Depending on your MS Project settings you may find the software changes your task durations.

Making the changes in Resource usage allows you to modify the assigned hours but leaves the duration unchanged.

I hope this helps.

Kind regards,
Andrew

 

 

Please browse our web site to find out more about
project server consultant and other Microsoft training courses.

Ms project tip:

Inserting Task Durations Quickly

When entering durations for your tasks simply use the single letters - m for min, h for hr, d for day, w for week, but mon for month. If default is set for days, you need only type the number, for example 3 for 3days, or 0.5 for half a day.

View all MS Project hints and tips

forum postDo you have any help cards I can access for Powerpoint 2007? I would like to know things like the 'view a slideshow' button in version 2003 can now be found 'here' in 2007 etc.

» Forum post: Powerpoint


Rate this page:
2.2/5 (213 votes cast)
Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses
Microsoft Certified Partner
Security Seal verified by visa, mastercard securecard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Management training

Professional Skills courses
Project Management Course London
Project Management Courses London
Project Management Training London
Project Management Training
Project Seminar
Project Seminars
Time Management Course London
Time Management London
Time Management Courses London
Time Management Training London
Introduction to Finance course
Assertiveness Skills course
Effective Communications Skills training
Presentation Skills London

Training Formats

Public scheduled courses
On-site training
Closed company courses

Consultancy
Application Development

Blogs

Excel Training
MS Project Training
Microsoft Training Blog

Version differences

Office 2010 vs 2007
MS Project version differences

Training Information

London Computer Training
Computer Training London
Docklands Training Courses
Docklands Training London

Training venues London
Client list
FAQ
Pricing and availability
Course details / Syllabus

Training Articles
Training Information

Microsoft training

Microsoft Office training
& IT Applications

Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training
MS Project courses
MS Project training
Outlook courses
PowerPoint courses
PowerPoint training
VBA courses
Word courses
Microsoft.training
(more...)

Excel Training

Excel courses
Excel Training Courses Medway
Autonumber in Excel
Microsoft Excel training
Basic Excel Courses
Basic Excel Course
Basic Excel Training

Interested in MS Access training?

Access courses
Microsoft Access training
Microsoft access courses
Microsoft training access course
Microsoft+access+training
Access courses in london

Training provider

Training providers
IT training companies
IT training providers
Management Training providers
Management Training provider

Event history, feedback results
Events in 2012 · 2011 · 2010 · More

See also

Crystal Reports training