程序

新编写的一款影片结算系统

作者:Leon 日期:2010-03-04

字体大小: 小中大

With the fast increase of Wanda Cinemas, the data has become increasingly massive, and the settlement of box offices to the upstream distributors is becoming more and more complicated. Once at the end of each month, my subordinate, who oversees this work usually has to spend several days completing it, with Excel to analyze, split, and summarize data across numerous tables. Since the beginning of this year, I found her work has seriously affected the whole working progress of the finance department because all the work was purely processed manually. But the problems were obvious: firstly, the data accuracy wasn’t guaranteed, and secondly, the efficiency is too low. Thus, I started programming a little system and try to highly decrease manual processing and automatically generate settlement data. The framework of the system used a combined mode: ASP+Access+Excel, which took me about 3 days to develop. After using the system, the processing time was reduced from 5 days to about half a day, and what’s more, the quality of the data increased a lot.
随着下属影院越来越多，数据量越来越海量，片款结算工作越来越复杂。每到月末，我手下的结算主管就头大如斗，每月都要花好几天时间跟EXCEL较劲，去分析、拆分、汇总编织片款结算表。今年以来我觉得她这块工作已经严重影响到了全部门整体的工作进度，通过手工处理，一是数据不能保证完全准确，二是效率实在是太低了。于是动了采用程序自动生成结算基础数据的念头。说干就干，程序采用ASP+Access+Excel模式编写，耗时3天左右。上线之后，该项工作从5天左右缩减到半天左右，数据质量更是有了质的飞跃。
The screenshots are as follows:
该系统截图如下：