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 · High Priority · Version 2007

replyReplyThu 12 Nov 2009, 12:26Delegate Stuart said...

Resourcing

Hi Andrew.

First of all, thanks for your help previously.

I would like to resolve the following issue:

We have 15+ projects loaded onto project and i want to accurately track progress. If i do it by entering % work complete for each line item, it only says what the 'actual cost' is assuming the hours completed were as planned - which they sadly arent always!

We receive timesheet data on projects for each resource (consultant) and how much time they have spent on each consulting project. What I would like to know is if there is a way of entering this data (ie. no. hours spent on a project) into project to determine the cost of job to date, and value remaining? ie. i simply want to say - for project A, consultant A has spent 10 hours, consultant B 50hours, and it tell me whether I am overbudget for the project so far. However I do not want to have to manually enter hours for each day, i want to enter it as a total and have project spread it across the project so far.

Hope you understand!

Thanks,

Stuart

p.s. more than happy to write a recommendation for your work so far, as you requested when we spoke before




For upcoming training course dates see: Pricing & availability

replyReplyTue 17 Nov 2009, 17:31Trainer Andrew said...

RE: Resourcing

Hi Stuart - thank you for your question. I have been out of the office for the last few days. I will get back to you shortly with some suggestions.

Kind regards,
Andrew

replyReplyThu 3 Dec 2009, 14:55Trainer Andrew said...

RE: Resourcing

Hi Stuart

Thanks for your question. Rather than % work you may find the Actual work field more useful. You can record how many hours have been carried out (e.g. a weekly total). There is a related field called Remaining Work.

Project will work out progress for you. Costs will also be calculated so you can compare them against the baseline figures.

I hope this helps - let me know how you get on.


Kind regards,
Andrew

replyReplyThu 3 Dec 2009, 15:11Delegate Stuart said...

RE: Resourcing

Hi Andrew

I need to enter the total actual work for each consultant over the project, rather than a sum of the team's hours. Is there a way i can enter this - its almost like i need to split the screen to enter the actual work rather than just work.

Eeek. Annoying!

Thanks

Stu

replyReplyThu 3 Dec 2009, 15:16Trainer Andrew said...

RE: Resourcing

Hi Stu

All is not lost :) How about giving the same two columns a try in the Task Usage view?

This would let you record actual work carried out by individual resources on each task. You could also try the same two fields on the Resource Usage view which organises the plan by Resources rather than in Task order.

Let me know if that works better.

Kind regards,
Andrew

replyReplyThu 3 Dec 2009, 15:55Delegate Stuart said...

RE: Resourcing

Yes i had a go at that one, the resource usage looks like it would work, but you can't enter in summary info, it is faded out, only allowing you to enter work completed for each task individually. I thought there was another view that worked but cant seem to find one that will let me enter in the summary data for each consultant. Any other ideas? Thanks again

Stuart

replyReplyThu 3 Dec 2009, 17:17Trainer Andrew said...

RE: Resourcing

Hi Stuart

Yes, that's true. On the regular Gantt chart you can record actual work and remaining at the Summary task level (so it is applied evening across all tasks in the group. Does that get you any nearer to what you are looking for?

Kind regards,
Andrew

replyReplyThu 3 Dec 2009, 18:43Delegate Stuart said...

RE: Resourcing

But i believe that will make Project assume that all consultants have used the same amount of hours. Remember we have different consultants at different rates. I want to enter, for example, Charles has done 8 hours, Maeve has done 10, and Stuart has done 5 - then have Project tell me how much of my budget I have used up. And how much remaining. See what i mean? Thanks again for your time.

Stu

replyReplyFri 4 Dec 2009, 10:01Trainer Andrew said...

RE: Resourcing

Hi Stuart

Yes MS Project will need to know which tasks should be progressed either by resource or by summary task.

The baseline information enables MS Project so show variance and remaining cost at a task or summary task level.

Each resource can have its own rate set so the calculation of cost based on work will take this into account

I'm sorry we weren't able to be of more help.

Kind regards,
Andrew

Thu 10 Dec 2009: Automatically marked as resolved.

 

 

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

Ms project tip:

Show or hide toolbar ScreenTips

On the Tools menu, go to Customize, and then select Toolbars.
Click the Options tab.
put a tick or remove the tick from the Show ScreenTips on toolbars check box.

View all MS Project hints and tips

forum postHow do you copy the formula from one cell to another?

» Forum post: Cell reference


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