Introduction

In this project, I worked with a client to develop a cross-platform app for iOS and Android that provides automated saw band and machine configuration recommendations based on specific cutting requirements. The app calculates the optimal configuration using complex data models, which were originally housed in a massive and intricate Excel sheet.

Understanding the Challenge

The key challenge was translating a vast and complicated Excel spreadsheet—containing numerous tables and formulas—into a structured data model and backend algorithm. We collaborated closely with the client to ensure the data models accurately reflected the original calculations.

From Excel to Data Models

Working iteratively, we analyzed the client’s Excel sheet and transformed the calculations into database models. After finalizing the data models, we mapped out how each model would interact with the app’s logic to generate recommendations. This required:

• Cleaning and restructuring the Excel data into JSON format.
• Developing scripts to process the JSON data and upload it to Firebase Datastore.

App Design and Development

Design

Once the concept and logic were approved, I created the app’s design using Figma, incorporating the client’s corporate identity (CI). We opted for Material UI as the design foundation, customizing it to fit the client’s branding.

Technology Stack

To stay within budget, we chose a streamlined tech stack:

• Firebase for authentication, storage, and backend logic with Cloud Functions and Datastore.
• Flutter for cross-platform mobile development, enabling the app to run smoothly on both iOS and Android devices.
• Riverpod for state management within the app, ensuring seamless data flow.

Development Process

The most significant technical challenge involved converting the complex Excel data into JSON format. I extracted relevant data, cleaned it up, and used a custom script to convert it into a format suitable for Firebase Datastore.

From there, I developed the backend logic that handled the core calculations and validations. The frontend was developed in Flutter, and I customized Material UI themes to match the client’s branding. A unique input theme was created to streamline the user experience.

Key Features

• Automated saw band recommendations based on input parameters from customers.
• Firebase integration for storage, authentication, and cloud functions.
• Custom input theme built on top of Material UI.
• Backup job to ensure data safety, allowing the client to modify data directly in Firebase.

Future Enhancements

The app has been successfully deployed to the client’s customers and is regularly updated. Recent updates include:

• User registration system with email workflows.
• A role-based system for different levels of access.

Conclusion

This project transformed complex Excel calculations into an intuitive mobile app, making it easier for customers to get accurate machine configurations. Leveraging Flutter and Firebase, the app offers a seamless experience and continues to evolve with new features based on client feedback.