{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["INSTRUCTIONS","1-PasteSheet","2-Dashboard","3-Multiplr","3-Multiplr (2)","3-ServiceCats","4-Trends","5-Pies","Paste ER Names","Serices Graph","6-CatCoPaste","7-CatCoReport","8-Audit Legend","General Instr","Unlocked Cells Legend"],"not_rendered":{"charts":9,"images":8,"macros":0,"external_links":1,"defined_names":9,"comments":6,"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":"INSTRUCTIONS","index":0,"n_rows":33,"n_cols":28,"rows_kept":33,"cut":false,"hidden":false,"merged":[[6,15,6,16],[9,2,9,6],[10,11,10,12],[10,15,10,16],[10,19,10,20],[6,17,6,26],[11,11,11,12],[11,15,11,16],[11,19,11,20],[9,11,9,13],[9,15,9,17],[9,19,9,21],[12,11,12,12],[12,15,12,16],[12,19,12,20],[13,11,13,12],[13,15,13,16],[13,19,13,20],[14,11,14,12],[14,15,14,16],[14,19,14,20],[15,11,15,12],[15,15,15,16],[15,19,15,20],[16,11,16,12],[16,15,16,16],[16,19,16,20],[16,2,16,6],[17,11,17,12],[17,15,17,16],[17,19,17,20],[17,2,17,6],[18,11,18,12],[18,15,18,16],[18,19,18,20],[18,2,18,6],[19,2,19,6],[20,11,20,12],[20,15,20,16],[20,19,20,20],[20,2,20,6],[19,11,19,12],[19,15,19,16],[19,19,19,20],[23,2,23,6],[21,2,21,6],[22,11,22,12],[22,15,22,16],[22,19,22,20],[22,2,22,6],[22,7,22,9],[21,11,21,12],[21,15,21,16],[21,19,21,20],[13,7,13,9],[14,7,14,9],[15,7,15,9],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6],[6,27,6,28],[23,7,23,9],[3,2,4,8],[0,2,1,17],[6,2,7,11],[6,12,7,13],[16,7,16,9],[17,7,17,9],[18,7,18,9],[19,7,19,9],[20,7,20,9],[21,7,21,9],[9,7,9,9],[10,7,10,9],[11,7,11,9],[12,7,12,9]]}
[null,null,"Instructions: Work your way down this sheet to prepare for reporting"]
[]
[]
[null,null,"Complete Yellow Cells Below"]
[]
[]
[null,null,"Enter month # for the report month \nrelative to your FY start (from table @ right)\nSo if your FY starts in October and you are reporting for January type in a 4 in the yellow cell to the right.",null,null,null,null,null,null,null,null,null,8,null,null,"here",null,"< Click either option to research when the date of first service was for this FY for each company >",null,null,null,null,null,null,null,null,null,"here"]
[]
[]
[null,null,"Employer Names type or copy and paste from previous dashboard",null,null,null,null,"Input month # company started (refer to table at right)",null,null,null,"FY START\nOCT",null,null,null,"FY START\nJAN",null,null,null,"FY START\nAPR"]
[null,1,"Anne Grady Corp.",null,null,null,null,2,null,null,{"$f":"($M$7-H11)+1","v":7},"Month #",null,null,null,"Month #",null,null,null,"Month #"]
[null,2,"Bittersweet Farms",null,null,null,null,3,null,null,{"$f":"($M$7-H12)+1","v":6},1,null,"Oct",null,1,null,"Jan",null,1,null,"Apr"]
[null,3,"Champagne CRSI",null,null,null,null,3,null,null,6,2,null,"Nov",null,2,null,"Feb",null,2,null,"May"]
[null,4,"Community Residential Svcs.",null,null,null,null,1,null,null,8,3,null,"Dec",null,3,null,"Mar",null,3,null,"Jun"]
[null,5,"Epilepsy Center",null,null,null,null,3,null,null,6,4,null,"Jan",null,4,null,"Apr",null,4,null,"Jul"]
[null,6,"Josina Lott",null,null,null,null,1,null,null,8,5,null,"Feb",null,5,null,"May",null,5,null,"Aug"]
[null,7,"Sunshine Communities",null,null,null,null,2,null,null,7,6,null,"Mar",null,6,null,"Jun",null,6,null,"Sep"]
[null,8,"Triad",null,null,null,null,3,null,null,6,7,null,"Apr",null,7,null,"Jul",null,7,null,"Oct"]
[null,9,null,null,null,null,null,null,null,null,9,8,null,"May",null,8,null,"Aug",null,8,null,"Nov"]
[null,10,null,null,null,null,null,null,null,null,9,9,null,"Jun",null,9,null,"Sep",null,9,null,"Dec"]
[null,11,null,null,null,null,null,null,null,null,9,10,null,"Jul",null,10,null,"Oct",null,10,null,"Jan"]
[null,12,null,null,null,null,null,null,null,null,9,11,null,"Aug",null,11,null,"Nov",null,11,null,"Feb"]
[null,13,null,null,null,null,null,null,null,null,9,12,null,"Sep",null,12,null,"Dec",null,12,null,"Mar"]
[null,14,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,{"$f":"($U$48-H24)+1","v":1}]
[]
[null,null,null,null,"1.  When complete return here to review how to save multiple pages as a pdf for printing and sending to HR after the meeting."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<= this does not work yet"]

{"sheet":"1-PasteSheet","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Company Name",null,"HR","Supervisor","Self","Co-worker","Other"]
[null,null,null,null,"Anne Grady Corp.","Record Count",0,0,23,3,1,27]
[null,null,null,null,"Bittersweet Farms","Record Count",3,1,11,0,0,15]
[null,null,null,null,"Champagne (CRSI)","Record Count",4,0,2,0,0,6]
[null,null,null,null,"CRS Community Residential Services","Record Count",0,0,1,0,0,1]
[null,null,null,null,"Epilepsy Center","Record Count",1,0,5,0,0,6]
[null,null,null,null,"Josina Lott","Record Count",0,1,0,0,0,1]
[null,null,null,null,"Sunshine Communities","Record Count",12,2,27,0,1,42]
[null,null,null,null,"Triad","Record Count",6,2,10,0,1]

{"sheet":"2-Dashboard","index":2,"n_rows":96,"n_cols":53,"rows_kept":96,"cut":false,"hidden":false,"merged":[[30,28,30,31],[21,36,21,38],[22,36,22,38],[23,36,23,38],[24,36,24,38],[25,36,25,38],[26,36,26,38],[27,36,27,38],[28,36,28,38],[29,36,29,38],[21,33,21,35],[22,33,22,35],[23,33,23,35],[24,33,24,35],[25,33,25,35],[26,33,26,35],[27,33,27,35],[28,33,28,35],[29,33,29,35],[21,28,21,32],[22,28,22,32],[23,28,23,32],[24,28,24,32],[25,28,25,32],[42,36,42,38],[43,36,43,38],[34,28,34,35],[35,28,35,35],[36,28,36,35],[37,28,37,35],[38,28,38,35],[39,28,39,35],[40,28,40,35],[41,28,41,35],[42,28,42,35],[43,28,43,35],[34,36,34,38],[35,36,35,38],[36,36,36,38],[37,36,37,38],[38,36,38,38],[39,36,39,38],[40,36,40,38],[41,36,41,38],[51,33,51,35],[50,36,50,38],[51,36,51,38],[45,33,45,35],[45,36,45,38],[45,28,45,32],[46,28,46,32],[47,28,47,32],[48,28,48,32],[49,28,49,32],[50,28,50,32],[51,28,51,32],[46,33,46,35],[47,33,47,35],[46,36,46,38],[47,36,47,38],[48,33,48,35],[49,33,49,35],[48,36,48,38],[49,36,49,38],[50,33,50,35],[46,48,46,49],[47,48,47,49],[48,48,48,49],[49,48,49,49],[50,48,50,49],[51,48,51,49],[52,48,52,49],[53,48,53,49],[46,46,46,47],[47,46,47,47],[34,48,34,49],[35,48,35,49],[36,48,36,49],[37,48,37,49],[38,48,38,49],[39,48,39,49],[40,48,40,49],[41,48,41,49],[42,48,42,49],[25,48,25,49],[26,48,26,49],[27,48,27,49],[28,48,28,49],[29,48,29,49],[30,48,30,49],[31,48,31,49],[32,48,32,49],[33,48,33,49],[47,40,47,45],[48,40,48,45],[49,40,49,45],[50,40,50,45],[26,46,26,47],[27,46,27,47],[28,46,28,47],[29,46,29,47],[30,46,30,47],[31,46,31,47],[32,46,32,47],[33,46,33,47],[34,46,34,47],[35,46,35,47],[36,46,36,47],[37,46,37,47],[38,46,38,47],[39,46,39,47],[40,46,40,47],[41,46,41,47],[42,46,42,47],[43,46,43,47],[37,40,37,45],[44,46,44,47],[54,40,54,45],[55,40,55,45],[54,46,54,47],[55,46,55,47],[55,48,55,49],[51,40,51,45],[52,40,52,45],[53,40,53,45],[49,46,49,47],[50,46,50,47],[51,46,51,47],[52,46,52,47],[53,46,53,47],[54,48,54,49],[21,40,21,45],[22,40,22,45],[23,40,23,45],[24,40,24,45],[25,40,25,45],[21,46,21,47],[22,46,22,47],[23,46,23,47],[24,46,24,47],[25,46,25,47],[21,48,21,49],[22,48,22,49],[23,48,23,49],[24,48,24,49],[11,48,11,49],[12,48,12,49],[13,48,13,49],[14,48,14,49],[15,48,15,49],[16,48,16,49],[17,48,17,49],[18,48,18,49],[1,48,3,49],[1,28,1,47],[2,28,2,31],[4,48,4,49],[5,48,5,49],[6,48,6,49],[7,48,7,49],[8,48,8,49],[9,48,9,49],[9,38,9,39],[9,40,9,41],[9,42,9,43],[9,44,9,45],[9,46,9,47],[4,46,4,47],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[6,36,6,37],[6,38,6,39],[6,40,6,41],[10,48,10,49],[17,36,17,37],[17,38,17,39],[17,40,17,41],[17,42,17,43],[17,44,17,45],[17,46,17,47],[18,36,18,37],[18,38,18,39],[18,40,18,41],[18,42,18,43],[18,44,18,45],[18,46,18,47],[15,38,15,39],[15,40,15,41],[15,42,15,43],[15,44,15,45],[15,46,15,47],[16,36,16,37],[16,38,16,39],[16,40,16,41],[16,42,16,43],[16,44,16,45],[16,46,16,47],[13,38,13,39],[13,40,13,41],[13,42,13,43],[13,44,13,45],[13,46,13,47],[14,36,14,37],[14,38,14,39],[14,40,14,41],[14,42,14,43],[14,44,14,45],[14,46,14,47],[13,36,13,37],[11,38,11,39],[11,40,11,41],[11,42,11,43],[11,44,11,45],[11,46,11,47],[12,36,12,37],[12,38,12,39],[12,40,12,41],[12,42,12,43],[12,44,12,45],[12,46,12,47],[11,36,11,37],[10,36,10,37],[10,38,10,39],[10,40,10,41],[10,42,10,43],[10,44,10,45],[10,46,10,47],[7,38,7,39],[7,40,7,41],[7,42,7,43],[7,44,7,45],[7,46,7,47],[8,36,8,37],[8,38,8,39],[8,40,8,41],[8,42,8,43],[8,44,8,45],[8,46,8,47],[7,36,7,37],[9,36,9,37],[6,42,6,43],[6,44,6,45],[6,46,6,47],[3,42,3,43],[3,44,3,45],[2,32,2,35],[4,32,4,33],[5,32,5,33],[6,32,6,33],[2,36,2,39],[2,40,2,43],[2,44,2,47],[3,46,3,47],[4,36,4,37],[4,38,4,39],[4,40,4,41],[4,42,4,43],[4,44,4,45],[3,32,3,33],[3,34,3,35],[3,36,3,37],[3,38,3,39],[3,40,3,41],[4,30,4,31],[5,30,5,31],[6,30,6,31],[7,30,7,31],[8,30,8,31],[9,30,9,31],[10,30,10,31],[11,30,11,31],[12,30,12,31],[7,32,7,33],[8,32,8,33],[9,32,9,33],[4,34,4,35],[5,34,5,35],[6,34,6,35],[7,34,7,35],[8,34,8,35],[9,34,9,35],[45,46,45,47],[48,46,48,47],[43,48,43,49],[44,48,44,49],[45,48,45,49],[26,40,26,45],[27,40,27,45],[28,40,28,45],[29,40,29,45],[30,40,30,45],[34,40,34,45],[35,40,35,45],[36,40,36,45],[38,40,38,45],[39,40,39,45],[40,40,40,45],[41,40,41,45],[42,40,42,45],[43,40,43,45],[44,40,44,45],[45,40,45,45],[46,40,46,45],[31,40,31,45],[32,40,32,45],[94,4,94,7],[14,1,14,5],[13,1,13,5],[15,1,15,5],[8,1,8,5],[80,8,80,9],[59,1,62,9],[26,28,26,32],[27,28,27,32],[28,28,28,32],[10,32,10,33],[11,32,11,33],[12,32,12,33],[13,32,13,33],[14,32,14,33],[15,32,15,33],[16,32,16,33],[17,32,17,33],[18,32,18,33],[11,28,11,29],[12,28,12,29],[13,28,13,29],[14,28,14,29],[15,28,15,29],[1,1,3,5],[1,6,1,8],[1,9,3,9],[1,10,3,10],[1,11,3,11],[1,12,1,17],[1,18,1,23],[2,22,3,22],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,23,3,23],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21],[4,1,4,5],[5,1,5,5],[9,1,9,5],[10,1,10,5],[6,1,6,5],[7,1,7,5],[6,28,6,29],[7,28,7,29],[9,28,9,29],[10,28,10,29],[4,28,4,29],[11,34,11,35],[12,34,12,35],[13,34,13,35],[14,34,14,35],[15,34,15,35],[16,34,16,35],[17,34,17,35],[18,34,18,35],[16,28,16,29],[17,28,17,29],[18,28,18,29],[13,30,13,31],[15,30,15,31],[16,30,16,31],[17,30,17,31],[18,30,18,31],[14,30,14,31],[90,4,90,20],[1,24,1,27],[2,24,3,24],[2,25,3,25],[2,26,3,26],[2,27,3,27],[3,28,3,29],[3,30,3,31],[79,9,79,10],[73,1,73,7],[75,1,75,7],[74,1,74,7],[74,9,74,10],[76,1,76,7],[76,9,76,10],[71,1,71,7],[11,1,11,5],[17,1,17,5],[72,9,72,10],[77,9,77,10],[73,9,73,10],[75,9,75,10],[78,9,78,10],[66,9,66,10],[0,39,0,49],[3,51,3,52],[33,28,33,38],[52,33,52,35],[53,33,53,35],[52,36,52,38],[53,36,53,38],[54,28,54,32],[55,28,55,32],[54,33,54,35],[55,33,55,35],[54,36,54,38],[55,36,55,38],[52,28,52,32],[53,28,53,32],[30,33,30,35],[31,33,31,35],[30,36,30,38],[31,36,31,38],[33,40,33,45],[5,28,5,29],[8,28,8,29],[15,36,15,37],[10,34,10,35],[77,11,79,14],[73,11,76,14],[65,1,65,7],[70,11,70,14],[18,1,18,5],[16,1,16,5],[12,1,12,5],[69,9,69,10],[70,9,70,10],[71,9,71,10],[63,9,63,10],[64,9,64,10],[65,9,65,10],[67,9,67,10],[68,9,68,10]]}
[null,"EaRNed SUCCESS  |Monthly Dashboard | FY JAN 2017 - DEC 2017",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August 2017"]
[null,null,null,null,null,null,"Services this Month",null,null,"Delivered Services YTD","Avg Services / Mo. YTD*","Total Employees Served YTD","Requests this Month                    by Source",null,null,null,null,null,"Requests YTD                                   by Source",null,null,null,null,null,"Employee Request by Multiple YTD",null,null,null,"           Retention % a, b, c                ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee Utilization %"]
[null,null,null,null,null,null,"Delivered","Pending","Total Service Interfaces",null,null,null,"Total ","HR","Supervisor","Self","Co-Worker","Other","Total ","HR","Supervisor","Self","Co-Worker","Other","1x","2x","3x","4x+","YTD",null,null,null,"Q1",null,null,null,"Q2",null,null,null,"Q3",null,null,null,"Q4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Related",null,"ERN General ",null,"Service Related",null,"ERN General ",null,"Service Related",null,"ERN General ",null,"Service Related",null,"ERN General ",null,"Service Related",null,"ERN General ",null,null,null,null,"Don’t Delete"]
[null,{"$f":"INSTRUCTIONS!C11","v":"Anne Grady Corp."},null,null,null,null,null,9,{"$f":"SUM(G5:H5)","v":9},27,{"$f":"J5/INSTRUCTIONS!K11","v":3.8571428571428572},19,{"$f":"SUM(N5:R5)","v":5},0,null,3,2,0,{"$f":"SUM(T5:X5)","v":27},0,0,23,3,1,{"$f":"'3-Multiplr'!G56","v":19},{"$f":"'3-Multiplr'!H56","v":4},{"$f":"'3-Multiplr'!I56","v":0},{"$f":"'3-Multiplr'!J56","v":0},{"$f":"IFERROR(AZ5,0)","v":0},null,{"$f":"IFERROR(BA5,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,null,null,{"$f":"AVERAGE(AG5,AK5,AO5,AS5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(AI5,AN5,AR5,AU5)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"INSTRUCTIONS!C12","v":"Bittersweet Farms"},null,null,null,null,1,3,4,16,{"$f":"J6/INSTRUCTIONS!K12","v":2.6666666666666665},11,{"$f":"SUM(N6:R6)","v":1},0,null,1,0,0,{"$f":"SUM(T6:X6)","v":15},3,1,11,0,0,{"$f":"'3-Multiplr'!G57","v":11},{"$f":"'3-Multiplr'!H57","v":2},{"$f":"'3-Multiplr'!I57","v":0},{"$f":"'3-Multiplr'!J57","v":0},{"$f":"IFERROR(AZ6,0)","v":0},null,{"$f":"IFERROR(BA6,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1000000000000002E-2,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"INSTRUCTIONS!C13","v":"Champagne CRSI"},null,null,null,null,1,null,1,5,{"$f":"J7/INSTRUCTIONS!K13","v":0.83333333333333337},5,1,1,null,0,0,0,6,4,0,2,0,0,{"$f":"'3-Multiplr'!G58","v":6},{"$f":"'3-Multiplr'!H58","v":0},{"$f":"'3-Multiplr'!I58","v":0},{"$f":"'3-Multiplr'!J58","v":0},0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.7999999999999995E-2,null,null,{"$error":"#DIV/0!"},{"$f":"AVERAGE(AI7,AM7,AQ7,AU7)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"INSTRUCTIONS!C14","v":"Community Residential Svcs."},null,null,null,null,null,null,0,3,{"$f":"J8/INSTRUCTIONS!K14","v":0.375},2,0,null,null,null,null,0,1,0,0,1,0,0,{"$f":"'3-Multiplr'!G59","v":1},{"$f":"'3-Multiplr'!H59","v":0},{"$f":"'3-Multiplr'!I59","v":0},{"$f":"'3-Multiplr'!J59","v":0},0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2999999999999997E-2,null,null,{"$error":"#DIV/0!"},{"$f":"AVERAGE(AI8,AM8,AQ8,AU8)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"INSTRUCTIONS!C15","v":"Epilepsy Center"},null,null,null,null,null,null,0,8,{"$f":"J9/INSTRUCTIONS!K15","v":1.3333333333333333},6,0,null,null,null,null,0,6,1,0,5,0,0,{"$f":"'3-Multiplr'!G60","v":4},{"$f":"'3-Multiplr'!H60","v":1},{"$f":"'3-Multiplr'!I60","v":0},{"$f":"'3-Multiplr'!J60","v":0},0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.08,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"INSTRUCTIONS!C16","v":"Josina Lott"},null,null,null,null,null,null,0,null,{"$f":"J10/INSTRUCTIONS!K16","v":0},null,0,null,null,null,null,0,1,0,1,0,0,0,{"$f":"'3-Multiplr'!G61","v":1},{"$f":"'3-Multiplr'!H61","v":0},{"$f":"'3-Multiplr'!I61","v":0},{"$f":"'3-Multiplr'!J61","v":0},0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"INSTRUCTIONS!C17","v":"Sunshine Communities"},null,null,null,null,3,4,7,66,{"$f":"J11/INSTRUCTIONS!K17","v":9.4285714285714288},34,3,1,null,2,0,0,42,12,2,27,0,1,{"$f":"'3-Multiplr'!G62","v":30},{"$f":"'3-Multiplr'!H62","v":4},{"$f":"'3-Multiplr'!I62","v":0},{"$f":"'3-Multiplr'!J62","v":1},0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.1999999999999998E-2,null,null,{"$error":"#DIV/0!"},{"$f":"AVERAGE(AI11,AM11,AQ11,AU11)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"INSTRUCTIONS!C18","v":"Triad"},null,null,null,null,1,1,2,16,{"$f":"J12/INSTRUCTIONS!K18","v":2.6666666666666665},7,2,0,null,2,0,0,19,6,2,10,0,1,{"$f":"'3-Multiplr'!G63","v":15},{"$f":"'3-Multiplr'!H63","v":2},{"$f":"'3-Multiplr'!I63","v":0},{"$f":"'3-Multiplr'!J63","v":0},{"$f":"IFERROR(AZ12,0)","v":0},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AW11)","v":5.1999999999999998E-2},null,null,{"$error":"#DIV/0!"},{"$f":"AVERAGE(AI12,AM12,AQ12,AU12)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"INSTRUCTIONS!C19","v":0},null,null,null,null,null,null,0,null,{"$f":"J13/INSTRUCTIONS!K19","v":0},null,0,null,null,null,null,null,0,null,null,null,null,null,{"$f":"'3-Multiplr'!G64","v":0},{"$f":"'3-Multiplr'!H64","v":0},{"$f":"'3-Multiplr'!I64","v":0},{"$f":"'3-Multiplr'!J64","v":0},0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$f":"AVERAGE(AI13,AM13,AQ13,AU13)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"INSTRUCTIONS!C20","v":0},null,null,null,null,null,null,0,null,{"$f":"J14/INSTRUCTIONS!K20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Multiplr'!G65","v":0},{"$f":"'3-Multiplr'!H65","v":0},{"$f":"'3-Multiplr'!I65","v":0},{"$f":"'3-Multiplr'!J65","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$f":"AVERAGE(AI14,AM14,AQ14,AU14)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"INSTRUCTIONS!C21","v":0},null,null,null,null,null,null,0,null,{"$f":"J15/INSTRUCTIONS!K21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Multiplr'!G66","v":0},{"$f":"'3-Multiplr'!H66","v":0},{"$f":"'3-Multiplr'!I66","v":0},{"$f":"'3-Multiplr'!J66","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$f":"AVERAGE(AI15,AM15,AQ15,AU15)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"INSTRUCTIONS!C22","v":0},null,null,null,null,null,null,0,null,{"$f":"J16/INSTRUCTIONS!K22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-Multiplr'!G67","v":0},{"$f":"'3-Multiplr'!H67","v":0},{"$f":"'3-Multiplr'!I67","v":0},{"$f":"'3-Multiplr'!J67","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"INSTRUCTIONS!C23","v":0},null,null,null,null,null,null,0,null,{"$f":"J17/INSTRUCTIONS!K23","v":0},null,0,null,null,null,null,null,0,null,null,null,null,null,{"$f":"'3-Multiplr'!G68","v":0},{"$f":"'3-Multiplr'!H68","v":0},{"$f":"'3-Multiplr'!I68","v":0},{"$f":"'3-Multiplr'!J68","v":0},0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$f":"AVERAGE(AI17,AM17,AQ17,AU17)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"INSTRUCTIONS!C24","v":0},null,null,null,null,null,null,0,null,{"$f":"J18/INSTRUCTIONS!K24","v":0},null,0,null,null,null,null,null,0,null,null,null,null,null,{"$f":"'3-Multiplr'!G69","v":0},{"$f":"'3-Multiplr'!H69","v":0},{"$f":"'3-Multiplr'!I69","v":0},{"$f":"'3-Multiplr'!J69","v":0},0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Totals/Averages",null,null,null,null,{"$f":"SUM(G5:G18)","v":6},17,23,141,{"$f":"SUM(K5:K18)","v":21.160714285714288},84,12,2,0,8,2,0,117,26,6,79,3,3,87,13,0,1,{"$f":"IFERROR(AVERAGEIF(AC5:AC18,\"<>0\"),0)","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,5.7999999999999996E-2]
[]
[null,"* Average Services / YTD count adjusted to month ER joined ERN"]
[null,null,null,null,null,null,null,null,null,null,null,null,"aaa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ee Served-Type",null,null,null,null,"Month",null,null,"YTD",null,null,null,"Service by Category",null,null,null,null,null,"Mo",null,"YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total ODJFS",null,null,null,null,{"$f":"SUM(AH24:AJ25)","v":1},null,null,{"$f":"SUM(AK24:AK25)","v":1},null,null,null,"Auto Repair",null,null,null,null,null,{"$f":"'3-ServiceCats'!L27","v":0},null,{"$f":"'3-ServiceCats'!L29","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Incumbent ODJFS",null,null,null,null,1,null,null,1,null,null,null,"Career Counseling",null,null,null,null,null,{"$f":"'3-ServiceCats'!M27","v":0},null,{"$f":"'3-ServiceCats'!M29","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   New ODJFS",null,null,null,null,null,null,null,null,null,null,null,"Child Care",null,null,null,null,null,{"$f":"'3-ServiceCats'!N27","v":1},null,{"$f":"'3-ServiceCats'!N29","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-ODJFS",null,null,null,null,{"$f":"SUM(AH27:AJ28)","v":0},null,null,{"$f":"SUM(AK27:AK28)","v":1},null,null,null,"Child Support",null,null,null,null,null,{"$f":"'3-ServiceCats'!O27","v":0},null,{"$f":"'3-ServiceCats'!O29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Former ODJFS",null,null,null,null,null,null,null,null,null,null,null,"Clothing",null,null,null,null,null,{"$f":"'3-ServiceCats'!P27","v":0},null,{"$f":"'3-ServiceCats'!P29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Never ODJFS",null,null,null,null,null,null,null,1,null,null,null,"Coaching",null,null,null,null,null,{"$f":"'3-ServiceCats'!Q27","v":1},null,{"$f":"'3-ServiceCats'!Q29","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unk/Uncoded",null,null,null,null,5,null,null,82,null,null,null,"Comm Food Rsrc",null,null,null,null,null,{"$f":"'3-ServiceCats'!R27","v":0},null,{"$f":"'3-ServiceCats'!R29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Counseling Request",null,null,null,null,null,{"$f":"'3-ServiceCats'!S27","v":1},null,{"$f":"'3-ServiceCats'!S29","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Domestic Violence",null,null,null,null,null,{"$f":"'3-ServiceCats'!T27","v":0},null,{"$f":"'3-ServiceCats'!T29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(AH23,AH26,AH29)","v":6},null,null,{"$f":"SUM(AK23,AK26,AK29)","v":84},null,null,null,"Education",null,null,null,null,null,{"$f":"'3-ServiceCats'!U27","v":0},null,{"$f":"'3-ServiceCats'!U29","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,"5-Pies'!C14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elder Care",null,null,null,null,null,{"$f":"'3-ServiceCats'!V27","v":0},null,{"$f":"'3-ServiceCats'!V29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loans",null,null,null,null,null,null,null,null,null,null,null,"Emergency",null,null,null,null,null,{"$f":"'3-ServiceCats'!W27","v":0},null,{"$f":"'3-ServiceCats'!W29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23a",null,null,null,null,null,"23b",null,null,null,null,null,null,null,"New Loans this Month",null,null,null,null,null,null,null,0,null,null,null,"Employment-Retention",null,null,null,null,null,{"$f":"'3-ServiceCats'!X27","v":0},null,{"$f":"'3-ServiceCats'!X29","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disbursed this Month",null,null,null,null,null,null,null,null,null,null,null,"Financial",null,null,null,null,null,{"$f":"'3-ServiceCats'!Y27","v":0},null,{"$f":"'3-ServiceCats'!Y29","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open Bridge Loans",null,null,null,null,null,null,null,null,null,null,null,"Financial Literacy",null,null,null,null,null,{"$f":"'3-ServiceCats'!Z27","v":1},null,{"$f":"'3-ServiceCats'!Z29","v":18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paid/Clsed Bridge Loans",null,null,null,null,null,null,null,null,null,null,null,"Food Assistance",null,null,null,null,null,{"$f":"'3-ServiceCats'!AA27","v":1},null,{"$f":"'3-ServiceCats'!AA29","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Disbursed",null,null,null,null,null,null,null,2000,null,null,null,"Homeless Prev.",null,null,null,null,null,{"$f":"'3-ServiceCats'!AB27","v":0},null,{"$f":"'3-ServiceCats'!AB29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Balance Remaining",null,null,null,null,null,null,null,null,null,null,null,"Furniture",null,null,null,null,null,{"$f":"'3-ServiceCats'!AC27","v":0},null,{"$f":"'3-ServiceCats'!AC29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Savings",null,null,null,null,null,null,null,null,null,null,null,"Govt Agency Nav.",null,null,null,null,null,{"$f":"'3-ServiceCats'!AD27","v":0},null,{"$f":"'3-ServiceCats'!AD29","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delinquent",null,null,null,null,null,null,null,null,null,null,null,"Hard Training",null,null,null,null,null,{"$f":"'3-ServiceCats'!AE27","v":0},null,{"$f":"'3-ServiceCats'!AE29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loss",null,null,null,null,null,null,null,null,null,null,null,"Health/Insurance",null,null,null,null,null,{"$f":"'3-ServiceCats'!AF27","v":0},null,{"$f":"'3-ServiceCats'!AF29","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loss %",null,null,null,null,null,null,null,{"$f":"AK43/AK39","v":0},null,null,null,"Home Repair",null,null,null,null,null,{"$f":"'3-ServiceCats'!AG27","v":0},null,{"$f":"'3-ServiceCats'!AG29","v":2}]
[null,"Story Rank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Homeless Shelter",null,null,null,null,null,{"$f":"'3-ServiceCats'!AH27","v":0},null,{"$f":"'3-ServiceCats'!AH29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Fin Supt",null,null,null,null,"Month",null,null,"YTD",null,null,null,"Housing",null,null,null,null,null,{"$f":"'3-ServiceCats'!AI27","v":0},null,{"$f":"'3-ServiceCats'!AI29","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Priv/Com Rsrc",null,null,null,null,473,null,null,473,null,null,null,"Immigration",null,null,null,null,null,{"$f":"'3-ServiceCats'!AJ27","v":0},null,{"$f":"'3-ServiceCats'!AJ29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DHHS",null,null,null,null,null,null,null,null,null,null,null,"Legal Assistance",null,null,null,null,null,{"$f":"'3-ServiceCats'!AK27","v":0},null,{"$f":"'3-ServiceCats'!AK29","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt Public Asst",null,null,null,null,null,null,null,null,null,null,null,"Literacy",null,null,null,null,null,{"$f":"'3-ServiceCats'!AL27","v":0},null,{"$f":"'3-ServiceCats'!AL29","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loan  ",null,null,null,null,null,null,null,2000,null,null,null,"Other",null,null,null,null,null,{"$f":"'3-ServiceCats'!AM27","v":0},null,{"$f":"'3-ServiceCats'!AM29","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Com Food Rsrc",null,null,null,null,null,null,null,null,null,null,null,"Soft Training",null,null,null,null,null,{"$f":"'3-ServiceCats'!AN27","v":0},null,{"$f":"'3-ServiceCats'!AN29","v":14}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas Card",null,null,null,null,null,null,null,null,null,null,null,"Sub.Abuse/Addictns",null,null,null,null,null,{"$f":"'3-ServiceCats'!AO27","v":0},null,{"$f":"'3-ServiceCats'!AO29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bus Pass",null,null,null,null,null,null,null,null,null,null,null,"Transportation",null,null,null,null,null,{"$f":"'3-ServiceCats'!AP27","v":0},null,{"$f":"'3-ServiceCats'!AP29","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilities",null,null,null,null,null,{"$f":"'3-ServiceCats'!AQ27","v":1},null,{"$f":"'3-ServiceCats'!AQ29","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water/Public Health",null,null,null,null,null,{"$f":"'3-ServiceCats'!AR27","v":0},null,{"$f":"'3-ServiceCats'!AR29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(AD47:AH55)","v":473},null,null,{"$f":"SUM(AK47:AM55)","v":2473},null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(AU23:AU55)","v":6},null,{"$f":"SUM(AW23:AW55)","v":141}]
[null,"a - % of ees that were served & still employed or not terminated for a reason related to an issue addressed by the SC during a rolling 12-month lookback & not counted during a previous Q.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b - the overall retention % of all ERN ees",null,null,null,null,null,null,null,null,"c - Insufficient data provided by member to calculate"]
[]
[null,"AUDIT TABLE",null,null,null,"Link ","to Audit Legend colors"]
[null,"Each matched color pair should be equal (note comment on bottom purple cell).  If not, click on the numbers to jump to the source cell above to audit your work.  Once there, click on the source cell to jump back to the audit table"]
[]
[]
[]
[null,"Services this Month - Delivered - Total                              ",null,null,null,null,null,null,1,{"$f":"G19","v":6}]
[null,"Service by Category - Mo - Total                          ",null,null,null,null,null,null,2,{"$f":"AU56","v":6}]
[null,"Delivered Services YTD                                ",null,null,null,null,null,null,3,{"$f":"J19","v":141}]
[null,"Service by Category - YTD                            ",null,null,null,null,null,null,4,{"$f":"AW56","v":141}]
[null,"Unique Emps. Served YTD                                       ",null,null,null,null,null,null,5,{"$f":"L19","v":84}]
[null,"Served/Unq Ee - YTD- Total                              ",null,null,null,null,null,null,6,{"$f":"AK32","v":84}]
[null,"Bridge Loans - Disbursed this Month                        ",null,null,null,null,null,null,7,{"$f":"AK36","v":0}]
[null,"Total Fin Supt - Loan - Month                         ",null,null,null,null,null,null,8,{"$f":"AH50","v":0},null,"blank if 0"]
[null,"Requests YTD by Source - Total",null,null,null,null,null,null,9,{"$f":"S19","v":117}]
[null,"Employee Request by Multiple YTD 1,2,3,4+",null,null,null,null,null,null,10,{"$f":"'3-Multiplr'!F73","v":117}]
[null,"Monthly - CV and Non-CV/Unk (if CV region)",null,null,null,null,null,null,11,null,null,"CV Regions Only:\n-Will only match if you have no EEs w/ unknown CV status"]
[null,"Month - Ee Served-Type",null,null,null,null,null,null,11]
[null,"YTD - CV and Non-CV/Unk (if CV region)",null,null,null,null,null,null,12]
[null,"YTD - Ee Served-Type",null,null,null,null,null,null,13]
[null,"Are Total Interfaces greater than Requests?",null,null,null,null,null,null,14,{"$f":"IF(I19>M19,\"Yes\",\"No\")","v":"Yes"},null,"< Should be Yes 99.99% of the time"]
[null,"Are YTD Services greater than YTD Request?",null,null,null,null,null,null,15,{"$f":"IF(J19>S19,\"Yes\",\"No\")","v":"Yes"}]
[null,"Trendline Services greater than Requests?",null,null,null,null,null,null,16,{"$f":"IF('4-Trends'!O24>'4-Trends'!O13,\"Yes\",\"No\")","v":"Yes"}]
[]
[null," Checklist  - Starting and Finalizing the Report"]
[null,"*Field inputs requiring working in the formula bar at the top rather than working in the cell"]
[]
[null,null,null,1,"Save your file using the naming convention at the right (yellow box)"]
[null,null,null,2,"Save often"]
[null,null,"*",3,"Click ","here","to enter the ERN name and insure the fiscal year is current"]
[null,null,"*",4,"Click ","here","to enter the correct reporting month in the title row"]
[null,null,null,5,"Click ","here","to enter the correct  month code"]
[null,null,null,6,"Click to visit the ",null,null,null,"Audit Table",null,"to double check your work."]
[null,null,null,7,"Adjust the LEFT axis SCALE UNITS on the trendlines so there is not blank space up top and so they are the same top #s for Services and Referrals.  Insure you check the loan trendlines also.  To learn how to adjust them watch the Youtube video link below"]
[]
[]
[]
[null,null,null,null,"Adjust the Unit Scale"]
[null,null,null,7,"Save a copy as a pdf to email to James/Duane/HR after the meeting"]

{"sheet":"3-Multiplr","index":3,"n_rows":76,"n_cols":45,"rows_kept":76,"cut":false,"hidden":false,"merged":[[10,16,10,17],[75,7,76,11],[53,2,53,3],[53,4,53,5]]}
[]
[null,null,null,null,"Automated Request Multiplier Input Tool"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Example Illustration"]
[null,"X->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLICK"]
[null,null,null,null,null," "]
[]
[null,null,null,null," "]
[null,null,"Example"]
[null,null,null,null,"Match to Count Numbers Columns Below"]
[null,"¶","Company Name",null,1,2,3,4,6,9,10,11]
[null,null,"Co 1","Record Count",17,6,1,2,0,0,0,0,26]
[null,null,"Co 2","Record Count",19,4,0,1,0,0,0,0,24]
[null,null,"Co 3","Record Count",33,5,2,2,0,1,0,1,{"$f":"SUM(E20:L20)","v":44}]
[null,null,null,null,"Continious Block 1-5",null,null,null,6,"Continious Block 9-11"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Company Match Audit",null,"Should Match",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V V        Match Count Numbers  Here      V V"]
[null,null,"Correct List","Should match left list","Dash","Here",1,2,3,"4+",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35]
[null,1,{"$f":"'2-Dashboard'!B5","v":"Anne Grady Corp."},{"$f":"C34","v":0},{"$f":"'2-Dashboard'!S5","v":27},{"$f":"K56*$K$55+L56*$L$55+M56*$M$55+N56*$N$55+O56*$O$55+P56*$P$55+Q56*$Q$55+R56*$R$55+S56*$S$55+T56*$T$55+U56*$U$55+V56*$V$55+W56*$W$55+X56*$X$55","v":27},{"$f":"K56","v":19},{"$f":"L56","v":4},{"$f":"M56","v":0},{"$f":"SUM(N56:AS56)","v":0},19,4,0,0]
[null,2,{"$f":"'2-Dashboard'!B6","v":"Bittersweet Farms"},{"$f":"C35","v":0},{"$f":"'2-Dashboard'!S6","v":15},{"$f":"K57*$K$55+L57*$L$55+M57*$M$55+N57*$N$55+O57*$O$55+P57*$P$55+Q57*$Q$55+R57*$R$55+S57*$S$55+T57*$T$55+U57*$U$55+V57*$V$55+W57*$W$55+X57*$X$55","v":15},{"$f":"K57","v":11},2,0,{"$f":"SUM(N57:AS57)","v":0},11,2]
[null,3,{"$f":"'2-Dashboard'!B7","v":"Champagne CRSI"},0,{"$f":"'2-Dashboard'!S7","v":6},6,6,0,0,0,6]
[null,4,{"$f":"'2-Dashboard'!B8","v":"Community Residential Svcs."},0,{"$f":"'2-Dashboard'!S8","v":1},1,1,0,0,0,1]
[null,5,{"$f":"'2-Dashboard'!B9","v":"Epilepsy Center"},0,{"$f":"'2-Dashboard'!S9","v":6},6,4,1,0,0,4,1]
[null,6,{"$f":"'2-Dashboard'!B10","v":"Josina Lott"},0,{"$f":"'2-Dashboard'!S10","v":1},1,1,0,0,0,1]
[null,7,{"$f":"'2-Dashboard'!B11","v":"Sunshine Communities"},0,{"$f":"'2-Dashboard'!S11","v":42},42,30,4,0,1,30,4,0,1]
[null,8,{"$f":"'2-Dashboard'!B12","v":"Triad"},0,{"$f":"'2-Dashboard'!S12","v":19},19,15,2,0,0,15,2]
[null,9,{"$f":"'2-Dashboard'!B13","v":0},0,{"$f":"'2-Dashboard'!S13","v":0},0,0,0,0,0]
[null,10,{"$f":"'2-Dashboard'!B14","v":0},0,{"$f":"'2-Dashboard'!S14","v":0},0,0,0,0,0]
[null,11,{"$f":"'2-Dashboard'!B15","v":0},0,{"$f":"'2-Dashboard'!S15","v":0},0,{"$f":"K66","v":0},{"$f":"L66","v":0},{"$f":"M66","v":0},{"$f":"SUM(N66:AS66)","v":0}]
[null,12,{"$f":"'2-Dashboard'!B16","v":0},0,{"$f":"'2-Dashboard'!S16","v":0},{"$f":"K67*$K$55+L67*$L$55+M67*$M$55+N67*$N$55+O67*$O$55+P67*$P$55+Q67*$Q$55+R67*$R$55+S67*$S$55+T67*$T$55+U67*$U$55+V67*$V$55+W67*$W$55+X67*$X$55","v":0},{"$f":"K67","v":0},{"$f":"L67","v":0},{"$f":"M67","v":0},{"$f":"SUM(N67:AS67)","v":0}]
[null,13,{"$f":"'2-Dashboard'!B17","v":0},0,{"$f":"'2-Dashboard'!S17","v":0},0,0,0,0,0]
[null,14,{"$f":"'2-Dashboard'!B18","v":0},0,{"$f":"'2-Dashboard'!S18","v":0},0,0,0,0,0]
[null,null,"Summary Row",null,{"$f":"SUM(E56:E69)","v":117},{"$f":"SUM(F56:F69)","v":117},{"$f":"SUM(G56:G69)","v":87},{"$f":"SUM(H56:H69)","v":13},{"$f":"SUM(I56:I69)","v":0},1,{"$f":"SUM(K56:K69)","v":87},13,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Multiple Row",null,null,null,{"$f":"G70*G55","v":87},{"$f":"H70*H55","v":26},{"$f":"I70*I55","v":0},4,null,null,null,{"$f":"N70*N55","v":4},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"â"]
[null,"Total to Audit Table",null,null,null,{"$f":"SUM(G71:J71)","v":117}]
[null,"Requst Count from Dashboard",null,null,null,{"$f":"'2-Dashboard'!J72","v":117}]
[]
[null,null,null,null,null,null,null,"Click to return to dashboard"]

{"sheet":"3-Multiplr (2)","index":4,"n_rows":76,"n_cols":45,"rows_kept":76,"cut":false,"hidden":true,"merged":[[10,16,10,17],[53,2,53,3],[53,4,53,5],[75,7,76,11]]}
[]
[null,null,null,null,"Automated Request Multiplier Input Tool"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Example Illustration"]
[null,"X->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLICK"]
[null,null,null,null,null," "]
[]
[null,null,null,null," "]
[null,null,"Example"]
[null,null,null,null,"Match to Count Numbers Columns Below"]
[null,"¶","Company Name",null,1,2,3,4,6,9,10,11]
[null,null,"Co 1","Record Count",17,6,1,2,0,0,0,0,26]
[null,null,"Co 2","Record Count",19,4,0,1,0,0,0,0,24]
[null,null,"Co 3","Record Count",33,5,2,2,0,1,0,1,{"$f":"SUM(E20:L20)","v":44}]
[null,null,null,null,"Continious Block 1-5",null,null,null,6,"Continious Block 9-11"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Company Name",null,1,2,3,4,5,6,7,9,10]
[null,null,"Aspen","Record Count",33,5,2,2,0,1,0,0,0,43]
[null,null,"Corium","Record Count",11,2,0,0,0,0,0,0,0,13]
[null,null,"Holland Home","Record Count",46,6,4,2,1,0,1,0,0,60]
[null,null,"Ranir","Record Count",39,4,1,0,1,0,2,1,1,49]
[null,null,"Sunset","Record Count",24,2,3,1,1,1,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Company Match Audit",null,"Should Match",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V V        Match Count Numbers  Here      V V"]
[null,null,"Correct List","Should match left list","Dash","Here",1,2,3,"4+",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35]
[null,1,{"$f":"'2-Dashboard'!B5","v":"Anne Grady Corp."},{"$f":"C34","v":"Aspen"},{"$f":"'2-Dashboard'!S5","v":27},{"$f":"K56*$K$55+L56*$L$55+M56*$M$55+N56*$N$55+O56*$O$55+P56*$P$55+Q56*$Q$55+R56*$R$55+S56*$S$55+T56*$T$55+U56*$U$55+V56*$V$55+W56*$W$55+X56*$X$55","v":63},{"$f":"K56","v":33},{"$f":"L56","v":5},{"$f":"M56","v":2},{"$f":"SUM(N56:AS56)","v":3},33,5,2,2,0,1,0,null,0,0]
[null,2,{"$f":"'2-Dashboard'!B6","v":"Bittersweet Farms"},{"$f":"C35","v":"Corium"},{"$f":"'2-Dashboard'!S6","v":15},{"$f":"K57*$K$55+L57*$L$55+M57*$M$55+N57*$N$55+O57*$O$55+P57*$P$55+Q57*$Q$55+R57*$R$55+S57*$S$55+T57*$T$55+U57*$U$55+V57*$V$55+W57*$W$55+X57*$X$55","v":15},{"$f":"K57","v":11},2,0,{"$f":"SUM(N57:AS57)","v":0},11,2,0,0,0,0,0,null,0,0]
[null,3,{"$f":"'2-Dashboard'!B7","v":"Champagne CRSI"},"Holland Home",{"$f":"'2-Dashboard'!S7","v":6},90,46,6,4,4,46,6,4,2,1,0,1,null,0,0]
[null,4,{"$f":"'2-Dashboard'!B8","v":"Community Residential Svcs."},"Ranir",{"$f":"'2-Dashboard'!S8","v":1},88,39,4,1,5,39,4,1,0,1,0,2,null,1,1]
[null,5,{"$f":"'2-Dashboard'!B9","v":"Epilepsy Center"},"Sunset",{"$f":"'2-Dashboard'!S9","v":6},52,24,2,3,3,24,2,3,1,1,1,0,null,0,0]
[null,6,{"$f":"'2-Dashboard'!B10","v":"Josina Lott"},0,{"$f":"'2-Dashboard'!S10","v":1},0,0,0,0,0]
[null,7,{"$f":"'2-Dashboard'!B11","v":"Sunshine Communities"},0,{"$f":"'2-Dashboard'!S11","v":42},0,0,0,0,0]
[null,8,{"$f":"'2-Dashboard'!B12","v":"Triad"},0,{"$f":"'2-Dashboard'!S12","v":19},0,0,0,0,0]
[null,9,{"$f":"'2-Dashboard'!B13","v":0},0,{"$f":"'2-Dashboard'!S13","v":0},0,0,0,0,0]
[null,10,{"$f":"'2-Dashboard'!B14","v":0},0,{"$f":"'2-Dashboard'!S14","v":0},0,0,0,0,0]
[null,11,{"$f":"'2-Dashboard'!B15","v":0},0,{"$f":"'2-Dashboard'!S15","v":0},0,{"$f":"K66","v":0},{"$f":"L66","v":0},{"$f":"M66","v":0},{"$f":"SUM(N66:AS66)","v":0}]
[null,12,{"$f":"'2-Dashboard'!B16","v":0},0,{"$f":"'2-Dashboard'!S16","v":0},0,{"$f":"K67","v":0},0,0,{"$f":"SUM(N67:AS67)","v":0}]
[null,13,{"$f":"'2-Dashboard'!B17","v":0},0,{"$f":"'2-Dashboard'!S17","v":0},0,0,0,0,0]
[null,14,{"$f":"'2-Dashboard'!B18","v":0},0,{"$f":"'2-Dashboard'!S18","v":0},0,0,0,0,0]
[null,null,"Summary Row",null,{"$f":"SUM(E56:E69)","v":117},{"$f":"SUM(F56:F69)","v":308},{"$f":"SUM(G56:G69)","v":153},{"$f":"SUM(H56:H69)","v":19},{"$f":"SUM(I56:I69)","v":10},15,{"$f":"SUM(K56:K69)","v":153},19,10,5,3,2,3,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Multiple Row",null,null,null,{"$f":"G70*G55","v":153},{"$f":"H70*H55","v":38},{"$f":"I70*I55","v":30},87,null,null,null,{"$f":"N70*N55","v":20},15,12,21,0,9,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"â"]
[null,"Total to Audit Table",null,null,null,{"$f":"SUM(G71:J71)","v":308}]
[null,"Requst Count from Dashboard",null,null,null,{"$f":"'2-Dashboard'!J72","v":117}]
[]
[null,null,null,null,null,null,null,"Click to return to dashboard"]

{"sheet":"3-ServiceCats","index":5,"n_rows":32,"n_cols":46,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,19,32,28]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]
[]
[null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Insert Month #15 Service Cat data here",null,null,null,null,null,null,null,null,"Click",0,0,1,0,0,1,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,null,null,{"$f":"SUM(L27:AS27)","v":6}]
[]
[null,"Insert YTD #16 Service Cat data here ",null,null,null,null,null,null,null,null,"Click",4,11,3,0,0,11,0,4,0,6,0,0,6,9,18,2,0,0,2,0,15,2,0,6,0,6,1,8,14,0,4,9,null,null,{"$f":"SUM(L29:AS29)","v":141}]
[]
[null,null,null,null,null,null,null,null,null,null,"^"]
[null,null,null,null,null,null,null,null,null,null,"Click above links to access SF page",null,null,null,null,null,null,null,null,"CLICK TO GO BACK TO DASHBOARD"]

{"sheet":"4-Trends","index":6,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,16,35,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Requests Per Month |Multi -Year Comparison"]
[null,null,"Jan ","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Previous FY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C11:N11)","v":0}]
["Prev FY Gap fill","Rare!"]
["FY16/17","click",1,10,34,20,18,11,11,12,null,null,null,null,{"$f":"SUM(C13:N13)","v":117}]
["FY Gap Fill","Rare!"]
[null,null,null,null,null," "]
[]
[null,null,null,null," "]
[]
[]
[null,null,"Delivered Services Per Month | Multi-Year Comparison"]
[null,null,"Jan ","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Previous FY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C22:N22)","v":0}]
["Prev FY Gap fill","Rare!"]
["FY16/17","click",1,9,41,25,30,13,16,6,null,null,null,null,{"$f":"SUM(C24:N24)","v":141}]
["FY Gap Fill","Rare!"]
[]
[]
[]
[]
[]
[]
[null,null,"Loans $ Delivered Per Month  | Multi- Year Comparison"]
[null,null,"Jan ","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Previous FY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C34:N34)","v":0},null,"Click to Go Back to Dashboard"]
["Prev FY Gap fill"]
["FY16/17",null,null,null,null,1000,1000,0,0,0,null,null,null,null,{"$f":"SUM(C36:N36)","v":2000}]
["FY Gap Fill"]

{"sheet":"5-Pies","index":7,"n_rows":36,"n_cols":34,"rows_kept":36,"cut":false,"hidden":false,"merged":[[17,9,20,11]]}
[]
[]
[]
[]
[]
[]
[null,"Type","Loans -  Program To Date by Type                                       "]
[null,"Incmbnt DHHS"]
[null,"New DHHS"]
[null,"Frmr DHHS"]
[null,"Never DHHS",1,null,null,"To rotate the position of the slices in a pie chart for better label visability visit ... "]
[null,"Unknown",1,null,null," "]
[null,null,"^",{"$f":"SUM(C8:C12)","v":2}]
[null,null,"Click Here",null," "]
[null,null,null,null,null,"To remove any low (less than 5?) value data labels,"]
[null,null,null,null,null," click multiple times on the specifc label until just that label shows and then hit the delete key."]
[]
[null,null,null,"S",null,null,null,null,null,"Click to return to dashboard after pasting data"]
[]
[]
[null,"Insert  - Loan by Need Reason in row 25 below in the green cell"]
[null,"Click Here"]
[]
[null,"Auto Repair","Career Counseling","Child Care","Child Support","Clothing","Coaching","Comm Food Rsrc","Counseling Request","Domestic Violence","Education","Elder Care","Emergency","Employment","Financial","Financial Literacy","Food Assistance","Homeless Prev.","Furniture","Govt Agency Nav.","Hard Training","Health/Insurance","Home Repair","Homeless Shelter","Housing","Immigration","Legal Assistance","Literacy","Other","Soft Training","Sub. Abuse/Addictions","Transportation","Utilities","Water/Public Health"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,1]
[]
[{"$f":"SUM(B25:AH25)","v":2}]
[null,null,"YTD Loan $ by Need Reason"]
[null,"Auto Repair",{"$f":"B25","v":0},"<"]
[null,"Car Purchase",{"$f":"AF25","v":0},"<"]
[null,"Financial",{"$f":"O25","v":1},"< - all data populates from below"]
[null,"Homless Prev.",{"$f":"R25","v":0},"<"]
[null,"Home Repair",{"$f":"W25","v":0},"<"]
[null,"Utilities",{"$f":"AG25","v":0}]
[null,"Other",{"$f":"SUM(C25:N25,P25:Q25,S25:V25,X25:AE25,AH25)","v":1}]
[null,null,null,{"$f":"SUM(C29:C35)","v":2}]

{"sheet":"Paste ER Names","index":8,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":true,"merged":[[17,0,17,4],[18,0,18,4],[19,0,19,4],[12,0,12,4],[13,0,13,4],[14,0,14,4],[15,0,15,4],[16,0,16,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[10,0,10,4],[11,0,11,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4],[6,0,6,4]]}
[]
["Paste names from Dashboard sheet below"]
[{"$f":"'2-Dashboard'!B5","v":"Anne Grady Corp."}]
[{"$f":"'2-Dashboard'!B6","v":"Bittersweet Farms"}]
[{"$f":"'2-Dashboard'!B7","v":"Champagne CRSI"}]
[{"$f":"'2-Dashboard'!B8","v":"Community Residential Svcs."}]
[{"$f":"'2-Dashboard'!B9","v":"Epilepsy Center"}]
[{"$f":"'2-Dashboard'!B10","v":"Josina Lott"}]
[{"$f":"'2-Dashboard'!B11","v":"Sunshine Communities"}]
[{"$f":"'2-Dashboard'!B12","v":"Triad"}]
[{"$f":"'2-Dashboard'!B13","v":0}]
[{"$f":"'2-Dashboard'!B17","v":0}]

{"sheet":"Serices Graph","index":9,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":true,"merged":[[1,14,1,15]]}
[]
[null,"  GLBERN |Monthly Dashboard | FY OCT 2016 - SEP 2017",null,null,null,null,null,null,null,null,null,null,null,null,"August 2017"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,55,null,null,101]
[null,null,null,null,null,null,2,null,null,10,null,7]

{"sheet":"6-CatCoPaste","index":10,"n_rows":45,"n_cols":35,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,2,25,2]]}
["STEP 1.   Click here to access the SF Cat by Company report","STEP 2.   Copy and then Paste raw data into the Blue Cell below (click here to jump there)","STEP 3. see cell A29\n\nSTEP 4.  see cell A29\n\nSTEP 5.  Scroll down to row 36"]
[]
[null,null,"STEP 6.   Copy  all numbers from where you pasted them below (starting in B38) once blank rows are removed.  \n\nSTEP 7.   Tranpose paste into adjacent Green Cell (ask Duane if you don’t know how) .\n\nSTEP 8.  The data will auto populate onto the next tab.",2,1,0,0,0,null,0,1]
[null,null,null,0,2,3,0,0,null,5,1]
[null,null,null,1,0,0,0,0,null,2,0]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,2,0,1,0,1,null,6,1]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,1,1,0,0,0,null,2,0]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,1,1,0,0,0,null,4,0]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,0,1,0,0,1,null,4,0]
[null,null,null,5,0,0,0,0,null,4,0]
[null,null,null,2,3,0,0,5,null,4,4]
[null,null,null,0,0,0,0,0,null,1,1]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,0,0,0,0,0,null,2,0]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,2,2,0,2,0,null,8,1]
[null,null,null,1,0,0,0,0,null,1,0]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,1,0,0,0,0,null,4,1]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,1,1,0,0,0,null,3,1]
[null,null,null,0,0,0,0,0,null,1,0]
[null,null,null,2,2,0,0,0,null,1,3]
[null,null,null,0,1,0,0,1,null,11,1]
[null,null,null,0,0,0,0,0,null,0,0]
[null,null,null,2,0,0,1,0,null,1,0]
[null,null,null,4,1,1,0,0,null,2,1]
[]
[null,null,null,"Auto Repair","Career Counseling","Child Care","Child Support","Clothing","Coaching","Food - Community","Counseling Referral","Domestic Violence","Education","Elder Care","Emergency","Employment-RETENTION","Financial","Financial Literacy","Food - FAP/SNAP","Foreclosure/Evic Prev.","Furniture","Govt. Agency Navigation","Hard Training","Health/Insurance","Home Repair","Homeless Shelter","Housing","Immigration","Legal Assistance","Literacy","Other","Soft Training","Sub. Abuse/Addictions","Transportation","Utilities"]
[]
[null,null,"Company Name: Anne Grady Corp.(27 records)",2,0,1,0,0,2,0,1,0,1,0,0,0,5,2,0,0,0,0,0,2,1,0,1,0,1,0,2,0,0,2,4]
[null,null,"Company Name: Bittersweet Farms (16 records)",1,2,0,0,0,0,0,1,0,1,0,0,1,0,3,0,0,0,0,0,2,0,0,0,0,1,0,2,1,0,0,1]
[null,null,"Company Name: Champagne (CRSI) (5 records)",0,3,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,null,"Company Name: CRS Community Residential Services (3 records)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,1,0]
[null,null,"Company Name: Epilepsy Center (8 records)",0,0,0,0,0,1,0,0,0,0,0,0,1,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0]
[]
[null,null,"Company Name: Sunshine Communities(66 records)",0,5,2,0,0,6,0,2,0,4,0,0,4,4,4,1,0,0,2,0,8,1,0,4,0,3,1,1,11,0,1,2]
[null,null,"Company Name: Triad(16 records)",1,1,0,0,0,1,0,0,0,0,0,0,0,0,4,1,0,0,0,0,1,0,0,1,0,1,0,3,1,0,0,1]

{"sheet":"7-CatCoReport","index":11,"n_rows":54,"n_cols":23,"rows_kept":54,"cut":false,"hidden":false,"merged":[[5,6,5,8],[35,6,35,8],[41,6,41,8]]}
[]
[]
[]
[null,null,null,null,null,null,{"$f":"LEFT(G54,LEN(G54)-44)","v":"EaRNed SUCCESS "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2-Dashboard'!AN1","v":"August 2017"}]
[]
[null,null,null,null,null,null,null,null,null," Totals",{"$f":"'Paste ER Names'!A3","v":"Anne Grady Corp."},{"$f":"'Paste ER Names'!A4","v":"Bittersweet Farms"},{"$f":"'Paste ER Names'!A5","v":"Champagne CRSI"},{"$f":"'Paste ER Names'!A6","v":"Community Residential Svcs."},{"$f":"'Paste ER Names'!A7","v":"Epilepsy Center"},{"$f":"'Paste ER Names'!A8","v":"Josina Lott"},{"$f":"'Paste ER Names'!A9","v":"Sunshine Communities"},{"$f":"'Paste ER Names'!A10","v":"Triad"},{"$f":"'Paste ER Names'!A11","v":0},{"$f":"'Paste ER Names'!A12","v":0},{"$f":"'Paste ER Names'!A13","v":0}," "]
[]
[null,null,null,null,null,null,"YTD - Service by Category Type"]
[null,null,null,null,null,null,"Auto Repair",null,null,{"$f":"SUM(K9:U9)","v":4},{"$f":"'6-CatCoPaste'!D3","v":2},{"$f":"'6-CatCoPaste'!E3","v":1},{"$f":"'6-CatCoPaste'!F3","v":0},{"$f":"'6-CatCoPaste'!G3","v":0},{"$f":"'6-CatCoPaste'!H3","v":0},{"$f":"'6-CatCoPaste'!I3","v":0},{"$f":"'6-CatCoPaste'!J3","v":0},{"$f":"'6-CatCoPaste'!K3","v":1},{"$f":"'6-CatCoPaste'!L3","v":0},{"$f":"'6-CatCoPaste'!M3","v":0},{"$f":"'6-CatCoPaste'!N3","v":0}]
[null,null,null,null,null,null,"Career Counseling",null,null,11,{"$f":"'6-CatCoPaste'!D4","v":0},{"$f":"'6-CatCoPaste'!E4","v":2},{"$f":"'6-CatCoPaste'!F4","v":3},{"$f":"'6-CatCoPaste'!G4","v":0},{"$f":"'6-CatCoPaste'!H4","v":0},{"$f":"'6-CatCoPaste'!I4","v":0},{"$f":"'6-CatCoPaste'!J4","v":5},{"$f":"'6-CatCoPaste'!K4","v":1},{"$f":"'6-CatCoPaste'!L4","v":0},{"$f":"'6-CatCoPaste'!M4","v":0},{"$f":"'6-CatCoPaste'!N4","v":0}]
[null,null,null,null,null," ","Child Care",null,null,3,{"$f":"'6-CatCoPaste'!D5","v":1},{"$f":"'6-CatCoPaste'!E5","v":0},{"$f":"'6-CatCoPaste'!F5","v":0},{"$f":"'6-CatCoPaste'!G5","v":0},{"$f":"'6-CatCoPaste'!H5","v":0},{"$f":"'6-CatCoPaste'!I5","v":0},{"$f":"'6-CatCoPaste'!J5","v":2},{"$f":"'6-CatCoPaste'!K5","v":0},{"$f":"'6-CatCoPaste'!L5","v":0},{"$f":"'6-CatCoPaste'!M5","v":0},{"$f":"'6-CatCoPaste'!N5","v":0}]
[null,null,null,null,null,null,"Child Support",null,null,0,{"$f":"'6-CatCoPaste'!D6","v":0},{"$f":"'6-CatCoPaste'!E6","v":0},{"$f":"'6-CatCoPaste'!F6","v":0},{"$f":"'6-CatCoPaste'!G6","v":0},{"$f":"'6-CatCoPaste'!H6","v":0},{"$f":"'6-CatCoPaste'!I6","v":0},{"$f":"'6-CatCoPaste'!J6","v":0},{"$f":"'6-CatCoPaste'!K6","v":0},{"$f":"'6-CatCoPaste'!L6","v":0},{"$f":"'6-CatCoPaste'!M6","v":0},{"$f":"'6-CatCoPaste'!N6","v":0}," "]
[null,null,null,null," ",null,"Clothing",null,null,0,{"$f":"'6-CatCoPaste'!D7","v":0},{"$f":"'6-CatCoPaste'!E7","v":0},{"$f":"'6-CatCoPaste'!F7","v":0},{"$f":"'6-CatCoPaste'!G7","v":0},{"$f":"'6-CatCoPaste'!H7","v":0},{"$f":"'6-CatCoPaste'!I7","v":0},{"$f":"'6-CatCoPaste'!J7","v":0},{"$f":"'6-CatCoPaste'!K7","v":0},{"$f":"'6-CatCoPaste'!L7","v":0},{"$f":"'6-CatCoPaste'!M7","v":0},{"$f":"'6-CatCoPaste'!N7","v":0}]
[null,null,null,null,null,null,"Coaching",null,null,11,{"$f":"'6-CatCoPaste'!D8","v":2},{"$f":"'6-CatCoPaste'!E8","v":0},{"$f":"'6-CatCoPaste'!F8","v":1},{"$f":"'6-CatCoPaste'!G8","v":0},{"$f":"'6-CatCoPaste'!H8","v":1},{"$f":"'6-CatCoPaste'!I8","v":0},{"$f":"'6-CatCoPaste'!J8","v":6},{"$f":"'6-CatCoPaste'!K8","v":1},{"$f":"'6-CatCoPaste'!L8","v":0},{"$f":"'6-CatCoPaste'!M8","v":0},{"$f":"'6-CatCoPaste'!N8","v":0}]
[null,null,null,null,null,null,"Food - Community",null,null,0,{"$f":"'6-CatCoPaste'!D9","v":0},{"$f":"'6-CatCoPaste'!E9","v":0},{"$f":"'6-CatCoPaste'!F9","v":0},{"$f":"'6-CatCoPaste'!G9","v":0},{"$f":"'6-CatCoPaste'!H9","v":0},{"$f":"'6-CatCoPaste'!I9","v":0},{"$f":"'6-CatCoPaste'!J9","v":0},{"$f":"'6-CatCoPaste'!K9","v":0},{"$f":"'6-CatCoPaste'!L9","v":0},{"$f":"'6-CatCoPaste'!M9","v":0},{"$f":"'6-CatCoPaste'!N9","v":0}]
[null,null,null,null,null,null,"Counseling Referral",null,null,4,{"$f":"'6-CatCoPaste'!D10","v":1},{"$f":"'6-CatCoPaste'!E10","v":1},{"$f":"'6-CatCoPaste'!F10","v":0},{"$f":"'6-CatCoPaste'!G10","v":0},{"$f":"'6-CatCoPaste'!H10","v":0},{"$f":"'6-CatCoPaste'!I10","v":0},{"$f":"'6-CatCoPaste'!J10","v":2},{"$f":"'6-CatCoPaste'!K10","v":0},{"$f":"'6-CatCoPaste'!L10","v":0},{"$f":"'6-CatCoPaste'!M10","v":0},{"$f":"'6-CatCoPaste'!N10","v":0}]
[null,null,null,null,null,null,"Domestic Violence",null,null,0,{"$f":"'6-CatCoPaste'!D11","v":0},{"$f":"'6-CatCoPaste'!E11","v":0},{"$f":"'6-CatCoPaste'!F11","v":0},{"$f":"'6-CatCoPaste'!G11","v":0},{"$f":"'6-CatCoPaste'!H11","v":0},{"$f":"'6-CatCoPaste'!I11","v":0},{"$f":"'6-CatCoPaste'!J11","v":0},{"$f":"'6-CatCoPaste'!K11","v":0},{"$f":"'6-CatCoPaste'!L11","v":0},{"$f":"'6-CatCoPaste'!M11","v":0},{"$f":"'6-CatCoPaste'!N11","v":0}]
[null,null,null,null,null,null,"Education",null,null,6,{"$f":"'6-CatCoPaste'!D12","v":1},{"$f":"'6-CatCoPaste'!E12","v":1},{"$f":"'6-CatCoPaste'!F12","v":0},{"$f":"'6-CatCoPaste'!G12","v":0},{"$f":"'6-CatCoPaste'!H12","v":0},{"$f":"'6-CatCoPaste'!I12","v":0},{"$f":"'6-CatCoPaste'!J12","v":4},{"$f":"'6-CatCoPaste'!K12","v":0},{"$f":"'6-CatCoPaste'!L12","v":0},{"$f":"'6-CatCoPaste'!M12","v":0},{"$f":"'6-CatCoPaste'!N12","v":0}]
[null,null,null,null,null,null,"Elder Care",null,null,0,{"$f":"'6-CatCoPaste'!D13","v":0},{"$f":"'6-CatCoPaste'!E13","v":0},{"$f":"'6-CatCoPaste'!F13","v":0},{"$f":"'6-CatCoPaste'!G13","v":0},{"$f":"'6-CatCoPaste'!H13","v":0},{"$f":"'6-CatCoPaste'!I13","v":0},{"$f":"'6-CatCoPaste'!J13","v":0},{"$f":"'6-CatCoPaste'!K13","v":0},{"$f":"'6-CatCoPaste'!L13","v":0},{"$f":"'6-CatCoPaste'!M13","v":0},{"$f":"'6-CatCoPaste'!N13","v":0}]
[null,null,null,null,null,null,"Emergency",null,null,0,{"$f":"'6-CatCoPaste'!D14","v":0},{"$f":"'6-CatCoPaste'!E14","v":0},{"$f":"'6-CatCoPaste'!F14","v":0},{"$f":"'6-CatCoPaste'!G14","v":0},{"$f":"'6-CatCoPaste'!H14","v":0},{"$f":"'6-CatCoPaste'!I14","v":0},{"$f":"'6-CatCoPaste'!J14","v":0},{"$f":"'6-CatCoPaste'!K14","v":0},{"$f":"'6-CatCoPaste'!L14","v":0},{"$f":"'6-CatCoPaste'!M14","v":0},{"$f":"'6-CatCoPaste'!N14","v":0}]
[null,null,null,null,null,null,"Employment - Retention",null,null,6,{"$f":"'6-CatCoPaste'!D15","v":0},{"$f":"'6-CatCoPaste'!E15","v":1},{"$f":"'6-CatCoPaste'!F15","v":0},{"$f":"'6-CatCoPaste'!G15","v":0},{"$f":"'6-CatCoPaste'!H15","v":1},{"$f":"'6-CatCoPaste'!I15","v":0},{"$f":"'6-CatCoPaste'!J15","v":4},{"$f":"'6-CatCoPaste'!K15","v":0},{"$f":"'6-CatCoPaste'!L15","v":0},{"$f":"'6-CatCoPaste'!M15","v":0},{"$f":"'6-CatCoPaste'!N15","v":0}]
[null,null,null,null,null,null,"Financial",null,null,9,{"$f":"'6-CatCoPaste'!D16","v":5},{"$f":"'6-CatCoPaste'!E16","v":0},{"$f":"'6-CatCoPaste'!F16","v":0},{"$f":"'6-CatCoPaste'!G16","v":0},{"$f":"'6-CatCoPaste'!H16","v":0},{"$f":"'6-CatCoPaste'!I16","v":0},{"$f":"'6-CatCoPaste'!J16","v":4},{"$f":"'6-CatCoPaste'!K16","v":0},{"$f":"'6-CatCoPaste'!L16","v":0},{"$f":"'6-CatCoPaste'!M16","v":0},{"$f":"'6-CatCoPaste'!N16","v":0}]
[null,null,null,null,null,null,"Financial Literacy",null,null,18,{"$f":"'6-CatCoPaste'!D17","v":2},{"$f":"'6-CatCoPaste'!E17","v":3},{"$f":"'6-CatCoPaste'!F17","v":0},{"$f":"'6-CatCoPaste'!G17","v":0},{"$f":"'6-CatCoPaste'!H17","v":5},{"$f":"'6-CatCoPaste'!I17","v":0},{"$f":"'6-CatCoPaste'!J17","v":4},{"$f":"'6-CatCoPaste'!K17","v":4},{"$f":"'6-CatCoPaste'!L17","v":0},{"$f":"'6-CatCoPaste'!M17","v":0},{"$f":"'6-CatCoPaste'!N17","v":0}]
[null,null,null,null,null,null,"Food - FAP/SNAP",null,null,2,{"$f":"'6-CatCoPaste'!D18","v":0},{"$f":"'6-CatCoPaste'!E18","v":0},{"$f":"'6-CatCoPaste'!F18","v":0},{"$f":"'6-CatCoPaste'!G18","v":0},{"$f":"'6-CatCoPaste'!H18","v":0},{"$f":"'6-CatCoPaste'!I18","v":0},{"$f":"'6-CatCoPaste'!J18","v":1},{"$f":"'6-CatCoPaste'!K18","v":1},{"$f":"'6-CatCoPaste'!L18","v":0},{"$f":"'6-CatCoPaste'!M18","v":0},{"$f":"'6-CatCoPaste'!N18","v":0}]
[null,null,null,null,null,null,"Foreclosure/Evic Prev.",null,null,0,{"$f":"'6-CatCoPaste'!D19","v":0},{"$f":"'6-CatCoPaste'!E19","v":0},{"$f":"'6-CatCoPaste'!F19","v":0},{"$f":"'6-CatCoPaste'!G19","v":0},{"$f":"'6-CatCoPaste'!H19","v":0},{"$f":"'6-CatCoPaste'!I19","v":0},{"$f":"'6-CatCoPaste'!J19","v":0},{"$f":"'6-CatCoPaste'!K19","v":0},{"$f":"'6-CatCoPaste'!L19","v":0},{"$f":"'6-CatCoPaste'!M19","v":0},{"$f":"'6-CatCoPaste'!N19","v":0}]
[null,null,null,null,null,null,"Furniture",null,null,0,{"$f":"'6-CatCoPaste'!D20","v":0},{"$f":"'6-CatCoPaste'!E20","v":0},{"$f":"'6-CatCoPaste'!F20","v":0},{"$f":"'6-CatCoPaste'!G20","v":0},{"$f":"'6-CatCoPaste'!H20","v":0},{"$f":"'6-CatCoPaste'!I20","v":0},{"$f":"'6-CatCoPaste'!J20","v":0},{"$f":"'6-CatCoPaste'!K20","v":0},{"$f":"'6-CatCoPaste'!L20","v":0},{"$f":"'6-CatCoPaste'!M20","v":0},{"$f":"'6-CatCoPaste'!N20","v":0}]
[null,null,null,null,null,null,"Govt. Agency Navigation",null,null,2,{"$f":"'6-CatCoPaste'!D21","v":0},{"$f":"'6-CatCoPaste'!E21","v":0},{"$f":"'6-CatCoPaste'!F21","v":0},{"$f":"'6-CatCoPaste'!G21","v":0},{"$f":"'6-CatCoPaste'!H21","v":0},{"$f":"'6-CatCoPaste'!I21","v":0},{"$f":"'6-CatCoPaste'!J21","v":2},{"$f":"'6-CatCoPaste'!K21","v":0},{"$f":"'6-CatCoPaste'!L21","v":0},{"$f":"'6-CatCoPaste'!M21","v":0},{"$f":"'6-CatCoPaste'!N21","v":0}]
[null,null,null,null,null,null,"Hard Training",null,null,0,{"$f":"'6-CatCoPaste'!D22","v":0},{"$f":"'6-CatCoPaste'!E22","v":0},{"$f":"'6-CatCoPaste'!F22","v":0},{"$f":"'6-CatCoPaste'!G22","v":0},{"$f":"'6-CatCoPaste'!H22","v":0},{"$f":"'6-CatCoPaste'!I22","v":0},{"$f":"'6-CatCoPaste'!J22","v":0},{"$f":"'6-CatCoPaste'!K22","v":0},{"$f":"'6-CatCoPaste'!L22","v":0},{"$f":"'6-CatCoPaste'!M22","v":0},{"$f":"'6-CatCoPaste'!N22","v":0}]
[null,null,null,null,null,null,"Health/Insurance",null,null,15,{"$f":"'6-CatCoPaste'!D23","v":2},{"$f":"'6-CatCoPaste'!E23","v":2},{"$f":"'6-CatCoPaste'!F23","v":0},{"$f":"'6-CatCoPaste'!G23","v":2},{"$f":"'6-CatCoPaste'!H23","v":0},{"$f":"'6-CatCoPaste'!I23","v":0},{"$f":"'6-CatCoPaste'!J23","v":8},{"$f":"'6-CatCoPaste'!K23","v":1},{"$f":"'6-CatCoPaste'!L23","v":0},{"$f":"'6-CatCoPaste'!M23","v":0},{"$f":"'6-CatCoPaste'!N23","v":0}]
[null,null,null,null,null,null,"Home Repair",null,null,2,{"$f":"'6-CatCoPaste'!D24","v":1},{"$f":"'6-CatCoPaste'!E24","v":0},{"$f":"'6-CatCoPaste'!F24","v":0},{"$f":"'6-CatCoPaste'!G24","v":0},{"$f":"'6-CatCoPaste'!H24","v":0},{"$f":"'6-CatCoPaste'!I24","v":0},{"$f":"'6-CatCoPaste'!J24","v":1},{"$f":"'6-CatCoPaste'!K24","v":0},{"$f":"'6-CatCoPaste'!L24","v":0},{"$f":"'6-CatCoPaste'!M24","v":0},{"$f":"'6-CatCoPaste'!N24","v":0}]
[null,null,null,null,null,null,"Homeless Shelter",null,null,0,{"$f":"'6-CatCoPaste'!D25","v":0},{"$f":"'6-CatCoPaste'!E25","v":0},{"$f":"'6-CatCoPaste'!F25","v":0},{"$f":"'6-CatCoPaste'!G25","v":0},{"$f":"'6-CatCoPaste'!H25","v":0},{"$f":"'6-CatCoPaste'!I25","v":0},{"$f":"'6-CatCoPaste'!J25","v":0},{"$f":"'6-CatCoPaste'!K25","v":0},{"$f":"'6-CatCoPaste'!L25","v":0},{"$f":"'6-CatCoPaste'!M25","v":0},{"$f":"'6-CatCoPaste'!N25","v":0}]
[null,null,null,null,null,null,"Housing",null,null,6,{"$f":"'6-CatCoPaste'!D26","v":1},{"$f":"'6-CatCoPaste'!E26","v":0},{"$f":"'6-CatCoPaste'!F26","v":0},{"$f":"'6-CatCoPaste'!G26","v":0},{"$f":"'6-CatCoPaste'!H26","v":0},{"$f":"'6-CatCoPaste'!I26","v":0},{"$f":"'6-CatCoPaste'!J26","v":4},{"$f":"'6-CatCoPaste'!K26","v":1},{"$f":"'6-CatCoPaste'!L26","v":0},{"$f":"'6-CatCoPaste'!M26","v":0},{"$f":"'6-CatCoPaste'!N26","v":0}]
[null,null,null,null,null,null,"Immigration",null,null,0,{"$f":"'6-CatCoPaste'!D27","v":0},{"$f":"'6-CatCoPaste'!E27","v":0},{"$f":"'6-CatCoPaste'!F27","v":0},{"$f":"'6-CatCoPaste'!G27","v":0},{"$f":"'6-CatCoPaste'!H27","v":0},{"$f":"'6-CatCoPaste'!I27","v":0},{"$f":"'6-CatCoPaste'!J27","v":0},{"$f":"'6-CatCoPaste'!K27","v":0},{"$f":"'6-CatCoPaste'!L27","v":0},{"$f":"'6-CatCoPaste'!M27","v":0},{"$f":"'6-CatCoPaste'!N27","v":0}]
[null,null,null,null,null,null,"Legal Assistance",null,null,6,{"$f":"'6-CatCoPaste'!D28","v":1},{"$f":"'6-CatCoPaste'!E28","v":1},{"$f":"'6-CatCoPaste'!F28","v":0},{"$f":"'6-CatCoPaste'!G28","v":0},{"$f":"'6-CatCoPaste'!H28","v":0},{"$f":"'6-CatCoPaste'!I28","v":0},{"$f":"'6-CatCoPaste'!J28","v":3},{"$f":"'6-CatCoPaste'!K28","v":1},{"$f":"'6-CatCoPaste'!L28","v":0},{"$f":"'6-CatCoPaste'!M28","v":0},{"$f":"'6-CatCoPaste'!N28","v":0}]
[null,null,null,null,null,null,"Literacy",null,null,1,{"$f":"'6-CatCoPaste'!D29","v":0},{"$f":"'6-CatCoPaste'!E29","v":0},{"$f":"'6-CatCoPaste'!F29","v":0},{"$f":"'6-CatCoPaste'!G29","v":0},{"$f":"'6-CatCoPaste'!H29","v":0},{"$f":"'6-CatCoPaste'!I29","v":0},{"$f":"'6-CatCoPaste'!J29","v":1},{"$f":"'6-CatCoPaste'!K29","v":0},{"$f":"'6-CatCoPaste'!L29","v":0},{"$f":"'6-CatCoPaste'!M29","v":0},{"$f":"'6-CatCoPaste'!N29","v":0}]
[null,null,null,null,null,null,"Other",null,null,8,{"$f":"'6-CatCoPaste'!D30","v":2},{"$f":"'6-CatCoPaste'!E30","v":2},{"$f":"'6-CatCoPaste'!F30","v":0},{"$f":"'6-CatCoPaste'!G30","v":0},{"$f":"'6-CatCoPaste'!H30","v":0},{"$f":"'6-CatCoPaste'!I30","v":0},{"$f":"'6-CatCoPaste'!J30","v":1},{"$f":"'6-CatCoPaste'!K30","v":3},{"$f":"'6-CatCoPaste'!L30","v":0},{"$f":"'6-CatCoPaste'!M30","v":0},{"$f":"'6-CatCoPaste'!N30","v":0}]
[null,null,null,null,null,null,"Soft Training",null,null,14,{"$f":"'6-CatCoPaste'!D31","v":0},{"$f":"'6-CatCoPaste'!E31","v":1},{"$f":"'6-CatCoPaste'!F31","v":0},{"$f":"'6-CatCoPaste'!G31","v":0},{"$f":"'6-CatCoPaste'!H31","v":1},{"$f":"'6-CatCoPaste'!I31","v":0},{"$f":"'6-CatCoPaste'!J31","v":11},{"$f":"'6-CatCoPaste'!K31","v":1},{"$f":"'6-CatCoPaste'!L31","v":0},{"$f":"'6-CatCoPaste'!M31","v":0},{"$f":"'6-CatCoPaste'!N31","v":0}]
[null,null,null,null,null,null,"Sub. Abuse/Addictions",null,null,0,{"$f":"'6-CatCoPaste'!D32","v":0},{"$f":"'6-CatCoPaste'!E32","v":0},{"$f":"'6-CatCoPaste'!F32","v":0},{"$f":"'6-CatCoPaste'!G32","v":0},{"$f":"'6-CatCoPaste'!H32","v":0},{"$f":"'6-CatCoPaste'!I32","v":0},{"$f":"'6-CatCoPaste'!J32","v":0},{"$f":"'6-CatCoPaste'!K32","v":0},{"$f":"'6-CatCoPaste'!L32","v":0},{"$f":"'6-CatCoPaste'!M32","v":0},{"$f":"'6-CatCoPaste'!N32","v":0}]
[null,null,null,null,null,null,"Transportation",null,null,4,{"$f":"'6-CatCoPaste'!D33","v":2},{"$f":"'6-CatCoPaste'!E33","v":0},{"$f":"'6-CatCoPaste'!F33","v":0},{"$f":"'6-CatCoPaste'!G33","v":1},{"$f":"'6-CatCoPaste'!H33","v":0},{"$f":"'6-CatCoPaste'!I33","v":0},{"$f":"'6-CatCoPaste'!J33","v":1},{"$f":"'6-CatCoPaste'!K33","v":0},{"$f":"'6-CatCoPaste'!L33","v":0},{"$f":"'6-CatCoPaste'!M33","v":0},{"$f":"'6-CatCoPaste'!N33","v":0}]
[null,null,null,null,null,null,"Utilities",null,null,9,{"$f":"'6-CatCoPaste'!D34","v":4},{"$f":"'6-CatCoPaste'!E34","v":1},{"$f":"'6-CatCoPaste'!F34","v":1},{"$f":"'6-CatCoPaste'!G34","v":0},{"$f":"'6-CatCoPaste'!H34","v":0},{"$f":"'6-CatCoPaste'!I34","v":0},{"$f":"'6-CatCoPaste'!J34","v":2},{"$f":"'6-CatCoPaste'!K34","v":1},{"$f":"'6-CatCoPaste'!L34","v":0},{"$f":"'6-CatCoPaste'!M34","v":0},{"$f":"'6-CatCoPaste'!N34","v":0}]
[]
[null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(J9:J41)","v":141},{"$f":"SUM(K9:K41)","v":27},{"$f":"SUM(L9:L41)","v":16},{"$f":"SUM(M9:M41)","v":5},{"$f":"SUM(N9:N41)","v":3},{"$f":"SUM(O9:O41)","v":8},0,66,16,0,0,0]
[]
[]
[null,null,null,null,null,null,"audit row 1 - should match row 42",null,null,{"$f":"SUM(K42:U42)","v":141}]
[null,null,null,null,null,null,"audit row 2 - should match row 42",null,null,{"$f":"'2-Dashboard'!J19","v":141},{"$f":"'2-Dashboard'!J5","v":27},{"$f":"'2-Dashboard'!J6","v":16},{"$f":"'2-Dashboard'!J7","v":5},{"$f":"'2-Dashboard'!J8","v":3},{"$f":"'2-Dashboard'!J9","v":8},{"$f":"'2-Dashboard'!J10","v":0},{"$f":"'2-Dashboard'!J11","v":66},{"$f":"'2-Dashboard'!J12","v":16},{"$f":"'2-Dashboard'!J13","v":0},{"$f":"'2-Dashboard'!J14","v":0},{"$f":"'2-Dashboard'!J15","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"'2-Dashboard'!B1","v":"EaRNed SUCCESS  |Monthly Dashboard | FY JAN 2017 - DEC 2017"}]

{"sheet":"8-Audit Legend","index":12,"n_rows":55,"n_cols":43,"rows_kept":55,"cut":false,"hidden":false,"merged":[[50,27,50,29],[50,30,50,31],[50,32,50,33],[50,35,50,38],[50,39,50,40],[50,41,50,42],[49,27,49,29],[49,30,49,31],[49,32,49,33],[49,35,49,38],[49,39,49,40],[49,41,49,42],[48,27,48,29],[48,30,48,31],[48,32,48,33],[48,35,48,38],[48,39,48,40],[48,41,48,42],[47,27,47,29],[47,30,47,31],[47,32,47,33],[47,35,47,38],[47,39,47,40],[47,41,47,42],[45,30,45,31],[45,32,45,33],[45,35,45,38],[45,39,45,40],[45,41,45,42],[46,30,46,31],[46,32,46,33],[46,35,46,38],[46,39,46,40],[46,41,46,42],[44,27,44,29],[44,30,44,31],[44,32,44,33],[44,35,44,38],[44,39,44,40],[44,41,44,42],[42,41,42,42],[43,30,43,31],[43,32,43,33],[43,35,43,38],[43,39,43,40],[43,41,43,42],[41,30,41,31],[41,32,41,33],[41,35,41,38],[41,39,41,40],[41,41,41,42],[42,27,42,29],[42,30,42,31],[42,32,42,33],[42,35,42,38],[42,39,42,40],[39,35,39,38],[39,39,39,40],[39,41,39,42],[40,30,40,31],[40,32,40,33],[40,35,40,38],[40,39,40,40],[40,41,40,42],[37,27,37,31],[37,32,37,33],[37,35,37,38],[37,39,37,40],[37,41,37,42],[38,27,38,31],[38,32,38,33],[38,35,38,38],[38,39,38,40],[38,41,38,42],[35,27,35,31],[35,32,35,33],[35,35,35,38],[35,39,35,40],[35,41,35,42],[36,27,36,31],[36,32,36,33],[36,35,36,38],[36,39,36,40],[36,41,36,42],[33,27,33,31],[33,32,33,33],[33,35,33,38],[33,39,33,40],[33,41,33,42],[34,27,34,31],[34,32,34,33],[34,35,34,38],[34,39,34,40],[34,41,34,42],[31,27,31,31],[31,32,31,33],[31,35,31,38],[31,39,31,40],[31,41,31,42],[32,32,32,33],[32,35,32,38],[32,39,32,40],[32,41,32,42],[29,32,29,33],[29,35,29,38],[29,39,29,40],[29,41,29,42],[30,32,30,33],[30,35,30,38],[30,39,30,40],[30,41,30,42],[27,35,27,38],[27,39,27,40],[27,41,27,42],[28,35,28,38],[28,39,28,40],[28,41,28,42],[26,27,26,29],[26,30,26,31],[26,32,26,33],[26,35,26,38],[26,39,26,40],[26,41,26,42],[25,27,25,29],[25,30,25,31],[25,32,25,33],[25,35,25,38],[25,39,25,40],[25,41,25,42],[24,27,24,29],[24,30,24,31],[24,32,24,33],[24,35,24,38],[24,39,24,40],[24,41,24,42],[23,27,23,29],[23,30,23,31],[23,32,23,33],[23,35,23,38],[23,39,23,40],[23,41,23,42],[22,27,22,29],[22,30,22,31],[22,32,22,33],[22,35,22,38],[22,39,22,40],[22,41,22,42],[21,27,21,29],[21,30,21,31],[21,32,21,33],[21,35,21,38],[21,39,21,40],[21,41,21,42],[20,27,20,29],[20,30,20,31],[20,32,20,33],[20,35,20,38],[20,39,20,40],[20,41,20,42],[19,27,19,29],[19,30,19,31],[19,32,19,33],[19,35,19,38],[19,39,19,40],[19,41,19,42],[18,27,18,29],[18,30,18,31],[18,32,18,33],[18,35,18,38],[18,39,18,40],[18,41,18,42],[16,39,16,40],[16,41,16,42],[17,27,17,29],[17,30,17,31],[17,32,17,33],[17,35,17,38],[17,39,17,40],[17,41,17,42],[13,1,13,5],[13,28,13,29],[16,27,16,29],[16,30,16,31],[16,32,16,33],[16,35,16,38],[10,1,10,5],[10,28,10,29],[11,1,11,5],[11,28,11,29],[12,1,12,5],[12,28,12,29],[7,1,7,5],[7,28,7,29],[8,1,8,5],[8,28,8,29],[9,1,9,5],[9,28,9,29],[2,42,3,42],[4,1,4,5],[4,28,4,29],[5,1,5,5],[5,28,5,29],[6,1,6,5],[6,28,6,29],[2,32,2,33],[2,34,2,35],[2,36,2,37],[2,38,2,39],[2,40,3,40],[2,41,3,41],[2,23,3,23],[2,24,3,24],[2,25,3,25],[2,26,3,26],[2,27,3,27],[0,35,0,42],[2,30,2,31],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[1,30,1,39],[1,40,1,42],[1,1,3,5],[1,6,1,8],[1,9,3,9],[1,10,3,10],[1,11,3,11],[1,12,1,17],[1,18,1,23],[1,24,1,27],[1,28,3,29],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16]]}
[null,"XXERN-XLocationX Monthly Dashboard | FY 20xx/xx",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mm/01/yyyy"]
[null,"Employers",null,null,null,null,"Services this Month",null,null,"Delivered Services YTD","Avg Services / Mo. YTD","Unique Emps. Served YTD","Requests this Month by type",null,null,null,null,null,"Requests YTD by type",null,null,null,null,null,"Employees by Request Multiple YTD - including pends",null,null,null,null,null,"Retention % a                ",null,null,null,null,null,null,null,null,null,"YTD Utilization %   Updated quarterlyb"]
[null,null,null,null,null,null,"Delivered","Pending","Total Service Interfaces",null,null,null,"Total ","HR","Supervisor","Self","Co-Worker","Other","Total ","HR","Supervisor","Self","Co-Worker","Other","1x","2x","3x","4x+",null,null,"YTD",null,"Q1",null,"Q2",null,"Q3",null,"Q4",null,"Total Ees"," DHHS Ees"," Non-DHHS Ees"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ERN","Co","ERN","Co","ERN","Co","ERN","Co","ERN","Co"]
[null,"Blinded 1",null,null,null,null,32,2,{"$f":"SUM(G5:H5)","v":34},108,{"$f":"J5/G55","v":21.6},38,{"$f":"SUM(N5:R5)","v":21},6,null,13,1,1,{"$f":"SUM(T5:X5)","v":69},11,3,53,1,1,22,10,4,3]
[null,"Blinded 2",null,null,null,null,26,1,27,97,{"$f":"J6/G55","v":19.399999999999999},70,24,4,null,18,1,1,{"$f":"SUM(T6:X6)","v":94},18,null,73,2,1,60,7,4,2]
[null,"Blinded 3",null,null,null,null,5,3,8,16,{"$f":"J7/G55","v":3.2},12,6,null,1,5,null,null,17,7,1,9,null,null,10,2,1]
[null,"Blinded 4",null,null,null,null,9,1,10,36,{"$f":"J8/G55","v":7.2},28,8,1,null,6,null,1,35,9,null,25,null,1,22,4,2]
[null,"Blinded 5",null,null,null,null,2,null,2,6,{"$f":"J9/G55","v":1.2},6,2,1,null,1,null,null,6,1,1,4,null,null,6,0,0]
[null,"Blinded 6",null,null,null,null,1,null,1,18,{"$f":"J10/G55","v":3.6},9,1,null,null,1,null,null,19,1,null,18,null,null,5,2,0,3]
[null,"Blinded 7",null,null,null,null,2,null,2,6,{"$f":"J11/G55","v":1.2},3,1,1,null,null,null,null,4,3,null,1,null,null,2,1,0]
[null,"Blinded 8",null,null,null,null,1,null,1,5,{"$f":"J12/G55","v":1},4,1,null,null,1,null,null,4,null,1,3,null,null,4,0,0]
[null,"Blinded 9",null,null,null,null,5,1,6,24,{"$f":"J13/G55","v":4.8},14,2,2,null,null,null,null,19,3,null,15,null,1,11,2,0,1]
[null,"Totals",null,null,null,null,{"$f":"SUM(G5:G13)","v":83},{"$f":"SUM(H5:H13)","v":8},91,316,63.20000000000001,184,66,15,1,45,2,3,267,53,6,201,3,4,142,28,11,{"$f":"SUM(AB5:AB13)","v":9}]
[]
[]
[null,20,"paste as a picture",null,null,null,null,null,null,null,null,null,null,21,"paste as a picture",null,null,null,null,null,null,null,null,null,null,null,null,"Served/Unq Ee",null,null,"Month",null,"YTD",null,null,"Service by Category",null,null,null,"Mo",null,"YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total DHHS",null,null,{"$f":"SUM(AE19:AF20)","v":26},null,{"$f":"SUM(AG19:AH20)","v":82},null,null,"Auto Repair",null,null,null,0,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Incumbent DHHS",null,null,25,null,78,null,null,"Career Counseling",null,null,null,2,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," New DHHS c",null,null,1,null,4,null,null,"Child Care",null,null,null,11,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-DHHS",null,null,{"$f":"SUM(AE22:AF23)","v":29},null,{"$f":"SUM(AG22:AH23)","v":71},null,null,"Child Support",null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Former DHHS",null,null,4,null,4,null,null,"Clothing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Never DHHS",null,null,25,null,67,null,null,"Coaching",null,null,null,6,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown/coded",null,null,12,null,31,null,null,"Comm Food Rsrc",null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Counseling Request",null,null,null,4,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Domestic Violence"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(AE18,AE21,AE24)","v":67},null,{"$f":"SUM(AG18,AG21,AG24)","v":184},null,null,"Education",null,null,null,2,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elder Care"]
[null,21,"paste as a picture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bridge Loans",null,null,null,null,null,null,null,"Emergency",null,null,null,3,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"23a",null,null,null,null,null,null,"23b",null,null,null,null,null,null,"New Loans this Month",null,null,null,null,2,null,null,"Employment",null,null,null,2,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disbursed this Month",null,null,null,null,2000,null,null,"Financial",null,null,null,7,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open Bridge Loans",null,null,null,null,52,null,null,"Financial Literacy",null,null,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paid/Clsed Bridge Loans",null,null,null,null,36,null,null,"Food Assistance",null,null,null,5,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Disbursed",null,null,null,null,252000,null,null,"Homeless Prev.",null,null,null,1,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Balance Remaining",null,null,null,null,198523,null,null,"Furniture",null,null,null,1,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Savings",null,null,null,null,23462,null,null,"Govt Agency Nav.",null,null,null,11,null,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delinquent",null,null,null,null,3216,null,null,"Hard Training"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loss",null,null,null,null,1425,null,null,"Health/Insurance",null,null,null,2,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Home Repair",null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Homeless Shelter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Fin Supt",null,null,"Month",null,"YTD",null,null,"Housing",null,null,null,7,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Priv/Com Rsrc",null,null,null,null,1820,null,null,"Immigration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DHHS",null,null,3118,null,11833,null,null,"Legal Assistance",null,null,null,2,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt Public Asst",null,null,null,null,null,null,null,"Literacy",null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loan  ",null,null,2000,null,7000,null,null,"Other",null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Com Food Rsrc",null,null,null,null,240,null,null,"Soft Training"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(AE42:AF46)","v":5118},null,{"$f":"SUM(AG42:AH46)","v":20893},null,null,"Sub.Abuse/Addictns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation",null,null,null,10,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilities",null,null,null,6,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water/Public Health"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(AN18:AO50)","v":83},null,{"$f":"SUM(AP18:AQ50)","v":316}]
[null,"a - Averaged across all eers from total distinct ees served.  Each rention quarter looks back 9 mos prior to Q start.",null,null,null,null,null,null,null,null,null,null,null,null,null,"b - Based upon DHHS analysis of active ees at FY start, then extrapolated according to reported ee count for Q.     ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c - Not on DHHS in any of three previous months."]
[]
[]
[null,null,null,null,null,null,5]

{"sheet":"General Instr","index":13,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["."]

{"sheet":"Unlocked Cells Legend","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}