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

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 Length
 |  |  |  |  |  |  | Test | Survey
 | Line G | SD.MH-4E | SD.MH-G1 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 58
ELC/EXT/STM/76 | "       " | SD.MH-G1 | SD.MH-G2 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 62.5 | 60 | 62.5
ELC/EXT/STM/61 | "       " | SD.MH-G2 | SD.MH-G3 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 100 | 87.5 | 100
ELC/EXT/STM/61 | "       " | SD.MH-G3 | SD.MH-G4 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 115.5 | 112.5 | 115.5
ELC/EXT./STM/29 | "       " | SD.MH-G4 | SD.MH-G5 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 88.5 | 82.5 | 88.5
ELC/EXT/STM/18 | "       " | SD.MH-G5 | SD.MH-G6 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 100 | 90 | 100
ELC/EXT/STM/81 | "       " | SD.MH-G6 | SD.MH-G7 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 57.5 | 35 | 57.5
ELC/EXT./STM/26 | "       " | SD.MH-G7 | SD.MH-G8 | 900 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 87 | 82.5 | 87
ELC/EXT./STM/30 | "       " | SD.MH-G8 | SD.MH-G9 | 900 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 79.5 | 75 | 79.5
ELC/EXT./STM/3 | "       " | SD.MH-G9 | SD.MH-G10 | 900 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 79 | 72.5 | 79
ELC/EXT./STM/35 | "       " | SD.MH-G10 | SD.MH-G11 | 800 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 72 | 70 | 72
ELC/EXT/STM/20A | "       " | SD.MH-G11 | SD.MH-G12 | 800 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 76 | 70 | 76
ELC/EXT/STM/20A | "       " | SD.MH-G12 | SD.MH-G13 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 76 | 70 | 76
 | "       " | SD.MH-G13 | SD.MH-G14 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 58.5
ELC/EXT/STM/57 | Line G 7 | SD.MH-G7 | SD.MH-G7/1 | 700 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 82.5 | 77 | 82.5
 | "       " | SD.MH-G7/1 | SD.MH-G7/2 | 600 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 45
 | "       " | SD.MH-G7/2 | SD.MH-G7/2/1 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 22.5
 | "       " | SD.MH-G7/2/1 | SD.MH-G7/2/2 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 22
ELC/EXT/STM/72 | "       " | SD.MH-G7/2 | SD.MH-G7/3 | 600 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 95 | 92.5 | 95
 | "       " | SD.MH-G7/3 | SD.MH-G7/3/1 | 600 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 17.5
ELC/EXT/STM/57 | "       " | SD.MH-G7/3 | SD.MH-G7/4 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 90.5 | 83 | 90.5
ELC/EXT/STM/60 | Line G 10 | SD.MH-G10 | SD.MH-G10/1 | 700 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 82.5 | 80.5 | 82.5 | 378
ELC/EXT/STM/69 | "       " | SD.MH-G10/1 | SD.MH-G10/2 | 700 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 56 | 45 | 56
 | "       " | SD.MH-G10/2 | SD.MH-G10/3 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 23.5
 | "       " | SD.MH-G10/3 | SD.MH-G10/4 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 26.5
 | "       " | SD.MH-G10/2 | SD.MH-G10/2/1 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 21.5
 | "       " | SD.MH-G10/2/1 | SD.MH-G10/2/2 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 20.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Length |  | 1400 | 1285.5