{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Lookups","Data","Provider return report","Quick reference","Definitions","FAC","Export"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":11,"comments":2,"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":"Lookups","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":true,"merged":[[16,0,16,1]]}
["Code","Description",null,"Ethnicity",null,"Reason","Complete",null,"YJ Site",null,"NEET Status on exit",null,"OT Status"]
["SUPBAIL","Supported Bail for young offenders",null,"Māori",null,"Did not start","Exclude",null,"Police Youth Aid/Other",null,"Employment",null,"Youth Justice"]
["SWAP","Supervision with Activity Programmes for young offenders",null,"Māori/Pacific",null,"Intervention complete, goals partially/fully met",true,null,"Other community referral",null,"Education",null,"SCaF"]
["YJPTPNT","Therapeutic Parenting Programmes for young offenders who are soon to be parents or for parents of young offenders",null,"Pacific",null,"Reoffend - in custody",false,null,"Auckland City YJ",null,"Training",null,"Dual status"]
["YJSAP","Community Youth Development, Structured Activity Programmes for young offenders",null,"NZ Euro & Other",null,"Reoffend - change of legal status",false,null,"Christchurch East YJ",null,"Not in education, employment or training",null,"Other"]
["YJTPMEN","Therapeutic Mentoring Programmes for young offenders",null,null,null,"Disengaged",false,null,"Christchurch West YJ",null,"Primary parental caregiver"]
["YJYCSP","Youth Court Supervised Programmes for young offenders",null,null,null,"Absconded",false,null,"Hawkes Bay YJ",null,"Unknown"]
["YJYIP","Youth Inclusion Programme",null,null,null,"Left area: planned",true,null,"Manurewa YJ"]
["YDPPLAN","Services to implement the whanau service plans developed at or after a Youth Justice Family Group Conference",null,null,null,"Left area: unplanned",false,null,"North Harbour YJ"]
[null,null,null,null,null,"Breach of bail condition - in custody",false,null,"Otahuhu YJ"]
[null,null,null,null,null,"Other",false,null,"Otara YJ"]
[null,null,null,null,null,null,null,null,"Palmerston North YJ"]
[null,null,null,null,null,null,null,null,"Papakura YJ"]
[null,null,null,null,null,null,null,null,"Rotorua YJ"]
[null,null,null,null,null,null,null,null,"South Canterbury/Otago YJ"]
[null,null,null,null,null,null,null,null,"Southland YJ"]
["Values",null,null,null,null,null,null,null,"Tairawhiti YJ"]
["MonthStart",{"$f":"DATEVALUE(\"1 \"&ReportMonth&\" \"&ReportYear)","v":"2022-07-01"},null,null,null,null,null,null,"Taranaki YJ"]
["MonthEnd",{"$f":"EOMONTH(MonthStart,0)","v":"2022-07-31"},null,null,null,null,null,null,"Tauranga YJ"]
["FirstWeekday",{"$f":"EOMONTH(MonthStart,-1)+1+CHOOSE(WEEKDAY(EOMONTH(MonthStart,-1)+1,2),0,0,0,0,0,2,1)","v":"2022-07-01"},null,null,null,null,null,null,"Te Tai Tokerau YJ"]
["FirstMonday",{"$f":"EOMONTH(MonthStart,-1)+1+CHOOSE(WEEKDAY(EOMONTH(MonthStart,-1)+1,2),0,6,5,4,3,2,1)","v":"2022-07-04"},null,null,null,null,null,null,"Upper South YJ"]
[null,null,null,null,null,null,null,null,"Waikato/Hauraki YJ"]
[null,null,null,null,null,null,null,null,"Waitakere YJ"]
[null,null,null,null,null,null,null,null,"Wellington YJ"]
[null,null,null,null,null,null,null,null,"Whanganui YJ"]

{"sheet":"Data","index":1,"n_rows":14,"n_cols":34,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,14,10,15],[0,3,0,5],[9,0,9,2],[1,3,1,5],[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5]]}
[null,null,null,"Service description",null,null,"# FTE"]
["Select year",2022,null,"Combined services - All FTE not counted below\nYouth Workers may be working across multiple services"]
["Select month","July",null,"Therapeutic Mentoring Programmes for young offenders"]
["Provider name","Provider Example",null,"Supervision with Activity Programmes for young offenders"]
[null,null,null,"Supported Bail for young offenders"]
[null,null,null,"Therapeutic Parenting Programmes for young offenders who are soon to be parents or for parents of young offenders"]
[null,null,null,"Community Youth Development, Structured Activity Programmes for young offenders"]
[null,null,null,"Youth Court Supervised Programmes for young offenders",null,null,null,null,null,null,null,null,null,null,"Enter these once per child, for the relevant service"]
[null,null,null,"Youth Inclusion Programme"]
["See quick reference guide for copy/paste troubleshooting",null,null,"Services to implement the whanau service plans developed at or after a Youth Justice Family Group Conference"]
[]
["First name","Last name","CYRAS ID","Oranga Tamariki status","Ethnicity","Gender identity","Date of birth","Service provided","Referral source","Date referral received","Date defined programme starts","Date defined programme ends/date referral closed (DNS)","Reason for exit","NEET status on exit","Number of occurrences: YP offended/reoffended, but remained on defined programme","Number of occurrences: YP breached conditions of bail, but remained on defined programme","Complete","Re-entry","Full name","Code","Age at referral","Age at exit","Current age","Supported bail - weeks","Active this month","Number of week periods","Working date","Period pending referral","Waiting period - DNS","Waiting period","Length of time on programme","Fixed Date referral received","Fixed Date defined programme starts","Fixed Date defined programme ends/date referral closed (DNS)"]
["Henry","Cavill",123456,"Youth Justice","Māori/Pacific","Male","1996-07-01","Supervision with Activity Programmes for young offenders","Tairawhiti YJ","2022-03-08","2022-03-12","2022-03-25","Intervention complete, goals partially/fully met","Training",1,0,0,{"$f":"IF(OR(COUNTIF($C$12:$C12,Data[[#This Row],[CYRAS ID]])=0,Data[[#This Row],[CYRAS ID]]=\"\"),\"\",TRUE)","v":""},{"$f":"IF(Data[[#This Row],[Re-entry]]=TRUE,\"\",Data[[#This Row],[First name]]&\" \"&Data[[#This Row],[Last name]])","v":"Henry Cavill"},{"$f":"IFERROR(IF(Data[[#This Row],[Service provided]]=\"\",\"\",INDEX(ServiceTypes[Code],MATCH(Data[[#This Row],[Service provided]],ServiceTypes[Description],0))),\"\")","v":"SWAP"},{"$f":"IF(Data[[#This Row],[Date of birth]]=\"\",\"\",IFERROR(DATEDIF(Data[[#This Row],[Date of birth]],Data[[#This Row],[Fixed Date referral received]],\"y\"),\"\"))","v":25},{"$f":"IF(Data[[#This Row],[Date of birth]]=\"\",\"\",IFERROR(DATEDIF(Data[[#This Row],[Date of birth]],Data[[#This Row],[Date defined programme ends/date referral closed (DNS)]],\"y\"),\"\"))","v":25},{"$f":"IF(Data[[#This Row],[Date of birth]]=\"\",\"\",DATEDIF(Data[[#This Row],[Date of birth]],MonthEnd,\"y\"))","v":26},{"$f":"IF(OR(Data[[#This Row],[Fixed Date defined programme starts]]=\"\",Data[[#This Row],[Fixed Date defined programme starts]]>MonthEnd),\"\",IF(Data[[#This Row],[Code]]=\"YJTPMEN\",ROUND(IF(OR(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]=\"\",Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>MonthEnd),DATEDIF(Data[[#This Row],[Fixed Date defined programme starts]],MonthEnd,\"D\")/7,DATEDIF(Data[[#This Row],[Fixed Date defined programme starts]],Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]],\"D\")/7),0)))","v":false},{"$f":"AND(Data[[#This Row],[Fixed Date defined programme starts]]<=MonthEnd,Data[[#This Row],[Fixed Date defined programme starts]]>0,Data[[#This Row],[Fixed Date defined programme starts]]<>\"\",OR(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>=MonthStart,Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]=\"\",Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]=0))","v":false},{"$f":"IF(OR(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>=MonthStart,Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]=\"\"),IF(Data[[#This Row],[Code]]=\"SUPBAIL\",IFERROR(ROUNDUP((IF(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]=\"\",MonthEnd,MIN(MonthEnd,Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]))-MAX(FirstMonday,Data[[#This Row],[Fixed Date defined programme starts]]))/7,0)+IF(AND(Data[[#This Row],[Fixed Date defined programme starts]]>=MonthStart,Data[[#This Row],[Fixed Date defined programme starts]]<FirstMonday),1,0),\"\"),\"\"),\"\")","v":""},{"$f":"ISNUMBER(Data[[#This Row],[Fixed Date defined programme starts]])","v":true},{"$f":"IF(AND(Data[[#This Row],[Fixed Date defined programme starts]]>0,Data[[#This Row],[Fixed Date referral received]]>0),IF(Data[[#This Row],[Fixed Date defined programme starts]]<Data[[#This Row],[Fixed Date referral received]],Data[[#This Row],[Fixed Date referral received]]-Data[[#This Row],[Fixed Date defined programme starts]],\"\"),\"\")","v":""},{"$f":"IF(AND(Data[[#This Row],[Fixed Date referral received]]>0,Data[[#This Row],[Reason for exit]]=\"Did not start\"),IF(Data[[#This Row],[Fixed Date defined programme starts]]>Data[[#This Row],[Fixed Date referral received]],Data[[#This Row],[Fixed Date defined programme starts]]-Data[[#This Row],[Fixed Date referral received]],IF(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>Data[[#This Row],[Fixed Date referral received]],Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]-Data[[#This Row],[Fixed Date referral received]],\"\")),\"\")","v":""},{"$f":"IF(AND(Data[[#This Row],[Fixed Date defined programme starts]]>0,Data[[#This Row],[Fixed Date referral received]]>0,Data[[#This Row],[Reason for exit]]<>\"Did not start\"),IF(Data[[#This Row],[Fixed Date defined programme starts]]>Data[[#This Row],[Date referral received]],Data[[#This Row],[Fixed Date defined programme starts]]-Data[[#This Row],[Fixed Date referral received]],\"\"),\"\")","v":4},{"$f":"IF(Data[[#This Row],[Reason for exit]]=\"Did not start\",\"\",IF(AND(Data[[#This Row],[Fixed Date defined programme starts]]>0,Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>0),Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]-Data[[#This Row],[Fixed Date defined programme starts]],IF(AND(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>0,OR(Data[[#This Row],[Fixed Date referral received]]>0,Data[[#This Row],[Fixed Date defined programme starts]]>0)),Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]-MAX(Data[[#This Row],[Fixed Date defined programme starts]],Data[[#This Row],[Fixed Date referral received]]),\"\")))","v":13},{"$f":"IFERROR(DATEVALUE(Data[[#This Row],[Date referral received]]),Data[[#This Row],[Date referral received]])","v":"2022-03-08"},{"$f":"IFERROR(DATEVALUE(Data[[#This Row],[Date defined programme starts]]),Data[[#This Row],[Date defined programme starts]])","v":"2022-03-12"},{"$f":"IFERROR(DATEVALUE(Data[[#This Row],[Date defined programme ends/date referral closed (DNS)]]),Data[[#This Row],[Date defined programme ends/date referral closed (DNS)]])","v":"2022-03-25"}]
["Henry","Cavill",123456,"Youth Justice","Māori/Pacific","Male","1996-07-01","Supervision with Activity Programmes for young offenders","Tairawhiti YJ","2022-03-08","2022-03-12","2022-03-25","Intervention complete, goals partially/fully met","Training",1,0,null,{"$f":"IF(OR(COUNTIF($C$12:$C13,Data[[#This Row],[CYRAS ID]])=0,Data[[#This Row],[CYRAS ID]]=\"\"),\"\",TRUE)","v":true},{"$f":"IF(Data[[#This Row],[Re-entry]]=TRUE,\"\",Data[[#This Row],[First name]]&\" \"&Data[[#This Row],[Last name]])","v":""},{"$f":"IFERROR(IF(Data[[#This Row],[Service provided]]=\"\",\"\",INDEX(ServiceTypes[Code],MATCH(Data[[#This Row],[Service provided]],ServiceTypes[Description],0))),\"\")","v":"SWAP"},{"$f":"IF(Data[[#This Row],[Date of birth]]=\"\",\"\",IFERROR(DATEDIF(Data[[#This Row],[Date of birth]],Data[[#This Row],[Fixed Date referral received]],\"y\"),\"\"))","v":25},{"$f":"IF(Data[[#This Row],[Date of birth]]=\"\",\"\",IFERROR(DATEDIF(Data[[#This Row],[Date of birth]],Data[[#This Row],[Date defined programme ends/date referral closed (DNS)]],\"y\"),\"\"))","v":25},{"$f":"IF(Data[[#This Row],[Date of birth]]=\"\",\"\",DATEDIF(Data[[#This Row],[Date of birth]],MonthEnd,\"y\"))","v":26},{"$f":"IF(OR(Data[[#This Row],[Fixed Date defined programme starts]]=\"\",Data[[#This Row],[Fixed Date defined programme starts]]>MonthEnd),\"\",IF(Data[[#This Row],[Code]]=\"YJTPMEN\",ROUND(IF(OR(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]=\"\",Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>MonthEnd),DATEDIF(Data[[#This Row],[Fixed Date defined programme starts]],MonthEnd,\"D\")/7,DATEDIF(Data[[#This Row],[Fixed Date defined programme starts]],Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]],\"D\")/7),0)))","v":false},{"$f":"AND(Data[[#This Row],[Fixed Date defined programme starts]]<=MonthEnd,Data[[#This Row],[Fixed Date defined programme starts]]>0,Data[[#This Row],[Fixed Date defined programme starts]]<>\"\",OR(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>=MonthStart,Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]=\"\",Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]=0))","v":false},{"$f":"IF(OR(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>=MonthStart,Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]=\"\"),IF(Data[[#This Row],[Code]]=\"SUPBAIL\",IFERROR(ROUNDUP((IF(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]=\"\",MonthEnd,MIN(MonthEnd,Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]))-MAX(FirstMonday,Data[[#This Row],[Fixed Date defined programme starts]]))/7,0)+IF(AND(Data[[#This Row],[Fixed Date defined programme starts]]>=MonthStart,Data[[#This Row],[Fixed Date defined programme starts]]<FirstMonday),1,0),\"\"),\"\"),\"\")","v":""},{"$f":"ISNUMBER(Data[[#This Row],[Fixed Date defined programme starts]])","v":true},{"$f":"IF(AND(Data[[#This Row],[Fixed Date defined programme starts]]>0,Data[[#This Row],[Fixed Date referral received]]>0),IF(Data[[#This Row],[Fixed Date defined programme starts]]<Data[[#This Row],[Fixed Date referral received]],Data[[#This Row],[Fixed Date referral received]]-Data[[#This Row],[Fixed Date defined programme starts]],\"\"),\"\")","v":""},{"$f":"IF(AND(Data[[#This Row],[Fixed Date referral received]]>0,Data[[#This Row],[Reason for exit]]=\"Did not start\"),IF(Data[[#This Row],[Fixed Date defined programme starts]]>Data[[#This Row],[Fixed Date referral received]],Data[[#This Row],[Fixed Date defined programme starts]]-Data[[#This Row],[Fixed Date referral received]],IF(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>Data[[#This Row],[Fixed Date referral received]],Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]-Data[[#This Row],[Fixed Date referral received]],\"\")),\"\")","v":""},{"$f":"IF(AND(Data[[#This Row],[Fixed Date defined programme starts]]>0,Data[[#This Row],[Fixed Date referral received]]>0,Data[[#This Row],[Reason for exit]]<>\"Did not start\"),IF(Data[[#This Row],[Fixed Date defined programme starts]]>Data[[#This Row],[Date referral received]],Data[[#This Row],[Fixed Date defined programme starts]]-Data[[#This Row],[Fixed Date referral received]],\"\"),\"\")","v":4},{"$f":"IF(Data[[#This Row],[Reason for exit]]=\"Did not start\",\"\",IF(AND(Data[[#This Row],[Fixed Date defined programme starts]]>0,Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>0),Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]-Data[[#This Row],[Fixed Date defined programme starts]],IF(AND(Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]>0,OR(Data[[#This Row],[Fixed Date referral received]]>0,Data[[#This Row],[Fixed Date defined programme starts]]>0)),Data[[#This Row],[Fixed Date defined programme ends/date referral closed (DNS)]]-MAX(Data[[#This Row],[Fixed Date defined programme starts]],Data[[#This Row],[Fixed Date referral received]]),\"\")))","v":13},{"$f":"IFERROR(DATEVALUE(Data[[#This Row],[Date referral received]]),Data[[#This Row],[Date referral received]])","v":"2022-03-08"},{"$f":"IFERROR(DATEVALUE(Data[[#This Row],[Date defined programme starts]]),Data[[#This Row],[Date defined programme starts]])","v":"2022-03-12"},{"$f":"IFERROR(DATEVALUE(Data[[#This Row],[Date defined programme ends/date referral closed (DNS)]]),Data[[#This Row],[Date defined programme ends/date referral closed (DNS)]])","v":"2022-03-25"}]

{"sheet":"Provider return report","index":2,"n_rows":109,"n_cols":14,"rows_kept":109,"cut":false,"hidden":false,"merged":[[41,4,41,5],[41,2,41,3],[3,8,4,8],[5,8,6,8],[7,8,8,8],[3,7,4,7],[39,4,39,5],[40,4,40,5],[10,7,10,8],[36,4,36,5],[31,2,31,8],[38,4,38,5],[38,2,38,3],[39,2,39,3],[40,2,40,3],[32,2,33,3],[77,7,77,8],[68,8,69,8],[74,7,75,7],[74,8,75,8],[54,7,54,8],[65,7,66,8],[70,7,71,7],[70,8,71,8],[72,7,73,7],[72,8,73,8],[68,7,69,7],[0,1,0,5],[1,1,1,5],[3,0,3,1],[5,7,6,7],[7,7,8,7],[3,2,3,5],[32,4,33,5],[37,4,37,5],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[34,4,34,5],[35,4,35,5],[105,0,105,1],[106,0,106,1],[107,0,107,1],[108,0,108,1],[32,0,33,0],[32,1,33,1],[45,0,46,3],[47,0,48,3],[49,0,50,3],[51,0,52,3],[53,0,54,3],[55,0,56,3],[57,0,58,3],[65,1,65,5],[55,4,56,5],[57,4,58,5],[59,0,60,3],[61,0,62,3],[43,0,44,3],[55,7,63,8],[104,0,104,1],[61,4,62,5],[43,4,44,5],[45,4,46,5],[47,4,48,5],[59,4,60,5],[68,0,68,1],[68,2,68,5],[66,1,66,5],[49,4,50,5],[51,4,52,5],[53,4,54,5]]}
["Provider",{"$f":"IF(ProviderName=\"Enter name\",\"Please enter provider name in the Data tab\",ProviderName)","v":"Provider Example"},null,null,null,null,null,"Report version",1.5]
["Reporting period",{"$f":"\"As at \" & TEXT(EOMONTH(DATEVALUE(\"1 \"&ReportMonth&\" \"&ReportYear),0),\"d mmmm yyy\")","v":"As at 31 July 2022"},null,null,null,null,null,"Referrals received pending\ndefined programme start",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">\"&0,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],0,Data[Fixed Date defined programme starts],0)\n+COUNTIFS(Data[Fixed Date referral received],\">\"&0,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],0,Data[Fixed Date defined programme starts],\">\"&MonthEnd)","v":0}]
["Provider Level Report",null,null,null,null,null,null,"Young people\ncurrently engaged",{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">\"&MonthEnd)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Fixed Date defined programme starts],\">\"&0)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],0,Data[Fixed Date defined programme starts],\">\"&0)","v":0}]
["Referral source",null,"Oranga Tamariki status",null,null,null,null,"Exited this month",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],\"<>Did not start\")","v":0}]
["YJ Site","New referrals","Youth Justice","SCaF","Dual status","Other"]
["Police Youth Aid/Other",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Successful exits",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Complete],TRUE)","v":0}]
["Other community referral",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0}]
["Auckland City YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Unsuccessful exits",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Complete],FALSE)","v":0}]
["Christchurch East YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0}]
["Christchurch West YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0}]
["Hawkes Bay YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Exits"]
["Manurewa YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Reason","Young people"]
["North Harbour YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Did not start",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table1161[[#This Row],[Reason]])","v":0}]
["Otahuhu YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Intervention complete, goals partially/fully met",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table1161[[#This Row],[Reason]])","v":0}]
["Otara YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Left area: planned",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table1161[[#This Row],[Reason]])","v":0}]
["Palmerston North YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Reoffend - in custody",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table1161[[#This Row],[Reason]])","v":0}]
["Papakura YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Reoffend - change of legal status",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table1161[[#This Row],[Reason]])","v":0}]
["Rotorua YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Disengaged",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table1161[[#This Row],[Reason]])","v":0}]
["South Canterbury/Otago YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Absconded",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table1161[[#This Row],[Reason]])","v":0}]
["Southland YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Left area: unplanned",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table1161[[#This Row],[Reason]])","v":0}]
["Tairawhiti YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Breach of bail condition - in custody",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table1161[[#This Row],[Reason]])","v":0}]
["Taranaki YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Other",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table1161[[#This Row],[Reason]])","v":0}]
["Tauranga YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0}]
["Te Tai Tokerau YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"NEET Status on exit","Young people"]
["Upper South YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Employment",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus44[[#This Row],[NEET Status on exit]])","v":0}]
["Waikato/Hauraki YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Education",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus44[[#This Row],[NEET Status on exit]])","v":0}]
["Waitakere YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Training",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus44[[#This Row],[NEET Status on exit]])","v":0}]
["Wellington YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Not in education, employment or training",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus44[[#This Row],[NEET Status on exit]])","v":0}]
["Whanganui YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]])","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites1547[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\")","v":0},null,"Primary parental caregiver",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus44[[#This Row],[NEET Status on exit]])","v":0}]
["Total",{"$f":"SUBTOTAL(109,YJSites1547[New referrals])","v":0},{"$f":"SUBTOTAL(109,YJSites1547[Youth Justice])","v":0},{"$f":"SUBTOTAL(109,YJSites1547[SCaF])","v":0},{"$f":"SUBTOTAL(109,YJSites1547[Dual status])","v":0},{"$f":"SUBTOTAL(109,YJSites1547[Other])","v":0},null,"Unknown",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus44[[#This Row],[NEET Status on exit]])","v":0}]
[]
["Engaged during month",null,"Includes YP currently involved in programme & exited within reporting month"]
["Service code","Young people","Number of occurrences: YP offended/reoffended, but remained on service",null,"Number of occurrences: YP breached conditions of bail, but remained on service",null,null,"Gender identity","Young people"]
[null,null,null,null,null,null,null,"Male",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Gender identity],Table8111765[[#This Row],[Gender identity]])","v":0}]
["Therapeutic Mentoring Programmes for young offenders",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Service provided],$A35)","v":0},{"$f":"IFERROR(IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A35),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A35),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Service provided],$A35),\" YP)\"),\"\"),\"\")","v":""},null,null,null,null,"Female",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Gender identity],Table8111765[[#This Row],[Gender identity]])","v":0}]
["Supervision with Activity Programmes for young offenders",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Service provided],$A36)","v":0},{"$f":"IFERROR(IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A36),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A36),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Service provided],$A36),\" YP)\"),\"\"),\"\")","v":""},null,null,null,null,"Gender diverse",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Gender identity],Table8111765[[#This Row],[Gender identity]])","v":0}]
["Supported Bail for young offenders",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Service provided],$A37)","v":0},{"$f":"IFERROR(IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A37),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A37),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Service provided],$A37),\" YP)\"),\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(SUMIFS(Data[Number of occurrences: YP breached conditions of bail, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A37)>0,_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP breached conditions of bail, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A37),\" (\",COUNTIFS(Data[Number of occurrences: YP breached conditions of bail, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Service provided],$A37),\" YP)\"),\"\"),\"\")","v":""}]
["Therapeutic Parenting Programmes for young offenders who are soon to be parents or for parents of young offenders",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Service provided],$A38)","v":0},{"$f":"IFERROR(IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A38),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A38),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Service provided],$A38),\" YP)\"),\"\"),\"\")","v":""},null,null,null,null,"Ethnicity","Young people"]
["Community Youth Development, Structured Activity Programmes for young offenders",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Service provided],$A39)","v":0},{"$f":"IFERROR(IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A39),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A39),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Service provided],$A39),\" YP)\"),\"\"),\"\")","v":""},null,null,null,null,"Māori",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Ethnicity],NewEthnicity101664[[#This Row],[Ethnicity]])","v":0}]
["Youth Court Supervised Programmes for young offenders",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Service provided],$A40)","v":0},{"$f":"IFERROR(IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A40),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A40),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Service provided],$A40),\" YP)\"),\"\"),\"\")","v":""},null,null,null,null,"Māori/Pacific",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Ethnicity],NewEthnicity101664[[#This Row],[Ethnicity]])","v":0}]
["Youth Inclusion Programme",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Service provided],$A41)","v":0},{"$f":"IFERROR(IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A41),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A41),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Service provided],$A41),\" YP)\"),\"\"),\"\")","v":""},null,null,null,null,"Pacific",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Ethnicity],NewEthnicity101664[[#This Row],[Ethnicity]])","v":0}]
["Services to implement the whanau service plans developed at or after a Youth Justice Family Group Conference",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Service provided],$A42)","v":0},{"$f":"IFERROR(IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A42),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Service provided],$A42),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Service provided],$A42),\" YP)\"),\"\"),\"\")","v":""},null,null,null,null,"NZ Euro & Other",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Ethnicity],NewEthnicity101664[[#This Row],[Ethnicity]])","v":0}]
[null,{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Code],$A43)","v":0},{"$f":"IFERROR(IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],$A43),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],$A43),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Code],$A43),\" YP)\"),\"\"),\"\")","v":""}]
["Service description",null,null,null,"Youth worker FTE",null,null,"Age","Young people"]
[null,null,null,null,null,null,null,"Up to 10",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],\"<=\"&10)","v":0}]
["Combined services - All FTE not counted below\nYouth Workers may be working across multiple services",null,null,null,{"$f":"Data!$G2","v":0},null,null,11,{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],Table12141966[[#This Row],[Age]])","v":0}]
[null,null,null,null,null,null,null,12,{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],Table12141966[[#This Row],[Age]])","v":0}]
["Therapeutic Mentoring Programmes for young offenders",null,null,null,{"$f":"Data!$G3","v":0},null,null,13,{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],Table12141966[[#This Row],[Age]])","v":0}]
[null,null,null,null,null,null,null,14,{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],Table12141966[[#This Row],[Age]])","v":0}]
["Supervision with Activity Programmes for young offenders",null,null,null,{"$f":"Data!$G4","v":0},null,null,15,{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],Table12141966[[#This Row],[Age]])","v":0}]
[null,null,null,null,null,null,null,16,{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],Table12141966[[#This Row],[Age]])","v":0}]
["Supported Bail for young offenders",null,null,null,{"$f":"Data!$G5","v":0},null,null,17,{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],Table12141966[[#This Row],[Age]])","v":0}]
[null,null,null,null,null,null,null,"18+",{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],\">=\"&18)","v":0}]
["Therapeutic Parenting Programmes for young offenders who are soon to be parents or for parents of young offenders",null,null,null,{"$f":"Data!$G6","v":0}]
[null,null,null,null,null,null,null,"Comments"]
["Community Youth Development, Structured Activity Programmes for young offenders",null,null,null,{"$f":"Data!$G7","v":0}]
[]
["Youth Court Supervised Programmes for young offenders",null,null,null,{"$f":"Data!$G8","v":0}]
[]
["Youth Inclusion Programme",null,null,null,{"$f":"Data!$G9","v":0}]
[]
["Services to implement the whanau service plans developed at or after a Youth Justice Family Group Conference",null,null,null,{"$f":"Data!G10","v":0}]
[]
[]
[]
["Provider",{"$f":"IF(ProviderName=\"Enter name\",\"Please enter provider name in the Data tab\",ProviderName)","v":"Provider Example"},null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Reporting period as at \",TEXT(EOMONTH(DATEVALUE(\"1 \"&ReportMonth&\" \"&ReportYear),0),\"d mmmm yyy\"))","v":"Reporting period as at 31 July 2022"}]
["Service","Services to implement the whanau service plans developed at or after a Youth Justice Family Group Conference",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ServiceTypes[Code],MATCH($B$67,ServiceTypes[Description],0)),\"\")","v":"YDPPLAN"}]
["Service Level Report",null,null,null,null,null,null,"Referrals received pending\ndefined programme start",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">\"&0,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],0,Data[Fixed Date defined programme starts],0,Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date referral received],\">\"&0,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],0,Data[Fixed Date defined programme starts],\">\"&MonthEnd,Data[Code],Service1)","v":0}]
["Referral source",null,"Oranga Tamariki status",null,null,null,null,"Young people\ncurrently engaged",{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">\"&MonthEnd,Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Fixed Date defined programme starts],\">\"&0,Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],0,Data[Fixed Date defined programme starts],\">\"&0,Data[Code],Service1)","v":0}]
["YJ Site","New referrals","Youth Justice","SCaF","Dual status","Other"]
["Police Youth Aid/Other",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Exited this month",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],\"<>Did not start\",Data[Code],Service1)","v":0}]
["Other community referral",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0}]
["Auckland City YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Successful exits",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Complete],TRUE,Data[Code],Service1)","v":0}]
["Christchurch East YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0}]
["Christchurch West YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Unsuccessful exits",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Complete],FALSE,Data[Code],Service1)","v":0}]
["Hawkes Bay YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0}]
["Manurewa YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0}]
["North Harbour YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Exits"]
["Otahuhu YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Reason","Young people"]
["Otara YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Did not start",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table11617[[#This Row],[Reason]],Data[Code],Service1)","v":0}]
["Palmerston North YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Intervention complete, goals partially/fully met",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table11617[[#This Row],[Reason]],Data[Code],Service1)","v":0}]
["Papakura YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Left area: planned",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table11617[[#This Row],[Reason]],Data[Code],Service1)","v":0}]
["Rotorua YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Reoffend - in custody",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table11617[[#This Row],[Reason]],Data[Code],Service1)","v":0}]
["South Canterbury/Otago YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Reoffend - change of legal status",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table11617[[#This Row],[Reason]],Data[Code],Service1)","v":0}]
["Southland YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Disengaged",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table11617[[#This Row],[Reason]],Data[Code],Service1)","v":0}]
["Tairawhiti YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Absconded",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table11617[[#This Row],[Reason]],Data[Code],Service1)","v":0}]
["Taranaki YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Left area: unplanned",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table11617[[#This Row],[Reason]],Data[Code],Service1)","v":0}]
["Tauranga YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Breach of bail condition - in custody",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table11617[[#This Row],[Reason]],Data[Code],Service1)","v":0}]
["Te Tai Tokerau YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Other",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Table11617[[#This Row],[Reason]],Data[Code],Service1)","v":0}]
["Upper South YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0}]
["Waikato/Hauraki YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Age","Young people"]
["Waitakere YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,"Up to 10",{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Current age],\"<=\"&10,Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Current age],\"<=\"&10,Data[Code],Service1)","v":0}]
["Wellington YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,11,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)","v":0}]
["Whanganui YJ",{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Youth Justice\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"SCaF\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Dual status\",Data[Code],Service1)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],YJSites154742[[#This Row],[YJ Site]],Data[Oranga Tamariki status],\"Other\",Data[Code],Service1)","v":0},null,12,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)","v":0}]
["Total",{"$f":"SUBTOTAL(109,YJSites154742[New referrals])","v":0},{"$f":"SUBTOTAL(109,YJSites154742[Youth Justice])","v":0},{"$f":"SUBTOTAL(109,YJSites154742[SCaF])","v":0},{"$f":"SUBTOTAL(109,YJSites154742[Dual status])","v":0},{"$f":"SUBTOTAL(109,YJSites154742[Other])","v":0},null,13,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)","v":0}]
[null,null,null,null,null,null,null,14,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)","v":0}]
["NEET Status on exit","Young people",null,"Gender identity","Young people",null,null,15,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)","v":0}]
["Employment",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus4450[[#This Row],[NEET Status on exit]],Data[Code],Service1)","v":0},null,"Male",{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Gender identity],Table811176546[[#This Row],[Gender identity]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\"\",Data[Gender identity],Table811176546[[#This Row],[Gender identity]],Data[Code],Service1)","v":0},null,null,16,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)","v":0}]
["Education",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus4450[[#This Row],[NEET Status on exit]],Data[Code],Service1)","v":0},null,"Female",{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Gender identity],Table811176546[[#This Row],[Gender identity]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\"\",Data[Gender identity],Table811176546[[#This Row],[Gender identity]],Data[Code],Service1)","v":0},null,null,17,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Current age],Table1214196648[[#This Row],[Age]],Data[Code],Service1)","v":0}]
["Training",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus4450[[#This Row],[NEET Status on exit]],Data[Code],Service1)","v":0},null,"Gender diverse",{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Gender identity],Table811176546[[#This Row],[Gender identity]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\"\",Data[Gender identity],Table811176546[[#This Row],[Gender identity]],Data[Code],Service1)","v":0},null,null,"18+",{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Current age],\">=\"&18,Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Current age],\">=\"&18,Data[Code],Service1)","v":0}]
["Not in education, employment or training",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus4450[[#This Row],[NEET Status on exit]],Data[Code],Service1)","v":0}]
["Primary parental caregiver",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus4450[[#This Row],[NEET Status on exit]],Data[Code],Service1)","v":0},null,null,null,null,null,"Ethnicity","Young people"]
["Unknown",{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],NEETStatus4450[[#This Row],[NEET Status on exit]],Data[Code],Service1)","v":0},null,null,null,null,null,"Māori",{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Ethnicity],NewEthnicity10166445[[#This Row],[Ethnicity]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\"\",Data[Ethnicity],NewEthnicity10166445[[#This Row],[Ethnicity]],Data[Code],Service1)","v":0}]
[null,null,null,null,null,null,null,"Māori/Pacific",{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Ethnicity],NewEthnicity10166445[[#This Row],[Ethnicity]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\"\",Data[Ethnicity],NewEthnicity10166445[[#This Row],[Ethnicity]],Data[Code],Service1)","v":0}]
["Time",null,"Average days",null,null,null,null,"Pacific",{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Ethnicity],NewEthnicity10166445[[#This Row],[Ethnicity]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\"\",Data[Ethnicity],NewEthnicity10166445[[#This Row],[Ethnicity]],Data[Code],Service1)","v":0}]
["Programme started before referral received",null,{"$f":"IFERROR(SUMIFS(Data[Period pending referral],Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Period pending referral],\">\"&0,Data[Code],Service1)\n/COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Period pending referral],\">\"&0,Data[Code],Service1),0)","v":0},null,null,null,null,"NZ Euro & Other",{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Ethnicity],NewEthnicity10166445[[#This Row],[Ethnicity]],Data[Code],Service1)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Date defined programme ends/date referral closed (DNS)],\"\",Data[Ethnicity],NewEthnicity10166445[[#This Row],[Ethnicity]],Data[Code],Service1)","v":0}]
["Period from referral received to defined programme start",null,{"$f":"IFERROR(SUMIFS(Data[Waiting period],Data[Fixed Date defined programme starts],\">=\"&MonthStart,Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Waiting period],\">\"&0,Data[Code],Service1)\n/COUNTIFS(Data[Fixed Date defined programme starts],\">=\"&MonthStart,Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Waiting period],\">\"&0,Data[Code],Service1),0)","v":0}]
["Period from referral received to DNS decision",null,{"$f":"IFERROR(SUMIFS(Data[Waiting period - DNS],Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Waiting period - DNS],\">\"&0,Data[Code],Service1)\n/COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Waiting period - DNS],\">\"&0,Data[Code],Service1),0)","v":0}]
["Length of time on programme",null,{"$f":"IFERROR(SUMIFS(Data[Length of time on programme],Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Length of time on programme],\">\"&0,Data[Code],Service1)\n/COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Length of time on programme],\">\"&0,Data[Code],Service1),0)","v":0}]

{"sheet":"Quick reference","index":3,"n_rows":128,"n_cols":10,"rows_kept":128,"cut":false,"hidden":false,"merged":[[127,0,127,9],[84,0,84,9],[83,0,83,9],[112,0,112,9],[113,0,113,9],[119,0,119,9],[120,0,120,9],[117,0,117,9],[103,0,103,9],[115,0,115,9],[105,0,105,9],[74,0,74,9],[108,0,108,9],[109,0,109,9],[104,0,104,9],[118,0,118,9],[106,0,106,9],[85,0,85,9],[86,0,86,9],[87,0,87,9],[88,0,88,9],[116,0,116,9],[101,0,101,9],[102,0,102,9],[110,0,110,9],[111,0,111,9],[107,0,107,9],[2,0,2,9],[42,0,43,9],[3,0,3,9],[5,0,5,9],[6,0,6,9],[7,0,7,9],[17,9,23,9],[11,0,11,9],[12,0,12,9],[9,0,9,9],[8,0,8,9],[4,0,4,9],[51,0,51,9],[52,0,52,9],[53,0,53,9],[58,0,58,9],[73,0,73,9],[54,0,54,9],[72,0,72,9],[57,0,57,9]]}
["Youth Justice reporting template"]
[]
["Save document, ensuring it remains in the .xlsm file format"]
["• Locate and open the reporting template in your local drive."]
["If relevant:"]
["• Save the document"]
["      • File"]
["      • Save As"]
["      • Name the file something you will remember"]
["      • Save as file type \"Excel Macro-Enabled Workbook (*.xlsm)\""]
[]
["Enable content (must be completed for each tab opened)"]
["• Note Security warning (Yellow strip) at top: Click Enable Content"]
[]
["When copying and pasting, do not copy and paste the whole row, ensure you only copy and paste data in the columns required in the sheet"]
["Do not copy entire rows"]
[null,null,null,null,null,null,null,null,null,"Note for Mac users, and users without Outlook"]
[null,null,null,null,null,null,null,null,null,"This spreadsheet works with Excel for Mac. Ensure macros are enabled, and use the Output to email button as normal.\nThe file will save to the folder where the template is saved, instead of attaching to an email.\nDo not send client-level data via email."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["How to copy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Change relevant details in Data tab"]
["At the top of the Data tab, enter your provider name, select the reporting month from the drop down list, then enter the reporting year.\nThe order entered doesn't matter."]
[]
[]
[]
[]
[]
[]
[]
["Number of Youth Worker FTE"]
["• This section assists your PfO advisor to understand current staffing levels."]
["• Do not double count FTEs  "]
["• COMBINED: only count FTEs that are across multiple service types"]
["• Service Level FTEs (e.g. SUPBAIL): only count FTEs specifically assigned to that given service"]
["Example: I have 6 FTEs in total, 4 are assigned across multiple services, 2 are assigned to Supported Bail only."]
["Number of programmes delivered"]
["• For providers funded to deliver a given block of programmes "]
["• Enter number of programmes delivered during reporting month "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Providers with NO case management system"]
["Client Level Data Entry"]
["• Manually enter client level data"]
["      • Complete client level data entry on first PINK row, tabbing to next box"]
["                            • To add additional clients, simply begin data entry on first WHITE row (Given Name) and tab to (Last Name). This will\n                          add rows automatically."]
[]
[]
[]
[]
[]
[]
["     "]
[]
["Providers WITH a case management system"]
["There may be an option to cut and paste data for providers who have a case management system that can"]
["1.       Ensure export contains same columns and data as described above"]
["2.       Export data to Excel"]
["3.       Copy data from export, and paste values from cell A11 in the Data tab"]
["4.       If the below pop-up appears, check the box and click OK"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["We will be working with these providers directly"]
[]
["Reports"]
["Provider Return Report"]
["• Data entered in the “Data” tab will aggregate and populate the provider return report"]
["• DO NOT SEND unencrypted client level data via email as this would be a breach of data security"]
["• Additional Comments: this section will have a limited amount of space that can be used and should be used to describe situations that are out of the normal.  "]
["   • Comments or rationale for “Other” selections"]
["      • EXAMPLE: of our 10 exits, 2 were exited for other reasons (indicate reason for exits)"]
["      • EXAMPLE: one of our young people were referred from Police"]
["   • FTE, Face to Face Hours, Offending or Breaching but still on service"]
["      • EXAMPLE: we are down by two FTE this month, recruitment is underway"]
["      • EXAMPLE: our Face to Face hours are really high for Whānau this month. We have been putting in more time with a complex family"]
["      • EXAMPLE: one of our Young People continues to have multiple minor breaches of bail, but we can see they are benefiting from the service. Let’s discuss"]
["   • Any other information you wish to discuss with the PfO advisor"]
["      • EXAMPLE: we have noticed we have a high proportion of Māori boys entering our services. We have begun a new service offering called “Tuakana”. It is innovative and seems to be really effective keeping our boys out of residences. Let’s discuss"]
[]
["Once the provider feels comfortable with the data in the Provider Return Report"]
["• Navigate to the top of the page"]
["• Click on “Output to email” (top left corner)"]
["• An email will be generated with a PDF attachment"]
["• This report will only contain aggregated data"]
["• Consult your PfO advisor to obtain the correct email address for submission"]
[]
[]
[]
[]
[]
[]
["• Click \"Output to email\" on the \"Provider return report\" tab"]

{"sheet":"Definitions","index":4,"n_rows":215,"n_cols":2,"rows_kept":215,"cut":false,"hidden":false,"merged":[[9,0,9,2],[10,0,10,2],[11,0,11,2],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[32,0,32,2],[40,0,40,2],[41,0,41,2],[42,0,42,2],[43,0,43,2],[44,0,44,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[66,0,66,2],[67,0,67,2],[68,0,68,2],[45,0,45,2],[46,0,46,2],[47,0,47,2],[48,0,48,2],[49,0,49,2],[50,0,50,2],[51,0,51,2],[52,0,52,2],[53,0,53,2],[54,0,54,2],[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,2],[59,0,59,2],[60,0,60,2],[61,0,61,2],[62,0,62,2],[63,0,63,2],[64,0,64,2],[65,0,65,2],[90,0,90,2],[91,0,91,2],[92,0,92,2],[69,0,69,2],[70,0,70,2],[71,0,71,2],[72,0,72,2],[73,0,73,2],[74,0,74,2],[75,0,75,2],[76,0,76,2],[77,0,77,2],[78,0,78,2],[79,0,79,2],[80,0,80,2],[81,0,81,2],[82,0,82,2],[83,0,83,2],[84,0,84,2],[85,0,85,2],[86,0,86,2],[87,0,87,2],[88,0,88,2],[89,0,89,2],[115,0,115,2],[116,0,116,2],[117,0,117,2],[93,0,93,2],[94,0,94,2],[95,0,95,2],[96,0,96,2],[97,0,97,2],[98,0,98,2],[99,0,99,2],[100,0,100,2],[101,0,101,2],[102,0,102,2],[103,0,103,2],[104,0,104,2],[105,0,105,2],[106,0,106,2],[107,0,107,2],[108,0,108,2],[109,0,109,2],[111,0,111,2],[112,0,112,2],[113,0,113,2],[114,0,114,2],[139,0,139,2],[140,0,140,2],[141,0,141,2],[118,0,118,2],[119,0,119,2],[120,0,120,2],[121,0,121,2],[122,0,122,2],[123,0,123,2],[124,0,124,2],[125,0,125,2],[126,0,126,2],[127,0,127,2],[128,0,128,2],[129,0,129,2],[130,0,130,2],[131,0,131,2],[132,0,132,2],[133,0,133,2],[134,0,134,2],[135,0,135,2],[136,0,136,2],[137,0,137,2],[138,0,138,2],[163,0,163,2],[164,0,164,2],[165,0,165,2],[142,0,142,2],[143,0,143,2],[144,0,144,2],[145,0,145,2],[146,0,146,2],[147,0,147,2],[148,0,148,2],[149,0,149,2],[150,0,150,2],[151,0,151,2],[152,0,152,2],[153,0,153,2],[154,0,154,2],[155,0,155,2],[156,0,156,2],[157,0,157,2],[158,0,158,2],[159,0,159,2],[160,0,160,2],[161,0,161,2],[162,0,162,2],[166,0,166,2],[167,0,167,2],[168,0,168,2],[169,0,169,2],[182,0,182,2],[183,0,183,2],[170,0,170,2],[171,0,171,2],[172,0,172,2],[173,0,173,2],[174,0,174,2],[175,0,175,2],[197,0,197,2],[198,0,198,2],[199,0,199,2],[184,0,184,2],[185,0,185,2],[186,0,186,2],[187,0,187,2],[176,0,176,2],[177,0,177,2],[178,0,178,2],[179,0,179,2],[180,0,180,2],[181,0,181,2],[188,0,188,2],[189,0,189,2],[190,0,190,2],[191,0,191,2],[192,0,192,2],[193,0,193,2],[194,0,194,2],[195,0,195,2],[196,0,196,2],[206,0,206,2],[207,0,207,2],[208,0,208,2],[210,0,210,2],[200,0,200,2],[201,0,201,2],[202,0,202,2],[203,0,203,2],[204,0,204,2],[205,0,205,2]]}
["Data Definitions and Notes"]
["DATA TAB"]
["· First Name"]
["      · Young Person's first name"]
["· Last Name"]
["      · Young Person's last name"]
["· CYRAS ID"]
["      · Oranga Tamariki identification number"]
["      · NOTE: Consists of numerical digits"]
["      · NOTE: The CYRAS ID can be obtained from a YJ site Social Worker"]
["· Oranga Tamariki status"]
["      ·Status for young person"]
["            · Youth Justice (e.g. 238(1b), 238(1d), etc…)"]
["            · SCaF - Services for Children & Families (related to the custody of OT e.g. shared, complete, 30day custody)"]
["            · Dual Status (Young person is associated with both Youth Justice and SCaF)"]
["            · Other (some other variation)"]
["· Ethnicity"]
["      · Young person primarily identifies as"]
["            · Māori"]
["            · Māori / Pacific"]
["            · Pacific"]
["            · NZ Euro & Other (NOTE: includes all other ethnicities)"]
["· Gender Identity"]
["      · Young Person primarily identifies as:"]
["            · Male"]
["            · Female"]
["            · Gender diverse"]
["· Date of Birth"]
["      · Date Young Person Born"]
["      · NOTE: template will return an error for birthdays older than 01/01/1990"]
["· Service Provided"]
["      · Defined Programme that is associated with one of the following Service Types."]
["            · Therapeutic Mentoring Programmes for young offenders"]
["            · Supervision with Activity Programmes for young offenders"]
["            · Supported Bail for young offenders"]
["            · Services to implement the whanau service plans developed at or after a Youth Justice Family Group Conference"]
["            · Community Youth Development, Structured Activity Programmes for young offenders"]
["            · Youth Court Supervised Programmes for young offenders"]
["            · Youth Inclusion Programme"]
["            · Therapeutic Parenting Programmes for young offenders who are soon to be parents or for parents of young offenders"]
["      · NOTE: If Young Person starts on one service, completes that services and begins another service, the Young Person should be entered twice (one for each service)"]
["      · EXAMPLE: if a YP begins a Supported Bail service, agrees FGC Plan or Court Order, is then discharged from the Supported Bail service, but continues on with a Supervision with Activity service"]
["· Referral Source"]
["      · Youth Justice Site (or other) arranged alphabetically:"]
["            · Police Youth Aid/Other"]
["            · Other community referral"]
["            · Auckland City YJ"]
["            · Christchurch East YJ"]
["            · Christchurch West YJ"]
["            · Hawkes Bay YJ"]
["            · Manurewa YJ"]
["            · North Harbour YJ"]
["            · Otahuhu YJ"]
["            · Otara YJ"]
["            · Palmerston North YJ"]
["            · Papakura YJ"]
["            · Rotorua YJ"]
["            · South Canterbury/Otago YJ"]
["            · Southland YJ"]
["            · Tairawhiti YJ"]
["            · Taranaki YJ"]
["            · Tauranga YJ"]
["            · Te Tai Tokerau YJ"]
["            · Upper South YJ"]
["            · Waikato/Hauraki YJ"]
["            · Waitakere YJ"]
["            · Wellington YJ"]
["            · Whanganui YJ"]
["· Date referral received"]
["      · NOTE: This may occur before or after first contact"]
["· Date defined programme start"]
["      · NOTE: the date the young person begins the defined programme. This date does not include preparation prior to the young person starting the defined programme. That data will be captured elsewhere."]
["· Date defined programme ends/date referral closes (DNS)"]
["      · NOTE: Did Not Start (DNS) when a referral is received, preparation activities have occurred, but for some reason the defined programme did not start for the young person."]
["· Reason for Exit"]
["      · Reason Young Person was discharged from the service by NGO, includes:"]
["            · Did not start"]
["            · Intervention complete, goals partially/fully met"]
["            · Reoffend - in custody"]
["            · Reoffend - change of legal status"]
["            · Disengaged"]
["            · Absconded"]
["            · Left area: planned"]
["            · Left area: unplanned"]
["            · Breach of bail condition - in custody"]
["            · Other"]
["· NEET Status on Exit"]
["      · NEET status is recorded on all Young People who exit the services (successfully or otherwise). This includes:"]
["            · Employment"]
["            · Education"]
["            · Training"]
["            · Not in education, employment or training"]
["            · Primary parental caregiver"]
["            · Unknown"]
["· Number of occurrences: YP offended/reoffended, but remained on defined programme"]
["      · Total number of occurrences that the Youth Worker or other core worker have become aware of, but where the young person remains on defined programme.  "]
["      · NOTE: This is an observation from Youth Workers or other core worker and should NOT be taken as the primary source of truth. Police will be engaged by Oranga Tamariki should they require confirmation of data."]
["      · NOTE: this information will be used to provide strengths-based reporting "]
["· Number of occurrences: YP breached conditions of bail, but remained on defined programme"]
["      · Total number of occurrences that the Youth Worker or other core worker have become aware of, but where the young person remains on defined programme.  "]
["      · NOTE: This is an observation from Youth Workers or other core worker and should NOT be taken as the primary source of truth. Police will be engaged by Oranga Tamariki should they require confirmation of data."]
["      · NOTE: this information will be used to provide strengths-based reporting "]
[]
["PROVIDER RETURN REPORT TAB"]
["Provider Level Reporting"]
["· Output to email"]
["      · Generates and email with our reporting template attached"]
["· Provider Name"]
["      · Auto Populates"]
["· Reporting period"]
["      · Auto Populates"]
["      · Is defined at last day of reporting period"]
["· Referral Source"]
["      · Counts all new referrals during the reporting period; regardless if they start the defined programme or not"]
["· Oranga Tamariki Status"]
["      · Status for young person associated with new referrals"]
["            · Youth Justice (e.g. 238(1b), 238(1d), etc…)"]
["            · SCaF - Services for Children & Families (related to the custody of OT e.g. shared, complete, 30day custody)"]
["            · Dual Status (Young person is associated with both Youth Justice and SCaF)"]
["            · Other (some other variation)"]
["· Referrals received pending defined programme start"]
["      · Total number of referrals received, but where the young person has not started the defined programme within the reporting period.  "]
["· Young people currently engaged"]
["      · Young people who are currently engaged in defined programme as at end of reporting month"]
["· Exited this month"]
["      · Young people who were on the defined programme and exited within the reporting period"]
["      · This does not include young people who did not start the programme, but the referral was closed."]
["· Successful exits"]
["      · Total number of young people who were on the defined programme and exited successfully"]
["· Unsuccessful exits"]
["      · Total number of young people who were on the defined programme and exited unsuccessful"]
["· Exit Reasons and number of young people"]
["      · Provides reason for exits and the number who exited the defined programme for the given reason."]
["      · Includes number of did not starts"]
["      · Describes successful exits from unsuccessful exits   "]
["· NEET status on Exit"]
["      · Number of young people who were on or exited from a defined programme by need status"]
["      · Includes primary parental care giver (e.g. young person is not in education, training or employment, is the primary care giver for a dependant, and is supported by partner or some other person/benefit)"]
["      · Includes unknown, when young person did not start programme, or the NEET status is unknown."]
["· Engaged during month"]
["      · By service code number of young people: number of young people currently involved in the defined programme and exited with in the reporting month."]
["      · YP offended/reoffended but remained on defined programme: Total number of occurrences that the Youth Worker or other NGO staff have become aware of, but where the young person remains on defined programme.  "]
["      · YP breached conditions of bail but remained on defined programme: Total number of occurrences that the Youth Worker or other NGO staff have become aware of, but where the young person remains on defined programme.  "]
["            · This is for Supported Bail and REMHOME-Bail only"]
["· Age, Gender identity, Ethnicity"]
["      · Number of young people who were on, or exited, from a defined programme during reporting month"]
["· FTE"]
["      · Number of Youth Worker (as core worker) FTE either combined or dedicated to a specific service type"]
["      · Combined: Youth workers (or other core worker) who may be working across multiple service types"]
["      · By service type: youth workers (or other core worker) who are ONLY engaged in the given service type"]
["· Comments: area for provider to leave comments."]
["      · Alt Enter: this will take you to a new line."]
["      · Hitting enter will take out of this comment box"]
["      · To get back to the comment box you can double click where you would like to add data."]
["Service Level Reporting"]
["· Provider Name"]
["      · Auto Populates"]
["· Service:"]
["      · Select service your wishing to review  "]
["            · Therapeutic Mentoring Programmes for young offenders"]
["            · Supervision with Activity Programmes for young offenders"]
["            · Supported Bail for young offenders"]
["            · Services to implement the whanau service plans developed at or after a Youth Justice Family Group Conference"]
["            · Community Youth Development, Structured Activity Programmes for young offenders"]
["            · Youth Court Supervised Programmes for young offenders"]
["            · Youth Inclusion Programme"]
["            · Therapeutic Parenting Programmes for young offenders who are soon to be parents or for parents of young offenders"]
["· Referral Source"]
["      · Counts all new referrals during the reporting period; regardless if they start the defined programme or not"]
["· Oranga Tamariki Status"]
["      · Status for young person associated with new referrals"]
["            · Youth Justice (e.g. 238(1b), 238(1d), etc…)"]
["            · SCaF - Services for Children & Families (related to the custody of OT e.g. shared, complete, 30day custody)"]
["            · Dual Status (Young person is associated with both Youth Justice and SCaF)"]
["            · Other (some other variation)"]
["· Referrals received pending defined programme start"]
["      · Total number of referrals received, but where the young person has not started the defined programme within the reporting period.  "]
["· Young people currently engaged"]
["      · Young people who are currently engaged in defined programme as at end of reporting month"]
["· Exited this month"]
["      · Young people who were on the defined programme and exited within the reporting period"]
["      · This does not include young people who did not start the programme, but the referral was closed."]
["· Successful exits"]
["      · Total number of young people who were on the defined programme and exited successfully"]
["· Unsuccessful exits"]
["      · Total number of young people who were on the defined programme and exited unsuccessful"]
["· Exit Reasons and number of young people"]
["      · Provides reason for exits and the number who exited the defined programme for the given reason."]
["      · Includes number of did not starts"]
["      · Describes successful exits from unsuccessful exits   "]
["· NEET status on Exit"]
["      · Number of young people who were on or exited from a defined programme by need status"]
["      · Includes primary parental care giver (e.g. young person is not in education, training or employment, is the primary care giver for a dependant, and is supported by partner or some other person/benefit)"]
["      · Includes unknown, when young person did not start programme, or the NEET status is unknown."]
["· Engaged during month"]
["      · By service description, young people: number of young people currently involved in the defined programme and exited with in the reporting month."]
["      · YP offended/reoffended but remained on defined programme: Total number of occurrences that the Youth Worker or other core worker have become aware of, but where the young person remains on defined programme.  "]
["      · YP breached conditions of bail but remained on defined programme: Total number of occurrences that the Youth Worker or other core worker have become aware of, but where the young person remains on defined programme.  "]
["            · This is for Supported Bail only"]
["· Age, Gender identity, Ethnicity"]
["      · Number of young people who were on, or exited, from a defined programme during reporting month"]
["· Programme started before referral received"]
["      · Average number of days YP referred in report month (where programme started before referral)"]
["· Period from referral received to defined programme start"]
["      · Average number of days YP who started programme in report month"]
["· Period form referral received to DNS decision"]
["      · Average number of days YP with exit date (with DNS decision) in report month"]
["· Length of time on programme"]
["      · Average number of days YP with exit date (and not DNS decision) in report month"]
[]
["FAC TAB"]
["Data entered into FAC ","Interpretation   "]
["Total number of Young People accepted onto the programme","All young people with a defined programme start date in the reporting month"]
["Number of FTE allocated to service","number of FTE allocated to serivce (e.g. only includes youth worker as the core worker)"]
["Number of FTE allocated to service","Number of FTE allocated to service (e.g. only includes youth worker as the core worker)"]

{"sheet":"FAC","index":5,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,26,3],[25,0,25,3],[22,0,22,3],[23,0,23,3],[20,0,20,3],[10,0,10,3],[11,0,11,3],[7,0,7,3],[6,0,6,3],[19,0,19,3],[16,0,16,3],[17,0,17,3],[14,0,14,3],[13,0,13,3],[0,1,0,5],[1,1,1,5],[3,0,3,3],[4,0,4,3],[9,0,9,3]]}
["Provider",{"$f":"IF(ProviderName=\"Enter name\",\"Please enter provider name in the Data tab\",ProviderName)","v":"Provider Example"}]
["Reporting period",{"$f":"ReportMonth&\" \"&ReportYear","v":"July 2022"}]
[]
["YJTPMEN",null,null,null,"Value"]
["Total number of Young People accepted onto the programme (Primary)",null,null,null,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\">=\"&MonthStart,Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Code],\"YJTPMEN\")","v":0}]
[]
["SWAP",null,null,null,"Value"]
["Total number of Young People accepted onto the programme (Primary)",null,null,null,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\">=\"&MonthStart,Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Code],\"SWAP\")","v":0}]
[]
["SUPBAIL",null,null,null,"Value"]
["Number of FTE allocated to SUPBAIL service (Primary)",null,null,null,{"$f":"Data!G5","v":0}]
["Total number of Young People accepted onto the programme (Secondary)",null,null,null,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\">=\"&MonthStart,Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Code],\"SUPBAIL\")","v":0}]
[]
["YJPTPNT",null,null,null,"Value"]
["Total number of Young People accepted onto the programme (Primary)",null,null,null,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\">=\"&MonthStart,Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Code],\"YJPTPNT\")","v":0}]
[]
["YJSAP",null,null,null,"Value"]
["Total number of Young People accepted onto the programme (Primary)",null,null,null,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\">=\"&MonthStart,Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Code],\"YJSAP\")","v":0}]
[]
["YJYCSP",null,null,null,"Value"]
["Total number of Young People accepted onto the programme (Primary)",null,null,null,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\">=\"&MonthStart,Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Code],\"YJYCSP\")","v":0}]
[]
["YJYIP",null,null,null,"Value"]
["Total number of Young People accepted onto the programme (Primary)",null,null,null,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\">=\"&MonthStart,Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Code],\"YJYIP\")","v":0}]
[]
["YDPPLAN",null,null,null,"Value"]
["Total number of Young People accepted onto the programme (Primary)",null,null,null,{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\">=\"&MonthStart,Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Code],\"YDPPLAN\")","v":0}]

{"sheet":"Export","index":6,"n_rows":3,"n_cols":187,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,176,0,184],[0,95,0,118],[0,119,0,142],[0,2,0,6],[0,7,0,16],[0,17,0,22],[0,23,0,46],[0,47,0,70],[0,71,0,94],[0,143,0,145],[0,146,0,149],[0,150,0,158],[0,159,0,166],[0,167,0,174]]}
[null,null,"General counts",null,null,null,null,"Exits",null,null,null,null,null,null,null,null,null,"NEET status on exit",null,null,null,null,null,"New referrals by site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YJ referrals by site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCaF referrals by site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dual status referrals by site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other referrals by site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gender Identity",null,null,"Ethnicity",null,null,null,"Age",null,null,null,null,null,null,null,null,"Young People",null,null,null,null,null,null,null,"YP offended/reoffended, but remained on service",null,null,null,null,null,null,null,"Number of occurrences: YP breached conditions of bail, but remained on service","FTE",null,null,null,null,null,null,null,null,"Comments","Version"]
["Provider name","Report month","Referrals received pending defined programme start","Young people currently engaged","Exited this month","Successful exits","Unsuccessful exits","Did not start","Intervention complete, goals partially/fully met","Left area: planned","Reoffend - in custody","Reoffend - change of legal status","Disengaged","Absconded","Left area: unplanned","Breach of bail condition - in custody","Other","Employment","Education","Training","Not in education, employment or training","Primary parental caregiver","Unknown","New - Police Youth Aid/Other","New - Other community referral","New - Auckland City YJ","New - Christchurch East YJ","New - Christchurch West YJ","New - Hawkes Bay YJ","New - Manurewa YJ","New - North Harbour YJ","New - Otahuhu YJ","New - Otara YJ","New - Palmerston North YJ","New - Papakura YJ","New - Rotorua YJ","New - South Canterbury/Otago YJ","New - Southland YJ","New - Tairawhiti YJ","New - Taranaki YJ","New - Tauranga YJ","New - Te Tai Tokerau YJ","New - Upper South YJ","New - Waikato/Hauraki YJ","New - Waitakere YJ","New - Wellington YJ","New - Whanganui YJ","YJ - Police Youth Aid/Other","YJ - Other community referral","YJ - Auckland City YJ","YJ - Christchurch East YJ","YJ - Christchurch West YJ","YJ - Hawkes Bay YJ","YJ - Manurewa YJ","YJ - North Harbour YJ","YJ - Otahuhu YJ","YJ - Otara YJ","YJ - Palmerston North YJ","YJ - Papakura YJ","YJ - Rotorua YJ","YJ - South Canterbury/Otago YJ","YJ - Southland YJ","YJ - Tairawhiti YJ","YJ - Taranaki YJ","YJ - Tauranga YJ","YJ - Te Tai Tokerau YJ","YJ - Upper South YJ","YJ - Waikato/Hauraki YJ","YJ - Waitakere YJ","YJ - Wellington YJ","YJ - Whanganui YJ","SCaF - Police Youth Aid/Other","SCaF - Other community referral","SCaF - Auckland City YJ","SCaF - Christchurch East YJ","SCaF - Christchurch West YJ","SCaF - Hawkes Bay YJ","SCaF - Manurewa YJ","SCaF - North Harbour YJ","SCaF - Otahuhu YJ","SCaF - Otara YJ","SCaF - Palmerston North YJ","SCaF - Papakura YJ","SCaF - Rotorua YJ","SCaF - South Canterbury/Otago YJ","SCaF - Southland YJ","SCaF - Tairawhiti YJ","SCaF - Taranaki YJ","SCaF - Tauranga YJ","SCaF - Te Tai Tokerau YJ","SCaF - Upper South YJ","SCaF - Waikato/Hauraki YJ","SCaF - Waitakere YJ","SCaF - Wellington YJ","SCaF - Whanganui YJ","Dual status - Police Youth Aid/Other","Dual status - Other community referral","Dual status - Auckland City YJ","Dual status - Christchurch East YJ","Dual status - Christchurch West YJ","Dual status - Hawkes Bay YJ","Dual status - Manurewa YJ","Dual status - North Harbour YJ","Dual status - Otahuhu YJ","Dual status - Otara YJ","Dual status - Palmerston North YJ","Dual status - Papakura YJ","Dual status - Rotorua YJ","Dual status - South Canterbury/Otago YJ","Dual status - Southland YJ","Dual status - Tairawhiti YJ","Dual status - Taranaki YJ","Dual status - Tauranga YJ","Dual status - Te Tai Tokerau YJ","Dual status - Upper South YJ","Dual status - Waikato/Hauraki YJ","Dual status - Waitakere YJ","Dual status - Wellington YJ","Dual status - Whanganui YJ","Other - Police Youth Aid/Other","Other - Other community referral","Other - Auckland City YJ","Other - Christchurch East YJ","Other - Christchurch West YJ","Other - Hawkes Bay YJ","Other - Manurewa YJ","Other - North Harbour YJ","Other - Otahuhu YJ","Other - Otara YJ","Other - Palmerston North YJ","Other - Papakura YJ","Other - Rotorua YJ","Other - South Canterbury/Otago YJ","Other - Southland YJ","Other - Tairawhiti YJ","Other - Taranaki YJ","Other - Tauranga YJ","Other - Te Tai Tokerau YJ","Other - Upper South YJ","Other - Waikato/Hauraki YJ","Other - Waitakere YJ","Other - Wellington YJ","Other - Whanganui YJ","Male","Female","Gender Diverse ","Māori","Māori/Pacific","Pacific","NZ Euro & Other","Up to 10","11","12","13","14","15","16","17","18+","YJTPMEN - YP","SWAP - YP","SUPBAIL - YP","YJPTPNT - YP","YJSAP - YP","YJYCSP - YP","YJYIP - YP","YDPPLAN - YP","YJTPMEN - Offended","SWAP - Offended","SUPBAIL - Offended","YJPTPNT - Offended","YJSAP - Offended","YJYCSP - Offended","YJYIP - Offended","YDPPLAN - Offended","SUPBAIL - Breached","Combined - FTE","YJTPMEN - FTE","SWAP - FTE","SUPBAIL - FTE","YJPTPNT - FTE","YJSAP - FTE","YJYCSP - FTE","YJYIP - FTE","YDPPLAN - FTE","Comments","Report version"]
[{"$f":"ProviderName","v":"Provider Example"},{"$f":"DATEVALUE(\"1 \"&ReportMonth&\" \"&ReportYear)","v":"2022-07-01"},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">\"&0,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],0,Data[Fixed Date defined programme starts],0)\n+COUNTIFS(Data[Fixed Date referral received],\">\"&0,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],0,Data[Fixed Date defined programme starts],\">\"&MonthEnd)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\">\"&MonthEnd)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"\",Data[Fixed Date defined programme starts],\">\"&0)\n+COUNTIFS(Data[Fixed Date defined programme starts],\"<=\"&MonthEnd,Data[Fixed Date defined programme ends/date referral closed (DNS)],0,Data[Fixed Date defined programme starts],\">\"&0)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],\"<>Did not start\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Complete],TRUE)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Complete],FALSE)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],H$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],I$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],J$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],K$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],L$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],M$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],N$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],O$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],P$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[Reason for exit],Q$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],R$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],S$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],T$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],U$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],V$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date defined programme ends/date referral closed (DNS)],\">=\"&MonthStart,Data[Fixed Date defined programme ends/date referral closed (DNS)],\"<=\"&MonthEnd,Data[NEET status on exit],W$2)","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(X$2,LEN(X$2)-FIND(\" - \",X$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(Y$2,LEN(Y$2)-FIND(\" - \",Y$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(Z$2,LEN(Z$2)-FIND(\" - \",Z$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AA$2,LEN(AA$2)-FIND(\" - \",AA$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AB$2,LEN(AB$2)-FIND(\" - \",AB$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AC$2,LEN(AC$2)-FIND(\" - \",AC$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AD$2,LEN(AD$2)-FIND(\" - \",AD$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AE$2,LEN(AE$2)-FIND(\" - \",AE$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AF$2,LEN(AF$2)-FIND(\" - \",AF$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AG$2,LEN(AG$2)-FIND(\" - \",AG$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AH$2,LEN(AH$2)-FIND(\" - \",AH$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AI$2,LEN(AI$2)-FIND(\" - \",AI$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AJ$2,LEN(AJ$2)-FIND(\" - \",AJ$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AK$2,LEN(AK$2)-FIND(\" - \",AK$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AL$2,LEN(AL$2)-FIND(\" - \",AL$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AM$2,LEN(AM$2)-FIND(\" - \",AM$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AN$2,LEN(AN$2)-FIND(\" - \",AN$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AO$2,LEN(AO$2)-FIND(\" - \",AO$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AP$2,LEN(AP$2)-FIND(\" - \",AP$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AQ$2,LEN(AQ$2)-FIND(\" - \",AQ$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AR$2,LEN(AR$2)-FIND(\" - \",AR$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AS$2,LEN(AS$2)-FIND(\" - \",AS$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AT$2,LEN(AT$2)-FIND(\" - \",AT$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AU$2,LEN(AU$2)-FIND(\" - \",AU$2)-2))","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AV$2,LEN(AV$2)-FIND(\" - \",AV$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AW$2,LEN(AW$2)-FIND(\" - \",AW$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AX$2,LEN(AX$2)-FIND(\" - \",AX$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AY$2,LEN(AY$2)-FIND(\" - \",AY$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(AZ$2,LEN(AZ$2)-FIND(\" - \",AZ$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BA$2,LEN(BA$2)-FIND(\" - \",BA$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BB$2,LEN(BB$2)-FIND(\" - \",BB$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BC$2,LEN(BC$2)-FIND(\" - \",BC$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BD$2,LEN(BD$2)-FIND(\" - \",BD$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BE$2,LEN(BE$2)-FIND(\" - \",BE$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BF$2,LEN(BF$2)-FIND(\" - \",BF$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BG$2,LEN(BG$2)-FIND(\" - \",BG$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BH$2,LEN(BH$2)-FIND(\" - \",BH$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BI$2,LEN(BI$2)-FIND(\" - \",BI$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BJ$2,LEN(BJ$2)-FIND(\" - \",BJ$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BK$2,LEN(BK$2)-FIND(\" - \",BK$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BL$2,LEN(BL$2)-FIND(\" - \",BL$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BM$2,LEN(BM$2)-FIND(\" - \",BM$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BN$2,LEN(BN$2)-FIND(\" - \",BN$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BO$2,LEN(BO$2)-FIND(\" - \",BO$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BP$2,LEN(BP$2)-FIND(\" - \",BP$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BQ$2,LEN(BQ$2)-FIND(\" - \",BQ$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BR$2,LEN(BR$2)-FIND(\" - \",BR$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BS$2,LEN(BS$2)-FIND(\" - \",BS$2)-2),Data[Oranga Tamariki status],\"Youth Justice\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BT$2,LEN(BT$2)-FIND(\" - \",BT$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BU$2,LEN(BU$2)-FIND(\" - \",BU$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BV$2,LEN(BV$2)-FIND(\" - \",BV$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BW$2,LEN(BW$2)-FIND(\" - \",BW$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BX$2,LEN(BX$2)-FIND(\" - \",BX$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BY$2,LEN(BY$2)-FIND(\" - \",BY$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(BZ$2,LEN(BZ$2)-FIND(\" - \",BZ$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CA$2,LEN(CA$2)-FIND(\" - \",CA$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CB$2,LEN(CB$2)-FIND(\" - \",CB$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CC$2,LEN(CC$2)-FIND(\" - \",CC$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CD$2,LEN(CD$2)-FIND(\" - \",CD$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CE$2,LEN(CE$2)-FIND(\" - \",CE$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CF$2,LEN(CF$2)-FIND(\" - \",CF$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CG$2,LEN(CG$2)-FIND(\" - \",CG$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CH$2,LEN(CH$2)-FIND(\" - \",CH$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CI$2,LEN(CI$2)-FIND(\" - \",CI$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CJ$2,LEN(CJ$2)-FIND(\" - \",CJ$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CK$2,LEN(CK$2)-FIND(\" - \",CK$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CL$2,LEN(CL$2)-FIND(\" - \",CL$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CM$2,LEN(CM$2)-FIND(\" - \",CM$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CN$2,LEN(CN$2)-FIND(\" - \",CN$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CO$2,LEN(CO$2)-FIND(\" - \",CO$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CP$2,LEN(CP$2)-FIND(\" - \",CP$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CQ$2,LEN(CQ$2)-FIND(\" - \",CQ$2)-2),Data[Oranga Tamariki status],\"SCaF\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CR$2,LEN(CR$2)-FIND(\" - \",CR$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CS$2,LEN(CS$2)-FIND(\" - \",CS$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CT$2,LEN(CT$2)-FIND(\" - \",CT$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CU$2,LEN(CU$2)-FIND(\" - \",CU$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CV$2,LEN(CV$2)-FIND(\" - \",CV$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CW$2,LEN(CW$2)-FIND(\" - \",CW$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CX$2,LEN(CX$2)-FIND(\" - \",CX$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CY$2,LEN(CY$2)-FIND(\" - \",CY$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(CZ$2,LEN(CZ$2)-FIND(\" - \",CZ$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DA$2,LEN(DA$2)-FIND(\" - \",DA$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DB$2,LEN(DB$2)-FIND(\" - \",DB$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DC$2,LEN(DC$2)-FIND(\" - \",DC$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DD$2,LEN(DD$2)-FIND(\" - \",DD$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DE$2,LEN(DE$2)-FIND(\" - \",DE$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DF$2,LEN(DF$2)-FIND(\" - \",DF$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DG$2,LEN(DG$2)-FIND(\" - \",DG$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DH$2,LEN(DH$2)-FIND(\" - \",DH$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DI$2,LEN(DI$2)-FIND(\" - \",DI$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DJ$2,LEN(DJ$2)-FIND(\" - \",DJ$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DK$2,LEN(DK$2)-FIND(\" - \",DK$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DL$2,LEN(DL$2)-FIND(\" - \",DL$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DM$2,LEN(DM$2)-FIND(\" - \",DM$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DN$2,LEN(DN$2)-FIND(\" - \",DN$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DO$2,LEN(DO$2)-FIND(\" - \",DO$2)-2),Data[Oranga Tamariki status],\"Dual status\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DP$2,LEN(DP$2)-FIND(\" - \",DP$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DQ$2,LEN(DQ$2)-FIND(\" - \",DQ$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DR$2,LEN(DR$2)-FIND(\" - \",DR$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DS$2,LEN(DS$2)-FIND(\" - \",DS$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DT$2,LEN(DT$2)-FIND(\" - \",DT$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DU$2,LEN(DU$2)-FIND(\" - \",DU$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DV$2,LEN(DV$2)-FIND(\" - \",DV$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DW$2,LEN(DW$2)-FIND(\" - \",DW$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DX$2,LEN(DX$2)-FIND(\" - \",DX$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DY$2,LEN(DY$2)-FIND(\" - \",DY$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(DZ$2,LEN(DZ$2)-FIND(\" - \",DZ$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EA$2,LEN(EA$2)-FIND(\" - \",EA$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EB$2,LEN(EB$2)-FIND(\" - \",EB$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EC$2,LEN(EC$2)-FIND(\" - \",EC$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(ED$2,LEN(ED$2)-FIND(\" - \",ED$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EE$2,LEN(EE$2)-FIND(\" - \",EE$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EF$2,LEN(EF$2)-FIND(\" - \",EF$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EG$2,LEN(EG$2)-FIND(\" - \",EG$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EH$2,LEN(EH$2)-FIND(\" - \",EH$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EI$2,LEN(EI$2)-FIND(\" - \",EI$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EJ$2,LEN(EJ$2)-FIND(\" - \",EJ$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EK$2,LEN(EK$2)-FIND(\" - \",EK$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EL$2,LEN(EL$2)-FIND(\" - \",EL$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Fixed Date referral received],\">=\"&MonthStart,Data[Fixed Date referral received],\"<=\"&MonthEnd,Data[Referral source],RIGHT(EM$2,LEN(EM$2)-FIND(\" - \",EM$2)-2),Data[Oranga Tamariki status],\"Other\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Gender identity],\"Male\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Gender identity],\"Female\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Gender identity],\"Gender Diverse\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Ethnicity],\"Māori\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Ethnicity],\"Māori/Pacific\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Ethnicity],\"Pacific\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Ethnicity],\"NZ Euro & Other\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],\"<=\"&10)","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],11)","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],12)","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],13)","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],14)","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],15)","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],16)","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],17)","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Current age],\">=\"&18)","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Code],\"YJTPMEN\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Code],\"SWAP\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Code],\"SUPBAIL\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Code],\"YJPTPNT\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Code],\"YJSAP\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Code],\"YJYCSP\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Code],\"YJYIP\")","v":0},{"$f":"COUNTIFS(Data[Active this month],TRUE,Data[Code],\"YDPPLAN\")","v":0},{"$f":"IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YJTPMEN\"),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YJTPMEN\"),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Code],\"YJTPMEN\"),\" YP)\"),\"\")","v":""},{"$f":"IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"SWAP\"),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"SWAP\"),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Code],\"SWAP\"),\" YP)\"),\"\")","v":""},{"$f":"IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"SUPBAIL\"),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"SUPBAIL\"),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Code],\"SUPBAIL\"),\" YP)\"),\"\")","v":""},{"$f":"IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YJPTPNT\"),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YJPTPNT\"),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Code],\"YJPTPNT\"),\" YP)\"),\"\")","v":""},{"$f":"IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YJSAP\"),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YJSAP\"),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Code],\"YJSAP\"),\" YP)\"),\"\")","v":""},{"$f":"IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YJYCSP\"),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YJYCSP\"),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Code],\"YJYCSP\"),\" YP)\"),\"\")","v":""},{"$f":"IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YJYIP\"),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YJYIP\"),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Code],\"YJYIP\"),\" YP)\"),\"\")","v":""},{"$f":"IF(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YDPPLAN\"),_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"YDPPLAN\"),\" (\",COUNTIFS(Data[Number of occurrences: YP offended/reoffended, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Code],\"YDPPLAN\"),\" YP)\"),\"\")","v":""},{"$f":"IF(SUMIFS(Data[Number of occurrences: YP breached conditions of bail, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"SUPBAIL\")>0,_xlfn.CONCAT(SUMIFS(Data[Number of occurrences: YP breached conditions of bail, but remained on defined programme],Data[Active this month],TRUE,Data[Code],\"SUPBAIL\"),\" (\",COUNTIFS(Data[Number of occurrences: YP breached conditions of bail, but remained on defined programme],\">\"&0,Data[Active this month],TRUE,Data[Code],\"SUPBAIL\"),\" YP)\"),\"\")","v":""},{"$f":"Data!G2","v":0},{"$f":"Data!G3","v":0},{"$f":"Data!G4","v":0},{"$f":"Data!G5","v":0},{"$f":"Data!G6","v":0},{"$f":"Data!G7","v":0},{"$f":"Data!G8","v":0},{"$f":"Data!G9","v":0},{"$f":"Data!G10","v":0},{"$f":"Comments","v":0},{"$f":"ReportVersion","v":1.5}]