Abstract

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
Audit App

Manage Data Easily

Our 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 Support

This 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 Report

The 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:

Programming Language:

Kotlin 1.3.21 version

IDE:

Android Studio 3.3.4

SDK:

Android SDK 28

Third-party Libraries:

FlowLayout
itextpdf

Total Resource allocated to convert
excel to Android App

Project Manager - 1

Sr. Android Developer - 1

Designer - 1

Quality Analyst - 1

Results

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.

Words From Our Happy Clients

Get Your Free Quote

Let’s Build Your App

Locations

India Office

1005, 10th Floor, Abhishree Adroit, Mansi Circle,Beside Gwalia Sweet, Ahmedabad, Gujarat 380015
HR: +91 79 40084018
Sales: +91 7069268048


USA Office

Space-O Infoweb Inc, Suite 100-B 8585 E. Bell Road
Scottsdale, Arizona 85260
+1 (650) 666-3071


Canada Office

2 County Court Blvd., Suite 400, Brampton, Ontario L6W 3W8
+1 (902) 388-4599