Challenge
The client reached us with a comprehensive real estate project – the development of 4 powerful property development feasibility software. The applications were aimed to have a different level of calculation complexity to serve various requirements of real estate developers and investors.
Initially, the client stored all their data in Google Sheets along with complex calculations and formulas. This made it challenging for real estate professionals to work with. Therefore, the client requested us to develop 4 robust applications to empower real estate developers, investors, landowners & property agents with bespoke functionality for making informed decisions about property ventures. Its most challenging part was to transform the Google Sheets’ calculations and formulas into code. On the design side, we had to visualize a vast volume of intricate data into user-friendly and visually appealing tables.
Solution
We approached ecosystem development by thoroughly analyzing the existing data in Google Sheets, its calculations, and formulas. By utilizing Next.js for all the applications, we built a property investment and development feasibility suite that consists of 4 SAAS products, considering different user personas and their specific needs.
Namely, One Minute Feaso for early-stage property evaluation and checking basic project viability on the go, Smart Feasibility Calculator for comparing different project options and understanding realistic potential, Lead Developer Plus for detailed project planning and in-depth analysis, and Smart REIA to analyze and compare up to 5 different residential or commercial investment opportunities to make informed decisions.
On the technical side, we transformed all the Google Sheets’ data, calculations, and formulas into code to enable users with robust functionality when getting reports in seconds. After the development of the calculations, we employed a test-driven approach to ensure their accuracy and reliability in various scenarios and edge cases while identifying potential errors. We migrated 1800 Excel formulas into typescript code. The number of calculations varies depending on the application complexity, with One Minute Feaso containing 300, Smart Feasibility Calculator having 8000, Lead Developer Plus including 200, and Smart REIA containing 300. With these intricate calculations, real estate developers and property investors can develop a comprehensive investment plan for up to 100 years.
What about the design side, the team visualized the comprehensive data tables in a straightforward and appealing way according to the UI/UX rules, making them intuitive and easy to navigate, ensuring seamless platform interaction.
Digital Ecosystem Architecture
We utilized Typescript for the project as one of the most popular languages for enterprise applications. To ensure smooth web application development and seamless rendering, we utilized the powerful Next.js, a full-stack framework with the power of React components. For the database, we utilized MySQL, while AWS served as our primary cloud infrastructure. In our development process, we used BitBucket to maintain and delegate the development process between team members, involved PM2 for continued delivery on the EC2 instance, and relied on Nginx as our reverse proxy.