Standard Reports will opens the Standard Reports screen, which includes:
TREAT offers a wide variety of reports to assist you in the modeling process and demonstrate the improvement benefits to the building owner. Reports may be accessed from the Index Panel or the main menu, under Reports. Most of the reports become available only after a project is opened and has calculated results.
Select the checkbox next to the name of the report to indicate that you would like to view it. Depending on the report that you select, you may be asked for some additional information that is required for the report. Note that your inputs on this screen are not saved with the project.
The Change Selection button on the Reports window allows the user to change the package or analysis period for which the report is created. Click the View button if you would like to view the report. Click the Print button to print the report without viewing. You may also print the report directly from the on-screen report (also called the print preview window), using the buttons at the top of the screen.
Reports may be saved to a file using the Save shortcut on the print preview toolbar. Any TREAT user may open the file with the Open shortcut on the print preview window.
Base Load and Occupant Lifestyle Savings reports may be printed without headers. Click Reports > Use paper with pre-printed headers on the main menu and check the name of the report for which you would like to use this option.
The Fuel Bill Release report prints a letter to the utility company requesting that they release the bills for a specified address.
Building Description shows all the inputs made on the Building Model screens.
The Design Heating and Cooling Load report presents results of the load sizing calculations. TREAT load sizing has been tested in Minimize Calculation Time mode and results were compared to Manual J. TREAT heating and cooling loads proved to be slightly more conservative. Please use professional judgment in applying the results to sizing heating and cooling systems.
The Model Energy Report presents two pie charts for the selected package or the Base Building:
This report is available for any calculated package or the Base Building.
The Base Load Report provides information on energy consumption by appliances, domestic hot water and lighting in the selected building model. This report is available for models with calculated results. If the model is compared to more than one analysis period, you will be asked to select a single analysis period for inclusion in the report.
The Occupant Lifestyle Savings report contains information from Lifestyle Savings screen. This report is made up of two parts – one part summarizes possible savings, the other part shows savings accepted by the home-owner. The main purpose of the report is to educate homeowners about potential of energy conservation behaviors.
The Model to Actual Comparison of Base Usage table shows the overall non-HVAC energy consumption of each fuel in the selected model and billing analysis period (if any). The percent difference row indicates how well the model base load was calibrated against billing data.
The Base Load Report gives a detailed report on base load energy consumption. The items in this table are sorted by total annual cost of consumed fuel. The top nine energy consumers are shown individually, and the rest of the items are aggregated and presented in a single Other category.
The Percentage Improvement report compares annual energy savings of the selected packages with the overall energy usage of the Base Building.
The Visual Inspection and Measurements reports display the inputs made on the corresponding screens of Building Inspection section.
The Visual Inspection / Measurements Forms report prints the requested number of forms for on-site data collection. The forms closely resemble the Visual Inspection and Measurements screens.
The Improvement Packages report displays the calculation results presented on the Package Wizard screen for the packages selected by the user. The report includes the list of all non-energy benefits of improvements in each package.
The Workscopes report contains the list of the work scopes for the improvements in the selected package.
The Normalized Model to Billing Comparison report presents tabulated energy consumption of each fuel for the model and the corresponding billing analysis period. The billing period fuel usage is calculated using the slope and reference temperature from the billing analysis and thirty-year average weather data. The report is available for the analysis periods that are compared to a Base Building or a package.
Investment Guidelines for Heating provides an estimate of the cost-effective investment based on the billing analysis slope, reference temperature, cost of heating fuel, target payback and several other criteria. The report is presented for any billing analysis period for which calculations were performed.
The Heating Energy Scorecard presents a bar chart comparison of the overall annual per square foot energy usage of your building and energy usage of typical new and existing homes.
The Normalized Annual Billing Savings Tracking report compares the energy usage of the two selected analysis periods. For each period it presents stacked bars for each fuel, providing a breakdown for heating, cooling and base load. Heating and cooling consumption is calculated based on the heating and cooling slope for the period and the thirty-year average weather data.
The Actual Billing to Model Comparison report displays side by side the average daily fuel usage from each utility bill included in the analysis period and the calculated model usage for the same period. The report is available only for the fuels with the single set of billing data, not for the fuels with multiple individually metered spaces. The actual weather conditions during the billing period and the calculated model slope are used to generate the model usage data.
The Customer Information and Mail Merge report allows using the customer data entered in TREAT to generate a customer list in the comma-delimited text file format. This file may be used for printing letter headings, mailing labels and for other administrative and marketing activities.
The Data Collection Forms report prints the forms that should be used for data collection during site visits. The forms very closely resemble the input screens of the Building Model section. Enter the estimated number of spaces in the building, which allows TREAT to evaluate the expected number of walls, windows and lighting in the project and allow enough space on the forms.
TREAT has included a Business Reports module that generates any number of customized documents that help you run your business more efficiently. It merges the project data into a user-defined template, producing a customized document ready for inclusion in your package to the customer. The Templates are freely and easily customizable with any editor, such as WordPad, that can process .RTF (Rich Text Format) documents.
Steps to Produce a Business Report:

This feature allows the user to view or print a report showing the recommended investment for a package that has valid model results. Energy factor shown in the report is equal to heating slope normalized for HDDbase65.
Investment factor is determined based on current Weatherization Program requirements and the number of units in the building. If the base building is compared to an analysis period with valid calculation results, then the billing heating slope is used to calculate recommended investment, otherwise model slope is used.
Custom Reports are accessible from the main menu. They are available only if a Registration Password that enables them has been entered during the TREAT registration process.
TREAT offers two customized reports for NY Home Performance program. These reports may be accessed by selecting Custom Reports > NY Home Performance on the main menu.
The Home Performance Report may be used to present the modeling results to the building owner. Its purpose is to demonstrate the energy, health and safety benefits of up to three suggested packages for which modeling calculations were performed. The report contains educational information on the different types of improvements and a summarized description of the Base Building and proposed measures. The total cost, energy savings, payback and SIR of each package is shown to illustrate the feasibility of the improvements.
The Workscope Upload report allows the user to save the information for a single selected package to two files that conform to NYSERDA reporting requirements and may be uploaded to a NYSERDA database using an exporting tool that is shipped separately from TREAT. The export files are named [ProjectName_PackageName.txt] and [ProjectName_PackageName.xml] and are saved to the NYSERDAReporting folder located in the TREAT root directory.
You may export any package that has calculation results for all the included improvements.
If you run the report several times for the same project, then the later file will overwrite the earlier file. Only one file per project may be stored. You may create files for multiple projects without overwriting the information.
TREAT allows saving information for the selected package to an XML file that may be uploaded to the TREATtracker online database. This feature may be accessed by selecting Custom Reports > TREATtracker > XML Package Export from the main menu.
The Export button on the Export Wizard window is enabled after you select a package with calculated package and improvement savings. If the Export Wizard indicates that not all of the required calculations were performed for the package that you want to upload, run the calculations for the package as follows:
The package data is saved to TREATtracker folder in the TREAT root directory. The name of the file is {Your Project Name_Your Package Name_Your Package Status]. The name of the project is entered on the TREAT Projects screen when the project is created. Package name and status are entered on the Package Wizard screen.
The file generated by the Export Wizard will overwrite any existing files with the same name (for the same project and package). However, you may create files for other packages and projects without overwriting information that was previously extracted.
CSV Package Export - This utility allows TREAT users to export fuel usage information for selected package to a text file in comma separated format (.csv). The file may be imported into a spreadsheet program for additional calculations or into word processor for generating custom reports. The selected package must have calculated results for the entire package and each included improvement. The generated file will overwrite any existing files with the same name (for the same project and package). However, you may create files for other packages and projects without overwriting information that was previously extracted.
The file contains information that is not available in standard TREAT reports, such as energy consumption broken down by end use and by fuel.
The energy consumption for each improvement in the file is shown twice. Interacted improvement fuel energy usage is shown in the Improvements in Package section. This usage is also shown on the Package Wizard screen. Standalone improvement fuel usage is shown in the Individual Improvements section. This usage is also presented on the Improvements screen. Interacted and non-interacted usage and savings may or may not be equal, depending on the specific project.
Double-click the "csv" file to open it in Microsoft Excel. You may also open the file in Word. To improve the file appearance in Word you may select an individual section of the file (for example, the rows starting with Building Address and ending with Zip) and then select Table >Insert Table to replace commas with table grid.
Sample File
BUILDING ADDRESS
| Street Address | 123 Main Street |
| Apartment Number | |
| City | Buffalo |
| State | NY |
| Zip | 11111 |
CUSTOMER
| Name | Bob Jones |
| Street Address | 5432 Salt Spring Road |
| Suite Number | |
| City | Buffalo |
| State | NY |
| Zip | |
| Phone | (555) 555-1414 |
USER
| First Name | |
| Last Name | |
| Company Name | Your company name |
FINANCIAL DATA
| Inflation | 3.00% |
| Loan Interest | 8.00% |
| Loan Term | 30 |
| Bank Rate | 6.00% |
EXISTING BUILDING
| Heated Area SqFt | 1200 |
| Heated Volume Cubic feet | 9600 |
| Total Area SqFt | 3600 |
| Heating Slope Btu/ft2-HDD | 18.32 |
EXISTING FUEL USAGE
| Fuel Name | Natural gas | Electricity |
| Energy Unit | Therm | kWh |
| Unit Cost | 1 | 0.11 |
| Annual Heating Btu | 124573029 | 0 |
| Annual Cooling Btu | 0 | 0 |
| Annual Lighting Btu | 0 | 5380042 |
| Annual Hot Water Btu | 40643744 | 0 |
| Annual Appliance Btu | 0 | 16705152 |
| Annual Other Btu | 0 | 0 |
PACKAGE DESCRIPTION
| Package Name | Insulation & Air Sealing Measures Only |
| Package Cost | 3458.00 |
| Annual Dollar Savings | 498 |
| Annual non-electric savings MMBtu | 50 |
| Annual electricity savings kWh | 0 |
| SIR | 2.86 |
| Cash Flow $/year | 194 |
FUEL USAGE FOR PACKAGE Insulation & Air Sealing Measures Only
| Fuel Name | Natural gas | Electricity |
| Energy Unit | Therm | kWh |
| Unit Cost | 1 | 0.11 |
| Annual Heating Btu | 74725475 | 0 |
| Annual Cooling Btu | 0 | 0 |
| Annual Lighting Btu | 0 | 5380042 |
| Annual Hot Water Btu | 40643744 | 0 |
| Annual Appliance Btu | 0 | 16705152 |
| Annual Other Btu | 0 | 0 |
| Unit Savings | 498 | 0 |
| Dollar Savings | 498 | 0 |
IMPROVEMENTS IN PACKAGE Insulation & Air Sealing Measures Only
| Improvement Name | Dense Pack All Exterior Walls | Loose fill Cellulose: Bring Attic to R47 | Targeted Air Sealing & Benefits of Dense Pack |
| ImprovementID | 619 | 621 | 620 |
| Non Energy Benefits | Improve comfort increase value of building. |
Improve comfort increase value of building. |
Reduce drafts. |
| Improvement Cost | 1998.00 | 960.00 | 500.00 |
| Annual Dollar Savings | 231 | 54 | 213 |
| Annual non-electric savings MMBtu | 23 | 5 | 21 |
| Annual electricity savings kWh | 0 | 0 | 0 |
| SIR | 2.71 | 1.32 | 6.40 |
IMPROVEMENT FUEL USAGE FOR Dense Pack All Exterior Walls
| Fuel Name | Natural gas | Electricity |
| Energy Unit | Therm | kWh |
| Unit Cost | 1 | 0.11 |
| Annual Heating Btu | 101467070 | 0 |
| Annual Cooling Btu | 0 | 0 |
| Annual Lighting Btu | 0 | 5380042 |
| Annual Hot Water Btu | 40643744 | 0 |
| Annual Appliance Btu | 0 | 16705152 |
| Annual Other Btu | 0 | 0 |
| Unit Savings | 231 | 0 |
| Dollar Savings | 231 | 0 |
IMPROVEMENT FUEL USAGE FOR Loose fill Cellulose: Bring Attic to R47
| Fuel Name | Natural gas | Electricity |
| Energy Unit | Therm | kWh |
| Unit Cost | 1 | 0.11 |
| Annual Heating Btu | 119166911 | 0 |
| Annual Cooling Btu | 0 | 0 |
| Annual Lighting Btu | 0 | 5380042 |
| Annual Hot Water Btu | 40643744 | 0 |
| Annual Appliance Btu | 0 | 16705152 |
| Annual Other Btu | 0 | 0 |
| Unit Savings | 54 | 0 |
| Dollar Savings | 54 | 0 |
IMPROVEMENT FUEL USAGE FOR Targeted Air Sealing & Benefits of Dense Pack
| Fuel Name | Natural gas | Electricity |
| Energy Unit | Therm | kWh |
| Unit Cost | 1 | 0.11 |
| Annual Heating Btu | 103237552 | 0 |
| Annual Cooling Btu | 0 | 0 |
| Annual Lighting Btu | 0 | 5380042 |
| Annual Hot Water Btu | 40643744 | 0 |
| Annual Appliance Btu | 0 | 16705152 |
| Annual Other Btu | 0 | 0 |
| Unit Savings | 213 | 0 |
| Dollar Savings | 213 | 0 |
INDIVIDUAL IMPROVEMENTS
| Improvement Name | Dense Pack All Exterior Walls | Loose fill Cellulose: Bring Attic to R47 | Targeted Air Sealing & Benefits of Dense Pack |
| ImprovementID | 619 | 621 | 620 |
| Non Energy Benefits | Improve comfort increase value of building. |
Improve comfort increase value of building. |
Reduce drafts. |
| Improvement Cost | 1998.00 | 960.00 | 500.00 |
| Annual Dollar Savings | 231 | 54 | 213 |
| Annual non-electric savings MMBtu | 23 | 5 | 21 |
| Annual electricity savings kWh | 0 | 0 | 0 |
| SIR | 2.71 | 1.32 | 6.40 |
IMPROVEMENT FUEL USAGE FOR Dense Pack All Exterior Walls
| Fuel Name | Natural gas | Electricity |
| Energy Unit | Therm | kWh |
| Unit Cost | 1 | 0.11 |
| Annual Heating Btu | 101455682 | 0 |
| Annual Cooling Btu | 0 | 0 |
| Annual Lighting Btu | 0 | 5380042 |
| Annual Hot Water Btu | 40643744 | 0 |
| Annual Appliance Btu | 0 | 16705152 |
| Annual Other Btu | 0 | 0 |
| Unit Savings | 231 | 0 |
| Dollar Savings | 231 | 0 |
IMPROVEMENT FUEL USAGE FOR Loose fill Cellulose: Bring Attic to R47
| Fuel Name | Natural gas | Electricity |
| Energy Unit | Therm | kWh |
| Unit Cost | 1 | 0.11 |
| Annual Heating Btu | 119164247 | 0 |
| Annual Cooling Btu | 0 | 0 |
| Annual Lighting Btu | 0 | 5380042 |
| Annual Hot Water Btu | 40643744 | 0 |
| Annual Appliance Btu | 0 | 16705152 |
| Annual Other Btu | 0 | 0 |
| Unit Savings | 54 | 0 |
| Dollar Savings | 54 | 0 |
IMPROVEMENT FUEL USAGE FOR Targeted Air Sealing & Benefits of Dense Pack
| Fuel Name | Natural gas | Electricity |
| Energy Unit | Therm | kWh |
| Unit Cost | 1 | 0.11 |
| Annual Heating Btu | 103227037 | 0 |
| Annual Cooling Btu | 0 | 0 |
| Annual Lighting Btu | 0 | 5380042 |
| Annual Hot Water Btu | 40643744 | 0 |
| Annual Appliance Btu | 0 | 16705152 |
| Annual Other Btu | 0 | 0 |
| Unit Savings | 213 | 0 |
| Dollar Savings | 213 | 0 |
Use Paper with Pre-printed Header allows the use of paper with a company logo for two of the reports. If Low Cost No Cost Report or Baseload Report is checked, the header will not be printed on that report. Any design that is preprinted in the same place on the paper will appear in place of the header on the report.