Advanced Planning Baseline Schedule with Primavera P6 &Excel

Real project case study course for an intermediate-level construction planning using Oracle Primavera p6 and Microsoft Excel.

You need to have basic knowledge of Planning Concepts and Oracle Primavera P6 software. Furthermore, you need to have Microsoft Office 2016 or later or Microsoft Office 365.

We will start from scratch with a project Bill of quantities BOQ and a set of drawings to create the following:

1-Course introduction.

2- Read project BOQ.

3- Create Project Data Loading.

4- Read Drawings and add floors to data loading.

5- Activity list and WBS.

6- Cost Loading.

7- Resource Loading.

8- Load Cost and Resources to P6.

9- Estimate Activities Duration.

10- Activities Relationships.

11- Shop Drawings.

12- Materials Procurement.

13- Cash flow and Manpower Histograms.

We will be using the smart Planning Technique using Microsoft Power Query and Oracle Primavera Import and Export to facilitate the Planning Process and provide a Detailed Baseline Schedule with minimal efforts saving 100's working hours.

The course includes all the project documents and the final Baseline documents (Excel and XER files) as open-source for your use so you can modify and use them on your next project.

This is a practical case study project where the instructor will open the files and start working on a real project case study doing the Baseline Schedule using Oracle Primavera P6 and Microsoft Excel advanced techniques. This course scope is NOT including the Project Time Schedule Update or Revised / Recovery schedule and does NOT involve Extension of Time EOT and Claims.