Eemsdelta dataset households shares in useful heat demand don't add to 100%

[kndehaan]

The "Share in useful heat demand per residence type and construction period" should add up to 100%. This is not the case for the Eemsdelta municipality. This is probably caused due to some problem in how the datasets of former separate municipalities are combined within the Eemsdelta dataset.

Proposed solution: track down where combining datasets went wrong and correct this error so that all shares add up to 100%.

[mabijkerk]

@kndehaan how big is the delta? If it's very minor than it might be due to rounding issues in Excel.

[kndehaan]

@mabijkerk the shares add up to 2.98 (298%), so the delta is quite large and cannot be due to Excel rounding issues.

I'm not very familiar with the former municipalities that Eemsdelta is composed of but could it be that there were 3 former municipalities of which the shares are just added up, therefore almost adding up to 300%? Anyhow, this should be fixed by properly combining the former municipality datasets that now represent the Eemsdelta municipality.

[mabijkerk]

@KoenvanB this issue might actually be related to the issue I spotted for the municipalities listed below, since Eemsdelta is included:

Could you look into this?

[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.

[kaskranenburgQ]

I have delved in the issue of @mabijkerk a bit further:

Nuenen, gerwen en Nederwetten
This label creates a bug since it has a comma in the key of the dataset.

Sudwest-Fryslan
This municipality has 2 special characters in the key: GM1900_súdwest_fryslân, it can't be found because of this.
For the municipality GM1970_noardeast_fryslan, the special characters has been removed. This is why this municipality can be found.

Beekdaelen
fused around 2018 consisted of:

• Nuth
• Onderbanken
• Schinnen

There is no label in the areas.yml files in etmodel for this municipality

Westerkwartier
fused in 2019 and consisted of:

• Grootegast
• Leek
• Marum
• Zuidhorm
• Part of Winsum

There is no label in the areas.yml files in etmodel for this municipality

Eemsdelta
fused in 2021 and consisted of:

• Appingedam
• Delfzijl
• Loppersum

There is no label in the areas.yml files in etmodel for this municipality