C
Chris Allen
We have a common situation where we need to calculate productivity using the
calendar hours worked on a task to status date.
The tasks have multiple resources, both persons and equipment of type
'work', and are set to fixed duration and effort driven. This would work
easily if they were Fixed Work, but although resources can be changed, the
duration is set by the equipment production rate (a drill rig).
Microsoft Project Server is storing a start and end time for splits, becasue
it uses them to display the Gant bars as split. How can I extract the start
and end of a split within a task?? And what about multiple splits?
- Have used Actual Duration - it only works correctly in Fixed Work tasks.
- Have checked Stop and Resume fields - they work to form the next split,
not store a past one.
- My next plan is to enter the SQL Server database and start snuffling
around for fields to call in a VBA macro. I think there will be a separate
table for split start/stops with a keyfield to project/taskID.
Many thanks for any ideas!
calendar hours worked on a task to status date.
The tasks have multiple resources, both persons and equipment of type
'work', and are set to fixed duration and effort driven. This would work
easily if they were Fixed Work, but although resources can be changed, the
duration is set by the equipment production rate (a drill rig).
Microsoft Project Server is storing a start and end time for splits, becasue
it uses them to display the Gant bars as split. How can I extract the start
and end of a split within a task?? And what about multiple splits?
- Have used Actual Duration - it only works correctly in Fixed Work tasks.
- Have checked Stop and Resume fields - they work to form the next split,
not store a past one.
- My next plan is to enter the SQL Server database and start snuffling
around for fields to call in a VBA macro. I think there will be a separate
table for split start/stops with a keyfield to project/taskID.
Many thanks for any ideas!