{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Expenditure Report","Report Narrative","Equity Strategies","Operating Subsidy","Project Summary","DataTable","COSR Data","Equity Data","Drop-Down"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":46,"comments":2,"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":"Instructions","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,0,6,0]]}
["Beginning of Sheet 1: Instructions for the Homekey Program Grantee Expenditure Reporting:"]
["Pursuant to Health and Safety Code (HSC) Section 50675.1. The Department is authorized to administer the Multifamily Housing Program (MHP). Assembly Bill No. 83 (2019-2020 Reg. Sess.) added section 50675.1.1 and 50675.1.2 to the Multifamily Housing Program (“MHP”) (Chapter 6.7 (commencing with Section 50675) of Part 2 of Division 31 of the Health and Safety Code). Health and Safety Code section 50675.1.1 is the statutory basis for the Homekey Program (“Homekey” or “Program”)."]
["Biannual Reporting\nThe Department issued a Notice of Funding Availability on July 16, 2020 for $600 million to purchase and rehabilitate housing, including hotels, motels, vacant apartment buildings, and other buildings and convert them into interim or permanent, long-term housing. Of this funding, $550 million is from Coronavirus Relief Funds which must be expended by December 30th, 2020. The other $50 million is derived from State General Funds must be spent by June 30, 2022 and is subject to the biannual reporting requirements. All recipients of Homekey award funds must complete and submit this workbook as the first Grantee Expenditure Report by February 1, 2021. Per the NOFA's Article IV, Section 402, recipients of the State General Fund for Capitalized Operating Subsidies shall provide to the Department a report on January 31 and July 31 of each grant year, in a format specified by the Department, including but not limited to the information requested in this workbook. Recipients of only the Coronavirus Relief Funds do not need to fill out the Operating Subsidy tab. Recipients of the Operating Subsidy funds may update the Report Narrative Tab as appropriate but can leave most information the same when submitting biannual reports subsequent the first. "]
["Completion of the Reporting Workbook\nAll fields in which information is requested must be completed by the Grantee within the four tabs of the reporting workbook.  Reporting workbooks which contain blank information will be considered incomplete and will be returned to the Grantee for completion. Any questions pertaining to the reporting requirements should be directed to the Grant Management Representative assigned to the project.  If you do not have your Grant Management Representative information, you may submit your email inquiry at HomekeySGM@hcd.ca.gov"]
["Instructions - Please tab through each worksheet and fill in the form fields as prompted\n\nTab 1 - Instructions\nBefore you begin, ensure that Macros are enabled by selecting \"Enable Content\" in the yellow bar above, or go to File-Options-Trust Center, click on \"Trust Center Settings\" and select \"Macro Settings.\" Select \"Enable All Macros\" \n\nTab 2 - Expenditure Report \n(Per Article IV Section 402 of the NOFA: The Grantee that receives funds under the Homekey Program is responsible for ensuring that the expenditure of those funds is consistent with the requirements of the Program and for eligible activities described in Section 302. The Department shall monitor the expenditures to ensure that those expenditures comply with the NOFA. The Department may request the repayment of funds or pursue any other remedies available to it by law for failure to comply with program requirements. After the contract has expired, any funds not expended for eligible uses shall revert and must be remitted to the Department. \n1. Enter the requested project and Sponsor Information. Enter the name, telephone number, and email of the person preparing this workbook.  A Grant Management Representative may contact the Preparer for questions or additional information regarding this workbook\n2. Use the drop down box to select the appropriate reporting period for the project\n3. Under Expenditure Breakdown: Enter the beginning amounts of Coronavirus Relief Funds and State General Funds pursuant to the Standard Agreement between the Department and Sponsor.  \n4. Once the entire workbook is complete, have the authorizing official come back to this first tab and sign and certify that all information is true and correct. The Authorized Name and Title is the person who is authorized to execute documents per the submitted Resolution.\n\nTab 3 - Report Narrative \nA narrative summary of the Homekey project sites and outcomes.\n1. In cell B4, select from the drop-down or enter a whole number reflecting the number of unique sites funded with Homekey dollars. The appropriate number of rows will appear for the number of projects selected. If necessary, selecting \"Select One\" or \"1\" from the drop-down menu will reset the form to one project.  \nFor each unique project site, enter the site address (street address, city, and county), occupancy dates, matching requirements and sources, number of doors and type and number of units created or planned as applicable. \"Doors\" refers to the original number of rooms at the hotel, motel or hostel when acquired and may not be the same as the final number of useable housing units produced or anticipated when the project is finished. If the project site received funding from the Project Roomkey and Rehousing Strategy program, indicate \"Project Roomkey Site\" when prompted. Find out more about Project Roomkey: https://www.cdss.ca.gov/inforesources/cdss-programs/housing-programs/project-roomkey\n2. When individual site information is completed, you will be prompted to provide the number of useable units created and individuals housed with Homekey dollars. The numbers in this section are cumulative for all projects, if multiple projects are listed. The number of Units and the number of Doors converted will automatically populate based on the information submitted by project site. Individuals served include each person within a household (one household could represent multiple individuals). Rows 38-40 (i-iii) are optional if information is available.\n3. Provide as thorough a response as possible for narrative questions 2 through 9. \n4. On Question 8, select \"Yes\" or \"No\" from the drop-down menu in cell C152 to indicate whether participants are referred through the Coordinated Entry program.\n\nTab 4 - Operating Subsidy \nThis tab is for recipients of State General Fund capitalized operating subsidy awards only. If you have only been awarded Homekey CRF dollars, please leave Tab 4 blank.\n\nBegin by inputting in Cell C4 the first month and year that Operating Subsidy costs were expended for any of the Homekey-funded projects. This will enable the form to calculate a monthly estimate for operating subsidy costs. Proceed to enter information as prompted for the corresponding project site, beginning in Row 7. Amounts entered into Columns D-O should be expenditures from the Homekey Capitalized Operating Funds only. Matching funds will be accounted for in Column P as applicable. \n\n1. Column A: Enter the street address of the project, pursuant to NOFA §402 v. Please be sure the street address matches the corresponding street address input into the Report Narrative Tab (e.g. if street is input as \"St.\" on the Report Narrative rather than spelled out as \"street\", then use the same \"St.\" abbreviation in the Operating Subsidy Column A.\n2. Column B: Enter the County of the project site.\n3. Column C: Enter the number of units for the corresponding project site assisted by Capitalized Operating Subsidy (COSR)\n4. Columns D-F represent Administrative Costs Enter the amount of operating capital used to date for the corresponding project. As applicable, enter amount spent on Office Salaries in Column D, Property Management in E and Other Administrative Expenses in F\n5. Column G represents Utilities Costs expended by project site. As applicable, enter the total amount for the corresponding project in column G.\n6. Columns H-K represent Maintenance Costs expended by project site. Enter the amount spent on Payroll in Column H, Repairs and Maintenance in I, Security Payroll in J, and Other Maintenance Costs in K.\n7. Columns L and M represent Supportive Services Costs expended by project site. Enter the amount spent on Case Management in Column L and Other supportive services costs in M.\n8. Columns N and O represent total Taxes and Insurance Costs expended by project site. As applicable, enter the amount spent on Taxes in Column N and Insurance in Column O. \n9. Column P: enter the amount of match funding provided by the Sponsor, if any. Refer to the NOFA §203 and §303 for information regarding matching fund requirements\n10. Column Q: Enter the source(s) of the match amount provided in Column D. Separate multiple sources by commas. \n11. Columns R-T will automatically calculate the total expended per project, the average monthly costs per assisted unit and average monthly cost of supportive services. \n12. Sponsors receiving operating subsidy for supportive services will be required to fill out the table beginning in Row 25: Supportive Services and Itemization Detail. Select the appropriate service in the first row, and input the information requested pertaining to that service. Amounts expended and people served will be for all project sites where that service was provided. Repeat this for each distinct service provided. If you select \"Other\", briefly describe what other eligible service was provided. Your grant representative may contact you for more information or verification of services provided if the description is not clear or is not an eligible use of funds.\n\nThe Department will monitor the expenditures to ensure that those expenditures comply with the NOFA and the terms of the Standard Agreement. A Grant Management Representative may request additional information from the Sponsor if there is insufficient documentation or explanation of expenditures, pursuant to Section 402 of the Homekey NOFA."]

{"sheet":"Expenditure Report","index":1,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[18,5,18,7],[19,5,19,7],[20,5,20,7],[39,0,39,1],[39,2,39,3],[31,0,31,4],[32,0,32,4],[30,0,30,7],[25,0,25,2],[22,0,22,2],[20,0,20,2],[20,3,20,4],[23,0,23,2],[24,0,24,2],[35,8,35,15],[36,0,36,4],[33,0,33,4],[36,5,36,7],[37,0,37,4],[37,5,37,7],[42,0,42,4],[43,0,43,4],[35,0,35,7],[29,0,29,2],[41,0,41,3],[40,0,40,3],[40,4,40,7],[42,5,42,7],[43,5,43,7],[49,0,49,4],[50,0,50,4],[46,0,46,4],[47,0,47,4],[44,0,44,7],[47,5,47,7],[50,5,50,7],[46,5,46,7],[49,5,49,7],[48,0,48,1],[48,2,48,3],[45,0,45,1],[45,2,45,3],[1,0,1,2],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[17,5,17,7],[15,1,15,7],[41,4,41,7],[34,0,34,4],[16,0,16,7],[21,0,21,2],[26,0,26,2],[38,0,38,7],[27,0,27,2],[28,0,28,2],[17,3,17,4],[18,3,18,4],[19,3,19,4],[17,0,17,2],[18,0,18,2],[19,0,19,2],[10,0,10,7],[2,0,2,2],[12,5,12,7],[13,5,13,7],[14,5,14,7],[8,0,8,7],[9,0,9,7],[12,1,12,3],[11,1,11,3],[13,1,13,3],[14,1,14,3],[11,5,11,7]]}
["Beginning of Sheet 1: Expenditure Report"]
["DEPARTMENT OF HOUSING AND COMMUNITY DEVELOPMENT"]
["DIVISION OF STATE FINANCIAL ASSISTANCE"]
["STATE GRANT MANAGEMENT"]
["2020 West El Camino, 4th Floor"]
["Sacramento, CA  95833"]
["HomekeySGM@hcd.ca.gov"]
[]
["HOMEKEY PROGRAM"]
["Expenditure Report"]
["Last Revised 6/23/2021"]
["HCD Contract Number:",null,null,null,"Preparer Name:"]
["Sponsor Name:",null,null,null,"Preparer Title:"]
["Sponsor Address (number and street):",null,null,null,"Preparer Email:"]
["Sponsor City, State, Zip:",null,null,null,"Preparer phone number:"]
["Reporting Period:"]
["EXPENDITURE BREAKDOWN"]
["Fund Type",null,null,"Award Amount",null,"Expenditure Deadline"]
["Coronavirus Relief Funds (CRF)",null,null,null,null,"2020-12-30"]
["*24 Month Operating Subsidy funded from State General Fund \n(pursuant to NOFA §308)",null,null,null,null,"2022-06-30"]
["Philanthropic/Other Funds",null,null,null,null,"See Enterprise policies for report submission"]
["Activity Name",null,null,"HCD Award Amount\nDo not include philanthropic/other funds","Amount of Award Expended\nDo not include philanthropic/other funds","Proof of Expenditure Attached?","Percent Expended","Amount of Award Remaining"]
["*Capitalized operating subsidies for units purchased, converted or altered",null,null,null,null,null,{"$f":"IFERROR(E23/D23,0)","v":0},{"$f":"D23-E23","v":0}]
["Acquisition or rehabilitation of motels, hotels, or hostels",null,null,null,null,null,{"$f":"IFERROR(E24/D24,0)","v":0},{"$f":"D24-E24","v":0}]
["Master leasing of properties",null,null,null,null,null,0,0]
["Acquisition of other sites and assets",null,null,null,null,null,0,0]
["Conversion of units from nonresidential to residential",null,null,null,null,null,0,0]
["Purchase of affordability covenants and restrictions for units",null,null,null,null,null,0,0]
["Relocation costs for individuals who are being displaced",null,null,null,null,null,0,0]
["TOTAL",null,null,{"$f":"IF(SUM(D23:D29)=SUM(D19:E20), SUM(D23:D29), \"ERROR\")","v":0},{"$f":"SUM(E23:E29)","v":0},null,0,0]
["DOCUMENTATION"]
["Requirement",null,null,null,null,"Attachment Included? ","Has this document been amended since last submission?","Affordability Covenant Expiration Date"]
["Recordation of current version of 55 year affordability covenant (pursuant to NOFA §305 ii, permanent housing projects only) "]
["Recordation of 10 year use restriction (pursuant to Standard Agreement Exhibit D 23. & Exhibit E 6., interim housing projects only)."]
["Supportive Services Plan, if required (pursuant to Standard Agreement Exhibit D 16.) "]
["CERTIFICATION"]
["Sponsor agrees to employ the core components of Housing First in the property management and tenant selection process (pursuant to NOFA §310) "]
["Would the Sponsor like any Technical Assistance or opportunity to discuss any part of this Report with Department staff?  "]
["***By signing this request, I certify to the best of my knowledge and belief that the request is true, complete, and accurate, and the expenditures, disbursements and cash receipts will be  for the purposes and objectives set forth in the terms and conditions of the State award. I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise. (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812)"]
["Signature Method: ",null,"Select One"]
["    Name of Authorized Representative",null,null,null,"      Title of Authorized Representative"]
[]
["    Signature of Authorized Representative",null,null,null,null,"     Date"]
[]
["HCD USE ONLY"]
["Signature Method: ",null,"Select One"]
["     HCD SGM Representative Signature                                                                ",null,null,null,null,"     Date"]
[]
["Signature Method: ",null,"Select One"]
["     HCD SGM Manager Signature                                                                ",null,null,null,null,"     Date"]

{"sheet":"Report Narrative","index":2,"n_rows":157,"n_cols":3,"rows_kept":157,"cut":false,"hidden":false,"merged":[[156,0,156,2],[157,0,157,2],[155,0,155,2],[153,0,153,2],[152,0,152,1],[141,0,141,2],[138,0,138,2],[139,0,139,2],[142,0,142,2],[143,0,143,2],[144,0,144,2],[145,0,145,2],[154,0,154,2],[150,0,150,2],[151,0,151,2],[146,0,146,2],[148,0,148,2],[149,0,149,2],[147,0,147,2],[1,0,1,2],[140,0,140,2],[127,0,127,2],[128,1,128,2],[129,1,129,2],[124,1,124,2],[125,1,125,2],[131,1,131,2],[135,1,135,2],[136,1,136,2],[137,1,137,2],[134,1,134,2],[132,1,132,2],[133,1,133,2]]}
["Beginning of Sheet 2: Report Narrative"]
["HOMEKEY PROGRAM\nReport Narrative"]
["Sponsor and Contract:",{"$f":"'Expenditure Report'!B13","v":0},{"$f":"'Expenditure Report'!B12","v":0}]
["Scattered Sites: How many unique sites are receiving Homekey funds for this project?","Select One"]
["Project Site Street Address (cell B5), City and Zip Code (C5)                                          (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B6,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed (cell B7) and Source of Match (cell C7) (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired (cell B8) and indicate whether this was a Project Roomkey site (cell C8)",null,"Select One"]
["Housing Type (cell B9) and Number of Units created (cell C9)","Select One"]
["Unit Design (cell B10) and Date of Substantial Occupancy \n(50%+ occupied) (cell C10) ","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B12,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B18,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B24,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B30,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B36,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B42,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B48,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B54,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B60,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B66,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B72,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B78,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B84,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B90,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B96,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B102,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B108,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B114,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Project Site Street Address and City                                                             (pursuant to NOFA §402 ii.):"]
["County and Geographic Region:","Select One",{"$f":"VLOOKUP(B120,'Drop-Down'!$A$7:$B$66, 2, FALSE)","v":"Geographic Region"}]
["Amount of Match Contributed and Source of Match (pursuant to NOFA §203)"]
["Identify the Number of Doors (rooms) at the site when acquired and indicate whether this was a Project Roomkey site.",null,"Select One"]
["Housing Type and Number of Units created","Select One"]
["Unit Design and Date of Substantial Occupancy","Select One"]
["Total Number of useable housing units produced using Program funds (pursuant to NOFA §402 iii.):",{"$f":"(C9+C15+C21+C27+C33+C39+C45+C51+C57+C63+C69+C75+C81+C87+C93+C99+C105+C111+C117+C123)","v":0}]
["Total Number of Doors converted (how many rooms in hotels prior to rehabilitation or conversion)\n",{"$f":"SUM(B8+B14+B20+B26+B32+B38+B44+B50+B56+B62+B68+B74+B80+B86+B92+B98+B104+B110+B116+B122)","v":0}]
[]
["1. Complete the following information in regards to participants housed using Homekey funds."]
["Prompt","Response"]
["A. Does this project serve individuals and families who are homeless or at risk of homelessness?","Select One"]
["B. Please input the number of units currently occupied",null,{"$f":"IFERROR(B131/B125,\"\")","v":""}]
["C. Total number of individuals housed using Program Funds. Include all individuals in household. (pursuant to NOFA §402 iv.):"]
["i. How many individuals are housed in Permanent Housing units? "]
["ii. How many individuals are housed in Interim Housing Units? "]
["Describe the anticipated turnover and plan for permanent housing placements. "]
["iii. Of individuals housed, total number of Minor Children (ages 17 and under) if available:"]
["iv. Of individuals housed, total number of Transition-Age Youth (ages 18-24) if available:"]
["v. Of individuals housed, total number of Seniors (age 65 and older) if available:"]
["2. Describe on-site and off-site supportive services made available to participants."]
[]
["3. Describe any lessons learned from the use of the Homekey funds (pursuant to NOFA §402 vi.). Include any barriers faced when trying to reach expected occupancy."]
[]
["4. Describe the proposed development vision that identifies the financial and regulatory mechanisms to be used to maintain the long-term affordability of the project (pursuant to NOFA §402 vii.)."]
[]
["     4a. Has your proposed development vision changed since you submitted your application? If yes, please explain. If your plan includes converting interim to permanent housing, please include your vision to achieve this. "]
[]
["5. Describe progress and status in securing required entitlements, permits and environmental clearances (pursuant to NOFA §402 viii.)."]
[]
["6. Provide the proposed timeline for the completion of the Project (pursuant to NOFA §402 ix.). Include anticipated or actual dates of property acquisition and completion for other performance milestones as listed in Exhibit E of the Standard Agreement."]
[]
["7. Discuss the most important factors that influenced the proposed project design, including factors such as local conditions, target population, organizational capacity, conformity with applicable local plans and land use requirements, etc. "]
[]
["8. Is Coordinated Entry being used for referrals? If yes, are there any lessons learned in the use of Coordinated Entry for Homekey Participants?",null,"Select One"]
[]
["9. Is there anything you would do differently if pursuing this strategy again? What parts of the Technical Assistance offered by the Department were helpful and what could be improved upon?"]
[]
["10. Please share any success stories you've had from Homekey-funded projects.\nOptional: Grantee may send attachments and photos to HomekeySGM@hcd.ca.gov"]

{"sheet":"Equity Strategies","index":3,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,0,4,10],[5,0,5,10],[7,0,7,10],[1,0,1,10],[2,0,2,10],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10]]}
["beginning of sheet 3: Equity Strategies Update"]
["HOMEKEY PROGRAM\nEquity Strategies Update"]
["\"The Sponsor shall, at the request of the Department, report back on any racial equity strategies described in the Homekey Application.\" Standard Agreement, Exhibit E, Section 5 \n"]
["HCD Contract Number:",{"$f":"'Expenditure Report'!B12","v":0},null,"Sponsor Name: ",null,{"$f":"'Expenditure Report'!B13","v":0},null,"Reporting Period:",null,{"$f":"'Expenditure Report'!B16","v":0}]
["Please explain how your Homekey project is advancing racial equity and inclusion. Include detail about the primary racial demographic of participants served by your projects, how outreach was carried out, and how the targeted population reflects or doesn't reflect that of the broader homeless population in your community (pursuant to Standard Agreement Exhibit E, §5.)"]
[]
[]
["Racial and Ethnic Composition of Tenants Assisted by Homekey\nInstructions: Use rows 9-23 to list tenants served in the last 6 month reporting period by each Homekey project site. In the bottom row under the totals (Row 26), input the number of clients by the column identifier included in your local HMIS database across all programs (not only Homekey) from the last 6 month period."]
["Project Site","Total Number of Participants Served in 6 month reporting period","Number of American Indian or Alaska Native Participants Served","Number of Asian Participants Served","Number of Black/African American Participants served","Number of Native Hawaiian/Other Pacific Islander Participants Served","Number of White Participants Served","Number of Participants whose race is unknown, or declined to state","How Many Participants Served were Hispanic/Latino? ","How Many Participants were Not Hispanic/Latino?","Is Homekey tenant information input into Sponsor's local HMIS system? "]
[{"$f":"'Report Narrative'!B5","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B11","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B17","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B23","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B29","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B35","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B41","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B47","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B53","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B59","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B65","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B71","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B77","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B83","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Report Narrative'!B89","v":0},null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Operating Subsidy'!A23","v":"TOTAL: "},{"$f":"SUM(B10:B24)","v":0},0,0,0,0,0,0,0,0]
["Total Number of Total Clients in Local HMIS System"]

{"sheet":"Operating Subsidy","index":4,"n_rows":45,"n_cols":24,"rows_kept":45,"cut":false,"hidden":false,"merged":[[34,0,34,1],[31,6,31,7],[24,0,24,10],[25,0,25,10],[33,8,33,10],[34,8,34,10],[32,6,32,7],[33,6,33,7],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[32,8,32,10],[37,0,37,12],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[30,6,30,7],[5,12,5,14],[28,8,28,10],[29,8,29,10],[30,8,30,10],[31,8,31,10],[5,15,5,16],[34,6,34,7],[36,0,36,12],[1,0,1,23],[0,1,0,23],[6,17,6,18],[2,0,2,23],[5,4,5,6],[26,8,26,10],[27,8,27,10],[3,0,3,23],[5,8,5,11],[4,5,4,7],[4,0,4,1],[4,2,4,3],[4,9,4,15]]}
["Beginning of Sheet 4: Operating Subsidy "]
["HOMEKEY PROGRAM\nOperating Subsidy and Services Provided"]
[{"$f":"IF('Expenditure Report'!D23<1,\"No projects received capitalized operating subsidy funds. Please do not fill out this form.\",\"As a recipient of State General Fund capitalized operating subsidy funds, you must fill out this form to maintain program eligibility. Please include philanthropic funds received under 'Sponsor Matching Share' column only\")","v":"No projects received capitalized operating subsidy funds. Please do not fill out this form."}]
["Instructions: Fill out the following three tables on Operating Subsidy Finances by project, Supportive Services Details, and Racial and Ethnic Composition of Tenants Served by each Project."]
["First Month Utilizing Operating Subsidy:",null,"Select One",null,"Sponsor:",{"$f":"'Expenditure Report'!$B$13","v":0},null,null,"Reporting Period:",{"$f":"'Expenditure Report'!B16","v":0}]
["Project Site Street Address","Project Site City, State, Zip","County","Number of Assisted Units ","Total Administrative Costs Expended",null,null,"Total Utilities Costs Expended","Total Maintenance Costs Expended",null,null,null,"Total Supportive Services Costs Expended ",null,null,"Total Taxes and Insurance Costs Expended",null,"Sponsor Matching Share\n(include philanthropic funds if applicable)","Match Source(s)","Total Operating Expenses","Average Monthly Operating Cost","Average Monthly Operating Cost Per Assisted Unit","Average Supportive Services Monthly Cost ","Average Supportive Services Monthly Cost Per Unit"]
[null,null,null,null,"Office Salaries","Property Management","Other",null,"Payroll","Repairs and Maintenance","Security Payroll","Other","Case Management \n(salary and benefits) ","Services Provided\n(must itemize below)","Other \n(must describe below) ","Taxes","Insurance","Refer to §303 of the NOFA for information on match requirements"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:Q8)","v":0},{"$f":"T8/DATEDIF($C$5,\"7/2021\",\"M\")","v":{"$error":"#VALUE!"}},{"$f":"U8/D8","v":{"$error":"#VALUE!"}},{"$f":"(M8+O8)/DATEDIF($C$5,\"7/2021\",\"M\")","v":{"$error":"#VALUE!"}},{"$f":"W8/D8","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"T9/DATEDIF($C$5,\"7/2021\",\"M\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"(M9+O9)/DATEDIF($C$5,\"7/2021\",\"M\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["TOTAL: ",null,null,{"$f":"SUM(D8:D22)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O8:O22)","v":0},{"$f":"SUM(P8:P22)","v":0},{"$f":"SUM(Q8:Q22)","v":0},{"$f":"SUM(R8:R22)","v":0},null,{"$f":"SUM(T8:T22)","v":0},{"$f":"AVERAGEIF(U8:U22,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIF(V8:V22,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"(M23+O23)/DATEDIF($C$5,\"6/30/2021\",\"M\")","v":{"$error":"#VALUE!"}},{"$f":"AVERAGEIF(X8:X22,\">0\")","v":{"$error":"#DIV/0!"}}]
[]
["Supportive Services Itemization and Detail"]
["Instructions: Specify the type of supportive services provided to Homekey participants, the demographics of participants supported, and whether services were provide on or off-site. If specified service was provided at multiple project locations, include each separated by commas."]
["Types of Supportive Services provided to Homekey participants",null,"On-Site or Off-Site","If \"Other\" Selected, Please Explain",null,"Total Cost of Service for all locations over 6 Month Reporting Period","Project Sites where Service was provided \n(select all that apply)",null,"Additional Comments"]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
["COSR Match Five Year Schedule"]
["Eligible Applicants are required to demonstrate a five-year commitment to provide operating funds for the proposed projects. The first two years of operating funds may include an award from the $50 million in state General Fund (Homekey NOFA §303). The table below is an estimated schedule of expenses across all projects based on the Sponsor Matching Share submitted."]
["HCD COSR Award:",{"$f":"'Expenditure Report'!D23","v":0},"Sponsor Matching Share:",{"$f":"R23","v":0},"Total COSR:",{"$f":"B39+D39","v":0}]
[{"$f":"'Expenditure Report'!D23","v":0},"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
["Year 1",{"$f":"R23+B39","v":0},{"$f":"B41-$U$23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"D41-$U$23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"F41-$U$23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Year 2",{"$f":"M41-$U$23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Year 3",{"$f":"M42-$U$23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Year 4",{"$f":"M43-$U$23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Year 5",{"$f":"M44-$U$23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Project Summary","index":5,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":true,"merged":[[55,1,55,3],[55,4,55,7],[55,8,55,10],[66,8,66,10],[67,8,67,10],[2,9,2,10],[4,9,4,10],[3,9,3,10],[5,9,5,10],[51,8,51,10],[52,8,52,10],[53,8,53,10],[27,8,27,10],[28,8,28,10],[29,8,29,10],[30,8,30,10],[31,8,31,10],[60,8,60,10],[61,8,61,10],[62,8,62,10],[63,8,63,10],[64,8,64,10],[65,8,65,10],[40,8,40,10],[45,8,45,10],[46,8,46,10],[47,8,47,10],[48,8,48,10],[20,6,20,7],[6,9,6,10],[7,9,7,10],[1,0,1,10],[20,8,20,10],[11,8,11,10],[19,6,19,7],[12,8,12,10],[10,8,10,10],[13,8,13,10],[15,8,15,10],[16,8,16,10],[18,8,18,10],[19,8,19,10],[11,6,11,7],[39,8,39,10],[24,0,24,2],[23,0,23,2],[22,0,22,3],[41,8,41,10],[0,0,0,10],[44,8,44,10],[32,8,32,10],[33,8,33,10],[34,8,34,10],[35,8,35,10],[36,8,36,10],[21,0,21,10],[26,0,26,10],[23,8,23,10],[24,8,24,10],[25,8,25,10],[22,8,22,10],[8,5,8,6],[8,7,8,8],[9,5,9,6],[7,7,7,8],[9,7,9,8],[9,9,9,10],[15,0,15,1],[15,6,15,7],[11,0,11,1],[11,2,11,3],[11,4,11,5],[12,2,12,3],[13,2,13,3],[13,0,13,1],[14,0,14,1],[14,4,14,5],[13,6,13,7],[9,13,9,14],[12,4,12,5],[14,8,14,10],[14,2,14,3],[14,6,14,7],[2,5,2,6],[2,2,2,4],[2,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,8],[4,0,5,1],[6,2,6,4],[7,2,7,4],[6,0,9,1],[8,2,8,4],[9,2,9,4],[5,2,5,4],[4,5,4,6],[4,7,4,8],[5,5,5,6],[5,7,5,8],[6,5,6,6],[7,5,7,6],[6,7,6,8],[4,2,4,4],[2,7,2,8],[8,9,8,10],[34,0,34,1],[35,0,35,1],[46,4,46,7],[47,4,47,7],[48,4,48,7],[36,0,36,1],[27,0,27,3],[28,0,28,1],[27,4,27,7],[22,4,22,7],[44,0,44,7],[45,4,45,7],[29,0,29,1],[30,0,30,1],[31,0,31,1],[12,0,12,1],[15,2,15,3],[13,4,13,5],[15,4,15,5],[10,0,10,7],[12,6,12,7],[18,4,18,5],[19,4,19,5],[65,0,65,3],[66,0,66,3],[67,0,67,3],[16,0,16,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[16,2,16,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[40,0,40,1],[45,1,45,3],[32,0,32,1],[33,0,33,1],[58,0,58,3],[48,1,48,3],[46,1,46,3],[51,1,51,3],[50,1,50,3],[47,1,47,3],[49,1,49,3],[54,1,54,3],[25,0,25,2],[52,1,52,3],[20,4,20,5],[41,0,41,1],[63,0,63,3],[64,0,64,3],[54,4,54,7],[59,0,59,3],[61,0,61,3],[62,0,62,3],[52,4,52,7],[53,4,53,7],[50,4,50,7],[51,4,51,7],[49,4,49,7],[56,0,56,10],[57,0,57,3],[53,1,53,3],[60,0,60,3],[54,8,54,10],[57,8,57,10],[58,8,58,10],[59,8,59,10],[49,8,49,10],[50,8,50,10],[16,6,16,7],[18,6,18,7],[37,0,37,7],[37,8,37,10],[39,0,39,1],[43,8,43,10],[41,2,41,3],[42,2,42,3],[43,0,43,1],[42,0,42,1],[39,6,39,7],[40,6,40,7],[38,0,38,1],[38,6,38,7],[38,8,38,10],[43,2,43,3],[17,0,17,1],[17,4,17,5],[17,2,17,3],[17,8,17,10],[17,6,17,7],[16,4,16,5],[42,8,42,10]]}
["Homekey Annual Report Summary\nFor HCD Staff Only"]
["1. General Information"]
["Rep Information",null,"Reviewing Rep Name",null,null,"Review Start Date",null,"Review End Date",null,"Comments"]
[]
["Manager Information",null,"Reviewing Manager Name",null,null,"Review Start Date",null,"Review End Date",null,"Comments"]
[]
["General Applicant Information",null,"Sponsor Name",null,null,"Contract #",null,"HCD Award Amount",null,"Sponsor Address"]
[null,null,{"$f":"'Expenditure Report'!B13","v":0},null,null,{"$f":"'Expenditure Report'!B12","v":0},null,{"$f":"'Expenditure Report'!D30","v":0},null,{"$f":"_xlfn.CONCAT('Expenditure Report'!B14,\", \",'Expenditure Report'!B15)","v":", "}]
[null,null,"Preparer Name and Title",null,null,"Preparer Email",null,"Preparer Phone Number",null,"Reporting Period:"]
[null,null,{"$f":"_xlfn.CONCAT('Expenditure Report'!F12, \", \",'Expenditure Report'!F13)","v":", "},null,null,{"$f":"'Expenditure Report'!F14","v":0},null,{"$f":"'Expenditure Report'!F15","v":0},null,{"$f":"'Expenditure Report'!B16","v":0}]
["2. Project Overview",null,null,null,null,null,null,null,"Rep Notes"]
["CRF Funds Awarded",null,{"$f":"'Expenditure Report'!D19","v":0},null,"SGF Funds Awarded",null,{"$f":"'Expenditure Report'!D20","v":0}]
["Project County:",null,{"$f":"'Report Narrative'!B6","v":"Select One"},null,"Project Region:",null,{"$f":"'Report Narrative'!C6","v":"Geographic Region"}]
["# Useable Housing Units Produced:",null,{"$f":"'Report Narrative'!B125","v":0},null,"# of Project Sites Receiving Funding:",null,{"$f":"'Report Narrative'!B4","v":"Select One"}]
["# of Units Occupied",null,{"$f":"'Report Narrative'!B131","v":0},null,"% Occupancy",null,{"$f":"'Report Narrative'!C131","v":""}]
["# of Project Sites Receiving Operating Subsidy:",null,{"$f":"COUNTA('Operating Subsidy'!A8:A22)","v":0},null,"# of Units utilizing or planned for Capitalized Operating Subsidy: ",null,{"$f":"'Operating Subsidy'!D23","v":0}]
["# of Project Roomkey Sites:",null,{"$f":"COUNTIF('Report Narrative'!C5:C131,\"Project Roomkey Site\")","v":0},null,"# Doors originally acquired:",null,{"$f":"'Report Narrative'!B126","v":0}]
["§203 Matching Funds Contributed:",null,{"$f":"SUM('Report Narrative'!B7,'Report Narrative'!B13,'Report Narrative'!B19,'Report Narrative'!B25,'Report Narrative'!B31,'Report Narrative'!B37,'Report Narrative'!B43,'Report Narrative'!B49,'Report Narrative'!B55,'Report Narrative'!B61,'Report Narrative'!B67,'Report Narrative'!B73,'Report Narrative'!B79,'Report Narrative'!B85,'Report Narrative'!B91,'Report Narrative'!B97,'Report Narrative'!B103,'Report Narrative'!B109,'Report Narrative'!B115,'Report Narrative'!B121)","v":0},null,"Matching Funds Required"]
["Cost per Unit",null,{"$f":"(C18+C12)/C14","v":{"$error":"#DIV/0!"}},null,"Cost per Door",null,{"$f":"(C18+C12)/G17","v":{"$error":"#DIV/0!"}}]
["Total Number of Individuals Housed",null,{"$f":"'Report Narrative'!B132","v":0},null,"Number of Projects at Substantial Occupancy:",null,{"$f":"COUNTIF('Report Narrative'!$C$5:$C$124,\">11/1/2020\")","v":0}]
["Does Sponsor use Coordinated Entry for Referrals?",null,{"$f":"'Report Narrative'!C153","v":"Select One"},null,"Philanthropic Funds Awarded",null,{"$f":"'Expenditure Report'!D21","v":0}]
["3. Individuals Housed and Unit Information"]
["Optional Individual Information",null,null,null,"Housing Type Information",null,null,null,"Rep Notes"]
["Number of Minor Children (ages 0-17) housed:",null,null,{"$f":"'Report Narrative'!B136","v":0},"Number of Interim Housing Units Created:",{"$f":"(SUMIF('Report Narrative'!$B$5:$B$130,\"Interim Housing\",'Report Narrative'!$C$5:$C$130))","v":0},"Number of Projects with Factory-Built Units:",{"$f":"COUNTIF('Report Narrative'!$B$5:$B$124,\"Factory Built\")","v":0}]
["Number of TAY (ages 18-24) housed: ",null,null,{"$f":"'Report Narrative'!B137","v":0},"Number of Permanent Housing Units Created:",{"$f":"(SUMIF('Report Narrative'!$B$5:$B$130,\"Permanent Housing\",'Report Narrative'!$C$5:$C$130))","v":0},"Number of Projects with Manufactured Units:",{"$f":"COUNTIF('Report Narrative'!$B$5:$B$124,\"Manufactured\")","v":0}]
["Number of Seniors (age 65+) housed:",null,null,{"$f":"'Report Narrative'!B138","v":0},"Number of Interim to Permanent Converted Units:",{"$f":"(SUMIF('Report Narrative'!$B$5:$B$130,\"Interim to Permanent Conversion\",'Report Narrative'!$C$5:$C$130))","v":0},"Number of Projects with Existing Remodeled Units: ",{"$f":"COUNTIF('Report Narrative'!$B$5:$B$124,\"Existing Remodeled\")","v":0}]
["4. Expenditure Information"]
["Project Expenditures",null,null,null,"Operating Subsidy Costs",null,null,null,"Rep Notes"]
["Category",null,"Amount Awarded","Amount Expended","Category","Total Spent this Reporting Period","Average Monthly Expenditure ","Average Monthly Expenditure Per Unit"]
["Capitalized operating subsidies for units purchased, converted or altered:",null,{"$f":"'Expenditure Report'!D24","v":0},{"$f":"'Expenditure Report'!E23","v":0},"Admin Costs:",{"$f":"'Operating Subsidy'!E23+'Operating Subsidy'!F23+'Operating Subsidy'!G23","v":0},{"$f":"F30/(DATEDIF('Operating Subsidy'!$C$5,\"6/2021\",\"M\"))","v":{"$error":"#VALUE!"}},{"$f":"G30/$G$16","v":{"$error":"#VALUE!"}}]
["Acquisition or rehabilitation of motels, hotels, or hostels:",null,{"$f":"'Expenditure Report'!D24","v":0},{"$f":"'Expenditure Report'!E24","v":0},"Utilities:",{"$f":"'Operating Subsidy'!H23","v":0},{"$f":"F31/(DATEDIF('Operating Subsidy'!$C$5,\"6/2021\",\"M\"))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["Master leasing of properties:",null,{"$f":"'Expenditure Report'!D25","v":0},{"$f":"'Expenditure Report'!E25","v":0},"Maintenance Costs:",{"$f":"'Operating Subsidy'!I23+'Operating Subsidy'!J23+'Operating Subsidy'!K23+'Operating Subsidy'!L23","v":0},{"$f":"F32/(DATEDIF('Operating Subsidy'!$C$5,\"6/2021\",\"M\"))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["Acquisition of other sites and assets:",null,{"$f":"'Expenditure Report'!D26","v":0},{"$f":"'Expenditure Report'!E26","v":0},"Supportive Services, Case Management:",{"$f":"'Operating Subsidy'!M8","v":0},{"$f":"F33/(DATEDIF('Operating Subsidy'!$C$5,\"6/2021\",\"M\"))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["Conversion of units from nonresidential to residential:",null,{"$f":"'Expenditure Report'!D27","v":0},{"$f":"'Expenditure Report'!E27","v":0},"Supportive Services, Service Provision",{"$f":"'Operating Subsidy'!N8","v":0},{"$f":"F34/(DATEDIF('Operating Subsidy'!$C$5,\"6/2021\",\"M\"))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["Purchase of affordability covenants and restrictions for units:",null,{"$f":"'Expenditure Report'!D28","v":0},{"$f":"'Expenditure Report'!E28","v":0},"Supportive Services, Other",{"$f":"'Operating Subsidy'!O8","v":0},{"$f":"F35/(DATEDIF('Operating Subsidy'!$C$5,\"6/2021\",\"M\"))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["Relocation costs for individuals who are being displaced:",null,{"$f":"'Expenditure Report'!D29","v":0},{"$f":"'Expenditure Report'!E29","v":0},"Taxes and Insurance:",{"$f":"'Operating Subsidy'!P23+'Operating Subsidy'!Q23","v":0},{"$f":"F36/(DATEDIF('Operating Subsidy'!$C$5,\"6/2021\",\"M\"))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["Total:",null,{"$f":"'Expenditure Report'!D30","v":0},{"$f":"'Expenditure Report'!E30","v":0},"Total:",{"$f":"'Operating Subsidy'!T23","v":0},{"$f":"'Operating Subsidy'!U23","v":{"$error":"#DIV/0!"}},{"$f":"'Operating Subsidy'!V23","v":{"$error":"#DIV/0!"}}]
["5. Operating Subsidy Outlook",null,null,null,null,null,null,null,"Rep Notes"]
["Sites Receiving COSR",null,{"$f":"COUNTA('Operating Subsidy'!A8:A22)","v":0},"# Units Receiving COSR",{"$f":"'Operating Subsidy'!D23","v":0},"Starting Month of COSR",{"$f":"'Operating Subsidy'!C5","v":"Select One"}]
["COSR Awarded:",null,{"$f":"'Expenditure Report'!D23","v":0},"Sponsor Matching Share per NOFA 303",{"$f":"'Operating Subsidy'!R8","v":0},"Total COSR:",{"$f":"SUM(C40+E40)","v":0}]
["Average Monthly Operating Cost",null,{"$f":"'Operating Subsidy'!U23","v":{"$error":"#DIV/0!"}},"Average Yearly Operating Cost",{"$f":"C41*12","v":{"$error":"#DIV/0!"}},"Approximate 5-Year Operating Cost: ",{"$f":"E41*5","v":{"$error":"#DIV/0!"}}]
["COSR Year",null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Approximate Funds Remaining by Year-End",null,{"$f":"G40-E41","v":{"$error":"#DIV/0!"}},null,{"$f":"C43-$E$41","v":{"$error":"#DIV/0!"}},{"$f":"E43-$E$41","v":{"$error":"#DIV/0!"}},{"$f":"F43-$E$41","v":{"$error":"#DIV/0!"}},{"$f":"G43-$E$41","v":{"$error":"#DIV/0!"}}]
["Types of Supportive Services Provided:",null,{"$f":"_xlfn.CONCAT('Operating Subsidy'!A28, \", \",'Operating Subsidy'!A29,\", \", 'Operating Subsidy'!A30,\", \", 'Operating Subsidy'!A31, \", \", 'Operating Subsidy'!A32,\", \",'Operating Subsidy'!A33,\", \",'Operating Subsidy'!A34,\", \",'Operating Subsidy'!A35)","v":", , , , , , , "},null,"Onsite Services:",{"$f":"COUNTIF('Operating Subsidy'!C28:C35,\"On-Site\")","v":0},"Offsite Services: ",{"$f":"COUNTIF('Operating Subsidy'!C28:C35,\"Off-Site\")","v":0}]
["6. Report Narrative",null,null,null,null,null,null,null,"Rep Notes"]
[2,"Description of Supportive Services provided:",null,null,{"$f":"'Report Narrative'!A140","v":0}]
[3,"Lessons Learned with Funds:",null,null,{"$f":"'Report Narrative'!A142","v":0}]
[4,"Proposed Development Vision:",null,null,{"$f":"'Report Narrative'!A144","v":0}]
["4a.","Changes to Proposed Development Vision: ",null,null,{"$f":"'Report Narrative'!A146","v":0}]
[5,"Progress and Status in securing required entitlements, permits, and environmental clearances:",null,null,{"$f":"'Report Narrative'!A148","v":0}]
[6,"Proposed Timeline for the completion of the project:",null,null,{"$f":"'Report Narrative'!A150","v":0}]
[7,"Explanation of how funding decisions were made for acquisition, conversion, or rehabilitation projects, or for capitalized operating subsidies:",null,null,{"$f":"'Report Narrative'!A152","v":0}]
[8,"If Coordinated Entry is being used for referrals, any lessons learned in use for program participants:",null,null,{"$f":"'Report Narrative'!A154","v":0}]
[9,"Sponsor Feedback on process and Technical Assistance provided:",null,null,{"$f":"'Report Narrative'!A156","v":0}]
[10,"Success Stories",null,null,{"$f":"'Report Narrative'!A158","v":0}]
[11,"Equity ",null,null,{"$f":"'Equity Strategies'!A6","v":0}]
["7. Special Conditions Checklist "]
["Special Condition Required by Exhibit E\n(Select from Drop-Down) ",null,null,null,"Supporting Documents Submitted? ","Compliance Deadline","Date Reminder Sent to Sponsor","Compliance Date","Rep Notes"]

{"sheet":"DataTable","index":6,"n_rows":2,"n_cols":79,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["HCD Contract Number","Sponsor Name","HCD Rep","Reporting Period","HCD CRF Award","HCD SGF Award","Total HCD Award","Philanthropic Award","Program Funds Expended","Project County","Geographic Region","10 Yr Use Recorded?","10-Yr Covenant Expiration Date","55 Yr Use Recorded?","55-Yr Covenant Expiration Date","# Useable Units Created","# Units Receiving COSR","# Project Sites Receiving COSR","Matching Funds ","Source of Match","# Roomkey Sites","# Doors Converted","# Individuals Housed","# Project Sites Funded","# Projects Occupied","Does Sponsor use CE For Referrals?","# Minor Children Housed","# TAY Housed","# Seniors Housed","# Interim Units Created","# Permanent Units Created","# Interim to Perm Units Created","# Projects w Factory Built Units","# Projects w Manufactured Units","# Projects with Existing Rehabbed Units","$ Expended COSR ","$ Expended Acquisition/Rehab of Motels/Hotels/Hostels","$ Expended on Master Leasing of Properties","$ Expended on Acquisition of other sites/assets","$ Expended on Conversion of Units","$ Expended on Purchase of Aff. Covenants","$ Expended on Relocation","$ Expended on Admin Costs","$ Expended on Utilities","$ Expended on Maintenance","$ Expended on Supportive Services","$ Expended on Taxes & Insurance","Supportive Services Provided","Description of Supportive Services","Lessons Learned","Proposed Dev Vision","Dev Vision Changes","Progress and Status securing Entitlements","Proposed Timeline for Project Completion","How Funding Decisions were Made","Lessons with CE","Equity Strategies","Sponsor Feedback","CRF Spent Per Door","Actual Cost Per Door","Actual Cost Per Unit","# Units Occupied","Subs. Occupancy Rate","Date of Occupancy","ProjectAddress1","ProjectAddress2","ProjectAddress3","ProjectAddress4","ProjectAddress5","ProjectAddress6","ProjectAddress7","ProjectAddress8","ProjectAddress9","ProjectAddress10","ProjectAddress11","ProjectAddress12","ProjectAddress13","ProjectAddress14","ProjectAddress15"]
[{"$f":"'Expenditure Report'!B12","v":0},{"$f":"'Expenditure Report'!B13","v":0},{"$f":"'Project Summary'!C4","v":0},{"$f":"'Expenditure Report'!B16","v":0},{"$f":"'Expenditure Report'!D19","v":0},{"$f":"'Expenditure Report'!D20","v":0},{"$f":"'Expenditure Report'!D30","v":0},{"$f":"'Expenditure Report'!D21","v":0},{"$f":"'Expenditure Report'!E30","v":0},{"$f":"'Project Summary'!C13","v":"Select One"},{"$f":"'Project Summary'!G13","v":"Geographic Region"},{"$f":"'Expenditure Report'!F34","v":0},{"$f":"'Expenditure Report'!H34","v":0},{"$f":"'Expenditure Report'!F33","v":0},{"$f":"'Expenditure Report'!H33","v":0},{"$f":"'Report Narrative'!B125","v":0},{"$f":"'Project Summary'!G16","v":0},{"$f":"'Project Summary'!C16","v":0},{"$f":"'Report Narrative'!B7","v":0},{"$f":"'Report Narrative'!C7","v":0},{"$f":"'Project Summary'!C17","v":0},{"$f":"'Report Narrative'!B126","v":0},{"$f":"'Report Narrative'!B132","v":0},{"$f":"'Project Summary'!G14","v":"Select One"},{"$f":"'Project Summary'!G20","v":0},{"$f":"'Project Summary'!C21","v":"Select One"},{"$f":"'Project Summary'!D24","v":0},{"$f":"'Project Summary'!D25","v":0},{"$f":"'Project Summary'!D26","v":0},{"$f":"'Project Summary'!F24","v":0},{"$f":"'Project Summary'!F25","v":0},{"$f":"'Project Summary'!F26","v":0},{"$f":"'Project Summary'!H24","v":0},{"$f":"'Project Summary'!H25","v":0},{"$f":"'Project Summary'!H26","v":0},{"$f":"'Project Summary'!D30","v":0},{"$f":"'Project Summary'!D31","v":0},{"$f":"'Project Summary'!D32","v":0},{"$f":"'Project Summary'!D33","v":0},{"$f":"'Project Summary'!D34","v":0},{"$f":"'Project Summary'!D35","v":0},{"$f":"'Project Summary'!D36","v":0},{"$f":"'Project Summary'!F30","v":0},{"$f":"'Project Summary'!F31","v":0},{"$f":"'Project Summary'!F32","v":0},{"$f":"'Project Summary'!F33","v":0},{"$f":"'Project Summary'!F36","v":0},{"$f":"'Project Summary'!C44","v":", , , , , , , "},{"$f":"'Project Summary'!E46","v":0},{"$f":"'Project Summary'!E47","v":0},{"$f":"'Project Summary'!E48","v":0},{"$f":"'Project Summary'!E49","v":0},{"$f":"'Project Summary'!E50","v":0},{"$f":"'Project Summary'!E51","v":0},{"$f":"'Project Summary'!E52","v":0},{"$f":"'Project Summary'!E53","v":0},{"$f":"'Equity Strategies'!A6","v":0},{"$f":"'Project Summary'!E54","v":0},{"$f":"E2/V2","v":{"$error":"#DIV/0!"}},{"$f":"(S2+E2)/V2","v":{"$error":"#DIV/0!"}},{"$f":"(S2+E2)/P2","v":{"$error":"#DIV/0!"}},{"$f":"'Report Narrative'!B131","v":0},{"$f":"'Report Narrative'!C131","v":""},{"$f":"'Report Narrative'!C10","v":"00:00:00"},{"$f":"_xlfn.CONCAT('Report Narrative'!B5,\", \", 'Report Narrative'!C5)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!B11, \", \", 'Report Narrative'!D11)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B17,\", \", 'Report Narrative'!$D17)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B23,\", \", 'Report Narrative'!$D23)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B29,\", \", 'Report Narrative'!$D29)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B35,\", \", 'Report Narrative'!$D35)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B41,\", \", 'Report Narrative'!$D41)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B47,\", \", 'Report Narrative'!$D47)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B53,\", \", 'Report Narrative'!$D53)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B59,\", \", 'Report Narrative'!$D59)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B65,\", \", 'Report Narrative'!$D65)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B71,\", \", 'Report Narrative'!$D71)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B77,\", \", 'Report Narrative'!$D77)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B83,\", \", 'Report Narrative'!$D83)","v":", "},{"$f":"_xlfn.CONCAT('Report Narrative'!$B89,\", \", 'Report Narrative'!$D89)","v":", "}]

{"sheet":"COSR Data","index":7,"n_rows":16,"n_cols":24,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["HCD Contract Number","Reporting Period","Project Site Street Address","Project Site City, State, Zip","County","Number of Assisted Units ","$ Admin - Office Salary","$ Admin - Prop Management","$ Admin - Other","$ Utilities","$ Maint. - Payroll","$ Maint. - Repairs/Maint.","$ Maint. - Security Pay","$ Maint.- Other","$ SS Case Management ","$ SS Services Provided","$ SS Other ","$ Taxes","$ Insurance","Total Operating Expenses","Average Monthly Operating Cost","Average Monthly Operating Cost Per Assisted Unit","Average Supportive Services Monthly Cost ","Average Supportive Services Monthly Cost Per Unit"]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A8","v":0},{"$f":"'Operating Subsidy'!B8","v":0},{"$f":"'Operating Subsidy'!C8","v":0},{"$f":"'Operating Subsidy'!D8","v":0},{"$f":"'Operating Subsidy'!E8","v":0},{"$f":"'Operating Subsidy'!F8","v":0},{"$f":"'Operating Subsidy'!G8","v":0},{"$f":"'Operating Subsidy'!H8","v":0},{"$f":"'Operating Subsidy'!I8","v":0},{"$f":"'Operating Subsidy'!J8","v":0},{"$f":"'Operating Subsidy'!K8","v":0},{"$f":"'Operating Subsidy'!L8","v":0},{"$f":"'Operating Subsidy'!M8","v":0},{"$f":"'Operating Subsidy'!N8","v":0},{"$f":"'Operating Subsidy'!O8","v":0},{"$f":"'Operating Subsidy'!P8","v":0},{"$f":"'Operating Subsidy'!Q8","v":0},{"$f":"'Operating Subsidy'!R8","v":0},{"$f":"'Operating Subsidy'!S8","v":0},{"$f":"'Operating Subsidy'!T8","v":0},{"$f":"'Operating Subsidy'!U8","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V8","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A9","v":0},{"$f":"'Operating Subsidy'!B9","v":0},{"$f":"'Operating Subsidy'!C9","v":0},{"$f":"'Operating Subsidy'!D9","v":0},{"$f":"'Operating Subsidy'!E9","v":0},{"$f":"'Operating Subsidy'!F9","v":0},{"$f":"'Operating Subsidy'!G9","v":0},{"$f":"'Operating Subsidy'!H9","v":0},{"$f":"'Operating Subsidy'!I9","v":0},{"$f":"'Operating Subsidy'!J9","v":0},{"$f":"'Operating Subsidy'!K9","v":0},{"$f":"'Operating Subsidy'!L9","v":0},{"$f":"'Operating Subsidy'!M9","v":0},{"$f":"'Operating Subsidy'!N9","v":0},{"$f":"'Operating Subsidy'!O9","v":0},{"$f":"'Operating Subsidy'!P9","v":0},{"$f":"'Operating Subsidy'!Q9","v":0},{"$f":"'Operating Subsidy'!R9","v":0},{"$f":"'Operating Subsidy'!S9","v":0},{"$f":"'Operating Subsidy'!T9","v":0},{"$f":"'Operating Subsidy'!U9","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V9","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A10","v":0},{"$f":"'Operating Subsidy'!B10","v":0},{"$f":"'Operating Subsidy'!C10","v":0},{"$f":"'Operating Subsidy'!D10","v":0},{"$f":"'Operating Subsidy'!E10","v":0},{"$f":"'Operating Subsidy'!F10","v":0},{"$f":"'Operating Subsidy'!G10","v":0},{"$f":"'Operating Subsidy'!H10","v":0},{"$f":"'Operating Subsidy'!I10","v":0},{"$f":"'Operating Subsidy'!J10","v":0},{"$f":"'Operating Subsidy'!K10","v":0},{"$f":"'Operating Subsidy'!L10","v":0},{"$f":"'Operating Subsidy'!M10","v":0},{"$f":"'Operating Subsidy'!N10","v":0},{"$f":"'Operating Subsidy'!O10","v":0},{"$f":"'Operating Subsidy'!P10","v":0},{"$f":"'Operating Subsidy'!Q10","v":0},{"$f":"'Operating Subsidy'!R10","v":0},{"$f":"'Operating Subsidy'!S10","v":0},{"$f":"'Operating Subsidy'!T10","v":0},{"$f":"'Operating Subsidy'!U10","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V10","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A11","v":0},{"$f":"'Operating Subsidy'!B11","v":0},{"$f":"'Operating Subsidy'!C11","v":0},{"$f":"'Operating Subsidy'!D11","v":0},{"$f":"'Operating Subsidy'!E11","v":0},{"$f":"'Operating Subsidy'!F11","v":0},{"$f":"'Operating Subsidy'!G11","v":0},{"$f":"'Operating Subsidy'!H11","v":0},{"$f":"'Operating Subsidy'!I11","v":0},{"$f":"'Operating Subsidy'!J11","v":0},{"$f":"'Operating Subsidy'!K11","v":0},{"$f":"'Operating Subsidy'!L11","v":0},{"$f":"'Operating Subsidy'!M11","v":0},{"$f":"'Operating Subsidy'!N11","v":0},{"$f":"'Operating Subsidy'!O11","v":0},{"$f":"'Operating Subsidy'!P11","v":0},{"$f":"'Operating Subsidy'!Q11","v":0},{"$f":"'Operating Subsidy'!R11","v":0},{"$f":"'Operating Subsidy'!S11","v":0},{"$f":"'Operating Subsidy'!T11","v":0},{"$f":"'Operating Subsidy'!U11","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V11","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A12","v":0},{"$f":"'Operating Subsidy'!B12","v":0},{"$f":"'Operating Subsidy'!C12","v":0},{"$f":"'Operating Subsidy'!D12","v":0},{"$f":"'Operating Subsidy'!E12","v":0},{"$f":"'Operating Subsidy'!F12","v":0},{"$f":"'Operating Subsidy'!G12","v":0},{"$f":"'Operating Subsidy'!H12","v":0},{"$f":"'Operating Subsidy'!I12","v":0},{"$f":"'Operating Subsidy'!J12","v":0},{"$f":"'Operating Subsidy'!K12","v":0},{"$f":"'Operating Subsidy'!L12","v":0},{"$f":"'Operating Subsidy'!M12","v":0},{"$f":"'Operating Subsidy'!N12","v":0},{"$f":"'Operating Subsidy'!O12","v":0},{"$f":"'Operating Subsidy'!P12","v":0},{"$f":"'Operating Subsidy'!Q12","v":0},{"$f":"'Operating Subsidy'!R12","v":0},{"$f":"'Operating Subsidy'!S12","v":0},{"$f":"'Operating Subsidy'!T12","v":0},{"$f":"'Operating Subsidy'!U12","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V12","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A13","v":0},{"$f":"'Operating Subsidy'!B13","v":0},{"$f":"'Operating Subsidy'!C13","v":0},{"$f":"'Operating Subsidy'!D13","v":0},{"$f":"'Operating Subsidy'!E13","v":0},{"$f":"'Operating Subsidy'!F13","v":0},{"$f":"'Operating Subsidy'!G13","v":0},{"$f":"'Operating Subsidy'!H13","v":0},{"$f":"'Operating Subsidy'!I13","v":0},{"$f":"'Operating Subsidy'!J13","v":0},{"$f":"'Operating Subsidy'!K13","v":0},{"$f":"'Operating Subsidy'!L13","v":0},{"$f":"'Operating Subsidy'!M13","v":0},{"$f":"'Operating Subsidy'!N13","v":0},{"$f":"'Operating Subsidy'!O13","v":0},{"$f":"'Operating Subsidy'!P13","v":0},{"$f":"'Operating Subsidy'!Q13","v":0},{"$f":"'Operating Subsidy'!R13","v":0},{"$f":"'Operating Subsidy'!S13","v":0},{"$f":"'Operating Subsidy'!T13","v":0},{"$f":"'Operating Subsidy'!U13","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V13","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A14","v":0},{"$f":"'Operating Subsidy'!B14","v":0},{"$f":"'Operating Subsidy'!C14","v":0},{"$f":"'Operating Subsidy'!D14","v":0},{"$f":"'Operating Subsidy'!E14","v":0},{"$f":"'Operating Subsidy'!F14","v":0},{"$f":"'Operating Subsidy'!G14","v":0},{"$f":"'Operating Subsidy'!H14","v":0},{"$f":"'Operating Subsidy'!I14","v":0},{"$f":"'Operating Subsidy'!J14","v":0},{"$f":"'Operating Subsidy'!K14","v":0},{"$f":"'Operating Subsidy'!L14","v":0},{"$f":"'Operating Subsidy'!M14","v":0},{"$f":"'Operating Subsidy'!N14","v":0},{"$f":"'Operating Subsidy'!O14","v":0},{"$f":"'Operating Subsidy'!P14","v":0},{"$f":"'Operating Subsidy'!Q14","v":0},{"$f":"'Operating Subsidy'!R14","v":0},{"$f":"'Operating Subsidy'!S14","v":0},{"$f":"'Operating Subsidy'!T14","v":0},{"$f":"'Operating Subsidy'!U14","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V14","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A15","v":0},{"$f":"'Operating Subsidy'!B15","v":0},{"$f":"'Operating Subsidy'!C15","v":0},{"$f":"'Operating Subsidy'!D15","v":0},{"$f":"'Operating Subsidy'!E15","v":0},{"$f":"'Operating Subsidy'!F15","v":0},{"$f":"'Operating Subsidy'!G15","v":0},{"$f":"'Operating Subsidy'!H15","v":0},{"$f":"'Operating Subsidy'!I15","v":0},{"$f":"'Operating Subsidy'!J15","v":0},{"$f":"'Operating Subsidy'!K15","v":0},{"$f":"'Operating Subsidy'!L15","v":0},{"$f":"'Operating Subsidy'!M15","v":0},{"$f":"'Operating Subsidy'!N15","v":0},{"$f":"'Operating Subsidy'!O15","v":0},{"$f":"'Operating Subsidy'!P15","v":0},{"$f":"'Operating Subsidy'!Q15","v":0},{"$f":"'Operating Subsidy'!R15","v":0},{"$f":"'Operating Subsidy'!S15","v":0},{"$f":"'Operating Subsidy'!T15","v":0},{"$f":"'Operating Subsidy'!U15","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V15","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A16","v":0},{"$f":"'Operating Subsidy'!B16","v":0},{"$f":"'Operating Subsidy'!C16","v":0},{"$f":"'Operating Subsidy'!D16","v":0},{"$f":"'Operating Subsidy'!E16","v":0},{"$f":"'Operating Subsidy'!F16","v":0},{"$f":"'Operating Subsidy'!G16","v":0},{"$f":"'Operating Subsidy'!H16","v":0},{"$f":"'Operating Subsidy'!I16","v":0},{"$f":"'Operating Subsidy'!J16","v":0},{"$f":"'Operating Subsidy'!K16","v":0},{"$f":"'Operating Subsidy'!L16","v":0},{"$f":"'Operating Subsidy'!M16","v":0},{"$f":"'Operating Subsidy'!N16","v":0},{"$f":"'Operating Subsidy'!O16","v":0},{"$f":"'Operating Subsidy'!P16","v":0},{"$f":"'Operating Subsidy'!Q16","v":0},{"$f":"'Operating Subsidy'!R16","v":0},{"$f":"'Operating Subsidy'!S16","v":0},{"$f":"'Operating Subsidy'!T16","v":0},{"$f":"'Operating Subsidy'!U16","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V16","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A17","v":0},{"$f":"'Operating Subsidy'!B17","v":0},{"$f":"'Operating Subsidy'!C17","v":0},{"$f":"'Operating Subsidy'!D17","v":0},{"$f":"'Operating Subsidy'!E17","v":0},{"$f":"'Operating Subsidy'!F17","v":0},{"$f":"'Operating Subsidy'!G17","v":0},{"$f":"'Operating Subsidy'!H17","v":0},{"$f":"'Operating Subsidy'!I17","v":0},{"$f":"'Operating Subsidy'!J17","v":0},{"$f":"'Operating Subsidy'!K17","v":0},{"$f":"'Operating Subsidy'!L17","v":0},{"$f":"'Operating Subsidy'!M17","v":0},{"$f":"'Operating Subsidy'!N17","v":0},{"$f":"'Operating Subsidy'!O17","v":0},{"$f":"'Operating Subsidy'!P17","v":0},{"$f":"'Operating Subsidy'!Q17","v":0},{"$f":"'Operating Subsidy'!R17","v":0},{"$f":"'Operating Subsidy'!S17","v":0},{"$f":"'Operating Subsidy'!T17","v":0},{"$f":"'Operating Subsidy'!U17","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V17","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A18","v":0},{"$f":"'Operating Subsidy'!B18","v":0},{"$f":"'Operating Subsidy'!C18","v":0},{"$f":"'Operating Subsidy'!D18","v":0},{"$f":"'Operating Subsidy'!E18","v":0},{"$f":"'Operating Subsidy'!F18","v":0},{"$f":"'Operating Subsidy'!G18","v":0},{"$f":"'Operating Subsidy'!H18","v":0},{"$f":"'Operating Subsidy'!I18","v":0},{"$f":"'Operating Subsidy'!J18","v":0},{"$f":"'Operating Subsidy'!K18","v":0},{"$f":"'Operating Subsidy'!L18","v":0},{"$f":"'Operating Subsidy'!M18","v":0},{"$f":"'Operating Subsidy'!N18","v":0},{"$f":"'Operating Subsidy'!O18","v":0},{"$f":"'Operating Subsidy'!P18","v":0},{"$f":"'Operating Subsidy'!Q18","v":0},{"$f":"'Operating Subsidy'!R18","v":0},{"$f":"'Operating Subsidy'!S18","v":0},{"$f":"'Operating Subsidy'!T18","v":0},{"$f":"'Operating Subsidy'!U18","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V18","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A19","v":0},{"$f":"'Operating Subsidy'!B19","v":0},{"$f":"'Operating Subsidy'!C19","v":0},{"$f":"'Operating Subsidy'!D19","v":0},{"$f":"'Operating Subsidy'!E19","v":0},{"$f":"'Operating Subsidy'!F19","v":0},{"$f":"'Operating Subsidy'!G19","v":0},{"$f":"'Operating Subsidy'!H19","v":0},{"$f":"'Operating Subsidy'!I19","v":0},{"$f":"'Operating Subsidy'!J19","v":0},{"$f":"'Operating Subsidy'!K19","v":0},{"$f":"'Operating Subsidy'!L19","v":0},{"$f":"'Operating Subsidy'!M19","v":0},{"$f":"'Operating Subsidy'!N19","v":0},{"$f":"'Operating Subsidy'!O19","v":0},{"$f":"'Operating Subsidy'!P19","v":0},{"$f":"'Operating Subsidy'!Q19","v":0},{"$f":"'Operating Subsidy'!R19","v":0},{"$f":"'Operating Subsidy'!S19","v":0},{"$f":"'Operating Subsidy'!T19","v":0},{"$f":"'Operating Subsidy'!U19","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V19","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A20","v":0},{"$f":"'Operating Subsidy'!B20","v":0},{"$f":"'Operating Subsidy'!C20","v":0},{"$f":"'Operating Subsidy'!D20","v":0},{"$f":"'Operating Subsidy'!E20","v":0},{"$f":"'Operating Subsidy'!F20","v":0},{"$f":"'Operating Subsidy'!G20","v":0},{"$f":"'Operating Subsidy'!H20","v":0},{"$f":"'Operating Subsidy'!I20","v":0},{"$f":"'Operating Subsidy'!J20","v":0},{"$f":"'Operating Subsidy'!K20","v":0},{"$f":"'Operating Subsidy'!L20","v":0},{"$f":"'Operating Subsidy'!M20","v":0},{"$f":"'Operating Subsidy'!N20","v":0},{"$f":"'Operating Subsidy'!O20","v":0},{"$f":"'Operating Subsidy'!P20","v":0},{"$f":"'Operating Subsidy'!Q20","v":0},{"$f":"'Operating Subsidy'!R20","v":0},{"$f":"'Operating Subsidy'!S20","v":0},{"$f":"'Operating Subsidy'!T20","v":0},{"$f":"'Operating Subsidy'!U20","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V20","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A21","v":0},{"$f":"'Operating Subsidy'!B21","v":0},{"$f":"'Operating Subsidy'!C21","v":0},{"$f":"'Operating Subsidy'!D21","v":0},{"$f":"'Operating Subsidy'!E21","v":0},{"$f":"'Operating Subsidy'!F21","v":0},{"$f":"'Operating Subsidy'!G21","v":0},{"$f":"'Operating Subsidy'!H21","v":0},{"$f":"'Operating Subsidy'!I21","v":0},{"$f":"'Operating Subsidy'!J21","v":0},{"$f":"'Operating Subsidy'!K21","v":0},{"$f":"'Operating Subsidy'!L21","v":0},{"$f":"'Operating Subsidy'!M21","v":0},{"$f":"'Operating Subsidy'!N21","v":0},{"$f":"'Operating Subsidy'!O21","v":0},{"$f":"'Operating Subsidy'!P21","v":0},{"$f":"'Operating Subsidy'!Q21","v":0},{"$f":"'Operating Subsidy'!R21","v":0},{"$f":"'Operating Subsidy'!S21","v":0},{"$f":"'Operating Subsidy'!T21","v":0},{"$f":"'Operating Subsidy'!U21","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V21","v":{"$error":"#VALUE!"}}]
[{"$f":"'Expenditure Report'!$B$12","v":0},{"$f":"'Expenditure Report'!$B$16","v":0},{"$f":"'Operating Subsidy'!A22","v":0},{"$f":"'Operating Subsidy'!B22","v":0},{"$f":"'Operating Subsidy'!C22","v":0},{"$f":"'Operating Subsidy'!D22","v":0},{"$f":"'Operating Subsidy'!E22","v":0},{"$f":"'Operating Subsidy'!F22","v":0},{"$f":"'Operating Subsidy'!G22","v":0},{"$f":"'Operating Subsidy'!H22","v":0},{"$f":"'Operating Subsidy'!I22","v":0},{"$f":"'Operating Subsidy'!J22","v":0},{"$f":"'Operating Subsidy'!K22","v":0},{"$f":"'Operating Subsidy'!L22","v":0},{"$f":"'Operating Subsidy'!M22","v":0},{"$f":"'Operating Subsidy'!N22","v":0},{"$f":"'Operating Subsidy'!O22","v":0},{"$f":"'Operating Subsidy'!P22","v":0},{"$f":"'Operating Subsidy'!Q22","v":0},{"$f":"'Operating Subsidy'!R22","v":0},{"$f":"'Operating Subsidy'!S22","v":0},{"$f":"'Operating Subsidy'!T22","v":0},{"$f":"'Operating Subsidy'!U22","v":{"$error":"#VALUE!"}},{"$f":"'Operating Subsidy'!V22","v":{"$error":"#VALUE!"}}]

{"sheet":"Equity Data","index":8,"n_rows":2,"n_cols":45,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["HCD Contract","Sponsor","Reporting Period","Total HK","Total HMIS","# AIAN HK","# AIAN HMIS","% AIAN HK","% AIAN HMIS","# Asian HK","# Asian HMIS","% Asian HK","% Asian HMIS","# Black/AA HK","# Black/AA HMIS","% Black/AA HK","% Black/AA HMIS","# HI/PI HK","#HI/PI HMIS","% HI/PI HK","% HI/PI HMIS","# WHT HK","# WHT HMIS","% WHT HK","% WHT HMIS","# Unknown HK","# Unknown HMIS","% Unknown HK","% Unknown HMIS","# Latinx HK","% Latinx HK","# Latinx HMIS","% Latinx HMIS","# Not Latinx HK","% Not Latinx HK","# Not Latinx HMIS","% Not Latinx HMIS","Tenant Support Services","Coordination of Medical and Behavioral Health","Substance Abuse Use Disorder Treatment","Employment Services","Life Skills Training","Peer Support","Crisis Management Interventions","Other"]
[{"$f":"'Expenditure Report'!B12","v":0},{"$f":"'Expenditure Report'!B13","v":0},{"$f":"'Expenditure Report'!B16","v":0},{"$f":"'Equity Strategies'!B25","v":0},{"$f":"'Equity Strategies'!B26","v":0},{"$f":"'Equity Strategies'!C25","v":0},{"$f":"'Equity Strategies'!C26","v":0},{"$f":"F2/D2","v":{"$error":"#DIV/0!"}},{"$f":"G2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!D25","v":0},{"$f":"'Equity Strategies'!D26","v":0},{"$f":"J2/D2","v":{"$error":"#DIV/0!"}},{"$f":"K2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!E25","v":0},{"$f":"'Equity Strategies'!E26","v":0},{"$f":"N2/D2","v":{"$error":"#DIV/0!"}},{"$f":"O2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!F25","v":0},{"$f":"'Equity Strategies'!F26","v":0},{"$f":"R2/D2","v":{"$error":"#DIV/0!"}},{"$f":"S2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!G25","v":0},{"$f":"'Equity Strategies'!G26","v":0},{"$f":"V2/D2","v":{"$error":"#DIV/0!"}},{"$f":"W2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!H25","v":0},{"$f":"'Equity Strategies'!H26","v":0},{"$f":"Z2/D2","v":{"$error":"#DIV/0!"}},{"$f":"AA2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!I25","v":0},{"$f":"AD2/D2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!I26","v":0},{"$f":"AF2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!J25","v":0},{"$f":"AH2/D2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!J26","v":0},{"$f":"AJ2/E2","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Operating Subsidy'!$A$28:$B$35, 'Drop-Down'!A69)","v":0},{"$f":"COUNTIF('Operating Subsidy'!$A$28:$B$35, 'Drop-Down'!A70)","v":0},{"$f":"COUNTIF('Operating Subsidy'!$A$28:$B$35, 'Drop-Down'!A71)","v":0},{"$f":"COUNTIF('Operating Subsidy'!$A$28:$B$35, 'Drop-Down'!A72)","v":0},{"$f":"COUNTIF('Operating Subsidy'!$A$28:$B$35, 'Drop-Down'!A73)","v":0},{"$f":"COUNTIF('Operating Subsidy'!$A$28:$B$35, 'Drop-Down'!A74)","v":0},{"$f":"COUNTIF('Operating Subsidy'!$A$28:$B$35, 'Drop-Down'!A75)","v":0},{"$f":"COUNTIF('Operating Subsidy'!$A$28:$B$35, 'Drop-Down'!A76)","v":0}]

{"sheet":"Drop-Down","index":9,"n_rows":103,"n_cols":2,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
["Reporting Period","Due Date"]
["First Grantee Expenditure Report: Project Inception-Current Date (All Sponsors - Due February 1, 2021)","2021-02-01"]
["January 1 - June 30, 2021 (If Recipient of Operating Subsidy - Due July 31, 2021)","2021-07-31"]
["July 1 - December 31, 2021 (If Recipient of Operating Subsidy - Due January 31, 2022)","2022-01-31"]
["January 1 - June 30, 2022 (If Recipient of Operating Subsidy - Due July 31, 2022)","2022-07-31"]
[]
["Counties","Geographic Region"]
["Select One","Geographic Region"]
["Alameda","Bay Area"]
["Alpine","Balance of State"]
["Amador","Sacramento Area"]
["Butte","Balance of State"]
["Calaveras","Balance of State"]
["Colusa","Balance of State"]
["Contra Costa","Bay Area"]
["Del Norte","Balance of State"]
["El Dorado","Sacramento Area"]
["Fresno","San Joaquin Valley"]
["Glenn","Balance of State"]
["Humboldt","Balance of State"]
["Imperial","Southern California"]
["Inyo","Balance of State"]
["Kern","San Joaquin Valley"]
["Kings","San Joaquin Valley"]
["Lake","Balance of State"]
["Lassen","Balance of State"]
["Los Angeles","Los Angeles County"]
["Madera","San Joaquin Valley"]
["Marin","Bay Area"]
["Mariposa","Balance of State"]
["Mendocino","Balance of State"]
["Merced","San Joaquin Valley"]
["Modoc","Balance of State"]
["Mono","Balance of State"]
["Monterey","Central Coast"]
["Napa","Bay Area"]
["Nevada","Balance of State"]
["Orange","Southern California"]
["Placer","Sacramento Area"]
["Plumas","Balance of State"]
["Riverside","Southern California"]
["Sacramento","Sacramento Area"]
["San Benito","Central Coast"]
["San Bernardino","Southern California"]
["San Diego","San Diego County"]
["San Francisco","Bay Area"]
["San Joaquin","San Joaquin Valley"]
["San Luis Obispo","Central Coast"]
["San Mateo","Bay Area"]
["Santa Barbara","Central Coast"]
["Santa Clara","Bay Area"]
["Santa Cruz","Central Coast"]
["Shasta","Balance of State"]
["Sierra","Balance of State"]
["Siskiyou","Balance of State"]
["Solano","Bay Area"]
["Sonoma","Bay Area"]
["Stanislaus","San Joaquin Valley"]
["Sutter","Sacramento Area"]
["Tehama","Balance of State"]
["Trinity","Balance of State"]
["Tulare","San Joaquin Valley"]
["Tuolumne","Balance of State"]
["Ventura","Southern California"]
["Yolo","Sacramento Area"]
["Yuba","Sacramento Area"]
[]
[]
["Tenant Support Services"]
["Coordination of Medical and Behavioral Health"]
["Substance Abuse Use Disorder Treatment"]
["Employment Services"]
["Life Skills Training"]
["Peer Support"]
["Crisis Management Interventions"]
["Other"]
[]
["Special Conditions"]
["A Regulatory Agreement recorded against the real property of the Project Site by the Performance Milestone date (refer to Sponsor's Exhibit E). Unless otherwise authorized by the prior and express written approval of the Department, the Regulatory Agreement shall be recorded as a lien against the Project in first position and shall remain in first position over all other Project agreements, covenants or other matters of record on the real property for the period of affordability required by the Program.  "]
["At least nine months prior to conversion, Sponsor shall obtain Department review and written approval of the unit replacement plan."]
["Certification that Sponsor will employ the core components of Housing First (set forth in Health and Safety Code section 8255) as part of its property management and tenant selection practices."]
["Submitted documentation of compliance with California’s relocation assistance law, in form and substance satisfactory to the Department, as required by Exhibit D of the Standard Agreement. Such documentation shall be in finalized form and expressly approved by the Department in writing by the Performance Milestone date set forth in Exhibit E."]
["Ensurance of a one-for-one replacement of Homekey Restricted units If the Project is redeveloped as a mixed-income or mixed-use development during its conversion from Interim to Permanent Housing. "]
["If sale price of site is higher than the appraised value of the property, Sponsor must submit a budget documenting the source of funds that will be used to cover the difference between the appraised value and purchase price"]
["Notice of Exemption"]
["Physical Needs Assessment for the project, prepared by a third party"]
["Sponsor has demonstrated ability to fund ongoing operating reserves (pursuant to AB-83 Section 21 50675.1.1. (b) 3."]
["Sponsor must obtain all discretionary public land use approvals that are required, notwithstanding Health and Safety Code section 50675.1.1, subdivision (g)."]
["The Sponsor must submit final environmental clearances in form and substance satisfactory to the Department."]
["Use restriction in accordance with the NOFA and Program Requirements (\"Covenant\") recorded against the real property of the Project site by the Performance Milestone date set forth in Exhibit E. The sponsor/county shall obtain the Department's express written approval of such Covenant prior to the County's recordation of the same. Unless otherwise authorized by the prior and express written approval of the Department, the Covenant shall be recorded as a lien against the Project in first position, and shall remain in first position over all other Project agreements, covenants or other matters of record on the real property for the period of affordability required by the Program.   "]
["Other Condition (Describe in Notes Box)"]
[]
["Months"]
["Select One"]
["2020-10-01"]
["2020-11-01"]
["2020-12-01"]
["2021-01-01"]
["2021-02-01"]
["2021-03-01"]
["2021-04-01"]
["2021-05-01"]
["2021-06-01"]