ANALYZE THE DATA

Once project and portfolio data are entered, the DDx provides a variety of ways to study a firm’s progress. Data is kept confidential, but projects of similar type, size, climate, and a host of other attributes can be compared across the 2030 portfolio.

 

Built-in reports

The Reports screen allows viewing and interaction with interact with dynamic graphs at the Firm and Program Level. Firm level reports use a firm's portfolio as the data set, while program level reports use the overall AIA 2030 Commitment project set as the data set. Energy Modeling and Reported Projects reports are available in both data sets, allowing comparison of firm results to the program results.

 

This short video introduces how to work with reports.

Reports Types

The table outlines the different reports within the Firm and Program and describes the intent of each report.

     

Level

Report Name

Report Description

Firm

AIA 2030 Commitment 

A variation of the previous Whole Building/Addition and Source and Emissions reports from the previous spreadsheet tool. A collection of donut charts and bar graphs that provide high-level metrics for the firm's portfolio and the project set that has Source & Emissions project data.

Dataset Filters:  Year, Office Location, Reporting Status 

Firm

Progress

A set of bar charts for % pEUI Reduction, Energy Modeling, Collect Operational Data, % LPD Reduction and CO2e Emissions Intensity that display the yearly average for each year that the firm has contributed data.

Dataset Filters:  Office Location, Reporting Status 

Firm

Predicted EUI

A set of drilldown bar charts controlled by three additional filter variables. The top graph displays one of three variables (Project Size, Use Type, Office Location), which is controlled by the first drop-down selection. The bottom graph displays the selected bin of the initial variable choice, and then energy modeled projects or projects pursuing a green building rating can be highlighted.

Dataset Filters:  Year, Office Location, Reporting Status

Firm

Energy Modeling

A series of charts showing different perspectives on the firm's projects that have energy models. View the % GSF of projects, % pEUI difference of Modeled vs. Not Modeled, Energy Modeling Tools, who is doing the energy modeling, and the time effort involved. 

Dataset Filters:  Year, Office Location, Reporting Status

Firm

Reported Projects

A series of charts showing different perspectives of the firm's reported projects.  View the diversity and quantity of buildings within different use types, the pEUI % Reduction based on % reduction bins, project diversification across project phase, and global location of the firm's projects.   

Dataset Filters:  Year, Office Location, Reporting Status

Program  

Results at a Glance

A set of bar and stacked bar charts that provide an overview of the key metrics for the AIA 2030 Commitment Program for each year the program has developed an annual report.

 

Dataset Filters:  None

Program  

Reporting Firms

Displays the quantity of firms of different bin sizes that have reported project data to the program each year.

 

Dataset Filters:  None

Program

Energy Modeling

A series of charts showing different perspectives on the PROGRAM LEVEL projects that have energy models.  View the %GSF of projects, % pEUI difference of Modeled vs. Not Modeled, Energy Modeling Tools, who is doing the energy modeling, and the time effort involved.

Dataset Filters:  Year

Program

Reported Projects

A series of charts showing different perspectives of the PROGRAM LEVEL reported projects. View the diversity and quantity of buildings within different use types, the pEUI % Reduction based on % reduction bins, project diversification across project phase, and global location of the firm's projects.   

Dataset Filters:  Year

 

Dataset Controls

Above the Report Types menu on the left side of the screen are controls for up to three drop-down lists to change and/or refine the dataset being worth with, and the projects that are displayed in the reports.

  • Year: Similar to other workspaces, the years for the dataset can be changed. (Default = All).

  • Office Location: If a firm has multiple offices included on the Firm Accounts screen, this control allows for selection of different offices. (Default = All).

  • Reporting Status: Allows "Ready to Submit" projects to be included in the results displayed, along with those that have been "Submitted" to the AIA 2030 Commitment. (Default = All).

Firm Level Reports

The different firm level report types, charts, chart type, and axes are identified for each in the following sections. The charts include hover highlight capabilities, and any of the charts can be printed and/or exported by selecting the menu icon.

AIA 2030 Commitment Report

The main sections are All Projects (top) and Source and Emissions (bottom). The report provides the same information that the AIA 2030 Commitment Spreadsheet tool provided, but presents it in the same report, and makes the results more engaging.

 

  • All Projects: The description at the top summarizes the number of projects included and the overall GSF being displayed within the report. At the bottom of this section the overall GSF is broken down into Whole Building (Non-Residential and Residential) and Interior Only values to provide a clearer picture for the graphs above.

 

The first three graphs deal with Whole Building (Non-Residential and Residential) and the last with Interior Only projects. Below the graphs are GSF totals related to each graph above.  

 

  • Source and Emissions: The Project and GSF values totals for this section are displayed on the bottom right. If projects include input values on the Design and Emissions dialog box on the General Inputs screen, section 2, the cumulative results for all the firm's projects will display here. The dialog box only appears as an option if "Energy Model Status" is "Has Been Modeled". If no projects have Source and Emissions data, the graphs will appear blank.

 

The donut graph displays the Design Source Energy (Blue = Site Energy) for the projects included.  The goal is to have all energy provided on site, so that this value would display as 100%. The column chart displays the Design CO2e emissions Intensity for the overall project set, which provides a comparison value for projects year to year, office by office, or for submitted or ready to submit projects, depending on the filters selected in the upper left.  

 

Finally, the table on the far right provides different equivalent metrics for the collection of projects, to tell the performance story in different ways. For example, it would take 26,717 acres of carbon sequestered annually to accommodate the emissions from the set of projects included in the analysis.  

 

 

Progress Report

A collection of five bar charts that are in the same format displaying results for each year, but with different vertical axes for each. The set allows a direct comparison for the firm for the years that AIA 2030 Commitment Reporting has occurred. Hovering over the bars displays the specific value for the year displayed.

 

  • % pEUI Reduction: Displays the year % pEUI Reduction for the project set as compared to the Baseline EUI. The formula is the (SUM FOR PROJECTS OF (% pEUI Reduction X GSF)) / GSF of overall Projects (Non-Res, Res).

 

  • Energy Modeling: Displays the percentage of Gross Floor Area Modeled for each of the years Whole Building (Non-Res, Res) projects. The formula is the GSF of Modeled Projects (Non-Res, Res) / GSF of overall Projects (Non-Res, Res).

 

  • Collect Operational Data: Displays the percentage of Gross Floor Area of projects that are targeting having operational data collected for each of the years for the whole building (Non-Res, Res) projects. The formula is the GSF of Projects (Non-Res, Res) Collecting Data) / GSF of overall projects (Non-Res, Res).

 

  • % LPD Reduction: Displays the yearly % LPD Reduction for the project set as compared to the Baseline LPD, as determined by ASHRAE 90.1-2007. The formula is (SUM FOR PROJECTS OF (% LPD Reduction X GSF [Interior Only])) / GSF of Projects [Interior Only].

 

  • CO2e Emissions Intensity: Displays the yearly Design Co2e Emissions Intensity (lbs CO2e/sf/yr) for the firm's project set that contains Source and Emissions inputs compared to the overall. The Source and Emissions data is input for projects that have energy models on the General Inputs screen in Section 2.

 

Predicted EUI Report

The top graph shows the % pEUI Reduction for one of three categories (Project Size, Use Type and Office Location). The bottom graph displays a drilldown view of the top graph, made up of a breakdown of projects in the selected bar. Bars can be selected in the “Bin Drop-down” list, the second selection menu located between the two graphs. In addition, another filter to highlight projects on the lower graph can be added by selecting “All Projects”, “Projects w/ Energy Models” or “Projects pursuing green building rating” from the third drop-down list. 

 

The view on the bar chart can also be zoomed in if a significant number of projects are displayed in the lower graph even after filter selections.

 

Filters

 

The PREDICTED EUI Report features the most filters (four) available in any of the reports:

  

  • Upper Left: Year, Office Location, Reporting Status

  • % pEUI Reduction Category: Project Size, Use Type, and Office Location

  • Bin: Options vary based on which category was selected above

  • % pEUI Reduction Type: All projects, Energy Modeled, Pursuing Green Building Rating

Energy Modeling Report

  • Energy Model % GSF of Projects: The donut chart shows the percentage of GSF for Non-Res and Res projects for the firm’s portfolio that HAS BEEN MODELED, and the percentage that HAS NOT BEEN MODELED as compared to the overall GSF for Non-Res and Res projects. The portion of the donut highlighted in dark blue represents the percentage of GSF that has been modeled. The chart can be exported in image or spreadsheet form.

  • Will Actual EUI Data Be Collected: The donut chart shows the percentage of GSF for Non-Res and Res projects for the firm’s portfolio that WILL HAVE PERFORMANCE DATA COLLECTED, and the percentage that WILL NOT HAVE PERFORMANCE DATA COLLECTED as compared to the overall GSF for Non-Res and Res projects. The portion of the donut highlighted in dark blue represents the percentage of GSF that will have performance data collected. The chart can be exported in image or spreadsheet form.

  • % pEUI Difference: This graphic is a comparison to show the difference between the Average % pEUI reduction for MODELED and NOT MODELED projects. The number on the left below the circle is the Average % pEUI Reduction for the firm’s MODELED projects, and the number of the right below the circle is the Average % pEUI Reduction for the firm’s NOT MODELED projects.  The number displayed in the circle is the % Difference. (% Difference = Average % pEUI Reduction for MODELED projects - Average % pEUI Reduction for MODELED projects).  

It should be noted that the % difference calculation has a number of flaws and is only provided to demonstrate the potential to increase the % pEUI reduction if projects pursue energy modeling. First, it makes the assumption that the NOT MODELED projects achieve the % pEUI Reduction that is associated with the Design Energy Code selection. Second, because of this assumption, there is a difference in rigor between the two numbers. The modeled projects incorporate the rigor of the energy model simulation, while the not modeled projects are just based on a design energy code selection.

  • What Tool?: Displays the energy modeling tool that was used and the number of projects that it was used for within a firm’s portfolio. Only the energy modeling tools that have at least one project associated with them will be displayed. For reference, “not modeled” projects are displayed along the top row, which provides feedback on the number of projects within the portfolio that are not pursuing energy modeling. Firms may want to set an internal goal for this to be a low number. The chart can be exported in image or spreadsheet form.

  • Who?: Displays who is doing the energy modeling on projects, and the number of projects within the portfolio (influenced by filter selections) for which they are doing energy modeling. The chart can be exported in image or spreadsheet form.

  • How Many Hours?: Displays the ranges of hours associated with the energy model for the firm’s modeled projects. Each bin (range of hours) displays the number of projects that reported the energy modeling effort to be within that range. The chart can be exported in image or spreadsheet form.

 

Reported Projects

These four bar charts dig deeper into the landscape of what use types, % pEUI Reduction range, Project Phase and Global location are associated with projects. 

 

Note: Multiple project views for the same project are not displayed. For example, if a project has been advanced and is reported on for multiple years, therefore having multiple project views, and if Years = All, then the most recent “Submitted Year” and associated use type, % pEUI reduction, project phase and global location, if applicable, are what will be displayed. 

 

  • Use Type: Displays the number of projects for each use type for the Firm’s Portfolio. Only the use types that have at least one project associated with them will be displayed. The number of projects displayed in the graph are influenced by the filter selections (upper left). If a project has more than one use type associated with it, then the project is associated with the use type with the largest area. The chart can be exported in image or spreadsheet form.

 

  • % pEUI Reduction: Displays a set of % pEUI reduction ranges (bins) for the firm’s projects. Each bin displays the number of projects that fall that within that % pEUI reduction range. The number of projects displayed in the graph are influenced by the filter selections (upper left). The chart can be exported in image or spreadsheet form.

 

  • Project Phase: Displays the number of projects in the firm’s portfolio for each of the Project Phase options. The first five represent the design and construction phases, and the last two express if the design project is moving forward to an “occupied” phase or if the project has been “closed” and is not continuing forward. The number of projects displayed in the graph are influenced by the filter selections (upper left). The chart can be exported in image or spreadsheet form.

 

  • Global Location: Displays the number of projects in the firm’s portfolio for each of the global locations, which are geographic regions. The number of projects displayed in the graph are influenced by the filter selections (upper left). The chart can be exported in image or spreadsheet form.

Program Level Reports

The different program level report types, charts, chart type, and axes are identified for each in the following sections.

Results at a Glance Report

A set of three graphs providing a glance at the AIA 2030 Commitment program for a range of different metrics to provide different snapshots. As the program continues to grow and more firms, more projects, and more GSF become part of the data set, these charts becoming increasingly interesting.

 

  • High Level Program Metrics: The four metrics of Average Firm % pEUI Reduction, % of Projects > 60% Reduction, % Total of GSF Energy Modeled and % Total of GSF Collecting Performance Data are displayed in clusters on the same bar graph for each of the years of the AIA 2030 Commitment Program. 

 

Note: The data for each reporting year will be included on the graph after the AIA 2030 Commitment Annual Report is released by AIA.

 

  • Number of Firms Submitting Data: A stacked bar graph showing the three keys items for each year – the number of signatory firms that reported (dark blue), the number of signatory firms that did not report (gray), and the number of signatory firms in the program overall (Reported Number + Not Reported Number). 

 

Note: The data for each reporting year will be included on the graph after the AIA 2030 Commitment Annual Report is released by AIA.

 

  • AIA 2030 Commitment Project GSF Submitted: Displays the total project GSF (Non-Res + Res + Interior Only) for each AIA 2030 Commitment Program year.

 

Note: The data for each reporting year will be included on the graph after the AIA 2030 Commitment Annual Report is released by AIA.

 

Reporting Firms Report

A graph displaying bins for size of reporting signatory firms on the horizontal axis, and the number of reporting firms on the vertical axis for each year of the program. The years for each bin are displayed from left to right, so the leftmost bar for each bin is the year 2010. Hovering over a bar will display the exact number of firms for that year. In addition, the graph can be exported in graphic or spreadsheet form by selecting the desired option from the menu icon (upper right) drop-down list.

 

Note: The data for each reporting year will be included on the graph after the AIA 2030 Commitment Annual Report is released by AIA.

 

Energy Modeling Report

  • Energy Model % GSF of Projects: The donut chart shows the percentage of GSF for Non-Res and Res projects for the AIA 2030 Commitment Data Set that HAS BEEN MODELED, and the percentage that HAS NOT BEEN MODELED as compared to the overall GSF for Non-Res and Res projects. The portion of the donut highlighted in dark blue represents the percentage of GSF that has been modeled. The chart can be exported in image or spreadsheet form.

 

  • Will Actual EUI Data Be Collected: The donut chart shows the percentage of GSF for Non-Res and Res projects for the AIA 2030 Commitment Data Set that WILL HAVE PERFORMANCE DATA COLLECTED, and the percentage that WILL NOT HAVE PERFORMANCE DATA COLLECTED as compared to the overall GSF for Non-Res and Res projects. The portion of the donut highlighted in dark blue represents the percentage of GSF that will have performance data collected. The chart can be exported in image or spreadsheet form.

 

  • % pEUI Difference: This graphic is a compares the difference between the Average % pEUI reduction for MODELED and NOT MODELED projects. The number on the left below the circle is the average % pEUI Reduction for the AIA 2030 Commitment Data Set MODELED projects, and the number of the right below the circle is the average % pEUI Reduction for the AIA 2030 Commitment Data Set NOT MODELED projects. The number displayed in the circle is the % difference. (% Difference = Average % pEUI Reduction for MODELED projects - Average % pEUI Reduction for MODELED projects.)

 

It should be noted that the % difference calculation has a number of flaws and is provided to demonstrate the potential to increase the % pEUI reduction if projects pursue energy modeling.  First, it makes the assumption that the NOT MODELED projects achieve the % pEUI Reduction that is associated with the Design Energy Code selection. Second, because of this assumption there is a difference in rigor between the two numbers. The modeled projects incorporate the rigor of the energy model simulation, while the not modeled projects are just based on a design energy code selection.

 

  • What Tool?: Displays the energy modeling tool that was used and the number of projects that it was used for within the AIA 2030 Commitment Data Set. Only the energy modeling tools that have at least one project associated with them will be displayed. For reference,“not modeled” projects are displayed along the top row, which provides feedback on the number of projects within the portfolio that are not pursuing energy modeling—ideally a low number. The chart can be exported in image or spreadsheet form.

 

  • Who?: Displays who is doing the energy modeling on projects, and the number of projects within the portfolio (influenced by filter selections) for which they are doing energy modeling. The chart can be exported in image or spreadsheet form.

 

  • How Many Hours?: Displays the ranges of hours associated with the energy model for the AIA 2030 Commitment Data Set modeled projects. Each bin (range of hours) displays the number of projects that reported the energy modeling effort to be within that range.  The chart can be exported in image or spreadsheet form.

 

Reported Projects Report

A set of four bar charts that dig deeper into the landscape of what use types, % pEUI reduction range, project phase, and global location are associated with projects. 

 

Note: Multiple project views for the same project are not displayed. For example, if a project has been advanced and is reported on for multiple years, therefore having multiple project views, and if Years = All, then the most recent “Submitted Year” and associated use type, % pEUI reduction, project phase and global location, if applicable, are what will be displayed.  

 

  • Use Type: Displays the number of projects for each use type for the AIA 2030 Commitment Data Set. Only the use types that have at least one project associated with them will be displayed. The number of projects displayed in the graph are influenced by the filter selections (upper left). If a project has more than one use type associated with it, then the project is associated with the use type with the largest area. The chart can be exported in image or spreadsheet form.

 

  • % pEUI Reduction: Displays a set of % pEUI reduction ranges (bins) for the AIA 2030 Commitment Data Set. Each bin displays the number of projects that fall that within that % pEUI reduction range. The number of projects displayed in the graph are influenced by the filter selections (upper left). The chart can be exported in image or spreadsheet form.

 

  • Project Phase: Displays the number of projects in the AIA 2030 Commitment Data Set for each of the Project Phase options. The first five represent the design and construction phases, and the last two express if the design project is moving forward to an “occupied” phase or if the project has been “closed” and is not continuing forward. The number of projects displayed in the graph are influenced by the filter selections (upper left). The chart can be exported in image or spreadsheet form.

 

  • Global Location: Displays the number of projects in the AIA 2030 Commitment Data Set for each of the global locations, which are geographic regions. The number of projects displayed in the graph are influenced by the filter selections (upper left). The chart can be exported in image or spreadsheet form. 

Print and Export Charts

Each chart has a menu icon in the upper right that provides the following options when selected:

  • Print Chart

  • Download PNG image

  • Download JPEG image

  • Download PDF document

  • Download SVG vector image

  • Download CSV

  • Download XLS

Research Screen

 

The Research screen allows investigation of AIA 2030 Commitment data set for whole buildings, utilizing a number of filters to visualize the results in the scatter plot. Firms can “slice and dice” the data set in different ways using multi-faceted queries, and review the results in the summary table. In addition, a firm’s portfolio projects are highlighted in the scatter plot, so that firms can see where their projects are within the landscape of the data set they are examining, and how they compare to projects of a similar type. This video provides a short introduction.

 
 

Basics

Workspace Layout

The Research screen features:

  • Project Counter: A counter on the upper right displaying the number of active projects displayed in the scatter plot and the overall number of whole building projects in the data set.

  • Scatter plot: The overall data set displayed in the scatter plot.

  • Filters: A set of filters on the left side.

  • Data Set Summary Table: A set of metrics based on the filtered data set selected.

Project Counter

The counter displays two numbers. The first number (green) is the number of whole building projects in the current data set. With additional filter selections, this number will increase and decrease. The second number (blue) is the number of whole building projects in the DDx that contain values for at least one of the filters.

 

 

Data Privacy

The data privacy measures that are incorporated into the DDx Research screen include:

  • Firms can only see their projects highlighted (displayed in light blue and purple) when logged into the firm's account.

  • When a user makes filter selections and the building count for the filtered data set goes below 10, the scatter plot will not display the results.

  • No Project Names or Project IDs are displayed associated with individual projects

  • Within the scatter plot, when hovering on a project that IS NOT in a firm’s portfolio, only the GSF, pEUI, and % pEUI Reduction are displayed. 

  • Only the scatter plot image can be exported, not the overall data set.

Filters

The research filters (left navigation column) refine the data set that is displayed in the scatter plot.  

Making a Filter Selection

There are three easy steps for making a filter selection:

1.  Click on the desired filter (e.g., Gross Floor Area)

The menu will appear to the right displaying either a set of selections or a slider bar with minimum and maximum fields.

 

2.  Make filter selections

Enter a minimum and/or maximum range, use the slider bar to set the values or make selections from a menu of options depending on the filter menu type. In the example shown below, entering values in the minimum and maximum fields adjusts the slider bar, and since values are selected, the checkbox next to Gross Floor Area is not marked. 

 

 

 

3.  Close the menu

Selecting the “X” or hitting “Enter” closes the filter menu and applies the selections to the data set. The counter, scatter plot and summary table are updated, and then other filters can be selected as desired.

 

Filter Options

This table outlines the filter categories, sub-categories, the type of filter selection, and the filter selection options. 

Note:  All projects do not contain values for all of the filters. Therefore, when selecting a filter type (even when selecting all the options), the number of projects in the data set selected may decrease.

Filter Category

Filter

Dialog Box Type

Description of Options

X & Y Axis Controls

Gross Floor Area [sf]

Range (slider)

0k to 45,000k

 

pEUI [kBtu/sf/yr]

Range (slider)

0 to 2,500

 

% pEUI Reduction [%]

Range (slider)

0 to 100 default (negative percentages can be entered as well as percentages > 100)

DATA SET

Project Category

Menu

Non-Residential, Residential

 

Reporting Year

Menu

Set of Years

BUILDING BASICS

Use Types

Menu

AIA 2030 Commitment Set

 

Target Certification

Menu

Set of Green Building Certifications

 

Project Phase

Menu

Concept, Schematic Design, Design Development, Construction Documents, Construction Administration, Design Closeout Final

LOCATION

Global Region

Menu

Eastern Europe and Eurasia, Africa, Central and South America, Asia, Europe, Middle East, North America

 

Country

Menu

Overall data set countries included

 

Climate Zone (US)

Menu

 

 

State/Province

Menu

US States; Canada, India and China provinces

BUILDING ENVELOPE

Window to Wall Ratio

Range (slider)

0-100

 

Window/Glazing Type

Menu

(9) options ranging from single pane to triple pane with low-E and inert gas filled

ENERGY PERFORMANCE

Energy Modeler

Menu

Architecture Team, Design Engineer, Modeling Consultant, Other

 

Energy Model Tool

Menu

Set of tools recommended by the Working Group

 

Energy Use Data Collected

Menu

Collected or Not Collected

LIGHTING

Lighting Power Density

Range (slider)

Overall data set range

 

Lighting Controls

Menu

Occupancy Sensors and Daylight Dimming Sensors

BUILDING SYSTEMS

Heating

Menu

Boiler-Mech Draft, Boiler-Other draft, District, None

 

Cooling

Menu

(6) Chiller types + District

 

Ventilation

Menu

Mechanical, Natural, Mixed-Mode and Night Flushing

 

Renewables

Menu

PV, Wind Turbine, Solar Thermal, None

 

Export

Selecting the icon on the upper right of the scatter plot displays an export menu, which allows the current chart to be printed or exported as a PNG, JPEG or SVG image, or in PDF format. 

 
 

Scatter Plot

The scatter plot is an interactive graph that allows exploration of each firm's portfolio and the overall data set in interesting ways. Each dot in the scatter plot represents a project. Dots are displayed in four different colors, which are defined in the legend at the bottom of the scatter plot. 

  • Blue = 2030 Commitment Data set Modeled

  • Gray = 2030 Commitment Data set NOT Modeled

  • Light Blue = Firm’s Projects that are Modeled

  • Purple = Firm’s Projects that are NOT Modeled

The different sets of projects can be turned on or off by selecting them directly in the legend. On the upper right is a counter which displays the number of buildings within the data set based on any filter selections (the number on the left), and the overall number of projects within the data set (number on the right).  As filter selections are made, the number on the left will update.

X- Axis Default = Gross Square Feet [sf]

Y- Axis Default = pEUI (predicted energy use intensity) [kBtu/sf/yr]

The scatter plot display can be changed in a few ways:

  1. Make a Filter Selection: After a selection is made or a min/max is defined the scatter plot will update automatically.

  2. Change the Y- Axis: View the % pEUI Reduction for the data set versus the pEUI.

  3. Zoom: Draw a selection window in the scatter plot to zoom into a view in the data set. Note that the counter will not update to this “zoomed in selection”, and the button on the upper right can be selected to get back to the previous view. This short video details how to use the “zoom” feature within the scatter plot. 

  4. Select Project Types in the Legend: Selecting a project type in the legend will hide or show that project type on the scatter plot.

 

Project Information

In the scatter plot each dot represents a project. A firm’s projects are only highlighted in different colors (displayed in light blue for modeled and purple for not modeled) when logged into that firm's account. For additional security and data privacy, when a user makes filter selections that sends the building count below 10, the scatter plot will not display the results.

 

Within the scatter plot, when a user hovers on a project that IS NOT in their firm’s portfolio, they will only see the shared field information (GSF and pEUI). No project numbers or names are displayed. 

 

When a user hovers on a project that IS in their firm’s portfolio, they will see the following information displayed:

  • Project Hyperlink

  • Project Name

  • Project ID

  • Project Location

  • Project Phase

  • pEUI 

  • % pEUI Reduction

  • Gross Floor Area (sf)

Data Set Summary

The summary table displays rolled up totals and weighted calculations for the “Combined” current data set (all of the projects based on the filter selections), as well as for each of the four project types that are displayed in the scatter plot legend. As filter selections are made, this table updates when the scatter plot updates.

Gross Floor Area Weighted pEUI (kBtu/sf/yr)

A calculation that multiplies each project’s gross floor area times its pEUI value, adds them together, and then divides the set by the sum of the gross floor area for all the projects in the current data set.  At a basic level, the gross floor area is being weighted across the set of projects. 

Let’s go through a simple example with three projects in our active data set with the following GSF and pEUI values. (Remember that a minimum of 10 projects are actually needed to be displayed). 

 

 

GSF (sf)

pEUI (kBtu/sf/yr)

Project 1

1,000,000

142

Project 2

20,000

15

Project 3

100,000

35

Project 2 and Project 3 are strong performers and have low pEUI values, while Project 1 is quite a bit higher. 

If we calculated the average pEUI across the three projects in the last column, the result is 64.

However, if we take into account the size (Gross Floor Area) for each project in the formula outlined below, the result is 130. The pEUI value is significantly higher, because our poorest performer, Project 1, has the largest Gross Floor Area of any project. It is “weighting” the calculation, so that the pEUI value increases and is closer to the Project 1 pEUI value (Gross Floor Area Weighted pEUI = sum of projects (GSF * pEUI) / sum of projects (GSF)).

Gross Floor Area Weighted % pEUI Reduction

This calculation multiplies each project’s gross floor area times its % pEUI Reduction value, adds them together, and then divides the set by the sum of the gross floor area for all the projects in the current data set. The calculation approach is the same as Gross Floor Area Weighted pEUI (Gross Floor Area Weighted pEUI = sum of projects (GSF * % pEUI Reduction) / sum of projects (GSF)).

Gross Floor Area (sf)

The sum of the square footage (sf) for all of the projects that are in the current data set. The values displayed in the table are compressed to display either 1,000s of square feet (k) or millions of square feet (M).

No. of Projects

The total number of whole building projects included in the current data set. The value displayed for combined will match the number of buildings shown on the counter above, and if the values for the four sub-categories below were added together, they would return the same value.

Export

Selecting the icon in on the far right of the Current Data Set Summary header allows export of the current table in either XLS or CSV.

 

 

Export 

The DDx provides the ability to select one of five current options to EXPORT single, multiple or ALL projects in a firm's portfolio for select or ALL input fields in either CSV or XLS format. The feature can be accessed from the Portfolio screen, which displays a dialog box to select an "Export Option", and then the "Export Type".  

Possible Export Options:

  1. Export ALL projects for ALL General Input Screens.

  2. Export ALL projects for ALL Project Table Columns.

  3. Export Selected projects for Selected Columns.

  4. Export ALL projects for ALL General/Envelope/HVAC Screens.

  5. Export Selected projects for ALL General/Envelope/HVAC Screens.

Notes:  

  • The Export options for "Selected Projects" will appear grey and cannot be selected if no projects had previously been selected (checkbox) on the Portfolio table.

  • General Input refers to the main input screen for all three project categories (Non-Residential, Residential, and Interior Only).

  • General/Envelope/HVAC Screens refers to the General Input screen as well as the other Detailed Input screens for either Non-Residential or Residential projects.