Energy Tools

Energy Tools

The energy tools are useful for energy technology applications. The tools can be used in Microsoft Excel to work on typical tasks of renewable energy technology.

Conversion of 15-minute values to hourly, daily and monthly values (23 Sep 2020)

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).

Conversion of hourly values to daily and monthly values (23 Sep 2020)

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).

Modeling of the solar irradiation (21 May 2021)

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).

Photovoltaic yield simulation (17 Nov 2021)

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).

Photovoltaic system with battery storage (15 Mar 2021)

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 (2021). Photovoltaic system with battery storage (Version: 15 Mar 2021) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

Solar thermal system with heat storage (22. June 2022)

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).
Design of a heat storage (23 Sep 2020)

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).

Wind Energy Yield Simulation (12. July 2022)

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 (2022). Wind Energy Yield Simulation (Version: 12. July 2022) [Computer program]. Hochschule Trier. Online at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

Synthesis of power and heat profiles according to VDI 4655 (2 Nov 2020)

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.

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).

Synthesis of standard electricity load profiles according to BDEW (21 May 2021)

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.

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

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

Design of a combined heat and power plant (21 May 2021)

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).

Concept for an Energy Hub (19. July 2022)

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)

Load profile analysis (23 June 2022)

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 (2022). Load profile analysis (Version: 23 June 2022) [Computer program]. Hochschule Trier. Available at: umwelt-campus.de/energietools (Downloaded: Day Month Year).

Economic efficiency of energy technology systems (23 Sep 2020)

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).

Weather Data

It is necessary for many energy applications to have weather data (e.g. ambient temperature, wind speed, solar radiation, cloud cover) available for different locations. The following websites provide weather data:

Some services require registration to use the services to their full extent. The data can usually be exported as CSV files. For data from English language websites, it must be taken into account that the decimal separator is a dot (1.23) instead of a comma (1,23). In the CSV file, the dot must be replaced by a comma using the Search and Replace function in a text editor to be able to read the CSV file directly into Excel. If the Excel data are not displayed separately in columns, the values can be split into different columns in Excel using the "Text to Columns" function on the "Data" tab.

License

These tools are free software: you can redistribute them and/or modify them under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. See the GNU General Public License for more details. https://www.gnu.org/licenses/

If you have any comments, remarks or criticism, feel free to contact us by e-mail: h.teheesen(at)umwelt-campus.de

 

Contact

Prof. Dr. Henrik te Heesen
Prof. Dr. Henrik te Heesen
Professor FB Umweltplanung/Umwelttechnik - FR Maschinenbau

Contact

+49 6782 17-1908

Location

Birkenfeld | Building 9925 | Room 12

Consultation

nur nach Vereinbarung per E-Mail/only by arrangement via mail
back-to-top nach oben