MPMAS - Single-Agents-Version
"Interactive Modelling Chile"

(c) 2005-2009 Chris Schilling, Christian Troost, Evgeny Latynsky,  Pepijn Schreinemachers, Thomas Berger
Universität Hohenheim


**Visual Inspection of Results**

The two files XsingleAgents60.xls and XSingleAgents100.xls contain both input and output data for the scenarios described in the article.
The former contains the scenarios with 60% water allocation, the later with full water supply. 

In both files, the sheet RHS contains the right-hand-side values for the different farms under different scenarios, and the Results sheet the respective solution vectors and the optimized target value (Total Farm Gross Margin).

The scenarios are denominated as follows 

first letter:
	B - without investments
	I - with Investments
	A - with Investments and Advanced Irrigation Technologies

number:
	 60	-  60% water supply (dry year)
	100	- 100% water supply (normal year)

comparison scenario:
	base	- baseline
	secured - with one insecure water right secured

farms:
	farm<X>	 FarmID

The file Matrix_IAM.xls contains the MILP-Tableau used in all scenarios.



**Reproduction of Results**

If you want to reproduce the calculations do the following:


Installation:

1.	Install the IBM OSL library (see MP-MAS-homepage for details)

2.	Install the MP-MAS Excel Add-In (MPMAS.xla) in your Excel


Solving:

1.	Make a working copy of the XSingleAgents<60/100>.xls file you want to use and name it XSingleAgents.xls (without number).

2.	Open XSingleAgents.xls

3.	(Change the RHS values (sheet RHS) or matrix coefficenty (file Matrix.xls) according to your preferences.)

4.	Choose "Solve XSingleAgents.xls" from the MP-MAS Add-In menu.

--> the Add-In will now convert the Input fiels, send it to the solver (milpcheck.exe) and reimport the results into the "Analyze" sheet. however, we recommend to use the "Results" sheet, which offers a summary of the results for inspection.


5.	Go to the sheet "Results" and click on the "Press to update view!" button to renew the default and check the results.


