Model generator for the optimization of energy systems, based on the modeling framework oemof. No programming skills are required to use it, as the parameters are entered using spreadsheets (e.g. Excel, LibreOffice).

Spreadsheet Energy System Model Generator (SESMG)

Generic badge Generic badge

Maintainability Documentation Status License: GPL v3 DOI

Software Description

The SESMG is an energy system model generator with the focus on the optimization of urban energy systems, which can, however, also be used for the modeling of other types of energy systems. The SESMG is based on the 'Open Energy Modelling Framework' (oemof) and comes, compared to other modeling tools with advantages regarding user-friendliness, as

  • the model definition is based on spreadsheets, therefore no programming skills are required for the entire modeling process,
  • urban energy system models with any size can automatically conceptualized,
  • visualization of complex results are automatically created in the form of system graphs, Pareto-fronts, energy amounts, capacity diagrams, and many more, as well as
  • a set of standard (but still customizable) parameters are given, including detailed descriptions and references.

Furthermore, the SESMG comes with important modeling methods, enabling holistic modeling of spatially high resolution modeling of mixed-use multi energy systems, such as

  • considering the multi-energy system (MES) approach
  • applying multi-objective optimization by using the epsilon-constraint-method, as well as
  • providing several methods for model-based reduction of computational requirements (run-time and RAM).


Quick Start

Generic badge

A detailed description of the installation process for Windows, MacOS and Linux can be found in the documentation (chapter installation).

SESMG Features & Releases

Generic badge


Examples are stored in a separate GIT-Repository: SESMG/SESMG-Examples

Project status

✓ Draft (alpha, beta) State
✓ Modeling and Optimization of holistic energy systems
✓ Automated modeling of urban energy systems
✓ Several result plotting oportunities
✓ Usable on Windows, MacOS and Linux

✘ More time to code other things ... wait ✓!

Detailed Documentation!

Generic badge

The documentation, which includes detailed instructions for installation and use, troubleshooting and much more, can be accessed via the following link:


Generic badge Generic badge

Use the Discussions Section and let's chat!


Generic badge

Contact and Code of Conduct

Code of Conduct can be found here.

Contact information

Münster University of Applied Sciences

Christian Klemm - [email protected]


The Spreadsheet Energy System Model Generator was carried out within the research project R2Q "Resource Planing for Urban Districts". The project was funded by the Federal Ministry of Education and Research (BMBF) funding program RES:Z "Resource-Efficient Urban Districts". The funding measure is part of the flagship initiative "City of the Future" within the BMBF's framework programme "Research for Sustainable Development - FONA3". The contributors gratefully acknowledge the support of BMBF (grant number 033W102).


This project is published under GNU GPL-3.0 license, click here for more details.


Generic badge

Issues and Pull Requests are greatly appreciated. If you've never contributed to an open source project before I'm more than happy to walk you through how to create a pull request.

Detailed description of the contribution procedure as well as the projects coding standards can be found here.

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.