{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Quarterly Interactive"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Quarterly Interactive","index":0,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[[12,0,14,0],[12,1,13,5],[14,1,14,5],[12,6,13,6],[41,0,43,0],[41,1,42,5],[43,1,43,5],[41,6,42,6],[31,0,33,0],[28,0,30,0],[20,1,20,5],[34,0,36,0],[23,1,23,5],[28,1,29,5],[31,1,32,5],[18,0,20,0],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[40,1,40,5],[47,1,48,5],[47,6,48,6],[44,8,46,8],[38,6,39,6],[38,1,39,5],[9,8,11,8],[9,1,10,5],[9,6,10,6],[24,0,26,0],[24,1,25,5],[24,6,25,6],[24,7,26,7],[24,8,26,8],[26,1,26,5],[9,0,11,0],[17,1,17,5],[9,7,11,7],[15,7,17,7],[11,1,11,5],[15,0,17,0],[15,1,16,5],[57,0,59,0],[57,7,59,7],[47,0,49,0],[18,7,20,7],[44,0,46,0],[38,7,40,7],[44,7,46,7],[50,0,56,0],[38,0,40,0],[18,1,19,5],[44,1,45,5],[46,1,46,5],[44,6,45,6],[21,0,23,0],[58,1,59,5],[58,6,59,6],[5,2,5,4],[7,2,7,4],[6,2,6,4],[57,8,59,8],[50,6,52,6],[50,7,52,7],[50,8,52,8],[50,1,52,5],[57,1,57,5],[47,8,49,8],[38,8,40,8],[47,7,49,7],[49,1,49,5],[15,8,17,8],[33,1,33,5],[21,8,23,8],[12,7,14,7],[41,7,43,7],[41,8,43,8],[12,8,14,8],[15,6,16,6],[31,8,33,8],[28,7,30,7],[31,7,33,7],[28,6,29,6],[31,6,32,6],[28,8,30,8],[21,7,23,7],[18,8,20,8],[18,6,19,6],[34,8,36,8],[35,6,36,6],[21,6,22,6],[34,7,36,7],[27,0,27,5],[21,1,22,5],[35,1,36,5],[34,1,34,5]]}
[null,"Instructions on how to use sheet:"]
[null,"Pull a quarterly report and enter the quarterly data into column G (yellow)"]
[null,"Review data paying extra attention to outcome in column J"]
[null,"Submit to LISC the first Friday of the following month"]
[]
[null,"Site Name"]
[null,"Quarter"]
[null,"Date Data Was Pulled"]
["FFT Employment Counseling",{"$nulls":5},"This Quarter","Calculation","Percentage","Percentage Rating Explanation"]
[1,"Enter People who received a service for the first time E1",{"$nulls":5},"E1/E2",{"$f":"G10/G12","v":{"$error":"#DIV/0!"}},"Under 39% FOC is providing services to existing clients only, there could be a lack of new clients"]
[{"$nulls":9},"Between 40 - 74% site is providing services to new and existing clients"]
[null,"Enter People who got at least one service - E2",{"$nulls":7},"Over 75% site is focusing on new client only"]
[2,"Enter total # who had a direct contact (E4)",{"$nulls":5},"E4/E2",{"$f":"G13/G15","v":{"$error":"#DIV/0!"}},"Over 85% the FOC is connecting the services rendered with a direct counseling session"]
[{"$nulls":9},"Between 70-84% there is a gap between services rendered and direct counseling sessions"]
[null,"Enter the total number who received a service (E2)",{"$nulls":7},"Below 69% the FOC is not fully connecting the services rendered with direct counseling sessions"]
[3,"Enter People who had at least one direct counseling contact - E4",{"$nulls":5},"E5/E4",{"$f":"G18/G16","v":{"$error":"#DIV/0!"}},"Over 50% could indicate transactional service and low client engagement"]
[{"$nulls":9},"Between 11% and 49% coaches can improve data tracking to ensure high level of coach/client engagement"]
[null,"Enter 1 time only - E5",{"$nulls":7},"Under 10% indicates high level of coach/client engagement"]
[4,"Enter People with an increase in earnings - E8",{"$nulls":5},"E12/E8",{"$f":"G21/G19","v":{"$error":"#DIV/0!"}},"Over 80% most positive changes in employment earnings are successfully captured in the CFA - goal is greater than 95%"]
[{"$nulls":9},"Between 51 - 79% Communication between workforce and financial coach needs improvement to ensure employment earnings are captured in CFA"]
[null,"Enter People with a subsequent budget completed - E12",{"$nulls":7},"Under 50% lack of communication between workforce and financial coach; positive changes in employment earnings are not successfully captured in the CFA. Possible implications: Low # of Net Income Increases"]
[5,"Enter # of \"People placed in unsubsidized jobs\" - E15",{"$nulls":5},"E18/E15",{"$f":"G24/G22","v":{"$error":"#DIV/0!"}},"Over 50% indicates that there could be an issue with client contact and/or data entry as there are clients that are due for retention verification that have not been entered"]
[{"$nulls":9},"Between 21% and 49% coaches can improve data tracking to ensure high level of coach/client engagement"]
[null,"Enter # of \"Placements during the report period due for any retention verification\" - E18",{"$nulls":7},"Under 20% indicates strong system to track job placement and retention"]
[6,"Enter # \"worked an unsubsidized job (retention denominator) - E19",{"$nulls":5},"E21/E19",{"$f":"G27/G25","v":{"$error":"#DIV/0!"}},"Over 72% - Client 90-day job retention is at or above the national median (see powerpoint for data)"]
[{"$nulls":9},"Between 71% and 50% - Coaches could improve data tracking and documentation in the FFT data system"]
[null,"Enter # \"Achieved 90-day steady employment during report period\" - E21",{"$nulls":7},"Under 49% - client job retention is not being documented in the FFT data system, and/or the proper followup is not taking place; possible implications low retenion milestone acheivement (E20 - E25)"]
["FFT Income Supports Counseling",{"$nulls":5},"This Quarter","Calculation"]
[1,"Enter people screened for benefits - I3",{"$nulls":5},"I3/I1",{"$f":"G29/G31","v":{"$error":"#DIV/0!"}},"Over 80% the FOC is screening all new enrollees for benefits. "]
[{"$nulls":9},"Between 60 - 79% check client flow to ensure new enrolles are screened for benefits"]
[null,"Enter People who received a service for the first time - I1",{"$nulls":7},"Under 59% The FOC’s client flow will need to be revised to ensure all new clients are screened for benefits. "]
[2,"Enter people eligible for at least one benefit - I4",{"$nulls":5},"I5/I4",{"$f":"G34/G32","v":{"$error":"#DIV/0!"}},"Over 80% New clients eligible for at least one benefit have applied and existing FOC clients have re-applied for benefits."]
[{"$nulls":9},"Between 50 - 79% may be a gap for new clients who are eligible for benefit to apply"]
[null,"Enter People who applied (or re-reapplied) for at least one benefit I5",{"$nulls":7},"Under 49% Pending data entry. Possible implications: low number of applications approved (I6)."]
[3,"Enter People with new or changed recurring benefit/subsidy amount - I7",{"$nulls":5},"I8 / I7",{"$f":"G36/G35","v":{"$error":"#DIV/0!"}},"Over 80% FOC staff communicates effectiviely relating to changes in benefits"]
[null,"Enter People with subsequent BUDGET completed - I8",{"$nulls":7},"Between 50 - 79% may be a gap in communication between staff regarding changes in benefits "]
[{"$nulls":9},"Under 49% substantial lack of communication between income support coach and financial coach; changes in benefits are not successfully captured in the CFA"]
["FFT Financial Counseling",{"$nulls":5},"This Quarter","Calculation"]
[1,"Enter total # who received a service for the first time F1",{"$nulls":5},"F1/F2",{"$f":"G39/G41","v":{"$error":"#DIV/0!"}},"Under 39% FOC is providing services to existing clients only, there could be a lack of new clients"]
[{"$nulls":9},"Between 40 - 74% site is providing servies to a new and existing clients"]
[null,"Enter total # who received a service (includes F1) - F2",{"$nulls":7},"Over 75% site is focusing on new client only"]
[2,"Enter total # who had a direct contact (F3)",{"$nulls":5},"F3/F2",{"$f":"G42/G44","v":{"$error":"#DIV/0!"}},"Over 85% the FOC is connecting the services rendered with a direct counseling session"]
[{"$nulls":9},"Between 70-84% there is a gap between services rendered and direct counseling sessions"]
[null,"Enter the total number who received a service (F2)",{"$nulls":7},"Below 69% the FOC is not fully connecting the services rendered with direct counseling sessions"]
[3,"Total # who had a direct contact F3",{"$nulls":5},"F4 / F3",{"$f":"G47/G45","v":{"$error":"#DIV/0!"}},"Over 50% could indicate transactional service and low client engagement"]
[{"$nulls":9},"Between 11% and 49% coaches can improve data tracking to ensure high level of coach/client engagement"]
[null,"Enter One Time Only Counseling Contact F4",{"$nulls":7},"Under 10% indicates high level of coach/client engagement"]
[4,"Enter total # who received a service for the first time F1",{"$nulls":5},"F7/F1",{"$f":"G50/G48","v":{"$error":"#DIV/0!"}},"Over 95% signals that first time clients are receiving their baseline financial assessment"]
[{"$nulls":9},"Between 94% - 75% financial coach may need to review process to ensure that first time clients are receiving their baseline financial assessment"]
[null,"Enter People submitting at least one baseline financial assessment F7",{"$nulls":7},"Under 74% signals that there could be a problem with client flow, as first time clients are not receiving baseline CFA"]
[5,"Enter People submitting at least one baseline financial assessment F7",{"$nulls":5},"Average of %'s from calculations below",{"$f":"AVERAGE(I54,I55,I56,I57)","v":{"$error":"#DIV/0!"}},"Under 5% signals clients ARE receiving the full CFA"]
[{"$nulls":9},"Between 6% - 15% financial coach may need to review process to ensure tht first time clients are receiving their FULL baseline financial assessment"]
[{"$nulls":9},"Over 16% signals clients are NOT receiving the full CFA"]
[null,"Enter Financial Health - F8",{"$nulls":5},"(F7-F8)/F7",{"$f":"(G51-G54)/G51","v":{"$error":"#DIV/0!"}}]
[null,"Enter Credit Reports F9",{"$nulls":5},"(F7-F9)/F7",{"$f":"(G51-G55)/G51","v":{"$error":"#DIV/0!"}}]
[null,"Enter Budgets F11",{"$nulls":5},"(F7-F11)/F7",{"$f":"(G51-G56)/G51","v":{"$error":"#DIV/0!"}}]
[null,"Enter Balance Sheets - F12",{"$nulls":5},"(F7-F12)/F7",{"$f":"(G51-G57)/G51","v":{"$error":"#DIV/0!"}}]
[6,"Enter people who received at least 1 FFT Counseling service during 18 months prior to report end date - F14",{"$nulls":5},"F17/F14",{"$f":"G59/G58","v":{"$error":"#DIV/0!"}},"Over 80% is a manageable number of clients in need of subsequent credit report pulls"]
[null,"Enter people submitting at leaset one subsequent Credit Report F17",{"$nulls":7},"Between 79% - 49% financial coach needs to review process for following up with clients that are in need of credit report pull"]
[{"$nulls":9},"Under 50% signals that clients are not being followed up with at the six month mark - this also could mean a site experiencing a challenge with client retention"]