Skip to content
ProjectControls.com
Microsoft Project

Can Project calculate the number of people (resources) required to execute?

In the Open Standard
Dale FaveroMember for 14 years 2 months
Created
3
6
0

I am using Project to plan execution time lines for maintenance.  I deal with a large workforce that has many special quals.  To that end I have my resource sheet set up showing all of these skills.  To accomplish this work takes numerous mechanics with this special skill.  I have been assigning that resource (special skill) and then tagging it with a 200%, 300% or whatever as appropriate to show the number of mechanics needed to make the team. 

Is there a better way?  I really need the ability to make task break downs without knowing who the work team is.  I need the software to help me track how many and what flavor of mechanics I need on any given week.

Thanks in Advance

Dale

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Alexandre Faulx-Briole ·
    #1

    Hi Dale,you are on the right

    Hi Dale,

    you are on the right track

    you could do even better: double-click the resource name in the resource sheet, and change the time-distributed availability of the resource to fit with the amount of work the resource will have to achieve

    Alexandre

    Report
  2. 0
    Ron Beechey ·
    #2

    Hi Dale First I would change

    Hi Dale

    First I would change the 100% to 1 as we are talking a resource of which it is hard to cut in half.   Since most tasks are duration driven.  anyway you can change this in the project options to Decimal.   Then for a task that needs 4 special welders you only need to indicate 4.   If you are doing your maintenance work like ours then you would have only a single resource per task.   It takes a little more time but makes a better schedule for each trade as you can filter for each and they have their own.   Also as Alexandre points out you can also take the task to the person but if there is a large number of resources as well as tasks  this may be hard to do.

    There are a number of different views like the resource usage view were the total number of resources special can be viewed.   If need you can always copy and paste into excel and do some manpower graphs

    Report
  3. 0
    Ron Beechey ·
    #3

    Hi Dale First I would change

    Hi Dale

    First I would change the 100% to 1 as we are talking a resource of which it is hard to cut in half.   Since most tasks are duration driven.  anyway you can change this in the project options to Decimal.   Then for a task that needs 4 special welders you only need to indicate 4.   If you are doing your maintenance work like ours then you would have only a single resource per task.   It takes a little more time but makes a better schedule for each trade as you can filter for each and they have their own.   Also as Alexandre points out you can also take the task to the person but if there is a large number of resources as well as tasks  this may be hard to do.

    There are a number of different views like the resource usage view were the total number of resources special can be viewed.   If need you can always copy and paste into excel and do some manpower graphs

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?