{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Program Summary","Annual Data Tracking","Service Provision","Staff Metrics","Employer Relations","Closed Case Archive","v1.3 Update Notes"],"not_rendered":{"charts":26,"images":5,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Program Summary","index":0,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Program Summary"]
[]
["SERVICE PROVISION","CURRENT","BENCHMARK"]
["Total Consumers",{"$f":"'Service Provision'!B504","v":0}]
["Active Consumer Cases",{"$f":"'Service Provision'!D504","v":""},0.9]
["Employment Rate",{"$f":"'Service Provision'!L504","v":""},0.9]
["Average Unemployment",{"$f":"'Service Provision'!G504","v":""},"< 3 months"]
["Average Job Stabilization",{"$f":"'Service Provision'!I504","v":""},"< 3 months"]
["Average Retention",{"$f":"'Service Provision'!M504","v":""},"12+ months"]
[]
["STAFF MANAGEMENT"]
["Total Staff",{"$f":"'Staff Metrics'!B54","v":0}]
["Average Staff Caseload",{"$f":"IFERROR(ROUNDDOWN('Staff Metrics'!N54/'Staff Metrics'!B54, 2),\"\")","v":""}]
["Average Staff Retention",{"$f":"'Staff Metrics'!E55","v":""}]
[]
["EMPLOYER RELATIONS"]
["Total # of Organizations",{"$f":"'Employer Relations'!B54","v":0}]
["% Satisfied with Service",{"$f":"'Employer Relations'!I54","v":""},0.9]
["% Satisfied with Job Coach",{"$f":"'Employer Relations'!J54","v":""},0.9]
["% Satisfied with Employee",{"$f":"'Employer Relations'!K54","v":""},0.9]
["Overall Satisfaction",{"$f":"IFERROR(AVERAGE(B18:B20),\"\")","v":""},0.9]
[]
["% Willing to be a Future Reference",{"$f":"'Employer Relations'!L54","v":""},1]
[]
["CLOSED CASE STATISTICS"]
["Total Closed Cases",{"$f":"'Closed Case Archive'!B504","v":0}]
["Graduated From Service With Job",{"$f":"'Closed Case Archive'!M504","v":""},0.9]
["Average Unemployment",{"$f":"'Closed Case Archive'!G504","v":""},"< 3 months"]
["Average Job Stabilization",{"$f":"'Closed Case Archive'!I504","v":""},"< 3 months"]
["Average Retention",{"$f":"'Closed Case Archive'!N504","v":""},"12+ months"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"CASES v1.3 - 7/2021"]
[null,null,null,null,null,null,null,null,null," Comprehensive Assessment of Supported Employment Service (CASES) companion guide","AVAILABLE HERE"]

{"sheet":"Annual Data Tracking","index":1,"n_rows":139,"n_cols":14,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Annual Data Tracking"]
["FY 2021"]
["SERVICE PROVISION","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sept","Oct","Nov","Dec","CURRENT"]
["Total Consumers",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Service Provision'!B504","v":0}]
["Active Consumer Cases",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Service Provision'!D504","v":""}]
["Employment Rate",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Service Provision'!L504","v":""}]
["Average Unemployment",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Service Provision'!G509","v":""}]
["Average Job Stabilization",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Service Provision'!I509","v":""}]
["Average Retention",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Service Provision'!M509","v":""}]
[]
["STAFF MANAGEMENT","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sept","Oct","Nov","Dec"]
["Total Staff",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Staff Metrics'!B54","v":0}]
["Average Staff Caseload",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUNDDOWN('Staff Metrics'!N54/'Staff Metrics'!B54, 2),\"\")","v":""}]
["Average Staff Retention",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Staff Metrics'!E56","v":""}]
[]
["EMPLOYER RELATIONS","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sept","Oct","Nov","Dec"]
["Total # of Organizations",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Employer Relations'!B54","v":0}]
["% Satisfied with Service",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Employer Relations'!I54","v":""}]
["% Satisfied with Job Coach",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Employer Relations'!J54","v":""}]
["% Satisfied with Employee",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Employer Relations'!K54","v":""}]
["Overall Satisfaction",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N18:N20),\"\")","v":""}]
[]
["% Willing to be a Future Reference",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Employer Relations'!L54","v":""}]
[]
["CLOSED CASE STATISTICS","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sept","Oct","Nov","Dec"]
["Total Closed Cases",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Closed Case Archive'!B504","v":0}]
["Graduated From Service With Job",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Closed Case Archive'!M504","v":""}]
["Average Unemployment",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Closed Case Archive'!G509","v":""}]
["Average Job Stabilization",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Closed Case Archive'!I509","v":""}]
["Average Retention",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Closed Case Archive'!N509","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CASES v1.3 - 7/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null," Comprehensive Assessment of Supported Employment Service (CASES) companion guide","AVAILABLE HERE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SERVICE PROVISION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["STAFF METRICS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["EMPLOYER RELATIONS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CLOSED CASE STATISTICS"]

{"sheet":"Service Provision","index":2,"n_rows":510,"n_cols":19,"rows_kept":510,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Provision"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","N"]
[null,"Consumer","County","Active Case (Y/N)","Referral Date","Employment Start Date","Unemployed Period (Days)","Follow Along Transition Date","Job Stabilization Period (Days)","# of  Re-stabilization Attempts","Employment Terminated","Currently Employed","Retention Period (Days)","Funding Source","Units/Hours Allotted","Units/Hours Used","Units/Hours Remaining","% Complete","# of Vouchers Used"]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D4,\"N\"),\"\",IF(ISBLANK(E4),\"\",IF(ISBLANK(F4),_xlfn.DAYS(TODAY(),E4),_xlfn.DAYS(F4,E4))))","v":""},null,{"$f":"IF(COUNTIF(D4,\"N\"),\"\",IF(ISBLANK(F4),\"\",IF(ISBLANK(H4),IF(ISBLANK(K4),_xlfn.DAYS(TODAY(),F4),_xlfn.DAYS(K4,F4)),_xlfn.DAYS(H4,F4))))","v":""},null,null,{"$f":"IF(COUNTIF(D4,\"N\"),\"ON HOLD\",IF(ISBLANK(K4),IF(ISBLANK(E4),\"\",IF(ISBLANK(F4),\"NO\",\"YES\")),\"NO\"))","v":""},{"$f":"IF(COUNTIF(D4,\"N\"),\"\",IF(ISBLANK(F4),\"\",IF(ISBLANK(K4),_xlfn.DAYS(TODAY(),F4),_xlfn.DAYS(K4,F4))))","v":""},null,null,null,{"$f":"IF(ISBLANK(O4), \"\", O4-P4)","v":""},{"$f":"IF(ISBLANK(P4), \"\", P4/O4)","v":""}]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D5,\"N\"),\"\",IF(ISBLANK(F5),\"\",IF(ISBLANK(H5),IF(ISBLANK(K5),_xlfn.DAYS(TODAY(),F5),_xlfn.DAYS(K5,F5)),_xlfn.DAYS(H5,F5))))","v":""},null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D36,\"N\"),\"\",IF(ISBLANK(E36),\"\",IF(ISBLANK(F36),_xlfn.DAYS(TODAY(),E36),_xlfn.DAYS(F36,E36))))","v":""},null,"",null,null,{"$f":"IF(COUNTIF(D36,\"N\"),\"ON HOLD\",IF(ISBLANK(K36),IF(ISBLANK(E36),\"\",IF(ISBLANK(F36),\"NO\",\"YES\")),\"NO\"))","v":""},{"$f":"IF(COUNTIF(D36,\"N\"),\"\",IF(ISBLANK(F36),\"\",IF(ISBLANK(K36),_xlfn.DAYS(TODAY(),F36),_xlfn.DAYS(K36,F36))))","v":""},null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D68,\"N\"),\"\",IF(ISBLANK(E68),\"\",IF(ISBLANK(F68),_xlfn.DAYS(TODAY(),E68),_xlfn.DAYS(F68,E68))))","v":""},null,"",null,null,{"$f":"IF(COUNTIF(D68,\"N\"),\"ON HOLD\",IF(ISBLANK(K68),IF(ISBLANK(E68),\"\",IF(ISBLANK(F68),\"NO\",\"YES\")),\"NO\"))","v":""},"",null,null,null,{"$f":"IF(ISBLANK(O68), \"\", O68-P68)","v":""},{"$f":"IF(ISBLANK(P68), \"\", P68/O68)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D69,\"N\"),\"\",IF(ISBLANK(E69),\"\",IF(ISBLANK(F69),_xlfn.DAYS(TODAY(),E69),_xlfn.DAYS(F69,E69))))","v":""},null,{"$f":"IF(COUNTIF(D69,\"N\"),\"\",IF(ISBLANK(F69),\"\",IF(ISBLANK(H69),IF(ISBLANK(K69),_xlfn.DAYS(TODAY(),F69),_xlfn.DAYS(K69,F69)),_xlfn.DAYS(H69,F69))))","v":""},null,null,{"$f":"IF(COUNTIF(D69,\"N\"),\"ON HOLD\",IF(ISBLANK(K69),IF(ISBLANK(E69),\"\",IF(ISBLANK(F69),\"NO\",\"YES\")),\"NO\"))","v":""},{"$f":"IF(COUNTIF(D69,\"N\"),\"\",IF(ISBLANK(F69),\"\",IF(ISBLANK(K69),_xlfn.DAYS(TODAY(),F69),_xlfn.DAYS(K69,F69))))","v":""},null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D132,\"N\"),\"\",IF(ISBLANK(E132),\"\",IF(ISBLANK(F132),_xlfn.DAYS(TODAY(),E132),_xlfn.DAYS(F132,E132))))","v":""},null,"",null,null,{"$f":"IF(COUNTIF(D132,\"N\"),\"ON HOLD\",IF(ISBLANK(K132),IF(ISBLANK(E132),\"\",IF(ISBLANK(F132),\"NO\",\"YES\")),\"NO\"))","v":""},{"$f":"IF(COUNTIF(D132,\"N\"),\"\",IF(ISBLANK(F132),\"\",IF(ISBLANK(K132),_xlfn.DAYS(TODAY(),F132),_xlfn.DAYS(K132,F132))))","v":""},null,null,null,{"$f":"IF(ISBLANK(O132), \"\", O132-P132)","v":""},{"$f":"IF(ISBLANK(P132), \"\", P132/O132)","v":""}]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D133,\"N\"),\"\",IF(ISBLANK(F133),\"\",IF(ISBLANK(H133),IF(ISBLANK(K133),_xlfn.DAYS(TODAY(),F133),_xlfn.DAYS(K133,F133)),_xlfn.DAYS(H133,F133))))","v":""},null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D196,\"N\"),\"\",IF(ISBLANK(E196),\"\",IF(ISBLANK(F196),_xlfn.DAYS(TODAY(),E196),_xlfn.DAYS(F196,E196))))","v":""},null,"",null,null,{"$f":"IF(COUNTIF(D196,\"N\"),\"ON HOLD\",IF(ISBLANK(K196),IF(ISBLANK(E196),\"\",IF(ISBLANK(F196),\"NO\",\"YES\")),\"NO\"))","v":""},{"$f":"IF(COUNTIF(D196,\"N\"),\"\",IF(ISBLANK(F196),\"\",IF(ISBLANK(K196),_xlfn.DAYS(TODAY(),F196),_xlfn.DAYS(K196,F196))))","v":""},null,null,null,{"$f":"IF(ISBLANK(O196), \"\", O196-P196)","v":""},{"$f":"IF(ISBLANK(P196), \"\", P196/O196)","v":""}]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D197,\"N\"),\"\",IF(ISBLANK(F197),\"\",IF(ISBLANK(H197),IF(ISBLANK(K197),_xlfn.DAYS(TODAY(),F197),_xlfn.DAYS(K197,F197)),_xlfn.DAYS(H197,F197))))","v":""},null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D260,\"N\"),\"\",IF(ISBLANK(E260),\"\",IF(ISBLANK(F260),_xlfn.DAYS(TODAY(),E260),_xlfn.DAYS(F260,E260))))","v":""},null,"",null,null,{"$f":"IF(COUNTIF(D260,\"N\"),\"ON HOLD\",IF(ISBLANK(K260),IF(ISBLANK(E260),\"\",IF(ISBLANK(F260),\"NO\",\"YES\")),\"NO\"))","v":""},{"$f":"IF(COUNTIF(D260,\"N\"),\"\",IF(ISBLANK(F260),\"\",IF(ISBLANK(K260),_xlfn.DAYS(TODAY(),F260),_xlfn.DAYS(K260,F260))))","v":""},null,null,null,{"$f":"IF(ISBLANK(O260), \"\", O260-P260)","v":""},{"$f":"IF(ISBLANK(P260), \"\", P260/O260)","v":""}]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D261,\"N\"),\"\",IF(ISBLANK(F261),\"\",IF(ISBLANK(H261),IF(ISBLANK(K261),_xlfn.DAYS(TODAY(),F261),_xlfn.DAYS(K261,F261)),_xlfn.DAYS(H261,F261))))","v":""},null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D324,\"N\"),\"\",IF(ISBLANK(E324),\"\",IF(ISBLANK(F324),_xlfn.DAYS(TODAY(),E324),_xlfn.DAYS(F324,E324))))","v":""},null,"",null,null,{"$f":"IF(COUNTIF(D324,\"N\"),\"ON HOLD\",IF(ISBLANK(K324),IF(ISBLANK(E324),\"\",IF(ISBLANK(F324),\"NO\",\"YES\")),\"NO\"))","v":""},{"$f":"IF(COUNTIF(D324,\"N\"),\"\",IF(ISBLANK(F324),\"\",IF(ISBLANK(K324),_xlfn.DAYS(TODAY(),F324),_xlfn.DAYS(K324,F324))))","v":""},null,null,null,{"$f":"IF(ISBLANK(O324), \"\", O324-P324)","v":""},{"$f":"IF(ISBLANK(P324), \"\", P324/O324)","v":""}]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D325,\"N\"),\"\",IF(ISBLANK(F325),\"\",IF(ISBLANK(H325),IF(ISBLANK(K325),_xlfn.DAYS(TODAY(),F325),_xlfn.DAYS(K325,F325)),_xlfn.DAYS(H325,F325))))","v":""},null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D388,\"N\"),\"\",IF(ISBLANK(E388),\"\",IF(ISBLANK(F388),_xlfn.DAYS(TODAY(),E388),_xlfn.DAYS(F388,E388))))","v":""},null,"",null,null,{"$f":"IF(COUNTIF(D388,\"N\"),\"ON HOLD\",IF(ISBLANK(K388),IF(ISBLANK(E388),\"\",IF(ISBLANK(F388),\"NO\",\"YES\")),\"NO\"))","v":""},{"$f":"IF(COUNTIF(D388,\"N\"),\"\",IF(ISBLANK(F388),\"\",IF(ISBLANK(K388),_xlfn.DAYS(TODAY(),F388),_xlfn.DAYS(K388,F388))))","v":""},null,null,null,{"$f":"IF(ISBLANK(O388), \"\", O388-P388)","v":""},{"$f":"IF(ISBLANK(P388), \"\", P388/O388)","v":""}]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D389,\"N\"),\"\",IF(ISBLANK(F389),\"\",IF(ISBLANK(H389),IF(ISBLANK(K389),_xlfn.DAYS(TODAY(),F389),_xlfn.DAYS(K389,F389)),_xlfn.DAYS(H389,F389))))","v":""},null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D452,\"N\"),\"\",IF(ISBLANK(E452),\"\",IF(ISBLANK(F452),_xlfn.DAYS(TODAY(),E452),_xlfn.DAYS(F452,E452))))","v":""},null,"",null,null,{"$f":"IF(COUNTIF(D452,\"N\"),\"ON HOLD\",IF(ISBLANK(K452),IF(ISBLANK(E452),\"\",IF(ISBLANK(F452),\"NO\",\"YES\")),\"NO\"))","v":""},{"$f":"IF(COUNTIF(D452,\"N\"),\"\",IF(ISBLANK(F452),\"\",IF(ISBLANK(K452),_xlfn.DAYS(TODAY(),F452),_xlfn.DAYS(K452,F452))))","v":""},null,null,null,{"$f":"IF(ISBLANK(O452), \"\", O452-P452)","v":""},{"$f":"IF(ISBLANK(P452), \"\", P452/O452)","v":""}]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D453,\"N\"),\"\",IF(ISBLANK(F453),\"\",IF(ISBLANK(H453),IF(ISBLANK(K453),_xlfn.DAYS(TODAY(),F453),_xlfn.DAYS(K453,F453)),_xlfn.DAYS(H453,F453))))","v":""},null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,"","",null,null,null,"",""]
[null,{"$f":"COUNTA(B4:B503)","v":0},null,{"$f":"IFERROR(COUNTIF(D4:D503, \"Y\")/COUNTA(B4:B503),\"\")","v":""},"Active",null,{"$f":"IFERROR(ROUNDDOWN(AVERAGE(G4:G503)/30, 0)&\" months, \"&ROUNDDOWN(MOD(AVERAGE(G4:G503), 30),0)&\" days\", \"\")","v":""},null,{"$f":"IFERROR(ROUNDDOWN(AVERAGE(I4:I503)/30, 0)&\" months, \"&ROUNDDOWN(MOD(AVERAGE(I4:I503), 30),0)&\" days\", \"\")","v":""},"Re-referral Rate by Job Stabilization Period","Employed",{"$f":"IFERROR(COUNTIF(L4:L503, \"*YES*\")/COUNTIF(D4:D503, \"Y\"), \"\")","v":""},{"$f":"IFERROR(ROUNDDOWN(AVERAGE(M4:M503)/30, 0)&\" months, \"&ROUNDDOWN(MOD(AVERAGE(M4:M503), 30),0)&\" days\",\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(COUNTIF(D4:D503, \"N\")/COUNTA(B4:B503),\"\")","v":""},"On hold",null,{"$f":"IFERROR(COUNTIFS(G4:G503, \">0\", G4:G503, \"<91\")/COUNTIFS(D4:D503, \"Y\", G4:G503, \">0\"),\"\")","v":""},"<3 Months",{"$f":"IFERROR(COUNTIF(I4:I503, \"<91\")/COUNTA(F4:F503),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(I4:I503, \">0\", I4:I503, \"<91\", J4:J503, \">.5\")/COUNTIFS(I4:I503, \">0\", I4:I503, \"<91\"),\"\")","v":""},"Unemployed",{"$f":"IFERROR(COUNTIF(L4:L503, \"*NO*\")/COUNTIF(D4:D503, \"Y\"),\"\")","v":""},{"$f":"IFERROR(COUNTIF(M4:M503, \"<91\")/COUNTIFS(M4:M503, \">1\", M4:M503, \"<7000\"), \"\")","v":""},"<3 Months"]
[null,null,null,null,null,null,{"$f":"IFERROR(COUNTIFS(G4:G503, \">91\", G4:G503, \"<181\")/COUNTIFS(D4:D503, \"Y\", G4:G503, \">0\"),\"\")","v":""},"3-6 Months",{"$f":"IFERROR(COUNTIFS(I4:I503, \">91\", I4:I503, \"<181\")/COUNTA(F4:F503),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(I4:I503, \">91\", I4:I503, \"<181\", J4:J503, \">.5\")/COUNTIFS(I4:I503, \">91\", I4:I503, \"<181\"),\"\")","v":""},null,null,{"$f":"IFERROR(COUNTIFS(M4:M503, \">91\", M4:M503,\"<181\")/COUNTIFS(M4:M503, \">1\", M4:M503, \"<7000\"),\"\")","v":""},"3-6 Months"]
[null,null,null,null,null,null,{"$f":"IFERROR(COUNTIFS(G4:G503, \">181\", G4:G503, \"<366\")/COUNTIFS(D4:D503, \"Y\", G4:G503, \">0\"),\"\")","v":""},"6-12 Months",{"$f":"IFERROR(COUNTIFS(I4:I503, \">181\", I4:I503, \"<366\")/COUNTA(F4:F503),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(I4:I503, \">181\", I4:I503, \"<361\", J4:J503, \">.5\")/COUNTIFS(I4:I503, \">181\", I4:I503, \"<361\"),\"\")","v":""},null,null,{"$f":"IFERROR(COUNTIFS(M4:M503, \">181\", M4:M503,\"<366\")/COUNTIFS(M4:M503, \">1\", M4:M503, \"<7000\"),\"\")","v":""},"6-12 Months"]
[null,null,null,null,null,null,{"$f":"IFERROR(COUNTIFS(G4:G503, \">366\", G4:G503, \"<7000\")/COUNTIFS(D4:D503, \"Y\", G4:G503, \">0\"),\"\")","v":""},"12+ Months",{"$f":"IFERROR(COUNTIFS(I4:I503, \">366\", I4:I503, \"<7000\")/COUNTA(F4:F503),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(I4:I503, \">361\", I4:I503, \"<7000\", J4:J503, \">.5\")/COUNTIFS(I4:I503, \">361\", I4:I503, \"<7000\"),\"\")","v":""},null,null,{"$f":"IFERROR(COUNTIFS(M4:M503, \">366\", M4:M503,\"<7000\")/COUNTIFS(M4:M503, \">1\", M4:M503, \"<7000\"),\"\")","v":""},"12+ Months"]
[null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(G4:G503),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(I4:I503),\"\")","v":""},null,null,null,{"$f":"IFERROR(AVERAGE(M4:M503),\"\")","v":""},null,null,null,null,null,"CASES v1.3 - 7/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Comprehensive Assessment of Supported Employment Service (CASES) companion guide","AVAILABLE HERE"]

{"sheet":"Staff Metrics","index":3,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Staff Metrics"]
[]
[null,"Staff Member","Start Date","End Date","Staff Retention (Days)","Title","Credentials","30/60/90 Evaluation","Biannual Evaluation","Prof Development Opportunities","PP Cases","Intensive Cases","FA Cases","Total Caseload"]
[null,null,null,null,{"$f":"IF(ISBLANK(C4),\"\",IF(ISBLANK(D4),_xlfn.DAYS(TODAY(),C4),_xlfn.DAYS(D4,C4)))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(B4), \"\", SUM(K4:M4))","v":""}]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(ISBLANK(C36),\"\",IF(ISBLANK(D36),_xlfn.DAYS(TODAY(),C36),_xlfn.DAYS(D36,C36)))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(B36), \"\", SUM(K36:M36))","v":""}]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,""]
[null,{"$f":"COUNTA(B4:B53)","v":0},null,null,{"$f":"IFERROR(ROUNDDOWN(AVERAGE(E4:E53), 0),\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K4:K53)","v":0},{"$f":"SUM(L4:L53)","v":0},{"$f":"SUM(M4:M53)","v":0},{"$f":"SUM(N4:N53)","v":0}]
[null,null,null,null,{"$f":"IFERROR(DATEDIF(0,E54,\"Y\")&\" year(s), \"&DATEDIF(0,E54,\"ym\")&\" month(s), \"&DATEDIF(0,E54,\"md\")&\" day(s)\",\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(AVERAGE(E4:E53),\"\")","v":""},null,null,null,null,null,null,null,null,"CASES v1.3 - 7/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null," Comprehensive Assessment of Supported Employment Service (CASES) companion guide","AVAILABLE HERE"]

{"sheet":"Employer Relations","index":4,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Contact Information",null,null,null,null,null,"Employer Relations"]
[null,null,null,null,"YES","NO",null,1,2,3,4,5]
[null,"Organization","Employer/Supervisor Name","Contact Information","Initial Contact Date","Job Developer Making Contact","Last Survey Date","# of Consumers at Location","Satisfaction with Service","Satisfaction with Job Coach","Satisfaction With Employee","Future Reference"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"COUNTA(B4:B53)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(I4:I53)/5, \"\")","v":""},{"$f":"IFERROR(AVERAGE(J4:J53)/5, \"\")","v":""},{"$f":"IFERROR(AVERAGE(K4:K53)/5, \"\")","v":""},{"$f":"IFERROR(COUNTIF(L4:L53, \"YES\")/COUNTA(L4:L53), \"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"CASES v1.3 - 7/2021"]
[null,null,null,null,null,null,null,null,null,null," Comprehensive Assessment of Supported Employment Service (CASES) companion guide","AVAILABLE HERE"]

{"sheet":"Closed Case Archive","index":5,"n_rows":510,"n_cols":20,"rows_kept":510,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Closed Case Archive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","N"]
[null,"Consumer","County","Closed Case (Y/N)","Referral Date","Employment Start Date","Unemployed Period (Days)","Follow Along Transition Date","Job Stabilization Period (Days)","# of  Re-stabilization Attempts","Employment Terminated","Case Closed Date","Currently Employed","Retention Period (Days)","Funding Source","Units/Hours Allotted","Units/Hours Used","Units/Hours Remaining","% Complete","# of Vouchers Used"]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D4,\"N\"),\"\",IF(ISBLANK(E4),\"\",IF(ISBLANK(F4),IF(ISBLANK(L4), _xlfn.DAYS(TODAY(),E4), _xlfn.DAYS(L4,E4)), _xlfn.DAYS(F4,E4))))","v":""},null,{"$f":"IF(COUNTIF(D4,\"N\"),\"\",IF(ISBLANK(F4),\"\",IF(ISBLANK(H4),IF(ISBLANK(K4),_xlfn.DAYS(TODAY(),F4),_xlfn.DAYS(K4,F4)),_xlfn.DAYS(H4,F4))))","v":""},null,null,null,{"$f":"IF(COUNTIF(D4,\"N\"),\"ON HOLD\",IF(ISBLANK(K4),IF(ISBLANK(E4),\"\",IF(ISBLANK(F4),\"NO\",\"YES\")),\"NO\"))","v":""},{"$f":"IF(COUNTIF(D4,\"N\"),\"\",IF(ISBLANK(F4),\"\",IF(ISBLANK(K4),_xlfn.DAYS(TODAY(),F4),_xlfn.DAYS(K4,F4))))","v":""},null,null,null,{"$f":"IF(ISBLANK(P4), \"\", P4-Q4)","v":""},{"$f":"IF(ISBLANK(Q4), \"\", Q4/P4)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D5,\"N\"),\"\",IF(ISBLANK(E5),\"\",IF(ISBLANK(F5),IF(ISBLANK(L5), _xlfn.DAYS(TODAY(),E5), _xlfn.DAYS(L5,E5)), _xlfn.DAYS(F5,E5))))","v":""},null,{"$f":"IF(COUNTIF(D5,\"N\"),\"\",IF(ISBLANK(F5),\"\",IF(ISBLANK(H5),IF(ISBLANK(K5),_xlfn.DAYS(TODAY(),F5),_xlfn.DAYS(K5,F5)),_xlfn.DAYS(H5,F5))))","v":""},null,null,null,{"$f":"IF(COUNTIF(D5,\"N\"),\"ON HOLD\",IF(ISBLANK(K5),IF(ISBLANK(E5),\"\",IF(ISBLANK(F5),\"NO\",\"YES\")),\"NO\"))","v":""},{"$f":"IF(COUNTIF(D5,\"N\"),\"\",IF(ISBLANK(F5),\"\",IF(ISBLANK(K5),_xlfn.DAYS(TODAY(),F5),_xlfn.DAYS(K5,F5))))","v":""},null,null,null,"",""]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D6,\"N\"),\"\",IF(ISBLANK(F6),\"\",IF(ISBLANK(H6),IF(ISBLANK(K6),_xlfn.DAYS(TODAY(),F6),_xlfn.DAYS(K6,F6)),_xlfn.DAYS(H6,F6))))","v":""},null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,{"$f":"IF(COUNTIF(D68,\"N\"),\"ON HOLD\",IF(ISBLANK(K68),IF(ISBLANK(E68),\"\",IF(ISBLANK(F68),\"NO\",\"YES\")),\"NO\"))","v":""},"",null,null,null,{"$f":"IF(ISBLANK(P68), \"\", P68-Q68)","v":""},{"$f":"IF(ISBLANK(Q68), \"\", Q68/P68)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D69,\"N\"),\"\",IF(ISBLANK(E69),\"\",IF(ISBLANK(F69),IF(ISBLANK(L69), _xlfn.DAYS(TODAY(),E69), _xlfn.DAYS(L69,E69)), _xlfn.DAYS(F69,E69))))","v":""},null,"",null,null,null,"",{"$f":"IF(COUNTIF(D69,\"N\"),\"\",IF(ISBLANK(F69),\"\",IF(ISBLANK(K69),_xlfn.DAYS(TODAY(),F69),_xlfn.DAYS(K69,F69))))","v":""},null,null,null,"",""]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D70,\"N\"),\"\",IF(ISBLANK(F70),\"\",IF(ISBLANK(H70),IF(ISBLANK(K70),_xlfn.DAYS(TODAY(),F70),_xlfn.DAYS(K70,F70)),_xlfn.DAYS(H70,F70))))","v":""},null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,{"$f":"IF(COUNTIF(D132,\"N\"),\"ON HOLD\",IF(ISBLANK(K132),IF(ISBLANK(E132),\"\",IF(ISBLANK(F132),\"NO\",\"YES\")),\"NO\"))","v":""},"",null,null,null,{"$f":"IF(ISBLANK(P132), \"\", P132-Q132)","v":""},{"$f":"IF(ISBLANK(Q132), \"\", Q132/P132)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D133,\"N\"),\"\",IF(ISBLANK(E133),\"\",IF(ISBLANK(F133),IF(ISBLANK(L133), _xlfn.DAYS(TODAY(),E133), _xlfn.DAYS(L133,E133)), _xlfn.DAYS(F133,E133))))","v":""},null,"",null,null,null,"",{"$f":"IF(COUNTIF(D133,\"N\"),\"\",IF(ISBLANK(F133),\"\",IF(ISBLANK(K133),_xlfn.DAYS(TODAY(),F133),_xlfn.DAYS(K133,F133))))","v":""},null,null,null,"",""]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D134,\"N\"),\"\",IF(ISBLANK(F134),\"\",IF(ISBLANK(H134),IF(ISBLANK(K134),_xlfn.DAYS(TODAY(),F134),_xlfn.DAYS(K134,F134)),_xlfn.DAYS(H134,F134))))","v":""},null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,{"$f":"IF(COUNTIF(D196,\"N\"),\"ON HOLD\",IF(ISBLANK(K196),IF(ISBLANK(E196),\"\",IF(ISBLANK(F196),\"NO\",\"YES\")),\"NO\"))","v":""},"",null,null,null,{"$f":"IF(ISBLANK(P196), \"\", P196-Q196)","v":""},{"$f":"IF(ISBLANK(Q196), \"\", Q196/P196)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D197,\"N\"),\"\",IF(ISBLANK(E197),\"\",IF(ISBLANK(F197),IF(ISBLANK(L197), _xlfn.DAYS(TODAY(),E197), _xlfn.DAYS(L197,E197)), _xlfn.DAYS(F197,E197))))","v":""},null,"",null,null,null,"",{"$f":"IF(COUNTIF(D197,\"N\"),\"\",IF(ISBLANK(F197),\"\",IF(ISBLANK(K197),_xlfn.DAYS(TODAY(),F197),_xlfn.DAYS(K197,F197))))","v":""},null,null,null,"",""]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D198,\"N\"),\"\",IF(ISBLANK(F198),\"\",IF(ISBLANK(H198),IF(ISBLANK(K198),_xlfn.DAYS(TODAY(),F198),_xlfn.DAYS(K198,F198)),_xlfn.DAYS(H198,F198))))","v":""},null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,{"$f":"IF(COUNTIF(D260,\"N\"),\"ON HOLD\",IF(ISBLANK(K260),IF(ISBLANK(E260),\"\",IF(ISBLANK(F260),\"NO\",\"YES\")),\"NO\"))","v":""},"",null,null,null,{"$f":"IF(ISBLANK(P260), \"\", P260-Q260)","v":""},{"$f":"IF(ISBLANK(Q260), \"\", Q260/P260)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D261,\"N\"),\"\",IF(ISBLANK(E261),\"\",IF(ISBLANK(F261),IF(ISBLANK(L261), _xlfn.DAYS(TODAY(),E261), _xlfn.DAYS(L261,E261)), _xlfn.DAYS(F261,E261))))","v":""},null,"",null,null,null,"",{"$f":"IF(COUNTIF(D261,\"N\"),\"\",IF(ISBLANK(F261),\"\",IF(ISBLANK(K261),_xlfn.DAYS(TODAY(),F261),_xlfn.DAYS(K261,F261))))","v":""},null,null,null,"",""]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D262,\"N\"),\"\",IF(ISBLANK(F262),\"\",IF(ISBLANK(H262),IF(ISBLANK(K262),_xlfn.DAYS(TODAY(),F262),_xlfn.DAYS(K262,F262)),_xlfn.DAYS(H262,F262))))","v":""},null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,{"$f":"IF(COUNTIF(D324,\"N\"),\"ON HOLD\",IF(ISBLANK(K324),IF(ISBLANK(E324),\"\",IF(ISBLANK(F324),\"NO\",\"YES\")),\"NO\"))","v":""},"",null,null,null,{"$f":"IF(ISBLANK(P324), \"\", P324-Q324)","v":""},{"$f":"IF(ISBLANK(Q324), \"\", Q324/P324)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D325,\"N\"),\"\",IF(ISBLANK(E325),\"\",IF(ISBLANK(F325),IF(ISBLANK(L325), _xlfn.DAYS(TODAY(),E325), _xlfn.DAYS(L325,E325)), _xlfn.DAYS(F325,E325))))","v":""},null,"",null,null,null,"",{"$f":"IF(COUNTIF(D325,\"N\"),\"\",IF(ISBLANK(F325),\"\",IF(ISBLANK(K325),_xlfn.DAYS(TODAY(),F325),_xlfn.DAYS(K325,F325))))","v":""},null,null,null,"",""]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D326,\"N\"),\"\",IF(ISBLANK(F326),\"\",IF(ISBLANK(H326),IF(ISBLANK(K326),_xlfn.DAYS(TODAY(),F326),_xlfn.DAYS(K326,F326)),_xlfn.DAYS(H326,F326))))","v":""},null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,{"$f":"IF(COUNTIF(D388,\"N\"),\"ON HOLD\",IF(ISBLANK(K388),IF(ISBLANK(E388),\"\",IF(ISBLANK(F388),\"NO\",\"YES\")),\"NO\"))","v":""},"",null,null,null,{"$f":"IF(ISBLANK(P388), \"\", P388-Q388)","v":""},{"$f":"IF(ISBLANK(Q388), \"\", Q388/P388)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D389,\"N\"),\"\",IF(ISBLANK(E389),\"\",IF(ISBLANK(F389),IF(ISBLANK(L389), _xlfn.DAYS(TODAY(),E389), _xlfn.DAYS(L389,E389)), _xlfn.DAYS(F389,E389))))","v":""},null,"",null,null,null,"",{"$f":"IF(COUNTIF(D389,\"N\"),\"\",IF(ISBLANK(F389),\"\",IF(ISBLANK(K389),_xlfn.DAYS(TODAY(),F389),_xlfn.DAYS(K389,F389))))","v":""},null,null,null,"",""]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D390,\"N\"),\"\",IF(ISBLANK(F390),\"\",IF(ISBLANK(H390),IF(ISBLANK(K390),_xlfn.DAYS(TODAY(),F390),_xlfn.DAYS(K390,F390)),_xlfn.DAYS(H390,F390))))","v":""},null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,{"$f":"IF(COUNTIF(D452,\"N\"),\"ON HOLD\",IF(ISBLANK(K452),IF(ISBLANK(E452),\"\",IF(ISBLANK(F452),\"NO\",\"YES\")),\"NO\"))","v":""},"",null,null,null,{"$f":"IF(ISBLANK(P452), \"\", P452-Q452)","v":""},{"$f":"IF(ISBLANK(Q452), \"\", Q452/P452)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(D453,\"N\"),\"\",IF(ISBLANK(E453),\"\",IF(ISBLANK(F453),IF(ISBLANK(L453), _xlfn.DAYS(TODAY(),E453), _xlfn.DAYS(L453,E453)), _xlfn.DAYS(F453,E453))))","v":""},null,"",null,null,null,"",{"$f":"IF(COUNTIF(D453,\"N\"),\"\",IF(ISBLANK(F453),\"\",IF(ISBLANK(K453),_xlfn.DAYS(TODAY(),F453),_xlfn.DAYS(K453,F453))))","v":""},null,null,null,"",""]
[null,null,null,null,null,null,"",null,{"$f":"IF(COUNTIF(D454,\"N\"),\"\",IF(ISBLANK(F454),\"\",IF(ISBLANK(H454),IF(ISBLANK(K454),_xlfn.DAYS(TODAY(),F454),_xlfn.DAYS(K454,F454)),_xlfn.DAYS(H454,F454))))","v":""},null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,null,null,null,null,null,"",null,"",null,null,null,"","",null,null,null,"",""]
[null,{"$f":"COUNTA(B4:B503)","v":0},null,{"$f":"IFERROR(COUNTIF(D4:D503, \"Y\")/COUNTA(B4:B503),\"\")","v":""},"Active",null,{"$f":"IFERROR(ROUNDDOWN(AVERAGE(G4:G503)/30, 0)&\" months, \"&ROUNDDOWN(MOD(AVERAGE(G4:G503), 30),0)&\" days\", \"\")","v":""},null,{"$f":"IFERROR(ROUNDDOWN(AVERAGE(I4:I503)/30, 0)&\" months, \"&ROUNDDOWN(MOD(AVERAGE(I4:I503), 30),0)&\" days\", \"\")","v":""},"Re-referral Rate by Job Stabilization Period",null,"Graduated Service w/Job",{"$f":"IFERROR(COUNTIF(M4:M503, \"*YES*\")/COUNTIF(D4:D503, \"Y\"), \"\")","v":""},{"$f":"IFERROR(ROUNDDOWN(AVERAGE(N4:N503)/30, 0)&\" months, \"&ROUNDDOWN(MOD(AVERAGE(N4:N503), 30),0)&\" days\",\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(COUNTIF(D4:D503, \"N\")/COUNTA(B4:B503),\"\")","v":""},"On hold",null,{"$f":"IFERROR(COUNTIFS(G4:G503, \">0\", G4:G503, \"<91\")/COUNTIFS(D4:D503, \"Y\", G4:G503, \">0\"),\"\")","v":""},"<3 Months",{"$f":"IFERROR(COUNTIF(I4:I503, \"<91\")/COUNTA(F4:F503),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(I4:I503, \">0\", I4:I503, \"<91\", J4:J503, \">.5\")/COUNTIFS(I4:I503, \">0\", I4:I503, \"<91\"),\"\")","v":""},null,"Unemployed",{"$f":"IFERROR(COUNTIF(M4:M503, \"*NO*\")/COUNTIF(D4:D503, \"Y\"),\"\")","v":""},{"$f":"IFERROR(COUNTIF(N4:N503, \"<91\")/COUNTIFS(N4:N503, \">1\", N4:N503, \"<7000\"), \"\")","v":""},"<3 Months"]
[null,null,null,null,null,null,{"$f":"IFERROR(COUNTIFS(G4:G503, \">91\", G4:G503, \"<181\")/COUNTIFS(D4:D503, \"Y\", G4:G503, \">0\"),\"\")","v":""},"3-6 Months",{"$f":"IFERROR(COUNTIFS(I4:I503, \">91\", I4:I503, \"<181\")/COUNTA(F4:F503),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(I4:I503, \">91\", I4:I503, \"<181\", J4:J503, \">.5\")/COUNTIFS(I4:I503, \">91\", I4:I503, \"<181\"),\"\")","v":""},null,null,null,{"$f":"IFERROR(COUNTIFS(N4:N503, \">91\", N4:N503,\"<181\")/COUNTIFS(N4:N503, \">1\", N4:N503, \"<7000\"),\"\")","v":""},"3-6 Months"]
[null,null,null,null,null,null,{"$f":"IFERROR(COUNTIFS(G4:G503, \">181\", G4:G503, \"<366\")/COUNTIFS(D4:D503, \"Y\", G4:G503, \">0\"),\"\")","v":""},"6-12 Months",{"$f":"IFERROR(COUNTIFS(I4:I503, \">181\", I4:I503, \"<366\")/COUNTA(F4:F503),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(I4:I503, \">181\", I4:I503, \"<361\", J4:J503, \">.5\")/COUNTIFS(I4:I503, \">181\", I4:I503, \"<361\"),\"\")","v":""},null,null,null,{"$f":"IFERROR(COUNTIFS(N4:N503, \">181\", N4:N503,\"<366\")/COUNTIFS(N4:N503, \">1\", N4:N503, \"<7000\"),\"\")","v":""},"6-12 Months"]
[null,null,null,null,null,null,{"$f":"IFERROR(COUNTIFS(G4:G503, \">366\", G4:G503, \"<7000\")/COUNTIFS(D4:D503, \"Y\", G4:G503, \">0\"),\"\")","v":""},"12+ Months",{"$f":"IFERROR(COUNTIFS(I4:I503, \">366\", I4:I503, \"<7000\")/COUNTA(F4:F503),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(I4:I503, \">361\", I4:I503, \"<7000\", J4:J503, \">.5\")/COUNTIFS(I4:I503, \">361\", I4:I503, \"<7000\"),\"\")","v":""},null,null,null,{"$f":"IFERROR(COUNTIFS(N4:N503, \">366\", N4:N503,\"<7000\")/COUNTIFS(N4:N503, \">1\", N4:N503, \"<7000\"),\"\")","v":""},"12+ Months"]
[null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(G4:G503),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(I4:I503),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(AVERAGE(N4:N503),\"\")","v":""},null,null,null,null,null,"CASES v1.3 - 7/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Comprehensive Assessment of Supported Employment Service (CASES) companion guide","AVAILABLE HERE"]

{"sheet":"v1.3 Update Notes","index":6,"n_rows":59,"n_cols":1,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Welcome to the CASES Update Notes! "]
[]
["All updates are driven by feedback from SE agencies who utilize this free tool. "]
["All feedback is considered and appreciated!"]
[]
["I have received a lot of great feedback on the CASES tool over the last few years it has been available to the public. The intention of this tool is to assist SE managers, supervisors, and director in data analysis while keeping the data entry component as simple as possible. To that end, I have used user feedback to shape what has, and what will, be included in updates for CASES."]
[]
["***The newest version of CASES is a MACRO-ENABLED EXCEL FILE. To use the following feature, you need to accept the pop up to enable macros in your Excel when you open it. Furthermore, when you save your file, make sure you are saving it as a Macro Enabled Excel file to retain the use of all the new features!*** "]
[]
["Please remember to contact me if you have any problems, concerns, feedback (positive or negative), need something tweaked, make suggestions, etc. Also, should you want to take part in our long term project, please email robert.kimmel@rutgers.edu. We would be very grateful if you could send us de-identified data (no names) so we can build a larger database of where services currently stand in the field (this is VOLUNTARY ONLY, feel free to use this tool without taking part in this endeavor). "]
[]
["Hope you enjoy the newest update: version 1.3!"]
[]
["R. Kimmel"]
["Training and Consultation Specialist"]
["The Boggs Center on Developmental Disabilities"]
["Rutgers Robert Wood Johnson Medical School"]
["robert.kimmel@rutgers.edu"]
[]
[]
["CASES V1.3 Update Notes (7/2021)"]
[]
["Annual Data Tracking"]
["- CASES was designed to give a \"snapshot\" of the current status of a supported employment program by analyzing inputted data and producing a Program Summary on that first tab. While this aggregated and displayed data on Service Provision, Staff Metrics, Employer Relations, and Closed Cases, aside from printing out or recording the data presented month to month, there was no way to look for trends over time visually. I received a great deal of feedback asking for this feature to be introduced, so voila! You will see in this newest version of CASES (v1.3) that there is a new tab at the bottom called \"Annual Data Tracking.\" What you'll see in this tab is a large table that accounts for each metric on the Program Summary tab, with each column representing a month of the year. I also copied the Program Summary column onto this page so you wouldn't have to flip between tabs to copy over information. Now, once a month a user could copy the \"snapshot\" statistics into the appropriate month and the line graphs will auto-populate, showing you trends over the course of the year. Furthermore, while I headed the columns in calendar year order, these cells are unlocked and can be customized. This way you could start the months with your fiscal year instead of calendar year. Should you do so, the tables will adjust their headings along each axis appropriately. I unfortunately could not find a way to get excel to auto-populate this graph once a month on its own, so this feature will need to be a manual entry once a month. That said, I've tried to make it as user friendly as possible."]
["Staff Credentials"]
["- A \"credentials\" column has been added to the staff metrics section. Tracking staff credentials allows a manager or supervisor to offer professional development opportunities that could help their employee grow or maintain their certification. Furthermore, efforts can be made to get SE teams to obtain SE certifications, such as an Association of Community Rehavilitation Educators (ACRE) accreditation or as a Certified Employment Support Professional through the Association of Peoples Supporting Employment First (APSE). Having documentation of the skill and certification level of your teams is important for drawing in more talent, elevating the profession, and setting standards for employee experience and knowledge that comes with the accreditation. "]
["Error Corrections"]
["- In Closed Cases, the Retention number for days stopped when adding a date to \"Case Closed.\" At times, a consumer will graduate from service with your organization and retain their job, in which case we shouldn't be stopping the count on their retention! Retention numbers will now only stop when adding a date to the \"Employment Terminated\" column."]
[]
["- In Service Provision and Closed Cases, the Job Stabilization number was not capped when an \"Employment Terminated\" date was added to the sheet. This has been remedied, so if the individual receiving service did not move to follow-along and lost their job during that phase, the number will stop when employment termination is added."]
[]
["- In Closed Cases, the Unemployment Period number was not capped when a \"Closed Case\" date was added to the sheet. This has been remedied, so if the individual receiving services starts the pre-employment process with your organization and ends up not getting a job or gets referred out for more training, adding a date to closed cases will pause the count on the Unemployment Period tally."]
[]
["CASES V1.21 Update (7/2020)"]
[]
["Error Corrections"]
["- The employer reference drop down fields were coded to have 1-5 drop downs like the other survey option fields when they should have been YES/NO. This has been fixed"]
[]
["- Formatting issues existed for number entries areas for Closed case archives In the date column for date employed. This has been fixed."]
[]
["- Graphs In the Program Summary page were not locked In place as they should have been. This has been fixed."]
[]
["CASES V1.2 Update (7/2019)"]
[]
["Data capacity"]
["- The original version had approximately 25 available rows for entries. Many providers have asked for additional spaces to be made available since they have many individuals they support. Since the tool is a protected file and users don't have the ability to add rows as they normally would, the new version now has a default 500 available rows for individuals you work with on the service provision and closed case archive tabs. The Employer Relations and Staff Metrics tabs have been increased to 50 each."]
[]
["- Additionally, a button was macro/VBA coded and embedded into the sheet to allow users to insert new rows to allow for more data fields as needed should users max out the given fields. When rows are added, the formulas will port over to the new rows automatically and the Excel file/formulas/structure will remain protected. **FYI** - The new row will be inserted at Row 5 of the active sheet."]
[]
["Quality of Life Improvements"]
["- New Black Menu Bar housing the \"Add Row\" button on Left side of workbook sheets (not on dashboard)"]
[]
["- The header-menu bar-consumer/organization/staff names on every page are now frozen and will always be visible as you scroll down or to the right. This addition is helpful now that the fields have been heavily expanded so the keys for each row/column are always available. This feature CAN be altered by the user even while the file is protected so if you have a preference of how you'd like to freeze your panes in a different pattern than I selected, you can change it yourself in the \"View\" tab/\"Freeze/Unfreeze Panes\"."]
[]
["- A macro/VBA code was embedded into the sheets so that a user could double click the header on any column and it would sort it alphabetically/ASCENDING numerically/oldest to newest. If you then double click the same cell, it will sort that column DESCENDING/newest to oldest. Whenever sorting is done, it will also move the data in other columns around accordingly. This feature is usable while keeping the sheet and formulas protected (so all of you still scared of Excel can use these features)!"]
[]
["- Drop down fields were added to the Y/N and YES/NO fields to make sure there were NO data entry mistakes based on spelling or capitalization. This way the formulas will always count the data In the correct way when selections are made using the drop down."]
[]
["- Drop down fields were added to the Employer Survey Questions (coded for Likert scales, 1-5, as seen in the sample survey in the guide) so that the formulas worked for accurately aggregating employer responses to the survey. (If you have your own survey that you use and a different numbered scale, I can change the parameters to match your number range, just email me)."]