利用VBA在EXCEL中建立决策分析系统

Building a decision analysis system in Excel by means of VBA

在 Excel环境下 ,利用 VBA建立了一个决策分析系统 .该系统主要由图形显示、数值计算和剪枝三部分组成 ,它把 Excel本身具有的数值计算、分析和处理能力与决策树直观清晰的优点结合起来 ,增强了

A decision analysis system is developed in Excel by using VBA. The system mainly consists of three parts of graphic display, numerical calculation and branch cutting. It enhances modeling and decision analysis abilities of Excel by combining the functions of numerical calculation, analysis and treatment of Excel with the visual advantage of decision tree.