first task.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "79df4d98",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import plotly.express as px"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "50520c75",
   "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>KukaRobotId</th>\n",
       "      <th>Product</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-01-31 20:13:35</td>\n",
       "      <td>2022-02-01 01:01:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 01:02:12</td>\n",
       "      <td>2022-02-01 01:02:55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor A4</td>\n",
       "      <td>2022-01-31 23:27:53</td>\n",
       "      <td>2022-02-01 03:09:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-01-31 23:26:11</td>\n",
       "      <td>2022-02-01 03:18:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 01:03:26</td>\n",
       "      <td>2022-02-01 04:20:59</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   KukaRobotId   Product           StartDate             EndDate\n",
       "0        68051  Rotor A3 2022-01-31 20:13:35 2022-02-01 01:01:47\n",
       "1        68051  Rotor A3 2022-02-01 01:02:12 2022-02-01 01:02:55\n",
       "2        82402  Rotor A4 2022-01-31 23:27:53 2022-02-01 03:09:23\n",
       "3        82403  Rotor A2 2022-01-31 23:26:11 2022-02-01 03:18:29\n",
       "4        68050  Rotor A3 2022-02-01 01:03:26 2022-02-01 04:20:59"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kuka_output = pd.read_excel('KukaOutput-ICNAP.xlsx', engine='openpyxl')\n",
    "kuka_output.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "653684cb",
   "metadata": {},
   "outputs": [],
   "source": [
    "kuka_output['EndDate'] = pd.to_datetime(kuka_output['EndDate'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "cf51e54e",
   "metadata": {},
   "outputs": [],
   "source": [
    "t0 = kuka_output['EndDate'].iloc[0]\n",
    "kuka_output['EndDate min'] = (kuka_output['EndDate'] - t0).astype('timedelta64[m]')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "5a72d8e3",
   "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>KukaRobotId</th>\n",
       "      <th>Product</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>EndDate min</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-01-31 20:13:35</td>\n",
       "      <td>2022-02-01 01:01:47</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 01:02:12</td>\n",
       "      <td>2022-02-01 01:02:55</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor A4</td>\n",
       "      <td>2022-01-31 23:27:53</td>\n",
       "      <td>2022-02-01 03:09:23</td>\n",
       "      <td>127.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-01-31 23:26:11</td>\n",
       "      <td>2022-02-01 03:18:29</td>\n",
       "      <td>136.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 01:03:26</td>\n",
       "      <td>2022-02-01 04:20:59</td>\n",
       "      <td>199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A1</td>\n",
       "      <td>2022-02-28 20:14:35</td>\n",
       "      <td>2022-02-28 23:24:19</td>\n",
       "      <td>40222.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor B3</td>\n",
       "      <td>2022-02-28 23:24:00</td>\n",
       "      <td>2022-03-01 01:14:49</td>\n",
       "      <td>40333.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A1</td>\n",
       "      <td>2022-02-28 23:29:09</td>\n",
       "      <td>2022-03-01 02:45:57</td>\n",
       "      <td>40424.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor C1</td>\n",
       "      <td>2022-02-28 23:46:24</td>\n",
       "      <td>2022-03-01 04:13:09</td>\n",
       "      <td>40511.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530</th>\n",
       "      <td>82401</td>\n",
       "      <td>Rotor A5</td>\n",
       "      <td>2022-02-28 12:27:06</td>\n",
       "      <td>2022-03-01 06:17:10</td>\n",
       "      <td>40635.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>531 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     KukaRobotId   Product           StartDate             EndDate  \\\n",
       "0          68051  Rotor A3 2022-01-31 20:13:35 2022-02-01 01:01:47   \n",
       "1          68051  Rotor A3 2022-02-01 01:02:12 2022-02-01 01:02:55   \n",
       "2          82402  Rotor A4 2022-01-31 23:27:53 2022-02-01 03:09:23   \n",
       "3          82403  Rotor A2 2022-01-31 23:26:11 2022-02-01 03:18:29   \n",
       "4          68050  Rotor A3 2022-02-01 01:03:26 2022-02-01 04:20:59   \n",
       "..           ...       ...                 ...                 ...   \n",
       "526        82403  Rotor A1 2022-02-28 20:14:35 2022-02-28 23:24:19   \n",
       "527        82402  Rotor B3 2022-02-28 23:24:00 2022-03-01 01:14:49   \n",
       "528        82403  Rotor A1 2022-02-28 23:29:09 2022-03-01 02:45:57   \n",
       "529        68050  Rotor C1 2022-02-28 23:46:24 2022-03-01 04:13:09   \n",
       "530        82401  Rotor A5 2022-02-28 12:27:06 2022-03-01 06:17:10   \n",
       "\n",
       "     EndDate min  \n",
       "0            0.0  \n",
       "1            1.0  \n",
       "2          127.0  \n",
       "3          136.0  \n",
       "4          199.0  \n",
       "..           ...  \n",
       "526      40222.0  \n",
       "527      40333.0  \n",
       "528      40424.0  \n",
       "529      40511.0  \n",
       "530      40635.0  \n",
       "\n",
       "[531 rows x 5 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kuka_output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "bfcafda8",
   "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>program name</th>\n",
       "      <th>product type</th>\n",
       "      <th>target temp (C)</th>\n",
       "      <th>program duration (min)</th>\n",
       "      <th>cooling temp  (C)</th>\n",
       "      <th>time to cooling (min)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A01 Kuk</td>\n",
       "      <td>Rotor A0</td>\n",
       "      <td>319.55085</td>\n",
       "      <td>260</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A01 Kuk</td>\n",
       "      <td>Rotor A1</td>\n",
       "      <td>319.55085</td>\n",
       "      <td>260</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A23 Kuk</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>319.55085</td>\n",
       "      <td>390</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A23 Kuk</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>319.55085</td>\n",
       "      <td>390</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A456 Kuk</td>\n",
       "      <td>Rotor A4</td>\n",
       "      <td>319.55085</td>\n",
       "      <td>400</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>A456 Kuk</td>\n",
       "      <td>Rotor A5</td>\n",
       "      <td>319.55085</td>\n",
       "      <td>400</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>A456 Kuk</td>\n",
       "      <td>Rotor A6</td>\n",
       "      <td>319.55085</td>\n",
       "      <td>400</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>B2 Kuk</td>\n",
       "      <td>Rotor B2</td>\n",
       "      <td>326.65198</td>\n",
       "      <td>240</td>\n",
       "      <td>71.01130</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>B3 Kuk</td>\n",
       "      <td>Rotor B3</td>\n",
       "      <td>326.65198</td>\n",
       "      <td>240</td>\n",
       "      <td>71.01130</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>B456+B6 Kuk</td>\n",
       "      <td>Rotor B4</td>\n",
       "      <td>326.65198</td>\n",
       "      <td>390</td>\n",
       "      <td>71.01130</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>B456+B6 Kuk</td>\n",
       "      <td>Rotor B5</td>\n",
       "      <td>326.65198</td>\n",
       "      <td>390</td>\n",
       "      <td>71.01130</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>B456+B6 Kuk</td>\n",
       "      <td>Rotor B6</td>\n",
       "      <td>326.65198</td>\n",
       "      <td>390</td>\n",
       "      <td>71.01130</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>B456+B6 Kuk</td>\n",
       "      <td>Blower B6</td>\n",
       "      <td>326.65198</td>\n",
       "      <td>390</td>\n",
       "      <td>71.01130</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B111 Kuk</td>\n",
       "      <td>Blower B111</td>\n",
       "      <td>326.65198</td>\n",
       "      <td>180</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>B142 146 200 Kuk</td>\n",
       "      <td>Blower B142</td>\n",
       "      <td>326.65198</td>\n",
       "      <td>180</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>B142 146 200 Kuk</td>\n",
       "      <td>Blower B146</td>\n",
       "      <td>326.65198</td>\n",
       "      <td>180</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>B142 146 200 Kuk</td>\n",
       "      <td>Blower B200</td>\n",
       "      <td>326.65198</td>\n",
       "      <td>180</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>C01 Kuk</td>\n",
       "      <td>Rotor C0</td>\n",
       "      <td>333.75311</td>\n",
       "      <td>180</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>C01 Kuk</td>\n",
       "      <td>Rotor C1</td>\n",
       "      <td>333.75311</td>\n",
       "      <td>180</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>C23 Kuk</td>\n",
       "      <td>Rotor C2</td>\n",
       "      <td>333.75311</td>\n",
       "      <td>210</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>C23 Kuk</td>\n",
       "      <td>Rotor C3</td>\n",
       "      <td>333.75311</td>\n",
       "      <td>210</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>C456 Kuk</td>\n",
       "      <td>Rotor C4</td>\n",
       "      <td>333.75311</td>\n",
       "      <td>240</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>C456 Kuk</td>\n",
       "      <td>Rotor C5</td>\n",
       "      <td>333.75311</td>\n",
       "      <td>240</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>C456 Kuk</td>\n",
       "      <td>Rotor C6</td>\n",
       "      <td>333.75311</td>\n",
       "      <td>240</td>\n",
       "      <td>42.60678</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        program name product type  target temp (C)  program duration (min)  \\\n",
       "0            A01 Kuk     Rotor A0        319.55085                     260   \n",
       "1            A01 Kuk     Rotor A1        319.55085                     260   \n",
       "2            A23 Kuk     Rotor A2        319.55085                     390   \n",
       "3            A23 Kuk     Rotor A3        319.55085                     390   \n",
       "4           A456 Kuk     Rotor A4        319.55085                     400   \n",
       "5           A456 Kuk     Rotor A5        319.55085                     400   \n",
       "6           A456 Kuk     Rotor A6        319.55085                     400   \n",
       "7             B2 Kuk     Rotor B2        326.65198                     240   \n",
       "8             B3 Kuk     Rotor B3        326.65198                     240   \n",
       "9        B456+B6 Kuk     Rotor B4        326.65198                     390   \n",
       "10       B456+B6 Kuk     Rotor B5        326.65198                     390   \n",
       "11       B456+B6 Kuk     Rotor B6        326.65198                     390   \n",
       "12       B456+B6 Kuk    Blower B6        326.65198                     390   \n",
       "13          B111 Kuk  Blower B111        326.65198                     180   \n",
       "14  B142 146 200 Kuk  Blower B142        326.65198                     180   \n",
       "15  B142 146 200 Kuk  Blower B146        326.65198                     180   \n",
       "16  B142 146 200 Kuk  Blower B200        326.65198                     180   \n",
       "17           C01 Kuk     Rotor C0        333.75311                     180   \n",
       "18           C01 Kuk     Rotor C1        333.75311                     180   \n",
       "19           C23 Kuk     Rotor C2        333.75311                     210   \n",
       "20           C23 Kuk     Rotor C3        333.75311                     210   \n",
       "21          C456 Kuk     Rotor C4        333.75311                     240   \n",
       "22          C456 Kuk     Rotor C5        333.75311                     240   \n",
       "23          C456 Kuk     Rotor C6        333.75311                     240   \n",
       "\n",
       "    cooling temp  (C)  time to cooling (min)  \n",
       "0            42.60678                     60  \n",
       "1            42.60678                     60  \n",
       "2            42.60678                     60  \n",
       "3            42.60678                     60  \n",
       "4            42.60678                     60  \n",
       "5            42.60678                     60  \n",
       "6            42.60678                     60  \n",
       "7            71.01130                     60  \n",
       "8            71.01130                     60  \n",
       "9            71.01130                     60  \n",
       "10           71.01130                     60  \n",
       "11           71.01130                     60  \n",
       "12           71.01130                     60  \n",
       "13           42.60678                     60  \n",
       "14           42.60678                     60  \n",
       "15           42.60678                     60  \n",
       "16           42.60678                     60  \n",
       "17           42.60678                     60  \n",
       "18           42.60678                     60  \n",
       "19           42.60678                     60  \n",
       "20           42.60678                     60  \n",
       "21           42.60678                     60  \n",
       "22           42.60678                     60  \n",
       "23           42.60678                     60  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "programs = pd.read_excel('OvenPrograms-ICNAP.xlsx', engine='openpyxl')\n",
    "programs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "9e54a105",
   "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>KukaRobotId</th>\n",
       "      <th>Product</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>EndDate min</th>\n",
       "      <th>oven_number</th>\n",
       "      <th>start_job</th>\n",
       "      <th>finish_job</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-01-31 20:13:35</td>\n",
       "      <td>2022-02-01 01:01:47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 01:02:12</td>\n",
       "      <td>2022-02-01 01:02:55</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>451.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor A4</td>\n",
       "      <td>2022-01-31 23:27:53</td>\n",
       "      <td>2022-02-01 03:09:23</td>\n",
       "      <td>127.0</td>\n",
       "      <td>2</td>\n",
       "      <td>127.0</td>\n",
       "      <td>587.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-01-31 23:26:11</td>\n",
       "      <td>2022-02-01 03:18:29</td>\n",
       "      <td>136.0</td>\n",
       "      <td>3</td>\n",
       "      <td>136.0</td>\n",
       "      <td>586.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 01:03:26</td>\n",
       "      <td>2022-02-01 04:20:59</td>\n",
       "      <td>199.0</td>\n",
       "      <td>4</td>\n",
       "      <td>199.0</td>\n",
       "      <td>649.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 04:21:22</td>\n",
       "      <td>2022-02-01 06:40:31</td>\n",
       "      <td>338.0</td>\n",
       "      <td>5</td>\n",
       "      <td>338.0</td>\n",
       "      <td>788.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor C1</td>\n",
       "      <td>2022-02-01 06:45:10</td>\n",
       "      <td>2022-02-01 06:45:43</td>\n",
       "      <td>343.0</td>\n",
       "      <td>0</td>\n",
       "      <td>450.0</td>\n",
       "      <td>690.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-02-01 03:18:34</td>\n",
       "      <td>2022-02-01 07:07:44</td>\n",
       "      <td>365.0</td>\n",
       "      <td>1</td>\n",
       "      <td>451.0</td>\n",
       "      <td>901.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor B3</td>\n",
       "      <td>2022-02-01 03:09:33</td>\n",
       "      <td>2022-02-01 09:46:59</td>\n",
       "      <td>525.0</td>\n",
       "      <td>3</td>\n",
       "      <td>586.0</td>\n",
       "      <td>886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor B3</td>\n",
       "      <td>2022-02-01 09:47:05</td>\n",
       "      <td>2022-02-01 09:53:56</td>\n",
       "      <td>532.0</td>\n",
       "      <td>2</td>\n",
       "      <td>587.0</td>\n",
       "      <td>887.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor B3</td>\n",
       "      <td>2022-02-01 09:54:00</td>\n",
       "      <td>2022-02-01 09:54:12</td>\n",
       "      <td>532.0</td>\n",
       "      <td>4</td>\n",
       "      <td>649.0</td>\n",
       "      <td>949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-02-01 07:08:01</td>\n",
       "      <td>2022-02-01 11:25:35</td>\n",
       "      <td>623.0</td>\n",
       "      <td>0</td>\n",
       "      <td>690.0</td>\n",
       "      <td>1140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>82401</td>\n",
       "      <td>Rotor A5</td>\n",
       "      <td>2022-02-01 09:13:24</td>\n",
       "      <td>2022-02-01 12:35:48</td>\n",
       "      <td>694.0</td>\n",
       "      <td>5</td>\n",
       "      <td>788.0</td>\n",
       "      <td>1248.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-02-01 09:40:23</td>\n",
       "      <td>2022-02-01 12:46:20</td>\n",
       "      <td>704.0</td>\n",
       "      <td>3</td>\n",
       "      <td>886.0</td>\n",
       "      <td>1336.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-02-01 12:46:33</td>\n",
       "      <td>2022-02-01 14:17:57</td>\n",
       "      <td>796.0</td>\n",
       "      <td>2</td>\n",
       "      <td>887.0</td>\n",
       "      <td>1337.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor B3</td>\n",
       "      <td>2022-02-01 12:36:10</td>\n",
       "      <td>2022-02-01 16:26:45</td>\n",
       "      <td>924.0</td>\n",
       "      <td>1</td>\n",
       "      <td>924.0</td>\n",
       "      <td>1224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-02-01 11:25:47</td>\n",
       "      <td>2022-02-01 17:47:42</td>\n",
       "      <td>1005.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1005.0</td>\n",
       "      <td>1455.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-02-01 17:48:06</td>\n",
       "      <td>2022-02-01 21:05:06</td>\n",
       "      <td>1203.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1203.0</td>\n",
       "      <td>1653.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-02-01 21:05:11</td>\n",
       "      <td>2022-02-01 23:28:59</td>\n",
       "      <td>1347.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1347.0</td>\n",
       "      <td>1797.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor A4</td>\n",
       "      <td>2022-02-01 23:33:14</td>\n",
       "      <td>2022-02-01 23:33:46</td>\n",
       "      <td>1351.0</td>\n",
       "      <td>5</td>\n",
       "      <td>1351.0</td>\n",
       "      <td>1811.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    KukaRobotId   Product           StartDate             EndDate  \\\n",
       "0         68051  Rotor A3 2022-01-31 20:13:35 2022-02-01 01:01:47   \n",
       "1         68051  Rotor A3 2022-02-01 01:02:12 2022-02-01 01:02:55   \n",
       "2         82402  Rotor A4 2022-01-31 23:27:53 2022-02-01 03:09:23   \n",
       "3         82403  Rotor A2 2022-01-31 23:26:11 2022-02-01 03:18:29   \n",
       "4         68050  Rotor A3 2022-02-01 01:03:26 2022-02-01 04:20:59   \n",
       "5         68050  Rotor A3 2022-02-01 04:21:22 2022-02-01 06:40:31   \n",
       "6         68050  Rotor C1 2022-02-01 06:45:10 2022-02-01 06:45:43   \n",
       "7         82403  Rotor A2 2022-02-01 03:18:34 2022-02-01 07:07:44   \n",
       "8         82402  Rotor B3 2022-02-01 03:09:33 2022-02-01 09:46:59   \n",
       "9         82402  Rotor B3 2022-02-01 09:47:05 2022-02-01 09:53:56   \n",
       "10        82402  Rotor B3 2022-02-01 09:54:00 2022-02-01 09:54:12   \n",
       "11        82403  Rotor A2 2022-02-01 07:08:01 2022-02-01 11:25:35   \n",
       "12        82401  Rotor A5 2022-02-01 09:13:24 2022-02-01 12:35:48   \n",
       "13        68051  Rotor A2 2022-02-01 09:40:23 2022-02-01 12:46:20   \n",
       "14        68051  Rotor A2 2022-02-01 12:46:33 2022-02-01 14:17:57   \n",
       "15        82402  Rotor B3 2022-02-01 12:36:10 2022-02-01 16:26:45   \n",
       "16        82403  Rotor A2 2022-02-01 11:25:47 2022-02-01 17:47:42   \n",
       "17        82403  Rotor A2 2022-02-01 17:48:06 2022-02-01 21:05:06   \n",
       "18        82403  Rotor A2 2022-02-01 21:05:11 2022-02-01 23:28:59   \n",
       "19        82402  Rotor A4 2022-02-01 23:33:14 2022-02-01 23:33:46   \n",
       "\n",
       "    EndDate min  oven_number  start_job  finish_job  \n",
       "0           0.0            0        0.0       450.0  \n",
       "1           1.0            1        1.0       451.0  \n",
       "2         127.0            2      127.0       587.0  \n",
       "3         136.0            3      136.0       586.0  \n",
       "4         199.0            4      199.0       649.0  \n",
       "5         338.0            5      338.0       788.0  \n",
       "6         343.0            0      450.0       690.0  \n",
       "7         365.0            1      451.0       901.0  \n",
       "8         525.0            3      586.0       886.0  \n",
       "9         532.0            2      587.0       887.0  \n",
       "10        532.0            4      649.0       949.0  \n",
       "11        623.0            0      690.0      1140.0  \n",
       "12        694.0            5      788.0      1248.0  \n",
       "13        704.0            3      886.0      1336.0  \n",
       "14        796.0            2      887.0      1337.0  \n",
       "15        924.0            1      924.0      1224.0  \n",
       "16       1005.0            4     1005.0      1455.0  \n",
       "17       1203.0            0     1203.0      1653.0  \n",
       "18       1347.0            1     1347.0      1797.0  \n",
       "19       1351.0            5     1351.0      1811.0  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ovens = []\n",
    "names = []\n",
    "ovens_index = []\n",
    "start_times = []\n",
    "end_times = []\n",
    "\n",
    "for i in range(kuka_output.shape[0]):\n",
    "    product = kuka_output['Product'].iloc[i]\n",
    "    time = kuka_output['EndDate min'].iloc[i]\n",
    "    duration = programs[programs['product type']==product]['program duration (min)'].values[0] + 60\n",
    "    if i < 6:\n",
    "        ovens.append([time+duration])\n",
    "        names.append([product])\n",
    "        ovens_index.append(i)\n",
    "        start_times.append(time)\n",
    "        end_times.append(time+duration)\n",
    "\n",
    "    else:\n",
    "        kt = [oven[-1]-time for oven in ovens]\n",
    "        index = kt.index(min(kt))\n",
    "        names[index].append(product)\n",
    "        ovens_index.append(index)\n",
    "        if min(kt) <= 0:\n",
    "            start_times.append(time)\n",
    "            end_times.append(time+duration)\n",
    "            ovens[index].append(time+duration)\n",
    "\n",
    "        else:\n",
    "            start_times.append(ovens[index][-1])\n",
    "            end_times.append(ovens[index][-1]+duration)\n",
    "            ovens[index].append(ovens[index][-1]+duration)\n",
    "\n",
    "\n",
    "kuka_output['oven_number'] = ovens_index\n",
    "kuka_output['start_job'] = start_times\n",
    "kuka_output['finish_job'] = end_times\n",
    "kuka_output.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "988fa8b1",
   "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>index</th>\n",
       "      <th>KukaRobotId</th>\n",
       "      <th>Product</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>EndDate min</th>\n",
       "      <th>oven_number</th>\n",
       "      <th>start_job</th>\n",
       "      <th>finish_job</th>\n",
       "      <th>start_job_date</th>\n",
       "      <th>finish_job_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-01-31 20:13:35</td>\n",
       "      <td>2022-02-01 01:01:47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>450.0</td>\n",
       "      <td>2022-02-01 01:01:47</td>\n",
       "      <td>2022-02-01 08:31:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 01:02:12</td>\n",
       "      <td>2022-02-01 01:02:55</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>451.0</td>\n",
       "      <td>2022-02-01 01:02:47</td>\n",
       "      <td>2022-02-01 08:32:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor A4</td>\n",
       "      <td>2022-01-31 23:27:53</td>\n",
       "      <td>2022-02-01 03:09:23</td>\n",
       "      <td>127.0</td>\n",
       "      <td>2</td>\n",
       "      <td>127.0</td>\n",
       "      <td>587.0</td>\n",
       "      <td>2022-02-01 03:08:47</td>\n",
       "      <td>2022-02-01 10:48:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-01-31 23:26:11</td>\n",
       "      <td>2022-02-01 03:18:29</td>\n",
       "      <td>136.0</td>\n",
       "      <td>3</td>\n",
       "      <td>136.0</td>\n",
       "      <td>586.0</td>\n",
       "      <td>2022-02-01 03:17:47</td>\n",
       "      <td>2022-02-01 10:47:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 01:03:26</td>\n",
       "      <td>2022-02-01 04:20:59</td>\n",
       "      <td>199.0</td>\n",
       "      <td>4</td>\n",
       "      <td>199.0</td>\n",
       "      <td>649.0</td>\n",
       "      <td>2022-02-01 04:20:47</td>\n",
       "      <td>2022-02-01 11:50:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 04:21:22</td>\n",
       "      <td>2022-02-01 06:40:31</td>\n",
       "      <td>338.0</td>\n",
       "      <td>5</td>\n",
       "      <td>338.0</td>\n",
       "      <td>788.0</td>\n",
       "      <td>2022-02-01 06:39:47</td>\n",
       "      <td>2022-02-01 14:09:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor C1</td>\n",
       "      <td>2022-02-01 06:45:10</td>\n",
       "      <td>2022-02-01 06:45:43</td>\n",
       "      <td>343.0</td>\n",
       "      <td>0</td>\n",
       "      <td>450.0</td>\n",
       "      <td>690.0</td>\n",
       "      <td>2022-02-01 08:31:47</td>\n",
       "      <td>2022-02-01 12:31:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-02-01 03:18:34</td>\n",
       "      <td>2022-02-01 07:07:44</td>\n",
       "      <td>365.0</td>\n",
       "      <td>1</td>\n",
       "      <td>451.0</td>\n",
       "      <td>901.0</td>\n",
       "      <td>2022-02-01 08:32:47</td>\n",
       "      <td>2022-02-01 16:02:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor B3</td>\n",
       "      <td>2022-02-01 03:09:33</td>\n",
       "      <td>2022-02-01 09:46:59</td>\n",
       "      <td>525.0</td>\n",
       "      <td>3</td>\n",
       "      <td>586.0</td>\n",
       "      <td>886.0</td>\n",
       "      <td>2022-02-01 10:47:47</td>\n",
       "      <td>2022-02-01 15:47:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor B3</td>\n",
       "      <td>2022-02-01 09:47:05</td>\n",
       "      <td>2022-02-01 09:53:56</td>\n",
       "      <td>532.0</td>\n",
       "      <td>2</td>\n",
       "      <td>587.0</td>\n",
       "      <td>887.0</td>\n",
       "      <td>2022-02-01 10:48:47</td>\n",
       "      <td>2022-02-01 15:48:47</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index  KukaRobotId   Product           StartDate             EndDate  \\\n",
       "0      0        68051  Rotor A3 2022-01-31 20:13:35 2022-02-01 01:01:47   \n",
       "1      1        68051  Rotor A3 2022-02-01 01:02:12 2022-02-01 01:02:55   \n",
       "2      2        82402  Rotor A4 2022-01-31 23:27:53 2022-02-01 03:09:23   \n",
       "3      3        82403  Rotor A2 2022-01-31 23:26:11 2022-02-01 03:18:29   \n",
       "4      4        68050  Rotor A3 2022-02-01 01:03:26 2022-02-01 04:20:59   \n",
       "5      5        68050  Rotor A3 2022-02-01 04:21:22 2022-02-01 06:40:31   \n",
       "6      6        68050  Rotor C1 2022-02-01 06:45:10 2022-02-01 06:45:43   \n",
       "7      7        82403  Rotor A2 2022-02-01 03:18:34 2022-02-01 07:07:44   \n",
       "8      8        82402  Rotor B3 2022-02-01 03:09:33 2022-02-01 09:46:59   \n",
       "9      9        82402  Rotor B3 2022-02-01 09:47:05 2022-02-01 09:53:56   \n",
       "\n",
       "   EndDate min  oven_number  start_job  finish_job      start_job_date  \\\n",
       "0          0.0            0        0.0       450.0 2022-02-01 01:01:47   \n",
       "1          1.0            1        1.0       451.0 2022-02-01 01:02:47   \n",
       "2        127.0            2      127.0       587.0 2022-02-01 03:08:47   \n",
       "3        136.0            3      136.0       586.0 2022-02-01 03:17:47   \n",
       "4        199.0            4      199.0       649.0 2022-02-01 04:20:47   \n",
       "5        338.0            5      338.0       788.0 2022-02-01 06:39:47   \n",
       "6        343.0            0      450.0       690.0 2022-02-01 08:31:47   \n",
       "7        365.0            1      451.0       901.0 2022-02-01 08:32:47   \n",
       "8        525.0            3      586.0       886.0 2022-02-01 10:47:47   \n",
       "9        532.0            2      587.0       887.0 2022-02-01 10:48:47   \n",
       "\n",
       "      finish_job_date  \n",
       "0 2022-02-01 08:31:47  \n",
       "1 2022-02-01 08:32:47  \n",
       "2 2022-02-01 10:48:47  \n",
       "3 2022-02-01 10:47:47  \n",
       "4 2022-02-01 11:50:47  \n",
       "5 2022-02-01 14:09:47  \n",
       "6 2022-02-01 12:31:47  \n",
       "7 2022-02-01 16:02:47  \n",
       "8 2022-02-01 15:47:47  \n",
       "9 2022-02-01 15:48:47  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kuka_output['start_job_date'] = t0 + pd.to_timedelta(kuka_output['start_job'], unit='m')\n",
    "kuka_output['finish_job_date'] = t0 + pd.to_timedelta(kuka_output['finish_job'], unit='m')\n",
    "kuka_output.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "ab87b47c",
   "metadata": {},
   "outputs": [],
   "source": [
    "kuka_output.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "7c8eca14",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.plotly.v1+json": {
       "config": {
        "plotlyServerURL": "https://plot.ly"
       },
       "data": [
        {
         "alignmentgroup": "True",
         "base": [
          "2022-02-01T01:01:47",
          "2022-02-01T01:02:47",
          "2022-02-01T04:20:47",
          "2022-02-01T06:39:47",
          "2022-02-04T00:44:47",
          "2022-02-04T03:20:47",
          "2022-02-04T05:57:47",
          "2022-02-04T07:11:47",
          "2022-02-04T09:39:47",
          "2022-02-04T12:04:47",
          "2022-02-04T13:27:47",
          "2022-02-04T22:11:47",
          "2022-02-05T14:58:47",
          "2022-02-05T17:41:47",
          "2022-02-05T20:58:47",
          "2022-02-05T23:41:47",
          "2022-02-06T04:02:47",
          "2022-02-06T09:29:47",
          "2022-02-06T22:34:47",
          "2022-02-07T00:51:47",
          "2022-02-07T07:20:47",
          "2022-02-07T08:21:47",
          "2022-02-07T16:00:47",
          "2022-02-07T19:20:47",
          "2022-02-08T07:00:47",
          "2022-02-08T13:01:47",
          "2022-02-08T14:30:47",
          "2022-02-08T17:04:47",
          "2022-02-09T08:14:47",
          "2022-02-09T11:14:47",
          "2022-02-09T17:10:47",
          "2022-02-09T18:21:47",
          "2022-02-12T01:24:47",
          "2022-02-13T06:44:47",
          "2022-02-13T13:11:47",
          "2022-02-13T14:54:47",
          "2022-02-13T14:54:47",
          "2022-02-13T14:54:47",
          "2022-02-14T00:50:47",
          "2022-02-14T05:09:47",
          "2022-02-14T12:29:47",
          "2022-02-14T12:30:47",
          "2022-02-15T01:29:47",
          "2022-02-15T03:30:47",
          "2022-02-15T03:39:47",
          "2022-02-15T03:56:47",
          "2022-02-15T08:59:47",
          "2022-02-15T11:00:47",
          "2022-02-17T09:15:47",
          "2022-02-17T13:13:47",
          "2022-02-17T14:38:47",
          "2022-02-17T17:54:47",
          "2022-02-17T22:08:47",
          "2022-02-18T02:14:47",
          "2022-02-18T04:13:47",
          "2022-02-18T09:44:47",
          "2022-02-20T00:18:47",
          "2022-02-20T05:15:47",
          "2022-02-20T22:38:47",
          "2022-02-21T06:08:47",
          "2022-02-23T15:35:47",
          "2022-02-23T20:52:47",
          "2022-02-24T04:22:47",
          "2022-02-24T06:03:47",
          "2022-02-27T22:52:47",
          "2022-02-28T00:58:47",
          "2022-02-28T01:16:47",
          "2022-02-28T01:20:47",
          "2022-02-28T04:15:47",
          "2022-02-28T06:22:47",
          "2022-02-28T08:50:47",
          "2022-02-28T11:45:47",
          "2022-02-28T13:52:47"
         ],
         "hovertemplate": "Product=Rotor A3<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>",
         "legendgroup": "Rotor A3",
         "marker": {
          "color": "#636efa"
         },
         "name": "Rotor A3",
         "offsetgroup": "Rotor A3",
         "orientation": "h",
         "showlegend": true,
         "text": [
          0,
          1,
          4,
          5,
          56,
          60,
          61,
          63,
          65,
          67,
          69,
          77,
          86,
          89,
          91,
          93,
          96,
          102,
          111,
          114,
          119,
          121,
          128,
          129,
          141,
          145,
          146,
          148,
          162,
          165,
          170,
          171,
          223,
          240,
          244,
          246,
          247,
          248,
          253,
          255,
          257,
          258,
          269,
          270,
          271,
          272,
          275,
          276,
          302,
          304,
          307,
          309,
          313,
          316,
          317,
          323,
          352,
          356,
          369,
          375,
          416,
          419,
          425,
          426,
          501,
          502,
          503,
          504,
          505,
          507,
          510,
          511,
          513
         ],
         "textposition": "auto",
         "type": "bar",
         "x": [
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000
         ],
         "xaxis": "x",
         "y": [
          0,
          1,
          4,
          5,
          1,
          3,
          5,
          0,
          2,
          3,
          5,
          0,
          4,
          1,
          5,
          4,
          0,
          2,
          3,
          5,
          1,
          5,
          4,
          1,
          4,
          0,
          4,
          2,
          2,
          3,
          4,
          5,
          2,
          3,
          2,
          1,
          3,
          4,
          3,
          5,
          0,
          1,
          5,
          1,
          0,
          4,
          5,
          1,
          3,
          1,
          4,
          2,
          4,
          5,
          1,
          5,
          2,
          3,
          1,
          1,
          0,
          1,
          1,
          2,
          0,
          3,
          4,
          5,
          1,
          0,
          5,
          1,
          0
         ],
         "yaxis": "y"
        },
        {
         "alignmentgroup": "True",
         "base": [
          "2022-02-01T03:08:47",
          "2022-02-01T23:32:47",
          "2022-02-01T23:34:47",
          "2022-02-06T01:49:47",
          "2022-02-06T05:11:47",
          "2022-02-06T06:40:47",
          "2022-02-06T07:11:47",
          "2022-02-06T08:28:47",
          "2022-02-06T11:51:47",
          "2022-02-06T14:54:47",
          "2022-02-06T17:10:47",
          "2022-02-06T17:11:47",
          "2022-02-06T17:12:47",
          "2022-02-06T17:49:47",
          "2022-02-07T08:20:47",
          "2022-02-07T12:01:47",
          "2022-02-07T13:34:47",
          "2022-02-07T13:44:47",
          "2022-02-08T01:54:47",
          "2022-02-08T04:44:47",
          "2022-02-08T06:51:47",
          "2022-02-08T12:24:47",
          "2022-02-08T20:31:47",
          "2022-02-08T22:11:47",
          "2022-02-09T02:00:47",
          "2022-02-09T08:11:47",
          "2022-02-09T15:44:47",
          "2022-02-09T18:44:47",
          "2022-02-09T23:21:47",
          "2022-02-10T01:51:47",
          "2022-02-10T17:24:47",
          "2022-02-10T20:40:47",
          "2022-02-11T00:51:47",
          "2022-02-11T13:01:47",
          "2022-02-11T14:10:47",
          "2022-02-11T15:41:47",
          "2022-02-11T21:50:47",
          "2022-02-11T22:04:47",
          "2022-02-13T14:07:47",
          "2022-02-13T16:33:47",
          "2022-02-14T00:27:47",
          "2022-02-14T00:29:47",
          "2022-02-14T04:39:47",
          "2022-02-14T12:46:47",
          "2022-02-14T19:59:47",
          "2022-02-14T20:21:47",
          "2022-02-16T17:23:47",
          "2022-02-16T20:07:47",
          "2022-02-16T23:26:47",
          "2022-02-17T03:47:47",
          "2022-02-17T10:41:47",
          "2022-02-17T14:24:47",
          "2022-02-17T16:45:47",
          "2022-02-17T18:34:47",
          "2022-02-18T00:25:47",
          "2022-02-18T01:24:47",
          "2022-02-20T02:07:47",
          "2022-02-20T02:28:47",
          "2022-02-20T06:49:47",
          "2022-02-20T11:01:47",
          "2022-02-20T12:46:47",
          "2022-02-20T12:46:47",
          "2022-02-20T13:06:47",
          "2022-02-20T20:26:47",
          "2022-02-20T22:48:47",
          "2022-02-21T02:11:47",
          "2022-02-21T04:06:47",
          "2022-02-21T04:06:47",
          "2022-02-21T04:16:47",
          "2022-02-21T06:28:47",
          "2022-02-21T09:51:47",
          "2022-02-22T08:35:47",
          "2022-02-22T21:15:47",
          "2022-02-22T23:44:47",
          "2022-02-23T03:42:47",
          "2022-02-23T05:32:47",
          "2022-02-23T13:12:47",
          "2022-02-23T16:42:47",
          "2022-02-23T22:23:47",
          "2022-02-24T00:22:47",
          "2022-02-24T06:35:47",
          "2022-02-24T08:02:47",
          "2022-02-24T13:33:47",
          "2022-02-24T15:42:47",
          "2022-02-25T09:22:47",
          "2022-02-25T10:32:47",
          "2022-02-25T12:55:47",
          "2022-02-25T18:12:47",
          "2022-02-27T02:12:47",
          "2022-02-27T05:38:47",
          "2022-02-27T07:35:47",
          "2022-02-27T09:56:47",
          "2022-02-27T15:12:47",
          "2022-02-27T17:18:47",
          "2022-02-27T17:36:47",
          "2022-02-27T20:35:47",
          "2022-02-28T04:19:47",
          "2022-02-28T08:28:47",
          "2022-02-28T08:46:47",
          "2022-02-28T11:59:47",
          "2022-02-28T19:15:47",
          "2022-02-28T19:39:47",
          "2022-02-28T21:22:47",
          "2022-03-01T00:00:47"
         ],
         "hovertemplate": "Product=Rotor A4<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>",
         "legendgroup": "Rotor A4",
         "marker": {
          "color": "#EF553B"
         },
         "name": "Rotor A4",
         "offsetgroup": "Rotor A4",
         "orientation": "h",
         "showlegend": true,
         "text": [
          2,
          19,
          20,
          95,
          98,
          99,
          100,
          101,
          103,
          105,
          106,
          107,
          108,
          109,
          120,
          123,
          124,
          125,
          136,
          138,
          140,
          144,
          151,
          153,
          156,
          161,
          168,
          172,
          174,
          177,
          191,
          193,
          196,
          209,
          211,
          213,
          218,
          219,
          245,
          249,
          251,
          252,
          254,
          260,
          263,
          265,
          287,
          291,
          294,
          297,
          303,
          306,
          308,
          310,
          314,
          315,
          354,
          355,
          357,
          359,
          360,
          361,
          362,
          367,
          370,
          371,
          372,
          373,
          374,
          376,
          377,
          385,
          397,
          399,
          402,
          404,
          412,
          417,
          420,
          423,
          428,
          429,
          432,
          435,
          451,
          452,
          454,
          458,
          482,
          484,
          487,
          489,
          493,
          496,
          497,
          498,
          506,
          508,
          509,
          512,
          517,
          518,
          520,
          522
         ],
         "textposition": "auto",
         "type": "bar",
         "x": [
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000
         ],
         "xaxis": "x",
         "y": [
          2,
          5,
          3,
          2,
          1,
          3,
          4,
          5,
          0,
          3,
          4,
          5,
          2,
          1,
          4,
          0,
          3,
          2,
          2,
          3,
          5,
          3,
          0,
          5,
          4,
          0,
          2,
          3,
          0,
          5,
          3,
          1,
          5,
          5,
          1,
          0,
          1,
          3,
          0,
          5,
          0,
          1,
          4,
          4,
          0,
          3,
          5,
          2,
          4,
          2,
          5,
          0,
          3,
          5,
          3,
          2,
          4,
          0,
          1,
          5,
          4,
          0,
          3,
          4,
          2,
          5,
          0,
          4,
          3,
          2,
          5,
          0,
          0,
          3,
          5,
          1,
          1,
          5,
          2,
          5,
          0,
          5,
          2,
          5,
          5,
          1,
          0,
          1,
          0,
          3,
          1,
          4,
          0,
          3,
          4,
          1,
          2,
          3,
          4,
          2,
          1,
          2,
          0,
          5
         ],
         "yaxis": "y"
        },
        {
         "alignmentgroup": "True",
         "base": [
          "2022-02-01T03:17:47",
          "2022-02-01T08:32:47",
          "2022-02-01T12:31:47",
          "2022-02-01T15:47:47",
          "2022-02-01T15:48:47",
          "2022-02-01T17:46:47",
          "2022-02-01T21:04:47",
          "2022-02-01T23:28:47",
          "2022-02-01T23:50:47",
          "2022-02-02T01:16:47",
          "2022-02-02T04:34:47",
          "2022-02-02T06:58:47",
          "2022-02-02T07:12:47",
          "2022-02-02T09:39:47",
          "2022-02-02T12:59:47",
          "2022-02-02T14:28:47",
          "2022-02-02T17:36:47",
          "2022-02-02T17:38:47",
          "2022-02-02T20:21:47",
          "2022-02-02T20:29:47",
          "2022-02-02T23:57:47",
          "2022-02-03T02:14:47",
          "2022-02-03T03:37:47",
          "2022-02-03T03:39:47",
          "2022-02-03T04:41:47",
          "2022-02-03T07:27:47",
          "2022-02-03T09:44:47",
          "2022-02-03T11:09:47",
          "2022-02-03T12:11:47",
          "2022-02-03T12:20:47",
          "2022-02-03T18:39:47",
          "2022-02-03T19:41:47",
          "2022-02-03T19:50:47",
          "2022-02-03T22:27:47",
          "2022-02-04T02:09:47",
          "2022-02-04T18:42:47",
          "2022-02-06T23:31:47",
          "2022-02-07T00:50:47",
          "2022-02-07T00:52:47",
          "2022-02-07T06:04:47",
          "2022-02-07T15:51:47",
          "2022-02-07T21:14:47",
          "2022-02-07T23:21:47",
          "2022-02-07T23:30:47",
          "2022-02-08T02:50:47",
          "2022-02-08T05:31:47",
          "2022-02-08T09:34:47",
          "2022-02-08T10:20:47",
          "2022-02-09T03:44:47",
          "2022-02-09T05:51:47",
          "2022-02-09T09:40:47",
          "2022-02-09T14:30:47",
          "2022-02-09T15:51:47",
          "2022-02-09T22:00:47",
          "2022-02-09T23:24:47",
          "2022-02-10T02:24:47",
          "2022-02-10T05:30:47",
          "2022-02-10T07:01:47",
          "2022-02-10T09:54:47",
          "2022-02-10T16:54:47",
          "2022-02-14T07:38:47",
          "2022-02-14T12:59:47",
          "2022-02-14T20:00:47",
          "2022-02-14T20:26:47",
          "2022-02-16T17:24:47",
          "2022-02-16T20:38:47",
          "2022-02-16T23:08:47",
          "2022-02-17T01:29:47",
          "2022-02-18T19:40:47",
          "2022-02-18T23:23:47",
          "2022-02-19T08:45:47",
          "2022-02-19T10:29:47",
          "2022-02-20T07:48:47",
          "2022-02-20T15:18:47",
          "2022-02-20T18:41:47",
          "2022-02-20T20:46:47",
          "2022-02-21T18:06:47",
          "2022-02-21T18:27:47",
          "2022-02-21T21:18:47",
          "2022-02-22T12:42:47",
          "2022-02-22T15:23:47",
          "2022-02-22T17:51:47",
          "2022-02-22T20:12:47",
          "2022-02-22T22:53:47",
          "2022-02-23T14:53:47",
          "2022-02-23T18:03:47",
          "2022-02-23T23:04:47",
          "2022-02-23T23:05:47",
          "2022-02-24T06:34:47",
          "2022-02-24T11:52:47",
          "2022-02-24T14:04:47",
          "2022-02-24T14:15:47",
          "2022-02-24T16:53:47",
          "2022-02-24T19:22:47",
          "2022-02-24T21:45:47",
          "2022-02-25T10:43:47",
          "2022-02-25T17:02:47",
          "2022-02-25T18:13:47",
          "2022-02-26T05:19:47",
          "2022-02-26T05:20:47",
          "2022-02-26T11:06:47",
          "2022-02-26T16:25:47",
          "2022-02-26T22:08:47",
          "2022-02-26T22:30:47",
          "2022-02-28T16:26:47",
          "2022-02-28T21:08:47",
          "2022-02-28T23:56:47",
          "2022-03-01T02:55:47"
         ],
         "hovertemplate": "Product=Rotor A2<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>",
         "legendgroup": "Rotor A2",
         "marker": {
          "color": "#00cc96"
         },
         "name": "Rotor A2",
         "offsetgroup": "Rotor A2",
         "orientation": "h",
         "showlegend": true,
         "text": [
          3,
          7,
          11,
          13,
          14,
          16,
          17,
          18,
          21,
          22,
          23,
          24,
          25,
          27,
          29,
          30,
          33,
          34,
          35,
          36,
          37,
          38,
          39,
          40,
          42,
          43,
          44,
          46,
          47,
          48,
          52,
          53,
          54,
          55,
          58,
          72,
          112,
          113,
          115,
          117,
          127,
          131,
          133,
          134,
          137,
          139,
          142,
          143,
          157,
          160,
          164,
          167,
          169,
          173,
          175,
          178,
          179,
          181,
          184,
          189,
          256,
          261,
          264,
          266,
          288,
          292,
          293,
          296,
          330,
          332,
          339,
          340,
          358,
          364,
          365,
          368,
          379,
          380,
          383,
          389,
          391,
          394,
          396,
          398,
          414,
          418,
          421,
          422,
          427,
          431,
          433,
          434,
          436,
          437,
          440,
          453,
          457,
          459,
          461,
          462,
          468,
          473,
          478,
          480,
          516,
          519,
          521,
          523
         ],
         "textposition": "auto",
         "type": "bar",
         "x": [
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000
         ],
         "xaxis": "x",
         "y": [
          3,
          1,
          0,
          3,
          2,
          4,
          0,
          1,
          2,
          4,
          0,
          1,
          5,
          2,
          0,
          1,
          4,
          2,
          3,
          0,
          5,
          1,
          4,
          2,
          0,
          5,
          1,
          2,
          0,
          3,
          2,
          0,
          3,
          5,
          2,
          4,
          0,
          4,
          2,
          3,
          5,
          3,
          5,
          4,
          1,
          0,
          2,
          1,
          3,
          5,
          4,
          1,
          0,
          1,
          2,
          3,
          1,
          0,
          3,
          2,
          2,
          5,
          1,
          4,
          1,
          3,
          0,
          5,
          1,
          5,
          2,
          5,
          2,
          2,
          5,
          3,
          4,
          3,
          5,
          5,
          4,
          2,
          5,
          4,
          2,
          4,
          3,
          0,
          3,
          1,
          3,
          0,
          4,
          1,
          0,
          4,
          5,
          4,
          3,
          0,
          4,
          1,
          3,
          5,
          4,
          3,
          4,
          1
         ],
         "yaxis": "y"
        },
        {
         "alignmentgroup": "True",
         "base": [
          "2022-02-01T08:31:47",
          "2022-02-06T01:11:47",
          "2022-02-06T04:28:47",
          "2022-02-06T13:49:47",
          "2022-02-06T19:31:47",
          "2022-02-08T22:00:47",
          "2022-02-09T01:30:47",
          "2022-02-09T04:11:47",
          "2022-02-09T05:30:47",
          "2022-02-11T01:04:47",
          "2022-02-11T03:11:47",
          "2022-02-11T11:41:47",
          "2022-02-11T13:24:47",
          "2022-02-11T17:24:47",
          "2022-02-11T18:04:47",
          "2022-02-11T20:41:47",
          "2022-02-11T21:24:47",
          "2022-02-13T08:35:47",
          "2022-02-13T08:36:47",
          "2022-02-13T10:52:47",
          "2022-02-13T20:41:47",
          "2022-02-16T01:05:47",
          "2022-02-16T08:52:47",
          "2022-02-16T18:08:47",
          "2022-02-16T18:09:47",
          "2022-02-17T00:54:47",
          "2022-02-17T04:58:47",
          "2022-02-17T05:11:47",
          "2022-02-17T13:38:47",
          "2022-02-18T05:38:47",
          "2022-02-18T19:23:47",
          "2022-02-18T23:52:47",
          "2022-02-19T14:47:47",
          "2022-02-19T20:15:47",
          "2022-02-19T20:15:47",
          "2022-02-21T20:10:47",
          "2022-02-22T12:41:47",
          "2022-02-23T01:32:47",
          "2022-02-23T01:33:47",
          "2022-02-23T07:24:47",
          "2022-02-23T10:53:47",
          "2022-02-23T11:24:47",
          "2022-02-23T14:03:47",
          "2022-02-25T15:33:47",
          "2022-02-25T15:34:47",
          "2022-02-26T07:06:47",
          "2022-02-26T07:09:47",
          "2022-02-26T14:08:47",
          "2022-02-27T11:19:47",
          "2022-02-27T13:18:47",
          "2022-02-27T21:20:47",
          "2022-03-01T08:19:47"
         ],
         "hovertemplate": "Product=Rotor C1<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>",
         "legendgroup": "Rotor C1",
         "marker": {
          "color": "#ab63fa"
         },
         "name": "Rotor C1",
         "offsetgroup": "Rotor C1",
         "orientation": "h",
         "showlegend": true,
         "text": [
          6,
          94,
          97,
          104,
          110,
          152,
          155,
          158,
          159,
          197,
          198,
          208,
          210,
          214,
          215,
          216,
          217,
          241,
          242,
          243,
          250,
          282,
          284,
          289,
          290,
          295,
          298,
          299,
          305,
          319,
          329,
          334,
          342,
          346,
          347,
          382,
          388,
          400,
          401,
          407,
          409,
          411,
          413,
          455,
          456,
          464,
          465,
          470,
          490,
          491,
          500,
          529
         ],
         "textposition": "auto",
         "type": "bar",
         "x": [
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000
         ],
         "xaxis": "x",
         "y": [
          0,
          1,
          5,
          1,
          0,
          4,
          1,
          0,
          1,
          3,
          0,
          0,
          2,
          2,
          3,
          5,
          2,
          0,
          1,
          5,
          2,
          1,
          4,
          0,
          4,
          1,
          3,
          1,
          2,
          4,
          5,
          0,
          3,
          5,
          3,
          2,
          1,
          1,
          2,
          3,
          2,
          3,
          4,
          2,
          3,
          4,
          1,
          3,
          2,
          3,
          5,
          2
         ],
         "yaxis": "y"
        },
        {
         "alignmentgroup": "True",
         "base": [
          "2022-02-01T10:47:47",
          "2022-02-01T10:48:47",
          "2022-02-01T11:50:47",
          "2022-02-01T16:25:47",
          "2022-02-05T08:01:47",
          "2022-02-05T09:48:47",
          "2022-02-07T02:20:47",
          "2022-02-07T07:01:47",
          "2022-02-09T09:30:47",
          "2022-02-09T13:21:47",
          "2022-02-10T06:54:47",
          "2022-02-10T08:20:47",
          "2022-02-10T11:54:47",
          "2022-02-10T14:31:47",
          "2022-02-12T00:41:47",
          "2022-02-12T12:03:47",
          "2022-02-12T13:56:47",
          "2022-02-12T17:41:47",
          "2022-02-14T20:29:47",
          "2022-02-14T23:11:47",
          "2022-02-17T06:38:47",
          "2022-02-17T07:12:47",
          "2022-02-18T08:05:47",
          "2022-02-18T09:38:47",
          "2022-02-19T20:29:47",
          "2022-02-20T00:15:47",
          "2022-02-22T10:23:47",
          "2022-02-22T12:51:47",
          "2022-02-22T16:15:47",
          "2022-02-22T18:44:47",
          "2022-02-24T23:22:47",
          "2022-02-25T02:54:47",
          "2022-02-25T04:22:47",
          "2022-02-25T05:43:47",
          "2022-02-26T05:32:47",
          "2022-02-26T08:51:47",
          "2022-02-28T16:08:47",
          "2022-03-01T03:19:47",
          "2022-03-01T04:38:47",
          "2022-03-01T07:26:47"
         ],
         "hovertemplate": "Product=Rotor B3<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>",
         "legendgroup": "Rotor B3",
         "marker": {
          "color": "#FFA15A"
         },
         "name": "Rotor B3",
         "offsetgroup": "Rotor B3",
         "orientation": "h",
         "showlegend": true,
         "text": [
          8,
          9,
          10,
          15,
          80,
          81,
          116,
          118,
          163,
          166,
          180,
          182,
          185,
          188,
          222,
          225,
          227,
          230,
          267,
          268,
          300,
          301,
          320,
          322,
          348,
          350,
          386,
          390,
          392,
          395,
          441,
          445,
          446,
          448,
          463,
          466,
          514,
          524,
          525,
          527
         ],
         "textposition": "auto",
         "type": "bar",
         "x": [
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000,
          18000000
         ],
         "xaxis": "x",
         "y": [
          3,
          2,
          4,
          1,
          4,
          3,
          1,
          0,
          1,
          5,
          2,
          4,
          2,
          0,
          5,
          5,
          4,
          1,
          5,
          2,
          0,
          4,
          3,
          4,
          1,
          3,
          4,
          2,
          0,
          3,
          5,
          3,
          5,
          4,
          5,
          2,
          3,
          2,
          3,
          4
         ],
         "yaxis": "y"
        },
        {
         "alignmentgroup": "True",
         "base": [
          "2022-02-01T14:09:47",
          "2022-02-03T04:40:47",
          "2022-02-04T19:34:47",
          "2022-02-04T21:09:47",
          "2022-02-10T00:40:47",
          "2022-02-12T22:41:47",
          "2022-02-13T02:17:47",
          "2022-02-14T12:41:47",
          "2022-02-14T15:08:47",
          "2022-02-15T05:31:47",
          "2022-02-15T05:31:47",
          "2022-02-15T11:09:47",
          "2022-02-15T12:38:47",
          "2022-02-19T13:04:47",
          "2022-02-19T18:48:47",
          "2022-02-20T00:15:47",
          "2022-02-21T17:32:47",
          "2022-02-21T18:32:47",
          "2022-02-22T11:04:47",
          "2022-02-22T16:41:47",
          "2022-02-25T02:52:47",
          "2022-02-25T05:15:47",
          "2022-02-25T07:53:47",
          "2022-02-25T07:54:47",
          "2022-02-25T19:33:47",
          "2022-02-27T13:40:47",
          "2022-02-27T20:39:47",
          "2022-03-01T09:38:47"
         ],
         "hovertemplate": "Product=Rotor A5<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>",
         "legendgroup": "Rotor A5",
         "marker": {
          "color": "#19d3f3"
         },
         "name": "Rotor A5",
         "offsetgroup": "Rotor A5",
         "orientation": "h",
         "showlegend": true,
         "text": [
          12,
          41,
          73,
          76,
          176,
          236,
          238,
          259,
          262,
          273,
          274,
          277,
          278,
          341,
          344,
          351,
          378,
          381,
          387,
          393,
          444,
          447,
          449,
          450,
          460,
          492,
          499,
          530
         ],
         "textposition": "auto",
         "type": "bar",
         "x": [
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000
         ],
         "xaxis": "x",
         "y": [
          5,
          3,
          3,
          2,
          4,
          1,
          2,
          3,
          2,
          3,
          2,
          0,
          4,
          4,
          0,
          5,
          0,
          1,
          3,
          1,
          1,
          0,
          2,
          3,
          2,
          5,
          2,
          3
         ],
         "yaxis": "y"
        },
        {
         "alignmentgroup": "True",
         "base": [
          "2022-02-02T09:19:47",
          "2022-02-02T11:17:47",
          "2022-02-02T15:01:47",
          "2022-02-02T16:27:47",
          "2022-02-05T06:10:47",
          "2022-02-05T12:21:47",
          "2022-02-05T16:51:47",
          "2022-02-08T00:11:47",
          "2022-02-11T04:20:47",
          "2022-02-11T05:04:47",
          "2022-02-11T08:04:47",
          "2022-02-11T09:10:47",
          "2022-02-12T15:37:47",
          "2022-02-12T20:57:47",
          "2022-02-19T14:49:47",
          "2022-02-19T18:58:47",
          "2022-02-19T20:44:47",
          "2022-02-20T01:29:47",
          "2022-02-23T04:55:47",
          "2022-02-23T05:33:47",
          "2022-02-23T10:15:47",
          "2022-02-23T11:22:47",
          "2022-02-24T21:13:47",
          "2022-02-24T21:34:47",
          "2022-02-25T00:23:47",
          "2022-02-25T02:33:47",
          "2022-02-27T05:59:47",
          "2022-02-27T09:52:47",
          "2022-02-27T15:15:47",
          "2022-02-27T15:19:47",
          "2022-03-01T05:02:47",
          "2022-03-01T07:40:47"
         ],
         "hovertemplate": "Product=Rotor A1<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>",
         "legendgroup": "Rotor A1",
         "marker": {
          "color": "#FF6692"
         },
         "name": "Rotor A1",
         "offsetgroup": "Rotor A1",
         "orientation": "h",
         "showlegend": true,
         "text": [
          26,
          28,
          31,
          32,
          78,
          85,
          87,
          135,
          199,
          201,
          203,
          205,
          229,
          234,
          343,
          345,
          349,
          353,
          403,
          405,
          408,
          410,
          438,
          439,
          442,
          443,
          485,
          488,
          494,
          495,
          526,
          528
         ],
         "textposition": "auto",
         "type": "bar",
         "x": [
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000,
          19200000
         ],
         "xaxis": "x",
         "y": [
          3,
          4,
          3,
          5,
          1,
          1,
          3,
          0,
          1,
          3,
          2,
          4,
          2,
          2,
          1,
          2,
          4,
          1,
          0,
          2,
          0,
          5,
          2,
          3,
          4,
          2,
          2,
          0,
          1,
          2,
          0,
          5
         ],
         "yaxis": "y"
        },
        {
         "alignmentgroup": "True",
         "base": [
          "2022-02-03T11:07:47",
          "2022-02-03T14:57:47",
          "2022-02-03T17:14:47",
          "2022-02-03T18:37:47",
          "2022-02-04T12:14:47",
          "2022-02-04T14:41:47",
          "2022-02-12T18:56:47",
          "2022-02-12T19:53:47",
          "2022-02-16T08:56:47",
          "2022-02-16T08:57:47",
          "2022-02-17T20:43:47",
          "2022-02-17T22:04:47",
          "2022-02-18T16:21:47",
          "2022-02-18T16:22:47"
         ],
         "hovertemplate": "Product=Rotor B6<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>",
         "legendgroup": "Rotor B6",
         "marker": {
          "color": "#B6E880"
         },
         "name": "Rotor B6",
         "offsetgroup": "Rotor B6",
         "orientation": "h",
         "showlegend": true,
         "text": [
          45,
          49,
          50,
          51,
          68,
          70,
          232,
          233,
          285,
          286,
          311,
          312,
          325,
          326
         ],
         "textposition": "auto",
         "type": "bar",
         "x": [
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000,
          27000000
         ],
         "xaxis": "x",
         "y": [
          4,
          5,
          1,
          4,
          1,
          0,
          4,
          3,
          2,
          3,
          1,
          0,
          3,
          0
         ],
         "yaxis": "y"
        },
        {
         "alignmentgroup": "True",
         "base": [
          "2022-02-04T02:07:47",
          "2022-02-04T03:11:47",
          "2022-02-04T06:07:47",
          "2022-02-04T08:14:47",
          "2022-02-04T17:09:47",
          "2022-02-04T19:44:47",
          "2022-02-04T20:57:47",
          "2022-02-05T06:38:47",
          "2022-02-15T18:10:47",
          "2022-02-15T20:09:47",
          "2022-02-15T21:44:47",
          "2022-02-16T03:30:47",
          "2022-02-18T18:22:47",
          "2022-02-18T23:51:47",
          "2022-02-19T06:06:47",
          "2022-02-19T08:02:47",
          "2022-02-26T12:25:47",
          "2022-02-26T14:32:47",
          "2022-02-26T18:08:47",
          "2022-02-26T18:30:47"
         ],
         "hovertemplate": "Product=Rotor C0<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>",
         "legendgroup": "Rotor C0",
         "marker": {
          "color": "#FF97FF"
         },
         "name": "Rotor C0",
         "offsetgroup": "Rotor C0",
         "orientation": "h",
         "showlegend": true,
         "text": [
          57,
          59,
          62,
          64,
          71,
          74,
          75,
          79,
          279,
          280,
          281,
          283,
          328,
          333,
          335,
          337,
          469,
          471,
          474,
          475
         ],
         "textposition": "auto",
         "type": "bar",
         "x": [
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000,
          14400000
         ],
         "xaxis": "x",
         "y": [
          4,
          0,
          4,
          1,
          2,
          1,
          5,
          5,
          2,
          3,
          5,
          0,
          2,
          3,
          4,
          3,
          1,
          0,
          3,
          5
         ],
         "yaxis": "y"
        },
        {
         "alignmentgroup": "True",
         "base": [
          "2022-02-04T11:02:47",
          "2022-02-05T09:54:47",
          "2022-02-05T10:16:47",
          "2022-02-05T10:38:47",
          "2022-02-05T17:34:47",
          "2022-02-05T20:22:47",
          "2022-02-05T23:00:47",
          "2022-02-08T14:31:47",
          "2022-02-08T17:50:47",
          "2022-02-08T20:04:47",
          "2022-02-09T00:34:47",
          "2022-02-10T09:31:47",
          "2022-02-10T13:00:47",
          "2022-02-10T13:20:47",
          "2022-02-10T17:11:47",
          "2022-02-10T19:31:47",
          "2022-02-10T21:00:47",
          "2022-02-11T00:24:47",
          "2022-02-11T10:24:47",
          "2022-02-11T14:30:47",
          "2022-02-11T22:10:47",
          "2022-02-11T23:21:47",
          "2022-02-12T06:20:47",
          "2022-02-12T12:13:47",
          "2022-02-12T15:01:47",
          "2022-02-12T17:53:47",
          "2022-02-12T22:41:47",
          "2022-02-13T01:33:47",
          "2022-02-13T06:35:47",
          "2022-02-18T05:34:47",
          "2022-02-18T09:04:47",
          "2022-02-18T11:43:47",
          "2022-02-18T17:26:47",
          "2022-02-18T22:22:47",
          "2022-02-19T06:56:47",
          "2022-02-19T08:32:47",
          "2022-02-20T14:58:47",
          "2022-02-20T20:26:47",
          "2022-02-22T00:10:47",
          "2022-02-23T06:23:47",
          "2022-02-23T15:24:47",
          "2022-02-24T01:33:47",
          "2022-02-24T09:13:47",
          "2022-02-26T10:50:47",
          "2022-02-26T14:39:47",
          "2022-02-26T18:32:47",
          "2022-02-26T18:36:47",
          "2022-02-26T22:19:47",
          "2022-02-26T23:55:47",
          "2022-02-27T02:16:47",
          "2022-02-27T06:00:47",
          "2022-02-28T16:20:47"
         ],
         "hovertemplate": "Product=Rotor A6<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>",
         "legendgroup": "Rotor A6",
         "marker": {
          "color": "#FECB52"
         },
         "name": "Rotor A6",
         "offsetgroup": "Rotor A6",
         "orientation": "h",
         "showlegend": true,
         "text": [
          66,
          82,
          83,
          84,
          88,
          90,
          92,
          147,
          149,
          150,
          154,
          183,
          186,
          187,
          190,
          192,
          194,
          195,
          207,
          212,
          220,
          221,
          224,
          226,
          228,
          231,
          235,
          237,
          239,
          318,
          321,
          324,
          327,
          331,
          336,
          338,
          363,
          366,
          384,
          406,
          415,
          424,
          430,
          467,
          472,
          476,
          477,
          479,
          481,
          483,
          486,
          515
         ],
         "textposition": "auto",
         "type": "bar",
         "x": [
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000,
          27600000
         ],
         "xaxis": "x",
         "y": [
          4,
          2,
          0,
          5,
          2,
          0,
          3,
          5,
          1,
          3,
          2,
          5,
          1,
          4,
          5,
          0,
          4,
          2,
          3,
          4,
          4,
          0,
          1,
          3,
          0,
          5,
          0,
          5,
          4,
          0,
          2,
          1,
          4,
          2,
          1,
          0,
          1,
          0,
          2,
          4,
          3,
          4,
          4,
          5,
          2,
          0,
          4,
          2,
          1,
          4,
          5,
          5
         ],
         "yaxis": "y"
        },
        {
         "alignmentgroup": "True",
         "base": [
          "2022-02-07T09:14:47",
          "2022-02-07T14:50:47",
          "2022-02-07T19:41:47",
          "2022-02-07T21:24:47",
          "2022-02-11T04:40:47",
          "2022-02-11T07:11:47",
          "2022-02-11T08:31:47",
          "2022-02-11T09:40:47"
         ],
         "hovertemplate": "Product=Rotor C3<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>",
         "legendgroup": "Rotor C3",
         "marker": {
          "color": "#636efa"
         },
         "name": "Rotor C3",
         "offsetgroup": "Rotor C3",
         "orientation": "h",
         "showlegend": true,
         "text": [
          122,
          126,
          130,
          132,
          200,
          202,
          204,
          206
         ],
         "textposition": "auto",
         "type": "bar",
         "x": [
          16200000,
          16200000,
          16200000,
          16200000,
          16200000,
          16200000,
          16200000,
          16200000
         ],
         "xaxis": "x",
         "y": [
          2,
          1,
          0,
          2,
          4,
          0,
          5,
          1
         ],
         "yaxis": "y"
        }
       ],
       "layout": {
        "barmode": "overlay",
        "legend": {
         "title": {
          "text": "Product"
         },
         "tracegroupgap": 0
        },
        "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,
              "#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,
              "#f0f921"
             ]
            ],
            "type": "contour"
           }
          ],
          "contourcarpet": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "contourcarpet"
           }
          ],
          "heatmap": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              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,
              "#f0f921"
             ]
            ],
            "type": "heatmap"
           }
          ],
          "heatmapgl": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              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,
              "#f0f921"
             ]
            ],
            "type": "heatmapgl"
           }
          ],
          "histogram": [
           {
            "marker": {
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "histogram"
           }
          ],
          "histogram2d": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              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,
              "#f0f921"
             ]
            ],
            "type": "histogram2d"
           }
          ],
          "histogram2dcontour": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              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,
              "#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,
              "#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,
              "#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,
             "#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,
             "#f0f921"
            ]
           ],
           "sequentialminus": [
            [
             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,
             "#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
          }
         }
        },
        "xaxis": {
         "anchor": "y",
         "domain": [
          0,
          1
         ],
         "type": "date"
        },
        "yaxis": {
         "anchor": "x",
         "autorange": "reversed",
         "domain": [
          0,
          1
         ],
         "title": {
          "text": "oven_number"
         }
        }
       }
      },
      "text/html": [
       "<div>                            <div id=\"096171a8-4349-48e2-a42e-f7e37290848a\" class=\"plotly-graph-div\" style=\"height:525px; width:100%;\"></div>            <script type=\"text/javascript\">                require([\"plotly\"], function(Plotly) {                    window.PLOTLYENV=window.PLOTLYENV || {};                                    if (document.getElementById(\"096171a8-4349-48e2-a42e-f7e37290848a\")) {                    Plotly.newPlot(                        \"096171a8-4349-48e2-a42e-f7e37290848a\",                        [{\"alignmentgroup\":\"True\",\"base\":[\"2022-02-01T01:01:47\",\"2022-02-01T01:02:47\",\"2022-02-01T04:20:47\",\"2022-02-01T06:39:47\",\"2022-02-04T00:44:47\",\"2022-02-04T03:20:47\",\"2022-02-04T05:57:47\",\"2022-02-04T07:11:47\",\"2022-02-04T09:39:47\",\"2022-02-04T12:04:47\",\"2022-02-04T13:27:47\",\"2022-02-04T22:11:47\",\"2022-02-05T14:58:47\",\"2022-02-05T17:41:47\",\"2022-02-05T20:58:47\",\"2022-02-05T23:41:47\",\"2022-02-06T04:02:47\",\"2022-02-06T09:29:47\",\"2022-02-06T22:34:47\",\"2022-02-07T00:51:47\",\"2022-02-07T07:20:47\",\"2022-02-07T08:21:47\",\"2022-02-07T16:00:47\",\"2022-02-07T19:20:47\",\"2022-02-08T07:00:47\",\"2022-02-08T13:01:47\",\"2022-02-08T14:30:47\",\"2022-02-08T17:04:47\",\"2022-02-09T08:14:47\",\"2022-02-09T11:14:47\",\"2022-02-09T17:10:47\",\"2022-02-09T18:21:47\",\"2022-02-12T01:24:47\",\"2022-02-13T06:44:47\",\"2022-02-13T13:11:47\",\"2022-02-13T14:54:47\",\"2022-02-13T14:54:47\",\"2022-02-13T14:54:47\",\"2022-02-14T00:50:47\",\"2022-02-14T05:09:47\",\"2022-02-14T12:29:47\",\"2022-02-14T12:30:47\",\"2022-02-15T01:29:47\",\"2022-02-15T03:30:47\",\"2022-02-15T03:39:47\",\"2022-02-15T03:56:47\",\"2022-02-15T08:59:47\",\"2022-02-15T11:00:47\",\"2022-02-17T09:15:47\",\"2022-02-17T13:13:47\",\"2022-02-17T14:38:47\",\"2022-02-17T17:54:47\",\"2022-02-17T22:08:47\",\"2022-02-18T02:14:47\",\"2022-02-18T04:13:47\",\"2022-02-18T09:44:47\",\"2022-02-20T00:18:47\",\"2022-02-20T05:15:47\",\"2022-02-20T22:38:47\",\"2022-02-21T06:08:47\",\"2022-02-23T15:35:47\",\"2022-02-23T20:52:47\",\"2022-02-24T04:22:47\",\"2022-02-24T06:03:47\",\"2022-02-27T22:52:47\",\"2022-02-28T00:58:47\",\"2022-02-28T01:16:47\",\"2022-02-28T01:20:47\",\"2022-02-28T04:15:47\",\"2022-02-28T06:22:47\",\"2022-02-28T08:50:47\",\"2022-02-28T11:45:47\",\"2022-02-28T13:52:47\"],\"hovertemplate\":\"Product=Rotor A3<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>\",\"legendgroup\":\"Rotor A3\",\"marker\":{\"color\":\"#636efa\"},\"name\":\"Rotor A3\",\"offsetgroup\":\"Rotor A3\",\"orientation\":\"h\",\"showlegend\":true,\"text\":[0.0,1.0,4.0,5.0,56.0,60.0,61.0,63.0,65.0,67.0,69.0,77.0,86.0,89.0,91.0,93.0,96.0,102.0,111.0,114.0,119.0,121.0,128.0,129.0,141.0,145.0,146.0,148.0,162.0,165.0,170.0,171.0,223.0,240.0,244.0,246.0,247.0,248.0,253.0,255.0,257.0,258.0,269.0,270.0,271.0,272.0,275.0,276.0,302.0,304.0,307.0,309.0,313.0,316.0,317.0,323.0,352.0,356.0,369.0,375.0,416.0,419.0,425.0,426.0,501.0,502.0,503.0,504.0,505.0,507.0,510.0,511.0,513.0],\"textposition\":\"auto\",\"x\":[27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0],\"xaxis\":\"x\",\"y\":[0,1,4,5,1,3,5,0,2,3,5,0,4,1,5,4,0,2,3,5,1,5,4,1,4,0,4,2,2,3,4,5,2,3,2,1,3,4,3,5,0,1,5,1,0,4,5,1,3,1,4,2,4,5,1,5,2,3,1,1,0,1,1,2,0,3,4,5,1,0,5,1,0],\"yaxis\":\"y\",\"type\":\"bar\"},{\"alignmentgroup\":\"True\",\"base\":[\"2022-02-01T03:08:47\",\"2022-02-01T23:32:47\",\"2022-02-01T23:34:47\",\"2022-02-06T01:49:47\",\"2022-02-06T05:11:47\",\"2022-02-06T06:40:47\",\"2022-02-06T07:11:47\",\"2022-02-06T08:28:47\",\"2022-02-06T11:51:47\",\"2022-02-06T14:54:47\",\"2022-02-06T17:10:47\",\"2022-02-06T17:11:47\",\"2022-02-06T17:12:47\",\"2022-02-06T17:49:47\",\"2022-02-07T08:20:47\",\"2022-02-07T12:01:47\",\"2022-02-07T13:34:47\",\"2022-02-07T13:44:47\",\"2022-02-08T01:54:47\",\"2022-02-08T04:44:47\",\"2022-02-08T06:51:47\",\"2022-02-08T12:24:47\",\"2022-02-08T20:31:47\",\"2022-02-08T22:11:47\",\"2022-02-09T02:00:47\",\"2022-02-09T08:11:47\",\"2022-02-09T15:44:47\",\"2022-02-09T18:44:47\",\"2022-02-09T23:21:47\",\"2022-02-10T01:51:47\",\"2022-02-10T17:24:47\",\"2022-02-10T20:40:47\",\"2022-02-11T00:51:47\",\"2022-02-11T13:01:47\",\"2022-02-11T14:10:47\",\"2022-02-11T15:41:47\",\"2022-02-11T21:50:47\",\"2022-02-11T22:04:47\",\"2022-02-13T14:07:47\",\"2022-02-13T16:33:47\",\"2022-02-14T00:27:47\",\"2022-02-14T00:29:47\",\"2022-02-14T04:39:47\",\"2022-02-14T12:46:47\",\"2022-02-14T19:59:47\",\"2022-02-14T20:21:47\",\"2022-02-16T17:23:47\",\"2022-02-16T20:07:47\",\"2022-02-16T23:26:47\",\"2022-02-17T03:47:47\",\"2022-02-17T10:41:47\",\"2022-02-17T14:24:47\",\"2022-02-17T16:45:47\",\"2022-02-17T18:34:47\",\"2022-02-18T00:25:47\",\"2022-02-18T01:24:47\",\"2022-02-20T02:07:47\",\"2022-02-20T02:28:47\",\"2022-02-20T06:49:47\",\"2022-02-20T11:01:47\",\"2022-02-20T12:46:47\",\"2022-02-20T12:46:47\",\"2022-02-20T13:06:47\",\"2022-02-20T20:26:47\",\"2022-02-20T22:48:47\",\"2022-02-21T02:11:47\",\"2022-02-21T04:06:47\",\"2022-02-21T04:06:47\",\"2022-02-21T04:16:47\",\"2022-02-21T06:28:47\",\"2022-02-21T09:51:47\",\"2022-02-22T08:35:47\",\"2022-02-22T21:15:47\",\"2022-02-22T23:44:47\",\"2022-02-23T03:42:47\",\"2022-02-23T05:32:47\",\"2022-02-23T13:12:47\",\"2022-02-23T16:42:47\",\"2022-02-23T22:23:47\",\"2022-02-24T00:22:47\",\"2022-02-24T06:35:47\",\"2022-02-24T08:02:47\",\"2022-02-24T13:33:47\",\"2022-02-24T15:42:47\",\"2022-02-25T09:22:47\",\"2022-02-25T10:32:47\",\"2022-02-25T12:55:47\",\"2022-02-25T18:12:47\",\"2022-02-27T02:12:47\",\"2022-02-27T05:38:47\",\"2022-02-27T07:35:47\",\"2022-02-27T09:56:47\",\"2022-02-27T15:12:47\",\"2022-02-27T17:18:47\",\"2022-02-27T17:36:47\",\"2022-02-27T20:35:47\",\"2022-02-28T04:19:47\",\"2022-02-28T08:28:47\",\"2022-02-28T08:46:47\",\"2022-02-28T11:59:47\",\"2022-02-28T19:15:47\",\"2022-02-28T19:39:47\",\"2022-02-28T21:22:47\",\"2022-03-01T00:00:47\"],\"hovertemplate\":\"Product=Rotor A4<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>\",\"legendgroup\":\"Rotor A4\",\"marker\":{\"color\":\"#EF553B\"},\"name\":\"Rotor A4\",\"offsetgroup\":\"Rotor A4\",\"orientation\":\"h\",\"showlegend\":true,\"text\":[2.0,19.0,20.0,95.0,98.0,99.0,100.0,101.0,103.0,105.0,106.0,107.0,108.0,109.0,120.0,123.0,124.0,125.0,136.0,138.0,140.0,144.0,151.0,153.0,156.0,161.0,168.0,172.0,174.0,177.0,191.0,193.0,196.0,209.0,211.0,213.0,218.0,219.0,245.0,249.0,251.0,252.0,254.0,260.0,263.0,265.0,287.0,291.0,294.0,297.0,303.0,306.0,308.0,310.0,314.0,315.0,354.0,355.0,357.0,359.0,360.0,361.0,362.0,367.0,370.0,371.0,372.0,373.0,374.0,376.0,377.0,385.0,397.0,399.0,402.0,404.0,412.0,417.0,420.0,423.0,428.0,429.0,432.0,435.0,451.0,452.0,454.0,458.0,482.0,484.0,487.0,489.0,493.0,496.0,497.0,498.0,506.0,508.0,509.0,512.0,517.0,518.0,520.0,522.0],\"textposition\":\"auto\",\"x\":[27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0],\"xaxis\":\"x\",\"y\":[2,5,3,2,1,3,4,5,0,3,4,5,2,1,4,0,3,2,2,3,5,3,0,5,4,0,2,3,0,5,3,1,5,5,1,0,1,3,0,5,0,1,4,4,0,3,5,2,4,2,5,0,3,5,3,2,4,0,1,5,4,0,3,4,2,5,0,4,3,2,5,0,0,3,5,1,1,5,2,5,0,5,2,5,5,1,0,1,0,3,1,4,0,3,4,1,2,3,4,2,1,2,0,5],\"yaxis\":\"y\",\"type\":\"bar\"},{\"alignmentgroup\":\"True\",\"base\":[\"2022-02-01T03:17:47\",\"2022-02-01T08:32:47\",\"2022-02-01T12:31:47\",\"2022-02-01T15:47:47\",\"2022-02-01T15:48:47\",\"2022-02-01T17:46:47\",\"2022-02-01T21:04:47\",\"2022-02-01T23:28:47\",\"2022-02-01T23:50:47\",\"2022-02-02T01:16:47\",\"2022-02-02T04:34:47\",\"2022-02-02T06:58:47\",\"2022-02-02T07:12:47\",\"2022-02-02T09:39:47\",\"2022-02-02T12:59:47\",\"2022-02-02T14:28:47\",\"2022-02-02T17:36:47\",\"2022-02-02T17:38:47\",\"2022-02-02T20:21:47\",\"2022-02-02T20:29:47\",\"2022-02-02T23:57:47\",\"2022-02-03T02:14:47\",\"2022-02-03T03:37:47\",\"2022-02-03T03:39:47\",\"2022-02-03T04:41:47\",\"2022-02-03T07:27:47\",\"2022-02-03T09:44:47\",\"2022-02-03T11:09:47\",\"2022-02-03T12:11:47\",\"2022-02-03T12:20:47\",\"2022-02-03T18:39:47\",\"2022-02-03T19:41:47\",\"2022-02-03T19:50:47\",\"2022-02-03T22:27:47\",\"2022-02-04T02:09:47\",\"2022-02-04T18:42:47\",\"2022-02-06T23:31:47\",\"2022-02-07T00:50:47\",\"2022-02-07T00:52:47\",\"2022-02-07T06:04:47\",\"2022-02-07T15:51:47\",\"2022-02-07T21:14:47\",\"2022-02-07T23:21:47\",\"2022-02-07T23:30:47\",\"2022-02-08T02:50:47\",\"2022-02-08T05:31:47\",\"2022-02-08T09:34:47\",\"2022-02-08T10:20:47\",\"2022-02-09T03:44:47\",\"2022-02-09T05:51:47\",\"2022-02-09T09:40:47\",\"2022-02-09T14:30:47\",\"2022-02-09T15:51:47\",\"2022-02-09T22:00:47\",\"2022-02-09T23:24:47\",\"2022-02-10T02:24:47\",\"2022-02-10T05:30:47\",\"2022-02-10T07:01:47\",\"2022-02-10T09:54:47\",\"2022-02-10T16:54:47\",\"2022-02-14T07:38:47\",\"2022-02-14T12:59:47\",\"2022-02-14T20:00:47\",\"2022-02-14T20:26:47\",\"2022-02-16T17:24:47\",\"2022-02-16T20:38:47\",\"2022-02-16T23:08:47\",\"2022-02-17T01:29:47\",\"2022-02-18T19:40:47\",\"2022-02-18T23:23:47\",\"2022-02-19T08:45:47\",\"2022-02-19T10:29:47\",\"2022-02-20T07:48:47\",\"2022-02-20T15:18:47\",\"2022-02-20T18:41:47\",\"2022-02-20T20:46:47\",\"2022-02-21T18:06:47\",\"2022-02-21T18:27:47\",\"2022-02-21T21:18:47\",\"2022-02-22T12:42:47\",\"2022-02-22T15:23:47\",\"2022-02-22T17:51:47\",\"2022-02-22T20:12:47\",\"2022-02-22T22:53:47\",\"2022-02-23T14:53:47\",\"2022-02-23T18:03:47\",\"2022-02-23T23:04:47\",\"2022-02-23T23:05:47\",\"2022-02-24T06:34:47\",\"2022-02-24T11:52:47\",\"2022-02-24T14:04:47\",\"2022-02-24T14:15:47\",\"2022-02-24T16:53:47\",\"2022-02-24T19:22:47\",\"2022-02-24T21:45:47\",\"2022-02-25T10:43:47\",\"2022-02-25T17:02:47\",\"2022-02-25T18:13:47\",\"2022-02-26T05:19:47\",\"2022-02-26T05:20:47\",\"2022-02-26T11:06:47\",\"2022-02-26T16:25:47\",\"2022-02-26T22:08:47\",\"2022-02-26T22:30:47\",\"2022-02-28T16:26:47\",\"2022-02-28T21:08:47\",\"2022-02-28T23:56:47\",\"2022-03-01T02:55:47\"],\"hovertemplate\":\"Product=Rotor A2<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>\",\"legendgroup\":\"Rotor A2\",\"marker\":{\"color\":\"#00cc96\"},\"name\":\"Rotor A2\",\"offsetgroup\":\"Rotor A2\",\"orientation\":\"h\",\"showlegend\":true,\"text\":[3.0,7.0,11.0,13.0,14.0,16.0,17.0,18.0,21.0,22.0,23.0,24.0,25.0,27.0,29.0,30.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,42.0,43.0,44.0,46.0,47.0,48.0,52.0,53.0,54.0,55.0,58.0,72.0,112.0,113.0,115.0,117.0,127.0,131.0,133.0,134.0,137.0,139.0,142.0,143.0,157.0,160.0,164.0,167.0,169.0,173.0,175.0,178.0,179.0,181.0,184.0,189.0,256.0,261.0,264.0,266.0,288.0,292.0,293.0,296.0,330.0,332.0,339.0,340.0,358.0,364.0,365.0,368.0,379.0,380.0,383.0,389.0,391.0,394.0,396.0,398.0,414.0,418.0,421.0,422.0,427.0,431.0,433.0,434.0,436.0,437.0,440.0,453.0,457.0,459.0,461.0,462.0,468.0,473.0,478.0,480.0,516.0,519.0,521.0,523.0],\"textposition\":\"auto\",\"x\":[27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0],\"xaxis\":\"x\",\"y\":[3,1,0,3,2,4,0,1,2,4,0,1,5,2,0,1,4,2,3,0,5,1,4,2,0,5,1,2,0,3,2,0,3,5,2,4,0,4,2,3,5,3,5,4,1,0,2,1,3,5,4,1,0,1,2,3,1,0,3,2,2,5,1,4,1,3,0,5,1,5,2,5,2,2,5,3,4,3,5,5,4,2,5,4,2,4,3,0,3,1,3,0,4,1,0,4,5,4,3,0,4,1,3,5,4,3,4,1],\"yaxis\":\"y\",\"type\":\"bar\"},{\"alignmentgroup\":\"True\",\"base\":[\"2022-02-01T08:31:47\",\"2022-02-06T01:11:47\",\"2022-02-06T04:28:47\",\"2022-02-06T13:49:47\",\"2022-02-06T19:31:47\",\"2022-02-08T22:00:47\",\"2022-02-09T01:30:47\",\"2022-02-09T04:11:47\",\"2022-02-09T05:30:47\",\"2022-02-11T01:04:47\",\"2022-02-11T03:11:47\",\"2022-02-11T11:41:47\",\"2022-02-11T13:24:47\",\"2022-02-11T17:24:47\",\"2022-02-11T18:04:47\",\"2022-02-11T20:41:47\",\"2022-02-11T21:24:47\",\"2022-02-13T08:35:47\",\"2022-02-13T08:36:47\",\"2022-02-13T10:52:47\",\"2022-02-13T20:41:47\",\"2022-02-16T01:05:47\",\"2022-02-16T08:52:47\",\"2022-02-16T18:08:47\",\"2022-02-16T18:09:47\",\"2022-02-17T00:54:47\",\"2022-02-17T04:58:47\",\"2022-02-17T05:11:47\",\"2022-02-17T13:38:47\",\"2022-02-18T05:38:47\",\"2022-02-18T19:23:47\",\"2022-02-18T23:52:47\",\"2022-02-19T14:47:47\",\"2022-02-19T20:15:47\",\"2022-02-19T20:15:47\",\"2022-02-21T20:10:47\",\"2022-02-22T12:41:47\",\"2022-02-23T01:32:47\",\"2022-02-23T01:33:47\",\"2022-02-23T07:24:47\",\"2022-02-23T10:53:47\",\"2022-02-23T11:24:47\",\"2022-02-23T14:03:47\",\"2022-02-25T15:33:47\",\"2022-02-25T15:34:47\",\"2022-02-26T07:06:47\",\"2022-02-26T07:09:47\",\"2022-02-26T14:08:47\",\"2022-02-27T11:19:47\",\"2022-02-27T13:18:47\",\"2022-02-27T21:20:47\",\"2022-03-01T08:19:47\"],\"hovertemplate\":\"Product=Rotor C1<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>\",\"legendgroup\":\"Rotor C1\",\"marker\":{\"color\":\"#ab63fa\"},\"name\":\"Rotor C1\",\"offsetgroup\":\"Rotor C1\",\"orientation\":\"h\",\"showlegend\":true,\"text\":[6.0,94.0,97.0,104.0,110.0,152.0,155.0,158.0,159.0,197.0,198.0,208.0,210.0,214.0,215.0,216.0,217.0,241.0,242.0,243.0,250.0,282.0,284.0,289.0,290.0,295.0,298.0,299.0,305.0,319.0,329.0,334.0,342.0,346.0,347.0,382.0,388.0,400.0,401.0,407.0,409.0,411.0,413.0,455.0,456.0,464.0,465.0,470.0,490.0,491.0,500.0,529.0],\"textposition\":\"auto\",\"x\":[14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0],\"xaxis\":\"x\",\"y\":[0,1,5,1,0,4,1,0,1,3,0,0,2,2,3,5,2,0,1,5,2,1,4,0,4,1,3,1,2,4,5,0,3,5,3,2,1,1,2,3,2,3,4,2,3,4,1,3,2,3,5,2],\"yaxis\":\"y\",\"type\":\"bar\"},{\"alignmentgroup\":\"True\",\"base\":[\"2022-02-01T10:47:47\",\"2022-02-01T10:48:47\",\"2022-02-01T11:50:47\",\"2022-02-01T16:25:47\",\"2022-02-05T08:01:47\",\"2022-02-05T09:48:47\",\"2022-02-07T02:20:47\",\"2022-02-07T07:01:47\",\"2022-02-09T09:30:47\",\"2022-02-09T13:21:47\",\"2022-02-10T06:54:47\",\"2022-02-10T08:20:47\",\"2022-02-10T11:54:47\",\"2022-02-10T14:31:47\",\"2022-02-12T00:41:47\",\"2022-02-12T12:03:47\",\"2022-02-12T13:56:47\",\"2022-02-12T17:41:47\",\"2022-02-14T20:29:47\",\"2022-02-14T23:11:47\",\"2022-02-17T06:38:47\",\"2022-02-17T07:12:47\",\"2022-02-18T08:05:47\",\"2022-02-18T09:38:47\",\"2022-02-19T20:29:47\",\"2022-02-20T00:15:47\",\"2022-02-22T10:23:47\",\"2022-02-22T12:51:47\",\"2022-02-22T16:15:47\",\"2022-02-22T18:44:47\",\"2022-02-24T23:22:47\",\"2022-02-25T02:54:47\",\"2022-02-25T04:22:47\",\"2022-02-25T05:43:47\",\"2022-02-26T05:32:47\",\"2022-02-26T08:51:47\",\"2022-02-28T16:08:47\",\"2022-03-01T03:19:47\",\"2022-03-01T04:38:47\",\"2022-03-01T07:26:47\"],\"hovertemplate\":\"Product=Rotor B3<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>\",\"legendgroup\":\"Rotor B3\",\"marker\":{\"color\":\"#FFA15A\"},\"name\":\"Rotor B3\",\"offsetgroup\":\"Rotor B3\",\"orientation\":\"h\",\"showlegend\":true,\"text\":[8.0,9.0,10.0,15.0,80.0,81.0,116.0,118.0,163.0,166.0,180.0,182.0,185.0,188.0,222.0,225.0,227.0,230.0,267.0,268.0,300.0,301.0,320.0,322.0,348.0,350.0,386.0,390.0,392.0,395.0,441.0,445.0,446.0,448.0,463.0,466.0,514.0,524.0,525.0,527.0],\"textposition\":\"auto\",\"x\":[18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0,18000000.0],\"xaxis\":\"x\",\"y\":[3,2,4,1,4,3,1,0,1,5,2,4,2,0,5,5,4,1,5,2,0,4,3,4,1,3,4,2,0,3,5,3,5,4,5,2,3,2,3,4],\"yaxis\":\"y\",\"type\":\"bar\"},{\"alignmentgroup\":\"True\",\"base\":[\"2022-02-01T14:09:47\",\"2022-02-03T04:40:47\",\"2022-02-04T19:34:47\",\"2022-02-04T21:09:47\",\"2022-02-10T00:40:47\",\"2022-02-12T22:41:47\",\"2022-02-13T02:17:47\",\"2022-02-14T12:41:47\",\"2022-02-14T15:08:47\",\"2022-02-15T05:31:47\",\"2022-02-15T05:31:47\",\"2022-02-15T11:09:47\",\"2022-02-15T12:38:47\",\"2022-02-19T13:04:47\",\"2022-02-19T18:48:47\",\"2022-02-20T00:15:47\",\"2022-02-21T17:32:47\",\"2022-02-21T18:32:47\",\"2022-02-22T11:04:47\",\"2022-02-22T16:41:47\",\"2022-02-25T02:52:47\",\"2022-02-25T05:15:47\",\"2022-02-25T07:53:47\",\"2022-02-25T07:54:47\",\"2022-02-25T19:33:47\",\"2022-02-27T13:40:47\",\"2022-02-27T20:39:47\",\"2022-03-01T09:38:47\"],\"hovertemplate\":\"Product=Rotor A5<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>\",\"legendgroup\":\"Rotor A5\",\"marker\":{\"color\":\"#19d3f3\"},\"name\":\"Rotor A5\",\"offsetgroup\":\"Rotor A5\",\"orientation\":\"h\",\"showlegend\":true,\"text\":[12.0,41.0,73.0,76.0,176.0,236.0,238.0,259.0,262.0,273.0,274.0,277.0,278.0,341.0,344.0,351.0,378.0,381.0,387.0,393.0,444.0,447.0,449.0,450.0,460.0,492.0,499.0,530.0],\"textposition\":\"auto\",\"x\":[27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0],\"xaxis\":\"x\",\"y\":[5,3,3,2,4,1,2,3,2,3,2,0,4,4,0,5,0,1,3,1,1,0,2,3,2,5,2,3],\"yaxis\":\"y\",\"type\":\"bar\"},{\"alignmentgroup\":\"True\",\"base\":[\"2022-02-02T09:19:47\",\"2022-02-02T11:17:47\",\"2022-02-02T15:01:47\",\"2022-02-02T16:27:47\",\"2022-02-05T06:10:47\",\"2022-02-05T12:21:47\",\"2022-02-05T16:51:47\",\"2022-02-08T00:11:47\",\"2022-02-11T04:20:47\",\"2022-02-11T05:04:47\",\"2022-02-11T08:04:47\",\"2022-02-11T09:10:47\",\"2022-02-12T15:37:47\",\"2022-02-12T20:57:47\",\"2022-02-19T14:49:47\",\"2022-02-19T18:58:47\",\"2022-02-19T20:44:47\",\"2022-02-20T01:29:47\",\"2022-02-23T04:55:47\",\"2022-02-23T05:33:47\",\"2022-02-23T10:15:47\",\"2022-02-23T11:22:47\",\"2022-02-24T21:13:47\",\"2022-02-24T21:34:47\",\"2022-02-25T00:23:47\",\"2022-02-25T02:33:47\",\"2022-02-27T05:59:47\",\"2022-02-27T09:52:47\",\"2022-02-27T15:15:47\",\"2022-02-27T15:19:47\",\"2022-03-01T05:02:47\",\"2022-03-01T07:40:47\"],\"hovertemplate\":\"Product=Rotor A1<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>\",\"legendgroup\":\"Rotor A1\",\"marker\":{\"color\":\"#FF6692\"},\"name\":\"Rotor A1\",\"offsetgroup\":\"Rotor A1\",\"orientation\":\"h\",\"showlegend\":true,\"text\":[26.0,28.0,31.0,32.0,78.0,85.0,87.0,135.0,199.0,201.0,203.0,205.0,229.0,234.0,343.0,345.0,349.0,353.0,403.0,405.0,408.0,410.0,438.0,439.0,442.0,443.0,485.0,488.0,494.0,495.0,526.0,528.0],\"textposition\":\"auto\",\"x\":[19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0,19200000.0],\"xaxis\":\"x\",\"y\":[3,4,3,5,1,1,3,0,1,3,2,4,2,2,1,2,4,1,0,2,0,5,2,3,4,2,2,0,1,2,0,5],\"yaxis\":\"y\",\"type\":\"bar\"},{\"alignmentgroup\":\"True\",\"base\":[\"2022-02-03T11:07:47\",\"2022-02-03T14:57:47\",\"2022-02-03T17:14:47\",\"2022-02-03T18:37:47\",\"2022-02-04T12:14:47\",\"2022-02-04T14:41:47\",\"2022-02-12T18:56:47\",\"2022-02-12T19:53:47\",\"2022-02-16T08:56:47\",\"2022-02-16T08:57:47\",\"2022-02-17T20:43:47\",\"2022-02-17T22:04:47\",\"2022-02-18T16:21:47\",\"2022-02-18T16:22:47\"],\"hovertemplate\":\"Product=Rotor B6<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>\",\"legendgroup\":\"Rotor B6\",\"marker\":{\"color\":\"#B6E880\"},\"name\":\"Rotor B6\",\"offsetgroup\":\"Rotor B6\",\"orientation\":\"h\",\"showlegend\":true,\"text\":[45.0,49.0,50.0,51.0,68.0,70.0,232.0,233.0,285.0,286.0,311.0,312.0,325.0,326.0],\"textposition\":\"auto\",\"x\":[27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0,27000000.0],\"xaxis\":\"x\",\"y\":[4,5,1,4,1,0,4,3,2,3,1,0,3,0],\"yaxis\":\"y\",\"type\":\"bar\"},{\"alignmentgroup\":\"True\",\"base\":[\"2022-02-04T02:07:47\",\"2022-02-04T03:11:47\",\"2022-02-04T06:07:47\",\"2022-02-04T08:14:47\",\"2022-02-04T17:09:47\",\"2022-02-04T19:44:47\",\"2022-02-04T20:57:47\",\"2022-02-05T06:38:47\",\"2022-02-15T18:10:47\",\"2022-02-15T20:09:47\",\"2022-02-15T21:44:47\",\"2022-02-16T03:30:47\",\"2022-02-18T18:22:47\",\"2022-02-18T23:51:47\",\"2022-02-19T06:06:47\",\"2022-02-19T08:02:47\",\"2022-02-26T12:25:47\",\"2022-02-26T14:32:47\",\"2022-02-26T18:08:47\",\"2022-02-26T18:30:47\"],\"hovertemplate\":\"Product=Rotor C0<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>\",\"legendgroup\":\"Rotor C0\",\"marker\":{\"color\":\"#FF97FF\"},\"name\":\"Rotor C0\",\"offsetgroup\":\"Rotor C0\",\"orientation\":\"h\",\"showlegend\":true,\"text\":[57.0,59.0,62.0,64.0,71.0,74.0,75.0,79.0,279.0,280.0,281.0,283.0,328.0,333.0,335.0,337.0,469.0,471.0,474.0,475.0],\"textposition\":\"auto\",\"x\":[14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0,14400000.0],\"xaxis\":\"x\",\"y\":[4,0,4,1,2,1,5,5,2,3,5,0,2,3,4,3,1,0,3,5],\"yaxis\":\"y\",\"type\":\"bar\"},{\"alignmentgroup\":\"True\",\"base\":[\"2022-02-04T11:02:47\",\"2022-02-05T09:54:47\",\"2022-02-05T10:16:47\",\"2022-02-05T10:38:47\",\"2022-02-05T17:34:47\",\"2022-02-05T20:22:47\",\"2022-02-05T23:00:47\",\"2022-02-08T14:31:47\",\"2022-02-08T17:50:47\",\"2022-02-08T20:04:47\",\"2022-02-09T00:34:47\",\"2022-02-10T09:31:47\",\"2022-02-10T13:00:47\",\"2022-02-10T13:20:47\",\"2022-02-10T17:11:47\",\"2022-02-10T19:31:47\",\"2022-02-10T21:00:47\",\"2022-02-11T00:24:47\",\"2022-02-11T10:24:47\",\"2022-02-11T14:30:47\",\"2022-02-11T22:10:47\",\"2022-02-11T23:21:47\",\"2022-02-12T06:20:47\",\"2022-02-12T12:13:47\",\"2022-02-12T15:01:47\",\"2022-02-12T17:53:47\",\"2022-02-12T22:41:47\",\"2022-02-13T01:33:47\",\"2022-02-13T06:35:47\",\"2022-02-18T05:34:47\",\"2022-02-18T09:04:47\",\"2022-02-18T11:43:47\",\"2022-02-18T17:26:47\",\"2022-02-18T22:22:47\",\"2022-02-19T06:56:47\",\"2022-02-19T08:32:47\",\"2022-02-20T14:58:47\",\"2022-02-20T20:26:47\",\"2022-02-22T00:10:47\",\"2022-02-23T06:23:47\",\"2022-02-23T15:24:47\",\"2022-02-24T01:33:47\",\"2022-02-24T09:13:47\",\"2022-02-26T10:50:47\",\"2022-02-26T14:39:47\",\"2022-02-26T18:32:47\",\"2022-02-26T18:36:47\",\"2022-02-26T22:19:47\",\"2022-02-26T23:55:47\",\"2022-02-27T02:16:47\",\"2022-02-27T06:00:47\",\"2022-02-28T16:20:47\"],\"hovertemplate\":\"Product=Rotor A6<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>\",\"legendgroup\":\"Rotor A6\",\"marker\":{\"color\":\"#FECB52\"},\"name\":\"Rotor A6\",\"offsetgroup\":\"Rotor A6\",\"orientation\":\"h\",\"showlegend\":true,\"text\":[66.0,82.0,83.0,84.0,88.0,90.0,92.0,147.0,149.0,150.0,154.0,183.0,186.0,187.0,190.0,192.0,194.0,195.0,207.0,212.0,220.0,221.0,224.0,226.0,228.0,231.0,235.0,237.0,239.0,318.0,321.0,324.0,327.0,331.0,336.0,338.0,363.0,366.0,384.0,406.0,415.0,424.0,430.0,467.0,472.0,476.0,477.0,479.0,481.0,483.0,486.0,515.0],\"textposition\":\"auto\",\"x\":[27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0,27600000.0],\"xaxis\":\"x\",\"y\":[4,2,0,5,2,0,3,5,1,3,2,5,1,4,5,0,4,2,3,4,4,0,1,3,0,5,0,5,4,0,2,1,4,2,1,0,1,0,2,4,3,4,4,5,2,0,4,2,1,4,5,5],\"yaxis\":\"y\",\"type\":\"bar\"},{\"alignmentgroup\":\"True\",\"base\":[\"2022-02-07T09:14:47\",\"2022-02-07T14:50:47\",\"2022-02-07T19:41:47\",\"2022-02-07T21:24:47\",\"2022-02-11T04:40:47\",\"2022-02-11T07:11:47\",\"2022-02-11T08:31:47\",\"2022-02-11T09:40:47\"],\"hovertemplate\":\"Product=Rotor C3<br>start_job_date=%{base}<br>finish_job_date=%{x}<br>oven_number=%{y}<br>index=%{text}<extra></extra>\",\"legendgroup\":\"Rotor C3\",\"marker\":{\"color\":\"#636efa\"},\"name\":\"Rotor C3\",\"offsetgroup\":\"Rotor C3\",\"orientation\":\"h\",\"showlegend\":true,\"text\":[122.0,126.0,130.0,132.0,200.0,202.0,204.0,206.0],\"textposition\":\"auto\",\"x\":[16200000.0,16200000.0,16200000.0,16200000.0,16200000.0,16200000.0,16200000.0,16200000.0],\"xaxis\":\"x\",\"y\":[2,1,0,2,4,0,5,1],\"yaxis\":\"y\",\"type\":\"bar\"}],                        {\"template\":{\"data\":{\"histogram2dcontour\":[{\"type\":\"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\"]]}],\"choropleth\":[{\"type\":\"choropleth\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"histogram2d\":[{\"type\":\"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\"]]}],\"heatmap\":[{\"type\":\"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\"]]}],\"heatmapgl\":[{\"type\":\"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\"]]}],\"contourcarpet\":[{\"type\":\"contourcarpet\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"contour\":[{\"type\":\"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\"]]}],\"surface\":[{\"type\":\"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\"]]}],\"mesh3d\":[{\"type\":\"mesh3d\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"scatter\":[{\"fillpattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2},\"type\":\"scatter\"}],\"parcoords\":[{\"type\":\"parcoords\",\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterpolargl\":[{\"type\":\"scatterpolargl\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"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\"}],\"scattergeo\":[{\"type\":\"scattergeo\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterpolar\":[{\"type\":\"scatterpolar\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"histogram\":[{\"marker\":{\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"histogram\"}],\"scattergl\":[{\"type\":\"scattergl\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatter3d\":[{\"type\":\"scatter3d\",\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scattermapbox\":[{\"type\":\"scattermapbox\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterternary\":[{\"type\":\"scatterternary\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scattercarpet\":[{\"type\":\"scattercarpet\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"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\"}],\"table\":[{\"cells\":{\"fill\":{\"color\":\"#EBF0F8\"},\"line\":{\"color\":\"white\"}},\"header\":{\"fill\":{\"color\":\"#C8D4E3\"},\"line\":{\"color\":\"white\"}},\"type\":\"table\"}],\"barpolar\":[{\"marker\":{\"line\":{\"color\":\"#E5ECF6\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"barpolar\"}],\"pie\":[{\"automargin\":true,\"type\":\"pie\"}]},\"layout\":{\"autotypenumbers\":\"strict\",\"colorway\":[\"#636efa\",\"#EF553B\",\"#00cc96\",\"#ab63fa\",\"#FFA15A\",\"#19d3f3\",\"#FF6692\",\"#B6E880\",\"#FF97FF\",\"#FECB52\"],\"font\":{\"color\":\"#2a3f5f\"},\"hovermode\":\"closest\",\"hoverlabel\":{\"align\":\"left\"},\"paper_bgcolor\":\"white\",\"plot_bgcolor\":\"#E5ECF6\",\"polar\":{\"bgcolor\":\"#E5ECF6\",\"angularaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"radialaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"}},\"ternary\":{\"bgcolor\":\"#E5ECF6\",\"aaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"baxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"caxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"}},\"coloraxis\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"colorscale\":{\"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\"]],\"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\"]]},\"xaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"white\",\"automargin\":true,\"zerolinewidth\":2},\"yaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"white\",\"automargin\":true,\"zerolinewidth\":2},\"scene\":{\"xaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2},\"yaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2},\"zaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2}},\"shapedefaults\":{\"line\":{\"color\":\"#2a3f5f\"}},\"annotationdefaults\":{\"arrowcolor\":\"#2a3f5f\",\"arrowhead\":0,\"arrowwidth\":1},\"geo\":{\"bgcolor\":\"white\",\"landcolor\":\"#E5ECF6\",\"subunitcolor\":\"white\",\"showland\":true,\"showlakes\":true,\"lakecolor\":\"white\"},\"title\":{\"x\":0.05},\"mapbox\":{\"style\":\"light\"}}},\"xaxis\":{\"anchor\":\"y\",\"domain\":[0.0,1.0],\"type\":\"date\"},\"yaxis\":{\"anchor\":\"x\",\"domain\":[0.0,1.0],\"title\":{\"text\":\"oven_number\"},\"autorange\":\"reversed\"},\"legend\":{\"title\":{\"text\":\"Product\"},\"tracegroupgap\":0},\"margin\":{\"t\":60},\"barmode\":\"overlay\"},                        {\"responsive\": true}                    ).then(function(){\n",
       "                            \n",
       "var gd = document.getElementById('096171a8-4349-48e2-a42e-f7e37290848a');\n",
       "var x = new MutationObserver(function (mutations, observer) {{\n",
       "        var display = window.getComputedStyle(gd).display;\n",
       "        if (!display || display === 'none') {{\n",
       "            console.log([gd, 'removed!']);\n",
       "            Plotly.purge(gd);\n",
       "            observer.disconnect();\n",
       "        }}\n",
       "}});\n",
       "\n",
       "// Listen for the removal of the full notebook cells\n",
       "var notebookContainer = gd.closest('#notebook-container');\n",
       "if (notebookContainer) {{\n",
       "    x.observe(notebookContainer, {childList: true});\n",
       "}}\n",
       "\n",
       "// Listen for the clearing of the current output cell\n",
       "var outputEl = gd.closest('.output');\n",
       "if (outputEl) {{\n",
       "    x.observe(outputEl, {childList: true});\n",
       "}}\n",
       "\n",
       "                        })                };                });            </script>        </div>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "fig = px.timeline(kuka_output, x_start=\"start_job_date\", x_end=\"finish_job_date\", y=\"oven_number\", color=\"Product\", text=\"index\")\n",
    "fig.update_yaxes(autorange=\"reversed\") # otherwise tasks are listed from the bottom up\n",
    "fig.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "0d02d2c3",
   "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>KukaRobotId</th>\n",
       "      <th>Product</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>EndDate min</th>\n",
       "      <th>oven_number</th>\n",
       "      <th>start_job</th>\n",
       "      <th>finish_job</th>\n",
       "      <th>start_job_date</th>\n",
       "      <th>finish_job_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-01-31 20:13:35</td>\n",
       "      <td>2022-02-01 01:01:47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>450.0</td>\n",
       "      <td>2022-02-01 01:01:47</td>\n",
       "      <td>2022-02-01 08:31:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>68051</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 01:02:12</td>\n",
       "      <td>2022-02-01 01:02:55</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>451.0</td>\n",
       "      <td>2022-02-01 01:02:47</td>\n",
       "      <td>2022-02-01 08:32:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor A4</td>\n",
       "      <td>2022-01-31 23:27:53</td>\n",
       "      <td>2022-02-01 03:09:23</td>\n",
       "      <td>127.0</td>\n",
       "      <td>2</td>\n",
       "      <td>127.0</td>\n",
       "      <td>587.0</td>\n",
       "      <td>2022-02-01 03:08:47</td>\n",
       "      <td>2022-02-01 10:48:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-01-31 23:26:11</td>\n",
       "      <td>2022-02-01 03:18:29</td>\n",
       "      <td>136.0</td>\n",
       "      <td>3</td>\n",
       "      <td>136.0</td>\n",
       "      <td>586.0</td>\n",
       "      <td>2022-02-01 03:17:47</td>\n",
       "      <td>2022-02-01 10:47:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 01:03:26</td>\n",
       "      <td>2022-02-01 04:20:59</td>\n",
       "      <td>199.0</td>\n",
       "      <td>4</td>\n",
       "      <td>199.0</td>\n",
       "      <td>649.0</td>\n",
       "      <td>2022-02-01 04:20:47</td>\n",
       "      <td>2022-02-01 11:50:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor A3</td>\n",
       "      <td>2022-02-01 04:21:22</td>\n",
       "      <td>2022-02-01 06:40:31</td>\n",
       "      <td>338.0</td>\n",
       "      <td>5</td>\n",
       "      <td>338.0</td>\n",
       "      <td>788.0</td>\n",
       "      <td>2022-02-01 06:39:47</td>\n",
       "      <td>2022-02-01 14:09:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor C1</td>\n",
       "      <td>2022-02-01 06:45:10</td>\n",
       "      <td>2022-02-01 06:45:43</td>\n",
       "      <td>343.0</td>\n",
       "      <td>0</td>\n",
       "      <td>450.0</td>\n",
       "      <td>690.0</td>\n",
       "      <td>2022-02-01 08:31:47</td>\n",
       "      <td>2022-02-01 12:31:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A2</td>\n",
       "      <td>2022-02-01 03:18:34</td>\n",
       "      <td>2022-02-01 07:07:44</td>\n",
       "      <td>365.0</td>\n",
       "      <td>1</td>\n",
       "      <td>451.0</td>\n",
       "      <td>901.0</td>\n",
       "      <td>2022-02-01 08:32:47</td>\n",
       "      <td>2022-02-01 16:02:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor B3</td>\n",
       "      <td>2022-02-01 03:09:33</td>\n",
       "      <td>2022-02-01 09:46:59</td>\n",
       "      <td>525.0</td>\n",
       "      <td>3</td>\n",
       "      <td>586.0</td>\n",
       "      <td>886.0</td>\n",
       "      <td>2022-02-01 10:47:47</td>\n",
       "      <td>2022-02-01 15:47:47</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   KukaRobotId   Product           StartDate             EndDate  EndDate min  \\\n",
       "0        68051  Rotor A3 2022-01-31 20:13:35 2022-02-01 01:01:47          0.0   \n",
       "1        68051  Rotor A3 2022-02-01 01:02:12 2022-02-01 01:02:55          1.0   \n",
       "2        82402  Rotor A4 2022-01-31 23:27:53 2022-02-01 03:09:23        127.0   \n",
       "3        82403  Rotor A2 2022-01-31 23:26:11 2022-02-01 03:18:29        136.0   \n",
       "4        68050  Rotor A3 2022-02-01 01:03:26 2022-02-01 04:20:59        199.0   \n",
       "5        68050  Rotor A3 2022-02-01 04:21:22 2022-02-01 06:40:31        338.0   \n",
       "6        68050  Rotor C1 2022-02-01 06:45:10 2022-02-01 06:45:43        343.0   \n",
       "7        82403  Rotor A2 2022-02-01 03:18:34 2022-02-01 07:07:44        365.0   \n",
       "8        82402  Rotor B3 2022-02-01 03:09:33 2022-02-01 09:46:59        525.0   \n",
       "\n",
       "   oven_number  start_job  finish_job      start_job_date     finish_job_date  \n",
       "0            0        0.0       450.0 2022-02-01 01:01:47 2022-02-01 08:31:47  \n",
       "1            1        1.0       451.0 2022-02-01 01:02:47 2022-02-01 08:32:47  \n",
       "2            2      127.0       587.0 2022-02-01 03:08:47 2022-02-01 10:48:47  \n",
       "3            3      136.0       586.0 2022-02-01 03:17:47 2022-02-01 10:47:47  \n",
       "4            4      199.0       649.0 2022-02-01 04:20:47 2022-02-01 11:50:47  \n",
       "5            5      338.0       788.0 2022-02-01 06:39:47 2022-02-01 14:09:47  \n",
       "6            0      450.0       690.0 2022-02-01 08:31:47 2022-02-01 12:31:47  \n",
       "7            1      451.0       901.0 2022-02-01 08:32:47 2022-02-01 16:02:47  \n",
       "8            3      586.0       886.0 2022-02-01 10:47:47 2022-02-01 15:47:47  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kuka_output.iloc[:9]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "6b1de56d",
   "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>index</th>\n",
       "      <th>KukaRobotId</th>\n",
       "      <th>Product</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>EndDate min</th>\n",
       "      <th>oven_number</th>\n",
       "      <th>start_job</th>\n",
       "      <th>finish_job</th>\n",
       "      <th>start_job_date</th>\n",
       "      <th>finish_job_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>526</td>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A1</td>\n",
       "      <td>2022-02-28 20:14:35</td>\n",
       "      <td>2022-02-28 23:24:19</td>\n",
       "      <td>40222.0</td>\n",
       "      <td>0</td>\n",
       "      <td>40561.0</td>\n",
       "      <td>40881.0</td>\n",
       "      <td>2022-03-01 05:02:47</td>\n",
       "      <td>2022-03-01 10:22:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>527</td>\n",
       "      <td>82402</td>\n",
       "      <td>Rotor B3</td>\n",
       "      <td>2022-02-28 23:24:00</td>\n",
       "      <td>2022-03-01 01:14:49</td>\n",
       "      <td>40333.0</td>\n",
       "      <td>4</td>\n",
       "      <td>40705.0</td>\n",
       "      <td>41005.0</td>\n",
       "      <td>2022-03-01 07:26:47</td>\n",
       "      <td>2022-03-01 12:26:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>528</td>\n",
       "      <td>82403</td>\n",
       "      <td>Rotor A1</td>\n",
       "      <td>2022-02-28 23:29:09</td>\n",
       "      <td>2022-03-01 02:45:57</td>\n",
       "      <td>40424.0</td>\n",
       "      <td>5</td>\n",
       "      <td>40719.0</td>\n",
       "      <td>41039.0</td>\n",
       "      <td>2022-03-01 07:40:47</td>\n",
       "      <td>2022-03-01 13:00:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>529</td>\n",
       "      <td>68050</td>\n",
       "      <td>Rotor C1</td>\n",
       "      <td>2022-02-28 23:46:24</td>\n",
       "      <td>2022-03-01 04:13:09</td>\n",
       "      <td>40511.0</td>\n",
       "      <td>2</td>\n",
       "      <td>40758.0</td>\n",
       "      <td>40998.0</td>\n",
       "      <td>2022-03-01 08:19:47</td>\n",
       "      <td>2022-03-01 12:19:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530</th>\n",
       "      <td>530</td>\n",
       "      <td>82401</td>\n",
       "      <td>Rotor A5</td>\n",
       "      <td>2022-02-28 12:27:06</td>\n",
       "      <td>2022-03-01 06:17:10</td>\n",
       "      <td>40635.0</td>\n",
       "      <td>3</td>\n",
       "      <td>40837.0</td>\n",
       "      <td>41297.0</td>\n",
       "      <td>2022-03-01 09:38:47</td>\n",
       "      <td>2022-03-01 17:18:47</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     index  KukaRobotId   Product           StartDate             EndDate  \\\n",
       "526    526        82403  Rotor A1 2022-02-28 20:14:35 2022-02-28 23:24:19   \n",
       "527    527        82402  Rotor B3 2022-02-28 23:24:00 2022-03-01 01:14:49   \n",
       "528    528        82403  Rotor A1 2022-02-28 23:29:09 2022-03-01 02:45:57   \n",
       "529    529        68050  Rotor C1 2022-02-28 23:46:24 2022-03-01 04:13:09   \n",
       "530    530        82401  Rotor A5 2022-02-28 12:27:06 2022-03-01 06:17:10   \n",
       "\n",
       "     EndDate min  oven_number  start_job  finish_job      start_job_date  \\\n",
       "526      40222.0            0    40561.0     40881.0 2022-03-01 05:02:47   \n",
       "527      40333.0            4    40705.0     41005.0 2022-03-01 07:26:47   \n",
       "528      40424.0            5    40719.0     41039.0 2022-03-01 07:40:47   \n",
       "529      40511.0            2    40758.0     40998.0 2022-03-01 08:19:47   \n",
       "530      40635.0            3    40837.0     41297.0 2022-03-01 09:38:47   \n",
       "\n",
       "        finish_job_date  \n",
       "526 2022-03-01 10:22:47  \n",
       "527 2022-03-01 12:26:47  \n",
       "528 2022-03-01 13:00:47  \n",
       "529 2022-03-01 12:19:47  \n",
       "530 2022-03-01 17:18:47  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kuka_output.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ac46ffb0",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.8.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}