Quantity Surveying/Building Estimation Cad and Excel In Urdu

Quantity Surveying/Estimation, Bar bending Schedule, And Mode Of Payments To Contractors Like Interim Payment.

Advanced 5(1 Ratings) 4 Students enrolled Urdu
Created by Mudessar Afraz
Last updated Tue, 16-Aug-2022
+ View more
Course overview

Welcome to Quantity Surveying /Building Estimation online training course. it is focused on practical application of Estimation using Auto Cad & M.S Excel

This course is a field oriented course and contains real examples and a full fledge real project for better understanding

After successful completion of this course, you will be able to develop a schedule, How to read Drawings, Different Parts Of Drawings,

Excavation Work

  • How to Find Out Excavation Quantity ,

Concrete Work And Brick Work Substructure And Superstructure

  • How to Find Plain Cement Concrete,

  • How to Find Out Brick Work in Foundation And In Superstructure,

  • How to Find Concrete In Beam And Columns,

Bar bending Schedule

  • How to Prepare Bar bending Schedule Sheet In Excel,

  • Bar bending Schedule Basics

  • How to Find Steel ,Like

  • Bar-bending Schedule Of Column Necks And Columns

  • Bar-bending Schedule Of Beams

  • Bar-bending Schedule Of Stairs

  • Bar Bending Schedule Of Slab

Rate Analysis Of Different Works:

Rate Analysis For Excavation

Rate Analysis For Plain Cement Concrete (P.C.C)

Rate Analysis For Reinforcement Concrete (Column Beam And Slab)

Rate Analysis For Masonry Work

Rate Analysis For Plaster Work

Rate Analysis For Tile Work

Rate Analysis For Paint Work

Finishing Work

Quantity For Tiles

Quantity For Marble

Quantity For Skirting

Quantity For Plaster

Quantity For Paint

Material Statement :

Material Statement In Excel

Bill Of Quantity (B.O.Q)

Bill Of Quantity For A Project According To CSI Codes

Mode Of Payments To Contractors

  • Advance And Secured Advance

  • Final Payment And Mobilization Advance

  • How to Prepare Interim Payment In Excel Complete Procedure

What will i learn?

  • Estimation Of Complete Project With Excel And Autocad
  • Creating Material Statement In Excel Means We Will Find out Material To Be Used In Our Project
  • Steel Calculations
  • Bar bending Schedule Like , B.B.S For Footing, Columns, Beams And Slab
  • Bill Of Quantity (BOQ)
  • Mode Of Payments To Contractors
  • Interim Payment In Excel
Requirements
  • Basic Knowlege Of Civil Engineering.
Curriculum for this course
102 Lessons 13:53:16 Hours
Introduction
3 Lessons 00:24:29 Hours
  • Introduction To Estimation
    00:16:54
  • Measurement Form In Excel
    00:06:34
  • Practice Question 1
    00:01:01
Foundation Work
6 Lessons 00:29:48 Hours
  • Excavation For Foundation
    00:10:04
  • P.C.C For Foundation
    00:04:16
  • Formwork For Foundation
    00:09:04
  • R.C.C For Foundation
    00:03:33
  • Practice Question 1 For This Module
    00:01:24
  • Practice Question 2 For This Module
    00:01:27
Column Necks
3 Lessons 00:09:21 Hours
  • Formwork For Column Necks
    00:04:54
  • Concrete For Column Necks
    00:03:26
  • Practice Question For This Module
    00:01:01
Grade Beams
5 Lessons 00:44:03 Hours
  • Formwork For Grade Beam Part 1
    00:16:03
  • Formwork For Grade Beam Part 2
    00:13:02
  • Concrete For Grade Beam Part 1
    00:07:06
  • Concrete For Grade Beam Part 2
    00:06:41
  • Practice Question For This Module
    00:01:11
Slab On Grade
2 Lessons 00:19:18 Hours
  • Concrete For Slab On Grade Part 1
    00:12:09
  • Concrete For Slab On Grade Part 2
    00:07:09
Column In Super Structure
2 Lessons 00:09:58 Hours
  • Concrete For Column In Superstructure
    00:09:24
  • Practice Question For This Module
    00:00:34
Brick Work In Superstructure
3 Lessons 00:32:33 Hours
  • Brick Work In Superstructure Part 1
    00:16:22
  • Brick Work In Superstructure Part 2
    00:15:15
  • Practice Question For This Module
    00:00:56
Stairs
2 Lessons 00:25:05 Hours
  • Formwork For Stairs
    00:15:18
  • Concrete For Stairs
    00:09:47
Slab
3 Lessons 00:29:27 Hours
  • Formwork For Slab
    00:17:31
  • Concrete For Slab
    00:11:15
  • Practice Question For This Module
    00:00:41
Parapet Wall And Mumty
2 Lessons 00:08:52 Hours
  • Brick Work In Mumty
    00:07:24
  • Practice Question For This Module
    00:01:28
Plaster Works
6 Lessons 00:55:03 Hours
  • Internal Plaster Part 1
    00:10:21
  • Internal Plaster Part 2
    00:13:16
  • Stair Plaster
    00:15:00
  • Ceiling Plaster
    00:10:38
  • External Plaster
    00:05:06
  • Practice Question For This Module
    00:00:42
Tile And Marble
5 Lessons 00:44:13 Hours
  • Quantity Of Tiles In Toilet
    00:08:18
  • Quantity Of Marble On Floors
    00:13:09
  • Quantity Of Skirting
    00:16:55
  • Quantity Of Marble On Stairs
    00:05:04
  • Practice Question For This Module
    00:00:47
Paint Works
3 Lessons 00:21:43 Hours
  • Internal Painting
    00:15:34
  • Stair Ceiling And External Painting
    00:05:33
  • Practice Question For This Module
    00:00:36
Bar-Bending Schedule Basics
8 Lessons 00:46:29 Hours
  • Bar bending Schedule Basics
    00:05:32
  • Cut Length Of Main Bar
    00:05:56
  • Overlapping
    00:07:46
  • Cut Length Of Crank Bar
    00:06:29
  • Cut Length Of Rectangular Stirrups
    00:03:31
  • Cut Length Of Triangular Stirrups
    00:07:51
  • Cut Length Of Dimond Stirrups
    00:04:41
  • Cut Length Of Circular Stirrups And Chair Bar
    00:04:43
How to prepare Excel Sheet For B.B.S
3 Lessons 00:16:37 Hours
  • How to prepare B.B.S Sheet In Excel Part 1
    00:07:05
  • How to prepare B.B.S Sheet In Excel Part 2
    00:08:37
  • Practice Question For This Module
    00:00:55
Bar-Bending Schedule For Different Structures
11 Lessons 02:00:21 Hours
  • How to Prepare Bar Bending Schedule For Foundation
    00:14:03
  • How to Prepare Bar Bending Schedule For Column Necks
    00:14:20
  • How to Prepare Bar Bending Schedule For Columns
    00:11:37
  • How to Prepare Bar Bending Schedule For Grade Beams Part 1
    00:19:24
  • How to Prepare Bar Bending Schedule For Grade Beams Part 2
    00:08:36
  • How to Prepare Bar Bending Schedule For Stairs
    00:18:00
  • How to Prepare Bar Bending Schedule For Slab Part 1
    00:18:00
  • How to Prepare Bar Bending Schedule For Slab Part 2
    00:14:00
  • Practice Question For This Module 1
    00:00:45
  • Practice Question For This Module 2
    00:00:33
  • Practice Question For This Module 3
    00:01:03
Procedure To Find out Material
3 Lessons 00:09:23 Hours
  • How to Find out Material Part 1
    00:03:47
  • How to Find out Material Part 2
    00:02:50
  • How to Find out Material Part 3
    00:02:46
Material Statement In Excel
5 Lessons 00:36:14 Hours
  • How to Prepare Material Statement In Excel Part 1
    00:07:56
  • How to Prepare Material Statement In Excel Part 2
    00:13:01
  • How to Prepare Material Statement In Excel Part 3
    00:05:39
  • How to Prepare Material Statement In Excel Part 4
    00:08:54
  • Practice Question For This Module
    00:00:44
Rate Analysis
8 Lessons 02:04:55 Hours
  • Introduction To Rate Analysis
    00:07:14
  • Rate Analysis For Excavation
    00:18:56
  • Rate Analysis For R.C.C Part 1
    00:16:50
  • Rate Analysis For R.C.C Part 2
    00:18:14
  • Rate Analysis For Brick Works
    00:18:21
  • Rate Analysis For Plaster Works
    00:17:35
  • Rate Analysis For Tile Works
    00:15:24
  • Rate Analysis For Paint Works
    00:12:21
Bill Of Quantity
1 Lessons 00:07:57 Hours
  • How to Create B.O.Q
    00:07:57
Mode Of Payments To Contractors
8 Lessons 01:01:26 Hours
  • Mode Of Payments To Contractors
    00:07:16
  • Advance And Secured Advance
    00:03:36
  • Final Payment And Mobilization Advance
    00:12:57
  • How to Prepare Interim Payment In Excel Part 1
    00:12:59
  • How to Prepare Interim Payment In Excel Part 2
    00:05:18
  • How to Prepare Interim Payment In Excel Part 3
    00:04:41
  • How to Prepare Interim Payment In Excel Part 4
    00:08:17
  • How to Prepare Interim Payment In Excel Part 5
    00:06:22
Excel Training For Beginners
9 Lessons 00:56:01 Hours
  • Font Panel
    00:05:17
  • Border
    00:06:15
  • Alignment Panel
    00:06:05
  • Number Panel
    00:07:20
  • Formulas Part 1
    00:07:20
  • Formulas Part 2
    00:05:13
  • Formulas Part 3
    00:05:58
  • Formulas Part 4
    00:07:52
  • Conditional Formatting
    00:04:41
Resources To Download
1 Lessons 00:00:00 Hours
  • Resources To Download [Excel Sheets,B.B.S Sheets,IPC,Drawing File]
    .
+ View more
Other related courses
01:39:44 Hours
Updated Wed, 21-Dec-2022
5 39 Free
02:59:00 Hours
5 29 Free
37:25:21 Hours
0 0 15000₨ 3500₨
05:58:46 Hours
0 7 Free
About instructor

Mudessar Afraz

Civil Engineer

8 Reviews | 71 Students | 10 Courses
Planning Engineer Quantity Surveyor
Student feedback
5
1 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (1)

Reviews

  • Umar Hayat
    Good teaching method thanks.
9000₨ 1900₨
Includes: