Building Quantity Calculation: Long Wall and Short Wall Method Explained with Excel Templates

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

  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, Building Material Calculator Free Download Download Excel Sheet

Building Estimation and Costing Excel Sheet – Download Excel Sheet

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.

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.

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.

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.

9. Brick Masonry  

How to Find Brick Masonry as Per Drawing 

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

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.

Frequently Asked Questions about Long Wall and Short Wall Method:

What is the Long Wall and Short Wall Method in building quantity calculation?

The Long Wall and Short Wall Method is a technique used in civil engineering and construction to estimate quantities of materials required for construction projects. It involves dividing the building into long walls and short walls and calculating the quantities of materials such as bricks, cement, and steel for each section.

How does the Long Wall and Short Wall Method differ from other quantity estimation techniques?

Unlike other methods that calculate quantities based on area or volume, the Long Wall and Short Wall Method focuses on the length of walls in a building. It provides a more accurate estimation by considering the structural layout and dimensions of the building.

What are the advantages of using the Long Wall and Short Wall Method?

One advantage is its simplicity and ease of implementation, especially for buildings with complex layouts. Additionally, it allows for better control over material costs and reduces wastage by providing a detailed breakdown of material requirements for each section of the building.

How do I apply the Long Wall and Short Wall Method in practice?

To apply this method, you first need to identify the long walls and short walls in the building layout. Then, measure the lengths of these walls and calculate the quantities of materials required based on predefined unit rates or material specifications.

Are there any limitations or challenges associated with this method?

While the Long Wall and Short Wall Method is effective for many construction projects, it may not be suitable for buildings with irregular shapes or non-standard wall configurations. In such cases, additional adjustments or alternative estimation techniques may be necessary.

Can software tools or templates assist in implementing this method?

Yes, there are various software tools and Excel templates available that can streamline the calculation process and help automate the generation of quantity estimates using the Long Wall and Short Wall Method. These tools often allow for customization based on specific project requirements.

How can I ensure the accuracy of quantity estimates obtained through this method?

To ensure accuracy, it’s essential to input precise measurements and verify calculations against project drawings and specifications. Regular updates and revisions to the estimates may also be necessary as the project progresses and new information becomes available.

Leave a Comment

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

/* */
Scroll to Top