Modernizing a Legacy Excel Tool into a Scalable Web Application

Outcome at a glance: A spreadsheet-driven estimating tool was costing a global aerospace and defense engine manufacturer rework, version conflicts, and five-day approval cycles. i3solutions rebuilt the estimating tool as a web application on the Microsoft stack: ASP.NET MVC with Razor, Entity Framework, SQL Server, jQuery, and Power BI. The rebuild reduced rework by 30% and saves approximately $250k annually in rework-related labor, and approval cycles that took up to five days now complete in one. Engineers save an average of 8 hours per month each, over $1.1 million in annual productivity gains across the organization.

The client is a global aerospace and defense engine manufacturer that designs, produces, and services aircraft engines for both commercial and military applications. The tool behind much of its cost estimating had not kept pace with that engineering: an outdated internal estimating tool that relied on cumbersome Excel spreadsheets.

As the data volume and complexity continued to grow, the limitations of this tool became frustrating for their teams. Teams struggled with version control, inconsistent calculations, and limited visibility into the latest data, resulting in delays, errors, and rework across departments. They recognized the urgent need to transform this outdated system into a modern, web-based solution.

To address these challenges, the company partnered with i3solutions, a trusted Excel to web application development firm, to modernize and streamline their internal estimating tool. Our team led the transformation of their estimating tool, migrating it from a complex, spreadsheet-driven Excel application into a scalable, web-based solution. Rather than digitize the existing workbook as-is, the team rebuilt the process as a platform designed to improve collaboration, eliminate manual inefficiencies, and scale with evolving business needs.

Our engagement began with a strategic discovery phase, consistent with our approach to delivering tailored Excel workflow modernization solutions. We conducted in-depth stakeholder interviews and an assessment of the tool’s underlying logic, workflows, and pain points. This allowed us to design a roadmap tailored to the company’s specific requirements to preserve the calculation logic of their existing models while positioning the new system for long-term agility and growth.

As part of our Excel to web development services, we engineered a custom solution using the Microsoft technology stack. The resulting web application offers secure access from any internet-enabled device and features real-time updates, centralized data handling, and integration with other enterprise tools. The application replaced Excel with a web application that simplifies operations and improves the user experience. A thoughtfully designed interface, intuitive dashboards, and flexible configuration options let users complete tasks with greater accuracy and speed.

By replacing Excel with the web application, the company eliminated the limitations that once hindered performance and decision-making. Updates to the tool can be rolled out quickly, without the need for downloads or version tracking. Changes are rolled out centrally, so the platform evolves with business priorities. With their new web-enabled tool, the company now benefits from a flexible, centralized solution that runs the estimating process from one centralized tool instead of competing spreadsheet copies.

i3solutions harnessed a set of cutting-edge technologies
to deliver the web-enabled estimating tool:

How much time and money did the Excel to web modernization save?

The web-enabled estimating tool reduced rework by 30% and saves approximately $250k annually in rework-related labor. Engineers each save an average of 8 hours per month, over $1.1 million in annual productivity gains across the organization, and approval cycles that once took up to five days now take just one.

What technology stack replaced the Excel spreadsheets?

The application is built on the Microsoft stack: ASP.NET with a Razor MVC structure, Entity Framework for data access, SQL Server as the database, jQuery for the interface, and Power BI for interactive dashboards and cross-proposal reporting.

Is the web application harder to maintain than the old spreadsheet?

No. Updates roll out centrally without downloads or version tracking, so the platform evolves with business priorities instead of accumulating conflicting spreadsheet copies.

How did i3solutions run the project?

The engagement began with a discovery phase: stakeholder interviews and an assessment of the tool’s underlying logic, workflows, and pain points. Delivery then followed an Agile process with short iterations and direct collaboration against the company’s requirements.