Reports


The reports workspace allows you to view and interact with dynamic graphs at the Firm and Program Level. 

Firm Level Report Set
The set of reports that use your firm's portfolio as the data set.

Program Level Report Set

The set of reports that use the overall AIA 2030 Commitment project set as the data set.  The report set contains two reports that are the same as the Firm Level Reports (Energy Modeling and Reported Projects), which allows you to view the same types of results for both data sets.
 


 

A short video introducing 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 LEVEL 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 

 

  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 each that the firm has contributed data



Dataset Filters:  Office Location, Reporting Status

 

  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 dropdown selection.  The bottom graph displays the selected bin of the initial variable choice, and then you can choose to highlight energy modeled projects or projects pursuing a green building rating


Dataset Filters:  Year, Office Location, Reporting Status

 

  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

 

  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 LEVEL   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
  Reporting Firms Displays the quantity of firms of different bin sizes that have reported project data to the program each year.

Dataset Filters:  None
  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

  Reporting Firms

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 dropdown lists that allow you to change and/or refine the dataset that you are working with, and the projects that are displayed in the reports.

Year

Similar to other workspaces you can change the years you are working with for the dataset. 

Default = All

Office Location

If your firm has multiple offices included on the Firm Accounts screen, this control allows you to easily select different offices.

Default = All

Reporting Status

Allows you to select if you want to include "Ready to Submit" projects in the results displayed or if you are just interested in the projects 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 you are able to print and/or export any of the charts 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, allowing you to tell the performance story in different ways. For example, it would take 26,717 acres of carbon sequestered annually to accomodate the emissions from the set of projects included in the analysis.  Explore and create your own interesting stories...


 


 

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.  When you hover over the bars the specific value for the year is 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, which is 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.  Imagine if you selected one of the bars on the top graph, and a breakdown of the projects that make up that bar appeared in the graph below.  That is what happens, but rather than select directly from the graph, you can choose one of the bars in the “Bin Dropdown” list, which is the second selection menu located between the two graphs.  In addition you can add another filter to highlight projects on the lower graph by selecting if you want to view “All Projects” or “Projects w/ Energy Models” or “Projects pursuing green building rating” from the third drop down list. 

Also review the view for how you can zoom on the bar chart if the outcome of your filter selections is still a significant number of projects displayed in the lower graph.

Filters, Filters, Filters


On the PREDICTED EUI Report you have the most filters available of any of the other reports.  There are four options of filters:

  • 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 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 you have 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?

The first of three Energy Modeling related bar charts that displays the energy modeling tool that was used and the number of projects that it was used for within your 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.  It would be beneficial to a firm to see this number 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) that they are doing energy modeling for. 

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


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 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 list of options aligns with the options that were included in the AIA 2030 Commitment spreadsheet tool.  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.  It is interesting to consider all three graphs, particularly as the program continues to grow and more firms, more projects, and more GSF become part of the data set.  What do you think?  What do we need to do as practice to keep trending upward as volume increases…
 

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 left most 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 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 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 you have 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?

The first of three Energy Modeling related bar charts that 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.  It would be beneficial to see this number 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) that they are doing energy modeling for. 

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 list of options aligns with the options that were included in the AIA 2030 Commitment spreadsheet tool.  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.  When selected a menu of the following options are provided

  • Print Chart
  • Download PNG image
  • Download JPEG image
  • Download PDF document
  • Download SVG vector image
  • Download CSV
  • Download XLS