Energy Tools

Energy Tools

IBT energy tools offer useful tools 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.

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.

Photovoltaic system with battery storage (23 Sep 2020)

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.

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.

Load profile analysis (23 Sep 2020)

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.

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.

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

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/-technik - FR Maschinenbau

Contact

+49 6782 17-1908

Location

Birkenfeld | Building 9925 | Room 12

Consultation

nach Vereinbarung per E-Mail/by arrangement via mail

Contact

Trier University of Applied Sciences, Environmental Campus Birkenfeld
Institut for Operations and Technology Management (IBT)
Campusallee 9925
55768 Hoppstädten-Weiersbach
Germany

back-to-top nach oben