Upload Databases

Direct upload from Scenario Editor

Conversion and Storage Technologies

While editing a scenario, single items can be uploaded to My User Database directly from the scenario editor (i.e., Setup), by ticking the box ‘Save the technology for future use?’.

Energy Demand Profiles

In this case, the process is streamlined.

1. In the excel template, enter “profile names” in Sheet 1,

2. In Sheet 2, add the corresponding profile under the columns with the same column name as in Sheet 1.

Use demand profiles from My User Database

To use the data, click on “Select Saved”, when adding a new Demands in step 4.

Upload from Database Center

To upload data to your databases, you first have to prepare your data with the correct format. Different parameters can be entered depending on the type of data you wish to upload. Finally, note that the databases that you are allowed to modify depend on the roles and permissions within your organization.

Conversion and Storage Technologies

1. Select the database (My User Database or Organization Database) you wish to replace/add data for.

2. Select the type of data (Energy Demands, On-site Resources or the category of Technology).

3. As prompted, drop or click to select your file and then press upload.

By default, any data you upload will be "added" to the existing database. If you want to add new data without replacing the current content, ensure the 'Append existing data' option remains checked. If you prefer to replace the entire database with the new data, uncheck the "Append to existing data" option. Please note that this will overwrite the existing database entirely.

Energy Carriers Naming Conventions

Energy Carriers (EC) have to follow the exact nomenclature given in the table below.

Nevertheless, after adding a specific technology from the scenario editor, the Energy Carriers can be changed to any other ECs that are available in the respective scenario.

Energy Demands: Usage and Naming Convention

To upload Energy Demands profiles, you will need to fill in an excel file with two sheets. There are currently two possible cases, depending whether you are uploading to My User Database or to your Organization Database.

Upload to Organization Database

This method is preferred for batch upload.

1. In the excel template, enter information about each profile in Sheet 1, including the corresponding Building Use, the Demand Type, the Building Age or Standard and the Specific Energy Demand. Please adhere to the Naming Convention. The Specific Energy Demand [kWh/m2/a] for each combination of Building Use, Demand Type, the Building Age or Standard enables users to scale the profiles according to the requirements of each scenario via the scenario editor.

2. In Sheet 2, add the corresponding profiles under the columns with the same column name as in Sheet 1, normalized to 1 kWh. Ensure sure the naming in Row 1 of Sheet 2 matches the naming in column A of Sheet 1.

Naming Convention

You can upload your demands under one of the four Demand Types listed below. Please use the following nomenclature:

Building Use type should be one of the following types:

Finally, the Building Age or Standard should use the following nomenclature:

Use demand profiles from My User Database

To use your profile, you will have to click on “Generate Profile” when adding a new Demand in step 4 and further click on your Organization Database (in this example, “Sympheny database”):

Currency

The cost database is maintained in CHF.

Through the Scenario editor

When saving a technology to the database while being on another currency (e.g. EUR), the data is converted to CHF with the exchange rate considered in the scenario. Should the database be used again in the future, it will be converted again from CHF to the current EUR value given the exchange rate of the scenario.

Example:

Working with EUR and an exchange rate of 1.1 (1 CHF = 1.1 EUR).

You save a technology from the Scenario editor with 1’100 EUR.

In the database, this technology is saved as 1’100 EUR * (1/1.1) CHF/EUR = 1’000 CHF.

In a later scenario, with this time an exchange rate of 1.2 (1 CHF = 1.2 EUR), this technology, when selected from the database, will be entered with 1’000 CHF * 1.2 = 1’200 EUR.

Through the Upload from Database center

When uploading data through the excel upload, the data are in CHF.

Templates

Here you can download the templates for the upload:

Updated: 04/11/2024

Conversion Technologies Template.xlsx

Storage Technologies

Updated: 04/11/2024

Storage Technologies Template.xlsx

Network Technologies

Updated: 04/11/2024

Network Technologies Template.xlsx

Energy Demands

My User Database

Updated: 21/08/2024

Demands UserDB Template.xlsx

Organization Database

Updated: 21/08/2024

Demands OrgDB Template.xlsx