{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["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":44,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Expenditure Report","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[10,0,10,7],[2,0,2,2],[8,0,8,7],[9,0,9,7],[13,1,13,3],[12,1,12,3],[13,5,13,7],[11,0,11,7],[12,5,12,7],[22,0,22,2],[27,0,27,7],[18,3,18,4],[19,3,19,4],[20,3,20,4],[18,0,18,2],[19,0,19,2],[20,0,20,2],[23,0,23,2],[18,5,18,7],[19,5,19,7],[20,5,20,7],[21,5,21,7],[21,0,21,2],[21,3,21,4],[1,0,1,2],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[32,0,32,4],[25,0,25,7],[30,0,30,3],[29,0,29,3],[29,4,29,7],[30,4,30,7],[32,5,32,7],[31,5,31,7],[25,8,25,15],[26,0,26,4],[24,0,24,2],[26,5,26,7],[31,0,31,4],[28,0,28,1],[28,2,28,3],[17,0,17,7],[15,1,15,3],[14,1,14,3],[14,5,14,7],[15,5,15,7],[16,1,16,3],[16,5,16,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/22/2023"]
["Instructions: All fields in which information is requested must be completed by the Grantee within the three tabs of the reporting workbook.  Reporting workbooks which contain blank information where information requested in non-optional will be considered incomplete and will be returned to the Grantee for completion. Any questions pertaining to the reporting requirements should be directed to your Grant Management Representative.  If you do not have your Grant Management Representative's information, you may submit your email inquiry at HomekeySGM@hcd.ca.gov. Recipients of Operating Subsidy funds who have not expended 100% by this final report will be required to return funds to the Department."]
["HCD Contract Number:",null,null,null,"Project Name:"]
["Sponsor Name:",null,null,null,"Sponsor Address (number and street):"]
["Preparer Name:",null,null,null,"Preparer Title:"]
["Sponsor City, State, Zip:",null,null,null,"Preparer Email:"]
["Preparer phone number:",null,null,null,"Reporting Period:","Select One"]
["EXPENDITURE BREAKDOWN"]
["Fund Type",null,null,"Award Amount",null,"Expenditure Deadline"]
["Coronavirus Relief Funds (CRF) for Capital Expenditures",null,null,null,null,"2021-12-31"]
["*24 Month Operating Subsidy funded from State General Fund \n(pursuant to NOFA §308)",null,null,null,null,"June 30, 2023*\nAll funds must be expended by this date. No further extensions will be made."]
["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 January 1, 2023-June 30, 2023\nDo not include philanthropic/other funds","Amount of Award Expended Total ","Percent Expended","Amount of Award Remaining"]
["*Capitalized operating subsidies for units purchased, converted or altered",null,null,null,null,null,{"$f":"IFERROR(E24/D24,0)","v":0},{"$f":"D24-E24","v":0}]
["TOTAL",null,null,{"$f":"SUM(D24:D24)","v":0},{"$f":"SUM(E24:E24)","v":0},{"$f":"SUM(F24:F24)","v":0},{"$f":"IFERROR(E25/D25,0)","v":0},{"$f":"D25-E25","v":0}]
["CERTIFICATION"]
["Sponsor agrees to employ the core components of Housing First in the property management and tenant selection process (pursuant to NOFA §310) ",null,null,null,null,"Select One"]
["***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"]

{"sheet":"Report Narrative","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[10,1,10,3],[3,1,3,3],[4,2,4,3],[5,2,5,3],[8,2,8,3],[6,2,6,3],[7,2,7,3],[9,2,9,3],[14,1,14,3],[15,1,15,3],[11,1,11,3],[12,1,12,3],[13,1,13,3]]}
[null,"Beginning of Sheet 2: Report Narrative"]
[null,"HOMEKEY PROGRAM\nReport Narrative"]
[null,"Sponsor and Contract:",{"$f":"'Expenditure Report'!B14","v":0},{"$f":"'Expenditure Report'!B13","v":0}]
[null,"1. Complete the following information in regards to participants housed and units created using Homekey funds."]
[null,"Prompt","Response"]
[null,"A. Please input the number of units created, rehabilitated or otherwise made available to the Homekey Target population at the project site"]
[null,"B. Number of units currently occupied onsite:"]
[null,"C. Number of units supported by operating subsidy funds off site:\nFor projects undergoing rehabilitation/construction"]
[null,"D. Total number of individuals housed using Program Funds over the life of the project. Include all individuals in household. (pursuant to NOFA §402 iv.):"]
[null,"E. Total number of individuals currently housed in Homekey-funded units."]
[null,"1. 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."]
[]
[null,"2. If your plan includes converting interim to permanent housing, please describe your vision to achieve this. Explain timeline of conversion process. If planning to convert in the next 12 months, please complete the Interim to Permanent Conversion Notice Form and submit to your Grant Management Representative."]
[]
[null,"3. Optional: Please share any success stories you've had from Homekey-funded projects.\nGrantee may send attachments and photos to HomekeySGM@hcd.ca.gov"]

{"sheet":"Equity Strategies","index":2,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,0,4,11],[5,0,5,11],[7,0,7,11],[1,0,1,11],[2,0,2,11],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,8,3,9],[3,10,3,11]]}
["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'!B13","v":0},null,"Sponsor Name: ",null,{"$f":"'Expenditure Report'!B14","v":0},null,null,"Reporting Period:",null,{"$f":"'Expenditure Report'!F17","v":"Select One"}]
["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 Multi-Racial 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? "]
[null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'Operating Subsidy'!A9","v":"TOTAL: "},{"$f":"SUM(B10:B10)","v":0},0,0,0,0,0,0,0,0,0]
["Total Number of Total Clients in Local HMIS System or last PIT Count"]

{"sheet":"Operating Subsidy","index":3,"n_rows":30,"n_cols":24,"rows_kept":30,"cut":false,"hidden":false,"merged":[[30,0,30,7],[29,0,29,7],[10,0,10,9],[11,0,11,9],[18,1,18,4],[12,7,12,9],[14,7,14,8],[15,7,15,8],[16,7,16,8],[13,7,13,9],[16,1,16,4],[17,1,17,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[12,1,12,4],[21,0,21,12],[5,15,5,16],[20,0,20,12],[1,0,1,23],[0,1,0,23],[6,17,6,18],[2,0,2,23],[5,4,5,6],[3,0,3,23],[5,8,5,11],[4,5,4,7],[4,0,4,1],[4,2,4,3],[4,9,4,15],[5,12,5,14]]}
["Beginning of Sheet 3: Operating Subsidy "]
["HOMEKEY PROGRAM\nOperating Subsidy and Services Provided"]
[]
["Instructions: Fill out the following table on Operating Subsidy Finances expended to date by project site. Provide evidence for any expenditures made that have not yet been reported to the Department. If any expenses are attributed to \"Other,\" you must itemize expenses in the subsequent table, beginning in row 11. "]
["First Month Utilizing Operating Subsidy:",null,"Select One",null,"Sponsor:",{"$f":"'Expenditure Report'!$B$14","v":0},null,null,"Reporting Period:",{"$f":"'Expenditure Report'!F17","v":"Select One"}]
["Project Site Street Address","Project Site City, Zip","County","Number of Assisted Units ","Total Administrative Costs Expended \n",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)\n(separated by commas)","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\n(must itemize below)",null,"Payroll","Repairs and Maintenance","Security Payroll","Other\n(must itemize below)","Case Management \n(salary and benefits) ","Services Provided\n(must itemize below)","Other\n(must itemize 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/2023\",\"M\")","v":{"$error":"#VALUE!"}},{"$f":"U8/D8","v":{"$error":"#VALUE!"}},{"$f":"(M8+N8+O8)/DATEDIF($C$5,\"7/2023\",\"M\")","v":{"$error":"#VALUE!"}},{"$f":"W8/D8","v":{"$error":"#VALUE!"}}]
["TOTAL: ",null,null,{"$f":"SUM(D8:D8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(T8:T8)","v":0},{"$f":"AVERAGEIF(U8:U8,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIF(V8:V8,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"(M9+O9)/DATEDIF($C$5,\"7/2023\",\"M\")","v":{"$error":"#VALUE!"}},{"$f":"AVERAGEIF(X8:X8,\">0\")","v":{"$error":"#DIV/0!"}}]
[]
["Other Expenses Itemization"]
["Instructions: Fill out this table with information on any expenses reported above under the category of \"Other\". Submit appropriate evidence of any expenditures reported, such as itemized invoices, scopes of work, wire transfer, etc. "]
["Expense Category","Itemization of Other Expenses",null,null,null,"Amount of Other Expense","Proof of Expenditure Submitted?","Itemized Totals"]
["Select One",null,null,null,null,0,null,"Totals must equal what is reported in the table above."]
["Select One",null,null,null,null,0,null,"Total Other Administrative Costs:",null,{"$f":"SUMIF($A$14:$A$19,\"Administrative - Other\",$F$14:$F$19)","v":0}]
["Select One",null,null,null,null,0,null,"Total Other Maintenance Costs:",null,{"$f":"SUMIF($A$14:$A$19,\"Maintenance - Other\",$F$14:$F$19)","v":0}]
["Select One",null,null,null,null,0,null,"Total Other Supportive Services Costs:",null,{"$f":"SUMIF($A$14:$A$19,\"Supportive Services - Other\",$F$14:$F$19)","v":0}]
["Select One",null,null,null,null,0]
["Select One",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 $250 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. Numbers that appear to be in the negative do not necessarily reflect non-compliance or inability to meet this five-year requirement, but significant discrepancies may require further explanation and proof of supplemental funding sources to be provided to the Department."]
["HCD COSR Award:",{"$f":"'Expenditure Report'!D24","v":0},"Sponsor Matching Share:",{"$f":"R9","v":0},"Total COSR:",{"$f":"B23+D23","v":0}]
[{"$f":"'Expenditure Report'!D24","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":"R9+B23","v":0},{"$f":"B25-$U$9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"D25-$U$9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"F25-$U$9","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":"M25-$U$9","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":"M26-$U$9","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":"M27-$U$9","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":"M28-$U$9","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!"}]
["If the COSR Match five-year schedule shows significant discrepancy in available funds through year 5, please explain why this is and how you plan to fulfill the five-year commitment to providing operating funds for your project."]

{"sheet":"Project Summary","index":4,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":true,"merged":[[24,7,26,9],[34,3,34,6],[24,5,24,6],[24,0,24,1],[24,2,24,3],[26,0,26,1],[27,0,27,6],[25,0,25,1],[35,1,35,2],[28,0,28,1],[35,3,35,6],[36,0,36,9],[33,3,33,6],[35,7,35,9],[29,0,29,1],[30,0,30,6],[31,0,31,6],[30,7,31,9],[27,7,29,9],[33,7,33,9],[34,7,34,9],[32,7,32,9],[22,0,22,1],[19,3,19,4],[33,1,33,2],[34,1,34,2],[12,0,12,1],[13,3,13,4],[23,0,23,6],[17,0,17,6],[18,3,18,4],[12,5,12,6],[15,3,15,4],[15,0,15,1],[14,3,14,4],[32,0,32,6],[14,0,14,1],[6,6,6,7],[10,0,10,6],[4,2,4,3],[2,6,2,7],[2,0,3,1],[3,2,3,3],[3,4,3,5],[3,6,3,7],[4,0,5,1],[5,2,5,3],[4,4,4,5],[4,6,4,7],[5,4,5,5],[5,6,5,7],[2,4,2,5],[2,2,2,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[6,4,6,5],[7,4,7,5],[9,12,9,13],[12,3,12,4],[14,5,14,6],[11,7,15,9],[9,2,9,3],[10,7,10,9],[11,5,11,6],[11,0,11,1],[11,3,11,4],[13,0,13,1],[0,0,0,9],[8,4,8,5],[8,6,8,7],[9,4,9,5],[7,6,7,7],[9,6,9,7],[9,8,9,9],[6,8,6,9],[7,8,7,9],[6,0,9,1],[2,8,2,9],[4,8,4,9],[3,8,3,9],[5,8,5,9],[8,8,8,9],[1,0,1,9],[23,7,23,9],[18,7,22,9],[16,0,16,9],[13,5,13,6],[22,3,22,4],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[17,7,17,9],[20,3,20,4],[21,3,21,4],[15,5,15,6]]}
["Homekey Annual Report Summary\nFor HCD Staff Only"]
["1. General Information"]
["Rep Information",null,"Reviewing Rep Name",null,"Review Start Date",null,"Review End Date",null,"Comments"]
[]
["Manager Information",null,"Reviewing Manager Name",null,"Review Start Date",null,"Manager Approval Date",null,"Comments"]
[]
["General Applicant Information",null,"Sponsor Name",null,"Contract #",null,"HCD Award Amount",null,"Sponsor Address"]
[null,null,{"$f":"'Expenditure Report'!B14","v":0},null,{"$f":"'Expenditure Report'!B13","v":0},null,{"$f":"'Expenditure Report'!D25","v":0},null,{"$f":"_xlfn.CONCAT('Expenditure Report'!F14,\", \",'Expenditure Report'!B16)","v":", "}]
[null,null,"Preparer Name and Title",null,"Preparer Email",null,"Preparer Phone Number",null,"Reporting Period:"]
[null,null,{"$f":"_xlfn.CONCAT('Expenditure Report'!B15,\", \",'Expenditure Report'!F15)","v":", "},null,{"$f":"'Expenditure Report'!F16","v":0},null,{"$f":"'Expenditure Report'!B17","v":0},null,{"$f":"'Expenditure Report'!F17","v":"Select One"}]
["2. Project Overview",null,null,null,null,null,null,"Rep Notes"]
["CRF Funds Awarded",null,{"$f":"'Expenditure Report'!D20","v":0},"SGF Funds Awarded",null,{"$f":"'Expenditure Report'!D21","v":0}]
["CRF Funds Remaining",null,{"$f":"'Expenditure Report'!#REF!","v":{"$error":"#REF!"}},"SGF Funds Remaining:",null,{"$f":"'Expenditure Report'!H24","v":0}]
["Units Created",null,{"$f":"'Report Narrative'!C6","v":0},"# Units Occupied (onsite)",null,{"$f":"'Report Narrative'!C7","v":0}]
["# of Units Occupied (offsite)",null,{"$f":"'Report Narrative'!C8","v":0},"% Occupancy",null,{"$f":"(C15+F14)/C14","v":{"$error":"#DIV/0!"}}]
["Total Number of Individuals Housed (life of project)",null,{"$f":"'Report Narrative'!C9","v":0},"Total number of individuals housed currently:",null,{"$f":"'Report Narrative'!C10","v":0}]
["3. Expenditure Information"]
["Operating Subsidy Expenditures",null,null,null,null,null,null,"Rep Notes"]
["Category",null,"Amount Expended","Category",null,"Amount Expended"]
["Admin Costs:",null,{"$f":"'Operating Subsidy'!E9+'Operating Subsidy'!F9+'Operating Subsidy'!G9","v":0},"Supportive Services, Service Provision",null,{"$f":"'Operating Subsidy'!N8","v":0}]
["Utilities:",null,{"$f":"'Operating Subsidy'!H9","v":0},"Supportive Services, Other",null,{"$f":"'Operating Subsidy'!O8","v":0}]
["Maintenance Costs:",null,{"$f":"'Operating Subsidy'!I9+'Operating Subsidy'!J9+'Operating Subsidy'!K9+'Operating Subsidy'!L9","v":0},"Taxes and Insurance:",null,{"$f":"'Operating Subsidy'!P9+'Operating Subsidy'!Q9","v":0}]
["Supportive Services, Case Management:",null,{"$f":"'Operating Subsidy'!M8","v":0},"Total:",null,{"$f":"'Operating Subsidy'!T9","v":0}]
["4. Operating Subsidy Outlook",null,null,null,null,null,null,"Rep Notes"]
["Starting Month of COSR",null,{"$f":"'Operating Subsidy'!C5","v":"Select One"},null,"Total COSR (HCD Award + Matching Funds):",{"$f":"'Operating Subsidy'!F23","v":0}]
["Other Admin Costs Described and Itemized? ",null,null,"Other Maintenance Costs Described and Itemized? ",null,"Other Supportive Services Costs Described and Itemized?"]
["Proof of Other Admin Costs Submitted and Approved?",null,null,"Proof of Other Maintenance Costs Submitted and Approved?",null,"Proof of Other Supportive Services Costs Submitted and Approved? "]
["COSR Expenditure Estimate\nPlease note: COSR Funds remaining by year end is an estimation based on prior expenditures and not an exact calculation. This is only to be used as reference if there seems to be a significant discrepancy in how much they have v. how much they are spending. Negative amounts does not necessarily mean out of compliance, but may require follow-up with the grantee for an explanation and additional proof that they have sufficient funds from other sources."]
["COSR Year",null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Approximate Funds Remaining by Year-End",null,{"$f":"'Operating Subsidy'!M25","v":{"$error":"#DIV/0!"}},{"$f":"'Operating Subsidy'!M26","v":{"$error":"#DIV/0!"}},{"$f":"'Operating Subsidy'!M27","v":{"$error":"#DIV/0!"}},{"$f":"'Operating Subsidy'!M28","v":{"$error":"#DIV/0!"}},{"$f":"'Operating Subsidy'!M29","v":{"$error":"#DIV/0!"}}]
["Grantee Explanation of COSR Outlook"]
[{"$f":"'Operating Subsidy'!A31","v":0}]
["5. Report Narrative",null,null,null,null,null,null,"Rep Notes"]
[1,"Lessons Learned with Funds:",null,{"$f":"'Report Narrative'!B12","v":0}]
[2,"Proposed Development Vision for Interim to Perm projects",null,{"$f":"'Report Narrative'!B14","v":0}]
[3,"Success Stories",null,{"$f":"'Report Narrative'!B16","v":0}]
["6. Special Conditions Checklist - Keep track on Expenditure Report Tracker Project Information Tab"]

{"sheet":"DataTable","index":5,"n_rows":2,"n_cols":41,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["HCD Contract Number","Sponsor Name","HCD Rep","Reporting Period","Preparer Name","Preparer Email","HCD CRF Award","HCD SGF Award","Total HCD Award","Philanthropic Award","Award_Capital","Capital Expended","Capital Remaining","Award_COSR","COSR Expended","COSR Remaining","Units Created","Units Occupied Onsite","Units Occupied Offsite","Total Units Occupied ","Site Occupancy Rate","Total Occupancy Rate","# Individuals Housed CUMULATIVE","# Individuals Housed CURRENT","$ Expended on Admin Costs","$ Expended on Utilities","$ Expended on Maintenance","$ Expended on Supportive Services","$ Expended on Taxes & Insurance","Other Expenses 1","Other Expenses Item 2","Other Expenses Item 3","Other Expenses Item 4","Other Expenses Item 5","Other Expenses Item 6","Operating Match Funds","Operating Match Source(s)","Lessons Learned","Interim to Perm Plan","Success Stories","Equity and Inclusion"]
[{"$f":"'Expenditure Report'!B13","v":0},{"$f":"'Expenditure Report'!B14","v":0},{"$f":"'Project Summary'!C4","v":0},{"$f":"'Expenditure Report'!F17","v":"Select One"},{"$f":"'Expenditure Report'!B15","v":0},{"$f":"'Expenditure Report'!F15","v":0},{"$f":"'Expenditure Report'!D20","v":0},{"$f":"'Expenditure Report'!D21","v":0},{"$f":"'Expenditure Report'!D25","v":0},{"$f":"'Expenditure Report'!D22","v":0},{"$f":"'Expenditure Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Expenditure Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Expenditure Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Expenditure Report'!D24","v":0},{"$f":"'Expenditure Report'!E25","v":0},{"$f":"'Expenditure Report'!H24","v":0},{"$f":"'Report Narrative'!C6","v":0},{"$f":"'Report Narrative'!C7","v":0},{"$f":"'Report Narrative'!C8","v":0},{"$f":"SUM(R2:S2)","v":0},{"$f":"R2/Q2","v":{"$error":"#DIV/0!"}},{"$f":"T2/Q2","v":{"$error":"#DIV/0!"}},{"$f":"'Report Narrative'!C9","v":0},{"$f":"'Report Narrative'!C10","v":0},{"$f":"'Project Summary'!C20","v":0},{"$f":"'Project Summary'!C21","v":0},{"$f":"'Project Summary'!C22","v":0},{"$f":"'Project Summary'!C23","v":0},{"$f":"'Project Summary'!F22","v":0},{"$f":"'Operating Subsidy'!B14","v":0},{"$f":"'Operating Subsidy'!B15","v":0},{"$f":"'Operating Subsidy'!B16","v":0},{"$f":"'Operating Subsidy'!B17","v":0},{"$f":"'Operating Subsidy'!B18","v":0},{"$f":"'Operating Subsidy'!B19","v":0},{"$f":"'Operating Subsidy'!R8","v":0},{"$f":"'Operating Subsidy'!S8","v":0},{"$f":"'Report Narrative'!B12","v":0},{"$f":"'Report Narrative'!B14","v":0},{"$f":"'Report Narrative'!B16","v":0},{"$f":"'Equity Strategies'!A6","v":0}]

{"sheet":"COSR Data","index":6,"n_rows":5,"n_cols":24,"rows_kept":5,"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$13","v":0},{"$f":"'Expenditure Report'!$F$17","v":"Select One"},{"$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$13","v":0},{"$f":"'Expenditure Report'!$F$17","v":"Select One"},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Expenditure Report'!$B$13","v":0},{"$f":"'Expenditure Report'!$F$17","v":"Select One"},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Expenditure Report'!$B$13","v":0},{"$f":"'Expenditure Report'!$F$17","v":"Select One"},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operating Subsidy'!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Equity Data","index":7,"n_rows":2,"n_cols":41,"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","#Multi HK","#Multi HMIS","%Multi HK","%Multi 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"]
[{"$f":"'Expenditure Report'!B13","v":0},{"$f":"'Expenditure Report'!B14","v":0},{"$f":"'Expenditure Report'!F17","v":"Select One"},{"$f":"'Equity Strategies'!B11","v":0},{"$f":"'Equity Strategies'!B12","v":0},{"$f":"'Equity Strategies'!C11","v":0},{"$f":"'Equity Strategies'!C12","v":0},{"$f":"F2/D2","v":{"$error":"#DIV/0!"}},{"$f":"G2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!D11","v":0},{"$f":"'Equity Strategies'!D12","v":0},{"$f":"J2/D2","v":{"$error":"#DIV/0!"}},{"$f":"K2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!E11","v":0},{"$f":"'Equity Strategies'!E12","v":0},{"$f":"N2/D2","v":{"$error":"#DIV/0!"}},{"$f":"O2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!F11","v":0},{"$f":"'Equity Strategies'!F12","v":0},{"$f":"R2/D2","v":{"$error":"#DIV/0!"}},{"$f":"S2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!G11","v":0},{"$f":"'Equity Strategies'!G12","v":0},{"$f":"V2/D2","v":{"$error":"#DIV/0!"}},{"$f":"W2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!H11","v":0},{"$f":"'Equity Strategies'!H12","v":0},{"$f":"Z2/D2","v":{"$error":"#DIV/0!"}},{"$f":"AA2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!I11","v":0},{"$f":"'Equity Strategies'!I12","v":0},{"$f":"AD2/D2","v":{"$error":"#DIV/0!"}},{"$f":"AE2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!J11","v":0},{"$f":"AH2/D2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!J12","v":0},{"$f":"AJ2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!K11","v":0},{"$f":"AL2/D2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!K12","v":0},{"$f":"AN2/E2","v":{"$error":"#DIV/0!"}}]

{"sheet":"Drop-Down","index":8,"n_rows":130,"n_cols":2,"rows_kept":130,"cut":false,"hidden":true,"merged":[]}
["Reporting Period","Due Date"]
["Select One"]
["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"]
["July 1 - December 31, 2022 (If Recipient of Operating Subsidy with Extension - Due January 31, 2023)","2023-01-31"]
["January 1 - June 30, 2023 (If Recipient of Operating Subsidy with Extension - Due July 31, 2023)","2023-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"]
["2021-07-01"]
["2021-08-01"]
["2021-09-01"]
["2021-10-01"]
["2021-11-01"]
["2021-12-01"]
["2022-01-01"]
["2022-02-01"]
["2022-03-01"]
["2022-04-01"]
["2022-05-01"]
["2022-06-01"]
["2022-07-01"]
["2022-08-01"]
["2022-09-01"]
["2022-10-01"]
["2022-11-01"]
["2022-12-01"]
["2023-01-01"]
["2023-02-01"]
["2023-03-01"]
["2023-04-01"]
["2023-05-01"]
["2023-06-01"]
["2023-07-01"]