{ "cells": [ { "cell_type": "markdown", "id": "209ffd26", "metadata": { "Collapsed": "false" }, "source": [ "(multiple-price-bid-matrix)=\n", "# Bidding under uncertainty\n", "\n", "The model setup is available in the following formats:\n", "\n", "- pyshop\n", " - [multi_price_bid_matrix_model.py](multi-price-bid-matrix-model-py)" ] }, { "cell_type": "markdown", "id": "c300d2be", "metadata": { "Collapsed": "false" }, "source": [ "In this example we show how to import a spreadsheet containing multiple prices (up to 52 time series) into a dataframe. This price input will be used to create the same amount of scenarios which we in turn feed to SHOP. The output of this multiple price input run from SHOP will result into a joint bid matrix which consider all the stochastic price inputs to SHOP with all its price data intact, ready to make use of in a marked bidding situation with uncertainty regarding the price forecasts." ] }, { "cell_type": "markdown", "id": "c5d4fd3c", "metadata": { "Collapsed": "false" }, "source": [ "## Imports and settings" ] }, { "cell_type": "markdown", "id": "116fdb56", "metadata": { "Collapsed": "false" }, "source": [ "The first thing we do is to import the needed packages. You can import whichever packages you like, however we use the following ones for this example:\n", "\n", "* Pandas for structuring our data into dataframes\n", "* Pyshop in order to create a SHOP session\n", "* Plotly as backend for dynamic graph plotting" ] }, { "cell_type": "code", "execution_count": 1, "id": "0bc8fb82", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "import pandas as pd\n", "from pyshop import ShopSession\n", "import plotly.express as px\n", "pd.options.plotting.backend = \"plotly\"" ] }, { "cell_type": "markdown", "id": "1d0b3958", "metadata": { "Collapsed": "false" }, "source": [ "Additionally, we import basic SHOP functions and data from a predefined demo dataset, see this section of the documentation:" ] }, { "cell_type": "code", "execution_count": 2, "id": "02e65938", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "from multi_price_bid_matrix_model import build_model, run_model" ] }, { "cell_type": "markdown", "id": "65006b8b", "metadata": { "Collapsed": "false" }, "source": [ "## Instancing SHOP and building the model" ] }, { "cell_type": "markdown", "id": "70142c86", "metadata": { "Collapsed": "false" }, "source": [ "In order to have SHOP receive our inputs, run the model we create and give us results, we need to instance a running SHOP session. You may create multiple SHOP sessions simultaneously if needed." ] }, { "cell_type": "code", "execution_count": 3, "id": "85f0e563", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "#Create a standard ShopSession\n", "shop = ShopSession()" ] }, { "cell_type": "markdown", "id": "8cdf3caf", "metadata": { "Collapsed": "false" }, "source": [ "We then build our model using the existing function imported from bp.py" ] }, { "cell_type": "code", "execution_count": 4, "id": "331c2936", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "#Build a simple model with one plant with two equal generators and a second plant with one large and three small generators \n", "#by calling function \"build_model\" in bp.py\n", "build_model(shop)" ] }, { "cell_type": "markdown", "id": "274d968b", "metadata": { "Collapsed": "false" }, "source": [ "The imported model can now be visualized:" ] }, { "cell_type": "code", "execution_count": 5, "id": "9586624a", "metadata": { "Collapsed": "false" }, "outputs": [ { "data": { "image/svg+xml": [ "\n", "\n", "\n", "\n", "\n", "\n", "%3\n", "\n", "\n", "\n", "reservoir_Reservoir1\n", "\n", "Reservoir1\n", "\n", "\n", "\n", "plant_Plant1\n", "\n", "Plant1\n", "\n", "\n", "\n", "reservoir_Reservoir1->plant_Plant1\n", "\n", "\n", "\n", "\n", "reservoir_Reservoir2\n", "\n", "Reservoir2\n", "\n", "\n", "\n", "plant_Plant2\n", "\n", "Plant2\n", "\n", "\n", "\n", "reservoir_Reservoir2->plant_Plant2\n", "\n", "\n", "\n", "\n", "plant_Plant1->reservoir_Reservoir2\n", "\n", "\n", "\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "#Display topology to the screen\n", "display(shop.model.build_connection_tree())" ] }, { "cell_type": "markdown", "id": "53e3d2a6", "metadata": { "Collapsed": "false" }, "source": [ "## Data preperation" ] }, { "cell_type": "markdown", "id": "f5357d40", "metadata": { "Collapsed": "false" }, "source": [ "Since we we need to work a bit with time horizons given that we will consider part of a period with stochastic information, we retrive the start time from the imported data" ] }, { "cell_type": "code", "execution_count": 6, "id": "4b49bec3", "metadata": { "Collapsed": "false" }, "outputs": [ { "data": { "text/plain": [ "{'starttime': Timestamp('2018-01-23 00:00:00'),\n", " 'endtime': Timestamp('2018-01-26 00:00:00'),\n", " 'timeunit': 'hour',\n", " 'timeresolution': 2018-01-23 00:00:00 1.0\n", " 2018-01-23 01:00:00 1.0\n", " 2018-01-23 02:00:00 1.0\n", " 2018-01-23 03:00:00 1.0\n", " 2018-01-23 04:00:00 1.0\n", " ... \n", " 2018-01-25 20:00:00 1.0\n", " 2018-01-25 21:00:00 1.0\n", " 2018-01-25 22:00:00 1.0\n", " 2018-01-25 23:00:00 1.0\n", " 2018-01-26 00:00:00 1.0\n", " Name: data, Length: 73, dtype: float64}" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Retrieve the start time for adding stochastic time series later\n", "timeres=shop.get_time_resolution()\n", "shop.get_time_resolution()" ] }, { "cell_type": "markdown", "id": "78ca3a04", "metadata": { "Collapsed": "false" }, "source": [ "### Importing prices from spreadsheet" ] }, { "cell_type": "markdown", "id": "f384543e", "metadata": { "Collapsed": "false" }, "source": [ "After the model data has been imported and read, we move on to the prices we want to consider. \n", "We first define the number of prices we want to import" ] }, { "cell_type": "code", "execution_count": 7, "id": "10943f64", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "# Import number of prices\n", "n_prices = 10" ] }, { "cell_type": "markdown", "id": "28108b39", "metadata": { "Collapsed": "false" }, "source": [ "which will be equal to the scenarios we will create later on. \n", "We then define for how long of a period we want to consider the stochastic price input. This can not be a larger period than what you have data for in your price forecasts." ] }, { "cell_type": "code", "execution_count": 8, "id": "cf764364", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "# Set the hours to import stochastic price\n", "stochastic_prices_start = timeres['starttime']\n", "# In this example, we choose 24 hours\n", "stochastic_prices_end = stochastic_prices_start + pd.Timedelta(hours=23)" ] }, { "cell_type": "markdown", "id": "e74790bc", "metadata": { "Collapsed": "false" }, "source": [ "Next we import the stochastic prices accordingly into a dataframe" ] }, { "cell_type": "code", "execution_count": 9, "id": "8fda73d4", "metadata": { "Collapsed": "false" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
0123456789
038.68892530.84143739.30318343.12222131.39970838.21173842.47948529.83885729.93227946.548664
138.91648428.47852433.84338536.85633340.44714034.47371133.75162933.69934636.98775738.796374
237.13397329.92342531.28058540.11727133.28553834.72807434.09604732.08503336.42659045.003989
328.56714525.73859033.42898439.93746239.57022431.55864838.29084237.52719228.99041040.885543
432.90962930.64244834.66852147.70865636.96327333.74917438.70346831.80226729.55370346.706921
534.43855634.62347033.96960641.13648235.48029141.83473233.78857628.95316439.69066846.564680
635.47086230.47929435.03191041.90296137.54483633.30079441.63094742.22412740.85321838.904588
743.88436351.59123243.36287248.16582343.54943448.46864753.58639643.27692246.69187551.359444
846.48571249.47362744.29502254.17468247.94751053.74083050.93594954.03181853.41606958.500872
951.83157148.73569756.20106050.87969954.29157454.69347458.22480053.48550864.63548454.939225
1042.77078741.49397037.82846242.26399449.96689654.10620844.12832049.39106660.57510445.339350
1137.87060037.42526244.11692641.93284042.41688846.17547545.12199549.68323140.77799045.914877
1238.72012642.77109941.50705142.14680438.80397248.31662040.81178047.99123653.71575441.338486
1336.11937043.06022638.30018035.63193039.99991146.29631245.36328432.37836542.46518134.729646
1438.19404946.10862637.37508736.57564544.01463748.48044750.67242540.07908141.31169249.711962
1538.26022751.17502739.21637538.05367646.20276647.60882844.79515039.29150351.56377837.664475
1638.05804847.07770340.79919645.25095843.69050844.29423050.90564946.36238146.65976144.224564
1756.71036747.71087555.55446449.06669554.54647952.04463756.70139453.91189560.11102253.380406
1859.00434456.79788660.17298158.23750557.51310055.19502254.10929073.96141556.12152855.876500
1955.77624558.24584758.27061754.60177357.31774556.95479253.89801570.85271559.41414553.165951
2043.24421050.68762749.48684149.71405937.70655846.24326647.60151958.95601043.54022949.330592
2148.31710341.46123145.00785743.13839040.50753644.10861041.70081651.10217740.24570739.758460
2238.23718747.59398242.57414136.78084949.54837138.09788933.73190951.82626946.92059542.529905
2342.37140435.49695346.26549938.24747843.22821436.81609242.98743346.24975639.40723141.273543
\n", "
" ], "text/plain": [ " 0 1 2 3 4 5 \\\n", "0 38.688925 30.841437 39.303183 43.122221 31.399708 38.211738 \n", "1 38.916484 28.478524 33.843385 36.856333 40.447140 34.473711 \n", "2 37.133973 29.923425 31.280585 40.117271 33.285538 34.728074 \n", "3 28.567145 25.738590 33.428984 39.937462 39.570224 31.558648 \n", "4 32.909629 30.642448 34.668521 47.708656 36.963273 33.749174 \n", "5 34.438556 34.623470 33.969606 41.136482 35.480291 41.834732 \n", "6 35.470862 30.479294 35.031910 41.902961 37.544836 33.300794 \n", "7 43.884363 51.591232 43.362872 48.165823 43.549434 48.468647 \n", "8 46.485712 49.473627 44.295022 54.174682 47.947510 53.740830 \n", "9 51.831571 48.735697 56.201060 50.879699 54.291574 54.693474 \n", "10 42.770787 41.493970 37.828462 42.263994 49.966896 54.106208 \n", "11 37.870600 37.425262 44.116926 41.932840 42.416888 46.175475 \n", "12 38.720126 42.771099 41.507051 42.146804 38.803972 48.316620 \n", "13 36.119370 43.060226 38.300180 35.631930 39.999911 46.296312 \n", "14 38.194049 46.108626 37.375087 36.575645 44.014637 48.480447 \n", "15 38.260227 51.175027 39.216375 38.053676 46.202766 47.608828 \n", "16 38.058048 47.077703 40.799196 45.250958 43.690508 44.294230 \n", "17 56.710367 47.710875 55.554464 49.066695 54.546479 52.044637 \n", "18 59.004344 56.797886 60.172981 58.237505 57.513100 55.195022 \n", "19 55.776245 58.245847 58.270617 54.601773 57.317745 56.954792 \n", "20 43.244210 50.687627 49.486841 49.714059 37.706558 46.243266 \n", "21 48.317103 41.461231 45.007857 43.138390 40.507536 44.108610 \n", "22 38.237187 47.593982 42.574141 36.780849 49.548371 38.097889 \n", "23 42.371404 35.496953 46.265499 38.247478 43.228214 36.816092 \n", "\n", " 6 7 8 9 \n", "0 42.479485 29.838857 29.932279 46.548664 \n", "1 33.751629 33.699346 36.987757 38.796374 \n", "2 34.096047 32.085033 36.426590 45.003989 \n", "3 38.290842 37.527192 28.990410 40.885543 \n", "4 38.703468 31.802267 29.553703 46.706921 \n", "5 33.788576 28.953164 39.690668 46.564680 \n", "6 41.630947 42.224127 40.853218 38.904588 \n", "7 53.586396 43.276922 46.691875 51.359444 \n", "8 50.935949 54.031818 53.416069 58.500872 \n", "9 58.224800 53.485508 64.635484 54.939225 \n", "10 44.128320 49.391066 60.575104 45.339350 \n", "11 45.121995 49.683231 40.777990 45.914877 \n", "12 40.811780 47.991236 53.715754 41.338486 \n", "13 45.363284 32.378365 42.465181 34.729646 \n", "14 50.672425 40.079081 41.311692 49.711962 \n", "15 44.795150 39.291503 51.563778 37.664475 \n", "16 50.905649 46.362381 46.659761 44.224564 \n", "17 56.701394 53.911895 60.111022 53.380406 \n", "18 54.109290 73.961415 56.121528 55.876500 \n", "19 53.898015 70.852715 59.414145 53.165951 \n", "20 47.601519 58.956010 43.540229 49.330592 \n", "21 41.700816 51.102177 40.245707 39.758460 \n", "22 33.731909 51.826269 46.920595 42.529905 \n", "23 42.987433 46.249756 39.407231 41.273543 " ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Use pandas read_excel function to import n_prices to a dataframe, starting from the first column to the left in the spreadsheet\n", "stochastic_prices_from_file = pd.read_excel ('52_hourly_prices_random.xls', header=None,usecols=list(range(0,n_prices)))\n", "\n", "# Optionally, select which scenarios you want relative to the columns in your spreadsheet. They must then be equal to n_prices;\n", "#stoch_price_from_file = pd.read_excel (r'20200123_scens_edit.xlsx', usecols=[1,2,5,7,9])\n", "\n", "stochastic_prices_from_file" ] }, { "cell_type": "markdown", "id": "221aa486", "metadata": { "Collapsed": "false" }, "source": [ "In order to later combine the stochastic prices with a deterministic price into the future, we make sure the dataframe has the correct timestamp indexing" ] }, { "cell_type": "code", "execution_count": 10, "id": "e5d84c37", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "# Add correct indexing to the dataframe\n", "stochastic_prices_from_file.index=pd.date_range(stochastic_prices_start,stochastic_prices_end,freq='h')" ] }, { "cell_type": "markdown", "id": "638ab023", "metadata": { "Collapsed": "false" }, "source": [ "Then we can plot and review the newly imported prices" ] }, { "cell_type": "code", "execution_count": 11, "id": "e30d1361", "metadata": { "Collapsed": "false" }, "outputs": [ { "data": { "text/html": [ " \n", " " ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "application/vnd.plotly.v1+json": { "config": { "plotlyServerURL": "https://plot.ly" }, "data": [ { "hovertemplate": "=0
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "0", "line": { "color": "#636efa", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "0", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00" ], "xaxis": "x", "y": [ 38.688924790028935, 38.91648373357578, 37.13397283607992, 28.567144764921423, 32.90962859918502, 34.43855641685243, 35.47086224821935, 43.884362898890004, 46.48571170034651, 51.83157067457943, 42.77078719357291, 37.87059975592636, 38.72012568912313, 36.11937041948169, 38.194048733917754, 38.26022728649826, 38.05804786206631, 56.71036696579608, 59.00434355483017, 55.77624532195394, 43.24421031420755, 48.317102814015996, 38.237187361867846, 42.371404453779654 ], "yaxis": "y" }, { "hovertemplate": "=1
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "1", "line": { "color": "#EF553B", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "1", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00" ], "xaxis": "x", "y": [ 30.84143666529853, 28.47852434471662, 29.923425146009553, 25.7385904884098, 30.64244779413558, 34.62346957920782, 30.47929369560378, 51.591232223645896, 49.47362653799953, 48.73569665784232, 41.49396971475139, 37.42526162689267, 42.77109897478207, 43.060226041834014, 46.10862607282206, 51.175027264422994, 47.07770347974001, 47.71087538922627, 56.79788602641253, 58.24584690285616, 50.687626812451406, 41.46123136424681, 47.593982027701074, 35.49695286383878 ], "yaxis": "y" }, { "hovertemplate": "=2
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "2", "line": { "color": "#00cc96", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "2", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00" ], "xaxis": "x", "y": [ 39.30318270980665, 33.84338460894348, 31.28058529475953, 33.42898384611474, 34.66852142919224, 33.9696063734057, 35.03191004478626, 43.362871627306525, 44.29502173658242, 56.201060307257364, 37.82846182019187, 44.11692579762013, 41.50705054972993, 38.30018021897476, 37.37508689986337, 39.21637545527792, 40.79919610418443, 55.5544635153597, 60.1729813513571, 58.270617107738786, 49.48684060432931, 45.007856590396585, 42.574140822722775, 46.26549880390542 ], "yaxis": "y" }, { "hovertemplate": "=3
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "3", "line": { "color": "#ab63fa", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "3", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00" ], "xaxis": "x", "y": [ 43.1222213657023, 36.85633331407592, 40.11727135214596, 39.93746190323393, 47.708656045739914, 41.136482401465926, 41.90296077026431, 48.16582265504936, 54.17468219492054, 50.87969915242537, 42.2639939367465, 41.93283958287484, 42.14680390729975, 35.63193002550175, 36.57564545317568, 38.05367612977148, 45.250958178628906, 49.06669510663274, 58.237504769322314, 54.60177345780331, 49.71405910604083, 43.138390473686016, 36.780848917322885, 38.24747762487639 ], "yaxis": "y" }, { "hovertemplate": "=4
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "4", "line": { "color": "#FFA15A", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "4", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00" ], "xaxis": "x", "y": [ 31.399707877439493, 40.44714002248111, 33.28553820479103, 39.5702239851003, 36.96327342983141, 35.48029110424704, 37.54483625037337, 43.549433968320535, 47.94751030975122, 54.291573962141264, 49.96689611434518, 42.41688837159459, 38.80397234301293, 39.99991112626061, 44.01463732532422, 46.202766220740195, 43.69050794432827, 54.54647867289708, 57.513099511561066, 57.317744778949475, 37.70655838878481, 40.50753566627801, 49.548370526927386, 43.22821414518731 ], "yaxis": "y" }, { "hovertemplate": "=5
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "5", "line": { "color": "#19d3f3", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "5", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00" ], "xaxis": "x", "y": [ 38.211738224562396, 34.47371124763938, 34.7280738365677, 31.55864788701061, 33.749174228915635, 41.83473160042925, 33.30079368907467, 48.468647031564394, 53.74082984083143, 54.693474100441335, 54.10620785334244, 46.175475331181204, 48.31661977281291, 46.296312210030116, 48.48044709718775, 47.6088277963454, 44.29423031503364, 52.04463673650779, 55.195022080319625, 56.95479156611447, 46.24326639374972, 44.108610402454936, 38.09788889449211, 36.816091953881276 ], "yaxis": "y" }, { "hovertemplate": "=6
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "6", "line": { "color": "#FF6692", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "6", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00" ], "xaxis": "x", "y": [ 42.479485028495645, 33.75162850526158, 34.09604723329545, 38.290841505691326, 38.70346824980726, 33.78857578711016, 41.63094728212825, 53.58639585781828, 50.93594863387132, 58.22479969565341, 44.12831968551308, 45.121995478221244, 40.81178048525122, 45.36328446516111, 50.67242464460132, 44.795150046331486, 50.9056494242492, 56.7013936281821, 54.10928992277162, 53.898014509384915, 47.60151878277625, 41.700816040923726, 33.73190908915484, 42.98743348732935 ], "yaxis": "y" }, { "hovertemplate": "=7
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "7", "line": { "color": "#B6E880", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "7", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00" ], "xaxis": "x", "y": [ 29.83885677823433, 33.6993463496901, 32.08503270612679, 37.527191611735795, 31.802267240063458, 28.953163992553172, 42.22412721160745, 43.27692227013378, 54.03181777559293, 53.48550785435142, 49.39106615383736, 49.68323133044724, 47.99123597938316, 32.378365450187964, 40.079081432670144, 39.29150257508463, 46.36238144501525, 53.91189541744889, 73.96141458604406, 70.85271509694213, 58.95601014294316, 51.10217655427115, 51.82626868327121, 46.24975583110782 ], "yaxis": "y" }, { "hovertemplate": "=8
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "8", "line": { "color": "#FF97FF", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "8", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00" ], "xaxis": "x", "y": [ 29.93227883576153, 36.98775697574074, 36.42658995902406, 28.99040988121767, 29.553703261597807, 39.69066832659008, 40.85321844893519, 46.69187486266235, 53.41606943876772, 64.63548367033422, 60.57510426310269, 40.777990024016965, 53.715753720173545, 42.46518071355044, 41.311691911561276, 51.563778217252654, 46.659760523543746, 60.11102240027948, 56.121528169768595, 59.41414482942551, 43.54022872965482, 40.2457071697066, 46.92059468036083, 39.40723132420954 ], "yaxis": "y" }, { "hovertemplate": "=9
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "9", "line": { "color": "#FECB52", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "9", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00" ], "xaxis": "x", "y": [ 46.54866447289529, 38.79637418511707, 45.003988815437644, 40.88554303114959, 46.706920769563055, 46.564680245777616, 38.9045882715515, 51.35944374090656, 58.50087160008804, 54.93922457297462, 45.3393497791437, 45.9148773821524, 41.33848577095818, 34.72964629465234, 49.71196176709573, 37.664474969438864, 44.22456435168797, 53.38040630699615, 55.876500217206456, 53.16595109294248, 49.330592191903854, 39.75846030900367, 42.52990511682548, 41.27354268730056 ], "yaxis": "y" } ], "layout": { "legend": { "title": { "text": "" }, "tracegroupgap": 0 }, "template": { "data": { "bar": [ { "error_x": { "color": "#2a3f5f" }, "error_y": { "color": "#2a3f5f" }, "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "bar" } ], "barpolar": [ { "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "barpolar" } ], "carpet": [ { "aaxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "baxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "type": "carpet" } ], "choropleth": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "choropleth" } ], "contour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "contour" } ], "contourcarpet": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "contourcarpet" } ], "heatmap": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmap" } ], "heatmapgl": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmapgl" } ], "histogram": [ { "marker": { "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "histogram" } ], "histogram2d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2d" } ], "histogram2dcontour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2dcontour" } ], "mesh3d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "mesh3d" } ], "parcoords": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "parcoords" } ], "pie": [ { "automargin": true, "type": "pie" } ], "scatter": [ { "fillpattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 }, "type": "scatter" } ], "scatter3d": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter3d" } ], "scattercarpet": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattercarpet" } ], "scattergeo": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergeo" } ], "scattergl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergl" } ], "scattermapbox": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattermapbox" } ], "scatterpolar": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolar" } ], "scatterpolargl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolargl" } ], "scatterternary": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterternary" } ], "surface": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "surface" } ], "table": [ { "cells": { "fill": { "color": "#EBF0F8" }, "line": { "color": "white" } }, "header": { "fill": { "color": "#C8D4E3" }, "line": { "color": "white" } }, "type": "table" } ] }, "layout": { "annotationdefaults": { "arrowcolor": "#2a3f5f", "arrowhead": 0, "arrowwidth": 1 }, "autotypenumbers": "strict", "coloraxis": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "colorscale": { "diverging": [ [ 0, "#8e0152" ], [ 0.1, "#c51b7d" ], [ 0.2, "#de77ae" ], [ 0.3, "#f1b6da" ], [ 0.4, "#fde0ef" ], [ 0.5, "#f7f7f7" ], [ 0.6, "#e6f5d0" ], [ 0.7, "#b8e186" ], [ 0.8, "#7fbc41" ], [ 0.9, "#4d9221" ], [ 1, "#276419" ] ], "sequential": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "sequentialminus": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ] }, "colorway": [ "#636efa", "#EF553B", "#00cc96", "#ab63fa", "#FFA15A", "#19d3f3", "#FF6692", "#B6E880", "#FF97FF", "#FECB52" ], "font": { "color": "#2a3f5f" }, "geo": { "bgcolor": "white", "lakecolor": "white", "landcolor": "#E5ECF6", "showlakes": true, "showland": true, "subunitcolor": "white" }, "hoverlabel": { "align": "left" }, "hovermode": "closest", "mapbox": { "style": "light" }, "paper_bgcolor": "white", "plot_bgcolor": "#E5ECF6", "polar": { "angularaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "radialaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "scene": { "xaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "yaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "zaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" } }, "shapedefaults": { "line": { "color": "#2a3f5f" } }, "ternary": { "aaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "baxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "caxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "title": { "x": 0.05 }, "xaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 }, "yaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 } } }, "title": { "text": "Stochastic prices imported from spreadsheet" }, "xaxis": { "anchor": "y", "domain": [ 0.0, 1.0 ], "title": { "text": "Time" } }, "yaxis": { "anchor": "x", "domain": [ 0.0, 1.0 ], "title": { "text": "EUR/MWh" } } } }, "text/html": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Plot all stochastic prices imported from Excel\n", "stochastic_prices_from_file.plot(title=\"Stochastic prices imported from spreadsheet\", labels=dict(index=\"Time\", value=\"EUR/MWh\", variable=\"\"))" ] }, { "cell_type": "markdown", "id": "abebc6a1", "metadata": { "Collapsed": "false" }, "source": [ "### Creating scenarios" ] }, { "cell_type": "markdown", "id": "79c7468a", "metadata": { "Collapsed": "false" }, "source": [ "Now it is time to create scenarios that we can populate with the imported prices. We make sure to create just as many scenarios as we have prices imported." ] }, { "cell_type": "code", "execution_count": 12, "id": "bde5807d", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "# Generate as many scenarios as prices\n", "n_scenarios = n_prices\n", "for i in range (1, n_scenarios+1):\n", " scenario_name='S'+str(i)\n", " # The first scenario always exists in SHOP and should not be added again\n", " if i>1:\n", " scenario = shop.model.scenario.add_object(scenario_name)\n", " else:\n", " scenario=shop.model.scenario[scenario_name]\n", " scenario.scenario_id.set(i)\n", " \n", " # Set each scenario equally probable\n", " scenario.probability.set(1.0/n_scenarios)\n", " \n", " # Branch immediately, i.e. at 'starttime'\n", " scenario.common_scenario.set(pd.Series([i], index=[timeres['starttime']]))\n", " \n", " # Optionally set branching to start after given number of hours (all scenarios are set equal to scenario 2 before this) \n", " #scen.common_scenario.set(pd.Series([2, i], index=[timeres['starttime'], branching_start_time]))" ] }, { "cell_type": "markdown", "id": "433aae2e", "metadata": { "Collapsed": "false" }, "source": [ "### Creating the new price array from stochastic and deterministic prices" ] }, { "cell_type": "markdown", "id": "dfc7c519", "metadata": { "Collapsed": "false" }, "source": [ "Since we have chosen to only consider the first 24 hours as stochastic when it comes to the price, but have longer total time horizon, we need to combine the stochastic and deterministic prices into a joint price dataframe. We have already defined the start and end time for the stochastic price, but need to make sure that we also define when the deterministic price should be valid and thus overlap each other." ] }, { "cell_type": "code", "execution_count": 13, "id": "b6018856", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "# Use first (and only) market as index for setting stochastic data and getting results\n", "name_list = shop.model.market.get_object_names()\n", "\n", "# The deterministic model only has one market, so we give stochastic price to that (da is just a name we use to indicate that we regard it to be a day ahead energy market)\n", "day_ahead_market = shop.model.market[name_list[0]]\n", "\n", "# Get the deterministic price from ASCII import for correct indexing \n", "deterministic_price = day_ahead_market.sale_price.get()\n", "\n", "# Create a new array for deterministic price with n_prices columns in order to combine it with the stochastic price\n", "deterministic_price_multi_dimension_array = pd.DataFrame(index=deterministic_price.index, columns=list(range(0,n_prices)))\n", "\n", "# Define when to use deterministic price\n", "deterministic_price_start = timeres['starttime']+pd.Timedelta(hours=24)\n", "deterministic_price_end = timeres['endtime']-pd.Timedelta(hours=1)" ] }, { "cell_type": "markdown", "id": "676e5405", "metadata": { "Collapsed": "false" }, "source": [ "We print out the start and end times to make sure they are correct." ] }, { "cell_type": "code", "execution_count": 14, "id": "4d494983", "metadata": { "Collapsed": "false" }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Stochastic price(s) start time 2018-01-23 00:00:00\n", "Stochastic price(s) end time 2018-01-23 23:00:00\n", "Deterministic prices start time 2018-01-24 00:00:00\n", "Deterministic prices end time 2018-01-25 23:00:00\n" ] } ], "source": [ "# Print out start and end set point for prices\n", "print(\"Stochastic price(s) start time\",stochastic_prices_start)\n", "print(\"Stochastic price(s) end time\",stochastic_prices_end)\n", "print(\"Deterministic prices start time\",deterministic_price_start)\n", "print(\"Deterministic prices end time\",deterministic_price_end)" ] }, { "cell_type": "markdown", "id": "959b4942", "metadata": { "Collapsed": "false" }, "source": [ "Lastly, we need to combine the stochastic and deterministic price inputs. We do this by creating a new dataframe with the right dimensions and indexes, and then populate it according to the start and end times defined above." ] }, { "cell_type": "code", "execution_count": 15, "id": "2aeb25a8", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "# Creating a new price dataframe which will combine both stochastic and deterministic price\n", "combined_price = pd.DataFrame(index=deterministic_price.index, columns=list(range(0,n_prices)))\n", "\n", "# Loop over the new price array and assign stochastic and deterministic prices\n", "\n", "for j in range(0,n_prices):\n", " deterministic_price_multi_dimension_array[j]=deterministic_price\n", "for i in pd.date_range(stochastic_prices_start,stochastic_prices_end,freq='h'):\n", " combined_price.loc[i] = stochastic_prices_from_file.loc[i]\n", "for i in pd.date_range(deterministic_price_start,(deterministic_price_end),freq='h'):\n", " combined_price.loc[i] = deterministic_price_multi_dimension_array.loc[i]" ] }, { "cell_type": "markdown", "id": "e35dc2a0", "metadata": { "Collapsed": "false" }, "source": [ "Then we can plot out the resulting combined price." ] }, { "cell_type": "code", "execution_count": 16, "id": "8d09af7b", "metadata": { "Collapsed": "false" }, "outputs": [ { "data": { "application/vnd.plotly.v1+json": { "config": { "plotlyServerURL": "https://plot.ly" }, "data": [ { "hovertemplate": "=0
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "0", "line": { "color": "#636efa", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "0", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ 38.688924790028935, 38.91648373357578, 37.13397283607992, 28.567144764921423, 32.90962859918502, 34.43855641685243, 35.47086224821935, 43.884362898890004, 46.48571170034651, 51.83157067457943, 42.77078719357291, 37.87059975592636, 38.72012568912313, 36.11937041948169, 38.194048733917754, 38.26022728649826, 38.05804786206631, 56.71036696579608, 59.00434355483017, 55.77624532195394, 43.24421031420755, 48.317102814015996, 38.237187361867846, 42.371404453779654, 27.242, 26.622, 25.732, 25.392, 25.992, 27.402, 28.942, 32.182, 33.082, 32.342, 30.912, 30.162, 30.062, 29.562, 29.462, 29.512, 29.672, 30.072, 29.552, 28.862, 28.412, 28.072, 27.162, 25.502, 26.192, 25.222, 24.052, 23.892, 23.682, 26.092, 28.202, 30.902, 31.572, 31.462, 31.172, 30.912, 30.572, 30.602, 30.632, 31.062, 32.082, 36.262, 34.472, 32.182, 31.492, 30.732, 29.712, 28.982 ], "yaxis": "y" }, { "hovertemplate": "=1
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "1", "line": { "color": "#EF553B", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "1", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ 30.84143666529853, 28.47852434471662, 29.923425146009553, 25.7385904884098, 30.64244779413558, 34.62346957920782, 30.47929369560378, 51.591232223645896, 49.47362653799953, 48.73569665784232, 41.49396971475139, 37.42526162689267, 42.77109897478207, 43.060226041834014, 46.10862607282206, 51.175027264422994, 47.07770347974001, 47.71087538922627, 56.79788602641253, 58.24584690285616, 50.687626812451406, 41.46123136424681, 47.593982027701074, 35.49695286383878, 27.242, 26.622, 25.732, 25.392, 25.992, 27.402, 28.942, 32.182, 33.082, 32.342, 30.912, 30.162, 30.062, 29.562, 29.462, 29.512, 29.672, 30.072, 29.552, 28.862, 28.412, 28.072, 27.162, 25.502, 26.192, 25.222, 24.052, 23.892, 23.682, 26.092, 28.202, 30.902, 31.572, 31.462, 31.172, 30.912, 30.572, 30.602, 30.632, 31.062, 32.082, 36.262, 34.472, 32.182, 31.492, 30.732, 29.712, 28.982 ], "yaxis": "y" }, { "hovertemplate": "=2
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "2", "line": { "color": "#00cc96", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "2", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ 39.30318270980665, 33.84338460894348, 31.28058529475953, 33.42898384611474, 34.66852142919224, 33.9696063734057, 35.03191004478626, 43.362871627306525, 44.29502173658242, 56.201060307257364, 37.82846182019187, 44.11692579762013, 41.50705054972993, 38.30018021897476, 37.37508689986337, 39.21637545527792, 40.79919610418443, 55.5544635153597, 60.1729813513571, 58.270617107738786, 49.48684060432931, 45.007856590396585, 42.574140822722775, 46.26549880390542, 27.242, 26.622, 25.732, 25.392, 25.992, 27.402, 28.942, 32.182, 33.082, 32.342, 30.912, 30.162, 30.062, 29.562, 29.462, 29.512, 29.672, 30.072, 29.552, 28.862, 28.412, 28.072, 27.162, 25.502, 26.192, 25.222, 24.052, 23.892, 23.682, 26.092, 28.202, 30.902, 31.572, 31.462, 31.172, 30.912, 30.572, 30.602, 30.632, 31.062, 32.082, 36.262, 34.472, 32.182, 31.492, 30.732, 29.712, 28.982 ], "yaxis": "y" }, { "hovertemplate": "=3
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "3", "line": { "color": "#ab63fa", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "3", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ 43.1222213657023, 36.85633331407592, 40.11727135214596, 39.93746190323393, 47.708656045739914, 41.136482401465926, 41.90296077026431, 48.16582265504936, 54.17468219492054, 50.87969915242537, 42.2639939367465, 41.93283958287484, 42.14680390729975, 35.63193002550175, 36.57564545317568, 38.05367612977148, 45.250958178628906, 49.06669510663274, 58.237504769322314, 54.60177345780331, 49.71405910604083, 43.138390473686016, 36.780848917322885, 38.24747762487639, 27.242, 26.622, 25.732, 25.392, 25.992, 27.402, 28.942, 32.182, 33.082, 32.342, 30.912, 30.162, 30.062, 29.562, 29.462, 29.512, 29.672, 30.072, 29.552, 28.862, 28.412, 28.072, 27.162, 25.502, 26.192, 25.222, 24.052, 23.892, 23.682, 26.092, 28.202, 30.902, 31.572, 31.462, 31.172, 30.912, 30.572, 30.602, 30.632, 31.062, 32.082, 36.262, 34.472, 32.182, 31.492, 30.732, 29.712, 28.982 ], "yaxis": "y" }, { "hovertemplate": "=4
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "4", "line": { "color": "#FFA15A", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "4", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ 31.399707877439493, 40.44714002248111, 33.28553820479103, 39.5702239851003, 36.96327342983141, 35.48029110424704, 37.54483625037337, 43.549433968320535, 47.94751030975122, 54.291573962141264, 49.96689611434518, 42.41688837159459, 38.80397234301293, 39.99991112626061, 44.01463732532422, 46.202766220740195, 43.69050794432827, 54.54647867289708, 57.513099511561066, 57.317744778949475, 37.70655838878481, 40.50753566627801, 49.548370526927386, 43.22821414518731, 27.242, 26.622, 25.732, 25.392, 25.992, 27.402, 28.942, 32.182, 33.082, 32.342, 30.912, 30.162, 30.062, 29.562, 29.462, 29.512, 29.672, 30.072, 29.552, 28.862, 28.412, 28.072, 27.162, 25.502, 26.192, 25.222, 24.052, 23.892, 23.682, 26.092, 28.202, 30.902, 31.572, 31.462, 31.172, 30.912, 30.572, 30.602, 30.632, 31.062, 32.082, 36.262, 34.472, 32.182, 31.492, 30.732, 29.712, 28.982 ], "yaxis": "y" }, { "hovertemplate": "=5
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "5", "line": { "color": "#19d3f3", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "5", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ 38.211738224562396, 34.47371124763938, 34.7280738365677, 31.55864788701061, 33.749174228915635, 41.83473160042925, 33.30079368907467, 48.468647031564394, 53.74082984083143, 54.693474100441335, 54.10620785334244, 46.175475331181204, 48.31661977281291, 46.296312210030116, 48.48044709718775, 47.6088277963454, 44.29423031503364, 52.04463673650779, 55.195022080319625, 56.95479156611447, 46.24326639374972, 44.108610402454936, 38.09788889449211, 36.816091953881276, 27.242, 26.622, 25.732, 25.392, 25.992, 27.402, 28.942, 32.182, 33.082, 32.342, 30.912, 30.162, 30.062, 29.562, 29.462, 29.512, 29.672, 30.072, 29.552, 28.862, 28.412, 28.072, 27.162, 25.502, 26.192, 25.222, 24.052, 23.892, 23.682, 26.092, 28.202, 30.902, 31.572, 31.462, 31.172, 30.912, 30.572, 30.602, 30.632, 31.062, 32.082, 36.262, 34.472, 32.182, 31.492, 30.732, 29.712, 28.982 ], "yaxis": "y" }, { "hovertemplate": "=6
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "6", "line": { "color": "#FF6692", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "6", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ 42.479485028495645, 33.75162850526158, 34.09604723329545, 38.290841505691326, 38.70346824980726, 33.78857578711016, 41.63094728212825, 53.58639585781828, 50.93594863387132, 58.22479969565341, 44.12831968551308, 45.121995478221244, 40.81178048525122, 45.36328446516111, 50.67242464460132, 44.795150046331486, 50.9056494242492, 56.7013936281821, 54.10928992277162, 53.898014509384915, 47.60151878277625, 41.700816040923726, 33.73190908915484, 42.98743348732935, 27.242, 26.622, 25.732, 25.392, 25.992, 27.402, 28.942, 32.182, 33.082, 32.342, 30.912, 30.162, 30.062, 29.562, 29.462, 29.512, 29.672, 30.072, 29.552, 28.862, 28.412, 28.072, 27.162, 25.502, 26.192, 25.222, 24.052, 23.892, 23.682, 26.092, 28.202, 30.902, 31.572, 31.462, 31.172, 30.912, 30.572, 30.602, 30.632, 31.062, 32.082, 36.262, 34.472, 32.182, 31.492, 30.732, 29.712, 28.982 ], "yaxis": "y" }, { "hovertemplate": "=7
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "7", "line": { "color": "#B6E880", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "7", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ 29.83885677823433, 33.6993463496901, 32.08503270612679, 37.527191611735795, 31.802267240063458, 28.953163992553172, 42.22412721160745, 43.27692227013378, 54.03181777559293, 53.48550785435142, 49.39106615383736, 49.68323133044724, 47.99123597938316, 32.378365450187964, 40.079081432670144, 39.29150257508463, 46.36238144501525, 53.91189541744889, 73.96141458604406, 70.85271509694213, 58.95601014294316, 51.10217655427115, 51.82626868327121, 46.24975583110782, 27.242, 26.622, 25.732, 25.392, 25.992, 27.402, 28.942, 32.182, 33.082, 32.342, 30.912, 30.162, 30.062, 29.562, 29.462, 29.512, 29.672, 30.072, 29.552, 28.862, 28.412, 28.072, 27.162, 25.502, 26.192, 25.222, 24.052, 23.892, 23.682, 26.092, 28.202, 30.902, 31.572, 31.462, 31.172, 30.912, 30.572, 30.602, 30.632, 31.062, 32.082, 36.262, 34.472, 32.182, 31.492, 30.732, 29.712, 28.982 ], "yaxis": "y" }, { "hovertemplate": "=8
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "8", "line": { "color": "#FF97FF", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "8", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ 29.93227883576153, 36.98775697574074, 36.42658995902406, 28.99040988121767, 29.553703261597807, 39.69066832659008, 40.85321844893519, 46.69187486266235, 53.41606943876772, 64.63548367033422, 60.57510426310269, 40.777990024016965, 53.715753720173545, 42.46518071355044, 41.311691911561276, 51.563778217252654, 46.659760523543746, 60.11102240027948, 56.121528169768595, 59.41414482942551, 43.54022872965482, 40.2457071697066, 46.92059468036083, 39.40723132420954, 27.242, 26.622, 25.732, 25.392, 25.992, 27.402, 28.942, 32.182, 33.082, 32.342, 30.912, 30.162, 30.062, 29.562, 29.462, 29.512, 29.672, 30.072, 29.552, 28.862, 28.412, 28.072, 27.162, 25.502, 26.192, 25.222, 24.052, 23.892, 23.682, 26.092, 28.202, 30.902, 31.572, 31.462, 31.172, 30.912, 30.572, 30.602, 30.632, 31.062, 32.082, 36.262, 34.472, 32.182, 31.492, 30.732, 29.712, 28.982 ], "yaxis": "y" }, { "hovertemplate": "=9
Time=%{x}
EUR/MWh=%{y}", "legendgroup": "9", "line": { "color": "#FECB52", "dash": "solid" }, "marker": { "symbol": "circle" }, "mode": "lines", "name": "9", "orientation": "v", "showlegend": true, "type": "scatter", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ 46.54866447289529, 38.79637418511707, 45.003988815437644, 40.88554303114959, 46.706920769563055, 46.564680245777616, 38.9045882715515, 51.35944374090656, 58.50087160008804, 54.93922457297462, 45.3393497791437, 45.9148773821524, 41.33848577095818, 34.72964629465234, 49.71196176709573, 37.664474969438864, 44.22456435168797, 53.38040630699615, 55.876500217206456, 53.16595109294248, 49.330592191903854, 39.75846030900367, 42.52990511682548, 41.27354268730056, 27.242, 26.622, 25.732, 25.392, 25.992, 27.402, 28.942, 32.182, 33.082, 32.342, 30.912, 30.162, 30.062, 29.562, 29.462, 29.512, 29.672, 30.072, 29.552, 28.862, 28.412, 28.072, 27.162, 25.502, 26.192, 25.222, 24.052, 23.892, 23.682, 26.092, 28.202, 30.902, 31.572, 31.462, 31.172, 30.912, 30.572, 30.602, 30.632, 31.062, 32.082, 36.262, 34.472, 32.182, 31.492, 30.732, 29.712, 28.982 ], "yaxis": "y" } ], "layout": { "legend": { "title": { "text": "" }, "tracegroupgap": 0 }, "template": { "data": { "bar": [ { "error_x": { "color": "#2a3f5f" }, "error_y": { "color": "#2a3f5f" }, "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "bar" } ], "barpolar": [ { "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "barpolar" } ], "carpet": [ { "aaxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "baxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "type": "carpet" } ], "choropleth": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "choropleth" } ], "contour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "contour" } ], "contourcarpet": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "contourcarpet" } ], "heatmap": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmap" } ], "heatmapgl": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmapgl" } ], "histogram": [ { "marker": { "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "histogram" } ], "histogram2d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2d" } ], "histogram2dcontour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2dcontour" } ], "mesh3d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "mesh3d" } ], "parcoords": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "parcoords" } ], "pie": [ { "automargin": true, "type": "pie" } ], "scatter": [ { "fillpattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 }, "type": "scatter" } ], "scatter3d": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter3d" } ], "scattercarpet": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattercarpet" } ], "scattergeo": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergeo" } ], "scattergl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergl" } ], "scattermapbox": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattermapbox" } ], "scatterpolar": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolar" } ], "scatterpolargl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolargl" } ], "scatterternary": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterternary" } ], "surface": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "surface" } ], "table": [ { "cells": { "fill": { "color": "#EBF0F8" }, "line": { "color": "white" } }, "header": { "fill": { "color": "#C8D4E3" }, "line": { "color": "white" } }, "type": "table" } ] }, "layout": { "annotationdefaults": { "arrowcolor": "#2a3f5f", "arrowhead": 0, "arrowwidth": 1 }, "autotypenumbers": "strict", "coloraxis": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "colorscale": { "diverging": [ [ 0, "#8e0152" ], [ 0.1, "#c51b7d" ], [ 0.2, "#de77ae" ], [ 0.3, "#f1b6da" ], [ 0.4, "#fde0ef" ], [ 0.5, "#f7f7f7" ], [ 0.6, "#e6f5d0" ], [ 0.7, "#b8e186" ], [ 0.8, "#7fbc41" ], [ 0.9, "#4d9221" ], [ 1, "#276419" ] ], "sequential": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "sequentialminus": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ] }, "colorway": [ "#636efa", "#EF553B", "#00cc96", "#ab63fa", "#FFA15A", "#19d3f3", "#FF6692", "#B6E880", "#FF97FF", "#FECB52" ], "font": { "color": "#2a3f5f" }, "geo": { "bgcolor": "white", "lakecolor": "white", "landcolor": "#E5ECF6", "showlakes": true, "showland": true, "subunitcolor": "white" }, "hoverlabel": { "align": "left" }, "hovermode": "closest", "mapbox": { "style": "light" }, "paper_bgcolor": "white", "plot_bgcolor": "#E5ECF6", "polar": { "angularaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "radialaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "scene": { "xaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "yaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "zaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" } }, "shapedefaults": { "line": { "color": "#2a3f5f" } }, "ternary": { "aaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "baxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "caxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "title": { "x": 0.05 }, "xaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 }, "yaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 } } }, "title": { "text": "Combined price input" }, "xaxis": { "anchor": "y", "domain": [ 0.0, 1.0 ], "title": { "text": "Time" } }, "yaxis": { "anchor": "x", "domain": [ 0.0, 1.0 ], "title": { "text": "EUR/MWh" } } } }, "text/html": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Plot the combined price\n", "combined_price.plot(title=\"Combined price input\", labels=dict(index=\"Time\", value=\"EUR/MWh\", variable=\"\"))" ] }, { "cell_type": "markdown", "id": "7706d39e", "metadata": { "Collapsed": "false" }, "source": [ "This price is then set as the day ahead market price to consider for all scenarios. We also define a slightly higher buy-back price" ] }, { "cell_type": "code", "execution_count": 17, "id": "08e56706", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "day_ahead_market.sale_price.set(combined_price)\n", "\n", "# Make sure that the buy price is slightly higher, so no arbitrage occurs\n", "\n", "day_ahead_market.buy_price.set(day_ahead_market.sale_price.get()+0.1)" ] }, { "cell_type": "markdown", "id": "ee353fa2", "metadata": { "Collapsed": "false" }, "source": [ "### Create bid groups and configure limits" ] }, { "cell_type": "markdown", "id": "56a6e782", "metadata": { "Collapsed": "false" }, "source": [ "Now we need to create a bid group, which is the connection between a set of hydropower plants and their bid matrix." ] }, { "cell_type": "code", "execution_count": 18, "id": "1e486eb3", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "# Create a bid group\n", "bg=shop.model.bid_group.add_object('bg')\n", "\n", "# Add all plants in the system to the bid group\n", "for plant in shop.model.plant:\n", " bg.connect_to(plant)\n", "\n", "# Defining which periods the bid curve should consider\n", "day_ahead_market.bid_flag.set(pd.Series([1,0],index=[stochastic_prices_start,stochastic_prices_end]))" ] }, { "cell_type": "markdown", "id": "7093d764", "metadata": { "Collapsed": "false" }, "source": [ "## Running multi price scenarios in SHOP" ] }, { "cell_type": "markdown", "id": "54f57f77", "metadata": { "Collapsed": "false" }, "source": [ "It is time to optimize. We call the predefined function run_model, which calls for five full and three incremental iterations. Since we have defined scenarios in the SHOP instance earlier, all scenarios will be computed and optimized with a single call." ] }, { "cell_type": "code", "execution_count": 19, "id": "dc0b9363", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "#Optimize model by calling \"run_model\" bp.py\n", "run_model(shop)" ] }, { "cell_type": "markdown", "id": "7b00dfd0", "metadata": { "Collapsed": "false" }, "source": [ "## Creating and plotting the bid matrix" ] }, { "cell_type": "markdown", "id": "3102ba50", "metadata": { "Collapsed": "false" }, "source": [ "Once SHOP has finished optimizing all scenarios, we can retrive and start processing the bid matrix the way we want it." ] }, { "cell_type": "code", "execution_count": 20, "id": "3a635767", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "# Get bid matrix as an array\n", "bid_result=bg.bid_curves.get()\n", "\n", "# Convert bid matrix to a dataframe structure of choice\n", "bid_matrix=pd.DataFrame(index=bid_result[0].index)\n", "for t in range (0, 23):\n", " bid_matrix[t]=bid_result[t].values\n", "\n", "# Transpose the bid matrix if necessary depending on the viewing needs \n", "bid_matrix_transposed=bid_matrix.transpose()" ] }, { "cell_type": "markdown", "id": "d8c18089", "metadata": { "Collapsed": "false" }, "source": [ "When we are satisfied with a data structure that fulfill our needs, we can either print it or plot it to review it" ] }, { "cell_type": "code", "execution_count": 21, "id": "5c05c2b7", "metadata": { "Collapsed": "false" }, "outputs": [ { "data": { "application/vnd.plotly.v1+json": { "config": { "plotlyServerURL": "https://plot.ly" }, "data": [ { "coloraxis": "coloraxis", "hovertemplate": "x: %{x}
y: %{y}
color: %{z}", "name": "0", "type": "heatmap", "x": [ 0.0 ], "xaxis": "x", "y": [ 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22 ], "yaxis": "y", "z": [ [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ], [ 0.0 ] ] } ], "layout": { "coloraxis": { "colorscale": [ [ 0.0, "rgb(158,1,66)" ], [ 0.1, "rgb(213,62,79)" ], [ 0.2, "rgb(244,109,67)" ], [ 0.3, "rgb(253,174,97)" ], [ 0.4, "rgb(254,224,139)" ], [ 0.5, "rgb(255,255,191)" ], [ 0.6, "rgb(230,245,152)" ], [ 0.7, "rgb(171,221,164)" ], [ 0.8, "rgb(102,194,165)" ], [ 0.9, "rgb(50,136,189)" ], [ 1.0, "rgb(94,79,162)" ] ] }, "margin": { "t": 60 }, "template": { "data": { "bar": [ { "error_x": { "color": "#2a3f5f" }, "error_y": { "color": "#2a3f5f" }, "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "bar" } ], "barpolar": [ { "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "barpolar" } ], "carpet": [ { "aaxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "baxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "type": "carpet" } ], "choropleth": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "choropleth" } ], "contour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "contour" } ], "contourcarpet": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "contourcarpet" } ], "heatmap": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmap" } ], "heatmapgl": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmapgl" } ], "histogram": [ { "marker": { "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "histogram" } ], "histogram2d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2d" } ], "histogram2dcontour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2dcontour" } ], "mesh3d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "mesh3d" } ], "parcoords": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "parcoords" } ], "pie": [ { "automargin": true, "type": "pie" } ], "scatter": [ { "fillpattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 }, "type": "scatter" } ], "scatter3d": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter3d" } ], "scattercarpet": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattercarpet" } ], "scattergeo": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergeo" } ], "scattergl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergl" } ], "scattermapbox": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattermapbox" } ], "scatterpolar": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolar" } ], "scatterpolargl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolargl" } ], "scatterternary": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterternary" } ], "surface": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "surface" } ], "table": [ { "cells": { "fill": { "color": "#EBF0F8" }, "line": { "color": "white" } }, "header": { "fill": { "color": "#C8D4E3" }, "line": { "color": "white" } }, "type": "table" } ] }, "layout": { "annotationdefaults": { "arrowcolor": "#2a3f5f", "arrowhead": 0, "arrowwidth": 1 }, "autotypenumbers": "strict", "coloraxis": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "colorscale": { "diverging": [ [ 0, "#8e0152" ], [ 0.1, "#c51b7d" ], [ 0.2, "#de77ae" ], [ 0.3, "#f1b6da" ], [ 0.4, "#fde0ef" ], [ 0.5, "#f7f7f7" ], [ 0.6, "#e6f5d0" ], [ 0.7, "#b8e186" ], [ 0.8, "#7fbc41" ], [ 0.9, "#4d9221" ], [ 1, "#276419" ] ], "sequential": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "sequentialminus": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ] }, "colorway": [ "#636efa", "#EF553B", "#00cc96", "#ab63fa", "#FFA15A", "#19d3f3", "#FF6692", "#B6E880", "#FF97FF", "#FECB52" ], "font": { "color": "#2a3f5f" }, "geo": { "bgcolor": "white", "lakecolor": "white", "landcolor": "#E5ECF6", "showlakes": true, "showland": true, "subunitcolor": "white" }, "hoverlabel": { "align": "left" }, "hovermode": "closest", "mapbox": { "style": "light" }, "paper_bgcolor": "white", "plot_bgcolor": "#E5ECF6", "polar": { "angularaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "radialaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "scene": { "xaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "yaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "zaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" } }, "shapedefaults": { "line": { "color": "#2a3f5f" } }, "ternary": { "aaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "baxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "caxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "title": { "x": 0.05 }, "xaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 }, "yaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 } } }, "title": { "text": "Bid matrix heatmapped (and inverted compared to normal bid matrix)" }, "xaxis": { "anchor": "y", "constrain": "domain", "domain": [ 0.0, 1.0 ], "scaleanchor": "y", "title": { "text": "Market price" } }, "yaxis": { "anchor": "x", "autorange": true, "constrain": "domain", "domain": [ 0.0, 1.0 ], "title": { "text": "Hours" } } } }, "text/html": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Plotting bid matrices with different properties\n", "fig = px.imshow(bid_matrix.transpose(), color_continuous_scale='spectral')\n", "fig.update_layout(title=\"Bid matrix heatmapped (and inverted compared to normal bid matrix)\", xaxis_title =\"Market price\", yaxis_title=\"Hours\")\n", "fig.update_yaxes(autorange=True) \n", "fig.show()" ] }, { "cell_type": "code", "execution_count": 22, "id": "b4e75ac8", "metadata": { "Collapsed": "false" }, "outputs": [ { "data": { "application/vnd.plotly.v1+json": { "config": { "plotlyServerURL": "https://plot.ly" }, "data": [ { "alignmentgroup": "True", "hovertemplate": "=0.0
Hour [h]=%{x}
Market price=%{y}", "legendgroup": "0.0", "marker": { "color": "#636efa", "pattern": { "shape": "" } }, "name": "0.0", "offsetgroup": "0.0", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22 ], "xaxis": "x", "y": [ 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 ], "yaxis": "y" } ], "layout": { "barmode": "group", "legend": { "title": { "text": "" }, "tracegroupgap": 0 }, "template": { "data": { "bar": [ { "error_x": { "color": "#2a3f5f" }, "error_y": { "color": "#2a3f5f" }, "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "bar" } ], "barpolar": [ { "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "barpolar" } ], "carpet": [ { "aaxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "baxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "type": "carpet" } ], "choropleth": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "choropleth" } ], "contour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "contour" } ], "contourcarpet": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "contourcarpet" } ], "heatmap": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmap" } ], "heatmapgl": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmapgl" } ], "histogram": [ { "marker": { "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "histogram" } ], "histogram2d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2d" } ], "histogram2dcontour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2dcontour" } ], "mesh3d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "mesh3d" } ], "parcoords": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "parcoords" } ], "pie": [ { "automargin": true, "type": "pie" } ], "scatter": [ { "fillpattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 }, "type": "scatter" } ], "scatter3d": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter3d" } ], "scattercarpet": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattercarpet" } ], "scattergeo": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergeo" } ], "scattergl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergl" } ], "scattermapbox": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattermapbox" } ], "scatterpolar": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolar" } ], "scatterpolargl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolargl" } ], "scatterternary": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterternary" } ], "surface": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "surface" } ], "table": [ { "cells": { "fill": { "color": "#EBF0F8" }, "line": { "color": "white" } }, "header": { "fill": { "color": "#C8D4E3" }, "line": { "color": "white" } }, "type": "table" } ] }, "layout": { "annotationdefaults": { "arrowcolor": "#2a3f5f", "arrowhead": 0, "arrowwidth": 1 }, "autotypenumbers": "strict", "coloraxis": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "colorscale": { "diverging": [ [ 0, "#8e0152" ], [ 0.1, "#c51b7d" ], [ 0.2, "#de77ae" ], [ 0.3, "#f1b6da" ], [ 0.4, "#fde0ef" ], [ 0.5, "#f7f7f7" ], [ 0.6, "#e6f5d0" ], [ 0.7, "#b8e186" ], [ 0.8, "#7fbc41" ], [ 0.9, "#4d9221" ], [ 1, "#276419" ] ], "sequential": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "sequentialminus": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ] }, "colorway": [ "#636efa", "#EF553B", "#00cc96", "#ab63fa", "#FFA15A", "#19d3f3", "#FF6692", "#B6E880", "#FF97FF", "#FECB52" ], "font": { "color": "#2a3f5f" }, "geo": { "bgcolor": "white", "lakecolor": "white", "landcolor": "#E5ECF6", "showlakes": true, "showland": true, "subunitcolor": "white" }, "hoverlabel": { "align": "left" }, "hovermode": "closest", "mapbox": { "style": "light" }, "paper_bgcolor": "white", "plot_bgcolor": "#E5ECF6", "polar": { "angularaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "radialaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "scene": { "xaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "yaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "zaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" } }, "shapedefaults": { "line": { "color": "#2a3f5f" } }, "ternary": { "aaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "baxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "caxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "title": { "x": 0.05 }, "xaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 }, "yaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 } } }, "title": { "text": "Bid matrix per hour" }, "xaxis": { "anchor": "y", "domain": [ 0.0, 1.0 ], "title": { "text": "Hour [h]" } }, "yaxis": { "anchor": "x", "domain": [ 0.0, 1.0 ], "title": { "text": "Market price" } } } }, "text/html": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Plotting bid matrices with different properties\n", "bid_matrix_transposed.plot.bar(title=\"Bid matrix per hour\", labels=dict(index=\"Hour [h]\", value=\"Market price\", variable=\"\")).update_layout(barmode='group')" ] }, { "cell_type": "markdown", "id": "f40d5b37", "metadata": { "Collapsed": "false" }, "source": [ "## Plotting other results" ] }, { "cell_type": "markdown", "id": "f23fa931", "metadata": { "Collapsed": "false" }, "source": [ "If we want to see how each scenario suggest to produce, we can of course have a look at that as well" ] }, { "cell_type": "code", "execution_count": 23, "id": "0f890bdb", "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "# Get the optimal production value(s)\n", "optimal_production=day_ahead_market.sale.get()" ] }, { "cell_type": "code", "execution_count": 24, "id": "b5557722", "metadata": { "Collapsed": "false" }, "outputs": [ { "data": { "application/vnd.plotly.v1+json": { "config": { "plotlyServerURL": "https://plot.ly" }, "data": [ { "alignmentgroup": "True", "hovertemplate": "=0
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "0", "marker": { "color": "#636efa", "pattern": { "shape": "" } }, "name": "0", "offsetgroup": "0", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -521.1960606086715, -520.620030926564, -514.370085578086, -366.50322869796923, -473.9251354923942, -495.0343130180835, -505.0236904838023, -563.2455746093333, -561.8482397151829, -560.4472054706848, -559.0442184020047, -514.9895566029824, -512.5718667351299, -505.759731267397, -513.2638460367926, -510.52775478988514, -503.41254125888497, -549.6381866574892, -546.8394751189442, -543.4117314864736, -537.6339328838885, -541.76869203694, -533.0660053338179, -537.2409319310432, -176.5295199372248, -167.88311480812158, -152.3727323901242, -148.7176238586118, -166.42203186992126, -183.9040208776829, -289.1790496723868, -452.11515014090276, -465.27122303200844, -449.3230789878139, -359.4464023508553, -342.2765099526191, -341.1796137878189, -340.08273257439873, -338.98586631235906, -337.88901500169897, -336.7921786424189, -339.1700040796491, -334.5720231500111, -333.4752316448715, -232.4318818423758, -229.44040974057103, -176.6201347057092, -159.72844760932963, -172.4835253432682, -158.4059432460981, -146.26552089830497, -141.0166077453809, -141.11072128192865, -161.3124162812524, -224.41438000501407, -333.62192828599103, -335.3747540454959, -334.09094046534824, -332.8071418365805, -331.52335815919287, -327.88260725332697, -327.5406259473661, -327.7095905041617, -326.4258666322941, -331.47045507171197, -434.1999928402353, -425.03091924955214, -327.406097259542, -326.02111814620895, -323.9461147212547, -317.17861563996064, -215.24492976216197 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=1
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "1", "marker": { "color": "#EF553B", "pattern": { "shape": "" } }, "name": "1", "offsetgroup": "1", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -411.07001153659303, -354.3256613669856, -383.9202037955065, -209.93337629350333, -404.1807714876737, -499.2896611102433, -446.4797747585759, -564.9544623223526, -561.8496517646382, -560.4503962020177, -559.0472453849237, -514.9906360000973, -558.3477759617738, -556.653431881515, -551.1522930873573, -554.232192843377, -549.7939018715307, -544.5690517706961, -544.2172785818274, -544.5241162568656, -544.6281382236382, -537.2779918787537, -536.6825342876905, -487.41468937578975, -187.73732111103746, -168.28124510781345, -167.48518625827285, -150.56631608561065, -167.4887763183259, -186.24164479236214, -349.3225843825902, -453.82282445984265, -471.1971407198311, -454.36463867772085, -360.9133407621165, -353.858159241232, -346.08024612408684, -341.37557805418396, -340.2786860478483, -339.18180899287563, -341.59633013559727, -348.14475586871276, -339.25893790669005, -334.6607871033276, -233.4268258003039, -232.25075527625, -215.59198123220804, -162.07051766217884, -173.85492149291636, -161.43612340861364, -146.39827156747575, -146.27440378423157, -146.15021894089867, -171.7069686460792, -224.99566979719754, -337.44449630649024, -342.8388317834425, -341.45363112355585, -340.06844541503307, -332.1350595929425, -330.8512651224577, -329.5674856033362, -330.5445129592646, -332.64249066316785, -331.9843977322797, -434.93009949469723, -425.74386811250196, -327.919908727637, -326.5349038696603, -325.1499139630468, -225.52787919730872, -219.59442329679507 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=2
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "2", "marker": { "color": "#00cc96", "pattern": { "shape": "" } }, "name": "2", "offsetgroup": "2", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -521.1960606086715, -487.6494071221921, -420.08846756893445, -460.9060001538972, -499.05461063971154, -487.1726213127128, -496.8802257105996, -562.7226425421978, -561.8499882978543, -562.1856355849361, -544.9657870755262, -557.5730357384512, -554.7909449964604, -542.1321007758809, -513.2622881453916, -538.9822866105927, -546.8638228290134, -547.4648141826718, -546.8242512020423, -544.5119662930288, -539.5795491412309, -539.930977707497, -536.671132983487, -535.3254364763369, -167.3057551779517, -166.69510612599407, -145.7089603129955, -143.791956158499, -149.87614213911982, -166.04645001439258, -287.27277377587154, -450.95081351722814, -457.3922692804674, -448.2117492778321, -346.86132515072427, -341.2861392873918, -340.1892402542214, -339.092356172431, -337.99548704202107, -336.8986328629906, -335.8017936353403, -334.70496935907005, -333.6081600341801, -326.4152748379733, -215.92051778737374, -215.57301407994055, -173.73260057991456, -146.54695045745163, -159.0662046340011, -146.28483914216284, -141.1708678822265, -141.09581783391369, -140.86356930662797, -157.76421827978038, -209.91632051361591, -333.2689689468435, -336.45762196887875, -330.79850485634444, -329.5611363085622, -328.3237827121597, -327.08644406713756, -325.8491203734954, -324.6118116312333, -323.3745178403508, -330.5868434143306, -434.04774437782737, -419.1531853844099, -327.30258445133745, -325.2230341209887, -318.42078646380395, -314.4055053439144, -212.0302107949368 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=3
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "3", "marker": { "color": "#ab63fa", "pattern": { "shape": "" } }, "name": "3", "offsetgroup": "3", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -568.255936282998, -509.21511309228623, -520.0428223179105, -519.3030872057032, -567.6579586062752, -518.3730281213461, -561.418853087828, -563.2457713645358, -561.8497295959959, -560.4505546414509, -559.0474455072631, -554.6333983336536, -554.7930420417287, -501.6931855738576, -495.7916365273262, -510.10994008664545, -548.8130181664754, -544.5679554161977, -544.2194452212298, -541.9072154637641, -539.5951627357219, -537.2832870371042, -495.74062564362515, -496.0608285118072, -268.6331165414805, -150.04401630846183, -143.6047030027484, -143.65405415738928, -143.45517967236296, -267.52903004674397, -286.691363083618, -449.6425862031498, -456.05713148399013, -446.90385421413066, -345.87641381189724, -340.3150180824882, -339.2181596078388, -338.1213160845742, -337.0244875126945, -335.9276738921994, -334.830875223089, -333.7340915053638, -332.6373227390229, -317.7035354459154, -177.56262153983178, -177.0513023638083, -173.75407675354182, -146.7212748950566, -159.01995264174386, -146.2669207295797, -141.15687698978294, -141.08182064642764, -140.85370125219885, -157.09020406979994, -173.22760316513006, -333.0986827290145, -331.8613241199435, -330.62398046225724, -329.38665175595577, -328.14933800103853, -324.3731077364883, -325.69605420905356, -324.4587853082911, -323.2215313589131, -328.0428471587779, -433.61183019840337, -418.73821720913634, -326.4801816491442, -324.9920875475176, -318.3006910443287, -216.51523821040496, -208.6884677448552 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=4
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "4", "marker": { "color": "#FFA15A", "pattern": { "shape": "" } }, "name": "4", "offsetgroup": "4", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -430.54526857949463, -520.6671627451043, -471.2766425268825, -519.3031063707798, -506.9517152726026, -499.2896343941742, -505.22624249864737, -562.7226366270254, -561.8499016017524, -560.4487647277908, -560.9295642245813, -555.9421430335491, -543.2617237844102, -551.9013549540144, -551.1507839017542, -552.5775219577265, -546.8806656387735, -547.4820734429682, -544.2210752976449, -543.4132420427135, -532.0622985186959, -537.2273011973833, -536.6299646690196, -534.3184212792456, -268.86240811872943, -151.4001355991568, -143.6543869971071, -143.57992192760216, -143.50426583725692, -267.6297814968061, -286.98555675138226, -450.252348828552, -456.6696562993317, -447.51358241678753, -346.4276262109569, -340.86481468756506, -339.76795201098787, -338.67110428579053, -337.57427151197373, -336.47745368953656, -335.3806508184793, -334.28386289880257, -333.1870899305054, -327.23799220879994, -215.7950362276287, -177.20657040392453, -173.896826972508, -146.74456778495343, -159.10499901162055, -146.306206229567, -141.19036930529836, -141.11537868336498, -140.8799885247588, -157.3100929028458, -210.06360878184447, -333.09615861244134, -333.92389833693807, -330.6236633816788, -329.3863306426701, -328.149012855019, -326.9117100187252, -325.6744221337887, -324.437149200209, -323.199891217987, -324.8048122410221, -433.6472613099671, -420.9508962527965, -327.16379122149516, -319.61254054289543, -318.3289713734512, -216.51523821040496, -208.6884677448552 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=5
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "5", "marker": { "color": "#19d3f3", "pattern": { "shape": "" } }, "name": "5", "offsetgroup": "5", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -515.8234274878303, -491.3190993684492, -499.31812152599946, -430.00193233079625, -473.9289985365724, -518.3777242079166, -466.7967197307354, -563.2511421193109, -561.8561117360077, -560.4570532238101, -561.1539352677564, -559.7566740005735, -558.3554995495052, -556.9503304436151, -551.159373162929, -552.7247841998646, -548.8222633603308, -544.5778974319935, -542.2665892911638, -543.4228595043276, -537.643720688862, -539.0518705374459, -499.21113489253105, -490.4179530409409, -167.50595825736804, -167.07377929185833, -143.74011522734423, -143.66578456461016, -150.08948225249108, -166.235843271415, -286.7341541256997, -450.98389163178143, -457.42154111662285, -448.24487436096814, -346.9284787812883, -341.3552433991281, -340.2583500995215, -339.1614717512953, -338.06460835445006, -336.9677599089848, -335.87092641489994, -334.7741078721961, -333.67730428087214, -332.58051564092875, -216.0777073780167, -177.37770178706563, -174.03030337031032, -148.5564909910558, -161.3274415627689, -146.7139974788265, -141.10798514704527, -141.15231962143727, -140.9461850752188, -159.39183616138666, -210.26684430049562, -333.5272119825583, -336.713929166427, -331.05675963418634, -329.8193968199726, -328.5820489571395, -327.3447160456867, -326.10739808561397, -324.87009507692215, -325.0753220878291, -330.8447803276673, -434.270851307884, -425.1041759571402, -327.5016547435319, -325.4211620782728, -318.611651004748, -216.57236341137497, -215.24492976216197 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=6
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "6", "marker": { "color": "#FF6692", "pattern": { "shape": "" } }, "name": "6", "offsetgroup": "6", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -521.1960606086715, -475.85220265666186, -478.4592892160958, -513.7384505623507, -513.0171723174785, -467.6680113244051, -517.7722890289774, -564.9544160547017, -561.8497746745295, -562.1899722508042, -559.0471036774156, -557.5783365863905, -551.7788318227981, -556.6553401960211, -554.4212663815421, -552.108317890747, -549.7955464293196, -547.4829519972604, -542.2583224068567, -541.9101231484618, -537.6350775252922, -537.2874657048466, -495.74455265595145, -534.0508551037105, -166.9611989393784, -150.06862433142777, -143.62218409360057, -143.5475487448237, -143.4727306474767, -165.75494458009308, -286.2415779814626, -442.142588636586, -456.585387661116, -447.40872557245115, -346.13694807397, -340.56371503821754, -339.46682174178767, -336.49583404270294, -335.4211394936241, -334.74493576308316, -335.11637710473184, -334.0195585652021, -332.92275497705265, -316.198247154747, -177.1284616963392, -176.61805398868427, -168.33620068509416, -146.54506089882295, -159.05325505361478, -146.28291674466843, -141.1731371721165, -140.94632481143924, -140.86478861558993, -157.1160097620782, -209.9523976504062, -326.02377068763866, -336.4291101198221, -330.7719429324624, -329.53458012142073, -328.2972322617592, -324.0407369063696, -325.8478283397365, -324.61052533421457, -323.373237280073, -329.36066478558257, -434.05825754700675, -419.16450121050127, -326.6613994022255, -319.817606086505, -317.1684833272768, -216.51523821040496, -208.6884677448552 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=7
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "7", "marker": { "color": "#B6E880", "pattern": { "shape": "" } }, "name": "7", "offsetgroup": "7", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -358.84426028919245, -421.7638521460262, -420.08845621446665, -460.90596566057485, -412.0378697510836, -352.4882256508195, -564.1367496918745, -562.7224752050367, -561.8502851361133, -560.4514347448797, -560.9326209721222, -561.1231990439882, -558.3505388452004, -494.69218088176336, -551.1550946768227, -550.1396780668952, -549.7950550367354, -547.4835346534766, -549.2605959261064, -546.9482766291482, -544.636134361558, -542.3241691233355, -540.0123809144812, -537.7007697349947, -281.2909475957733, -167.75350161200012, -150.44665377804924, -150.7986163290738, -166.99368399540498, -285.94902231044017, -335.0029291324221, -452.14024738065825, -466.9004217811419, -449.33596995324575, -359.6028766393858, -342.4231211287077, -341.32624535391716, -340.22938453050614, -339.1325386584752, -338.0357077378247, -336.93889176855373, -339.32198845640227, -334.71877705616424, -333.62200594103336, -232.7303741137272, -231.55430358967337, -176.79742126676274, -159.91548339471697, -173.7982584506732, -158.58610284576676, -146.31831276083707, -146.1942551566874, -141.15276829650082, -166.92539441825605, -224.62966980530874, -333.6976396434075, -335.45410958271754, -334.17031639257897, -332.8865381538209, -331.60277486644236, -328.8697174556085, -329.0495272485508, -327.76580881531237, -326.48210533345394, -331.53403128500156, -434.10710185308653, -424.9516921622835, -327.4697773787535, -326.0848186554292, -324.00899126896024, -219.33947462512452, -215.57955888884283 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=8
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "8", "marker": { "color": "#FF97FF", "pattern": { "shape": "" } }, "name": "8", "offsetgroup": "8", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -392.1798499810144, -509.6035587626409, -508.7359817743647, -366.5031724031329, -352.8749368819192, -518.336230097695, -517.772044544158, -563.2448441467636, -561.8490390281471, -563.2409449732473, -561.8519965729676, -554.6339194108552, -559.0968080767033, -556.6467011881637, -551.1176246658841, -554.1946796878652, -549.7569597473528, -549.6030086253882, -544.1834533247875, -545.0278678820898, -537.5972471336963, -537.2497174781618, -536.6531375481593, -537.5856117975338, -269.35608231494194, -166.94299050241798, -150.19315835344946, -143.6964254361059, -147.3640810918398, -269.81954990971224, -286.883067763476, -451.37745015700153, -459.4886754064006, -448.62460264242753, -347.107873795443, -341.86184019955857, -340.7649689178708, -339.6681125875628, -338.5712712086348, -337.47444478108713, -336.37763330491913, -335.2808367801312, -334.1840552067236, -333.0872885846957, -230.9611794766381, -215.578262811804, -176.553157652042, -159.5764051828894, -161.51561401041258, -154.46483085860604, -141.08501328861587, -141.0040012038229, -141.10043118493965, -160.26315220606043, -224.44501079992202, -333.4691175138183, -335.8996922204046, -333.93930677227814, -331.18939038570534, -328.4503269133722, -327.21301541197977, -325.9757188619678, -324.73843726333587, -326.36499614901555, -330.69971706580696, -433.95447559311026, -424.8021497062441, -327.356752247763, -325.27622933048025, -320.17884261217245, -216.22448539278537, -215.24492976216197 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=9
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "9", "marker": { "color": "#FECB52", "pattern": { "shape": "" } }, "name": "9", "offsetgroup": "9", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -573.7843718437973, -520.5800718344051, -566.0391136393663, -560.3096471212908, -567.1456046157068, -565.7598583292291, -517.7390069992492, -563.2048837112807, -561.8092758643102, -560.4098060733711, -559.0063779643187, -557.5368697919785, -551.7373401611684, -501.65882728506494, -551.1115815275632, -510.07578546021745, -546.8412222157569, -544.528623068123, -542.2162009498012, -539.9039558607925, -537.5918878010949, -532.0680575203555, -533.0226648523299, -530.7111278805687, -165.75342381162721, -149.5894985484992, -143.2882510479928, -143.21281451645496, -143.1371855505498, -164.66886807775197, -283.10570476384436, -437.8586720493045, -453.9932328931804, -442.51235058217713, -343.7131696900898, -338.1406172033234, -337.0437258646455, -319.6112017826175, -318.8017991609204, -317.99180027009123, -332.98256460225025, -331.8857480204486, -330.78894639002226, -314.69970983149005, -175.80406652164174, -175.15706455562074, -160.88071050460036, -146.1305670872884, -157.61321153407042, -145.65038542903054, -40.75092258450545, -40.661316233597944, -40.65816866710159, -157.0026742547384, -172.57306996303467, -325.9411783911285, -336.34326814888414, -333.36730428608826, -329.45229226660496, -328.2149465841625, -320.02232530331605, -324.9854886420616, -324.5670525129129, -323.32976663585305, -329.31590830403246, -433.992772665089, -419.1015987377489, -330.97336408149226, -319.7786264098744, -315.5910060569449, -216.51523821040496, -208.6884677448552 ], "yaxis": "y" } ], "layout": { "barmode": "relative", "legend": { "title": { "text": "" }, "tracegroupgap": 0 }, "template": { "data": { "bar": [ { "error_x": { "color": "#2a3f5f" }, "error_y": { "color": "#2a3f5f" }, "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "bar" } ], "barpolar": [ { "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "barpolar" } ], "carpet": [ { "aaxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "baxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "type": "carpet" } ], "choropleth": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "choropleth" } ], "contour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "contour" } ], "contourcarpet": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "contourcarpet" } ], "heatmap": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmap" } ], "heatmapgl": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmapgl" } ], "histogram": [ { "marker": { "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "histogram" } ], "histogram2d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2d" } ], "histogram2dcontour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2dcontour" } ], "mesh3d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "mesh3d" } ], "parcoords": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "parcoords" } ], "pie": [ { "automargin": true, "type": "pie" } ], "scatter": [ { "fillpattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 }, "type": "scatter" } ], "scatter3d": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter3d" } ], "scattercarpet": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattercarpet" } ], "scattergeo": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergeo" } ], "scattergl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergl" } ], "scattermapbox": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattermapbox" } ], "scatterpolar": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolar" } ], "scatterpolargl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolargl" } ], "scatterternary": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterternary" } ], "surface": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "surface" } ], "table": [ { "cells": { "fill": { "color": "#EBF0F8" }, "line": { "color": "white" } }, "header": { "fill": { "color": "#C8D4E3" }, "line": { "color": "white" } }, "type": "table" } ] }, "layout": { "annotationdefaults": { "arrowcolor": "#2a3f5f", "arrowhead": 0, "arrowwidth": 1 }, "autotypenumbers": "strict", "coloraxis": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "colorscale": { "diverging": [ [ 0, "#8e0152" ], [ 0.1, "#c51b7d" ], [ 0.2, "#de77ae" ], [ 0.3, "#f1b6da" ], [ 0.4, "#fde0ef" ], [ 0.5, "#f7f7f7" ], [ 0.6, "#e6f5d0" ], [ 0.7, "#b8e186" ], [ 0.8, "#7fbc41" ], [ 0.9, "#4d9221" ], [ 1, "#276419" ] ], "sequential": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "sequentialminus": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ] }, "colorway": [ "#636efa", "#EF553B", "#00cc96", "#ab63fa", "#FFA15A", "#19d3f3", "#FF6692", "#B6E880", "#FF97FF", "#FECB52" ], "font": { "color": "#2a3f5f" }, "geo": { "bgcolor": "white", "lakecolor": "white", "landcolor": "#E5ECF6", "showlakes": true, "showland": true, "subunitcolor": "white" }, "hoverlabel": { "align": "left" }, "hovermode": "closest", "mapbox": { "style": "light" }, "paper_bgcolor": "white", "plot_bgcolor": "#E5ECF6", "polar": { "angularaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "radialaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "scene": { "xaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "yaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "zaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" } }, "shapedefaults": { "line": { "color": "#2a3f5f" } }, "ternary": { "aaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "baxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "caxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "title": { "x": 0.05 }, "xaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 }, "yaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 } } }, "title": { "text": "Bid volumes per stochastic price #" }, "xaxis": { "anchor": "y", "domain": [ 0.0, 1.0 ], "title": { "text": "Time" } }, "yaxis": { "anchor": "x", "domain": [ 0.0, 1.0 ], "title": { "text": "Sale/Production [MW]" } } } }, "text/html": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "\n", "# Plot optimal production in different plot types\n", "optimal_production.plot.bar(title=\"Bid volumes per stochastic price #\", labels=dict(index=\"Time\", value=\"Sale/Production [MW]\", variable=\"\"))" ] }, { "cell_type": "code", "execution_count": 25, "id": "50bc0cd3", "metadata": { "Collapsed": "false" }, "outputs": [ { "data": { "application/vnd.plotly.v1+json": { "config": { "plotlyServerURL": "https://plot.ly" }, "data": [ { "alignmentgroup": "True", "hovertemplate": "=0
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "0", "marker": { "color": "#636efa", "pattern": { "shape": "" } }, "name": "0", "offsetgroup": "0", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -521.1960606086715, -520.620030926564, -514.370085578086, -366.50322869796923, -473.9251354923942, -495.0343130180835, -505.0236904838023, -563.2455746093333, -561.8482397151829, -560.4472054706848, -559.0442184020047, -514.9895566029824, -512.5718667351299, -505.759731267397, -513.2638460367926, -510.52775478988514, -503.41254125888497, -549.6381866574892, -546.8394751189442, -543.4117314864736, -537.6339328838885, -541.76869203694, -533.0660053338179, -537.2409319310432, -176.5295199372248, -167.88311480812158, -152.3727323901242, -148.7176238586118, -166.42203186992126, -183.9040208776829, -289.1790496723868, -452.11515014090276, -465.27122303200844, -449.3230789878139, -359.4464023508553, -342.2765099526191, -341.1796137878189, -340.08273257439873, -338.98586631235906, -337.88901500169897, -336.7921786424189, -339.1700040796491, -334.5720231500111, -333.4752316448715, -232.4318818423758, -229.44040974057103, -176.6201347057092, -159.72844760932963, -172.4835253432682, -158.4059432460981, -146.26552089830497, -141.0166077453809, -141.11072128192865, -161.3124162812524, -224.41438000501407, -333.62192828599103, -335.3747540454959, -334.09094046534824, -332.8071418365805, -331.52335815919287, -327.88260725332697, -327.5406259473661, -327.7095905041617, -326.4258666322941, -331.47045507171197, -434.1999928402353, -425.03091924955214, -327.406097259542, -326.02111814620895, -323.9461147212547, -317.17861563996064, -215.24492976216197 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=1
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "1", "marker": { "color": "#EF553B", "pattern": { "shape": "" } }, "name": "1", "offsetgroup": "1", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -411.07001153659303, -354.3256613669856, -383.9202037955065, -209.93337629350333, -404.1807714876737, -499.2896611102433, -446.4797747585759, -564.9544623223526, -561.8496517646382, -560.4503962020177, -559.0472453849237, -514.9906360000973, -558.3477759617738, -556.653431881515, -551.1522930873573, -554.232192843377, -549.7939018715307, -544.5690517706961, -544.2172785818274, -544.5241162568656, -544.6281382236382, -537.2779918787537, -536.6825342876905, -487.41468937578975, -187.73732111103746, -168.28124510781345, -167.48518625827285, -150.56631608561065, -167.4887763183259, -186.24164479236214, -349.3225843825902, -453.82282445984265, -471.1971407198311, -454.36463867772085, -360.9133407621165, -353.858159241232, -346.08024612408684, -341.37557805418396, -340.2786860478483, -339.18180899287563, -341.59633013559727, -348.14475586871276, -339.25893790669005, -334.6607871033276, -233.4268258003039, -232.25075527625, -215.59198123220804, -162.07051766217884, -173.85492149291636, -161.43612340861364, -146.39827156747575, -146.27440378423157, -146.15021894089867, -171.7069686460792, -224.99566979719754, -337.44449630649024, -342.8388317834425, -341.45363112355585, -340.06844541503307, -332.1350595929425, -330.8512651224577, -329.5674856033362, -330.5445129592646, -332.64249066316785, -331.9843977322797, -434.93009949469723, -425.74386811250196, -327.919908727637, -326.5349038696603, -325.1499139630468, -225.52787919730872, -219.59442329679507 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=2
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "2", "marker": { "color": "#00cc96", "pattern": { "shape": "" } }, "name": "2", "offsetgroup": "2", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -521.1960606086715, -487.6494071221921, -420.08846756893445, -460.9060001538972, -499.05461063971154, -487.1726213127128, -496.8802257105996, -562.7226425421978, -561.8499882978543, -562.1856355849361, -544.9657870755262, -557.5730357384512, -554.7909449964604, -542.1321007758809, -513.2622881453916, -538.9822866105927, -546.8638228290134, -547.4648141826718, -546.8242512020423, -544.5119662930288, -539.5795491412309, -539.930977707497, -536.671132983487, -535.3254364763369, -167.3057551779517, -166.69510612599407, -145.7089603129955, -143.791956158499, -149.87614213911982, -166.04645001439258, -287.27277377587154, -450.95081351722814, -457.3922692804674, -448.2117492778321, -346.86132515072427, -341.2861392873918, -340.1892402542214, -339.092356172431, -337.99548704202107, -336.8986328629906, -335.8017936353403, -334.70496935907005, -333.6081600341801, -326.4152748379733, -215.92051778737374, -215.57301407994055, -173.73260057991456, -146.54695045745163, -159.0662046340011, -146.28483914216284, -141.1708678822265, -141.09581783391369, -140.86356930662797, -157.76421827978038, -209.91632051361591, -333.2689689468435, -336.45762196887875, -330.79850485634444, -329.5611363085622, -328.3237827121597, -327.08644406713756, -325.8491203734954, -324.6118116312333, -323.3745178403508, -330.5868434143306, -434.04774437782737, -419.1531853844099, -327.30258445133745, -325.2230341209887, -318.42078646380395, -314.4055053439144, -212.0302107949368 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=3
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "3", "marker": { "color": "#ab63fa", "pattern": { "shape": "" } }, "name": "3", "offsetgroup": "3", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -568.255936282998, -509.21511309228623, -520.0428223179105, -519.3030872057032, -567.6579586062752, -518.3730281213461, -561.418853087828, -563.2457713645358, -561.8497295959959, -560.4505546414509, -559.0474455072631, -554.6333983336536, -554.7930420417287, -501.6931855738576, -495.7916365273262, -510.10994008664545, -548.8130181664754, -544.5679554161977, -544.2194452212298, -541.9072154637641, -539.5951627357219, -537.2832870371042, -495.74062564362515, -496.0608285118072, -268.6331165414805, -150.04401630846183, -143.6047030027484, -143.65405415738928, -143.45517967236296, -267.52903004674397, -286.691363083618, -449.6425862031498, -456.05713148399013, -446.90385421413066, -345.87641381189724, -340.3150180824882, -339.2181596078388, -338.1213160845742, -337.0244875126945, -335.9276738921994, -334.830875223089, -333.7340915053638, -332.6373227390229, -317.7035354459154, -177.56262153983178, -177.0513023638083, -173.75407675354182, -146.7212748950566, -159.01995264174386, -146.2669207295797, -141.15687698978294, -141.08182064642764, -140.85370125219885, -157.09020406979994, -173.22760316513006, -333.0986827290145, -331.8613241199435, -330.62398046225724, -329.38665175595577, -328.14933800103853, -324.3731077364883, -325.69605420905356, -324.4587853082911, -323.2215313589131, -328.0428471587779, -433.61183019840337, -418.73821720913634, -326.4801816491442, -324.9920875475176, -318.3006910443287, -216.51523821040496, -208.6884677448552 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=4
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "4", "marker": { "color": "#FFA15A", "pattern": { "shape": "" } }, "name": "4", "offsetgroup": "4", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -430.54526857949463, -520.6671627451043, -471.2766425268825, -519.3031063707798, -506.9517152726026, -499.2896343941742, -505.22624249864737, -562.7226366270254, -561.8499016017524, -560.4487647277908, -560.9295642245813, -555.9421430335491, -543.2617237844102, -551.9013549540144, -551.1507839017542, -552.5775219577265, -546.8806656387735, -547.4820734429682, -544.2210752976449, -543.4132420427135, -532.0622985186959, -537.2273011973833, -536.6299646690196, -534.3184212792456, -268.86240811872943, -151.4001355991568, -143.6543869971071, -143.57992192760216, -143.50426583725692, -267.6297814968061, -286.98555675138226, -450.252348828552, -456.6696562993317, -447.51358241678753, -346.4276262109569, -340.86481468756506, -339.76795201098787, -338.67110428579053, -337.57427151197373, -336.47745368953656, -335.3806508184793, -334.28386289880257, -333.1870899305054, -327.23799220879994, -215.7950362276287, -177.20657040392453, -173.896826972508, -146.74456778495343, -159.10499901162055, -146.306206229567, -141.19036930529836, -141.11537868336498, -140.8799885247588, -157.3100929028458, -210.06360878184447, -333.09615861244134, -333.92389833693807, -330.6236633816788, -329.3863306426701, -328.149012855019, -326.9117100187252, -325.6744221337887, -324.437149200209, -323.199891217987, -324.8048122410221, -433.6472613099671, -420.9508962527965, -327.16379122149516, -319.61254054289543, -318.3289713734512, -216.51523821040496, -208.6884677448552 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=5
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "5", "marker": { "color": "#19d3f3", "pattern": { "shape": "" } }, "name": "5", "offsetgroup": "5", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -515.8234274878303, -491.3190993684492, -499.31812152599946, -430.00193233079625, -473.9289985365724, -518.3777242079166, -466.7967197307354, -563.2511421193109, -561.8561117360077, -560.4570532238101, -561.1539352677564, -559.7566740005735, -558.3554995495052, -556.9503304436151, -551.159373162929, -552.7247841998646, -548.8222633603308, -544.5778974319935, -542.2665892911638, -543.4228595043276, -537.643720688862, -539.0518705374459, -499.21113489253105, -490.4179530409409, -167.50595825736804, -167.07377929185833, -143.74011522734423, -143.66578456461016, -150.08948225249108, -166.235843271415, -286.7341541256997, -450.98389163178143, -457.42154111662285, -448.24487436096814, -346.9284787812883, -341.3552433991281, -340.2583500995215, -339.1614717512953, -338.06460835445006, -336.9677599089848, -335.87092641489994, -334.7741078721961, -333.67730428087214, -332.58051564092875, -216.0777073780167, -177.37770178706563, -174.03030337031032, -148.5564909910558, -161.3274415627689, -146.7139974788265, -141.10798514704527, -141.15231962143727, -140.9461850752188, -159.39183616138666, -210.26684430049562, -333.5272119825583, -336.713929166427, -331.05675963418634, -329.8193968199726, -328.5820489571395, -327.3447160456867, -326.10739808561397, -324.87009507692215, -325.0753220878291, -330.8447803276673, -434.270851307884, -425.1041759571402, -327.5016547435319, -325.4211620782728, -318.611651004748, -216.57236341137497, -215.24492976216197 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=6
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "6", "marker": { "color": "#FF6692", "pattern": { "shape": "" } }, "name": "6", "offsetgroup": "6", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -521.1960606086715, -475.85220265666186, -478.4592892160958, -513.7384505623507, -513.0171723174785, -467.6680113244051, -517.7722890289774, -564.9544160547017, -561.8497746745295, -562.1899722508042, -559.0471036774156, -557.5783365863905, -551.7788318227981, -556.6553401960211, -554.4212663815421, -552.108317890747, -549.7955464293196, -547.4829519972604, -542.2583224068567, -541.9101231484618, -537.6350775252922, -537.2874657048466, -495.74455265595145, -534.0508551037105, -166.9611989393784, -150.06862433142777, -143.62218409360057, -143.5475487448237, -143.4727306474767, -165.75494458009308, -286.2415779814626, -442.142588636586, -456.585387661116, -447.40872557245115, -346.13694807397, -340.56371503821754, -339.46682174178767, -336.49583404270294, -335.4211394936241, -334.74493576308316, -335.11637710473184, -334.0195585652021, -332.92275497705265, -316.198247154747, -177.1284616963392, -176.61805398868427, -168.33620068509416, -146.54506089882295, -159.05325505361478, -146.28291674466843, -141.1731371721165, -140.94632481143924, -140.86478861558993, -157.1160097620782, -209.9523976504062, -326.02377068763866, -336.4291101198221, -330.7719429324624, -329.53458012142073, -328.2972322617592, -324.0407369063696, -325.8478283397365, -324.61052533421457, -323.373237280073, -329.36066478558257, -434.05825754700675, -419.16450121050127, -326.6613994022255, -319.817606086505, -317.1684833272768, -216.51523821040496, -208.6884677448552 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=7
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "7", "marker": { "color": "#B6E880", "pattern": { "shape": "" } }, "name": "7", "offsetgroup": "7", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -358.84426028919245, -421.7638521460262, -420.08845621446665, -460.90596566057485, -412.0378697510836, -352.4882256508195, -564.1367496918745, -562.7224752050367, -561.8502851361133, -560.4514347448797, -560.9326209721222, -561.1231990439882, -558.3505388452004, -494.69218088176336, -551.1550946768227, -550.1396780668952, -549.7950550367354, -547.4835346534766, -549.2605959261064, -546.9482766291482, -544.636134361558, -542.3241691233355, -540.0123809144812, -537.7007697349947, -281.2909475957733, -167.75350161200012, -150.44665377804924, -150.7986163290738, -166.99368399540498, -285.94902231044017, -335.0029291324221, -452.14024738065825, -466.9004217811419, -449.33596995324575, -359.6028766393858, -342.4231211287077, -341.32624535391716, -340.22938453050614, -339.1325386584752, -338.0357077378247, -336.93889176855373, -339.32198845640227, -334.71877705616424, -333.62200594103336, -232.7303741137272, -231.55430358967337, -176.79742126676274, -159.91548339471697, -173.7982584506732, -158.58610284576676, -146.31831276083707, -146.1942551566874, -141.15276829650082, -166.92539441825605, -224.62966980530874, -333.6976396434075, -335.45410958271754, -334.17031639257897, -332.8865381538209, -331.60277486644236, -328.8697174556085, -329.0495272485508, -327.76580881531237, -326.48210533345394, -331.53403128500156, -434.10710185308653, -424.9516921622835, -327.4697773787535, -326.0848186554292, -324.00899126896024, -219.33947462512452, -215.57955888884283 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=8
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "8", "marker": { "color": "#FF97FF", "pattern": { "shape": "" } }, "name": "8", "offsetgroup": "8", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -392.1798499810144, -509.6035587626409, -508.7359817743647, -366.5031724031329, -352.8749368819192, -518.336230097695, -517.772044544158, -563.2448441467636, -561.8490390281471, -563.2409449732473, -561.8519965729676, -554.6339194108552, -559.0968080767033, -556.6467011881637, -551.1176246658841, -554.1946796878652, -549.7569597473528, -549.6030086253882, -544.1834533247875, -545.0278678820898, -537.5972471336963, -537.2497174781618, -536.6531375481593, -537.5856117975338, -269.35608231494194, -166.94299050241798, -150.19315835344946, -143.6964254361059, -147.3640810918398, -269.81954990971224, -286.883067763476, -451.37745015700153, -459.4886754064006, -448.62460264242753, -347.107873795443, -341.86184019955857, -340.7649689178708, -339.6681125875628, -338.5712712086348, -337.47444478108713, -336.37763330491913, -335.2808367801312, -334.1840552067236, -333.0872885846957, -230.9611794766381, -215.578262811804, -176.553157652042, -159.5764051828894, -161.51561401041258, -154.46483085860604, -141.08501328861587, -141.0040012038229, -141.10043118493965, -160.26315220606043, -224.44501079992202, -333.4691175138183, -335.8996922204046, -333.93930677227814, -331.18939038570534, -328.4503269133722, -327.21301541197977, -325.9757188619678, -324.73843726333587, -326.36499614901555, -330.69971706580696, -433.95447559311026, -424.8021497062441, -327.356752247763, -325.27622933048025, -320.17884261217245, -216.22448539278537, -215.24492976216197 ], "yaxis": "y" }, { "alignmentgroup": "True", "hovertemplate": "=9
Time=%{x}
Sale/Production [MW]=%{y}", "legendgroup": "9", "marker": { "color": "#FECB52", "pattern": { "shape": "" } }, "name": "9", "offsetgroup": "9", "orientation": "v", "showlegend": true, "textposition": "auto", "type": "bar", "x": [ "2018-01-23T00:00:00", "2018-01-23T01:00:00", "2018-01-23T02:00:00", "2018-01-23T03:00:00", "2018-01-23T04:00:00", "2018-01-23T05:00:00", "2018-01-23T06:00:00", "2018-01-23T07:00:00", "2018-01-23T08:00:00", "2018-01-23T09:00:00", "2018-01-23T10:00:00", "2018-01-23T11:00:00", "2018-01-23T12:00:00", "2018-01-23T13:00:00", "2018-01-23T14:00:00", "2018-01-23T15:00:00", "2018-01-23T16:00:00", "2018-01-23T17:00:00", "2018-01-23T18:00:00", "2018-01-23T19:00:00", "2018-01-23T20:00:00", "2018-01-23T21:00:00", "2018-01-23T22:00:00", "2018-01-23T23:00:00", "2018-01-24T00:00:00", "2018-01-24T01:00:00", "2018-01-24T02:00:00", "2018-01-24T03:00:00", "2018-01-24T04:00:00", "2018-01-24T05:00:00", "2018-01-24T06:00:00", "2018-01-24T07:00:00", "2018-01-24T08:00:00", "2018-01-24T09:00:00", "2018-01-24T10:00:00", "2018-01-24T11:00:00", "2018-01-24T12:00:00", "2018-01-24T13:00:00", "2018-01-24T14:00:00", "2018-01-24T15:00:00", "2018-01-24T16:00:00", "2018-01-24T17:00:00", "2018-01-24T18:00:00", "2018-01-24T19:00:00", "2018-01-24T20:00:00", "2018-01-24T21:00:00", "2018-01-24T22:00:00", "2018-01-24T23:00:00", "2018-01-25T00:00:00", "2018-01-25T01:00:00", "2018-01-25T02:00:00", "2018-01-25T03:00:00", "2018-01-25T04:00:00", "2018-01-25T05:00:00", "2018-01-25T06:00:00", "2018-01-25T07:00:00", "2018-01-25T08:00:00", "2018-01-25T09:00:00", "2018-01-25T10:00:00", "2018-01-25T11:00:00", "2018-01-25T12:00:00", "2018-01-25T13:00:00", "2018-01-25T14:00:00", "2018-01-25T15:00:00", "2018-01-25T16:00:00", "2018-01-25T17:00:00", "2018-01-25T18:00:00", "2018-01-25T19:00:00", "2018-01-25T20:00:00", "2018-01-25T21:00:00", "2018-01-25T22:00:00", "2018-01-25T23:00:00" ], "xaxis": "x", "y": [ -573.7843718437973, -520.5800718344051, -566.0391136393663, -560.3096471212908, -567.1456046157068, -565.7598583292291, -517.7390069992492, -563.2048837112807, -561.8092758643102, -560.4098060733711, -559.0063779643187, -557.5368697919785, -551.7373401611684, -501.65882728506494, -551.1115815275632, -510.07578546021745, -546.8412222157569, -544.528623068123, -542.2162009498012, -539.9039558607925, -537.5918878010949, -532.0680575203555, -533.0226648523299, -530.7111278805687, -165.75342381162721, -149.5894985484992, -143.2882510479928, -143.21281451645496, -143.1371855505498, -164.66886807775197, -283.10570476384436, -437.8586720493045, -453.9932328931804, -442.51235058217713, -343.7131696900898, -338.1406172033234, -337.0437258646455, -319.6112017826175, -318.8017991609204, -317.99180027009123, -332.98256460225025, -331.8857480204486, -330.78894639002226, -314.69970983149005, -175.80406652164174, -175.15706455562074, -160.88071050460036, -146.1305670872884, -157.61321153407042, -145.65038542903054, -40.75092258450545, -40.661316233597944, -40.65816866710159, -157.0026742547384, -172.57306996303467, -325.9411783911285, -336.34326814888414, -333.36730428608826, -329.45229226660496, -328.2149465841625, -320.02232530331605, -324.9854886420616, -324.5670525129129, -323.32976663585305, -329.31590830403246, -433.992772665089, -419.1015987377489, -330.97336408149226, -319.7786264098744, -315.5910060569449, -216.51523821040496, -208.6884677448552 ], "yaxis": "y" } ], "layout": { "barmode": "relative", "legend": { "title": { "text": "" }, "tracegroupgap": 0 }, "template": { "data": { "bar": [ { "error_x": { "color": "#2a3f5f" }, "error_y": { "color": "#2a3f5f" }, "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "bar" } ], "barpolar": [ { "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "barpolar" } ], "carpet": [ { "aaxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "baxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "type": "carpet" } ], "choropleth": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "choropleth" } ], "contour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "contour" } ], "contourcarpet": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "contourcarpet" } ], "heatmap": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmap" } ], "heatmapgl": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "heatmapgl" } ], "histogram": [ { "marker": { "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "histogram" } ], "histogram2d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2d" } ], "histogram2dcontour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "histogram2dcontour" } ], "mesh3d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "mesh3d" } ], "parcoords": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "parcoords" } ], "pie": [ { "automargin": true, "type": "pie" } ], "scatter": [ { "fillpattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 }, "type": "scatter" } ], "scatter3d": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter3d" } ], "scattercarpet": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattercarpet" } ], "scattergeo": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergeo" } ], "scattergl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergl" } ], "scattermapbox": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattermapbox" } ], "scatterpolar": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolar" } ], "scatterpolargl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolargl" } ], "scatterternary": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterternary" } ], "surface": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "type": "surface" } ], "table": [ { "cells": { "fill": { "color": "#EBF0F8" }, "line": { "color": "white" } }, "header": { "fill": { "color": "#C8D4E3" }, "line": { "color": "white" } }, "type": "table" } ] }, "layout": { "annotationdefaults": { "arrowcolor": "#2a3f5f", "arrowhead": 0, "arrowwidth": 1 }, "autotypenumbers": "strict", "coloraxis": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "colorscale": { "diverging": [ [ 0, "#8e0152" ], [ 0.1, "#c51b7d" ], [ 0.2, "#de77ae" ], [ 0.3, "#f1b6da" ], [ 0.4, "#fde0ef" ], [ 0.5, "#f7f7f7" ], [ 0.6, "#e6f5d0" ], [ 0.7, "#b8e186" ], [ 0.8, "#7fbc41" ], [ 0.9, "#4d9221" ], [ 1, "#276419" ] ], "sequential": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ], "sequentialminus": [ [ 0.0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1.0, "#f0f921" ] ] }, "colorway": [ "#636efa", "#EF553B", "#00cc96", "#ab63fa", "#FFA15A", "#19d3f3", "#FF6692", "#B6E880", "#FF97FF", "#FECB52" ], "font": { "color": "#2a3f5f" }, "geo": { "bgcolor": "white", "lakecolor": "white", "landcolor": "#E5ECF6", "showlakes": true, "showland": true, "subunitcolor": "white" }, "hoverlabel": { "align": "left" }, "hovermode": "closest", "mapbox": { "style": "light" }, "paper_bgcolor": "white", "plot_bgcolor": "#E5ECF6", "polar": { "angularaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "radialaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "scene": { "xaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "yaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "zaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" } }, "shapedefaults": { "line": { "color": "#2a3f5f" } }, "ternary": { "aaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "baxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "caxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "title": { "x": 0.05 }, "xaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 }, "yaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 } } }, "title": { "text": "Bid volumes per stochastic price #, stacked" }, "xaxis": { "anchor": "y", "domain": [ 0.0, 1.0 ], "title": { "text": "Time" } }, "yaxis": { "anchor": "x", "domain": [ 0.0, 1.0 ], "title": { "text": "Sale/Production [MW]" } } } }, "text/html": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Plot optimal production in different plot types\n", "optimal_production.plot.bar(title=\"Bid volumes per stochastic price #, stacked\", labels=dict(index=\"Time\", value=\"Sale/Production [MW]\", variable=\"\")) # bargap=.1, " ] }, { "cell_type": "markdown", "id": "1249afff", "metadata": { "Collapsed": "false" }, "source": [ "# Files" ] }, { "cell_type": "markdown", "id": "df4b12d4", "metadata": { "Collapsed": "false" }, "source": [ "(multi-price-bid-matrix-model-py)=\n", "## multi_price_bid_matrix_model.py" ] }, { "cell_type": "code", "execution_count": 26, "id": "b9d9c1cc", "metadata": { "Collapsed": "false", "tags": [ "remove-input" ] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "import pandas as pd\n", "\n", "def build_model(shop):\n", " starttime = pd.Timestamp('2018-01-23 00:00:00')\n", " endtime = pd.Timestamp('2018-01-26')\n", " shop.set_time_resolution(starttime=starttime, endtime=endtime, timeunit=\"hour\", timeresolution=pd.Series(index=[starttime],data=[1]))\n", " \n", " rsv1 = shop.model.reservoir.add_object('Reservoir1')\n", " rsv1.max_vol.set(39)\n", " rsv1.lrl.set(860)\n", " rsv1.hrl.set(905)\n", " rsv1.vol_head.set(pd.Series([860, 906, 907], index=[0, 39, 41.66], name=0)) \n", "\n", " rsv2 = shop.model.reservoir.add_object('Reservoir2')\n", " rsv2.max_vol.set(97.5) \n", " rsv2.lrl.set(650) \n", " rsv2.hrl.set(679) \n", " rsv2.vol_head.set(pd.Series([650, 679, 680], index=[0, 97.5, 104.15], name=0))\n", " \n", " plant1 = shop.model.plant.add_object('Plant1')\n", " plant1.outlet_line.set(672)\n", " plant1.main_loss.set([0])\n", " plant1.penstock_loss.set([0.001])\n", " plant1.mip_flag.set(1)\n", " for gen_no in range(2):\n", " gen=shop.model.generator.add_object(f\"{plant1.get_name()}_G{str(gen_no+1)}\")\n", " gen.connect_to(plant1)\n", " gen.penstock.set(1)\n", " gen.p_min.set(60)\n", " gen.p_max.set(120)\n", " gen.p_nom.set(120)\n", " gen.startcost.set(300)\n", " gen.gen_eff_curve.set(pd.Series([100, 100], index=[60, 120]))\n", " gen.turb_eff_curves.set([pd.Series([85.8733, 87.0319, 88.0879, 89.0544, 89.9446, 90.7717, 91.5488, 92.2643, 92.8213, 93.1090, 93.2170, 93.0390, 92.6570, 92.1746],\n", " index=[28.12, 30.45, 32.78, 35.11, 37.45, 39.78, 42.11, 44.44, 46.77, 49.10, 51.43, 53.76, 56.10, 58.83],\n", " name=170),\n", " pd.Series([86.7321, 87.9022, 88.9688, 89.9450, 90.8441, 91.6794, 92.4643, 93.1870, 93.7495, 94.0401, 94.1492, 93.9694, 93.5836, 93.0964],\n", " index=[28.12, 30.45, 32.78, 35.11, 37.45, 39.78, 42.11, 44.44, 46.77, 49.10, 51.43, 53.76, 56.10, 58.83],\n", " name=200),\n", " pd.Series([87.5908, 88.7725, 89.8497, 90.8355, 91.7435, 92.5871, 93.3798, 94.1096, 94.6777, 94.9712, 95.0813, 94.8998, 94.5101, 94.0181],\n", " index=[28.12, 30.45, 32.78, 35.11, 37.45, 39.78, 42.11, 44.44, 46.77, 49.10, 51.43, 53.76, 56.10, 58.83],\n", " name=230)])\n", "\n", " plant2 = shop.model.plant.add_object('Plant2')\n", " plant2.outlet_line.set(586)\n", " plant2.main_loss.set([0])\n", " plant2.penstock_loss.set([0.0001,0.0002])\n", " plant2.mip_flag.set(1)\n", " for gen_no in range(4):\n", " gen=shop.model.generator.add_object(f\"{plant2.get_name()}_G{str(gen_no+1)}\")\n", " gen.connect_to(plant2)\n", " if gen_no == 0:\n", " gen.penstock.set(1)\n", " gen.p_min.set(100)\n", " gen.p_max.set(180)\n", " gen.p_nom.set(180)\n", " gen.startcost.set(300)\n", " gen.gen_eff_curve.set(pd.Series([100, 100], index=[100, 180]))\n", " gen.turb_eff_curves.set([pd.Series([92.7201, 93.2583, 93.7305, 94.1368, 94.4785, 94.7525, 94.9606, 95.1028, 95.1790, 95.1892, 95.1335, 95.0118, 94.8232, 94.5191],\n", " index=[126.54, 137.03, 147.51, 158.00, 168.53, 179.01, 189.50, 199.98, 210.47, 220.95, 231.44, 241.92, 252.45, 264.74],\n", " name=60)])\n", " else:\n", " gen.penstock.set(2)\n", " gen.p_min.set(30)\n", " gen.p_max.set(55)\n", " gen.p_nom.set(55)\n", " gen.startcost.set(300)\n", " gen.gen_eff_curve.set(pd.Series([100, 100], index=[30, 55]))\n", " gen.turb_eff_curves.set([pd.Series([83.8700, 85.1937, 86.3825, 87.4362, 88.3587, 89.1419, 89.7901, 90.3033, 90.6815, 90.9248, 91.0331, 91.0063, 90.8436, 90.4817],\n", " index=[40.82, 44.20, 47.58, 50.97, 54.36, 57.75, 61.13, 64.51, 67.89, 71.27, 74.66, 78.04, 81.44, 85.40],\n", " name=60)])\n", " \n", " rsv1.connect_to(plant1)\n", " plant1.connect_to(rsv2)\n", " rsv2.connect_to(plant2)\n", " \n", " rsv1.start_head.set(900)\n", " rsv2.start_head.set(670) \n", " rsv1.energy_value_input.set(30)\n", " rsv2.energy_value_input.set(10)\n", " rsv2.inflow.set(pd.Series([60], [starttime]))\n", " \n", " da = shop.model.market.add_object('Day_ahead')\n", " da.sale_price.set(pd.DataFrame([32.992,31.122,29.312,28.072,30.012,33.362,42.682,74.822,77.732,62.332,55.892,46.962,42.582,40.942,39.212,39.142,41.672,46.922,37.102,32.992,31.272,29.752,28.782,28.082,27.242,26.622,25.732,25.392,25.992,27.402,28.942,32.182,33.082,32.342,30.912,30.162,30.062,29.562,29.462,29.512,29.672,30.072,29.552,28.862,28.412,28.072,27.162,25.502,26.192,25.222,24.052,23.892,23.682,26.092,28.202,30.902,31.572,31.462,31.172,30.912,30.572,30.602,30.632,31.062,32.082,36.262,34.472,32.182,31.492,30.732,29.712,28.982], \n", " index=[starttime + pd.Timedelta(hours=i) for i in range(0,72)]))\n", " da.max_sale.set(pd.Series([9999], [starttime]))\n", " da.buy_price.set(da.sale_price.get()+0.002)\n", " da.max_buy.set(pd.Series([9999], [starttime]))\n", "\n", "def run_model(shop):\n", " shop.start_sim([], ['5'])\n", " shop.set_code(['incremental'], [])\n", " shop.start_sim([], ['3'])\n", "\n" ] } ], "source": [ "with open('multi_price_bid_matrix_model.py', 'r') as f:\n", " print(f.read())" ] } ], "metadata": { "jupytext": { "text_representation": { "extension": ".md", "format_name": "myst", "format_version": 0.13, "jupytext_version": "1.13.8" } }, "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.13.10" }, "source_map": [ 14, 24, 28, 32, 40, 49, 53, 59, 63, 67, 74, 78, 86, 90, 97, 101, 105, 113, 117, 122, 129, 134, 143, 147, 159, 163, 170, 174, 181, 185, 189, 213, 217, 221, 241, 245, 255, 259, 275, 279, 286, 290, 300, 304, 308, 322, 326, 330, 337, 341, 345, 360, 364, 374, 381, 385, 389, 396, 404, 411, 415, 420 ] }, "nbformat": 4, "nbformat_minor": 5 }