Texas_Cohorts

Quarto

Quarto enables you to weave together content and executable code into a finished document. To learn more about Quarto see https://quarto.org.

#Importing Data

library(readxl)
library(dplyr)

Attaching package: 'dplyr'
The following objects are masked from 'package:stats':

    filter, lag
The following objects are masked from 'package:base':

    intersect, setdiff, setequal, union
library(lubridate)

Attaching package: 'lubridate'
The following objects are masked from 'package:base':

    date, intersect, setdiff, union
library(ggplot2)
library(DT)

# Load Data
Texas_Pop_2016 <- read_excel("~/Library/CloudStorage/Box-Box/Company/Working files/LPT & Aging in Prison/Texas/Texas.Data.PIA/CY2016/On Hand Inmate Data 0716.xlsx")
Texas_Pop_2017 <- read_excel("~/Library/CloudStorage/Box-Box/Company/Working files/LPT & Aging in Prison/Texas/Texas.Data.PIA/CY2017/On Hand Inmate Data 0717.xlsx")
Texas_Pop_2018 <- read_excel("~/Library/CloudStorage/Box-Box/Company/Working files/LPT & Aging in Prison/Texas/Texas.Data.PIA/CY2018/On Hand Inmate Data 0718.xlsx")
Texas_Pop_2019 <- read_excel("~/Library/CloudStorage/Box-Box/Company/Working files/LPT & Aging in Prison/Texas/Texas.Data.PIA/CY2019/On Hand Inmate Data 0719.xlsx")
Texas_Pop_2020 <- read_excel("~/Library/CloudStorage/Box-Box/Company/Working files/LPT & Aging in Prison/Texas/Texas.Data.PIA/CY2020/On Hand Inmate Data 0720.xlsx")
Warning: Expecting date in H1219 / R1219C8: got '#NULL!'
Warning: Expecting date in I1219 / R1219C9: got '#NULL!'
Warning: Expecting date in O1377 / R1377C15: got '#NULL!'
Warning: Expecting date in O1485 / R1485C15: got '#NULL!'
Warning: Expecting date in H1775 / R1775C8: got '#NULL!'
Warning: Expecting date in I1775 / R1775C9: got '#NULL!'
Warning: Expecting date in O1824 / R1824C15: got '#NULL!'
Warning: Expecting date in I1969 / R1969C9: got '#NULL!'
Warning: Expecting date in O1969 / R1969C15: got '#NULL!'
Warning: Expecting date in O2453 / R2453C15: got '#NULL!'
Warning: Expecting date in O2556 / R2556C15: got '#NULL!'
Warning: Expecting date in O2769 / R2769C15: got '#NULL!'
Warning: Expecting date in O3604 / R3604C15: got '#NULL!'
Warning: Expecting date in O3975 / R3975C15: got '#NULL!'
Warning: Expecting date in O4009 / R4009C15: got '#NULL!'
Warning: Expecting date in H4270 / R4270C8: got '#NULL!'
Warning: Expecting date in I4270 / R4270C9: got '#NULL!'
Warning: Expecting date in I4578 / R4578C9: got '#NULL!'
Warning: Expecting date in O4578 / R4578C15: got '#NULL!'
Warning: Expecting date in O4799 / R4799C15: got '#NULL!'
Warning: Expecting date in O5042 / R5042C15: got '#NULL!'
Warning: Expecting date in H5108 / R5108C8: got '#NULL!'
Warning: Expecting date in I5108 / R5108C9: got '#NULL!'
Warning: Expecting date in O5277 / R5277C15: got '#NULL!'
Warning: Expecting date in O5432 / R5432C15: got '#NULL!'
Warning: Expecting date in O5443 / R5443C15: got '#NULL!'
Warning: Expecting date in O5468 / R5468C15: got '#NULL!'
Warning: Expecting date in O5799 / R5799C15: got '#NULL!'
Warning: Expecting date in O5854 / R5854C15: got '#NULL!'
Warning: Expecting date in O6232 / R6232C15: got '#NULL!'
Warning: Expecting date in O6251 / R6251C15: got '#NULL!'
Warning: Expecting date in O6304 / R6304C15: got '#NULL!'
Warning: Expecting date in O6488 / R6488C15: got '#NULL!'
Warning: Expecting date in O6606 / R6606C15: got '#NULL!'
Warning: Expecting date in O6974 / R6974C15: got '#NULL!'
Warning: Expecting date in O7160 / R7160C15: got '#NULL!'
Warning: Expecting date in O7613 / R7613C15: got '#NULL!'
Warning: Expecting date in O8199 / R8199C15: got '#NULL!'
Warning: Expecting date in O8490 / R8490C15: got '#NULL!'
Warning: Expecting date in O8667 / R8667C15: got '#NULL!'
Warning: Expecting date in O8904 / R8904C15: got '#NULL!'
Warning: Expecting date in O8927 / R8927C15: got '#NULL!'
Warning: Expecting date in O9063 / R9063C15: got '#NULL!'
Warning: Expecting date in O9879 / R9879C15: got '#NULL!'
Warning: Expecting date in O9942 / R9942C15: got '#NULL!'
Warning: Expecting date in O10593 / R10593C15: got '#NULL!'
Warning: Expecting date in O10687 / R10687C15: got '#NULL!'
Warning: Expecting date in O10925 / R10925C15: got '#NULL!'
Warning: Expecting date in O11083 / R11083C15: got '#NULL!'
Warning: Expecting date in O11180 / R11180C15: got '#NULL!'
Warning: Expecting date in O11238 / R11238C15: got '#NULL!'
Warning: Expecting date in O11439 / R11439C15: got '#NULL!'
Warning: Expecting date in O11492 / R11492C15: got '#NULL!'
Warning: Expecting date in O11764 / R11764C15: got '#NULL!'
Warning: Expecting date in O11877 / R11877C15: got '#NULL!'
Warning: Expecting date in O11973 / R11973C15: got '#NULL!'
Warning: Expecting date in O12587 / R12587C15: got '#NULL!'
Warning: Expecting date in O13318 / R13318C15: got '#NULL!'
Warning: Expecting date in O13377 / R13377C15: got '#NULL!'
Warning: Expecting date in O13394 / R13394C15: got '#NULL!'
Warning: Expecting date in O13938 / R13938C15: got '#NULL!'
Warning: Expecting date in O13999 / R13999C15: got '#NULL!'
Warning: Expecting date in O14031 / R14031C15: got '#NULL!'
Warning: Expecting date in O14316 / R14316C15: got '#NULL!'
Warning: Expecting date in O14365 / R14365C15: got '#NULL!'
Warning: Expecting date in O14813 / R14813C15: got '#NULL!'
Warning: Expecting date in O14886 / R14886C15: got '#NULL!'
Warning: Expecting date in O15176 / R15176C15: got '#NULL!'
Warning: Expecting date in O15246 / R15246C15: got '#NULL!'
Warning: Expecting date in O16056 / R16056C15: got '#NULL!'
Warning: Expecting date in H16063 / R16063C8: got '#NULL!'
Warning: Expecting date in I16063 / R16063C9: got '#NULL!'
Warning: Expecting date in O16210 / R16210C15: got '#NULL!'
Warning: Expecting date in O16412 / R16412C15: got '#NULL!'
Warning: Expecting date in O16472 / R16472C15: got '#NULL!'
Warning: Expecting date in O16652 / R16652C15: got '#NULL!'
Warning: Expecting date in O16776 / R16776C15: got '#NULL!'
Warning: Expecting date in O17004 / R17004C15: got '#NULL!'
Warning: Expecting date in O17153 / R17153C15: got '#NULL!'
Warning: Expecting date in O17161 / R17161C15: got '#NULL!'
Warning: Expecting date in O17303 / R17303C15: got '#NULL!'
Warning: Expecting date in O17550 / R17550C15: got '#NULL!'
Warning: Expecting date in O17622 / R17622C15: got '#NULL!'
Warning: Expecting date in O17768 / R17768C15: got '#NULL!'
Warning: Expecting date in O17830 / R17830C15: got '#NULL!'
Warning: Expecting date in O17835 / R17835C15: got '#NULL!'
Warning: Expecting date in O17971 / R17971C15: got '#NULL!'
Warning: Expecting date in O18046 / R18046C15: got '#NULL!'
Warning: Expecting date in O18124 / R18124C15: got '#NULL!'
Warning: Expecting date in O18220 / R18220C15: got '#NULL!'
Warning: Expecting date in O18380 / R18380C15: got '#NULL!'
Warning: Expecting date in O18411 / R18411C15: got '#NULL!'
Warning: Expecting date in O18633 / R18633C15: got '#NULL!'
Warning: Expecting date in O18672 / R18672C15: got '#NULL!'
Warning: Expecting date in O18717 / R18717C15: got '#NULL!'
Warning: Expecting date in O18833 / R18833C15: got '#NULL!'
Warning: Expecting date in O18888 / R18888C15: got '#NULL!'
Warning: Expecting date in O18928 / R18928C15: got '#NULL!'
Warning: Expecting date in O19137 / R19137C15: got '#NULL!'
Warning: Expecting date in O19157 / R19157C15: got '#NULL!'
Warning: Expecting date in O19720 / R19720C15: got '#NULL!'
Warning: Expecting date in O19848 / R19848C15: got '#NULL!'
Warning: Expecting date in O19857 / R19857C15: got '#NULL!'
Warning: Expecting date in O19879 / R19879C15: got '#NULL!'
Warning: Expecting date in O20031 / R20031C15: got '#NULL!'
Warning: Expecting date in O20082 / R20082C15: got '#NULL!'
Warning: Expecting date in O20208 / R20208C15: got '#NULL!'
Warning: Expecting date in O20329 / R20329C15: got '#NULL!'
Warning: Expecting date in O20545 / R20545C15: got '#NULL!'
Warning: Expecting date in O20613 / R20613C15: got '#NULL!'
Warning: Expecting date in O20727 / R20727C15: got '#NULL!'
Warning: Expecting date in O21154 / R21154C15: got '#NULL!'
Warning: Expecting date in O21343 / R21343C15: got '#NULL!'
Warning: Expecting date in O21513 / R21513C15: got '#NULL!'
Warning: Expecting date in O21694 / R21694C15: got '#NULL!'
Warning: Expecting date in O21913 / R21913C15: got '#NULL!'
Warning: Expecting date in O22068 / R22068C15: got '#NULL!'
Warning: Expecting date in O22376 / R22376C15: got '#NULL!'
Warning: Expecting date in O22474 / R22474C15: got '#NULL!'
Warning: Expecting date in O22547 / R22547C15: got '#NULL!'
Warning: Expecting date in O22731 / R22731C15: got '#NULL!'
Warning: Expecting date in O23039 / R23039C15: got '#NULL!'
Warning: Expecting date in O23120 / R23120C15: got '#NULL!'
Warning: Expecting date in O23396 / R23396C15: got '#NULL!'
Warning: Expecting date in O23592 / R23592C15: got '#NULL!'
Warning: Expecting date in O23736 / R23736C15: got '#NULL!'
Warning: Expecting date in O23831 / R23831C15: got '#NULL!'
Warning: Expecting date in O23899 / R23899C15: got '#NULL!'
Warning: Expecting date in O24087 / R24087C15: got '#NULL!'
Warning: Expecting date in O24135 / R24135C15: got '#NULL!'
Warning: Expecting date in O24142 / R24142C15: got '#NULL!'
Warning: Expecting date in O24164 / R24164C15: got '#NULL!'
Warning: Expecting date in O24252 / R24252C15: got '#NULL!'
Warning: Expecting date in O24488 / R24488C15: got '#NULL!'
Warning: Expecting date in O24840 / R24840C15: got '#NULL!'
Warning: Expecting date in O24984 / R24984C15: got '#NULL!'
Warning: Expecting date in O25291 / R25291C15: got '#NULL!'
Warning: Expecting date in O25556 / R25556C15: got '#NULL!'
Warning: Expecting date in O25702 / R25702C15: got '#NULL!'
Warning: Expecting date in O25932 / R25932C15: got '#NULL!'
Warning: Expecting date in O26127 / R26127C15: got '#NULL!'
Warning: Expecting date in O26861 / R26861C15: got '#NULL!'
Warning: Expecting date in O26874 / R26874C15: got '#NULL!'
Warning: Expecting date in O27116 / R27116C15: got '#NULL!'
Warning: Expecting date in O27173 / R27173C15: got '#NULL!'
Warning: Expecting date in O27188 / R27188C15: got '#NULL!'
Warning: Expecting date in O27489 / R27489C15: got '#NULL!'
Warning: Expecting date in O27517 / R27517C15: got '#NULL!'
Warning: Expecting date in O27526 / R27526C15: got '#NULL!'
Warning: Expecting date in O27554 / R27554C15: got '#NULL!'
Warning: Expecting date in O27876 / R27876C15: got '#NULL!'
Warning: Expecting date in O27926 / R27926C15: got '#NULL!'
Warning: Expecting date in O27973 / R27973C15: got '#NULL!'
Warning: Expecting date in O28342 / R28342C15: got '#NULL!'
Warning: Expecting date in O28396 / R28396C15: got '#NULL!'
Warning: Expecting date in O28466 / R28466C15: got '#NULL!'
Warning: Expecting date in O28528 / R28528C15: got '#NULL!'
Warning: Expecting date in O28657 / R28657C15: got '#NULL!'
Warning: Expecting date in O28761 / R28761C15: got '#NULL!'
Warning: Expecting date in O28771 / R28771C15: got '#NULL!'
Warning: Expecting date in O28773 / R28773C15: got '#NULL!'
Warning: Expecting date in O28935 / R28935C15: got '#NULL!'
Warning: Expecting date in O28991 / R28991C15: got '#NULL!'
Warning: Expecting date in O28994 / R28994C15: got '#NULL!'
Warning: Expecting date in O28997 / R28997C15: got '#NULL!'
Warning: Expecting date in O29023 / R29023C15: got '#NULL!'
Warning: Expecting date in O29078 / R29078C15: got '#NULL!'
Warning: Expecting date in O29131 / R29131C15: got '#NULL!'
Warning: Expecting date in O29132 / R29132C15: got '#NULL!'
Warning: Expecting date in O29199 / R29199C15: got '#NULL!'
Warning: Expecting date in O29238 / R29238C15: got '#NULL!'
Warning: Expecting date in O29272 / R29272C15: got '#NULL!'
Warning: Expecting date in O29499 / R29499C15: got '#NULL!'
Warning: Expecting date in O29554 / R29554C15: got '#NULL!'
Warning: Expecting date in O29604 / R29604C15: got '#NULL!'
Warning: Expecting date in O29663 / R29663C15: got '#NULL!'
Warning: Expecting date in O29694 / R29694C15: got '#NULL!'
Warning: Expecting date in O29736 / R29736C15: got '#NULL!'
Warning: Expecting date in O29930 / R29930C15: got '#NULL!'
Warning: Expecting date in O30031 / R30031C15: got '#NULL!'
Warning: Expecting date in O30161 / R30161C15: got '#NULL!'
Warning: Expecting date in O30202 / R30202C15: got '#NULL!'
Warning: Expecting date in O30405 / R30405C15: got '#NULL!'
Warning: Expecting date in O30729 / R30729C15: got '#NULL!'
Warning: Expecting date in O30888 / R30888C15: got '#NULL!'
Warning: Expecting date in O31042 / R31042C15: got '#NULL!'
Warning: Expecting date in O31249 / R31249C15: got '#NULL!'
Warning: Expecting date in O31514 / R31514C15: got '#NULL!'
Warning: Expecting date in O31599 / R31599C15: got '#NULL!'
Warning: Expecting date in O31613 / R31613C15: got '#NULL!'
Warning: Expecting date in O31678 / R31678C15: got '#NULL!'
Warning: Expecting date in O31834 / R31834C15: got '#NULL!'
Warning: Expecting date in O31860 / R31860C15: got '#NULL!'
Warning: Expecting date in O32428 / R32428C15: got '#NULL!'
Warning: Expecting date in O33004 / R33004C15: got '#NULL!'
Warning: Expecting date in O33165 / R33165C15: got '#NULL!'
Warning: Expecting date in O33211 / R33211C15: got '#NULL!'
Warning: Expecting date in O33228 / R33228C15: got '#NULL!'
Warning: Expecting date in O33315 / R33315C15: got '#NULL!'
Warning: Expecting date in O33647 / R33647C15: got '#NULL!'
Warning: Expecting date in O33960 / R33960C15: got '#NULL!'
Warning: Expecting date in O34302 / R34302C15: got '#NULL!'
Warning: Expecting date in O34745 / R34745C15: got '#NULL!'
Warning: Expecting date in O34926 / R34926C15: got '#NULL!'
Warning: Expecting date in O35048 / R35048C15: got '#NULL!'
Warning: Expecting date in O35061 / R35061C15: got '#NULL!'
Warning: Expecting date in O35185 / R35185C15: got '#NULL!'
Warning: Expecting date in O35224 / R35224C15: got '#NULL!'
Warning: Expecting date in O35349 / R35349C15: got '#NULL!'
Warning: Expecting date in O35390 / R35390C15: got '#NULL!'
Warning: Expecting date in O35565 / R35565C15: got '#NULL!'
Warning: Expecting date in O35665 / R35665C15: got '#NULL!'
Warning: Expecting date in O35707 / R35707C15: got '#NULL!'
Warning: Expecting date in O35737 / R35737C15: got '#NULL!'
Warning: Expecting date in O35973 / R35973C15: got '#NULL!'
Warning: Expecting date in O35982 / R35982C15: got '#NULL!'
Warning: Expecting date in O36249 / R36249C15: got '#NULL!'
Warning: Expecting date in O36673 / R36673C15: got '#NULL!'
Warning: Expecting date in O36917 / R36917C15: got '#NULL!'
Warning: Expecting date in O36972 / R36972C15: got '#NULL!'
Warning: Expecting date in O37026 / R37026C15: got '#NULL!'
Warning: Expecting date in O37156 / R37156C15: got '#NULL!'
Warning: Expecting date in O37163 / R37163C15: got '#NULL!'
Warning: Expecting date in O37288 / R37288C15: got '#NULL!'
Warning: Expecting date in O37818 / R37818C15: got '#NULL!'
Warning: Expecting date in O37909 / R37909C15: got '#NULL!'
Warning: Expecting date in O37986 / R37986C15: got '#NULL!'
Warning: Expecting date in O37997 / R37997C15: got '#NULL!'
Warning: Expecting date in O38000 / R38000C15: got '#NULL!'
Warning: Expecting date in O38037 / R38037C15: got '#NULL!'
Warning: Expecting date in O38073 / R38073C15: got '#NULL!'
Warning: Expecting date in O38231 / R38231C15: got '#NULL!'
Warning: Expecting date in O38491 / R38491C15: got '#NULL!'
Warning: Expecting date in O38528 / R38528C15: got '#NULL!'
Warning: Expecting date in O38589 / R38589C15: got '#NULL!'
Warning: Expecting date in O38688 / R38688C15: got '#NULL!'
Warning: Expecting date in O38705 / R38705C15: got '#NULL!'
Warning: Expecting date in O38737 / R38737C15: got '#NULL!'
Warning: Expecting date in O38993 / R38993C15: got '#NULL!'
Warning: Expecting date in O38995 / R38995C15: got '#NULL!'
Warning: Expecting date in O39003 / R39003C15: got '#NULL!'
Warning: Expecting date in O39053 / R39053C15: got '#NULL!'
Warning: Expecting date in O39302 / R39302C15: got '#NULL!'
Warning: Expecting date in O39389 / R39389C15: got '#NULL!'
Warning: Expecting date in O39437 / R39437C15: got '#NULL!'
Warning: Expecting date in O39482 / R39482C15: got '#NULL!'
Warning: Expecting date in O39750 / R39750C15: got '#NULL!'
Warning: Expecting date in O39828 / R39828C15: got '#NULL!'
Warning: Expecting date in O39995 / R39995C15: got '#NULL!'
Warning: Expecting date in O40354 / R40354C15: got '#NULL!'
Warning: Expecting date in O40426 / R40426C15: got '#NULL!'
Warning: Expecting date in O40685 / R40685C15: got '#NULL!'
Warning: Expecting date in O40759 / R40759C15: got '#NULL!'
Warning: Expecting date in O40857 / R40857C15: got '#NULL!'
Warning: Expecting date in O41291 / R41291C15: got '#NULL!'
Warning: Expecting date in O41335 / R41335C15: got '#NULL!'
Warning: Expecting date in O41445 / R41445C15: got '#NULL!'
Warning: Expecting date in O41475 / R41475C15: got '#NULL!'
Warning: Expecting date in O41515 / R41515C15: got '#NULL!'
Warning: Expecting date in O41532 / R41532C15: got '#NULL!'
Warning: Expecting date in O41542 / R41542C15: got '#NULL!'
Warning: Expecting date in O41560 / R41560C15: got '#NULL!'
Warning: Expecting date in O41639 / R41639C15: got '#NULL!'
Warning: Expecting date in O41869 / R41869C15: got '#NULL!'
Warning: Expecting date in O41990 / R41990C15: got '#NULL!'
Warning: Expecting date in O42136 / R42136C15: got '#NULL!'
Warning: Expecting date in O42184 / R42184C15: got '#NULL!'
Warning: Expecting date in O42233 / R42233C15: got '#NULL!'
Warning: Expecting date in O42237 / R42237C15: got '#NULL!'
Warning: Expecting date in O42260 / R42260C15: got '#NULL!'
Warning: Expecting date in O42366 / R42366C15: got '#NULL!'
Warning: Expecting date in O42457 / R42457C15: got '#NULL!'
Warning: Expecting date in O42634 / R42634C15: got '#NULL!'
Warning: Expecting date in O42703 / R42703C15: got '#NULL!'
Warning: Expecting date in O42715 / R42715C15: got '#NULL!'
Warning: Expecting date in O42763 / R42763C15: got '#NULL!'
Warning: Expecting date in O42864 / R42864C15: got '#NULL!'
Warning: Expecting date in O42881 / R42881C15: got '#NULL!'
Warning: Expecting date in O42910 / R42910C15: got '#NULL!'
Warning: Expecting date in O42929 / R42929C15: got '#NULL!'
Warning: Expecting date in O43014 / R43014C15: got '#NULL!'
Warning: Expecting date in O43054 / R43054C15: got '#NULL!'
Warning: Expecting date in O43361 / R43361C15: got '#NULL!'
Warning: Expecting date in O43366 / R43366C15: got '#NULL!'
Warning: Expecting date in O43625 / R43625C15: got '#NULL!'
Warning: Expecting date in O43678 / R43678C15: got '#NULL!'
Warning: Expecting date in O43695 / R43695C15: got '#NULL!'
Warning: Expecting date in O43772 / R43772C15: got '#NULL!'
Warning: Expecting date in O44002 / R44002C15: got '#NULL!'
Warning: Expecting date in O44095 / R44095C15: got '#NULL!'
Warning: Expecting date in O44189 / R44189C15: got '#NULL!'
Warning: Expecting date in O44251 / R44251C15: got '#NULL!'
Warning: Expecting date in O44287 / R44287C15: got '#NULL!'
Warning: Expecting date in O44295 / R44295C15: got '#NULL!'
Warning: Expecting date in O44407 / R44407C15: got '#NULL!'
Warning: Expecting date in O44528 / R44528C15: got '#NULL!'
Warning: Expecting date in O44541 / R44541C15: got '#NULL!'
Warning: Expecting date in O44550 / R44550C15: got '#NULL!'
Warning: Expecting date in O44679 / R44679C15: got '#NULL!'
Warning: Expecting date in O44776 / R44776C15: got '#NULL!'
Warning: Expecting date in O44787 / R44787C15: got '#NULL!'
Warning: Expecting date in O44841 / R44841C15: got '#NULL!'
Warning: Expecting date in O44911 / R44911C15: got '#NULL!'
Warning: Expecting date in O44924 / R44924C15: got '#NULL!'
Warning: Expecting date in O44935 / R44935C15: got '#NULL!'
Warning: Expecting date in O45042 / R45042C15: got '#NULL!'
Warning: Expecting date in O45146 / R45146C15: got '#NULL!'
Warning: Expecting date in O45175 / R45175C15: got '#NULL!'
Warning: Expecting date in O45500 / R45500C15: got '#NULL!'
Warning: Expecting date in O45615 / R45615C15: got '#NULL!'
Warning: Expecting date in O45710 / R45710C15: got '#NULL!'
Warning: Expecting date in O45838 / R45838C15: got '#NULL!'
Warning: Expecting date in O45839 / R45839C15: got '#NULL!'
Warning: Expecting date in O46104 / R46104C15: got '#NULL!'
Warning: Expecting date in O46354 / R46354C15: got '#NULL!'
Warning: Expecting date in O46367 / R46367C15: got '#NULL!'
Warning: Expecting date in O46488 / R46488C15: got '#NULL!'
Warning: Expecting date in O46579 / R46579C15: got '#NULL!'
Warning: Expecting date in O47091 / R47091C15: got '#NULL!'
Warning: Expecting date in O47135 / R47135C15: got '#NULL!'
Warning: Expecting date in O47284 / R47284C15: got '#NULL!'
Warning: Expecting date in O47477 / R47477C15: got '#NULL!'
Warning: Expecting date in O47741 / R47741C15: got '#NULL!'
Warning: Expecting date in O47894 / R47894C15: got '#NULL!'
Warning: Expecting date in O47932 / R47932C15: got '#NULL!'
Warning: Expecting date in O48130 / R48130C15: got '#NULL!'
Warning: Expecting date in O48198 / R48198C15: got '#NULL!'
Warning: Expecting date in O48226 / R48226C15: got '#NULL!'
Warning: Expecting date in O48322 / R48322C15: got '#NULL!'
Warning: Expecting date in O48459 / R48459C15: got '#NULL!'
Warning: Expecting date in O48512 / R48512C15: got '#NULL!'
Warning: Expecting date in O48810 / R48810C15: got '#NULL!'
Warning: Expecting date in O48857 / R48857C15: got '#NULL!'
Warning: Expecting date in O49026 / R49026C15: got '#NULL!'
Warning: Expecting date in O49186 / R49186C15: got '#NULL!'
Warning: Expecting date in O49228 / R49228C15: got '#NULL!'
Warning: Expecting date in O49233 / R49233C15: got '#NULL!'
Warning: Expecting date in O49246 / R49246C15: got '#NULL!'
Warning: Expecting date in O49340 / R49340C15: got '#NULL!'
Warning: Expecting date in O49400 / R49400C15: got '#NULL!'
Warning: Expecting date in O49524 / R49524C15: got '#NULL!'
Warning: Expecting date in O49654 / R49654C15: got '#NULL!'
Warning: Expecting date in O49744 / R49744C15: got '#NULL!'
Warning: Expecting date in O49799 / R49799C15: got '#NULL!'
Warning: Expecting date in O49802 / R49802C15: got '#NULL!'
Warning: Expecting date in O49956 / R49956C15: got '#NULL!'
Warning: Expecting date in O50014 / R50014C15: got '#NULL!'
Warning: Expecting date in O50128 / R50128C15: got '#NULL!'
Warning: Expecting date in O50226 / R50226C15: got '#NULL!'
Warning: Expecting date in O50334 / R50334C15: got '#NULL!'
Warning: Expecting date in O50421 / R50421C15: got '#NULL!'
Warning: Expecting date in O50436 / R50436C15: got '#NULL!'
Warning: Expecting date in O50573 / R50573C15: got '#NULL!'
Warning: Expecting date in O50648 / R50648C15: got '#NULL!'
Warning: Expecting date in O50660 / R50660C15: got '#NULL!'
Warning: Expecting date in O50681 / R50681C15: got '#NULL!'
Warning: Expecting date in O50727 / R50727C15: got '#NULL!'
Warning: Expecting date in O50823 / R50823C15: got '#NULL!'
Warning: Expecting date in O50850 / R50850C15: got '#NULL!'
Warning: Expecting date in O50936 / R50936C15: got '#NULL!'
Warning: Expecting date in O50950 / R50950C15: got '#NULL!'
Warning: Expecting date in I51092 / R51092C9: got '#NULL!'
Warning: Expecting date in O51092 / R51092C15: got '#NULL!'
Warning: Expecting date in O51117 / R51117C15: got '#NULL!'
Warning: Expecting date in O51134 / R51134C15: got '#NULL!'
Warning: Expecting date in O51189 / R51189C15: got '#NULL!'
Warning: Expecting date in O51280 / R51280C15: got '#NULL!'
Warning: Expecting date in O51388 / R51388C15: got '#NULL!'
Warning: Expecting date in O51398 / R51398C15: got '#NULL!'
Warning: Expecting date in O51549 / R51549C15: got '#NULL!'
Warning: Expecting date in O51777 / R51777C15: got '#NULL!'
Warning: Expecting date in O51811 / R51811C15: got '#NULL!'
Warning: Expecting date in O52556 / R52556C15: got '#NULL!'
Warning: Expecting date in O52725 / R52725C15: got '#NULL!'
Warning: Expecting date in O52834 / R52834C15: got '#NULL!'
Warning: Expecting date in O52971 / R52971C15: got '#NULL!'
Warning: Expecting date in O53220 / R53220C15: got '#NULL!'
Warning: Expecting date in O53246 / R53246C15: got '#NULL!'
Warning: Expecting date in O53260 / R53260C15: got '#NULL!'
Warning: Expecting date in I53318 / R53318C9: got '#NULL!'
Warning: Expecting date in O53318 / R53318C15: got '#NULL!'
Warning: Expecting date in O53365 / R53365C15: got '#NULL!'
Warning: Expecting date in O53660 / R53660C15: got '#NULL!'
Warning: Expecting date in O53706 / R53706C15: got '#NULL!'
Warning: Expecting date in O53739 / R53739C15: got '#NULL!'
Warning: Expecting date in O53751 / R53751C15: got '#NULL!'
Warning: Expecting date in O53772 / R53772C15: got '#NULL!'
Warning: Expecting date in O53784 / R53784C15: got '#NULL!'
Warning: Expecting date in O53837 / R53837C15: got '#NULL!'
Warning: Expecting date in O54082 / R54082C15: got '#NULL!'
Warning: Expecting date in O54109 / R54109C15: got '#NULL!'
Warning: Expecting date in O54232 / R54232C15: got '#NULL!'
Warning: Expecting date in O54552 / R54552C15: got '#NULL!'
Warning: Expecting date in O54688 / R54688C15: got '#NULL!'
Warning: Expecting date in O54819 / R54819C15: got '#NULL!'
Warning: Expecting date in O54864 / R54864C15: got '#NULL!'
Warning: Expecting date in O55058 / R55058C15: got '#NULL!'
Warning: Expecting date in O55250 / R55250C15: got '#NULL!'
Warning: Expecting date in O55293 / R55293C15: got '#NULL!'
Warning: Expecting date in O55502 / R55502C15: got '#NULL!'
Warning: Expecting date in O55676 / R55676C15: got '#NULL!'
Warning: Expecting date in O55799 / R55799C15: got '#NULL!'
Warning: Expecting date in O55839 / R55839C15: got '#NULL!'
Warning: Expecting date in O55865 / R55865C15: got '#NULL!'
Warning: Expecting date in O55869 / R55869C15: got '#NULL!'
Warning: Expecting date in O55891 / R55891C15: got '#NULL!'
Warning: Expecting date in O55936 / R55936C15: got '#NULL!'
Warning: Expecting date in O55943 / R55943C15: got '#NULL!'
Warning: Expecting date in O55948 / R55948C15: got '#NULL!'
Warning: Expecting date in O56005 / R56005C15: got '#NULL!'
Warning: Expecting date in O56026 / R56026C15: got '#NULL!'
Warning: Expecting date in O56130 / R56130C15: got '#NULL!'
Warning: Expecting date in O56210 / R56210C15: got '#NULL!'
Warning: Expecting date in O56337 / R56337C15: got '#NULL!'
Warning: Expecting date in O56481 / R56481C15: got '#NULL!'
Warning: Expecting date in O56546 / R56546C15: got '#NULL!'
Warning: Expecting date in O56605 / R56605C15: got '#NULL!'
Warning: Expecting date in O56705 / R56705C15: got '#NULL!'
Warning: Expecting date in O56793 / R56793C15: got '#NULL!'
Warning: Expecting date in O56798 / R56798C15: got '#NULL!'
Warning: Expecting date in O56809 / R56809C15: got '#NULL!'
Warning: Expecting date in O56854 / R56854C15: got '#NULL!'
Warning: Expecting date in O56880 / R56880C15: got '#NULL!'
Warning: Expecting date in O57010 / R57010C15: got '#NULL!'
Warning: Expecting date in O57203 / R57203C15: got '#NULL!'
Warning: Expecting date in O57279 / R57279C15: got '#NULL!'
Warning: Expecting date in O57303 / R57303C15: got '#NULL!'
Warning: Expecting date in O57482 / R57482C15: got '#NULL!'
Warning: Expecting date in O57519 / R57519C15: got '#NULL!'
Warning: Expecting date in O57545 / R57545C15: got '#NULL!'
Warning: Expecting date in O57568 / R57568C15: got '#NULL!'
Warning: Expecting date in O57629 / R57629C15: got '#NULL!'
Warning: Expecting date in O57880 / R57880C15: got '#NULL!'
Warning: Expecting date in O57887 / R57887C15: got '#NULL!'
Warning: Expecting date in O57953 / R57953C15: got '#NULL!'
Warning: Expecting date in O57973 / R57973C15: got '#NULL!'
Warning: Expecting date in O58086 / R58086C15: got '#NULL!'
Warning: Expecting date in O58127 / R58127C15: got '#NULL!'
Warning: Expecting date in O58255 / R58255C15: got '#NULL!'
Warning: Expecting date in O58315 / R58315C15: got '#NULL!'
Warning: Expecting date in O58329 / R58329C15: got '#NULL!'
Warning: Expecting date in O58398 / R58398C15: got '#NULL!'
Warning: Expecting date in O58454 / R58454C15: got '#NULL!'
Warning: Expecting date in O58455 / R58455C15: got '#NULL!'
Warning: Expecting date in O58484 / R58484C15: got '#NULL!'
Warning: Expecting date in O58570 / R58570C15: got '#NULL!'
Warning: Expecting date in O58604 / R58604C15: got '#NULL!'
Warning: Expecting date in O58759 / R58759C15: got '#NULL!'
Warning: Expecting date in O58766 / R58766C15: got '#NULL!'
Warning: Expecting date in O58832 / R58832C15: got '#NULL!'
Warning: Expecting date in O59031 / R59031C15: got '#NULL!'
Warning: Expecting date in O59091 / R59091C15: got '#NULL!'
Warning: Expecting date in O59127 / R59127C15: got '#NULL!'
Warning: Expecting date in O59144 / R59144C15: got '#NULL!'
Warning: Expecting date in O59211 / R59211C15: got '#NULL!'
Warning: Expecting date in O59302 / R59302C15: got '#NULL!'
Warning: Expecting date in O59314 / R59314C15: got '#NULL!'
Warning: Expecting date in O59406 / R59406C15: got '#NULL!'
Warning: Expecting date in O59437 / R59437C15: got '#NULL!'
Warning: Expecting date in O59454 / R59454C15: got '#NULL!'
Warning: Expecting date in O59481 / R59481C15: got '#NULL!'
Warning: Expecting date in O59488 / R59488C15: got '#NULL!'
Warning: Expecting date in O59525 / R59525C15: got '#NULL!'
Warning: Expecting date in O59533 / R59533C15: got '#NULL!'
Warning: Expecting date in O59541 / R59541C15: got '#NULL!'
Warning: Expecting date in O59559 / R59559C15: got '#NULL!'
Warning: Expecting date in O59598 / R59598C15: got '#NULL!'
Warning: Expecting date in O59601 / R59601C15: got '#NULL!'
Warning: Expecting date in O59630 / R59630C15: got '#NULL!'
Warning: Expecting date in O59638 / R59638C15: got '#NULL!'
Warning: Expecting date in O59642 / R59642C15: got '#NULL!'
Warning: Expecting date in O59719 / R59719C15: got '#NULL!'
Warning: Expecting date in O59941 / R59941C15: got '#NULL!'
Warning: Expecting date in O60074 / R60074C15: got '#NULL!'
Warning: Expecting date in O60131 / R60131C15: got '#NULL!'
Warning: Expecting date in O60255 / R60255C15: got '#NULL!'
Warning: Expecting date in O60383 / R60383C15: got '#NULL!'
Warning: Expecting date in O60420 / R60420C15: got '#NULL!'
Warning: Expecting date in O60677 / R60677C15: got '#NULL!'
Warning: Expecting date in O60688 / R60688C15: got '#NULL!'
Warning: Expecting date in O60706 / R60706C15: got '#NULL!'
Warning: Expecting date in O60804 / R60804C15: got '#NULL!'
Warning: Expecting date in O60827 / R60827C15: got '#NULL!'
Warning: Expecting date in O60903 / R60903C15: got '#NULL!'
Warning: Expecting date in O60992 / R60992C15: got '#NULL!'
Warning: Expecting date in O61214 / R61214C15: got '#NULL!'
Warning: Expecting date in O61258 / R61258C15: got '#NULL!'
Warning: Expecting date in O61266 / R61266C15: got '#NULL!'
Warning: Expecting date in O61636 / R61636C15: got '#NULL!'
Warning: Expecting date in O61729 / R61729C15: got '#NULL!'
Warning: Expecting date in O61962 / R61962C15: got '#NULL!'
Warning: Expecting date in O62095 / R62095C15: got '#NULL!'
Warning: Expecting date in O62156 / R62156C15: got '#NULL!'
Warning: Expecting date in O62185 / R62185C15: got '#NULL!'
Warning: Expecting date in O62223 / R62223C15: got '#NULL!'
Warning: Expecting date in O62267 / R62267C15: got '#NULL!'
Warning: Expecting date in O62620 / R62620C15: got '#NULL!'
Warning: Expecting date in O62680 / R62680C15: got '#NULL!'
Warning: Expecting date in O62828 / R62828C15: got '#NULL!'
Warning: Expecting date in O62904 / R62904C15: got '#NULL!'
Warning: Expecting date in I62938 / R62938C9: got '#NULL!'
Warning: Expecting date in O62938 / R62938C15: got '#NULL!'
Warning: Expecting date in O62945 / R62945C15: got '#NULL!'
Warning: Expecting date in O62984 / R62984C15: got '#NULL!'
Warning: Expecting date in O63065 / R63065C15: got '#NULL!'
Warning: Expecting date in O63119 / R63119C15: got '#NULL!'
Warning: Expecting date in O63550 / R63550C15: got '#NULL!'
Warning: Expecting date in O63743 / R63743C15: got '#NULL!'
Warning: Expecting date in O63789 / R63789C15: got '#NULL!'
Warning: Expecting date in O63959 / R63959C15: got '#NULL!'
Warning: Expecting date in O64038 / R64038C15: got '#NULL!'
Warning: Expecting date in O64079 / R64079C15: got '#NULL!'
Warning: Expecting date in O64181 / R64181C15: got '#NULL!'
Warning: Expecting date in O64270 / R64270C15: got '#NULL!'
Warning: Expecting date in O64349 / R64349C15: got '#NULL!'
Warning: Expecting date in O64490 / R64490C15: got '#NULL!'
Warning: Expecting date in O64591 / R64591C15: got '#NULL!'
Warning: Expecting date in O64703 / R64703C15: got '#NULL!'
Warning: Expecting date in O64728 / R64728C15: got '#NULL!'
Warning: Expecting date in O64765 / R64765C15: got '#NULL!'
Warning: Expecting date in O64793 / R64793C15: got '#NULL!'
Warning: Expecting date in O64840 / R64840C15: got '#NULL!'
Warning: Expecting date in O64936 / R64936C15: got '#NULL!'
Warning: Expecting date in O65176 / R65176C15: got '#NULL!'
Warning: Expecting date in O65186 / R65186C15: got '#NULL!'
Warning: Expecting date in O65211 / R65211C15: got '#NULL!'
Warning: Expecting date in O65259 / R65259C15: got '#NULL!'
Warning: Expecting date in O65353 / R65353C15: got '#NULL!'
Warning: Expecting date in O65365 / R65365C15: got '#NULL!'
Warning: Expecting date in O65403 / R65403C15: got '#NULL!'
Warning: Expecting date in O65475 / R65475C15: got '#NULL!'
Warning: Expecting date in O65515 / R65515C15: got '#NULL!'
Warning: Expecting date in O65565 / R65565C15: got '#NULL!'
Warning: Expecting date in O65594 / R65594C15: got '#NULL!'
Warning: Expecting date in O65677 / R65677C15: got '#NULL!'
Warning: Expecting date in O65688 / R65688C15: got '#NULL!'
Warning: Expecting date in O65705 / R65705C15: got '#NULL!'
Warning: Expecting date in O65813 / R65813C15: got '#NULL!'
Warning: Expecting date in O65819 / R65819C15: got '#NULL!'
Warning: Expecting date in O65827 / R65827C15: got '#NULL!'
Warning: Expecting date in O65834 / R65834C15: got '#NULL!'
Warning: Expecting date in O65904 / R65904C15: got '#NULL!'
Warning: Expecting date in O65969 / R65969C15: got '#NULL!'
Warning: Expecting date in O66058 / R66058C15: got '#NULL!'
Warning: Expecting date in O66176 / R66176C15: got '#NULL!'
Warning: Expecting date in O66223 / R66223C15: got '#NULL!'
Warning: Expecting date in O66385 / R66385C15: got '#NULL!'
Warning: Expecting date in O66403 / R66403C15: got '#NULL!'
Warning: Expecting date in O66456 / R66456C15: got '#NULL!'
Warning: Expecting date in O66621 / R66621C15: got '#NULL!'
Warning: Expecting date in O66768 / R66768C15: got '#NULL!'
Warning: Expecting date in O66793 / R66793C15: got '#NULL!'
Warning: Expecting date in O66797 / R66797C15: got '#NULL!'
Warning: Expecting date in O67022 / R67022C15: got '#NULL!'
Warning: Expecting date in O67315 / R67315C15: got '#NULL!'
Warning: Expecting date in O67409 / R67409C15: got '#NULL!'
Warning: Expecting date in O67691 / R67691C15: got '#NULL!'
Warning: Expecting date in O67771 / R67771C15: got '#NULL!'
Warning: Expecting date in O67875 / R67875C15: got '#NULL!'
Warning: Expecting date in O67895 / R67895C15: got '#NULL!'
Warning: Expecting date in O67936 / R67936C15: got '#NULL!'
Warning: Expecting date in O67942 / R67942C15: got '#NULL!'
Warning: Expecting date in O67955 / R67955C15: got '#NULL!'
Warning: Expecting date in O67972 / R67972C15: got '#NULL!'
Warning: Expecting date in O68171 / R68171C15: got '#NULL!'
Warning: Expecting date in I68192 / R68192C9: got '#NULL!'
Warning: Expecting date in O68192 / R68192C15: got '#NULL!'
Warning: Expecting date in O68680 / R68680C15: got '#NULL!'
Warning: Expecting date in O68697 / R68697C15: got '#NULL!'
Warning: Expecting date in O68737 / R68737C15: got '#NULL!'
Warning: Expecting date in O68808 / R68808C15: got '#NULL!'
Warning: Expecting date in O68817 / R68817C15: got '#NULL!'
Warning: Expecting date in O68858 / R68858C15: got '#NULL!'
Warning: Expecting date in O68882 / R68882C15: got '#NULL!'
Warning: Expecting date in O68923 / R68923C15: got '#NULL!'
Warning: Expecting date in O69233 / R69233C15: got '#NULL!'
Warning: Expecting date in O69506 / R69506C15: got '#NULL!'
Warning: Expecting date in H69528 / R69528C8: got '#NULL!'
Warning: Expecting date in I69528 / R69528C9: got '#NULL!'
Warning: Expecting date in O69565 / R69565C15: got '#NULL!'
Warning: Expecting date in O69641 / R69641C15: got '#NULL!'
Warning: Expecting date in O70064 / R70064C15: got '#NULL!'
Warning: Expecting date in O70079 / R70079C15: got '#NULL!'
Warning: Expecting date in O70080 / R70080C15: got '#NULL!'
Warning: Expecting date in O70101 / R70101C15: got '#NULL!'
Warning: Expecting date in O70254 / R70254C15: got '#NULL!'
Warning: Expecting date in O70270 / R70270C15: got '#NULL!'
Warning: Expecting date in O70286 / R70286C15: got '#NULL!'
Warning: Expecting date in O70376 / R70376C15: got '#NULL!'
Warning: Expecting date in O70479 / R70479C15: got '#NULL!'
Warning: Expecting date in O70539 / R70539C15: got '#NULL!'
Warning: Expecting date in O70613 / R70613C15: got '#NULL!'
Warning: Expecting date in O70844 / R70844C15: got '#NULL!'
Warning: Expecting date in O70916 / R70916C15: got '#NULL!'
Warning: Expecting date in O70962 / R70962C15: got '#NULL!'
Warning: Expecting date in O71022 / R71022C15: got '#NULL!'
Warning: Expecting date in O71073 / R71073C15: got '#NULL!'
Warning: Expecting date in O71172 / R71172C15: got '#NULL!'
Warning: Expecting date in O71213 / R71213C15: got '#NULL!'
Warning: Expecting date in O71290 / R71290C15: got '#NULL!'
Warning: Expecting date in O71338 / R71338C15: got '#NULL!'
Warning: Expecting date in O71421 / R71421C15: got '#NULL!'
Warning: Expecting date in O71464 / R71464C15: got '#NULL!'
Warning: Expecting date in O71543 / R71543C15: got '#NULL!'
Warning: Expecting date in O71651 / R71651C15: got '#NULL!'
Warning: Expecting date in O71720 / R71720C15: got '#NULL!'
Warning: Expecting date in O71733 / R71733C15: got '#NULL!'
Warning: Expecting date in O72036 / R72036C15: got '#NULL!'
Warning: Expecting date in O72116 / R72116C15: got '#NULL!'
Warning: Expecting date in O72149 / R72149C15: got '#NULL!'
Warning: Expecting date in O72165 / R72165C15: got '#NULL!'
Warning: Expecting date in O72188 / R72188C15: got '#NULL!'
Warning: Expecting date in O72209 / R72209C15: got '#NULL!'
Warning: Expecting date in O72240 / R72240C15: got '#NULL!'
Warning: Expecting date in O72303 / R72303C15: got '#NULL!'
Warning: Expecting date in O72521 / R72521C15: got '#NULL!'
Warning: Expecting date in O72538 / R72538C15: got '#NULL!'
Warning: Expecting date in O72595 / R72595C15: got '#NULL!'
Warning: Expecting date in O72699 / R72699C15: got '#NULL!'
Warning: Expecting date in O72775 / R72775C15: got '#NULL!'
Warning: Expecting date in O72776 / R72776C15: got '#NULL!'
Warning: Expecting date in O72782 / R72782C15: got '#NULL!'
Warning: Expecting date in O72921 / R72921C15: got '#NULL!'
Warning: Expecting date in O72946 / R72946C15: got '#NULL!'
Warning: Expecting date in O73086 / R73086C15: got '#NULL!'
Warning: Expecting date in O73119 / R73119C15: got '#NULL!'
Warning: Expecting date in O73179 / R73179C15: got '#NULL!'
Warning: Expecting date in O73195 / R73195C15: got '#NULL!'
Warning: Expecting date in O73229 / R73229C15: got '#NULL!'
Warning: Expecting date in O73317 / R73317C15: got '#NULL!'
Warning: Expecting date in O73328 / R73328C15: got '#NULL!'
Warning: Expecting date in O73339 / R73339C15: got '#NULL!'
Warning: Expecting date in O73445 / R73445C15: got '#NULL!'
Warning: Expecting date in O73468 / R73468C15: got '#NULL!'
Warning: Expecting date in O73604 / R73604C15: got '#NULL!'
Warning: Expecting date in O73625 / R73625C15: got '#NULL!'
Warning: Expecting date in O73628 / R73628C15: got '#NULL!'
Warning: Expecting date in O73684 / R73684C15: got '#NULL!'
Warning: Expecting date in O73795 / R73795C15: got '#NULL!'
Warning: Expecting date in O73816 / R73816C15: got '#NULL!'
Warning: Expecting date in O73933 / R73933C15: got '#NULL!'
Warning: Expecting date in O74227 / R74227C15: got '#NULL!'
Warning: Expecting date in O74234 / R74234C15: got '#NULL!'
Warning: Expecting date in O74247 / R74247C15: got '#NULL!'
Warning: Expecting date in O74252 / R74252C15: got '#NULL!'
Warning: Expecting date in O74259 / R74259C15: got '#NULL!'
Warning: Expecting date in O74282 / R74282C15: got '#NULL!'
Warning: Expecting date in O74310 / R74310C15: got '#NULL!'
Warning: Expecting date in O74322 / R74322C15: got '#NULL!'
Warning: Expecting date in O74361 / R74361C15: got '#NULL!'
Warning: Expecting date in O74471 / R74471C15: got '#NULL!'
Warning: Expecting date in O74483 / R74483C15: got '#NULL!'
Warning: Expecting date in O74653 / R74653C15: got '#NULL!'
Warning: Expecting date in O74948 / R74948C15: got '#NULL!'
Warning: Expecting date in O75034 / R75034C15: got '#NULL!'
Warning: Expecting date in O75055 / R75055C15: got '#NULL!'
Warning: Expecting date in O75067 / R75067C15: got '#NULL!'
Warning: Expecting date in O75315 / R75315C15: got '#NULL!'
Warning: Expecting date in O75563 / R75563C15: got '#NULL!'
Warning: Expecting date in O75597 / R75597C15: got '#NULL!'
Warning: Expecting date in O75624 / R75624C15: got '#NULL!'
Warning: Expecting date in O75689 / R75689C15: got '#NULL!'
Warning: Expecting date in O75696 / R75696C15: got '#NULL!'
Warning: Expecting date in O75709 / R75709C15: got '#NULL!'
Warning: Expecting date in O75737 / R75737C15: got '#NULL!'
Warning: Expecting date in O75790 / R75790C15: got '#NULL!'
Warning: Expecting date in O75814 / R75814C15: got '#NULL!'
Warning: Expecting date in O75830 / R75830C15: got '#NULL!'
Warning: Expecting date in O75838 / R75838C15: got '#NULL!'
Warning: Expecting date in O75840 / R75840C15: got '#NULL!'
Warning: Expecting date in O75905 / R75905C15: got '#NULL!'
Warning: Expecting date in O75965 / R75965C15: got '#NULL!'
Warning: Expecting date in O75969 / R75969C15: got '#NULL!'
Warning: Expecting date in O76041 / R76041C15: got '#NULL!'
Warning: Expecting date in O76371 / R76371C15: got '#NULL!'
Warning: Expecting date in O76459 / R76459C15: got '#NULL!'
Warning: Expecting date in O76583 / R76583C15: got '#NULL!'
Warning: Expecting date in O76587 / R76587C15: got '#NULL!'
Warning: Expecting date in O76781 / R76781C15: got '#NULL!'
Warning: Expecting date in O76817 / R76817C15: got '#NULL!'
Warning: Expecting date in O76966 / R76966C15: got '#NULL!'
Warning: Expecting date in O76977 / R76977C15: got '#NULL!'
Warning: Expecting date in O77081 / R77081C15: got '#NULL!'
Warning: Expecting date in O77122 / R77122C15: got '#NULL!'
Warning: Expecting date in O77225 / R77225C15: got '#NULL!'
Warning: Expecting date in O77287 / R77287C15: got '#NULL!'
Warning: Expecting date in O77304 / R77304C15: got '#NULL!'
Warning: Expecting date in O77311 / R77311C15: got '#NULL!'
Warning: Expecting date in O77349 / R77349C15: got '#NULL!'
Warning: Expecting date in O77471 / R77471C15: got '#NULL!'
Warning: Expecting date in O77777 / R77777C15: got '#NULL!'
Warning: Expecting date in O77779 / R77779C15: got '#NULL!'
Warning: Expecting date in O77848 / R77848C15: got '#NULL!'
Warning: Expecting date in I77901 / R77901C9: got '#NULL!'
Warning: Expecting date in O77901 / R77901C15: got '#NULL!'
Warning: Expecting date in O78027 / R78027C15: got '#NULL!'
Warning: Expecting date in O78049 / R78049C15: got '#NULL!'
Warning: Expecting date in O78055 / R78055C15: got '#NULL!'
Warning: Expecting date in O78148 / R78148C15: got '#NULL!'
Warning: Expecting date in O78208 / R78208C15: got '#NULL!'
Warning: Expecting date in O78223 / R78223C15: got '#NULL!'
Warning: Expecting date in O78363 / R78363C15: got '#NULL!'
Warning: Expecting date in O78396 / R78396C15: got '#NULL!'
Warning: Expecting date in O78427 / R78427C15: got '#NULL!'
Warning: Expecting date in O78574 / R78574C15: got '#NULL!'
Warning: Expecting date in O78617 / R78617C15: got '#NULL!'
Warning: Expecting date in O78808 / R78808C15: got '#NULL!'
Warning: Expecting date in O78906 / R78906C15: got '#NULL!'
Warning: Expecting date in O78928 / R78928C15: got '#NULL!'
Warning: Expecting date in O79122 / R79122C15: got '#NULL!'
Warning: Expecting date in O79169 / R79169C15: got '#NULL!'
Warning: Expecting date in O79251 / R79251C15: got '#NULL!'
Warning: Expecting date in O79314 / R79314C15: got '#NULL!'
Warning: Expecting date in O79332 / R79332C15: got '#NULL!'
Warning: Expecting date in O79369 / R79369C15: got '#NULL!'
Warning: Expecting date in O79413 / R79413C15: got '#NULL!'
Warning: Expecting date in O79657 / R79657C15: got '#NULL!'
Warning: Expecting date in O79875 / R79875C15: got '#NULL!'
Warning: Expecting date in O79935 / R79935C15: got '#NULL!'
Warning: Expecting date in O80033 / R80033C15: got '#NULL!'
Warning: Expecting date in O80072 / R80072C15: got '#NULL!'
Warning: Expecting date in O80229 / R80229C15: got '#NULL!'
Warning: Expecting date in O80232 / R80232C15: got '#NULL!'
Warning: Expecting date in O80323 / R80323C15: got '#NULL!'
Warning: Expecting date in O80351 / R80351C15: got '#NULL!'
Warning: Expecting date in O80555 / R80555C15: got '#NULL!'
Warning: Expecting date in O80904 / R80904C15: got '#NULL!'
Warning: Expecting date in O80949 / R80949C15: got '#NULL!'
Warning: Expecting date in O81098 / R81098C15: got '#NULL!'
Warning: Expecting date in O81256 / R81256C15: got '#NULL!'
Warning: Expecting date in O81320 / R81320C15: got '#NULL!'
Warning: Expecting date in O81325 / R81325C15: got '#NULL!'
Warning: Expecting date in O81329 / R81329C15: got '#NULL!'
Warning: Expecting date in O81431 / R81431C15: got '#NULL!'
Warning: Expecting date in O81587 / R81587C15: got '#NULL!'
Warning: Expecting date in O81717 / R81717C15: got '#NULL!'
Warning: Expecting date in O81795 / R81795C15: got '#NULL!'
Warning: Expecting date in O81970 / R81970C15: got '#NULL!'
Warning: Expecting date in O81991 / R81991C15: got '#NULL!'
Warning: Expecting date in O82014 / R82014C15: got '#NULL!'
Warning: Expecting date in O82441 / R82441C15: got '#NULL!'
Warning: Expecting date in O82450 / R82450C15: got '#NULL!'
Warning: Expecting date in O82547 / R82547C15: got '#NULL!'
Warning: Expecting date in O82583 / R82583C15: got '#NULL!'
Warning: Expecting date in O82673 / R82673C15: got '#NULL!'
Warning: Expecting date in O82674 / R82674C15: got '#NULL!'
Warning: Expecting date in O82710 / R82710C15: got '#NULL!'
Warning: Expecting date in O82839 / R82839C15: got '#NULL!'
Warning: Expecting date in O82979 / R82979C15: got '#NULL!'
Warning: Expecting date in O83016 / R83016C15: got '#NULL!'
Warning: Expecting date in O83052 / R83052C15: got '#NULL!'
Warning: Expecting date in O83135 / R83135C15: got '#NULL!'
Warning: Expecting date in O83163 / R83163C15: got '#NULL!'
Warning: Expecting date in O83214 / R83214C15: got '#NULL!'
Warning: Expecting date in O83324 / R83324C15: got '#NULL!'
Warning: Expecting date in O83334 / R83334C15: got '#NULL!'
Warning: Expecting date in O83360 / R83360C15: got '#NULL!'
Warning: Expecting date in O83524 / R83524C15: got '#NULL!'
Warning: Expecting date in O83536 / R83536C15: got '#NULL!'
Warning: Expecting date in O83610 / R83610C15: got '#NULL!'
Warning: Expecting date in O83613 / R83613C15: got '#NULL!'
Warning: Expecting date in O83651 / R83651C15: got '#NULL!'
Warning: Expecting date in O83749 / R83749C15: got '#NULL!'
Warning: Expecting date in O83751 / R83751C15: got '#NULL!'
Warning: Expecting date in O83813 / R83813C15: got '#NULL!'
Warning: Expecting date in O83819 / R83819C15: got '#NULL!'
Warning: Expecting date in O83949 / R83949C15: got '#NULL!'
Warning: Expecting date in O83997 / R83997C15: got '#NULL!'
Warning: Expecting date in O84013 / R84013C15: got '#NULL!'
Warning: Expecting date in O84067 / R84067C15: got '#NULL!'
Warning: Expecting date in O84148 / R84148C15: got '#NULL!'
Warning: Expecting date in O84178 / R84178C15: got '#NULL!'
Warning: Expecting date in O84618 / R84618C15: got '#NULL!'
Warning: Expecting date in O84658 / R84658C15: got '#NULL!'
Warning: Expecting date in H84672 / R84672C8: got '#NULL!'
Warning: Expecting date in I84672 / R84672C9: got '#NULL!'
Warning: Expecting date in O84770 / R84770C15: got '#NULL!'
Warning: Expecting date in O84899 / R84899C15: got '#NULL!'
Warning: Expecting date in O84946 / R84946C15: got '#NULL!'
Warning: Expecting date in O85112 / R85112C15: got '#NULL!'
Warning: Expecting date in O85167 / R85167C15: got '#NULL!'
Warning: Expecting date in O85219 / R85219C15: got '#NULL!'
Warning: Expecting date in O85240 / R85240C15: got '#NULL!'
Warning: Expecting date in O85241 / R85241C15: got '#NULL!'
Warning: Expecting date in O85338 / R85338C15: got '#NULL!'
Warning: Expecting date in O85374 / R85374C15: got '#NULL!'
Warning: Expecting date in O85443 / R85443C15: got '#NULL!'
Warning: Expecting date in O85454 / R85454C15: got '#NULL!'
Warning: Expecting date in O85615 / R85615C15: got '#NULL!'
Warning: Expecting date in O85780 / R85780C15: got '#NULL!'
Warning: Expecting date in O85877 / R85877C15: got '#NULL!'
Warning: Expecting date in O85976 / R85976C15: got '#NULL!'
Warning: Expecting date in O86032 / R86032C15: got '#NULL!'
Warning: Expecting date in O86102 / R86102C15: got '#NULL!'
Warning: Expecting date in O86268 / R86268C15: got '#NULL!'
Warning: Expecting date in O86335 / R86335C15: got '#NULL!'
Warning: Expecting date in O86338 / R86338C15: got '#NULL!'
Warning: Expecting date in O86411 / R86411C15: got '#NULL!'
Warning: Expecting date in O86445 / R86445C15: got '#NULL!'
Warning: Expecting date in O86457 / R86457C15: got '#NULL!'
Warning: Expecting date in O86458 / R86458C15: got '#NULL!'
Warning: Expecting date in O86550 / R86550C15: got '#NULL!'
Warning: Expecting date in O86818 / R86818C15: got '#NULL!'
Warning: Expecting date in O86963 / R86963C15: got '#NULL!'
Warning: Expecting date in O87063 / R87063C15: got '#NULL!'
Warning: Expecting date in O87105 / R87105C15: got '#NULL!'
Warning: Expecting date in O87116 / R87116C15: got '#NULL!'
Warning: Expecting date in O87184 / R87184C15: got '#NULL!'
Warning: Expecting date in O87245 / R87245C15: got '#NULL!'
Warning: Expecting date in H87262 / R87262C8: got '#NULL!'
Warning: Expecting date in I87262 / R87262C9: got '#NULL!'
Warning: Expecting date in O87380 / R87380C15: got '#NULL!'
Warning: Expecting date in O87674 / R87674C15: got '#NULL!'
Warning: Expecting date in O87715 / R87715C15: got '#NULL!'
Warning: Expecting date in O87719 / R87719C15: got '#NULL!'
Warning: Expecting date in O87785 / R87785C15: got '#NULL!'
Warning: Expecting date in O87790 / R87790C15: got '#NULL!'
Warning: Expecting date in O87856 / R87856C15: got '#NULL!'
Warning: Expecting date in O87887 / R87887C15: got '#NULL!'
Warning: Expecting date in O87925 / R87925C15: got '#NULL!'
Warning: Expecting date in O87935 / R87935C15: got '#NULL!'
Warning: Expecting date in O88036 / R88036C15: got '#NULL!'
Warning: Expecting date in O88039 / R88039C15: got '#NULL!'
Warning: Expecting date in O88056 / R88056C15: got '#NULL!'
Warning: Expecting date in O88090 / R88090C15: got '#NULL!'
Warning: Expecting date in O88266 / R88266C15: got '#NULL!'
Warning: Expecting date in O88357 / R88357C15: got '#NULL!'
Warning: Expecting date in O88386 / R88386C15: got '#NULL!'
Warning: Expecting date in O88507 / R88507C15: got '#NULL!'
Warning: Expecting date in O88677 / R88677C15: got '#NULL!'
Warning: Expecting date in O88797 / R88797C15: got '#NULL!'
Warning: Expecting date in O88861 / R88861C15: got '#NULL!'
Warning: Expecting date in O88884 / R88884C15: got '#NULL!'
Warning: Expecting date in O89021 / R89021C15: got '#NULL!'
Warning: Expecting date in O89055 / R89055C15: got '#NULL!'
Warning: Expecting date in O89097 / R89097C15: got '#NULL!'
Warning: Expecting date in O89209 / R89209C15: got '#NULL!'
Warning: Expecting date in O89269 / R89269C15: got '#NULL!'
Warning: Expecting date in O89314 / R89314C15: got '#NULL!'
Warning: Expecting date in O89371 / R89371C15: got '#NULL!'
Warning: Expecting date in O89443 / R89443C15: got '#NULL!'
Warning: Expecting date in O89485 / R89485C15: got '#NULL!'
Warning: Expecting date in O89550 / R89550C15: got '#NULL!'
Warning: Expecting date in O89624 / R89624C15: got '#NULL!'
Warning: Expecting date in O89742 / R89742C15: got '#NULL!'
Warning: Expecting date in O89751 / R89751C15: got '#NULL!'
Warning: Expecting date in O90144 / R90144C15: got '#NULL!'
Warning: Expecting date in O90211 / R90211C15: got '#NULL!'
Warning: Expecting date in O90223 / R90223C15: got '#NULL!'
Warning: Expecting date in O90259 / R90259C15: got '#NULL!'
Warning: Expecting date in O90415 / R90415C15: got '#NULL!'
Warning: Expecting date in O90447 / R90447C15: got '#NULL!'
Warning: Expecting date in O90495 / R90495C15: got '#NULL!'
Warning: Expecting date in O90597 / R90597C15: got '#NULL!'
Warning: Expecting date in O90658 / R90658C15: got '#NULL!'
Warning: Expecting date in O90678 / R90678C15: got '#NULL!'
Warning: Expecting date in O90731 / R90731C15: got '#NULL!'
Warning: Expecting date in O91087 / R91087C15: got '#NULL!'
Warning: Expecting date in O91158 / R91158C15: got '#NULL!'
Warning: Expecting date in H91316 / R91316C8: got '#NULL!'
Warning: Expecting date in I91316 / R91316C9: got '#NULL!'
Warning: Expecting date in O91382 / R91382C15: got '#NULL!'
Warning: Expecting date in O91402 / R91402C15: got '#NULL!'
Warning: Expecting date in O91523 / R91523C15: got '#NULL!'
Warning: Expecting date in O91592 / R91592C15: got '#NULL!'
Warning: Expecting date in O91730 / R91730C15: got '#NULL!'
Warning: Expecting date in O91842 / R91842C15: got '#NULL!'
Warning: Expecting date in O91844 / R91844C15: got '#NULL!'
Warning: Expecting date in O91887 / R91887C15: got '#NULL!'
Warning: Expecting date in O92058 / R92058C15: got '#NULL!'
Warning: Expecting date in O92152 / R92152C15: got '#NULL!'
Warning: Expecting date in O92166 / R92166C15: got '#NULL!'
Warning: Expecting date in O92203 / R92203C15: got '#NULL!'
Warning: Expecting date in O92274 / R92274C15: got '#NULL!'
Warning: Expecting date in O92394 / R92394C15: got '#NULL!'
Warning: Expecting date in O92538 / R92538C15: got '#NULL!'
Warning: Expecting date in O92591 / R92591C15: got '#NULL!'
Warning: Expecting date in O92627 / R92627C15: got '#NULL!'
Warning: Expecting date in O92685 / R92685C15: got '#NULL!'
Warning: Expecting date in O92765 / R92765C15: got '#NULL!'
Warning: Expecting date in O93023 / R93023C15: got '#NULL!'
Warning: Expecting date in O93162 / R93162C15: got '#NULL!'
Warning: Expecting date in O93253 / R93253C15: got '#NULL!'
Warning: Expecting date in O93294 / R93294C15: got '#NULL!'
Warning: Expecting date in O93317 / R93317C15: got '#NULL!'
Warning: Expecting date in O93326 / R93326C15: got '#NULL!'
Warning: Expecting date in O93358 / R93358C15: got '#NULL!'
Warning: Expecting date in O93444 / R93444C15: got '#NULL!'
Warning: Expecting date in O93462 / R93462C15: got '#NULL!'
Warning: Expecting date in O93545 / R93545C15: got '#NULL!'
Warning: Expecting date in O93564 / R93564C15: got '#NULL!'
Warning: Expecting date in O93659 / R93659C15: got '#NULL!'
Warning: Expecting date in O93768 / R93768C15: got '#NULL!'
Warning: Expecting date in O93771 / R93771C15: got '#NULL!'
Warning: Expecting date in O93879 / R93879C15: got '#NULL!'
Warning: Expecting date in O93953 / R93953C15: got '#NULL!'
Warning: Expecting date in O94023 / R94023C15: got '#NULL!'
Warning: Expecting date in O94119 / R94119C15: got '#NULL!'
Warning: Expecting date in O94201 / R94201C15: got '#NULL!'
Warning: Expecting date in O94215 / R94215C15: got '#NULL!'
Warning: Expecting date in O94243 / R94243C15: got '#NULL!'
Warning: Expecting date in O94281 / R94281C15: got '#NULL!'
Warning: Expecting date in O94350 / R94350C15: got '#NULL!'
Warning: Expecting date in O94409 / R94409C15: got '#NULL!'
Warning: Expecting date in O94591 / R94591C15: got '#NULL!'
Warning: Expecting date in O94714 / R94714C15: got '#NULL!'
Warning: Expecting date in O94722 / R94722C15: got '#NULL!'
Warning: Expecting date in O94765 / R94765C15: got '#NULL!'
Warning: Expecting date in O94790 / R94790C15: got '#NULL!'
Warning: Expecting date in O94874 / R94874C15: got '#NULL!'
Warning: Expecting date in O94922 / R94922C15: got '#NULL!'
Warning: Expecting date in O94932 / R94932C15: got '#NULL!'
Warning: Expecting date in O95024 / R95024C15: got '#NULL!'
Warning: Expecting date in O95030 / R95030C15: got '#NULL!'
Warning: Expecting date in O95213 / R95213C15: got '#NULL!'
Warning: Expecting date in O95475 / R95475C15: got '#NULL!'
Warning: Expecting date in O95523 / R95523C15: got '#NULL!'
Warning: Expecting date in O95537 / R95537C15: got '#NULL!'
Warning: Expecting date in O95545 / R95545C15: got '#NULL!'
Warning: Expecting date in O95549 / R95549C15: got '#NULL!'
Warning: Expecting date in O95568 / R95568C15: got '#NULL!'
Warning: Expecting date in O95660 / R95660C15: got '#NULL!'
Warning: Expecting date in O95676 / R95676C15: got '#NULL!'
Warning: Expecting date in O95748 / R95748C15: got '#NULL!'
Warning: Expecting date in O95766 / R95766C15: got '#NULL!'
Warning: Expecting date in O95811 / R95811C15: got '#NULL!'
Warning: Expecting date in O95886 / R95886C15: got '#NULL!'
Warning: Expecting date in O96028 / R96028C15: got '#NULL!'
Warning: Expecting date in O96048 / R96048C15: got '#NULL!'
Warning: Expecting date in O96057 / R96057C15: got '#NULL!'
Warning: Expecting date in O96064 / R96064C15: got '#NULL!'
Warning: Expecting date in O96173 / R96173C15: got '#NULL!'
Warning: Expecting date in O96185 / R96185C15: got '#NULL!'
Warning: Expecting date in O96205 / R96205C15: got '#NULL!'
Warning: Expecting date in O96216 / R96216C15: got '#NULL!'
Warning: Expecting date in O96238 / R96238C15: got '#NULL!'
Warning: Expecting date in O96344 / R96344C15: got '#NULL!'
Warning: Expecting date in O96385 / R96385C15: got '#NULL!'
Warning: Expecting date in O96419 / R96419C15: got '#NULL!'
Warning: Expecting date in O96490 / R96490C15: got '#NULL!'
Warning: Expecting date in O96540 / R96540C15: got '#NULL!'
Warning: Expecting date in O96664 / R96664C15: got '#NULL!'
Warning: Expecting date in O96799 / R96799C15: got '#NULL!'
Warning: Expecting date in O96850 / R96850C15: got '#NULL!'
Warning: Expecting date in O96857 / R96857C15: got '#NULL!'
Warning: Expecting date in O96868 / R96868C15: got '#NULL!'
Warning: Expecting date in O96920 / R96920C15: got '#NULL!'
Warning: Expecting date in O96935 / R96935C15: got '#NULL!'
Warning: Expecting date in O97089 / R97089C15: got '#NULL!'
Warning: Expecting date in O97182 / R97182C15: got '#NULL!'
Warning: Expecting date in O97211 / R97211C15: got '#NULL!'
Warning: Expecting date in O97214 / R97214C15: got '#NULL!'
Warning: Expecting date in O97243 / R97243C15: got '#NULL!'
Warning: Expecting date in O97295 / R97295C15: got '#NULL!'
Warning: Expecting date in O97364 / R97364C15: got '#NULL!'
Warning: Expecting date in O97418 / R97418C15: got '#NULL!'
Warning: Expecting date in I97455 / R97455C9: got '#NULL!'
Warning: Expecting date in O97455 / R97455C15: got '#NULL!'
Warning: Expecting date in O97503 / R97503C15: got '#NULL!'
Warning: Expecting date in O97542 / R97542C15: got '#NULL!'
Warning: Expecting date in O97672 / R97672C15: got '#NULL!'
Warning: Expecting date in O97682 / R97682C15: got '#NULL!'
Warning: Expecting date in O97762 / R97762C15: got '#NULL!'
Warning: Expecting date in O97783 / R97783C15: got '#NULL!'
Warning: Expecting date in O97853 / R97853C15: got '#NULL!'
Warning: Expecting date in O97881 / R97881C15: got '#NULL!'
Warning: Expecting date in O98063 / R98063C15: got '#NULL!'
Warning: Expecting date in O98094 / R98094C15: got '#NULL!'
Warning: Expecting date in O98178 / R98178C15: got '#NULL!'
Warning: Expecting date in O98218 / R98218C15: got '#NULL!'
Warning: Expecting date in O98297 / R98297C15: got '#NULL!'
Warning: Expecting date in O98347 / R98347C15: got '#NULL!'
Warning: Expecting date in O98452 / R98452C15: got '#NULL!'
Warning: Expecting date in O98535 / R98535C15: got '#NULL!'
Warning: Expecting date in O98570 / R98570C15: got '#NULL!'
Warning: Expecting date in O98645 / R98645C15: got '#NULL!'
Warning: Expecting date in O98688 / R98688C15: got '#NULL!'
Warning: Expecting date in O98725 / R98725C15: got '#NULL!'
Warning: Expecting date in O98844 / R98844C15: got '#NULL!'
Warning: Expecting date in O98878 / R98878C15: got '#NULL!'
Warning: Expecting date in O98899 / R98899C15: got '#NULL!'
Warning: Expecting date in O98992 / R98992C15: got '#NULL!'
Warning: Expecting date in O99069 / R99069C15: got '#NULL!'
Warning: Expecting date in O99127 / R99127C15: got '#NULL!'
Warning: Expecting date in O99149 / R99149C15: got '#NULL!'
Warning: Expecting date in O99252 / R99252C15: got '#NULL!'
Warning: Expecting date in O99295 / R99295C15: got '#NULL!'
Warning: Expecting date in O99342 / R99342C15: got '#NULL!'
Warning: Expecting date in O99383 / R99383C15: got '#NULL!'
Warning: Expecting date in O99513 / R99513C15: got '#NULL!'
Warning: Expecting date in O99514 / R99514C15: got '#NULL!'
Warning: Expecting date in O99621 / R99621C15: got '#NULL!'
Warning: Expecting date in I99637 / R99637C9: got '#NULL!'
Warning: Expecting date in O99637 / R99637C15: got '#NULL!'
Warning: Expecting date in O99673 / R99673C15: got '#NULL!'
Warning: Expecting date in O99869 / R99869C15: got '#NULL!'
Warning: Expecting date in O99887 / R99887C15: got '#NULL!'
Warning: Expecting date in O99970 / R99970C15: got '#NULL!'
Warning: Expecting date in O100019 / R100019C15: got '#NULL!'
Warning: Expecting date in O100021 / R100021C15: got '#NULL!'
Warning: Expecting date in O100026 / R100026C15: got '#NULL!'
Warning: Expecting date in O100074 / R100074C15: got '#NULL!'
Warning: Expecting date in O100159 / R100159C15: got '#NULL!'
Warning: Expecting date in O100165 / R100165C15: got '#NULL!'
Warning: Expecting date in O100182 / R100182C15: got '#NULL!'
Warning: Expecting date in O100199 / R100199C15: got '#NULL!'
Warning: Expecting date in O100284 / R100284C15: got '#NULL!'
Warning: Expecting date in O100413 / R100413C15: got '#NULL!'
Warning: Expecting date in O100445 / R100445C15: got '#NULL!'
Warning: Expecting date in O100499 / R100499C15: got '#NULL!'
Warning: Expecting date in O100519 / R100519C15: got '#NULL!'
Warning: Expecting date in O100568 / R100568C15: got '#NULL!'
Warning: Expecting date in H100686 / R100686C8: got '#NULL!'
Warning: Expecting date in I100686 / R100686C9: got '#NULL!'
Warning: Expecting date in O100729 / R100729C15: got '#NULL!'
Warning: Expecting date in O100773 / R100773C15: got '#NULL!'
Warning: Expecting date in O100871 / R100871C15: got '#NULL!'
Warning: Expecting date in O100983 / R100983C15: got '#NULL!'
Warning: Expecting date in O101007 / R101007C15: got '#NULL!'
Warning: Expecting date in O101045 / R101045C15: got '#NULL!'
Warning: Expecting date in O101097 / R101097C15: got '#NULL!'
Warning: Expecting date in O101169 / R101169C15: got '#NULL!'
Warning: Expecting date in O101201 / R101201C15: got '#NULL!'
Warning: Expecting date in O101259 / R101259C15: got '#NULL!'
Warning: Expecting date in O101432 / R101432C15: got '#NULL!'
Warning: Expecting date in O101485 / R101485C15: got '#NULL!'
Warning: Expecting date in O101548 / R101548C15: got '#NULL!'
Warning: Expecting date in O101594 / R101594C15: got '#NULL!'
Warning: Expecting date in O101602 / R101602C15: got '#NULL!'
Warning: Expecting date in O101618 / R101618C15: got '#NULL!'
Warning: Expecting date in O101653 / R101653C15: got '#NULL!'
Warning: Expecting date in O101677 / R101677C15: got '#NULL!'
Warning: Expecting date in O101749 / R101749C15: got '#NULL!'
Warning: Expecting date in O101800 / R101800C15: got '#NULL!'
Warning: Expecting date in O101808 / R101808C15: got '#NULL!'
Warning: Expecting date in O101823 / R101823C15: got '#NULL!'
Warning: Expecting date in O102091 / R102091C15: got '#NULL!'
Warning: Expecting date in O102332 / R102332C15: got '#NULL!'
Warning: Expecting date in O102380 / R102380C15: got '#NULL!'
Warning: Expecting date in O102480 / R102480C15: got '#NULL!'
Warning: Expecting date in O102523 / R102523C15: got '#NULL!'
Warning: Expecting date in O102545 / R102545C15: got '#NULL!'
Warning: Expecting date in O102790 / R102790C15: got '#NULL!'
Warning: Expecting date in O102829 / R102829C15: got '#NULL!'
Warning: Expecting date in O102905 / R102905C15: got '#NULL!'
Warning: Expecting date in O102919 / R102919C15: got '#NULL!'
Warning: Expecting date in O102921 / R102921C15: got '#NULL!'
Warning: Expecting date in O102931 / R102931C15: got '#NULL!'
Warning: Expecting date in O102971 / R102971C15: got '#NULL!'
Warning: Expecting date in O103037 / R103037C15: got '#NULL!'
Warning: Expecting date in O103058 / R103058C15: got '#NULL!'
Warning: Expecting date in O103079 / R103079C15: got '#NULL!'
Warning: Expecting date in O103090 / R103090C15: got '#NULL!'
Warning: Expecting date in O103137 / R103137C15: got '#NULL!'
Warning: Expecting date in O103150 / R103150C15: got '#NULL!'
Warning: Expecting date in O103165 / R103165C15: got '#NULL!'
Warning: Expecting date in O103187 / R103187C15: got '#NULL!'
Warning: Expecting date in O103287 / R103287C15: got '#NULL!'
Warning: Expecting date in O103330 / R103330C15: got '#NULL!'
Warning: Expecting date in O103564 / R103564C15: got '#NULL!'
Warning: Expecting date in O103693 / R103693C15: got '#NULL!'
Warning: Expecting date in O103748 / R103748C15: got '#NULL!'
Warning: Expecting date in O103820 / R103820C15: got '#NULL!'
Warning: Expecting date in O103838 / R103838C15: got '#NULL!'
Warning: Expecting date in O103863 / R103863C15: got '#NULL!'
Warning: Expecting date in O103880 / R103880C15: got '#NULL!'
Warning: Expecting date in O103895 / R103895C15: got '#NULL!'
Warning: Expecting date in O103945 / R103945C15: got '#NULL!'
Warning: Expecting date in O104068 / R104068C15: got '#NULL!'
Warning: Expecting date in O104091 / R104091C15: got '#NULL!'
Warning: Expecting date in O104094 / R104094C15: got '#NULL!'
Warning: Expecting date in O104103 / R104103C15: got '#NULL!'
Warning: Expecting date in O104200 / R104200C15: got '#NULL!'
Warning: Expecting date in O104210 / R104210C15: got '#NULL!'
Warning: Expecting date in O104241 / R104241C15: got '#NULL!'
Warning: Expecting date in O104320 / R104320C15: got '#NULL!'
Warning: Expecting date in O104328 / R104328C15: got '#NULL!'
Warning: Expecting date in O104334 / R104334C15: got '#NULL!'
Warning: Expecting date in O104338 / R104338C15: got '#NULL!'
Warning: Expecting date in I104381 / R104381C9: got '#NULL!'
Warning: Expecting date in O104381 / R104381C15: got '#NULL!'
Warning: Expecting date in O104386 / R104386C15: got '#NULL!'
Warning: Expecting date in O104406 / R104406C15: got '#NULL!'
Warning: Expecting date in O104459 / R104459C15: got '#NULL!'
Warning: Expecting date in O104524 / R104524C15: got '#NULL!'
Warning: Expecting date in O104556 / R104556C15: got '#NULL!'
Warning: Expecting date in O104599 / R104599C15: got '#NULL!'
Warning: Expecting date in O104675 / R104675C15: got '#NULL!'
Warning: Expecting date in O104682 / R104682C15: got '#NULL!'
Warning: Expecting date in O104721 / R104721C15: got '#NULL!'
Warning: Expecting date in O104747 / R104747C15: got '#NULL!'
Warning: Expecting date in O104815 / R104815C15: got '#NULL!'
Warning: Expecting date in O104877 / R104877C15: got '#NULL!'
Warning: Expecting date in O104923 / R104923C15: got '#NULL!'
Warning: Expecting date in O104985 / R104985C15: got '#NULL!'
Warning: Expecting date in O105004 / R105004C15: got '#NULL!'
Warning: Expecting date in O105132 / R105132C15: got '#NULL!'
Warning: Expecting date in O105173 / R105173C15: got '#NULL!'
Warning: Expecting date in O105244 / R105244C15: got '#NULL!'
Warning: Expecting date in O105253 / R105253C15: got '#NULL!'
Warning: Expecting date in O105276 / R105276C15: got '#NULL!'
Warning: Expecting date in O105319 / R105319C15: got '#NULL!'
Warning: Expecting date in O105358 / R105358C15: got '#NULL!'
Warning: Expecting date in O105389 / R105389C15: got '#NULL!'
Warning: Expecting date in O105454 / R105454C15: got '#NULL!'
Warning: Expecting date in O105523 / R105523C15: got '#NULL!'
Warning: Expecting date in O105604 / R105604C15: got '#NULL!'
Warning: Expecting date in O105611 / R105611C15: got '#NULL!'
Warning: Expecting date in O105653 / R105653C15: got '#NULL!'
Warning: Expecting date in O105698 / R105698C15: got '#NULL!'
Warning: Expecting date in O105749 / R105749C15: got '#NULL!'
Warning: Expecting date in O105766 / R105766C15: got '#NULL!'
Warning: Expecting date in H105839 / R105839C8: got '#NULL!'
Warning: Expecting date in I105839 / R105839C9: got '#NULL!'
Warning: Expecting date in O105865 / R105865C15: got '#NULL!'
Warning: Expecting date in O105919 / R105919C15: got '#NULL!'
Warning: Expecting date in O105958 / R105958C15: got '#NULL!'
Warning: Expecting date in O105988 / R105988C15: got '#NULL!'
Warning: Expecting date in O106016 / R106016C15: got '#NULL!'
Warning: Expecting date in O106018 / R106018C15: got '#NULL!'
Warning: Expecting date in O106019 / R106019C15: got '#NULL!'
Warning: Expecting date in O106030 / R106030C15: got '#NULL!'
Warning: Expecting date in O106040 / R106040C15: got '#NULL!'
Warning: Expecting date in O106108 / R106108C15: got '#NULL!'
Warning: Expecting date in O106137 / R106137C15: got '#NULL!'
Warning: Expecting date in O106147 / R106147C15: got '#NULL!'
Warning: Expecting date in O106159 / R106159C15: got '#NULL!'
Warning: Expecting date in O106162 / R106162C15: got '#NULL!'
Warning: Expecting date in O106171 / R106171C15: got '#NULL!'
Warning: Expecting date in O106205 / R106205C15: got '#NULL!'
Warning: Expecting date in O106246 / R106246C15: got '#NULL!'
Warning: Expecting date in O106306 / R106306C15: got '#NULL!'
Warning: Expecting date in O106309 / R106309C15: got '#NULL!'
Warning: Expecting date in O106311 / R106311C15: got '#NULL!'
Warning: Expecting date in O106335 / R106335C15: got '#NULL!'
Warning: Expecting date in O106369 / R106369C15: got '#NULL!'
Warning: Expecting date in O106382 / R106382C15: got '#NULL!'
Warning: Expecting date in O106415 / R106415C15: got '#NULL!'
Warning: Expecting date in O106508 / R106508C15: got '#NULL!'
Warning: Expecting date in O106524 / R106524C15: got '#NULL!'
Warning: Expecting date in O106657 / R106657C15: got '#NULL!'
Warning: Expecting date in O106661 / R106661C15: got '#NULL!'
Warning: Expecting date in O106695 / R106695C15: got '#NULL!'
Warning: Expecting date in O106711 / R106711C15: got '#NULL!'
Warning: Expecting date in O106729 / R106729C15: got '#NULL!'
Warning: Expecting date in O106750 / R106750C15: got '#NULL!'
Warning: Expecting date in O106759 / R106759C15: got '#NULL!'
Warning: Expecting date in O106816 / R106816C15: got '#NULL!'
Warning: Expecting date in O106821 / R106821C15: got '#NULL!'
Warning: Expecting date in O106828 / R106828C15: got '#NULL!'
Warning: Expecting date in O106980 / R106980C15: got '#NULL!'
Warning: Expecting date in O107024 / R107024C15: got '#NULL!'
Warning: Expecting date in O107077 / R107077C15: got '#NULL!'
Warning: Expecting date in O107079 / R107079C15: got '#NULL!'
Warning: Expecting date in O107093 / R107093C15: got '#NULL!'
Warning: Expecting date in O107184 / R107184C15: got '#NULL!'
Warning: Expecting date in O107193 / R107193C15: got '#NULL!'
Warning: Expecting date in O107322 / R107322C15: got '#NULL!'
Warning: Expecting date in O107323 / R107323C15: got '#NULL!'
Warning: Expecting date in O107328 / R107328C15: got '#NULL!'
Warning: Expecting date in O107343 / R107343C15: got '#NULL!'
Warning: Expecting date in O107375 / R107375C15: got '#NULL!'
Warning: Expecting date in O107416 / R107416C15: got '#NULL!'
Warning: Expecting date in O107462 / R107462C15: got '#NULL!'
Warning: Expecting date in O107480 / R107480C15: got '#NULL!'
Warning: Expecting date in O107481 / R107481C15: got '#NULL!'
Warning: Expecting date in O107482 / R107482C15: got '#NULL!'
Warning: Expecting date in O107498 / R107498C15: got '#NULL!'
Warning: Expecting date in O107540 / R107540C15: got '#NULL!'
Warning: Expecting date in O107582 / R107582C15: got '#NULL!'
Warning: Expecting date in O107614 / R107614C15: got '#NULL!'
Warning: Expecting date in O107669 / R107669C15: got '#NULL!'
Warning: Expecting date in O107703 / R107703C15: got '#NULL!'
Warning: Expecting date in O107794 / R107794C15: got '#NULL!'
Warning: Expecting date in O107805 / R107805C15: got '#NULL!'
Warning: Expecting date in O107824 / R107824C15: got '#NULL!'
Warning: Expecting date in O107951 / R107951C15: got '#NULL!'
Warning: Expecting date in O107974 / R107974C15: got '#NULL!'
Warning: Expecting date in O108021 / R108021C15: got '#NULL!'
Warning: Expecting date in O108050 / R108050C15: got '#NULL!'
Warning: Expecting date in O108103 / R108103C15: got '#NULL!'
Warning: Expecting date in O108133 / R108133C15: got '#NULL!'
Warning: Expecting date in O108168 / R108168C15: got '#NULL!'
Warning: Expecting date in O108290 / R108290C15: got '#NULL!'
Warning: Expecting date in O108338 / R108338C15: got '#NULL!'
Warning: Expecting date in O108377 / R108377C15: got '#NULL!'
Warning: Expecting date in O108387 / R108387C15: got '#NULL!'
Warning: Expecting date in O108407 / R108407C15: got '#NULL!'
Warning: Expecting date in O108480 / R108480C15: got '#NULL!'
Warning: Expecting date in O108538 / R108538C15: got '#NULL!'
Warning: Expecting date in O108558 / R108558C15: got '#NULL!'
Warning: Expecting date in O108574 / R108574C15: got '#NULL!'
Warning: Expecting date in O108596 / R108596C15: got '#NULL!'
Warning: Expecting date in O108636 / R108636C15: got '#NULL!'
Warning: Expecting date in O108642 / R108642C15: got '#NULL!'
Warning: Expecting date in O108700 / R108700C15: got '#NULL!'
Warning: Expecting date in O108731 / R108731C15: got '#NULL!'
Warning: Expecting date in O108739 / R108739C15: got '#NULL!'
Warning: Expecting date in O108745 / R108745C15: got '#NULL!'
Warning: Expecting date in O108810 / R108810C15: got '#NULL!'
Warning: Expecting date in O108830 / R108830C15: got '#NULL!'
Warning: Expecting date in O108921 / R108921C15: got '#NULL!'
Warning: Expecting date in I108928 / R108928C9: got '#NULL!'
Warning: Expecting date in O108928 / R108928C15: got '#NULL!'
Warning: Expecting date in O108959 / R108959C15: got '#NULL!'
Warning: Expecting date in O108983 / R108983C15: got '#NULL!'
Warning: Expecting date in O108995 / R108995C15: got '#NULL!'
Warning: Expecting date in O109015 / R109015C15: got '#NULL!'
Warning: Expecting date in O109121 / R109121C15: got '#NULL!'
Warning: Expecting date in O109174 / R109174C15: got '#NULL!'
Warning: Expecting date in O109209 / R109209C15: got '#NULL!'
Warning: Expecting date in O109266 / R109266C15: got '#NULL!'
Warning: Expecting date in O109272 / R109272C15: got '#NULL!'
Warning: Expecting date in O109273 / R109273C15: got '#NULL!'
Warning: Expecting date in O109289 / R109289C15: got '#NULL!'
Warning: Expecting date in O109332 / R109332C15: got '#NULL!'
Warning: Expecting date in O109349 / R109349C15: got '#NULL!'
Warning: Expecting date in O109427 / R109427C15: got '#NULL!'
Warning: Expecting date in O109503 / R109503C15: got '#NULL!'
Warning: Expecting date in O109513 / R109513C15: got '#NULL!'
Warning: Expecting date in O109552 / R109552C15: got '#NULL!'
Warning: Expecting date in O109571 / R109571C15: got '#NULL!'
Warning: Expecting date in O109602 / R109602C15: got '#NULL!'
Warning: Expecting date in O109612 / R109612C15: got '#NULL!'
Warning: Expecting date in O109619 / R109619C15: got '#NULL!'
Warning: Expecting date in O109635 / R109635C15: got '#NULL!'
Warning: Expecting date in O109641 / R109641C15: got '#NULL!'
Warning: Expecting date in O109651 / R109651C15: got '#NULL!'
Warning: Expecting date in O109659 / R109659C15: got '#NULL!'
Warning: Expecting date in O109719 / R109719C15: got '#NULL!'
Warning: Expecting date in O109721 / R109721C15: got '#NULL!'
Warning: Expecting date in O109727 / R109727C15: got '#NULL!'
Warning: Expecting date in O109728 / R109728C15: got '#NULL!'
Warning: Expecting date in O109747 / R109747C15: got '#NULL!'
Warning: Expecting date in O109750 / R109750C15: got '#NULL!'
Warning: Expecting date in O109758 / R109758C15: got '#NULL!'
Warning: Expecting date in O109773 / R109773C15: got '#NULL!'
Warning: Expecting date in O109804 / R109804C15: got '#NULL!'
Warning: Expecting date in O109851 / R109851C15: got '#NULL!'
Warning: Expecting date in O109854 / R109854C15: got '#NULL!'
Warning: Expecting date in O109912 / R109912C15: got '#NULL!'
Warning: Expecting date in O109915 / R109915C15: got '#NULL!'
Warning: Expecting date in O109937 / R109937C15: got '#NULL!'
Warning: Expecting date in O109979 / R109979C15: got '#NULL!'
Warning: Expecting date in O109997 / R109997C15: got '#NULL!'
Warning: Expecting date in O110001 / R110001C15: got '#NULL!'
Warning: Expecting date in O110037 / R110037C15: got '#NULL!'
Warning: Expecting date in O110100 / R110100C15: got '#NULL!'
Warning: Expecting date in O110134 / R110134C15: got '#NULL!'
Warning: Expecting date in O110142 / R110142C15: got '#NULL!'
Warning: Expecting date in O110209 / R110209C15: got '#NULL!'
Warning: Expecting date in O110212 / R110212C15: got '#NULL!'
Warning: Expecting date in O110297 / R110297C15: got '#NULL!'
Warning: Expecting date in O110301 / R110301C15: got '#NULL!'
Warning: Expecting date in O110372 / R110372C15: got '#NULL!'
Warning: Expecting date in O110386 / R110386C15: got '#NULL!'
Warning: Expecting date in O110393 / R110393C15: got '#NULL!'
Warning: Expecting date in O110449 / R110449C15: got '#NULL!'
Warning: Expecting date in O110455 / R110455C15: got '#NULL!'
Warning: Expecting date in O110469 / R110469C15: got '#NULL!'
Warning: Expecting date in O110491 / R110491C15: got '#NULL!'
Warning: Expecting date in O110494 / R110494C15: got '#NULL!'
Warning: Expecting date in O110500 / R110500C15: got '#NULL!'
Warning: Expecting date in O110514 / R110514C15: got '#NULL!'
Warning: Expecting date in O110583 / R110583C15: got '#NULL!'
Warning: Expecting date in O110586 / R110586C15: got '#NULL!'
Warning: Expecting date in O110588 / R110588C15: got '#NULL!'
Warning: Expecting date in O110589 / R110589C15: got '#NULL!'
Warning: Expecting date in O110593 / R110593C15: got '#NULL!'
Warning: Expecting date in O110609 / R110609C15: got '#NULL!'
Warning: Expecting date in O110618 / R110618C15: got '#NULL!'
Warning: Expecting date in O110640 / R110640C15: got '#NULL!'
Warning: Expecting date in O110705 / R110705C15: got '#NULL!'
Warning: Expecting date in O110713 / R110713C15: got '#NULL!'
Warning: Expecting date in O110745 / R110745C15: got '#NULL!'
Warning: Expecting date in O110772 / R110772C15: got '#NULL!'
Warning: Expecting date in O110795 / R110795C15: got '#NULL!'
Warning: Expecting date in O110800 / R110800C15: got '#NULL!'
Warning: Expecting date in O110815 / R110815C15: got '#NULL!'
Warning: Expecting date in O110856 / R110856C15: got '#NULL!'
Warning: Expecting date in O110863 / R110863C15: got '#NULL!'
Warning: Expecting date in O110877 / R110877C15: got '#NULL!'
Warning: Expecting date in O110890 / R110890C15: got '#NULL!'
Warning: Expecting date in O110914 / R110914C15: got '#NULL!'
Warning: Expecting date in O110955 / R110955C15: got '#NULL!'
Warning: Expecting date in O110997 / R110997C15: got '#NULL!'
Warning: Expecting date in O111004 / R111004C15: got '#NULL!'
Warning: Expecting date in O111015 / R111015C15: got '#NULL!'
Warning: Expecting date in O111017 / R111017C15: got '#NULL!'
Warning: Expecting date in O111070 / R111070C15: got '#NULL!'
Warning: Expecting date in O111074 / R111074C15: got '#NULL!'
Warning: Expecting date in O111076 / R111076C15: got '#NULL!'
Warning: Expecting date in O111103 / R111103C15: got '#NULL!'
Warning: Expecting date in O111121 / R111121C15: got '#NULL!'
Warning: Expecting date in O111127 / R111127C15: got '#NULL!'
Warning: Expecting date in O111140 / R111140C15: got '#NULL!'
Warning: Expecting date in O111145 / R111145C15: got '#NULL!'
Warning: Expecting date in O111148 / R111148C15: got '#NULL!'
Warning: Expecting date in O111156 / R111156C15: got '#NULL!'
Warning: Expecting date in O111171 / R111171C15: got '#NULL!'
Warning: Expecting date in O111191 / R111191C15: got '#NULL!'
Warning: Expecting date in O111204 / R111204C15: got '#NULL!'
Warning: Expecting date in O111238 / R111238C15: got '#NULL!'
Warning: Expecting date in O111255 / R111255C15: got '#NULL!'
Warning: Expecting date in O111265 / R111265C15: got '#NULL!'
Warning: Expecting date in O111268 / R111268C15: got '#NULL!'
Warning: Expecting date in O111282 / R111282C15: got '#NULL!'
Warning: Expecting date in O111410 / R111410C15: got '#NULL!'
Warning: Expecting date in O111417 / R111417C15: got '#NULL!'
Warning: Expecting date in O111446 / R111446C15: got '#NULL!'
Warning: Expecting date in O111474 / R111474C15: got '#NULL!'
Warning: Expecting date in O111586 / R111586C15: got '#NULL!'
Warning: Expecting date in O111595 / R111595C15: got '#NULL!'
Warning: Expecting date in O111599 / R111599C15: got '#NULL!'
Warning: Expecting date in O111625 / R111625C15: got '#NULL!'
Warning: Expecting date in O111658 / R111658C15: got '#NULL!'
Warning: Expecting date in O111670 / R111670C15: got '#NULL!'
Warning: Expecting date in O111800 / R111800C15: got '#NULL!'
Warning: Expecting date in O111801 / R111801C15: got '#NULL!'
Warning: Expecting date in O111812 / R111812C15: got '#NULL!'
Warning: Expecting date in O111842 / R111842C15: got '#NULL!'
Warning: Expecting date in I111845 / R111845C9: got '#NULL!'
Warning: Expecting date in O111845 / R111845C15: got '#NULL!'
Warning: Expecting date in O111948 / R111948C15: got '#NULL!'
Warning: Expecting date in O111949 / R111949C15: got '#NULL!'
Warning: Expecting date in O111981 / R111981C15: got '#NULL!'
Warning: Expecting date in O112000 / R112000C15: got '#NULL!'
Warning: Expecting date in O112070 / R112070C15: got '#NULL!'
Warning: Expecting date in O112095 / R112095C15: got '#NULL!'
Warning: Expecting date in O112110 / R112110C15: got '#NULL!'
Warning: Expecting date in O112201 / R112201C15: got '#NULL!'
Warning: Expecting date in O112324 / R112324C15: got '#NULL!'
Warning: Expecting date in O112484 / R112484C15: got '#NULL!'
Warning: Expecting date in O112504 / R112504C15: got '#NULL!'
Warning: Expecting date in O112695 / R112695C15: got '#NULL!'
Warning: Expecting date in O112727 / R112727C15: got '#NULL!'
Warning: Expecting date in O112845 / R112845C15: got '#NULL!'
Warning: Expecting date in O112855 / R112855C15: got '#NULL!'
Warning: Expecting date in O112899 / R112899C15: got '#NULL!'
Warning: Expecting date in O112929 / R112929C15: got '#NULL!'
Warning: Expecting date in O113055 / R113055C15: got '#NULL!'
Warning: Expecting date in O113066 / R113066C15: got '#NULL!'
Warning: Expecting date in O113073 / R113073C15: got '#NULL!'
Warning: Expecting date in O113131 / R113131C15: got '#NULL!'
Warning: Expecting date in O113155 / R113155C15: got '#NULL!'
Warning: Expecting date in O113192 / R113192C15: got '#NULL!'
Warning: Expecting date in O113210 / R113210C15: got '#NULL!'
Warning: Expecting date in O113320 / R113320C15: got '#NULL!'
Warning: Expecting date in O113400 / R113400C15: got '#NULL!'
Warning: Expecting date in O113442 / R113442C15: got '#NULL!'
Warning: Expecting date in O113459 / R113459C15: got '#NULL!'
Warning: Expecting date in O113560 / R113560C15: got '#NULL!'
Warning: Expecting date in O113683 / R113683C15: got '#NULL!'
Warning: Expecting date in O113724 / R113724C15: got '#NULL!'
Warning: Expecting date in O113982 / R113982C15: got '#NULL!'
Warning: Expecting date in O114010 / R114010C15: got '#NULL!'
Warning: Expecting date in O114045 / R114045C15: got '#NULL!'
Warning: Expecting date in O114067 / R114067C15: got '#NULL!'
Warning: Expecting date in O114143 / R114143C15: got '#NULL!'
Warning: Expecting date in O114182 / R114182C15: got '#NULL!'
Warning: Expecting date in O114200 / R114200C15: got '#NULL!'
Warning: Expecting date in O114246 / R114246C15: got '#NULL!'
Warning: Expecting date in O114304 / R114304C15: got '#NULL!'
Warning: Expecting date in O114316 / R114316C15: got '#NULL!'
Warning: Expecting date in O114325 / R114325C15: got '#NULL!'
Warning: Expecting date in O114337 / R114337C15: got '#NULL!'
Warning: Expecting date in O114424 / R114424C15: got '#NULL!'
Warning: Expecting date in O114430 / R114430C15: got '#NULL!'
Warning: Expecting date in O114502 / R114502C15: got '#NULL!'
Warning: Expecting date in O114603 / R114603C15: got '#NULL!'
Warning: Expecting date in O114623 / R114623C15: got '#NULL!'
Warning: Expecting date in O114687 / R114687C15: got '#NULL!'
Warning: Expecting date in O114736 / R114736C15: got '#NULL!'
Warning: Expecting date in O114873 / R114873C15: got '#NULL!'
Warning: Expecting date in O114934 / R114934C15: got '#NULL!'
Warning: Expecting date in O114972 / R114972C15: got '#NULL!'
Warning: Expecting date in O114992 / R114992C15: got '#NULL!'
Warning: Expecting date in O115002 / R115002C15: got '#NULL!'
Warning: Expecting date in O115037 / R115037C15: got '#NULL!'
Warning: Expecting date in O115093 / R115093C15: got '#NULL!'
Warning: Expecting date in O115107 / R115107C15: got '#NULL!'
Warning: Expecting date in O115214 / R115214C15: got '#NULL!'
Warning: Expecting date in O115354 / R115354C15: got '#NULL!'
Warning: Expecting date in O115363 / R115363C15: got '#NULL!'
Warning: Expecting date in O115385 / R115385C15: got '#NULL!'
Warning: Expecting date in O115456 / R115456C15: got '#NULL!'
Warning: Expecting date in O115480 / R115480C15: got '#NULL!'
Warning: Expecting date in O115513 / R115513C15: got '#NULL!'
Warning: Expecting date in O115623 / R115623C15: got '#NULL!'
Warning: Expecting date in O115683 / R115683C15: got '#NULL!'
Warning: Expecting date in O115794 / R115794C15: got '#NULL!'
Warning: Expecting date in O115818 / R115818C15: got '#NULL!'
Warning: Expecting date in O115835 / R115835C15: got '#NULL!'
Warning: Expecting date in O115923 / R115923C15: got '#NULL!'
Warning: Expecting date in O116023 / R116023C15: got '#NULL!'
Warning: Expecting date in O116033 / R116033C15: got '#NULL!'
Warning: Expecting date in O116044 / R116044C15: got '#NULL!'
Warning: Expecting date in O116070 / R116070C15: got '#NULL!'
Warning: Expecting date in O116095 / R116095C15: got '#NULL!'
Warning: Expecting date in O116147 / R116147C15: got '#NULL!'
Warning: Expecting date in O116171 / R116171C15: got '#NULL!'
Warning: Expecting date in O116257 / R116257C15: got '#NULL!'
Warning: Expecting date in O116267 / R116267C15: got '#NULL!'
Warning: Expecting date in O116326 / R116326C15: got '#NULL!'
Warning: Expecting date in O116421 / R116421C15: got '#NULL!'
Warning: Expecting date in O116480 / R116480C15: got '#NULL!'
Warning: Expecting date in O116525 / R116525C15: got '#NULL!'
Warning: Expecting date in O116541 / R116541C15: got '#NULL!'
Warning: Expecting date in O116547 / R116547C15: got '#NULL!'
Warning: Expecting date in O116570 / R116570C15: got '#NULL!'
Warning: Expecting date in O116618 / R116618C15: got '#NULL!'
Warning: Expecting date in O116651 / R116651C15: got '#NULL!'
Warning: Expecting date in O116732 / R116732C15: got '#NULL!'
Warning: Expecting date in O116792 / R116792C15: got '#NULL!'
Warning: Expecting date in O116794 / R116794C15: got '#NULL!'
Warning: Expecting date in O116834 / R116834C15: got '#NULL!'
Warning: Expecting date in O116872 / R116872C15: got '#NULL!'
Warning: Expecting date in O116876 / R116876C15: got '#NULL!'
Warning: Expecting date in O116949 / R116949C15: got '#NULL!'
Warning: Expecting date in O117005 / R117005C15: got '#NULL!'
Warning: Expecting date in O117073 / R117073C15: got '#NULL!'
Warning: Expecting date in O117163 / R117163C15: got '#NULL!'
Warning: Expecting date in O117194 / R117194C15: got '#NULL!'
Warning: Expecting date in O117202 / R117202C15: got '#NULL!'
Warning: Expecting date in O117224 / R117224C15: got '#NULL!'
Warning: Expecting date in O117227 / R117227C15: got '#NULL!'
Warning: Expecting date in O117254 / R117254C15: got '#NULL!'
Warning: Expecting date in O117271 / R117271C15: got '#NULL!'
Warning: Expecting date in O117295 / R117295C15: got '#NULL!'
Warning: Expecting date in O117414 / R117414C15: got '#NULL!'
Warning: Expecting date in O117437 / R117437C15: got '#NULL!'
Warning: Expecting date in O117481 / R117481C15: got '#NULL!'
Warning: Expecting date in O117503 / R117503C15: got '#NULL!'
Warning: Expecting date in O117520 / R117520C15: got '#NULL!'
Warning: Expecting date in O117621 / R117621C15: got '#NULL!'
Warning: Expecting date in O117693 / R117693C15: got '#NULL!'
Warning: Expecting date in O117852 / R117852C15: got '#NULL!'
Warning: Expecting date in O117887 / R117887C15: got '#NULL!'
Warning: Expecting date in O117893 / R117893C15: got '#NULL!'
Warning: Expecting date in O117924 / R117924C15: got '#NULL!'
Warning: Expecting date in O118033 / R118033C15: got '#NULL!'
Warning: Expecting date in I118148 / R118148C9: got '#NULL!'
Warning: Expecting date in O118148 / R118148C15: got '#NULL!'
Warning: Expecting date in O118226 / R118226C15: got '#NULL!'
Warning: Expecting date in O118289 / R118289C15: got '#NULL!'
Warning: Expecting date in O118301 / R118301C15: got '#NULL!'
Warning: Expecting date in O118452 / R118452C15: got '#NULL!'
Warning: Expecting date in O118509 / R118509C15: got '#NULL!'
Warning: Expecting date in O118530 / R118530C15: got '#NULL!'
Warning: Expecting date in O118549 / R118549C15: got '#NULL!'
Warning: Expecting date in O118552 / R118552C15: got '#NULL!'
Warning: Expecting date in O118679 / R118679C15: got '#NULL!'
Warning: Expecting date in O118885 / R118885C15: got '#NULL!'
Warning: Expecting date in O118917 / R118917C15: got '#NULL!'
Warning: Expecting date in O118918 / R118918C15: got '#NULL!'
Warning: Expecting date in O119018 / R119018C15: got '#NULL!'
Warning: Expecting date in O119134 / R119134C15: got '#NULL!'
Warning: Expecting date in O119144 / R119144C15: got '#NULL!'
Warning: Expecting date in O119150 / R119150C15: got '#NULL!'
Warning: Expecting date in O119181 / R119181C15: got '#NULL!'
Warning: Expecting date in O119429 / R119429C15: got '#NULL!'
Warning: Expecting date in O119502 / R119502C15: got '#NULL!'
Warning: Expecting date in O119541 / R119541C15: got '#NULL!'
Warning: Expecting date in O119570 / R119570C15: got '#NULL!'
Warning: Expecting date in O119752 / R119752C15: got '#NULL!'
Warning: Expecting date in O119896 / R119896C15: got '#NULL!'
Warning: Expecting date in O119904 / R119904C15: got '#NULL!'
Warning: Expecting date in O120038 / R120038C15: got '#NULL!'
Warning: Expecting date in O120102 / R120102C15: got '#NULL!'
Warning: Expecting date in O120125 / R120125C15: got '#NULL!'
Warning: Expecting date in O120131 / R120131C15: got '#NULL!'
Warning: Expecting date in O120132 / R120132C15: got '#NULL!'
Warning: Expecting date in O120236 / R120236C15: got '#NULL!'
Warning: Expecting date in O120306 / R120306C15: got '#NULL!'
Warning: Expecting date in O120312 / R120312C15: got '#NULL!'
Warning: Expecting date in O120370 / R120370C15: got '#NULL!'
Warning: Expecting date in O120468 / R120468C15: got '#NULL!'
Warning: Expecting date in O120481 / R120481C15: got '#NULL!'
Warning: Expecting date in O120500 / R120500C15: got '#NULL!'
Warning: Expecting date in O120570 / R120570C15: got '#NULL!'
Warning: Expecting date in O120602 / R120602C15: got '#NULL!'
Warning: Expecting date in O120710 / R120710C15: got '#NULL!'
Warning: Expecting date in O120781 / R120781C15: got '#NULL!'
Warning: Expecting date in O120816 / R120816C15: got '#NULL!'
Warning: Expecting date in O120817 / R120817C15: got '#NULL!'
Warning: Expecting date in O120843 / R120843C15: got '#NULL!'
Warning: Expecting date in O120864 / R120864C15: got '#NULL!'
Warning: Expecting date in O120872 / R120872C15: got '#NULL!'
Warning: Expecting date in O120903 / R120903C15: got '#NULL!'
Warning: Expecting date in O120917 / R120917C15: got '#NULL!'
Warning: Expecting date in O120957 / R120957C15: got '#NULL!'
Warning: Expecting date in O120959 / R120959C15: got '#NULL!'
Warning: Expecting date in O120976 / R120976C15: got '#NULL!'
Warning: Expecting date in O121079 / R121079C15: got '#NULL!'
Warning: Expecting date in O121083 / R121083C15: got '#NULL!'
Warning: Expecting date in O121092 / R121092C15: got '#NULL!'
Warning: Expecting date in O121123 / R121123C15: got '#NULL!'
Warning: Expecting date in O121153 / R121153C15: got '#NULL!'
Warning: Expecting date in O121169 / R121169C15: got '#NULL!'
Warning: Expecting date in O121242 / R121242C15: got '#NULL!'
Warning: Expecting date in O121260 / R121260C15: got '#NULL!'
Warning: Expecting date in O121341 / R121341C15: got '#NULL!'
Warning: Expecting date in O121371 / R121371C15: got '#NULL!'
Warning: Expecting date in O121425 / R121425C15: got '#NULL!'
Warning: Expecting date in O121456 / R121456C15: got '#NULL!'
Warning: Expecting date in O121510 / R121510C15: got '#NULL!'
Warning: Expecting date in O121511 / R121511C15: got '#NULL!'
Warning: Expecting date in O121564 / R121564C15: got '#NULL!'
Warning: Expecting date in O121590 / R121590C15: got '#NULL!'
Warning: Expecting date in O121607 / R121607C15: got '#NULL!'
Warning: Expecting date in O121622 / R121622C15: got '#NULL!'
Warning: Expecting date in O121665 / R121665C15: got '#NULL!'
Warning: Expecting date in O121687 / R121687C15: got '#NULL!'
Warning: Expecting date in O121747 / R121747C15: got '#NULL!'
Warning: Expecting date in O121751 / R121751C15: got '#NULL!'
Warning: Expecting date in O121769 / R121769C15: got '#NULL!'
Warning: Expecting date in O121884 / R121884C15: got '#NULL!'
Warning: Expecting date in O121914 / R121914C15: got '#NULL!'
Warning: Expecting date in O121943 / R121943C15: got '#NULL!'
Warning: Expecting date in O121982 / R121982C15: got '#NULL!'
Warning: Expecting date in O122005 / R122005C15: got '#NULL!'
Warning: Expecting date in O122064 / R122064C15: got '#NULL!'
Warning: Expecting date in O122080 / R122080C15: got '#NULL!'
Warning: Expecting date in O122099 / R122099C15: got '#NULL!'
Warning: Expecting date in O122125 / R122125C15: got '#NULL!'
Warning: Expecting date in O122210 / R122210C15: got '#NULL!'
Warning: Expecting date in O122258 / R122258C15: got '#NULL!'
Warning: Expecting date in O122271 / R122271C15: got '#NULL!'
Warning: Expecting date in O122378 / R122378C15: got '#NULL!'
Warning: Expecting date in O122383 / R122383C15: got '#NULL!'
Warning: Expecting date in O122398 / R122398C15: got '#NULL!'
Warning: Expecting date in O122436 / R122436C15: got '#NULL!'
Warning: Expecting date in O122477 / R122477C15: got '#NULL!'
Warning: Expecting date in O122486 / R122486C15: got '#NULL!'
Warning: Expecting date in O122558 / R122558C15: got '#NULL!'
Warning: Expecting date in O122613 / R122613C15: got '#NULL!'
Warning: Expecting date in O122675 / R122675C15: got '#NULL!'
Warning: Expecting date in O122852 / R122852C15: got '#NULL!'
Warning: Expecting date in O122878 / R122878C15: got '#NULL!'
Warning: Expecting date in O122891 / R122891C15: got '#NULL!'
Warning: Expecting date in O122896 / R122896C15: got '#NULL!'
Warning: Expecting date in O122900 / R122900C15: got '#NULL!'
Warning: Expecting date in O122997 / R122997C15: got '#NULL!'
Warning: Expecting date in O123034 / R123034C15: got '#NULL!'
Warning: Expecting date in I123068 / R123068C9: got '#NULL!'
Warning: Expecting date in O123068 / R123068C15: got '#NULL!'
Warning: Expecting date in O123186 / R123186C15: got '#NULL!'
Warning: Expecting date in O123191 / R123191C15: got '#NULL!'
Warning: Expecting date in O123218 / R123218C15: got '#NULL!'
Warning: Expecting date in O123278 / R123278C15: got '#NULL!'
Warning: Expecting date in O123280 / R123280C15: got '#NULL!'
Warning: Expecting date in O123299 / R123299C15: got '#NULL!'
Warning: Expecting date in O123354 / R123354C15: got '#NULL!'
Warning: Expecting date in O123428 / R123428C15: got '#NULL!'
Warning: Expecting date in O123470 / R123470C15: got '#NULL!'
Warning: Expecting date in O123478 / R123478C15: got '#NULL!'
Warning: Expecting date in O123518 / R123518C15: got '#NULL!'
Warning: Expecting date in O123542 / R123542C15: got '#NULL!'
Warning: Expecting date in O123575 / R123575C15: got '#NULL!'
Warning: Expecting date in O123576 / R123576C15: got '#NULL!'
Warning: Expecting date in O123596 / R123596C15: got '#NULL!'
Warning: Expecting date in I123603 / R123603C9: got '#NULL!'
Warning: Expecting date in O123603 / R123603C15: got '#NULL!'
Warning: Expecting date in O123699 / R123699C15: got '#NULL!'
Warning: Expecting date in O123737 / R123737C15: got '#NULL!'
Warning: Expecting date in O123827 / R123827C15: got '#NULL!'
Warning: Expecting date in O123866 / R123866C15: got '#NULL!'
Warning: Expecting date in O123891 / R123891C15: got '#NULL!'
Warning: Expecting date in O123930 / R123930C15: got '#NULL!'
Warning: Expecting date in O123993 / R123993C15: got '#NULL!'
Warning: Expecting date in O124007 / R124007C15: got '#NULL!'
Warning: Expecting date in O124042 / R124042C15: got '#NULL!'
Warning: Expecting date in O124043 / R124043C15: got '#NULL!'
Warning: Expecting date in O124090 / R124090C15: got '#NULL!'
Warning: Expecting date in O124107 / R124107C15: got '#NULL!'
Texas_Pop_2021 <- read_excel("~/Library/CloudStorage/Box-Box/Company/Working files/LPT & Aging in Prison/Texas/Texas.Data.PIA/CY2021/On Hand Inmate Data 0721.xlsx")
Texas_Pop_2022 <- read_excel("~/Library/CloudStorage/Box-Box/Company/Working files/LPT & Aging in Prison/Texas/Texas.Data.PIA/CY2022/On Hand Inmate Data 0722.xlsx")
Texas_Pop_2023 <- read_excel("~/Library/CloudStorage/Box-Box/Company/Working files/LPT & Aging in Prison/Texas/Texas.Data.PIA/CY2023/On Hand Inmate Data 0723.xlsx")
Texas_Pop_2024 <- read_excel("~/Library/CloudStorage/Box-Box/Company/Working files/LPT & Aging in Prison/Texas/Texas.Data.PIA/CY2024/On Hand Inmate Data 0724.xlsx")

# Store datasets in a list
df_list <- list(Texas_Pop_2016, Texas_Pop_2017, Texas_Pop_2018, Texas_Pop_2019, Texas_Pop_2020, Texas_Pop_2021, Texas_Pop_2022, Texas_Pop_2023, Texas_Pop_2024)

# Assign correct cohort years
years <- 2016:2024
names(df_list) <- years

# Add snapshot year column to each dataset
for (i in seq_along(df_list)) {
  df_list[[i]]$Year <- years[i]
}

#Cleaning Date

# Function to standardize date columns before merging
# Define correct column names (update if necessary)
library(dplyr)
colnames(Texas_Pop_2016) <- tolower(colnames(Texas_Pop_2016))  # Convert to lowercase
colnames(Texas_Pop_2016) <- gsub("\\s+", "_", colnames(Texas_Pop_2016))

# Standardize column names manually
colnames(Texas_Pop_2017) <- tolower(colnames(Texas_Pop_2017))  # Convert to lowercase
colnames(Texas_Pop_2017) <- gsub("\\s+", "_", colnames(Texas_Pop_2017))

# Standardize column names manually
colnames(Texas_Pop_2018) <- tolower(colnames(Texas_Pop_2018))  # Convert to lowercase
colnames(Texas_Pop_2018) <- gsub("\\s+", "_", colnames(Texas_Pop_2018))

# Standardize column names manually
colnames(Texas_Pop_2019) <- tolower(colnames(Texas_Pop_2019))  # Convert to lowercase
colnames(Texas_Pop_2019) <- gsub("\\s+", "_", colnames(Texas_Pop_2019))

# Standardize column names manually
colnames(Texas_Pop_2020) <- tolower(colnames(Texas_Pop_2020))  # Convert to lowercase
colnames(Texas_Pop_2020) <- gsub("\\s+", "_", colnames(Texas_Pop_2020))

# Standardize column names manually
colnames(Texas_Pop_2021) <- tolower(colnames(Texas_Pop_2021))  # Convert to lowercase
colnames(Texas_Pop_2021) <- gsub("\\s+", "_", colnames(Texas_Pop_2021))

# Standardize column names manually
colnames(Texas_Pop_2022) <- tolower(colnames(Texas_Pop_2022))  # Convert to lowercase
colnames(Texas_Pop_2022) <- gsub("\\s+", "_", colnames(Texas_Pop_2022))

# Standardize column names manually
colnames(Texas_Pop_2023) <- tolower(colnames(Texas_Pop_2023))  # Convert to lowercase
colnames(Texas_Pop_2023) <- gsub("\\s+", "_", colnames(Texas_Pop_2023))

# Standardize column names manually
colnames(Texas_Pop_2024) <- tolower(colnames(Texas_Pop_2024))  # Convert to lowercase
colnames(Texas_Pop_2024) <- gsub("\\s+", "_", colnames(Texas_Pop_2024))
library(dplyr)
# Function to convert date columns to Date format
convert_dates <- function(df) {
  df %>%
    mutate(
      sentence_date = if ("sentence_date" %in% colnames(df)) as.Date(sentence_date, format = "%Y-%m-%d") else NA,
      projected_release = if ("projected_release" %in% colnames(df)) as.Date(projected_release, format = "%Y-%m-%d") else NA,
      maximum_sentence_date = if ("maximum_sentence_date" %in% colnames(df)) as.Date(maximum_sentence_date, format = "%Y-%m-%d") else NA,
      parole_eligibility_date = if ("parole_eligibility_date" %in% colnames(df)) as.Date(parole_eligibility_date, format = "%Y-%m-%d") else NA,
      next_parole_review_date = if ("next_parole_review_date" %in% colnames(df)) as.Date(next_parole_review_date, format = "%Y-%m-%d") else NA
    )
}
# List of datasets
df_list <- list(Texas_Pop_2016, Texas_Pop_2017, Texas_Pop_2018, Texas_Pop_2019, Texas_Pop_2020, Texas_Pop_2021, Texas_Pop_2022, Texas_Pop_2023, Texas_Pop_2024)
# Function to rename or remove duplicate columns
fix_duplicate_columns <- function(df) {
  colnames(df) <- make.unique(colnames(df))  # Make duplicate names unique
  return(df)
}

# Apply function to all datasets
df_list <- lapply(df_list, fix_duplicate_columns)
# Apply function to all datasets
df_list <- lapply(df_list, convert_dates)

# Reassign cleaned datasets back to original variables
Texas_Pop_2016 <- df_list[[1]]
Texas_Pop_2017 <- df_list[[2]]
Texas_Pop_2018 <- df_list[[3]]
Texas_Pop_2019 <- df_list[[4]]
Texas_Pop_2020 <- df_list[[5]]
Texas_Pop_2021 <- df_list[[6]]
Texas_Pop_2022 <- df_list[[7]]
Texas_Pop_2023 <- df_list[[8]]
Texas_Pop_2024 <- df_list[[9]]
# List of datasets with corresponding years
df_list <- list(
  "2016" = Texas_Pop_2016,
  "2017" = Texas_Pop_2017,
  "2018" = Texas_Pop_2018,
  "2019" = Texas_Pop_2019,
  "2020" = Texas_Pop_2020,
  "2021" = Texas_Pop_2021,
  "2022" = Texas_Pop_2022,
  "2023" = Texas_Pop_2023,
  "2024" = Texas_Pop_2024
)

# Loop through each dataset and add `cohort_year`
df_list <- lapply(names(df_list), function(year) {
  df <- df_list[[year]]  # Get the dataframe
  df$cohort_year <- as.numeric(year)  # Assign the correct cohort year
  return(df)
})

# Reassign cleaned datasets back to original variables
Texas_Pop_2016 <- df_list[[1]]
Texas_Pop_2017 <- df_list[[2]]
Texas_Pop_2018 <- df_list[[3]]
Texas_Pop_2019 <- df_list[[4]]
Texas_Pop_2020 <- df_list[[5]]
Texas_Pop_2021 <- df_list[[6]]
Texas_Pop_2022 <- df_list[[7]]
Texas_Pop_2023 <- df_list[[8]]
Texas_Pop_2024 <- df_list[[9]]
library(dplyr)
library(lubridate)  # Needed for year() function

# Function to extract sentenced_year and calculate incarceration stats
calculate_incarceration_stats <- function(df) {
  df %>%
    mutate(
      sentenced_year = year(sentence_date),  # Extract the year from sentence_date
      birth_year = cohort_year - age,  # Calculate birth year
      estimated_age_at_admission = sentenced_year - birth_year,  # Age at admission
      LOS_Years = cohort_year - sentenced_year  # Length of stay in years
    )
}

# List of datasets
df_list <- list(Texas_Pop_2016, Texas_Pop_2017, Texas_Pop_2018, Texas_Pop_2019, 
                Texas_Pop_2020, Texas_Pop_2021, Texas_Pop_2022, Texas_Pop_2023, Texas_Pop_2024)

# Apply function to all datasets
df_list <- lapply(df_list, calculate_incarceration_stats)

# Reassign modified datasets back to original variables
Texas_Pop_2016 <- df_list[[1]]
Texas_Pop_2017 <- df_list[[2]]
Texas_Pop_2018 <- df_list[[3]]
Texas_Pop_2019 <- df_list[[4]]
Texas_Pop_2020 <- df_list[[5]]
Texas_Pop_2021 <- df_list[[6]]
Texas_Pop_2022 <- df_list[[7]]
Texas_Pop_2023 <- df_list[[8]]
Texas_Pop_2024 <- df_list[[9]]
library(dplyr)

# Function to filter LPT (15+ years) and categorize age groups
process_lpt_data <- function(df) {
  df %>%
    filter(LOS_Years >= 15) %>%  # Filter only individuals serving 15+ years
    mutate(
      # Categorizing Age at Admission
      Admin_Age_Group = case_when(
        estimated_age_at_admission < 18 ~ "Youth",
        estimated_age_at_admission >= 18 & estimated_age_at_admission < 25 ~ "Emerging Adult",
        TRUE ~ "Other"
      ),
      
      # Categorizing Current Age
      Current_Age_Group = case_when(
        age >= 55 ~ "Aging Population",
        TRUE ~ "Other"
      )
    )
}
# List of datasets
df_list <- list(Texas_Pop_2016, Texas_Pop_2017, Texas_Pop_2018, Texas_Pop_2019, 
                Texas_Pop_2020, Texas_Pop_2021, Texas_Pop_2022, Texas_Pop_2023, Texas_Pop_2024)

# Apply function to all datasets
df_list <- lapply(df_list, process_lpt_data)

# Reassign filtered datasets back to original variables
Texas_Pop_2016 <- df_list[[1]]
Texas_Pop_2017 <- df_list[[2]]
Texas_Pop_2018 <- df_list[[3]]
Texas_Pop_2019 <- df_list[[4]]
Texas_Pop_2020 <- df_list[[5]]
Texas_Pop_2021 <- df_list[[6]]
Texas_Pop_2022 <- df_list[[7]]
Texas_Pop_2023 <- df_list[[8]]
Texas_Pop_2024 <- df_list[[9]]
library(dplyr)
library(lubridate)

# Define the cutoff date (July 1, 2024)
cutoff_date <- as.Date("2024-07-01")

# Combine all datasets into a single dataframe
texas_lpt_combined <- bind_rows(df_list, .id = "source_df")

# Ensure maximum_sentence_date is in Date format
texas_lpt_combined <- texas_lpt_combined %>%
  mutate(maximum_sentence_date = as.Date(maximum_sentence_date, format = "%Y-%m-%d"))

# Identify individuals who were serving an LPT at any time
lpt_individuals <- texas_lpt_combined %>%
  filter(LOS_Years >= 15) %>%
  select(tdcj_number, maximum_sentence_date) %>%
  distinct()

# Identify individuals whose max sentence date extends beyond July 1, 2024
still_incarcerated <- lpt_individuals %>%
  filter(maximum_sentence_date > cutoff_date) %>%
  select(tdcj_number)

# Identify individuals who are missing from the 2024 dataset and have a max sentence date before or on July 1, 2024
individuals_missing_in_2024 <- setdiff(lpt_individuals$tdcj_number, 
                                       texas_lpt_combined$tdcj_number[texas_lpt_combined$cohort_year == 2024])

released_or_deceased <- lpt_individuals %>%
  filter(tdcj_number %in% individuals_missing_in_2024 & maximum_sentence_date <= cutoff_date) %>%
  select(tdcj_number)

# Merge back to the combined dataset
texas_lpt_combined <- texas_lpt_combined %>%
  mutate(
    still_incarcerated = ifelse(tdcj_number %in% still_incarcerated$tdcj_number, TRUE, FALSE),
    released_or_deceased = ifelse(tdcj_number %in% released_or_deceased$tdcj_number, TRUE, FALSE)
  )

# Check summary
table(texas_lpt_combined$still_incarcerated)

 FALSE   TRUE 
 11418 147819 
table(texas_lpt_combined$released_or_deceased)

 FALSE   TRUE 
147454  11783 
library(dplyr)
library(ggplot2)
library(lubridate)

# Combine all datasets into a single dataframe
texas_lpt_combined <- bind_rows(df_list, .id = "source_df")

# Convert maximum sentence date to Date format
texas_lpt_combined <- texas_lpt_combined %>%
  mutate(maximum_sentence_date = as.Date(maximum_sentence_date, format = "%Y-%m-%d"))

# Identify individuals with maximum sentence date beyond July 1, 2024
texas_lpt_combined <- texas_lpt_combined %>%
  mutate(still_incarcerated_after_2024 = ifelse(maximum_sentence_date > as.Date("2024-07-01"), TRUE, FALSE))

# Summary of still incarcerated individuals
table(texas_lpt_combined$still_incarcerated_after_2024)

 FALSE   TRUE 
 11680 147432 
# Count number of LPT individuals by cohort year
lpt_growth <- texas_lpt_combined %>%
  group_by(cohort_year) %>%
  summarize(total_LPT = n())

# Plot the trend of LPT cases over time
ggplot(lpt_growth, aes(x = cohort_year, y = total_LPT)) +
  geom_line() +
  geom_point() +
  labs(title = "Growth of Long Prison Terms Over Time",
       x = "Cohort Year",
       y = "Number of LPT Cases") +
  theme_minimal()

# Race distribution among LPTs
lpt_race_dist <- texas_lpt_combined %>%
  filter(still_incarcerated_after_2024) %>%
  group_by(race) %>%
  summarize(count = n())

# Gender distribution among LPTs
lpt_gender_dist <- texas_lpt_combined %>%
  filter(still_incarcerated_after_2024) %>%
  group_by(gender) %>%
  summarize(count = n())

# Plot race distribution
ggplot(lpt_race_dist, aes(x = reorder(race, -count), y = count, fill = race)) +
  geom_bar(stat = "identity") +
  labs(title = "Race Distribution of LPT Cases",
       x = "Race",
       y = "Count") +
  theme_minimal() +
  theme(legend.position = "none")

# Plot gender distribution
ggplot(lpt_gender_dist, aes(x = gender, y = count, fill = gender)) +
  geom_bar(stat = "identity") +
  labs(title = "Gender Distribution of LPT Cases",
       x = "Gender",
       y = "Count") +
  theme_minimal() +
  theme(legend.position = "none")

library(dplyr)
library(ggplot2)

# Aggregate count of LPT individuals by cohort year and age group at admission
lpt_by_age_at_admission <- texas_lpt_combined %>%
  filter(!is.na(Admin_Age_Group)) %>%  # Remove missing values if any
  group_by(cohort_year, Admin_Age_Group) %>%
  summarize(count = n(), .groups = "drop")

# Plot LPT growth by age at admission over time
ggplot(lpt_by_age_at_admission, aes(x = cohort_year, y = count, color = Admin_Age_Group, group = Admin_Age_Group)) +
  geom_line(size = 1) +
  geom_point(size = 2) +  # Add points for better readability
  scale_x_continuous(breaks = seq(min(lpt_by_age_at_admission$cohort_year, na.rm = TRUE), 
                                  max(lpt_by_age_at_admission$cohort_year, na.rm = TRUE), 1)) +  # Ensure yearly intervals
  labs(title = "LPT Growth by Age at Admission (2016-2024)",
       x = "Cohort Year", 
       y = "Number of People",
       color = "Age at Admission") +
  theme_minimal() +
  theme(legend.position = "right")  # Adjust legend position for readability
Warning: Using `size` aesthetic for lines was deprecated in ggplot2 3.4.0.
ℹ Please use `linewidth` instead.

library(dplyr)
library(ggplot2)

# Aggregate count of LPT individuals by cohort year and current age group
lpt_by_current_age <- texas_lpt_combined %>%
  filter(!is.na(Current_Age_Group)) %>%  # Remove missing values if any
  group_by(cohort_year, Current_Age_Group) %>%
  summarize(count = n(), .groups = "drop")

# Plot LPT growth by current age over time
ggplot(lpt_by_current_age, aes(x = cohort_year, y = count, color = Current_Age_Group, group = Current_Age_Group)) +
  geom_line(size = 1) +
  geom_point(size = 2) +  # Add points for better readability
  scale_x_continuous(breaks = seq(min(lpt_by_current_age$cohort_year, na.rm = TRUE), 
                                  max(lpt_by_current_age$cohort_year, na.rm = TRUE), 1)) +  # Ensure yearly intervals
  labs(title = "LPT Growth by Current Age (2016-2024)",
       x = "Cohort Year", 
       y = "Number of People",
       color = "Current Age Group") +
  theme_minimal() +
  theme(legend.position = "right")  # Adjust legend position for better visualization