News and Information
 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
 Meeting Records
 Reference Material

Planning Products
 GIS Web Mapping
 Framework Water Plan
 Platte Water Atlas
 Water Search Engine
 Send Us Your Comments

 State Engineer's Office
 Water Resources Data System

Contact Us

Water Plan Home Page

Water Development Office

Bear River Basin Water Plan
Spreadsheet Model

Steps for Downloading the Model

The three workbooks (wet, dry and normal years) are yoked together with a simple menu-driven graphical user interface (GUI). 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

There are two versions of the model which can be selected for each of the three hydrologic conditions. The differences between the versions lie in the manner in which the ungaged reach gains and losses are determined. To determine which of the two versions to select please read the following Model Version Selection Memorandum.

  • Once the model is selected, download the model 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.
  • In Microsoft Excel, open the Bear River 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 the workborks. For additional information, including both a user's guide and engineering documentation of the model, please refer to the Task 3B Surface Water Data Synthesis and Spreadsheet Model Development Technical Memorandum.

Bear River Basin Spreadsheet Models

Bear River Basin Model   2,407 kb compressed
10,820 kb uncompressed

Bear River Basin Model - Archived   2,193 kb compressed
  10,650 kb uncompressed

* Please note that these files are in read only format. Any changes to the model made by the user may change the results and must be saved with a new file name.

** For Windows XP users - Due to additional security levels, XP users may have to manually change their security levels. If you receive a message when opening Microsoft Excel that reads as follows: "Macros in this workbook are disabled because the security level is high..." click OK and perform the following routine: Under the Tools menu, click on Macro then Security. Change the Security Level to Medium, this will enable the user to go to the Spreadsheet Model Main Menu.

   Citizen    Government    Business    Visitor   Privacy Policy