News and Information
Newsletter
Water Planning Process History
Historical Planning Documents
Wyoming Water Facts
River Basin Plans
Statewide Products
Bear River Basin
Green River Basin
NE River Basin
Platte River Basin
Powder/Tongue River Basin
Snake/Salt River Basin
Wind/Bighorn River Basin
Groundwater Reports
Basin Advisory Groups
Mission and Purpose
Calendar
Agendas
Meeting Records
Reference Material
Planning Products
GIS Web Mapping
Framework Water Plan
Platte Water Atlas
Water Search Engine
Send Us Your Comments
Partners
State Engineer's Office
Water Resources Data System
Contact Us
Water Plan Home Page
Water Development Office
|
Wind/Bighorn River Basin Water Plan
Spreadsheet Models
There are 48 spreadsheet workbooks, one for each of three hydrologic
conditions and twelve distinct areas:
- Clarks Fork
- Greybull
- Little Wind
- Lower Bighorn
- Lower Wind
- Madison
- Nowood
- Owl Creek
- Shoshone
- Upper Bighorn
- Upper Wind
- Yellowstone
For further information including both a user's guide and engineering documentation of the models please
refer to the Spreadsheet
Model Development and Calibration.
Steps for Downloading the Models
The three workbooks (wet, dry and normal years) for each area are yoked together with a simple menu-driven graphical user
interface (GUI), effectively creating four area models. In addition, the spreadsheet models are stored as
zipped Microsoft Excel files using WinZip compression software. An evaluation
version of WinZip may be downloaded at
http://www.winzip.com/download.htm
- Download the models by clicking on the file name and saving to your local directory. Depending on
the browser this may entail only responding to a prompt, or choosing "Save As..." from the browser file menu.
- Once on the local disk, double click the zipped file to extract the Excel Workbooks. A total of 4 files will be
extracted for each zipped file.
- In Microsoft Excel, open the area Model file. From this graphical user interface the wet,
normal, or dry year models may be selected.
- For further information on the use of the models please refer to the tutorial included in each of the workborks.
|