Advanced Planning Baseline Schedule with Primavera P6 &Excel
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
Instructor
- 4.6 Instructor Rating
- 504 Reviews
- 1,843 Students
- 1 Course
Planning & Project Control Manager with 20 years of experience.
BSc Civil Engineering 1998-2003 Tanta University-Egypt, PMP certified 2010 PMI-USA and Project Management MSc from University of Liverpool-UK 2013-2016.
I have been working as a Planning Manager in large-scale projects (hotel, hospital, residential buildings, conference center, shopping mall, warehouses, and infrastructure projects) in Dubai-UAE, Suadi Arabia, and Egypt.
I have provided over 5,000 Online / Offline training hours to Planning Engineers / Managers over the past 10 years.
I do have my own Planning Techniques which were developed over my years of experience and the different situations I faced during my career. I have created several smart Planning Tools to help us facilitating our planning tasks as well.
My strategy of teaching is to find solutions to works SMART not HARD.