The WHAT-IF (Water, Hydropower, Agriculture Tool for Investment and Financing) model is an open source decision support tool distributed under the GPLv3 license and is described in the HESS publication:

WHAT-IF: an open-source decision support tool for water infrastructure investment planning within the Water-Energy-Food-Climate Nexus

The decision-support tool can be used in single-run mode or in scenario mode:

• WHATIF_main.py Single run of the model, collects the parameters from the data module, creates an hydroeconomic optimization model, solves it and exports the results
• WHATIF_scenario.py Multiple runs of the model, collects the parameters from the data module, creates an hydroeconomic optimization model, solves it for all specified scenarios and exports the results for each scenario as well as a synthesis of all scenarios

The bin folder contains the main libraries for the decision support tool:

• data_collection.py Collects the data from the excel files (MainFile, WaterModule, AgricultureModule, CropMarketModule, EnergyModule) into a python object
• hydroeconomic_optimization.py Formulates the optimization problem of the water-energy-food management (and investments at a later stage)
• result_analysis.py Performs the analysis of the results and exports them towards the excel/python files

The Data folder contains the requiered data for the different modules:

• MainFile.xlsx Is the configuration file, specifying the time steps, options and scenarios that are used by the model.
• WaterModule.xlsx Data supporting the Water module, including the hydrology (runoff, evapo-transpiration, precipitation, groundwater recharge, catchments …), the reservoirs and the environmental requirements
• AgricultureModule.xlsx Data supporting the Agriculture module, including farming zones, farm types, crops and cultures characteristics.
• CropMarketModule.xlsx Data supporting the crop market module, including crop markets, demands, value of crops, transport routes and food security constraints.
• EnergyModule.xlsx Data supporting the energy production and energy markets modules, including hydropower plants, other power plants, power technologies, fuels, energy markets, demands, value of energy and transmission lines.

The Documents folder contains additional information:

• Data_Organization.docx summarizes the organization of the data for the WHAT-IF model and the HESS publication
• COMMON ERRORS.docx lists most common programing errors when using/developing the model
• WHATIF_py27.yml is the conda environment with all the useful packages to run WHAT-IF,
• INSTALLING_WHATIF is a step by step guide on how to install and run WHAT-IF

The Documents folder contains a step by step guide INSTALLING_WHATIF describing the process, in brief:

• Install the Anaconda navigator, the simpliest way to manage your pyhton packages and versions

• Install the WHATIF_py27 environment from the Documents folder

To do so, in the anaconda prompt, run:

conda env create -f WHATIF_py27.yml

• Recommended solvers are cplex (free for academics) or glpk (open-source)
• WHAT-IF is also compatible with Python 3.7 and will be soon only released in python 3.7

Payet-Burin Raphaël (rapp@env.dtu.dk) Mikkel Kromann (mikr@cowi.com)