Manpower over multiple activities in one day

Hi Jon

The starting point is on a spreadsheet with each day in column A and the floors in rows 2 to whatever across the top.

You can now enter the hours on each day for each floor.

This will give you the start date and end date for each floor.

If you don't know what floor they were working on then you will have to interpolate across the floors.

Presumably they started on the top floor and worked down.

You know when they started and when they finished and you know the total number of hours.

To start just divide the hours by the number of floors and make a basic allocation.

Assuming that the work got quicker as they came down you can top load the higher floors and reduce on the lower floors.

Best regards

Mike Testro

Mike,

thanks for your input, The spreadsheet version works, but I need to do this in P6 using codes from the baseline schedule. The demo crew worked all over the place and not in any type of order as shown the baseline schedule.

Jon

Look for Timesheet applications that integrate with your software, otherwise recording this level of detail can become a monumental task if performed twice. 

At home most contractors do not integrate accounting timesheet software to scheduling software and use a separate job costing that comes integrated within the accounting system. Most do not use the scheduling system to keep a detailed track of costs as they happen but more for projections. To be honest I do not know of a single contractor that uses Timesheet integrated with scheduling. 

These projections are as important as the records and here most believe for projections the schedule is the best source while for gathering data and storing such detailed data the accounting system is a better choice. Usually cost data is transferred to the scheduling software in a summarized way and not the other way.

About cost codes, it is a matter of company standards, but I would assign the same cost code to demolition work no matter into how many activities it is distributed. In any case you should be able to get the reports that will give you the global/job totals for each cost code or a distribution of each cost code per activity. You can assign and get cost reports for cost assignment/actual/projected on one to many, many to one or many to many assignments. Look at each cost code as if a resource that can be assigned to different activities or as different resources assigned to the same activity.