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.

Spreadsheet Models
Clarks Fork Model 2585 kb compressed
13757 kb uncompressed
Greybull Model 4273 kb compressed
23087 kb uncompressed
Little Wind Model 2638 kb compressed
13609 kb uncompressed
Lower Bighorn Model 3195 kb compressed
16728 kb uncompressed
Lower Wind Model 4038 kb compressed
22351 kb uncompressed
Madison Model 761 kb compressed
2717 kb uncompressed
Nowood Model 4171 kb compressed
22825 kb uncompressed
Owl Creek Model 2978 kb compressed
15490 kb uncompressed
Shoshone Model 6036 kb compressed
34218 kb uncompressed
Upper Bighorn Model 3348 kb compressed
17739 kb uncompressed
Upper Wind Model 5236 kb compressed
29300 kb uncompressed
Yellowstone Model 1261 kb compressed
5822 kb uncompressed


   Citizen    Government    Business    Visitor   Privacy Policy