Verdict

“The existing Excel tool's complexity can be mitigated by leveraging Power BI's data modeling and interactive features to simplify the replication of its functionality.”

The idea is feasible for a solo or 2-person team to build in 4-12 weeks. The existing Excel-based tool is complex, with multiple tabs and macros, but its functionality can be broken down into manageable components. The proposed web-based solution using Sharepoint and Power BI is a viable option, as it can handle large volumes of data and provide a user-friendly interface. The main challenge lies in replicating the existing macros and data processing logic in the new platform. However, Power BI's data modeling and DAX formulas can likely replace the XLOOKUP columns and some macros. The 'stepping' through unique PO#s and filtering functionality can be achieved using Power BI's interactive features. The email generation feature may require some custom development, but it's a relatively contained task. Overall, the technical complexity is moderate, and the timeframe is realistic.

“A tailored, web - based procurement tracker that integrates with the company's ERP and automates the current macro - heavy Excel process offers the most defensible differentiation, provided it can be built and maintained cost - effectively.”

The market already offers multiple solutions that address parts of this need: legacy Excel workbooks (the current tool), Microsoft Power Apps/Airtable/Smartsheet for low - code app creation, and full - featured procurement suites such as Coupa, SAP Ariba, or Oracle Procurement Cloud. These alternatives provide scalability, collaboration, audit trails, and integration with ERP systems, which the Excel - macro solution lacks. However, the user's specific workflow - combining order - level and line - item data, extensive XLOOKUP logic, custom receiving tracking, and vendor - email generation - does not map cleanly onto any off - the - shelf product, creating a niche where a purpose - built web app could add real value. The differentiation is therefore real in that it targets a precise, manually - crafted process that existing tools either over - engineer or under - support. Durability hinges on the entrant's ability to deliver a maintainable, secure, and user - friendly platform, secure buy - in from the organization, and continuously evolve the product; otherwise the advantage could erode as the user's needs change or as the company adopts a more robust ERP module. The key risk is the high upfront development effort versus the low cost of maintaining the existing Excel file, which may limit the viability of a sustainable business model.

“Lack of company support exacerbates regulatory, financial, and technical hurdles, making solo development of a viable, paid platform highly improbable within 6-12 months.”

The proposed venture to recreate the Excel-based tool using Sharepoint and Power BI (or alternative platforms) as a standalone business venture is highly unlikely to succeed within 6-12 months due to the following specific failure modes: 1. **Regulation & Compliance Risk (8/10)**: Without company backing, ensuring GDPR, CCPA, and industry-specific data handling regulations for potentially sensitive logistics and vendor data becomes a solo burden, risking legal repercussions. 2. **No-Budget Customer Base (9/10)**: The target market (individuals in purchasing roles without company support) likely lacks the budget for a new, potentially costly platform, especially if they're accustomed to free (Excel) solutions. 3. **Platform Risk - Dependency & Learning Curve (7/10)**: Transitioning to a new platform (e.g., Sharepoint, Power BI, or alternatives) introduces significant dependency risks (platform changes, costs) and a steep learning curve for the solo developer (you), potentially leading to a non-viable product within the timeline.

“The real product isn't the software - it's the automation of the tedious, error-prone procurement rituals that thousands of professionals perform daily with Excel, and they'll pay to stop doing it.”

This is a high-potential business idea because it targets a widespread, unmet need among mid-to-large enterprise employees who rely on brittle, homegrown Excel tools to manage critical operational workflows. You are not alone - thousands of procurement, logistics, and supply chain professionals use similarly complex Excel workbooks with macros, often without IT support. These users are frustrated, time-constrained, and desperate for scalable, reliable alternatives. The market isn't just 'people who use Excel'; it's specifically procurement analysts, logistics coordinators, and supply chain specialists in companies too large for simple SaaS tools but too under-resourced to justify enterprise ERP customization. Your tool solves a real pain point: automating manual reconciliation, reducing errors in PO/receiving matching, and streamlining vendor communication. A web-based solution built on Power Platform (Power Apps + Power BI + SharePoint) or even a lightweight Python/Streamlit app with a SQL backend could be packaged as a low-code SaaS product for this niche. The audience is sizable: Gartner estimates over 10M procurement professionals globally, and even 0.1% adoption (10,000 users) at $20/month = $2.4M ARR. You already have the domain expertise and prototype - this is a classic 'build it for yourself, sell it to others' opportunity. The key is packaging it as a turnkey solution with templates, training, and support - not just software. Competitors like Airtable or Zapier are too generic; your vertical-specific automation is the differentiator.

“Your tool solves a real pain point - productizing it for other purchasing teams could capture significant value.”

Your Excel-based tool demonstrates a clear, high-value use case with tangible efficiency gains (automated data processing, vendor communications, and PO tracking). The complexity (20+ tabs, 30+ macros) signals a need for scalability, but the core logic is already validated by your daily use. Transitioning to a web-based tool (e.g., Power Apps + Power BI or a lightweight SaaS like Airtable with scripting) could unlock multi-user access, real-time updates, and better data handling - critical for enterprise purchasing. However, the revenue model is unclear: if this is for internal use only, monetization is zero. If you productize it (e.g., sell as a niche SaaS for purchasing teams), pricing could be $50 - $200/user/month (tiered by features/data volume), with gross margins >80% (hosting + support costs are low). The conversion path would involve piloting with other purchasing teams, proving ROI (time saved, error reduction), and scaling via industry networks. Unit economics are strong if you automate onboarding (e.g., templates, tutorials).