KPF-CC-Scheduler_v3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 142,
   "id": "deluxe-fraction",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Populating the interactive namespace from numpy and matplotlib\n"
     ]
    }
   ],
   "source": [
    "import astropy\n",
    "from astropy.time import Time,TimezoneInfo\n",
    "from astropy import units as u\n",
    "from astropy import coordinates as co\n",
    "import pandas as pd\n",
    "from astroplan import Observer\n",
    "%pylab inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 223,
   "id": "hydraulic-freeware",
   "metadata": {},
   "outputs": [],
   "source": [
    "nnights = 181\n",
    "t = Time('2021-02-2') + arange(nnights) * u.day # UT date\n",
    "df = pd.DataFrame(dict(utdate=t.to_value('iso','date')))\n",
    "keck = Observer.at_site(\"Keck\", timezone=\"US/Hawaii\")\n",
    "sunset = keck.sun_set_time(t,horizon=-12*u.deg,which='next')\n",
    "sunrise =  keck.sun_rise_time(t,horizon=-12*u.deg, which='next')\n",
    "moonrise = keck.moon_rise_time(t,horizon=0*u.deg, which='next')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 312,
   "id": "refined-friend",
   "metadata": {},
   "outputs": [],
   "source": [
    "nightlength = sunrise-sunset\n",
    "df2 = []\n",
    "for i in range(1,5):\n",
    "    df = pd.DataFrame(dict(utdate=t.to_value('iso','date')))\n",
    "    df['Date'] = (t - 1*u.day).to_value('iso','date')\n",
    "    df['quarter'] = i\n",
    "    start = sunset + (i-1) / 4.0 * nightlength\n",
    "    stop = sunset +  i / 4.0 * nightlength\n",
    "    df['nightlength'] = nightlength.value\n",
    "    df['start_jd'] =  start.jd\n",
    "    df['start'] = pd.Series(start.to_value('iso','date_hm')).str.slice(start=11,stop=16)\n",
    "    df['stop'] = pd.Series(stop.to_value('iso','date_hm')).str.slice(start=11,stop=16)\n",
    "    df['moon_alt_start'] = keck.moon_altaz(start).alt.deg\n",
    "    df['moon_alt_stop'] = keck.moon_altaz(stop).alt.deg\n",
    "    df2.append(df)\n",
    "\n",
    "df = pd.concat(df2)\n",
    "df = df.sort_values(by=['start_jd'])\n",
    "df = df.reset_index(drop=True)\n",
    "df['dark'] = (df.moon_alt_start < 0) & (df.moon_alt_stop < 0) # determine darktime\n",
    "calendar = df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 313,
   "id": "designed-newman",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "496/724 quarters remain after dropping dark all, early, late\n",
      "['2021-02-04' '2021-02-17' '2021-02-18' '2021-02-20' '2021-03-04'\n",
      " '2021-03-15' '2021-03-21' '2021-03-24' '2021-04-15' '2021-05-01'\n",
      " '2021-05-16' '2021-05-21' '2021-05-28' '2021-06-15' '2021-06-19'\n",
      " '2021-06-20' '2021-06-21' '2021-06-28' '2021-06-30' '2021-07-19'\n",
      " '2021-07-23' '2021-07-31']\n",
      "178/724 quarters are KPF-CC\n",
      "134/181 nights KPF-CC onsky\n"
     ]
    }
   ],
   "source": [
    "df = calendar.copy()\n",
    "dfrem = calendar.copy()\n",
    "\n",
    "df['kpfcc'] = False\n",
    "dark_early = df[df.quarter.isin([1,2])].groupby('utdate').filter(lambda x: x['dark'].sum()==2)\n",
    "dark_late = df[df.quarter.isin([3,4])].groupby('utdate').filter(lambda x: x['dark'].sum()==2)\n",
    "dark_all = df.groupby('utdate').filter(lambda x: x['dark'].sum()==4)\n",
    "\n",
    "rs = 0 \n",
    "nstart_quarters = len(df)\n",
    "nkpfcc_quarters = 181 \n",
    "ndark_quarters = 181 # remove this many quarters for darktime\n",
    "\n",
    "dfrem = dfrem.drop(dark_all.index,errors='ignore')\n",
    "dfrem = dfrem.drop(dark_early.index,errors='ignore')\n",
    "dfrem = dfrem.drop(dark_late.index,errors='ignore')\n",
    "\n",
    "print(\"{}/{} quarters remain after dropping dark all, early, late\".format(len(dfrem),nstart_quarters))\n",
    "\n",
    "# schedule 1/8 of nights are first half\n",
    "\n",
    "for i in range(4):\n",
    "    if i==0:\n",
    "        # schedule 1/8 of nights as Q1+Q2\n",
    "        nnights_select = int(0.125 * nkpfcc_quarters)\n",
    "\n",
    "        # remove dark early nights from consideration here.\n",
    "        temp = dfrem[~dfrem.utdate.isin(dark_early.utdate.drop_duplicates())]\n",
    "        dates = temp.utdate.drop_duplicates().sample(nnights_select,random_state=rs)\n",
    "        print(sort(dates))\n",
    "        df.loc[df.utdate.isin(dates) & (df.quarter.isin([1,2])),'kpfcc'] = True\n",
    "\n",
    "    if i==1:\n",
    "        # schedule 1/8 of nights as Q3+Q4\n",
    "        nnights_select = int(0.125 * nkpfcc_quarters)\n",
    "        temp = dfrem[~dfrem.utdate.isin(dark_late.utdate.drop_duplicates())]\n",
    "        dates = temp.utdate.drop_duplicates().sample(nnights_select,random_state=rs)\n",
    "        df.loc[df.utdate.isin(dates) & df.quarter.isin([3,4]),'kpfcc'] = True\n",
    "\n",
    "    if i==2:\n",
    "        # schedule 1/4 of nights as Q1 \n",
    "        nnights_select = int(0.25 * nkpfcc_quarters)\n",
    "        temp = dfrem[(dfrem.quarter==1)&(~dfrem.dark)]\n",
    "        dates = temp.utdate.drop_duplicates().sample(nnights_select,random_state=rs)\n",
    "        df.loc[df.utdate.isin(dates) & df.quarter.isin([1]),'kpfcc'] = True\n",
    "\n",
    "    if i==3:\n",
    "        # schedule 1/4 of nights as Q4\n",
    "        nnights_select = int(0.25 * nkpfcc_quarters)\n",
    "        temp = dfrem[(dfrem.quarter==4)&(~dfrem.dark)]\n",
    "        dates = temp.utdate.drop_duplicates().sample(nnights_select,random_state=rs)\n",
    "        df.loc[df.utdate.isin(dates) & df.quarter.isin([4]),'kpfcc'] = True\n",
    "\n",
    "    dfrem = dfrem[~dfrem.utdate.isin(dates)]\n",
    "\n",
    "\n",
    "print(\"{}/{} quarters are KPF-CC\".format(df.kpfcc.sum(),nstart_quarters))\n",
    "print(\"{}/{} nights KPF-CC onsky\".format((df.groupby('utdate')['kpfcc'].sum()>0).sum(),nnights))\n",
    "savecols = 'utdate quarter start stop kpfcc dark'.split()\n",
    "\n",
    "sched_cc = df.copy()\n",
    "sched_cc[savecols].to_csv('kpfcc_schedule_v3.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 314,
   "id": "seeing-gentleman",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.collections.QuadMesh at 0x7fd9c990de20>"
      ]
     },
     "execution_count": 314,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAnsAAARvCAYAAABgoyIgAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAABKPklEQVR4nO39fbjtd1kf+L/vc0TwoPIYJAcMcagRq02UBKVqeZAp+Rl5KGK1RotYHpoLoQxRUad1sLW0UzsKowgaflaYzlQEFBgT6h6qI0JrhGBJeAqJQIEkqEVBhcPTOfueP9baYeV4HvY5Z+/v2t/Peb2ua13svb5rf9e9zgL77v15qu4OAABj2rfuAgAA2D3CHgDAwIQ9AICBCXsAAAMT9gAABibsAQAMbNfDXlXtq6pfqaoPVdX1VfXNVfU/VNUfLp/72ZXXPnP53I1V9Yyj7vPsqrriOO9x56r6jeXfblTV3ZbPf8PyfW6qqv+jqr5gdz8tALAuVXWwqv7ZuuvYa6YIP09Ics8kD0jy1UlekeR9SZ6X5OokV1fVI5O8K8mVSS5McjjJW6vqtUk+leT5Sb4vyXOP8x5XJPlAd39HVf3o8j7PS/KCJP+ou99eVa9M8vgkv368Qr+w7tx3yV3P7NMCp+yCCw+tuwQ4a73ths98tLvPWXcdO+FZT7n7rf/3xifye6/78p962OM/XOuuZ6+YIuzdN8nLe7F787ur6pwk90jyHd3dVfWqJI9O8okkr+zujydJVb0ryQOTvC3J65Pc/QTvcVmSH17+/GtJfjWLsLeZ5EuXHb0vSfJXJyr0LrlrvrEedTqfETgDGxvXr7sEOGvtP/fmD667hp1QVQcvuejOee3LD+ZH/vlH84bHr7uivWPXw153/8LWz1X1tCQfT/LZ/vzRHbcleXh3vzXJW5ev+7ok35Tkad19KIvu3yUneJvzktyycr/7Ln/+6ST/b5K/TPLhJL975p8IANhrnvWUu9/6zd94l1z4N++cu99tX37vdV/eunsLkyzQqKq7VtVLkzw7yfdnMUy7pZMcWXnts7Po5D2luz92nPvdbzmv78aqesLyHlv37CRHqmp/khcmuTjJvbPoED7rGPd6elVdV1XXfS6fOcNPCgBMraoO/v51n8oTv/2LkyQ/ceU981M/++drrmrvmGKBxoEkb8pimPaSLELXvVZecjDJh5avvSrJY5I8pLv/4/Hu2d23dveDlo/XJLl1eZ/V+907ySe6++3dfSTJK5N8zTHudVV3X9Ldl9wpdz7DTwsATO1ZT7n7rT/8g/fIvn2LRt7XPujz3b01l7YnTDFn74okb+7u52w9UVVvXy7K+L0sFl78WFU9OIsu3Dd29+Fj3+q4rklyeRbz9J68/P1Ps5iv98Dufl+Sb03yhye6yQUXHjJ3CNbg0oMXrbsEOIvdvO4CzsjWXL2f/Rf3vsPzP3HlPfNDzzN3L5lmGPfiJE9YGXa9McmPJPnfsliV+5+7+23L152f5J0rr/2Gbb7HLyX5uqp6X5KvT/Li5ZzAH0jy6uV73jfJS3f0kwEAa3V0V2+L7t7n1efXSXDJRXfpt2yct+4y4Kyjswfr85/61W/r7hMtgtyzll29W3//9V/+18Jekrzzxs8suntv/ORZvVDDCRoAwCwdr6u3RXdvQdgDAGbn6BW4x2NlrrAHAMzQybp6W3T3zNm7gy+te7YTNABOzcZtdjGYs/3n3jy7OXsnm6t3tLN97p7OHgAwK9vt6m0527t7wh4AMBvbnat3tLN57p6wBwDMxql29baczd09YQ8AmIXT7eptOVu7e8IeADALp9vV23K2dveEPQBgzzvTrt6Ws7G7J+wBAHvemXb1tpyN3T1hDwDY03aqq7flbOvuCXsAwJ62U129LWdbd0/YAwD2rJ3u6m05m7p7wh4AsGftdFdvy9nU3RP2AIA9abe6elvOlu6esAcA7Em71dXbcrZ094Q9AGDPqaqD175t97p6W86G7p6wBwDsObvd1dtyNnT3hD0AYE/Z6up9x2W729XbMnp3T9gDAPaUqbp6W0bv7n3BugsA2Ljt+nWXAOwRVXXwIV935/zsv7j3pO/7E1feMz/0vI/mDY+f9G0nobMHAOwZU3f1tozc3RP2AIA9Yeq5ekcbde6esAcA7Anr6uptGbW7J+wBAGu37q7elhG7e8IeALB26+7qbRmxu1fdw3yWM3bJRXfpt2yct+4yOA2XHrxo3SUAzNJ/6le/rbsvWWcNyxW4t/6Xa7587WEvSd5542cWK3Pf+Mn1F7MDdPYAgLXaK129LaN194Q9AGBt9spcvaONNHdP2AMA1mavdfW2jNTdE/YAgLXYq129LaN094Q9AGAt9mpXb8so3T1hDwCY3F7v6m0Zobsn7AEAk9vrXb0tI3T3hD0AYFJz6eptmXt3T9gDACY1l67elrl394Q9AGAyc+vqbZlzd0/YAwAmM7eu3pbtdvdq4SVV9cGquraq7n/U9e+pqhur6qaqetbuVr0g7AEAk5hrV2/LNrt7j0tyTpLzk7wgyfO3LlTVPZL8VJJvTvK1Sf5+VT1wV4pdIewBAFN57hy7elu2untV9c0neNllSV7e3Z3kNUkesXLtK5O8s7v/rLs/m+T3k3zrrhW8JOwBAFP5hsf+3buuu4Yz8thH3zVJ/klVXbfyePrKS85LckuSLAPd/qraylvvT/K1VXVOVX1Jkv8xiy7grvqC3X4DAIAtVfPs6m1Zln9td3/3cV7SSQ6v/H64uzeTpLs/WlX/LMnvJPlkkj9a/ueu0tkDANg5tyY5mCRVdackn966UFUHktzU3X+rux+a5C+TvHu3CxL2AAB2zjVJLl/+fHmSN6xc+4Ikr62qu1XVlyf5liRv2u2CDOMyhI3brl93CZyBSw9etO4SgIlsZjObme9Qbuek+yq/Lsljqur9ST6c5IlV9cwk6e4XVdW/TvJfsxjq/cHu/vTxb7UzhD0AgB2yXIX71KOeftHK9ZckecmUNRnGBQAYmLAHADAww7gAwGSO9GaO9Hzn7G2efM7enqOzBwAwMJ29FTfdcMCqQFgDq6lhffafu+4K2G06ewAAA9PZAwAms5nO5rqLOAPb2Gdvz9HZAwAYmLAHADAwYQ8AYGDm7AFrZxU8rNPNk77bWXA27p6jswcAMDBhDwBgYMIeAMDAzNkDACZzpDtH5jft7XabPb/idfYAAAYm7AEADEzYAwAYmDl7AMBk5n427hxr19kDABiYsAcAMDBhDwBgYObsrbjgwkPZ2Lh+3WXAWcfZuHD2OJLOkXUXcQY2nY0LAMBeIuwBAAzMMC4AMJm5b73ShnEBANhLhD0AgIEZxmUIVnMCwLEJewDAZI5058j8pr3dbnOGtRvGBQAYmLAHADAwYQ8AYGDm7AEAk9lcPuZqhlP2hL1VN91wwKpOAGAohnEBAAYm7AEADMwwLgAwmSPpHFl3EWdgc4az9nT2AAAGJuwBAAxM2AMAGJg5ewDAZI505n027roLOA06ewAAAxP2AAAGJuwBAAzMnD0AYDLOxp2esLfiggsPZWPj+nWXwWlwpjEAHJthXACAgQl7AAADM4wLAEzmSCpHUusu47RtzrB2nT0AgIEJewAAAzOMu+KmGw5Y1QkAu2izF4+56hnWrrMHADAwYQ8AYGDCHgDAwMzZAwAmM/+tV+ZHZw8AYGDCHgDAwIQ9AICBmbMHAExmc/Zz9uZXu84eAMDAhD0AgIEJewAAAzNnb8UFFx7Kxsb16y6D0+BMY4B52OzKZs9v3tuWOdauswcAMDBhDwBgYMIeAMDAzNkDACZzJJV9M9yrbouzcQEA2FN09lbcdMMBqzoBgKHo7AEADExnDwCYzJHsm/WcvZ5h7Tp7AAADE/YAAAYm7AEADMycPQBgMrM/G9ecPQAA9hJhDwBgYIZxAYDJzP+4tPnVrrMHADAwYQ8AYGDCHgDAwMzZAwAmc6T3Zd+ct16ZYe06ewAAAxP2AAAGJuwBAAzMnD0AYDKb2TfLveq29Axr19kDABiYsAcAMDBhDwBgYObsAQCTcTbu9HT2AAAGJuwBAAzMMC4AZ2TjtuvXXQJnYP+5666A3SbsAQCTcTbu9AzjAgAMTNgDABiYsAcAMDBz9gCAyWymZrlX3RZn4wIAsKcIewAAAxP2AAAGZs4eADCZxdm48+01zXG+4Xz/tQEAOClhDwBgYIZxAYDJLI5Lm2+vyTAuAAB7irAHADAwYQ8AYGDm7AEAk9nMvmzOuNfUM6x9fhUDALBtwh4AwMCEPQCAgZmzBwBM5khX9vX89qrbstknvl5VleTFSS5L8pEk39ndt6xc//Yk/ybJnZO8trt/ZNeKXdLZAwDYOY9Lck6S85O8IMnzj7r+80keleSrk3xLVV282wUJewAAO+eyJC/v7k7ymiSPOOp6J/niJF+Y5IuSfGK3CxL2AAB2znlJbkmS7v5skv1VtZq3XpDkxiR/nOS2JDftdkHm7AFwRi49eNG6S+CM3Dzpu21mX47MuNe03CPwoVV13crTV3X3VcufO8nhlWuHu3szSarqnkl+OMkDk/z3JK9L8h1Jfn03axb2AABOzbXd/d3HuXZrkoNJ3lFVd0ry6ZVrX5nk+u7+UJJU1WuSfE12OezNN1oDAOw91yS5fPnz5UnesHLtj5J8bVXdazm0+4gkf7jbBensAQDsnNcleUxVvT/Jh5M8saqemSTd/aKq+rEkb8wig72+u6/e7YKEPQBgMpu9L5s934HFPskegctVuE896ukXrVx/VZJX7Xxlxzfff20AAE5KZw+AM7Jx2/XrLoEzsP/cdVfAbtPZAwAYmM4eADCZI9mXmnGvaTPzO9d3vv/aAACclLAHADAwYQ8AYGC7Hvaqal9V/UpVfaiqrq+qb66q/6Gq/nD53M+uvPaZy+durKpnHHWfZ1fVFcd5jztX1W8s/3ajqu5WVV+2vM/W431VtavHkQAAJ3aka9YPc/aO7QlJ7pnkAUm+J8lLkvxMkuctn/uqqnpkVd0nyZVJLkxySZJnVdXBqrpHVb04yU+d4D2uSPKB7j4vye8kubK7/6S7H7T1SPLmJL+wS58RAGBPmiLs3TfJy3vh3UnOySLMXb3cZfpVSR6dRfB7ZXd/vLs/keRdSR6Y5DNJXp/kRMeJXJbkZcuff215v9tV1bck+eLu/p0d+1QAADOw61uvdPft3bSqelqSjyf57DLoJcltSR7e3W9N8tbl674uyTcleVp3H0pydVVdcoK3OS/JLSv3u+9R138yyY+e0QcBAJihSfbZq6q7Jnlhkr+d5PuzGMrd0kmOrLz22VkEs6d098eOc7/7Jfnt5a8/vrzH4ePc74FJvrC733acez09ydOT5C45cIqfDAA4FZvZl80Zrw+d45y9XQ97VXUgyZuSvDGL4dvPJbnXyksOJvnQ8rVXJfmKJA/p7luPd8/ltQetvMczlvd57+r9ln4gyXEXZnT3VUmuSpIvrXv28V4HADBHU3T2rkjy5u5+ztYTVfX2qnpkkt9L8n1JfqyqHpzk4iTf2N2Hj32r47omyeVZLPp48vL3Ld+6fO6kLrjwUDY2nPEIU7v04EXrLoEz4Pubu5vXXQC7bIqwd3GSh1XV6qKJxyZ5RRYdvpd199uW8/nOT/LOqttbpE/q7rds4z1+Kckrqup9Sd6RxarfVNUXJvkb8d9kANgTjvS+VM93GLfbMO5f093fe5xLFx/1upcmeekJ7vOTJ7j2qSSPP8bzn01yn20VCgAwoPlGawAATkrYAwAY2CRbrwAAJIutS+a4fcmWOdYu7K246YYDVpUBAEMxjAsAMDBhDwBgYIZxAYDJzH2fvTnO2ZvvvzYAACcl7AEADMww7gpn48J6WAUPsHuEPQBgMkeyLzXjgcXNGdY+v4oBANg2YQ8AYGDCHgDAwMzZAwAms9mVzZ7fXnVbutddwakT9hiC1ZwAcGyGcQEABibsAQAMzDAuADAZ++xNb34VAwCwbcIeAMDADOOuuOmGA1Z1whps3OZMaliX/eeuuwJ2m7AHAExms/dls+c7sNgz3CNwvv/aAACclLAHADAww7gAwGSOpFKZ31Dols0Z1q6zBwAwMGEPAGBgwh4AwMDM2QMAJjP7rVfM2QMAYC8R9gAABibsAQAMzJw9AGAy899nb3509gAABibsAQAMTNgDABiYOXsAwGQ2M+999uZY+/wqBgBg23T2Vlxw4aFsbFy/7jI4DZcevGjdJXAGfH+wTjevuwB2mc4eAMDAdPYAgMkc6X2pGc5729I9vz0C5/uvDQDASQl7AAADE/YAAAZmzh4AMJlOZXPWZ+POr3adPQCAgQl7AAADE/YAAAZmzh4AMJkjvS+Z8T575uwBALCn6OwxhI3bnGk8Z87GBdg9wh4AMJnNrtQMjxzb4rg0AAD2FGEPAGBgwh4AwMDM2QMAJnMk+zLnXpOtVwAA2FOEPQCAgQl7AAADM2cPAJiMffamp7MHADAwYQ8AYGDCHgDAwMzZAwAms5lKzbjX1PbZAwBgLxH2AAAGJuwBAAzMnD0AYDJHupIZ7lW3ZXPdBZwGYY8hXHrwonWXAAB7kmFcAICBCXsAAAMzjAsATGbuZ+NuzrB2nT0AgIEJewAAAxP2AAAGZs4eADCZzd6X6vn2mtqcPQAA9hJhDwBgYIZxAYDJHEklmd9Q6JbNGdauswcAMDBhDwBgYMIeAMDAzNkDACYz9+PS2pw9AAD2EmEPAGBgwh4AwMDM2WMIG7ddv+4SOAOXHrxo3SUAE3Fc2vTm+68NAMBJCXsAAAMT9gAABmbOHgAwmc1UaoZ71W1xNi4AAHuKzh5DsJoTAI5NZw8AYGA6ewDAZI50JTPcq27L5roLOA06ewAAAxP2AAAGJuwBAAzMnD0AYDLzPxv3xLVXVSV5cZLLknwkyXd29y3Law9O8h9WXn6XJK/t7v9pV4pdmu+/NgDA3vO4JOckOT/JC5I8f+tCd/9hdz+oux+U5KuTvDfJL+12QcIeAMDOuSzJy7u7k7wmySOO87rvTfKu7n7PbhdkGBcA4NQ8tKquW/n9qu6+avnzeUluSZLu/mxV7a+qfd19+64ty6HeH01y6RTFCnsAwGQ2u1Iz3mevO0lybXd/9/FekuTwyu+HV4Pe0rcmeXt337bzFf51hnEBAHbOrUkOJklV3SnJp4/xmh9I8uqpChL2AAB2zjVJLl/+fHmSNxzjNX/nOM/vCsO4AMBkNlOpzHcYd/Pktb8uyWOq6v1JPpzkiVX1zCTp7hdV1QOS/GV3H9rdSj9P2AMA2CHLVbhPPerpF61c/2CSvzVlTYZxAQAGJuwBAAzMMC4AMJnZb70yw/mGwt6Km244kEsPXrTuMgAAdoxhXACAgQl7AAADM4wLAExms/eler69pp7hfMP5/msDAHBSwh4AwMCEPQCAgZmzBwBMpruyOcN5b1u6113BqdPZAwAYmLAHADAwYQ8AYGDm7AEAk9lMJTM8X3bL5gxr19kDABiYsAcAMDBhDwBgYObsAQCT2exK5rzPnjl7AADsJcIeAMDADOMCcEY2brt+3SVwBvafu+4K2G3CHgAwmdnP2XM2LgAAe4mwBwAwMMO4AMBk5j6MuznD2nX2AAAGJuwBAAxM2AMAGJg5ewDAZOY+Z89xaQAA7CnCHgDAwIQ9AICBmbMHAExmM5XMcN7blhmelqazBwAwMmEPAGBgwh4AwMDM2QMAJjP7ffZmWLvOHgDAwIQ9AICBCXsAAAMzZw8AmMzc5+xtzrB2nT0AgIEJewAAAxP2AAAGZs4esHYbt12/7hKAicx9zp6zcQEA2FOEPQCAgQl7AAADM2cPAJjM7OfszbB2nT0AgIEJe8DaXXrwonWXADAsYQ9YO1uvAOwec/YAgMl01yznvW3pzK92nT0AgIEJewAAAzOMCwBMZjOVzHAodMscj0sT9oA9wYrc+dq47Xrf30xZHHV2MIwLrJ2gMG++v/ny3Z0dhD0AgIEZxgUAJjP349I2Z1i7zh4AwMCEPQCAgQl7AAAD2/U5e1W1L8kvJ3lUko8leUaSjyR5dZJ7J3l1d1+5fO0zkzw3yaEkP9fdL165z7OTfKa7f/EY73HnJL+a5JIk70nyXd39F1V1TpJXJfnyJNcn+Z7u/sxufVbg9Nj+AdZn/7nTvt/cj0ub40Z7U3T2npDknkkekOR7krwkyc8ked7yua+qqkdW1X2SXJnkwixC27Oq6mBV3aOqXpzkp07wHlck+UB3n5fkd5b3SZKfTvLvu/uBSf4iyXfv+KcDANjDpgh7903y8l54d5JzsghzV3d3Z9F5e3QWwe+V3f3x7v5EkncleWCSzyR5fZKrT/AelyV52fLnX1veL0keluTly5+fm+S3d+pDAQDMwa4P43b3L2z9XFVPS/LxJJ9dBr0kuS3Jw7v7rUneunzd1yX5piRP6+5DSa6uqktO8DbnJbll5X73rap7JflckhdX1bck+YMshpDvoKqenuTpSXKXHDjNTwkAsDdNskCjqu5aVS9N8uwk35/k8MrlTnJk5bXPzqKT95Tu/thx7ne/qrpx+XjC8h5b99y63xcluSDJf0jyNUk+m+RZR9+ru6/q7ku6+5I75c5n+EkBgBPZ7Jr1o2d4ru8UCzQOJHlTkjdmMXz7uST3WnnJwSQfWr72qiRfkeQh3X3r8e65vPaglfd4xvI+712538eT/Gl3/+7yNa9N8p0786kAAOZhihM0rkjy5u5+ztYTVfX2qnpkkt9L8n1JfqyqHpzk4iTf2N2Hj32r47omyeVZLPp4cpJruvsTVfWBqvqG7n5Lkv8xy2FiYG9xPue8WU0Ne9sUYe/iJA+rqkevPPfYJK/IosP3su5+23I+3/lJ3ll1e4v0ScugdjK/lOQVVfW+JO/IYtVvkvxAkn9XVfdIcm0WW8AAAJw1plig8b3HuXTxUa97aZKXnuA+P3mCa59K8vhjPH9jFgs9AIA9YO777M2xdidoAAAMTNgDABiYsAcAMLApFmgAACRZ7LOXGc5729LOxgUAYC8R9gAABibsAQAMzJw9AGAy3fOc97ZljqXr7AEADExnb8UFFx7KxoYzHufI2aqwPv73N3c3r7sAdpmwBwBMZjOVZMZbr8ywdsO4AAADE/YAAAYm7AEADMycPQBgMt2VnvVxafOrXdhjCBu3WUU9Z1ZzAuwew7gAAAMT9gAABmYYFwCYzGZXMsN5b1vmeNSbzh4AwMCEPQCAgRnGXXHTDQesCgQAhiLsAQCT6Z7nvLctcyzdMC4AwMCEPQCAgQl7AAADM2cPAJiMs3GnJ+wBa+dsY1if/eeuuwJ2m2FcAICBCXsAAAMzjAsATGbuc/bmeK6vzh4AwMCEPQCAgRnGBdbOmdTzZjU17G3CHgAwme7K5gznvW1xNi4AAHuKsAcAMDDDuADAZLozz7HQpZ5h7Tp7AAAD09lbccGFh7KxYVXZHFnNCevjf39zd/O6C2CX6ewBAAxM2AMAJtP9+SPT5vo4kVp4SVV9sKqurar7H3X9gqq6rqr+qKp+aVf/sZeEPQCAnfO4JOckOT/JC5I8/6jrv5jkR5N8ZZK/UVUP2+2ChD0AgJ1zWZKXd3cneU2SR2xdqKq7Jbl3d//28vr3J3n3bhck7AEA7JzzktySJN392ST7q2orb/2NJH9eVa+sqvckeU6SP9vtgqzGXXHTDQesKgM4Rc7Gnbf95077ft2VzPi4tKSS5KFVdd3Kk1d191XLnzvJ4ZVrh7t7c/nzFyW5JMk3ZLEM+nVJ/n6SV+5mxcIeAMCpuba7v/s4125NcjDJO6rqTkk+vXLtY0ne1d3vTpKq+s0kX7WrlcYwLgDATromyeXLny9P8oaVazcmuUdVnV9VleRRSd662wXp7AEA7JzXJXlMVb0/yYeTPLGqnpkk3f2iqnpyFgs37pzkN7v7t3a7IGEPAJjMDI+WvYOT1b9cZfvUo55+0cr1/5Lk63e6rhMxjAsAMDCdvRXOxp0vq6hhffzvb+6cjTs6nT0AgIHp7AEAk5n7Pns9w0mHOnsAAAMT9gAABibsAQAMzJw9huBsznmzmhPOIp35b7Y3Mzp7AAADE/YAAAYm7AEADMycPQBgMp1577M3x9p19gAABqazxxCs5gSAYxP2AIDJ9My3XnFcGgAAe4qwBwAwMGEPAGBg5uwBAJPpnvfWKzOcsqezBwAwMmEPAGBgwh4AwMDM2QMApjPzOXtzrF1nDwBgYMIeAMDAhD0AgIGZswcATGbuZ+POsXadPQCAgQl7AAADE/YAAAZmzh4AMJ25z9mbIWFvxU03HMilBy9adxkAADvGMC4AwMCEPQCAgRnGBQAm0zM/G7dnWLvOHgDAwIQ9AICBGcZdccGFh7Kxcf26y4CzjlXwALtH2AMApjP3ffZmWLthXACAgQl7AAADM4wLAExm9luvrLuA06CzBwAwMJ29Fc7GBQBGo7MHADAwnT0AYDq2Xpmczh4AwMCEPQCAgQl7AAADM2cPAJhQLR9zNb/adfYAAAYm7AEADEzYAwAYmDl7AMB07LM3OZ09AICBCXsAAAMT9gAABmbOHgAwnbnP2ZshnT0AgIEJewAAAxP2AAAGZs4eADCdrsVjrmZYu84eAMDAhD0AgIEJewAAAzNnDwCYTNtnb3I6ewAAAxP2AAAGJuwBAAzMnD0AYDpzn7M3w9p19gAABibsAQAMzDAuADCd2R+Xtu4CTp3OHgDAwIQ9AICBCXsAAAMzZw8AmEz14sF0dPYAAAYm7AEADMwwLgBnZOO269ddAmdg/7nrroDdJuwBANNxXNrkDOMCAAxM2AMAGJiwBwAwMHP2AIDpzP5s3PnVLuwBa2c1J8DuMYwLADAwYQ8AYGCGcQGA6cx9n70Z0tkDABiYsAcAMDDDuMDaXXrwonWXwBmwmhr2NmEPAJjO3OfszbB2w7gAAAMT9gAABibsAQAMzJw9AGA65uxNTmcPAGBgwh4AwMAM4wIA0+laPGZrfrXr7AEADEzYAwAYmLAHADAwc/YAgMlULx5zNcfaT7mzV1VfuBuFAACw87YV9qrq7lX176rqz5P8VVV9fVW9sqruvcv1AQBwBrbb2fvFLNYaPzjJZpJ3JvnTJL+8S3UBALADtjtn77Ik9+/uv6yq7u7PVdWPJvnjXawNABiN49JOSVV9VZKfS/J/dve/r6rnJXlgkiu7+6Pbucd2O3sfSPLVRz335Un+ZLvFAgBwyn4lyduSvG75+y8k+USSf7fdG2y3s3dlktdV1auSfEFV/esk/yDJj2+/VgAATtHfSvKw7j6cJN390aq6MqfQcNtWZ6+7fzvJJUk+nOSlST6d5LHd/YpTLhkAgO36r0medNRzj8li1HVbttXZq6rf7O7HJvnpo55/TXc/YbtvBgDAKXlKFqOr/zTJ+5PcN8k9k2w7f50w7FXVf8xiKuKjq+r1R12+R5IHnFK5AABsW3ffXFVfm+QhSc5L8mdJ/kt3f3q79zhZZ+8VWWy58ugkv3bUtcNJrt1+uQAAnIrjrMZ9clVtezXuCcNed798+Ubv7u63HKOAb0/yvlMvHQCAbfiVJL+b5LXL338hyb/IYjXu47Zzg+2uxr2lqv5tknutPHen5ZvcbZv3AADOcrM/G/dk16sqyYuz2KP4I0m+s7tvWbn+o0memuTI8qlv6+4TLbaYZjVukpclud/y9Q9YvsHDk1y+3TcCADgLPC7JOUnOT/KCJM8/6vqDklza3Q9aPk62qnaa1bhJHprkPkkOJnlxd/94VV2TxT5712z3zQAABndZkpd3d1fVa3LUTiZZHEpx6ync76lJXrtrq3FXfDKLlPrBJF+1fO66LLp7AABnk4dW1XUrv1/V3Vctfz4vyS1J0t2frar9VbWvuzeX178syeur6twkv9bd//xYb1DL82mT3Jzka5N8QxZBccdX4255URYrb/9OkndW1f+VxZy9G7b7RgAA6Vo85mox3/Da7v7uE7zi8Mrvh1eCXpL8VpIXJvl4kv+7qv5ed7/2GPc5VFV3T/JX3f2FWeSw09oFZbsnaDw/yd9N8t+TPDmLceL3J3ni6bwpAMCgbs1i2luq6k5ZnDqW5e/7kzyvu2/t7k8m+fUsunbH8rYszsD9gqo6dNTjU1V1aLsFnWxT5fus/PrRJF+0/PnntvsGACezcdv16y4BYKdck8UC1o3lf75h5dqXJXlTVX19FlPkvj2LLt+xPDKL0PhHSb76TAo62TDuH2erYfl5h5d/t5nkr7KYJAgAQPK6JI+pqvcn+XCSJ1bVM5Oku19UVS9M8vYkn0ryG939hmPdpLs/l8VaiTtV1V2TfGMWi2X/OMnvd/dntlvQyTZV3pckVfUvlm/wz5b7u5ybxYZ+793uGwEApPPX20gDWS6qeOpRT79o5frPJ/n57d6vqh6e5FVZ7Nn30Sy2wLvrcq7fH2znHttdoPHsJOd296FloR+pqv8pyYeS/G/bLRgAgFPyi0l+sLtftfVEVV2R5KVJLtzODba7qfLHk3zrUc89PMnHtvn3AACcuvvm80elbfl3Sb5iuzfYbmfvmUn+j+WeMh/KooV4SZLv3e4bAQDMfhh3+tqfn+RfVtW/7O6/qqovSfJDWZyRuy3bCnvd/ZtV9RVZrBq5f5I3Jfne7v7Tk/1tVe1L8stJHpVFJ/AZWYw7vzrJvZO8uruvXL72mUmem+RQkp/r7hev3OfZST7T3b94jPe4c5JfzSKAvifJd3X3X1TV5Un+ZZLPLl/61O5+8/FqveDCQ9nYsCoQpnbpwYvWXQKcxW5edwGc2D9NcrckP1RVf7X8OUk+XVX/JIvjeru7DxzvBtsKe1V1Q3dfmOQ/rDy3v6r+sLsffJI/f0IWK3YfkMXS4VckeV+S5yW5OsnVVfXIJO9KcmUW48+Hk7y1ql6bxWqV5yf5viyC4LFckeQD3f0dywOGr1ze/yuzCHi/s53PCQCwxzwvixW+q744yf+e5CnbucHJ9tl7TxYNywdV1buPuny3LILYydw3yzPikry7qs5Jco8k37E8N+5VSR6dxcaBr+zujy/f+11JHpjFpoKvT3L3E7zHZUl+ePnzr2XR5XteFkeWfHgbNQIA7EX/OMm9u/t/qap7ZLEbylOS/Ep3f3A7NzhZZ++KLNqDb1j5ecvhJO842Rt09+1jylX1tCwWe3x2Gf6S5LYkD+/utyZ56/J1X5fkm5I8bbkC+OqquuQEb3P7OXTL+913+fMDkry4qu6f5D8luXK5b83tqurpSZ6eJOfdb7tTGAGA01G9eMzW9LX/nSxy0MVZ7LV3bZKLu/s9273ByfbZe2OSVNWHs1j6eyx/82RvstwM8IVJ/naS70/yktW3SXJk5bXPTvKjSZ7S3cdc7VtV90vy28tffzx3PIdu9X6/m+Q3ktyU5FeS/GCO2ql6eXDxVUlyyUV3mfN//QCAwXT3n1fVo7LYa++mJI/v7iMn+bM72G4r6wdWft6XxQbL359lJ+5EqupAFgs63pjFAorPJbnXyksOZrHCN1V1VRZLiR/S3bce757Law9aeY9nLO/z3q37VVUleWF3f2L5ml9N8h0nqxcAYN1WptJtuVMW09veX1WfTJLuPmnDLdn+atw3HqOIVyf5/Szmxp3IFUne3N3PWfnbty8XZfxeFgsvfqyqHpzk4iTf2N2Hj32r49o6h+55SZ68/H1/kpuq6pLuvi3J45KccKfpm244YFUgwClytvG87T933RVwHFfs1I3OZJLa3bO9c3EvTvKwqnr0ynOPzWJV7r2SvKy737acz3d+kncumnJJkid191u28R6/lOQVVfW+LOYRfk93H14OCf9uVR3Oorv4sm3cCwDYLXPfZ28ix2q0na7tbr1ydCtxXxaLIv7Xk/1tdx9v4+WLj3rdS7M4+uN49/nJE1z7VJLHH+P5V2Uxxg0AcFbabmfv6FbiZpJbuvsDO1wPAAA76LTn7AEAsPfZWA4AmM7c5+zNsHZhD1g7qzkBds++dRcAAMDuEfYAAAZmGBcAmMzcz8adY+06ewAAAxP2AAAGZhh3xQUXHsrGhlWBc+RM43nz/cE63bzuAthlwh4AMJ2uxWO25le7YVwAgIEJewAAAxP2AAAGZs4eADAdZ+NOTmcPAGBgwh4AwMAM4wIAk3Fc2vR09gAABibsAQAMTNgDABiYOXsAwHTmvvXKDOnsAQAMTNgDABiYsAcAMDBz9gCAycx9n705zjfU2QMAGJiwBwAwMGEPAGBg5uwBANOZ+z57M6xdZw8AYGDCHgDAwIQ9AICBmbMHAExn7nP2ZkhnDwBgYMIeAMDAhD0AgIGZswcATGbuZ+POsXadPQCAgQl7AAADE/YAAAYm7AEADEzYAwAYmLAHADAwW68AANNxXNrkhL0VN91wIJcevGjdZcBZZ+O269ddApy19p+77grYbYZxAQAGJuwBAAzMMC4AMBnHpU1PZw8AYGDCHgDAwAzjrrjgwkPZ2LAqcI6sop433x+s083rLoBdJuwBANOa4by3282wdsO4AAADE/YAAAYm7AEADMycPQBgOs7GnZzOHgDAwIQ9AICBCXsAAAMzZw8AmMzcz8ad43xDnT0AgIEJewAAAxP2AAAGZs4eADCdue+zN8PadfYAAAYm7AEADEzYAwAYmDl7AMBk5r7PXq27gNOgswcAMDBhDwBgYIZxAYDp2Hplcjp7AAADE/YAAAYm7AEADMycvRU33XAglx68aN1lAMC4zNmbnM4eAMDAhD0AgIEJewAAAzNnDwCYjOPSpqezBwAwMGEPAGBgwh4AwMDM2QMApmOfvcnp7AEADEzYAwAYmLAHADAwc/ZWXHDhoWxsXL/uMuCs40xqOIuYszc5nT0AgIEJewAAAxP2AAAGZs4eADCdmZ+NO0c6ewAAA9PZW3HTDQesCgQAhqKzBwAwMJ09AGA69tmbnM4eAMDAhD0AgIEJewAAAzNnDwCYTM18n71adwGnQWcPAGBgwh4AwMCEPQBgOj3A4wRq4SVV9cGquraq7n+c1/1gVb1iO/9kZ0rYAwDYOY9Lck6S85O8IMnzj35BVX15kh+ZqiBhDwBg51yW5OXd3Ulek+QRx3jNzyX5N1MVJOwBAOyc85LckiTd/dkk+6vq9rxVVf8wyfVJ3jNVQbZeAQCmM8ZxaQ+tqutWnr2qu69aecXhlWuHu3szSarqnCRPT/KoJN+0+8UuCHsAAKfm2u7+7uNcuzXJwSTvqKo7Jfn0yrVLkjwgyQ1JDiS5e1W9qLufuZvFGsYFANg51yS5fPnz5UnesHWhu/9jd5/X3Q9K8qQkr9/toJfo7AEA7KTXJXlMVb0/yYeTPLGqnpkk3f2idRQk7AEAk6nM88ix7Vquwn3qUU//tZDX3b+b5HcnKMkwLgDAyIQ9AICBCXsAAAMzZw8AmM7c99mbIZ09AICBCXsAAAMT9gAABmbOHgAwmerFY67mWLvOHgDAwIQ9AICBCXsAAAMzZw8AmM7c99mbYe3CHgBnZOO269ddAmdg/7nrroDdZhgXAGBgwh4AwMAM4wIA05n7nL0Z0tkDABiYsAcAMDDDuADAZByXNj2dPQCAgQl7AAADE/YAAAZmzh4AMJ25b70yw9p19gAABibsAQAMTNgDABiYOXsAwGTmvs/eHOnsAQAMTNgDABiYsAcAMDBz9gA4I5cevGjdJXBGbp727eyzNzmdPQCAgQl7AAADE/YAAAZmzh4AMJm577M3x9p19gAABqazB8AZ2bjt+nWXwBnYf+66K2C36ewBAAxMZw8AmM7c99mbIZ09AICBCXsAAAMT9gAABmbOHgBnxNm4c+ds3FMyw9p19gAABibsAQAMzDAuADCZ2R+Xtu4CToPOHgDAwIQ9AICBGcYF4Iw4G3fenI07PmEPAJiOrVcmZxgXAGBgwh4AwMCEPQCAgZmzBwBMprpTPcOJb1tmWLuwB8AZcTbu3E18Ni6TM4wLADAwYQ8AYGCGcQGA6cx9n70Z0tkDABiYsAcAMLBdH8atqn1JfjnJo5J8LMkzknwkyauT3DvJq7v7yuVrn5nkuUkOJfm57n7xyn2eneQz3f2Lx3iPOyf51SSXJHlPku/q7r9YuX5Zkp/o7r+9Kx8S4CzmbNx5czbu+Kbo7D0hyT2TPCDJ9yR5SZKfSfK85XNfVVWPrKr7JLkyyYVZhLZnVdXBqrpHVb04yU+d4D2uSPKB7j4vye8s75MkqaovSfKvktSOfzIA4JRUz/8xN1OEvfsmeXkvvDvJOVmEuau7u5O8Ksmjswh+r+zuj3f3J5K8K8kDk3wmyeuTXH2C97gsycuWP//a8n5b/k2Sn9+5jwMAMB+7Hva6+xe6+zeSpKqeluTjSf58GfSS5LYk9+3ut3b3jy1f93VJvinJO7v7UHdfneSmE7zNeUluWb3f8j4PS3KXJL99vD+sqqdX1XVVdd3n8pnT/JQAAHvTJAs0ququVfXSJM9O8v1JDq9c7iRHVl777Cw6eU/p7o8d5373q6obl48nLO+xdc9OcqSq7pLF8O2PnKi27r6quy/p7kvulDuf5icEANibpligcSDJm5K8MYvh288ludfKSw4m+dDytVcl+YokD+nuW493z+W1B628xzOW93nvyv3+RpLzk/znJHdKcrCqXtPdT9ipzwYAnKK577M3w9qn2FT5iiRv7u7nbD1RVW+vqkcm+b0k35fkx6rqwUkuTvKN3X342Lc6rmuSXJ7Foo8nJ7mmu9+Z5P7L9zs/yStOFvQuuPBQNjasKpsjZ3PC+vjf39w5G3d0U4S9i5M8rKpWF008Nskrsujwvay737acz3d+kndW3b5w9knd/ZZtvMcvJXlFVb0vyTuyWPULAHDW2/Ww193fe5xLFx/1upcmeekJ7vOTJ7j2qSSPP8H1/5bkoSeqEwBgRM7GBQAmM9e96rbMcdNex6UBAAxM2AMAGJhh3BU33XDAqjKAU+Rs3Hmb/GxcW69MTmcPAGBgwh4AwMCEPQCAgZmzBwBMZu5br5izBwDAniLsAQAMTNgDABiYOXsAwHTmvs/eDOnsAQAMTNgDABiYsAcAMDBz9lZccOGhbGw443GOnGkM6+N/f3N386TvNvd99uZYu84eAMDAhD0AgIEJewAAAzNnDwCYTvfiMVczLF1nDwBgYMIeAMDAhD0AgIGZswcATGb2++ytu4DToLMHADAwYQ8AYGDCHgDAwMzZW3HTDQec8QhwijZuc6b4nO0/d+I37Mxyr7rbzbB2nT0AgIEJewAAAzOMCwBMpjaTmuP+JVsM4wIAsJcIewAAAzOMu+KCCw9lY8OqsjmyihrWx//+5u7mdRfALhP2AIBpzXDe2+1mWLthXACAgQl7AAADE/YAAAZmzh4AMJnqxWOu5rhFoLDHEJzNOW9WcwLsHsO4AAADE/YAAAZmGBcAmE734jFXM6xdZw8AYGDCHgDAwAzjMgSrOQHg2HT2AIDJbO2zN9fHyc7GrYWXVNUHq+raqrr/UdefU1XvraqbqupHd/Gf+nbCHgDAznlcknOSnJ/kBUmev3Whqs5P8gNJvm75uKKqztntgoQ9AICdc1mSl3d3J3lNkkesXDuU5B9396eSHEiymeQzu12QsAcAcGoeWlXXrTyevnLtvCS3JEl3fzbJ/qrat/z9T7v796vqh5LcluT3u/svd7tYCzQAgOlsY97bDFzb3d99nGud5PDK74e7e/MOL+j+mar65ST/qaoe3t1v3K1CE2HvDm664YBVnbAGzjaG9dl/7rorGM6tSQ4meUdV3SnJp7cuVNW3JTnY3b/c3R+vqt/JohO4qwzjAgDsnGuSXL78+fIkb1i59qdZLMr4wqo6kMV8vut2uyCdPQCAnfO6JI+pqvcn+XCSJ1bVM5Oku19UVa9P8p4sFmb8Qne/Z7cLEvYAgMncvl/dTJ2s9uUq3Kce9fSLVq4/L8nzdrywEzCMCwAwMGEPAGBghnFXXHDhoWxsWBUIU7MKHtbp5nUXwC4T9gCA6XQvHnM1w9oN4wIADEzYAwAYmGFcAGAys996Zd0FnAadPQCAgensMQSrOQHg2HT2AAAGprMHAEynl4+5mmHtOnsAAAMT9gAABibsAQAMzJy9FTfdcMCqTgDYRXPfZ8+cPQAA9hRhDwBgYMIeAMDAzNkDAKazOfON9mZYus4eAMDAhD0AgIEJewAAAzNnDwCYzsyn7M2xdp09AICBCXsAAAMT9gAABmbO3ooLLjyUjY3r110Gp8GZxgDzMPezcWvdBZwGnT0AgIEJewAAAxP2AAAGZs4eADCd7sVjrmZYu84eAMDAhD0AgIEZxgUAJmPrlenp7AEADEzYAwAYmLAHADAwc/YAgOn08jFXM6xd2GMIG7c503jOnG0MsHsM4wIADEzYAwAYmGFcAGAy1Z2a4ZFjt5th7Tp7AAADE/YAAAZmGHfFTTccsCoQABiKsAcATGdz3QWcoflN2TOMCwAwMmEPAGBgwh4AwMDM2QMAJjP3ffZqhqXr7AEADEzYAwAYmLAHADAwc/YAgOl0ZrlX3Zzp7AEADEzYAwAYmLAHADAwc/YAgOl0Lx5zNcPadfYAAAYm7AEADMwwLgAwmep5Hjm2ZY616+wBAAxM2AMAGJiwBwAwMHP2AIDpzH3rlRme9aazBwAwMGEPAGBgwh4AwMDM2QPgjGzcdv26S+AM7D932verzaSmfcudtbnuAk6dzh4AwMCEPQCAgQl7AAADM2cPAJjO7PfZmx+dPQCAgensAWtnNSfA7tHZAwAYmM4eADCdzhyPl/28GdauswcAMDBhDwBgYMIeAMDAzNkD1u7SgxetuwTOgNXUnIrqTs14n72a4aQ9nT0AgIEJewAAAxP2AAAGZs4eADCduZ+NO8PSdfYAAAYm7AEADMwwLgAwnc11F3CGDOMCALCXCHsAAAMT9gAABmbOHgAwmdkflzbD2nX2AAAGJuwBAAxM2AMAGJg5ewDAdDozPy5tfrXr7AEADEzYAwAYmLAHADAwc/YAgOl0z3Le25zp7AEADEzYAwAYmLAHADAwc/YAgOlsrruAMzTD+oW9FRdceCgbG9evuww461x68KJ1l8AZ8P3N3c3rLoBdZhgXAGBgwh4AwMAM4wIAk6nu1Kz32Ztf7Tp7AAADE/YAAAZmGHfFTTccsKoMABiKsAcATGfuZ+POsHbDuAAAAxP2AAAGJuwBANPZGsad7ePEH68WXlJVH6yqa6vq/kdd/86q+kBVvbeq/uVu/lNvEfYAAHbO45Kck+T8JC9I8vytC1X1BUl+JskjknxNkodV1UN2uyALNIC127jNmdSwLvvPXXcFw7ksycu7u6vqNUl+euXafZL8Xnd/MEmq6i1JHpTkrbtZkM4eAMDOOS/JLUnS3Z9Nsr+q9i1/v627/2GSVNUDkvz9JH+w2wXp7AEA05n71iuLSXsPrarrVp68qruvWnnB4ZVrh7t7c/UOVfUPshjO/afdfdNuVpsIewAAp+ra7v7u41y7NcnBJO+oqjsl+fTqxar6n5N8Z5JHdfeNu1vmgmFcAICdc02Sy5c/X57kDVsXquqcJE9P8oipgl6iswcAsJNel+QxVfX+JB9O8sSqeuby2nuT3DPJW6pq6/U/3t2v2c2Cdj3sLScl/nKSRyX5WJJnJPlIklcnuXeSV3f3lcvXPjPJc5McSvJz3f3ilfs8O8lnuvsXj/Eed07yq0kuSfKeJN/V3X+xHBP/X7L4nL/V3f9k1z4ocNqcST1vVlNzSjrJ5klftXedZLphd3eSpx719ItWfv7SHa7opKYYxn1CFin2AUm+J8lLspiU+Lzlc19VVY+sqvskuTLJhVmEtmdV1cGqukdVvTjJT53gPa5I8oHuPi/J7yS5sqq+KMm/SvJ3knx1kkuq6pJd+YQAAHvUFGHvvlnuN9Pd785io8FLkly9TL+vSvLoLILfK7v74939iSTvSvLAJJ9J8vokV5/gPS5L8rLlz7+2vN++JP+4u/8syV2Wj7/c4c8GALCn7XrY6+5f6O7fSJKqelqSjyf582XQS5Lbkty3u9/a3T+2fN3XJfmmJO/s7kPdfXWSEy1Nvn1Pm5X7fbK737Acyv3vWQS99+3spwMA2NsmWY1bVXetqpcmeXaS788d95/pJEdWXvvsLDp5T+nujx3nfverqhuXjyfkjnva3OF+3f2KJPdK8okk33eMez29qq6rqus+l8+cyccEAE6iumf/mJspFmgcSPKmJG/MYvj2c1mEry0Hk3xo+dqrknxFkod0963Hu+fy2oNW3uMZy/u8d+t+VfX1Sb6tu/9Vd3+qql6fRQfw6HtdleSqJPnSuuf8vkEAgBOYorN3RZI3d/dzuvvT3X0kyduXizL2Z9Ftu6aqHpzk4iwC2nGD3nGs7mnz5OXvH0nyj6rq7suDh78tExxJAgCwl0yxz97FSR5WVY9eee6xSbaGV1/W3W9bzuc7P8k7V/aeeVJ3v2Ub7/FLSV5RVe9L8o4k37Ps5v3bJNdl0U38je7+f3bkEwEAzMSuh73u/t7jXLr4qNe9NMlLT3CfnzzBtU8lefwxnv+lLIIgALAXdOekm9XtZTMs3XFpAAADE/YAAAYm7AEADGyKBRoAJ+RsVTiLbHZSM5z4tmWG++zp7AEADEzYAwAYmLAHADAwc/YAgOnMfp+9+dWuswcAMDCdvRUXXHgoGxtWBc7RpQcvWncJnAHfH6zTzesugF0m7AEA05n7MO4MGcYFABiYsAcAMDBhDwBgYObsAQDTmfucvRluvSLsrbjphgNWBQKcImcbz9v+c9ddAbvNMC4AwMCEPQCAgRnGBQCms9lJzW/e2+1mWLrOHgDAwIQ9AICBGcYF1s5qToDdI+wBANPpzSS17ipOX2+uu4JTZhgXAGBgwh4AwMCEPQCAgZmzBwBMZ/Zn4667gFMn7K244MJD2diwKnCOnGk8b74/WKeb110Au8wwLgDAwIQ9AICBGcYFAKYz+7Nx51e7zh4AwMCEPQCAgRnGXXHTDQesCoQ1cDYurM/+c9ddAbtN2AMApjP3ffZmWLthXACAgQl7AAADE/YAAAZmzh4AMJ25z9mbYek6ewAAAxP2AAAGZhgXAJjO7Idx51e7zh4AwMCEPQCAgQl7AAADM2dvxQUXHsrGhjM6YWrOpIZ1unnat9vcTKqmfc+dZM4eAAB7ibAHADAwYQ8AYGDm7AEA07HP3uR09gAABqazxxCs5gSAY9PZAwAYmM4eADCduc/Zm2HtOnsAAAMT9gAABibsAQAMzJw9hrBxmzON58xqajiLbHZS85v3drvNdRdw6nT2AAAGJuwBAAxM2AMAGJg5ewDAZLo306l1l3Ha2j57AADsJcIeAMDAhD0AgIGZswcATGf2++zNr3adPQCAgQl7AAADM4wLAEynO5nh9iWfN7/ahT2G4GxVADg2w7gAAAMT9gAABmYYFwCYzuZmUvM9Lm0x53BedPYAAAYm7AEADEzYAwAYmDl7AMB05r7Pnjl7AADsJcIeAMDAhD0AgIGZswcATKY3N9P22ZuUsLfiphsOOGMVABiKYVwAgIEJewAAAzOMCwBMxz57k9PZAwAYmLAHADAww7grLrjwUDY2rl93GZwGq6gB4NiEPQBgOpud1Pzmvd1uhqUbxgUAGJiwBwAwMGEPAGBg5uwBANPpzSRzPht3c90VnDJhb4WzcQGA0RjGBQAYmM4eADCZ3uz0jLdemeFpaTp7AAAjE/YAAAYm7AEADMycPQBgOrZemZzOHgDAwIQ9AICBCXsAAAMzZw8AmIx99qanswcAMDBhDwBgYMIeAMDAhD0AYDrdi73qZvs48aS9WnhJVX2wqq6tqvsf4zV3qqrrd+3f+CjCHgDAznlcknOSnJ/kBUmev3qxqv5+kt9N8mVTFSTsAQDsnMuSvLy7O8lrkjziqOs3J/nXUxZk6xUAYCof+1Q+mbvmS9Zdx2n7VD6ZJBdW1XUrT1/V3Vctfz4vyS1J0t2frar9VbWve3HOWne/Pcnbq6Y7Mk7YA+CMbNw22dQjdsH+cyd9uxf8t9x42dfkIZO+6U453Ifzp4sc94zu/tRxXtZJDt/hz3q9B+oaxgUApvLbn8onc6j/at11nJZb8r4czPk5QdBLkluTHEwWCzGSfHqS4k5A2AMAJtHd/RX56nwgN667lFN2uA/nj/Oh3JTrD5zkpdckuXz58+VJ3rC7lZ2csAcATOa/5k375tjd22ZXL0lel+RzVfX+JP8oyT+vqmdW1TN3v8pjM2cPAJhMd/eD62H5QG7MXObubXX1PpG/OFlXL8tVuE896ukXHeN1992p+k5GZw8AmNTcunun0NXbk4Q9AGBSc5q7dwpz9fYsYQ8AmNxcuntz7+olwh4AsAZz6O6N0NVLhD0AYE32endvhK5eIuwBAGuyl7t7o3T1EmEPAFijvdrdG6Wrl9hnD4AzdOnBi9ZdAmfk5rW++17cd+9U9tWbA509AGCt9lp3b6SuXiLsAQBrtpfm7o00V2+LsAcArN1e6e6N1tVLhD0AYA/YC929Ebt6ibAHAOwR6+7ujdjVS6zGBeAMbdx2/bpL4AzsP3fdFXzeOlfmjrYCd5XOHgCwZ6yruzdqVy8R9gCAPWQdc/dGnau3RdgDAPaUqbt7I3f1EmEPANhjpuzujd7VS4Q9AGAPmqq7N3pXL7EaF9gDrOYEjjbFytyRV+Cu0tkDAPak3e7unQ1dvUTYAwD2qN2cu3c2zNXbIuwBAHvWbnX3zpauXiLsAQB72G50986mrl4i7AEAe9xOd/fOpq5eYjXuHVxw4aFsbFgVCFO79OBF6y4BzmI3r7uAk9rJlblnywrcVTp7AMCet1PdvbOtq5cIewDADOzE3L2zba7eFmEPAJiFM+3unY1dvUTYAwBm4ky6e2drVy8R9gCAGTnd7t7Z2tVLrMa9g5tuOGBVIMApcrbxvO0/d90VnJrTWZl7Nq7AXaWzBwDMyql2987mrl4i7AEAM3Mqc/fO5rl6W4Q9AGB2ttvdO9u7eomwBwDM0Ha6e7p6C8IeADBLJ+vu6eotWI0LwBmxi8Hc7f2zcY/nRCtzz/YVuKt09gCA2Tped09X7/OEPQBgto41d89cvTsS9gCAWTu6u6erd0fCHgAwa6vdPV29v07YAwBmb6u7d1Ou19U7irAHAMzeVnfvz/LHunpHqe5edw17RlX9VZL3rruOXXTvJB9ddxG7yOebt5E/38ifLfH55u6ruvtL1l0Eu8c+e3f03u6+ZN1F7Jaqus7nmy+fb75G/myJzzd3VXXdumtgdxnGBQAYmLAHADAwYe+Orlp3AbvM55s3n2++Rv5sic83d6N/vrOeBRoAAAPT2QMAGNhZGfZq4SVV9cGquraq7n/U9R+tqpur6sbl4yvWVeuZqKrHV9X/eoznv72q3ldV76+qy9dR2044weeb7fdXVfuq6leq6kNVdX1VffNR12f93W3j8832u0uSqvqSqvrNqnpvVf1hVV181PXZfn/b+Gyz/u62LP87em1V/f+Oen62392qE3y+Ib4/ju1s3XrlcUnOSXJ+ku9K8vwk379y/UFJLu3u909f2pmrqkrys0kuT/IrR137wiQvSPLwJJ9Icl1Vva67Pzl5oafpRJ9vac7f3xOS3DPJA5J8dZJXJLkwGeO7ywk+39Kcv7skuTLJtd392Kq6LMk/T/KYZIjv77ifbWnu392WZyf5ytUnBvjuVv21z7c0yvfHMZytYe+yJC/v7q6q1yT56aOuf3mSW6cva0f99nGevzjJO7r7liSpqjcn+ZYkG1MVtkOO9/mSeX9/983yv5tJ3l1V51RVLX8f4bs70edL5v3dJcn/k2Tr/7G8e5K/WLk29+/vRJ8tmf93l2U36+8mufqoS3P/7pKc8PMlA3x/HN9ZOYyb5LwktyRJd382yf6qWv23+LIkr6+qd1fV89ZR4JnohauTXH+My7d/9qXbsvh/gGfjJJ8vmfH3192/0N2/kSRV9bQkN68EoRG+uxN9vmTG312SdPfvd/efVNV/TfJ/Jnn5yuVZf38n+WzJzL+7pZ9P8pwkR69cnPV3t+J4ny8Z4/vjOM7WsNdJDq/8fri7N1d+/60kT0rykCQPq6q/N2Ftu+3oz95Jjqyplt0y6++vqu5aVS/NYrjlySuXhvjuTvD5kpl/d1u6++uTPDLJS1afzgDf33E+WzLz766q/lGSP+juYx2ZOfvv7iSfL5n598eJna1h79YkB5Okqu6U5NNbF6pqf5Lndfety/kYv57ka9dS5e64/bMvHUzyoTXVsuPm/v1V1YEkb8piXtAlR82fmf13d6LPN/fvLkmq6gW1XPDV3W9McpflHNNk5t/fiT7bCN9dkkck+YdVdWMWc0tfWlWPWl6b9Xe39Igc5/MN8v1xAmdr2Lsmi8n9Wf7nG1aufVmSd1TVly7/B/DtSf5g4vp20x8k+fqqundV3SeL/1/ctWuuaSfN/fu7Ismbu/s53f3po66N8N2d6PPN/btLkv1ZLPpKVf3tJP9tZZh67t/fiT7b7L+77n5Sd1/Q3Q9K8pokT+vurbnBc//uTvb5Zv/9cWJn6wKN1yV5TFW9P8mHkzyxqp6ZJN39oqp6YZK3J/lUkt/o7jcc70ZzcdTne26S/5zF//F+znLe4qwN9P1dnMUQyqNXnntRMsx3d7LP98LM97tLFiv7/0NVXZHko0meNtD/9k722V6YeX93f81A390xjf798XlO0AAAGNjZOowLAHBWEPYAAAYm7AEADEzYAwAYmLAHADAwYQ/Ys6rqd6vqH6y7DoA5O1v32QP2sOXJDHXSFx7n7446/hDgrKazB5yRqvqHVfWRqvpoVf1IVX26qn6yqn5x5TW3/15V51TVf6yqT1TVH1fV81de11V1ZZKPJ3lpkocn+b+q6ruqan9V/evle91WVf/kOH93n2k+OcA86OwBp62qviLJ/57F8UrvS/LL2/iz5yb5kyT3TnK/JG+tqld09zuW178+yf26+xNV9cAkv9jdr6yqH07y4CzO7Dw3yW9V1fXLc1rv8Hc79fkARiDsAWfiH2RxtNLvJ0lV/USSv3uSv3lJko8luVOSuyX5bJJ7rVx//nEC21OSPKm7/yzJn1XV/z/J30vyxpP8HcBZTdgDzsR5ST648vufHOd1q1NGLkjywiSHk1yfvz437+PHuccDkrxpMS0vWf7dr2/j7wDOasIecCY+muS+K7/ff/mfm7ljwFudR/fLSZ7S3b+VJFX1kW2+158m+bbufs/y7+4f844BTsr/oQTOxG8m+a6q+ptV9SVJ/uny+VuSPLiq9lXVOUket/I3X5DkQFXdraqem0UQvPNx7n84i7l9SfLKJD9WVV9cVRck+e0kF+7w5wEYjrAHnLbufkuSf5bkDUk+kOTty0u/msXw7nuzGGq9euXPnpXFvL0/SnIgyb9N8u+P8xavT/IzVfUdSX4yi/l9H8pint7Luvvq4/wdAEvV3euuARhEVZ2f5Mbuvsu6awFgQWcPAGBgwh4AwMAM4wIADExnDwBgYMIeAMDAhD0AgIEJewAAAxP2AAAGJuwBAAzs/wNCK+HUj+D0OwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 720x1440 with 2 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "da = df.groupby(['utdate','quarter'])['kpfcc'].first().to_xarray()\n",
    "da.coords['utdate'] = Time(list(array(da.utdate))).datetime\n",
    "da.sortby(da.utdate,ascending=False).plot.pcolormesh(figsize=(10,20),vmin=0.1,vmax=0.9)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 315,
   "id": "nonprofit-sharp",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv('2021A-schedule.csv')\n",
    "sched_cj_night = df.copy()\n",
    "def shorten_name(s):\n",
    "    names = s.split(' ')\n",
    "    nnames = len(names)\n",
    "    if nnames > 1:\n",
    "        _out = \" \".join([n[0] for n in names[:-1]] + [names[-1]])\n",
    "    return _out\n",
    "\n",
    "df['PIlast'] = df.PI.apply(lambda x : x.split(' ')[-1] )\n",
    "dates = df.Date.drop_duplicates()\n",
    "nnights = len(dates)\n",
    "df['night_percent'] = df.Time.str.slice(start=-5,stop=-2).astype(int)\n",
    "\n",
    "#df['PIlastnmae'] = df['PI'].\n",
    "df['numq'] = (df.night_percent * 4/100).round()\n",
    "df2 = []\n",
    "for i, row in df.iterrows():\n",
    "    for i in range(int(row.numq)):\n",
    "        df2.append(row)\n",
    "df2 = pd.concat(df2,axis=1).T\n",
    "df = df2.reset_index() \n",
    "df['quarter'] = hstack([arange(1,5)]*nnights)\n",
    "assert len(df.groupby('Date')['quarter'].nunique().drop_duplicates())==1, False\n",
    "df = pd.merge(df,calendar['Date quarter dark'.split()]) # merge in dark info\n",
    "sched_cj = df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 316,
   "id": "processed-geometry",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>Date</th>\n",
       "      <th>Time</th>\n",
       "      <th>Dark</th>\n",
       "      <th>TelNr</th>\n",
       "      <th>Instrument</th>\n",
       "      <th>Account</th>\n",
       "      <th>PI</th>\n",
       "      <th>Institution</th>\n",
       "      <th>ProjCode</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>PIlast</th>\n",
       "      <th>night_percent</th>\n",
       "      <th>numq</th>\n",
       "      <th>quarter</th>\n",
       "      <th>dark</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2021-02-01</td>\n",
       "      <td>05:03 - 16:08 (100%)</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-LGS</td>\n",
       "      <td>osiris6</td>\n",
       "      <td>George Djorgovski</td>\n",
       "      <td>CIT</td>\n",
       "      <td>C311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Djorgovski</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>2021-02-01</td>\n",
       "      <td>05:03 - 16:08 (100%)</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-LGS</td>\n",
       "      <td>osiris6</td>\n",
       "      <td>George Djorgovski</td>\n",
       "      <td>CIT</td>\n",
       "      <td>C311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Djorgovski</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>2021-02-01</td>\n",
       "      <td>05:03 - 16:08 (100%)</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-LGS</td>\n",
       "      <td>osiris6</td>\n",
       "      <td>George Djorgovski</td>\n",
       "      <td>CIT</td>\n",
       "      <td>C311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Djorgovski</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>2021-02-01</td>\n",
       "      <td>05:03 - 16:08 (100%)</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-LGS</td>\n",
       "      <td>osiris6</td>\n",
       "      <td>George Djorgovski</td>\n",
       "      <td>CIT</td>\n",
       "      <td>C311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Djorgovski</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>2021-02-02</td>\n",
       "      <td>05:04 - 10:36 ( 50%)</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-NGS</td>\n",
       "      <td>osiris7</td>\n",
       "      <td>Michihiro Takami</td>\n",
       "      <td>Subaru</td>\n",
       "      <td>S364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Takami</td>\n",
       "      <td>50</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>2021-02-02</td>\n",
       "      <td>05:04 - 10:36 ( 50%)</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-NGS</td>\n",
       "      <td>osiris7</td>\n",
       "      <td>Michihiro Takami</td>\n",
       "      <td>Subaru</td>\n",
       "      <td>S364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Takami</td>\n",
       "      <td>50</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2</td>\n",
       "      <td>2021-02-02</td>\n",
       "      <td>10:36 - 16:08 ( 50%)</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-LGS</td>\n",
       "      <td>osiris7</td>\n",
       "      <td>Duncan Farrah</td>\n",
       "      <td>UH</td>\n",
       "      <td>H319</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Farrah</td>\n",
       "      <td>50</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>2021-02-02</td>\n",
       "      <td>10:36 - 16:08 ( 50%)</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-LGS</td>\n",
       "      <td>osiris7</td>\n",
       "      <td>Duncan Farrah</td>\n",
       "      <td>UH</td>\n",
       "      <td>H319</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Farrah</td>\n",
       "      <td>50</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3</td>\n",
       "      <td>2021-02-03</td>\n",
       "      <td>05:04 - 10:36 ( 50%)</td>\n",
       "      <td>46</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-NGS</td>\n",
       "      <td>osiris7</td>\n",
       "      <td>Michihiro Takami</td>\n",
       "      <td>Subaru</td>\n",
       "      <td>S364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Takami</td>\n",
       "      <td>50</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3</td>\n",
       "      <td>2021-02-03</td>\n",
       "      <td>05:04 - 10:36 ( 50%)</td>\n",
       "      <td>46</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-NGS</td>\n",
       "      <td>osiris7</td>\n",
       "      <td>Michihiro Takami</td>\n",
       "      <td>Subaru</td>\n",
       "      <td>S364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Takami</td>\n",
       "      <td>50</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>4</td>\n",
       "      <td>2021-02-03</td>\n",
       "      <td>10:36 - 16:07 ( 50%)</td>\n",
       "      <td>46</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-LGS</td>\n",
       "      <td>osiris7</td>\n",
       "      <td>Duncan Farrah</td>\n",
       "      <td>UH</td>\n",
       "      <td>H319</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Farrah</td>\n",
       "      <td>50</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>4</td>\n",
       "      <td>2021-02-03</td>\n",
       "      <td>10:36 - 16:07 ( 50%)</td>\n",
       "      <td>46</td>\n",
       "      <td>1</td>\n",
       "      <td>OSIRIS-LGS</td>\n",
       "      <td>osiris7</td>\n",
       "      <td>Duncan Farrah</td>\n",
       "      <td>UH</td>\n",
       "      <td>H319</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Farrah</td>\n",
       "      <td>50</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5</td>\n",
       "      <td>2021-02-04</td>\n",
       "      <td>05:05 - 16:07 (100%)</td>\n",
       "      <td>55</td>\n",
       "      <td>1</td>\n",
       "      <td>MOSFIRE</td>\n",
       "      <td>mosfire4</td>\n",
       "      <td>Themiya Nanayakkara</td>\n",
       "      <td>Swinburne</td>\n",
       "      <td>W242</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nanayakkara</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5</td>\n",
       "      <td>2021-02-04</td>\n",
       "      <td>05:05 - 16:07 (100%)</td>\n",
       "      <td>55</td>\n",
       "      <td>1</td>\n",
       "      <td>MOSFIRE</td>\n",
       "      <td>mosfire4</td>\n",
       "      <td>Themiya Nanayakkara</td>\n",
       "      <td>Swinburne</td>\n",
       "      <td>W242</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nanayakkara</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5</td>\n",
       "      <td>2021-02-04</td>\n",
       "      <td>05:05 - 16:07 (100%)</td>\n",
       "      <td>55</td>\n",
       "      <td>1</td>\n",
       "      <td>MOSFIRE</td>\n",
       "      <td>mosfire4</td>\n",
       "      <td>Themiya Nanayakkara</td>\n",
       "      <td>Swinburne</td>\n",
       "      <td>W242</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nanayakkara</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5</td>\n",
       "      <td>2021-02-04</td>\n",
       "      <td>05:05 - 16:07 (100%)</td>\n",
       "      <td>55</td>\n",
       "      <td>1</td>\n",
       "      <td>MOSFIRE</td>\n",
       "      <td>mosfire4</td>\n",
       "      <td>Themiya Nanayakkara</td>\n",
       "      <td>Swinburne</td>\n",
       "      <td>W242</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nanayakkara</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>6</td>\n",
       "      <td>2021-02-05</td>\n",
       "      <td>05:05 - 16:07 (100%)</td>\n",
       "      <td>64</td>\n",
       "      <td>1</td>\n",
       "      <td>MOSFIRE</td>\n",
       "      <td>mosfire5</td>\n",
       "      <td>Patrick Kelly</td>\n",
       "      <td>NASA</td>\n",
       "      <td>N201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kelly</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>6</td>\n",
       "      <td>2021-02-05</td>\n",
       "      <td>05:05 - 16:07 (100%)</td>\n",
       "      <td>64</td>\n",
       "      <td>1</td>\n",
       "      <td>MOSFIRE</td>\n",
       "      <td>mosfire5</td>\n",
       "      <td>Patrick Kelly</td>\n",
       "      <td>NASA</td>\n",
       "      <td>N201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kelly</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>6</td>\n",
       "      <td>2021-02-05</td>\n",
       "      <td>05:05 - 16:07 (100%)</td>\n",
       "      <td>64</td>\n",
       "      <td>1</td>\n",
       "      <td>MOSFIRE</td>\n",
       "      <td>mosfire5</td>\n",
       "      <td>Patrick Kelly</td>\n",
       "      <td>NASA</td>\n",
       "      <td>N201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kelly</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>6</td>\n",
       "      <td>2021-02-05</td>\n",
       "      <td>05:05 - 16:07 (100%)</td>\n",
       "      <td>64</td>\n",
       "      <td>1</td>\n",
       "      <td>MOSFIRE</td>\n",
       "      <td>mosfire5</td>\n",
       "      <td>Patrick Kelly</td>\n",
       "      <td>NASA</td>\n",
       "      <td>N201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kelly</td>\n",
       "      <td>100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index        Date                  Time Dark TelNr  Instrument   Account  \\\n",
       "0       0  2021-02-01  05:03 - 16:08 (100%)   28     1  OSIRIS-LGS   osiris6   \n",
       "1       0  2021-02-01  05:03 - 16:08 (100%)   28     1  OSIRIS-LGS   osiris6   \n",
       "2       0  2021-02-01  05:03 - 16:08 (100%)   28     1  OSIRIS-LGS   osiris6   \n",
       "3       0  2021-02-01  05:03 - 16:08 (100%)   28     1  OSIRIS-LGS   osiris6   \n",
       "4       1  2021-02-02  05:04 - 10:36 ( 50%)   37     1  OSIRIS-NGS   osiris7   \n",
       "5       1  2021-02-02  05:04 - 10:36 ( 50%)   37     1  OSIRIS-NGS   osiris7   \n",
       "6       2  2021-02-02  10:36 - 16:08 ( 50%)   37     1  OSIRIS-LGS   osiris7   \n",
       "7       2  2021-02-02  10:36 - 16:08 ( 50%)   37     1  OSIRIS-LGS   osiris7   \n",
       "8       3  2021-02-03  05:04 - 10:36 ( 50%)   46     1  OSIRIS-NGS   osiris7   \n",
       "9       3  2021-02-03  05:04 - 10:36 ( 50%)   46     1  OSIRIS-NGS   osiris7   \n",
       "10      4  2021-02-03  10:36 - 16:07 ( 50%)   46     1  OSIRIS-LGS   osiris7   \n",
       "11      4  2021-02-03  10:36 - 16:07 ( 50%)   46     1  OSIRIS-LGS   osiris7   \n",
       "12      5  2021-02-04  05:05 - 16:07 (100%)   55     1     MOSFIRE  mosfire4   \n",
       "13      5  2021-02-04  05:05 - 16:07 (100%)   55     1     MOSFIRE  mosfire4   \n",
       "14      5  2021-02-04  05:05 - 16:07 (100%)   55     1     MOSFIRE  mosfire4   \n",
       "15      5  2021-02-04  05:05 - 16:07 (100%)   55     1     MOSFIRE  mosfire4   \n",
       "16      6  2021-02-05  05:05 - 16:07 (100%)   64     1     MOSFIRE  mosfire5   \n",
       "17      6  2021-02-05  05:05 - 16:07 (100%)   64     1     MOSFIRE  mosfire5   \n",
       "18      6  2021-02-05  05:05 - 16:07 (100%)   64     1     MOSFIRE  mosfire5   \n",
       "19      6  2021-02-05  05:05 - 16:07 (100%)   64     1     MOSFIRE  mosfire5   \n",
       "\n",
       "                     PI Institution ProjCode Unnamed: 9       PIlast  \\\n",
       "0     George Djorgovski         CIT     C311        NaN   Djorgovski   \n",
       "1     George Djorgovski         CIT     C311        NaN   Djorgovski   \n",
       "2     George Djorgovski         CIT     C311        NaN   Djorgovski   \n",
       "3     George Djorgovski         CIT     C311        NaN   Djorgovski   \n",
       "4      Michihiro Takami      Subaru     S364        NaN       Takami   \n",
       "5      Michihiro Takami      Subaru     S364        NaN       Takami   \n",
       "6         Duncan Farrah          UH     H319        NaN       Farrah   \n",
       "7         Duncan Farrah          UH     H319        NaN       Farrah   \n",
       "8      Michihiro Takami      Subaru     S364        NaN       Takami   \n",
       "9      Michihiro Takami      Subaru     S364        NaN       Takami   \n",
       "10        Duncan Farrah          UH     H319        NaN       Farrah   \n",
       "11        Duncan Farrah          UH     H319        NaN       Farrah   \n",
       "12  Themiya Nanayakkara   Swinburne     W242        NaN  Nanayakkara   \n",
       "13  Themiya Nanayakkara   Swinburne     W242        NaN  Nanayakkara   \n",
       "14  Themiya Nanayakkara   Swinburne     W242        NaN  Nanayakkara   \n",
       "15  Themiya Nanayakkara   Swinburne     W242        NaN  Nanayakkara   \n",
       "16        Patrick Kelly        NASA     N201        NaN        Kelly   \n",
       "17        Patrick Kelly        NASA     N201        NaN        Kelly   \n",
       "18        Patrick Kelly        NASA     N201        NaN        Kelly   \n",
       "19        Patrick Kelly        NASA     N201        NaN        Kelly   \n",
       "\n",
       "   night_percent numq  quarter   dark  \n",
       "0            100  4.0        1   True  \n",
       "1            100  4.0        2  False  \n",
       "2            100  4.0        3  False  \n",
       "3            100  4.0        4  False  \n",
       "4             50  2.0        1   True  \n",
       "5             50  2.0        2  False  \n",
       "6             50  2.0        3  False  \n",
       "7             50  2.0        4  False  \n",
       "8             50  2.0        1   True  \n",
       "9             50  2.0        2  False  \n",
       "10            50  2.0        3  False  \n",
       "11            50  2.0        4  False  \n",
       "12           100  4.0        1   True  \n",
       "13           100  4.0        2   True  \n",
       "14           100  4.0        3  False  \n",
       "15           100  4.0        4  False  \n",
       "16           100  4.0        1   True  \n",
       "17           100  4.0        2   True  \n",
       "18           100  4.0        3  False  \n",
       "19           100  4.0        4  False  "
      ]
     },
     "execution_count": 316,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sched_cj.head(20)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 317,
   "id": "looking-composer",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Djorgovski, OSIRIS-LGS, C311, date=2021-02-01, dark=1, q=1\n",
      "Djorgovski, OSIRIS-LGS, C311, date=2021-02-01, dark=0, q=2\n",
      "Djorgovski, OSIRIS-LGS, C311, date=2021-02-01, dark=0, q=3\n",
      "Djorgovski, OSIRIS-LGS, C311, date=2021-02-01, dark=0, q=4\n",
      "Takami, OSIRIS-NGS, S364, date=2021-02-02, dark=1, q=1\n",
      "Takami, OSIRIS-NGS, S364, date=2021-02-02, dark=0, q=2\n",
      "Farrah, OSIRIS-LGS, H319, date=2021-02-02, dark=0, q=3\n",
      "Farrah, OSIRIS-LGS, H319, date=2021-02-02, dark=0, q=4\n",
      "Takami, OSIRIS-NGS, S364, date=2021-02-03, dark=1, q=1\n",
      "Takami, OSIRIS-NGS, S364, date=2021-02-03, dark=0, q=2\n",
      "Farrah, OSIRIS-LGS, H319, date=2021-02-03, dark=0, q=3\n",
      "Farrah, OSIRIS-LGS, H319, date=2021-02-03, dark=0, q=4\n",
      "Nanayakkara, MOSFIRE, W242, date=2021-02-04, dark=1, q=1\n",
      "Nanayakkara, MOSFIRE, W242, date=2021-02-04, dark=1, q=2\n",
      "Nanayakkara, MOSFIRE, W242, date=2021-02-04, dark=0, q=3\n",
      "Nanayakkara, MOSFIRE, W242, date=2021-02-04, dark=0, q=4\n",
      "Kelly, MOSFIRE, N201, date=2021-02-05, dark=1, q=1\n",
      "Kelly, MOSFIRE, N201, date=2021-02-05, dark=1, q=2\n",
      "Kelly, MOSFIRE, N201, date=2021-02-05, dark=0, q=3\n",
      "Kelly, MOSFIRE, N201, date=2021-02-05, dark=0, q=4\n",
      "Wilson, MOSFIRE, U008, date=2021-02-06, dark=1, q=1\n",
      "Wilson, MOSFIRE, U008, date=2021-02-06, dark=1, q=2\n",
      "Wilson, MOSFIRE, U008, date=2021-02-06, dark=1, q=3\n",
      "Wilson, MOSFIRE, U008, date=2021-02-06, dark=0, q=4\n",
      "Wilson, MOSFIRE, U008, date=2021-02-07, dark=1, q=1\n",
      "Wilson, MOSFIRE, U008, date=2021-02-07, dark=1, q=2\n",
      "Wilson, MOSFIRE, U008, date=2021-02-07, dark=1, q=3\n",
      "Wilson, MOSFIRE, U008, date=2021-02-07, dark=0, q=4\n",
      "Wilson, MOSFIRE, U008, date=2021-02-08, dark=1, q=1\n",
      "Wilson, MOSFIRE, U008, date=2021-02-08, dark=1, q=2\n",
      "Wilson, MOSFIRE, U008, date=2021-02-08, dark=1, q=3\n",
      "Wilson, MOSFIRE, U008, date=2021-02-08, dark=0, q=4\n",
      "Nierenberg, OSIRIS-LGS, U129, date=2021-02-09, dark=1, q=1\n",
      "Nierenberg, OSIRIS-LGS, U129, date=2021-02-09, dark=1, q=2\n",
      "Nierenberg, OSIRIS-LGS, U129, date=2021-02-09, dark=1, q=3\n",
      "Nierenberg, OSIRIS-LGS, U129, date=2021-02-09, dark=1, q=4\n",
      "Gaidos, OSIRIS-LGS, H246, date=2021-02-10, dark=1, q=1\n",
      "Gaidos, OSIRIS-LGS, H246, date=2021-02-10, dark=1, q=2\n",
      "Yan, LRIS-ADC, C251, date=2021-02-10, dark=1, q=3\n",
      "Yan, LRIS-ADC, C251, date=2021-02-10, dark=1, q=4\n",
      "Roestel, LRIS-ADC, C229, date=2021-02-11, dark=1, q=1\n",
      "Roestel, LRIS-ADC, C229, date=2021-02-11, dark=1, q=2\n",
      "Foley, LRIS-ADC, U089, date=2021-02-11, dark=1, q=3\n",
      "Foley, LRIS-ADC, U089, date=2021-02-11, dark=1, q=4\n",
      "Masters, LRIS-ADC, N238, date=2021-02-12, dark=0, q=1\n",
      "Masters, LRIS-ADC, N238, date=2021-02-12, dark=1, q=2\n",
      "Masters, LRIS-ADC, N238, date=2021-02-12, dark=1, q=3\n",
      "Masters, LRIS-ADC, N238, date=2021-02-12, dark=1, q=4\n",
      "Hallinan, LRIS-ADC, C302, date=2021-02-13, dark=0, q=1\n",
      "Hallinan, LRIS-ADC, C302, date=2021-02-13, dark=1, q=2\n",
      "Hallinan, LRIS-ADC, C302, date=2021-02-13, dark=1, q=3\n",
      "Hallinan, LRIS-ADC, C302, date=2021-02-13, dark=1, q=4\n",
      "Prince, LRIS-ADC, C308, date=2021-02-14, dark=0, q=1\n",
      "Prince, LRIS-ADC, C308, date=2021-02-14, dark=1, q=2\n",
      "Prince, LRIS-ADC, C308, date=2021-02-14, dark=1, q=3\n",
      "Prince, LRIS-ADC, C308, date=2021-02-14, dark=1, q=4\n",
      "Ravi, LRIS-ADC, C310, date=2021-02-15, dark=0, q=1\n",
      "Ravi, LRIS-ADC, C310, date=2021-02-15, dark=0, q=2\n",
      "Ravi, LRIS-ADC, C310, date=2021-02-15, dark=1, q=3\n",
      "Ravi, LRIS-ADC, C310, date=2021-02-15, dark=1, q=4\n",
      "Graham, LRIS-ADC, C275, date=2021-02-16, dark=0, q=1\n",
      "Graham, LRIS-ADC, C275, date=2021-02-16, dark=0, q=2\n",
      "Fremling, LRIS-ADC, C287, date=2021-02-16, dark=1, q=3\n",
      "Fremling, LRIS-ADC, C287, date=2021-02-16, dark=1, q=4\n",
      "Harikane, MOSFIRE, S365, date=2021-02-17, dark=0, q=1\n",
      "Harikane, MOSFIRE, S365, date=2021-02-17, dark=0, q=2\n",
      "Harikane, MOSFIRE, S365, date=2021-02-17, dark=1, q=3\n",
      "Harikane, MOSFIRE, S365, date=2021-02-17, dark=1, q=4\n",
      "Ebeling, MOSFIRE, H352, date=2021-02-18, dark=0, q=1\n",
      "Ebeling, MOSFIRE, H352, date=2021-02-18, dark=0, q=2\n",
      "Ebeling, MOSFIRE, H352, date=2021-02-18, dark=1, q=3\n",
      "Ebeling, MOSFIRE, H352, date=2021-02-18, dark=1, q=4\n",
      "Inami, MOSFIRE, S363, date=2021-02-19, dark=0, q=1\n",
      "Inami, MOSFIRE, S363, date=2021-02-19, dark=0, q=2\n",
      "Inami, MOSFIRE, S363, date=2021-02-19, dark=0, q=3\n",
      "Inami, MOSFIRE, S363, date=2021-02-19, dark=1, q=4\n",
      "Inami, MOSFIRE, S363, date=2021-02-20, dark=0, q=1\n",
      "Inami, MOSFIRE, S363, date=2021-02-20, dark=0, q=2\n",
      "Inami, MOSFIRE, S363, date=2021-02-20, dark=0, q=3\n",
      "Inami, MOSFIRE, S363, date=2021-02-20, dark=1, q=4\n",
      "Rice, HIRESr, Y333, date=2021-02-21, dark=0, q=1\n",
      "Rice, HIRESr, Y333, date=2021-02-21, dark=0, q=2\n",
      "Rice, HIRESr, Y333, date=2021-02-21, dark=0, q=3\n",
      "Rice, HIRESr, Y333, date=2021-02-21, dark=1, q=4\n",
      "Batalha, HIRESr, U111, date=2021-02-22, dark=0, q=1\n",
      "Batalha, HIRESr, U111, date=2021-02-22, dark=0, q=2\n",
      "Batalha, HIRESr, U111, date=2021-02-22, dark=0, q=3\n",
      "Batalha, HIRESr, U111, date=2021-02-22, dark=0, q=4\n",
      "Rice, HIRESr, Y333, date=2021-02-23, dark=0, q=1\n",
      "Rice, HIRESr, Y333, date=2021-02-23, dark=0, q=2\n",
      "Rice, HIRESr, Y333, date=2021-02-23, dark=0, q=3\n",
      "Rice, HIRESr, Y333, date=2021-02-23, dark=0, q=4\n",
      "Shapley, MOSFIRE, U073, date=2021-02-24, dark=0, q=1\n",
      "Shapley, MOSFIRE, U073, date=2021-02-24, dark=0, q=2\n",
      "Shapley, MOSFIRE, U073, date=2021-02-24, dark=0, q=3\n",
      "Shapley, MOSFIRE, U073, date=2021-02-24, dark=0, q=4\n",
      "Crossfield, HIRESr, N180, date=2021-02-25, dark=0, q=1\n",
      "Crossfield, HIRESr, N180, date=2021-02-25, dark=0, q=2\n",
      "Crossfield, HIRESr, N180, date=2021-02-25, dark=0, q=3\n",
      "Crossfield, HIRESr, N180, date=2021-02-25, dark=0, q=4\n",
      "Engineering, PCS, E377, date=2021-02-26, dark=0, q=1\n",
      "Engineering, PCS, E377, date=2021-02-26, dark=0, q=2\n",
      "Engineering, OSIRIS-LGS, E389, date=2021-02-26, dark=0, q=3\n",
      "Engineering, OSIRIS-LGS, E389, date=2021-02-26, dark=0, q=4\n",
      "Engineering, SSC, E391, date=2021-02-27, dark=0, q=1\n",
      "Engineering, OSIRIS-LGS, E388, date=2021-02-27, dark=0, q=2\n",
      "Engineering, OSIRIS-LGS, E388, date=2021-02-27, dark=0, q=3\n",
      "Engineering, OSIRIS-LGS, E388, date=2021-02-27, dark=0, q=4\n",
      "Steidel, MOSFIRE, C281, date=2021-02-28, dark=0, q=1\n",
      "Steidel, MOSFIRE, C281, date=2021-02-28, dark=0, q=2\n",
      "Steidel, MOSFIRE, C281, date=2021-02-28, dark=0, q=3\n",
      "Steidel, MOSFIRE, C281, date=2021-02-28, dark=0, q=4\n",
      "Steidel, MOSFIRE, C281, date=2021-03-01, dark=0, q=1\n",
      "Steidel, MOSFIRE, C281, date=2021-03-01, dark=0, q=2\n",
      "Steidel, MOSFIRE, C281, date=2021-03-01, dark=0, q=3\n",
      "Steidel, MOSFIRE, C281, date=2021-03-01, dark=0, q=4\n",
      "Shapley, MOSFIRE, U073, date=2021-03-02, dark=1, q=1\n",
      "Shapley, MOSFIRE, U073, date=2021-03-02, dark=0, q=2\n",
      "Shapley, MOSFIRE, U073, date=2021-03-02, dark=0, q=3\n",
      "Shapley, MOSFIRE, U073, date=2021-03-02, dark=0, q=4\n",
      "Shapley, MOSFIRE, U046, date=2021-03-03, dark=1, q=1\n",
      "Shapley, MOSFIRE, U046, date=2021-03-03, dark=0, q=2\n",
      "Shapley, MOSFIRE, U046, date=2021-03-03, dark=0, q=3\n",
      "Shapley, MOSFIRE, U046, date=2021-03-03, dark=0, q=4\n",
      "Shapley, MOSFIRE, U073, date=2021-03-04, dark=1, q=1\n",
      "Shapley, MOSFIRE, U073, date=2021-03-04, dark=0, q=2\n",
      "Shapley, MOSFIRE, U073, date=2021-03-04, dark=0, q=3\n",
      "Shapley, MOSFIRE, U073, date=2021-03-04, dark=0, q=4\n",
      "Kriek, MOSFIRE, U075, date=2021-03-05, dark=1, q=1\n",
      "Kriek, MOSFIRE, U075, date=2021-03-05, dark=1, q=2\n",
      "Kriek, MOSFIRE, U075, date=2021-03-05, dark=0, q=3\n",
      "Kriek, MOSFIRE, U075, date=2021-03-05, dark=0, q=4\n",
      "Huber, HIRESr, H269, date=2021-03-06, dark=1, q=1\n",
      "Huber, HIRESr, H269, date=2021-03-06, dark=1, q=2\n",
      "Huber, HIRESr, H269, date=2021-03-06, dark=0, q=3\n",
      "Huber, HIRESr, H269, date=2021-03-06, dark=0, q=4\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-03-07, dark=1, q=1\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-03-07, dark=1, q=2\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-03-07, dark=1, q=3\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-03-07, dark=0, q=4\n",
      "Gregg, LRIS-ADC, U114, date=2021-03-08, dark=1, q=1\n",
      "Gregg, LRIS-ADC, U114, date=2021-03-08, dark=1, q=2\n",
      "Gregg, LRIS-ADC, U114, date=2021-03-08, dark=1, q=3\n",
      "Gregg, LRIS-ADC, U114, date=2021-03-08, dark=0, q=4\n",
      "Gregg, LRIS-ADC, U114, date=2021-03-09, dark=1, q=1\n",
      "Gregg, LRIS-ADC, U114, date=2021-03-09, dark=1, q=2\n",
      "Gregg, LRIS-ADC, U114, date=2021-03-09, dark=1, q=3\n",
      "Gregg, LRIS-ADC, U114, date=2021-03-09, dark=0, q=4\n",
      "Masters, LRIS-ADC, N238, date=2021-03-10, dark=1, q=1\n",
      "Masters, LRIS-ADC, N238, date=2021-03-10, dark=1, q=2\n",
      "Masters, LRIS-ADC, N238, date=2021-03-10, dark=1, q=3\n",
      "Masters, LRIS-ADC, N238, date=2021-03-10, dark=1, q=4\n",
      "Cowie, LRIS-ADC, H288, date=2021-03-11, dark=1, q=1\n",
      "Cowie, LRIS-ADC, H288, date=2021-03-11, dark=1, q=2\n",
      "Cowie, LRIS-ADC, H288, date=2021-03-11, dark=1, q=3\n",
      "Cowie, LRIS-ADC, H288, date=2021-03-11, dark=1, q=4\n",
      "Filippenko, LRIS-ADC, U050, date=2021-03-12, dark=1, q=1\n",
      "Filippenko, LRIS-ADC, U050, date=2021-03-12, dark=1, q=2\n",
      "Filippenko, LRIS-ADC, U078, date=2021-03-12, dark=1, q=3\n",
      "Filippenko, LRIS-ADC, U078, date=2021-03-12, dark=1, q=4\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-03-13, dark=1, q=1\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-03-13, dark=1, q=2\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-03-13, dark=1, q=3\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-03-13, dark=1, q=4\n",
      "Kasliwal, LRIS-ADC, C285, date=2021-03-14, dark=0, q=1\n",
      "Kasliwal, LRIS-ADC, C285, date=2021-03-14, dark=1, q=2\n",
      "Andreoni, LRIS-ADC, C277, date=2021-03-14, dark=1, q=3\n",
      "Andreoni, LRIS-ADC, C277, date=2021-03-14, dark=1, q=4\n",
      "Lewis, HIRESb, K349, date=2021-03-15, dark=0, q=1\n",
      "Lewis, HIRESb, K349, date=2021-03-15, dark=1, q=2\n",
      "Lewis, HIRESb, K349, date=2021-03-15, dark=1, q=3\n",
      "Lewis, HIRESb, K349, date=2021-03-15, dark=1, q=4\n",
      "Xu, HIRESb, N056, date=2021-03-16, dark=0, q=1\n",
      "Xu, HIRESb, N056, date=2021-03-16, dark=1, q=2\n",
      "Xu, HIRESb, N056, date=2021-03-16, dark=1, q=3\n",
      "Xu, HIRESb, N056, date=2021-03-16, dark=1, q=4\n",
      "Cowie, MOSFIRE, H288, date=2021-03-17, dark=0, q=1\n",
      "Cowie, MOSFIRE, H288, date=2021-03-17, dark=0, q=2\n",
      "Cowie, MOSFIRE, H288, date=2021-03-17, dark=1, q=3\n",
      "Cowie, MOSFIRE, H288, date=2021-03-17, dark=1, q=4\n",
      "Cowie, MOSFIRE, H288, date=2021-03-18, dark=0, q=1\n",
      "Cowie, MOSFIRE, H288, date=2021-03-18, dark=0, q=2\n",
      "Cowie, MOSFIRE, H288, date=2021-03-18, dark=1, q=3\n",
      "Cowie, MOSFIRE, H288, date=2021-03-18, dark=1, q=4\n",
      "Siana, MOSFIRE, U122, date=2021-03-19, dark=0, q=1\n",
      "Siana, MOSFIRE, U122, date=2021-03-19, dark=0, q=2\n",
      "Siana, MOSFIRE, U122, date=2021-03-19, dark=1, q=3\n",
      "Siana, MOSFIRE, U122, date=2021-03-19, dark=1, q=4\n",
      "Labbe, MOSFIRE, W243, date=2021-03-20, dark=0, q=1\n",
      "Labbe, MOSFIRE, W243, date=2021-03-20, dark=0, q=2\n",
      "Treu, OSIRIS-LGS, U021, date=2021-03-20, dark=0, q=3\n",
      "Treu, OSIRIS-LGS, U021, date=2021-03-20, dark=1, q=4\n",
      "Labbe, MOSFIRE, W243, date=2021-03-21, dark=0, q=1\n",
      "Labbe, MOSFIRE, W243, date=2021-03-21, dark=0, q=2\n",
      "Howard, HIRESr, C013, date=2021-03-21, dark=0, q=3\n",
      "Howard, HIRESr, C013, date=2021-03-21, dark=1, q=4\n",
      "Labbe, MOSFIRE, W243, date=2021-03-22, dark=0, q=1\n",
      "Labbe, MOSFIRE, W243, date=2021-03-22, dark=0, q=2\n",
      "Howard, HIRESr, C013, date=2021-03-22, dark=0, q=3\n",
      "Howard, HIRESr, C013, date=2021-03-22, dark=1, q=4\n",
      "Exchange, PCS, ENG, date=2021-03-23, dark=0, q=1\n",
      "Exchange, PCS, ENG, date=2021-03-23, dark=0, q=2\n",
      "Engineering, OSIRIS-LGS, E389, date=2021-03-23, dark=0, q=3\n",
      "Engineering, OSIRIS-LGS, E389, date=2021-03-23, dark=0, q=4\n",
      "Exchange, PCS, ENG, date=2021-03-24, dark=0, q=1\n",
      "Exchange, PCS, ENG, date=2021-03-24, dark=0, q=2\n",
      "Engineering, PCS, E377, date=2021-03-24, dark=0, q=3\n",
      "Engineering, PCS, E377, date=2021-03-24, dark=0, q=4\n",
      "Exch, PCS, ENG, date=2021-03-25, dark=0, q=1\n",
      "Howard, HIRESr, C013, date=2021-03-25, dark=0, q=2\n",
      "Howard, HIRESr, C013, date=2021-03-25, dark=0, q=3\n",
      "Engineering, OSIRIS-LGS, E388, date=2021-03-25, dark=0, q=4\n",
      "Beers, HIRESr, D337, date=2021-03-26, dark=0, q=1\n",
      "Beers, HIRESr, D337, date=2021-03-26, dark=0, q=2\n",
      "Engineering, OSIRIS-LGS, E389, date=2021-03-26, dark=0, q=3\n",
      "Engineering, OSIRIS-LGS, E388, date=2021-03-26, dark=0, q=4\n",
      "Kriek, MOSFIRE, U075, date=2021-03-27, dark=0, q=1\n",
      "Kriek, MOSFIRE, U075, date=2021-03-27, dark=0, q=2\n",
      "Batalha, HIRESr, U111, date=2021-03-27, dark=0, q=3\n",
      "Batalha, HIRESr, U111, date=2021-03-27, dark=0, q=4\n",
      "Kriek, MOSFIRE, U075, date=2021-03-28, dark=0, q=1\n",
      "Kriek, MOSFIRE, U075, date=2021-03-28, dark=0, q=2\n",
      "Batalha, HIRESr, U111, date=2021-03-28, dark=0, q=3\n",
      "Batalha, HIRESr, U111, date=2021-03-28, dark=0, q=4\n",
      "Nanayakkara, MOSFIRE, W242, date=2021-03-29, dark=0, q=1\n",
      "Nanayakkara, MOSFIRE, W242, date=2021-03-29, dark=0, q=2\n",
      "Howard, HIRESr, C013, date=2021-03-29, dark=0, q=3\n",
      "Howard, HIRESr, C013, date=2021-03-29, dark=0, q=4\n",
      "Lewis, OSIRIS-LGS, K328, date=2021-03-30, dark=0, q=1\n",
      "Lewis, OSIRIS-LGS, K328, date=2021-03-30, dark=0, q=2\n",
      "Paterson, MOSFIRE, O316, date=2021-03-30, dark=0, q=3\n",
      "Paterson, MOSFIRE, O316, date=2021-03-30, dark=0, q=4\n",
      "Lewis, OSIRIS-LGS, K332, date=2021-03-31, dark=1, q=1\n",
      "Lewis, OSIRIS-LGS, K332, date=2021-03-31, dark=0, q=2\n",
      "Engineering, OSIRIS-LGS, E389, date=2021-03-31, dark=0, q=3\n",
      "Engineering, OSIRIS-LGS, E389, date=2021-03-31, dark=0, q=4\n",
      "Lewis, MOSFIRE, K323, date=2021-04-01, dark=1, q=1\n",
      "Lewis, MOSFIRE, K323, date=2021-04-01, dark=0, q=2\n",
      "Engineering, PCS, E394, date=2021-04-01, dark=0, q=3\n",
      "Engineering, PCS, E377, date=2021-04-01, dark=0, q=4\n",
      "Shapley, MOSFIRE, U046, date=2021-04-02, dark=1, q=1\n",
      "Shapley, MOSFIRE, U046, date=2021-04-02, dark=0, q=2\n",
      "Shapley, MOSFIRE, U046, date=2021-04-02, dark=0, q=3\n",
      "Shapley, MOSFIRE, U046, date=2021-04-02, dark=0, q=4\n",
      "Hennawi, MOSFIRE, U058, date=2021-04-03, dark=1, q=1\n",
      "Hennawi, MOSFIRE, U058, date=2021-04-03, dark=1, q=2\n",
      "Hennawi, MOSFIRE, U058, date=2021-04-03, dark=0, q=3\n",
      "Hennawi, MOSFIRE, U058, date=2021-04-03, dark=0, q=4\n",
      "Kirby, LRIS-ADC, C259, date=2021-04-04, dark=1, q=1\n",
      "Kirby, LRIS-ADC, C259, date=2021-04-04, dark=1, q=2\n",
      "Kirby, LRIS-ADC, C259, date=2021-04-04, dark=0, q=3\n",
      "Kirby, LRIS-ADC, C259, date=2021-04-04, dark=0, q=4\n",
      "Prince, LRIS-ADC, C308, date=2021-04-05, dark=1, q=1\n",
      "Prince, LRIS-ADC, C308, date=2021-04-05, dark=1, q=2\n",
      "Prince, LRIS-ADC, C308, date=2021-04-05, dark=1, q=3\n",
      "Prince, LRIS-ADC, C308, date=2021-04-05, dark=0, q=4\n",
      "Filippenko, LRIS-ADC, U053, date=2021-04-06, dark=1, q=1\n",
      "Filippenko, LRIS-ADC, U053, date=2021-04-06, dark=1, q=2\n",
      "Filippenko, LRIS-ADC, U053, date=2021-04-06, dark=1, q=3\n",
      "Filippenko, LRIS-ADC, U053, date=2021-04-06, dark=0, q=4\n",
      "Kriek, LRIS-ADC, U075, date=2021-04-07, dark=1, q=1\n",
      "Kriek, LRIS-ADC, U075, date=2021-04-07, dark=1, q=2\n",
      "Foley, LRIS-ADC, U089, date=2021-04-07, dark=1, q=3\n",
      "Foley, LRIS-ADC, U089, date=2021-04-07, dark=0, q=4\n",
      "Kriek, LRIS-ADC, U075, date=2021-04-08, dark=1, q=1\n",
      "Kriek, LRIS-ADC, U075, date=2021-04-08, dark=1, q=2\n",
      "Grunblatt, HIRESr, N098, date=2021-04-08, dark=1, q=3\n",
      "Grunblatt, HIRESr, N098, date=2021-04-08, dark=0, q=4\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-04-09, dark=1, q=1\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-04-09, dark=1, q=2\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-04-09, dark=1, q=3\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-04-09, dark=1, q=4\n",
      "Prochaska, LRIS-ADC, U084, date=2021-04-10, dark=1, q=1\n",
      "Prochaska, LRIS-ADC, U084, date=2021-04-10, dark=1, q=2\n",
      "Prochaska, LRIS-ADC, U084, date=2021-04-10, dark=1, q=3\n",
      "Prochaska, LRIS-ADC, U084, date=2021-04-10, dark=1, q=4\n",
      "Filippenko, LRIS-ADC, U050, date=2021-04-11, dark=1, q=1\n",
      "Filippenko, LRIS-ADC, U050, date=2021-04-11, dark=1, q=2\n",
      "Filippenko, LRIS-ADC, U078, date=2021-04-11, dark=1, q=3\n",
      "Filippenko, LRIS-ADC, U078, date=2021-04-11, dark=1, q=4\n",
      "Masters, LRIS-ADC, N238, date=2021-04-12, dark=1, q=1\n",
      "Masters, LRIS-ADC, N238, date=2021-04-12, dark=1, q=2\n",
      "Masters, LRIS-ADC, N238, date=2021-04-12, dark=1, q=3\n",
      "Masters, LRIS-ADC, N238, date=2021-04-12, dark=1, q=4\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-04-13, dark=0, q=1\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-04-13, dark=1, q=2\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-04-13, dark=1, q=3\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-04-13, dark=1, q=4\n",
      "Dokkum, LRIS-ADC, Y228, date=2021-04-14, dark=0, q=1\n",
      "Dokkum, LRIS-ADC, Y228, date=2021-04-14, dark=1, q=2\n",
      "Dokkum, LRIS-ADC, Y228, date=2021-04-14, dark=1, q=3\n",
      "Dokkum, LRIS-ADC, Y228, date=2021-04-14, dark=1, q=4\n",
      "Dokkum, LRIS-ADC, Y228, date=2021-04-15, dark=0, q=1\n",
      "Dokkum, LRIS-ADC, Y228, date=2021-04-15, dark=0, q=2\n",
      "Dokkum, LRIS-ADC, Y228, date=2021-04-15, dark=1, q=3\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dokkum, LRIS-ADC, Y228, date=2021-04-15, dark=1, q=4\n",
      "Kirby, MOSFIRE, C259, date=2021-04-16, dark=0, q=1\n",
      "Kirby, MOSFIRE, C259, date=2021-04-16, dark=0, q=2\n",
      "Kirby, MOSFIRE, C259, date=2021-04-16, dark=1, q=3\n",
      "Kirby, MOSFIRE, C259, date=2021-04-16, dark=1, q=4\n",
      "Hennawi, MOSFIRE, U058, date=2021-04-17, dark=0, q=1\n",
      "Hennawi, MOSFIRE, U058, date=2021-04-17, dark=0, q=2\n",
      "Hennawi, MOSFIRE, U058, date=2021-04-17, dark=1, q=3\n",
      "Hennawi, MOSFIRE, U058, date=2021-04-17, dark=1, q=4\n",
      "Shapley, MOSFIRE, U046, date=2021-04-18, dark=0, q=1\n",
      "Shapley, MOSFIRE, U046, date=2021-04-18, dark=0, q=2\n",
      "Shapley, MOSFIRE, U046, date=2021-04-18, dark=0, q=3\n",
      "Shapley, MOSFIRE, U046, date=2021-04-18, dark=1, q=4\n",
      "Siana, MOSFIRE, U122, date=2021-04-19, dark=0, q=1\n",
      "Siana, MOSFIRE, U122, date=2021-04-19, dark=0, q=2\n",
      "Siana, MOSFIRE, U122, date=2021-04-19, dark=0, q=3\n",
      "Siana, MOSFIRE, U122, date=2021-04-19, dark=1, q=4\n",
      "Treu, MOSFIRE, U020, date=2021-04-20, dark=0, q=1\n",
      "Treu, MOSFIRE, U020, date=2021-04-20, dark=0, q=2\n",
      "Treu, MOSFIRE, U020, date=2021-04-20, dark=0, q=3\n",
      "Treu, MOSFIRE, U020, date=2021-04-20, dark=1, q=4\n",
      "Treu, MOSFIRE, U020, date=2021-04-21, dark=0, q=1\n",
      "Treu, MOSFIRE, U020, date=2021-04-21, dark=0, q=2\n",
      "Treu, MOSFIRE, U020, date=2021-04-21, dark=0, q=3\n",
      "Treu, MOSFIRE, U020, date=2021-04-21, dark=0, q=4\n",
      "Jung, MOSFIRE, N199, date=2021-04-22, dark=0, q=1\n",
      "Jung, MOSFIRE, N199, date=2021-04-22, dark=0, q=2\n",
      "Jung, MOSFIRE, N199, date=2021-04-22, dark=0, q=3\n",
      "Jung, MOSFIRE, N199, date=2021-04-22, dark=0, q=4\n",
      "Jung, MOSFIRE, N199, date=2021-04-23, dark=0, q=1\n",
      "Jung, MOSFIRE, N199, date=2021-04-23, dark=0, q=2\n",
      "Jung, MOSFIRE, N199, date=2021-04-23, dark=0, q=3\n",
      "Jung, MOSFIRE, N199, date=2021-04-23, dark=0, q=4\n",
      "Melis, HIRESr, U110, date=2021-04-24, dark=0, q=1\n",
      "Melis, HIRESr, U110, date=2021-04-24, dark=0, q=2\n",
      "Melis, HIRESr, U110, date=2021-04-24, dark=0, q=3\n",
      "Melis, HIRESr, U110, date=2021-04-24, dark=0, q=4\n",
      "Fassnacht, OSIRIS-LGS, U109, date=2021-04-25, dark=0, q=1\n",
      "Fassnacht, OSIRIS-LGS, U109, date=2021-04-25, dark=0, q=2\n",
      "Fassnacht, OSIRIS-LGS, U109, date=2021-04-25, dark=0, q=3\n",
      "Fassnacht, OSIRIS-LGS, U109, date=2021-04-25, dark=0, q=4\n",
      "Howard, HIRESr, C013, date=2021-04-26, dark=0, q=1\n",
      "Howard, HIRESr, C013, date=2021-04-26, dark=0, q=2\n",
      "Engineering, OSIRIS-LGS, E379, date=2021-04-26, dark=0, q=3\n",
      "Engineering, OSIRIS-LGS, E379, date=2021-04-26, dark=0, q=4\n",
      "Engineering, LRIS-ADC, E376, date=2021-04-27, dark=0, q=1\n",
      "Engineering, LRIS-ADC, E376, date=2021-04-27, dark=0, q=2\n",
      "Engineering, OSIRIS-NGS, E379, date=2021-04-27, dark=0, q=3\n",
      "Engineering, OSIRIS-NGS, E379, date=2021-04-27, dark=0, q=4\n",
      "Engineering, LRIS-ADC, E376, date=2021-04-28, dark=0, q=1\n",
      "Engineering, LRIS-ADC, E376, date=2021-04-28, dark=0, q=2\n",
      "Engineering, OSIRIS-LGS, E379, date=2021-04-28, dark=0, q=3\n",
      "Engineering, OSIRIS-LGS, E379, date=2021-04-28, dark=0, q=4\n",
      "Earnshaw, MOSFIRE, C249, date=2021-04-29, dark=1, q=1\n",
      "Earnshaw, MOSFIRE, C249, date=2021-04-29, dark=0, q=2\n",
      "Earnshaw, MOSFIRE, C249, date=2021-04-29, dark=0, q=3\n",
      "Earnshaw, MOSFIRE, C249, date=2021-04-29, dark=0, q=4\n",
      "Shapley, MOSFIRE, N140, date=2021-04-30, dark=1, q=1\n",
      "Shapley, MOSFIRE, N140, date=2021-04-30, dark=0, q=2\n",
      "Shapley, MOSFIRE, N140, date=2021-04-30, dark=0, q=3\n",
      "Shapley, MOSFIRE, N140, date=2021-04-30, dark=0, q=4\n",
      "Shapley, MOSFIRE, N140, date=2021-05-01, dark=1, q=1\n",
      "Shapley, MOSFIRE, N140, date=2021-05-01, dark=0, q=2\n",
      "Shapley, MOSFIRE, N140, date=2021-05-01, dark=0, q=3\n",
      "Shapley, MOSFIRE, N140, date=2021-05-01, dark=0, q=4\n",
      "Hamann, OSIRIS-LGS, U092, date=2021-05-02, dark=1, q=1\n",
      "Hamann, OSIRIS-LGS, U092, date=2021-05-02, dark=1, q=2\n",
      "Hamann, OSIRIS-LGS, U092, date=2021-05-02, dark=0, q=3\n",
      "Hamann, OSIRIS-LGS, U092, date=2021-05-02, dark=0, q=4\n",
      "Hamann, OSIRIS-LGS, U092, date=2021-05-03, dark=1, q=1\n",
      "Hamann, OSIRIS-LGS, U092, date=2021-05-03, dark=1, q=2\n",
      "Hamann, OSIRIS-LGS, U092, date=2021-05-03, dark=0, q=3\n",
      "Hamann, OSIRIS-LGS, U092, date=2021-05-03, dark=0, q=4\n",
      "Xu, HIRESb, N056, date=2021-05-04, dark=1, q=1\n",
      "Xu, HIRESb, N056, date=2021-05-04, dark=1, q=2\n",
      "Xu, HIRESb, N056, date=2021-05-04, dark=0, q=3\n",
      "Xu, HIRESb, N056, date=2021-05-04, dark=0, q=4\n",
      "Melis, HIRESb, U110, date=2021-05-05, dark=1, q=1\n",
      "Melis, HIRESb, U110, date=2021-05-05, dark=1, q=2\n",
      "Melis, HIRESb, U110, date=2021-05-05, dark=1, q=3\n",
      "Melis, HIRESb, U110, date=2021-05-05, dark=0, q=4\n",
      "Engineering, LRIS-ADC, E376, date=2021-05-06, dark=1, q=1\n",
      "Engineering, LRIS-ADC, E376, date=2021-05-06, dark=1, q=2\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-06, dark=1, q=3\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-06, dark=0, q=4\n",
      "Dokkum, LRIS-ADC, Y228, date=2021-05-07, dark=1, q=1\n",
      "Dokkum, LRIS-ADC, Y228, date=2021-05-07, dark=1, q=2\n",
      "Dokkum, LRIS-ADC, Y228, date=2021-05-07, dark=1, q=3\n",
      "Dokkum, LRIS-ADC, Y228, date=2021-05-07, dark=0, q=4\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-05-08, dark=1, q=1\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-05-08, dark=1, q=2\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-05-08, dark=1, q=3\n",
      "Djorgovski, LRIS-ADC, C278, date=2021-05-08, dark=0, q=4\n",
      "Kasliwal, LRIS-ADC, C285, date=2021-05-09, dark=1, q=1\n",
      "Kasliwal, LRIS-ADC, C285, date=2021-05-09, dark=1, q=2\n",
      "Fremling, LRIS-ADC, C287, date=2021-05-09, dark=1, q=3\n",
      "Fremling, LRIS-ADC, C287, date=2021-05-09, dark=1, q=4\n",
      "Paterson, LRIS-ADC, O316, date=2021-05-10, dark=1, q=1\n",
      "Paterson, LRIS-ADC, O316, date=2021-05-10, dark=1, q=2\n",
      "Paterson, LRIS-ADC, O316, date=2021-05-10, dark=1, q=3\n",
      "Paterson, LRIS-ADC, O316, date=2021-05-10, dark=1, q=4\n",
      "Foley, LRIS-ADC, U089, date=2021-05-11, dark=1, q=1\n",
      "Foley, LRIS-ADC, U089, date=2021-05-11, dark=1, q=2\n",
      "Foley, LRIS-ADC, U089, date=2021-05-11, dark=1, q=3\n",
      "Foley, LRIS-ADC, U089, date=2021-05-11, dark=1, q=4\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-05-12, dark=0, q=1\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-05-12, dark=1, q=2\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-05-12, dark=1, q=3\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-05-12, dark=1, q=4\n",
      "Hallinan, LRIS-ADC, C302, date=2021-05-13, dark=0, q=1\n",
      "Hallinan, LRIS-ADC, C302, date=2021-05-13, dark=1, q=2\n",
      "Hallinan, LRIS-ADC, C302, date=2021-05-13, dark=1, q=3\n",
      "Hallinan, LRIS-ADC, C302, date=2021-05-13, dark=1, q=4\n",
      "Brown, LRIS-ADC, C314, date=2021-05-14, dark=0, q=1\n",
      "Brown, LRIS-ADC, C314, date=2021-05-14, dark=1, q=2\n",
      "Brown, LRIS-ADC, C314, date=2021-05-14, dark=1, q=3\n",
      "Brown, LRIS-ADC, C314, date=2021-05-14, dark=1, q=4\n",
      "Fremling, LRIS-ADC, C287, date=2021-05-15, dark=0, q=1\n",
      "Fremling, LRIS-ADC, C287, date=2021-05-15, dark=0, q=2\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-15, dark=1, q=3\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-15, dark=1, q=4\n",
      "Treu, MOSFIRE, U020, date=2021-05-16, dark=0, q=1\n",
      "Treu, MOSFIRE, U020, date=2021-05-16, dark=0, q=2\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-16, dark=1, q=3\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-16, dark=1, q=4\n",
      "Treu, MOSFIRE, U020, date=2021-05-17, dark=0, q=1\n",
      "Treu, MOSFIRE, U020, date=2021-05-17, dark=0, q=2\n",
      "Bennett, OSIRIS-LGS, N164, date=2021-05-17, dark=1, q=3\n",
      "Bennett, OSIRIS-LGS, N164, date=2021-05-17, dark=1, q=4\n",
      "Howard, HIRESr, N012, date=2021-05-18, dark=0, q=1\n",
      "Howard, HIRESr, N012, date=2021-05-18, dark=0, q=2\n",
      "Bennett, OSIRIS-LGS, N164, date=2021-05-18, dark=0, q=3\n",
      "Bennett, OSIRIS-LGS, N164, date=2021-05-18, dark=1, q=4\n",
      "Howard, HIRESr, C013, date=2021-05-19, dark=0, q=1\n",
      "Howard, HIRESr, C013, date=2021-05-19, dark=0, q=2\n",
      "Howard, HIRESr, C013, date=2021-05-19, dark=0, q=3\n",
      "Kleer, HIRESr, C294, date=2021-05-19, dark=1, q=4\n",
      "Crossfield, HIRESr, N136, date=2021-05-20, dark=0, q=1\n",
      "Howard, HIRESr, N012, date=2021-05-20, dark=0, q=2\n",
      "Howard, HIRESr, N012, date=2021-05-20, dark=0, q=3\n",
      "Howard, HIRESr, N012, date=2021-05-20, dark=1, q=4\n",
      "Engineering, LRIS-ADC, E376, date=2021-05-21, dark=0, q=1\n",
      "Engineering, LRIS-ADC, E376, date=2021-05-21, dark=0, q=2\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-21, dark=0, q=3\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-21, dark=0, q=4\n",
      "Engineering, LRIS-ADC, E376, date=2021-05-22, dark=0, q=1\n",
      "Engineering, LRIS-ADC, E376, date=2021-05-22, dark=0, q=2\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-22, dark=0, q=3\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-22, dark=0, q=4\n",
      "Howard, HIRESr, C013, date=2021-05-23, dark=0, q=1\n",
      "Howard, HIRESr, C013, date=2021-05-23, dark=0, q=2\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-23, dark=0, q=3\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-23, dark=0, q=4\n",
      "Engineering, LRIS-ADC, E376, date=2021-05-24, dark=0, q=1\n",
      "Engineering, LRIS-ADC, E376, date=2021-05-24, dark=0, q=2\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-24, dark=0, q=3\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-24, dark=0, q=4\n",
      "Treu, OSIRIS-LGS, U021, date=2021-05-25, dark=0, q=1\n",
      "Treu, OSIRIS-LGS, U021, date=2021-05-25, dark=0, q=2\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-25, dark=0, q=3\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-05-25, dark=0, q=4\n",
      "Dai, HIRESr, C252, date=2021-05-26, dark=0, q=1\n",
      "Dai, HIRESr, C252, date=2021-05-26, dark=0, q=2\n",
      "Dai, HIRESr, C252, date=2021-05-26, dark=0, q=3\n",
      "Dai, HIRESr, C252, date=2021-05-26, dark=0, q=4\n",
      "Engineering, OSIRIS-NGS, E333, date=2021-05-27, dark=0, q=1\n",
      "Engineering, OSIRIS-NGS, E333, date=2021-05-27, dark=0, q=2\n",
      "Engineering, OSIRIS-NGS, E333, date=2021-05-27, dark=0, q=3\n",
      "Engineering, OSIRIS-NGS, E333, date=2021-05-27, dark=0, q=4\n",
      "Chontos, HIRESr, H262, date=2021-05-28, dark=0, q=1\n",
      "Chontos, HIRESr, H262, date=2021-05-28, dark=0, q=2\n",
      "Chontos, HIRESr, H262, date=2021-05-28, dark=0, q=3\n",
      "Chontos, HIRESr, H262, date=2021-05-28, dark=0, q=4\n",
      "Earnshaw, MOSFIRE, C249, date=2021-05-29, dark=1, q=1\n",
      "Earnshaw, MOSFIRE, C249, date=2021-05-29, dark=0, q=2\n",
      "Earnshaw, MOSFIRE, C249, date=2021-05-29, dark=0, q=3\n",
      "Earnshaw, MOSFIRE, C249, date=2021-05-29, dark=0, q=4\n",
      "Jones, MOSFIRE, U023, date=2021-05-30, dark=1, q=1\n",
      "Jones, MOSFIRE, U023, date=2021-05-30, dark=0, q=2\n",
      "Batalha, HIRESr, U111, date=2021-05-30, dark=0, q=3\n",
      "Batalha, HIRESr, U111, date=2021-05-30, dark=0, q=4\n",
      "Howard, HIRESr, C013, date=2021-05-31, dark=1, q=1\n",
      "Howard, HIRESr, C013, date=2021-05-31, dark=1, q=2\n",
      "Howard, HIRESr, C013, date=2021-05-31, dark=0, q=3\n",
      "Howard, HIRESr, C013, date=2021-05-31, dark=0, q=4\n",
      "Hinz, HIRESr, U006, date=2021-06-01, dark=1, q=1\n",
      "Hinz, HIRESr, U006, date=2021-06-01, dark=1, q=2\n",
      "Crepp, HIRESr, D347, date=2021-06-01, dark=0, q=3\n",
      "Crepp, HIRESr, D347, date=2021-06-01, dark=0, q=4\n",
      "Chontos, HIRESr, H262, date=2021-06-02, dark=1, q=1\n",
      "Chontos, HIRESr, H262, date=2021-06-02, dark=1, q=2\n",
      "Chontos, HIRESr, H262, date=2021-06-02, dark=0, q=3\n",
      "Chontos, HIRESr, H262, date=2021-06-02, dark=0, q=4\n",
      "Roestel, LRIS-ADC, C229, date=2021-06-03, dark=1, q=1\n",
      "Roestel, LRIS-ADC, C229, date=2021-06-03, dark=1, q=2\n",
      "Roestel, LRIS-ADC, C229, date=2021-06-03, dark=0, q=3\n",
      "Roestel, LRIS-ADC, C229, date=2021-06-03, dark=0, q=4\n",
      "Prince, LRIS-ADC, C308, date=2021-06-04, dark=1, q=1\n",
      "Prince, LRIS-ADC, C308, date=2021-06-04, dark=1, q=2\n",
      "Prince, LRIS-ADC, C308, date=2021-06-04, dark=1, q=3\n",
      "Prince, LRIS-ADC, C308, date=2021-06-04, dark=0, q=4\n",
      "Ravi, LRIS-ADC, C310, date=2021-06-05, dark=1, q=1\n",
      "Ravi, LRIS-ADC, C310, date=2021-06-05, dark=1, q=2\n",
      "Ravi, LRIS-ADC, C310, date=2021-06-05, dark=1, q=3\n",
      "Ravi, LRIS-ADC, C310, date=2021-06-05, dark=0, q=4\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-06-06, dark=1, q=1\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-06-06, dark=1, q=2\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-06-06, dark=1, q=3\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-06-06, dark=0, q=4\n",
      "Batalha, HIRESr, U111, date=2021-06-07, dark=1, q=1\n",
      "Batalha, HIRESr, U111, date=2021-06-07, dark=1, q=2\n",
      "Kleer, HIRESr, C294, date=2021-06-07, dark=1, q=3\n",
      "Kleer, HIRESr, C294, date=2021-06-07, dark=0, q=4\n",
      "Rice, HIRESr, Y333, date=2021-06-08, dark=1, q=1\n",
      "Rice, HIRESr, Y333, date=2021-06-08, dark=1, q=2\n",
      "Rice, HIRESr, Y333, date=2021-06-08, dark=1, q=3\n",
      "Rice, HIRESr, Y333, date=2021-06-08, dark=1, q=4\n",
      "Nierenberg, OSIRIS-LGS, U129, date=2021-06-09, dark=1, q=1\n",
      "Nierenberg, OSIRIS-LGS, U129, date=2021-06-09, dark=1, q=2\n",
      "Nierenberg, OSIRIS-LGS, U129, date=2021-06-09, dark=1, q=3\n",
      "Nierenberg, OSIRIS-LGS, U129, date=2021-06-09, dark=1, q=4\n",
      "Huber, HIRESr, H270, date=2021-06-10, dark=1, q=1\n",
      "Huber, HIRESr, H270, date=2021-06-10, dark=1, q=2\n",
      "Huber, HIRESr, H270, date=2021-06-10, dark=1, q=3\n",
      "Huber, HIRESr, H270, date=2021-06-10, dark=1, q=4\n",
      "Batalha, HIRESr, U111, date=2021-06-11, dark=0, q=1\n",
      "Batalha, HIRESr, U111, date=2021-06-11, dark=1, q=2\n",
      "Batalha, HIRESr, U111, date=2021-06-11, dark=1, q=3\n",
      "Batalha, HIRESr, U111, date=2021-06-11, dark=1, q=4\n",
      "Batalha, HIRESr, U111, date=2021-06-12, dark=0, q=1\n",
      "Batalha, HIRESr, U111, date=2021-06-12, dark=1, q=2\n",
      "Batalha, HIRESr, U111, date=2021-06-12, dark=1, q=3\n",
      "Batalha, HIRESr, U111, date=2021-06-12, dark=1, q=4\n",
      "Batalha, HIRESr, U111, date=2021-06-13, dark=0, q=1\n",
      "Batalha, HIRESr, U111, date=2021-06-13, dark=1, q=2\n",
      "Batalha, HIRESr, U111, date=2021-06-13, dark=1, q=3\n",
      "Batalha, HIRESr, U111, date=2021-06-13, dark=1, q=4\n",
      "Urry, LRIS-ADC, Y227, date=2021-06-14, dark=0, q=1\n",
      "Urry, LRIS-ADC, Y227, date=2021-06-14, dark=0, q=2\n",
      "Urry, LRIS-ADC, Y227, date=2021-06-14, dark=1, q=3\n",
      "Urry, LRIS-ADC, Y227, date=2021-06-14, dark=1, q=4\n",
      "Follette, LRIS-ADC, N196, date=2021-06-15, dark=0, q=1\n",
      "Follette, LRIS-ADC, N196, date=2021-06-15, dark=0, q=2\n",
      "Weiss, HIRESr, N048, date=2021-06-15, dark=1, q=3\n",
      "Weiss, HIRESr, N048, date=2021-06-15, dark=1, q=4\n",
      "Follette, LRIS-ADC, N196, date=2021-06-16, dark=0, q=1\n",
      "Follette, LRIS-ADC, N196, date=2021-06-16, dark=0, q=2\n",
      "Weiss, HIRESr, N048, date=2021-06-16, dark=1, q=3\n",
      "Weiss, HIRESr, N048, date=2021-06-16, dark=1, q=4\n",
      "Batalha, HIRESr, U111, date=2021-06-17, dark=0, q=1\n",
      "Batalha, HIRESr, U111, date=2021-06-17, dark=0, q=2\n",
      "Batalha, HIRESr, U111, date=2021-06-17, dark=0, q=3\n",
      "Batalha, HIRESr, U111, date=2021-06-17, dark=1, q=4\n",
      "Chontos, HIRESr, H262, date=2021-06-18, dark=0, q=1\n",
      "Chontos, HIRESr, H262, date=2021-06-18, dark=0, q=2\n",
      "Chontos, HIRESr, H262, date=2021-06-18, dark=0, q=3\n",
      "Chontos, HIRESr, H262, date=2021-06-18, dark=1, q=4\n",
      "Chontos, HIRESr, H262, date=2021-06-19, dark=0, q=1\n",
      "Chontos, HIRESr, H262, date=2021-06-19, dark=0, q=2\n",
      "Chontos, HIRESr, H262, date=2021-06-19, dark=0, q=3\n",
      "Chontos, HIRESr, H262, date=2021-06-19, dark=1, q=4\n",
      "Batalha, HIRESr, U111, date=2021-06-20, dark=0, q=1\n",
      "Batalha, HIRESr, U111, date=2021-06-20, dark=0, q=2\n",
      "Kleer, HIRESr, C294, date=2021-06-20, dark=0, q=3\n",
      "Kleer, HIRESr, C294, date=2021-06-20, dark=0, q=4\n",
      "Crossfield, HIRESr, N136, date=2021-06-21, dark=0, q=1\n",
      "Howard, HIRESr, N012, date=2021-06-21, dark=0, q=2\n",
      "Howard, HIRESr, N012, date=2021-06-21, dark=0, q=3\n",
      "Howard, HIRESr, N012, date=2021-06-21, dark=0, q=4\n",
      "Howard, HIRESr, C014, date=2021-06-22, dark=0, q=1\n",
      "Howard, HIRESr, C014, date=2021-06-22, dark=0, q=2\n",
      "Howard, HIRESr, C014, date=2021-06-22, dark=0, q=3\n",
      "Howard, HIRESr, C014, date=2021-06-22, dark=0, q=4\n",
      "Batalha, HIRESr, U111, date=2021-06-23, dark=0, q=1\n",
      "Batalha, HIRESr, U111, date=2021-06-23, dark=0, q=2\n",
      "Batalha, HIRESr, U111, date=2021-06-23, dark=0, q=3\n",
      "Batalha, HIRESr, U111, date=2021-06-23, dark=0, q=4\n",
      "Engineering, OSIRIS-LGS, E333, date=2021-06-24, dark=0, q=1\n",
      "Engineering, OSIRIS-LGS, E333, date=2021-06-24, dark=0, q=2\n",
      "Engineering, OSIRIS-LGS, E333, date=2021-06-24, dark=0, q=3\n",
      "Engineering, OSIRIS-LGS, E333, date=2021-06-24, dark=0, q=4\n",
      "Ruffio, OSIRIS-NGS, C292, date=2021-06-25, dark=0, q=1\n",
      "Ruffio, OSIRIS-NGS, C292, date=2021-06-25, dark=0, q=2\n",
      "Engineering, LRIS-ADC, E376, date=2021-06-25, dark=0, q=3\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Engineering, LRIS-ADC, E376, date=2021-06-25, dark=0, q=4\n",
      "Ruffio, OSIRIS-NGS, C292, date=2021-06-26, dark=0, q=1\n",
      "Ruffio, OSIRIS-NGS, C292, date=2021-06-26, dark=0, q=2\n",
      "Engineering, OSIRIS-LGS, E333, date=2021-06-26, dark=0, q=3\n",
      "Engineering, OSIRIS-LGS, E333, date=2021-06-26, dark=0, q=4\n",
      "Ruffio, OSIRIS-NGS, C292, date=2021-06-27, dark=1, q=1\n",
      "Ruffio, OSIRIS-NGS, C292, date=2021-06-27, dark=0, q=2\n",
      "Engineering, MOSFIRE, E395, date=2021-06-27, dark=0, q=3\n",
      "Engineering, MOSFIRE, E395, date=2021-06-27, dark=0, q=4\n",
      "Ravi, MOSFIRE, C310, date=2021-06-28, dark=1, q=1\n",
      "Ravi, MOSFIRE, C310, date=2021-06-28, dark=0, q=2\n",
      "Ravi, MOSFIRE, C310, date=2021-06-28, dark=0, q=3\n",
      "Ravi, MOSFIRE, C310, date=2021-06-28, dark=0, q=4\n",
      "Batalha, HIRESr, U111, date=2021-06-29, dark=1, q=1\n",
      "Batalha, HIRESr, U111, date=2021-06-29, dark=0, q=2\n",
      "Batalha, HIRESr, U111, date=2021-06-29, dark=0, q=3\n",
      "Batalha, HIRESr, U111, date=2021-06-29, dark=0, q=4\n",
      "Duchene, OSIRIS-NGS, U032, date=2021-06-30, dark=1, q=1\n",
      "Duchene, OSIRIS-NGS, U032, date=2021-06-30, dark=0, q=2\n",
      "Hodapp, MOSFIRE, H253, date=2021-06-30, dark=0, q=3\n",
      "Hodapp, MOSFIRE, H253, date=2021-06-30, dark=0, q=4\n",
      "Duchene, OSIRIS-NGS, U032, date=2021-07-01, dark=1, q=1\n",
      "Duchene, OSIRIS-NGS, U032, date=2021-07-01, dark=1, q=2\n",
      "Winn, HIRESr, N146, date=2021-07-01, dark=0, q=3\n",
      "Winn, HIRESr, N146, date=2021-07-01, dark=0, q=4\n",
      "Paterson, LRIS-ADC, O316, date=2021-07-02, dark=1, q=1\n",
      "Paterson, LRIS-ADC, O316, date=2021-07-02, dark=1, q=2\n",
      "Paterson, LRIS-ADC, O316, date=2021-07-02, dark=0, q=3\n",
      "Paterson, LRIS-ADC, O316, date=2021-07-02, dark=0, q=4\n",
      "Howard, HIRESr, C013, date=2021-07-03, dark=1, q=1\n",
      "Howard, HIRESr, C013, date=2021-07-03, dark=1, q=2\n",
      "Howard, HIRESr, C013, date=2021-07-03, dark=0, q=3\n",
      "Kleer, HIRESr, C294, date=2021-07-03, dark=0, q=4\n",
      "Prince, LRIS-ADC, C308, date=2021-07-04, dark=1, q=1\n",
      "Prince, LRIS-ADC, C308, date=2021-07-04, dark=1, q=2\n",
      "Prince, LRIS-ADC, C308, date=2021-07-04, dark=0, q=3\n",
      "Prince, LRIS-ADC, C308, date=2021-07-04, dark=0, q=4\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-07-05, dark=1, q=1\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-07-05, dark=1, q=2\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-07-05, dark=1, q=3\n",
      "Kulkarni, LRIS-ADC, C293, date=2021-07-05, dark=0, q=4\n",
      "Hallinan, LRIS-ADC, C302, date=2021-07-06, dark=1, q=1\n",
      "Hallinan, LRIS-ADC, C302, date=2021-07-06, dark=1, q=2\n",
      "Hallinan, LRIS-ADC, C302, date=2021-07-06, dark=1, q=3\n",
      "Hallinan, LRIS-ADC, C302, date=2021-07-06, dark=0, q=4\n",
      "Foley, LRIS-ADC, U089, date=2021-07-07, dark=1, q=1\n",
      "Foley, LRIS-ADC, U089, date=2021-07-07, dark=1, q=2\n",
      "Foley, LRIS-ADC, U089, date=2021-07-07, dark=1, q=3\n",
      "Foley, LRIS-ADC, U089, date=2021-07-07, dark=0, q=4\n",
      "Andreoni, LRIS-ADC, C277, date=2021-07-08, dark=1, q=1\n",
      "Andreoni, LRIS-ADC, C277, date=2021-07-08, dark=1, q=2\n",
      "Weiss, HIRESr, N048, date=2021-07-08, dark=1, q=3\n",
      "Weiss, HIRESr, N048, date=2021-07-08, dark=1, q=4\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-09, dark=1, q=1\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-09, dark=1, q=2\n",
      "Weiss, HIRESr, N048, date=2021-07-09, dark=1, q=3\n",
      "Weiss, HIRESr, N048, date=2021-07-09, dark=1, q=4\n",
      "Weiss, HIRESr, H047, date=2021-07-10, dark=0, q=1\n",
      "Weiss, HIRESr, H047, date=2021-07-10, dark=1, q=2\n",
      "Weiss, HIRESr, H047, date=2021-07-10, dark=1, q=3\n",
      "Weiss, HIRESr, H047, date=2021-07-10, dark=1, q=4\n",
      "Weiss, HIRESr, H047, date=2021-07-11, dark=0, q=1\n",
      "Weiss, HIRESr, H047, date=2021-07-11, dark=1, q=2\n",
      "Weiss, HIRESr, H047, date=2021-07-11, dark=1, q=3\n",
      "Weiss, HIRESr, H047, date=2021-07-11, dark=1, q=4\n",
      "Bennett, OSIRIS-LGS, N164, date=2021-07-12, dark=0, q=1\n",
      "Bennett, OSIRIS-LGS, N164, date=2021-07-12, dark=1, q=2\n",
      "Batalha, HIRESr, U111, date=2021-07-12, dark=1, q=3\n",
      "Batalha, HIRESr, U111, date=2021-07-12, dark=1, q=4\n",
      "Bennett, OSIRIS-LGS, N164, date=2021-07-13, dark=0, q=1\n",
      "Bennett, OSIRIS-LGS, N164, date=2021-07-13, dark=1, q=2\n",
      "Howard, HIRESr, N012, date=2021-07-13, dark=1, q=3\n",
      "Howard, HIRESr, N012, date=2021-07-13, dark=1, q=4\n",
      "Caiazzo, LRIS-ADC, C291, date=2021-07-14, dark=0, q=1\n",
      "Caiazzo, LRIS-ADC, C291, date=2021-07-14, dark=0, q=2\n",
      "Caiazzo, LRIS-ADC, C291, date=2021-07-14, dark=1, q=3\n",
      "Caiazzo, LRIS-ADC, C291, date=2021-07-14, dark=1, q=4\n",
      "Howard, HIRESr, C013, date=2021-07-15, dark=0, q=1\n",
      "Kleer, HIRESr, C294, date=2021-07-15, dark=0, q=2\n",
      "Kleer, HIRESr, C294, date=2021-07-15, dark=1, q=3\n",
      "Howard, HIRESr, C013, date=2021-07-15, dark=1, q=4\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-16, dark=0, q=1\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-16, dark=0, q=2\n",
      "Batalha, HIRESr, U111, date=2021-07-16, dark=1, q=3\n",
      "Batalha, HIRESr, U111, date=2021-07-16, dark=1, q=4\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-17, dark=0, q=1\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-17, dark=0, q=2\n",
      "Batalha, HIRESr, U111, date=2021-07-17, dark=0, q=3\n",
      "Batalha, HIRESr, U111, date=2021-07-17, dark=1, q=4\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-18, dark=0, q=1\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-18, dark=0, q=2\n",
      "Batalha, HIRESr, U111, date=2021-07-18, dark=0, q=3\n",
      "Batalha, HIRESr, U111, date=2021-07-18, dark=1, q=4\n",
      "Weiss, HIRESr, N048, date=2021-07-19, dark=0, q=1\n",
      "Weiss, HIRESr, N048, date=2021-07-19, dark=0, q=2\n",
      "Pater, HIRESr, U027, date=2021-07-19, dark=0, q=3\n",
      "Pater, HIRESr, U027, date=2021-07-19, dark=1, q=4\n",
      "Weiss, HIRESr, N048, date=2021-07-20, dark=0, q=1\n",
      "Weiss, HIRESr, N048, date=2021-07-20, dark=0, q=2\n",
      "Pater, HIRESr, U027, date=2021-07-20, dark=0, q=3\n",
      "Pater, HIRESr, U027, date=2021-07-20, dark=0, q=4\n",
      "Weiss, HIRESr, H047, date=2021-07-21, dark=0, q=1\n",
      "Weiss, HIRESr, H047, date=2021-07-21, dark=0, q=2\n",
      "Weiss, HIRESr, H047, date=2021-07-21, dark=0, q=3\n",
      "Weiss, HIRESr, H047, date=2021-07-21, dark=0, q=4\n",
      "Weiss, HIRESr, H047, date=2021-07-22, dark=0, q=1\n",
      "Weiss, HIRESr, H047, date=2021-07-22, dark=0, q=2\n",
      "Weiss, HIRESr, H047, date=2021-07-22, dark=0, q=3\n",
      "Weiss, HIRESr, H047, date=2021-07-22, dark=0, q=4\n",
      "Crossfield, HIRESr, N180, date=2021-07-23, dark=0, q=1\n",
      "Howard, HIRESr, N012, date=2021-07-23, dark=0, q=2\n",
      "Howard, HIRESr, N012, date=2021-07-23, dark=0, q=3\n",
      "Howard, HIRESr, N012, date=2021-07-23, dark=0, q=4\n",
      "Howard, HIRESr, C013, date=2021-07-24, dark=0, q=1\n",
      "Howard, HIRESr, C013, date=2021-07-24, dark=0, q=2\n",
      "Howard, HIRESr, C013, date=2021-07-24, dark=0, q=3\n",
      "Howard, HIRESr, C013, date=2021-07-24, dark=0, q=4\n",
      "Engineering, OSIRIS-LGS, E333, date=2021-07-25, dark=0, q=1\n",
      "Engineering, OSIRIS-LGS, E333, date=2021-07-25, dark=0, q=2\n",
      "Howard, HIRESr, C013, date=2021-07-25, dark=0, q=3\n",
      "Howard, HIRESr, C013, date=2021-07-25, dark=0, q=4\n",
      "Weiss, HIRESr, N048, date=2021-07-26, dark=0, q=1\n",
      "Weiss, HIRESr, N048, date=2021-07-26, dark=0, q=2\n",
      "Weiss, HIRESr, N048, date=2021-07-26, dark=0, q=3\n",
      "Weiss, HIRESr, N048, date=2021-07-26, dark=0, q=4\n",
      "Engineering, LRIS-ADC, E376, date=2021-07-27, dark=1, q=1\n",
      "Engineering, LRIS-ADC, E376, date=2021-07-27, dark=0, q=2\n",
      "Konopacky, OSIRIS-NGS, U079, date=2021-07-27, dark=0, q=3\n",
      "Konopacky, OSIRIS-NGS, U079, date=2021-07-27, dark=0, q=4\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-28, dark=1, q=1\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-28, dark=0, q=2\n",
      "Konopacky, OSIRIS-NGS, U079, date=2021-07-28, dark=0, q=3\n",
      "Konopacky, OSIRIS-NGS, U079, date=2021-07-28, dark=0, q=4\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-29, dark=1, q=1\n",
      "Ghez, OSIRIS-LGS, U017, date=2021-07-29, dark=0, q=2\n",
      "Konopacky, OSIRIS-NGS, U079, date=2021-07-29, dark=0, q=3\n",
      "Konopacky, OSIRIS-NGS, U079, date=2021-07-29, dark=0, q=4\n",
      "Crossfield, HIRESr, N180, date=2021-07-30, dark=1, q=1\n",
      "Howard, HIRESr, N012, date=2021-07-30, dark=0, q=2\n",
      "Howard, HIRESr, N012, date=2021-07-30, dark=0, q=3\n",
      "Howard, HIRESr, N012, date=2021-07-30, dark=0, q=4\n",
      "Hillenbrand, HIRESr, C283, date=2021-07-31, dark=1, q=1\n",
      "Hillenbrand, HIRESr, C283, date=2021-07-31, dark=1, q=2\n",
      "Hillenbrand, HIRESr, C283, date=2021-07-31, dark=0, q=3\n",
      "Hillenbrand, HIRESr, C283, date=2021-07-31, dark=0, q=4\n"
     ]
    }
   ],
   "source": [
    "dates = sched_cj.Date.drop_duplicates()\n",
    "df_cj = sched_cj.groupby(['Date','quarter']).first()\n",
    "df_cc = sched_cc.groupby(['Date','quarter']).first()\n",
    "df_cj_night = sched_cj_night.groupby(['Date']).first()\n",
    "\n",
    "df_out = pd.DataFrame(index=dates)\n",
    "for date in dates:\n",
    "    df_out.loc[date,'dark'] = df_cj_night.loc[date,'Dark']\n",
    "    for quarter in range(1,5):\n",
    "        row = df_cj.loc[date,quarter]\n",
    "        d = dict(**row)\n",
    "        d['dark'] = int(d['dark'])\n",
    "        d['date'] = date\n",
    "        d['quarter'] = quarter\n",
    "        s = \"{PIlast:}, {Instrument}, {ProjCode}, date={date}, dark={dark}, q={quarter}\".format(**d)\n",
    "        df_out.loc[date,'schedule_old{}'.format(quarter)] = s\n",
    "        df_out.loc[date,'dark{}'.format(quarter)] = int(row.dark)\n",
    "\n",
    "        df_out.loc[date,'kpfcc{}'.format(quarter)] = int(df_cc.loc[date,quarter].kpfcc)\n",
    "        df_out.loc[date,'schedule_new{}'.format(quarter)] = ''\n",
    "        print(s)\n",
    "        \n",
    "for quarter in range(1,5):\n",
    "    df_out.loc[:,'dark{}'.format(quarter)] = df_out.loc[:,'dark{}'.format(quarter)].astype(int)\n",
    "    \n",
    "df_out['x'] = '' # blank for spacing \n",
    "\n",
    "cols = []\n",
    "cols+=['dark']\n",
    "for i in range(1,5):\n",
    "    cols += ['schedule_old{}'.format(i),'dark{}'.format(i)]\n",
    "\n",
    "cols += ['x']\n",
    "for i in range(1,5):\n",
    "    cols += ['kpfcc{}'.format(i)]\n",
    "    cols += ['schedule_new{}'.format(i)]\n",
    "    cols += ['x']*3 # three blank columns\n",
    "    \n",
    "df_out[cols].to_excel('2021A_mock-schedule.xlsx')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}