An ordering spreadsheet nobody could maintain was rebuilt as a tested application that matches the original method and does more.
What we built it with: Python · Power Apps · Dataverse
A large multi-brand automotive dealer group decided what vehicles to order using a spreadsheet that the business trusted but nobody could maintain or extend.
The replacement had to give the same answers as the method the business already relied on, and we had to be able to prove it.
The spreadsheet's logic was rebuilt as tested software.
Managers see an order recommendation with the sales history behind it.
The app does more than the spreadsheet could, and supports multiple stores.
The recommendation is a starting point. The person placing the order makes the final call.
The new application's results matched the original method exactly.
The group now has an ordering tool that can be maintained and extended, and that no longer depends on one spreadsheet.
Free 30-minute call. No sales pitch. We'll tell you honestly what we would do and whether we are the right fit.
