Quantity Estimating & Costing For Building

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

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.

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 PracticeThe Interface – The Ribbon, Quick Access Toolbar, File Tab, Entering Data into CellsBasic Formatting – Basic Formatting – Labels & Values, Calculating with Formulas, Copy a Formula with Autofill, Quick Addition with AutoSum, Save Your Work. Exercise –1 & 2Formulas and Functions – Writing and Copying Formulas, Absolute References, The AutoSum Function, The Payment Function, ExerciseTables & 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 FeaturePart-B] Professional PWD Quantity Estimating & Costinga) Preparing Building Plan & Section for Estimatingb) Measurement Sheet using Excel – 60 Building Itemsc) Using Current Schedule of Ratesd) Abstract Sheet using Excele) General Abstract Sheet using Excelf) Material Quantity Calculationg) Site Visit for Offline batch onlyTrainee will be able to –a) Prepare Complete Detailed Estimate of Building using Excel.b) Use Current Schedule of Rate book published by PWDc) Calculate detailed quantity of complete building items using Exceld) Calculate Floor wise / Phase wise / Duration wise Cost using Excele) Calculate Complete Quantity of all material require for building using ExcelFill Measurement Book from site work for preparing running bills.

Overview

Section 1: Part-A] Spreadsheet Practice

Lecture 1 Introduction

Lecture 2 Day-1 Lecture

Lecture 3 Day-2 Lecture

Lecture 4 Day-3 Lecture

Lecture 5 Day-4 Lecture

Lecture 6 Day-5 Lecture

Lecture 7 Day-6 Lecture

Lecture 8 Day-7 Lecture

Lecture 9 Day-8 Lecture

Section 2: Part-B] Professional PWD Quantity Estimating & Costing

Lecture 10 Day-9 Lecture

Lecture 11 Day-10 Lecture

Lecture 12 Day-11 Lecture

Lecture 13 Day-12 Lecture

Lecture 14 Day-13 Lecture

Lecture 15 Day-14 Lecture

Lecture 16 Day-15 Lecture

Lecture 17 Day-16 Lecture

Lecture 18 Day-17 Lecture

Lecture 19 Day-18 Lecture

Lecture 20 Day-19 Lecture

Lecture 21 Day-20 Lecture

Lecture 22 Day-21 Lecture

Lecture 23 Day-22 Lecture

Lecture 24 Day-23 Lecture

Lecture 25 Day-24 Lecture

Lecture 26 Day-25 Lecture

Lecture 27 Day-26 Lecture

Lecture 28 Day-27 Lecture

Lecture 29 Day-28 Lecture

Lecture 30 Day-29 Lecture

Lecture 31 Day-30 Lecture

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