{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Expenditure Report","Report Narrative","Project Details","Operational Costs","Equity Strategies","Review Workbook","DataTable","Site Data","Equity Data","Risk Analysis Data","Drop-Down"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":87,"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":"Expenditure Report","index":0,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[48,5,49,7],[48,4,49,4],[39,0,39,7],[48,0,48,1],[48,2,48,3],[49,0,49,1],[49,2,49,3],[46,4,46,5],[46,2,46,3],[46,6,46,7],[46,0,46,1],[40,0,40,1],[40,4,40,5],[40,2,40,3],[40,6,40,7],[44,6,44,7],[45,6,45,7],[45,2,45,3],[45,4,45,5],[43,0,43,1],[43,4,43,5],[41,2,41,3],[47,2,47,3],[41,6,41,7],[42,6,42,7],[44,4,44,5],[22,2,22,3],[23,2,23,3],[31,0,31,1],[32,0,32,1],[33,0,33,1],[27,0,27,1],[30,0,30,1],[25,0,25,7],[28,0,29,1],[45,0,45,1],[43,6,43,7],[0,6,6,7],[26,0,26,1],[12,1,12,3],[11,1,11,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[14,1,14,3],[1,0,1,2],[2,0,2,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[16,4,16,5],[17,4,17,5],[14,4,14,5],[24,0,24,1],[24,2,24,3],[24,6,24,7],[24,4,24,5],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,1,18,3],[21,4,21,5],[15,4,15,5],[22,4,23,7],[21,6,21,7],[20,4,20,7],[18,4,18,7],[19,0,19,7],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[20,2,20,3],[21,2,21,3],[8,0,8,7],[9,0,9,7],[10,0,10,7],[12,6,12,7],[13,6,13,7],[11,4,11,5],[12,4,12,5],[13,4,13,5],[13,1,13,3],[11,6,11,7],[54,0,54,3],[53,0,53,3],[54,4,54,7],[53,4,53,7],[34,0,34,1],[35,0,35,1],[37,0,37,1],[36,0,36,1],[50,0,50,7],[51,5,51,7],[52,0,52,7],[51,0,51,4],[38,0,38,7],[41,0,41,1],[41,4,41,5],[47,0,47,1],[47,4,47,5],[47,6,47,7],[42,0,42,1],[42,2,42,3],[43,2,43,3],[44,2,44,3],[44,0,44,1],[42,4,42,5]]}
["Beginning of Sheet 1: Expenditure Report"]
["DEPARTMENT OF HOUSING AND COMMUNITY DEVELOPMENT"]
["DIVISION OF STATE FINANCIAL ASSISTANCE"]
["STATE GRANTS MANAGEMENT"]
["2020 West El Camino, 4th Floor"]
["Sacramento, CA  95833"]
["Homekey2SGM@hcd.ca.gov"]
[]
["HOMEKEY 2.0 PROGRAM"]
["Annual Report"]
["Last Updated: 12/13/2023"]
["HCD Contract Number:",null,null,null,"Project Name:"]
["Sponsor Name:",null,null,null,"Sponsor Type:",null,"Select One"]
["Co-Applicant 1 Name:",null,null,null,"Co-Applicant 1 Type:",null,"Select One"]
["Co-Applicant 2 Name:",null,null,null,"Co-Applicant 2 Type:",null,"Select One"]
["Preparer Name:",null,null,null,"Preparer Title:"]
["Preparer phone number:",null,null,null,"Preparer Email:"]
["Date of Award:",null,null,null,"Date of Standard Agreement Execution:"]
["Reporting Period:","Select One",null,null,{"$f":"_xlfn.XLOOKUP(B19,'Drop-Down'!A3:A7,'Drop-Down'!B3:B7,\"\",0)","v":""}]
["EXPENDITURE BREAKDOWN\nFill out the following information on use of Homekey Award Funds only"]
["HCD Fund Type",null,"Award Amount",null,"Expenditure Deadline"]
["Capital Fund Award\nIf funds have been flexed, account for that here.",null,null,null,{"$f":"IF(B18=\"\",\"8 Months from Award Date\",EDATE(B18,8))","v":"8 Months from Award Date"},null,", absent a granted extension"]
["State General Fund Operating Subsidy Award\n(pursuant to Standard Agreement Exhibit E, A.1.) \nDo Not Include Expedited Occupancy Bonus\nIf funds have been flexed, account for that here.",null,null,null,"Disbursement Deadline: 6/30/2025\nExpenditure Deadline: 6/30/2026"]
["Conditional Bonus Award for Expedited Occupancy \n(pursuant to Standard Agreement Exhibit E, A.1. ) \nCan only be used for Operating Subsidy. Include amount even if forfeited."]
["Total Homekey Award:",null,{"$f":"IF(G25=\"Disencumbered/Forfeit\",SUM(C22:D23), SUM(C22:D24))","v":0},null,"What is the Status of Expedited Occupancy Bonus? ",null,"Select One"]
["Instructions: Fill out the table below with the award amounts per Eligible Use category. If funds have been reallocated or flexed between Capital and Operating Subsidy, please account for that here. Total Amount Disbursed refers to the amount that HCD has disbursed to you through your Request for Funds forms, or how much of your award you have received. Expended refers to how much of the disbursed award has been invoiced or spent on eligible activities, including reimbursements for activities that were paid for prior to the execution of the Standard Agreement."]
["Eligible Use",null,"Homekey Award Amount ","Total Amount Disbursed \n(requested by RFF Form and received)","Total Amount Expended \n(all reporting periods)",{"$f":"IF(E19=\"\",\"Amount Expended This Reporting Period\",_xlfn.CONCAT(\"Amount Expended \"&B19))","v":"Amount Expended This Reporting Period"},"Unexpended Amount","HCD Verified Expenditures"]
["Acquisition and/or Rehabilitation of motels, hotels, hostels, or other sites and assets (pursuant to NOFA §201 i.)",null,null,null,null,null,{"$f":"C28-E28","v":0},{"$f":"SUM('Review Workbook'!H15:I15)","v":0}]
["Enter a breakdown of Homekey funds spent on Acquisition and Rehabilitation. The sum of Acquisition and Rehab individually (Rows 29 and 30) should add up to the total Activity amount input in Row 28:",null,"Amount spent on Acquisition:",null,null,null,null,{"$f":"SUM('Review Workbook'!H16:I16)","v":0}]
[null,null,"Amount spent on Rehabilitation:",null,null,null,null,{"$f":"SUM('Review Workbook'!H17:I17)","v":0}]
["Master leasing of properties (pursuant to NOFA §201 ii.)",null,null,null,null,null,{"$f":"C31-E31","v":0},{"$f":"SUM('Review Workbook'!H18:I18)","v":0}]
["Conversion of units from nonresidential to residential (pursuant to NOFA §201 iii.)",null,null,null,null,null,0,{"$f":"SUM('Review Workbook'!H19:I19)","v":0}]
["New construction of dwelling units (pursuant to NOFA §201 iv.)",null,null,null,null,null,0,{"$f":"SUM('Review Workbook'!H20:I20)","v":0}]
["Purchase of affordability covenants and restrictions for units (pursuant to NOFA §201 v.)",null,null,null,null,null,0,{"$f":"SUM('Review Workbook'!H21:I21)","v":0}]
["Relocation costs for individuals who are being displaced as a result of Homekey project (pursuant to NOFA §201 vi.)",null,null,null,null,null,0,{"$f":"SUM('Review Workbook'!H22:I22)","v":0}]
["Capitalized operating subsidies for units purchased, converted or altered (not including Expedited Occupancy Bonus)\n(pursuant to NOFA §201 vi.)",null,{"$f":"C23","v":0},null,null,null,0,{"$f":"SUM('Review Workbook'!H24:I24)","v":0}]
["Bonus for Occupying Project 8 Months from Award Date \n(if applicable):\n(pursuant to NOFA §201 vi.)",null,{"$f":"IF(G25=\"Disencumbered/Forfeit\",0,C24)","v":0},null,null,null,0,{"$f":"SUM('Review Workbook'!H25:I25)","v":0}]
["TOTAL:",null,{"$f":"SUM(C28,C31:C37)","v":0},{"$f":"IF($G$25=\"Disencumbered/Forfeit\",SUM(D28,D31:D36)-D24,SUM(D28,D31:D37))","v":0},{"$f":"SUM(E28,E31:E37)","v":0},{"$f":"SUM(F28,F31:F37)","v":0},{"$f":"SUM(G28:G37)","v":0},{"$f":"C38-D38","v":0}]
["OTHER FUNDING SOURCES"]
["Instructions: Fill out the table below with all current capital and operational funding sources and amounts for this Homekey project. Operations funds will be included in the overall match amount in C49, but the Total Development Cost in Cell C50 should be the final cost, all in, of acquiring and rehabilitating the project. Use the notes to provide updates on any new sources of funding or applications and changes to development plan and cost."]
["Number of Project-Based Vouchers (PBVs) in Project:",null,null,null,"Total Value of PBVs:"]
["Source of Matching Funds",null,"Match Amount",null,"Type of Match",null,"Notes"]
[null,null,null,null,"Select One"]
[null,null,null,null,"Select One"]
[null,null,null,null,"Select One"]
[null,null,null,null,"Select One"]
[null,null,null,null,"Select One"]
[null,null,null,null,"Select One"]
["TOTAL FROM NON-HOMEKEY SOURCES:",null,{"$f":"SUM(C43:D48,G41)","v":0},null,"Notes:"]
["TOTAL DEVELOPMENT COST (Non-Homekey + Homekey Capital) If project is not completed, provide current estimate\n(Do not include Operations Costs):"]
["CERTIFICATION"]
["Sponsor agrees to employ the core components of Housing First in the property management and tenant selection process (pursuant to NOFA §501) ",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)"]
["    Name and Title of Grantee Representative (does not need to be Homekey Authorized Representative per resolution)",null,null,null,"     Date"]

{"sheet":"Report Narrative","index":1,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,1,9,7],[6,4,6,5],[10,4,10,5],[6,6,6,7],[21,1,21,7],[22,1,22,7],[23,1,23,7],[24,1,24,7],[28,1,28,7],[25,1,25,7],[26,1,26,7],[27,1,27,7],[29,1,29,7],[30,1,30,7],[31,1,31,7],[32,1,32,7],[33,1,33,7],[37,1,37,7],[38,1,38,7],[34,1,34,7],[35,1,35,7],[36,1,36,7],[0,3,0,7],[3,1,3,7],[11,4,11,5],[11,6,11,7],[12,1,12,7],[1,1,1,7],[6,2,6,3],[11,2,11,3],[10,2,10,3],[5,6,5,7],[5,4,5,5],[5,2,5,3],[8,5,8,6],[4,1,4,7],[10,6,10,7],[7,1,7,7]]}
[null,"Beginning of Sheet 2: Report Narrative"]
[null,"HOMEKEY PROGRAM\nHouseholds Served and Progress Narrative"]
[]
[null,"Instructions: Use the drop-down menus or fillable forms as applicable to answer questions A-K regarding requirements contained in your Standard Agrement"]
[null,"Refer to your Standard Agreement Exhibit E §A2 to answer questions A-D."]
[null,"A. Does this project have an obligation to serve individuals experiencing homelessness with at least 50% of the Project's Assisted Units? \nSee Standard Agreement Exhibit E §2. Project Narrative","Select One",null,"B. Does this project have an obligation to serve Homeless Youth and Youth at Risk of Homelessness (ages 0-25) with at least 25% of the Project's Assisted Units?\nSee Standard Agreement Exhibit E §2. Project Narrative",null,"Select One"]
[null,"C. Does this project have an obligation to serve Chronically Homeless Individuals with at least 25% of the Project's Assisted Units?\nSee Standard Agreement Exhibit E §2. Project Narrative","Select One",null,"D. Does this Project intentionally target another sub-population that is not obligated by your Homekey Standard Agreement? (e.g. Seniors, Veterans, LGBTQ+). If yes, please enter:"]
[null,"Refer to your Standard Agreement Exhibit E §B2 to answer questions E-G"]
[null,"E. Has this project committed to a 55 year deed restriction and waived any potential accommodation by the Department to increase income limits per NOFA §303?","Select One","F. If Yes to question E, what percentage of assisted units are permanently restricted? ","Select One","G. Will Project be able to Comply with waiver of increased income limits for the selected percentage of units?",null,"Select One"]
[null,"Additional Questions"]
[null,"H. Is Coordinated Entry utilized for tenant referrals per NOFA §502?","Select One",null,"I. Did this project receive a CEQA Exemption? If so, which one?",null,"Select One"]
[null,"J. Is Tenant Information input into HMIS? If not yet occupied, will tenant information be input into HMIS? Note: This is a California State requirement per AB-977","Select One",null,"K. Must your project's address be kept confidential due to serving an at-risk population? \nIf you answer \"Yes\", this Project's site will not be recommended for publicity events or visitation requests from HCD, Other State Departments or the State Legislature/Governor's Office. The project may still be subject to site visits for compliance monitoring.",null,"Select One"]
[null,"Instructions: Complete the following table with information regarding the individuals and households served with Homekey funds"]
[null,"Tenant Category","Currently Housed in Permanent Units:","Currently Housed in Interim/Transitional Units:","Housed using Program Funds over project lifetime \n(pursuant to NOFA §601 iv.): ","Total Exits to Permanent Housing over project lifetime","Total Exits to Homelessness over project lifetime","Total Exits to Other (e.g. transitional housing, hospital, rehab center, etc) over project lifetime"]
[null,"Total Number of Households \n(example: two parents and two children in the same family living in one unit = 1 household)"]
[null,"Total Number of Individuals\n(example: two parents and two children in the same family living in one unit = 4 individuals)"]
[null,"Chronic Homeless Individuals:"]
[null,"Minor Children (ages 17 and under):"]
[null,"Transition Aged Youth (ages 18-25):"]
[null,"Seniors (ages 65 and above):"]
[null,"Veterans:"]
[null,"1. Describe how tenant outreach and selection is being conducted. If referrals will be made using a prioritization system other than Coordinated Entry, please describe your plan for tenant selection. "]
[]
[null,"2. Describe the current and anticipated rate of turnover and reasons for program exits, if applicable."]
[]
[null,"3. Describe on-site and off-site supportive services made available to tenants (pursuant to NOFA §601 vii). Have any changes been made since the application? If yes, please explain and submit updated plan. "]
[]
[null,"4. Describe any lessons learned from the use of the Homekey funds (pursuant to NOFA §601 viii.). Include any barriers faced when trying to reach occupancy. Is there anything you would do differently if pursuing this strategy again? "]
[]
[null,"5. 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 §601 ix.)."]
[]
[null,"     5a. 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 and the estimated timeline for conversion."]
[]
[null,"6. Describe progress and status in securing required entitlements, permits and environmental clearances (pursuant to NOFA §601 x.)"]
[]
[null,"7. Provide the proposed timeline for the completion of the Project (pursuant to NOFA §601 xi.). Include dates of property acquisition, completion of rehabilitation and construction and other anticipated dates of completion for other performance milestones as listed in Exhibit E of the Standard Agreement."]
[]
[null,"8. Please share any success stories you've had from Homekey-funded projects.\nOptional: Grantee may send attachments and photos to Homekey2SGM@hcd.ca.gov. Content may be used for promotional or public-facing reports. Please obtain permission from tenants to use their stories and do not share any personal identifying information."]

{"sheet":"Project Details","index":2,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[21,6,21,7],[22,6,22,7],[28,6,29,9],[30,6,31,9],[32,6,33,9],[25,6,26,7],[25,8,26,8],[23,6,23,7],[24,6,24,7],[2,10,2,13],[18,6,18,7],[25,9,26,9],[17,6,17,7],[1,0,1,13],[2,1,2,2],[10,0,11,1],[10,2,11,9],[8,0,9,9],[12,0,12,9],[13,0,13,9],[14,8,14,9],[15,6,15,7],[16,6,16,7],[19,6,19,7],[20,6,20,7]]}
["Beginning of Sheet 3: Project Details"]
["HOMEKEY PROGRAM\nProject Details"]
["Sponsor and Contract:",{"$f":"Sponsor","v":0},null,{"$f":"'Expenditure Report'!B12","v":0},null,null,null,null,null,null,"Interim to Permanent Projects Only"]
["Site Name or Identifier","Project Site Full Address\nIf your project address is confidential, do not fill in this column","Project County","Geographic Region","Former Roomkey Site? ","Eligible Conversion Type\nSelect the original site building or construction type from the drop-down menu","Project Type\nper Standard Agreement Exhibit E","Current Project Status","Has Project Type or Conversion Type changed since Award?","Homekey Units Created to date\n\"Created\" means completed and ready to be occupied. Include manager/staff units","Conversion to Perm Start Date\n(projected or actual - interim to perm projects only)","Conversion to Perm End Date \n(projected or actual - interim to perm projects only)","Units Offline During Conversion\n (if known. If N/A, enter \"0\")","Planned Number of Units Post-Conversion"]
[null,null,"Select One",{"$f":"IF($C5>0,_xlfn.XLOOKUP($C5,'Drop-Down'!$A$10:$A$68,'Drop-Down'!$B$10:$B$68,\"Not Found\",0),\" \")","v":"Geographic Region"},"Select One","Select One","Select One","Select One","Select One"]
[null,null,"Select One",{"$f":"IF($C6>0,_xlfn.XLOOKUP($C6,'Drop-Down'!$A$10:$A$68,'Drop-Down'!$B$10:$B$68,\"Not Found\",0),\" \")","v":"Geographic Region"},"Select One","Select One","Select One","Select One","Select One"]
["Total:",null,null,null,{"$f":"_xlfn.CONCAT(\"Roomkey Sites: \"&COUNTIF(E5:E6,\"Yes\"))","v":"Roomkey Sites: 0"},null,null,null,null,{"$f":"SUM(J5:J6)","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(\"New Sites: \"&COUNTIF(E5:E6,\"No\"))","v":"New Sites: 0"}]
["*Department must grant special permission for structures lacking a permanent foundation. See NOFA §202"]
[]
["Additional Comments"]
[]
["Unit Mix"]
["Instructions: Input the number of units that have been or will be created for this project, bedrooms per unit and units restricted by target population.\nIf an interim to permanent project, fill out for the project as it will be once it converts to permanent. \nIf there is more than one bedroom size for the same population, use separate rows to report each of the distinct unit types.\nGeneral Target Population refers to the Homekey target population per NOFA Article 7 xxxi. Use this selection for any units that are not restricted to a special sub-population, even if currently occupied by a household that qualifies as a special sub-population.\nExisting tenants refers to tenants that do not fall under the Homekey Target Population but were already living on the property when the site was acquired and, at the time of acquisition, the tenant's household income was at or below the ELI limit, per NOFA §303 b. \nNon-Homekey Unit refers to any units that were acquired with the property but are not being supported by Homekey funding.\nOf the units listed, indicate how many are accessible to persons with mobility disabilities and how many are accessible to people with hearing or vision disabilities in columns E and F.\nIf your project is multi/scattered site, combine the units between sites for this table."]
["Total Doors Acquired",{"$f":"I7","v":0}]
["Target Population\nPlease select by how unit is restricted in Covenant or Regulatory Agreement, not who is occupying the unit.","Number of Units\n(NOFA §601 iii)","Number of Bedrooms \n(Studios are \"0\" BR)","Number of Units Currently Occupied","Number of Units Accessible to persons with mobility disabilities\nper 24 CFR part 8.22 \n(as applicable)","Number of Units Accessible to persons with hearing or vision disabilities\nper 24 CFR part 8.22 \n(as applicable)","Category",null,"Total Units","Percentage"]
["Select One",null,null,null,null,null,"Homekey-Assisted Units:",null,{"$f":"SUMIF(A17:A33,\"<>Non-Homekey Unit\",B17:B33)","v":0},{"$f":"IFERROR((SUMIF(A17:A33,\"<>Non-Homekey Unit\",B17:B33))/B34,0)","v":0}]
["Select One"," ",null,null,null,null,"Units for those Experiencing Homelessness ",null,{"$f":"SUMIF(A17:A33,\"Experiencing Homelessness (not Chronic)\",B17:B33)","v":0},{"$f":"IFERROR(I18/$I$17,0)","v":0}]
["Select One"," ",null,null,null,null,"Chronic Homeless Units:",null,{"$f":"SUMIF($A$17:$A$33, \"Chronically Homeless\",$B$17:$B$33)","v":0},{"$f":"IFERROR(I19/$I$17,0)","v":0}]
["Select One",null,null,null,null,null,"Youth Units:",null,{"$f":"SUMIF($A$17:$A$33, \"Homeless or at-risk Youth\",$B$17:$B$33)","v":0},{"$f":"IFERROR(I20/$I$17,0)","v":0}]
["Select One",null,null,null,null,null,"Mobility Accessible:",null,{"$f":"E34","v":0},0]
["Select One",null,null,null,null,null,"Hearing/Vision Accessible:",null,{"$f":"F34","v":0},0]
["Select One",null,null,null,null,null,"Existing Tenant Units:",null,{"$f":"SUMIF($A$17:$A$33,\"Existing Tenant\",B17:B33)","v":0},0]
["Select One",null,null,null,null,null,"Manager Units:",null,{"$f":"SUMIF($A$17:$A$33,\"Manager Unit\",$B$17:$B$33)","v":0},0]
["Select One",null,null,null,null,null,"Non-Homekey Units:",null,{"$f":"SUMIF(A17:A33,\"Non-Homekey Unit\",B17:B33)","v":0},{"$f":"IFERROR(SUMIF(A17:A33,\"Non-Homekey Unit\",B17:B33)/B34,0)","v":0}]
["Select One",null,null,null,null,null,"Units Created to Date from Project Details Table",null,{"$f":"J7","v":0},{"$f":"I26/I17","v":{"$error":"#DIV/0!"}}]
["Select One"]
["Select One"]
["Select One"]
["Select One"]
["Select One"]
["Select One"]
["Select One"]
["TOTALS",{"$f":"SUM(B17:B33)","v":0},null,{"$f":"SUM(D17:D33)","v":0},{"$f":"SUM(E17:E33)","v":0},{"$f":"SUM(F17:F33)","v":0}]

{"sheet":"Operational Costs","index":3,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,0,1,8],[63,1,63,2],[63,3,63,7],[65,1,65,2],[0,0,0,8],[2,2,2,3],[2,7,2,8],[4,0,4,1],[4,3,4,4],[4,5,4,6],[2,4,2,6],[5,0,5,1],[5,3,5,4],[5,5,5,6],[6,0,6,1],[6,3,6,4],[6,5,6,6],[17,1,17,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[7,3,7,4],[7,5,7,6],[29,1,29,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[3,3,3,4],[3,5,3,6],[51,1,51,2],[52,1,52,2],[41,1,41,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[53,1,53,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[46,1,46,2],[47,1,47,2]]}
["HOMEKEY PROJECT OPERATIONS EXPENDITURES"]
["Instructions: Fill out Operating Subsidy expenditures this reporting period by category in column E. The total amount should match the total amount expended on the Expenditure Details tab. Proof of reported expenditures must accompany this workbook. Use the space at the bottom of the table (beginning in Row 64) to explain where verification of stated expenditures can be found among your attached supplemental documents, if not immediately apparent."]
[null,null,"Reporting Period:",null,{"$f":"'Expenditure Report'!B19","v":"Select One"}]
[]
["Project Name:",null,{"$f":"'Expenditure Report'!G12","v":0},"Total Operating Subsidy:",null,{"$f":"'Expenditure Report'!C36+'Expenditure Report'!C37","v":0},null,"Homekey Units (including manager units)",{"$f":"'Project Details'!I17","v":0}]
["Project County:",null,{"$f":"'Project Details'!C5","v":"Select One"},"Expended This Period:",null,{"$f":"'Expenditure Report'!F36+'Expenditure Report'!F37","v":0},null,"Total Units:",{"$f":"'Project Details'!I17+'Project Details'!I25","v":0}]
["Prepared By:",null,{"$f":"'Expenditure Report'!B16","v":0},"Reported Prior Expended: ",null,{"$f":"('Expenditure Report'!E36+'Expenditure Report'!E37)-('Expenditure Report'!F36+'Expenditure Report'!F37)","v":0},null,"Proration %:",{"$f":"IF(I6=\"\",\"\",I5/I6)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Remaining Balance: ",null,{"$f":"F5-F6-F7","v":0}]
[null,null,null,null,"Total Expenditures ","Proration Percentage\n",null,"Operation Cost for Non-Assisted Units \n(NOT HOMEKEY ELIGIBLE)"]
[null,"Administrative Expenses:"]
[1,"Conventions and Meetings",null,6203,0]
[2,"Management Consultants",null,6204,0]
[3,"Advertising and Marketing",null,null,0]
[4,"Other Renting Expenses",null,6250,0]
[5,"Office Salaries",null,6310,0]
[6,"Office Expenses",null,6311,0]
[7,"Office or Model Apartment Rent",null,6312,0]
[8,"Management Fee (do not include GP Management Fee)",null,6320,0]
[9,"Manager or Superintendent Salaries",null,6330,0]
[10,"Administrative Rent Free Unit",null,6331,0]
[11,"Legal Expense - Project",null,6340,0]
[12,"Audit Expense",null,6350,0]
[13,"Bookkeeping Fees/ Accounting Services",null,6351,0]
[14,"Bad Debts",null,6370,0]
[15,"Misc. Administrative Expenses",null,6390,0]
[16,"Total Administrative Expenses",null,"6263T",{"$f":"SUM(E11:E25)","v":0},{"$f":"$I$7","v":{"$error":"#DIV/0!"}},{"$f":"E26*F26","v":{"$error":"#DIV/0!"}},{"$f":"E26-G26","v":{"$error":"#DIV/0!"}}]
[null,"Utilities:"]
[17,"Electricity",null,6450,0,{"$f":"$I$7","v":{"$error":"#DIV/0!"}}]
[18,"Water",null,6451,0,{"$f":"$I$7","v":{"$error":"#DIV/0!"}}]
[19,"Gas",null,6452,0,{"$f":"$I$7","v":{"$error":"#DIV/0!"}}]
[20,"Sewer",null,6453,0,{"$f":"$I$7","v":{"$error":"#DIV/0!"}}]
[21,"Total Utilities Expenses",null,"6400T",{"$f":"SUM(E28:E31)","v":0},{"$f":"$I$7","v":{"$error":"#DIV/0!"}},{"$f":"E32*F32","v":{"$error":"#DIV/0!"}},{"$f":"E32-G32","v":{"$error":"#DIV/0!"}}]
[null,"Operating and Maintenance Expenses:"]
[22,"Payroll",null,6510,0,{"$f":"$I$7","v":{"$error":"#DIV/0!"}}]
[23,"Supplies",null,6515,0,{"$error":"#DIV/0!"}]
[24,"Contracts",null,6520,0,{"$error":"#DIV/0!"}]
[25,"Operating and Maintenance Rent Free Unit",null,6521,0,{"$error":"#DIV/0!"}]
[26,"Garbage and Trash Removal",null,6525,0,{"$error":"#DIV/0!"}]
[27,"Security Payroll/Contracts",null,6530,0,{"$error":"#DIV/0!"}]
[28,"Security Rent Free Unit",null,6531,0,{"$error":"#DIV/0!"}]
[29,"Heating/Cooling Repairs and Maintenance",null,6546,0,{"$error":"#DIV/0!"}]
[30,"Snow Removal",null,6548,0,{"$error":"#DIV/0!"}]
[31,"Vehicle and Maintenance Equip. Operation and Repairs",null,6570,0,{"$error":"#DIV/0!"}]
[32,"Lease Expense",null,6580,0,{"$error":"#DIV/0!"}]
[33,"Misc. Operating & Maintenance Expenses",null,6590,0,{"$error":"#DIV/0!"}]
[34,"Total Operating and Maintenance Expenses",null,"6500T",{"$f":"SUM(E34:E45)","v":0},{"$error":"#DIV/0!"},{"$f":"E46*F46","v":{"$error":"#DIV/0!"}},{"$f":"E46-G46","v":{"$error":"#DIV/0!"}}]
[null,"Taxes and Insurance:"]
[35,"Real Estate Taxes",null,6710,0,{"$f":"$I$7","v":{"$error":"#DIV/0!"}}]
[36,"Payroll Taxes (Project's Share)",null,6711,0,{"$error":"#DIV/0!"}]
[37,"Property & Liability Insurance (Hazard)",null,6720,0,{"$error":"#DIV/0!"}]
[38,"Fidelity Bond Insurance",null,6721,0,{"$error":"#DIV/0!"}]
[39,"Worker's Compensation",null,6722,0,{"$error":"#DIV/0!"}]
[40,"Health Insurance and Other Employee Benefits",null,6723,0,{"$error":"#DIV/0!"}]
[41,"Miscellaneous Taxes, Licenses, Permits and Insurance",null,6790,0,{"$error":"#DIV/0!"}]
[42,"Total Taxes and Insurance",null,"6700T",{"$f":"SUM(E48:E54)","v":0},{"$error":"#DIV/0!"},{"$f":"E55*F55","v":{"$error":"#DIV/0!"}},{"$f":"E55-G55","v":{"$error":"#DIV/0!"}}]
[null,"Supportive Services Costs:",null,6990]
[43,"Staff Supervisors Salaries",null,null,0]
[44,"On-site Services Coordinator Salaries and Benefits",null,null,0]
[45,"On-site Other Supportive Services Staff Salaries",null,null,0]
[46,"Supportive Services Administrative Overhead",null,null," "]
[47,"Other Supportive Services Costs",null,6990," "]
[48,"Total Supportive Services Costs",null,"6900T",{"$f":"SUM(E57:E61)","v":0},1,{"$f":"SUM(G57:G61)","v":0},{"$f":"SUM(H57:H61)","v":0}]
[49,"Total Cost of Operations",null,"6000T",{"$f":"(E26+E32+E46+E55+E62)","v":0},null,{"$f":"G26+G32+G46+G55+G62","v":{"$error":"#DIV/0!"}},{"$f":"H26+H32+H46+H55+H62","v":{"$error":"#DIV/0!"}}]
[null,"Please indicate which attachments contain backup to expenditures using highlighting or indicating name of file and page number:"]

{"sheet":"Equity Strategies","index":4,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,1,15,2],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[3,1,3,4],[3,9,3,14],[3,5,3,8],[15,3,15,4],[9,9,9,10],[9,11,9,12],[9,13,9,14],[9,15,9,16],[9,17,9,18],[14,0,14,17],[4,0,4,18],[5,0,5,18],[8,0,8,18],[16,11,16,12],[16,13,16,14],[16,15,16,16],[16,17,16,18],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[1,0,1,18],[2,0,2,18],[3,15,3,17],[6,0,6,18],[7,0,7,18]]}
["beginning of sheet 5: Equity Strategies Update"]
["HOMEKEY PROGRAM\nSupplemental Equity Strategies Update Form"]
["\"Grantee shall, at the request of the Department, report back on any racial equity strategies described in the Homekey Application.\" Exhibit A, Section 7 \n"]
["HCD Contract Number:",{"$f":"'Expenditure Report'!B12","v":0},null,null,null,"Sponsor Name: ",null,null,null,{"$f":"'Expenditure Report'!B13","v":0},null,null,null,null,null,"Reporting Period:",null,null,{"$f":"'Expenditure Report'!B19","v":"Select One"}]
["Please explain how your Homekey project is advancing racial equity and inclusion, and addressing any disparities in program outcomes. 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."]
[]
["Please explain the extent to which your Homekey project commits to being accessible to persons with mobility, hearing, vision and other physical and/or sensory disabilities.  (pursuant to Standard Agreement Exhibit E Section 7)."]
[]
["Racial and Ethnic Composition of Tenants Assisted by Homekey (pursuant to NOFA §601 v.)\nInstructions: Use the table beginning in row 12 to list tenants assisted in the last reporting period by each Homekey project site. In the bottom row under the totals (Row 17), input the number of clients by the column identifier included in Stella or your local Point In Time Homeless Count data. "]
["Homekey Project Site","Total Number of Participants Served during reporting period",null,"Number of White, Non-Hispanic/Non-Latino Participants Served",null,"Number of White Hispanic/Latino Participants Served",null,"Number of Black/African American Participants served",null,"Number of Asian Participants Served",null,"Number of American Indian or Alaska Native Participants Served",null,"Number of Native Hawaiian/Other Pacific Islander Participants Served",null,"Number of Multiracial Participants served",null,"Number of Participants whose race is unknown, or declined to state"]
[null,"Total","Number With Disability(ies)","Total","Number With Disability(ies)","Total","Number With Disability(ies)","Total","Number With Disability(ies)","Total","Number With Disability(ies)","Total","Number With Disability(ies)","Total","Number With Disability(ies)","Total","Number With Disability(ies)","Total","Number With Disability(ies)"]
[{"$f":"'Project Details'!A5","v":0}]
[{"$f":"'Project Details'!A6","v":0}]
["Total:",{"$f":"SUM(B12:B13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Using data from Stella or the jurisdiction's local Point-In-Time (PIT) count, please insert your jurisdiction's outcomes here (using the latest available year as reference): \nStella Resources: https://www.hudexchange.info/resource/5827/stella-p-quick-start-guide/"]
[null,"Total Number",null,"White, Non-Hispanic/Non-Latino",null,"White Hispanic/Latino",null,"Black/African American ",null,"Asian",null,"American Indian or Alaska Native ",null,"Native Hawaiian/Other Pacific Islander",null,"Multiracial",null,"Race unknown, or declined to state"]
["Number of Individuals Experiencing Homelessness: "]

{"sheet":"Review Workbook","index":5,"n_rows":94,"n_cols":10,"rows_kept":94,"cut":false,"hidden":true,"merged":[[19,0,19,1],[20,0,20,1],[21,0,21,1],[28,0,28,6],[29,0,29,1],[29,3,29,4],[27,7,27,8],[0,0,0,6],[0,7,0,9],[1,0,1,6],[1,7,2,9],[2,0,2,6],[3,0,3,6],[14,0,14,1],[17,0,17,1],[18,0,18,1],[11,7,11,8],[3,7,3,8],[12,10,12,16],[13,0,13,1],[7,5,7,6],[8,0,8,1],[8,4,8,6],[9,0,9,1],[10,0,10,9],[4,0,5,1],[4,2,4,3],[4,5,4,6],[5,2,5,3],[5,5,5,6],[6,0,7,1],[6,2,6,3],[6,5,6,6],[7,2,7,3],[11,0,11,1],[12,0,12,1],[4,7,9,8],[4,9,9,9],[28,10,28,19],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[29,7,34,7],[29,8,34,8],[29,5,29,6],[30,0,30,1],[30,3,30,4],[30,5,30,6],[33,0,33,1],[33,3,33,4],[33,5,33,6],[34,0,34,1],[34,3,34,4],[34,5,34,6],[27,3,27,4],[35,0,35,6],[41,7,43,7],[31,0,31,1],[31,3,31,4],[31,5,31,6],[32,0,32,1],[32,3,32,4],[32,5,32,6],[36,7,39,7],[36,0,36,1],[36,3,36,5],[37,0,37,1],[37,3,37,4],[43,3,43,4],[41,8,43,8],[39,3,39,4],[40,0,40,1],[40,3,40,4],[40,5,40,6],[38,0,38,1],[38,3,38,4],[45,0,45,1],[45,3,45,4],[45,5,45,6],[43,5,43,6],[36,8,39,8],[45,7,47,7],[45,8,47,8],[46,0,46,1],[39,0,39,1],[47,0,47,1],[41,0,41,1],[41,3,41,4],[41,5,41,6],[42,0,42,1],[42,3,42,4],[42,5,42,6],[43,0,43,1],[44,0,44,6],[51,1,51,2],[51,3,51,6],[52,1,52,2],[52,3,52,6],[48,0,48,6],[49,1,49,2],[49,3,49,6],[50,1,50,2],[50,3,50,6],[55,1,55,2],[55,3,55,6],[56,1,56,2],[56,3,56,6],[53,1,53,2],[53,3,53,6],[54,1,54,2],[54,3,54,6],[70,1,70,5],[57,1,57,2],[57,3,57,6],[58,0,58,5],[60,0,65,0],[60,1,63,2],[60,4,63,4],[60,5,63,5],[64,1,64,5],[65,1,65,5],[90,3,90,5],[91,1,92,1],[91,2,92,2],[93,4,93,5],[84,0,89,0],[84,1,87,2],[84,4,87,4],[84,5,87,5],[88,1,88,5],[89,1,89,5],[78,0,83,0],[78,1,81,2],[78,3,79,3],[78,4,81,4],[78,5,81,5],[80,3,81,3],[82,1,82,5],[83,1,83,5],[66,0,71,0],[66,1,69,2],[66,4,69,4],[66,5,69,5],[72,1,75,2],[72,3,73,3],[72,4,75,4],[72,5,75,5],[74,3,75,3],[76,1,76,5],[77,1,77,5],[72,0,77,0],[71,1,71,5]]}
["Homekey Annual Report Summary\nFor HCD Staff Only",null,null,null,null,null,null,"Rep Overview of Project"]
["1. Instructions"]
["This page is for SGM Staff review only. SGM Rep: Please fill out all applicable green cells unless it is for Manager approval only. You will need to refer to outside documents to complete certain sections such as the Standard Agreement or prior Request for Funds forms.  If a cell turns red, that means there is an error or discrepancy in the way that the information was input into the report or a compliance issue and further review or a follow-up with the Grantee may be necessary. Comments are not required for every section, but where explanation may be necessary, please use the comment boxes along the right and be as thorough as possible."]
["2. Project Overview",null,null,null,null,null,null,"Rep Notes",null,"Manager Notes"]
["Rep Information",null,"Reviewing Rep Name",null,"Review Start Date","Review End Date"]
[]
["Manager Information",null,"Reviewing Manager Name",null,"Review Start Date","Manager Approval Date"]
[]
["HCD Contract Number:",null,{"$f":"'Expenditure Report'!B12","v":0},"Sponsor and Project Name ",{"$f":"_xlfn.CONCAT('Expenditure Report'!B13,\", \",'Expenditure Report'!G12)","v":", "}]
["Please enter the current expenditure deadline for this project (check the 2.0 Deadline and Extension Tracker for extensions that have been granted) ",null,null,"Please enter the current construction deadline for this project (check the 2.0 Deadline and Extension Tracker for extensions that have been granted) ",null,"Please enter the current Occupancy deadline for this project (check the 2.0 Deadline and Extension Tracker for extensions that have been granted) "]
["3. Expenditure Information"]
["Project Expenditures",null,null,null,null,null,null,"Rep Notes",null,"Manager Notes"]
["Has Capital Expenditure Deadline Passed? \nCheck for Extension before responding",null,"Select One","Has Grantee had a Budget Flex Form Approved since Standard Agreement Execution?\nIf yes, make sure Award Amounts reported reflect changes from Budget Flex Form","Select One","Has Occupancy Bonus been Forfeited? ","Select One"]
["Category",null,"Amount Awarded","Total Disbursed","Total Expenditures","Expended This Period","Amount Unexpended\nCapital amounts will turn red if there is a balance after deadline passed","Expenditures Verified by Previous Milestones/Reimbursements\nRefer to milestone reports submitted, RFFs for Reimbursement, and supplemental documents that are proof for previously claimed expenditures. Input amounts already verified by eligible activity in this column.","New Expenditures Verified in this Report\nReview any supplemental expenditure documents that show new expenditures made since Milestone/RFF report. Input amounts that can be supported with new proof of expenditure by eligible activity in this column. If an expenditure was already captured in column H, do not duplicate here.","Unverified Expenditures\nDifference between amount reported as expended and amounts Rep has confirmed with proof of expenditures. Capital amounts will turn red if there is a balance after expenditure deadline. If Grantee is reporting that all funds are expended but has not provided evidence for all expenditures, request proof for the amount unverified in the AR Review Letter."]
["Acquisition and Rehabilitation of motels, hotels, or hostels or other sites:",null,{"$f":"'Expenditure Report'!C28","v":0},{"$f":"'Expenditure Report'!D28","v":0},{"$f":"'Expenditure Report'!E28","v":0},{"$f":"'Expenditure Report'!F28","v":0},{"$f":"'Expenditure Report'!G28","v":0},null,null,{"$f":"C15-H15-I15","v":0}]
[null,"Acquisition Amount",null,null,{"$f":"'Expenditure Report'!E29","v":0},{"$f":"'Expenditure Report'!F29","v":0},null,null,null,0]
[null,"Rehabilitation Amount",null,null,{"$f":"'Expenditure Report'!E30","v":0},{"$f":"'Expenditure Report'!F30","v":0},null,null,null,0]
["Master leasing of properties:",null,{"$f":"'Expenditure Report'!C31","v":0},{"$f":"'Expenditure Report'!D31","v":0},{"$f":"'Expenditure Report'!E31","v":0},{"$f":"'Expenditure Report'!F29","v":0},{"$f":"'Expenditure Report'!G31","v":0},null,null,0]
["Conversion of units from nonresidential to residential:",null,{"$f":"'Expenditure Report'!C32","v":0},{"$f":"'Expenditure Report'!D32","v":0},{"$f":"'Expenditure Report'!E32","v":0},{"$f":"'Expenditure Report'!F30","v":0},{"$f":"'Expenditure Report'!G32","v":0},null,null,0]
["New Construction of Dwelling Units",null,{"$f":"'Expenditure Report'!C33","v":0},{"$f":"'Expenditure Report'!D33","v":0},{"$f":"'Expenditure Report'!E33","v":0},{"$f":"'Expenditure Report'!F31","v":0},{"$f":"'Expenditure Report'!G33","v":0},null,null,0]
["Purchase of affordability covenants and restrictions for units:",null,{"$f":"'Expenditure Report'!C34","v":0},{"$f":"'Expenditure Report'!D34","v":0},{"$f":"'Expenditure Report'!E34","v":0},{"$f":"'Expenditure Report'!F32","v":0},{"$f":"'Expenditure Report'!G34","v":0},null,null,0]
["Relocation costs for individuals who are being displaced:",null,{"$f":"'Expenditure Report'!C35","v":0},{"$f":"'Expenditure Report'!D35","v":0},{"$f":"'Expenditure Report'!E35","v":0},{"$f":"'Expenditure Report'!F33","v":0},{"$f":"'Expenditure Report'!G35","v":0},null,null,0]
["TOTAL CAPITAL",null,{"$f":"SUM(C15,C18:C22)","v":0},0,0,0,{"$f":"SUM(G15,G18:G22)","v":0},{"$f":"SUM(H15,H18:H22)","v":0},{"$f":"SUM(I15,I18:I22)","v":0},0]
["Capitalized operating subsidies for units purchased, converted or altered (without bonus):",null,{"$f":"'Expenditure Report'!C36","v":0},{"$f":"'Expenditure Report'!D36","v":0},{"$f":"'Expenditure Report'!E36","v":0},{"$f":"'Expenditure Report'!F36","v":0},{"$f":"'Expenditure Report'!G36","v":0},null,null,{"$f":"E24-H24-I24","v":0}]
["EXPEDITED OCCUPANCY BONUS: Capitalized operating subsidies for units purchased, converted or altered:",null,{"$f":"'Expenditure Report'!C37","v":0},{"$f":"'Expenditure Report'!D37","v":0},{"$f":"'Expenditure Report'!E37","v":0},{"$f":"'Expenditure Report'!F37","v":0},{"$f":"'Expenditure Report'!G37","v":0},null,null,{"$f":"E25-H25-I25","v":0}]
["TOTAL COSR",null,{"$f":"SUM(C24:C25)","v":0},0,0,0,0,{"$f":"SUM(H24:H25)","v":0},{"$f":"SUM(I24:I25)","v":0},{"$f":"E26-H26-I26","v":0}]
["TOTAL:",null,{"$f":"'Expenditure Report'!C38","v":0},{"$f":"'Expenditure Report'!D38","v":0},{"$f":"'Expenditure Report'!E38","v":0},{"$f":"'Expenditure Report'!F38","v":0},{"$f":"'Expenditure Report'!G38","v":0},{"$f":"H23+H26","v":0},{"$f":"I23+I26","v":0},{"$f":"E27-H27-I27","v":0}]
["COSR Amount Expended This Period Per Operational Costs Tab\nWill turn red if inconsistent with amount on Expenditure Report (F24). Will turn yellow if within $1 of each other (no action necessary)",null,{"$f":"'Operational Costs'!E63","v":0},"Prorated COSR Expended this period\nIf the project has both Homekey and non-Homekey funded units, this number reflects the actual amount of COSR expended on eligible units. If this is significantly different from the total amount of COSR funds expended in C28, consult with your Manager. If there are no non-HK units, disregard this (Manager units count as HK units)",null,{"$f":"'Operational Costs'!G63","v":{"$error":"#DIV/0!"}},"Can Eligible Expenditures on Operational Costs tab be Verified?","Select One"]
["4. Project and Unit Details\nNumbers may turn red if they require further investigation or there is a discrepancy with other information provided. Provide any additional context for responses in Rep Notes box.",null,null,null,null,null,null,"Rep Notes","Manager Notes"]
["Total Number of Homekey Assisted Units Created per Project Summary",null,{"$f":"'Project Details'!J7","v":0},"Homekey-Assisted Units per Unit Mix\nincludes manager units",null,{"$f":"'Project Details'!I17","v":0}]
["Do the numbers in cells C30 and F30 match? \nNote: these should match once construction is completd, unless interim to perm conversion will result in a different unit count",null,"Select One","Does the Unit Mix on Project Details Tab match the Unit Mix in the Standard Agreement Exhibit E? \nCompare numbers by bedroom sizes in addition to total number of units.",null,"Select One"]
["Assisted/Restricted Units Occupied\ndoes not count Manager Units",null,{"$f":"SUMIFS('Project Details'!D17:D33, 'Project Details'!A17:A33,\"<>Non-Homekey Unit\",'Project Details'!A17:A33,\"<>Unrestricted Manager Unit\")","v":0},"Homekey Occupancy Rate",null,{"$f":"IFERROR(C32/F30,0)","v":0}]
["Has Grantee Met their Occupancy Requirement?\nSelect N/A if the Occupancy deadline has not yet passed",null,"Select One","If no, is there a valid reason why? (explain in notes)",null,"Select One"]
["Reported Project Type(s):",null,{"$f":"_xlfn.CONCAT('Project Details'!G5, \", \", 'Project Details'!G6)","v":"Select One, Select One"},"Does this match the Project Type listed in the Standard Agreement/Project Overview Tab of the Tracker?\nIf no, explain in comments and follow-up with Grantee as needed",null,"Select One"]
["Has the Grantee submitted the correct Covenant for review? (15 year or 55 year)?",null,"Select One","Status of Covenant/Regulatory Agreement\nCovenants and agreements should be recorded no later than year 3. If nothing has been submitted past this point, please explain in comments and follow up with Grantee as needed.",null,"Select One"]
["5. Special Conditions\nThe following questions will not apply to all projects. Check Exhibit E to confirm that the condition does or does not apply. If it does not, select \"N/A\" in column C and proceed to the next question.",null,null,null,null,null,null,"Rep Notes","Manager Notes"]
["Expedited Occupancy Bonus Status:",null,{"$f":"'Expenditure Report'!G25","v":"Select One"},"Is Coordinated Entry Used?\nPlease note: Interim projects do not normally utilize Coordinated Entry.",null,null,{"$f":"'Report Narrative'!C11","v":"Select One"}]
["Reserved Units for those experiencing homelessness? Check the Standard Agreement Exhibit E under 2. Project Narrative to see if they agreed to reserve units for People Experiencing Homelessness",null,"Select One","Serving those experiencing Homelessness: Will turn red if they are required to serve but are not serving this sub-population. Percentage should be at least 50% if given points at application",null,{"$f":"'Report Narrative'!C6","v":"Select One"},{"$f":"'Project Details'!J18","v":0}]
["Chronic Homeless Project? Check the Standard Agreement Exhibit E under 2. Project Narrative to see if they agreed to reserve units for Chronically Homeless individuals",null,"Select One","Serving Chronic Homeless  Will turn red if they are required to serve but are not serving this sub-population. Percentage should be at least 25% if given points at application",null,{"$f":"'Report Narrative'!C7","v":"Select One"},{"$f":"'Project Details'!J19","v":0}]
["Youth Project? Check the Standard Agreement Exhibit E under 2. Project Narrative to see if they agreed to reserve units for Youth At-Risk or Experiencing Homelessness",null,"Select One","Serving Youth? Note:  Will turn red if they are required to serve but are not serving this sub-population. Percentage should be at least 25% if given points at application",null,{"$f":"'Report Narrative'!G6","v":"Select One"},{"$f":"'Project Details'!J20","v":0}]
["Number of Accessible units for disabled persons per 24 CFR part 8.22",null,{"$f":"'Project Details'!I21+'Project Details'!I22","v":0},"Percentage of Homekey units accessible for persons with disabilites per 24 CFR part 8.22",null,{"$f":"IFERROR(('Project Details'!I21+'Project Details'!I22)/'Project Details'!I17,0)","v":0},null,"Rep Notes","Manager Notes"]
["Percentage of units Accessible for mobility-impaired tenants",null,{"$f":"'Project Details'!J21","v":0},"Percentage of Homekey units accessible for persons with hearing/vision disabilites per 24 CFR part 8.23",null,{"$f":"'Project Details'!J22","v":0}]
["Has Grantee met Accessible Units requirements per Exhibit E?\nCheck Scope of Work section in SA. If there is no mention of a percentage or number of units that must be ADA accessible, select \"N/A\"",null,"Select One","If no, is there a valid reason why? (explain in notes)",null,"Select One"]
["Number of Units with Existing Tenants supported by HK",null,{"$f":"SUMIF('Project Details'!A17:A33,\"Existing Tenant\",'Project Details'!B17:B33)","v":0},"Percentage of Assisted Units with Existing Tenants \n(Can be no more than 49% - §303 of the NOFA)",null,{"$f":"IFERROR(C44/F30,0)","v":0}]
["6. Other Compliance Issues\n",null,null,null,null,null,null,"Rep Notes","Manager Notes"]
["HMIS Entry? This is a CA State requirement per AB 977.",null,{"$f":"'Report Narrative'!C12","v":"Select One"},"CEQA Status:",null,{"$f":"'Report Narrative'!G11","v":"Select One"}]
["Interim to Perm: Conversion Plan on File? (conversion plans should be submitted with occupancy milestone for Interim to Perm projects only. Select N/A if occupancy deadline has not passed)",null,"Select One","Is Interim to Perm Conversion Form Submitted? Should be if Construction start date is in next 60 days.","Select One","Planned Conversion Start Date:",{"$f":"_xlfn.IFS('Project Details'!K5>0,'Project Details'!K5,'Project Details'!K6>0,'Project Details'!K6,AND('Project Details'!K5=0,'Project Details'!K6=0),\"\")","v":""}]
["Has this project committed to a 55 year deed restriction and waived any potential accommodation by the Department to increase income limits per NOFA §303?",null,{"$f":"'Report Narrative'!C9","v":"Select One"},"If Yes, What Percentage of units must be restricted to 30% without potential to increase AMI?",{"$f":"'Report Narrative'!E9","v":"Select One"},"Are they in compliance?",{"$f":"'Report Narrative'!H9","v":"Select One"}]
["6. Report Narrative\n* Reporting Requirement per NOFA. Vague answers or blanks should not be accepted.",null,null,null,null,null,null,"Rep Notes\nAny areas of concerns or items to highlight?","Manager Notes"]
[1,"Description of Tenant Outreach",null,{"$f":"'Report Narrative'!B23","v":0}]
[2,"Description of anticipated turnover and reasons for exits",null,{"$f":"'Report Narrative'!B25","v":0}]
[3,"Description of Supportive Services* (NOFA 601 vii)",null,{"$f":"'Report Narrative'!B27","v":0}]
[4,"Lessons Learned* (NOFA §601 viii)",null,{"$f":"'Report Narrative'!B29","v":0}]
[5,"Proposed Development Vision:* (NOFA §601 ix)",null,{"$f":"'Report Narrative'!B31","v":0}]
["5a.","Changes to Proposed Development Vision: ",null,{"$f":"'Report Narrative'!B33","v":0}]
[6,"Progress and Status in securing required entitlements, permits, and environmental clearances:* (NOFA §601 x.)",null,{"$f":"'Report Narrative'!B35","v":0}]
[7,"Proposed Timeline for the completion of the project:* (NOFA §601 xi.)",null,{"$f":"'Report Narrative'!B37","v":0}]
[9,"Success Stories",null,{"$f":"'Report Narrative'!B39","v":0}]
["7. Risk Assessment\nFill out this section only after review is entirely complete. Do not assign risk scores for discrepancies or issues from the annual report until after Grantee has submitted all corrections and final documentation."]
[null,null,null,"Rating Categories","Evaluator’s Entry","Assigned Risk Score"]
[1,"Late Report Letters Issued\nIn the Evaluator's Entry Field, please select whether a 30, 60 or 90 day letter has been issued for this contract's Annual Report. In the event that a 60 or 90 day letter has been issued, it is assumed that the prior letter in the sequence has already been sent. ",null,"No Late Reports","Select One",{"$f":"_xlfn.IFS(E61= \"Select One\", 0, E61= \"No Late Reports\", 0, E61= \"30-Day Letter Issued\", 2, E61= \"60-Day Letter Issued\", 5, E61= \"90-Day Letter Issued\", 10)","v":0}]
[null,null,null,"30-Day Letter Issued"]
[null,null,null,"60-Day Letter Issued"]
[null,null,null,"90-Day Letter Issued"]
[null,"If a 90-day letter has been issued, please use the narrative box below to provide current status of the contract and any pending actions."]
[]
[2,"Outstanding Milestones\nExhibit B 3.\nIn the Evaluator's Entry Field, please select the number of Milestones that are past due by 30 days or more with no pending extensions INCLUDING Use Restrictions that are overdue without valid reason (such as awaiting LAD approval). If SGM has determined that milestones were delayed due to problems/circumstances outside the Grantees' control and has been in communication with the Grantee, select \"No Late Reports.\"\nNote: Do not count forfeitures of occupancy bonus or otherwised missed expedited occupancy deadlines. This deadline just reverts to 12 months + 90 days from award",null,"No Late Reports","Select One",{"$f":"_xlfn.IFS(E67=\"Select One\", 0,E67=\"No Late Reports\",0, E67= \"1 Late Notice Issued\", 1, E67= \"2-3 Late Notices Issued\", 5, E67= \"4+ Late Notices OR Occupancy/Construction/Expenditure Late Notice\", 10)","v":0}]
[null,null,null,"1 Delinquent Milestones Letter"]
[null,null,null,"2-3 Delinquent Milestones Letter"]
[null,null,null,"4+ Delinquent Milestone Letters OR \nConstruction OR Occupancy (non-expedited) Delinquent"]
[null,"If Multiple Milestone deadlines have been missed, please use the narrative box below to provide details on the requested extensions and their current status."]
[]
[3,"Unauthorized Changes to Unit Mix or Population Served, \nIn the Evaluator's Entry Field, please confirm whether the number of units and restrictions identified in this report align with the number of and restrictions for units required by the Standard Agreement. Changes that have been approved or are in process of being amended do not count against the Grantee",null,"Yes","Select One",{"$f":"_xlfn.IFS(E73=\"Select One\", 0, E73= \"Yes\", 10, E73= \"No\", 0)","v":0}]
[]
[null,null,null,"No"]
[]
[null,"If the Unit Mix or Populations Served have been changed by the Grantee without Department permission, please describe the violations here."]
[]
[4,"Verified or Unverified Expenditures\nIn the Evaluator's Entry Field, please confirm that funds have been expended on eligible activities/participants. \"Yes\" for funds being expended on eligible activities/participants. \"No\" for funds being spent on ineligible activities/participants or if proof has not been provided after attempts to request.",null,"Yes","Select One",{"$f":"_xlfn.IFS(E79=\"Select One\", 0, E79= \"Yes\", 0, E79= \"No\", 10)","v":0}]
[]
[null,null,null,"No"]
[]
[null,"If funds have been expended on ineligible activities/participants, please use the narrative box below to provide details and the current status of the contract/project."]
[]
[5,"Special Conditions and other Compliance Issues\nReview Sections 5 and 6 Above, and count how many compliance issues have arisen (after attempts to remedy, if applicable). Other compliance concerns not listed can also be counted here (e.g., other Special Conditions not listed), as long as they are described in the space below. If unsure whether an issue constitutes a concern, consult with your Manager. ",null,"1 Compliance Concern","Select One",{"$f":"_xlfn.IFS(E85=\"Select One\", 0, E85= \"1 Concern\", 5, E85= \"2-3 Concerns\", 10, E85= \"4+Concerns\", 15, E85= \"Non-Compliance/Breach of Contract\", 30)","v":0}]
[null,null,null,"2-3 Compliance Concerns"]
[null,null,null,"4+ Compliance Concerns"]
[null,null,null,"Any official Non-Compliance/Breach of Contract"]
[null,"If the Grantee has failed to fulfill Special Conditions or is in breach of contract requirements, please use the narrative box below to explain the issue and the measures that were taken to remedy the violations prior to assigning risk points."]
[]
[null,"SGM Representative:",{"$f":"C6","v":0},"Score Summary\nIf score is above 30 or project is recommended for site visit or penalty, Manager and Section Chief sign-off is required."]
[null,"Recommendation:   ","Select One","Risk Categories","Maximum Score","Project Risk Score"]
[null,null,null,"Risk Analysis Score",70,{"$f":"SUM(F61+F67+F73+F79+F85)","v":0}]
[null,"SGM Manager Sign-off\nFor scores above 5",null,"SGM Section Chief Sign-Off\nFor Scores above 30"]

{"sheet":"DataTable","index":6,"n_rows":2,"n_cols":148,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["HCD Contract Number","Project Name","Sponsor Name","Sponsor Type","Project County","Geographic Region","Project Address","Project Address 2 (if applicable)","Cosponsor1 Name","Cosponsor1 Type","Cosponsor2 Name","Cosponsor2 Type","Preparer Name","Preparer Title","Preparer Phone #","Preparer Email","HCD Rep","Reporting Period","Award Date","Contract Ex. Date","Project Type","Project Type 2","Total HCD Award","Capital","COSR Awarded","Exp. Occupancy Bonus","Exp Occupancy Status","$ Award Acquisition+Rehab","$ Award on Master Leasing of Properties","$ Award on Conversion of NonRes to Res","$ Award New Const.","$ Award on Purchase of Aff. Covenants","$ Award on Relocation","$ Award COSR ","Total Disbursed.","Total Expended ","Total Expended This Period","$ Exp Acq.","$ Exp Rehab","$ Expended Master Leasing","$ Exp Conversion","$ Exp New Constr.","$ Exp Aff. Covenants","$ Exp Relocation","$ Exp COSR ","Undisbursed Funds","Unexpended Funds","# PBVS","$ PBVS","Match Source 1","Amount","Match Type 1","Match Source 2","Amount","Match Type 2","Match Source 3","Amount","Match Type 3","Match Source 4","Amount","Match Type 4","Match Source 5","Amount","Match Type 5","Match Source 6","Amount","Match Type 6","Total Acquisition Match","Total Rehab Match","Total Relo Match","Total COSR Match","Total Other Match","Total Non-HK Sources","Total Cap Dev Cost","50% Homeless Obligation?","25% Chronic Homeless Obligation?","25% Youth Obligation?","Other Sub-Population Targeted","Waiver of AMI Increase?","Confidential Address?","Using HMIS","Using CE","CEQA Exemption","INDV Housed","HH Housed","INDV in Perm","INDV in Interim","Chronic Housed","Minor Child Housed","TAY Housed","Seniors Housed","Vets Housed","INDV Served Total","HH Served Total","Chronic Served Total","Minor Child Served Total","TAY Served Total","Seniors Served Total","Vets Served Total","INDV PH Exits","HH PH Exits","Chronic PH Exits","Minor Child PH Exits","TAY PH Exits","Seniors PH Exits","Vets PH Exits","INDV Homeless Exits","HH Homeless Exits","Chronic Homeless Exits","Minor Child Homeless Exits","TAY Homeless Exits","Seniors Homeless Exits","Vets Homeless Exits","# Project Sites","#Roomkey Sites","#HK Assisted Units \n(incl. mgr)","% Units Completed ","Asst 0-BR","Asst 1-BR","Asst 2-BR","Asst 3-BR+","Youth Units","Chronic Homeless Units","Unassist. Manager Units","Existing Tenant Units","Total Project Units","#HK Units","#HK Units Occupied","HK Occ Rate.","# Roomkey Sites","Cost Per Unit","Admin Exp.","Utilities Exp.","Operating/Mainten. Exp.","Taxes/Insurance","Supportive Services Exp.","Total Op Costs","Tenant Outreach","Anticipated Turnover","Description of Supportive Services","Lessons Learned","Proposed Dev Vision","Dev Vision Changes","Progress and Status securing Entitlements","Proposed Timeline for Project Completion","Success Stories","Equity Strategies","Accessibility"]
[{"$f":"'Expenditure Report'!B12","v":0},{"$f":"'Expenditure Report'!G12","v":0},{"$f":"'Expenditure Report'!B13","v":0},{"$f":"'Expenditure Report'!G13","v":"Select One"},{"$f":"'Project Details'!C5","v":"Select One"},{"$f":"'Project Details'!D5","v":"Geographic Region"},{"$f":"IF('Report Narrative'!G12=\"Yes\",\"Confidential\",'Project Details'!B5)","v":0},{"$f":"IF('Report Narrative'!G12=\"Yes\",\"Confidential\",'Project Details'!B6)","v":0},{"$f":"'Expenditure Report'!B14","v":0},{"$f":"'Expenditure Report'!G14","v":"Select One"},{"$f":"'Expenditure Report'!B15","v":0},{"$f":"'Expenditure Report'!G15","v":"Select One"},{"$f":"'Expenditure Report'!B16","v":0},{"$f":"'Expenditure Report'!G16","v":0},{"$f":"'Expenditure Report'!B17","v":0},{"$f":"'Expenditure Report'!G17","v":0},{"$f":"'Review Workbook'!C6","v":0},{"$f":"'Expenditure Report'!B19","v":"Select One"},{"$f":"'Expenditure Report'!B18","v":"00:00:00"},{"$f":"'Expenditure Report'!G18","v":"00:00:00"},{"$f":"'Project Details'!G5","v":"Select One"},{"$f":"'Project Details'!G6","v":"Select One"},{"$f":"'Expenditure Report'!C22+'Expenditure Report'!C23","v":0},{"$f":"'Expenditure Report'!C22","v":0},{"$f":"'Expenditure Report'!C23","v":0},{"$f":"'Expenditure Report'!C24","v":0},{"$f":"'Expenditure Report'!G25","v":"Select One"},{"$f":"'Expenditure Report'!C28","v":0},{"$f":"'Expenditure Report'!C31","v":0},{"$f":"'Expenditure Report'!C32","v":0},{"$f":"'Expenditure Report'!C33","v":0},{"$f":"'Expenditure Report'!C34","v":0},{"$f":"'Expenditure Report'!C35","v":0},{"$f":"'Expenditure Report'!C36","v":0},{"$f":"'Expenditure Report'!D38","v":0},{"$f":"'Expenditure Report'!E38","v":0},{"$f":"'Expenditure Report'!F38","v":0},{"$f":"'Expenditure Report'!E29","v":0},{"$f":"'Expenditure Report'!E30","v":0},{"$f":"'Expenditure Report'!E31","v":0},{"$f":"'Expenditure Report'!E32","v":0},{"$f":"'Expenditure Report'!E33","v":0},{"$f":"'Expenditure Report'!E34","v":0},{"$f":"'Expenditure Report'!E35","v":0},{"$f":"'Expenditure Report'!E36","v":0},{"$f":"'Expenditure Report'!H38","v":0},{"$f":"'Expenditure Report'!G38","v":0},{"$f":"'Expenditure Report'!C41","v":0},{"$f":"'Expenditure Report'!G41","v":0},{"$f":"'Expenditure Report'!A43","v":0},{"$f":"'Expenditure Report'!C43","v":0},{"$f":"'Expenditure Report'!E43","v":"Select One"},{"$f":"'Expenditure Report'!A44","v":0},{"$f":"'Expenditure Report'!C44","v":0},{"$f":"'Expenditure Report'!E44","v":"Select One"},{"$f":"'Expenditure Report'!A45","v":0},{"$f":"'Expenditure Report'!C45","v":0},{"$f":"'Expenditure Report'!E45","v":"Select One"},{"$f":"'Expenditure Report'!A46","v":0},{"$f":"'Expenditure Report'!C46","v":0},{"$f":"'Expenditure Report'!E46","v":"Select One"},{"$f":"'Expenditure Report'!A47","v":0},{"$f":"'Expenditure Report'!C48","v":0},{"$f":"'Expenditure Report'!E47","v":"Select One"},{"$f":"'Expenditure Report'!A48","v":0},0,{"$f":"'Expenditure Report'!E48","v":"Select One"},{"$f":"SUMIF('Expenditure Report'!E43:F48,\"Acquisition\",'Expenditure Report'!C43:D48)","v":0},{"$f":"SUMIF('Expenditure Report'!E43:F48,\"Rehabilitation\",'Expenditure Report'!D43:E48)","v":0},{"$f":"SUMIF('Expenditure Report'!E43:F48,\"Relocation\",'Expenditure Report'!C43:D48)","v":0},{"$f":"SUMIF('Expenditure Report'!E43:F48,\"Operations\",'Expenditure Report'!C43:D48)","v":0},{"$f":"SUMIF('Expenditure Report'!E43:F48,\"Other\",'Expenditure Report'!C43:D48)","v":0},{"$f":"'Expenditure Report'!C49","v":0},{"$f":"'Expenditure Report'!C50","v":0},{"$f":"'Report Narrative'!C6","v":"Select One"},{"$f":"'Report Narrative'!C7","v":"Select One"},{"$f":"'Report Narrative'!G6","v":"Select One"},{"$f":"'Report Narrative'!G7","v":0},{"$f":"'Report Narrative'!C9","v":"Select One"},{"$f":"'Report Narrative'!G12","v":"Select One"},{"$f":"'Report Narrative'!C12","v":"Select One"},{"$f":"'Report Narrative'!C11","v":"Select One"},{"$f":"'Report Narrative'!G11","v":"Select One"},{"$f":"'Report Narrative'!C16+'Report Narrative'!D16","v":0},{"$f":"'Report Narrative'!D16","v":0},{"$f":"'Report Narrative'!C16","v":0},{"$f":"'Report Narrative'!D16","v":0},{"$f":"'Report Narrative'!C17+'Report Narrative'!D17","v":0},{"$f":"'Report Narrative'!C18+'Report Narrative'!D18","v":0},{"$f":"'Report Narrative'!C19+'Report Narrative'!D19","v":0},{"$f":"'Report Narrative'!C20+'Report Narrative'!D20","v":0},{"$f":"'Report Narrative'!C21+'Report Narrative'!D21","v":0},{"$f":"'Report Narrative'!E16","v":0},{"$f":"'Report Narrative'!D15","v":0},{"$f":"'Report Narrative'!D17","v":0},{"$f":"'Report Narrative'!D18","v":0},{"$f":"'Report Narrative'!D19","v":0},{"$f":"'Report Narrative'!D20","v":0},{"$f":"'Report Narrative'!D21","v":0},{"$f":"'Report Narrative'!F16","v":0},{"$f":"'Report Narrative'!F15","v":0},{"$f":"'Report Narrative'!F17","v":0},{"$f":"'Report Narrative'!F18","v":0},{"$f":"'Report Narrative'!F19","v":0},{"$f":"'Report Narrative'!F20","v":0},{"$f":"'Report Narrative'!F21","v":0},{"$f":"'Report Narrative'!G16","v":0},{"$f":"'Report Narrative'!G15","v":0},{"$f":"'Report Narrative'!G17","v":0},{"$f":"'Report Narrative'!G18","v":0},{"$f":"'Report Narrative'!G19","v":0},{"$f":"'Report Narrative'!G20","v":0},{"$f":"'Report Narrative'!G21","v":0},{"$f":"COUNTA('Project Details'!A5:A6)","v":0},{"$f":"COUNTIF('Project Details'!E5:E7,\"Yes\")","v":0},{"$f":"'Project Details'!J7","v":0},{"$f":"'Project Details'!J26","v":{"$error":"#DIV/0!"}},{"$f":"SUMIFS('Project Details'!B17:B33,'Project Details'!C17:C33,\"0\",'Project Details'!A17:A33,\"<>Non-Homekey Unit\")","v":0},{"$f":"SUMIFS('Project Details'!B17:B33,'Project Details'!A17:A33,\"<>'Unit Mix'!Non-Homekey Unit\",'Project Details'!C17:C33,\"1\")","v":0},{"$f":"SUMIFS('Project Details'!C17:C33,'Project Details'!B17:B33,\"<>'Unit Mix'!Non-Homekey Unit\",'Project Details'!D17:D33,\"2\")","v":0},{"$f":"SUMIFS('Project Details'!D17:D33,'Project Details'!C17:C33,\"<>'Unit Mix'!Non-Homekey Unit\",'Project Details'!E17:E33,\"3+\")","v":0},{"$f":"SUMIF('Project Details'!A17:A33,\"Homeless or at-risk Youth\",'Project Details'!B17:B33)","v":0},{"$f":"SUMIF('Project Details'!B17:B33,\"Chronically Homeless\",'Project Details'!C17:C33)","v":0},{"$f":"SUMIF('Project Details'!C17:C33,\"Unrestricted Manager Unit\",'Project Details'!D17:D33)","v":0},{"$f":"SUMIF('Project Details'!D17:D33,\"Existing Tenant\",'Project Details'!E17:E33)","v":0},{"$f":"'Project Details'!B34","v":0},{"$f":"SUMIFS('Project Details'!B17:B33,'Project Details'!A17:A33,\"<>Non-Homekey Unit\",'Project Details'!A17:A33,\"<>Existing Tenant\")","v":0},{"$f":"SUMIFS('Project Details'!D17:D33,'Project Details'!A17:A33,\"<>Non-Homekey Unit\")","v":0},{"$f":"DX2/DW2","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Project Details'!E5:E6,\"Yes\")","v":0},{"$f":"BV2/DV2","v":{"$error":"#DIV/0!"}},{"$f":"'Operational Costs'!E26","v":0},{"$f":"'Operational Costs'!E32","v":0},{"$f":"'Operational Costs'!E46","v":0},{"$f":"'Operational Costs'!E55","v":0},{"$f":"'Operational Costs'!E62","v":0},{"$f":"'Operational Costs'!E63","v":0},{"$f":"'Report Narrative'!B23","v":0},{"$f":"'Report Narrative'!B25","v":0},{"$f":"'Report Narrative'!B27","v":0},{"$f":"'Report Narrative'!B29","v":0},{"$f":"'Report Narrative'!B31","v":0},{"$f":"'Report Narrative'!B33","v":0},{"$f":"'Report Narrative'!B35","v":0},{"$f":"'Report Narrative'!B37","v":0},{"$f":"'Report Narrative'!B39","v":0},{"$f":"'Equity Strategies'!A6","v":0},{"$f":"'Equity Strategies'!A8","v":0}]

{"sheet":"Site Data","index":7,"n_rows":3,"n_cols":17,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Contract Number","Sponsor","Project Name","Site Name","Site Address","Project County","Geo Region","Roomkey?","Conversion Type","Project Type","Current Project Status","Has Project Changed since SA?","Construction Start Date","Construction End Date","Units Offline during Construction","Units Post-Conversion","Addtl Comments"]
[{"$f":"IF(D2=\"\",\"\",'Expenditure Report'!$B$12)","v":0},{"$f":"IF(D2=\"\",\"\",Sponsor)","v":0},{"$f":"'Expenditure Report'!$G$12","v":0},{"$f":"'Project Details'!A5","v":0},{"$f":"'Project Details'!B5","v":0},{"$f":"'Project Details'!C5","v":"Select One"},{"$f":"'Project Details'!D5","v":"Geographic Region"},{"$f":"'Project Details'!E5","v":"Select One"},{"$f":"'Project Details'!F5","v":"Select One"},{"$f":"'Project Details'!G5","v":"Select One"},{"$f":"'Project Details'!H5","v":"Select One"},{"$f":"'Project Details'!I5","v":"Select One"},{"$f":"'Project Details'!K5","v":"00:00:00"},{"$f":"'Project Details'!L5","v":"00:00:00"},{"$f":"'Project Details'!M5","v":0},{"$f":"'Project Details'!N5","v":0},{"$f":"'Project Details'!C11","v":0}]
[{"$f":"IF(D3=\"\",\"\",'Expenditure Report'!$B$12)","v":0},0,{"$f":"'Expenditure Report'!$G$12","v":0},{"$f":"'Project Details'!A6","v":0},{"$f":"'Project Details'!B6","v":0},{"$f":"'Project Details'!C6","v":"Select One"},{"$f":"'Project Details'!D6","v":"Geographic Region"},{"$f":"'Project Details'!E6","v":"Select One"},{"$f":"'Project Details'!F6","v":"Select One"},{"$f":"'Project Details'!G6","v":"Select One"},{"$f":"'Project Details'!H6","v":"Select One"},{"$f":"'Project Details'!I6","v":"Select One"},{"$f":"'Project Details'!K6","v":"00:00:00"},{"$f":"'Project Details'!L6","v":"00:00:00"},{"$f":"'Project Details'!M6","v":0},{"$f":"'Project Details'!N6","v":0}]

{"sheet":"Equity Data","index":8,"n_rows":2,"n_cols":46,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["HCD Contract","Sponsor","Reporting Period","Total HK","Total PIT","# White HK","# White PIT","% Wt HK","% Wt PIT","# Latinx HK","# Latinx PIT","% Latinx HK","% Latinx PIT","# Black/AA HK","# Black/AA PIT","% Black/AA HK","% Black/AA PIT","# Asian HK","# Asian HMIS","% Asian HK","% Asian PIT","# AIAN HK","# AIAN PIT","% AIAN HK","% AIAN PIT","# HI/PI HK","#HI/PI HMIS","% HI/PI HK","% HI/PI HMIS","# Multi HK","# Multi HMIS","%Multi HK","%Multi HMIS","# Unknown HK","# Unknown HMIS","% Unknown HK","% Unknown HMIS","Total Disabled (DA)","White DA","Latinx DA","Black DA","Asian DA ","AIAN DA","HI/PI DA","Multi DA","Unknown DA"]
[{"$f":"'Expenditure Report'!B12","v":0},{"$f":"'Expenditure Report'!B13","v":0},{"$f":"'Expenditure Report'!B19","v":"Select One"},{"$f":"'Equity Strategies'!B14","v":0},{"$f":"'Equity Strategies'!B17","v":0},{"$f":"'Equity Strategies'!D14","v":0},{"$f":"'Equity Strategies'!D17","v":0},{"$f":"F2/D2","v":{"$error":"#DIV/0!"}},{"$f":"G2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!F14","v":0},{"$f":"'Equity Strategies'!F17","v":0},{"$f":"J2/D2","v":{"$error":"#DIV/0!"}},{"$f":"K2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!H14","v":0},{"$f":"'Equity Strategies'!H17","v":0},{"$f":"N2/D2","v":{"$error":"#DIV/0!"}},{"$f":"O2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!J14","v":0},{"$f":"'Equity Strategies'!J17","v":0},{"$f":"R2/D2","v":{"$error":"#DIV/0!"}},{"$f":"S2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!L14","v":0},{"$f":"'Equity Strategies'!L17","v":0},{"$f":"V2/D2","v":{"$error":"#DIV/0!"}},{"$f":"W2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!N14","v":0},{"$f":"'Equity Strategies'!N17","v":0},{"$f":"Z2/D2","v":{"$error":"#DIV/0!"}},{"$f":"AA2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!P14","v":0},{"$f":"'Equity Strategies'!P17","v":0},{"$f":"AD2/D2","v":{"$error":"#DIV/0!"}},{"$f":"AE2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!R14","v":0},{"$f":"'Equity Strategies'!R17","v":0},{"$f":"AH2/D2","v":{"$error":"#DIV/0!"}},{"$f":"AI2/E2","v":{"$error":"#DIV/0!"}},{"$f":"'Equity Strategies'!C14","v":0},{"$f":"'Equity Strategies'!E14","v":0},{"$f":"'Equity Strategies'!G12","v":0},{"$f":"'Equity Strategies'!I12","v":0},{"$f":"'Equity Strategies'!K12","v":0},{"$f":"'Equity Strategies'!M12","v":0},{"$f":"'Equity Strategies'!O12","v":0},{"$f":"'Equity Strategies'!Q12","v":0},{"$f":"'Equity Strategies'!S12","v":0}]

{"sheet":"Risk Analysis Data","index":9,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract #","Sponsor","Coapplicant 1","Coapplicant 2","Late Reports Score","Outstanding Milestones Score","Unauthorized Change Score","Unverified Expenditure Score","Other Compliance Concerns","Total Risk Score"]
[{"$f":"'Review Workbook'!C9","v":0},{"$f":"Sponsor","v":0},{"$f":"'Expenditure Report'!B14","v":0},{"$f":"'Expenditure Report'!B15","v":0},{"$f":"'Review Workbook'!F61","v":0},{"$f":"'Review Workbook'!F67","v":0},{"$f":"'Review Workbook'!F73","v":0},{"$f":"'Review Workbook'!F79","v":0},{"$f":"'Review Workbook'!F85","v":0},{"$f":"'Review Workbook'!F93","v":0}]

{"sheet":"Drop-Down","index":10,"n_rows":120,"n_cols":3,"rows_kept":120,"cut":false,"hidden":true,"merged":[]}
["Reporting Period","Due Date"]
["Select One"]
["January 1, 2022 - December 31, 2022 ","Report Due January 31, 2023"]
["January 1, 2023 - December 31, 2023 ","Report Due January 31, 2024"]
["January 1, 2024 - December 31, 2024 ","Report Due January 31, 2025"]
["January 1, 2025 - December 31, 2025 ","Report Due January 31, 2026"]
["January 1, 2026 - December 31, 2026","Report Due January 31, 2027"]
[]
["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"]
[]
["Special Conditions",null,"Tenant Support Services"]
["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.  ",null,"Coordination of Medical and Behavioral Health"]
["At least nine months prior to conversion, Sponsor shall obtain Department review and written approval of the unit replacement plan.",null,"Substance Abuse Use Disorder Treatment"]
["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.",null,"Employment Services"]
["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.",null,"Life Skills Training"]
["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. ",null,"Peer Support"]
["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",null,"Crisis Management Interventions"]
["Notice of Exemption",null,"Other"]
["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"]
["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"]
["Type of Conversion"]
["Select One"]
["Existing Rehab - Hotels/Motels/Hostels"]
["Existing Rehab - Commercial/Office Space"]
["Existing Rehab - Adult Residential Facilities"]
["Existing Rehab - Multifamily Rental"]
["Existing Rehab - Single Family Home"]
["Existing Rehab - Other (please explain in comments)"]
["Manufactured Housing"]
["New Construction - Not manufactured"]
["New Construction - ADU"]
["Affordability Covenant"]
["Master Leasing"]
["Other (please explain in comments)"]
["Type of Applicant"]
["Select One"]
["City"]
["County"]
["City and County"]
["Housing Authority"]
["State"]
["Tribal Entity"]
["Other Public Agency"]
["Nonprofit Entity"]
["For-profit Entity"]