{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["CoverPage","Formula Allocation Application","Instructions & Checklist","302(c)(4) Plan","Urban County","Application Support","DATA"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":199,"comments":1,"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":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":false,"merged":[[23,0,23,6],[0,0,0,6],[2,0,2,6],[19,0,19,6],[20,0,20,6],[22,0,22,6],[34,0,34,6],[25,0,25,6],[26,0,26,6],[29,0,29,6],[30,0,30,6],[31,0,31,6],[32,0,32,6]]}
["Permanent Local Housing Allocation (PLHA) Formula Allocation "]
[]
["5-Year Plan Amendment Form"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Gavin Newsom, Governor"]
["State of California"]
[]
["Tomiquia Moss, Secretary"]
["Business, Consumer Services and Housing Agency"]
[]
["Gustavo Velasquez, Director"]
["Department of Housing and Community Development"]
[]
[]
["Program Design and Implementation, PLHA Program"]
["2020 West El Camino Avenue, Suite 150, Sacramento, CA 95833"]
["Website: https://www.hcd.ca.gov/grants-and-funding/programs-active/permanent-local-housing-allocation"]
["Email: PLHA@hcd.ca.gov"]
[]
["Final Filing Date: June 30, 2027\nat 4:00 P.M. PST"]

{"sheet":"Formula Allocation Application","index":1,"n_rows":34,"n_cols":36,"rows_kept":34,"cut":false,"hidden":false,"merged":[[26,0,26,34],[26,35,26,37],[27,0,27,34],[27,35,27,37],[28,0,28,34],[28,35,28,37],[23,0,23,34],[23,35,23,37],[24,0,24,34],[24,35,24,37],[25,0,25,34],[25,35,25,37],[32,0,32,34],[32,35,32,37],[33,0,33,34],[33,35,33,37],[29,0,29,34],[29,35,29,37],[30,0,30,34],[30,35,30,37],[31,0,31,34],[31,35,31,37],[20,0,20,2],[20,3,20,10],[20,11,20,29],[20,30,20,35],[20,36,20,37],[21,0,21,2],[21,3,21,10],[21,11,21,29],[21,30,21,35],[21,36,21,37],[19,0,19,2],[19,3,19,10],[19,11,19,29],[19,30,19,31],[19,32,19,35],[19,36,19,37],[16,31,16,33],[16,34,16,37],[17,0,17,35],[17,36,17,37],[18,0,18,25],[18,26,18,32],[18,33,18,35],[18,36,18,37],[16,0,16,2],[16,3,16,16],[16,17,16,18],[16,19,16,26],[16,27,16,28],[16,29,16,30],[14,31,14,33],[14,34,14,37],[15,0,15,3],[15,4,15,8],[15,9,15,10],[15,11,15,16],[15,17,15,20],[15,21,15,28],[15,29,15,32],[15,33,15,37],[14,0,14,2],[14,3,14,16],[14,17,14,18],[14,19,14,26],[14,27,14,28],[14,29,14,30],[12,20,12,21],[12,22,12,37],[13,0,13,3],[13,4,13,8],[13,9,13,10],[13,11,13,16],[13,17,13,20],[13,21,13,30],[13,31,13,33],[13,34,13,37],[12,0,12,1],[12,2,12,8],[12,9,12,10],[12,11,12,13],[12,14,12,15],[12,16,12,19],[4,36,4,37],[7,0,7,37],[8,0,8,37],[9,0,9,37],[10,0,10,3],[10,4,10,37],[11,0,11,2],[11,3,11,37],[6,0,6,11],[6,12,6,15],[6,16,6,26],[6,27,6,30],[6,31,6,35],[6,36,6,37],[22,0,22,37],[3,0,3,11],[3,12,3,15],[3,16,3,26],[3,27,3,30],[3,31,3,35],[3,36,3,37],[0,0,0,34],[0,35,0,37],[1,0,1,6],[1,7,1,37],[2,0,2,21],[2,22,2,37],[5,0,5,11],[5,12,5,15],[5,16,5,26],[5,27,5,30],[5,31,5,35],[5,36,5,37],[4,0,4,11],[4,12,4,15],[4,16,4,26],[4,27,4,30],[4,31,4,35]]}
["PLHA Formula - Amendment for years 2020, 2021, 2022, 2023\n",null,null,null,null,null,null,null,null,null,null,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. 03/18/24"]
["Eligible Applicant Type: "]
["Local Government Recipient of PLHA Formula Allocation: "]
["2020 PLHA NOFA Formula Allocation Amount:",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"2020 NOFA Allowable Local Admin (5%):",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M4*0.05,\"\")","v":""},null,null,null,"Admin requested?"]
["2021 PLHA NOFA Formula Allocation Amount:",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"2021 NOFA Allowable Local Admin (5%):",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M5*0.05,\"\")","v":""},null,null,null,"Admin requested?"]
["2022 PLHA NOFA Formula Allocation Amount:",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"2022 NOFA Allowable Local Admin (5%):",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M6*0.05,\"\")","v":""},null,null,null,"Admin requested?"]
["2023 PLHA NOFA Formula Allocation Amount:",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"2023 NOFA Allowable Local Admin (5%):",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M7*0.05,\"\")","v":""},null,null,null,"Admin requested?"]
["Instructions: If the Local Government Recipient of the PLHA Formula Allocation delegated its PLHA formula allocation to a Local Housing Trust Fund or to another Local Government, the Applicant (for which information is required below) is the Local Housing Trust Fund or administering Local Government. The PLHA award will be made to the Applicant (upon meeting threshold requirements) and the Applicant is responsible for meeting all program requirements throughout the term of the Standard Agreement.  \n\nThe 302(c)(4) Plan template worksheet requires first choosing one or more of the Eligible Activities listed below. If \"Yes\" is clicked, the 302(c)(4) Plan worksheet opens a series of questions about what precise activities are planned. Some specific activities, such as providing downpayment assistance to lower-income households for acquisition of an affordable home, could be included under either Activity 2 or 9. Please only choose one of those Activities; don't list the downpayment assistance under both Activities.                                                                                                                                                                                                                                                                                         \n\nIf the PLHA funds are used for the same Activity but for different Area Median Income (AMI) level, select the same Activity twice (or more times) and the different AMI level the Activity will serve. Please enter the percentage of funds allocated to the Activity in only the first Activity listing to avoid double counting the funding allocation.\n\nFor each year (2020-2023), allocations must equal 100% annually including the allowable administrative costs of up to 5%.\n  "]
["§300 Eligible Applicants"]
["§300(a) and (b) Eligible Applicants for the Entitlement and Non-Entitlement formula component described in Section §100(b)(1) and (2) are limited to the metropolitan cities and urban counties allocated a grant for the federal fiscal year 2017 pursuant to the federal CDBG formula specified in 42 USC, Section §5306 and Non-entitlement local governments."]
["Applicant:  "]
["Address:"]
["City:",null,null,null,null,null,null,null,null,"State:",null,null,null,null,"Zip:",null,null,null,null,null,"County:"]
["Auth Rep Name:",null,null,null,null,null,null,null,null,"Title:",null,null,null,null,null,null,null,"Auth Rep. Email:",null,null,null,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,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip Code:"]
["Contact Name:",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,null,"Contact Phone:"]
["Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip Code:"]
["§300(d) Is Applicant delegated by another Local government to administer on its behalf its formula allocation of program funds?"]
["§300(d) If Applicant answered \"Yes\" above, has the Applicant attached the legally binding agreement required by §300(c) and (d)?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A sample agreement can be found by double clicking on the icon to the right"]
["File Name:",null,null,"Application and/or Adopting the PLHA Plan (2020-2023 Allocations) Reso",null,null,null,null,null,null,null,"Pursuant to section 302(c)(4) of the Guidelines, Applicant’s PLHA Plan for 2020-2023 allocations is attached to this resolution, and Applicant certifies compliance with all public notice, comment, and hearing requirements in accordance with the Guidelines.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Gov TIN",null,null,null,null,null,null,null,"Provide a signed Gov't TIN Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Applicant Delegation Agreement",null,null,null,null,null,null,null,"Legally binding agreement between Delegating and Administering Local Governments (sample provided—just click on icon in row 19, column AH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["§301 Eligible Activities"]
["§301(a) Eligible activities are limited to the following:",null,null,null,null,null,null,null,null,null,null,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 below:"]
["§301(a)(1) The predevelopment, development, acquisition, rehabilitation, and preservation of multifamily, residential live-work, rental housing that is affordable to Extremely low-,Very low-, Low-, or Moderate-income households, including necessary operating subsidies."]
["§301(a)(2) The predevelopment, development, acquisition, rehabilitation, and preservation of affordable rental and ownership housing, including Accessory Dwelling Units (ADUs), that meets the needs of a growing workforce earning up to 120 percent of AMI, or 150 percent of AMI in high-cost areas. ADUs shall be available for occupancy for a term of no less than 30 days."]
["§301(a)(3) Matching portions of funds placed into Local or Regional Housing Trust Funds."]
["§301(a)(4) Matching portions of funds available through the Low- and Moderate-Income Housing Asset Fund pursuant to subdivision (d) of HSC Section 34176."]
["§301(a)(5) Capitalized Reserves for services connected to the preservation and creation of new permanent supportive housing."]
["§301(a)(6) Assisting persons who are experiencing or At-risk of homelessness, including, but not limited to, providing rapid re-housing, rental assistance, supportive/case management services that allow people to obtain and retain housing, operating and capital costs for navigation centers and emergency shelters, and the new construction, rehabilitation, and preservation of permanent and transitional housing."]
["§301(a)(7) Accessibility modifications in Lower-income Owner-occupied housing."]
["§301(a)(8) Efforts to acquire and rehabilitate foreclosed or vacant homes and apartments."]
["§301(a)(9) Homeownership opportunities, including, but not limited to, down payment assistance."]
["§301(a)(10) Fiscal incentives made by a county to a city within the county to incentivize approval of one or more affordable housing Projects, or matching funds invested by a county in an affordable housing development Project in a city within the county, provided that the city has made an equal or greater investment in the Project. The county fiscal incentives shall be in the form of a grant or low-interest loan to an affordable housing Project. Matching funds investments by both the county and the city also shall be a grant or low-interest deferred loan to the affordable housing Project. "]

{"sheet":"Instructions & Checklist","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"302(c)(4) Plan","index":3,"n_rows":144,"n_cols":39,"rows_kept":144,"cut":false,"hidden":false,"merged":[[152,0,152,5],[152,6,152,7],[153,0,153,5],[153,6,153,7],[147,0,147,5],[147,6,147,7],[148,0,148,5],[148,6,148,7],[150,0,150,7],[151,0,151,5],[151,6,151,7],[145,0,145,7],[146,0,146,5],[146,6,146,7],[139,0,139,37],[134,33,134,34],[134,35,134,37],[135,0,135,37],[136,0,136,37],[137,0,137,2],[137,3,137,10],[137,11,137,29],[137,30,137,35],[137,36,137,37],[134,21,134,22],[134,23,134,24],[134,25,134,26],[134,27,134,28],[134,29,134,30],[134,31,134,32],[140,2,140,7],[140,9,140,14],[140,16,140,21],[140,23,140,28],[133,33,133,34],[133,35,133,37],[134,0,134,6],[134,7,134,8],[134,9,134,10],[134,11,134,12],[134,13,134,14],[134,15,134,16],[134,17,134,18],[134,19,134,20],[133,21,133,22],[133,23,133,24],[133,25,133,26],[133,27,133,28],[133,29,133,30],[133,31,133,32],[132,33,132,34],[132,35,132,37],[133,0,133,6],[133,7,133,8],[133,9,133,10],[133,11,133,12],[133,13,133,14],[133,15,133,16],[133,17,133,18],[133,19,133,20],[132,21,132,22],[132,23,132,24],[132,25,132,26],[132,27,132,28],[132,29,132,30],[132,31,132,32],[131,33,131,34],[131,35,131,37],[132,0,132,6],[132,7,132,8],[132,9,132,10],[132,11,132,12],[132,13,132,14],[132,15,132,16],[132,17,132,18],[132,19,132,20],[131,21,131,22],[131,23,131,24],[131,25,131,26],[131,27,131,28],[131,29,131,30],[131,31,131,32],[130,33,130,34],[130,35,130,37],[131,0,131,6],[131,7,131,8],[131,9,131,10],[131,11,131,12],[131,13,131,14],[131,15,131,16],[131,17,131,18],[131,19,131,20],[130,21,130,22],[130,23,130,24],[130,25,130,26],[130,27,130,28],[130,29,130,30],[130,31,130,32],[129,33,129,34],[129,35,129,37],[130,0,130,6],[130,7,130,8],[130,9,130,10],[130,11,130,12],[130,13,130,14],[130,15,130,16],[130,17,130,18],[130,19,130,20],[129,21,129,22],[129,23,129,24],[129,25,129,26],[129,27,129,28],[129,29,129,30],[129,31,129,32],[128,33,128,34],[128,35,128,37],[129,0,129,6],[129,7,129,8],[129,9,129,10],[129,11,129,12],[129,13,129,14],[129,15,129,16],[129,17,129,18],[129,19,129,20],[128,21,128,22],[128,23,128,24],[128,25,128,26],[128,27,128,28],[128,29,128,30],[128,31,128,32],[127,33,127,34],[127,35,127,37],[128,0,128,6],[128,7,128,8],[128,9,128,10],[128,11,128,12],[128,13,128,14],[128,15,128,16],[128,17,128,18],[128,19,128,20],[127,21,127,22],[127,23,127,24],[127,25,127,26],[127,27,127,28],[127,29,127,30],[127,31,127,32],[125,0,125,37],[126,0,126,37],[127,0,127,6],[127,7,127,8],[127,9,127,10],[127,11,127,12],[127,13,127,14],[127,15,127,16],[127,17,127,18],[127,19,127,20],[120,33,120,34],[120,35,120,37],[121,0,121,37],[122,0,122,37],[123,0,123,37],[124,0,124,25],[124,26,124,35],[124,36,124,37],[120,21,120,22],[120,23,120,24],[120,25,120,26],[120,27,120,28],[120,29,120,30],[120,31,120,32],[119,33,119,34],[119,35,119,37],[120,0,120,6],[120,7,120,8],[120,9,120,10],[120,11,120,12],[120,13,120,14],[120,15,120,16],[120,17,120,18],[120,19,120,20],[119,21,119,22],[119,23,119,24],[119,25,119,26],[119,27,119,28],[119,29,119,30],[119,31,119,32],[118,33,118,34],[118,35,118,37],[119,0,119,6],[119,7,119,8],[119,9,119,10],[119,11,119,12],[119,13,119,14],[119,15,119,16],[119,17,119,18],[119,19,119,20],[118,21,118,22],[118,23,118,24],[118,25,118,26],[118,27,118,28],[118,29,118,30],[118,31,118,32],[117,33,117,34],[117,35,117,37],[118,0,118,6],[118,7,118,8],[118,9,118,10],[118,11,118,12],[118,13,118,14],[118,15,118,16],[118,17,118,18],[118,19,118,20],[117,21,117,22],[117,23,117,24],[117,25,117,26],[117,27,117,28],[117,29,117,30],[117,31,117,32],[116,33,116,34],[116,35,116,37],[117,0,117,6],[117,7,117,8],[117,9,117,10],[117,11,117,12],[117,13,117,14],[117,15,117,16],[117,17,117,18],[117,19,117,20],[116,21,116,22],[116,23,116,24],[116,25,116,26],[116,27,116,28],[116,29,116,30],[116,31,116,32],[115,33,115,34],[115,35,115,37],[116,0,116,6],[116,7,116,8],[116,9,116,10],[116,11,116,12],[116,13,116,14],[116,15,116,16],[116,17,116,18],[116,19,116,20],[115,21,115,22],[115,23,115,24],[115,25,115,26],[115,27,115,28],[115,29,115,30],[115,31,115,32],[114,33,114,34],[114,35,114,37],[115,0,115,6],[115,7,115,8],[115,9,115,10],[115,11,115,12],[115,13,115,14],[115,15,115,16],[115,17,115,18],[115,19,115,20],[114,21,114,22],[114,23,114,24],[114,25,114,26],[114,27,114,28],[114,29,114,30],[114,31,114,32],[112,0,112,37],[113,0,113,37],[114,0,114,6],[114,7,114,8],[114,9,114,10],[114,11,114,12],[114,13,114,14],[114,15,114,16],[114,17,114,18],[114,19,114,20],[107,33,107,34],[107,35,107,37],[108,0,108,37],[109,0,109,37],[110,0,110,37],[111,0,111,25],[111,26,111,35],[111,36,111,37],[107,21,107,22],[107,23,107,24],[107,25,107,26],[107,27,107,28],[107,29,107,30],[107,31,107,32],[106,33,106,34],[106,35,106,37],[107,0,107,6],[107,7,107,8],[107,9,107,10],[107,11,107,12],[107,13,107,14],[107,15,107,16],[107,17,107,18],[107,19,107,20],[106,21,106,22],[106,23,106,24],[106,25,106,26],[106,27,106,28],[106,29,106,30],[106,31,106,32],[105,33,105,34],[105,35,105,37],[106,0,106,6],[106,7,106,8],[106,9,106,10],[106,11,106,12],[106,13,106,14],[106,15,106,16],[106,17,106,18],[106,19,106,20],[105,21,105,22],[105,23,105,24],[105,25,105,26],[105,27,105,28],[105,29,105,30],[105,31,105,32],[104,33,104,34],[104,35,104,37],[105,0,105,6],[105,7,105,8],[105,9,105,10],[105,11,105,12],[105,13,105,14],[105,15,105,16],[105,17,105,18],[105,19,105,20],[104,21,104,22],[104,23,104,24],[104,25,104,26],[104,27,104,28],[104,29,104,30],[104,31,104,32],[103,33,103,34],[103,35,103,37],[104,0,104,6],[104,7,104,8],[104,9,104,10],[104,11,104,12],[104,13,104,14],[104,15,104,16],[104,17,104,18],[104,19,104,20],[103,21,103,22],[103,23,103,24],[103,25,103,26],[103,27,103,28],[103,29,103,30],[103,31,103,32],[102,33,102,34],[102,35,102,37],[103,0,103,6],[103,7,103,8],[103,9,103,10],[103,11,103,12],[103,13,103,14],[103,15,103,16],[103,17,103,18],[103,19,103,20],[102,21,102,22],[102,23,102,24],[102,25,102,26],[102,27,102,28],[102,29,102,30],[102,31,102,32],[101,33,101,34],[101,35,101,37],[102,0,102,6],[102,7,102,8],[102,9,102,10],[102,11,102,12],[102,13,102,14],[102,15,102,16],[102,17,102,18],[102,19,102,20],[101,21,101,22],[101,23,101,24],[101,25,101,26],[101,27,101,28],[101,29,101,30],[101,31,101,32],[99,0,99,37],[100,0,100,37],[101,0,101,6],[101,7,101,8],[101,9,101,10],[101,11,101,12],[101,13,101,14],[101,15,101,16],[101,17,101,18],[101,19,101,20],[94,33,94,34],[94,35,94,37],[95,0,95,37],[96,0,96,37],[97,0,97,37],[98,0,98,25],[98,26,98,35],[98,36,98,37],[94,21,94,22],[94,23,94,24],[94,25,94,26],[94,27,94,28],[94,29,94,30],[94,31,94,32],[93,33,93,34],[93,35,93,37],[94,0,94,6],[94,7,94,8],[94,9,94,10],[94,11,94,12],[94,13,94,14],[94,15,94,16],[94,17,94,18],[94,19,94,20],[93,21,93,22],[93,23,93,24],[93,25,93,26],[93,27,93,28],[93,29,93,30],[93,31,93,32],[92,33,92,34],[92,35,92,37],[93,0,93,6],[93,7,93,8],[93,9,93,10],[93,11,93,12],[93,13,93,14],[93,15,93,16],[93,17,93,18],[93,19,93,20],[92,21,92,22],[92,23,92,24],[92,25,92,26],[92,27,92,28],[92,29,92,30],[92,31,92,32],[91,33,91,34],[91,35,91,37],[92,0,92,6],[92,7,92,8],[92,9,92,10],[92,11,92,12],[92,13,92,14],[92,15,92,16],[92,17,92,18],[92,19,92,20],[91,21,91,22],[91,23,91,24],[91,25,91,26],[91,27,91,28],[91,29,91,30],[91,31,91,32],[90,33,90,34],[90,35,90,37],[91,0,91,6],[91,7,91,8],[91,9,91,10],[91,11,91,12],[91,13,91,14],[91,15,91,16],[91,17,91,18],[91,19,91,20],[90,21,90,22],[90,23,90,24],[90,25,90,26],[90,27,90,28],[90,29,90,30],[90,31,90,32],[89,33,89,34],[89,35,89,37],[90,0,90,6],[90,7,90,8],[90,9,90,10],[90,11,90,12],[90,13,90,14],[90,15,90,16],[90,17,90,18],[90,19,90,20],[89,21,89,22],[89,23,89,24],[89,25,89,26],[89,27,89,28],[89,29,89,30],[89,31,89,32],[87,0,87,37],[88,0,88,37],[89,0,89,6],[89,7,89,8],[89,9,89,10],[89,11,89,12],[89,13,89,14],[89,15,89,16],[89,17,89,18],[89,19,89,20],[82,35,82,37],[83,0,83,37],[84,0,84,37],[85,0,85,37],[86,0,86,25],[86,26,86,35],[86,36,86,37],[82,23,82,24],[82,25,82,26],[82,27,82,28],[82,29,82,30],[82,31,82,32],[82,33,82,34],[81,35,81,37],[82,0,82,6],[82,7,82,8],[82,9,82,10],[82,11,82,12],[82,13,82,14],[82,15,82,16],[82,17,82,18],[82,19,82,20],[82,21,82,22],[81,23,81,24],[81,25,81,26],[81,27,81,28],[81,29,81,30],[81,31,81,32],[81,33,81,34],[80,35,80,37],[81,0,81,6],[81,7,81,8],[81,9,81,10],[81,11,81,12],[81,13,81,14],[81,15,81,16],[81,17,81,18],[81,19,81,20],[81,21,81,22],[80,23,80,24],[80,25,80,26],[80,27,80,28],[80,29,80,30],[80,31,80,32],[80,33,80,34],[79,35,79,37],[80,0,80,6],[80,7,80,8],[80,9,80,10],[80,11,80,12],[80,13,80,14],[80,15,80,16],[80,17,80,18],[80,19,80,20],[80,21,80,22],[79,23,79,24],[79,25,79,26],[79,27,79,28],[79,29,79,30],[79,31,79,32],[79,33,79,34],[78,35,78,37],[79,0,79,6],[79,7,79,8],[79,9,79,10],[79,11,79,12],[79,13,79,14],[79,15,79,16],[79,17,79,18],[79,19,79,20],[79,21,79,22],[78,23,78,24],[78,25,78,26],[78,27,78,28],[78,29,78,30],[78,31,78,32],[78,33,78,34],[77,35,77,37],[78,0,78,6],[78,7,78,8],[78,9,78,10],[78,11,78,12],[78,13,78,14],[78,15,78,16],[78,17,78,18],[78,19,78,20],[78,21,78,22],[77,23,77,24],[77,25,77,26],[77,27,77,28],[77,29,77,30],[77,31,77,32],[77,33,77,34],[76,35,76,37],[77,0,77,6],[77,7,77,8],[77,9,77,10],[77,11,77,12],[77,13,77,14],[77,15,77,16],[77,17,77,18],[77,19,77,20],[77,21,77,22],[76,23,76,24],[76,25,76,26],[76,27,76,28],[76,29,76,30],[76,31,76,32],[76,33,76,34],[75,0,75,37],[76,0,76,6],[76,7,76,8],[76,9,76,10],[76,11,76,12],[76,13,76,14],[76,15,76,16],[76,17,76,18],[76,19,76,20],[76,21,76,22],[69,35,69,37],[70,0,70,37],[71,0,71,37],[72,0,72,37],[73,0,73,37],[74,0,74,37],[69,23,69,24],[69,25,69,26],[69,27,69,28],[69,29,69,30],[69,31,69,32],[69,33,69,34],[68,35,68,37],[69,0,69,6],[69,7,69,8],[69,9,69,10],[69,11,69,12],[69,13,69,14],[69,15,69,16],[69,17,69,18],[69,19,69,20],[69,21,69,22],[68,23,68,24],[68,25,68,26],[68,27,68,28],[68,29,68,30],[68,31,68,32],[68,33,68,34],[67,35,67,37],[68,0,68,6],[68,7,68,8],[68,9,68,10],[68,11,68,12],[68,13,68,14],[68,15,68,16],[68,17,68,18],[68,19,68,20],[68,21,68,22],[67,23,67,24],[67,25,67,26],[67,27,67,28],[67,29,67,30],[67,31,67,32],[67,33,67,34],[66,35,66,37],[67,0,67,6],[67,7,67,8],[67,9,67,10],[67,11,67,12],[67,13,67,14],[67,15,67,16],[67,17,67,18],[67,19,67,20],[67,21,67,22],[66,23,66,24],[66,25,66,26],[66,27,66,28],[66,29,66,30],[66,31,66,32],[66,33,66,34],[65,35,65,37],[66,0,66,6],[66,7,66,8],[66,9,66,10],[66,11,66,12],[66,13,66,14],[66,15,66,16],[66,17,66,18],[66,19,66,20],[66,21,66,22],[65,23,65,24],[65,25,65,26],[65,27,65,28],[65,29,65,30],[65,31,65,32],[65,33,65,34],[64,35,64,37],[65,0,65,6],[65,7,65,8],[65,9,65,10],[65,11,65,12],[65,13,65,14],[65,15,65,16],[65,17,65,18],[65,19,65,20],[65,21,65,22],[64,23,64,24],[64,25,64,26],[64,27,64,28],[64,29,64,30],[64,31,64,32],[64,33,64,34],[55,27,55,28],[55,29,55,30],[55,31,55,32],[55,33,55,34],[63,35,63,37],[64,0,64,6],[64,7,64,8],[64,9,64,10],[64,11,64,12],[64,13,64,14],[64,15,64,16],[64,17,64,18],[64,19,64,20],[64,21,64,22],[63,23,63,24],[63,25,63,26],[63,27,63,28],[63,29,63,30],[63,31,63,32],[63,33,63,34],[62,0,62,37],[63,0,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[63,13,63,14],[63,15,63,16],[63,17,63,18],[63,19,63,20],[63,21,63,22],[54,7,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[54,15,54,16],[54,17,54,18],[54,19,54,20],[54,21,54,22],[56,35,56,37],[57,0,57,37],[58,0,58,37],[59,0,59,37],[60,0,60,37],[61,0,61,37],[56,23,56,24],[56,25,56,26],[56,27,56,28],[56,29,56,30],[56,31,56,32],[56,33,56,34],[55,35,55,37],[56,0,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[56,13,56,14],[56,15,56,16],[56,17,56,18],[56,19,56,20],[56,21,56,22],[55,23,55,24],[55,25,55,26],[52,23,52,24],[52,25,52,26],[52,27,52,28],[52,29,52,30],[52,31,52,32],[52,33,52,34],[52,0,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[52,15,52,16],[52,17,52,18],[52,19,52,20],[52,21,52,22],[54,35,54,37],[55,0,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[55,15,55,16],[55,17,55,18],[55,19,55,20],[55,21,55,22],[54,23,54,24],[54,25,54,26],[54,27,54,28],[54,29,54,30],[54,31,54,32],[54,33,54,34],[54,0,54,6],[53,35,53,37],[50,35,50,37],[51,0,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[51,15,51,16],[51,17,51,18],[51,19,51,20],[50,21,50,22],[50,23,50,24],[50,25,50,26],[50,27,50,28],[50,29,50,30],[50,31,50,32],[53,23,53,24],[53,25,53,26],[53,27,53,28],[53,29,53,30],[53,31,53,32],[53,33,53,34],[52,35,52,37],[53,0,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[53,13,53,14],[53,15,53,16],[53,17,53,18],[53,19,53,20],[53,21,53,22],[48,0,48,37],[49,0,49,37],[50,0,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[50,15,50,16],[50,17,50,18],[50,19,50,20],[51,33,51,34],[43,33,43,34],[43,35,43,37],[44,0,44,37],[45,0,45,37],[46,0,46,37],[47,0,47,25],[47,26,47,35],[47,36,47,37],[43,21,43,22],[43,23,43,24],[43,25,43,26],[43,27,43,28],[43,29,43,30],[43,31,43,32],[51,21,51,22],[51,23,51,24],[51,25,51,26],[51,27,51,28],[51,29,51,30],[51,31,51,32],[50,33,50,34],[42,33,42,34],[42,35,42,37],[43,0,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[43,13,43,14],[43,15,43,16],[43,17,43,18],[43,19,43,20],[42,21,42,22],[42,23,42,24],[42,25,42,26],[42,27,42,28],[42,29,42,30],[42,31,42,32],[41,33,41,34],[41,35,41,37],[42,0,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,14],[42,15,42,16],[42,17,42,18],[42,19,42,20],[41,21,41,22],[41,23,41,24],[41,25,41,26],[41,27,41,28],[41,29,41,30],[41,31,41,32],[40,33,40,34],[40,35,40,37],[41,0,41,6],[41,7,41,8],[41,9,41,10],[41,11,41,12],[41,13,41,14],[41,15,41,16],[41,17,41,18],[41,19,41,20],[40,21,40,22],[40,23,40,24],[40,25,40,26],[40,27,40,28],[40,29,40,30],[40,31,40,32],[39,33,39,34],[39,35,39,37],[40,0,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[40,13,40,14],[40,15,40,16],[40,17,40,18],[40,19,40,20],[39,21,39,22],[39,23,39,24],[39,25,39,26],[39,27,39,28],[39,29,39,30],[39,31,39,32],[38,33,38,34],[38,35,38,37],[39,0,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,14],[39,15,39,16],[39,17,39,18],[39,19,39,20],[38,21,38,22],[38,23,38,24],[38,25,38,26],[38,27,38,28],[38,29,38,30],[38,31,38,32],[37,33,37,34],[37,35,37,37],[38,0,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,14],[38,15,38,16],[38,17,38,18],[38,19,38,20],[37,21,37,22],[37,23,37,24],[37,25,37,26],[37,27,37,28],[37,29,37,30],[37,31,37,32],[35,0,35,37],[36,0,36,37],[37,0,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,14],[37,15,37,16],[37,17,37,18],[37,19,37,20],[30,33,30,34],[30,35,30,37],[31,0,31,37],[32,0,32,37],[33,0,33,37],[34,0,34,25],[34,26,34,35],[34,36,34,37],[30,21,30,22],[30,23,30,24],[30,25,30,26],[30,27,30,28],[30,29,30,30],[30,31,30,32],[29,33,29,34],[29,35,29,37],[30,0,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[30,13,30,14],[30,15,30,16],[30,17,30,18],[30,19,30,20],[29,21,29,22]],"merged_total":1234,"flags":["merged_cut"]}
["§302(c)(4) 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,null,null,null,null,null,null,null,null,null,null,{"$f":"'Formula Allocation Application'!AJ1","v":"Rev. 03/18/24"}]
["§302(c)(4)(A) Describe the manner in which allocated funds will be used for eligible activities. "]
[]
["§302(c)(4)(B) Provide a description of the way the Local government will prioritize investments that increase the supply of housing for households with incomes at or below 60 percent of Area Median Income (AMI)."]
[]
["§302(c)(4)(C) Provide a description of how the Plan is consistent with the programs set forth in the Local Government’s Housing Element. "]
[]
["Activities Detail (Activities Detail (Must make a selection on Formula Allocation Application worksheet under Eligible Activities, §301))"]
["§301(a)(1) The predevelopment, development, acquisition, rehabilitation, and preservation of multifamily, residential live-work, rental housing that is affordable to extremely low-,very low-, low-, or moderate-income households, including necessary Operating subsidies."]
["§302(c)(4)(E)(i) Provide a detailed and complete description of how allocated funds will be used for each proposed Affordable Rental Housing Activity. "]
[]
["Complete the table below for each proposed Affordable Rental Housing Activity to be funded with 2020-2023 PLHA allocations. If a single Activity will be assisting households at more than one level of Area Median Income, please list the Activity as many times as needed to capture all of the AMI levels that will be assisted, but only show the percentage of annual funding allocated to the Activity one time (to avoid double counting)."]
["Funding Allocation Year "]
["§302(c)(4)(E)(i) Percentage of Funds Allocated for the Proposed Affordable Rental Housing  Activity  "]
["§302(c)(4)(E)(ii) Area Median Income Level Served ",null,null,null,null,null,null,null,null,null,null,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"]
["§302(c)(4)(E)(ii) Unmet share of the RHNA at the AMI Level\nNote: complete for years 2020, 2021, 2022 only",null,null,null,null,null,null,null,null,null,null,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(H16:AI16)","v":0}]
["§302(c)(4)(E)(ii) Projected Number of Households Served",null,null,null,null,null,null,null,null,null,null,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(H17:AI17)","v":0}]
["§302(c)(4)(E)(iv) Period of Affordability for the Proposed Affordable Rental Housing  Activity (55 years required for rental housing projects)",null,null,null,null,null,null,"55 Years",null,"55 Years",null,"55 Years",null,"55 Years",null,"55 Years",null,"55 Years",null,"55 Years",null,"55 Years",null,"55 Years",null,"55 Years",null,"55 Years",null,"55 Years",null,"55 Years",null,"55 Years"]
["§302(c)(4)(E)(iii) A description of major steps/actions and a proposed schedule for the implementation and completion of the Activity."]
[]
["§301(a)(2) The predevelopment, development, acquisition, rehabilitation, and preservation of Affordable rental and ownership housing, including Accessory Dwelling Units (ADUs), that meets the needs of a growing workforce earning up to 120 percent of AMI, or 150 percent of AMI in high-cost areas. ADUs shall be available for occupancy for a term of no less than 30 days."]
["§302(c)(4)(E)(i) Provide a detailed and complete description of how allocated funds will be used for each proposed Affordable Rental and Ownership Housing Activity.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing "]
[]
["Complete the table below for each proposed Affordable Rental and Ownership Housing Activity to be funded with 2020-2023 PLHA allocations. If a single Activity will be assisting households at more than one level of Area Median Income, please list the Activity as many times as needed to capture all of the AMI levels that will be assisted, but only show the percentage of annual funding allocated to the Activity one time (to avoid double counting)."]
["Funding Allocation Year "]
["Type of Affordable Housing Activity"]
["§302(c)(4)(E)(i) Percentage of Funds Allocated for Each Affordable Housing Activity"]
["§302(c)(4)(E)(ii) Area Median Income Level Served",null,null,null,null,null,null,null,null,null,null,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"]
["§302(c)(4)(E)(ii) Unmet share of the RHNA at AMI Level\nNote: complete for years 2020, 2021, 2022 only",null,null,null,null,null,null,null,null,null,null,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(H29:AI29)","v":0}]
["§302(c)(4)(E)(ii) Projected Number of Households Served",null,null,null,null,null,null,null,null,null,null,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(H30:AH30)","v":0}]
["§302(c)(4)(E)(iv) Period of Affordability for the Proposed Activity (55 years required for rental housing projects)"]
["§302(c)(4)(E)(iii) A description of major steps/actions and a proposed schedule for the implementation and completion of each Affordable Rental and Ownership Housing project."]
[]
["§301(a)(3) Matching portions of funds placed into Local or Regional Housing Trust Funds."]
["§302(c)(4)(E)(i) Provide a detailed and complete description of how allocated funds will be used for the proposed Activity.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing"]
[]
["Complete the table below for each proposed Activity to be funded with 2020-2023 PLHA allocations. If a single Activity will be assisting households at more than one level of Area Median Income, please list the Activity as many times as needed to capture all of the AMI levels that will be assisted, but only show the percentage of annual funding allocated to the Activity one time (to avoid double counting)."]
["Funding Allocation Year "]
["Type of Affordable Housing Activity"]
["§302(c)(4)(E)(i) Percentage of Funds Allocated for the Proposed Activity"]
["§302(c)(4)(E)(ii) Area Median Income Level Served ",null,null,null,null,null,null,null,null,null,null,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"]
["§302(c)(4)(E)(ii) Unmet share of the RHNA at AMI Level\nNote: complete for years 2020, 2021, 2022 only",null,null,null,null,null,null,null,null,null,null,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(H42:AI42)","v":0}]
["§302(c)(4)(E)(ii) Projected Number of Households Served",null,null,null,null,null,null,null,null,null,null,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(H43:AH43)","v":0}]
["§302(c)(4)(E)(iv) Period of Affordability for the Proposed Activity (55 years required for rental housing projects)"]
["§302(c)(4)(E)(iii) A description of major steps/actions and a proposed schedule for the implementation and completion of the Activity."]
[]
["§301(a)(4)  Matching portions of funds available through the Low- and Moderate-Income Housing Asset Fund pursuant to subdivision (d) of HSC Section 34176."]
["§302(c)(4)(E)(i) Provide a detailed and complete description of how allocated funds will be used for the proposed Activity.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing"]
[]
["Complete the table below for the proposed Activity to be funded with 2020-2023 PLHA allocations. If a single Activity will be assisting households at more than one level of Area Median Income, please list the Activity as many times as needed to capture all of the AMI levels that will be assisted, but only show the percentage of annual funding allocated to the Activity one time (to avoid double counting)."]
["Funding Allocation Year "]
["Type of Affordable Housing Activity"]
["§302(c)(4)(E)(i) Percentage of Funds Allocated for the Proposed Activity"]
["§302(c)(4)(E)(ii) Area Median Income Level Served ",null,null,null,null,null,null,null,null,null,null,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"]
["§302(c)(4)(E)(ii) Unmet share of the RHNA at AMI Level\nNote: complete for years 2020, 2021, 2022 only ",null,null,null,null,null,null,null,null,null,null,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(H55:AI55)","v":0}]
["§302(c)(4)(E)(ii) Projected Number of Households Served",null,null,null,null,null,null,null,null,null,null,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(H56:AH56)","v":0}]
["§302(c)(4)(E)(iv) Period of Affordability for the Proposed Activity (55 years required for rental housing projects)"]
["§302(c)(4)(E)(iii) A description of major steps/actions and a proposed schedule for the implementation and completion of the Activity."]
[]
["§301(a)(5) Capitalized Reserves for Services connected to the preservation and creation of new permanent supportive housing."]
["§302(c)(4)(E)(i) Provide a detailed and complete description of how allocated funds will be used for the proposed Activity ."]
[]
["Complete the table below for each proposed Activity to be funded with 2020-2023 PLHA allocations. If a single Activity will be assisting households at more than one level of Area Median Income, please list the Activity as many times as needed to capture all of the AMI levels that will be assisted, but only show the percentage of annual funding allocated to the Activity one time (to avoid double counting)."]
["Funding Allocation Year "]
["Type of Permanent Supportive Housing Project"]
["§302(c)(4)(E)(i) Percentage of Funds Allocated for the Proposed Activity"]
["§302(c)(4)(E)(ii) Area Median Income Level Served ",null,null,null,null,null,null,null,null,null,null,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"]
["§302(c)(4)(E)(ii) Unmet share of the RHNA at AMI Level\nNote: complete for years 2020, 2021, 2022 only",null,null,null,null,null,null,null,null,null,null,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(H68:AH68)","v":0}]
["§302(c)(4)(E)(ii) Projected Number of Households Served",null,null,null,null,null,null,null,null,null,null,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(H69:AH69)","v":0}]
["§302(c)(4)(E)(iv) Period of Affordability for the Proposed Activity (55 years required for rental housing projects)"]
["§302(c)(4)(E)(iii) A description of major steps/actions and a proposed schedule for the implementation and completion of the Activity."]
[]
["§301(a)(6) Assisting persons who are experiencing or At risk of homelessness, including, but not limited to, providing rapid rehousing, rental assistance, supportive/case management services that allow people to obtain and retain housing, operating and capital costs for navigation centers and emergency shelters, and the new construction, rehabilitation, and preservation of permanent and transitional housing."]
["§302(c)(4)(E)(i) Provide a detailed and complete description of how allocated funds will be used for the proposed Activity."]
[]
["Complete the table below for each proposed Activity to be funded with 2020-2023 PLHA allocations. If a single Activity will be assisting households at more than one level of Area Median Income, please list the Activity as many times as needed to capture all of the AMI levels that will be assisted, but only show the percentage of annual funding allocated to the Activity one time (to avoid double counting)."]
["Funding Allocation Year "]
["Type of Activity for Persons Experiencing or At Risk of Homelessness"]
["§302(c)(4)(E)(i) Percentage of Funds Allocated for the Proposed Activity"]
["§302(c)(4)(E)(ii) Area Median Income Level Served ",null,null,null,null,null,null,null,null,null,null,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"]
["§302(c)(4)(E)(ii) Unmet share of the RHNA at AMI Level\nNote: complete for years 2020, 2021, 2022 only",null,null,null,null,null,null,null,null,null,null,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(H81:AI81)","v":0}]
["§302(c)(4)(E)(ii) Projected Number of Households Served",null,null,null,null,null,null,null,null,null,null,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(H82:AH82)","v":0}]
["§302(c)(4)(E)(iv) Period of Affordability for the Proposed Activity (55 years required for rental housing projects)"]
["§302(c)(4)(E)(iii) A description of major steps/actions and a proposed schedule for the implementation and completion of the Activity."]
[]
["§301(a)(7) Accessibility modifications in Lower-income Owner-occupied housing."]
["§302(c)(4)(E)(i) Provide a detailed and complete description of how allocated funds will be used for the proposed Activity.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing"]
[]
["Complete the table below for each proposed Activity to be funded with 2020-2023 PLHA allocations. If a single Activity will be assisting households at more than one level of Area Median Income, please list the Activity as many times as needed to capture all of the AMI levels that will be assisted, but only show the percentage of annual funding allocated to the Activity one time (to avoid double counting)."]
["Funding Allocation Year "]
["§302(c)(4)(E)(i) Percentage of Funds Allocated for the Proposed Activity"]
["§302(c)(4)(E)(ii) Area Median Income Level Served ",null,null,null,null,null,null,null,null,null,null,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"]
["§302(c)(4)(E)(ii) Unmet share of the RHNA at AMI Level\nNote: complete for years 2020, 2021, 2022 only",null,null,null,null,null,null,null,null,null,null,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(H93:AI93)","v":0}]
["§302(c)(4)(E)(ii) Projected Number of Households Served",null,null,null,null,null,null,null,null,null,null,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(H94:AH94)","v":0}]
["§302(c)(4)(E)(iv) Period of Affordability for the Proposed Activity"]
["§302(c)(4)(E)(iii) A description of major steps/actions and a proposed schedule for the implementation and completion of the Activity."]
[]
["§301(a)(8)  Efforts to acquire and rehabilitate foreclosed or vacant homes and apartments."]
["§302(c)(4)(E)(i) Provide a detailed and complete description of how allocated funds will be used for the proposed Activity.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing (AOWH)"]
[]
["Complete the table below for each proposed Activity to be funded with 2020-2023 PLHA allocations. If a single Activity will be assisting households at more than one level of Area Median Income, please list the Activity as many times as needed to capture all of the AMI levels that will be assisted, but only show the percentage of annual funding allocated to the Activity one time (to avoid double counting)."]
["Funding Allocation Year "]
["Type of Activity"]
["§302(c)(4)(E)(i) Percentage of Funds Allocated for the Proposed Activity"]
["§302(c)(4)(E)(ii) Area Median Income Level Served ",null,null,null,null,null,null,null,null,null,null,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"]
["§302(c)(4)(E)(ii) Unmet share of the RHNA at AMI Level\nNote: complete for years 2020, 2021, 2022 only",null,null,null,null,null,null,null,null,null,null,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(H106:AI106)","v":0}]
["§302(c)(4)(E)(ii) Projected Number of Households Served",null,null,null,null,null,null,null,null,null,null,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(H107:AH107)","v":0}]
["§302(c)(4)(E)(iv) Period of Affordability for the Proposed  Activity (55 years required for rental housing projects)"]
["§302(c)(4)(E)(iii) A description of major steps/actions and a proposed schedule for the implementation and completion of the Activity."]
[]
["§301(a)(9)  Homeownership opportunities, including, but not limited to, down payment assistance."]
["§302(c)(4)(E)(i) Provide a detailed and complete description of how allocated funds will be used for the proposed Activity.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing (AOWH)"]
[]
["Complete the table below for each proposed Activity to be funded with 2020-2023 PLHA allocations. If a single Activity will be assisting households at more than one level of Area Median Income, please list the Activity as many times as needed to capture all of the AMI levels that will be assisted, but only show the percentage of annual funding allocated to the Activity one time (to avoid double counting)."]
["Funding Allocation Year "]
["Type of Homeowner Assistance"]
["§302(c)(4)(E)(i) Percentage of Funds Allocated for the Proposed Activity"]
["§302(c)(4)(E)(ii) Area Median Income Level Served ",null,null,null,null,null,null,null,null,null,null,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"]
["§302(c)(4)(E)(ii) Unmet share of the RHNA at AMI Level\nNote: complete for years 2020, 2021, 2022 only",null,null,null,null,null,null,null,null,null,null,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(H119:AI119)","v":0}]
["§302(c)(4)(E)(ii) Projected Number of Households Served",null,null,null,null,null,null,null,null,null,null,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(H120:AH120)","v":0}]
["§302(c)(4)(E)(iv) Period of Affordability for the Proposed Activity"]
["§302(c)(4)(E)(iii) A description of major steps/actions and a proposed schedule for the implementation and completion of the Activity."]
[]
["§301(a)(10) Fiscal incentives made by a county to a city within the county to incentivize approval of one or more affordable housing Projects, or matching funds invested by a county in an affordable housing development Project in a city within the county, provided that the city has made an equal or greater investment in the Project. The county fiscal incentives shall be in the form of a grant or low-interest loan to an affordable housing Project. Matching funds investments by both the county and the city also shall be a grant or low-interest deferred loan to the affordable housing Project. "]
["§302(c)(4)(E)(i) Provide a detailed and complete description of how allocated funds will be used for the proposed Activity.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing (AOWH)"]
[]
["Complete the table below for each proposed Activity to be funded with 2020-2023 PLHA allocations. If a single Activity will be assisting households at more than one level of Area Median Income, please list the Activity as many times as needed to capture all of the AMI levels that will be assisted, but only show the percentage of annual funding allocated to the Activity one time (to avoid double counting)."]
["Funding Allocation Year "]
["Type of Activity"]
["Type of Affordable Housing Project ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fiscal Incentives"]
["§302(c)(4)(E)(i) Percentage of Funds Allocated for the Proposed Activity"]
["§302(c)(4)(E)(ii) Area Median Income Level Served ",null,null,null,null,null,null,null,null,null,null,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"]
["§302(c)(4)(E)(ii) Unmet share of the RHNA at AMI Level\nNote: complete for years 2020, 2021, 2022 only",null,null,null,null,null,null,null,null,null,null,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(H133:AI133)","v":0}]
["§302(c)(4)(E)(ii) Projected Number of Households Served",null,null,null,null,null,null,null,null,null,null,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(H134:AH134)","v":0}]
["§302(c)(4)(E)(iv) Period of Affordability for the Proposed Activity (55 years required for rental housing projects)"]
["§302(c)(4)(E)(iii) A description of major steps/actions and a proposed schedule for the implementation and completion of the Activity."]
[]
["File Name:",null,null,"Plan Adoption Reso",null,null,null,null,null,null,null,"§302(c)(4)(D) Evidence that the Plan was authorized and adopted by resolution by the Local jurisdiction and that the public had an adequate opportunity to review and comment on its content.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
[]
["Total Percentage of Funds Allocated Calculator (2020 - 2023)"]
[null,null,"2020 Allocation",null,null,null,null,null,null,"2021 Allocation",null,null,null,null,null,null,"2022 Allocation",null,null,null,null,null,null,"2023 Allocation"]
[null,null,"Admin",null,null,null,{"$f":"IF('Formula Allocation Application'!AK4=\"Yes\",\"5%\",\"0%\")","v":"0%"},null,null,"Admin",null,null,null,{"$f":"IF('Formula Allocation Application'!AK5=\"Yes\",\"5%\",\"0%\")","v":"0%"},null,null,"Admin",null,null,null,{"$f":"IF('Formula Allocation Application'!AK6=\"Yes\",\"5%\",\"0%\")","v":"0%"},null,null,"Admin",null,null,null,{"$f":"IF('Formula Allocation Application'!AK7=\"Yes\",\"5%\",\"0%\")","v":"0%"}]
[null,null,"Funds Allocated ",null,null,null,{"$f":"SUM(SUMIF(H$13:AI$13,2020,H$14:AI$14),SUMIF(H$25:AI$25,2020,H$27:AI$27),SUMIF(H$38:AI$38,2020,H$40:AI$40),SUMIF(H$51:AI$51,2020,H$53:AI$53),SUMIF(H$64:AI$64,2020,H$66:AI$66),SUMIF(H$77:AI$77,2020,H$79:AI$79),SUMIF(H$90:AI$90,2020,H$91:AI$91),SUMIF(H$102:AI$102,2020,H$104:AI$104),SUMIF(H$115:AI$115,2020,H$117:AI$117),SUMIF(H$128:AI$128,2020,H$131:AI$131))","v":0},null,null,"Funds Allocated ",null,null,null,{"$f":"SUM(SUMIF(H$13:AI$13,2021,H$14:AI$14),SUMIF(H$25:AI$25,2021,H$27:AI$27),SUMIF(H$38:AI$38,2021,H$40:AI$40),SUMIF(H$51:AI$51,2021,H$53:AI$53),SUMIF(H$64:AI$64,2021,H$66:AI$66),SUMIF(H$77:AI$77,2021,H$79:AI$79),SUMIF(H$90:AI$90,2021,H$91:AI$91),SUMIF(H$102:AI$102,2021,H$104:AI$104),SUMIF(H$115:AI$115,2021,H$117:AI$117),SUMIF(H$128:AI$128,2021,H$131:AI$131))","v":0},null,null,"Funds Allocated ",null,null,null,{"$f":"SUM(SUMIF(H$13:AI$13,2022,H$14:AI$14),SUMIF(H$25:AI$25,2022,H$27:AI$27),SUMIF(H$38:AI$38,2022,H$40:AI$40),SUMIF(H$51:AI$51,2022,H$53:AI$53),SUMIF(H$64:AI$64,2022,H$66:AI$66),SUMIF(H$77:AI$77,2022,H$79:AI$79),SUMIF(H$90:AI$90,2022,H$91:AI$91),SUMIF(H$102:AI$102,2022,H$104:AI$104),SUMIF(H$115:AI$115,2022,H$117:AI$117),SUMIF(H$128:AI$128,2022,H$131:AI$131))","v":0},null,null,"Funds Allocated ",null,null,null,{"$f":"SUM(SUMIF(H$13:AI$13,2023,H$14:AI$14),SUMIF(H$25:AI$25,2023,H$27:AI$27),SUMIF(H$38:AI$38,2023,H$40:AI$40),SUMIF(H$51:AI$51,2023,H$53:AI$53),SUMIF(H$64:AI$64,2023,H$66:AI$66),SUMIF(H$77:AI$77,2023,H$79:AI$79),SUMIF(H$90:AI$90,2023,H$91:AI$91),SUMIF(H$102:AI$102,2023,H$104:AI$104),SUMIF(H$115:AI$115,2023,H$117:AI$117),SUMIF(H$128:AI$128,2023,H$131:AI$131))","v":0}]
[null,null,"Total Percentage of Funds Allocated for 2020 ",null,null,null,{"$f":"G142+G143","v":0},null,null,"Total Percentage of Funds Allocated for 2021 ",null,null,null,{"$f":"N142+N143","v":0},null,null,"Total Percentage of Funds Allocated for 2022 ",null,null,null,{"$f":"U142+U143","v":0},null,null,"Total Percentage of Funds Allocated for 2023",null,null,null,{"$f":"AB142+AB143","v":0}]

{"sheet":"Urban County","index":4,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[[1,0,1,2],[0,0,0,1]]}
["URBAN COUNTY",null,{"$f":"'Formula Allocation Application'!AJ1","v":"Rev. 03/18/24"}]
["If you are an Urban County, please complete the following table:"]
["List the cities that are part of your Urban County.","Are they opting in to receive a portion of the PLHA award?","List the amount of the allocation being applied for that will be shared with this city."]
["EXAMPLE: City of Trees","Yes",20000]

{"sheet":"Application Support","index":5,"n_rows":31,"n_cols":42,"rows_kept":31,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[26,0,26,1],[26,2,26,4],[26,5,26,8],[26,9,26,14],[26,15,26,16],[26,17,26,28],[27,32,27,34],[27,35,27,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],[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],[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],[22,0,22,1],[22,2,22,4],[22,5,22,8],[22,9,22,14],[22,15,22,16],[22,17,22,28],[23,32,23,34],[23,35,23,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],[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],[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],[18,0,18,1],[18,2,18,4],[18,5,18,8],[18,9,18,14],[18,15,18,16],[18,17,18,28],[19,32,19,34],[19,35,19,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],[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],[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],[14,0,14,1],[14,2,14,4],[14,5,14,8],[14,9,14,14],[14,15,14,16],[14,17,14,28],[15,32,15,34],[15,35,15,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],[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],[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],[10,0,10,1],[10,2,10,4],[10,5,10,8],[10,9,10,14],[10,15,10,16],[10,17,10,28],[11,32,11,34],[11,35,11,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],[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],[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],[6,0,6,1],[6,2,6,4],[6,5,6,8],[6,9,6,14],[6,15,6,16],[6,17,6,28],[7,32,7,34],[7,35,7,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],[3,0,3,3],[3,4,3,14],[3,15,3,16],[3,17,3,27],[3,28,3,31],[3,32,3,37],[0,0,0,34],[0,35,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]]}
["Application Development Team (ADT) Support 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,{"$f":"'Formula Allocation Application'!AJ1","v":"Rev. 03/18/24"}]
["Please complete the \"yellow\" cells in the form below and email a copy to: PLHA@hcd.ca.gov. A member of the Application Development Team will respond to your request within 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:"]
[]
["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,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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":0},{"$f":"IF(C7=\"\",\"\",$R$4)","v":0},{"$f":"IF(C7=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C7=\"\",\"\",$AI$3)","v":"00:00:00"}]
[2,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,{"$f":"IF(C8=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C8=\"\",\"\",$AI$3)","v":"00:00:00"}]
[3,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,{"$f":"IF(C9=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C9=\"\",\"\",$AI$3)","v":"00:00:00"}]
[4,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,{"$f":"IF(C10=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C10=\"\",\"\",$AI$3)","v":"00:00:00"}]
[5,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,{"$f":"IF(C11=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C11=\"\",\"\",$AI$3)","v":"00:00:00"}]
[6,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[7,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[8,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[9,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[10,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[11,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[12,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[13,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[14,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[15,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[16,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[17,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[18,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[19,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[20,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[21,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[22,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[23,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[24,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]
[25,null,"PLHA Supp App",null,null,null,null,null,null,null,null,null,null,null,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,0,0,"00:00:00"]

{"sheet":"DATA","index":6,"n_rows":187,"n_cols":18,"rows_kept":187,"cut":false,"hidden":true,"merged":[[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,9,0,10]]}
["2022 Allocations",null,"2021 Allocations",null,"2020 Allocations",null,null,null,null,"2019 Allocations"]
["Nonentitlement","Entitlement","Nonentitlement.","Entitlement.","Nonentitlement","Entitlement","Counties ",null,null,"Nonentitlement","Entitlement",null,"Plan Activity 2 Dropdowns","Plan Activity 3 Dropdowns","Plan Activity 4 Dropdowns","Plan Activity 6 Dropdowns","Plan Activity 8 Dropdowns","Plan Activity 9 Dropdowns"]
["Alpine County","Alameda","Alpine County","Aliso Viejo","Alpine County","Aliso Viejo","Alameda",null,null,"Alpine County","Aliso Viejo",null,"Rental: Predevelopment","Rental: Predevelopment","Rental: Predevelopment","Rapid Rehousing","Rental: Acquisition"]
["Alturas","Alameda County","Alturas","Carlsbad","Alturas","Carlsbad","Alpine",null,null,"Alturas","Carlsbad",null,"Rental: Development","Rental: Development","Rental: Development","Rental Assistance (term of six months)","Rental: Rehabilitation"]
["Amador City","Alhambra","Amador City","Cerritos","Amador City","Carson","Amador",null,null,"Amador City","Carson",null,"Rental: Acquisition","Rental: Acquisition","Rental: Acquisition","Supportive/Case Management Services","Ownership: Acquisition"]
["Amador County","Aliso Viejo","Amador County","Chico","Amador County","Cerritos","Butte",null,null,"Amador County","Cerritos",null,"Rental: Rehabilitation","Rental: Rehabilitation","Rental: Rehabilitation","Navigation Center Operating","Ownership: Rehabilitation"]
["American Canyon","Anaheim","American Canyon","Chino","American Canyon","Chico","Calaveras",null,null,"American Canyon","Chico",null,"Rental: Preservation","Rental: Preservation","Rental: Preservation","Navigation Center Capital Costs"]
["Anderson","Antioch","Anderson","Compton","Anderson","Chino","Colusa",null,null,"Anderson","Chino",null,"Ownership: Predevelopment","Ownership: Predevelopment","Ownership: Predevelopment","Emergency Shelter Operating"]
["Angels","Apple Valley","Angels","El Cajon","Angels","Clovis City","Contra Costa",null,null,"Angels","Chino Hills",null,"Ownership: Development","Ownership: Development","Ownership: Development","Emergency Shelter Capital Costs"]
["Arcata","Bakersfield","Arcata","El Centro","Arcata","Compton","Del Norte",null,null,"Arcata","Clovis City",null,"Ownership: Acquisition","Ownership: Acquisition","Ownership: Acquisition","Permanent Housing: New Construction"]
["Artesia","Baldwin Park","Artesia","Elk Grove","Artesia","Concord","El Dorado",null,null,"Artesia","Compton",null,"Ownership: Rehabilitation","Ownership: Rehabilitation","Ownership: Rehabilitation","Permanent Housing: Rehabilitation"]
["Arvin","Bellflower","Atwater","Encinitas","Atwater","Contra Costa County","Fresno",null,null,"Atwater","Concord",null,"Ownership: Preservation","Ownership: Preservation","Ownership: Preservation","Permanent Housing: Preservation"]
["Atwater","Berkeley","Auburn","Escondido","Auburn","Cupertino City","Glenn",null,null,"Auburn","Contra Costa County",null,"ADU","ADU","ADU","Street Outreach"]
["Auburn","Buena Park","Avenal","Gardena","Avenal","Downey","Humboldt",null,null,"Avenal","Cupertino City",null,null,"Transitional Housing",null,"Transitional Housing: New Construction"]
["Avenal","Burbank","Benicia","Glendale","Benicia","El Cajon","Imperial",null,null,"Benicia","Downey",null,null,"Emergency Shelter",null,"Transitional Housing: Rehabilitation"]
["Benicia","Camarillo","Biggs","Glendora City","Biggs","El Centro","Inyo",null,null,"Biggs","El Cajon",null,null,null,null,"Transitional Housing: Preservation"]
["Biggs","Carlsbad","Bishop","Hesperia","Bishop","Elk Grove","Kern",null,null,"Bishop","El Centro (Colonia Only)"]
["Bishop","Carson","Blue Lake","Huntington Park","Blue Lake","Encinitas","Kings",null,null,"Blue Lake","Elk Grove"]
["Blue Lake","Cathedral City","Brawley","Inglewood","Brawley","Escondido","Lake",null,null,"Brawley","Encinitas",null,2019]
["Brawley","Cerritos","Butte County","Lake Forest","Butte County","Fountain Valley","Lassen",null,null,"Butte County","Escondido",null,2020]
["Butte County","Chico","Calexico","Lakewood","Calaveras County","Gardena","Los Angeles",null,null,"Calaveras County","Fountain Valley",null,2021]
["Calaveras County","Chino","Calimesa","Lompoc","Calexico","Gilroy City","Madera",null,null,"Calexico","Gardena",null,2022]
["Calexico","Chino Hills","Calipatria","Milpitas City","Calimesa","Glendale","Marin",null,null,"Calimesa","Gilroy City",null,2023]
["Calimesa","Chula Vista","Calistoga","Montebello","Calipatria","Glendora City","Mariposa",null,null,"Calipatria","Glendale"]
["Calipatria","Citrus Heights","Capitola","Monterey Park","Calistoga","Hesperia","Mendocino",null,null,"Calistoga","Glendora City"]
["Calistoga","Clovis City","Carmel-by-the-Sea","Mountain View","Capitola","Huntington Park","Merced",null,null,"Capitola","Hawthorne"]
["Capitola","Compton","Clearlake","Norwalk","Carmel-by-the-Sea","Inglewood","Modoc",null,null,"Carmel-by-the-Sea","Hesperia"]
["Carmel-by-the-Sea","Concord","Colfax","Palo Alto","Clearlake","Laguna Niguel","Mono",null,null,"Clearlake","Huntington Park"]
["Chowchilla","Corona","Colusa","Paradise","Colfax","Lake Forest","Monterey",null,null,"Colfax","Laguna Niguel"]
["Clearlake","Costa Mesa","Colusa County","Paramount City","Colusa","Lakewood","Napa",null,null,"Colusa","Lake Forest"]
["Coalinga","Cupertino City","Corcoran","Pico Rivera","Colusa County","Lompoc","Nevada",null,null,"Colusa County","Lakewood"]
["Colfax","Daly City","Corning","Pleasanton City","Corcoran","Madera","Orange",null,null,"Corcoran","Lompoc"]
["Colfax","Davis","Crescent City","Rancho Cordova City","Corning","Merced","Placer",null,null,"Corning","Madera"]
["Colusa","Delano City","Del Norte County","Rancho Cucamonga","Crescent City","Milpitas City","Plumas",null,null,"Crescent City","Merced"]
["Colusa","Downey","Dixon","Redondo Beach","Del Norte County","Montebello","Riverside",null,null,"Del Norte County","Milpitas City"]
["Colusa County","El Cajon","Dorris","Rialto","Dixon","Monterey Park","Sacramento",null,null,"Dixon","Montebello"]
["Corcoran","El Centro","Dos Palos","Rosemead","Dorris","Mountain View","San Benito",null,null,"Dorris","Monterey Park"]
["Corning","El Monte","Dunsmuir","San Marcos City","Dos Palos","Newport Beach","San Bernardino",null,null,"Dos Palos","Mountain View"]
["Crescent City","Elk Grove","El Centro (Colonia Only)","Santa Clarita","Dunsmuir","Norwalk","San Diego",null,null,"Dunsmuir","Newport Beach"]
["Del Norte County","Encinitas","Etna","Santee","El Centro (Colonia Only)","Palo Alto","San Francisco",null,null,"El Centro","Norwalk"]
["Dinuba","Escondido","Ferndale","Seaside","Etna","Paradise","San Joaquin",null,null,"Etna","Palo Alto"]
["Dixon","Fairfield","Firebaugh","Sunnyvale","Eureka","Paramount City","San Luis Obispo",null,null,"Eureka","Paradise"]
["Dorris","Fontana","Fort Bragg","Turlock","Ferndale","Petaluma","San Mateo",null,null,"Ferndale","Paramount City"]
["Dos Palos","Fountain Valley","Fort Jones","Vacaville","Firebaugh","Pico Rivera","Santa Barbara",null,null,"Firebaugh","Petaluma"]
["Dunsmuir","Fremont","Fortuna","Watsonville","Fort Bragg","Pittsburg","Santa Clara",null,null,"Fort Bragg","Pico Rivera"]
["El Centro","Fresno","Fowler","West Covina","Fort Jones","Pleasanton City","Santa Cruz",null,null,"Fort Jones","Pittsburg"]
["El Dorado County","Fresno County","Greenfield","West Sacramento","Fortuna","Rancho Cordova City","Shasta",null,null,"Fortuna","Pleasanton City"]
["Etna","Fullerton","Gridley",null,"Fowler","Rancho Cucamonga","Sierra",null,null,"Fowler","Rancho Cordova City"]
["Eureka","Garden Grove","Guadalupe",null,"Greenfield","Redondo Beach","Siskiyou",null,null,"Greenfield","Rancho Cucamonga"]
["Exeter","Gardena","Gustine",null,"Gridley","Rialto","Solano",null,null,"Gridley","Redondo Beach"]
["Farmersville","Gilroy City","Hidden Hills",null,"Guadalupe","Rosemead","Sonoma",null,null,"Guadalupe","Redwood City"]
["Ferndale","Glendale","Hollister",null,"Gustine","San Clemente","Stanislaus",null,null,"Gustine","Rialto"]
["Firebaugh","Glendora City","Holtville",null,"Hidden Hills","San Marcos City","Sutter",null,null,"Hidden Hills","Rosemead"]
["Fort Bragg","Goleta","Imperial",null,"Hollister","Santa Clara","Tehama",null,null,"Hollister","San Clemente"]
["Fort Jones","Hanford","Imperial County",null,"Holtville","Santa Clara County","Trinity",null,null,"Holtville","San Marcos City"]
["Fortuna","Hawthorne","Indian Wells",null,"Imperial","Santa Clarita","Tulare",null,null,"Huron","San Mateo County"]
["Fowler","Hayward","Industry",null,"Imperial County","Santee","Tuolumne",null,null,"Imperial","Santa Clara"]
["Glenn County","Hemet","Inyo County",null,"Indian Wells","Seaside","Ventura",null,null,"Imperial County","Santa Clara County"]
["Grass Valley","Hesperia","Ione",null,"Industry","Sunnyvale","Yolo",null,null,"Indian Wells","Santa Clarita"]
["Greenfield","Huntington Beach","Jackson",null,"Inyo County","Torrance","Yuba",null,null,"Industry","Santee"]
["Gridley","Huntington Park","Kings County",null,"Ione","Turlock",null,null,null,"Inyo County","Seaside"]
["Grover Beach","Indio City","Lake County",null,"Jackson","Vacaville",null,null,null,"Ione","Sunnyvale"]
["Guadalupe","Inglewood","Lakeport",null,"Kings County","Watsonville",null,null,null,"Jackson","Torrance"]
["Gustine","Irvine","Lassen County",null,"Lake County","West Covina",null,null,null,"Kings County","Turlock"]
["Hidden Hills","La Habra","Lemoore",null,"Lakeport","West Sacramento",null,null,null,"Lake County","Union City"]
["Hollister","La Mesa","Lincoln",null,"Lassen County","n/a",null,null,null,"Lakeport","Upland"]
["Holtville","Laguna Niguel","Live Oak",null,"Lemoore","n/a",null,null,null,"Lassen County","Vacaville"]
["Humboldt County","Lake Elsinore","Livingston",null,"Lincoln","n/a",null,null,null,"Lemoore","Watsonville"]
["Huron","Lake Forest","Loomis",null,"Live Oak","n/a",null,null,null,"Lincoln","West Covina"]
["Imperial","Lakewood","Los Banos",null,"Livingston","n/a",null,null,null,"Live Oak","West Sacramento"]
["Imperial County","Lancaster","Loyalton",null,"Loomis","n/a",null,null,null,"Livingston","Whittier"]
["Indian Wells","Livermore","Madera County",null,"Los Banos","n/a",null,null,null,"Loomis"]
["Industry","Lodi","Mammoth Lakes",null,"Loyalton","n/a",null,null,null,"Los Banos"]
["Inyo County","Lompoc","Maricopa",null,"Madera County","n/a",null,null,null,"Loyalton"]
["Ione","Long Beach","Marina",null,"Mammoth Lakes","n/a",null,null,null,"Madera County"]
["Jackson","Los Angeles","McFarland",null,"Maricopa","n/a",null,null,null,"Mammoth Lakes"]
["King City","Los Angeles County","Modoc County",null,"Marina","n/a",null,null,null,"Maricopa"]
["Kings County","Lynwood","Mono County",null,"McFarland","n/a",null,null,null,"Marina"]
["Lake County","Madera","Montague",null,"Mendocino County","n/a",null,null,null,"McFarland"]
["Lakeport","Marin County","Mount Shasta",null,"Modoc County","n/a",null,null,null,"Mendocino County"]
["Lassen County","Menifee","Orange Cove",null,"Mono County","n/a",null,null,null,"Modoc County"]
["Lemoore","Merced","Palos Verdes Estates",null,"Montague","n/a",null,null,null,"Mono County"]
["Lincoln","Milpitas City","Pismo Beach",null,"Mount Shasta","n/a",null,null,null,"Montague"]
["Lindsay","Mission Viejo","Placerville",null,"Orange Cove","n/a",null,null,null,"Mount Shasta"]
["Live Oak","Modesto","Plymouth",null,"Palos Verdes Estates","n/a",null,null,null,"Napa County"]
["Livingston","Montebello","Point Arena",null,"Pismo Beach","n/a",null,null,null,"Orange Cove"]
["Loomis","Monterey","Portola",null,"Placerville","n/a",null,null,null,"Palos Verdes Estates"]
["Los Banos","Monterey County","Rancho Mirage",null,"Plymouth","n/a",null,null,null,"Parlier"]
["Loyalton","Monterey Park","Red Bluff",null,"Point Arena","n/a",null,null,null,"Pismo Beach"]
["Madera County","Moreno Valley","Rio Dell",null,"Portola","n/a",null,null,null,"Placerville"]
["Mammoth Lakes","Mountain View","Rio Vista",null,"Rancho Mirage","n/a",null,null,null,"Plymouth"]
["Maricopa","Napa City","San Benito County",null,"Red Bluff","n/a",null,null,null,"Point Arena"]
["Marina","National City","San Joaquin",null,"Rio Dell","n/a",null,null,null,"Portola"]
["Mariposa County","Newport Beach","San Juan Bautista",null,"Rio Vista","n/a",null,null,null,"Rancho Mirage"]
["Marysville","Norwalk","San Juan Capistrano",null,"San Benito County","n/a",null,null,null,"Red Bluff"]
["McFarland","Oakland","Sand City",null,"San Joaquin","n/a",null,null,null,"Rio Dell"]
["Mendocino County","Oceanside","Scotts Valley",null,"San Juan Bautista","n/a",null,null,null,"Rio Vista"]
["Merced County","Ontario","Soledad",null,"San Juan Capistrano","n/a",null,null,null,"San Benito County"]
["Modoc County","Orange","Sonora",null,"Sand City","n/a",null,null,null,"San Juan Bautista"]
["Mono County","Orange County","St. Helena",null,"Scotts Valley","n/a",null,null,null,"San Juan Capistrano"]
["Montague","Oxnard","Suisun City",null,"Shasta County","n/a",null,null,null,"Sand City"]
["Mount Shasta","Palm Desert","Susanville",null,"Shasta Lake","n/a",null,null,null,"Scotts Valley"]
["Napa County","Palm Springs","Sutter Creek",null,"Sierra County","n/a",null,null,null,"Shasta County"]
["Nevada City","Palmdale","Taft",null,"Soledad","n/a",null,null,null,"Shasta Lake"]
["Nevada County","Palo Alto","Tehama",null,"Sonora","n/a",null,null,null,"Sierra County"]
["Orange Cove","Paradise","Tehama County",null,"St. Helena","n/a",null,null,null,"Soledad"]
["Orland","Paramount City","Trinidad",null,"Suisun City","n/a",null,null,null,"Sonora"]
["Oroville","Pasadena","Trinity County",null,"Susanville","n/a",null,null,null,"St. Helena"]
["Pacific Grove","Perris City","Tulelake",null,"Sutter Creek","n/a",null,null,null,"Suisun City"]
["Palos Verdes Estates","Petaluma","Tuolumne County",null,"Taft","n/a",null,null,null,"Susanville"]
["Parlier","Pico Rivera","Ukiah",null,"Tehama","n/a",null,null,null,"Sutter Creek"]
["Pismo Beach","Pittsburg","Wasco",null,"Tehama County","n/a",null,null,null,"Taft"]
["Placer County","Placentia","Weed",null,"Trinidad","n/a",null,null,null,"Tehama"]
["Placerville","Pleasanton City","Westmorland",null,"Trinity County","n/a",null,null,null,"Tehama County"]
["Plumas County","Pomona","Wheatland",null,"Tulelake","n/a",null,null,null,"Trinidad"]
["Plymouth","Porterville","Williams",null,"Tuolumne County","n/a",null,null,null,"Trinity County"]
["Point Arena","Rancho Cordova City","Willits",null,"Ukiah","n/a",null,null,null,"Tulelake"]
["Portola","Rancho Cucamonga","Yountville",null,"Vernon","n/a",null,null,null,"Tuolumne County"]
["Rancho Mirage","Rancho Santa Margarita","Yreka",null,"Wasco","n/a",null,null,null,"Ukiah"]
["Red Bluff","Redding",null,null,"Weed","n/a",null,null,null,"Vernon"]
["Rio Dell","Redondo Beach",null,null,"Westmorland","n/a",null,null,null,"Wasco"]
["Rio Vista","Redwood  City",null,null,"Wheatland","n/a",null,null,null,"Weed"]
["Riverbank","Rialto",null,null,"Williams","n/a",null,null,null,"Westmorland"]
["San Benito County","Riverside",null,null,"Willits","n/a",null,null,null,"Wheatland"]
["San Joaquin","Riverside County",null,null,"Yountville","n/a",null,null,null,"Williams"]
["San Juan Bautista","Rocklin City",null,null,"Yreka","n/a",null,null,null,"Willits"]
["San Juan Capistrano","Rosemead",null,null,null,"n/a",null,null,null,"Woodlake"]
["Sand City","Roseville",null,null,null,"n/a",null,null,null,"Yountville"]
["Santa Cruz County","Sacramento",null,null,null,"n/a",null,null,null,"Yreka"]
["Scotts Valley","Sacramento County"]
["Shasta County","Salinas"]
["Shasta Lake","San Barbara County"]
["Sierra County","San Bernardino"]
["Siskiyou County","San Bernardino County"]
["Solano County","San Buenaventura"]
["Soledad","San Clemente"]
["Sonora","San Diego"]
["South Lake Tahoe","San Diego County"]
["St. Helena","San Francisco"]
["Suisun City","San Joaquin County"]
["Susanville","San Jose"]
["Sutter County","San Leandro"]
["Sutter Creek","San Luis Obispo County"]
["Taft","San Marcos City"]
["Tehama","San Mateo"]
["Tehama County","San Mateo County"]
["Trinidad","Santa Ana"]
["Trinity County","Santa Barbara"]
["Truckee","Santa Clara"]
["Tulare County","Santa Clara County"]
["Tulelake","Santa Clarita"]
["Tuolumne County","Santa Cruz"]
["Ukiah","Santa Maria"]
["Vernon","Santa Monica"]
["Wasco","Santa Rosa"]
["Weed","Santee"]
["Westmorland","Seaside"]
["Wheatland","Simi Valley"]
["Williams","Sonoma County"]
["Willits","South Gate"]
["Willows","South San Francisco"]
["Winters","Stanislaus County"]
["Woodlake","Stockton"]
["Yolo County","Sunnyvale"]
["Yountville","Temecula"]
["Yreka","Thousand Oaks"]
["Yuba County","Torrance"]
[null,"Tulare"]
[null,"Turlock"]
[null,"Tustin"]
[null,"Union City"]
[null,"Upland"]
[null,"Vacaville"]
[null,"Vallejo"]
[null,"Ventura County"]
[null,"Victorville"]
[null,"Visalia"]
[null,"Vista"]
[null,"Walnut Creek"]
[null,"Watsonville"]
[null,"West Covina"]
[null,"West Sacramento"]
[null,"Westminster"]
[null,"Whittier"]
[null,"Woodland"]
[null,"Yorba Linda"]
[null,"Yuba City"]