Ejercicio_SP_UDF_Triggers_ETL.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/rubuntu/uaa-417-sistemas-de-gestion-de-bases-de-datos-avanzados/blob/main/Ejercicio_SP_UDF_Triggers_ETL.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "86gvNUTmCvBc"
      },
      "source": [
        "# Ejercicio: Implementación del ELT para el Data Warehouse con ClassicModels\n",
        "\n",
        "El esquema es de Classic Models, un minorista de modelos a escala de coches clásicos. La base de datos contiene datos comerciales típicos, como clientes, pedidos, artículos de línea de pedido, productos, etc.\n",
        "\n",
        "Fuente original: www.mysqltutorial.org"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "0_9-u1OiCAYQ"
      },
      "source": [
        "![classicmodels[1].svg](data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+CjwhRE9DVFlQRSBzdmcgUFVCTElDICItLy9XM0MvL0RURCBTVkcgMS4xLy9FTiIKICJodHRwOi8vd3d3LnczLm9yZy9HcmFwaGljcy9TVkcvMS4xL0RURC9zdmcxMS5kdGQiPgo8IS0tIEdlbmVyYXRlZCBieSBncmFwaHZpeiB2ZXJzaW9uIDIuMzguMCAoMjAxNDA0MTMuMjA0MSkKIC0tPgo8IS0tIFRpdGxlOiBuYW1lIFBhZ2VzOiAxIC0tPgo8c3ZnIHdpZHRoPSI1ODlwdCIgaGVpZ2h0PSIxMTQzcHQiCiB2aWV3Qm94PSIwLjAwIDAuMDAgNTg5LjAwIDExNDMuMDAiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgeG1sbnM6eGxpbms9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkveGxpbmsiPgo8ZyBpZD0iZ3JhcGgwIiBjbGFzcz0iZ3JhcGgiIHRyYW5zZm9ybT0ic2NhbGUoMSAxKSByb3RhdGUoMCkgdHJhbnNsYXRlKDQgMTEzOSkiPgo8dGl0bGU+bmFtZTwvdGl0bGU+CjwhLS0gZW1wbG95ZWVzIC0tPgo8ZyBpZD0ibm9kZTEiIGNsYXNzPSJub2RlIj48dGl0bGU+ZW1wbG95ZWVzPC90aXRsZT4KPHBvbHlnb24gZmlsbD0iTGF2ZW5kZXIiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI5MiwtMzkzLjUgOTIsLTQxNi41IDI1MywtNDE2LjUgMjUzLC0zOTMuNSA5MiwtMzkzLjUiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI5MiwtMzkzLjUgOTIsLTQxNi41IDI1MywtNDE2LjUgMjUzLC0zOTMuNSA5MiwtMzkzLjUiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxMzYuNSIgeT0iLTQwMS45IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtd2VpZ2h0PSJib2xkIiBmb250LXNpemU9IjEyLjAwIj5lbXBsb3llZXM8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iOTIsLTM3NC41IDkyLC0zOTMuNSAyMDEsLTM5My41IDIwMSwtMzc0LjUgOTIsLTM3NC41Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iOTIsLTM3NC41IDkyLC0zOTMuNSAyMDEsLTM5My41IDIwMSwtMzc0LjUgOTIsLTM3NC41Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iOTUiIHk9Ii0zODAuOSIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5lbXBsb3llZU51bWJlcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIyMDEsLTM3NC41IDIwMSwtMzkzLjUgMjUzLC0zOTMuNSAyNTMsLTM3NC41IDIwMSwtMzc0LjUiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIyMDEsLTM3NC41IDIwMSwtMzkzLjUgMjUzLC0zOTMuNSAyNTMsLTM3NC41IDIwMSwtMzc0LjUiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIyMDQiIHk9Ii0zODAuOSIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5pbnQ8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iOTIsLTM1NS41IDkyLC0zNzQuNSAyMDEsLTM3NC41IDIwMSwtMzU1LjUgOTIsLTM1NS41Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iOTIsLTM1NS41IDkyLC0zNzQuNSAyMDEsLTM3NC41IDIwMSwtMzU1LjUgOTIsLTM1NS41Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iOTUiIHk9Ii0zNjEuOSIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5sYXN0TmFtZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIyMDEsLTM1NS41IDIwMSwtMzc0LjUgMjUzLC0zNzQuNSAyNTMsLTM1NS41IDIwMSwtMzU1LjUiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIyMDEsLTM1NS41IDIwMSwtMzc0LjUgMjUzLC0zNzQuNSAyNTMsLTM1NS41IDIwMSwtMzU1LjUiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIyMDQiIHk9Ii0zNjEuOSIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjkyLC0zMzYuNSA5MiwtMzU1LjUgMjAxLC0zNTUuNSAyMDEsLTMzNi41IDkyLC0zMzYuNSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjkyLC0zMzYuNSA5MiwtMzU1LjUgMjAxLC0zNTUuNSAyMDEsLTMzNi41IDkyLC0zMzYuNSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9Ijk1IiB5PSItMzQyLjkiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+Zmlyc3ROYW1lPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIwMSwtMzM2LjUgMjAxLC0zNTUuNSAyNTMsLTM1NS41IDI1MywtMzM2LjUgMjAxLC0zMzYuNSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIwMSwtMzM2LjUgMjAxLC0zNTUuNSAyNTMsLTM1NS41IDI1MywtMzM2LjUgMjAxLC0zMzYuNSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjIwNCIgeT0iLTM0Mi45IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iOTIsLTMxNy41IDkyLC0zMzYuNSAyMDEsLTMzNi41IDIwMSwtMzE3LjUgOTIsLTMxNy41Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iOTIsLTMxNy41IDkyLC0zMzYuNSAyMDEsLTMzNi41IDIwMSwtMzE3LjUgOTIsLTMxNy41Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iOTUiIHk9Ii0zMjMuOSIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5leHRlbnNpb248L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMjAxLC0zMTcuNSAyMDEsLTMzNi41IDI1MywtMzM2LjUgMjUzLC0zMTcuNSAyMDEsLTMxNy41Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMjAxLC0zMTcuNSAyMDEsLTMzNi41IDI1MywtMzM2LjUgMjUzLC0zMTcuNSAyMDEsLTMxNy41Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjA0IiB5PSItMzIzLjkiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dmFyY2hhcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI5MiwtMjk4LjUgOTIsLTMxNy41IDIwMSwtMzE3LjUgMjAxLC0yOTguNSA5MiwtMjk4LjUiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI5MiwtMjk4LjUgOTIsLTMxNy41IDIwMSwtMzE3LjUgMjAxLC0yOTguNSA5MiwtMjk4LjUiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI5NSIgeT0iLTMwNC45IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmVtYWlsPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIwMSwtMjk4LjUgMjAxLC0zMTcuNSAyNTMsLTMxNy41IDI1MywtMjk4LjUgMjAxLC0yOTguNSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIwMSwtMjk4LjUgMjAxLC0zMTcuNSAyNTMsLTMxNy41IDI1MywtMjk4LjUgMjAxLC0yOTguNSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjIwNCIgeT0iLTMwNC45IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iOTIsLTI3OS41IDkyLC0yOTguNSAyMDEsLTI5OC41IDIwMSwtMjc5LjUgOTIsLTI3OS41Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iOTIsLTI3OS41IDkyLC0yOTguNSAyMDEsLTI5OC41IDIwMSwtMjc5LjUgOTIsLTI3OS41Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iOTUiIHk9Ii0yODUuOSIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5vZmZpY2VDb2RlPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIwMSwtMjc5LjUgMjAxLC0yOTguNSAyNTMsLTI5OC41IDI1MywtMjc5LjUgMjAxLC0yNzkuNSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIwMSwtMjc5LjUgMjAxLC0yOTguNSAyNTMsLTI5OC41IDI1MywtMjc5LjUgMjAxLC0yNzkuNSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjIwNCIgeT0iLTI4NS45IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iOTIsLTI2MC41IDkyLC0yNzkuNSAyMDEsLTI3OS41IDIwMSwtMjYwLjUgOTIsLTI2MC41Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iOTIsLTI2MC41IDkyLC0yNzkuNSAyMDEsLTI3OS41IDIwMSwtMjYwLjUgOTIsLTI2MC41Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iOTUiIHk9Ii0yNjYuOSIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5yZXBvcnRzVG88L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMjAxLC0yNjAuNSAyMDEsLTI3OS41IDI1MywtMjc5LjUgMjUzLC0yNjAuNSAyMDEsLTI2MC41Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMjAxLC0yNjAuNSAyMDEsLTI3OS41IDI1MywtMjc5LjUgMjUzLC0yNjAuNSAyMDEsLTI2MC41Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjA0IiB5PSItMjY2LjkiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+aW50PC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjkyLC0yNDEuNSA5MiwtMjYwLjUgMjAxLC0yNjAuNSAyMDEsLTI0MS41IDkyLC0yNDEuNSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjkyLC0yNDEuNSA5MiwtMjYwLjUgMjAxLC0yNjAuNSAyMDEsLTI0MS41IDkyLC0yNDEuNSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9Ijk1IiB5PSItMjQ3LjkiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+am9iVGl0bGU8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMjAxLC0yNDEuNSAyMDEsLTI2MC41IDI1MywtMjYwLjUgMjUzLC0yNDEuNSAyMDEsLTI0MS41Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMjAxLC0yNDEuNSAyMDEsLTI2MC41IDI1MywtMjYwLjUgMjUzLC0yNDEuNSAyMDEsLTI0MS41Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjA0IiB5PSItMjQ3LjkiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dmFyY2hhcjwvdGV4dD4KPC9nPgo8IS0tIGVtcGxveWVlcyYjNDU7Jmd0O2VtcGxveWVlcyAtLT4KPGcgaWQ9ImVkZ2UzIiBjbGFzcz0iZWRnZSI+PHRpdGxlPmVtcGxveWVlcyYjNDU7Jmd0O2VtcGxveWVlczwvdGl0bGU+CjxwYXRoIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIGQ9Ik0yMDEuNSwtNDIxLjQwN0MyMDEuNSwtNDMxLjk0MSAyMDEuNSwtNDM5IDIwMS41LC00MzkgMjAxLjUsLTQzOSAyNzMuNSwtNDM5IDI3My41LC00MzkgMjczLjUsLTQzOSAyNzMuNSwtMjIwIDI3My41LC0yMjAgMjczLjUsLTIyMCAyNTQuNSwtMjIwIDI1NC41LC0yMjAgMjU0LjUsLTIyMCAyNTQuNSwtMjI3LjU5MyAyNTQuNSwtMjI3LjU5MyIvPgo8cG9seWdvbiBmaWxsPSJibGFjayIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIyNTEsLTIyNy41OTMgMjU0LjUsLTIzNy41OTMgMjU4LC0yMjcuNTkzIDI1MSwtMjI3LjU5MyIvPgo8L2c+CjwhLS0gb2ZmaWNlcyAtLT4KPGcgaWQ9Im5vZGUzIiBjbGFzcz0ibm9kZSI+PHRpdGxlPm9mZmljZXM8L3RpdGxlPgo8cG9seWdvbiBmaWxsPSJMYXZlbmRlciIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjEwNCwtMTc1IDEwNCwtMTk4IDI0MSwtMTk4IDI0MSwtMTc1IDEwNCwtMTc1Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTA0LC0xNzUgMTA0LC0xOTggMjQxLC0xOTggMjQxLC0xNzUgMTA0LC0xNzUiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxNDkuNSIgeT0iLTE4My40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtd2VpZ2h0PSJib2xkIiBmb250LXNpemU9IjEyLjAwIj5vZmZpY2VzPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjEwNCwtMTU2IDEwNCwtMTc1IDE4OSwtMTc1IDE4OSwtMTU2IDEwNCwtMTU2Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTA0LC0xNTYgMTA0LC0xNzUgMTg5LC0xNzUgMTg5LC0xNTYgMTA0LC0xNTYiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxMDciIHk9Ii0xNjIuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5vZmZpY2VDb2RlPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjE4OSwtMTU2IDE4OSwtMTc1IDI0MSwtMTc1IDI0MSwtMTU2IDE4OSwtMTU2Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTg5LC0xNTYgMTg5LC0xNzUgMjQxLC0xNzUgMjQxLC0xNTYgMTg5LC0xNTYiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxOTIiIHk9Ii0xNjIuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjEwNCwtMTM3IDEwNCwtMTU2IDE4OSwtMTU2IDE4OSwtMTM3IDEwNCwtMTM3Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTA0LC0xMzcgMTA0LC0xNTYgMTg5LC0xNTYgMTg5LC0xMzcgMTA0LC0xMzciLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxMDciIHk9Ii0xNDMuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5jaXR5PC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjE4OSwtMTM3IDE4OSwtMTU2IDI0MSwtMTU2IDI0MSwtMTM3IDE4OSwtMTM3Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTg5LC0xMzcgMTg5LC0xNTYgMjQxLC0xNTYgMjQxLC0xMzcgMTg5LC0xMzciLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxOTIiIHk9Ii0xNDMuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjEwNCwtMTE4IDEwNCwtMTM3IDE4OSwtMTM3IDE4OSwtMTE4IDEwNCwtMTE4Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTA0LC0xMTggMTA0LC0xMzcgMTg5LC0xMzcgMTg5LC0xMTggMTA0LC0xMTgiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxMDciIHk9Ii0xMjQuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5waG9uZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIxODksLTExOCAxODksLTEzNyAyNDEsLTEzNyAyNDEsLTExOCAxODksLTExOCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjE4OSwtMTE4IDE4OSwtMTM3IDI0MSwtMTM3IDI0MSwtMTE4IDE4OSwtMTE4Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMTkyIiB5PSItMTI0LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dmFyY2hhcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIxMDQsLTk5IDEwNCwtMTE4IDE4OSwtMTE4IDE4OSwtOTkgMTA0LC05OSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjEwNCwtOTkgMTA0LC0xMTggMTg5LC0xMTggMTg5LC05OSAxMDQsLTk5Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMTA3IiB5PSItMTA1LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+YWRkcmVzc0xpbmUxPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjE4OSwtOTkgMTg5LC0xMTggMjQxLC0xMTggMjQxLC05OSAxODksLTk5Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTg5LC05OSAxODksLTExOCAyNDEsLTExOCAyNDEsLTk5IDE4OSwtOTkiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxOTIiIHk9Ii0xMDUuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjEwNCwtODAgMTA0LC05OSAxODksLTk5IDE4OSwtODAgMTA0LC04MCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjEwNCwtODAgMTA0LC05OSAxODksLTk5IDE4OSwtODAgMTA0LC04MCIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjEwNyIgeT0iLTg2LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+YWRkcmVzc0xpbmUyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjE4OSwtODAgMTg5LC05OSAyNDEsLTk5IDI0MSwtODAgMTg5LC04MCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjE4OSwtODAgMTg5LC05OSAyNDEsLTk5IDI0MSwtODAgMTg5LC04MCIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjE5MiIgeT0iLTg2LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dmFyY2hhcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIxMDQsLTYxIDEwNCwtODAgMTg5LC04MCAxODksLTYxIDEwNCwtNjEiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIxMDQsLTYxIDEwNCwtODAgMTg5LC04MCAxODksLTYxIDEwNCwtNjEiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxMDciIHk9Ii02Ny40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnN0YXRlPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjE4OSwtNjEgMTg5LC04MCAyNDEsLTgwIDI0MSwtNjEgMTg5LC02MSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjE4OSwtNjEgMTg5LC04MCAyNDEsLTgwIDI0MSwtNjEgMTg5LC02MSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjE5MiIgeT0iLTY3LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dmFyY2hhcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIxMDQsLTQyIDEwNCwtNjEgMTg5LC02MSAxODksLTQyIDEwNCwtNDIiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIxMDQsLTQyIDEwNCwtNjEgMTg5LC02MSAxODksLTQyIDEwNCwtNDIiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxMDciIHk9Ii00OC40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmNvdW50cnk8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMTg5LC00MiAxODksLTYxIDI0MSwtNjEgMjQxLC00MiAxODksLTQyIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTg5LC00MiAxODksLTYxIDI0MSwtNjEgMjQxLC00MiAxODksLTQyIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMTkyIiB5PSItNDguNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjEwNCwtMjMgMTA0LC00MiAxODksLTQyIDE4OSwtMjMgMTA0LC0yMyIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjEwNCwtMjMgMTA0LC00MiAxODksLTQyIDE4OSwtMjMgMTA0LC0yMyIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjEwNyIgeT0iLTI5LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+cG9zdGFsQ29kZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIxODksLTIzIDE4OSwtNDIgMjQxLC00MiAyNDEsLTIzIDE4OSwtMjMiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIxODksLTIzIDE4OSwtNDIgMjQxLC00MiAyNDEsLTIzIDE4OSwtMjMiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxOTIiIHk9Ii0yOS40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMTA0LC00IDEwNCwtMjMgMTg5LC0yMyAxODksLTQgMTA0LC00Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTA0LC00IDEwNCwtMjMgMTg5LC0yMyAxODksLTQgMTA0LC00Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMTA3IiB5PSItMTAuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj50ZXJyaXRvcnk8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMTg5LC00IDE4OSwtMjMgMjQxLC0yMyAyNDEsLTQgMTg5LC00Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTg5LC00IDE4OSwtMjMgMjQxLC0yMyAyNDEsLTQgMTg5LC00Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMTkyIiB5PSItMTAuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8L2c+CjwhLS0gZW1wbG95ZWVzJiM0NTsmZ3Q7b2ZmaWNlcyAtLT4KPGcgaWQ9ImVkZ2UyIiBjbGFzcz0iZWRnZSI+PHRpdGxlPmVtcGxveWVlcyYjNDU7Jmd0O29mZmljZXM8L3RpdGxlPgo8cGF0aCBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBkPSJNMTcyLC0yMzcuODc3QzE3MiwtMjM3Ljg3NyAxNzIsLTIxMi4wMTYgMTcyLC0yMTIuMDE2Ii8+Cjxwb2x5Z29uIGZpbGw9ImJsYWNrIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjE3NS41LC0yMTIuMDE2IDE3MiwtMjAyLjAxNiAxNjguNSwtMjEyLjAxNiAxNzUuNSwtMjEyLjAxNiIvPgo8L2c+CjwhLS0gY3VzdG9tZXJzIC0tPgo8ZyBpZD0ibm9kZTIiIGNsYXNzPSJub2RlIj48dGl0bGU+Y3VzdG9tZXJzPC90aXRsZT4KPHBvbHlnb24gZmlsbD0iTGF2ZW5kZXIiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI2NiwtNzA4IDY2LC03MzEgMjc5LC03MzEgMjc5LC03MDggNjYsLTcwOCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjY2LC03MDggNjYsLTczMSAyNzksLTczMSAyNzksLTcwOCA2NiwtNzA4Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMTM2LjUiIHk9Ii03MTYuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXdlaWdodD0iYm9sZCIgZm9udC1zaXplPSIxMi4wMCI+Y3VzdG9tZXJzPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjY2LC02ODkgNjYsLTcwOCAyMjcsLTcwOCAyMjcsLTY4OSA2NiwtNjg5Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNjYsLTY4OSA2NiwtNzA4IDIyNywtNzA4IDIyNywtNjg5IDY2LC02ODkiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI2OSIgeT0iLTY5NS40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmN1c3RvbWVyTnVtYmVyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIyNywtNjg5IDIyNywtNzA4IDI3OSwtNzA4IDI3OSwtNjg5IDIyNywtNjg5Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMjI3LC02ODkgMjI3LC03MDggMjc5LC03MDggMjc5LC02ODkgMjI3LC02ODkiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIyMzAiIHk9Ii02OTUuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5pbnQ8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iNjYsLTY3MCA2NiwtNjg5IDIyNywtNjg5IDIyNywtNjcwIDY2LC02NzAiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI2NiwtNjcwIDY2LC02ODkgMjI3LC02ODkgMjI3LC02NzAgNjYsLTY3MCIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjY5IiB5PSItNjc2LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+Y3VzdG9tZXJOYW1lPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIyNywtNjcwIDIyNywtNjg5IDI3OSwtNjg5IDI3OSwtNjcwIDIyNywtNjcwIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMjI3LC02NzAgMjI3LC02ODkgMjc5LC02ODkgMjc5LC02NzAgMjI3LC02NzAiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIyMzAiIHk9Ii02NzYuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjY2LC02NTEgNjYsLTY3MCAyMjcsLTY3MCAyMjcsLTY1MSA2NiwtNjUxIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNjYsLTY1MSA2NiwtNjcwIDIyNywtNjcwIDIyNywtNjUxIDY2LC02NTEiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI2OSIgeT0iLTY1Ny40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmNvbnRhY3RMYXN0TmFtZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIyMjcsLTY1MSAyMjcsLTY3MCAyNzksLTY3MCAyNzksLTY1MSAyMjcsLTY1MSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIyNywtNjUxIDIyNywtNjcwIDI3OSwtNjcwIDI3OSwtNjUxIDIyNywtNjUxIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjMwIiB5PSItNjU3LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dmFyY2hhcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI2NiwtNjMyIDY2LC02NTEgMjI3LC02NTEgMjI3LC02MzIgNjYsLTYzMiIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjY2LC02MzIgNjYsLTY1MSAyMjcsLTY1MSAyMjcsLTYzMiA2NiwtNjMyIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNjkiIHk9Ii02MzguNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5jb250YWN0Rmlyc3ROYW1lPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIyNywtNjMyIDIyNywtNjUxIDI3OSwtNjUxIDI3OSwtNjMyIDIyNywtNjMyIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMjI3LC02MzIgMjI3LC02NTEgMjc5LC02NTEgMjc5LC02MzIgMjI3LC02MzIiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIyMzAiIHk9Ii02MzguNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjY2LC02MTMgNjYsLTYzMiAyMjcsLTYzMiAyMjcsLTYxMyA2NiwtNjEzIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNjYsLTYxMyA2NiwtNjMyIDIyNywtNjMyIDIyNywtNjEzIDY2LC02MTMiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI2OSIgeT0iLTYxOS40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnBob25lPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIyNywtNjEzIDIyNywtNjMyIDI3OSwtNjMyIDI3OSwtNjEzIDIyNywtNjEzIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMjI3LC02MTMgMjI3LC02MzIgMjc5LC02MzIgMjc5LC02MTMgMjI3LC02MTMiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIyMzAiIHk9Ii02MTkuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjY2LC01OTQgNjYsLTYxMyAyMjcsLTYxMyAyMjcsLTU5NCA2NiwtNTk0Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNjYsLTU5NCA2NiwtNjEzIDIyNywtNjEzIDIyNywtNTk0IDY2LC01OTQiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI2OSIgeT0iLTYwMC40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmFkZHJlc3NMaW5lMTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIyMjcsLTU5NCAyMjcsLTYxMyAyNzksLTYxMyAyNzksLTU5NCAyMjcsLTU5NCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIyNywtNTk0IDIyNywtNjEzIDI3OSwtNjEzIDI3OSwtNTk0IDIyNywtNTk0Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjMwIiB5PSItNjAwLjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dmFyY2hhcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI2NiwtNTc1IDY2LC01OTQgMjI3LC01OTQgMjI3LC01NzUgNjYsLTU3NSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjY2LC01NzUgNjYsLTU5NCAyMjcsLTU5NCAyMjcsLTU3NSA2NiwtNTc1Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNjkiIHk9Ii01ODEuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5hZGRyZXNzTGluZTI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMjI3LC01NzUgMjI3LC01OTQgMjc5LC01OTQgMjc5LC01NzUgMjI3LC01NzUiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIyMjcsLTU3NSAyMjcsLTU5NCAyNzksLTU5NCAyNzksLTU3NSAyMjcsLTU3NSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjIzMCIgeT0iLTU4MS40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iNjYsLTU1NiA2NiwtNTc1IDIyNywtNTc1IDIyNywtNTU2IDY2LC01NTYiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI2NiwtNTU2IDY2LC01NzUgMjI3LC01NzUgMjI3LC01NTYgNjYsLTU1NiIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjY5IiB5PSItNTYyLjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+Y2l0eTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIyMjcsLTU1NiAyMjcsLTU3NSAyNzksLTU3NSAyNzksLTU1NiAyMjcsLTU1NiIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIyNywtNTU2IDIyNywtNTc1IDI3OSwtNTc1IDI3OSwtNTU2IDIyNywtNTU2Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjMwIiB5PSItNTYyLjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dmFyY2hhcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI2NiwtNTM3IDY2LC01NTYgMjI3LC01NTYgMjI3LC01MzcgNjYsLTUzNyIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjY2LC01MzcgNjYsLTU1NiAyMjcsLTU1NiAyMjcsLTUzNyA2NiwtNTM3Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNjkiIHk9Ii01NDMuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5zdGF0ZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIyMjcsLTUzNyAyMjcsLTU1NiAyNzksLTU1NiAyNzksLTUzNyAyMjcsLTUzNyIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIyNywtNTM3IDIyNywtNTU2IDI3OSwtNTU2IDI3OSwtNTM3IDIyNywtNTM3Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjMwIiB5PSItNTQzLjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dmFyY2hhcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI2NiwtNTE4IDY2LC01MzcgMjI3LC01MzcgMjI3LC01MTggNjYsLTUxOCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjY2LC01MTggNjYsLTUzNyAyMjcsLTUzNyAyMjcsLTUxOCA2NiwtNTE4Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNjkiIHk9Ii01MjQuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5wb3N0YWxDb2RlPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIyNywtNTE4IDIyNywtNTM3IDI3OSwtNTM3IDI3OSwtNTE4IDIyNywtNTE4Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMjI3LC01MTggMjI3LC01MzcgMjc5LC01MzcgMjc5LC01MTggMjI3LC01MTgiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIyMzAiIHk9Ii01MjQuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjY2LC00OTkgNjYsLTUxOCAyMjcsLTUxOCAyMjcsLTQ5OSA2NiwtNDk5Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNjYsLTQ5OSA2NiwtNTE4IDIyNywtNTE4IDIyNywtNDk5IDY2LC00OTkiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI2OSIgeT0iLTUwNS40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmNvdW50cnk8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMjI3LC00OTkgMjI3LC01MTggMjc5LC01MTggMjc5LC00OTkgMjI3LC00OTkiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIyMjcsLTQ5OSAyMjcsLTUxOCAyNzksLTUxOCAyNzksLTQ5OSAyMjcsLTQ5OSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjIzMCIgeT0iLTUwNS40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iNjYsLTQ4MCA2NiwtNDk5IDIyNywtNDk5IDIyNywtNDgwIDY2LC00ODAiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI2NiwtNDgwIDY2LC00OTkgMjI3LC00OTkgMjI3LC00ODAgNjYsLTQ4MCIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjY5IiB5PSItNDg2LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+c2FsZXNSZXBFbXBsb3llZU51bWJlcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIyMjcsLTQ4MCAyMjcsLTQ5OSAyNzksLTQ5OSAyNzksLTQ4MCAyMjcsLTQ4MCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIyNywtNDgwIDIyNywtNDk5IDI3OSwtNDk5IDI3OSwtNDgwIDIyNywtNDgwIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjMwIiB5PSItNDg2LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+aW50PC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjY2LC00NjEgNjYsLTQ4MCAyMjcsLTQ4MCAyMjcsLTQ2MSA2NiwtNDYxIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNjYsLTQ2MSA2NiwtNDgwIDIyNywtNDgwIDIyNywtNDYxIDY2LC00NjEiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI2OSIgeT0iLTQ2Ny40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmNyZWRpdExpbWl0PC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIyNywtNDYxIDIyNywtNDgwIDI3OSwtNDgwIDI3OSwtNDYxIDIyNywtNDYxIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMjI3LC00NjEgMjI3LC00ODAgMjc5LC00ODAgMjc5LC00NjEgMjI3LC00NjEiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIyMzAiIHk9Ii00NjcuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5kb3VibGU8L3RleHQ+CjwvZz4KPCEtLSBjdXN0b21lcnMmIzQ1OyZndDtlbXBsb3llZXMgLS0+CjxnIGlkPSJlZGdlMSIgY2xhc3M9ImVkZ2UiPjx0aXRsZT5jdXN0b21lcnMmIzQ1OyZndDtlbXBsb3llZXM8L3RpdGxlPgo8cGF0aCBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBkPSJNMTQyLjUsLTQ1Ni44OTZDMTQyLjUsLTQ1Ni44OTYgMTQyLjUsLTQzMS4xNDQgMTQyLjUsLTQzMS4xNDQiLz4KPHBvbHlnb24gZmlsbD0iYmxhY2siIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTQ2LC00MzEuMTQ0IDE0Mi41LC00MjEuMTQ0IDEzOSwtNDMxLjE0NCAxNDYsLTQzMS4xNDQiLz4KPC9nPgo8IS0tIG9yZGVycyAtLT4KPGcgaWQ9Im5vZGU0IiBjbGFzcz0ibm9kZSI+PHRpdGxlPm9yZGVyczwvdGl0bGU+Cjxwb2x5Z29uIGZpbGw9IkxhdmVuZGVyIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iOCwtOTI3IDgsLTk1MCAxNzAsLTk1MCAxNzAsLTkyNyA4LC05MjciLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI4LC05MjcgOCwtOTUwIDE3MCwtOTUwIDE3MCwtOTI3IDgsLTkyNyIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjY2LjUiIHk9Ii05MzUuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXdlaWdodD0iYm9sZCIgZm9udC1zaXplPSIxMi4wMCI+b3JkZXJzPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjgsLTkwOCA4LC05MjcgMTE4LC05MjcgMTE4LC05MDggOCwtOTA4Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iOCwtOTA4IDgsLTkyNyAxMTgsLTkyNyAxMTgsLTkwOCA4LC05MDgiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxMSIgeT0iLTkxNC40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPm9yZGVyTnVtYmVyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjExOCwtOTA4IDExOCwtOTI3IDE3MCwtOTI3IDE3MCwtOTA4IDExOCwtOTA4Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTE4LC05MDggMTE4LC05MjcgMTcwLC05MjcgMTcwLC05MDggMTE4LC05MDgiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxMjEiIHk9Ii05MTQuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5pbnQ8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iOCwtODg5IDgsLTkwOCAxMTgsLTkwOCAxMTgsLTg4OSA4LC04ODkiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI4LC04ODkgOCwtOTA4IDExOCwtOTA4IDExOCwtODg5IDgsLTg4OSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjExIiB5PSItODk1LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+b3JkZXJEYXRlPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjExOCwtODg5IDExOCwtOTA4IDE3MCwtOTA4IDE3MCwtODg5IDExOCwtODg5Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTE4LC04ODkgMTE4LC05MDggMTcwLC05MDggMTcwLC04ODkgMTE4LC04ODkiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxMjEiIHk9Ii04OTUuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5kYXRlPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjgsLTg3MCA4LC04ODkgMTE4LC04ODkgMTE4LC04NzAgOCwtODcwIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iOCwtODcwIDgsLTg4OSAxMTgsLTg4OSAxMTgsLTg3MCA4LC04NzAiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIxMSIgeT0iLTg3Ni40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnJlcXVpcmVkRGF0ZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIxMTgsLTg3MCAxMTgsLTg4OSAxNzAsLTg4OSAxNzAsLTg3MCAxMTgsLTg3MCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjExOCwtODcwIDExOCwtODg5IDE3MCwtODg5IDE3MCwtODcwIDExOCwtODcwIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMTIxIiB5PSItODc2LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+ZGF0ZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI4LC04NTEgOCwtODcwIDExOCwtODcwIDExOCwtODUxIDgsLTg1MSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjgsLTg1MSA4LC04NzAgMTE4LC04NzAgMTE4LC04NTEgOCwtODUxIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMTEiIHk9Ii04NTcuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5zaGlwcGVkRGF0ZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIxMTgsLTg1MSAxMTgsLTg3MCAxNzAsLTg3MCAxNzAsLTg1MSAxMTgsLTg1MSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjExOCwtODUxIDExOCwtODcwIDE3MCwtODcwIDE3MCwtODUxIDExOCwtODUxIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMTIxIiB5PSItODU3LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+ZGF0ZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI4LC04MzIgOCwtODUxIDExOCwtODUxIDExOCwtODMyIDgsLTgzMiIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjgsLTgzMiA4LC04NTEgMTE4LC04NTEgMTE4LC04MzIgOCwtODMyIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMTEiIHk9Ii04MzguNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5zdGF0dXM8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMTE4LC04MzIgMTE4LC04NTEgMTcwLC04NTEgMTcwLC04MzIgMTE4LC04MzIiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIxMTgsLTgzMiAxMTgsLTg1MSAxNzAsLTg1MSAxNzAsLTgzMiAxMTgsLTgzMiIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjEyMSIgeT0iLTgzOC40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iOCwtODEzIDgsLTgzMiAxMTgsLTgzMiAxMTgsLTgxMyA4LC04MTMiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI4LC04MTMgOCwtODMyIDExOCwtODMyIDExOCwtODEzIDgsLTgxMyIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjExIiB5PSItODE5LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+Y29tbWVudHM8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMTE4LC04MTMgMTE4LC04MzIgMTcwLC04MzIgMTcwLC04MTMgMTE4LC04MTMiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIxMTgsLTgxMyAxMTgsLTgzMiAxNzAsLTgzMiAxNzAsLTgxMyAxMTgsLTgxMyIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjEyMSIgeT0iLTgxOS40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnRleHQ8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iOCwtNzk0IDgsLTgxMyAxMTgsLTgxMyAxMTgsLTc5NCA4LC03OTQiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI4LC03OTQgOCwtODEzIDExOCwtODEzIDExOCwtNzk0IDgsLTc5NCIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjExIiB5PSItODAwLjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+Y3VzdG9tZXJOdW1iZXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMTE4LC03OTQgMTE4LC04MTMgMTcwLC04MTMgMTcwLC03OTQgMTE4LC03OTQiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIxMTgsLTc5NCAxMTgsLTgxMyAxNzAsLTgxMyAxNzAsLTc5NCAxMTgsLTc5NCIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjEyMSIgeT0iLTgwMC40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmludDwvdGV4dD4KPC9nPgo8IS0tIG9yZGVycyYjNDU7Jmd0O2N1c3RvbWVycyAtLT4KPGcgaWQ9ImVkZ2U2IiBjbGFzcz0iZWRnZSI+PHRpdGxlPm9yZGVycyYjNDU7Jmd0O2N1c3RvbWVyczwvdGl0bGU+CjxwYXRoIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIGQ9Ik0xMTcuNzUsLTc4OS45MzhDMTE3Ljc1LC03ODkuOTM4IDExNy43NSwtNzQ1LjEyIDExNy43NSwtNzQ1LjEyIi8+Cjxwb2x5Z29uIGZpbGw9ImJsYWNrIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjEyMS4yNSwtNzQ1LjEyIDExNy43NSwtNzM1LjEyIDExNC4yNSwtNzQ1LjEyIDEyMS4yNSwtNzQ1LjEyIi8+CjwvZz4KPCEtLSBvcmRlcmRldGFpbHMgLS0+CjxnIGlkPSJub2RlNSIgY2xhc3M9Im5vZGUiPjx0aXRsZT5vcmRlcmRldGFpbHM8L3RpdGxlPgo8cG9seWdvbiBmaWxsPSJMYXZlbmRlciIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIwNywtMTEwOCAyMDcsLTExMzEgMzY4LC0xMTMxIDM2OCwtMTEwOCAyMDcsLTExMDgiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIyMDcsLTExMDggMjA3LC0xMTMxIDM2OCwtMTEzMSAzNjgsLTExMDggMjA3LC0xMTA4Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjQ3IiB5PSItMTExNi40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtd2VpZ2h0PSJib2xkIiBmb250LXNpemU9IjEyLjAwIj5vcmRlcmRldGFpbHM8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMjA3LC0xMDg5IDIwNywtMTEwOCAzMTYsLTExMDggMzE2LC0xMDg5IDIwNywtMTA4OSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIwNywtMTA4OSAyMDcsLTExMDggMzE2LC0xMTA4IDMxNiwtMTA4OSAyMDcsLTEwODkiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIyMTAiIHk9Ii0xMDk1LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+b3JkZXJOdW1iZXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMzE2LC0xMDg5IDMxNiwtMTEwOCAzNjgsLTExMDggMzY4LC0xMDg5IDMxNiwtMTA4OSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjMxNiwtMTA4OSAzMTYsLTExMDggMzY4LC0xMTA4IDM2OCwtMTA4OSAzMTYsLTEwODkiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIzMTkiIHk9Ii0xMDk1LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+aW50PC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIwNywtMTA3MCAyMDcsLTEwODkgMzE2LC0xMDg5IDMxNiwtMTA3MCAyMDcsLTEwNzAiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIyMDcsLTEwNzAgMjA3LC0xMDg5IDMxNiwtMTA4OSAzMTYsLTEwNzAgMjA3LC0xMDcwIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjEwIiB5PSItMTA3Ni40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnByb2R1Y3RDb2RlPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjMxNiwtMTA3MCAzMTYsLTEwODkgMzY4LC0xMDg5IDM2OCwtMTA3MCAzMTYsLTEwNzAiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIzMTYsLTEwNzAgMzE2LC0xMDg5IDM2OCwtMTA4OSAzNjgsLTEwNzAgMzE2LC0xMDcwIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMzE5IiB5PSItMTA3Ni40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMjA3LC0xMDUxIDIwNywtMTA3MCAzMTYsLTEwNzAgMzE2LC0xMDUxIDIwNywtMTA1MSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIwNywtMTA1MSAyMDcsLTEwNzAgMzE2LC0xMDcwIDMxNiwtMTA1MSAyMDcsLTEwNTEiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIyMTAiIHk9Ii0xMDU3LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+cXVhbnRpdHlPcmRlcmVkPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjMxNiwtMTA1MSAzMTYsLTEwNzAgMzY4LC0xMDcwIDM2OCwtMTA1MSAzMTYsLTEwNTEiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIzMTYsLTEwNTEgMzE2LC0xMDcwIDM2OCwtMTA3MCAzNjgsLTEwNTEgMzE2LC0xMDUxIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMzE5IiB5PSItMTA1Ny40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmludDwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIyMDcsLTEwMzIgMjA3LC0xMDUxIDMxNiwtMTA1MSAzMTYsLTEwMzIgMjA3LC0xMDMyIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMjA3LC0xMDMyIDIwNywtMTA1MSAzMTYsLTEwNTEgMzE2LC0xMDMyIDIwNywtMTAzMiIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjIxMCIgeT0iLTEwMzguNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5wcmljZUVhY2g8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMzE2LC0xMDMyIDMxNiwtMTA1MSAzNjgsLTEwNTEgMzY4LC0xMDMyIDMxNiwtMTAzMiIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjMxNiwtMTAzMiAzMTYsLTEwNTEgMzY4LC0xMDUxIDM2OCwtMTAzMiAzMTYsLTEwMzIiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIzMTkiIHk9Ii0xMDM4LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+ZG91YmxlPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIwNywtMTAxMyAyMDcsLTEwMzIgMzE2LC0xMDMyIDMxNiwtMTAxMyAyMDcsLTEwMTMiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIyMDcsLTEwMTMgMjA3LC0xMDMyIDMxNiwtMTAzMiAzMTYsLTEwMTMgMjA3LC0xMDEzIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjEwIiB5PSItMTAxOS40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPm9yZGVyTGluZU51bWJlcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIzMTYsLTEwMTMgMzE2LC0xMDMyIDM2OCwtMTAzMiAzNjgsLTEwMTMgMzE2LC0xMDEzIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMzE2LC0xMDEzIDMxNiwtMTAzMiAzNjgsLTEwMzIgMzY4LC0xMDEzIDMxNiwtMTAxMyIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjMxOSIgeT0iLTEwMTkuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5zbWFsbGludDwvdGV4dD4KPC9nPgo8IS0tIG9yZGVyZGV0YWlscyYjNDU7Jmd0O29yZGVycyAtLT4KPGcgaWQ9ImVkZ2U0IiBjbGFzcz0iZWRnZSI+PHRpdGxlPm9yZGVyZGV0YWlscyYjNDU7Jmd0O29yZGVyczwvdGl0bGU+CjxwYXRoIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIGQ9Ik0yNTcsLTEwMDguNjJDMjU3LC05NzQuMzYxIDI1NywtOTM5IDI1NywtOTM5IDI1NywtOTM5IDE4OC40MTEsLTkzOSAxODguNDExLC05MzkiLz4KPHBvbHlnb24gZmlsbD0iYmxhY2siIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMTg4LjQxMSwtOTM1LjUgMTc4LjQxMSwtOTM5IDE4OC40MTEsLTk0Mi41IDE4OC40MTEsLTkzNS41Ii8+CjwvZz4KPCEtLSBwcm9kdWN0cyAtLT4KPGcgaWQ9Im5vZGU2IiBjbGFzcz0ibm9kZSI+PHRpdGxlPnByb2R1Y3RzPC90aXRsZT4KPHBvbHlnb24gZmlsbD0iTGF2ZW5kZXIiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI0MDAsLTk0NiA0MDAsLTk2OSA1NzEsLTk2OSA1NzEsLTk0NiA0MDAsLTk0NiIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjQwMCwtOTQ2IDQwMCwtOTY5IDU3MSwtOTY5IDU3MSwtOTQ2IDQwMCwtOTQ2Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNDU1IiB5PSItOTU0LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC13ZWlnaHQ9ImJvbGQiIGZvbnQtc2l6ZT0iMTIuMDAiPnByb2R1Y3RzPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjQwMCwtOTI3IDQwMCwtOTQ2IDUxOSwtOTQ2IDUxOSwtOTI3IDQwMCwtOTI3Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNDAwLC05MjcgNDAwLC05NDYgNTE5LC05NDYgNTE5LC05MjcgNDAwLC05MjciLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI0MDMiIHk9Ii05MzMuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5wcm9kdWN0Q29kZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI1MTksLTkyNyA1MTksLTk0NiA1NzEsLTk0NiA1NzEsLTkyNyA1MTksLTkyNyIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjUxOSwtOTI3IDUxOSwtOTQ2IDU3MSwtOTQ2IDU3MSwtOTI3IDUxOSwtOTI3Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNTIyIiB5PSItOTMzLjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dmFyY2hhcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI0MDAsLTkwOCA0MDAsLTkyNyA1MTksLTkyNyA1MTksLTkwOCA0MDAsLTkwOCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjQwMCwtOTA4IDQwMCwtOTI3IDUxOSwtOTI3IDUxOSwtOTA4IDQwMCwtOTA4Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNDAzIiB5PSItOTE0LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+cHJvZHVjdE5hbWU8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iNTE5LC05MDggNTE5LC05MjcgNTcxLC05MjcgNTcxLC05MDggNTE5LC05MDgiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI1MTksLTkwOCA1MTksLTkyNyA1NzEsLTkyNyA1NzEsLTkwOCA1MTksLTkwOCIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjUyMiIgeT0iLTkxNC40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iNDAwLC04ODkgNDAwLC05MDggNTE5LC05MDggNTE5LC04ODkgNDAwLC04ODkiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI0MDAsLTg4OSA0MDAsLTkwOCA1MTksLTkwOCA1MTksLTg4OSA0MDAsLTg4OSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjQwMyIgeT0iLTg5NS40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnByb2R1Y3RMaW5lPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjUxOSwtODg5IDUxOSwtOTA4IDU3MSwtOTA4IDU3MSwtODg5IDUxOSwtODg5Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNTE5LC04ODkgNTE5LC05MDggNTcxLC05MDggNTcxLC04ODkgNTE5LC04ODkiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI1MjIiIHk9Ii04OTUuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjQwMCwtODcwIDQwMCwtODg5IDUxOSwtODg5IDUxOSwtODcwIDQwMCwtODcwIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNDAwLC04NzAgNDAwLC04ODkgNTE5LC04ODkgNTE5LC04NzAgNDAwLC04NzAiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI0MDMiIHk9Ii04NzYuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5wcm9kdWN0U2NhbGU8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iNTE5LC04NzAgNTE5LC04ODkgNTcxLC04ODkgNTcxLC04NzAgNTE5LC04NzAiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI1MTksLTg3MCA1MTksLTg4OSA1NzEsLTg4OSA1NzEsLTg3MCA1MTksLTg3MCIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjUyMiIgeT0iLTg3Ni40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iNDAwLC04NTEgNDAwLC04NzAgNTE5LC04NzAgNTE5LC04NTEgNDAwLC04NTEiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI0MDAsLTg1MSA0MDAsLTg3MCA1MTksLTg3MCA1MTksLTg1MSA0MDAsLTg1MSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjQwMyIgeT0iLTg1Ny40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnByb2R1Y3RWZW5kb3I8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iNTE5LC04NTEgNTE5LC04NzAgNTcxLC04NzAgNTcxLC04NTEgNTE5LC04NTEiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI1MTksLTg1MSA1MTksLTg3MCA1NzEsLTg3MCA1NzEsLTg1MSA1MTksLTg1MSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjUyMiIgeT0iLTg1Ny40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iNDAwLC04MzIgNDAwLC04NTEgNTE5LC04NTEgNTE5LC04MzIgNDAwLC04MzIiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI0MDAsLTgzMiA0MDAsLTg1MSA1MTksLTg1MSA1MTksLTgzMiA0MDAsLTgzMiIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjQwMyIgeT0iLTgzOC40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnByb2R1Y3REZXNjcmlwdGlvbjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI1MTksLTgzMiA1MTksLTg1MSA1NzEsLTg1MSA1NzEsLTgzMiA1MTksLTgzMiIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjUxOSwtODMyIDUxOSwtODUxIDU3MSwtODUxIDU3MSwtODMyIDUxOSwtODMyIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNTIyIiB5PSItODM4LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dGV4dDwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI0MDAsLTgxMyA0MDAsLTgzMiA1MTksLTgzMiA1MTksLTgxMyA0MDAsLTgxMyIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjQwMCwtODEzIDQwMCwtODMyIDUxOSwtODMyIDUxOSwtODEzIDQwMCwtODEzIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNDAzIiB5PSItODE5LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+cXVhbnRpdHlJblN0b2NrPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjUxOSwtODEzIDUxOSwtODMyIDU3MSwtODMyIDU3MSwtODEzIDUxOSwtODEzIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNTE5LC04MTMgNTE5LC04MzIgNTcxLC04MzIgNTcxLC04MTMgNTE5LC04MTMiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI1MjIiIHk9Ii04MTkuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5zbWFsbGludDwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI0MDAsLTc5NCA0MDAsLTgxMyA1MTksLTgxMyA1MTksLTc5NCA0MDAsLTc5NCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjQwMCwtNzk0IDQwMCwtODEzIDUxOSwtODEzIDUxOSwtNzk0IDQwMCwtNzk0Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNDAzIiB5PSItODAwLjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+YnV5UHJpY2U8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iNTE5LC03OTQgNTE5LC04MTMgNTcxLC04MTMgNTcxLC03OTQgNTE5LC03OTQiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI1MTksLTc5NCA1MTksLTgxMyA1NzEsLTgxMyA1NzEsLTc5NCA1MTksLTc5NCIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjUyMiIgeT0iLTgwMC40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmRvdWJsZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI0MDAsLTc3NSA0MDAsLTc5NCA1MTksLTc5NCA1MTksLTc3NSA0MDAsLTc3NSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjQwMCwtNzc1IDQwMCwtNzk0IDUxOSwtNzk0IDUxOSwtNzc1IDQwMCwtNzc1Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNDAzIiB5PSItNzgxLjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+TVNSUDwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI1MTksLTc3NSA1MTksLTc5NCA1NzEsLTc5NCA1NzEsLTc3NSA1MTksLTc3NSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjUxOSwtNzc1IDUxOSwtNzk0IDU3MSwtNzk0IDU3MSwtNzc1IDUxOSwtNzc1Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNTIyIiB5PSItNzgxLjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+ZG91YmxlPC90ZXh0Pgo8L2c+CjwhLS0gb3JkZXJkZXRhaWxzJiM0NTsmZ3Q7cHJvZHVjdHMgLS0+CjxnIGlkPSJlZGdlNSIgY2xhc3M9ImVkZ2UiPjx0aXRsZT5vcmRlcmRldGFpbHMmIzQ1OyZndDtwcm9kdWN0czwvdGl0bGU+CjxwYXRoIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIGQ9Ik0zMTUuNSwtMTAwOC45MUMzMTUuNSwtOTg0LjgwNSAzMTUuNSwtOTYzIDMxNS41LC05NjMgMzE1LjUsLTk2MyAzODEuMzI2LC05NjMgMzgxLjMyNiwtOTYzIi8+Cjxwb2x5Z29uIGZpbGw9ImJsYWNrIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjM4MS4zMjYsLTk2Ni41IDM5MS4zMjYsLTk2MyAzODEuMzI2LC05NTkuNSAzODEuMzI2LC05NjYuNSIvPgo8L2c+CjwhLS0gcHJvZHVjdGxpbmVzIC0tPgo8ZyBpZD0ibm9kZTgiIGNsYXNzPSJub2RlIj48dGl0bGU+cHJvZHVjdGxpbmVzPC90aXRsZT4KPHBvbHlnb24gZmlsbD0iTGF2ZW5kZXIiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIzOTcsLTYyMiAzOTcsLTY0NSA1NzMsLTY0NSA1NzMsLTYyMiAzOTcsLTYyMiIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjM5NywtNjIyIDM5NywtNjQ1IDU3MywtNjQ1IDU3MywtNjIyIDM5NywtNjIyIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNDQzLjUiIHk9Ii02MzAuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXdlaWdodD0iYm9sZCIgZm9udC1zaXplPSIxMi4wMCI+cHJvZHVjdGxpbmVzPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjM5NywtNjAzIDM5NywtNjIyIDQ5NSwtNjIyIDQ5NSwtNjAzIDM5NywtNjAzIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMzk3LC02MDMgMzk3LC02MjIgNDk1LC02MjIgNDk1LC02MDMgMzk3LC02MDMiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI0MDAiIHk9Ii02MDkuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5wcm9kdWN0TGluZTwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSI0OTUsLTYwMyA0OTUsLTYyMiA1NzMsLTYyMiA1NzMsLTYwMyA0OTUsLTYwMyIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjQ5NSwtNjAzIDQ5NSwtNjIyIDU3MywtNjIyIDU3MywtNjAzIDQ5NSwtNjAzIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNDk4IiB5PSItNjA5LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dmFyY2hhcjwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIzOTcsLTU4NCAzOTcsLTYwMyA0OTUsLTYwMyA0OTUsLTU4NCAzOTcsLTU4NCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjM5NywtNTg0IDM5NywtNjAzIDQ5NSwtNjAzIDQ5NSwtNTg0IDM5NywtNTg0Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iNDAwIiB5PSItNTkwLjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+dGV4dERlc2NyaXB0aW9uPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjQ5NSwtNTg0IDQ5NSwtNjAzIDU3MywtNjAzIDU3MywtNTg0IDQ5NSwtNTg0Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNDk1LC01ODQgNDk1LC02MDMgNTczLC02MDMgNTczLC01ODQgNDk1LC01ODQiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI0OTgiIHk9Ii01OTAuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj52YXJjaGFyPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjM5NywtNTY1IDM5NywtNTg0IDQ5NSwtNTg0IDQ5NSwtNTY1IDM5NywtNTY1Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMzk3LC01NjUgMzk3LC01ODQgNDk1LC01ODQgNDk1LC01NjUgMzk3LC01NjUiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI0MDAiIHk9Ii01NzEuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5odG1sRGVzY3JpcHRpb248L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iNDk1LC01NjUgNDk1LC01ODQgNTczLC01ODQgNTczLC01NjUgNDk1LC01NjUiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSI0OTUsLTU2NSA0OTUsLTU4NCA1NzMsLTU4NCA1NzMsLTU2NSA0OTUsLTU2NSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjQ5OCIgeT0iLTU3MS40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPm1lZGl1bXRleHQ8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMzk3LC01NDYgMzk3LC01NjUgNDk1LC01NjUgNDk1LC01NDYgMzk3LC01NDYiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIzOTcsLTU0NiAzOTcsLTU2NSA0OTUsLTU2NSA0OTUsLTU0NiAzOTcsLTU0NiIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjQwMCIgeT0iLTU1Mi40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmltYWdlPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjQ5NSwtNTQ2IDQ5NSwtNTY1IDU3MywtNTY1IDU3MywtNTQ2IDQ5NSwtNTQ2Ii8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNDk1LC01NDYgNDk1LC01NjUgNTczLC01NjUgNTczLC01NDYgNDk1LC01NDYiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSI0OTgiIHk9Ii01NTIuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5tZWRpdW1ibG9iPC90ZXh0Pgo8L2c+CjwhLS0gcHJvZHVjdHMmIzQ1OyZndDtwcm9kdWN0bGluZXMgLS0+CjxnIGlkPSJlZGdlOCIgY2xhc3M9ImVkZ2UiPjx0aXRsZT5wcm9kdWN0cyYjNDU7Jmd0O3Byb2R1Y3RsaW5lczwvdGl0bGU+CjxwYXRoIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIGQ9Ik00ODUsLTc3MC43OTVDNDg1LC03NzAuNzk1IDQ4NSwtNjU5LjU1MSA0ODUsLTY1OS41NTEiLz4KPHBvbHlnb24gZmlsbD0iYmxhY2siIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iNDg4LjUsLTY1OS41NSA0ODUsLTY0OS41NTEgNDgxLjUsLTY1OS41NTEgNDg4LjUsLTY1OS41NSIvPgo8L2c+CjwhLS0gcGF5bWVudHMgLS0+CjxnIGlkPSJub2RlNyIgY2xhc3M9Im5vZGUiPjx0aXRsZT5wYXltZW50czwvdGl0bGU+Cjxwb2x5Z29uIGZpbGw9IkxhdmVuZGVyIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMjA0LC04OTggMjA0LC05MjEgMzY2LC05MjEgMzY2LC04OTggMjA0LC04OTgiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIyMDQsLTg5OCAyMDQsLTkyMSAzNjYsLTkyMSAzNjYsLTg5OCAyMDQsLTg5OCIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjI1MiIgeT0iLTkwNi40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtd2VpZ2h0PSJib2xkIiBmb250LXNpemU9IjEyLjAwIj5wYXltZW50czwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIyMDQsLTg3OSAyMDQsLTg5OCAzMTQsLTg5OCAzMTQsLTg3OSAyMDQsLTg3OSIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIwNCwtODc5IDIwNCwtODk4IDMxNCwtODk4IDMxNCwtODc5IDIwNCwtODc5Ii8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjA3IiB5PSItODg1LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+Y3VzdG9tZXJOdW1iZXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMzE0LC04NzkgMzE0LC04OTggMzY2LC04OTggMzY2LC04NzkgMzE0LC04NzkiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIzMTQsLTg3OSAzMTQsLTg5OCAzNjYsLTg5OCAzNjYsLTg3OSAzMTQsLTg3OSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjMxNyIgeT0iLTg4NS40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmludDwvdGV4dD4KPHBvbHlnb24gZmlsbD0iV2hpdGUiIHN0cm9rZT0ibm9uZSIgcG9pbnRzPSIyMDQsLTg2MCAyMDQsLTg3OSAzMTQsLTg3OSAzMTQsLTg2MCAyMDQsLTg2MCIvPgo8cG9seWdvbiBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjIwNCwtODYwIDIwNCwtODc5IDMxNCwtODc5IDMxNCwtODYwIDIwNCwtODYwIi8+Cjx0ZXh0IHRleHQtYW5jaG9yPSJzdGFydCIgeD0iMjA3IiB5PSItODY2LjQiIGZvbnQtZmFtaWx5PSJIZWx2ZXRpY2Esc2Fucy1TZXJpZiIgZm9udC1zaXplPSIxMi4wMCI+Y2hlY2tOdW1iZXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMzE0LC04NjAgMzE0LC04NzkgMzY2LC04NzkgMzY2LC04NjAgMzE0LC04NjAiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIzMTQsLTg2MCAzMTQsLTg3OSAzNjYsLTg3OSAzNjYsLTg2MCAzMTQsLTg2MCIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjMxNyIgeT0iLTg2Ni40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnZhcmNoYXI8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMjA0LC04NDEgMjA0LC04NjAgMzE0LC04NjAgMzE0LC04NDEgMjA0LC04NDEiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIyMDQsLTg0MSAyMDQsLTg2MCAzMTQsLTg2MCAzMTQsLTg0MSAyMDQsLTg0MSIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjIwNyIgeT0iLTg0Ny40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPnBheW1lbnREYXRlPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjMxNCwtODQxIDMxNCwtODYwIDM2NiwtODYwIDM2NiwtODQxIDMxNCwtODQxIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMzE0LC04NDEgMzE0LC04NjAgMzY2LC04NjAgMzY2LC04NDEgMzE0LC04NDEiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIzMTciIHk9Ii04NDcuNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5kYXRlPC90ZXh0Pgo8cG9seWdvbiBmaWxsPSJXaGl0ZSIgc3Ryb2tlPSJub25lIiBwb2ludHM9IjIwNCwtODIyIDIwNCwtODQxIDMxNCwtODQxIDMxNCwtODIyIDIwNCwtODIyIi8+Cjxwb2x5Z29uIGZpbGw9Im5vbmUiIHN0cm9rZT0iYmxhY2siIHBvaW50cz0iMjA0LC04MjIgMjA0LC04NDEgMzE0LC04NDEgMzE0LC04MjIgMjA0LC04MjIiLz4KPHRleHQgdGV4dC1hbmNob3I9InN0YXJ0IiB4PSIyMDciIHk9Ii04MjguNCIgZm9udC1mYW1pbHk9IkhlbHZldGljYSxzYW5zLVNlcmlmIiBmb250LXNpemU9IjEyLjAwIj5hbW91bnQ8L3RleHQ+Cjxwb2x5Z29uIGZpbGw9IldoaXRlIiBzdHJva2U9Im5vbmUiIHBvaW50cz0iMzE0LC04MjIgMzE0LC04NDEgMzY2LC04NDEgMzY2LC04MjIgMzE0LC04MjIiLz4KPHBvbHlnb24gZmlsbD0ibm9uZSIgc3Ryb2tlPSJibGFjayIgcG9pbnRzPSIzMTQsLTgyMiAzMTQsLTg0MSAzNjYsLTg0MSAzNjYsLTgyMiAzMTQsLTgyMiIvPgo8dGV4dCB0ZXh0LWFuY2hvcj0ic3RhcnQiIHg9IjMxNyIgeT0iLTgyOC40IiBmb250LWZhbWlseT0iSGVsdmV0aWNhLHNhbnMtU2VyaWYiIGZvbnQtc2l6ZT0iMTIuMDAiPmRvdWJsZTwvdGV4dD4KPC9nPgo8IS0tIHBheW1lbnRzJiM0NTsmZ3Q7Y3VzdG9tZXJzIC0tPgo8ZyBpZD0iZWRnZTciIGNsYXNzPSJlZGdlIj48dGl0bGU+cGF5bWVudHMmIzQ1OyZndDtjdXN0b21lcnM8L3RpdGxlPgo8cGF0aCBmaWxsPSJub25lIiBzdHJva2U9ImJsYWNrIiBkPSJNMjQxLjI1LC04MTguNDU3QzI0MS4yNSwtODE4LjQ1NyAyNDEuMjUsLTc0NS4wNjkgMjQxLjI1LC03NDUuMDY5Ii8+Cjxwb2x5Z29uIGZpbGw9ImJsYWNrIiBzdHJva2U9ImJsYWNrIiBwb2ludHM9IjI0NC43NSwtNzQ1LjA2OSAyNDEuMjUsLTczNS4wNjkgMjM3Ljc1LC03NDUuMDY5IDI0NC43NSwtNzQ1LjA2OSIvPgo8L2c+CjwvZz4KPC9zdmc+Cg==)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "xjDltiqMJv_d"
      },
      "source": [
        "**Contexto del Ejercicio:**\n",
        "\n",
        "La empresa ClassicModels requiere construir un Data Warehouse para mejorar sus capacidades analíticas y de toma de decisiones. La base de datos transaccional **ClassicModels**, originalmente en MySQL/MariaDB, ha sido transferida al esquema **ods** (Operational Data Store) de una base de datos PostgreSQL llamada **classicmodels_dw**. El objetivo es implementar el proceso **ELT** (Extract, Load, Transform) para transformar y cargar los datos al esquema **data_marts**, donde se aplicará el **modelado dimensional en estrella** siguiendo la **metodología de Kimball**.\n",
        "\n",
        "---\n",
        "\n",
        "**Objetivos Específicos:**\n",
        "\n",
        "1. **Crear las tablas de dimensiones y hechos** en el esquema **data_marts** según el diseño dimensional basado en la metodología de Kimball.\n",
        "\n",
        "2. **Implementar el proceso ELT**, escribiendo scripts SQL que:\n",
        "\n",
        "   - Extraigan los datos del esquema **ods**.\n",
        "   - Transformen los datos según los requerimientos del modelo dimensional.\n",
        "   - Carguen los datos en las tablas correspondientes del esquema **data_marts**.\n",
        "\n",
        "3. **Asegurar la integridad referencial** y la calidad de los datos durante todo el proceso. (Deseable)\n",
        "\n",
        "**Observación:** Hacer la implementación con procedimientos almacenados. Se recomienda usar \"upsert\" para actualizar la tabla de hechos y dimensiones."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "S9GJW31kBuMm"
      },
      "source": [
        "**Introducción**\n",
        "\n",
        "La base de datos educativa **ClassicModels** simula una empresa que vende autos a escala y otros productos clásicos. Contiene información sobre clientes, empleados, pedidos, productos y oficinas. Utilizando la **metodología de Kimball**, diseñaremos un **Data Warehouse** en PostgreSQL, mapeando los datos de origen desde MySQL/MariaDB. Proporcionaremos el **linaje de datos**, detallando cómo cada campo en las dimensiones y hechos se origina y transforma desde las tablas fuente.\n",
        "\n",
        "---\n",
        "\n",
        "**Metodología de Kimball**\n",
        "\n",
        "La metodología de Kimball se centra en el modelado dimensional, diseñando esquemas en estrella que facilitan el análisis y la toma de decisiones empresariales. Este enfoque implica:\n",
        "\n",
        "- **Identificación de Procesos de Negocio**: Determinar los procesos clave que el Data Warehouse debe soportar.\n",
        "- **Granos**: Definir el nivel de detalle (grano) de los datos almacenados.\n",
        "- **Dimensiones**: Identificar las entidades que describen los hechos.\n",
        "- **Hechos**: Determinar las medidas que se analizarán.\n",
        "\n",
        "---\n",
        "\n",
        "**Diseño del Data Warehouse**\n",
        "\n",
        "Basándonos en los requerimientos del negocio y los datos disponibles, diseñaremos las siguientes tablas:\n",
        "\n",
        "### Dimensiones:\n",
        "\n",
        "1. **dim_producto**\n",
        "2. **dim_cliente**\n",
        "3. **dim_empleado**\n",
        "4. **dim_tiempo**\n",
        "5. **dim_oficina**\n",
        "\n",
        "### Tabla de Hechos:\n",
        "\n",
        "1. **fact_ventas**\n",
        "\n",
        "---\n",
        "\n",
        "**Linaje de Datos: Mapeo de Origen de Datos**\n",
        "\n",
        "A continuación, se presenta el mapeo detallado de cada dimensión y la tabla de hechos, incluyendo las transformaciones aplicadas.\n",
        "\n",
        "---\n",
        "\n",
        "### **Dimensión `dim_producto`**\n",
        "\n",
        "**Descripción**: Información detallada de los productos vendidos.\n",
        "\n",
        "#### **Origen de Datos**:\n",
        "\n",
        "- **`products`**: Información básica de productos.\n",
        "- **`productlines`**: Detalles de las líneas de productos.\n",
        "\n",
        "#### **Mapeo y Transformaciones**:\n",
        "\n",
        "| Campo en `dim_producto`          | Origen                         | Transformación                            |\n",
        "|----------------------------------|--------------------------------|-------------------------------------------|\n",
        "| `producto_key`                   | Generado                       | Secuencia o ID autoincremental            |\n",
        "| `product_code`                   | `products.productCode`         | Ninguna                                   |\n",
        "| `nombre_producto`                | `products.productName`         | Ninguna                                   |\n",
        "| `linea_producto`                 | `productlines.productLine`     | JOIN en `productLine`                     |\n",
        "| `escala`                         | `products.productScale`        | Ninguna                                   |\n",
        "| `proveedor`                      | `products.productVendor`       | Ninguna                                   |\n",
        "| `descripcion`                    | `products.productDescription`  | Ninguna                                   |\n",
        "| `cantidad_en_stock`              | `products.quantityInStock`     | Ninguna                                   |\n",
        "| `precio_compra`                  | `products.buyPrice`            | Ninguna                                   |\n",
        "| `precio_venta`                   | `products.MSRP`                | Ninguna                                   |\n",
        "\n",
        "#### **Relaciones Clave**:\n",
        "\n",
        "- **JOIN con `productlines`**: Para obtener detalles de la línea de producto.\n",
        "\n",
        "---\n",
        "\n",
        "### **Dimensión `dim_cliente`**\n",
        "\n",
        "**Descripción**: Información de los clientes.\n",
        "\n",
        "#### **Origen de Datos**:\n",
        "\n",
        "- **`customers`**: Información de clientes.\n",
        "\n",
        "#### **Mapeo y Transformaciones**:\n",
        "\n",
        "| Campo en `dim_cliente`           | Origen                         | Transformación                            |\n",
        "|----------------------------------|--------------------------------|-------------------------------------------|\n",
        "| `cliente_key`                    | Generado                       | Secuencia o ID autoincremental            |\n",
        "| `customer_number`                | `customers.customerNumber`     | Ninguna                                   |\n",
        "| `nombre_cliente`                 | `customers.customerName`       | Ninguna                                   |\n",
        "| `contacto_nombre`                | `customers.contactFirstName`   | Ninguna                                   |\n",
        "| `contacto_apellido`              | `customers.contactLastName`    | Ninguna                                   |\n",
        "| `telefono`                       | `customers.phone`              | Ninguna                                   |\n",
        "| `direccion_linea1`               | `customers.addressLine1`       | Ninguna                                   |\n",
        "| `direccion_linea2`               | `customers.addressLine2`       | Ninguna                                   |\n",
        "| `ciudad`                         | `customers.city`               | Ninguna                                   |\n",
        "| `estado`                         | `customers.state`              | Ninguna                                   |\n",
        "| `codigo_postal`                  | `customers.postalCode`         | Ninguna                                   |\n",
        "| `pais`                           | `customers.country`            | Ninguna                                   |\n",
        "| `empleado_key`                   | `customers.salesRepEmployeeNumber` | Mapeo a `dim_empleado`                |\n",
        "\n",
        "---\n",
        "\n",
        "### **Dimensión `dim_empleado`**\n",
        "\n",
        "**Descripción**: Información sobre los empleados y representantes de ventas.\n",
        "\n",
        "#### **Origen de Datos**:\n",
        "\n",
        "- **`employees`**: Información de empleados.\n",
        "- **`offices`**: Información de oficinas.\n",
        "\n",
        "#### **Mapeo y Transformaciones**:\n",
        "\n",
        "| Campo en `dim_empleado`          | Origen                         | Transformación                            |\n",
        "|----------------------------------|--------------------------------|-------------------------------------------|\n",
        "| `empleado_key`                   | Generado                       | Secuencia o ID autoincremental            |\n",
        "| `employee_number`                | `employees.employeeNumber`     | Ninguna                                   |\n",
        "| `nombre`                         | `employees.firstName`          | Ninguna                                   |\n",
        "| `apellido`                       | `employees.lastName`           | Ninguna                                   |\n",
        "| `extension`                      | `employees.extension`          | Ninguna                                   |\n",
        "| `email`                          | `employees.email`              | Ninguna                                   |\n",
        "| `oficina_key`                    | `employees.officeCode`         | Mapeo a `dim_oficina`                     |\n",
        "| `puesto`                         | `employees.jobTitle`           | Ninguna                                   |\n",
        "| `jefe_employee_number`           | `employees.reportsTo`          | Mapeo recursivo a `dim_empleado`          |\n",
        "\n",
        "---\n",
        "\n",
        "### **Dimensión `dim_oficina`**\n",
        "\n",
        "**Descripción**: Detalles de las oficinas de la empresa.\n",
        "\n",
        "#### **Origen de Datos**:\n",
        "\n",
        "- **`offices`**: Información de oficinas.\n",
        "\n",
        "#### **Mapeo y Transformaciones**:\n",
        "\n",
        "| Campo en `dim_oficina`           | Origen                         | Transformación                            |\n",
        "|----------------------------------|--------------------------------|-------------------------------------------|\n",
        "| `oficina_key`                    | Generado                       | Secuencia o ID autoincremental            |\n",
        "| `office_code`                    | `offices.officeCode`           | Ninguna                                   |\n",
        "| `ciudad`                         | `offices.city`                 | Ninguna                                   |\n",
        "| `estado`                         | `offices.state`                | Ninguna                                   |\n",
        "| `pais`                           | `offices.country`              | Ninguna                                   |\n",
        "| `codigo_postal`                  | `offices.postalCode`           | Ninguna                                   |\n",
        "| `territorio`                     | `offices.territory`            | Ninguna                                   |\n",
        "| `direccion_linea1`               | `offices.addressLine1`         | Ninguna                                   |\n",
        "| `direccion_linea2`               | `offices.addressLine2`         | Ninguna                                   |\n",
        "\n",
        "---\n",
        "\n",
        "### **Dimensión `dim_tiempo`**\n",
        "\n",
        "**Descripción**: Información temporal para análisis.\n",
        "\n",
        "#### **Origen de Datos**:\n",
        "\n",
        "- **`orders.orderDate`**: Fechas de pedidos.\n",
        "- **`payments.paymentDate`**: Fechas de pagos.\n",
        "\n",
        "#### **Mapeo y Transformaciones**:\n",
        "\n",
        "| Campo en `dim_tiempo`            | Origen                         | Transformación                            |\n",
        "|----------------------------------|--------------------------------|-------------------------------------------|\n",
        "| `tiempo_key`                     | Generado                       | Secuencia o ID autoincremental            |\n",
        "| `fecha`                          | Generado                       | Rango de fechas entre mín. y máx.         |\n",
        "| `dia`                            | `fecha`                        | `EXTRACT(DAY FROM fecha)`                 |\n",
        "| `mes`                            | `fecha`                        | `EXTRACT(MONTH FROM fecha)`               |\n",
        "| `anio`                           | `fecha`                        | `EXTRACT(YEAR FROM fecha)`                |\n",
        "| `trimestre`                      | `fecha`                        | `EXTRACT(QUARTER FROM fecha)`             |\n",
        "| `nombre_dia`                     | `fecha`                        | `TO_CHAR(fecha, 'Day')`                   |\n",
        "| `nombre_mes`                     | `fecha`                        | `TO_CHAR(fecha, 'Month')`                 |\n",
        "| `es_fin_de_semana`               | `fecha`                        | Verificación de día de la semana          |\n",
        "\n",
        "---\n",
        "\n",
        "### **Tabla de Hechos `fact_ventas`**\n",
        "\n",
        "**Descripción**: Registra las ventas realizadas.\n",
        "\n",
        "#### **Origen de Datos**:\n",
        "\n",
        "- **`orders`**: Información de pedidos.\n",
        "- **`orderdetails`**: Detalles de pedidos.\n",
        "- **`payments`**: Información de pagos.\n",
        "\n",
        "#### **Mapeo y Transformaciones**:\n",
        "\n",
        "| Campo en `fact_ventas`           | Origen                         | Transformación                            |\n",
        "|----------------------------------|--------------------------------|-------------------------------------------|\n",
        "| `venta_key`                      | Generado                       | Secuencia o ID autoincremental            |\n",
        "| `order_number`                   | `orders.orderNumber`           | Ninguna                                   |\n",
        "| `producto_key`                   | `orderdetails.productCode`     | Mapeo a `dim_producto`                    |\n",
        "| `cliente_key`                    | `orders.customerNumber`        | Mapeo a `dim_cliente`                     |\n",
        "| `empleado_key`                   | `customers.salesRepEmployeeNumber` | Mapeo a `dim_empleado`               |\n",
        "| `tiempo_key`                     | `orders.orderDate`             | Mapeo a `dim_tiempo`                      |\n",
        "| `cantidad_pedida`                | `orderdetails.quantityOrdered` | Ninguna                                   |\n",
        "| `precio_unidad`                  | `orderdetails.priceEach`       | Ninguna                                   |\n",
        "| `monto_total`                    | Calculado                      | `cantidad_pedida * precio_unidad`         |\n",
        "| `estado_pedido`                  | `orders.status`                | Ninguna                                   |\n",
        "| `fecha_pedido`                   | `orders.orderDate`             | Ninguna                                   |\n",
        "| `fecha_requerida`                | `orders.requiredDate`          | Ninguna                                   |\n",
        "| `fecha_envio`                    | `orders.shippedDate`           | Ninguna                                   |\n",
        "\n",
        "#### **Relaciones Clave**:\n",
        "\n",
        "- **JOIN entre `orders` y `orderdetails`**: Para vincular pedidos y detalles.\n",
        "- **JOIN con `dim_producto`**: A través de `productCode`.\n",
        "- **JOIN con `dim_cliente`**: A través de `customerNumber`.\n",
        "- **JOIN con `dim_empleado`**: A través de `salesRepEmployeeNumber`.\n",
        "- **JOIN con `dim_tiempo`**: Basado en `orderDate`.\n",
        "\n",
        "---\n",
        "\n",
        "**Proceso ETL y Transformaciones**\n",
        "\n",
        "1. **Extracción**:\n",
        "\n",
        "   - Conectar a la base de datos ClassicModels (MySQL/MariaDB).\n",
        "   - Extraer datos de las tablas: `products`, `productlines`, `customers`, `employees`, `offices`, `orders`, `orderdetails`, `payments` , en el esquema ODS de la base de datos DATA_WAREHOUSE\n",
        "\n",
        "2. **Transformación**:\n",
        "\n",
        "   - **Dimensiones**:\n",
        "     - Crear claves sustitutas (`_key`) autoincrementales.\n",
        "     - Realizar joins necesarios para enriquecer las dimensiones.\n",
        "     - Estandarizar formatos de datos (fechas, textos).\n",
        "     - Manejar valores nulos y datos inconsistentes.\n",
        "\n",
        "   - **Hechos**:\n",
        "     - Calcular medidas (e.g., `monto_total`).\n",
        "     - Asegurar integridad referencial con dimensiones.\n",
        "\n",
        "3. **Carga**:\n",
        "\n",
        "   - Conectar a la base de datos DATA_WAREHOUSE, esquema DATA_MARTS (PostgreSQL)\n",
        "   - Crear esquemas y tablas según diseño.\n",
        "   - Insertar datos transformados en las tablas de dimensiones y hechos.\n",
        "   - Establecer índices y claves foráneas para optimizar consultas.\n",
        "\n",
        "---\n",
        "\n",
        "**Ejemplo de Mapeo Detallado para `fact_ventas`**\n",
        "\n",
        "- **`venta_key`**: Generado secuencialmente en PostgreSQL.\n",
        "- **`order_number`**: Tomado directamente de `orders.orderNumber`.\n",
        "- **`producto_key`**: Obtenido al mapear `orderdetails.productCode` a `dim_producto.product_code` y obtener `dim_producto.producto_key`.\n",
        "- **`cliente_key`**: Mapeado desde `orders.customerNumber` a `dim_cliente.customer_number`, obteniendo `dim_cliente.cliente_key`.\n",
        "- **`empleado_key`**: A través de `customers.salesRepEmployeeNumber` mapeado a `dim_empleado.employee_number`, obteniendo `dim_empleado.empleado_key`.\n",
        "- **`tiempo_key`**: Basado en `orders.orderDate`, se busca en `dim_tiempo.fecha` para obtener `dim_tiempo.tiempo_key`.\n",
        "- **`cantidad_pedida`**: Tomado de `orderdetails.quantityOrdered`.\n",
        "- **`precio_unidad`**: Tomado de `orderdetails.priceEach`.\n",
        "- **`monto_total`**: Calculado multiplicando `cantidad_pedida` por `precio_unidad`.\n",
        "- **`estado_pedido`**: Tomado de `orders.status`.\n",
        "- **`fecha_pedido`**: Tomado de `orders.orderDate`.\n",
        "- **`fecha_requerida`**: Tomado de `orders.requiredDate`.\n",
        "- **`fecha_envio`**: Tomado de `orders.shippedDate`.\n",
        "\n",
        "---\n",
        "\n",
        "**Implementación Técnica**\n",
        "\n",
        "- **Herramientas**: Utilizar una herramienta ETL (por ejemplo, DBT, Pentaho Data Integration, Talend) o scripts personalizados en Python con librerías como `pymysql` y `psycopg2` para conectar a ambas bases de datos.\n",
        "- **Conexión a Bases de Datos**:\n",
        "  - **MySQL/MariaDB**: Extraer datos de origen en el esquema ODS de base de datos PostgreSQL.\n",
        "  - **PostgreSQL**: Cargar datos transformados en el Data Warehouse.\n",
        "- **Procesamiento en Bloques**: Para manejar grandes volúmenes de datos, procesar en lotes para optimizar memoria y rendimiento.\n",
        "- **Programación**: Automatizar el proceso ETL para actualizaciones periódicas.\n",
        "\n",
        "---\n",
        "\n",
        "**Ventajas del Enfoque**\n",
        "\n",
        "- **Análisis Multidimensional**: El modelo en estrella facilita consultas complejas y análisis de datos.\n",
        "- **Escalabilidad**: Añadir nuevas dimensiones o hechos es más sencillo.\n",
        "- **Flexibilidad**: Adaptable a cambios en los requerimientos del negocio.\n",
        "- **Trazabilidad**: El linaje de datos permite rastrear el origen y transformación de cada dato.\n",
        "\n",
        "---\n",
        "\n",
        "**Conclusión**\n",
        "\n",
        "Siguiendo la **metodología de Kimball**, hemos diseñado un Data Warehouse en PostgreSQL basado en la base de datos ClassicModels, detallando el linaje de datos desde las tablas de origen en MySQL/MariaDB. Este enfoque garantiza que los datos están estructurados para análisis eficientes y soportan las necesidades de información del negocio.\n",
        "\n",
        "Este Data Warehouse permitirá a la empresa:\n",
        "\n",
        "- Analizar ventas por producto, cliente, empleado y tiempo.\n",
        "- Evaluar el rendimiento de representantes de ventas y oficinas.\n",
        "- Identificar tendencias y patrones en las ventas.\n",
        "- Tomar decisiones informadas basadas en datos confiables.\n",
        "\n",
        "---\n",
        "\n",
        "**Nota**: Este diseño es una propuesta que puede ajustarse según los requerimientos específicos del negocio y las particularidades de los datos reales. Es importante validar y posiblemente enriquecer este diseño con el conocimiento detallado de los procesos empresariales y necesidades de análisis."
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import subprocess\n",
        "import time\n",
        "import pandas as pd\n",
        "from sqlalchemy import create_engine, inspect, text\n",
        "\n",
        "# Instalar PostgreSQL, MariaDB y las dependencias necesarias\n",
        "subprocess.run([\"apt\", \"update\"])\n",
        "subprocess.run([\"apt\", \"install\", \"-y\", \"postgresql\", \"postgresql-contrib\", \"mariadb-server\", \"wget\", \"python3-pymysql\"])\n",
        "\n",
        "# Ajustar la dirección de enlace de MariaDB\n",
        "with open(\"/etc/mysql/mariadb.conf.d/50-server.cnf\", \"r\") as file:\n",
        "    config = file.read()\n",
        "\n",
        "if \"bind-address\" in config:\n",
        "    config = config.replace(\"bind-address            = 127.0.0.1\", \"bind-address            = 0.0.0.0\")\n",
        "else:\n",
        "    config += \"\\nbind-address            = 0.0.0.0\\n\"\n",
        "\n",
        "with open(\"/etc/mysql/mariadb.conf.d/50-server.cnf\", \"w\") as file:\n",
        "    file.write(config)\n",
        "\n",
        "# Iniciar servicios\n",
        "subprocess.run([\"service\", \"mariadb\", \"start\"])\n",
        "subprocess.run([\"service\", \"postgresql\", \"start\"])\n",
        "\n",
        "print(\"Esperando que MariaDB esté operativo...\")\n",
        "time.sleep(10)  # Espera para asegurar que el servicio esté disponible\n",
        "\n",
        "# Establecer contraseña para root en MariaDB\n",
        "subprocess.run([\"mysql\", \"-e\", \"ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES;\"])\n",
        "\n",
        "# Crear la base de datos classicmodels en MariaDB\n",
        "subprocess.run([\"mysql\", \"-u\", \"root\", \"-ppassword\", \"-e\", \"CREATE DATABASE IF NOT EXISTS classicmodels;\"])\n",
        "\n",
        "# Descargar y poblar la base de datos ClassicModels\n",
        "subprocess.run([\"wget\", \"-O\", \"classicmodels.sql\",\n",
        "                \"https://gist.githubusercontent.com/prof3ssorSt3v3/796ebc82fd8eeb0b697effaa1e86c3a6/raw/classicmodels.sql\"])\n",
        "subprocess.run(\"mysql -u root -ppassword classicmodels < classicmodels.sql\", shell=True)\n",
        "\n",
        "# Establecer contraseña para postgres\n",
        "subprocess.run([\"sudo\", \"-u\", \"postgres\", \"psql\", \"-c\", \"ALTER USER postgres WITH PASSWORD 'postgres';\"])\n",
        "\n",
        "# Reiniciar PostgreSQL después de cambiar la contraseña\n",
        "subprocess.run([\"service\", \"postgresql\", \"restart\"])\n",
        "\n",
        "# Crear la base de datos classicmodels_dw en PostgreSQL\n",
        "subprocess.run([\"sudo\", \"-u\", \"postgres\", \"createdb\", \"classicmodels_dw\"])\n",
        "\n",
        "# Parámetros de conexión para MariaDB\n",
        "mariadb_usuario = 'root'\n",
        "mariadb_contraseña = 'password'\n",
        "mariadb_host = '127.0.0.1'\n",
        "mariadb_puerto = 3306\n",
        "mariadb_base_datos = 'classicmodels'\n",
        "\n",
        "# Parámetros de conexión para PostgreSQL\n",
        "postgres_usuario = 'postgres'\n",
        "postgres_contraseña = 'postgres'\n",
        "postgres_host = '127.0.0.1'\n",
        "postgres_puerto = 5432\n",
        "postgres_base_datos = 'classicmodels_dw'\n",
        "\n",
        "# Crear el motor de conexión para MariaDB\n",
        "try:\n",
        "    mariadb_engine = create_engine(\n",
        "        f'mysql+pymysql://{mariadb_usuario}:{mariadb_contraseña}@{mariadb_host}:{mariadb_puerto}/{mariadb_base_datos}'\n",
        "    )\n",
        "    # Probar la conexión\n",
        "    with mariadb_engine.connect() as conn:\n",
        "        print(\"Conexión a MariaDB exitosa.\")\n",
        "except Exception as e:\n",
        "    print(\"Error conectando a MariaDB:\", e)\n",
        "    exit(1)\n",
        "\n",
        "\n",
        "# Crear el motor de conexión para PostgreSQL\n",
        "try:\n",
        "    postgres_engine = create_engine(\n",
        "        f'postgresql+psycopg2://{postgres_usuario}:{postgres_contraseña}@{postgres_host}:{postgres_puerto}/{postgres_base_datos}'\n",
        "    )\n",
        "    # Probar la conexión\n",
        "    with postgres_engine.connect() as conn:\n",
        "        print(\"Conexión a PostgreSQL exitosa.\")\n",
        "except Exception as e:\n",
        "    print(\"Error conectando a PostgreSQL:\", e)\n",
        "    exit(1)\n",
        "\n",
        "\n",
        "# Crear el esquema ODS en PostgreSQL si no existe\n",
        "with postgres_engine.connect() as conn:\n",
        "    conn.execute(text(\"CREATE SCHEMA IF NOT EXISTS ods;\"))\n",
        "    conn.commit()\n",
        "\n",
        "\n",
        "# Migrar tablas de MariaDB a PostgreSQL\n",
        "inspector = inspect(mariadb_engine)\n",
        "tablas = inspector.get_table_names()\n",
        "\n",
        "for nombre_tabla in tablas:\n",
        "    print(f\"Procesando la tabla {nombre_tabla}\")\n",
        "    df = pd.read_sql_table(nombre_tabla, mariadb_engine)\n",
        "    df.to_sql(nombre_tabla, postgres_engine, index=False, if_exists='replace', schema='ods')\n",
        "    print(f\"Tabla {nombre_tabla} copiada exitosamente.\")\n",
        "\n",
        "# Verificar las tablas copiadas\n",
        "print(\"Tablas copiadas en PostgreSQL (esquema ODS):\")\n",
        "with postgres_engine.connect() as conn:\n",
        "    result = conn.execute(text(\"SELECT table_name FROM information_schema.tables WHERE table_schema = 'ods';\"))\n",
        "    for row in result:\n",
        "        print(row[0])\n"
      ],
      "metadata": {
        "id": "sX3svn-WfCC4",
        "outputId": "71208291-ffe0-4c8c-a334-eecaacd78952",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Esperando que MariaDB esté operativo...\n",
            "Conexión a MariaDB exitosa.\n",
            "Conexión a PostgreSQL exitosa.\n",
            "Procesando la tabla customers\n",
            "Tabla customers copiada exitosamente.\n",
            "Procesando la tabla employees\n",
            "Tabla employees copiada exitosamente.\n",
            "Procesando la tabla offices\n",
            "Tabla offices copiada exitosamente.\n",
            "Procesando la tabla orderdetails\n",
            "Tabla orderdetails copiada exitosamente.\n",
            "Procesando la tabla orders\n",
            "Tabla orders copiada exitosamente.\n",
            "Procesando la tabla payments\n",
            "Tabla payments copiada exitosamente.\n",
            "Procesando la tabla productlines\n",
            "Tabla productlines copiada exitosamente.\n",
            "Procesando la tabla products\n",
            "Tabla products copiada exitosamente.\n",
            "Tablas copiadas en PostgreSQL (esquema ODS):\n",
            "customers\n",
            "employees\n",
            "offices\n",
            "orderdetails\n",
            "orders\n",
            "payments\n",
            "productlines\n",
            "products\n"
          ]
        }
      ]
    }
  ],
  "metadata": {
    "colab": {
      "provenance": [],
      "include_colab_link": true
    },
    "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.12.5"
    },
    "nbclean": true
  },
  "nbformat": 4,
  "nbformat_minor": 0
}