{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Summary","Capacity","Layout"," Zones","IDF Data","NOAA Data2","FHWA","Revision Comments","Counties","Updates"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
["You must be using as a minimum, EXCEL 2003, SP3."]
["Save an unedited copy of these spreadsheets in case problems occur with the calculations or spreadsheet construction."]
["The following instructions apply to the spreadsheet named \"Capacity\" and generates a solution for non-pressure system flow."]
[]
["The county name and storm return interval are selected from pull-down lists.  IDF intensities are user retrieved from the NOAA website."]
["The FHWA curve fitting procedure found in the FHWA Hydraulic Toolbox is used to generate  IDF equations for each design storm."]
["Blue shaded cells are user input values.  Other cell entries are populated immediately by fomula or later at run time."]
["Yellow cells are formulas that need to be verified by the user as explained later."]
["Entries in column 6 are the sum of the CA terms.   These values / formula need to be checked and verified by the user."]
[null,"Colors other than yellow in column 6 represent decision points in the system that represent the cummation of the CA terms at a junction. "]
["Entries in column 10 are the pipe travel times at the inlet or outlet end of a pipe.  These values / formula need to be checked and verified by the user."]
[null,"Colors other than yellow in column 10 represent decision points in the system that represent the cummation of the travel time at a pipe inlet or outlet."]
[null,"These cells must be created by the user."]
["The 10, 25 or 100 year design storm may be selected from the drop down in cell V3."]
[]
["A correct network can be used to solve multiple storms."]
["A line with inlet data and a following line with pipe data line a basicl segment that serves as a template to be copied for successive pipe.  If there is no inlet flow, simply delete the inlet flow data."]
[]
["Individual pipe roughnesses are entered for each pipe in this spreadsheet."]
[]
["The user must examine the time of concentration for all intersecting laterals to enter the design time to that point."]
["The most appropriate time of concentration is usually the lateral having the longest travel time to that junction."]
["Hydra uses a method to adjust the Tc when a single area produces a higher flow than what would be computed using the longest Tc."]
["In these cases, refer to the Hydra documentation (page 8)."]
[]
["Enter all user supplied data then press \"CTRL+ r\" to solve.  The macro computes pipe velocity, full pipe flow and % pipe load."]
["If undersized, resize the pipe as noted and press \"CTRL+r\" to rerun."]
[]
["The Drawing Toolbar allows the user to optionally graph the system as shown on the \"Layout\" spreadsheet."]
["All drawing elements have been \"grouped\" so you may move all at one time.  You will need to \"ungroup\", to edit these individual elements."]
["The user may instead choose to import a picture file graphic to show the system layout."]
[]
["To create an 8.5\" X 11\" report summary, select the spreadsheet, \"Summary\" and Press \"CTRL + q\" to create summary from Capacity sheet."]
[]
["Multiple runs (for different flows) may be saved by copying the results to a new spreadsheet."]
[]
["A comparison of the FHWA computed intensities to the NOAA webpage values is displayed on sheet \"FHWA\" with the computed IDF equation coefficients."]

{"sheet":"Summary","index":1,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,6,3,7],[3,8,3,9],[3,10,3,13],[2,11,2,12],[0,11,0,12],[1,11,1,12],[2,8,2,10],[0,0,0,10],[5,6,5,7],[2,0,3,0],[2,1,3,2],[5,1,7,1],[5,2,6,2],[5,3,7,3],[2,4,2,5],[3,4,3,5],[1,0,1,10],[6,11,7,11],[5,8,5,11],[2,6,2,7]]}
["STORM SEWER DESIGN",null,null,null,null,null,null,null,null,null,null,"pages:",null,1]
["PIPE CAPACITY COMPUTATIONS SUMMARY",null,null,null,null,null,null,null,null,null,null," Storm",null,{"$f":"Capacity!V3","v":10}]
["County:",{"$f":"Capacity!B3","v":"Menifee"},null," Route:",{"$f":"Capacity!E3","v":"US 460"},null,"Project:",null,{"$f":"Capacity!H3","v":"US 460 - System 2"},null,null,"Item No:",null,{"$f":"Capacity!Q3","v":"10-8802"}]
[null,null,null,"Lat:",{"$f":"Capacity!E4","v":" 37.9579°"},null,"Long:",null,{"$f":"Capacity!H4","v":"-83.6640°"},null,{"$f":"Capacity!J4","v":" Frenchburg, Kentucky"}]
[1,2,3,4,9,12,13,14,15,16,17,18,21,22]
["Inlet or","Location","Area","C","Inlet","Pipe","Pipe Invert",null,"Pipe",null,null,null,"Full","%"]
["M.H.",null,null,null,"Q","Q","Upst.","Dnst.","Len.","Slope","Size","n","Flow","Full"]
["ID",null,"Acres",null,"cfs","cfs","ft.","ft.","lf","ft / ft","in",null,"cfs"]
["CBI 1","14+25",1.1000000000000001,0.8,4.8662406257744726]
[null,null,null,null,null,4.8662406257744726,953.75,953.5,41.5,6.024096385542169E-3,15,1.2E-2,5.4320025107108769,0.89584653471333464]
["CBI 2","14+25",0.52,0.8,2.4031020148098521]
[null,null,null,null,null,7.1249939211980173,953.5,935.8,292,6.0616438356164537E-2,15,1.2E-2,17.230949653448771,0.41349978175880464]
["CBI 4","17+20",0.41,0.8,1.8947535116769985]
["CBI 3","17+20",2,0.8,9.2427000569609685]
[null,null,null,null,null,9.2427000569609685,936.05,935.8,41.5,6.024096385542169E-3,18,1.2E-2,8.8330350036403686,1.0463787422048894]
["CBI 4","17+20"]
["CBI 4","17+20"]
[null,null,null,null,null,17.459088366166306,935.8,928.5,138,5.2898550724637353E-2,15,1.2E-2,16.096664524574525,1.0846401339551923]
["MH 5","18+54"]
["JNC 6","18+54",5,0.8,15.066501403967347]
[null,null,null,null,null,15.066501403967345,928.7,928.5,16,1.2500000000002842E-2,21,1.2E-2,19.193040261927869,0.78499816591610549]
["MH 5","18+54"]
["DBI 7","19+40",0.3,0.8,1.3864050085441453]
[null,null,null,null,null,1.3864050085441451,931.5,931,21,2.3809523809523808E-2,15,1.2E-2,10.799144710266134,0.12838100106447953]
["CBI 8","19+22",0.2,0.8,0.92427000569609685]
[null,null,null,null,null,2.3046868994043548,931,930.5,41.5,1.2048192771084338E-2,15,1.2E-2,7.6820116214920251,0.30001085821798473]
["CBI 9","19+22",0.1,0.8]
["CBI 11","21+90",0.25,0.8,1.1553375071201211]
[null,null,null,null,null,1.1553375071201211,933,932.75,41.5,6.024096385542169E-3,15,1.2E-2,5.4320025107108769,0.2126909007943231]
["CBI 10","21+90",0.15,0.8,0.69320250427207264]
[null,null,null,null,null,1.8327142624326505,932.75,930.5,265,8.4905660377358489E-3,15,1.2E-2,6.448850783015506,0.28419238157277793]
["CBI 9","19+22"]
["CBI 9","19+22"]
[null,null,null,null,null,4.3931952049001168,930.5,928.5,72,2.7777777777777776E-2,15,1.2E-2,11.66440943863628,0.37663245859224037]
["MH 5","18+54"]
["MH 5","18+54"]
[null,null,null,null,null,30.200878105642325,928.5,928.24,20,1.2999999999999545E-2,24,1.2E-2,27.945097932920909,1.0807218560527561]
["Outfall","18+54"]
[null,null,null,null,null,30.175811050704727]
[]
[]
[]
[]
[]
[]
[]
["     ","     ",null,"     ",null,"     ",null,null,"     ",null,"     "]

{"sheet":"Capacity","index":2,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,20,1,21],[5,2,6,2],[5,4,6,4],[0,4,0,18],[1,4,1,18],[0,0,0,3],[1,0,1,3],[2,14,2,15],[2,19,2,20],[6,17,7,17],[2,1,3,2],[2,0,3,0],[5,5,6,5],[5,9,5,11],[5,6,5,8],[5,1,7,1],[2,21,3,21],[3,14,3,15],[3,9,3,13],[3,19,3,20],[5,12,5,13],[5,14,5,18],[3,17,3,18],[2,16,2,18],[2,5,2,6],[2,7,2,13],[3,7,3,8],[3,5,3,6],[5,3,7,3]]}
["Kentucky Transportation Cabinet",null,null,null,"STORM SEWER DESIGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 1"]
["Division of Highway Design 01-16",null,null,null,"PIPE CAPACITY COMPUTATIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v3"]
["County:","Menifee",null," Route:","US 460","Project:",null,"US 460 - System 2",null,null,null,null,null,null,"Item No:",null,"10-8802",null,null,"Design",null,10]
[null,null,null,"Lat:",{"$f":"'NOAA Data2'!Q5","v":" 37.9579°"},"Long:",null,{"$f":"'NOAA Data2'!Q6","v":"-83.6640°"},null,{"$f":"'NOAA Data2'!Q2","v":" Frenchburg, Kentucky"},null,null,null,null,"Locate Site:",null,"n","(Y or N)",null," Storm"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
["Inlet or","Location","Area","C","CA","å CA","Inlet Flow",null,null,"Pipe Flow",null,null,"Pipe Invert",null,"Pipe",null,null,null,null,"Travel","Full","%"]
["M.H.",null,null,null,null,null,"Time","I","Q","Time","I","Q","Upst.","Dnst.","Len.","Slope","Size","n","Vel.","Time","Flow","Full"]
["ID",null,"Acres",null,"Acres","Acres","min","in /hr","cfs","min","in /hr","cfs","ft.","ft.","lf","ft / ft","in",null,"fps","min","cfs"]
["CBI 1","14+25",1.1000000000000001,0.8,{"$f":"D9*C9","v":0.88000000000000012},{"$f":"E9","v":0.88000000000000012},9,{"$f":"IF($V$3=10,FHWA!$B$6/(G9+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(G9+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(G9+FHWA!$C$9)^FHWA!$D$9))","v":5.5298188929255367},{"$f":"D9*H9*C9","v":4.8662406257744726},{"$f":"G9","v":9},{"$f":"IF($V$3=10,FHWA!$B$6/(J9+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J9+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J9+FHWA!$C$9)^FHWA!$D$9))","v":5.5298188929255367}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F9*K9","v":4.8662406257744726},953.75,953.5,41.5,{"$f":"(M10-N10)/O10","v":6.024096385542169E-3},15,1.2E-2,5.0069868711373671,{"$f":"O10/S10/60","v":0.13814029963884256},5.4320025107108769,0.89584653471333464]
["CBI 2","14+25",0.52,0.8,{"$f":"D11*C11","v":0.41600000000000004},{"$f":"F9+E11","v":1.2960000000000003},8,{"$f":"IF($V$3=10,FHWA!$B$6/(G11+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(G11+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(G11+FHWA!$C$9)^FHWA!$D$9))","v":5.7766875356006047},{"$f":"D11*H11*C11","v":2.4031020148098521},{"$f":"MAX(J9+T10,G11)","v":9.1381402996388417},{"$f":"IF($V$3=10,FHWA!$B$6/(J11+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J11+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J11+FHWA!$C$9)^FHWA!$D$9))","v":5.4976804947515552}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F11*K11","v":7.1249939211980173},953.5,935.8,292,{"$f":"(M12-N12)/O12","v":6.0616438356164537E-2},15,1.2E-2,13.411334883434122,{"$f":"O12/S12/60","v":0.36287712662205196},17.230949653448771,0.41349978175880464]
["CBI 4","17+20",0.41,0.8,{"$f":"D13*C13","v":0.32800000000000001},{"$f":"F11+E13","v":1.6240000000000003},8,{"$f":"IF($V$3=10,FHWA!$B$6/(G13+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(G13+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(G13+FHWA!$C$9)^FHWA!$D$9))","v":5.7766875356006047},{"$f":"D13*H13*C13","v":1.8947535116769985},{"$f":"MAX(J11+T12,G13)","v":9.5010174262608942},{"$f":"IF($V$3=10,FHWA!$B$6/(J13+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J13+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J13+FHWA!$C$9)^FHWA!$D$9))","v":5.4153499895056774}]
["CBI 3","17+20",2,0.8,{"$f":"D14*C14","v":1.6},{"$f":"E14","v":1.6},8,{"$f":"IF($V$3=10,FHWA!$B$6/(G14+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(G14+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(G14+FHWA!$C$9)^FHWA!$D$9))","v":5.7766875356006047},{"$f":"D14*H14*C14","v":9.2427000569609685},{"$f":"G14","v":8},{"$f":"IF($V$3=10,FHWA!$B$6/(J14+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J14+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J14+FHWA!$C$9)^FHWA!$D$9))","v":5.7766875356006047}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F14*K14","v":9.2427000569609685},936.05,935.8,41.5,{"$f":"(M15-N15)/O15","v":6.024096385542169E-3},21,1.2E-2,5.9899525429184015,{"$f":"O15/S15/60","v":0.11547114300335934},13.324003061707312,0.6936879265304392]
["CBI 4","17+20",null,null,null,null,null,null,null,{"$f":"J14+T18","v":8.144811148247312}]
["CBI 4","17+20",null,null,null,{"$f":"F14+F13","v":3.2240000000000002},null,null,null,{"$f":"MAX(J16,J13)","v":9.5010174262608942},{"$f":"IF($V$3=10,FHWA!$B$6/(J17+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J17+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J17+FHWA!$C$9)^FHWA!$D$9))","v":5.4153499895056774}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F17*K17","v":17.459088366166306},935.8,928.5,138,{"$f":"(M18-N18)/O18","v":5.2898550724637353E-2},18,1.2E-2,15.882755076784557,{"$f":"O18/S18/60","v":0.14481114824731228},26.174951301488957,0.66701512316369238]
["MH 5","18+54",null,null,null,null,null,null,null,{"$f":"MAX(J17+T18,G19)","v":9.6458285745082062},{"$f":"IF($V$3=10,FHWA!$B$6/(J19+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J19+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J19+FHWA!$C$9)^FHWA!$D$9))","v":5.3833129294508897}]
["JNC 6","18+54",5,0.8,{"$f":"D20*C20","v":4},{"$f":"E20","v":4},21,{"$f":"IF($V$3=10,FHWA!$B$6/(G20+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(G20+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(G20+FHWA!$C$9)^FHWA!$D$9))","v":3.7666253509918364},{"$f":"D20*H20*C20","v":15.066501403967347},{"$f":"G20","v":21},{"$f":"IF($V$3=10,FHWA!$B$6/(J20+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J20+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J20+FHWA!$C$9)^FHWA!$D$9))","v":3.7666253509918364}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F20*K20","v":15.066501403967345},928.7,928.5,16,{"$f":"(M21-N21)/O21","v":1.2500000000002842E-2},21,1.2E-2,8.8496211870843613,{"$f":"O21/S21/60","v":3.0133116551458169E-2},19.193040261927869,0.78499816591610549]
["MH 5","18+54",null,null,null,null,null,null,null,{"$f":"J20+T21","v":21.030133116551458}]
["DBI 7","19+40",0.3,0.8,{"$f":"D23*C23","v":0.24},{"$f":"E23","v":0.24},8,{"$f":"IF($V$3=10,FHWA!$B$6/(G23+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(G23+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(G23+FHWA!$C$9)^FHWA!$D$9))","v":5.7766875356006047},{"$f":"D23*H23*C23","v":1.3864050085441453},{"$f":"G23","v":8},{"$f":"IF($V$3=10,FHWA!$B$6/(J23+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J23+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J23+FHWA!$C$9)^FHWA!$D$9))","v":5.7766875356006047}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F23*K23","v":1.3864050085441451},931.5,931,21,{"$f":"(M24-N24)/O24","v":2.3809523809523808E-2},15,1.2E-2,6.063762717455667,{"$f":"O24/S24/60","v":5.7719936664483919E-2},10.799144710266134,0.12838100106447953]
["CBI 8","19+22",0.2,0.8,{"$f":"D25*C25","v":0.16000000000000003},{"$f":"F23+E25","v":0.4},8,{"$f":"IF($V$3=10,FHWA!$B$6/(G25+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(G25+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(G25+FHWA!$C$9)^FHWA!$D$9))","v":5.7766875356006047},{"$f":"D25*H25*C25","v":0.92427000569609685},{"$f":"MAX(J23+T24,G25)","v":8.0577199366644834},{"$f":"IF($V$3=10,FHWA!$B$6/(J25+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J25+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J25+FHWA!$C$9)^FHWA!$D$9))","v":5.7617172485108865}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F25*K25","v":2.3046868994043548},931,930.5,41.5,{"$f":"(M26-N26)/O26","v":1.2048192771084338E-2},15,1.2E-2,5.4888077217317308,{"$f":"O26/S26/60","v":0.12601400918603217},7.6820116214920251,0.30001085821798473]
["CBI 9","19+22",0.1,0.8,{"$f":"D27*C27","v":8.0000000000000016E-2},{"$f":"F25+E27","v":0.48000000000000004},null,null,null,{"$f":"MAX(J25+T26,G27)","v":8.1837339458505163}]
["CBI 11","21+90",0.25,0.8,{"$f":"D28*C28","v":0.2},{"$f":"E28","v":0.2},8,{"$f":"IF($V$3=10,FHWA!$B$6/(G28+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(G28+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(G28+FHWA!$C$9)^FHWA!$D$9))","v":5.7766875356006047},{"$f":"D28*H28*C28","v":1.1553375071201211},{"$f":"G28","v":8},{"$f":"IF($V$3=10,FHWA!$B$6/(J28+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J28+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J28+FHWA!$C$9)^FHWA!$D$9))","v":5.7766875356006047}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F28*K28","v":1.1553375071201211},933,932.75,41.5,{"$f":"(M29-N29)/O29","v":6.024096385542169E-3},15,1.2E-2,3.6012862400261412,{"$f":"O29/S29/60","v":0.19206100836395776},5.4320025107108769,0.2126909007943231]
["CBI 10","21+90",0.15,0.8,{"$f":"D30*C30","v":0.12},{"$f":"F28+E30","v":0.32},8,{"$f":"IF($V$3=10,FHWA!$B$6/(G30+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(G30+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(G30+FHWA!$C$9)^FHWA!$D$9))","v":5.7766875356006047},{"$f":"D30*H30*C30","v":0.69320250427207264},{"$f":"MAX(J28+T29,G30)","v":8.1920610083639573},{"$f":"IF($V$3=10,FHWA!$B$6/(J30+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J30+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J30+FHWA!$C$9)^FHWA!$D$9))","v":5.7272320701020325}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F30*K30","v":1.8327142624326505},932.75,930.5,265,{"$f":"(M31-N31)/O31","v":8.4905660377358489E-3},15,1.2E-2,4.5397230475497903,{"$f":"O31/S31/60","v":0.97289341671414509},6.448850783015506,0.28419238157277793]
["CBI 9","19+22",null,null,null,{"$f":"F30+E32","v":0.32},null,null,null,{"$f":"MAX(J30+T31,G32)","v":9.1649544250781023},{"$f":"IF($V$3=10,FHWA!$B$6/(J32+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J32+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J32+FHWA!$C$9)^FHWA!$D$9))","v":5.491494006125146}]
["CBI 9","19+22",null,null,null,{"$f":"F32+F27","v":0.8},null,null,null,{"$f":"MAX(J32,J27)","v":9.1649544250781023},{"$f":"IF($V$3=10,FHWA!$B$6/(J33+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J33+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J33+FHWA!$C$9)^FHWA!$D$9))","v":5.491494006125146}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F33*K33","v":4.3931952049001168},930.5,928.5,72,{"$f":"(M34-N34)/O34","v":2.7777777777777776E-2},15,1.2E-2,8.8599565653548815,{"$f":"O34/S34/60","v":0.1354408445626431},11.66440943863628,0.37663245859224037]
["MH 5","18+54",null,null,null,{"$f":"F32+E35","v":0.32},null,null,null,{"$f":"J32+T34","v":9.3003952696407453}]
["MH 5","18+54",null,null,null,{"$f":"F17+F20+F33","v":8.0240000000000009},null,null,null,{"$f":"MAX(J35,J22,J19)","v":21.030133116551458},{"$f":"IF($V$3=10,FHWA!$B$6/(J36+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J36+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J36+FHWA!$C$9)^FHWA!$D$9))","v":3.7638183082804488}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F36*K36","v":30.200878105642325},928.5,928.24,20,{"$f":"(M37-N37)/O37","v":1.2999999999999545E-2},30,1.2E-2,10.790953747474576,{"$f":"O37/S37/60","v":3.0890071548248813E-2},50.66783379674267,0.59605623218065973]
["Outfall","18+54",null,null,null,{"$f":"F36","v":8.0240000000000009},null,null,null,{"$f":"MAX(J36+T37,G38)","v":21.061023188099707},{"$f":"IF($V$3=10,FHWA!$B$6/(J38+FHWA!$C$6)^FHWA!$D$6,IF($V$3=25,FHWA!$B$7/(J38+FHWA!$C$7)^FHWA!$D$7,FHWA!$B$9/(J38+FHWA!$C$9)^FHWA!$D$9))","v":3.7609459565066583}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F38*K38","v":30.17783035500943}]
[]
[]
[]
[]
[]
[]
[]
["     ","     ",null,"     ","     ","     ","     ",null,null,null,"     ","     ",null,null,"     ",null,"     ",null,"     "]

{"sheet":"Layout","index":3,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RCL 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RCL 2"]

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

{"sheet":"IDF Data","index":5,"n_rows":170,"n_cols":11,"rows_kept":170,"cut":false,"hidden":true,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,9]]}
[null,"10-YR",null,null,"25-YR",null,null,"100-YR"]
["County","A0","A1","A2","A0","A1","A2","A0","A1","A2"]
["Adair East",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Adair West",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Allen",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Anderson East",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Anderson West",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Ballard",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Barren North",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Barren South",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Bath",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Bell",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Boone",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Bourbon",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Boyd East",9.25,-0.04,-8.7999999999999995E-2,10.72,-3.9E-2,-8.6999999999999994E-2,12.91,-3.7999999999999999E-2,-8.5999999999999993E-2,"Parkersburg"]
["Boyd West",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Boyle",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Bracken North",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Bracken South",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Breathitt",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Breckinridge East",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Breckinridge West",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Bullitt",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Butler North",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Butler South",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Caldwell East",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Caldwell West",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Calloway",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Campbell",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Carlisle",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Carroll East",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Carroll West",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Carter",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Casey",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Christian North",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Christian South",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Clark",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Clay North",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Clay South",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Clinton East",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Clinton North",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Clinton West",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Crittenden East",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Crittenden West",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Cumberland NE",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Cumberland North",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Cumberland South",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Daviess",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Edmonson North",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Edmonson South",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Edmonson West",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Elliott",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Estill",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Fayette",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Fleming",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Floyd East",6.9,8.5000000000000006E-2,-9.6000000000000002E-2,7.45,0.128,-0.10100000000000001,8.32,0.17399999999999999,-0.106,"Wytheville"]
["Floyd West",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Franklin",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Fulton",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Gallatin",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Garrard",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Grant North",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Grant South",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Graves",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Grayson East",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Grayson West",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Green",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Greenup East",9.25,-0.04,-8.7999999999999995E-2,10.72,-3.9E-2,-8.6999999999999994E-2,12.91,-3.7999999999999999E-2,-8.5999999999999993E-2,"Parkersburg"]
["Greenup North",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Greenup West",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Hancock",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Hardin",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Harlan",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Harrison",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Hart",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Henderson",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Henry East",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Henry West",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Hickman",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Jackson",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Jefferson",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Jessamine",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Johnson",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Kenton",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Knott East",6.9,8.5000000000000006E-2,-9.6000000000000002E-2,7.45,0.128,-0.10100000000000001,8.32,0.17399999999999999,-0.106,"Wytheville"]
["Knott South",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Knott West",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Knox",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Larue",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Laurel North",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Laurel South",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Lawrence East",9.25,-0.04,-8.7999999999999995E-2,10.72,-3.9E-2,-8.6999999999999994E-2,12.91,-3.7999999999999999E-2,-8.5999999999999993E-2,"Parkersburg"]
["Lawrence South",6.9,8.5000000000000006E-2,-9.6000000000000002E-2,7.45,0.128,-0.10100000000000001,8.32,0.17399999999999999,-0.106,"Wytheville"]
["Lawrence West",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Lee",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Leslie North",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Leslie South",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Letcher East",6.9,8.5000000000000006E-2,-9.6000000000000002E-2,7.45,0.128,-0.10100000000000001,8.32,0.17399999999999999,-0.106,"Wytheville"]
["Letcher West",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Lewis North",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Lewis South",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Lincoln",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Livingston",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Logan",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Lyon",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Madison",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Magoffin",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Marion East",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Marion West",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Marshall",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Martin East",6.9,8.5000000000000006E-2,-9.6000000000000002E-2,7.45,0.128,-0.10100000000000001,8.32,0.17399999999999999,-0.106,"Wytheville"]
["Martin West",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Mason North",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Mason South",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["McCracken",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["McCreary",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["McLean",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Meade",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Menifee",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Mercer",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Metcalfe North",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Metcalfe South",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Monroe",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Montgomery",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Morgan",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Muhlenberg South",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Muhlenburg North",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Nelson",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Nicholas",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Ohio",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Oldham",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Owen North",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Owen South",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Owen West",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Owsley",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Pendleton North",8.5299999999999994,0,-8.7999999999999995E-2,9.26,3.7999999999999999E-2,-9.1999999999999998E-2,10.37,7.9000000000000001E-2,-9.7000000000000003E-2,"Cincinnati"]
["Pendleton South",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Perry North",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Perry South",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Pike",6.9,8.5000000000000006E-2,-9.6000000000000002E-2,7.45,0.128,-0.10100000000000001,8.32,0.17399999999999999,-0.106,"Wytheville"]
["Powell",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Pulaski North",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Pulaski South",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Robertson",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Rockcastle",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Rowan",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Russell North",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Russell South",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Scott",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Shelby East",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Shelby West",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Simpson",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Spencer",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Taylor East",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Taylor West",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Todd",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Trigg East",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Trigg North",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Trigg West",9.4499999999999993,-0.04,-7.3999999999999996E-2,10.95,-4.2999999999999997E-2,-7.1999999999999995E-2,13.17,-4.7E-2,-7.0000000000000007E-2,"Cairo"]
["Trimble",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Union",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Warren",11.68,-0.182,-5.8999999999999997E-2,13.89,-0.20499999999999999,-5.3999999999999999E-2,17.170000000000002,-0.22900000000000001,-4.9000000000000002E-2,"Nashville"]
["Washington East",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Washington West",9.3699999999999992,-5.8999999999999997E-2,-7.9000000000000001E-2,10.47,-3.6999999999999998E-2,-8.1000000000000003E-2,12.11,-1.4E-2,-8.4000000000000005E-2,"Louisville"]
["Wayne North",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Wayne South",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Webster",9.23,-6.4000000000000001E-2,-7.3999999999999996E-2,10.53,-6.0999999999999999E-2,-7.1999999999999995E-2,12.44,-5.8999999999999997E-2,-7.0999999999999994E-2,"Evansville"]
["Whitley",5.9,0.20399999999999999,-0.111,6.24,0.254,-0.11600000000000001,6.81,0.307,-0.122,"Knoxville"]
["Wolfe",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]
["Woodford",6.96,8.5999999999999993E-2,-9.2999999999999999E-2,7.64,0.114,-9.5000000000000001E-2,8.66,0.14499999999999999,-9.7000000000000003E-2,"Lexington"]

{"sheet":"NOAA Data2","index":6,"n_rows":22,"n_cols":32,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,29,1,31],[12,18,14,18],[12,25,12,26],[13,25,13,26],[14,25,14,26],[1,19,1,24],[2,25,2,26],[3,18,5,18],[3,25,3,26],[4,25,4,26],[5,25,5,26],[6,18,8,18],[6,25,6,26],[7,25,7,26],[8,25,8,26],[9,18,11,18],[15,25,15,26],[16,25,16,26],[9,25,9,26],[10,25,10,26],[11,25,11,26],[0,12,0,14],[0,0,0,10],[1,0,2,0],[1,1,1,10],[15,18,16,18]]}
["PDS-based precipitation frequency estimates with 90% confidence intervals (in inches/hour)",null,null,null,null,null,null,null,null,null,null,null,"LOCATION INFORMATION"]
["Duration","Average recurrence interval(years)",null,null,null,null,null,null,null,null,null,null,"Name: Frenchburg, Kentucky, USA*",null,null,null,{"$f":"MID(M2,6,FIND(\"Kentucky\",M2,1)+2)","v":" Frenchburg, Kentucky"},null,null,"DESIGN STORM",null,null,null,null,null,null,null,null,null,"IDF Variables*"]
[null,1,2,5,10,25,50,100,200,500,1000,null,null,null,null,null,null,null,"tc",2,5,10,25,50,100,"IDF",null,null,"RI","a","b","m"]
["5-min",4.28,5.09,6,6.71,7.66,8.4,9.1300000000000008,9.9,10.9,11.7,null,"Station name: -",null,null,null,"Lat/Long",null,5,null,null,null,null,null,null,"FHWA",null,null,2]
["10-min",3.38,4.03,4.75,5.3,6.01,6.56,7.12,7.66,8.3699999999999992,8.93,null,"Site ID: -",null,null,null,{"$f":"MID(M6,10,10)","v":" 37.9579°"},null,null,null,null,null,null,null,null,"NOAA",null,null,5]
["15-min",2.8,3.34,3.95,4.42,5.0199999999999996,5.48,5.94,6.4,6.99,7.45,null,"Latitude: 37.9579°",null,null,null,{"$f":"MID(M7,12,10)","v":"-83.6640°"},null,null,null,null,null,null,null,null,"Diff",null,null,10]
["30-min",1.89,2.2799999999999998,2.77,3.15,3.65,4.05,4.45,4.8600000000000003,5.42,5.86,null,"Longitude: -83.6640°",null,null,null,null,null,10,null,null,null,null,null,null,"FHWA",null,null,25]
["60-min",1.17,1.42,1.76,2.0299999999999998,2.41,2.71,3.03,3.37,3.83,4.21,null,"Elevation: 973 ft **",null,null,null,null,null,null,null,null,null,null,null,null,"NOAA",null,null,50]
["2-hr",0.68200000000000005,0.82199999999999995,1.02,1.18,1.4,1.59,1.78,1.99,2.29,2.5299999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff",null,null,100]
["3-hr",0.48399999999999999,0.58199999999999996,0.72099999999999997,0.83399999999999996,0.995,1.1299999999999999,1.27,1.42,1.63,1.81,null,null,null,null,null,null,null,15,null,null,null,null,null,null,"FHWA"]
["6-hr",0.29299999999999998,0.35099999999999998,0.432,0.498,0.59299999999999997,0.67200000000000004,0.755,0.84499999999999997,0.97299999999999998,1.08,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOAA",null,null,"* I = a / (tc + b) ^ m"]
["12-hr",0.17399999999999999,0.20799999999999999,0.254,0.29299999999999998,0.34699999999999998,0.39200000000000002,0.44,0.49099999999999999,0.56399999999999995,0.624,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff"]
["24-hr",0.106,0.126,0.152,0.17299999999999999,0.20300000000000001,0.22700000000000001,0.251,0.27700000000000002,0.312,0.34,null,null,null,null,null,null,null,30,null,null,null,null,null,null,"FHWA"]
["2-day",6.4000000000000001E-2,7.5999999999999998E-2,9.0999999999999998E-2,0.104,0.121,0.13400000000000001,0.14799999999999999,0.16200000000000001,0.18099999999999999,0.19600000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOAA"]
["3-day",4.5999999999999999E-2,5.3999999999999999E-2,6.5000000000000002E-2,7.2999999999999995E-2,8.5000000000000006E-2,9.4E-2,0.10299999999999999,0.112,0.124,0.13300000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff"]
["4-day",3.6999999999999998E-2,4.2999999999999997E-2,5.1999999999999998E-2,5.8000000000000003E-2,6.7000000000000004E-2,7.3999999999999996E-2,0.08,8.6999999999999994E-2,9.6000000000000002E-2,0.10199999999999999,null,null,null,null,null,null,null,60,null,null,null,null,null,null,"FHWA"]
["7-day",2.5000000000000001E-2,0.03,3.5999999999999997E-2,0.04,4.5999999999999999E-2,5.0999999999999997E-2,5.5E-2,0.06,6.7000000000000004E-2,7.0999999999999994E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOAA"]
["10-day",0.02,2.4E-2,2.8000000000000001E-2,3.2000000000000001E-2,3.5999999999999997E-2,3.9E-2,4.2000000000000003E-2,4.4999999999999998E-2,4.9000000000000002E-2,5.1999999999999998E-2]
["20-day",1.4E-2,1.7000000000000001E-2,0.02,2.1999999999999999E-2,2.4E-2,2.5999999999999999E-2,2.8000000000000001E-2,0.03,3.2000000000000001E-2,3.3000000000000002E-2]
["30-day",1.2E-2,1.4E-2,1.6E-2,1.7999999999999999E-2,0.02,2.1000000000000001E-2,2.1999999999999999E-2,2.4E-2,2.5000000000000001E-2,2.5999999999999999E-2]
["45-day",0.01,1.2E-2,1.2999999999999999E-2,1.4E-2,1.6E-2,1.7000000000000001E-2,1.7999999999999999E-2,1.9E-2,0.02,0.02]
["60-day",8.9999999999999993E-3,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2,1.4E-2,1.4999999999999999E-2,1.6E-2,1.6E-2,1.7000000000000001E-2,1.7999999999999999E-2]

{"sheet":"FHWA","index":7,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[26,0,28,0],[1,1,1,3],[12,1,12,6],[14,0,16,0],[17,0,19,0],[20,0,22,0],[23,0,25,0]]}
[]
[null,"IDF Variables*"]
["RI","a","b","m"]
[2,52.183077382838732,10.657833999866853,0.84605766958436623]
[5,45.60614893459536,9.0599112306381357,0.76732188025663794]
[10,41.628747549798668,7.8645861525940264,0.71450677075940439]
[25,35.119025350674882,5.898571576532504,0.63749091660237756]
[50,32.205043522093845,4.7231123784622469,0.59084983772341715]
[100,30.21661876951687,3.7859254271688432,0.55073316900329028]
[]
["* I = a / (tc + b) ^ m"]
[]
[null,"DESIGN STORM CHECK"]
["tc",2,5,10,25,50,100]
[5,5.0899999999983097,5.9999999999998819,6.7099999999999547,7.660000000000017,8.3999999999998352,9.1300000000001518]
[null,5.09,6,6.71,7.66,8.4,9.1300000000000008]
[null,-1.6902035326893383E-12,-1.1812772982011666E-13,-4.5297099404706387E-14,1.6875389974302379E-14,-1.6520118606422329E-13,1.5099033134902129E-13]
[10,4.0261701074317049,4.7507113684684938,5.3068388281044419,6.0212626828287732,6.5737245178146049,7.1239474545668724]
[null,4.03,4.75,5.3,6.01,6.56,7.12]
[null,-3.8298925682953566E-3,7.1136846849384483E-4,6.8388281044420296E-3,1.1262682828773407E-2,1.3724517814605264E-2,3.9474545668722882E-3]
[15,3.3515700861586026,3.9730705421347943,4.4489951487346753,5.0580149806432946,5.5307987542674422,6.0076414354593117]
[null,3.34,3.95,4.42,5.0199999999999996,5.48,5.94]
[null,1.1570086158602777E-2,2.3070542134794092E-2,2.8995148734675347E-2,3.8014980643295004E-2,5.0798754267441737E-2,6.7641435459311339E-2]
[30,2.2703920779890763,2.7393856982199365,3.1026660046366326,3.5825716531256995,3.9595844814779806,4.3483084459466683]
[null,2.2799999999999998,2.77,3.15,3.65,4.05,4.45]
[null,-9.6079220109235308E-3,-3.0614301780063524E-2,-4.7333995363367354E-2,-6.7428346874300438E-2,-9.0415518522019234E-2,-0.10169155405333186]
[60,1.4224382297486615,1.7690700764730183,2.0448990501191227,2.4323469654306384,2.7406889056799635,3.0642487918257051]
[null,1.42,1.76,2.0299999999999998,2.41,2.71,3.03]
[null,2.4382297486615911E-3,9.0700764730182737E-3,1.4899050119122847E-2,2.2346965430638299E-2,3.0688905679963518E-2,3.4248791825705283E-2]

{"sheet":"Revision Comments","index":8,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,24]]}
["DATE","COMMENT"]
["2017-01-16","Reformats the new NOAA data format from the NOAA website so the program can read the data properly.  Currently NOAA data intensity and S.D. values paste as merged values into a single cell.  This update removes the S.D. values when the macro is executed."]
[null,"Updated the error and messaging logic."]

{"sheet":"Counties","index":9,"n_rows":168,"n_cols":3,"rows_kept":168,"cut":false,"hidden":true,"merged":[]}
["Adair",null,"Adair East"]
["Allen",null,"Adair West"]
["Anderson ",null,"Allen"]
["Ballard",null,"Anderson East"]
["Barren",null,"Anderson West"]
["Bath",null,"Ballard"]
["Bell",null,"Barren North"]
["Boone",null,"Barren South"]
["Bourbon",null,"Bath"]
["Boyd",null,"Bell"]
["Boyle ",null,"Boone"]
["Bracken ",null,"Bourbon"]
["Breathitt",null,"Boyd East"]
["Breckinridge",null,"Boyd West"]
["Bullitt",null,"Boyle"]
["Butler",null,"Bracken North"]
["Caldwell",null,"Bracken South"]
["Calloway",null,"Breathitt"]
["Campbell",null,"Breckinridge East"]
["Carlisle",null,"Breckinridge West"]
["Carroll",null,"Bullitt"]
["Carter ",null,"Butler North"]
["Casey",null,"Butler South"]
["Christian",null,"Caldwell East"]
["Clark ",null,"Caldwell West"]
["Clay",null,"Calloway"]
["Clinton",null,"Campbell"]
["Crittenden",null,"Carlisle"]
["Cumberland",null,"Carroll East"]
["Daviess",null,"Carroll West"]
["Edmonson ",null,"Carter"]
["Elliott ",null,"Casey"]
["Estill",null,"Christian North"]
["Fayette",null,"Christian South"]
["Fleming",null,"Clark"]
["Floyd ",null,"Clay North"]
["Franklin",null,"Clay South"]
["Fulton",null,"Clinton East"]
["Gallatin",null,"Clinton North"]
["Garrard ",null,"Clinton West"]
["Grant",null,"Crittenden East"]
["Graves",null,"Crittenden West"]
["Grayson",null,"Cumberland NE"]
["Green",null,"Cumberland North"]
["Greenup ",null,"Cumberland South"]
["Hancock",null,"Daviess"]
["Hardin ",null,"Edmonson North"]
["Harlan",null,"Edmonson South"]
["Harrison",null,"Edmonson West"]
["Hart ",null,"Elliott"]
["Henderson",null,"Estill"]
["Henry",null,"Fayette"]
["Hickman",null,"Fleming"]
["Hopkins",null,"Floyd East"]
["Jackson",null,"Floyd West"]
["Jefferson",null,"Franklin"]
["Jessamine ",null,"Fulton"]
["Johnson",null,"Gallatin"]
["Kenton",null,"Garrard"]
["Knott",null,"Grant North"]
["Knox",null,"Grant South"]
["Larue",null,"Graves"]
["Laurel",null,"Grayson East"]
["Lawrence",null,"Grayson West"]
["Lee",null,"Green"]
["Leslie",null,"Greenup East"]
["Letcher",null,"Greenup North"]
["Lewis",null,"Greenup West"]
["Lincoln ",null,"Hancock"]
["Livingston",null,"Hardin"]
["Logan",null,"Harlan"]
["Lyon",null,"Harrison"]
["Madison",null,"Hart"]
["Magoffin",null,"Henderson"]
["Marion",null,"Henry East"]
["Marshall",null,"Henry West"]
["Martin",null,"Hickman"]
["Mason",null,"Jackson"]
["McCracken",null,"Jefferson"]
["McCreary",null,"Jessamine"]
["McLean",null,"Johnson"]
["Meade ",null,"Kenton"]
["Menifee",null,"Knott East"]
["Mercer ",null,"Knott South"]
["Metcalfe",null,"Knott West"]
["Monroe",null,"Knox"]
["Montgomery ",null,"Larue"]
["Morgan ",null,"Laurel North"]
["Muhlenburg",null,"Laurel South"]
["Nelson",null,"Lawrence East"]
["Nicholas",null,"Lawrence South"]
["Ohio",null,"Lawrence West"]
["Oldham",null,"Lee"]
["Owen",null,"Leslie North"]
["Owsley",null,"Leslie South"]
["Pendleton",null,"Letcher East"]
["Perry",null,"Letcher West"]
["Pike",null,"Lewis North"]
["Powell",null,"Lewis South"]
["Pulaski",null,"Lincoln"]
["Robertson",null,"Livingston"]
["Rockcastle",null,"Logan"]
["Rowan ",null,"Lyon"]
["Russell",null,"Madison"]
["Scott ",null,"Magoffin"]
["Shelby",null,"Marion East"]
["Simpson",null,"Marion West"]
["Spencer",null,"Marshall"]
["Taylor",null,"Martin East"]
["Todd",null,"Martin West"]
["Trigg",null,"Mason North"]
["Trimble",null,"Mason South"]
["Union",null,"McCracken"]
["Warren ",null,"McCreary"]
["Washington",null,"McLean"]
["Wayne",null,"Meade"]
["Webster",null,"Menifee"]
["Whitley",null,"Mercer"]
["Wolfe",null,"Metcalfe North"]
["Woodford ",null,"Metcalfe South"]
[null,null,"Monroe"]
[null,null,"Montgomery"]
[null,null,"Morgan"]
[null,null,"Muhlenberg South"]
[null,null,"Muhlenburg North"]
[null,null,"Nelson"]
[null,null,"Nicholas"]
[null,null,"Ohio"]
[null,null,"Oldham"]
[null,null,"Owen North"]
[null,null,"Owen South"]
[null,null,"Owen West"]
[null,null,"Owsley"]
[null,null,"Pendleton North"]
[null,null,"Pendleton South"]
[null,null,"Perry North"]
[null,null,"Perry South"]
[null,null,"Pike"]
[null,null,"Powell"]
[null,null,"Pulaski North"]
[null,null,"Pulaski South"]
[null,null,"Robertson"]
[null,null,"Rockcastle"]
[null,null,"Rowan"]
[null,null,"Russell North"]
[null,null,"Russell South"]
[null,null,"Scott"]
[null,null,"Shelby East"]
[null,null,"Shelby West"]
[null,null,"Simpson"]
[null,null,"Spencer"]
[null,null,"Taylor East"]
[null,null,"Taylor West"]
[null,null,"Todd"]
[null,null,"Trigg East"]
[null,null,"Trigg North"]
[null,null,"Trigg West"]
[null,null,"Trimble"]
[null,null,"Union"]
[null,null,"Warren"]
[null,null,"Washington East"]
[null,null,"Washington West"]
[null,null,"Wayne North"]
[null,null,"Wayne South"]
[null,null,"Webster"]
[null,null,"Whitley"]
[null,null,"Wolfe"]
[null,null,"Woodford"]

{"sheet":"Updates","index":10,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,1,0,16],[1,0,2,0]]}
["DATE","DESCRIPTION"]
["2014-10-01","Moved county names to separate speadsheet to eliminate accidental deletion and assigned a named range to them so I could use them in Data Validation."]
[null,"Moved rational area county names to separate speadsheet.  No longer used."]