GQL Statement

IF(
  GRAPH().future?,
  -> {
    GROUP(dispatchable_production).each_with_object({}){ |c,h|
      h[c.key] = {
        :profitability => c.node_api.profitability,
        :full_load_hours => c.node_api.full_load_hours,
        :position => c.node_api.merit_order_position,
        :capacity => c.node_api.input_capacity *
                    c.node_api.electricity_output_conversion *
                    c.node_api.number_of_units,
        :availability=> c.node_api.availability * 100,
        :profit_per_mwh_electricity => c.node_api.profit_per_mwh_electricity
      }
    }
  },
  -> { {} }
)

Result

2019
{}
hash
2050
{agriculture_chp_engine_network_gas_dispatchable: {profitability: :unprofitable, full_load_hours: 0.0, position: 11, capacity: 2769.6769254870774, availability: 95.0, profit_per_mwh_electricity: nil}, agriculture_chp_wood_pellets: {profitability: :unprofitable, full_load_hours: 0.0, position: 17, capacity: 2.033294040090608, availability: 91.0, profit_per_mwh_electricity: nil}, energy_chp_combined_cycle_ht_network_gas: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_chp_combined_cycle_mt_network_gas: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_chp_local_engine_ht_network_gas: {profitability: :unprofitable, full_load_hours: 0.0, position: 12, capacity: 223.93101300027402, availability: 95.0, profit_per_mwh_electricity: nil}, energy_chp_local_engine_mt_network_gas: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 95.0, profit_per_mwh_electricity: nil}, energy_chp_local_ht_wood_pellets_ccs_dispatchable: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 91.0, profit_per_mwh_electricity: nil}, energy_chp_local_ht_wood_pellets_dispatchable: {profitability: :unprofitable, full_load_hours: 0.0, position: 15, capacity: 48.623619243356586, availability: 91.0, profit_per_mwh_electricity: nil}, energy_chp_local_mt_wood_pellets_ccs_dispatchable: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 91.0, profit_per_mwh_electricity: nil}, energy_chp_local_mt_wood_pellets_dispatchable: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 91.0, profit_per_mwh_electricity: nil}, energy_chp_supercritical_ccs_ht_waste_mix: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_chp_supercritical_ccs_mt_waste_mix: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_chp_supercritical_ht_waste_mix: {profitability: :conditionally_profitable, full_load_hours: 7883.999999999999, position: 2, capacity: 894.6490091116173, availability: 90.0, profit_per_mwh_electricity: -8.670799173416057}, energy_chp_supercritical_mt_waste_mix: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_chp_ultra_supercritical_cofiring_ht_coal: {profitability: :unprofitable, full_load_hours: 0.0, position: 10, capacity: 495.3929806451613, availability: 90.0, profit_per_mwh_electricity: nil}, energy_chp_ultra_supercritical_cofiring_mt_coal: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_chp_ultra_supercritical_ht_coal: {profitability: :conditionally_profitable, full_load_hours: 7884.000000000001, position: 3, capacity: 103.88966451612893, availability: 90.0, profit_per_mwh_electricity: -5.666646532744398}, energy_chp_ultra_supercritical_ht_lignite: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_chp_ultra_supercritical_mt_coal: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_chp_ultra_supercritical_mt_lignite: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_power_combined_cycle_ccs_coal: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 83.0, profit_per_mwh_electricity: nil}, energy_power_combined_cycle_ccs_network_gas: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 87.0, profit_per_mwh_electricity: nil}, energy_power_combined_cycle_coal: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 85.0, profit_per_mwh_electricity: nil}, energy_power_combined_cycle_hydrogen: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_power_combined_cycle_network_gas: {profitability: :conditionally_profitable, full_load_hours: 7699.118310531569, position: 7, capacity: 7402.501411669566, availability: 90.0, profit_per_mwh_electricity: -0.5623046271604227}, energy_power_engine_diesel: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 95.0, profit_per_mwh_electricity: nil}, energy_power_engine_network_gas: {profitability: :unprofitable, full_load_hours: 0.0, position: 8, capacity: 19.022879874519365, availability: 95.0, profit_per_mwh_electricity: nil}, energy_power_hydro_mountain: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 51.0, profit_per_mwh_electricity: nil}, energy_power_nuclear_gen2_uranium_oxide: {profitability: :profitable, full_load_hours: 7796.399999999999, position: 1, capacity: 512.4181048492795, availability: 89.0, profit_per_mwh_electricity: 13.243985247403764}, energy_power_nuclear_gen3_uranium_oxide: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 92.0, profit_per_mwh_electricity: nil}, energy_power_nuclear_small_modular_reactor_uranium_oxide: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_power_supercritical_ccs_waste_mix: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_power_supercritical_coal: {profitability: :unprofitable, full_load_hours: 0.0, position: 9, capacity: 694.8294337082499, availability: 89.0, profit_per_mwh_electricity: nil}, energy_power_supercritical_waste_mix: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_power_turbine_hydrogen: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_power_turbine_network_gas: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_power_ultra_supercritical_ccs_coal: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 87.0, profit_per_mwh_electricity: nil}, energy_power_ultra_supercritical_coal: {profitability: :conditionally_profitable, full_load_hours: 7884.0, position: 6, capacity: 2329.0253755229414, availability: 90.0, profit_per_mwh_electricity: -4.511751633562761}, energy_power_ultra_supercritical_cofiring_coal: {profitability: :unprofitable, full_load_hours: 0.0, position: 16, capacity: 344.2297568627441, availability: 90.0, profit_per_mwh_electricity: nil}, energy_power_ultra_supercritical_crude_oil: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 89.0, profit_per_mwh_electricity: nil}, energy_power_ultra_supercritical_lignite: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_power_ultra_supercritical_network_gas: {profitability: :unprofitable, full_load_hours: 0.0, position: 13, capacity: 2526.4421539163764, availability: 90.0, profit_per_mwh_electricity: nil}, energy_power_ultra_supercritical_oxyfuel_ccs_lignite: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 87.0, profit_per_mwh_electricity: nil}, energy_power_wood_pellets_ccs_dispatchable: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, energy_power_wood_pellets_dispatchable: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, industry_chp_combined_cycle_gas_power_fuelmix: {profitability: :conditionally_profitable, full_load_hours: 7883.999999999999, position: 5, capacity: 5292.716683078902, availability: 90.0, profit_per_mwh_electricity: -0.7759319588611463}, industry_chp_engine_gas_power_fuelmix: {profitability: :unprofitable, full_load_hours: 0.0, position: 14, capacity: 39.74739711183594, availability: 95.0, profit_per_mwh_electricity: nil}, industry_chp_turbine_gas_power_fuelmix: {profitability: :unprofitable, full_load_hours: 0.0, position: 18, capacity: 791.1575765812647, availability: 90.0, profit_per_mwh_electricity: nil}, industry_chp_turbine_hydrogen: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}, industry_chp_ultra_supercritical_coal: {profitability: :conditionally_profitable, full_load_hours: 7884.0, position: 4, capacity: 0.7686007078084766, availability: 90.0, profit_per_mwh_electricity: -5.794973426768345}, industry_chp_wood_pellets: {profitability: :unprofitable, full_load_hours: 0.0, position: nil, capacity: 0.0, availability: 90.0, profit_per_mwh_electricity: nil}}
hash

Description

Characteristics

Groups
Unit hash
File path /app/tmp/etsource/gqueries/output_elements/dashboard/dashboard_profitability.gql

References