demo_energiedelen.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Intro\n",
    "\n",
    "Deze notebook toont de Python-implementatie van het protocol energiedelen versie 3.1\n",
    "\n",
    "Het protocol beschrijft 3 verdeelsleutels: Vast, Relatief en Optimaal."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from openenergyid import TimeDataFrame\n",
    "from openenergyid.energysharing import EnergySharingInput, EnergySharingOutput, calculate, CalculationMethod, KeyInput"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Input Data\n",
    "\n",
    "Om de werking aan te tonen, maken we een sample dataset met 6 deelnemers, gedurende 4 kwartieren.\n",
    "\n",
    "Elke deelnemer heeft een Bruto Afname en een Bruto Injectie. Voor elk kwartier is er een verdeelsleutel, die bepaalt hoeveel energie er naar elke deelnemer gaat. We wijzen een verdeelsleutel per kwartier to, omdat deze verdeelsleutels in de tijd kunnen veranderen.\n",
    "\n",
    "Het resultaat zal zijn dat elke deelnemer een Netto Afname, een Netto Injectie en een hoeveelheid gedeelde energie heeft."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "index = pd.date_range(\n",
    "    start=pd.Timestamp('2024-01-01 12:00:00', tz='Europe/Brussels'),\n",
    "    end=pd.Timestamp('2024-01-01 12:45:00', tz='Europe/Brussels'),\n",
    "    freq='15T',\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "gross_injection = pd.DataFrame(\n",
    "    data={\n",
    "        \"P1\": [70, 20, 100, 0],\n",
    "        \"P2\": [10, 10, 10, 10],\n",
    "        \"P3\": [20, 30, 40, 50],\n",
    "        \"P4\": [0, 0, 0, 0],\n",
    "        \"P5\": [0, 0, 0, 0],\n",
    "        \"P6\": [0, 0, 0, 0],\n",
    "    },\n",
    "    index=index,\n",
    ")\n",
    "\n",
    "gross_offtake = pd.DataFrame(\n",
    "    data={\n",
    "        \"P1\": [0, 0, 0, 0],\n",
    "        \"P2\": [30, 20, 10, 0],\n",
    "        \"P3\": [22, 20, 30, 40],\n",
    "        \"P4\": [30, 25, 35, 10],\n",
    "        \"P5\": [18, 17, 19, 25],\n",
    "        \"P6\": [20, 22, 24, 26],\n",
    "    },\n",
    "    index=index,\n",
    ")\n",
    "\n",
    "key = pd.DataFrame(\n",
    "    data={\n",
    "        \"P1\": [0, 0, 0, 0],\n",
    "        \"P2\": [10, 10, 10, 10],\n",
    "        \"P3\": [22.5, 22.5, 22.5, 22.5],\n",
    "        \"P4\": [22.5, 22.5, 22.5, 22.5],\n",
    "        \"P5\": [22.5, 22.5, 22.5, 22.5],\n",
    "        \"P6\": [22.5, 22.5, 22.5, 22.5],\n",
    "    },\n",
    "    index=index,\n",
    ")\n",
    "key = key.div(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:00:00+01:00</th>\n",
       "      <td>70</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:15:00+01:00</th>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:30:00+01:00</th>\n",
       "      <td>100</td>\n",
       "      <td>10</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:45:00+01:00</th>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            P1  P2  P3  P4  P5  P6\n",
       "2024-01-01 12:00:00+01:00   70  10  20   0   0   0\n",
       "2024-01-01 12:15:00+01:00   20  10  30   0   0   0\n",
       "2024-01-01 12:30:00+01:00  100  10  40   0   0   0\n",
       "2024-01-01 12:45:00+01:00    0  10  50   0   0   0"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gross_injection"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:00:00+01:00</th>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>22</td>\n",
       "      <td>30</td>\n",
       "      <td>18</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:15:00+01:00</th>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>25</td>\n",
       "      <td>17</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:30:00+01:00</th>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>30</td>\n",
       "      <td>35</td>\n",
       "      <td>19</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:45:00+01:00</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>10</td>\n",
       "      <td>25</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           P1  P2  P3  P4  P5  P6\n",
       "2024-01-01 12:00:00+01:00   0  30  22  30  18  20\n",
       "2024-01-01 12:15:00+01:00   0  20  20  25  17  22\n",
       "2024-01-01 12:30:00+01:00   0  10  30  35  19  24\n",
       "2024-01-01 12:45:00+01:00   0   0  40  10  25  26"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gross_offtake"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:00:00+01:00</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:15:00+01:00</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:30:00+01:00</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 12:45:00+01:00</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            P1   P2     P3     P4     P5     P6\n",
       "2024-01-01 12:00:00+01:00  0.0  0.1  0.225  0.225  0.225  0.225\n",
       "2024-01-01 12:15:00+01:00  0.0  0.1  0.225  0.225  0.225  0.225\n",
       "2024-01-01 12:30:00+01:00  0.0  0.1  0.225  0.225  0.225  0.225\n",
       "2024-01-01 12:45:00+01:00  0.0  0.1  0.225  0.225  0.225  0.225"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Construct the input model\n",
    "# This helps with validation and serialization\n",
    "\n",
    "input = EnergySharingInput.model_construct(\n",
    "    gross_injection=TimeDataFrame.from_pandas(gross_injection),\n",
    "    gross_offtake=TimeDataFrame.from_pandas(gross_offtake),\n",
    "    key=KeyInput.from_pandas(key)\n",
    ")\n",
    "\n",
    "with open('data/energiedelen/sample_input.json', 'w') as f:\n",
    "    f.write(input.model_dump_json(by_alias=True))\n",
    "\n",
    "df = input.to_pandas()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"6\" halign=\"left\">Gross Injection</th>\n",
       "      <th colspan=\"6\" halign=\"left\">Gross Offtake</th>\n",
       "      <th colspan=\"6\" halign=\"left\">Key</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:00:00+00:00</th>\n",
       "      <td>70</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>22</td>\n",
       "      <td>30</td>\n",
       "      <td>18</td>\n",
       "      <td>20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:15:00+00:00</th>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>25</td>\n",
       "      <td>17</td>\n",
       "      <td>22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:30:00+00:00</th>\n",
       "      <td>100</td>\n",
       "      <td>10</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>30</td>\n",
       "      <td>35</td>\n",
       "      <td>19</td>\n",
       "      <td>24</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:45:00+00:00</th>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>10</td>\n",
       "      <td>25</td>\n",
       "      <td>26</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "      <td>0.225</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Gross Injection                  Gross Offtake      \\\n",
       "                                       P1  P2  P3 P4 P5 P6            P1  P2   \n",
       "2024-01-01 11:00:00+00:00              70  10  20  0  0  0             0  30   \n",
       "2024-01-01 11:15:00+00:00              20  10  30  0  0  0             0  20   \n",
       "2024-01-01 11:30:00+00:00             100  10  40  0  0  0             0  10   \n",
       "2024-01-01 11:45:00+00:00               0  10  50  0  0  0             0   0   \n",
       "\n",
       "                                           Key                            \\\n",
       "                           P3  P4  P5  P6   P1   P2     P3     P4     P5   \n",
       "2024-01-01 11:00:00+00:00  22  30  18  20  0.0  0.1  0.225  0.225  0.225   \n",
       "2024-01-01 11:15:00+00:00  20  25  17  22  0.0  0.1  0.225  0.225  0.225   \n",
       "2024-01-01 11:30:00+00:00  30  35  19  24  0.0  0.1  0.225  0.225  0.225   \n",
       "2024-01-01 11:45:00+00:00  40  10  25  26  0.0  0.1  0.225  0.225  0.225   \n",
       "\n",
       "                                  \n",
       "                              P6  \n",
       "2024-01-01 11:00:00+00:00  0.225  \n",
       "2024-01-01 11:15:00+00:00  0.225  \n",
       "2024-01-01 11:30:00+00:00  0.225  \n",
       "2024-01-01 11:45:00+00:00  0.225  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Vaste methode\n",
    "\n",
    "![Methodiek vaste methode](data/energiedelen/Vast.png)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"6\" halign=\"left\">Net Injection</th>\n",
       "      <th colspan=\"6\" halign=\"left\">Net Offtake</th>\n",
       "      <th colspan=\"6\" halign=\"left\">Shared Energy</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:00:00+00:00</th>\n",
       "      <td>4.9</td>\n",
       "      <td>1.70</td>\n",
       "      <td>5.90</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>4.00</td>\n",
       "      <td>7.50</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.00</td>\n",
       "      <td>22.50</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:15:00+00:00</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>6.75</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>13.25</td>\n",
       "      <td>11.50</td>\n",
       "      <td>3.5</td>\n",
       "      <td>8.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.75</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.5</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:30:00+00:00</th>\n",
       "      <td>19.0</td>\n",
       "      <td>2.90</td>\n",
       "      <td>16.60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.25</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>24.75</td>\n",
       "      <td>33.75</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:45:00+00:00</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.42</td>\n",
       "      <td>18.33</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>11.5</td>\n",
       "      <td>12.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.25</td>\n",
       "      <td>10.00</td>\n",
       "      <td>13.5</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Net Injection                              \\\n",
       "                                     P1    P2     P3   P4   P5   P6   \n",
       "2024-01-01 11:00:00+00:00           4.9  1.70   5.90  0.0  0.0  0.0   \n",
       "2024-01-01 11:15:00+00:00           0.0  1.00   6.75  0.0  0.0  0.0   \n",
       "2024-01-01 11:30:00+00:00          19.0  2.90  16.60  0.0  0.0  0.0   \n",
       "2024-01-01 11:45:00+00:00           0.0  2.42  18.33  0.0  0.0  0.0   \n",
       "\n",
       "                          Net Offtake                                  \\\n",
       "                                   P1    P2     P3     P4    P5    P6   \n",
       "2024-01-01 11:00:00+00:00         0.0  21.0   4.00   7.50   0.0   0.0   \n",
       "2024-01-01 11:15:00+00:00         0.0  15.0  13.25  11.50   3.5   8.5   \n",
       "2024-01-01 11:30:00+00:00         0.0   0.0   5.25   1.25   0.0   0.0   \n",
       "2024-01-01 11:45:00+00:00         0.0   0.0  37.75   0.00  11.5  12.5   \n",
       "\n",
       "                          Shared Energy                                  \n",
       "                                     P1    P2     P3     P4    P5    P6  \n",
       "2024-01-01 11:00:00+00:00           0.0   9.0  18.00  22.50  18.0  20.0  \n",
       "2024-01-01 11:15:00+00:00           0.0   5.0   6.75  13.50  13.5  13.5  \n",
       "2024-01-01 11:30:00+00:00           0.0  10.0  24.75  33.75  19.0  24.0  \n",
       "2024-01-01 11:45:00+00:00           0.0   0.0   2.25  10.00  13.5  13.5  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "calculate(df, method=CalculationMethod.FIXED)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Relatieve methode\n",
    "\n",
    "![Methodiek relatieve methode](data/energiedelen/Relatief.png)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"6\" halign=\"left\">Net Injection</th>\n",
       "      <th colspan=\"6\" halign=\"left\">Net Offtake</th>\n",
       "      <th colspan=\"6\" halign=\"left\">Shared Energy</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:00:00+00:00</th>\n",
       "      <td>7.08</td>\n",
       "      <td>1.01</td>\n",
       "      <td>2.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.42</td>\n",
       "      <td>3.75</td>\n",
       "      <td>5.94</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.58</td>\n",
       "      <td>18.25</td>\n",
       "      <td>24.06</td>\n",
       "      <td>18.00</td>\n",
       "      <td>20.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:15:00+00:00</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.13</td>\n",
       "      <td>13.00</td>\n",
       "      <td>9.29</td>\n",
       "      <td>1.29</td>\n",
       "      <td>6.29</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.87</td>\n",
       "      <td>7.00</td>\n",
       "      <td>15.71</td>\n",
       "      <td>15.71</td>\n",
       "      <td>15.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:30:00+00:00</th>\n",
       "      <td>24.67</td>\n",
       "      <td>2.47</td>\n",
       "      <td>9.87</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.00</td>\n",
       "      <td>25.00</td>\n",
       "      <td>35.00</td>\n",
       "      <td>19.00</td>\n",
       "      <td>24.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:45:00+00:00</th>\n",
       "      <td>0.00</td>\n",
       "      <td>2.24</td>\n",
       "      <td>11.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>37.50</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7.98</td>\n",
       "      <td>8.98</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.50</td>\n",
       "      <td>10.00</td>\n",
       "      <td>17.02</td>\n",
       "      <td>17.02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Net Injection                              \\\n",
       "                                     P1    P2     P3   P4   P5   P6   \n",
       "2024-01-01 11:00:00+00:00          7.08  1.01   2.02  0.0  0.0  0.0   \n",
       "2024-01-01 11:15:00+00:00          0.00  0.00  -0.00  0.0  0.0  0.0   \n",
       "2024-01-01 11:30:00+00:00         24.67  2.47   9.87  0.0  0.0  0.0   \n",
       "2024-01-01 11:45:00+00:00          0.00  2.24  11.22  0.0  0.0  0.0   \n",
       "\n",
       "                          Net Offtake                                  \\\n",
       "                                   P1     P2     P3    P4    P5    P6   \n",
       "2024-01-01 11:00:00+00:00         0.0  20.42   3.75  5.94  0.00  0.00   \n",
       "2024-01-01 11:15:00+00:00         0.0  14.13  13.00  9.29  1.29  6.29   \n",
       "2024-01-01 11:30:00+00:00         0.0   0.00   5.00  0.00  0.00  0.00   \n",
       "2024-01-01 11:45:00+00:00         0.0   0.00  37.50  0.00  7.98  8.98   \n",
       "\n",
       "                          Shared Energy                                     \n",
       "                                     P1     P2     P3     P4     P5     P6  \n",
       "2024-01-01 11:00:00+00:00           0.0   9.58  18.25  24.06  18.00  20.00  \n",
       "2024-01-01 11:15:00+00:00           0.0   5.87   7.00  15.71  15.71  15.71  \n",
       "2024-01-01 11:30:00+00:00           0.0  10.00  25.00  35.00  19.00  24.00  \n",
       "2024-01-01 11:45:00+00:00           0.0   0.00   2.50  10.00  17.02  17.02  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "calculate(df, method=CalculationMethod.RELATIVE)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Optimale methode\n",
    "\n",
    "## Iteratie 1\n",
    "\n",
    "![Methodiek optimale methode iteratie 1](data/energiedelen/Optimaal_1.png)\n",
    "\n",
    "## Iteratie 2\n",
    "\n",
    "![Methodiek optimale methode iteratie 2](data/energiedelen/Optimaal_2.png)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"6\" halign=\"left\">Net Injection</th>\n",
       "      <th colspan=\"6\" halign=\"left\">Net Offtake</th>\n",
       "      <th colspan=\"6\" halign=\"left\">Shared Energy</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:00:00+00:00</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.51</td>\n",
       "      <td>0.35</td>\n",
       "      <td>1.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.49</td>\n",
       "      <td>21.65</td>\n",
       "      <td>28.86</td>\n",
       "      <td>18.00</td>\n",
       "      <td>20.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:15:00+00:00</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.13</td>\n",
       "      <td>13.00</td>\n",
       "      <td>9.29</td>\n",
       "      <td>1.29</td>\n",
       "      <td>6.29</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.87</td>\n",
       "      <td>7.00</td>\n",
       "      <td>15.71</td>\n",
       "      <td>15.71</td>\n",
       "      <td>15.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:30:00+00:00</th>\n",
       "      <td>14.76</td>\n",
       "      <td>1.48</td>\n",
       "      <td>15.77</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.00</td>\n",
       "      <td>30.00</td>\n",
       "      <td>35.00</td>\n",
       "      <td>19.00</td>\n",
       "      <td>24.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-01 11:45:00+00:00</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>36.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.62</td>\n",
       "      <td>2.62</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.25</td>\n",
       "      <td>10.00</td>\n",
       "      <td>23.38</td>\n",
       "      <td>23.38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Net Injection                              \\\n",
       "                                     P1    P2     P3   P4   P5   P6   \n",
       "2024-01-01 11:00:00+00:00          0.00  0.00   0.00  0.0  0.0  0.0   \n",
       "2024-01-01 11:15:00+00:00          0.00  0.00   0.00  0.0  0.0  0.0   \n",
       "2024-01-01 11:30:00+00:00         14.76  1.48  15.77  0.0  0.0  0.0   \n",
       "2024-01-01 11:45:00+00:00          0.00  0.00   0.00  0.0  0.0  0.0   \n",
       "\n",
       "                          Net Offtake                                  \\\n",
       "                                   P1     P2     P3    P4    P5    P6   \n",
       "2024-01-01 11:00:00+00:00         0.0  18.51   0.35  1.14  0.00  0.00   \n",
       "2024-01-01 11:15:00+00:00         0.0  14.13  13.00  9.29  1.29  6.29   \n",
       "2024-01-01 11:30:00+00:00         0.0   0.00   0.00  0.00  0.00  0.00   \n",
       "2024-01-01 11:45:00+00:00         0.0   0.00  36.75  0.00  1.62  2.62   \n",
       "\n",
       "                          Shared Energy                                     \n",
       "                                     P1     P2     P3     P4     P5     P6  \n",
       "2024-01-01 11:00:00+00:00           0.0  11.49  21.65  28.86  18.00  20.00  \n",
       "2024-01-01 11:15:00+00:00           0.0   5.87   7.00  15.71  15.71  15.71  \n",
       "2024-01-01 11:30:00+00:00           0.0  10.00  30.00  35.00  19.00  24.00  \n",
       "2024-01-01 11:45:00+00:00           0.0   0.00   3.25  10.00  23.38  23.38  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "calculate(df, method=CalculationMethod.OPTIMAL)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Output Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = calculate(df, method=CalculationMethod.OPTIMAL)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "output = EnergySharingOutput.from_calculation_result(result)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\n",
      "  \"netInjection\": {\n",
      "    \"index\": [\n",
      "      \"2024-01-01T11:00:00Z\",\n",
      "      \"2024-01-01T11:15:00Z\",\n",
      "      \"2024-01-01T11:30:00Z\",\n",
      "      \"2024-01-01T11:45:00Z\"\n",
      "    ],\n",
      "    \"columns\": [\n",
      "      \"P1\",\n",
      "      \"P2\",\n",
      "      \"P3\",\n",
      "      \"P4\",\n",
      "      \"P5\",\n",
      "      \"P6\"\n",
      "    ],\n",
      "    \"data\": [\n",
      "      [\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0\n",
      "      ],\n",
      "      [\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0\n",
      "      ],\n",
      "      [\n",
      "        14.76,\n",
      "        1.48,\n",
      "        15.77,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0\n",
      "      ],\n",
      "      [\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0\n",
      "      ]\n",
      "    ]\n",
      "  },\n",
      "  \"netOfftake\": {\n",
      "    \"index\": [\n",
      "      \"2024-01-01T11:00:00Z\",\n",
      "      \"2024-01-01T11:15:00Z\",\n",
      "      \"2024-01-01T11:30:00Z\",\n",
      "      \"2024-01-01T11:45:00Z\"\n",
      "    ],\n",
      "    \"columns\": [\n",
      "      \"P1\",\n",
      "      \"P2\",\n",
      "      \"P3\",\n",
      "      \"P4\",\n",
      "      \"P5\",\n",
      "      \"P6\"\n",
      "    ],\n",
      "    \"data\": [\n",
      "      [\n",
      "        0.0,\n",
      "        18.51,\n",
      "        0.35,\n",
      "        1.14,\n",
      "        0.0,\n",
      "        0.0\n",
      "      ],\n",
      "      [\n",
      "        0.0,\n",
      "        14.13,\n",
      "        13.0,\n",
      "        9.29,\n",
      "        1.29,\n",
      "        6.29\n",
      "      ],\n",
      "      [\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0,\n",
      "        0.0\n",
      "      ],\n",
      "      [\n",
      "        0.0,\n",
      "        0.0,\n",
      "        36.75,\n",
      "        0.0,\n",
      "        1.62,\n",
      "        2.62\n",
      "      ]\n",
      "    ]\n",
      "  },\n",
      "  \"sharedEnergy\": {\n",
      "    \"index\": [\n",
      "      \"2024-01-01T11:00:00Z\",\n",
      "      \"2024-01-01T11:15:00Z\",\n",
      "      \"2024-01-01T11:30:00Z\",\n",
      "      \"2024-01-01T11:45:00Z\"\n",
      "    ],\n",
      "    \"columns\": [\n",
      "      \"P1\",\n",
      "      \"P2\",\n",
      "      \"P3\",\n",
      "      \"P4\",\n",
      "      \"P5\",\n",
      "      \"P6\"\n",
      "    ],\n",
      "    \"data\": [\n",
      "      [\n",
      "        0.0,\n",
      "        11.49,\n",
      "        21.65,\n",
      "        28.86,\n",
      "        18.0,\n",
      "        20.0\n",
      "      ],\n",
      "      [\n",
      "        0.0,\n",
      "        5.87,\n",
      "        7.0,\n",
      "        15.71,\n",
      "        15.71,\n",
      "        15.71\n",
      "      ],\n",
      "      [\n",
      "        0.0,\n",
      "        10.0,\n",
      "        30.0,\n",
      "        35.0,\n",
      "        19.0,\n",
      "        24.0\n",
      "      ],\n",
      "      [\n",
      "        0.0,\n",
      "        0.0,\n",
      "        3.25,\n",
      "        10.0,\n",
      "        23.38,\n",
      "        23.38\n",
      "      ]\n",
      "    ]\n",
      "  }\n",
      "}\n"
     ]
    }
   ],
   "source": [
    "print(output.model_dump_json(by_alias=True, indent=2))"
   ]
  }
 ],
 "metadata": {
  "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.9.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}