基于Excel VBA的ERP沙盘模拟经营决策支持系统的设计与实现

Design and implementation of ERP sandbox simulation business decision support system based on Excel VBA

利用Excel VBA技术,探讨了用友新道"新商战ERP沙盘模拟经营"平台决策支持系统的设计与实现过程,着重阐述了本研究成果的教学实践。实践结果表明,Excel VBA技术对于沙盘企业的现金流监控、财务核算以及整体实验效率的提高有显著作用,能够有效为沙盘模拟实验的参与者提供决策支持。

Using Excel VBA technology,this article tries to explore the design and implementation decision support system of the New Commercial War ERP Sandbox Simulation Management platform of the Seentao Corporation,and focus on the research results of teaching practice. The practical results show that Excel VBA technology has a significant effect on the cash flow monitoring,financial accounting and overall experiment efficiency of sandbox enterprises,and can effectively provide decision support for participants in the sandbox simulation experiment.