{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sheet2","Sheet3"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet2","index":0,"n_rows":58,"n_cols":2,"rows_kept":58,"merged":[[2,0,2,1],[11,0,11,1],[16,0,16,1],[18,0,18,1],[27,0,27,1],[29,0,29,1],[31,0,31,1],[53,0,53,1],[55,0,55,1],[57,0,57,1]]}
["August 3, 2016"]
[]
["Legend for codes and headings in raw parking data files"]
[]
[]
["Record cleared reason (column Z)"]
["DP","Payment at the MTO or at a Collections Agency"]
["PD","Paid"]
["SP","Suspended"]
["VO","Void"]
["XX","Open"]
[]
[]
["Record status (column X)"]
["CL","Closed"]
["OP","Open"]
[]
[]
["Review code will contain a value if the client attended one of the First Attendance Facilities and initiated a review to resolve the matter."]
[]
["Review Code (column AB)"]
["ROD","Review outcome denied"]
["ROU","Review outcome upheld"]
["RR","Review requested"]
["RRA","Review request accepted"]
["RRD","Review request denied"]
["BLANKS","No review"]
[]
[]
["Trial code will contain a value if for example the ticket was at a stage where a legislated notice was created and sent or it may contain a code representing the trial stage it was at when the data snapshot was taken."]
[]
["Trial code (column AC)"]
["AOD","Appeal outcome denied"]
["AON","Appeal outcome withdrawn"]
["AOS","Appeal outcome suspended"]
["CFR","Conviction of failure to respond"]
["CRC","Certificate requesting conviction"]
["CRPD","Certificate requesting plate denial"]
["JRA","Adjournment request accepted"]
["NFDD","Notice of fine and due date"]
["NIC","Notice of impending conviction"]
["NOT","Notice of trial"]
["ORG","Reopen outcome guilty / impose set fine"]
["ORT","Reopen outcome conviction struck / new trial"]
["SOC","Strike out conviction"]
["SOCR","Request to strike out conviction"]
["TOA","Trial outcome adjourned"]
["TOD","Trial outcome denied"]
["TOU","Trial outcome convicted"]
["TR","Trial request"]
["TRA","Trial request accepted"]
["TS","Trial scheduled"]
["BLANKS","Dealt with prior to notices being sent"]
[]
[]
["If the record cleared reason is void (VO column Z) then the total credits (column T) is the value of the ticket at the time of the void. "]
[]
["If the record cleared reason is DP (paid at MTO/collections) then the total credits (column T) minus the totalnoncashcredit (column R) is the total fine and fees paid to the City."]

{"sheet":"Sheet3","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}