Verdict

“A native, free - tier Excel VBA solution that instantly computes distance and time from addresses could carve a niche, but its durability hinges on managing API costs and the declining relevance of VBA.”

The core need - quickly calculating line - haul mileage and time from two addresses to decide whether a run meets a per - mile profitability threshold - is already served by several existing tools: Google Maps Distance Matrix API (via paid add - ins), proprietary Excel distance calculators, and specialized freight - routing platforms such as Route4Me or Circuit. These solutions are either costly, closed - source, or require manual API calls and separate windows, which matches the user's pain points. A native Excel workbook that embeds a VBA (or Office Scripts) routine to call a free - tier mapping API, automatically pulls distance and duration, and presents the result in - sheet would indeed differentiate itself by being free, fully customizable, and eliminating external windows. However, durability is uncertain: Google's API pricing, usage limits, and potential policy changes could make the solution expensive or break it; VBA is also being phased out in favor of Office Scripts/TypeScript in the Microsoft 365 ecosystem, reducing long - term viability. Competitors could easily adopt similar native - Excel approaches or offer better free tiers, eroding the advantage. Thus, while the idea has a clear niche and a plausible differentiation, the defensibility is modest and depends heavily on the entrant's ability to keep the API costs low and stay ahead of platform changes.

“The project is feasible for a solo developer with some VBA and API programming knowledge, and the main challenge lies in learning and implementing the specific technical requirements.”

The idea is to build a custom Excel workbook that uses the Google Route API to calculate distances and times between addresses. The user wants to input start and end addresses in two columns and have the workbook automatically calculate the miles and time without requiring manual intervention. The technical requirements involve using Power Query to fetch data from the Google Route API, creating a VBA loop function to process the data, and linking it to a macro. While the user is a self-described 'noob', the task is achievable with some learning and experimentation. The main challenges are understanding how to alter the API programming, creating a VBA loop function, and linking it to a macro. However, these are specific, well-defined problems that can be solved with the right resources and guidance. The user has already identified some of the necessary tools and techniques, such as using Claude for API programming and exploring VBA loop functions. With focused learning and practice, a solo developer can build this in 4-12 weeks.

“A customizable, API-driven Excel tool for per-mile profitability in trucking can command premium pricing in a niche with high willingness-to-pay.”

The idea has clear utility for owner-operators or small fleets in trucking/line haul, where per-mile profitability is critical. The revenue model could be a one-time purchase (e.g., $150 - $300) or a subscription ($20 - $50/month) for a customizable Excel workbook with native Google Maps API integration, automated mileage/time calculations, and user-defined profitability thresholds. Unit economics are strong: near-zero marginal cost per user after development, with high gross margins (80%+). The key differentiator is customizability - competing tools are rigid or require external queries. However, the market is niche, and scalability depends on targeting the right channels (e.g., trucking forums, freight broker platforms). The main risk is execution: building a seamless VBA loop and API integration that feels native to Excel. If solved, this could capture value from a segment willing to pay for flexibility over off-the-shelf solutions.

“The project lacks a viable business model, relying heavily on personal technical development with no clear path to scalability or monetization.”

The idea's viability is severely limited by its narrow, personal scope, lack of scalability, and dependency on a single individual's learning curve without a clear path to monetization or broader appeal. The primary goal is to create a customized, proprietary tool for personal use, which doesn't translate to a viable business venture. Regulatory risks are low due to the non-public nature of the tool, but platform risk is high due to dependence on Google's Route API, which could change terms or pricing. Churn isn't applicable as there are no intended customers, and the 'no-budget customers' aspect is irrelevant since the project isn't designed for external use. The critical failure modes are: 1) **API Dependency & Cost**: Google increasing API costs or changing terms could make the project unsustainable. 2) **Lack of Scalability/Monetization Path**: No clear way to turn this personal project into a business. 3) **Dependence on Individual Learning Curve**: Project's success heavily relies on the founder's ability to overcome significant technical hurdles without a clear timeline or support system.

“Independent truckers will pay for a simple, self-contained Excel tool that automates route profitability calculations without requiring technical skills or recurring fees.”

There is a clear, unmet need among independent truckers, owner-operators, and small freight brokers who manually calculate route profitability and are frustrated by expensive, inflexible commercial tools. These users operate on thin margins and need real-time, customizable calculations for miles, time, and pay-per-mile thresholds - exactly what this idea solves. The target audience is sizable: over 3.5 million truck drivers in the U.S., with an estimated 500,000+ owner-operators who are tech-savvy enough to use Excel but unwilling to pay $100 - $150 for proprietary software they can't modify. The pain point is acute: a single inefficient route can cost hundreds in lost profit, making automation valuable. While VBA + Google Maps API is technically feasible, the barrier to entry is high for non-programmers, which creates an opportunity for a turnkey, pre-built Excel template with embedded automation. The idea isn't novel in concept, but its execution as a user-friendly, plug-and-play workbook with zero external dependencies (no Power Query pop-ups, no manual API calls) would differentiate it. The market is willing to pay - many already do for similar tools - and the product can be sold as a one-time $49 - $79 download on platforms like Etsy, Gumroad, or a simple website. The real value isn't the code; it's the time saved and margin protection it delivers. With proper documentation and a demo video, this could scale into a niche SaaS-like product with upsells (e.g., fuel cost integration, toll calculations).