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 0.6 ms
{}
hash
2050 321.85 ms
{: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.9303002821843, :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=>7884.000000000257, :position=>2, :capacity=>894.6490091116173, :availability=>90.0, :profit_per_mwh_electricity=>-8.732891380975916}, :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.0000000014725, :position=>3, :capacity=>103.88966451612893, :availability=>90.0, :profit_per_mwh_electricity=>-5.728738740308548}, :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=>7690.419818931871, :position=>7, :capacity=>7402.501411669566, :availability=>90.0, :profit_per_mwh_electricity=>-0.6265958147655545}, :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.4000000010965, :position=>1, :capacity=>512.4181048492795, :availability=>89.0, :profit_per_mwh_electricity=>13.181893039840228}, :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=>7883.999999999575, :position=>6, :capacity=>2329.0253755229414, :availability=>90.0, :profit_per_mwh_electricity=>-4.573843841120514}, :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.99999999889, :position=>5, :capacity=>5292.716683078902, :availability=>90.0, :profit_per_mwh_electricity=>-0.8380233906217013}, :industry_chp_engine_gas_power_fuelmix=>{:profitability=>:unprofitable, :full_load_hours=>0.0, :position=>14, :capacity=>39.74822882258972, :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=>7883.999999999481, :position=>4, :capacity=>0.7686007078084766, :availability=>90.0, :profit_per_mwh_electricity=>-5.857065634327161}, :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