{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ReadMe","Project Location","Tributary Area","BMP Design","Results Summary Report","Graph Parameters","Rain Gage Summary"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":3,"defined_names":37,"comments":0,"pivot_tables":2},"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":"ReadMe","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[25,1,25,5],[25,6,25,11],[8,1,8,11],[9,1,9,11],[19,1,19,5],[19,6,19,11],[2,1,2,11],[10,1,10,11],[11,1,11,11],[12,1,12,11],[18,1,18,5],[18,6,18,11],[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,1,6,11],[7,1,7,11],[26,1,26,5],[26,6,26,11],[27,1,27,5],[27,6,27,11],[28,1,28,5],[28,6,28,11]]}
["NCHRP 25-51 Roadside BMP Clogging Risk Assessment Tool"]
["Readme Notes"]
[1,"Please read the User's Guide before using the Tool."]
[2,"Tool inputs are intended to be populated sequentially (i.e., Project Location, Tributary Area, then BMP Design). Inputs on previous tabs can later be modified by skipping backward and forward, however skipping forward as part of the initial tool parameterization will potentially introduce errors."]
[3,"The tool is navigated using the tabs at the bottom of the workbook. "]
[4,"The user is responsible for ensuring that input parameters are reasonable. It is possible to enter inputs that are outside of acceptable ranges. Valid ranges are provided in cell descriptions. Negative numbers are never reasonable for populating the Tool and will not return valid results. "]
[5,"The user should review all provided descriptions and ensure that default values are applicable to the project site."]
[6,"Where dropdown boxes are available for input parameters, values must be selected from the dropdown menu. The Tool cannot accept custom inputs for these fields. "]
[7,"The Tool requires macros to be enabled. If macros are not enabled, the Tool will not function."]
[8,"The Tool is intended to be operated with Excel set to \"Auto Calculate\" mode; not \"Manual Calculate\" mode. To change this setting, go to the \"Formulas\" ribbon and select \"Calculation Options\"."]
[9,"Any changes to the structure of this workbook (tab names, inserting or deleting columns or rows, etc.) will render the Tool non-functional. Several precautions were taken to prevent this kind of action, but it is ultimately the user's responsibility to maintain a functional workbook. The user may create new worksheets for the purpose of calculations and notes, but any other structural changes must be avoided. "]
[10,"The workbook is saved as a Template file (.xltm). Opening the file by double-clicking will create a new macro-enabled workbook (.xlsm) that can be saved by the user without the risk of over-writing the template. If the user would like to edit the template, first open Excel and then navigate to the .xltm file."]
[11,"Many cells and sheets in this workbook are protected. To unprotect/protect a sheet, go to \"Review\" or \"File\" and click the appropriate selection. The password is \"NCHRP\". It is the user's responsibility to maintain a functional workbook."]

{"sheet":"Project Location","index":1,"n_rows":51,"n_cols":29,"rows_kept":51,"cut":false,"hidden":false,"merged":[[22,14,25,15],[0,14,0,15],[18,14,18,15],[7,14,7,15],[9,2,9,8],[10,2,10,8],[7,0,7,11]]}
[{"$f":"ReadMe!A1","v":"NCHRP 25-51 Roadside BMP Clogging Risk Assessment Tool"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Key",null,null,null,null,null,null,null,null,"Section","State",null,{"$f":"VLOOKUP(C11,Y2:Z51,2,FALSE)","v":{"$error":"#N/A"}},"Section",4]
["Project Title",null,"Example Run",null,null,null,null,null,null,null,null,null,null,null,"User Steps","Default data; editing allowed with rationale",null,null,null,null,null,null,null,7,"Alabama","AL"]
["Project Location",null,"Horton, KS",null,null,null,null,null,null,null,null,null,null,null,"User Entered Data","Guidance",null,null,null,null,null,null,null,"X","Alaska","AK",null,"Row Labels"]
["Company",null,"ABC Engineering",null,null,null,null,null,null,null,null,null,null,null,"Reference Data; do not edit cells","Reference Links",null,null,null,null,null,null,null,2,"Arizona","AZ",null,"Colorado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Arkansas","AR",null,"Kansas"]
["Project Location and Climate Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"California","CA",null,"New Mexico"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Colorado","CO",null,"Oklahoma"]
["Step 1: Select the Region your Project is Located",null,null,null,null,null,null,null,null,null,null,null,null,null,"Step 2: Select the state your project is located and the rain gage closest to the project",null,null,null,null,null,null,null,null,10,"Connecticut","CT",null,"Texas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Delaware","DE",null,"Grand Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"States within Selected Region","Rain Gages Available in State",null,null,null,null,null,null,null,7,"Florida","FL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kansas","[3] NORTHEAST - HORTON",null,null,null,null,null,null,null,7,"Georgia","GA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","Hawaii","HI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Idaho","ID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COOP ID",{"$f":"IF(P11=\"\",\"Select Rain Gage\",VLOOKUP(P11,'Rain Gage Summary'!B2:J348,9,FALSE))","v":143810},null,null,null,null,null,null,null,5,"Illinois","IL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elevation (ft)",{"$f":"IF(P11=\"\",\"Select Rain Gage\",VLOOKUP(P11,'Rain Gage Summary'!B2:J348,5,FALSE))","v":1030},null,null,null,null,null,null,null,5,"Indiana","IN",null,"# states"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Annual Precipitation Depth (in)",{"$f":"IF(P11=\"\",\"Select Rain Gage\",VLOOKUP(P11,'Rain Gage Summary'!B2:J348,8,FALSE))","v":35.444405866639698},null,null,null,null,null,null,null,3,"Iowa","IA",null,{"$f":"COUNTA(AB4:AB14)-1","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"85th Percentile, 24-Hour Storm Depth (in)",{"$f":"IF(P11=\"\",\"Select Rain Gage\",VLOOKUP(P11,'Rain Gage Summary'!B3:J349,6,FALSE))","v":1.1000000000000001},null,null,null,null,null,null,null,4,"Kansas","KS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Kentucky","KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Step 3: If available, override the existing data and provide project specific rain data ",null,null,null,null,null,null,null,null,7,"Louisiana","LA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Maine","ME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Location Average Annual Precipitation Depth (in)",35.444405866639698,null,null,null,null,null,null,null,8,"Maryland","MD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Location 85th Percentile, 24-Hour Storm Depth (in)",1.1000000000000001,null,null,null,null,null,null,null,10,"Massachusetts","MA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjust the annual and 85th percentile storm depths to a project specific value. If a new rain gauge is selected, the entries in the cells above will be reset to the default values for the selected rain gage. Precipitation statistics are for load and reference calculations only, they do not imply a BMP size which is entered on the BMP Design Tab.",null,null,null,null,null,null,null,null,5,"Michigan","MI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Minnesota","MN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Mississippi","MS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Missouri","MO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Montana","MT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Nebraska","NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Nevada","NV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"New Hampshire","NH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"New Jersey","NJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"New Mexico","NM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"New York","NY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"North Carolina","NC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"North Dakota","ND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Ohio","OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Oklahoma","OK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Oregon","OR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Pennsylvania","PA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Rhode Island","RI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"South Carolina","SC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"South Dakota","SD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Tennessee","TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Texas","TX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Utah","UT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Vermont","VT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Virginia","VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Washington","WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"West Virginia","WV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Wisconsin","WI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Wyoming","WY"]

{"sheet":"Tributary Area","index":2,"n_rows":149,"n_cols":26,"rows_kept":149,"cut":false,"hidden":false,"merged":[[41,0,41,2],[0,3,0,4],[36,0,36,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[7,0,7,2],[13,0,13,2],[23,0,23,2],[25,0,25,2],[29,0,29,2],[31,0,31,2]]}
[{"$f":"'Project Location'!A1","v":"NCHRP 25-51 Roadside BMP Clogging Risk Assessment Tool"},null,null,"Key"]
["Project Title",{"$f":"'Project Location'!C2","v":"Example Run"},null,"User Steps","Default data; editing allowed with rationale"]
["Project Location",{"$f":"'Project Location'!C3","v":"Horton, KS"},null,"User Entered Data","Guidance"]
["Company",{"$f":"'Project Location'!C4","v":"ABC Engineering"},null,"Reference Data; do not edit cells","Reference Links"]
[]
["Tributary Area Attributes"]
[]
["Step 1: Provide data describing the roadway sediment concentration",null,null,null,null,null,"Look Up Tables and Lists"]
["Sediment Concentration Parameter","Value","Guidance",null,null,null,{"$f":"B10","v":"25K to 50K"},{"$f":"VLOOKUP(G9,G11:H15,2,FALSE)","v":57},{"$f":"B20","v":"Yes"}]
["Average Annual Daily Traffic Volume ","25K to 50K","Enter the average annual daily traffic (AADT) volume, the average number of vehicles that pass a roadway point in 24 hours. This value will be used to determine the default roadway TSS concentration.",null,null,null,"AADT","TSS (mg/L)","Additional Run On Area"]
["Default Roadway TSS Concentration (mg/L)",{"$f":"H9","v":57},"Default roadway TSS concentrations are median values based on AADT recorded in the Highway Runoff Database (HRDB; Granato & Cazenas, 2009).",null,null,null,"Less than 25K",43,"Yes"]
["User-Provided Roadway TSS Concentration (mg/L)",50,"Enter a site-specific roadway TSS concentration if available. If no value is entered here, the default roadway TSS concentration will be used.",null,null,null,"25K to 50K",57,"No"]
[null,null,null,null,null,null,"50K to 100K",95]
["Step 2: Provide data describing the roadway tributary area of the project",null,null,null,null,null,"Greater than 100K",107]
["Tributary Area Parameter","Value","Guidance",null,null,null,"Unknown (All AADT Combined)",70]
["Roadway Drainage Area (ac)",9.5,"Include roadway areas, medians, shoulders, adjacent structures, runoff conveyances, and other urban areas. Exclude any hydrologically-isolated areas (e.g. isolated pervious or self-sustained areas) and run-on from non-roadway land uses."]
["Imperviousness of Roadway Drainage Area (%)",1,"The directly connected impervious percentage should be used. If unknown, 100% should be used to provide a conservative estimate."]
["Calculated Runoff Coefficient",{"$f":"IF((B17)<0.55, 0.225*(B17)+0.129, 1.14*(B17)-0.371)","v":0.76899999999999991},"This runoff coefficient is calculated based on a Two-line regression model of the volumetric runoff coefficient (Rv) (Granato, 2010), where Rv(%<55) = imperviousness (%) × 0.225 + 0.05, Rv(%>55) = imperviousness (%) × 1.14 - 0.371."]
["User-Provided Runoff Coefficient",0.8,"Enter a site-specific runoff coefficient if available. If no value is entered here, the calculated runoff coefficient will be used."]
["Does the site include additional run-on area?","Yes","Non-roadway, pervious areas such as open space, forest, or agriculture land that drain to the BMP. If Yes, the RUSLE off-site sediment load calculator will be completed."]
[]
[]
[]
["Step 3: Complete RUSLE Off-Site Sediment Load Calculator"]
["RUSLE Input Parameter","Value","Guidance",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N27=\"Bare Soil/Construction (0 ft)\",N27=\"Grass/Weeds, No Canopy (0 ft)\"),\"Hide\",\"Unhide\")","v":"Hide"},null,null,null,null,null,null,"C Factor for Permanent Pasture, Range, and Idle Lands (Table 10, Wischmeier and Smith, 1978)"]
["Drainage Area",null,null,null,null,null,"RUSLE Calculation",null,null,null,null,{"$f":"IF(B36=\"\",\"Enter K Factor\",B36)","v":0.2},null,{"$f":"IF(N27=\"Bare Soil/Construction (0 ft)\",\"Bare\",\"Vegetated\")","v":"Vegetated"},null,null,null,null,null,null,"C Factor:",{"$f":"IF(N27=\"Bare Soil/Construction (0 ft)\",V29,V27)","v":3.0000000000000001E-3}]
["Additional Run-On Area from Erodible Open Space (ac)",2.5,"Only include pervious area from off-site (non-roadway) drainage. This can include land uses such as open space, forest, and agriculture land. Urban land uses should be included in the roadway drainage area. This area is used to determine the potential for clogging from off-site drainage.",null,null,null,{"$f":"B33","v":"No"},{"$f":"B34","v":"Silty Clay"},{"$f":"B35","v":0.5},null,"K Factor Calculation",{"$f":"INDEX(L29:L59,MATCH(B34&B35,J29:J59&K29:K59,0))","v":0.25},null,{"$f":"B38","v":"Grass/Weeds, No Canopy (0 ft)"},{"$f":"IF(N27=\"Bare Soil/Construction (0 ft)\",0,IF(N27=\"Grass/Weeds, No Canopy (0 ft)\",0,B39))","v":0},{"$f":"B40","v":"Grass"},{"$f":"B41","v":"95+"},null,null,null,"Index Match:",{"$f":"INDEX(V29:V149,MATCH(N27&O27&P27&Q27,R29:R149&S29:S149&T29:T149&U29:U149,0))","v":3.0000000000000001E-3},{"$f":"INDEX(W29:W149,MATCH(N27&O27&P27&Q27,R29:R149&S29:S149&T29:T149&U29:U149,0))","v":"Low"},null,"LS Factor Calculation:",{"$f":"Z34*Z35","v":0.51850516808482094}]
["Length of Flow Path (ft)",50,"Horizontal distance from the origin of overland flow to the point where channelized flow begins or deposition occurs due to a reduction in slope. Surface runoff will usually concentrate in less than 400 ft, though lengths up to 1000 ft may be found. Refer to Renard et al. (1997), Chapter 4 for guidance. Valid range = 15 - 1000 ft.",null,null,null,"K Factor Known","Texture Class","Organic Matter","Texture Class","Organic Matter","K Factor",null,"Plant Canopy List","Percent Canopy Cover","Ground Cover Type","Percent Ground Cover","Plant Canopy Type","Canopy Cover (%)","Ground Cover Type","Ground Cover (%)","C Factor","Rill Erosion Potential",null,"Parameter","Value"]
["Slope of Flow Path (%)",5,"The slope of flow path is the vertical distance/horizontal distance (%) along the length of the flow path. Refer to Renard et al. (1997), Chapter 4 for guidance. Valid range = 0.2 - 60%",null,null,null,"Yes","Fine Sand",0.5,"Fine Sand",0.5,0.16,null,"Bare Soil/Construction (0 ft)",25,"Grass",0,"Bare Soil/Construction (0 ft)","NA","NA","NA",1,"High",null,"Slope Angle (degrees):",{"$f":"DEGREES(ATAN(B29/100))","v":2.8624052261117479}]
["Climate",null,null,null,null,null,"No","Very Fine Sand",2,"Fine Sand",2,0.14000000000000001,null,"Grass/Weeds, No Canopy (0 ft)",50,"Weeds",20,"Grass/Weeds, No Canopy (0 ft)",0,"Grass",0,0.45,{"$f":"IF(V30>0.2,\"Moderate\",\"Low\")","v":"Moderate"},null,"Ratio of Rill to Interrill Erosion (β):",{"$f":"(SIN(RADIANS(Z29))/0.0896)/(3*SIN(RADIANS(Z29))^0.8+0.56)","v":0.66922601929778547}]
["Rainfall-Runoff Erosivity Factor (R)",10,"Refer to US EPA (2012) Figures 2 - 5 or local guidance to establish R value. Valid range = 10 - 700",null,null,null,null,"Loamy Sand",4,"Fine Sand",4,0.1,null,"Tall Weeds/Short Brush (1.6 ft)",75,null,40,"Grass/Weeds, No Canopy (0 ft)",0,"Grass",20,0.2,"Low",null,"Rill Erosion Potential:",{"$f":"IF(V26=1,\"High\",W27)","v":"Low"}]
["Soil Type",null,null,null,null,null,null,"Loamy Very Fine Sand",null,"Very Fine Sand",0.5,0.42,null,"Brush or Bushes (6.5 ft)",null,null,60,"Grass/Weeds, No Canopy (0 ft)",0,"Grass",40,0.1,"Low",null,"Modified β: ",{"$f":"IF(Z31=\"Low\",Z30/2,IF(Z31<>\"Moderate\",Z30,2*Z30))","v":0.33461300964889273}]
["Is the soil erodibility factor known?","No","If Yes is selected a user provided K value will be entered. Refer to the NRCS Web Soil Survey, Soil Erosion Factors Tab to determine K value for a project location. \nIf No is selected the K value will be calculated based on soil texture and organic matter content.",null,null,null,null,"Sandy Loam",null,"Very Fine Sand",2,0.36,null,"Trees (13 ft)",null,null,80,"Grass/Weeds, No Canopy (0 ft)",0,"Grass",60,4.2000000000000003E-2,"Low",null,"Slope-Length Exponent (m):",{"$f":"Z32/(1+Z32)","v":0.2507191277394501}]
["Texture Class","Silty Clay","Enter the soil texture class from the dropdown menu. Refer to the NRCS Web Soil Survey, Map Unit Description Tab to determine soil texture class for a project location.",null,null,null,null,"Very Fine Sandy Loam",null,"Very Fine Sand",4,0.28000000000000003,null,null,null,null,"95+","Grass/Weeds, No Canopy (0 ft)",0,"Grass",80,1.2999999999999999E-2,"Low",null,"Slope - Length Factor (L):",{"$f":"(B28/72.6)^Z33","v":0.91073467322243018}]
["Organic Matter Content (%)",0.5,"Enter the soil organic matter content from the dropdown menu. Refer to the NRCS Web Soil Survey, Soil Physical Properties Tab to determine percent organic matter for a project location.",null,null,null,null,"Silt Loam",null,"Loamy Sand",0.5,0.12,null,null,null,null,null,"Grass/Weeds, No Canopy (0 ft)",0,"Grass","95+",3.0000000000000001E-3,"Low",null,"Slope Steepness Factor (S):",{"$f":"IF(B29<9,10.8*SIN(RADIANS(Z29))+0.03,16.8*SIN(RADIANS(Z29))-0.5)","v":0.56932626299403621}]
["User Defined Soil Erodibility Factor (K)",0.2,"Enter the soil erodibility factor (K). Valid range = 0.02 - 0.69.",null,null,null,null,"Clay Loam",null,"Loamy Sand",2,0.1,null,null,null,null,null,"Grass/Weeds, No Canopy (0 ft)",0,"Weeds",0,0.45,"Moderate"]
["Vegetation/Cover",null,null,null,null,null,null,"Silt Clay Loam",null,"Loamy Sand",4,0.08,null,null,null,null,null,"Grass/Weeds, No Canopy (0 ft)",0,"Weeds",20,0.24,"Moderate"]
["Plant Canopy Type","Grass/Weeds, No Canopy (0 ft)","Select the plant canopy cover that best represents the site conditions. The average canopy height for the vegetation type, measured as the average distance water drops fall to the ground, is listed in parenthesis.",null,null,null,null,"Silty Clay",null,"Loamy Very Fine Sand",0.5,0.44,null,null,null,null,null,"Grass/Weeds, No Canopy (0 ft)",0,"Weeds",40,0.15,"Low"]
["Canopy Cover (%)",75,"The canopy cover is defined as the portion of the total surface area that would be hidden from view by the canopy vegetation from a bird's-eye view.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grass/Weeds, No Canopy (0 ft)",0,"Weeds",60,9.0999999999999998E-2,"Low"]
["Ground Cover Type","Grass","Select the predominant ground cover type. Weeds refers to broad-leaf herbaceous plants.",null,null,null,null,null,null,"Loamy Very Fine Sand",2,0.38,null,null,null,null,null,"Grass/Weeds, No Canopy (0 ft)",0,"Weeds",80,4.2999999999999997E-2,"Low"]
["Ground Cover (%)","95+","Specify the percent of the ground surface that is covered by vegetation or organic material with a depth greater than 2 inches.",null,null,null,null,null,null,"Loamy Very Fine Sand",4,0.3,null,null,null,null,null,"Grass/Weeds, No Canopy (0 ft)",0,"Weeds","95+",1.0999999999999999E-2,"Low"]
["Practice Management",null,null,null,null,null,null,null,null,"Sandy Loam",0.5,0.27,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Grass",0,0.36,"Moderate"]
["Practice Support Factor (P)",0.5,"Agricultural management practices (contouring, etc.) or pretreatment BMPs may warrant the inclusion of a practice management factor. The default value of 1 is recommended under most conditions, indicating no management practices present. Refer to Renard et al. (1997), Chapter 6 for guidance. Valid range = 0.05 - 1.0.",null,null,null,null,null,null,"Sandy Loam",2,0.24,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Grass",20,0.17,"Low"]
[null,null,null,null,null,null,null,null,null,"Sandy Loam",4,0.19,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Grass",40,0.09,"Low"]
["RUSLE Calculation:",null,null,null,null,null,null,null,null,"Very Fine Sandy Loam",0.5,0.47,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Grass",60,3.7999999999999999E-2,"Low"]
["RUSLE Factor","Value",null,null,null,null,null,null,null,"Very Fine Sandy Loam",2,0.41,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Grass",80,1.2999999999999999E-2,"Low"]
["Rainfall-Runoff Erosivity (R)",{"$f":"B31","v":10},null,null,null,null,null,null,null,"Very Fine Sandy Loam",4,0.33,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Grass","95+",3.0000000000000001E-3,"Low"]
["Soil Erodibility (K)",{"$f":"IF(B33=\"Yes\",L26,L27)","v":0.25},null,null,null,null,null,null,null,"Silt Loam",0.5,0.48,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Weeds",0,0.36,"Moderate"]
["Length-Slope (LS)",{"$f":"Z27","v":0.51850516808482094},null,null,null,null,null,null,null,"Silt Loam",2,0.42,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Weeds",20,0.2,"Low"]
["Cover Management (C)",{"$f":"V26","v":3.0000000000000001E-3},null,null,null,null,null,null,null,"Silt Loam",4,0.33,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Weeds",40,0.13,"Low"]
["Practice Support (P)",{"$f":"B43","v":0.5},null,null,null,null,null,null,null,"Clay Loam",0.5,0.28000000000000003,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Weeds",60,8.3000000000000004E-2,"Low"]
["Unit Area Soil Loss (tons/ac/yr)",{"$f":"B47*B48*B49*B50*B51","v":1.9443943803180786E-3},null,null,null,null,null,null,null,"Clay Loam",2,0.25,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Weeds",80,4.1000000000000002E-2,"Low"]
["Annual Sediment Load from Off-site Areas (lb/yr)",{"$f":"ROUND(B52*B27*2000,-2)","v":0},null,null,null,null,null,null,null,"Clay Loam",4,0.21,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",25,"Weeds","95+",1.0999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,"Silt Clay Loam",0.5,0.37,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Grass",0,0.26,"Moderate"]
[null,null,null,null,null,null,null,null,null,"Silt Clay Loam",2,0.32,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Grass",20,0.13,"Low"]
[null,null,null,null,null,null,null,null,null,"Silt Clay Loam",4,0.26,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Grass",40,7.0000000000000007E-2,"Low"]
[null,null,null,null,null,null,null,null,null,"Silty Clay",0.5,0.25,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Grass",60,3.5000000000000003E-2,"Low"]
[null,null,null,null,null,null,null,null,null,"Silty Clay",2,0.23,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Grass",80,1.2E-2,"Low"]
[null,null,null,null,null,null,null,null,null,"Silty Clay",4,0.19,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Grass","95+",3.0000000000000001E-3,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Weeds",0,0.26,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Weeds",20,0.16,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Weeds",40,0.11,{"$f":"IF(V62>0.2,\"Moderate\",\"Low\")","v":"Low"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Weeds",60,7.5999999999999998E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Weeds",80,3.9E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",50,"Weeds","95+",1.0999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Grass",0,0.17,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Grass",20,0.1,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Grass",40,0.06,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Grass",60,3.2000000000000001E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Grass",80,1.0999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Grass","95+",3.0000000000000001E-3,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Weeds",0,0.17,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Weeds",20,0.12,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Weeds",40,0.09,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Weeds",60,6.8000000000000005E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Weeds",80,3.7999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tall Weeds/Short Brush (1.6 ft)",75,"Weeds","95+",1.0999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Grass",0,0.4,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Grass",20,0.18,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Grass",40,0.09,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Grass",60,0.04,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Grass",80,1.2999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Grass","95+",3.0000000000000001E-3,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Weeds",0,0.4,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Weeds",20,0.22,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Weeds",40,0.14000000000000001,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Weeds",60,8.6999999999999994E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Weeds",80,4.2000000000000003E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",25,"Weeds","95+",1.0999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Grass",0,0.34,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Grass",20,0.16,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Grass",40,0.08,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Grass",60,3.7999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Grass",80,1.2E-2,{"$f":"IF(V94>0.2,\"Moderate\",\"Low\")","v":"Low"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Grass","95+",3.0000000000000001E-3,{"$f":"IF(V95>0.2,\"Moderate\",\"Low\")","v":"Low"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Weeds",0,0.34,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Weeds",20,0.19,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Weeds",40,0.13,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Weeds",60,8.2000000000000003E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Weeds",80,4.1000000000000002E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",50,"Weeds","95+",1.0999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Grass",0,0.28000000000000003,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Grass",20,0.14000000000000001,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Grass",40,0.08,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Grass",60,3.5999999999999997E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Grass",80,1.2E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Grass","95+",3.0000000000000001E-3,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Weeds",0,0.28000000000000003,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Weeds",20,0.17,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Weeds",40,0.12,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Weeds",60,7.8E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Weeds",80,0.04,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brush or Bushes (6.5 ft)",75,"Weeds","95+",1.0999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Grass",0,0.42,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Grass",20,0.19,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Grass",40,0.1,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Grass",60,4.1000000000000002E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Grass",80,1.2999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Grass","95+",3.0000000000000001E-3,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Weeds",0,0.42,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Weeds",20,0.23,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Weeds",40,0.14000000000000001,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Weeds",60,8.8999999999999996E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Weeds",80,4.2000000000000003E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",25,"Weeds","95+",1.0999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Grass",0,0.39,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Grass",20,0.18,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Grass",40,0.09,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Grass",60,0.04,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Grass",80,1.2999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Grass","95+",3.0000000000000001E-3,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Weeds",0,0.39,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Weeds",20,0.21,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Weeds",40,0.14000000000000001,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Weeds",60,8.6999999999999994E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Weeds",80,4.2000000000000003E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",50,"Weeds","95+",1.0999999999999999E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Grass",0,0.36,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Grass",20,0.17,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Grass",40,0.09,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Grass",60,3.9E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Grass",80,1.2E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Grass","95+",3.0000000000000001E-3,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Weeds",0,0.36,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Weeds",20,0.2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Weeds",40,0.13,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Weeds",60,8.4000000000000005E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Weeds",80,4.1000000000000002E-2,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trees (13 ft)",75,"Weeds","95+",1.0999999999999999E-2,"Low"]

{"sheet":"BMP Design","index":3,"n_rows":32,"n_cols":36,"rows_kept":32,"cut":false,"hidden":false,"merged":[[20,0,20,2],[0,3,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2],[7,0,7,2]]}
[{"$f":"'Project Location'!A1","v":"NCHRP 25-51 Roadside BMP Clogging Risk Assessment Tool"},null,null,"Key"]
["Project Title",{"$f":"'Project Location'!C2","v":"Example Run"},null,"User Steps","Default data; editing allowed with rationale"]
["Project Location",{"$f":"'Project Location'!C3","v":"Horton, KS"},null,"User Entered Data","Guidance"]
["Company",{"$f":"'Project Location'!C4","v":"ABC Engineering"},null,"Reference Data; do not edit cells","Reference Links"]
[]
["BMP Design Inputs"]
[]
["Step 1: Provide data describing the media/soil parameters of the practice",null,null,null,null,null,"Look Up Tables and Lists",null,null,null,{"$f":"IF(B26=\"Off-Line\",0.8,IF(B26=\"On-Line\",1,\"Select Practice Type\"))","v":0.8},null,{"$f":"IF(M9=\"Sediment Forebay Only\",0.25,IF(M9=\"TAPE Pretreatment GULD\",0.5,IF(M9=\"TAPE Basic Treatment GULD\",0.8,\"Enter Removal Efficiency\")))","v":0.5}]
["Parameter","Value","Guidance",null,null,null,{"$f":"B11","v":"Sand (HSG A)"},{"$f":"VLOOKUP(G9,G11:H21,2,FALSE)","v":4.49},{"$f":"B10","v":"Infiltration"},{"$f":"B14","v":"Yes"},{"$f":"B26","v":"Off-Line"},{"$f":"B28","v":"Yes"},{"$f":"B29","v":"TAPE Pretreatment GULD"},{"$f":"B31","v":"Surface"},{"$f":"B32","v":"Vegetated"},null,null,"Infiltration Rates of Selected Practice",null,null,null,null,null,"Load to Clog Calculation",null,null,null,null,null,null,null,null,null,null,"Rate of Reduction (in/hr/lb/ft2)"]
["Practice Type","Infiltration","Infiltration practices refer to retention facilities designed to infiltrate water into the existing underlying soils (i.e. infiltration basin and bioretention without an underdrain).\nFiltration practices refer to detention facilities with flow through a media layer which leaves the site through controlled drainage (i.e. sand filter and bioretention with an underdrain).",null,null,null,"Underlying Soil","Infiltration Rate (in/hr)","Practice Type?","Media Layer Present?","Flow Configuration?","Pretreatment Present?","Type of Pretreatment?","Location?","Vegetation?",null,null,"Practice Type:","Infiltration","Filtration","Selected","Location","Vegetated","Bin","Bin Initial Infiltration Rate (in/hr)","Bin Final Infiltration Rate (in/hr)","Rate of Reduction (in/hr/lb/ft2)","Scenario Initial Infiltration Rate (in/hr)","Scenario Final Infiltration Rate (in/hr)","Load to Clog (lb/ft2)","Graph Initial Infiltration Rate (in/hr)","Graph Final Infiltration Rate (in/hr)","Applied Load (lb/ft2)",null,"25th Percentile (Not Used)","Median (Applied to All Practices)"]
["Underlying Soil Type","Sand (HSG A)","Hydrologic soil group (HSG) is provided in parenthesis for the soil type. Refer to the USDA Texture Triangle for soil type gradations. ",null,null,null,"Sand (HSG A)",4.49,"Infiltration","Yes","Off-Line","Yes","Sediment Forebay Only","Surface","Vegetated",null,null,"Initial Infiltration Rate (in/hr):",{"$f":"IF(B14=\"Yes\",B15,IF(B13=\"\",B12,B13))","v":10},{"$f":"B18","v":30},{"$f":"IF(B10=\"Infiltration\",S11,T11)","v":10},{"$f":"N9","v":"Surface"},{"$f":"O9","v":"Vegetated"},1,150,25,180.26883187102348,{"$f":"IF(U11>Y11,Y11,U11)","v":10},{"$f":"IF(U12<Z11,Z11,U12)","v":25},{"$f":"IF((AB11-AC11)/AA11>0,(AB11-AC11)/AA11,0)","v":0},{"$f":"IF(U11>Y11,Y11,U11)","v":10},{"$f":"IF(U11>Z11,Z11,U11)","v":10},{"$f":"IF((AE11-AF11)/AA11>0,(AE11-AF11)/AA11,0)","v":0},null,314.58678502982525,180.26883187102348]
["Default Initial Soil Infiltration Rate (in/hr)",{"$f":"H9","v":4.49},"Default value do not edit. The infiltration rate is determined based on the underlying soil type input. Values extracted from the USDA SPAW Soil Water Characteristics Model.",null,null,null,"Loamy Sand (HSG A)",3.59,"Filtration","No","On-Line","No","TAPE Pretreatment GULD","Below Grade","Unvegetated",null,null,"Final Infiltration Rate (in/hr):",{"$f":"B16","v":0.5},{"$f":"B19","v":0.5},{"$f":"IF(B10=\"Infiltration\",S12,T12)","v":0.5},null,null,2,25,2.5,9.718122209821427,{"$f":"IF(U11>Y12,Y12,U11)","v":10},{"$f":"IF(U12<Z12,Z12,U12)","v":2.5},{"$f":"IF((AB12-AC12)/AA12>0,(AB12-AC12)/AA12,0)","v":0.77175403211335147},{"$f":"IF(U11>Y12,Y12,U11)","v":10},{"$f":"IF(U11>Z12,Z12,U11)","v":2.5},{"$f":"IF((AE12-AF12)/AA12>0,(AE12-AF12)/AA12,0)+AG11","v":0.77175403211335147},null,10.131033166310674,9.718122209821427]
["User-Provided Soil Infiltration Rate (in/hr)",1.33,"Enter a site-specific underlying soil infiltration rate if available. If no value is entered here, the default soil infiltration rate will be used.",null,null,null,"Sandy Loam (HSG A)",1.98,null,null,null,null,"TAPE Basic Treatment GULD",null,null,null,null,null,null,null,null,null,null,3,2.5,0.75,2.2660734331405483,{"$f":"IF(U11>Y13,Y13,U11)","v":2.5},{"$f":"IF(U12<Z13,Z13,U12)","v":0.75},{"$f":"IF((AB13-AC13)/AA13>0,(AB13-AC13)/AA13,0)","v":0.77226094018263003},{"$f":"IF(U11>Y13,Y13,U11)","v":2.5},{"$f":"IF(U11>Z13,Z13,U11)","v":0.75},{"$f":"IF((AE13-AF13)/AA13>0,(AE13-AF13)/AA13,0)+AG12","v":1.5440149722959815},null,3.6751062729779411,2.2660734331405483]
["Will a sacrificial media or sand layer be used over the underlying soil?","Yes","This refers to a more granular media that is placed above the in situ soil to reduce clogging risks. Recommended depth is 6 inches or greater. This should have a higher infiltration rate than the underlying soil. ",null,null,null,"Silt (HSG B)",0.75,null,null,null,null,"User Specified",null,null,null,null,null,null,null,null,null,null,4,0.75,0.25,0.56610332652082573,{"$f":"IF(U11>Y14,Y14,U11)","v":0.75},{"$f":"IF(U12<Z14,Z14,U12)","v":0.5},{"$f":"IF((AB14-AC14)/AA14>0,(AB14-AC14)/AA14,0)","v":0.44161549365282354},{"$f":"IF(U11>Y14,Y14,U11)","v":0.75},{"$f":"IF(U11>Z14,Z14,U11)","v":0.25},{"$f":"IF((AE14-AF14)/AA14>0,(AE14-AF14)/AA14,0)+AG13","v":2.4272459596016285},null,0.80274060413907433,0.56610332652082573]
["Initial Media Layer Infiltration Rate (in/hr)",10,"Enter the initial infiltration rate of the media layer.Valid range = 1 to 150 in/hr.",null,null,null,"Loam (HSG B)",0.73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AD11:AD14)","v":1.9856304659488051}]
["Minimum Allowable Infiltration Rate To Trigger Maintenance (in/hr)",0.5,"Enter the infiltration rate of the limiting layer (media or soil) that will trigger rehabilitative maintenance. This value and the design infiltration rate will be used to determine the load to clog. The minimum allowable infiltration rate must be less than the initial/design infiltration rate. The minimum infiltration rate evaluated by the tool is 0.25 in/hr. Recommended value range: 0.25 to 2.0 in/hr.  ",null,null,null,"Sandy Clay Loam (HSG C)",0.31]
[null,null,null,null,null,null,"Silty Clay Loam (HSG D)",0.23]
["Initial Filter Media Infiltration Rate (in/hr)",30,"Enter the design initial infiltration rate of the filter media. If multiple layers are used, enter the layer with the limiting infiltration rate. Valid range = 1 to 150 in/hr. ",null,null,null,"Clay Loam (HSG D)",0.18]
["Minimum Allowable Filter Media Infiltration Rate to Trigger Maintenance (in/hr)",0.5,"Enter the infiltration rate of the filter media that will trigger rehabilitative maintenance. This value and the design infiltration rate will be used to determine the load to clog. The minimum allowable infiltration rate must be less than the initial/design infiltration rate. The minimum infiltration rate evaluated by the tool is 0.25 in/hr. Recommended value range: 0.25 to 2.0 in/hr.",null,null,null,"Silty Clay (HSG D)",0.15]
[null,null,null,null,null,null,"Clay (HSG D)",0.03]
["Step 2: Provide data describing the design and configuration of the BMP",null,null,null,null,null,"Sandy Clay (HSG D)",0.03]
["Parameter","Value","Guidance"]
["85th Percentile Event Runoff Volume (ft3) ",{"$f":"O26","v":30346.800000000003},"Reference value do not edit. Volume is based on the runoff coefficient, precipitation depth, and roadway tributary area. Off-site drainage is not included. Provided for sizing reference only, does not affect clogging calculation."]
["Practice Storage Volume (ft3)",32500,"Specify the ponded storage volume of the practice to the overflow depth. This parameter is used to calculate the BMP drawdown time. If no storage volume is provided enter zero.",null,null,null,"Unit Area Loading Rate Calculation"]
["BMP Infiltrating Footprint Area (ft2)",11000,"Specify the infiltrating area of the BMP, equivalent to the surface area of the media or underlying soil for which runoff will flow through. Measure the BMP footprint area halfway up the side slopes to account for system drawdown. The practice footprint will be used to determine the area over which sediment accumulates and infiltration occurs. ",null,null,null,"Component","Runoff Coefficient","Tributary Area (ac)","BMP Footprint (ft2)","Footprint Area (% Watershed Area)","Average Annual Precipitation (in)","Annual Roadway Runoff Volume (cf/yr)","85th Percentile Precipitation (in)","85th Percentile Roadway Runoff Volume (cf)","Roadway TSS Concentration (mg/L)","Annual Sediment Load From Component Area (lb/yr)","BMP Captured Annual Sediment Load (lb/yr)","BMP Captured Unit Area Sediment Load (lb/ft2/yr)","Load to Clog (lb/ft2)","Time to Rehabilitative Maintenance (yrs)"]
["Select Flow Configuration","Off-Line","On line flow through systems route the entirety of inflow through the treatment area. Off-line BMPs, have designed bypass of peak flows. This selection sets the default average annual BMP sediment capture rate.",null,null,null,"Roadway",{"$f":"IF('Tributary Area'!B19=\"\",'Tributary Area'!B18,'Tributary Area'!B19)","v":0.8},{"$f":"'Tributary Area'!B16","v":9.5},null,null,{"$f":"IF('Project Location'!P21=\"\",'Project Location'!P16,'Project Location'!P21)","v":35.444405866639698},{"$f":"H26*L26*I26*43560/12","v":977840.26904885611},{"$f":"IF('Project Location'!P22=\"\",'Project Location'!P17,'Project Location'!P22)","v":1.1000000000000001},{"$f":"H26*N26*I26*43560/12","v":30346.800000000003},{"$f":"IF('Tributary Area'!B12=\"\",'Tributary Area'!B11,'Tributary Area'!B12)","v":50},{"$f":"M26*28.3168*P26*10^-3*0.00220462","v":3052.2200363596608},{"$f":"IF(B28=\"No\",B27*Q26,(1-B30)*B27*Q26)","v":1220.8880145438643},{"$f":"R26/B25","v":0.11098981950398766},{"$f":"AD15","v":1.9856304659488051},{"$f":"T26/S26","v":17.890203577432299}]
["Average Annual BMP Sediment Capture Rate (%)",0.8,"Enter the percentage of the annual sediment load that is captured by the BMP. Default values are 100% for on-line flow through practices and 80% for off-line storage BMPs. Refer to NCHRP 792 Long Term Performance and Life Cycle Cost of BMPs evaluation tools for detailed calculation of sediment capture rate based on BMP volume capture and treatment efficiency (Taylor et al, 2014).",null,null,null,"Off-Site Drainage",null,{"$f":"IF('Tributary Area'!B20=\"No\",0,'Tributary Area'!B27)","v":2.5},null,null,null,null,null,null,null,{"$f":"IF('Tributary Area'!B20=\"No\",0,'Tributary Area'!B53)","v":0},{"$f":"IF(B28=\"No\",B27*Q27,(1-B30)*B27*Q27)","v":0},{"$f":"R27/B25","v":0}]
["Is pretreatment present?","Yes","Specify if pretreatment is provided prior to inflow into the BMP.",null,null,null,"Total",null,{"$f":"I26+I27","v":12},{"$f":"B25","v":11000},{"$f":"J28/(43560*I28)","v":2.1043771043771045E-2},null,null,null,null,null,{"$f":"Q26+Q27","v":3052.2200363596608},{"$f":"R26+R27","v":1220.8880145438643},{"$f":"S26+S27","v":0.11098981950398766},{"$f":"AD15","v":1.9856304659488051},{"$f":"T28/S28","v":17.890203577432299}]
["Type of Pretreatment","TAPE Pretreatment GULD","Select the type of pretreatment provided to generate the default removal efficiency for pretreatment. Estimated values are based on the Washington Department of Ecology TAPE guidelines. Refer to the TAPE Emerging Technologies List for practices that have been rated for pretreatment and basic general use level designations (GULD). If user specified is selected, input the pretreatment removal efficiency in the cell below."]
["Sediment Removal Efficiency of Pretreatment (%)",0.5,"Default values: Sediment Forebay Only = 25%, TAPE Pretreatment GULD = 50%, and TAPE Basic Treatment GULD = 80%. If only a portion of inflow is treated by pretreatment scale the removal efficiency by the portion of annual inflow volume that is treated by the pretreatment device. A user-defined value may be provided to override default values.",null,null,null,"Drawdown Time Calculation"]
["Is the BMP exposed to the surface or below grade?","Surface","Specify if the BMP is located at the surface or below grade. This selection will not impact the tool calculation due to data limitations, however, will be used to identify possible risk. ",null,null,null,"Storage Volume (ft3)","Surface Area (ft2)","Ponding Depth (ft)","Infiltration Practice Limiting Layer Initial Infiltration Rate (in/hr)","Infiltration Practice Limiting Layer Final Infiltration Rate (in/hr)","Initial Drawdown Infiltration Rate","Final Drawdown Infiltration Rate","Initial Drawdown Time (hr)","Final Drawdown Time (hr)"]
["Is the BMP vegetated?","Vegetated","Vegetated BMPs have the potential to reduce clogging risk due to the formation of macropores and bioturbation. Surface vegetated BMPs may be able to assimilate the influent sediment load over time eliminating the need for rehabilitative maintenance (Hatt et al., 2008; Le Coustumer et al., 2011; Limouzin et al., 2011). This selection will not impact the tool calculation due to data limitations, however, will be used to identify potential risk.",null,null,null,{"$f":"B24","v":32500},{"$f":"B25","v":11000},{"$f":"G32/H32","v":2.9545454545454546},{"$f":"IF(B14=\"Yes\",MIN((IF(B13=\"\",B12,B13),B15)),IF(B13=\"\",B12,B13))","v":1.33},{"$f":"MIN(B12,B16)","v":0.5},{"$f":"IF(AND(B10=\"Infiltration\",B14=\"Yes\"),J32,U11)","v":1.33},{"$f":"IF(B10=\"Infiltration\",K32,U11)","v":0.5},{"$f":"I32/(L32/12)","v":26.657552973342447},{"$f":"I32/(M32/12)","v":70.909090909090921}]

{"sheet":"Results Summary Report","index":4,"n_rows":77,"n_cols":12,"rows_kept":77,"cut":false,"hidden":false,"merged":[[69,0,70,0],[22,2,22,4],[23,2,23,4],[24,2,24,4],[50,3,52,4],[69,1,69,3],[61,0,61,4],[62,3,63,4],[64,0,64,4],[65,2,66,2],[62,2,63,2],[65,3,65,4],[66,3,66,4],[0,5,0,6],[48,3,48,4],[54,3,57,4],[59,3,60,4],[53,0,53,4],[58,0,58,4],[49,1,49,2],[50,2,52,2],[21,2,21,4],[54,2,57,2],[59,2,60,2]]}
[{"$f":"'Project Location'!A1","v":"NCHRP 25-51 Roadside BMP Clogging Risk Assessment Tool"},null,null,null,null,"Key"]
["Project Title",{"$f":"'Project Location'!C2","v":"Example Run"},null,null,null,"User Steps","Default data; editing allowed with rationale"]
["Project Location",{"$f":"'Project Location'!C3","v":"Horton, KS"},null,null,null,"User Entered Data","Guidance"]
["Company",{"$f":"'Project Location'!C4","v":"ABC Engineering"},null,null,null,"Reference Data; do not edit cells","Reference Links"]
[]
["Results Summary Report"]
[]
["Summary of Modeled Scenario"]
[{"$f":"\"The modeled scenario consists of a roadway drainage area of \"&'BMP Design'!I26&\" acres at \"&'Tributary Area'!B17*100&\"% impervious, with an additional \"&'BMP Design'!I27&\" acres of pervious off-site drainage (\"&'BMP Design'!I28&\"-acre total drainage area).\"","v":"The modeled scenario consists of a roadway drainage area of 9.5 acres at 100% impervious, with an additional 2.5 acres of pervious off-site drainage (12-acre total drainage area)."}]
[{"$f":"IF('Project Location'!P21='Project Location'!P16,\"Analysis is based on an average annual precipitation depth of \"&ROUND('Project Location'!P16,1)&\" in for the \"&'Project Location'!P11&\" rain gauge in \"&'Project Location'!O11&\".\",\"Analysis is based on a user-specified average annual precipitation depth of \"&ROUND('Project Location'!P21,1)&\" in.\")","v":"Analysis is based on an average annual precipitation depth of 35.4 in for the [3] NORTHEAST - HORTON rain gauge in Kansas."}]
[{"$f":"\"Clogging is assessed for a \"&'BMP Design'!J28&\" sq. ft. \"&LOWER('BMP Design'!O9)&\" \"&LOWER('BMP Design'!N9)&\" \"&LOWER('BMP Design'!I9)&\" practice with an initial infiltration rate of \"&'BMP Design'!U11&\" in/hr and a minimum allowable infiltration rate of \"&'BMP Design'!U12&\" in/hr.\"","v":"Clogging is assessed for a 11000 sq. ft. vegetated surface infiltration practice with an initial infiltration rate of 10 in/hr and a minimum allowable infiltration rate of 0.5 in/hr."}]
[{"$f":"IF('BMP Design'!L9=\"Yes\",\"Pretreatment is included in the design with a sediment removal efficiency of \"&'BMP Design'!M8*100&\"%.\", \"Pretreatment is not included in the design.\")","v":"Pretreatment is included in the design with a sediment removal efficiency of 50%."}]
[]
["Design Warnings",null,null,null,null,null,null,null,"Display","Order",null,"Warning"]
[{"$f":"IF(J15=1,L15,IF(J16=1,L16,IF(J17=1,L17,IF(J18=1,L18,IF(J19=1,L19,\"No fatal design warnings have been identified, view results below.\")))))","v":"The surface storage drawdown time at the initial infiltration rate is greater than 24 hours (current design = 26.7 hours), consider revising practice configuration."},null,null,null,null,null,null,null,{"$f":"IF(AND('BMP Design'!B10=\"Infiltration\",'BMP Design'!J32<0.75),\"Yes\",\"No\")","v":"No"},{"$f":"IF(I15=\"No\",0,1)","v":0},null,{"$f":"\"An infiltration practice has been specified with an underlying soil infiltration rate less than 0.75 in/hr (current design = \"&ROUND('BMP Design'!J32,1)&\" in/hr), consider changing practice type to filtration.\"","v":"An infiltration practice has been specified with an underlying soil infiltration rate less than 0.75 in/hr (current design = 1.3 in/hr), consider changing practice type to filtration."}]
[{"$f":"IF(J16=2,L16,IF(J17=2,L17,IF(J18=2,L18,IF(J19=2,L19,\"\"))))","v":""},null,null,null,null,null,null,null,{"$f":"IF('BMP Design'!N32>24,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(I16=\"No\",0,J15+1)","v":1},null,{"$f":"\"The surface storage drawdown time at the initial infiltration rate is greater than 24 hours (current design = \"&ROUND('BMP Design'!N32,1)&\" hours), consider revising practice configuration.\"","v":"The surface storage drawdown time at the initial infiltration rate is greater than 24 hours (current design = 26.7 hours), consider revising practice configuration."}]
[{"$f":"IF(J17=3,L17,IF(J18=3,L18,IF(J19=3,L19,\"\")))","v":""},null,null,null,null,null,null,null,{"$f":"IF('BMP Design'!O32>72,\"Yes\",\"No\")","v":"No"},{"$f":"IF(I17=\"No\",0,MAX(J15,J16)+1)","v":0},null,{"$f":"\"The surface storage drawdown time at the minimum allowable infiltration rate is greater than 72 hours (current design = \"&ROUND('BMP Design'!O32,1)&\" hours), consider revising practice configuration.\"","v":"The surface storage drawdown time at the minimum allowable infiltration rate is greater than 72 hours (current design = 70.9 hours), consider revising practice configuration."}]
[{"$f":"IF(J18=4,L18,IF(J19=4,L19,\"\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF(B25<10,\"Yes\",\"No\")","v":"No"},{"$f":"IF(I18=\"No\",0,MAX(J15,J16,J17)+1)","v":0},null,{"$f":"\"The time to rehabiltative maintenance is less than 10 years (current design = \"&ROUND(B25,0)&\" years) and due to uncertainty may clog much sooner. Consult the risk factor assessment below for identification of critical parameters.\"","v":"The time to rehabiltative maintenance is less than 10 years (current design = 18 years) and due to uncertainty may clog much sooner. Consult the risk factor assessment below for identification of critical parameters."}]
[]
[]
["Infiltration Rate Reduction Summary"]
["Parameter","Value","Guidance"]
["Load to Rehabilitative Maintenance (lb/ft2)",{"$f":"'BMP Design'!T28","v":1.9856304659488051},"The applied load to reduce the infiltration rate from the initial to minimum allowable value. The tool uses estimates for the infiltration rate of reduction per applied load for different infiltration rate zones based on laboratory experiments (Clark and Pitt, 2010; Le Coustumer et al., 2012; Limouzin et al., 2011). Refer to the User Guide for method details. "]
["BMP Captured Unit Area Sediment Load (lb/ft2/yr)",{"$f":"'BMP Design'!S28","v":0.11098981950398766},"The annual BMP sediment capture rate is normalized by BMP footprint area and calculated based on the runoff volume, roadway runoff concentration, and off-site sediment load determined by RUSLE. The sediment load that bypasses the BMP or is removed by pretreatment is not included in the BMP capture rate. The load applied over time is graphed below."]
["Time to Rehabilitative Maintenance (yrs)",{"$f":"ROUND('BMP Design'!U28,1)","v":17.899999999999999},"The time to rehabilitative maintenance is the duration for the initial infiltration rate to be reduced to the minimum allowable value due to sediment loading. If this value is less than acceptable for maintenance considerations consider the risk factors identified below or adjust the media infiltration rate. This value will be flagged for surface practices with a time to rehabilitative maintenance less than 10 years. The predicted infiltration rate reduction over time is graphed below."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Risk Factor Assessment"]
["Parameter","Value","Risk","Guidance"]
["Drawdown Rate"," (see risk factor range table below for levels)",null,null,null,null,null,null,"Parameter","Risk"]
["Practice Footprint Area (% Watershed Area)",{"$f":"'BMP Design'!K28","v":2.1043771043771045E-2},{"$f":"IF(OR(J51=\"High\",J52=\"High\"),\"High\",IF(OR(J51=\"Moderate\",J52=\"Moderate\"),\"Moderate\",\"Low\"))","v":"High"},"The drawdown rate risk factor is identified based on the drawdown time for the initial and minimum allowable infiltration rate inputs. The higher initial or final drawdown time risk is identified in the table. Extended drawdown times increase the risk for biofouling, reduce capture efficiency, and may lead to vector or human safety risks. Outlet control is encouraged for filtration practices using highly permeable media.",null,null,null,null,"Initial Infiltration Rate",{"$f":"IF(B52<12,\"Low\",IF(B52<24,\"Moderate\",\"High\"))","v":"High"}]
["Drawdown Time at Initial Infiltration Rate (hr)",{"$f":"'BMP Design'!N32","v":26.657552973342447},null,null,null,null,null,null,"Final Infiltration Rate",{"$f":"IF(B53<24,\"Low\",IF(B53<72,\"Moderate\",\"High\"))","v":"Moderate"}]
["Drawdown Time at Minimum Allowable Infiltration Rate (hr)",{"$f":"'BMP Design'!O32","v":70.909090909090921}]
["Off-Site Drainage"]
["Annual Sediment Load from Roadway Area (lb/yr)",{"$f":"'BMP Design'!Q26","v":3052.2200363596608},{"$f":"IF(B57<5/100,\"Low\",IF(B57<25/100,\"Moderate\",\"High\"))","v":"Low"},"Off-site drainage risk is identified based on the percentage of annual sediment load that is due to off-site drainage. Sediment loads are calculated based on tributary area and RUSLE inputs. Consider rerouting off-site drainage areas or providing additional pretreatment for scenarios with high off-site sediment loading."]
["Annual Sediment Load from Off-Site Area (lb/yr)",{"$f":"'BMP Design'!Q27","v":0}]
["Off-Site Sediment Contribution (% of Total Load)",{"$f":"B56/(B55+B56)","v":0}]
["Reduction in Time to Maintenance due to Off-Site Drainage (yr)",{"$f":"'BMP Design'!U26-'BMP Design'!U28","v":0}]
["Media Conditions - Infiltration Practice"]
["Underlying Soil Type",{"$f":"'BMP Design'!G9","v":"Sand (HSG A)"},{"$f":"IF(B61>2,\"Low\",IF(B61<0.75,\"High\",\"Moderate\"))","v":"Moderate"},"This risk factor is identified based on the infiltration rate of the underlying soil. Low infiltration rates of the underlying soil will lead to a lack of system drawdown and if a media layer is used poses a risk to clogging at the interface of the media layer and underlying soil."]
["Underlying Soil Infiltration Rate (in/hr)",{"$f":"IF('BMP Design'!B13=\"\",'BMP Design'!B12,'BMP Design'!B13)","v":1.33}]
["Pretreatment"]
["Type of Pretreatment",{"$f":"IF('BMP Design'!B28=\"No\", \"Not Used\",'BMP Design'!B29)","v":"TAPE Pretreatment GULD"},{"$f":"IF(B64>=50,\"Low\",IF(B64<=20,\"High\",\"Moderate\"))","v":"Low"},"This risk factor is identified based on the removal efficiency of pretreatment. Providing additional pretreatment will reduce the BMP sediment load and reduce clogging risk."]
["Pretreatment Removal Efficiency (%)",{"$f":"'BMP Design'!B30*100","v":50}]
["Vegetation and Location"]
["Is the practice installed at the surface or below grade?",{"$f":"'BMP Design'!B31","v":"Surface"},{"$f":"IF(AND(B66=\"Surface\",B67=\"Vegetated\"),\"Low\",IF(AND(B66=\"Surface\",B67=\"Unvegetated\"),\"Moderate\",\"High\"))","v":"Low"},"Below grade BMPs are increasingly susceptible to clogging due to confined area of infiltration and restricted maintenance access. Added caution with regards to clogging is recommended when implementing a below grade BMP."]
["Is the practice vegetated?",{"$f":"'BMP Design'!B32","v":"Vegetated"},null,"The presence of vegetation can reduce clogging risk due to the formation of macropores and bioturbation. When feasible surface vegetated BMPs are recommended. "]
[]
["Reference Risk Factor Range Table"]
["Parameter","Risk Range"]
[null,"Low","Moderate","High"]
["Drawdown Time at Initial Infiltration Rate (hr)","< 12","12 to 24","> 24"]
["Drawdown Time at Minimum Allowable Infiltration Rate (hr)","< 24","24 to 72","> 72"]
["Off-Site Sediment Contribution (% of Total Load)","< 5%","5 to 25%","> 25%"]
["Infiltration Practice, Underlying Soil Infiltration Rate (in/hr)","> 2","0.75 to 2.0","< 0.75"]
["Pretreatment Removal Efficiency (%)","> 50","20 to 50","< 20"]
["Vegetation and Location","Surface Vegetated","Surface Unvegetated","Below Grade Unvegetated"]

{"sheet":"Graph Parameters","index":5,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["Time (yrs)","Applied Load (lbs/ft2)","Time to Maintenance (yrs)","Load to Clog (lbs/ft2)","Time (yrs)","System Infiltration Rate (in/hr)","Time to Maintenance (yrs)","Maintenance Infiltration Rate (in/hr)"]
[0,0,{"$f":"'BMP Design'!U28","v":17.890203577432299},{"$f":"'BMP Design'!T28","v":1.9856304659488051},0,{"$f":"'BMP Design'!U11","v":10},{"$f":"'BMP Design'!U28","v":17.890203577432299},{"$f":"'BMP Design'!U12","v":0.5}]
[{"$f":"ROUNDUP(E7,0)","v":22},{"$f":"'BMP Design'!$S$28*A4","v":2.4417760290877286},null,null,{"$f":"'BMP Design'!AG11/'BMP Design'!$S$28","v":0},{"$f":"'BMP Design'!AF11","v":10}]
[null,null,null,null,{"$f":"'BMP Design'!AG12/'BMP Design'!$S$28","v":6.9533767652052427},{"$f":"'BMP Design'!AF12","v":2.5}]
[null,null,null,null,{"$f":"'BMP Design'!AG13/'BMP Design'!$S$28","v":13.911320688655664},{"$f":"'BMP Design'!AF13","v":0.75}]
[null,null,null,null,{"$f":"'BMP Design'!AG14/'BMP Design'!$S$28","v":21.86908646620893},{"$f":"'BMP Design'!AF14","v":0.25}]

{"sheet":"Rain Gage Summary","index":6,"n_rows":348,"n_cols":15,"rows_kept":348,"cut":false,"hidden":true,"merged":[]}
[" Station ID","Climate Division - Rain Gage","State","County","Climate Division","Elevation","85th Percentile","95th Percentile","Average Annual"," Station ID","Climate Division - Rain Gage"]
[15550,"[6] PRAIRIE - MONTGOMERY AP ASOS","AL","MONTGOMERY",6,202,1.25,2.0099999999999998,50.958726554660103,15550,"[6] PRAIRIE - MONTGOMERY AP ASOS"]
[26481,"[6] SOUTH CENTRAL - PHOENIX AP","AZ","MARICOPA",6,1107,0.67,1.02,7.2056578406174303,26481,"[6] SOUTH CENTRAL - PHOENIX AP"]
[47769,"[4] CENTRAL COAST DRNG. - SAN FRANCISCO WSO AP","CA","SAN MATEO",4,8,0.89,1.39,20.1809709584711,47769,"[4] CENTRAL COAST DRNG. - SAN FRANCISCO WSO AP"]
[45114,"[6] SOUTH COAST DRNG. - LOS ANGELES INTL AP","CA","LOS ANGELES",6,97,1.02,1.6,12.3051502429536,45114,"[6] SOUTH COAST DRNG. - LOS ANGELES INTL AP"]
[47740,"[6] SOUTH COAST DRNG. - SAN DIEGO WSO AP","CA","SAN DIEGO",6,15,0.78,1.25,9.7954187791749394,47740,"[6] SOUTH COAST DRNG. - SAN DIEGO WSO AP"]
[85663,"[6] LOWER EAST COAST - MIAMI INTL AP","FL","MIAMI-DADE",6,29,1.28,2.2000000000000002,58.883741625309,85663,"[6] LOWER EAST COAST - MIAMI INTL AP"]
[90451,"[2] NORTH CENTRAL - ATLANTA/MUN., GA.","GA","FULTON",2,1010,1.1399999999999999,1.8,48.999608631629798,90451,"[2] NORTH CENTRAL - ATLANTA/MUN., GA."]
[101022,"[5] SOUTHWESTERN VALLEYS - BOISE AIR TERMINAL","ID","ADA",5,2814,0.42,0.61,11.5045419821974,101022,"[5] SOUTHWESTERN VALLEYS - BOISE AIR TERMINAL"]
[124259,"[5] CENTRAL - INDIANAPOLIS INTL AP","IN","MARION",5,790,0.91,1.47,40.427824877002699,124259,"[5] CENTRAL - INDIANAPOLIS INTL AP"]
[132203,"[5] CENTRAL - DES MOINES AP","IA","POLK",5,957,0.91,1.5,32.261402697125,132203,"[5] CENTRAL - DES MOINES AP"]
[160549,"[6] EAST CENTRAL - BATON ROUGE METRO AP","LA","EAST BATON ROUGE",6,64,1.36,2.2999999999999998,57.724417306923499,160549,"[6] EAST CENTRAL - BATON ROUGE METRO AP"]
[215435,"[6] EAST CENTRAL - MINNEAPOLIS/ST PAUL AP","MN","HENNEPIN",6,872,0.8,1.33,27.729709270311702,215435,"[6] EAST CENTRAL - MINNEAPOLIS/ST PAUL AP"]
[244055,"[4] CENTRAL - HELENA AP ASOS","MT","LEWIS AND CLARK",4,3828,0.45,0.73,11.0347127383643,244055,"[4] CENTRAL - HELENA AP ASOS"]
[305811,"[4] COASTAL - NEW YORK LA GUARDIA AP","NY","QUEENS",4,11,1,1.68,43.142663833732797,305811,"[4] COASTAL - NEW YORK LA GUARDIA AP"]
[300042,"[5] HUDSON VALLEY - ALBANY INTL AP","NY","ALBANY",5,275,0.8,1.27,36.674898136458502,300042,"[5] HUDSON VALLEY - ALBANY INTL AP"]
[317069,"[4] CENTRAL PIEDMONT - RALEIGH  AP","NC","WAKE",4,416,0.99,1.57,42.2305432688404,317069,"[4] CENTRAL PIEDMONT - RALEIGH  AP"]
[320819,"[8] SOUTH CENTRAL - BISMARCK MUNI AP","ND","BURLEIGH",8,1651,0.66,1.1200000000000001,15.8931293881458,320819,"[8] SOUTH CENTRAL - BISMARCK MUNI AP"]
[346661,"[5] CENTRAL - OKLAHOMA CITY WILL ROGERS AP","OK","OKLAHOMA",5,1285,1.17,1.87,33.154702814476998,346661,"[5] CENTRAL - OKLAHOMA CITY WILL ROGERS AP"]
[356751,"[2] WILLAMETTE VALLEY - PORTLAND INTL AP","OR","MULTNOMAH",2,19,0.63,0.98,36.668365003488702,356751,"[2] WILLAMETTE VALLEY - PORTLAND INTL AP"]
[381939,"[6] CENTRAL - COLUMBIA METRO AP","SC","LEXINGTON",6,225,1.19,1.92,45.149107883625597,381939,"[6] CENTRAL - COLUMBIA METRO AP"]
[406402,"[3] MIDDLE - NASHVILLE ASOS","TN","DAVIDSON",3,600,1.05,1.75,47.799301791763199,406402,"[3] MIDDLE - NASHVILLE ASOS"]
[412797,"[5] TRANS PECOS - EL PASO AP","TX","EL PASO",5,3918,0.6,1.04,8.4729255843169504,412797,"[5] TRANS PECOS - EL PASO AP"]
[427598,"[3] NORTH CENTRAL - SALT LAKE CITY INTL AP","UT","SALT LAKE",3,4225,0.51,0.8,15.320145410649401,427598,"[3] NORTH CENTRAL - SALT LAKE CITY INTL AP",null,null,"State","KS"]
[448906,"[4] NORTHERN - WASHINGTON/NAT., VA.","VA","ARLINGTON",4,10,0.94,1.5,39.597033383956898,448906,"[4] NORTHERN - WASHINGTON/NAT., VA.","Climate Division Filter"]
[14064,"[1] NORTHERN VALLEY - HUNTSVILLE INTL AP","AL","MADISON",1,624,1.24,2,54.9199579921302,14064,"[1] NORTHERN VALLEY - HUNTSVILLE INTL AP",{"$f":"VLOOKUP('Project Location'!O11,'Project Location'!Y2:Z51,2,FALSE)","v":"KS"},null,"Row Labels"]
[10831,"[2] APPALACHIAN MOUNTAIN - BIRMINGHAM AP ASOS","AL","JEFFERSON",2,615,1.2,1.93,45.103104268769499,10831,"[2] APPALACHIAN MOUNTAIN - BIRMINGHAM AP ASOS",null,null,"[1] NORTHWEST - GOODLAND RENNER FLD"]
[10063,"[3] UPPER PLAINS - ADDISON","AL","WINSTON",3,818,1.3,2.1,51.219776903393097,10063,"[3] UPPER PLAINS - ADDISON",null,null,"[2] NORTH CENTRAL - CONCORDIA BLOSSER MUNI"]
[14209,"[4] EASTERN VALLEY - JACKSONVILLE","AL","CALHOUN",4,688,1.2,1.92,45.638574430053197,14209,"[4] EASTERN VALLEY - JACKSONVILLE",null,null,"[3] NORTHEAST - HORTON"]
[12124,"[5] PIEDMONT PLATEAU - DADEVILLE 2","AL","TALLAPOOSA",5,733,1.3,2,51.701422516589098,12124,"[5] PIEDMONT PLATEAU - DADEVILLE 2",null,null,"[4] WEST CENTRAL - COLLYER 10 S"]
[10140,"[7] COASTAL PLAIN - ALBERTA","AL","WILCOX",7,175,1.4,2.2000000000000002,55.167222104976702,10140,"[7] COASTAL PLAIN - ALBERTA",null,null,"[5] CENTRAL - KANOPOLIS LAKE"]
[15478,"[8] GULF - MOBILE REGIONAL AP","AL","MOBILE",8,215,1.45,2.42,58.616081582496697,15478,"[8] GULF - MOBILE REGIONAL AP",null,null,"[6] EAST CENTRAL - TOPEKA BILLARD MUNI AP"]
[24645,"[1] NORTHWEST - KINGMAN #2","AZ","MOHAVE",1,3539,0.8,1.2,8.9992980678706296,24645,"[1] NORTHWEST - KINGMAN #2",null,null,"[7] SOUTHWEST - DODGE CITY RGNL AP"]
[29439,"[2] NORTHEAST - WINSLOW AP","AZ","NAVAJO",2,4886,0.48,0.75,7.2817907594776896,29439,"[2] NORTHEAST - WINSLOW AP",null,null,"[8] SOUTH CENTRAL - WICHITA MID-CONTINENT"]
[20487,"[3] NORTH CENTRAL - ASH FORK 3","AZ","YAVAPAI",3,5075,0.69,1.1000000000000001,12.255190810118901,20487,"[3] NORTH CENTRAL - ASH FORK 3",null,null,"[9] SOUTHEAST - CASSODAY 2SW"]
[26323,"[4] EAST CENTRAL - PAYSON","AZ","GILA",4,4850,0.9,1.5,19.304966977310499,26323,"[4] EAST CENTRAL - PAYSON",null,null,"Grand Total"]
[29660,"[5] SOUTHWEST - YUMA WSO AP","AZ","YUMA",5,206,0.57999999999999996,1.1100000000000001,2.9133797970488802,29660,"[5] SOUTHWEST - YUMA WSO AP"]
[28820,"[7] SOUTHEAST - TUCSON INTL AP","AZ","PIMA",7,2549,0.66,1.1000000000000001,11.261923334010399,28820,"[7] SOUTHEAST - TUCSON INTL AP"]
[32356,"[1] NORTHWEST - EUREKA SPRINGS 3 WNW","AR","CARROLL",1,1420,1.2,1.91,43.160099726593501,32356,"[1] NORTHWEST - EUREKA SPRINGS 3 WNW"]
[32794,"[2] NORTH CENTRAL - GILBERT","AR","SEARCY",2,620,1.18,1.95,42.912752287980503,32794,"[2] NORTH CENTRAL - GILBERT"]
[30458,"[3] NORTHEAST - BATESVILLE LVSTK","AR","INDEPENDENCE",3,571,1.3,2.1,45.946523350982297,30458,"[3] NORTHEAST - BATESVILLE LVSTK"]
[32574,"[4] WEST CENTRAL - FT SMITH RGNL AP","AR","SEBASTIAN",4,449,1.2,1.92,42.348915585491099,32574,"[4] WEST CENTRAL - FT SMITH RGNL AP"]
[34248,"[5] CENTRAL - LITTLE ROCK ADAMS FLD","AR","PULASKI",5,258,1.28,2.1,29.292320743432899,34248,"[5] CENTRAL - LITTLE ROCK ADAMS FLD"]
[36920,"[6] EAST CENTRAL - STUTTGART 9 ESE","AR","ARKANSAS",6,198,1.3,2.2000000000000002,47.832965677706298,36920,"[6] EAST CENTRAL - STUTTGART 9 ESE"]
[32810,"[7] SOUTHWEST - GILLHAM DAM","AR","POLK",7,520,1.5,2.4,54.294502269735901,32810,"[7] SOUTHWEST - GILLHAM DAM"]
[30220,"[8] SOUTH CENTRAL - ARKADELPHIA 2 N","AR","CLARK",8,196,1.44,2.2999999999999998,52.461847632528197,30220,"[8] SOUTH CENTRAL - ARKADELPHIA 2 N"]
[35754,"[9] SOUTHEAST - PINE BLUFF","AR","JEFFERSON",9,215,1.4,2.2000000000000002,49.2808479244881,35754,"[9] SOUTHEAST - PINE BLUFF"]
[42910,"[1] NORTH COAST DRAINAGE - EUREKA WFO WOODLEY IS","CA","HUMBOLDT",1,20,0.88,1.37,39.2170512827769,42910,"[1] NORTH COAST DRAINAGE - EUREKA WFO WOODLEY IS"]
[40161,"[2] SACRAMENTO DRNG. - ALTURAS","CA","MODOC",2,4400,0.5,0.72,12.323587980482101,40161,"[2] SACRAMENTO DRNG. - ALTURAS"]
[48873,"[3] NORTHEAST INTER. BASINS - TERMO 1 E","CA","LASSEN",3,5300,0.49,0.8,10.033020538884699,48873,"[3] NORTHEAST INTER. BASINS - TERMO 1 E"]
[43257,"[5] SAN JOAQUIN DRNG. - FRESNO YOSEMITE INT'L","CA","FRESNO",5,333,0.68,0.97,10.905569496770701,43257,"[5] SAN JOAQUIN DRNG. - FRESNO YOSEMITE INT'L"]
[44232,"[7] SOUTHEAST DESERT BASIN - INDEPENDENCE","CA","INYO",7,3950,0.7,1.3,4.8396085141279599,44232,"[7] SOUTHEAST DESERT BASIN - INDEPENDENCE"]
[53477,"[1] ARKANSAS DRAINAGE BASIN - GRANADA","CO","PROWERS",1,3484,0.8,1.4,14.591443739255901,53477,"[1] ARKANSAS DRAINAGE BASIN - GRANADA"]
[53488,"[2] COLORADO DRAINAGE BASIN - GRAND JUNCTION WALKER","CO","MESA",2,4858,0.42,0.61,8.4675887472262108,53488,"[2] COLORADO DRAINAGE BASIN - GRAND JUNCTION WALKER"]
[50304,"[3] KANSAS DRAINAGE BASIN - ARAPAHOE","CO","CHEYENNE",3,4020,0.8,1.3,15.4886188643747,50304,"[3] KANSAS DRAINAGE BASIN - ARAPAHOE"]
[51179,"[4] PLATTE DRAINAGE BASIN - BYERS 5 ENE","CO","ADAMS",4,5100,0.7,1.2,14.5019973181131,51179,"[4] PLATTE DRAINAGE BASIN - BYERS 5 ENE"]
[57337,"[5] RIO GRANDE DRAINAGE BASIN - SAGUACHE","CO","SAGUACHE",5,7701,0.44,0.64,8.0820283906143597,57337,"[5] RIO GRANDE DRAINAGE BASIN - SAGUACHE"]
[65445,"[1] NORTHWEST - NORFOLK 2 SW","CT","LITCHFIELD",1,1340,1.04,1.69,50.754002468978598,65445,"[1] NORTHWEST - NORFOLK 2 SW"]
[63456,"[2] CENTRAL - HARTFORD","CT","HARTFORD",2,190,1.01,1.6,44.907378057766003,63456,"[2] CENTRAL - HARTFORD"]
[60806,"[3] COASTAL - BRIDGEPORT SIKORSKY AP","CT","FAIRFIELD",3,5,0.96,1.6,41.719486331577798,60806,"[3] COASTAL - BRIDGEPORT SIKORSKY AP"]
[79595,"[1] NORTHERN - WILMINGTON NEW CASTLE","DE","NEW CASTLE",1,79,0.99,1.62,37.710656259354899,79595,"[1] NORTHERN - WILMINGTON NEW CASTLE"]
[73570,"[2] SOUTHERN - GEORGETOWN 5 SW","DE","SUSSEX",2,45,1.1000000000000001,1.7,40.0292458266251,73570,"[2] SOUTHERN - GEORGETOWN 5 SW"]
[80211,"[1] NORTHWEST - APALACHICOLA AP","FL","FRANKLIN",1,20,1.4,2.39,54.872237429444603,80211,"[1] NORTHWEST - APALACHICOLA AP",null,"# of Climate Divisions"]
[80975,"[2] NORTH - BRANFORD","FL","SUWANNEE",2,30,1.29,2.2000000000000002,25.8358178940709,80975,"[2] NORTH - BRANFORD",null,{"$f":"COUNTA(N27:N62)-1","v":9}]
[82158,"[3] NORTH CENTRAL - DAYTONA BEACH INTL AP","FL","VOLUSIA",3,31,1.2,2.0299999999999998,49.075850401756,82158,"[3] NORTH CENTRAL - DAYTONA BEACH INTL AP"]
[85612,"[4] SOUTH CENTRAL - MELBOURNE WFO","FL","BREVARD",4,35,1.3,2.1,48.073704606411603,85612,"[4] SOUTH CENTRAL - MELBOURNE WFO"]
[83186,"[5] EVERGLADES - FT MYERS PAGE FLD AP","FL","LEE",5,15,1.4,2.2999999999999998,54.856636359656299,83186,"[5] EVERGLADES - FT MYERS PAGE FLD AP"]
[null,"[7] KEYS - KEY WEST INTL AP",null,null,null,null,null,null,null,null,"[7] KEYS - KEY WEST INTL AP"]
[92485,"[1] NORTHWEST - DALLAS 7 NE","GA","PAULDING",1,1100,1.2,1.98,49.3259697709424,92485,"[1] NORTHWEST - DALLAS 7 NE"]
[91619,"[3] NORTHEAST - CARNESVILLE 4 N","GA","FRANKLIN",3,866,1.28,1.95,46.608108776111898,91619,"[3] NORTHEAST - CARNESVILLE 4 N"]
[92166,"[4] WEST CENTRAL - COLUMBUS METO AP","GA","MUSCOGEE",4,392,1.18,1.9,48.755448815530997,92166,"[4] WEST CENTRAL - COLUMBUS METO AP"]
[95443,"[5] CENTRAL - MACON MIDDLE GA AP","GA","BIBB",5,343,1.1299999999999999,1.86,44.7604157007788,95443,"[5] CENTRAL - MACON MIDDLE GA AP"]
[90495,"[6] EAST CENTRAL - AUGUSTA BUSH FLD AP","GA","RICHMOND",6,132,1.1000000000000001,1.77,43.405444610761599,90495,"[6] EAST CENTRAL - AUGUSTA BUSH FLD AP"]
[93028,"[7] SOUTHWEST - EDISON","GA","CALHOUN",7,294,1.3,2.15,48.338548813605001,93028,"[7] SOUTHWEST - EDISON"]
[96879,"[8] SOUTH CENTRAL - PEARSON","GA","ATKINSON",8,205,1.29,2,46.511468190443502,96879,"[8] SOUTH CENTRAL - PEARSON"]
[97847,"[9] SOUTHEAST - SAVANNAH INTL AP","GA","CHATHAM",9,46,1.18,1.95,48.810847048415901,97847,"[9] SOUTHEAST - SAVANNAH INTL AP"]
[101079,"[1] PANHANDLE - BONNERS FERRY","ID","BOUNDARY",1,2075,0.59,0.9,23.2852898264074,101079,"[1] PANHANDLE - BONNERS FERRY"]
[105241,"[3] NORTH CENTRAL PRAIRIES - LEWISTON AP","ID","NEZ PERCE",3,1436,0.41,0.62,12.054141578519101,105241,"[3] NORTH CENTRAL PRAIRIES - LEWISTON AP"]
[103143,"[3] NORTH CENTRAL CANYONS - FENN RS","ID","IDAHO",3,1560,0.68,1,36.406118443444498,103143,"[3] NORTH CENTRAL CANYONS - FENN RS"]
[107327,"[4] CENTRAL MOUNTAINS - PRAIRIE","ID","ELMORE",4,4780,0.68,1.05,22.166740410585,107327,"[4] CENTRAL MOUNTAINS - PRAIRIE"]
[103811,"[6] SOUTHWESTERN HIGHLANDS - GRASMERE 3 S","ID","OWYHEE",6,5140,0.5,0.8,10.922331159836499,103811,"[6] SOUTHWESTERN HIGHLANDS - GRASMERE 3 S"]
[103677,"[7] CENTRAL PLAINS - GOODING 1 S","ID","GOODING",7,3643,0.5,0.8,10.3096365508612,103677,"[7] CENTRAL PLAINS - GOODING 1 S"]
[105169,"[8] NORTHEASTERN VALLEYS - LEADORE","ID","LEMHI",8,6000,0.4,0.6,8.4739012454303602,105169,"[8] NORTHEASTERN VALLEYS - LEADORE"]
[107211,"[9] UPPER SNAKE RIVER PLAINS - POCATELLO RGNL AP","ID","POWER",9,4478,0.42,0.63,11.208200815973999,107211,"[9] UPPER SNAKE RIVER PLAINS - POCATELLO RGNL AP"]
[104456,"[10] EASTERN HIGHLANDS - IDAHO FALLS 16 SE","ID","BONNEVILLE",10,5828,0.5,0.7,16.420389979223099,104456,"[10] EASTERN HIGHLANDS - IDAHO FALLS 16 SE"]
[115751,"[1] NORTHWEST - MOLINE WSO AP","IL","ROCK ISLAND",1,592,0.96,1.56,36.940955484412598,115751,"[1] NORTHWEST - MOLINE WSO AP"]
[111577,"[2] NORTHEAST - CHICAGO MIDWAY AP 3SW","IL","COOK",2,620,0.9,1.5,36.363414420778597,111577,"[2] NORTHEAST - CHICAGO MIDWAY AP 3SW"]
[110082,"[3] WEST - ALEXIS 1 SW","IL","WARREN",3,680,0.97,1.6,33.238715535927099,110082,"[3] WEST - ALEXIS 1 SW"]
[116711,"[4] CENTRAL - PEORIA GTR PEORIA RGNL","IL","PEORIA",4,650,0.93,1.47,35.298617860977998,116711,"[4] CENTRAL - PEORIA GTR PEORIA RGNL"]
[114198,"[5] EAST - HOOPESTON 1NE","IL","VERMILION",5,710,0.9,1.5,36.116082422589898,114198,"[5] EAST - HOOPESTON 1NE"]
[118179,"[6] WEST SOUTHWEST - SPRINGFIELD LINCOLN AP","IL","SANGAMON",6,594,0.9,1.47,34.923126810457802,118179,"[6] WEST SOUTHWEST - SPRINGFIELD LINCOLN AP"]
[116159,"[7] EAST SOUTHEAST - NEWTON 6 SSE","IL","JASPER",7,510,1,1.6,39.710206389509601,116159,"[7] EAST SOUTHEAST - NEWTON 6 SSE"]
[115983,"[8] SOUTHWEST - MURPHYSBORO 2 SW","IL","JACKSON",8,550,1.1000000000000001,1.74,43.928203596200703,115983,"[8] SOUTHWEST - MURPHYSBORO 2 SW"]
[112353,"[9] SOUTHEAST - DIXON SPRINGS AG CTR","IL","POPE",9,527,1.1499999999999999,1.82,45.805058358617799,112353,"[9] SOUTHEAST - DIXON SPRINGS AG CTR"]
[125535,"[1] NORTHWEST - MEDARYVILLE 5 N","IN","PULASKI",1,695,0.9,1.5,36.246435888108202,125535,"[1] NORTHWEST - MEDARYVILLE 5 N"]
[128187,"[2] NORTH CENTRAL - SOUTH BEND AP","IN","ST. JOSEPH",2,773,0.8,1.33,37.667420949400601,128187,"[2] NORTH CENTRAL - SOUTH BEND AP"]
[123037,"[3] NORTHEAST - FORT WAYNE AP","IN","ALLEN",3,791,0.82,1.3,36.537604938499399,123037,"[3] NORTHEAST - FORT WAYNE AP"]
[120922,"[4] WEST CENTRAL - BRAZIL","IN","CLAY",4,680,1,1.61,41.677050587665903,120922,"[4] WEST CENTRAL - BRAZIL"]
[120132,"[6] EAST CENTRAL - ALPINE 2 NE","IN","FAYETTE",6,850,0.92,1.46,41.056392119218003,120132,"[6] EAST CENTRAL - ALPINE 2 NE"]
[122738,"[7] SOUTHWEST - EVANSVILLE REGIONAL AP","IN","VANDERBURGH",7,400,1.03,1.7,43.952759517773501,122738,"[7] SOUTHWEST - EVANSVILLE REGIONAL AP"]
[126580,"[8] SOUTH CENTRAL - OOLITIC PURDUE EX FRM","IN","LAWRENCE",8,650,1.05,1.6,43.567085389845097,126580,"[8] SOUTH CENTRAL - OOLITIC PURDUE EX FRM"]
[120482,"[9] SOUTHEAST - BATESVILLE WTR WKS","IN","RIPLEY",9,970,1,1.5,43.423276268264601,120482,"[9] SOUTHEAST - BATESVILLE WTR WKS"]
[136975,"[1] NORTHWEST - REMSEN","IA","PLYMOUTH",1,1330,0.97,1.5,28.142727231680901,136975,"[1] NORTHWEST - REMSEN"]
[137602,"[2] NORTH CENTRAL - SHELL ROCK","IA","BUTLER",2,912,0.92,1.5,30.494840192211999,137602,"[2] NORTH CENTRAL - SHELL ROCK"]
[138009,"[3] NORTHEAST - STRAWBERRY POINT","IA","CLAYTON",3,1200,0.93,1.52,34.409640907829797,138009,"[3] NORTHEAST - STRAWBERRY POINT"]
[137708,"[4] WEST CENTRAL - SIOUX CITY AP","IA","WOODBURY",4,1095,0.87,1.35,25.886912556998301,137708,"[4] WEST CENTRAL - SIOUX CITY AP"]
[130608,"[6] EAST CENTRAL - BELLEVUE L&D 12","IA","JACKSON",6,603,0.98,1.54,33.080873276480602,130608,"[6] EAST CENTRAL - BELLEVUE L&D 12"]
[131245,"[7] SOUTHWEST - CARSON 3NNE","IA","POTTAWATTAMIE",7,1090,1.06,1.86,32.721171718926499,131245,"[7] SOUTHWEST - CARSON 3NNE"]
[132195,"[8] SOUTH CENTRAL - DERBY","IA","LUCAS",8,1190,1,1.63,34.183728250968102,132195,"[8] SOUTH CENTRAL - DERBY"]
[138688,"[9] SOUTHEAST - WASHINGTON","IA","WASHINGTON",9,690,1,1.6,33.875365714153197,138688,"[9] SOUTHEAST - WASHINGTON"]
[143153,"[1] NORTHWEST - GOODLAND RENNER FLD","KS","SHERMAN",1,3656,0.74,1.27,17.503211448335598,143153,"[1] NORTHWEST - GOODLAND RENNER FLD"]
[141767,"[2] NORTH CENTRAL - CONCORDIA BLOSSER MUNI","KS","CLOUD",2,1469,0.97,1.6,27.460579401611099,141767,"[2] NORTH CENTRAL - CONCORDIA BLOSSER MUNI"]
[143810,"[3] NORTHEAST - HORTON","KS","BROWN",3,1030,1.1000000000000001,1.9,35.444405866639698,143810,"[3] NORTHEAST - HORTON"]
[141730,"[4] WEST CENTRAL - COLLYER 10 S","KS","TREGO",4,2407,0.9,1.4,19.7947899620155,141730,"[4] WEST CENTRAL - COLLYER 10 S"]
[144178,"[5] CENTRAL - KANOPOLIS LAKE","KS","ELLSWORTH",5,1492,1.07,1.7,25.542465538262899,144178,"[5] CENTRAL - KANOPOLIS LAKE"]
[148167,"[6] EAST CENTRAL - TOPEKA BILLARD MUNI AP","KS","SHAWNEE",6,881,1.07,1.78,34.707205789067402,148167,"[6] EAST CENTRAL - TOPEKA BILLARD MUNI AP"]
[142164,"[7] SOUTHWEST - DODGE CITY RGNL AP","KS","FORD",7,2582,0.86,1.44,20.542071099784199,142164,"[7] SOUTHWEST - DODGE CITY RGNL AP"]
[148830,"[8] SOUTH CENTRAL - WICHITA MID-CONTINENT","KS","SEDGWICK",8,1321,1.1000000000000001,1.76,30.2310903797453,148830,"[8] SOUTH CENTRAL - WICHITA MID-CONTINENT"]
[141351,"[9] SOUTHEAST - CASSODAY 2SW","KS","BUTLER",9,1440,1.1499999999999999,1.8,32.179869414972103,141351,"[9] SOUTHEAST - CASSODAY 2SW"]
[151631,"[1] WESTERN - CLINTON 4 S","KY","HICKMAN",1,350,1.2,1.9,46.524157593527399,151631,"[1] WESTERN - CLINTON 4 S"]
[154954,"[2] CENTRAL - LOUISVILLE INTL AP","KY","JEFFERSON",2,488,0.95,1.51,43.875840672316102,154954,"[2] CENTRAL - LOUISVILLE INTL AP"]
[154746,"[3] BLUE GRASS - LEXINGTON BLUEGRASS AP","KY","FAYETTE",3,980,0.94,1.5,45.456807167131402,154746,"[3] BLUE GRASS - LEXINGTON BLUEGRASS AP"]
[151080,"[4] EASTERN - BUCKHORN LAKE","KY","PERRY",4,780,0.9,1.44,45.849065971780597,151080,"[4] EASTERN - BUCKHORN LAKE"]
[168440,"[1] NORTHWEST - SHREVEPORT AP","LA","CADDO",1,254,1.32,2.16,42.452293152756297,168440,"[1] NORTHWEST - SHREVEPORT AP"]
[169803,"[2] NORTH CENTRAL - WINNFIELD 3 N","LA","WINN",2,160,1.4,2.2999999999999998,55.9953091976978,169803,"[2] NORTH CENTRAL - WINNFIELD 3 N"]
[169806,"[3] NORTHEAST - WINNSBORO 5 SSE","LA","FRANKLIN",3,80,1.46,2.2999999999999998,53.988962244902702,169806,"[3] NORTHEAST - WINNSBORO 5 SSE"]
[165266,"[4] WEST CENTRAL - LEESVILLE","LA","VERNON",4,28,1.4,2.4,52.8365850420765,165266,"[4] WEST CENTRAL - LEESVILLE"]
[169357,"[5] CENTRAL - VIDALIA #2","LA","CONCORDIA",5,60,1.5,2.5499999999999998,54.455508941979801,169357,"[5] CENTRAL - VIDALIA #2"]
[165078,"[7] SOUTHWEST - LAKE CHARLES AP","LA","CALCASIEU",7,9,1.47,2.5499999999999998,55.647435261786001,165078,"[7] SOUTHWEST - LAKE CHARLES AP"]
[165021,"[8] SOUTH CENTRAL - LAFAYETTE","LA","LAFAYETTE",8,25,1.5,2.7,60.2836234467933,165021,"[8] SOUTH CENTRAL - LAFAYETTE"]
[166660,"[9] SOUTHEAST - NEW ORLEANS AP","LA","JEFFERSON",9,4,1.44,2.4,61.295183637258901,166660,"[9] SOUTHEAST - NEW ORLEANS AP"]
[171175,"[1] NORTHERN - CARIBOU WFO","ME","AROOSTOOK",1,624,0.7,1.06,36.999612938899602,171175,"[1] NORTHERN - CARIBOU WFO"]
[178641,"[2] SOUTHERN INTERIOR - SWANS FALLS","ME","OXFORD",2,400,1,1.6,43.139020616171102,178641,"[2] SOUTHERN INTERIOR - SWANS FALLS"]
[176905,"[3] COASTAL - PORTLAND JETPORT","ME","CUMBERLAND",3,45,0.97,1.62,43.695301266456397,176905,"[3] COASTAL - PORTLAND JETPORT"]
[188005,"[1] SOUTHEASTERN SHORE - SALISBURY FAA AP","MD","WICOMICO",1,48,0.92,1.86,44.142674633351596,188005,"[1] SOUTHEASTERN SHORE - SALISBURY FAA AP"]
[183090,"[2] CENTRAL EASTERN SHORE - FEDERALSBURG","MD","CAROLINE",2,20,1.1000000000000001,1.9,43.771629083186397,183090,"[2] CENTRAL EASTERN SHORE - FEDERALSBURG"]
[186915,"[3] LOWER SOUTHERN - PATUXENT RIVER","MD","ST. MARY'S",3,38,1.1000000000000001,2,14.320344635908899,186915,"[3] LOWER SOUTHERN - PATUXENT RIVER"]
[180465,"[4] UPPER SOUTHERN - BALTIMORE WASH INTL AP","MD","ANNE ARUNDEL",4,156,0.99,1.62,41.654828387736799,180465,"[4] UPPER SOUTHERN - BALTIMORE WASH INTL AP"]
[180470,"[6] NORTHERN CENTRAL - BALTIMORE CITY","MD","BALTIMORE (CITY)",6,14,1.05,1.72,41.183517631180898,180470,"[6] NORTHERN CENTRAL - BALTIMORE CITY"]
[184030,"[7] APPALACHIAN MOUNTAIN - HANCOCK","MD","WASHINGTON",7,384,0.9,1.3,34.399616872771801,184030,"[7] APPALACHIAN MOUNTAIN - HANCOCK"]
[188315,"[8] ALLEGHENY PLATEAU - SINES DEEP CREEK","MD","GARRETT",8,2040,0.74,1.1599999999999999,46.941347068619699,188315,"[8] ALLEGHENY PLATEAU - SINES DEEP CREEK"]
[193985,"[1] WESTERN - KNIGHTVILLE DAM","MA","HAMPSHIRE",1,630,1,1.68,44.480456359622501,193985,"[1] WESTERN - KNIGHTVILLE DAM"]
[190736,"[2] CENTRAL - BLUE HILL","MA","NORFOLK",2,625,1.08,1.75,50.209855880060402,190736,"[2] CENTRAL - BLUE HILL"]
[190770,"[3] COASTAL - BOSTON","MA","SUFFOLK",3,12,0.96,1.57,43.072755536579898,190770,"[3] COASTAL - BOSTON"]
[204090,"[1] WEST UPPER - IRON MT KINGSFORD WWTP","MI","DICKINSON",1,1071,0.79,1.2,28.266469248647802,204090,"[1] WEST UPPER - IRON MT KINGSFORD WWTP"]
[207366,"[2] EAST UPPER - SAULT STE MARIE SNDRSN","MI","CHIPPEWA",2,722,0.62,1.02,32.601371840622299,207366,"[2] EAST UPPER - SAULT STE MARIE SNDRSN"]
[200662,"[3] NORTHWEST - BELLAIRE","MI","ANTRIM",3,625,0.7,1.1000000000000001,31.163715135887301,200662,"[3] NORTHWEST - BELLAIRE"]
[200164,"[4] NORTHEAST LOWER - ALPENA CO RGNL AP","MI","ALPENA",4,684,0.66,1.04,27.6986656305506,200164,"[4] NORTHEAST LOWER - ALPENA CO RGNL AP"]
[205712,"[5] WEST CENTRAL LOWER - MUSKEGON CO AP","MI","MUSKEGON",5,625,0.71,1.1499999999999999,32.081845424203202,205712,"[5] WEST CENTRAL LOWER - MUSKEGON CO AP"]
[203170,"[6] CENTRAL LOWER - GLADWIN","MI","GLADWIN",6,775,0.8,1.4,18.302869333267399,203170,"[6] CENTRAL LOWER - GLADWIN"]
[203580,"[7] EAST CENTRAL LOWER - HARBOR BEACH","MI","HURON",7,600,0.7,1.1000000000000001,29.4734700244429,203580,"[7] EAST CENTRAL LOWER - HARBOR BEACH"]
[203333,"[8] SOUTHWEST LOWER - GERALD R FORD INTL AP","MI","KENT",8,803,0.82,1.33,35.820947726870699,203333,"[8] SOUTHWEST LOWER - GERALD R FORD INTL AP"]
[204155,"[9] SOUTH CENTRAL LOWER - JACKSON 3N","MI","JACKSON",9,950,0.8,1.26,30.621632811511201,204155,"[9] SOUTH CENTRAL LOWER - JACKSON 3N"]
[202846,"[10] SOUTHEAST LOWER - FLINT BISHOP INTL AP","MI","GENESEE",10,770,0.71,1.1599999999999999,26.234706471737699,202846,"[10] SOUTHEAST LOWER - FLINT BISHOP INTL AP"]
[218235,"[1] NORTHWEST - THIEF LAKE REFUGE","MN","MARSHALL",1,1142,0.8,1.3,23.169414773254299,218235,"[1] NORTHWEST - THIEF LAKE REFUGE"]
[214026,"[2] NORTH CENTRAL - INTERNATIONAL FALLS AP","MN","KOOCHICHING",2,1183,0.68,1.1399999999999999,24.333258707563498,214026,"[2] NORTH CENTRAL - INTERNATIONAL FALLS AP"]
[212248,"[3] NORTHEAST - DULUTH INTL AP","MN","ST. LOUIS",3,1433,0.79,1.31,29.442940913425002,212248,"[3] NORTHEAST - DULUTH INTL AP"]
[210112,"[4] WEST CENTRAL - ALEXANDRIA CHANDLER FLD","MN","DOUGLAS",4,1416,0.83,1.31,11.1161275511538,210112,"[4] WEST CENTRAL - ALEXANDRIA CHANDLER FLD"]
[217294,"[5] CENTRAL - ST CLOUD MUNI AP","MN","SHERBURNE",5,1018,0.83,1.39,26.685996216082401,217294,"[5] CENTRAL - ST CLOUD MUNI AP"]
[218323,"[7] SOUTHWEST - TRACY","MN","LYON",7,1403,0.9,1.4,25.171279380420401,218323,"[7] SOUTHWEST - TRACY"]
[215987,"[8] SOUTH CENTRAL - NORTHFIELD 2 NNE","MN","DAKOTA",8,890,0.9,1.42,29.0813096390374,215987,"[8] SOUTH CENTRAL - NORTHFIELD 2 NNE"]
[217004,"[9] SOUTHEAST - ROCHESTER INTL AP","MN","OLMSTED",9,1304,0.85,1.44,29.5082689102221,217004,"[9] SOUTHEAST - ROCHESTER INTL AP"]
[221743,"[1] UPPER DELTA - CLEVELAND 3 N","MS","BOLIVAR",1,140,1.4,2.2999999999999998,50.423791056400198,221743,"[1] UPPER DELTA - CLEVELAND 3 N"]
[227815,"[2] NORTH CENTRAL - SARDIS DAM","MS","PANOLA",2,303,1.32,2.16,53.862935657902199,227815,"[2] NORTH CENTRAL - SARDIS DAM"]
[229003,"[3] NORTHEAST - TUPELO RGNL AP","MS","LEE",3,361,1.3,2.13,54.419479251947102,229003,"[3] NORTHEAST - TUPELO RGNL AP"]
[228445,"[4] LOWER DELTA - STONEVILLE EXP STN","MS","WASHINGTON",4,127,1.4,2.1,50.038279315596498,228445,"[4] LOWER DELTA - STONEVILLE EXP STN"]
[225062,"[5] CENTRAL - LEXINGTON","MS","HOLMES",5,285,1.4,2.23,54.050590822853302,225062,"[5] CENTRAL - LEXINGTON"]
[228374,"[6] EAST CENTRAL - STATE UNIV","MS","OKTIBBEHA",6,185,1.3,2.11,51.837215400029997,228374,"[6] EAST CENTRAL - STATE UNIV"]
[227714,"[7] SOUTHWEST - RUTH 1 SE","MS","LINCOLN",7,443,1.43,2.35,56.3540766454718,227714,"[7] SOUTHWEST - RUTH 1 SE"]
[227220,"[8] SOUTH CENTRAL - PURVIS 2N","MS","LAMAR",8,378,1.4,2.2999999999999998,59.832813910051399,227220,"[8] SOUTH CENTRAL - PURVIS 2N"]
[225776,"[9] SOUTHEAST - MERIDIAN AP","MS","LAUDERDALE",9,294,1.3,2.12,55.170790586378899,225776,"[9] SOUTHEAST - MERIDIAN AP"]
[227840,"[10] COASTAL - SAUCIER EXP FOREST","MS","HARRISON",10,229,1.5,2.5,66.875872040758395,227840,"[10] COASTAL - SAUCIER EXP FOREST"]
[234358,"[1] NORTHWEST PRAIRIE - KANSAS CITY INTL AP","MO","PLATTE",1,1005,1.01,1.76,37.207543267124301,234358,"[1] NORTHWEST PRAIRIE - KANSAS CITY INTL AP"]
[237455,"[2] NORTHEAST PRAIRIE - ST LOUIS LAMBERT AP","MO","ST. LOUIS",2,531,0.96,1.57,37.233300152643501,237455,"[2] NORTHEAST PRAIRIE - ST LOUIS LAMBERT AP"]
[235987,"[3] WEST CENTRAL PLAINS - NEVADA WTP","MO","VERNON",3,820,1.2,1.9,39.325031223008899,235987,"[3] WEST CENTRAL PLAINS - NEVADA WTP"]
[237976,"[4] WEST OZARKS - SPRINGFIELD WSO AP","MO","GREENE",4,1259,1.1000000000000001,1.78,42.014439295849598,237976,"[4] WEST OZARKS - SPRINGFIELD WSO AP"]
[238620,"[5] EAST OZARKS - VIENNA 2 WNW","MO","MARIES",5,770,1.1100000000000001,1.74,41.334146188653101,238620,"[5] EAST OZARKS - VIENNA 2 WNW"]
[233999,"[6] BOOTHEEL - HORNERSVILLE","MO","DUNKLIN",6,250,1.25,2.0699999999999998,46.362927066531498,233999,"[6] BOOTHEEL - HORNERSVILLE"]
[245745,"[1] WESTERN - MISSOULA INTL AP","MT","MISSOULA",1,3192,0.41,0.64,13.1938276621895,245745,"[1] WESTERN - MISSOULA INTL AP"]
[241309,"[2] SOUTHWESTERN - BUTTE 8 S","MT","SILVER BOW",2,5700,0.5,0.8,14.846556945220501,241309,"[2] SOUTHWESTERN - BUTTE 8 S"]
[241737,"[3] NORTH CENTRAL - CHOTEAU","MT","TETON",3,3845,0.63,1,10.5588976608386,241737,"[3] NORTH CENTRAL - CHOTEAU"]
[240807,"[5] SOUTH CENTRAL - BILLINGS INTL AP","MT","YELLOWSTONE",5,3581,0.51,0.85,13.6707487377093,240807,"[5] SOUTH CENTRAL - BILLINGS INTL AP"]
[241088,"[6] NORTHEASTERN - BREDETTE","MT","ROOSEVELT",6,2638,0.65,1.02,12.2633469626566,241088,"[6] NORTHEASTERN - BREDETTE"]
[248169,"[7] SOUTHEASTERN - TERRY 21 NNW","MT","PRAIRIE",7,3142,0.63,1.06,13.874866913076501,248169,"[7] SOUTHEASTERN - TERRY 21 NNW"]
[257665,"[1] PANHANDLE - SCOTTSBLUFF AP","NE","SCOTTS BLUFF",1,3945,0.61,0.99,14.567364076393501,257665,"[1] PANHANDLE - SCOTTSBLUFF AP"]
[258760,"[2] NORTH CENTRAL - VALENTINE MILLER AP","NE","CHERRY",2,2590,0.73,1.22,18.337201881668001,258760,"[2] NORTH CENTRAL - VALENTINE MILLER AP"]
[255995,"[3] NORTHEAST - NORFOLK AP","NE","MADISON",3,1551,0.88,1.48,24.8177628805457,255995,"[3] NORTHEAST - NORFOLK AP"]
[253395,"[5] CENTRAL - GRAND ISLAND CTR NE AP","NE","HALL",5,1840,0.88,1.45,23.876035846249,253395,"[5] CENTRAL - GRAND ISLAND CTR NE AP"]
[254795,"[6] EAST CENTRAL - LINCOLN AP","NE","LANCASTER",6,1190,0.94,1.55,17.8023137319109,254795,"[6] EAST CENTRAL - LINCOLN AP"]
[256065,"[7] SOUTHWEST - NORTH PLATTE RGNL AP","NE","LINCOLN",7,2778,0.81,1.25,19.383337615550602,256065,"[7] SOUTHWEST - NORTH PLATTE RGNL AP"]
[252560,"[8] SOUTH CENTRAL - EDISON","NE","FURNAS",8,2120,0.9,1.41,21.211898959741902,252560,"[8] SOUTH CENTRAL - EDISON"]
[258395,"[9] SOUTHEAST - SYRACUSE","NE","OTOE",9,1100,1,1.7,29.950787814231798,258395,"[9] SOUTHEAST - SYRACUSE"]
[269171,"[1] NORTHWESTERN - WINNEMUCCA AP","NV","HUMBOLDT",1,4296,0.39,0.57999999999999996,7.9489980693056497,269171,"[1] NORTHWESTERN - WINNEMUCCA AP"]
[262631,"[2] NORTHEASTERN - ELY AIRPORT","NV","WHITE PINE",2,6262,0.44,0.63,9.0888613946378705,262631,"[2] NORTHEASTERN - ELY AIRPORT"]
[268170,"[3] SOUTH CENTRAL - TONOPAH AIRPORT","NV","NYE",3,5395,0.42,0.63,2.2727660960845499,268170,"[3] SOUTH CENTRAL - TONOPAH AIRPORT"]
[264436,"[4] EXTREME SOUTHERN - LAS VEGAS AP","NV","CLARK",4,2131,0.57999999999999996,0.88,4.1954561446556298,264436,"[4] EXTREME SOUTHERN - LAS VEGAS AP"]
[275639,"[1] NORTHERN - MT WASHINGTON","NH","COOS",1,6267,1.02,1.77,92.171099441877203,275639,"[1] NORTHERN - MT WASHINGTON"]
[271683,"[2] SOUTHERN - CONCORD ASOS","NH","MERRIMACK",2,346,0.85,1.33,38.0610226239681,271683,"[2] SOUTHERN - CONCORD ASOS"]
[286026,"[1] NORTHERN - NEWARK INTL AP","NJ","ESSEX",1,7,0.99,1.61,43.986730749057301,286026,"[1] NORTHERN - NEWARK INTL AP"]
[280311,"[2] SOUTHERN - ATLANTIC CITY INTL AP","NJ","ATLANTIC",2,60,1.01,1.63,41.185443687022897,280311,"[2] SOUTHERN - ATLANTIC CITY INTL AP"]
[281351,"[3] COASTAL - CAPE MAY 2 NW","NJ","CAPE MAY",3,20,1,1.66,37.268170399953902,281351,"[3] COASTAL - CAPE MAY 2 NW"]
[293142,"[1] NORTHWESTERN PLATEAU - FARMINGTON AG SCI CTR","NM","SAN JUAN",1,5625,0.5,0.7,7.7209758109770599,293142,"[1] NORTHWESTERN PLATEAU - FARMINGTON AG SCI CTR"]
[292837,"[2] NORTHERN MOUNTAINS - EL VADO DAM","NM","RIO ARRIBA",2,6740,0.5,0.8,14.3061020804502,292837,"[2] NORTHERN MOUNTAINS - EL VADO DAM"]
[292030,"[3] NORTHEASTERN PLAINS - CONCHAS DAM","NM","SAN MIGUEL",3,4244,0.8,1.3,13.7035163566705,292030,"[3] NORTHEASTERN PLAINS - CONCHAS DAM"]
[292250,"[4] SOUTHWESTERN MOUNTAINS - CUBERO","NM","CIBOLA",4,6195,0.6,0.9,10.926241224445899,292250,"[4] SOUTHWESTERN MOUNTAINS - CUBERO"]
[290234,"[5] CENTRAL VALLEY - ALBUQUERQUE INTL AP","NM","BERNALILLO",5,5310,0.51,0.77,8.6430493763345009,290234,"[5] CENTRAL VALLEY - ALBUQUERQUE INTL AP"]
[297094,"[6] CENTRAL HIGHLANDS - PROGRESSO","NM","TORRANCE",6,6297,0.62,1.02,12.795570300004499,297094,"[6] CENTRAL HIGHLANDS - PROGRESSO"]
[290600,"[7] SOUTHEASTERN PLAINS - ARTESIA 6S","NM","EDDY",7,3366,0.78,1.3,10.6966610785556,290600,"[7] SOUTHEASTERN PLAINS - ARTESIA 6S"]
[294426,"[8] SOUTHERN DESERT - JORNADA EXP RANGE","NM","DONA ANA",8,4266,0.65,1.07,9.1515503508978,294426,"[8] SOUTHERN DESERT - JORNADA EXP RANGE"]
[303983,"[1] WESTERN PLATEAU - HORNELL ALMOND DAM","NY","STEUBEN",1,1325,0.7,1.2,32.2241946216202,303983,"[1] WESTERN PLATEAU - HORNELL ALMOND DAM"]
[300687,"[2] EASTERN PLATEAU - BINGHAMTON GREATER AP","NY","BROOME",2,1595,0.74,1.1599999999999999,37.115249508353102,300687,"[2] EASTERN PLATEAU - BINGHAMTON GREATER AP"]
[303851,"[3] NORTHERN PLATEAU - HIGHMARKET","NY","LEWIS",3,1763,0.9,1.5,52.477528737194099,303851,"[3] NORTHERN PLATEAU - HIGHMARKET"]
[308586,"[6] MOHAWK VALLEY - TRIBES HILL","NY","MONTGOMERY",6,300,0.8,1.3,36.370337490532002,308586,"[6] MOHAWK VALLEY - TRIBES HILL"]
[309389,"[7] CHAMPLAIN VALLEY - WHITEHALL","NY","WASHINGTON",7,119,0.87,1.35,36.116445169528198,309389,"[7] CHAMPLAIN VALLEY - WHITEHALL"]
[301185,"[8] ST. LAWRENCE VALLEY - CANTON 4 SE","NY","ST. LAWRENCE",8,448,0.7,1.1399999999999999,33.9360818166626,301185,"[8] ST. LAWRENCE VALLEY - CANTON 4 SE"]
[307167,"[9] GREAT LAKES - ROCHESTER INTL AP","NY","MONROE",9,533,0.65,1.03,32.004585596925899,307167,"[9] GREAT LAKES - ROCHESTER INTL AP"]
[308383,"[10] CENTRAL LAKES - SYRACUSE HANCOCK  AP","NY","ONONDAGA",10,413,0.7,1.1299999999999999,36.760231810687898,308383,"[10] CENTRAL LAKES - SYRACUSE HANCOCK  AP"]
[310301,"[1] SOUTHERN MOUNTAINS - ASHEVILLE","NC","BUNCOMBE",1,2238,0.82,1.37,37.832106862413603,310301,"[1] SOUTHERN MOUNTAINS - ASHEVILLE"]
[319675,"[2] NORTHERN MOUNTAINS - YADKINVILLE 6 E","NC","YADKIN",2,875,1,1.63,43.0817221889316,319675,"[2] NORTHERN MOUNTAINS - YADKINVILLE 6 E"]
[313630,"[3] NORTHERN PIEDMONT - GREENSBORO  AP","NC","GUILFORD",3,890,0.98,1.56,42.063608617594298,313630,"[3] NORTHERN PIEDMONT - GREENSBORO  AP"]
[311690,"[5] SOUTHERN PIEDMONT - CHARLOTTE DOUGLAS AP","NC","MECKLENBURG",5,728,1.01,1.67,42.397444076015702,311690,"[5] SOUTHERN PIEDMONT - CHARLOTTE DOUGLAS AP"]
[319457,"[6] SOUTHERN COASTAL PLAIN - WILMINGTON INTL AP","NC","NEW HANOVER",6,33,1.24,2.19,54.652552570885902,319457,"[6] SOUTHERN COASTAL PLAIN - WILMINGTON INTL AP"]
[319476,"[7] CENTRAL COASTAL PLAIN - WILSON 3 SW","NC","WILSON",7,110,1.1000000000000001,1.74,38.497102329964697,319476,"[7] CENTRAL COASTAL PLAIN - WILSON 3 SW"]
[311458,"[8] NORTHERN COASTAL PLAIN - CAPE HATTERAS AP","NC","DARE",8,11,1.26,2.16,55.824485445260798,311458,"[8] NORTHERN COASTAL PLAIN - CAPE HATTERAS AP"]
[329425,"[1] NORTHWEST - WILLISTON SLOULIN FLD","ND","WILLIAMS",1,1902,0.56999999999999995,1.02,13.3898453950807,329425,"[1] NORTHWEST - WILLISTON SLOULIN FLD"]
[320492,"[2] NORTH CENTRAL - BALFOUR 3 SW","ND","MCHENRY",2,1615,0.76,1.3,15.949105280340101,320492,"[2] NORTH CENTRAL - BALFOUR 3 SW"]
[321435,"[3] NORTHEAST - CAVALIER 7NW","ND","PEMBINA",3,890,0.9,1.5,19.315489900829501,321435,"[3] NORTHEAST - CAVALIER 7NW"]
[327585,"[4] WEST CENTRAL - RIVERDALE","ND","MCLEAN",4,1977,0.8,1.35,16.5837040347092,327585,"[4] WEST CENTRAL - RIVERDALE"]
[322018,"[5] CENTRAL - DAWSON","ND","KIDDER",5,1730,0.79,1.38,17.4655805847168,322018,"[5] CENTRAL - DAWSON"]
[322859,"[6] EAST CENTRAL - FARGO HECTOR INTL AP","ND","CASS",6,900,0.74,1.3,20.041663432215099,322859,"[6] EAST CENTRAL - FARGO HECTOR INTL AP"]
[327530,"[7] SOUTHWEST - RICHARDTON ABBEY","ND","STARK",7,2470,0.7,1.21,16.963260930888602,327530,"[7] SOUTHWEST - RICHARDTON ABBEY"]
[320382,"[9] SOUTHEAST - ASHLEY","ND","MCINTOSH",9,2014,0.8,1.4,17.596545084205701,320382,"[9] SOUTHEAST - ASHLEY"]
[338357,"[1] NORTHWEST - TOLEDO EXPRESS WSO AP","OH","LUCAS",1,669,0.76,1.22,32.624084543076201,338357,"[1] NORTHWEST - TOLEDO EXPRESS WSO AP"]
[336196,"[2] NORTH CENTRAL - OBERLIN","OH","LORAIN",2,816,0.78,1.24,34.687682730758198,336196,"[2] NORTH CENTRAL - OBERLIN"]
[330058,"[3] NORTHEAST - AKRON CANTON WSO AP","OH","SUMMIT",3,1208,0.72,1.21,36.338136760287,330058,"[3] NORTHEAST - AKRON CANTON WSO AP"]
[337935,"[4] WEST CENTRAL - SPRINGFIELD NEW WWKS","OH","CLARK",4,930,0.9,1.4,38.648295673483297,337935,"[4] WEST CENTRAL - SPRINGFIELD NEW WWKS"]
[331786,"[5] CENTRAL - COLUMBUS WSO AP","OH","FRANKLIN",5,810,0.79,1.32,38.035463905329799,331786,"[5] CENTRAL - COLUMBUS WSO AP"]
[334865,"[6] EAST CENTRAL - MANSFIELD WSO AP","OH","RICHLAND",6,1295,0.8,1.3,34.239322516630999,334865,"[6] EAST CENTRAL - MANSFIELD WSO AP"]
[334992,"[7] NORTHEAST HILLS - MASSILLON","OH","STARK",7,930,0.9,1.4,11.1544072801911,334992,"[7] NORTHEAST HILLS - MASSILLON"]
[332075,"[8] SOUTHWEST - DAYTON WSO AP","OH","MONTGOMERY",8,1000,0.8,1.34,37.4822045999761,332075,"[8] SOUTHWEST - DAYTON WSO AP"]
[334004,"[9] SOUTH CENTRAL - JACKSON 3 NW","OH","JACKSON",9,800,0.9,1.45,36.690105805018703,334004,"[9] SOUTH CENTRAL - JACKSON 3 NW"]
[338378,"[10] SOUTHEAST - JENKINS DAM BURR OAK","OH","ATHENS",10,760,0.8,1.3,35.062757844636799,338378,"[10] SOUTHEAST - JENKINS DAM BURR OAK"]
[343002,"[1] PANHANDLE - EVA","OK","TEXAS",1,3574,0.8,1.3,15.1250235548346,343002,"[1] PANHANDLE - EVA"]
[343304,"[2] NORTH CENTRAL - FORT SUPPLY 3SE","OK","WOODWARD",2,2030,1,1.71,21.423120637987701,343304,"[2] NORTH CENTRAL - FORT SUPPLY 3SE"]
[348992,"[3] NORTHEAST - TULSA INTL AP","OK","TULSA",3,650,1.23,1.95,39.0766583580454,348992,"[3] NORTHEAST - TULSA INTL AP"]
[345648,"[4] WEST CENTRAL - MAYFIELD","OK","BECKHAM",4,2005,1.1000000000000001,1.9,23.949199612925501,345648,"[4] WEST CENTRAL - MAYFIELD"]
[348497,"[6] EAST CENTRAL - STIGLER 1 SE","OK","HASKELL",6,570,1.35,2.2999999999999998,43.121572558486797,348497,"[6] EAST CENTRAL - STIGLER 1 SE"]
[343281,"[7] SOUTHWEST - FT COBB","OK","CADDO",7,1285,1.2,2.0099999999999998,28.808166101360001,343281,"[7] SOUTHWEST - FT COBB"]
[344865,"[8] SOUTH CENTRAL - KINGSTON 5 SSE","OK","MARSHALL",8,684,1.34,2.1800000000000002,37.9973745308139,344865,"[8] SOUTH CENTRAL - KINGSTON 5 SSE"]
[340670,"[9] SOUTHEAST - BENGAL 4 NNW","OK","LATIMER",9,667,1.4,2.4,48.328681863347597,340670,"[9] SOUTHEAST - BENGAL 4 NNW"]
[350328,"[1] COASTAL AREA - ASTORIA AP PORT OF","OR","CLATSOP",1,9,0.88,1.42,67.778287394032304,350328,"[1] COASTAL AREA - ASTORIA AP PORT OF"]
[355429,"[3] SOUTHWESTERN VALLEYS - MEDFORD INTL AP","OR","JACKSON",3,1297,0.6,0.97,19.094623453349701,355429,"[3] SOUTHWESTERN VALLEYS - MEDFORD INTL AP"]
[352697,"[4] NORTHERN CASCADES - ESTACADA 24 SE","OR","CLACKAMAS",4,2200,0.88,1.4,54.042982315868898,352697,"[4] NORTHERN CASCADES - ESTACADA 24 SE"]
[353232,"[5] HIGH PLATEAU - GERBER DAM","OR","KLAMATH",5,4850,0.6,1.2,17.6999320750941,353232,"[5] HIGH PLATEAU - GERBER DAM"]
[356546,"[6] NORTH CENTRAL - PENDLETON E OR RGNL AP","OR","UMATILLA",6,1486,0.41,0.62,12.1368281448036,356546,"[6] NORTH CENTRAL - PENDLETON E OR RGNL AP"]
[354670,"[7] SOUTH CENTRAL - LAKEVIEW 2 NNW","OR","LAKE",7,4890,0.5,0.79,15.361697703957001,354670,"[7] SOUTH CENTRAL - LAKEVIEW 2 NNW"]
[356845,"[8] NORTHEAST - PRAIRIE CITY RS","OR","GRANT",8,3540,0.47,0.7,14.559330220833299,356845,"[8] NORTHEAST - PRAIRIE CITY RS"]
[354321,"[9] SOUTHEAST - JORDAN VALLEY","OR","MALHEUR",9,4390,0.45,0.71,12.487680157671599,354321,"[9] SOUTHEAST - JORDAN VALLEY"]
[369705,"[1] POCONO MOUNTAINS - WILKES-BARRE INTL AP","PA","LUZERNE",1,930,0.78,1.29,37.009486563445499,369705,"[1] POCONO MOUNTAINS - WILKES-BARRE INTL AP"]
[360106,"[2] EAST CENTRAL MOUNTAINS - ALLENTOWN AP","PA","LEHIGH",2,390,0.99,1.57,44.138919849983203,360106,"[2] EAST CENTRAL MOUNTAINS - ALLENTOWN AP"]
[366889,"[3] SOUTHEASTERN PIEDMONT - PHILADELPHIA INTL AP","PA","PHILADELPHIA",3,10,0.99,1.6,41.504717986157601,366889,"[3] SOUTHEASTERN PIEDMONT - PHILADELPHIA INTL AP"]
[363699,"[4] LOWER SUSQUEHANNA - HARRISBURG CAPITAL CY","PA","YORK",4,340,0.84,1.47,32.470822735899198,363699,"[4] LOWER SUSQUEHANNA - HARRISBURG CAPITAL CY"]
[367931,"[5] MIDDLE SUSQUEHANNA - SELINSGROVE 2 S","PA","SNYDER",5,420,1,1.7,24.6253803526056,367931,"[5] MIDDLE SUSQUEHANNA - SELINSGROVE 2 S"]
[368905,"[6] UPPER SUSQUEHANNA - TOWANDA 1 S","PA","BRADFORD",6,760,0.8,1.21,32.713503330418099,368905,"[6] UPPER SUSQUEHANNA - TOWANDA 1 S"]
[362265,"[7] CENTRAL MOUNTAINS - DU BOIS 7 E","PA","CLEARFIELD",7,1670,0.75,1.1499999999999999,40.595851966673102,362265,"[7] CENTRAL MOUNTAINS - DU BOIS 7 E"]
[364001,"[8] SOUTH CENTRAL MOUNTAINS - HOLLIDAYSBURG 2 NW","PA","BLAIR",8,990,0.81,1.3,36.420228028112199,364001,"[8] SOUTH CENTRAL MOUNTAINS - HOLLIDAYSBURG 2 NW"]
[366993,"[9] SOUTHWEST PLATEAU - PITTSBURGH ASOS","PA","ALLEGHENY",9,1203,0.71,1.1299999999999999,34.533815054724101,366993,"[9] SOUTHWEST PLATEAU - PITTSBURGH ASOS"]
[362682,"[10] NORTHWEST PLATEAU - ERIE WSO AP","PA","ERIE",10,730,0.73,1.21,36.5789792564264,362682,"[10] NORTHWEST PLATEAU - ERIE WSO AP"]
[376698,"[1] ALL - PROVIDENCE","RI","KENT",1,60,1.05,1.75,45.5632476480721,376698,"[1] ALL - PROVIDENCE"]
[384581,"[1] MOUNTAIN - JOCASSEE 8 WNW","SC","OCONEE",1,2500,1.6,2.8,82.423347193347993,384581,"[1] MOUNTAIN - JOCASSEE 8 WNW"]
[383747,"[2] NORTHWEST - GRNVL SPART INTL AP","SC","SPARTANBURG",2,943,1.1200000000000001,1.86,48.8460074304476,383747,"[2] NORTHWEST - GRNVL SPART INTL AP"]
[389327,"[3] NORTH CENTRAL - WINNSBORO","SC","FAIRFIELD",3,560,1.2,1.9,35.581370980331101,389327,"[3] NORTH CENTRAL - WINNSBORO"]
[385306,"[4] NORTHEAST - LORIS 2 S","SC","HORRY",4,90,1.2,1.9,46.786638643163798,385306,"[4] NORTHEAST - LORIS 2 S"]
[386209,"[5] WEST CENTRAL - NEWBERRY","SC","NEWBERRY",5,476,1.2,1.9,44.898800093251197,386209,"[5] WEST CENTRAL - NEWBERRY"]
[381544,"[7] SOUTHERN - CHARLESTON INTL AP","SC","CHARLESTON",7,40,1.2,2,49.364079046329003,381544,"[7] SOUTHERN - CHARLESTON INTL AP"]
[394864,"[1] NORTHWEST - LEMMON","SD","PERKINS",1,2567,0.71,1.2,16.697259030576099,394864,"[1] NORTHWEST - LEMMON"]
[396282,"[2] NORTH CENTRAL - ONAKA 2N","SD","FAULK",2,1610,0.8,1.4,18.064820912317199,396282,"[2] NORTH CENTRAL - ONAKA 2N"]
[390020,"[3] NORTHEAST - ABERDEEN RGNL AP","SD","BROWN",3,1297,0.79,1.32,18.553700763816099,390020,"[3] NORTHEAST - ABERDEEN RGNL AP"]
[396427,"[4] BLACK HILLS - PACTOLA DAM","SD","PENNINGTON",4,4720,0.7,1.2,18.512526528035199,396427,"[4] BLACK HILLS - PACTOLA DAM"]
[392557,"[5] SOUTHWEST - EDGEMONT","SD","FALL RIVER",5,3610,0.62,1.02,15.041513809454701,392557,"[5] SOUTHWEST - EDGEMONT"]
[396170,"[6] CENTRAL - OAHE DAM","SD","STANLEY",6,1660,0.8,1.3,14.9904650957059,396170,"[6] CENTRAL - OAHE DAM"]
[394127,"[7] EAST CENTRAL - HURON AP","SD","BEADLE",7,1280,0.78,1.28,20.0065322722403,394127,"[7] EAST CENTRAL - HURON AP"]
[395620,"[8] SOUTH CENTRAL - MISSION","SD","TODD",8,2587,0.9,1.41,20.833218869359701,395620,"[8] SOUTH CENTRAL - MISSION"]
[397667,"[9] SOUTHEAST - SIOUX FALLS AP","SD","MINNEHAHA",9,1428,0.85,1.41,23.9385825714504,397667,"[9] SOUTHEAST - SIOUX FALLS AP"]
[401656,"[1] EASTERN - CHATTANOOGA AP","TN","HAMILTON",1,671,1.1200000000000001,1.79,53.100084952017802,401656,"[1] EASTERN - CHATTANOOGA AP"]
[406170,"[2] CUMBERLAND PLATEAU - MONTEREY","TN","PUTNAM",2,1860,1.19,1.82,55.677855116592802,406170,"[2] CUMBERLAND PLATEAU - MONTEREY"]
[405954,"[4] WESTERN - MEMPHIS INTL AP","TN","SHELBY",4,254,1.3,2.02,51.595550015911897,405954,"[4] WESTERN - MEMPHIS INTL AP"]
[415411,"[1] HIGH PLAINS - LUBBOCK INTL AP","TX","LUBBOCK",1,3254,0.91,1.55,15.846552950694999,415411,"[1] HIGH PLAINS - LUBBOCK INTL AP"]
[419729,"[2] LOW ROLLING PLAINS - WICHITA FALLS MUNI AP","TX","WICHITA",2,1017,1.1299999999999999,1.86,27.474575436789099,419729,"[2] LOW ROLLING PLAINS - WICHITA FALLS MUNI AP"]
[413284,"[3] NORTH CENTRAL - FT WORTH MEACHAM FLD","TX","TARRANT",3,687,1.2,2.0299999999999998,28.5565763299326,413284,"[3] NORTH CENTRAL - FT WORTH MEACHAM FLD"]
[419665,"[4] EAST TEXAS - WHEELOCK","TX","ROBERTSON",4,420,1.36,2.2000000000000002,36.570095257539201,419665,"[4] EAST TEXAS - WHEELOCK"]
[418845,"[6] EDWARDS PLATEAU - TARPLEY","TX","BANDERA",6,1390,1.3,2.2200000000000002,31.3140267899214,418845,"[6] EDWARDS PLATEAU - TARPLEY"]
[410428,"[7] SOUTH CENTRAL - AUSTIN-CAMP MABRY","TX","TRAVIS",7,670,1.21,2.0099999999999998,32.328115308908998,410428,"[7] SOUTH CENTRAL - AUSTIN-CAMP MABRY"]
[419364,"[8] UPPER COAST - VICTORIA ASOS","TX","VICTORIA",8,115,1.32,2.2999999999999998,30.527551353145601,419364,"[8] UPPER COAST - VICTORIA ASOS"]
[414191,"[9] SOUTHERN - HINDES","TX","ATASCOSA",9,360,1.3,2.38,23.471994590512001,414191,"[9] SOUTHERN - HINDES"]
[411136,"[10] LOWER VALLEY - BROWNSVILLE INTL AP","TX","CAMERON",10,24,1.17,2.2799999999999998,25.696535723869601,411136,"[10] LOWER VALLEY - BROWNSVILLE INTL AP"]
[422090,"[1] WESTERN - DELTA","UT","MILLARD",1,4620,0.45,0.69,7.7265314937420602,422090,"[1] WESTERN - DELTA"]
[427516,"[2] DIXIE - ST GEORGE","UT","WASHINGTON",2,2770,0.55000000000000004,0.8,7.0894189431281402,427516,"[2] DIXIE - ST GEORGE"]
[426135,"[4] SOUTH CENTRAL - NEPHI","UT","JUAB",4,5128,0.5,0.75,14.277950103672,426135,"[4] SOUTH CENTRAL - NEPHI"]
[422385,"[5] NORTHERN MOUNTAINS - ECHO DAM","UT","SUMMIT",5,5470,0.5,0.7,13.990739928747599,422385,"[5] NORTHERN MOUNTAINS - ECHO DAM"]
[427395,"[6] UINTA BASIN - ROOSEVELT RADIO","UT","UINTAH",6,5014,0.46,0.7,6.7876993667982104,427395,"[6] UINTA BASIN - ROOSEVELT RADIO"]
[420738,"[7] SOUTHEAST - BLANDING","UT","SAN JUAN",7,6032,0.57999999999999996,0.9,11.5553098389921,420738,"[7] SOUTHEAST - BLANDING"]
[431565,"[1] NORTHEASTERN - CORINTH","VT","ORANGE",1,1180,0.8,1.3,37.774771432241998,431565,"[1] NORTHEASTERN - CORINTH"]
[431081,"[2] WESTERN - BURLINGTON WSO AP","VT","CHITTENDEN",2,330,0.69,1.1000000000000001,34.507930001895701,431081,"[2] WESTERN - BURLINGTON WSO AP"]
[438556,"[3] SOUTHEASTERN - UNION VILLAGE DAM","VT","ORANGE",3,460,0.77,1.26,34.330441949660802,438556,"[3] SOUTHEASTERN - UNION VILLAGE DAM"]
[446139,"[1] TIDEWATER - NORFOLK INTL AP","VA","NORFOLK (CITY)",1,30,1.01,1.76,43.905093954286102,446139,"[1] TIDEWATER - NORFOLK INTL AP"]
[447201,"[2] EASTERN PIEDMONT - RICHMOND INTL AP","VA","HENRICO",2,164,1.01,1.69,43.4489681759379,447201,"[2] EASTERN PIEDMONT - RICHMOND INTL AP"]
[445120,"[3] WESTERN PIEDMONT - LYNCHBURG INTL AP","VA","CAMPBELL",3,940,0.93,1.55,40.629648451289398,445120,"[3] WESTERN PIEDMONT - LYNCHBURG INTL AP"]
[447285,"[5] CENTRAL MOUNTAIN - ROANOKE INTL AP","VA","ROANOKE",5,1175,0.93,1.5,40.185245343366098,447285,"[5] CENTRAL MOUNTAIN - ROANOKE INTL AP"]
[448547,"[6] SOUTHWESTERN MOUNTAIN - TROUT DALE 3 SSE","VA","GRAYSON",6,2839,0.9,1.44,45.379783484298997,448547,"[6] SOUTHWESTERN MOUNTAIN - TROUT DALE 3 SSE"]
[456858,"[1] WEST OLYMPIC COAST - QUILLAYUTE AP","WA","CLALLAM",1,185,1.2,1.97,101.875746785928,456858,"[1] WEST OLYMPIC COAST - QUILLAYUTE AP"]
[456678,"[2] NE OLYMPIC SAN JUAN - PORT TOWNSEND","WA","JEFFERSON",2,100,0.46,0.72,22.329913082110501,456678,"[2] NE OLYMPIC SAN JUAN - PORT TOWNSEND"]
[456114,"[3] PUGET SOUND LOWLANDS - OLYMPIA AP","WA","THURSTON",3,188,0.79,1.27,47.935123955581297,456114,"[3] PUGET SOUND LOWLANDS - OLYMPIA AP"]
[453357,"[4] E OLYMPIC CASCADE FOOTHILLS - GREENWATER","WA","PIERCE",4,1730,0.79,1.31,52.6172996760261,453357,"[4] E OLYMPIC CASCADE FOOTHILLS - GREENWATER"]
[458009,"[5] CASCADE MOUNTAINS WEST - STAMPEDE PASS","WA","KITTITAS",5,3959,1.07,1.8,80.295464388292601,458009,"[5] CASCADE MOUNTAINS WEST - STAMPEDE PASS"]
[454849,"[6] EAST SLOPE CASCADES - LUCERNE 1 N","WA","CHELAN",6,1200,0.68,1.1599999999999999,26.7007457613654,454849,"[6] EAST SLOPE CASCADES - LUCERNE 1 N"]
[453515,"[7] OKANOGAN BIG BEND - HARRINGTON 1 NW","WA","LINCOLN",7,2160,0.5,0.66,12.6718913917199,453515,"[7] OKANOGAN BIG BEND - HARRINGTON 1 NW"]
[458207,"[8] CENTRAL BASIN - SUNNYSIDE","WA","YAKIMA",8,747,0.4,0.6,7.55094907226069,458207,"[8] CENTRAL BASIN - SUNNYSIDE"]
[457938,"[9] NORTHEASTERN - SPOKANE INTL AP","WA","SPOKANE",9,2353,0.45,0.66,16.530656403472101,457938,"[9] NORTHEASTERN - SPOKANE INTL AP"]
[456789,"[10] PALOUSE BLUE MOUNTAINS - PULLMAN 2 NW","WA","WHITMAN",10,2545,0.51,0.8,21.358156201380201,456789,"[10] PALOUSE BLUE MOUNTAINS - PULLMAN 2 NW"]
[466859,"[1] NORTHWESTERN - PARKERSBURG","WV","WOOD",1,620,0.78,1.18,37.351581709645899,466859,"[1] NORTHWESTERN - PARKERSBURG"]
[465002,"[2] NORTH CENTRAL - LAKE LYNN","WV","MONONGALIA",2,900,0.75,1.2,38.442708706542597,465002,"[2] NORTH CENTRAL - LAKE LYNN"]
[461570,"[3] SOUTHWESTERN - CHARLESTON YEAGER AP","WV","KANAWHA",3,910,0.79,1.24,43.018240335892202,461570,"[3] SOUTHWESTERN - CHARLESTON YEAGER AP"]
[462718,"[4] CENTRAL - ELKINS RANDOLPH CY AP","WV","RANDOLPH",4,1979,0.72,1.1200000000000001,44.2715463535068,462718,"[4] CENTRAL - ELKINS RANDOLPH CY AP"]
[469011,"[5] SOUTHERN - UNION 3 SSE","WV","MONROE",5,2110,0.8,1.2,35.661147108145798,469011,"[5] SOUTHERN - UNION 3 SSE"]
[465739,"[6] NORTHEASTERN - MATHIAS","WV","HARDY",6,1540,0.8,1.3,33.618995389482002,465739,"[6] NORTHEASTERN - MATHIAS"]
[470349,"[1] NORTHWEST - ASHLAND EXP FARM","WI","BAYFIELD",1,650,0.8,1.34,28.897529369882601,470349,"[1] NORTHWEST - ASHLAND EXP FARM"]
[476939,"[2] NORTH CENTRAL - RAINBOW RSVR TOMAHAWK","WI","ONEIDA",2,1600,0.74,1.2,27.939458291180099,476939,"[2] NORTH CENTRAL - RAINBOW RSVR TOMAHAWK"]
[476510,"[3] NORTHEAST - PESHTIGO","WI","MARINETTE",3,600,0.8,1.3,28.675948882305999,476510,"[3] NORTHEAST - PESHTIGO"]
[475948,"[4] WEST CENTRAL - NEW RICHMOND","WI","ST. CROIX",4,1000,0.9,1.5,29.695553704059499,475948,"[4] WEST CENTRAL - NEW RICHMOND"]
[471676,"[5] CENTRAL - CLINTONVILLE","WI","WAUPACA",5,802,0.82,1.39,30.078624765378301,471676,"[5] CENTRAL - CLINTONVILLE"]
[473269,"[6] EAST CENTRAL - GREEN BAY A S INTL AP","WI","BROWN",6,687,0.74,1.18,27.803830258957099,473269,"[6] EAST CENTRAL - GREEN BAY A S INTL AP"]
[474546,"[7] SOUTHWEST - LANCASTER 4 WSW","WI","GRANT",7,1040,0.9,1.5,32.669855495037403,474546,"[7] SOUTHWEST - LANCASTER 4 WSW"]
[474961,"[8] SOUTH CENTRAL - MADISON DANE CO AP","WI","DANE",8,866,0.83,1.42,32.144774908267202,474961,"[8] SOUTH CENTRAL - MADISON DANE CO AP"]
[475479,"[9] SOUTHEAST - MILWAUKEE MITCHELL AP","WI","MILWAUKEE",9,670,0.79,1.33,31.8833229229881,475479,"[9] SOUTHEAST - MILWAUKEE MITCHELL AP"]
[485345,"[1] YELLOWSTONE DRAINAGE - LAKE YELLOWSTONE","WY","TETON",1,7870,0.43,0.7,20.181575279931401,485345,"[1] YELLOWSTONE DRAINAGE - LAKE YELLOWSTONE"]
[486440,"[2] SNAKE DRAINAGE - MORAN 5 WNW","WY","TETON",2,6798,0.5,0.77,23.548843404156798,486440,"[2] SNAKE DRAINAGE - MORAN 5 WNW"]
[487845,"[3] GREEN AND BEAR DRAINAGE - ROCK SPRINGS AP","WY","SWEETWATER",3,6741,0.4,0.6,4.1800803811740899,487845,"[3] GREEN AND BEAR DRAINAGE - ROCK SPRINGS AP"]
[488852,"[4] BIG HORN - TENSLEEP 4NE","WY","WASHAKIE",4,4815,0.6,0.9,12.926461073342701,488852,"[4] BIG HORN - TENSLEEP 4NE"]
[488155,"[5] POWDER, LITTLE MISSOURI, TONGU - SHERIDAN AP","WY","SHERIDAN",5,3945,0.52,0.83,14.251251158802299,488155,"[5] POWDER, LITTLE MISSOURI, TONGU - SHERIDAN AP"]
[487270,"[6] BELLE FOURCHE DRAINAGE - PINE TREE 9 NE","WY","CAMPBELL",6,5111,0.6,1.1100000000000001,11.5241241993683,487270,"[6] BELLE FOURCHE DRAINAGE - PINE TREE 9 NE"]
[486660,"[7] CHEYENNE & NIOBRARA DRAINAGE - NEWCASTLE","WY","WESTON",7,4315,0.6,1,15.0204678524871,486660,"[7] CHEYENNE & NIOBRARA DRAINAGE - NEWCASTLE"]
[481570,"[8] LOWER PLATTE - CASPER WSCMO","WY","NATRONA",8,5338,0.45,0.8,11.9083259789791,481570,"[8] LOWER PLATTE - CASPER WSCMO"]
[485390,"[9] WIND RIVER - LANDER AP","WY","FREMONT",9,5557,0.6,0.97,12.895921548627401,485390,"[9] WIND RIVER - LANDER AP"]
[487105,"[10] UPPER PLATTE - PATHFINDER DAM","WY","NATRONA",10,5918,0.5,0.75,9.2125112997508793,487105,"[10] UPPER PLATTE - PATHFINDER DAM"]
[null,"[1]   - ANNETTE WSO AP",null,null,null,null,null,null,null,null,"[1]   - ANNETTE WSO AP"]
[null,"[6]   - HILO INTL AP 87",null,null,null,null,null,null,null,null,"[6]   - HILO INTL AP 87"]
[null,"[1]   - SAN JUAN INTL AP",null,null,null,null,null,null,null,null,"[1]   - SAN JUAN INTL AP"]