Quantity Surveying/Building Estimation With Cad And Excel

Building Estimation/ Quantity Surveying/Quantity Takeoff/Steel Estimation/Rate Analysis/Construction Quantity Takeoff

Created by Mudessar Afraz, Last Updated 15-Sep-2020, Language:English

What Will I Get ?

Estimation Of Complete Project Through Auto-cad And Excel
Bar bending Schedule Of Foundation,Columns,Beams,Slab,Stairs, In Excel
How to Find Material Like Cement,Sand,Coarse Aggregates,Bricks
Complete Material Statement In Excel
Rate Analysis For Different Works Like ,Excavation, P.C.C, R.C.C, Masonry, Tiles, Plaster, Paint In Excel
Will Learn How to Create B.O.Q Of Project
Microsoft Excel For Beginners
Auto-cad 2020 For Beginners

Requirements

To have the Auto Cad And M.S Excel installed in your computer.
To have the minimum understanding for Civil Quantity/Estimation
To have a minimum understanding of construction processes

Description

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 Estimate Any Building Project (From Foundation To Finishing)

Major Topics That We Will Learn In This Course:

Quantity Of Substructure (Isolated Footing)
Quantity Of Superstructure (Columns,Beams Masonry, Slab,Finishing Work)

Bar bending Schedule:

Bar-bending Schedule Of Isolated Footing
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

Material Statement :

Material Statement In Excel

Bill Of Quantity (B.O.Q)

Bill Of Quantity For A Project According To CSI Codes

Excel Training For Beginners

As Excel Is Important For This Course So I Have Add Basic Training And Formulas For Those Who Are Beginners In Excel

Auto-cad Training

As Auto-cad Is Also Essential For This Course So I Have Also Included Auto-cad Training For Those Who Are Beginner In Auto-cad

Course Content

Introduction

1 Lectures 00:05:28
- Introduction To Estimation
  
  Preview
  
  00:05:28
Foundation Work

8 Lectures 00:24:38
- Introduction To Isolated Foundation
  
  Preview
  
  00:03:19
- Quantity Of Excavation For Isolated Foundation
  
  Preview
  
  00:07:54
- Quantity Of P.C.C
  
  00:03:09
- How to Find Quantity Of Form-work In Foundation
  
  Preview
  
  00:05:18
- How to Find Quantity Of Concrete In Foundation
  
  00:02:45
- Practice Question 1 For This Module
  
  00:00:52
- Practice Question 2 For This Module
  
  00:00:54
- Practice Question 3 For This Module
  
  00:00:27
Column Necks

3 Lectures 00:07:19
- Quantity Of Form-work In Column Necks
  
  00:04:12
- Concrete In Column Necks
  
  00:02:46
- Practice Question For This Module
  
  00:00:21
Grade Beam

7 Lectures 00:45:47
- Form-work For Grade Beams Part 1
  
  Preview
  
  00:07:38
- Form-work For Grade Beams Part 2
  
  00:06:13
- Form-work For Grade Beams Part 3
  
  00:07:10
- Form-work For Grade Beams Part 4
  
  00:07:06
- Concrete For Grade Beams Part 1
  
  00:09:26
- Concrete For Grade Beams Part 2
  
  00:07:44
- Practice Question
  
  00:00:30
Slab On Grade

2 Lectures 00:18:37
- Concrete For Slab On Grade Part 1
  
  00:10:29
- Concrete For Slab On Grade Part 2
  
  00:08:08
Column In Superstructure

2 Lectures 00:06:36
- Concrete For Column In S.S
  
  00:06:07
- Practice Question
  
  00:00:29
Question

1 Lectures 00:00:45
- Practice Question
  
  00:00:45
Brick Work In Superstructure

3 Lectures 00:30:03
- Brick Work For Superstructure Part 1
  
  00:14:54
- Brick Work For Superstructure Part 2
  
  00:14:34
- Practice Question
  
  00:00:35
Stairs

2 Lectures 00:20:22
- Form-work For Stairs
  
  00:10:47
- Concrete For Stairs
  
  00:09:35
Slab

4 Lectures 00:26:18
- Form-work For Slab Part 1
  
  00:09:42
- Form-work For Slab Part 2
  
  00:09:29
- Concrete For Slab
  
  00:06:29
- Practice Question
  
  00:00:38
Parapet Wall And Mumty

2 Lectures 00:07:30
- B.W In Parapet Wall
  
  00:06:50
- Practice Question
  
  00:00:40
Plaster Work

6 Lectures 00:45:46
- Internal Plaster Part 1
  
  Preview
  
  00:09:53
- Internal Plaster Part 2
  
  00:11:50
- Plaster For Stairs
  
  00:11:05
- Ceiling Plaster
  
  00:08:12
- External Plaster
  
  00:04:27
- Practice Question
  
  00:00:19
Tiles And Marble

5 Lectures 00:32:13
- Quantity Of Tiles
  
  00:06:57
- Quantity Of Marble
  
  00:08:32
- Skirting Quantity
  
  00:11:14
- Quantity Of Marble In Stairs
  
  00:05:00
- Practice Question
  
  00:00:30
Paint Work

4 Lectures 00:21:30
- Quantity Of Internal Paint Part 1
  
  00:07:46
- Quantity Of Internal Paint Part 2
  
  00:09:55
- Stairs Ceiling And External Painting
  
  00:03:40
- Practice Question
  
  00:00:09
Bar bending Schedule Basic

8 Lectures 00:32:20
- Bar Bending Schedule Basic
  
  Preview
  
  00:04:10
- Cut Length For Main Bar
  
  00:03:58
- Overlapping
  
  00:05:01
- Cut Length Of Bent-up Or Crank Bar
  
  00:05:34
- Cut Length Of Rectangular Stirrups
  
  00:02:38
- Cut Length Of Triangular Stirrups
  
  00:03:21
- Cut Length Of Diamond Stirrups
  
  00:03:19
- Cut Length Of Circular Stirrups And Chair Bar
  
  00:04:19
Bar Bending Schedule In Excel

16 Lectures 02:15:22
- How to Prepare B.B.S Sheet In Excel Part 1
  
  Preview
  
  00:03:02
- How to Prepare B.B.S Sheet In Excel Part 2
  
  00:07:46
- Bar Bending Schedule For Footing
  
  00:13:22
- Bar Bending Schedule For Column Necks
  
  00:12:43
- Bar Bending Schedule For Columns
  
  00:14:16
- Bar Bending Schedule For Beam Part 1
  
  00:11:37
- Bar Bending Schedule For Beam Part 2
  
  00:12:43
- Bar Bending Schedule For Beam Part 3
  
  00:10:07
- Bar Bending Schedule For Stairs Part 1
  
  00:09:10
- Bar Bending Schedule For Stairs Part 2
  
  00:09:56
- Bar Bending Schedule For Slab Part 1
  
  00:16:08
- Bar Bending Schedule For Slab Part 2
  
  00:12:19
- Practice Question 1 For This Module
  
  00:00:30
- Practice Question 2 For This Module
  
  00:00:32
- Practice Question 3 For This Module
  
  00:00:40
- Practice Question 4 For This Module
  
  00:00:31
Procedure To Find-out Material

3 Lectures 00:07:46
- How to Find Quantity Of Cement Sand And Coarse Aggregates In Concrete
  
  00:03:06
- How to Find Quantity Of Cement And Sand In Plaster
  
  00:02:42
- How to Find Quantity Of Bricks
  
  00:01:58
Material Statement In Excel

6 Lectures 00:27:25
- Material Statement Part 1
  
  00:02:41
- Material Statement Part 2
  
  00:06:09
- Material Statement Part 3
  
  00:07:27
- Material Statement Part 4
  
  00:06:43
- Explanation Of Material Statement Sheet In Excel
  
  00:04:02
- Practice Question For This Module
  
  00:00:23
Rate Analysis

7 Lectures 00:24:05
- Introduction To Rate Analysis And Excavation Rate Analysis
  
  00:04:15
- Rate Analysis For P.C.C
  
  00:04:12
- Rate Analysis For R.C.C (Column,Beam,Slab)
  
  00:05:23
- Rate Analysis For Brick Work
  
  00:02:48
- Rate Analysis For Plaster
  
  00:02:57
- Rate Analysis For Tiles
  
  00:02:44
- Rate Analysis For Paint
  
  00:01:46
Bill Of Quantity (B.O.Q)

2 Lectures 00:11:15
- B.O.Q For Excavation
  
  00:03:50
- B.O.Q For Concrete Work
  
  00:07:25
Excel Training For Beginners

5 Lectures 00:26:03
- Font Panel
  
  00:04:33
- Border In Excel
  
  00:05:41
- Alignment Panel
  
  00:05:26
- Number Panel
  
  00:06:12
- Conditional Formatting
  
  00:04:11
Formulas In Excel

4 Lectures 00:24:21
- Formulas (Sum,Subtract,Multiply,Divide)
  
  00:05:55
- Formulas (Countblank ,Countif ,Sumif)
  
  00:05:20
- Formula ( IF )
  
  00:06:06
- Formulas (NETWORKDAYSINTL, VLOOKUP)
  
  00:07:00
Auto-cad Training For Beginners (Introduction)

9 Lectures 00:35:27
- User Interface Of Auto-cad
  
  00:09:21
- Application Button
  
  00:02:37
- Navigation Options
  
  00:03:49
- Cartesian And Polar Co-ordinates In Auto-cad
  
  00:02:57
- How to Set Drawing Units
  
  00:04:11
- How to Set Measuring Unit
  
  00:04:12
- How to Set Drawing Limits
  
  00:03:53
- Template
  
  00:01:45
- Practice Question
  
  00:02:42
Commands

8 Lectures 00:56:56
- Line Command
  
  00:10:37
- How to Draw Circle In Auto-cad
  
  00:05:56
- How to Draw Arc
  
  00:08:59
- How to Draw Ellipse
  
  00:04:14
- How to Draw Rectangle
  
  00:08:25
- How to Draw Polygon
  
  00:05:52
- Poly-line And Spline
  
  00:09:15
- Practice Question
  
  00:03:38
Modifying Object

7 Lectures 00:31:45
- Selection
  
  00:04:36
- Move And Copy
  
  00:03:56
- Rotate
  
  00:04:14
- Offset
  
  00:04:29
- Scale
  
  00:05:12
- Mirror
  
  00:03:27
- Trim And Extend
  
  00:05:51
Dimensions

10 Lectures 00:50:27
- Creating Dimensions
  
  00:06:38
- DIM Command
  
  00:07:39
- Editing Dimensions
  
  00:05:05
- Own Dimension Style
  
  00:05:23
- Continue And Baseline Dimension
  
  00:03:07
- Associative And Non Associative Dimension
  
  00:05:38
- Add Multi leader
  
  00:04:10
- Edit Multi-leader
  
  00:04:39
- Creating Own Multi leader Style
  
  00:05:58
- Practice Question
  
  00:02:10
Final Note And Resources

1 Lectures 00:00:23
- Resources
  
  00:00:23

Mudessar Afraz

More Courses from Mudessar Afraz

Estimating And Costing

79 Lectures 10:23:12

~~$24.99~~ 8.99

Add to Cart