search

Energinet-DataHub / ARCHIVED-geh-aggregations

This project aims to create an engine that is able to do calculations on billions of metering points and deliver the results within minutes
Apache License 2.0
2 stars 0 forks source link

Revisit Excel input data and macro to generate chare prices #212

Closed mknic closed 3 years ago

mknic commented 3 years ago

1) Remove invalid time-series rows from input data eg. for metering point 578710000000000110 where it has an energy quantity within a time window where there's no energy supplier attached to the metering point.

2) Fix macro for generating charge prices. Currently, it has duplicates which should not be possible.

mknic commented 3 years ago

In grid loss calculator we experience incorrect results due to metering point 578710000000000110 issue stated in 1) above in the description.

We get an incorrect result because we have an hour without energy supplier and balance responsible but with a quantity value. This is an invalid scenario and we need to verify the aggregation after test data has been fixed to avoid implementing fixes for invalid scenarious.