Designed and developed by our Android app developer team, City of Greeley is a water station audit app, replacing the conventional way of generating landscape irrigation audit report with an automated one. Available on the Android platform, this water audit app has made it easy for water conservation specialist to generate entire landscape irrigation audit report with just a few clicks on the screen.
Without writing manually and managing paper-based reports, water auditors can make the entire report in the application, filling complete information like date of assessment, arrival time, completion time, evaluator, rain sensor, controller type, and other important details.
Problems Water Auditors in Greeley Used to Face
Based in the USA, our client (Greeley Gov.) decided to create app from excel spreadsheet, allowing water auditors to generate water station audit report in the mobile app.
Previously, water auditors and inspectors were creating a report in the paper-based forms and excel sheet, filling the entire data manually. The entire process of filling information in the excel sheet and paper-based form was taking much time of the auditors.
The water auditors were filling complete information like account number, customer name, address, and type of assessment in the form and excel sheet. Many a time, excel sheet created confusion among water auditors and they were spending maximum time and efforts in maintaining such papers and sheets.
So, the Greeley Government decided to convert spreadsheet to app (water audit mobile app) so that water auditors can generate water station audit report in the app.
How Our Client Found Us
As our client decided to convert excel to mobile app, so he was looking for the mobile app development company which has special expertise in converting excel sheet into app. Our client searched in Google and found one of our blogs on excel sheet to mobile app. Impressed by our blog, our client directly contacted us with his requirements.
The First Step We Took
We took almost one week to comprehend our client’s requirements. In fact, we spent time on comprehending entire Greeley Gov. and its conventional process of generating a report.
We checked the excel sheets and paper-based forms that water auditors used to fill manually. After researching and digging deep, we decided to turn excel spreadsheet into app (water audit mobile app) for the department.
Some Key Features of Water
Manage Data EasilyOur developed water audit app has made it easy for water auditors and inspectors to manage all the data and information easily. Even, inspectors can access the save information anytime and anywhere and edit if requires.
Offline SupportThis audit app of Greeley water and sewer department works offline, allowing auditors to fill information like customer information, customer program, site inspection, and recommended program offline in the app.
Create a PDF of the ReportThe app allows users to create a PDF version of the report and send it to any citizen directly on his/her email. The app creates PDF with one single tap on the screen.
Do you have any such excel sheet that you want to convert into an iPhone or Android app? Get in touch with us and let us suggest the best possible solution for your business.
Android App Development of Water
Station Inspection App
As our client decided to converting excel to standalone application only on the Android platform, so we assigned one of our Android developers, who has almost 2 years of experience in the Android app development industry.
Our assigned Android programmer did not work on any such application previously, so he spent some time on researching about the project, comprehending the excel sheet and its formulas. While developing the app, he faced some issues of macros of excel, which had complex logic.
It was a major issue for our developer; however, he resolved it by extending his knowledge of excel sheet. According to our developer, the most unique features of this app are - generate PDF report, export PDF report to citizens, and mobility for water auditors and inspectors.
Ultimately, our Android app developer successfully converted excel to app or we can say developed this water audit and inspection app within 2 months using the following tools and technologies:
Kotlin 1.3.21 version
Android Studio 3.3.4
Android SDK 28
Total Resource allocated to convert
excel to Android App
Project Manager - 1
Sr. Android Developer - 1
Designer - 1
Quality Analyst - 1
Overall, it was a great experience for our team to convert excel spreadsheet to app (water audit app) successfully. Our client was more than happy to see that the app is working on the field. In fact, our client gave us a 4.5/5 rating for our internal evaluation of work.