Why Excel reaches its limits for asset management
A property manager opens the spreadsheet used to track the building's HVAC equipment. Twelve tabs. Colour codes that no longer mean anything. A "remaining service life" column nobody has updated in two years.
He is looking for a simple answer: which piece of equipment should be replaced first next year?
The answer is in that file somewhere. But it takes twenty minutes to dig out, and nobody is sure the numbers are still accurate.
There is nothing unusual about this situation. Excel has long been the default tool for tracking a building's assets. The problem isn't Excel itself. The problem is what we now ask it to do.
Why this deserves your attention
Asset management rests on one simple thing: reliable data, easy to consult, that lets you compare scenarios.
When that foundation becomes fragile, every investment decision gets riskier. Equipment isn't replaced at the right time. A failure that could have been anticipated comes as a surprise. A budget gets approved on the strength of an estimate that was never validated.
For a single-building portfolio, these cracks remain manageable. Across ten, twenty or fifty buildings, they become a genuine drag on sound asset management.
What actually happens with a spreadsheet
An asset management spreadsheet always starts out simple. A list of equipment, a few columns, an installation date.
Then the needs grow. Tabs get added for each building. Formulas get added to calculate life cycle cost. Links between files get added to centralize data from several properties.
Over time, three problems almost always emerge:
Dependence on a single person. Often, only one person truly understands how the file works: where the formulas live, why a given tab exists, how everything fits together. If that person leaves the organization or changes roles, the knowledge leaves with them.
Errors that go unnoticed. A cell changed by mistake. A formula copied into the wrong place. A number entered by hand that no longer matches reality in the field. In a complex spreadsheet, these errors are hard to detect, and they pile up silently.
No consistent method. Everyone who touches the file uses it their own way. Prioritization criteria shift from one building to the next. Two managers can reach different conclusions from the same data, simply because the method isn't standardized.
The impact on the building and on decisions
These limits don't stay theoretical. They translate into decisions that are slower, harder to compare, and sometimes harder to justify.
A capital budget built on an incomplete spreadsheet can understate certain risks. A critical piece of equipment can end up at the same priority level as a secondary one, simply because the information wasn't structured to tell them apart.
And when the time comes to present a recommendation to senior management or a board, a spreadsheet that's hard to interpret doesn't help make the case. It adds a translation step between the raw data and the decision to be made.
Common mistakes to avoid
Many organizations repeat the same mistakes when trying to evolve their spreadsheet-based management:
- Adding ever more tabs instead of rethinking the data structure.
- Handing updates to several people without clear rules, which multiplies inconsistencies.
- Never revalidating the formulas after years of use, even though the needs have changed.
- Waiting for a major incident (a lost file, a calculation error discovered too late) before questioning the tool.
The possible approaches
There are several ways to tackle this problem, depending on portfolio size and available resources.
Stay with Excel, but better structured. For a small portfolio, a well-designed spreadsheet, documented and maintained with a clear method, can still be enough. It takes discipline and a data structure thought through from the start.
Centralize the data in a dedicated tool. For a larger portfolio, a platform built specifically for asset management makes it possible to standardize the analyses, reduce dependence on a single person, and keep a reliable record of the decisions made.
A gradual transition. Some organizations choose to migrate one building or one data pillar at a time, rather than changing everything at once. This approach reduces the risk of losing data during the transition.
Strengths and limits of each approach
A well-kept spreadsheet remains inexpensive and flexible. But it demands constant rigour, and that rigour tends to erode with staff turnover or portfolio growth.
A dedicated platform requires an initial investment and an adjustment period. In return, it offers a consistent method, better traceability, and the ability to compare several scenarios without rebuilding the analysis every time.
Neither approach is universally better. The right choice depends on the size of the portfolio, the number of people involved, and the level of risk the organization is willing to tolerate.
A concrete example
A manager responsible for a portfolio of fifteen commercial buildings tracked his HVAC equipment in a spreadsheet shared among three people. Each had their own way of recording equipment condition: some used a 1-to-5 scale, others free-text comments.
When the time came to present a five-year investment plan, it took nearly two months to harmonize the data before it could even be analyzed. The portfolio already contained the necessary information. The problem wasn't a lack of data, but the absence of a common method to structure it.
How a platform like OPTIMA can help
In this kind of situation, a decision-support platform like OPTIMA can bring a common structure: the same criteria and the same analysis method, applied across an entire portfolio. The goal is not to replace the manager's judgment, but to give it a reliable basis for comparison across several buildings and several scenarios, without depending on a spreadsheet maintained by a single person.
Conclusion
Excel isn't a bad tool. It simply becomes insufficient beyond a certain level of complexity, especially when asset management spans several buildings, several people, and significant investment decisions.
Recognizing that moment is already a useful step. The question isn't whether Excel is good or bad, but whether your current method still lets you make decisions based on reliable data.
Takeaways
- A well-designed spreadsheet can be enough for a small portfolio, but grows fragile as the portfolio grows.
- Dependence on a single person is one of the biggest risks of an asset management spreadsheet.
- The lack of a consistent method makes comparisons between buildings unreliable.
- Migrating to a centralized tool isn't mandatory for everyone, but becomes worthwhile beyond a certain volume of assets.
- The goal never changes: reliable data to support better decisions.
FAQ
1. At how many buildings does Excel become limiting? There is no universal threshold. It depends mostly on the number of people involved and the complexity of the analyses you need, more than on the number of buildings itself.
2. Can a spreadsheet stay reliable over the long term? Yes, provided it is documented, structured from the start, and maintained with a clear, consistent method.
3. What is the main risk of an asset management spreadsheet? Depending on a single person to understand it and keep it up to date.
4. Does a dedicated platform eliminate human judgment? No. It standardizes the analysis, but the final decision always remains in the manager's hands.
5. How long does a transition to a centralized tool take? It varies with the volume and quality of the existing data, but a gradual, building-by-building transition generally reduces the risks.
6. Do all buildings have to be migrated at once? No. Many organizations prefer a gradual transition, starting with the most critical buildings.
7. How do I know whether my current spreadsheet is reliable? A good indicator: does only one person in the organization truly understand how it works? If so, that's a signal to take seriously.
8. Are spreadsheet errors common? They are hard to quantify precisely, but they often accumulate invisibly, especially in files edited by several people over several years.
9. Does a small portfolio really need a dedicated platform? Not necessarily. For one or two buildings, a well-structured spreadsheet can remain sufficient.
10. What is the first step toward better data management? Take an honest inventory of how reliable your data currently is, before even thinking about changing tools.
This article makes a qualitative argument grounded in general asset management practice. References: the ISO 55000 series of asset management standards; ASHRAE publications on HVAC equipment life cycles; Natural Resources Canada guides on energy management in commercial buildings.