{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Design","Design Summary","Plan Map","IA-1571 Drawings","IA-1572 Drawings","Specs-O&M","Reference","Labels","Notes"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":1,"defined_names":51,"comments":1,"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":"Instructions","index":0,"n_rows":47,"n_cols":27,"rows_kept":47,"cut":false,"hidden":false,"merged":[[43,18,43,19],[44,18,44,19],[45,18,45,19],[43,20,43,21],[44,20,44,21],[32,20,32,21],[2,2,2,11],[3,2,3,11],[6,0,6,11],[5,0,5,1],[32,15,32,17],[32,18,32,19],[14,2,14,11],[11,2,11,11],[7,0,11,1],[15,0,15,11],[7,2,7,11],[12,0,12,11],[32,13,36,14],[31,15,31,17],[16,2,21,11],[33,15,33,17],[34,15,34,17],[35,15,35,17],[36,15,36,17],[47,15,47,16],[44,15,44,17],[38,15,38,17],[39,15,39,17],[40,15,40,17],[41,15,41,17],[42,15,42,17],[43,15,43,17],[37,15,37,17],[45,15,45,17],[46,15,46,17],[33,18,33,19],[34,18,34,19],[35,18,35,19],[36,18,36,19],[37,18,37,19],[33,20,33,21],[34,20,34,21],[35,20,35,21],[36,20,36,21],[37,20,37,21],[40,20,40,21],[39,20,39,21],[45,20,45,21],[41,20,41,21],[37,13,40,14],[44,13,46,14],[41,13,43,14],[38,20,38,21],[46,20,46,21],[42,20,42,21],[46,18,46,19],[38,18,38,19],[39,18,39,19],[40,18,40,19],[41,18,41,19],[42,18,42,19],[46,0,46,11],[24,0,24,11],[25,2,30,11],[25,0,30,1],[39,0,39,11],[40,0,40,11],[38,0,38,11],[35,2,37,11],[35,0,37,1],[22,0,22,11],[23,0,23,1],[23,2,23,11],[32,0,33,1],[32,2,33,11],[0,12,0,26],[0,0,1,11],[4,0,4,11],[5,2,5,11],[31,20,31,21],[4,13,4,26],[19,13,19,26],[13,2,13,11],[16,0,21,1],[9,2,9,11],[13,0,14,1],[31,18,31,19],[31,13,31,14],[2,0,2,1],[3,0,3,1],[10,2,10,11]]}
["Iowa Roof Runoff Spreadsheet Design Tool",null,null,null,null,null,null,null,null,null,null,null,"Gutter and Downspoint Material Information"]
[]
["Step",null,"Instructions",null,null,null,null,null,null,null,null,null,null,"Gutter Sizes"]
[1,null,"Enter basic information -- designer, producer name, location"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"K-Style Gutter Sizes"]
[2,null,"Select the correct county from the drop down menu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INCH","A","B","C","D","E","F","G","Area (sq. in.)"]
[3,null,"Enter basic characteristics about the building, including the name, the area, the height of the downspouts, and",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5K",3.625,3.375,3.625,0.56200000000000006,5,0.56200000000000006,0.5,12.68]
[null,null,"gutter slope.  The Gutter Length is the linear feet of gutter that drains to a particular downspout section.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6K",3.875,3.875,4.625,1,6,0.625,0.5625,20.23]
[null,null,"IMPORTANT: the roof area entered should be the roof area PER GUTTER SECTION.  So, if you have",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7K",5.875,4.5620000000000003,6,1,7,0.625,0.625,31.64]
[null,null,"a building that will have a gutter and a downspouts on each corner, the roof area entered should be the roof area ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8K",7.25,5.375,7,1,8,0.625,0.625,43.3]
[null,null,"draining to the corresponding gutter/downspout system"]
[]
[4,null,"Select a gutter size/type from the drop-down menu that is capable of carrying the desired flow."]
[null,null,"The gutter design messages will inform you if the selected gutter has sufficient capacity"]
[]
[5,null,"Choose a downspout style that is compatible with the selected gutter type.  If animal traffic is expected, select a downspout material that will withstand that loading, such as PVC.  Increase the number of downspouts as necessary to handle the flow of the gutter.  The downspout design messages will inform you if the current downspout design is sufficient.  The Needed Qdown box will inform you as to how much flow each downspout must carry if the flow is divided equally among the downspouts.  The Actual Qdown box will inform you of the current downspout's maximum capacity.  The calculations assume that the combined downspouts are adjacent to one another."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Half Round Gutter Sizes"]
[]
[]
[]
[6,null,"Select the number of end caps that will be needed for the gutter section.  This will depend on whether the gutter section is a self-contained unit (an entire side of a building, for example), or if the gutter section represents only part of a gutter system (where there are sections of guttter serving different parts of the same roof, for example.)"]
[]
[7,null,"For each gutter/downspout design, select an outlet method from the drop-down box. Input cells and check boxes will become available or unavailable depending upon the type of outlet selected. The underground outlet can have the option of an animal guard at the outlet.  The type of underground conduit can be selected by the user. The above ground outlet offers a splash pad option (specify the dimensions and other design information on a separate sheet in the construction plans). Inputted data will show on the Design Summary and the appropriate standard drawing (IA-1571 or IA-1572, depending on the selection of underground or above ground outlet.) The program error checks certain requirements as the entry cells are filled out. "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Downspout Sizes and Materials"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TYPE",null,"Nomal Size (in.)",null,null,"Actual Size (in.)",null,"Area (sq. in.)"]
[8,null,"On the \"Plan Map\" tab, insert or draw a plan map to be included in the design plans. Include a location drawing as well as a plan map of the gutter and outlet locations.",null,null,null,null,null,null,null,null,null,null,"Plain Round",null,3,null,null,3,null,7.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,4,null,12.57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,5,null,19.63]
[9,null,"Click the \"Print Design\" button.  A box will display that allows you to select the sheets you wish to print.  You can print to PDF files if desired by changing the default printer to \"Adobe PDF\".  (In Excel 2016, look under File --> Print.)  This will create a separate PDF file for each sheet, which you can combine into construction plans and supporting documentation packet as needed.",null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,6,null,28.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,8,null,50.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Corrugated Round",null,3,null,null,3,null,5.94]
["Important to Note",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,4,null,11.04]
["1. The gutter hanger equation assumes a hanger spacing of 2 feet.  Manual calculation will be required for a closer spacing.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,5,null,17.72]
["2. The \"Print Design\" routine will automatically select the appropriate standard drawing (IA-1571 or 1572) based on your design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,6,null,25.97]
["    (underground or above ground outlet.)",null,null,null,null,null,null,null,null,null,null,null,null,"Plain Rectangular",null,"2\" x 3\"",null,null,"2\" x 3\"",null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3\" x 4\"",null,null,"3\" x 4\"",null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4\" x 5\"",null,null,"4\" x 5\"",null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Corrugated Rectangular",null,"2\" x 3\"",null,null,"2.37\" x 3.25\"",null,7.73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3\" x 4\"",null,null,"2.75\" x 4.25\"",null,11.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4\" x 5\"",null,null,"3.75\" x 5\"",null,18.75]

{"sheet":"Design","index":1,"n_rows":35,"n_cols":191,"rows_kept":35,"cut":false,"hidden":false,"merged":[[20,4,20,6],[19,8,19,10],[20,8,20,10],[19,12,19,14],[20,12,20,14],[20,0,20,2],[2,1,2,2],[3,3,3,6],[17,0,17,15],[7,1,7,2],[5,1,5,2],[4,1,4,2],[11,12,11,16],[3,1,3,2],[2,7,7,10],[2,12,7,15],[11,0,11,6],[11,7,11,11],[19,0,19,2],[6,1,6,2],[19,4,19,6]]}
["Roof Runoff Structure (Gutter Design) Conservation Practice Standard 558",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iowa NRCS - Version 2.0  June 2023"]
[]
["Designed By:",null,null,null,null,null,null,"Note on K-Style Gutter Downspout Selection: \n5\" K-Style gutter can receive a 2\"x3\" downspout; \n6\" K-Style gutter can receive a 3\"x4\" downspout;\n7\" K-Style gutter can receive a 4\"x5\" downspout.  ",null,null,null,null,"Notes on gutter hydraulics:  \nCalculations in this spreadsheet use the 10 yr - 5 min or the \n             25 yr - 5min storm event (as selected by the user).  \nInput gutter slope in ft/ft.  Typical slope is 1/16\"/ft = 0.00521 ft/ft.\nManning's 'n' for the gutter is 0.012."]
["Designed By Date:"]
["Section:"]
["Township:"]
["Range:"]
["Producer Name:"]
["County:","25yr, 5min:",{"$f":"VLOOKUP(Reference!B107,Reference!$A$3:$D$104,3)","v":0.74}]
[null,"10yr, 5 min:",{"$f":"VLOOKUP(Reference!B107,Reference!$A$3:$D$104,4)","v":0.65},null,null,"Reference: Agricultural Waste Management Field Handbook, NEH Part 651 Chapter 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!N39,6,0)","v":0}]
[]
["Determine Water Volume",null,null,null,null,null,null,"Gutter Design",null,null,null,null,"Downspout Design"]
["Gutter Name","Roof Area, ft2","Gutter Length, ft","Downspout Height, ft","Gutter Slope, ft/ft","Storm Event","Roof Qmin, cfs","Gutter Type",{"$f":"IF(Reference!S20<4,\"Gutter Depth, in\",\"\")","v":""},{"$f":"IF(Reference!S20<4,\"Gutter Width, in\",\"\")","v":""},"Qgutter, cfs","Gutter Design Errors","Number of Downspouts","Downspout","Needed per downspout   Qdown, cfs","Actual per downspout Qdown, cfs","Downspout Design Errors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gutter Width"]
[null,null,null,null,null,null,{"$f":"(B14*Reference!$M$46)/3600","v":0},null,null,null,{"$f":"IF(Reference!F16=10,IF(AND(ISNUMBER(I14),ISNUMBER(J14)),Reference!K16,0),(VLOOKUP(Reference!F16,Reference!$E$5:$J$14,6))*(E14^0.5))","v":0},{"$f":"IF(G14=0, \" \", IF(K14<G14, \"Gutter undersized!\", \"OK!\"))","v":" "},null,null,{"$f":"IF(ISNUMBER(B14),IF(Reference!N16=1,G14,G14/(Reference!N16)),\"\")","v":""},{"$f":"0.010457*(VLOOKUP(Reference!G16,Reference!$E$35:$G$50,3))*Reference!M16^0.5","v":0},{"$f":"IF(G14=0,\" \", IF(P14<O14, \"Downspout undersized!\", IF(O14=0, \"Gutter size too small!\", \"OK!\")))","v":" "}]
[null,null,null,null,null,null,{"$f":"(B15*Reference!$M$47)/3600","v":0},null,null,null,{"$f":"IF(Reference!F17=10,IF(AND(ISNUMBER(I15),ISNUMBER(J15)),Reference!K17,0),(VLOOKUP(Reference!F17,Reference!$E$5:$J$14,6))*(E15^0.5))","v":0},{"$f":"IF(G15=0, \" \", IF(K15<G15, \"Gutter undersized!\", \"OK!\"))","v":" "},null,null,{"$f":"IF(ISNUMBER(B15),IF(Reference!N17=1,G15,G15/(Reference!N17)),\"\")","v":""},{"$f":"0.010457*(VLOOKUP(Reference!G17,Reference!$E$35:$G$50,3))*Reference!M17^0.5","v":0},{"$f":"IF(G15=0,\" \", IF(P15<O15, \"Downspout undersized!\", IF(O15=0, \"Gutter size too small!\", \"OK!\")))","v":" "},null,null,null,null,null,null,null,"Gutter Hangers","Downspout Brackets"]
[null,null,null,null,null,null,{"$f":"(B16*Reference!$M$48)/3600","v":0},null,null,null,{"$f":"IF(Reference!F18=10,IF(AND(ISNUMBER(I16),ISNUMBER(J16)),Reference!K18,0),(VLOOKUP(Reference!F18,Reference!$E$5:$J$14,6))*(E16^0.5))","v":0},{"$f":"IF(G16=0, \" \", IF(K16<G16, \"Gutter undersized!\", \"OK!\"))","v":" "},null,null,{"$f":"IF(ISNUMBER(B16),IF(Reference!N18=1,G16,G16/(Reference!N18)),\"\")","v":""},{"$f":"0.010457*(VLOOKUP(Reference!G18,Reference!$E$35:$G$50,3))*Reference!M18^0.5","v":0},{"$f":"IF(G16=0,\" \", IF(P16<O16, \"Downspout undersized!\", IF(O16=0, \"Gutter size too small!\", \"OK!\")))","v":" "},null,null,null,null,null,null,null,{"$f":"MOD(C14,Y17)","v":0},{"$f":"MOD(D14-IF(Reference!N39,6,0),Z17)","v":0}]
[null,null,null,null,null,null,{"$f":"(B17*Reference!$M$49)/3600","v":0},null,null,null,{"$f":"IF(Reference!F19=10,IF(AND(ISNUMBER(I17),ISNUMBER(J17)),Reference!K19,0),(VLOOKUP(Reference!F19,Reference!$E$5:$J$14,6))*(E17^0.5))","v":0},{"$f":"IF(G17=0, \" \", IF(K17<G17, \"Gutter undersized!\", \"OK!\"))","v":" "},null,null,{"$f":"IF(ISNUMBER(B17),IF(Reference!N19=1,G17,G17/(Reference!N19)),\"\")","v":""},{"$f":"0.010457*(VLOOKUP(Reference!G19,Reference!$E$35:$G$50,3))*Reference!M19^0.5","v":0},{"$f":"IF(G17=0,\" \", IF(P17<O17, \"Downspout undersized!\", IF(O17=0, \"Gutter size too small!\", \"OK!\")))","v":" "},null,null,null,null,null,null,null,2,10]
["Outlet Specification Section:  The values specified below will be used to fill out the standard drawing for each respective section of the design.  Design underground outlet or splash pad separately but report in this section.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y16>0,INT(C14/2)+2,INT(C14/2)+1)","v":1},{"$f":"(MAX(IF(Z16>0,2,1)+ROUNDDOWN((D14-IF(Reference!N39,6,0))/Z17,0),2)+IF(Reference!N39,2,0))*Reference!N16","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(C15,Y20)","v":0},{"$f":"MOD(D15-IF(Reference!N40,6,0),Z20)","v":0}]
["Gutter Name",null,null,null,"Gutter Name",null,null,null,"Gutter Name",null,null,null,"Gutter Name",null,null,null,null,null,null,null,null,null,null,null,2,10]
[{"$f":"IF(ISBLANK(A14),\"\",A14)","v":""},null,null,null,{"$f":"IF(ISBLANK(A15),\"\",A15)","v":""},null,null,null,{"$f":"IF(ISBLANK(A16),\"\",A16)","v":""},null,null,null,{"$f":"IF(ISBLANK(A17),\"\",A17)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y19>0,INT(C15/2)+2,INT(C15/2)+1)","v":1},{"$f":"(MAX(IF(Z19>0,2,1)+ROUNDDOWN((D15-IF(Reference!N40,6,0))/Z20,0),2)+IF(Reference!N40,2,0))*Reference!N17","v":2}]
["Outlet Style",{"$f":"IF(Reference!J39=1,\"\",\"Riser Type\")","v":"Riser Type"},null,null,"Outlet Style",{"$f":"IF(Reference!J40=1,\"\",\"Riser Type\")","v":"Riser Type"},null,null,"Outlet Style",{"$f":"IF(Reference!J41=1,\"\",\"Riser Type\")","v":"Riser Type"},null,null,"Outlet Style",{"$f":"IF(Reference!J42=1,\"\",\"Riser Type\")","v":"Riser Type"},null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(C16,Y23)","v":0},{"$f":"MOD(D16-IF(Reference!N41,6,0),Z23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y22>0,INT(C16/2)+2,INT(C16/2)+1)","v":1},{"$f":"(MAX(IF(Z22>0,2,1)+ROUNDDOWN((D16-IF(Reference!N41,6,0))/Z23,0),2)+IF(Reference!N41,2,0))*Reference!N18","v":2}]
["End Caps:",null,null,null,"End Caps:",null,null,null,"End Caps:",null,null,null,"End Caps:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(C17,Y26)","v":0},{"$f":"MOD(D17-IF(Reference!N42,6,0),Z26)","v":0}]
["Item","Unit","Quantity",null,"Item","Unit","Quantity",null,"Item","Unit","Quantity",null,"Item","Unit","Quantity",null,null,null,null,null,null,null,null,null,2,10]
[{"$f":"IF(Reference!$J$39=1,\"Splash Pad\", \"Elbow Elevation\")","v":"Elbow Elevation"},{"$f":"IF(Reference!$J$39=1,\"NO.\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$40=1,\"Splash Pad\", \"Elbow Elevation\")","v":"Elbow Elevation"},{"$f":"IF(Reference!$J$40=1,\"NO.\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$41=1,\"Splash Pad\", \"Elbow Elevation\")","v":"Elbow Elevation"},{"$f":"IF(Reference!$J$41=1,\"NO.\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$42=1,\"Splash Pad\", \"Elbow Elevation\")","v":"Elbow Elevation"},{"$f":"IF(Reference!$J$42=1,\"NO.\", \"FT.\")","v":"FT."},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y25>0,INT(C17/2)+2,INT(C17/2)+1)","v":1},{"$f":"(MAX(IF(Z25>0,2,1)+ROUNDDOWN((D17-IF(Reference!N42,6,0))/Z26,0),2)+IF(Reference!N42,2,0))*Reference!N19","v":2}]
[{"$f":"IF(Reference!$J$39=1,\"\", \"Outlet Elevation\")","v":"Outlet Elevation"},{"$f":"IF(Reference!$J$39=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$40=1,\"\", \"Outlet Elevation\")","v":"Outlet Elevation"},{"$f":"IF(Reference!$J$40=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$41=1,\"\", \"Outlet Elevation\")","v":"Outlet Elevation"},{"$f":"IF(Reference!$J$41=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$42=1,\"\", \"Outlet Elevation\")","v":"Outlet Elevation"},{"$f":"IF(Reference!$J$42=1,\"\", \"FT.\")","v":"FT."}]
[{"$f":"IF(Reference!$J$39=1,\"\", \"Diameter of Riser Unit\")","v":"Diameter of Riser Unit"},{"$f":"IF(Reference!$J$39=1,\"\", \"IN.\")","v":"IN."},null,null,{"$f":"IF(Reference!$J$40=1,\"\", \"Diameter of Riser Unit\")","v":"Diameter of Riser Unit"},{"$f":"IF(Reference!$J$40=1,\"\", \"IN.\")","v":"IN."},null,null,{"$f":"IF(Reference!$J$41=1,\"\", \"Diameter of Riser Unit\")","v":"Diameter of Riser Unit"},{"$f":"IF(Reference!$J$41=1,\"\", \"IN.\")","v":"IN."},null,null,{"$f":"IF(Reference!$J$42=1,\"\", \"Diameter of Riser Unit\")","v":"Diameter of Riser Unit"},{"$f":"IF(Reference!$J$42=1,\"\", \"IN.\")","v":"IN."}]
[{"$f":"IF(Reference!$J$39=1,\"\", \"Riser Height Including Elbow\")","v":"Riser Height Including Elbow"},{"$f":"IF(Reference!$J$39=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$40=1,\"\", \"Riser Height Including Elbow\")","v":"Riser Height Including Elbow"},{"$f":"IF(Reference!$J$40=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$41=1,\"\", \"Riser Height Including Elbow\")","v":"Riser Height Including Elbow"},{"$f":"IF(Reference!$J$41=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$42=1,\"\", \"Riser Height Including Elbow\")","v":"Riser Height Including Elbow"},{"$f":"IF(Reference!$J$42=1,\"\", \"FT.\")","v":"FT."}]
[{"$f":"IF(Reference!$J$39=1,\"\", \"Riser Height Above Ground\")","v":"Riser Height Above Ground"},{"$f":"IF(Reference!$J$39=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$40=1,\"\", \"Riser Height Above Ground\")","v":"Riser Height Above Ground"},{"$f":"IF(Reference!$J$40=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$41=1,\"\", \"Riser Height Above Ground\")","v":"Riser Height Above Ground"},{"$f":"IF(Reference!$J$41=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$42=1,\"\", \"Riser Height Above Ground\")","v":"Riser Height Above Ground"},{"$f":"IF(Reference!$J$42=1,\"\", \"FT.\")","v":"FT."}]
[{"$f":"IF(Reference!$J$39=1,\"\", \"Solid Riser Outlet Pipe Length\")","v":"Solid Riser Outlet Pipe Length"},{"$f":"IF(Reference!$J$39=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$40=1,\"\", \"Solid Riser Outlet Pipe Length\")","v":"Solid Riser Outlet Pipe Length"},{"$f":"IF(Reference!$J$40=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$41=1,\"\", \"Solid Riser Outlet Pipe Length\")","v":"Solid Riser Outlet Pipe Length"},{"$f":"IF(Reference!$J$41=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$42=1,\"\", \"Solid Riser Outlet Pipe Length\")","v":"Solid Riser Outlet Pipe Length"},{"$f":"IF(Reference!$J$42=1,\"\", \"FT.\")","v":"FT."}]
[{"$f":"IF(Reference!$J$39=1,\"\", \"Outlet conduit diameter\")","v":"Outlet conduit diameter"},{"$f":"IF(Reference!$J$39=1,\"\", \"IN.\")","v":"IN."},null,null,{"$f":"IF(Reference!$J$40=1,\"\", \"Outlet conduit diameter\")","v":"Outlet conduit diameter"},{"$f":"IF(Reference!$J$40=1,\"\", \"IN.\")","v":"IN."},null,null,{"$f":"IF(Reference!$J$41=1,\"\", \"Outlet conduit diameter\")","v":"Outlet conduit diameter"},{"$f":"IF(Reference!$J$41=1,\"\", \"IN.\")","v":"IN."},null,null,{"$f":"IF(Reference!$J$42=1,\"\", \"Outlet conduit diameter\")","v":"Outlet conduit diameter"},{"$f":"IF(Reference!$J$42=1,\"\", \"IN.\")","v":"IN."}]
[{"$f":"IF(Reference!$J$39=1,\"\", \"Underground conduit length\")","v":"Underground conduit length"},{"$f":"IF(Reference!$J$39=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$40=1,\"\", \"Underground conduit length\")","v":"Underground conduit length"},{"$f":"IF(Reference!$J$40=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$41=1,\"\", \"Underground conduit length\")","v":"Underground conduit length"},{"$f":"IF(Reference!$J$41=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$42=1,\"\", \"Underground conduit length\")","v":"Underground conduit length"},{"$f":"IF(Reference!$J$42=1,\"\", \"FT.\")","v":"FT."}]
[{"$f":"IF(Reference!$J$39=1,\"\", \"Solid Outlet Pipe Length\")","v":"Solid Outlet Pipe Length"},{"$f":"IF(Reference!$J$39=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$40=1,\"\", \"Solid Outlet Pipe Length\")","v":"Solid Outlet Pipe Length"},{"$f":"IF(Reference!$J$40=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$41=1,\"\", \"Solid Outlet Pipe Length\")","v":"Solid Outlet Pipe Length"},{"$f":"IF(Reference!$J$41=1,\"\", \"FT.\")","v":"FT."},null,null,{"$f":"IF(Reference!$J$42=1,\"\", \"Solid Outlet Pipe Length\")","v":"Solid Outlet Pipe Length"},{"$f":"IF(Reference!$J$42=1,\"\", \"FT.\")","v":"FT."}]

{"sheet":"Design Summary","index":2,"n_rows":38,"n_cols":69,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,68,5,69],[4,10,5,13],[4,14,5,15],[4,32,5,33],[11,22,11,25],[11,58,11,61],[11,40,11,43],[5,41,5,42],[4,50,5,51],[12,65,12,69],[11,4,11,7],[18,2,18,15],[9,2,9,7],[9,9,9,15],[9,27,9,33],[9,45,9,51],[18,20,18,33],[9,38,9,43],[20,2,20,15],[27,2,27,15],[1,5,1,7],[1,8,1,11],[9,20,9,25],[3,2,3,7],[3,9,3,15],[6,10,6,11],[5,3,5,4],[6,3,6,4],[4,5,4,6],[5,5,5,6],[6,5,6,6],[20,20,20,33],[27,20,27,33],[1,23,1,25],[1,26,1,29],[3,20,3,25],[3,27,3,33],[4,23,4,24],[5,21,5,22],[5,23,5,24],[4,28,5,31],[20,38,20,51],[27,38,27,51],[20,56,20,69],[27,56,27,69],[1,41,1,43],[18,38,18,51],[18,56,18,69],[6,46,6,47],[9,63,9,69],[6,57,6,58],[6,59,6,60],[6,64,6,65],[9,56,9,61],[4,64,5,67],[4,46,5,49],[1,59,1,61],[1,62,1,65],[6,21,6,22],[6,23,6,24],[6,28,6,29],[6,39,6,40],[6,41,6,42],[3,56,3,61],[3,63,3,69],[4,59,4,60],[5,57,5,58],[5,59,5,60],[1,44,1,47],[3,38,3,43],[3,45,3,51],[4,41,4,42],[5,39,5,40]]}
[]
[null,null,null,null,null,"Gutter Name:",null,null,{"$f":"IF(ISBLANK(Design!A14),\"\",Design!A14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gutter Name:",null,null,{"$f":"IF(ISBLANK(Design!A15),\"\",Design!A15)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gutter Name:",null,null,{"$f":"IF(ISBLANK(Design!A16),\"\",Design!A16)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gutter Name:",null,null,{"$f":"IF(ISBLANK(Design!A17),\"\",Design!A17)","v":""}]
[]
[null,null,"Roof Information",null,null,null,null,null,null,"Storm Event",null,null,null,null,null,null,null,null,null,null,"Roof Information",null,null,null,null,null,null,"Storm Event",null,null,null,null,null,null,null,null,null,null,"Roof Information",null,null,null,null,null,null,"Storm Event",null,null,null,null,null,null,null,null,null,null,"Roof Information",null,null,null,null,null,null,"Storm Event"]
[null,null,null,"Detail",null,"Amount",null,"Unit",null,null,{"$f":"IF(Reference!$L$46=1,Reference!$J$46,Reference!$J$47)&\" Storm:\"","v":"25-year, 5 minute Storm:"},null,null,null,{"$f":"IF(Reference!$L$46=1,Design!$C$10,Design!$C$9)","v":0.74},null,null,null,null,null,null,"Detail",null,"Amount",null,"Unit",null,null,{"$f":"IF(Reference!$L$47=1,Reference!$J$46,Reference!$J$47)&\" Storm:\"","v":"25-year, 5 minute Storm:"},null,null,null,{"$f":"IF(Reference!$L$47=1,Design!$C$10,Design!$C$9)","v":0.74},null,null,null,null,null,null,"Detail",null,"Amount",null,"Unit",null,null,{"$f":"IF(Reference!$L$48=1,Reference!$J$46,Reference!$J$47)&\" Storm:\"","v":"25-year, 5 minute Storm:"},null,null,null,{"$f":"IF(Reference!$L$48=1,Design!$C$10,Design!$C$9)","v":0.74},null,null,null,null,null,null,"Detail",null,"Amount",null,"Unit",null,null,{"$f":"IF(Reference!$L$49=1,Reference!$J$46,Reference!$J$47)&\" Storm:\"","v":"25-year, 5 minute Storm:"},null,null,null,{"$f":"IF(Reference!$L$49=1,Design!$C$10,Design!$C$9)","v":0.74}]
[null,null,null,"Roof Area",null,{"$f":"IF(ISBLANK(Design!$B$14),\"\",Design!$B$14)","v":""},null,"SQ. FT.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof Area",null,{"$f":"IF(ISBLANK(Design!$B$15),\"\",Design!$B$15)","v":""},null,"SQ. FT.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof Area",null,{"$f":"IF(ISBLANK(Design!$B$16),\"\",Design!$B$16)","v":""},null,"SQ. FT.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof Area",null,{"$f":"IF(ISBLANK(Design!$B$17),\"\",Design!$B$17)","v":""},null,"SQ. FT."]
[null,null,null,"Gutter Length",null,{"$f":"IF(ISBLANK(Design!$C$14),\"\",Design!$C$14)","v":""},null,"FT.",null,null,"Roof Flow:",null,{"$f":"Design!$G$14","v":0},"C.F.S",null,null,null,null,null,null,null,"Gutter Length",null,{"$f":"IF(ISBLANK(Design!$C$15),\"\",Design!$C$15)","v":""},null,"FT.",null,null,"Roof Flow:",null,{"$f":"Design!$G$15","v":0},"C.F.S",null,null,null,null,null,null,null,"Gutter Length",null,{"$f":"IF(ISBLANK(Design!$C$16),\"\",Design!$C$16)","v":""},null,"FT.",null,null,"Roof Flow:",null,{"$f":"Design!$G$16","v":0},"C.F.S",null,null,null,null,null,null,null,"Gutter Length",null,{"$f":"IF(ISBLANK(Design!$C$17),\"\",Design!$C$17)","v":""},null,"FT.",null,null,"Roof Flow:",null,{"$f":"Design!$G$17","v":0},"C.F.S"]
[]
[]
[null,null,"Gutter Material Quantities",null,null,null,null,null,null,"Downspout Material Quantities",null,null,null,null,null,null,null,null,null,null,"Gutter Material Quantities",null,null,null,null,null,null,"Downspout Material Quantities",null,null,null,null,null,null,null,null,null,null,"Gutter Material Quantities",null,null,null,null,null,null,"Downspout Material Quantities",null,null,null,null,null,null,null,null,null,null,"Gutter Material Quantities",null,null,null,null,null,null,"Downspout Material Quantities"]
[]
[null,null,{"$f":"IF(ISBLANK(Design!A14),\"\", IF(Reference!$J$39=1,Labels!G31, Labels!B31))","v":""},"FT. of",{"$f":"IF(ISBLANK(Design!A14),\"\", IF(Reference!J39=1, Labels!G25 & \" Gutter\", Labels!B25 & \" Gutter\"))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A14),\"\", IF(Reference!$J$39=1,Labels!G32, Labels!B32))","v":""},"Downspouts",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A15),\"\", IF(Reference!$J$40=1,Labels!H31, Labels!C31))","v":""},"FT. of",{"$f":"IF(ISBLANK(Design!A15),\"\", IF(Reference!J40=1, Labels!H25 & \" Gutter\", Labels!C25 & \" Gutter\"))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A15),\"\", IF(Reference!$J$40=1,Labels!H32, Labels!C32))","v":""},"Downspouts",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A16),\"\", IF(Reference!$J$41=1,Labels!I31, Labels!D31))","v":""},"FT. of",{"$f":"IF(ISBLANK(Design!A16),\"\", IF(Reference!J41=1, Labels!I25 & \" Gutter\", Labels!D25 & \" Gutter\"))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$A$16),\"\",Reference!$N$18)","v":""},"Downspouts",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A17),\"\", IF(Reference!$J$42=1,Labels!J31, Labels!E31))","v":""},"FT. of",{"$f":"IF(ISBLANK(Design!A17),\"\", IF(Reference!J42=1, Labels!J25 & \" Gutter\", Labels!E25 & \" Gutter\"))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$A$17),\"\",Reference!$N$19)","v":""},"Downspouts"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A14),\"\", IF(Reference!$J$39=1,Labels!G17, Labels!B17))","v":""},"FT. of ",{"$f":"IF(ISBLANK(Design!$A$14),\"\",IF(Reference!J39=1, Labels!$G26&\" Downspout, per DS\", Labels!$B26&\" Downspout, per DS\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A15),\"\", IF(Reference!$J$40=1,Labels!H17, Labels!C17))","v":""},"FT. of ",{"$f":"IF(ISBLANK(Design!$A$15),\"\",IF(Reference!J40=1, Labels!$H26&\" Downspout, per DS\", Labels!$C26&\" Downspout, per DS\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A16),\"\", IF(Reference!$J$41=1,Labels!I17, Labels!D17))","v":""},"FT. of ",{"$f":"IF(ISBLANK(Design!$A$16),\"\",IF(Reference!J41=1, Labels!$I26&\" Downspout, per DS\", Labels!$D26&\" Downspout, per DS\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A17),\"\", IF(Reference!$J$42=1,Labels!J17, Labels!E17))","v":""},"FT. of ",{"$f":"IF(ISBLANK(Design!$A$17),\"\",IF(Reference!J42=1, Labels!$J26&\" Downspout, per DS\", Labels!$E26&\" Downspout, per DS\"))","v":""}]
[null,null,"Requires:",{"$f":"IF(ISBLANK(Design!A14),\"\", IF(Reference!$J$39=1,Labels!G14, Labels!B14))","v":""},"EA. Gutter End Caps",null,null,null,null,null,"Requires:",{"$f":"IF(ISBLANK(Design!A14),\"\", IF(Reference!$J$39=1,Labels!G20, Labels!B20))","v":""},"EA.  Support Brackets (Total)",null,null,null,null,null,null,null,"Requires:",{"$f":"IF(ISBLANK(Design!A15),\"\", IF(Reference!$J$40=1,Labels!H14, Labels!C14))","v":""},"EA. Gutter End Caps",null,null,null,null,null,"Requires:",{"$f":"IF(ISBLANK(Design!A15),\"\", IF(Reference!$J$40=1,Labels!H20, Labels!C20))","v":""},"EA.  Support Brackets (Total)",null,null,null,null,null,null,null,"Requires:",{"$f":"IF(ISBLANK(Design!A16),\"\", IF(Reference!$J$41=1,Labels!I14, Labels!D14))","v":""},"EA. Gutter End Caps",null,null,null,null,null,"Requires:",{"$f":"IF(ISBLANK(Design!A16),\"\", IF(Reference!$J$41=1,Labels!I20, Labels!D20))","v":""},"EA.  Support Brackets (Total)",null,null,null,null,null,null,null,"Requires:",{"$f":"IF(ISBLANK(Design!A17),\"\", IF(Reference!$J$42=1,Labels!J14, Labels!E14))","v":""},"EA. Gutter End Caps",null,null,null,null,null,"Requires:",{"$f":"IF(ISBLANK(Design!A17),\"\", IF(Reference!$J$42=1,Labels!J20, Labels!E20))","v":""},"EA.  Support Brackets (Total)"]
[null,null,null,{"$f":"IF(ISBLANK(Design!A14),\"\", IF(Reference!$J$39=1,Labels!G15, Labels!B15))","v":""},"EA. Gutter Hanger Straps",null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A14),\"\", IF(Reference!$J$39=1,Labels!G19, Labels!B19))","v":""},"EA.  Elbows (per DS)",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A15),\"\", IF(Reference!$J$40=1,Labels!H15, Labels!C15))","v":""},"EA. Gutter Hanger Straps",null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A15),\"\", IF(Reference!$J$40=1,Labels!H19, Labels!C19))","v":""},"EA.  Elbows (per DS)",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A16),\"\", IF(Reference!$J$41=1,Labels!I15, Labels!D15))","v":""},"EA. Gutter Hanger Straps",null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A16),\"\", IF(Reference!$J$41=1,Labels!I19, Labels!D19))","v":""},"EA.  Elbows (per DS)",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A17),\"\", IF(Reference!$J$42=1,Labels!J15, Labels!E15))","v":""},"EA. Gutter Hanger Straps",null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A17),\"\", IF(Reference!$J$42=1,Labels!J19, Labels!E19))","v":""},"EA.  Elbows (per DS)"]
[]
[null,null,{"$f":"IF(ISBLANK(Design!A14),\"\", IF(Reference!$J$39=1,Labels!G16, Labels!B16))","v":""},"FT of 1\" x",{"$f":"IF(ISBLANK(Design!A14),\"\",IF(Reference!J39=1, Labels!$G28&\"\"\"\", Labels!$B28&\"\"\"\"))","v":""},"Fascia Board",null,null,null,{"$f":"IF(ISBLANK(Design!$A$14),\"\",IF(Reference!J39=1, \"\",Labels!B21))","v":""},{"$f":"IF(Reference!$J$39=2,\"FT. of\", \"\")","v":"FT. of"},{"$f":"IF(ISBLANK(Design!$A$14),\"\",IF(Reference!J39=1, \"\", IF(Reference!M39=1, Labels!B29&\"in. PVC Riser\", IF(Reference!M39=2, Labels!B30&\"in. CMP Riser\", \"\"))))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!A15),\"\", IF(Reference!$J$40=1,Labels!H16, Labels!C16))","v":""},"FT of 1\" x",{"$f":"IF(ISBLANK(Design!A15),\"\",IF(Reference!J40=1, Labels!$H28&\"\"\"\", Labels!$C28&\"\"\"\"))","v":""},"Fascia Board",null,null,null,{"$f":"IF(ISBLANK(Design!$A$15),\"\",IF(Reference!J40=1, \"\",Labels!C21))","v":""},{"$f":"IF(Reference!$J$40=2,\"FT. of\", \"\")","v":"FT. of"},{"$f":"IF(ISBLANK(Design!$A$15),\"\",IF(Reference!J40=1, \"\", IF(Reference!M40=1, Labels!C29&\"in. PVC Riser\", IF(Reference!M40=2, Labels!C30&\"in. CMP Riser\", \"\"))))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Labels!$D16),\"\",Labels!$D16)","v":""},"FT of 1\" x",{"$f":"IF(ISBLANK(Design!A16),\"\",IF(Reference!J41=1, Labels!$I28&\"\"\"\", Labels!$D28&\"\"\"\"))","v":""},"Fascia Board",null,null,null,{"$f":"IF(ISBLANK(Design!$A$16),\"\",IF(Reference!J41=1, \"\",Labels!D21))","v":""},{"$f":"IF(Reference!$J$41=2,\"FT. of\", \"\")","v":"FT. of"},null,{"$f":"IF(ISBLANK(Design!$A$16),\"\",IF(Reference!J41=1, \"\", IF(Reference!M41=1, Labels!D29&\"in. PVC Riser\", IF(Reference!M41=2, Labels!D30&\"in. CMP Riser\", \"\"))))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Labels!$E16),\"\",Labels!$E16)","v":""},"FT of 1\" x",{"$f":"IF(ISBLANK(Design!A17),\"\",IF(Reference!J42=1, Labels!$J28&\"\"\"\", Labels!$E28&\"\"\"\"))","v":""},"Fascia Board",null,null,null,{"$f":"IF(ISBLANK(Design!$A$17),\"\",IF(Reference!J42=1, \"\",Labels!E21))","v":""},{"$f":"IF(Reference!$J$42=2,\"FT. of\", \"\")","v":"FT. of"},null,{"$f":"IF(ISBLANK(Design!$A$17),\"\",IF(Reference!J42=1, \"\", IF(Reference!M42=1, Labels!E29&\"in. PVC Riser\", IF(Reference!M42=2, Labels!E30&\"in. CMP Riser\", \"\"))))","v":""}]
[]
[null,null,"Outlet Material Quantities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outlet Material Quantities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outlet Material Quantities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outlet Material Quantities"]
[]
[null,null,{"$f":"IF(Reference!$J$39=2,\"Riser\", \"Above Ground Outlet\")","v":"Riser"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$40=2,\"Riser\", \"Above Ground Outlet\")","v":"Riser"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$41=2,\"Riser\", \"Above Ground Outlet\")","v":"Riser"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$42=2,\"Riser\", \"Above Ground Outlet\")","v":"Riser"}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!C$27),\"\",IF(Reference!$J$39=2,Labels!$B6,Labels!G13))","v":""},{"$f":"IF(Reference!$J$39=2,\"IN. Riser Diam.\", \"No of Splash Pads\")","v":"IN. Riser Diam."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$G27),\"\",IF(Reference!$J$40=2,Labels!$C6, Labels!H13))","v":""},{"$f":"IF(Reference!$J$40=2,\"IN. Riser Diam.\", \"No of Splash Pads\")","v":"IN. Riser Diam."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$K27),\"\",IF(Reference!$J$41=2,Labels!$D6,Labels!I13))","v":""},{"$f":"IF(Reference!$J$41=2,\"IN. Riser Diam.\", \"No of Splash Pads\")","v":"IN. Riser Diam."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$O27),\"\",IF(Reference!$J$42=2,Labels!$E6,Labels!J13))","v":""},{"$f":"IF(Reference!$J$42=2,\"IN. Riser Diam.\", \"No of Splash Pads\")","v":"IN. Riser Diam."}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Labels!$B21),\"\",Labels!$B21)","v":""},{"$f":"IF(Reference!$J$39=2,\"FT. Riser Unit with Elbow\", \"\")","v":"FT. Riser Unit with Elbow"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Labels!$C21),\"\",Labels!$C21)","v":""},{"$f":"IF(Reference!$J$40=2,\"FT. Riser Unit with Elbow\", \"\")","v":"FT. Riser Unit with Elbow"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!K28),\"\",IF(Reference!$J$41=2,Labels!$D21,Design!$K28))","v":""},{"$f":"IF(Reference!$J$41=2,\"FT. Riser Unit with Elbow\", \"\")","v":"FT. Riser Unit with Elbow"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!O28),\"\",IF(Reference!$J$42=2,Labels!$E21, Design!$O28))","v":""},{"$f":"IF(Reference!$J$42=2,\"FT. Riser Unit with Elbow\", \"\")","v":"FT. Riser Unit with Elbow"}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!C$29),\"\",IF(Reference!$J$39=2,Labels!$B9,\"\"))","v":""},{"$f":"IF(Reference!$J$39=2,\"FT. Solid Riser Outlet Pipe\", \"\")","v":"FT. Solid Riser Outlet Pipe"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!G$29),\"\",IF(Reference!$J$40=2,Labels!$C9,\"\"))","v":""},{"$f":"IF(Reference!$J$40=2,\"FT. Solid Riser Outlet Pipe\", \"\")","v":"FT. Solid Riser Outlet Pipe"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!K28),\"\",IF(Reference!$J$41=2,Labels!$D9,Design!$K29))","v":""},{"$f":"IF(Reference!$J$41=2,\"FT. Solid Riser Outlet Pipe\", \"\")","v":"FT. Solid Riser Outlet Pipe"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!O28),\"\",IF(Reference!$J$42=2,Labels!$E9,Design!$O29))","v":""},{"$f":"IF(Reference!$J$42=2,\"FT. Solid Riser Outlet Pipe\", \"\")","v":"FT. Solid Riser Outlet Pipe"}]
[null,null,null,null,null,null,{"$f":"IF(Reference!$J$39=2,\"Elbow Elevation:\", \"\")","v":"Elbow Elevation:"},{"$f":"IF(ISBLANK(Design!C$30),\"\",IF(Reference!$J$39=2,Labels!$B4,\"\"))","v":""},{"$f":"IF(Reference!$J$39=2,\"FT.\", \"\")","v":"FT."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$40=2,\"Elbow Elevation:\", \"\")","v":"Elbow Elevation:"},{"$f":"IF(ISBLANK(Design!G$30),\"\",IF(Reference!$J$40=2,Labels!$C4,\"\"))","v":""},{"$f":"IF(Reference!$J$40=2,\"FT.\", \"\")","v":"FT."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$41=2,\"Elbow Elevation:\", \"\")","v":"Elbow Elevation:"},{"$f":"IF(ISBLANK(Design!K28),\"\",IF(Reference!$J$41=2,Labels!$D4,Design!$K30))","v":""},{"$f":"IF(Reference!$J$41=2,\"FT.\", \"\")","v":"FT."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$42=2,\"Elbow Elevation:\", \"\")","v":"Elbow Elevation:"},{"$f":"IF(ISBLANK(Design!O28),\"\",IF(Reference!$J$42=2,Labels!$E4,Design!$O30))","v":""},{"$f":"IF(Reference!$J$42=2,\"FT.\", \"\")","v":"FT."}]
[]
[null,null,{"$f":"IF(Reference!$J$39=2,\"Underground Outlet\", \"\")","v":"Underground Outlet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$40=2,\"Underground Outlet\", \"\")","v":"Underground Outlet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$41=2,\"Underground Outlet\", \"\")","v":"Underground Outlet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$42=2,\"Underground Outlet\", \"\")","v":"Underground Outlet"}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!C$27),\"\",IF(Reference!$J$39=2,Labels!$B10,\"\"))","v":""},{"$f":"IF(Reference!$J$39=2,\"IN. Diam Conduit\", \"\")","v":"IN. Diam Conduit"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$G27),\"\",IF(Reference!$J$40=2,Labels!$C10,\"\"))","v":""},{"$f":"IF(Reference!$J$40=2,\"IN. Diam Conduit\", \"\")","v":"IN. Diam Conduit"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$K27),\"\",IF(Reference!$J$41=2,Labels!$D10,\"\"))","v":""},{"$f":"IF(Reference!$J$41=2,\"IN. Diam Conduit\", \"\")","v":"IN. Diam Conduit"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$O27),\"\",IF(Reference!$J$42=2,Labels!$E10,\"\"))","v":""},{"$f":"IF(Reference!$J$42=2,\"IN. Diam Conduit\", \"\")","v":"IN. Diam Conduit"}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!C$27),\"\",IF(Reference!$J$39=2,Labels!$B$11, \"\"))","v":""},{"$f":"IF(Reference!$J$39=2,\"FT. of\", \"\")","v":"FT. of"},null,null,null,null,null,{"$f":"IF(ISBLANK(Design!C$27),\"\",IF(Reference!$J$39=2,Reference!$I$53,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$G27),\"\",IF(Reference!$J$40=2,Labels!$C$11, \"\"))","v":""},{"$f":"IF(Reference!$J$40=2,\"FT. of\", \"\")","v":"FT. of"},null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$G27),\"\",IF(Reference!$J$40=2,Reference!$I$54,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$K27),\"\",IF(Reference!$J$41=2,Labels!$D$11, \"\"))","v":""},{"$f":"IF(Reference!$J$41=2,\"FT. of\", \"\")","v":"FT. of"},null,null,null,null,null,{"$f":"IF(ISBLANK(Reference!H53),\"\",IF(Reference!$J$41=2,Reference!$I$55,\"\"))","v":"Conduit Material"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$O27),\"\",IF(Reference!$J$42=2,Labels!$E$11, \"\"))","v":""},{"$f":"IF(Reference!$J$42=2,\"FT. of\", \"\")","v":"FT. of"},null,null,null,null,null,{"$f":"IF(ISBLANK(Reference!H53),\"\",IF(Reference!$J$42=2,Reference!$I$56,\"\"))","v":"Conduit Material"}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!C$27),\"\",IF(Reference!$J$39=2,Labels!$B$12,\"\"))","v":""},{"$f":"IF(Reference!$J$39=2,\"FT. of Solid Outlet Pipe\", \"\")","v":"FT. of Solid Outlet Pipe"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$G27),\"\",IF(Reference!$J$40=2,Labels!$C$12,\"\"))","v":""},{"$f":"IF(Reference!$J$40=2,\"FT. of Solid Outlet Pipe\", \"\")","v":"FT. of Solid Outlet Pipe"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$K27),\"\",IF(Reference!$J$41=2,Labels!$D$12,\"\"))","v":""},{"$f":"IF(Reference!$J$41=2,\"FT. of Solid Outlet Pipe\", \"\")","v":"FT. of Solid Outlet Pipe"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Design!$O27),\"\",IF(Reference!$J$42=2,Labels!$E$12,\"\"))","v":""},{"$f":"IF(Reference!$J$42=2,\"FT. of Solid Outlet Pipe\", \"\")","v":"FT. of Solid Outlet Pipe"}]
[null,null,null,null,null,null,{"$f":"IF(Reference!$J$39=2,\"Outlet Elevation:\", \"\")","v":"Outlet Elevation:"},{"$f":"IF(ISBLANK(Design!C$27),\"\",IF(Reference!$J$39=2,Labels!$B5,\"\"))","v":""},{"$f":"IF(Reference!$J$39=2,\"FT.\", \"\")","v":"FT."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$40=2,\"Outlet Elevation:\", \"\")","v":"Outlet Elevation:"},{"$f":"IF(ISBLANK(Design!$G27),\"\",IF(Reference!$J$40=2,Labels!$C5,\"\"))","v":""},{"$f":"IF(Reference!$J$40=2,\"FT.\", \"\")","v":"FT."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$41=2,\"Outlet Elevation:\", \"\")","v":"Outlet Elevation:"},{"$f":"IF(ISBLANK(Design!$K27),\"\",IF(Reference!$J$41=2,Labels!$D5,\"\"))","v":""},{"$f":"IF(Reference!$J$41=2,\"FT.\", \"\")","v":"FT."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Reference!$J$42=2,\"Outlet Elevation:\", \"\")","v":"Outlet Elevation:"},{"$f":"IF(ISBLANK(Design!$O27),\"\",IF(Reference!$J$42=2,Labels!$E5,\"\"))","v":""},{"$f":"IF(Reference!$J$42=2,\"FT.\", \"\")","v":"FT."}]
[]
[]
[]
[]
[null,null,"Notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes"]

{"sheet":"Plan Map","index":3,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"LANDUSER",null,null,null,null,"LOCATION"]

{"sheet":"IA-1571 Drawings","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"IA-1572 Drawings","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Specs-O&M","index":6,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":true,"merged":[[53,0,53,9],[44,0,44,9],[45,0,45,9],[46,0,46,9],[47,0,47,9],[48,0,48,9],[49,0,49,9],[42,0,42,9],[43,0,43,9],[50,0,50,9],[51,0,51,9],[52,0,52,9],[37,0,37,9],[38,0,38,9],[39,0,39,9],[40,0,40,9],[41,0,41,9],[32,0,32,9],[33,0,33,9],[34,0,34,9],[35,0,35,9],[36,0,36,9],[27,0,27,9],[28,0,28,9],[29,0,29,9],[30,0,30,9],[31,0,31,9],[22,0,22,9],[23,0,23,9],[24,0,24,9],[25,0,25,9],[26,0,26,9],[17,0,17,9],[18,0,18,9],[19,0,19,9],[20,0,20,9],[21,0,21,9],[12,0,12,9],[13,0,13,9],[14,0,14,9],[15,0,15,9],[16,0,16,9],[7,0,7,9],[8,0,8,9],[9,0,9,9],[10,0,10,9],[11,0,11,9],[0,0,0,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[6,0,6,9],[37,10,37,19],[38,10,38,19],[39,10,39,19],[40,10,40,19],[41,10,41,19]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Additional Details:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NRCS, Iowa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"February, 2012"]

{"sheet":"Reference","index":7,"n_rows":109,"n_cols":31,"rows_kept":109,"cut":false,"hidden":false,"merged":[[30,16,30,18],[24,16,24,17],[14,16,14,17],[15,16,15,17],[16,16,16,17],[17,16,17,17],[18,16,18,17],[0,1,0,3],[15,14,15,15],[16,14,16,15],[17,14,17,15],[18,14,18,15],[14,14,14,15]]}
[null,"NOAA Atlas 14 Rainfall Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"These numbers are as harvested from NOAA (not rounded off)"]
[null,"County","Rainfall 25yr, 5min, in","Rainfall 10yr, 5 min, in",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rainfall 25yr, 5min, in","Rainfall 10yr, 5 min, in"]
[1,"ADAIR",{"$f":"ROUND(AD3,2)","v":0.74},{"$f":"ROUND(AE3,2)","v":0.65},"Note: Area and wetted perimeter numbers based on calculations by Matt Robert 7/2/13",null,null,null,null,null,null,"Manning's n",null,null,"JOB CLASS",1,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73886473522600005,0.64697896453899995]
[{"$f":"A3+1","v":2},"ADAMS",{"$f":"ROUND(AD4,2)","v":0.74},0.66,"Gutters",null,null,null,null,"Qgutter, cfs (without s)",null,1.2E-2,null,1,"Job Class",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73961697762599998,0.65777846880799995]
[{"$f":"A4+1","v":3},"ALLAMAKEE",0.73,0.64,1,null,"Area, in2","Wetted Per., in","r, in",null,"Depth, in",null,null,2,"I",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73226411745099995,0.64107419736000004]
[4,"APPANOOSE",0.7,0.61,2,"5\" K-Style ",12.68,10.11,{"$f":"G6/H6","v":1.2542037586547972},{"$f":"(1.486/$L$4)*(G6/144)*((I6/12)^(2/3))","v":2.4194624862595044},3.625,null,null,3,"II",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.69873344778799995,0.61357491284300003]
[5,"AUDUBON",0.73,0.64,3,"6\" K-Style ",20.23,12.8,1.5804687499999999,{"$f":"(1.486/$L$4)*(G7/144)*((I7/12)^(2/3))","v":4.5034021632567001},4.625,null,null,4,"III",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73417085319300002,0.64273366441900004]
[6,"BENTON ",0.74,0.64,4,"7\" K-Style ",31.64,16.2,1.9530864197530866,8.1109493413424829,6,null,null,5,"IV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73850698577499996,0.64112945633899998]
[7,"BLACK HAWK",0.72,0.63,5,"8\" K-Style",43.3,18.98,2.2799999999999998,12.306428560500349,7,null,null,6,"V",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72186294066400003,0.62953651558699997]
[8,"BOONE",0.75,0.65,6,"4\" Half-Round",4.28,5.3,0.8075471698113208,0.60894295334536652,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74987117526000002,0.64711246054899996]
[9,"BREMER ",0.73,0.64,7,"6\" Half-Round",11.1,8.4,1.3214285714285714,2.1930052995742115,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.734982690148,0.64397802881499999]
[10,"BUCHANAN",0.74,0.64,8,"8\" Half-Round",21.1,11.6,1.8189655172413794,5.1584553201478558,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73730977775499995,0.64451169171800005]
[11,"BUENA VISTA",0.73,0.64,9,"10\" Half-Round",34.299999999999997,14.7,2.333333333333333,9.8999473322508678,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72963965187000002,0.63869953153400005]
[12,"BUTLER",0.72,0.63,10,"Custom Rect.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.71995270576600001,0.63014598516700004]
[13,"CALHOUN",0.73,0.64,null,"Gutter Style #","Downspout Style #","Gutter Depth, in","Gutter Width, in","Custom r, in","Custom Q","Custom Depth","Head, in","# of Downspouts","Gutter Name",null,"Downspout Name",null,"custom flag","Page #",null,null,"Area, in2","Wetted Per., in","r, in","r, in","Depth, in",null,null,0.72557260609200003,0.63638118873299998]
[14,"CARROLL",0.74,0.64,"Chosen:",1,1,{"$f":"IF(ISNUMBER(Design!I14),Design!I14,\"\")","v":""},{"$f":"IF(ISNUMBER(Design!J14),Design!J14,\"\")","v":""},{"$f":"(H16-0.5)*I16/((H16-0.5)+(H16-0.5)+I16)","v":{"$error":"#VALUE!"}},{"$f":"(1.486/$L$4)*((H16-0.5)/12)*(I16/12)*((J16/12)^(2/3))*Design!E14^(1/2)","v":{"$error":"#VALUE!"}},{"$f":"Design!I14","v":0},{"$f":"IF(Design!K14>0,((IF(F16=10,L16,VLOOKUP(F16,$E$6:$K$14,7)))-0.5),0)","v":0},1,{"$f":"IF(S16=1,VLOOKUP(F16,$E$5:$K$14,2),H16&\" in. x \"&I16&\" in. Rectangular\")","v":0},null,{"$f":"VLOOKUP(G16,$E$35:$G$49,2)","v":0},null,{"$f":"IF(F16=10,0,1)","v":1},{"$f":"IF(F16>1,1,0)","v":0},{"$f":"IF(T16=1,1,\"\")","v":""},{"$f":"U16&\" of \"&$T$20","v":" of 0"},{"$f":"_xlfn.XLOOKUP(F16, $E6:$E14, $G6:$G14)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(F16, $E6:$E14, $H6:$H14)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.XLOOKUP(F16, $E6:$E14, $I6:$I14)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(F16, $E6:$E14, $K6:$K14)","v":{"$error":"#N/A"}},null,null,0.73723721650499996,0.64496932472799995]
[15,"CASS",0.72,0.64,null,1,1,{"$f":"IF(ISNUMBER(Design!I15),Design!I15,\"\")","v":""},{"$f":"IF(ISNUMBER(Design!J15),Design!J15,\"\")","v":""},{"$f":"(H17-0.5)*I17/((H17-0.5)+(H17-0.5)+I17)","v":{"$error":"#VALUE!"}},{"$f":"(1.486/$L$4)*((H17-0.5)/12)*(I17/12)*((J17/12)^(2/3))*Design!E15^(1/2)","v":{"$error":"#VALUE!"}},{"$f":"Design!I15","v":0},{"$f":"IF(Design!K15>0,((IF(F17=10,L17,VLOOKUP(F17,$E$6:$K$14,7)))-0.5),0)","v":0},1,{"$f":"IF(S17=1,VLOOKUP(F17,$E$5:$K$14,2),H17&\" in. x \"&I17&\" in. Rectangular\")","v":0},null,{"$f":"VLOOKUP(G17,$E$35:$G$49,2)","v":0},null,{"$f":"IF(F17=10,0,1)","v":1},{"$f":"IF(F17>1,1,0)","v":0},{"$f":"IF(T17=1,2,\"\")","v":""},{"$f":"U17&\" of \"&$T$20","v":" of 0"},{"$f":"_xlfn.XLOOKUP(F17, $E6:$E14, $G6:$G14)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(F17, E6:E14, H6:H14)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.XLOOKUP(F17, $E6:$E14, $I6:$I14)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(F17, $E6:$E14, $K6:$K14)","v":{"$error":"#N/A"}},null,null,0.72471219857000002,0.63502318288899995]
[16,"CEDAR",0.7,0.61,null,1,1,{"$f":"IF(ISNUMBER(Design!I16),Design!I16,\"\")","v":""},{"$f":"IF(ISNUMBER(Design!J16),Design!J16,\"\")","v":""},{"$f":"(H18-0.5)*I18/((H18-0.5)+(H18-0.5)+I18)","v":{"$error":"#VALUE!"}},{"$f":"(1.486/$L$4)*((H18-0.5)/12)*(I18/12)*((J18/12)^(2/3))*Design!E16^(1/2)","v":{"$error":"#VALUE!"}},{"$f":"Design!I16","v":0},{"$f":"IF(Design!K16>0,((IF(F18=10,L18,VLOOKUP(F18,$E$6:$K$14,7)))-0.5),0)","v":0},1,{"$f":"IF(S18=1,VLOOKUP(F18,$E$5:$K$14,2),H18&\" in. x \"&I18&\" in. Rectangular\")","v":0},null,{"$f":"VLOOKUP(G18,$E$35:$G$49,2)","v":0},null,{"$f":"IF(F18=10,0,1)","v":1},{"$f":"IF(F18>1,1,0)","v":0},{"$f":"IF(T18=1,3,\"\")","v":""},{"$f":"U18&\" of \"&$T$20","v":" of 0"},{"$f":"_xlfn.XLOOKUP(F18, $E6:$E14, $G6:$G14)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(F18, E6:E14, H6:H14)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.XLOOKUP(F18, $E6:$E14, $I6:$I14)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(F18, $E6:$E14, $K6:$K14)","v":{"$error":"#N/A"}},null,null,0.700489173799,0.61084639195000001]
[17,"CERRO GORDO",0.72,0.63,null,1,1,{"$f":"IF(ISNUMBER(Design!I17),Design!I17,\"\")","v":""},{"$f":"IF(ISNUMBER(Design!J17),Design!J17,\"\")","v":""},{"$f":"(H19-0.5)*I19/((H19-0.5)+(H19-0.5)+I19)","v":{"$error":"#VALUE!"}},{"$f":"(1.486/$L$4)*((H19-0.5)/12)*(I19/12)*((J19/12)^(2/3))*Design!E17^(1/2)","v":{"$error":"#VALUE!"}},{"$f":"Design!I17","v":0},{"$f":"IF(Design!K17>0,((IF(F19=10,L19,VLOOKUP(F19,$E$6:$K$14,7)))-0.5),0)","v":0},1,{"$f":"IF(S19=1,VLOOKUP(F19,$E$5:$K$14,2),H19&\" in. x \"&I19&\" in. Rectangular\")","v":0},null,{"$f":"VLOOKUP(G19,$E$35:$G$49,2)","v":0},null,{"$f":"IF(F19=10,0,1)","v":1},{"$f":"IF(F19>1,1,0)","v":0},{"$f":"IF(T19=1,4,\"\")","v":""},{"$f":"U19&\" of \"&$T$20","v":" of 0"},{"$f":"_xlfn.XLOOKUP(F19, $E6:$E14, $G6:$G14)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(F19, E6:E14, H6:H14)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.XLOOKUP(F19, $E6:$E14, $I6:$I14)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(F19, $E6:$E14, $K6:$K14)","v":{"$error":"#N/A"}},null,null,0.71720243894199998,0.62936183180899996]
[18,"CHEROKEE",0.72,0.63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S16:S19)","v":4},{"$f":"SUM(T16:T19)","v":0},null,null,null,null,null,null,null,null,null,0.72307282045900001,0.63466690565600004]
[19,"CHICKASAW",0.68,0.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,0.68444683334599998,0.59841712384199996]
[20,"CLARKE",0.74,0.65,null,null,{"$f":"IF(Design!C29=5,IF((OR(Reference!G16=4,Reference!G16=7,Reference!G16=10,Reference!G16=11,Reference!G16=11,Reference!G16=12,Reference!G16=15,Reference!G16=16)),\"True\",\"False\"),\"\")","v":""},null,"riser/rock link","b1","b2","b3","b4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74018400818899999,0.64839157657799995]
[21,"CLAY",0.73,0.64,null,null,null,null,1,{"$f":"IF($J$39=2,\"PVC\",\"\")","v":"PVC"},{"$f":"IF($J$40=2,\"PVC\",\"\")","v":"PVC"},{"$f":"IF($J$41=2,\"PVC\",\"\")","v":"PVC"},{"$f":"IF($J$42=2,\"PVC\",\"\")","v":"PVC"},null,null,null,null,null,null,null,"DS","Diam",null,null,null,null,null,null,null,0.728708999114,0.63768865599900004]
[22,"CLAYTON",0.68,0.59,null,null,null,null,2,{"$f":"IF($J$39=2,\"CMP\",\"\")","v":"CMP"},{"$f":"IF($J$40=2,\"CMP\",\"\")","v":"CMP"},{"$f":"IF($J$41=2,\"CMP\",\"\")","v":"CMP"},{"$f":"IF($J$42=2,\"CMP\",\"\")","v":"CMP"},null,null,null,"Fascia Board",null,null,null,1,null,null,null,null,null,null,null,null,0.67637352921500005,0.59018529377399997]
[23,"CLINTON",0.73,0.64,null,null,null,null,3,{"$f":"IF($J$39=2,\"Not Applicable\",\"\")","v":"Not Applicable"},{"$f":"IF($J$40=2,\"Not Applicable\",\"\")","v":"Not Applicable"},{"$f":"IF($J$41=2,\"Not Applicable\",\"\")","v":"Not Applicable"},{"$f":"IF($J$42=2,\"Not Applicable\",\"\")","v":"Not Applicable"},null,null,null,"Size",null,"Actual",null,2,3,"DS Diam Size",null,null,null,null,null,null,0.72841294372900001,0.63560467140400001]
[24,"CRAWFORD",0.72,0.63,null,null,null,null,null,null,null,null,null,null,null,null,"2x",4,3.5,null,3,4,"b1",{"$f":"VLOOKUP(G16,$U$24:$V$39,2)","v":0},null,null,null,null,null,0.72254107570699999,0.63276174601500002]
[25,"DALLAS",0.72,0.63,null,null,null,null,"End cap link",null,"b1",{"$f":"VLOOKUP(M27,$I$28:$J$30,2)","v":0},1,null,null,null,"2x",6,5.5,null,4,5,"b2",{"$f":"VLOOKUP(G17,$U$24:$V$39,2)","v":0},null,null,null,null,null,0.721306832648,0.63402348286099997]
[26,"DAVIS",0.73,0.64,null,null,null,null,1,null,"b2",{"$f":"VLOOKUP(M28,$I$28:$J$30,2)","v":0},1,null,null,null,"2x",8,7.25,null,5,3,"b3",{"$f":"VLOOKUP(G18,$U$24:$V$39,2)","v":0},null,null,null,null,null,0.72600355201699995,0.63680191993000002]
[27,"DECATUR",0.73,0.64,null,null,null,null,2,1,"b3",{"$f":"VLOOKUP(M29,$I$28:$J$30,2)","v":0},1,null,null,null,"2x",10,9.25,null,6,4,"b4",{"$f":"VLOOKUP(G19,$U$24:$V$39,2)","v":0},null,null,null,null,null,0.72922956053200005,0.63797379355399997]
[28,"DELAWARE",0.75,0.66,null,null,null,null,3,2,"b4",{"$f":"VLOOKUP(M30,$I$28:$J$30,2)","v":0},1,null,null,null,"2x",12,11.25,null,7,5,null,null,null,null,null,null,null,0.74804368620499995,0.655385396924]
[29,"DES MOINES",0.75,0.66,null,null,null,null,null,null,null,null,null,null,null,null,"Lookup Table",null,null,null,8,3,null,null,null,null,null,null,null,0.749195806894,0.65595434891399995]
[30,"DICKINSON",0.72,0.63,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rounded #","Width Dim",null,9,4,null,null,null,null,null,null,null,0.71947073004399997,0.63170729853600005]
[31,"DUBUQUE",0.72,0.63,"Downspouts",null,null,null,"Outlets",null,null,null,null,null,null,null,null,1,4,null,10,5,null,null,null,null,null,null,null,0.71989010914600005,0.62850829601699998]
[32,"EMMET",0.68,0.59,null,null,"Area, in2","AT - PVC Diam",null,null,null,null,null,null,null,null,null,2,4,null,11,6,null,null,null,null,null,null,null,0.67556970815700002,0.59063798059200001]
[33,"FAYETTE",0.73,0.64,1,null,null,null,null,1,"Above Ground",null,null,null,null,null,null,3,4,null,12,8,null,null,null,null,null,null,null,0.73408612202500001,0.64306040764100003]
[34,"FLOYD",0.74,0.65,2,"2\" x 3\" Corrugated",7.73,6,null,2,"Underground",null,null,null,null,null,null,4,6,null,13,3,null,null,null,null,null,null,null,0.74490412493699998,0.65090133078199996]
[35,"FRANKLIN",0.71,0.62,3,"3\" x 4\" Corrugated",11.7,6,null,null,null,null,null,null,null,null,null,5,6,null,14,4,null,null,null,null,null,null,null,0.70610968662499995,0.62291453129200003]
[36,"FREMONT",0.75,0.65,4,"4\" x 5\" Corrugated",18.75,8,null,"Outlet Link",null,null,"Rock/riser link","animal traffic","animal guard",null,null,6,8,null,15,5,null,null,null,null,null,null,null,0.75243400960100004,0.65310723485800004]
[37,"GREENE",0.76,0.65,5,"2\" x 3\" Plain",6,6,"b1",2,null,"b1",1,false,false,null,null,7,8,null,16,6,null,null,null,null,null,null,null,0.75809416107200001,0.65382258474499999]
[38,"GRUNDY",0.72,0.63,6,"3\" x 4\" Plain",12,6,"b2",2,null,"b2",1,false,false,null,null,8,10,null,null,null,null,null,null,null,null,null,null,0.72260368964699995,0.63218870929299997]
[39,"GUTHRIE",0.77,0.67,7,"4\" x 5\" Plain",20,8,"b3",2,null,"b3",1,false,false,null,null,9,10,null,null,null,null,null,null,null,null,null,null,0.766011265163,0.67120450781600005]
[40,"HAMILTON",0.72,0.63,8,"3\" Plain Round",7.07,6,"b4",2,null,"b4",1,false,false,null,null,10,12,null,null,null,null,null,null,null,null,null,null,0.718678224629,0.63167459882699994]
[41,"HANCOCK",0.74,0.65,9,"4\" Plain Round",12.57,6,null,null,null,null,null,null,null,null,null,11,12,null,null,null,null,null,null,null,null,null,null,0.74157562141300004,0.649165483742]
[42,"HARDIN",0.72,0.63,10,"5\" Plain Round",19.63,6,null,null,null,null,null,null,null,null,null,12,{"$f":"\"\"","v":""},null,null,null,null,null,null,null,null,null,null,0.721044223609,0.62876938832899998]
[43,"HARRISON",0.73,0.63,11,"6\" Plain Round",28.27,8,"Rain Event",null,null,"link","Rainfall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73346304578800003,0.63330191982200001]
[44,"HENRY",0.74,0.66,12,"8\" Plain Round",50.27,12,1,"10-year, 5 minute","b1",2,{"$f":"IF(L46=1,INDEX(D3:D104,B107),INDEX(C3:C104,B107))","v":0.74},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74400679677100001,0.65796374554399994]
[45,"HOWARD",0.68,0.59,13,"3\" Corrug. Round",5.94,6,2,"25-year, 5 minute","b2",2,{"$f":"IF(L47=1,INDEX(D3:D104,B107),INDEX(C3:C104,B107))","v":0.74},null,"Density","Rock Type",null,"Density","cu yds","sq yds","Tons",null,null,null,null,null,null,null,null,0.67504917126700004,0.58944018859400005]
[46,"HUMBOLT",0.7,0.61,14,"4\" Corrug. Round",11.04,6,null,null,"b3",2,{"$f":"IF(L48=1,INDEX(D3:D104,B107),INDEX(C3:C104,B107))","v":0.74},null,1.7,"CA1","b1",{"$f":"IF(M39=1,$O$48,IF(M39=2,$O$49,IF(M39=3,$O$50,\"\")))","v":1.7},{"$f":"(Design!C27*Design!$C$28*Design!$C$29*Design!$C$30)/27","v":0},{"$f":"ROUND((Design!C27*(Design!$C$28+1)*(Design!$C$29+1)*(Design!$C$30*2))/9,1)","v":0},{"$f":"S48*R48","v":0},null,null,null,null,null,null,null,null,0.70084337857300005,0.61327904134099998]
[47,"IDA",0.66,0.57999999999999996,15,"5\" Corrug. Round",17.72,6,null,null,"b4",2,{"$f":"IF(L49=1,INDEX(D3:D104,B107),INDEX(C3:C104,B107))","v":0.74},null,1.7,"CA1","b2",{"$f":"IF(M40=1,$O$48,IF(M40=2,$O$49,IF(M40=3,$O$50,\"\")))","v":1.7},{"$f":"(Design!G27*Design!$G$28*Design!$G$29*Design!$G$30)/27","v":0},{"$f":"ROUND((Design!G27*(Design!$G$28+1)*(Design!$G$29+1)*(Design!$G$30*2)/9),1)","v":0},{"$f":"S49*R49","v":0},null,null,null,null,null,null,null,null,0.662703732356,0.579056762286]
[48,"IOWA",0.76,0.66,16,"6\" Corrug. Round",25.97,8,null,null,null,null,null,null,1.7,"CA3","b3",{"$f":"IF(M41=1,$O$48,IF(M41=2,$O$49,IF(M41=3,$O$50,\"\")))","v":1.7},{"$f":"(Design!K27*Design!$K$28*Design!$K$29*Design!$K$30)/27","v":0},{"$f":"ROUND((Design!K27*(Design!$K$28+1)*(1+Design!$K$29)*(2*Design!$K$30))/9,1)","v":0},{"$f":"S50*R50","v":0},null,null,null,null,null,null,null,null,0.75563823193099999,0.65672214240000004]
[49,"JACKSON",0.69,0.6,null,null,null,null,null,null,null,null,null,null,null,null,"b4",{"$f":"IF(M42=1,$O$48,IF(M42=2,$O$49,IF(M42=3,$O$50,\"\")))","v":1.7},{"$f":"(Design!O27*Design!$O$28*Design!$O$29*Design!$O$30)/27","v":0},{"$f":"ROUND((Design!O27*(1+Design!$O$28)*(1+Design!$O$29)*(2*Design!$O$30))/9,1)","v":0},{"$f":"S51*R51","v":0},null,null,null,null,null,null,null,null,0.69083176716700001,0.60245924833099995]
[50,"JASPER",0.7,0.61,"Underground Outlet Style",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.69828671141499998,0.611082043277]
[51,"JEFFERSON",0.72,0.63,1,"Conduit Material",null,"b1",{"$f":"IF(J39=2,VLOOKUP(L53,$E$53:$F$55,2),\"\")","v":"Conduit Material"},null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.719910438938,0.63108471694099999]
[52,"JOHNSON",0.72,0.63,2,"Non-Perf. Corrugated Plastic Tubing",null,"b2",{"$f":"IF(J40=2,VLOOKUP(L54,$E$53:$F$55,2),\"\")","v":"Conduit Material"},null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.71858171836600004,0.62595141039299995]
[53,"JONES",0.72,0.63,3,"Perforated Corrugated Plastic Tubing",null,"b3",{"$f":"IF(J41=2,VLOOKUP(L55,$E$53:$F$55,2),\"\")","v":"Conduit Material"},null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.71668196046599997,0.62757963124000005]
[54,"KEOKUK",0.74,0.65,null,null,null,"b4",{"$f":"IF(J42=2,VLOOKUP(L56,$E$53:$F$55,2),\"\")","v":"Conduit Material"},null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73797317317199995,0.64735782072699999]
[55,"KOSSUTH",0.74,0.64,null,"b1","B2","b3","b4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73539642752300005,0.64401828148100004]
[56,"LEE",0.73,0.63,null,"Conduit Material","Conduit Material","Conduit Material","Conduit Material",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72503074756899999,0.63431046962199999]
[57,"LINN",0.73,0.64,null,"Non-Perforated Corrugated Plastic Tubing","Non-Perforated Corrugated Plastic Tubing","Non-Perforated Corrugated Plastic Tubing","Non-Perforated Corrugated Plastic Tubing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72796407518600004,0.63554533040000005]
[58,"LOUISA",0.74,0.64,null,"Perforated Corrugated Plastic Tubing","Perforated Corrugated Plastic Tubing","Perforated Corrugated Plastic Tubing","Perforated Corrugated Plastic Tubing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73570976456199999,0.64468128399900004]
[59,"LUCAS",0.74,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74009302316600001,0.64725456029499995]
[60,"LYON",0.74,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73973495019799995,0.64900988648299995]
[61,"MADISON",0.73,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72719259885999998,0.64526115051400001]
[62,"MAHASKA",0.75,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74631958657099995,0.65250128551099995]
[63,"MARION",0.7,0.61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.69588444469800004,0.609367058116]
[64,"MARSHALL",0.74,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73763134279999998,0.64622665588999995]
[65,"MILLS",0.73,0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73378739293399997,0.64408003166000005]
[66,"MITCHELL",{"$f":"ROUND(AD68,2)","v":0.75},0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74613965411000005,0.64348396610500003]
[{"$f":"A68+1","v":67},"MONONA",0.74,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74437924363600005,0.64961749039000005]
[68,"MONROE",0.73,0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73066318547700004,0.63928678888099999]
[69,"MONTGOMERY",0.73,0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72853791264400003,0.63819423546499998]
[70,"MUSCATINE",0.73,0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72864856684099999,0.63813352952199998]
[71,"O'BRIEN",0.71,0.62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.71313783264300001,0.62256699667100002]
[72,"OSCEOLA",0.75,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74865811251400005,0.65485115878199995]
[73,"PAGE",0.76,0.66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75619129183199996,0.66147263047299998]
[74,"PALO ALTO",0.74,0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73567171576400003,0.64386354959400005]
[75,"PLYMOUTH",0.73,0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72805963709800003,0.63664488072500003]
[76,"POCAHONTAS",0.73,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73181114836399996,0.64686132170999999]
[77,"POLK",0.74,0.66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73616926946399996,0.65562499741400004]
[78,"POTTAWATTAMIE",0.73,0.63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72504178857599999,0.63344812607900003]
[79,"POWESHIEK",0.76,0.66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.759166520776,0.663402461236]
[80,"RINGGOLD",0.72,0.63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72158339672500005,0.63333854618600005]
[81,"SAC",0.75,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75324793361099995,0.64713057824700004]
[82,"SCOTT",0.74,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73772068475899999,0.64848276121899995]
[83,"SHELBY",0.73,0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72863907680399997,0.63870833593200005]
[84,"SIOUX",0.74,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74133676341599997,0.64885020310599995]
[85,"STORY",0.72,0.63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72371124949499999,0.63333536142500002]
[86,"TAMA",0.73,0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72563936179999999,0.63597960607000004]
[87,"TAYLOR",0.74,0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73543491221699997,0.64148396889000003]
[88,"UNION",0.75,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75256207061199998,0.65384999719199999]
[89,"VAN BUREN",0.71,0.62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.70996977478300005,0.62011169280300005]
[90,"WAPELLO",0.75,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74502389065800001,0.65360307544200003]
[91,"WARREN",0.76,0.67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.76147051591199999,0.67087013871800005]
[92,"WASHINGTON",0.74,0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.735918402789,0.64259425917599999]
[93,"WAYNE",0.72,0.63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72140387802499994,0.63168942724900001]
[94,"WEBSTER",0.75,0.66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.754910554279,0.65563944608199998]
[95,"WINNEBAGO",0.74,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74166926906099995,0.64810165469500003]
[96,"WINNESHIEK",0.73,0.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72645595525600004,0.63628520057500004]
[97,"WOODBURY",0.72,0.63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72090079328300005,0.63120897608899995]
[98,"WORTH",0.76,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.755622710935,0.65130362791700003]
[99,"WRIGHT",0.68,0.59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.67647065533100004,0.59110517133999996]
[100,null,0.75,0.66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.749970017637,0.65921046224400004]
[101,null,0.7,0.62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.70139337873899998,0.61595697583300002]
[102,null,0.74,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73992045427200004,0.64817287365599996]
[]
[]
[null,1]
[]
[null,{"$f":"VLOOKUP($B$107,A3:C104,2)","v":"ADAIR"}]

{"sheet":"Labels","index":8,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["IA-1572:","Design 1 ","Design 2","Design 3","Design 4","IA-1571:","Design 1 ","Design 2","Design 3","Design 4"]
["Item","Quantity","Quantity","Quantity","Quantity",null,"Quantity","Quantity","Quantity","Quantity"]
["Gutter Slope",{"$f":"IF(Reference!$J$39=1,\"\",IF(ISBLANK(Design!E14),\"\",(Design!E14*12)))","v":""},{"$f":"IF(Reference!$J$40=1,\"\",IF(ISBLANK(Design!E15),\"\",(Design!E15*12)))","v":""},{"$f":"IF(Reference!$J$41=1,\"\",IF(ISBLANK(Design!E16),\"\",(Design!E16*12)))","v":""},{"$f":"IF(Reference!$J$42=1,\"\",IF(ISBLANK(Design!E17),\"\",(Design!E17*12)))","v":""},null,{"$f":"IF(Reference!$J$39=2,\"\",IF(ISBLANK(Design!E14),\"\",(Design!E14*12)))","v":""},{"$f":"IF(Reference!$J$40=2,\"\",IF(ISBLANK(Design!E15),\"\",(Design!E15*12)))","v":""},{"$f":"IF(Reference!$J$41=2,\"\",IF(ISBLANK(Design!E16),\"\",(Design!E16*12)))","v":""},{"$f":"IF(Reference!$J$42=2,\"\",IF(ISBLANK(Design!E17),\"\",(Design!E17*12)))","v":""}]
["Elbow Elevation",{"$f":"IF(Reference!$J$39=1,\"\",IF(ISBLANK(Design!$C$27),\"\",Design!$C$27))","v":""},{"$f":"IF(Reference!$J$40=1,\"\",IF(ISBLANK(Design!$G$27),\"\",Design!$G$27))","v":""},{"$f":"IF(Reference!$J$41=1,\"\",IF(ISBLANK(Design!$K$27),\"\",Design!$K$27))","v":""},{"$f":"IF(Reference!$J$42=1,\"\",IF(ISBLANK(Design!$O$27),\"\",Design!$O$27))","v":""}]
["Outlet Elevation",{"$f":"IF(Reference!$J$39=1,\"\",IF(ISBLANK(Design!C28),\"\",Design!C28))","v":""},{"$f":"IF(Reference!$J$40=1,\"\",IF(ISBLANK(Design!G28),\"\",Design!G28))","v":""},{"$f":"IF(Reference!$J$41=1,\"\",IF(ISBLANK(Design!K28),\"\",Design!K28))","v":""},{"$f":"IF(Reference!$J$42=1,\"\",IF(ISBLANK(Design!O28),\"\",Design!O28))","v":""}]
["Diameter Riser Unit",{"$f":"IF(Reference!$J$39=1,\"\",IF(ISBLANK(Design!C29),\"\",Design!C29))","v":""},{"$f":"IF(Reference!$J$40=1,\"\",IF(ISBLANK(Design!G29),\"\",Design!G29))","v":""},{"$f":"IF(Reference!$J$41=1,\"\",IF(ISBLANK(Design!K29),\"\",Design!K29))","v":""},{"$f":"IF(Reference!$J$42=1,\"\",IF(ISBLANK(Design!O29),\"\",Design!O29))","v":""}]
["Height including elbow",{"$f":"IF(Reference!$J$39=1,\"\",IF(ISBLANK(Design!C30),\"\",Design!C30))","v":""},{"$f":"IF(Reference!$J$40=1,\"\",IF(ISBLANK(Design!G30),\"\",Design!G30))","v":""},{"$f":"IF(Reference!$J$41=1,\"\",IF(ISBLANK(Design!K30),\"\",Design!K30))","v":""},{"$f":"IF(Reference!$J$42=1,\"\",IF(ISBLANK(Design!O30),\"\",Design!O30))","v":""}]
["Height above ground",{"$f":"IF(Reference!$J$39=1,\"\",IF(ISBLANK(Design!C31),\"\",Design!C31))","v":""},{"$f":"IF(Reference!$J$40=1,\"\",IF(ISBLANK(Design!G31),\"\",Design!G31))","v":""},{"$f":"IF(Reference!$J$41=1,\"\",IF(ISBLANK(Design!K31),\"\",Design!K31))","v":""},{"$f":"IF(Reference!$J$42=1,\"\",IF(ISBLANK(Design!O31),\"\",Design!O31))","v":""}]
["Solid Riser Outlet Pipe",{"$f":"IF(Reference!$J$39=1,\"\",IF(ISBLANK(Design!C32),\"\",Design!C32))","v":""},{"$f":"IF(Reference!$J$40=1,\"\",IF(ISBLANK(Design!G32),\"\",Design!G32))","v":""},{"$f":"IF(Reference!$J$41=1,\"\",IF(ISBLANK(Design!K32),\"\",Design!K32))","v":""},{"$f":"IF(Reference!$J$42=1,\"\",IF(ISBLANK(Design!O32),\"\",Design!O32))","v":""}]
["Outlet Conduit Diameter",{"$f":"IF(Reference!$J$39=1,\"\",IF(ISBLANK(Design!C33),\"\",Design!C33))","v":""},{"$f":"IF(Reference!$J$40=1,\"\",IF(ISBLANK(Design!G33),\"\",Design!G33))","v":""},{"$f":"IF(Reference!$J$41=1,\"\",IF(ISBLANK(Design!K33),\"\",Design!K33))","v":""},{"$f":"IF(Reference!$J$42=1,\"\",IF(ISBLANK(Design!O33),\"\",Design!O33))","v":""}]
["Conduit Length",{"$f":"IF(Reference!$J$39=1,\"\",IF(ISBLANK(Design!C34),\"\",Design!C34))","v":""},{"$f":"IF(Reference!$J$40=1,\"\",IF(ISBLANK(Design!G34),\"\",Design!G34))","v":""},{"$f":"IF(Reference!$J$41=1,\"\",IF(ISBLANK(Design!K34),\"\",Design!K34))","v":""},{"$f":"IF(Reference!$J$42=1,\"\",IF(ISBLANK(Design!O34),\"\",Design!O34))","v":""}]
["Solid Outlet Pipe",{"$f":"IF(Reference!$J$39=1,\"\",IF(ISBLANK(Design!C35),\"\",Design!C35))","v":""},{"$f":"IF(Reference!$J$40=1,\"\",IF(ISBLANK(Design!G35),\"\",Design!G35))","v":""},{"$f":"IF(Reference!$J$41=1,\"\",IF(ISBLANK(Design!K35),\"\",Design!K35))","v":""},{"$f":"IF(Reference!$J$42=1,\"\",IF(ISBLANK(Design!O35),\"\",Design!O35))","v":""}]
["Splash Pads",null,null,null,null,null,{"$f":"IF(Reference!$J$39=1,IF(ISBLANK(Design!$B$14),\"\",Design!$C$27),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISBLANK(Design!$B$15),\"\",Design!$G$27),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISBLANK(Design!$B$16),\"\",Design!$K$27),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISBLANK(Design!$B$17),\"\",Design!$O$27),\"\")","v":""}]
["End Caps",{"$f":"IF(Reference!$J$39=2,IF(Reference!$L27=0,\"\",Reference!$L27),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(Reference!$L28=0,\"\",Reference!$L28),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(Reference!$L29=0,\"\",Reference!$L29),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(Reference!$L30=0,\"\",Reference!$L30),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(Reference!$L27=0,\"\",Reference!$L27),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(Reference!$L28=0,\"\",Reference!$L28),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(Reference!$L29=0,\"\",Reference!$L29),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(Reference!$L30=0,\"\",Reference!$L30),\"\")","v":""}]
["Gutter hangers/straps",{"$f":"IF(Reference!$J$39=2,IF(ISNUMBER(Design!$B$14),Design!$Y$18,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(ISNUMBER(Design!$B$15),Design!$Y$21,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISNUMBER(Design!$B$16),Design!$Y$24,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(ISNUMBER(Design!$B$17),Design!$Y$27,\"\"),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(ISNUMBER(Design!$B$14),Design!$Y$18,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISNUMBER(Design!$B$15),Design!$Y$21,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISNUMBER(Design!$B$16),Design!$Y$24,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISNUMBER(Design!$B$17),Design!$Y$27,\"\"),\"\")","v":""}]
["Feet of Fascia Board",{"$f":"IF(Reference!$J$39=2,IF(ISBLANK(Design!$B$14),\"\",Design!$C$14),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(ISBLANK(Design!$B$15),\"\",Design!$C$15),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISBLANK(Design!$B$16),\"\",Design!$C$16),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISBLANK(Design!$B$17),\"\",Design!$C$17),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(ISBLANK(Design!$B$14),\"\",Design!$C$14),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISBLANK(Design!$B$15),\"\",Design!$C$15),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISBLANK(Design!$B$16),\"\",Design!$C$16),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISBLANK(Design!$B$17),\"\",Design!$C$17),\"\")","v":""}]
["Feet of Downspout (per downspout)",{"$f":"IF(Reference!$J$39=2,IF(ISBLANK(Design!$B$14),\"\",Design!$D$14),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(ISBLANK(Design!$B$15),\"\",Design!$D$15),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISBLANK(Design!$B$16),\"\",Design!$D$16),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(ISBLANK(Design!$B$17),\"\",Design!$D$17),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(ISBLANK(Design!$B$14),\"\",Design!$D$14),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISBLANK(Design!$B$15),\"\",Design!$D$15),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISBLANK(Design!$B$16),\"\",Design!$D$16),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISBLANK(Design!$B$17),\"\",Design!$D$17),\"\")","v":""}]
["Feet of Downspout PVC (per downspout)"]
["Number of Downspout Elbows",{"$f":"IF(Reference!$J$39=2,IF(ISBLANK(Design!$A$14),\"\",IF(Reference!$J$39=1,3,2)),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(ISBLANK(Design!$A$15),\"\",IF(Reference!$J$40=1,3,2)),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISBLANK(Design!$A$16),\"\",IF(Reference!$J$41=1,3,2)),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(ISBLANK(Design!$A$17),\"\",IF(Reference!$J$42=1,3,2)),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(ISBLANK(Design!$A$14),\"\",IF(Reference!$J$39=1,3,2)),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISBLANK(Design!$A$15),\"\",IF(Reference!$J$40=1,3,2)),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISBLANK(Design!$A$16),\"\",IF(Reference!$J$41=1,3,2)),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISBLANK(Design!$A$17),\"\",IF(Reference!$J$42=1,3,2)),\"\")","v":""}]
["Number of DS Support Brackets",{"$f":"IF(Reference!$J$39=2,IF(ISNUMBER(Design!$B$14),Design!$Z$18,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(ISNUMBER(Design!$B$15),Design!$Z$21,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISNUMBER(Design!$B$16),Design!$Z$24,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(ISNUMBER(Design!$B$17),Design!$Z$27,\"\"),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(ISNUMBER(Design!$B$14),Design!$Z$18,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISNUMBER(Design!$B$15),Design!$Z$21,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISNUMBER(Design!$B$16),Design!$Z$24,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISNUMBER(Design!$B$17),Design!$Z$27,\"\"),\"\")","v":""}]
["Feet of riser unit",{"$f":"IF(ISBLANK(Design!$A$14),\"\",IF(Reference!$J$39=1,\"\",IF(ISNUMBER(B7),B7,\"\")))","v":""},{"$f":"IF(ISBLANK(Design!$A$15),\"\",IF(Reference!$J$40=1,\"\",IF(ISNUMBER(C7),C7,\"\")))","v":""},{"$f":"IF(ISBLANK(Design!$A$16),\"\",IF(Reference!$J$41=1,\"\",IF(ISNUMBER(D7),D7,\"\")))","v":""},{"$f":"IF(ISBLANK(Design!$A$17),\"\",IF(Reference!$J$42=1,\"\",IF(ISNUMBER(E7),E7,\"\")))","v":""}]
["Slope",{"$f":"IF(ISBLANK(Design!$A$14),\"\",IF(Reference!$J$39=2,IF(AND(ISNUMBER(B4),ISNUMBER(B5),ISNUMBER(B9),ISNUMBER(B11),ISNUMBER(B12)),((B4-B5)/(B9+B11+B12))*100,\"\"),\"\"))","v":""},{"$f":"IF(ISBLANK(Design!$A$15),\"\",IF(Reference!$J$40=2,IF(AND(ISNUMBER(C4),ISNUMBER(C5),ISNUMBER(C9),ISNUMBER(C11),ISNUMBER(C12)),((C4-C5)/(C9+C11+C12))*100,\"\"),\"\"))","v":""},{"$f":"IF(ISBLANK(Design!$A$16),\"\",IF(Reference!$J$41=2,IF(AND(ISNUMBER(D4),ISNUMBER(D5),ISNUMBER(D9),ISNUMBER(D11),ISNUMBER(D12)),((D4-D5)/(D9+D11+D12))*100,\"\"),\"\"))","v":""},{"$f":"IF(ISBLANK(Design!$A$17),\"\",IF(Reference!$J$42=2,IF(AND(ISNUMBER(E4),ISNUMBER(E5),ISNUMBER(E9),ISNUMBER(E11),ISNUMBER(E12)),((E4-E5)/(E9+E11+E12))*100,\"\"),\"\"))","v":""}]
["number of animal guards",{"$f":"IF(Reference!$O$39=TRUE,1,\"\")","v":""},{"$f":"IF(Reference!$O$40=TRUE,1,\"\")","v":""},{"$f":"IF(Reference!$O$41=TRUE,1,\"\")","v":""},{"$f":"IF(Reference!$O$42=TRUE,1,\"\")","v":""}]
["PVC Diameter"]
["Gutter Style",{"$f":"IF(Reference!$J$39=2,IF(ISBLANK(Design!$B$14),\"\",Reference!$O$16),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(ISBLANK(Design!$B$15),\"\",Reference!$O$17),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISBLANK(Design!$B$16),\"\",Reference!$O$18),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(ISBLANK(Design!$B$17),\"\",Reference!$O$19),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(ISBLANK(Design!$B$14),\"\",Reference!$O$16),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISBLANK(Design!$B$15),\"\",Reference!$O$17),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISBLANK(Design!$B$16),\"\",Reference!$O$18),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISBLANK(Design!$B$17),\"\",Reference!$O$19),\"\")","v":""}]
["Downspout Style",{"$f":"IF(Reference!$J$39=2,IF(ISBLANK(Design!A14),\"\",Reference!$Q$16),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(ISBLANK(Design!$B$15),\"\",Reference!$Q$17),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISBLANK(Design!$B$16),\"\",Reference!$Q$18),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(ISBLANK(Design!$B$17),\"\",Reference!$Q$19),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(ISBLANK(Design!G14),\"\",Reference!$Q$16),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISBLANK(Design!$B$15),\"\",Reference!$Q$17),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISBLANK(Design!$B$16),\"\",Reference!$Q$18),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISBLANK(Design!$B$17),\"\",Reference!$Q$19),\"\")","v":""}]
["Vertical Drop",{"$f":"IF(Reference!$J$39=2,IF(ISBLANK(Design!$A$14),\"\",Design!$C$14*(1/16)),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(ISBLANK(Design!$A$15),\"\",Design!$C$15*(1/16)),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISBLANK(Design!$A$16),\"\",Design!$C$16*(1/16)),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(ISBLANK(Design!$A$17),\"\",Design!$C$17*(1/16)),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(ISBLANK(Design!$A$14),\"\",Design!$C$14*(1/16)),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISBLANK(Design!$A$15),\"\",Design!$C$15*(1/16)),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISBLANK(Design!$A$16),\"\",Design!$C$16*(1/16)),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISBLANK(Design!$A$17),\"\",Design!$C$17*(1/16)),\"\")","v":""}]
["Fascia Board",{"$f":"IF(Reference!$J$39=2,IF(ISBLANK(Design!$A$14),\"\",(VLOOKUP(ROUNDUP(B27,0),Reference!$R$33:$S$44,2))),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(ISBLANK(Design!$A$15),\"\",(VLOOKUP(ROUNDUP(C27,0),Reference!$R$33:$S$44,2))),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISBLANK(Design!$A$16),\"\",(VLOOKUP(ROUNDUP(D27,0),Reference!$R$33:$S$44,2))),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(ISBLANK(Design!$A$17),\"\",(VLOOKUP(ROUNDUP(E27,0),Reference!$R$33:$S$44,2))),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(ISBLANK(Design!$A$14),\"\",(VLOOKUP(ROUNDUP(G27,0),Reference!$R$33:$S$44,2))),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISBLANK(Design!$A$15),\"\",(VLOOKUP(ROUNDUP(H27,0),Reference!$R$33:$S$44,2))),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISBLANK(Design!$A$16),\"\",(VLOOKUP(ROUNDUP(I27,0),Reference!$R$33:$S$44,2))),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISBLANK(Design!$A$17),\"\",(VLOOKUP(ROUNDUP(J27,0),Reference!$R$33:$S$44,2))),\"\")","v":""}]
["Diam of PVC Riser",{"$f":"IF(Reference!$J$39=2,IF(Reference!$M$39=1,Labels!B6,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(Reference!$M$40=1,Labels!C6,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(Reference!$M$41=1,Labels!D6,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(Reference!$M$42=1,Labels!E6,\"\"),\"\")","v":""}]
["Diam of CMP Riser",{"$f":"IF(Reference!$J$39=2,IF(Reference!$M$39=2,Labels!B6,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(Reference!$M$40=2,Labels!C6,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(Reference!$M$41=2,Labels!D6,\"\"),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(Reference!$M$42=2,Labels!E6,\"\"),\"\")","v":""}]
["Gutter Length",{"$f":"IF(Reference!$J$39=2,IF(ISBLANK(Design!$B$14),\"\",Design!$C$14),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(ISBLANK(Design!$B$15),\"\",Design!$C$15),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISBLANK(Design!$B$16),\"\",Design!$C$16),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(ISBLANK(Design!$B$17),\"\",Design!$C$17),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(ISBLANK(Design!$B$14),\"\",Design!$C$14),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISBLANK(Design!$B$15),\"\",Design!$C$15),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISBLANK(Design!$B$16),\"\",Design!$C$16),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISBLANK(Design!$B$17),\"\",Design!$C$17),\"\")","v":""}]
["Number of downspouts",{"$f":"IF(Reference!$J$39=2,IF(ISBLANK(Design!$A$14),\"\",Reference!N16),\"\")","v":""},{"$f":"IF(Reference!$J$40=2,IF(ISBLANK(Design!$A$15),\"\",Reference!N17),\"\")","v":""},{"$f":"IF(Reference!$J$41=2,IF(ISBLANK(Design!$A$16),\"\",Reference!N18),\"\")","v":""},{"$f":"IF(Reference!$J$42=2,IF(ISBLANK(Design!$A$17),\"\",Reference!N19),\"\")","v":""},null,{"$f":"IF(Reference!$J$39=1,IF(ISBLANK(Design!$A$14),\"\",Reference!N16),\"\")","v":""},{"$f":"IF(Reference!$J$40=1,IF(ISBLANK(Design!$A$15),\"\",Reference!N17),\"\")","v":""},{"$f":"IF(Reference!$J$41=1,IF(ISBLANK(Design!$A$16),\"\",Reference!N18),\"\")","v":""},{"$f":"IF(Reference!$J$42=1,IF(ISBLANK(Design!$A$17),\"\",Reference!N19),\"\")","v":""}]
["Downspout Size",{"$f":"IF(Reference!$J$39=2,IF(Reference!$N$39=TRUE,Labels!B24,Reference!X26),\"\")","v":0},{"$f":"IF(Reference!$J$40=2,IF(Reference!$N$40=TRUE,Labels!C24,Reference!X27),\"\")","v":0},{"$f":"IF(Reference!$J$41=2,IF(Reference!$N$41=TRUE,Labels!D24,Reference!X28),\"\")","v":0},{"$f":"IF(Reference!$J$42=2,IF(Reference!$N$42=TRUE,Labels!E24,Reference!X29),\"\")","v":0}]
["Error condition for tile grade",{"$f":"IF(AND(Reference!$J39=1,Labels!B5>Labels!B4),1,0)","v":0},{"$f":"IF(AND(Reference!$J40=1,Labels!C5>Labels!C4),1,0)","v":0},{"$f":"IF(AND(Reference!$J41=1,Labels!D5>Labels!D4),1,0)","v":0},{"$f":"IF(AND(Reference!$J42=1,Labels!E5>Labels!E4),1,0)","v":0}]
["Underground Outlet Pipe Type",{"$f":"IF(ISBLANK(Design!C$27),\"\",IF(Reference!$J$39=2,IF(Reference!L53=2, \"Non-Perf CPT\", IF(Reference!L53=3, \"Perf CPT\", \"\"))))","v":""},{"$f":"IF(ISBLANK(Design!G$27),\"\",IF(Reference!$J$40=2,IF(Reference!L54=2, \"Non-Perf CPT\", IF(Reference!L54=3, \"Perf CPT\", \"\"))))","v":""},{"$f":"IF(ISBLANK(Design!K$27),\"\",IF(Reference!$J$41=2,IF(Reference!L55=2, \"Non-Perf CPT\", IF(Reference!L55=3, \"Perf CPT\", \"\"))))","v":""},{"$f":"IF(ISBLANK(Design!O$27),\"\",IF(Reference!$J$42=2,IF(Reference!L56=2, \"Non-Perf CPT\", IF(Reference!L56=3, \"Perf CPT\", \"\"))))","v":""}]
["# of PVC downspout (only with animal traffic)"]

{"sheet":"Notes","index":9,"n_rows":107,"n_cols":4,"rows_kept":107,"cut":false,"hidden":false,"merged":[[2,0,4,0],[9,0,12,0],[2,2,4,2],[9,2,12,2],[13,1,17,1],[2,1,4,1],[13,2,17,2],[26,0,35,0],[26,1,35,1],[26,2,35,2],[20,0,23,0],[20,1,23,1],[20,2,23,2],[24,0,25,0],[24,1,25,1],[24,2,25,2],[18,0,19,0],[5,2,8,2],[5,1,8,1],[13,0,17,0],[5,0,8,0],[9,1,12,1],[18,2,19,2],[18,1,19,1],[53,1,61,1],[53,0,61,0],[36,0,45,0],[36,2,45,2],[36,1,45,1],[46,1,52,1],[46,0,52,0]]}
["Date","Program Version Number","Modification Author","Notes"]
["2010-03-04",1.01,"S. Anderson/ S. Hobson","Program as received from R. Book on noted date"]
["2010-03-05",1.02,"C. Zurliene","changed downspout flow equation to take square root of head (per AWFM chpt 10, July 1996)"]
[null,null,null,"added cell for building length to calcualte gutter footage and hanger quantities"]
[null,null,null,"added change event to gutter drop-down to enable custom cells to clear when not in use"]
["2010-03-08",1.03,"C. Zurliene","revised the methodology to fill out standard sheets"]
[null,null,null,"included outlet design section"]
[null,null,null,"added dialog box to save upon exiting workbook"]
[null,null,null,"added cell for downspout height to calculate additional quantities"]
["3/2010",1.04,"C. Zurliene","created outlet sections for all four buildings"]
[null,null,null,"changed printing design sheet methodology"]
[null,null,null,"added \"Instructions\" sheet"]
[null,null,null,"added drop downs to indicate the presence of animal traffic"]
["3/2010",1.05,"C. Zurliene","added \"Specifications\" tab"]
[null,null,null,"added \"O&M\" tab"]
[null,null,null,"created user form to select sheets to print"]
[null,null,null,"added pvc diameter label to standard drawings"]
[null,null,null,"added clear cells macro"]
["4/2010",1.06,"C. Zurliene","added text boxes to customize O&M sheets"]
[null,null,null,"changed printing methodology"]
["3/2011",1.07,"C. Zurliene","Added PDF printing functionality"]
[null,null,null,"Changed text box format for std dwgs"]
[null,null,null,"Improved error checking routine"]
[null,null,null,"Updated std dwgs"]
["3/2013",1.1000000000000001,"C. Zurliene","Changed standard drawing sizes to 11x17 to meet policy requirement"]
[null,null,null,"Updated O&M and Construction Specifications"]
["2013-07-01",1.1200000000000001,"M. Robert","Added disclaimer about calculations only using 25 yr-5 min storm to design and Instructions worksheet"]
[null,null,null,"Added Step 4 to Instructions worksheet explaining the Livestock Traffic pulldown menu"]
[null,null,null,"Added information to Step 8 on Instuctions worksheet about updating the Standard Drawing after any edits to the design"]
[null,null,null,"Updated solid outlet pipe design so that a warning occurs when a value less than 10 feet is inputted on the Design sheet"]
[null,null,null,"Explained Gutter Length and how to determine Roof Area for this spreadsheet in Step 3 on Instructions worksheet"]
[null,null,null,"Updated 25 yr-5min storm numbers using IL Bulletin 70 numbers"]
[null,null,null,"Updated area and wetted perimeter numbers for different gutter sizes."]
[null,null,null,"Included various Plain rectangular downspouts to the worksheet"]
[null,null,null,"Included 8K Style gutter to worksheet"]
[null,null,null,"Added explanation of downspout location to Step 6 on Instructions worksheet"]
["2014-01-21",2,"G. Baker","Added design summaries that populate only the selected outlet when the \"Fill Out IL-ENG-124\" Button is selected."]
[null,null,null,"Removed Print design function to print one design at a time."]
[null,null,null,"Moved all design drawings onto one worksheet."]
[null,null,null,"Updated Print button to allow the printing of all designs or just selected designs and drawings"]
[null,null,null,"Added color warning to Elevation Warning when filling out IL-ENG-124"]
[null,null,null,"Added data entry cells for providing design information about splash pad outlet."]
[null,null,null,"Added Livestock Traffic and Animal Guard checkboxes. Animal Guard option only available for Underground Outlet."]
[null,null,null,"Added drop down menu to select underground outlet conduit material. This is only available for underground outlet option."]
[null,null,null,"Added Cover Sheet and Plan Map worksheet."]
[null,null,null,"Moved all specifications into one worksheet."]
["2014-01-27","2.1","R.Book","Adjusted wording on Design sheet explanatory notes"]
[null,null,"G. Baker","Adjusted wording on Instructions page, and moved Instructions to the first tab."]
[null,null,null,"Added conditional formatting on gutter depth,width to show up only when \"custom\" gutter is selected"]
[null,null,null,"Corrected calculation of hydraulic radius for custom gutter"]
[null,null,null,"Removed \"Fill out design' routine so all sheets populate correctly when data is entered."]
[null,null,null,"Updated error checking to use data validation and conditional formatting,"]
[null,null,null,"Reformated how data is entered into design summary sheets"]
["2014-01-28","2.2","R.Book","Added formatting on gutter flow lookup to prevent error message when custom dimensions are blank"]
[null,null,"G. Baker","Added hyperlink from Design sheet to IL-ENG-124 Drawings"]
[null,null,null,"Added interpretive notes on entries for underground outlet dimensions"]
[null,null,null,"Changed conditional formatting on \"greyed out\" outlet dimensions on Design sheet to white, to save print ink"]
[null,null,null,"Changed standard dwg QTY for riser unit to the vertical height only (not including the horizontal riser outlet section)"]
[null,null,null,"Changed error flag methods on the outlet design portion to accommodate differing entries depending on design type"]
[null,null,null,"Corrected downspout bracket quantity calculations"]
[null,null,null,"Corrected dimension entries on IL-ENG-24 drawings"]
[null,null,null,"Added drop down box to add number of end caps for the gutters to the plans."]
["2014-01-30","2.3","R.Book","Grouped controls to help correct resizing issue"]
[null,null,null,"Adjusted Instructions to reflect updates"]
["2014-03-25",2.4,"G. Baker","Updated formatting on Design Sheet Summary so decimal places were appropriate and data were not cut off"]
[null,null,null,"Adjusted protection on cover sheet to allow location \"X\" to be moved"]
[null,null,null,"Added input box on cover sheet for total number of pages, and dropdown for job class"]
[null,null,null,"Added \"X\" on each IL-ENG-24 sheet for user to indicate which implementation will not be used in the design"]
[null,null,null,"Adjusted Instructions to reflect addition of the \"X\" features on IL-ENG-24."]
[null,null,null,"Added the county design storm information to the design home page and design summary sheet"]
[null,null,null,"Added a reference to AWMFH Chapter 10"]
[null,null,null,"Formatted data on drawings to be more visible"]
[null,null,null,"Changed the Fascia board nominal dimensions to 1\" x due to industry standard."]
[null,null,null,"Changed rock type to CA1, CA2, and CA3"]
[null,null,null,"Added information about gutters and downspouts to instructions page."]
["2018-01-02","3.0","R.Book","Updated rainfall data from Illinois Bulletin 70 to NOAA Atlas 14"]
[null,null,null,"Adjusted data validation to allow UGO size smaller than riser size"]
[null,null,null,"Removed \"rock type\" designation and splash pad dimensions for above ground outlets (designs to be done separately)"]
[null,null,null,"Set default storm event to the 25 year instead of the 10 year"]
[null,null,null,"Removed \"animal traffic\" checkbox"]
[null,null,null,"Formatted dropdowns for UGO option to show only when UGO is selected."]
[null,null,null,"Updated Print dialog box to identify supporting documentation vs construction plans"]
[null,null,null,"Updated standard drawings to latest version: 2 drawings instead of 1, to better document the selected outlet alternative"]
[null,null,null,"Removed IL-ENG-6 cover sheet tab: use separate IL-ENG-6 drawing or spreadsheet for this purpose."]
[null,null,null,"Changed Design Sheet title to reflect name of Conservation Practice Standard and clarify that the spreadsheet is for gutter design"]
[null,null,null,"Clarified that the lower section of the Design page is for specifying inputs on the standard drawings; UGO design is done separately"]
[null,null,null,"Updated instructions page accordingly"]
["2019-10-22",null,null,"Unprotected for Iowa NRCS"]
["2020-04-02",1,null,"Spreadsheet rework for Iowa."]
[null,null,null,"Design Tab modified to show spreadsheet for Iowa.  Iowa County information for rainfall from form NOAA 14 added in Notes."]
[null,null,null,"Design Summary tab.  Design Summary sheet updated to current NRCS / USDA title block for Iowa"]
[null,null,null,"The drawings IA-ENG-xx1 and xx2 were inserted in place of the original Illinois drawings.  Drawing were updated with current"]
[null,null,null,"NRCS / USDA Title Block for Iowa.  Drawigs were rearrange and reformated to match current NRCS CAD standard\\"]
[null,null,null,"Plan Map Tab - Title block was changed to current NRCS / USDA titel block"]
[null,null,null,"Specs-O&M - The existing CS from IL was retained with name changes from IL to IA. The IL O&M was replaced by the current "]
[null,null,null,"IA O&M."]
[]
["2020-04-17",1.1000000000000001,null,"Fixed issue with boxes showing or not showing up depending on selection of surface or underground outlet being selected"]
[null,null,null,"Hid tab containing the O&M and Construction Specification"]
[null,null,null,"Removed the check boxes from the print button for O&M and CS"]
[null,null,null,"Changed Names of drawings in Print Button Function."]
[null,null,null,"Changed Names of drawings in Instructions"]
[]
[]
[]
[]
["2023-04-10",2,null,"Added user input gutter slope."]