How to Enable or Disable the Aggregate Sheet in the Energy and Demand Report

Goals and Symptoms

The first worksheet of the Energy and Demand Report, called Aggregate Energy & Demand, contains the overall energy and demand information. If there are multiple queries, this worksheet will contain the totals from the other queries. You have the option of either enabling or disabling the generation of this sheet.

Facts and Changes

Keywords

Aggregate, Energy and Demand report

Causes and Fixes

Resolution
How to Enable or Disable the Aggregate Sheet in the Energy and Demand Report

• 1. Open the Energy and Demand Report template in Microsoft Excel.
  2. Select Format > Sheet > Unhide. Select the |Private|Template sheet and click OK.
  3. Find the row labeled Aggregate Sheet:
  • • · Setting the Aggregate Sheet to 0 will disable the sheet.

      · Setting the Aggregate Sheet to 1 will enable the sheet.

  4. Select Format > Sheet > Hide to hide the |Private|Template sheet.
  5. Click Save.

Now when you generate the report, the aggregate sheet with either be enabled or disabled.

Original article#10703

All content © 1992-2005 Power Measurement

---

Legacy KB System (APS) Data: RESL182928 V1.0, Originally authored by DaMi on 03/20/2007, Last Edited by DaMi on 03/20/2007
Related ranges: ION Enterprise