Database Center¶

The Database Center gives you an overview of all your data. Saved data can be called from the scenario editor across all scenarios. Through the Database Center, you can also download databases or upload databases to the web app from other sources.

Overview of the databases¶

In the Sympheny Database Center (the database icon at the bottom left of your screen), you have access to up to two databases:

• My User Database: your own private database, available to you across all your scenarios. You can maintain this database directly.
• Organization Database: the database specific to your organization, named after your organization. Only accounts from your organization can access this data. See the roles and permissions table below.

Roles & permissions¶

The account type and license determine which rights are available to which users.

Download databases¶

Downloading your database is useful when you want an overview of all your data, or need to perform post-processing or make adjustments.

To download your data:

1. Navigate to the database and the type of data you want to download (for example, Energy Demands, On-site Resources, or a category of Technologies).
2. On the right side of your screen, click the Download button.
3. Scroll to the bottom of the page and click the download arrow.
4. Open the downloaded file in Excel.

Direct upload from Scenario Editor¶

Conversion and storage technologies (scenario editor)¶

While editing a scenario, you can upload single items to My User Database directly from the scenario editor (in Setup) by selecting 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.

Select a saved profile¶

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 Energy demand profiles 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 organization 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 upload templates 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 for My User Database (XLSX)

Last updated: 2024-11-04

Organization Database¶

Energy demands template for the Organization Database (XLSX)

Last updated: 2024-11-04