Spreadsheet: 107036d1304191668-spellnumber-formula-example-sheet
Sheet: Line-B

EMERGENCY LODGING CENTER PROJECT, SHUMAISI
EXTERNAL WORKS - ROAD PROJECTS
Storm Drainage System
Pipe Installation
Request No. | Line No. | From Manhole | To Manhole | Pipe Dia. | Excavaion | Beding | Pipe |  | Gravel | Layer 1 | Layer 2 | Layer 3 | Layer 4 | Layer 5 | Layer 6 | Layer 7 | As per Drawing | Approved Qty
 |  |  |  |  |  |  | Test | Survey
 | Line B | SD.MH-A | SD.MH-B1 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 52 | 228.5
ELC/EXT/STM/65 | "       " | SD.MH-B1 | SD.MH-B2 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 52.5 | 50 | 52.5
1 Rev-1 | "       " | SD.MH-B2 | SD.MH-B3 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 48.5 | 42.5 | 48.5
1 Rev-1 | "       " | SD.MH-B3 | SD.MH-B4 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 37.5 | 30 | 37.5
4 | "       " | SD.MH-B4 | SD.MH-B5 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 38 | 32.5 | 38
ELC/EXT./SMT/14 | "       " | SD.MH-B5 | SD.MH-B6 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 40.5 | 37.5 | 40.5
ELC/EXT/STM/20B | "       " | SD.MH-B6 | SD.MH-B7 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 72 | 67.5 | 72
ELC/EXT./STM/28 | "       " | SD.MH-B7 | SD.MH-B8 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 76.5 | 72.5 | 76.5
ELC/EXT./STM/47 | "       " | SD.MH-B8 | SD.MH-B9 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 32 | 27.5 | 32
ELC/EXT./STM/63 | "       " | SD.MH-B9 | SD.MH-B10 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 69.5 | 65 | 69.5
 | "       " | SD.MH-B10 | SD.MH-B11 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 20
ELC/EXT/STM/63 | "       " | SD.MH-B11 | SD.MH-B12 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 51.5 | 47.5 | 51.5
ELC/EXT./STM/31 | "       " | SD.MH-B12 | SD.MH-B13 | 900 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 57 | 55 | 57
ELC/EXT./STM/31 | "       " | SD.MH-B13 | SD.MH-B14 | 900 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 50 | 47.5 | 50
ELC/EXT./STM/32 | "       " | SD.MH-B14 | SD.MH-B15 | 800 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 64.5 | 60 | 64.5
ELC/EXT./STM/32 | "       " | SD.MH-B15 | SD.MH-B16 | 800 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 25.5 | 20 | 25.5
ELC/EXT./STM/48 | "       " | SD.MH-B16 | SD.MH-B17 | 800 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 37.5 | 35 | 37.5
ELC/EXT./STM/48 | "       " | SD.MH-B17 | SD.MH-B18 | 800 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 45.5 | 40 | 45.5
ELC/EXT/STM/53 | "       " | SD.MH-B18 | SD.MH-B19 | 600 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 90 | 87.5 | 90
ELC/EXT/STM/53 | "       " | SD.MH-B19 | SD.MH-B20 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 59.5 | 57.5 | 59.5
 | "       " | SD.MH-B20 | SD.MH-B21 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 47.5
 | "       " | SD.MH-B21 | SD.MH-B22 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 53.5
8 | Line B2 | SD.MH-B2 | SD.MH-B2/1 | 600 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 21 | 17.5 | 21
8 | "       " | SD.MH-B2/1 | SD.MH-B2/2 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 46 | 42.5 | 46
8 | "       " | SD.MH-B2/2 | SD.MH-B2/3 | 400 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 42.5 | 40 | 42.5
13 | [NAME] | SD.MH-B8 | SD.MH-B8/1 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 96 | 92.5 | 96
13 | "       " | SD.MH-B8/1 | SD.MH-B8/2 | 400 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 17.5 | 15 | 17.5
ELC/EXT./STM/25 | [NAME] | SD.MH-B12 | SD.MH-B12/1 | 600 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 59 | 56 | 59
ELC/EXT./STM/25 | "       " | SD.MH-B12/1 | SD.MH-B12/2 | 600 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 75 | 67.5 | 75
ELC/EXT./STM/34 | "       " | SD.MH-B12/2 | SD.MH-B12/3 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 53 | 47.5 | 53
ELC/EXT./STM/34 | "       " | SD.MH-B12/3 | SD.MH-B12/4 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 52.5 | 50 | 52.5
 | "       " | SD.MH-B12/4 | SD.MH-B12/5 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 42
 | "       " | SD.MH-B12/5 | SD.MH-B12/6 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 62
 | "       " | SD.MH-B12/6 | SD.MH-B12/7 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 57.5
 | [NAME] | SD.MH-B18 | SD.MH-B18/1 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 65.5
 | "       " | SD.MH-B18/1 | SD.MH-B18/2 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 70.5
 | "       " | SD.MH-B18/2 | SD.MH-B18/3 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 21.5
 | "       " | SD.MH-B18/3 | SD.MH-B18/4 | 300 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 60
 | "       " | SD.MH-B18/4 | SD.MH-B18/5 | 300 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 57.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Length |  | 1410.5 | 1303.5