{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Full Offense Macros","Open Offense Macros","CountyCompletenessReport Macro","Transaction Error Reports","NICS Reports","Late Dispositions","Version Info","County List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Full Offense Macros","index":0,"n_rows":38,"n_cols":26,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,2,37,5],[35,6,37,9],[35,10,37,13],[35,14,37,17],[29,2,31,5],[29,6,31,9],[29,10,31,13],[29,14,31,17],[34,2,34,4],[34,6,34,8],[34,10,34,12],[34,14,34,16],[22,14,22,16],[28,14,28,16],[28,10,28,12],[22,2,22,4],[28,2,28,4],[22,6,22,8],[28,6,28,8],[22,10,22,12],[23,2,25,5],[23,6,25,9],[23,10,25,13],[23,14,25,17]]}
["Report Used:   Full County Open and Closed Offense Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Type Saved As?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"csv"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Specific CDN/PAN/JAN Code Request:"," You can select up to 8 additionals codes"]
[null,"Are you looking for a specific ","CDN/PAN/JAN 1",null,null,null,"CDN/PAN/JAN 2",null,null,null,"CDN/PAN/JAN 3",null,null,null,"CDN/PAN/JAN 4"]
[null,"code that is not included in "]
[null,"the macro?  Enter the CDN/PAN/JAN"]
[null,"here to include it in the results"]
[]
[null,"NOTE:  This will not work with CPN/JDN codes."]
[null,null,"CDN/PAN/JAN 5",null,null,null,"CDN/PAN/JAN 6",null,null,null,"CDN/PAN/JAN 7",null,null,null,"CDN/PAN/JAN 8"]
[]
[]
[]
[]
[]
[null,null,"Offense Code 1",null,null,null,"Offense Code 2",null,null,null,"Offense Code 3",null,null,null,"Offense Code 4"]
[null,"Looking for a specific offene code?"]
[null,"You can enter up to 4 offense codes here"]
[null,"The last 4 tabs will only have these offenses"]

{"sheet":"Open Offense Macros","index":1,"n_rows":6,"n_cols":26,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Report Used:   Open Offense Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Type Saved As?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"csv"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,"Hide"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Show"]

{"sheet":"CountyCompletenessReport Macro","index":2,"n_rows":2,"n_cols":26,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Report Used:   County Completeness Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Type Saved As?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"csv"]

{"sheet":"Transaction Error Reports","index":3,"n_rows":8,"n_cols":26,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Report Used:   Prosecutor Transaction Error Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Type Saved As?"]
["Report Used:   Court Transaction Error Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"csv"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"NICS Reports","index":4,"n_rows":40,"n_cols":28,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,1,3,6],[1,27,3,27],[6,27,10,27],[2,8,2,12],[4,8,4,12],[1,23,10,23],[1,26,12,26],[12,24,32,24],[1,25,7,25],[10,25,17,25],[1,24,3,24],[20,25,26,25],[1,13,2,16]]}
[null,"Report Used:   Legacy NIE County - Transaction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MsgPartOne","MsgPartTwo","MsgZeroReport","MsgEnd","messagebox1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of days for agency to reply\nUsed in email message",null,null,null,null,null,null,null,null,null,"DPS is conducting a biennial audit of all agencies that submit NICS records to the FBI NICS Indices.  Attached is a list of records that were entered into the NICS Indices for these ORIs in the county during","Please return the supporting documentation for the listed NICS entries to me at","The ORIs below did not enter any NICS records or any Zero Reports for the year","If you have any questions, please let me know.\nThank you,\nCJIS Site Support Specialist\n","Do you want to open up an email message to send?"]
[null,null,null,null,null,null,null,null,"NICS Audit Reports"]
[null,null,null,null,null,null,null,null,null,"Year",2018,null,null,null,30,"Days"]
[null,null,null,null,null,null,null,null,"(Change to year you are auditing)",null,null,null,null,null,{"$f":"TEXT(TODAY()+O4,\"MM/DD/YYYY\")","v":"02/20/2022"},null,null,null,null,null,null,null,null,null,"MsgPartTwoDate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"by \",TEXT(TODAY()+O4,\"MM/DD/YYYY\"),\".\")","v":"by 02/20/2022."},null,null,"messagebox2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You will be given an opportunity to add additional email addresses when done"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of days for agency to reply"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MsgZeroReportRest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please verify if these agencies do not hear and do not report NICS case information.  Please send the NICS contact information for these agencies."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MsgPartTwoRest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"These documents can be sent to DPS per Texas Government Code 411.0521(b)(4).  The document(s) needed are copies of the signed court order for involuntary commitment of the person to a facility, the dismissal/delay of the criminal case due to mental incapacity reasons, or for the adult guardianship.  If your agency is reporting Misdemeanor Class C Family Violence cases, send a copy of the conviction paperwork.  The supporting court documentation that is submitted to DPS will be deleted and/or destroyed upon completion of the biennial audit."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NoORI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"There were no NICS entries done this audit year"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original - bring back up if I add Zero Report ORI's to email"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORIs listed below did not enter any NICS records or any Zero Reports for the year"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"AuditColumnNumber"]
[null,null,null,null,null,null,null,null,null,"Column",5]
[null,null,null,null,null,null,null,null,null,"Which column number is the year being audited?"]
[]
[null,null,null,null,null,null,null,null,null,"A=1"]
[null,null,null,null,null,null,null,null,null,"B=2"]
[null,null,null,null,null,null,null,null,null,"C=3"]
[null,null,null,null,null,null,null,null,null,"D=4"]
[null,null,null,null,null,null,null,null,null,"E=5"]
[null,null,null,null,null,null,null,null,null,"F=6"]
[null,null,null,null,null,null,null,null,null,"etc"]

{"sheet":"Late Dispositions","index":5,"n_rows":11,"n_cols":26,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Report Used:   County Dispositions over 37 Days Old - Adhoc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Type Saved As?"]
["Change file type if needed in Cell Z2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xlsx"]
[]
[]
[null,null,null,"Late Disposition Year to compare"]
[null,null,null,2021]
[null,null,null,"Late Disposition number of days to compare"]
[null,null,null,35]
[]
[null,null,null,"Enter Column Letter for the DOE column"]
[null,null,null,"X"]

{"sheet":"Version Info","index":6,"n_rows":127,"n_cols":31,"rows_kept":127,"cut":false,"hidden":true,"merged":[]}
["VERSION 20181101",null,null,null,null,null,null,null,null,null,"Maximum Number of Rows allowed",null,null,null,null,null,null,null,"Hide Warning Notification Counter","All Versions",null,null,null,null,null,"File Types",null,null,null,"Column Letter","Column Number"]
[null,"Beginning of a new macro that can pull the following data from a",null,null,null,null,null,null,null,null,1048575,null,null,null,null,null,null,null,"How many runs to hide for:",50,null,null,null,null,null,"csv",null,null,null,"A",1]
[null," Full Open and Closed Offense Report",null,null,null,null,null,null,null,null,"Maximum Number of Files allowed",null,null,null,null,null,null,null,"Current number of macro runs",45,null,null,null,null,null,"xls",null,null,null,"B",2]
[null,null,null,null,null,null,null,null,null,null,50,null,600,null,null,null,null,null,"Yes/No on formWARNING","Yes",null,null,null,null,null,"xlsx",null,null,null,"C",3]
[null," Felony - Arrest Only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",4]
[null," Misd - Arrest Only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",5]
[null," Felony - Pros/Court Opened",null,null,null,null,null,null,null,null,"Late Disposition Year to compare",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",6]
[null," Misd - Pros/Court Opened",null,null,null,null,null,null,null,null,{"$f":"'Late Dispositions'!D6","v":2021},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G",7]
[null," Juvenile same as above",null,null,null,null,null,null,null,null,"Late Disposition number of days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",8]
[null," Juvenile Last Dispo received (closed but not complete)",null,null,null,null,null,null,null,null,{"$f":"'Late Dispositions'!D8","v":35},null,null,null,null,null,null,null,null,null,null,null,null,null,"Report","File Type Saved As?",null,null,null,"I",9]
[null," Name Based Disposition",null,null,null,null,null,null,null,null,"Late Disposition DOE Column Number",null,null,null,null,null,null,null,null,null,null,null,null,null,"Late Dispositions",{"$f":"'Late Dispositions'!$Z$2","v":"xlsx"},null,null,null,"J",10]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Late Dispositions'!D11,'Version Info'!AD2:AE27,2)","v":24},null,null,null,null,null,null,null,null,null,null,null,null,null,"Open Offense",{"$f":"'Full Offense Macros'!$Z$2","v":"csv"},null,null,null,"K",11]
[" VERSION 20181105",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full Open/Closed",{"$f":"'Open Offense Macros'!$Z$2","v":"csv"},null,null,null,"L",12]
[null," Fixed minor bugs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completeness",{"$f":"'CountyCompletenessReport Macro'!$Z$2","v":"csv"},null,null,null,"M",13]
[null," Changed Macro Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ER3/ER4 Errors",{"$f":"'Transaction Error Reports'!$Z$2","v":"csv"},null,null,null,"N",14]
[null," Added Open Offense Report by Level and Degree using the Full Open and Closed Offense Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O",15]
[null," Added Open Offense Report Macro using the Open Offense Report (Old version)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P",16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q",17]
[" VERSION 20181114",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",18]
[null," Fixed bug that would cause wrong range to be copied.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S",19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T",20]
[" VERSION 20190124",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U",21]
[null," Added feature for counting number of rows and attempting to prevent going over max allowed.",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V",22]
[null,"Moved number of rows count and files from the VBA to this sheet to make it easier to adjust in the future.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W",23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",24]
["VERSION 20190207",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",25]
[null,"Clean up some code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Z",26]
[null,"Added NBF to Level/Degree Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AA",27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB",28]
["VERSION 20190318",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC",29]
[null,"Added Completeness Percentage Report Option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AD",30]
[null,"Added Multi-Select option for all reports",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AE",31]
[null,"Completeness Percentage only has Multi-Select option available.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AF",32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AG",33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AH",34]
["VERSION 20190329",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AI",35]
[null,"Added function to hide WARNING message on Multi-Select.  Prevents warning message for 50 runs or next time workbook is opened.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AJ",36]
[null,"Works on both Full Open and Closed and the Open Offense macros.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AK",37]
[null,"Added Transaction Error Reports",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AL",38]
[null,"Now counts number of files open and if over max allowed, cancels macro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AM",39]
[null,"Added NICS Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AN",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AO",41]
["VERSION 20190501",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AP",42]
[null,"Fixed bug with ORI Checking",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AQ",43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR",44]
["VERSION 20190613",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AS",45]
[null,"Fixed print jobs for Full Open and Closed and Full Open and Closed by Level/Degree",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AT",46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AU",47]
["VERSION 20190819",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AV",48]
[null,"Fixed bug that was allowing 605 to show on L/D report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AW",49]
[null,"Split NBD adults into 2 tabs - one for Pros and one for Court - both Full and L/D report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AX",50]
[null,"Pulled Pros actions \"E\", \"P\", \"F\" from pros open offense tab and moved to their own tabs (added 6 new tabs at end of report)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AY",51]
[null,"No changes needed to accommodate new 235 dispo code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AZ",52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BA",53]
["VERSION 20190901",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BB",54]
[null,"Added breakout for Arrest, Pros and Court on L/D macro for adults and Arrest, Court for Juv ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BC",55]
[null,"Moved some program to it's own module due to macro being to large for excel.  Code cleanup",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BD",56]
[null,"Fixed bug that was allowing the multi-select warning to show up after closing the macro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BE",57]
[null,"Added new tab that puts Prosecutor Action for Felony E, F, P onto one tab and Misdemeanor onto one tab.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BF",58]
[null,"Added new tab for 235 in Full macro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BG",59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BH",60]
["VERSION 20190912",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BI",61]
[null,"More code clean up",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BJ",62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BK",63]
["VERSION 20191031",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BL",64]
[null,"Fixed bug that was not keeping 235 on Full Open and Closed report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BM",65]
[null,"Added 233 to Full Open and Closed report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BN",66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BO",67]
["VERSION 20191206",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BP",68]
[null,"Fixed bug that was not converting \"remove\" PAF codes back to regular codes for the NBD tabs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BQ",69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BR",70]
["VERSION 20200429",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BS",71]
[null,"Added NICS Audit reports",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BT",72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BU",73]
["VERSION 20200508",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BV",74]
[null,"Added ADN 207 to the Full Open and Closed macro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW",75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BX",76]
["VERSION 20200511",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BY",77]
[null,"Added NICS Admin Audit Function",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BZ",78]
[]
["VERSION 20200513"]
[null,"Added variable to select column number for NICS Admin Function"]
[null,"Changed the way the auditors will get the information compiled"]
[null,"Now they will be able to create the final audit report easier."]
[]
["VERSION 20200522"]
[null,"Set Column Width for Column J (Notes) on the COUNTY county.xlsx file"]
[null,"Added macro to create workbook that the rep will email to the county for their NICS Audit."]
[null,"Added ability to also include Zero Report to \"COUNTY County.xlsx\" file when adding ORI csv files with a 3rd open box (Included ability to select that there is no ZERO REPORT)"]
[null,"If no zero report file, adds \"There are no Zero Reports for this audit year\" to cell A1"]
[null,"Includes Zero Report tab in spreadsheet being emailed to county"]
[]
["VERSION 20200707"]
[null,"Fixed bug found when cause number does not contain any letters and is over a certain length."]
[null,"Center cause number column"]
[null,"Fixed bug that caused save error in Audit report"]
[null,"Added creation of email with email addresses and body of email prefilled in for the rep."]
[null,"Added email attachment when emailing the NICS Audit"]
[]
["VERSION 20200901"]
[null,"Changing tab name upon opening csv file because new default file name is too long"]
[]
["VERSION 2020909"]
[null,"Clean up coding"]
[null,"Add Late Disposition Reporting option"]
[]
["VERSION 20201106"]
[null,"Fixed monthly late disposition reporting to select all files in folder instead of one at a time."]
[null,"Made number of days a variable on a sheet so that when timeframe changes I don't need to rewrite macro"]
[null,"Also fixed column issue for new website.  They moved the DOE column around"]
[]
["VERSION 20201202"]
[null,"Changed \"Yes\" to \"Possible\" for Late Disposition affecting grants"]
[]
["VERSION 20210329"]
[null,"Added tabs for 312, 400/393, 400/394, 330/403 to Full Offense Report from request by Jeff"]
[]
["VERSION 20210401"]
[null,"Added option to request specific codes by entering the CDN/PAN/JAN you would like in the boxes below the button"]
[null,"Now has the ability to add an additional 8 CDN/PAN/JAN codes for a total of up to 16 new tabs - one Misd and one Felony per CDN/PAN/JAN code entered"]
[null,"Added option to request up to 4 specific offense codes"]
[]
["VERSION 20210416"]
[null,"Fixed bug when offense code empty in first box"]
[null,"Made improvements to the Late Dispositions Macro"]
[null,"added a timer to determine how long it takes for macro to run"]
[null,"Fixed bug where I accidentally changed a sub name."]

{"sheet":"County List","index":7,"n_rows":549,"n_cols":3,"rows_kept":549,"cut":false,"hidden":true,"merged":[]}
["ORI","County","Region"]
["001","ANDERSON","Region 1"]
["002","ANDREWS","Region 5"]
["003","ANGELINA","Region 1"]
["004","ARANSAS","Region 4"]
["005","ARCHER","Region 8"]
["006","ARMSTRONG","Region 9"]
["007","ATASCOSA","Region 4"]
["008","AUSTIN","Region 2"]
["009","BAILEY","Region 9"]
["010","BANDERA","Region 3"]
["011","BASTROP","Region 3"]
["012","BAYLOR","Region 6"]
["013","BEE","Region 4"]
["014","BELL","Region 7"]
["015","BEXAR","Region 3"]
["016","BLANCO","Region 3"]
["017","BORDEN","Region 6"]
["018","BOSQUE","Region 7"]
["019","BOWIE","Region 1"]
["020","BRAZORIA","Region 2"]
["021","BRAZOS","Region 2"]
["022","BREWSTER","Region 5"]
["023","BRISCOE","Region 9"]
["024","BROOKS","Region 4"]
["025","BROWN","Region 7"]
["026","BURLESON","Region 2"]
["027","BURNET","Region 3"]
["028","CALDWELL","Region 3"]
["029","CALHOUN","Region 2"]
["030","CALLAHAN","Region 7"]
["031","CAMERON","Region 4"]
["032","CAMP","Region 1"]
["033","CARSON","Region 9"]
["034","CASS","Region 1"]
["035","CASTRO","Region 9"]
["036","CHAMBERS","Region 2"]
["037","CHEROKEE","Region 1"]
["038","CHILDRESS","Region 9"]
["039","CLAY","Region 8"]
["040","COCHRAN","Region 9"]
["041","COKE","Region 6"]
["042","COLEMAN","Region 7"]
["043","COLLIN","Region 8"]
["044","COLLINGSWORTH","Region 9"]
["045","COLORADO","Region 2"]
["046","COMAL","Region 3"]
["047","COMANCHE","Region 7"]
["048","CONCHO","Region 6"]
["049","COOKE","Region 8"]
["050","CORYELL","Region 7"]
["051","COTTLE","Region 6"]
["052","CRANE","Region 5"]
["053","CROCKETT","Region 5"]
["054","CROSBY","Region 6"]
["055","CULBERSON","Region 5"]
["056","DALLAM","Region 9"]
["057","DALLAS","Region 8"]
["058","DAWSON","Region 6"]
["059","DEAF SMITH","Region 9"]
["060","DELTA","Region 1"]
["061","DENTON","Region 8"]
["062","DEWITT","Region 2"]
["063","DICKENS","Region 9"]
["064","DIMMIT","Region 3"]
["065","DONLEY","Region 9"]
["066","DUVAL","Region 4"]
["067","EASTLAND","Region 7"]
["068","ECTOR","Region 5"]
["069","EDWARDS","Region 3"]
["070","ELLIS","Region 8"]
["071","EL PASO","Region 5"]
["072","ERATH","Region 7"]
["073","FALLS","Region 7"]
["074","FANNIN","Region 1"]
["075","FAYETTE","Region 2"]
["076","FISHER","Region 6"]
["077","FLOYD","Region 9"]
["078","FOARD","Region 6"]
["079","FT BEND","Region 2"]
["080","FRANKLIN","Region 1"]
["081","FREESTONE","Region 7"]
["082","FRIO","Region 4"]
["083","GAINES","Region 6"]
["084","GALVESTON","Region 2"]
["085","GARZA","Region 6"]
["086","GILLESPIE","Region 3"]
["087","GLASSCOCK","Region 6"]
["088","GOLIAD","Region 2"]
["089","GONZALES","Region 2"]
["090","GRAY","Region 9"]
["091","GRAYSON","Region 8"]
["092","GREGG","Region 1"]
["093","GRIMES","Region 2"]
["094","GUADALUPE","Region 2"]
["095","HALE","Region 9"]
["096","HALL","Region 9"]
["097","HAMILTON","Region 7"]
["098","HANSFORD","Region 9"]
["099","HARDEMAN","Region 6"]
["100","HARDIN","Region 2"]
["101","HARRIS","Region 2"]
["102","HARRISON","Region 1"]
["103","HARTLEY","Region 9"]
["104","HASKELL","Region 6"]
["105","HAYS","Region 3"]
["106","HEMPHILL","Region 9"]
["107","HENDERSON","Region 1"]
["108","HIDALGO","Region 4"]
["109","HILL","Region 7"]
["110","HOCKLEY","Region 9"]
["111","HOOD","Region 8"]
["112","HOPKINS","Region 1"]
["113","HOUSTON","Region 1"]
["114","HOWARD","Region 6"]
["115","HUDSPETH","Region 5"]
["116","HUNT","Region 1"]
["117","HUTCHINSON","Region 9"]
["118","IRION","Region 6"]
["119","JACK","Region 8"]
["120","JACKSON","Region 2"]
["121","JASPER","Region 1"]
["122","JEFF DAVIS","Region 5"]
["123","JEFFERSON","Region 2"]
["124","JIM HOGG","Region 4"]
["125","JIM WELLS","Region 4"]
["126","JOHNSON","Region 8"]
["127","JONES","Region 6"]
["128","KARNES","Region 4"]
["129","KAUFMAN","Region 8"]
["130","KENDALL","Region 3"]
["131","KENEDY","Region 4"]
["132","KENT","Region 6"]
["133","KERR","Region 3"]
["134","KIMBLE","Region 3"]
["135","KING","Region 6"]
["136","KINNEY","Region 5"]
["137","KLEBERG","Region 4"]
["138","KNOX","Region 6"]
["139","LAMAR","Region 1"]
["140","LAMB","Region 9"]
["141","LAMPASAS","Region 7"]
["142","LASALLE","Region 4"]
["143","LAVACA","Region 2"]
["144","LEE","Region 3"]
["145","LEON","Region 2"]
["146","LIBERTY","Region 2"]
["147","LIMESTONE","Region 7"]
["148","LIPSCOMB","Region 9"]
["149","LIVE OAK","Region 4"]
["150","LLANO","Region 3"]
["151","LOVING","Region 5"]
["152","LUBBOCK","Region 6"]
["153","LYNN","Region 6"]
["154","MCCULLOCH","Region 3"]
["155","MCLENNAN","Region 7"]
["156","MCMULLEN","Region 4"]
["157","MADISON","Region 2"]
["158","MARION","Region 1"]
["159","MARTIN","Region 6"]
["160","MASON","Region 3"]
["161","MATAGORDA","Region 2"]
["162","MAVERICK","Region 3"]
["163","MEDINA","Region 3"]
["164","MENARD","Region 3"]
["165","MIDLAND","Region 5"]
["166","MILAM","Region 7"]
["167","MILLS","Region 7"]
["168","MITCHELL","Region 6"]
["169","MONTAGUE","Region 8"]
["170","MONTGOMERY","Region 2"]
["171","MOORE","Region 9"]
["172","MORRIS","Region 1"]
["173","MOTLEY","Region 9"]
["174","NACOGDOCHES","Region 1"]
["175","NAVARRO","Region 7"]
["176","NEWTON","Region 1"]
["177","NOLAN","Region 6"]
["178","NUECES","Region 4"]
["179","OCHILTREE","Region 9"]
["180","OLDHAM","Region 9"]
["181","ORANGE","Region 2"]
["182","PALO PINTO","Region 7"]
["183","PANOLA","Region 1"]
["184","PARKER","Region 8"]
["185","PARMER","Region 9"]
["186","PECOS","Region 5"]
["187","POLK","Region 2"]
["188","POTTER","Region 9"]
["189","PRESIDIO","Region 5"]
["190","RAINS","Region 1"]
["191","RANDALL","Region 9"]
["192","REAGAN","Region 5"]
["193","REAL","Region 3"]
["194","RED RIVER","Region 1"]
["195","REEVES","Region 5"]
["196","REFUGIO","Region 2"]
["197","ROBERTS","Region 9"]
["198","ROBERTSON","Region 7"]
["199","ROCKWALL","Region 8"]
["200","RUNNELS","Region 6"]
["201","RUSK","Region 1"]
["202","SABINE","Region 1"]
["203","SAN AUGUSTINE","Region 1"]
["204","SAN JACINTO","Region 2"]
["205","SAN PATRICIO","Region 4"]
["206","SAN SABA","Region 3"]
["207","SCHLEICHER","Region 6"]
["208","SCURRY","Region 6"]
["209","SHACKELFORD","Region 6"]
["210","SHELBY","Region 1"]
["211","SHERMAN","Region 9"]
["212","SMITH","Region 1"]
["213","SOMERVELL","Region 8"]
["214","STARR","Region 4"]
["215","STEPHENS","Region 7"]
["216","STERLING","Region 6"]
["217","STONEWALL","Region 6"]
["218","SUTTON","Region 5"]
["219","SWISHER","Region 9"]
["220","TARRANT","Region 8"]
["221","TAYLOR","Region 7"]
["222","TERRELL","Region 5"]
["223","TERRY","Region 6"]
["224","THROCKMORTON","Region 6"]
["225","TITUS","Region 1"]
["226","TOM GREEN","Region 6"]
["227","TRAVIS","Region 3"]
["228","TRINITY","Region 2"]
["229","TYLER","Region 2"]
["230","UPSHUR","Region 1"]
["231","UPTON","Region 5"]
["232","UVALDE","Region 3"]
["233","VAL VERDE","Region 5"]
["234","VAN ZANDT","Region 1"]
["235","VICTORIA","Region 2"]
["236","WALKER","Region 2"]
["237","WALLER","Region 2"]
["238","WARD","Region 5"]
["239","WASHINGTON","Region 2"]
["240","WEBB","Region 4"]
["241","WHARTON","Region 2"]
["242","WHEELER","Region 9"]
["243","WICHITA","Region 6"]
["244","WILBARGER","Region 6"]
["245","WILLACY","Region 4"]
["246","WILLIAMSON","Region 3"]
["247","WILSON","Region 4"]
["248","WINKLER","Region 5"]
["249","WISE","Region 8"]
["250","WOOD","Region 1"]
["251","YOAKUM","Region 6"]
["252","YOUNG","Region 7"]
["253","ZAPATA","Region 4"]
["254","ZAVALA","Region 3"]
["101","HARRIS","TX923783Z"]
["092","GREGG","TX923786Z"]
["101","HARRIS","TX923784Z"]
["152","LUBBOCK","TX923782Z"]
["015","BEXAR","TX923785Z"]
["015","BEXAR","TX923787Z"]
["125","JIM WELLS","TX923791Z"]
["021","BRAZOS","TX923790Z"]
["227","TRAVIS","TX923789Z"]
["111","HOOD","TX923788Z"]
["079","FORT BEND","TX923792Z"]
["155","MCLENNAN","TX923793Z"]
["139","LAMAR","TX923020Z"]
["227","TRAVIS","TX923333Z"]
["227","TRAVIS","TX923334Z"]
["227","TRAVIS","TX923336Z"]
["081","FREESTONE","TX923795Z"]
["019","BOWIE","TX923794Z"]
["015","BEXAR","TX923799Z"]
["227","TRAVIS","TX923796Z"]
["015","BEXAR","TX923797Z"]
["101","HARRIS","TX923798Z"]
["101","HARRIS","TX923800Z"]
["227","TRAVIS","TX923435Z"]
["227","TRAVIS","TX923434Z"]
["227","TRAVIS","TX923439Z"]
["227","TRAVIS","TX923438Z"]
["108","HIDALGO","TX923437Z"]
["227","TRAVIS","TX923440Z"]
["227","TRAVIS","TX923441Z"]
["227","TRAVIS","TX923467Z"]
["227","TRAVIS","TX923466Z"]
["015","BEXAR","TX923465Z"]
["108","HIDALGO","TX923446Z"]
["178","NUECES","TX923447Z"]
["235","VICTORIA","TX923448Z"]
["101","HARRIS","TX923449Z"]
["123","JEFFERSON","TX923450Z"]
["236","WALKER","TX923451Z"]
["092","GREGG","TX923452Z"]
["225","TITUS","TX923453Z"]
["243","WICHITA","TX923454Z"]
["057","DALLAS","TX923455Z"]
["220","TARRANT","TX923456Z"]
["155","MCLENNAN","TX923457Z"]
["227","TRAVIS","TX923458Z"]
["221","TAYLOR","TX923459Z"]
["188","POTTER","TX923461Z"]
["152","LUBBOCK","TX923462Z"]
["165","MIDLAND","TX923463Z"]
["071","EL PASO","TX923464Z"]
["226","TOM GREEN","TX923460Z"]
["227","TRAVIS","TX923479Z"]
["101","HARRIS","TX923480Z"]
["227","TRAVIS","TX923477Z"]
["227","TRAVIS","TX923478Z"]
["019","BOWIE","TX923481Z"]
["227","TRAVIS","TX923490Z"]
["227","TRAVIS","TX923483Z"]
["061","DENTON","TX923482Z"]
["227","TRAVIS","TX923486Z"]
["015","BEXAR","TX923484Z"]
["227","TRAVIS","TX923469Z"]
["227","TRAVIS","TX923488Z"]
["057","DALLAS","TX923492Z"]
["227","TRAVIS","TX923489Z"]
["227","TRAVIS","TX923491Z"]
["227","TRAVIS","TX923493Z"]
["227","TRAVIS","TX923495Z"]
["057","DALLAS","TX923496Z"]
["227","TRAVIS","TX923503Z"]
["227","TRAVIS","TX923499Z"]
["101","HARRIS","TX923500Z"]
["057","DALLAS","TX923468Z"]
["227","TRAVIS","TX923536Z"]
["221","TAYLOR","TX923539Z"]
["221","TAYLOR","TX923540Z"]
["221","TAYLOR","TX923541Z"]
["015","BEXAR","TX923542Z"]
["015","BEXAR","TX923543Z"]
["079","FORT BEND","TX923544Z"]
["079","FORT BEND","TX923545Z"]
["079","FORT BEND","TX923546Z"]
["079","FORT BEND","TX923547Z"]
["043","COLLIN","TX923548Z"]
["191","RANDALL","TX923551Z"]
["227","TRAVIS","TX923552Z"]
["057","DALLAS","TX923554Z"]
["057","DALLAS","TX923555Z"]
["057","DALLAS","TX923556Z"]
["114","HOWARD","TX923508Z"]
["031","CAMERON","TX923538Z"]
["079","FORT BEND","TX923494Z"]
["246","WILLIAMSON","TX923561Z"]
["227","TRAVIS","TX923558Z"]
["227","TRAVIS","TX923567Z"]
["188","POTTER","TX923560Z"]
["084","GALVESTON","TX923571Z"]
["101","HARRIS","TX923573Z"]
["209","SHACKELFORD","TX923572Z"]
["071","EL PASO","TX923574Z"]
["071","EL PASO","TX923575Z"]
["227","TRAVIS","TX923576Z"]
["101","HARRIS","TX923569Z"]
["227","TRAVIS","TX923510Z"]
["021","BRAZOS","TX923577Z"]
["026","BURLESON","TX923581Z"]
["227","TRAVIS","TX923580Z"]
["178","NUECES","TX923579Z"]
["074","FANNIN","TX923584Z"]
["227","TRAVIS","TX923583Z"]
["123","JEFFERSON","TX923582Z"]
["071","EL PASO","TX923578Z"]
["152","LUBBOCK","TX923588Z"]
["227","TRAVIS","TX923570Z"]
["091","GRAYSON","TX923589Z"]
["084","GALVESTON","TX923590Z"]
["227","TRAVIS","TX923591Z"]
["101","HARRIS","TX923592Z"]
["108","HIDALGO","TX923600Z"]
["227","TRAVIS","TX923504Z"]
["061","DENTON","TX923587Z"]
["227","TRAVIS","TX923553Z"]
["123","JEFFERSON","TX923602Z"]
["227","TRAVIS","TX923604Z"]
["227","TRAVIS","TX923606Z"]
["227","TRAVIS","TX923605Z"]
["227","TRAVIS","TX923603Z"]
["227","TRAVIS","TX923607Z"]
["101","HARRIS","TX923608Z"]
["101","HARRIS","TX923609Z"]
["227","TRAVIS","TX923610Z"]
["227","TRAVIS","TX923611Z"]
["246","WILLIAMSON","TX923612Z"]
["227","TRAVIS","TX923613Z"]
["080","FRANKLIN","TX923614Z"]
["220","TARRANT","TX923618Z"]
["227","TRAVIS","TX923621Z"]
["072","ERATH","TX923363Z"]
["101","HARRIS","TX923630Z"]
["177","NOLAN","TX923631Z"]
["057","DALLAS","TX923633Z"]
["105","HAYS","TX923632Z"]
["076","FISHER","TX923634Z"]
["227","TRAVIS","TX923625Z"]
["084","GALVESTON","TX923626Z"]
["003","ANGELINA","TX923636Z"]
["240","WEBB","TX923637Z"]
["227","TRAVIS","TX923635Z"]
["184","PARKER","TX923640Z"]
["227","TRAVIS","TX923638Z"]
["113","HOUSTON","TX923642Z"]
["064","DIMMIT","TX923639Z"]
["139","LAMAR","TX923643Z"]
["108","HIDALGO","TX923645Z"]
["108","HIDALGO","TX923644Z"]
["227","TRAVIS","TX923641Z"]
["123","JEFFERSON","TX923652Z"]
["015","BEXAR","TX923653Z"]
["015","BEXAR","TX923646Z"]
["057","DALLAS","TX923647Z"]
["101","HARRIS","TX923648Z"]
["057","DALLAS","TX923649Z"]
["199","ROCKWALL","TX923650Z"]
["227","TRAVIS","TX923651Z"]
["227","TRAVIS","TX923654Z"]
["057","DALLAS","TX923660Z"]
["227","TRAVIS","TX923658Z"]
["097","HAMILTON","TX923662Z"]
["181","ORANGE","TX923659Z"]
["227","TRAVIS","TX923661Z"]
["178","NUECES","TX923657Z"]
["227","TRAVIS","TX923655Z"]
["101","HARRIS","TX923663Z"]
["227","TRAVIS","TX923664Z"]
["227","TRAVIS","TX923665Z"]
["043","COLLIN","TX923670Z"]
["057","DALLAS","TX923669Z"]
["057","DALLAS","TX923666Z"]
["227","TRAVIS","TX923667Z"]
["227","TRAVIS","TX923668Z"]
["227","TRAVIS","TX923672Z"]
["071","EL PASO","TX923673Z"]
["015","BEXAR","TX923674Z"]
["227","TRAVIS","TX923675Z"]
["068","ECTOR","TX923677Z"]
["246","WILLIAMSON","TX923671Z"]
["015","BEXAR","TX923678Z"]
["227","TRAVIS","TX923679Z"]
["220","TARRANT","TX923680Z"]
["227","TRAVIS","TX923332Z"]
["227","TRAVIS","TX923681Z"]
["227","TRAVIS","TX923683Z"]
["246","WILLIAMSON","TX923684Z"]
["001","ANDERSON","TX923685Z"]
["101","HARRIS","TX923682Z"]
["108","HIDALGO","TX923686Z"]
["101","HARRIS","TX923688Z"]
["057","DALLAS","TX923689Z"]
["105","HAYS","TX923690Z"]
["220","TARRANT","TX923691Z"]
["227","TRAVIS","TX923692Z"]
["011","BASTROP","TX923693Z"]
["094","GUADALUPE","TX923694Z"]
["239","WASHINGTON","TX923695Z"]
["057","DALLAS","TX923376Z"]
["061","DENTON","TX923282Z"]
["015","BEXAR","TX923696Z"]
["014","BELL","TX923697Z"]
["061","DENTON","TX923698Z"]
["247","WILSON","TX923699Z"]
["001","ANDERSON","TX923701Z"]
["227","TRAVIS","TX923702Z"]
["227","TRAVIS","TX923703Z"]
["236","WALKER","TX923708Z"]
["057","DALLAS","TX923709Z"]
["101","HARRIS","TX923707Z"]
["015","BEXAR","TX923706Z"]
["126","JOHNSON","TX923705Z"]
["043","COLLIN","TX923704Z"]
["084","GALVESTON","TX923712Z"]
["220","TARRANT","TX923711Z"]
["015","BEXAR","TX923713Z"]
["227","TRAVIS","TX923714Z"]
["045","COLORADO","TX923710Z"]
["101","HARRIS","TX923716Z"]
["101","HARRIS","TX923717Z"]
["227","TRAVIS","TX923718Z"]
["227","TRAVIS","TX923700Z"]
["227","TRAVIS","TX923719Z"]
["101","HARRIS","TX923720Z"]
["181","ORANGE","TX923721Z"]
["227","TRAVIS","TX923723Z"]
["101","HARRIS","TX923724Z"]
["181","ORANGE","TX923722Z"]
["057","DALLAS","TX923725Z"]
["227","TRAVIS","TX923726Z"]
["220","TARRANT","TX923735Z"]
["071","EL PASO","TX923734Z"]
["227","TRAVIS","TX923733Z"]
["101","HARRIS","TX923732Z"]
["212","SMITH","TX923731Z"]
["057","DALLAS","TX923730Z"]
["108","HIDALGO","TX923729Z"]
["015","BEXAR","TX923728Z"]
["152","LUBBOCK","TX923727Z"]
["170","MONTGOMERY","TX923737Z"]
["220","TARRANT","TX923738Z"]
["227","TRAVIS","TX923739Z"]
["101","HARRIS","TX923428Z"]
["227","TRAVIS","TX923740Z"]
["214","STARR","TX923746Z"]
["155","MCLENNAN","TX923741Z"]
["155","MCLENNAN","TX923744Z"]
["246","WILLIAMSON","TX923743Z"]
["015","BEXAR","TX923742Z"]
["031","CAMERON","TX923747Z"]
["170","MONTGOMERY","TX923736Z"]
["227","TRAVIS","TX923749Z"]
["198","ROBERTSON","TX923750Z"]
["220","TARRANT","TX923751Z"]
["227","TRAVIS","TX923628Z"]
["226","TOM GREEN","TX923752Z"]
["227","TRAVIS","TX923748Z"]
["227","TRAVIS","TX923753Z"]
["101","HARRIS","TX923757Z"]
["101","HARRIS","TX923756Z"]
["235","VICTORIA","TX923754Z"]
["227","TRAVIS","TX923755Z"]
["061","DENTON","TX923758Z"]
["084","GALVESTON","TX923763Z"]
["015","BEXAR","TX923760Z"]
["227","TRAVIS","TX923761Z"]
["070","ELLIS","TX923762Z"]
["227","TRAVIS","TX923764Z"]
["227","TRAVIS","TX923759Z"]
["220","TARRANT","TX923765Z"]
["227","TRAVIS","TX923767Z"]
["015","BEXAR","TX923768Z"]
["057","DALLAS","TX923772Z"]
["227","TRAVIS","TX923770Z"]
["152","LUBBOCK","TX923769Z"]
["101","HARRIS","TX923771Z"]
["015","BEXAR","TX923766Z"]
["227","TRAVIS","TX923775Z"]
["101","HARRIS","TX923773Z"]
["101","HARRIS","TX923774Z"]
["227","TRAVIS","TX923776Z"]
["227","TRAVIS","TX923777Z"]
["227","TRAVIS","TX923778Z"]
["101","HARRIS","TX923779Z"]
["015","BEXAR","TX923507Z"]
["014","BELL","TX923780Z"]
["101","HARRIS","TX923781Z"]