Civil-Jungles

Building Estimation Step by Step In Excel Sheet : 2024

Building Estimation Step by Step In Excel Sheet

Building estimation is a fundamental aspect of construction that plays a critical role in ensuring projects are completed within budget and on schedule.

Whether you’re planning a small residential house or a large commercial building, having an accurate building estimation is essential. It involves calculating the total cost of construction, including materials, labor, and other expenses.

By using tools like Excel sheets, the process of building estimation and costing becomes more streamlined, efficient, and less prone to errors.

One of the most effective methods for estimating building costs is the long wall and short wall method. This technique is particularly beneficial for estimating the quantities of materials needed for rectangular or L-shaped buildings, which are common in both residential and commercial construction.

Importance of Building Estimation:

Building estimation helps in predicting the probable cost of a construction project by calculating the quantity of materials required and their associated costs.

This estimation is vital for budgeting, resource allocation, and avoiding cost overruns. Excel sheets have become an indispensable tool in this process, providing a platform for detailed calculations that are easy to manage and update.

These Excel sheets not only help in maintaining accuracy but also allow for adjustments as the project progresses, making them highly adaptable for construction estimation tasks.

The Long Wall and Short Wall Method Explained:

The long wall and short wall method is a simple yet effective approach to building estimation. Here’s how it works:

  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

    For the short walls:

    • Volume = 20m x 3m x 0.3m x 2 (for two walls) = 36 cubic meters

    The total volume of material required would be the sum of these volumes.

By incorporating these detailed calculations into your house estimation Excel sheet or residential building estimate Excel, you ensure that your building estimation is comprehensive and accurate, covering every aspect of the construction process.

Also, Read: Top 10 Tiles Companies in India

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

Building Estimation

Building Estimation is the process of predicting and calculating the expected costs and resource requirements needed to complete a construction project. This involves determining the quantities of materials, labor, equipment, and other expenses required to construct a building or structure.

Building estimation is an essential step in the planning and budgeting phase of any construction project, whether it’s a small residential house or a large commercial building.

Building Estimate Format in Excel, Building Material Calculator Free Download – Download Excel Sheet

Building Estimation and Costing Excel Sheet – Download Excel Sheet

Also, read: How to Load Calculation on Column, Beam, Wall & Slab

1. Excavation

To calculate excavation, measure the dimensions of the footing as per the drawing. Consider the working space required for both sides. The final excavation quantity is derived from multiplying the length, breadth, and depth.

Section

Section A-A

Footing Location

Footing Location

In this plan, 11 footings as per drawing.

  • 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

As per follows table format copy of the building estimate excel sheet.

QUANTITY SHEET
Sr. No. Item Description No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
1 Earthwork in Excavation in
Foundation:
Footing (1m x 1m) 11 2.200 2.200 1.580 84.12 Cu.m.
Depth From GL = 0.6 + 1 + 0.6
0.6 =Extra For working space
Total Qty= 84.12 Cu.m.

Also, read: What Is Slab Beam

2. Footing P.C.C.

Measure the P.C.C. (Plain Cement Concrete) dimensions, including the extra working space around the footing. Use these measurements to calculate the P.C.C. volume.

In this plan, 11 footings as per drawing.

  • 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
QUANTITY SHEET
Sr. No. Item Description No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
2 Footing P.C.C.
Footing (1m x 1m) 11 1.300 1.300 0.075 1.39 Cu.m.
Thickness = 0.075
D = 0.150 + 1.0 + 0.150
Total Qty= 1.39 Cu.m.

3. Footing R.C.C.

R.C.C. (Reinforced Cement Concrete) volume is calculated using the dimensions of the footing as per the drawing. Ensure that the height of the R.C.C. footing is correctly factored into the calculation.

In this plan, 11 footings as per drawing.

  • Length = 1.0m  = 1.0m
  • Here Height = 0.450 m
  • And, 1.0 m = footing size
QUANTITY SHEET
Sr. No. Item Description No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
3 Footing R.C.C.
Base(1m x 1m) 11 1.000 1.000 0.450 4.95 Cu.m.
Thickness = 0.450
Total Qty= 4.95 Cu.m.


Also, read: Difference Between CPM and PERT

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

For columns, the length and breadth are taken from the section drawing, and the height is determined from the plinth level. The R.C.C. volume is then calculated accordingly.

In this plan, 11 footings as per drawing.

  • Length = 0.230 m, Breadth = 0.230 m
  • Here Height = 1.05 m

Section

Section A-A

QUANTITY SHEET
Sr. No. Item Description No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
4 Column up to Plinth Level R.C.C.
Column 11 0.230 0.230 1.050 0.61 Cu.m.
Total Qty= 0.61 Cu.m.

5. Backfilling

The backfilling quantity is derived by subtracting the volume of the footings (P.C.C. and R.C.C.) and columns from the total excavation volume. The final quantity includes the backfilling around the plinth beam.

Footing backfilling qty for 11 Qty

  • 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
QUANTITY SHEET
Sr. No. Item Description  No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
5 BackFilling
5.a Backfilling In Footing
Excavation Area 11 2.200 2.200 1.580 84.12 Cu.m.
Deduction
Footing P.C.C. -11 1.300 1.300 0.075 -1.39 Cu.m.
Footing R.C.C. -11 1.000 1.000 0.450 -4.95 Cu.m.
Footing Column -11 0.230 0.230 1.050 -0.61 Cu.m.
5.a Total Qty= 77.16 Cu.m.
5.b Plinth Beam Backfilling
Plinth area out to out 1 10.240 7.690 0.600 47.25 Cu.m.
Deduction
L-1 -3 10.240 0.230 0.600 -4.24 Cu.m.
L-2 -4 3.000 0.230 0.600 -1.66 Cu.m.
L-3 -3 4.000 0.230 0.600 -1.66 Cu.m.
L-4 -1 1.500 0.230 0.600 -0.21 Cu.m.
L-5 -1 2.315 0.230 0.600 -0.32 Cu.m.
5.b Total Qty= 39.17 Cu.m.
5.a + 5.b Total Qty= 116.33 Cu.m.

Also, read, Rate Analysis of Brick Masonry

6. Plinth Beam R.C.C.

Measure the dimensions of the plinth beam as per the drawing, and use these measurements to calculate the total R.C.C. volume for the plinth beam.

Lintel Beam

Lintel Beam

As per lintel beam drawing, L-1 = 3 nos., L-2 = 4 nos., L-3 = 3 nos., L- 4 = 1 nos, L-5 = 1 nos of qty and length

  • and beam size = 0.230 m x 0.600 m
QUANTITY SHEET
Sr. No. Item Description  No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
6 Plinth Beam R.C.C.
Beam (230 mm x 600 mm)
L-1 3 10.240 0.230 0.600 4.24 Cu.m.
L-2 4 3.000 0.230 0.600 1.66 Cu.m.
L-3 3 4.000 0.230 0.600 1.66 Cu.m.
L-4 1 1.500 0.230 0.600 0.21 Cu.m.
L-5 1 2.315 0.230 0.600 0.32 Cu.m.
Total Qty= 0.32 Cu.m.

7. Grae Slab R.C.C.

Calculate the Grae Slab R.C.C. by taking the total area and subtracting the volume occupied by columns. The final volume gives the total R.C.C. for the slab.

  • 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.
QUANTITY SHEET
Sr. No. Item Description  No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
7 Grae Slab R.C.C.
Plinth area out to out 1 10.240 7.690 0.100 7.87 Cu.m.
Deduction
Column -11 0.230 0.230 0.100 -0.06 Cu.m.
Total Qty= 7.82 Cu.m.

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

For this section, calculate the R.C.C. volume using the column dimensions up to the slab level. Consider the reduced height due to slab beams.

  • Column Length & Breadth= 0.230 m
  • Height = Ground Slab – Ground Floor – Slab Beam
  • Height = 3 – 0 – 0.350 = 2.650 m
QUANTITY SHEET
Sr. No. Item Description  No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
8 Column Up to Slab Level R.C.C.
Column 11 0.230 0.230 2.650 1.54 Cu.m.
Total Qty= 1.54 Cu.m.

Also, Read:

9. Brick Masonry

The brick masonry quantity is calculated using the long wall and short wall method. Deduct the volumes occupied by doors, windows, and other openings from the total brickwork.

PLAN

Plan

Elevation

Elevation

Section

Section

Brick masonry calculation uses a Long wall and Short wall method

  • All length as per drawing and height = 3.00 m – 0.35 m = 2.65 m.
QUANTITY SHEET
Sr. No. Item Description  No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
9 Brick Masonry  
230 mm thick wall Brick Masonry
Long Wall 3 10.240 0.230 2.650 18.72 Cu.m.
Shot wall-1 3 3.000 0.230 2.650 5.49 Cu.m.
Shot wall-1 1 3.000 0.230 1.200 0.83 Cu.m.
Shot Wall-2 3 4.000 0.230 2.650 7.31 Cu.m.
Deduction
Column -11 0.230 0.230 2.650 -1.54 Cu.m.
Window W -2 2.000 0.230 1.200 -1.10 Cu.m.
Window W1 -2 1.500 0.230 1.200 -0.83 Cu.m.
Window W2 -3 1.200 0.230 1.200 -0.99 Cu.m.
Window W3 -1 1.200 0.230 1.500 -0.41 Cu.m.
Door o -2 1.200 0.230 2.100 -1.16 Cu.m.
Door D -1 1.200 0.230 2.100 -0.58 Cu.m.
Door D1 -1 1.000 0.230 2.100 -0.48 Cu.m.
Door MS -1 2.000 0.230 1.200 -0.55 Cu.m.
Vent -1 0.900 0.230 0.600 -0.12 Cu.m.
Vent V1 -1 0.600 0.230 0.600 -0.08 Cu.m.
Total Qty 230 mm Thick Wall= 24.49 Cu.m.
115 mm thick wall Brick Masonry
Bath Room 1 1.500 0.115 2.650 0.46 Cu.m.
Passage wall 1 2.315 0.115 2.650 0.71 Cu.m.
Deduction
Door D2 -2 0.750 0.115 2.100 -0.36 Cu.m.
Parapet Wall
Long Wall 2 10.240 0.115 1.000 2.36 Cu.m.
Shot Wall 2 7.460 0.115 1.000 1.72 Cu.m.
Total Qty 115 mm Thick Wall= 4.87 Cu.m.

10. In Side Plaster

To calculate inside plaster, measure the surface area of the walls and deduct the areas occupied by doors and windows. Apply appropriate deductions for smaller openings based on the provided rules.

Sum Note Point for deduction

  • 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
QUANTITY SHEET
Sr. No. Item Description  No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
10 In Side Plaster
Bed Room
Long Wall 2 4.000 3.000 24.00 Sq.m.
Shot wall 2 3.000 3.000 18.00 Sq.m.
Deduction
Door D1 -0.5 1.000 2.100 -1.05 Sq.m.
Window W2 -0.5 1.200 1.000 -0.60 Sq.m.
Window W3 -0.5 1.200 1.200 -0.72 Sq.m.
Kitchen + Dining
Long Wall 2 4.000 3.000 24.00 Sq.m.
Shot wall 2 4.000 3.000 24.00 Sq.m.
Deduction
Door O -0.5 1.200 2.100 -1.26 Sq.m.
Window W2 -1 1.200 1.000 -1.20 Sq.m.
Verandah
Long Wall 2 3.000 3.000 18.00 Sq.m.
Shot wall 1 3.000 3.000 9.00 Sq.m.
Shot wall 1 3.000 1.200 3.60 Sq.m.
Deduction
Door MS -0.5 1.200 1.200 -0.72 Sq.m.
Door D -0.5 1.200 2.100 -1.26 Sq.m.
Window W -0.5 2.000 1.200 -1.20 Sq.m.
DRG. Room
Long Wall 2 5.550 3.000 33.30 Sq.m.
Shot wall 2 4.000 3.000 24.00 Sq.m.
Deduction
Door O -1 1.200 2.100 -2.52 Sq.m.
Door D -0.5 1.200 1.200 -0.72 Sq.m.
Window W -0.5 2.000 1.200 -1.20 Sq.m.
Window W1 -1 1.500 1.200 -1.80 Sq.m.
Bath Room
Long Wall 2 1.500 3.000 9.00 Sq.m.
Shot wall 2 1.200 3.000 7.20 Sq.m.
Deduction
Door D2 -0.5 0.750 2.100 -0.79 Sq.m.
Vent V1 -0.5 0.900 0.600 -0.27 Sq.m.
W.C.
Long Wall 2 1.500 3.000 9.00 Sq.m.
Shot wall 2 1.000 3.000 6.00 Sq.m.
Deduction
Door D2 -0.5 0.750 2.100 -0.79 Sq.m.
Vent -0.5 0.600 0.600 -0.18 Sq.m.
Passage
Long Wall 2 2.320 3.000 13.92 Sq.m.
Shot wall 2 1.390 3.000 8.34 Sq.m.
Deduction
Door D2 -1 0.750 2.100 -1.58 Sq.m.
Door D1 -1 1.000 2.100 -2.10 Sq.m.
Door O -1 1.200 2.100 -2.52 Sq.m.
Total Qty In Side Plaster= 208.89 Sq.m.

11. Out Side Plaster

For outside plaster, calculate the surface area of the exterior walls, and make deductions for doors, windows, and other openings, as specified.

QUANTITY SHEET
Sr. No. Item Description  No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
11 Out Side Plaster
Front Side 1 4.450 4.775 21.25 Sq.m.
1 3.230 2.180 7.04 Sq.m.
Lintel W 1 2.000 1.300 2.60 Sq.m.
Deduction
Door MS -0.5 1.200 1.200 -0.72 Sq.m.
Window W -0.5 2.000 1.200 -1.20 Sq.m.
Back Side 1 7.690 4.775 36.72 Sq.m.
Lintel W 2 2 1.200 1.300 3.12 Sq.m.
Deduction
Window W 2 -1 1.200 1.000 -1.20 Sq.m.
Right Side 1 10.240 4.775 48.90 Sq.m.
Deduction
Window W -0.5 2.000 1.200 -1.20 Sq.m.
Window W 3 -0.5 1.200 1.200 -0.72 Sq.m.
Vent -0.5 0.600 0.600 -0.18 Sq.m.
Vent V1 -0.5 0.900 0.600 -0.27 Sq.m.
Left Side 1 10.240 4.775 48.90 Sq.m.
Deduction
Window W 1 -1 1.500 1.200 -1.80 Sq.m.
Window W 2 -0.5 1.200 1.000 -0.60 Sq.m.
Parapet Wall
Long Wall 2 10.010 1.115 22.32 Sq.m.
Shot Wall 2 7.460 1.000 14.92 Sq.m.
Total Out Side Plastet Qty = 197.87 Sq.m.

12. Celling Plaster

The ceiling plaster quantity is determined by measuring the area of the ceilings in each room. No deductions are typically required unless there are significant openings.

QUANTITY SHEET
Sr. No. Item Description No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
12 Celling Plaster
Bed Room 1 4.000 3.000 12.00 Sq.m.
Kitchen + Dining 1 4.000 4.000 16.00 Sq.m.
Verandah 1 3.000 3.000 9.00 Sq.m.
DRG. Room 1 5.550 4.000 22.20 Sq.m.
Bath Room 1 1.500 1.200 1.80 Sq.m.
W.C 1 1.500 1.000 1.50 Sq.m.
Passage 1 2.320 1.390 3.22 Sq.m.
Total Out Side Plastet Qty = 65.72 Sq.m.

13. Slab R.C.C.

Calculate the Slab R.C.C. by considering the slab area and adding the volume of the slab beams. Ensure all components are measured accurately.

Slab Beam

Slab Beam

Section

Section

QUANTITY SHEET
Sr. No. Item Description  No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
13 Slab RCC
Slab Area 1 10.240 7.690 0.100 7.87  Cu.m.
S-1 3 10.240 0.230 0.350 2.47  Cu.m.
S-2 4 3.000 0.230 0.350 0.97  Cu.m.
S-3 3 4.000 0.230 0.350 0.97  Cu.m.
S-4 1 1.500 0.230 0.350 0.12  Cu.m.
S-5 1 2.315 0.230 0.350 0.19  Cu.m.
Total RCC Slab Qty= 12.59  Cu.m.

14. In Side Paint

The inside paint quantity is calculated by measuring the wall areas and ceilings and deducting the areas occupied by doors and windows.

QUANTITY SHEET
Sr. No. Item Description No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
14 In Side Paint
Bed Room
Long Wall 2 4.000 3.000 24.00 Sq.m.
Shot wall 2 3.000 3.000 18.00 Sq.m.
Bed Room Ceiling 1 4.000 3.000 12.00 Sq.m.
Deduction
Door D1 -1 1.000 2.100 -2.10 Sq.m.
Window W2 -1 1.200 1.000 -1.20 Sq.m.
Window W3 -1 1.200 1.200 -1.44 Sq.m.
Kitchen + Dining
Long Wall 2 4.000 3.000 24.00 Sq.m.
Shot wall 2 4.000 3.000 24.00 Sq.m.
Kitchen + Dining Celling 1 4.000 4.000 16.00 Sq.m.
Deduction
Door O -1 1.200 2.100 -2.52 Sq.m.
Window W2 -2 1.200 1.000 -2.40 Sq.m.
Verandah
Long Wall 2 3.000 3.000 18.00 Sq.m.
Shot wall 1 3.000 3.000 9.00 Sq.m.
Shot wall 1 3.000 1.200 3.60 Sq.m.
Verandah Celling 1 3.000 3.000 9.00 Sq.m.
Deduction
Door MS -1 1.200 1.200 -1.44 Sq.m.
Door D -1 1.200 2.100 -2.52 Sq.m.
Window W -1 2.000 1.200 -2.40 Sq.m.
DRG. Room
Long Wall 2 5.550 3.000 33.30 Sq.m.
Shot wall 2 4.000 3.000 24.00 Sq.m.
DRG. Room Ceiling 1 5.550 4.000 22.20 Sq.m.
Deduction
Door O -2 1.200 2.100 -5.04 Sq.m.
Door D -1 1.200 1.200 -1.44 Sq.m.
Window W -1 2.000 1.200 -2.40 Sq.m.
Window W1 -2 1.500 1.200 -3.60 Sq.m.
Bath Room
Long Wall 2 1.500 3.000 9.00 Sq.m.
Shot wall 2 1.200 3.000 7.20 Sq.m.
Bath Room Ceiling 1 1.500 1.200 1.80 Sq.m.
Deduction
Door D2 -1 0.750 2.100 -1.58 Sq.m.
Vent V1 -1 0.900 0.600 -0.54 Sq.m.
W.C.
Long Wall 2 1.500 3.000 9.00 Sq.m.
Shot wall 2 1.000 3.000 6.00 Sq.m.
W.C Celling 1 1.500 1.000 1.50 Sq.m.
Deduction
Door D2 -1 0.750 2.100 -1.58 Sq.m.
Vent -1 0.600 0.600 -0.36 Sq.m.
Passage
Long Wall 2 2.320 3.000 13.92 Sq.m.
Shot wall 2 1.390 3.000 8.34 Sq.m.
Passage Celling 1 2.320 1.390 3.22 Sq.m.
Deduction
Door D2 -2 0.750 2.100 -3.15 Sq.m.
Door D1 -2 1.000 2.100 -4.20 Sq.m.
Door O -2 1.200 2.100 -5.04 Sq.m.
Total Qty In Side Plaster= 252.14 Sq.m.

15. Out Side Pint

For outside paint, measure the surface area of all exterior walls and deduct areas covered by doors, windows, and other openings.

QUANTITY SHEET
Sr. No. Item Description No. Length
(m)		 Widht/
Breadth
(m)		 Height/
Depth
(m)		 Quantity Unit
15 Out Side Plaster
Front Side 1 4.450 4.775 21.25 Sq.m.
1 3.230 2.180 7.04 Sq.m.
Lintel W 1 2.000 1.300 2.60 Sq.m.
Deduction
Door MS -1 1.200 1.200 -1.44 Sq.m.
Window W -1 2.000 1.200 -2.40 Sq.m.
Back Side 1 7.690 4.775 36.72 Sq.m.
Lintel W 2 2 1.200 1.300 3.12 Sq.m.
Deduction
Window W 2 -1 1.200 1.000 -1.20 Sq.m.
Right Side 1 10.240 4.775 48.90 Sq.m.
Deduction
Window W -1 2.000 1.200 -2.40 Sq.m.
Window W 3 -1 1.200 1.200 -1.44 Sq.m.
Vent -1 0.600 0.600 -0.36 Sq.m.
Vent V1 -1 0.900 0.600 -0.54 Sq.m.
Left Side 1 10.240 4.775 48.90 Sq.m.
Deduction
Window W 1 -2 1.500 1.200 -3.60 Sq.m.
Window W 2 -1 1.200 1.000 -1.20 Sq.m.
Parapet Wall
Long Wall 2 10.010 1.115 22.32 Sq.m.
Shot Wall 2 7.460 1.000 14.92 Sq.m.
Total Out Side Plastet Qty = 191.18 Sq.m.

Also Read:

Conclusion

In conclusion, using Excel for building estimations offers a highly efficient and accurate method for managing construction projects. The building estimation excel sheet simplifies the process of calculating quantities and costs, ensuring that all necessary materials and labor are accounted for.

By following the steps outlined, you can create a detailed estimate of a residential building in Excel or any other type of construction project with ease.

Excel not only provides a structured approach to estimation but also allows for easy adjustments and updates, making it an invaluable tool in the construction industry. The ability to use predefined formulas and templates, such as the building estimate format in Excel, further enhances accuracy and reduces the chances of errors.

For those looking to dive deeper, the detailed estimate of building format in Excel and house construction estimate spreadsheet Excel download provide comprehensive templates that cover all aspects of building estimation. These resources, including the detailed estimation of building with plan PDF, are designed to save time and improve the precision of your project estimations.

Some Excel File For Your Refrence

  • 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
FAQ

Building Estimation

A building estimator or cost estimator is an individual that quantifies the materials, labor, and equipment needed to complete a construction project. Building cost estimating can concern diverse forms of construction from residential properties to hi-rise and civil works.

Calculated to Estimate

  • 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.

Estimation of Building

Estimation of A Building With Plan is processed of predicting the probable cost of the project by calculating material quantity and their costing with help of market rates before undertaking any construction project.

Estimate of Building in Excel

Cost Estimation RCC Building Excel Sheet In order to determine the rate of a particular item, the factors affecting the rate of that item are studied carefully and then finally a rate is decided for that item. This process of determining the rates of an item is termed as analysis of rates or rate analysis.

Estimate for Building

Estimation of A Building With Plan is processed of predicting the probable cost of the project by calculating material quantity and their costing with help of market rates before undertaking any construction project.

Estimation and Costing of Building

The basic definition of estimation is the estimate of record materials an item of work or cost of all projects all detail of uses the building item-like beam column slab wall window door, etc, and also the cost of labor number of labor also to calculate the time of finished the project. we have given drawing skect.

Estimation in Civil Engineering

Estimation in civil engineering is the process of determining the number of materials, resources, and money needed to operate during a construction project. This is usually done before the start of the project, so you can procure estimated materials and gather the funds as the project progresses.

Estimate of Building Construction

The valuation of a building or property is found by multiplying the net income by year’s purchase. The valuation, in this case, can be too high in comparison with the actual cost of construction.

Estimation of a House

As a rough estimate, the average cost to build a house in the United States ranges from $100 to $400 per square foot, depending on the above-mentioned factors. So, for example, if you are planning to build a 2,000 square foot house, the estimated cost could be between $200,000 to $800,000.

House Estimate Format

A typical format for a house estimate includes:

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

Civil Estimation

Civil estimation refers to the process of estimating the cost and resources required for civil engineering projects such as building construction, road construction, bridge construction, and other infrastructure projects. Civil estimation involves calculating the cost of materials, labor, equipment, and other expenses involved in a construction project.

Sample Detailed Estimate of Building

  • 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

Total estimate: $510,000

How to Prepare Estimate for a Building?

How to Write a Construction Estimate in 8 Steps

  • 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.

Quantity of Various Item Involved in the Structure Are Calculated Using

The quantity of various items involved in a structure, such as materials, labor, and equipment, is typically calculated using a combination of mathematical formulas, engineering principles, and project management software.

How to Calculate Estimate of Building

Approximate cost on various work of material to complete the construction for 1000 ft 2

  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.

Detailed Estimate Example

For example, if a project contains only two tasks, Task A and Task B, and they are the exact same size: If Task A has an estimate with an accuracy of 10%, and. If Task B has an estimate with an accuracy of 20%, The accuracy of the project estimate is (10 + 20) / 2 = 15%

Estimation Format

To provide an estimation, I would typically need the following information:

  • 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

Estimating and Costing of Building

Estimating and costing of a building is the process of calculating the approximate cost of construction of a building project before construction begins. This involves a detailed analysis of the materials, labor, and other expenses that will be required to complete the project. The following are the steps involved in estimating and costing a building:

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

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

To calculate the quantity of earth filling in plinth for a room, we need to know the dimensions of the plinth and the height.

Given:

  • Room dimensions: 5 m x 4 m
  • Plinth height: 0.6 m

To calculate the quantity of earth filling, we can use the formula:

Volume of earth filling = Length x Width x Height

The length and width of the plinth will be the same as the room dimensions, so we can substitute those values into the formula:

  • Volume of earth filling = 5 m x 4 m x 0.6 m
  • Volume of earth filling = 12 cubic meters

Therefore, the quantity of earth filling in the plinth for a room with dimensions 5 m x 4 m and plinth height of 0.6 m is 12 cubic meters.

Quantity Estimation of Building

Cubical Contents Method
The cost of a structure is calculated approximately as the total cubical contents (Volume of buildings) multiplied by Local Cubic Rate. The volume of building is obtained by Length x breadth x depth or height. The length and breadth are measured out to out of walls excluding the plinth off set.

Estimation for Residential Building

As a rough estimate, a basic 1,500 square foot single-story home in a suburban area can cost around $150,000 to $250,000 to build, while a larger 2,500 square foot two-story home in the same area could cost around $250,000 to $400,000.

Like this post? Share it with your friends!

Suggested Read –

Total
4
Shares
Share 0
Pin it 4
Tweet 0
Share 0
Share 0
Share 0
Share 0

About Matthew L. Deloney

Hey, I am Matthew L. Deloney. The Man Behind CivilJungle. I started this site to spread knowledge about Civil Engineering. I am a Degree Holder in Civil Engineering.

You can find him on Facebook, Twitter, Tumblr, Instagram and Google News.

Comments

  1. Swapnil Sutar says

    Hello Sir,
    Its really nice to visit your website. luckily I got your website and I saw that, its complete ocean of knowledge for civil engineers. really appreciable of your talent and knowledge. Thanks a lot Sir for sharing your valuable knowledge and experience…. I pray for your success…
    Sir, can you share the File of “Complete Building Estimation Step by Step In Excel Sheet Calculator”. Sir, If you can, plz mail me on —- [email protected].
    Thanking you. Best of Luck Sir.

    Reply

  2. yaseen says

    dear ,

    where is estimation & , its only quantity of concrete ,
    how much building material required ?
    thanks for sharing knowledge .

    Reply

  5. JAGDISH CHANDRA DANGI says

    It’s only quantity of total material used in construction… Please provide estimate excel sheet … Thank you for sharing knowledge !!

    Reply

  8. Rahul patil says

    I want this this type plan…calculate the quantity of items work using standard measurement sheets load bearing residential structure using description of items from DSR(1bhk plan with staircase)

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

MIND BEHIND CIVILJUNGLE

ADVERTISE

At CivilJungle, we clarify civil engineering and publish all the happenings & news of civil engineering.

Get Traffic & Exposure. We help brands optimize their online presence & performance.

MORE DETAIL

CONNECT WITH US


/* */