From reviewing auctions one by one to having them all filtered and scored
Automated extraction of the public auctions that match their filters, loaded into their Excel with the profitability formulas and stages to track each property.
Property investor · Portugal
BEFORE
Hours a day to review a handful of properties
AFTER
Every property that matches their filters, in one step
The problem: hours a day to review a handful of properties
Auctions are published on a public government website. To find out whether a property was worth it, the client opened each listing's detail page, one by one, and copied its data by hand into an Excel file where they then ran the profitability numbers and filtered by city and other features.
That work ate up hours every day and still only covered a handful of properties. The investment criteria already existed and were sound: what failed was the time it took to apply them.
A phased project, to validate before growing
The project was quoted and split into phases. We laid out several options, each with what it delivered and the risks it carried, and the phases were defined together with the client, so they felt comfortable from the first minute and got something of value in a very short time.
The idea was to prove first that automation solved the problem and, with that validated, decide whether to evolve the product.
The first phase is not a full application, and was never meant to be. Even so, from day one it drastically cut the time the client spent reviewing auctions.
What we built in the first phase
Extraction with their filters. The system works through the public website and pulls only the properties that match the features the client asks for, such as the city, without opening a single listing by hand.
Loaded into Excel, without duplicates. The data is downloaded and added to their Excel file: properties that already existed are updated and new ones are added.
The profitability formulas, applied to every property. The spreadsheet works out whether each property is profitable using the same criteria the client already used.
Stages to track each property. Every property can be moved through different stages, so the spreadsheet stops being a list and becomes the tracker for each deal.
Why the first phase lives in Excel
The client already worked in Excel: that is where their numbers and their way of comparing deals lived. Bringing the automation into that same file meant it could be used from day one, without learning a new tool, and the project's value could be validated with the smallest possible investment.
With phase one working, the next step has a real foundation to build on.
The result
What used to take hours a day and only reached a handful of properties is now done in one step, and covers every property that matches their filters.
The real effect is not only speed, it is coverage. Once reviewing a property stops costing time, every property gets reviewed, not just the ones there was time to look at.
The first phase is delivered and the client uses it every day.
What v1 covered
This is the first phase, and its scope was deliberate: extraction, Excel and formulas, with no application of its own. The next phase replaces the spreadsheet with a web application that can be used from anywhere, with new modules on the same foundation.
Services involved
Shall we build something that scales, together?
Tell us about your project. We'll get back to you with a concrete plan and a senior team — not a generic quote.