Energy Tools

This tool can automatically convert data from a time series of 15-minute values (for example, for power load profiles) to hourly, daily and monthly values. It also arranges the individual values of the time series in a matrix (15-minute values on individual days). The tool is available for regular years and for leap years.

↧ Download Excel tool for converting 15-minute values.
↧ Download the Excel tool for converting 15-minute values for leap years.

The tool is available in German and English.

Citation: te Heesen, Henrik (2020). Conversion of 15-minute values to hourly, daily and monthly values (Version: 23 Sep 2020) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

This tool can be used to automatically convert data from a time series with hourly values (for example for load profiles or weather data) to daily and monthly values. It also arranges the individual values of the time series in a matrix (hourly values on the individual days). The tool is available for regular years and for leap years.

↧ Download Excel tool for converting hourly values.
↧ Download the Excel tool for converting hourly values for leap years.

The tool is available in German and English.

Citation: te Heesen, Henrik (2020). Conversion of hourly values to daily and monthly values (Version: 23 Sep 2020) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

With the help of this tool, the direct radiation and the diffuse radiation can be determined based on hourly global radiation data in the horizontal plane using statistical distributions. The radiation information is used to simulate electricity yields of photovoltaic systems or solar thermal systems.

↧ Download Excel tool for modeling solar irradiance.

The tool is available in German. Collaboration on the tool by Kevin Kreitzer.

Citation: Kreizer, Kevin; te Heesen, Henrik (2021). Modeling of the solar irradiation (Version: 21 May 2021) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

This Excel tool enables a simplified yield simulation of photovoltaic systems. From weather data (horizontal direct and diffuse radiation or horizontal global radiation and ambient temperature) and location information, the power production of a photovoltaic system is calculated to the hour. If only global radiation information is available, this tool can automatically determine the proportions of direct and diffuse radiation from the global radiation. In addition, the corresponding tool for "Modeling of solar irradiation" can be used to calculate horizontal direct and diffuse irradiation.

Note: It should be noted that the irradiation data (global or direct/diffuse) must be specified in the UTC timestamp. If the data are in local time (with the change from winter time to summer time), these timestamps must be adjusted to UTC (winter time: local time - 1h = UTC; summertime: local time - 2h = UTC).

↧ Download Excel tool for yield simulation of photovoltaic systems.

The tool is available in English. Collaboration on the tool by Jonas Borger and Felix Hermesdorf.

Citation: Borger, Jonas; Hermesdorf, Felix; te Heesen, Henrik (2021). Photovoltaic yield simulation (Version: 14 Sep 2021) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

This Excel-Tool allows the design and evaluation of battery storage for a photovoltaic system under consideration of the power consumption. The yield profile and the current load curve can be stored individually. The battery storage can be varied in the charging capacity and charging power. Relevant energy key figures are output, especially for self-consumption and charging cycles.

↧ Download Excel-Tool PV system with battery storage.

The tool is available in German. Collaboration on the tool by Emanuel Altmeier.

Citation: Altmeier, Emanuel; te Heesen, Henrik (2024). Photovoltaic system with battery storage (Version: 13 November 2024) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

Update
13.11.2024 Error correction when checking the battery input parameters.
28.06.2024 Error correction when checking the battery input parameters. Addition to the calculation of the geometric mean of self-sufficiency and self-consumption on the results tab.

This Excel tool allows the design of a solar thermal system with a heat storage tank. The heat load profile of the building can be stored to optimize the solar thermal system with the storage tank. Note: The tool must run through several iteration steps due to the physical equations that are solved in the background, so calling up and running the tool is quite complex and may be of limited use to those not experienced in Excel.

↧ Download Excel-Tool Solar Thermal System with Heat Storage.

The tool is available in German. Collaboration on the tool by Benjamin Hasmann.

Citation: Hasmann, Benjamin; te Heesen, Henrik (2022). Solar thermal system with heat storage (Version: 22. June 2022) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

This calculation program is used for the design of heat storage. Depending on an (individual) heat demand profile and a yield profile (e.g., from a solar thermal system) the heat storage condition is calculated for each hour. The capacity of the heat accumulator can be varied.

↧ Download the Excel tool Heat accumulator design.

The tool is available in German. Collaboration on the tool by Emanuel Altmeier.

Citation: Altmeier, Emanuel; te Heesen, Henrik (2020). Design of a heat storage (Version: 23 Sep 2020) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

This Excel tool allows a simplified yield simulation of wind turbines. A power curve for a modern wind turbine is stored in the tool. By specifying turbine-specific parameters (hub height, rated power, etc.) and entering wind speed data, the wind speeds at hub height are determined, and the electricity yield is calculated at hourly intervals. The tool can be extended with its power characteristic data if required. The DWD and renewables.ninja provide wind speed data (see links below).

↧ Download Excel Tool for Wind Energy Yield Simulation.

The tool is available in German. Collaboration on the tool by Jeannine Riemer.

Citation: Riemer, Jeannine; te Heesen, Henrik (2024). Wind Energy Yield Simulation (Version: 20th January 2024) [Computer program]. Hochschule Trier. Online at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

Update
20.01.2024 Update of the power coefficient

From weather data, load profiles for electricity, heating, and domestic hot water for single and multi-family houses are synthesized by VDI 4655 (reference load profiles of residential buildings for electricity, heating, and domestic hot water). The time interval of the load profiles is 15 minutes.

↧ Download Excel tool for load synthesis according to VDI 4655 (Download via external server seafile.rlp.net of the state of Rhineland-Palatinate)

The tool is available in German.

Citation: te Heesen, Henrik (2020). Synthesis of power and heat profiles according to VDI 4655 (Version: 2 Nov 2020) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

Using the BDEW standard load profiles for electricity, this Excel tool can generate different electricity profiles for a calendar year at 15-minute intervals. In addition to the different consumer classes (households, commercial, etc.), the year-specific holidays are considered in the synthesis.

↧ Download Excel tool for electricity load profile synthesis (Download via external server seafile.rlp.net of the state of Rhineland-Palatinate)

The tool is available in German. Collaboration on the tool by Lukas Liesenklas.

Citation: Liesenklas, Lukas; te Heesen, Henrik (2023). Synthesis of standard electricity load profiles according to BDEW (Version: 1. Nov. 2023) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

---
Version history

07.07.2023. Bug fixing and function extension (among others correction of an error in the calculation of days, addition of the region "nationwide").
01.11.2023. Typography 

With the help of this tool, it is possible to synthesize hourly heat load profiles for households and different commercial categories based on the processing of standard gas load profiles of the BDEW. The input size is the outdoor temperatures for each hour of a year. In addition to the different consumer classes (households, businesses, etc.), the year-specific holidays are taken into account in the synthesis.

↧ Download Excel tool for heat load profile synthesis.

The tool is available in German. Contribution to the tool by Kirena Frolova.

Citation: Frolova, Kirena; te Heesen, Henrik (2023). Synthesis of Heat Load Profiles according to BDEW (Version of November 1, 2023) [Computer program]. Hochschule Trier. Available at: https://umwelt-campus.de/energietools (Accessed on: Day Month Year)

With the help of this tool, a combined heat and power plant (CHP) can be designed based on electricity and heat load profiles. In addition to the selection of the operating mode (electricity-led or heat-led). In addition to a technical design, key business figures are also output.

↧ Download the Excel tool for designing a CHP unit.

The tool is available in German. Collaboration on the tool by Pia Nickenig.

Citation: Nickenig, Pia; te Heesen, Henrik (2021). Design of a combined heat and power plant (Version: 21 May 2021) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

This tool can plan and calculate electricity consumption and heat demand in energy hubs. For this purpose, the consumption units (single-family and multi-family houses, commercial units, etc.) within the neighborhood are entered and stored with specific key figures. The tool calculates the annual energy demand. It creates an electricity load profile with hourly resolution.

↧ Download Excel Tool for Energy Hubs.

The tool is available in German. Collaboration of Kevin Kreitzer, Alexandra Luschmann and Vincent Hauf

Citation: Kreitzer, Kevin; Luschmann, Alexandra; Hauf, Vincent, te Heesen, Henrik (2022). Concept for an Energy Hub (Version: 19. July 2022) [Computer program] Hochschule Trier. Online at: umwelt-campus.de/energietools (Downloaded: Day Month Year)

The Excel tool is used for the load curve evaluation of quarter-hourly current values. The analysis tool offers the following functions, among others: Visualization of monthly and weekly values, the output of the sorted annual duration line, and display of the distribution of the 15-minute values for working days, Saturdays, and Sundays.

↧ Download Excel tool for load profile analysis.

The tool is available in German. Collaboration on the tool by Pascal Schäfer.

Citation: Schäfer, Pascal; te Heesen, Henrik (2023). Load profile analysis (Version: 23 January 2023) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

This Excel tool allows the investigation of energy technology plants' profitability based on the net present value method. An overview of the capital value development is created by parameterizing the essential economic key figures for capital-related, demand-related, and operation-related costs and revenues.

↧ Download Excel tool for the calculation of profitability.

The tool is available in German. Collaboration on the tool by Felix Fauß.

Citation: Fauß, Felix; te Heesen, Henrik (2020). Economic efficiency of energy technology systems (Version: 23 Sep 2020) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).