区域水资源优化配置多目标模型求解的Matlab与Excel集成实现

区域水资源优化配置模型是决策变量多、结构复杂的非线性多目标模型，简洁快速的求解方法是模型用于实践的关键。利用excel和matlab的特点，通过excellink工具建立excel和matlab的数据通道，实现两者之间的通信，把excel作为数据输入端，调用matlab的函数求解多目标规划问题，实现了对区域水资源配置多目标模型的求解.以郑州市水资源优化配置为例进行了实践应用，应用结果表明，求解方法具有操作简便、易于实现、通用性强的特点。

Integrating Application with Matlab and Excel on Multi-goal Optimized Collocation Model of District Water Resources

The optimized collocation model of district water resources is the nonlinearity multi-goal model with many decision variables and complicated construction. The concise and rapid method is the key that the model is used for fulfillment. Data passage can be built by excellink tool, making use of the characteristics of excel and matlab, which can carry out correspondence from one to the other one. Being the port of data importation, excel can solve multi-goal programming by the function of matlab, which applies to solve the problem of district water resources optimized collocation model. Zhengzhou city is taken as the example for application. The results show this method has the advantage of simple operation, easy realization and general use.