Building Quantity Estimation & Bbs With Excel For Beginners

Name: Building Quantity Estimation & Bbs With Excel For Beginners
Rating: 4.3 (414 reviews)

QUANITY ESTIMATION, BAR BENDING SCHEDULE , THUMB RULE FOR QUICK ESTIMATION, BRICK WORKS & UNDERGROUND WATER TANK COSTING

Created byAkshay Kamath

Last updated 11/2023

English

What you'll learn

QUANTITY ESTIMATION FOR EXCAVATION, PCC & FOOTING SHUTTERING
BAR BENDING SCHEDULE FOR FOOTING
ESTIMATION OF UNDER GROUND SUMP TANK
QUICK EXCEL TIPS & FORMULAS
THUMB RULE FOR QUICK BUILDING ESTIMATION

Course content

5 sections • 15 lectures • 1h 58m total length

CALCULATE EXCAVATION QUANTITY19:34
Calculate excavation quantities for footing foundations by reading foundation drawings, counting footings (F1, F2, F3), applying offsets and working space, and computing in Excel.
CALCULATE PCC QUANTITY3:38
Learn to calculate PCC quantity using Excel by entering thickness from drawings, compute volume (length × breadth × thickness), and drag formulas to arrive at 36.2 cubic meters.
CALCULATE FOOTING SHUTTERING QUANTITY6:11
Calculate footing shuttering quantity by deriving perimeter from length and breadth, multiply by footing depth, apply to all footings, totaling 232.25 square meters.

CALCULATE BRICKWORK & BRICKS REQUIRED FOR BUILDING ( MANUAL )18:43
Calculate brickwork quantities manually for a building, then replicate method in Excel; determine area and perimeter, deduct openings and columns, and compute bricks, mortar, cement, sand, and water needs.
PREPARE ABSTRACT FOR BUILDING WITH EXCEL ( BRICKS, CEMENT , AGGREGATE + WATER )5:10
Learn to prepare an excel-based abstract for building quantities, calibrating bricks, cement, aggregate, and water, and compute areas, volumes, and costs with a 1:4 ratio.
HOW TO MAKE CHANGES IN EXCEL QUICKLY TO GET ABSTRACT1:18
Learn how to quickly adjust Excel calculations to get accurate estimates by handling missing data with zeros or blanks, and verify results through manual calculations.

CUTTING LENGTH OF FOOTING ALONG SHORTER SPAN15:35
Calculate footing cutting lengths for shorter and longer spans in an Excel model, determine land requirements, cover gaps, and estimate total steel weight and number of bars by diameter.
CUTTING LENGTH OF FOOTING ALONG LONGER DIRECTION4:43
Calculate the cutting length of footing along the longer direction, determine the bar length, spacing, and number of bars needed for the footing.

QUICK ESTIMATION OF STEEL REQUIRED FOR SLAB3:59
Quickly estimate steel for slabs by computing concrete volume from slab area and thickness, then apply a standard steel gauge per cubic foot to determine total steel.
CALCULATE CEMENT , SAND & AGGREGATE REQUIRED FOR 500 SQ FT HOUSE PLAN6:19
Calculate cement, sand, and aggregate for a 500 sq ft slab. Convert area and thickness to meters and estimate cement bags and reinforcement weight for M20 concrete.
QUICK CONCRETE , CEMENT, SAND & AGGREGATE REQUIREMENT FOR HOUSE CONSTRUCTION6:34
Learn to quickly estimate concrete quantities for house construction using Excel for beginners, calculating cement, sand, aggregate, and water, plus steel reinforcement for residential and commercial slabs.
CALCULATE PLYBOARDS REQUIRED FOR SHUTTERING QUICKLY5:08
Estimate shuttering quickly by calculating plywood required from area, plus timber, nails, binding wire, buttons, and shuttering oil with simple conversion rules.
CALCULATE SHUTTERING QUANTITY QUICKLY IN 1 MINUTE7:23
Calculate shuttering quantity quickly with practical rules for steel and concrete across foundations, columns, beams, slabs, and footings, using per-cubic-meter estimates and unit conversions.

QUICK ESTIMATION OF WATER TANK ( CEMENT, SAND, AGGREGATE & WATER )9:41
Compute the quick concrete estimate for a large water tank by deriving the wall height, perimeter, and thickness, then apply cement, sand, aggregate, and water ratios in an Excel calculator.
QUICK ESTIMATION FOR WATER TANK SLAB4:43
Use Excel to estimate a water tank slab by calculating slab thickness and area, concrete quantity, and cement, sand, and aggregate needs from listed lengths and wall dimensions.

Requirements

PATIENCE TO LEARN

Description

This Courses is a Beginner Course for those students who want to choose Quantity Estimation as their Subject & Become a Professional in this Field.

The course is prepared with the intention that the learners will understand the basic of quantity Estimation .

After the Course completion the learner can try to apply these concepts practically in their Homes or near by buildings and get a Rough Estimate of the total Building cot and how much Cement bags, Sand, Coarse Aggregate & Water has been used in the structure .

We all know that an "Estimate" is a rough calculation of the quantities of various items of work,like cement , Sand , Coarse aggregate and the expenses likely to be incurred for the construction projects that one may undertake to complete successfully. Hence, the total of these probable expenses to be incurred on the work is known as the estimated cost of the work. The estimated cost of a work is actually a close approximation of its actual cost.

Thumb Rules for Quick Calculations of Shuttering & Concrete Materials

Thumb rule for finding Footing Shuttering Quantity with footing Concrete Quantity.
Thumb rule for Finding Beam, Column & Slab Shuttering & Centering Quantity with Concrete Quantity.
MISCELLANEOUS LECTURES
Estimation & Costing of Under Ground Water tank of 50 Kl ( EXCEL CALCULATIONS )

Who this course is for:

QUANITIY SURVEYORS , QUANTITY ESTIMATORS, CIVIL ENGINEERS , STRUCTURAL ENGINEERS, BAR BENDING ENGINEERS

Building Quantity Estimation & Bbs With Excel For Beginners

What you'll learn

Explore related topics

Course content

ESTIMATION & COSTING3 lectures • 29min

ESTIMATION & COSTING FOR BRICK WORK & EXCEL CALCULATIONS & FORMULAS3 lectures • 25min

BAR BENDING SCHEDULE IN BRIEF2 lectures • 20min

THUMB RULES FOR QUICK CALCULATIONS5 lectures • 29min

QUICK EXCEL SHEET CALCULATIONS & ADVANCE TOPIC FOR ESTIMATION2 lectures • 14min

Requirements

Description

Who this course is for: