基于VBA的城市商品房价格统计系统设计

The Design of Urban Commercial Housing Price Statistics System Based on VBA

针对统计部门进行商品房价格统计工作中手工操作困难的问题,在分析商品房价格统计系统功能的基础上,给出了系统的功能框图,结合Excel的VBA技术,给出了系统核心模块的实现流程,并基于字典对象进行了设计和编程。实践结果证明,利用VBA技术设计的统计系统简单实用,对于相关行业的统计工作有一定参考价值。

To solve the problem that commercial housing price statistics manual work is difficult for the statistics depart- ment, based on the analysis of commercial housing price statistics system functions, gives the functional block diagram of the system. Combined with Excel＇s VBA technology, gives the realization of the process system core module ,and design and programming based on dictionary objects. The practice results prove that the statistics system based on VBA is simple and practical, and has a certain reference value for the statistical work of relevant industry.