{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Coverpage","Instructions","Application Checklist","A - Applicant & Min Requirement","B - Unit Mix & Max Award Amt","C - Selection Criteria","D - Supportive Services Plan","E - Certification","Application Support","Sheet2","Dropdowns","PU FMR Amts","CHAS Data"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":3,"defined_names":185,"comments":4,"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":"Coverpage","index":0,"n_rows":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,22],[3,0,3,22],[6,0,7,21],[26,0,26,22],[27,0,27,22],[29,0,29,22],[30,0,30,22],[32,0,32,22],[33,0,33,22],[36,0,36,22],[37,0,37,22],[38,0,38,22],[39,0,39,22],[40,0,40,22],[44,0,44,22],[41,0,41,22],[42,0,42,22]]}
[]
["Housing for a Healthy California"]
[]
["2019 NOTICE OF FUNDING AVAILABILITY"]
[]
[]
["Article II - Building Homes and Jobs Act (SB2) Allocation - Supplemental Application"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State of California"]
["Governor Gavin Newsom"]
[]
["Alexis Podesta, Secretary"]
["Business, Consumer Services and Housing Agency"]
[]
["Ben Metcalf, Director"]
["Department of Housing and Community Development (HCD)"]
[]
[]
["2020 West El Camino Avenue, Suite 500"]
["Sacramento, CA 95833"]
["Phone: (916) 263-2771   "]
["Email: HousingforHealthyCA@hcd.ca.gov"]
["Website: http://www.hcd.ca.gov/grants-funding/active-funding/hhc.shtml"]
["Application Technical Support email:"]
["AppSupport@hcd.ca.gov"]
[]
["May 13, 2019"]

{"sheet":"Instructions","index":1,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,0,9,37],[10,0,10,37],[8,0,8,37],[11,0,11,37],[17,0,17,37],[16,0,16,37],[15,0,15,37],[14,0,14,37],[13,0,13,37],[12,0,12,37],[7,0,7,37],[6,0,6,37],[5,0,5,37],[4,0,4,37],[0,0,0,37],[1,0,1,37],[2,0,2,37],[3,0,3,37]]}
["Instructions & Checklist"]
["HCD will only accept applications through a postal carrier service such as U.S. Postal Service, UPS, FedEx or other carrier services that provide date stamp verification confirming delivery to HCD’s office. A complete original application and an electronic copy on CD or USB flash drive with all applicable information must be received by HCD via postal carrier no later than 5:00 p.m. on:"]
["2019-08-13"]
["Applications must be on the HCD’s forms and cannot be altered or modified by the Applicant. Excel forms must be in Excel format and unprotected, not a .pdf document.  Please fill-out the Support tab and email the entire workbook to Application Support for application errors at AppSupport@hcd.ca.gov."]
["General Instructions (additional instructions and guidance are given throughout the Supplemental Application in \"red\" text and in cell comments. "]
["\"Yellow\" cells are for applicant input. Failure to provide the required attachments and documentation may disqualify your application from consideration or may negatively impact your point score."]
["Required attachments are indicated in \"Orange\" through the Supplemental Application. Failure to provide the required attachments and documentation may disqualify your application from consideration or may negatively impact your point score. Electronically attached files must use the naming convention in the Supplemental Application. For Example: \"App1 Payee Data\" for Applicant 1 Payee Data Record/ STD. 204."]
["Self score points awarded are indicated in \"blue\" cells in the 'Selection Criteria' worksheet. These are automated calculations based on the inputs provided by the applicant. "]
["\"Red\" shaded cells indicate the Applicant has failed to meet a requirement of the program. Point cells in \"Scoring\" worksheet shaded in \"Red\" indicate that the applicant has failed to meet the minimum points required. "]
["HHC Article II Supplemental Application Instructions"]
["Applicants must complete the following worksheets in the Supplemental Application. "]
["Applicant "]
["Supportive Services Plan"]
["Unit Mix & Max Award Amount"]
["Selection Criteria"]
["Certification"]
["Universal Application - NOT REQUIRED FOR HHC ARTICLE II"]
["Disclosure of Application: Information provided in this application and attachments will become a public record available for review by the public pursuant to the Public Records Act.  As such, any materials provided will be disclosable to any person making a public records request.  Please use discretion in providing HCD with information that is not specifically requested, including but not limited to, bank account numbers, personal phone numbers and home addresses.  By providing this information to HCD, the Sponsor is waiving any claim of confidentiality and consents to the disclosure of all submitted material upon request."]

{"sheet":"Application Checklist","index":2,"n_rows":42,"n_cols":36,"rows_kept":42,"cut":false,"hidden":false,"merged":[[17,0,17,2],[17,3,17,9],[17,10,17,34],[17,35,17,37],[13,10,13,34],[12,10,12,34],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[15,3,15,9],[16,3,16,9],[16,10,16,34],[15,10,15,34],[14,10,14,34],[41,0,41,2],[41,3,41,34],[23,3,23,34],[23,0,23,2],[38,10,38,34],[37,10,37,34],[20,0,20,2],[38,0,38,2],[36,0,36,2],[37,0,37,2],[32,0,32,2],[32,10,32,34],[33,0,33,2],[33,10,33,34],[30,0,30,2],[30,10,30,34],[31,10,31,34],[29,3,29,9],[29,10,29,34],[28,3,28,9],[28,10,28,34],[25,3,25,9],[24,3,24,9],[31,0,31,2],[0,0,0,37],[8,3,8,9],[9,3,9,9],[10,3,10,9],[11,3,11,9],[12,3,12,9],[5,0,5,37],[1,0,1,37],[6,3,6,9],[6,35,6,37],[6,10,6,34],[7,3,7,34],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[9,10,9,34],[8,10,8,34],[10,35,10,37],[11,35,11,37],[12,35,12,37],[2,0,2,37],[3,0,3,37],[11,0,11,2],[12,0,12,2],[13,3,13,9],[14,3,14,9],[41,35,41,37],[30,35,30,37],[31,35,31,37],[32,35,32,37],[24,35,24,37],[25,35,25,37],[26,35,26,37],[23,35,23,37],[26,3,26,9],[27,3,27,9],[32,3,32,9],[33,3,33,9],[26,10,26,34],[27,10,27,34],[24,10,24,34],[25,10,25,34],[36,3,36,34],[20,3,20,34],[30,3,30,9],[31,3,31,9],[4,0,4,37],[39,0,39,37],[27,35,27,37],[28,35,28,37],[29,35,29,37],[15,35,15,37],[16,35,16,37],[37,35,37,37],[38,35,38,37],[34,0,34,37],[18,0,18,37],[8,35,8,37],[9,35,9,37],[7,35,7,37],[36,35,36,37],[21,0,21,37],[20,35,20,37],[33,35,33,37],[37,3,37,9],[38,3,38,9],[11,10,11,34],[10,10,10,34],[13,35,13,37],[14,35,14,37],[19,35,19,37],[19,3,19,34],[22,0,22,2],[22,35,22,37],[35,0,35,2],[35,35,35,37],[40,0,40,2],[40,3,40,34],[40,35,40,37],[22,3,22,9],[22,10,22,34],[35,3,35,9],[35,10,35,34],[28,0,28,2],[29,0,29,2],[26,0,26,2],[27,0,27,2],[24,0,24,2],[25,0,25,2],[19,0,19,2]]}
["Application Checklist"]
["Packaging instructions for the HHC application submission:"]
["   (1) Use 3-ring binder/binders appropriate to the size/thickness of the Universal Application and the Supplemental Application when submitting the application package to the Department."]
["   (2) Use a labeled tab for each Tab and File Name to separate sections and documents attached in the Application."]
["   (3) Use the tab file name descriptions and file structure below for the attached document tabs."]
["Section A - Applicant"]
["Tab #",null,null,"File Name",null,null,null,null,null,null,"File Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached?"]
["A1",null,null,"Applicant Worksheet"]
["A2",null,null,{"$f":"'A - Applicant & Min Requirement'!F8","v":"App1 Cert & Legal Disclosure"},null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!L8","v":"Reference Certification Tab"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A - Applicant & Min Requirement'!AK8=\"\",\"\",'A - Applicant & Min Requirement'!AK8)","v":""}]
["A3",null,null,{"$f":"'A - Applicant & Min Requirement'!F9","v":"App1 Reso"},null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!L9","v":"Reference HHC webpage for Resolution Document."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A - Applicant & Min Requirement'!AK9=\"\",\"\",'A - Applicant & Min Requirement'!AK9)","v":""}]
["A4",null,null,{"$f":"'A - Applicant & Min Requirement'!F10","v":"App1 Signature Block"},null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!L10","v":"Signature Block - upload in Microsoft Word Document."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A - Applicant & Min Requirement'!AK10=\"\",\"\",'A - Applicant & Min Requirement'!AK10)","v":""}]
["A5",null,null,{"$f":"'A - Applicant & Min Requirement'!F11","v":"App1 TIN"},null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!L11","v":"Reference Taxpayer Identification Number Document on the HHC webpage."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A - Applicant & Min Requirement'!AK11=\"\",\"\",'A - Applicant & Min Requirement'!AK11)","v":""}]
["A6",null,null,{"$f":"'A - Applicant & Min Requirement'!F17","v":"App2 Cert & Legal Disclosure"},null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!L17","v":"Reference Certification Tab"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A - Applicant & Min Requirement'!AK17=\"\",\"\",'A - Applicant & Min Requirement'!AK17)","v":""}]
["A7",null,null,{"$f":"'A - Applicant & Min Requirement'!F18","v":"App2 Reso"},null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!L18","v":"Reference HHC webpage for Resolution Document."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A - Applicant & Min Requirement'!AK18=\"\",\"\",'A - Applicant & Min Requirement'!AK18)","v":""}]
["A8",null,null,{"$f":"'A - Applicant & Min Requirement'!F19","v":"App2 Signature Block"},null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!L19","v":"Signature Block - upload in Microsoft Word Document."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A - Applicant & Min Requirement'!AK19=\"\",\"\",'A - Applicant & Min Requirement'!AK19)","v":""}]
["A9",null,null,{"$f":"'A - Applicant & Min Requirement'!F20","v":"App2 TIN"},null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!L20","v":"Reference Taxpayer Identification Number Document on the HHC webpage."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A - Applicant & Min Requirement'!AK40=\"\",\"\",'A - Applicant & Min Requirement'!AK40)","v":""}]
["A10",null,null,{"$f":"'A - Applicant & Min Requirement'!F40","v":"County Application Plan"},null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!L40","v":"Attached County Application Plan as specified in §211."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A - Applicant & Min Requirement'!AK40=\"\",\"\",'A - Applicant & Min Requirement'!AK40)","v":""}]
["A11",null,null,{"$f":"'A - Applicant & Min Requirement'!F56","v":"Letter of Explanation"},null,null,null,null,null,null,"Letter of explanation for any \"red\" shaded cells.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A - Applicant & Min Requirement'!AK56=\"\",\"\",'A - Applicant & Min Requirement'!AK56)","v":""}]
["Section B  - Unit Mix & Max Award Amt Section"]
["Tab #",null,null,"File Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached?"]
["B1",null,null,"Unit Mix & Max Award Amt Worksheet"]
["Section C - Selection Criteria Section"]
["Tab #",null,null,"File Name",null,null,null,null,null,null,"File Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached?"]
["C1",null,null,"Selection Criteria Worksheet"]
["C2",null,null,{"$f":"'C - Selection Criteria'!F7","v":"PIT Cert Letter"},null,null,null,null,null,null,{"$f":"'C - Selection Criteria'!L7","v":"Letter from CoC Certifying PIT Count. "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('C - Selection Criteria'!AK7=\"\",\"\",'C - Selection Criteria'!AK7)","v":""}]
["C3",null,null,{"$f":"'C - Selection Criteria'!F12","v":"Homelessness Plan"},null,null,null,null,null,null,{"$f":"'C - Selection Criteria'!L12","v":"Attach Applicant's homelessness plan."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('C - Selection Criteria'!AK12=\"\",\"\",'C - Selection Criteria'!AK12)","v":""}]
["C4",null,null,{"$f":"'C - Selection Criteria'!F41","v":"Dev Exp 1, 2, 3, etc"},null,null,null,null,null,null,{"$f":"'C - Selection Criteria'!L41","v":"Notice of Completion, Placed in Service, Certificate of Occ. or equivalent."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('C - Selection Criteria'!AK41=\"\",\"\",'C - Selection Criteria'!AK41)","v":""}]
["C5",null,null,{"$f":"'C - Selection Criteria'!F43","v":"Rent Contracts 1, 2, 3, etc"},null,null,null,null,null,null,{"$f":"'C - Selection Criteria'!L43","v":"Copies of Rental Assistance contracts."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('C - Selection Criteria'!AK43=\"\",\"\",'C - Selection Criteria'!AK43)","v":""}]
["C6",null,null,{"$f":"'C - Selection Criteria'!F46","v":"TP Dev Exp 1, 2, 3, etc"},null,null,null,null,null,null,{"$f":"'C - Selection Criteria'!L46","v":"Notice of Completion, Placed in Service, Certificate of Occ. or equivalent."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('C - Selection Criteria'!AK46=\"\",\"\",'C - Selection Criteria'!AK46)","v":""}]
["C7",null,null,{"$f":"'C - Selection Criteria'!F48","v":"TP Rent Contracts 1, 2, 3, etc"},null,null,null,null,null,null,{"$f":"'C - Selection Criteria'!L48","v":"Copies of Rental Assistance contracts."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('C - Selection Criteria'!AK48=\"\",\"\",'C - Selection Criteria'!AK48)","v":""}]
["C8",null,null,{"$f":"'C - Selection Criteria'!F56","v":"Funding Commitments"},null,null,null,null,null,null,{"$f":"'C - Selection Criteria'!L56","v":"Attach letter(s) of commitment from funding sources."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('C - Selection Criteria'!AK56=\"\",\"\",'C - Selection Criteria'!AK48)","v":""}]
["C9",null,null,{"$f":"'C - Selection Criteria'!F57","v":"Feasibility Study"},null,null,null,null,null,null,{"$f":"'C - Selection Criteria'!L57","v":"Attach documentation of applicants determination the project’s feasibility showing there is no financial gap that needs to be addressed."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('C - Selection Criteria'!AK57=\"\",\"\",'C - Selection Criteria'!AK48)","v":""}]
["C10",null,null,{"$f":"'C - Selection Criteria'!F61","v":"Homeless Benefits Program"},null,null,null,null,null,null,{"$f":"'C - Selection Criteria'!L61","v":"Whole Person Care Pilot Program documents or documentation of a Health Homes Program benefitting people experiencing homelessness."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('C - Selection Criteria'!AK61=\"\",\"\",'C - Selection Criteria'!AK61)","v":""}]
["C11",null,null,{"$f":"'C - Selection Criteria'!F62","v":"Funding Program"},null,null,null,null,null,null,{"$f":"'C - Selection Criteria'!L62","v":"Documentation of a locally committed funding  program for projects in an amount at least equivalent to requested HHC funding."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('C - Selection Criteria'!AK62=\"\",\"\",'C - Selection Criteria'!AK62)","v":""}]
["Section D - Supportive Services Plan Section"]
["Tab #",null,null,"File Name",null,null,null,null,null,null,"File Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached?"]
["D1",null,null,"Supportive Services Plan Worksheet"]
["D2",null,null,{"$f":"'D - Supportive Services Plan'!F3","v":"SSP"},null,null,null,null,null,null,{"$f":"'D - Supportive Services Plan'!L3","v":"Attach a Supportive Services Plan as specified in §214."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('D - Supportive Services Plan'!AK3=\"\",\"\",'D - Supportive Services Plan'!AK3)","v":""}]
["D3",null,null,{"$f":"'D - Supportive Services Plan'!F76","v":"Org. Chart/ Resumes"},null,null,null,null,null,null,{"$f":"'D - Supportive Services Plan'!K76","v":"Attach copies provider org. charts, staff resumes, and duty statements."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('D - Supportive Services Plan'!AK76=\"\",\"\",'D - Supportive Services Plan'!AK76)","v":""}]
["Section E - Certification Section"]
["Tab #",null,null,"File Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached?"]
["E1",null,null,"Certification Worksheet"]

{"sheet":"A - Applicant & Min Requirement","index":3,"n_rows":56,"n_cols":37,"rows_kept":56,"cut":false,"hidden":false,"merged":[[53,0,53,37],[54,0,54,37],[55,0,55,2],[55,3,55,4],[55,5,55,10],[55,11,55,29],[55,30,55,35],[55,36,55,37],[0,34,0,37],[0,0,0,33],[28,0,28,35],[28,36,28,37],[29,0,29,4],[29,5,29,37],[30,0,30,35],[30,36,30,37],[31,0,31,35],[31,36,31,37],[26,0,26,1],[26,2,26,6],[26,7,26,8],[26,9,26,20],[26,22,26,28],[26,29,26,30],[26,31,26,32],[26,34,26,37],[23,0,23,1],[23,2,23,6],[23,7,23,8],[23,9,23,20],[23,22,23,28],[23,31,23,32],[50,0,50,35],[50,36,50,37],[23,34,23,37],[25,0,25,2],[25,3,25,14],[25,15,25,17],[25,18,25,26],[25,27,25,29],[25,30,25,37],[24,0,24,37],[23,29,23,30],[51,0,51,35],[51,36,51,37],[37,0,37,35],[37,36,37,37],[38,0,38,35],[38,36,38,37],[32,0,32,35],[32,36,32,37],[33,0,33,35],[33,36,33,37],[34,0,34,35],[34,36,34,37],[35,0,35,35],[35,36,35,37],[36,0,36,35],[36,36,36,37],[39,0,39,2],[39,11,39,29],[39,30,39,35],[39,36,39,37],[39,5,39,10],[39,3,39,4],[52,0,52,35],[52,36,52,37],[27,0,27,37],[2,0,2,8],[2,14,2,23],[45,0,45,35],[45,36,45,37],[46,0,46,35],[46,36,46,37],[47,0,47,35],[47,36,47,37],[48,0,48,35],[48,36,48,37],[49,0,49,35],[49,36,49,37],[40,0,40,35],[40,36,40,37],[41,0,41,37],[42,0,42,35],[42,36,42,37],[43,0,43,35],[43,36,43,37],[44,0,44,35],[44,36,44,37],[22,0,22,2],[22,3,22,14],[22,15,22,17],[22,18,22,26],[22,27,22,29],[22,30,22,37],[21,0,21,37],[20,0,20,37],[18,0,18,2],[18,36,18,37],[19,0,19,2],[19,11,19,29],[19,30,19,35],[19,36,19,37],[18,30,18,35],[18,11,18,29],[19,5,19,10],[18,5,18,10],[18,3,18,4],[19,3,19,4],[15,0,15,1],[15,2,15,20],[15,22,15,27],[15,28,15,29],[15,30,15,32],[15,34,15,37],[16,0,16,2],[17,0,17,2],[16,11,16,29],[16,30,16,35],[16,36,16,37],[17,11,17,29],[17,30,17,35],[17,36,17,37],[17,5,17,10],[16,5,16,10],[16,3,16,4],[17,3,17,4],[13,0,13,3],[13,4,13,12],[13,14,13,19],[13,20,13,24],[13,25,13,31],[13,32,13,33],[13,34,13,37],[14,0,14,2],[14,3,14,11],[14,13,14,19],[14,20,14,22],[14,23,14,30],[14,31,14,32],[14,33,14,37],[12,0,12,1],[2,9,2,13],[9,0,9,2],[9,36,9,37],[10,0,10,2],[11,0,11,10],[12,2,12,20],[12,22,12,27],[8,0,8,2],[11,11,11,13],[11,14,11,37],[12,28,12,29],[12,30,12,32],[12,34,12,37],[7,30,7,35],[7,11,7,29],[7,0,7,2],[10,11,10,29],[10,30,10,35],[10,36,10,37],[8,11,8,29],[8,30,8,35],[8,36,8,37],[7,36,7,37],[1,0,1,37],[5,0,5,2],[5,3,5,11],[3,0,3,1],[2,24,2,32],[2,33,2,34],[2,35,2,37],[3,2,3,20],[3,22,3,27],[3,28,3,29],[3,30,3,32],[3,34,3,37],[5,13,5,19],[5,20,5,22],[5,23,5,30],[5,31,5,32],[5,33,5,37],[4,4,4,12],[4,14,4,19],[4,20,4,24],[4,25,4,31],[9,30,9,35],[9,11,9,29],[10,5,10,10],[9,5,9,10],[8,5,8,10],[7,5,7,10],[10,3,10,4],[9,3,9,4],[8,3,8,4],[7,3,7,4],[6,0,6,1],[6,2,6,20],[6,22,6,27],[6,28,6,29],[6,30,6,32],[4,0,4,3],[6,34,6,37],[4,32,4,33],[4,34,4,37]]}
["Applicant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev. 7/3/19"]
["Proposed Project uses of the HHC Funds §203"]
["Eligible County Applicant:",null,null,null,null,null,null,null,null,"Sacramento",null,null,null,null,"Continuum of Care (CoC):",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(J3,Dropdowns!A2:B59,2,FALSE),\"\")","v":"Sacramento City & County CoC"},null,null,null,null,null,null,null,null,"CoC #:",null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!Y3,Dropdowns!B2:C59,2,FALSE),\"\")","v":"CA-503"}]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Auth Rep Name",null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Authorized Rep. Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact Name",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"Contact Email",null,null,null,null,null,null,null,null,null,null,"Phone"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["File Name:",null,null,{"$f":"'Application Checklist'!A9","v":"A2"},null,"App1 Cert & Legal Disclosure",null,null,null,null,null,"Reference Certification Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,{"$f":"'Application Checklist'!A10","v":"A3"},null,"App1 Reso",null,null,null,null,null,"Reference HHC webpage for Resolution Document.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,{"$f":"'Application Checklist'!A11","v":"A4"},null,"App1 Signature Block",null,null,null,null,null,"Signature Block - upload in Microsoft Word Document.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,{"$f":"'Application Checklist'!A12","v":"A5"},null,"App1 TIN",null,null,null,null,null,"Reference Taxpayer Identification Number Document on the HHC webpage.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Eligible City Applicant #2:",null,null,null,null,null,null,null,null,null,null,"City Name:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Auth Rep Name",null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Authorized Rep. Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact Name",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"Contact Email",null,null,null,null,null,null,null,null,null,null,"Phone"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["File Name:",null,null,{"$f":"'Application Checklist'!A13","v":"A6"},null,"App2 Cert & Legal Disclosure",null,null,null,null,null,"Reference Certification Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,{"$f":"'Application Checklist'!A14","v":"A7"},null,"App2 Reso",null,null,null,null,null,"Reference HHC webpage for Resolution Document.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,{"$f":"'Application Checklist'!A15","v":"A8"},null,"App2 Signature Block",null,null,null,null,null,"Signature Block - upload in Microsoft Word Document.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,{"$f":"'Application Checklist'!A16","v":"A9"},null,"App2 TIN",null,null,null,null,null,"Reference Taxpayer Identification Number Document on the HHC webpage.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Other Project Contacts"]
["Financial Consultant"]
["Legal Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Name",null,null,null,null,null,null,null,null,null,null,null,"Contact Email"]
["Phone",null,null,null,null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"State",null,null,null,"Zip"]
["Lead (primary) Service Provider"]
["Legal Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Name",null,null,null,null,null,null,null,null,null,null,null,"Contact Email"]
["Phone",null,null,null,null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"State",null,null,null,"Zip"]
["Minimum Requirements §202"]
["(a)(1) Has Applicant identified a source of funding for providing intensive services promoting housing stability?"]
["Identify and explain source(s):"]
["(a)(2) Has Applicant developed a process for administering grant funds implementing affordable & Supportive housing projects (the agency Applicant is partnering with, or the applying housing agency, must have either administered rental assistance or funded an affordable or Supportive housing project within the past 3 years)?"]
["(a)(3) Does Applicant agree to collect and report data, as described in §219, to HCD?"]
["(a)(4) Is Applicant compliant with both their housing element and annual progress report submittals?"]
["(b)(1) Does Applicant's application promote housing for persons who meet all the requirements of §202(b)(1)?"]
["(b)(2) Is Applicant's proposed use of funds connected to the goals and strategies pursuant to Health & Safety Code §53591(a)(1)?"]
["(b)(3) Is Applicant's requested fund amount less than or equal to the amount specified in §208?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - Unit Mix & Max Award Amt'!AH5=0,\"\",IF(AND('B - Unit Mix & Max Award Amt'!AH5>1,'B - Unit Mix & Max Award Amt'!AH5<20000000),\"Yes\",\"No\"))","v":""}]
["(b)(4) Does Applicant agree that the proposed project(s) must be financially feasible for the duration of the HHC rental subsidy?"]
["(b)(5) Has Applicant attached a resolution from the County board of supervisors, or other controlling body, that authorizes the County to apply for funding and coordinate referrals and access to health care services to HHC tenants, such as a WPC pilot program, Health Homes Program, or other community-based program funding services?"]
["(b)(6) Has Applicant provided the County Application Plan as specified in §211?"]
["File Name:",null,null,{"$f":"'Application Checklist'!A17","v":"A10"},null,"County Application Plan",null,null,null,null,null,"Attached County Application Plan as specified in §211.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["(c) Does Applicant acknowledge County subrecipient(s) of HHC funds have not been debarred or suspended from any state programs?"]
["Other Requirements"]
["Applicant agrees to use grant funds pursuant to the eligible uses in §203. For acquisition, new construction, reconstruction, and rehabilitation projects, Applicant agrees project will comply with Article 1, §103(a)(1), 104, 105, 106, 107, and 109(a)?"]
["Applicant agrees to comply with §204, Site and Neighborhood and Property Standard Requirements?"]
["Applicant agrees to comply with the §205, Occupancy and Income as well as the documentation requirements?"]
["Applicant agrees to comply with the §206, Rent Standard requirements?"]
["Applicant agrees to comply with §207, Capitialized Operating Subsidy Reserves (COSR) and §210, Use of Operating Cash Flow if funds are used to pay for a COSR?"]
["Applicant agrees to comply with  §215, Housing First?"]
["Applicant agrees to comply with §216, Tenant Selection?"]
["Applicant agrees to comply with  §217, Rental Agreements and Grievance Procedures?"]
["For HHC funded construction projects, Applicant agrees to incorporate §218, Vulnerable Populations Best Practices?"]
["Applicant agrees to comply with §219, Reporting Requirements?"]
["Applicant agrees to comply with the  §221, Federal and State Overlays?"]
["Explanations "]
["Please provide a letter of explanation providing details for all \"No\" answers that are shaded red above."]
["File Name:",null,null,{"$f":"'[3]Application Checklist'!A27","v":"B3"},null,"Letter of Explanation",null,null,null,null,null,"Letter of explanation for any \"red\" shaded cells above. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]

{"sheet":"B - Unit Mix & Max Award Amt","index":4,"n_rows":39,"n_cols":43,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,36,1,37],[1,0,1,35],[37,0,37,8],[37,10,37,18],[37,20,37,33],[37,35,37,37],[38,0,38,8],[38,10,38,18],[38,20,38,33],[26,33,26,35],[19,7,19,8],[28,24,28,26],[19,9,19,10],[20,7,20,8],[31,3,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14],[31,24,31,26],[26,7,26,8],[26,9,26,10],[27,7,27,8],[27,9,27,10],[5,3,5,6],[31,15,31,20],[28,3,28,4],[29,3,29,4],[30,3,30,4],[6,33,10,35],[11,33,11,35],[12,33,12,35],[13,33,13,35],[14,33,14,35],[15,33,15,35],[16,33,16,35],[17,33,17,35],[18,33,18,35],[19,33,19,35],[20,33,20,35],[21,33,21,35],[22,33,22,35],[23,33,23,35],[24,33,24,35],[25,33,25,35],[16,3,16,4],[17,3,17,4],[18,3,18,4],[27,33,27,35],[28,33,28,35],[29,33,29,35],[30,33,30,35],[22,27,22,29],[23,27,23,29],[24,27,24,29],[25,27,25,29],[26,27,26,29],[28,27,28,29],[29,27,29,29],[30,27,30,29],[19,11,19,12],[20,11,20,12],[25,30,25,32],[27,27,27,29],[22,11,22,12],[30,11,30,12],[26,13,26,14],[20,13,20,14],[28,13,28,14],[28,7,28,8],[28,9,28,10],[31,21,31,23],[31,27,31,29],[31,33,31,35],[31,30,31,32],[29,21,29,23],[30,21,30,23],[6,27,10,29],[11,27,11,29],[12,27,12,29],[13,27,13,29],[14,27,14,29],[15,27,15,29],[16,27,16,29],[17,27,17,29],[18,27,18,29],[19,27,19,29],[6,30,10,32],[14,30,14,32],[13,30,13,32],[20,24,20,26],[11,30,11,32],[24,30,24,32],[18,21,18,23],[6,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[11,7,11,8],[11,9,11,10],[12,7,12,8],[12,9,12,10],[13,7,13,8],[13,9,13,10],[14,7,14,8],[14,9,14,10],[15,7,15,8],[15,9,15,10],[6,9,10,10],[11,5,11,6],[12,5,12,6],[6,5,10,6],[15,5,15,6],[13,5,13,6],[14,5,14,6],[21,7,21,8],[21,9,21,10],[29,7,29,8],[29,9,29,10],[30,7,30,8],[30,9,30,10],[22,7,22,8],[22,9,22,10],[23,7,23,8],[23,9,23,10],[24,9,24,10],[25,9,25,10],[16,5,16,6],[29,11,29,12],[28,15,28,17],[22,13,22,14],[23,13,23,14],[27,15,27,17],[18,11,18,12],[17,11,17,12],[26,11,26,12],[25,11,25,12],[24,11,24,12],[23,11,23,12],[21,11,21,12],[27,13,27,14],[24,13,24,14],[29,13,29,14],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[20,9,20,10],[30,13,30,14],[28,18,28,20],[21,30,21,32],[20,30,20,32],[19,24,19,26],[19,18,19,20],[20,18,20,20],[25,13,25,14],[24,21,24,23],[25,21,25,23],[26,24,26,26],[21,13,21,14],[25,24,25,26],[22,18,22,20],[19,21,19,23],[20,21,20,23],[21,21,21,23],[19,30,19,32],[19,13,19,14],[23,30,23,32],[22,30,22,32],[12,30,12,32],[20,27,20,29],[21,27,21,29],[13,24,13,26],[21,18,21,20],[21,24,21,26],[13,18,13,20],[18,18,18,20],[16,24,16,26],[16,30,16,32],[15,30,15,32],[27,18,27,20],[27,24,27,26],[22,24,22,26],[23,18,23,20],[23,24,23,26],[24,18,24,20],[24,24,24,26],[25,18,25,20],[22,21,22,23],[23,21,23,23],[18,30,18,32],[17,30,17,32],[15,15,15,17],[16,7,16,8],[16,9,16,10],[17,7,17,8],[17,9,17,10],[18,7,18,8],[18,9,18,10],[11,13,11,14],[12,13,12,14],[13,13,13,14],[14,13,14,14],[15,13,15,14],[16,13,16,14],[14,11,14,12],[13,11,13,12],[12,11,12,12],[15,11,15,12],[17,13,17,14],[18,13,18,14],[16,11,16,12],[36,0,36,37],[29,15,29,17],[29,18,29,20],[29,24,29,26],[26,15,26,17],[26,18,26,20],[30,15,30,17],[30,18,30,20],[26,21,26,23],[27,21,27,23],[28,21,28,23],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[29,30,29,32],[28,30,28,32],[27,30,27,32],[26,30,26,32],[30,30,30,32],[30,24,30,26],[35,0,35,37],[27,3,27,4],[6,7,10,8],[6,11,10,12],[14,24,14,26],[6,24,10,26],[11,18,11,20],[11,24,11,26],[12,15,12,17],[12,18,12,20],[6,15,10,17],[6,18,10,20],[6,21,10,23],[11,21,11,23],[12,21,12,23],[13,21,13,23],[11,15,11,17],[13,15,13,17],[12,24,12,26],[0,35,0,37],[0,0,0,34],[33,0,33,37],[32,0,32,37],[34,0,34,35],[34,36,34,37],[11,11,11,12],[14,15,14,17],[17,15,17,17],[16,15,16,17],[18,15,18,17],[21,15,21,17],[20,15,20,17],[19,15,19,17],[19,3,19,4],[22,15,22,17],[25,15,25,17],[24,15,24,17],[23,15,23,17],[28,11,28,12],[27,11,27,12],[26,3,26,4],[25,3,25,4],[24,3,24,4],[5,0,31,0],[5,36,10,37],[23,3,23,4],[22,3,22,4],[21,3,21,4],[20,3,20,4],[25,5,25,6],[24,7,24,8],[25,7,25,8],[24,5,24,6],[5,7,5,14],[5,15,5,35],[6,13,10,14],[18,24,18,26],[15,18,15,20],[15,24,15,26],[16,18,16,20],[17,18,17,20],[17,24,17,26],[14,18,14,20],[14,21,14,23],[15,21,15,23],[16,21,16,23],[17,21,17,23],[4,26,4,32],[3,0,4,25],[4,33,4,37],[2,0,2,23],[2,24,2,25],[2,26,2,32],[2,33,2,37],[3,26,3,32],[3,33,3,37]]}
["Unit Mix & Maximum Award Amount",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!AI1","v":"Rev. 7/3/19"}]
["Will Applicant be using award funds for Administrative Costs?"]
["If Applicant is using Administrative Costs, What is the proposed Adminstrative Cost percentage? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Allowed Administrative Cost:",null,null,null,null,null,null,{"$f":"IFERROR((Y3*AH5),\"\")","v":0}]
[{"$f":"CONCATENATE(\"Maximum HHC Loan Amount Chart\",\" - click here for 2019 HHC loan limits - (beginning on page 31)\")","v":"Maximum HHC Loan Amount Chart - click here for 2019 HHC loan limits - (beginning on page 31)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Allowed Activity Cost: ",null,null,null,null,null,null,{"$f":"AH5-AH3","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL AWARD LIMIT: ",null,null,null,null,null,null,{"$f":"MIN(SUM(V32,AB32,AH32),20000000)","v":0}]
[{"$f":"'A - Applicant & Min Requirement'!J3&\" County\"","v":"Sacramento County"},null,null,null,null,null,null,"Proposed # of Assisted Units",null,null,null,null,null,null,null,"Eligible Per Unit (PU) Award Amounts"]
[null,null,null,"# of Bedrms",null,"% of Area Median Income (AMI)",null,"9% Tax Credit Development ",null,"Non 4% or No Tax Credit Development",null,"COSR",null,"Rental Assistance",null,"9% Tax Credit Development PU Amount",null,null,"4% or No Tax Credit Development PU Amount",null,null,"Max Development Award",null,null,"Total ANNAUL PU COSR",null,null,"Max COSR Award (15 Years)",null,null,"Annual Rental Assistance\nPU Amount",null,null,"Max Rental Assistance Award\n5 yrs per NOFA"]
[]
[]
[]
[]
[null,null,null,0,null,"30%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ12,'PU FMR Amts'!$A$2:$F$233,AP12,FALSE),\"\")","v":132862},null,null,{"$f":"IFERROR(VLOOKUP(AQ12,'PU FMR Amts'!$G$2:$L$233,AP12,FALSE),\"\")","v":186006},null,null,{"$f":"IFERROR(SUM(H12*P12,J12*S12),\"\")","v":0},null,null,null,null,null,{"$f":"(L12*Y12)*15","v":0},null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP12,FALSE)*0.95*12,\"\")","v":9724.1999999999989},null,null,{"$f":"IFERROR(N12*AE12*5,\"\")","v":0},null,null,null,null,null,null,null,2,{"$f":"IF(F12=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F12)","v":"Sacramento30%"}]
[null,null,null,1,null,"30%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ13,'PU FMR Amts'!$A$2:$F$233,AP13,FALSE),\"\")","v":132862},null,null,{"$f":"IFERROR(VLOOKUP(AQ13,'PU FMR Amts'!$G$2:$L$233,AP13,FALSE),\"\")","v":186006},null,null,{"$f":"IFERROR(SUM(H13*P13,J13*S13),\"\")","v":0},null,null,null,null,null,{"$f":"(L13*Y13)*15","v":0},null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP13,FALSE)*0.95*12,\"\")","v":11035.199999999999},null,null,{"$f":"IFERROR(N13*AE13*5,\"\")","v":0},null,null,null,null,null,null,null,3,{"$f":"IF(F13=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F13)","v":"Sacramento30%"}]
[null,null,null,2,null,"30%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ14,'PU FMR Amts'!$A$2:$F$233,AP14,FALSE),\"\")","v":132862},null,null,{"$f":"IFERROR(VLOOKUP(AQ14,'PU FMR Amts'!$G$2:$L$233,AP14,FALSE),\"\")","v":186006},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP14,FALSE)*0.95*12,\"\")","v":13908},null,null,0,null,null,null,null,null,null,null,4,{"$f":"IF(F14=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F14)","v":"Sacramento30%"}]
[null,null,null,3,null,"30%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ15,'PU FMR Amts'!$A$2:$F$233,AP15,FALSE),\"\")","v":132862},null,null,{"$f":"IFERROR(VLOOKUP(AQ15,'PU FMR Amts'!$G$2:$L$233,AP15,FALSE),\"\")","v":186006},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP15,FALSE)*0.95*12,\"\")","v":20109.599999999999},null,null,0,null,null,null,null,null,null,null,5,{"$f":"IF(F15=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F15)","v":"Sacramento30%"}]
[null,null,null,"4+",null,"30%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ16,'PU FMR Amts'!$A$2:$F$233,AP16,FALSE),\"\")","v":132862},null,null,{"$f":"IFERROR(VLOOKUP(AQ16,'PU FMR Amts'!$G$2:$L$233,AP16,FALSE),\"\")","v":186006},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP16,FALSE)*0.95*12,\"\")","v":24430.199999999997},null,null,0,null,null,null,null,null,null,null,6,{"$f":"IF(F16=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F16)","v":"Sacramento30%"}]
[null,null,null,0,null,"25%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ17,'PU FMR Amts'!$A$2:$F$233,AP17,FALSE),\"\")","v":143377.45314373483},null,null,{"$f":"IFERROR(VLOOKUP(AQ17,'PU FMR Amts'!$G$2:$L$233,AP17,FALSE),\"\")","v":196521},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP17,FALSE)*0.95*12,\"\")","v":9724.1999999999989},null,null,0,null,null,null,null,null,null,null,2,{"$f":"IF(F17=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F17)","v":"Sacramento25%"}]
[null,null,null,1,null,"25%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ18,'PU FMR Amts'!$A$2:$F$233,AP18,FALSE),\"\")","v":144097.68966042902},null,null,{"$f":"IFERROR(VLOOKUP(AQ18,'PU FMR Amts'!$G$2:$L$233,AP18,FALSE),\"\")","v":197242},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP18,FALSE)*0.95*12,\"\")","v":11035.199999999999},null,null,0,null,null,null,null,null,null,null,3,{"$f":"IF(F18=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F18)","v":"Sacramento25%"}]
[null,null,null,2,null,"25%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ19,'PU FMR Amts'!$A$2:$F$233,AP19,FALSE),\"\")","v":146402.44651385036},null,null,{"$f":"IFERROR(VLOOKUP(AQ19,'PU FMR Amts'!$G$2:$L$233,AP19,FALSE),\"\")","v":199546},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP19,FALSE)*0.95*12,\"\")","v":13908},null,null,0,null,null,null,null,null,null,null,4,{"$f":"IF(F19=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F19)","v":"Sacramento25%"}]
[null,null,null,3,null,"25%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ20,'PU FMR Amts'!$A$2:$F$233,AP20,FALSE),\"\")","v":148563.15606393284},null,null,{"$f":"IFERROR(VLOOKUP(AQ20,'PU FMR Amts'!$G$2:$L$233,AP20,FALSE),\"\")","v":201707},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP20,FALSE)*0.95*12,\"\")","v":20109.599999999999},null,null,0,null,null,null,null,null,null,null,5,{"$f":"IF(F20=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F20)","v":"Sacramento25%"}]
[null,null,null,"4+",null,"25%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ21,'PU FMR Amts'!$A$2:$F$233,AP21,FALSE),\"\")","v":150291.72370399884},null,null,{"$f":"IFERROR(VLOOKUP(AQ21,'PU FMR Amts'!$G$2:$L$233,AP21,FALSE),\"\")","v":203436},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP21,FALSE)*0.95*12,\"\")","v":24430.199999999997},null,null,0,null,null,null,null,null,null,null,6,{"$f":"IF(F21=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F21)","v":"Sacramento25%"}]
[null,null,null,0,null,"20%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ22,'PU FMR Amts'!$A$2:$F$233,AP22,FALSE),\"\")","v":153892.90628746967},null,null,{"$f":"IFERROR(VLOOKUP(AQ22,'PU FMR Amts'!$G$2:$L$233,AP22,FALSE),\"\")","v":207037},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP22,FALSE)*0.95*12,\"\")","v":9724.1999999999989},null,null,0,null,null,null,null,null,null,null,2,{"$f":"IF(F22=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F22)","v":"Sacramento20%"}]
[null,null,null,1,null,"20%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ23,'PU FMR Amts'!$A$2:$F$233,AP23,FALSE),\"\")","v":155477.42662419684},null,null,{"$f":"IFERROR(VLOOKUP(AQ23,'PU FMR Amts'!$G$2:$L$233,AP23,FALSE),\"\")","v":208621},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP23,FALSE)*0.95*12,\"\")","v":11035.199999999999},null,null,0,null,null,null,null,null,null,null,3,{"$f":"IF(F23=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F23)","v":"Sacramento20%"}]
[null,null,null,2,null,"20%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ24,'PU FMR Amts'!$A$2:$F$233,AP24,FALSE),\"\")","v":159942.89302770069},null,null,{"$f":"IFERROR(VLOOKUP(AQ24,'PU FMR Amts'!$G$2:$L$233,AP24,FALSE),\"\")","v":213087},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP24,FALSE)*0.95*12,\"\")","v":13908},null,null,0,null,null,null,null,null,null,null,4,{"$f":"IF(F24=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F24)","v":"Sacramento20%"}]
[null,null,null,3,null,"20%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ25,'PU FMR Amts'!$A$2:$F$233,AP25,FALSE),\"\")","v":164264.31212786568},null,null,{"$f":"IFERROR(VLOOKUP(AQ25,'PU FMR Amts'!$G$2:$L$233,AP25,FALSE),\"\")","v":217408},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP25,FALSE)*0.95*12,\"\")","v":20109.599999999999},null,null,0,null,null,null,null,null,null,null,5,{"$f":"IF(F25=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F25)","v":"Sacramento20%"}]
[null,null,null,"4+",null,"20%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ26,'PU FMR Amts'!$A$2:$F$233,AP26,FALSE),\"\")","v":167721.44740799768},null,null,{"$f":"IFERROR(VLOOKUP(AQ26,'PU FMR Amts'!$G$2:$L$233,AP26,FALSE),\"\")","v":220865},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP26,FALSE)*0.95*12,\"\")","v":24430.199999999997},null,null,0,null,null,null,null,null,null,null,6,{"$f":"IF(F26=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F26)","v":"Sacramento20%"}]
[null,null,null,0,null,"15%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ27,'PU FMR Amts'!$A$2:$F$233,AP27,FALSE),\"\")","v":164552.40673454336},null,null,{"$f":"IFERROR(VLOOKUP(AQ27,'PU FMR Amts'!$G$2:$L$233,AP27,FALSE),\"\")","v":217696},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP27,FALSE)*0.95*12,\"\")","v":9724.1999999999989},null,null,0,null,null,null,null,null,null,null,2,{"$f":"IF(F27=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F27)","v":"Sacramento15%"}]
[null,null,null,1,null,"15%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ28,'PU FMR Amts'!$A$2:$F$233,AP28,FALSE),\"\")","v":166713.11628462587},null,null,{"$f":"IFERROR(VLOOKUP(AQ28,'PU FMR Amts'!$G$2:$L$233,AP28,FALSE),\"\")","v":219857},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP28,FALSE)*0.95*12,\"\")","v":11035.199999999999},null,null,0,null,null,null,null,null,null,null,3,{"$f":"IF(F28=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F28)","v":"Sacramento15%"}]
[null,null,null,2,null,"15%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ29,'PU FMR Amts'!$A$2:$F$233,AP29,FALSE),\"\")","v":173483.33954155102},null,null,{"$f":"IFERROR(VLOOKUP(AQ29,'PU FMR Amts'!$G$2:$L$233,AP29,FALSE),\"\")","v":226627},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP29,FALSE)*0.95*12,\"\")","v":13908},null,null,0,null,null,null,null,null,null,null,4,{"$f":"IF(F29=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F29)","v":"Sacramento15%"}]
[null,null,null,3,null,"15%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ30,'PU FMR Amts'!$A$2:$F$233,AP30,FALSE),\"\")","v":179821.42088845969},null,null,{"$f":"IFERROR(VLOOKUP(AQ30,'PU FMR Amts'!$G$2:$L$233,AP30,FALSE),\"\")","v":232965},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP30,FALSE)*0.95*12,\"\")","v":20109.599999999999},null,null,0,null,null,null,null,null,null,null,5,{"$f":"IF(F30=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F30)","v":"Sacramento15%"}]
[null,null,null,"4+",null,"15%",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(AQ31,'PU FMR Amts'!$A$2:$F$233,AP31,FALSE),\"\")","v":185295.21841533537},null,null,{"$f":"IFERROR(VLOOKUP(AQ31,'PU FMR Amts'!$G$2:$L$233,AP31,FALSE),\"\")","v":238439},null,null,0,null,null,null,null,null,0,null,null,{"$f":"IFERROR(VLOOKUP('A - Applicant & Min Requirement'!$J$3,'PU FMR Amts'!$M$2:$R$59,AP31,FALSE)*0.95*12,\"\")","v":24430.199999999997},null,null,0,null,null,null,null,null,null,null,6,{"$f":"IF(F31=\"\",0,'A - Applicant & Min Requirement'!$J$3&\"\"&F31)","v":"Sacramento15%"}]
[null,null,null,"Total Units: ",null,null,null,{"$f":"SUM(H12:I31)","v":0},null,{"$f":"SUM(J12:K31)","v":0},null,{"$f":"SUM(L12:M31)","v":0},null,{"$f":"SUM(N12:O31)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(V12:X31)","v":0},null,null,null,null,null,{"$f":"SUM(AB12:AD31)","v":0},null,null,null,null,null,{"$f":"SUM(AH12:AJ31)","v":0}]
["Applicants Requesting COSR: Describe methodology used to estimate per unit COSR amount that is consistent with §207"]
[]
["Applicant agrees to use awarded grant funds pursuant to §203"]
["CERTIFICATION"]
["The information, statements and, attachments included in this \"Unit Mix & Award Amt\" worksheet are, to the best of my knowledge and belief, true and correct."]
["     "]
["Printed Name",null,null,null,null,null,null,null,null,null,"Title of Signatory",null,null,null,null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"C - Selection Criteria","index":5,"n_rows":62,"n_cols":39,"rows_kept":62,"cut":false,"hidden":false,"merged":[[30,0,30,8],[35,0,35,35],[33,0,33,35],[19,23,19,33],[19,34,19,37],[14,34,14,37],[15,34,15,37],[14,21,14,22],[15,21,15,22],[16,17,16,20],[16,21,16,22],[32,0,32,8],[32,9,32,35],[21,0,21,35],[23,0,23,35],[25,0,25,35],[28,0,28,35],[28,36,28,37],[29,36,29,37],[29,9,29,35],[29,0,29,8],[21,36,21,37],[23,36,23,37],[25,36,25,37],[24,0,24,37],[45,11,45,29],[45,30,45,35],[47,3,47,4],[47,5,47,10],[45,5,45,10],[45,3,45,4],[42,3,42,4],[42,5,42,10],[40,5,40,10],[40,3,40,4],[42,11,42,29],[42,30,42,35],[35,36,35,37],[37,0,37,35],[38,0,38,35],[38,36,38,37],[36,0,36,37],[47,0,47,2],[47,11,47,29],[47,30,47,35],[47,36,47,37],[44,0,44,32],[44,33,44,35],[44,36,44,37],[46,0,46,32],[46,33,46,35],[46,36,46,37],[40,0,40,2],[40,11,40,29],[40,30,40,35],[40,36,40,37],[42,0,42,2],[42,36,42,37],[45,0,45,2],[57,0,57,35],[57,36,57,37],[56,36,56,37],[54,0,54,37],[2,0,2,35],[6,36,6,37],[4,21,4,23],[4,0,4,20],[13,0,13,35],[5,27,5,29],[5,19,5,23],[5,0,5,18],[8,36,8,37],[8,34,8,35],[6,11,6,28],[6,29,6,35],[7,0,7,35],[7,36,7,37],[9,36,9,37],[10,36,10,37],[9,34,9,35],[10,34,10,35],[16,23,16,33],[14,23,14,33],[61,36,61,37],[58,0,58,33],[58,34,58,35],[58,36,58,37],[59,0,59,33],[59,34,59,35],[59,36,59,37],[60,36,60,37],[60,11,60,29],[60,30,60,35],[61,11,61,29],[61,30,61,35],[61,5,61,10],[60,5,60,10],[61,3,61,4],[60,3,60,4],[61,0,61,2],[60,0,60,2],[15,23,15,33],[13,36,13,37],[53,0,53,35],[53,36,53,37],[55,36,55,37],[56,11,56,29],[56,30,56,35],[55,11,55,29],[55,30,55,35],[55,0,55,2],[55,3,55,4],[55,5,55,10],[56,0,56,2],[56,3,56,4],[56,5,56,10],[45,36,45,37],[39,36,39,37],[41,36,41,37],[39,33,39,35],[41,33,41,35],[39,0,39,32],[41,0,41,32],[43,0,43,35],[43,36,43,37],[17,34,17,37],[32,36,32,37],[52,36,52,37],[52,0,52,35],[11,36,11,37],[34,0,34,37],[11,29,11,35],[1,0,1,24],[1,25,1,35],[1,36,1,37],[4,24,4,30],[5,33,5,35],[5,30,5,32],[5,24,5,26],[3,0,3,35],[3,36,3,37],[5,36,5,37],[4,31,4,33],[4,34,4,35],[4,36,4,37],[2,36,2,37],[11,11,11,28],[12,0,12,35],[12,36,12,37],[6,5,6,10],[11,5,11,10],[50,0,50,35],[51,0,51,37],[48,0,48,35],[8,0,8,33],[9,0,9,33],[10,0,10,33],[22,0,22,37],[26,0,26,37],[27,0,27,35],[48,36,48,37],[49,0,49,37],[50,36,50,37],[14,17,14,20],[15,17,15,20],[19,21,19,22],[19,1,19,16],[19,17,19,20],[37,36,37,37],[33,36,33,37],[27,36,27,37],[16,1,16,16],[17,23,17,33],[11,3,11,4],[11,0,11,2],[30,9,30,35],[30,36,30,37],[31,0,31,8],[0,35,0,37],[0,0,0,34],[14,0,14,16],[15,1,15,16],[18,1,18,16],[18,17,18,20],[18,21,18,22],[18,23,18,33],[31,9,31,35],[31,36,31,37],[20,0,20,35],[18,34,18,37],[20,36,20,37],[16,34,16,37],[17,1,17,16],[17,17,17,20],[17,21,17,22],[6,0,6,2],[6,3,6,4]]}
["Selection Criteria §213 (145 Points Max )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!AI1","v":"Rev. 7/3/19"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Self Score",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AK3,AK13,AK38,AK53,AK58)","v":0}]
["Need §213(a) - 25 Points Max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK4+AK8","v":0}]
["(1) Estimated Need based on Applicant's geographic jurisdiction - 10  Points Max.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(SUM(AK5:AL6),10)","v":0}]
["(a) Points awarded if more than 400 individuals are Homeless using the latest Point in Time Count (PIT) as stated in the NOFA - 10 points. OR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"County:",null,null,{"$f":"'A - Applicant & Min Requirement'!J3","v":"Sacramento"},null,null,null,null,null,null,"County PIT:",null,null,null,null,{"$f":"IF(AI5>=400,10,0)","v":0}]
["(b) More than half of the Extremely low income (ELI) population that pay more than 50% of their income towards rent - 5 points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELI pop. paying >50% to rent",null,null,null,null,{"$f":"VLOOKUP('A - Applicant & Min Requirement'!J3,'CHAS Data'!A2:C59,2,FALSE)","v":1368},null,null,"Total ELI pop.",null,null,{"$f":"VLOOKUP('A - Applicant & Min Requirement'!J3,'CHAS Data'!A2:C59,3,FALSE)","v":62015},null,null,{"$f":"Y6/AE6","v":2.2059179230831252E-2},null,null,{"$f":"IFERROR(IF(AH6>0.5,5,0),\"\")","v":0}]
["File Name:",null,null,{"$f":"'Application Checklist'!A25","v":"C2"},null,"PIT Cert Letter",null,null,null,null,null,"Letter from CoC Certifying PIT Count. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["(2) Describe the Applicant’s demonstrated commitment to address the needs of people experiencing homelessness. Applicant has demonstrated successful outcomes in implementing federal and state programs addressing the needs of people experiencing homelessness, along with local commitment of resources - 15  Points Max.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(MAX(AK9,AK10,AK11),15)","v":0}]
["(a) The Applicant has dedicated local resources to provide Permanent housing to residents experiencing homelessness over the last three years and has a plan to address homelessness. The plan has been successful and has been implemented for at least one year - 15 points. OR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI9=\"Yes\",15,0)","v":0}]
["(b) The Applicant has administered programs with successful outcomes in moving people from homelessness to Permanent housing but has not dedicated resources consistently over the last three years. The Applicant has a plan to address homelessness and has been implementing it over the last year - 10 points. OR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI10=\"Yes\",10,0)","v":0}]
["(c) The Applicant proposes to implement some actions in the next 12 months, including implementation of a plan to address homelessness and dedication of local resources - 5 points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI11=\"Yes\",5,0)","v":0}]
["File Name:",null,null,{"$f":"'Application Checklist'!A26","v":"C3"},null,"Homelessness Plan",null,null,null,null,null,"Attach Applicant's homelessness plan.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Proposed Uses and Process for Using Funds §213(b) - 30 Points Max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK14+AK21+AK28","v":0}]
["(1) Applicant’s description (either address or narrative) of the specific uses of the grant funds. (must provide all information below to receive points). (a) If the Applicant intends to use funding for development, project(s)’ location and target date(s) for completion; OR (b) If the Applicant intends to use funding for rental assistance or a COSR, project(s)’ total number of units and the total number of households who will receive Permanent housing and/or rental subsidies under the project. - 10 Points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AM16=\"Yes\",AM17=\"Yes\",AM18=\"Yes\",AM19=\"Yes\",AM20=\"Yes\"),10,0)","v":0}]
["Project Address/ Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Type",null,null,null,"Total Units ",null,"# of Households that will receive Permanent Housing and/or Rental Subsidies",null,null,null,null,null,null,null,null,null,null,"Target Date Completion"]
["1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"No\",IF(AND(R16<>\"\",V16<>\"\",X16<>\"\",AI16<>\"\"),\"Yes\",\"No\"))","v":"No"}]
["2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B17=\"\",\"Yes\",IF(AND(R17<>\"\",V17<>\"\",X17<>\"\",AI17<>\"\"),\"Yes\",\"No\"))","v":"Yes"}]
["3.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B18=\"\",\"Yes\",IF(AND(R18<>\"\",V18<>\"\",X18<>\"\",AI18<>\"\"),\"Yes\",\"No\"))","v":"Yes"}]
["4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["5.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["(2) Process for Using Grant Funds (must provide descriptions for the following to receive points) - 10 Points Max.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AM23=\"Yes\",AM25=\"Yes\",AM27=\"Yes\"),10,0)","v":0}]
["(a) The Applicant’s or agency or agencies responsible for the distribution of the HHC grant funds and the proposed selection criteria and process to identify project(s) and/or sub-recipient(s) - 6 Points:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM23=\"yes\",6,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A23=\"\",\"No\",\"Yes\")","v":"No"}]
["(b) The timeline with clearly delineated milestones - 1 Point:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM25=\"yes\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A25=\"\",\"No\",\"Yes\")","v":"No"}]
["(c) The proposed funding source for the services - 3 Points:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM27=\"yes\",3,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A27=\"\",\"No\",\"Yes\")","v":"No"}]
["(3) Funding Coordination (must provide descriptions for the following to receive points) - 10 Points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AK29,AK34,AK36)","v":0}]
["(a) Applicant's description of the following service provisions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AK30:AL33)","v":0}]
["(1) The funding source(s) - 2 points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM30=\"yes\",2,0)","v":0},null,{"$f":"IF(J30=\"\",\"No\",\"Yes\")","v":"No"}]
["(2) The amount of funding per participant, per month, the Applicant intends to commit - 1 Point",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM31=\"yes\",1,0)","v":0},null,"No"]
["(3) The length of time services will be provided - 1 Point.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM32=\"yes\",1,0)","v":0},null,"No"]
["(4) The process for selecting the Homeless service provider - 2 Points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM33=\"yes\",2,0)","v":0},null,{"$f":"IF(J33=\"\",\"No\",\"Yes\")","v":"No"}]
["(b) The Applicant’s partnerships with affordable and Supportive housing providers to address homelessness - 2 Points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM35=\"yes\",2,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A35=\"\",\"No\",\"Yes\")","v":"No"}]
["(c) Applicant’s partnerships with healthcare providers who provide dental, mental health, primary care and substance abuse services - 2 Points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM37=\"yes\",2,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A37=\"\",\"No\",\"Yes\")","v":"No"}]
["Experience §213(c) - 40 Points Max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK39+AK44+AK49+AK51","v":0}]
["(1) The Applicant’s experience, for the last three years, in funding and underwriting Supportive housing projects; and/or the Applicant’s experience administering Supportive housing projects; and/or the Applicant’s experience working with agencies that administer rental subsidies. - 15 points max.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(MAX(AK40,AK42),15)","v":0}]
["If Applicant intends to use funding for development or a COSR, enter the number of Projects Applicant has developed and/or administered in the last 3 Years:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH40=\"4+\",15,IF(AH40=\"2 to 3\",10,IF(AH40=1,5,0)))","v":0}]
["File Name:",null,null,{"$f":"'Application Checklist'!A27","v":"C4"},null,"Dev Exp 1, 2, 3, etc",null,null,null,null,null,"Notice of Completion, Placed in Service, Certificate of Occ. or equivalent.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["If Applicant intends to use funding for rental assistance, enter the number of households Applicant has administered rental subsidies for in the last 3 years:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH42=\"500+\",15,IF(AH42=\"300 to 499\",10,IF(AH42=\"100 to 299\",5,0)))","v":0}]
["File Name:",null,null,{"$f":"'Application Checklist'!A28","v":"C5"},null,"Rent Contracts 1, 2, 3, etc",null,null,null,null,null,"Copies of Rental Assistance contracts.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["(2) The Applicant’s development funding, rental assistance, or other operating assistance to the Target Population that is comparable in scale and scope to the number of projects or rental assistance the Applicant has proposed for the Program. - 15 points max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(MAX(AK45,AK47),15)","v":0}]
["If Applicant intends to use funding for development or a COSR, enter the number of Projects comparable in scale and scope to the proposed project and Target Population that Applicant has developed and/or administered in last 3 Years:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH45=\"4+\",15,IF(AH45=\"2 to 3\",10,IF(AH45=1,5,0)))","v":0}]
["File Name:",null,null,{"$f":"'Application Checklist'!A29","v":"C6"},null,"TP Dev Exp 1, 2, 3, etc",null,null,null,null,null,"Notice of Completion, Placed in Service, Certificate of Occ. or equivalent.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["If Applicant intends to use funding for rental assistance, enter the number of clients similar to the Target Population the administering agency has administered rental subsidies for in the last 3 years:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH47=\"500+\",15,IF(AH47=\"300 to 499\",10,IF(AH47=\"100 to 299\",5,0)))","v":0}]
["File Name:",null,null,{"$f":"'Application Checklist'!A30","v":"C7"},null,"TP Rent Contracts 1, 2, 3, etc",null,null,null,null,null,"Copies of Rental Assistance contracts.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["(3) Describe barrier(s) the Applicant encountered in the implementation of its Homeless strategy or funding and how barriers were resolved  - 5 points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A50=\"\",0,5)","v":0}]
[]
["(4) Describe any best practices developed by the Applicant that could be used for other program participants. - 5 points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A52=\"\",0,5)","v":0}]
[]
["Funding Sources §213(d) - 30 Points Max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK54","v":0}]
["(1) Applicant’s description of the plan to sustain funding for the program/project. The Applicant may commit to using funding from the Building Homes & Jobs Act allocations to score points in this category. - 30 points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A55=\"\",0,30)","v":0}]
[]
["File Name:",null,null,{"$f":"'Application Checklist'!A31","v":"C8"},null,"Funding Commitments",null,null,null,null,null,"Attach letter(s) of commitment from funding sources.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,{"$f":"'Application Checklist'!A32","v":"C9"},null,"Feasibility Study",null,null,null,null,null,"Attach documentation of applicants determination the project’s feasibility showing there is no financial gap that needs to be addressed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Incentive Points §213(e) - 20 Points Max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK59+AK60","v":0}]
["(1) The Applicant has a Whole Person Care Pilot Program or is working with managed care organizations to make available Health Homes Program benefits to people experiencing homelessness. - 10 points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI59=\"Yes\",10,0)","v":0}]
["(2) Evidence demonstrating locally committed funding program for projects in an amount at least equivalent to requested HHC funding. - 10 points.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI60=\"Yes\",10,0)","v":0}]
["File Name:",null,null,{"$f":"'Application Checklist'!A33","v":"C10"},null,"Homeless Benefits Program",null,null,null,null,null,"Whole Person Care Pilot Program documents or documentation of a Health Homes Program benefitting people experiencing homelessness.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,{"$f":"'Application Checklist'!A34","v":"C11"},null,"Funding Program",null,null,null,null,null,"Documentation of a locally committed funding  program for projects in an amount at least equivalent to requested HHC funding.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]

{"sheet":"D - Supportive Services Plan","index":6,"n_rows":81,"n_cols":39,"rows_kept":81,"cut":false,"hidden":false,"merged":[[22,30,22,33],[22,34,22,37],[32,34,32,37],[33,0,33,15],[33,16,33,20],[2,3,2,4],[2,5,2,10],[75,5,75,9],[75,3,75,4],[17,0,17,5],[73,0,73,37],[75,0,75,2],[75,10,75,29],[75,30,75,35],[75,36,75,37],[74,36,74,37],[74,0,74,35],[67,0,67,37],[68,0,68,37],[69,0,69,37],[70,0,70,37],[71,0,71,37],[72,0,72,37],[23,0,23,37],[24,0,24,37],[21,6,21,21],[21,22,21,26],[21,27,21,29],[76,0,76,37],[77,0,77,37],[78,0,78,37],[22,6,22,21],[22,22,22,26],[22,27,22,29],[21,0,21,5],[21,30,21,33],[21,34,21,37],[35,16,35,20],[35,21,35,25],[35,26,35,33],[35,34,35,37],[36,0,36,15],[36,16,36,20],[36,21,36,33],[36,34,36,37],[37,0,37,15],[22,0,22,5],[37,16,37,20],[79,0,79,37],[80,0,80,37],[81,0,81,37],[25,0,25,37],[26,0,26,37],[27,0,27,37],[28,0,28,37],[29,0,29,37],[30,0,30,37],[31,0,31,15],[31,16,31,20],[31,21,31,25],[31,26,31,33],[31,34,31,37],[32,0,32,15],[32,16,32,20],[32,21,32,25],[32,26,32,33],[34,0,34,15],[34,16,34,20],[34,21,34,25],[34,26,34,33],[34,34,34,37],[35,0,35,15],[20,0,20,5],[20,30,20,33],[20,34,20,37],[20,6,20,21],[20,22,20,26],[20,27,20,29],[16,0,16,5],[15,0,15,5],[14,0,14,5],[14,30,14,33],[14,34,14,37],[19,0,19,5],[19,30,19,33],[19,34,19,37],[18,0,18,5],[18,30,18,33],[18,34,18,37],[18,6,18,21],[18,22,18,26],[18,27,18,29],[19,6,19,21],[19,22,19,26],[19,27,19,29],[15,6,15,21],[13,0,13,5],[13,30,13,33],[13,34,13,37],[13,6,13,21],[13,22,13,26],[13,27,13,29],[14,6,14,21],[14,22,14,26],[14,27,14,29],[0,35,0,37],[0,0,0,34],[10,0,10,5],[10,30,10,33],[10,34,10,37],[9,0,9,5],[9,30,9,33],[9,34,9,37],[9,6,9,21],[9,22,9,26],[9,27,9,29],[10,6,10,21],[10,22,10,26],[10,27,10,29],[1,0,1,37],[3,0,3,37],[4,0,4,37],[5,0,5,37],[6,0,6,37],[7,0,7,37],[8,0,8,5],[8,30,8,33],[8,34,8,37],[8,6,8,21],[8,22,8,26],[8,27,8,29],[2,0,2,2],[2,11,2,29],[2,30,2,35],[2,36,2,37],[33,21,33,25],[33,26,33,33],[33,34,33,37],[17,34,17,37],[16,34,16,37],[15,34,15,37],[12,0,12,5],[12,30,12,33],[12,34,12,37],[11,0,11,5],[11,30,11,33],[11,34,11,37],[11,6,11,21],[11,22,11,26],[11,27,11,29],[12,6,12,21],[12,22,12,26],[12,27,12,29],[37,21,37,25],[37,26,37,33],[37,34,37,37],[38,0,38,37],[39,0,39,10],[39,11,39,12],[39,13,39,15],[39,16,39,20],[39,21,39,25],[39,26,39,33],[39,34,39,37],[40,0,40,10],[40,11,40,12],[40,13,40,15],[40,16,40,20],[40,21,40,25],[40,26,40,33],[40,34,40,37],[41,0,41,10],[41,11,41,12],[41,13,41,15],[41,16,41,20],[41,21,41,25],[41,26,41,33],[41,34,41,37],[42,0,42,10],[42,11,42,12],[42,13,42,15],[42,16,42,20],[42,21,42,25],[42,26,42,33],[42,34,42,37],[43,0,43,15],[43,16,43,20],[43,21,43,25],[43,26,43,33],[43,34,43,37],[44,0,44,15],[44,16,44,20],[44,21,44,33],[44,34,44,37],[45,0,45,15],[45,16,45,20],[45,21,45,25],[45,26,45,33],[45,34,45,37],[46,0,46,15],[46,16,46,20],[46,21,46,25],[46,26,46,33],[46,34,46,37],[47,0,47,15],[47,16,47,20],[47,21,47,25],[47,26,47,33],[47,34,47,37],[48,0,48,15],[48,16,48,20],[48,21,48,25],[48,26,48,33],[48,34,48,37],[52,0,52,15],[52,16,52,20],[52,21,52,25],[52,26,52,33],[52,34,52,37],[49,0,49,15],[49,16,49,20],[49,21,49,25],[49,26,49,33],[49,34,49,37],[50,0,50,15],[50,16,50,20],[50,21,50,25],[50,26,50,33],[50,34,50,37],[51,0,51,15],[51,16,51,20],[51,21,51,25],[51,26,51,33],[66,0,66,37],[57,0,57,37],[55,0,55,15],[55,16,55,20],[55,21,55,25],[55,26,55,33],[55,34,55,37],[56,0,56,15],[56,16,56,20],[56,21,56,33],[56,34,56,37],[58,0,58,37],[59,0,59,37],[60,0,60,37],[61,0,61,37],[62,0,62,37],[63,0,63,37],[53,34,53,37],[54,0,54,15],[54,16,54,20],[54,21,54,25],[54,26,54,33],[54,34,54,37],[51,34,51,37],[64,0,64,37],[65,0,65,37],[53,0,53,15],[53,16,53,20],[53,21,53,25],[53,26,53,33],[16,6,16,21],[17,6,17,21],[15,22,15,26],[15,27,15,29],[15,30,15,33],[16,22,16,26],[16,27,16,29],[16,30,16,33],[17,22,17,26],[17,27,17,29],[17,30,17,33]]}
["Supportive Services Plan §214",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!AI1","v":"Rev. 7/3/19"}]
["All projects must include a SSP meeting §214 requirements. Be as specific as possible. The checklist below serves as a guide to ensure all the components of the SSP are complete."]
["File Name:",null,null,{"$f":"'Application Checklist'!A38","v":"D2"},null,"SSP",null,null,null,null,null,"Attach a Supportive Services Plan as specified in §214.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Tenant Outreach, Engagement, and Retention Strategies §214 (d)(1) "]
["Services in the HHC Program must be voluntary, flexible, and individualized so that HHC tenants may continue to engage with supportive services providers, even as the intensity of services needed may change. Adaptability in the level of services should support tenant engagement and housing retention. Describe the plan for conducting tenant outreach, engagement and retention strategies to be used in support of these Program objectives."]
[]
["List of Services §214 (d)(2)"]
["Pursuant to §214 (d)(2), identify all required services, and any other services that are encouraged to be part of the SSP, in the table below. Provide a detailed description of each service to be offered, the frequency of each service, the proposed service provider, location, and general hours of availability of the services."]
["§214 (c ), Required Services",null,null,null,null,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Provider",null,null,null,null,"Miles from Project Site",null,null,"Frequency of Offered Service",null,null,null,"Hrs. Available\n(for example)\n8 am - 5 pm"]
["(1) Housing Navigation "]
["(2) Case management"]
["(3) Peer support activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
["(4) Support linking to behavior health care",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case management"]
["(5) Support linking to substance abuse disorder treatment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peer support activities"]
["(6) Support linking to primary care services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mental health care"]
["(7) Benefits counseling and advocacy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Substance use services"]
["(8) Basic housing retention skills",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Linkage to physical health care"]
["(9) Services for persons with co-occurring disabilities/disorders"]
["Optional (encouraged) Services:",null,null,null,null,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Provider",null,null,null,null,"Miles from Project Site",null,null,"Frequency of Offered Service",null,null,null,"Hrs. Available\n(for example)\n8 am - 5 pm",null,null,null,"Benefits counseling and advocacy"]
["(1) Recreational and social activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basic housing retention skills"]
["(2) Educational services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Services for co-occurring mental and physical disabilities"]
["(3) Employment services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recreational and social activities"]
["(4) Obtaining access to other needed services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Educational services"]
["Transportation Plan §214 (d)(3)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employment services"]
["For services provided off-site, (not at the project site), provide a detailed narrative on what transportation options will be available to tenants in order to provide them with reasonable access to these services. Reasonable access is access that does not require walking more than ½ mile.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Access to other services"]
[]
["Services Competency §214 (d)(4) "]
["(A) Describe how the services are linguistically and culturally competent for persons of different races, ethnicities, sexual orientations, gender identities, and gender expressions. (B) Explain how services will be provided to HHC tenants who do not speak English, or have other communication barriers, including sensory disabilities. (C) Explain how communication among the services providers, the property manager, and these tenants will be facilitated."]
[]
["Estimated Itemized Budget §214(d)(5) "]
["Provide a line item Supportive Services Budget for project using format below. Complete both income and expense portions of the budget.  Include all costs associated with implementing your Supportive Services Plan, including any in-kind services.  Include income and expenses for Sponsor or LSP staff positions, and also any staff positions of partnering organizations who have committed time to the project.  Don't include costs associated with providing services in non-HHC assisted units.  If costs are associated with both HHC & non-HHC assisted units, include only that portion of costs associated with HHC assisted units."]
["Income Source/Program Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount",null,null,null,null,"Type",null,null,null,null,"Status",null,null,null,null,null,null,null,"% of Total Budget"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$37=0,0,Q33/$Q$37)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$37=0,0,Q34/$Q$37)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Revenue:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q33:U36)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Expense Item",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount",null,null,null,null,"Type",null,null,null,null,"Status",null,null,null,null,null,null,null,"% of Total Budget"]
["Staff Salaries:  List by title of position. (This list must match the Staffing Chart above.)"]
["Staff Position",null,null,null,null,null,null,null,null,null,null,"FTE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$45=0,0,Q40/$Q$45)","v":0}]
["Staff Position",null,null,null,null,null,null,null,null,null,null,"FTE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$45=0,0,Q41/$Q$45)","v":0}]
["Staff Position",null,null,null,null,null,null,null,null,null,null,"FTE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$45=0,0,Q42/$Q$45)","v":0}]
["Staff Position",null,null,null,null,null,null,null,null,null,null,"FTE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Fringe Benefits ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Staff Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q40:U44)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Tenant Transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$57=0,0,Q46/$Q$57)","v":0}]
["Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$57=0,0,Q47/$Q$57)","v":0}]
["Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Office Rent/Occupancy Costs (don't include rent/leasing costs for SH units)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Training",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Consultants:  List by Function",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Subcontractors/Partners (list by Entity & Service Type)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other Expenses (type in expense description)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other Expenses (type in expense description)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other Expenses (type in expense description)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q45:U56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Supportive Services Cost Per Unit: Permanent supportive housing best practice suggests a range between $5,000 - $10,000 annually in services per household, depending upon the intensity of the needs of the target population."]
["Budget Narrative and Funding Commitments"]
["1.  Describe how budgeted amts. are adequate to provide services described in Supportive Services Plan and in Services Staffing Table:"]
[]
["2.  Document committed funds with letter from committing agency that includes the following. Documented services/funding must appear in Supportive Services Budget Table. "]
["a) Project name; b) Description of services to be funded or provided; c) Dollar value of funds or in-kind services.  If cash is  provided, state funding source; d) Funding term or service provision; e) A description and history of agency/organization providing funding or services."]
["3.  For funding that is not yet committed, specifically describe your experience filling major services funding gaps in similar housing."]
[]
["4. Describe in specific terms the plan to fill any service gaps that occur during project life due to expiration of grants, partner withdrawals, cancellation of a commitment or any other reason. Describe experience filling service gaps caused by loss of major funding sources."]
[]
["Collaboration of Supportive Services and Property Management Staff §214 (d)(6) "]
["Describe how the supportive services staff and property management staff will collaborate to prevent evictions, adopt and ensure compliance with harm reduction principles, and facilitate the implementation of reasonable accommodation policies from rent-up to on-going Project operations."]
[]
["Communication Protocols §214 (d)(7) "]
["Provide a detailed narrative on the communication protocols to be utilized by the services providers and the property manager."]
[]
["Provider-to-Client Staff Ratio §214 (d)(8) "]
["Service provider will maintain at least a 1:20 provider-to-client staff Ratio?"]
["File Name:",null,null,{"$f":"'Application Checklist'!A39","v":"D3"},null,"Org. Chart/ Resumes",null,null,null,null,"Attach copies provider org. charts, staff resumes, and duty statements.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Project Physical Design §214 (d)(9) "]
["Provide a detailed narrative on how the physical design of the Project fosters tenant engagement, on-site supportive services provision, security and safety, and sustainability of equipment, furnishings, and fixtures."]
[]
["Other Additional Information §214 (d)(10) "]
["Provide any other information necessary to evaluate the supportive services to be offered consistent with HHC Program requirements."]

{"sheet":"E - Certification","index":7,"n_rows":10,"n_cols":37,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,0,5,37],[6,0,6,37],[7,0,7,37],[0,0,0,37],[1,0,1,37],[2,0,2,37],[3,0,3,37],[4,0,4,37],[8,20,8,33],[8,35,8,37],[9,0,9,8],[9,10,9,18],[9,20,9,33],[8,0,8,8],[8,10,8,18]]}
["Certifications"]
["State of California"]
["On behalf of the entity identified in the signature block below, I certify that:"]
["1. The information, statements and attachments included in this application are, to the best of my knowledge and belief, true and correct."]
["2. I possess the legal authority to submit this application on behalf of the entity identified in the signature block."]
["3. As of the date of application, the Project, or the real property on which the Project is proposed (Property) is not part to or the subject of any claim or action at the State or Federal appellate level."]
["4. I have disclosed and described below any claim or action undertaken which affects or potentially affects the feasibility of the Project."]
["In addition, I acknowledge that all information in this application and attachments is public, and may be disclosed by the State."]
["     "]
["Printed Name",null,null,null,null,null,null,null,null,null,"Title of Signatory",null,null,null,null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"Application Support","index":8,"n_rows":31,"n_cols":42,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,35],[0,36,0,37],[1,0,1,37],[2,0,2,2],[2,3,2,21],[2,22,2,25],[2,26,2,29],[2,30,2,33],[2,34,2,37],[3,0,3,3],[3,4,3,14],[3,15,3,16],[3,17,3,27],[3,28,3,31],[3,32,3,37],[4,0,4,37],[5,0,5,1],[5,2,5,4],[5,5,5,8],[5,9,5,14],[5,15,5,16],[5,17,5,28],[5,29,5,31],[5,32,5,34],[5,35,5,37],[6,0,6,1],[6,2,6,4],[6,5,6,8],[6,9,6,14],[6,15,6,16],[6,17,6,28],[6,29,6,31],[6,32,6,34],[6,35,6,37],[7,0,7,1],[7,2,7,4],[7,5,7,8],[7,9,7,14],[7,15,7,16],[7,17,7,28],[7,29,7,31],[7,32,7,34],[7,35,7,37],[8,0,8,1],[8,2,8,4],[8,5,8,8],[8,9,8,14],[8,15,8,16],[8,17,8,28],[8,29,8,31],[8,32,8,34],[8,35,8,37],[9,0,9,1],[9,2,9,4],[9,5,9,8],[9,9,9,14],[9,15,9,16],[9,17,9,28],[9,29,9,31],[9,32,9,34],[9,35,9,37],[10,0,10,1],[10,2,10,4],[10,5,10,8],[10,9,10,14],[10,15,10,16],[10,17,10,28],[10,29,10,31],[10,32,10,34],[10,35,10,37],[11,0,11,1],[11,2,11,4],[11,5,11,8],[11,9,11,14],[11,15,11,16],[11,17,11,28],[11,29,11,31],[11,32,11,34],[11,35,11,37],[12,0,12,1],[12,2,12,4],[12,5,12,8],[12,9,12,14],[12,15,12,16],[12,17,12,28],[12,29,12,31],[12,32,12,34],[12,35,12,37],[13,0,13,1],[13,2,13,4],[13,5,13,8],[13,9,13,14],[13,15,13,16],[13,17,13,28],[13,29,13,31],[13,32,13,34],[13,35,13,37],[14,0,14,1],[14,2,14,4],[14,5,14,8],[14,9,14,14],[14,15,14,16],[14,17,14,28],[14,29,14,31],[14,32,14,34],[14,35,14,37],[15,0,15,1],[15,2,15,4],[15,5,15,8],[15,9,15,14],[15,15,15,16],[15,17,15,28],[15,29,15,31],[15,32,15,34],[15,35,15,37],[16,0,16,1],[16,2,16,4],[16,5,16,8],[16,9,16,14],[16,15,16,16],[16,17,16,28],[16,29,16,31],[16,32,16,34],[16,35,16,37],[17,0,17,1],[17,2,17,4],[17,5,17,8],[17,9,17,14],[17,15,17,16],[17,17,17,28],[17,29,17,31],[17,32,17,34],[17,35,17,37],[18,0,18,1],[18,2,18,4],[18,5,18,8],[18,9,18,14],[18,15,18,16],[18,17,18,28],[18,29,18,31],[18,32,18,34],[18,35,18,37],[19,0,19,1],[19,2,19,4],[19,5,19,8],[19,9,19,14],[19,15,19,16],[19,17,19,28],[19,29,19,31],[19,32,19,34],[19,35,19,37],[20,0,20,1],[20,2,20,4],[20,5,20,8],[20,9,20,14],[20,15,20,16],[20,17,20,28],[20,29,20,31],[20,32,20,34],[20,35,20,37],[21,0,21,1],[21,2,21,4],[21,5,21,8],[21,9,21,14],[21,15,21,16],[21,17,21,28],[21,29,21,31],[21,32,21,34],[21,35,21,37],[22,0,22,1],[22,2,22,4],[22,5,22,8],[22,9,22,14],[22,15,22,16],[22,17,22,28],[22,29,22,31],[22,32,22,34],[22,35,22,37],[23,0,23,1],[23,2,23,4],[23,5,23,8],[23,9,23,14],[23,15,23,16],[23,17,23,28],[23,29,23,31],[23,32,23,34],[23,35,23,37],[24,0,24,1],[24,2,24,4],[24,5,24,8],[24,9,24,14],[24,15,24,16],[24,17,24,28],[24,29,24,31],[24,32,24,34],[24,35,24,37],[25,0,25,1],[25,2,25,4],[25,5,25,8],[25,9,25,14],[25,15,25,16],[25,17,25,28],[25,29,25,31],[25,32,25,34],[25,35,25,37],[26,0,26,1],[26,2,26,4],[26,5,26,8],[26,9,26,14],[26,15,26,16],[26,17,26,28],[26,29,26,31],[26,32,26,34],[26,35,26,37],[27,0,27,1],[27,2,27,4],[27,5,27,8],[27,9,27,14],[27,15,27,16],[27,17,27,28],[27,29,27,31],[27,32,27,34],[27,35,27,37],[28,0,28,1],[28,2,28,4],[28,5,28,8],[28,9,28,14],[28,15,28,16],[28,17,28,28],[28,29,28,31],[28,32,28,34],[28,35,28,37],[29,0,29,1],[29,2,29,4],[29,5,29,8],[29,9,29,14],[29,15,29,16],[29,17,29,28],[29,29,29,31],[29,32,29,34],[29,35,29,37],[30,29,30,31],[30,32,30,34],[30,35,30,37],[30,0,30,1],[30,2,30,4],[30,5,30,8],[30,9,30,14],[30,15,30,16],[30,17,30,28]]}
["Application Development Team (ADT)\nSupport Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A - Applicant & Min Requirement'!AI1","v":"Rev. 7/3/19"}]
["Please complete the \"yellow\" cells in the form below and email entire workbook to: AppSupport@hcd.ca.gov. A member of the Application Development Team will respond to your request ASAP. "]
["Full Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Requested:",null,null,null,null,null,null,null,"Application Version Date:"]
["Organization:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:",null,null,null,null,null,null,null,null,null,null,null,null,"Contact Phone:"]
["Justification:"]
["Issue #",null,"Program Name & Round",null,null,"Tab",null,null,null,"Section",null,null,null,null,null,"Cell#",null,"Update/Comment",null,null,null,null,null,null,null,null,null,null,null,"Urgency ",null,null,"ADT Status",null,null,"Status Date",null,null,"Requestor","Email","Phone","App Version"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7=\"\",\"\",$D$3)","v":""},{"$f":"IF(C7=\"\",\"\",$R$4)","v":""},{"$f":"IF(C7=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C7=\"\",\"\",$AI$3)","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]

{"sheet":"Sheet2","index":9,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[0,0.15]
[1,0.15]
[2,0.15]
[3,0.15]
["4+",0.15]

{"sheet":"Dropdowns","index":10,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County",null,"CoC#","CoC PIT","County PIT","Target Population"]
["Alameda","Oakland/Alameda County CoC","CA-502",5496,4657,"Chronically homeless or is Homeless and a High-cost health user upon initial eligibility"]
["Alpine","Inyo, Mono, Alpine Counties CoC","CA-613",1493,0,"Number of households similar to the Target Population applicant has administered rental subsidies for in the last 3 years:","500+ Households","4+ Projects",{"$f":"IF('C - Selection Criteria'!K40=Dropdowns!F14,G3,IF('C - Selection Criteria'!K40=#REF!,H3))","v":{"$error":"#REF!"}}]
["Amador","Amador, Calaveras, Tuolumne and Mariposa Counties CoC","CA-526",398,149]
["Butte","Chico/Paradise/Butte County CoC","CA-519",1125,1195]
["Calaveras","Amador, Calaveras, Tuolumne and Mariposa Counties CoC","CA-526",398,19]
["Colusa","Colusa, Glenn, Trinity Counties CoC","CA-523",268,5]
["Contra Costa","Richmond/Contra Costa County CoC","CA-505",2234,1607]
["Del Norte","Redding/Shasta, Siskiyou, Lassen, Plumas, Del Norte, Modoc, Sierra Counties CoC","CA-516",1149,128,"Project Type"]
["El Dorado","El Dorado County CoC","CA-525",645,602,"Acquisition"]
["Fresno","Fresno/Madera County CoC","CA-514",2144,1572,"New Construction"]
["Glenn","Colusa, Glenn, Trinity Counties CoC","CA-523",268,94,"Rehabilitation "]
["Humboldt","Humboldt County CoC","CA-522",703,759,"Development or Capitalized Operating Subsidy Reserves (COSR) "]
["Imperial","Imperial County CoC","CA-613",1493,1154,"Rental Assistance"]
["Inyo","Inyo, Mono, Alpine Counties CoC","CA-613",1493,120,1]
["Kern","Bakersfield/Kern County CoC","CA-604",885,810,"Number of projects applicant has developed and/or administered in the last 3 Years:"]
["Kings","Visalia, Kings, Tulare Counties CoC","CA-518",1129,187,"Number of households applicant has administered rental subsidies for in the last 3 years:"]
["Lake","Lake County CoC","CA-529",615,401,2]
["Lassen","Redding/Shasta, Siskiyou, Lassen, Plumas, Del Norte, Modoc, Sierra Counties CoC","CA-516",1149,107,"Number of projects applicant has developed and/or administered in the last 3 Years that are comparable in scale and scope to the proposed project and Target Population:",1,null,"Dropdown"]
["Los Angeles","Los Angeles City & County CoC","CA-600",49955,54227,"Number of households similar to the Target Population applicant has administered rental subsidies for in the last 3 years:","500+ Households","4+ Projects","4+ Projects"]
["Madera","Fresno/Madera County CoC","CA-514",2144,444,null,"300+ Households","2+ Projects","2+ Projects"]
["Marin","Marin County CoC","CA-507",1095,1117,null,"100+ Households","1 Project ","1 Project "]
["Mariposa","Amador, Calaveras, Tuolumne and Mariposa Counties CoC","CA-526",398,38,null,2]
["Mendocino","Mendocino County CoC","CA-509",880,1238,null,"500+ Households","4+ Projects","4+ Projects"]
["Merced","Merced City & County CoC","CA-520",514,454,null,"300+ Households","2+ Projects","2+ Projects"]
["Modoc","Redding/Shasta, Siskiyou, Lassen, Plumas, Del Norte, Modoc, Sierra Counties CoC","CA-516",1149,12,null,"100+ Households","1 Project ","1 Project "]
["Mono","Inyo, Mono, Alpine Counties CoC","CA-613",1493,1]
["Monterey","Salinas/Monterey, San Benito Counties CoC","CA-506",3299,2837]
["Napa","Napa City & County CoC","CA-517",322,315]
["Nevada","Nevada County CoC","CA-531",316,316]
["Orange","Santa Ana/Anaheim/Orange County CoC","CA-602",4955,4792]
["Placer","Roseville/Rocklin/Placer Counties CoC","CA-515",663,663]
["Plumas","Redding/Shasta, Siskiyou, Lassen, Plumas, Del Norte, Modoc, Sierra Counties CoC","CA-516",1149,47]
["Riverside","Riverside City & County CoC","CA-608",2316,2406]
["Sacramento","Sacramento City & County CoC","CA-503",3621,3665]
["San Benito","Salinas/Monterey, San Benito Counties CoC","CA-506",3299,527]
["San Bernardino","San Bernardino City & County CoC","CA-609",2118,1866]
["San Diego","San Diego City and County CoC","CA-601",8576,9160]
["San Francisco","San Francisco CoC","CA-501",6857,6858]
["San Joaquin","Stockton/San Joaquin County CoC","CA-511",1685,1542]
["San Luis Obispo","San Luis Obispo County CoC","CA-614",1095,1125]
["San Mateo","Daly/San Mateo County CoC","CA-512",1238,1253]
["Santa Barbara","Santa Maria/Santa Barbara County CoC","CA-603",1706,1860]
["Santa Clara","San Jose/Santa Clara City & County CoC","CA-500",7254,7394]
["Santa Cruz","Watsonville/Santa Cruz City & County CoC","CA-508",2320,2249]
["Shasta","Redding/Shasta, Siskiyou, Lassen, Plumas, Del Norte, Modoc, Sierra Counties CoC","CA-516",1149,640]
["Sierra","Redding/Shasta, Siskiyou, Lassen, Plumas, Del Norte, Modoc, Sierra Counties CoC","CA-516",1149,0]
["Siskiyou","Redding/Shasta, Siskiyou, Lassen, Plumas, Del Norte, Modoc, Sierra Counties CoC","CA-516",1149,0]
["Solano","Vallejo/Solano County CoC","CA-518",1129,1232]
["Sonoma","Santa Rosa/Petaluma/Sonoma County CoC","CA-504",2996,2835]
["Stanislaus","Turlock/Modesto/Stanislaus County CoC","CA-510",1356,1661]
["Sutter","Yuba City & County/Sutter County CoC","CA-524",765,331]
["Tehama","Tehama County CoC","CA-527",125,124]
["Trinity","Colusa, Glenn, Trinity Counties CoC","CA-523",268,77]
["Tulare","Visalia, Kings, Tulare Counties CoC","CA-518",1129,666]
["Tuolumne","Amador, Calaveras, Tuolumne and Mariposa Counties CoC","CA-526",398,161]
["Ventura","Oxnard/San Buenaventura/Ventura County CoC","CA-611",1308,1152]
["Yolo","Davis/Woodland/Yolo County CoC","CA-521",448,459]
["Yuba","Yuba City & County/Sutter County CoC","CA-524",765,429]

{"sheet":"PU FMR Amts","index":11,"n_rows":233,"n_cols":18,"rows_kept":233,"cut":false,"hidden":true,"merged":[]}
["Level*","Efficiency","1 BR","2 BR","3 BR","4+ BR","Level*","Efficiency","1 BR","2 BR","3 BR","4+ BR","Locality Name",0,1,2,3,"4+"]
["ALAMEDA30%",132862,132862,132862,132862,132862,"ALAMEDA30%",186006,186006,186006,186006,186006,"Alameda",1409,1706,2126,2925,3587]
["ALAMEDA25%",148563.15606393284,149571.48718730468,153028.62246743668,156053.61583755218,158790.51460099002,"ALAMEDA25%",201707,202715,206173,209198,211935,"Alpine",657,734,965,1378,1551]
["ALAMEDA20%",164120.26482452685,166280.97437460936,173051.19763153454,179245.23167510435,184574.98189864121,"ALAMEDA20%",217264,219425,226195,232389,237719,"Amador",814,819,1084,1567,1789]
["ALAMEDA15%",179821.42088845969,183134.50886525286,193217.82009897122,202436.84751265653,210503.4964996312,"ALAMEDA15%",232965,236279,246362,255581,263647,"Butte",808,894,1144,1654,1921]
["ALPINE30%",132862,132862,132862,132862,132862,"ALPINE30%",186006,186006,186006,186006,186006,"Calaveras",633,799,930,1345,1634]
["ALPINE25%",142945.31123371836,143665.54775041252,145826.257300495,147986.9668505775,149571.48718730468,"ALPINE25%",196089,196810,198970,201131,202715,"Colusa",608,736,893,1291,1569]
["ALPINE20%",153028.62246743668,154469.09550082503,158790.51460099002,162967.88639781618,166280.97437460936,"ALPINE20%",206173,207613,211935,216112,219425,"Contra Costa",1409,1706,2126,2925,3587]
["ALPINE15%",163111.93370115501,165272.64325123752,171754.77190148504,177948.80594505486,183134.50886525286,"ALPINE15%",216256,218417,224899,231093,236279,"Del Norte",643,749,945,1312,1516]
["AMADOR30%",132862,132862,132862,132862,132862,"AMADOR30%",186006,186006,186006,186006,186006,"El Dorado",853,968,1220,1764,2143]
["AMADOR25%",142081.02741368534,142657.21662704067,144673.87887378433,146546.49381718918,148131.01415391633,"AMADOR25%",195225,195801,197818,199690,201275,"Fresno",668,769,956,1364,1584]
["AMADOR20%",151300.05482737068,152596.48055742017,156485.75774756868,160230.98763437837,163400.02830783269,"AMADOR20%",204444,205740,209630,213375,216544,"Glenn",569,632,836,1047,1130]
["AMADOR15%",160519.08224105602,162391.69718446085,168297.63662135304,173915.48145156752,178669.04246174902,"AMADOR15%",213663,215536,221442,227059,231813,"Humboldt",665,765,998,1443,1660]
["BUTTE30%",132862,132862,132862,132862,132862,"BUTTE30%",186006,186006,186006,186006,186006,"Imperial",612,733,953,1247,1657]
["BUTTE25%",141216.74359365233,141936.98011034651,143665.54775041252,145394.11539047852,146834.58842386684,"BUTTE25%",194361,195081,196810,198538,199979,"Inyo",772,776,929,1251,1256]
["BUTTE20%",149571.48718730468,150867.91291735417,154469.09550082503,157782.18347761818,160663.12954439485,"BUTTE20%",202715,204012,207613,210926,213807,"Kern",700,711,926,1334,1587]
["BUTTE15%",158070.27808429586,159798.84572436186,165272.64325123752,170314.2988680967,174635.71796826168,"BUTTE15%",211214,212943,218417,223458,227780,"Kings",778,811,987,1427,1559]
["CALAVERAS30%",132862,132862,132862,132862,132862,"CALAVERAS30%",186006,186006,186006,186006,186006,"Lake",617,735,960,1388,1517]
["CALAVERAS25%",142369.12202036299,143089.35853705718,145106.02078380084,146978.63572720566,148563.15606393284,"CALAVERAS25%",195513,196233,198250,200123,201707,"Lassen",577,641,848,1226,1356]
["CALAVERAS20%",151876.24404072601,153316.71707411436,157205.99426426284,161095.27145441136,164264.31212786568,"CALAVERAS20%",205020,206461,210350,214239,217408,"Los Angeles",1158,1384,1791,2401,2641]
["CALAVERAS15%",161383.36606108901,163400.02830783269,169450.01504806368,175211.90718161705,180109.51549513737,"CALAVERAS15%",214527,216544,222594,228356,233254,"Madera",766,771,1020,1450,1609]
["COLUSA30%",132862,132862,132862,132862,132862,"COLUSA30%",186006,186006,186006,186006,186006,"Marin",2069,2561,3170,4153,4392]
["COLUSA25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"COLUSA25%",194217,194649,196521,198106,199546,"Mariposa",662,736,973,1337,1709]
["COLUSA20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"COLUSA20%",202283,203436,207037,210206,213087,"Mendocino",742,815,1078,1527,1735]
["COLUSA15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"COLUSA15%",210494,212223,217552,222450,226627,"Merced",579,680,839,1213,1465]
["CONTRA COSTA30%",132862,132862,132862,132862,132862,"CONTRA COSTA30%",186006,186006,186006,186006,186006,"Modoc",476,529,700,1012,1125]
["CONTRA COSTA25%",148563.15606393284,149571.48718730468,153028.62246743668,156053.61583755218,158790.51460099002,"CONTRA COSTA25%",201707,202715,206173,209198,211935,"Mono",803,945,1250,1606,2009]
["CONTRA COSTA20%",164120.26482452685,166280.97437460936,173051.19763153454,179245.23167510435,184574.98189864121,"CONTRA COSTA20%",217264,219425,226195,232389,237719,"Monterey",1089,1240,1540,2219,2378]
["CONTRA COSTA15%",179821.42088845969,183134.50886525286,193217.82009897122,202436.84751265653,210503.4964996312,"CONTRA COSTA15%",232965,236279,246362,255581,263647,"Napa",1095,1289,1705,2465,2685]
["DEL NORTE30%",132862,132862,132862,132862,132862,"DEL NORTE30%",186006,186006,186006,186006,186006,"Nevada",778,916,1211,1751,1978]
["DEL NORTE25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"DEL NORTE25%",194217,194649,196521,198106,199546,"Orange",1415,1632,2037,2862,3304]
["DEL NORTE20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"DEL NORTE20%",202283,203436,207037,210206,213087,"Placer",853,968,1220,1764,2143]
["DEL NORTE15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"DEL NORTE15%",210494,212223,217552,222450,226627,"Plumas",612,744,899,1181,1327]
["EL DORADO30%",132862,132862,132862,132862,132862,"EL DORADO30%",186006,186006,186006,186006,186006,"Riverside",826,986,1232,1717,2132]
["EL DORADO25%",143377.45314373483,144097.68966042902,146402.44651385036,148563.15606393284,150291.72370399884,"EL DORADO25%",196521,197242,199546,201707,203436,"Sacramento",853,968,1220,1764,2143]
["EL DORADO20%",153892.90628746967,155477.42662419684,159942.89302770069,164264.31212786568,167721.44740799768,"EL DORADO20%",207037,208621,213087,217408,220865,"San Benito",1314,1323,1750,2530,3074]
["EL DORADO15%",164552.40673454336,166713.11628462587,173483.33954155102,179821.42088845969,185295.21841533537,"EL DORADO15%",217696,219857,226627,232965,238439,"San Bernardino",826,986,1232,1717,2132]
["FRESNO30%",132862,132862,132862,132862,132862,"FRESNO30%",186006,186006,186006,186006,186006,"San Diego",1333,1490,1938,2776,3404]
["FRESNO25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"FRESNO25%",194217,194649,196521,198106,199546,"San Francisco",2069,2561,3170,4153,4392]
["FRESNO20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"FRESNO20%",202283,203436,207037,210206,213087,"San Joaquin",702,826,1092,1579,1918]
["FRESNO15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"FRESNO15%",210494,212223,217552,222450,226627,"San Luis Obispo",1059,1196,1542,2230,2708]
["GLENN30%",132862,132862,132862,132862,132862,"GLENN30%",186006,186006,186006,186006,186006,"San Mateo",2069,2561,3170,4153,4392]
["GLENN25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"GLENN25%",194217,194649,196521,198106,199546,"Santa Barbara",1403,1667,1951,2625,3040]
["GLENN20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"GLENN20%",202283,203436,207037,210206,213087,"Santa Clara",1952,2316,2839,3829,4394]
["GLENN15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"GLENN15%",210494,212223,217552,222450,226627,"Santa Cruz",1567,1844,2439,3241,3701]
["HUMBOLDT30%",132862,132862,132862,132862,132862,"HUMBOLDT30%",186006,186006,186006,186006,186006,"Shasta",659,758,980,1417,1721]
["HUMBOLDT25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"HUMBOLDT25%",194217,194649,196521,198106,199546,"Sierra",881,984,1294,1848,2079]
["HUMBOLDT20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"HUMBOLDT20%",202283,203436,207037,210206,213087,"Siskiyou",540,635,840,1156,1349]
["HUMBOLDT15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"HUMBOLDT15%",210494,212223,217552,222450,226627,"Solano",983,1184,1443,2086,2531]
["IMPERIAL30%",132862,132862,132862,132862,132862,"IMPERIAL30%",186006,186006,186006,186006,186006,"Sonoma",1254,1447,1887,2728,3298]
["IMPERIAL25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"IMPERIAL25%",194217,194649,196521,198106,199546,"Stanislaus",722,803,1016,1451,1715]
["IMPERIAL20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"IMPERIAL20%",202283,203436,207037,210206,213087,"Sutter",670,674,878,1269,1542]
["IMPERIAL15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"IMPERIAL15%",210494,212223,217552,222450,226627,"Tehama",599,633,837,1142,1151]
["INYO30%",132862,132862,132862,132862,132862,"INYO30%",186006,186006,186006,186006,186006,"Trinity",575,639,845,1222,1358]
["INYO25%",141936.98011034651,142801.2639303795,144673.87887378433,146546.49381718918,148131.01415391633,"INYO25%",195081,195945,197818,199690,201275,"Tulare",695,699,925,1291,1525]
["INYO20%",151156.00752403185,152596.48055742017,156485.75774756868,160086.94033103951,163255.98100449386,"INYO20%",204300,205740,209630,213231,216400,"Tuolumne",660,797,992,1365,1616]
["INYO15%",160375.0349377172,162391.69718446085,168297.63662135304,173771.4341482287,178524.99515841019,"INYO15%",213519,215536,221442,226915,231669,"Ventura",1153,1362,1795,2518,3019]
["KERN30%",132862,132862,132862,132862,132862,"KERN30%",186006,186006,186006,186006,186006,"Yolo",953,1015,1342,1935,2357]
["KERN25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"KERN25%",194217,194649,196521,198106,199546,"Yuba",670,674,878,1269,1542]
["KERN20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"KERN20%",202283,203436,207037,210206,213087]
["KERN15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"KERN15%",210494,212223,217552,222450,226627]
["KINGS30%",132862,132862,132862,132862,132862,"KINGS30%",186006,186006,186006,186006,186006]
["KINGS25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"KINGS25%",194217,194649,196521,198106,199546]
["KINGS20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"KINGS20%",202283,203436,207037,210206,213087]
["KINGS15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"KINGS15%",210494,212223,217552,222450,226627]
["LAKE30%",132862,132862,132862,132862,132862,"LAKE30%",186006,186006,186006,186006,186006]
["LAKE25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"LAKE25%",194217,194649,196521,198106,199546]
["LAKE20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"LAKE20%",202283,203436,207037,210206,213087]
["LAKE15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"LAKE15%",210494,212223,217552,222450,226627]
["LASSEN30%",132862,132862,132862,132862,132862,"LASSEN30%",186006,186006,186006,186006,186006]
["LASSEN25%",141504.83820033001,142081.02741368534,143953.64235709017,145538.16269381734,147122.68303054452,"LASSEN25%",194649,195225,197098,198682,200267]
["LASSEN20%",150147.67640066001,151300.05482737068,155045.28471418034,158358.37269097351,161383.36606108901,"LASSEN20%",203292,204444,208189,211502,214527]
["LASSEN15%",158790.51460099002,160519.08224105602,166136.92707127053,171178.58268812968,175644.04909163353,"LASSEN15%",211935,213663,219281,224323,228788]
["LOS ANGELES30%",132862,132862,132862,132862,132862,"LOS ANGELES30%",186006,186006,186006,186006,186006]
["LOS ANGELES25%",146114.35190717268,146978.63572720566,149859.58179398236,152452.43325408135,154757.19010750268,"LOS ANGELES25%",199258,200123,203004,205596,207901]
["LOS ANGELES20%",159222.65651100653,161095.27145441136,166713.11628462587,171898.81920482387,176508.33291166654,"LOS ANGELES20%",212367,214239,219857,225043,229652]
["LOS ANGELES15%",172330.96111484035,175211.90718161705,183710.6980786082,191489.25245890522,198403.52301916922,"LOS ANGELES15%",225475,228356,236855,244633,251548]
["MADERA30%",132862,132862,132862,132862,132862,"MADERA30%",186006,186006,186006,186006,186006]
["MADERA25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"MADERA25%",194217,194649,196521,198106,199546]
["MADERA20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"MADERA20%",202283,203436,207037,210206,213087]
["MADERA15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"MADERA15%",210494,212223,217552,222450,226627]
["MARIN30%",132862,132862,132862,132862,132862,"MARIN30%",186006,186006,186006,186006,186006]
["MARIN25%",153172.66977077551,154757.19010750268,159078.6092076677,163111.93370115501,166569.06898128701,"MARIN25%",206317,207901,212223,216256,219713]
["MARIN20%",173483.33954155102,176508.33291166654,185151.17111199655,193217.82009897122,200132.0906592352,"MARIN20%",226627,229652,238295,246362,253276]
["MARIN15%",193794.00931232655,198259.47571583037,211223.73301632539,223467.75380012623,233839.15964052224,"MARIN15%",246938,251403,264368,276612,286983]
["MARIPOSA30%",132862,132862,132862,132862,132862,"MARIPOSA30%",186006,186006,186006,186006,186006]
["MARIPOSA25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"MARIPOSA25%",194217,194649,196521,198106,199546]
["MARIPOSA20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"MARIPOSA20%",202283,203436,207037,210206,213087]
["MARIPOSA15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"MARIPOSA15%",210494,212223,217552,222450,226627]
["MENDOCINO30%",132862,132862,132862,132862,132862,"MENDOCINO30%",186006,186006,186006,186006,186006]
["MENDOCINO25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"MENDOCINO25%",194217,194649,196521,198106,199546]
["MENDOCINO20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"MENDOCINO20%",202283,203436,207037,210206,213087]
["MENDOCINO15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"MENDOCINO15%",210494,212223,217552,222450,226627]
["MERCED30%",132862,132862,132862,132862,132862,"MERCED30%",186006,186006,186006,186006,186006]
["MERCED25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"MERCED25%",194217,194649,196521,198106,199546]
["MERCED20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"MERCED20%",202283,203436,207037,210206,213087]
["MERCED15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"MERCED15%",210494,212223,217552,222450,226627]
["MODOC30%",132862,132862,132862,132862,132862,"MODOC30%",186006,186006,186006,186006,186006]
["MODOC25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"MODOC25%",194217,194649,196521,198106,199546]
["MODOC20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"MODOC20%",202283,203436,207037,210206,213087]
["MODOC15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"MODOC15%",210494,212223,217552,222450,226627]
["MONO30%",132862,132862,132862,132862,132862,"MONO30%",186006,186006,186006,186006,186006]
["MONO25%",142657.21662704067,143377.45314373483,145538.16269381734,147410.77763722217,149139.34527728817,"MONO25%",195801,196521,198682,200555,202283]
["MONO20%",152452.43325408135,153892.90628746967,158070.27808429586,161959.55527444434,165416.69055457634,"MONO20%",205596,207037,211214,215104,218561]
["MONO15%",162391.69718446085,164408.35943120453,170746.4407781132,176652.38021500537,181694.03583186452,"MONO15%",215536,217552,223890,229796,234838]
["MONTEREY30%",132862,132862,132862,132862,132862,"MONTEREY30%",186006,186006,186006,186006,186006]
["MONTEREY25%",144097.68966042902,144961.97348046201,147410.77763722217,149715.53449064351,151588.14943404833,"MONTEREY25%",197242,198106,200555,202860,204732]
["MONTEREY20%",155477.42662419684,157061.94696092402,161959.55527444434,166425.02167794819,170314.2988680967,"MONTEREY20%",208621,210206,215104,219569,223458]
["MONTEREY15%",166857.16358796469,169305.96774472485,176508.33291166654,183278.55616859172,189184.49560548388,"MONTEREY15%",220001,222450,229652,236423,242328]
["NAPA30%",132862,132862,132862,132862,132862,"NAPA30%",186006,186006,186006,186006,186006]
["NAPA25%",145538.16269381734,146546.49381718918,149139.34527728817,151732.19673738719,153748.85898413084,"NAPA25%",198682,199690,202283,204876,206893]
["NAPA20%",158214.32538763469,160086.94033103951,165416.69055457634,170458.34617143552,174779.76527160054,"NAPA20%",211358,213231,218561,223602,227924]
["NAPA15%",170890.48808145203,173627.38684488984,181694.03583186452,189328.54290882271,195810.67155907021,"NAPA15%",224034,226771,234838,242473,248955]
["NEVADA30%",132862,132862,132862,132862,132862,"NEVADA30%",186006,186006,186006,186006,186006]
["NEVADA25%",142945.31123371836,143665.54775041252,145826.257300495,147698.87224389985,149427.43988396585,"NEVADA25%",196089,196810,198970,200843,202571]
["NEVADA20%",152884.57516409786,154325.04819748618,158646.46729765119,162679.79179113853,166136.92707127053,"NEVADA20%",206029,207469,211790,215824,219281]
["NEVADA15%",162967.88639781618,165128.59594789869,171610.72459814619,177660.71133837721,182846.41425857518,"NEVADA15%",216112,218273,224755,230805,235990]
["ORANGE30%",132862,132862,132862,132862,132862,"ORANGE30%",186006,186006,186006,186006,186006]
["ORANGE25%",147842.91954723868,148851.25067061052,152020.29134406484,155045.28471418034,157638.13617427935,"ORANGE25%",200987,201995,205164,208189,210782]
["ORANGE20%",162823.83909447736,164840.50134122101,171322.62999146851,177228.5694283607,182414.2723485587,"ORANGE20%",215968,217985,224467,230373,235558]
["ORANGE15%",177804.75864171603,180973.79931517038,190624.9686388722,199555.90144587989,207190.40852283806,"ORANGE15%",230949,234118,243769,252700,260334]
["PLACER30%",132862,132862,132862,132862,132862,"PLACER30%",186006,186006,186006,186006,186006]
["PLACER25%",143377.45314373483,144097.68966042902,146402.44651385036,148563.15606393284,150291.72370399884,"PLACER25%",196521,197242,199546,201707,203436]
["PLACER20%",153892.90628746967,155477.42662419684,159942.89302770069,164264.31212786568,167721.44740799768,"PLACER20%",207037,208621,213087,217408,220865]
["PLACER15%",164552.40673454336,166713.11628462587,173483.33954155102,179821.42088845969,185295.21841533537,"PLACER15%",217696,219857,226627,232965,238439]
["PLUMAS30%",132862,132862,132862,132862,132862,"PLUMAS30%",186006,186006,186006,186006,186006]
["PLUMAS25%",141648.88550366883,142225.07471702417,144241.73696376785,145970.30460383385,147410.77763722217,"PLUMAS25%",194793,195369,197386,199114,200555]
["PLUMAS20%",150435.77100733767,151588.14943404833,155477.42662419684,158934.56190432885,161959.55527444434,"PLUMAS20%",203580,204732,208621,212079,215104]
["PLUMAS15%",159222.65651100653,161095.27145441136,166713.11628462587,172042.8665081627,176508.33291166654,"PLUMAS15%",212367,214239,219857,225187,229652]
["RIVERSIDE30%",132862,132862,132862,132862,132862,"RIVERSIDE30%",186006,186006,186006,186006,186006]
["RIVERSIDE25%",141936.98011034651,142657.21662704067,144529.8315704455,146402.44651385036,147842.91954723868,"RIVERSIDE25%",195081,195801,197674,199546,200987]
["RIVERSIDE20%",151011.960220693,152308.38595074252,156197.663140891,159798.84572436186,162823.83909447736,"RIVERSIDE20%",204156,205452,209342,212943,215968]
["RIVERSIDE15%",160086.94033103951,161959.55527444434,167865.49471133653,173195.24493487336,177804.75864171603,"RIVERSIDE15%",213231,215104,221009,226339,230949]
["SACRAMENTO30%",132862,132862,132862,132862,132862,"SACRAMENTO30%",186006,186006,186006,186006,186006]
["SACRAMENTO25%",143377.45314373483,144097.68966042902,146402.44651385036,148563.15606393284,150291.72370399884,"SACRAMENTO25%",196521,197242,199546,201707,203436]
["SACRAMENTO20%",153892.90628746967,155477.42662419684,159942.89302770069,164264.31212786568,167721.44740799768,"SACRAMENTO20%",207037,208621,213087,217408,220865]
["SACRAMENTO15%",164552.40673454336,166713.11628462587,173483.33954155102,179821.42088845969,185295.21841533537,"SACRAMENTO15%",217696,219857,226627,232965,238439]
["SAN BENITO30%",132862,132862,132862,132862,132862,"SAN BENITO30%",186006,186006,186006,186006,186006]
["SAN BENITO25%",145682.20999715617,146546.49381718918,149427.43988396585,151876.24404072601,154181.00089414735,"SAN BENITO25%",198826,199690,202571,205020,207325]
["SAN BENITO20%",158502.41999431234,160375.0349377172,165848.83246459285,171034.53538479086,175500.0017882947,"SAN BENITO20%",211646,213519,218993,224179,228644]
["SAN BENITO15%",171466.67729480736,174203.57605824521,182414.2723485587,190192.82672885573,196819.00268244202,"SAN BENITO15%",224611,227348,235558,243337,249963]
["SAN BERNARDINO30%",132862,132862,132862,132862,132862,"SAN BERNARDINO30%",186006,186006,186006,186006,186006]
["SAN BERNARDINO25%",141936.98011034651,142657.21662704067,144529.8315704455,146402.44651385036,147842.91954723868,"SAN BERNARDINO25%",195081,195801,197674,199546,200987]
["SAN BERNARDINO20%",151011.960220693,152308.38595074252,156197.663140891,159798.84572436186,162823.83909447736,"SAN BERNARDINO20%",204156,205452,209342,212943,215968]
["SAN BERNARDINO15%",160086.94033103951,161959.55527444434,167865.49471133653,173195.24493487336,177804.75864171603,"SAN BERNARDINO15%",213231,215104,221009,226339,230949]
["SAN DIEGO30%",132862,132862,132862,132862,132862,"SAN DIEGO30%",186006,186006,186006,186006,186006]
["SAN DIEGO25%",146258.3992105115,147266.73033388334,150291.72370399884,152884.57516409786,155189.33201751919,"SAN DIEGO25%",199402,200411,203436,206029,208333]
["SAN DIEGO20%",159798.84572436186,161671.46066776669,167577.40010465885,172907.15032819568,177516.66403503838,"SAN DIEGO20%",212943,214815,220721,226051,230661]
["SAN DIEGO15%",173339.29223821219,176220.23830498886,184863.07650531887,192929.72549229354,199988.04335589637,"SAN DIEGO15%",226483,229364,238007,246074,253132]
["SAN FRANCISCO30%",132862,132862,132862,132862,132862,"SAN FRANCISCO30%",186006,186006,186006,186006,186006]
["SAN FRANCISCO25%",153172.66977077551,154757.19010750268,159078.6092076677,163111.93370115501,166569.06898128701,"SAN FRANCISCO25%",206317,207901,212223,216256,219713]
["SAN FRANCISCO20%",173483.33954155102,176508.33291166654,185151.17111199655,193217.82009897122,200132.0906592352,"SAN FRANCISCO20%",226627,229652,238295,246362,253276]
["SAN FRANCISCO15%",193794.00931232655,198259.47571583037,211223.73301632539,223467.75380012623,233839.15964052224,"SAN FRANCISCO15%",246938,251403,264368,276612,286983]
["SAN JOAQUIN30%",132862,132862,132862,132862,132862,"SAN JOAQUIN30%",186006,186006,186006,186006,186006]
["SAN JOAQUIN25%",141648.88550366883,142225.07471702417,144241.73696376785,145970.30460383385,147554.82494056103,"SAN JOAQUIN25%",194793,195369,197386,199114,200699]
["SAN JOAQUIN20%",150435.77100733767,151732.19673738719,155477.42662419684,159078.6092076677,162103.6025777832,"SAN JOAQUIN20%",203580,204876,208621,212223,215248]
["SAN JOAQUIN15%",159366.70381434535,161239.31875775018,166857.16358796469,172186.91381150152,176796.42751834419,"SAN JOAQUIN15%",212511,214383,220001,225331,229940]
["SAN LUIS OBISPO30%",132862,132862,132862,132862,132862,"SAN LUIS OBISPO30%",186006,186006,186006,186006,186006]
["SAN LUIS OBISPO25%",144241.73696376785,145106.02078380084,147410.77763722217,149715.53449064351,151732.19673738719,"SAN LUIS OBISPO25%",197386,198250,200555,202860,204876]
["SAN LUIS OBISPO20%",155477.42662419684,157205.99426426284,161959.55527444434,166569.06898128701,170458.34617143552,"SAN LUIS OBISPO20%",208621,210350,215104,219713,223602]
["SAN LUIS OBISPO15%",166857.16358796469,169305.96774472485,176652.38021500537,183422.60347193055,189184.49560548388,"SAN LUIS OBISPO15%",220001,222450,229796,236567,242328]
["SAN MATEO30%",132862,132862,132862,132862,132862,"SAN MATEO30%",186006,186006,186006,186006,186006]
["SAN MATEO25%",153172.66977077551,154757.19010750268,159078.6092076677,163111.93370115501,166569.06898128701,"SAN MATEO25%",206317,207901,212223,216256,219713]
["SAN MATEO20%",173483.33954155102,176508.33291166654,185151.17111199655,193217.82009897122,200132.0906592352,"SAN MATEO20%",226627,229652,238295,246362,253276]
["SAN MATEO15%",193794.00931232655,198259.47571583037,211223.73301632539,223467.75380012623,233839.15964052224,"SAN MATEO15%",246938,251403,264368,276612,286983]
["SANTA BARBARA30%",132862,132862,132862,132862,132862,"SANTA BARBARA30%",186006,186006,186006,186006,186006]
["SANTA BARBARA25%",146690.54112052801,147842.91954723868,150723.86561401535,153460.76437745319,155909.56853421335,"SANTA BARBARA25%",199835,200987,203868,206605,209054]
["SANTA BARBARA20%",160663.12954439485,162679.79179113853,168585.73122803069,174203.57605824521,178957.1370684267,"SANTA BARBARA20%",213807,215824,221730,227348,232101]
["SANTA BARBARA15%",174635.71796826168,177660.71133837721,186447.59684204604,194802.3404356984,202004.70560264005,"SANTA BARBARA15%",227780,230805,239592,247946,255149]
["SANTA CLARA30%",132862,132862,132862,132862,132862,"SANTA CLARA30%",186006,186006,186006,186006,186006]
["SANTA CLARA25%",151300.05482737068,152596.48055742017,156485.75774756868,160230.98763437837,163400.02830783269,"SANTA CLARA25%",204444,205740,209630,213375,216544]
["SANTA CLARA20%",169738.10965474136,172330.96111484035,180253.5627984762,187599.97526875671,193938.05661566538,"SANTA CLARA20%",222882,225475,233398,240744,247082]
["SANTA CLARA15%",188176.16448211204,192209.48897559935,204021.36784938374,215113.01020647387,224620.13222683693,"SANTA CLARA15%",241320,245353,257165,268257,277764]
["SANTA CRUZ30%",132862,132862,132862,132862,132862,"SANTA CRUZ30%",186006,186006,186006,186006,186006]
["SANTA CRUZ25%",148419.10876059401,149427.43988396585,152740.527860759,155909.56853421335,158502.41999431234,"SANTA CRUZ25%",201563,202571,205885,209054,211646]
["SANTA CRUZ20%",163832.1702178492,165992.87976793171,172619.05572151803,178813.08976508788,184142.83998862471,"SANTA CRUZ20%",216976,219137,225763,231957,237287]
["SANTA CRUZ15%",179245.23167510435,182558.31965189753,192497.58358227703,201860.65829930123,209783.25998293704,"SANTA CRUZ15%",232389,235702,245642,255005,262927]
["SHASTA30%",132862,132862,132862,132862,132862,"SHASTA30%",186006,186006,186006,186006,186006]
["SHASTA25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"SHASTA25%",194217,194649,196521,198106,199546]
["SHASTA20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"SHASTA20%",202283,203436,207037,210206,213087]
["SHASTA15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"SHASTA15%",210494,212223,217552,222450,226627]
["SIERRA30%",132862,132862,132862,132862,132862,"SIERRA30%",186006,186006,186006,186006,186006]
["SIERRA25%",142369.12202036299,143089.35853705718,145106.02078380084,146978.63572720566,148707.20336727169,"SIERRA25%",195513,196233,198250,200123,201851]
["SIERRA20%",151876.24404072601,153172.66977077551,157350.04156760167,161095.27145441136,164408.35943120453,"SIERRA20%",205020,206317,210494,214239,217552]
["SIERRA15%",161383.36606108901,163400.02830783269,169594.06235140254,175211.90718161705,180109.51549513737,"SIERRA15%",214527,216544,222738,228356,233254]
["SISKIYOU30%",132862,132862,132862,132862,132862,"SISKIYOU30%",186006,186006,186006,186006,186006]
["SISKIYOU25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"SISKIYOU25%",194217,194649,196521,198106,199546]
["SISKIYOU20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"SISKIYOU20%",202283,203436,207037,210206,213087]
["SISKIYOU15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"SISKIYOU15%",210494,212223,217552,222450,226627]
["SOLANO30%",132862,132862,132862,132862,132862,"SOLANO30%",186006,186006,186006,186006,186006]
["SOLANO25%",143665.54775041252,144529.8315704455,146834.58842386684,148851.25067061052,150867.91291735417,"SOLANO25%",196810,197674,199979,201995,204012]
["SOLANO20%",154469.09550082503,156053.61583755218,160663.12954439485,164984.54864455987,168729.77853136952,"SOLANO20%",207613,209198,213807,218129,221874]
["SOLANO15%",165272.64325123752,167577.40010465885,174635.71796826168,180973.79931517038,186591.64414538487,"SOLANO15%",218417,220721,227780,234118,239736]
["SONOMA30%",132862,132862,132862,132862,132862,"SONOMA30%",186006,186006,186006,186006,186006]
["SONOMA25%",146546.49381718918,147410.77763722217,150435.77100733767,153028.62246743668,155333.37932085802,"SONOMA25%",199690,200555,203580,206173,208477]
["SONOMA20%",160086.94033103951,161959.55527444434,167865.49471133653,173339.29223821219,177948.80594505486,"SONOMA20%",213231,215104,221009,226483,231093]
["SONOMA15%",173771.4341482287,176652.38021500537,185439.2657186742,193505.91470564887,200564.23256925173,"SONOMA15%",226915,229796,238583,246650,253708]
["STANISLAUS30%",132862,132862,132862,132862,132862,"STANISLAUS30%",186006,186006,186006,186006,186006]
["STANISLAUS25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"STANISLAUS25%",194217,194649,196521,198106,199546]
["STANISLAUS20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"STANISLAUS20%",202283,203436,207037,210206,213087]
["STANISLAUS15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"STANISLAUS15%",210494,212223,217552,222450,226627]
["SUTTER30%",132862,132862,132862,132862,132862,"SUTTER30%",186006,186006,186006,186006,186006]
["SUTTER25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"SUTTER25%",194217,194649,196521,198106,199546]
["SUTTER20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"SUTTER20%",202283,203436,207037,210206,213087]
["SUTTER15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"SUTTER15%",210494,212223,217552,222450,226627]
["TEHAMA30%",132862,132862,132862,132862,132862,"TEHAMA30%",186006,186006,186006,186006,186006]
["TEHAMA25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"TEHAMA25%",194217,194649,196521,198106,199546]
["TEHAMA20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"TEHAMA20%",202283,203436,207037,210206,213087]
["TEHAMA15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"TEHAMA15%",210494,212223,217552,222450,226627]
["TRINITY30%",132862,132862,132862,132862,132862,"TRINITY30%",186006,186006,186006,186006,186006]
["TRINITY25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"TRINITY25%",194217,194649,196521,198106,199546]
["TRINITY20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"TRINITY20%",202283,203436,207037,210206,213087]
["TRINITY15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"TRINITY15%",210494,212223,217552,222450,226627]
["TULARE30%",132862,132862,132862,132862,132862,"TULARE30%",186006,186006,186006,186006,186006]
["TULARE25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"TULARE25%",194217,194649,196521,198106,199546]
["TULARE20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"TULARE20%",202283,203436,207037,210206,213087]
["TULARE15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"TULARE15%",210494,212223,217552,222450,226627]
["TUOLUMNE30%",132862,132862,132862,132862,132862,"TUOLUMNE30%",186006,186006,186006,186006,186006]
["TUOLUMNE25%",141216.74359365233,141648.88550366883,143521.50044707366,145106.02078380084,146690.54112052801,"TUOLUMNE25%",194361,194793,196666,198250,199835]
["TUOLUMNE20%",149427.43988396585,150579.81831067652,154181.00089414735,157494.08887094053,160375.0349377172,"TUOLUMNE20%",202571,203724,207325,210638,213519]
["TUOLUMNE15%",157782.18347761818,159510.75111768418,164840.50134122101,169738.10965474136,174059.52875490638,"TUOLUMNE15%",210926,212655,217985,222882,227204]
["VENTURA30%",132862,132862,132862,132862,132862,"VENTURA30%",186006,186006,186006,186006,186006]
["VENTURA25%",145970.30460383385,146978.63572720566,149859.58179398236,152452.43325408135,154757.19010750268,"VENTURA25%",199114,200123,203004,205596,207901]
["VENTURA20%",159222.65651100653,161095.27145441136,166713.11628462587,172042.8665081627,176508.33291166654,"VENTURA20%",212367,214239,219857,225187,229652]
["VENTURA15%",172475.0084181792,175211.90718161705,183710.6980786082,191633.29976224405,198403.52301916922,"VENTURA15%",225619,228356,236855,244777,251548]
["YOLO30%",132862,132862,132862,132862,132862,"YOLO30%",186006,186006,186006,186006,186006]
["YOLO25%",143953.64235709017,144817.92617712318,147122.68303054452,149283.392580627,151300.05482737068,"YOLO25%",197098,197962,200267,202427,204444]
["YOLO20%",155045.28471418034,156629.80505090751,161383.36606108901,165704.78516125403,169594.06235140254,"YOLO20%",208189,209774,214527,218849,222738]
["YOLO15%",166136.92707127053,168585.73122803069,175644.04909163353,182270.22504521988,188032.11717877322,"YOLO15%",219281,221730,228788,235414,241176]
["YUBA30%",132862,132862,132862,132862,132862,"YUBA30%",186006,186006,186006,186006,186006]
["YUBA25%",141072.6962903135,141504.83820033001,143377.45314373483,144961.97348046201,146402.44651385036,"YUBA25%",194217,194649,196521,198106,199546]
["YUBA20%",149139.34527728817,150291.72370399884,153892.90628746967,157061.94696092402,159942.89302770069,"YUBA20%",202283,203436,207037,210206,213087]
["YUBA15%",157350.04156760167,159078.6092076677,164408.35943120453,169305.96774472485,173483.33954155102,"YUBA15%",210494,212223,217552,222450,226627]

{"sheet":"CHAS Data","index":12,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["name"," AND with housing cost burden greater than 50%, none of the needs above  AND household income is less than or equal to 30% of HAMFI","TOTAL Renter household income is less than or equal to 30% of HAMFI"]
["Alameda",1330,73320,{"$f":"B2/C2","v":1.8139661756683034E-2},{"$f":"IF(D2>0.5,\"YES\",0)","v":0}]
["Alpine",11,10,{"$f":"MIN((B3/C3),1)","v":1},"YES"]
["Amador",173,875,{"$f":"B4/C4","v":0.1977142857142857},0]
["Butte",505,7985,{"$f":"B5/C5","v":6.3243581715716965E-2},0]
["Calaveras",166,945,0.17566137566137566,0]
["Colusa",88,445,0.19775280898876405,0]
["Contra Costa",1141,36640,3.1140829694323142E-2,0]
["Del Norte",167,1000,0.16700000000000001,0]
["El Dorado",411,3580,0.11480446927374302,0]
["Fresno",947,34670,2.731468128064609E-2,0]
["Glenn",192,870,0.22068965517241379,0]
["Humboldt",455,5450,8.3486238532110096E-2,0]
["Imperial",439,6410,6.8486739469578783E-2,0]
["Inyo",138,525,0.26285714285714284,0]
["Kern",875,24825,3.5246727089627394E-2,0]
["Kings",355,4190,8.4725536992840092E-2,0]
["Lake",274,2440,0.11229508196721312,0]
["Lassen",150,885,0.16949152542372881,0]
["Los Angeles",3125,517420,6.0395809980286807E-3,0]
["Madera",432,3650,0.11835616438356164,0]
["Marin",542,10505,5.1594478819609713E-2,0]
["Mariposa",106,540,0.1962962962962963,0]
["Mendocino",329,3255,0.1010752688172043,0]
["Merced",563,8610,6.5389082462253195E-2,0]
["Modoc",86,370,0.23243243243243245,0]
["Mono",99,155,0.6387096774193548,"YES"]
["Monterey",447,10985,4.0691852526172051E-2,0]
["Napa",322,3610,8.9196675900277009E-2,0]
["Nevada",360,2340,0.15384615384615385,0]
["Orange",1711,106440,1.6074783915821119E-2,0]
["Placer",522,7495,6.9646430953969315E-2,0]
["Plumas",105,570,0.18421052631578946,0]
["Riverside",1203,49445,2.4330063707149359E-2,0]
["Sacramento",1368,62015,2.2059179230831252E-2,0]
["San Benito",156,1105,0.14117647058823529,0]
["San Bernardino",1238,56065,2.2081512530098994E-2,0]
["San Diego",2090,117030,1.7858668717422883E-2,0]
["San Francisco",1269,66120,1.9192377495462796E-2,0]
["San Joaquin",631,19390,3.2542547705002575E-2,0]
["San Luis Obispo",632,10280,6.147859922178988E-2,0]
["San Mateo",788,23305,3.3812486590860329E-2,0]
["Santa Barbara",587,14495,4.049672300793377E-2,0]
["Santa Clara",1294,65980,1.9612003637465899E-2,0]
["Santa Cruz",593,11200,5.2946428571428575E-2,0]
["Shasta",409,5705,7.1691498685363717E-2,0]
["Sierra",52,90,0.57777777777777772,{"$f":"IF(D47>0.5,\"YES\",0)","v":"YES"}]
["Siskiyou",209,1850,0.11297297297297297,{"$f":"IF(D48>0.5,YES,0)","v":0}]
["Solano",578,12715,4.545812033031852E-2,{"$f":"IF(D49>0.5,YES,0)","v":0}]
["Sonoma",650,13765,4.7221213221939701E-2,{"$f":"IF(D50>0.5,YES,0)","v":0}]
["Stanislaus",605,15720,3.8486005089058521E-2,{"$f":"IF(D51>0.5,YES,0)","v":0}]
["Sutter",261,2250,0.11600000000000001,{"$f":"IF(D52>0.5,YES,0)","v":0}]
["Tehama",191,1700,0.11235294117647059,{"$f":"IF(D53>0.5,YES,0)","v":0}]
["Trinity",90,425,0.21176470588235294,{"$f":"IF(D54>0.5,YES,0)","v":0}]
["Tulare",542,14240,3.806179775280899E-2,{"$f":"IF(D55>0.5,YES,0)","v":0}]
["Tuolumne",232,1400,0.1657142857142857,{"$f":"IF(D56>0.5,YES,0)","v":0}]
["Ventura",798,20835,3.8300935925125991E-2,{"$f":"IF(D57>0.5,YES,0)","v":0}]
["Yolo",519,10665,4.8663853727144865E-2,{"$f":"IF(D58>0.5,YES,0)","v":0}]
["Yuba",192,2010,9.5522388059701493E-2,{"$f":"IF(D59>0.5,YES,0)","v":0}]