Building Estimation Step by Step In Excel Sheet : 2024

Building Estimation Step by Step In Excel Sheet

Dear friend, we work building quantity calculation in manual in a paper, So now going we area in how to Calculate in Excel use a long wall and short wall method.

This long wall and short wall method is very easy to calculation in the estimation sheet. In this estimation excel sheet easy calution using a excel formulas. In this article also attached construction cost estimate template excel sheet. so please see that.

Laminates contains plastics and resins. Some resins give off harmful gases. In this article, we calculate step by calculation as below.

Note: Free Download building construction estimate spreadsheet excel download UK, US, Canada, and also India.

Following Quantities Are Building Estimation

Important Point

  • 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

It is processed by predicting the probable cost of a project by calculating material quantity and their costing with help of market rates before undertaking any construction project.

Or

building estimator or cost estimator is an individual that quantifies the materials, labor, and equipment needed to complete a construction project.

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 Find House Construction Cost

1. Excavation

How to Find Excavation as Per Drawing 

Footing excavation work needs sum drawing like Footing location Drawing and Section Drawing. All drawing as per below, please see

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 / Hidden Beam / Concealed Beam | Advantage and Disadvantage

2. Footing P.C.C.

How to Find Footing P.C.C. as Per Drawing 

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.

How to Find Footing R.C.C. as Per Drawing 

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/PERT Vs CPM | What Is CPM & PERT

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

How to Find Column up to Plinth Level R.C.C. as Per Drawing 

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

How to Find Backfilling as Per Drawing 

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.

How to Find Plinth Beam R.C.C. as Per Drawing 

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.

How to Find Grae Slab RCC as Per Drawing 

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.

How to Find Grae Slab RCC as Per Drawing 

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: What Is Floating Slab| Floating Slab Construction | How to Build a Floating Slab | Advantages & Disadvantages Floating Slabs

9. Brick Masonry  

How to Find Brick Masonry as Per Drawing 

PLAN

Plan

Elevation

Elevation

SectionSection

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

How to Find In Side Plaster as Per Drawing 

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

How to Find Out Side Plaster as Per Drawing 

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

How to Find Celling Plaster as Per Drawing 

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.

How to Find In Out Slab  R.C.C. as Per Drawing 

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

How to Find In Side Paint as Per Drawing 

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

How to Find Out Side Plaster as Per Drawing 

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

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.

16 thoughts on “Building Estimation Step by Step In Excel Sheet : 2024”

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

  2. dear ,

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

  3. JAGDISH CHANDRA DANGI

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

  4. 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)

Leave a Comment

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

Scroll to Top