Udemyexperten

Quantity Estimating & Costing for Building

Master Excel for accurate quantity estimation & building material calculations. Learn to prepare bills of quantities & analyze rates efficiently.

4.7(20)
143students
40h 57m
Certificate
Pravin Khandve
Pravin KhandveAssistant Professor in Civil Engineer and Book Author

Course Content

Quantity Estimating & Costing for Building is an advanced Udemy course taught by Pravin Khandve. It runs 40h 57m, is taught in English, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 20 reviews, with 143 students enrolled. It is a paid course, first published February 2023.

Excel Skills for Quantity Surveying & Cost Estimating

Part-A: Mastering Excel Fundamentals

This section provides a comprehensive introduction to Excel for practical application in quantity surveying. You'll learn the essential tools and techniques to efficiently manage and analyze construction data.

  • Navigating the Interface: Become familiar with the Excel Ribbon, Quick Access Toolbar, and File Tab for streamlined workflow.
  • Data Entry & Basic Formatting: Learn to accurately enter data into cells, format labels and values, and utilize basic formulas for calculations.
  • Formula Proficiency: Master copying formulas with Autofill, leveraging the AutoSum function for quick calculations, and understanding the Payment Function.
  • Data Organization with Tables: Create and utilize Excel Tables for enhanced data management and efficient sorting and filtering. Explore the Table Tools - Design Tab.
  • Data Analysis & Visualization: Sort and filter data within tables, and insert basic graphs to visualize trends and insights. Learn to move charts between worksheets.
  • Advanced Data Tools: Efficiently convert text to columns, apply conditional formatting for data highlighting, and utilize Count & Countif functions for data aggregation. Remove duplicates and protect your Excel sheets.

Exercises: Practical exercises reinforce each concept, building your confidence and skill.

Part-B: Professional Quantity Estimating & Costing with Excel

This section focuses on applying Excel to the specific tasks of PWD (Public Works Department) quantity estimation and costing.

  • Plan Preparation: Learn to prepare building plans and sections specifically for estimating purposes.
  • Measurement Sheets: Create detailed measurement sheets using Excel covering 60 common building items.
  • Schedule of Rates Integration: Effectively utilize the current Schedule of Rates published by the PWD.
  • Abstract Sheets: Develop abstract sheets using Excel to summarize quantities and costs.
  • General Abstract Sheets: Create comprehensive general abstract sheets using Excel for detailed cost breakdowns.
  • Material Quantity Calculation: Accurately calculate the quantity of all materials required for construction projects using Excel.
  • Site Visit Integration: Learn how to integrate site visit data into your Excel estimates for offline batch processing.

Upon completion, you will be able to:

  • Prepare complete and detailed building estimates using Excel.
  • Apply the current PWD Schedule of Rates effectively.
  • Calculate detailed quantities for all building items using Excel.
  • Calculate floor-wise, phase-wise, and duration-wise costs using Excel.
  • Calculate the complete material quantity required for a building project using Excel.
  • Fill Measurement Books from site work to prepare running bills.

This course equips you with the practical Excel skills necessary for accurate and efficient quantity surveying and cost estimating within the PWD framework.

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

SAP S4: CO "UPA"-Event-Based-Product Costing by Period-MTS

by Karanam Sreedhar : SAP S/4 HANA Controlling-Subject Matter Expert

5.0(18)
21h 27m
all
5.0(59)
1h 35m
beginner

SAP S4: CO "UPA"-Event-Based-Product Costing by Order-MTS

by Karanam Sreedhar : SAP S/4 HANA Controlling-Subject Matter Expert

4.9(52)
18h 35m
all
4.9(1,309)
1h 39m
all

SAP S/4 HANA 'UPA' : Material Ledger/Actual Costing-CKMLCP

by Karanam Sreedhar : SAP S/4 HANA Controlling-Subject Matter Expert

4.8(18)
27h 24m
all