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

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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 112.5
 | Line C | SD.MH-2A | SD.MH-C1 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 52
ELC/EXT/STM/21 | "       " | SD.MH-C1 | SD.MH-C2 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 23 | 17.5 | 23
ELC/EXT./STM/27 | "       " | SD.MH-C2 | SD.MH-C3 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 82.5 | 70 | 82.5
ELC/EXT/STM/17 | "       " | SD.MH-C3 | SD.MH-C4 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 82.5 | 95 | 82.5
5B | "       " | SD.MH-C4 | SD.MH-C5 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 117 | 92.5 | 117
12 | "       " | SD.MH-C5 | SD.MH-C6 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 48.5 | 42.5 | 48.5
ELC/EXT./STM/36 | "       " | SD.MH-C6 | SD.MH-C7 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 51.5 | 47.5 | 51.5
ELC/EXT/STM/62 | "       " | SD.MH-C7 | SD.MH-C8 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 76.5 | 70 | 76.5
 | "       " | SD.MH-C8 | SD.MH-C9 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 54
ELC/EXT./STM/27 | "       " | SD.MH-C9 | SD.MH-C10 | 900 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 29.5 | 22.5 | 29.5
ELC/EXT./STM/36 | "       " | SD.MH-C10 | SD.MH-C11 | 800 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 92.5 | 85 | 92.5
ELC/EXT./STM/49 | "       " | SD.MH-C11 | SD.MH-C12 | 800 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 84.5 | 87.5 | 84.5 |  | 20
ELC/EXT/STM/64 | "       " | SD.MH-C12 | SD.MH-C13 | 700 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 75 | 60 | 75
ELC/EXT./STM/33 | "       " | SD.MH-C13 | SD.MH-C14 | 700 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 58.5 | 52.5 | 58.5
ELC/EXT/STM/64 | "       " | SD.MH-C14 | SD.MH-C15 | 400 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 61.5 | 55 | 61.5
ELC/EXT./STM/33 | "       " | SD.MH-C15 | SD.MH-C16 | 400 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 73.5 | 67.5 | 73.5
 | "       " | SD.MH-C16 | SD.MH-C17 | 300 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 53.5
ELC/EXT/STM/24 | [NAME] | SD.MH-C1 | SD.MH-C1/1 | 600 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 52 | 20 | 52
ELC/EXT/STM/23 | Line C2 | SD.MH-C2 | SD.MH-C2/1 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 26 | 20 | 26
ELC/EXT/STM/23 | "       " | SD.MH-C2/1 | SD.MH-C2/1/1 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 22 | 15 | 22
ELC/EXT/STM/23 | "       " | SD.MH-C2/1 | SD.MH-C2/2 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | 5 | 12
ELC/EXT/STM/23 | "       " | SD.MH-C2/2 | SD.MH-C2/3 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 31.5 | 27.5 | 31.5
ELC/EXT/STM/78 | [NAME] | SD.MH-C3 | SD.MH-C3/1 | 400 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 24 | 20 | 24
ELC/EXT/STM/74 | Line C4 | SD.MH-C4 | SD.MH-C4/1 | 400 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 24.5 | 20 | 24.5
ELC/EXT/STM/73 | [NAME] | SD.MH-C5 | SD.MH-C5/1 | 400 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 24.5 | 17.5 | 24.5
ELC/EXT/STM/75 | Line C6 | SD.MH-C6 | SD.MH-C6/1 | 400 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 24 | 20 | 24
 | [NAME] | SD.MH-C10 | SD.MH-C10/1 | 600 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 27
 | "       " | SD.MH-C10/1 | SD.MH-C10/2 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 90
 | Line C12 | SD.MH-C12 | SD.MH-C12/1 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 24
 | [NAME] | SD.MH-C13 | SD.MH-C13/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | [NAME] | SD.MH-C14 | SD.MH-C14/1 | 600 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 29.5
 | "       " | SD.MH-C14/1 | SD.MH-C14/2 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Length |  | 1197 | 1030
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 287.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 445