{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SVAP2 Data Form","HUC8","Classification","macro"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":26,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SVAP2 Data Form","index":0,"n_rows":461,"n_cols":29,"rows_kept":461,"cut":false,"hidden":false,"merged":[[311,2,316,7],[311,8,316,14],[15,9,15,18],[13,14,13,18],[14,3,14,8],[14,9,14,18],[130,2,130,28],[152,2,153,28],[205,2,205,28],[318,2,318,28],[29,3,29,9],[29,16,29,27],[22,3,22,9],[23,3,23,9],[24,3,24,9],[26,3,26,9],[27,3,27,9],[27,10,27,12],[22,10,22,16],[23,10,23,16],[24,10,24,16],[26,10,26,16],[317,2,317,7],[317,8,317,14],[317,15,317,21],[317,22,317,28],[311,15,316,21],[311,22,316,28],[2,29,2,30],[53,12,53,17],[54,12,54,17],[57,12,57,17],[56,4,56,11],[56,12,56,17],[112,11,112,14],[22,18,22,21],[22,22,22,27],[55,12,55,17],[104,22,104,28],[109,2,110,28],[60,2,62,28],[91,15,91,19],[91,20,91,21],[91,22,91,25],[91,26,91,27],[92,2,103,7],[92,8,103,14],[92,15,103,21],[307,2,307,7],[307,8,307,13],[320,3,320,28],[325,16,325,18],[325,19,325,28],[326,3,326,12],[326,13,326,15],[326,16,326,18],[326,19,326,28],[323,3,323,12],[323,13,323,15],[323,16,323,18],[325,3,325,12],[325,13,325,15],[307,14,307,18],[307,19,307,23],[307,24,307,28],[310,15,310,19],[310,20,310,21],[310,22,310,25],[310,26,310,27],[303,20,303,21],[303,22,303,25],[303,26,303,27],[304,24,306,28],[303,15,303,19],[304,2,306,7],[304,8,306,13],[304,14,306,18],[304,19,306,23],[294,2,300,7],[294,8,300,14],[294,15,300,21],[294,22,300,28],[301,2,301,7],[301,8,301,14],[301,15,301,21],[301,22,301,28],[287,2,287,7],[287,8,287,13],[287,14,287,18],[287,19,287,23],[287,24,287,28],[293,15,293,19],[293,20,293,21],[293,22,293,25],[293,26,293,27],[279,15,279,19],[279,20,279,21],[279,22,279,25],[279,26,279,27],[280,2,286,7],[280,8,286,13],[280,14,286,18],[280,19,286,23],[280,24,286,28],[272,2,276,7],[272,8,276,13],[272,14,276,18],[272,19,276,23],[272,24,276,28],[277,2,277,7],[277,8,277,13],[277,14,277,18],[277,19,277,23],[277,24,277,28],[264,2,268,7],[264,8,268,14],[264,15,268,21],[264,22,268,28],[269,2,269,7],[269,8,269,14],[269,15,269,21],[269,22,269,28],[271,15,271,19],[271,20,271,21],[271,22,271,25],[271,26,271,27],[260,2,260,7],[260,8,260,14],[260,15,260,21],[260,22,260,28],[262,15,262,19],[262,20,262,21],[262,22,262,25],[262,26,262,27],[242,2,242,7],[242,8,242,14],[242,15,242,21],[242,22,242,28],[232,2,232,28],[243,2,243,28],[244,2,259,7],[244,8,259,14],[244,15,259,21],[244,22,259,28],[231,15,231,19],[231,20,231,21],[231,22,231,25],[231,26,231,27],[233,2,241,7],[233,8,241,14],[233,15,241,21],[233,22,241,28],[220,2,228,7],[220,8,228,14],[220,15,228,21],[220,22,228,28],[229,2,229,7],[229,8,229,14],[229,15,229,21],[229,22,229,28],[208,2,216,7],[208,8,216,14],[208,15,216,21],[208,22,216,28],[217,2,217,7],[217,8,217,14],[217,15,217,21],[217,22,217,28],[219,15,219,19],[219,20,219,21],[219,22,219,25],[219,26,219,27],[207,15,207,19],[207,20,207,21],[207,22,207,25],[207,26,207,27],[192,2,192,7],[192,8,192,14],[192,15,192,21],[192,22,192,28],[194,15,194,19],[194,20,194,21],[194,22,194,25],[194,26,194,27],[195,2,203,7],[195,8,203,14],[195,15,203,21],[195,22,203,28],[204,2,204,7],[204,8,204,14],[204,15,204,21],[204,22,204,28],[190,15,191,21],[190,22,191,28],[48,4,48,11],[129,2,129,28],[113,15,113,19],[113,20,113,21],[128,2,128,7],[112,15,112,19],[112,20,112,21],[112,22,112,25],[112,26,112,27],[114,2,127,7],[114,8,127,14],[114,15,127,21],[114,22,127,28],[128,8,128,14],[128,15,128,21],[128,22,128,28],[113,11,113,14],[92,22,103,28],[65,15,65,19],[322,3,322,12],[322,13,322,15],[322,16,322,18],[322,19,322,28],[104,2,104,7],[104,8,104,14],[104,15,104,21],[150,2,150,7],[150,8,150,13],[150,14,150,18],[150,19,150,23],[150,24,150,28],[156,15,156,19],[156,20,156,21],[156,22,156,25],[156,26,156,27],[155,2,156,10],[157,2,157,28],[158,2,162,7],[158,8,162,14],[158,15,162,21],[189,2,189,28],[190,2,191,7],[190,8,191,14],[55,4,55,11],[54,4,54,11],[137,8,149,13],[133,22,133,25],[134,22,134,25],[133,11,133,13],[134,11,134,13],[133,19,133,20],[134,19,134,20],[135,11,135,28],[137,14,149,18],[137,19,149,23],[137,24,149,28],[133,2,135,10],[133,26,133,27],[134,26,134,27],[137,2,149,7],[136,2,136,28],[65,20,65,21],[68,2,88,10],[66,2,67,10],[43,14,43,16],[44,14,44,16],[6,8,6,17],[8,2,8,7],[9,8,9,17],[8,8,8,17],[0,2,0,28],[1,2,1,28],[6,2,6,7],[4,2,4,7],[4,8,4,11],[4,20,4,21],[6,20,6,21],[4,22,4,26],[6,22,6,26],[43,4,43,13],[13,3,13,13],[15,3,15,8],[16,3,16,13],[18,3,18,13],[19,3,19,13],[19,14,19,18],[18,14,18,18],[16,14,16,18],[45,4,45,13],[38,4,38,28],[42,4,42,28],[32,2,35,28],[45,14,45,17],[65,22,65,25],[330,3,330,12],[330,13,330,15],[330,16,330,18],[330,19,330,28],[327,3,327,12],[327,13,327,15],[327,16,327,18],[327,19,327,28],[328,3,328,12],[328,13,328,15],[328,16,328,18],[328,19,328,28],[329,3,329,12],[329,13,329,15],[329,16,329,18],[329,19,329,28],[66,11,66,28],[133,28,134,28],[371,3,371,28],[344,3,344,12],[344,13,344,15],[344,16,344,18],[346,13,346,14],[347,13,347,14],[348,13,348,14],[364,3,364,5],[364,6,364,10],[365,3,365,5],[349,13,349,14],[350,13,350,14],[364,11,364,28],[365,11,365,28],[366,11,366,28],[367,11,367,28],[368,11,368,28],[365,6,365,10],[366,3,366,5],[366,6,366,10],[367,3,367,5],[367,6,367,10],[359,3,359,28],[363,3,363,28],[334,3,334,12],[334,13,334,15],[334,16,334,18],[334,19,334,28],[331,3,331,12],[331,13,331,15],[331,16,331,18],[331,19,331,28],[332,3,332,12],[332,13,332,15],[332,16,332,18],[332,19,332,28],[341,3,341,12],[341,13,341,15],[341,16,341,18],[342,3,342,12],[342,13,342,15],[342,16,342,18],[337,3,337,12],[357,3,358,28],[360,3,361,28],[339,3,339,28],[337,16,337,18],[337,19,337,28],[338,3,338,12],[338,13,338,15],[338,16,338,18],[338,19,338,28],[335,13,335,15],[335,16,335,18],[335,19,335,28],[336,3,336,12],[336,13,336,15],[336,16,336,18],[336,19,336,28],[78,31,79,31],[82,11,82,28],[81,11,81,16],[81,17,81,22],[81,23,81,28],[89,11,89,16],[89,17,89,22],[89,23,89,28],[67,11,80,16],[67,17,80,22],[324,3,324,12],[324,13,324,15],[324,16,324,18],[324,19,324,28],[179,26,179,27],[133,21,134,21],[333,19,333,28],[368,3,368,5],[368,6,368,10],[49,4,49,11],[49,12,49,16],[346,20,350,28],[353,3,353,28],[356,3,356,28],[67,23,80,28],[83,11,88,16],[83,17,88,22],[83,23,88,28],[89,2,89,10],[106,2,108,28],[337,13,337,15],[333,3,333,12],[354,3,355,28],[323,19,323,28],[333,13,333,15],[333,16,333,18],[131,2,131,28],[179,15,179,19],[179,20,179,21],[179,22,179,25],[335,3,335,12],[164,2,164,28],[165,2,173,7],[165,8,173,14],[165,15,173,21],[165,22,173,28],[174,2,174,7],[174,8,174,14],[174,15,174,21],[174,22,174,28],[50,12,50,16],[48,12,48,16],[188,8,188,14],[188,15,188,21],[188,22,188,28],[180,2,180,28],[181,2,187,7],[181,8,187,14],[181,15,187,21],[181,22,187,28],[188,2,188,7],[158,22,162,28],[163,2,163,7],[177,2,177,28],[155,12,155,14],[155,15,155,19],[155,20,155,21],[155,22,155,25],[155,26,155,27],[156,12,156,14],[176,2,176,28],[163,8,163,14],[163,15,163,21],[163,22,163,28],[263,2,263,28],[289,2,291,28],[112,29,113,29],[18,22,18,23],[44,4,44,13],[44,17,44,28],[52,4,52,28],[65,26,65,27],[46,14,46,17],[112,28,113,28],[112,2,112,10],[113,2,113,10],[45,18,45,28],[46,18,46,28],[113,22,113,25],[113,26,113,27],[48,17,48,28],[39,18,39,28],[40,4,40,17],[39,4,39,17],[40,18,40,28],[53,4,53,11],[57,4,57,11],[50,4,50,11]]}
[null,null,"Stream Visual Assessment Protocol version 2 (SVAP2) "]
[null,null,"Colorado Data Form"]
[]
[]
[null,null,"Site Assessment Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"County:",null,null,null,null,null,null,", CO"]
[]
[null,null," Name of Land Owner:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tract #:"]
[]
[null,null,"Team Member Names:"]
[]
[]
[null,null,"PRELIMINARY ASSESSMENT"]
[null,null,"Watershed Description"]
[null,null,null,"Watershed Hydrologic Code (8-digit HUC):"]
[null,null,null,"Watershed Basin: ",null,null,null,null,null,{"$f":"IF(ISBLANK(O14),\"\",VLOOKUP(O14,'HUC8'!E2:J93,4,FALSE))","v":""}]
[null,null,null,"Watershed SubBasin: ",null,null,null,null,null,{"$f":"IF(ISBLANK(O14),\"\",VLOOKUP(O14,'HUC8'!E2:J93,5,FALSE))","v":""}]
[null,null,null,"Watershed Drainage Area (square miles): ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(O14),\"\",VLOOKUP(O14,'HUC8'!E2:J93,6,FALSE))","v":""}]
[]
[null,null,null,"Rapid Watershed Assessement Available?"]
[null,null,null,"Water Quality Assessment Report Avail?"]
[]
[null,null,"Stream Description"]
[null,null,null,"Stream Name/Identifier:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tributary to:"]
[null,null,null,"Stream Type:"]
[null,null,null,"Stream Classification:"]
[]
[null,null,null,"Nearest Stream Gage (ID):"]
[null,null,null,"Mean Daily Discharge:",null,null,null,null,null,null,null,null,null,"(ft3/s)",null,"Attach the hydrograph."]
[]
[null,null,null,"Reference Site Available? ",null,null,null,null,null,null,"Yes",null,", No",null,null,"ID#:"]
[]
[null,null,"FIELD ASSESSMENT"]
[null,null,"Field identify the stream reach to be assessed (a section of stream which has consistent characteristics). Ideally, the stream reach to be assessed should equal 12 times the bankfull channel width; unless limited by property boundaries or there is a change in characteristics. Identify the stream reach on a map."]
[]
[]
[]
[]
[null,null,null,"A. Field Data "]
[null,null,null,null,"Weather Conditions: Avoid conducting the assessment during and 5 days after a precipitation event."]
[null,null,null,null,"Day of assessment (temp., precip., cloud cover, wind):"]
[null,null,null,null,"Two-five days prior (avg. day temp. and precipitation):"]
[]
[null,null,null,null,"Channel: Ideally, conduct the assessment during base flow (low water) when element are more visible.  "]
[null,null,null,null,"Average Bankfull Channel Width (ft):"]
[null,null,null,null,"Assessment Stream Reach Length (ft):"]
[null,null,null,null,"Reach Location (lat/long or UTM):",null,null,null,null,null,null,null,null,null,"downstream:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"upstream:"]
[]
[null,null,null,null,"Streambed Slope Gradient (%):",null,null,null,null,null,null,null,null,null,null,null,null," vertical rise over horizontal run (ft/ft x 100 = % gradient)"]
[null,null,null,null,"Warm or Cold Water Stream?"]
[null,null,null,null,"Streambed Dominate Substrate:"]
[]
[null,null,null,null,"Riparian/Floodplain: Provide an average of the entire floodplain associated to the stream reach (both sides)."]
[null,null,null,null,"Active Floodplain Width (ft):"]
[null,null,null,null,"Riparian Zone Width(ft):"]
[null,null,null,null,"Dominate Riparian Cover:"]
[null,null,null,null,"Avg. Riparian Height (ft):"]
[null,null,null,null,"Floodplain Wetlands (ac):"]
[]
[]
[null,null,"Element Scores.  If an element does not apply leave it blank. Assign a score based on conditions observed within the assessment reach unless otherwise indicated. If the condition fits the description of more than one score range, then score with the lower value or use decimals (ex. score 6.7)."]
[]
[]
[]
[]
[null,null,"Element 1 - Channel Condition",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"Natural, stable channel with established bank vegetation",null,null,null,null,null,null,null,null,"     If channel is incising (appears to be downcutting or degrading):"]
[null,null,null,null,null,null,null,null,null,null,null,"▪Evidence of past incision and  some recovery; some bank erosion possible,                               ▪Active channel and flood plain are connected in most areas, inundated seasonally,                      ▪Streambanks may be low or appear to be steepening,                   ▪Top of point bars are below active floodplain and regeneration of preferred species is occurring.                                                                        Stage I: Score 8\nStage V: Score 7–8\nStage IV: Score 6                    ",null,null,null,null,null,"▪Active incision evident; plants are stressed, dying or falling in channel,                                   ▪Active channel appears to be disconnected from the floodplain, with infrequent or no inundation,                                 ▪Steep banks, bank failures evident or imminent,                    ▪Point bars located adjacent to steep banks.                          Stage IV: Score 5\nStage III: Score 4\nStage II: Score 3",null,null,null,null,null,"▪Headcuts or surface cracks on banks; active incision; vegetation very sparse,                                      ▪Little or no connection between floodplain and stream channel and no inundation,                   ▪Steep streambanks and failures prominent,                            ▪Point bars, if present, located adjacent to steep banks.                             Stage II or III, score 2 to 0 depending on severity"]
[null,null,"▪No discernible signs of incision (such as vertical banks) or aggradation (such as very shallow multiple channels),                      ▪Streambanks low with few or no bank failures,\n▪Active channel and floodplain are connected throughout reach and flooded at natural intervals,\nStage I: Score 10\nStage V: Score 9 (if terrace is visible)                                                              "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"8          7          6",null,null,null,null,null,"5          4          3",null,null,null,null,null,"2          1          0"]
[null,null,null,null,null,null,null,null,null,null,null,"     If channel is aggrading (appears to be filling in and is relatively wide and shallow):"]
[null,null,null,null,null,null,null,null,null,null,null,"▪Minimal lateral migration and bank erosion,                                 ▪A few shallow places in reach, due to sediment deposits,                               ▪Minimal bar formation (less than 3).",null,null,null,null,null,"▪Moderate lateral migration and bank erosion,                         ▪Deposition of sediments causing channel to be very shallow in places,                                              ▪3–4 bars in channel.",null,null,null,null,null,"▪Severe lateral channel migration and bank erosion,                                   ▪Deposition of sediments causing channel to be very shallow in reach,                                         ▪Braided channels (5 or more bars in channel)."]
[]
[]
[]
[]
[]
[null,null,"10          9",null,null,null,null,null,null,null,null,"8          7          6",null,null,null,null,null,"5          4          3",null,null,null,null,null,"2          1          0"]
[]
[null,null,"Element 2 - Hydrologic Alteration",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"▪Bankfull or higher flows occur according to the flow regime that is characteristic of the site, (generally every 1 to 2 years), and                                                         No dams, dikes, or development in the flood plain1], or water control structures are present, and natural flow regime2] prevails.",null,null,null,null,null,"▪Bankfull or higher flows occur less often than the local natural flow regime (generally every 3 to 5 yrs),                    ▪Developments in the flood plain, water withdrawals, flow augmentation, or water control structures may be present, but do not significantly alter the natural flow regime2].",null,null,null,null,null,null,"▪Bankfull or higher flows occur less often than the local natural flow regime (generally every 6 to 10 yrs),                         ▪Developments in the flood plain, stream water withdrawals, flow augmentation, or water control structures alter the natural flow regime2].",null,null,null,null,null,null,"▪Bankfull or higher flows rarely occur,                                ▪Stream water withdrawals completely dewater channel; and/or flow augmentation, stormwater, or urban runoff discharges directly into stream and severely alters the natural flow regime2]. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"10          9",null,null,null,null,null,"8          7          6",null,null,null,null,null,null,"5          4          3",null,null,null,null,null,null,"2          1          0"]
[]
[null,null,"1] Development in the floodplain refers to transportation infrastructure (roads, railways), commercial or residential development, land conversion for agriculture or other uses, and similar activities that alter the timing, concentration, and delivery of precipitation as surface runoff or subsurface drainage."]
[]
[]
[null,null,"2] As used here, “natural flow regime” refers to streamflow patterns unaffected by water withdrawals, floodplain development, agricultural or wastewater effluents, and practices that change surface runoff (dikes and levees) or subsurface drainage."]
[]
[]
[null,null,"Element 3 - Bank Condition",null,null,null,null,null,null,null,null,"Right Bank:",null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,null,null,null,null,null,null,null,null,null,"Left Bank:",null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"Banks are stable:                   ▪ >75% protection of banks by deep binding plant roots, wood, vegetation and/or rock 1],                                ▪No erosion or bank failures, or effects are minimal (<5% of the bank reach affected),                       ▪No man-made structures present on the banks,                                           \n▪Recreational use and/or grazing do not negatively impact bank condition.",null,null,null,null,null,"Banks moderately stable:         ▪50-75% protection of banks by roots of natural wood, vegetation and/or rock 1],     ▪Small or infrequent areas with erosion or bank failures often \"healed over\" (5-25% of the bank reach affected),                   ▪Limited number of structures present on bank,                              ▪Recreational use and/or grazing do not negatively impact bank condition.",null,null,null,null,null,null,"Banks moderately unstable:                                   ▪25-50% protection of banks by roots of natural wood, vegetation and/or rock 1],       ▪Small or infrequent areas with erosion or bank failures often \"healed over\" (5-25% of the bank reach affected),                                   ▪Structures cover more than half of reach or entire bank,                           ▪Recreational and/or livestock use are contributing to bank instability.",null,null,null,null,null,null,"Banks are unstable:                           ▪<25% protection of banks by roots of natural wood, vegetation and/or rock,              ▪25-50% of the banks within the reach have active bank erosion or bank failures, or have high erosion potential,                                   ▪Structures dominate banks,                                              ▪Recreational and/or livestock use are contributing to bank instability."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"10          9",null,null,null,null,null,"8          7          6",null,null,null,null,null,null,"5          4          3",null,null,null,null,null,null,"2          1          0"]
[null,null,"1] Natural wood and rock does not mean riprap, gabions, log cribs, or other fabricated revetments."]
[null,null,"2] Bank failure refers to a section of streambank that collapses and falls into the stream, usually due to slope instability."]
[null,null,"Note: Final Element Score = left bank score plus right bank score divided by 2."]
[]
[null,null,"Element 4 - Riparian Quantity",null,null,null,null,null,null,null,null,"Right Bank:",null,null,null,null,null,null,"Bench Mark Score:",null,null,{"$f":"IF(ISNUMBER(T134),IF(ISNUMBER(T135),IF(T134<5,IF(T135>6,\"-2\",\"\"),IF(T134>6,IF(T135<5,\"-2\",\"\"))),\"\"),\"\")","v":""},"Planned Score:",null,null,null,null,null,{"$f":"IF(ISNUMBER(AA134),IF(ISNUMBER(AA135),IF(AA134<5,IF(AA135>6,\"-2\",\"\"),IF(AA134>6,IF(AA135<5,\"-2\",\"\"))),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Left Bank:",null,null,null,null,null,null,"Bench Mark Score:",null,null,null,"Planned Score:"]
[null,null,null,null,null,null,null,null,null,null,null,"If one bank is ≥7 and the other is ≤4, then 2 points will be subtracted from final score."]
[null,null,"Scores should represent the entire stream's riparian area within the property."]
[null,null,"Natural plant community (woody and herbacous) covers 90-100% of the  entire active floodplain, along the stream assessment reach, and is primarily contiguous.",null,null,null,null,null,"Natural plant community covers 75-90% of the  entire active floodplain, along the stream assessment reach, and is generally contiguous:              ▪Streamside vegetation gaps1] do not exceed 10% of the assessment reach length.",null,null,null,null,null,"Natural plant community covers 50-75% of the entire active floodplain, along the stream assessment reach.                    ▪Vegetation gaps1] do not exceed 30% of the assessment reach length.",null,null,null,null,"▪Natural plant community extends at least 1/3 of the bankfull width,             or                                  >25% of active floodplain along the stream assessment reach.                         ▪Vegetation gaps1] may exceed 30% of the assessment reach length.                            ",null,null,null,null,"▪Natural plant community extends less than 1/3 of the bankfull width,              or                               <25% of active floodplain along the stream assessment reach.                   ▪Vegetation gaps1] may exceed 30% of the assessment reach length. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"10          9",null,null,null,null,null,"8          7",null,null,null,null,null,"6          5",null,null,null,null,"4         3         2",null,null,null,null,"1          0"]
[]
[null,null,"1] Vegetation Gaps: lengths of streamside with no natural vegetation ecologically suitable for the site and/or vegetation is at a density uncharacteristic of the plant community. Note: Final Element Score = left bank score plus right bank score divided by 2."]
[]
[]
[null,null,"Element 5 - Riparian Quality",null,null,null,null,null,null,null,null,null,"Right Bank:",null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Left Bank:",null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"     Natural plant community is dominated by Herbaceous Riparian Plants. "]
[null,null,"Natural and diverse composition, density and appropriate age structure:                              ▪ 0-5% undesirable plant species present.            ",null,null,null,null,null,"Natural and diverse composition, density and appropriate age structure:               ▪ 5-25% undesirable plant species present. ",null,null,null,null,null,null,"Natural plant community compromised:                            ▪ 25-50% undesirable plant species present.",null,null,null,null,null,null,"Natural plant community compromised:                              ▪ >50% undesirable plant species present."]
[]
[]
[]
[]
[null,null,"10          9",null,null,null,null,null,"8          7          6",null,null,null,null,null,null,"5          4          3",null,null,null,null,null,null,"2          1          0"]
[null,null,"     Natural plant community is dominated by Woody Riparian Plants. "]
[null,null,"Natural and diverse composition, density and appropriate age structure:  ▪ 0-5% undesirable plant species present,\n▪Regeneration of native, desirable trees and shrubs is appropriate for the site.                ",null,null,null,null,null,"Natural and diverse composition, density and appropriate age structure:                                                        ▪ 5-25% undesirable plant species present, \n▪Adequate regeneration of  native, desirable trees and shrubs (5-10% composition of saplings/seedlings).",null,null,null,null,null,null,"Natural plant community compromised:                                                                   ▪ 25-50% undesirable plant species present, \n▪Lmited regeneration of  native, desirable trees and shrubs (2-5% composition of saplings/seedlings).",null,null,null,null,null,null,"Natural plant community compromised:                                                               ▪ >50% undesirable plant species present,\n▪Little to no regeneration of  native, desirable trees and shrubs (0-2% composition of saplings/seedlings)."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"10          9",null,null,null,null,null,"8          7          6",null,null,null,null,null,null,"5          4          3",null,null,null,null,null,null,"2          1          0"]
[]
[null,null,"Undesirable riparian species generally include noxious and invasive species."]
[null,null,"Notes: Element Score  = left bank score plus right bank score divided by 2."]
[]
[null,null,"Element 6 - Canopy Cover / Stream Shading",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"     Natural plant community is dominated by Herbaceous Riparian Plants. "]
[null,null,">75% of the linear streambank, within the stream reach, has the water edge shaded by overhanging herbaceous vegetation or other natural features such as logs.",null,null,null,null,null,"75–50% of the linear streambank, within the stream reach, has the water edge shaded by overhanging herbaceous vegetation or other natural features such as logs.",null,null,null,null,null,null,"49–20% of the linear streambank, within the stream reach, has the water edge shaded by overhanging herbaceous vegetation or other natural features such as logs.",null,null,null,null,null,null,"<20% of the linear streambank, within the stream reach, has the water edge shaded by overhanging herbaceous vegetation or other natural features such as logs."]
[]
[]
[]
[]
[]
[]
[null,null,"10          9",null,null,null,null,null,"8          7          6",null,null,null,null,null,null,"5          4          3",null,null,null,null,null,null,"2          1          0"]
[null,null,"     Natural plant community is dominated by Woody Riparian Plants. "]
[null,null," >75% of water surface is shaded within the reach.",null,null,null,null,null,"50–75% of water surface is shaded within the stream reach.",null,null,null,null,null,null,"49–20% of water surface is shaded within the stream reach.",null,null,null,null,null,null,"<20% of water surface is shaded within the stream reach. "]
[]
[null,null,"10          9",null,null,null,null,null,"8          7          6",null,null,null,null,null,null,"5          4          3",null,null,null,null,null,null,"2          1          0"]
[]
[null,null,"Element 7 - Water Appearance",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"Very clear or clarity is appropriate to the site: submerged features in stream (rocks, wood) are visible at depths of 3 to 6 feet,                                             ▪No motor oil sheen on surface or evidence of metal precipitates.",null,null,null,null,null,"Slightly turbid, especially 2-5 days after a storm event, but clears afterwards:                                      submerged features in stream (rocks, wood) are visible at depths of 1.5 to 3 feet,                                             ▪No motor oil sheen on surface or evidence of metal precipitates.",null,null,null,null,null,null,"Turbid most of the time: submerged features in stream are visible at depths of only .5 to 1.5 feet,                             and/or                                   ▪Motor oil sheen is present on water surface, and/or                                     ▪There is evidence of metal precipitates in stream.",null,null,null,null,null,null,"Very turbid most of the time:                                          submerged features in stream are visible only within .5 feet below surface,                                  and/or                                    ▪Motor oil sheen is present on the water surface or slackwater."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"10          9          8",null,null,null,null,null,"7          6          5",null,null,null,null,null,null,"4          3          2",null,null,null,null,null,null,"1          0"]
[null,null,"If the stream is not deep enough to evaluate using this approach (<3 ft deep), then score based on water appearance of the reference site."]
[]
[null,null,"Element 8 - Nutrient Enrichment",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"Slight to no algal growth present along the entire reach; clear water.",null,null,null,null,null,"Moderate algal growth on substrates (i.e. streambed, submerged rocks, logs),               ▪fairly clear or slightly greenish water.                          ",null,null,null,null,null,null,"Abundant algal growth on substrates, especially during warmer months and/or: ▪greenish water particularly in slow sections,                                                     ▪Slight odor of ammonia or rotten eggs, and/or                        ▪Sporadic growth of aquatic plants within slack water.",null,null,null,null,null,null,"Thick algal mats dominating stream, and/or                           ▪Pea green water color, and/or                                       ▪Strong odor of ammonia or rotten eggs and/or                                 ▪Dense stands of aquatic plants widely dispersed."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"10          9          8",null,null,null,null,null,"7          6          5",null,null,null,null,null,null,"4          3          2",null,null,null,null,null,null,"1          0"]
[]
[null,null,"Element 9 - Manure or Human Waste Present",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"▪Livestock do not have access to stream,                             ▪No pipes or concentrated flows discharging animal waste or sewage directly into stream or it's floodplain.",null,null,null,null,null,"▪Livestock access to the stream is controlled and/or limited to small watering or crossing areas,                                             ▪No pipes or concentrated flows discharging animal waste or sewage directly into stream or it's floodplain.",null,null,null,null,null,null,"▪Livestock have unlimited access to stream during some portion of the year, and/or                                    ▪Manure is noticeable in stream, and/or                              ▪Pipes or concentrated flows discharge treated animal waste or sewage directly into stream.",null,null,null,null,null,null,"▪Livestock have unlimited access to stream for a majority of the year, and/or                                            ▪Manure is noticeable in stream and/or                                    ▪Pipes or concentrated flows discharge untreated animal waste or sewage directly into stream."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"10          9          8",null,null,null,null,null,"7          6          5",null,null,null,null,null,null,"4          3          2",null,null,null,null,null,null,"1          0"]
[]
[null,null,"Element 10 - Pools",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"      Low-gradient streams (<2% slope) "]
[null,null,"▪More than two deep pools (>2.5 ft) separated by riffles, each with greater than 30% of the pool bottom obscured by depth, wood, or other cover,                         ▪Shallow pools also present.",null,null,null,null,null,"▪One or two deep pools separated by riffles, each with greater than 30% of the pool bottom obscured by depth wood, or other cover,                          ▪At least one shallow pool present.",null,null,null,null,null,null,"▪Pools present but shallow (<2 times maximum depth of the upstream riffle),                          ▪Only 10–30% of pool bottoms are obscured due to depth or wood cover.",null,null,null,null,null,null,"▪Pools absent, but some slow water habitat is available                   ▪No cover discernible or                    ▪Reach is dominated by shallow continuous pools or slow water."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"10          9",null,null,null,null,null,"8          7          6",null,null,null,null,null,null,"5          4          3",null,null,null,null,null,null,"2          1          0"]
[null,null,"      high-gradient streams (>2% slope) "]
[null,null,"▪More than three deep pools separated by boulders or wood, each with greater than 30% of the pool bottom obscured by depth, wood, or other cover.                                     For small streams, pool bottoms may not be completely obscured by depth, but pools are deep enough to provide adequate cover for resident fish,                     ▪Shallow pools also present.",null,null,null,null,null,"▪Two to three deep pools, each with greater than 30% of the pool bottom obscured by depth wood or other cover; at least one shallow pool present.                                           For small streams, pool bottoms may not be completely obscured by depth, but pools are deep enough to provide some cover for resident fish.                                  ▪At least one shallow pool also present.",null,null,null,null,null,null,"▪Pools present but relatively shallow, with only 10–30% of pool bottoms obscured by depth or wood cover.                             For small streams, pool bottoms may not be completely obscured by depth, but pools are deep enough to provide minimal cover for resident fish. \n▪No shallow pools present.",null,null,null,null,null,null,"▪Pools absent."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"10          9",null,null,null,null,null,"8          7          6",null,null,null,null,null,null,"5          4          3",null,null,null,null,null,null,"2          1          0"]
[]
[null,null,"Element 11 - Barriers to Species Movement ",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"When addressing this element, assess the entire stream length on the landowner’s property."]
[null,null,"No artificial barriers that prohibit movement of aquatic organisms during any time of the year.",null,null,null,null,null,"Physical structures, water withdrawals and/or water quality seasonally restrict movement of aquatic species.",null,null,null,null,null,null,"Physical structures, water withdrawals and/or water quality restrict movement of aquatic species throughout the year.",null,null,null,null,null,null,"Physical structures, water withdrawals and/or water quality prohibit movement of aquatic species."]
[]
[]
[]
[]
[null,null,10,null,null,null,null,null,"9          8          7",null,null,null,null,null,null,"6        5        4       3",null,null,null,null,null,null,"2         1          0"]
[]
[null,null,"Element 12 - Fish Habitat Complexity",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"10 or more habitat features1] available, at least one of which is considered optimal in reference sites.",null,null,null,null,null,"8 to 9 habitat features available.",null,null,null,null,null,"6 to 7 habitat features available.",null,null,null,null,"4 to 5 habitat features available.",null,null,null,null,"Less than 4 habitat features available."]
[]
[]
[]
[]
[null,null,"10          9",null,null,null,null,null,"8          7",null,null,null,null,null,"6          5",null,null,null,null,"4         3         2",null,null,null,null,"1          0"]
[]
[null,null,"Element 13 - Aquatic Invertebrate Habitat",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"At least 9 habitat features1] present,                                       ▪A combination of wood with riffles should be present and suitable in addition to other types of habitat.                                                          ",null,null,null,null,null,"8 to 6 habitat features, ▪Site may be in need of more wood or reference habitat features and stable wood-riffle sections.",null,null,null,null,null,"5 to 4 habitat features present",null,null,null,null,"3 to 2 habitat features present",null,null,null,null,"None to 1 habitat feature present"]
[]
[]
[]
[]
[]
[]
[null,null,"10          9",null,null,null,null,null,"8          7          6",null,null,null,null,null,"5          4",null,null,null,null,"3         2",null,null,null,null,"1          0"]
[]
[null,null,"Habitat Features: logs/large wood, small wood accumulations, deep pools, secondary pools (scour, plunge, shallow, pocket) overhanging vegetation, large boulders, small boulder clusters, cobble riffles, undercut banks, thick root mats, macrophyte beds, and off-channel habitats (backwater pools/channels). Each habitat feature must be present in appreciable amounts to score."]
[]
[]
[]
[null,null,"Element 14 - Aquatic Invertebrate Community ",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"▪Invertebrate community is diverse and well represented by Group I or intolerant species,                    ▪One or two species do not dominate.",null,null,null,null,null,"▪Invertebrate community is well represented by Group II or facultative species, and Group I species are also present,                                    ▪One or two species do not dominate.",null,null,null,null,null,null,"▪Invertebrate community is composed mainly of Groups II and III and/or                                ▪One or two species of any group may dominate.",null,null,null,null,null,null,"▪Invertebrate community composition is predominantly Group III species and/or                       ▪only one or two species of any group is present and abundance is low."]
[]
[]
[]
[]
[]
[]
[null,null,"10          9         8",null,null,null,null,null,"7          6          5",null,null,null,null,null,null,"4        3       2",null,null,null,null,null,null,"1          0"]
[]
[null,null,"Element 15 - Riffle Embeddedness (if applicable)1]",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"Gravel or cobble substrates are <10% embedded",null,null,null,null,null,"Gravel or cobble substrates are 10–20% embedded",null,null,null,null,null,"Gravel or cobble substrates are 21–30% embedded",null,null,null,null,"Gravel or cobble substrates are 31-–0% embedded",null,null,null,null,"Gravel or cobble substrates are >40% embedded"]
[]
[]
[null,null,"10          9",null,null,null,null,null,"8          7",null,null,null,null,null,"6          5",null,null,null,null,"4          3",null,null,null,null,"2         1         0"]
[null,null,"1] Only assess this element if riffles or swift-flowing water and coarse substrates are a natural feature that should be present."]
[]
[null,null,"Element 16 - Salinity (if applicable)1]",null,null,null,null,null,null,null,null,null,null,null,null,"Bench Mark Score:",null,null,null,null,null,null,"Planned Score:"]
[null,null,"▪No wilting, bleaching, leaf burn, or stunting of riparian vegetation,                      ▪No streamside salt-tolerant vegetation present.",null,null,null,null,null,"▪Minimal wilting, bleaching, leaf burn, or stunting of riparian vegetation,                            ▪Some salt-tolerant streamside vegetation.",null,null,null,null,null,null,"▪Riparian vegetation may show significant wilting, bleaching, leaf burn, or stunting,                             ▪Dominance of salt-tolerant streamside vegetation.",null,null,null,null,null,null,"▪Severe wilting, bleaching, leaf burn, or stunting; presence of only salt tolerant riparian vegetation,                              ▪Most streamside vegetation is salt tolerant."]
[]
[]
[]
[]
[]
[null,null,"10          9         8",null,null,null,null,null,"7          6          5",null,null,null,null,null,null,"4        3",null,null,null,null,null,null,"2          1          0"]
[null,null,"1] Do not assess this element unless elevated salinity levels are suspected to be caused by human influence."]
[]
[null,null,null,"Summary Sheet"]
[]
[null,null,null,"Element",null,null,null,null,null,null,null,null,null,"Baseline Score",null,null,"Planned Score",null,null,"Notes                                                            "]
[null,null,null,"1.  Channel Condition",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U66)=0,\"\",SUM(U66))","v":""},null,null,{"$f":"IF(COUNT(AA66)=0,\"\",SUM(AA66))","v":""}]
[null,null,null,"2.  Hydrologic Alteration",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U92)=0,\"\",SUM(U92))","v":""},null,null,{"$f":"IF(COUNT(AA92)=0,\"\",SUM(AA92))","v":""}]
[null,null,null,"3.  Bank ConditionPC",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U113:V114)=0,\"\",IF(COUNT(U113:V114)=1,SUM(U113:V114),SUM(U113:V114)/2))","v":""},null,null,{"$f":"IF(COUNT(AA113:AB114)=0,\"\",IF(COUNT(AA113:AB114)=1,SUM(AA113:AB114),SUM(AA113:AB114)/2))","v":""}]
[null,null,null,"4.  Riparian QuantityPC",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(T134:U135)=0,\"\",IF(COUNT(T134:U135)=1,SUM(T134:U135),IF(V134=\"-2\",SUM((SUM(T134:U135)-2)/2),SUM(T134:U135)/2)))","v":""},null,null,{"$f":"IF(COUNT(AA134:AB135)=0,\"\",IF(COUNT(AA134:AB135)=1,SUM(AA134:AB135),IF(AC134=\"-2\",SUM((SUM(AA134:AB135)-2)/2),SUM(AA134:AB135)/2)))","v":""}]
[null,null,null,"5.  Riparian QualityPC",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U156:V157)=0,\"\",IF(COUNT(U156:V157)=1,SUM(U156:V157),SUM(U156:V157)/2))","v":""},null,null,{"$f":"IF(COUNT(AA156:AB157)=0,\"\",IF(COUNT(AA156:AB157)=1,SUM(AA156:AB157),SUM(AA156:AB157)/2))","v":""}]
[null,null,null,"6.  Canopy Cover/Stream ShadingPC",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U180)=0,\"\",SUM(U180))","v":""},null,null,{"$f":"IF(COUNT(AA180)=0,\"\",SUM(AA180))","v":""}]
[null,null,null,"7.  Water Appearance",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U195)=0,\"\",SUM(U195))","v":""},null,null,{"$f":"IF(COUNT(AA195)=0,\"\",SUM(AA195))","v":""}]
[null,null,null,"8.  Nutrient Enrichment",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U208)=0,\"\",SUM(U208))","v":""},null,null,{"$f":"IF(COUNT(AA208)=0,\"\",SUM(AA208))","v":""}]
[null,null,null,"9.  Manure or Human Waste",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U220)=0,\"\",SUM(U220))","v":""},null,null,{"$f":"IF(COUNT(AA220)=0,\"\",SUM(AA220))","v":""}]
[null,null,null,"10. Pools",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U232)=0,\"\",SUM(U232))","v":""},null,null,{"$f":"IF(COUNT(AA232)=0,\"\",SUM(AA232))","v":""}]
[null,null,null,"11. Barriers to MovementPC",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U263)=0,\"\",SUM(U263))","v":""},null,null,{"$f":"IF(COUNT(AA263)=0,\"\",SUM(AA263))","v":""}]
[null,null,null,"12. Fish Habitat ComplexityPC",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U272)=0,\"\",SUM(U272))","v":""},null,null,{"$f":"IF(COUNT(AA272)=0,\"\",SUM(AA272))","v":""}]
[null,null,null,"13. Aquatic Invertebrate HabitatPC",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U280)=0,\"\",SUM(U280))","v":""},null,null,{"$f":"IF(COUNT(AA280)=0,\"\",SUM(AA280))","v":""}]
[null,null,null,"14. Aquatic Invertebrate Community",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U294)=0,\"\",SUM(U294))","v":""},null,null,{"$f":"IF(COUNT(AA294)=0,\"\",SUM(AA294))","v":""}]
[null,null,null,"15. Riffle Embeddedness",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U304)=0,\"\",SUM(U304))","v":""},null,null,{"$f":"IF(COUNT(AA304)=0,\"\",SUM(AA304))","v":""}]
[null,null,null,"16. Salinity",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(U311)=0,\"\",SUM(U311))","v":""},null,null,{"$f":"IF(COUNT(AA311)=0,\"\",SUM(AA311))","v":""}]
[]
[]
[null,null,null,"A. Sum of elements scored:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(N324:P339)=0,\"\",SUM(N324:P339))","v":""},null,null,{"$f":"IF(COUNT(Q324:S339)=0,\"\",SUM(Q324:S339))","v":""}]
[null,null,null,"B. Number of elements scored:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(N324:P339)=0,\"\",COUNT(N324:P339))","v":""},null,null,{"$f":"IF(COUNT(Q324:S339)=0,\"\",COUNT(Q324:S339))","v":""},null,null,{"$f":"IF(Q343=\"\",\"\",IF(N343=Q343,\"\",\"ERROR: the before/after should match.\"))","v":""}]
[]
[null,null,null,"Overall Score (A/B):",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(N324:P339)=0,\"\",N342/N343)","v":""},null,null,{"$f":"IF(COUNT(Q324:S339)=0,\"\",IF(T343=\"\",Q342/Q343,\"--\"))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1 to 2.9",null,"Severely Degraded",null,null,null,null,"An Overall Score of < 5 does not met Planning Criteria (PC)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3 to 4.9",null,"Poor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5 to 6.9",null,"Fair"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"7 to 8.9",null,"Good"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"9 to 10",null,"Excellent"]
[]
[]
[null,null,null,"Suspected causes of SVAP2 scores less than 5:"]
[]
[]
[null,null,null,"Recommendations for further assessment or actions:"]
[]
[]
[null,null,null,"Stream/Riparian/Floodplain Habitat recommendations:"]
[]
[]
[]
[null,null,null,"Photo Point Locations and Descriptions:"]
[null,null,null,"Point #",null,null,"Coordinates",null,null,null,null,"Description                       "]
[]
[]
[]
[]
[]
[null,null,"Reference"]
[null,null,null,"1] USDA-NRCS.  2017.  Colorado Stream Visual Assessment Protocol Version 2. USDA NRCS. Denver, CO."]
[]
[]
[]
[]
[null,null,"Drop Down Lists"]
[]
[null,null,null,null,"Yes, Report Attached",null,null,null,null,null,11020010]
[null,null,null,null,"Not Available",null,null,null,null,null,11040001]
[null,null,null,null,null,null,null,null,null,null,11040002]
[null,null,null,null,"Bedrock",null,null,null,null,null,11080001]
[null,null,null,null,"Boulder ",null,null,null,null,null,11080002]
[null,null,null,null,"Cobble",null,null,null,null,null,11080003]
[null,null,null,null,"Gravel ",null,null,null,null,null,11080004]
[null,null,null,null,"Sand",null,null,null,null,null,11080005]
[null,null,null,null,"Silt/Clay",null,null,null,null,null,11080006]
[null,null,null,null,null,null,null,null,null,null,11080007]
[null,null,null,null,"Woody Riparian",null,null,null,null,null,11080008]
[null,null,null,null,"Herbaceous Riparian",null,null,null,null,null,11090101]
[null,null,null,null,"Unvegetated",null,null,null,null,null,11090102]
[null,null,null,null,null,null,null,null,null,null,11090103]
[null,null,null,null,"Cold Water Stream",null,null,null,null,null,11090104]
[null,null,null,null,"Warm Water Stream",null,null,null,null,null,11100101]
[null,null,null,null,null,null,null,null,null,null,11120101]
[null,null,null,null,"Ephemeral Stream",null,null,null,null,null,11120102]
[null,null,null,null,"Intermittent Stream",null,null,null,null,null,12050001]
[null,null,null,null,"Perennial Stream",null,null,null,null,null,12050002]
[null,null,null,null,null,null,null,null,null,null,12050005]
[null,null,null,null,null,null,null,null,null,null,12080001]
[null,null,null,null,null,null,null,null,null,null,12080003]
[null,null,null,null,null,null,null,null,null,null,12080004]
[null,null,null,null,null,null,null,null,null,null,12080006]
[null,null,null,null,null,null,null,null,null,null,13010002]
[null,null,null,null,null,null,null,null,null,null,13010005]
[null,null,null,null,null,null,null,null,null,null,13020101]
[null,null,null,null,null,null,null,null,null,null,13020102]
[null,null,null,null,null,null,null,null,null,null,13020201]
[null,null,null,null,null,null,null,null,null,null,13020202]
[null,null,null,null,null,null,null,null,null,null,13020203]
[null,null,null,null,null,null,null,null,null,null,13020204]
[null,null,null,null,null,null,null,null,null,null,13020205]
[null,null,null,null,null,null,null,null,null,null,13020206]
[null,null,null,null,null,null,null,null,null,null,13020207]
[null,null,null,null,null,null,null,null,null,null,13020208]
[null,null,null,null,null,null,null,null,null,null,13020209]
[null,null,null,null,null,null,null,null,null,null,13020210]
[null,null,null,null,null,null,null,null,null,null,13020211]
[null,null,null,null,null,null,null,null,null,null,13030101]
[null,null,null,null,null,null,null,null,null,null,13030102]
[null,null,null,null,null,null,null,null,null,null,13030103]
[null,null,null,null,null,null,null,null,null,null,13030201]
[null,null,null,null,null,null,null,null,null,null,13030202]
[null,null,null,null,null,null,null,null,null,null,13050001]
[null,null,null,null,null,null,null,null,null,null,13050002]
[null,null,null,null,null,null,null,null,null,null,13050003]
[null,null,null,null,null,null,null,null,null,null,13050004]
[null,null,null,null,null,null,null,null,null,null,13060001]
[null,null,null,null,null,null,null,null,null,null,13060002]
[null,null,null,null,null,null,null,null,null,null,13060003]
[null,null,null,null,null,null,null,null,null,null,13060004]
[null,null,null,null,null,null,null,null,null,null,13060005]
[null,null,null,null,null,null,null,null,null,null,13060006]
[null,null,null,null,null,null,null,null,null,null,13060007]
[null,null,null,null,null,null,null,null,null,null,13060008]
[null,null,null,null,null,null,null,null,null,null,13060009]
[null,null,null,null,null,null,null,null,null,null,13060010]
[null,null,null,null,null,null,null,null,null,null,13060011]
[null,null,null,null,null,null,null,null,null,null,13070001]
[null,null,null,null,null,null,null,null,null,null,13070002]
[null,null,null,null,null,null,null,null,null,null,13070007]
[null,null,null,null,null,null,null,null,null,null,14080101]
[null,null,null,null,null,null,null,null,null,null,14080103]
[null,null,null,null,null,null,null,null,null,null,14080104]
[null,null,null,null,null,null,null,null,null,null,14080105]
[null,null,null,null,null,null,null,null,null,null,14080106]
[null,null,null,null,null,null,null,null,null,null,14080107]
[null,null,null,null,null,null,null,null,null,null,14080201]
[null,null,null,null,null,null,null,null,null,null,14080204]
[null,null,null,null,null,null,null,null,null,null,15020001]
[null,null,null,null,null,null,null,null,null,null,15020002]
[null,null,null,null,null,null,null,null,null,null,15020003]
[null,null,null,null,null,null,null,null,null,null,15020004]
[null,null,null,null,null,null,null,null,null,null,15020006]
[null,null,null,null,null,null,null,null,null,null,15040001]
[null,null,null,null,null,null,null,null,null,null,15040002]
[null,null,null,null,null,null,null,null,null,null,15040003]
[null,null,null,null,null,null,null,null,null,null,15040004]
[null,null,null,null,null,null,null,null,null,null,15040006]
[null,null,null,null,null,null,null,null,null,null,15080302]
[null,null,null,null,null,null,null,null,null,null,15080303]

{"sheet":"HUC8","index":1,"n_rows":93,"n_cols":10,"rows_kept":93,"cut":false,"hidden":false,"merged":[[0,0,1,3]]}
["RETURN",null,null,null,"HUC 8","REGION","SUBREGION","BASIN","SUBBASIN","SqMi"]
[null,null,null,null,10180001,"Missouri Region","North Platte","North Platte","North Platte Headwaters",1424]
[null,null,null,null,10180002,"Missouri Region","North Platte","North Platte","Upper North Platte",2960]
[null,null,null,null,10180010,"Missouri Region","North Platte","North Platte","Upper Laramie",2273]
[null,null,null,null,10190001,"Missouri Region","South Platte","South Platte","South Platte Headwaters",1604]
[null,null,null,null,10190002,"Missouri Region","South Platte","South Platte","Upper South Platte",1850]
[null,null,null,null,10190003,"Missouri Region","South Platte","South Platte","Middle South Platte-Cherry Creek",2872]
[null,null,null,null,10190004,"Missouri Region","South Platte","South Platte","Clear",570]
[null,null,null,null,10190005,"Missouri Region","South Platte","South Platte","St. Vrain",980]
[null,null,null,null,10190006,"Missouri Region","South Platte","South Platte","Big Thompson",832]
[null,null,null,null,10190007,"Missouri Region","South Platte","South Platte","Cache La Poudre",1890]
[null,null,null,null,10190008,"Missouri Region","South Platte","South Platte","Lone Tree-Owl",578]
[null,null,null,null,10190009,"Missouri Region","South Platte","South Platte","Crow",1390]
[null,null,null,null,10190010,"Missouri Region","South Platte","South Platte","Kiowa",717]
[null,null,null,null,10190011,"Missouri Region","South Platte","South Platte","Bijou",1384]
[null,null,null,null,10190012,"Missouri Region","South Platte","South Platte","Middle South Platte-Sterling",2983]
[null,null,null,null,10190013,"Missouri Region","South Platte","South Platte","Beaver",1106]
[null,null,null,null,10190014,"Missouri Region","South Platte","South Platte","Pawnee",724]
[null,null,null,null,10190015,"Missouri Region","South Platte","South Platte","Upper Lodgepole",1182]
[null,null,null,null,10190016,"Missouri Region","South Platte","South Platte","Lower Lodgepole",1334]
[null,null,null,null,10190017,"Missouri Region","South Platte","South Platte","Sidney Draw",752]
[null,null,null,null,10190018,"Missouri Region","South Platte","South Platte","Lower South Platte",1412]
[null,null,null,null,10250001,"Missouri Region","Republican","Republican","Arikaree",1847]
[null,null,null,null,10250002,"Missouri Region","Republican","Republican","North Fork Republican",2949]
[null,null,null,null,10250003,"Missouri Region","Republican","Republican","South Fork Republican",2698]
[null,null,null,null,10250005,"Missouri Region","Republican","Republican","Frenchman",1647]
[null,null,null,null,10250006,"Missouri Region","Republican","Republican","Stinking Water",1446]
[null,null,null,null,10250012,"Missouri Region","Republican","Republican","South Fork Beaver",751]
[null,null,null,null,10250013,"Missouri Region","Republican","Republican","Little Beaver",643]
[null,null,null,null,10260001,"Missouri Region","Smoky Hill","Smoky Hill","Smoky Hill Headwaters",1053]
[null,null,null,null,10260002,"Missouri Region","Smoky Hill","Smoky Hill","North Fork Smoky Hill",730]
[null,null,null,null,10260004,"Missouri Region","Smoky Hill","Smoky Hill","Ladder",1417]
[null,null,null,null,11020001,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Arkansas Headwaters",3065]
[null,null,null,null,11020002,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Upper Arkansas",2305]
[null,null,null,null,11020003,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Fountain",928]
[null,null,null,null,11020004,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Chico",724]
[null,null,null,null,11020005,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Upper Arkansas-Lake Meredith",2214]
[null,null,null,null,11020006,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Huerfano",1860]
[null,null,null,null,11020007,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Apishapa",1077]
[null,null,null,null,11020008,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Horse",1425]
[null,null,null,null,11020009,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Upper Arkansas-John Martin Reservoir",3857]
[null,null,null,null,11020010,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Purgatoire",3449]
[null,null,null,null,11020011,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Big Sandy",1851]
[null,null,null,null,11020012,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Rush",1365]
[null,null,null,null,11020013,"Arkansas-White-Red Region","Upper Arkansas","Upper Arkansas","Two Butte",806]
[null,null,null,null,11030001,"Arkansas-White-Red Region","Middle Arkansas","Middle Arkansas","Middle Arkansas-Lake McKinney",2300]
[null,null,null,null,11030002,"Arkansas-White-Red Region","Middle Arkansas","Middle Arkansas","Whitewoman",1458]
[null,null,null,null,11040001,"Arkansas-White-Red Region","Upper Cimarron","Upper Cimarron","Cimarron Headwaters",1678]
[null,null,null,null,11040002,"Arkansas-White-Red Region","Upper Cimarron","Upper Cimarron","Upper Cimarron",1650]
[null,null,null,null,11040003,"Arkansas-White-Red Region","Upper Cimarron","Upper Cimarron","North Fork Cimarron",991]
[null,null,null,null,11040004,"Arkansas-White-Red Region","Upper Cimarron","Upper Cimarron","Sand Arroyo",762]
[null,null,null,null,11040005,"Arkansas-White-Red Region","Upper Cimarron","Upper Cimarron","Bear",1904]
[null,null,null,null,11080001,"Arkansas-White-Red Region","Upper Canadian","Upper Canadian","Canadian Headwaters",1725]
[null,null,null,null,13010001,"Rio Grande Region","Rio Grande Headwaters","Rio Grande Headwaters","Rio Grande Headwaters",1381]
[null,null,null,null,13010002,"Rio Grande Region","Rio Grande Headwaters","Rio Grande Headwaters","Alamosa-Trinchera",2539]
[null,null,null,null,13010003,"Rio Grande Region","Rio Grande Headwaters","Rio Grande Headwaters","San Luis",1582]
[null,null,null,null,13010004,"Rio Grande Region","Rio Grande Headwaters","Rio Grande Headwaters","Saguache",1343]
[null,null,null,null,13010005,"Rio Grande Region","Rio Grande Headwaters","Rio Grande Headwaters","Conejos",767]
[null,null,null,null,13020101,"Rio Grande Region","Rio Grande-Elephant Butte","Upper Rio Grande","Upper Rio Grande",3254]
[null,null,null,null,13020102,"Rio Grande Region","Rio Grande-Elephant Butte","Upper Rio Grande","Rio Chama",3158]
[null,null,null,null,14010001,"Upper Colorado Region","Colorado Headwaters","Colorado Headwaters","Colorado Headwaters",2902]
[null,null,null,null,14010002,"Upper Colorado Region","Colorado Headwaters","Colorado Headwaters","Blue",683]
[null,null,null,null,14010003,"Upper Colorado Region","Colorado Headwaters","Colorado Headwaters","Eagle",972]
[null,null,null,null,14010004,"Upper Colorado Region","Colorado Headwaters","Colorado Headwaters","Roaring Fork",1455]
[null,null,null,null,14010005,"Upper Colorado Region","Colorado Headwaters","Colorado Headwaters","Colorado Headwaters-Plateau",3826]
[null,null,null,null,14020001,"Upper Colorado Region","Gunnison","Gunnison","East-Taylor",767]
[null,null,null,null,14020002,"Upper Colorado Region","Gunnison","Gunnison","Upper Gunnison",2411]
[null,null,null,null,14020003,"Upper Colorado Region","Gunnison","Gunnison","Tomichi",1103]
[null,null,null,null,14020004,"Upper Colorado Region","Gunnison","Gunnison","North Fork Gunnison",969]
[null,null,null,null,14020005,"Upper Colorado Region","Gunnison","Gunnison","Lower Gunnison",1663]
[null,null,null,null,14020006,"Upper Colorado Region","Gunnison","Gunnison","Uncompahgre",1115]
[null,null,null,null,14030001,"Upper Colorado Region","Upper Colorado-Dolores","Upper Colorado-Dolores","Westwater Canyon",1455]
[null,null,null,null,14030002,"Upper Colorado Region","Upper Colorado-Dolores","Upper Colorado-Dolores","Upper Dolores",2157]
[null,null,null,null,14030003,"Upper Colorado Region","Upper Colorado-Dolores","Upper Colorado-Dolores","San Miguel",1553]
[null,null,null,null,14030004,"Upper Colorado Region","Upper Colorado-Dolores","Upper Colorado-Dolores","Lower Dolores",923]
[null,null,null,null,14030005,"Upper Colorado Region","Upper Colorado-Dolores","Upper Colorado-Dolores","Upper Colorado-Kane Springs",2275]
[null,null,null,null,14040106,"Upper Colorado Region","Great Divide-Upper Green","Upper Green","Upper Green-Flaming Gorge Reservoir",2501]
[null,null,null,null,14040109,"Upper Colorado Region","Great Divide-Upper Green","Upper Green","Vermilion",975]
[null,null,null,null,14050001,"Upper Colorado Region","White-Yampa","White-Yampa","Upper Yampa",2620]
[null,null,null,null,14050002,"Upper Colorado Region","White-Yampa","White-Yampa","Lower Yampa",1569]
[null,null,null,null,14050003,"Upper Colorado Region","White-Yampa","White-Yampa","Little Snake",3060]
[null,null,null,null,14050005,"Upper Colorado Region","White-Yampa","White-Yampa","Upper White",1364]
[null,null,null,null,14050006,"Upper Colorado Region","White-Yampa","White-Yampa","Piceance-Yellow",914]
[null,null,null,null,14050007,"Upper Colorado Region","White-Yampa","White-Yampa","Lower White",2725]
[null,null,null,null,14060001,"Upper Colorado Region","Lower Green","Lower Green","Lower Green-Diamond",981]
[null,null,null,null,14080101,"Upper Colorado Region","San Juan","Upper San Juan","Upper San Juan",3431]
[null,null,null,null,14080102,"Upper Colorado Region","San Juan","Upper San Juan","Piedra",676]
[null,null,null,null,14080104,"Upper Colorado Region","San Juan","Upper San Juan","Animas",1370]
[null,null,null,null,14080105,"Upper Colorado Region","San Juan","Upper San Juan","Middle San Juan",1945]
[null,null,null,null,14080107,"Upper Colorado Region","San Juan","Upper San Juan","Mancos",802]
[null,null,null,null,14080201,"Upper Colorado Region","San Juan","Lower San Juan","Lower San Juan-Four Corners",1994]
[null,null,null,null,14080202,"Upper Colorado Region","San Juan","Lower San Juan","McElmo",717]
[null,null,null,null,14080203,"Upper Colorado Region","San Juan","Lower San Juan","Montezuma",1169]

{"sheet":"Classification","index":2,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,2,17,2],[30,0,30,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RETURN"]

{"sheet":"macro","index":3,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
["Sub clear()"]
["    Dim WorkRange As Range"]
["    Dim FoundCells As Range"]
["    Dim Cell As Range"]
["    Set WorkRange = ActiveSheet.UsedRange"]
["    For Each Cell In WorkRange"]
["        If Cell.Locked = False Then"]
["            If FoundCells Is Nothing Then"]
["                Set FoundCells = Cell"]
["            Else"]
["                Set FoundCells = Union(FoundCells, Cell)"]
["            End If"]
["        End If"]
["    Next Cell"]
["    If FoundCells Is Nothing Then"]
["        MsgBox \"All cells are locked.\""]
["    Else"]
["        FoundCells.Select"]
["        Selection.ClearContents"]
["        Range(\"I5:L5\").Select"]
["    End If"]
["End Sub"]