{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Drainage-Summary 9190-26-71","Drainage-Data 9190-26-71","Drainage-DataExample Problem","WQ-Summary 9190-26-71","WQ-Wet Detention Ponds","WQ-Catchbasins","Spreadsheet Constants","Sheet1"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":45,"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":"Drainage-Summary 9190-26-71","index":0,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[[17,0,19,0],[16,1,16,2],[17,1,19,2],[20,1,20,2],[23,1,23,2],[21,1,21,2],[22,1,22,2],[25,1,25,2],[27,1,27,2],[26,1,26,2],[24,1,24,2],[35,1,35,2],[29,1,29,2],[31,1,31,2],[33,1,33,2],[28,1,28,2],[30,1,30,2],[34,1,34,2],[32,1,32,2]]}
[1,"Basic Project Information"]
[2,"Project ID:  9190-26(27)-71"]
[3,"Title:    Pulaski - STH 22"]
[4,"Designer/Checker: Spielmacher"]
[5,"DOT Region/Firm Name: NER"]
[6,"Date: 3-21-18"]
[]
[7,"HIGHWAY: ","STH 32"]
[8,"LIMITS:","Pulaski NVL - CTH E, CTH E - STH 22"]
[9,"COUNTY:","Outagamie"]
[10,"DESCRIPTION OF WORK: ","Resurfacing"]
[11,"PROJECT MANAGER: ","Zoellner"]
[12,"PS&E DATE: ","2020-11-01"]
[13,"DESIGN STAGE"]
[]
[14,"Drainage Summary"]
[15,"IS THERE A SIGNIFICANT FLOW INCREASE OR DECREASE WITHIN ANY SUB BASIN OF THE PROJECT?  IF YES, DESCRIBE THE CAUSE OF THE CHANGE AND WHY IT IS NECESSARY."]
[16,"no"]
[]
[]
[17,"IS THERE A SIGNIFICANT IMPERVIOUS AREA CHANGE TO ANY SUB BASIN OF THE PROJECT?  IF YES, DESCRIBE THE CAUSE OF THE CHANGE AND WHY IT IS NECESSARY."]
[18,"no"]
[19,"HAVE THE DRAINAGE SUB BASIN AREAS OR FLOW PATHS CHANGED SIGNIFICANTLY?  IF YES, DESCRIBE THE CAUSE OF THE CHANGE AND WHY IT IS NECESSARY."]
[20,"no"]
[21,"DESCRIBE THE PROPOSED DRAINAGE CONVEYANCE AND CONTROL SYSTEMS FOR THE PROJECT."]
[22,"roadside ditches and cross culverts"]
[23,"DESCRIBE THE AQUATIC ORGANISM PASSAGE ISSUES FOR THE PROJECT, IF ANY."]
[24,"NA"]
[25,"IF THE DESIGN DOES NOT MEET THE DOT FDM CHAPTER 13 DRAINAGE REQUIREMENTS, EXPLAIN HOW AND WHY."]
[26,"NA"]
[27,"DESCRIBE WDNR COORDINATION.  PROVIDE NAME OF WDNR CONTACT AND DATE, AND ATTACH ANY CORRESPONDENCE."]
[28,"DNR Initial Project Review dated March 7, 2016 (Doperalski)"]
[29,"IF THE DRAINAGE DESIGN MEETS LOCAL, MUNICIPAL OR REGIONAL GUIDELINES THAT EXCEED FDM CHAPTER 13 DRAINAGE REQUIREMENTS, EXPLAIN HOW AND WHY."]
[30,"NA"]
[29," IF A SIGNIFICANT IMPACT TO THE PROJECT OCCURS DUE TO DRAINAGE, PROJECT MANAGER CONCURRENCE IS REQUIRED.  (PM SIGN AND DATE)"]
[30,"NA"]

{"sheet":"Drainage-Data 9190-26-71","index":1,"n_rows":141,"n_cols":11,"rows_kept":141,"cut":false,"hidden":false,"merged":[[141,0,141,7],[142,0,142,7],[143,0,143,7],[144,0,144,7],[145,0,145,7]]}
[1,"Drainage Data"]
[2,{"$f":"'Drainage-Summary 9190-26-71'!B2","v":"Project ID:  9190-26(27)-71"}]
[3,{"$f":"'Drainage-Summary 9190-26-71'!B3","v":"Title:    Pulaski - STH 22"}]
[4,{"$f":"'Drainage-Summary 9190-26-71'!B4","v":"Designer/Checker: Spielmacher"}]
[5,{"$f":"'Drainage-Summary 9190-26-71'!B5","v":"DOT Region/Firm Name: NER"}]
[6,{"$f":"'Drainage-Summary 9190-26-71'!B6","v":"Date: 3-21-18"}]
[]
[7,"Section 1:  OUTFALL INFORMATION (all projects)",null,null,null,"(CTH S)"]
[8,"Outfall number",1,2,3,4,5,6,7,8,9]
[9,"Outfall discharges to:","Ditch","Ditch","Ditch","Ditch","Ditch","Ditch","Ditch","Ditch","Ditch"]
[10,"Waterway crossing type","Culvert","Culvert","Culvert","Culvert","Culvert","Culvert","Culvert","Culvert","Culvert"]
[12,"Previous flooding issues or flow restrictions?","No","No","No","No","No","No","No","No","No"]
[13,"Is the drainageway a navigable waterway?","No","No","No","No","No","No","No","No","No"]
[14,"Waterway designation, if any","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[]
[15,"Section 2:  BASIC SUB BASIN DRAINAGE INFORMATION (all projects)",null,null,null,"(CTH S)"]
[16,"Outfall number",{"$f":"C9","v":1},2,3,4,5,6,{"$f":"I9","v":7},8,9]
[17,"Outfall station","45+20",8112,14565,6547,22840,57975,58505,62094,67850]
[18,"Flood design frequency (yrs)",25,25,25,25,25,25,25,25,25]
[19,"Check design frequency (yrs)",100,100,100,100,100,100,100,100,100]
[20,"Drainage area (acres)",2.17,33.700000000000003,30.1,32,152.6,58.1,36,38.4,32]
[21,"Hydrologic Method","rational","rational","rational","rational","rational","rational","rational","rational","rational"]
[22,"Time of Concentration (min)",2.5,30,42,32,84,46,21,28,32]
[23,"C or CN ",0.88500000000000001,0.19,0.2,0.22,0.17,0.18,0.18,0.2,0.18]
[24,"Rainfall intensity (in/hr) (rational method only)",7.25,3.2,2.5,3,1.6,2.4,3.9,3.3,3]
[25,"Rainfall depth for design storm (in)","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[26,"Design peak flow rate (cfs)",{"$f":"C24*C25*C21","v":13.9232625},{"$f":"D24*D25*D21","v":20.489600000000006},15.05,21.12,41.507200000000005,25.0992,25.271999999999998,25.344000000000001,17.28]
[27,"Check peak flow rate (cfs)",{"$f":"C24*C21*9","v":17.284050000000001},{"$f":"D24*D21*4","v":25.612000000000002},{"$f":"E24*E21*3.1","v":18.662000000000003},{"$f":"F24*F21*3.7","v":26.048000000000002},{"$f":"G24*G21*2","v":51.884},{"$f":"H24*H21*3","v":31.374000000000002},{"$f":"I24*I21*4.75","v":30.779999999999998},{"$f":"J24*J21*4","v":30.72},{"$f":"K24*K21*3.8","v":21.887999999999998}]
[28,"Hydraulic Design software","HY-8","HY-8","HY-8","HY-8","HY-8","HY-8","HY-8","HY-8","HY-8"]
[]
[29,"Section 3:  URBAN/TRANS 401 PROJECTS"]
[30,"Outfall number",{"$f":"C9","v":1},2,3,4,5,6,{"$f":"I9","v":7},8,9]
[31,"DOT right-of-way area (ac)",1]
[32,"DOT area/drainage area (%)",{"$f":"C33/C21","v":0.46082949308755761},{"$f":"D33/D21","v":0},0,0,0,0,{"$f":"I33/I21","v":0},0,0]
[33,"DOT impervious area--existing (ac)"]
[34,"DOT impervious area--proposed (ac)"]
[35,"Impervious area change (ac)",{"$f":"C36-C35","v":0},{"$f":"D36-D35","v":0},0,0,0,0,{"$f":"I36-I35","v":0},0,0]
[36,"Impervious area change (%)",{"$f":"C37/C35","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"I37/I35","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[37,"Design peak flow rate--proposed (cfs) pre-detention"]
[38,"Peak flow rate change (cfs)",{"$f":"C39-C27","v":-13.9232625},-20.489600000000006,-15.05,-21.12,-41.507200000000005,-25.0992,{"$f":"I39-I27","v":-25.271999999999998},-25.344000000000001,-17.28]
[39,"Peak flow rate change (%)",{"$f":"C40/C27","v":-1},-1,-1,-1,-1,-1,{"$f":"I40/I27","v":-1},-1,-1]
[40,"Design peak flow rate--proposed (cfs) post-detention"]
[41,"2-yr peak flow rate--existing (cfs)"]
[42,"2-yr peak flow rate--proposed (cfs)"]
[43,"2-yr peak flow rate--post-detention (cfs)"]
[]
[44,"Section 4:  CULVERT DESIGN"]
[45,"Existing Culvert",null,null,null,"(CTH S)"]
[46,"Outfall number",{"$f":"C9","v":1},2,3,4,5,6,{"$f":"I9","v":7},8,9]
[47,"Culvert present? (Yes or No)","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes"]
[48,"Shape","Circular","Circular","Circular","Circular","Circular","Circular","Circular","Circular","Circular"]
[49,"Material","RCP","RCP","RCP","RCP","RCP","RCP","RCP","RCP","RCP"]
[50,"Diameter/span (ft)",2,2.25,2.5,2.5,3,2,2,2,2.5]
[51,"Number of barrels",1,1,1,1,1,1,1,1,1]
[52,"Manning's n",1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2]
[53,"Inlet entrance type","AEW","AEW","AEW","AEW","AEW","AEW","AEW","AEW","AEW"]
[54,"Upstream invert (ft)",802.64200000000005,801.52499999999998,798.50300000000004,797.85500000000002,788.75599999999997,789.61900000000003,784.23500000000001,786.26800000000003,796.274]
[55,"Downstream invert (ft)",802.49300000000005,800.99099999999999,798.452,797.64200000000005,788.26400000000001,788.048,781.32100000000003,785.65099999999995,796.07600000000002]
[56,"Length (ft)",54,50,56,96,62,104,98,62,66]
[57,"Slope (%)",{"$f":"(C57-C58)/C59","v":2.759259259259276E-3},{"$f":"(D57-D58)/D59","v":1.0679999999999835E-2},9.1071428571508155E-4,2.2187499999996398E-3,7.9354838709671267E-3,1.5105769230769485E-2,{"$f":"(I57-I58)/I59","v":2.9734693877550889E-2},9.9516129032270247E-3,2.999999999999683E-3]
[58,"Computed Upstream Water Surface Elevation (ft)","see line 73","see line 73","see line 73","see line 73","see line 73","see line 73","see line 73","see line 73","see line 73"]
[59,"Tailwater elevation","see line 74","see line 74","see line 74","see line 74","see line 74","see line 74","see line 74","see line 74","see line 74"]
[60,"Outlet velocity (ft/s)","see line 75","see line 75","see line 75","see line 75","see line 75","see line 75","see line 75","see line 75","see line 75"]
[61,"Proposed Culvert Design",null,null,null,"(CTH S)"]
[62,"Design ADT (2041)",6000,6000,6000,3300,6000,3700,3700,3700,3700]
[63,"Shape","Circular","Circular","Circular","Circular","Circular","Circular","Circular","Circular","Circular"]
[64,"Material","RCP","RCP","RCP","RCP","RCP","RCP","RCP","RCP","RCP"]
[65,"Diameter/span (ft)",2,2.25,2.5,2.5,3,2,2,2,2.5]
[66,"Number of barrels",1,1,1,1,1,1,1,1,1]
[67,"Manning's n",1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.2E-2]
[68,"Inlet entrance type","AEW","AEW","AEW","AEW","AEW","AEW","AEW","AEW","AEW"]
[69,"Upstream invert (ft)",802.65,801.53,798.5,797.86,788.76,789.61900000000003,784.23500000000001,786.26800000000003,796.274]
[70,"Downstream invert (ft)",802.49,800.99,798.33,797.57,788.26,788.048,781.32100000000003,785.65099999999995,796.07600000000002]
[71,"Length (ft)",54,50,56,96,62,104,98,62,66]
[72,"Slope (%)",{"$f":"(C72-C73)/C74","v":2.9629629629623734E-3},{"$f":"(D72-D73)/D74","v":1.0799999999999272E-2},3.0357142857135549E-3,3.0208333333329542E-3,8.0645161290322578E-3,1.5105769230769485E-2,{"$f":"(I72-I73)/I74","v":2.9734693877550889E-2},9.9516129032270247E-3,2.999999999999683E-3]
[73,"Computed Upstream Water Surface Elevation (ft)",804.87,804.4,800.72,800.37,792.18,793.44,788.05,790.1,798.69]
[74,"Tailwater elevation",802.68,801.25,798.54,797.81,788.63,788.32,781.59,785.92,796.31]
[75,"Outlet velocity (ft/s)",6.2,10.199999999999999,6.1,6.5,9.3000000000000007,10.5,13.2,8.9,6.4]
[76,"Change in Upstream Water Surface Elevation (ft)","no change","no change","slight decrease","slight decrease","no change","no change","no change","no change","no change"]
[77,"Riprap outfall (Size riprap or None)","none","none","none","none","none","none","none","none","none"]
[78,"Maximum allowable headwater","see line 81","see line 81","see line 81","see line 81","see line 81","see line 81","see line 81","see line 81","see line 81"]
[79,"Maximum allowable headwater design criteria","Top of Subgrade","Top of Subgrade","Top of Subgrade","Top of Subgrade","Top of Subgrade","Top of Subgrade","Top of Subgrade","Top of Subgrade","Top of Subgrade"]
[80,"Station of lowest subgrade shoulder point (0+00)","45+20","81+12","145+65","65+47","228+40","579+75","585+05","620+94","678+50"]
[81,"Elevation of lowest subgrade shoulder point (ft)","~807.25","~804.75","~800.50","~800.75","~793.75","~797.00","~790.25","~790.75","~801.00"]
[82,"Headwater to pipe diameter ratio",{"$f":"(C76-C72)/C68","v":1.1100000000000136},{"$f":"(D76-D72)/D68","v":1.2755555555555576},0.88800000000001089,1.0039999999999965,1.1399999999999864,1.9105000000000132,1.9074999999999704,1.9159999999999968,0.96640000000002146]
[83,"Floodplain Management","NA"]
[84,"Mapped floodplain","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[85,"Increase in headwater","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[86,"Drainage District Issues","NA"]
[87,"Is culvert in a drainage district?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[88,"Drainage District Name"]
[89,"Increase in headwater","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[90,"Drainage board approval?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[91,"Aquatic Organism Passage","NA"]
[92,"Is aquatic organism passage a concern?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[93,"Does WDNR concur with design?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[94,"Embedment depth (ft)"]
[95,"Embedment material"]
[]
[96,"Section 5:  CULVERT LINER DESIGN"]
[97,"Existing Culvert"]
[98,"Outfall number",{"$f":"C9","v":1},2,3,4,5,6,{"$f":"I9","v":7},8,9]
[99,"Existing culvert size (ft)"]
[100,"Pipe material"]
[101,"Pipe condition"]
[102,"Any collapse?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[103,"Any deflection?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[104,"Are ends crushed?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[105,"n value existing pipe"]
[106,"Pipe geometry (i.e. circular)","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[107,"Upstream invert (ft)",100]
[108,"Downstream invert (ft)",99]
[109,"Length (ft)",100]
[110,"Slope (%)",{"$f":"(C111-C112)/C113","v":0.01},{"$f":"(D111-D112)/D113","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"(I111-I112)/I113","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[111,"Depth of cover over culvert (ft)"]
[112,"Is overtopping an issue?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[113,"Upstream flooding risk?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[114,"Existing Design highwater elevation (ft)"]
[115,"Field verify dimension?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[116,"Liner Details"]
[117,"Estimated Diameter (ft)"]
[118,"Proposed Material"]
[119,"Roughness, n"]
[120,"Upstream invert (ft)"]
[121,"Downstream invert (ft)"]
[122,"Proposed Design highwater elevation (ft)"]
[123,"Change in highwater elevation (ft)"]
[124,"Floodplain Management"]
[125,"Mapped floodplain","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[126,"Increase in headwater","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[127,"Drainage District Issues"]
[128,"Is culvert in a drainage district?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[129,"Drainage District Name"]
[130,"Has drainage board approved use of a liner?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[131,"Aquatic Organism Passage"]
[132,"Is aquatic organism passage a concern?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[133,"Does WDNR concur with design?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[134,"Embedment depth (ft)"]
[135,"Embedment material"]
[]
["Enter Line Number and Note.  Add more boxes if necessary"]

{"sheet":"Drainage-DataExample Problem","index":2,"n_rows":126,"n_cols":10,"rows_kept":126,"cut":false,"hidden":true,"merged":[[126,0,126,7],[127,0,127,7],[128,0,128,7],[129,0,129,7],[130,0,130,7]]}
[1,"Drainage Data"]
[2,{"$f":"'Drainage-Summary 9190-26-71'!B2","v":"Project ID:  9190-26(27)-71"}]
[3,{"$f":"'Drainage-Summary 9190-26-71'!B3","v":"Title:    Pulaski - STH 22"}]
[4,{"$f":"'Drainage-Summary 9190-26-71'!B4","v":"Designer/Checker: Spielmacher"}]
[5,"DOT Region/Firm Name:"]
[6,{"$f":"'Drainage-Summary 9190-26-71'!B6","v":"Date: 3-21-18"}]
[]
[7,"OUTFALL INFORMATION"]
[8,"Outfall number",1,2,3,4,5,6]
[9,"Outfall discharges to:"]
[10,"Waterway crossing type","Box Culvert","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[12,"Previous flooding issues or flow restrictions?","No","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[13,"Is the drainageway a navigable waterway?","Yes","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[14,"Waterway designation, if any","N/A","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[]
[15,"BASIC SUB BASIN DRAINAGE INFORMATION"]
[16,"Outfall number",{"$f":"C9","v":1},2,3,4,5,6]
[17,"Outfall station","397+89",null,"397+89"]
[18,"Flood design frequency (yrs)",25,null,25]
[19,"Check design frequency (yrs)",100,null,100]
[20,"Drainage area (acres)",101.5,null,101.5]
[21,"Hydrologic Method","Rational",null,"TR20"]
[22,"Time of Concentration (min)",20,null,20]
[23,"C or CN ",0.23,null,73]
[24,"Rainfall intensity (in/hr) (rational method only)",5]
[25,"Rainfall depth for design storm (in)",null,null,4.9000000000000004]
[26,"Peak flow (cfs)",117,null,225,null,null,null,null,{"$f":"C21*C24*C25","v":116.72500000000001}]
[27,"Hydraulic Design software","HY-8",null,"HY-8"]
[]
[28,"CULVERT DESIGN"]
[29,"Existing Culvert"]
[30,"Outfall number",{"$f":"C9","v":1},2,3,4,5,6]
[31,"Culvert present? (Yes or No)","Yes","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[32,"Shape","Box","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[33,"Material","RCP","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[34,"Diameter/span (ft)","6 x 6"]
[35,"Number of barrels",1]
[36,"Manning's n",1.2999999999999999E-2]
[37,"Inlet entrance type","Headwall","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[38,"Upstream invert (ft)",839.2]
[39,"Downstream invert (ft)",839]
[40,"Length (ft)",34]
[41,"Slope (%)",{"$f":"(C40-C41)/C42","v":5.882352941177808E-3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[42,"Computed Upstream Water Surface Elevation (ft)",843.27]
[43,"Tailwater elevation",841.23]
[44,"Overtopping Frequency","> 100yr"]
[45,"Outlet velocity (ft/s)",10.35]
[46,"Proposed Culvert Design"]
[47,"Design ADT"]
[48,"Shape","Circular","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[49,"Material","RCP","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[50,"Diameter/span (ft)",6]
[51,"Number of barrels",1]
[52,"Manning's n",1.2999999999999999E-2]
[53,"Inlet entrance type","AEW","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[54,"Upstream invert (ft)",838.94]
[55,"Downstream invert (ft)",838.31]
[56,"Length (ft)",55]
[57,"Slope (%)",{"$f":"(C56-C57)/C58","v":1.145454545454744E-2},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[58,"Computed Upstream Water Surface Elevation (ft)",843.68]
[59,"Tailwater elevation",840.59]
[60,"Overtopping Frequency","> 100 yr"]
[61,"Outlet velocity (ft/s)",12.29]
[62,"Change in Upstream Water Surface Elevation (ft)","+ 0.41"]
[63,"Riprap outfall (Size riprap or None)"]
[64,"Maximum allowable headwater"]
[65,"Maximum allowable headwater design criteria","Top of Subgrade","DDMenu","DDMenu","DDMenu","DDMenu","DDMenu"]
[66,"Station of lowest subgrade shoulder point (0+00)","397 + 89"]
[67,"Elevation of lowest subgrade shoulder point (ft)","~ 847.0"]
[68,"Headwater to pipe diameter ratio",{"$f":"(843.68-838.94)/C52","v":0.78999999999998261}]
[69,"Floodplain Management"]
[70,"Mapped floodplain","No","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[71,"Increase in headwater","Yes","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[72,"Drainage District Issues"]
[73,"Is culvert in a drainage district?","No","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[74,"Drainage District Name"]
[75,"Increase in headwater","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[76,"Drainage board approval?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[77,"Aquatic Organism Passage"]
[78,"Is aquatic organism passage a concern?","No","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[79,"Does WDNR concur with design?",null,"DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[80,"Embedment depth (ft)"]
[81,"Embedment material"]
[]
[82,"CULVERT LINER DESIGN"]
[83,"Existing Culvert"]
[84,"Outfall number",{"$f":"C9","v":1},2,3,4,5,6]
[85,"Existing culvert size (ft)",4]
[86,"Pipe material","CMP"]
[87,"Pipe condition","Poor"]
[88,"Any collapse?","No","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[89,"Any deflection?","No","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[90,"Are ends crushed?","Yes","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[91,"n value existing pipe",2.4E-2]
[92,"Pipe geometry (i.e. circular)","Circular","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[93,"Upstream invert (ft)",839]
[94,"Downstream invert (ft)",838.5]
[95,"Length (ft)",100]
[96,"Slope (%)",{"$f":"(C96-C97)/C98","v":5.0000000000000001E-3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[97,"Depth of cover over culvert (ft)",6]
[98,"Is overtopping an issue?","No","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[99,"Upstream flooding risk?","No","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[100,"Existing Design highwater elevation (ft)",843.8]
[101,"Field verify dimension?","Yes","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[102,"Liner Details"]
[103,"Diameter (ft)",3.5]
[104,"Material","HDPE"]
[105,"Roughness, n",1.2E-2]
[106,"Upstream invert (ft)",839.25]
[107,"Downstream invert (ft)",838.75]
[108,"Proposed Design highwater elevation (ft)",844.32]
[109,"Change in highwater elevation (ft)"," +0.52"]
[110,"Floodplain Management"]
[111,"Mapped floodplain","No","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[112,"Increase in headwater","Yes","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[113,"Drainage District Issues"]
[114,"Is culvert in a drainage district?","No","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[115,"Drainage District Name"]
[116,"Has drainage board approved use of a liner?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[117,"Aquatic Organism Passage"]
[118,"Is aquatic organism passage a concern?","No","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[119,"Does WDNR concur with design?","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu","DD Menu"]
[120,"Embedment depth (ft)"]
[121,"Embedment material"]
[]
["Enter Line Number and Note.  Add more boxes if necessary"]

{"sheet":"WQ-Summary 9190-26-71","index":3,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[27,1,27,10],[23,1,23,10],[19,1,19,10],[14,1,14,10],[24,1,24,10],[20,1,20,10],[21,1,21,10],[7,2,7,10],[31,1,31,10],[37,1,37,10],[13,2,13,10],[22,1,22,10],[8,2,8,10],[9,2,9,10],[10,2,10,10],[11,2,11,10],[12,2,12,10],[36,1,36,10],[28,1,28,10],[29,1,29,10],[30,1,30,10],[25,1,25,10],[26,1,26,10]]}
[1,"Project Summary"]
[2,{"$f":"'Drainage-Summary 9190-26-71'!B2","v":"Project ID:  9190-26(27)-71"}]
[3,{"$f":"'Drainage-Summary 9190-26-71'!B3","v":"Title:    Pulaski - STH 22"}]
[4,{"$f":"'Drainage-Summary 9190-26-71'!B4","v":"Designer/Checker: Spielmacher"}]
[5,{"$f":"'Drainage-Summary 9190-26-71'!B5","v":"DOT Region/Firm Name: NER"}]
[6,{"$f":"'Drainage-Summary 9190-26-71'!B6","v":"Date: 3-21-18"}]
[]
[7,"HIGHWAY:",{"$f":"'Drainage-Summary 9190-26-71'!C8","v":"STH 32"}]
[8,"LIMITS:",{"$f":"'Drainage-Summary 9190-26-71'!C9","v":"Pulaski NVL - CTH E, CTH E - STH 22"}]
[9,"COUNTY:",{"$f":"'Drainage-Summary 9190-26-71'!C10","v":"Outagamie"}]
[10,"DESCRIPTION OF WORK:",{"$f":"'Drainage-Summary 9190-26-71'!C11","v":"Resurfacing"}]
[11,"PROJECT MANAGER:",{"$f":"'Drainage-Summary 9190-26-71'!C12","v":"Zoellner"}]
[12,"PS&E DATE:","11-1-20"]
[13,"DESIGN STAGE","60% Design Stage"]
[null,"Water Quality Results Discussion"]
[14,"Water Quality Results Summary","Total Project Drainage Basin Area (ac)","Grass Swales","Filter Strips","Wet Detention Ponds","Catch- basins","Street Cleaning","Biofilters","Other Devices","Untreated Areas"]
[15,"Drainage Area (ac)",0,null,null,0,0,null,null,null,{"$f":"C17-SUM(D17:J17)","v":0}]
[16,"ROW Drainage Area (ac)",0,null,null,0,0,null,null,null,{"$f":"C18-SUM(D18:J18)","v":0}]
[17,"Percent TSS Reduction by Treatement Type",{"$f":"(G18*G19+F18*F19+E18*E19+D18*D19+H18*H19+J18*J19)/C18","v":{"$error":"#DIV/0!"}},null,null,0,0,null,null,null,0]
[null,"Project Water Quality Objectives"]
[18,"           THE PROJECT IS EXEMPT FROM TRANS 401 STORMWATER QUALITY REQUIREMENTS AND REQUIRES NO FURTHER WATER QUALITY INFORMATION.  DESCRIBE BELOW WHY IT IS EXEMPT.  "]
[19,"PROJECT CONSIDERED MINOR RECONSTRUCTION PER TRANS 401.03(3)(F) - NO TSS REDUCTION REQUIRED"]
[20,"DESCRIBE THE STORMWATER QUALITY MANAGEMENT REQUIREMENTS PER TRANS 401 OR THE TMDL WASTELOAD ALLOCATION."]
[21]
[22,"IF THE PROJECT REQUIRES STORMWATER MANAGEMENT EXPLAIN HOW THE TRANS 401 2-YR PEAK DISCHARGE REQUIREMENT WAS MET."]
[23]
[24,"HAS THE DEPARTMENT AGREED TO MEET ANY LOCAL STORMWATER QUALITY ORDINANCES OR REQUIREMENTS FOR THIS PROJECT?  IF SO, DESCRIBE."]
[25]
[26,"IF THE PROJECT REQUIRES STORM WATER MANAGEMENT EXPLAIN HOW THE TOTAL SUSPENDED SOLIDS REDUCTION WAS MET.   Refer to Water Quality Results Summary above."]
[27]
[28,"LIST THE POST CONSTRUCTION STORMWATER QUALITY CONTROL TREATMENT MEASURES FOR THE PROJECT."]
[29]
[]
[]
[]
[]
[null,"REGIONAL STORMWATER ENGINEER CONCURRENCE (SIGN AND DATE)"]
[30]

{"sheet":"WQ-Wet Detention Ponds","index":4,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":true,"merged":[[25,0,25,6],[7,6,11,6],[21,0,21,6],[22,0,22,6],[23,0,23,6],[24,0,24,6]]}
[1,"Wet Detention Pond Performance"]
[2,{"$f":"'Drainage-Summary 9190-26-71'!B2","v":"Project ID:  9190-26(27)-71"}]
[3,{"$f":"'Drainage-Summary 9190-26-71'!B3","v":"Title:    Pulaski - STH 22"}]
[4,{"$f":"'Drainage-Summary 9190-26-71'!B4","v":"Designer/Checker: Spielmacher"}]
[5,{"$f":"'Drainage-Summary 9190-26-71'!B5","v":"DOT Region/Firm Name: NER"}]
[6,{"$f":"'Drainage-Summary 9190-26-71'!B6","v":"Date: 3-21-18"}]
[]
[7,"Drainage Area Basin Number",null,null,null,null,"Total"]
[8,"Pond Number",1,2]
[9,"Pond Ending Station Number",3000,4800]
[10,"Pond Starting Station Number",2000,3500]
[11,"Left, Center, Right, or All","R","R"]
[12,"Site Assessment"]
[13,"Highway Segment Length Treated (ft)",{"$f":"C10-C11","v":1000},{"$f":"D10-D11","v":1300}]
[14,"Drainage Area (ac)",12,15,null,null,{"$f":"SUM(C15:F15)","v":27}]
[15,"ROW Area (ac)",1.5,1.9,null,null,{"$f":"SUM(C16:F16)","v":3.4}]
[16,"Percent Reduction",0.75,0.85,null,null,{"$f":"(C16*C17+D16*D17+E16*E17+F16*E18)/G16","v":0.80588235294117661}]
[17,"Results Summary"]
[18,"Percent Reduction per Treated Highway Segment",{"$f":"C17","v":0.75},{"$f":"D17","v":0.85},null,null,{"$f":"G17","v":0.80588235294117661}]
[]
["Enter Line Number and Comment.  Add more boxes if necessary"]

{"sheet":"WQ-Catchbasins","index":5,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[[30,0,30,5],[7,5,10,5],[26,0,26,5],[27,0,27,5],[28,0,28,5],[29,0,29,5]]}
[1,"Catchbasin Performance"]
[2,{"$f":"'Drainage-Summary 9190-26-71'!B2","v":"Project ID:  9190-26(27)-71"}]
[3,{"$f":"'Drainage-Summary 9190-26-71'!B3","v":"Title:    Pulaski - STH 22"}]
[4,{"$f":"'Drainage-Summary 9190-26-71'!B4","v":"Designer/Checker: Spielmacher"}]
[5]
[6,{"$f":"'Drainage-Summary 9190-26-71'!B6","v":"Date: 3-21-18"}]
[]
[7,"Drainage Area Basin Number",null,null,null,"Total"]
[8,"Catchbasin Number"]
[9,"Catchbasin Station",1000,1200]
[10,"Left, Center,  or Right","R","R"]
[11,"Site Assessment"]
[12,"Distance to Next Catchbasin or Drainage Area (ft)",200,250]
[13,"Drainage Area (ac)",0.3,0.45,null,{"$f":"SUM(C14:E14)","v":0.75}]
[14,"ROW Area (ac)",0.2,0.2,null,{"$f":"SUM(C15:E15)","v":0.4}]
[15,"Cross Section Type (5 or 8)",5,8,"DD Menu"]
[16,"Catchbasin or Inlet Type/Size","Type 3 Inlet","Type 3 Inlet","DD Menu"]
[17,"Predominant Cover Type","Mostly Imperv","Mostly Perv","DD Menu"]
[18,"Design Chart Number",1,10,"DD Menu"]
[19,"Percent Reduction from Design Chart",0.22,0.23]
[20,"Results Summary"]
[21,"Average Drainage Area Width (ft)",{"$f":"C14/C$13*43560","v":65.34},78.408000000000001,{"$error":"#DIV/0!"}]
[22,"Average ROW Width (ft)",43.56,34.847999999999999,{"$error":"#DIV/0!"}]
[23,"Percent Reduction per unit ROW Area",{"$f":"C20*C15","v":4.4000000000000004E-2},{"$f":"D20*D15","v":4.6000000000000006E-2},{"$f":"E20*E15","v":0},{"$f":"SUM(C24:E24)/F14","v":0.12000000000000001}]
[]
["Enter Line Number and Comment.  Add more boxes if necessary"]

{"sheet":"Spreadsheet Constants","index":6,"n_rows":172,"n_cols":1,"rows_kept":172,"cut":false,"hidden":true,"merged":[[0,13,0,14],[0,15,0,16],[0,5,0,6],[0,7,0,8],[0,9,0,10],[0,11,0,12]]}
[]
["Catchbasin Types"]
["DD Menu"]
[]
["Type 3 Inlet"]
["Type 1 CB"]
["5' Dia CB"]
["Type 5 CB"]
[]
["Cross Section Type"]
["DD Menu"]
[]
[5]
[8]
[]
["Land Use Types"]
["DD Menu"]
[]
["Mostly Perv"]
["Mostly Imperv"]
[]
["Soil Types"]
["DD Menu"]
[]
["Sandy"]
["Silty/Clayey"]
[]
["Design Freq"]
["DD Menu"]
[]
["Yes"]
["No"]
[]
["Tailwater Condition"]
["DD Menu"]
[]
["Submerged"]
["Unsubmerged"]
["Free Flow Outlet"]
[]
["Chart Number"]
["DD Menu"]
[]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
["Culvert_Shape"]
["DD Menu"]
[]
["Circular"]
["Elliptical"]
["Arch"]
["Box"]
[]
["Culvert_Material"]
["DD Menu"]
[]
["RCP"]
["CMP"]
["HDPE"]
[]
["Inlet_Entrance_Type"]
["DD Menu"]
[]
["AEW"]
["Miter to Slope"]
["Projected"]
["Headwall"]
[]
["Outfall_Discharges_To"]
["DD Menu"]
[]
["Overland"]
["Ditch"]
["Creek"]
["River"]
["Wetland"]
["Storm Sewer"]
["Combined Sewer"]
["Other"]
[]
["Waterway_Type"]
["DD Menu"]
[]
["N/A"]
["Wetland"]
["303(d) Waters"]
["Exceptional Waters"]
["Outstanding Waters"]
["Waters of the U.S."]
[]
["Stormwater_Conveyance_Type"]
["DD Menu"]
[]
["Storm Sewer"]
["Ditch/Swale"]
["Combined Sewer"]
[]
["Waterway_Crossing_Type"]
["DD Menu"]
[]
["Culvert"]
["Box Culvert"]
["Storm Sewer"]
["3 Sided Box Culvert"]
["Bridge"]
[]
["Buffer_Options"]
["DD Menu"]
[]
["Swales"]
["Filter Strips"]
["Veg. Embankment"]
[]
["Freeway_Lanes_and_Design_Chart_Number"]
["DD Menu"]
[1]
[2]
[3]
[]
["Freeway_Soil_Types"]
["DD Menu"]
["Sand"]
["Loamy Sand"]
["Sandy Loam"]
["Loam"]
["Silty Clay Loam"]
[]
["Headwater_Design_Criteria"]
["DDMenu"]
["1.5xHw/Dia"]
["Top of Subgrade"]
[]
["Swale_Soil_Type"]
["DD Menu"]
["Sand"]
["Loamy Sand"]
["Sandy Loam"]
["Loamy Sand"]
["Silty Clay Loam"]
[]
["Number_of_Highway_Lanes"]
["DDMenu"]
[1]
[2]
[3]
[4]
[]
["Typical_Grass_Swale_Slope"]
["DD Menu"]
[3.0000000000000001E-3]
[1.2999999999999999E-2]
[3.5000000000000003E-2]
[]
["Swale_Design_Chart_Number"]
["DD Menu"]
[1]
[2]
[3]
[]
["Grass_Swale_Width"]
["DD Menu"]
[0]
[10]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}