EXCEL Reports
Portfolio Performance & Data Quality Report
Navigate to Portfolio → Reports → Performance A comprehensive excel report that includes annual and monthly consumption trends and data quality metrics across the portfolio, properties, and in-metric meters. Property-level The property level tabs in the EXCEL report include the following data quality insights:Data Quality Metrics
Data Quality Metrics
- Whole Building (in-metric) Data Completeness
- Number of In-Metric Meters with Months with Jumps from Prior Year (50%)
- Number of In-Metric Meters with Gaps
- Number of In-Metric Meters with Overlaps
Whole Building Consumption Metrics & Annual Percent Changes
Whole Building Consumption Metrics & Annual Percent Changes
| Energy Metric | Emissions Metric |
|---|---|
| ENERGY STAR Score | Total (Location-Based) Emissions |
| Energy Use Intensity | Total (Location-Based) Emissions Intensity |
| Total Energy | Total (Market-Based) Emissions |
| Total Electricity | Total (Market-Based) Emissions Intensity |
| Green Power - Total Onsite | Direct Emissions |
| Green Power - Total Offsite | Indirect (Location-Based) Emissions |
| Total Fuel | Indirect (Market-Based) Emissions |
| Total District Heat & Cooling |
Meter Gaps, Overlaps, Jumps, Consumption, Annual Percent Changes
Meter Gaps, Overlaps, Jumps, Consumption, Annual Percent Changes
- Data Coverage Events
- Data Completeness
- Specific Monthly Jumps from Prior Year
- Specific Gaps
- Specific Overlaps
- Total Energy & percent changes
- Total Emissions & percent changes
Landlord vs. Tenant Performance Report
Navigate to Portfolio → Reports → Performance A comprehensive excel report that includes annual and monthly consumption trends and data quality metrics across the portfolio, property spaces types (e.g. landlord vs. tenant) and all in-metric and out-of-metric meters. Property-level The property level tabs in the EXCEL report include the following data quality insights:Data Quality Metrics
Data Quality Metrics
- Data Completeness (%): All Meters with Assigned Spaces
- Number of Assigned Meters with Months with Jumps from Prior Year (50%)
- Number of Assigned Meters with Gaps
- Number of Assigned Meters with Overlaps
Space-based Consumption Metrics & Annual Percent Changes
Space-based Consumption Metrics & Annual Percent Changes
- Total Energy - (Assigned) Base Building (Common Areas)
- Total Energy - (Assigned) Base Building (Shared Services)
- Total Energy - (Assigned) Tenant Spaces (Landlord Controlled)
- Total Energy - (Assigned) Tenant Spaces (Tenant Controlled)
- Total Energy - (Assigned) Outdoor / Exterior Areas / Parking Landlord Controlled
- Total Energy - (Assigned) Outdoor / Exterior Areas / Parking Tenant Controlled
- Total Energy - (Assigned) EV Charging
Meter Gaps, Overlaps, Jumps, Consumption, Annual Percent Changes
Meter Gaps, Overlaps, Jumps, Consumption, Annual Percent Changes
- Data Coverage Events
- Monthly Jumps from Prior Year
- Data Completeness (%)
- Specific Gaps
- Specific Overlaps
- Total Energy
- Green Power - Total Onsite
- Total Location-based Emissions
ENERGY STAR Portfolio Manager® Gaps & Flags Report
Navigate to Portfolio → Reports → ESPM A comprehensive excel report that identifies potentially anomalous (e.g. high or low) property attributes, property performance metrics, meter configurations, and meter entries across the portfolio. Threshold parameters, which are used to detect potential anomalies, can be set by the user prior to report generation.
ENERGY STAR Portfolio Manager® Meter Status by Provider Report
Navigate to Portfolio → Reports → ESPM An excel report that lists every meter in the portfolio that is updated by a specific ESPM data provider with additional information about when the meter was last updated and its configuration.| Meters Included in this Report | This report includes all meters (in-metric & out-of-metric) across all properties in the portfolio for which any entry has been created or updated by the selected data provider. |
|---|---|
| Meter is in Metric? | In-metric meters are those designated to contribute to whole building performance metrics. |
| Meter Status | The current activation status of a meter. Meters that have been deactivated are no longer used to track data and do not contribute to performance calculations outside of their active periods. |
| Meter Date Created | The date on which the meter was created. |
| Meter Created By | The username of the entity that created the meter. |
| All Providers | The usernames of each entity that has created or updated any consumption entry in the meter at any point since the meter was first created. |
| All Providers - First Entry Start Date | The start date of the first (i.e. earliest in time) entry of the meter that was created or updated by ANY data provider. |
| All Providers - Last Entry End Date | The end date of the latest (i.e. furthest in the future) entry of the meter that was created or updated by ANY data provider. |
| Abisko - Last Date Meter Updated | The most recent date on which the selected data provider (Abisko) created or updated any consumption entry of the meter. |
| Abisko - Last Entry End Date | The end date of the latest (i.e. furthest in the future) entry of the meter that was created or updated by the selected data provider (Abisko). |