QUANTITY SURVEYING,

& PROJECT BILLING

WORKSHOP
 IMPORTANCE OF BBS
✓ There is faster execution of work at the site with the help
of BBS, which reduces construction cost and time

✓ BBS reduces reinforcement wastages in cutting

✓ BBS helps in improving quality control at the site

✓ It helps in stock management at the site

✓ It helps in auditing of reinforcement and provides a check

on theft

✓ It helps in fast preparation of bills of construction works

✓ It helps in the estimation of steel quantity

• Formulae :
• Standard length of bar in meter - 12m

• Wight of bar per meter (Kg/meter) – D^2/162 (D in mm)

• Wight per bar (Kg/bar) – (D^2/162) x Standard length of

bar

• Size of members in inches – 1” = 25mm & 1’ = 300mm

• Standard length of bar in feet = 40ft

 BASICS TO BE KNOWN...

• Weight of bar per feet (Kg/ft) – D^2/533 (D in

mm)

• Cutting length of main bar with hook –

9d
L
• Length of hook – 9d
• Length of bar – L+9d+9d
 BASICS TO BE KNOWN...
• Concrete cover –
1. Clear cover Clear
2. Effective cover Cover

Effective
cover
• Spacing –
Distance between two adjecent reinforcement bars

• Number of bars –
=(Opposite length /spacing)+1

• Number of stirrups –
=(Actual length of column or beam/spacing)+1
 BASICS TO BE KNOWN...
• Crank length & extra bars – Crank

45
• Crank length – 0.42h
✓ For 45 bend = 0.42h
✓ For 30 bend = 0.27h
✓ For 60 bend = 0.58h

• Extra bar length = L/4

• Bend deduction –
✓ 45 bend = 1d
✓ 90 bend = 2d
✓ 135 bend = 3d
 BASICS TO BE KNOWN...
• Cutting length of a crank/bent-up bar –
Crank
Ld
45
0.42h

Clear span

• Cutting length of bar = Clear span + Crank length +

Development length – (1d x No. of bends) – (2d x No. of
bends)

• = Clear span + (2 x 0.42 x h) + (2 x Ld) – (1d x 4) – (2d x 2)

h = Depth of crank = Slab thickness – (2 x Clear cover)

BENTUP BARS
 BASICS TO BE KNOWN...
• Cutting length of rectangular stirrups –

= (a x 2) + (b x 2) + Hook length – Bend deduction

Where, A
a = A – (2 x clear cover) – d
b = B – (2 x clear cover) – d

b
• Hook length = 2 x (10d or 75mm) B
• Bend deduction = 3 x 2d &
2 x 3d a
Cross-section of a beam
 BASICS TO BE KNOWN...

• Cutting length of a chair bar –

= 2A + 2D + B
• D = Footing height –(Upper + lower clear
cover) - (Upper main bar dia + distribution bar
dia) – (Lower side main bar dia)
Column
reinforcement
B

D D A
Chair
A
 BASICS TO BE KNOWN...
➢ Development Length :
• A length of reinforcement embedded in concrete so that it
can develop the bond stress, is known as development length
 DEVELOPMENT LENGTH
COLUMN

Ld

BEAM

FOOTING
 BASICS TO BE KNOWN...
➢ Lap Length :

• The length of bar extended over the other bars in beam, columns
etc. is called lap length
• Reinforcement bars are spliced because of
⁻ Limited bar length available in market (12m)
⁻ Change from larger bars to smaller bars
• (IS:456) The lap length in compression = Development length (But
not less than 24d)
• (IS:456) The lap length in tension shall be Ld or 30d whichever is
greater
• (IS:456) When bars of two different dia. Are to be spliced lap length
will be calculated on the basis of dia. of smaller bar.
• (IS:456) If the dia. of bar is greater than 36mm then it should be
welded
BASICS TO BE KNOWN...
HOW TO READ THE DRAWING??
 WALL FOOTING

SIMPLE SPREAD FOOTING

STEPPED FOOTING

SLOPED FOOTING

COMBINED FOOTING

CANTILEVER FOOTING

MAT/RAFT FOUNDATION

PILE FOUNDATION
WALL FOOTING
SIMPLE SPREAD FOOTING
STEPPED FOOTING
SLOPED/TRAPAZOIDAL FOOTING
CANTILEVER FOOTING
COMBINED FOOTING
RAFT/MAT FOUNDATION
Pile Foundation
Read column & footing layout plan (Overview)

See the cross section of footing (Identify the

type of mesh/reinforcement)

Read the schedule of footing (Size of the

footing, dia. of bars, spacing, location)

Calculate number of bars (Main &

distribution)

Calculate cutting length of bar, weight of bar

per meter length, total weight
 BBS FOR FOOTING
MAIN REINF. (AT BOTTOM) DISTR. REINF. (AT TOP)

LONGER SIDE

SHORTER SIDE
12”
D
6”

2” COVER
PCC IN M10 (4” THK) REINF.

SCHEDULE OF FOOTINGS
FOOTING FOOTING DETAILS
COLUMN NOS. PCC (1:4:8)
NOS. SIZE (L x B) D REINF 'a' & 'b' B/W AT BOTTOM

F1 C - 1,13,17 4'-11" x 4'-2" 4'-3" x 3'-6" 14" 10Y@7" C/C B/W AT BOTTOM
C-
F2 5'-8" x 4'-11" 5'-0" x 4'-3" 15" 10Y@7" C/C B/W AT BOTTOM
2,4,6,8,9,12,14,15,16
F3 C - 3,5 5'-11" x 5'-2" 5'-3" x 4'-6" 17" 10Y@6" C/C B/W AT BOTTOM
F4 C - 7,11 6'-11" x 5'-11" 6'-3" x 5'-3" 20" 12Y@5" C/C B/W AT BOTTOM
F5 C -10 7'-5" x 6'-2" 6'-9" - 5'-6" 22" 12Y@5" C/C B/W AT BOTTOM
 STEPS TO SLOVE FOOTING
• Formwork (Sq.m)
=[2*(Length/1000)*(Depth/1000)]+[2*(width/1000)*(Depth/1000)]
=[2*(1275/1000)*(350/1000)]+[(2*(1050/1000)*(350/1000)]
= 1.63 Sq.m

• Concrete(Cum.)
=(Length/1000)*(Width/1000)*(Depth/1000)
= (1275/1000)*(1050/1000)*(350/1000) = 0.47 Cum

• No of Bars
– Main Bar
=[(Length of long span-(2*cover))/Spacing]+1
= ((1275-(2*50))/175)+1 = 8
- Distribution Bar
=[(Length of short span-(2*Cover))/spacing]+1
=((1050-(2*50))/175)+1 = 7
 FOOTING
• Shape of Bar –
• Main Bar MAIN REINF. (AT BOTTOM)
DISTR. REINF. (AT TOP)
150 150 LONGER SIDE

Length of short span-(2*Cover)

SHORTER SIDE
= 1050-(2*50) = 950

• Distribution Bar

150 150

Length of long span-(2*Cover)

=1275-(2*50) = 1175
2
 FOOTING
• Length of Bar (mm)
• Main Bar
150 150
a c
950
b
• Main Bar= a + b+ c
=150+950+150 = 1250

• Distribution bar 150 150

a c
1175
• Dist. Bar=a + b + c b

= 150+1175+150 = 1475 3
• Length of Bar (m) FOOTING
Main Bar =Length of Bar(mm)/1000
=1250/1000 = 1.25
Distribution Bar = 1475/1000 = 1.475
• Wt(Kg/m)
=((Diameter of bar)^2/162
Main & Distribution bars =(10^2)/162 = 0.62
• Total Weight(MT)
(Length of bar(m)*WT(Kg/m)*No of bars*sets)/1000
Main Bars =(1.25*0.62*8*3)/1000 = 0.019
Distribution Bars = (1.475*0.62*7*3)/1000 = 0.019
• Total Formwork(sq.m)
(Formwork of one component)*(No of sets)
=1.63*3 = 4.88
• Total Concrete(Cum)
(Concrete of one component)*(No of sets)
=0.47*3 = 1.40 4
 TRAPAZOIDAL
FOOTING
L
1275

450

1150
200

B
l
d=400

12”
D=350 6”

2” COVER
PCC IN M10 (4” THK) REINF.
SCHEDULE OF FOOTINGS
FOOTING FOOTING DETAILS
COLUMN NOS. PCC (1:4:8)
NOS. SIZE (L x B) D REINF 'a' & 'b' B/W AT BOTTOM

F1 C - 1,13,17 1475 x 1250 1275 x 1150 350 10Y@175 C/C B/W AT BOTTOM
 TRAPAZOIDAL FOOTING

L
1275

450

1150
200

B
l
d=400

12”
D=350 6”

2” COVER
PCC IN M10 (4” THK) REINF.
SCHEDULE OF FOOTINGS
FOOTING FOOTING DETAILS
COLUMN NOS. PCC (1:4:8)
NOS. SIZE (L x B) D REINF 'a' & 'b' B/W AT BOTTOM

F1 C - 1,13,17 1475 x 1250 1275 x 1150 350 10Y@175 C/C B/W AT BOTTOM
 STEPS TO SLOVE FOOTING
• Formwork (Sq.m)

=[2*(Length/1000)*(Depth/1000)]+[(2*(width/1000)*(Dept
h/1000)]
=[2*(1275/1000)*(350/1000)]+[(2*(1050/1000)*(350/1000)]
= 1.63 Sq.m
1150
• Concrete(Cum.)
1275 350
• Rectangular part
=LxBxD
= 1.275 x 1.150 x 0.35
= 0.513 Cum
 STEPS TO SLOVE FOOTING
• Concrete(Cum.)

• Sloped portion

= d/3(A1+A2+ A1+A2 ) 400

A1 = L x B
= 1.275 x 1.150
= 1.466 Sq.m
A2 = l x b
= 0.450 x 0.200
= 0.09 Sq.m

Volume = 0.4/3 (1.466+0.09+ 1.466+0.09 )

= 0.373 Cum

Total Quantity = Rectangular portion + Sloped portion

= 0.513 + 0.373
= 0.886 Cum
 6Y@ 6” THROUGHT
COLUMN
SCHEDULE OF COLUMNS
SIZE OF COLUMN LONG. BARS 'C'
COLUMN MARKS

6Y@ 6” UPTO SOFT STORY

'a' 'b' BARS
FB

C-
1,2,4,6,9,12,13,14,15 8" 18" 12Y - 8 NOS.
,16,17
40mm cover

C - 3,5,8 8" 21" 12Y - 10 NOS.

FGL(+)0.00

16Y - 6 NOS. +
C - 10 8" 24"
12Y - 4 NOS.
PB

1’-8”
6Y@ 6” C/C LINKS

16Y - 4 NOS. +
C - 7,11 8" 21"
12Y - 6 NOS.

12”
D
6”
 SCHEDULE OF COLUMNS
SIZE OF COLUMN LONG. BARS 'C'
COLUMN MARKS SKETCH
BARS
'a' 'b'

C- 6Y@6” C/C
1,2,4,6,9,12,13 8" 18" 12Y - 8 NOS. 8” LINKS.
,14,15,16,17 EACH FACE 12Y – 8NOS.

6Y@6” C/C
C - 3,5,8 8" 21" 12Y - 10 NOS. LINKS.
12Y – 10NOS.
EACH FACE

6Y@6” C/C
16Y - 6 NOS. + LINKS.
C - 10 8" 24"
12Y - 4 NOS. EACH FACE

12Y – 6NOS.

16Y - 4 NOS. + 6Y@6” C/C

C - 7,11 8" 21" LINKS.
12Y - 6 NOS. EACH FACE

16Y – 4NOS.
SLAB TOP RL – 456.86

12”
D
PCC TOP RL – 443.31 6”
 C/C Dist. Between outer
bars / (No of bars – 1)

600

6Y@6” C/C
200 LINKS.
EACH FACE

123 123 123 123

 600
Width
200 200 Height of column for formwork calculation=

=(Slab top R.L. – PCC top R.L.) – Depth of footing

600 = (456.86 – 443.31) – 550
Length =13550 – 550
Height =13000
13000

COLUMN FORMWORK
 COLUMN
• Formwork(Sq.m.)
=(2*(Length/1000)*((Column depth-footing
depth)/1000))+(2*(Width/1000)*((Column depth-footing
depth)/1000))
=(2*(600/1000)*((13550-550)/1000))+(2*(200/1000)*((13550-
550)/1000)) = 20.80
• Concrete(Cum)
=((Length/1000)*(Width/1000)*(Column depth-footing
depth/1000))
=(600/1000)*(200/1000)*((13550-550/1000) = 1.56
• C/C Dist. Main Bar
=(Length of longitudinal face-(2*cover)-(2*dia of stirrups)-(2*Dia
of main bar/2))/(No of bars in longitudinal face-1)
=(600-(2*40)-(2*6)-(2*(16/2)))/(5-1) = 123 6
 COLUMN
• No of bars c
• Master Links
=((Depth of column)/spacing+1)
=((13451/150)+1) = 91
• Shape of bar
a=300 b
b=Column vertical length
=((Slab top RL – PCC top RL)*1000)-Footing cover–Footing
main bar – footing dist. Bar – slab cover
=13550-50-12-12-25 = 13451
C=(45*Dia of bar)-(Slab thick.-slab cover) a
=(45*16)-(150-25) = 595
7
 COLUMN
• Length of bar(mm)
• Main bar

• Main Bar= a + b + c + Lap Length – Bend Deduction

=(595+300+13451+2160)-(2*2*16) = 16442

• Length of Bar(m) c
=Length of bar (mm)/1000
=16442/1000 = 16.442
b
• Wt(Kg/m)
=((Diameter of bar)^2)/162
=(16^2)/162 = 1.58
a

8
 COLUMN
• Total weight(MT)
(Length of bar(m)*Wt(Kg/m)*No of bars*sets)/1000
=(16.442*1.58*6*1)/1000 = 0.156

• Total Formwork(Sq.m)
(Formwork of one component)*(No of sets)
=20.80*1 = 20.80

• Total Concrete(Cum)
(Concrete of one component)*(No of sets)
=1.56*1 = 1.56

9
 COLUMN LINKS
600

200 Master Link

75MM OR 10d
WHICHEVER IS MORE

600 – (2*40) = 520

200 – (2*40) = 120

TYPICAL STIRRUP/LINK
DETAILS

Cutting length of master link = 520+520+120+120 + HOOK LENGTH

= 520 + 520 +120 +120 + (75*2)

= 1430
 600

200 Link 2

=123+123+(2*(12/2) =258

200 – (2*40) = 120

123 123

Cutting length of Link 2 = 258+258+120+120 + HOOK LENGTH

= 258 + 258 +120 +120 + (75*2)

= 906
 COLUMN LINKS
600

200 Link 3

(9*6)= 54

200-(2*40)= 120

(9*6)= 54

Cutting length of Link 2 = 120+54+54

= 228
 BEAM
MAX L1/4 OR Ld MAX L1/4 OR Ld MAX L1/4 OR Ld

E.O.S. ‘d’ TOP

BARS ‘C’

CURTAILED BAR ‘b’ SPACER BAR (PIN) 20

STRAIGHT BAR (0.75 L1 SPAN) mm @ 750 mm c/c
‘a’ 75MM OR 10d
WHICHEVER IS MORE
(0.75 L1 SPAN)

L1 (SPAN)

BEAM
COL. COL.

TYPICAL REINFORCEMENT DETAILS OF BEAM

TYPICAL STIRRUP
DETAILS FOR BEAM
 SCHEDULE OF FIRST FLOOR BEAM
STIRRUPS L/4 STIRRUPS AT
BOTTOM
SIZE TOP REINFORCEMENT FROM MIDSPAN OF
REINFORCEMENT
BEAM SUPPORT 'e' BEAM 'f'
MEMBERS EXTRA AT
FULL SPAN FULL SPAN EXTRA AT
B D MID SPAN DIA SPACING DIA SPACING
'a' 'a' SUPPORT 'd'
'b'

FB1 8" 18" 12Y-2 NOS. 12Y-2 NOS. 12Y - 2 NOS. - 6Y 4" C/C 6Y 6" C/C

FB2 8" 18" 10Y-2 NOS. 10Y-1 NOS. 10Y - 2 NOS. 10Y - 1 NOS. 6Y 5" C/C 6Y 7" C/C

FB3,15 8" 18" 12Y-2 NOS. 12Y-1 NOS. 10Y - 2 NOS. 12Y - 1 NOS. 6Y 5" C/C 6Y 7" C/C

FB4 8" 24" 16Y-2 NOS. 12Y-2 NOS. 12Y - 2 NOS. 16Y - 2 NOS. 8Y 5" C/C 8Y 7" C/C

FB5 8" 18" 10Y-2 NOS. 10Y-1 NOS. 12Y - 2 NOS. 10Y - 1 NOS. 6Y 5" C/C 6Y 7" C/C
 100 3404

450 C1 C2 450
FB2

200 200
X X

200 3104 200

L/S CLEAR SPAN R/S
 200 3104 200

=20D-160 =20D-160
=20x10-160 =20x10-160
=40 =40
=200-40 3104 =200-40
=160 =160

BOTTOM MAIN BAR

200 3104 200

=L1/4 or Ld
=3304/4 =200-40
=826 =160
=DEPTH – 2 x COVER
=450 – 2 x 30
=390

TOP R.E.O.S BAR

• STIRRUPS AT L/4 FROM SUPPORT
NO OF BARS
= (Length of clear span/4) + 1
Spacing
= (3104/4)
+1
125
=8
• STIRRUPS AT MIDSPAN
NO OF BARS
= (Length of clear span/4) + 1
Spacing
= (3104/4)
+1
175
= 10
 CLEAR
SPAN

SLAB

DEPTH BEAM DEPTH –

SLAB THICKNESS

WIDTH
 BEAM
• Formwork(Sq.m)
=((Depth/1000)*(Length of clear
span/1000))+((Width/1000)*(Length of clear
span/1000))+((Beam depth-slab thickness)/1000)*(Length
of clear span/1000))
• =((450/1000)*(3104/1000))+((200/1000)*(3104/1000))+(((
450-125)/1000)*(3104/1000))
• = 3.03

• Concrete(Cum)
=((Length of clear span/1000)*(Width/1000)*(Depth/1000)
• =(200/1000)*(200/1000)*(450/1000)
• = 0.28
10
 BEAM
• Shape of bar(mm)
• Bottom main bar
a e

b c d
a=(20*d)-b = 40
b=Left support-Col. Cover = 200-40 = 160
c=Clear span = 3104
d=Right support-Col. Cover = 200-40 = 160
e=(20*d)-d = (20*10)-160 = 40

• Length of bar(mm)= a+ b + c + d + e – Bend deduction

=(40+160+3104+160+40)-(2*2*10)
=3464

11
 BEAM
• Length of bar(m)
=Length of bar(mm)/1000
=3464/1000 = 3.464
• Wt(Kg/m)
=((Diameter of bar)^2)/162
=(10^2)/162 = 0.62
• Total weight(MT)
(Length of bar(m)*Wt(Kg/m)*No of bars*No of sets)/1000
=(3.464*0.62*2*1)/1000
• Total Formwork(Sq.m)
(Formwork of one component)*(No of sets)
=3.03*1 = 3.03
• Total Concrete(Cum)
(Concrete of one component)*(No of sets)
=0.28*1 = 0.28
12
 SLAB
REINF. ALONG SHORTER SPAN
ALTERNATE BENTUP BARS

REINF. ALONG LONGER SPAN REINF. ALONG LONGER SPAN

MAX OF L1/3 OR 30” MAX OF L2/3 OR 30” MAX OF L2/3 OR 30”

L1/7 L1/5 L2/5 L2/5

L1 L2

TYPICAL BAR BENDING DETAILS FOR SLAB

 SCHEDULE OF FIRST FLOOR SLAB
REINFORCEMENT REINFORCEMENT
SLAB
THICKNESS ALONG SHORTER ALONG LONGER REMARKS
MARKS
SPAN SPAN
S1 5" 8Y @ 5" C/C 6Y @ 6" C/C ONE WAY SLAB
S2 5" 8Y @ 5" C/C 6Y @ 6" C/C ONE WAY SLAB
S3 6" 10Y @ 7" C/C 10Y @ 7" C/C TWO WAY SLAB
S4 4 - 1/2" 8Y @ 6" C/C 6Y @ 6" C/C ONE WAY SLAB
S5 5" 8Y @ 6" C/C 8Y @ 7" C/C TWO WAY SLAB
ST 4 - 1/2" 8Y @ 6" C/C 6Y @ 6" C/C ONE WAY SLAB
 8444 11758
FB9
C11 C12 6305
62.5 25

3401
FB20 FB16

2904

C7 C8 3201
FB5

C11 – 200x525 Long span = 11758-8444+62.5+25 = 3401.5

C12 – 200x550 Short span = 6305-3201-100-100 = 2904
FB20 – 200
FB16 - 200
 SLAB
• Formwork(Sq.m)
=(Short span/1000)*(Long span/1000)
=(2904/1000)*(3401/1000)
• =9.88

• Concrete(Cum)
=(Short span/1000)*(Long span/1000)*(Slab
Thk/1000))
=(2904/1000)*(3401/1000)*(125/1000)
= 1.23

14
 SLAB
• No. of bars
• Main Bars
=(Long span/Spacing)+1
=(3401/150)+1
=23

• Distribution Bars
=(Short span/spacing)+1
=(2904/175)+1
= 17
 MAX OF L1/3 OR 30” MAX OF L2/3 OR 30” MAX OF L2/3 OR 30”

L1/7 L1/5 L2/5 L2/5

L1 L2
FB9
C11 C12

Shorter span
FB20 FB16

C7 C8
FB5
 SLAB
• Shape of bar(mm)
• Short span main bar b c
d e f
a
a=Slab Thick-(2*Slab cover) = 125-(2*25) = 75
b=Left support-Beam Cover = 200 – 30 = 170
c=((Short span+(Left support/2)+(Right support/2))/7)-(Left support/2)
=((2904+(200/2)+(200/2))/7)-(200/2) = 343
d=(0.42*(Slab Thk-(2*Slab cover)))
= (0.42*(125-(2*25))) = 32
e=Short span- c = 2904 – 343 = 2561
F=Right support = 200

Length of bar(mm)= a+ b + c + d + e + f – Bend deduction

15
=(75+170+343+32+2561+200-(2*1*8)-(1*(2*8))
=3349
 SLAB
• Shape of bar(mm)
• Short span dist. Bar c b a
d
f e
a=(L2/3)-(Support/2) = (3504/3)-(200/2) = 1068
b= Right support = 200
c=((Short span+(Left support/2)+(Right support/2))/5-Right support/2
= ((2904+(200/2)+(200/2))/5-200/2 = 721
d=(0.42*(Slab Thk-(2*Slab cover)))
= (0.42*(125-(2*25))) = 32
e=Short span - c = 2904 – 721 = 2183
f=Left support = 200
Length of bar(mm)= a + b + c + d + e + f – Bend deduction
=(1068+200+721+32+2183+200)-(2*1*8)
=4388
16
 SLAB
• Shape of bar(mm)
• Long span main bar
a b c
d e f
a=(4878/3)-(200/2)) = 1526
b=Left support = 200
c=((Long span+(Left support/2)+(Right support/2))/5)-Left support/2
=((3401+(200/2)+(200/2))/5)-(200/2) = 620
d=(0.45*(Slab Thk-(2*Slab Cover)-(2*Bar dia/2))))
= (0.45*(125-(2*25)-(2*(8/2)))) = 30
E=Long span- c = 3401 – 620 = 2781
F=200
Length of bar(mm)= a + b + c + d + e + f – Bend Deduction
=(1526+200+620+30+2781+200)-(2*(1*8))
=5341 17
 SLAB
• Shape of bar(mm)
• Long span dist. Bar
c b
d a
f e

a=Slab Thk-(2*Slab cover)=125-(2*25) = 75

B=Right support-Beam cover = 200-30 = 170
c=((Long span+(Left suppordt/2)+(Right support/2))/7)-Right support/2
=((3401+(200/2)+(200/2))/7)-200/2 = 414
d=(0.45*(Slab Thk-(2*slab cover)-(2*(Bar dia/2))))
=(0.45*(D22-(2*L22)-(2*(K22/2)))) = 30
e=Long span – c =3401-414 = 2987
f=200
Length of bar(mm)= a + b + c + d + e + f – Bend Deduction
=(75+170+414+30+2987+200)-(1*(2*8))-(2*(1*8))
=3753 18
 SLAB
• Length of bar(m)
=Length of bar(mm)/1000
=3349/1000 = 3.34
• Wt(Kg/m)
=((Diameter of bar)^2)/162
=(8^2)/162 = 0.40
• Total weight(MT)
(Length of bar(m)*Wt(Kg/m)*No of bars*sets)/1000
=(3.34*0.40*12*1)/1000 = 0.016
• Total Formwork(Sq.m)
(Formwork of one component)*(No of sets)
=9.88*1 = 9.88
• Total Concrete(Cum)
(Concrete of one component)*(No of sets)
=1.23*1 = 1.23 19
 BBS FOOTING IN EXCEL
• Formwork (Sq.m)

=(2*(Length/1000)*(Depth/1000))+(2*(width/1000)*(Dept
h/1000))
G11
=(2*(D11/1000)*(F11/1000))+(2*(E11/1000)*(F11/1000))
• Concrete(Cum.)
=((Length/1000)*(Width/1000)*(Depth/1000)
H11= (D11/1000)*(E11/1000)*F11/1000)
• No of Bars
– Main Bar
=ROUNDUP((Length of long span-(2*cover))/Spacing+1,0)
L11=ROUNDUP((D11-(2*J11))/K11+1,0)
Distribution Bar
=ROUNDUP((Length of short span-(2*Cover))/spacing+1,0)
1
L13=ROUNDUP((E13-(2*J13))/K13+1,0)
 FOOTING
• Shape of Bar –
• Main Bar
150 150

Length of short span-(2*Cover)

=E11-(2*J11)

• Distribution Bar

150 150

Length of long span-(2*Cover)

=D13-(2*J13)
2
 FOOTING
• Length of Bar (mm)
• Main Bar
150 150
a c
Length of short span-(2*Cover)
b
• Main Bar= a + b+ c
Q11=(N11+O12+P11)-(2*2*I11)

• Distribution bar 150 150

a c
Length of long span-(2*Cover)
• Dist. Bar=a + b + c b

Q13= N13+O14+P13 3
 FOOTING
• Length of Bar (m)
=Length of Bar(mm)/1000
R11=Q11/1000
• Wt(Kg/m)
=((Diameter of bar)^2/162
S11=(I11^2)/162
• Total Weight(MT)
(Length of bar(m)*WT(Kg/m)*No of bars*sets)/1000
T11=(R11*S11*L11*M11)/1000
• Total Formwork(sq.m)
(Formwork of one component)*(No of sets)
U11=G11*M11
• Total Concrete(Cum)
(Concrete of one component)*(No of sets)
V11=H11*M11 4
 FOOTING
• Total Wt (Each dia. In MT)
=IF(Diameter of given bar = Diameter of available
bar, WT(MT) of given bar,0)
W11=IF(I11=$W$8.T11,0)
X11=IF(I11=$X$8,T11,0)
Y11=IF(I11=$Y$8,T11,0)
Z11=IF(I11=$Z$8,T11,0)
A11=IF(I11=$AA$8,T11,0)
AB11=IF(I11=$AB$8,T11,0)
5
 COLUMN
• Formwork(Sq.m.)
=(2*(Length/1000)*((Column depth-footing
depth)/1000))+(2*(Width/1000)*((Column depth-footing
depth)/1000))
G10=(2*(D10/1000)*((F10-550)/1000))+(2*(E10/1000)*((F10-
550)/1000))
• Concrete(Cum)
=((Length/1000)*(Width/1000)*(Column depth-footing
depth/1000))
H10=(D10/1000)*(E10/1000)*((F10-550/1000)
• C/C Dist. Main Bar
=(Length of longitudinal face-(2*cover)-(2*dia of stirrups)-(2*Dia
of main bar/2))/(No of bars in longitudinal face-1)
L10=(D10-(2*J10)-(2*6)-(2*($I$10/2)))/(5-1) 6
 COLUMN
• No of bars
c
• Master Links
=ROUNDUP((Depth of column)/spacing+1,0)
M18=ROUNDUP((P14/K18)+1,0)
• Shape of bar
a=300
b=Column vertical length b
=((Slab top RL – PCC top RL)*1000)-Footing cover–Footing
main bar – footing dist. Bar – slab cover

• P10=F10-50-12-12-25
• C=(45*Dia of bar)-(Slab thick.-slab cover) a
• P9=(45*I10)-(150-25)
7
 COLUMN
c
• Length of bar(mm)
• Main bar
b
• Main Bar= a + b + c
S10=(P9+O11+P10+R10)-(2*2*I10)
a
• Length of Bar(m)
=Length of bar =(mm)/1000
T10=S10/1000

• Wt(Kg/m)
=((Diameter of bar)^2)/162
U10=(I10^2)/162
8
 COLUMN
• Total weight(MT)
(Length of bar(m)*Wt(Kg/m)*No of bars*sets)/1000
V10=(T10*U10*M10*N10)/1000
• Total Formwork(Sq.m)
(Formwork of one component)*(No of sets)
W10=G10*N10
• Total Concrete(Cum)
(Concrete of one component)*(No of sets)
X10=H10*N10
• Total Wt(Each dia in MT)
=IF(Diameter of given bar = Diameter of available bar, Wt(MT) of
given bar,0)
Y10=IF(I10=$Y$8,V10,0)

9
 BEAM
• Formwork(Sq.m)
=((Depth/1000)*(Length of clear
span/1000))+((Width/1000)*(Length of clear
span/1000))+((Beam depth-slab thickness)/1000)*(Length
of clear span/1000))
• J10=((E10/1000)*(H10/1000))+((D10/1000)*(H10/1000))+((
(E10-125)/1000)*(H10/1000))

• Concrete(Cum)
=((Length of clear span/1000)*(Width/1000)*(Depth/1000)
• K10=(D10/1000)*(E10/1000)*(H10/1000)

10
 BEAM
• Shape of bar(mm)
• Bottom main bar
a e

b c d
a=R10=(20*L10)-S11
b=S11=F10-N10
c=T11=H10
d=U11=I10-N10
e=V10=(20*L10)-U11

• Length of bar(mm)= a+ b + c + + d + e
X10=(R10+S11+T11+U11+V10)-(2*2*L10)

11
 BEAM
• Length of bar(m)
=Length of bar(mm)/1000
Y10=X10/1000
• Wt(Kg/m)
=((Diameter of bar)^2)/162
Z10=(L10^2)/162
• Total weight(MT)
(Length of bar(m)*Wt(Kg/m)*No of sets)/1000
AA10=(Y10*Z10*P10*Q10)/1000
• Total Formwork(Sq.m)
(Formwork of one component)*(No of sets)
AB10=J10*Q10
• Total Concrete(Cum)
(Concrete of one component)*(No of sets)
AC10=K10*Q10
12
 BEAM
• Total Wt(Each dia in MT)
=IF(Diameter of given bar = Diameter of
available bar, Wt(MT) of given bar,0)
AD10=IF(L10=$AD$8,AA10,0)

13
 SLAB
• Formwork(Sq.m)
=(Short span/1000)*(Long span/1000)
I10=(F10/1000)*(G10/1000)

• Concrete(Cum)
=(Short span/1000)*(Long span/1000)*(Slab
Thk/1000))
J10=I10*(D10/1000)

14
 SLAB
• Shape of bar(mm)
• Short span main bar b c
d e f
a
a=Q10=D10-(2*L10)
b=R9=E10-M10
c=S9=((F10+(E10/2)+(H10/2))/7)-E10/2
d=T9=(0.45*(D10-(2*L10)-(2*(K10/2))))
e=U11=F10-S9
F=X11=H10
Length of bar(mm)= a+ b + c + d + e + f
AA10=(R9+Q10+S9+U11+T9+X11)-(2*1*K10)-(1*(2*K10))
15
 SLAB
• Shape of bar(mm)
• Short span dist. Bar c b a
d
f e

a=Y13=(3504/3)-(H14/2)
b=X13=H14
c=W13=((F14+(E14/2)+(H14/2))/7-H14/2
d=V13=(0.45*(D14-(2*L14)-(2*(K14/2))))
e=S15=F14-W13
f=R15=E14
Length of bar(mm)= a + b + c + d + e + f
AA14=(V13+R15+S15+W13+X13+Y13)-(2*1*K14)
16
 SLAB
• Shape of bar(mm)
• Long span main bar
a b c
d e f

a=Q17=(4878/3)-(E18/2))
b=R17=E18
c=S17=((G18+(E18/2)+(H18/2))/5)-E18/2
d=T17=(0.45*(D18-(2*L18)-(2*K18/2))))
E=U19=G18-S17
F=X19=H18
Length of bar(mm)= a + b + c + d + e + f
AA18=(R17+Q17+S17+U19+T17+X19)-(2*(1*K18)) 17
 SLAB
• Shape of bar(mm)
• Long span dist. Bar c b
d a
f e

a=Y22=D22-(2*L22)
b=X21=H22-M22
c=W21=((G22+(E22/2)+(H22/2))/7)-H22/2
d=V21=(0.45*(D22-(2*L22)-(2*(K22/2))))
e=S23=G22-W21
f=R23=E22
Length of bar(mm)= a + b + c + d + e + f
AA22=(V21+R23+S23+W21+X21+Y22)-(1*(2*K22))-
(2*(1*K22)) 18
 SLAB
• Length of bar(m)
=Length of bar(mm)/1000
AB10=AA10/1000
• Wt(Kg/m)
=((Diameter of bar)^2)/162
AC10=(K10^2)/162
• Total weight(MT)
(Length of bar(m)*Wt(Kg/m)*No of bars*sets)/1000
AD10=(AB10*AC10*O10*P10)/1000
• Total Formwork(Sq.m)
(Formwork of one component)*(No of sets)
AE=I10*P10
• Total Concrete(Cum)
(Concrete of one component)*(No of sets)
19
AF10=J10*P10
 SLAB
• Total Wt(Each dia. In MT)
=IF(Diameter of given bar = Diameter of
available bar, Wt(MT) of given bar,0)
AG10=IF(K10=$AG$8,AD10,0)

20