Quantity Estimating & Costing For Building
Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 33.58 GB | Duration: 40h 57m

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

https://anonymz.com/?https://www.udemy.com/course/quantity-estimating-costing-for-building/

https://rapidgator.net/file/ca451f14d2039b46374223191b1d2fdd/Quantity_Estimating_Costing_for_Building.part1.rar
https://rapidgator.net/file/bcc46946ca52f2a80e964eefbbbe7401/Quantity_Estimating_Costing_for_Building.part2.rar
https://rapidgator.net/file/203c07bd7b205a9cd29b77e03e60e3d9/Quantity_Estimating_Costing_for_Building.part3.rar
https://rapidgator.net/file/7fdf630657cdaebfd5df873226524c9a/Quantity_Estimating_Costing_for_Building.part4.rar
https://rapidgator.net/file/dc1ed10240f6c6b11d8e410a84ae09ae/Quantity_Estimating_Costing_for_Building.part5.rar
https://rapidgator.net/file/be266f84b817d63bc8d13e78e2edaf6e/Quantity_Estimating_Costing_for_Building.part6.rar
https://rapidgator.net/file/2aee85472bdd6a1a42f59287b0bae01d/Quantity_Estimating_Costing_for_Building.part7.rar

https://nitroflare.com/view/0C4D229C808F4EF/Quantity_Estimating_Costing_for_Building.part1.rar
https://nitroflare.com/view/AAAE1D9BD8CC8E1/Quantity_Estimating_Costing_for_Building.part2.rar
https://nitroflare.com/view/41B4013AB96184A/Quantity_Estimating_Costing_for_Building.part3.rar
https://nitroflare.com/view/947EA052A66531A/Quantity_Estimating_Costing_for_Building.part4.rar
https://nitroflare.com/view/0FC4BE88F7D6A53/Quantity_Estimating_Costing_for_Building.part5.rar
https://nitroflare.com/view/7CB585CB1AC2F2F/Quantity_Estimating_Costing_for_Building.part6.rar
https://nitroflare.com/view/606D054C7350E9A/Quantity_Estimating_Costing_for_Building.part7.rar