(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
I am working on an As-Built schedule using daily reports showing total manpower in each day for Demolition.
the job is coded such that every floor has its own code (I can't add floor codes). But the demo crew worked on multiple floors, so I need to create a different activity for each floor. How would I assign the manpower across the demolition activites for the day?
Any help would be appreciated.
thanks
Jon Grove
Printer-friendly version
Send to friend
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.
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
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
Email: PPadmin@planningplanet.com
Replies