China Mobile Group Guangdong Company Limited Shantou Branch, the largest mobile telecommunications provider in Shantou, struggled with traditional, error-prone ways of compiling data and reports. The company needed a solution to improve employee satisfaction and productivity. By leveraging Office technologies and existing business applications, China Mobile not only migrated its data processing into Excel with little development costs, but also enhanced employee efficiency.Situation
Employees at the Shantou Branch of China Mobile typically spend a lot of time compiling and summarizing data and reports. Traditional ways of doing this type of work present three drawbacks that severely impact productivity and quality:
Firstly, data is decentralized and often in a state of flux. Many people fill in forms and make frequent changes, increasing the workload exponentially as more manual operations are required.
Secondly, the traditional way of summarizing data reports is emailing back and forth, which is extremely inefficient.
||Microsoft Office products have outstanding functionality, and meet our requirements by allowing extensive secondary development. Companies can integrate Microsoft’s products into their processes, forming a one-stop service model…
Vice President, China Mobile Group Guangdong Company Ltd., Shantou Branch
Thirdly, with manual copying and pasting, the reports tend to be error-prone.
In light of the enormous demands placed on business applications, the IT experts at the Shantou Branch of China Mobile developed Quick Reports based on Microsoft Office 2010.Solution
Developers leveraged Microsoft’s .Net platform and Office 2010 components to build the solution, resulting in highly effective form definitions, report transfers, and office synergy.
Using Office’s real-time communication systems and Excel’s functionality including its form design, form statistics, mathematical functions and data effectiveness, China Mobile was able to create a solution without the need for additional development.
Now, users can automate data collection and statistics, reducing repetitive tasks associated with data collection and statistics production. The solution integrates well with China Mobile’s existing corporate application system, allowing real-time information sharing and collection.
China Mobile was able to reduce development costs by leveraging existing corporate application platforms. Using Excel’s existing functionality resulted in a tremendous reduction in development costs while making data collection and processing easy. The company installed the solution at client end, where users already had Office Excel 2010 on their machines, which also lowered hardware needs and costs. Benefits
Easy To Use, Familiar Interface
Users are familiar with Office, particularly Excel, and, the solution has been easy to use. In addition to automated operations, there is also support for manual data input, and data services can be accessed by third parties very easily. This reduces the number of interfaces users encounter, allowing them to complete data entry in a familiar Office environment.
The customizable forms and processes help employees in their day-to-day tasks and reduce work stress by providing a faster and more convenient task completion.
The flexibility and ease of use not only support client-end operations, but also allow for real-time, intuitive, and clear Web operations and data charts.
Virtual Binding, Seamless Integration
With virtual binding, the company saves on hardware needs for deploying Office 2010. Once applications have been virtualized, the user doesn’t have to install Office, nor is it necessary to install plug-ins or perform plug-in upgrades, as the version is the same across the board and the plug-in defaults are loaded and disseminated.
Visualized and self-defined Excel 2010 integrate with Excel perfectly. The simple installation process supports automatic version upgrades, and installing or running ClickOnce won’t interfere with existing applications.
Users can set up distribution based on templates, assign recurring tasks, and distribute forms automatically on a regular basis. Reviewers can be designated and summary data sent directly to them for review.
For example, customized templates can include reminders for how to fill them out. Once forms have been defined and tested for legitimacy, they can be distributed, after which text messages can be sent out as reminders.
Report distribution can also be customized. If the person filling out the form requires additional people, then further form-filling privileges can be defined and forms can be distributed to more colleagues. These reports can be sent out regularly daily, weekly, or monthly, and intelligent templating and report distribution enhances productivity and shortens the procedure.
Web-based Form Filling and Distribution
A program for operating and reading Excel can be used to set row height and column width and to merge cells as well as acquiring cell data and field data. Excel forms can be reconstructed and field hierarchy can be assigned on the Web as a means of preparing data. Forms can be filled out on the Web and documents can be downloaded. Forms can also be read on the Web. This solves the problem of incompatible versions of Office or users unwilling to install various plug-ins.
The third party call table acquisition service module allows access to the XML operational module for Excel data tables so that data tables or portions of data information can be acquired.
The system is already in use in some cities, and has been be very effective. It has also been very effective in the areas of provisional data collection, elections and data summarization. The automated form distribution and summary functions reduce the manual workload involved with data collection and the need for email servers, while enhancing the overall efficiency of data collection.Microsoft Office 2010
Microsoft Office 2010 gives your people powerful, timesaving tools to do their best work from more places. With new capabilities and insightful updates to Excel, PowerPoint, Word and Outlook, Office 2010 offers the complete package— with familiar, intuitive tools. Now you can express ideas, solve problems, connect with people, and create amazing results—in the office, at home, or on the go. For more information about Microsoft Office, go to: www.office.comFor More Information
For more information about Microsoft products and services, call the Microsoft Sales Information Center at (800) 426-9400. In Canada, call the Microsoft Canada Information Centre at (877) 568-2495. Customers in the United States and Canada who are deaf or hard-of-hearing can reach Microsoft text telephone (TTY/TDD) services at (800) 892-5234. Outside the 50 United States and Canada, please contact your local Microsoft subsidiary. To access information using the World Wide Web, go to:
For more information about China Mobile Group Guangdong Company Limited Shantou Branch, visit the Website at:
China MobileDocument published 7/29/11