manpower in microsoft project RRS feed

  • Question

  • Hi all,
    I'm new to MS Project. We're moving from excel to MS Project. We would like to be able to track number of manpower in our construction site, for example:

    Task S M T W T F S
    Excavation 0 2 2  2 2 2 2
    Forming 0 2 4  3 2 2 2
    Rebar 0 3 2  2 3 2 1

    The numbers above represent total labour count working in any given day. Previously we tracked total count using excel sheet but i'm having a hard time figuring it out in MS Project.

    Anyone can help me with this?

    Thank you.

    Saturday, March 22, 2014 12:35 AM

All replies

  • bApTizE --

    In the Resource Sheet view of your project, enter the names of the types of your workers.  You can enter the real name for those workers, or you can enter the names of roles.  If you enter roles, such as Laborer, then in the Max. Units column, enter 100% times the numbers of workers you have of that type.  For example, if you have 12 laborers available to work on the project, enter 1200% in the Max. Units field.

    In the Gantt Chart view, make sure that you entered a duration estimate in the Duration column for each task.  Right-click anywhere in the Gantt Chart pane in the right half of the Gantt Chart view and select Show Split on the shortcut menu.  Select a task in the top pane (Gantt Chart pane).  In the bottom pane (Task Form pane), first select the names of the resources working on the task, one resource per row, but DO NOT click in the top pane and DO NOT click the OK button yet.  If you enter the names of humans, enter 100% in the Units column for each human.  If you enter the name of a role, such as Laborer, enter 100% times the number of workers of that type.  So, if you are going to use 4 laborers on the task, enter 400% in the Units column.  When finished selecting all of the resources who will work on the task, click the OK button in the bottom pane.  You will see that Microsoft Project calculates the Work for each person or role on the task.

    In the bottom pane, there is a checkbox option called Effort Driven.  If this option is selected and you add helpers to this task at a later time, Microsoft Project will automatically shorten the Duration of the task because more workers are sharing the workload.  If this is the behavior you want for this task, leave the option selected.  If this is NOT the behavior you want, DESELECT the Effort Driven checkbox and then click the OK button in the bottom pane.

    These are some ideas for you to get you moving in the right direction.  Hope this helps.

    Dale A. Howard [MVP]

    Saturday, March 22, 2014 2:20 AM
  • bApTizE,

    A question. Why are you moving to Project? If all you want to track is daily manpower, then Excel is much easier and a better choice. However if your intent is to actually set up a schedule for your construction project(s), then Project is probably the better application, but Project isn't a quick learn so expect to invest some time learning how to use it to the best advantage.


    Saturday, March 22, 2014 2:25 AM