Construction Project Planning & Project scheduling -MS Excel

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

4.55 (132 reviews)
Udemy
platform
English
language
Engineering
category
instructor
1,024
students
6 hours
content
Nov 2023
last update
$44.99
regular price

What you will 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

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.

Content

PREPARING A BASELINE SCHEDULE FOR A PROJECT

what is planning & scheduling of project
Understanding the Scope & Nature of the Project
Understanding start to start and finish to start link
Prepare Baseline Schedule for Foundation works
Prepare Baseline Schedule for Column Upto Plinth Beam
Prepare Baseline schedule for Plinth Beams & Backfilling works
Prepare Baseline Schedule for Ground floor column , Roof Beams & Slabs
Prepare baseline Schedule for First Floor column Activites
Prepare Baseline chedule for 1st floor slab works
Prepare baseline schedule for terrace portion / LMR Portion / Mumty Level
Prepare baseline Schedule for Ground floor Finishing Activities
Prepare Baseline Schedule for terrace Floor Finishing Works
Prepare Baseline Schedule for External Works

LEARN TO PREPARE MONTHWISE QUANTITIES

How to Prepare monthwise Quantitiy Excel Sheets & BOQ
Prepare Start & Finish Date Entry in Monthwise Schedule from BaseLine Schedule
Calculate Monthwise Quantity of Concrete , PCC,Shuttering & Reinforcement works
Calculate Monthwise Quantity for Ground Floor Activities
Calculate Monthwise Quantitiy for 1st Floor & Other Floors
Calculate Monthwise Quantitiy for Ground Floor Fininshing Activities
Calculate Monthwise Quanitity for External Finishing Works

LEARN TO PREPARE MONTHWISE INVOICE COST FOR THE PROJECT

Understanding to Prepare Average rate for the Project
Month wise Invoice for Excavation, Pcc ,Shuttering & Concreting for Substructure
Month wise Invoice for Excavation, Shuttering & Concreting For Superstructure

LEARN TO PREPARE BULK MATERIALS REQUIREMENT FOR ENTIRE PROJECT

Prepare Bulk materials Quantity from S1 schedule
Prepare total duration Excel Sheet for all Activities for Complete Project
Prepare Month wise quantitiy for Complete Project
Learn to calculate coeffcients for PCC, concrete , Plastering , Flooring works
Calculate Cement, Sand, Aggregate, Steel required for Month Wise
Calculate Cement, Sand, Aggregate, Steel required for Month Wise- Part 2
Calculate Cement blocks & Red Bricks required Month wise for a Project

ASSIGNMENTS

Excel Sheets for Assignments

PREPARE S5 SCHEDULE FOR MANPOWER REQUIREMENT

Calculate Number of Carpenters & Helpers Required for Monthwise Manpower
Calculate Number of Bar Bender & Helpers Required for complete Project

Screenshots

Construction Project Planning & Project scheduling -MS Excel - Screenshot_01Construction Project Planning & Project scheduling -MS Excel - Screenshot_02Construction Project Planning & Project scheduling -MS Excel - Screenshot_03Construction Project Planning & Project scheduling -MS Excel - Screenshot_04

Reviews

faizan
January 3, 2023
Great learning session, very well presented and informative. For someone who has just started to get into this field this is a much recommended course.

Charts

Price

Construction Project Planning & Project scheduling -MS Excel - Price chart

Rating

Construction Project Planning & Project scheduling -MS Excel - Ratings chart

Enrollment distribution

Construction Project Planning & Project scheduling -MS Excel - Distribution chart
3720546
udemy ID
12/22/2020
course created date
3/7/2021
course indexed date
Bot
course submited by