How to Export the Data Quality Report

Measurabl's Data Quality Report (DQR) is a comprehensive export available to portfolio and subgroup members. This export provides granular data into your portfolio/subgroup including: Relevant Site Profile Information, YOY Property Trends, and Yearly & Monthly Meter Level Totals. 

How to Export the Data Quality Report

1. From the Measurabl landing page, click on the 'Reports' tab.
2. Click 'Export XLSX' in the 'Data Quality' card.
3. Choose the period that you would like to export the data for > Export.
   
   
4. Open the export to peruse, filter, and utilize your data! Note that there are 4 tabs:
   • Portfolio: This tab includes all of the important property information at all of your properties. The following is the list of data that is included on this tab.
     • Group Name
     • Company
     • Building ID/Custom ID
     • Building Source
     • Building Name
     • Address, City, State/Province, Postal Code, Country
     • Primary Type, Secondary Type(s), GRESB Primary Type
     • Gross Floor Area (GFA), Gross Leased Area (GLA)
     • Year Built, Bought/Sold Dates (Leased/Lease Terminated)
     • Current Lifecycle Stage, Lifecycle Events
     • EnergyStar Score
     • Property Managers
     • Control, Tenancy
     • % Owned, % GLA
   • Property Trends: This tab shows you the trends for each utility type, emissions, and occupancy at each property.
   • Meters: This tab shows you a high-level overview of all of the meters at each property.
   • Monthly: Here you will find all of the monthly readings for each meter and property. 
     
     

Additional Information & FAQs

Why are the readings in the report different than what is in the meters?

• The usages that appear on the 'Monthly' tab are calendarized. Meaning, if you have meter readings that don't start on the first and last day of the month, the usages are normalized for each day so that the whole month has a single usage.
  • For Example: If you were billed for 3,194 kWh, and there are 30 days in the billing period:
    • 3,194 kWh / 30 days = 106.467 kWh per day
    • The difference: 19 days in January (31 days total - 12 days in January prior to start of bill)
    • 106.467 kWh per day * 19 days = 2,022.873 kWh from January 13 - January 31 for this meter.
      • To get the rest of January's usage you'd need to do the same exercise with the bill beginning in December and ending in January, and then add that usage (for the first 12 days of January) to the 2,022.873 total 

Why are the units in the report the same for each utility type?

• The units of measurement in the Data Quality Report are based off of the preferences set in your user profile. See here on how to change those preferences.

Do inactive meters and properties appear in the report?

• Inactive meters are included on the report.
• EnergyStar 'Link Incomplete' sites are included on the report.
• Sites that were removed, but retained for reporting & analytics, are included on the report.
• Inactive sites are not included on the report.
• EnergyStar 'Removed' sites are not included on the report.

Do sites with a sold date appear on the report?

• Yes! Properties with sold dates will still show on the report. However, only data that is between the bought and sold dates will be available in the report.

How is occupancy calculated on the report?

• The occupancy values entered at the site profile level are first converted into monthly values. If data is entered for every month, then this step is done. However, if data was added less frequently, such as annually or quarterly, the months without an occupancy value are assumed to be the same as the last month before it with data (see example below).

  • Site A has 2 occupancy values:

    • Jan: 60%

    • Mar: 40%

    Measurabl calculates this to mean:

    • Jan: 60%

    • Feb: 60%

    • Mar: 40%

    Since February didn’t have a value, it’s assumed that the occupancy was still 60% until March, when it changed to 40%.
    
    

• Additionally, any empty months before the first occupancy value (and after the site’s sold date), are backfilled with the first occupancy’s value (see example below).

  • For Site A:

    • Bought Date: Jan

    • Occupancy value: Jun @ 85%, Jul @ 90%

    Measurabl calculates the occupancy like this:

    • Jan-May = 85% (backfilling)

    • Jun = 85%

    • Jul and onwards = 90% (see gap filling explanation above)

    Since the site was purchased in Jan, Jan-May were expected to have occupancy values. It’s assumed the occupancy was also 85% for those months, but first recorded in June.