User Guide for the Recovery Potential Screening (RPS) Scoring Spreadsheet Tool August 2022


User Guide
for the

Recovery Potential Screening (RPS)

100
90
80
70

85 60

¦O

c

S 50
"oo
_o
o

lu 40

30
20
10
0

0	10	20	30	40	50	60	70	80	90	100

Stressor Index

Scoring Spreadsheet Tool

August 2022

Watershed % Impervious

I I 0-0.02

I I 0.02-0.05
IB 0.05-0.09

¦	0.09-0.14

¦	0.14-0.54

1

-------
Table of Contents

1.	Introduction & Background	4

1.1.	RPS Overview	4

1.2.	RPS Scoring Spreadsheet Tool	4

1.3.	User Guide Organization	4

2.	Instructions Worksheet	5

3.	Setup Worksheet	6

3.1.	Overview	6

Basics	6

Advanced Tips	7

3.2.	Choose Watershed Scale	8

Basics	8

Advanced Tips	8

3.3.	Select Watersheds to Screen	9

Basics	9

Advanced Tips	13

3.4.	Select Indicators and Weights	14

Basics	14

Advanced Tips	17

3.5.	Run Screening Button	18

Basics	18

Advanced Tips	19

3.6.	Respond to Warning Messages	20

Basics	20

Advanced Tips	21

3.7.	Reset Screening Button	22

4.	Notes Worksheet	23

5.	Results Worksheet	24

5.1.	Overview	24

Basics	24

Advanced Tips	24

5.2.	Sort and Filter	25

6.	Bubble Plot Worksheet	26

7.	Bubble Plot Options Worksheet	27

7.1.	Overview	27

7.2.	Reposition Axes	28

7.3.	Toggle Screening to Plot	29

2

-------
7.4.	Label Bubbles	30

Basics	30

Advanced Tips	32

7.5.	Edit Bubble Sizes	33

7.6.	Edit Bubble Colors	34

7.7.	Highlight Bubbles	37

7.8.	Save As Image File	39

8.	Map Worksheet	40

8.1.	Overview	40

8.2.	Create Custom Map	41

8.3.	Highlight Watersheds of Interest	44

8.4.	Save Map as PDF File	45

9.	Indicator Data Worksheet(s)	46

10.	Explore Indicator Data Menu	47

10.1.	Overview	47

10.2.	Select an Indicator to Explore	49

10.3.	Select a Covariate Indicator	50

10.4.	Save or Copy a Chart	51

10.5.	Change Watershed Selection Button	52

11.	Indicator Info Worksheet	56

11.1.	Overview	56

11.2.	Filter Table	57

11.3.	Add Indicator Info	58

12.	Add Indicators Worksheet	60

12.1.	Overview	60

12.2.	Enter New Indicator Information	61

12.3.	Enter New Indicator Data	62

12.4.	Add Indicators Button	64

13.	HUC Subsets Worksheet	65

13.1.	Overview	65

13.2.	Create a New Watershed Subset Button	66

13.3.	Manually Add a Subset List	70

3

-------
1. Introduction & Background
1.1. RPS Overview

Recovery Potential Screening (RPS) is a systematic method for comparing watersheds based on characteristics that may
influence the relative likelihood of successful watershed restoration or protection. RPS was developed to provide states
and other planners with a flexible screening tool to guide prioritization of watersheds according to differences in key
environmental and social factors affecting prospects for restoration and protection success.

RPS involves identifying a group of watersheds to be compared and a specific purpose for comparison, selecting
appropriate indicators of recovery potential in three categories (Ecological, Stressor, and Social; Figure 1), and calculating
recovery potential index scores for the watersheds. Index scores include the Ecological Index, Stressor Index, and Social
Index and are calculated by combining indicators from each category. For example, the Ecological Index is calculated from
all ecological indicators while the Stressor Index is calculated from all stressor indicators. In addition, an overall Recovery
Potential Integrated (RPI) Index score is calculated by combining the Ecological Index, Stressor Index, and Social Index.

Figure 1. RPS uses three categories of recovery potential indicators to compare watersheds.

1.2. RPS Scoring Spreadsheet Tool

The RPS Scoring Spreadsheet Tool (RPS Tool) is a custom-coded Microsoft Excel workbook designed to facilitate setting up
an RPS screening run, perform all recovery potential index calculations, and display results. The State RPS Tool series was
first released in July 2014 and updated in September 2018 as a set of ready-to-use RPS spreadsheet tools for each of the
lower 48 States. Each RPS Tool has pre-calculated indicator data already embedded for all 12-digit hydrologic unit (HUC12)
subwatersheds of the National Watershed Boundary Dataset that are wholly or partially within the State's boundary. In
addition to storing pre-calculated indicator data, each State RPS Tool:

¦ Contains a user-friendly interface for setting up a screening;

¦ Automatically calculates RPS index scores and ranks for the HUC12 subwatersheds of interest;

¦ Displays results in customizable table, plot, and map form;

¦ Can be readily updated with user-generated indicator data.

The RPS Tool is designed for use by anyone with basic familiarity with Microsoft Excel. Instructions for each step are
contained within the RPS Tool and this User Guide provides more detailed directions on tool use.

1.3. User Guide Organization

The RPS Tool is made up of several worksheets within a Microsoft Excel workbook. Some worksheets contain interactive
menus and buttons while others store data for viewing and use in RPS calculations.

Each section of this User Guide describes a worksheet in the RPS Tool. Worksheet contents are summarized and step-by-
step instructions are provided for interactive features within the worksheet. For some worksheets and features, a set of
advanced tips are also provided for users that have become proficient in basic use of the tool.

-------
Instructions Worksheet

2. Instructions Worksheet

The Instructions worksheet provides an abridged set of instructions for using the RPS Tool. The Instructions worksheet is

intended to serve as a built-in reference for users of the RPS Tool. It does not supplant the more detailed instructions

presented in this User Guide.

Listed at the top of the Instructions are three key pieces of information for the tool file you are working with

¦ Project Area - The state, river basin, or other geographic area that the RPS Tool file is designed for. Each tool file
comes with a table of pre-calculated indicator data for all watersheds in the Project Area at one or more watershed
scales (defined below). Users can decide to screen all watersheds within the Project Area or only a subset of
watersheds of interest.

¦ Watershed Scales - The watershed scales that the RPS Tool file is able to screen. The term "watershed scale" refers
to pre-defined watershed delineations. A typical tool file is able to screen, at minimum, 12-digit hydrologic units
(HUC12s) of the National Watershed Boundary Dataset (WBD). Tool files for some Project Areas are able to screen
additional watershed scales such as 14-digit hydrologic units (HUC14s) or other custom watershed delineations
created by state water agencies.

¦ Version Date - The date the RPS Tool file was last updated to add new user features or modify existing features.

Al a BCD E F G H I . J , K , L M

1 Scoring Spreadsheet for Recovery Potential Screening

2 Project Area: New Jersey

3 Watershed Scales: HUC12, HUC14

4 Version Date: February 16, 2022

6 This MS Excel file is specially coded to perform Recovery Potential Screening (RPS) calculations for the project area and watershed
j scales listed above using indicator data stored in this file. This procedure supports the assessment and comparison of relative

restorability of impaired waters or watersheds by measuring ecological, stressor, and social indicators and calculating summary indices.
s This file should function properly in Excel 2003, 2007, 2010, 2013, or 2016.

, c Each of the worksheets in this spreadsheet file (see tabs along the bottom of the screen) begins with instructions and a summary of its
contents. Below is an overview of all the steps involved to perform Recovery Potential Screening from this spreadsheet tool. For

11 general background information about Recovery Potential Screening, please visit www.epa.gov/rps/.

Print a copy of this Instructions worksheet, if desired, for reference when using other worksheets.

14 1. ENABLE THE MACROS THAT RUN THIS FILE. If the message "Security warning - macros have been disabled" appears — click on
•j 5 Options and select Enable this Content. If any other message appears regarding security, click on Enable Macros or Enable this Content.
The message may vary with different versions of Excel, You should only need to do this step once to activate all of the tool's functions.

17 2. REVIEW INDICATOR DATA AND DESCRIPTIONS. Click on the HUC_Data tab for the watershed scale of interest (e.g., HUC12_Data).

18 There will be one worksheet for each watershed scale included in this file. Each worksheet stores the complete data table of raw

19 indicator values for all indicators measured and for all watersheds in the project area at a given scale,

2~\ indicator data (values of specific attributes for every watershed, in a data table) have been pre-loaded to this file. Some pre-loaded
22 indicators are measured from the in-state portion of each watershed only. Other indicators are measured from the entire watershed
area (including the out-of-state portion). Indicators that consider in-state conditions only contain "(INSTATE)'1 in their names.

24 Descriptions of pre-loaded indicators are stored on the lndicator_lnfo worksheet. Descriptions include a summary of what the indicator
-3 measures, the source dataset used to measure the indicator, and methods used to measure the indicator. The lndicator_lnfo

26 worksheet can be filtered using the drop-down arrows on the header row to explore indicator descriptions.

28 Indicator data can be reviewed by clicking the EXPLORE INDICATOR DATA button on the HUC_Data tabs, A menu will launch with tabs

29 that contain a histogram of indicator values, summary statistics, an ecoregional boxplot, a correlation plot, and correlation statistics.
The menu includes controls to give users the option to review indicator data for all watersheds in the state or just a subset of
watershed

INSTRUCTIONS Notes Setup Results Bubble_Plot Bubble_Plot_Options HUC8_Map

-------
Setup Worksheet-Overview

3. Setup Worksheet
3.1. Overview
Basics

The Setup worksheet is your "home base" for configuring and running a Recovery Potential Screening. It is the first
worksheet you should use after opening the tool file, reviewing instructions, and planning your Recovery Potential
Screening run. The Setup worksheet is the only worksheet where you can choose (and change) the watersheds and
indicators that are used in your screening run.

RUN SCREENING RESET SCREENING

Select Watersheds

Select watersheds to include in the screening by clicking the Select
Watersheds button below. To clear your selections, click the Clear
Watershed Selections button.

9 HUC12 C HUC14

Select Ecological Indicators

Select ecological indicators to include in the screening by clicking the
Select Ecological Indicators button below. To clear your selections, click
the Clear Ecological Indicator Selections button.

Select Stressor Indicators

Select stressor indicators to include in the screening by clicking the Select
Stressor Indicators button below.To clear your selections, click the Clear
Stressor Indicator Selections button.

Select Social Indicators

Select social indicators to include in the screening by clicking the Select
Social Indicators button below. To clear your selections, click the Clear
Social Indicator Selections button.

Select Watersheds

Select Ecological Indicators

Select Stressor Indicators

Select Social Indicators

Clear W&tershed Selections

Clear Ecological Indicator Selections

Clear Stressor Indicator Selections

Clear Social Indicator Selections

HUC12 ID

Ecological Indicator

Weight

Stressor Indicator

Weight

Social Indicator

Weight

INSTRUCnON^^NoteJ

Setup

| Results Bubble_Plot Bubble_Plot_Options HUC8_Map -

The Setup worksheet is organized into four sections:

¦ In the Select Watersheds section you will specify which watersheds will be included in the screening.

¦ In the Select Ecological Indicators section you will specify which ecological indicators will be used in the screening and
how those ecological indicators will be weighted.

¦ In the Select Stressor Indicators section you will specify which stressor indicators will be used in the screening and
how those stressor indicators will be weighted.

¦ In the Select Social Indicators section you will specify which social indicators will be used in the screening and how
those social indicators will be weighted.

After selecting watersheds, indicators, and weights, you will click the RUN SCREENING button to populate other
worksheets in the tool with screening results. The Setup worksheet also includes a RESET SCREENING button to clear the
current watershed/indicator selections from the Setup worksheet and screening results from other worksheets so that a
new screening run can be configured from scratch.

The following sections provide step-by-step instructions for how to:

¦ Choose a Watershed Scale

¦ Select Watersheds to Screen

m Select Indicators and Assign Weights

¦ Use the Run Screening Button

¦ Respond to Warning Messages

¦ Use the Reset Button

-------
Setup Worksheet-Overview

Advanced Tips

¦ Completing the setup process is far easier if you have already planned out your screening by identifying the screening
purpose, watersheds of interest, and relevant indicators (from the full list available) beforehand.

¦ The process of selecting watersheds and indicators to screen can be streamlined by copying and pasting watershed
IDs, indicator names, and indicator weights that have already been compiled in other spreadsheets. This is faster than
typing or selecting individually from popup menus on the Setup worksheet. Instructions for copying and pasting
watersheds and indicators into the Setup worksheet are provided in the following sections.

¦ After setting up and running a screening, you may want to make minor adjustments to your screening by adding or
removing watersheds, adding or removing indicators, or adjusting indicator weights. Do not click the RESET
SCREENING button on the Setup worksheet if you want to make minor adjustments to an existing screening since
clicking the RESET SCREENING button will clear all selections from the Setup worksheet. Instead, to adjust an existing
screening, simply make the desired changes on the Setup worksheet and then re-click the RUN SCREENING button.
This will update results stored on other worksheets to reflect the changes made to watershed and indicator selections
on the Setup worksheet.

¦ Save completed screening runs and change the file name before beginning a new run with different watersheds or
indicators, or before using RESET SCREENING.

-------
Setup Worksheet-Choose Watershed Scale

3.2. Choose Watershed Scale

Basics

Some RPS Tool files are designed to screen watersheds at a single scale (e.g., HUC12 subwatersheds only). Others allow
users to select between multiple watershed scales for a screening (e.g., either HUC12 watersheds or HUC14
subwatersheds). If your tool file includes multiple watershed scales, you must specify which scale your screening will
consider on the Setup worksheet.

Watershed scale options are displayed right below the
Select Watersheds section title on the Setup

worksheet.

To select a watershed scale, click the option button
next to the watershed scale name.

If your RPS tool contains watershed data at one scale
only, there will be no options buttons visible.

Select Watersheds

Select watersheds to include in the screening by clicking the Seiecf
Watersheds button below. To clear your selections, click the Clear

« HUC12

C HUC14

Select Watersheds

Clear Watershed Selections

HUC12 ID

Advanced Tips

¦ Users must select only one watershed scale per screening run (i.e., you cannot screen watersheds from multiple scales
in a single screening run).

¦ Clicking a watershed scale button will prepare the watershed and indicator popup menus on the Setup worksheet for
next steps. For example, clicking the HUC12 option button will add HUC12 IDs to the popup menu displayed when the
Select Watersheds button is clicked.

¦ Be aware that changing to a different watershed scale will reset the Setup worksheet by clearing any selected
watersheds, indicators, and weights. If you have begun to setup your screening run by entering watersheds, indicators,
or weights on the Setup worksheet then those entries will be deleted if you click a different watershed scale button
and will not be recovered by returning to the original scale.

-------
Setup Worksheet-Select Watersheds to Screen

3.3. Select Watersheds to Screen
Basics

A Recovery Potential Screening run can include all watersheds in the Project Area that the RPS Tool is designed for or a
targeted subset of watersheds of interest. Users must decide which watersheds to screen based on the purpose and goals
of their screening.

In the Select Watersheds section of the Setup worksheet, you will specify which watersheds to include in the screening
by entering a list of watershed IDs (one ID per row). Four options are available for entering watersheds IDs.

Select Watersheds to Screen Option 1 -

Add All Watersheds

Click the Select Watersheds button. A popup menu
will display with a list of watershed IDs that can be
selected for the screening.

Select Watersheds

Select watersheds to include in the screening by clicking the Select
Watersheds button below. To ciearyour selections, click the Clear
Watershed Selections button.

« HUC12 C HUC14

Select Wafers/reds

Clear V&tershed Selections

HUC12 ID

Select Watersheds...

• Select from list of watersheds

Select watersheds to include in your screening by highlighting their names in the box
below and clicking the Add Selected Watersheds button.

Or click the Add All Watersheds button to select all watersheds for your screening.

020200070101	(Lake Mohawk-Wallkill River)

020200070102	{Papakating Creek)

020200070103	(Beaver Run-Wallkill River)

020200070104	(Quarryville Brook-Wallkill River)

020200070201	(Upper Wawayanda Creek)

020200070202	(Lower Wawayanda Creek)

020200070203	(Upper Pochuck Creek)

020200070206	(Rutgers Creek)

020200070207	(Lower Pochuck Creek-Wallkill River)

020301010404	(Sparkill Creek-Hudson River)

020301010405	(East River-Hudson River)

020301030101	(Upper Wanaque River)

020301030102	(Ringwood River)

020301030103	(Lower Wanaque River)

020301030203	(Mahwah River)

020301030204	(Middle Ramapo River)

020301030205	(Lower Ramapo River)

020301030301	(Upper Whippany River)

020301030302	(Troy Brook)

020301030303	(Lower Whippany River)

Click the Add All Watersheds button. This will select
all watersheds for the screening by adding the full list
of watershed IDs to column A of the Setup worksheet.

Add Selected Watersheds

Add AS Watersheds

i Named Subset from the HUC_Subsets Sheet;

Select from a subset of watersheds by selecting the subset of interest from the drop-*
down menu and clicking the Added Selected Subset button. This option is only available^
one of more watershed subsets have been defined on the HUC_Subsets worksheet.

?lected Sub

Select Watersheds

Select watersheds to include in the screening by clicking the Select
Watersheds button below. To ciearyour selections, click the Clear
Watershed Selections button.

HUC12	HUC14

Select Watersheds

Clear Watershed Selections

HUC12 ID

020200070101 (Lake Mohawk-Wallkill River)

020200070102 (Papakating Creek)

020200070103 (Beaver Run-Wallkill River)

020200070104 (Quarryville Brook-Wallkill River;

9

-------
Setup Worksheet-Select Watersheds to Screen

Select Watersheds to Screen Ootion 2 -

Select Watersheds Individual!

Click the Select Watersheds button. A popup menu
will display with a list of watershed IDs that can be
selected for the screening.

^	r:

IL

Select Watersheds

Select watersheds to include in the screening by clicking the Select
Watersheds button below.To clear your selections, dick the Clear
Watershed Selections button,

« HUC12 r HUC14

Select Watersheds

Clear Vtetershed Selections

HUC12 ID

In the popup menu, highlight the watersheds you
would like to include in your screening by clicking on
their IDs/names.

Multiple watersheds can be highlighted by dragging
the mouse cursor down or by holding the Ctrl key and
then clicking on each watershed ID individually.

Select Watersheds...

(* Select from list of watersheds

Select watersheds to include in your screening by highlighting their names in the box
below and clicking the Add Selected Watersheds button.

Or click the Add All Watersheds button to select all watersheds for your screening.

Click the Add Selected Watersheds button to add the
highlighted watersheds to the list of watershed IDs for
screening.

You still have the opportunity to select additional
watersheds after clicking the Add Selected
Watersheds button. Repeat the previous step until all
watersheds of interest have been selected for the
screening, then click the Exit button to close the
popup menu.

020200070101	{Lake Mohawk-Wallkill River)

020200070102	(Papakating Creek)

020200070103	{Beaver Run-Wallkill River)

020200070104 (Quarryville Brook-Wallkill River)

020200070201	(Upper Wawayanda Creek)

020200070202	(Lower Wawayanda Creek)

020200070203	(Upper Poehuck Creek)

020200070206	(Rutgers Creek)

020200070207	(Lower Pochuck Creek-Wallkill River)
020 301010404 (Sparkill Creek-Hudson River)

020301010405 (East River-Hudson River)

020301030101	(Upper Wanaque River)

020301030102	(Ringwood River)

020301030103	(Lower Wanaque River)

020301030203	{Mahwah River)

020301030204	(Middle Ramapo River)

020301030205	0-ower Ramapo River)

020301030301	(Upper Whippany River)

020301030302	(Troy Brook)

020301030303	(Lower Whippany River)

1

d

Add Selected Watersheds

Select fron
down men
one of mor

Select watei
Wafers/reds
Wafers/red

Add AS Watersheds

;t from the HUC Subsets Sheet

subset of watersheds by selecting the subset of interest from the drop-
nd clicking the Added Selected Subset button. This option is only available if
vatershed subsets have been defined on the HUC_Subsets worksheet.

~3

Add Selected Subset

Select Watersheds

eds to include in the screening by clicking the Setecf
utton below. To clear your selections, click the Clear
lections button.

C HUC14

HUC12

Select Watersheds

Clear Watershed Selections

HUC12 ID

020200070104 (Quarryville Brook-Wallkill River)

020200070201 (Upper Wawayanda Creek)

020200070202 (Lower Wawayanda Creek)

020200070203 (Upper Pochuck Creek)

020200070206 (Rutgers Creek)

020200070207 (Lower Pochuck Creek-Wallkill River)

020301010404 (Sparkill Creek-Hudson River)

10

-------
Setup Worksheet-Select Watersheds to Screen

Select Watersheds to Screen ODtion 3 -
Copv and Paste Watershed IDs

20200070104
9n9nnn7n9ni

To use this option, you must already have a pre-
existing list of watershed IDs to screen in a
separate worksheet or file. The list of watershed
IDs must be formatted with one ID per row.

Open the worksheet containing the pre-existing
list of watershed IDs to screen. Select the list
and click "Copy" on the Excel menu.

-------
Setup Worksheet-Select Watersheds to Screen

Select Watersheds to Screen Option 4 - Add a Watershed Subset from the HUC Subsets Sheet

To use this option, you must already have a subset of watersheds defined on the HUC_Subsets worksheet. A
subset is a list of watersheds that meet certain user-defined selection criteria, such as minimum levels of
agricultural land cover or impervious cover. See Section 13 (HUC Subsets Worksheet) of this guide for step-by-
step instructions on how to define a watershed subset.

Click the Select Watersheds button. This
displays the watershed selection popup menu.

Select Watersheds...

Select from list of watersheds

Select Watersheds

Select watersheds to include in the screening by clicking the Select
Watersheds button below. To clear your selections, click the Clear
Watershed Selections button.

ff HUC12 C HUC14

Select watersheds to include in your screening by highlighting their names in the box
below and clicking the Add Selected Watersheds button.

Or click the Add All Watersheds button to select all watersheds for your screening.

020200070101

020200070102

020200070103

020200070104

020200070201

020200070202

020200070203

020200070206

020200070207

020301010404

020301010405

020301030101

020301030102

020301030103

020301030203

020301030204

020301030205

020301030301

020301030302

020301030303

(Lake Mohawk-Wallkill River)
(Papakating Creek)

(Beaver Run-Wallkill River)
(Quarryville Brook-Wallkill River)
(Upper Wawayanda Creek)

(Lower Wawayanda Creek)

(Upper Pochuck Creek)

(Rutgers Creek)

(Lower Pochuck Creek-Wallkill River)
(Sparkill Creek-Hudson River)

(East River-Hudson River)

(Upper Wanaque River)

(Ringwood River)

(Lower Wanaque River)

(Mahwah River)

(Middle Ramapo River)

(Lower Ramapo River)

(Upper Whippany River)

(Troy Brook)

(Lower Whippany River)

Select Watersheds

Gear Watershed Selections

HUC12ID

Click the Named Subset from the HUC_Subsets
Sheet option. This activates the drop-down
menu containing the names of watershed
subsets that have been defined on the
HUC_Subsets worksheet. The drop-down menu
will be blank if you have not yet defined a
watershed subset.

belenrfomTsuDseforwatefsneasBvseleCTingTnesuDset of interest from the drop-
down menu and clicking the Added Selected Subset button. This option is only available jf_
one of more watershed subsets have been defined on the HUC_Subse;

New Jersey HUC12 Subset

Add Selected Subset

17
IS

27
23

Selectw
Wafers??
Wafers/i

Exit

Select Watersheds

ersheds to include in the screening by clicking the Se/ecf
fe button below. To clear your selections, click the Clear
I Selections button.

HUC12 HUC14

Select Watersheds

Clear Watershed Selections

HUC12 ID

020301040403

020301040404

020301040405

020302020903

020402010101

Choose the name of the watershed subset that
you would like to add to the screening.

Click the Add Selected Subset button to add the

watersheds in the subset to the list of watershed
IDs for screening. The selected subset will
appear in column A of the Setup sheet.

-------
Setup Worksheet-Select Watersheds to Screen

Advanced Tips

¦ The watershed ID list in the Select Watersheds section must begin in cell A24 of the Setup worksheet and must contain
one watershed ID per row.

¦ Watershed names alone cannot be added to the watershed ID list. Watershed names can be included in the text but
must occur after the watershed ID. For example, the Jacks River HUC12 (HUC12 ID 031501010102) can be entered as
"031501010102" or "031501010102 (Jacks River)" but not "Jacks River".

¦ When manually typing watershed IDs or copying and pasting from another worksheet, be sure that all IDs are present
in column A of the Indicator Data worksheet for the watershed scale you are screening (e.g., the HUC12_Data
worksheet HUC12 subwatersheds are being screened). The tool cannot screen watersheds that are not present in the
Indicator Data worksheet.

¦ Use the HUC Subsets worksheet to store lists of watershed IDs that will be of interest for future screenings. For
example, you can use the HUC Subsets worksheet to store lists of HUC12 IDs within each HUC8 in the Project Area.

¦ Do not omit leading zeros from watershed IDs (e.g., "04030001" cannot be entered as "4030001"). Omitting leading
zeros will cause errors in the screening run.

¦ If HUC8 watersheds are being screened, the first 8 characters in each watershed ID are used to extract indicator
values from the indicator data worksheet. Any text after the eighth character is ignored. Similarly, if HUC12
subwatersheds are being screened, only the first 12 characters in each watershed ID are used to extract indicator
values from the indicator data sheet. This concept applies across all watershed scales.

-------
Setup Worksheet-Select Indicators and Weights

3.4. Select Indicators and Weights
RPS index scores and ranks are calculated for each watershed included in a screening using ecological, stressor, and social
indicators. The choice of which indicators to use for a screening depends on the purpose of the screening and the nature
of the watersheds being screened. Thus, users should review the full list of indicators and their definitions in the Indicator
Info worksheet before selecting indicators on the Setup worksheet.

Basics

At least one ecological indicator, one stressor indicator, and one social indicator must be selected in order to perform a
Recovery Potential Screening run. Neutral indicator values are available in each category if one or more categories are not
of interest. In general, three to ten indicators per category are recommended. If too few indicators are selected, index
scores will not adequately reflect the factors influencing recovery potential. If too many indicators are selected, index
scores will reflect random noise in the indicator data rather than true patterns in recovery potential.

Indicator weights determine the relative influence of each indicator on index scores. Weights must be numeric but any
set of numeric values can be used. A typical approach is to select a certain number of weight categories (e.g., 3 = high; 2
= medium; 1 = low) and assign weights to indicators based on their relevance to the purpose of the screening and data
quality considerations.

Two options are available for selecting indicators and weights on the Setup worksheet. Step-by-step instructions for each
option are provided on the following pages.

-------
Setup Worksheet - Select Indicators and Weights

Select Indicators and Weights Option 1 - Select

from Popup Menu

Click on the Select Ecological Indicators button. A
popup menu will display a list of ecological
indicators that can be selected for the screening.

By default, the list will include all ecological
indicators that are available for the screening.
Users can filter the list to display groups of
indicators by subcategory. Example subcategories
include forest cover or wetland cover.

To filter the list by subcategory, select the
subcategory of interest from the drop-down
menu.

Highlight the indicators you would like to
include in your screening by clicking on their
name.

Double-clicking an indicator name will display a
popup box with its description.

Click the Add Selected Indicators button to add
the highlighted indicators to the list of
indicators selected for the screening.

You still have the opportunity to select
additional indicators after clicking the Add
Selected Indicators button. Repeat the previous
step until all indicators of interest have been
selected for the screening then click the Exit
button to close the popup menu.

Select Ecological Indicators

Select ecological indicators to include in the screening by clicking the
Select Ecological Indicators button below. To cfear your selections, click
the Clear Ecological Indicator Selections button.

Select Ecological Indicators

Clear Ecological Indicator Selections

Ecological Indicator

Weight

Select Ecological Indicators... X

Use this menu to select Ecological indicators for your screening.

By default, the box below displays a list of all Ecological indicators available for screening. To
view smaller groups of indicators, choose an indicator subcategory from the drop-down list

Double-dick any indicator name in the box to view its description.

% Forest in WS (2016)
% Forest in HCZ (2016)

% Forest in RZ (2016)

% Forest Change in WS (2001-16)
% Forest Change in HCZ (2001-16)

% Forest Change in RZ (2001-16)

% Forest Remaining in WS

Add Selected Indicators

By default, indicators selected from the popup
menu will be assigned a weight of 1.

Indicator weights can be adjusted by placing the
cursor on the cell containing the weight and
typing in a new weight.

Repeat these steps in the Select Stressor Indicators section to select stressor indicators and weights and again in
the Select Social Indicators section to select social indicators and weights.

Selectee
Select Ec
the Clear

Select Ecological Indicators

igical indicators to include in the screening by clicking the
ogical Indicators button below. To clear your selections, dick
eological Indicator Selections button.

Select Ecological Indicators

. Clear Ecological Indicator Selections

Ecological Indicator

IVRflTI

% Woody Vegetation (2006) in Riparian Zone

% Natural Cover. N-index1 (2006) in Watershed

NFHAP Habitat Condition Index

-------
Setup Worksheet - Select Indicators and Weights

Select Indicators and Weights Option 2 -

Codv and Paste Indicator List

To use this option, you must already have a
pre-existing list of ecological indicator names
and weights stored in a separate worksheet
or file. The pre-existing indicator list must be
formatted with one indicator per row, with
the indicator name in the first column and
the indicator weight in the second column.

Open the worksheet with the pre-existing
indicator list. Select the indicator names and
weights and click "Copy" on the Excel menu.

% N-lndexl in WS(2011)

Soil Stability, Mean in WS

% National Ecological Framework (NEF) in WS (2001)

2
1
1

* Format Painter
Clipboard r,

Select Ecological Indicators

Select ecological indicators to include in the screening by clicking the
\ Select Ecological Indicators button below. To clear your selections, click
the Clear Ecological Indicator Selections button.

Select Ecological Indicators
Clear Ecological Indicator Selections

FmkMiiral Indicator

Select "Paste Values" from the Excel
menu to paste the ecological indicators
and weights into the Select Ecological
Indicators section.

3d a «5- <*

FILE

| Home

ApJ

.X) Cut

Paste

£[=) Copy -

•

Format Pain

Go back to the Setup worksheet and set the
cursor to cell C24 (the first cell of the indicator
list in the Ecological Indicators section).

Select Ecological Indicators

Select ecological Indicators to Include in the screening by dicking the
Select Ecological Indicators button below. To clear your selections, dick
the Clear Ecological Indicator Selections button.

Select Ecological Indicators

Clear Ecological Indicator Selections

% N-lndex1 in WS (2011)

Ecological Indicator

Soil Stability. Mean in WS

% National Ecological Framework (NEF) in WS (2001)

Weight

Repeat these steps in the Select Stressor Indicators section to select stressor indicators and weights and again in
the Select Social Indicators section to select social indicators and weights.

-------
Setup Worksheet-Select Indicators and Weights

Advanced Tips

¦ The Ecological Indicator list must begin in cell C24 of the Setup worksheet and must contain one indicator per row.

¦ The Stressor Indicator list must begin in cell G24 of the Setup worksheet and must contain one indicator per row.

¦ The Social Indicator list must begin in cell K24 of the Setup worksheet and must contain one indicator per row.

¦ The Ecological, Stressor, and Social Indicator lists must be continuous (no blank rows). If blank rows are present, any
indicators below the first blank row will not be included in the screening.

¦ When viewing the lists of available Ecological, Stressor, and Social indicators, remember that the lists can be filtered
to only display indicators within a subcategory of interest. When selecting indicators in multiple subcategories, users
should click the Add Selected Indicators button before changing to a different subcategory.

¦ When copying and pasting from another worksheet, be sure that indicator names exactly match names in the header
row (row 7) of the Indicator Data worksheet for the selected watershed scale (e.g., the HUC12_Data worksheet if
HUC12 subwatersheds are being screened). Any differences in indicator spelling, capitalization, or whitespace will
result in errors when the screening is run.

¦ Indicator weights can be set to zero. A weight of zero means that the indicator has no effect on index scores.

¦ Indicator weights can be set to negative values. A negative weight will reverse the directional effect of the indicator
on index scores. The standard directionality is for larger indicator values to increase Ecological Index, Stressor, and
Social Index scores. A negative weight will reverse directionality so that smaller values increase Ecological Index,
Stressor, and Social Index scores.

¦ For ecological indicators, higher numbers correspond to healthier conditions; for stressor indicators, higher numbers
indicate greater stress on watershed processes and aquatic ecosystems; for social indicators, higher numbers
correspond to more favorable characteristics for watershed prioritization.

¦ Indicator selections within each category (Ecological, Stressor, and Social) should be topically diverse. A diverse set of
indicators will reflect a range of factors relevant to recovery potential rather than one single topic.

¦ Users may want to consider numeric redundancy as part of the indicator selection process. Non-redundant indicators
can be identified by examining correlation coefficients between indicator pairs.

¦ Up to 20 indicators can be selected in each category.

-------
Setup Worksheet-Run Screening Button

3.5. Run Screening Button
Basics

After selecting watersheds, indicators, and weights for your screening, use the RUN SCREENING button to auto-calculate
Ecological Index, Stressor Index, Social Index, and Recovery Potential Integrated (RPI) Index scores for each watershed.
Clicking the RUN SCREENING button will populate other worksheets in the RPS Tool with screening results. Any results
from previous screenings will be cleared from other worksheets in the RPS Tool when the RUN SCREENING button is
clicked.

When the RUN SCREENING button is clicked from the Setup worksheet, the tool will first check to verify that
watersheds, indicators, and weights have been selected by the user. The tool will then look for potential issues
with indicator data.

If no data issues are found, index scores will be automatically calculated and screening results will be added to
other worksheets in table, plot, and map form. If indicators data issues are identified, a warning message will
appear. Indicator data warnings are described in the next section.

RUN SCREENING

RESET SCREENING

^^selectwatersnea^^

Select watersheds to indude In the screening by clicking the Se/ect
Watersheds button below. To clear your selections, click the Clear
Watershed Selections button.

Select Ecological Indicators

Select ecological indicators to include in the screening by clicking the
Select Ecological Indicators button below. To clear your selections, click
the Clear Ecological Indicator Selections button.

HUC12 HUC14

Select Watersheds

Select Ecological Indicators

Clear Watershed Selections

Clear Ecological Indicator Selections

HUC12ID

Ecological Indicator

Weight

|020200070101 (Lake Mohawk-Wallkill River)

% Woody Vegetation in RZ (2016)

020200070102 (Papakating Creek)

% N-lndex2 in HCZ(2016)

; 020200070103 (Beaver Run-Wallkill River)

Soil Stability. Mean in HCZ

020200070104 (Quarryville Brook-Wallkill River)

Habitat Condition Index WS (2015)

020200070201 (Upper Wawayanda Creek)

020200070202 (Lower Wawayanda Creek)

020200070203 (Upper Pochuck Creek)

020200070206 (Rutgers Creek)

; 020200070207 (Lower Pochuck Creek-Wallkill River)

020301010404 (Sparkill Creek-Hudson River)

020301010405 (East River-Hudson River)

020301030101 (Upper Wanaque River)

020301030102 (Ringwood River)

020301030103 (Lower Wanaque River)

020301030203 (Mahwah River)

020301030204 (Middle Ramapo River)

020301030205 (Lower Ramapo River)

020301030301 (Upper Whippany River)

Select Stressor indicators

Select stressor indicators to include in the screening by clicking the Select
Stressor Indicators button below. To clear your selections, click the Clear
Stressor Indicator Selections button.

Select Stressor Indicators

Clear Stressor Indicator Selections

Stressor Indicator

Weight

% Developed, Low Intensity in WS (2016)

% Agriculture in WS (2016)

% Streamlength Near a 15% Impervious Cover (2016)

Synthetic Nitrogen Fertilizer Application in WS

Impaired Waters Cause Count (2021)

Nutrient Impaired Waters. % of WS (2021)

Select Social Indicators

Select social indicators to include in the screening by clicking the Select
Social Indicators button below. To clear your selections, click the Clear
Social Indicator Selections button.

Select Social Indicators

Clear Social Indicator Selections

Social Indicator

Weight

% Protected Land, All Types (2019)

Nonpoint Control Projects Count

Assessed Waters, % ofWS (2021)

Waters with TlvlDLs Count (2021)

Microsoft Excel

Screening Successfully Run!

Go to the Results, Bubble_Plot, and Map worksheets to view screening
run output.

After auto-calculating index scores and populating
worksheets with the screening results, a message
box will appear to notify you that your screening
successfully ran to completion.

If your screening includes several thousand
watersheds, processing times of up to 1 minute can
be expected before the message box appears.

Click OK and then proceed to other worksheets to
review screening results.

-------
Setup Worksheet-Run Screening Button

Advanced Tips

¦ After clicking the RUN SCREENING button an error message may appear. A screening will not successfully run to
completion and an error message will be displayed if any of the following errors occur:

Watersheds, indicators, and/or weights are not specified.

One or more watershed IDs entered in the Select Watersheds section do not have an exact match in column
A of the Indicator Data worksheet for the watershed scale you are screening (e.g., the HUC12_Data worksheet
if HUC12 subwatersheds are being screened).

One or more indicator names entered in the Select Ecological Indicators, Select Stressor Indicators, or Select

Social Indicators sections do not have an exact match in the header row of the Indicator Data worksheet (e.g.,
the HUC12_Data worksheet if HUC12 subwatersheds are being screened).

One or more of the indicators selected for the screening contain non-numeric data in the Indicator Data
worksheet. Indicator data must be numeric (blank cells are allowed for missing data).

-------
Setup Worksheet-Respond to Warnings

3.6. Respond to Warning Messages
Basics

After clicking the RUN SCREENING button on the Setup worksheet, the tool will automatically check for potential issues

with indicator data, including:

¦ Missing indicator values. In most cases, each indicator will have a numeric value for every watershed selected for the
screening in the Indicator Data worksheet. However, indicator values may be missing for one or more watersheds.
Missing indicator values are denoted as blank cells in the Indicator Data worksheet. If a watershed is missing indicator
values, then RPS index scores for that watershed will be calculated from non-missing indicators only. In rare cases, a
watershed will be missing values of all ecological, stressor, and social indicators selected for the screening. If a
watershed is missing values for all indicators, RPS index scores cannot be calculated for that watershed.

¦ Equal-value indicators. Equal value indicators are indicators that have the same exact value for every watershed
selected for the screening. Equal value indicators therefore provide no information on recovery potential differences
between watersheds. RPS index calculations are based on the assumption that indicator values vary between
watersheds and cannot be applied to equal value indicators. An equal-value indicator can be included in a screening
but normalized values of the equal-value indicator are set to 0.5 for all watersheds to prevent index calculation errors.

After clicking the RUN SCREENING button, a message box will appear if the tool finds any indicator data issues.
The warning message will notify users if missing indicator data or equal-value indicators were found and will list
the names of indicators with issues. Users have the option to continue the screening by clicking Yes on the
message box or to stop the screening to adjust indicator selections by clicking No.

Warnings

One or more watersheds in this screening run are missing values in the
HUC12_Data sheet for7 indicator(s):

•Soil Stability, Mean in HCZ

•% Streamlength Near = 15% Impervious Cover (2016)

•Assessed Waters, % of WS (2021)

•Habitat Condition Index WS (2015)

•Waters with TMDLs Count (2021)

•Impaired Waters Cause Count (2021)

•Nutrient Impaired Waters, % of WS (2021)

Index scores for these watersheds will be calculated from non-missing
indicators only,

Do you still want to run this screening?

Yes

-------
Setup Worksheet-Respond to Warnings

Advanced Tips

¦ Users can remove indicators with missing values or equal-value indicators by clicking No on the warning message box
and deleting the names of indicators from the Select Ecological Indicators, Select Stressor Indicators, and/or the
Select Social Indicators sections.

¦ Decisions on whether to remove indicators with missing values can be based on the number of watersheds with
missing data. Missing indicator values are denoted as blank cells on the indicator data worksheet. As the number of
watersheds with missing data increases, the value of the indicator for describing recovery potential differences
between watersheds decreases. If most of the watersheds selected for screening are missing values of an indicator, it
is likely advantageous to remove that indicator from the screening, particularly if it can be replaced with another
indicator with a more complete record that describes a similar watershed characteristic.

¦ Equal-value indicators should be removed from a screening since they provide no information on recovery potential
differences between watersheds. The exception is when a user intentionally selects an equal-value indicator as the
only indicator for one of the Ecological, Stressor, or Social groups to evaluate the effect on RPI index scores. For
example, selecting an equal-value indicator as the only Social indicator will nullify the effect of Social Index scores on
the RPI Index since all watersheds will receive an equal Social Index score.

-------
Setup Worksheet-Reset Screening Button

3.7. Reset Screening Button
The RESET SCREENING button on the Setup worksheet can be used to produce a "clean slate" version of the RPS Tool. Do
not click the RESET SCREENING button unless you have saved the current screening setup and results under a separate
filename or you are sure you do not want to store the current screening setup and results for future use.

Clicking the RESET SCREENING button will clear all

watershed and indicator selections from the Setup worksheet

and any screening results stored on other worksheets. The only worksheets not affected are the Indicator Data

worksheets (e.g., HUC12_Data).

—-l

RUN SCREENING

RESET SCREENING

Select Watersheds

Select watersheds to include in the screening by clicking the Select
Watersheds Button below. To clear your selections, dick the Clear
Watershed Selections button.

Select Ecological Indicators

Select ecological indicators to include in the screening by clicking the
Select Ecological Indicators button below. To clear your selections, dick
the Clear Ecological Indicator Selections button.

Select Stressor Indicators

Select stressor indicators to indude in the screening by dicking the Select
Stressor Indicators button below. To dear your selections, dick the Clear
Stressor Indicator Selections button.

Select Social Indicators

Select sodal indicators to include in the screening by dicking the Select
Social Indicators button below. To clear your selections, dick the Clear
Social Indicator Selections button.

HUC12 C HUC14

Select Watersheds

Select Ecological Indicators

Select Stressor Indicators

Select Social Indicators

Clear Watershed Selections

Clear Ecological Indicator Selections

Clear Stressor Indicator Selections

Clear Social Indicator Selections

HUC12 ID

Ecological Indicator

Weight

Stressor Indicator

Weight

Social Indicator

Weight

|020200070101 (Lake Mohawk-WaBMII River;

% Woody Vegetation in RZ (2016)

% Developed, Low Intensity in WS (2016)

% Protected Land, All Types (2019)

! 020200070102 (Papakating Creek)

% N-lndex2 in HCZ (2016)

% Agriculture in WS (2016)

Monpoint Control Projects Count

1020200070103 (Beaver Run-Wallkill River)

Soil Stability, Mean in HCZ

% Streamlength Near a 15% Impervious Cover (2016)

Assessed Waters, % of WS (2021)

020200070104 (Quarr>ville Brook-WaHWII River;

Habitat Condition Index WS (2015)

Synthetic Nitrogen Fertilizer Application in WS

Waters with TMDLs Count (2021)

1020200070201 (Upper Wawayanda Creek)

Impaired Waters Cause Count (2021)

; 020200070202 (Lower Wawayanda Creek)

Nutrient Impaired Waters, % ofWS (2021)

020200070203 (Upper Poctiuck Creek)

020200070206 (Rutgers Creek)

020200070207 (Lower Pochuck Creek-Wallkill River)

' -

020301010405 (East River-Hudson River)

020301030101 (Upper Wanaque River)

020301030102 (Ringwood River)

020301030103 (Lower Wanaque River)

020301030203 (Mahwah River)

020301030204 (Middle Ramapo River)

020301030205 (Lower Ramapo River)

1020301030301 (Upper Whippany River)

| INSTRUCTIONS Notes Setup Results Bubble.Plot Bubble_Plot_Options HUC12_Map HUC12_Data

HUC14_Data Indicatorjnfo HUC_Subsets | Addjndicators

! [

n I

-------
Notes Worksheet

4. Notes Worksheet

The Notes worksheet provides users with a space to document information related to their screening run, including a
screening run name, screening objectives, watershed scale screened, and notes on indicator selection and weighting.

Filling the Notes worksheet is optional, its contents are not used in any of the auto-calculation methods in the RPS Tool.

Screening Run Name:

New Jersey Urban/Suburban Nutrient Screening

Objectives:

Identify New Jersey HUC12s with significant urban/suburban sources of
nutrients that are restoration priorities

Watershed Scale:

HUC12

Indicator Selection Notes;

Focus on indicators relevant to recovery from urban/suburban sources of nutrients.

INSTRUCTIONS I Notes I Setup j Results Bubble_Plot Bubble_Plot_Options HUC8_Map

-------
Results Worksheet- Overview

5. Results Worksheet
5.1. Overview
Basics

The Results worksheet displays a table of Ecological Index, Stressor Index, Social Index, and Recovery Potential Integrated
(RPI) Index scores and ranks for each watershed selected for screening. Also displayed are values of the ecological,
stressor, and social indicators selected for the screening. All base indicator values are also displayed to allow for sorting
or filtering according to base indicator values.

Index scores and ranks are automatically calculated and added to the Results worksheet after clicking the RUN SCREENING
button on the Setup worksheet. Watersheds are displayed in the same order as they are entered in the Select Watersheds
section of the Setup worksheet.

Ecological Index, Stressor Index, and Social Index scores are calculated as the average of weight-adjusted, normalized
indicator values. RPI scores are calculated from Ecological Index, Stressor Index, and Social Index scores. Index scores can
be interpreted using the following guidelines:

¦ Higher Ecological Index scores correspond to higher recovery potential.

¦ Lower Stressor Index scores correspond to higher recovery potential.

¦ Higher Social Index scores correspond to higher recovery potential,

¦ Higher RPI Index scores correspond to higher recovery potential.

Watershed ID -

Watershed Name

Ecological Index -

Ecological Rank -

Stressor Index -

Stressor Rank -

Social Index I -

Social Rank -

RPI Score -

RPI Rank -

,020200070101

Lake Mohawk-Wallkill River

44.87

107

9.61

33.24

141

56.17

^20200070102

Papakating Creek

39.90

152

25.99

139

38.13

50.68

125

rt)20200070103

Beaver Run-Wallkill River

38.35

165

11.87

31.57

196

52.69

102

[1)20200070104

Quarryville Brook-Wallkill River

48.88

14.05

35.40

107

56.74

^20200070201

Upper Wawayanda Creek

45.38

104

8.89

31.59

195

56.03

^20200070202

Lower Wawayanda Creek

43.97

119

22.58

114

36.10

100

52.50

103

[&20200070203

Upper Pochuck Creek

38.91

159

24.17

122

7.57

270

40.77

232

fb20200070206

Rutgers Creek

36.79

179

11.22

27.83

259

51.13

123

1)20200070207

Lower Pochuck Creek-Wallkill River

38.68

162

22.41

112

6.59

271

40.95

229

fb20301010404

Sparkill Creek-Hudson River

15.97

258

25.54

136

27.60

260

39.34

242

[1)20301010405

East River-Hudson River

17.07

255

44.95

244

35.24

110

35.79

256

1)20301030101

Upper Wanaque River

41.60

142

9.93

36.83

56.17

t)20301030102

_ 44.75

111

3.27

38.77

60.09

Setup 1 Results

I Bubble.Plc

t 8ubble

_Plot_Option

s j huci;

!_Map

HUC8_Data

huci

l2_Dat a

Advanced Tips

The formula used to calculate each weight-adjusted normalized indicator value is:

(Ind I ux.l ¦)
hid Norm = Weight * _ j j 7

yinuMax >nuMin)

where lndNorm is the weight-adjusted normalized indicator value, weight is the indicator weight, Ind is the raw indicator
value, lndMin is the minimum indicator value for watersheds selected for screening, and lndMax maximum indicator
value for watersheds selected for screening.

RPI scores are calculated from Ecological Index, Stressor Index, and Social Index scores using the formula:

[Ecological Index + Social Index + (100 — Stressor Index)]
~ 3

Ecological Index, Social Index, and RPI Index ranks are determined by sorting index scores from highest to lowest (i.e.,
the watershed with the highest Ecological Index score receives a rank of 1).

Stressor Index ranks are determined by sorting index scores from lowest to highest (i.e., the watershed with the lowest
Stressor Index score receives a rank of 1).

-------
Results Worksheet-Sort and Filter

5.2. Sort and Filter

By default, the Results table displays indicator data and index scores for all watersheds included in the screening and
sorted by watershed ID. Users can sort the Results table based on values in any column in the table (e.g., from highest to
lowest Ecological Index score). Users can also filter the Results table to only display watersheds that meet certain criteria
(e.g., watersheds within a particular ecoregion).

To sort the Results table, right-click on the
name of the column that you would like to use
for sorting. Scroll to Sort in the popup menu
and select a sorting option.

EcoRegton (2010) Level 3,1st Code (Largest Area)

21 Sort Smallest to Largest

a! Sort Largest to Smallest
Sort by Color

Number Filters
I Search

I 0 (Select Alt)

065

066

067

068
|' 069
!•¦ 071
[-073

1,0 74

Is. Dirtarian 7nno IP7I in

Cut

M'atershed -

67705639

75266778

56091445

58351704

63491534

06067519

03809443

60551596

23969159

23682768

60131782

55719195

61391447

08013937

S Hydrologically Connecti

~ 43142814

~ Sort A to Z

JJ, Sfirt Z to A

Put Selected Cell Color On Top
Put Selected Font Color On Top
Put Selected Cell Icon On Top
fit] Custom Sort...

. ..juoot r iuj

To filter the Results table, click the drop-down
arrow next to the column you would like to use
to filter and select a filter option.

-------
Bubble Plot Worksheet

6. Bubble Plot Worksheet

The Bubble Plot worksheet contains a bubble plot that displays RPS results.

The Bubble Plot is automatically created when the RUN SCREENING button is clicked on the Setup worksheet. It contains
one "bubble" for each watershed selected for screening, with the Stressor Index score plotted on the horizontal (x) axis,
Ecological Index score plotted on the vertical (y) axis, and Social Index plotted as the bubble size. Larger bubbles have
higher Social Index scores relative to smaller bubbles.

The bubble plot can be customized using controls on the Bubble Plot Options worksheet.

The bubble plot displays Ecological Index, Stressor Index, and Social Index scores for watersheds included in your
screening. Hover over any bubble with your mouse cursor to view a popup information box with index scores and
ranks for that watershed.

Falling Water River Upper (051301080702)

Ecological Index: 17

Stressor Index: 59

Social Index: 24

RPI Score: 27.216

RPI Rank: 48

Oo CP °

O
o

40 50 60

Stressor Index

Note: Circle size increases with Social Index score

100

Setup Results I Bubble_Plot I Bubble_Plot_Options HUC12_Map | HUC8_Data | HUC12_Data

-------
Bubble Plot Options Worksheet- Overview

7. Bubble Plot Options Worksheet
7.1. Overview

The Bubble Plot Options worksheet provides users the ability to customize the Bubble Plot worksheet that displays
screening results.

10 | REPOSITION AXES

By default, axes cross at the median of Ecological Index (horizontal axis)

11 and Stressor Index (vertical axis) scores listed in the Summary_Scores
\ sheet Axes can be repositioned to:

hJ[

13 1

15 This option will position axes to percentiles entered below.

16 I

17 I Enter a new Stressor Index percentile for the y-axis (0-100):

18 j "sol

19 | Enter a new Ecological Index percentile for the x-axis (0-100):

20 501

22 I

23 J

REPOSITION AXES

RESET AXES

24 I SELECT SCREENING TO PLOT

2511f your screening focuses on a subset of watersheds from the project

26 | area, you may want to know if Ecological and Stressor Index scores for

27 your subset are generally above or below average for the project area.

28 | Clicking the ALL WATERSHEDS SCREENING option below will plot

29 scores from a screening that includes all watersheds in the project

30 jarea, with axes set to the median of all Ecological and Stressor Index

31 | scores. Clicking the SUBSET ONLY SCREENING option will return to

32 Ithe default option of plotting scores from the screening that only

33 includes those watersheds selected on the Setup sheet

G SUBSET ONLY SCREENING
C ALL WATERSHEDS SCREENING

ADD LABELS TO BUBBLES

Select a watershed identifier for labeling:

Watershed Name

Clickthe button below to label all bubbles:
ADD ALL LABELS I

Or, select watersheds individually from the list
below (repeat to label multiple watersheds):

r Highlight Selected Watershed

Label locations can be changed by clicking on tt
label in the bubble plot and dragging to the
desired location.

Clickthe button below to remove labels and
highlighting:

REMOVE LABELS I

EDIT BUBBLE SIZES

Enter a bubble size (1 - 300):

The default bubble size is 20.

Clickthe button below to resize:
RESIZE BUBBLES |
RESET BUBBLE SIZES I

SAVE AS IMAGE FILE

Clickthe button below to save the
bubble plot as an image (.jpg) file:

SAVE BUBBLE PLOT

HIGHLIGHT BUBBLES

Clickthe button below to select
watersheds to highlight on the bubble
plot: ,

HIGHLIGHT BUBBLESl

Setup Results Bubble.Plot I Bubble.Plot.Options |HUC12_Map HUC8_Data HUC12_Data

EDIT BUBBLE COLORS
Select Indicator for Adjusting Colors |

Select a classification method:
Select the number of classes:
Select a color scheme:

Clickthe button below to update bubble colors:
UPDATE BUBBLE COLORS

Clickthe button below to reset bubble colors:

RESET BUBBLE COLORS

The following sections provide step-by-step instructions for how to use the Bubble Plot Options worksheet to:

¦ Reposition Plot Axes

m Toggle Between Plotting a Subset Only Screening or an All Watersheds Screening

m Add Labels to Bubbles

m Edit Bubble Sizes

m Edit Bubble Colors

m Highlight Bubbles

m Save an Image File of the Bubble Plot

-------
Bubble Plot Options Worksheet-Reposition Axes

7.2. Reposition Axes

The horizontal axis and vertical axis of the Bubble Plot can be set to any user-defined position.

By default, the horizontal axis is positioned at the median of Ecological Index scores for the active screening and the
vertical axis is positioned at the median of Stressor Index scores.

Users have two options for repositioning Bubble Plot axes:

¦ Reposition to new index percentiles - Under this option, users can reposition axes to any desired percentile of
Ecological Index and Stressor Index scores (25th percentile, 75th percentile, etc.);

¦ Reposition to specific index scores - Under this option, users can reposition axes to any desired Ecological and Stressor
Index score (e.g., index scores of 50).

Reposition Axes Option 1 -

Reposition to New Percentiles

To reposition axes to new percentiles, select
the "User-Defined Percentiles" option from the
drop-down menu in the Reposition Axes
section of the Bubble Plot Options worksheet.

Then enter new a new Stressor Index percentile
for the vertical axis and a new Ecological Index
percentile for the horizontal axis in the
designated cells.

REPOSITION AXES
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:

| (a) User-Defined Percentiles

This option will position axes to percentiles entered below.

Enter a new Stressor Index percentile for the y-axis (0-100):

Enter a new Ecological Index percentile for the x-axis (0-100):

REPOSITION AXES

RESET AXES

Enter a new Stressor Index percentile for the y-axis (0-100):

75!

Enter a new Ecological Index percentile for the x-axis (0-100):
75l

Reposition Axes Option 2 -

Reposition to Specific Index Scores

To reposition axes to specific index scores,
select the "User-Defined Index Scores" option
from the drop-down menu in the Reposition
Axes section of the Bubble Plot Options
worksheet.

Then enter new Stressor Index score for the
vertical axis and a new Ecological Index score
for the horizontal axis in the designated cells.

REPOSITION AXES

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:

| (t>) User-Defined Index Scores *]

This option will position axes to Index Scores entered below.

Enter a new Stressor Index score for the y-axis (0-100):

Enter a new Ecological Index score for the x-axis (0-100):

REPOSITION AXES

RESET AXES

Enter a new Stressor Index score for the y-axis (0-100):
40

Enter a new Ecological Index score for the x-axis (0-100):
60l

After entering new index percentiles or scores,
click the REPOSITION AXES button.

Axes on the Bubble Plot will be automatically
moved to the new index percentiles or scores.

RESET AXES

— REPOSITION AXES

To move Bubble Plot axes back to their default
position, click the RESET AXES button.

-------
Bubble Plot Options Worksheet-Toggle Screening to Plot

7.3. Toggle Screening to Plot
By default, the Bubble Plot displays Ecological Index, Stressor Index, and Social Index scores listed in the Summary Scores
worksheet. These scores are derived from indicators that are normalized to minimum and maximum values for the subset
of watersheds included in the screening. Index scores are therefore relative rather than absolute, they depend on the
subset of watersheds selected for screening. A given watershed will have two different sets of index scores for two
screenings that include different groups of watersheds.

Users may be interested in how the subset of watersheds selected for screening compares to all other watersheds in the
Project Area. For example, users may want to know whether ecological conditions in the screened subset are above- or
below-average for the Project Area as a whole. Such questions can be answered by running the same screening on all
watersheds in the Project Area and then reviewing the resulting index scores for the watershed subset of interest. To
streamline this process, the RPS Tool allows users to view an alternate version of the bubble plot with index scores that
result from a screening that includes all watersheds in the Project Area. This can be done on-the-fly in the Select Screening
to Plot section of the Bubble Plot Options worksheet without adjusting settings on the Setup worksheet or creating a new
file.

The Select Screening to Plot section contains option buttons to toggle between a "Subset Only" screening or an "All
Watersheds" screening. A "Subset Only" screening includes only those watersheds selected for screening on the Setup
worksheet. An "All Watersheds" screening includes all watersheds in the Project Area. Note that if you selected all
watersheds in the Project Area on the Setup worksheet then there is no difference between the two options.

SELECT SCREENING TO PLOT

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.

(? 'SUBSET ONLY SCREENING

c all watersheds screening

By default, the Bubble Plot displays index scores resulting from "Subset Only" screening.

Click the ALL WATERSHEDS SCREENING option button to view index scores resulting from a screening that
includes all watersheds in the Project Area. The Bubble Plot worksheet will automatically update with new index
scores for the "All Watersheds" screening.

If you have viewed bubble plot for the "All Watersheds" screening and want to return to the "Subset Only"
screening bubble plot, click the SUBSET ONLY SCREENING button. The Bubble Plot worksheet will automatically
update with index scores for the "Subset Only" screening.

-------
Bubble Plot Options Worksheet-Label Bubbles

7.4. Label Bubbles

Bubbles in the Bubble Plot worksheet can be labeled to identify one or more watersheds. Bubbles can be labeled with the
watershed name or the watershed ID. Users also have the option to highlight labeled bubbles to make them stand out
from other unlabeled bubbles.

Basics

To label bubbles, first select a label option from

the drop-down menu in the Add Labels to

Bubbles section of the Bubble Plot Options

worksheet.

Users can choose to have labels display

watershed names or watershed IDs.

ADD LABELS TO BUBBLES

Select a watershed identifier for labeling:

Click the button below to label all bubbles:
ADD ALL LABELS

Or. select watersheds individually from the list
below (repeat to label multiple watersheds):

V Highlight Selected Watershed

Note: To hightlight the watershed, the box above must be
checked BEFORE selecting from the drop-down Bst

Label locations can be changed by clicking on the
label in the bubble plot and dragging to the
desired location

Click the button below to remove labels and
highlighting:

REMOVE LABELS I

Add Labels Option 1 - Label All Bubbles

If you would like to add labels to all bubbles on the Bubble
Plot worksheet, click the ADD ALL LABELS button. Labeling all

Click the button below to label all bubbles:
_ ADD ALL LABELS

bubbles is generally not recommended if your screening
includes more than 20 watersheds.

-------
Bubble Plot Options Worksheet-Label Bubbles

Add Labels Option 2 - Label Bubbles Individuall

To label individual bubbles in the Bubble Plot, select the
watershed to label from the drop-down menu in the Add
Labels to Bubbles section of the Bubble Plot Options

worksheet. Watersheds names are displayed in the drop-
down menu alphabetically from A to Z. Watershed IDs are
displayed in ascending numerical order.

To highlight the labeled bubble, check the Highlight Selected
Watershed box before selecting a watershed from the drop-
down menu.

Or, select watersheds individually from the list
below (repeat to label multiple watersheds):

Fall Creek

Falling Water River Headwaters
Falling Water River Lower
Falling Water River Middle
Falling Water River Upper
Glade Creek
Hickman Creek
Indian Creek

20
10

90
80
70
60

30
20
10
0

to.

(

» _

_yws~\ )

r__ 11

. . - '

m J

rait creek

•

m> R Highlight Selected Watershed

A label will be automatically added to the
bubble for the selected watershed.

10 20

30 40 50 60 70 80
Stressor Index

Note: Circle size increases with Social Index score

^86

"V*1

§ ^

,-TV.

p_ii

•

Fall Creek
#-

PrZ.

The labeled bubble will also be highlighted if
the Highlight Selected Watershed box is

checked when selecting the watershed from
the drop-down menu.

SO 60

Stressor Index

REMOVE LABELS

To remove labels from the Bubble Plot, click the
REMOVE LABELS button. This will also remove

any highlighting from labeled bubbles.

-------
Bubble Plot Options Worksheet-Label Bubbles

Advanced Tips

Label text, formatting, and position can be edited manually after labels are added.

To edit label text, click on the label in the Bubble Plot worksheet and revise the text as desired

To edit label formatting (font size, color, etc.) click on the label in the Bubble Plot worksheet and use Excel's font
formatting menu.

To edit the position of a label, click on the label in the Bubble Plot worksheet and drag it to the desired location.

-------
Bubble Plot Options Worksheet - Edit Bubble Sizes

7.5. Edit Bubble Sizes

The size of each bubble in the Bubble Plot is based on the Social Index score for the corresponding watershed (i.e., bubbles
for watersheds with higher Social Index scores are larger than bubbles for watersheds with lower Social Index scores).

While users cannot adjust the size of an individual bubble, they can collectively increase or decrease the size of all bubbles
to improve the look of the Bubble Plot.

A common reason for editing bubble sizes is to reduce overlap between bubbles with similar Ecological Index and Stressor
Index scores.

To adjust bubble sizes, enter a new size in the
Edit Bubble Sizes section of the Bubble Plot
Options worksheet.

Bubble sizes can range from 1 (small) to 300
(large). The default bubble size is 20.

Click the RESIZE BUBBLES button to apply the
new bubble size. The Bubble Plot worksheet
will automatically be updated with the new
bubble sizes.

To return to the default size, click the RESET
BUBBLE SIZES button.

EDIT BUBBLE SIZES

Enter a bubble size (1 - 300):
10]

The default bubble size is 20.

Click the button below to resize:
RESIZE BUBBLES

RESET BUBBLE SIZES

-------
Bubble Plot Options Worksheet- Edit Bubble Colors

7.6. Edit Bubble Colors

The Bubble Plot worksheet displays three pieces of information for each watershed included in your screening: the
Ecological Index score on the y-axis, Stressor Index score on the x-axis, and Social Index score using the bubble size. The
Bubble Plot worksheet can also display a fourth piece of information by shading bubbles different colors to reflect different
values of an indicator. This feature is implemented in the Edit Bubble Colors section of the Bubble Plot Options worksheet.

To display indicator values using bubble colors, users must select the number of Classes to display, a method for defining
Class Breaks, and a Color Scheme. These terms are defined below.

¦ Classes - The number of groups or bins to separate watersheds into. Up to 10 classes can be selected.

¦ Class Breaks - The cutoff indicator values used to define class membership. Three options are available for defining
class breaks:

Ouantile Breaks result in classes that have an equal number of watersheds. For example, if four classes are
selected then then quantile breaks option would result in each class containing one-quarter of the total
number of watersheds using the 25th percentile, 50th percentile, and 75th percentile of indicator values as class
breaks.

Equal-Interval Breaks result in classes that cover an equal range of indicator values. For example, if four classes
are selected for an indicator with a minimum value of 0% and a maximum value of 100%, then the equal-
interval breaks option would result in each class spanning 25 percentage points use values of 25%, 50%, and
75% as class breaks. Under the equal-interval option, the definition of breaks is independent of the number
of watersheds within each class. Depending on the distribution of indicator values, some classes may contain
zero watersheds.

User-Defined Breaks are entered by the user to apply user-specified class breaks.

¦ Color Scheme - The primary color(s) used to shade bubbles. Options are blue, green, or blue-green.

-------
Bubble Plot Options Worksheet- Edit Bubble Colors

Select a classification method: Quantile Breaks

Quantile Breaks

Equal-Interval Breaks
User-Defined Breaks

Select the number of classes:

If the Quantile or Equal- Interval options are
selected for defining class breaks, then break
values will be automatically calculated.

If the User-Defined option is selected, a popup
form will display for you to enter class breaks.

In the class break form, the lower bound of
the first class will automatically be set to the
minimum value of the selected indicator. The
upper bound of the last class will be set to the
indicator's maximum value.

Enter break values for each class in the "Upper
Bound" column. The lower bound of the next
class will be calculated automatically by
adding 0.01 to the upper bound you entered
for the preceding class.

When all breaks have been entered, click the
OK button.

After selecting an indicator, choose a method
for defining class breaks (Quantile, Equal
Interval, or User-Defined) from the
classification method drop-down menu.

Next, choose the number of classes to use for
plotting (between 2 and 10).

Define Class Breaks...

Enter the upper bound for each class below.
Click OK when finished.

Lower
Bound

Upper
Bound

Class 1:
Class 2:
Class 3;
Class 4:

Class 5:
Class 6:
Class 7:
Class 8:
Class 9:
Class 10;

1 to [ 60

to | 30

: to f

to r

Cancel

Select a color scheme:

Blue-Green _z_

Finally, select a color scheme to use for

¦Mitt shading bubbles. Options are blue, green, or

Blue

blue-green.

Green

Blue-Green

-------
Bubble Plot Options Worksheet- Edit Bubble Colors

EDIT BUBBLE COLORS
Select Indicator for A dju sting Colors

Select a classification method:
Select the number of classes:
Select a color scheme

Quantile Breaks

it :

Blue-G reen

Click the bu

ii|-ilrH '-n'nl-lr

UPDATE BUBBLE COLORS

Legend

% Impervious Cover in WS (2016)

After you have selected the indicator to plot,
the method for defining class breaks, the
number of classes, and the color scheme, a
legend will display in the Edit Bubble Colors
section that illustrates your selections.

Click the UPDATE BUBBLE COLORS button to
apply the selected settings to the Bubble Plot
worksheet.

0 - 1.71

1.72 - 5.22

5.23 - 15.16

15.17 - 59.92

After clicking the UPDATE BUBBLE COLORS button, the Bubble Plot worksheet will automatically update to
shade bubbles according to the selected indicator. Users can adjust bubble color settings at any time by revising
selections in the Edit Bubble Colors section of the Bubble Plot Options sheet and clicking the UPDATE BUBBLE
COLORS button.

a>
¦a

o ©

% Impervious Cover in WS (2016)

H o -1.71

~ 1.72-5.22
J 5.23 - 15.16

~ 15.17 - 59.92

40 50

Stressor Index

Note: Circle size increases with Social Index score

To return to the default bubble plot (all bubbles shaded
the same color), click the RESET BUBBLE COLORS button.

RESET BUBBLE COLORS

-------
Bubble Plot Options Worksheet-Highlight Bubbles

7.7. Highlight Bubbles

Bubbles can be highlighted iri the bubble plot to call attention to one or more watersheds of interest. Two options are
available for choosing watersheds to highlight.

Highlight Bubbles Option 1-
Select Individual Watersheds

Click the Highlight Bubbles button to display a
popup menu with highlighting options.

HIGHLIGHT BUBBLES

Click the button below to select
watersheds to highlight on the bubble plot:

HIGHLIGHT BUBBLES

The popup menu contains a list of watersheds
included in the screening. Select individual
watersheds to highlight by clicking on their ID
and name.

By default, bubbles are highlighted with a
yellow outline and a medium outline width.
Users can adjust these settings by choosing a
different outline color or width.

Highlight Bubbles...

Choose watersheds to highlight in the bubble plot by selecting their names in the box
below and clicking the Highlight Selected Watersheds button.

Or click the Highlight Filtered Watersheds from Results button to highlight watersheds
that have been filtered on the Results sheet.

I 020200070101 (Lake Mohawk-Wallkill River)

(Papakating Creek)

(Beaver Run-Wallkill River)
(Quarryville Brook-Wallkili River)
(Upper Wawayanda Creek)

(Lower Wawayanda Creek)

(Upper Pochuck Creek)

(Rutgers Creek)

(Lower Pochuck Creek-Wallkill River)
(Sparkill Creek-Hudson River)

(East River-Hudson River)
r Wanaque River)

020200070102

020200070103

020200070104

020200070201

020200070202

020200070203

020200070206

020200070207

020301010404

020301010405
020301030101

020301030103 (Lower Wanaque River)

Select an outline width c
and color:

After the watersheds of interest are selected,
click the Highlight Selected Watersheds button
to highlight the bubbles for the selected
watersheds.

You still have the opportunity to select
additional watersheds after clicking the
Highlight Selected Watersheds button. Repeat
the previous step until all watersheds of interes'
have been selected for highlighting, then click
the Exit button to close the popup menu.

Highlight Selected Watersheds

esufts

Highlight Filtered Watersheds fron

Remove Highlighting

-------
Bubble Plot Options Worksheet-Highlight Bubbles

Highlight Bubbles Option 2 -

Highlight Filtered Watersheds from the Results Worksheet

To use this option, you must have already applied filters on the Results worksheet to display watersheds that
meet user-specified criteria. For example, the Results worksheet could be filtered to only display watersheds
with top-ranked Ecological Index, Stressor Index, and/or Social Index scores. See Section 5 of this guide for
instructions on how to filter the Results worksheet.

Click the Highlight Bubbles button to display a popup
menu with highlighting options.

By default, bubbles are highlighted with a yellow
outline and a medium outline width. Users can
adjust these settings by choosing a different
outline color or width.

Click the Highlight Filtered Watersheds from Results

button. The tool will automatically highlight bubbles for
the watersheds that are displayed on the Results
worksheet.

HIGHLIGHT BUBBLES

Click the button below to select
watersheds to highlight on the bubble plot:

HIGHLIGHT BUBBLES

T Highlight Filtered Watersheds from Results

Remove Highlighting

Exit

Highlight Bubbles...

Choose watersheds to highlight in the bubble plot by selecting their names in the box
below and clicking the Highlight Selected Watersheds button.

Or click the Highlight Filtered Watersheds from Results button to highlight watersheds
that have been filtered on the Results sheet.

020200070101 (Lake Mohawk-Wallkill River) a|

020200070102 (Papakating Creek)

020200070103 (Beaver Run-Wallkill River)

020200070104 (Quarryville Brook-Wallkill River)

020200070201 (Upper Wawayanda Creek)

020200070202 (Lower Wawayanda Creek)

020200070203 (Upper Pochuck Creek)

020200070206 (Rutgers Creek)

020200070207 (Lower Pochuck Creek-Wallkill River)

020301010404 (Sparkill Creek-Hudson River)

020301010405 (East River-Hudson River)

020301030101 (Upper Wanaque River)

020301030102 (Ringwood River) .

020301030103 (Lower Wanaque River) _zl

Select an outline width
and color:

Highlight Selected Watersheds

-------
Bubble Plot Options Worksheet-Save as Image File

7.8. Save As Image File
A copy of the Bubble Plot worksheet can be saved as an image file for use in reports or presentations.

Microsoft Excel

File saved iin current directory as Test.jpg
A record of the Setup and Notes worksheets have also been saved. WJ

A message box will notify you that the image
file saved in JPEG format using the filename you
provided.

The file will be saved in the same directory that
the RPS Tool file is saved in.

Two PDF files storing the contents of the Setup
sheet and Notes sheet are also saved to provide
a record of the screening settings used to
produce the Bubble Plot image file.

-------
Map Worksheet- Overview

8. Map Worksheet
8.1. Overview

The Map worksheet that displays screening results in map form. The Map worksheet is automatically created when the
RUN SCREENING button is clicked on the Setup worksheet. By default, the Map worksheet displays Recovery Potential
Integrated (RPI) index scores.

The name of the Map worksheet displayed in the bottom tab of your RPSTool will reflect the scale of watersheds selected
for screening. For example, if you screened HUC12 subwatersheds, then the Map worksheet will be named HUC12_Map.
Most RPS tools have a map worksheet for HUC12 subwatersheds and, if the tool is also setup to screen HUC14 watersheds,
a map for HUC14s. RPS Tools that are setup to screen other watershed scales may not have a map for those additional
watershed scales.

RPI Score

25.91 - 35.46
35.47 - 45.01
45.02 - 54.56
54.57 - 64.11
64.12 - 73.65
Not Analyzed I No Data

Setup Results Bubble_Plot | Bubble_Plot_Options

Map Options

Click the button belo w to select an indicator to map:

Select Indicator ro Map

Indicator Selected:

RPI Score

Select the number of classes:

Select a classification method:

| Eau a (-Interval Breaks 3
Select a color scheme:

| Blue-Green

Click the button below to update the map:

Update Map

Click the button below to highlight watersheds of interest:

Highlight Watersheds |

Click the button below to save the map as a PDF file:
Save Map as PDF file

HUC8_Data HUC12_Data Iridicatorjnfo

The following sections describe how to:

¦ Create a Custom Map
m Highlight Watersheds of Interest
m Save the Map as a PDF File

-------
Map Worksheet- Create Custom Map

8.2. Create Custom Map

Users can customize the Map worksheet to shade watersheds on the map using any indicator or index. To customize the
Map worksheet, users must select the mapped indicator, the number of Classes to display, a method for defining Class
Breaks, and a Color Scheme. These terms are defined below.

¦ Classes - The number of groups or bins to separate watersheds into. Up to 10 classes can be selected.

¦ Class Breaks - The cutoff indicator values used to define class membership. Three options are available for defining
class breaks:

Ouantile Breaks result in classes that have an equal number of watersheds. For example, if four classes are
selected then the quantile breaks option would result in each class containing one-quarter of the total number
of watersheds using the 25th percentile, 50th percentile, and 75th percentile of indicator values as class breaks.
Equal-Interval Breaks result in classes that cover an equal range of indicator values. For example, if four classes
are selected for an indicator with a minimum value of 0% and a maximum value of 100%, then the equal-
interval breaks option would result in each class spanning 25 percentage points using values of 25%, 50%, and
75% as class breaks. Under the equal-interval option, the definition of breaks is independent of the number
of watersheds within each class. Depending on the distribution of indicator values, some classes may contain
zero watersheds.

User-Defined Breaks are entered by the user to apply user-specific class breaks.

¦ Color Scheme - The primary color(s) used to shade watersheds on the map. Options are blue, green, or blue-green.

Map Options

Click the button below to select an indicator to map:

S el eel hdicaHDno Map

To map an indicator, first click the Select Indicator to
Map button in the Map Options section of the Map
worksheet. This launches a popup menu for choosing
an indicator to map.

Use the drop-down menus to choose the
category and subcategory of the indicator that
you would like to map.

Any Ecological, Stressor, Social or indicator can
be selected for mapping, regardless of whether
it was included in your screening or not.

Index scores such as Ecological Index can also
be selected.

Highlight the name of the indicator that you
would like to map. Only one indicator can be
mapped at a time.

Click the Select Indicator for Display button to
choose the highlighted indicator.

Tfi

Select Indicator for Display X

Use this menu to select an indicator for display.

Choose an indicator category and subcategory of interest from the drop-down menu. Then
highlight the indicator name from the list and click the Select Indicator button.

Select Indicator Category:
| Index Scores & Ranks

Select Indicator Subcategory:
| Index Scores & Ranks

Ecological Index
Ecological Rank
Stressor Index
Stressor Rank
Social Index
Social Rank

RPI Rank

Select Indicator for Display

-------
Map Worksheet-Create Custom Map

Equal-Interval Breaks
User-Defined Breaks

Class 3: | 50.01 to | 7sf

Class 4: | to T

Class 5: | to

Class 6: | to

Class 7: | to

Class 8: | to |

Class 9: | to

Class 10: to |

OK | Cancel

-------
Map Worksheet-Create Custom Map

After you have selected the indicator to map,
the number of classes, the method for defining
class breaks, and the color scheme click the
UPDATE MAP button to apply the selected
settings to the watershed map.

Map Options

Click the button belo w to select an indicator to map:

Se/ecr Indicate) no Map

Indicator Selected:

RPI Score

Select the number of classes:

Select a classification method:

lEouaUnterval Breaks
Select a color scheme:

| Blue-Green

Click the button below to update the map:

Update Map

Reset Map

Click the button below to highlight watersheds of interest:

Highlight Watersheds |

Click the button below to save the map as a PDF file:
Save Map as PDF file

The Map worksheet will automatically update to shade watersheds according to the selected indicator or index.
Users can adjust map settings at any time by revising selections in the Map Options section of the Map
worksheet and clicking the UPDATE MAP button.

To return to the default map (displaying
Recovery Potential Integrated Index scores),
click the RESET MAP button.

RPI Score

25.91 - 35.46
35.47 - 45.01
45.02 - 54.56
54.57 - 64.11
64.12 - 73.65
Not Analyzed / No Data

-------
Map Worksheet-Highlight Watersheds of Interest

8.3. Highlight Watersheds of Interest
Watersheds can be highlighted on the map to call attention to one or more watersheds of interest.

Click the button below to highlight watersheds of interest:
Highlight Watersheds

Select Watersheds...

Choose watersheds to highlight in the map by selecting their names in the box below and
clicking the Highlight Selected Watersheds button.

(Lake Mohawk-Wallkill River)
(Papakating Creek)

(Beaver Run-Wallkill River)
(Quarryville Brook-Wallkill River)
(Upper Wawayanda Creek)

(Lower Wawayanda Creek)

(Upper Pochuck Creek)

(Rutgers Creek)

(Lower Pochuck Creek-Wallkill River)
(Sparkill Creek-Hudson River)

(East River-Hudson River)

(Upper Wanaque River)

(Ringwood River)

(Lower Wanaque River)

(Mahwah River) —-

(Middle Ramapo River)

020200070101

020200070102

020200070103

020200070104

020200070201

020200070202

020200070203

020200070206

020200070207

020301010404

020301010405

020301030101

020301030102

020301030103

020301030203

020301030204

020301030205 (Lower Ramapo River)
020301030301 (Upper Whippany River)

Click the Highlight Watersheds button to
display a popup menu with highlighting options.

The popup menu contains a list of watersheds
included in the screening. Select individual
watersheds to highlight by clicking on their
ID/name.

By default, watersheds are highlighted with a
yellow outline and a medium outline width.
Users can adjust these settings by choosing a
different outline color or width.

Select an outline width r
and color:

Highlight Selected Watersheds

Remove Highlighting

After the watersheds of interest are selected,
click the Highlight Selected Watersheds button
to highlight the watersheds on the map.

You still have the opportunity to select
additional watersheds after clicking the
Highlight Selected Watersheds button. Repeat
the previous step until all watersheds of interest
have been selected for the highlighting, then
click the Exit button to close the popup menu.

-------
Map Worksheet - Sa ve Map as PDF File

8.4. Save Map as PDF File
The watershed map ori the Map worksheet can be saved as a PDF file for use in reports or presentations.

-------
Indicator Data Worksheet

9. Indicator Data Worksheet(s)

The Indicator Data worksheet contains a table of indicator values for all watersheds in the Project Area covered by your
RPS Tool file.

Indicators are grouped by category in the Indicator Data worksheet and are ordered from left-to-right as Base, Ecological,
Stressor, and Social indicators. Indicator categories are displayed in row 6. Indicator names are displayed in row 7.

The name of the Indicator Data worksheet displayed in the bottom tab of your RPS Tool will reflect the watershed scale
of the indicator data it stores. For example, the Indicator Data worksheet for HUC12 subwatersheds is named
HUC12_Data. If your tool file includes multiple watershed scales (e.g., both HIJC14 and HUC12) then it will contain multiple
Indicator Data worksheets, one for each scale (e.g., HUC14_Data and HUC12_Data).

BASE INDICATORS

Hydrologic Unit Code
12-Digit (HUC12)

Name HUC12 Watershed

Hydrologic Unit Code 8-Digit (HUC8)

Name HUC8 Watershed

Hydrologic Unit Code 6-Digit (HUC6)

020200070101

Lake Mohawk-Wall kill River

02020007

Rondout

020200

020200070102

Papakating Creek

02020007

Rondout

020200

020200070103

Beaver Run-Wallkill River

02020007

Rondout

020200

020200070104

Quarryville Brook-Wallkill River

02020007

Rondout

020200

020200070201

Upper Wawayanda Creek

02020007

Rondout

020200

020200070202

Lower Wawayanda Creek

02020007

Rondout

020200

020200070203

Upper Pochuck Creek

02020007

Rondout

020200

020200070206

Rutgers Creek

02020007

Rondout

020200

020200070207

Lower Pochuck Creek-Wallkill River

02020007

Rondout

020200

020301010404

Sparkill Creek-Hudson River

02030101

Lower Hudson

020301

020301010405

East River-Hudson River

02030101

Lower Hudson

020301

020301030101

Upper Wanaque River

02030103

Hackensack-Passaic

020301

020301030102

Ring wood River

02030103

Hackensack-Passaic

020301

020301030103

Lower Wanaque River

02030103

Hackensack-Passaic

020301

020301030203

Mahwah River

02030103

Hackensack-Passaic

020301

020301030204

Middle Ramapo River

02030103

Hackensack-Passaic

020301

020301030205

Lower Ramapo River

02030103

Hackensack-Passaic

020301

020301030301

Upper Whippany River

02030103

Hackensack-Passaic

020301

020301030302

Troy Brook

02030103

Hackensack-Passaic

020301

020301030303

Lower Whippany River

02030103

Hackensack-Passaic

020301

020301030401

Upper Rockaway River

02030103

Hackensack-Passaic

020301

020301030402

Beaver Brooker

02030103

Hackensack-Passaic

020301

020301030403

Middle Rockaway River

02030103

Hackensack-Passaic

020301

020301030404

Lower Rockaway River

02030103

Hackensack-Passaic

020301

020301030501

Upper Pequannock River

02030103

Hackensack-Passaic

020301

020301030502

Lower Pequannock River

02030103

Hackensack-Passaic

020301

020301030503

Morris Canal-Pompton River

02030103

Hackensack-Passaic

020301

020301030601

Great Brook-Passaic River

02030103

Hackensack-Passaic

020301

020301030602

Black Brook-Passaic River

02030103

020301

Results Bubble_Plot Bubble_Plot_Options

HUC12_Map HUC8_Data 1 HUC12_Data 1 Indicatorjnfo HUC.Subsets

-------
Explore Indicator Data Menu-Overview

10. Explore Indicator Data Menu
10.1. Overview

The RPSTool includes built-in functions for exploring the statistical properties of indicator data. This information can be
useful when making decisions on which indicators to include in a screening.

Indicator statistics are displayed within the Explore Indicator Data menu. To open the menu, select an indicator data
worksheet tab (HUC12_Data, HUC14_Data, etc.). Then click the EXPLORE INDICATOR DATA button.

This worksheet contains the complete base, ecological, stressor, and social indicator dataset for all HUC12 watersheds in the project area (sta
Indicators can be added to the table from the Add_lndicators worksheet.

Click the Explore Indicator Data button below to review indicator summary statistics, histograms, ecoregional variation, and correlations.

EXPLORE INDICATOR DA TA

Result

Bubb!e_Plot Bubble_Plot_Options HUC12_Map HUC8_Dat; HUC12Data

Indicator Info

HUC Subsets

Explore Indicator Data... X

Use this interface to explore indicator data. To begin, select an indicator of interest from the drop-down menus below.

Select Indicator Category: jj ^Tj Select Indicator Subcategory: | ^Tj

Select Ind icator Na me: j Tj

By default, all watersheds in the project area are included in the data summary. Click the button below to select a subset of watersheds for data exploration.

Watershed Selection: |

Change Watershed Selection...

Summary Stats | Ecoregional Variation | Correlation ]

This panel displays summary statistics and a histogram for the indicator selected above.

The shape of the histogram
reveals information about the
distribution of indicator values.

histogram for data with normal
(beff-shaped) distribution.

histogram for data with skewed
distribution.

* i

VaUe

Histogram for data with even
distribution.

Save Chart to Ftie Copy Chart to Clipboard

Minimum |
Maximum

Median
Mean

25th Percentile
75th Percentile

Standard Deviation
Number/Percent Blanks

-------
Explore Indicator Data Menu - Overview

The Explore Indicator Data menu contains drop-down menus for selecting an indicator to explore and three tabs for

reviewing the statistical properties of the selected indicator:

¦ The Summary Stats tab displays summary statistics (minimum, maximum, mean, etc.) and a histogram of indicator
values;

¦ The Ecoregional Variation tab displays a boxplot of indicator summary statistics by Level 3 Ecoregion
(https://www.epa.gov/eco-research/level-iii-and-iv-ecoregions-continental-united-states). The tab also contains a
table listing the number of watersheds in each ecoregion and the number of watersheds with blank or missing values
of the selected indicator per ecoregion. The Ecoregional Variation tab is only visible when reviewing indicator data
for HUC12 watersheds.

¦ The Correlation tab contains additional drop-down menus for users to select a second covariate indicator to evaluate
correlation between two indicators. Correlation statistics and a scatterplot of indicator values are displayed in the tab.

By default, all watersheds in your tool's study area are included in the indicator data summary. The menu also contains

the CHANGE WATERSHED SELECTION button for selecting a custom subset of watersheds for the indicator data summary.

The following sections describe how to:

¦ Select an Indicator to Explore

¦ Select a Covariate Indicator to Review Correlation

¦ Save or Copy a Chart

m Use the Change Watershed Selection Button

-------
Explore Indicator Data Menu-Selectan Indicator to Explore

10.2. Select an indicator to Explore

To explore the statistical properties of ari indicator, select the indicator of interest from the drop-down menus at
the top of the Explore Indicator Data menu.

Explore Indicator Data...

lisp Irhte intprfarp fro pyr>k>rp indiratnr data. To hpfiin. an inrlirator of intprp*;!" from t~hp droo-rlown mpniis hplnw.

Select Indicator Category: |g35e Select Indicator Subcategory: |aII Base Indicators

Select Indicator Name: |

"31

ay utuauu, an water /// usa prujeu. area art; /r/uuu&u ui ute uata sutninary. am uuitust utuuw tu a zruustu u/ waitm-r/ttuz- tut uata ttxpiviauuii.

Watershed Selection:Watersheds change Watershed Selection...

Ecoregional Variation ] Correlation |

First choose the indicator category and subcategory from
the dropdown menus.

^^icatoMJata. To begin, select an indicator^nnteres^ron^h^droj^owiyijenu^ejow.

Ecological

Select Indicator Category:|

Select Indicator Name: |~

By default, all watersheds in the project area are included in the data summary. C
Watershed Selection:!

Change Watershed Selection...

Summary Stats | Ecoregional Variation | Correlation

All Ecological Indicators

1 ah hcoioaicai inaicators

Forest Cover

Wetlands Cover

Woody Vegetation Cover

Natural Land Cover (All Types}

Soil Attributes

Stream Order

Aquatic Lfe and Habitat

Then choose the indicator name from the
Select Indicator Name menu.

The Summary Stats and
Ecoregional Variation tabs
will automatically populate
with statistical information
for the selected indicator.
Click on each tab name to
view its contents.

Summary Stats

Ecoregional Variation | torrelation

This panel displays summary statistics and a histogram for the indicator selected above.

19.22 2£.S

S7.2G9 76.S

% Forest in WS (2016)

Save Chart to Fie | Copy Chart to Clipboard |

1*1??- jrjh- aw. 4Hcw- tn ?m- 7e.sm-

Minimum
Maximum

Median 124.6548 25th Percentile 110.2477 Standard Deviation |21.2657

Mean 128.190 1 75th Percentile j44.8842 Number/Percent Blanks |o (0%)

1 1

|| d

% Forest in HCZ (2011}

% Forest in RZ (2011)

% Forest Change in WS (2001-11)

% Forest Change In HCZ (2001-11)

% Forest Change f> RZ (2001-11)

% Forest Remaining in WS X

The shape of the histogram
reveals ir formation about the
distribution of indicator values.

histogram for data with norma!
(beS-shaped) distribution.

Histogram for data with even
distribution.

-------
Explore Indicator Data Menu-Selecta Covariate Indicator

10.3. Select a Covariate indicator

The Correlation tab of the Explore Indicator Data menu contains additional drop-down menus for users to select
a second covariate indicator to evaluate correlation between two indicators.

Summary Stats ] Ecoregional Variation

Correlation

This panel displays information on the strength of correlation between the indicator selected above and any other covariate indicator.

Select Covariate Category: Ecological

Select Covariate Subcategory: I^h Ecological Indicators

Select Covariate Name: |~

The scatterpbt H/ustr3tt

First choose the indicator category and subcategory from
the dropdown menus.

This panel displays information on the strength of correlation between the indicator selected above and any other covariate indicator.

Select Covariate Category

-| Ecological | Select Covariate Subcategon,^

All Ecological Indicators »¦ 1

Select Covariate Name: |~

Forest Cover

Wetlands Cover

Woody Vegetation Cover

Natural Land Cover (All Types)

Soil Attributes

Stream Order

Aquatic Life and Habitat

i i \

Then choose the indicator name from the
Select Covariate Name menu.

This panel displays information on the strength of correlation between the indicator select

Select Covariate Category: |Ecological Select Covariate Subcategory: | Forest Cover

"Select Cc

>variate Name:

iMBfeea in HCZ (201$)

50.003 -

X—1

% Forest in HCZ (2016

% Forest in RZ (2016)

% Forest Change in WS (2001-16)
% Forest Change in HCZ (2001-16)
% Forest Change in RZ (2001-16)
% Forest Remaining in WS

The scatterplot and
correlation statistics will
automatically populate
with values for the
selected indicator and the
covariate indicator.

Summary Stats ] Ecoregional Variatiof^^^^^^^^ |

Select Covariate Category: | Ecological T] Select Covariate Subcategory: | All Ecological Indicators

Select Covariate Name: 1% Forest in HCZ (2016)

40.C00 50.000 60.000
% Forest in WS (2016)

80.000 90.000 100.000

? Chart to Fie | Copy Chart to Clipboard |

Correlation Coefficient (R) Coefficient of Determination (R-Squared)

The scatterpbt Mustrates
whether values for the two
indicators vary together or
randomly.

Scatterpbt showing strong
positive correlation

Scatterplot showing
moderate positive correlation

Scatterpbt showing weak
correlatbn

-------
Explore Indicator Data Menu - Save or Copy a Chart

10.4. Save or Copy a Chart

The Summary Stats, Ecoregional Variation, and Correlation tabs each have buttons that allow users to save or
copy an image of the histogram, ecoregional boxplot, or correlation scatterplot.

Summary Stats | Ecoregional Variation Correlation

This panel displays summary statistics and a histogram for the indicator selected above.

Save Chart to File

Copy Chart to Clipboard

The shape of the histogram
reveals information about the
dMbtim of hdator values.

H$to
-------
Explore Indicator Data Menu - Change Watershed Selection Button
10.5. Change Watershed Selection Button

By default, the Explore Indicator Data menu displays indicator statistical properties for all watersheds in your
tool's study area. You can instead explore indicator data for just a subset of watersheds using the CHANGE
WATERSHED SELECTION button at top of the Explore Indicator Data menu. Clicking the button will launch the
Select Watersheds menu.

Explore Indicator Data...

Use this interface to explore indicator data. To begin, select an indicator

Select Indicator Category: |Base
Select Indicator Name: J~

By default, all watersheds in the project area are included in the

Watershed Selection: | 'stershecs

Select Indicator Subcategory:

cummnn/ tho hi iftnn

^Ifjj^j^jjglect a subset of watersheds for data exploration.

Change Watershed Selection...

Select Watersheds...

Indicator data can be reviewed for all watersheds in the project area or for a subset
of watersheds of interest. Use the buttons below to specify which watersheds you
would like to explore then click OK.

(* All Watersheds

C Watersheds Selected for Screening on the Setup Sheet
C Named Subset from the HUC_Subsets Sheet

This option is available if you have already defined one or more watershed subsets on the HUC_Subsets
sheet Selecting a subset name from the menu below will only indude those watersheds within tine selected
subset in the data summary.

C Other Subset of Watersheds

A subset of watersheds can be selected based on indicator values. Watersheds that meet the conditions
spetified below will be induded in the data summary.

Select Indicator Type: |~~

Select Subcategory: I

Select Indicator Name:

Select Subset Method:

Indude Watersheds with
Values Between:

Indude Watersheds with
Values Of:

-------
Explore Indicator Data Menu - Change Watershed Selection Button

The third option button selects watersheds that

have already been detined in a named

watershed subset on the HUC_Subsets 1

worksheet.

To use this option, you must have previously

entered one or more watershed subsets on the

HUC_Subsets worksheet (see Section 13).

Named Subset from the HUC Subsets Sheet

Named Subset from the HUC_Subseis Sheet

This option is available if you have already defined one or more watershed subsets on the HUC_5ubsete
sheet. Selecting a subset name from the menu below wJ only include those watersheds withn the selected
subset in the data summary.

A subset of watersheds can be selected based on indicator values. Watersheds that meet the conditions
specified below will be included in the data summary,

Select Indicator Type:

Select Indicator Name;

Select Subset Method:

Indude Watersheds with
Values Between:

Min =

Max =

Indude Watersheds with
Values Of:

-------
Explore Indicator Data Menu - Change Watershed Selection Button

After choosing an option for selecting watersheds to include in the indicator data summary, click the OK button
at the bottom of the Select Watersheds menu.

Select Watersheds...

C" All Watersheds

f Watersheds Selected for Screening on the Setup Sheet

C Named Subset from the HUC_Subsets Sheet

This option is available if you have already defined one or more watershed subsets on the HUC_Subsets
sheet. Selecting a subset name from the menu below will only indude those watersheds within the selected
subset in the data summary.

(* Other Subset of Watersheds

A subset of watersheds can be selected based on indicator values. Watersheds that meet the conditions
specified below will be induded in the data summary.

Select Indicator Type: | Base ~ ]

All Base Indicators

Select Indicator Name: Name HUC12 Watershed

Select Subset Method: U n iq u e Va lu es

Indude Watersheds with
Values Between:

Min =

Max =

Indude Watersheds with
Values Of:

Absecon Bay
Absecon Creek

Alexauken Creek-Delaware River
Allegheny Creek-Delaware River

Ambrose Brook
Assiscunk Creek

The Explore Indicator Data menu will now only display indicator summary statistics, histograms, correlations,
and other statistical properties for the group of watersheds specified on the Select Watersheds menu. You can
adjust your watershed selection at any time by clicking the CHANGE WATERSHED SELECTION button on the
Explore Indicator Data menu.

-------
Indicator Info Worksheet- Overview

11. Indicator Info Worksheet
11.1. Overview

The Indicator Info worksheet contains a table of indicator information, including the category of each indicator (Base,
Ecological, Stressor, or Social), subcategory, the watershed scale(s) that each indicator is quantified at, and a description
of what watershed characteristic the indicator measures.

Indicator Name/Glossary Term ,

Subcategory

Watershed Scale(s)

Description

% Forest in WS (2016)

Ecological Indicator

Forest Cover

HUC12

Percent of the HUC12 classified as forest cover by the 2016 CDL-NLCD Hybrid Land Cover dataset. Forest cover
classes include 'Deciduous Forest' (code 141), 'Evergreen Forest' (code 142), and 'Mixed Forest' (code 143) in the
2016 CDL-NLCD Hybrid Land Cover dataset. Calculated as Forest area divided by HUC12 area, multiplied by 100.
See also 2016 CDL-NLCD Hybrid Land Cover glossary definition.

% Forest in HCZ (2016)

Ecological Indicator

Forest Cover

HUC12

Percent of the HUC12 that is in the Hydrologically Connected Zone and classified as forest cover by the 2016 CDL-
NLCD Hybrid Land Cover dataset. Forest cover classes include 'Deciduous Forest' (code 141), 'Evergreen Forest'
(code 142), and 'Mixed Forest' (code 143) in the 2016 CDL-NLCD Hybrid Land Cover dataset. Calculated as forest
area in the Hydrologically Connected Zone divided by HUC12 area, multiplied by 100. See also 2016 CDL-NLCD
Hybrid Land Cover and Hydrologically Connected Zone glossary definitions.

% Forest in RZ (2016)

Ecological Indicator

Forest Cover

HUC12

Percent of the HUC12 that is in the Riparian Zone and classified as forest cover by the 2016 CDL-NLCD Hybrid Land
Cover dataset. Forest cover classes include 'Deciduous Forest' (code 141), 'Evergreen Forest' (code 142), and
'Mixed Forest' (code 143) in the 2016 CDL-NLCD Hybrid Land Cover dataset. Calculated as forest area in the
Riparian Zone divided by HUC12 area, multiplied by 100. See also 2016 CDL-NLCD Hybrid Land Cover and Riparian
Zone glossary definitions.

% Forest Change in WS (2001-16)

Ecological Indicator

Forest Cover

HUC12

The change in the percentage of the HUC12 with forest cover from 2001 to 2016. Calculated from the National
Land Cover Database 2016 (NLCD 2016) 2001 and 2016 Land Cover Datasets (January 2019 version). Forest cover
classes include 'Deciduous Forest', 'Evergreen Forest', and 'Mixed Forest'; codes 41, 42, and 43 in the 2001 and
2016 Land Cover datasets. Positive values denote an increase in forest; negative values denote a decrease in
forest. Does not count areas that changed to/from the 'Open Water' class (code 11) since these were assumed to
be errors. Equation used: (Area Changing To Forest-Area Changing From Forest)/(HUC12 Area) * 100.

% Forest Change in HCZ (2001-16)

Ecological Indicator

Forest Cover

HUC12

The change in the percentage of the HUC12 with forest cover in the Hydrologically Connected Zone (HCZ) from

Bubble.Plot Bubble.Plot.Options HUC12_Map HUC8.Data HUC12_Data

| Indicatorlnfo

lmJC_Subsets Addjndicators

The following sections describe how to:

¦ Filter the Indicator Info Table

¦ Add Indicator Info

-------
Indicator Info Worksheet- Filter Table

11.2. Filter Table

The indicator information tabie can be filtered to view information for a specific indicator category (Base,
Ecological, Stressor, or Social), indicator subcategory, or watershed scale by clicking the drop-down arrow next
to the column name and selecting a filter option.

In the example below, the table is filtered to only display information for Ecological indicators.

' |Category

Indicator Name/Glossary Term

% Forest in WS (2016)

% Forest in HCZ (2016)

% Forest in RZ (2016)

zJ, Sort A to Z
U Sort Z to A
Sort by Color

Sheet View

CI ear Filter From "Category"
Filter by Color

% Forest Change in WS (2001-16)

% Forest Change in HCZ (2001-16)

Subcategory **

Watershed Scale(s) T

Forest Cover

HUC12

Forest Cover

HUC12

Forest Cover

HUC12

Forest Cover

HUC12

Forest Cover

HUC12

Indicator Name/Glossary Term **

Category

Subcategory | *

Watershed Scale(s) '

% N-lndexl Change in WS (2001-16)

Ecological Indicator

Natural Land Cover (All Types)

HUC12

% N-lndexl Change in HCZ (2001-16)

Ecological Indicator

Natural Land Cover (All Types)

HUC12

-------
Indicator Info Worksheet-Add Indicator Info

11.3. Add Indicator info

The Indicator Info worksheet can be updated by users to store information for new indicators added to the Indicator Data
worksheet(s).

To add indicator information for a new
indicator, first insert a row for the new
indicator.

Right-click the margin of the Indicator
Info worksheet (where row numbers
are displayed) where you would like to
insert the new row.

For example, if you would like to add
information for a new Ecological
indicator, right-click the margin of the
first Stressor indicator row.

" Cut \

' 1F[|) Copy §
5» -

q Paste Options:

¦D

Paste Special...

Insert

U Eelete i]

I Clear Contents i]
* n

[sE| Format Cells... r

I: Row Height...

Hide

!•

j Unhide g

Indicator Name/Glossary Term | Z

Category ,

Subcategory | ~

139

PHWA Water Quality Sub-Index,
ER Percentile

Ecological Indicator

Integrated Waters

Neutral Variable, Ecological
Category

Ecological Indicator

Neutral Variable

1141

i Urban in WS (2016)

Stressor Indicator

Urban/Developed

% Urban in HCZ (2016)

Stressor Indicator

Urban/Developed

After right-clicking, select "Insert" from the Excel popup
menu.

A new row will be inserted into the indicator
information table.

Type the name of the new indicator in the Indicator
Name column.

Indicator Name/Glossary Term ITT

Category

Subcategory HT

Watershed Scale(s) »

14'

New Ecological Indicator

-------
Indicator Info Worksheet-Add Indicator Info

Type the category of the new indicator (Base, Ecological,
Stressor, or Social) in the Indicator Category column.

Indicator Name/Glossary Term

Category

141

New Ecological Indicator

Ecological Indicator

Type the subcategory of the new indicator. Users can enter an existing
subcategory or a new subcategory.

Note that the subcategory entered here will only be relevant for sorting and
filtering the Indicator Info sheet. The subcategory drop-down menus in other
worksheets will store new indicators under a "user-added" subcategory.

Indicator Name/Glossary Term T

Category

Subcategory T

141

New Ecological Indicator

Ecological Indicator

Ecological Subcategory

Type the watershed scale of the new indicator in the
Indicator Scale(s) column. For example, if the indicator
is calculated for HUC12s in the Project Area then type
"HUC12".

Indicator Name/Glossary Term |T

141 New Ecological Indicator

Category j •,

Ecological Indicator

Subcategory

Ecological Subcategory

Watershed Scale(s}

HUC12

Type a description of the new indicator in the Indicator
Description column.

i Indicator Name/Glossary Term »

41 New Ecological Indicator

Category

Ecological Indicator

Subcategory

Ecological Subcategory

Description

Example new Ecological indicator.

Repeat these steps for each new indicator added to the Indicator Data worksheet.

-------
Add Indicators Worksheet - Overview

12. Add Indicators Worksheet
12.1. Overview

New indicators can be added to the RPS Tool from the Add indicators worksheet for use in a screening run. Note that the
RPS Tool does not include features for calculating new indicators. New indicators must be calculated outside of the RPS
Tool and once calculated can be added at anytime. New indicators are inserted into new columns on the Indicator Data
worksheet and will display in the indicator menus on the Setup, Bubble Plot Options, and Map worksheets.

If your RPS Tool file is setup to screen multiple watersheds scales then new indicators must be added separately for each
watershed scale. For example, if you would like to add new HUC12 indicators and new HUC14 indicators, you must add
the HUC12 indicators in a separate step from the HUC14 indicators. Up to 50 indicators can be added at a time for each
scale.

ADD INDICATORS

Enter Indicator Information

Enter nw indicator tames and types £*kiw

Enter Indicator Data

Paste vour indicator table below. Your table must have watershed IDs in column D and indicator values in subsequent columns. The header row
-------
Add Indicators Worksheet-Enter New Indicator Information

12.2. Enter New indicator Information
Iri the Enter Indicator Information section of the Add Indicators worksheet, you will enter the name and type of each new
indicator. This information is used to update the indicator menus on the Setup, Bubble Plot Options, and Map worksheets.

Enter New Indicator Information Option 1 -

Tvpe New Indicator Names and Tvpes

In the Enter indicator Information section,
select cell All and type the name of the first
new indicator.

Then enter the new indicator type in cell Bll.
Indicator type must be Ecological, Stressor,
Social, or Base.

Repeat until each new indicator name and type
has been added.

Enter New Indicator Information Option 2 -

Codv and Paste New Indicator Names and

Types

To use this option you must already have a
pre-existing list of new indicator names and
types stored in a separate worksheet. The pre-
existing indicator list must be formatted with
one indicator per row with the indicator name
in the first column and indicator type in the
second column.

Open the worksheet with the pre-existing
indicator list. Select the indicator names and
types and click "Copy" on the Excel menu.

Go back to the Add Indicators worksheet and
set the cursor to cell All in the Enter Indicator
Information section.

Enter Indicator Information

Enter new indicator names and types below

Indicator Name

Indicator Tvoe

Index of Biotic Integrity Score

Ecological

Enter Indicator Information

Enter new indicator names and types below.

Indicator Name

Indicator Type

Index of Biotic Integrity Score

Ecological

Number of CAFOs in WS

Stressor

% MS4 Area

Social

BB4)

Select "Paste Values" from the Excel menu
to paste the new indicator names and
types into the Enter Indicators
Information section.

FILE

| Home

fll

Cut

-
Paste

£[=] Copy '

Format Pain

index of Biotic Integrity Score

Ecological

Number of CAFOs in WS

Stressor

% MS4 Area

Social

INSI

pitEEEI]

* Format Painter
Clipboard f*

Enter Indicator Information

Enter new indicator names and types below

Indicator Name

Indicator Type

ill

c»-

Enter Indicator Information

Enter new indicator names and types below.

Indicator Name

Indicator Type

Index of Biotic Integrity Score

Ecological

] Number of CAFOs in WS

Stressor

% MS4 Area

Social

-------
Add Indicators Worksheet-Enter New Indicator data

12.3. Enter New indicator Data
Iri the Enter Indicator Data section of the Add Indicators worksheet, you will copy and paste a table of new indicator
values for watersheds in the Study Area. These values are used to update the indicator data table in the indicator Data
worksheet.

To add new indicators, you must first prepare a table of new indicator values in a separate spreadsheet file. An
example indicator table is displayed below. Note the following characteristics of the table:

1. The table must have watershed IDs entered in the first column. Your table does not need to have a row
for every watershed in the study area. Any watersheds that are missing from your table will have blank
cells for the new indicators when added to the Indicator Data worksheet. Your table can include extra
watersheds that are not in the study area; however, those watersheds will be skipped when updating the
Indicator Data worksheet. Watersheds can be sorted in any order in your table.

2. The table must have indicator values in subsequent columns.

3. The table must have a header row with indicator names. Names of new indicators cannot match an
existing indicator name already in the tool. We recommend limiting indicator names to 50 characters or
less to properly display in tool menus.

4. Values of new ecological, stressor, and social indicators in your table should be numeric or blank. Non-
numeric values will be skipped when updating the Indicator Data worksheet. Non-numeric values are
allowed for base indicators.

0 2

A II B

D \

HUC12

Index of Biotic Integrity Score

Number of CAFOs in WS

% MS4 Area

031501010101

98.50

0.00

r031501010102

99.35

0.00

*031501010103

^9 78.42

18.02

"031501010104

7.96

"031501010105

47.08

5.88

*031501010106

53.29

9.56

'031501010301

46.89

4.21

r031501010302

50.24

4.52

'031501010303

57.43

9.08

"050500010102

3.06

*050500010103

83.32

37.50

*050500010105

8097

2.13

r051100020101

42.89

0.92

r051100020102

46.93

0.82

r051100020105

0.41

r051100020106

55.19

0.69

"051100020108

50.26

0.00

"051100020109

50.61

0.34

"051100020201

0.38

"051100020203

54.46

0.83

r0S 1100020501

53.91

0.00

-------
Add Indicators Worksheet-Enter New Indicator data

After you have prepared your indicator
data table in a separate spreadsheet file,
you will copy and paste the table into the
Enter Indicator Data section.

Open the spreadsheet file containing
your pre-calculated new indicators.
Select the cells containing watershed IDs
and new indicator values in that file
(including the header row) and click
"Copy" on the Excel menu.

HUC12

>31501010101

331501010102

)31501010103

)3150101G104

)31501010105

531501010106

>31501010301

1501010302

031501010303

050500010102

050500010103

050500010105

051100020101

051100020102

051100020105

051100020106

Index of Biotie Integrity Score

98.50

99.35

78.42

47.08

53.29

46.89

50.24

57.43

83.32

80.97

42.89

46.93

55.19

Number of CAFOs in WS

% MS4 Area

0.00

18.02

7.96

5.88

9.56

4.21

4.52

9.08

3.06

37.50

INSI

% Format Painter
Clipboard r*

Go back to the Add Indicators worksheet
and set the cursor to cell D10.

Note that by default cell D10 contains the
text "Watershed ID". This text is included
as a placeholder and should be
overwritten by your indicator data table.

s Enter Indicator Data

toaJow. Your table must have watershed IDs

Watershed ID

A A ,A. A

D U *£ Wf

Cffl Lh 0

Select "Paste Values" from the Excel
menu to paste the indicator data table
into the Add Indicators worksheet.

16 1

17!

18 '

19 1

20 '

22
23!

|HUC12

Index of Biotic Integrity Score

Number of CAFOs

% MS4 Area

031501010101

98.49662401

031501010102

99.35390734

031501010103

78.42011275

18.02

031501010104

7.96026228

031501010105

47.0843994

5.880882549

031501010106

53.28558028

9.559236623

031501010301

46.89142972

4.214230407

031501010302

50.2423724

4.519161244

031501010303

57.42810532

9.08079115

050500010102

3.058646903

050500010103

83.31772027

37.5

050500010105

80.97092932

2.125675012

051100020101

42.88632856

0.921042273

051100020102

46.93380457

0.816190158

051100020105

0.408689922

-------
Add Indicators Worksheet-Add Indicators Button

12.4. Add Indicators Button
After entering new indicator names, types, and values use the ADD INDICATORS button to update the other tool
worksheets with new indicators.

Clicking the ADD INDICATORS button from the Add Indicators worksheet will display a message box listing the
requirements for adding new indicators. Review that the requirements are met and click YES to continue.

ADD INDICATORS

Enter Indicator Information

Enter new indicator names and types below.

Indicator Name

Indicator Type

Index of Biotic Integrity Score

Ecological

Number of CAFOs in WS

Stressor

% MS4 Area

Social

Add Indicators,.. X

Please specify a watershed scale for the new indicators.

<• Ihuc 12!

r HUC14

Enter Indicator Data

Paste your indicator table below. Your table must have wate

HUC12

Index of Biotic Integrity Score

031501010101

98.49662401

031501010102

99.35390734

031501010103

78.42011275

031501010104

Plf your tool file includes multiple watershed
scales, a message box will prompt you to
specify which scale the new indicators apply to.
Select the option button for the appropriate
S watershed scale and click OK.

The tool will then check to verify that indicator names, types, and values have been correctly entered on the Add
Indicators worksheet. The tool will also look for potential issues with new indicator data.

If no data issues are found, the new indicators will be automatically added as new columns to the Indicator Data
worksheet and will be added to menus on the Setup, Bubble Plot Options, and Map worksheets. If issues are

identified, an error message will appear.

Indicators successfully added. New indicator data is stored in the HUC12J)ata
worksheet. New indicators can be selected for screening on the Setup worksheet.

Would you like to dear the Addjndicators worksheet?

Yes

It is strongly recommended that you enter information for the new indicators (name, type, scale, and description)
to the Indicator Info worksheet. Refer to the Indicator Info worksheet section of this guide for instructions on

inserting information for new indicators.

A message box will appear to notify you that your
new indicators were successfully added to the tool
file.

The message box will prompt you to clear new
indicator names, types, and values from the Add
Indicators worksheet. If you would like to
automatically clear the Add Indicators worksheet
click YES. Or click NO to clear manually.

-------
HUC Subsets Worksheet - Overview

13. HUC Subsets Worksheet
13.1. Overview

When setting up an RPS screening, you'll often want to focus on just a subset of watersheds of interest rather than all
watersheds in the Project Area. The HUC Subsets worksheet provides a space to identify and store groups of watershed
subsets for use in a screening. For example, within the HUC Subsets tab you can generate a list of HUC12 watersheds that
are located in a particular HIJC8 of interest or that have a certain land cover profile.

Watershed subsets include only a portion of all watersheds in the Project Area. A watershed subset is a list of watershed
IDs that meet one or more user-defined selection criteria. Watershed subsets are stored on the HUC Subsets worksheet
with one watershed ID per row. A subset can be added to the Select Watersheds section of the Setup worksheet to screen
and compare the watersheds in the subset. Watershed subsets are defined automatically with the CREATE A NEW
WATERSHED SUBSET button or entered manually.

This worksheet is provided for users to store watershed subsets (lists of watershed IDs for specific groups of watersheds of interest, e.g., all HUC12 IDs ir

Click the Create a New Watershed Subset button below to launch a menu to define a new watershed subset and add it to this sheet.

Or if you already have a watershed subset identified, copy the watershed IDs and a descriptive header from an outside source and use Paste Special/Vo!
available column on this sheet. When copying your own list, you must enter the subset name in row 12 and have ore watershed ID per subsequent rt

("Example Subset") followed by example watershed IDs.

To use subset lists from this worksheet in a screening run, select and copy only the ID numbers in a single column (without the subset name); then go to
to insert the ID list into the first line of the Select Watersheds section.

CREA TE A NEW WATERSHED SUBSET \

| Upper Iowa WMAlTurkey River WMA Upper Wapsipinicon River WMA Upper Cedar River WMA Middle CedarWMA Middle-South Raccoon WMA

JD70600020101 ',&70600040101 "&70801020101 "670802010401 "670802050101 "571000070101

i"&70600020103 "670600040102 "570801020102 "670802010402 "670802050102 "671000070102

F&70600020105 "670600040103 "&70801020103 "670802010403 "670802050103 "671000070103

>670600020106 "670600040104 "670801020201 "670802010503 "670802050201 "671000070104

"670600020107 "670600040105 "&70801020202 "670802010504 "670802050202 "671000070201

"670600020201 "670600040201 "670801020203 "670802010505 "670802050203 "&71000070202

^570600020202 "670600040202 "670801020204 "670802010601 "670802050204 "6710000702:03

^170600020203 "670600040203 "670801020301 "670802010602 "670802050301 "&71000070204

^70600020204 "670600040204 "670801020302

"670802010603 "670a

psnqmn? Ti7mn

0070205

Bubble_Plot_Options

HUC12_Map

HUC8_Data

HUC12_Data

Indicatorjnfo I

HUC.Subsets

I Addjndicators

The following sections provide step-by-step instructions for how to:
¦ Use the Create a New Watershed Subset Button
m Manually Add a Subset List

-------
HUC Subsets Worksheet-Create a New Watershed Subset Button
13.2. Create a New Watershed Subset Button

Define Watershed Subset...

On this menu you can define and store a subset of watersheds of interest based on one or more indicators.

For example, a subset could include all watersheds with agricultural land cover greater than 50%. Use the controls below to specify which watersheds to include in your subset. The
selected watershed IDs will be stored as a new list on the HUC_Subsets sheet and can be copy/pasted onto the Setup sheet for screening.

Enter Subset Name (required, 50 character limit):
Enter Subset Description (optional):

A "subset condition" is an indicator, and set of values for that indicator, used to define watersheds
to include in the subset. Use the menus below to define a subset condition then click the "Add
Condition" button to add it to the list of conditions defined in the box to the right. Up to 10 subset
conditions can be defined but must be entered one-at-a-time using the menus below.

Select Indicator Category:

Select Indicator Subcategory:
Select Indicator

Subset conditons are listed below after they are added with the "Add
Condition" button. Up to 10 conditions can be defined.

Your subset can include watersheds that meet at least one of the subset
conditions or only those watersheds that meet all of the subset conditions. Use
the option buttons to select a subsetting method.

Watersheds must meet: (9 At Least One Condition

C All Conditions

Select Subset Method:

Include Watersheds
with Values Between:

Include Watersheds
with Values Of:

Add Condition

You can remove a subset condition by highlighting it in the list above and
clicking the "Remove Selected Condition" button below.

Remove Selected Condition

When you have defined all of your subset conditions click the "Add Subset to HU<
- Check this box to save a copy of the subset name, description, and conditions as a
Subset to HUC_Subsets Sheet" button below. The PDF file will be saved in the same'

e^^Pry

Ls Sheet" button below to add the list of watershed IDs to the HUC_Subsets sheet.
Ir your records. If this box is checked, the PDF file will be saved after clicking the "Add
as this tool file and will be named using the subset name.

Add Subset to HUC_Subsets Sheet

-------
HUC Subsets Worksheet-Create a New Watershed Subset Button

If your tool file includes multiple watershed scales,
a popup box will display after you click the CREATE
A NEW WATERSHED SUBSET button.

The popup box will contain a list of watershed
scales and ask you to specify the scale to use for
defining your subset.

A subset can only contain watersheds from a single
scale. Choose your desired scale and click OK.

Select Watershed Scale,.. X

Please specify a watershed scale for the new watershed subset.

On the Define Watershed Subset menu, type a name for your subset in the Enter Subset Name text box and an
optional description in the Enter Subset Description text box.

Define Watershed Subset...

On this menu you can define and store a subset of watersheds of interest based o

For example, a subset could include all watersheds with agricultural land cover greater than 50%
selected watershed IDs will be stored as a new list on the HUC Subsets sheet and can be copv/i

Enter Subset Name (required, 50 character limit):
Enter Subset Description (optional):

>w to specify which watersheds to include in your subset. The
le Setup sheet for screening.

Delaware Bay Cropland

HUC12s in the Delaware Bay HUC8 with at least 50% cropland cover

You can now begin to define subset conditions.
First select an indicator category (Base,
Ecological, Stressor, or Social), indicator
subcategory, and indicator name.

Base

Select Indicator Category:

Select Indicator Subcategory: |aII Base Indicators

Select Indicator Name:

Select Subset Method:

Include Watershe
Values Between:

Include Water:

% Water in HUC12 Watershed (2016)

% Hydrologically Connected Zone (HCZ) in Watershed (2016)
% Riparian Zone (RZ) in Watershed (2016)

% Hydrologically Active Zone (HAZ) in Watershed (2016)
Downstream HUC12

Upstream HUC12 Count, Not Including This HUC12
Upstream HUC12 Area, Not Including This HUC12
NHDPIUS2 Catchment COMID at HUC12 Outlet
1

Next, choose a subset method from the Select Subset Method
drop-down menu.

The Range of Values option allows you to specify minimum and
maximum values of interest for the selected indicator.
Watersheds with indicator values in the specified range will be
included in the subset.

The Unique Values option allows you to select one or more
unique values of interest for the selected indicator. Watersheds
with the specified values will be included in the subset. The
unique values option will typically only be used for categorical
indicators.

Rariae of Values

Unique Values

-------
HUC Subsets Worksheet-Create a New Watershed Subset Button

The Define Watershed Subset interface contain two option buttons for choosing how the subset conditions wil
be used to select watersheds to include in your subset. The option buttons are displayed on the right side of
the interface above the subset list.

Subset conditons are listed below after they are added with the "Add
Condition" button. Up to 10 conditions can be defined.

Watersheds must meet: (5 At Least One Condition

C All Conditions

% Agriculture in WS (2016) = 50 To 100
Name HUC8 Watershed = Delaware Bay

If the AT LEAST ONE CONDITION button is selected,
then your subset will include any watershed that meets
at least one condition in the subset condition list.

> At Least One Condition

If the>UZ. CONDITIONS button is selected, then your
subset will only include watersheds that meet all of the
conditions in the subset condition Iist.

* [All Conditions

After defining your subset conditions and selecting an option for applying the conditions (i.e., At Least One
Condition versus All Conditions), you are ready to add the watershed subset to your tool file with the ADD
SUBSET TO HUC_SUBSETS SHEET button.

By default, a record of the subset name, description, and conditions are saved in a PDF file when the ADD SUBSET
TO HUC_SUBSETS SHEET button is clicked. The PDF file is saved in the same folder as your tool file using the
subset name in the PDF filename. If you would like to create your subset without saving a record of the subset
settings, uncheckthe box above the ADD SUBSET TO HUC_SUBSETS SHEET button.

After clicking the ADD SUBSET TO HUC_SUBSETS SHEET button, the tool will automatically identify watersheds
that satisfy your subset conditions. The subset name and list of watershed IDs in the subset will be added to the
first available column in the HUC Subsets worksheet for use in a screening run.

When you have defined all of your subset conditions dick the "Add Subset to HUC_Subsets Sheet" button below to add the list of watershed IDs to the HUC_Subsets sheet.

Check this box to save a copy of the subset name, description, and conditions as a PDF file for your records. If this box is checked, the PDF file will be saved after clicking the rAdd
Subset to HUC_Subsets Sheet" button below. The PDF file will be saved in the same directory as this tool file and will be named using the subset name.

Add Subset to HUC Subsets Sheet

Delaware Bay Cropland

020200070207

020301050104

"020301050107

020401050603

020401050902

020401050905

020402010401

020402010402

-------
HUC Subsets Worksheet-Manually Add a Subset List

13.3. Manually Add a Subset List

To add a new subset list to the HUC Subsets
worksheet, select the pre-existing list of
watershed IDs from a separate worksheet
(formatted with one ID per row) and click
"Copy" on the Excel menu.

"051301070102
'051301070103
'051301070201
'051301070202
'051301070203
'051301070204
'051301070301
'051301070302
'051301070303

INSI

p»„L^Copy ' I

* Format Painter

Clipboard Q

7 Conasauga 03150101 (7)

8 [031501010102

9 031501010103

10 "031501010104

11 ^31501010106

12 ^31501010301

13 r03l501010302

14 ^031501010303

17
IS

Barren 05110002(13)
"051100020101
"051100020102
"051100020105
'051100020106
'051100020108
'051100020201
'051100020203
'051100020501
'051100020503
'051100020601
'051100020602
'051100020604
'051100020605

Upper Cumberland 05130101 (10)

'051301010201

'051301010501

'051301010502

^>51301010503

'051301010601

'051301010602

'051301010603

'051301010604

'051301010605

'051301010701

Set the cursor to row 8 in the first open column
on the HUC Subsets worksheet.

Paste

Format Pain

«C fx H ¥

A
-------