This is a C# project which connects in GeoPerdasANEEL database (MS SQL Server 2014) and batch generates the OpenDSS files (.dss) for the distribution feeders in the exact format to be executed by the project https://github.com/Zecao/ExecutorOpenDssBr.
The GeoPerdasANEEL is a database created from another database know as BDGD which Brazilian distribution utilities annualy inform all the mais assets to the Brazilian regulatory agency - ANEEL. So, the agency calculates the feeders energy losses on this database. The feeders .dss files - see FeederExample directory - are very similar to the ones created by the ANEEL software GeoPerdas.exe, but they are customized to be executed by the C# project cited above.
Advantages of using this project:
- faster .dss files creation, e.g. it takes 40 minutes to create 1700 feeders X 18 hours using a commercial ETL tool.
- alternative of using the ANEEL software GeoPerdas.EXE.
- addition of some customizations that do not exist in ANEEL .dss files, such as: capacitor files, alternative to the ANEEL load model and modeling of reclosers and fuses. Of course, those informations must also be avaiable in GeoPerdas database, through extensions of the original database.
There are some improvements to do yet, like:
- It doesn't generates the "linecode" files and the load profiles files. As I use a fixed files for all feeders, I've included these files in FeederExample directory.
- Addition of the SQL Scripts to extend the original GeoPerdas database (e.g. recolosers and fuse modelling and capacitor table).
The project also uses one external dll (EPPlus in lib directory) that allows Excel files to be read in the C#.
Feel free to make contact if this project have some use for you or your company. Ezequiel