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

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 A | SD.MH-A3 | SD.MH-A4 | 700 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 85.5
ELC/EXT/STM/65 | "       " | SD.MH-A4 | SD.MH-A5 | 700 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 83 | 80.5 | 83
ELC/EXT/STM/70 | "       " | SD.MH-A5 | SD.MH-A6 | 700 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 96 | 92.5 | 96 | 95
ELC/EXT/STM/71 | "       " | SD.MH-A6 | SD.MH-A7 | 600 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 100 | 95 | 100
ELC/EXT/STM/79 | "       " | SD.MH-A7 | SD.MH-A8 | 600 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 100 | 95 | 100 |  | 17.5 | 20 | 56 | 67.5 | 87.5 | 86.5 | 87.5 | 95 | 92.5 | 95
 | "       " | SD.MH-A8 | SD.MH-A9 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 93.5 |  |  |  |  |  |  |  |  |  | 705
 | "       " | SD.MH-A9 | SD.MH-A10 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 106
 | "       " | SD.MH-A10 | SD.MH-A11 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 100
 | "       " | SD.MH-A11 | SD.MH-A12 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 100
 | "       " | SD.MH-A3 | SD.MH-A2 | 700 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 111.5
 | "       " | SD.MH-A2 | SD.MH-A1 | 800 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 100
 | "       " | SD.MH-A1 | SD.MH-A | 800 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 60.5
 | "       " | SD.MH-A | SD.MH-1A | 1400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 84.5
 | "       " | SD.MH-1A | SD.MH-2A | 1400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 84.5
 | "       " | SD.MH-2A | SD.MH-3A | 1800 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 95
 | "       " | SD.MH-3A | SD.MH-4A | 1800 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 95
 | "       " | SD.MH-4A | SD.MH-5A | 1800 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 96
 | "       " | SD.MH-5A | SD.MH-6A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-6A | SD.MH-7A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-7A | SD.MH-8A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-8A | SD.MH-9A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-9A | SD.MH-10A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-10A | SD.MH-11A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-11A | SD.MH-12A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-12A | SD.MH-13A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-13A | SD.MH-14A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-14A | SD.MH-15A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-15A | SD.MH-16A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-16A | SD.MH-17A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-17A | SD.MH-18A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 | "       " | SD.MH-18A | SD.MH-19A | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Length |  | 379 | 363
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 710.5