Powder/Tongue River Basin Water Plan
Spreadsheet Models

There are twenty four spreadsheet workbooks, one for each of three hydrologic conditions and six distinct areas:

• Clear Creek from North Piney Creek to the Powder River at Moorhead
• Crazy Woman Creek from Kelly Creek Headwaters to the Upper Station near Arvada
• Little Bighorn River from East Pass Creek to Red Canyon Creek at the Stateline
• Little Powder Creek from Corral Creek to the Stateline
• Powder River from Crazy Woman Creek near Arvada to Salt Creek
• Tongue River from Mead Coffeen Diversion to the Stateline near Decker

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.