Home

Energy Lens

Energy management made easy

Energy Monitoring Charts and Tables Created by Energy Lens

Using Energy Lens, you can instantly create a variety of charts and tables from interval energy data of your choosing. All charts and tables are created directly in Excel, meaning that they are easy to edit, or copy and paste into reports or presentations.

Although these charts and tables can be used for many kinds of energy analysis, they are particularly useful for the energy monitoring and targeting practiced by energy consultants and energy managers or facility managers.

You can very easily create the following charts and tables for yourself: just download Energy Lens and give it a go.

Calendar charts for an overview of energy consumption patterns

The "Calendar" feature is great for getting a quick view of the patterns of energy consumption. It plots an entire month of profiles on a single sheet:

A calendar chart with optional overlayed profiles

Overlayed profiles

Each of the mini-charts shown above have maximum, average, and minimum profiles overlayed on top. You can leave these out of your calendar charts if you like, but, if you configure these overlayed profiles appropriately, you might find them useful for things like:

Using calendar charts to find energy waste

Calendar charts make it easy to spot the times when it's likely that energy is being wasted:

Use a calendar chart to quickly identify wasted energy

If you're new to energy-data analysis and you're not sure what to look for, you might like to set aside some time to go through our article on finding energy waste.

Anyway, once you've identified possible sources of waste, you can use the other features of Energy Lens to investigate further, quantify the waste, and set targets to ensure that it doesn't happen again.

Back to top

Free Trial of Energy Lens

Single-day profiles – detailed charts of energy usage

The "Single Day" feature allows you to view an individual date in more detail:

A single day profile with overlayed comparison data

Just like with the "Calendar" charts, you can easily leave out the average, maximum, and minimum overlayed comparison data if you want your single-day charts to be as simple as possible.

More detailed data gives more detailed profiles

The chart above was generated from half-hourly data. If you have more detailed data, you'll get more detailed profiles, such as this profile of 15-minute data with optional overlays included. Energy Lens works with 5-minute, 10-minute, 15-minute, 20-minute, 30-minute (half-hourly), and 60-minute (hourly) interval data.

Using "Date Finder" to identify dates of interest

The "Single Day" feature has a "Date Finder" to help you identify dates of interest such as:

Back to top

Average, maximum & minimum charts and tables

The "Av Max Min" feature helps you to make a bar-chart of the average, maximum, and minimum interval values between selected dates. Amongst other things, this can be useful for comparing the average, worst, and best energy performance of a building.

Average, maximum, and minimum data for Tuesdays, Wednesdays, and Thursdays only

The profile above is based on 15-minute interval data from a manufacturing business. Each week, the business runs continuously from mid-morning on Monday to mid-afternoon on Friday, so, to give a good representation of the days with 24-hour operation, this av-max-min profile is based on data from Tuesdays, Wednesdays, and Thursdays only.

The data in this chart specifically excludes the energy consumption on holiday days when the business was closed. In particular this prevents the average and minimum values from being affected by the low energy consumption on holiday days.

Energy Lens makes it very easy to focus on the specific dates that you choose – this is particularly important for meaningful average, maximum, and minimum profiles. Please feel free to download Energy Lens and try out its advanced date-selection features.

As a table of figures

You can also make a table showing the average, maximum, and minimum interval values between selected dates, and the specific dates on which the maximum and minimum values occurred:

The first few rows of a table of average, maximum, and minimum data

Average, maximum and minimum tables such as these are useful for identifying dates on which consumption was at a maximum or minimum at particular times of the day.

Back to top

Download a Free Trial

Daily bar-charts and tables

The "Daily" feature helps you to make charts and tables of day-by-day demand (kW average power) or total energy consumption (kWh):

A chart of daily total kWh between selected times

Choosing the times

You can easily choose to focus on particular times-of-the-day (e.g. to look at a particular tariff cost-band). For example, the above chart looks at energy consumption between 09:00 and 17:00 only, as these are the core occupancy hours of the building that the interval data came from.

Looking at longer periods of energy consumption

The "Daily" feature can be very useful for getting a quick, fairly detailed snapshot of energy consumption over a longer period of time. For example, the chart below shows 8 months worth of data:

8 months of daily kW in midnight-to-seven period

This is great for pinpointing days when energy consumption was uncommonly high or low between your chosen times (you can use midnight to midnight if you want to look at complete days).

Including maximum and minimum kW

You might have noticed that the chart above includes daily maximum and minimum kW alongside the average values. A number of the features of Energy Lens give you the option of including these maximum and minimum kW in your charts and tables. This extra data can help you to get an idea of how the energy consumption varied within each day, and it is useful if you're looking for periods with an unusually high maximum demand (peak load).

Back to top

Weekly and monthly charts and tables for larger energy-consumption trends

The "Weekly" and "Monthly" features make it easy to compare energy performance on a week-to-week or a month-to-month basis.

The sophistication of the "Weekly" and "Monthly" features is in the calculation of their figures. When tracking energy performance, it's very important that you follow some rules to ensure that the results are meaningful – the "Weekly" and "Monthly" features of Energy Lens make it easy to do this.

Although you can use the "Weekly" and "Monthly" features to look at overall changes, it's usually better to focus in on specific days-of-the-week and times-of-the-day. For example:

Tracking changes in energy performance by focusing in on specific days and times is an incredibly effective energy-monitoring technique.

However, it is very time consuming to do without specialist software like Energy Lens.

The following chart is an example of how Energy Lens can help you to focus in on specific days and times – it looks at the average power on Tuesday evenings only:

Weekly average kW on Tuesday evenings

Tuesday evenings are just an example – they might, for instance, be when the cleaners come in. Energy Lens makes it easy to focus in on any days and times, so you can choose the days and times that are relevant to your operations.

Comparing weekly or monthly maximum and minimum kW

Like the "Daily" feature, both the "Weekly" and "Monthly" features give you the option of looking at maximum and minimum power demand. For example, the chart below shows month-on-month variations in maximum, average, and minimum kW:

Monthly weekend maximum, average, and minimum kW

As tables of figures

The "Weekly" and "Monthly" features can also output Excel tables. Like the chart above, the table below was created to investigate month-to-month variations in weekend energy performance.

A table of figures for tracking monthly changes in weekend energy performance

A table such as this provides a great starting point for your own calculations.

Back to top

Make Your Own Charts and Tables

Summary tables

The "Summary" feature helps you to calculate figures such as totals, averages, maximums, and minimums, for the dates and times that you specify. For example, the summary table below has figures that were calculated for core occupancy hours only (09:00 to 17:00, Monday to Friday, excluding bank holidays):

A summary for 9 to 5, Monday to Friday

Like the other tables that Energy Lens makes, one of the best things about summary tables is that you can use them as a starting point for your own calculations. All the tables that Energy Lens makes are just regular Excel tables, so you can easily chop and change them or extend them as you please. This alone makes Energy Lens quite different to most energy management software!

Back to top

What next?

© 2006–2024 BizEE Software – Contact Us | About Us | Privacy Policy