Upload databases¶

Direct upload from Scenario Editor¶

Conversion and storage technologies¶

While editing a scenario, you can upload single items to My User Database directly from the scenario editor (in Setup) by checking Save the technology for future use?.

Energy demand profiles¶

This 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 names as in Sheet 1.

Use demand profiles from My User Database¶

To use the data, click Select Saved when adding a new demand in step 4.

Upload from Database Center¶

To upload data to your databases, first prepare your data in the correct format. The parameters available depend on the type of data you want to upload. The databases you're allowed to modify depend on your roles and permissions within your organization.

Conversion and storage technologies¶

1. Select the database (My User Database or Organization Database) you want to add or replace data for.
2. Select the type of data (Energy Demands, On-site Resources, or a category of Technology).
3. Drop or select your file, then click upload.

By default, uploaded data is added to the existing database. To add new data without replacing the current content, keep Append existing data checked. To replace the entire database with the new data, uncheck Append existing data — this overwrites the existing database entirely.

Energy carriers naming conventions¶

Energy carriers (EC) must follow the exact nomenclature given in the table below.

After adding a specific technology from the scenario editor, you can change the energy carriers to any other EC available in that scenario.

Energy demands: usage and naming convention¶

To upload energy demand profiles, fill in an Excel file with two sheets. There are currently two cases, depending on whether you're uploading to My User Database (see "Use demand profiles from My User Database" above) 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: Building Use, Demand Type, Building Age or Standard, and Specific Energy Demand. Follow the naming convention below. The Specific Energy Demand (kWh/m²/a) for each combination of Building Use, Demand Type, and Building Age or Standard lets you scale the profiles to each scenario's requirements via the scenario editor.
2. In Sheet 2, add the corresponding profiles under the columns with the same column names as in Sheet 1, normalized to 1 kWh. Make sure the naming in row 1 of Sheet 2 matches the naming in column A of Sheet 1.

Naming convention¶

Upload your demands under one of the four demand types listed below, using this nomenclature:

Building use type must be one of the following:

Building age or standard must use the following nomenclature:

Use demand profiles from My User Database¶

To use your profile, click Generate Profile when adding a new demand in step 4, then click your organization database (in this example, "Sympheny database"):

Currency¶

The cost database is maintained in CHF.

Through the scenario editor¶

When you save a technology to the database while working in another currency (for example, EUR), the data is converted to CHF using the exchange rate in the scenario. When that database entry is used again in the future, it's converted from CHF back to the current EUR value using the exchange rate of the new scenario.

For 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 a value of 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 an exchange rate of 1.2 (1 CHF = 1.2 EUR), this technology, when selected from the database, is entered as 1,000 CHF × 1.2 = 1,200 EUR.

Through the upload from Database Center¶

When you upload data through the Excel upload, the data is in CHF.

Templates¶

Download the templates for the upload here:

Conversion technologies¶

Conversion technologies template (XLSX)

Last updated: 2024-11-04

Storage technologies¶

Storage technologies template (XLSX)

Last updated: 2024-11-04

Network technologies¶

Network technologies template (XLSX)

Last updated: 2024-11-04

Energy demands¶

My User Database¶

Energy demands template — My User Database (XLSX)

Last updated: 2024-11-04

Organization Database¶

Energy demands template — Organization Database (XLSX)

Last updated: 2024-11-04