Energy management software for building portfolios

Most software in this category was built for a single building with a controls system and an engineer to watch it. Running eight buildings, or eighty, is a different problem. The meters are on different utilities, the bills arrive in different formats on different days, half the accounts are in a property manager's name and the other half are in the owner's, and nobody has an hour a week to keep a dashboard current. The question is not which tool has the most charts. It is which arrangement produces a number you can act on every month without adding a full-time job.

The United States Department of Energy describes energy management information systems as a broad and rapidly evolving family of software tools that monitor, analyze and control building energy use and system performance. Its framework splits a deployment into capabilities, scope and stack, and then adds a fourth element: operations, meaning the people, organizational processes and actions needed to use the system successfully. That fourth element is the one portfolios usually get wrong.

What the software has to cover

Strip away the feature lists and a portfolio tool has five jobs. Each one fails in a specific way when it is missing.

• Capture: every bill and every meter feed, every month, without somebody forwarding PDFs. Missing months are the most common defect in portfolio data.
• Validate: check what arrived before it is reported. A duplicate bill, an estimated read or a credit posted to the wrong month will quietly move an intensity.
• Normalize: put consumption on one calendar, in consistent units, with weather and floor area handled the same way for every building.
• Benchmark: compare buildings to each other and to their own history in terms that survive a challenge.
• Report: produce something short enough that a board or an asset manager reads it, and specific enough that someone can act on it.

Capture and validation are unglamorous and they decide everything downstream. We wrote separately about what it takes to get bill PDFs and Green Button meter data into one structured store, and about the checks a bill passes before it is benchmarked.

Where the data comes from

There are two practical routes into a portfolio, and most portfolios need both. The first is the bill itself: a PDF or a portal export, read and turned into structured line items. The second is the meter: interval data delivered under Green Button Connect My Data where the utility offers it, which sends consumption directly once the account holder authorizes it.

Bills tell you what you were charged. Interval data tells you what the building did. A portfolio running on bills alone can benchmark and report, but it cannot see that a site started running its air handlers at 4 a.m. or that a weekend setback stopped working. A portfolio running on interval data alone knows the load shape and cannot check the invoice. The combination is what makes both the cost and the operational questions answerable, which is why heat maps of interval data sit next to the bill review in a monthly report.

Why validation matters before reporting

Reporting on unvalidated data produces confident wrong answers. The usual failures are mundane: a bill covering 34 days compared against one covering 29, an estimated read followed by a true-up that lands in the wrong month, a tax line included in one building's cost intensity and excluded from another's, a meter multiplier applied twice.

None of these are exotic, and all of them change a number that someone will present. If a board is told consumption rose 9 percent, the first question is whether that is the building or the data. A validation step that runs before benchmarking is what lets you answer it in one sentence instead of three days.

Benchmarking across a portfolio

Benchmarking answers two different questions and it is worth keeping them apart. Against itself: is this building using more than it did last year, once weather and calendar are accounted for. Against its peers: is this building reasonable for its type and size at all.

The peer comparison has an established public basis. ENERGY STAR Portfolio Manager expresses energy use intensity as energy per square foot per year, and its 1 to 100 score compares a building against similar buildings nationally, where 50 is median performance. For Canadian buildings the peer group comes from the Survey on Commercial and Institutional Energy Use, commissioned by Natural Resources Canada and implemented by Statistics Canada, rather than the United States survey. Our guide to Portfolio Manager for Canadian buildings covers what that means in practice.

Cost intensity needs the same discipline as energy intensity and is easier to get wrong, because prices move independently of consumption. We set out how to build a defensible cost per square foot figure separately.

Software alone, or software plus a person

This is the real decision, and the Department of Energy framework names it: operations, the people and processes around the tools. Software will capture, validate, normalize, benchmark and produce a report. It will not notice that the number it produced is strange, chase the utility for the missing month, or decide which of eleven flagged items is worth someone's Tuesday.

Three arrangements are common. Buy a platform and run it in house, which works when there is an energy manager whose job includes it. Hire a consultant for a periodic study, which produces a good document and no monthly rhythm. Or take the review as a service, where the capture, validation and benchmarking run every month and what arrives is a short list of what changed and who should look at it. That last arrangement is what VE-MAP is, and the comparison between an audit and an ongoing review is covered in energy audit versus ongoing monitoring.

The platform framing of this same problem, from the data pipeline side, is set out in the MartinAI article on what an energy management information system is. VE-MAP is the managed portfolio review built on that work.

What to ask a provider

1. Which utilities can you capture automatically today, and what happens with the ones you cannot?
2. What validation runs before a number reaches a report, and what does the exception list look like?
3. How is a 34 day billing period compared against a 29 day one?
4. Who fixes a missing month, us or you?
5. What exactly arrives each month, and how long does it take to read?
6. Does the annual benchmark keep Portfolio Manager in sync, or is that a separate exercise?
7. What does it cost per site and per meter, and what is the setup?

FAQ

Do we need software if we only have six buildings?

Six buildings is roughly where a spreadsheet stops being honest. The arithmetic is still possible by hand; the discipline is not. What usually breaks first is not the calculation but the monthly cadence, because the person doing it has another job. The virtual energy manager article describes the same choice from the staffing side.

We already have a building automation system. Is that not the same thing?

No. A building automation system controls equipment in one building and knows nothing about the invoice. Energy management software works from utility and meter data across many buildings and answers cost, consumption and reporting questions. They are complementary, and the Department of Energy framework treats controls and analytics as different capabilities.

Can we start with bills and add meter data later?

Yes, and most portfolios do. Twelve to 24 months of complete billed consumption per meter supports benchmarking and reporting. Interval data is added where the utility supports it and improves the operational half of the review. Either way the portfolio view has to reconcile both onto the same calendar.

How long before it is useful?

The first monthly review is useful immediately as a data check: it usually finds missing accounts and estimated reads nobody knew about. Trend and weather-normalized comparison need a baseline, so the second and third months are where it starts answering the questions a board asks. Request a review with your building count and we will show the format.