Available Reports on DEXCell Energy Manager

Follow

DEXCell Energy Manager has some different comprehensive and detailed reports to show overall consumption
(e.g. including electricity, gas, water,.. ) and cost performance. 

The predefined reports are the following: 

  1. Basic Energy
  2. Cost and Energy
  3. HVAC Regression
  4. Measurement and Verification Projects summary
  5. Weekly Pro
  6. Water Bill simulation
  7. Electrical Bill simulation
  8. Exported electricity bill simulation
  9. Thermal bill simulation
  10. Gas bill simulation

 


DEXCell Energy Manager allows also to create custom report templates in an easy way:

  1. How to create a Custom Report template

 

 

1. Basic Energy

What is it for?

This basic energy report is very useful to have a quick view of your installation. It's is a weekly report, so every Monday you will be comparing last week consumption versus the previous one, receiving figures for both energy consumption and cost.
   

Available configurations

  • Automations: Weekly
  • By devices or groups
 

Requirements

  • Electrical, water or gas devices with data
  • Tariff assigned to each device

   

Report explanation

01_Weekly_Basic_Report.png

  1. Report title. Report gets its title from the report configuration wizard. 
  2. Date range for the report. This report is only available in a weekly automation, so each Monday you will get the report. Below, it appears the report device name where data is acquired.
  3. Customer and location basic information, such as surface, location name or customer name.
  4. This chart shows the current reported week versus the previous week, from Monday to Sunday, with hourly frequency.
  5. Consumption and cost summary tables for the reported week, by day of the week. Latest columns give the aggregates the consumption and cost for the whole week and compare it with the previous ones, showing also the difference.
  6. These charts show the last 28 days of energy consumption compared with the previous 28 days, in a daily frequency.
  7. Summary table for the current 28 days and previous 28 days, for energy consumption and cost, including differences. 

Note: For the reports using groups we have to make sure the 30 min frequency has been defined, essential for the calculation, and that the prices have been correctly assigned to that group. 

 

 

2. Cost and Energy

What is it for?

The Cost and Energy report makes a deep analysis for the most important factors in an energy efficiency project: Energy consumption and its cost. It's a double-sided report, analyzing the cost by tariff time bands, giving interesting ratios concerning average cost per kWh consumed, daily average cost, etc. 

On the second side of the report, a thermal consumption matrix is showed, for the average week, helping Energy Managers to identify major density energy consumption hours, and detect inefficiencies.  
   

Available configurations

  • Automations: Monthly or on-demand
  • By devices or groups

   

Requirements

  • Electrical, water or gas devices with data
  • Tariff assigned to each device
   

Report explanation - Side A

02_5b757655743f3.png

  1. Report title. Report gets its title from the report configuration wizard. 
  2. Date range for the report. This report is available on-demand or in a monthly automation, so each 1st day of the month you will get the report. Below, it appears the report device name where data is acquired.
  3. Customer and location basic information, such as surface, location name or customer name.
  4. This chart shows the cost for the report time range, day by day, disaggregating it by tariff time bands, if necessary.
  5. Ratios concerning energy and cost for the reported period. The average price per kWh is very useful to make further analysis or to fast quantify the ROI of energy efficiency projects.
  6. Summary table for cost chart, including price, consumption and cost for each tariff band period.
  7. These charts show the consumption for each day compared with the previous period of time, in a daily frequency.
  8. Energy and power figures, such as maximum demand, total consumed energy and Utilization factor. The Utilization factor, in hours, divides the total consumption by the maximum demand and explains de equivalent hours that you have been consuming at the maximum load.
  9. Summary table for energy consumption, focusing the analysis in the max and min hourly and daily consumed energy. In addition, the difference versus the previous period it's included. 

 

Report explanation - Side B

03_5b7576561558b.png

  1. Report title. Report gets its title from the report configuration wizard. 
  2. Date range for the report. This report is only available in a weekly automation, so each Monday you will get the report. Below, it appears the report device name where data is acquired.
  3. Customer and location basic information, such as surface, location name or customer name.
  4. Consumption distribution analysis, hour by hour. This analysis takes the average consumption for each hour of the week, from the weeks that take part in the report. A 24x7 matrix with the results is printed, adding global average column and row. On the right hand, a density chart is printed as an output from the average hourly matrix. This chart helps the Energy Manager to detect inefficiencies between days of the week and also to know in what time ranges our facility consumes more energy. 
  5. Consumption versus cost analysis. Two different pie charts are shown in this section, for the tariff time bands distribution, focusing on energy and cost.  

Note: For the reports using groups we have to make sure the 30 min frequency has been defined, essential for the calculation, and that the prices have been correctly assigned to that group. 

 

 

 

3. HVAC Regression

 

What is it for?

The HVAC regression report helps the Energy Manager and Maintenance staff to check the performance of the global HVAC system. For the selected time range, it calculates the regression between the external temperature and HVAC consumption, for both cooling and heating zones, according to the reference temperatures configured in the location, so users can detect outliers and inefficiencies.
The Potential savings matrix shows the % of consumption increase/decrease when changing your internal temperature in 1 ºC or more, giving an idea of how much energy you will save by changing the set-point in your particular HVAC system.
   

Available configurations

  • Automations: on-demand
  • By location (It takes the HVAC device if available, the Main device and the Outdoor temperature)

     

Requirements

  • HVAC / Main device configured in a location with data
  • Outdoor temperature device configured in a location with data
   

Report explanation

04_5b75765eab4f1.png

  1. Report title. Report gets its title from the report configuration wizard. 
  2. Date range for the report.
  3. Printed report date.
  4. Customer and location basic information, such as customer name and Location. Depending on available devices, consumption data will be taken from HVAC device or Main device, Temperature data will be taken from Outdoor temperature device.
  5. This part of the chart shows the regression between outdoor average daily temperature and consumption temperature, for the heating zone. Normally, the slope for this regression must be negative. At low temperatures, HVAC system consumes more energy. You must check outliers and variability in consumptions at the same outdoor temperature.
  6. This part of the chart shows the regression between outdoor average daily temperature and consumption temperature, for the cooling zone. Normally, the slope for this regression must be positive. At high temperatures, HVAC system consumes more energy. You must check outliers and variability in consumptions at the same outdoor temperature. 
  7. The matrix expresses how much energy you will consume/save by changing 1ºC or more your indoor temperature set-point. This is the real value for your facility. 
  8. Same as point 7 but for the cooling zone.
  9. This chart shows the ratio of evolution between consumed energy and average daily outdoor temperature.

 

 

4. MVP summary

What is it for?


This MVP energy report is very useful to track the development of your Measurement and Verification Projects. It is a weekly report, so it is automatically performed every Monday. In this kind of report, you can compare the evolution of the real consumption versus the baseline of your projects during the last week and the last month from the day that the report was made, and from the beginning to date.
 

Available configurations

 

  • Automation: weekly.
  • By locations.
 

Requirements

 
  • Electrical, water or gas devices with data.
  • Baseline created from the historical consumption before starting an energy efficiency project.
 

Report explanation - Side A. Summary of the ongoing MVP's

 12_5b75771bc3edd.png
1. Report title. The report gets its title from the report configuration wizard.
2. Report reference date. It indicates the last day from the week that the report is going to track.
3. Status for ongoing Measurement and Verification projects. In this first part of the report, a tracking of the ongoing projects from the account is going to be performed.
4. Savings to date. This indicates the level of energy savings achieved from the beginning of the project until the last day tracked by comparing the real consumption to the baseline.

13_5b75771c26984.png
1. Report title. The report gets its title from the report configuration wizard.
2. Report reference date. It indicates the last day from the week that the report is going to track.
3. Ongoing project tracked. Information about the project that is being tracked.
4. Savings to date. This indicates the level of energy 
savings achieved from the beginning of the project until the last day tracked by comparing the real consumption to the baseline.
5. Last 7 days of evolution. This chart shows the evolution of the project for the last 7 days, comparing the real consumption to the baseline.
6. Summary table. It shows the total energy consumed and the energy difference for the last 7 days. 

7. Last 28 days of evolution. This chart shows the evolution of the project for the last 28 days, comparing the real consumption to the baseline.
8. 
Summary table. It shows the total energy consumed and the energy difference for the last 28 days.

14_5b75771c81b39.png

1. Report title. The report gets its title from the report configuration wizard.
2. Report reference date. It indicates the last day from the week that the report is going to track.
3. Ongoing project tracked. Information about the project that is being tracked.
4. Savings to date. This indicates the level of energy 
savings achieved from the beginning of the project until the last day tracked by comparing the real consumption to the baseline.
5. Evolution from the beginning of the project. This chart shows the evolution of the project from the beginning to the last day tracked, comparing the real consumption to the baseline.
6. Summary table. It shows the total energy consumed during the period and the energy difference from the beginning of the project to date.


 

Report explanation - Side B. Summary of the already completed MVP's

15_5b75771cd94ba.png

   1. Report title. The report gets its title from the report configuration wizard.
2. Report reference date. It indicates the last day from the week that the report is going to track.
3. Status for completed Measurement and Verification projects. In this second part of the report, a tracking of the already completed projects from the account is going to be performed.
4. Savings to date. This indicates the level of energy savings achieved during the whole period of the project by comparing the real consumption to the baseline.

16_5b75771d3de9c.png
1. Report title. The report gets its title from the report configuration wizard.
2. Report reference date. It indicates the last day from the week that the report is going to track.
3. Completed project tracked. Information about the project that is being tracked.
4. Savings to date. This indicates the level of energy savings achieved during the whole period of the project by comparing the real consumption to the baseline.
5. Evolution from the beginning of the project. This chart shows the evolution of the whole project, comparing the real consumption to the baseline.
6. Summary table. It shows the total energy consumed during that period and the energy difference from the whole period of the project.

 

 

 

5. Weekly pro

 

What is it for?

The weekly professional report was born as a tool to quickly check the performance of a facility, focusing on energy, cost and baseload consumption. This report helps to identify the top-5 deviations above a 4-weeks baseline, monetizing them. 
Concerning the consumed base load, this report analyzes the evolution for the last 4 weeks, and how much it cost each base load kW with the current energy prices.
   

Available configurations

  • Automations: Weekly
  • By locations

     

Requirements

  • Main device configured in a location with data
  • Tariff assigned
   

Report explanation - Side A

05_5b7576574f755.png

  1. Report title. Report gets its title from the report configuration wizard. 
  2. Date range for the report. This report is only available in a weekly automation, so each Monday you will get the report. Below, it appears the report device name where data is acquired.
  3. Summary table for this week, compared with last week and 4 previous last week median.
  4. This chart shows the consumption by day of the week (Monday-Sunday), compared with the median of previous 4-weeks. Interesting to see if some remarkable differences appeared. 
  5. List of very important energy indicators for the current week and last 4 weeks median. Energy managers must have a look at "baseload %" and "Weekly Utilization Factor". First one relates how much power is used all the time, while the second one shows how many full utilization hours a week your facility uses.  
  6. This chart benchmarks 4 different energy curves: Current week, the 4 weeks median baseline, 4 weeks maximum demand and 4 weeks minimum demand. If your facility is performing well, it won't go above the 4 weeks maximum.
  7. Top 5 deviations above the maximum demand curve. This table prints major 5 detected inefficiencies during the week above last 4 weeks maximum curve baseline. It gives information about the duration, wasted kWh and wasted money. 
  8. Top 5 deviations above the median demand curve. This table prints major 5 detected inefficiencies during the week above last 4 weeks median curve baseline. It gives information about the duration, wasted kWh and wasted money.
  9. Summary cost wasted current week against last 4 weeks median baseline. It is a very important value to have a look all weeks.

 

Report explanation - Side B

06_5b7576580c4ad.png

  1. Report title. Report gets its title from the report configuration wizard. 
  2. Date range for the report. This report is only available in a weekly automation, so each Monday you will get the report. Below, it appears the report device name where data is acquired.
  3. This chart shows your current week consumption curve, in blue, with the average baseload as a grey band. This is the volume of energy that your facility consumes every week by default, so it is a very sensitive part of your total consumption and should be monitored closely.
  4. Summary figures according to baseload, such as median base load, total baseload energy consumed, baseload weekly cost, and base load cost % above total weekly cost. These data indicate whether it is worthwhile to focus efforts on reducing consumption-based or not.
  5. This chart shows the base load evolution for the last 4 weeks. The dotted line indicates de % of baseload above the total load, so the trend slope should be negative to get energy savings.
  6. Baseload reduction/increase for the current week versus 4 weeks previous median. 
  7. Summary table for the last 4 weeks.
  8. Information message quantifying how much money costs each kW consuming during the whole year (8,760h).

 

 

 

6. Water bill simulation

 

What is it for?

The Water bill simulation report helps users to get a simulated bill for their facilities before they get the real one from the utility. The billed concepts depend on the prices configuration, so the report is fully customizable. It also can be used as a tenant billing report

   

Available configurations

  • Automations: Monthly, on-demand
  • By locations

     

Requirements

  • Main water device configured in a location with data
  • Tariff assigned
   

Report explanation

08_5b757660c9c6d.png

  1. Report title. Report gets its title from the report configuration wizard. 
  2. Date range for the report. This report is available on-demand or in a monthly automation, so each 1st day of the month you will get the report. Below, it appears the report device name where data is acquired.
  3. Customer data, such as current contract, contracted demand, tariff, etc.
  4. This chart shows daily water cost by blocks, for the whole report time range. Each colour represents different blocks. The used billing strategy can be selected on the "prices" form.
  5. Total billed cost, excluding VAT.
  6. Total billed water.
  7. Figures concerning water and cost usage, such as daily average and hourly cost.
  8. Billing table, disaggregating total cost by different concepts, such as water consumed, fixed costs, taxes, etc. Each concept can be configured in the "prices" form. 
  9. Total billed cost, including VAT
  10. Water cost pie chart, showing the distribution between consumption and fixed costs.
  11. This chart shows the evolution of water consumption (in bars) and average water cost (in lines) for the last twelve months.

 

 

 

7. Electricity bill simulation

 

What is it for?

The Electricity bill simulation report helps users to get a simulated bill for their facilities before they get the real one from the utility. The billed concepts depend on the prices configuration, so the report is fully customizable. It also can be used as a tenant billing report

   

Available configurations

  • Automations: Monthly, on-demand
  • By locations

   

Requirements

Procedure to generate it

Go to Reports --> New report --> Electrical bill simulation. In the settings select the location where the general meter is.

   

Report explanation

07_5b75765d39a18.png

  1. Report title. Report gets its title from the report configuration wizard. 
  2. Date range for the report. This report is available on-demand or in a monthly automation, so each 1st day of the month you will get the report. Below, it appears the report device name where data is acquired.
  3. Customer data, such as current contract, contracted demand, tariff, etc.
  4. This chart shows daily energy cost by tariff time bands, for the whole report time range. Each colour represents a different tariff period (peak, off-peak, etc.) 
  5. Total billed cost, excluding VAT.
  6. Total billed energy.
  7. Figures concerning energy and cost usage, such as average daily and hourly cost.
  8. Billing table, disaggregating total cost by different concepts, such as energy consumed, demand, reactive excess, etc. Each concept can be configured in the "cost" form. 
  9. Maximum demand by tariff time band analysis. Important for countries that have contracted load and excess penalties.
  10. Cost and energy pie charts, showing the distribution by tariff time bands for both variables.
  11. This chart shows the evolution of energy consumption (in bars) and average energy cost (in lines) for the last twelve months.
  12. Total billed cost, including VAT

  

 

 

 

8. Exported electricity bill simulation

 

What is it for?

 

The exported electricity bill simulation report helps users to get a simulated electricity bill before they get the real one from the utility. The billed concepts depend on the prices configuration, so the report is fully customizable.
It differs from the Electricity bill simulation report by the variables used to calculate the costs.
 

Available configurations

 
  • Automation: monthly, on demand.
  • By location.
 

Requirements

 
  • Main device configured in a location with data.
  • Prices assigned.
 

Report explanation

11_5b75751a744ad.png
1. Report title. The report gets its title from the report configuration wizard.
2. Date range for the report. The report is available on demand and in a monthly automation, so each 1st day of the month you will get the report. Below it appears the name of the device from where the data is acquired.
3. Customer data. All data related to the customer, such as current contract and prices.
4. Daily energy cost. This chart shows the daily energy cost for the whole time range.
5. Total billed cost. This shows the price wasted on electricity.
6. Total used energy. This shows the amount of energy used during the indicated period of time.
7. Other costs. This line shows daily and the average cost per kWh, as well as the average of energy used.
8. Billing table. This table indicates the amount of cost that supposes the Energy term and the Fix term, and the total cost.
9. Distribution by concept. This pie chart indicates the percentage of the data that comes from the Fix term and the one that comes from the Energy term.
10. Consumption and average cost for last year. This chart shows the evolution of energy consumption (in bars) and average cost (in lines) for the last twelve months.
 

 

 

 

9. Thermal bill simulation

 

What is it for?

 
The exported Thermal bill simulation report helps users to get a simulated Thermal bill before they get the real one from the utility. The billed concepts depend on the prices configuration, so the report is fully customizable.
 

Available configurations

 
  • Automation: monthly, on demand.
  • By location.
 

Requirements

 
  • Main Thermal device configured in a location with data.
  • Prices assigned.
 

Report explanation

10_5b757511198d7.png
 
1. Report title. The report gets its title from the report configuration wizard.
2. Date range for the report. The report is available on demand and in a monthly automation, so each 1st day of the month you will get the report. Below it appears the name of the device from where the data is acquired.
3. Customer data. All data related to the customer, such as current contract and prices.
4. Daily energy cost. This chart shows the daily energy cost for the whole time range.
5. Total billed cost. This shows the price wasted, excluding VAT.
6. Total used energy. This shows the amount of energy used during the indicated period of time.
7. Other costs. This line shows daily and the average cost per kWh, as well as the average of energy used.
8. Billing table. This table indicates the amount of cost that supposes the Energy term and the Fix term, and the total cost including VAT.
9. Distribution by concept. This pie chart indicates the percentage of the data that comes from the Fix term and the one that comes from the Energy term.
10. Consumption and average cost for last year. This chart shows the evolution of energy consumption (in bars) and average cost (in lines) for the last twelve months.

 

 

 

 

10. Gas bill simulation

 

What is it for?

The Gas bill simulation report helps users to get a simulated bill for their facilities before they get the real one from the utility. The billed concepts depend on the prices configuration, so the report is fully customizable. It also can be used as a tenant billing report

   

Available configurations

  • Automations: Monthly, on-demand
  • By locations

     

Requirements

  • Main gas device configured in a location with data
  • Tariff assigned
   

Report explanation

09_5b757663156e9.png

  1. Report title. Report gets its title from the report configuration wizard. 
  2. Date range for the report. This report is available on-demand or in a monthly automation, so each 1st day of the month you will get the report. Below, it appears the report device name where data is acquired.
  3. Customer data, such as current contract, contracted demand, tariff, etc.
  4. This chart shows daily gas cost according to the selected billing strategy, configured on "prices" form.
  5. Total billed cost, excluding VAT.
  6. Total billed gas.
  7. Figures concerning gas and cost usage, such as daily average and hourly cost.
  8. Billing table, disaggregating total cost by different concepts, such as gas consumed, fixed costs, taxes, etc. Each concept can be configured in the "prices" form. 
  9. Total billed cost, including VAT
  10. Gas cost pie chart, showing the distribution between consumption and fixed costs.
  11. This chart shows the evolution of gas consumption (in bars) and average gas cost (in lines) for the last twelve months.
 
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.