(Optional) Configure Additional Energy Report Parameters

  1. Select Applications > Advanced Reporting.
  1. In the Application Viewer tab, click the Configuration Page.
  • The Advanced Reporting Configuration Page displays.
  1. In the Configuration section, next to Additional Energy Report Settings (for Cost, Emissions, Budget, and Performance), click Edit.
  • In the Parameter dialog box that displays, proceed as follows for the selected type of report.
  • For Consumption Cost Report: In the Cost Value format display field, select the value format in which the cost is to be displayed. In the Currency in cost report field, specify the currency format.
  • For Consumption Emissions Report: In the CO2 unit display field, select the unit in which CO2 emission value is to be measured.
  • For Consumption Budget Report: In the Budget % display field, select either % used of the Budget to display the percentage consumed from the planned budget amount or Difference in % to display the remaining budget balance in percentage.
  • For Consumption Budget Report: In the Default Graph type (Budget) field specify the type of graph in which the budget series is to be displayed.
  • For Consumption Degree Days Corrected Report: In the HDD Corrected, Value 1 display in Graphics and HDD Corrected, Value 2 display in Graphics fields, select the value that you want to display in the graph in the report. The options include, Consumption measured, Consumption Not corrected part, Consumption corrected part, and Total corrected consumption.
  1. Click Execute.
  • The settings are applied and the list of managed meters configured in your system display.
    You can now copy the meter IDs as well as the names of the managed meters in the Meter ID and MeterName columns in the MeterIDList worksheet in EnergyReportsExternalSetting.xlsx.
  1. For Consumption Emissions Report, Consumption Budget Report, and Consumption Performance Report: In the Read Worksheet section, click Clean Tables next to Clean tables in cache (for an update of data from Excel worksheet) so that any latest changes done in EnergyReportsExternalSetting.xlsx are reflected in the generated report output.
  1. You can also view the following information that has been configured in the EnergyReportsExternalSetting.xlsx file by clicking the Read worksheet button next to the corresponding options:
    a. Check the Excel file in the worksheet "MeterSurfaceCovered" - Surface area covered by the listed meters.
    b. Check the Excel file in the worksheet "MeterVatFee" - Amount of VAT and meter fee specified for the meters.
    c. Check the Excel file in the worksheet "MeterTariffData" - Tariff specified for the meters.
    d. Check the Excel file in the worksheet “Budget” - Whether or not the budget has been configured for each listed meter, number of months for which the budget is configured for a meter, and whether any duplicate entry exists for a meter in the excel.