Building Estimation Step by Step In Excel Sheet : 2024

Importance of Building Estimation:

The Long Wall and Short Wall Method Explained:

Read more
  1. Long Walls: These are the walls that run along the length of the building. In the estimation process, you calculate the length of these walls separately. For a rectangular building, you would measure the length of the building and multiply it by the height and thickness of the wall to find the volume or area of the long walls.
  2. Short Walls: Similarly, the short walls run across the width of the building. You measure these separately from the long walls. The calculation involves measuring the width of the building, then multiplying it by the height and thickness to determine the volume or area.
  3. Application in Excel: When using an Excel sheet for estimation of building, you input the measurements of both the long and short walls into the respective columns. The Excel sheet then uses these inputs to calculate the total quantity of materials needed, such as bricks, concrete, and plaster. This method allows for precise estimation, ensuring that no aspect of the building's structure is overlooked.
  4. Advantages: The long wall and short wall method is advantageous because it simplifies the estimation process. By breaking down the structure into manageable sections, it allows for more accurate calculations. Additionally, using an Excel sheet for this method ensures that all calculations are automated, reducing the chances of human error and saving time.
  5. Examples: For instance, if you have a building with a total length of 30 meters and a width of 20 meters, you would calculate the volume for the long walls and short walls separately. Suppose the walls are 3 meters high and 0.3 meters thick. The volume for the long walls would be calculated as:
    • Volume of Long Walls = Length x Height x Thickness x Number of Walls
    • Volume = 30m x 3m x 0.3m x 2 (for two walls) = 54 cubic meters
    • Volume = 20m x 3m x 0.3m x 2 (for two walls) = 36 cubic meters
Read more

Following Quantities Are Building Estimation

  • Excavation
  • Footing P.C.C.
  • Footing R.C.C.
  • Column up to Plinth Level R.C.C.
  • Backfilling
  • Plinth Beam R.C.C.
  • Grae Slab R.C.C.
  • Column Up to Slab Level R.C.C.
  • Brick Masonry  
  • In Side Plaster
  • Out Side Plaster
  • Celling Plaster
  • Slab R.C.C.
  • In Side Paint
  • Out Side Pint
Read more

Building Estimation

1. Excavation

Read more
  • Length = 0.6m + 1.0m + 0.6m = 2.20m
  • Here 0.6 m is working space in footing for both sides.
  • And,1.0 m = footing size
Read more
QUANTITY SHEET
Sr. No.Item DescriptionNo.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
1Earthwork in Excavation inFoundation:
Footing (1m x 1m)112.2002.2001.58084.12Cu.m.
Depth From GL = 0.6 + 1 + 0.6
0.6 =Extra For working space
Total Qty=84.12Cu.m.
Read more

2. Footing P.C.C.

  • Length = 0.15m + 1.0m + 0.15m = 1.30m
  • Here 0.15 m = P.C.C. working space in footing, for both side
  • And,1.0 m = footing size
Read more
QUANTITY SHEET
Sr. No.Item DescriptionNo.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
2Footing P.C.C.
Footing (1m x 1m)111.3001.3000.0751.39Cu.m.
Thickness = 0.075
D = 0.150 + 1.0 + 0.150
Total Qty=1.39Cu.m.
Read more

3. Footing R.C.C.

  • Length = 1.0m  = 1.0m
  • Here Height = 0.450 m
  • And, 1.0 m = footing size
Read more
QUANTITY SHEET
Sr. No.Item DescriptionNo.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
3Footing R.C.C.
Base(1m x 1m)111.0001.0000.4504.95Cu.m.
Thickness = 0.450
Total Qty=4.95Cu.m.
Read more

4. Column up to Plinth Level R.C.C.

  • Length = 0.230 m, Breadth = 0.230 m
  • Here Height = 1.05 m
Read more
QUANTITY SHEET
Sr. No.Item DescriptionNo.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
4Column up to Plinth Level R.C.C.
Column110.2300.2301.0500.61Cu.m.
Total Qty=0.61Cu.m.
Read more

5. Backfilling

  • Length & Breadth = 2.2 m, Height Footing Bottom to ground level = 1.580 mm
  • Backfilling = Excavation - Footing P.C.C - Column R.C.C
  • Plinth Beam Backfilling
  • Height of backfilling = 0.600 m
  • Total plinth beam backfilling = Total Area - Plinth beam
Read more
QUANTITY SHEET
Sr. No.Item Description No.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
5BackFilling
5.aBackfilling In Footing
Excavation Area112.2002.2001.58084.12Cu.m.
Deduction
Footing P.C.C.-111.3001.3000.075-1.39Cu.m.
Footing R.C.C.-111.0001.0000.450-4.95Cu.m.
Footing Column-110.2300.2301.050-0.61Cu.m.
5.a Total Qty=77.16Cu.m.
5.bPlinth Beam Backfilling
Plinth area out to out110.2407.6900.60047.25Cu.m.
Deduction
L-1-310.2400.2300.600-4.24Cu.m.
L-2-43.0000.2300.600-1.66Cu.m.
L-3-34.0000.2300.600-1.66Cu.m.
L-4-11.5000.2300.600-0.21Cu.m.
L-5-12.3150.2300.600-0.32Cu.m.
5.b Total Qty=39.17Cu.m.
5.a + 5.b Total Qty=116.33Cu.m.
Read more

6. Plinth Beam R.C.C.

  • and beam size = 0.230 m x 0.600 m
Read more
QUANTITY SHEET
Sr. No.Item Description No.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
6Plinth Beam R.C.C.
Beam (230 mm x 600 mm)
L-1310.2400.2300.6004.24Cu.m.
L-243.0000.2300.6001.66Cu.m.
L-334.0000.2300.6001.66Cu.m.
L-411.5000.2300.6000.21Cu.m.
L-512.3150.2300.6000.32Cu.m.
Total Qty=0.32Cu.m.
Read more

7. Grae Slab R.C.C.

  • Grae Slab RCC = ( Total Length x Total Breadth x Thickness ) - Column
  • Grae Slab RCC = ( 10.240 x 7.690 x 0.100 ) - ( 11 x 0.230 x 0.230 x 0.100)
  • Grae Slab RCC = ( 7.87 ) - (0.06)
  • Grae Slab RCC = 7.82 Cu.m.
Read more
QUANTITY SHEET
Sr. No.Item Description No.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
7Grae Slab R.C.C.
Plinth area out to out110.2407.6900.1007.87Cu.m.
Deduction
Column-110.2300.2300.100-0.06Cu.m.
Total Qty=7.82Cu.m.
Read more

8. Column Up to Slab Level R.C.C.

  • Column Length & Breadth= 0.230 m
  • Height = Ground Slab - Ground Floor - Slab Beam
  • Height = 3 - 0 - 0.350 = 2.650 m
Read more
QUANTITY SHEET
Sr. No.Item Description No.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
8Column Up to Slab Level R.C.C.
Column110.2300.2302.6501.54Cu.m.
Total Qty=1.54Cu.m.
Read more

9. Brick Masonry

  • All length as per drawing and height = 3.00 m - 0.35 m = 2.65 m.
Read more
QUANTITY SHEET
Sr. No.Item Description No.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
9Brick Masonry  
230 mm thick wall Brick Masonry
Long Wall310.2400.2302.65018.72Cu.m.
Shot wall-133.0000.2302.6505.49Cu.m.
Shot wall-113.0000.2301.2000.83Cu.m.
Shot Wall-234.0000.2302.6507.31Cu.m.
Deduction
Column-110.2300.2302.650-1.54Cu.m.
Window W-22.0000.2301.200-1.10Cu.m.
Window W1-21.5000.2301.200-0.83Cu.m.
Window W2-31.2000.2301.200-0.99Cu.m.
Window W3-11.2000.2301.500-0.41Cu.m.
Door o-21.2000.2302.100-1.16Cu.m.
Door D-11.2000.2302.100-0.58Cu.m.
Door D1-11.0000.2302.100-0.48Cu.m.
Door MS-12.0000.2301.200-0.55Cu.m.
Vent-10.9000.2300.600-0.12Cu.m.
Vent V1-10.6000.2300.600-0.08Cu.m.
Total Qty 230 mm Thick Wall=24.49Cu.m.
115 mm thick wall Brick Masonry
Bath Room11.5000.1152.6500.46Cu.m.
Passage wall12.3150.1152.6500.71Cu.m.
Deduction
Door D2-20.7500.1152.100-0.36Cu.m.
Parapet Wall
Long Wall210.2400.1151.0002.36Cu.m.
Shot Wall27.4600.1151.0001.72Cu.m.
Total Qty 115 mm Thick Wall=4.87Cu.m.
Read more

10. In Side Plaster

  • 0.5 sq.m. below section is a full deduction
  • 0.5 sq.m. to 3.0 sq.m. between  half deduction in area
  • 3.0 sq.m. above full deduction but add side pattas
Read more
QUANTITY SHEET
Sr. No.Item Description No.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
10In Side Plaster
Bed Room
Long Wall24.0003.00024.00Sq.m.
Shot wall23.0003.00018.00Sq.m.
Deduction
Door D1-0.51.0002.100-1.05Sq.m.
Window W2-0.51.2001.000-0.60Sq.m.
Window W3-0.51.2001.200-0.72Sq.m.
Kitchen + Dining
Long Wall24.0003.00024.00Sq.m.
Shot wall24.0003.00024.00Sq.m.
Deduction
Door O-0.51.2002.100-1.26Sq.m.
Window W2-11.2001.000-1.20Sq.m.
Verandah
Long Wall23.0003.00018.00Sq.m.
Shot wall13.0003.0009.00Sq.m.
Shot wall13.0001.2003.60Sq.m.
Deduction
Door MS-0.51.2001.200-0.72Sq.m.
Door D-0.51.2002.100-1.26Sq.m.
Window W-0.52.0001.200-1.20Sq.m.
DRG. Room
Long Wall25.5503.00033.30Sq.m.
Shot wall24.0003.00024.00Sq.m.
Deduction
Door O-11.2002.100-2.52Sq.m.
Door D-0.51.2001.200-0.72Sq.m.
Window W-0.52.0001.200-1.20Sq.m.
Window W1-11.5001.200-1.80Sq.m.
Bath Room
Long Wall21.5003.0009.00Sq.m.
Shot wall21.2003.0007.20Sq.m.
Deduction
Door D2-0.50.7502.100-0.79Sq.m.
Vent V1-0.50.9000.600-0.27Sq.m.
W.C.
Long Wall21.5003.0009.00Sq.m.
Shot wall21.0003.0006.00Sq.m.
Deduction
Door D2-0.50.7502.100-0.79Sq.m.
Vent-0.50.6000.600-0.18Sq.m.
Passage
Long Wall22.3203.00013.92Sq.m.
Shot wall21.3903.0008.34Sq.m.
Deduction
Door D2-10.7502.100-1.58Sq.m.
Door D1-11.0002.100-2.10Sq.m.
Door O-11.2002.100-2.52Sq.m.
Total Qty In Side Plaster=208.89Sq.m.
Read more

11. Out Side Plaster

QUANTITY SHEET
Sr. No.Item Description No.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
11Out Side Plaster
Front Side14.4504.77521.25Sq.m.
13.2302.1807.04Sq.m.
Lintel W12.0001.3002.60Sq.m.
Deduction
Door MS-0.51.2001.200-0.72Sq.m.
Window W-0.52.0001.200-1.20Sq.m.
Back Side17.6904.77536.72Sq.m.
Lintel W 221.2001.3003.12Sq.m.
Deduction
Window W 2-11.2001.000-1.20Sq.m.
Right Side110.2404.77548.90Sq.m.
Deduction
Window W-0.52.0001.200-1.20Sq.m.
Window W 3-0.51.2001.200-0.72Sq.m.
Vent-0.50.6000.600-0.18Sq.m.
Vent V1-0.50.9000.600-0.27Sq.m.
Left Side110.2404.77548.90Sq.m.
Deduction
Window W 1-11.5001.200-1.80Sq.m.
Window W 2-0.51.2001.000-0.60Sq.m.
Parapet Wall
Long Wall210.0101.11522.32Sq.m.
Shot Wall27.4601.00014.92Sq.m.
Total Out Side Plastet Qty =197.87Sq.m.
Read more

12. Celling Plaster

QUANTITY SHEET
Sr. No.Item DescriptionNo.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
12Celling Plaster
Bed Room14.0003.00012.00Sq.m.
Kitchen + Dining14.0004.00016.00Sq.m.
Verandah13.0003.0009.00Sq.m.
DRG. Room15.5504.00022.20Sq.m.
Bath Room11.5001.2001.80Sq.m.
W.C11.5001.0001.50Sq.m.
Passage12.3201.3903.22Sq.m.
Total Out Side Plastet Qty =65.72Sq.m.
Read more

13. Slab R.C.C.

QUANTITY SHEET
Sr. No.Item Description No.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
13Slab RCC
Slab Area110.2407.6900.1007.87 Cu.m.
S-1310.2400.2300.3502.47 Cu.m.
S-243.0000.2300.3500.97 Cu.m.
S-334.0000.2300.3500.97 Cu.m.
S-411.5000.2300.3500.12 Cu.m.
S-512.3150.2300.3500.19 Cu.m.
Total RCC Slab Qty=12.59 Cu.m.
Read more

14. In Side Paint

QUANTITY SHEET
Sr. No.Item DescriptionNo.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
14In Side Paint
Bed Room
Long Wall24.0003.00024.00Sq.m.
Shot wall23.0003.00018.00Sq.m.
Bed Room Ceiling14.0003.00012.00Sq.m.
Deduction
Door D1-11.0002.100-2.10Sq.m.
Window W2-11.2001.000-1.20Sq.m.
Window W3-11.2001.200-1.44Sq.m.
Kitchen + Dining
Long Wall24.0003.00024.00Sq.m.
Shot wall24.0003.00024.00Sq.m.
Kitchen + Dining Celling14.0004.00016.00Sq.m.
Deduction
Door O-11.2002.100-2.52Sq.m.
Window W2-21.2001.000-2.40Sq.m.
Verandah
Long Wall23.0003.00018.00Sq.m.
Shot wall13.0003.0009.00Sq.m.
Shot wall13.0001.2003.60Sq.m.
Verandah Celling13.0003.0009.00Sq.m.
Deduction
Door MS-11.2001.200-1.44Sq.m.
Door D-11.2002.100-2.52Sq.m.
Window W-12.0001.200-2.40Sq.m.
DRG. Room
Long Wall25.5503.00033.30Sq.m.
Shot wall24.0003.00024.00Sq.m.
DRG. Room Ceiling15.5504.00022.20Sq.m.
Deduction
Door O-21.2002.100-5.04Sq.m.
Door D-11.2001.200-1.44Sq.m.
Window W-12.0001.200-2.40Sq.m.
Window W1-21.5001.200-3.60Sq.m.
Bath Room
Long Wall21.5003.0009.00Sq.m.
Shot wall21.2003.0007.20Sq.m.
Bath Room Ceiling11.5001.2001.80Sq.m.
Deduction
Door D2-10.7502.100-1.58Sq.m.
Vent V1-10.9000.600-0.54Sq.m.
W.C.
Long Wall21.5003.0009.00Sq.m.
Shot wall21.0003.0006.00Sq.m.
W.C Celling11.5001.0001.50Sq.m.
Deduction
Door D2-10.7502.100-1.58Sq.m.
Vent-10.6000.600-0.36Sq.m.
Passage
Long Wall22.3203.00013.92Sq.m.
Shot wall21.3903.0008.34Sq.m.
Passage Celling12.3201.3903.22Sq.m.
Deduction
Door D2-20.7502.100-3.15Sq.m.
Door D1-21.0002.100-4.20Sq.m.
Door O-21.2002.100-5.04Sq.m.
Total Qty In Side Plaster=252.14Sq.m.
Read more

15. Out Side Pint

QUANTITY SHEET
Sr. No.Item DescriptionNo.Length(m)Widht/Breadth(m)Height/Depth(m)QuantityUnit
15Out Side Plaster
Front Side14.4504.77521.25Sq.m.
13.2302.1807.04Sq.m.
Lintel W12.0001.3002.60Sq.m.
Deduction
Door MS-11.2001.200-1.44Sq.m.
Window W-12.0001.200-2.40Sq.m.
Back Side17.6904.77536.72Sq.m.
Lintel W 221.2001.3003.12Sq.m.
Deduction
Window W 2-11.2001.000-1.20Sq.m.
Right Side110.2404.77548.90Sq.m.
Deduction
Window W-12.0001.200-2.40Sq.m.
Window W 3-11.2001.200-1.44Sq.m.
Vent-10.6000.600-0.36Sq.m.
Vent V1-10.9000.600-0.54Sq.m.
Left Side110.2404.77548.90Sq.m.
Deduction
Window W 1-21.5001.200-3.60Sq.m.
Window W 2-11.2001.000-1.20Sq.m.
Parapet Wall
Long Wall210.0101.11522.32Sq.m.
Shot Wall27.4601.00014.92Sq.m.
Total Out Side Plastet Qty =191.18Sq.m.
Read more

Conclusion

Some Excel File For Your Refrence

Read more
  • Detailed Estimation of Building with Plan PDF = Click Here
  • Detailed Estimate of a Residential Building in Excel = Click Here
  • Detailed Estimate of a Residential Building in Excel PDF = Click Here
  • Detailed Estimate of G+1 Building PDF = Click Here
  • Building Estimate Format in Excel Free Download = Click Here
  • Estimation Excel Sheet Download = Click Here
  • Construction Estimate Format = Click Here
  • Building Estimate Format in PDF = Click Here
  • Cost Estimation Excel Sheet.xls Download= Click Here
  • Measurement Sheet and Abstract Sheet = Click Here
  • Detailed Estimate of Building Format in Excel = Click Here
  • Detailed Estimate of a Residential Building PDF Download = Click Here
  • Building Estimation Excel Sheet Free Download = Click Here
  • Building Estimate Format in PDF = Click Here
  • Detailed Estimate of G+1 Building PDF = Click Here
Read more

Building Estimation

Calculated to Estimate

Read more
  • Estimation is used to predict the answer to a calculation.
  • The estimation uses round numbers in a calculation to make it quicker or easier to get an approximate answer.
  • For example, if we were to estimate the answer to 11.87 x 4.876. We could use the calculation 10 x 5 = 50.
Read more

Estimation of Building

Estimate of Building in Excel

Read more

Estimate for Building

Estimation and Costing of Building

Read more

Estimation in Civil Engineering

Estimate of Building Construction

Read more

Estimation of a House

House Estimate Format

Read more
  • Header
  • Introduction
  • Scope of work
  • Materials and labor costs
  • Payment terms
  • Estimated timeline
  • Terms and conditions
  • Signature
Read more

Civil Estimation

Sample Detailed Estimate of Building

Read more
  • Site preparation and foundation work: $50,000
  • Structural frame: $100,000
  • Exterior and interior walls: $80,000
  • Roofing: $30,000
  • Plumbing: $40,000
  • Electrical: $50,000
  • HVAC: $60,000
  • Finish work: $100,000
Read more

How to Prepare Estimate for a Building?

  • Review The Scope of The Project.
  • Provide a rough timeline.
  • Determine What Work You Need to Subcontract Out.
  • Put Together an Estimate of The Cost of Materials.
  • Check Out The Competition.
  • Outline Your Terms And Conditions.
  • Make Your Estimate Professional.
  • Submit Your Estimate.
Read more

Quantity of Various Item Involved in the Structure Are Calculated Using

How to Calculate Estimate of Building

Read more
  1. Total Cost. = Builtup area × Approx cost per sq. ft. = 1000 × 1000. = 1000000.00 Rs.
  2. Amount of Aggregate Required. = Builtup area × 0.608. = 1000 × 0.608. = 608.00 Ton.
  3. Flooring. = Builtup area × 1.3. = 1000 × 1.3. = 1300.00 Sq.
Read more

Detailed Estimate Example

Estimation Format

Read more
  • The task or project you want an estimation for
  • The scope and requirements of the task or project
  • The deadline or timeline for completion
  • The level of complexity involved
  • The resources and team required
  • Any potential risks or challenges that may affect the estimation
Read more

Estimating and Costing of Building

  1. Design the building
  2. Quantity surveying
  3. Cost analysis
  4. Labor costs
  5. Overhead costs
  6. Contingencies
  7. Summarize the costs
Read more

Calculate the Quantity of Earth Filling in Plinth for Room 5 M X 4 M for Plinth Height Is 0.6 M.

  • Room dimensions: 5 m x 4 m
  • Plinth height: 0.6 m
Read more
  • Volume of earth filling = 5 m x 4 m x 0.6 m
  • Volume of earth filling = 12 cubic meters
Read more

Quantity Estimation of Building

Estimation for Residential Building

Read more
  • All Cement Prices in India
  • How to Calcuted of M30 Grade of Concrete
  • How to Calculated MS Plate Weight
  • Top 10 Water Tank Brands in India
  • What does 1BHK, 2BHK, 3BHK, 4 BHK, 2.5 BHK, 1 RK, 2 BHK 2T, 3 BHK 2T, 3 BHK 3T Mean?
  • Density of Cement Sand and Aggregate
  • Difference Between Pre-Tensioning and Post-Tensioning
  • 20 Types of Plumbing Pipes for Different Use
  • What Is Spread Footing
  • What Is Pitched Roof
  • What Is Parapet Wall And Their Types
  • What Is Concrete Mix Ratio?
Read more

Did you like this story?

Please share by clicking this button!

Visit our site and see all other available articles!

Civil-Jungles