Load profiles spec fails on GB, NO, RS & CH dataset curves.

[kaskranenburgQ]

Since the recent ruby update the load_profiles_spec has failed on the most recently added datasets:

• GB_great_britain
• NO_norway
• RS_serbia
• CH_switzerland

After some investigation we discovered the following:

• This issue persists for every normalised curve that is present on ETSource for Norway, Serbia, Switzerland and Great Britain.
• Great Britain has 19 normalised curves, the other 3 countries have 21 normalised curves on ETSource. GB is missing the curves solar_pv & solar_pv_profile.csv in comparison to the other datasets.
• The curves sum up to a "country-specific" value. I.e. the curves for Norway all add up to 0.999725320080003, the curves for Switzerland all add up to 0.9999546271441201.
• When I open a curve in excel, sum up the curve and multiply with 3600. The curve does pass the 1*10-7 test.

Based on this I have 2 hypotheses:

1. The excel calculation is wrong, and the issue lies in the data module in which these curves are created is the weather year profile generator module in the scenario tools.
2. The calculation in the spec is wrong, if this is the case we should check why this happens.

After some more consideration we found that excel does not take all decimals into account.

As a solution we proposed to export the curves one more time using the rake task.
Will try this solution.

[github-actions]

This issue has had no activity for 60 days and will be closed in 7 days. Removing the "Stale" label or posting a comment will prevent it from being closed automatically. You can also add the "Pinned" label to ensure it isn't marked as stale in the future.