Large Project Upload Using Templates and P6-Loader
Once the projects were created, we extracted the activities and set durations based on the dates from MS Project. We calculated the duration of the activities using formulas in Excel, then used a VLOOKUP to match the calculated durations to the proper activities. The planned duration was then set with a load of the activities into P6 from P6-Loader.
Once the planned duration of the activities was loaded, the projects were scheduled and the dates for the activities were calculated. The BU was then able to analyze the projects in P6 to ensure the data was properly transferred from their MS Project schedule.
Instead of taking hours upon hours of time to manually create projects, the use of the P6-Loader allowed the creation and setting of durations on each project to be done with some help of Excel functionality in a matter of a few short hours. Our client was very pleased with the reduced number of hours required to accomplish the project upload.
About the Author
At Emerald Associates, Sue is an Implementation Specialist and has been successful at drawing on her accounting and project management background to consult with our diverse client base. With her friendly demeanor and strong communication skills, she has become a talented Primavera trainer and works very hard to effectively implement Oracle Primavera solutions that cater to each client’s unique organizational needs.