Total row in "Flexible electricity demand technologies" table is out of date

[mabijkerk]

In the table storage_options, the Total row is out of date. For example the value for total capacity has the following technologies:

- query =
    SUM(
      Q(households_flexibility_p2p_electricity_capacity),
      Q(transport_car_using_electricity_capacity),
      Q(energy_hydrogen_flexibility_p2g_electricity_capacity),
      Q(energy_flexibility_pumped_storage_electricity_capacity),
      Q(energy_flexibility_opac_electricity_capacity),
      Q(energy_flexibility_mv_batteries_electricity_capacity),
      Q(energy_heat_flexibility_p2h_boiler_electricity_capacity),
      Q(energy_heat_flexibility_p2h_heatpump_electricity_capacity),
      Q(industry_flexibility_p2h_electricity_capacity),
      Q(energy_interconnector_1_exported_electricity_capacity),
      Q(energy_interconnector_2_exported_electricity_capacity),
      Q(energy_interconnector_3_exported_electricity_capacity),
      Q(energy_interconnector_4_exported_electricity_capacity),
      Q(energy_interconnector_5_exported_electricity_capacity),
      Q(energy_interconnector_6_exported_electricity_capacity),
      Q(energy_interconnector_7_exported_electricity_capacity),
      Q(energy_interconnector_8_exported_electricity_capacity),
      Q(energy_interconnector_9_exported_electricity_capacity),
      Q(energy_interconnector_10_exported_electricity_capacity),
      Q(energy_interconnector_11_exported_electricity_capacity),
      Q(energy_interconnector_12_exported_electricity_capacity)
    )
- unit = MW

A number of technologies are missing, such as storage in electric buses, vans, and trucks and the flow batteries. Because the query is hardcoded, it is error-prone. Other column queries for the totals row or for the losses row may also be out of date.

Potential solutions:

• Evaluate the need for having the total and losses row in the table
• Update the queries for the total and losses row using the current structure
• Add MT test to check whether the queries are still up to date
• Update the queries to a more dynamic structure

[github-actions[bot]]

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.