9560

• UCREFRP Catalog Number: 9560
• Author: Valdez, R. A.
• Title: A Generalized Interactive Model to Predict Floodplain Habitat Area Needed to Recover the Endangered Razorback Sucker in the Upper Colorado River Basin - Floodplain Model Version 5.1.
• USFW Year: 2004.
• USFW - Doc Type: Logan, UT.
• Copyright Material: NO

11

I
I
I
I
I
I
I
I
I
I
I
I
il
I
I
I
I
I
I

habitat area needed to recover the endangered razorback sucker in the Upper Colorado River
Basin. FLOODPLAIN is written on a Microsoft Excel 2002 platform, but can be used on other
versions of Excel. The model is constructed to allow users access to entry cells for data input
and it provides automated data output.
FLOODPLAIN is driven by a series of mathematical relationships that are invoked with
input variables specified by the user. Automated output variables that result from these
relationships are displayed on the spreadsheet in labeled rows and columns. A single variable
input affects all subsequent variable outputs.
FLOODPLAIN is write-protected (Le., read-only) to prevent accidental alteration of
internal mathematical relationships and linkages. Only the cells identified as data entry cells are ,
unprotected and allow the user to input data variables to run the model. If the user tries to enter
data, or otherwise alter a protected cell, an error message will appear. The user can exit the error
message by clicking the "OK" on the message box.
4.2 Structure of the Floodplain Model
An Excel file is provided with this report that contains five worksheets and seven charts.
Printouts of the eight charts are provided in Appendix B. Instructions on how to access and run
the model are provided in Sections 4.2 and 4.3. The three worksheets are:
Worksheet 1: "Model".-this worksheet contains the primary model FLOODPLAIN
and consists of 31 identified steps, including 21 user-specified input variables and 50 output
variables. A description of each of the 31 steps in the model is provided in Section 4.3. This
worksheet also contains three figures which illustrate hectares and acres of floodplains, number
of fish surviving to recruitment, and recruitment rate. A user guidance is provided on the
worksheet to facilitate use of the model.
Worksheet 2: "Drift".-this worksheet contains a drift sub-model that estimates the
downstream drift and entrainment of larvae from the spawning bar. This sub-model has three
user-specified input variables and five output variables. A box is provided of 1 00 river miles
which allows the user to specify overall survival rate and percentage entrainment at each river
mile; this allows the user to simulate a specific river reach with known spawning bar and
floodplain locations. This sub-model also allows the user to simulate runs for floodplain