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

2015 0.37 ms
{}
hash
2050 280.06 ms
{:agriculture_chp_engine_network_gas_dispatchable=>{:profitability=>:unprofitable, :full_load_hours=>0.0, :position=>nil, :capacity=>0.0, :availability=>95.0, :profit_per_mwh_electricity=>nil}, :agriculture_chp_wood_pellets=>{:profitability=>:unprofitable, :full_load_hours=>0.0, :position=>nil, :capacity=>0.0, :availability=>91.0, :profit_per_mwh_electricity=>nil}, :energy_chp_combined_cycle_ht_network_gas=>{:profitability=>:profitable, :full_load_hours=>7884.000000000211, :position=>6, :capacity=>182.19082685090575, :availability=>90.0, :profit_per_mwh_electricity=>1.7807851570864952}, :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=>14, :capacity=>3187.120543290129, :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=>7971.599999999309, :position=>8, :capacity=>15.497215653091105, :availability=>91.0, :profit_per_mwh_electricity=>-29.968703864248848}, :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=>:profitable, :full_load_hours=>7884.0000000006985, :position=>1, :capacity=>726.1999999999995, :availability=>90.0, :profit_per_mwh_electricity=>3.8638286131575255}, :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=>11, :capacity=>19.50000000000003, :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=>7883.999999998704, :position=>3, :capacity=>1352.125, :availability=>90.0, :profit_per_mwh_electricity=>-5.8945209706237005}, :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=>:unprofitable, :full_load_hours=>6213.882011009469, :position=>10, :capacity=>8265.692307692307, :availability=>90.0, :profit_per_mwh_electricity=>-7.355276587480541}, :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=>nil, :capacity=>0.0, :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.400000000878, :position=>2, :capacity=>509.62499999999994, :availability=>89.0, :profit_per_mwh_electricity=>10.098180364513937}, :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=>:conditionally_profitable, :full_load_hours=>7796.399999999088, :position=>9, :capacity=>1953.5618181818184, :availability=>89.0, :profit_per_mwh_electricity=>-5.1013529332663845}, :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.000000001485, :position=>5, :capacity=>2300.1985915493015, :availability=>90.0, :profit_per_mwh_electricity=>-0.9216182438093903}, :energy_power_ultra_supercritical_cofiring_coal=>{:profitability=>:unprofitable, :full_load_hours=>0.0, :position=>13, :capacity=>485.9154929577469, :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=>12, :capacity=>3893.260869565217, :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=>:profitable, :full_load_hours=>7884.000000000617, :position=>7, :capacity=>5443.360123449158, :availability=>90.0, :profit_per_mwh_electricity=>1.1211252063712855}, :industry_chp_engine_gas_power_fuelmix=>{:profitability=>:unprofitable, :full_load_hours=>0.0, :position=>15, :capacity=>58.86675847131907, :availability=>95.0, :profit_per_mwh_electricity=>nil}, :industry_chp_turbine_gas_power_fuelmix=>{:profitability=>:unprofitable, :full_load_hours=>0.0, :position=>16, :capacity=>650.0606860297326, :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.0000000013315, :position=>4, :capacity=>0.22593468476739925, :availability=>90.0, :profit_per_mwh_electricity=>-3.268751445858633}, :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