{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Exhibit I Coverpage","Section A","Section B","Section C","Section D","Section E","Section F","Section G","Section H","Section I","Section C_Supplement","Section G_Supplement","Exhibit I Scores","Exhibit I Exit Summary","DropDown","Exhibit_II","Pick Files","Case File Review","CAP_Response_Form","Checkbox_Scoring","Data_Export"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":59,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Exhibit I Coverpage","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[60,1,60,7],[62,1,65,7],[45,1,47,7],[54,1,56,7],[58,1,58,7],[6,3,6,7],[9,1,9,7],[32,1,35,7],[10,2,10,7],[11,2,11,7],[12,2,12,7],[14,2,14,7],[15,2,15,7],[16,2,16,7],[13,1,13,7],[20,1,20,2],[22,1,23,2],[22,3,23,7]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"$C$12","v":0}]
[]
[]
[]
[null,null,null,"Supportive Services for Veteran Families (SSVF)"]
[null,null,null,"FY 2018 Uniform Monitoring Package (UMP)"]
[null,null,null,"Last Revision:  11/1/2017"]
[]
[]
[null,"Exhibit 1"]
[null,"Grantee Name:"]
[null,"Program Number:"]
[null,"Award Amount:"]
[]
[null,"Grantee Staff Consulted:"]
[null,"Name(s) of Reviewer(s):"]
[null,"Date of Review:"]
[]
[null,"FY16/FY17 UMP Items Reviewed by Monitor:"]
[]
[null,"Repeat Issues Identified:"]
[]
[null,"Please list all items identified as repeat issues (please include section and item # [ex: B3, D4])"]

{"sheet":"Section A","index":1,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,1,6,7],[4,1,4,7],[7,2,7,6],[23,1,23,7],[24,1,24,7],[14,1,16,1],[14,2,14,6],[15,2,15,7],[16,2,16,7],[17,1,19,1],[17,2,17,6],[18,2,18,7],[8,1,10,1],[8,2,8,6],[9,2,9,7],[10,2,10,7],[20,1,22,1],[20,2,20,6],[21,2,21,7],[22,2,22,7],[11,1,13,1],[12,2,12,7],[13,2,13,7],[11,2,11,6],[19,2,19,7]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,"A.  Program Progress"]
[null,"This section is designed to ensure that activities are being carried out in a timely manner and that the number of participants served is consistent with the approved application."]
[]
[null,"Item","Description",null,null,null,null,"Score"]
[null,1,"Is the number of participants currently being served within 10% or less of where the grantee needs to be to hit their households served goal by the end of the year? Serving beyond the goal is allowable. (Source: HMIS households served, resolution)"]
[null,null,"Notes:"]
[]
[null,2,"Is the grantee drawing down in line with projected point in time expenditures for the project’s grant term and approved budget using VA spreadsheet? (Source: VA Spreadsheet\n)"]
[null,null,"Notes:"]
[]
[null,3,"Is the staffing plan consistent with the approved budget or approved program changes? (Source: Grantee staffing plan, approved budget, budget changes, interviews)"]
[null,null,"Notes:"]
[]
[null,"4a","For grantees without a waiver, has at least 60% of Temporary Financial Assistance been spent on Rapid Re-Housing households? (Source: Grantee reported)"]
[null,null,"Notes:"]
[]
[null,"4b","For grantees with a waiver, has at least 30% of Temporary Financial Assistance been spent on Rapid Rehousing households? (Source: Grantee reported)"]
[null,null,"Notes:"]
[]
[null,"Overall Remarks:"]

{"sheet":"Section B","index":2,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[23,1,25,1],[23,2,23,6],[24,2,24,7],[25,2,25,7],[26,1,28,1],[26,2,26,6],[27,2,27,7],[28,2,28,7],[35,2,35,6],[35,1,37,1],[36,2,36,7],[37,2,37,7],[38,2,38,6],[38,1,40,1],[39,2,39,7],[40,2,40,7],[29,1,31,1],[29,2,29,6],[30,2,30,7],[31,2,31,7],[32,1,34,1],[32,2,32,6],[33,2,33,7],[34,2,34,7],[8,2,8,6],[9,2,9,7],[10,2,10,7],[8,1,10,1],[4,1,4,7],[5,1,6,7],[7,2,7,6],[11,1,13,1],[11,2,11,6],[12,2,12,7],[14,1,16,1],[14,2,14,6],[16,2,16,7],[13,2,13,7],[15,2,15,7],[18,2,18,7],[19,2,19,7],[20,1,22,1],[20,2,20,6],[21,2,21,7],[22,2,22,7],[17,1,19,1],[17,2,17,6],[51,1,51,7],[41,1,43,1],[41,2,41,6],[42,2,42,7],[43,2,43,7],[44,1,46,1],[44,2,44,6],[45,2,45,7],[46,2,46,7],[50,1,50,7],[47,1,49,1],[47,2,47,6],[48,2,48,7],[49,2,49,7]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,"B.   Overall Management Systems/Structure"]
[null,"This section is designed to assess grantee’s overall managements system and structure in relation to ensure compliance with program requirements and achievement of program goals."]
[]
[null,"Item","Description",null,null,null,null,"Score"]
[null,1,"Does the grantee have written policies and procedures that describe how screening will be conducted?  (Source: Policy and procedures (P&Ps), program brochures, interviews)"]
[null,null,"NOTES:"]
[]
[null,2,"Does the grantee have written policies and procedures that describe how program eligibility will be determined?  (Source: P&Ps, program brochures, interviews)\n"]
[null,null,"NOTES:"]
[]
[null,3,"Is the grantee participating in the local community’s coordinated entry process?  In communities where coordinated entry does not exist does the grantee have written policies and procedures that describe how admissions will be prioritized and who is responsible for making admission decisions?  (Source: P&Ps, interviews)"]
[null,null,"NOTES:"]
[]
[null,4,"Does the grantee have written policies that describe when a person is found ineligible for the program, they:\n    • Inform the participant as to the reasons\n     • Recommend alternative services to the Veteran\n     • Notify the referral source as to the reasons (if applicable)\n     • Inform the Veteran of the grievance process in the event \n        there is a disagreement with ineligibility determination\n\n(Source: P&Ps, interviews)"]
[null,null,"NOTES:"]
[]
[null,5,"In comparing the number of Veterans registered for the Participant Survey with the number of Veterans exited per HMIS for the same time period, did the grantee register at least 70% of exited households? (Source: M.Davis report, HMIS exits)"]
[null,null,"NOTES:"]
[]
[null,6,"Does the grantee review survey results from internal or Participant Survey? (Source: Interviews, meeting minutes)"]
[null,null,"NOTES:"]
[]
[null,7,"Is the grantee working to end Veteran homelessness in all  Continuum(s) of Care (CoC) listed on their resolution? (Source: CoC attendance sheet, CoC meeting minutes, interviews, resolution service area)"]
[null,null,"NOTES:"]
[]
[null,8,"Does the grantee have clear procedures for reporting and following-up on critical incidents including related to persons served? Critical incidents may include events involving injury, aggression or violence, suicide or attempted suicide, abuse, neglect.  (Source: P&Ps, interviews, incident reports, staff training records)"]
[null,null,"NOTES:"]
[]
[null,9,"Does the grantee have procedures for providing and documenting supervision of personnel delivering services to participants?  (Source: Documentation of supervision or team meetings, records of staff trainings, interviews, P&Ps)"]
[null,null,"NOTES:"]
[]
[null,10,"Does the grantee have position descriptions for all staff listed on the approved budget?  (Source: Budget, grantee records)"]
[null,null,"NOTES:"]
[]
[null,11,"Does the grantee have signed conflict of interest statements for their board of directors or other governing body?  (Source: Annual signed conflict of interest declarations, interviews)"]
[null,null,"NOTES:"]
[]
[null,12,"Does the grantee have a clear practice in place for landlord recruitment and retention for both identifying new landlords, and providing support to landlords and tenants after move in? (Source: Staff interviews)"]
[null,null,"NOTES:"]
[]
[null,13,"Is there a practice for keeping information (including paper records, electronic records, and HMIS) secure and protected?  (Source: Visual observance, P&Ps, staff interviews, demonstration of access to electronic records)\n"]
[null,null,"NOTES:"]
[]
[null,14,"Have all SSVF staff (including fiscal team) viewed the SSVF Fraud webinar? (Source: Interviews, training records)"]
[null,null,"NOTES:"]
[]
[null,"Overall Remarks:"]

{"sheet":"Section C","index":3,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[8,2,9,6],[10,2,10,6],[4,1,4,7],[5,1,6,7],[7,2,7,6],[8,1,9,1],[10,1,12,1],[16,1,18,1],[11,2,11,7],[12,2,12,7],[17,2,17,7],[18,2,18,7],[14,2,14,7],[15,2,15,7],[16,2,16,6],[13,2,13,6],[13,1,15,1],[30,1,30,7],[28,1,28,7],[20,2,20,7],[21,2,21,7],[22,2,22,6],[23,2,23,7],[24,2,24,7],[22,1,24,1],[19,1,21,1],[19,2,19,6],[25,1,27,1],[25,2,25,6],[26,2,26,7],[27,2,27,7],[29,1,29,7]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,"C.   Subcontractor Management (if applicable)"]
[null,"This section is designed to assess the grantee’s management of any subcontractors to ensure compliance with program requirements and achievement of program goals."]
[]
[null,"Item","Description",null,null,null,null,"Score"]
[null,"1a","Does the grantee have subcontractors as part of the SSVF Program?",null,null,null,null,"No"]
[null,null,null,null,null,null,null,{"$f":"IF(H9=\"Yes\",\"Continue with Section C\", IF(H9=\"No\", \"Skip to Section D\",\"\"))","v":"Skip to Section D"}]
[null,1,"Does the grantee have written policies and procedures, or language in the subcontractor agreement, which detail how the grantee will manage the work of the subcontractor? (Source:  FY18 Resolution, interviews, written agreements with subcontractor, P&Ps)"]
[null,null,"Notes:"]
[]
[null,2,"Does the grantee have copies of each subcontractor’s policies and procedures specific to SSVF?   (Source:  FY18 Resolution, written agreements with subcontractor, subcontractor P&Ps)"]
[null,null,"Notes:"]
[]
[null,3,"Has the grantee executed written agreements with its subcontractors to carry out program activities (signed MOUs/MOAs)?  (Source: Written agreements with subcontractor)"]
[null,null,"Notes:"]
[]
[null,4,"Do the written agreements contain descriptions of the type of supportive service activities that the subcontractor will perform along with payment guidelines? (Source: Written agreements with subcontractor)"]
[null,null,"Notes:"]
[]
[null,5,"Does the grantee have a system or method for amending subcontractor agreements?  (Source: Written agreements with subcontractor)"]
[null,null,"Notes:"]
[]
[null,6,"Does the grantee assess the performance of subcontractors at least quarterly and conduct an on-site annual monitoring? (Source: Written agreements with subcontractor, P&Ps, interviews, monitoring records)"]
[null,null,"Notes:"]
[]
[null,"Overall Remarks:"]

{"sheet":"Section D","index":4,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,1,4,7],[5,1,6,7],[7,2,7,6],[11,1,13,1],[14,1,16,1],[8,1,10,1],[8,2,8,6],[9,2,9,7],[10,2,10,7],[17,1,19,1],[11,2,11,6],[12,2,12,7],[13,2,13,7],[14,2,14,6],[15,2,15,7],[16,2,16,7],[17,2,17,6],[18,2,18,7],[19,2,19,7],[23,1,23,7],[24,1,35,7],[20,1,22,1],[20,2,20,6],[21,2,21,7],[22,2,22,7]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,"D.  Outreach and Targeting"]
[null,"This section is designed to assess outreach services as described in 38 CFR 62.30. Grantees must a) provide outreach services and use their best efforts to ensure that hard-to-reach very low-income veteran families occupying permanent housing are found, engaged and provided supportive services and b) outreach services must include active liaison with local VA facilities, State, local, tribal (if any), and private agencies and organizations providing supportive services to very low-income veteran families in the area or community served by the grantee."]
[]
[null,"Item","Description",null,null,null,null,"Score"]
[null,1,"Does the grantee conduct consistent outreach to all the communities/CoCs listed in their FY18 Resolution? \n(Source:  FY18 Resolution, outreach logs, interviews)"]
[null,null,"Notes:"]
[]
[null,2,"Does the grantee have documentation showing where outreach is conducted and the frequency of outreach activities? (Source:  FY18 Resolution, outreach logs, interviews [38 CFR 62.30])"]
[null,null,"Notes:"]
[]
[null,3,"Does the grantee provide consistent outreach efforts throughout the entire service area that target the populations identified in their grant agreement? (Source:  FY18 Resolution, outreach logs, interviews)"]
[null,null,"Notes:"]
[]
[null,4,"Does the grantee provide outreach services to find and engage hard-to-reach very low income veteran families throughout the service area? (Source:  FY18 Resolution, outreach logs, interviews)"]
[null,null,"Notes:"]
[]
[null,5,"Does the grantee receive referrals through the community's coordinated entry process?  In communities where coordinated entry does not exist does the grantee conduct and engage in outreach activities with private organizations, state agencies, local government agencies, and other providers in the community? (Source:  FY18 Resolution, outreach logs, interviews)"]
[null,null,"Notes:"]
[]
[null,"Overall Remarks:"]

{"sheet":"Section E","index":5,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[4,1,4,7],[5,1,6,7],[7,2,7,6],[8,2,8,6],[9,2,9,7],[24,2,24,7],[25,2,25,7],[10,2,10,7],[8,1,10,1],[11,1,13,1],[11,2,11,6],[12,2,12,7],[13,2,13,7],[42,2,42,7],[43,2,43,7],[14,1,16,1],[14,2,14,6],[15,2,15,7],[16,2,16,7],[17,1,19,1],[17,2,17,6],[18,2,18,7],[19,2,19,7],[23,1,25,1],[20,1,22,1],[20,2,20,6],[21,2,21,7],[22,2,22,7],[23,2,23,6],[41,2,41,6],[26,1,28,1],[26,2,26,6],[27,2,27,7],[28,2,28,7],[29,1,31,1],[29,2,29,6],[30,2,30,7],[31,2,31,7],[55,1,55,7],[32,1,34,1],[32,2,32,6],[33,2,33,7],[34,2,34,7],[45,1,45,7],[35,1,37,1],[35,2,35,6],[36,2,36,7],[37,2,37,7],[38,1,40,1],[38,2,38,6],[39,2,39,7],[40,2,40,7],[44,1,44,7],[41,1,43,1]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,"E.   Participant Eligibility"]
[null,"This section is designed to assess whether participant eligibility has been adequately documented in terms of each participant’s income and housing status upon program entry."]
[]
[null,"Item","Description",null,null,null,null,"Score"]
[null,1,"Do front line staff have a clear understanding of the process for determining eligibility?  (Source: Client files, interviews)"]
[null,null,"Notes:"]
[]
[null,2,"When a person is found ineligible for services, do frontline staff have knowledge of the process to:\n     • Inform the Veteran household as to the reasons\n     • Recommend alternative services to the Veteran\n     • Notify the referral source as to the reasons (if applicable)\n     • Inform the Veteran of the grievance process in the event there\n        is a disagreement with ineligibility determination. \n(Source: Interviews,ineligible screenings/intakes)\n\n\n"]
[null,null,"Notes:"]
[]
[null,3,"Do staff have knowledge of area resources to make referrals and clearly describe how they refer based on Veteran's individual needs? (Source: Client files, interviews, ineligible screenings/intakes)"]
[null,null,"Notes:"]
[]
[null,4,"Programs do not screen out households based on lack of income, criminal history, or other perceived housing barriers. (Source: Source: Client files, interviews, ineligible screenings/intakes)"]
[null,null,"Notes:"]
[]
[null,5,"Are more than 30% of the grantee’s clients being exited to HUD-VASH (not including HUD-VASH referral packet households)?   (Source: Client files, interviews, HMIS exits)"]
[null,null,"Notes:"]
[]
[null,6,"Are Veterans required to participant in supportive services prior to obtaining housing assistance?  (Source: Client files, interviews)"]
[null,null,"Notes:"]
[]
[null,7,"Do the client files include evidence of Veteran status (DD214, HINQ, etc.)?  (Source: Client files [38 CFR 62.2])"]
[null,null,"Notes:"]
[]
[null,8,"Do the files reviewed document the participants' housing status as either literally homeless or at-risk of literal homelessness at program entry?  Do prevention files contain an eligibility screener? \n(Source: Client files [38 CFR 62.11 (a)])"]
[null,null,"Notes:"]
[]
[null,9,"Do the files reviewed document each participant is a Veteran family whose annual income is at or below 50% of the area median income (in accordance with the most recent HUD AMI guidelines)?  (Source: Client files [24 CFR 5.609, 38 CFR 62.2])"]
[null,null,"Notes:"]
[]
[null,10,"Do the files reviewed document recertification of eligibility for each participant at least every 3 months? (Source: Client files [38 CFR 62.36])"]
[null,null,"Notes:"]
[]
[null,11,"Is the SSVF exit checklist in the client files that have been exited? (Source: Client files)"]
[null,null,"Notes:"]
[]
[null,12,"Are there releases of information in the client files? (Source: Client files)\n"]
[null,null,"Notes:"]
[]
[null,"Overall Remarks:"]

{"sheet":"Section F","index":6,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[40,2,40,7],[42,1,42,7],[33,2,33,7],[34,2,34,7],[8,2,8,6],[9,2,9,7],[10,2,10,7],[11,1,13,1],[11,2,11,6],[12,2,12,7],[16,2,16,7],[17,2,17,6],[18,2,18,7],[20,2,20,6],[21,2,21,7],[19,2,19,7],[4,1,4,7],[5,1,6,7],[14,2,14,6],[15,2,15,7],[8,1,10,1],[14,1,16,1],[13,2,13,7],[38,2,38,6],[17,1,19,1],[20,1,22,1],[23,1,25,1],[24,2,24,7],[25,2,25,7],[22,2,22,7],[37,2,37,7],[23,2,23,6],[39,2,39,7],[32,1,34,1],[32,2,32,6],[41,1,41,7],[26,1,28,1],[26,2,26,6],[27,2,27,7],[28,2,28,7],[29,1,31,1],[29,2,29,6],[30,2,30,7],[31,2,31,7],[35,1,37,1],[35,2,35,6],[36,2,36,7],[38,1,40,1]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,"F.   Supportive Services and Case Management"]
[null,"This section is designed to assess the grantee’s performance in conducting on-going participant needs assessments and in providing the supportive services identified in the approved application."]
[]
[null,"Item","Description",null,null,null,null,"Score"]
[null,1,"The Grantee is providing all agreed upon supportive services to participants that are based on an individualized housing-focused assessment. (Source: FY18 Resolution, client files)"]
[null,null,"Notes:"]
[]
[null,2,"Is there an individualized housing stability plan that is developed with the active involvement of participants served that identifies: \n  1.  Overall goals; \n  2.  Specific measureable objectives;\n  3.  Methods/techniques to be used to achieve the objectives; and\n  4.  Those responsible for implementation.\n(Source: Client files [38 CFR 62.31])"]
[null,null,"Notes:"]
[]
[null,3,"Do the files reviewed document that participants were linked to VA services for which the participant may be eligible? \n     • Vocational and rehabilitation counseling\n     • VA NSC or SC Pension\n     • Educational Assistance\n     • Health Care Services\n (Source: Client files [38 CFR 62.32])"]
[null,null,"Notes:"]
[]
[null,4,"Do the files reviewed document that participants were provided with assistance in obtaining and coordinating the provision of mainstream benefits? \nIncluding but not limited to the following:\n    • Health care services\n    • Daily living services\n    • Personal financial planning services\n    • Transportation services\n    • Income support services\n    • Fiduciary and representative payee services\n    • Legal Services\n    • Child Care\n    • Housing Counseling\n (Source: Client files [38 CFR 62.33])"]
[null,null,"Notes:"]
[]
[null,5,"Do the case files demonstrate that the grantee is providing housing counseling to participants related to the stabilization of a participant’s residence in permanent housing? \nIncluding but not limited to the following:\n    • Housing search assistance\n    • Rental and rent subsidy programs\n    • Federal, State, tribal or local assistance\n    • Fair housing\n    • Landlord tenant laws\n    • Rent delinquency\n    • Resolution or prevention of mortgage delinquency\n    • Home maintenance and budgeting\n(Source: Client files [38 CFR 62.33])"]
[null,null,"Notes:"]
[]
[null,6,"Does the grantee conduct ongoing assessments of the participants’ supportive services needs and review the coordinated housing stability plan with respect to expected outcomes?  (Source: Client files)"]
[null,null,"Notes:"]
[]
[null,7,"Was it clear in the file review that clients were allowed choice in determining their housing and stability plans? (Source: Client files)"]
[null,null,"Notes:"]
[]
[null,8,"Do the files reviewed document that the grantee assesses for rent affordability for Veterans receiving financial assistance and either staying in or moving into a new housing unit? \n (Source: Client Files)"]
[null,null,"Notes:"]
[]
[null,9,"If grant funds have been used for temporary assistance payments, is there documentation to demonstrate that such payments were necessary for maintaining independent living in permanent housing and housing stability?  (Source: Client files)"]
[null,null,"Notes:"]
[]
[null,10,"Do the files demonstrate that the grantee is assisting clients with their housing search?  (Source: Client files)"]
[null,null,"Notes:"]
[]
[null,11,"Do the files reviewed document that grantees conduct a habitability inspection on units for veterans receiving financial assistance AND moving into a new housing unit? (Source: Client files)"]
[null,null,"Notes:"]
[]
[null,"Overall Remarks:"]

{"sheet":"Section G","index":7,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[11,1,13,1],[14,1,16,1],[26,1,28,1],[29,1,31,1],[32,1,34,1],[17,1,19,1],[20,1,22,1],[23,1,25,1],[11,2,11,6],[14,2,14,6],[17,2,17,6],[20,2,20,6],[23,2,23,6],[22,2,22,7],[19,2,19,7],[16,2,16,7],[13,2,13,7],[12,2,12,7],[15,2,15,7],[18,2,18,7],[21,2,21,7],[4,1,4,7],[5,1,6,7],[7,2,7,6],[8,1,10,1],[8,2,8,6],[9,2,9,7],[10,2,10,7],[42,2,42,4],[25,2,25,7],[24,2,24,7],[26,2,26,6],[29,2,29,6],[31,2,31,7],[28,2,28,7],[32,2,32,6],[27,2,27,7],[30,2,30,7],[33,2,33,7],[37,2,37,7],[34,2,34,7],[35,2,35,6],[47,1,47,7],[48,1,48,7],[43,2,43,7],[36,2,36,7],[39,2,39,7],[35,1,37,1],[38,1,40,1],[41,1,43,1],[40,2,40,7],[38,2,38,6],[41,2,41,6],[44,1,46,1],[44,2,44,6],[45,2,45,7],[46,2,46,7],[42,5,42,6]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,"G.   Financial Management and Cost Allowability"]
[null,"This section is designed to review the grantee’s financial management system and eligibility of grant expenditures. This section is designed to review the SSVF grantee's allocation of cost to verify that its procedures comply with OMB Circular A87, OMB Circular A122, 24 CFR Part 84 and24 CFR 85.22, made applicable to the SSVF program per 38 CFR 62."]
[]
[null,"Item","Description",null,null,null,null,"Score"]
[null,1,"Does the grantee have written procedures for recording financial transactions, and a current accounting manual and a chart of accounts? (Source: Financial policies)"]
[null,null,"Notes:"]
[]
[null,2,"Do the files reviewed adequately document that grantees ensure that all temporary financial assistance payments are provided to third parties?  Does the grantee verify that payments are made to legitimate third party vendors? (Source: Client files, draw down backup documentation, interviews)"]
[null,null,"Notes:"]
[]
[null,3,"Does the grantee maintain written policies and procedures regarding the authority for approving financial transactions?\n(Source: Financial policies)"]
[null,null,"Notes:"]
[]
[null,4,"Is there a written policy that the staff duties are separated so that no one individual has complete authority over an entire financial transaction? (Source: Source: Financial policies)"]
[null,null,"Notes:"]
[]
[null,5,"Does the grantee have written procedures regarding record retention? (Source: Financial policies)"]
[null,null,"Notes:"]
[]
[null,6,"Are the grantee’s fiscal records and valuables secured in a limited access area?  (Source: Financial policies, interviews, visual observance)"]
[null,null,"Notes:"]
[]
[null,7,"Does the grantee track actual costs for all administrative purchases AND do all staff charged under Admin track actual time OR have a time study to account for what is charged to SSVF? (Source: Draw down backup documentation, fiscal records, interviews)"]
[null,null,"Notes:"]
[]
[null,8,"Are charges to SSVF for salaries and wages based on payroll documentation and approved by a responsible official of the organization being monitored?  (Source: Draw down backup documentation, fiscal records, interviews)"]
[null,null,"Notes:"]
[]
[null,9,"Are charges to SSVF for salaries and wages of Services staff supported by timesheets that account for actual hours of work performed on projects AND show multiple projects if the staff work on other projects in addition to SSVF?  (Source: Draw down backup documentation, fiscal records, interviews)"]
[null,null,"Notes:"]
[]
[null,10,"Do all SSVF funds spent line up with the approved budget categories and amounts allotted for each per the budget?\n(Source: Draw down backup documentation, fiscal records, interviews, approved budget)"]
[null,null,"Notes:"]
[]
[null,11,"Does the grantee have backup documentation and invoices to support the amount of funds drawn down from HHS PMS for the time period monitor is reviewing? (Source: Draw down backup documentation, fiscal records, interviews)"]
[null,null,"Notes:"]
[]
[null,12,"Is there evidence that ineligible expenses have been paid with SSVF funds (Examples of ineligible expenditures include, but are not limited to, costs associated with entertainment, contributions and donations, fines and penalties, or general governmental and nonprofit expenditures including salary and expenses of the chief executive officer of the grantee)?  (Source: Draw down backup documentation, fiscal records, interviews, client files, approved budget)"]
[null,null,"Notes and Explanation:",null,null,"Total Amount in Question",null,0]
[]
[null,13,"Is this grantee required to submit an A-133? If yes, was it also submitted on time per the clearing house site? (Source: Clearinghouse Website)"]
[null,null,"Notes:"]
[]
[null,"Overall Remarks:"]

{"sheet":"Section H","index":8,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,1,16,7],[17,1,17,7],[4,1,4,7],[5,1,6,7],[7,2,7,6],[8,1,9,1],[8,2,9,6],[10,1,12,1],[10,2,10,6],[11,2,11,7],[12,2,12,7],[13,1,15,1],[13,2,13,6],[14,2,14,7],[15,2,15,7]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,"H.   Vehicle Usage (if applicable) "]
[null,"This section is designed to review the grantee’s use of vehicles funded with SSVF Grant fund in accordance with the grant agreement"]
[]
[null,"Item","Description",null,null,null,null,"Score"]
[null,1,"Grantee has leased a vehicle with SSVF grant funds or transports veterans as part of SSVF program.  (Source: Program files, approved budget, vehicle records)",null,null,null,null,"No"]
[null,null,null,null,null,null,null,{"$f":"IF(H9=\"Yes\",\"Continue with Section H\",IF(H9=\"No\",\"Skip to Next Section\",\"\"))","v":"Skip to Next Section"}]
[null,2,"Vehicle(s) charged to SSVF have clear documentation to support the amounts charged to the program. (Source: Program files, approved budget, vehicle records, P&Ps related to vehicle usage, mileage logs)"]
[null,null,"Notes:"]
[]
[null,3,"When transportation is provided for participants there is evidence of:\n     1.Valid license for all drivers;\n     2. An up-to-date mileage log in place;\n     3. Insurance covering passengers;\n     4. Training of drivers regarding agency transportation procedures, cell phone availability, and safety training.              \n                   \n(Source: Program files, approved budget, vehicle records, mileage logs, visual inspection, P&Ps related to vehicle usage, safety, and maintenance, documentation training, copies of insurance, and drivers licenses)"]
[null,null,"Notes:"]
[]
[null,"Overall Remarks:"]

{"sheet":"Section I","index":9,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,1,4,7],[5,1,6,7],[7,2,7,6],[17,1,19,1],[17,2,17,6],[18,2,18,7],[19,2,19,7],[12,2,12,7],[13,2,13,7],[14,1,16,1],[14,2,14,6],[15,2,15,7],[16,2,16,7],[8,1,10,1],[8,2,8,6],[9,2,9,7],[10,2,10,7],[11,1,13,1],[11,2,11,6],[6,9,6,20],[7,10,7,11],[8,9,8,11],[9,9,9,10],[10,9,10,10],[26,1,26,7],[27,1,27,7],[20,1,22,1],[20,2,20,6],[21,2,21,7],[22,2,22,7],[23,1,25,1],[23,2,23,6],[24,2,24,7],[25,2,25,7]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,"I.   Data Management & Quality Assurance"]
[null,"This section is designed to review the grantee’s data management (HMIS and Repository Uploads) and assess whether quality assurance is in accordance with the grant agreement."]
[]
[null,"Item","Description",null,null,null,null,"Score"]
[null,1,"Does the grantee maintain a Comprehensive Data Quality Plan (as published in the \"FY 2016 VA Data Guide\") to ensure completeness, timeliness, and accuracy of HMIS data? (Source: P&Ps, CoC P&Ps)"]
[null,null,"Notes:"]
[]
[null,2,"Does the Data Quality Plan specifically detail staff responsibility including:  timelines for data entry and HMIS Repository uploads, and ongoing quality assurance procedures? (Source: P&Ps, CoC P&Ps)"]
[null,null,"Notes:"]
[]
[null,3,"Does the grantee successfully upload all client information into the SSVF HMIS Repository on a monthly basis? (Source: VA Spreadsheet)"]
[null,null,"Notes:"]
[]
[null,4,"Is the grantee entering or exporting data to all CoCs served? (Source: FY18 Resolution, interviews)"]
[null,null,"Notes:"]
[]
[null,5,"Is client file data accurately entered into the grantee's HMIS system?  Data entered should include ALL of the following data elements and match client file information provided:\n    • Valid VAMC station codes\n    • Valid CoC codes\n    • Valid Veteran SSN\n    • Residential move-in date (if applicable)\n    • Head of Household designation\n    • Housing Prevention Screener Scores Threshold \n       (if applicable)\n    • Services Provided\n    • Entry/Exit Date & Destination\n\n(Source: Client files, HMIS System Review)\n\n\n\n"]
[null,null,"Notes:"]
[]
[null,6,"Is TFA information captured in the HMIS data? Do HMIS TFA amounts reconcile with client file documentation and/or HHS drawdowns?\n(Source: Client files, HMIS System Review)"]
[null,null,"Notes:"]
[]
[null,"Overall Remarks:"]

{"sheet":"Section C_Supplement","index":10,"n_rows":102,"n_cols":5,"rows_kept":102,"cut":false,"hidden":false,"merged":[[8,1,8,3],[10,1,10,3],[10,4,10,6],[14,2,14,6],[15,2,15,6],[34,2,34,6],[16,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[21,2,21,6],[22,1,22,6],[23,1,27,6],[32,2,32,6],[33,2,33,6],[57,1,57,2],[35,2,35,6],[36,2,36,6],[40,1,40,6],[41,1,45,6],[50,1,50,2],[50,3,50,6],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[37,2,37,6],[38,2,38,6],[39,2,39,6],[56,1,56,2],[71,1,75,6],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[70,1,70,6],[68,1,68,2],[69,1,69,2],[102,1,110,6],[80,2,80,6],[81,2,81,6],[82,2,82,6],[83,2,83,6],[84,2,84,6],[86,2,86,6],[88,2,88,6],[89,2,89,6],[90,1,90,6],[91,1,95,6],[101,1,101,6],[87,2,87,6],[85,2,85,6]]}
[]
[]
[]
[null,null,"Supportive Services for Veteran Families"]
[null,null,"PART C:  SUBCONTRACTOR FOCUS REVIEW"]
[null,null,"(Supplement to Section C)"]
[]
["SECTION 1:  2-DAY SUBCONTRACTOR REVIEW"]
[null,"Was this grantee flagged for a 2-Day subcontractor review?",null,null,"No"]
[]
[null,"Subcontracted agency reviewed on Day 2: ",null,null,"Subcontractor Agency ABC"]
[]
["SECTION 2:  MANAGEMENT OF SSVF PROGRAM"]
[]
[null,null,{"$f":"E11","v":"Subcontractor Agency ABC"}]
[null,"Does the subcontractor have job descriptions in place for all SSVF Program staff?"]
[null,"Is the subcontractor informed about program updates and changes within a few days of them taking effect? "]
[null,"Does the subcontractor have their own policies and procedures for carrying out SSVF services separate from the grantee’s policies and procedures OR is there clear documentation that they follow the policies of the grantee?"]
[null,"Does the subcontractor have documentation or notes of supervision provided to their front line staff delivering services to participants?"]
[null,"Does the subcontractor management team understand eligibility criteria for SSVF and requirements around case management and referrals provided by their staff? "]
[null,"Do subcontractor front line staff understand eligibility criteria and what to do with ineligible Veteran families? "]
[null,"Does the subcontractor have written practices to protect client information which are trained on and carried out by the staff?"]
[null,"Notes:"]
[]
[]
[]
[]
[]
[null,"Management of SSVF Program",{"$f":"IF(AND(E9=\"Yes\",C16=\"Yes\",C17=\"Yes\",C18=\"Yes\",C19=\"Yes\",C20=\"Yes\",C21=\"Yes\",C22=\"Yes\"),\"PASS\",IF(E9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
["SECTION 3:  CARRYING OUT MOU/AGREEMENT"]
[]
[null,null,{"$f":"E11","v":"Subcontractor Agency ABC"}]
[null,"Does the subcontractor have written documentation of all duties being carried out via logs, records, or documented in client files?"]
[null,"Does the subcontractor meet all other requirements of their MOU beyond the services provided as addressed in the question above? I.e. submitting invoices, etc."]
[null,"Is there a process in place to notify the grantee of any issues or concerns raised by the subcontractor?"]
[null,"Does the subcontractor report that the grantee responds to their issues or concerns immediately, in order to address the subcontractor's needs?"]
[null,"Has the subcontractor received a monitoring visit by the grantee to include reviewing client records, financial records, and other program documentation?"]
[null,"Did the subcontractor or grantee provide written results of the monitoring review conducted on the subcontractor to the SSVF monitor?"]
[null,"Does the subcontractor have a process in place to address any issues found during the grantee monitor visit AND did they address any issues from the most recent review?"]
[null,"Notes:"]
[]
[]
[]
[]
[]
[null,"Carrying Out MOU/Agreement",{"$f":"IF(AND(E9=\"Yes\",C34=\"Yes\",C35=\"Yes\",C36=\"Yes\",C37=\"Yes\",C38=\"Yes\",C39=\"Yes\",C40=\"Yes\"),\"PASS\",IF(E9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
["SECTION 4:  FILE REVIEW - Review 4 additional subcontractor files"]
[]
[null,null,null,{"$f":"E11","v":"Subcontractor Agency ABC"}]
[null,"Do the client files include evidence of Veteran status (DD214, HINQ, etc.)?"]
[null,"Do the files reviewed document the participants' housing status as either literally homeless or at-risk of literal homelessness at program entry?  Do prevention files contain an eligibility screener?"]
[null,"Do the files reviewed document each participant is a Veteran family whose annual income is at or below 50% of the area median income (in accordance with the most recent HUD AMI guidelines)? "]
[null,"Do the files reviewed document recertification of eligibility for each participant at least every 3 months?"]
[null,"Do the files reviewed document the exit criteria for each client?"]
[null,"Are there releases of information in the client files?"]
[null,"Is there an individualized housing stability plan that is developed with the active involvement participants served that identifies:\n    1. Overall goals\n    2. Specific measurable objectives\n    3. Methods/techniques to be used to achieve the objectives\n    4. Those responsible for implementation"]
[null,"Do the files reviewed document that participants were linked to VA services for which the participant may be eligible?"]
[null,"Do the files reviewed document that participants were provided with assistance in obtaining and coordinating the provision of mainstream benefits?"]
[null,"Do the case files demonstrate that the subcontractor is providing housing counseling to participants related to the stabilization of a participant’s residence in permanent housing? "]
[null,"Does the subcontractor conduct ongoing assessments of the participants’ supportive services needs and review the coordinated housing stability plan with respect to expected outcomes?"]
[null,"Was it clear in the file review that clients were allowed choice in determining their housing and stability plans?"]
[null,"Do the files reviewed document that the grantee assesses for rent reasonableness for Veterans receiving financial assistance and either staying in or moving into a new housing unit?"]
[null,"If grant funds have been used for temporary assistance payments, is there documentation to demonstrate that such payments were necessary for maintaining independent living in permanent housing and housing stability? "]
[null,"Do the files demonstrate that the subcontractor is assisting clients with their housing search?"]
[null,"Do the files reviewed adequately document that grantees conduct a habitability inspection on units for veterans receiving financial assistance AND moving into a new housing unit?"]
[null,"Do the files reviewed adequately document that grantees ensure that all temporary financial assistance payments are provided to third parties?"]
[null,"Is client file data accurately entered into the grantee's HMIS system?  Data entered should include ALL of the following data elements and match client file information provided:\n    • Valid VAMC station codes\n    • Valid CoC code\n    • Valid Veteran SSN\n    • Residential move-in date (if applicable)\n    • Head of Household designation\n    • Housing Prevention Screener Scores/Threshold (if applicable)\n    • Services Provided\n    • Entry/Exit Date & Destination\n"]
[null,"Are TFA payment amounts accurately entered in HMIS and match client file information?"]
[null,"Notes:"]
[]
[]
[]
[]
[]
[null,"File Review",{"$f":"IF(AND(OR(D52=\"Yes\",D52=\"N/A\"),OR(E52=\"Yes\",E52=\"N/A\"),OR(F52=\"Yes\",F52=\"N/A\"),OR(G52=\"Yes\",G52=\"N/A\"), OR(D53=\"Yes\",D53=\"N/A\"),OR(E53=\"Yes\",E53=\"N/A\"),OR(F53=\"Yes\",F53=\"N/A\"),OR(G53=\"Yes\",G53=\"N/A\"),OR(D54=\"Yes\",D54=\"N/A\"),OR(E54=\"Yes\",E54=\"N/A\"),OR(F54=\"Yes\",F54=\"N/A\"),OR(G54=\"Yes\",G54=\"N/A\"), OR(D55=\"Yes\",D55=\"N/A\"),OR(E55=\"Yes\",E55=\"N/A\"),OR(F55=\"Yes\",F55=\"N/A\"),OR(G55=\"Yes\",G55=\"N/A\"),OR(D56=\"Yes\",D56=\"N/A\"),OR(E56=\"Yes\",E56=\"N/A\"),OR(F56=\"Yes\",F56=\"N/A\"),OR(G56=\"Yes\",G56=\"N/A\"),OR(D58=\"Yes\",D58=\"N/A\"),OR(E58=\"Yes\",E58=\"N/A\"),OR(F58=\"Yes\",F58=\"N/A\"),OR(G58=\"Yes\",G58=\"N/A\"),OR(D59=\"Yes\",D59=\"N/A\"),OR(E59=\"Yes\",E59=\"N/A\"),OR(F59=\"Yes\",F59=\"N/A\"),OR(G59=\"Yes\",G59=\"N/A\"),OR(D60=\"Yes\",D60=\"N/A\"),OR(E60=\"Yes\",E60=\"N/A\"),OR(F60=\"Yes\",F60=\"N/A\"),OR(G60=\"Yes\",G60=\"N/A\"),OR(D61=\"Yes\",D61=\"N/A\"),OR(E61=\"Yes\",E61=\"N/A\"),OR(F61=\"Yes\",F61=\"N/A\"),OR(G61=\"Yes\",G61=\"N/A\"),OR(D62=\"Yes\",D62=\"N/A\"),OR(E62=\"Yes\",E62=\"N/A\"),OR(F62=\"Yes\",F62=\"N/A\"),OR(G62=\"Yes\",G62=\"N/A\"),OR(D63=\"Yes\",D63=\"N/A\"),OR(E63=\"Yes\",E63=\"N/A\"),OR(F63=\"Yes\",F63=\"N/A\"),OR(G63=\"Yes\",G63=\"N/A\"),OR(D64=\"Yes\",D64=\"N/A\"),OR(E64=\"Yes\",E64=\"N/A\"),OR(F64=\"Yes\",F64=\"N/A\"),OR(G64=\"Yes\",G64=\"N/A\"),OR(D65=\"Yes\",D65=\"N/A\"),OR(E65=\"Yes\",E65=\"N/A\"),OR(F65=\"Yes\",F65=\"N/A\"),OR(G65=\"Yes\",G65=\"N/A\"),OR(D66=\"Yes\",D66=\"N/A\"),OR(E66=\"Yes\",E66=\"N/A\"),OR(F66=\"Yes\",F66=\"N/A\"),OR(G66=\"Yes\",G66=\"N/A\"),OR(D67=\"Yes\",D67=\"N/A\"),OR(E67=\"Yes\",E67=\"N/A\"),OR(F67=\"Yes\",F67=\"N/A\"),OR(G67=\"Yes\",G67=\"N/A\"),OR(D68=\"Yes\",D68=\"N/A\"),OR(E68=\"Yes\",E68=\"N/A\"),OR(F68=\"Yes\",F68=\"N/A\"),OR(G68=\"Yes\",G68=\"N/A\"), OR(D69=\"Yes\",D69=\"N/A\"),OR(E69=\"Yes\",E69=\"N/A\"),OR(F69=\"Yes\",F69=\"N/A\"),OR(G69=\"Yes\",G69=\"N/A\"), OR(D70=\"Yes\",D70=\"N/A\"),OR(E70=\"Yes\",E70=\"N/A\"),OR(F70=\"Yes\",F70=\"N/A\"),OR(G70=\"Yes\",G70=\"N/A\")),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
["SECTION 5:  FINANCIAL MANAGEMENT"]
[]
[null,null,{"$f":"E11","v":"Subcontractor Agency ABC"}]
[null,"Does the subcontractor submits invoices with back-up documentation to grantee in the timeframe identified in the MOU?"]
[null,"Does the subcontracted staff keep timesheets that indicate actual hours worked on the SSVF Program and that are reviewed and signed by an authorized official?"]
[null,"At the subcontractor agency, are payroll documents  prepared on a monthly basis (at minimum) and coincide with one or more pay periods?"]
[null,"Are subcontractor's administrative costs broken down and not based on indirect cost rate or another set percentage?"]
[null,"Did subcontractor provide their SSVF budget for monitor's review? "]
[null,"Are subcontractor expenditures consistent with the grantee's SSVF Final Budget, meaning align with budget line items?"]
[null,"Do all expenses reviewed by monitor include clear invoices and back up documentation to support costs?"]
[null,"Are all expenses reviewed for eligible costs?"]
[null,"Does the grantee reimburse the subcontractor for their work in the timeframe identified in the MOU?"]
[null,"Notes:"]
[]
[]
[]
[]
[]
[null,"Financial Management",{"$f":"IF(AND(E9=\"Yes\",C82=\"Yes\",C83=\"Yes\",C84=\"Yes\",OR(C85=\"Yes\",C85=\"N/A\"),C86=\"Yes\",C87=\"Yes\",C88=\"Yes\",C89=\"Yes\",C90=\"Yes\"),\"PASS\",IF(E9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
[]
[null,"FINAL RESULT FOR SUB SUPPLEMENT:",{"$f":"IF(AND(E9=\"Yes\",C29=\"PASS\",C47=\"PASS\",C77=\"PASS\",C97=\"PASS\"),\"PASS\",IF($E$9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
[null,"Overall Remarks:"]

{"sheet":"Section G_Supplement","index":11,"n_rows":177,"n_cols":12,"rows_kept":177,"cut":false,"hidden":false,"merged":[[166,3,166,10],[131,6,131,10],[132,6,132,10],[129,4,129,5],[131,2,131,3],[131,4,131,5],[154,1,154,2],[162,1,162,12],[136,4,136,5],[137,2,137,3],[155,3,158,10],[8,1,8,2],[152,1,152,12],[132,2,132,3],[132,4,132,5],[133,2,133,3],[133,4,133,5],[134,2,134,3],[134,4,134,5],[124,1,124,12],[127,1,127,12],[129,2,129,3],[129,6,129,10],[130,1,130,10],[142,1,142,12],[144,1,144,2],[136,2,136,3],[176,1,176,11],[177,1,185,11],[112,1,112,11],[100,1,103,11],[137,4,137,5],[138,2,138,3],[138,4,138,5],[133,6,136,10],[137,6,137,10],[138,6,138,10],[135,2,135,3],[135,4,135,5],[167,3,171,10],[144,3,144,10],[145,3,148,10],[154,3,154,10],[99,1,99,11],[113,1,116,11],[123,1,123,12],[19,1,22,11],[32,1,35,11],[45,1,48,11],[61,1,64,11],[77,1,80,11],[31,1,31,11],[44,1,44,11],[60,1,60,11],[76,1,76,11],[89,1,89,11],[90,1,90,11]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[null,null,null,null,"Supportive Services for Veteran Families (SSVF)"]
[null,null,null,null,"PART B:  FISCAL ADMINISTRATION REVIEW"]
[null,null,null,null,"(Supplement to Section G)"]
[]
[]
["1)","Was this grantee flagged for an additional fiscal review?",null,"No"]
[]
["SECTION A:  TEMPORARY FINANCIAL ASSISTANCE PAYMENTS"]
[]
[null,"RENTAL ASSISTANCE","Record #1","Record #2","Record #3","Record #4","Record #5","Record #6","Record #7","Record #8","Record #9","Record #10"]
[null,"Record ID:"]
[null,"Was rental assistance provided to SSVF participant?"]
[null,"If yes, are the payments consistent with the NOFA limitations AND was there backup documentation to match the amount paid?  (i.e.  Payments per participant household cannot exceed 6 months of rental assistance in a 12 month period OR 10 months of rental assistance in a 2-year period; for extremely low income veterans cannot exceed 9 months of rental assistance in a 12 month period OR 12 months in a 2-year period)."]
[null,"If yes, are the payments made directly to a third party?"]
[null,"Individual Record Result",{"$f":"IF(C15=\"No\",1,IF(AND(C16=\"Yes\",C17=\"Yes\"),1,0))","v":0},0,0,0,0,0,0,0,0,0]
[null,"Notes:"]
[]
[]
[]
[]
[null,"Rental Assistance Result:",{"$f":"IF(AND(D9=\"Yes\",C18+D18+E18+F18+G18+H18+I18+J18+K18+L18=10),\"PASS\",IF(D9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
[null,"UTILITY PAYMENT ASSISTANCE","Record #1","Record #2","Record #3","Record #4","Record #5","Record #6","Record #7","Record #8","Record #9","Record #10"]
[null,"Record ID:",{"$f":"C14","v":0},0,0,0,0,0,0,0,0,0]
[null,"Was utility payment assistance provided to SSVF participant?"]
[null,"If yes, are the payments consistent with the NOFA limitations AND was there backup documentation to match the amount paid?  (i.e.  Payments per participant household cannot exceed 6 months in a 12 month period OR 10 months in a 2-year period; for extremely low income veterans cannot exceed 9 months in a 12 month period OR 12 months in a 2-year period)."]
[null,"If yes, are the payments made directly to a third party?"]
[null,"Individual Record Result",{"$f":"IF(C28=\"No\",\"PASS\",IF(AND(C29=\"Yes\",C30=\"Yes\"),\"PASS\",\"FAIL\"))","v":"FAIL"},{"$f":"IF(D28=\"No\",\"PASS\",IF(AND(D29=\"Yes\",D30=\"Yes\"),\"PASS\",\"FAIL\"))","v":"FAIL"},{"$f":"IF(E28=\"No\",\"PASS\",IF(AND(E29=\"Yes\",E30=\"Yes\"),\"PASS\",\"FAIL\"))","v":"FAIL"},"FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL"]
[null,"Notes:"]
[]
[]
[]
[]
[null,"Utility Payment Assistance Result:",{"$f":"IF(AND($D$9=\"Yes\",C31=\"PASS\",D31=\"PASS\",E31=\"PASS\",F31=\"PASS\",G31=\"PASS\",H31=\"PASS\",I31=\"PASS\",J31=\"PASS\",K31=\"PASS\",L31=\"PASS\"),\"PASS\",IF($D$9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
[null,"SECURITY OR UTILITY DEPOSITS","Record #1","Record #2","Record #3","Record #4","Record #5","Record #6","Record #7","Record #8","Record #9","Record #10"]
[null,"Record ID:",{"$f":"C14","v":0},0,0,0,0,0,0,0,0,0]
[null,"Was security or utility deposit provided to SSVF participant?"]
[null,"If yes, are the payments consistent with the NOFA limitations AND was there backup documentation to match the amount paid?  (i.e.  A maximum of one security deposit and one utility deposit may be paid per participant during a 2-year period)."]
[null,"If yes, are the deposits made directly to a third party?"]
[null,"Individual Record Result",{"$f":"IF(C41=\"No\",\"PASS\",IF(AND(C42=\"Yes\",C43=\"Yes\"),\"PASS\",\"FAIL\"))","v":"FAIL"},{"$f":"IF(D41=\"No\",\"PASS\",IF(AND(D42=\"Yes\",D43=\"Yes\"),\"PASS\",\"FAIL\"))","v":"FAIL"},"FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL"]
[null,"Notes:"]
[]
[]
[]
[]
[null,"Security or Utility Deposits Result:",{"$f":"IF(AND($D$9=\"Yes\",C44=\"PASS\",D44=\"PASS\",E44=\"PASS\",F44=\"PASS\",G44=\"PASS\",H44=\"PASS\",I44=\"PASS\",J44=\"PASS\",K44=\"PASS\",L44=\"PASS\"),\"PASS\",IF($D$9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
[null,"TRANSPORTATION","Record #1","Record #2","Record #3","Record #4","Record #5","Record #6","Record #7","Record #8","Record #9","Record #10"]
[null,"Record ID:",{"$f":"C14","v":0},0,0,0,0,0,0,0,0,0]
[null,"Was transportation TFA provided to SSVF participant?"]
[null,"If yes, was the TFA provided related to car repair/maintenance?"]
[null,"If yes, are the payments consistent with the NOFA limitations AND was there backup documentation to match the amount paid??  (i.e. Car repair or maintenance assistance for a participant may not exceed $1,200 in a 2-year period)."]
[null,"If yes, are the car repair payments made directly to a third party?"]
[null,"If yes, was the TFA provided related to public transportation?"]
[null,"If yes, can the transit tokens or voucher payments be linked to a specific SSVF participant?  (i.e. The Grantee has not made a bulk purchase of transit tokens without specific client need demonstrated)."]
[null,"Individual Record Result",{"$f":"IF(C54=\"No\",\"PASS\",IF(AND(C55=\"Yes\",C56=\"Yes\",C57=\"Yes\",C58=\"No\"),\"PASS\",IF(AND(C55=\"No\",C58=\"Yes\",C59=\"Yes\"),\"PASS\",IF(AND(C55=\"YES\",C56=\"Yes\",C57=\"Yes\",C58=\"Yes\",C59=\"Yes\"),\"PASS\",\"FAIL\"))))","v":"FAIL"},{"$f":"IF(D54=\"No\",\"PASS\",IF(AND(D55=\"Yes\",D56=\"Yes\",D57=\"Yes\",D58=\"No\"),\"PASS\",IF(AND(D55=\"No\",D58=\"Yes\",D59=\"Yes\"),\"PASS\",IF(AND(D55=\"YES\",D56=\"Yes\",D57=\"Yes\",D58=\"Yes\",D59=\"Yes\"),\"PASS\",\"FAIL\"))))","v":"FAIL"},"FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL"]
[null,"Notes:"]
[]
[]
[]
[]
[null,"Transportation Result:",{"$f":"IF(AND($D$9=\"Yes\",C60=\"PASS\",D60=\"PASS\",E60=\"PASS\",F60=\"PASS\",G60=\"PASS\",H60=\"PASS\",I60=\"PASS\",J60=\"PASS\",K60=\"PASS\",L60=\"PASS\"),\"PASS\",IF($D$9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
[null,"GENERAL HOUSING STABILITY ASSISTANCE (INCLUDING EMERGENCY SUPPLIES ASSISTANCE)","Record #1","Record #2","Record #3","Record #4","Record #5","Record #6","Record #7","Record #8","Record #9","Record #10"]
[null,"Record ID:",{"$f":"C14","v":0},0,0,0,0,0,0,0,0,0]
[null,"Was general housing stability assistance provided to SSVF participant?"]
[null,"If yes, are the payments consistent with the NOFA limitations AND was there backup documentation to match the amount paid??  (i.e.  Limited to $1,500 total GHS [this includes a $500 maximum for Emergency Supplies Assistance] per participant household during a 2-year period)"]
[null,"If yes, are the items purchased necessary for a participant's life or safety to address an emergency situation?"]
[null,"If yes, are the expenses associated with gaining or keeping employment (such as tool, uniforms, certifications, and licenses)?"]
[null,"If yes, are the expenses associated with moving into permanent housing (such as basic kitchen utensils, bedding, and other supplies)?"]
[null,"If yes, are the expenses necessary for securing appropriate permanent housing (such as fees for applications, brokerage fees, or background checks)?"]
[null,"Individual Record Result",{"$f":"IF(C70=\"No\",\"PASS\",IF(AND(C71=\"Yes\",OR((C72=\"Yes\"),OR(C73=\"Yes\"),OR(C74=\"Yes\"),OR(C75=\"Yes\"))),\"PASS\",\"FAIL\"))","v":"FAIL"},"FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL"]
[null,"Notes:"]
[]
[]
[]
[]
[null,"GHS Result:",{"$f":"IF(AND($D$9=\"Yes\",C76=\"PASS\",D76=\"PASS\",E76=\"PASS\",F76=\"PASS\",G76=\"PASS\",H76=\"PASS\",I76=\"PASS\",J76=\"PASS\",K76=\"PASS\",L76=\"PASS\"),\"PASS\",IF($D$9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
[null,"EMERGENCY HOUSING ASSISTANCE","Record #1","Record #2","Record #3","Record #4","Record #5","Record #6","Record #7","Record #8","Record #9","Record #10"]
[null,"Record ID:",{"$f":"C14","v":0},0,0,0,0,0,0,0,0,0]
[null,"Was emergency housing assistance provided to SSVF participant?"]
[null,"If yes, are the payments consistent with the NOFA limitations AND was there backup documentation to match the amount paid?  (i.e.  Payments cannot exceed 72 hours for single Veterans [unless grantee can certify that appropriate shelter/GPD beds are unavailable at the end of that time] OR 45 days for Veterans with spouse/dependents. Assistance may be provided one time per 2-years.)"]
[null,"If yes, are the payments reasonable in relation to the costs charged for other available emergency housing considering the location, quality, size, and type of emergency housing?"]
[null,"Individual Record Result",{"$f":"IF(C86=\"No\",\"PASS\",IF(AND(C86=\"Yes\",C87=\"Yes\",C88=\"Yes\"),\"PASS\",\"FAIL\"))","v":"FAIL"},{"$f":"IF(D86=\"No\",\"PASS\",IF(AND(D86=\"Yes\",D87=\"Yes\",D88=\"Yes\"),\"PASS\",\"FAIL\"))","v":"FAIL"},"FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL"]
[null,"Notes:"]
[]
[null,"Emergency Housing Result:",{"$f":"IF(AND($D$9=\"Yes\",C89=\"PASS\",D89=\"PASS\",E89=\"PASS\",F89=\"PASS\",G89=\"PASS\",H89=\"PASS\",I89=\"PASS\",J89=\"PASS\",K89=\"PASS\",L89=\"PASS\"),\"PASS\",IF($D$9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
[null,"MOVING COSTS","Record #1","Record #2","Record #3","Record #4","Record #5","Record #6","Record #7","Record #8","Record #9","Record #10"]
[null,"Record ID:",{"$f":"C14","v":0},0,0,0,0,0,0,0,0,0]
[null,"Was TFA related to moving costs provided to SSVF participant?"]
[null,"If yes, are the payments consistent with the NOFA limitations AND was there backup documentation to match the amount paid?  (i.e. Includes reasonable costs such as truck rental, hiring a moving company, or short-term storage fees for a maximum of 3 months or until the participant is in permanent housing, whichever is shorter limited to one time in a 2-year period.)"]
[null,"If yes, are the payments made directly to a third party?"]
[null,"Individual Record Result",{"$f":"IF(C96=\"No\",\"PASS\",IF(AND(C97=\"Yes\",C98=\"Yes\"),\"PASS\",\"FAIL\"))","v":"FAIL"},{"$f":"IF(D96=\"No\",\"PASS\",IF(AND(D97=\"Yes\",D98=\"Yes\"),\"PASS\",\"FAIL\"))","v":"FAIL"},"FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL"]
[null,"Notes:"]
[]
[]
[]
[]
[null,"Moving Costs Result:",{"$f":"IF(AND($D$9=\"Yes\",C99=\"PASS\",D99=\"PASS\",E99=\"PASS\",F99=\"PASS\",G99=\"PASS\",H99=\"PASS\",I99=\"PASS\",J99=\"PASS\",K99=\"PASS\",L99=\"PASS\"),\"PASS\",IF($D$9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
[null,"CHILD CARE","Record #1","Record #2","Record #3","Record #4","Record #5","Record #6","Record #7","Record #8","Record #9","Record #10"]
[null,"Record ID:",{"$f":"C14","v":0},0,0,0,0,0,0,0,0,0]
[null,"Was TFA related to child care costs provided to SSVF participant?"]
[null,"If yes, are the payments consistent with the NOFA limitations AND was there backup documentation to match the amount paid?  (i.e. must be made to an \"eligible\" child care provider for a maximum of 6 months in a 12-month period OR 10 months in a 2-year period; for extremely low income veterans a maximum of 9 months in a 12-month period OR 12 months in a 2-year period.)"]
[null,"If yes, are the payments made directly to a third party?"]
[null,"Individual Record Result",{"$f":"IF(C109=\"No\",\"PASS\",IF(AND(C110=\"Yes\",C111=\"Yes\"),\"PASS\",\"FAIL\"))","v":"FAIL"},{"$f":"IF(D109=\"No\",\"PASS\",IF(AND(D110=\"Yes\",D111=\"Yes\"),\"PASS\",\"FAIL\"))","v":"FAIL"},"FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL","FAIL"]
[null,"Notes:"]
[]
[]
[]
[]
[null,"Child Care Result:",{"$f":"IF(AND($D$9=\"Yes\",C112=\"PASS\",D112=\"PASS\",E112=\"PASS\",F112=\"PASS\",G112=\"PASS\",H112=\"PASS\",I112=\"PASS\",J112=\"PASS\",K112=\"PASS\",L112=\"PASS\"),\"PASS\",IF($D$9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
["2)","SECTION A FINAL RESULT:",{"$f":"IF(AND($D$9=\"Yes\",C24=\"PASS\",C37=\"PASS\",C50=\"PASS\",C66=\"PASS\",C82=\"PASS\",C105=\"PASS\",C118=\"PASS\",C92=\"PASS\"),\"PASS\",IF($D$9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
["SECTION B:  GENERAL LEDGER EXPENDITURES"]
[]
[null,"Overview:"]
[null,"The concepts of reasonableness, allowability, and allocability of costs address directly the legitimacy of a cost charged against a grant award. 2 CFR Part 230 provides the following criteria: A cost is reasonable if, in its nature or amount, it does not exceed that which would be incurred by a prudent person under the circumstances prevailing at the time the decision was made to incur the costs. \n\nTo be allowable under an award, costs must meet the following general criteria: \n• Be reasonable for the performance of the award and be allocable thereto under these principles. \n• Conform to any limitations or exclusions set forth in these principles or in the award as to types or amount of cost items. \n• Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the organization. \n• Be accorded consistent treatment. \n• Be determined in accordance with generally accepted accounting principles (GAAP). \n• Not be included as a cost or used to meet cost sharing or matching requirements of any other federally-financed program in either the current or a prior period. \n• Be adequately documented. \n\nA cost is allocable to a particular cost objective, such as a grant, contract, project, service, or other activity, in accordance with the relative benefits received.\n"]
[]
[null,"GENERAL LEDGER EXPENSES"]
[null,"Review general ledger expenses reimbursed with SSVF funds against the grantee's final budget provided by the SSVF Program Office.  All costs should meet reasonable, allowable, and allocable criteria."]
[]
[null,null,"Expenses from draw down reviewed are consistent with SSVF Final Budget, meaning the expenses directly match to a line item on the budget and do not exceed the budget amounts listed.",null,"Expenses reviewed are allowable AND there is back up documentation for the following:",null,"Notes:"]
[null,"Budget Categories:"]
[null,"1.  Personnel/Labor"]
[null,"2.  TFA"]
[null,"3.  Other Non-Personnel Service Expenses & Coordination of Supportive Services"]
[null,"Outreach Materials"]
[null,"Staff Travel/Training"]
[null,"Equipment"]
[null,"4.  Lease & Maintenance of Vehicles"]
[null,"5.  Administrative"]
["3)","Review Final Result:",{"$f":"IF(AND(D9=\"Yes\",OR(C132=\"Yes\", C132 = \"N/A\"),OR(E132=\"Yes\", E132=\"N/A\"), OR(C133=\"Yes\", C133 =\"N/A\"), OR(E133=\"Yes\", E133 = \"N/A\"), OR(C134=\"Yes\", C134 = \"N/A\"), OR(E134=\"Yes\", E134 = \"N/A\"), OR(C135=\"Yes\", C135=\"N/A\"), OR(E135=\"Yes\", E135 = \"N/A\"), OR(C136=\"Yes\", C136 = \"N/A\"), OR(E136=\"Yes\", E136 = \"N/A\"), OR(C137=\"Yes\", C137 = \"N/A\"), OR(E137=\"Yes\", E137 = \"N/A\"), OR(C138=\"Yes\", C138 = \"N/A\"), OR(E138=\"Yes\", E138 = \"N/A\"), OR(C139=\"Yes\", C139 = \"N/A\"), OR(E139=\"Yes\", E139 = \"N/A\")),\"PASS\",IF(D9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
[null,"PAYROLL"]
[null,"Review all payroll documentation for a 3 month time period.   Compare payroll expenses against the grantee's final budget provided by the SSVF Program Office.  All costs should meet reasonable, allowable, and allocable criteria.  For staff serving multiple programs, SSVF Funds used should be proportional to the % FTE budgeted."]
[]
[null,"Overall Findings:",null,"Notes:"]
[null,"Payroll documents are consistent with SSVF Final Budget Budget, meaning staff paid match who are on the budget and no unapproved staff are paid by SSVF."]
[null,"Payroll documents/timesheets for Services staff adequately reflect the actual effort provided by each staff member to the SSVF grant (i.e. timesheets, etc.)"]
[null,"Payroll documents are reviewed and signed by an authorized official."]
[null,"Payroll documents are prepared on a monthly basis (at minimum) and coincide with one or more pay periods"]
["4)","Payroll Review Final Result:",{"$f":"IF(AND(D9=\"Yes\",C146=\"Yes\",C147=\"Yes\",C148=\"Yes\",C149=\"Yes\"),\"PASS\",IF(D9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
["SECTION C:  ADMINISTRATIVE EXPENDITURES"]
[null,"Review administrative expenses reimbursed with SSVF funds against the grantee's final budget provided by the SSVF Program Office.  All costs should meet reasonable, allowable, and allocable criteria. "]
[]
[null,"Overall Findings:",null,"Notes:"]
[null,"Administrative costs are consistent with the SSVF Final Budget and there are invoices to support all costs Administrative costs paid."]
[null,"Administrative costs are not drawn down based on an indirect cost rate or set percentage. (ineligible)"]
[null,"Administrative costs do not exceed 10% of the total SSVF grant award amount."]
[null,"Payroll documents/timesheets for Administrative staff adequately reflect the actual effort provided by each staff member to the SSVF grant or there is a work study to support amounts charged."]
["5)","Administrative Review Final Result:",{"$f":"IF(AND($D$9=\"Yes\",C156=\"Yes\",C158=\"Yes\", C157=\"Yes\", C159=\"Yes\"),\"PASS\",IF(AND($D$9=\"Yes\",C156=\"N/A\",C158=\"N/A\", C157=\"Yes\", C159=\"Yes\"),\"PASS\",IF($D$9=\"No\",\"N/A\",\"FAIL\")))","v":"N/A"}]
[]
["SECTION D:  SUBCONTRACTOR EXPENDITURES"]
[null,"Review subcontractor expenditures and supporting documentation including activity/time sheets.  Subcontractor should be providing services consistent with signed MOU and Resolution document provided by SSVF Program Office."]
[]
[null,"Does the Grantee have subcontractors?","No"]
[]
[null,"Overall Findings:",null,"Notes:"]
[null,"Subcontractor expenditures are consistent with SSVF Final Budget and do not exceed budgeted amounts for subcontractors."]
[null,"All subcontractor expenses are supported by clear invoices for each request made."]
[null,"Payroll documents/Timesheets adequately reflect the actual effort provided by each staff member to the SSVF grant (i.e. timesheets, etc.)"]
[null,"Subcontractor expenditures are submitted to the grantee and are reviewed and signed-off by an authorized official."]
[null,"Subcontractor admin costs are broken down with invoices to support admin costs paid."]
["6)","Subcontractor Review Final Result:",{"$f":"IF(AND(C165=\"No\",$D$9=\"Yes\"),\"PASS\",IF(AND($D$9=\"Yes\",C168=\"Yes\",C170=\"Yes\",C171=\"Yes\", C169=\"Yes\",C172=\"Yes\"),\"PASS\",IF($D$9=\"No\",\"NA\",\"FAIL\")))","v":"NA"}]
[]
["7)","FINAL RESULT FOR SG Supplement:",{"$f":"IF(AND($D$9=\"Yes\",$C$120=\"PASS\",$C$140=\"PASS\",$C$150=\"PASS\",$C$160=\"PASS\",$C$173=\"PASS\"),\"PASS\",IF($D$9=\"No\",\"N/A\",\"FAIL\"))","v":"N/A"}]
[]
[null,"Overall Remarks:"]

{"sheet":"Exhibit I Scores","index":12,"n_rows":108,"n_cols":9,"rows_kept":108,"cut":false,"hidden":false,"merged":[[102,6,106,6],[92,3,92,4],[13,3,13,4],[84,6,89,6],[81,3,81,4],[85,3,85,4],[94,6,98,6],[68,6,78,6],[81,6,82,6],[8,7,12,7],[28,3,28,4],[42,3,42,4],[55,3,55,4],[67,3,67,4],[8,6,12,6],[14,6,26,6],[30,6,34,6],[37,6,41,6],[43,6,55,6],[56,6,66,6],[36,3,36,4]]}
[null,null,null,null,null,"PROGRAM NUMBER:",null,null,{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[null,null,null,null,"Repeat Findings",{"$f":"'Exhibit I Coverpage'!D21","v":0}]
[]
[]
[null,null,null,"Exhibit 1:   Sections A thru H:"]
[null,null,null,"Section","Item Number","Item Fulfilled (1=Yes, 0=No)","Total Scores Possible","% Score"]
[null,null,null,"A",1,{"$f":"Checkbox_Scoring!$H$6","v":0}]
[null,null,null,"A",2,{"$f":"Checkbox_Scoring!$H$7","v":0}]
[null,null,null,"A",3,{"$f":"Checkbox_Scoring!$H$8","v":0}]
[null,null,null,"A","4a",{"$f":"Checkbox_Scoring!$H$9","v":0}]
[null,null,null,"A","4b",{"$f":"Checkbox_Scoring!$H$10","v":0}]
[null,null,null,"Section A Score:",null,{"$f":"SUM(F9:F13)","v":0},5,{"$f":"F14/G14","v":0}]
[null,null,null,"B",1,{"$f":"Checkbox_Scoring!$H$11","v":0}]
[null,null,null,"B",2,{"$f":"Checkbox_Scoring!$H$12","v":0}]
[null,null,null,"B",3,{"$f":"Checkbox_Scoring!$H$13","v":0}]
[null,null,null,"B",4,{"$f":"Checkbox_Scoring!$H$14","v":0}]
[null,null,null,"B",5,{"$f":"Checkbox_Scoring!$H$15","v":0}]
[null,null,null,"B",6,{"$f":"Checkbox_Scoring!$H$16","v":0}]
[null,null,null,"B",7,{"$f":"Checkbox_Scoring!$H$17","v":0}]
[null,null,null,"B",8,{"$f":"Checkbox_Scoring!$H$18","v":0}]
[null,null,null,"B",9,{"$f":"Checkbox_Scoring!$H$19","v":0}]
[null,null,null,"B",10,{"$f":"Checkbox_Scoring!$H$20","v":0}]
[null,null,null,"B",11,{"$f":"Checkbox_Scoring!$H$21","v":0}]
[null,null,null,"B",12,{"$f":"Checkbox_Scoring!$H$22","v":0}]
[null,null,null,"B",13,{"$f":"Checkbox_Scoring!$H$23","v":0}]
[null,null,null,"B",14,{"$f":"Checkbox_Scoring!$H$24","v":0}]
[null,null,null,"Section B Score:",null,{"$f":"SUM(F15:F28)","v":0},13,{"$f":"F29/G29","v":0}]
[null,null,null,"C","1a",{"$f":"'Section C'!$H$9","v":"No"}]
[null,null,null,"C",1,{"$f":"Checkbox_Scoring!$H$26","v":1}]
[null,null,null,"C",2,{"$f":"Checkbox_Scoring!$H$27","v":1}]
[null,null,null,"C",3,{"$f":"Checkbox_Scoring!$H$28","v":1}]
[null,null,null,"C",4,{"$f":"Checkbox_Scoring!$H$29","v":1}]
[null,null,null,"C",5,{"$f":"Checkbox_Scoring!$H$30","v":1}]
[null,null,null,"C",6,{"$f":"Checkbox_Scoring!$H$31","v":1},5,{"$f":"#REF!/G36","v":{"$error":"#REF!"}}]
[null,null,null,"Section C Score:",null,{"$f":"SUM(F31:F36)","v":6}]
[null,null,null,"D",1,{"$f":"Checkbox_Scoring!$H$32","v":0}]
[null,null,null,"D",2,{"$f":"Checkbox_Scoring!$H$33","v":0}]
[null,null,null,"D",3,{"$f":"Checkbox_Scoring!$H$34","v":0}]
[null,null,null,"D",4,{"$f":"Checkbox_Scoring!$H$35","v":0}]
[null,null,null,"D",5,{"$f":"Checkbox_Scoring!$H$36","v":0}]
[null,null,null,"Section D Score:",null,{"$f":"SUM(F38:F42)","v":0},5,{"$f":"F43/G43","v":0}]
[null,null,null,"E",1,{"$f":"Checkbox_Scoring!$H$37","v":0}]
[null,null,null,"E",2,{"$f":"Checkbox_Scoring!$H$38","v":0}]
[null,null,null,"E",3,{"$f":"Checkbox_Scoring!$H$39","v":0}]
[null,null,null,"E",4,{"$f":"Checkbox_Scoring!$H$40","v":0}]
[null,null,null,"E",5,{"$f":"Checkbox_Scoring!$H$41","v":1}]
[null,null,null,"E",6,{"$f":"Checkbox_Scoring!$H$42","v":1}]
[null,null,null,"E",7,{"$f":"Checkbox_Scoring!$H$43","v":0}]
[null,null,null,"E",8,{"$f":"Checkbox_Scoring!$H$44","v":0}]
[null,null,null,"E",9,{"$f":"Checkbox_Scoring!$H$45","v":0}]
[null,null,null,"E",10,{"$f":"Checkbox_Scoring!$H$46","v":0}]
[null,null,null,"E",11,{"$f":"Checkbox_Scoring!$H$47","v":0}]
[null,null,null,"E",12,{"$f":"Checkbox_Scoring!$H$48","v":0}]
[null,null,null,"Section E Score:",null,{"$f":"SUM(F44:F55)","v":2}]
[null,null,null,"F",1,{"$f":"Checkbox_Scoring!$H$49","v":0}]
[null,null,null,"F",2,{"$f":"Checkbox_Scoring!$H$50","v":0}]
[null,null,null,"F",3,{"$f":"Checkbox_Scoring!$H$51","v":0}]
[null,null,null,"F",4,{"$f":"Checkbox_Scoring!$H$52","v":0}]
[null,null,null,"F",5,{"$f":"Checkbox_Scoring!$H$53","v":0}]
[null,null,null,"F",6,{"$f":"Checkbox_Scoring!$H$54","v":0}]
[null,null,null,"F",7,{"$f":"Checkbox_Scoring!$H$55","v":0}]
[null,null,null,"F",8,{"$f":"Checkbox_Scoring!$H$56","v":0}]
[null,null,null,"F",9,{"$f":"Checkbox_Scoring!$H$57","v":0}]
[null,null,null,"F",10,{"$f":"Checkbox_Scoring!$H$58","v":0}]
[null,null,null,"F",11,{"$f":"Checkbox_Scoring!$H$59","v":0}]
[null,null,null,"Section F Score:",null,{"$f":"SUM(F57:F67)","v":0},11,{"$f":"F68/G68","v":0}]
[null,null,null,"G",1,{"$f":"Checkbox_Scoring!$H$60","v":0}]
[null,null,null,"G",2,{"$f":"Checkbox_Scoring!$H$61","v":0}]
[null,null,null,"G",3,{"$f":"Checkbox_Scoring!$H$62","v":0}]
[null,null,null,"G",4,{"$f":"Checkbox_Scoring!$H$63","v":0}]
[null,null,null,"G",5,{"$f":"Checkbox_Scoring!$H$64","v":0}]
[null,null,null,"G",6,{"$f":"Checkbox_Scoring!$H$65","v":0}]
[null,null,null,"G",7,{"$f":"Checkbox_Scoring!$H$66","v":0}]
[null,null,null,"G",8,{"$f":"Checkbox_Scoring!$H$67","v":0}]
[null,null,null,"G",9,{"$f":"Checkbox_Scoring!$H$68","v":0}]
[null,null,null,"G",10,{"$f":"Checkbox_Scoring!$H$69","v":0}]
[null,null,null,"G",11,{"$f":"Checkbox_Scoring!$H$70","v":0}]
[null,null,null,"G",12,{"$f":"Checkbox_Scoring!$H$71","v":1},12,{"$f":"F82/G80","v":8.3333333333333329E-2}]
[null,null,null,"G",13,{"$f":"Checkbox_Scoring!$H$72","v":0}]
[null,null,null,"Section G Score:",null,{"$f":"SUM(F69:F81)","v":1}]
[null,null,null,"H",1,{"$f":"'Section H'!$H$9","v":"No"}]
[null,null,null,"H",2,{"$f":"Checkbox_Scoring!$H$74","v":1},2,{"$f":"F86/G84","v":1}]
[null,null,null,"H",3,{"$f":"Checkbox_Scoring!$H$75","v":1}]
[null,null,null,"Section H Score:",null,{"$f":"F85+F84","v":2}]
[null,null,null,"I",1,{"$f":"Checkbox_Scoring!$H$76","v":0}]
[null,null,null,"I",2,{"$f":"Checkbox_Scoring!$H$77","v":0}]
[null,null,null,"I",3,{"$f":"Checkbox_Scoring!$H$78","v":0}]
[null,null,null,"I",4,{"$f":"Checkbox_Scoring!$H$79","v":0}]
[null,null,null,"I",5,{"$f":"Checkbox_Scoring!$H$80","v":0},6,{"$f":"F93/G91","v":0}]
[null,null,null,"I",6,{"$f":"Checkbox_Scoring!$H$81","v":0}]
[null,null,null,"Section I Score:",null,{"$f":"SUM(F87:F92)","v":0}]
[]
[null,null,null,"Part B:   Section G Supplement (if applicable):"]
[null,null,null,"Section","Item Number","Item Fulfilled (1=Yes, 0=No)"]
[null,null,null,"G_S",2,{"$f":"IF(Checkbox_Scoring!$G$82=\"No\",\"N/A\",Checkbox_Scoring!H83)","v":"N/A"}]
[null,null,null,"G_S",3,{"$f":"IF(Checkbox_Scoring!$G$82=\"No\",\"N/A\",Checkbox_Scoring!H84)","v":"N/A"}]
[null,null,null,"G_S",4,{"$f":"IF(Checkbox_Scoring!$G$82=\"No\",\"N/A\",Checkbox_Scoring!H85)","v":"N/A"}]
[null,null,null,"G_S",5,{"$f":"IF(Checkbox_Scoring!$G$82=\"No\",\"N/A\",Checkbox_Scoring!H86)","v":"N/A"}]
[null,null,null,"G_S",6,{"$f":"IF(Checkbox_Scoring!$G$82=\"No\",\"N/A\",Checkbox_Scoring!H87)","v":"N/A"}]
[]
[null,null,null,"Part C:  Subcontractor Supplement (if applicable):"]
[null,null,null,"Section","Item Number","Item Fulfilled (1=Yes, 0=No)"]
[null,null,null,"Sub",2,{"$f":"IF(Checkbox_Scoring!$G$89=\"No\",\"N/A\",Checkbox_Scoring!H90)","v":"N/A"}]
[null,null,null,"Sub",3,{"$f":"IF(Checkbox_Scoring!$G$89=\"No\",\"N/A\",Checkbox_Scoring!H91)","v":"N/A"}]
[null,null,null,"Sub",4,{"$f":"IF(Checkbox_Scoring!$G$89=\"No\",\"N/A\",Checkbox_Scoring!H92)","v":"N/A"}]
[null,null,null,"Sub",5,{"$f":"IF(Checkbox_Scoring!$G$89=\"No\",\"N/A\",Checkbox_Scoring!H93)","v":"N/A"}]

{"sheet":"Exhibit I Exit Summary","index":13,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[16,1,16,7],[7,1,7,8],[9,1,9,7],[12,1,12,7],[15,1,15,7],[10,1,10,7],[13,1,13,7]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,null,null,null,"Supportive Services for Veteran Families (SSVF)"]
[null,null,null,null,"Uniform Monitoring Package (UMP)"]
[]
[null,"Exhibit 1:  Exit Summary"]
[]
[null,"1. Names and Titles of Reviewer(s) Participating in Exit Conference: "]
[]
[]
[null,"2. Names and Titles of Grantee Staff in Attendance:"]
[]
[]
[null,"3. Discussion (Highlights, including areas of disagreement, if any):"]

{"sheet":"DropDown","index":14,"n_rows":302,"n_cols":3,"rows_kept":302,"cut":false,"hidden":true,"merged":[]}
["Yes",null,"On Site"]
["No",null,"Remote"]
[]
["Yes"]
["No"]
["N/A"]
[]
["Award Amt","Grantee ID List","Grantee Name List"]
[null,"12-AK-001","Access"]
[null,"12-AL-002","Action Ministries, Inc."]
[null,"12-AZ-003","Advocate Program, Inc."]
[null,"12-AZ-004","Albany Housing Coalition, Inc."]
[null,"12-CA-007","Alger Marquette Community Action Board"]
[null,"12-CA-010","Alliance, Inc"]
[null,"12-CA-013","American GI Forum National Veterans Outreach Program, Inc."]
[null,"12-CA-014","American National Red Cross Southern Arizona Chapter"]
[null,"12-CA-015","Asheville-Buncombe Community Christian Ministry, Inc."]
[null,"12-CA-016","Berkeley Food and Housing Project"]
[null,"12-CA-017","Big Bend Homeless Coalition, Inc."]
[null,"12-CA-018","Blue Mountain Action Council"]
[null,"12-CT-021","Blue Valley Community Action, Inc."]
[null,"12-FL-024","Blue Water Center For Independent Living, Inc."]
[null,"12-FL-025","California Veterans Assistance Foundation, Inc."]
[null,"12-FL-028","Career And Recovery Resources Inc"]
[null,"12-GA-029","Caritas of Austin"]
[null,"12-ID-032","Carrillo Counseling Services, Inc. (DBA New Beginnings)"]
[null,"12-IL-033","Casa del Peregrino Aguadilla, Inc."]
[null,"12-IN-035","Catholic Charities Community Services, Inc."]
[null,"12-LA-038","Catholic Charities Diocese of Fort Worth, Inc."]
[null,"12-LA-039","Catholic Charities Dioceses of Camden, Inc."]
[null,"12-MA-040","Catholic Charities Hawaii"]
[null,"12-MD-042","Catholic Charities of Kansas City - St Joseph, Inc."]
[null,"12-ME-043","Catholic Charities of Southern Missouri, Inc."]
[null,"12-MI-044","Catholic Charities of the Archdiocese of Chicago"]
[null,"12-MI-045","Catholic Charities of the Diocese of Allentown"]
[null,"12-NC-049","Catholic Charities of the Diocese of Stockton"]
[null,"12-NC-050","Catholic Charities of the Roman Catholic Diocese of Syracuse NY"]
[null,"12-ND-051","Catholic Charities, Inc. (dba Catholic Charities of the Diocese of Memphis, Inc.)"]
[null,"12-NJ-053","Catholic Charities, Inc. (Diocese of Jackson)"]
[null,"12-NM-055","Catholic Charities, Inc. (Diocese of Wichita)"]
[null,"12-NY-060","Catholic Community Services of Western Washington"]
[null,"12-NY-061","Catholic Family and Community Service"]
[null,"12-NY-063","Catholic Social Services"]
[null,"12-OH-064","Center For Veterans Issues Limited"]
[null,"12-OK-065","Centerstone of Tennessee, Inc."]
[null,"12-PA-067","Central Nebraska Community Services, Inc."]
[null,"12-TX-071","Central Oregon Veteran's Outreach"]
[null,"12-TX-072","Central Savannah River Area Economic Opportunity Authority, Inc. (CSRA EOA)"]
[null,"12-TX-075","Changing Homelessness, Inc."]
[null,"12-TX-076","Chautauqua Opportunities, Inc."]
[null,"12-VA-077","Chestnut Health Systems, Inc."]
[null,"12-WA-079","Columbus House, Inc."]
[null,"12-ZZ-026","Commission on Economic Opportunity"]
[null,"12-ZZ-031","Community Action Agency"]
[null,"12-ZZ-041","Community Action Agency of Columbiana County, Inc."]
[null,"12-ZZ-070","Community Action Agency of Delaware County, Inc."]
[null,"13-AZ-087","Community Action Coalition for South Central Wisconsin, Inc."]
[null,"13-CA-090","Community Action of Northeast Indiana, Inc. "]
[null,"13-CT-093","Community Action Partnership of North Dakota"]
[null,"13-DE-095","Community Action Partnership of Oregon"]
[null,"13-FL-096","Community Action Partnership Of San Luis Obispo County, Inc."]
[null,"13-GA-101","Community Action Program Corporation of Washington-Morgan Counties, Ohio"]
[null,"13-GA-102","Community Action Team, Inc."]
[null,"13-IA-103","Community Bridges, Inc."]
[null,"13-IL-104","Community Catalysts of California"]
[null,"13-IL-105","Community Coalition on Homelessness Corporation"]
[null,"13-IN-106","Community Hope, Inc."]
[null,"13-MD-107","Community Link Programs of Travelers Aid Society of Central Carolinas, Inc."]
[null,"13-MI-108","Community Psychiatric Clinic, Inc."]
[null,"13-MO-047","Community Rebuilders"]
[null,"13-MO-110","Community Renewal Team, Inc."]
[null,"13-MS-111","Community Service Council of Greater Tulsa, Inc."]
[null,"13-NC-114","Community Support Services, Inc."]
[null,"13-NH-115","Connections Community Support Programs, Inc."]
[null,"13-NV-056","Cornerstone Rescue Mission"]
[null,"13-NV-117","Decatur Cooperative Ministry, Inc."]
[null,"13-NV-118","Denver Options, Inc. (dba Rocky Mountain Human Services)"]
[null,"13-NY-119","Diakonia, Inc."]
[null,"13-NY-121","East Oakland Community Project"]
[null,"13-OH-124","Easter Seals Oregon"]
[null,"13-OR-125","Eastern Carolina Homelessness Organization, Inc."]
[null,"13-OR-126","Economic Opportunity Council of Suffolk, Inc."]
[null,"13-OR-128","El-Ada, Inc."]
[null,"13-PA-129","Elle Foundation"]
[null,"13-PA-130","Fairbanks Rescue Mission, Inc."]
[null,"13-SD-136","Faith Mission, Inc."]
[null,"13-TN-139","Faith, Hope, Love, Charity, Inc."]
[null,"13-TX-140","Families in Crisis, Inc."]
[null,"13-VA-144","Family & Community Services, Inc."]
[null,"13­WA-148","Family Alliance For Veterans of America, Inc."]
[null,"13-WI-151","Family Endeavors, Inc."]
[null,"13-ZZ-092","Featherfist, Inc."]
[null,"13-ZZ-123","Friendship Place"]
[null,"13-ZZ-133","Front Steps, Inc."]
[null,"13-ZZ-134","Good Samaritan Shelter"]
[null,"13-ZZ-145","Goodwill Industries of Central Oklahoma, Inc."]
[null,"13-ZZ-147","Goodwill Industries of New Mexico"]
[null,"14-AK-152","Goodwill Industries of Silicon Valley  (dba Goodwill Industries of Santa Clara County)"]
[null,"14-AL-155","Goodwill Industries of The Inland Northwest"]
[null,"14-AZ-157","Hampton Roads Community Action Program, Inc."]
[null,"14-AZ-158","Hancock Resource Center (HRC)"]
[null,"14-AZ-159","Harbor Homes, Inc."]
[null,"14-AZ-160","Hawkeye Area Community Action Program, Inc."]
[null,"14-CA-163","Heartland Human Care Services, Inc."]
[null,"14-CA-167","HELP Social Service Corporation"]
[null,"14-CA-169","Helping Heroes, Inc."]
[null,"14-CA-170","Homefirst Services Of Santa Clara County"]
[null,"14-CA-177","Homeless Services Center"]
[null,"14-CT-178","Homeless Services Network of Central Florida, Inc."]
[null,"14-FL-179","Homeless Veterans Fellowship"]
[null,"14-FL-181","Homeward Bound of Western North Carolina, Inc."]
[null,"14-FL-182","Hope Center, Inc."]
[null,"14-FL-184","HopeSource"]
[null,"14-FL-185","Housing Counseling Services, Inc."]
[null,"14-FL-322","Housing First, Inc."]
[null,"14-GA-188","Humility of Mary Shelter, Inc."]
[null,"14-GA-189","Indianhead Community Action Agency"]
[null,"14-IA-191","InteCare, Inc."]
[null,"14-ID-193","Jewish Family & Childrens Service Of The Suncoast Inc"]
[null,"14-IL-194","Kentucky River Foothills Development Council, Inc."]
[null,"14-IL-195","KI BOIS Community Action Foundation, Inc."]
[null,"14-IL-196","Knowledge, Education for Your Success, Inc."]
[null,"14-IL-197","Lafayette Transitional Housing Center, Inc."]
[null,"14-IL-198","Lawrence County Social Services, Inc."]
[null,"14-IL-308","Licking County Coalition for Housing"]
[null,"14-IN-199","Lifemoves"]
[null,"14-IN-200","Lighthouse Treatment Center"]
[null,"14-KS-322","Lubbock Mental Health and Retardation Center (dba Starcare)"]
[null,"14-KY-204","Lutheran Social Services of Central Ohio"]
[null,"14-LA-205","Maumee Valley Guidance Center, Inc."]
[null,"14-LA-207","Memphis Area Legal Services, Inc."]
[null,"14-LA-208","Mental Health America of Los Angeles"]
[null,"14-MA-209","Mental Health Services for Homeless Persons, Inc. (dba FrontLine Service)"]
[null,"14-MA-211","Meridian Behavioral Healthcare, Inc."]
[null,"14-MD-214","Mesilla Valley Community of Hope"]
[null,"14-MD-215","Metropolitan Development Council"]
[null,"14-MD-216","Mid Michigan Community Action Agency, Inc."]
[null,"14-MD-217","Midwest Shelter for Homeless Veterans, Inc."]
[null,"14-MI-218","Minnesota Assistance Council for Veterans"]
[null,"14-MI-219","Mississippi United to End Homelessness, Inc."]
[null,"14-MI-220","National Community Health Partners"]
[null,"14-MI-221","Neighborhood Centers, Inc."]
[null,"14-MI-222","New Directions, Inc."]
[null,"14-MI-223","New Mexico Veterans Integration Centers"]
[null,"14-MI-226","New Vision House of Hope, Inc."]
[null,"14-MN-227","Northeast Nebraska Community Action Partnership"]
[null,"14-MO-228","Northwest Florida Comprehensive Services For Children, Inc."]
[null,"14-MO-229","Northwest Michigan Community Action Agency, Inc."]
[null,"14-MS-231","Oakland Livingston Human Services Agency"]
[null,"14-MS-232","Ohio Valley Goodwill Industries Rehabilitation Center, Inc."]
[null,"14-MS-233","One-Eighty Place "]
[null,"14-MS-234","Operation Renewed Hope"]
[null,"14-NC-236","Operation Stand Down Rhode Island"]
[null,"14-NE-238","Operation Stand Down Tennessee"]
[null,"14-NH-240","Opportunity Council"]
[null,"14-NJ-242","Opportunity House"]
[null,"14-NM-246","Partners in Community Building, Inc."]
[null,"14-NM-247","Passage Home, Inc."]
[null,"14-NY-249","Pathstone Corporation"]
[null,"14-NY-250","People Assisting the Homeless"]
[null,"14-NY-251","Phoenix Programs, Inc."]
[null,"14-NY-253","Preble Street"]
[null,"14-NY-254","Primary Health Care, Inc."]
[null,"14-NY-256","Primavera Foundation"]
[null,"14-NY-259","Project Community Connections, Inc."]
[null,"14-OH-261","Project H.O.M.E."]
[null,"14-OH-262","Project PLASE, Inc."]
[null,"14-OH-264","Purpose Built Families Foundation"]
[null,"14-OH-265","Region 12 Commission On Mental Health & Retardation (Pine Belt Mental Health)"]
[null,"14-OH-266","ReStart, Inc."]
[null,"14-OH-267","Sabine Valley Regional Mental Health Mental Retardation Center"]
[null,"14-OH-268","Samaritan Daytop Village, Inc."]
[null,"14-OH-269","Saratoga County Rural Preservation Company, Inc."]
[null,"14-OK-270","Services for the UnderServed, Inc."]
[null,"14-OK-271","Shelter, Inc. of Contra Costa County"]
[null,"14-OR-272","Society of St. Vincent de Paul, South Pinellas, Inc."]
[null,"14-PA-273","Soldier On of Delaware, Inc."]
[null,"14-PA-274","Soldier On, Inc."]
[null,"14-PA-276","South Central Community Action Partnership, Inc."]
[null,"14-PA-277","Southwest Counseling Solutions"]
[null,"14-PA-279","Southwestern Community Services, Inc."]
[null,"14-PA-280","St. Francis House, Inc."]
[null,"14-PA-281","St. James A.M.E. Zion Church-Zion House"]
[null,"14-PA-282","St. Patrick Center"]
[null,"14-TN-283","St. Vincent de Paul Social Services, Inc."]
[null,"14-TN-284","St. Vincent de Paul Society of Lane County, Inc."]
[null,"14-TN-285","Start Corporation"]
[null,"14-TN-287","STOP Incorporated"]
[null,"14-TX-288","Sunnyvale Community Services"]
[null,"14-TX-290","Swords To Plowshares Veterans Rights Organization"]
[null,"14-TX-293","Talbert House, Inc."]
[null,"14-VA-294","Tampa Crossroads, Inc."]
[null,"14-VA-296","The Alston Wilkes Society (AWS, Alston Wilkes Veterans Home)"]
[null,"14-VA-297","The Greater Wheeling Coalition for the Homeless, Inc."]
[null,"14-VA-298","The Jericho Project"]
[null,"14-VI-299","The Kitchen, Inc."]
[null,"14-WI-302","The Methodist Training and Outreach Center, Inc."]
[null,"14-WV-303","The Road Home"]
[null,"14-WV-304","The Salvation Army"]
[null,"14-WV-305","The Salvation Army, a California Corporation"]
[null,"14-ZZ-153","The Salvation Army, a Georgia Corporation"]
[null,"14-ZZ-260","The Salvation Army, a New York Corporation"]
[null,"14-ZZ-301","The Salvation Army, an Illinois Corporation"]
[null,"14-ZZ-313","The Workplace, Inc."]
[null,"14-ZZ-314","Three Oaks Homeless Shelter, Inc."]
[null,"14-ZZ-317","Thresholds"]
[null,"14-ZZ-318","Total Action Against Poverty In Roanoke Valley"]
[null,"15-GA-325","Training & Treatment Innovations, Inc."]
[null,"15-GU-326","Transition Projects, Inc."]
[null,"15-IA-192","Transitional Living Services, Inc."]
[null,"15-IN-201","Travelers Aid of Metropolitan Atlanta, Inc."]
[null,"15-MI-328","Treasure Coast Homeless Services Council, Inc."]
[null,"15-MO-330","Tri-County Action Program, Inc."]
[null,"15-OH-333","United Methodist Outreach Ministries"]
[null,"15-PA-068","United States Veterans Initiative"]
[null,"15-PA-334","United Way of Broward County"]
[null,"15-TX-141","United Way of Central Alabama"]
[null,"15-UT-336","United Way of Central Indiana, Inc."]
[null,"15-WA-338","United Way of Forsyth County, Inc."]
[null,"15-ZZ-127","United Way of Greater Atlanta, Inc."]
[null,"15-ZZ-340","University of Vermont and State Agricultural College"]
[null,"16-CA-005","Utica Center for Development, Inc."]
[null,"16-MO-048","Utility Emergency Services Fund"]
[null,"16-NJ-054","Veterans Leadership Program of Western Pennsylvania, Inc."]
[null,"16-ZZ-037","Veterans Multi-Service Center, Inc."]
[null,"16-ZZ-058","Veterans Northeast Outreach Center, Inc."]
[null,"16-ZZ-278","Veterans, Inc."]
[null,"17-NE-052","Vietnam Veterans of California, Inc. (Sacramento Veterans Resource)"]
[null,"18-AR-086","Vietnam Veterans of San Diego"]
[null,"18-AZ-436","Vietnam Veterans Workshop, Inc."]
[null,"18-CA-006 ","Virginia Beach Community Development Corporation"]
[null,"18-CA-008","Virginia Supportive Housing"]
[null,"18-CA-009 ","Volunteer Behavioral Health Care System"]
[null,"18-CA-011","Volunteers of America Chesapeake"]
[null,"18-CA-019","Volunteers of America Colorado Branch, Inc."]
[null,"18-CA-091","Volunteers of America Michigan, Inc."]
[null,"18-CA-171","Volunteers of America Mid-States, Inc."]
[null,"18-CA-173 ","Volunteers of America Northern Rockies"]
[null,"18-CA-176","Volunteers of America of Florida, Inc."]
[null,"18-CA-344","Volunteers of America of Greater New Orleans"]
[null,"18-CA-354","Volunteers of America of Greater Ohio"]
[null,"18-CA-358","Volunteers of America of Greater Sacramento and Northern Nevada, Inc."]
[null,"18-CA-359","Volunteers of America of Illinois"]
[null,"18-CA-412","Volunteers of America of Indiana, Inc."]
[null,"18-CA-414","Volunteers of America of Los Angeles, Inc."]
[null,"18-CA-419","Volunteers of America of Massachusetts, Inc."]
[null,"18-CA-420","Volunteers of America of Pennsylvania, Inc."]
[null,"18-CA-437","Volunteers of America of the Carolinas, Inc."]
[null,"18-CO-360","Volunteers of America Southeast, Inc."]
[null,"18-CO-439","Volunteers of America Southwest California, Inc."]
[null,"18-FL-023 ","Volunteers of America-Greater New York, Inc."]
[null,"18-FL-099","Wayne Metropolitan Community Action Agency"]
[null,"18-FL-187 ","Welcome Home, Inc."]
[null,"18-FL-362","Wellspring Alliance for Families, Inc."]
[null,"18-FL-364","West Central Texas Regional Foundation"]
[null,"18-FL-368","West Tennessee Legal Services, Inc."]
[null,"18-GA-369","West Virginia Community Action Partnerships Inc"]
[null,"18-GA-370","WestCare California, Inc."]
[null,"18-GA-438","WestCare Pacific Islands, Inc."]
[null,"18-HI-190","Westchester Community Opportunity Program, Inc. (WestCOP)"]
[null,"18-HI-374","YWCA of Greater Harrisburg"]
[null,"18-KY-379","YWCA of Seattle - King County - Snohomish County"]
[null,"18-MI-383"]
[null,"18-MN-046 "]
[null,"18-NC-235"]
[null,"18-NC-237"]
[null,"18-NC-387"]
[null,"18-NE-239"]
[null,"18-NY-062 "]
[null,"18-OH-263"]
[null,"18-OH-396"]
[null,"18-OH-397"]
[null,"18-OR-066 "]
[null,"18-OR-399"]
[null,"18-OR-430"]
[null,"18-PR-132"]
[null,"18-SC-069 "]
[null,"18-SC-402"]
[null,"18-TN-403"]
[null,"18-TX-074"]
[null,"18-TX-292"]
[null,"18-TX-404"]
[null,"18-TX-433"]
[null,"18-WA-078"]
[null,"18-WA-146"]
[null,"18-WA-300 "]
[null,"18-WA-408"]
[null,"18-WI-080"]
[null,"18-WI-411"]
[null,"18-ZZ-020 "]
[null,"18-ZZ-034"]
[null,"18-ZZ-036"]
[null,"18-ZZ-094 "]
[null,"18-ZZ-113 "]
[null,"18-ZZ-324 "]
[null,"18-ZZ-386"]
[null,"C2015-CA-600C"]
[null,"C2015-CA-600E"]
[null,"C2015-NV-500D"]
[null,"C2015-NV-500E"]
[null,"C2015-OR-502B"]
[null,"C2015-WA-501E"]

{"sheet":"Exhibit_II","index":15,"n_rows":214,"n_cols":9,"rows_kept":214,"cut":false,"hidden":false,"merged":[[214,2,214,10],[206,1,206,10],[207,1,208,10],[209,1,209,10],[210,4,210,5],[211,4,211,5],[212,4,212,5],[213,4,213,5],[119,2,119,10],[199,4,199,5],[200,4,200,5],[201,4,201,5],[173,2,173,10],[174,2,174,10],[197,4,197,5],[198,4,198,5],[161,2,161,10],[162,2,162,10],[179,1,179,10],[180,1,181,10],[187,1,187,10],[183,2,183,10],[184,2,184,10],[185,2,185,10],[84,1,84,10],[86,1,86,10],[87,1,88,10],[101,1,101,10],[102,1,103,10],[104,1,104,10],[140,1,140,10],[142,1,142,10],[144,1,144,10],[132,2,132,10],[133,2,133,10],[134,2,134,10],[135,2,135,10],[136,2,136,10],[137,2,137,10],[138,2,138,10],[130,2,130,10],[127,2,127,10],[128,2,128,10],[129,2,129,10],[113,2,113,10],[114,2,114,10],[115,2,115,10],[110,2,110,10],[168,1,169,10],[141,2,141,10],[145,1,146,10],[156,2,156,10],[157,2,157,10],[67,1,67,10],[68,1,68,10],[70,1,70,10],[71,1,72,10],[73,1,73,10],[74,2,74,10],[76,2,76,10],[78,2,78,10],[81,2,81,10],[75,2,75,10],[82,2,82,10],[91,2,91,10],[97,2,97,10],[79,2,79,10],[80,2,80,10],[90,2,90,10],[93,2,93,10],[111,2,111,10],[131,1,131,10],[158,2,158,10],[159,2,159,10],[160,2,160,10],[148,2,148,10],[149,2,149,10],[150,2,150,10],[151,2,151,10],[155,2,155,10],[116,2,116,10],[117,2,117,10],[118,2,118,10],[152,2,152,10],[36,1,36,10],[39,2,39,10],[40,2,40,10],[112,1,112,10],[202,2,202,10],[203,1,203,10],[204,1,204,10],[139,2,139,10],[153,2,153,10],[175,1,175,10],[171,2,171,10],[164,1,164,10],[165,1,165,10],[163,2,163,10],[177,1,177,10],[193,1,193,10],[194,1,195,10],[196,1,196,10],[167,1,167,10],[176,1,176,10],[120,1,120,10],[121,1,121,10],[123,1,123,10],[124,1,125,10],[47,1,47,10],[48,1,49,10],[50,1,50,10],[55,1,55,10],[37,1,37,10],[44,1,44,10],[45,1,45,10],[42,2,42,10],[54,2,54,10],[38,2,38,10],[41,2,41,10],[33,1,34,10],[0,8,0,9],[7,1,7,8],[8,2,8,5],[8,8,8,9],[9,2,9,5],[9,8,9,9],[20,1,20,10],[21,1,23,10],[25,1,25,10],[26,1,30,10],[32,1,32,10],[10,2,10,5],[10,8,10,9],[14,1,14,10],[16,1,16,10],[17,1,18,10],[12,1,12,2],[61,2,61,10],[62,2,62,10],[63,2,63,10],[51,2,51,10],[52,2,52,10],[53,2,53,10],[56,2,56,10],[57,2,57,10],[58,2,58,10],[59,2,59,10],[60,2,60,10],[188,2,188,10],[189,2,189,10],[190,2,190,10],[64,2,64,10],[65,2,65,10],[66,2,66,10],[89,1,89,10],[92,1,92,10],[77,1,77,10],[83,1,83,10],[108,2,108,10],[109,2,109,10],[94,2,94,10],[95,2,95,10],[96,2,96,10],[105,2,105,10],[107,2,107,10],[98,1,98,10],[99,1,99,10],[106,2,106,10],[126,1,126,10],[172,1,172,10],[147,1,147,10],[154,1,154,10]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,null,null,null,null,"Supportive Services for Veteran Families (SSVF)"]
[null,null,null,null,null,"FY 2017 Uniform Monitoring Package (UMP)"]
[]
[]
[null,"Grantee Name:",{"$f":"'Exhibit I Coverpage'!$C$11","v":0},null,null,null,null,"Name(s) of Reviewer(s):",{"$f":"'Exhibit I Coverpage'!$C$16","v":0}]
[null,"Program Number:",{"$f":"'Exhibit I Coverpage'!$C$12","v":0},null,null,null,null,"Date of Visit:",{"$f":"'Exhibit I Coverpage'!$C$17","v":"00:00:00"}]
[null,"Award Amount:",{"$f":"'Exhibit I Coverpage'!$C$13","v":0},null,null,null,null,"On-Site or Remote:"]
[]
[null,"Repeat Findings Identified:",null,{"$f":"'Exhibit I Coverpage'!$D$21","v":0}]
[]
[null,"Exhibit II:  Grantee Monitoring Summary Report"]
[]
[null,"1. Names and Titles of Reviewer(s) Participating in Exit Conference: "]
[null,{"$f":"'Exhibit I Exit Summary'!$B$11","v":0}]
[]
[]
[null,"2. Names and Titles of Grantee Staff in Attendance:"]
[null,{"$f":"'Exhibit I Exit Summary'!$B$14","v":0}]
[]
[]
[]
[null,"3. Discussion (Highlights, including areas of disagreement, if any):"]
[null,{"$f":"'Exhibit I Exit Summary'!$B$17","v":0}]
[]
[]
[]
[]
[]
[null,"A.  Program Progress"]
[null,"This section is designed to ensure that activities are being carried out in a timely manner and that the number of participants served is consistent with the approved application."]
[]
[null,"Findings:","None for this section."]
[]
[null,"Concerns:"]
[null,"A1:",{"$f":"IF(Checkbox_Scoring!$H$6=0,Checkbox_Scoring!$I$6,\"None\")","v":"The number of participants served is not within 10% of the service number in the grant agreement."}]
[null,"A2:",{"$f":"IF(Checkbox_Scoring!$H$7=0,Checkbox_Scoring!$I$7,\"None\")","v":"The drawdown rate is not within 10% or less of the projected point in time expenditures."}]
[null,"A3:",{"$f":"IF(Checkbox_Scoring!$H$8=0,Checkbox_Scoring!$I$8,\"None\")","v":"The staffing level is not consistent with the grant agreement."}]
[null,"A4a",{"$f":"IF(Checkbox_Scoring!$H$9=0,Checkbox_Scoring!$I$9,\"None\")","v":"The grantee is not within the 60% TFA spending for Rapid Re-Housing."}]
[null,"A4b:",{"$f":"IF(Checkbox_Scoring!$H$10=0,Checkbox_Scoring!$I$10,\"None\")","v":"The grantee is not within the 40% TFA spending for Rapid Re-Housing."}]
[]
[null,"Recommendations:"]
[]
[]
[null,"B.   Overall Management Systems/Structure"]
[null,"This section is designed to assess grantee’s overall managements system and structure in relation to ensure compliance with program requirements and achievement of program goals."]
[]
[null,"Findings:"]
[null,"B5:",{"$f":"IF(Checkbox_Scoring!$H$15=0,Checkbox_Scoring!$I$15,\"None\")","v":"The grantee does not register all program participants for the VA required Consumer Survey."}]
[null,"B8:",{"$f":"IF(Checkbox_Scoring!$H$18=0,Checkbox_Scoring!$I$18,\"None\")","v":"The grantee does not have clear procedures for reporting and following-up on critical incidents."}]
[null,"B12:",{"$f":"IF(Checkbox_Scoring!$H$22=0,Checkbox_Scoring!$I$22,\"None\")","v":"The grantee does not have a clear practice in place for landlord recruitment and retainment for identifying new landlords, and providng support to landlords and tenants after move in ."}]
[]
[null,"Concerns:"]
[null,"B1:",{"$f":"IF(Checkbox_Scoring!$H$11=0,Checkbox_Scoring!$I$11,\"None\")","v":"The grantee does not have written policies/procedures that describe how screening will be conducted."}]
[null,"B2:",{"$f":"IF(Checkbox_Scoring!$H$12=0,Checkbox_Scoring!$I$12,\"None\")","v":"The grantee does not have written policies/procedures that describe how program eligibility will be determined."}]
[null,"B3:",{"$f":"IF(Checkbox_Scoring!$H$13=0,Checkbox_Scoring!$I$13,\"None\")","v":"The grantee does not have written policies/procedures that describe how admissions are prioritized and who is responsible for making admission decisions."}]
[null,"B4:",{"$f":"IF(Checkbox_Scoring!$H$14=0,Checkbox_Scoring!$I$14,\"None\")","v":"The grantee does not have written policies/procedures describing ineligibility criteria."}]
[null,"B6:",{"$f":"IF(Checkbox_Scoring!$H$16=0,Checkbox_Scoring!$I$16,\"None\")","v":"The grantee does not obtain input from program participants from VA Consumer Survey or other internal surveys."}]
[null,"B7:",{"$f":"IF(Checkbox_Scoring!$H$17=0,Checkbox_Scoring!$I$17,\"None\")","v":"The grantee does not work to end Veteran homelessness in conjunction with their Continuum(s) of Care (CoC) listed on their FY17 Resolution."}]
[null,"B9:",{"$f":"IF(Checkbox_Scoring!$H$19=0,Checkbox_Scoring!$I$19,\"None\")","v":"The grantee does not have procedures for providing and documenting supervision of personnel delivering services to participants."}]
[null,"B10:",{"$f":"IF(Checkbox_Scoring!$H$20=0,Checkbox_Scoring!$I$20,\"None\")","v":"The grantee does not have position descriptions for all staff listed on the approved budget."}]
[null,"B11:",{"$f":"IF(Checkbox_Scoring!$H$21=0,Checkbox_Scoring!$I$21,\"None\")","v":"The grantee does not have signed conflict of interest statements for their board of directors or other governing body."}]
[null,"B13:",{"$f":"IF(Checkbox_Scoring!$H$23=0,Checkbox_Scoring!$I$23,\"None\")","v":"The grantee does not ensure that confidential information is secure and protected."}]
[null,"B14:",{"$f":"IF(Checkbox_Scoring!$H$24=0,Checkbox_Scoring!$I$24,\"None\")","v":"The grantee does not ensure that all SSVF staff have viewed the SSVF Fraud webinar."}]
[null,"Recommendations:"]
[]
[]
[null,"C.   Subcontractor Management (if applicable)"]
[null,"This section is designed to assess the grantee’s management of any subcontractors to ensure compliance with program requirements and achievement of program goals."]
[]
[null,"Findings:"]
[null,"C3:",{"$f":"IF(Checkbox_Scoring!$G$25=\"No\",\"N/A\",IF(Checkbox_Scoring!$H$28=0,Checkbox_Scoring!$I$28,\"None\"))","v":"N/A"}]
[null,"C6:",{"$f":"IF(Checkbox_Scoring!$G$25=\"No\",\"N/A\",IF(Checkbox_Scoring!$H$31=0,Checkbox_Scoring!$I$31,\"None\"))","v":"N/A"}]
[]
[null,"Concerns:"]
[null,"C1:",{"$f":"IF(Checkbox_Scoring!$G$25=\"No\",\"N/A\",IF(Checkbox_Scoring!$H$26=0,Checkbox_Scoring!$I$26,\"None\"))","v":"N/A"}]
[null,"C2:",{"$f":"IF(Checkbox_Scoring!$G$25=\"No\",\"N/A\",IF(Checkbox_Scoring!$H$27=0,Checkbox_Scoring!$I$27,\"None\"))","v":"N/A"}]
[null,"C4:",{"$f":"IF(Checkbox_Scoring!$G$25=\"No\",\"N/A\",IF(Checkbox_Scoring!$H$29=0,Checkbox_Scoring!$I$29,\"None\"))","v":"N/A"}]
[null,"C5:",{"$f":"IF(Checkbox_Scoring!$G$25=\"No\",\"N/A\",IF(Checkbox_Scoring!$H$30=0,Checkbox_Scoring!$I$30,\"None\"))","v":"N/A"}]
[]
[null,"Recommendations:"]
[]
[]
[null,"D.  Outreach and Targeting"]
[null,"This section is designed to assess outreach services as described in 38 CFR 62.30. Grantees must a) provide outreach services and use their best efforts to ensure that hard-to-reach very low-income veteran families occupying permanent housing are found, engaged and provided supportive services and b) outreach services must include active liaison with local VA facilities, State, local, tribal (if any), and private agencies and organizations providing supportive services to very low-income veteran families in the area or community served by the grantee."]
[]
[null,"Findings:"]
[null,"D1:",{"$f":"IF(Checkbox_Scoring!$H$32=0,Checkbox_Scoring!$I$32,\"None\")","v":"The grantee does not conduct outreach to all the communities/CoCs listed in their FY17 Resolution."}]
[]
[null,"Concerns:"]
[null,"D2:",{"$f":"IF(Checkbox_Scoring!$H$33=0,Checkbox_Scoring!$I$33,\"None\")","v":"The grantee does not have documentation showing where outreach is conducted and the frequency of outreach activities."}]
[null,"D3:",{"$f":"IF(Checkbox_Scoring!$H$34=0,Checkbox_Scoring!$I$34,\"None\")","v":"The grantee does not provide consistent outreach efforts throughout the entire service area that target the populations identified in their grant agreement."}]
[null,"D4:",{"$f":"IF(Checkbox_Scoring!$H$35=0,Checkbox_Scoring!$I$35,\"None\")","v":"The grantee does not provide outreach services to find and engage hard-to-reach, very low income veteran families throughout the service area."}]
[null,"D5:",{"$f":"IF(Checkbox_Scoring!$H$36=0,Checkbox_Scoring!$I$36,\"None\")","v":"The grantee does not receive referrals through coordinated entry, and/or the grantee does not engage in outreach activities with private organizations, state agencies, local government agencies, and other providers in the community."}]
[]
[null,"Recommendations:"]
[]
[]
[null,"E.   Participant Eligibility"]
[null,"This section is designed to assess whether participant eligibility has been adequately documented in terms of each participant’s income and housing status upon program entry."]
[]
[null,"Findings:"]
[null,"E3:",{"$f":"IF(Checkbox_Scoring!$H$39=0,Checkbox_Scoring!$I$39,\"None\")","v":"Front line staff do not refer Veteran families to other resources if determined to be ineligible for SSVF services."}]
[null,"E7:",{"$f":"IF(Checkbox_Scoring!$H$43=0,Checkbox_Scoring!$I$43,\"None\")","v":"The client files do not include adequate evidence of Veteran status."}]
[null,"E8:",{"$f":"IF(Checkbox_Scoring!$H$44=0,Checkbox_Scoring!$I$44,\"None\")","v":"The files reviewed do not adequately document the participants' housing status as either literally homeless or at-risk of literal homelessness at program entry and/or prevention files do not include an eligibility screener."}]
[null,"E9:",{"$f":"IF(Checkbox_Scoring!$H$45=0,Checkbox_Scoring!$I$45,\"None\")","v":"The files reviewed do not adequately document that annual income is at or below 50% of the area median income (in accordance with the most recent HUD AMI guidelines)."}]
[null,"E10:",{"$f":"IF(Checkbox_Scoring!$H$46=0,Checkbox_Scoring!$I$46,\"None\")","v":"The files reviewed do not adequately document recertification of eligibility for each participant at least every 3 months."}]
[null,"E12:",{"$f":"IF(Checkbox_Scoring!$H$48=0,Checkbox_Scoring!$I$48,\"None\")","v":"The files reviewed do not adequately document a release of information form in each client file."}]
[]
[null,"Concerns:"]
[null,"E1:",{"$f":"IF(Checkbox_Scoring!$H$37=0,Checkbox_Scoring!$I$37,\"None\")","v":"Front line staff do not have a clear understanding of the process for determining eligibility."}]
[null,"E2:",{"$f":"IF(Checkbox_Scoring!$H$38=0,Checkbox_Scoring!$I$38,\"None\")","v":"When a person served is found ineligible for services, the grantee does not have a process to: inform the participant as to the reasons; recommend alternative services; notify the referral source as to the reasons, and/or notify the participant of grievance process."}]
[null,"E4:",{"$f":"IF(Checkbox_Scoring!$H$40=0,Checkbox_Scoring!$I$40,\"None\")","v":"The grantee does not serve Veterans with zero income, criminal history, or other perceived housing barriers."}]
[null,"E5:",{"$f":"IF(Checkbox_Scoring!$H$41=0,Checkbox_Scoring!$I$41,\"None\")","v":"None"}]
[null,"E6:",{"$f":"IF(Checkbox_Scoring!$H$42=0,Checkbox_Scoring!$I$42,\"None\")","v":"None"}]
[null,"E11:",{"$f":"IF(Checkbox_Scoring!$H$47=0,Checkbox_Scoring!$I$47,\"None\")","v":"The files reviewed do not adequately document the exit criteria for each client."}]
[]
[null,"Recommendations:"]
[]
[]
[null,"F.   Supportive Services and Case Management"]
[null,"This section is designed to assess the grantee’s performance in conducting on-going participant needs assessments and in providing the supportive services identified in the approved application."]
[]
[null,"Findings:"]
[null,"F3:",{"$f":"IF(Checkbox_Scoring!$H$51=0,Checkbox_Scoring!$I$51,\"None\")","v":"The files reviewed do not adequately document that participants were linked to VA services."}]
[null,"F4:",{"$f":"IF(Checkbox_Scoring!$H$52=0,Checkbox_Scoring!$I$52,\"None\")","v":"The files reviewed do not adequately document that participants were provided with assistance in obtaining mainstream benefits."}]
[null,"F11:",{"$f":"IF(Checkbox_Scoring!$H$59=0,Checkbox_Scoring!$I$59,\"None\")","v":"The files reviewed do not adequately document that grantees conduct a habitability inspection on units for veterans receiving financial assistance and moving into a new housing unit."}]
[]
[null,"Concerns:"]
[null,"F1:",{"$f":"IF(Checkbox_Scoring!$H$49=0,Checkbox_Scoring!$I$49,\"None\")","v":"The grantee is not providing all agreed upon supportive services to participants and based on an individualized housing-focused assessment. "}]
[null,"F2:",{"$f":"IF(Checkbox_Scoring!$H$50=0,Checkbox_Scoring!$I$50,\"None\")","v":"The grantee does not have housing stability plans that are developed with the active involvement participants."}]
[null,"F5:",{"$f":"IF(Checkbox_Scoring!$H$53=0,Checkbox_Scoring!$I$53,\"None\")","v":"Case files do not demonstrate that the grantee is providing housing counseling to participants related to the stabilization of a participant’s residence in permanent housing."}]
[null,"F6:",{"$f":"IF(Checkbox_Scoring!$H$54=0,Checkbox_Scoring!$I$54,\"None\")","v":"The grantee does not conduct ongoing assessments of the participants’ supportive services needs and review the coordinated housing stability plan."}]
[null,"F7:",{"$f":"IF(Checkbox_Scoring!$H$55=0,Checkbox_Scoring!$I$55,\"None\")","v":"The files reviewed do not adequately document that clients were allowed choice in their housing and stability plans."}]
[null,"F8:",{"$f":"IF(Checkbox_Scoring!$H$56=0,Checkbox_Scoring!$I$56,\"None\")","v":"The files reviewed do not adequately document that the grantee assesses for rent affordability for Veterans receiving financial assistance and either staying in or moving into a new housing unit."}]
[null,"F9:",{"$f":"IF(Checkbox_Scoring!$H$57=0,Checkbox_Scoring!$I$57,\"None\")","v":"Missing documentation demonstrating that financial assistance payments were necessary for maintaining independent living in permanent housing and housing stability."}]
[]
[null,"Recommendations:"]
[null,"F10:",{"$f":"IF(Checkbox_Scoring!$H$58=0,Checkbox_Scoring!$I$58,\"None\")","v":"The files reviewed do not demonstrate that the grantee is assisting clients with their housing search."}]
[]
[]
[null,"G.   Financial Management and Cost Allowability"]
[null,"This section is designed to review the grantee’s financial management system and eligibility of grant expenditures. This section is designed to review the SSVF grantee's allocation of cost to verify that its procedures comply with OMB Circular A87, OMB Circular A122, 24 CFR Part 84 and24 CFR 85.22, made applicable to the SSVF program per 38 CFR 62."]
[]
[null,"Findings:"]
[null,"G2:",{"$f":"IF(Checkbox_Scoring!$H$61=0,Checkbox_Scoring!$I$61,\"None\")","v":"The files reviewed do not adequately document that grantees ensure that all TFA payments are provided to third parties and/or grantee does not verify payments are made to legitimate third party vendors."}]
[null,"G9:",{"$f":"IF(Checkbox_Scoring!$H$68=0,Checkbox_Scoring!$I$68,\"None\")","v":"Charges to SSVF for salaries and wages are not supported by records that accurately reflect the work performed."}]
[null,"G11:",{"$f":"IF(Checkbox_Scoring!$H$70=0,Checkbox_Scoring!$I$70,\"None\")","v":"The HHS PMS withdrawal information does not match the information from the grantee’s drawdown requests tracking."}]
[null,"G12:",{"$f":"IF(Checkbox_Scoring!$H$71=0,Checkbox_Scoring!$I$71,\"None\")","v":"None"}]
[null,"G13:",{"$f":"IF(Checkbox_Scoring!$H$72=0,Checkbox_Scoring!$I$72,\"None\")","v":"This grantee has not completed their required A-133 audit in a timely manner. "}]
[]
[null,"Concerns:"]
[null,"G1:",{"$f":"IF(Checkbox_Scoring!$H$60=0,Checkbox_Scoring!$I$60,\"None\")","v":"The grantee does not have written procedures for recording financial transactions; and a current accounting manual and a chart of accounts."}]
[null,"G3:",{"$f":"IF(Checkbox_Scoring!$H$62=0,Checkbox_Scoring!$I$62,\"None\")","v":"The grantee does not maintain a policy manual covering the authority for approving financial transactions. "}]
[null,"G4:",{"$f":"IF(Checkbox_Scoring!$H$63=0,Checkbox_Scoring!$I$63,\"None\")","v":"Staff duties are not separated so that no one individual has complete authority over an entire financial transaction."}]
[null,"G5:",{"$f":"IF(Checkbox_Scoring!$H$64=0,Checkbox_Scoring!$I$64,\"None\")","v":"The grantee does not have written procedures regarding the maintenance of accounting records."}]
[null,"G6:",{"$f":"IF(Checkbox_Scoring!$H$65=0,Checkbox_Scoring!$I$65,\"None\")","v":"The grantee’s fiscal records and valuables are not secured in a limited access area."}]
[null,"G7:",{"$f":"IF(Checkbox_Scoring!$H$66=0,Checkbox_Scoring!$I$66,\"None\")","v":"The grantee does not identify, track and account for all costs (including administrative costs) charged to the SSVF grant."}]
[null,"G8:",{"$f":"IF(Checkbox_Scoring!$H$67=0,Checkbox_Scoring!$I$67,\"None\")","v":"Charges to SSVF for salaries and wages are not based on payroll documentation and approved by a responsible official of the organization being monitored."}]
[null,"G10:",{"$f":"IF(Checkbox_Scoring!$H$69=0,Checkbox_Scoring!$I$69,\"None\")","v":"For salaries paid from more than one source, fiscal records do not clearly define payments among the funding sources."}]
[]
[null,"Recommendations:"]
[]
[]
[null,"H.   Vehicle Usage (if applicable) "]
[null,"This section is designed to review the grantee’s use of vehicles funded with SSVF Grant fund in accordance with the grant agreement."]
[]
[null,"Findings:","None for this section."]
[]
[null,"Concerns:"]
[null,"H2:",{"$f":"IF(Checkbox_Scoring!$G$73=\"No\",\"N/A\",IF(Checkbox_Scoring!$H$74=0,Checkbox_Scoring!$I$74,\"None\"))","v":"N/A"}]
[null,"H3:",{"$f":"IF(Checkbox_Scoring!$G$73=\"No\",\"N/A\",IF(Checkbox_Scoring!$H$75=0,Checkbox_Scoring!$I$75,\"None\"))","v":"N/A"}]
[]
[null,"Recommendations:"]
[]
[]
[null,"I.   Data Management & Quality Assurance"]
[null,"This section is designed to review the grantee’s data management (HMIS and Repository Uploads) and assess whether quality assurance is in accordance with the grant agreement."]
[]
[null,"Findings:"]
[null,"I3:",{"$f":"IF(Checkbox_Scoring!$H$78=0,Checkbox_Scoring!$I$78,\"None\")","v":"The grantee does not successfully upload all client information into the SSVF HMIS Repository on a monthly basis."}]
[null,"I4:",{"$f":"IF(Checkbox_Scoring!$H$79=0,Checkbox_Scoring!$I$79,\"None\")","v":"The grantee is not entering or exporting data to all CoCs served."}]
[null,"I5:",{"$f":"IF(Checkbox_Scoring!$H$80=0,Checkbox_Scoring!$I$80,\"None\")","v":"Client file data is not accurately entered into the grantee's HMIS system."}]
[]
[null,"Concerns:"]
[null,"I1:",{"$f":"IF(Checkbox_Scoring!$H$76=0,Checkbox_Scoring!$I$76,\"None\")","v":"The grantee does not maintain a Comprehensive Data Quality Plan to ensure completeness, timeliness, and accuracy of HMIS data."}]
[null,"I2:",{"$f":"IF(Checkbox_Scoring!$H$77=0,Checkbox_Scoring!$I$77,\"None\")","v":"The Data Quality Plan does not specifically detail staff responsibility including:  timelines for data entry and HMIS Repository uploads, and ongoing quality assurance procedures."}]
[null,"I6:",{"$f":"IF(Checkbox_Scoring!$H$81=0,Checkbox_Scoring!$I$81,\"None\")","v":"TFA payments are not captured in the grantee's HMIS data and/or TFA amounts do not reconcile with client file documentation/HHS drawdowns."}]
[]
[]
[null,"Part B.   Section G Supplement (if applicable) "]
[null,"This section is designed as a supplement to Section G and provides a more in-depth review of the grantee's fiscal administration.  Only grantees selected for this intensive level of monitoring will receive a \"PASS\" or \"FAIL\" result.  "]
[]
[null,"Findings:"]
[null,"TFA Payment Review:",null,null,{"$f":"IF(Checkbox_Scoring!$G$82=\"No\",\"N/A\",Checkbox_Scoring!$G$83)","v":"N/A"}]
[null,"General Ledger Expense Review:",null,null,{"$f":"IF(Checkbox_Scoring!$G$82=\"No\",\"N/A\",Checkbox_Scoring!$G$84)","v":"N/A"}]
[null,"Payroll Review:",null,null,{"$f":"IF(Checkbox_Scoring!$G$82=\"No\",\"N/A\",Checkbox_Scoring!$G$85)","v":"N/A"}]
[null,"Administrative Review:",null,null,{"$f":"IF(Checkbox_Scoring!$G$82=\"No\",\"N/A\",Checkbox_Scoring!$G$86)","v":"N/A"}]
[null,"Subcontractor Review:",null,null,{"$f":"IF(Checkbox_Scoring!$G$82=\"No\",\"N/A\",Checkbox_Scoring!$G$87)","v":"N/A"}]
[]
[null,"Recommendations:"]
[]
[]
[null,"Part C.   Subcontractor Supplement (if applicable) "]
[null,"This section is designed as a supplement to Section C and provides a more in-depth review of a grantee's subcontractor's operations.  Only grantees selected for this intensive level of monitoring will receive a \"PASS\" or \"FAIL\" result.  "]
[]
[null,"Findings:"]
[null,"Management of SSVF Program:",null,null,{"$f":"IF(Checkbox_Scoring!$G$89=\"No\",\"N/A\",Checkbox_Scoring!$G$90)","v":"N/A"}]
[null,"Carrying Out MOU/Agreement:",null,null,{"$f":"IF(Checkbox_Scoring!$G$89=\"No\",\"N/A\",Checkbox_Scoring!$G$91)","v":"N/A"}]
[null,"File Review:",null,null,{"$f":"IF(Checkbox_Scoring!$G$89=\"No\",\"N/A\",Checkbox_Scoring!$G$92)","v":"N/A"}]
[null,"Financial Management:",null,null,{"$f":"IF(Checkbox_Scoring!$G$89=\"No\",\"N/A\",Checkbox_Scoring!$G$93)","v":"N/A"}]

{"sheet":"Pick Files","index":16,"n_rows":136314,"n_cols":2,"rows_kept":4500,"cut":true,"hidden":false,"merged":[],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0}}
[null,"Unique ID"]
[1,1]
[2,2]
[3,3]
[4,4]
[5,5]
[6,6]
[7,7]
[8,8]
[9,9]
[10,10]
[11,0]
[12,12]
[13,13]
[14,14]
[15,15]
[16,17]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[514]
[515]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[578]
[579]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[642]
[643]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[706]
[707]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[770]
[771]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[834]
[835]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[898]
[899]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[962]
[963]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]
[1001]
[1002]
[1003]
[1004]
[1005]
[1006]
[1007]
[1008]
[1009]
[1010]
[1011]
[1012]
[1013]
[1014]
[1015]
[1016]
[1017]
[1018]
[1019]
[1020]
[1021]
[1022]
[1023]
[1024]
[1025]
[1026]
[1027]
[1028]
[1029]
[1030]
[1031]
[1032]
[1033]
[1034]
[1035]
[1036]
[1037]
[1038]
[1039]
[1040]
[1041]
[1042]
[1043]
[1044]
[1045]
[1046]
[1047]
[1048]
[1049]
[1050]
[1051]
[1052]
[1053]
[1054]
[1055]
[1056]
[1057]
[1058]
[1059]
[1060]
[1061]
[1062]
[1063]
[1064]
[1065]
[1066]
[1067]
[1068]
[1069]
[1070]
[1071]
[1072]
[1073]
[1074]
[1075]
[1076]
[1077]
[1078]
[1079]
[1080]
[1081]
[1082]
[1083]
[1084]
[1085]
[1086]
[1087]
[1088]
[1089]
[1090]
[1091]
[1092]
[1093]
[1094]
[1095]
[1096]
[1097]
[1098]
[1099]
[1100]
[1101]
[1102]
[1103]
[1104]
[1105]
[1106]
[1107]
[1108]
[1109]
[1110]
[1111]
[1112]
[1113]
[1114]
[1115]
[1116]
[1117]
[1118]
[1119]
[1120]
[1121]
[1122]
[1123]
[1124]
[1125]
[1126]
[1127]
[1128]
[1129]
[1130]
[1131]
[1132]
[1133]
[1134]
[1135]
[1136]
[1137]
[1138]
[1139]
[1140]
[1141]
[1142]
[1143]
[1144]
[1145]
[1146]
[1147]
[1148]
[1149]
[1150]
[1151]
[1152]
[1153]
[1154]
[1155]
[1156]
[1157]
[1158]
[1159]
[1160]
[1161]
[1162]
[1163]
[1164]
[1165]
[1166]
[1167]
[1168]
[1169]
[1170]
[1171]
[1172]
[1173]
[1174]
[1175]
[1176]
[1177]
[1178]
[1179]
[1180]
[1181]
[1182]
[1183]
[1184]
[1185]
[1186]
[1187]
[1188]
[1189]
[1190]
[1191]
[1192]
[1193]
[1194]
[1195]
[1196]
[1197]
[1198]
[1199]
[1200]
[1201]
[1202]
[1203]
[1204]
[1205]
[1206]
[1207]
[1208]
[1209]
[1210]
[1211]
[1212]
[1213]
[1214]
[1215]
[1216]
[1217]
[1218]
[1219]
[1220]
[1221]
[1222]
[1223]
[1224]
[1225]
[1226]
[1227]
[1228]
[1229]
[1230]
[1231]
[1232]
[1233]
[1234]
[1235]
[1236]
[1237]
[1238]
[1239]
[1240]
[1241]
[1242]
[1243]
[1244]
[1245]
[1246]
[1247]
[1248]
[1249]
[1250]
[1251]
[1252]
[1253]
[1254]
[1255]
[1256]
[1257]
[1258]
[1259]
[1260]
[1261]
[1262]
[1263]
[1264]
[1265]
[1266]
[1267]
[1268]
[1269]
[1270]
[1271]
[1272]
[1273]
[1274]
[1275]
[1276]
[1277]
[1278]
[1279]
[1280]
[1281]
[1282]
[1283]
[1284]
[1285]
[1286]
[1287]
[1288]
[1289]
[1290]
[1291]
[1292]
[1293]
[1294]
[1295]
[1296]
[1297]
[1298]
[1299]
[1300]
[1301]
[1302]
[1303]
[1304]
[1305]
[1306]
[1307]
[1308]
[1309]
[1310]
[1311]
[1312]
[1313]
[1314]
[1315]
[1316]
[1317]
[1318]
[1319]
[1320]
[1321]
[1322]
[1323]
[1324]
[1325]
[1326]
[1327]
[1328]
[1329]
[1330]
[1331]
[1332]
[1333]
[1334]
[1335]
[1336]
[1337]
[1338]
[1339]
[1340]
[1341]
[1342]
[1343]
[1344]
[1345]
[1346]
[1347]
[1348]
[1349]
[1350]
[1351]
[1352]
[1353]
[1354]
[1355]
[1356]
[1357]
[1358]
[1359]
[1360]
[1361]
[1362]
[1363]
[1364]
[1365]
[1366]
[1367]
[1368]
[1369]
[1370]
[1371]
[1372]
[1373]
[1374]
[1375]
[1376]
[1377]
[1378]
[1379]
[1380]
[1381]
[1382]
[1383]
[1384]
[1385]
[1386]
[1387]
[1388]
[1389]
[1390]
[1391]
[1392]
[1393]
[1394]
[1395]
[1396]
[1397]
[1398]
[1399]
[1400]
[1401]
[1402]
[1403]
[1404]
[1405]
[1406]
[1407]
[1408]
[1409]
[1410]
[1411]
[1412]
[1413]
[1414]
[1415]
[1416]
[1417]
[1418]
[1419]
[1420]
[1421]
[1422]
[1423]
[1424]
[1425]
[1426]
[1427]
[1428]
[1429]
[1430]
[1431]
[1432]
[1433]
[1434]
[1435]
[1436]
[1437]
[1438]
[1439]
[1440]
[1441]
[1442]
[1443]
[1444]
[1445]
[1446]
[1447]
[1448]
[1449]
[1450]
[1451]
[1452]
[1453]
[1454]
[1455]
[1456]
[1457]
[1458]
[1459]
[1460]
[1461]
[1462]
[1463]
[1464]
[1465]
[1466]
[1467]
[1468]
[1469]
[1470]
[1471]
[1472]
[1473]
[1474]
[1475]
[1476]
[1477]
[1478]
[1479]
[1480]
[1481]
[1482]
[1483]
[1484]
[1485]
[1486]
[1487]
[1488]
[1489]
[1490]
[1491]
[1492]
[1493]
[1494]
[1495]
[1496]
[1497]
[1498]
[1499]
[1500]
[1501]
[1502]
[1503]
[1504]
[1505]
[1506]
[1507]
[1508]
[1509]
[1510]
[1511]
[1512]
[1513]
[1514]
[1515]
[1516]
[1517]
[1518]
[1519]
[1520]
[1521]
[1522]
[1523]
[1524]
[1525]
[1526]
[1527]
[1528]
[1529]
[1530]
[1531]
[1532]
[1533]
[1534]
[1535]
[1536]
[1537]
[1538]
[1539]
[1540]
[1541]
[1542]
[1543]
[1544]
[1545]
[1546]
[1547]
[1548]
[1549]
[1550]
[1551]
[1552]
[1553]
[1554]
[1555]
[1556]
[1557]
[1558]
[1559]
[1560]
[1561]
[1562]
[1563]
[1564]
[1565]
[1566]
[1567]
[1568]
[1569]
[1570]
[1571]
[1572]
[1573]
[1574]
[1575]
[1576]
[1577]
[1578]
[1579]
[1580]
[1581]
[1582]
[1583]
[1584]
[1585]
[1586]
[1587]
[1588]
[1589]
[1590]
[1591]
[1592]
[1593]
[1594]
[1595]
[1596]
[1597]
[1598]
[1599]
[1600]
[1601]
[1602]
[1603]
[1604]
[1605]
[1606]
[1607]
[1608]
[1609]
[1610]
[1611]
[1612]
[1613]
[1614]
[1615]
[1616]
[1617]
[1618]
[1619]
[1620]
[1621]
[1622]
[1623]
[1624]
[1625]
[1626]
[1627]
[1628]
[1629]
[1630]
[1631]
[1632]
[1633]
[1634]
[1635]
[1636]
[1637]
[1638]
[1639]
[1640]
[1641]
[1642]
[1643]
[1644]
[1645]
[1646]
[1647]
[1648]
[1649]
[1650]
[1651]
[1652]
[1653]
[1654]
[1655]
[1656]
[1657]
[1658]
[1659]
[1660]
[1661]
[1662]
[1663]
[1664]
[1665]
[1666]
[1667]
[1668]
[1669]
[1670]
[1671]
[1672]
[1673]
[1674]
[1675]
[1676]
[1677]
[1678]
[1679]
[1680]
[1681]
[1682]
[1683]
[1684]
[1685]
[1686]
[1687]
[1688]
[1689]
[1690]
[1691]
[1692]
[1693]
[1694]
[1695]
[1696]
[1697]
[1698]
[1699]
[1700]
[1701]
[1702]
[1703]
[1704]
[1705]
[1706]
[1707]
[1708]
[1709]
[1710]
[1711]
[1712]
[1713]
[1714]
[1715]
[1716]
[1717]
[1718]
[1719]
[1720]
[1721]
[1722]
[1723]
[1724]
[1725]
[1726]
[1727]
[1728]
[1729]
[1730]
[1731]
[1732]
[1733]
[1734]
[1735]
[1736]
[1737]
[1738]
[1739]
[1740]
[1741]
[1742]
[1743]
[1744]
[1745]
[1746]
[1747]
[1748]
[1749]
[1750]
[1751]
[1752]
[1753]
[1754]
[1755]
[1756]
[1757]
[1758]
[1759]
[1760]
[1761]
[1762]
[1763]
[1764]
[1765]
[1766]
[1767]
[1768]
[1769]
[1770]
[1771]
[1772]
[1773]
[1774]
[1775]
[1776]
[1777]
[1778]
[1779]
[1780]
[1781]
[1782]
[1783]
[1784]
[1785]
[1786]
[1787]
[1788]
[1789]
[1790]
[1791]
[1792]
[1793]
[1794]
[1795]
[1796]
[1797]
[1798]
[1799]
[1800]
[1801]
[1802]
[1803]
[1804]
[1805]
[1806]
[1807]
[1808]
[1809]
[1810]
[1811]
[1812]
[1813]
[1814]
[1815]
[1816]
[1817]
[1818]
[1819]
[1820]
[1821]
[1822]
[1823]
[1824]
[1825]
[1826]
[1827]
[1828]
[1829]
[1830]
[1831]
[1832]
[1833]
[1834]
[1835]
[1836]
[1837]
[1838]
[1839]
[1840]
[1841]
[1842]
[1843]
[1844]
[1845]
[1846]
[1847]
[1848]
[1849]
[1850]
[1851]
[1852]
[1853]
[1854]
[1855]
[1856]
[1857]
[1858]
[1859]
[1860]
[1861]
[1862]
[1863]
[1864]
[1865]
[1866]
[1867]
[1868]
[1869]
[1870]
[1871]
[1872]
[1873]
[1874]
[1875]
[1876]
[1877]
[1878]
[1879]
[1880]
[1881]
[1882]
[1883]
[1884]
[1885]
[1886]
[1887]
[1888]
[1889]
[1890]
[1891]
[1892]
[1893]
[1894]
[1895]
[1896]
[1897]
[1898]
[1899]
[1900]
[1901]
[1902]
[1903]
[1904]
[1905]
[1906]
[1907]
[1908]
[1909]
[1910]
[1911]
[1912]
[1913]
[1914]
[1915]
[1916]
[1917]
[1918]
[1919]
[1920]
[1921]
[1922]
[1923]
[1924]
[1925]
[1926]
[1927]
[1928]
[1929]
[1930]
[1931]
[1932]
[1933]
[1934]
[1935]
[1936]
[1937]
[1938]
[1939]
[1940]
[1941]
[1942]
[1943]
[1944]
[1945]
[1946]
[1947]
[1948]
[1949]
[1950]
[1951]
[1952]
[1953]
[1954]
[1955]
[1956]
[1957]
[1958]
[1959]
[1960]
[1961]
[1962]
[1963]
[1964]
[1965]
[1966]
[1967]
[1968]
[1969]
[1970]
[1971]
[1972]
[1973]
[1974]
[1975]
[1976]
[1977]
[1978]
[1979]
[1980]
[1981]
[1982]
[1983]
[1984]
[1985]
[1986]
[1987]
[1988]
[1989]
[1990]
[1991]
[1992]
[1993]
[1994]
[1995]
[1996]
[1997]
[1998]
[1999]
[2003]
[2096]
[2143]
[2223]
[2270]
[2384]
[2464]
[2511]
[2591]
[2638]
[2682]
[2764]
[2811]
[2925]
[2938]
[3052]
[3132]
[3179]
[3226]
[3306]
[3353]
[3405]
[3479]
[3593]
[3606]
[3720]
[3767]
[3847]
[3894]
[3974]
[4021]
[4135]
[4190]
[4261]
[4308]
[4388]
[4435]
[4515]
[4562]
[4609]
[4689]
[4803]
[4816]
[4909]
[4976]
[5056]
[5103]
[5150]
[5230]
[5344]
[5357]
[5471]
[5518]
[5588]
[5644]
[5724]
[5771]
[5818]
[5898]
[6012]
[6059]
[6139]
[6186]
[6266]
[6307]
[6359]
[6439]
[6486]
[6600]
[6680]
[6727]
[6807]
[6854]
[6901]
[6981]
[7026]
[7107]
[7154]
[7268]
[7348]
[7395]
[7442]
[7522]
[7569]
[7649]
[7696]
[7811]
[7822]
[7936]
[7983]
[8063]
[8110]
[8190]
[8237]
[8351]
[8364]
[8424]
[8490]
[8604]
[8651]
[8731]
[8778]
[8825]
[8905]
[9019]
[9032]
[9146]
[9209]
[9272]
[9319]
[9399]
[9446]
[9493]
[9573]
[9687]
[9734]
[9814]
[9861]
[9932]
[9987]
[10034]
[10114]
[10228]
[10275]
[10355]
[10402]
[10482]
[10529]
[10576]
[10651]
[10702]
[10782]
[10896]
[10943]
[11023]
[11070]
[11117]
[11197]
[11244]
[11330]
[11370]
[11484]
[11564]
[11611]
[11691]
[11738]
[11785]
[11865]
[11912]
[12026]
[12049]
[12152]
[12232]
[12279]
[12326]
[12406]
[12453]
[12567]
[12580]
[12694]
[12707]
[12834]
[12867]
[12947]
[12994]
[13074]
[13121]
[13235]
[13248]
[13362]
[13409]
[13489]
[13553]
[13615]
[13662]
[13709]
[13789]
[13903]
[13950]
[14030]
[14077]
[14157]
[14232]
[14250]
[14330]
[14377]
[14457]
[14571]
[14618]
[14698]
[14745]
[14792]
[14872]
[14951]
[14998]
[15112]
[15159]
[15239]
[15286]
[15366]
[15413]
[15460]
[15540]
[15587]
[15670]
[15780]
[15827]
[15907]
[15954]
[16001]
[16081]
[16128]
[16242]
[16255]
[16369]
[16393]
[16495]
[16542]
[16622]
[16669]
[16749]
[16796]
[16910]
[16923]
[17037]
[17068]
[17163]
[17210]
[17290]
[17337]
[17451]
[17464]
[17578]
[17625]
[17705]
[17752]
[17791]
[17878]
[17925]
[18005]
[18119]
[18132]
[18246]
[18293]
[18373]
[18420]
[18467]
[18576]
[18593]
[18673]
[18787]
[18834]
[18914]
[18961]
[19041]
[19088]
[19135]
[19215]
[19295]
[19375]
[19455]
[19502]
[19582]
[19629]
[19676]
[19756]
[19803]
[19917]
[19974]
[20043]
[20123]
[20170]
[20217]
[20297]
[20344]
[20424]
[20471]
[20585]
[20665]
[20693]
[20758]
[20838]
[20885]
[20965]
[21012]
[21126]
[21139]
[21253]
[21333]
[21380]
[21412]
[21506]
[21553]
[21667]
[21680]
[21794]
[21807]
[21921]
[21968]
[22048]
[22095]
[22197]
[22221]
[22335]
[22348]
[22462]
[22509]
[22589]
[22636]
[22716]
[22763]
[22810]
[22889]
[23003]
[23050]
[23130]
[23177]
[23257]
[23304]
[23351]
[23431]
[23478]
[23595]
[23671]
[23718]
[23798]
[23845]
[23892]
[23972]
[24019]
[24099]
[24146]
[24260]
[24318]
[24386]
[24433]
[24513]
[24560]
[24640]
[24687]
[24801]
[24881]
[24928]
[25008]
[25037]
[25101]
[25181]
[25228]
[25342]
[25355]
[25469]
[25549]
[25596]
[25643]
[25716]
[25769]
[25883]
[25896]
[26010]
[26023]
[26137]
[26184]
[26264]
[26311]
[26391]
[26435]
[26551]
[26564]
[26678]
[26725]
[26805]
[26852]
[26932]
[26979]
[27026]
[27106]
[27220]
[27232]
[27346]
[27393]
[27473]
[27520]
[27567]
[27647]
[27694]
[27774]
[27888]
[27939]
[28014]
[28061]
[28108]
[28188]
[28235]
[28315]
[28362]
[28476]
[28556]
[28618]
[28682]
[28729]
[28776]
[28856]
[28903]
[29017]
[29030]
[29144]
[29224]
[29271]
[29337]
[29397]
[29444]
[29558]
[29571]
[29685]
[29765]
[29812]
[29859]
[29939]
[29986]
[30060]
[30112]
[30226]
[30239]
[30353]
[30400]
[30480]
[30527]
[30607]
[30654]
[30768]
[30779]
[30894]
[30907]
[31021]
[31068]
[31148]
[31195]
[31242]
[31322]
[31436]
[31458]
[31562]
[31609]
[31689]
[31736]
[31783]
[31863]
[31910]
[31990]
[32104]
[32151]
[32177]
[32277]
[32357]
[32404]
[32451]
[32531]
[32578]
[32692]
[32772]
[32819]
[32899]
[32962]
[32992]
[33072]
[33119]
[33233]
[33246]
[33360]
[33440]
[33487]
[33534]
[33614]
[33681]
[33740]
[33787]
[33901]
[33914]
[34028]
[34075]
[34155]
[34202]
[34282]
[34360]
[34442]
[34455]
[34569]
[34649]
[34696]
[34743]
[34823]
[34870]
[34984]
[34997]
[35079]
[35123]
[35237]
[35284]
[35364]
[35411]
[35458]
[35538]
[35652]
[35665]
[35779]
[35798]
[35905]
[35952]
[36032]
[36079]
[36126]
[36206]
[36320]
[36367]
[36447]
[36494]
[36587]
[36620]
[36667]
[36747]
[36794]
[36874]
[36988]
[37035]
[37115]
[37162]
[37196]
[37288]
[37335]
[37415]
[37462]
[37576]
[37656]
[37703]
[37750]
[37830]
[37877]
[37985]
[38003]
[38117]
[38130]
[38244]
[38324]
[38371]
[38418]
[38498]
[38545]
[38659]
[38704]
[38785]
[38798]
[38912]
[38959]
[39039]
[39086]
[39133]
[39213]
[39327]
[39340]
[39423]
[39500]
[39580]
[39627]
[39707]
[39754]
[39868]
[39881]
[39995]
[40042]
[40102]
[40168]
[40248]
[40295]
[40342]
[40422]
[40536]
[40549]
[40663]
[40710]
[40790]
[40821]
[40883]
[40963]
[41010]
[41090]
[41204]
[41251]
[41331]
[41378]
[41425]
[41505]
[41606]
[41631]
[41678]
[41792]
[41872]
[41919]
[41999]
[42046]
[42093]
[42173]
[42220]
[42325]
[42346]
[42460]
[42540]
[42587]
[42634]
[42714]
[42761]
[42875]
[42888]
[43004]
[43014]
[43128]
[43175]
[43255]
[43302]
[43382]
[43429]
[43543]
[43556]
[43670]
[43723]
[43796]
[43843]
[43923]
[43970]
[44017]
[44097]
[44211]
[44224]
[44338]
[44385]
[44446]
[44511]
[44558]
[44638]
[44752]
[44765]
[44879]
[44926]
[45006]
[45053]
[45100]
[45165]
[45226]
[45306]
[45420]
[45467]
[45547]
[45594]
[45674]
[45721]
[45768]
[45844]
[45894]
[46008]
[46088]
[46135]
[46215]
[46262]
[46309]
[46389]
[46436]
[46516]
[46563]
[46676]
[46756]
[46803]
[46850]
[46930]
[46977]
[47057]
[47104]
[47218]
[47231]
[47348]
[47391]
[47471]
[47518]
[47598]
[47645]
[47759]
[47772]
[47886]
[47899]
[48013]
[48067]
[48139]
[48186]
[48233]
[48313]
[48427]
[48440]
[48554]
[48601]
[48681]
[48746]
[48774]
[48854]
[48901]
[48981]
[49095]
[49142]
[49222]
[49269]
[49349]
[49396]
[49465]
[49522]
[49636]
[49683]
[49763]
[49810]
[49890]
[49937]
[49984]
[50064]
[50111]
[50188]
[50304]
[50351]
[50431]
[50478]
[50525]
[50605]
[50652]
[50732]
[50779]
[50893]
[50973]
[51019]
[51066]
[51146]
[51193]
[51273]
[51320]
[51434]
[51447]
[51561]
[51586]
[51687]
[51734]
[51814]
[51861]
[51975]
[51988]
[52102]
[52115]
[52229]
[52276]
[52371]
[52402]
[52482]
[52529]
[52643]
[52656]
[52770]
[52817]
[52897]
[52944]
[53024]
[53090]
[53117]
[53197]
[53311]
[53358]
[53438]
[53485]
[53565]
[53612]
[53659]
[53739]
[53809]
[53865]
[53979]
[54026]
[54106]
[54153]
[54200]
[54280]
[54327]
[54407]
[54488]
[54567]
[54647]
[54694]
[54741]
[54821]
[54868]
[54948]
[54995]
[55109]
[55189]
[55207]
[55315]
[55362]
[55409]
[55489]
[55536]
[55650]
[55663]
[55777]
[55857]
[55904]
[55992]
[56030]
[56077]
[56157]
[56204]
[56318]
[56331]
[56445]
[56492]
[56572]
[56619]
[56715]
[56745]
[56859]
[56872]
[56986]
[57033]
[57113]
[57160]
[57240]
[57287]
[57390]
[57413]
[57527]
[57540]
[57654]
[57701]
[57781]
[57828]
[57875]
[57955]
[58002]
[58113]
[58195]
[58242]
[58322]
[58369]
[58416]
[58496]
[58543]
[58623]
[58670]
[58784]
[58832]
[58910]
[58990]
[59037]
[59084]
[59164]
[59211]
[59325]
[59405]
[59452]
[59532]
[59551]
[59625]
[59705]
[59752]
[59832]
[59879]
[59993]
[60073]
[60120]
[60167]
[60230]
[60293]
[60373]
[60420]
[60534]
[60547]
[60661]
[60708]
[60788]
[60835]
[60915]
[60949]
[61075]
[61088]
[61202]
[61215]
[61329]
[61376]
[61456]
[61503]
[61550]
[61630]
[61734]
[61756]
[61870]
[61917]
[61997]
[62044]
[62124]
[62171]
[62218]
[62298]
[62412]
[62453]
[62538]
[62585]
[62665]
[62712]
[62759]
[62839]
[62886]
[63000]
[63080]
[63132]
[63206]
[63253]
[63300]
[63380]
[63427]
[63507]
[63554]
[63668]
[63748]
[63795]
[63851]
[63921]
[63968]
[64048]
[64095]
[64209]
[64289]
[64336]
[64383]
[64463]
[64510]
[64574]
[64636]
[64750]
[64763]
[64877]
[64957]
[65004]
[65051]
[65131]
[65178]
[65292]
[65359]
[65418]
[65431]
[65545]
[65592]
[65672]
[65719]
[65799]
[65846]
[65960]
[65972]
[66086]
[66133]
[66213]
[66260]
[66340]
[66387]
[66434]
[66514]
[66628]
[66675]
[66757]
[66801]
[66881]
[66928]
[66975]
[67055]
[67102]
[67182]
[67296]
[67343]
[67423]
[67476]
[67516]
[67596]
[67643]
[67723]
[67770]
[67884]
[67964]
[68011]
[68091]
[68138]
[68195]
[68264]
[68311]
[68425]
[68438]
[68552]
[68632]
[68679]
[68726]
[68806]
[68853]
[68914]
[68979]
[69093]
[69173]
[69220]
[69267]
[69347]
[69394]
[69474]
[69521]
[69593]
[69647]
[69761]
[69808]
[69888]
[69935]
[70015]
[70062]
[70176]
[70189]
[70303]
[70312]
[70429]
[70476]
[70556]
[70603]
[70650]
[70730]
[70844]
[70857]
[70971]
[71018]
[71101]
[71144]
[71191]
[71271]
[71318]
[71398]
[71512]
[71559]
[71639]
[71686]
[71766]
[71820]
[71859]
[71939]
[71986]
[72100]
[72180]
[72227]
[72307]
[72354]
[72401]
[72499]
[72527]
[72641]
[72654]
[72768]
[72848]
[72895]
[72942]
[73022]
[73069]
[73149]
[73218]
[73309]
[73322]
[73436]
[73483]
[73563]
[73610]
[73690]
[73737]
[73851]
[73864]
[73937]
[74024]
[74104]
[74151]
[74231]
[74278]
[74392]
[74405]
[74519]
[74532]
[74646]
[74722]
[74772]
[74819]
[74866]
[74946]
[75060]
[75073]
[75187]
[75234]
[75314]
[75335]
[75440]
[75487]
[75534]
[75614]
[75728]
[75775]
[75855]
[75902]
[75982]
[76029]
[76120]
[76155]
[76202]
[76316]
[76396]
[76443]
[76523]
[76570]
[76617]
[76697]
[76744]
[76843]
[76870]
[76984]
[77064]
[77111]
[77158]
[77238]
[77285]
[77365]
[77412]
[77526]
[77562]
[77652]
[77732]
[77779]
[77826]
[77906]
[77953]
[78067]
[78080]
[78194]
[78241]
[78320]
[78367]
[78447]
[78494]
[78541]
[78621]
[78735]
[78748]
[78862]
[78909]
[78960]
[79035]
[79115]
[79162]
[79276]
[79289]
[79403]
[79450]
[79530]
[79577]
[79657]
[79679]
[79750]
[79830]
[79944]
[79991]
[80071]
[80118]
[80198]
[80245]
[80292]
[80372]
[80464]
[80498]
[80612]
[80659]
[80739]
[80786]
[80833]
[80913]
[80960]
[81040]
[81143]
[81200]
[81280]
[81327]
[81407]
[81454]
[81501]
[81581]
[81628]
[81742]
[81755]
[81862]
[81948]
[81995]
[82042]
[82122]
[82169]
[82283]
[82296]
[82410]
[82423]
[82537]
[82581]
[82663]
[82710]
[82790]
[82837]
[82951]
[82964]
[83078]
[83125]
[83205]
[83252]
[83304]
[83378]
[83425]
[83505]
[83619]
[83666]
[83746]
[83793]
[83873]
[83920]
[83979]
[84046]
[84160]
[84173]
[84287]
[84334]
[84414]
[84461]
[84508]
[84588]
[84635]
[84702]
[84828]
[84875]
[84955]
[85002]
[85082]
[85129]
[85176]
[85256]
[85303]
[85417]
[85487]
[85543]
[85623]
[85670]
[85717]
[85797]
[85844]
[85958]
[85971]
[86085]
[86165]
[86206]
[86258]
[86338]
[86385]
[86465]
[86512]
[86626]
[86639]
[86753]
[86800]
[86885]
[86926]
[87006]
[87053]
[87167]
[87180]
[87294]
[87307]
[87421]
[87468]
[87548]
[87604]
[87641]
[87721]
[87835]
[87848]
[87962]
[88009]
[88089]
[88136]
[88183]
[88263]
[88323]
[88389]
[88503]
[88550]
[88630]
[88677]
[88757]
[88804]
[88851]
[88931]
[89045]
[89108]
[89171]
[89218]
[89298]
[89345]
[89392]
[89472]
[89519]
[89633]
[89713]
[89721]
[89839]
[89886]
[89933]
[90013]
[90060]
[90140]
[90187]
[90301]
[90381]
[90428]
[90506]
[90554]
[90601]
[90681]
[90728]
[90842]
[90855]
[90969]
[91049]
[91096]
[91143]
[91229]
[91269]
[91383]
[91396]
[91510]
[91523]
[91637]
[91684]
[91764]
[91811]
[91858]
[91948]
[92051]
[92064]
[92178]
[92225]
[92305]
[92352]
[92432]
[92479]
[92526]
[92627]
[92719]
[92766]
[92846]
[92893]
[92973]
[93020]
[93067]
[93147]
[93194]
[93274]
[93346]
[93434]
[93514]
[93561]
[93608]
[93688]
[93735]
[93815]
[93929]
[93976]
[94056]
[94065]
[94149]
[94229]
[94276]
[94356]
[94403]
[94517]
[94597]
[94644]
[94724]
[94771]
[94850]
[94897]
[94944]
[95058]
[95071]
[95185]
[95265]
[95312]
[95359]
[95439]
[95529]
[95599]
[95612]
[95726]
[95739]
[95853]
[95900]
[95980]
[96027]
[96107]
[96154]
[96248]
[96280]
[96394]
[96441]
[96521]
[96568]
[96648]
[96695]
[96742]
[96822]
[96936]
[96971]
[97062]
[97109]
[97189]
[97236]
[97283]
[97363]
[97410]
[97490]
[97604]
[97651]
[97690]
[97777]
[97824]
[97904]
[97951]
[98031]
[98078]
[98192]
[98272]
[98319]
[98369]
[98445]
[98492]
[98572]
[98619]
[98733]
[98813]
[98860]
[98940]
[98987]
[99034]
[99088]
[99160]
[99274]
[99287]
[99401]
[99481]
[99528]
[99575]
[99655]
[99702]
[99782]
[99873]
[99942]
[99955]
[100069]
[100116]
[100196]
[100243]
[100323]
[100370]
[100484]
[100497]
[100592]
[100623]
[100737]
[100784]
[100864]
[100911]
[100958]
[101038]
[101152]
[101165]
[101271]
[101325]
[101405]
[101452]
[101499]
[101579]
[101626]
[101706]
[101820]
[101867]
[101947]
[101990]
[102073]
[102120]
[102167]
[102247]
[102294]
[102408]
[102488]
[102535]
[102615]
[102662]
[102709]
[102788]
[102835]
[102915]
[102962]
[103076]
[103156]
[103203]
[103250]
[103330]
[103377]
[103432]
[103503]
[103617]
[103697]
[103744]
[103791]
[103871]
[103918]
[103998]
[104045]
[104107]
[104171]
[104285]
[104365]
[104412]
[104459]
[104539]
[104586]
[104700]
[104713]
[104827]
[104896]
[104953]
[105000]
[105080]
[105127]
[105174]
[105254]
[105368]
[105381]
[105495]
[105542]
[105615]
[105668]
[105748]
[105795]
[105842]
[105922]
[106036]
[106083]
[106163]
[106210]
[106290]
[106334]
[106383]
[106463]
[106510]
[106590]
[106704]
[106751]
[106831]
[106878]
[106925]
[107013]
[107051]
[107131]
[107178]
[107292]
[107372]
[107419]
[107466]
[107546]
[107593]
[107673]
[107732]
[107833]
[107846]
[107960]
[108040]
[108087]
[108134]
[108214]
[108261]
[108375]
[108388]
[108451]
[108581]
[108628]
[108675]
[108755]
[108802]
[108916]
[108929]
[109043]
[109056]
[109170]
[109236]
[109296]
[109343]
[109423]
[109470]
[109584]
[109597]
[109711]
[109758]
[109838]
[109915]
[109964]
[110011]
[110058]
[110138]
[110252]
[110265]
[110379]
[110426]
[110506]
[110553]
[110634]
[110679]
[110726]
[110806]
[110920]
[110967]
[111047]
[111094]
[111141]
[111221]
[111268]
[111357]
[111394]
[111508]
[111588]
[111635]
[111715]
[111762]
[111809]
[111889]
[111936]
[112050]
[112076]
[112176]
[112256]
[112303]
[112350]
[112430]
[112477]
[112557]
[112604]
[112718]
[112755]
[112844]
[112891]
[112971]
[113018]
[113098]
[113145]
[113259]
[113272]
[113386]
[113433]
[113474]
[113559]
[113639]
[113686]
[113800]
[113813]
[113927]
[113940]
[114054]
[114101]
[114181]
[114259]
[114274]
[114354]
[114468]
[114481]
[114595]
[114642]
[114722]
[114769]
[114816]
[114896]
[114978]
[115022]
[115136]
[115183]
[115263]
[115310]
[115390]
[115437]
[115484]
[115564]
[115657]
[115724]
[115804]
[115851]
[115931]
[115978]
[116025]
[116105]
[116152]
[116232]
[116279]
[116376]
[116472]
[116519]
[116566]
[116646]
[116693]
[116773]
[116820]
[116934]
[116947]
[117061]
[117095]
[117187]
[117234]
[117314]
[117361]
[117475]
[117488]
[117602]
[117615]
[117729]
[117776]
[117818]
[117902]
[117949]
[118029]
[118143]
[118156]
[118270]
[118317]
[118397]
[118444]
[118497]
[118570]
[118684]
[118697]
[118811]
[118858]
[118938]
[118985]
[119065]
[119112]
[119159]
[119282]
[119352]
[119399]
[119479]
[119526]
[119606]
[119653]
[119700]
[119780]
[119827]
[119907]
[120001]
[120067]
[120147]
[120194]
[120241]
[120321]
[120368]
[120448]
[120495]
[120609]
[120689]
[120720]
[120782]
[120862]
[120909]
[120989]
[121036]
[121150]
[121163]
[121277]
[121357]
[121399]
[121450]
[121530]
[121577]
[121691]
[121704]
[121818]
[121831]
[121945]
[121992]
[122072]
[122118]
[122198]
[122245]
[122359]
[122372]
[122486]
[122533]
[122613]
[122660]
[122740]
[122787]
[122837]
[122913]
[123027]
[123074]
[123154]
[123201]
[123281]
[123328]
[123375]
[123455]
[123569]
[123626]
[123695]
[123742]
[123822]
[123869]
[123916]
[123996]
[124043]
[124123]
[124237]
[124301]
[124363]
[124410]
[124457]
[124537]
[124584]
[124664]
[124711]
[124825]
[124905]
[124952]
[125024]
[125078]
[125125]
[125205]
[125252]
[125366]
[125379]
[125493]
[125573]
[125620]
[125667]
[125743]
[125793]
[125873]
[125920]
[126034]
[126047]
[126161]
[126208]
[126288]
[126335]
[126415]
[126462]
[126575]
[126588]
[126702]
[126749]
[126829]
[126876]
[126956]
[127003]
[127050]
[127141]
[127243]
[127256]
[127370]
[127417]
[127497]
[127544]
[127591]
[127671]
[127718]
[127798]
[127860]
[127958]
[128038]
[128085]
[128165]
[128212]
[128259]
[128339]
[128453]
[128500]
[128580]
[128645]
[128706]
[128753]
[128800]
[128880]
[128927]
[129041]
[129121]
[129168]
[129248]
[129295]
[129364]
[129421]
[129468]
[129548]
[129595]
[129709]
[129789]
[129836]
[129883]
[129963]
[130043]
[130089]
[130136]
[130250]
[130263]
[130377]
[130424]
[130504]
[130551]
[130631]
[130678]
[130762]
[130804]
[130918]
[130931]
[131045]
[131092]
[131172]
[131219]
[131266]
[131346]
[131460]
[131485]
[131586]
[131633]
[131713]
[131760]
[131840]
[131887]
[131934]
[132014]
[132128]
[132175]
[132204]
[132301]
[132381]
[132428]
[132475]
[132555]
[132602]
[132716]
[132796]
[132843]
[132883]
[132969]
[133016]
[133096]
[133143]
[133223]
[133337]
[133384]
[133464]
[133511]
[133558]
[133668]
[133684]
[133764]
[133811]
[133925]
[134005]
[134052]
[134132]
[134179]
[134226]
[134306]
[134387]
[134466]
[134479]
[134593]
[134673]
[134720]
[134767]
[134847]
[134894]
[135008]
[135021]
[135106]
[135147]
[135261]
[135308]
[135388]
[135435]
[135515]
[135562]
[135676]
[135689]
[135803]
[135814]
[135815]
[135816]
[135817]
[135818]
[135819]
[135820]
[135821]
[135822]
[135823]
[135824]
[135825]
[135826]
[135827]
[135828]
[135829]
[135830]
[135831]
[135832]
[135833]
[135834]
[135835]
[135836]
[135837]
[135838]
[135839]
[135840]
[135841]
[135842]
[135843]
[135844]
[135845]
[135846]
[135847]
[135848]
[135849]
[135850]
[135851]
[135852]
[135853]
[135854]
[135855]
[135856]
[135857]
[135858]
[135859]
[135860]
[135861]
[135862]
[135863]
[135864]
[135865]
[135866]
[135867]
[135868]
[135869]
[135870]
[135871]
[135872]
[135873]
[135874]
[135875]
[135876]
[135877]
[135878]
[135879]
[135880]
[135881]
[135882]
[135883]
[135884]
[135885]
[135886]
[135887]
[135888]
[135889]
[135890]
[135891]
[135892]
[135893]
[135894]
[135895]
[135896]
[135897]
[135898]
[135899]
[135900]
[135901]
[135902]
[135903]
[135904]
[135905]
[135906]
[135907]
[135908]
[135909]
[135910]
[135911]
[135912]
[135913]
[135914]
[135915]
[135916]
[135917]
[135918]
[135919]
[135920]
[135921]
[135922]
[135923]
[135924]
[135925]
[135926]
[135927]
[135928]
[135929]
[135930]
[135931]
[135932]
[135933]
[135934]
[135935]
[135936]
[135937]
[135938]
[135939]
[135940]
[135941]
[135942]
[135943]
[135944]
[135945]
[135946]
[135947]
[135948]
[135949]
[135950]
[135951]
[135952]
[135953]
[135954]
[135955]
[135956]
[135957]
[135958]
[135959]
[135960]
[135961]
[135962]
[135963]
[135964]
[135965]
[135966]
[135967]
[135968]
[135969]
[135970]
[135971]
[135972]
[135973]
[135974]
[135975]
[135976]
[135977]
[135978]
[135979]
[135980]
[135981]
[135982]
[135983]
[135984]
[135985]
[135986]
[135987]
[135988]
[135989]
[135990]
[135991]
[135992]
[135993]
[135994]
[135995]
[135996]
[135997]
[135998]
[135999]
[136000]
[136001]
[136002]
[136003]
[136004]
[136005]
[136006]
[136007]
[136008]
[136009]
[136010]
[136011]
[136012]
[136013]
[136014]
[136015]
[136016]
[136017]
[136018]
[136019]
[136020]
[136021]
[136022]
[136023]
[136024]
[136025]
[136026]
[136027]
[136028]
[136029]
[136030]
[136031]
[136032]
[136033]
[136034]
[136035]
[136036]
[136037]
[136038]
[136039]
[136040]
[136041]
[136042]
[136043]
[136044]
[136045]
[136046]
[136047]
[136048]
[136049]
[136050]
[136051]
[136052]
[136053]
[136054]
[136055]
[136056]
[136057]
[136058]
[136059]
[136060]
[136061]
[136062]
[136063]
[136064]
[136065]
[136066]
[136067]
[136068]
[136069]
[136070]
[136071]
[136072]
[136073]
[136074]
[136075]
[136076]
[136077]
[136078]
[136079]
[136080]
[136081]
[136082]
[136083]
[136084]
[136085]
[136086]
[136087]
[136088]
[136089]
[136090]
[136091]
[136092]
[136093]
[136094]
[136095]
[136096]
[136097]
[136098]
[136099]
[136100]
[136101]
[136102]
[136103]
[136104]
[136105]
[136106]
[136107]
[136108]
[136109]
[136110]
[136111]
[136112]
[136113]
[136114]
[136115]
[136116]
[136117]
[136118]
[136119]
[136120]
[136121]
[136122]
[136123]
[136124]
[136125]
[136126]
[136127]
[136128]
[136129]
[136130]
[136131]
[136132]
[136133]
[136134]
[136135]
[136136]
[136137]
[136138]
[136139]
[136140]
[136141]
[136142]
[136143]
[136144]
[136145]
[136146]
[136147]
[136148]
[136149]
[136150]
[136151]
[136152]
[136153]
[136154]
[136155]
[136156]
[136157]
[136158]
[136159]
[136160]
[136161]
[136162]
[136163]
[136164]
[136165]
[136166]
[136167]
[136168]
[136169]
[136170]
[136171]
[136172]
[136173]
[136174]
[136175]
[136176]
[136177]
[136178]
[136179]
[136180]
[136181]
[136182]
[136183]
[136184]
[136185]
[136186]
[136187]
[136188]
[136189]
[136190]
[136191]
[136192]
[136193]
[136194]
[136195]
[136196]
[136197]
[136198]
[136199]
[136200]
[136201]
[136202]
[136203]
[136204]
[136205]
[136206]
[136207]
[136208]
[136209]
[136210]
[136211]
[136212]
[136213]
[136214]
[136215]
[136216]
[136217]
[136218]
[136219]
[136220]
[136221]
[136222]
[136223]
[136224]
[136225]
[136226]
[136227]
[136228]
[136229]
[136230]
[136231]
[136232]
[136233]
[136234]
[136235]
[136236]
[136237]
[136238]
[136239]
[136240]
[136241]
[136242]
[136243]
[136244]
[136245]
[136246]
[136247]
[136248]
[136249]
[136250]
[136251]
[136252]
[136253]
[136254]
[136255]
[136256]
[136257]
[136258]
[136259]
[136260]
[136261]
[136262]
[136263]
[136264]
[136265]
[136266]
[136267]
[136268]
[136269]
[136270]
[136271]
[136272]
[136273]
[136274]
[136275]
[136276]
[136277]
[136278]
[136279]
[136280]
[136281]
[136282]
[136283]
[136284]
[136285]
[136286]
[136287]
[136288]
[136289]
[136290]
[136291]
[136292]
[136293]
[136294]
[136295]
[136296]
[136297]
[136298]
[136299]
[136300]
[136301]
[136302]
[136303]
[136304]
[136305]
[136306]
[136307]
[136308]
[136309]
[136310]
[136311]
[136312]
[136313]

{"sheet":"Case File Review","index":17,"n_rows":113,"n_cols":38,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,14,1,15]]}
[]
[null,"HMIS Questions per Case Record","12","9","10","5","6","13","Column7","Column8","Column9","UMP Question ","UMP Answer",null,"Additional Files"]
[null,"VETERAN STATUS:\nDo the client files include evidence of Veteran status (DD214, HINQ, etc.)? ",null,null,null,null,null,null,{"$f":"IF((COUNTIF(C3:H3,\"Yes\")+COUNTIF(C3:H3,\"No\"))<6,\"Complete Client File Review\",IF(COUNTIF(C3:H3,\"No\")>2,\"No\",\"Yes\"))","v":"Complete Client File Review"},"E7",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"E7",{"$f":"IF(D3=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""},null,1,8]
[null,"HOUSING STATUS:\nDo the files reviewed document the participants' housing status as either literally homeless or at-risk of literal homelessness at program entry?  Do prevention files contain an eligibility screener? ",null,null,null,null,null,null,{"$f":"IF((COUNTIF(C4:H4,\"Yes\")+COUNTIF(C4:H4,\"No\"))<6,\"Complete Client File Review\",IF(COUNTIF(C4:H4,\"No\")>2,\"No\",\"Yes\"))","v":"Complete Client File Review"},"E8",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"E8",{"$f":"IF(D4=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""},null,2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,"INCOME DOCUMENTATION:\nDo the files reviewed document each participant is a Veteran family whose annual income is at or below 50% of the area median income (in accordance with the most recent HUD AMI guidelines)? ",null,null,null,null,null,null,"Complete Client File Review","E9",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"E9",{"$f":"IF(D5=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""},null,7,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"RECERTIFICATIONS:\nDo the files reviewed document recertification of eligibility for each participant at least every 3 months? ",null,null,null,null,null,null,"Complete Client File Review","E10",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"E10",{"$f":"IF(C6=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""},null,14,4]
[null,"EXITS:\nIs the SSVF exit checklist in the client files that have been exited?",null,null,null,null,null,null,"Complete Client File Review","E11",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"E11",{"$f":"IF(C7=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""},null,15,3]
[null,"ROIs:\nAre there releases of information in the client files?",null,null,null,null,null,null,"Yes",null,{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"E12",{"$f":"IF(C8=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"HOUSING STABILITY PLANS:\nIs there an individualized housing stability plan that is developed with the active involvement participants served that identifies: \n  1.  Overall goals; \n  2.  Specific measureable objectives;\n  3.  Methods/techniques to be used to achieve the objectives; and\n  4.  Those responsible for implementation.",null,null,null,null,null,null,{"$f":"IF((COUNTIF(C9:H9,\"Yes\")+COUNTIF(C9:H9,\"No\"))<6,\"Complete Client File Review\",IF(COUNTIF(C9:H9,\"No\")>2,\"FAIL\",\"PASS\"))","v":"Complete Client File Review"},null,{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"F2",{"$f":"IF(C9=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"VA REFERRALS:\nDo the files reviewed document that participants were linked to VA services for which the participant may be eligible? Including but not limited to the following:\n     • Vocational and rehabilitation counseling             • Educational Assistance\n     • VA NSC or SC Pension                                           • Health Care Services",null,null,null,null,null,null,"Complete Client File Review","F3",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"F3",{"$f":"IF(C10=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"MAINSTREAM REFERRALS:\nDo the files reviewed document that participants were provided with assistance in obtaining and coordinating the provision of mainstream benefits? Including but not limited to the following:\n    • Health care services                                               • Income support services\n    • Daily living services                                               • Legal Services\n    • Personal financial planning services                      • Child Care\n    • Transportation services                                          • Housing Counseling \n    • Fiduciary and representative payee services",null,null,null,null,null,null,"Complete Client File Review","F4",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"F4",{"$f":"IF(C11=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"HOUSING COUNSELING:\nDo the case files demonstrate that the grantee is providing housing counseling to participants related to the stabilization of a participant’s residence in permanent housing? Including but not limited to the following:\n    • Housing search assistance                                 • Landlord tenant laws\n    • Rental and rent subsidy programs                    • Rent delinquency\n    • Federal, State, tribal or local assistance          • Home maintenance and budgeting \n    • Fair housing                                                       • Resolution/prevention of mortgage delinquency",null,null,null,null,null,null,"Complete Client File Review","F5",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"F5",{"$f":"IF(C12=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"ONGOING ASSESSMENTS OF STABILITY PLANS:\nDoes the grantee conduct ongoing assessments of the participants’ supportive services needs and review the coordinated housing stability plan with respect to expected outcomes?",null,null,null,null,null,null,"Complete Client File Review","F6",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"F6",{"$f":"IF(C13=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"CLIENT CHOICE:\nWas it clear in the file review that clients were allowed choice in determining their housing and stability plans?",null,null,null,null,null,null,"Complete Client File Review","F7",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"F7",{"$f":"IF(C14=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"RENT REASONABLENESS:\nDo the files reviewed document that the grantee assesses for rent reasonableness for Veterans receiving financial assistance and either staying in or moving into a new housing unit?",null,null,null,null,null,null,"Complete Client File Review","F8",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"F8",{"$f":"IF(C15=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"TFA LINKED TO HOUSING STABILITY:\nIf grant funds have been used for temporary assistance payments, is there documentation to demonstrate that such payments were necessary for maintaining independent living in permanent housing and housing stability?",null,null,null,null,null,null,"Complete Client File Review","F9",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"F9",{"$f":"IF(C16=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"HOUSING SEARCH ASSISTANCE:\nDo the files demonstrate the grantee is assisting clients with their housing search?",null,null,null,null,null,null,{"$f":"IF((COUNTIF(C17:H17,\"Yes\")+COUNTIF(C17:H17,\"No\"))<6,\"Complete Client File Review\",IF(COUNTIF(C17:H17,\"No\")>2,\"FAIL\",\"PASS\"))","v":"Complete Client File Review"},null,{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"F10",{"$f":"IF(C17=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"HABITABILITY INSPECTIONS:\nDo the files reviewed document that grantees conduct a habitability inspection on units for veterans receiving financial assistance AND moving into a new housing unit?",null,null,null,null,null,null,{"$f":"IF((COUNTIF(C18:H18,\"Yes\")+COUNTIF(C18:H18,\"No\"))<6,\"Complete Client File Review\",IF(COUNTIF(C18:H18,\"No\")>2,\"FAIL\",\"PASS\"))","v":"Complete Client File Review"},null,{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"F11",{"$f":"IF(C18=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"TFA TO THIRD PARTIES:\nDo the files reviewed adequately document that grantees ensure that all temporary financial assistance payments are provided to third parties?  ",null,null,null,null,null,null,"Complete Client File Review","G2",{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"G2",{"$f":"IF(C19=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"HMIS DATA ELEMENTS:\nIs client file data accurately entered into the grantee's HMIS system?  Data entered should include ALL of the following data elements and match client file information provided:\n    • Valid VAMC station codes\n    • Valid CoC code\n    • Valid Veteran SSN\n    • Residential move-in date (if applicable)\n    • Head of Household designation\n    • Housing Prevention Screener Scores/Threshold (if applicable)\n    • Services Provided\n    • Entry/Exit Date & Destination",null,null,null,null,null,null,{"$f":"IF((COUNTIF(C20:H20,\"Yes\")+COUNTIF(C20:H20,\"No\"))<6,\"Complete Client File Review\",IF(COUNTIF(C20:H20,\"No\")>2,\"FAIL\",\"PASS\"))","v":"Complete Client File Review"},null,{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"I5",{"$f":"IF(C20=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"HMIS TFA:\nAre TFA payment amounts accurately entered in HMIS and match client file information? ",null,null,null,null,null,null,{"$f":"IF((COUNTIF(C21:H21,\"Yes\")+COUNTIF(C21:H21,\"No\"))<6,\"Complete Client File Review\",IF(COUNTIF(C21:H21,\"No\")>2,\"FAIL\",\"PASS\"))","v":"Complete Client File Review"},null,{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"I6",{"$f":"IF(C21=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"No\", \"Yes\"))","v":""}]
[null,"INELIGIBLE/QUESTIONED COSTS:\nAny ineligible costs found or costs without proper backup documentation or invoices?","No","No","No","No","No","No",{"$f":"IF((COUNTIF(C22:H22,\"Yes\")+COUNTIF(C22:H22,\"No\"))<6,\"Complete Client File Review\",IF(COUNTIF(C22:H22,\"YES\")>0,\"FAIL\",\"PASS\"))","v":"PASS"},null,{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"Yes\")","v":0},"G12",{"$f":"IF(C22=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=1, \"Yes\", \"No\"))","v":"No"}]
[null,"AMOUNT OF INELIGIBLE/QUESTIONED COSTS:\nTotal of costs in question:",0,0,0,0,0,0,{"$f":"IF((COUNTIF(C23:H23,\"Yes\")+COUNTIF(C23:H23,\"No\"))<6,\"Complete Client File Review\",IF(COUNTIF(C23:H23,\"No\")>2,\"FAIL\",\"PASS\"))","v":"Complete Client File Review"},null,{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"Total for G12:",{"$f":"SUM(Table1[[#This Row],[12]:[13]])","v":0}]
[null,"TYPE OF INELIGIBLE/QUESTIONED COST:\nChoose from the drop down the type of cost for the issue found.","N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"IF((COUNTIF(C24:H24,\"Yes\")+COUNTIF(C24:H24,\"No\"))<6,\"Complete Client File Review\",IF(COUNTIF(C24:H24,\"No\")>2,\"FAIL\",\"PASS\"))","v":"Complete Client File Review"},null,{"$f":"COUNTIF(Table1[[#This Row],[12]:[13]],\"No\")","v":0},"Input reason in G12"]
[null,"Notes",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D25=\"\", \"\", IF(Table1[[#This Row],[Column9]]>=2, \"No\", \"Yes\"))","v":""}]
[]
[null,"Optional Checkbox for HMIS Reference"]
[null,"Not required to be completed, but used to assist monitor with HMIS questions:",{"$f":"Table1[[#Headers],[12]]","v":"12"},{"$f":"Table1[[#Headers],[9]]","v":"9"},{"$f":"Table1[[#Headers],[10]]","v":"10"},{"$f":"Table1[[#Headers],[5]]","v":"5"},{"$f":"Table1[[#Headers],[6]]","v":"6"},{"$f":"Table1[[#Headers],[13]]","v":"13"}]
[null,"Is correct VAMC station code in HMIS?"]
[null,"Is correct CoC code in HMIS?"]
[null,"Does Veteran SSN match?"]
[null,"Veteran move-in date/does it match?"]
[null,"Is correct HoH designated in HMIS?"]
[null,"If a prevention file, what is threshold score? Is threshold score in HMIS?"]
[null,"Is TFA in HMIS? What was total spent on client in the file? Does it match HMIS?"]
[null,"Are Services in HMIS? What services were in the file? Do they match HMIS?"]
[null,"What was entry date/does it match HMIS?"]
[null,"What was exit date/does it match HMIS?"]
[null,"What was exit designation/does it match HMIS?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rental Assistance"]
[null,"Security Deposit"]
[null,"Utility Deposit"]
[null,"Utility Payment"]
[null,"Transportation"]
[null,"Emergency Supplies"]
[null,"General Housing Stability Assistance"]
[null,"Moving Costs"]
[null,"Child Care"]
[null,"Emergency Housing/Hotels"]
[null,"Two or more categories"]
[null,"Other - Detail below"]
[null,"N/A"]

{"sheet":"CAP_Response_Form","index":18,"n_rows":108,"n_cols":12,"rows_kept":108,"cut":false,"hidden":false,"merged":[[21,1,21,11],[102,3,102,5],[103,3,103,5],[104,3,104,5],[105,3,105,5],[29,3,29,6],[30,3,30,6],[31,3,31,6],[32,3,32,6],[54,3,54,6],[55,3,55,6],[56,3,56,6],[57,3,57,6],[58,3,58,6],[59,3,59,6],[45,3,45,6],[12,3,12,5],[12,6,12,8],[15,2,15,8],[19,2,19,8],[0,6,0,7],[10,3,10,5],[10,6,10,8],[11,3,11,5],[11,6,11,8],[22,3,22,6],[23,3,23,6],[24,3,24,6],[25,3,25,6],[26,3,26,6],[52,3,52,6],[53,3,53,6],[43,3,43,6],[44,3,44,6],[35,3,35,6],[36,3,36,6],[40,3,40,6],[42,3,42,6],[50,3,50,6],[51,3,51,6],[47,3,47,6],[41,3,41,6],[27,3,27,6],[28,3,28,6],[46,3,46,6],[48,3,48,6],[49,3,49,6],[33,3,33,6],[34,3,34,6],[37,3,37,6],[38,3,38,6],[39,3,39,6],[72,3,72,6],[60,3,60,6],[61,3,61,6],[62,3,62,6],[63,3,63,6],[65,3,65,6],[66,3,66,6],[67,3,67,6],[68,3,68,6],[69,3,69,6],[70,3,70,6],[71,3,71,6],[64,3,64,6],[78,3,78,6],[79,3,79,6],[80,3,80,6],[81,3,81,6],[82,3,82,6],[73,3,73,6],[74,3,74,6],[75,3,75,6],[76,3,76,6],[77,3,77,6],[93,3,93,6],[94,3,94,6],[95,3,95,6],[96,3,96,6],[83,3,83,6],[88,3,88,6],[101,3,101,5],[14,1,14,9],[7,1,7,9],[8,1,8,9],[84,3,84,6],[85,3,85,6],[86,3,86,6],[87,3,87,6],[89,3,89,6],[90,3,90,6],[97,3,97,5],[98,3,98,5],[99,3,99,5],[100,3,100,5],[91,3,91,6],[92,3,92,6]]}
[null,null,null,null,null,null,"PROGRAM NUMBER:",null,{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Supportive Services for Veteran Families (SSVF)"]
[null,null,null,null,null,null,null,null,"Uniform Monitoring Package (UMP)"]
[]
[null,"Corrective Action Plan"]
[null,"NOTE: THIS FORM IS ONLY REQUIRED FOR GRANTEES RECEIVING A CORRECTIVE ACTION PLAN RESULT FROM THE SSVF PROGRAM OFFICE."]
[]
[null,null,null,"Grantee Name:",null,null,{"$f":"'Exhibit I Coverpage'!$C$11","v":0}]
[null,null,null,"Program Number:",null,null,{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[null,null,null,"Monitoring Date:",null,null,{"$f":"'Exhibit I Coverpage'!$C$17","v":"00:00:00"}]
[]
[null,"Instructions:"]
[null,"1.","The below report is prepopulated with all findings/concerns from Exhibit II of your monitoring report."]
[null,"2.","Please review and respond to all items with a finding/concern identfied.  Items with \"None\", \"PASS\" or \"N/A\" do not require a response."]
[null,"3.","Include the name of the person completing this form and date at the bottom of this page.  Attached completed plan with GIFTS requirement."]
[null,"4.","Upon receipt, the SSVF Program Office will review progress made toward addressing the concerns and recommendations. "]
[]
[]
[null,"Corrective Action Plan"]
[null,"Section","Item Number","Finding/Concern Identified",null,null,null,"Reason for the Non-Compliance and Plan to Address the Issue","Timeline/Action Steps for accomplishing corrective action and who will be involved in each step of the process","Describe system of internal controls to prevent reoccurrence","If a repeat finding:\nProvide documentation/evidence that the finding has been corrected. Attach in GIFTS. Evidence should include plan or system of internal controls to prevent the finding from reoccurring.","If a repeat finding:\nProvide analysis and reasoning for each repeat finding and the steps management will take to assure the SSVF Program Office of full grant compliance. "]
[null,"A",1,{"$f":"Exhibit_II!$C$39","v":"The number of participants served is not within 10% of the service number in the grant agreement."}]
[null,"A",2,{"$f":"Exhibit_II!$C$40","v":"The drawdown rate is not within 10% or less of the projected point in time expenditures."}]
[null,"A",3,{"$f":"Exhibit_II!$C$41","v":"The staffing level is not consistent with the grant agreement."}]
[null,"A","4a",{"$f":"Exhibit_II!$C$42","v":"The grantee is not within the 60% TFA spending for Rapid Re-Housing."}]
[null,"A","4b",{"$f":"Exhibit_II!$C$43","v":"The grantee is not within the 40% TFA spending for Rapid Re-Housing."}]
[null,"B",1,{"$f":"Exhibit_II!$C$57","v":"The grantee does not have written policies/procedures that describe how screening will be conducted."}]
[null,"B",2,{"$f":"Exhibit_II!$C$58","v":"The grantee does not have written policies/procedures that describe how program eligibility will be determined."}]
[null,"B",3,{"$f":"Exhibit_II!$C$59","v":"The grantee does not have written policies/procedures that describe how admissions are prioritized and who is responsible for making admission decisions."}]
[null,"B",4,{"$f":"Exhibit_II!$C$60","v":"The grantee does not have written policies/procedures describing ineligibility criteria."}]
[null,"B",5,{"$f":"Exhibit_II!$C$52","v":"The grantee does not register all program participants for the VA required Consumer Survey."}]
[null,"B",6,{"$f":"Exhibit_II!$C$61","v":"The grantee does not obtain input from program participants from VA Consumer Survey or other internal surveys."}]
[null,"B",7,{"$f":"Exhibit_II!$C$62","v":"The grantee does not work to end Veteran homelessness in conjunction with their Continuum(s) of Care (CoC) listed on their FY17 Resolution."}]
[null,"B",8,{"$f":"Exhibit_II!$C$53","v":"The grantee does not have clear procedures for reporting and following-up on critical incidents."}]
[null,"B",9,{"$f":"Exhibit_II!$C$63","v":"The grantee does not have procedures for providing and documenting supervision of personnel delivering services to participants."}]
[null,"B",10,{"$f":"Exhibit_II!$C$64","v":"The grantee does not have position descriptions for all staff listed on the approved budget."}]
[null,"B",11,{"$f":"Exhibit_II!$C$65","v":"The grantee does not have signed conflict of interest statements for their board of directors or other governing body."}]
[null,"B",12,{"$f":"Exhibit_II!$C$54","v":"The grantee does not have a clear practice in place for landlord recruitment and retainment for identifying new landlords, and providng support to landlords and tenants after move in ."}]
[null,"B",13,{"$f":"Exhibit_II!$C$66","v":"The grantee does not ensure that confidential information is secure and protected."}]
[null,"B",14,{"$f":"Exhibit_II!$C$67","v":"The grantee does not ensure that all SSVF staff have viewed the SSVF Fraud webinar."}]
[null,"C",1,{"$f":"Exhibit_II!$C$79","v":"N/A"}]
[null,"C",2,{"$f":"Exhibit_II!$C$80","v":"N/A"}]
[null,"C",3,{"$f":"Exhibit_II!$C$75","v":"N/A"}]
[null,"C",4,{"$f":"Exhibit_II!$C$81","v":"N/A"}]
[null,"C",5,{"$f":"Exhibit_II!$C$82","v":"N/A"}]
[null,"C",6,{"$f":"Exhibit_II!$C$76","v":"N/A"}]
[null,"D",1,{"$f":"Exhibit_II!$C$91","v":"The grantee does not conduct outreach to all the communities/CoCs listed in their FY17 Resolution."}]
[null,"D",2,{"$f":"Exhibit_II!$C$94","v":"The grantee does not have documentation showing where outreach is conducted and the frequency of outreach activities."}]
[null,"D",3,{"$f":"Exhibit_II!$C$95","v":"The grantee does not provide consistent outreach efforts throughout the entire service area that target the populations identified in their grant agreement."}]
[null,"D",4,{"$f":"Exhibit_II!$C$96","v":"The grantee does not provide outreach services to find and engage hard-to-reach, very low income veteran families throughout the service area."}]
[null,"D",5,{"$f":"Exhibit_II!$C$97","v":"The grantee does not receive referrals through coordinated entry, and/or the grantee does not engage in outreach activities with private organizations, state agencies, local government agencies, and other providers in the community."}]
[null,"E",1,{"$f":"Exhibit_II!$C$114","v":"Front line staff do not have a clear understanding of the process for determining eligibility."}]
[null,"E",2,{"$f":"Exhibit_II!$C$115","v":"When a person served is found ineligible for services, the grantee does not have a process to: inform the participant as to the reasons; recommend alternative services; notify the referral source as to the reasons, and/or notify the participant of grievance process."}]
[null,"E",3,{"$f":"Exhibit_II!$C$106","v":"Front line staff do not refer Veteran families to other resources if determined to be ineligible for SSVF services."}]
[null,"E",4,{"$f":"Exhibit_II!$C$116","v":"The grantee does not serve Veterans with zero income, criminal history, or other perceived housing barriers."}]
[null,"E",5,{"$f":"Exhibit_II!$C$117","v":"None"}]
[null,"E",6,{"$f":"Exhibit_II!$C$118","v":"None"}]
[null,"E",7,{"$f":"Exhibit_II!$C$107","v":"The client files do not include adequate evidence of Veteran status."}]
[null,"E",8,{"$f":"Exhibit_II!$C$108","v":"The files reviewed do not adequately document the participants' housing status as either literally homeless or at-risk of literal homelessness at program entry and/or prevention files do not include an eligibility screener."}]
[null,"E",9,{"$f":"Exhibit_II!$C$109","v":"The files reviewed do not adequately document that annual income is at or below 50% of the area median income (in accordance with the most recent HUD AMI guidelines)."}]
[null,"E",10,{"$f":"Exhibit_II!$C$110","v":"The files reviewed do not adequately document recertification of eligibility for each participant at least every 3 months."}]
[null,"E",11,{"$f":"Exhibit_II!$C$119","v":"The files reviewed do not adequately document the exit criteria for each client."}]
[null,"E",12,{"$f":"Exhibit_II!$C$111","v":"The files reviewed do not adequately document a release of information form in each client file."}]
[null,"F",1,{"$f":"Exhibit_II!$C$133","v":"The grantee is not providing all agreed upon supportive services to participants and based on an individualized housing-focused assessment. "}]
[null,"F",2,{"$f":"Exhibit_II!$C$134","v":"The grantee does not have housing stability plans that are developed with the active involvement participants."}]
[null,"F",3,{"$f":"Exhibit_II!$C$128","v":"The files reviewed do not adequately document that participants were linked to VA services."}]
[null,"F",4,{"$f":"Exhibit_II!$C$129","v":"The files reviewed do not adequately document that participants were provided with assistance in obtaining mainstream benefits."}]
[null,"F",5,{"$f":"Exhibit_II!$C$135","v":"Case files do not demonstrate that the grantee is providing housing counseling to participants related to the stabilization of a participant’s residence in permanent housing."}]
[null,"F",6,{"$f":"Exhibit_II!$C$136","v":"The grantee does not conduct ongoing assessments of the participants’ supportive services needs and review the coordinated housing stability plan."}]
[null,"F",7,{"$f":"Exhibit_II!$C$137","v":"The files reviewed do not adequately document that clients were allowed choice in their housing and stability plans."}]
[null,"F",8,{"$f":"Exhibit_II!$C$138","v":"The files reviewed do not adequately document that the grantee assesses for rent affordability for Veterans receiving financial assistance and either staying in or moving into a new housing unit."}]
[null,"F",9,{"$f":"Exhibit_II!$C$139","v":"Missing documentation demonstrating that financial assistance payments were necessary for maintaining independent living in permanent housing and housing stability."}]
[null,"F",10,{"$f":"Exhibit_II!$C$142","v":"The files reviewed do not demonstrate that the grantee is assisting clients with their housing search."}]
[null,"F",11,{"$f":"Exhibit_II!$C$130","v":"The files reviewed do not adequately document that grantees conduct a habitability inspection on units for veterans receiving financial assistance and moving into a new housing unit."}]
[null,"G",1,{"$f":"Exhibit_II!$C$156","v":"The grantee does not have written procedures for recording financial transactions; and a current accounting manual and a chart of accounts."}]
[null,"G",2,{"$f":"Exhibit_II!$C$149","v":"The files reviewed do not adequately document that grantees ensure that all TFA payments are provided to third parties and/or grantee does not verify payments are made to legitimate third party vendors."}]
[null,"G",3,{"$f":"Exhibit_II!$C$157","v":"The grantee does not maintain a policy manual covering the authority for approving financial transactions. "}]
[null,"G",4,{"$f":"Exhibit_II!$C$158","v":"Staff duties are not separated so that no one individual has complete authority over an entire financial transaction."}]
[null,"G",5,{"$f":"Exhibit_II!$C$159","v":"The grantee does not have written procedures regarding the maintenance of accounting records."}]
[null,"G",6,{"$f":"Exhibit_II!$C$160","v":"The grantee’s fiscal records and valuables are not secured in a limited access area."}]
[null,"G",7,{"$f":"Exhibit_II!$C$161","v":"The grantee does not identify, track and account for all costs (including administrative costs) charged to the SSVF grant."}]
[null,"G",8,{"$f":"Exhibit_II!$C$162","v":"Charges to SSVF for salaries and wages are not based on payroll documentation and approved by a responsible official of the organization being monitored."}]
[null,"G",9,{"$f":"Exhibit_II!$C$150","v":"Charges to SSVF for salaries and wages are not supported by records that accurately reflect the work performed."}]
[null,"G",10,{"$f":"Exhibit_II!$C$163","v":"For salaries paid from more than one source, fiscal records do not clearly define payments among the funding sources."}]
[null,"G",11,{"$f":"Exhibit_II!$C$151","v":"The HHS PMS withdrawal information does not match the information from the grantee’s drawdown requests tracking."}]
[null,"G",12,{"$f":"Exhibit_II!$C$152","v":"None"}]
[null,"G",13,{"$f":"Exhibit_II!$C$153","v":"This grantee has not completed their required A-133 audit in a timely manner. "}]
[null,"H",2,{"$f":"Exhibit_II!$C$174","v":"N/A"}]
[null,"H",3,{"$f":"Exhibit_II!$C$175","v":"N/A"}]
[null,"I",1,{"$f":"Exhibit_II!$C$189","v":"The grantee does not maintain a Comprehensive Data Quality Plan to ensure completeness, timeliness, and accuracy of HMIS data."}]
[null,"I",2,{"$f":"Exhibit_II!$C$190","v":"The Data Quality Plan does not specifically detail staff responsibility including:  timelines for data entry and HMIS Repository uploads, and ongoing quality assurance procedures."}]
[null,"I",3,{"$f":"Exhibit_II!$C$184","v":"The grantee does not successfully upload all client information into the SSVF HMIS Repository on a monthly basis."}]
[null,"I",4,{"$f":"Exhibit_II!$C$185","v":"The grantee is not entering or exporting data to all CoCs served."}]
[null,"I",5,{"$f":"Exhibit_II!$C$186","v":"Client file data is not accurately entered into the grantee's HMIS system."}]
[null,"I",6,{"$f":"Exhibit_II!$C$191","v":"TFA payments are not captured in the grantee's HMIS data and/or TFA amounts do not reconcile with client file documentation/HHS drawdowns."}]
[null,"Section G Supplement",2,"TFA Payment Review:",null,null,{"$f":"Exhibit_II!$E$198","v":"N/A"}]
[null,"Section G Supplement",3,"General Ledger Expense Review:",null,null,{"$f":"Exhibit_II!$E$199","v":"N/A"}]
[null,"Section G Supplement",4,"Payroll Review:",null,null,{"$f":"Exhibit_II!$E$200","v":"N/A"}]
[null,"Section G Supplement",5,"Administrative Review:",null,null,{"$f":"Exhibit_II!$E$201","v":"N/A"}]
[null,"Section G Supplement",6,"Subcontractor Review:",null,null,{"$f":"Exhibit_II!$E$202","v":"N/A"}]
[null,"Section C Supplement",2,"Management of SSVF Program:",null,null,{"$f":"Exhibit_II!$E$211","v":"N/A"}]
[null,"Section C Supplement",3,"Carrying Out MOU/Agreement:",null,null,{"$f":"Exhibit_II!$E$212","v":"N/A"}]
[null,"Section C Supplement",4,"File Review:",null,null,{"$f":"Exhibit_II!$E$213","v":"N/A"}]
[null,"Section C Supplement",5,"Financial Management:",null,null,{"$f":"Exhibit_II!$E$214","v":"N/A"}]
[null,"Name:"]
[null,"Date:"]

{"sheet":"Checkbox_Scoring","index":19,"n_rows":94,"n_cols":9,"rows_kept":94,"cut":false,"hidden":true,"merged":[[24,3,24,5]]}
["Checkbox Scoring"]
[]
[null,"Grant ID",{"$f":"'Exhibit I Coverpage'!$C$12","v":0}]
[]
["Section","Item","Section & Item","YSCORE","NSCORE","YSCORE2","RESULT","RESULT_NUMERIC","Exhibit II Result Message"]
["A",1,{"$f":"CONCATENATE(A6,B6)","v":"A1"},false,false,null,{"$f":"IF(AND($D$6=TRUE,$E$6=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$6=\"PASS\",1,IF($G$6=\"N/A\",1,0))","v":0},"The number of participants served is not within 10% of the service number in the grant agreement."]
["A",2,{"$f":"CONCATENATE(A7,B7)","v":"A2"},false,false,null,{"$f":"IF(AND($D$7=TRUE,$E$7=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$7=\"PASS\",1,IF($G$7=\"N/A\",1,0))","v":0},"The drawdown rate is not within 10% or less of the projected point in time expenditures."]
["A",3,"A3",false,false,false,{"$f":"IF(AND($D$8=TRUE,$F$8=FALSE,$E$8=FALSE),\"PASS\",(IF(AND($E$8=FALSE,$F$8=TRUE,$D$8=FALSE),\"PASS\",\"FAIL\")))","v":"FAIL"},{"$f":"IF($G$8=\"PASS\",1,IF($G$8=\"N/A\",1,0))","v":0},"The staffing level is not consistent with the grant agreement."]
["A","4a","A4a",false,false,false,{"$f":"IF(AND($D$9=TRUE,$F$9=FALSE,$E$9=FALSE),\"PASS\",(IF(AND($E$9=FALSE,$F$9=TRUE,$D$9=FALSE),\"PASS\",\"FAIL\")))","v":"FAIL"},{"$f":"IF($G$9=\"PASS\",1,IF($G$9=\"N/A\",1,0))","v":0},"The grantee is not within the 60% TFA spending for Rapid Re-Housing."]
["A","4b","A4b",false,false,false,{"$f":"IF(AND($D$10=TRUE,$F$10=FALSE,$E$10=FALSE),\"PASS\",(IF(AND($E$10=FALSE,$F$10=TRUE,$D$10=FALSE),\"PASS\",\"FAIL\")))","v":"FAIL"},{"$f":"IF($G$10=\"PASS\",1,IF($G$10=\"N/A\",1,0))","v":0},"The grantee is not within the 40% TFA spending for Rapid Re-Housing."]
["B",1,"B1",false,false,null,{"$f":"IF(AND($D$11=TRUE,$E$11=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$11=\"PASS\",1,IF($G$11=\"N/A\",1,0))","v":0},"The grantee does not have written policies/procedures that describe how screening will be conducted."]
["B",2,"B2",false,false,null,{"$f":"IF(AND($D$12=TRUE,$E$12=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$12=\"PASS\",1,IF($G$12=\"N/A\",1,0))","v":0},"The grantee does not have written policies/procedures that describe how program eligibility will be determined."]
["B",3,"B3",false,false,null,{"$f":"IF(AND($D$13=TRUE,$E$13=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$13=\"PASS\",1,IF($G$13=\"N/A\",1,0))","v":0},"The grantee does not have written policies/procedures that describe how admissions are prioritized and who is responsible for making admission decisions."]
["B",4,"B4",false,false,null,{"$f":"IF(AND($D$14=TRUE,$E$14=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$14=\"PASS\",1,IF($G$14=\"N/A\",1,0))","v":0},"The grantee does not have written policies/procedures describing ineligibility criteria."]
["B",5,"B5",false,false,null,{"$f":"IF(AND($D$15=TRUE,$E$15=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$15=\"PASS\",1,IF($G$15=\"N/A\",1,0))","v":0},"The grantee does not register all program participants for the VA required Consumer Survey."]
["B",6,"B6",false,false,null,{"$f":"IF(AND($D$16=TRUE,$E$16=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$16=\"PASS\",1,IF($G$16=\"N/A\",1,0))","v":0},"The grantee does not obtain input from program participants from VA Consumer Survey or other internal surveys."]
["B",7,"B7",false,false,null,{"$f":"IF(AND($D$17=TRUE,$E$17=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$17=\"PASS\",1,IF($G$17=\"N/A\",1,0))","v":0},"The grantee does not work to end Veteran homelessness in conjunction with their Continuum(s) of Care (CoC) listed on their FY17 Resolution."]
["B",8,"B8",false,false,null,{"$f":"IF(AND($D$18=TRUE,$E$18=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$18=\"PASS\",1,IF($G$18=\"N/A\",1,0))","v":0},"The grantee does not have clear procedures for reporting and following-up on critical incidents."]
["B",9,"B9",false,false,null,{"$f":"IF(AND($D$19=TRUE,$E$19=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$19=\"PASS\",1,IF($G$19=\"N/A\",1,0))","v":0},"The grantee does not have procedures for providing and documenting supervision of personnel delivering services to participants."]
["B",10,"B10",false,false,null,{"$f":"IF(AND($D$20=TRUE,$E$20=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$20=\"PASS\",1,IF($G$20=\"N/A\",1,0))","v":0},"The grantee does not have position descriptions for all staff listed on the approved budget."]
["B",11,"B11",false,false,null,{"$f":"IF(AND($D$21=TRUE,$E$21=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$21=\"PASS\",1,IF($G$21=\"N/A\",1,0))","v":0},"The grantee does not have signed conflict of interest statements for their board of directors or other governing body."]
["B",12,"B12",false,false,null,{"$f":"IF(AND($D$22=TRUE,$E$22=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$22=\"PASS\",1,IF($G$22=\"N/A\",1,0))","v":0},"The grantee does not have a clear practice in place for landlord recruitment and retainment for identifying new landlords, and providng support to landlords and tenants after move in ."]
["B",13,"B13",false,false,null,{"$f":"IF(AND($D$23=TRUE,$E$23=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$23=\"PASS\",1,IF($G$23=\"N/A\",1,0))","v":0},"The grantee does not ensure that confidential information is secure and protected."]
["B",14,"B14",false,false,null,{"$f":"IF(AND($D$24=TRUE,$E$24=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$24=\"PASS\",1,IF($G$24=\"N/A\",1,0))","v":0},"The grantee does not ensure that all SSVF staff have viewed the SSVF Fraud webinar."]
["C","1a","C1a",null,null,null,{"$f":"'Section C'!$H$9","v":"No"}]
["C",1,"C1",false,false,null,{"$f":"IF($G$25=\"No\",\"N/A\",IF(AND($D$26=TRUE,$E$26=FALSE),\"PASS\",\"FAIL\"))","v":"N/A"},{"$f":"IF($G$26=\"PASS\",1,IF($G$26=\"N/A\",1,0))","v":1},"The grantee does not have written policies and procedures, or language in the subcontractor agreement, which details how the grantee will manage and monitor the work of the subcontractor."]
["C",2,"C2",false,false,null,{"$f":"IF($G$25=\"No\",\"N/A\",IF(AND($D$27=TRUE,$E$27=FALSE),\"PASS\",\"FAIL\"))","v":"N/A"},{"$f":"IF($G$27=\"PASS\",1,IF($G$27=\"N/A\",1,0))","v":1},"The grantee does not have copies of each subcontractor’s policies and procedures specific to SSVF."]
["C",3,"C3",false,false,null,{"$f":"IF($G$25=\"No\",\"N/A\",IF(AND($D$28=TRUE,$E$28=FALSE),\"PASS\",\"FAIL\"))","v":"N/A"},{"$f":"IF($G$28=\"PASS\",1,IF($G$28=\"N/A\",1,0))","v":1},"The grantee has not executed written agreements with its subcontractors to carry out program activities (signed MOUs/MOAs)?"]
["C",4,"C4",false,false,null,{"$f":"IF($G$25=\"No\",\"N/A\",IF(AND($D$29=TRUE,$E$29=FALSE),\"PASS\",\"FAIL\"))","v":"N/A"},{"$f":"IF($G$29=\"PASS\",1,IF($G$29=\"N/A\",1,0))","v":1},"Written agreements do not contain descriptions of the type of supportive service activities that the subcontractor will perform."]
["C",5,"C5",false,false,null,{"$f":"IF($G$25=\"No\",\"N/A\",IF(AND($D$30=TRUE,$E$30=FALSE),\"PASS\",\"FAIL\"))","v":"N/A"},{"$f":"IF($G$30=\"PASS\",1,IF($G$30=\"N/A\",1,0))","v":1},"The grantee does not have a system or method for amending subcontractor agreements."]
["C",6,{"$f":"CONCATENATE(A31,B31)","v":"C6"},false,false,null,{"$f":"IF($G$25=\"No\",\"N/A\",IF(AND($D$31=TRUE,$E$31=FALSE),\"PASS\",\"FAIL\"))","v":"N/A"},{"$f":"IF($G$30=\"PASS\",1,IF($G$30=\"N/A\",1,0))","v":1},"The grantee does not assess the performance of subcontractors quarterly and at annual on-site monitorings."]
["D",1,"D1",false,false,null,{"$f":"IF(AND($D$32=TRUE,$E$32=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$32=\"PASS\",1,IF($G$32=\"N/A\",1,0))","v":0},"The grantee does not conduct outreach to all the communities/CoCs listed in their FY17 Resolution."]
["D",2,"D2",false,false,null,{"$f":"IF(AND($D$33=TRUE,$E$33=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$33=\"PASS\",1,IF($G$33=\"N/A\",1,0))","v":0},"The grantee does not have documentation showing where outreach is conducted and the frequency of outreach activities."]
["D",3,"D3",false,false,null,{"$f":"IF(AND($D$34=TRUE,$E$34=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$34=\"PASS\",1,IF($G$34=\"N/A\",1,0))","v":0},"The grantee does not provide consistent outreach efforts throughout the entire service area that target the populations identified in their grant agreement."]
["D",4,"D4",false,false,null,{"$f":"IF(AND($D$35=TRUE,$E$35=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$35=\"PASS\",1,IF($G$35=\"N/A\",1,0))","v":0},"The grantee does not provide outreach services to find and engage hard-to-reach, very low income veteran families throughout the service area."]
["D",5,"D5",false,false,null,{"$f":"IF(AND($D$36=TRUE,$E$36=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$36=\"PASS\",1,IF($G$36=\"N/A\",1,0))","v":0},"The grantee does not receive referrals through coordinated entry, and/or the grantee does not engage in outreach activities with private organizations, state agencies, local government agencies, and other providers in the community."]
["E",1,"E1",false,false,null,{"$f":"IF(AND($D$37=TRUE,$E$37=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$37=\"PASS\",1,IF($G$37=\"N/A\",1,0))","v":0},"Front line staff do not have a clear understanding of the process for determining eligibility."]
["E",2,"E2",false,false,null,{"$f":"IF(AND($D$38=TRUE,$E$38=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$38=\"PASS\",1,IF($G$38=\"N/A\",1,0))","v":0},"When a person served is found ineligible for services, the grantee does not have a process to: inform the participant as to the reasons; recommend alternative services; notify the referral source as to the reasons, and/or notify the participant of grievance process."]
["E",3,"E3",false,false,null,{"$f":"IF(AND($D$39=TRUE,$E$39=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$39=\"PASS\",1,IF($G$39=\"N/A\",1,0))","v":0},"Front line staff do not refer Veteran families to other resources if determined to be ineligible for SSVF services."]
["E",4,"E4",false,false,null,{"$f":"IF(AND($D$40=TRUE,$E$40=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$40=\"PASS\",1,IF($G$40=\"N/A\",1,0))","v":0},"The grantee does not serve Veterans with zero income, criminal history, or other perceived housing barriers."]
["E",5,"E5",false,false,null,{"$f":"IF(AND($D$41=TRUE,$E$41=FALSE),\"FAIL\",\"PASS\")","v":"PASS"},{"$f":"IF($G$41=\"PASS\",1,IF($G$41=\"N/A\",1,0))","v":1},"Greater than 30% of the grantee's referrals come from HUD-VASH or GPD."]
["E",6,"E6",false,false,null,{"$f":"IF(AND($D$42=TRUE,$E$42=FALSE),\"FAIL\",\"PASS\")","v":"PASS"},{"$f":"IF($G$42=\"PASS\",1,IF($G$42=\"N/A\",1,0))","v":1},"Veterans are required to participant in supportive services prior to obtaining housing assistance."]
["E",7,"E7",false,false,null,{"$f":"IF(AND($D$43=TRUE,$E$43=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$43=\"PASS\",1,IF($G$43=\"N/A\",1,0))","v":0},"The client files do not include adequate evidence of Veteran status."]
["E",8,"E8",false,false,null,{"$f":"IF(AND($D$44=TRUE,$E$44=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$44=\"PASS\",1,IF($G$44=\"N/A\",1,0))","v":0},"The files reviewed do not adequately document the participants' housing status as either literally homeless or at-risk of literal homelessness at program entry and/or prevention files do not include an eligibility screener."]
["E",9,"E9",false,false,null,{"$f":"IF(AND($D$45=TRUE,$E$45=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$45=\"PASS\",1,IF($G$45=\"N/A\",1,0))","v":0},"The files reviewed do not adequately document that annual income is at or below 50% of the area median income (in accordance with the most recent HUD AMI guidelines)."]
["E",10,"E10",false,false,false,{"$f":"IF(AND($D$46=TRUE,$F$46=FALSE,$E$46=FALSE),\"PASS\",(IF(AND($E$46=FALSE,$F$46=TRUE,$D$46=FALSE),\"PASS\",\"FAIL\")))","v":"FAIL"},{"$f":"IF($G$46=\"PASS\",1,IF($G$46=\"N/A\",1,0))","v":0},"The files reviewed do not adequately document recertification of eligibility for each participant at least every 3 months."]
["E",11,"E11",false,false,null,{"$f":"IF(AND($D$47=TRUE,$E$47=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$47=\"PASS\",1,IF($G$47=\"N/A\",1,0))","v":0},"The files reviewed do not adequately document the exit criteria for each client."]
["E",12,"E12",false,false,null,{"$f":"IF(AND($D$48=TRUE,$E$48=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$48=\"PASS\",1,IF($G$48=\"N/A\",1,0))","v":0},"The files reviewed do not adequately document a release of information form in each client file."]
["F",1,"F1",false,false,null,{"$f":"IF(AND($D$49=TRUE,$E$49=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$49=\"PASS\",1,IF($G$49=\"N/A\",1,0))","v":0},"The grantee is not providing all agreed upon supportive services to participants and based on an individualized housing-focused assessment. "]
["F",2,"F2",false,false,null,{"$f":"IF(AND($D$50=TRUE,$E$50=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$50=\"PASS\",1,IF($G$50=\"N/A\",1,0))","v":0},"The grantee does not have housing stability plans that are developed with the active involvement participants."]
["F",3,"F3",false,false,null,{"$f":"IF(AND($D$51=TRUE,$E$51=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$51=\"PASS\",1,IF($G$51=\"N/A\",1,0))","v":0},"The files reviewed do not adequately document that participants were linked to VA services."]
["F",4,"F4",false,false,null,{"$f":"IF(AND($D$52=TRUE,$E$52=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$52=\"PASS\",1,IF($G$52=\"N/A\",1,0))","v":0},"The files reviewed do not adequately document that participants were provided with assistance in obtaining mainstream benefits."]
["F",5,"F5",false,false,null,{"$f":"IF(AND($D$53=TRUE,$E$53=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$53=\"PASS\",1,IF($G$53=\"N/A\",1,0))","v":0},"Case files do not demonstrate that the grantee is providing housing counseling to participants related to the stabilization of a participant’s residence in permanent housing."]
["F",6,"F6",false,false,null,{"$f":"IF(AND($D$54=TRUE,$E$54=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$54=\"PASS\",1,IF($G$54=\"N/A\",1,0))","v":0},"The grantee does not conduct ongoing assessments of the participants’ supportive services needs and review the coordinated housing stability plan."]
["F",7,"F7",false,false,null,{"$f":"IF(AND($D$55=TRUE,$E$55=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$55=\"PASS\",1,IF($G$55=\"N/A\",1,0))","v":0},"The files reviewed do not adequately document that clients were allowed choice in their housing and stability plans."]
["F",8,"F8",false,false,null,{"$f":"IF(AND($D$56=TRUE,$E$56=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$56=\"PASS\",1,IF($G$56=\"N/A\",1,0))","v":0},"The files reviewed do not adequately document that the grantee assesses for rent affordability for Veterans receiving financial assistance and either staying in or moving into a new housing unit."]
["F",9,"F9",false,false,null,{"$f":"IF(AND($D$57=TRUE,$E$57=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$57=\"PASS\",1,IF($G$57=\"N/A\",1,0))","v":0},"Missing documentation demonstrating that financial assistance payments were necessary for maintaining independent living in permanent housing and housing stability."]
["F",10,"F10",false,false,null,{"$f":"IF(AND($D$58=TRUE,$E$58=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$58=\"PASS\",1,IF($G$58=\"N/A\",1,0))","v":0},"The files reviewed do not demonstrate that the grantee is assisting clients with their housing search."]
["F",11,"F11",false,false,null,{"$f":"IF(AND($D$59=TRUE,$E$59=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$59=\"PASS\",1,IF($G$59=\"N/A\",1,0))","v":0},"The files reviewed do not adequately document that grantees conduct a habitability inspection on units for veterans receiving financial assistance and moving into a new housing unit."]
["G",1,"G1",false,false,null,{"$f":"IF(AND($D$60=TRUE,$E$60=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$60=\"PASS\",1,IF($G$60=\"N/A\",1,0))","v":0},"The grantee does not have written procedures for recording financial transactions; and a current accounting manual and a chart of accounts."]
["G",2,"G2",false,false,null,{"$f":"IF(AND($D$61=TRUE,$E$61=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$61=\"PASS\",1,IF($G$61=\"N/A\",1,0))","v":0},"The files reviewed do not adequately document that grantees ensure that all TFA payments are provided to third parties and/or grantee does not verify payments are made to legitimate third party vendors."]
["G",3,"G3",false,false,null,{"$f":"IF(AND($D$62=TRUE,$E$62=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$62=\"PASS\",1,IF($G$62=\"N/A\",1,0))","v":0},"The grantee does not maintain a policy manual covering the authority for approving financial transactions. "]
["G",4,"G4",false,false,null,{"$f":"IF(AND($D$63=TRUE,$E$63=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$63=\"PASS\",1,IF($G$63=\"N/A\",1,0))","v":0},"Staff duties are not separated so that no one individual has complete authority over an entire financial transaction."]
["G",5,"G5",false,false,null,{"$f":"IF(AND($D$64=TRUE,$E$64=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$64=\"PASS\",1,IF($G$64=\"N/A\",1,0))","v":0},"The grantee does not have written procedures regarding the maintenance of accounting records."]
["G",6,"G6",false,false,null,{"$f":"IF(AND($D$65=TRUE,$E$65=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$65=\"PASS\",1,IF($G$65=\"N/A\",1,0))","v":0},"The grantee’s fiscal records and valuables are not secured in a limited access area."]
["G",7,"G7",false,false,null,{"$f":"IF(AND($D$66=TRUE,$E$66=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$66=\"PASS\",1,IF($G$66=\"N/A\",1,0))","v":0},"The grantee does not identify, track and account for all costs (including administrative costs) charged to the SSVF grant."]
["G",8,"G8",false,false,null,{"$f":"IF(AND($D$67=TRUE,$E$67=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$67=\"PASS\",1,IF($G$67=\"N/A\",1,0))","v":0},"Charges to SSVF for salaries and wages are not based on payroll documentation and approved by a responsible official of the organization being monitored."]
["G",9,"G9",false,false,null,{"$f":"IF(AND($D$68=TRUE,$E$68=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$68=\"PASS\",1,IF($G$68=\"N/A\",1,0))","v":0},"Charges to SSVF for salaries and wages are not supported by records that accurately reflect the work performed."]
["G",10,"G10",false,false,null,{"$f":"IF(AND($D$69=TRUE,$E$69=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$69=\"PASS\",1,IF($G$69=\"N/A\",1,0))","v":0},"For salaries paid from more than one source, fiscal records do not clearly define payments among the funding sources."]
["G",11,"G11",false,false,null,{"$f":"IF(AND($D$70=TRUE,$E$70=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$70=\"PASS\",1,IF($G$70=\"N/A\",1,0))","v":0},"The HHS PMS withdrawal information does not match the information from the grantee’s drawdown requests tracking."]
["G",12,"G12",false,false,null,{"$f":"IF(AND($D$71=TRUE,$E$71=FALSE),\"FAIL\",\"PASS\")","v":"PASS"},{"$f":"IF($G$71=\"PASS\",1,IF($G$71=\"N/A\",1,0))","v":1},"There is evidence that ineligible expenses have been paid with SSVF funds."]
["G",13,{"$f":"CONCATENATE(A72,B72)","v":"G13"},false,false,false,{"$f":"IF(AND($D$72=TRUE,$F$72=FALSE,$E$72=FALSE),\"PASS\",(IF(AND($E$72=FALSE,$F$72=TRUE,$D$72=FALSE),\"PASS\",\"FAIL\")))","v":"FAIL"},{"$f":"IF($G$72=\"PASS\",1,IF($G$72=\"N/A\",1,0))","v":0},"This grantee has not completed their required A-133 audit in a timely manner. "]
["H",1,"H1",null,null,null,{"$f":"'Section H'!$H$9","v":"No"}]
["H",2,"H2",false,false,null,{"$f":"IF($G$73=\"No\",\"N/A\",IF(AND($D$74=TRUE,$E$74=FALSE),\"PASS\",\"FAIL\"))","v":"N/A"},{"$f":"IF($G$74=\"PASS\",1,IF($G$74=\"N/A\",1,0))","v":1},"Vehicles are not operational and being used as outlined in the grant agreement."]
["H",3,{"$f":"CONCATENATE(A75,B75)","v":"H3"},false,false,null,{"$f":"IF($G$73=\"No\",\"N/A\",IF(AND($D$75=TRUE,$E$75=FALSE),\"PASS\",\"FAIL\"))","v":"N/A"},{"$f":"IF($G$75=\"PASS\",1,IF($G$75=\"N/A\",1,0))","v":1},"Missing evidence of valid licenses for all drivers, insurance covering passengers, safety equipment, etc."]
["I",1,"I1",false,false,null,{"$f":"IF(AND($D$76=TRUE,$E$76=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$76=\"PASS\",1, 0)","v":0},"The grantee does not maintain a Comprehensive Data Quality Plan to ensure completeness, timeliness, and accuracy of HMIS data."]
["I",2,"I2",false,false,null,{"$f":"IF(AND($D$77=TRUE,$E$77=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$77=\"PASS\",1,0)","v":0},"The Data Quality Plan does not specifically detail staff responsibility including:  timelines for data entry and HMIS Repository uploads, and ongoing quality assurance procedures."]
["I",3,"I3",false,false,null,{"$f":"IF(AND($D$78=TRUE,$E$78=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$78=\"PASS\",1,0)","v":0},"The grantee does not successfully upload all client information into the SSVF HMIS Repository on a monthly basis."]
["I",4,"I4",false,false,null,{"$f":"IF(AND($D$79=TRUE,$E$79=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$79=\"PASS\",1,0)","v":0},"The grantee is not entering or exporting data to all CoCs served."]
["I",5,"I5",false,false,null,{"$f":"IF(AND($D$80=TRUE,$E$80=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$80=\"PASS\",1,0)","v":0},"Client file data is not accurately entered into the grantee's HMIS system."]
["I",6,"I6",false,false,null,{"$f":"IF(AND($D$81=TRUE,$E$81=FALSE),\"PASS\",\"FAIL\")","v":"FAIL"},{"$f":"IF($G$81=\"PASS\",1,0)","v":0},"TFA payments are not captured in the grantee's HMIS data and/or TFA amounts do not reconcile with client file documentation/HHS drawdowns."]
["GS",1,"GS1",null,null,null,{"$f":"'Section G_Supplement'!$D$9","v":"No"}]
["GS",2,"GS2",null,null,null,{"$f":"IF($G$82=\"No\",\"N/A\",'Section G_Supplement'!$C$120)","v":"N/A"},{"$f":"IF($G$83=\"PASS\",1,IF($G$83=\"N/A\",1,0))","v":1}]
["GS",3,"GS3",null,null,null,{"$f":"IF($G$82=\"No\",\"N/A\",'Section G_Supplement'!$C$140)","v":"N/A"},{"$f":"IF($G$84=\"PASS\",1,IF($G$84=\"N/A\",1,0))","v":1}]
["GS",4,"GS4",null,null,null,{"$f":"IF($G$82=\"No\",\"N/A\",'Section G_Supplement'!$C$150)","v":"N/A"},{"$f":"IF($G$85=\"PASS\",1,IF($G$85=\"N/A\",1,0))","v":1}]
["GS",5,"GS5",null,null,null,{"$f":"IF($G$82=\"No\",\"N/A\",'Section G_Supplement'!$C$160)","v":"N/A"},{"$f":"IF($G$86=\"PASS\",1,IF($G$86=\"N/A\",1,0))","v":1}]
["GS",6,"GS6",null,null,null,{"$f":"IF($G$82=\"No\",\"N/A\",'Section G_Supplement'!$C$173)","v":"N/A"},{"$f":"IF($G$87=\"PASS\",1,IF($G$87=\"N/A\",1,0))","v":1}]
["GS",7,"GS7",null,null,null,{"$f":"IF($G$82=\"No\",\"N/A\",'Section G_Supplement'!$C$175)","v":"N/A"},{"$f":"IF($G$88=\"PASS\",1,IF($G$88=\"N/A\",1,0))","v":1}]
[null,null,"Sub1",null,null,null,{"$f":"'Section C_Supplement'!$E$9","v":"No"}]
[null,null,"Sub2",null,null,null,{"$f":"IF($G$89=\"No\",\"N/A\",'Section C_Supplement'!$C$29)","v":"N/A"},{"$f":"IF($G$90=\"PASS\",1,IF($G$90=\"N/A\",1,0))","v":1}]
[null,null,"Sub3",null,null,null,{"$f":"IF($G$89=\"No\",\"N/A\",'Section C_Supplement'!$C$47)","v":"N/A"},{"$f":"IF($G$91=\"PASS\",1,IF($G$91=\"N/A\",1,0))","v":1}]
[null,null,"Sub4",null,null,null,{"$f":"IF($G$89=\"No\",\"N/A\",'Section C_Supplement'!$C$77)","v":"N/A"},{"$f":"IF($G$92=\"PASS\",1,IF($G$92=\"N/A\",1,0))","v":1}]
[null,null,"Sub5",null,null,null,{"$f":"IF($G$89=\"No\",\"N/A\",'Section C_Supplement'!$C$97)","v":"N/A"},{"$f":"IF($G$93=\"PASS\",1,IF($G$93=\"N/A\",1,0))","v":1}]
[null,null,"Sub6",null,null,null,{"$f":"IF($G$89=\"No\",\"N/A\",'Section C_Supplement'!$C$100)","v":"N/A"},{"$f":"IF($G$94=\"PASS\",1,IF($G$94=\"N/A\",1,0))","v":1}]

{"sheet":"Data_Export","index":20,"n_rows":2,"n_cols":80,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Checkbox_Scoring!$B$3","v":"Grant ID"},{"$f":"Checkbox_Scoring!$C$6","v":"A1"},{"$f":"Checkbox_Scoring!$C$7","v":"A2"},{"$f":"Checkbox_Scoring!$C$8","v":"A3"},{"$f":"Checkbox_Scoring!$C$9","v":"A4a"},{"$f":"Checkbox_Scoring!$C$10","v":"A4b"},{"$f":"Checkbox_Scoring!$C$11","v":"B1"},{"$f":"Checkbox_Scoring!$C$12","v":"B2"},{"$f":"Checkbox_Scoring!$C$13","v":"B3"},{"$f":"Checkbox_Scoring!$C$14","v":"B4"},{"$f":"Checkbox_Scoring!$C$15","v":"B5"},{"$f":"Checkbox_Scoring!$C$16","v":"B6"},{"$f":"Checkbox_Scoring!$C$17","v":"B7"},{"$f":"Checkbox_Scoring!$C$18","v":"B8"},{"$f":"Checkbox_Scoring!$C$19","v":"B9"},{"$f":"Checkbox_Scoring!$C$20","v":"B10"},{"$f":"Checkbox_Scoring!$C$21","v":"B11"},{"$f":"Checkbox_Scoring!$C$22","v":"B12"},{"$f":"Checkbox_Scoring!$C$23","v":"B13"},{"$f":"Checkbox_Scoring!$C$25","v":"C1a"},{"$f":"Checkbox_Scoring!$C$26","v":"C1"},{"$f":"Checkbox_Scoring!$C$27","v":"C2"},{"$f":"Checkbox_Scoring!$C$28","v":"C3"},{"$f":"Checkbox_Scoring!$C$29","v":"C4"},{"$f":"Checkbox_Scoring!$C$30","v":"C5"},{"$f":"Checkbox_Scoring!$C$32","v":"D1"},{"$f":"Checkbox_Scoring!$C$33","v":"D2"},{"$f":"Checkbox_Scoring!$C$34","v":"D3"},{"$f":"Checkbox_Scoring!$C$35","v":"D4"},{"$f":"Checkbox_Scoring!$C$36","v":"D5"},{"$f":"Checkbox_Scoring!$C$37","v":"E1"},{"$f":"Checkbox_Scoring!$C$38","v":"E2"},{"$f":"Checkbox_Scoring!$C$39","v":"E3"},{"$f":"Checkbox_Scoring!$C$40","v":"E4"},{"$f":"Checkbox_Scoring!$C$41","v":"E5"},{"$f":"Checkbox_Scoring!$C$42","v":"E6"},{"$f":"Checkbox_Scoring!$C$43","v":"E7"},{"$f":"Checkbox_Scoring!$C$44","v":"E8"},{"$f":"Checkbox_Scoring!$C$45","v":"E9"},{"$f":"Checkbox_Scoring!$C$46","v":"E10"},{"$f":"Checkbox_Scoring!$C$47","v":"E11"},{"$f":"Checkbox_Scoring!$C$49","v":"F1"},{"$f":"Checkbox_Scoring!$C$50","v":"F2"},{"$f":"Checkbox_Scoring!$C$51","v":"F3"},{"$f":"Checkbox_Scoring!$C$52","v":"F4"},{"$f":"Checkbox_Scoring!$C$53","v":"F5"},{"$f":"Checkbox_Scoring!$C$54","v":"F6"},{"$f":"Checkbox_Scoring!$C$55","v":"F7"},{"$f":"Checkbox_Scoring!$C$56","v":"F8"},{"$f":"Checkbox_Scoring!$C$57","v":"F9"},{"$f":"Checkbox_Scoring!$C$58","v":"F10"},{"$f":"Checkbox_Scoring!$C$59","v":"F11"},{"$f":"Checkbox_Scoring!$C$60","v":"G1"},{"$f":"Checkbox_Scoring!$C$61","v":"G2"},{"$f":"Checkbox_Scoring!$C$62","v":"G3"},{"$f":"Checkbox_Scoring!$C$63","v":"G4"},{"$f":"Checkbox_Scoring!$C$64","v":"G5"},{"$f":"Checkbox_Scoring!$C$65","v":"G6"},{"$f":"Checkbox_Scoring!$C$66","v":"G7"},{"$f":"Checkbox_Scoring!$C$67","v":"G8"},{"$f":"Checkbox_Scoring!$C$68","v":"G9"},{"$f":"Checkbox_Scoring!$C$69","v":"G10"},{"$f":"Checkbox_Scoring!$C$70","v":"G11"},{"$f":"Checkbox_Scoring!$C$71","v":"G12"},{"$f":"Checkbox_Scoring!$C$73","v":"H1"},{"$f":"Checkbox_Scoring!$C$74","v":"H2"},{"$f":"Checkbox_Scoring!$C$75","v":"H3"},"I1","I2","I3","I4","I5","I6",{"$f":"Checkbox_Scoring!$C$82","v":"GS1"},{"$f":"Checkbox_Scoring!$C$83","v":"GS2"},{"$f":"Checkbox_Scoring!$C$84","v":"GS3"},{"$f":"Checkbox_Scoring!$C$85","v":"GS4"},{"$f":"Checkbox_Scoring!$C$86","v":"GS5"},{"$f":"Checkbox_Scoring!$C$87","v":"GS6"},{"$f":"Checkbox_Scoring!$C$88","v":"GS7"}]
[{"$f":"Checkbox_Scoring!$C$3","v":0},{"$f":"Checkbox_Scoring!$H$6","v":0},{"$f":"Checkbox_Scoring!$H$7","v":0},{"$f":"Checkbox_Scoring!$H$8","v":0},{"$f":"Checkbox_Scoring!$H$9","v":0},{"$f":"Checkbox_Scoring!$H$10","v":0},{"$f":"Checkbox_Scoring!$H$11","v":0},{"$f":"Checkbox_Scoring!$H$12","v":0},{"$f":"Checkbox_Scoring!$H$13","v":0},{"$f":"Checkbox_Scoring!$H$14","v":0},{"$f":"Checkbox_Scoring!$H$15","v":0},{"$f":"Checkbox_Scoring!$H$16","v":0},{"$f":"Checkbox_Scoring!$H$17","v":0},{"$f":"Checkbox_Scoring!$H$18","v":0},{"$f":"Checkbox_Scoring!$H$19","v":0},{"$f":"Checkbox_Scoring!$H$20","v":0},{"$f":"Checkbox_Scoring!$H$21","v":0},{"$f":"Checkbox_Scoring!$H$22","v":0},{"$f":"Checkbox_Scoring!$H$23","v":0},{"$f":"Checkbox_Scoring!$G$25","v":"No"},{"$f":"Checkbox_Scoring!$H$26","v":1},{"$f":"Checkbox_Scoring!$H$27","v":1},{"$f":"Checkbox_Scoring!$H$28","v":1},{"$f":"Checkbox_Scoring!$H$29","v":1},{"$f":"Checkbox_Scoring!$H$30","v":1},{"$f":"Checkbox_Scoring!$H$32","v":0},{"$f":"Checkbox_Scoring!$H$33","v":0},{"$f":"Checkbox_Scoring!$H$34","v":0},{"$f":"Checkbox_Scoring!$H$35","v":0},{"$f":"Checkbox_Scoring!$H$36","v":0},{"$f":"Checkbox_Scoring!$H$37","v":0},{"$f":"Checkbox_Scoring!$H$38","v":0},{"$f":"Checkbox_Scoring!$H$39","v":0},{"$f":"Checkbox_Scoring!$H$40","v":0},{"$f":"Checkbox_Scoring!$H$41","v":1},{"$f":"Checkbox_Scoring!$H$42","v":1},{"$f":"Checkbox_Scoring!$H$43","v":0},{"$f":"Checkbox_Scoring!$H$44","v":0},{"$f":"Checkbox_Scoring!$H$45","v":0},{"$f":"Checkbox_Scoring!$H$46","v":0},{"$f":"Checkbox_Scoring!$H$47","v":0},{"$f":"Checkbox_Scoring!$H$49","v":0},{"$f":"Checkbox_Scoring!$H$50","v":0},{"$f":"Checkbox_Scoring!$H$51","v":0},{"$f":"Checkbox_Scoring!$H$52","v":0},{"$f":"Checkbox_Scoring!$H$53","v":0},{"$f":"Checkbox_Scoring!$H$54","v":0},{"$f":"Checkbox_Scoring!$H$55","v":0},{"$f":"Checkbox_Scoring!$H$56","v":0},{"$f":"Checkbox_Scoring!$H$57","v":0},{"$f":"Checkbox_Scoring!$H$58","v":0},{"$f":"Checkbox_Scoring!$H$59","v":0},{"$f":"Checkbox_Scoring!$H$60","v":0},{"$f":"Checkbox_Scoring!$H$61","v":0},{"$f":"Checkbox_Scoring!$H$62","v":0},{"$f":"Checkbox_Scoring!$H$63","v":0},{"$f":"Checkbox_Scoring!$H$64","v":0},{"$f":"Checkbox_Scoring!$H$65","v":0},{"$f":"Checkbox_Scoring!$H$66","v":0},{"$f":"Checkbox_Scoring!$H$67","v":0},{"$f":"Checkbox_Scoring!$H$68","v":0},{"$f":"Checkbox_Scoring!$H$69","v":0},{"$f":"Checkbox_Scoring!$H$70","v":0},{"$f":"Checkbox_Scoring!$H$71","v":1},{"$f":"Checkbox_Scoring!$G$73","v":"No"},{"$f":"Checkbox_Scoring!$H$74","v":1},{"$f":"Checkbox_Scoring!$H$75","v":1},{"$f":"Checkbox_Scoring!$H$76","v":0},{"$f":"Checkbox_Scoring!$H$77","v":0},{"$f":"Checkbox_Scoring!$H$78","v":0},{"$f":"Checkbox_Scoring!$H$79","v":0},{"$f":"Checkbox_Scoring!$H$80","v":0},{"$f":"Checkbox_Scoring!$H$81","v":0},{"$f":"Checkbox_Scoring!$G$82","v":"No"},{"$f":"Checkbox_Scoring!$H$83","v":1},{"$f":"Checkbox_Scoring!$H$84","v":1},{"$f":"Checkbox_Scoring!$H$85","v":1},{"$f":"Checkbox_Scoring!$H$86","v":1},{"$f":"Checkbox_Scoring!$H$87","v":1},{"$f":"Checkbox_Scoring!$H$88","v":1}]