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.
