ANALYSE YOUR BUILDING DATA
From Display Documentation in English
Nan.j.cole (Talk | contribs) (→Building Statistics Poster) |
Nan.j.cole (Talk | contribs) (→Import Buildings Data) |
||
Line 76: | Line 76: | ||
It is obligatory to add the fields ‘Building Type,’ ‘Name of Building,’ and ‘Building Surfaces.' Please do not touch the columns “BUILDING ID” and “ORGANISATION ID”. You can update the data in the other columns if you wish. To add new buildings, all you have to do is to make new lines by entering the building name, the building surface and other data related to this building on the line. Please note that you can add dozens of lines if you need to. | It is obligatory to add the fields ‘Building Type,’ ‘Name of Building,’ and ‘Building Surfaces.' Please do not touch the columns “BUILDING ID” and “ORGANISATION ID”. You can update the data in the other columns if you wish. To add new buildings, all you have to do is to make new lines by entering the building name, the building surface and other data related to this building on the line. Please note that you can add dozens of lines if you need to. | ||
+ | |||
+ | [[Image:Screen Shot_Building Data Required.jpg]] | ||
Once the changes on this file are done, just save them and go back to the “Import Buildings Data” page. Click the “Browse” button to get the updated file from your '''“work” directory''' on your desktop. Then click on the “Save” button. | Once the changes on this file are done, just save them and go back to the “Import Buildings Data” page. Click the “Browse” button to get the updated file from your '''“work” directory''' on your desktop. Then click on the “Save” button. |
Revision as of 11:49, 23 August 2010
Within the DATA TREATMENT section of the calculation tool there are three options for the user: Local statistics, Building Statistics Poster, National Statistics and Import/Export.
Contents |
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.
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.
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.
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!
Building Statistics Poster
The “Building statistics poster” feature is for local authorities that have carried out technical improvements on their building stock and have the consumption data from many years.
But how?
This feature enables you to compare two different years by clicking on the option “see the details for each building.” If you click on the title “Difference,” it will arrange your results from largest to smallest and visa versa.
Once you have identified the buildings that you would like to show to the public, go to the “Building statistics poster” option and choose the building and the two years that you want to compare. Add information about your building on “What solutions have been implemented?” and also “Financial details (Investment, cost savings, Return On Investment (ROI), etc.)”.
Once completed you have an option to share your poster on the Display Website http://www.display-europe.org/cities/posters_en.php. We encourage you to do this as this will stimulate more people to be inspired by the work that is being carried out by Display participants. Your new poster is now available in pdf to print and proudly show to the public showing the multiple years of monitoring.
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. New users are strongly encouraged to input a few buildings before utilizing the import tool. After having read this page, do not hesitate to contact the Display team if you have any questions.
When using Open Office, 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.
From the Display Website:
The Import/Export system is divided into three parts:
- Import Buildings Data,
- Import Consumption Data,
- 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.
From now on you do not need to use your “save” directory any more. All changes need to be made on your “work” directory. In case you make any serious mistake, you will be able to recover your data from your “save” directory. Please follow these important steps every time you use the Import/Export function.
Import Buildings Data
This section is dedicated to the importation of all data related to buildings (building name, building type, building surface, etc). First of all, go to your “work” directory and open the “Spreadsheet” for buildings data ».
From the Open Office Program:
To open the file in Open Office, please select “Unicode UTF-8” for your characters and “Semicolon” as separator. Opening this file, you will see the up to date buildings data entered into Display.
It is obligatory to add the fields ‘Building Type,’ ‘Name of Building,’ and ‘Building Surfaces.' Please do not touch the columns “BUILDING ID” and “ORGANISATION ID”. You can update the data in the other columns if you wish. To add new buildings, all you have to do is to make new lines by entering the building name, the building surface and other data related to this building on the line. Please note that you can add dozens of lines if you need to.
Once the changes on this file are done, just save them and go back to the “Import Buildings Data” page. Click the “Browse” button to get the updated file from your “work” directory on your desktop. Then click on the “Save” button.
If the syntax of your file is not valid, the Display software will signal an error by giving the line number and the field where an error occurred. If the file is valid, the Display software will ask you for a confirmation. The data has not yet been entered into the calculation tool. The file has just been checked and uploaded. If you click on “No”, the imported file will be deleted. By clicking on “Yes”, the data will be entered into the system. Previous building data will be updated and new building data will be inserted.
You can go back to your buildings list in the Display software to see all the new data that has been added.
Import Consumption Data
This section is dedicated to the importation of all data related to building consumption (year of reference, water consumption, energy consumptions, etc). Please note that you can only enter building consumption for existing buildings in the Display software. First of all, go to your “work” directory and open the “Spreadsheet for consumptions”. From the Open Office Program:
To open the file in Open Office, please select “Unicode UTF-8” for your characters and “Semicolon” as separator. Opening this file, you will see the buildings data entered into Display up to now. See the above description for “Import Building Data.”
Please do not touch the columns “CONSUMPTION ID”, “ORGANISATION ID” and “CONTACT ID”. You can update the data in the other columns if you wish. To add new building consumption data, all you have to do is to insert new lines by entering the building name, the year of reference, the water consumption, the energy consumptions and other data related to this building on the line. Please note that you can add hundreds of lines if you need to. When you first start we advise to not add more than 50 at a time.
Be careful, The “BUILDING ID” column is very important. If you update already entered data, please do not touch it. If you add new data, you need to insert the building ID in this column. You will find this number in the “Spreadsheet for Buildings Data” you downloaded previously.
From the Display Website:
Once the changes on the Open Office file are done, just save them and go back to the “Import Consumptions Data” page. Click on the “Browse” button to get the updated file in your “work” directory on your desktop. Then click on the “Save” button.
If the syntax of your file is not valid, the Display software will inform you by giving the line number and the field where an error occurred. If the file is valid, the Display software will ask you for confirmation. The data has not yet been entered into the calculation tool. The file has just been checked and uploaded. If you click on “No”, the imported file will be deleted. By clicking on “Yes’“, all data will be entered into the system. Previous consumptions data will be updated and new consumptions data will be inserted.
In the Import/Export section, just go to “Import Consumption Data”, click on “Spreadsheet for Consumption Data” and download/save the file in your “save” directory. Please copy this file to your “work” directory.
You can go back to your posters list in the Display software to see all your new poster calculations.
Export Data
From this section, you can find:
- the “Spreadsheet for buildings data” usable in the data importation system,
- the “Spreadsheet for consumptions” usable in the data importation system,
- all your results with the Display software up to now.
The “Spreadsheet for data and calculations” option will enable you to download both the building and calculation data in one spreadsheet allowing you to analyse them for further reports and presentations in your organisation.