Construction Project Planning & Project Scheduling -Ms Excel

Master Project Management & Project scheduling Concepts to Become Planning Engineer WITHOUT Ms Project & Primavera

What you'll learn

Students From Civil Engineering Will Learn Project Planning & project Management Using MS EXCEL

Prepare Baseline Schedule for construction projects

Prepare Month wise Quantities for Excavation, PCC, Concrete, Steel, Brickwork, Plastering, Tiling, Flooring

Prepare Month wise Billing/ Invoice for Excavation, PCC, Concrete, Steel, Brickwork, Plastering, Tiling, Flooring

Prepare Bulk Materials Requirement for Any construction Project

Target Entry Level Jobs as an Junior Planning Engineer

Requirements

Patience To Learn

Description

Oracle Primavera & MSP are the tools required to do Planning of any Project  . The Basics are to be understood first and this course will give you an idea how a planning can be done with Help of MS Excel and how to Apply that for any construction Project .Construction projects are never easy. That's why this course has taken  to carefully study it and make a schedule.Planning is a vital project phase and it would take an enormous amount of time if it is done manually. So You have to understand the main concepts of planning first to plan any project successfully.Project planning is inherently uncertain as it must be done before the project is actually started. Therefore, the duration of the tasks is often estimated through a weighted average of optimistic, normal, and pessimistic cases. Then the necessary resources can be estimated and costs for each activity can be allocated to each resource, giving the total project cost. At this stage, the project schedule may be optimized to achieve the appropriate balance between resource usage and project duration to comply with the project objectives. Once established and agreed, the project schedule becomes what is known as the baseline schedule. Progress will be measured against the baseline schedule throughout the life of the project. A project plan is a set of documents that can change over the course of a project. The plan provides an overall direction for the project. If unexpected issues arise (e.g. delivery delays), the plan can be adjusted by the project manager.Project plans are coordinated by the project manager with input from stakeholders and team members. Plan components cover the “what” and “how” of a project.

Overview

Section 1: PREPARING A BASELINE SCHEDULE FOR A PROJECT

Lecture 1 what is planning & scheduling of project

Lecture 2 Understanding the Scope & Nature of the Project

Lecture 3 Understanding start to start and finish to start link

Lecture 4 Prepare Baseline Schedule for Foundation works

Lecture 5 Prepare Baseline Schedule for Column Upto Plinth Beam

Lecture 6 Prepare Baseline schedule for Plinth Beams & Backfilling works

Lecture 7 Prepare Baseline Schedule for Ground floor column , Roof Beams & Slabs

Lecture 8 Prepare baseline Schedule for First Floor column Activites

Lecture 9 Prepare Baseline schedule for 1st floor slab works

Lecture 10 Prepare baseline schedule for terrace portion / LMR Portion / Mumty Level

Lecture 11 Prepare baseline Schedule for Ground floor Finishing Activities

Lecture 12 Prepare Baseline Schedule for terrace Floor Finishing Works

Lecture 13 Prepare Baseline Schedule for External Works

Section 2: LEARN TO PREPARE MONTHWISE QUANTITIES

Lecture 14 How to Prepare monthwise Quantitiy Excel Sheets & BOQ

Lecture 15 Prepare Start & Finish Date Entry in Monthwise Schedule from BaseLine Schedule

Lecture 16 Calculate Monthwise Quantity of Concrete , PCC,Shuttering & Reinforcement works

Lecture 17 Calculate Monthwise Quantity for Ground Floor Activities

Lecture 18 Calculate Monthwise Quantitiy for 1st Floor & Other Floors

Lecture 19 Calculate Monthwise Quantitiy for Ground Floor Fininshing Activities

Lecture 20 Calculate Monthwise Quanitity for External Finishing Works

Section 3: LEARN TO PREPARE MONTHWISE INVOICE COST FOR THE PROJECT

Lecture 21 Understanding to Prepare Average rate for the Project

Lecture 22 Month wise Invoice for Excavation, Pcc ,Shuttering & Concreting for Substructure

Lecture 23 Month wise Invoice for Excavation, Shuttering & Concreting For Superstructure

Section 4: LEARN TO PREPARE BULK MATERIALS REQUIREMENT FOR ENTIRE PROJECT

Lecture 24 Prepare Bulk materials Quantity from S1 schedule

Lecture 25 Prepare total duration Excel Sheet for all Activities for Complete Project

Lecture 26 Prepare Month wise quantitiy for Complete Project

Lecture 27 Learn to calculate coeffcients for PCC, concrete , Plastering , Flooring works

Lecture 28 Calculate Cement, Sand, Aggregate, Steel required for Month Wise

Lecture 29 Calculate Cement, Sand, Aggregate, Steel required for Month Wise- Part 2

Lecture 30 Calculate Cement blocks & Red Bricks required Month wise for a Project

Section 5: ASSIGNMENTS

Lecture 31 Excel Sheets for Assignments

Section 6: PREPARE S5 SCHEDULE FOR MANPOWER REQUIREMENT

Lecture 32 Calculate Number of Carpenters & Helpers Required for Monthwise Manpower

Lecture 33 Calculate Number of Bar Bender & Helpers Required for complete Project

Section 7: How to Download the Certificate after Course Completion

Lecture 34 Hurray !! Claim Your certificate

Civil Engineers,Construction Management,Planning Engineers,Bar Bending Engineers,Procurement Engineers,Project Managers -Site Managers or Construction Managers -Construction Engineers •Project Engineers •PMO Departments ,Project Controls Departments, Consultants,Fresh Engineers. It is a must have,Those who wants to pursue a career as a scheduler and/or a planner