We wanted to streamline the data entry process for using World Bank's Curb tool, which allows clients to reduce the carbon footprint in their cities and plan for a more efficient, sustainable future while saving costs and making the best investments. Additionally, we wanted to directly route this user data into Microsoft Excel documents to expedite the process of using this great tool.
What it does
Users download and install the mobile application on iOS or Android, and from there they can enter data that pertains to numerous sub-categories. Once the client is satisfied with his/her entries, they can review and submit the data to our server, which then parses the data into a Microsoft Excel (.csv) spreadsheet file. This spreadsheet is then immediately compatible with the Curb tool.
How we built it
Our app was built using the Ionic, a framework designed to make simple mobile apps for both Android and iOS devices. Additionally, we implemented a Node.js server with Express to handle to server-side data processing, and the conversion of user data to Microsoft Excel was implemented with a Google Script to take advantage of the Google Sheets API. The design and mockups for this project were done in Adobe Illustrator and Photoshop.
Challenges we ran into
Data visualization, exhaustion (for most of us this was our first hackathon), and merging the different components together in the end to get a working product.
Accomplishments that we're proud of
Our conversion of JSON data to Microsoft Excel document, creating a functional app in a new framework (Ionic) for iOS and Android, and successful delivery of most of the features we hoped to add.
What we learned
Working in teams allows for tons of opportunities for building on others' knowledge to collectively accomplish impressive tasks. While at times it seemed hectic and chaotic, we learned to trust each other and not be afraid to ask for help when one of us felt lost.
What's next for WorldBankCurb
Implementing more sophisticated ways to convert JSON data to Microsoft Excel sheets that protect user data, finishing data visualization, and minimizing the need to scroll through loads of data by means of drop-down menus.