GA4 (398745346)

SpreadJS customer case: Deeply empowering large state-owned enterprises to build ledger management systems

SpreadJS customer case: Deeply empowering large state-owned enterprises to build ledger management systems

“The pain points of airport ledger management are large numbers, heavy filling, difficult retrieval, and slow checking, which will lead to extremely low employee work efficiency. With the help of SpreadJS, a front-end form plug-in, the pain points of ledger management are solved and the ledger management is improved. s efficiency. “

——Western Airport Group Co., Ltd.

  Company Profile

Western Airport Group Co., Ltd. (hereinafter referred to as Western Airport) is affiliated to the Shaanxi Provincial People’s Government. Its predecessor was Xi’an Xianyang International Airport. After the airport localization reform in 2003, Xi’an Xianyang International Airport received four regional airports: Yulin, Yan’an, Hanzhong and Ankang. , established Shaanxi Airport Management Group Company. In 2004 and 2006, it achieved joint reorganization with Ningxia and Qinghai Airport Companies respectively, and was renamed Western Airport Group Company. Up to now, the group has jurisdiction over 18 airports in the three provinces (regions) of Shaanxi, Ningxia and Qinghai, forming an airport cluster with Xi’an Airport as the core, Yinchuan and Xining Airport as the two wings, 12 branch lines and 3 general airports as the support. The number of airports and The aviation business volume accounts for 70% and 80% of the total civil aviation volume in the northwest region respectively, and it has developed into the second largest large-scale airport management group operating across provinces (regions) in the country. The group has laid out the industrial chain and extended value chain around its main aviation business, involving aviation logistics, hotels and catering, advertising media, information technology, duty-free operations and other fields, forming a diversified, segmented and large-scale collaborative development pattern.

(Picture from the official website of West Airport)

  business background

As a basic tool responsible for recording work processes and results in the enterprise and implementing refined management. Ledgers are the most common form in business activities, involving various fields, such as production ledgers, accounting ledgers, sales ledgers, business ledgers, etc. Due to its flexible format and wide range of uses, Excel is currently widely used to create templates, distribute, fill in and print.

(Ledger definition)

Western Airport summarizes the following key issues in traditional ledger management:

  (1) Large number of ledgers: The types of ledgers for airport work and training work are constantly subdivided, resulting in an increasing number of ledgers. In addition, the number of positions at the airport is numerous and scattered, making ledger management a challenge.

  (2) Employees should fill in:On the one hand, filling in the ledger requires paper documents, and on the other hand, it requires manual entry into the computer system, which is a heavy workload. For employees, repeating the ledger multiple times will undoubtedly reduce the overall work efficiency.

  (3) Data retrieval is difficult:The amount of information stored in paper documents is small. Compared with electronic ledgers, retrieval requires a lot of time and manpower. Entering a large amount of paper information at the same time will inevitably lead to information errors, which will be difficult to verify and slow down the entire work process.

  (4) Supervision and inspection are slow:Because paper information is difficult to quickly share with relevant personnel, and after paper documents are classified and stored, it is difficult to quickly find the required documents; it is inconvenient to promote more frequent supervision and inspection work.

(Pain points of ledger projects)

In order to better solve the pain points in traditional ledgers, under the guidance of the “14th Five-Year Plan for Informatization”, Western Airports actively carries out digital transformation with the goals of improving management efficiency, accelerating airport smart transformation, and promoting industrial innovation and upgrading. Explore, combine basic management improvement and the three-year action plan for “three foundations” construction, use data as the starting point, use cloud, big data, Internet of Things, blockchain and other technologies to improve production and operation efficiency, and launch the group platform in 2021 Promote the electronic accounting business.

  Exploring the electronic ledger

In the exploration of the ledger electronic process, West Airport summarized the group’s electronic ledger types and classified them into two categories: process management and result management:

  Process management (bottom up):Starting from employees, to duty/shift scheduling, to tasks, to evaluation and planning, and finally to plan organization, electronic on-duty management is realized.

  Results management (top-down):Set up requirements from the group side (data integration, unified templates, compliance with industry inspection requirements, high-level restoration of existing reporting methods, etc.), and then distribute the standards according to the group level, focusing on results management.

(Method for electronic ledger implementation)

In order to solve the pain points of paper ledgers and create an electronic ledger system that satisfies both process management and result management, at the beginning of system design, West China Airport set the following system goals for the electronic ledger system:

  Ease of use:Because most of the users who fill out the reports are front-line employees, the electronic ledger system needs to be low-cost to learn and operate, and it needs to be easy for users to get started quickly.

  Unity:For group management, in order to better solve the differences in system filling, it is necessary to ensure that the electronic ledger system has a unified format in filling methods, classification standards and template content.

  Empowerment:Data can be extracted, mined and analyzed according to personalized needs to build high-value applications.

  interoperability:There is no need to fill in the form repeatedly. All accounting services are only filled in once to achieve data sharing.

(Goals for electronic ledger construction)

After determining the system goals, the data technology team of Western Airports began to build the idea of ​​​​building a ledger management system. During this process, the team encountered the following three technical difficulties:

  (1) Scattered Excel files are difficult to centrally manage:The ledger template is filled in by each business department. When it is difficult to ensure ease of use, a software system is used to extract valid data from the flexible and complex template. At the same time, because the permissions of the Excel document itself and the permission system in the information system are not unified, it is difficult to integrate into the existing business management process.

  (2) Unable to reuse Excel template:The data technology team of Western Airports has also tried to develop a self-developed reporting system, but due to the large number of people who use Excel daily, the training cost is too high, and the Excel templates that have been written are difficult to reuse.

  (3) Print, import and export Excel and PDF:It is difficult for the self-developed system to solve the various needs of users for functions such as printing, exporting Excel and PDF, common needs in form printing such as printing paging, printing area settings, paper settings and table header duplication, as well as problems with printing accuracy and document IO, etc. These are all technical difficulties often faced in self-developed systems.

(Difficulties in project development)

  SpreadJS solves technical difficulties

In order to better solve the above three difficult problems, West Airport finally chose SpreadJS after evaluating a variety of controls. The reason is that SpreadJS has the following features:

  (1) Support real-time online editing by multiple people:SpreadJS provides cell-level operation granularity. Through secondary development, Excel documents can be parsed on the front end to meet the needs of multi-person collaboration, collaborative editing, data synchronization, reduction of repeated filling in, and data sharing.

  (2) Excel-like native interactive experience:SpreadJS is a pure front-end table component based on the H5 standard. It is highly compatible with Excel, supports 90% of native formulas, and supports rich Excel features to facilitate efficient data analysis.

  (3) Fill in the template uniformly:SpreadJS can realize online import and export of Excel (xlsx) unified templates through the front-end interface, and visually operate unified templates.

  (4) Data structuring:SpreadJS can achieve data structuring after simple data binding.

  (5) Easy to operate:SpreadJS has a highly Excel-like interactive interface that enables efficient template design, online editing and data binding, allowing your system to easily achieve an interactive experience close to native Excel.

  (6) Complete technical support:SpreadJS has complete after-sales support and resources, and can develop different learning paths according to different people. In addition, it also contains rich technical documents and reference guides.

(SpreadJS value)

  EmbedIntroduction to some functions after SpreadJS

  (1) Template construction

Since the templates of the ledger system change very frequently, the business department needs to respond more quickly. Using SpreadJS to build a table system similar to Excel can highly restore the usage habits of Excel and lower the learning threshold for business personnel.

At the same time, template upgrade and maintenance no longer require developer intervention, which can improve the system’s agility in responding to changes in business requirements. The system uses SpreadJS to implement functional modules such as Excel template import and export, data binding, and data supplementary entry, which can effectively reuse the company’s existing Excel assets and achieve smooth migration of online and offline data.

(template building)

  (2) Data filling

In the process of filling in template data, it is necessary to control the filling permissions in different areas according to business needs. Traditional methods are difficult to control user behavior. However, with SpreadJS, only a small amount of code is needed to achieve cell-level permission control, and it can be adjusted as the business process changes. Transfer dynamic change permissions.

(Fill in data)

  (3) Import and export Excel

SpreadJS provides the “what you see is what you get” capability. For the four requirements of filling in, displaying, printing, and exporting, you only need to maintain a set of templates to ensure that the effects of different IO exports are highly consistent. Moreover, SpreadJS’s powerful interface and secondary development capabilities also allow customers to flexibly introduce custom extended font libraries and third-party mathematical formula design plug-ins to realize interaction with users and fill in reports.

(Import and Export)

  Customer testimonials

The relevant person in charge of the Western Airport said:

Combined with GcExcel, a high-performance server-side component, SpreadJS can perform batch operations on templates and data on the backend, realizing scenarios such as automated reports, massive data calculations, and batch export of PDF and printing, providing information systems with more flexible and powerful table processing capabilities.

Source link