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

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 E | SD.MH-E | SD.MH-E1 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 50
 | "       " | SD.MH-E1 | SD.MH-E2 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 27
 | "       " | SD.MH-E2 | SD.MH-E3 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 30
 | "       " | SD.MH-E3 | SD.MH-E4 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 78
 | "       " | SD.MH-E4 | SD.MH-E5 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 88
 | "       " | SD.MH-E5 | SD.MH-E6 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 28.5
 | "       " | SD.MH-E6 | SD.MH-E7 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 35
 | "       " | SD.MH-E7 | SD.MH-E8 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 53
 | "       " | SD.MH-E8 | SD.MH-E9 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 78
 | "       " | SD.MH-E9 | SD.MH-E10 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 57
 | "       " | SD.MH-E10 | SD.MH-E11 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 54
ELC/EXT./STM/80 | "       " | SD.MH-E11 | SD.MH-E12 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 26 | 22.5 | 26
ELC/EXT./STM/80 | "       " | SD.MH-E12 | SD.MH-E13 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 31 | 27.5 | 31
ELC/EXT./STM/83 | "       " | SD.MH-E13 | SD.MH-E14 | 1000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 78 | 75 | 78
 | "       " | SD.MH-E14 | SD.MH-E15 | 800 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 87.5
 | "       " | SD.MH-E15 | SD.MH-E16 | 800 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | "       " | SD.MH-E16 | SD.MH-E17 | 800 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 26.5
 | "       " | SD.MH-E17 | SD.MH-E18 | 800 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 66
 | "       " | SD.MH-E18 | SD.MH-E19 | 700 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 78
 | "       " | SD.MH-E19 | SD.MH-E20 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 56.5
 | "       " | SD.MH-E20 | SD.MH-E21 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 53
 | [NAME] | SD.MH-E1 | SD.MH-E1/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 26
 | Line E2 | SD.MH-E2 | SD.MH-E2/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E3 | SD.MH-E3 | SD.MH-E3/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E4 | SD.MH-E4 | SD.MH-E4/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E5 | SD.MH-E5 | SD.MH-E5/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 26
 | Line E6 | SD.MH-E6 | SD.MH-E6/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 26
 | Line E7 | SD.MH-E7 | SD.MH-E7/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E8 | SD.MH-E8 | SD.MH-E8/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E9 | SD.MH-E9 | SD.MH-E9/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E10 | SD.MH-E10 | SD.MH-E10/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 26
 | Line E11 | SD.MH-E11 | SD.MH-E11/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 26
 | Line E12 | SD.MH-E12 | SD.MH-E12/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E13 | SD.MH-E13 | SD.MH-E13/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E14 | SD.MH-E14 | SD.MH-E14/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E15 | SD.MH-E15 | SD.MH-E15/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E16 | SD.MH-E16 | SD.MH-E16/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 26.5
 | Line E17 | SD.MH-E17 | SD.MH-E17/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E18 | SD.MH-E18 | SD.MH-E18/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E19 | SD.MH-E19 | SD.MH-E19/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25
 | Line E20 | SD.MH-E20 | SD.MH-E20/1 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 27
 | Line E | SD.MH-E | SD.MH-1E | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 68
 | Line E | SD.MH-1E | SD.MH-2E | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 68
 | Line E | SD.MH-2E | SD.MH-3E | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 68
 | Line E | SD.MH-3E | SD.MH-4E | 1400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 82
 | Line E | SD.MH-4E | SD.MH-5E | 1600 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 82
 | Line E | SD.MH-5E | SD.MH-6E | 1600 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 82
 | Line E | SD.MH-7E | SD.MH-8E | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 86
 | Line E | SD.MH-8E | SD.MH-9E | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 86
 | Line E | SD.MH-9E | SD.MH-10E | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Length |  | 135 | 125