{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "963c0e0a",
   "metadata": {},
   "source": [
    "# Playback Walkthrough\n",
    "\n",
    "Explore deterministic playback outputs for the tiny7 scenario using the shared analytics utilities."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "3b7fa46d",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2026-10-05T12:56:48.745899Z",
     "iopub.status.busy": "2026-10-05T12:56:48.745770Z",
     "iopub.status.idle": "2026-10-05T12:56:51.926517Z",
     "shell.execute_reply": "2026-10-05T12:56:51.924061Z"
    }
   },
   "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>day</th>\n",
       "      <th>shift_id</th>\n",
       "      <th>machine_id</th>\n",
       "      <th>machine_role</th>\n",
       "      <th>sample_id</th>\n",
       "      <th>production_units</th>\n",
       "      <th>total_hours</th>\n",
       "      <th>idle_hours</th>\n",
       "      <th>mobilisation_cost</th>\n",
       "      <th>sequencing_violations</th>\n",
       "      <th>blackout_conflicts</th>\n",
       "      <th>available_hours</th>\n",
       "      <th>utilisation_ratio</th>\n",
       "      <th>downtime_hours</th>\n",
       "      <th>downtime_events</th>\n",
       "      <th>weather_severity_total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>S1</td>\n",
       "      <td>H1</td>\n",
       "      <td>feller_buncher</td>\n",
       "      <td>0</td>\n",
       "      <td>1194.708925</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>S1</td>\n",
       "      <td>H2</td>\n",
       "      <td>feller_buncher</td>\n",
       "      <td>0</td>\n",
       "      <td>813.203830</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>S1</td>\n",
       "      <td>H3</td>\n",
       "      <td>grapple_skidder</td>\n",
       "      <td>0</td>\n",
       "      <td>1438.086529</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>S1</td>\n",
       "      <td>H2</td>\n",
       "      <td>feller_buncher</td>\n",
       "      <td>0</td>\n",
       "      <td>1185.883055</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53.24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>S1</td>\n",
       "      <td>H3</td>\n",
       "      <td>grapple_skidder</td>\n",
       "      <td>0</td>\n",
       "      <td>569.826226</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   day shift_id machine_id     machine_role  sample_id  production_units  \\\n",
       "0    1       S1         H1   feller_buncher          0       1194.708925   \n",
       "1    1       S1         H2   feller_buncher          0        813.203830   \n",
       "2    2       S1         H3  grapple_skidder          0       1438.086529   \n",
       "3    3       S1         H2   feller_buncher          0       1185.883055   \n",
       "4    3       S1         H3  grapple_skidder          0        569.826226   \n",
       "\n",
       "   total_hours  idle_hours  mobilisation_cost  sequencing_violations  \\\n",
       "0         24.0         0.0               0.00                      0   \n",
       "1         24.0         0.0               0.00                      0   \n",
       "2         24.0         0.0               0.00                      0   \n",
       "3         24.0         0.0              53.24                      0   \n",
       "4         24.0         0.0               0.00                      0   \n",
       "\n",
       "   blackout_conflicts  available_hours  utilisation_ratio  downtime_hours  \\\n",
       "0                   0             24.0                1.0             0.0   \n",
       "1                   0             24.0                1.0             0.0   \n",
       "2                   0             24.0                1.0             0.0   \n",
       "3                   0             24.0                1.0             0.0   \n",
       "4                   0             24.0                1.0             0.0   \n",
       "\n",
       "   downtime_events  weather_severity_total  \n",
       "0                0                     0.0  \n",
       "1                0                     0.0  \n",
       "2                0                     0.0  \n",
       "3                0                     0.0  \n",
       "4                0                     0.0  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import sys\n",
    "from pathlib import Path\n",
    "\n",
    "PROJECT_ROOT = Path.cwd().resolve()\n",
    "while PROJECT_ROOT != PROJECT_ROOT.parent and not (PROJECT_ROOT / \"pyproject.toml\").exists():\n",
    "    PROJECT_ROOT = PROJECT_ROOT.parent\n",
    "if not (PROJECT_ROOT / \"pyproject.toml\").exists():\n",
    "    raise RuntimeError(\n",
    "        \"Notebook must be executed within a FHOPS checkout (pyproject.toml not found).\"\n",
    "    )\n",
    "if str(PROJECT_ROOT) not in sys.path:\n",
    "    sys.path.insert(0, str(PROJECT_ROOT))\n",
    "\n",
    "from docs.examples.analytics import utils\n",
    "\n",
    "SCENARIO = PROJECT_ROOT / \"examples/tiny7/scenario.yaml\"\n",
    "ASSIGNMENTS = PROJECT_ROOT / \"tests/fixtures/playback/tiny7_assignments.csv\"\n",
    "\n",
    "playback_tables = utils.load_deterministic_playback(SCENARIO, ASSIGNMENTS)\n",
    "playback_tables.shift.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cc480be6",
   "metadata": {},
   "source": [
    "## Production by Day\n",
    "\n",
    "Visualise production totals per day. Adjust the cell below to experiment with different views."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "a77887f6",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2026-10-05T12:56:51.928513Z",
     "iopub.status.busy": "2026-10-05T12:56:51.928243Z",
     "iopub.status.idle": "2026-10-05T12:56:51.954677Z",
     "shell.execute_reply": "2026-10-05T12:56:51.953931Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<style>\n",
       "  #altair-viz-ecc1cd782a55438c97e8cbd3f5becd52.vega-embed {\n",
       "    width: 100%;\n",
       "    display: flex;\n",
       "  }\n",
       "\n",
       "  #altair-viz-ecc1cd782a55438c97e8cbd3f5becd52.vega-embed details,\n",
       "  #altair-viz-ecc1cd782a55438c97e8cbd3f5becd52.vega-embed details summary {\n",
       "    position: relative;\n",
       "  }\n",
       "</style>\n",
       "<div id=\"altair-viz-ecc1cd782a55438c97e8cbd3f5becd52\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-ecc1cd782a55438c97e8cbd3f5becd52\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-ecc1cd782a55438c97e8cbd3f5becd52\");\n",
       "    }\n",
       "\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm/vega@6?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm/vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm/vega-lite@6.4.1?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm/vega-embed@7?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      let deps = [\"vega-embed\"];\n",
       "      require(deps, displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"6\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"6.4.1\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"7\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 300, \"continuousHeight\": 300}}, \"data\": {\"name\": \"data-293fe47942f18747370f6343cb11962f\"}, \"mark\": {\"type\": \"bar\"}, \"encoding\": {\"color\": {\"field\": \"sample_id\", \"type\": \"nominal\"}, \"x\": {\"field\": \"day\", \"type\": \"ordinal\"}, \"y\": {\"field\": \"production_units\", \"title\": \"Production (units)\", \"type\": \"quantitative\"}}, \"height\": 240, \"width\": 500, \"$schema\": \"https://vega.github.io/schema/vega-lite/v6.4.1.json\", \"datasets\": {\"data-293fe47942f18747370f6343cb11962f\": [{\"day\": 1, \"sample_id\": 0, \"production_units\": 2007.912755, \"total_hours\": 48.0, \"idle_hours\": 168.0, \"mobilisation_cost\": 0.0, \"completed_blocks\": 0, \"blackout_conflicts\": 0, \"sequencing_violations\": 0, \"available_hours\": 216.0, \"utilisation_ratio\": 0.2222222222222222, \"downtime_hours\": 0.0, \"downtime_events\": 0, \"weather_severity_total\": 0.0}, {\"day\": 2, \"sample_id\": 0, \"production_units\": 1438.0865290000004, \"total_hours\": 24.0, \"idle_hours\": 192.0, \"mobilisation_cost\": 0.0, \"completed_blocks\": 0, \"blackout_conflicts\": 0, \"sequencing_violations\": 0, \"available_hours\": 216.0, \"utilisation_ratio\": 0.1111111111111111, \"downtime_hours\": 0.0, \"downtime_events\": 0, \"weather_severity_total\": 0.0}, {\"day\": 3, \"sample_id\": 0, \"production_units\": 3193.795809999999, \"total_hours\": 120.0, \"idle_hours\": 96.0, \"mobilisation_cost\": 53.24, \"completed_blocks\": 0, \"blackout_conflicts\": 0, \"sequencing_violations\": 0, \"available_hours\": 216.0, \"utilisation_ratio\": 0.5555555555555556, \"downtime_hours\": 0.0, \"downtime_events\": 0, \"weather_severity_total\": 0.0}, {\"day\": 4, \"sample_id\": 0, \"production_units\": 4047.3441529999996, \"total_hours\": 144.0, \"idle_hours\": 72.0, \"mobilisation_cost\": 106.48, \"completed_blocks\": 0, \"blackout_conflicts\": 0, \"sequencing_violations\": 0, \"available_hours\": 216.0, \"utilisation_ratio\": 0.6666666666666666, \"downtime_hours\": 0.0, \"downtime_events\": 0, \"weather_severity_total\": 0.0}, {\"day\": 5, \"sample_id\": 0, \"production_units\": 2969.1939650000004, \"total_hours\": 96.0, \"idle_hours\": 120.0, \"mobilisation_cost\": 106.48, \"completed_blocks\": 1, \"blackout_conflicts\": 0, \"sequencing_violations\": 0, \"available_hours\": 216.0, \"utilisation_ratio\": 0.4444444444444444, \"downtime_hours\": 0.0, \"downtime_events\": 0, \"weather_severity_total\": 0.0}, {\"day\": 6, \"sample_id\": 0, \"production_units\": 1595.6877990000003, \"total_hours\": 72.0, \"idle_hours\": 144.0, \"mobilisation_cost\": 53.24, \"completed_blocks\": 0, \"blackout_conflicts\": 0, \"sequencing_violations\": 0, \"available_hours\": 216.0, \"utilisation_ratio\": 0.3333333333333333, \"downtime_hours\": 0.0, \"downtime_events\": 0, \"weather_severity_total\": 0.0}, {\"day\": 7, \"sample_id\": 0, \"production_units\": 2406.789997, \"total_hours\": 72.0, \"idle_hours\": 144.0, \"mobilisation_cost\": 159.72, \"completed_blocks\": 1, \"blackout_conflicts\": 0, \"sequencing_violations\": 0, \"available_hours\": 216.0, \"utilisation_ratio\": 0.3333333333333333, \"downtime_hours\": 0.0, \"downtime_events\": 0, \"weather_severity_total\": 0.0}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chart = utils.plot_production_by_day(playback_tables.day)\n",
    "chart"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "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.11.16"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}