CivilJungle

Building Estimation Step by Step In Excel Sheet

by 6 Comments

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.

Because of this method, very easy all methods like Centre Line Method & Crossing Method. And mostly Billing Engineer and Quantity Surveyor use this method.

Laminates contains plastics and resins. Some resins give off harmful gases.

In this article, we calculate step by calculation as below.

Following Quantities Are Building Estimation

1. Excavation

2. Footing P.C.C.

3. Footing R.C.C.

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

5. Backfilling

6. Plinth Beam R.C.C.

7. Grae Slab R.C.C.

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

9. Brick Masonry  

10. In Side Plaster

11. Out Side Plaster

12. Celling Plaster

13. Slab R.C.C.

14. In Side Paint

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

A 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 – Download link

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

QUANTITY SHEET
Sr. No.Item DescriptionNo.Length
(m)		Widht/
Breadth
(m)		Height/
Depth
(m)		QuantityUnit
1Earthwork in Excavation in
Foundation:
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.

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

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


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

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

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

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

#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)		QuantityUnit
8Column Up to Slab Level R.C.C.
Column110.2300.2302.6501.54Cu.m.
Total Qty=1.54Cu.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)		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.

#10. In Side Plaster

How to Find In Side Plaster as Per Drawing 

Sum Note Point for deduction

1. 0.5 sq.m. below section is a full deduction

2. 0.5 sq.m. to 3.0 sq.m. between  half deduction in area

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

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

#12. Celling Plaster

How to Find Celling Plaster as Per Drawing 

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.

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

#14. In Side Paint

How to Find In Side Paint as Per Drawing 

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.

#15. Out Side Pint

How to Find Out Side Plaster as Per Drawing 

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

Building Estimation

  • A building estimator or cost estimator is an individual that quantifies the materials, labour, 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.

 

Like this post? Share it with your friends!

Suggested Read –

About Krunal Rajput

Hey, I am Krunal Rajput. 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 —- sutarswapnil708@gmail.com.
    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

Leave a Reply

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

MIND BEHIND CIVILJUNGLE

Hey, I am Krunal Rajput. The Man Behind CivilJungle. I started this site to spread knowledge about Civil/Mechanical/Electrical Engineering. I am a Degree Holder in Civil Engineering.

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

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


/* */

Join the Home of Civil Engineers 👉🏼

CLICK HERE
X
More in Civil, Design, Excel Sheet, Quantity Survey
What Is Plaster
What Is Plaster | Requirement of Good Plaster | Types of Plasters

Close