Case Study

Microsoft Excel Forms


This project started under the observation of Microsoft Corporation. The requirement of this project is for government/ public sectors to save their time and manpower. The idea was to develop a solution which could be used for form designing, form download, data collection through the form in offline mode, i.e. absence of network connectivity &data upload to the server.

Business Challenges:

Client need an application which have facility to design a form for data collection (like birth certificate and etc.) and that data can be filled by the operators even in absence of internet connectivity. The major challenge of the project was to make a solution which could design different styles of forms, could help in circulating the form securely, and enable secure upload of the data to server as and when network becomes available. Further there was a need to make the solution which could be easily acceptable. Since the data collection part in villages is generally managed by people who are not versed in high end platforms, thus Microsoft excel seemed the best option.

Solution:

We developed an application(Microsoft Excel – Forms) which contains two facilities first is for designing an excel form as per their requirement by using drag and drop option and second is offline data collection in Macro enabled Excel Workbook. Microsoft Excel – Forms can later be used by various authenticated users to collect data. The distinctive advantage of E - FORMS is its ability to work in offline mode i.e. in absence of network connectivity. Data could be entered and temporarily saved using the apps for office forms integrated in the macro enabled excel workbook and could be uploaded to server as and when network becomes available. Form provides bi-lingual support as well. E-forms imbibe upgraded features which enables the user not only to design forms but also to download them and operate on it even in absence of network. SharePoint enables the user management of the application and provides authorization as per the type and needs of the user.
Soon after the solution was developed we received a huge positive feedback on the same. Trendsetterz is still in the process to upgrade the features and functionality of the solution. The mobile version of E-forms is also under construction.

Benefits:

•  Access forms without Network Connectivity,   • Highly Secured Data,   • Design different styles of forms in minimal time,    • Consolidated view of Disaster Recovery readiness,    • Easy ongoing maintenance.


Technologies

Client Testimonial

  • “Thank you very much Team Trendsetterz for turning around this competent application in quick time. The functionality of offline forms is working right as desired. Our App matches with the competitive productivity platform offerings of similar nature, like from Adobe etc. Great work team.”

    Mr.Sanjay Bobde Director (Public Sector) Microsoft India