ANALYSE YOUR BUILDING DATA

From Display Documentation in English

(Difference between revisions)
Jump to: navigation, search
(Import and Export)
(Import and Export)
Line 29: Line 29:
We highly recommend:
We highly recommend:
-
- to always save your data in .csv format
+
* to always save your data in .csv format
-
 
+
* to use OpenOffice scalc (www.openoffice.org) as your spreadsheet manager
-
- to use OpenOffice scalc (www.openoffice.org) as your spreadsheet manager
+
* to have used Display enough to know it well (at least 20 buildings and 30 calculations entered)
-
 
+
* to contact the Display team in case of a problem
-
- to have used Display enough to know it well (at least 20 buildings and 30 calculations entered)
+
-
 
+
-
- to contact the Display team in case of a problem
+
Line 46: Line 43:
Please create two directories on your desktop:
Please create two directories on your desktop:
-
 
+
*a “save” directory,
-
- a “save” directory,
+
*a “work” directory.
-
 
+
-
- a “work” directory.
+
In the Import/Export section, just go to “Import Buildings Data”, click on “Spreadsheet for buildings data” and download/save the file in your “save” directory. Please copy this file to your “work” directory. Then, go to “Import Consumption Data” and download the file in your “save” directory. Please copy this file to your “work” directory.
In the Import/Export section, just go to “Import Buildings Data”, click on “Spreadsheet for buildings data” and download/save the file in your “save” directory. Please copy this file to your “work” directory. Then, go to “Import Consumption Data” and download the file in your “save” directory. Please copy this file to your “work” directory.

Revision as of 15:05, 29 October 2008

Within the DATA TREATMENT section of the calculation tool there are three options for the user: Local statistics, National Statistics and Import/Export.


Local and National statistics

The local statistics section allows you to compare your own buildings to each other. The National statistics section allows you to see where you fit in nationally. You can choose to see the performance of a specific building type for one year or compare the performance between two different years for the same building. In order to display the general distribution of classes and average ratios for the same year just choose the Reference year from the first drop-down menu shown on the page. Then you have to select the type of building. To compare between different years (which is the aim of Display®) choose a year of comparison. Please note that there is also an option ‘all types of buildings’ if you want to get an overall picture of your building stock. Finally, click on the SUBMIT button at the bottom of the page.

Image:Figure17.jpg
Figure 17:menu to compare the results between 2004 and 2006

A new page will be uploaded containing the results (tables) for the primary energy, the CO2 emissions and the water consumption for the building type (or all your buildings) and the year/s selected.

Image:Figure18.jpg
Figure 18: Example of CO2 emission comparison table for 2005/6

Under the comparison tables is an important link in red See the details for each building which opens a table in a separate window listing each of the buildings, their performance and the classes achieved in the reference year selected. For the local statistics there is additional data on the total Carbon emission for each building and the total by buildings type.
By clicking on the title of each of the columns, you are able to rank the results from biggest to smallest when you click once or visa versa when you click twice. Note that this option see the details for each buildings is not available for the national statisticssection.

Image:Figure19.jpg
Figure 19: Example of the link "see the details for each building" for Carbon results

Please note that when you make your selection for the statistics the fields marked with an asterisk are always required!

Import and Export

The Display calculation tool enables all participants to import data and to export them in a spreadsheet format. Importation enables you to make hundreds of calculations at once. Be careful! This function is very powerful but also potentially very dangerous for your data. These manipulations are made at your own risk. You can lose data if you do not use it properly. After having read this page, do not hesitate to contact the Display team if you have any questions.

We highly recommend:

  • to always save your data in .csv format
  • to use OpenOffice scalc (www.openoffice.org) as your spreadsheet manager
  • to have used Display enough to know it well (at least 20 buildings and 30 calculations entered)
  • to contact the Display team in case of a problem


The Import/Export system is divided into three parts:

  1. Import Buildings Data,
  2. Import Consumption Data,
  3. Export Data.

How to save your data first:

Please create two directories on your desktop:

  • a “save” directory,
  • a “work” directory.

In the Import/Export section, just go to “Import Buildings Data”, click on “Spreadsheet for buildings data” and download/save the file in your “save” directory. Please copy this file to your “work” directory. Then, go to “Import Consumption Data” and download the file in your “save” directory. Please copy this file to your “work” directory.

Personal tools