{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["CoverPage","Instructions","Instructions & Checklist","Formula Allocation Application","Competitive Allocation","302(c)(4) Plan","Legislative Contacts ","Appplication Support","Formula","DATA"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":1,"defined_names":80,"comments":3,"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":[[34,0,34,6],[0,0,0,6],[2,0,2,6],[19,0,19,6],[20,0,20,6],[22,0,22,6],[23,0,23,6],[25,0,25,6],[26,0,26,6],[29,0,29,6],[30,0,30,6],[31,0,31,6]]}
["Permanent Local Housing Allocation (PLHA) Formula Allocation "]
[]
["2020 Application"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State of California"]
["Governor, Gavin Newsom"]
[]
["Lourdes Castro Ramírez, 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"]
["PLHA Program Email: PLHA@hcd.ca.gov"]
[]
[]
["Final Filing Date: October 23, 2020 through December 31, 2020 \nat 11:59 P.M. PST"]

{"sheet":"Instructions","index":1,"n_rows":37,"n_cols":36,"rows_kept":37,"cut":false,"hidden":true,"merged":[[4,0,4,37],[0,0,0,34],[0,35,0,37],[1,0,1,37],[2,0,2,37],[3,0,3,37],[16,0,16,37],[5,0,5,37],[6,0,6,37],[7,0,7,37],[8,0,8,37],[9,0,9,37],[10,0,10,37],[11,0,11,37],[12,0,12,37],[13,0,13,37],[14,0,14,37],[15,0,15,37],[28,0,28,37],[17,0,17,37],[18,0,18,37],[19,0,19,37],[20,0,20,37],[21,0,21,37],[22,0,22,37],[23,0,23,37],[24,0,24,37],[25,0,25,37],[26,0,26,37],[27,0,27,37],[35,0,35,37],[36,0,36,37],[29,0,29,37],[30,0,30,37],[31,0,31,37],[32,0,32,37],[33,0,33,37],[34,0,34,37]]}
["Instructions",null,null,null,null,null,null,null,null,null,null,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'!#REF!","v":{"$error":"#REF!"}}]
["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 a USB flash drive with all applicable information must be received by HCD via postal carrier no later than 5:00 p.m. on:"]
["2020-07-27"]
["Applications must be on the Department’s forms and cannot be altered or modified by the Sponsor. Excel forms must be in Excel format and unprotected, not a .pdf document.  Please fill-out the Application Support worksheet and email the entire workbook to Application Support for application errors at AppSupport@hcd.ca.gov."]
["General Instructions (Addition instructions and guidance are given throughout the Supplemental Application in \"red\" text and in cell comments. "]
["\"Yellow\" cells are for Sponsor 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\" throughout 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 Sponsor 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 Sponsor. "]
["\"Red\" shaded cells indicate the Sponsor has failed to meet a requirement of the program. Point cells in \"Scoring\" worksheet shaded in \"Red\" indicate that the Sponsor has failed to meet the minimum points required. "]
["Universal Application (UA) Instructions"]
["Sponsors must complete the following worksheets in the UA. "]
["General"]
["Narrative"]
["Site & Units"]
["Misc. "]
["Rents"]
["Subsidies"]
["Dev Budget"]
["TBL and High Cost Test"]
["Developer Fee 2017"]
["Supportive Services Costs (Supportive Housing and Special Needs Projects Only)"]
["Reserves"]
["Operating"]
["Cash Flow"]
["Supplemental Application Instructions"]
["Sponsor must complete the following worksheets in the Supplemental Application. "]
["B - Project Requirements"]
["B1 - Development Team Contacts"]
["B2 - SH Experience 7302(f)(1-3) (Supportive Housing Projects Only)"]
["B3 - Supportive Services Plan (Supportive Housing and Special Needs Projects Only)"]
["B4 - SS Verification (Supportive Housing and Special Needs Projects Only)"]
["B5 - At High Risk (At High Risk Projects Only)"]
["C - Local & Env Verification "]
["D - Max Loan & Unit Mix"]
["E - Project Selection"]
["F - Certification & Legal"]
["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":"Instructions & Checklist","index":2,"n_rows":23,"n_cols":36,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,0,22,37],[16,35,16,37],[21,35,21,37],[19,35,19,37],[21,0,21,3],[21,4,21,10],[19,0,19,3],[20,0,20,3],[20,35,20,37],[19,4,19,10],[20,4,20,10],[18,11,18,34],[19,11,19,34],[20,11,20,34],[21,11,21,34],[18,35,18,37],[13,0,13,37],[14,0,14,37],[15,0,15,37],[17,35,17,37],[16,0,16,3],[17,0,17,3],[18,0,18,3],[17,4,17,10],[16,4,16,10],[18,4,18,10],[17,11,17,34],[16,11,16,34],[0,0,0,34],[0,35,0,37],[1,0,1,37],[2,0,2,37],[3,0,3,37],[9,0,9,37],[11,0,11,37],[12,0,12,37],[10,0,10,37],[4,0,4,37],[5,0,5,37],[6,0,6,37],[7,0,7,37],[8,0,8,37]]}
["Instructions",null,null,null,null,null,null,null,null,null,null,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. 10/19/20"}]
["When opening this file, a yellow banner at the top may appear with a button that says \"Enable Content\". It is essential that you click this box so that the macros are enabled. Enabling macros is necessary for full worksheet functionality. Macros do not work with Microsoft's Excel version for Apple Mac.  "]
["Applications must be submitted electronically to the Department’s website. Requirements for uploading the Application Workbook and required supporting documentation, including naming conventions, are described in the application instructions available at https://www.hcd.ca.gov/grants-funding/active-funding/plha.shtml. All applicable information must be received by HCD no later than 11:59 p.m. on: "]
["2020-12-31"]
["Applications must be on the Department’s forms and cannot be altered or modified by the Applicant. Excel forms must be in Excel format and 'save as' .xls or .xlsx. Do not 'save as' .xlsm or .pdf format. For application errors please fill out the Application Support worksheet and email the entire workbook to Application Support for application errors at AppSupport@hcd.ca.gov and PLHA@hcd.ca.gov"]
["General Instructions (Additional instructions and guidance are given throughout the Formula Allocation Application in \"red\" text and in cell comments. "]
["Guideline references are made with \"§\" and the corresponding guideline section number. "]
["\"Yellow\" cells are for Sponsor 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\" throughout 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 PLHA Application. For Example: \"App1 Payee Data\" for Sponsor 1 Payee Data Record/STD. 204."]
["Threshold items are indicated in \"blue\" cells."]
["\"Red\" shaded cells indicate the Sponsor has failed to meet a requirement of the program. Point cells in the Scoring worksheet shaded in \"red\" indicate that the Sponsor has failed to meet the minimum points required. "]
["Sponsor must complete the following worksheets in the PLHA Formula Allocation Application. "]
["Formula Allocation Application"]
["302(c)(4) Plan"]
["Legislative Contacts"]
["Checklist"]
["Threshold Requirement",null,null,null,"Electronic File Name",null,null,null,null,null,null,"Document Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Included?"]
["X",null,null,null,"Application and Plan Adoption Reso",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. \nPLHA webpage for Application and Plan Adoption Resolution Document"]
["X",null,"X",null,"App1 TIN",null,null,null,null,null,null,{"$f":"'Formula Allocation Application'!L20","v":"Taxpayer Identification Number Document"}]
["X",null,"X",null,{"$f":"'Formula Allocation Application'!D21","v":"Applicant Agreement"},null,{"$f":"'Formula Allocation Application'!D20","v":"App1 TIN"},null,null,null,null,{"$f":"'Formula Allocation Application'!L21","v":"Legally binding agreement between Delegating and Administering Local Governments  "}]
["X",null,"X",null,"Plan Adoption Reso ",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. \nPLHA webpage for Plan Adoption Resolution Document"]
["X",null,null,null,{"$f":"'Formula Allocation Application'!D45","v":"Reuse Plan"},null,null,null,null,null,null,"Program Income Reuse Plan describing how repaid loans will be used for eligible activities in Section 301."]
["Disclosure of Application (California Public Records Act Statutes of 1968 Chapter 1473): Information provided in the application will become a public record available for review by the public, pursuant to the California Public Records Act Statutes of 1968 Chapter 1473. As such, any materials provided will be disclosable to any person making a request under this Act. The Department cautions Applicants to use discretion in providing information not specifically requested, including but not limited to, bank accounts, personal phone numbers and home addresses. By providing this information to the Department, the Applicant is waiving any claim of confidentiality and consents to the disclosure of submitted material upon request.\""]

{"sheet":"Formula Allocation Application","index":3,"n_rows":54,"n_cols":48,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,0,1,6],[1,7,1,37],[2,0,2,21],[2,22,2,37],[3,0,3,11],[22,35,22,37],[22,0,22,34],[23,35,23,37],[24,35,24,37],[3,28,3,33],[3,34,3,37],[3,24,3,27],[3,17,3,23],[3,12,3,16],[4,0,4,37],[5,0,5,37],[6,0,6,37],[7,0,7,3],[7,4,7,37],[9,20,9,21],[12,33,12,37],[11,34,11,37],[10,0,10,3],[10,4,10,8],[9,0,9,1],[9,2,9,8],[17,36,17,37],[35,0,35,35],[35,36,35,37],[18,0,18,2],[14,36,14,37],[19,3,19,10],[18,3,18,10],[17,3,17,10],[15,0,15,35],[18,11,18,29],[18,30,18,35],[18,36,18,37],[19,0,19,2],[20,0,20,2],[19,11,19,29],[19,30,19,35],[19,36,19,37],[11,31,11,33],[16,36,16,37],[26,35,26,37],[27,35,27,37],[20,3,20,10],[53,20,53,34],[53,36,53,37],[50,0,50,37],[49,0,49,35],[49,36,49,37],[48,0,48,35],[52,0,52,10],[53,0,53,10],[52,12,52,18],[53,12,53,18],[48,36,48,37],[51,0,51,37],[52,20,52,34],[52,36,52,37],[20,11,20,29],[32,0,32,34],[31,0,31,34],[30,0,30,34],[12,29,12,32],[13,19,13,26],[17,30,17,35],[13,17,13,18],[13,27,13,28],[25,0,25,34],[24,0,24,34],[23,0,23,34],[32,35,32,37],[29,0,29,34],[28,0,28,34],[27,0,27,34],[26,0,26,34],[29,35,29,37],[30,35,30,37],[28,35,28,37],[34,0,34,35],[25,35,25,37],[31,35,31,37],[47,36,47,37],[47,0,47,35],[46,36,46,37],[46,0,46,35],[38,36,38,37],[40,0,40,35],[40,36,40,37],[41,0,41,35],[43,36,43,37],[39,36,39,37],[45,0,45,37],[39,0,39,35],[42,0,42,35],[42,36,42,37],[44,0,44,2],[44,3,44,10],[44,11,44,29],[44,30,44,35],[44,36,44,37],[43,0,43,35],[11,19,11,26],[10,21,10,30],[10,17,10,20],[37,36,37,37],[34,36,34,37],[33,0,33,37],[0,0,0,34],[0,35,0,37],[41,36,41,37],[38,0,38,35],[9,11,9,13],[9,14,9,15],[9,16,9,19],[9,22,9,37],[14,0,14,35],[15,36,15,37],[17,0,17,2],[17,11,17,29],[9,9,9,10],[20,30,20,35],[20,36,20,37],[37,0,37,35],[36,0,36,35],[21,0,21,37],[10,9,10,10],[13,34,13,37],[8,3,8,37],[36,36,36,37],[13,31,13,33],[16,0,16,35],[10,34,10,37],[12,0,12,3],[11,17,11,18],[10,31,10,33],[8,0,8,2],[11,0,11,2],[13,3,13,16],[12,17,12,20],[12,21,12,28],[12,9,12,10],[12,11,12,16],[13,29,13,30],[11,27,11,28],[11,29,11,30],[13,0,13,2],[12,4,12,8],[10,11,10,16],[11,3,11,16]]}
["Local Government Formula Allocation",null,null,null,null,null,null,null,null,null,null,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. 10/19/20",null,null,null,null,null,null,null,null,"Unit of general purpose local government."]
["Eligible Applicant Type: "]
["Local Government Recipient of PLHA Formula Allocation: "]
["Approximate PLHA Formula Allocation Amount:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(W3,Formula!C14:M365,11,FALSE),0)","v":0},null,null,null,null,"Allowable Local Admin (5%):",null,null,null,null,null,null,{"$f":"AV4","v":0},null,null,null,"Admin Requested",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M4*0.05","v":0},{"$f":"ROUNDDOWN(AU4,0)","v":0}]
["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 (2019-2023), allocations must equal to 100% annually including the allowable administrative costs of up to five percent.\n  "]
["Eligible Applicants §300",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA-512","Daly City/San Mateo County CoC",627447]
["§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)?"]
["If applicant answered \"Yes\" above, has the delegated Applicant completed an additional application submission on behalf of the delegating jurisdiction?"]
["File Name:",null,null,"Application and 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. \nPLHA webpage for Application and Plan Adoption Resolution Document",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,"App1 Signature Block",null,null,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,"Uploaded to HCD?"]
["File Name:",null,null,"App1 TIN",null,null,null,null,null,null,null,"Taxpayer Identification Number Document",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 Agreement",null,null,null,null,null,null,null,"Legally binding agreement between Delegating and Administering Local Governments  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Eligible Activities, §301",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA-512","Daly City/San Mateo County CoC",627447]
["§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,"Included?"]
["§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. "]
["Threshold Requirements, §302"]
["§302(a) Housing Element compliance: Applicant or Delegating Local Government's Housing Element was adopted by the Local Government’s governing body by the application deadline and subsequently determined to be in substantial compliance with state Housing Element Law pursuant to Government Code Section 65585."]
["§302(b) Applicant or Delegating Local Government has submitted the current or prior year's Annual Progress Report to the Department of Housing and Community Development pursuant to Government Code Section 65400. "]
["§302(c)(2) Applicant certifies that submission of the application was authorized by the governing board of the Applicant."]
["§302(c)(3) Applicant certifies that, if the Local Government proposes allocation of funds for any activity to another entity, the Local government’s selection process had no conflicts of interest and was accessible to the public. "]
["§302(c)(4) Does the application include a Plan in accordance with §302(c)(4)? "]
["§302(c)(4)(D) Applicant certifies that the Plan was authorized and adopted by resolution by the Local Government and that the public had an adequate opportunity to review and comment on its content"]
["§302(c)(5) Applicant certifies that the Plan submitted is for a term of five years. Local Governments agree to inform the Department of changes made to the Plan in each succeeding year of the term of the Plan."]
["§302(c)(6) Applicant certifies that it will ensure compliance with §302(c)(6) if funds are used for the acquisition, construction, or rehabilitation of for-sale housing projects or units within for-sale housing projects.  "]
["§302(c)(7) Applicant certifies that it will ensure that the PLHA assistance is in the form of a low-interest, deferred loan to the Sponsor of the Project, if funds are used for the development of an Affordable Rental Housing Development. The loan shall be evidenced through a Promissory Note secured by a Deed of Trust."]
["§302(c)(8) Has Applicant attached a program income reuse plan describing how repaid loans will be reused for eligible activities specified in Section 301?"]
["File Name:",null,null,"Reuse Plan",null,null,null,"Program Income Reuse Plan describing how repaid loans will be used for eligible activities in Section 301.",null,null,null,"Program Income Reuse Plan describing how repaid loans will be used for eligible activities in Section 301.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Administration"]
["Applicant agrees to adhere to §500, Accounting Records."]
["Applicant agrees to adhere to §501, Audits/Monitoring of PLHA Files. "]
["Applicant agrees to adhere to §502, Cancellation/Termination."]
["Applicant agrees to adhere to §503, Reporting."]
["Certifications"]
["On behalf of the entity identified below, I certify that: The information, statements and attachments included in this application are, to the best of my knowledge and belief, true and correct and I possess the legal authority to submit this application on behalf of the entity identified in the signature block."]
["    "]
["Authorized Representative Printed Name ",null,null,null,null,null,null,null,null,null,null,null,"Title",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":"Competitive Allocation","index":4,"n_rows":55,"n_cols":45,"rows_kept":55,"cut":false,"hidden":true,"merged":[[44,0,44,33],[44,34,44,35],[44,36,44,37],[35,36,35,37],[36,0,36,33],[36,34,36,35],[36,36,36,37],[37,0,37,33],[37,34,37,35],[37,36,37,37],[24,0,24,32],[24,33,24,37],[26,0,26,10],[26,11,26,24],[26,25,26,33],[26,34,26,37],[27,0,27,37],[28,0,28,37],[29,0,29,2],[29,3,29,4],[29,5,29,10],[29,11,29,29],[29,30,29,35],[29,36,29,37],[25,36,25,37],[30,0,30,2],[30,3,30,4],[43,34,43,35],[43,36,43,37],[41,0,41,35],[39,0,39,33],[39,34,39,35],[40,0,40,33],[40,34,40,35],[40,36,40,37],[41,36,41,37],[30,5,30,10],[30,11,30,29],[30,30,30,35],[30,36,30,37],[54,0,54,4],[54,5,54,20],[54,22,54,27],[54,28,54,29],[54,30,54,32],[54,34,54,37],[52,0,52,12],[52,14,52,18],[52,20,52,34],[52,36,52,37],[53,0,53,5],[53,6,53,18],[53,19,53,24],[53,25,53,37],[49,0,49,37],[50,0,50,37],[51,0,51,12],[51,14,51,18],[51,20,51,34],[51,36,51,37],[47,0,47,2],[47,3,47,9],[47,10,47,29],[47,30,47,35],[47,36,47,37],[48,0,48,2],[48,3,48,9],[48,10,48,29],[48,30,48,35],[48,36,48,37],[45,0,45,37],[46,0,46,2],[46,3,46,9],[46,10,46,29],[46,30,46,35],[46,36,46,37],[31,30,31,34],[42,0,42,33],[42,34,42,35],[39,36,39,37],[35,0,35,33],[35,34,35,35],[34,0,34,33],[34,34,34,35],[34,36,34,37],[33,0,33,35],[33,36,33,37],[42,36,42,37],[38,0,38,35],[38,36,38,37],[31,35,31,37],[31,0,31,29],[32,0,32,35],[43,0,43,33],[13,0,13,35],[13,36,13,37],[15,0,15,32],[15,33,15,37],[16,0,16,32],[16,33,16,37],[32,36,32,37],[11,0,11,35],[11,36,11,37],[14,0,14,35],[14,36,14,37],[17,0,17,35],[17,36,17,37],[18,0,18,35],[18,36,18,37],[19,0,19,10],[19,11,19,24],[19,25,19,33],[19,34,19,37],[20,0,20,37],[21,0,21,37],[22,0,22,2],[22,3,22,4],[25,0,25,35],[10,0,10,35],[10,36,10,37],[9,0,9,1],[9,2,9,8],[9,9,9,10],[9,11,9,13],[9,14,9,15],[9,16,9,19],[12,0,12,37],[8,0,8,2],[8,3,8,37],[2,0,2,37],[3,0,3,37],[4,0,4,37],[5,0,5,37],[9,22,9,37],[0,0,0,34],[0,35,0,37],[1,0,1,12],[1,13,1,22],[1,23,1,29],[1,30,1,37],[6,0,6,3],[6,4,6,37],[7,0,7,2],[7,3,7,37],[22,5,22,10],[22,11,22,29],[22,30,22,35],[22,36,22,37],[23,0,23,2],[23,3,23,4],[23,5,23,10],[23,11,23,29],[23,30,23,35],[23,36,23,37]]}
["Competitive Allocation ",null,null,null,null,null,null,null,null,null,null,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. 2/19/19",null,null,null,null,null,null,null,null,"Unit of general purpose local government."]
["Estimated Allocation From SB 2 Formula Allocation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Allowable Local Admin (5%):"]
["Eligible Applicants §400",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA-512","Daly City/San Mateo County CoC",627447]
["(a) ) Eligible Applicants for the non-entitlement competitive allocation described in Section 100(b)(3) are limited to non-entitlement jurisdictions."]
["§300(c) For a list of eligible Applicants for each program component, please see Appendix A of the PLHA Guidelines."]
["Eligible Applicant:"]
["Applicant:  ",null,null,null,"Alpine County"]
["AE Name:"]
["Address:"]
["City:",null,null,null,null,null,null,null,null,"State:",null,null,null,null,"Zip:",null,null,null,null,null,"County:",null,"Alpine"]
["(d) Is Applicant designating another Local government to administer on its behalf its formula allocation of program funds?"]
["(d) If Applicant answered \"Yes\" above, have the governments enter into a legally binding agreement and the funds are expended for eligible activities and consistent with program requirements?"]
["Eligible Activites, §401, Threashold Requirements, §402",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA-512","Daly City/San Mateo County CoC",627447]
["§402(a) Housing Element compliance: Does the Applicant and any co-applicants have a Housing Element that has been adopted by the jurisdiction’s governing body by the deadline specified in the NOFA and subsequently determined to be in substantial compliance with state Housing Element law pursuant to GC Section 65585?",null,null,null,null,null,null,null,null,null,null,null,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"]
["§402(b) Has the Applicant and any co-applicants submitted to the Department the APR required by GC Section 65400 for the current or prior year by the application deadline date?",null,null,null,null,null,null,null,null,null,null,null,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"]
["§401(a) Eligible activities are limited to the following and must take place within the jurisdiction of the Applicant Local government: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Included?"]
["§401(a)(1) Development of new multifamily rental housing that is Affordable to households at or below 60 percent of AMI or substantial rehabilitation of multifamily rental housing that will be Affordable to households at or below 60 percent of AMI, but which is not currently restricted as Affordable housing."]
["§402 (c)(1) Applicant certifies that if the Local government proposes allocation of funds for any activity to another entity, the selection process shall avoid conflicts of interest, and shall be accessible to the public.",null,null,null,null,null,null,null,null,null,null,null,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"]
["§402 (c)(4) Does Applicant have site control? If yes, enter form of site control and most recent execution date."]
["Form of site control:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Most recent document execution date:"]
["Provide details below for unusual site control special circumstances:"]
[]
["File Name:",null,null,"B42",null,"Site Control ",null,null,null,null,null,"Provide documentation of the form of site control selected above meeting UMR §8303.",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,"B43",null,"Preliminary Title Report",null,null,null,null,null,"Provide a current preliminary report. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§401(a)(2) Assistance to persons who are experiencing or At risk of homelessness, including, but not limited to, through rapid rehousing, or rental assistance, or navigation centers, or new construction, rehabilitation, or preservation of permanent or transitional rental housing."]
["§402 (c)(4) Does Applicant have site control? If yes, enter form of site control and most recent execution date."]
["Form of site control:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Most recent document execution date:"]
["Provide details below for unusual site control special circumstances:"]
[]
["File Name:",null,null,"C13",null,"Site Control ",null,null,null,null,null,"Provide documentation of the form of site control selected above meeting UMR §8303.",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,"C14",null,"Preliminary Title Report",null,null,null,null,null,"Provide a current preliminary report. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["                                                             Selection Criteria, §403",null,null,null,null,null,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 Points: ",null,null,null,null,{"$f":"SUM(AK34,AK39)","v":0},null,null,null,null,null,"CA-512","Daly City/San Mateo County CoC",627447]
["(a) Applications submitted within a competitive funding round shall be evaluated using the following criteria. 100 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,"Points"]
["(a)(1) Priority Points. 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":"SUM(AK35:AL36)+MAX(AK37,AK38)","v":0}]
["(a)(1)(A) Population – Is the Applicant a county that has a population of 200,000 or less within the unincorporated areas of the county? 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(AI35=\"Yes\",5,0)","v":0}]
["(a)(1)(B ) Prior Award – Did the Applicant receive an award based on the formula specified in 42 USC, Section 5306 in 2016?",null,null,null,null,null,null,null,null,null,null,null,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(AI36=\"No\",5,0)","v":0}]
["(a)(1)(C)(1)  Assistance for Homeless Persons through Program Activities – Application will assist persons experiencing or At risk of homelessness, including but not limited to, through programs providing rapid rehousing, or rental assistance, or operating assistance to navigation centers? 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(AI37=\"Yes\",15,0)","v":0}]
["(a)(1)(C )(2) Assistance for Homeless Persons through Rental Projects –  Application is for the new construction, rehabilitation, or preservation of permanent or transitional rental housing in which all or at least 10% of the units are restricted to occupancy by tenants who are homeless or At risk of homelessness? 15 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(AI38=\"Yes\",15,0)","v":0}]
["(a)(2) Evaluation Critera. 75 Points Max."]
["(a)(2)(A) Community Need – Applicants will receive up to a maximum of 30 points based on the rate of households experiencing the most severe housing need according to the most recent HUD CHAS dataset in the Applicant Local government. Applicants will receive points in proportion to this percentage. "]
["(a)(2)(B ) Applicant Administrative Experience – Applicants with prior experience administering local, state or federal affordable housing or community development programs or who partner with an entity with prior experience in the implementation of local, state or federal affordable housing or community development programs will receive up to 15 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,"Yes"]
["(a)(2)(C) Demonstrated Capacity – 30 Points Max"]
["(i)(a) Sponsor experience in affordable housing development and ownership – 30 Points Max; OR"]
["(i)(b) Navigation center development experience (for development of these facilities)  – 30 Points Max; OR"]
["(i)(c) Program Operator experience (for non-development Activities)  – 30 Points Max"]
["Other Documents"]
["File Name:",null,null,"STD-204",null,null,null,null,null,null,"Applicants that are not a government agency must submit a Payee Data Record (STD-204)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and uploaded?"]
["File Name:",null,null,"Government TIN Form",null,null,null,null,null,null,"Applicants that are a government agency must submit a Government TIN Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and uploaded?"]
["File Name:",null,null,"Resolution",null,null,null,null,null,null,"Resolutions (Refer to Resolution Instructions and Sample Resolution on CESH Program website)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and uploaded?"]
["Certifications"]
["On behalf of the entity identified below, I certify that: The information, statements and attachments included in this application are, to the best of my knowledge and belief, true and correct and I possess the legal authority to submit this application on behalf of the entity identified in the signature block."]
["     "]
["Authorized Representative Printed Name ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
["Entity name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone Number:"]
["Entity 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"]

{"sheet":"302(c)(4) Plan","index":5,"n_rows":138,"n_cols":39,"rows_kept":138,"cut":false,"hidden":false,"merged":[[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],[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],[133,21,133,22],[133,23,133,24],[133,25,133,26],[133,27,133,28],[133,29,133,30],[133,31,133,32],[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],[134,21,134,22],[134,23,134,24],[134,25,134,26],[134,27,134,28],[134,29,134,30],[134,31,134,32],[134,33,134,34],[134,35,134,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],[131,21,131,22],[131,23,131,24],[131,25,131,26],[131,27,131,28],[131,29,131,30],[131,31,131,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],[132,21,132,22],[132,23,132,24],[132,25,132,26],[132,27,132,28],[132,29,132,30],[132,31,132,32],[132,33,132,34],[132,35,132,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],[129,21,129,22],[129,23,129,24],[129,25,129,26],[129,27,129,28],[129,29,129,30],[129,31,129,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],[130,21,130,22],[130,23,130,24],[130,25,130,26],[130,27,130,28],[130,29,130,30],[130,31,130,32],[130,33,130,34],[130,35,130,37],[122,0,122,37],[123,0,123,37],[124,0,124,25],[124,26,124,35],[124,36,124,37],[125,0,125,37],[126,0,126,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],[128,21,128,22],[128,23,128,24],[128,25,128,26],[128,27,128,28],[128,29,128,30],[128,31,128,32],[128,33,128,34],[128,35,128,37],[127,33,127,34],[127,35,127,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],[119,21,119,22],[119,23,119,24],[119,25,119,26],[119,27,119,28],[119,29,119,30],[119,31,119,32],[119,33,119,34],[119,35,119,37],[121,0,121,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],[120,21,120,22],[120,23,120,24],[120,25,120,26],[120,27,120,28],[120,29,120,30],[120,31,120,32],[120,33,120,34],[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],[117,21,117,22],[117,23,117,24],[117,25,117,26],[117,27,117,28],[117,29,117,30],[117,31,117,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],[118,21,118,22],[118,23,118,24],[118,25,118,26],[118,27,118,28],[118,29,118,30],[118,31,118,32],[118,33,118,34],[118,35,118,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],[115,21,115,22],[115,23,115,24],[115,25,115,26],[115,27,115,28],[115,29,115,30],[115,31,115,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],[116,21,116,22],[116,23,116,24],[116,25,116,26],[116,27,116,28],[116,29,116,30],[116,31,116,32],[116,33,116,34],[116,35,116,37],[109,0,109,37],[110,0,110,37],[111,0,111,25],[111,26,111,35],[111,36,111,37],[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],[114,21,114,22],[114,23,114,24],[114,25,114,26],[114,27,114,28],[114,29,114,30],[114,31,114,32],[114,33,114,34],[114,35,114,37],[106,27,106,28],[106,29,106,30],[106,31,106,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],[107,21,107,22],[107,23,107,24],[107,25,107,26],[107,27,107,28],[107,29,107,30],[107,31,107,32],[107,33,107,34],[107,35,107,37],[103,7,103,8],[103,9,103,10],[103,11,103,12],[103,13,103,14],[103,15,103,16],[103,17,103,18],[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],[106,21,106,22],[106,23,106,24],[106,25,106,26],[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],[105,21,105,22],[105,23,105,24],[105,25,105,26],[105,27,105,28],[105,29,105,30],[105,31,105,32],[105,33,105,34],[105,35,105,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],[94,21,94,22],[94,23,94,24],[94,25,94,26],[94,27,94,28],[94,29,94,30],[94,31,94,32],[94,33,94,34],[94,35,94,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,23,101,24],[101,25,101,26],[101,27,101,28],[101,29,101,30],[101,31,101,32],[101,33,101,34],[101,35,101,37],[100,0,100,37],[92,15,92,16],[92,17,92,18],[103,19,103,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],[103,33,103,34],[103,35,103,37],[102,23,102,24],[102,25,102,26],[102,27,102,28],[102,29,102,30],[102,31,102,32],[102,33,102,34],[102,35,102,37],[95,0,95,37],[98,0,98,25],[98,26,98,35],[98,36,98,37],[99,0,99,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],[101,21,101,22],[90,13,90,14],[90,15,90,16],[97,0,97,37],[96,0,96,37],[92,23,92,24],[92,25,92,26],[92,27,92,28],[92,29,92,30],[92,31,92,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],[93,21,93,22],[93,23,93,24],[93,25,93,26],[93,27,93,28],[93,29,93,30],[93,31,93,32],[93,33,93,34],[93,35,93,37],[92,0,92,6],[92,7,92,8],[92,9,92,10],[92,11,92,12],[92,13,92,14],[77,7,77,8],[77,9,77,10],[92,19,92,20],[92,21,92,22],[83,0,83,37],[86,0,86,25],[86,26,86,35],[86,36,86,37],[87,0,87,37],[88,0,88,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],[91,21,91,22],[91,23,91,24],[91,25,91,26],[91,27,91,28],[91,29,91,30],[91,31,91,32],[91,33,91,34],[91,35,91,37],[90,25,90,26],[90,27,90,28],[90,0,90,6],[90,7,90,8],[90,9,90,10],[90,11,90,12],[81,27,81,28],[81,29,81,30],[81,31,81,32],[81,33,81,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],[82,23,82,24],[82,25,82,26],[82,27,82,28],[82,29,82,30],[82,31,82,32],[82,33,82,34],[82,35,82,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],[81,23,81,24],[81,25,81,26],[69,33,69,34],[69,35,69,37],[73,0,73,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],[80,23,80,24],[80,25,80,26],[80,27,80,28],[80,29,80,30],[80,31,80,32],[80,33,80,34],[80,35,80,37],[79,11,79,12],[79,13,79,14],[79,15,79,16],[77,25,77,26],[77,27,77,28],[78,29,78,30],[78,31,78,32],[78,33,78,34],[78,35,78,37],[78,23,78,24],[78,25,78,26],[78,27,78,28],[77,0,77,6],[56,15,56,16],[56,17,56,18],[56,19,56,20],[56,21,56,22],[56,23,56,24],[56,25,56,26],[56,27,56,28],[56,29,56,30],[56,31,56,32],[56,33,56,34],[56,35,56,37],[61,0,61,37],[59,0,59,37],[58,0,58,37],[67,33,67,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],[68,23,68,24],[68,25,68,26],[68,27,68,28],[68,29,68,30],[68,31,68,32],[68,33,68,34],[68,35,68,37],[37,23,37,24],[37,25,37,26],[37,27,37,28],[37,29,37,30],[37,31,37,32],[37,33,37,34],[37,35,37,37],[43,23,43,24],[43,25,43,26],[43,27,43,28],[43,29,43,30],[43,31,43,32],[43,33,43,34],[43,35,43,37],[46,0,46,37],[47,0,47,25],[47,26,47,35],[47,36,47,37],[38,33,38,34],[38,35,38,37],[42,35,42,37],[40,0,40,6],[40,7,40,8],[21,0,21,25],[21,26,21,35],[21,36,21,37],[22,0,22,37],[24,0,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[24,13,24,14],[24,15,24,16],[24,17,24,18],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,26],[24,27,24,28],[24,29,24,30],[24,31,24,32],[24,33,24,34],[24,35,24,37],[52,31,52,32],[57,0,57,37],[53,29,53,30],[53,31,53,32],[38,13,38,14],[64,23,64,24],[64,25,64,26],[64,27,64,28],[64,29,64,30],[64,31,64,32],[64,33,64,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],[53,17,53,18],[53,19,53,20],[53,21,53,22],[38,23,38,24],[38,25,38,26],[38,27,38,28],[38,29,38,30],[53,7,53,8],[53,9,53,10],[53,11,53,12],[49,0,49,37],[52,21,52,22],[52,23,52,24],[52,25,52,26],[52,27,52,28],[52,0,52,6],[39,11,39,12],[39,13,39,14],[39,15,39,16],[39,17,39,18],[39,19,39,20],[39,21,39,22],[53,23,53,24],[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],[43,21,43,22],[41,27,41,28],[53,13,53,14],[53,15,53,16],[52,17,52,18],[52,19,52,20],[50,17,50,18],[50,19,50,20],[50,21,50,22],[48,0,48,37],[50,0,50,6],[50,7,50,8],[27,0,27,6],[27,7,27,8],[30,29,30,30],[51,17,51,18],[51,19,51,20],[51,21,51,22],[51,23,51,24],[51,25,51,26],[51,27,51,28],[51,29,51,30],[39,31,39,32],[39,33,39,34],[51,33,51,34],[44,0,44,37],[41,17,41,18],[41,19,41,20],[41,21,41,22],[41,23,41,24],[41,25,41,26],[34,0,34,25],[34,26,34,35],[34,36,34,37],[35,0,35,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],[37,21,37,22],[52,29,52,30],[54,27,54,28],[54,29,54,30],[53,25,53,26],[51,0,51,6],[39,23,39,24],[39,25,39,26],[39,27,39,28],[39,29,39,30],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[51,15,51,16],[39,0,39,6],[39,7,39,8],[45,0,45,37],[41,29,41,30],[41,31,41,32],[41,33,41,34],[41,35,41,37],[52,33,52,34],[52,35,52,37],[53,0,53,6],[53,27,53,28],[51,31,51,32],[52,7,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[52,15,52,16],[50,25,50,26],[89,9,89,10],[89,11,89,12],[89,13,89,14],[89,15,89,16],[89,17,89,18],[89,19,89,20],[89,21,89,22],[89,23,89,24],[89,25,89,26],[54,0,54,6],[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],[54,23,54,24],[54,25,54,26],[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],[55,23,55,24],[55,25,55,26],[89,0,89,6],[89,7,89,8],[90,29,90,30],[90,31,90,32],[90,33,90,34],[90,35,90,37],[90,17,90,18],[90,19,90,20],[90,21,90,22],[90,23,90,24],[89,27,89,28],[89,29,89,30],[89,31,89,32],[89,33,89,34],[89,35,89,37],[77,11,77,12],[77,13,77,14],[77,15,77,16],[85,0,85,37],[79,29,79,30],[79,31,79,32],[79,33,79,34],[79,35,79,37],[79,17,79,18],[79,19,79,20],[79,21,79,22],[79,23,79,24],[79,25,79,26],[79,27,79,28],[79,0,79,6],[79,7,79,8],[79,9,79,10],[84,0,84,37],[76,17,76,18],[76,19,76,20],[76,21,76,22],[78,17,78,18],[78,19,78,20],[78,21,78,22],[77,29,77,30],[77,31,77,32],[77,33,77,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],[77,17,77,18],[77,19,77,20],[77,21,77,22],[77,23,77,24],[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,29,76,30],[76,31,76,32],[76,33,76,34],[76,35,76,37],[76,23,76,24],[76,25,76,26],[76,27,76,28],[74,0,74,37],[75,0,75,37],[70,0,70,37],[66,29,66,30],[66,31,66,32],[66,33,66,34],[66,35,66,37],[66,17,66,18],[66,19,66,20],[66,21,66,22],[66,23,66,24],[66,25,66,26],[66,27,66,28],[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],[67,23,67,24],[67,25,67,26],[67,27,67,28],[67,29,67,30],[67,31,67,32],[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],[65,29,65,30],[65,31,65,32],[69,19,69,20],[69,21,69,22],[69,23,69,24],[69,25,69,26],[69,27,69,28],[69,29,69,30],[69,31,69,32],[65,33,65,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],[65,17,65,18],[65,19,65,20],[65,21,65,22],[65,23,65,24],[65,25,65,26],[65,27,65,28],[65,0,65,6],[65,7,65,8],[65,9,65,10],[65,11,65,12],[65,13,65,14],[65,15,65,16],[63,17,63,18],[63,19,63,20],[63,21,63,22],[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,29,63,30],[63,31,63,32],[63,33,63,34],[63,23,63,24],[63,25,63,26],[63,27,63,28],[62,0,62,37],[53,33,53,34],[53,35,53,37],[54,31,54,32],[54,33,54,34],[54,35,54,37],[60,0,60,37],[55,27,55,28],[55,29,55,30],[55,31,55,32],[55,33,55,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],[50,9,50,10],[50,11,50,12],[50,13,50,14],[50,15,50,16],[50,29,50,30],[50,31,50,32],[50,33,50,34],[50,35,50,37],[50,23,50,24],[50,27,50,28],[42,27,42,28],[38,21,38,22],[39,9,39,10],[41,13,41,14],[41,15,41,16],[40,17,40,18],[40,19,40,20],[40,21,40,22],[40,23,40,24],[40,25,40,26],[40,27,40,28],[40,11,40,12],[40,13,40,14],[40,15,40,16],[38,15,38,16],[38,17,38,18],[38,19,38,20],[38,31,38,32],[30,31,30,32],[30,33,30,34],[30,35,30,37],[32,0,32,37],[33,0,33,37],[30,17,30,18],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,26],[30,27,30,28],[30,0,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[30,13,30,14],[30,15,30,16],[31,0,31,37],[29,0,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[28,17,28,18],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,26],[28,27,28,28],[29,29,29,30],[29,31,29,32],[29,33,29,34],[29,35,29,37],[29,23,29,24],[29,25,29,26],[29,27,29,28],[28,0,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,14],[28,15,28,16],[29,17,29,18],[29,19,29,20],[29,21,29,22],[27,13,27,14],[27,15,27,16],[26,17,26,18],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,26],[26,27,26,28],[27,29,27,30],[27,31,27,32],[27,33,27,34],[27,35,27,37],[27,23,27,24],[27,25,27,26],[27,27,27,28],[28,29,28,30],[28,31,28,32],[28,33,28,34],[28,35,28,37],[26,0,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[26,13,26,14],[26,15,26,16],[26,29,26,30],[26,31,26,32],[26,33,26,34],[26,35,26,37],[27,17,27,18],[27,19,27,20],[27,21,27,22],[25,19,25,20],[25,21,25,22],[23,0,23,37],[25,0,25,6]],"merged_total":1191,"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:AL1","v":"Rev. 10/19/20"}]
["§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 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 2019-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 year 2019 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:AH17)","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 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,"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 2019-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)(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 year 2019 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(H28:AI28)","v":0}]
["§302(c)(4)(E)(i) Percentage of Funds Allocated for Each Affordable Housing Activity"]
["§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 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,"Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing"]
[]
["Complete the table below for each proposed Activity to be funded with 2019-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 year 2019 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 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,"Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing"]
[]
["Complete the table below for the proposed Activity to be funded with 2019-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 year 2019 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 description of how allocated funds will be used for the proposed Activity ."]
[]
["Complete the table below for each proposed Activity to be funded with 2019-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 year 2019 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 description of how allocated funds will be used for the proposed Activity."]
[]
["Complete the table below for each proposed Activity to be funded with 2019-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 year 2019 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 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,"Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing"]
[]
["Complete the table below for each proposed Activity to be funded with 2019-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 year 2019 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 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,"Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing (AOWH)"]
[]
["Complete the table below for each proposed Activity to be funded with 2019-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 year 2019 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 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,"Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing (AOWH)"]
[]
["Complete the table below for each proposed Activity to be funded with 2019-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 year 2019 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 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,"Percentage of Funds Allocated for Affordable Owner-occupied Workforce Housing (AOWH)"]
[]
["Complete the table below for each proposed Activity to be funded with 2019-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 year 2019 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?"]

{"sheet":"Legislative Contacts ","index":6,"n_rows":129,"n_cols":36,"rows_kept":129,"cut":false,"hidden":false,"merged":[[0,35,0,37],[0,0,0,34],[8,0,8,6],[8,7,8,14],[8,15,8,23],[8,24,8,37],[5,0,5,6],[5,7,5,14],[5,15,5,23],[5,24,5,37],[6,0,6,6],[6,7,6,14],[6,15,6,23],[6,24,6,37],[1,0,1,37],[2,0,2,37],[4,0,4,37],[7,0,7,6],[7,7,7,14],[7,15,7,23],[7,24,7,37],[3,0,3,11],[3,12,3,24],[3,25,3,37],[12,0,12,6],[12,7,12,14],[12,15,12,23],[12,24,12,37],[13,0,13,6],[13,7,13,14],[13,15,13,23],[13,24,13,37],[9,0,9,37],[10,0,10,6],[10,7,10,14],[10,15,10,23],[10,24,10,37],[11,0,11,6],[11,7,11,14],[11,15,11,23],[11,24,11,37],[17,0,17,6],[17,7,17,14],[17,15,17,23],[17,24,17,37],[18,0,18,6],[18,7,18,14],[18,15,18,23],[18,24,18,37],[14,0,14,37],[15,0,15,6],[15,7,15,14],[15,15,15,23],[15,24,15,37],[16,0,16,6],[16,7,16,14],[16,15,16,23],[16,24,16,37],[22,0,22,6],[22,7,22,14],[22,15,22,23],[22,24,22,37],[23,0,23,6],[23,7,23,14],[23,15,23,23],[23,24,23,37],[19,0,19,37],[20,0,20,6],[20,7,20,14],[20,15,20,23],[20,24,20,37],[21,0,21,6],[21,7,21,14],[21,15,21,23],[21,24,21,37],[27,0,27,6],[27,7,27,14],[27,15,27,23],[27,24,27,37],[28,0,28,6],[28,7,28,14],[28,15,28,23],[28,24,28,37],[24,0,24,37],[25,0,25,6],[25,7,25,14],[25,15,25,23],[25,24,25,37],[26,0,26,6],[26,7,26,14],[26,15,26,23],[26,24,26,37],[32,0,32,6],[32,7,32,14],[32,15,32,23],[32,24,32,37],[33,0,33,6],[33,7,33,14],[33,15,33,23],[33,24,33,37],[29,0,29,37],[30,0,30,6],[30,7,30,14],[30,15,30,23],[30,24,30,37],[31,0,31,6],[31,7,31,14],[31,15,31,23],[31,24,31,37],[37,0,37,6],[37,7,37,14],[37,15,37,23],[37,24,37,37],[38,0,38,6],[38,7,38,14],[38,15,38,23],[38,24,38,37],[34,0,34,37],[35,0,35,6],[35,7,35,14],[35,15,35,23],[35,24,35,37],[36,0,36,6],[36,7,36,14],[36,15,36,23],[36,24,36,37],[42,0,42,6],[42,7,42,14],[42,15,42,23],[42,24,42,37],[43,0,43,6],[43,7,43,14],[43,15,43,23],[43,24,43,37],[39,0,39,37],[40,0,40,6],[40,7,40,14],[40,15,40,23],[40,24,40,37],[41,0,41,6],[41,7,41,14],[41,15,41,23],[41,24,41,37],[47,0,47,6],[47,7,47,14],[47,15,47,23],[47,24,47,37],[48,0,48,6],[48,7,48,14],[48,15,48,23],[48,24,48,37],[44,0,44,37],[45,0,45,6],[45,7,45,14],[45,15,45,23],[45,24,45,37],[46,0,46,6],[46,7,46,14],[46,15,46,23],[46,24,46,37],[52,0,52,6],[52,7,52,14],[52,15,52,23],[52,24,52,37],[53,0,53,6],[53,7,53,14],[53,15,53,23],[53,24,53,37],[49,0,49,37],[50,0,50,6],[50,7,50,14],[50,15,50,23],[50,24,50,37],[51,0,51,6],[51,7,51,14],[51,15,51,23],[51,24,51,37],[57,0,57,6],[57,7,57,14],[57,15,57,23],[57,24,57,37],[58,0,58,6],[58,7,58,14],[58,15,58,23],[58,24,58,37],[54,0,54,37],[55,0,55,6],[55,7,55,14],[55,15,55,23],[55,24,55,37],[56,0,56,6],[56,7,56,14],[56,15,56,23],[56,24,56,37],[62,0,62,6],[62,7,62,14],[62,15,62,23],[62,24,62,37],[63,0,63,6],[63,7,63,14],[63,15,63,23],[63,24,63,37],[59,0,59,37],[60,0,60,6],[60,7,60,14],[60,15,60,23],[60,24,60,37],[61,0,61,6],[61,7,61,14],[61,15,61,23],[61,24,61,37],[67,0,67,6],[67,7,67,14],[67,15,67,23],[67,24,67,37],[68,0,68,6],[68,7,68,14],[68,15,68,23],[68,24,68,37],[64,0,64,37],[65,0,65,6],[65,7,65,14],[65,15,65,23],[65,24,65,37],[66,0,66,6],[66,7,66,14],[66,15,66,23],[66,24,66,37],[72,0,72,6],[72,7,72,14],[72,15,72,23],[72,24,72,37],[73,0,73,6],[73,7,73,14],[73,15,73,23],[73,24,73,37],[69,0,69,37],[70,0,70,6],[70,7,70,14],[70,15,70,23],[70,24,70,37],[71,0,71,6],[71,7,71,14],[71,15,71,23],[71,24,71,37],[77,0,77,6],[77,7,77,14],[77,15,77,23],[77,24,77,37],[78,0,78,6],[78,7,78,14],[78,15,78,23],[78,24,78,37],[74,0,74,37],[75,0,75,6],[75,7,75,14],[75,15,75,23],[75,24,75,37],[76,0,76,6],[76,7,76,14],[76,15,76,23],[76,24,76,37],[82,0,82,6],[82,7,82,14],[82,15,82,23],[82,24,82,37],[83,0,83,6],[83,7,83,14],[83,15,83,23],[83,24,83,37],[79,0,79,37],[80,0,80,6],[80,7,80,14],[80,15,80,23],[80,24,80,37],[81,0,81,6],[81,7,81,14],[81,15,81,23],[81,24,81,37],[84,0,84,37],[85,0,85,6],[85,7,85,14],[85,15,85,23],[85,24,85,37],[86,0,86,6],[86,7,86,14],[86,15,86,23],[86,24,86,37],[87,0,87,6],[87,7,87,14],[87,15,87,23],[87,24,87,37],[88,0,88,6],[88,7,88,14],[88,15,88,23],[88,24,88,37],[89,0,89,37],[90,0,90,6],[90,7,90,14],[90,15,90,23],[90,24,90,37],[91,0,91,6],[91,7,91,14],[91,15,91,23],[91,24,91,37],[92,0,92,6],[92,7,92,14],[92,15,92,23],[92,24,92,37],[93,0,93,6],[93,7,93,14],[93,15,93,23],[93,24,93,37],[94,0,94,37],[95,0,95,6],[95,7,95,14],[95,15,95,23],[95,24,95,37],[96,0,96,6],[96,7,96,14],[96,15,96,23],[96,24,96,37],[97,0,97,6],[97,7,97,14],[97,15,97,23],[97,24,97,37],[98,0,98,6],[98,7,98,14],[98,15,98,23],[98,24,98,37],[99,0,99,37],[100,0,100,6],[100,7,100,14],[100,15,100,23],[100,24,100,37],[101,0,101,6],[101,7,101,14],[101,15,101,23],[101,24,101,37],[102,0,102,6],[102,7,102,14],[102,15,102,23],[102,24,102,37],[103,0,103,6],[103,7,103,14],[103,15,103,23],[103,24,103,37],[104,0,104,37],[105,0,105,6],[105,7,105,14],[105,15,105,23],[105,24,105,37],[106,0,106,6],[106,7,106,14],[106,15,106,23],[106,24,106,37],[107,0,107,6],[107,7,107,14],[107,15,107,23],[107,24,107,37],[122,0,122,6],[122,7,122,14],[122,15,122,23],[122,24,122,37],[120,0,120,6],[108,7,108,14],[108,15,108,23],[108,24,108,37],[109,0,109,37],[110,0,110,6],[110,7,110,14],[110,15,110,23],[110,24,110,37],[108,0,108,6],[119,0,119,37],[114,0,114,37],[115,0,115,6],[115,7,115,14],[115,15,115,23],[115,24,115,37],[116,0,116,6],[116,7,116,14],[116,15,116,23],[116,24,116,37],[117,0,117,6],[117,7,117,14],[117,15,117,23],[128,0,128,6],[128,7,128,14],[128,15,128,23],[128,24,128,37],[123,0,123,6],[123,7,123,14],[123,15,123,23],[123,24,123,37],[124,0,124,37],[125,0,125,6],[125,7,125,14],[125,15,125,23],[125,24,125,37],[126,0,126,6],[126,7,126,14],[126,15,126,23],[126,24,126,37],[127,0,127,6],[127,7,127,14],[127,15,127,23],[127,24,127,37],[120,7,120,14],[120,15,120,23],[120,24,120,37],[121,0,121,6],[121,7,121,14],[121,15,121,23],[121,24,121,37],[111,0,111,6],[111,7,111,14],[111,15,111,23],[111,24,111,37],[112,0,112,6],[112,7,112,14],[112,15,112,23],[112,24,112,37],[113,0,113,6],[113,7,113,14],[113,15,113,23],[113,24,113,37],[117,24,117,37],[118,0,118,6],[118,7,118,14],[118,15,118,23],[118,24,118,37]]}
["Legislative and Congressional Information",null,null,null,null,null,null,null,null,null,null,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. 10/19/20"}]
["Provide the Legislative and Congressional information for the applicant and each activity location, (if different than applicant location), included in this application. "]
["To locate or verify the Legislative and Congressional information, click on the respective links below and enter the applicant office location zip code, the activity location site zip code(s) (i.e. zip code(s) where activities are performed), and any additional activity location site(s), as applicable."]
["California State Assembly",null,null,null,null,null,null,null,null,null,null,null,"California State Senate",null,null,null,null,null,null,null,null,null,null,null,null,"U.S. House of Representatives"]
["Applicant Office Location"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 1 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 2 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 3 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 4 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 5 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 6 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 7 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 8 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 9 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 10 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 11 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 12 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 13 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 14 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 15 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 16 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 17 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 18 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 20 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 21 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 22 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 23 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 24 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]
["Activity Location 25 (if different from applicant location)"]
[null,null,null,null,null,null,null,"District #",null,null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,"Last Name"]
["State Assembly Member"]
["State Senate Member"]
["U.S. House of Representatives"]

{"sheet":"Appplication Support","index":7,"n_rows":31,"n_cols":42,"rows_kept":31,"cut":false,"hidden":false,"merged":[[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],[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,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],[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,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],[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,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],[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,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],[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,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],[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,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],[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) 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. 10/19/20"}]
["Please complete the \"yellow\" cells in the form below and email a copy to: AppSupport@hcd.ca.gov. and 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:"]
["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,"","",{"$f":"IF(C8=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C8=\"\",\"\",$AI$3)","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(C9=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C9=\"\",\"\",$AI$3)","v":""}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(C10=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C10=\"\",\"\",$AI$3)","v":""}]
[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,"","",{"$f":"IF(C11=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C11=\"\",\"\",$AI$3)","v":""}]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"Formula","index":8,"n_rows":366,"n_cols":13,"rows_kept":366,"cut":false,"hidden":true,"merged":[[8,2,8,9],[9,2,9,9],[10,2,10,9],[11,2,11,9],[201,2,201,11],[7,2,7,9],[0,2,0,11],[1,2,1,10],[4,2,4,10],[5,2,5,10],[6,2,6,11]]}
[null,null,"Appendix A - Preliminary PLHA Allocations - CA"]
[null,null,"Estimated Building Homes and Jobs Trust Fund (BHJTF) \nSubject to Change Based on 2019-20 Budget Act",null,null,null,null,null,null,null,null,316386439.50999999]
[null,null,null,null,null,null,null,null,null,null,"30 % for Special Programs",{"$f":"L2*0.3","v":94915931.853}]
[null,null,null,null,null,null,null,null,null,null,"PLHA",{"$f":"L2*0.7","v":221470507.65699998}]
[null,null,"5% State Admin.",null,null,null,null,null,null,null,null,{"$f":"L4*0.05","v":11073525.382849999}]
[null,null,"PLHA NOFA Amount",null,null,null,null,null,null,null,null,{"$f":"L4-L5","v":210396982.27414998}]
[null,null,"PHLA Program Subcomponents"]
[null,null,"Subcomponent",null,null,null,null,null,null,null,"Estimated Funding Amount","Estimated % of PHLA Funds"]
[null,null,"90% for Formula Allocation to Entitlement Jurisdictions and Competitive Non-Entitlement  ",null,null,null,null,null,null,null,{"$f":"L6*0.9","v":189357284.04673499},0.9]
[null,null,"Competitive Non-Entitlement Allocation",null,null,null,null,null,null,null,{"$f":"K201","v":14585061.670668911},{"$f":"K10/$K$9","v":7.7024032870418618E-2}]
[null,null,"Formula Entitlement Allocation ",null,null,null,null,null,null,"Entitlement Subtotal",{"$f":"K9-K10","v":174772222.37606609},{"$f":"K11/$K$9","v":0.92297596712958141}]
[null,null,"10% for Formula Allocation to Non-Entitlement Jurisdictions",null,null,null,null,null,null,null,{"$f":"L6*0.1","v":21039698.227414999},{"$f":"K12/$L$6","v":0.1}]
[null,null,"LOCAL GOVERNMENT","STATE","2017 CDBG Allocation",null,null,null,null,"Percentage of Total 2017 CA CDBG Allocations","Estimated Allocation From SB 2 Formula Allocation","Allowable Local Admin (5%)"]
[null,null,"Alameda","CA",1053123,null,null,null,null,{"$f":"E14/SUM($E$14:$E$201)","v":2.9508503770966183E-3},{"$f":"J14*$K$9","v":558765.01303529937},{"$f":"K14*0.05","v":27938.250651764971},{"$f":"ROUNDDOWN(K14,0)","v":558765}]
[null,null,"Alhambra","CA",877586,null,null,null,null,2.458995747918062E-3,{"$f":"J15*$K$9","v":465628.75630823401},23281.4378154117,{"$f":"ROUNDDOWN(K15,0)","v":465628}]
[null,null,"Aliso Viejo","CA",224618,null,null,null,null,6.2937957864626286E-4,119177.60764693478,5958.8803823467388,119177]
[null,null,"Anaheim","CA",4062139,null,null,null,null,1.1382112440777459E-2,2155285.8985001734,107764.29492500867,2155285]
[null,null,"Antioch","CA",743029,null,null,null,null,2.0819670682757129E-3,394235.62952343229,19711.781476171614,394235]
[null,null,"Apple Valley","CA",541977,null,null,null,null,1.5186194156121308E-3,287561.64804095292,14378.082402047647,287561]
[null,null,"Bakersfield","CA",3262290,null,null,null,null,9.1409357470101094E-3,1730902.7666995469,86545.138334977353,1730902]
[null,null,"Baldwin Park","CA",920087,null,null,null,null,2.5780835390658988E-3,488178.89700311318,24408.944850155662,488178]
[null,null,"Bellflower","CA",968046,null,null,null,null,2.7124646448200953E-3,513624.93821592489,25681.246910796246,513624]
[null,null,"Berkeley","CA",2438062,null,null,null,null,6.8314491014676692E-3,1293584.647957426,64679.232397871303,1293584]
[null,null,"Buena Park","CA",695924,null,null,null,null,1.9499788703034567E-3,369242.70282918308,18462.135141459155,369242]
[null,null,"Burbank","CA",899361,null,null,null,null,2.520009292358055E-3,477182.11537345586,23859.105768672795,477182]
[null,null,"Camarillo","CA",255107,null,null,null,null,7.1480974886123187E-4,135354.4326544916,6767.7216327245806,135354]
[null,null,"Carlsbad","CA",513746,null,null,null,null,1.4395161608206062E-3,272582.87055437296,13629.143527718648,272582]
[null,null,"Carson","CA",781656,null,null,null,null,2.1901999124127329E-3,414730.30693387194,20736.515346693599,414730]
[null,null,"Cathedral City","CA",533801,null,null,null,null,1.4957102656997824E-3,283223.63363373117,14161.181681686559,283223]
[null,null,"Cerritos","CA",205838,null,null,null,null,5.7675802344152945E-4,109213.33287105113,5460.6666435525567,109213]
[null,null,"Chico","CA",735702,null,null,null,null,2.0614368161465816E-3,390348.07673946524,19517.403836973263,390348]
[null,null,"Chino","CA",469987,null,null,null,null,1.316903453993986E-3,249365.26140006562,12468.263070003282,249365]
[null,null,"Chino Hills","CA",334136,null,null,null,null,9.3624898668204541E-4,177285.56530961988,8864.2782654809944,177285]
[null,null,"Chula Vista","CA",1996844,null,null,null,null,5.595156378127835E-3,1059483.6155790535,52974.180778952679,1059483]
[null,null,"Citrus Heights","CA",589469,null,null,null,null,1.6516919874855706E-3,312759.90883202147,15637.995441601073,312759]
[null,null,"Clovis City","CA",689077,null,null,null,null,1.9307935780517628E-3,365609.82799475943,18280.491399737974,365609]
[null,null,"Compton","CA",1450717,null,null,null,null,4.0649086635753612E-3,769720.06443267362,38486.003221633684,769720]
[null,null,"Concord","CA",921231,null,null,null,null,2.5812890267737907E-3,488785.8794495248,24439.29397247624,488785]
[null,null,"Corona","CA",1096921,null,null,null,null,3.0735723619132807E-3,582003.3147730073,29100.165738650365,582003]
[null,null,"Costa Mesa","CA",996235,null,null,null,null,2.7914502156223438E-3,528581.43138191977,26429.071569095991,528581]
[null,null,"Cupertino City","CA",311943,null,null,null,null,8.7406420634878401E-4,165510.42419667068,8275.5212098335342,165510]
[null,null,"Daly City","CA",964647,null,null,null,null,2.7029406476879927E-3,511821.49998572108,25591.074999286055,511821]
[null,null,"Davis","CA",570931,null,null,null,null,1.5997485162190452E-3,302924.03418903257,15146.201709451629,302924]
[null,null,"Delano City","CA",612773,null,null,null,null,1.7169897895351505E-3,325124.52328235121,16256.226164117561,325124]
[null,null,"Downey","CA",980589,null,null,null,null,2.7476101276173782E-3,520279.99138492963,26013.999569246484,520279]
[null,null,"El Cajon","CA",1216373,null,null,null,null,{"$f":"E46/SUM($E$14:$E$201)","v":3.4082768354125256E-3},645382.0448331167,32269.102241655837,645382]
[null,null,"El Centro","CA",463642,null,null,null,null,1.2991247656141118E-3,245998.73725453939,12299.936862726971,245998]
[null,null,"Elk Grove","CA",828882,null,null,null,null,2.3225271523540929E-3,439787.43369456852,21989.371684728427,439787]
[null,null,"El Monte","CA",1596920,null,null,null,null,4.4745694322440325E-3,847292.31496827095,42364.615748413547,847292]
[null,null,"Encinitas","CA",294102,null,null,null,null,8.2407372890428723E-4,156044.3631595812,7802.2181579790604,156044]
[null,null,"Escondido","CA",1588664,null,null,null,null,4.4514361223521115E-3,842911.85423612536,42145.592711806268,842911]
[null,null,"Fairfield","CA",736762,null,null,null,null,2.0644069358759223E-3,390910.49054470682,19545.524527235342,390910]
[null,null,"Fontana","CA",1849155,null,null,null,null,5.1813318378385979E-3,981122.92455799482,49056.146227899742,981122]
[null,null,"Fountain Valley","CA",272549,null,null,null,null,7.6368222840760892E-4,144608.79264602315,7230.4396323011579,144608]
[null,null,"Fremont","CA",1208416,null,null,null,null,3.3859813234442581E-3,641160.22724037408,32058.011362018704,641160]
[null,null,"Fresno","CA",6422423,null,null,null,null,1.7995627606104885E-2,3407603.1682084682,170380.15841042344,3407603]
[null,null,"Fullerton","CA",1297550,null,null,null,null,3.6357347686848708E-3,688452.86131245142,34422.643065622571,688452]
[null,null,"Gardena","CA",621732,null,null,null,null,1.7420929052475683E-3,329877.98109476559,16493.899054738282,329877]
[null,null,"Garden Grove","CA",1874072,null,null,null,null,5.2511492654763155E-3,994343.36303460249,49717.168151730126,994343]
[null,null,"Gilroy City","CA",460364,null,null,null,null,1.2899398104511133E-3,244259.49909078295,12212.974954539148,244259]
[null,null,"Glendale","CA",1634112,null,null,null,null,4.5787814067474644E-3,867025.61142538837,43351.280571269424,867025]
[null,null,"Glendora City","CA",245502,null,null,null,null,6.8789654131376303E-4,130258.22076831679,6512.9110384158403,130258]
[null,null,"Goleta","CA",177194,null,null,null,null,4.9649754275545997E-4,94015.426232051585,4700.7713116025798,94015]
[null,null,"Hanford","CA",556879,null,null,null,null,1.5603748158070688E-3,295468.33721615095,14773.416860807549,295468]
[null,null,"Hawthorne","CA",1155001,null,null,null,null,3.2363125070831913E-3,612819.34666775283,30640.967333387642,612819]
[null,null,"Hayward","CA",1228347,null,null,null,null,3.4418279803550963E-3,651735.19851610018,32586.75992580501,651735]
[null,null,"Hemet","CA",758673,null,null,null,null,2.1258015522811892E-3,402536.0083622993,20126.800418114966,402536]
[null,null,"Hesperia","CA",953256,null,null,null,null,2.6710230685965592E-3,505777.67389562039,25288.88369478102,505777]
[null,null,"Huntington Beach","CA",1033767,null,null,null,null,2.8966148700389602E-3,548495.12471996376,27424.756235998189,548495]
[null,null,"Huntington Park","CA",1228240,null,null,null,null,3.4415281663824175E-3,651678.42655651446,32583.921327825723,651678]
[null,null,"Indio City","CA",859367,null,null,null,null,2.4079461145700832E-3,455962.13638587913,22798.106819293957,455962]
[null,null,"Inglewood","CA",1386743,null,null,null,null,3.8856535319104187E-3,735776.79954916018,36788.83997745801,735776]
[null,null,"Irvine","CA",1428585,null,null,null,null,4.0028948052265242E-3,757977.28864247887,37898.864432123948,757977]
[null,null,"Laguna Niguel","CA",289146,null,null,null,null,8.1018701816974736E-4,153414.81333054608,7670.7406665273047,153414]
[null,null,"La Habra","CA",732911,null,null,null,null,2.0536164348592327E-3,388867.23057868297,19443.361528934151,388867]
[null,null,"Lake Forest","CA",416658,null,null,null,null,1.1674756096109599E-3,221070.01062673761,11053.500531336882,221070]
[null,null,"Lake Elsinore","CA",468408,null,null,null,null,1.3124790963971662E-3,248527.47706188026,12426.373853094014,248527]
[null,null,"Lakewood","CA",510476,null,null,null,null,{"$f":"E78/SUM($E$14:$E$201)","v":1.4303536216555648E-3},270847.87702310889,{"$f":"K78*0.05","v":13542.393851155444},270847]
[null,null,"La Mesa","CA",355856,null,null,null,null,9.9710842113608219E-4,{"$f":"J79*$K$9","v":188809.74252645657},9440.4871263228288,{"$f":"ROUNDDOWN(K79,0)","v":188809}]
[null,null,"Lancaster","CA",1309617,null,null,null,null,3.6695464996036953E-3,694855.35884815909,34742.767942407954,694855]
[null,null,"Livermore","CA",393044,null,null,null,null,1.1013091876405352E-3,208540.91666732778,10427.04583336639,208540]
[null,null,"Lodi","CA",633771,null,null,null,null,1.775826180173542E-3,336265.62241674977,16813.281120837488,336265]
[null,null,"Lompoc","CA",427887,null,null,null,null,1.1989392647437582E-3,227027.88290886741,11351.394145443372,227027]
[null,null,"Long Beach","CA",5516208,null,null,null,null,1.5456413407496924E-2,2926784.4639471578,146339.2231973579,2926784]
[null,null,"Los Angeles","CA",49416902,null,null,null,null,0.1384661467859373,26219573.48780163,1310978.6743900815,26219573]
[null,null,"Lynwood","CA",1189997,null,null,null,null,3.3343712901473472E-3,631387.49150570948,31569.374575285474,631387]
[null,null,"Madera","CA",795959,null,null,null,null,2.230276914760619E-3,422319.17925120232,21115.958962560118,422319]
[null,null,"Menifee","CA",474207,null,null,null,null,1.3287278929164552E-3,251604.30503980088,12580.215251990045,251604]
[null,null,"Merced","CA",977648,null,null,null,null,2.7393694463683301E-3,518719.55836491502,25935.977918245753,518719]
[null,null,"Milpitas City","CA",449688,null,null,null,null,1.2600256611771125E-3,238595.03702968956,11929.751851484478,238595]
[null,null,"Mission Viejo","CA",389544,null,null,null,null,1.0915021885342217E-3,206683.88995190751,10334.194497595376,206683]
[null,null,"Modesto","CA",1827715,null,null,null,null,5.1212569633130658E-3,969747.30947839166,48487.365473919584,969747]
[null,null,"Montebello","CA",597005,null,null,null,null,1.6728078575613359E-3,316758.35263985209,15837.917631992605,316758]
[null,null,"Monterey","CA",219420,null,null,null,null,6.14814783973515E-4,116419.65768500489,5820.9828842502448,116419]
[null,null,"Monterey Park","CA",600988,null,null,null,null,1.6839682225443205E-3,318871.64904200035,15943.582452100018,318871]
[null,null,"Moreno Valley","CA",1940916,null,null,null,null,5.4384461364084353E-3,1029809.3898247605,51490.469491238029,1029809]
[null,null,"Mountain View","CA",483532,null,null,null,null,1.3548565405354191E-3,256551.95478874209,12827.597739437106,256551]
[null,null,"Napa City","CA",599742,null,null,null,null,1.680476930862473E-3,318210.54753131076,15910.527376565538,318210]
[null,null,"National City","CA",741061,null,null,null,null,2.0764527327782199E-3,393191.44993030449,19659.572496515226,393191]
[null,null,"Newport Beach","CA",319676,null,null,null,null,8.9573207037424744E-4,169613.39207962638,8480.6696039813196,169613]
[null,null,"Norwalk","CA",1117199,null,null,null,null,3.1303913127355165E-3,592762.39698309079,29638.11984915454,592762]
[null,null,"Oakland","CA",6981948,null,null,null,null,1.9563416513236329E-2,3704475.4176214775,185223.7708810739,3704475]
[null,null,"Oceanside","CA",1223477,null,null,null,null,3.4281822415985971E-3,649151.27848635823,32457.563924317914,649151]
[null,null,"Ontario","CA",1733990,null,null,null,null,4.8586395372447145E-3,920018.78693474445,46000.939346737228,920018]
[null,null,"Orange","CA",1144944,null,null,null,null,3.2081327956511355E-3,607483.31304575806,30374.165652287906,607483]
[null,null,"Oxnard","CA",2183330,null,null,null,null,6.1176901025106851E-3,1158429.1824510151,57921.459122550761,1158429]
[null,null,"Palmdale","CA",1468328,null,null,null,null,4.1142546810785862E-3,779064.09228560689,38953.204614280345,779064]
[null,null,"Palm Desert","CA",322867,null,null,null,null,9.046732515594607E-4,171306.46986502814,8565.3234932514079,171306]
[null,null,"Palm Springs","CA",362316,null,null,null,null,1.0152093394865923E-3,192237.28326406085,9611.8641632030431,192237]
[null,null,"Palo Alto","CA",436309,null,null,null,null,1.2225377065932931E-3,231496.41976523015,11574.820988261508,231496]
[null,null,"Paradise","CA",176404,null,null,null,null,4.9428396295717774E-4,93596.268773428135,4679.8134386714073,93596]
[null,null,"Paramount City","CA",825885,null,null,null,null,2.314129559119344E-3,438197.28824710724,21909.864412355364,438197]
[null,null,"Pasadena","CA",1764254,null,null,null,null,4.9434392575171352E-3,936076.23165345285,46803.811582672643,936076]
[null,null,"Perris City","CA",879290,null,null,null,null,2.4637703554829644E-3,466532.86302911292,23326.643151455646,466532]
[null,null,"Petaluma","CA",347465,null,null,null,null,9.7359684127863179E-4,184357.65362100184,9217.8826810500923,184357]
[null,null,"Pico Rivera","CA",638875,null,null,null,null,1.7901275868702916E-3,338973.69794689404,16948.684897344701,338973]
[null,null,"Pittsburg","CA",598748,null,null,null,null,1.6776917431162799E-3,317683.15194413136,15884.157597206569,317683]
[null,null,"Placentia","CA",404792,null,null,null,null,1.1342270806408124E-3,214774.1594824013,10738.707974120065,214774]
[null,null,"Pleasanton City","CA",284763,null,null,null,null,7.9790585328889821E-4,151089.28530377836,7554.4642651889189,151089]
[null,null,"Pomona","CA",2013735,null,null,null,null,5.6424849558149043E-3,1068445.6265076718,53422.281325383592,1068445]
[null,null,"Porterville","CA",646000,null,null,null,null,1.8100918350510012E-3,342754.07376042823,17137.703688021411,342754]
[null,null,"Rancho Cordova City","CA",537840,null,null,null,null,1.5070275426684683E-3,285366.64246332616,14268.332123166309,285366]
[null,null,"Rancho Cucamonga","CA",849028,null,null,null,null,2.3789762392100334E-3,450476.47946852766,22523.823973426384,450476]
[null,null,"Rancho Santa Margarita","CA",191106,null,null,null,null,5.354789632031837E-4,101396.84213631641,5069.8421068158204,101396]
[null,null,"Redding","CA",634805,null,null,null,null,1.7787234479095214E-3,336814.24116639106,16840.712058319554,336814]
[null,null,"Redondo Beach","CA",246581,null,null,null,null,6.9091989903825217E-4,130830.71557572778,6541.5357787863895,130830]
[null,null,"Redwood City","CA",655358,null,null,null,null,1.8363129486615387E-3,347719.23261840048,17385.961630920025,347719]
[null,null,"Rialto","CA",1126668,null,null,null,null,3.1569234483177114E-3,597786.45011689502,29889.322505844753,597786]
[null,null,"Riverside","CA",3057274,null,null,null,null,8.566480967358691E-3,1622125.5698170888,81106.278490854442,1622125]
[null,null,"Rocklin City","CA",253758,null,null,null,null,7.1102985120568413E-4,134638.68150046244,6731.9340750231222,134638]
[null,null,"Rosemead","CA",646913,null,null,null,null,1.8126500608178766E-3,343238.49244362209,17161.924622181104,343238]
[null,null,"Roseville","CA",590613,null,null,null,null,1.6548974751934627E-3,313366.89127843309,15668.344563921655,313366]
[null,null,"Sacramento","CA",4442443,null,null,null,null,1.2447724151671015E-2,2357067.2379233716,117853.36189616859,2357067]
[null,null,"Salinas","CA",1897639,null,null,null,null,5.3171839934587411E-3,1006847.5197781195,50342.37598890598,1006847]
[null,null,"San Bernardino","CA",3057089,null,null,null,null,8.5659625974059284E-3,1622027.4126907021,81101.370634535109,1622027]
[null,null,"San Clemente","CA",356291,null,null,null,null,9.9832729102500967E-4,189040.54441823022,9452.0272209115119,189040]
[null,null,"San Diego","CA",10912952,null,null,null,null,3.0578088717497669E-2,5790183.8308854681,289509.1915442734,5790183]
[null,null,"San Francisco","CA",16431172,null,null,null,null,4.6040139748480854E-2,8718035.8199044634,435901.79099522321,8718035]
[null,null,"San Jose","CA",8196038,null,null,null,null,2.2965296383231793E-2,4348646.1504570786,217432.30752285395,4348646]
[null,null,"San Leandro","CA",659582,null,null,null,null,1.8481485955829868E-3,349960.39857438195,17498.019928719099,349960]
[null,null,"San Marcos City","CA",601567,null,null,null,null,1.6855905803964794E-3,319178.85431863705,15958.942715931853,319178]
[null,null,"San Mateo","CA",644380,null,null,null,null,{"$f":"E142/SUM($E$14:$E$201)","v":1.8055525954646504E-3},341894.53568071942,{"$f":"K142*0.05","v":17094.726784035971},341894]
[null,null,"Santa Ana","CA",5284239,null,null,null,null,1.4806436328727659E-2,{"$f":"J143*$K$9","v":2803706.5696187792},140185.32848093897,{"$f":"ROUNDDOWN(K143,0)","v":2803706}]
[null,null,"Santa Barbara","CA",853991,null,null,null,null,2.3928825639427855E-3,453109.74335099355,22655.48716754968,453109]
[null,null,"Santa Clara","CA",903714,null,null,null,null,2.5322063972465642E-3,479491.72602837713,23974.586301418858,479491]
[null,null,"Santa Clarita","CA",1108713,null,null,null,null,3.1066135429023232E-3,588259.90306678892,29412.995153339449,588259]
[null,null,"Santa Cruz","CA",498973,null,null,null,null,1.3981222185927295E-3,264744.62607811479,13237.231303905741,264744]
[null,null,"Santa Maria","CA",1382399,null,null,null,null,3.8734816450196113E-3,733471.96410579281,36673.598205289643,733471]
[null,null,"Santa Monica","CA",1031923,null,null,null,null,2.8914479825098054E-3,547516.736930468,27375.836846523402,547516]
[null,null,"Santa Rosa","CA",1308618,null,null,null,null,3.666747301858779E-3,694325.31036567199,34716.265518283602,694325]
[null,null,"Santee","CA",253260,null,null,null,null,7.0963445533284294E-4,134374.45312781123,6718.7226563905615,134374]
[null,null,"Seaside","CA",363989,null,null,null,null,1.0198970850594101E-3,193124.94203403176,9656.2471017015887,193124]
[null,null,"Simi Valley","CA",547246,null,null,null,null,1.5333831522667495E-3,290357.26911625278,14517.86345581264,290357]
[null,null,"South Gate","CA",1359496,null,null,null,null,3.8093074448676406E-3,721320.11185914406,36066.005592957204,721320]
[null,null,"South San Francisco","CA",410836,null,null,null,null,1.1511623670975436E-3,217980.97933040137,10899.048966520069,217980]
[null,null,"Stockton","CA",3225590,null,null,null,null,9.0381023563810507E-3,1711430.5151407113,85571.525757035575,1711430]
[null,null,"Sunnyvale","CA",1004607,null,null,null,null,2.8149085574846458E-3,533023.4392852051,26651.171964260255,533023]
[null,null,"Temecula","CA",515274,null,null,null,null,1.4437976164304483E-3,273393.59536041931,13669.679768020966,273393]
[null,null,"Thousand Oaks","CA",557958,null,null,null,null,1.5633981735315582E-3,296040.83202356193,14802.041601178098,296040]
[null,null,"Torrance","CA",837528,null,null,null,null,2.3467532421464318E-3,444374.82026071817,22218.741013035909,444374]
[null,null,"Tulare","CA",600163,null,null,null,null,1.6816565727549753E-3,318433.9213162227,15921.696065811135,318433]
[null,null,"Turlock","CA",583994,null,null,null,null,1.6363510388835516E-3,309854.98847004259,15492.74942350213,309854]
[null,null,"Tustin","CA",726651,null,null,null,null,2.036075916457655E-3,385545.80565338844,19277.290282669423,385545]
[null,null,"Union City","CA",478601,null,null,null,null,1.3410398797944958E-3,253935.66943624569,12696.783471812285,253935]
[null,null,"Upland","CA",523649,null,null,null,null,1.4672643642919842E-3,277837.1950008893,13891.859750044467,277837]
[null,null,"Vacaville","CA",453279,null,null,null,null,1.2700876422601902E-3,240500.34643971076,12025.017321985539,240500]
[null,null,"Vallejo","CA",952486,null,null,null,null,2.6688655287931701E-3,505369.12801822787,25268.456400911396,505369]
[null,null,"San Buenaventura","CA",673678,null,null,null,null,1.8876455839837282E-3,357439.44102597178,17871.972051298591,357439]
[null,null,"Victorville","CA",1192603,null,null,null,null,3.3416733014819339E-3,632770.18054010521,31638.509027005261,632770]
[null,null,"Visalia","CA",1188919,null,null,null,null,3.3313507344226024E-3,630815.52727735997,31540.776363868001,630815]
[null,null,"Vista","CA",770635,null,null,null,null,2.1593190732268242E-3,408882.79509654432,20444.139754827218,408882]
[null,null,"Walnut Creek","CA",260940,null,null,null,null,7.311538133718394E-4,138449.30032050484,6922.4650160252422,138449]
[null,null,"Watsonville","CA",683245,null,null,null,null,1.9144523155408999E-3,362515.49090780772,18125.774545390388,362515]
[null,null,"West Covina","CA",732715,null,null,null,null,2.0530672429092791E-3,388763.23708261939,19438.161854130969,388763]
[null,null,"Westminster","CA",962303,null,null,null,null,2.6963727602865072E-3,510577.82266545104,25528.891133272555,510577]
[null,null,"West Sacramento","CA",446077,null,null,null,null,1.2499076400991416E-3,236679.11603843738,11833.955801921869,236679]
[null,null,"Whittier","CA",722211,null,null,null,null,2.0236350375913603E-3,383190.03462011245,19159.501731005625,383190]
[null,null,"Woodland","CA",469279,null,null,null,null,1.314919638174766E-3,248989.61142448915,12449.480571224458,248989]
[null,null,"Yorba Linda","CA",200780,null,null,null,null,5.625855087330341E-4,106529.66397773805,5326.4831988869028,106529]
[null,null,"Yuba City","CA",586416,null,null,null,null,1.6431374822651207E-3,311140.05095711345,15557.002547855673,311140]
[null,null,"Alameda County","CA",1760088,null,null,null,null,4.9317661265808775E-3,933865.83928304119,46693.291964152064,933865]
[null,null,"Contra Costa County","CA",4090208,null,null,null,null,1.1460761771610348E-2,2170178.7221787823,108508.93610893912,2170178]
[null,null,"Fresno County","CA",3097273,null,null,null,null,8.6785581551453873E-3,1643348.2016999735,82167.410084998686,1643348]
[null,null,"Kern County","CA",4071674,null,null,null,null,1.1408829508342802E-2,2160344.9698520401,108017.24849260201,2160344]
[null,null,"Los Angeles County","CA",20779423,null,null,null,null,5.8223937940202759E-2,11025126.754862444,551256.33774312225,11025126]
[null,null,"Marin County","CA",1367509,null,null,null,null,3.8317598688216094E-3,725571.64187933353,36278.582093966681,725571]
[null,null,"Monterey County","CA",1222025,null,null,null,null,3.4241137379693496E-3,648380.87768898963,32419.043884449482,648380]
[null,null,"Orange County","CA",2397690,null,null,null,null,6.7183267677762152E-3,1272164.1100845837,63608.20550422919,1272164]
[null,null,"Riverside County","CA",7531717,null,null,null,null,2.1103869110858858E-2,3996171.3377100173,199808.56688550088,3996171]
[null,null,"Sacramento County","CA",5128032,null,null,null,null,1.4368744354613399E-2,2720826.4061514493,136041.32030757246,2720826]
[null,null,"San Bernardino County","CA",6519559,null,null,null,null,1.8267802653302277E-2,{"$f":"J191*$K$9","v":3459141.4959310582},172957.07479655292,3459141]
[null,null,"San Diego County","CA",3731709,null,null,null,null,1.0456247665149129E-2,1979966.6591926531,98998.332959632666,1979966]
[null,null,"San Joaquin County","CA",2469366,null,null,null,null,6.9191629014745369E-3,1310193.894900145,65509.694745007255,1310193]
[null,null,"San Luis Obispo County","CA",1644434,null,null,null,null,4.6077036481118544E-3,872502.24849869346,43625.112424934676,872502]
[null,null,"San Mateo County","CA",2279680,null,null,null,null,6.3876627779087718E-3,1209550.4750312276,60477.523751561384,1209550]
[null,null,"Santa Barbara County","CA",1073897,null,null,null,null,3.0090591197922058E-3,569787.26245991106,28489.363122995554,569787]
[null,null,"Santa Clara County","CA",1388546,null,null,null,null,3.8907055374500427E-3,736733.43359713245,36836.671679856627,736733]
[null,null,"Sonoma County","CA",1695117,null,null,null,null,4.7497174011705079E-3,899393.58707516384,44969.679353758198,899393]
[null,null,"Stanislaus County","CA",2176833,null,null,null,null,6.0994855101696227E-3,1154982.0102881335,57749.10051440668,1154982]
[null,null,"Ventura County","CA",1620399,null,null,null,null,4.540357584248928E-3,859749.78075437178,42987.489037718595,859749]
[null,null,"California Nonentitlement","CA",27488950.710000001,null,null,null,null,7.7024032870418618E-2,14585061.670668911,729253.08353344561,14585061]
[null,null,"California Nonentitlement Areas Based on 2017 Federal CDBG Formula "]
[null,null,"Alpine County","CA","N/A",{"$f":"($K$12)*0.5/163","v":64538.951617837418},80,{"$f":"G203/$G$366","v":3.3521613060020448E-4},{"$f":"$K$12*0.5*H203","v":3526.4231143950183},"N/A",{"$f":"I203+F203","v":68065.374732232434},{"$f":"K203*0.05","v":3403.268736611622},68065]
[null,null,"Alturas","CA","N/A",{"$f":"($K$12)*0.5/163","v":64538.951617837418},335,{"$f":"G204/$G$366","v":1.4037175468883563E-3},14766.89679152914,"N/A",79305.848409366561,3965.2924204683281,79305]
[null,null,"Amador City","CA","N/A",{"$f":"($K$12)*0.5/163","v":64538.951617837418},30,1.2570604897507669E-4,1322.4086678981321,"N/A",65861.360285735544,3293.0680142867773,65861]
[null,null,"Amador County","CA","N/A",64538.951617837418,1580,6.6205185793540384E-3,69646.856509301622,"N/A",134185.80812713905,6709.2904063569531,134185]
[null,null,"American Canyon","CA","N/A",64538.951617837418,1200,5.0282419590030672E-3,52896.346715925276,"N/A",117435.29833376269,5871.7649166881347,{"$f":"ROUNDDOWN(K207,0)","v":117435}]
[null,null,"Anderson","CA","N/A",64538.951617837418,890,3.729279452927275E-3,39231.457147644585,"N/A",103770.408765482,5188.5204382741003,103770]
[null,null,"Angels","CA","N/A",64538.951617837418,380,1.5922766203509712E-3,16750.509793376339,"N/A",81289.461411213764,4064.4730705606885,81289]
[null,null,"Arcata","CA","N/A",64538.951617837418,2530,1.0601210130231466E-2,111523.13099274246,"N/A",176062.08261057988,8803.1041305289946,176062]
[null,null,"Artesia","CA","N/A",64538.951617837418,1615,6.7671756364916279E-3,71189.666621849436,"N/A",135728.61823968685,6786.4309119843429,135728]
[null,null,"Arvin","CA","N/A",64538.951617837418,1680,7.0395387426042937E-3,74054.885402295389,"N/A",138593.83702013281,6929.6918510066407,138593]
[null,null,"Atwater","CA","N/A",64538.951617837418,2125,8.9041784690679308E-3,93670.613976117675,"N/A",158209.56559395511,7910.4782796977561,158209]
[null,null,"Auburn","CA","N/A",64538.951617837418,1255,5.2587030487907076E-3,55320.762607071854,"N/A",119859.71422490927,5992.9857112454638,119859]
[null,null,"Avenal","CA","N/A",64538.951617837418,910,3.8130834855773258E-3,40113.062926243336,"N/A",104652.01454408075,5232.6007272040379,104652]
[null,null,"Benicia","CA","N/A",64538.951617837418,1745,7.3119018487169604E-3,76920.104182741343,"N/A",141459.05580057876,7072.9527900289386,141459]
[null,null,"Biggs","CA","N/A",64538.951617837418,140,5.8662822855035785E-4,6171.2404501912824,"N/A",70710.1920680287,3535.509603401435,70710]
[null,null,"Bishop","CA","N/A",64538.951617837418,435,1.8227377101386118E-3,19174.925684522914,"N/A",83713.877302360328,4185.6938651180162,83713]
[null,null,"Blue Lake","CA","N/A",64538.951617837418,85,3.5616713876271725E-4,3746.8245590447073,"N/A",68285.776176882122,3414.2888088441064,68285]
[null,null,"Brawley","CA","N/A",64538.951617837418,1965,8.2337462078675219E-3,86617.767747327642,"N/A",151156.71936516505,7557.8359682582523,151156]
[null,null,"Butte County","CA","N/A",64538.951617837418,6100,2.5560229958265592E-2,268889.76247262018,"N/A",333428.71409045759,16671.435704522879,333428]
[null,null,"Calaveras County","CA","N/A",64538.951617837418,3220,1.3492449256658231E-2,141938.5303543995,"N/A",206477.48197223691,10323.874098611846,206477]
[null,null,"Calexico","CA","N/A",64538.951617837418,3160,1.3241037158708077E-2,139293.71301860324,"N/A",203832.66463644066,10191.633231822034,203832]
[null,null,"Calimesa","CA","N/A",64538.951617837418,550,2.3046108978764059E-3,24244.158911465754,"N/A",88783.110529303172,4439.1555264651588,88783]
[null,null,"Calipatria","CA","N/A",64538.951617837418,285,1.1942074652632284E-3,12562.882345032252,"N/A",77101.83396286967,3855.0916981434839,77101]
[null,null,"Calistoga","CA","N/A",64538.951617837418,470,1.9693947672762015E-3,20717.735797070734,"N/A",85256.687414908156,4262.8343707454078,85256]
[null,null,"Capitola","CA","N/A",64538.951617837418,920,3.8549855019023517E-3,40553.865815542718,"N/A",105092.81743338014,5254.6408716690075,105092]
[null,null,"Carmel-by-the-Sea","CA","N/A",64538.951617837418,395,1.6551296448385096E-3,17411.714127325406,"N/A",81950.665745162827,4097.5332872581412,81950]
[null,null,"Chowchilla","CA","N/A",64538.951617837418,1040,4.3578096978026584E-3,45843.500487135243,"N/A",110382.45210497266,5519.1226052486336,110382]
[null,null,"Clearlake","CA","N/A",64538.951617837418,1845,7.7309220119672157E-3,81328.13307573511,"N/A",145867.08469357254,7293.3542346786271,145867]
[null,null,"Coalinga","CA","N/A",64538.951617837418,875,3.6664264284397364E-3,38570.252813695515,"N/A",103109.20443153294,5155.4602215766472,103109]
[null,null,"Colfax","CA","N/A",64538.951617837418,170,7.1233427752543451E-4,7493.6491180894145,"N/A",72032.600735926826,3601.6300367963413,72032]
[null,null,"Colusa","CA","N/A",64538.951617837418,485,2.0322477917637397E-3,21378.940131019801,"N/A",85917.891748857219,4295.8945874428609,85917]
[null,null,"Colusa County","CA","N/A",64538.951617837418,430,1.8017867019760991E-3,18954.524239873226,"N/A",83493.47585771064,4174.6737928855318,83493]
[null,null,"Corcoran","CA","N/A",64538.951617837418,1120,4.6930258284028628E-3,49369.923601530259,"N/A",113908.87521936768,5695.4437609683846,113908]
[null,null,"Corning","CA","N/A",64538.951617837418,635,2.6607780366391231E-3,27990.983470510459,"N/A",92529.935088347876,4626.4967544173942,92529]
[null,null,"Crescent City","CA","N/A",64538.951617837418,370,1.5503746040259458E-3,16309.706904076962,"N/A",80848.658521914374,4042.4329260957188,80848]
[null,null,"Del Norte County","CA","N/A",64538.951617837418,1730,7.2490488242294218E-3,76258.89984879228,"N/A",140797.85146662971,7039.8925733314863,140797]
[null,null,"Dinuba","CA","N/A",64538.951617837418,1900,7.961383101754857E-3,83752.548966881703,"N/A",148291.50058471912,7414.5750292359562,148291]
[null,null,"Dixon","CA","N/A",64538.951617837418,1155,4.8396828855404523E-3,50912.73371407808,"N/A",115451.68533191551,5772.5842665957753,115451]
[null,null,"Dorris","CA","N/A",64538.951617837418,45,1.8855907346261501E-4,1983.6130018471979,"N/A",66522.564619684621,3326.1282309842313,66522]
[null,null,"Dos Palos","CA","N/A",64538.951617837418,415,1.7389336774885607E-3,18293.31990592416,"N/A",82832.271523761578,4141.6135761880787,82832]
[null,null,"Dunsmuir","CA","N/A",64538.951617837418,170,7.1233427752543451E-4,7493.6491180894145,"N/A",72032.600735926826,3601.6300367963413,72032]
[null,null,"El Centro","CA","N/A",64538.951617837418,3440,1.4414293615808793E-2,151636.19391898581,"N/A",216175.14553682323,10808.757276841163,216175]
[null,null,"El Dorado County","CA","N/A",64538.951617837418,9425,3.9492650386336592E-2,415456.72316466313,"N/A",479995.67478250054,23999.783739125029,479995]
[null,null,"Etna","CA","N/A",64538.951617837418,60,2.5141209795015337E-4,2644.8173357962642,"N/A",67183.768953633684,3359.1884476816845,67183]
[null,null,"Eureka","CA","N/A",64538.951617837418,2790,1.1690662554682131E-2,122984.00611452627,"N/A",187522.95773236369,9376.1478866181842,187522]
[null,null,"Exeter","CA","N/A",64538.951617837418,755,3.1636022325394297E-3,33280.618142102983,"N/A",97819.569759940408,4890.9784879970202,97819]
[null,null,"Farmersville","CA","N/A",64538.951617837418,765,3.2055042488644552E-3,33721.421031402366,"N/A",98260.372649239784,4913.0186324619899,98260]
[null,null,"Ferndale","CA","N/A",64538.951617837418,150,6.285302448753834E-4,6612.0433394906595,"N/A",71150.994957328076,3557.5497478664038,71150]
[null,null,"Firebaugh","CA","N/A",64538.951617837418,700,2.9331411427517893E-3,30856.202250956412,"N/A",95395.15386879383,4769.757693439692,95395]
[null,null,"Fort Bragg","CA","N/A",64538.951617837418,960,4.0225935672024539E-3,42317.077372740227,"N/A",106856.02899057764,5342.8014495288826,106856]
[null,null,"Fort Jones","CA","N/A",64538.951617837418,105,4.3997117141276836E-4,4628.4303376434618,"N/A",69167.381955480872,3458.3690977740439,69167]
[null,null,"Fortuna","CA","N/A",64538.951617837418,1000,4.1902016325025557E-3,44080.288929937728,"N/A",108619.24054777515,5430.9620273887576,108619]
[null,null,"Fowler","CA","N/A",64538.951617837418,375,1.5713256121884585E-3,16530.108348726648,"N/A",81069.059966564062,4053.4529983282032,81069]
[null,null,"Glenn County","CA","N/A",64538.951617837418,960,4.0225935672024539E-3,42317.077372740227,"N/A",106856.02899057764,5342.8014495288826,106856]
[null,null,"Grass Valley","CA","N/A",64538.951617837418,1610,6.7462246283291156E-3,70969.265177199748,"N/A",135508.21679503715,6775.4108397518576,135508]
[null,null,"Greenfield","CA","N/A",64538.951617837418,1710,7.1652447915793709E-3,75377.294070193529,"N/A",139916.24568803096,6995.8122844015488,139916]
[null,null,"Gridley","CA","N/A",64538.951617837418,635,2.6607780366391231E-3,27990.983470510459,"N/A",92529.935088347876,4626.4967544173942,92529]
[null,null,"Grover Beach","CA","N/A",64538.951617837418,1285,5.3844090977657848E-3,56643.171274969987,"N/A",121182.12289280741,6059.106144640371,121182]
[null,null,"Guadalupe","CA","N/A",64538.951617837418,830,3.4778673549771214E-3,36586.639811848319,"N/A",101125.59142968574,5056.2795714842869,101125]
[null,null,"Gustine","CA","N/A",64538.951617837418,205,8.5899133466302399E-4,9036.4592306372342,"N/A",73575.410848474654,3678.7705424237329,73575]
[null,null,"Hidden Hills","CA","N/A",64538.951617837418,155,6.4948125303789623E-4,6832.4447841403489,"N/A",71371.396401977763,3568.5698200988882,71371]
[null,null,"Hollister","CA","N/A",64538.951617837418,2625,1.099927928531921E-2,115710.75844108655,"N/A",180249.71005892399,9012.4855029461996,180249]
[null,null,"Holtville","CA","N/A",64538.951617837418,410,1.717982669326048E-3,18072.918461274468,"N/A",82611.87007911189,4130.5935039555943,82611]
[null,null,"Humboldt County","CA","N/A",64538.951617837418,6350,2.6607780366391231E-2,279909.83470510459,"N/A",344448.786322942,17222.439316147102,344448]
[null,null,"Huron","CA","N/A",64538.951617837418,795,{"$f":"G267/$G$366","v":3.3312102978395319E-3},{"$f":"$K$12*0.5*H267","v":35043.829699300499},"N/A",{"$f":"I267+F267","v":99582.781317137909},{"$f":"K267*0.05","v":4979.1390658568962},99582]
[null,null,"Imperial","CA","N/A",64538.951617837418,610,2.556022995826559E-3,26888.976247262017,"N/A",91427.927865099438,4571.3963932549723,91427]
[null,null,"Imperial County","CA","N/A",{"$f":"($K$12)*0.5/163","v":64538.951617837418},2480,1.039170004860634E-2,109319.11654624558,"N/A",173858.068164083,8692.9034082041508,173858]
[null,null,"Indian Wells","CA","N/A",64538.951617837418,550,2.3046108978764059E-3,24244.158911465754,"N/A",88783.110529303172,4439.1555264651588,88783]
[null,null,"Industry","CA","N/A",64538.951617837418,24,1.0056483918006135E-4,1057.9269343185056,"N/A",65596.878552155918,3279.8439276077961,{"$f":"ROUNDDOWN(K271,0)","v":65596}]
[null,null,"Inyo County","CA","N/A",64538.951617837418,890,3.729279452927275E-3,39231.457147644585,"N/A",103770.408765482,5188.5204382741003,103770]
[null,null,"Ione","CA","N/A",64538.951617837418,245,1.0265993999631262E-3,10799.670787834744,"N/A",75338.622405672155,3766.9311202836079,75338]
[null,null,"Jackson","CA","N/A",64538.951617837418,520,2.1789048489013292E-3,22921.750243567622,"N/A",87460.701861405047,4373.0350930702525,87460]
[null,null,"King City","CA","N/A",64538.951617837418,1580,6.6205185793540384E-3,69646.856509301622,"N/A",134185.80812713905,6709.2904063569531,134185]
[null,null,"Kings County","CA","N/A",64538.951617837418,2245,9.4070026649682378E-3,98960.248647710207,"N/A",163499.20026554761,8174.9600132773812,163499]
[null,null,"Lake County","CA","N/A",64538.951617837418,4020,1.6844610562660275E-2,177202.76149834969,"N/A",241741.71311618711,12087.085655809356,241741]
[null,null,"Lakeport","CA","N/A",64538.951617837418,335,1.4037175468883563E-3,14766.89679152914,"N/A",79305.848409366561,3965.2924204683281,79305]
[null,null,"Lassen County","CA","N/A",64538.951617837418,850,3.5616713876271727E-3,37468.24559044707,"N/A",102007.19720828449,5100.3598604142244,102007]
[null,null,"Lemoore","CA","N/A",64538.951617837418,1830,7.6680689874796771E-3,80666.928741786047,"N/A",145205.88035962346,7260.294017981174,145205]
[null,null,"Lincoln","CA","N/A",64538.951617837418,3145,1.3178184134220538E-2,138632.50868465417,"N/A",203171.46030249159,10158.573015124581,203171]
[null,null,"Lindsay","CA","N/A",64538.951617837418,1195,5.007290950840554E-3,52675.945271275588,"N/A",117214.89688911301,5860.7448444556503,117214]
[null,null,"Live Oak","CA","N/A",64538.951617837418,570,2.3884149305264568E-3,25125.764690064505,"N/A",89664.716307901923,4483.2358153950963,89664]
[null,null,"Livingston","CA","N/A",64538.951617837418,1005,4.2111526406650689E-3,44300.690374587422,"N/A",108839.64199242485,5441.9820996212429,108839]
[null,null,"Loomis","CA","N/A",64538.951617837418,390,1.6341786366759969E-3,17191.312682675714,"N/A",81730.264300513139,4086.5132150256572,81730]
[null,null,"Los Banos","CA","N/A",64538.951617837418,2805,1.175351557916967E-2,123645.21044847534,"N/A",188184.16206631274,9409.2081033156373,188184]
[null,null,"Loyalton","CA","N/A",64538.951617837418,70,2.9331411427517892E-4,3085.6202250956412,"N/A",67624.571842933059,3381.2285921466532,67624]
[null,null,"Madera County","CA","N/A",64538.951617837418,4750,1.9903457754387142E-2,209381.37241720423,"N/A",273920.32403504162,13696.016201752082,273920]
[null,null,"Mammoth Lakes","CA","N/A",64538.951617837418,390,1.6341786366759969E-3,17191.312682675714,"N/A",81730.264300513139,4086.5132150256572,81730]
[null,null,"Maricopa","CA","N/A",64538.951617837418,50,2.0951008162512779E-4,2204.0144464968866,"N/A",66742.966064334309,3337.1483032167157,66742]
[null,null,"Marina","CA","N/A",64538.951617837418,2110,8.8413254445803939E-3,93009.409642168626,"N/A",157548.36126000603,7877.418063000302,157548]
[null,null,"Mariposa County","CA","N/A",64538.951617837418,1450,6.0757923671287059E-3,63916.418948409708,"N/A",128455.37056624712,6422.7685283123565,128455]
[null,null,"Marysville","CA","N/A",64538.951617837418,1040,4.3578096978026584E-3,45843.500487135243,"N/A",110382.45210497266,5519.1226052486336,110382]
[null,null,"McFarland","CA","N/A",64538.951617837418,1095,4.5882707875902987E-3,48267.916378281814,"N/A",112806.86799611922,5640.3433998059618,112806]
[null,null,"Mendocino County","CA","N/A",64538.951617837418,6475,2.713155557045405E-2,285419.87082134682,"N/A",349958.82243918424,17497.941121959211,349958]
[null,null,"Merced County","CA","N/A",64538.951617837418,5590,2.3423227125689287E-2,246408.81511835189,"N/A",310947.76673618931,15547.388336809467,310947]
[null,null,"Modoc County","CA","N/A",64538.951617837418,270,1.13135444077569E-3,11901.678011083186,"N/A",76440.629628920608,3822.0314814460307,76440]
[null,null,"Mono County","CA","N/A",64538.951617837418,285,1.1942074652632284E-3,12562.882345032252,"N/A",77101.83396286967,3855.0916981434839,77101]
[null,null,"Montague","CA","N/A",64538.951617837418,95,3.9806915508774281E-4,4187.6274483440848,"N/A",68726.579066181497,3436.3289533090751,68726]
[null,null,"Mount Shasta","CA","N/A",64538.951617837418,575,2.4093659386889696E-3,25346.166134714193,"N/A",89885.11775255161,4494.2558876275807,89885]
[null,null,"Napa County","CA","N/A",64538.951617837418,1785,7.4795099140170622E-3,78683.315739938844,"N/A",143222.26735777626,7161.1133678888136,143222]
[null,null,"Nevada City","CA","N/A",64538.951617837418,325,1.3618155305633306E-3,14326.093902229763,"N/A",78865.045520067186,3943.2522760033594,78865]
[null,null,"Nevada County","CA","N/A",64538.951617837418,5485,2.298325595427652E-2,241780.38478070847,"N/A",306319.33639854589,15315.966819927295,306319]
[null,null,"Orange Cove","CA","N/A",64538.951617837418,835,3.4988183631396341E-3,36807.041256498007,"N/A",101345.99287433542,5067.2996437167712,101345]
[null,null,"Orland","CA","N/A",64538.951617837418,635,2.6607780366391231E-3,27990.983470510459,"N/A",92529.935088347876,4626.4967544173942,92529]
[null,null,"Oroville","CA","N/A",64538.951617837418,1645,6.8928816854667042E-3,72512.075289747561,"N/A",137051.02690758498,6852.5513453792491,137051]
[null,null,"Pacific Grove","CA","N/A",64538.951617837418,1230,5.1539480079781435E-3,54218.755383823409,"N/A",118757.70700166083,5937.8853500830419,118757]
[null,null,"Palos Verdes Estates","CA","N/A",64538.951617837418,730,3.0588471917268661E-3,32178.610918854545,"N/A",96717.562536691956,4835.8781268345983,96717]
[null,null,"Parlier","CA","N/A",64538.951617837418,1565,6.5576655548664998E-3,68985.652175352545,"N/A",133524.60379318998,6676.230189659499,133524]
[null,null,"Pismo Beach","CA","N/A",64538.951617837418,795,3.3312102978395319E-3,35043.829699300499,"N/A",99582.781317137909,4979.1390658568962,99582]
[null,null,"Placer County","CA","N/A",64538.951617837418,8860,3.7125186463972649E-2,390551.35991924832,"N/A",455090.31153708574,22754.51557685429,455090]
[null,null,"Placerville","CA","N/A",64538.951617837418,1050,4.3997117141276838E-3,46284.303376434618,"N/A",110823.25499427204,5541.1627497136024,110823]
[null,null,"Plumas County","CA","N/A",64538.951617837418,1285,5.3844090977657848E-3,56643.171274969987,"N/A",121182.12289280741,6059.106144640371,121182]
[null,null,"Plymouth","CA","N/A",64538.951617837418,65,2.7236310611266615E-4,2865.2187804459527,"N/A",67404.170398283371,3370.2085199141688,67404]
[null,null,"Point Arena","CA","N/A",64538.951617837418,65,2.7236310611266615E-4,2865.2187804459527,"N/A",67404.170398283371,3370.2085199141688,67404]
[null,null,"Portola","CA","N/A",64538.951617837418,245,1.0265993999631262E-3,10799.670787834744,"N/A",75338.622405672155,3766.9311202836079,75338]
[null,null,"Rancho Mirage","CA","N/A",64538.951617837418,2440,1.0224091983306236E-2,107555.90498904807,"N/A",172094.8566068855,8604.7428303442757,172094]
[null,null,"Red Bluff","CA","N/A",64538.951617837418,1350,5.6567722038784506E-3,59508.390055415941,"N/A",124047.34167325337,6202.3670836626688,124047]
[null,null,"Rio Dell","CA","N/A",64538.951617837418,330,1.3827665387258436E-3,14546.495346879452,"N/A",79085.446964716873,3954.2723482358438,79085]
[null,null,"Rio Vista","CA","N/A",64538.951617837418,720,3.0169451754018402E-3,31737.808029555166,"N/A",96276.759647392581,4813.8379823696296,96276]
[null,null,"Riverbank","CA","N/A",64538.951617837418,1305,5.4682131304158357E-3,57524.777053568738,"N/A",122063.72867140616,6103.1864335703085,122063]
[null,null,"San Benito County","CA","N/A",64538.951617837418,1285,5.3844090977657848E-3,56643.171274969987,"N/A",121182.12289280741,6059.106144640371,121182]
[null,null,"San Joaquin","CA","N/A",64538.951617837418,320,1.3408645224008179E-3,14105.692457580073,"N/A",78644.644075417484,3932.2322037708745,78644]
[null,null,"San Juan Bautista","CA","N/A",64538.951617837418,260,1.0894524244506646E-3,11460.875121783811,"N/A",75999.826739621232,3799.991336981062,75999]
[null,null,"San Juan Capistrano","CA","N/A",64538.951617837418,3900,1.634178636675997E-2,171913.12682675716,"N/A",236452.07844459458,11822.60392222973,236452]
[null,null,"Sand City","CA","N/A",64538.951617837418,59,2.4722189631765079E-4,2600.7370468663262,"N/A",67139.688664703746,3356.9844332351877,67139]
[null,null,"Santa Cruz County","CA","N/A",64538.951617837418,11375,4.7663543569716575E-2,501413.28657804168,"N/A",565952.23819587915,28297.611909793959,565952]
[null,null,"Scotts Valley","CA","N/A",64538.951617837418,890,3.729279452927275E-3,39231.457147644585,"N/A",103770.408765482,5188.5204382741003,103770]
[null,null,"Shasta County","CA","N/A",64538.951617837418,5045,2.1139567235975393E-2,222385.05765153584,"N/A",286924.00926937326,14346.200463468664,286924]
[null,null,"Shasta Lake","CA","N/A",64538.951617837418,855,3.5826223957896855E-3,37688.647035096765,"N/A",102227.59865293419,5111.3799326467097,102227]
[null,null,"Sierra County","CA","N/A",64538.951617837418,70,{"$f":"G331/$G$366","v":2.9331411427517892E-4},{"$f":"$K$12*0.5*H331","v":3085.6202250956412},"N/A",{"$f":"I331+F331","v":67624.571842933059},{"$f":"K331*0.05","v":3381.2285921466532},67624]
[null,null,"Siskiyou County","CA","N/A",64538.951617837418,1760,7.374754873204499E-3,77581.308516690406,"N/A",142120.26013452781,7106.0130067263908,142120]
[null,null,"Solano County","CA","N/A",{"$f":"($K$12)*0.5/163","v":64538.951617837418},1445,6.0548413589661936E-3,63696.017503760027,"N/A",128234.96912159745,6411.748456079873,128234]
[null,null,"Soledad","CA","N/A",64538.951617837418,1280,5.3634580896032716E-3,56422.769830320292,"N/A",120961.72144815771,6048.0860724078857,120961]
[null,null,"Sonora","CA","N/A",64538.951617837418,610,2.556022995826559E-3,26888.976247262017,"N/A",91427.927865099438,4571.3963932549723,{"$f":"ROUNDDOWN(K335,0)","v":91427}]
[null,null,"South Lake Tahoe","CA","N/A",64538.951617837418,2295,9.6165127465933659E-3,101164.2630942071,"N/A",165703.21471204452,8285.1607356022269,165703]
[null,null,"St. Helena","CA","N/A",64538.951617837418,555,2.3255619060389187E-3,24464.560356115442,"N/A",89003.51197395286,4450.1755986976432,89003]
[null,null,"Suisun City","CA","N/A",64538.951617837418,2045,8.5689623384677272E-3,90144.190861722658,"N/A",154683.14247956008,7734.1571239780042,154683]
[null,null,"Susanville","CA","N/A",64538.951617837418,650,2.7236310611266613E-3,28652.187804459525,"N/A",93191.139422296939,4659.5569711148473,93191]
[null,null,"Sutter County","CA","N/A",64538.951617837418,1175,4.9234869181905032E-3,51794.339492676831,"N/A",116333.29111051426,5816.6645555257128,116333]
[null,null,"Sutter Creek","CA","N/A",64538.951617837418,320,1.3408645224008179E-3,14105.692457580073,"N/A",78644.644075417484,3932.2322037708745,78644]
[null,null,"Taft","CA","N/A",64538.951617837418,590,2.4722189631765082E-3,26007.370468663263,"N/A",90546.322086500673,4527.3161043250338,90546]
[null,null,"Tehama","CA","N/A",64538.951617837418,24,1.0056483918006135E-4,1057.9269343185056,"N/A",65596.878552155918,3279.8439276077961,65596]
[null,null,"Tehama County","CA","N/A",64538.951617837418,2771,1.1611048723664582E-2,122146.48062485745,"N/A",186685.43224269486,9334.2716121347439,186685]
[null,null,"Trinidad","CA","N/A",64538.951617837418,35,1.4665705713758946E-4,1542.8101125478206,"N/A",66081.761730385246,3304.0880865192626,66081]
[null,null,"Trinity County","CA","N/A",64538.951617837418,1295,5.4263111140908102E-3,57083.974164269363,"N/A",121622.92578210679,6081.1462891053397,121622]
[null,null,"Truckee","CA","N/A",64538.951617837418,910,3.8130834855773258E-3,40113.062926243336,"N/A",104652.01454408075,5232.6007272040379,104652]
[null,null,"Tulare County","CA","N/A",64538.951617837418,11775,4.93396242227176E-2,519045.4021500168,"N/A",583584.35376785416,29179.21768839271,583584]
[null,null,"Tulelake","CA","N/A",64538.951617837418,90,3.7711814692523003E-4,3967.2260036943958,"N/A",68506.17762153181,3425.3088810765908,68506]
[null,null,"Tuolumne County","CA","N/A",64538.951617837418,4030,1.68865125789853E-2,177643.56438764906,"N/A",242182.51600548648,12109.125800274325,242182]
[null,null,"Ukiah","CA","N/A",64538.951617837418,1480,6.2014984161037831E-3,65238.827616307848,"N/A",129777.77923414527,6488.8889617072637,129777]
[null,null,"Vernon","CA","N/A",64538.951617837418,19,7.9613831017548569E-5,837.52548966881693,"N/A",65376.477107506238,3268.8238553753122,65376]
[null,null,"Wasco","CA","N/A",64538.951617837418,1610,6.7462246283291156E-3,70969.265177199748,"N/A",135508.21679503715,6775.4108397518576,135508]
[null,null,"Weed","CA","N/A",64538.951617837418,275,1.152305448938203E-3,12122.079455732877,"N/A",76661.031073570295,3833.0515536785151,76661]
[null,null,"Westmorland","CA","N/A",64538.951617837418,185,7.7518730201297289E-4,8154.853452038481,"N/A",72693.805069875903,3634.6902534937954,72693]
[null,null,"Wheatland","CA","N/A",64538.951617837418,170,7.1233427752543451E-4,7493.6491180894145,"N/A",72032.600735926826,3601.6300367963413,72032]
[null,null,"Williams","CA","N/A",64538.951617837418,370,1.5503746040259458E-3,16309.706904076962,"N/A",80848.658521914374,4042.4329260957188,80848]
[null,null,"Willits","CA","N/A",64538.951617837418,630,2.6398270284766104E-3,27770.582025860771,"N/A",92309.533643698189,4615.4766821849098,92309]
[null,null,"Willows","CA","N/A",64538.951617837418,660,2.7655330774516871E-3,29092.990693758904,"N/A",93631.942311596329,4681.597115579817,93631]
[null,null,"Winters","CA","N/A",64538.951617837418,550,2.3046108978764059E-3,24244.158911465754,"N/A",88783.110529303172,4439.1555264651588,88783]
[null,null,"Woodlake","CA","N/A",64538.951617837418,575,2.4093659386889696E-3,25346.166134714193,"N/A",89885.11775255161,4494.2558876275807,89885]
[null,null,"Yolo County","CA","N/A",64538.951617837418,1635,6.8509796691416788E-3,72071.272400448186,"N/A",136610.2240182856,6830.5112009142804,136610]
[null,null,"Yountville","CA","N/A",64538.951617837418,375,1.5713256121884585E-3,16530.108348726648,"N/A",81069.059966564062,4053.4529983282032,81069]
[null,null,"Yreka","CA","N/A",64538.951617837418,850,3.5616713876271727E-3,37468.24559044707,"N/A",102007.19720828449,5100.3598604142244,102007]
[null,null,"Yuba County","CA","N/A",64538.951617837418,4715,1.9756800697249551E-2,207838.5623046564,"N/A",272377.51392249379,13618.875696124691,272377]
[null,null,null,null,null,null,{"$f":"SUM(G203:G365)","v":238652}]

{"sheet":"DATA","index":9,"n_rows":128,"n_cols":7,"rows_kept":128,"cut":false,"hidden":true,"merged":[]}
["Nonentitlement","Entitlement","Counties ",null,null,"Nonentitlement","Entitlement"]
["Alpine County","Aliso Viejo","Alameda",null,null,"Alpine County","Aliso Viejo"]
["Alturas","Carlsbad","Alpine",null,null,"Alturas","Carlsbad"]
["Amador City","Carson","Amador",null,null,"Amador City","Carson"]
["Amador County","Cerritos","Butte",null,null,"Amador County","Cerritos"]
["American Canyon","Chico","Calaveras",null,null,"American Canyon","Chico"]
["Anderson","Chino","Colusa",null,null,"Anderson","Chino"]
["Angels","Chino Hills","Contra Costa",null,null,"Angels","Chino Hills"]
["Arcata","Clovis City","Del Norte",null,null,"Arcata","Clovis City"]
["Artesia","Compton","El Dorado",null,null,"Artesia","Compton"]
["Atwater","Concord","Fresno",null,null,"Atwater","Concord"]
["Auburn","Contra Costa County","Glenn",null,null,"Auburn","Contra Costa County"]
["Avenal","Cupertino City","Humboldt",null,null,"Avenal","Cupertino City"]
["Benicia","Downey","Imperial",null,null,"Benicia","Downey"]
["Biggs","El Cajon","Inyo",null,null,"Biggs","El Cajon"]
["Bishop","El Centro (Colonia Only)","Kern",null,null,"Bishop","El Centro (Colonia Only)"]
["Blue Lake","Elk Grove","Kings",null,null,"Blue Lake","Elk Grove"]
["Brawley","Encinitas","Lake",null,null,"Brawley","Encinitas"]
["Butte County","Escondido","Lassen",null,null,"Butte County","Escondido"]
["Calaveras County","Fountain Valley","Los Angeles",null,null,"Calaveras County","Fountain Valley"]
["Calexico","Gardena","Madera",null,null,"Calexico","Gardena"]
["Calimesa","Gilroy City","Marin",null,null,"Calimesa","Gilroy City"]
["Calipatria","Glendale","Mariposa",null,null,"Calipatria","Glendale"]
["Calistoga","Glendora City","Mendocino",null,null,"Calistoga","Glendora City"]
["Capitola","Hawthorne","Merced",null,null,"Capitola","Hawthorne"]
["Carmel-by-the-Sea","Hesperia","Modoc",null,null,"Carmel-by-the-Sea","Hesperia"]
["Clearlake","Huntington Park","Mono",null,null,"Clearlake","Huntington Park"]
["Colfax","Laguna Niguel","Monterey",null,null,"Colfax","Laguna Niguel"]
["Colusa","Lake Forest","Napa",null,null,"Colusa","Lake Forest"]
["Colusa County","Lakewood","Nevada",null,null,"Colusa County","Lakewood"]
["Corcoran","Lompoc","Orange",null,null,"Corcoran","Lompoc"]
["Corning","Madera","Placer",null,null,"Corning","Madera"]
["Crescent City","Merced","Plumas",null,null,"Crescent City","Merced"]
["Del Norte County","Milpitas City","Riverside",null,null,"Del Norte County","Milpitas City"]
["Dixon","Montebello","Sacramento",null,null,"Dixon","Montebello"]
["Dorris","Monterey Park","San Benito",null,null,"Dorris","Monterey Park"]
["Dos Palos","Mountain View","San Bernardino",null,null,"Dos Palos","Mountain View"]
["Dunsmuir","Newport Beach","San Diego",null,null,"Dunsmuir","Newport Beach"]
["El Centro","Norwalk","San Francisco",null,null,"El Centro","Norwalk"]
["Etna","Palo Alto","San Joaquin",null,null,"Etna","Palo Alto"]
["Eureka","Paradise","San Luis Obispo",null,null,"Eureka","Paradise"]
["Ferndale","Paramount City","San Mateo",null,null,"Ferndale","Paramount City"]
["Firebaugh","Petaluma","Santa Barbara",null,null,"Firebaugh","Petaluma"]
["Fort Bragg","Pico Rivera","Santa Clara",null,null,"Fort Bragg","Pico Rivera"]
["Fort Jones","Pittsburg","Santa Cruz",null,null,"Fort Jones","Pittsburg"]
["Fortuna","Pleasanton City","Shasta",null,null,"Fortuna","Pleasanton City"]
["Fowler","Rancho Cordova City","Sierra",null,null,"Fowler","Rancho Cordova City"]
["Greenfield","Rancho Cucamonga","Siskiyou",null,null,"Greenfield","Rancho Cucamonga"]
["Gridley","Redondo Beach","Solano",null,null,"Gridley","Redondo Beach"]
["Guadalupe","Redwood City","Sonoma",null,null,"Guadalupe","Redwood City"]
["Gustine","Rialto","Stanislaus",null,null,"Gustine","Rialto"]
["Hidden Hills","Rosemead","Sutter",null,null,"Hidden Hills","Rosemead"]
["Hollister","San Clemente","Tehama",null,null,"Hollister","San Clemente"]
["Holtville","San Marcos City","Trinity",null,null,"Holtville","San Marcos City"]
["Huron","San Mateo County","Tulare",null,null,"Huron","San Mateo County"]
["Imperial","Santa Clara","Tuolumne",null,null,"Imperial","Santa Clara"]
["Imperial County","Santa Clara County","Ventura",null,null,"Imperial County","Santa Clara County"]
["Indian Wells","Santa Clarita","Yolo",null,null,"Indian Wells","Santa Clarita"]
["Industry","Santee","Yuba",null,null,"Industry","Santee"]
["Inyo County","Seaside",null,null,null,"Inyo County","Seaside"]
["Ione","Sunnyvale",null,null,null,"Ione","Sunnyvale"]
["Jackson","Torrance",null,null,null,"Jackson","Torrance"]
["Kings County","Turlock",null,null,null,"Kings County","Turlock"]
["Lake County","Union City",null,null,null,"Lake County","Union City"]
["Lakeport","Upland",null,null,null,"Lakeport","Upland"]
["Lassen County","Vacaville",null,null,null,"Lassen County","Vacaville"]
["Lemoore","Watsonville",null,null,null,"Lemoore","Watsonville"]
["Lincoln","West Covina",null,null,null,"Lincoln","West Covina"]
["Live Oak","West Sacramento",null,null,null,"Live Oak","West Sacramento"]
["Livingston","Whittier",null,null,null,"Livingston","Whittier"]
["Loomis",null,null,null,null,"Loomis"]
["Los Banos",null,null,null,null,"Los Banos"]
["Loyalton",null,null,null,null,"Loyalton"]
["Madera County",null,null,null,null,"Madera County"]
["Mammoth Lakes",null,null,null,null,"Mammoth Lakes"]
["Maricopa",null,null,null,null,"Maricopa"]
["Marina",null,null,null,null,"Marina"]
["McFarland",null,null,null,null,"McFarland"]
["Mendocino County",null,null,null,null,"Mendocino County"]
["Modoc County",null,null,null,null,"Modoc County"]
["Mono County",null,null,null,null,"Mono County"]
["Montague",null,null,null,null,"Montague"]
["Mount Shasta",null,null,null,null,"Mount Shasta"]
["Napa County",null,null,null,null,"Napa County"]
["Orange Cove",null,null,null,null,"Orange Cove"]
["Palos Verdes Estates",null,null,null,null,"Palos Verdes Estates"]
["Parlier",null,null,null,null,"Parlier"]
["Pismo Beach",null,null,null,null,"Pismo Beach"]
["Placerville",null,null,null,null,"Placerville"]
["Plymouth",null,null,null,null,"Plymouth"]
["Point Arena",null,null,null,null,"Point Arena"]
["Portola",null,null,null,null,"Portola"]
["Rancho Mirage",null,null,null,null,"Rancho Mirage"]
["Red Bluff",null,null,null,null,"Red Bluff"]
["Rio Dell",null,null,null,null,"Rio Dell"]
["Rio Vista",null,null,null,null,"Rio Vista"]
["San Benito County",null,null,null,null,"San Benito County"]
["San Juan Bautista",null,null,null,null,"San Juan Bautista"]
["San Juan Capistrano",null,null,null,null,"San Juan Capistrano"]
["Sand City",null,null,null,null,"Sand City"]
["Scotts Valley",null,null,null,null,"Scotts Valley"]
["Shasta County",null,null,null,null,"Shasta County"]
["Shasta Lake",null,null,null,null,"Shasta Lake"]
["Sierra County",null,null,null,null,"Sierra County"]
["Soledad",null,null,null,null,"Soledad"]
["Sonora",null,null,null,null,"Sonora"]
["St. Helena",null,null,null,null,"St. Helena"]
["Suisun City",null,null,null,null,"Suisun City"]
["Susanville",null,null,null,null,"Susanville"]
["Sutter Creek",null,null,null,null,"Sutter Creek"]
["Taft",null,null,null,null,"Taft"]
["Tehama",null,null,null,null,"Tehama"]
["Tehama County",null,null,null,null,"Tehama County"]
["Trinidad",null,null,null,null,"Trinidad"]
["Trinity County",null,null,null,null,"Trinity County"]
["Tulelake",null,null,null,null,"Tulelake"]
["Tuolumne County",null,null,null,null,"Tuolumne County"]
["Ukiah",null,null,null,null,"Ukiah"]
["Vernon",null,null,null,null,"Vernon"]
["Wasco",null,null,null,null,"Wasco"]
["Weed",null,null,null,null,"Weed"]
["Westmorland",null,null,null,null,"Westmorland"]
["Wheatland",null,null,null,null,"Wheatland"]
["Williams",null,null,null,null,"Williams"]
["Willits",null,null,null,null,"Willits"]
["Woodlake",null,null,null,null,"Woodlake"]
["Yountville",null,null,null,null,"Yountville"]
["Yreka",null,null,null,null,"Yreka"]