{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Data","About","Deleted File#'s","Lists"],"not_rendered":{"images":6,"macros":1,"defined_names":42},"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":22,"n_cols":44,"rows_kept":22,"merged":[[9,2,9,16],[9,18,9,24],[9,25,9,36],[9,37,9,41]]}
[null,null,"CAUTION: This record contains information about Young Persons which is subject to the Youth Criminal Justice Act. "]
[null,null,"Information about Young Persons as defined in the Youth Criminal Justice Act is subject to publication,\n"]
[null,null,"use and access restrictions as set out in the Act to protect the privacy of the Young Person.",{"$nulls":6},"N"]
[null,null,"Reporting Period","2018","Mar"]
[null,null,"Agency","Lanark County Community Justice Program Inc.",{"$nulls":5},""]
[null,null,"Court","28 Perth",{"$nulls":5},"2018-03-14"]
[]
[]
[]
[null,null,"Personal File Information",{"$nulls":15},"Sanctions",{"$nulls":6},"Other File Information",{"$nulls":11},"Identity-Based Information"]
[null,null,"File Number","Young Person Surname","Young Person Name","Date of Birth (mm/dd/yyyy)","Age at Time of Offence","Class I Offences",{"$f":"\"Number of Class 1 Offences= \"&SUM(I12:I1496)","v":"Number of Class 1 Offences= 3"},"Class II Offences",{"$f":"\"Number of Class 2 Offences= \"&SUM(K12:K1496)","v":"Number of Class 2 Offences= 10"}," EJS/EJM ","Date Received by YJC (mm/dd/yy)","Date of Arrest-EJM (mm/dd/yy)","Police Service","First Appearance Date-EJS (mm/dd/yy)","Date Accepted into Program (mm/dd/yy)","Conference Date (mm/dd/yy)","CSO (in hours)","Charitable Donation Amount ($)","Restitution Amount ($)","Apology","Other Sanctions","Program Hours","Date Sanctions Completed (mm/dd/yy)","Next Court Date (mm/dd/yy)","Date Charge Withdrawn/Stayed\n(mm/dd/yy)","Date File Closed (mm/dd/yy)","Case Status","Court Appearances-referral to W/S-EJS",{"$f":"\"Number of Direct Victims= \" &SUM(AE12:AE1496)","v":"Number of Direct Victims= 10"},"Victim Participation Type",{"$f":"\"Number of Direct Victims that Participated=\" & SUM(AG12:AG1496)","v":"Number of Direct Victims that Participated=7"},"Parental/Guardian Participants","Other Conference Participants",{"$f":"\"Number of Participants=\" & SUM(AJ12:AJ1496)","v":"Number of Participants=26"},"Case Comments","Racial Group","Indigenous Status","Gender Identity","Ethnicity","Postal Code","Reporting Period","Marked For Reporting"]
[null,null,"28-020-2017","Pike","Samual","1999-10-30",17,"",0,"Possesion Controlled Substance;\nPossession Over",2,"EJM - Pre-Charge Cases (Police Referral)","2017-05-27","2017-05-27","OPP",null,"2017-06-06","2017-08-11",{"$nulls":3},"Verbal","Other;\nSubstance Use Program",null,"2018-03-01",null,null,"2018-03-03","Successful",null,1,"Via Appointed Designate;",1,"Father;\nMother;\nOther","Social Services Worker;",4,null,"White",null,"Male","Canadian","K0A","2018-Mar","Y"]
[null,null,"28-025-2017","Willows","Kendra","2002-02-14",15,"Mischief Under $5,000;",1,"",0,"EJS - Post-Charge Cases (Crown Referral)","2017-10-11","2017-08-15","OPP","2017-10-11","2017-10-11",null,15,null,null,"","Other Counselling;",null,null,"2018-03-28",null,null,"Ongoing / Active",2,1,"Verbal;",1,"Guardian;","Social Services Worker;",2,{"$nulls":3},"Female","Canadian","K7H","2018-Mar","Y"]
[null,null,"28-027-2017","Legault-Caston","Kimberly","2001-07-18",16,"Accommodation/Transportation Fraud;",1,"",0,"EJS - Post-Charge Cases (Crown Referral)","2017-12-06","2017-11-19","OPP","2018-01-17","2018-01-17","2018-01-17",null,null,{"v":18,"d":"$18.00"},"","",null,"2018-01-31","2018-01-31","2018-01-31","2018-01-31","Successful",2,1,"Verbal;",1,"Guardian;","Social Services Worker;",2,{"$nulls":3},"Female","Canadian",null,"2018-Mar","Y"]
[null,null,"28-028-2017","Beauchamp","Ariel","2003-08-21",14,"Accommodation/Transportation Fraud;",1,"",0,"EJS - Post-Charge Cases (Crown Referral)","2017-12-06","2017-11-19","OPP","2018-01-17","2018-01-17","2018-01-17",null,null,{"v":18,"d":"$18.00"},"","",null,"2018-01-31","2018-01-31","2018-01-31","2018-01-31","Successful",2,1,"Verbal;",1,"Guardian;","Social Services Worker;",2,{"$nulls":3},"Female","Canadian",null,"2018-Jan"]
[null,null,"28-001-2018","White","Nicholas","2003-10-21",16,"",0,"Criminal Harrassment;\nUttering Threats",2,"EJS - Post-Charge Cases (Crown Referral)","2018-01-17","2017-11-02","Municipal/Regional","2018-01-17","2018-01-24","2018-04-20",{"$nulls":3},"","Other Counselling;",3,null,"2018-04-06",null,null,"Ongoing / Active",2,1,"In Person;\nVerbal",2,"Father;\nMother","Teacher/Principal;",3,{"$nulls":3},"Male",null,"K7A","2018-Mar","Y"]
[null,null,"28-002-2018","Corbett","Riley","2018-04-17",16,"",0,"Other (please specify in Case Comments section);",1,"EJS - Post-Charge Cases (Crown Referral)","2018-01-17",null,null,"2018-01-17","2018-01-31","2018-04-20",{"$nulls":3},"","Other Counselling;",3,{"$nulls":4},"Ongoing / Active",2,1,"Did Not Participate;",0,"Father;","Teacher/Principal;",2,{"$nulls":3},"Male",null,"K0G","2018-Mar","Y"]
[null,null,"28-003-2018","Dougherty-O'Neil","Taylor","2018-02-14",16,"",0,"Other (please specify in Case Comments section);",1,"EJS - Post-Charge Cases (Crown Referral)","2018-01-17",null,null,"2018-01-17",null,"2018-03-20",{"$nulls":3},"","Other Counselling;",3,{"$nulls":4},"Ongoing / Active",2,1,"Did Not Participate;",0,"Mother;","Teacher/Principal;",2,"fear of personal injury",null,null,"Male",null,null,"2018-Mar","Y"]
[null,null,"28-004-2018","Patterson","Bradley","2018-02-14",16,"",0,"Other (please specify in Case Comments section);",1,"EJS - Post-Charge Cases (Crown Referral)","2018-01-31",null,null,"2018-01-31","2018-02-01","2018-03-20",{"$nulls":3},"","Other Counselling;",3,{"$nulls":4},"Ongoing / Active",1,1,"Did Not Participate;",0,"Father;","Teacher/Principal;",2,{"$nulls":3},"Male",null,null,"2018-Mar","Y"]
[null,null,"28-005-2018","Novosad","Marshall","2004-09-17",13,"",0,"Assault;",1,"EJM - Pre-Charge Cases (Police Referral)","2018-02-08","2018-01-29","OPP",null,"2018-02-09","2018-03-13",{"$nulls":3},"Written","Other Counselling;",null,"2018-03-14",{"$nulls":3},"Successful",null,1,"In Person;",1,"Father;\nGrandparent;\nMother;\nOther","Social Services Worker;",5,{"$nulls":3},"Male",null,null,"2018-Mar","Y"]
[null,null,"28-006-2018","Boyle","Connor","2018-03-14",15,"",0,"Uttering Threats;",1,"EJS - Post-Charge Cases (Crown Referral)","2018-03-06","2017-03-14",null,"2018-03-14","2018-03-07","2018-03-20",{"$nulls":3},"","Other Counselling;",3,null,"2018-04-25",null,null,"Ongoing / Active",2,1,"Did Not Participate;",0,"Father;","Teacher/Principal;",2,{"$nulls":3},"Male",null,"K7A","2018-Mar","Y"]
[null,null,"28-007-2018","Issigaitok","Stacey","2018-04-03",15,"",0,"Fail to Comply;",1,"EJS - Post-Charge Cases (Crown Referral)","2018-04-04",null,"OPP","2018-03-29",{"$nulls":5},"","",null,null,"2018-04-25",null,null,"Ongoing / Active",1,null,null,0,null,null,0,null,null,"Inuit","Female",null,"K2B","2018-Mar","Y"]

{"sheet":"About","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"hidden":true,"merged":[[4,1,4,7],[5,1,5,7],[6,1,6,7],[9,1,9,12],[10,1,10,12],[11,1,11,12],[13,1,13,12],[14,1,14,12],[15,1,15,12],[16,1,16,12],[18,1,18,12]]}
[]
[]
[]
[]
[null,"Ministry of the Attorney General"]
[null,"Criminal Law Division"]
[null,"Strategic Operations and Management Centre"]
[]
[]
[null,"Youth Justice Committee (YJC) Application"]
[null,"Agency Data Management Utility (ADMU) "]
[null,"(version v1.0)"]
[]
[null,"This Excel application allows client agencies to manage their YJC referral data including submission of monthly reports to the Ministry of the Attorney General (MAG)"]
[]
[null,"This utility has been developed and is supported by SOMC. "]
[null,"Please send business and technical inquiries to: jane.rumleskie@ontario.ca or corinna.kitchen@ontario.ca"]
[]
[null,"Criminal Law Division 2017"]

{"sheet":"Deleted File#'s","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"hidden":true}
["File Number","Deletion date","Deleted by"]
[43040,42956.69548611111,"ciocioc"]
[42737,42996.47342592593,"ciocioc"]
[42738,42996.47346064815,"ciocioc"]
["01-2222-2017",42996.50895833333,"ciocioc"]
[42738,42996.51006944444,"ciocioc"]
[42737,42996.739652777775,"ciocioc"]
[42736,42996.7396875,"ciocioc"]
["01-2222-2017",42996.73974537037,"ciocioc"]
["01-2229-2017",42996.73976851852,"ciocioc"]
["01-0000-2017",42997.65440972222,"ciocioc"]
[42736,43020.611863425926,"ciocioc"]
[42737,43020.611909722225,"ciocioc"]
["01-2222-2017",43020.61194444444,"ciocioc"]
["01-2229-2017",43020.61195601852,"ciocioc"]

{"sheet":"Lists","index":3,"n_rows":80,"n_cols":19,"rows_kept":80,"hidden":true}
[]
[null,"MAGFundedProgram","ReasonForFileClosure","PoliceService","Victim Participation Type","Parental/Guardian Participants","Other Case Participants","Month","EJS/EJM","Year","YesNo","Class I Offences","Class II Offences","Agencies","Citizenship Status","Aboriginal","Racial","Gender","Ethnicity"]
[null,"Anger Management Program","Ongoing / Active","OPP","In Person","Mother","None","Jan","EJS - Post-Charge Cases (Crown Referral)",{"$f":"YEAR(TODAY())","v":2018},"Written","Accommodation/Transportation Fraud","Assault","Associated Youth Services of Peel","Canadian (by birth)","First Nations","Black","Female","Afghani"]
[null,"Essay/Project","Successful","Municipal/Regional","In Writing","Father","Loss Prevention Officer","Feb","EJM - Pre-Charge Cases (Police Referral)",{"$f":"J3-1","v":2017},"Verbal","Cause Disturbance","Assault with a Weapon","Boys  & Girls Club of Durham","Canadian (by naturalization)","Métis","East Asian","Male","American"]
[null,"Other Counselling","Successful (no conference)","RCMP","Verbal","Guardian","Police Officer","Mar",null,{"$f":"J4-1","v":2016},"Written and Verbal","Fraud under $5,000","Break and Enter","Boys and Girls Club of Kawartha Lakes","Landed Immigrant/Permanent Resident","Inuit","Indigenous","Trans/Transgender","Argentinian"]
[null,"Substance Use Program","Unsuccessful","Aboriginal Police Service","Completion of Victim Impact Statement","Grandparent","Probation Officer","Apr",null,{"$f":"J5-1","v":2015},null,"Mischief Under $5,000","Criminal Harrassment","Community Options for Justice (Oxford)","Refugee Claimant","No","Latino","Gender Non-Conforming","Armenian"]
[null,"Theft Prevention Program","Not Accepted into Program",null,"Via Appointed Designate","Sibling","Teacher/Principal","May",{"$nulls":3},"Possession Under $5,000","Fail to Comply","Community Organized Support & Prevention (Quinte) Inc.","None of the above (please specify)","Do not know","Middle Eastern","Two-Spirit","Austrian"]
[null,"Other","New Charges",null,"Did Not Participate","Aunt","Victim Support Person","Jun",{"$nulls":3},"Take Motor Vehicle without Consent","Publication/Distribution of Intimate Image Without Consent","Elizabeth Fry Society of Simcoe County","Do not know","Prefer not to answer","South Asian","Another Gender Identity","Australian"]
[null,"Completion of Conference Only","Bench Warrant",null,"Other","Uncle","Social Services Worker","Jul",{"$nulls":3},"Theft Under $5,000","Mischief Over","Essex County Diversion Program Inc.","Prefer not to answer",null,"White","Do not know","Bahamian"]
[null,null,"Transferred to Another Program",null,null,"Other","Friend","Aug",{"$nulls":4},"Obstructing Police/Arrest","FIREFLY",null,null,"Another Racial Category","Prefer not to answer","Bajan"]
[{"$nulls":5},"None","Other","Sept",{"$nulls":4},"Possesion Controlled Substance","Haldimand - Norfolk R.E.A.C.H. ",null,null,"Do not know",null,"Bermudian"]
[{"$nulls":7},"Oct",{"$nulls":4},"Possession Over","HandsTheFamilyHelpNetwork.ca",null,null,"Prefer not to answer",null,"Brazilian"]
[{"$nulls":7},"Nov",{"$nulls":4},"Possession Prohibited Weapon","Huron-Perth Centre",{"$nulls":4},"British/English"]
[null,"Last Column in Data Range",null,"FileName",{"$nulls":3},"Dec",{"$nulls":4},"Robbery","John Howard Society of Hamilton, Burlington and area",{"$nulls":4},"Bulgarian"]
[null,{"$f":"ADDRESS(ROW(Data!AR11),COLUMN(Data!AR11))","v":"$AR$11"},null,{"$f":"ReportingCourt&\"-YJC Stats.xlsm\"","v":"28 Perth-YJC Stats.xlsm"},{"$nulls":8},"Theft Over","John Howard Society of Peterborough",{"$nulls":4},"Cambodian"]
[{"$nulls":12},"Uttering Threats","John Howard Society of Waterloo-Wellington",{"$nulls":4},"Canadian"]
[null,"IdentityBased",{"$nulls":10},"Other (please specify in Case Comments section)","John Howard Society Peel-Halton-Dufferin",{"$nulls":4},"Chilean"]
[null,{"$f":"SUBSTITUTE(ADDRESS(ROW(Data!AL11),COLUMN(Data!AL11),4),1,\"\")&\":\"&SUBSTITUTE(ADDRESS(ROW(Data!AS11),COLUMN(Data!AS11),4),1,\"\")","v":"AL:AS"},{"$nulls":11},"Lanark County Community Justice Program Inc.",{"$nulls":4},"Chinese"]
[{"$nulls":13},"Laurencrest Youth Services Inc.",{"$nulls":4},"Croatian"]
[{"$nulls":13},"Ne-Chee Friendship Centre",{"$nulls":4},"Danish"]
[{"$nulls":13},"North Eastern Ontario Family and Children's Services",{"$nulls":4},"Dominican"]
[{"$nulls":13},"Operation Springboard",{"$nulls":4},"Dutch"]
[{"$nulls":13},"Owen Sound Family YMCA",{"$nulls":4},"Ecuadorian"]
[{"$nulls":13},"Port Colborne Community Association For Resource Extension (Port Cares)",{"$nulls":4},"Filipino"]
[{"$nulls":13},"Rebound Child & Youth Services Inc.",{"$nulls":4},"Finnish"]
[{"$nulls":13},"Rev. Norm Johnston Youth Residence (Lanark, Leeds 'n Grenville) Inc.",{"$nulls":4},"French"]
[{"$nulls":13},"Simcoe Muskoka Family Connexions",{"$nulls":4},"German"]
[{"$nulls":13},"St. Leonard's Society of London",{"$nulls":4},"Ghanaian"]
[{"$nulls":13},"The Salvation Army Correctional and Justice Services",{"$nulls":4},"Greek"]
[{"$nulls":13},"Thunder Bay Indigenous Youth Friendship Centre",{"$nulls":4},"Guyanese"]
[null,"Court ID","Courts","Agencies associated to Courts","Court ID and Name",{"$nulls":8},"United Native Friendship Centre",{"$nulls":4},"Haitian"]
[null,"01","Barrie","Elizabeth Fry Society of Simcoe County",{"$f":"TRIM(B32) & \" \" & TRIM(C32)","v":"01 Barrie"},{"$nulls":8},"West Scarborough Neighbourhood Community Centre",{"$nulls":4},"Honduran"]
[null,"02","Belleville","Community Organized Support & Prevention (Quinte) Inc.",{"$f":"TRIM(B33) & \" \" & TRIM(C33)","v":"02 Belleville"},{"$nulls":8},"YES Employment Services Inc. (Nipissing)",{"$nulls":4},"Hungarian"]
[null,"03","Bracebridge","Simcoe Muskoka Family Connexions","03 Bracebridge",{"$nulls":8},"Youth Diversion Program",{"$nulls":4},"Indian"]
[null,"04","Brampton","Associated Youth Services of Peel","04 Brampton",{"$nulls":13},"Irish"]
[null,"04A","Brampton","Associated Youth Services of Peel","04A Brampton"]
[null,"05","Brockville","Rev. Norm Johnston Youth Residence (Lanark, Leeds 'n Grenville) Inc.","05 Brockville",{"$nulls":13},"Iraqi"]
[null,"06","Cobourg","Rebound Child & Youth Services Inc.","06 Cobourg",{"$nulls":13},"Iranian"]
[null,"07","Cochrane","North Eastern Ontario Family and Children's Services","07 Cochrane",{"$nulls":13},"Italian"]
[null,"08","Cornwall","Laurencrest Youth Services Inc.","08 Cornwall",{"$nulls":13},"Jamaican"]
[null,"09","Durham Region","Boys  & Girls Club of Durham","09 Durham Region",{"$nulls":13},"Japanese"]
[null,"10","Dryden","FIREFLY","10 Dryden",{"$nulls":13},"Jewish"]
[null,"11","Etobicoke","Associated Youth Services of Peel","11 Etobicoke",{"$nulls":13},"Kenyan"]
[null,"12","Fort Frances","United Native Friendship Centre","12 Fort Frances",{"$nulls":13},"Korean"]
[null,"13","Goderich","The Salvation Army Correctional and Justice Services","13 Goderich",{"$nulls":13},"Laotian"]
[null,"14","Guelph","John Howard Society of Waterloo-Wellington","14 Guelph",{"$nulls":13},"Lebanese"]
[null,"15","Haileybury","North Eastern Ontario Family and Children's Services","15 Haileybury",{"$nulls":13},"Lithuanian"]
[null,"16","Hamilton","John Howard Society of Hamilton, Burlington and area","16 Hamilton",{"$nulls":13},"Macedonian"]
[null,"17","Kenora","Ne-Chee Friendship Centre","17 Kenora",{"$nulls":13},"Malaysian"]
[null,"18","Kingston","Youth Diversion Program","18 Kingston",{"$nulls":13},"Mexican"]
[null,"19","Kitchener","John Howard Society of Waterloo-Wellington","19 Kitchener",{"$nulls":13},"Nicaraguan"]
[null,"20","Lindsay","Boys and Girls Club of Kawartha Lakes","20 Lindsay",{"$nulls":13},"Nigerian"]
[null,"21","London","St. Leonard's Society of London","21 London",{"$nulls":13},"Norwegian"]
[null,"22","Milton","John Howard Society Peel-Halton-Dufferin","22 Milton",{"$nulls":13},"New Zealander"]
[null,"23","Newmarket","Operation Springboard","23 Newmarket",{"$nulls":13},"Omani"]
[null,"24","North Bay","YES Employment Services Inc. (Nipissing)","24 North Bay",{"$nulls":13},"Panamanian"]
[null,"25","Orangeville","Associated Youth Services of Peel","25 Orangeville",{"$nulls":13},"Peruvian"]
[null,"26","Owen Sound","Owen Sound Family YMCA","26 Owen Sound",{"$nulls":13},"Pakistani"]
[null,"27","Parry Sound","HandsTheFamilyHelpNetwork.ca","27 Parry Sound",{"$nulls":13},"Polish"]
[null,"28","Perth","Lanark County Community Justice Program Inc.","28 Perth",{"$nulls":13},"Portuguese"]
[null,"29","Peterborough","John Howard Society of Peterborough","29 Peterborough",{"$nulls":13},"Romanian"]
[null,"30","Simcoe-Cayuga","Haldimand - Norfolk R.E.A.C.H. ","30 Simcoe-Cayuga",{"$nulls":13},"Russian"]
[null,"31","St. Catharines-Niagara","Port Colborne Community Association For Resource Extension (Port Cares)","31 St. Catharines-Niagara",{"$nulls":13},"Rwandan"]
[null,"32","St. Thomas","The Salvation Army Correctional and Justice Services","32 St. Thomas",{"$nulls":13},"Saudi Arabian"]
[null,"33","Sault Ste. Marie","Operation Springboard","33 Sault Ste. Marie",{"$nulls":13},"Scottish"]
[null,"34","Scarborough East (Malvern)","Operation Springboard","34 Scarborough East (Malvern)",{"$nulls":13},"Serbian"]
[null,"35","Scarborough West","West Scarborough Neighbourhood Community Centre","35 Scarborough West",{"$nulls":13},"Somali"]
[null,"36","Stratford","Huron-Perth Centre","36 Stratford",{"$nulls":13},"Spanish"]
[null,"37","Thunder Bay","Thunder Bay Indigenous Youth Friendship Centre","37 Thunder Bay",{"$nulls":13},"Sri Lankan"]
[null,"38","Woodstock","Community Options for Justice (Oxford)","38 Woodstock",{"$nulls":13},"South African"]
[null,"39","Windsor","Essex County Diversion Program Inc.","39 Windsor",{"$nulls":13},"Swedish"]
[{"$nulls":18},"Syrian"]
[{"$nulls":18},"Tamil"]
[{"$nulls":18},"Trinidadian"]
[{"$nulls":18},"Turkish"]
[{"$nulls":18},"Venezuelan"]
[{"$nulls":18},"Vietnamese"]
[{"$nulls":18},"Other"]
[{"$nulls":18},"Do not know"]
[{"$nulls":18},"Prefer not to answer"]