{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Notes","Drainage Schedule","Lists"],"not_rendered":{"images":7,"external_links":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Notes","index":0,"n_rows":24,"n_cols":1,"rows_kept":24}
["Northern Ireland Water - Drainage Schedule Template"]
["GNSS Data Capture"]
["1. Where Global Navigation Satellite System (GNSS) technology is used for data capture (e.g. Global Positioning System (GPS)), the absolute horizontal accuracy must be sub-500mm with a vertical accuracy (e.g. manhole cover or invert levels) tolerance of +/- 50mm at one standard deviation maximum error. "]
["2. The data must be transformed and presented in the Code of Practice templates provided by NI Water."]
["3. All height related data e.g. cover levels and inverts must be related to the Ordnance Survey Northern Ireland datum (Belfast). Height data based on an arbitrary benchmark or datum will not be accepted."]
["4. All coordinates must be in the Irish Grid Projection."]
[]
["Data Validation"]
["If the Cover Level is lower than the Invert Level, both values will be highlighted in red. This condition will also cause the Depth value to appear in red, as it will be negative.\nNote: Depth is automatically calculated based on the Cover Level and Invert Level values provided."]
[]
[]
["Example 1: Drainage Schedule"]
{"$rows_empty":11}
["Example 2: Backdrop Manholes"]

{"sheet":"Drainage Schedule","index":1,"n_rows":12,"n_cols":22,"rows_kept":12,"merged":[[1,0,1,2],[1,3,1,10],[2,0,2,2],[2,3,2,10],[3,0,3,2],[3,3,3,10]]}
["Northern Ireland Water - Drainage Schedule Template"]
["Developer Services Reference"]
["Site Location"]
["Year Laid"]
["Please Note:"]
["1. If there is more that 1 pipe in parallel please add (xN) after the Pipe Diameter where N is the number of pipes"]
["2. If the storm includes a Geocellular structure please provide the length (L) x width (W) x height (H) in metres in Geocellular Dimension and the product details in the Comments field, inclusive of product name and flow rate."]
["3. All cover and invert levels must be to Ordnance Datum (Belfast)."]
["4. If a storm manhole incorporates a flow control please provide the details in the Comments field, inclusive of product name, head,design flow rate and overflow level if one is present."]
["5. If a manhole incorporates a backdrop please indicate as Yes in Backdrop (Y/N) and add the Backdrop Depth and Backdrop Invert details for that manhole."]
["Manhole Details Schedule"]
["Drainage Type","Manhole Reference","Co-ordinate\nX\n(Irish Grid)","Co-ordinate\nY\n(Irish Grid)","Cover Level\n(M)","Depth\n(M)","Invert Level (M)","Downstream Manhole Reference","Pipe Run Length\n(M)","Gradient (1:XXX)","Downstream Pipe Diameter (MM)","Downstream Box Culvert Dimension\n(MM x MM)","Geocellular Dimension\n(M x M x M)","Downstream Pipe\nMaterial","Manhole Diameter (MM)","Manhole Contruction","Cover Dimension 1 (MM)","Cover Dimension 2 (MM)","Cover Shape","Cover Classification","Backdrop @ Downstream MH (Y/N)","Comments"]

{"sheet":"Lists","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"hidden":true}
[]
[]
[]
[]
[null,"Shape","Duty","Material","Type","Bdrop","MH Dia","Manhole Type"]
[null,"Double Triangular","D400","Concrete","Foul","Y",null,"Pre-Cast"]
[null,"Rectangular","B125","PVC","Storm","N",null,"Brick"]
[null,"Square",null,"Reinf. Conc","Combined",null,null,"In-Situ"]
[null,"Circular",null,"Cast Iron","Pumping Main",null,null,"PVC"]
[{"$nulls":3},"Clay","Emergency Overflow",null,null,"Segmental"]
[{"$nulls":3},"Ductile Iron","Final Effluent Pipe"]
[{"$nulls":3},"HDPE"]
[{"$nulls":3},"Geocellular Structure"]