Spreadsheet: 759082d1639299854-using-index-match-function-in-same-row-calculation-bandra-wall_column_drainagenalla
Sheet: Sheet1

 | N | L | H / T | W
[NAME] (C:M - 1:5) | 1 | 80 | 1.22 | 0.23
[NAME] (450x450x2.13) |  | 0.45 | 2.13 | 0.45
Plaster (C:M - 1:4) | 2
 | 2
PCC - M15 | 1 |  | 0.15 |  |  | 7850
RCC - M30
[NAME] | 1 |  | 0.175
[NAME] | 1 |  | 0.15
Pardi | 2 |  | 1.7 | 0.175
 |  |  |  |  |  | 8925
Formwork
Column
[NAME] | 1 |  | 0.9
Pardi | 4 |  | 1.7
 |  |  |  |  |  | 900
Steel | No | L
Column - Main 12mm
Column - Stirrups 8mm
[NAME]
[NAME]mm
[NAME]mm
[NAME]mm
Top Distribution - 8mm
[NAME]
[NAME]mm
[NAME]mm
[NAME]mm
Top Distribution - 8mm
Pardi
Vertical Main - 10mm
Distribution - 8mm
 |  |  |  |  |  | 107000
Excavation | 1
RAMP WORK
Wall shuttering area | m2 |  |  |  |  | 200
PCC for raft | m3 |  | 17 | 8.2 | 0.15
 |  |  | 11.74 | 8.2 | 0.15
M35 concrete for foundation
raft slab | m3 | 1 | 17 | 7.9 | 0.45
 | m3 | 1 | 11.74 | 7.9 | 0.45
Retaining wall | m3 | 2 |  | 0.35
 |  | 2 |  | 0.35
Reinforcement
 |  |  |  |  |  |  |  |  | Bend |  |  |  |  |  |  | Bar Length (m)
Bar mark | Shape |  |  | a (m) | b (m) | c (m) | d (m) | e (m) | 45° | 90° | 180° | dia ([NAME]) | spacing ([NAME]) | cut length (m) | Nos | 8 | 10 | 12 | 16 | 20 | 25 | 32 | 40
 |  |  |  |  |  |  |  |  | 0.25 | 0.5 | 1
[NAME] span top |  |  |  | 0.3 | 7.9 | 0.3 |  |  |  | 2 |  | 12 | 125 |  | 95
[NAME] span bottom |  |  |  | 0.3 | 7.9 | 0.3 |  |  |  | 2 |  | 12 | 200 |  | 60
[NAME] span top |  |  |  | 0.3 | 11.75 | 0.3 |  |  |  | 2 |  | 12 | 200 |  | 31
[NAME] span bottom |  |  |  | 0.3 | 11.75 | 0.3 |  |  |  | 2 |  | 12 | 200 |  | 31
RS-1B [NAME] short span top |  |  |  | 0.3 | 7.9 | 0.3 |  |  |  | 2 |  | 12 | 175 |  | 104
RS-1B [NAME] short span bottom |  |  |  | 0.3 | 7.9 | 0.3 |  |  |  | 2 |  | 12 | 300 |  | 104
RS-1B RS-1C long span top |  |  |  | 0.3 | 17 | 0.3 |  |  |  | 2 |  | 12 | 300 |  | 28
RS-1B RS-1C long span bottom |  |  |  | 0.3 | 17 | 0.3 |  |  |  | 2 |  | 12 | 300 |  | 28
Inside main bar RS-1A |  |  |  | 0.2 | 0.29 | 1.2 | 1.82 | 0.2 |  | 4 |  | 10 | 150 |  | 80
Inside distribution bar RS-1A |  |  |  | 11.75 |  |  |  |  |  |  |  | 10 | 200 |  | 6
outside main full length bar RS-1A |  |  |  | 0.2 | 0.29 | 1.2 | 0.89 |  |  | 3 |  | 12 | 200 |  | 60
outside curtailed bar RS-1A |  |  |  | 0.6 | 0.89 |  |  |  |  | 1 |  | 12 | 200 |  | 60
outside distribution bar RS-1A |  |  |  | 11.75 |  |  |  |  |  |  |  | 10 | 200 |  | 6
Inside main bar RS-1B |  |  |  | 0.2 | 0.29 | 1.6 | 0.89 | 0.2 |  | 4 |  | 10 | 200 |  | 41
Inside distribution bar RS-1B |  |  |  | 8 |  |  |  |  |  |  |  | 10 | 300 |  | 7
outside main full length bar RS-1B |  |  |  | 0.2 | 0.29 | 1.6 | 1.29 |  |  | 3 |  | 12 | 300 |  | 28
outside curtailed bar RS-1B |  |  |  | 0.8 | 1.29 |  |  |  |  | 1 |  | 12 | 300 |  | 28
outside distribution bar RS-1B |  |  |  | 8 |  |  |  |  |  |  |  | 10 | 300 |  | 7
Inside main bar RS-1C |  |  |  | 0.2 | 0.29 | 2.2 | 0.89 | 0.2 |  | 4 |  | 10 | 300 |  | 31
Inside distribution bar RS-1C |  |  |  | 9 |  |  |  |  |  |  |  | 10 | 300 |  | 9
outside main full length bar RS-1C |  |  |  | 0.2 | 0.29 | 2.2 | 0.89 |  |  | 3 |  | 10 | 300 |  | 31
outside curtailed bar RS-1C |  |  |  | 1.1 | 0.89 |  |  |  |  | 1 |  | 10 | 300 |  | 31
outside distribution bar RS-1C |  |  |  | 9 |  |  |  |  |  |  |  | 10 | 300 | 9 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | Total length
 |  |  |  |  |  |  |  |  |  |  |  |  | unit [NAME]/m
 |  |  |  |  |  |  |  |  |  |  |  |  | weight (kg)
 |  |  |  |  |  |  |  |  |  |  |  |  | Total weight