Quantity Estimating & Costing for Building

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.