Dear Planners,
Most of my weekly project controls time is consumed with the maintenance of the DDR (Design Document Register), or also known as, PDR (Project Document Register), or just plainly the Document Register. It’s a list of the engineering deliverables (drawings mostly), their current status, next planned dates or forecast, progress, etc. contained in an Excel spreadsheet.
After maintaining this behemoth spreadsheet for about 4 months, I believe (or hope) there must be a better way. Someone in the planning world must have automated this process somewhat and linked the deliverables to P5, so that updating the forecasted dates is not a manual process, but linked to an activity in P5.
I thought about treating each deliverable as a "step" under the appropriate activity within P5, exporting the steps, updating them in excel, then importing them back into P5. Has anyone done this? I think you need SDK(software development kit) installed.
My main concern is to get this massive spreadsheet, the deliverables, into the project schedule and have a method to update the deliverable status/forecast/progress in a format that an engineer/designer can handle.
Thanks
Patrick
Most of my weekly project controls time is consumed with the maintenance of the DDR (Design Document Register), or also known as, PDR (Project Document Register), or just plainly the Document Register. It’s a list of the engineering deliverables (drawings mostly), their current status, next planned dates or forecast, progress, etc. contained in an Excel spreadsheet.
After maintaining this behemoth spreadsheet for about 4 months, I believe (or hope) there must be a better way. Someone in the planning world must have automated this process somewhat and linked the deliverables to P5, so that updating the forecasted dates is not a manual process, but linked to an activity in P5.
I thought about treating each deliverable as a "step" under the appropriate activity within P5, exporting the steps, updating them in excel, then importing them back into P5. Has anyone done this? I think you need SDK(software development kit) installed.
My main concern is to get this massive spreadsheet, the deliverables, into the project schedule and have a method to update the deliverable status/forecast/progress in a format that an engineer/designer can handle.
Thanks
Patrick