Flexibility of electricity production project - Scatter plot

[cjlaumans]

For the flexibility of electricity production project I'd like to make the following scatter plot (image below). The scatter plot is not from the jqPlot library, and therefore I can't make this chart myself.

We currently have 1 similar scatter plot in the ETM (total cost of electricity production, in the costs tab). We could copy this one and change a few things, however if we are going to make this chart it is better to improve it. In the current scatter plot, each of the 28 converters in the chart has 2 queries (i.e. 2x28 = 56 queries in total). This is unfortunate. Therefore @dennisschoenmakers and I would like to improve this by automating the chart and limit the number of queries required.

I've created 2 (temporary) queries that give the calculations required for the x and y axis of the chart. In this particular case I used the converter gas_ccgt_energy, however this should become dynamic (i.e. it should be possible to select which technologies are included in the chart, and not need new queries for each of them. The queries are:

• X-axis: security_of_supply_backup_capacity_costs
• Y-axis: security_of_supply_backup_capacity_emissions

These two particular queries have been made for the converter: gas_ccgt_energy. Other technologies that we would like to have in the chart are (for now, more will need to be added later): ccgt_ccs_energy , coal_conv_energy , coal_igcc_ccs_energy , coal_igcc_energy , coal_pwd_energy , coal_pwd_ccs_energy , oil_plant_energy , gas_conv_energy_energetic

[cjlaumans]

Hey Sebi, I see that you've been assigned. If you have any questions about this please let me know!

[dennisquintel]

I assigned @hasclass to give his opinion about the following:

In the current scatter plot, each of the 28 converters in the chart has 2 queries (i.e. 2x28 = 56 queries in total).This is unfortunate. Therefore @dennisschoenmakers and I would like to improve this by automating the chart and limit the number of queries required.

Questions:

• Can this be improved?
• How much effort?

[cjlaumans]

@hasclass Have you had time to take a look at this yet?

[hasclass]

so you mean the only things that changes in the gquery _security_of_supply_backup_capacityemissions is _gas_ccgtenergy?

a) it would be pretty to see a gquery as a function, e.g. security_of_supply_backup_capacity_costs( converter_key ), and you could call security_of_supply_backup_capacity_costs( gas_ccgt_energy ), and it inserts gas_ccgt_energy at the right place. this would reduce a lot a lot of work, and open up a lot of new possibilities, but it's a 5 day of my time, and extra work for etmodel.

b) the other thing is to cut the factor 2, by allowing gqueries to return not just one number, but like an array or other data structures (hashes, strings). this is a 1-2 days change, and I think will be pretty useful in the long run.

c) in etsource we could write a gquery generator. Which makes these gqueries for you. you just create/edit a template and define which converters and run it in etsource, then it generates all gqueries.

[cjlaumans]

Alright thanks. Let me keep thinking about it and I'll discuss with Dennis. Maybe that there are some other solutions as well.

[dennisquintel]

so you mean the only things that changes in the gquery security_of_supply_backup_capacity_emissions is gas_ccgt_energy?

I assume so, right, @cjlaumans ?

[cjlaumans]

yes, correct

[dennisquintel]

All right. We'll just make the queries. We can start making the chart with the current dummy queries (gas ccgt):

security_of_supply_backup_capacity_emissions
security_of_supply_backup_capacity_costs

[cjlaumans]

I've renamed the 2 queries so that the converter name is used in the query name. Like this the script used to generate the chart can look for all queries as long as they have the same naming convention. The two new query names are:

backup_costs_of_gas_ccgt_in_overview_backup_capacity_options
backup_emissions_of_gas_ccgt_in_overview_backup_capacity_options

Paolo, can you use these dummy queries to make the chart? With the above the script should be able to work the same by looking for "backup_costs_of" + converter_name + "in_overview_backup_capacity_options"

Let me know if you have any questions.

[cjlaumans]

This has already been implemented by Paolo, so closing ticket