{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["RRE","Gage","References","clip"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RRE","index":0,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,11,15,14],[11,5,11,6],[9,0,9,1],[9,5,9,6],[6,1,6,8],[9,13,9,15],[42,1,46,9],[33,1,36,9],[37,1,40,9],[12,0,12,1],[10,5,10,6],[11,0,11,1],[10,0,10,1],[5,1,5,8],[1,8,1,9],[3,1,3,2],[4,6,4,7],[4,1,4,4],[3,7,3,9]]}
["        REGIONAL EQUATION  ANNUAL EXCEEDENCE-PROBABILITY DISCHARGE ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","13-5086",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B","00-4233",2]
["LOCATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","87-4132",3]
["County:",null,null,"Route:",null,null,"Project/Des. No.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",null,4]
["Stream:",null,null,null,null,"By:",null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",null,5]
[null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum B"]
["BASIN PARAMETERS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum C"]
["Drainage Area:",null,{"$f":"MAX(Q12:Q14)","v":0},"sq.mi. (DRNAREA)",null,"Constant Chan Maint:",null,null,"sq.mi./mi. (CCM)",null,"Drainage Area (sq.mi.):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum D"]
["% Des Moines Lobe:",null,null,"% (DESMOIN)",null,"Avg Sat Hyd Conduct:",null,null,"um/s (KSATSSUR)",null,"Region-",1,2,3,4,5,"Total",null,null,null,null,null,null,null,null,null,"Sum E"]
["Basin Shape Factor:",null,null,"Ratio (BSHAPE)",null,"Main Chan Slope(MCS):",null,null,"ft./mi (CSL10_85)",null,"13-5086",null,null,null,null,null,{"$f":"SUM(L12:N12)","v":0},null,null,null,null,null,null,null,null,null,"Sum F"]
["Max 24 Hr 10 Yr Precip:",null,null,"in (I24H10Y)",null,null,null,null,null,null,"00-4233",null,null,null,null,null,{"$f":"SUM(L13:N13)","v":0},null,null,null,null,null,null,null,null,null,"QDes"]
[null,null,null,null,null,null,null,null,null,null,"87-4132",null,null,null,null,null,{"$f":"SUM(L14:P14)","v":0}]
["CALCULATIONS"]
[null,"Calculation Group:",null,null,null,null,null,null,null,null,null,"Regional Equation Basin Parameters Reqd. "]
[null,"USGS Report:","","","","","","","","",null,null,"87-4132","00-4233","13-5086"]
[null,"Region:",null,null,null,null,null,null,null,null,null,"DRNAREA","All","All","All"]
[null,"Region DA (sq. mi.)",null,null,null,null,null,null,null,null,null,"DESMOIN","-",2,2]
[null,"Region DA Fraction ",{"$f":"IF(C$19<>\"\",C$19/$C$10,\"\")","v":""},{"$f":"IF(D$19<>\"\",D$19/$C$10,\"\")","v":""},"","","","","","",null,"BSHAPE","-","-","2,3"]
[null,"Group Weight (Frac):",null,null,null,null,null,null,null,null,null,"I24H10Y","-","-",1]
["AEPD Results (cfs)",null,null,null,null,null,null,null,null,null,null,"CCM","-","-","1 (A)"]
[null,"2 yr. (50%) ",null,null,null,null,null,null,null,null,null,"KSATSSUR","-","-",3]
[null,"5 yr. (20%) ",null,null,null,null,null,null,null,null,null,"CSL10_85","-","2,3 (B)","-"]
[null,"10 yr. (10%) ",null,null,null,null,null,null,null,null,null,"(A) CCM=0 Invokes One Variable Equation (DRNAREA Only)"]
[null,"25 yr. (4%) ",null,null,null,null,null,null,null,null,null,"(B) For MCS values determined using GIS (StreamStats, ArcHydro, etc.)"]
[null,"50 yr. (2%) ",null,null,null,null,null,null,null,null,null," apply an adjustment (multiplier) as follows:"]
[null,"100 yr. (1%) ",null,null,null,null,null,null,null,null,null," Region 2 - 1.148, Region 3 - 1.177 "]
[null,"200 yr. (0.5%) ",null,null,null,null,null,null,null,null,null," See References, Note 3"]
[null,"500 yr. (0.2%) "]
[null,"Note ","","","","","","","",""]
[]
["Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Notes:"]

{"sheet":"Gage","index":1,"n_rows":59,"n_cols":64,"rows_kept":59,"cut":false,"hidden":false,"merged":[[50,2,50,3],[41,2,41,3],[44,2,44,3],[49,4,49,11],[47,4,47,11],[20,3,20,11],[21,3,21,11],[32,2,32,3],[26,3,26,11],[31,2,31,3],[20,0,20,2],[23,0,23,1],[1,9,1,11],[3,9,3,11],[4,8,4,9],[19,1,19,2],[14,3,14,11],[19,3,19,11],[13,3,13,11],[12,3,12,11],[13,0,13,2],[16,0,16,1],[8,0,8,1],[8,5,8,7],[8,8,8,11],[12,1,12,2],[54,1,57,11],[32,4,32,11],[52,4,52,11],[37,4,37,11],[40,4,40,11],[35,2,35,3],[34,4,34,11],[43,4,43,11],[46,4,46,11],[41,4,41,11],[44,4,44,11],[38,2,38,3],[35,4,35,11],[38,4,38,11],[50,4,50,11],[47,2,47,3]]}
[null,"GAGE WEIGHTED ANNUAL EXCEEDENCE-PROBABILITY DISCHARGE ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,25,26,27,28,29,30,31,null,33,34,35,36,37]
[]
["LOCATION"]
["County:",null,null,null,null,"Route:",null,null,"Project/Des. No.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area Wt",{"$f":"IF($B$13<>\"\",\"A  \"&$B$13,\"\")","v":""},"EMA",null,"A"]
["Stream:",null,null,null,null,null,null,"By:",null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg Wt",{"$f":"IF($B$20<>\"\",\"B  \"&$B$20,\"\")","v":""},"WIE",null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg (Alt)",null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D"]
["UNGAGED SITE 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,null,null,null,null,null,null,null,"E"]
["Drainage Area:",null,0,"sq.mi. (DRNAREA)",null,"Report 13-5086 Region:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DA",0,null,null,null,null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum A"]
["AEPD DATA SOURCES (cfs)",null,null,null,"2 yr.","5 yr.","10 yr.","25 yr.","50 yr.","100 yr.","200 yr.","500 yr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum B"]
[null,null,null,null,"(50%)","(20%)","(10%)","(4%)","(2%)","(1%)","(0.5%)","(0.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,"Sum C"]
["GageA:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GA1","",null,null,null,null,null,null,null,null,null,null,null,"Sum D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GA2",null,null,null,null,null,null,null,null,null,null,null,null,"Sum E"]
[null,"Gage Region:",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GA3",null,null,null,null,null,null,null,null,null,null,null,null,"Sum F"]
[null,"Gage DA (mi2):",null,"EMA/MGB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GA4",null,null,null,null,null,null,null,null,null,null,null,null,"QDes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mod"]
["DAu /DAg:",null,null,"RRE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GA5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mod"]
[null,"Gage Area Wt.:",null,"WIE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GA6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mod"]
[]
["GageB:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GB1",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GB2"]
[null,"Gage Region:",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GB3"]
[null,"Gage DA (mi2):",null,"EMA/MGB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GB4"]
["DAu/DAg:",null,null,"RRE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GB5"]
[null,"Gage Area Wt.:",null,"WIE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GB6"]
[]
[null,"Ungaged Site RRE:","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R1"]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R2"]
[]
["AEPD (cfs)",null,null,null,"2 yr.","5 yr.","10 yr.","25 yr.","50 yr.","100 yr.","200 yr.","500 yr."]
["GAGE WEIGHTED ESTIMATES",null,null,null,"(50%)","(20%)","(10%)","(4%)","(2%)","(1%)","(0.5%)","(0.2%)"]
["Group","Type","Gage"]
[null,"","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W1"]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W2"]
[null,null,null,null,""]
[null,"","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W1"]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W2"]
[null,null,null,null,""]
[null,"","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W1"]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W2"]
[null,null,null,null,""]
[null,"","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W1"]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W2"]
[null,null,null,null,""]
[null,"","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W1"]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W2"]
[null,null,null,null,""]
[null,"","",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W1"]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W2"]
[null,null,null,null,""]
[null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W1"]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W2"]
[null,null,null,null,""]
["Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"<<Btm Single Sheet"]

{"sheet":"References","index":2,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[[39,1,40,14],[41,1,42,14],[28,1,29,14],[1,1,2,14],[5,1,6,14],[3,1,4,14],[15,1,16,14],[17,1,18,14],[7,1,8,14],[30,1,32,14],[9,1,10,14],[20,1,22,14],[24,1,25,14]]}
["References"]
[null,"A) Rept. 13-5086 - \"Methods for Estimating Annual Exceedence-Probability Discharges for Streams in Iowa, based on data through Water Year 2010\", USGS Scientific Investigations report 2013-5086."]
[]
[null,"B) Rept. 00-4233 - \"Techniques For Estimating Flood-Frequency Discharges For Streams In Iowa\", USGS Water Resources Investigations Report 00-4233."]
[]
[null,"C) Rept. 87-4132 - \"Method For Estimating The Magnitude And Frequency Of Floods At Ungaged Sites On Unregulated Rural Streams In Iowa\", USGS Water Resources Investigation Report 87-4132."]
[]
[null,"D) USGS Bk. 4, Ch. 6 - \"The National Streamflow Statistics Program: A Computer Program for Estimating Streamflow Statistics for Ungaged Sites\", Chapter 6 of Book 4, Hydrologic Analysis and Interpretation, Section A, Statistical Analysis.  USGS Techniques and Methods 4-A6."]
[]
[null,"E) Rept. 03-4120 - \"Main-Channel Slopes of Selected Streams in Iowa for Estimation of Flood-Frequency Discharges\", USGS Water Resources Investigation Report 03-4120.  "]
[]
[]
[]
["Notes"]
[]
["Regional Reg. Equations:","1) Rept. 13-5086, Region 1, One variable equations per email transmittal, D. Eash, USGS, 7/25/13."]
[]
[null,"2) Sites draining more than one Region may be weighted using 'Region DA Fraction' determined per the procedure in Rept. 13-5086, Pg. 33.  AEPD results for a given Report/Reqion combination represent the AEPD for the entire basin using the specified Regional equation.  "]
[]
[]
[null,"3) MCS values determined using GIS (StreamStats, ArcHydro, etc.) are generally lower than the manual MCS determination methods used to develop the Rept. 00-4233 equations.  Therefore, for GIS MCS values to be used with the Rept. 00-4233 equations, apply the multiplier as shown (from Rept. 03-4120) or use the MCS value from Rept. 03-4120 for streams addressed in the report.  "]
[]
[]
[]
[null,"4) Region 1 RRE max. CCM increased to 3.87 (from 2.22) per email D. Eash 12/12/14."]
[]
[]
[]
["Gage-Weighted Estimates:","1)  Area-Weighted estimate (Area Wt) per Rept. 13-5086, Eq. (12).  Regression-Weighted (Reg Wt) estimate per Rept. 13-5086, Eq. (11).  "]
[]
[null,"2)  Alternate Regression-Weighted estimate (Reg (Alt)) per USGS Bk. 4, Ch. 6, Pg. 9.  Procedure used is similar to the Regression-Weighted estimate using Eq. (11) referenced above.  To adjust the gaged site discharge to the ungaged site an Area-Weighted estimate per Eq. (12) above is used in the second term in lieu of the ratio of  ungaged to gaged RRE estimates used in Eq. (11).  Use of Eq. (11) implies that the ungaged to gaged RRE estimates use identical methodologies. "]
[]
[]
[]
[]
[]
[]
[]
["Version History"]
[null,"1.0  9/16/13 - Initial.   1.01 12/16/14- Added notes regarding MCS, CCM usage."]
[]
[]
[]
[]
[]
[]
["Password:","AEPD"]

{"sheet":"clip","index":3,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,930]
[null,1970]
[null,2720]
[null,3910]
[null,4800]
[null,5760]
[null,6960]
[null,8090]