Quantity Estimating & Costing for Building (FHD)

[Srbija]

Quantity Estimating & Costing for Building
Last updated 2/2023
Created by Pravin Khandve
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Expert | Genre: eLearning | Language: English + subtitle | Duration: 31 Lectures ( 40h 57m ) | Size: 62.6 GB

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.

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


Homepage

Hidden Content

Give reaction to this post to see the hidden content.

Hidden Content

Give reaction to this post to see the hidden content.

Hidden Content

Give reaction to this post to see the hidden content.