Planned intervention: On Wednesday June 26th 05:30 UTC Zenodo will be unavailable for 10-20 minutes to perform a storage cluster upgrade.
Published January 4, 2021 | Version v1
Software Open

Three-phase Power Flow Calculation Tool in Excel

  • 1. Karlsruhe Institute of Technology

Description

Within the work of the CIRED working group “LOAD MODELLING AND DISTRIBUTION PLANNING IN THE ERA OF ELECTRIC MOBILITY”, an unbalanced power flow tool was developed in Excel. Especially, it is useful to investigate the effect of unbalanced charging of electric vehicles in low voltage grids. It is open-source and can be adapted to individual applications.

Many professional power flow tools exist already. They can be used to model low voltage grids in a high level of detail. Disadvantages are that they are complicated to use and a lot of input data is needed. The tool presented here can be used in Excel, so no extra software has to be installed. Additionally, it is easy to use and the level of complexity can be chosen by the user. In the following sections, the simulation framework is presented and basic instructions for the tool are given. Furthermore, an example to determine the effect of EV charging is shown.

Files

Information_Zenodo.pdf

Files (417.4 kB)

Name Size Download all
md5:ce7b02c5704a599c20bb591a3c7d667f
157.4 kB Preview Download
md5:afc85dead51a2cd7334b7e9dc7add385
260.0 kB Download