{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Main","Data","Minor K","Minor Results","Major K","Major Results","Summary Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":69,"n_cols":15,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
["DRAINS Design Output Converter for Results from Various Hydrological Models"]
[]
[]
["Updated by Watercom ",null,"December 2022"]
[null,"Increased Detention Basin Limit from 20 to 100"]
[null,"Corrected missing US & DS Pipe HGL Data"]
[null,"Corrected AEP reporting for IL-CL model"]
[]
["Geoffrey O'Loughlin",null,"September 2019"]
[]
["INTRODUCTION"]
[]
["This spreadsheet processes DRAINS spreadsheet outputs from major/minor calculations using ILSAX, rational method, extended rational method (ERM) and ARR 2016 initial loss - continuing loss (IL-CL) calculations."]
["It converts these to formats suitable for checking and for presentation as a table in a CAD drawing.  Allowance is made for pipes, pits, detention basins and headwalls, but not for most nodes, open channels or storage routing reaches."]
[]
["Minor storm results, major storm results or both can be presented  The procedure allows for the optional output of details of the revision of"]
["pit pressure loss coefficients (K values) using the QUDM (Queensland Urban Drainage Manual) charts. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["The method works by copying  spreadsheets exported from DRAINS into two or more of the worksheets with the yellow tags shown below:"]
[]
[null,"Data",null,"Minor K",null,"Minor Results",null,"Major K",null,"Major Results"]
[]
["and running a macro to rearrange and place this data into the worksheet tagged ",null,null,null,null,null,null,"  Summary Sheet"]
[]
["The copied data must be entered into Cell A1 in each of these worksheets.  If the entry point is elsewhere, the macros will not function properly."]
[]
["INSTRUCTIONS"]
[]
["It is assumed that you have set up a system for design using DRAINS, employing ILSAX, rational method, extended rational method (ERM) or initial loss - continuing loss (IL-CL) hydrology."]
["This sheet does not work with storage routing models."]
[]
["To output minor/major results with pressure loss information, the following steps can then be applied:"]
[]
["1.  First run the model in DRAINS to perform a design.  Then run an analysis with minor storms if minor results are required.  Otherwise go to Step 8 and run with major storms.  "]
["     The standard or premium hydraulic models can be used in analyses."]
[]
["2.  From the Run Menu, select Revise Pit Loss Coefficients → Using QUDM Charts and follow the procedure to alter the K coefficients.  This puts a table onto the Clipboard."]
["3.  Repeat  Steps 1 and 2 until K values converge and you are satisfied with the design pit and pipe sizes. "]
["4.  Open this Converter spreadsheet, and save it with another name.  If necessary, clear the input worksheets with yellow labels by pressing this 'Clear' button."]
["5.  Enter the last Clipboard output from the QUDM Charts procedure into the worksheet labelled 'Minor K'. (DRAINS automatically saves this information when the QUDM Charts procedure is applied.)"]
["6.  Return to DRAINS and select Edit → Copy data to Spreadsheet.  Then go to this spreadsheet and paste the data into the worksheet labelled 'Data'."]
["7.  Returning to DRAINS, run minor storms and select Edit → Copy Results to Spreadsheet\".  In this spreadsheet, paste the results into the worksheet named 'Minor Results'."]
["8.  In the DRAINS model, run the major storms, altering pressure change coefficients using the QUDM procedure, as described in Steps 1 and 2.  Do not alter pit and pipe sizes."]
["9.  Assuming the major flow results are satisfactory, transfer the K value information on the Clipboard to the worksheet labelled 'Major K'."]
["10.  Return to DRAINS and run major storms.  Select Edit → Copy Results to Spreadsheet.  In this spreadsheet paste the results into the worksheet named 'Major Results'."]
["11.  Click the 'Run' button to transfer information to the 'Summary Sheet' worksheet."]
["        If the run fails to produce a summary sheet and appear to be looping, hit the Esc button and check the inputs."]
[]
["NOTES"]
[]
["If only minor results are required or only major results, then the other set of results should not be entered."]
["The QUDM procedure for calculating K values can be omitted, leaving the 'Minor K' and 'Major K' worksheets blank.  In this case, do not carry out Steps 2, 3, 5, the QUDM part of Steps 8 and 9."]
[]
["Nodes receiving flows from sub-catchments are included.  Flowrates from these sub-catchments are displayed in approaching overflow routes if the '% of downstream catchment flow' is set at 100% in DRAINS."]
["It is recommended that naming systems distinguish between pits, nodes and basins, and use similar names for pits and the pipes, sub-catchments and overflow routes connected to these."]
["Numerical entries in the yellow-labelled worksheets have green triangles in their cells because these cells are in text format.  The procedure is not affected by this."]
[]
["You may not want all the imformation provided.  The output worksheet can be edited to delete columns or rows.  "]
["If the Summary Sheet is to be placed on a drawing, the required cells should be enclosed with solid borders and then copied to the Clipboard."]
["The table can then be copied into a CAD program  For example, in AutoCAD you can choose Paste Special from the Edit menu and select 'AutoCAD Entities'."]
[]
["The macros in this program are unprotected, and can be reviewed and changed by selecting View → Macros → (Select a macro) → Edit."]
["For further information, contact Geoffrey O'Loughlin at geoff.oloughlin@gmail.com.  If you have problems, send your file with the e-mail."]
[]
["DISCLAIMER"]
[]
["This spreadsheet is supplied on the basis that users will check the appropriateness and accuracy of results."]
["No responsibility is taken for any damages or loss that may occur through use of this spreadsheet."]

{"sheet":"Data","index":1,"n_rows":237,"n_cols":115,"rows_kept":237,"cut":false,"hidden":false,"merged":[]}
["PIT / NODE DETAILS",null,null,"Version 15"]
["Name","Type","Family","Size","Ponding","Pressure","Surface","Max Pond","Base","Blocking","x","y","Bolt-down","id","Part Full","Inflow","Pit is","Internal","Inflow is","Minor Safe","Major Safe"]
[null,null,null,null,"Volume","Change","Elev (m)","Depth (m)","Inflow","Factor",null,null,"lid",null,"Shock Loss","Hydrograph",null,"Width","Misaligned","Pond Depth","Pond Depth"]
[null,null,null,null,"(cu.m)","Coeff. Ku",null,null,"(cu.m/s)",null,null,null,null,null,null,null,null,"(mm)",null,"(m)","(m)"]
["PitE1","Sag","NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 3.6 m lintel","1","5.9","19.3","0.15","0","0.5","300777.607","6232704.294","No","1","1 x Ku","No","New",null,"No","0.15","0.20"]
["PitE2","OnGrade","NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 1.68 m lintel",null,"1.2","19.1",null,"0","0","300771.411","6232698.750","No","6","1 x Ku","No","New",null,"No"]
["PitE3","OnGrade","NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 1.68 m lintel",null,"0.8","19.0",null,"0","0","300761.815","6232698.815","No","2","1 x Ku","No","New",null,"No"]
["PitE4","Sag","NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 3.6 m lintel","2","2.0","15.9","0.15","0","0.5","300706.569","6232649.729","No","4","1 x Ku","No","New",null,null,"0.15","0.20"]
["PitE5","OnGrade","NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 1.68 m lintel",null,"1.2","15.7",null,"0","0","300699.354","6232654.020","No","3","1 x Ku","No","New",null,"No"]
["Out2","Node",null,null,null,null,"14.90",null,"0",null,"300674.190","6232651.374",null,"34",null,"No"]
["PitF1","OnGrade","NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 3.6 m lintel",null,"5.3","16.06",null,"0","0","300706.232","6232637.336","No","5","1 x Ku","No","New",null,"No"]
["Out1","Node",null,null,null,null,"14.90",null,"0",null,"300682.475","6232659.547",null,"35",null,"No"]
[]
["DETENTION BASIN DETAILS"]
["Name","Elev","Surf. Area","Not Used","Outlet Type","  K  ","Dia(mm)","Centre RL","Pit Family","Pit Type","x","y","HED","Crest RL","Crest Length(m)","id"]
[]
["SUB-CATCHMENT DETAILS"]
["Name","Pit or","Total","EIA","Perv","RIA","EIA","Perv","RIA","EIA","Perv","RIA","EIA","Perv","RIA","EIA","Perv","RIA","Rainfall"]
[null,"Node","Area",null,"Area",null,"Time","Time","Time","Length","Length","Length","Slope(%)","Slope","Slope","Rough","Rough","Rough","Multiplier"]
[null,null,"(ha)","%","%","%","(min)","(min)","(min)","(m)","(m)","(m)","%","%","%"]
["CatE1","PitE1","0.5700","32.0","60.0","8.0","6","20","5",null,null,null,null,null,null,null,null,null,"01"]
["CatE2","PitE2","0.0510","72.0","20.0","8.0","5","6","1",null,null,null,null,null,null,null,null,null,"01"]
["CatE3","PitE3","0.0120","80.0","20.0","0.0","5","5","0",null,null,null,null,null,null,null,null,null,"01"]
["CatE4","PitE4","0.3190","48.0","40.0","12.0","6","10","3",null,null,null,null,null,null,null,null,null,"01"]
["CatE5","PitE5","0.1910","56.0","30.0","14.0","5","8","2",null,null,null,null,null,null,null,null,null,"01"]
["CatF1","PitF1","0.9140","40.0","50.0","10.0","6","21","5",null,null,null,null,null,null,null,null,null,"01"]
[]
["PIPE DETAILS"]
["Name","From","To","Length","U/S IL","D/S IL","Slope","Type","Dia","I.D.","Rough","Pipe Is","No. Pipes","Chg From","At Chg","Chg","Rl","Chg","RL","etc"]
[null,null,null,"(m)","(m)","(m)","(%)",null,"(mm)","(mm)",null,null,null,null,null,"(m)","(m)","(m)","(m)","(m)"]
["PipeE1","PitE1","PitE2","8.314","18.208","18.008","2.41","Concrete, under roads, 1% minimum slope","450","450","0.013","New","1","PitE1","0"]
["PipeE2","PitE2","PitE3","9.613","17.978","17.882","1.00","Concrete, under roads, 1% minimum slope","450","450","0.013","New","1","PitE2","0"]
["PipeE3","PitE3","PitE4","73.9","17.844","14.808","4.11","Concrete, under roads, 1% minimum slope","450","450","0.013","New","1","PitE3","0"]
["PipeE4","PitE4","PitE5","8.394","14.536","14.290","2.93","Concrete, under roads, 1% minimum slope","675","675","0.013","New","1","PitE4","0"]
["PipeE5","PitE5","Out2","25.607","14.218","13.569","2.53","Concrete, under roads, 1% minimum slope","675","675","0.013","New","1","PitE5","0"]
["PipeF1","PitF1","PitE4","12.397","14.908","14.784","1.00","Concrete, under roads, 1% minimum slope","450","450","0.013","New","1","PitF1","0"]
[]
["DETAILS of SERVICES CROSSING PIPES"]
["Pipe","Chg"," Bottom","Height of Service","Chg"," Bottom","Height of Service","Chg"," Bottom","Height of Service","etc"]
[null,"(m)","Elev (m)","        (m)","(m)","Elev (m)","        (m)","(m)","Elev (m)","        (m)","etc"]
[]
["CHANNEL DETAILS"]
["Name","From","To","Type","Length","U/S IL","D/S IL","Slope","Base Width","L.B. Slope","R.B. Slope","Manning","Depth","Roofed"]
[null,null,null,null,"(m)","(m)","(m)","(%)","(m)","(1:?)","(1:?)","n","(m)"]
[]
["OVERFLOW ROUTE DETAILS"]
["Name","From","To","Travel","Spill","Crest","Weir","Cross","Safe Depth","SafeDepth","Safe","Bed","D/S Area",null,"id","U/S IL","D/S IL","Length (m)"]
[null,null,null,"Time","Level","Length","Coeff. C","Section","Major Storms","Minor Storms","DxV","Slope","Contributing"]
[null,null,null,"(min)","(m)","(m)",null,null,"(m)","(m)","(sq.m/sec)","(%)","%"]
["OFE1","PitE1","PitE2","0.1",null,null,null,"Overflow across road low point - parabola x = 15, y = 0.3","0.05","0","0.6","4.12","0",null,"67","19.45","19.1","8.5"]
["OFE2","PitE2","PitE3","0.1",null,null,null,"7.5 m roadway with 3% crossfall and barrier kerb","0.3","0.15","0.4","0.93","100",null,"70","19.1","19","10.7"]
["OFE3","PitE3","PitE4","0.5",null,null,null,"7.5 m roadway with 3% crossfall and barrier kerb","0.3","0.15","0.4","4.21","85",null,"72","19","15.9","73.7"]
["OFE4","PitE4","PitE5","0.1",null,null,null,"Overflow across road low point - parabola x = 15, y = 0.3","0.05","0","0.6","4.27","0",null,"76","16.05","15.7","8.2"]
["OFE5","PitE5","Out1","0.1",null,null,null,"7.5 m roadway with 3% crossfall and barrier kerb","0.3","0.15","0.4","4.00","0",null,"80","15.7","14.9","20"]
["OFF1","PitF1","PitE4","0.2",null,null,null,"7.5 m roadway with 3% crossfall and barrier kerb","0.3","0.15","0.4","0.69","15",null,"74","16.06","15.9","14.5"]
[]
[]
["PIPE COVER DETAILS"]
["Name","Type","Dia (mm)","Safe Cover (m)","Cover (m)"]
["PipeE1","Concrete, under roads, 1% minimum slope","450","0.6","0.60"]
["PipeE2","Concrete, under roads, 1% minimum slope","450","0.6","0.63"]
["PipeE3","Concrete, under roads, 1% minimum slope","450","0.6","0.60"]
["PipeE4","Concrete, under roads, 1% minimum slope","675","0.6","0.63"]
["PipeE5","Concrete, under roads, 1% minimum slope","675","0.6","0.60"]
["PipeF1","Concrete, under roads, 1% minimum slope","450","0.6","0.62"]
[]
[]
["This model has no pipes with non-return valves"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.186,7.9020000000000001,11.182,8.0259999999999998,11.175000000000001,8.0269999999999992,11.175000000000001,8.0280000000000005,11.175000000000001,8.0289999999999999,11.175000000000001,8.0299999999999994,11.175000000000001,8.1240000000000006,11.17,8.1739999999999995,11.167999999999999,8.2910000000000004,11.162000000000001,9.0310000000000006,11.124000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.3550000000000004,70.481999999999999,8.2530000000000001,70.932000000000002,8.2100000000000009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.76,62.466000000000001,6.7510000000000003,63.741999999999997,6.7290000000000001,66.783000000000001,6.6779999999999999,68.369,6.6539999999999999,69.456000000000003,6.6369999999999996,70.206000000000003,6.577]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.42,8.14,13.42,8.141,13.42,8.1419999999999995,13.42,8.1430000000000007,13.42,8.9540000000000006,13.395]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.817,30.984000000000002,10.797000000000001,31.161000000000001,10.76,31.608000000000001,10.669,31.751000000000001,10.632999999999999,31.792000000000002,10.622999999999999,31.818999999999999,10.622]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.452,23.751000000000001,8.4469999999999992,24.503,8.4369999999999994,24.562999999999999,8.4359999999999999,25.379000000000001,8.4260000000000002,25.395,8.4260000000000002,25.396000000000001,8.4260000000000002,25.396999999999998,8.4260000000000002,25.654,8.4239999999999995,25.771999999999998,8.423,25.866,8.423,25.949000000000002,8.4079999999999995,26.253,8.3510000000000009,26.398,8.3219999999999992]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.709,5.8360000000000003,13.693,6.2670000000000003,13.643000000000001,6.452,13.587999999999999,6.6150000000000002,13.573,6.6749999999999998,13.558,6.7880000000000003,13.534000000000001,7.1580000000000004,13.505000000000001,7.8849999999999998,13.461,8.02,13.442,8.0210000000000008,13.442,8.0220000000000002,13.442,8.0340000000000007,13.442,8.0679999999999996,13.44,8.0690000000000008,13.44,8.07,13.44,8.3109999999999999,13.429,8.8160000000000007,13.406000000000001]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4269999999999996,37.716999999999999,9.4139999999999997,40.948999999999998,9.3339999999999996,40.991999999999997,9.3339999999999996,41.018999999999998,9.3339999999999996,41.131,9.2720000000000002,41.198999999999998,9.234]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.411000000000001]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.3510000000000009,35.027000000000001,8.3369999999999997,36.973999999999997,8.2539999999999996,37.058999999999997,8.25,39.005000000000003,8.1669999999999998,39.031999999999996,8.1649999999999991,40.978999999999999,8.0820000000000007,41.003999999999998,8.0809999999999995,41.024000000000001,8.0790000000000006,42.970999999999997,7.9960000000000004,44.917000000000002,7.9130000000000003,45.05,7.9050000000000002,45.051000000000002,7.9050000000000002,45.5,7.8860000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.946]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.6]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.785,23.657,13.755000000000001,24.623000000000001,13.73,24.84,13.747999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.359,38.655000000000001,13.358000000000001,38.880000000000003,13.356999999999999,38.89,13.356999999999999,39.231000000000002,13.356]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.441000000000001,12.012,13.44,12.467000000000001,13.44,12.551,13.439,13.223000000000001,13.436999999999999,13.898,13.430999999999999,13.98,13.43,13.984,13.43,14.013999999999999,13.43,14.632,13.414,14.693,13.411,14.694000000000001,13.411,14.695,13.411,14.696,13.411,14.696999999999999,13.411,15.323,13.395]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.8,12.712999999999999,15.624000000000001,13.048,15.624000000000001,13.048999999999999,15.45,14.849,15.397,14.85,15.222,15.185,15.222,15.186,15.047000000000001,15.521000000000001,15.047000000000001,15.522,14.872,17.321999999999999,14.819000000000001,17.323,14.644,17.658000000000001,14.644,17.658999999999999,14.468999999999999,17.995000000000001,14.468999999999999,17.995999999999999,14.304,24.29,14.122999999999999,27.082000000000001,14.051]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.837999999999999,36.668999999999997,15.795,38.523000000000003,15.589,40.377000000000002,15.382,42.231000000000002,15.176,44.085999999999999,14.97,45.783999999999999,14.632999999999999,46.728000000000002,14.528,46.832000000000001,14.516999999999999,47.372,14.29,47.545000000000002,14.284000000000001,47.692,14.257,47.694000000000003,14.215999999999999,47.749000000000002,14.202999999999999]

{"sheet":"Minor K","index":2,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Pit","Initial K","Revised K","Chart (2008)","Ratios"]
["PitE2","1.22","1.22","A1-9","Du/Do=1.00, Qg/Qo=0.17, S/Do=1.1"]
["PitF1","5.28","5.28","A1-4","H/Do=0.0, Vo2/(2gDo)=0.16"]
["PitE4","2.05","2.05","H-O'L","Qg/Qo=0.27, S/Do=1.2"]
["PitE5","1.21","1.21","A1-9","Du/Do=1.00, Qg/Qo=0.17, S/Do=1.1"]
["PitE3","0.82","0.82","A1-9","Du/Do=1.00, Qg/Qo=0.04, S/Do=1.1"]
["PitE1","5.93","5.93","A1-4","H/Do=0.0, Vo2/(2gDo)=0.06"]

{"sheet":"Minor Results","index":3,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["DRAINS results prepared from Version 2022.09.8305.15911"]
[]
["PIT / NODE DETAILS",null,null,null,"Version 8"]
["Name","Max HGL","Max Pond","Max Surface","Max Pond","Min","Overflow","Constraint"]
[null,null,"HGL","Flow Arriving","Volume","Freeboard","(cu.m/s)"]
[null,null,null,"(cu.m/s)","(cu.m)","(m)"]
["PitE1","18.53","19.43","0.143","0.8","0.77","0.000","Inlet Capacity"]
["PitE2","18.24",null,"0.024",null,"0.86","0.000","None"]
["PitE3","18.08",null,"0.003",null,"0.92","0.000","None"]
["PitE4","14.98","16.01","0.058","1.2","0.92","0.000","Inlet Capacity"]
["PitE5","14.68",null,"0.081",null,"1.02","0.004","Inlet Capacity"]
["Out2","13.84",null,"0.000"]
["PitF1","15.49",null,"0.246",null,"0.57","0.000","None"]
[]
["SUB-CATCHMENT DETAILS"]
["Name","Max","EIA","Remaining","EIA","RIA","PA","Due to Storm"]
[null,"Flow Q","Max Q","Max Q","Tc","Tc","Tc"]
[null,"(cu.m/s)","(cu.m/s)","(cu.m/s)","(cu.m/s)","(min)","(min)","(min)"]
["CatE1","0.114","0.044","0.076","6.00","5.00","20.00","20% AEP, 45 min burst, Storm 9"]
["CatE2","0.017","0.016","0.001","5.00","1.00","6.00","20% AEP, 5 min burst, Storm 1"]
["CatE3","0.004","0.004","0.000","5.00","0.00","5.00","20% AEP, 5 min burst, Storm 1"]
["CatE4","0.086","0.045","0.045","6.00","3.00","10.00","20% AEP, 45 min burst, Storm 10"]
["CatE5","0.056","0.038","0.020","5.00","2.00","8.00","20% AEP, 10 min burst, Storm 8"]
["CatF1","0.189","0.119","0.105","6.00","5.00","21.00","20% AEP, 30 min burst, Storm 5"]
[]
[]
["PIPE DETAILS"]
["Name","Max Q","Max V","Max U/S","Max D/S","Due to Storm"]
[null,"(cu.m/s)","(m/s)","HGL (m)","HGL (m)"]
["PipeE1","0.114","1.36","18.443","18.244","20% AEP, 45 min burst, Storm 9"]
["PipeE2","0.126","1.74","18.225","18.091","20% AEP, 30 min burst, Storm 5"]
["PipeE3","0.128","2.30","18.082","14.980","20% AEP, 30 min burst, Storm 5"]
["PipeE4","0.401","1.90","14.935","14.676","20% AEP, 30 min burst, Storm 9"]
["PipeE5","0.451","3.35","14.641","13.840","20% AEP, 30 min burst, Storm 9"]
["PipeF1","0.188","1.94","15.211","15.048","20% AEP, 30 min burst, Storm 5"]
[]
["CHANNEL DETAILS"]
["Name","Max Q","Max V",null,null,"Due to Storm"]
[null,"(cu.m/s)","(m/s)"]
[]
["OVERFLOW ROUTE DETAILS"]
["Name","Max Q U/S","Max Q D/S","Safe Q","Max D","Max DxV","Max Width","Max V","Due to Storm"]
["OFE1","0","0","0.000","0","0","0","0"]
["OFE2","0.000","0.004","0.296","0.038","0.02","0.44","0.53","20% AEP, 20 min burst, Storm 2"]
["OFE3","0.000","0.073","0.630","0.074","0.08","1.59","1.11","20% AEP, 45 min burst, Storm 10"]
["OFE4","0","0","0.000","0","0","0","0"]
["OFE5","0.004","0.004","0.614","0.019","0.04","0.22","2.01","20% AEP, 15 min burst, Storm 5"]
["OFF1","0.000","0.013","0.255","0.000","0.00","0.00","0.00","20% AEP, 45 min burst, Storm 10"]
[]
[]
["DETENTION BASIN DETAILS"]
["Name","Max WL","MaxVol","Max Q","Max Q","Max Q"]
[null,null,null,"Total","Low Level","High Level"]
[]
["Run Log for Taree 9 - COMPLETED MODEL"]
["{\\colortbl;\\red0\\green0\\blue0;\\red192\\green0\\blue0;}Run Log for Taree 9 - COMPLETED MODEL.drn - DRAINS run at 22:28:24 on 12/12/2022 using Watercom Drains v2022.09.8305.15911"]
[]
["No water upwelling from any pit. Freeboard was adequate at all pits."]
[]
["The maximum flow in these overflow routes is unsafe: OFE4"]

{"sheet":"Major K","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Pit","Initial K","Revised K","Chart (2008)","Ratios"]
["PitE2","1.79","1.8","A1-9","Du/Do=1.00, Qg/Qo=0.37, S/Do=1.6"]
["PitF1","3.56","3.15","A1-4","H/Do=0.8, Vo2/(2gDo)=0.39"]
["PitE4","2.71","2.71","H-O'L","Qg/Qo=0.49, S/Do=2.0"]
["PitE5","1.58","1.6","A1-9","Du/Do=1.00, Qg/Qo=0.32, S/Do=1.7"]
["PitE3","1.17","1.17","A1-9","Du/Do=1.00, Qg/Qo=0.15, S/Do=1.4"]
["PitE1","4.86","4.86","A1-4","H/Do=0.0, Vo2/(2gDo)=0.20"]

{"sheet":"Major Results","index":5,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["DRAINS results prepared from Version 2022.09.8305.15911"]
[]
["PIT / NODE DETAILS",null,null,null,"Version 8"]
["Name","Max HGL","Max Pond","Max Surface","Max Pond","Min","Overflow","Constraint"]
[null,null,"HGL","Flow Arriving","Volume","Freeboard","(cu.m/s)"]
[null,null,null,"(cu.m/s)","(cu.m)","(m)"]
["PitE1","19.08","19.49","0.307","0.9","0.22","0.032","Inlet Capacity"]
["PitE2","18.60",null,"0.125",null,"0.50","0.006","Inlet Capacity"]
["PitE3","18.26",null,"0.044",null,"0.74","0.000","None"]
["PitE4","15.63","16.11","0.436","1.7","0.27","0.077","Inlet Capacity"]
["PitE5","14.90",null,"0.363",null,"0.80","0.063","Inlet Capacity"]
["Out2","13.97",null,"0.000"]
["PitF1","16.15",null,"0.516",null,"0.00","0.211","Outlet System"]
[]
["SUB-CATCHMENT DETAILS"]
["Name","Max","EIA","Remaining","EIA","RIA","PA","Due to Storm"]
[null,"Flow Q","Max Q","Max Q","Tc","Tc","Tc"]
[null,"(cu.m/s)","(cu.m/s)","(cu.m/s)","(cu.m/s)","(min)","(min)","(min)"]
["CatE1","0.246","0.105","0.156","6.00","5.00","20.00","1% AEP, 20 min burst, Storm 10"]
["CatE2","0.038","0.031","0.007","5.00","1.00","6.00","1% AEP, 5 min burst, Storm 1"]
["CatE3","0.009","0.008","0.001","5.00","0.00","5.00","1% AEP, 5 min burst, Storm 1"]
["CatE4","0.185","0.100","0.088","6.00","3.00","10.00","1% AEP, 10 min burst, Storm 7"]
["CatE5","0.125","0.070","0.054","5.00","2.00","8.00","1% AEP, 10 min burst, Storm 7"]
["CatF1","0.398","0.252","0.211","6.00","5.00","21.00","1% AEP, 20 min burst, Storm 3"]
[]
[]
["PIPE DETAILS"]
["Name","Max Q","Max V","Max U/S","Max D/S","Due to Storm"]
[null,"(cu.m/s)","(m/s)","HGL (m)","HGL (m)"]
["PipeE1","0.213","1.35","18.643","18.597","1% AEP, 20 min burst, Storm 8"]
["PipeE2","0.266","1.93","18.343","18.260","1% AEP, 20 min burst, Storm 10"]
["PipeE3","0.278","1.99","18.214","15.633","1% AEP, 20 min burst, Storm 2"]
["PipeE4","0.779","2.46","15.094","14.900","1% AEP, 20 min burst, Storm 8"]
["PipeE5","0.893","4.00","14.798","13.973","1% AEP, 20 min burst, Storm 8"]
["PipeF1","0.295","1.85","15.733","15.633","1% AEP, 25 min burst, Storm 5"]
[]
["CHANNEL DETAILS"]
["Name","Max Q","Max V",null,null,"Due to Storm"]
[null,"(cu.m/s)","(m/s)"]
[]
["OVERFLOW ROUTE DETAILS"]
["Name","Max Q U/S","Max Q D/S","Safe Q","Max D","Max DxV","Max Width","Max V","Due to Storm"]
["OFE1","0.032","0.032","0.585","0.038","0.01","10.51","0.60","1% AEP, 20 min burst, Storm 8"]
["OFE2","0.006","0.013","1.232","0.058","0.04","1.07","0.70","1% AEP, 20 min burst, Storm 3"]
["OFE3","0.000","0.155","0.773","0.093","0.12","2.24","1.26","1% AEP, 10 min burst, Storm 7"]
["OFE4","0.077","0.077","0.595","0.074","0.02","14.03","0.80","1% AEP, 20 min burst, Storm 8"]
["OFE5","0.063","0.063","0.790","0.072","0.13","1.53","1.96","1% AEP, 25 min burst, Storm 3"]
["OFF1","0.211","0.240","1.338","0.164","0.15","4.70","1.13","1% AEP, 20 min burst, Storm 5"]
[]
[]
["DETENTION BASIN DETAILS"]
["Name","Max WL","MaxVol","Max Q","Max Q","Max Q"]
[null,null,null,"Total","Low Level","High Level"]
[]
["Run Log for Taree 9 - COMPLETED MODEL"]
["{\\colortbl;\\red0\\green0\\blue0;\\red192\\green0\\blue0;}Run Log for Taree 9 - COMPLETED MODEL.drn - DRAINS run at 22:29:20 on 12/12/2022 using Watercom Drains v2022.09.8305.15911"]
[]
["No water upwelling from any pit."]
["Freeboard was less than 0.15m at PitF1"]
["The maximum pond depth in these sag pits is unsafe: PitE4"]
["The maximum flow in these overflow routes is unsafe: OFE4"]

{"sheet":"Summary Sheet","index":6,"n_rows":108,"n_cols":36,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[]
["INITIAL LOSS - CONTINUING LOSS METHOD CALCULATION SUMMARY SHEET"]
[]
["DRAINS results prepared from Version 2022.09.8305.15911"]
[null,null,null,null,null,null,null,null,"Entire Catchment Area"]
[null,null,"EIA","RIA","PA",null,null,"EIA ","0.854 ha","(41.5%}"]
["Initial Losses:",null,null,"User to enter",null,null,null,"RIA ","0.206 ha","(10%}"]
[null,null,null,null,null,null,null,"PA ","0.996 ha","(48.4%}"]
["Continuing Losses:",null,null,"User to enter",null,null,null,"Total Area ","2.057 ha"]
[]
["LOCATION AND LAND-USE",null,null,null,null,"TIME AND RUNOFF",null,null,null,null,null,"INLET DESIGN",null,null,null,null,null,null,null,"PIPE SYSTEM DESIGN",null,null,null,null,null,null,null,null,"PIT RESULTS"]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,"29a","29b",30,31,32,33,34]
[null,"Pit, Node","Sub-","Land-",null,"Constant",null,"Kinematic Wave or Friends",null,"Total","Peak Sub-",null,null,"Overflows Approaching Pit",null,null,null,"Peak",null,"Peak",null,null,null,"U/S Pipe","D/S Pipe","U/S","D/S","Pipe","Pressure","QUDM","QUDM","Water","Ground","Pit"]
[null,"or Basin","Catchment","Use","Percent-","Flow",null,"Formula Parameters",null,"Entry","Catchment","Origin of","Peak","Flow","Depth x","Inlet","Inlet","Approach","Bypass","Flow in","Reach","Pipe","Pipe","Invert","Invert","HGL","HGL","Flow","Change","Chart No.","Chart","Surface","Surface","Free-","Pit","Remarks"]
["AEP","Name","Area","Type","age","Time","Length","Slope","Roughness","Time, tc","Flowrate","Approach","Flowrate(s)","Width","Velocity","Family","Size","Flow","Flow(s)","Pipe","Length","Slope","Diameter","Level","Level","in Pipe","in Pipe","Velocity","Coeff.",2008,"Ratios","Elevation","Level","board","Name"]
[null,null,"(ha)","(IL-CL)","(%)","(minutes)","(m)","(%)","n","(minutes)","(m3/s)","Flows","(m3/s)","(m)","(m2/s)",null,null,"(m3/s)","(m3/s)","(m3/s)","(m)","(%)","(mm)","(m)","(m)","(m)","(m)","(m/s)","Ku","[2016]",null,"(m)","(m)","(m)"]
[null,null,null,null,null,null,null,null,null,null,"*worst storm"]
[0.2,"PitE1",0.56999999999999995,"EIA",32,6,null,null,null,6,0.114,null,null,null,null,"NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 3.6 m lintel",0.114,0,0.114,8.3140000000000001,2.41,450,18.207999999999998,18.007999999999999,18.443000000000001,18.244,1.36,5.93,"A1-4 [A2-3]","H/Do=0.0, Vo2/(2gDo)=0.06",18.53,19.3,0.77,"PitE1"]
[null,null,null,"RIA",8,5,null,null,null,5]
[null,null,null,"PA",60,20,null,null,null,0]
[0.01,"PitE1",0.56999999999999995,"EIA",null,null," < - - - - - - - - - - - - - - as above - - - - - - - - - - - - - - >",null,null,6,0.246,null,null,null,null,"    < - - - as above - - - >",null,0.246,3.2000000000000001E-2,0.21299999999999999,null,null,"< - - - - - - - - - - - - - as above - - - - - - - - - - - - - >",null,null,18.643000000000001,18.597000000000001,1.35,4.8600000000000003,"A1-4 [A2-3]","H/Do=0.0, Vo2/(2gDo)=0.20",19.079999999999998,19.3,0.22,"PitE1"]
[null,null,null,"RIA",null,null,null,null,null,5]
[null,null,null,"PA",null,null,null,null,null,0]
[0.2,"PitE2",5.0999999999999997E-2,"EIA",72,5,null,null,null,5,1.7000000000000001E-2,"PitE1",0,0,0,"NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 1.68 m lintel",1.7000000000000001E-2,0,0.126,9.6129999999999995,1,450,17.978000000000002,17.882000000000001,18.225000000000001,18.091000000000001,1.74,1.22,"A1-9 [A2-6 & A2-7]","Du/Do=1.00, Qg/Qo=0.17, S/Do=1.1",18.239999999999998,19.100000000000001,0.86,"PitE2"]
[null,null,null,"RIA",8,1,null,null,null,1]
[null,null,null,"PA",20,6,null,null,null,0]
[0.01,"PitE2",5.0999999999999997E-2,"EIA",null,null," < - - - - - - - - - - - - - - as above - - - - - - - - - - - - - - >",null,null,5,3.7999999999999999E-2,"PitE1",3.2000000000000001E-2,10.51,0.01,"    < - - - as above - - - >",null,7.0000000000000007E-2,6.0000000000000001E-3,0.26600000000000001,null,null,"< - - - - - - - - - - - - - as above - - - - - - - - - - - - - >",null,null,18.343,18.260000000000002,1.93,1.8,"A1-9 [A2-6 & A2-7]","Du/Do=1.00, Qg/Qo=0.37, S/Do=1.6",18.600000000000001,19.100000000000001,0.5,"PitE2"]
[null,null,null,"RIA",null,null,null,null,null,1]
[null,null,null,"PA",null,null,null,null,null,0]
[0.2,"PitE3",1.2E-2,"EIA",80,5,null,null,null,5,4.0000000000000001E-3,"PitE2",4.0000000000000001E-3,0.44,0.02,"NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 1.68 m lintel",4.0000000000000001E-3,0,0.128,73.900000000000006,4.1100000000000003,450,17.844000000000001,14.808,18.082000000000001,14.98,2.2999999999999998,0.82,"A1-9 [A2-6 & A2-7]","Du/Do=1.00, Qg/Qo=0.04, S/Do=1.1",18.079999999999998,19,0.92,"PitE3"]
[null,null,null,"RIA",0,0,null,null,null,0]
[null,null,null,"PA",20,5,null,null,null,0]
[0.01,"PitE3",1.2E-2,"EIA",null,null," < - - - - - - - - - - - - - - as above - - - - - - - - - - - - - - >",null,null,5,8.9999999999999993E-3,"PitE2",1.2999999999999999E-2,1.07,0.04,"    < - - - as above - - - >",null,1.4999999999999999E-2,0,0.27800000000000002,null,null,"< - - - - - - - - - - - - - as above - - - - - - - - - - - - - >",null,null,18.213999999999999,15.632999999999999,1.99,1.17,"A1-9 [A2-6 & A2-7]","Du/Do=1.00, Qg/Qo=0.15, S/Do=1.4",18.260000000000002,19,0.74,"PitE3"]
[null,null,null,"RIA",null,null,null,null,null,0]
[null,null,null,"PA",null,null,null,null,null,0]
[0.2,"PitE4",0.31900000000000001,"EIA",48,6,null,null,null,6,8.5999999999999993E-2,"PitE3",7.2999999999999995E-2,1.59,0.08,"NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 3.6 m lintel",8.5999999999999993E-2,0,0.40100000000000002,8.3940000000000001,2.93,675,14.536,14.29,14.935,14.676,1.9,2.0499999999999998,"H-O'L","Qg/Qo=0.27, S/Do=1.2",14.98,15.9,0.92,"PitE4"]
[null,null,null,"RIA",12,3,null,null,null,3,null,"PitF1"]
[null,null,null,"PA",40,10,null,null,null,0]
[0.01,"PitE4",0.31900000000000001,"EIA",null,null," < - - - - - - - - - - - - - - as above - - - - - - - - - - - - - - >",null,null,6,0.185,"PitE3",0.155,2.2400000000000002,0.12,"    < - - - as above - - - >",null,0.185,7.6999999999999999E-2,0.77900000000000003,null,null,"< - - - - - - - - - - - - - as above - - - - - - - - - - - - - >",null,null,15.093999999999999,14.9,2.46,2.71,"H-O'L","Qg/Qo=0.49, S/Do=2.0",15.63,15.9,0.27,"PitE4"]
[null,null,null,"RIA",null,null,null,null,null,3,null,"PitF1"]
[null,null,null,"PA",null,null,null,null,null,0]
[0.2,"PitE5",0.191,"EIA",56,5,null,null,null,5,5.6000000000000001E-2,"PitE4",0,0,0,"NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 1.68 m lintel",5.6000000000000001E-2,4.0000000000000001E-3,0.45100000000000001,25.606999999999999,2.5299999999999998,675,14.218,13.569000000000001,14.641,13.84,3.35,1.21,"A1-9 [A2-6 & A2-7]","Du/Do=1.00, Qg/Qo=0.17, S/Do=1.1",14.68,15.7,1.02,"PitE5"]
[null,null,null,"RIA",14,2,null,null,null,2]
[null,null,null,"PA",30,8,null,null,null,0]
[0.01,"PitE5",0.191,"EIA",null,null," < - - - - - - - - - - - - - - as above - - - - - - - - - - - - - - >",null,null,5,0.125,"PitE4",7.6999999999999999E-2,14.03,0.02,"    < - - - as above - - - >",null,0.20200000000000001,6.3E-2,0.89300000000000002,null,null,"< - - - - - - - - - - - - - as above - - - - - - - - - - - - - >",null,null,14.798,13.973000000000001,4,1.6,"A1-9 [A2-6 & A2-7]","Du/Do=1.00, Qg/Qo=0.32, S/Do=1.7",14.9,15.7,0.8,"PitE5"]
[null,null,null,"RIA",null,null,null,null,null,2]
[null,null,null,"PA",null,null,null,null,null,0]
[0.2,"PitF1",0.91400000000000003,"EIA",40,6,null,null,null,6,0.189,null,null,null,null,"NSW Dept. of Housing RM10 Inlet, 3% crossfall, all grades","RM10 3.6 m lintel",0.189,0,0.188,12.397,1,450,14.907999999999999,14.784000000000001,15.211,15.048,1.94,5.28,"A1-4 [A2-3]","H/Do=0.0, Vo2/(2gDo)=0.16",15.49,16.059999999999999,0.56999999999999995,"PitF1"]
[null,null,null,"RIA",10,5,null,null,null,5]
[null,null,null,"PA",50,21,null,null,null,0]
[0.01,"PitF1",0.91400000000000003,"EIA",null,null," < - - - - - - - - - - - - - - as above - - - - - - - - - - - - - - >",null,null,6,0.39800000000000002,null,null,null,null,"    < - - - as above - - - >",null,0.39800000000000002,0.21099999999999999,0.29499999999999998,null,null,"< - - - - - - - - - - - - - as above - - - - - - - - - - - - - >",null,null,15.733000000000001,15.632999999999999,1.85,3.15,"A1-4 [A2-3]","H/Do=0.8, Vo2/(2gDo)=0.39",16.149999999999999,16.059999999999999,0,"PitF1"]
[null,null,null,"RIA",null,null,null,null,null,5]
[null,null,null,"PA",null,null,null,null,null,0]
["NOTES"]
[]
["This sheet presents results from a pipe system model using ILSAX, the rational method, extended rational method (ERM), or the ARR 2016 initial loss - "]
["continuing loss (IL-CL) model implemented in the DRAINS program,(www.watercom.com.au) involving considerable calculations with multiple rainfall patterns, and complex"]
["hydraulic computations.  Therefore, unlike older rational method calculation sheets, this sheet does not portray hand calculations."]
["It presents the key model inputs and outputs of interest to reviewers."]
[]
["Depending on inputs, the table may show results for a minor storm, a major storm, or both."]
["There may be multiple rows for up to three overflow routes coming to a pit."]
["You can edit headings or delete columns or rows."]
[]
["The contents of each column are explained below:"]
[]
["Column 1: Design annual exceedance probability (AEP); values for minor storms, major storms or both may be displayed.  Numerical values are not available for the rational method, but users can enter these."]
["Column 2: Pit Name from DRAINS  (The connecting sub-catchment, downstream pipe and overflow route are assumed to have similar names, so they do not need to be entered in the table.)"]
["                      As well as pits, headwalls, detention basins and nodes connected to sub-catchments are included."]
["Column 3: Sub-Catchment Area (ha)"]
["Column 4: Land-Use Type: paved, supplementary and grassed areas (in different rows) for ILSAX, impervious and pervious areas for the rational method and ERM, or effective impervious areas (EIAs),remaining impervious areas (RIAs) and pervious areas (PAs) for the IL-CL model."]
["Column 5: Percentages of paved, supplementary and grassed areas for ILSAX, or impervious and pervious areas for the rational method and ERM, or effective impervious areas (EIAs),remaining impervious areas (RIAs) and pervious areas (PAs) for the IL-CL model."]
["Column 6: Constant flow times for the paved, supplementary and grassed areas (minutes) for ILSAX, or impervious and impervious areas for the rational method and ERM, or effective impervious areas (EIAs),remaining impervious areas (RIAs) and pervious areas (PAs) for the IL-CL model."]
["Column 7: Lengths of paved, supplementary and grassed area flow path segments (m) for ILSAX, or impervious and impervious areas for the rational method and ERM, or effective impervious areas (EIAs),remaining impervious areas (RIAs) and pervious areas (PAs) for the IL-CL model."]
["Column 8: Slopes of paved, supplementary and grassed area flow path segments (%) for ILSAX, or impervious and impervious areas for the rational method and ERM, or effective impervious areas (EIAs),remaining impervious areas (RIAs) and pervious areas (PAs) for the IL-CL model."]
["Column 9: Roughnesses of paved, supplementary and grassed area flow path segments (Manning's values) for ILSAX, or impervious and impervious areas for the rational method and ERM, or effective impervious areas (EIAs),remaining impervious areas (RIAs) and pervious areas (PAs) for the IL-CL model.\""]
["Column 10: Total flow times for the paved, supplementary and grassed areas (minutes) for ILSAX, or impervious and pervious areas for the rational method and ERM, or effective impervious areas (EIAs),remaining impervious areas (RIAs) and pervious areas (PAs) for the IL-CL model."]
["                    For the rational methoid, it is the total catchment time of concentration."]
["Column 11: Peak Sub-Catchment Flowrate (m3/s).  For the rational method, the output indicates whether this is a full catchment or partial area estimate."]
["Column 12: Origin of Overflows, the names of any pits or nodes from which overflows come to the pit."]
["Column 13: Peak Overflows from upstream pits or nodes(m3/s), which may include flows from the sub-catchment through which they flow.  "]
["                    - not outputted for the rational method.)"]
["Column 14: Approach Flow Width (m) - not outputted for the rational method."]
["Column 15: Approach Flow Depth x Velocity (m2/s) - not outputted for the rational method."]
["Column 16: Inlet Family, in the DRAINS classification."]
["Column 17: Inlet Size, in the DRAINS classification."]
["Column 18: Total Approach Flow (m3/s), sum of peaks of local sub-catchment runoff hydrograph plus overflow hydrographs directed to the pit.  "]
["                    (This will probably overestimate the true peak coming from additi0on of hydrographs.)"]
["Column 19: Bypass Flow (m3/s), the overflow occurring because of lack of inlet capacity or overflowing of the pipe system"]
["Column 19a: Baseflow or Direct Inflow Peak (m3/s), if present in the model; otherwise this column does not appear."]
["Column 20: Flow in Pipe (m3/s)."]
["Column 21: Pipe Length (mm)."]
["Column 22: Pipe Slope (%)."]
["Column 23: Pipe Diameter (mm) or Box Dimensions (m)."]
["Column 24: Upstream Pipe Invert Level (m AHD)."]
["Column 25: Downstream Pipe Invert Level (m AHD)."]
["Column 26: Upstream Pipe Hydraulic Grade Line Level (inside the pipe) (m AHD)."]
["Column 27: Downstream Pipe Hydraulic Grade Line Level (m AHD)."]
["Column 28: Pipe Flow Velocity (m/s), for full or part-full flow."]
["Column 29: Pit Pressure Change Coefficient, the Ku value applying to the main line through the pit."]
["Column 29a: Chart Structure Number.  If the QUDM method for determining Ku is applied, the number of the Chart in QUDM (2008) that is used to determine pit pressure change K factors is displayed."]
["                     If this is given as 'H-O'L' the equations in a paper by Hare and O'Loughlin are used."]
["Column 29b: Ratios used to define a K value from the appropriate QUDM chart, if teh QUDM method is applied."]
["Column 30: Water Surface Elevation (m AHD)."]
["Column 31: Surface or Kerb and Channel (Kerb and Gutter) Obvert Level (m AHD)."]
["Column 32: Freeboard (m), the difference between the levels in the two previous columns."]
["Column 33: Pit Name (repeated)."]