{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["INSTRUCTIONS","Setup","Notes","Summary_Scores","Bubble_Plot","Bubble_Plot_Options","Indicator_Values","Normalized_Indicator_Values","Values_Only_Summary","ScaleA_Data","ScaleB_Data","ScaleC_Data","Indicator_Info","HUC_Subsets","List_Data","Plot_Data","Map_Data","Summary_All","Weights"],"not_rendered":{"charts":2,"images":32,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Bubble_Plot","index":4,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,12],[5,0,9,12]]}
["Scoring Spreadsheet for Recovery Potential Screening"]
["Project Area: User-Defined"]
["Watershed Scales: User-Defined"]
["Version Date: March 10, 2015"]
[]
["TROUBLESHOOTING NOTE: In December 2014, Microsoft released Office updates that affect the functionality of Excel macros and controls (drop-down menus, buttons, etc.). This tool file contains a patch to address these issues, but the file must be opened twice for the patch to be fully implemented. If this is your first time opening the file, please close and re-open a second time before proceeding. If you continue to receive error messages while using the Setup worksheet, you will need to download and run the Administrator level Microsoft Fix it solution (#51031) from http://support.microsoft.com/kb/3025036/EN-US."]

{"sheet":"Setup","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,2,12,3],[12,5,12,6],[12,8,12,9],[13,2,13,3],[13,5,13,6],[13,8,13,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Select Watersheds",null,"Select Ecological Indicators",null,null,"Select Stressor Indicators",null,null,"Select Social Indicators"]
[null,null,"Select the Ecological Indicators of interest below:",null,null,"Select the Stressor Indicators of interest below:",null,null,"Select the Social Indicators of interest below:"]
[]
[]
["ScaleA ID",null,"Ecological Indicator","Weight",null,"Stressor Indicator","Weight",null,"Social Indicator","Weight"]

{"sheet":"Notes","index":2,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,0,6,0],[7,0,8,0],[9,0,10,0],[11,0,12,0]]}
[]
[]
[]
[]
[]
["Screening Run Name:"]
[]
["Objectives:"]
[]
["Watershed Scale:"]
[]
["Indicator Selection Notes:"]

{"sheet":"Summary_Scores","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Bubble_Plot_Options","index":5,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[9,17,9,22],[10,0,12,4],[24,0,32,4],[16,6,17,10],[20,6,21,10],[23,6,25,10],[27,6,28,10],[22,12,24,15],[9,6,9,10],[9,0,9,4],[23,0,23,4],[9,12,9,15],[21,12,21,15],[21,17,21,22]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["REPOSITION AXES",null,null,null,null,null,"ADD LABELS TO BUBBLES",null,null,null,null,null,"EDIT BUBBLE SIZES",null,null,null,null,"EDIT BUBBLE COLORS"]
["By default, axes cross at the median of Ecological Index (horizontal axis) and Stressor Index (vertical axis) scores listed in the Summary_Scores sheet. Axes can be repositioned to:",null,null,null,null,null,"Select a watershed identifier for labeling:",null,null,null,null,null,"Enter a bubble size (1 - 300):",null,null,null,null,"Select the indicator that will determine bubble colors:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"The default bubble size is 20."]
[null,null,null,null,null,null,"Click the button below to label all bubbles:",null,null,null,null,null,null,null,null,null,null,"Select a classification method:"]
["This option will position axes to percentiles entered below.",null,null,null,null,null,null,null,null,null,null,null,"Click the button below to resize:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select the number of classes:"]
["Enter a new Stressor Index percentile for the y-axis (0-100):",null,null,null,null,null,"Or, select watersheds individually from the list below (repeat to label multiple watersheds):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select a color scheme:"]
["Enter a new Ecological Index percentile for the x-axis (0-100):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click the button below to update bubble colors:"]
[]
[null,null,null,null,null,null,"Note: To hightlight the watershed, the box above must be checked BEFORE selecting from the drop-down list. "]
[null,null,null,null,null,null,null,null,null,null,null,null,"SAVE AS IMAGE FILE",null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Click the button below to save the bubble plot as an image (.jpg) file:"]
["SELECT SCREENING TO PLOT",null,null,null,null,null,"Label locations can be changed by clicking on the label in the bubble plot and dragging to the desired location."]
["If your screening focuses on a subset of watersheds from the project area, you may want to know if Ecological and Stressor Index scores for your subset are generally above or below average for the project area. Clicking the \"ALL WATERSHEDS SCREENING\" option below will plot scores from a screening that includes all watersheds in the project area, with axes set to the median of all Ecological and Stressor Index scores. Clicking the \"SUBSET ONLY SCREENING\" option will return to the default option of plotting scores from the screening that only includes those watersheds selected on the Setup sheet."]
[]
[]
[null,null,null,null,null,null,"Click the button below to remove labels and highlighting:"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click the button below to reset bubble colors:"]

{"sheet":"Indicator_Values","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Normalized_Indicator_Values","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Values_Only_Summary","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ScaleA_Data","index":9,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["BASE INDICATORS"]
["Watershed ID","Watershed Name"]

{"sheet":"ScaleB_Data","index":10,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["BASE INDICATORS"]
["Watershed ID","Watershed Name"]

{"sheet":"ScaleC_Data","index":11,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["BASE INDICATORS"]
["Watershed ID","Watershed Name"]

{"sheet":"Indicator_Info","index":12,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Indicator Name","Indicator Type","Description"]
["Watershed ID","Base"]
["Watershed Name","Base"]

{"sheet":"HUC_Subsets","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List_Data","index":14,"n_rows":12,"n_cols":37,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Drop-down contents for SCALE A boxes",null,null,null,null,"Drop-down contents for SCALE B boxes",null,null,null,null,"Drop-down contents for SCALE C boxes",null,null,null,null,"Drop-down contents for bubble plot label boxes",null,null,null,"Drop-Down Contents for Bubble Plot & Map Color boxes",null,null,null,null,"Drop-Down Contents for Bubble Plot Axis Position box",null,"Number of Watersheds & Indicators",null,null,null,null,"Enable Mapping",null,null,"Integrated Index Name",null,"Workbook Open Date/Time"]
["SCALE A IDs","SCALE A Ecological Indicators","SCALE A Stressor Indicators","SCALE A Social Indicators",null,"SCALE B IDs","SCALE B Ecological Indicators","SCALE B Stressor Indicators","SCALE B Social Indicators",null,"SCALE C IDs","SCALE C Ecological Indicators","SCALE C Stressor Indicators","SCALE C Social Indicators",null,"Site Identifiers","Watershed ID (Name)","Watershed Names Sorted",null,null,null,null,null,null,null,null,null,"Scale A","Scale B","Scale C",null,"Scale A",false,null,"RPI",null,"2015-03-31T14:20:21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Watershed Name",null,null,null,"RPI Score",2,"Blue","Quantile Breaks",null,"(a) User-Defined Percentiles",null,"Descriptive",2,2,2,null,"Scale B",false]
["None Entered","None Entered","None Entered","None Entered",null,"None Entered","None Entered","None Entered","None Entered",null,"None Entered","None Entered","None Entered","None Entered",null,"Watershed ID",null,null,null,"RPI Rank",3,"Green","Equal-Interval Breaks",null,"(b) User-Defined Index Scores",null,"Ecological",0,0,0,null,"Scale C",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ecological Index",4,"Blue-Green","User-Defined Breaks",null,null,null,"Stressor",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ecological Rank",5,null,null,null,null,null,"Social",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stressor Index",6,null,null,null,null,null,"Watersheds",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stressor Rank",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Social Index",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Social Rank",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Watershed ID",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Watershed Name"]

{"sheet":"Plot_Data","index":15,"n_rows":4,"n_cols":17,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Watershed ID","Watershed Name","Ecological Index Subset","Stressor Index Subset","Social Index Subset","Ecological Index All","Stressor Index All","Social Index All","Integrated Score All","Integrated Rank All",null,"Bubble Color",null,null,"Median Index Values"]
[null,null,null,null,null,null,null,null,null,null,null,"R",null,null,null,"Subset","All"]
[null,null,null,null,null,null,null,null,null,null,null,"G",null,null,"Ecological"]
[null,null,null,null,null,null,null,null,null,null,null,"B",null,null,"Stressor"]

{"sheet":"Map_Data","index":16,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Watershed","Indicator Value",null,null,null,"Number of Classes",null,"Color Class","Upper Bound","Start Row","End Row"]
[null,null,null,null,null,null,null,1,null,2,{"$f":"MATCH(I2,$B$2:$B$10001,1)+1","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,2,null,{"$f":"K2+1","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,"Number of Watersheds",null,3,null,{"$f":"K3+1","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,4,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,5,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,"Number of Watersheds with Data",null,6,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,7,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,8,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,9,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,10,null,{"$error":"#N/A"},{"$error":"#N/A"}]

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

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