Quantity Surveying/Building Estimation With Cad And Excel
Created by Mudessar Afraz, Last Updated 15-Sep-2020, Language:English
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
Preview00:05:28
-
-
Foundation Work
8 Lectures 00:24:38-
Introduction To Isolated Foundation
Preview00:03:19 -
Quantity Of Excavation For Isolated Foundation
Preview00:07:54 -
Quantity Of P.C.C
00:03:09 -
How to Find Quantity Of Form-work In Foundation
Preview00: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
Preview00: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
Preview00: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
Preview00: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
Preview00: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
-