Water Optimizer Programs

There are two versions of the single field Water Optimizer model available, one for computers using Excel 2003 and one for computers using Excel 2007. If you have a newer computer which uses Excel 2007 but want to continue using your 2003 version of the model you can do so by downloading and following the instruction in the Excel Solver Macro Fix document.  (Requires the free Adobe Reader available here.) 

Water Optimizer for Excel 2003
• Compatible with Microsoft Excel versions 2002 (part of Office XP) or 2003 
• Supports all 93 Nebraska counties 

Water Optimizer for Excel 2007
• Compatible with Microsoft Excel versions 2007 (full version must be installed)
• Supports all 93 Nebraska counties

Water Optimizer Manual
Water Optimizer Supporting Documents

Prices and Costs in Water Optimizer
Describes the process how default values for crops and energy sources originate.

Excel Solver Macro Fix
This document includes step-by-step instruction on how to allow Water Optimizer 2007 to run.
Instructions for Adding Solver to Microsoft Excel 2007 

Contacts:
 For Question regarding model use and applications call:

  Brian McMullen – Water Resources Associate
  bmcmullen2@unl.edu (402)-472-1781

  or
  
  Chris Thompson – Research Associate
  cthompson2@unl.edu (402) – 472-8602