Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Quantity Estimating & Costing for Building

Name: Quantity Estimating & Costing for Building
Rating: 4.6 (27 reviews)

Excel for Quantity Estimation, Quantity Calculation for Building, Material Requirement, Preparing Bill, Rate Analysis

Created byPravin Khandve

Last updated 2/2023

English

English [Auto],

What you'll learn

Prepare Complete Detailed Estimate of Building using Excel.
Use Current Schedule of Rate book published by PWD
Calculate detailed quantity of complete building items using Excel
Calculate Floor wise / Phase wise / Duration wise Cost using Excel
Calculate Complete Quantity of all material require for building using Excel
Fill Measurement Book from site work for preparing running bills.

Course content

2 sections • 31 lectures • 40h 57m total length

Introduction1:41:53
Download the MS Excel 2010 pdf file for start learning basic excel skills. Read it carefully and try to perform the given task to learn various functionality given in Excel.
Day-1 Lecture1:17:28
Download Pdf file for day wise lecture notes.
Day-2 Lecture53:07
Explore essential Excel techniques for quantity estimating and costing, including navigation shortcuts, selecting and moving data, managing worksheets, and applying formatting for clear cost sheets.
Day-3 Lecture1:43:41
Learn to prepare complete building estimates in Excel, applying quantity takeoff, cost calculations, and the schedule of rates with the PWD standards for civil engineering internships.
Assignment-1 on Excel Formula Tutorial
Day-4 Lecture58:59
Learn Excel techniques for quantity estimating: insert rows and columns, set uniform row heights, apply precise decimal formatting on measurement and abstract sheets, and configure headers, footers, and legal-page printing.
Assignment-2 on Excel Basic Tutorial
Day-5 Lecture1:13:02
Develop professional Excel skills for quantity estimating and costing by completing daily exercises, preparing measurement and abstract sheets, and using the CSR book and the current schedule of rates.
Assignment-3 Excel Practice for Beginners
Day-6 Lecture1:17:41
Demonstrate how to create and format a measurement sheet in Excel for quantity estimating, including page setup, inserting AutoCAD screenshots, and arranging images with freeze panes, split, and autofill.
Assignment-4 Excel Practice Work Exercise
Assignment-5 Excel Extra Practice Exercise
Day-7 Lecture1:38:31
Day-7 lecture teaches Excel-based quantity estimation and costing, including creating a measurement sheet aligned with AutoCAD drawings and using formulas, functions, and data tools to automate calculations.
Assignment-6 Excel Practice Exercise
Day-8 Lecture1:51:26
Develop hands-on excel skills for quantity estimation and costing in building projects, blending field observation with measurement sheets and formulas. Practice daily, collaborate, and solve problems on site.

Day-9 Lecture1:16:05
Master quantity estimating and costing for building projects using CSR/SSR rates. Learn to prepare site plans, ground and first floor drawings, elevations, cross sections, and detailed cost estimates in AutoCAD.
Day-10 Lecture1:06:25
Describe preparing building estimates with CSR rates, covering lead distance, transportation, loading and unloading, cement consumption, adverse conditions, floorwise rate increases, and the need for detailed plans and approvals.
Day-11 Lecture1:20:43
Day-11 builds on estimating and costing by reviewing exercises, submitting plans, and starting actual estimates. It emphasizes CSR and SSR material and labour rates, transport costs, and overhead.
Day-12 Lecture1:49:55
Learn to prepare a complete building estimate using CSR rates, compile material, labor, and equipment lists in Excel, and apply brief and detailed specifications from CSR/SSR.
Day-13 Lecture1:49:43
Learn practical quantity estimating and costing for building projects, focusing on excavation, foundations, PCC and RCC works, using Excel, trial pits, footing and column sizing, and daily measurement documentation.
Day-14 Lecture1:37:50
Day-14 guides you to estimate RCC quantities—from excavation and footing to columns, beams, lintels, and slabs—using Excel and CSR-based itemization, with practical size and bearing considerations.
Day-15 Lecture1:20:26
Master quantity estimation and costing for building projects, covering excavation, foundation, RCC beams and lintels, ground and plinth beams, brick masonry, and reinforcement planning.
Day-16 Lecture1:33:19
Day-16 of quantity estimating & costing for building trains interns to calculate excavation, plinth filling, RCC quantities, and record results in Excel.
Day-17 Lecture1:39:37
Master quantity estimating for building by calculating footing quantities, excavation, bed concrete, and trapezoidal RCC footing from drawings. Then compute column height, plinth, and ground beams using cross-sections and dimensions.
Day-18 Lecture1:02:23
Master quantity estimation for building substructure, from plinth construction and anti-termite treatments to RCC slab, beams, stairs, and waste slabs, guided by SSR references.
Day-19 Lecture1:08:38
Learn detail quantity estimation in the PWD style and accurate project cost planning. Apply Excel-based estimating, SSR references, and modern tools like BIM for on-site planning and management.
Day-20 Lecture56:12
Explore how to select and quantity door and window atoms from the SSR, including granite and frp frames, shutters, aluminum windows, and ventilation calculations for accurate building cost estimation.
Day-21 Lecture1:19:05
Learn to estimate building quantities by selecting door and window atoms, applying external and internal plaster calculations, and accounting for openings, chicken mesh, and RCC details using SSR guidelines.
Day-22 Lecture1:02:53
Learn to estimate plaster quantities for external and internal walls, deducting doors and windows. Apply SSR atoms for flooring, dado, skirting, vitrified tiles, granite, and mild steel grills.
Day-23 Lecture1:01:09
Develop professional estimating skills by calculating quantities for building components—granite platforms, tiles, jambs and sanitary fittings—and applying SSR rates for accurate cost planning of water supply systems.
Day-24 Lecture1:04:48
Explore accurate quantity estimation and cost budgeting for water supply, sanitary fittings, and plumbing in residential buildings, including pipe sizing, fixtures, soak pits, inspection chambers, and rainwater systems.
Day-25 Lecture1:15:01
Learn to prepare a detailed quantity estimate and material consumption, complete measurement sheets, rate analysis, and lead statements for residential building projects.
Day-26 Lecture1:06:25
Develop and complete a measurement sheet of 80 atoms, convert quantities into rate analysis and abstract sheets in Excel, applying CSR, SSR, and lead statements for building costing.
Day-27 Lecture1:10:48
Complete measurement sheets, rate analyses, and material calculations using the SSR, incorporating transportation charges, CSR rate increases for municipal areas, and first- and second-floor rate adjustments for accurate costs.
Day-28 Lecture1:19:01
Master building cost estimation by preparing measurement and abstract sheets, conducting CSR-based rate analysis, and calculating quantities to generate running bills in Excel.
Day-29 Lecture56:19
Learn quantity estimating and costing for building by creating measurement sheets, rate analyses, abstracts, and lead statement. Apply Excel-based material cost bifurcation to manage site execution and budgeting.
Day-30 Lecture1:24:35
Learn to prepare measurement sheets, rate analysis, and material consumption using SSR factors to accurately estimate cement, sand, aggregates, steel, bricks, and tiles for building projects.

Requirements

Knowledge of Basics of Building Construction
Knowledge of Building Plan, elevation and section detailing,
Use of scientific calculator
Knowledge of basic concepts of estimating and costing
Basic knowledge of M S Excel skill
Knowledge of AutoCAD Drawing

Description

Part-A] Spreadsheet Practice

The Interface – The Ribbon, Quick Access Toolbar, File Tab, Entering Data into Cells

Basic Formatting – Basic Formatting – Labels & Values, Calculating with Formulas, Copy a Formula with Autofill, Quick Addition with AutoSum, Save Your Work. Exercise –1 & 2

Formulas and Functions – Writing and Copying Formulas, Absolute References, The AutoSum Function, The Payment Function, Exercise

Tables & Charts- Create an Excel Table, Table Tools – Design Tab, Sort Your Data, Filter Your Data, Insert a basic graph, Move a chart to a new worksheet,

Extra Tools – Converting Text to Columns, Conditional Formatting, Using Count & Countif Functions, Removing Duplicates, Sheet Protection, The Excel Table Feature

Part-B] Professional PWD Quantity Estimating & Costing

a) Preparing Building Plan & Section for Estimating

b) Measurement Sheet using Excel – 60 Building Items

c) Using Current Schedule of Rates

d) Abstract Sheet using Excel

e) General Abstract Sheet using Excel

f) Material Quantity Calculation

g) Site Visit for Offline batch only

Trainee will be able to –

a) Prepare Complete Detailed Estimate of Building using Excel.

b) Use Current Schedule of Rate book published by PWD

c) Calculate detailed quantity of complete building items using Excel

d) Calculate Floor wise / Phase wise / Duration wise Cost using Excel

e) Calculate Complete Quantity of all material require for building using Excel

Fill Measurement Book from site work for preparing running bills.

Who this course is for:

Building Site Supervisor,
ITI Draughtsman,
Civil Engineering Polytechnic Diploma Students
Civil Engineering Fresher Graduates,
B. Arch. Fresher Graduates
Civil Engineering Assistant
Junior Quantity Surveyor

Quantity Estimating & Costing for Building

What you'll learn

Explore related topics

Course content

Part-A] Spreadsheet Practice9 lectures • 12hr 36min

Part-B] Professional PWD Quantity Estimating & Costing22 lectures • 28hr 21min

Requirements

Description

Who this course is for: