Description

Planning Engineer Interview Assignment 01 by using Primavera P6 | Construction of Office Building

1. Introduction and Overview:

Introduction to Softedemy: Dive into the world of project control and engineering software with Softedemy.
Overview of Interview Assignment Tasks: A quick snapshot of what planning engineers can expect during interviews.

2. Baseline Preparation and Milestone Assignments:

Tasks 1-3 take you through the journey of preparing a baseline schedule, explaining total costs, and updating the schedule with the necessary assignments.

3. Actual Execution, Milestones, and Understanding S-Curves:

Tasks 4-6 discuss how actual execution is used to control milestones, explaining the B S Curve and drawing out the SPI, CPI, and overall indexes.

4. Practical Applications and Advanced Techniques:

Tips for planning engineer interviews, site working team settings, project management calendars, and a thorough understanding of WBS.

5. Activities, Calendars, and Adjustments:

A step-by-step guide on adding, exporting, and importing activities, making calendar adjustments, and initializing a project with the correct activity names and IDs.

6. Project Controls and Constraints Management:

Dive deep into linking activities, setting dependencies, float management, and understanding the importance of a technical team’s input in decision-making.

7. Costs, Resources, and Budget Management:

Learn about cost loading, resource allocation, currency adjustments, and breaking down costs based on specific activities.

8. Troubleshooting, Data Management, and Monitoring:

Learn how to navigate through common issues, streamline data processing, and transition to the monitoring phase of the project.

9. Adjusting, Evaluating, and Completion:

From adjusting completion dates to evaluating the finish date, this section covers everything up to the finalization of milestones.

10. The S Curve and Earned Value Analysis:

A comprehensive look into creating S Curves in Excel, analyzing the graph, and delving into earned value analysis, including cost variance explanation and SPI/CPI indices overview.

11. Conclusion and Further Exploration:

An overview of the EVA Matrix Table and its applications. Links for further exploration and advanced learning are provided.

🎥 Delve deeper with our comprehensive video guide below.

Key Sessions Include:

📌 Timestamps:
0:00 – Introduction to Softedemy: Project Control & Engineering Software Academy
0:50 – Overview: Planning Engineers Interview Assignment Tasks
1:30 – Task 1: Preparing Baseline Schedule & Milestone Details
2:00 – Task 2: Loading Plan Cost & Total Cost Explanation
2:30 – Task 3: Updating Schedules & Task Assignments
3:00 – Task 4: Assigning Stones Based on Actual Execution & Control Milestones
4:15 – Task 5: Progress B S Curve Explanation
4:45 – Understanding S-curve: Plan Percent, Earned Percent & Schedule Percent
5:15 – Task 6: Drawing SPI, CPI & Overall Indexes Using S-curve
5:45 – Utilizing this Video for Planning Engineer Interviews
7:20 – Setting Site Working Team & Work Hours
7:50 – Creating Calendars for Project Management
8:30 – WBS Introduction & Explanation
9:00 – Adding Activities
9:40 – Exporting & Importing Activities Using Excel
11:00 – Calendar Adjustments & Project Initialization
15:04 – Introducing WBS Code & Activity Names
16:35 – Adjusting Activity Names & IDs
17:42 – Original Durations & Conversions
18:35 – Viewing Added Activities & IDs
21:00 – Assigning Constraints & Milestones
23:45 – Linking Activities & Setting Dependencies
24:20 – Adjusting Duration & Links for Clarity
26:04 – Calendar Verification & Float Management
27:16 – Connecting Activities & Creating Critical Paths
32:29 – Importance of Site Information and Technical Team Inputs
33:36 – Adjustments in Decimals for Accurate Scheduling
34:01 – Timeline for Landscaping and Tiling Work
34:42 – Matrix Analysis and Importance in Scheduling
37:49 – Critical Path Discussion and Implications
39:23 – Introduction to Cost Loading and Resource Allocation
40:01 – Currency Adjustments in Primavera
40:27 – Cost Breakdown Based on Activities
41:55 – Assigning Weights for Different Activities
46:04 – Troubleshooting costs and budget alignment
46:57 – Exporting data to Excel for resource assignment
48:00 – Modifying activity IDs and resource IDs
49:03 – Integrating updated activity IDs and cost data
51:40 – Applying filters to streamline data processing
52:34 – Importing updated cost data into Primavera P6
54:03 – Analyzing project schedules and constraints
55:02 – Transition to monitoring phase and setting baselines
57:09 – Updating progress for specific activities
1:00:54 – Navigation through the Task List
1:02:14 – Adjusting Completion & Scheduling
1:03:19 – Activity Completion & Duration Adjustments
1:09:45 – Wrapping Up Project and Evaluating Finish Date
1:10:20 – Adding Baseline Columns for Comparison
1:10:57 – Addressing Cost & Resource Assignments
1:11:35 – Editing Actual Costs & Cost Distribution
1:13:00 – Mistakes & Corrective Measures in Costing
1:15:41 – Completion of Tasks and Adjusting Milestones
1:17:23 – Introduction to Progress S Curve Creation
1:17:50 – Using the Spreadsheet to Plan Value Costs
1:18:28 – Importance of Maintaining and Assigning Baselines
1:19:06 – Adjusting and Reviewing Baseline Data
1:19:21 – Copying & Pasting Data to Create an S Curve in Excel
1:20:02 – Constructing and Analyzing the S Curve Graph
1:20:47 – Adjusting Graph Values for Better Visualization
1:21:33 – Comparing Earned and Planned Values
1:22:12 – Finalizing the S Curve Graph
1:24:05 – Performing Earned Value Analysis
1:25:21 – Setting Up an Earned Value Analysis Table
1:31:56 – Introduction to Earned Value Analysis
1:32:21 – Cost Variance Explanation and Analysis
1:33:01 – SPI and CPI Indices Overview and Analysis
1:34:56 – Budget Overrun and Schedule Variance Index Discussion
1:35:34 – Date and Value Adjustments
1:36:07 – Overview of EVA Matrix Table & Access Link

Who Can Benefit?

• Planning Engineers
• Project Management Professionals
• Project Control
• Cost Controls

What You Get

• Excel Sheets: Customizable Excel templates and all supporting files Like XER , PDF and Xlsx files used in the video for practice.
• By purchasing this Sheet, you are also contributing to Softedemy’s mission. The revenue generated supports our team and resources, allowing us to expand our network and bring you more high-quality products.

 

Let Softedemy’s Earned Schedule Analysis Excel guide you through your next project with ease and efficiency. Order now!

Watch below Video