Monday, January 25, 2010

Excel reporting

Excel is an excellent tool for reporting results of optimization models. Some models produce a ton of data and it is not always easy to find a compact way to present all this information. Here is an (early draft) example of an investment selection model for water management projects. During first few days of experimenting with the model, this has been quite useful to get a quick sense of the solution.