{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["MainMenu","Services","AveHours","Worker Costs_Hours","Proposed Schedule","Schedule","References"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":14,"comments":3,"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":"MainMenu","index":0,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,0,3,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Services Grid"]
[null,null,null,"Click here to view the services grid"]
[]
[]
[]
[]
[null,null,null,"Average Hours"]
[null,null,null,"Click here to enter or update your affiliate's average hours"]
[]
[]
[]
[]
[null,null,null,"Worker Info"]
[null,null,null,"Click here to enter or update caseworker info (cost and hours)"]
[]
[]
[]
[]
[null,null,null,"Proposed Schedule"]
[null,null,null,"Click here to view the Proposed Schedule"]
[null,null,null,{"$f":"IF(AND(AveHours!D27<>\"\",'Worker Costs_Hours'!G14=\"\"),\"**The Average Hours and Worker Info must be completed first**\",IF(AveHours!D27<>\"\",\"**The Average Hours must be completed first**\",IF('Worker Costs_Hours'!G14=\"\",\"**The Worker Info must be completed first**\",\"\")))","v":"**The Average Hours and Worker Info must be completed first**"}]
[]
[]
[]
[null,null,null,"Schedule"]
[null,null,null,"Click here to view and update the schedule"]
[null,null,null,{"$f":"IF(AND(AveHours!D27<>\"\",'Worker Costs_Hours'!G14=\"\"),\"**The Average Rate and Worker Info must be completed first**\",IF(AveHours!D27<>\"\",\"**The Average Rate must be completed first**\",IF('Worker Costs_Hours'!G14=\"\",\"**The Worker Info must be completed first**\",\"\")))","v":"**The Average Rate and Worker Info must be completed first**"}]

{"sheet":"Services","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Child Services"]
[null,null,"Service Name","FY 18/19 Service Rates","FY 18/19 Days to Complete","FY 19/20 Service Rates","FY 19/20 Days to Complete","FY 20/21 Service Rates","FY 20/21 Days to Complete","*FY 21/22 Service Rates","*FY 21/22 Days to Complete","*FY 22/23 Service Rates","*FY 22/23 Days to Complete"]
[null,null,"Adoption Finalization Extension",1600,120,1475,120,1200,120,1250,120,{"$f":"J5","v":1250},{"$f":"K5","v":120}]
[null,null,"Child Preparation",2600,180,2900,180,2900,180,2900,180,{"$f":"J6","v":2900},{"$f":"K6","v":180}]
[null,null,"Child Profile",1900,90,1800,90,2100,90,2100,90,2100,90]
[null,null,"Child Profile Addendum",500,90,500,90,1350,90,1600,90,1600,90]
[null,null,"Child Specific Recruitment",1850,180,3150,180,2800,180,2800,180,2800,180]
[null,null,"Finalization",3200,240,2950,240,2250,240,2400,240,2400,240]
[null,null,"Placement",2700,"n/a",2700,"n/a",1950,"n/a",2300,"n/a",2300,"n/a"]
[]
[null,null,"Family Services"]
[null,null,"Service Name","FY 18/19 Service Rates","FY 18/19 Days to Complete","FY 19/20 Service Rates","FY 19/20 Days to Complete","FY 20/21 Service Rates","FY 20/21 Days to Complete","*FY 21/22 Service Rates","*FY 21/22 Days to Complete","*FY 22/23 Service Rates","*FY 22/23 Days to Complete"]
[null,null,"Family Profile/Preparation",2800,120,2400,120,2700,120,2950,120,{"$f":"J15","v":2950},{"$f":"K15","v":120}]
[null,null,"Family Profile/Preparation Addendum",500,120,500,120,1450,120,1650,120,{"$f":"J16","v":1650},{"$f":"K16","v":120}]
[null,null,"Post-permanency Advocacy/Assessment",500,30,500,30,500,30,500,30,500,30]
[null,null,"Post-permanency Advocacy/Case Management",500,30,500,30,500,30,500,30,500,30]
[null,null,"Post-permanency: Support Group",250,90,250,90,250,90,250,90,250,90]
[null,null,"Post-permanency: Respite",300,30,300,30,300,30,300,30,300,30]
[null,null,"*Tentative"]

{"sheet":"AveHours","index":2,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[[4,2,4,7],[3,2,3,7],[26,3,26,5],[4,9,4,15],[9,3,17,3],[19,2,20,7],[5,2,6,7],[18,9,19,11],[20,9,22,15],[26,9,26,15],[24,9,24,15]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Your affiliate's Cost-Time report:"]
[]
[]
[]
[null,null,null,"Affiliate","Benchmark Type","Average Time"]
[null,null,null,"Your Affiliate","Adoption Finalization Extension"]
[null,null,null,null,"Child Preparation"]
[null,null,null,null,"Child Profile"]
[null,null,null,null,"Child Profile Addendum"]
[null,null,null,null,"Child Specific Recruitment"]
[null,null,null,null,"Family Profile/Preparation or ARFP"]
[null,null,null,null,"Family Profile/Preparation or ARFP Addendum"]
[null,null,null,null,"Finalization"]
[null,null,null,null,"Placement"]
[null,null,null,null,null,null,null,null,null,"Post-permanency basis:"]
[]
[null,null,null,null,null,null,null,null,null,"To automatically populate the state's average times, choose Statewide. Otherwise, choose Manual entry."]
[]
[null,null,null,null,"Post-permanency Advocate / Case Management"]
[null,null,null,null,"Post-permanency Case Assessment"]
[null,null,null,null,"Post-permanency: Respite"]
[null,null,null,null,"Post-permanency: Support Group",null,null,null,null,"*Calculated from the CY 2020 Cost-Time Report."]
[null,null,null,{"$f":"IF(COUNTA(F10:F26)<13,\"**Please complete each of the yellow fields above**\",\"\")","v":"**Please complete each of the yellow fields above**"}]

{"sheet":"Worker Costs_Hours","index":3,"n_rows":30,"n_cols":26,"rows_kept":30,"cut":false,"hidden":true,"merged":[[18,1,18,9],[19,1,19,4],[19,6,19,9],[1,1,1,9],[3,1,3,4],[3,6,3,9],[2,1,2,9],[17,4,17,6],[17,8,17,10]]}
[]
[null,"Cumulative Worker Cost and Hours"]
[null,{"$f":"IF(ISERROR(MATCH(0,A:A,0)),\"\",\"**Please complete all required fields for Worker \" & (MATCH(0,A:A,0)-2)/15 & \"**\")","v":"**Please complete all required fields for Worker 1**"}]
[null,"Adoption Worker Costs",null,null,null,null,"Adoption Worker Hours"]
[]
[null,"Salary",null,null,{"$f":"IF(B3<>\"\",\"\",SUM(O:O))","v":""},null,"Weeks",null,null,{"$f":"IF(B3<>\"\",\"\",SUM(T:T))","v":""}]
[null,"Taxes/benefits",null,{"$f":"IF(B3<>\"\",\"\",E7/E6)","v":""},{"$f":"IF(B3<>\"\",\"\",SUM(P:P))","v":""},null,"Hours/Week",null,null,{"$f":"IF(B3<>\"\",\"\",SUM(U:U))","v":""}]
[null,"Travel",null,null,{"$f":"IF(B3<>\"\",\"\",SUM(Q:Q))","v":""},null,"Total Hours",null,null,{"$f":"IF(B3<>\"\",\"\",SUM(V:V))","v":""}]
[null,"Overhead Rate",null,{"$f":"IF(B3<>\"\",\"\",E9/(SUM(E6:E8)))","v":""},{"$f":"IF(B3<>\"\",\"\",SUM(R:R))","v":""},null,"Less PTO","(days/yr)",{"$f":"IF(B3<>\"\",\"\",SUM(W:W))","v":""},{"$f":"IF(B3<>\"\",\"\",SUM(X:X))","v":""}]
[null,"Variance",null,{"$f":"IF(B3<>\"\",\"\",E10/(SUM(E6:E9)))","v":""},{"$f":"IF(B3<>\"\",\"\",SUM(S:S))","v":""},null,"Less NPH","(hrs/week)",{"$f":"IF(B3<>\"\",\"\",SUM(Y:Y))","v":""},{"$f":"IF(B3<>\"\",\"\",SUM(Z:Z))","v":""}]
[null,"Total Cost",null,null,{"$f":"SUM(E6:E10)","v":0},null,"Total Available Hours",null,null,{"$f":"IF(OR(J6=\"\",J7=\"\"),\"\",SUM(J8:J10))","v":""},"per Year"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J11=\"\",\"\",J11/12)","v":""},"per Month"]
[]
[null,null,null,null,null,"Minimum Desired Rate per Hour:",{"$f":"IF(OR(E6=\"\",D7=\"\",E8=\"\",D9=\"\",D10=\"\",J6=\"\",J7=\"\",I9=\"\",I10=\"\"),\"\",E11/J11)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salary","Taxes/Ben","Travel","Admin","Variance","Weeks","Hrs/Week","Total Hrs","PTO days/yr","PTO Total","NPH hrs/wk","NPH Total"]
[{"$f":"IF(LEFT(B19,2)=\"**\",0,1)","v":0},null,"Worker",null,null,null,null,null,null,null,null,null,null,null,{"$f":"E22","v":0},{"$f":"E23","v":0},{"$f":"E24","v":4100},{"$f":"E25","v":676.5},{"$f":"E26","v":0},{"$f":"J22","v":52},{"$f":"J23","v":0},{"$f":"J24","v":0},{"$f":"I25","v":0},{"$f":"J25","v":0},{"$f":"I26","v":0},{"$f":"J26","v":0}]
[null,"Type:","Worker",null,{"$f":"\"Worker \"&COUNTA($A$17:A17)&\" of \"&COUNTA(A:A)","v":"Worker 1 of 1"},null,null,"Name:","[optional]"]
[null,{"$f":"IF(G30=\"\",\"**Please enter a value (\"\"0\"\" if not applicable) in each of the required yellow fields**\",IF(C18=\"\",\"**Please make a selection in the Type drop-down field**\",\"\"))","v":"**Please enter a value (\"0\" if not applicable) in each of the required yellow fields**"}]
[null,"Adoption Worker Costs",null,null,null,null,"Adoption Worker Hours"]
[]
[null,"Salary",null,"Show Calculator",null,"per year","Weeks",null,null,52]
[null,"Taxes/benefits",null,0,{"$f":"E22 * D23","v":0},null,"Hours/Week"]
[null,"Travel",null,null,4100,null,"Total Hours",null,null,{"$f":"+J23*J22","v":0}]
[null,"Overhead Rate",null,0.16500000000000001,{"$f":"SUM(E22:E24) * D25","v":676.5},null,"Less PTO","(days/yr)",null,{"$f":"-I25*8","v":0}]
[null,"Variance",null,0,{"$f":"SUM(E22:E25) * D26","v":0},null,"Less NPH","(hrs/week)",null,{"$f":"-48*I26","v":0}]
[null,"Total Cost",null,null,{"$f":"SUM(E22:E26)","v":4776.5},null,"Total Available Hours",null,null,{"$f":"IF(OR(J22=\"\",J23=\"\"),\"\",SUM(J24:J26))","v":""},"per Year"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J27=\"\",\"\",J27/12)","v":""},"per Month"]
[]
[null,null,null,null,null,"Minimum Desired Rate per Hour:",{"$f":"IF(AND(C18=\"Worker\",OR(E22=\"\",D23=\"\",E23=\"\",E24=\"\",D25=\"\",E25=\"\",D26=\"\",E26=\"\",J22=\"\",J23=\"\",I25=\"\",I26=\"\")),\"\",\nIF(AND(C18=\"Consultant\",OR(E22=\"\",J22=\"\",J23=\"\",I26=\"\",D25=\"\",E25=\"\")),\"\",E27/J27))","v":""}]

{"sheet":"Proposed Schedule","index":4,"n_rows":78,"n_cols":25,"rows_kept":78,"cut":false,"hidden":true,"merged":[[52,13,52,16],[53,13,53,16],[54,13,54,16],[55,13,55,16],[75,13,75,16],[56,13,56,16],[63,13,63,16],[64,13,64,16],[65,13,65,16],[66,13,66,16],[67,13,67,16],[68,13,68,16],[69,13,69,16],[70,13,70,16],[71,13,71,16],[72,13,72,16],[73,13,73,16],[74,13,74,16],[58,13,58,15],[36,22,37,22],[36,19,37,19],[20,16,21,16],[47,13,47,16],[48,13,48,16],[49,13,49,16],[50,13,50,16],[51,13,51,16],[45,13,45,16],[46,13,46,16],[39,10,39,15],[36,20,37,20],[20,17,21,17],[58,9,59,9],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[20,23,21,23],[36,23,37,23],[2,9,2,10],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[30,6,30,7],[30,14,30,15],[33,2,33,3],[33,6,33,7],[33,14,33,15],[34,2,34,3],[34,4,34,5],[44,13,44,16],[70,6,70,7],[74,2,74,3],[74,4,74,5],[72,6,72,7],[69,2,69,3],[69,4,69,5],[58,23,59,23],[57,4,57,5],[57,6,57,7],[63,4,63,5],[63,6,63,7],[66,2,66,3],[57,13,57,15],[65,6,65,7],[66,4,66,5],[66,6,66,7],[62,22,62,23],[61,20,62,20],[61,21,62,21],[58,21,59,21],[58,22,59,22],[63,2,63,3],[57,2,57,3],[61,13,62,16],[51,2,51,3],[51,4,51,5],[51,6,51,7],[65,2,65,3],[65,4,65,5],[53,2,53,3],[53,4,53,5],[53,6,53,7],[55,2,55,3],[55,4,55,5],[55,6,55,7],[64,4,64,5],[64,6,64,7],[58,4,58,5],[58,6,58,7],[56,2,56,3],[56,4,56,5],[56,6,56,7],[58,10,59,10],[58,11,59,11],[77,13,77,15],[47,2,47,3],[49,2,49,3],[49,4,49,5],[49,6,49,7],[48,2,48,3],[48,4,48,5],[48,6,48,7],[52,2,52,3],[64,2,64,3],[54,2,54,3],[54,4,54,5],[54,6,54,7],[75,2,75,3],[70,2,70,3],[69,6,69,7],[67,6,67,7],[74,6,74,7],[73,2,73,3],[73,4,73,5],[73,6,73,7],[72,2,72,3],[72,4,72,5],[70,4,70,5],[77,23,78,23],[52,4,52,5],[52,6,52,7],[75,4,75,5],[75,6,75,7],[67,2,67,3],[67,4,67,5],[68,2,68,3],[68,4,68,5],[68,6,68,7],[71,2,71,3],[71,4,71,5],[71,6,71,7],[77,21,78,21],[77,22,78,22],[77,4,77,5],[77,6,77,7],[77,9,78,9],[76,2,76,3],[76,4,76,5],[76,6,76,7],[76,13,76,15],[77,10,78,10],[77,11,78,11],[23,2,23,3],[23,4,23,5],[23,6,23,7],[26,4,26,5],[26,6,26,7],[26,14,26,15],[27,2,27,3],[27,4,27,5],[27,6,27,7],[27,14,27,15],[25,2,25,3],[25,4,25,5],[25,6,25,7],[26,2,26,3],[24,14,24,15],[23,14,23,15],[61,8,62,8],[61,9,62,9],[24,2,24,3],[24,4,24,5],[24,6,24,7],[28,2,28,3],[61,18,62,18],[61,19,62,19],[62,2,62,3],[62,10,62,11],[29,6,29,7],[29,14,29,15],[30,4,30,5],[32,14,32,15],[29,4,29,5],[30,2,30,3],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,14,31,15],[32,2,32,3],[32,4,32,5],[32,6,32,7],[34,6,34,7],[34,14,34,15],[33,4,33,5],[47,4,47,5],[47,6,47,7],[29,2,29,3],[42,8,43,8],[61,1,62,1],[61,2,61,3],[61,4,62,5],[61,6,62,7],[28,4,28,5],[28,6,28,7],[50,2,50,3],[50,4,50,5],[50,6,50,7],[45,2,45,3],[45,4,45,5],[45,6,45,7],[44,2,44,3],[44,4,44,5],[44,6,44,7],[46,2,46,3],[46,4,46,5],[46,6,46,7],[36,4,36,5],[42,1,43,1],[42,2,42,3],[42,4,43,5],[42,6,43,7],[37,4,37,5],[43,2,43,3],[25,14,25,15],[35,2,35,3],[35,4,35,5],[35,6,35,7],[28,14,28,15],[37,12,37,14],[35,14,35,15],[36,6,36,7],[36,14,36,15],[38,4,38,18],[42,9,43,9],[42,13,43,16],[41,9,41,16],[20,24,21,25],[42,21,43,21],[43,10,43,11],[42,18,43,18],[42,19,43,19],[42,20,43,20],[20,18,21,18],[20,19,21,19],[43,22,43,23],[20,22,21,22],[32,24,32,25],[33,24,33,25],[34,24,34,25],[36,24,37,25],[23,24,23,25],[24,24,24,25],[25,24,25,25],[26,24,26,25],[27,24,27,25],[28,24,28,25],[30,24,30,25],[29,24,29,25],[31,24,31,25],[36,21,37,21],[12,1,12,2],[2,6,2,8],[15,22,15,24],[16,23,16,24],[14,22,14,24],[17,23,17,24],[18,23,18,24],[22,2,22,3],[22,4,22,5],[22,6,22,7],[22,14,22,15],[22,24,22,25],[21,2,21,3],[21,20,21,21],[20,2,20,3],[20,4,21,5],[20,6,21,7],[20,8,21,8],[20,9,21,9],[20,10,21,10],[20,11,21,11],[20,12,21,12],[20,13,21,13],[20,14,21,15],[3,1,3,2],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[1,1,1,6],[2,3,2,4],[3,4,3,5],[19,11,19,13],[18,11,18,13],[40,11,40,13],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[3,6,3,7],[4,6,4,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[10,4,10,5],[11,4,11,5],[12,4,12,5]]}
[]
[]
[null,null,null,null,null,null,"Statewide",null,null,"Affiliate"]
[null,"Service",null,"Months","Rate",null,"Hours",null,"Hours Per Month","Hours","Hours Per Month"]
[null,{"$f":"Services!$C$5","v":"Adoption Finalization Extension"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B5,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B5,Services!$C$5:$C$20,0))/30)","v":4},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$5,Services!$C$5:$C$20,0))","v":1200},null,{"$f":"References!O5","v":20.046822742474916},null,{"$f":"IF(D5=0,0,IF(D5=\"n/a\",\"n/a\",G5/D5))","v":5.011705685618729},{"$f":"AveHours!F10","v":0},{"$f":"IF(D5=0,0,IF(D5=\"n/a\",\"n/a\",J5/D5))","v":0}]
[null,{"$f":"Services!$C$6","v":"Child Preparation"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B6,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B6,Services!$C$5:$C$20,0))/30)","v":6},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$6,Services!$C$5:$C$20,0))","v":2900},null,{"$f":"References!O6","v":42.702392231170059},null,7.1170653718616768,{"$f":"AveHours!F11","v":0},0]
[null,{"$f":"Services!$C$7","v":"Child Profile"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B7,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B7,Services!$C$5:$C$20,0))/30)","v":3},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$7,Services!$C$5:$C$20,0))","v":2100},null,{"$f":"References!O7","v":35.362185952686595},null,11.787395317562199,{"$f":"AveHours!F12","v":0},0]
[null,{"$f":"Services!$C$8","v":"Child Profile Addendum"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B8,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B8,Services!$C$5:$C$20,0))/30)","v":3},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$8,Services!$C$5:$C$20,0))","v":1350},null,{"$f":"References!O8","v":26.710510328068043},null,8.9035034426893471,{"$f":"AveHours!F13","v":0},0]
[null,{"$f":"Services!$C$9","v":"Child Specific Recruitment"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B9,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B9,Services!$C$5:$C$20,0))/30)","v":6},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$9,Services!$C$5:$C$20,0))","v":2800},null,{"$f":"References!O9","v":43.007209499575914},null,7.1678682499293194,{"$f":"AveHours!F14","v":0},0]
[null,{"$f":"Services!$C$10","v":"Finalization"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B10,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B10,Services!$C$5:$C$20,0))/30)","v":8},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$10,Services!$C$5:$C$20,0))","v":2250},null,{"$f":"References!O10","v":48.876821814762579},null,6.1096027268453224,{"$f":"AveHours!F17","v":0},0]
[null,{"$f":"Services!$C$11","v":"Placement"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B11,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B11,Services!$C$5:$C$20,0))/30)","v":"n/a"},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$11,Services!$C$5:$C$20,0))","v":1950},null,{"$f":"References!O11","v":27.374683544303796},null,"n/a",{"$f":"AveHours!F18","v":0},"n/a"]
[null,{"$f":"Services!$C$15","v":"Family Profile/Preparation"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B12,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B12,Services!$C$5:$C$20,0))/30)","v":4},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$12,Services!$C$5:$C$20,0))","v":2700},null,{"$f":"References!O12","v":38.659925093632957},null,9.6649812734082392,{"$f":"AveHours!F15","v":0},0]
[null,{"$f":"Services!$C$16","v":"Family Profile/Preparation Addendum"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B13,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B13,Services!$C$5:$C$20,0))/30)","v":4},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$13,Services!$C$5:$C$20,0))","v":1450},null,{"$f":"References!O13","v":37.56203007518797},null,9.3905075187969924,{"$f":"AveHours!F16","v":0},0]
[null,{"$f":"Services!$C$17","v":"Post-permanency Advocacy/Assessment"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B14,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B14,Services!$C$5:$C$20,0))/30)","v":1},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$14,Services!$C$5:$C$20,0))","v":500},null,{"$f":"References!R6","v":9.081003289473685},null,9.081003289473685,{"$f":"AveHours!F24","v":0},0]
[null,{"$f":"Services!$C$18","v":"Post-permanency Advocacy/Case Management"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B15,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B15,Services!$C$5:$C$20,0))/30)","v":1},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$15,Services!$C$5:$C$20,0))","v":500},null,{"$f":"References!R5","v":26.906378600823047},null,26.906378600823047,{"$f":"AveHours!F23","v":0},0]
[null,{"$f":"Services!$C$19","v":"Post-permanency: Support Group"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B16,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B16,Services!$C$5:$C$20,0))/30)","v":3},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$16,Services!$C$5:$C$20,0))","v":250},null,{"$f":"References!R8","v":9.796153846153846},null,3.2653846153846153,{"$f":"AveHours!F26","v":0},0]
[null,{"$f":"Services!$C$20","v":"Post-permanency: Respite"},null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($B17,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($B17,Services!$C$5:$C$20,0))/30)","v":1},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($B$17,Services!$C$5:$C$20,0))","v":300},null,{"$f":"References!R7","v":7.891629297458894},null,7.891629297458894,{"$f":"AveHours!F25","v":0},0,null,null,null,null,null,null,null,null,"Total Available Hours:",{"$f":"'Worker Costs_Hours'!J11","v":""},null,"Total Earnings:",{"$f":"T37","v":85900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scheduled Hours:",{"$f":"SUM(E37:S37)","v":1758.0343868479649},null,"Worker Costs:",{"$f":"'Worker Costs_Hours'!E11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"ANNUAL WORKLOAD",null,null,null,null,null,null,null,"Remaining Available Hours:",{"$f":"IF(OR(U17=\"\",U17=0),\"\",U17-U18)","v":""},null,"Profit/Loss:",{"$f":"X17-X18","v":85900}]
[null,null,null,null,null,null,null,null,null,null,null,"Affiliate Hours"]
[null,null,"# of Cases",null,"2020-07-01",null,{"$f":"IF(OR(E21=\"\"),\"\",EDATE(E21,1))","v":"2020-08-01"},null,{"$f":"IF(G21=\"\",\"\",EDATE(G21,1))","v":"2020-09-01"},{"$f":"IF(I21=\"\",\"\",EDATE(I21,1))","v":"2020-10-01"},"2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01",null,{"$f":"IF(O21=\"\",\"\",EDATE(O21,1))","v":"2021-04-01"},{"$f":"IF(Q21=\"\",\"\",EDATE(Q21,1))","v":"2021-05-01"},{"$f":"IF(R21=\"\",\"\",EDATE(R21,1))","v":"2021-06-01"},"Earnings","Total Cost based on Worker Rate","Profit/Loss based on Worker Rate","Est. Hours","Total Hours","Hrs per Unit of Service"]
[null,null,{"$f":"\"Total = \"&SUM(C23:C36)","v":"Total = 60"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"??\",\"(\"&DOLLAR('Worker Costs_Hours'!G14)&\")\")","v":"??"}]
[null,"Adoption Finalization Extension",5,null,10,null,10,null,10,20,20,30,30,20,20,null,10,10,10,{"$f":"IF(OR(B23=\"\",B23=\"**Select a service**\",C23=\"\",C23=0),0,C23*INDEX($E$5:$E$17,MATCH(B23,$B$5:$B$17,0)))","v":6000},{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B23=\"\",B23=\"**Select a service**\",C23=\"\",C23=0),0,SUM(E23:S23)*'Worker Costs_Hours'!G14))","v":" "},{"$f":"IF($U$22=\"??\",\" \",T23-U23)","v":" "},{"$f":"IF(OR(B23=\"\",B23=\"**Select a service**\"),0,IF(INDEX($J$5:$J$17,MATCH(B23,$B$5:$B$17,0))=\"\",\" \",IF($L$20=\"Affiliate Hours\",C23*INDEX($J$5:$J$17,MATCH(B23,$B$5:$B$17,0)),C23*INDEX($G$5:$G$17,MATCH(B23,$B$5:$B$17,0)))))","v":0},{"$f":"SUM(E23:S23)","v":200},{"$f":"IF(OR(C23=0,C23=\"\"),0,X23/C23)","v":40}]
[null,"Child Preparation",5,null,null,null,13.333333333333334,null,13.333333333333334,13.333333333333334,20,26.666666666666668,33.333333333333336,20,20,null,20,13.333333333333334,6.666666666666667,14500,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B24=\"\",B24=\"**Select a service**\",C24=\"\",C24=0),0,SUM(E24:S24)*'Worker Costs_Hours'!G14))","v":" "}," ",0,200,40]
[null,"Child Profile",5,null,26.666666666666668,null,26.666666666666668,null,26.666666666666668,null,13.333333333333334,13.333333333333334,13.333333333333334,null,null,null,26.666666666666668,26.666666666666668,26.666666666666668,10500,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B25=\"\",B25=\"**Select a service**\",C25=\"\",C25=0),0,SUM(E25:S25)*'Worker Costs_Hours'!G14))","v":" "}," ",0,199.99999999999997,39.999999999999993]
[null,"Child Profile Addendum",5,null,13.333333333333334,null,13.333333333333334,null,26.666666666666668,13.333333333333334,26.666666666666668,13.333333333333334,13.333333333333334,null,13.333333333333334,null,26.666666666666668,26.666666666666668,13.333333333333334,6750,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B26=\"\",B26=\"**Select a service**\",C26=\"\",C26=0),0,SUM(E26:S26)*'Worker Costs_Hours'!G14))","v":" "}," ",0,200,40]
[null,"Child Specific Recruitment",5,null,6.666666666666667,null,13.333333333333334,null,20,20,20,20,26.666666666666668,20,13.333333333333334,null,13.333333333333334,13.333333333333334,13.333333333333334,14000,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B27=\"\",B27=\"**Select a service**\",C27=\"\",C27=0),0,SUM(E27:S27)*'Worker Costs_Hours'!G14))","v":" "}," ",0,200.00000000000006,40.000000000000014]
[null,"Finalization",4,null,null,null,10,null,10,15,20,20,20,20,20,null,10,10,5,9000,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B28=\"\",B28=\"**Select a service**\",C28=\"\",C28=0),0,SUM(E28:S28)*'Worker Costs_Hours'!G14))","v":" "}," ",0,160,40]
["x","Placement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B29=\"\",B29=\"**Select a service**\",C29=\"\",C29=0),0,SUM(E29:S29)*'Worker Costs_Hours'!G14))","v":" "}," ",0,0,0]
[null,"Family Profile/Preparation",4,null,20,null,20,null,20,20,null,null,null,null,20,null,20,20,20,10800,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B30=\"\",B30=\"**Select a service**\",C30=\"\",C30=0),0,SUM(E30:S30)*'Worker Costs_Hours'!G14))","v":" "}," ",0,160,40]
[null,"Family Profile/Preparation Addendum",4,null,20,null,20,null,20,20,null,null,null,10,20,null,20,20,10,5800,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B31=\"\",B31=\"**Select a service**\",C31=\"\",C31=0),0,SUM(E31:S31)*'Worker Costs_Hours'!G14))","v":" "}," ",0,160,40]
[null,"Post-permanency Advocacy/Assessment",6,null,9.081003289473685,null,9.081003289473685,null,null,9.081003289473685,null,9.081003289473685,null,null,9.081003289473685,null,null,null,9.081003289473685,3000,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B32=\"\",B32=\"**Select a service**\",C32=\"\",C32=0),0,SUM(E32:S32)*'Worker Costs_Hours'!G14))","v":" "}," ",0,54.48601973684211,9.081003289473685]
[null,"Post-permanency Advocacy/Case Management",4,null,26.906378600823047,null,null,null,null,null,null,null,null,53.812757201646093,null,null,null,null,26.906378600823047,2000,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B33=\"\",B33=\"**Select a service**\",C33=\"\",C33=0),0,SUM(E33:S33)*'Worker Costs_Hours'!G14))","v":" "}," ",0,107.62551440329219,26.906378600823047]
[null,"Post-permanency: Support Group",7,null,3.2653846153846153,null,3.2653846153846153,null,3.2653846153846153,6.5307692307692307,13.061538461538461,13.061538461538461,9.796153846153846,3.2653846153846153,3.2653846153846153,null,3.2653846153846153,3.2653846153846153,3.2653846153846153,1750,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B34=\"\",B34=\"**Select a service**\",C34=\"\",C34=0),0,SUM(E34:S34)*'Worker Costs_Hours'!G14))","v":" "}," ",0,68.57307692307694,9.7961538461538478]
[null,"Post-permanency: Respite",6,null,7.891629297458894,null,7.891629297458894,null,null,7.891629297458894,15.783258594917788,null,null,null,7.891629297458894,null,null,null,null,1800,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\" \",IF(OR(B35=\"\",B35=\"**Select a service**\",C35=\"\",C35=0),0,SUM(E35:S35)*'Worker Costs_Hours'!G14))","v":" "}," ",0,47.349775784753362,7.891629297458894]
[null,"*****"]
[null,null,null,null,{"$f":"SUM(E23:F36)","v":143.81106246980693},null,{"$f":"SUM(G23:H36)","v":146.90468386898388},null,{"$f":"SUM(I23:I36)","v":149.9320512820513},145.1700684843685,148.84479705645626,145.47587508434549,146.46282051282054,147.07814181703071,{"$f":"SUM(O23:P36)","v":146.90468386898388},null,{"$f":"SUM(Q23:Q36)","v":149.9320512820513},143.26538461538462,144.25276650568134,85900,0,0,0,1758.0343868479645,{"$f":"SUM(Y23:Z35)","v":373.67516503390954}]
[null,null,null,null,null,null,null,null,null,null,null,"HOURS",{"$f":"\"(Total = \"&TEXT(SUM(E37:S37),\"#,##0.0\")&\")\"","v":"(Total = 1,758.0)"}]
[null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"\",IF(COUNTIF(E37:S37,\">\"&'Worker Costs_Hours'!J12)>0,\"**The monthly hours available (\"&TEXT('Worker Costs_Hours'!J12,\"#,##0.00\")&\") has been exceeded**\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"QUARTERLY WORKLOAD"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L20","v":"Affiliate Hours"}]
[null,null,null,null,null,null,null,null,null,"* # of Cases = ([Hours in quarter] ÷ [Hours in year]) x [# of Cases in year]"]
[null,"QUARTER 1","# of Cases*",null,{"$f":"E21","v":"2020-07-01"},null,{"$f":"G21","v":"2020-08-01"},null,{"$f":"I21","v":"2020-09-01"},"Earnings","Total Cost based on Worker Rate","Profit/Loss based on Worker Rate",null,"QUARTER 2",null,null,null,"# of Cases*",{"$f":"J21","v":"2020-10-01"},{"$f":"K21","v":"2020-11-01"},{"$f":"L21","v":"2020-12-01"},"Earnings","Total Cost based on Worker Rate","Profit/Loss based on Worker Rate"]
[null,null,{"$f":"\"Total = \"&TEXT(SUM(C45:C58),\"0.00\")","v":"Total = 15.25"},null,null,null,null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"??\",\"($\"&TEXT('Worker Costs_Hours'!G14,\"0.##\")&\")\")","v":"??"},null,null,null,null,null,null,{"$f":"\"Total = \"&TEXT(SUM(R45:R58),\"0.00\")","v":"Total = 17.46"},null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"??\",\"(\"&DOLLAR('Worker Costs_Hours'!G14)&\")\")","v":"??"}]
[{"$f":"A23","v":0},{"$f":"IF(B23=\"**Select a service**\",\"\",B23)","v":"Adoption Finalization Extension"},{"$f":"IF(OR(C23=\"\",C23=0,SUM(E23:S23)=0),\"\",(SUM(E45:I45)/SUM(E23:S23))*C23)","v":0.75},null,{"$f":"IF(OR(A45=\"x\",A45=\"y\"),\"\",E23)","v":10},null,{"$f":"IF(OR(A45=\"x\",A45=\"y\"),\"\",G23)","v":10},null,{"$f":"IF(OR(A45=\"x\",A45=\"y\"),\"\",I23)","v":10},{"$f":"IF(OR(A45=\"x\",A45=\"y\"),\"\",IF(OR(B45=\"\",B45=\"**Select a service**\",C45=\"\",C45=0),0,C45*INDEX($E$5:$E$17,MATCH(B45,$B$5:$B$17,0))))","v":900},{"$f":"IF(OR(A45=\"x\",A45=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B45=\"\",B45=\"**Select a service**\",C45=\"\",C45=0),0,SUM(E45:I45)*'Worker Costs_Hours'!G14)))","v":" "},{"$f":"IF(OR(A45=\"x\",A45=\"y\"),\"\",IF($U$22=\"??\",\" \",J45-K45))","v":" "},{"$f":"A23","v":0},{"$f":"IF(B23=\"**Select a service**\",\"\",B23)","v":"Adoption Finalization Extension"},null,null,null,{"$f":"IF(OR(C23=\"\",C23=0,SUM(E23:S23)=0),\"\",(SUM(S45:U45)/SUM(E23:S23))*C23)","v":1.75},{"$f":"IF(OR(M45=\"x\",M45=\"y\"),\"\",J23)","v":20},{"$f":"IF(OR(M45=\"x\",M45=\"y\"),\"\",K23)","v":20},{"$f":"IF(OR(M45=\"x\",M45=\"y\"),\"\",L23)","v":30},{"$f":"IF(OR(M45=\"x\",M45=\"y\"),\"\",IF(OR(N45=\"\",N45=\"**Select a service**\",R45=\"\",R45=0),0,R45*INDEX($E$5:$E$17,MATCH(N45,$B$5:$B$17,0))))","v":2100},{"$f":"IF(OR(M45=\"x\",M45=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N45=\"\",N45=\"**Select a service**\",R45=\"\",R45=0),0,SUM(S45:U45)*'Worker Costs_Hours'!G14)))","v":" "},{"$f":"IF(OR(M45=\"x\",M45=\"y\"),\"\",IF($U$22=\"??\",\" \",V45-W45))","v":" "}]
[0,"Child Preparation",0.66666666666666663,null,0,null,13.333333333333334,null,13.333333333333334,1933.3333333333333,{"$f":"IF(OR(A46=\"x\",A46=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B46=\"\",B46=\"**Select a service**\",C46=\"\",C46=0),0,SUM(E46:I46)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Child Preparation",null,null,null,1.5,13.333333333333334,20,26.666666666666668,4350,{"$f":"IF(OR(M46=\"x\",M46=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N46=\"\",N46=\"**Select a service**\",R46=\"\",R46=0),0,SUM(S46:U46)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Child Profile",2.0000000000000004,null,26.666666666666668,null,26.666666666666668,null,26.666666666666668,4200.0000000000009,{"$f":"IF(OR(A47=\"x\",A47=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B47=\"\",B47=\"**Select a service**\",C47=\"\",C47=0),0,SUM(E47:I47)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Child Profile",null,null,null,0.66666666666666674,0,13.333333333333334,13.333333333333334,1400.0000000000002,{"$f":"IF(OR(M47=\"x\",M47=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N47=\"\",N47=\"**Select a service**\",R47=\"\",R47=0),0,SUM(S47:U47)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Child Profile Addendum",1.3333333333333333,null,13.333333333333334,null,13.333333333333334,null,26.666666666666668,1800,{"$f":"IF(OR(A48=\"x\",A48=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B48=\"\",B48=\"**Select a service**\",C48=\"\",C48=0),0,SUM(E48:I48)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Child Profile Addendum",null,null,null,1.3333333333333333,13.333333333333334,26.666666666666668,13.333333333333334,1800,{"$f":"IF(OR(M48=\"x\",M48=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N48=\"\",N48=\"**Select a service**\",R48=\"\",R48=0),0,SUM(S48:U48)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Child Specific Recruitment",0.99999999999999978,null,6.666666666666667,null,13.333333333333334,null,20,2799.9999999999995,{"$f":"IF(OR(A49=\"x\",A49=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B49=\"\",B49=\"**Select a service**\",C49=\"\",C49=0),0,SUM(E49:I49)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Child Specific Recruitment",null,null,null,1.4999999999999996,20,20,20,4199.9999999999991,{"$f":"IF(OR(M49=\"x\",M49=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N49=\"\",N49=\"**Select a service**\",R49=\"\",R49=0),0,SUM(S49:U49)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Finalization",0.5,null,0,null,10,null,10,1125,{"$f":"IF(OR(A50=\"x\",A50=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B50=\"\",B50=\"**Select a service**\",C50=\"\",C50=0),0,SUM(E50:I50)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Finalization",null,null,null,1.375,15,20,20,3093.75,{"$f":"IF(OR(M50=\"x\",M50=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N50=\"\",N50=\"**Select a service**\",R50=\"\",R50=0),0,SUM(S50:U50)*'Worker Costs_Hours'!G14)))","v":" "}," "]
["x","Placement","",null,"",null,"",null,"","",{"$f":"IF(OR(A51=\"x\",A51=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B51=\"\",B51=\"**Select a service**\",C51=\"\",C51=0),0,SUM(E51:I51)*'Worker Costs_Hours'!G14)))","v":""},"","x","Placement",null,null,null,"","","","","",{"$f":"IF(OR(M51=\"x\",M51=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N51=\"\",N51=\"**Select a service**\",R51=\"\",R51=0),0,SUM(S51:U51)*'Worker Costs_Hours'!G14)))","v":""},""]
[0,"Family Profile/Preparation",1.5,null,20,null,20,null,20,4050,{"$f":"IF(OR(A52=\"x\",A52=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B52=\"\",B52=\"**Select a service**\",C52=\"\",C52=0),0,SUM(E52:I52)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Family Profile/Preparation",null,null,null,0.5,20,0,0,1350,{"$f":"IF(OR(M52=\"x\",M52=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N52=\"\",N52=\"**Select a service**\",R52=\"\",R52=0),0,SUM(S52:U52)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Family Profile/Preparation Addendum",1.5,null,20,null,20,null,20,2175,{"$f":"IF(OR(A53=\"x\",A53=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B53=\"\",B53=\"**Select a service**\",C53=\"\",C53=0),0,SUM(E53:I53)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Family Profile/Preparation Addendum",null,null,null,0.5,20,0,0,725,{"$f":"IF(OR(M53=\"x\",M53=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N53=\"\",N53=\"**Select a service**\",R53=\"\",R53=0),0,SUM(S53:U53)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Post-permanency Advocacy/Assessment",2,null,9.081003289473685,null,9.081003289473685,null,0,1000,{"$f":"IF(OR(A54=\"x\",A54=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B54=\"\",B54=\"**Select a service**\",C54=\"\",C54=0),0,SUM(E54:I54)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Post-permanency Advocacy/Assessment",null,null,null,2,9.081003289473685,0,9.081003289473685,1000,{"$f":"IF(OR(M54=\"x\",M54=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N54=\"\",N54=\"**Select a service**\",R54=\"\",R54=0),0,SUM(S54:U54)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Post-permanency Advocacy/Case Management",1,null,26.906378600823047,null,0,null,0,500,{"$f":"IF(OR(A55=\"x\",A55=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B55=\"\",B55=\"**Select a service**\",C55=\"\",C55=0),0,SUM(E55:I55)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Post-permanency Advocacy/Case Management",null,null,null,0,0,0,0,0,{"$f":"IF(OR(M55=\"x\",M55=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N55=\"\",N55=\"**Select a service**\",R55=\"\",R55=0),0,SUM(S55:U55)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Post-permanency: Support Group",0.99999999999999978,null,3.2653846153846153,null,3.2653846153846153,null,3.2653846153846153,249.99999999999994,{"$f":"IF(OR(A56=\"x\",A56=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B56=\"\",B56=\"**Select a service**\",C56=\"\",C56=0),0,SUM(E56:I56)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Post-permanency: Support Group",null,null,null,3.3333333333333321,6.5307692307692307,13.061538461538461,13.061538461538461,833.33333333333303,{"$f":"IF(OR(M56=\"x\",M56=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N56=\"\",N56=\"**Select a service**\",R56=\"\",R56=0),0,SUM(S56:U56)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Post-permanency: Respite",2,null,7.891629297458894,null,7.891629297458894,null,0,600,{"$f":"IF(OR(A57=\"x\",A57=\"y\"),\"\",IF($K$44=\"??\",\" \",IF(OR(B57=\"\",B57=\"**Select a service**\",C57=\"\",C57=0),0,SUM(E57:I57)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Post-permanency: Respite",null,null,null,3,7.891629297458894,15.783258594917788,0,900,{"$f":"IF(OR(M57=\"x\",M57=\"y\"),\"\",IF($W$44=\"??\",\" \",IF(OR(N57=\"\",N57=\"**Select a service**\",R57=\"\",R57=0),0,SUM(S57:U57)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[null,"*",null,null,null,null,null,null,null,null,null,null,null,"**"]
[null,null,null,null,{"$f":"SUM(E45:E58)","v":143.81106246980693},null,{"$f":"SUM(G45:G58)","v":146.90468386898388},null,{"$f":"SUM(I45:I58)","v":149.9320512820513},21333.333333333336,0,0,null,null,null,null,null,null,{"$f":"SUM(S45:S58)","v":145.1700684843685},148.84479705645626,145.47587508434549,21752.083333333332,0,{"$f":"SUM(X45:X58)","v":0}]
[]
[]
[null,"QUARTER 3","# of Cases*",null,{"$f":"M21","v":"2021-01-01"},null,{"$f":"N21","v":"2021-02-01"},null,{"$f":"O21","v":"2021-03-01"},"Earnings","Total Cost based on Worker Rate","Profit/Loss based on Worker Rate",null,"QUARTER 4",null,null,null,"# of Cases*",{"$f":"Q21","v":"2021-04-01"},{"$f":"R21","v":"2021-05-01"},{"$f":"S21","v":"2021-06-01"},"Earnings","Total Cost based on Worker Rate","Profit/Loss based on Worker Rate"]
[null,null,{"$f":"\"Total = \"&TEXT(SUM(D64:D77),\"0.00\")","v":"Total = 0.00"},null,null,null,null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"??\",\"(\"&DOLLAR('Worker Costs_Hours'!G14)&\")\")","v":"??"},null,null,null,null,null,null,{"$f":"\"Total = \"&TEXT(SUM(R64:R77),\"0.00\")","v":"Total = 12.79"},null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"??\",\"(\"&DOLLAR('Worker Costs_Hours'!G14)&\")\")","v":"??"}]
[{"$f":"A23","v":0},{"$f":"IF(B23=\"**Select a service**\",\"\",B23)","v":"Adoption Finalization Extension"},{"$f":"IF(OR(C23=\"\",C23=0,SUM(E23:S23)=0),\"\",(SUM(E64:I64)/SUM(E23:S23))*C23)","v":1.75},null,{"$f":"IF(OR(A64=\"x\",A64=\"y\"),\"\",M23)","v":30},null,{"$f":"IF(OR(A64=\"x\",A64=\"y\"),\"\",N23)","v":20},null,{"$f":"IF(OR(A64=\"x\",A64=\"y\"),\"\",O23)","v":20},{"$f":"IF(OR(A64=\"x\",A64=\"y\"),\"\",IF(OR(B64=\"\",B64=\"**Select a service**\",C64=\"\",C64=0),0,C64*INDEX($F$5:$F$17,MATCH(B64,$B$5:$B$17,0))))","v":0},{"$f":"IF(OR(A64=\"x\",A64=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B64=\"\",B64=\"**Select a service**\",C64=\"\",C64=0),0,SUM(E64:I64)*'Worker Costs_Hours'!G14)))","v":" "},{"$f":"IF(OR(A64=\"x\",A64=\"y\"),\"\",IF($U$22=\"??\",\" \",J64-K64))","v":" "},{"$f":"A45","v":0},{"$f":"IF(B23=\"**Select a service**\",\"\",B23)","v":"Adoption Finalization Extension"},null,null,null,{"$f":"IF(OR(C23=\"\",C23=0,SUM(E23:S23)=0),\"\",(SUM(S64:U64)/SUM(E23:S23))*C23)","v":0.75},{"$f":"IF(OR(M64=\"x\",M64=\"y\"),\"\",Q23)","v":10},{"$f":"IF(OR(M64=\"x\",M64=\"y\"),\"\",R23)","v":10},{"$f":"IF(OR(M64=\"x\",M64=\"y\"),\"\",S23)","v":10},{"$f":"IF(OR(M64=\"x\",M64=\"y\"),\"\",IF(OR(N64=\"\",N64=\"**Select a service**\",R64=\"\",R64=0),0,R64*INDEX($F$5:$F$17,MATCH(N64,$B$5:$B$17,0))))","v":0},{"$f":"IF(OR(M64=\"x\",M64=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N64=\"\",N64=\"**Select a service**\",R64=\"\",R64=0),0,SUM(S64:U64)*'Worker Costs_Hours'!G14)))","v":" "},{"$f":"IF(OR(M64=\"x\",M64=\"y\"),\"\",IF($U$22=\"??\",\" \",V64-W64))","v":" "}]
[0,"Child Preparation",1.8333333333333335,null,33.333333333333336,null,20,null,20,{"$f":"IF(OR(A65=\"x\",A65=\"y\"),\"\",IF(OR(B65=\"\",B65=\"**Select a service**\",C65=\"\",C65=0),0,C65*INDEX($E$5:$E$17,MATCH(B65,$B$5:$B$17,0))))","v":5316.666666666667},{"$f":"IF(OR(A65=\"x\",A65=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B65=\"\",B65=\"**Select a service**\",C65=\"\",C65=0),0,SUM(E65:I65)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Child Preparation",null,null,null,1,20,13.333333333333334,6.666666666666667,{"$f":"IF(OR(M65=\"x\",M65=\"y\"),\"\",IF(OR(N65=\"\",N65=\"**Select a service**\",R65=\"\",R65=0),0,R65*INDEX($E$5:$E$17,MATCH(N65,$B$5:$B$17,0))))","v":2900},{"$f":"IF(OR(M65=\"x\",M65=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N65=\"\",N65=\"**Select a service**\",R65=\"\",R65=0),0,SUM(S65:U65)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Child Profile",0.33333333333333337,null,13.333333333333334,null,0,null,0,700.00000000000011,{"$f":"IF(OR(A66=\"x\",A66=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B66=\"\",B66=\"**Select a service**\",C66=\"\",C66=0),0,SUM(E66:I66)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Child Profile",null,null,null,2.0000000000000004,26.666666666666668,26.666666666666668,26.666666666666668,4200.0000000000009,{"$f":"IF(OR(M66=\"x\",M66=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N66=\"\",N66=\"**Select a service**\",R66=\"\",R66=0),0,SUM(S66:U66)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Child Profile Addendum",0.66666666666666663,null,13.333333333333334,null,0,null,13.333333333333334,900,{"$f":"IF(OR(A67=\"x\",A67=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B67=\"\",B67=\"**Select a service**\",C67=\"\",C67=0),0,SUM(E67:I67)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Child Profile Addendum",null,null,null,1.666666666666667,26.666666666666668,26.666666666666668,13.333333333333334,2250.0000000000005,{"$f":"IF(OR(M67=\"x\",M67=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N67=\"\",N67=\"**Select a service**\",R67=\"\",R67=0),0,SUM(S67:U67)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Child Specific Recruitment",1.4999999999999996,null,26.666666666666668,null,20,null,13.333333333333334,4199.9999999999991,{"$f":"IF(OR(A68=\"x\",A68=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B68=\"\",B68=\"**Select a service**\",C68=\"\",C68=0),0,SUM(E68:I68)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Child Specific Recruitment",null,null,null,0.99999999999999978,13.333333333333334,13.333333333333334,13.333333333333334,2799.9999999999995,{"$f":"IF(OR(M68=\"x\",M68=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N68=\"\",N68=\"**Select a service**\",R68=\"\",R68=0),0,SUM(S68:U68)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Finalization",1.5,null,20,null,20,null,20,3375,{"$f":"IF(OR(A69=\"x\",A69=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B69=\"\",B69=\"**Select a service**\",C69=\"\",C69=0),0,SUM(E69:I69)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Finalization",null,null,null,0.625,10,10,5,1406.25,{"$f":"IF(OR(M69=\"x\",M69=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N69=\"\",N69=\"**Select a service**\",R69=\"\",R69=0),0,SUM(S69:U69)*'Worker Costs_Hours'!G14)))","v":" "}," "]
["x","Placement","",null,"",null,"",null,"","",{"$f":"IF(OR(A70=\"x\",A70=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B70=\"\",B70=\"**Select a service**\",C70=\"\",C70=0),0,SUM(E70:I70)*'Worker Costs_Hours'!G14)))","v":""},"","x","Placement",null,null,null,"","","","","",{"$f":"IF(OR(M70=\"x\",M70=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N70=\"\",N70=\"**Select a service**\",R70=\"\",R70=0),0,SUM(S70:U70)*'Worker Costs_Hours'!G14)))","v":""},""]
[0,"Family Profile/Preparation",0.5,null,0,null,0,null,20,1350,{"$f":"IF(OR(A71=\"x\",A71=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B71=\"\",B71=\"**Select a service**\",C71=\"\",C71=0),0,SUM(E71:I71)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Family Profile/Preparation",null,null,null,1.5,20,20,20,4050,{"$f":"IF(OR(M71=\"x\",M71=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N71=\"\",N71=\"**Select a service**\",R71=\"\",R71=0),0,SUM(S71:U71)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Family Profile/Preparation Addendum",0.75,null,0,null,10,null,20,1087.5,{"$f":"IF(OR(A72=\"x\",A72=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B72=\"\",B72=\"**Select a service**\",C72=\"\",C72=0),0,SUM(E72:I72)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Family Profile/Preparation Addendum",null,null,null,1.25,20,20,10,1812.5,{"$f":"IF(OR(M72=\"x\",M72=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N72=\"\",N72=\"**Select a service**\",R72=\"\",R72=0),0,SUM(S72:U72)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Post-permanency Advocacy/Assessment",1,null,0,null,0,null,9.081003289473685,500,{"$f":"IF(OR(A73=\"x\",A73=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B73=\"\",B73=\"**Select a service**\",C73=\"\",C73=0),0,SUM(E73:I73)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Post-permanency Advocacy/Assessment",null,null,null,1,0,0,9.081003289473685,500,{"$f":"IF(OR(M73=\"x\",M73=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N73=\"\",N73=\"**Select a service**\",R73=\"\",R73=0),0,SUM(S73:U73)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Post-permanency Advocacy/Case Management",2,null,0,null,53.812757201646093,null,0,1000,{"$f":"IF(OR(A74=\"x\",A74=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B74=\"\",B74=\"**Select a service**\",C74=\"\",C74=0),0,SUM(E74:I74)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Post-permanency Advocacy/Case Management",null,null,null,1,0,0,26.906378600823047,500,{"$f":"IF(OR(M74=\"x\",M74=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N74=\"\",N74=\"**Select a service**\",R74=\"\",R74=0),0,SUM(S74:U74)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Post-permanency: Support Group",1.6666666666666661,null,9.796153846153846,null,3.2653846153846153,null,3.2653846153846153,416.66666666666652,{"$f":"IF(OR(A75=\"x\",A75=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B75=\"\",B75=\"**Select a service**\",C75=\"\",C75=0),0,SUM(E75:I75)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Post-permanency: Support Group",null,null,null,0.99999999999999978,3.2653846153846153,3.2653846153846153,3.2653846153846153,249.99999999999994,{"$f":"IF(OR(M75=\"x\",M75=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N75=\"\",N75=\"**Select a service**\",R75=\"\",R75=0),0,SUM(S75:U75)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[0,"Post-permanency: Respite",1,null,0,null,0,null,7.891629297458894,300,{"$f":"IF(OR(A76=\"x\",A76=\"y\"),\"\",IF($K$63=\"??\",\" \",IF(OR(B76=\"\",B76=\"**Select a service**\",C76=\"\",C76=0),0,SUM(E76:I76)*'Worker Costs_Hours'!G14)))","v":" "}," ",0,"Post-permanency: Respite",null,null,null,0,0,0,0,0,{"$f":"IF(OR(M76=\"x\",M76=\"y\"),\"\",IF($W$63=\"??\",\" \",IF(OR(N76=\"\",N76=\"**Select a service**\",R76=\"\",R76=0),0,SUM(S76:U76)*'Worker Costs_Hours'!G14)))","v":" "}," "]
[null,"***",null,null,null,null,null,null,null,null,null,null,null,"****"]
[null,null,null,null,{"$f":"SUM(E64:E77)","v":146.46282051282054},null,{"$f":"SUM(G64:G77)","v":147.07814181703071},null,{"$f":"SUM(I64:I77)","v":146.90468386898388},19145.833333333332,0,0,null,null,null,null,null,null,{"$f":"SUM(S64:S77)","v":149.9320512820513},143.26538461538462,144.25276650568134,20668.75,0,{"$f":"SUM(X64:X76)","v":0}]

{"sheet":"Schedule","index":5,"n_rows":1000002,"n_cols":30,"rows_kept":4500,"cut":true,"hidden":true,"merged":[[31,3,32,3],[38,3,39,3],[38,11,39,11],[34,17,34,20],[31,26,32,26],[32,28,32,30],[35,28,36,28],[31,24,32,24],[38,27,39,27],[31,25,32,25],[35,27,36,27],[38,26,39,26],[38,24,39,24],[31,29,31,30],[35,29,36,30],[38,29,38,30],[33,29,33,30],[33,5,33,6],[38,5,38,6],[26,26,27,26],[28,7,28,23],[26,7,26,8],[31,9,32,10],[31,18,32,21],[32,13,32,14],[35,13,36,13],[35,14,36,14],[39,13,39,14],[38,7,39,8],[38,9,39,10],[38,12,39,12],[35,9,35,10],[13,7,13,8],[22,14,23,14],[22,20,23,20],[18,28,18,29],[19,28,19,29],[26,25,27,25],[23,25,23,26],[22,29,23,30],[22,13,23,13],[26,29,27,30],[22,21,23,22],[24,15,24,17],[24,21,24,22],[22,28,23,28],[26,28,27,28],[22,18,23,18],[22,19,23,19],[22,15,23,17],[26,15,26,17],[22,27,23,27],[22,23,23,23],[26,24,27,24],[22,24,23,24],[26,27,27,27],[41,5,41,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[11,5,11,6],[10,5,10,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[22,5,22,6],[24,5,24,6],[31,5,31,6],[39,5,39,6],[32,5,32,6],[40,5,40,6],[2,2,2,5],[8,7,8,8],[10,7,10,8],[9,7,9,8],[34,5,34,6],[23,5,23,6],[29,2,29,30],[30,12,30,20],[25,29,25,30],[22,7,23,8],[14,7,14,8],[2,9,2,11],[3,5,3,6],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[33,9,33,10],[33,18,33,21],[19,14,20,18],[1,3,1,9],[25,7,25,8],[25,9,25,10],[22,9,23,10],[25,5,25,6],[22,12,23,12],[26,9,26,10],[22,11,23,11],[11,2,11,3],[16,7,16,8],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[12,2,12,3],[4,7,4,8],[5,7,5,8],[6,7,6,8],[7,7,7,8],[15,7,15,8],[2,12,2,13],[24,7,24,8],[3,7,3,8],[3,9,3,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[24,9,24,10],[42,29,43,30],[39,28,39,30],[42,28,43,28],[11,9,11,10],[20,28,20,29],[24,29,24,30],[40,29,40,30],[35,17,35,19],[40,9,40,10],[40,18,40,21],[42,12,43,12],[42,9,42,10],[31,11,32,11],[31,12,32,12],[41,9,41,10],[35,12,36,12],[12,9,12,10],[14,9,14,10],[13,9,13,10],[15,9,15,10],[16,9,16,10],[11,7,11,8],[42,27,43,27],[38,25,39,25],[31,27,32,27],[42,14,43,14],[41,17,41,20],[42,17,42,19],[33,7,33,8],[42,13,43,13],[26,21,26,22],[38,18,39,21],[42,7,42,8],[31,7,32,8],[35,7,35,8],[41,7,41,8],[34,7,34,8],[34,9,34,10],[40,7,40,8],[12,7,12,8]],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0}}
[]
[]
[null,null,null,null,null,null,null,null,null,"Statewide",null,null,"Affiliate"]
[null,null,"Service",null,null,"Months",null,"Rate",null,"Hours",null,"Hours Per Month","Hours","Hours Per Month"]
[null,null,{"$f":"Services!$C$5","v":"Adoption Finalization Extension"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C5,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C5,Services!$C$5:$C$20,0))/30)","v":4},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C5,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C5,Services!$C$5:$C$20,0))/30)","v":4},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$5,Services!$C$5:$C$20,0))","v":1200},null,{"$f":"References!O5","v":20.046822742474916},null,{"$f":"IF(F5=0,0,IF(F5=\"n/a\",\"n/a\",J5/F5))","v":5.011705685618729},{"$f":"AveHours!F10","v":0},{"$f":"IF(F5=0,0,IF(F5=\"n/a\",\"n/a\",M5/F5))","v":0}]
[null,null,{"$f":"Services!$C$6","v":"Child Preparation"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C6,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C6,Services!$C$5:$C$20,0))/30)","v":6},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C6,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C6,Services!$C$5:$C$20,0))/30)","v":6},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$6,Services!$C$5:$C$20,0))","v":2900},null,{"$f":"References!O6","v":42.702392231170059},null,7.1170653718616768,{"$f":"AveHours!F11","v":0},0]
[null,null,{"$f":"Services!$C$7","v":"Child Profile"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C7,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C7,Services!$C$5:$C$20,0))/30)","v":3},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C7,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C7,Services!$C$5:$C$20,0))/30)","v":3},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$7,Services!$C$5:$C$20,0))","v":2100},null,{"$f":"References!O7","v":35.362185952686595},null,11.787395317562199,{"$f":"AveHours!F12","v":0},0]
[null,null,{"$f":"Services!$C$8","v":"Child Profile Addendum"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C8,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C8,Services!$C$5:$C$20,0))/30)","v":3},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C8,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C8,Services!$C$5:$C$20,0))/30)","v":3},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$8,Services!$C$5:$C$20,0))","v":1350},null,{"$f":"References!O8","v":26.710510328068043},null,8.9035034426893471,{"$f":"AveHours!F13","v":0},0]
[null,null,{"$f":"Services!$C$9","v":"Child Specific Recruitment"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C9,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C9,Services!$C$5:$C$20,0))/30)","v":6},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C9,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C9,Services!$C$5:$C$20,0))/30)","v":6},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$9,Services!$C$5:$C$20,0))","v":2800},null,{"$f":"References!O9","v":43.007209499575914},null,7.1678682499293194,{"$f":"AveHours!F14","v":0},0]
[null,null,{"$f":"Services!$C$10","v":"Finalization"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C10,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C10,Services!$C$5:$C$20,0))/30)","v":8},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C10,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C10,Services!$C$5:$C$20,0))/30)","v":8},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$10,Services!$C$5:$C$20,0))","v":2250},null,{"$f":"References!O10","v":48.876821814762579},null,6.1096027268453224,{"$f":"AveHours!F17","v":0},0]
[null,null,{"$f":"Services!$C$11","v":"Placement"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C11,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C11,Services!$C$5:$C$20,0))/30)","v":"n/a"},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C11,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C11,Services!$C$5:$C$20,0))/30)","v":"n/a"},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$11,Services!$C$5:$C$20,0))","v":1950},null,{"$f":"References!O11","v":27.374683544303796},null,"n/a",{"$f":"AveHours!F18","v":0},"n/a"]
[null,null,{"$f":"Services!$C$15","v":"Family Profile/Preparation"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C12,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C12,Services!$C$5:$C$20,0))/30)","v":4},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C12,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C12,Services!$C$5:$C$20,0))/30)","v":4},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$12,Services!$C$5:$C$20,0))","v":2700},null,{"$f":"References!O12","v":38.659925093632957},null,9.6649812734082392,{"$f":"AveHours!F15","v":0},0]
[null,null,{"$f":"Services!$C$16","v":"Family Profile/Preparation Addendum"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C13,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C13,Services!$C$5:$C$20,0))/30)","v":4},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C13,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C13,Services!$C$5:$C$20,0))/30)","v":4},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$13,Services!$C$5:$C$20,0))","v":1450},null,{"$f":"References!O13","v":37.56203007518797},null,9.3905075187969924,{"$f":"AveHours!F16","v":0},0]
[null,null,{"$f":"Services!$C$17","v":"Post-permanency Advocacy/Assessment"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C14,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C14,Services!$C$5:$C$20,0))/30)","v":1},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C14,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C14,Services!$C$5:$C$20,0))/30)","v":1},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$14,Services!$C$5:$C$20,0))","v":500},null,{"$f":"References!R6","v":9.081003289473685},null,9.081003289473685,{"$f":"AveHours!F24","v":0},0]
[null,null,{"$f":"Services!$C$18","v":"Post-permanency Advocacy/Case Management"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C15,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C15,Services!$C$5:$C$20,0))/30)","v":1},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C15,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C15,Services!$C$5:$C$20,0))/30)","v":1},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$15,Services!$C$5:$C$20,0))","v":500},null,{"$f":"References!R5","v":26.906378600823047},null,26.906378600823047,{"$f":"AveHours!F23","v":0},0]
[null,null,{"$f":"Services!$C$19","v":"Post-permanency: Support Group"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C16,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C16,Services!$C$5:$C$20,0))/30)","v":3},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C16,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C16,Services!$C$5:$C$20,0))/30)","v":3},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$16,Services!$C$5:$C$20,0))","v":250},null,{"$f":"References!R8","v":9.796153846153846},null,3.2653846153846153,{"$f":"AveHours!F26","v":0},0]
[null,null,{"$f":"Services!$C$20","v":"Post-permanency: Respite"},null,null,{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C17,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C17,Services!$C$5:$C$20,0))/30)","v":1},{"$f":"IF(ISERROR(INDEX(Services!$I$5:$I$20,MATCH($C17,Services!$C$5:$C$20,0))/30),\"n/a\",INDEX(Services!$I$5:$I$20,MATCH($C17,Services!$C$5:$C$20,0))/30)","v":1},{"$f":"INDEX(Services!$H$5:$H$20,MATCH($C$17,Services!$C$5:$C$20,0))","v":300},null,{"$f":"References!R7","v":7.891629297458894},null,7.891629297458894,{"$f":"AveHours!F25","v":0},0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Available Hours:",{"$f":"'Worker Costs_Hours'!J11","v":""},null,"Total Earnings:",{"$f":"Y27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"Annual Workload",null,null,null,null,null,null,null,null,null,"Scheduled Hours:",{"$f":"SUM(H27:X27)","v":0},null,"Total Worker Cost:",{"$f":"'Worker Costs_Hours'!E11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remaining Available Hours:",{"$f":"IF(OR(Z19=\"\",Z19=0),\"\",Z19-Z20)","v":""},null,"Profit/Loss:",{"$f":"AC19-AC20","v":0}]
[]
[null,null,null,null,null,"# of Cases",null,"2020-07-01",null,{"$f":"IF(OR(H23=\"\"),\"\",EDATE(H23,1))","v":"2020-08-01"},null,{"$f":"IF(J23=\"\",\"\",EDATE(J23,1))","v":"2020-09-01"},{"$f":"IF(L23=\"\",\"\",EDATE(L23,1))","v":"2020-10-01"},"2020-11-01","2020-12-01","2021-01-01",null,null,{"$f":"IF(P23=\"\",\"\",EDATE(P23,1))","v":"2021-02-01"},{"$f":"IF(S23=\"\",\"\",EDATE(S23,1))","v":"2021-03-01"},{"$f":"IF(T23=\"\",\"\",EDATE(T23,1))","v":"2021-04-01"},{"$f":"IF(U23=\"\",\"\",EDATE(U23,1))","v":"2021-05-01"},null,{"$f":"IF(V23=\"\",\"\",EDATE(V23,1))","v":"2021-06-01"},"Earnings","Total Cost based on Worker Rate","Profit/Loss based on Worker Rate","Est. Hours","Total Hours","Hrs per Unit of Service"]
[null,null,null,null,null,{"$f":"\"Total = \"&SUM(F25:F26)","v":"Total = 0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"??\",\"(\"&DOLLAR('Worker Costs_Hours'!G14)&\")\")","v":"??"}]
[null,1,"ü","**Select a service**","(FY 21/22)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D25=\"\",D25=\"**Select a service**\",E25=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",IF(OR(C25=\"û\",F25=\"\",F25=0),0,(F25*INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))))))","v":0},{"$f":"IF('Worker Costs_Hours'!$G$14=\"\",\" \",IF(OR(D25=\"\",D25=\"**Select a service**\",E25=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",IF(OR(F25=\"\",F25=0),0,SUM(H25:X25)*'Worker Costs_Hours'!$G$14))))","v":" "},{"$f":"IF($Z$24=\"??\",\" \",IF(OR(D25=\"**Select a service**\",D25=\"\",E25=\"\"),Y25-Z25,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",Y25-Z25)))","v":" "},{"$f":"IF(OR(D25=\"\",D25=\"**Select a service**\",E25=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",F25*(INDEX($M$5:$M$17,MATCH(D25,$C$5:$C$17,0)))))","v":0},{"$f":"IF(OR(D25=\"**Select a service**\",D25=\"\",E25=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",SUM(H25:X25)))","v":0},{"$f":"IF(OR(D25=\"**Select a service**\",D25=\"\",E25=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",IF(OR(F25=0,F25=\"\"),0,AC25/F25)))","v":0}]
[null,null,null,"*****"]
[null,null,null,null,null,null,null,{"$f":"SUM(H25:I26)","v":0},null,{"$f":"SUM(J25:K26)","v":0},null,{"$f":"SUM(L25:L26)","v":0},{"$f":"SUM(M25:M26)","v":0},{"$f":"SUM(N25:N26)","v":0},{"$f":"SUM(O25:O26)","v":0},{"$f":"SUM(P25:P26)","v":0},null,null,{"$f":"SUM(S25:S26)","v":0},{"$f":"SUM(T25:T26)","v":0},{"$f":"SUM(U25:U26)","v":0},{"$f":"SUM(V25:V26)","v":0},null,{"$f":"SUM(X25:X26)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOURS",{"$f":"\"(Total = \"&TEXT(SUM(H27:X27),\"#,##0.0\")&\")\"","v":"(Total = 0.0)"}]
[null,null,null,null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"\",IF(COUNTIF(H27:X27,\">\"&'Worker Costs_Hours'!J12)>0,\"**The Total Hours Available per month (\"&TEXT('Worker Costs_Hours'!J12,\"#,##0.00\")&\") has been exceeded**\",\"\"))","v":""}]
[null,null,"Quarterly Workload"]
[null,null,null,null,null,null,null,null,null,null,null,null,"* # of Cases = ([Hours in quarter] ÷ [Hours in year]) x [# of Cases in year]"]
[null,null,null,"QUARTER 1",null,"# of Cases*",null,{"$f":"H23","v":"2020-07-01"},null,{"$f":"J23","v":"2020-08-01"},null,{"$f":"L23","v":"2020-09-01"},"Earnings","Total Cost based on Worker Rate","Profit/Loss based on Worker Rate",null,null,null,"QUARTER 2",null,null,null,null,"# of Cases*",{"$f":"M23","v":"2020-10-01"},{"$f":"N23","v":"2020-11-01"},{"$f":"O23","v":"2020-12-01"},"Earnings","Total Cost based on Worker Rate","Profit/Loss based on Worker Rate"]
[null,null,null,null,null,{"$f":"\"Total = \"&TEXT(SUM(F34:F35),\"0.00\")","v":"Total = 0.00"},null,null,null,null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"??\",\"(\"&DOLLAR('Worker Costs_Hours'!G14)&\")\")","v":"??"},null,null,null,null,null,null,null,null,null,{"$f":"\"Total = \"&TEXT(SUM(X34:X35),\"0.00\")","v":"Total = 0.00"},null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"??\",\"(\"&DOLLAR('Worker Costs_Hours'!G14)&\")\")","v":"??"}]
[null,null,{"$f":"C25","v":"ü"},{"$f":"IF(OR(D25=\"**Select a service**\",D25=\"\"),\"\",D25)","v":""},{"$f":"IF(OR(E25=\"**Select a service**\",E25=\"\"),\"\",E25)","v":"(FY 21/22)"},{"$f":"IF(OR(F25=\"\",F25=0,SUM(H25:X25)=0),\"\",(SUM(H34:L34)/SUM(H25:X25))*F25)","v":""},null,{"$f":"H25","v":0},null,{"$f":"J25","v":0},null,{"$f":"L25","v":0},{"$f":"IF(OR(D34=\"\",E34=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",IF(OR(C34=\"û\",F34=\"\",F34=0),0,F34*INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0)))))","v":0},{"$f":"IF($N$33=\"??\",\" \",IF(OR(D34=\"\",E34=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",IF(OR(F34=\"\",F34=0),0,SUM(H34:L34)*'Worker Costs_Hours'!$G$14))))","v":" "},{"$f":"IF($Z$24=\"??\",\" \",IF(OR(D34=\"\",E34=\"\"),M34-N34,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",M34-N34)))","v":" "},null,null,{"$f":"C25","v":"ü"},{"$f":"IF(OR(D25=\"**Select a service**\",D25=\"\"),\"\",D25)","v":""},null,null,null,{"$f":"IF(OR(E25=\"**Select a service**\",E25=\"\"),\"\",E25)","v":"(FY 21/22)"},{"$f":"IF(OR(F25=\"\",F25=0,SUM(H25:X25)=0),\"\",(SUM(Y34:AA34)/SUM(H25:X25))*F25)","v":""},{"$f":"M25","v":0},0,0,{"$f":"IF(OR(S34=\"\",W34=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",IF(OR(R34=\"û\",X34=\"\",X34=0),0,X34*INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0)))))","v":0},{"$f":"IF($AC$33=\"??\",\" \",IF(OR(S34=\"\",W34=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",IF(OR(X34=\"\",X34=0),0,SUM(Y34:AA34)*'Worker Costs_Hours'!$G$14))))","v":" "},{"$f":"IF($Z$24=\"??\",\" \",IF(OR(S34=\"\",W34=\"\"),AB34-AC34,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",AB34-AC34)))","v":" "}]
[null,null,null,"*",null,null,null,null,null,null,null,null,null,null,null,null,null,"**"]
[null,null,null,null,null,null,null,{"$f":"SUM(H34:H35)","v":0},null,{"$f":"SUM(J34:J35)","v":0},null,{"$f":"SUM(L34:L35)","v":0},{"$f":"SUM(M34:M35)","v":0},{"$f":"SUM(N34:N35)","v":0},{"$f":"SUM(O34:O35)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y34:Y35)","v":0},0,0,0,0,0]
[]
[]
[null,null,null,"QUARTER 3",null,"# of Cases*",null,{"$f":"P23","v":"2021-01-01"},null,{"$f":"P23","v":"2021-01-01"},null,{"$f":"S23","v":"2021-02-01"},"Earnings","Total Cost based on Worker Rate","Profit/Loss based on Worker Rate",null,null,null,"QUARTER 4",null,null,null,null,"# of Cases*",{"$f":"U23","v":"2021-04-01"},{"$f":"V23","v":"2021-05-01"},{"$f":"X23","v":"2021-06-01"},"Earnings","Total Cost based on Worker Rate","Profit/Loss based on Worker Rate"]
[null,null,null,null,null,{"$f":"\"Total = \"&TEXT(SUM(G41:G42),\"0.00\")","v":"Total = 0.00"},null,null,null,null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"??\",\"(\"&DOLLAR('Worker Costs_Hours'!G14)&\")\")","v":"??"},null,null,null,null,null,null,null,null,null,{"$f":"\"Total = \"&TEXT(SUM(X41:X42),\"0.00\")","v":"Total = 0.00"},null,null,null,null,{"$f":"IF('Worker Costs_Hours'!G14=\"\",\"??\",\"(\"&DOLLAR('Worker Costs_Hours'!G14)&\")\")","v":"??"}]
[null,null,{"$f":"C25","v":"ü"},{"$f":"IF(OR(D25=\"**Select a service**\",D25=\"\"),\"\",D25)","v":""},{"$f":"IF(OR(E25=\"**Select a service**\",E25=\"\"),\"\",E25)","v":"(FY 21/22)"},{"$f":"IF(OR(F25=\"\",F25=0,SUM(H25:X25)=0),\"\",(SUM(H41:L41)/SUM(H25:X25))*F25)","v":""},null,{"$f":"P25","v":0},null,{"$f":"S25","v":0},null,{"$f":"T25","v":0},{"$f":"IF(OR(D41=\"\",E41=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",IF(OR(C41=\"û\",F41=\"\",F41=0),0,F41*INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0)))))","v":0},{"$f":"IF($N$40=\"??\",\" \",IF(OR(D41=\"\",E41=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",IF(OR(F41=\"\",F41=0),0,SUM(H41:L41)*'Worker Costs_Hours'!$G$14))))","v":" "},{"$f":"IF($Z$24=\"??\",\" \",IF(OR(D41=\"\",E41=\"\"),M41-N41,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",M41-N41)))","v":" "},null,null,{"$f":"C25","v":"ü"},{"$f":"IF(OR(D25=\"**Select a service**\",D25=\"\"),\"\",D25)","v":""},null,null,null,{"$f":"IF(OR(E25=\"**Select a service**\",E25=\"\"),\"\",E25)","v":"(FY 21/22)"},{"$f":"IF(OR(F25=\"\",F25=0,SUM(H25:X25)=0),\"\",(SUM(Y41:AA41)/SUM(H25:X25))*F25)","v":""},{"$f":"U25","v":0},{"$f":"V25","v":0},{"$f":"X25","v":0},{"$f":"IF(OR(S41=\"\",W41=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",IF(OR(R41=\"û\",X41=\"\",X41=0),0,X41*INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0)))))","v":0},{"$f":"IF($AC$40=\"??\",\" \",IF(OR(S41=\"\",W41=\"\"),0,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",IF(OR(X41=\"\",X41=0),0,SUM(Y41:AA41)*'Worker Costs_Hours'!$G$14))))","v":" "},{"$f":"IF($Z$24=\"??\",\" \",IF(OR(S41=\"\",W41=\"\"),AB41-AC41,IF(INDEX(References!$F$3:$F$67,MATCH(D25&\" \"&E25,References!$B$3:$B$67,0))=\"N/A\",\"N/A\",AB41-AC41)))","v":" "}]
[null,null,null,"***",null,null,null,null,null,null,null,null,null,null,null,null,null,"****"]
[null,null,null,null,null,null,null,{"$f":"SUM(H41:H42)","v":0},null,{"$f":"SUM(J41:J42)","v":0},null,{"$f":"SUM(L41:L42)","v":0},{"$f":"SUM(M41:M42)","v":0},{"$f":"SUM(N41:N42)","v":0},{"$f":"SUM(O41:O42)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y41:Y42)","v":0},0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"**Select a service**"]

{"sheet":"References","index":6,"n_rows":67,"n_cols":168,"rows_kept":67,"cut":false,"hidden":true,"merged":[[66,1,66,2],[66,3,66,4],[66,5,66,6],[63,3,63,4],[63,5,63,6],[64,1,64,2],[64,3,64,4],[64,5,64,6],[65,1,65,2],[65,3,65,4],[65,5,65,6],[63,1,63,2],[46,5,46,6],[47,1,47,2],[42,1,42,2],[42,3,42,4],[42,5,42,6],[43,1,43,2],[59,3,59,4],[59,5,59,6],[60,1,60,2],[60,3,60,4],[60,5,60,6],[51,3,51,4],[51,5,51,6],[52,1,52,2],[52,3,52,4],[52,5,52,6],[53,1,53,2],[53,3,53,4],[53,5,53,6],[47,3,47,4],[47,5,47,6],[48,1,48,2],[48,3,48,4],[48,5,48,6],[49,1,49,2],[49,3,49,4],[49,5,49,6],[29,1,29,2],[29,3,29,4],[29,5,29,6],[37,1,37,2],[37,3,37,4],[37,5,37,6],[31,3,31,4],[31,5,31,6],[32,1,32,2],[32,3,32,4],[32,5,32,6],[33,1,33,2],[33,3,33,4],[33,5,33,6],[34,1,34,2],[34,3,34,4],[34,5,34,6],[35,1,35,2],[35,3,35,4],[35,5,35,6],[36,1,36,2],[30,1,30,2],[30,3,30,4],[30,5,30,6],[31,1,31,2],[18,3,18,4],[18,5,18,6],[19,1,19,2],[19,3,19,4],[19,5,19,6],[20,1,20,2],[20,3,20,4],[20,5,20,6],[22,1,22,2],[22,3,22,4],[22,5,22,6],[23,1,23,2],[27,3,27,4],[27,5,27,6],[28,1,28,2],[28,3,28,4],[28,5,28,6],[23,3,23,4],[50,1,50,2],[50,3,50,4],[50,5,50,6],[51,1,51,2],[46,1,46,2],[46,3,46,4],[10,3,10,4],[10,5,10,6],[11,1,11,2],[11,3,11,4],[11,5,11,6],[14,3,14,4],[14,5,14,6],[15,1,15,2],[15,3,15,4],[15,5,15,6],[16,1,16,2],[16,3,16,4],[16,5,16,6],[12,3,12,4],[12,5,12,6],[12,1,12,2],[36,3,36,4],[36,5,36,6],[62,1,62,2],[62,3,62,4],[62,5,62,6],[58,1,58,2],[58,3,58,4],[58,5,58,6],[59,1,59,2],[54,1,54,2],[54,3,54,4],[54,5,54,6],[55,1,55,2],[61,1,61,2],[61,3,61,4],[61,5,61,6],[55,3,55,4],[55,5,55,6],[56,1,56,2],[56,3,56,4],[56,5,56,6],[57,1,57,2],[57,3,57,4],[57,5,57,6],[38,1,38,2],[38,3,38,4],[38,5,38,6],[39,1,39,2],[43,3,43,4],[43,5,43,6],[44,1,44,2],[44,3,44,4],[44,5,44,6],[41,3,41,4],[41,5,41,6],[45,1,45,2],[45,3,45,4],[45,5,45,6],[39,3,39,4],[39,5,39,6],[40,1,40,2],[40,3,40,4],[40,5,40,6],[41,1,41,2],[0,3,0,4],[21,3,21,4],[21,5,21,6],[17,1,17,2],[17,3,17,4],[17,5,17,6],[18,1,18,2],[13,1,13,2],[13,3,13,4],[13,5,13,6],[14,1,14,2],[0,5,0,6],[2,1,2,2],[2,3,2,4],[2,5,2,6],[3,1,3,2],[10,1,10,2],[3,5,3,6],[6,3,6,4],[6,5,6,6],[7,1,7,2],[7,3,7,4],[7,5,7,6],[8,1,8,2],[3,3,3,4],[27,1,27,2],[5,1,5,2],[5,3,5,4],[5,5,5,6],[6,1,6,2],[4,1,4,2],[4,3,4,4],[4,5,4,6],[23,5,23,6],[24,1,24,2],[24,3,24,4],[24,5,24,6],[25,1,25,2],[25,3,25,4],[25,5,25,6],[26,1,26,2],[26,3,26,4],[26,5,26,6],[8,3,8,4],[8,5,8,6],[9,1,9,2],[9,3,9,4],[9,5,9,6]]}
[null,"Service",null,"Days to Complete",null,"Rate",null,"Hours¹","Rate/hour¹","Months","Hours Per Month"]
[null,"**Select a service**",null,null,null,null,null,null,null,null,null,null,"2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01","2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01","2026-06-01","2026-07-01","2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01","2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01","2027-06-01","2027-07-01","2027-08-01","2027-09-01","2027-10-01","2027-11-01","2027-12-01","2028-01-01","2028-02-01","2028-03-01","2028-04-01","2028-05-01","2028-06-01","2028-07-01","2028-08-01","2028-09-01","2028-10-01","2028-11-01","2028-12-01","2029-01-01","2029-02-01","2029-03-01","2029-04-01","2029-05-01","2029-06-01","2029-07-01","2029-08-01","2029-09-01","2029-10-01","2029-11-01","2029-12-01","2030-01-01","2030-02-01","2030-03-01","2030-04-01","2030-05-01","2030-06-01","2030-07-01","2030-08-01","2030-09-01","2030-10-01","2030-11-01","2030-12-01"]
[{"$f":"\"*\"&L3","v":"*(FY 22/23)"},{"$f":"$N$5&\" \"&L3","v":"Adoption Finalization Extension (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B3,FIND(\"(\",$B3)-2),Services!$C$5:$M$20,11,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B3,FIND(\"(\",$B3)-2),Services!$C$5:$M$20,10,FALSE)","v":1250},null,null,null,{"$f":"IF(D3=\"n/a\",\"n/a\",D3/30)","v":4},{"$f":"IF(ISERROR(H3/J3),\"n/a\",H3/J3)","v":0},"(FY 22/23)"]
[{"$f":"L4","v":"(FY 21/22)"},{"$f":"$N$5&\" \"&L4","v":"Adoption Finalization Extension (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B4,FIND(\"(\",B4)-2),Services!$C$5:$M$20,9,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B4,FIND(\"(\",$B4)-2),Services!$C$5:$M$20,8,FALSE)","v":1250},null,null,null,{"$f":"IF(D4=\"n/a\",\"n/a\",D4/30)","v":4},{"$f":"IF(ISERROR(H4/J4),\"n/a\",H4/J4)","v":0},"(FY 21/22)","Affiliate","Benchmark Type","Average Time",null,"Benchmark Type","Average Time"]
[{"$f":"L5","v":"(FY 20/21)"},{"$f":"$N$5&\" \"&L5","v":"Adoption Finalization Extension (FY 20/21)"},null,{"$f":"VLOOKUP(LEFT(B5,FIND(\"(\",B5)-2),Services!$C$5:$M$20,7,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B5,FIND(\"(\",$B5)-2),Services!$C$5:$M$20,6,FALSE)","v":1200},null,null,null,4,0,"(FY 20/21)","Statewide","Adoption Finalization Extension",20.046822742474916,null,"Post-permanency Advocacy/Case Management",26.906378600823047]
[{"$f":"L6","v":"(FY 19/20)"},{"$f":"$N$5&\" \"&L6","v":"Adoption Finalization Extension (FY 19/20)"},null,{"$f":"VLOOKUP(LEFT(B6,FIND(\"(\",B6)-2),Services!$C$5:$M$20,5,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B6,FIND(\"(\",$B6)-2),Services!$C$5:$M$20,4,FALSE)","v":1475},null,null,null,4,0,"(FY 19/20)",null,"Child Preparation",42.702392231170059,null,"Post-permanency Advocacy/Assessment",9.081003289473685]
[{"$f":"L7","v":"(FY 18/19)"},{"$f":"$N$5&\" \"&L7","v":"Adoption Finalization Extension (FY 18/19)"},null,{"$f":"VLOOKUP(LEFT(B7,FIND(\"(\",B7)-2),Services!$C$5:$M$20,3,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B7,FIND(\"(\",$B7)-2),Services!$C$5:$M$20,2,FALSE)","v":1600},null,null,null,4,0,"(FY 18/19)",null,"Child Profile",35.362185952686595,null,"Post-permanency: Respite",7.891629297458894]
[{"$f":"\"*\"&L3","v":"*(FY 22/23)"},{"$f":"$N$6&\" \"&L3","v":"Child Preparation (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B8,FIND(\"(\",$B8)-2),Services!$C$5:$M$20,11,FALSE)","v":180},null,{"$f":"VLOOKUP(LEFT($B8,FIND(\"(\",$B8)-2),Services!$C$5:$M$20,10,FALSE)","v":2900},null,null,null,6,0,null,null,"Child Profile Addendum",26.710510328068043,null,"Post-permanency: Support Group",9.796153846153846]
[{"$f":"IF(RIGHT(B9,3)<>\"21)\",MID(B9,FIND(\"(\",B9)+1,8),IF(RIGHT(B9,3)=\"21)\",\"*\"&MID(B9,FIND(\"(\",B9)+1,8),\"\"))","v":"FY 21/22"},{"$f":"$N$6&\" \"&L4","v":"Child Preparation (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B9,FIND(\"(\",B9)-2),Services!$C$5:$M$20,9,FALSE)","v":180},null,{"$f":"VLOOKUP(LEFT($B9,FIND(\"(\",$B9)-2),Services!$C$5:$M$20,8,FALSE)","v":2900},null,null,null,6,0,null,null,"Child Specific Recruitment",43.007209499575914]
["*FY 20/21",{"$f":"$N$6&\" \"&L5","v":"Child Preparation (FY 20/21)"},null,{"$f":"VLOOKUP(LEFT(B10,FIND(\"(\",B10)-2),Services!$C$5:$M$20,7,FALSE)","v":180},null,{"$f":"VLOOKUP(LEFT($B10,FIND(\"(\",$B10)-2),Services!$C$5:$M$20,6,FALSE)","v":2900},null,null,null,6,0,null,null,"Finalization",48.876821814762579]
["FY 19/20",{"$f":"$N$6&\" \"&L6","v":"Child Preparation (FY 19/20)"},null,{"$f":"VLOOKUP(LEFT(B11,FIND(\"(\",B11)-2),Services!$C$5:$M$20,5,FALSE)","v":180},null,{"$f":"VLOOKUP(LEFT($B11,FIND(\"(\",$B11)-2),Services!$C$5:$M$20,4,FALSE)","v":2900},null,null,null,6,0,null,null,"Placement",27.374683544303796]
["FY 18/19",{"$f":"$N$6&\" \"&L7","v":"Child Preparation (FY 18/19)"},null,{"$f":"VLOOKUP(LEFT(B12,FIND(\"(\",B12)-2),Services!$C$5:$M$20,3,FALSE)","v":180},null,{"$f":"VLOOKUP(LEFT($B12,FIND(\"(\",$B12)-2),Services!$C$5:$M$20,2,FALSE)","v":2600},null,null,null,6,0,null,null,"Family Profile/Preparation",38.659925093632957]
["FY 22/23",{"$f":"$N$7&\" \"&L3","v":"Child Profile (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B13,FIND(\"(\",$B13)-2),Services!$C$5:$M$20,11,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B13,FIND(\"(\",$B13)-2),Services!$C$5:$M$20,10,FALSE)","v":2100},null,null,null,3,0,null,null,"Family Profile/Preparation Addendum",37.56203007518797]
["FY 21/22",{"$f":"$N$7&\" \"&L4","v":"Child Profile (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B14,FIND(\"(\",B14)-2),Services!$C$5:$M$20,9,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B14,FIND(\"(\",$B14)-2),Services!$C$5:$M$20,8,FALSE)","v":2100},null,null,null,3,0]
["*FY 20/21",{"$f":"$N$7&\" \"&L5","v":"Child Profile (FY 20/21)"},null,{"$f":"VLOOKUP(LEFT(B15,FIND(\"(\",B15)-2),Services!$C$5:$M$20,7,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B15,FIND(\"(\",$B15)-2),Services!$C$5:$M$20,6,FALSE)","v":2100},null,null,null,3,0]
["FY 19/20",{"$f":"$N$7&\" \"&L6","v":"Child Profile (FY 19/20)"},null,{"$f":"VLOOKUP(LEFT(B16,FIND(\"(\",B16)-2),Services!$C$5:$M$20,5,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B16,FIND(\"(\",$B16)-2),Services!$C$5:$M$20,4,FALSE)","v":1800},null,null,null,3,0]
["FY 18/19",{"$f":"$N$7&\" \"&L7","v":"Child Profile (FY 18/19)"},null,{"$f":"VLOOKUP(LEFT(B17,FIND(\"(\",B17)-2),Services!$C$5:$M$20,3,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B17,FIND(\"(\",$B17)-2),Services!$C$5:$M$20,2,FALSE)","v":1900},null,null,null,3,0,null,"Average Hours","Worker Hours","Prop Sch","Schedule",{"$f":"N5","v":"Adoption Finalization Extension"},null,"Worker"]
["FY 22/23",{"$f":"$N$8&\" \"&L3","v":"Child Profile Addendum (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B18,FIND(\"(\",$B18)-2),Services!$C$5:$M$20,11,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B18,FIND(\"(\",$B18)-2),Services!$C$5:$M$20,10,FALSE)","v":1600},null,null,null,3,0,null,0,0,0,0,{"$f":"N6","v":"Child Preparation"},null,"Consultant"]
["FY 21/22",{"$f":"N8&\" \"&L4","v":"Child Profile Addendum (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B19,FIND(\"(\",B19)-2),Services!$C$5:$M$20,9,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B19,FIND(\"(\",$B19)-2),Services!$C$5:$M$20,8,FALSE)","v":1600},null,null,null,3,0,null,null,"PT","FT",null,"Child Profile"]
["*FY 20/21",{"$f":"N8&\" \"&L5","v":"Child Profile Addendum (FY 20/21)"},null,{"$f":"VLOOKUP(LEFT(B20,FIND(\"(\",B20)-2),Services!$C$5:$M$20,7,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B20,FIND(\"(\",$B20)-2),Services!$C$5:$M$20,6,FALSE)","v":1350},null,null,null,3,0,null,"Weeks/Year",null,52,null,"Child Profile Addendum"]
["FY 19/20",{"$f":"N8&\" \"&L6","v":"Child Profile Addendum (FY 19/20)"},null,{"$f":"VLOOKUP(LEFT(B21,FIND(\"(\",B21)-2),Services!$C$5:$M$20,5,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B21,FIND(\"(\",$B21)-2),Services!$C$5:$M$20,4,FALSE)","v":500},null,null,null,3,0,null,"Days/Week",null,40,null,"Child Specific Recruitment"]
["FY 18/19",{"$f":"N8&\" \"&L7","v":"Child Profile Addendum (FY 18/19)"},null,{"$f":"VLOOKUP(LEFT(B22,FIND(\"(\",B22)-2),Services!$C$5:$M$20,3,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B22,FIND(\"(\",$B22)-2),Services!$C$5:$M$20,2,FALSE)","v":500},null,null,null,3,0,null,"Less PTO days/year",null,10,null,"Finalization"]
["FY 22/23",{"$f":"$N$9&\" \"&L3","v":"Child Specific Recruitment (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B23,FIND(\"(\",$B23)-2),Services!$C$5:$M$20,11,FALSE)","v":180},null,{"$f":"VLOOKUP(LEFT($B23,FIND(\"(\",$B23)-2),Services!$C$5:$M$20,10,FALSE)","v":2800},null,null,null,6,0,null,"Less NPH hrs/week",null,10,null,"Placement"]
["FY 21/22",{"$f":"$N$9&\" \"&L4","v":"Child Specific Recruitment (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B24,FIND(\"(\",B24)-2),Services!$C$5:$M$20,9,FALSE)","v":180},null,{"$f":"VLOOKUP(LEFT($B24,FIND(\"(\",$B24)-2),Services!$C$5:$M$20,8,FALSE)","v":2800},null,null,null,6,0,null,"Total Available Hours",null,1520,null,"Family Profile/Preparation"]
["*FY 20/21",{"$f":"$N$9&\" \"&L5","v":"Child Specific Recruitment (FY 20/21)"},null,{"$f":"VLOOKUP(LEFT(B25,FIND(\"(\",B25)-2),Services!$C$5:$M$20,7,FALSE)","v":180},null,{"$f":"VLOOKUP(LEFT($B25,FIND(\"(\",$B25)-2),Services!$C$5:$M$20,6,FALSE)","v":2800},null,null,null,6,0,null,null,null,null,null,"Family Profile/Preparation Addendum"]
["FY 19/20",{"$f":"$N$9&\" \"&L6","v":"Child Specific Recruitment (FY 19/20)"},null,{"$f":"VLOOKUP(LEFT(B26,FIND(\"(\",B26)-2),Services!$C$5:$M$20,5,FALSE)","v":180},null,{"$f":"VLOOKUP(LEFT($B26,FIND(\"(\",$B26)-2),Services!$C$5:$M$20,4,FALSE)","v":3150},null,null,null,6,0,null,null,null,null,null,{"$f":"Q5","v":"Post-permanency Advocacy/Case Management"}]
["FY 18/19",{"$f":"$N$9&\" \"&L7","v":"Child Specific Recruitment (FY 18/19)"},null,{"$f":"VLOOKUP(LEFT(B27,FIND(\"(\",B27)-2),Services!$C$5:$M$20,3,FALSE)","v":180},null,{"$f":"VLOOKUP(LEFT($B27,FIND(\"(\",$B27)-2),Services!$C$5:$M$20,2,FALSE)","v":1850},null,null,null,6,0,null,null,null,null,null,{"$f":"Q6","v":"Post-permanency Advocacy/Assessment"}]
["FY 22/23",{"$f":"$N$10&\" \"&L3","v":"Finalization (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B28,FIND(\"(\",$B28)-2),Services!$C$5:$M$20,11,FALSE)","v":240},null,{"$f":"VLOOKUP(LEFT($B28,FIND(\"(\",$B28)-2),Services!$C$5:$M$20,10,FALSE)","v":2400},null,null,null,8,0,null,null,null,null,null,"Post-permanency: Respite"]
["FY 21/22",{"$f":"$N$10&\" \"&L4","v":"Finalization (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B29,FIND(\"(\",B29)-2),Services!$C$5:$M$20,9,FALSE)","v":240},null,{"$f":"VLOOKUP(LEFT($B29,FIND(\"(\",$B29)-2),Services!$C$5:$M$20,8,FALSE)","v":2400},null,null,null,8,0,null,null,null,null,null,"Post-permanency: Support Group"]
["*FY 20/21","Finalization (FY 20/21)",null,{"$f":"VLOOKUP(LEFT(B30,FIND(\"(\",B30)-2),Services!$C$5:$M$20,7,FALSE)","v":240},null,{"$f":"VLOOKUP(LEFT($B30,FIND(\"(\",$B30)-2),Services!$C$5:$M$20,6,FALSE)","v":2250},null,null,null,8,0,null,"Part Time"]
["FY 19/20","Finalization (FY 19/20)",null,{"$f":"VLOOKUP(LEFT(B31,FIND(\"(\",B31)-2),Services!$C$5:$M$20,5,FALSE)","v":240},null,{"$f":"VLOOKUP(LEFT($B31,FIND(\"(\",$B31)-2),Services!$C$5:$M$20,4,FALSE)","v":2950},null,null,null,8,0]
["FY 18/19","Finalization (FY 18/19)",null,{"$f":"VLOOKUP(LEFT(B32,FIND(\"(\",B32)-2),Services!$C$5:$M$20,3,FALSE)","v":240},null,{"$f":"VLOOKUP(LEFT($B32,FIND(\"(\",$B32)-2),Services!$C$5:$M$20,2,FALSE)","v":3200},null,null,null,8,0]
["FY 22/23",{"$f":"$N$11&\" \"&L3","v":"Placement (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B33,FIND(\"(\",$B33)-2),Services!$C$5:$M$20,11,FALSE)","v":"n/a"},null,{"$f":"VLOOKUP(LEFT($B33,FIND(\"(\",$B33)-2),Services!$C$5:$M$20,10,FALSE)","v":2300},null,null,null,"n/a","n/a"]
["FY 21/22",{"$f":"$N$11&\" \"&L4","v":"Placement (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B34,FIND(\"(\",B34)-2),Services!$C$5:$M$20,9,FALSE)","v":"n/a"},null,{"$f":"VLOOKUP(LEFT($B34,FIND(\"(\",$B34)-2),Services!$C$5:$M$20,8,FALSE)","v":2300},null,null,null,"n/a","n/a"]
["*FY 20/21","Placement (FY 20/21)",null,{"$f":"VLOOKUP(LEFT(B35,FIND(\"(\",B35)-2),Services!$C$5:$M$20,7,FALSE)","v":"n/a"},null,{"$f":"VLOOKUP(LEFT($B35,FIND(\"(\",$B35)-2),Services!$C$5:$M$20,6,FALSE)","v":1950},null,null,null,"n/a","n/a"]
["FY 19/20","Placement (FY 19/20)",null,{"$f":"VLOOKUP(LEFT(B36,FIND(\"(\",B36)-2),Services!$C$5:$M$20,5,FALSE)","v":"n/a"},null,{"$f":"VLOOKUP(LEFT($B36,FIND(\"(\",$B36)-2),Services!$C$5:$M$20,4,FALSE)","v":2700},null,null,null,"n/a","n/a"]
["FY 18/19","Placement (FY 18/19)",null,{"$f":"VLOOKUP(LEFT(B37,FIND(\"(\",B37)-2),Services!$C$5:$M$20,3,FALSE)","v":"n/a"},null,{"$f":"VLOOKUP(LEFT($B37,FIND(\"(\",$B37)-2),Services!$C$5:$M$20,2,FALSE)","v":2700},null,null,null,"n/a","n/a"]
["FY 22/23",{"$f":"$N$12&\" \"&L3","v":"Family Profile/Preparation (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B38,FIND(\"(\",$B38)-2),Services!$C$5:$M$20,11,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B38,FIND(\"(\",$B38)-2),Services!$C$5:$M$20,10,FALSE)","v":2950},null,null,null,4,0]
["FY 21/22",{"$f":"$N$12&\" \"&L4","v":"Family Profile/Preparation (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B39,FIND(\"(\",B39)-2),Services!$C$5:$M$20,9,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B39,FIND(\"(\",$B39)-2),Services!$C$5:$M$20,8,FALSE)","v":2950},null,null,null,4,0]
["*FY 20/21","Family Profile/Preparation (FY 20/21)",null,{"$f":"VLOOKUP(LEFT(B40,FIND(\"(\",B40)-2),Services!$C$5:$M$20,7,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B40,FIND(\"(\",$B40)-2),Services!$C$5:$M$20,6,FALSE)","v":2700},null,null,null,4,0]
["FY 19/20","Family Profile/Preparation (FY 19/20)",null,{"$f":"VLOOKUP(LEFT(B41,FIND(\"(\",B41)-2),Services!$C$5:$M$20,5,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B41,FIND(\"(\",$B41)-2),Services!$C$5:$M$20,4,FALSE)","v":2400},null,null,null,4,0]
["FY 18/19","Family Profile/Preparation (FY 18/19)",null,{"$f":"VLOOKUP(LEFT(B42,FIND(\"(\",B42)-2),Services!$C$5:$M$20,3,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B42,FIND(\"(\",$B42)-2),Services!$C$5:$M$20,2,FALSE)","v":2800},null,null,null,4,0]
["FY 22/23",{"$f":"$N$13&\" \"&L3","v":"Family Profile/Preparation Addendum (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B43,FIND(\"(\",$B43)-2),Services!$C$5:$M$20,11,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B43,FIND(\"(\",$B43)-2),Services!$C$5:$M$20,10,FALSE)","v":1650},null,null,null,4,0]
["FY 21/22",{"$f":"$N$13&\" \"&L4","v":"Family Profile/Preparation Addendum (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B44,FIND(\"(\",B44)-2),Services!$C$5:$M$20,9,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B44,FIND(\"(\",$B44)-2),Services!$C$5:$M$20,8,FALSE)","v":1650},null,null,null,4,0]
["*FY 20/21","Family Profile/Preparation Addendum (FY 20/21)",null,{"$f":"VLOOKUP(LEFT(B45,FIND(\"(\",B45)-2),Services!$C$5:$M$20,7,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B45,FIND(\"(\",$B45)-2),Services!$C$5:$M$20,6,FALSE)","v":1450},null,null,null,4,0]
["FY 19/20","Family Profile/Preparation Addendum (FY 19/20)",null,{"$f":"VLOOKUP(LEFT(B46,FIND(\"(\",B46)-2),Services!$C$5:$M$20,5,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B46,FIND(\"(\",$B46)-2),Services!$C$5:$M$20,4,FALSE)","v":500},null,null,null,4,0]
["FY 18/19","Family Profile/Preparation Addendum (FY 18/19)",null,{"$f":"VLOOKUP(LEFT(B47,FIND(\"(\",B47)-2),Services!$C$5:$M$20,3,FALSE)","v":120},null,{"$f":"VLOOKUP(LEFT($B47,FIND(\"(\",$B47)-2),Services!$C$5:$M$20,2,FALSE)","v":500},null,null,null,4,0]
["FY 22/23",{"$f":"$Q$5&\" \"&L3","v":"Post-permanency Advocacy/Case Management (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B48,FIND(\"(\",$B48)-2),Services!$C$5:$M$20,11,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B48,FIND(\"(\",$B48)-2),Services!$C$5:$M$20,10,FALSE)","v":500},null,null,null,1,0]
["FY 21/22",{"$f":"$Q$5&\" \"&L4","v":"Post-permanency Advocacy/Case Management (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B49,FIND(\"(\",B49)-2),Services!$C$5:$M$20,9,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B49,FIND(\"(\",$B49)-2),Services!$C$5:$M$20,8,FALSE)","v":500},null,null,null,1,0]
["*FY 20/21","Post-permanency Advocacy/Case Management (FY 20/21)",null,{"$f":"VLOOKUP(LEFT(B50,FIND(\"(\",B50)-2),Services!$C$5:$M$20,7,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B50,FIND(\"(\",$B50)-2),Services!$C$5:$M$20,6,FALSE)","v":500},null,null,null,1,0]
["FY 19/20","Post-permanency Advocacy/Case Management (FY 19/20)",null,{"$f":"VLOOKUP(LEFT(B51,FIND(\"(\",B51)-2),Services!$C$5:$M$20,5,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B51,FIND(\"(\",$B51)-2),Services!$C$5:$M$20,4,FALSE)","v":500},null,null,null,1,0]
["FY 18/19","Post-permanency Advocacy/Case Management (FY 18/19)",null,{"$f":"VLOOKUP(LEFT(B52,FIND(\"(\",B52)-2),Services!$C$5:$M$20,3,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B52,FIND(\"(\",$B52)-2),Services!$C$5:$M$20,2,FALSE)","v":500},null,null,null,1,0]
["FY 22/23",{"$f":"$Q$6&\" \"&L3","v":"Post-permanency Advocacy/Assessment (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B53,FIND(\"(\",$B53)-2),Services!$C$5:$M$20,11,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B53,FIND(\"(\",$B53)-2),Services!$C$5:$M$20,10,FALSE)","v":500},null,null,null,1,0]
["FY 21/22",{"$f":"$Q$6&\" \"&L4","v":"Post-permanency Advocacy/Assessment (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B54,FIND(\"(\",B54)-2),Services!$C$5:$M$20,9,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B54,FIND(\"(\",$B54)-2),Services!$C$5:$M$20,8,FALSE)","v":500},null,null,null,1,0]
["*FY 20/21","Post-permanency Advocacy/Assessment (FY 20/21)",null,{"$f":"VLOOKUP(LEFT(B55,FIND(\"(\",B55)-2),Services!$C$5:$M$20,7,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B55,FIND(\"(\",$B55)-2),Services!$C$5:$M$20,6,FALSE)","v":500},null,null,null,1,0]
["FY 19/20","Post-permanency Advocacy/Assessment (FY 19/20)",null,{"$f":"VLOOKUP(LEFT(B56,FIND(\"(\",B56)-2),Services!$C$5:$M$20,5,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B56,FIND(\"(\",$B56)-2),Services!$C$5:$M$20,4,FALSE)","v":500},null,null,null,1,0]
["FY 18/19","Post-permanency Advocacy/Assessment (FY 18/19)",null,{"$f":"VLOOKUP(LEFT(B57,FIND(\"(\",B57)-2),Services!$C$5:$M$20,3,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B57,FIND(\"(\",$B57)-2),Services!$C$5:$M$20,2,FALSE)","v":500},null,null,null,1,0]
["FY 22/23",{"$f":"$Q$8&\" \"&L3","v":"Post-permanency: Support Group (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B58,FIND(\"(\",$B58)-2),Services!$C$5:$M$20,11,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B58,FIND(\"(\",$B58)-2),Services!$C$5:$M$20,10,FALSE)","v":250},null,null,null,3,0]
["FY 21/22",{"$f":"$Q$8&\" \"&L4","v":"Post-permanency: Support Group (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B59,FIND(\"(\",B59)-2),Services!$C$5:$M$20,9,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B59,FIND(\"(\",$B59)-2),Services!$C$5:$M$20,8,FALSE)","v":250},null,null,null,3,0]
["*FY 20/21","Post-permanency: Support Group (FY 20/21)",null,{"$f":"VLOOKUP(LEFT(B60,FIND(\"(\",B60)-2),Services!$C$5:$M$20,7,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B60,FIND(\"(\",$B60)-2),Services!$C$5:$M$20,6,FALSE)","v":250},null,null,null,3,0]
["FY 19/20","Post-permanency: Support Group (FY 19/20)",null,{"$f":"VLOOKUP(LEFT(B61,FIND(\"(\",B61)-2),Services!$C$5:$M$20,5,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B61,FIND(\"(\",$B61)-2),Services!$C$5:$M$20,4,FALSE)","v":250},null,null,null,3,0]
["FY 18/19","Post-permanency: Support Group (FY 18/19)",null,{"$f":"VLOOKUP(LEFT(B62,FIND(\"(\",B62)-2),Services!$C$5:$M$20,3,FALSE)","v":90},null,{"$f":"VLOOKUP(LEFT($B62,FIND(\"(\",$B62)-2),Services!$C$5:$M$20,2,FALSE)","v":250},null,null,null,3,0]
["FY 22/23",{"$f":"$Q$7&\" \"&L3","v":"Post-permanency: Respite (FY 22/23)"},null,{"$f":"VLOOKUP(LEFT($B63,FIND(\"(\",$B63)-2),Services!$C$5:$M$20,11,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B63,FIND(\"(\",$B63)-2),Services!$C$5:$M$20,10,FALSE)","v":300},null,null,null,1,0]
["FY 21/22",{"$f":"$Q$7&\" \"&L4","v":"Post-permanency: Respite (FY 21/22)"},null,{"$f":"VLOOKUP(LEFT(B64,FIND(\"(\",B64)-2),Services!$C$5:$M$20,9,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B64,FIND(\"(\",$B64)-2),Services!$C$5:$M$20,8,FALSE)","v":300},null,null,null,1,0]
["*FY 20/21","Post-permanency: Respite (FY 20/21)",null,{"$f":"VLOOKUP(LEFT(B65,FIND(\"(\",B65)-2),Services!$C$5:$M$20,7,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B65,FIND(\"(\",$B65)-2),Services!$C$5:$M$20,6,FALSE)","v":300},null,null,null,1,0]
["FY 19/20","Post-permanency: Respite (FY 19/20)",null,{"$f":"VLOOKUP(LEFT(B66,FIND(\"(\",B66)-2),Services!$C$5:$M$20,5,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B66,FIND(\"(\",$B66)-2),Services!$C$5:$M$20,4,FALSE)","v":300},null,null,null,1,0]
["FY 18/19",{"$f":"$Q$7&\" \"&L7","v":"Post-permanency: Respite (FY 18/19)"},null,{"$f":"VLOOKUP(LEFT(B67,FIND(\"(\",B67)-2),Services!$C$5:$M$20,3,FALSE)","v":30},null,{"$f":"VLOOKUP(LEFT($B67,FIND(\"(\",$B67)-2),Services!$C$5:$M$20,2,FALSE)","v":300},null,null,null,{"$f":"IF(D67=\"n/a\",\"n/a\",D67/30)","v":1},0]