Advanced Planning Baseline Schedule with Primavera P6 &Excel

Practical Case Study with Step by Step instructions. Work Smart NOT Hard.

What you'll learn
Step by step Planning Technique to create a detailed baseline schedule using Oracle Primavera latest version and Excel power excel power query
Create activities, estimate the budget cost and resources in Excel and smartly export to Primavera P6
Develop project cash flow and manpower histogram, shop drawings log, and procurement log.
Real project case study to create a baseline schedule from scratch.
All Project case study files will be shared with you open source so you can use on your next project.

Requirements
Basic knowledge about Oracle Primavera and Planning concepts.
Oracle Primavera P6 software & Microsoft Excel 2016 or later, i am using MS 365
Description
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.

Who this course is for
Planning Engineers, Planning Managers, Construction Managers.
Anyone with basic construction / planning knowledge and want to learn planning