{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Grantee Cert. + Project Status","1. Expenditure Report","2.Standard Agreement Compliance","3. Operating Costs","4. Equity Strategies","5. Progress and Outcomes","6. Report Summary","Drop-Down","DataTable","Site Data","Equity Data","Risk Analysis Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":93,"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":"Grantee Cert. + Project Status","index":0,"n_rows":76,"n_cols":5,"rows_kept":76,"cut":false,"hidden":false,"merged":[[51,0,51,4],[0,0,0,4],[1,0,1,4],[12,1,12,2],[13,3,13,4],[2,0,2,4],[3,1,3,2],[9,1,9,2],[10,1,10,2],[27,0,27,4],[34,0,34,1],[50,0,50,4],[36,0,36,1],[35,0,35,1],[29,0,29,1],[30,0,30,1],[63,0,63,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[59,0,59,1],[61,0,61,1],[55,0,55,1],[60,0,60,1],[56,0,56,1],[58,0,58,1],[40,0,40,4],[41,0,41,1],[75,0,75,3],[76,0,76,3],[73,0,73,4],[67,0,67,3],[68,0,68,3],[69,0,69,3],[70,0,70,3],[71,0,71,3],[72,0,72,3],[74,0,74,4],[66,0,66,4],[65,0,65,4],[62,0,62,1],[57,0,57,1],[28,0,28,4],[37,0,37,1],[38,0,38,1],[26,0,26,1],[23,0,23,4],[24,0,24,4],[25,0,25,1],[32,0,32,1],[33,0,33,1],[31,0,31,1],[11,1,11,2],[14,1,14,2],[13,0,13,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2]]}
["Homekey Annual Report - Grantee Certification & Project Status"]
["Instructions: Annual Reports are a requirement of the Homekey Program as stated in the NOFA and in the Standard Agreeements. Please fill out this form and submit it to the Department prior by the reporting due date. Please complete the sections of the report as required; only if the project is fully occupied and operational must the entire report be completed.  Otherwise, if the project is not yet occupied and operational, please complete this tab and tab 1. Expenditure Report. Forms should be submitted to your assigned Grant Management Representative for the respective funding Round and Contract Number."]
["1. Project and Grantee Information"]
["Reporting Period:",null,null,"Homekey Round","Select One"]
["  HCD Contract Number:",null,null,"Project Name:"]
["Grantee Name:",null,null,"Grantee Type"]
["Co-Applicant 1 Name:",null,null,"Co-Applicant 1 Type:"]
["Co-Applicant 2 Name:",null,null,"Co-Applicant 2 Type:"]
["Preparer Name:",null,null,"Preparer Title:"]
["Preparer phone number:",null,null,"Preparer Email:"]
["Project County",null,null,"Geographic Region",{"$f":"IF('Grantee Cert. + Project Status'!$B11>0,_xlfn.XLOOKUP('Grantee Cert. + Project Status'!$B11,'Drop-Down'!$A$9:$A$67,'Drop-Down'!$B$9:$B$67,\"Not Found\",0),\" \")","v":" "}]
["Question","Grantee Response",null,"HCD Verification","Notes"]
["Must your project's address be kept confidential due to serving individuals for whom disclosing their location could lead to substantial harm?","Select One",null,"Select One"]
["If you answer \"Yes\", this Project's site will not be recommended for publicity events or visitaton 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. "]
["Total Number of Sites \nSelect 1 if not a Scattered Site Project\nIf your project address is confidential, please do not fill in the site address. ","Select One",null,"Select One"]
["Site 1 - Address / APN(s)",null,null,"Select One"]
["Site 2 - Address / APN(s)",null,null,"Select One"]
["Site 3 - Address / APN(s)",null,null,"Select One"]
["Site 4 - Address / APN(s)",null,null,"Select One"]
["Site 5 - Address / APN(s)",null,null,"Select One"]
["Site 6 - Address / APN(s)",null,null,"Select One"]
["Site 7 - Address / APN(s)",null,null,"Select One"]
[]
["2. Project Status Questions"]
["Instructions: Please select Yes or No to the following questions regarding the current status of your project. Your answers will determine which sections of this report must be filled out. Select all that apply."]
["Question",null,"Grantee Response","HCD Verification","Notes"]
["Overall Site Status",null,"Select One","No Findings"]
[{"$f":"_xlfn.IFS(OR(C27=\"Fully Occupied and Operational\",C27=\"Interim to Perm - Fully Occupied and Operational\"),\"The Project is fully occupied and operational.  Including this tab, you are required to complete tabs 1. Expenditure Report through 5. Progress and Outcomes of this report\",OR(C27=\"Construction not yet started\",C27=\"Construction Complete - Leasing Up\",C27=\"Under Construction\",C27=\"Under Construction (Occupied Offsite)\",C27=\"Interim to Perm - Under Construction\",C27=\"Interim to Perm - Construction Complete - Leasing Up\"),\"The Project is not yet fully occupied and operational. Including this tab, you are requried to complete Tab 1. Expenditure Report of this report. Tabs 2. Standard Agreement Compliance through 5. Progress and Outcomes are not required for this report\",C27=\"Select One\",\"\")","v":""}]
[{"$f":"IF(C27=\"Select One\",\"\",\"HCD will complete tab 6. Report Summary.\")","v":""}]
["If construction has started, please enter the Construction Start Date:",null,null,"Select One"]
["If \"Construction not yet started\" was chosen above, please explain why in the box to the right:",null,null,"Select One"]
["If \"Fully Occupied and Operational\" was chosen above, please select how many years the project has been occupied",null,"Select One","Select One"]
["Please select the unit type that is or will be provided?",null,"Select One","Select One"]
["Please select from the drop-down the project type that best describes this project.",null,"Select One","Select One"]
["If \"Other\" was selected above, please describe the project in the box to the right:",null,null,"No Findings"]
["Has Unit Type (C33) or Project Type Changed (C34) since Award?",null,"Select One","No Findings"]
["Grantee agrees to employ the core components of Housing First in the property management and tenant selection process (pursuant to NOFA §501) \t",null,"Select One","No Findings"]
["Was the Occupancy Bonus Award forfeited?",null,"Select One","No Findings"]
["Has a Flex Form been submitted and approved by the Department?",null,"Select One","No Findings"]
[]
["3. Milestone Completion and Due Date Summary"]
["Project has completed all milestones by thier Original Standard Agreement (SA) or approved, extended due dates. Project also does not have any late milestones.",null,"Select One","Select One"]
["Milestone","Current Due Date \n(Original SA Date or Latest Approved, Extended Date)","Date Achieved","HCD Verification","Notes"]
["Site Acquisition",null,null,"Select One"]
["Capital Expenditures",null,null,"Select One"]
["Construction Completion",null,null,"Select One"]
["Full Occupancy (at least 90% occupancy rate)",null,null,"Select One"]
["Recorded Use Restriction",null,null,"Select One"]
["Capitalized Operating Subsidy Reserve (COSR) Expenditures",null,null,"Select One"]
[]
["Interim to Permanent Conversion Projects Only"]
["Instructions: Please complete the section below if the project is considered an Interim to Permanent Conversion per the Standard Agreement.  If the project is not Interim to Perm, please double-check the response the the question above, \"please select the unit type that is or will be provided\"."]
["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","Select One"]
["Is Interim to Perm Conversion Notice Form Submitted? \nShould be if Construction start date is in next 60 days.",null,"Select One","Select One"]
["Date of Construction Start (Anticipated)",null,null,"Select One"]
["Date of Construction Start (Actual)",null,null,"Select One"]
["Number of Units Pre-Conversion/Interim Phase (Actual)",null,null,"Select One"]
["Number of Units Offline During Construction",null,null,"Select One"]
["Number of Units Post-Conversion/Perm Phase (Anticipated)",null,null,"Select One"]
["Date of Construction Completion (Anticipated)",null,null,"Select One"]
["Date of Construction Completion (Actual)",null,null,"Select One"]
["Date of full Occupancy Post-Conversion (Actual)",null,null,"Select One"]
["Date Permanent Use Restriction Recorded (Actual)",null,null,"Select One"]
["Is Interim to Perm Completion Form Submitted? \nShould be within 90 days of Construction Completion",null,"Select One","Select One"]
[]
["4. Certification"]
["***By signing this request, I certify to the best of my knowledge and belief that the information presented in this form 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)"]
[{"$f":"IF(OR(C27=\"Fully Occupied and Operational\",C27=\"Interim to Perm - Fully Occupied and Operational\"),\"This Project is fully occupied and operational.  Including this Tab, Tabs 1. Expenditure Report through 5. Progress and Outcomes have been completed, as required\",\"Project is not yet fully occupied and operational. Including this tab, Tab 1. Expenditure Report has been completed, as required. Tabs 2, Standard Agreement Compliance, through 5, Progress and Outcomes, are not required for this report\")","v":"Project is not yet fully occupied and operational. Including this tab, Tab 1. Expenditure Report has been completed, as required. Tabs 2, Standard Agreement Compliance, through 5, Progress and Outcomes, are not required for this report"},null,null,null,"Select One"]
["Grantees shall submit their first annual Homekey program report to the Department the year following Standard Agreement execution. \nTo ensure the Department captures five years of operations, Grantees will be required to submit annual Homekey program reports for 5 years following full occupancy of the project.  \nIf at year 5 the project has not fully expended their COSR award, Grantees will be required to continue reporting annually until 100% of their COSR has been expended. \nEach annual report will be due no later than March 31 for the prior calendar year of January 1 to December 31. \nThe report shall be in such form and contain such information as required by the Department in its sole and absolute discretion.",null,null,null,"Select One"]
["Housing First: Grantee agrees to employ the core components of Housing First in the property management and tenant selection process (pursuant to NOFA §501) ",null,null,null,"Select One"]
["Insurance:  Grantee affirms the project is maintaining insurance coverages as required by the Standard Agreement and NOFA.",null,null,null,"Select One"]
["Supportive Services: Grantee affirms supportive services are being administered in accordance with the HCD-approved supportive services plan, the Standard Agreement, and the NOFA.",null,null,null,"Select One"]
["Events and Promotional Materials: Would you like this project to be included in recommendations for publicity events and State promotional materials, including potential Governor's Office or Legislature press events, published materials on program successes, or other uses intended to promote Homekey or other State Housing programs?",null,null,null,"Select One"]
["Name of Preparer Agency Authorized Official \n(does not need to be Homekey Authorized Representative per resolution)"]
[]
["Signature (Electronic, Typed Only)",null,null,null,"Date"]

{"sheet":"1. Expenditure Report","index":1,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":false,"merged":[[81,1,81,6],[76,1,76,2],[76,3,76,5],[73,1,73,2],[73,3,73,4],[73,6,73,7],[66,1,66,5],[74,1,74,2],[74,3,74,5],[71,1,71,2],[71,3,71,4],[68,1,68,2],[68,3,68,4],[68,6,68,7],[75,1,75,2],[75,3,75,5],[70,1,70,2],[70,3,70,4],[28,1,28,2],[29,1,29,2],[34,1,34,4],[35,1,35,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[72,1,72,2],[72,3,72,4],[69,1,69,2],[69,3,69,4],[32,1,32,10],[31,1,31,10],[39,1,39,10],[41,1,41,10],[56,1,56,10],[57,1,57,10],[33,1,33,4],[83,3,83,4],[83,6,83,7],[84,1,84,2],[84,3,84,4],[84,6,84,7],[82,1,82,2],[82,3,82,4],[82,5,82,6],[83,1,83,2],[82,7,82,10],[83,8,83,10],[84,8,84,10],[85,8,85,10],[86,8,86,10],[87,8,87,10],[88,8,88,10],[89,1,89,2],[89,3,89,4],[90,1,90,2],[90,3,90,4],[91,1,91,2],[91,3,91,4],[87,1,87,2],[87,3,87,4],[87,6,87,7],[89,5,89,10],[90,5,90,10],[91,5,91,10],[88,1,88,2],[88,3,88,4],[88,6,88,7],[85,1,85,2],[85,3,85,4],[85,6,85,7],[86,1,86,2],[86,3,86,4],[86,6,86,7],[0,1,0,10],[1,1,1,10],[5,7,5,10],[5,2,5,5],[4,7,4,10],[4,2,4,5],[2,2,2,5],[2,7,2,10],[3,7,3,10],[3,2,3,5],[67,8,67,10],[68,8,68,10],[69,8,69,10],[70,8,70,10],[71,8,71,10],[72,8,72,10],[9,1,9,10],[8,1,8,10],[7,1,7,10],[67,1,67,2],[67,3,67,4],[26,1,26,2],[10,1,10,2],[11,1,11,2],[13,1,13,2],[15,1,15,2],[17,1,17,2],[19,1,19,2],[22,1,22,2],[24,1,24,2],[67,6,67,7],[70,6,70,7],[65,1,65,10],[66,6,66,10],[69,6,69,7],[12,1,12,2],[14,1,14,2],[16,1,16,2],[18,1,18,2],[20,1,20,2],[23,1,23,2],[25,1,25,2],[21,1,21,2],[27,1,27,2],[71,6,71,7],[72,6,72,7],[42,1,42,10],[62,1,63,10],[92,1,93,10],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[73,8,73,10],[74,6,74,10],[75,6,75,10],[76,6,76,10],[77,1,78,10],[80,1,80,10],[81,7,81,10],[64,1,64,10]]}
[null,"Homekey Annual Report - 1. Expenditure Report "]
[null,"Instructions: Please complete this tab and include proof of expenditures as instructed. This tab should be completed for every project."]
[null,"Contract",{"$f":"IF('Grantee Cert. + Project Status'!B5=\"\",\"\",'Grantee Cert. + Project Status'!B5)","v":""},null,null,null,"HK Round",{"$f":"IF('Grantee Cert. + Project Status'!E4=\"Select One\",\"\",'Grantee Cert. + Project Status'!E4)","v":""}]
[null,"Project Name",{"$f":"IF('Grantee Cert. + Project Status'!E5=\"\",\"\",'Grantee Cert. + Project Status'!E5)","v":""},null,null,null,"Grantee",{"$f":"IF('Grantee Cert. + Project Status'!B6=\"\",\"\",'Grantee Cert. + Project Status'!B6)","v":""}]
[null,"Co-Grantee 1",{"$f":"IF('Grantee Cert. + Project Status'!B7=\"\",\"-\",'Grantee Cert. + Project Status'!B7)","v":"-"},null,null,null,"Co-Grantee 2",{"$f":"IF('Grantee Cert. + Project Status'!B8=\"\",\"-\",'Grantee Cert. + Project Status'!B8)","v":"-"}]
[null,"Reporting Period",{"$f":"IF('Grantee Cert. + Project Status'!B4=\"\",\"\",'Grantee Cert. + Project Status'!B4)","v":""},null,null,null,"Payee"]
[]
[null,"1. Disbursements Summary"]
[null,"Instructions: Enter the Award Amounts as they appear in the Standard Agreement. Then, please enter disbursed amounts by RFF number."]
[null,"If a Flex Form has been submitted and approved by the Department, please also enter in those adjusted award amounts."]
[null,"Eligible Use",null,"Award Amounts","Total Amount Disbursed \n(requested by RFF Form and received)","RFF 1","RFF 2","RFF 3","RFF 4","RFF 5","RFF 6"]
[null,"Acquisition of motels, hotels, hostels, or other sites and assets (pursuant to NOFA §201 i.)",null,null,{"$f":"SUM(F12:K12)","v":0}]
[null,"Flexed Amount"]
[null,"Rehabilitation of motels, hotels, hostels, or other sites and assets (pursuant to NOFA §201 i.)",null,null,{"$f":"SUM(F14:K14)","v":0}]
[null,"Flexed Amount"]
[null,"Master leasing of properties (pursuant to NOFA §201 ii.)",null,null,{"$f":"SUM(F16:K16)","v":0}]
[null,"Flexed Amount"]
[null,"Conversion of units from nonresidential to residential (pursuant to NOFA §201 iii.)",null,null,{"$f":"SUM(F18:K18)","v":0}]
[null,"Flexed Amount"]
[null,"New construction of dwelling units (pursuant to NOFA §201 iv.)",null,null,{"$f":"SUM(F20:K20)","v":0}]
[null,"Flexed Amount"]
[null,"Eligible Use",null,"Original Award Amount","Total Amount Disbursed \n(requested by RFF Form and received)","RFF 1","RFF 2","RFF 3","RFF 4","RFF 5","RFF 6"]
[null,"Purchase of affordability covenants and restrictions for units (pursuant to NOFA §201 v.)",null,null,{"$f":"SUM(F23:K23)","v":0}]
[null,"Flexed Amount"]
[null,"Relocation costs for individuals who are being displaced as a result of Homekey project (pursuant to NOFA §201 vi.)",null,null,{"$f":"SUM(F25:K25)","v":0}]
[null,"Flexed Amount"]
[null,"Capitalized operating subsidies for units purchased, converted or altered (not including Expedited Occupancy Bonus)\n(pursuant to NOFA §201 vi.)",null,null,{"$f":"SUM(F27:K27)","v":0}]
[null,"Flexed Amount"]
[null,"Bonus for Occupying Project 8 Months from Award Date \n(if applicable - please include Original Award Amount, even if it has been forfeited):\n(pursuant to NOFA §201 vi.)",null,null,{"$f":"SUM(F29:K29)","v":0}]
[null,"TOTAL:",null,{"$f":"_xlfn.IFS('Grantee Cert. + Project Status'!C39=\"Yes\",SUM(D13,D15,D17,D19,D21,D24,D26,D28,D29),'Grantee Cert. + Project Status'!C39=\"Select One\",SUM(D12,D14,D16,D18,D20,D23,D25,D27,D29),'Grantee Cert. + Project Status'!C39=\"No\",SUM(D12,D14,D16,D18,D20,D23,D25,D27,D29))","v":0},{"$f":"SUM(E12:E29)","v":0},0,0,0,0,{"$f":"SUM(J12:J29)","v":0},0]
[]
[null,"2. Proof of Expenditures Summary - RFF Reimbursements"]
[null,"Instructions: Enter the disbursement amounts by RFF number, and distinguish whether the amounts were requsted as a Reimbursement or an Advance.  If an amount was requested as a Reimbursement, proof of expenditures should have been provided at the time of RFF submission. If not, please provide proof of expenditures for Reimbursements at this time, and note below that any amount Reimbursed is backed up by proof of expenditures (ie General Ledger, Final Buyer's Settlement Statement, etc.)"]
[null,null,null,null,null,"RFF 1","RFF 2","RFF 3","RFF 4","RFF 5","RFF 6"]
[null,"Advanced"]
[null,"Reimbursed"]
[null,"Total",null,null,null,{"$f":"SUM(F35:F36)","v":0},{"$f":"SUM(G35:G36)","v":0},{"$f":"SUM(H35:H36)","v":0},0,0,{"$f":"SUM(K35:K36)","v":0}]
[null," Submitted Proof of Expenditures for Reimbursements",null,null,null,"Select One","Select One","Select One","Select One","Select One","Select One"]
[null,"HCD Use Only - Verified Proof of Expenditures",null,null,null,"Select One","Select One","Select One","Select One","Select One","Select One"]
[null,"HCD Notes -"]
[]
[null,"3. Proof of Expenditures Summary - Prior and Current Reporting Periods"]
[null,"Instructions: Enter the amounts of Homekey funds exepended this reporting period, as well as the current total expended across all reporting periods.  If a report was submitted last year, please include the total amount expended across all reporting periods as reported last year.  This will help determine if the amounts are consistent accross reporting periods.  If the amount reported last year and the amount reported this year do not equal the total amount reported this year, please provide updated proof of expenditures. And for any amount expended this reporting period, please proivde proof of expenditures."]
[null,"Eligible Use",null,null,"Total Amount Expended \n(all reporting periods)","Total Amount Expended \n(this reporting period)","Total Amount Expended \n(as reported in prior reporting period)","Total Amount Expended in the last Reporting Period that has Changed this Reporting Period","If Total Amount Expended in prior reporting periods has changed, Updated Proof of Expenditures Provided?","Proof of Expenditures Submitted - This Reporting Period","HCD Use Only - Verified Proof of Expenditures"]
[null,"Acquisition of motels, hotels, hostels, or other sites and assets (pursuant to NOFA §201 i.)",null,null,null,null,null,{"$f":"E45-G45-F45","v":0},"Select One","Select One","Select One"]
[null,"Rehabilitation of motels, hotels, hostels, or other sites and assets (pursuant to NOFA §201 i.)",null,null,null,null,null,{"$f":"E46-G46-F46","v":0},"Select One","Select One","Select One"]
[null,"Master leasing of properties (pursuant to NOFA §201 ii.)",null,null,null,null,null,0,"Select One","Select One","Select One"]
[null,"Conversion of units from nonresidential to residential (pursuant to NOFA §201 iii.)",null,null,null,null,null,0,"Select One","Select One","Select One"]
[null,"New construction of dwelling units (pursuant to NOFA §201 iv.)",null,null,null,null,null,0,"Select One","Select One","Select One"]
[null,"Purchase of affordability covenants and restrictions for units (pursuant to NOFA §201 v.)",null,null,null,null,null,0,"Select One","Select One","Select One"]
[null,"Relocation costs for individuals who are being displaced as a result of Homekey project (pursuant to NOFA §201 vi.)",null,null,null,null,null,{"$f":"E51-G51-F51","v":0},"Select One","Select One","Select One"]
[null,"Capitalized operating subsidies for units purchased, converted or altered (not including Expedited Occupancy Bonus)\n(pursuant to NOFA §201 vi.)",null,null,null,null,null,{"$f":"E52-G52-F52","v":0},"Select One","Select One","Select One"]
[null,"Bonus for Occupying Project 8 Months from Award Date (if applicable):\n(pursuant to NOFA §201 vi.)",null,null,null,null,null,{"$f":"E53-G53-F53","v":0},"Select One","Select One","Select One"]
[null,null,null,null,{"$f":"SUM(E45:E53)","v":0},{"$f":"SUM(F45:F53)","v":0},{"$f":"SUM(G45:G53)","v":0},{"$f":"SUM(ABS(H45:H53))","v":0}]
[]
[]
[null,"3a. Expenditures Summary - Completed Expenditures by Fiscal Year"]
[null,"Instructions: Fill out the table below with the expenditures made by Fiscal Year. Accompanying proof of expenditures is required to confirm expenditure amounts."]
[null,null,"FY 21-22\n(Jul 2021 - Jun 2022)","FY 22-23\n(Jul 2022 - Jun 2023)","FY 23-24\n(Jul 2023 - Jun 2024)","FY 24-25\n(Jul 2024 - Jun 2025)","FY 25-26\n(Jul 2025 - Jun 2026)","FY 26-27\n(Jul 2026 - Jun 2027)","Total","Proof of Expenditures Submitted - This Reporting Period","HCD Use Only - Verified Proof of Expenditures"]
[null,"Capital Expended",null,null,null,null,null,null,{"$f":"SUM(C60:H60)","v":0},"Select One","Select One"]
[null,"Operating Expended",null,null,null,null,null,null,{"$f":"SUM(C61:H61)","v":0},"Select One","Select One"]
[null,"Fiscal Year Totals",{"$f":"SUM(C60:C61)","v":0},{"$f":"SUM(D60:D61)","v":0},{"$f":"SUM(E60:E61)","v":0},0,0,0,0]
[null,"HCD Notes -"]
[]
[null,"4. Total Development Costs and Non-Homekey Funding Sources"]
[null,"Instructions: Fill out the table below with all current capital funding sources and amounts for this Homekey project. Operations funds will be listed separately in a separate table below. The Total Development Cost 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."]
[null,"The Project has a source of matching fund not listed in the Standard Agreement or previously approved in a Budget Detail Adjustment Review Form?",null,null,null,null,"Select One"]
[null,"Source of Matching Funds",null,"Match Amount",null,"Lien Position","Type of Match",null,"Notes"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,"TOTAL FROM NON-HOMEKEY SOURCES:",null,{"$f":"SUM(D69:E74)","v":0}]
[null,"TOTAL FROM HOMEKEY SOURCES:",null,{"$f":"SUM(D12:D25)","v":0}]
[null,"TOTAL DEVELOPMENT COST (Non-Homekey + Homekey Capital)",null,{"$f":"SUM(D12:D25)+(D75)","v":0}]
[null,"HCD Notes -"]
[]
[]
[null,"5. Total Operating Non-Homekey Sources"]
[null,"Does the Project have a funding source not listed in the Standard Agreement or previously approved by HCD in a Budget Detail Adjustment Review Form?",null,null,null,null,null,"Select One"]
[null,"Number of Project-Based Vouchers (PBVs) in Project:",null,null,null,"Total Value of PBVs:"]
[null,"Source of Funds",null,"Amount",null,"Lien Position","Type of Match",null,"Notes"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,null,null,null,null,null,"Select One"]
[null,"TOTAL FROM NON-HOMEKEY SOURCES:",null,{"$f":"SUM(D85:D89)+H83","v":0}]
[null,"TOTAL FROM HOMEKEY SOURCES:",null,{"$f":"D27","v":0}]
[null,"TOTAL OPERATING FUNDS (Non-Homekey + Homekey Operating)",null,{"$f":"SUM(D90:E91)","v":0}]
[null,"HCD Notes -"]

{"sheet":"2.Standard Agreement Compliance","index":2,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":true,"merged":[[0,1,0,10],[1,1,1,10],[13,2,13,4],[13,5,13,6],[13,8,13,10],[5,2,5,4],[5,5,5,6],[5,8,5,10],[27,2,27,4],[27,5,27,6],[27,8,27,10],[2,1,2,10],[6,8,6,10],[3,1,3,10],[4,1,4,10],[6,2,6,4],[6,5,6,6],[14,8,14,10],[20,2,20,4],[21,2,21,4],[22,2,22,4],[14,2,14,4],[15,2,15,4],[14,5,14,6],[28,2,28,4],[29,2,29,4],[30,2,30,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[17,8,17,10],[7,8,7,10],[12,1,12,10],[16,8,16,10],[15,8,15,10],[7,2,7,4],[7,5,7,6],[28,8,28,10],[8,1,8,10],[11,8,11,10],[11,5,11,6],[11,2,11,4],[10,8,10,10],[10,5,10,6],[10,2,10,4],[9,8,9,10],[9,5,9,6],[9,2,9,4],[68,1,68,4],[32,5,32,6],[33,5,33,6],[34,5,34,6],[29,8,29,10],[30,8,30,10],[68,8,68,10],[60,8,60,10],[61,8,61,10],[62,8,62,10],[63,8,63,10],[64,8,64,10],[65,8,65,10],[66,8,66,10],[67,8,67,10],[36,5,36,6],[37,5,37,6],[61,1,61,4],[59,8,59,10],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[55,9,55,10],[56,9,56,10],[38,9,38,10],[60,1,60,4],[59,1,59,4],[47,1,47,3],[48,1,48,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[45,9,45,10],[70,8,70,10],[75,1,80,10],[74,1,74,10],[34,8,34,10],[35,8,35,10],[18,8,18,10],[24,1,24,10],[37,8,37,10],[36,8,36,10],[21,8,21,10],[22,8,22,10],[26,1,26,10],[25,1,25,10],[31,8,31,10],[39,9,39,10],[40,9,40,10],[41,9,41,10],[32,8,32,10],[62,1,62,4],[63,1,63,4],[64,1,64,4],[35,5,35,6],[38,1,38,3],[39,1,39,3],[33,8,33,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[50,9,50,10],[43,9,43,10],[44,9,44,10],[42,9,42,10],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,8,19,10],[20,8,20,10],[21,5,21,6],[22,5,22,6],[16,2,16,4],[72,1,72,4],[72,8,72,10],[57,1,57,3],[57,5,57,6],[57,7,57,10],[58,1,58,10],[49,1,49,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[54,1,54,3],[55,1,55,3],[56,1,56,3],[51,9,51,10],[52,9,52,10],[53,9,53,10],[54,9,54,10],[65,1,65,4],[66,1,66,4],[69,8,69,10],[69,1,69,4],[70,1,70,4],[67,1,67,4]]}
[null,"Homekey Annual Report - 2. Standard Agreement Compliance"]
[null,"Instructions: Please complete this tab only if the project is occupied and operational."]
[null,"1. Standard Agreement Compliance Questions"]
[null,"Instructions: Use the drop-down menus or fillable forms as applicable to answer the questions below regarding requirements contained in your Standard Agrement. If details have changed since the execution of your Standard Agreement, please answer the questions to reflect those changes."]
[null,"Standard Agreement - Exhibit E - 1. Project Specific Provisions - C. Scope of Work"]
[null,null,"Question",null,null,"Grantee Response",null,"HCD Verification","HCD Notes"]
[null,{"$f":"\"A\"","v":"A"},"Please briefly describe where you are with this project's proposed scope of work \n(Examples: \"we released an RFP for a project developer and plan to begin construction this summer\"; \"we are currently working on rehabilitating # units to add kitchenettes\"; \"this project is completed and currently leasing up.\")",null,null,null,null,"Select One"]
[null,{"$f":"CHAR(CODE(B7)+1)","v":"B"},"What is the name of the entity that will be providing Supportive Services to tenants?",null,null,null,null,"Select One"]
[null,"Stardard Agreement - Exhibit D - Homekey General Terms and Conditions"]
[null,{"$f":"CHAR(CODE(B8)+1)","v":"C"},"Is Coordinated Entry utilized for tenant referrals per NOFA §502?",null,null,"Select One",null,"Select One"]
[null,{"$f":"CHAR(CODE(B10)+1)","v":"D"},"Did this project receive a CEQA Exemption? If so, which one?",null,null,"Select one",null,"Select One"]
[null,{"$f":"CHAR(CODE(B11)+1)","v":"E"},"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. Tribal entities and Domestic Violence shelters are among those exempt from this requirement",null,null,"Select One",null,"Select One"]
[null,"Standard Agreement - Exhibit E - 2. Special Terms and Conditions"]
[null,null,"Question",null,null,"Grantee Response",null,"HCD Verification","HCD Notes"]
[null,{"$f":"CHAR(CODE(B12)+1)","v":"F"},"If Project is Permanent, Grantee waives any potential accommodation by the Department to increase income limits at year 15 from the recordation of the Affordability Covenant, as described in Section 303 (ii)? ",null,null,"Select One",null,"Select One"]
[null,{"$f":"IF('Grantee Cert. + Project Status'!E4=\"3.0\",CHAR(CODE(B15)+1),\"F\")","v":"F"},"Supportive Services Plan required by HCD received no later than 90 days prior to occupancy?",null,null,"Select One",null,"Select One"]
[null,{"$f":"CHAR(CODE(B16)+1)","v":"G"},"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,null,"Select One",null,"Select One"]
[null,"H","If Yes to question G, what percentage of assisted units are permanently restricted? ",null,null,null,null,"Select One"]
[null,"I","Will Project be able to Comply with waiver of increased income limits for the selected percentage of units?",null,null,"Select One",null,"Select One"]
[null,"J","Accessibility commitment to exceed the state and federal accessibiltiy requirement set forth in the NOFA - % percent of the Project's Assisted Units must have features accessible to persons with mobility disabilities",null,null,"Select One",null,"Select One"]
[null,"K","Accessibility commitment to exceed the state and federal accessibiltiy requirement set forth in the NOFA - % percent of the Project's Assisted Units must have features accessible to persons with hearing or vision disabilities",null,null,"Select One",null,"Select One"]
[null,"L","Has this project committed to larger family housing types for the project, as per NOFA Section 304, Application Scoring Criteria, (3)(B)?",null,null,"Select One",null,"Select One"]
[null,{"$f":"CHAR(CODE(B22)+1)","v":"M"},"Is the Project subject to AB 1010?",null,null,"Select One",null,"Select One"]
[]
[]
[null,"2. Unit Mix"]
[null,"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.\n- If an interim to permanent project, fill out for the project as it will be once it converts to permanent. \n- If your project is multi/scattered site, combine the units between sites for this table.\n- If there is more than one bedroom size for the same population, use separate rows to report each of the distinct unit types.\n- General 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 (\"N/A\"), even if currently occupied by a household that qualifies as a special sub-population.\n- Existing 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. \n- Non-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 H and I"]
[null,null,"Question",null,null,"Grantee Response",null,"HCD Verification","HCD Notes"]
[null,{"$f":"CHAR(CODE(B23)+1)","v":"N"},"Does this project have an obligation to serve individuals experiencing homelessness (not Chronic)? If yes, please enter the required minimum percent of units.",null,null,"Select One",null,"Select One"]
[null,{"$f":"CHAR(CODE(B29)+1)","v":"O"},"Does this project have an obligation to serve Homeless Youth and Youth at Risk of Homelessness (ages 0-25)",null,null,"Select One",null,"Select One"]
[null,{"$f":"CHAR(CODE(B30)+1)","v":"P"},"Does this project have an obligation to serve Chronically Homeless Individuals?",null,null,"Select One",null,"Select One"]
[null,"Q","Does this Project intentionally target another sub-population that is not obligated by your Homekey Standard Agreement? (e.g. Seniors, Veterans, LGBTQ+)?",null,null,"Select One",null,"Select One"]
[null,"R","If yes, please specify: ",null,null,null,null,"Select One"]
[null,"S","Has the following Unit Mix changed since Standard Agreement Execution? (e.g. different number of units, different target population, different number of accessible units)",null,null,"Select One",null,"Select One"]
[null,"T","If Yes, please briefly explain changes: ",null,null,null,null,"Select One"]
[null,"U","Has HCD approved these changes?: ",null,null,"Select One",null,"Select One"]
[null,"V","If yes, was a Standard Agreement amendment executed?: ",null,null,"Select One",null,"Select One"]
[null,"W","If Construction is complete, how many units have been constructed",null,null,{"$f":"IF(OR('Grantee Cert. + Project Status'!C27=\"Fully Occupied and Operational\",'Grantee Cert. + Project Status'!C27=\"Interim to Perm - Fully Occupied and Operational\"),E57,\"\")","v":""},null,"Select One"]
[null,"Target Population\nPlease select by how unit is restricted in Covenant or Regulatory Agreement, not who is occupying the unit.",null,null,"Number of Units\n(NOFA §601 iii)","Number of Bedrooms \n(Studios are \"0\" BR)","Number of Units Currently Occupied - Occupant(s) matches listed Target Population \n(as of the date this report is submitted)","Number of Units Currently Occupied - Occupant(s) does not match listed Target Population\n (as of the date this report is submitted)","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)"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"TOTALS",null,null,{"$f":"SUM(E39:E56)","v":0},null,{"$f":"SUM(G40:G56)","v":0},{"$f":"SUM(H40:H56)","v":0},{"$f":"SUM(I40:I56)","v":0},{"$f":"SUM(J40:J56)","v":0}]
[null,"If any unit is occupied with an occupant that does not match the required target population, please acknowledge that those units will be filled by the required target population as soon as possible",null,null,"Select One","Please provide a narrative explanation for why units are not filled with the required target population"]
[null,"Unit Mix Compliance with Standard Agreement Restrictions"]
[null,"Unit Type",null,null,null,"Total Units","Percentage","HCD Findings","HCD Notes"]
[null,"Homekey-Assisted Units:",null,null,null,{"$f":"SUMIF($B$40:$B$56,\"<>Non-Homekey Unit\",$E$40:$E$56)","v":0},{"$f":"IFERROR((SUMIF($B$40:$B$56,\"<>Non-Homekey Unit\",$E$40:$E$56))/$E$57,0)","v":0},"Select One"]
[null,"Units for those Experiencing Homelessness ",null,null,null,{"$f":"SUMIF($B$40:$B$56,\"Experiencing Homelessness (not Chronic)\",$E$40:$E$56)","v":0},{"$f":"IFERROR($F$62/$F$61,0)","v":0},"Select One"]
[null,"Chronic Homeless Units:",null,null,null,{"$f":"SUMIF($B$40:$B$56, \"Chronically Homeless\",$E$40:$E$56)","v":0},{"$f":"IFERROR($F63/$F$61,0)","v":0},"Select One"]
[null,"Youth Units:",null,null,null,{"$f":"SUMIF($B$40:$B$56,\"Homeless or at-risk Youth\",$E$40:$E$56)","v":0},{"$f":"IFERROR($F$64/$F$61,0)","v":0},"Select One"]
[null,"Mobility Accessible:",null,null,null,{"$f":"$I$57","v":0},{"$f":"IFERROR($F$65/$F$61,0)","v":0},"Select One"]
[null,"Hearing/Vision Accessible:",null,null,null,{"$f":"$J$57","v":0},{"$f":"IFERROR($F$66/$F$61,0)","v":0},"Select One"]
[null,"Existing Tenant Units:",null,null,null,{"$f":"SUMIF($B$40:$B$56,\"Existing Tenant\",$E$40:$E$56)","v":0},{"$f":"IFERROR($F$67/$F$61,0)","v":0},"Select One"]
[null,"Two Bedroom Units",null,null,null,{"$f":"SUMIF($F$40:$F$56,\"2\",$E$40:$E$56)","v":0},{"$f":"IFERROR($F68/$F$61,0)","v":0},"Select One"]
[null,"Three Bedroom or Greater Units",null,null,null,{"$f":"SUMIF($F$40:$F$56,\"3+\",$E$40:$E$56)","v":0},{"$f":"IFERROR($F69/$F61,0)","v":0},"Select One"]
[null,"Manager Units:",null,null,null,{"$f":"SUMIF($B$40:$B$56,\"Manager Unit\",$E$40:$E$56)","v":0},{"$f":"IFERROR($F$70/$F$61,0)","v":0},"Select One"]
[null,"Non-Homekey Units:",null,null,null,{"$f":"SUMIF($B$40:$B$56,\"Non-Homekey Unit\",$E$40:$E$56)","v":0},{"$f":"IFERROR($F$71/$E$57,0)","v":0},"Select One"]
[]
[null,"Occupied HK Units",null,null,null,{"$f":"(G57+H57)-F71","v":0},{"$f":"IFERROR(F73/E57,\"\")","v":""},"Select One"]
[]
[null,"HCD USE ONLY - Notes on Unit Mix"]

{"sheet":"3. Operating Costs","index":3,"n_rows":95,"n_cols":8,"rows_kept":95,"cut":false,"hidden":true,"merged":[[0,1,0,7],[1,1,1,7],[95,1,100,7],[94,1,94,7],[88,1,88,7],[93,4,93,7],[73,2,73,3],[92,6,92,7],[92,1,92,5],[90,1,90,5],[90,6,90,7],[91,1,91,5],[91,6,91,7],[89,1,89,7],[75,2,75,3],[15,2,15,3],[31,2,31,3],[17,2,17,3],[93,2,93,3],[51,2,51,3],[84,1,84,3],[58,2,58,3],[63,2,63,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[18,2,18,3],[30,2,30,3],[45,2,45,3],[34,2,34,3],[35,2,35,3],[62,2,62,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[41,2,41,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[44,2,44,3],[42,2,42,3],[43,2,43,3],[46,2,46,3],[32,2,32,3],[33,2,33,3],[39,2,39,3],[6,1,6,7],[9,2,9,3],[10,2,10,3],[28,1,28,7],[24,2,24,3],[7,1,7,7],[25,2,25,3],[8,2,8,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[29,1,29,7],[67,2,67,3],[82,2,82,3],[83,2,83,3],[85,2,85,3],[76,2,76,3],[77,2,77,3],[78,2,78,3],[79,2,79,3],[80,2,80,3],[72,2,72,3],[68,2,68,3],[69,2,69,3],[81,2,81,3],[74,2,74,3],[70,2,70,3],[71,2,71,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[3,3,3,4],[2,6,2,7],[3,6,3,7],[4,6,4,7],[2,1,2,2],[2,3,2,4],[3,1,3,2],[4,3,4,4],[4,1,4,2],[40,2,40,3],[36,2,36,3],[37,2,37,3],[38,2,38,3]]}
[null,"Homekey Annual Report - 3. Operating Costs"]
[null,"Instructions: Please complete this tab only if the project is occupied and operational."]
[null,"Reporting Period:",null,{"$f":"IF('Grantee Cert. + Project Status'!B4=\"\",\"\",'Grantee Cert. + Project Status'!B4)","v":""},null,"Project Name:",{"$f":"IF('Grantee Cert. + Project Status'!E5=\"\",\"\",'Grantee Cert. + Project Status'!E5)","v":""}]
[null,"Prepared By:",null,{"$f":"IF('Grantee Cert. + Project Status'!B9=\"\",\"\",'Grantee Cert. + Project Status'!B9)","v":""},null,"Project County:",{"$f":"IF('Grantee Cert. + Project Status'!B11=\"\",\"\",'Grantee Cert. + Project Status'!B11)","v":""}]
[null,"Homekey Units (including manager units)",null,{"$f":"IF('2.Standard Agreement Compliance'!F61=\"\",\"\",'2.Standard Agreement Compliance'!F61)","v":0},null,"Total Units:",{"$f":"'2.Standard Agreement Compliance'!F57","v":0}]
[]
[null,"1. Annual Operating Sources"]
[null,"Instructions: \n1) Fill out Operating sources of funds in this reporting period by category in column F for non-Homekey incoming funds.\n2) Please list the non-Homekey funding sources used as a source for this reporting period in Column D."]
[null,null,null,null,"Operating Sources - Homekey - This Reporting Period","Operating Sources - Non-Homekey Sources - This Reporting Period","Total Operating Sources - All Sources - This Reporting Period","HCD Notes"]
[null,null,"Rent Revenue:"]
[null,1,"Rent Revenue - Gross Potential",null,null,0,{"$f":"E11+F11","v":0}]
[null,{"$f":"1+B11","v":2},"Tenant Assistance Payments",null,null,0,{"$f":"E12+F12","v":0}]
[null,{"$f":"1+B12","v":3},"Rent Revenue - Stores and Commercial",null,null,0,0]
[null,4,"Garage and Parking Spaces",null,null,0,0]
[null,5,"Flexible Subsidy Revenue",null,null,0,0]
[null,{"$f":"1+B15","v":6},"Miscellaneous Rent Revenue",null,null,0,0]
[null,{"$f":"1+B16","v":7},"Total Rent Revenue",null,null,{"$f":"SUM(F11:F16)","v":0},0]
[null,null,"Operating Funding Sources:"]
[null,{"$f":"1+B17","v":8},"Amount of Homekey Funds Expended this Period",null,{"$f":"'1. Expenditure Report'!E52","v":0},null,{"$f":"E19+F19","v":0}]
[null,{"$f":"1+B19","v":9},"Funding Source 1:","Please Enter Funding Source",null,0,{"$f":"E20+F20","v":0}]
[null,{"$f":"1+B20","v":10},"Funding Source 2:","Please Enter Funding Source",null,0,0]
[null,11,"Funding Source 3:","Please Enter Funding Source",null,0,0]
[null,12,"Funding Source 4:","Please Enter Funding Source",null,0,0]
[null,{"$f":"1+B23","v":13},"Funding Source 5:","Please Enter Funding Source",null,0,0]
[null,{"$f":"1+B24","v":14},"Total Operating Funding",null,{"$f":"SUM(E19:E24)","v":0},{"$f":"SUM(F19:F24)","v":0},{"$f":"SUM(G19:G24)","v":0}]
[null,{"$f":"1+B25","v":15},"Total Annual Operating Sources",null,{"$f":"E25","v":0},{"$f":"F25+F17","v":0},{"$f":"E26+F26","v":0}]
[]
[]
[null,"2. Annual Operating Expenditures"]
[null,"Instructions: \n1) Fill out Operating Subsidy expenditures in this reporting period by category in columns F (for Homekey incoming funds) and E (non-Homekey incoming funds)."]
[null,null,null,null,"Operating Expenditures - Homekey - This Reporting Period","Operating Expenditures - Non-Homekey Sources - This Reporting Period","Total Operating Expenditures - All Sources - This Reporting Period","HCD Notes"]
[null,null,"Administrative Expenses:"]
[null,null,"Conventions and Meetings",null,0,0,{"$f":"E33+F33","v":0}]
[null,null,"Management Consultants",null,0,0,0]
[null,null,"Advertising and Marketing",null,0,0,0]
[null,null,"Other Renting Expenses",null,0,0,0]
[null,null,"Office Salaries",null,0,0,0]
[null,null,"Office Expenses",null,0,0,0]
[null,null,"Office or Model Apartment Rent",null,0,0,0]
[null,null,"Management Fee (do not include GP Management Fee)",null,0,0,0]
[null,null,"Manager or Superintendent Salaries",null,0,0,0]
[null,null,"Administrative Rent Free Unit",null,0,0,0]
[null,null,"Legal Expense - Project",null,0,0,0]
[null,null,"Audit Expense",null,0,0,0]
[null,null,"Bookkeeping Fees/ Accounting Services",null,0,0,0]
[null,null,"Bad Debts",null,0,0,0]
[null,null,"Misc. Administrative Expenses",null,0,0,0]
[null,null,"Total Administrative Expenses",null,{"$f":"SUM(E33:E47)","v":0},{"$f":"SUM(F33:F47)","v":0},{"$f":"SUM(G33:G47)","v":0}]
[null,null,"Utilities:"]
[null,null,"Electricity",null,0,0,{"$f":"E50+F50","v":0}]
[null,null,"Water",null,0,0,{"$f":"E51+F51","v":0}]
[null,null,"Gas",null,0,0,0]
[null,null,"Sewer",null,0,0,0]
[null,null,"Total Utilities Expenses",null,{"$f":"SUM(E50:E53)","v":0},{"$f":"SUM(F50:F53)","v":0},{"$f":"SUM(G50:G53)","v":0}]
[null,null,"Operating and Maintenance Expenses:"]
[null,null,"Payroll",null,0,0,{"$f":"E56+F56","v":0}]
[null,null,"Supplies",null,0,0,{"$f":"E57+F57","v":0}]
[null,null,"Contracts",null,0,0,0]
[null,null,"Operating and Maintenance Rent Free Unit",null,0,0,0]
[null,null,"Garbage and Trash Removal",null,0,0,0]
[null,null,"Security Payroll/Contracts",null,0,0,0]
[null,null,"Security Rent Free Unit",null,0,0,0]
[null,null,"Heating/Cooling Repairs and Maintenance",null,0,0,0]
[null,null,"Snow Removal",null,0,0,0]
[null,null,"Vehicle and Maintenance Equip. Operation and Repairs",null,0,0,0]
[null,null,"Lease Expense",null,0,0,0]
[null,null,"Misc. Operating & Maintenance Expenses",null,0,0,0]
[null,null,"Total Operating and Maintenance Expenses",null,{"$f":"SUM(E56:E67)","v":0},{"$f":"SUM(F56:F67)","v":0},{"$f":"SUM(G56:G67)","v":0}]
[null,null,"Taxes and Insurance:"]
[null,null,"Real Estate Taxes",null,0,0,{"$f":"E70+F70","v":0}]
[null,null,"Payroll Taxes (Project's Share)",null,0,0,{"$f":"E71+F71","v":0}]
[null,null,"Property & Liability Insurance (Hazard)",null,0,0,0]
[null,null,"Fidelity Bond Insurance",null,0,0,0]
[null,null,"Worker's Compensation",null,0,0,0]
[null,null,"Health Insurance and Other Employee Benefits",null,0,0,0]
[null,null,"Miscellaneous Taxes, Licenses, Permits and Insurance",null,0,0,0]
[null,null,"Total Taxes and Insurance",null,{"$f":"SUM(E70:E76)","v":0},{"$f":"SUM(F70:F76)","v":0},{"$f":"SUM(G70:G76)","v":0}]
[null,null,"Supportive Services Costs:"]
[null,null,"Staff Supervisors Salaries",null,0,0,{"$f":"E79+F79","v":0}]
[null,null,"On-site Services Coordinator Salaries and Benefits",null,0,0,{"$f":"E80+F80","v":0}]
[null,null,"On-site Other Supportive Services Staff Salaries",null,0,0,{"$f":"E81+F81","v":0}]
[null,null,"Supportive Services Administrative Overhead",null,0,0,0]
[null,null,"Other Supportive Services Costs",null,0,0,0]
[null,null,"Total Supportive Services Costs",null,{"$f":"SUM(E79:E83)","v":0},{"$f":"SUM(F79:F83)","v":0},{"$f":"SUM(G79:G83)","v":0}]
[null,null,null,null,"Operating Expenditures - Homekey - This Reporting Period","Operating Expenditures - Non-Homekey Sources - This Reporting Period","Total Operating Expenditures - All Sources - This Reporting Period"]
[null,null,"Total Cost of Operations",null,{"$f":"(E48+E54+E68+E77+E84)","v":0},{"$f":"(F48+F54+F68+F77+F84)","v":0},{"$f":"(G48+G54+G68+G77+G84)","v":0}]
[]
[]
[null,"3. Operating Costs - Cash Flow"]
[null,"Cash Flow"]
[null,"Operating Sources - All Sources",null,null,null,null,{"$f":"G26","v":0}]
[null,"Operating Expenditures - All Sources",null,null,null,null,{"$f":"G86","v":0}]
[null,"(Total Operating Sources) - (Total Operating Expenditures) = Cash Flow this Reporting Period",null,null,null,null,{"$f":"G26-G86","v":0}]
[null,null,"If there is positive cash flow (green), please describe in the box to the right the intended use of these funds.\n\nIf there is negative cash flow (red), please describe in the box to the right the efforts to stabilize the project operations."]
[null,"HCD USE ONLY"]

{"sheet":"4. Equity Strategies","index":4,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":true,"merged":[[24,1,24,4],[25,1,25,4],[14,6,14,7],[9,1,9,7],[10,1,10,7],[14,1,14,4],[16,1,16,4],[15,1,15,4],[13,5,13,7],[0,1,0,7],[12,1,12,7],[1,1,1,7],[4,1,4,7],[11,1,11,7],[8,1,8,7],[7,1,7,7],[6,1,6,7],[5,1,5,7],[2,6,2,7],[3,1,3,7],[44,1,44,5],[45,1,45,5],[35,1,35,7],[34,1,34,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[30,6,30,7],[31,6,31,7],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[24,6,24,7],[25,6,25,7],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[36,6,36,7],[37,6,37,7],[38,6,38,7],[36,1,36,5],[37,1,37,5],[38,1,38,5],[13,1,13,4],[31,1,31,4],[32,1,32,7],[33,1,33,7],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[45,6,45,7],[44,6,44,7],[39,6,39,7],[40,6,40,7],[41,6,41,7],[42,6,42,7],[43,6,43,7]]}
[null,"Homekey Annual Report - 4. Equity Strategies"]
[null,"Instructions: Please complete this tab only if the project is occupied and operational. "]
[null,"HCD Contract Number:",{"$f":"IF('Grantee Cert. + Project Status'!B5=\"\",\"\",'Grantee Cert. + Project Status'!B5)","v":""},"Grantee Name: ",{"$f":"IF('Grantee Cert. + Project Status'!B6=\"\",\"\",'Grantee Cert. + Project Status'!B6)","v":""},"Reporting Period:",{"$f":"IF('Grantee Cert. + Project Status'!B4=\"\",\"\",'Grantee Cert. + Project Status'!B4)","v":""}]
[]
[null,"1. Equity, Inclusion, and Accessibility"]
[null,"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."]
[]
[null,"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)."]
[]
[]
[]
[null,"2. Racial and Ethnic Composition of Tenants Assisted by Homekey \n(pursuant to NOFA §601 v.)"]
[null,"Instructions: Enter the number of participants served in the last reporting period in the table below. Please enter numbers by participant category, and within each category, enter the total number of participants served and the number of participants with disabilities) served."]
[null,"Particpant Category",null,null,null,"Number of Participants Served"]
[null,"Total Number of Participants Served during reporting period",null,null,null,"Total"]
[null,null,null,null,null,"Number With Disability(ies)"]
[null,"Number of White, Non-Hispanic/Non-Latino Participants Served",null,null,null,"Total"]
[null,null,null,null,null,"Number With Disability(ies)"]
[null,"Number of White Hispanic/Latino Participants Served",null,null,null,"Total"]
[null,null,null,null,null,"Number With Disability(ies)"]
[null,"Number of Black/African American Participants served",null,null,null,"Total"]
[null,null,null,null,null,"Number With Disability(ies)"]
[null,"Number of Asian Participants Served",null,null,null,"Total"]
[null,null,null,null,null,"Number With Disability(ies)"]
[null,"Number of American Indian or Alaska Native Participants Served",null,null,null,"Total"]
[null,null,null,null,null,"Number With Disability(ies)"]
[null,"Number of Native Hawaiian/Other Pacific Islander Participants Served",null,null,null,"Total"]
[null,null,null,null,null,"Number With Disability(ies)"]
[null,"Number of Multiracial Participants served",null,null,null,"Total"]
[null,null,null,null,null,"Number With Disability(ies)"]
[null,"Number of Participants whose race is unknown, or declined to state",null,null,null,"Total"]
[null,null,null,null,null,"Number With Disability(ies)"]
[]
[]
[null,"3. Jurisdiction Outcomes"]
[null,"Instructions: Using data from the jurisdiction's local Point-In-Time (PIT) count or HMIS, please insert your jurisdiction's outcomes here (using the latest available year as reference): "]
[null,"Population Description",null,null,null,null,"Number of People Experiencing Homelessness"]
[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"]

{"sheet":"5. Progress and Outcomes","index":5,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,1,0,7],[1,1,1,7],[3,1,3,7],[17,1,17,7],[18,1,18,7],[16,1,16,7],[12,1,12,7],[19,1,19,7],[2,1,2,7],[14,1,14,7],[31,1,31,7],[29,1,29,7],[15,1,15,7],[25,1,25,7],[26,1,26,7],[27,1,27,7],[28,1,28,7],[30,1,30,7],[23,1,23,7],[20,1,20,7],[21,1,21,7],[22,1,22,7],[24,1,24,7]]}
[null,"Homekey Annual Report - 5. Progress and Outcomes"]
[null,"Instructions: Please complete this tab only if the project is occupied and operational."]
[null,"1. Tenants Served"]
[null,"Instructions: Complete the following table with information regarding the types of individuals and households served with Homekey funds"]
[null,"Tenant Category","Currently Housed in Permanent Units:","Currently Housed in Interim/\nTransitional 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 \n(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 \n(ages 17 and under):"]
[null,"Transition Aged Youth \n(ages 18-25):"]
[null,"Seniors \n(ages 65 and above):"]
[null,"Veterans:"]
[]
[]
[null,"2. Project Narrative Questions"]
[null,"Instructions: Please provide written responses to questions 1 through 6 below. Responses are a requirement of the NOFA (pursuant to §601); blank or vague answers will not be accepted."]
[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. Please share any success stories you've had from Homekey-funded projects.\nOptional: Grantee may send attachments and photos to MultiFamilyGrants@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":"6. Report Summary","index":6,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[[25,1,25,3],[26,1,26,3],[25,4,25,5],[26,4,26,5],[25,6,25,9],[26,6,26,9],[53,8,53,9],[31,1,31,3],[31,4,31,6],[36,1,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[49,1,49,5],[52,1,52,5],[50,6,50,7],[51,6,51,7],[29,7,29,9],[37,1,37,3],[52,6,52,7],[42,8,42,9],[43,1,43,3],[43,4,43,5],[41,6,41,7],[0,1,0,9],[1,1,1,9],[41,8,41,9],[39,8,39,9],[40,1,40,3],[32,4,32,6],[35,1,35,9],[48,8,48,9],[30,7,30,9],[32,1,32,3],[30,4,30,6],[33,4,33,6],[33,7,33,9],[33,1,33,3],[39,4,39,5],[40,4,40,5],[41,4,41,5],[39,1,39,3],[39,6,39,7],[2,8,2,9],[2,4,2,6],[23,6,23,9],[29,1,29,3],[29,4,29,6],[50,8,50,9],[51,8,51,9],[52,8,52,9],[41,1,41,3],[38,4,38,5],[48,6,48,7],[54,1,54,5],[54,6,54,7],[54,8,54,9],[53,1,53,5],[53,6,53,7],[48,1,48,5],[42,4,42,5],[42,6,42,7],[38,8,38,9],[40,8,40,9],[38,1,38,3],[38,6,38,7],[42,1,42,3],[37,4,37,5],[3,2,3,4],[3,6,3,9],[14,1,14,9],[21,4,21,5],[7,2,7,6],[7,7,7,9],[10,2,10,6],[10,7,10,9],[11,2,11,6],[6,1,6,9],[11,7,11,9],[21,1,21,3],[21,6,21,9],[4,2,4,4],[4,6,4,9],[8,2,8,6],[8,7,8,9],[9,2,9,6],[9,7,9,9],[23,1,23,3],[23,4,23,5],[30,1,30,3],[32,7,32,9],[66,1,66,3],[66,4,66,6],[66,7,66,9],[63,1,63,3],[63,7,63,9],[63,4,63,6],[56,6,56,7],[56,8,56,9],[65,1,65,3],[65,4,65,6],[65,7,65,9],[60,1,60,9],[58,8,58,9],[56,1,56,5],[59,8,59,9],[58,1,58,5],[58,6,58,7],[57,1,57,5],[57,6,57,7],[57,8,57,9],[62,1,62,9],[64,1,64,3],[64,4,64,6],[64,7,64,9],[24,1,24,3],[24,4,24,5],[24,6,24,9],[31,7,31,9],[22,4,22,5],[22,6,22,9],[22,1,22,3],[28,1,28,9],[59,1,59,5],[59,6,59,7],[55,1,55,5],[55,6,55,7],[55,8,55,9],[37,6,37,7],[37,8,37,9],[47,1,47,9],[40,6,40,7],[43,6,43,7],[43,8,43,9],[44,1,44,9],[49,6,49,7],[49,8,49,9],[50,1,50,5],[51,1,51,5]]}
[null,"Homekey Annual Report - 6. Report Summary"]
[null,"Instructions: This tab is completed by HCD and summarizes the contents and findings of the report."]
[null,"Contract",{"$f":"IF('Grantee Cert. + Project Status'!B5=\"\",\"\",'Grantee Cert. + Project Status'!B5)","v":""},"Project Name",{"$f":"IF('Grantee Cert. + Project Status'!E5=\"\",\"\",'Grantee Cert. + Project Status'!E5)","v":""},null,null,"HK Round",{"$f":"IF('Grantee Cert. + Project Status'!E4=\"Select One\",\"\",'Grantee Cert. + Project Status'!E4)","v":""}]
[null,"Grantee",{"$f":"IF('Grantee Cert. + Project Status'!B6=\"\",\"\",'Grantee Cert. + Project Status'!B6)","v":""},null,null,"Reporting Period",{"$f":"IF('Grantee Cert. + Project Status'!B4=\"\",\"\",'Grantee Cert. + Project Status'!B4)","v":""}]
[null,"Co-Grantee 1",{"$f":"IF('Grantee Cert. + Project Status'!B7=\"\",\"-\",'Grantee Cert. + Project Status'!B7)","v":"-"},null,null,"Co-Grantee 2",{"$f":"IF('Grantee Cert. + Project Status'!B8=\"\",\"-\",'Grantee Cert. + Project Status'!B8)","v":"-"}]
[]
[null,"Annual Report Review Summary"]
[null,"Review Category","Findings",null,null,null,null,"Action(s) Required"]
[null,{"$f":"B15","v":"1. Expenditure Report Summary"}]
[null,{"$f":"B29","v":"2. Annual Operating Cash Flow"}]
[null,{"$f":"B36","v":"3. Milestone Achievement Summary"}]
[null,{"$f":"B48","v":"4. Standard Agreement Compliance"}]
[]
[]
[null,"1. Expenditure Report Summary"]
[null,"Eligible Use","Total Award Amounts","Total Amount Disbursed","Total Amount Undisbursed","Total Amount Expended - All reporting periods","Total Amount Expended - This Reporting Period","Difference in Amounts Expended Between Reporting Periods","Amount Unexpended","HCD Notes"]
[null,"Capital",{"$f":"SUM('1. Expenditure Report'!D12,'1. Expenditure Report'!D14,'1. Expenditure Report'!D16,'1. Expenditure Report'!D18,'1. Expenditure Report'!D20,'1. Expenditure Report'!D18,'1. Expenditure Report'!D23,'1. Expenditure Report'!D18,'1. Expenditure Report'!D25)","v":0},{"$f":"SUM('1. Expenditure Report'!E12,'1. Expenditure Report'!E14,'1. Expenditure Report'!E16,'1. Expenditure Report'!E18,'1. Expenditure Report'!E20,'1. Expenditure Report'!E18,'1. Expenditure Report'!E23,'1. Expenditure Report'!E18,'1. Expenditure Report'!E25)","v":0},{"$f":"C17-D17","v":0},{"$f":"SUM('1. Expenditure Report'!E45:E51)","v":0},{"$f":"SUM('1. Expenditure Report'!F45:F51)","v":0},{"$f":"SUM(ABS('1. Expenditure Report'!H45:H51))","v":0},{"$f":"_xlfn.IFS('Grantee Cert. + Project Status'!C39=\"Yes\",\"\",'Grantee Cert. + Project Status'!C39=\"No\",C17-F17,'Grantee Cert. + Project Status'!C39=\"Select One\",C17-F17)","v":0}]
[null,"Flexed Amount",{"$f":"SUM('1. Expenditure Report'!D13,'1. Expenditure Report'!D15,'1. Expenditure Report'!D17,'1. Expenditure Report'!D19,'1. Expenditure Report'!D21,'1. Expenditure Report'!D24,'1. Expenditure Report'!D26)","v":0},null,null,null,null,null,{"$f":"IF('Grantee Cert. + Project Status'!C39=\"Yes\",C18-F17,\"\")","v":""}]
[null,"Capitalized Operating Subsides (COSR)",{"$f":"SUM('1. Expenditure Report'!D27)","v":0},{"$f":"SUM('1. Expenditure Report'!E27)","v":0},{"$f":"C19-D19","v":0},{"$f":"SUM('1. Expenditure Report'!E52)","v":0},{"$f":"SUM('1. Expenditure Report'!F52)","v":0},{"$f":"SUM(ABS('1. Expenditure Report'!H52))","v":0},{"$f":"_xlfn.IFS('Grantee Cert. + Project Status'!C39=\"Yes\",\"\",'Grantee Cert. + Project Status'!C39=\"No\",C19-F19,'Grantee Cert. + Project Status'!C39=\"Select One\",C19-F19)","v":0}]
[null,"Flexed Amount",{"$f":"'1. Expenditure Report'!D28","v":0},null,null,null,null,null,{"$f":"IF('Grantee Cert. + Project Status'!C39=\"Yes\",C20-F19,\"\")","v":""}]
[null,"Bonus for Occupying Project 8 Months from Award Date",{"$f":"'1. Expenditure Report'!D29","v":0},{"$f":"'1. Expenditure Report'!E29","v":0},{"$f":"IF('1. Expenditure Report'!C37=\"Yes\",\"$0.00\",C21-D21)","v":0},{"$f":"'1. Expenditure Report'!E53","v":0},{"$f":"'1. Expenditure Report'!F53","v":0},{"$f":"SUM(ABS('1. Expenditure Report'!H53))","v":0},{"$f":"_xlfn.IFS('Grantee Cert. + Project Status'!C38=\"Yes\",\"Bonus forfeited\",'Grantee Cert. + Project Status'!C38=\"No\",C21-F21,'Grantee Cert. + Project Status'!C38=\"N/A\",\"\",'Grantee Cert. + Project Status'!C38=\"Select One\",\"\")","v":""}]
[null,"Question",null,null,"HCD Certification",null,"HCD Notes"]
[null,"1. Was HCD able to verify proof of expenditures for all amounts reported?",null,null,"Select One",null,null,null,null,null,null,null,{"$f":"IF(E23=\"No\",15,\"\")","v":""}]
[null,"2. Do the Sources of Funds listed in sections 4 (Total Development Costs and Non-Homekey Sources) and 5 (Total Operating Non-Homekey Sources) align with the Standard Agreement? If No, submission of a Budget Detail Adjustment Request form is required",null,null,"Select One",null,null,null,null,null,null,null,{"$f":"IF(E24=\"No\",5,\"\")","v":""}]
[null,"3. If there was a discrepancy between amounts reported expended between reporting periods, did Grantee provide an explanation?",null,null,"Select One"]
[null,"4. Has Grantee submitted Budget Flex  Request Form and received approval for adjusted award amounts?",null,null,"Select One"]
[null,"5. Was Bonus for Occupancy Project 8 Months from Award Date forfeited?",null,null,"Select One"]
[]
[null,"2. Annual Operating Cash Flow"]
[null,"Category",null,null,"Amount",null,null,"HCD Notes"]
[null,"Operating Sources  - This Reporting Period",null,null,{"$f":"'3. Operating Costs'!G91:G91","v":0}]
[null,"Operating Expenditures - This Reporting Period",null,null,{"$f":"'3. Operating Costs'!G86","v":0}]
[null,"Available Cashflow - This Reporting Period",null,null,{"$f":"'3. Operating Costs'!G93:G93","v":0}]
[null,"Explanation for positive or negative cash flow",null,null,{"$f":"'3. Operating Costs'!E94:E94","v":0}]
[]
[null,"3. Milestone Achievement Summary"]
[null,"Milestone",null,null,"Due Date",null,"Achieved Date",null,"HCD Certification"]
[null,"Site Acquisition",null,null,null,null,{"$f":"IF('Grantee Cert. + Project Status'!C44=\"\",\"\",'Grantee Cert. + Project Status'!C44)","v":""},null,"Select One",null,null,null,{"$f":"IFERROR(_xlfn.IFS(I38=\"Achieved – Late\",5,I38=\"Past Due\",15),\"\")","v":""}]
[null,"Capital Expenditures",null,null,{"$f":"IF('Grantee Cert. + Project Status'!B45=\"\",\"\",'Grantee Cert. + Project Status'!B45)","v":""},null,{"$f":"IF('Grantee Cert. + Project Status'!C45=\"\",\"\",'Grantee Cert. + Project Status'!C45)","v":""},null,"Select One",null,null,null,{"$f":"IFERROR(_xlfn.IFS(I39=\"Achieved – Late\",5,I39=\"Past Due\",15),\"\")","v":""}]
[null,"Construction Completion",null,null,{"$f":"IF('Grantee Cert. + Project Status'!B46=\"\",\"\",'Grantee Cert. + Project Status'!B46)","v":""},null,{"$f":"IF('Grantee Cert. + Project Status'!C46=\"\",\"\",'Grantee Cert. + Project Status'!C46)","v":""},null,"Select One",null,null,null,{"$f":"IFERROR(_xlfn.IFS(I40=\"Achieved – Late\",5,I40=\"Past Due but Occupied\",5,I40=\"Past Due\",10),\"\")","v":""}]
[null,"Occupancy",null,null,{"$f":"IF('Grantee Cert. + Project Status'!B47=\"\",\"\",'Grantee Cert. + Project Status'!B47)","v":""},null,{"$f":"IF('Grantee Cert. + Project Status'!C47=\"\",\"\",'Grantee Cert. + Project Status'!C47)","v":""},null,"Select One",null,null,null,{"$f":"IFERROR(_xlfn.IFS(I41=\"Achieved – Late\",5,I41=\"Past Due\",15),\"\")","v":""}]
[null,"Recorded Use Restriction",null,null,{"$f":"IF('Grantee Cert. + Project Status'!B48=\"\",\"\",'Grantee Cert. + Project Status'!B48)","v":""},null,{"$f":"IF('Grantee Cert. + Project Status'!C48=\"\",\"\",'Grantee Cert. + Project Status'!C48)","v":""},null,"Select One",null,null,null,{"$f":"IFERROR(_xlfn.IFS(I42=\"Achieved – Late\",5,I42=\"Past Due\",15),\"\")","v":""}]
[null,"Capitalized Operating Subsidy (COSR)  Expenditures",null,null,{"$f":"IF('Grantee Cert. + Project Status'!B49=\"\",\"\",'Grantee Cert. + Project Status'!B49)","v":""},null,{"$f":"IF('Grantee Cert. + Project Status'!C49=\"\",\"\",'Grantee Cert. + Project Status'!FC5)","v":""},null,"Select One",null,null,null,{"$f":"IFERROR(_xlfn.IFS(I43=\"Achieved – Late\",5,I43=\"Past Due\",15),\"\")","v":""}]
[null,"Any Late Reports or Reports of Milestone Completion? ",null,null,"Select One",null,"If so, how many?",null,null,null,null,null,{"$f":"I44*5","v":0}]
[null,"HCD Notes:"]
[]
[]
[null,"4. Standard Agreement Compliance"]
[null,"Question",null,null,null,null,"Finding",null,"HCD Certification"]
[null,"Occupancy due date has passed and occupancy rate is below 90%",null,null,null,null,{"$f":"IFERROR(IF('2.Standard Agreement Compliance'!G73<0.9,\"Occupancy Rate is below 90%\",\"\"),\"\")","v":""},null,"Select One",null,null,null,{"$f":"IF(I50=\"Corrective Action Required\",5,\"\")","v":""}]
[null,"Project does not restrict units for required target population - People Experiencing Homelessness (not Chronic)",null,null,null,null,{"$f":"IF(AND('2.Standard Agreement Compliance'!$G$62<'2.Standard Agreement Compliance'!G29,'2.Standard Agreement Compliance'!F29=\"Yes\"),\"Under Required Percentage Served\",\"\")","v":""},null,"Select One",null,null,null,{"$f":"IF(I51=\"Corrective Action Required\",2,\"\")","v":""}]
[null,"Project does not restrict units for required target population - Chronic Homeless Individuals",null,null,null,null,{"$f":"IF(AND('2.Standard Agreement Compliance'!$G$63<'2.Standard Agreement Compliance'!G31,'2.Standard Agreement Compliance'!F31=\"Yes\"),\"Under Required Percentage Served\",\"\")","v":""},null,"Select One",null,null,null,{"$f":"IF(I52=\"Corrective Action Required\",2,\"\")","v":""}]
[null,"Project does not serve required target population - Homeless Youth or At-Risk Youth",null,null,null,null,{"$f":"IF(AND('2.Standard Agreement Compliance'!$G$64<'2.Standard Agreement Compliance'!G30,'2.Standard Agreement Compliance'!F30=\"Yes\"),\"Under Required Percentage Served\",\"\")","v":""},null,"Select One",null,null,null,{"$f":"IF(I53=\"Corrective Action Required\",2,\"\")","v":""}]
[null,"Project does not include minimum percentage of units accessible to those with mobility disabilities",null,null,null,null,{"$f":"IF('2.Standard Agreement Compliance'!G20>'2.Standard Agreement Compliance'!$G$65,\"Does not Meet Accessibility Requirements in SA\",\"\")","v":""},null,"Select One",null,null,null,{"$f":"IF(I54=\"Corrective Action Required\",2,\"\")","v":""}]
[null,"Project does not include minimum percentage of units accessible to those with hearing or vision disabilities",null,null,null,null,{"$f":"IF('2.Standard Agreement Compliance'!G21>'2.Standard Agreement Compliance'!$G$66,\"Does not Meet Accessibility Requirements in SA\",\"\")","v":""},null,"Select One",null,null,null,{"$f":"IF(I55=\"Corrective Action Required\",2,\"\")","v":""}]
[null,"Standard Agreement Amendment is Required - Change to Unit Mix",null,null,null,null,{"$f":"IF('2.Standard Agreement Compliance'!F36:F36=\"No\",'2.Standard Agreement Compliance'!F35:F35,\"\")","v":""},null,"Select One",null,null,null,{"$f":"IF(I56=\"Corrective Action Required\",5,\"\")","v":""}]
[null,"One or more units are not occupied by the correct target population",null,null,null,null,{"$f":"IF('2.Standard Agreement Compliance'!H57=0,\"\",\"One or more units are not occupied by target population\")","v":""},null,"Select One",null,null,null,{"$f":"IF(I57=\"Corrective Action Required\",5,\"\")","v":""}]
[null,"Project will Comply with waiver of increased income limits for the selected percentage of units?",null,null,null,null,{"$f":"IF('2.Standard Agreement Compliance'!F19=\"Select One\",\"Grantee did not select a response\",'2.Standard Agreement Compliance'!F19)","v":"Grantee did not select a response"},null,"Select One",null,null,null,""]
[null,"Project is providing the required supportive services to individuals with Special Needs, Supportive Housing, or other tenants of the project as required",null,null,null,null,{"$f":"IF('Grantee Cert. + Project Status'!E72=\"Select One\",\"Grantee did not select a response\",'Grantee Cert. + Project Status'!E72)","v":"Grantee did not select a response"},null,"Select One",null,null,null,""]
[null,"Project does not comply with required special term and condition from Exhibit E of the Standard Agreement",null,null,null,null,null,null,"Select One",null,null,null,""]
[null,"HCD Notes:  "]
[]
[null,"5. Certification",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M23:M62)","v":0}]
[null,"Risk Assessment Score",null,null,{"$f":"M63","v":0},null,null,{"$f":"IF(E64>=50,\"Section Chief Signature Required\",\"\")","v":""}]
[null,"MGM Representative:",null,null,"Name",null,null,"Date"]
[null,"MGM Manager:",null,null,"Name",null,null,"Date"]
[null,"MGM Section Chief (if applicable):",null,null,"Name",null,null,"Date"]

{"sheet":"Drop-Down","index":7,"n_rows":164,"n_cols":3,"rows_kept":164,"cut":false,"hidden":true,"merged":[]}
["Reporting Period"]
["Select One"]
["January 1, 2024 - December 31, 2024 \n(Report Due March 31, 2025)"]
["January 1, 2025 - December 31, 2025 \n(Report Due March 31, 2026)"]
["January 1, 2026 - December 31, 2026 \n(Report Due March 31, 2027)"]
["January 1, 2028 - December 31, 2027 \n(Report Due March 31, 2028)"]
["January 1, 2028 - December 31, 2028 \n(Report Due March 31, 2029)"]
["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"]
["Modular 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"]
["CEQA Exemption"]
["Select one"]
["Yes - Statutory Exemption"]
["Yes - Categorical Exemption"]
["No - CEQA Completed without Exemption"]
["No - CEQA Not Yet Completed"]
["OVERALL SITE STATUS"]
["Select One"]
["Construction not yet started"]
["Under Construction"]
["Under Construction (Occupied Offsite)"]
["Construction Complete - Leasing Up"]
["Fully Occupied and Operational"]
["Interim to Perm - Under Construction"]
["Interim to Perm - Construction Complete - Leasing Up"]
["Interim to Perm - Fully Occupied and Operational"]
["Type of Match"]
["Select One"]
["Acquisition"]
["Rehabilitation"]
["Relocation"]
["Other"]
["Type of Match - Operating"]
["Select One"]
["Operating"]
["Other"]
["Milestone Completion Status"]
["Select One"]
["Not Yet Due"]
["Achieved"]
["Achieved – Late"]
["Past Due"]
["Milestone Completion Status - Construction"]
["Select One"]
["Not Yet Due"]
["Achieved"]
["Achieved – Late"]
["Past Due but Occupied"]
["Past Due"]
["HCD Certification"]
["Select One"]
["Yes"]
["No"]
["N/A"]

{"sheet":"DataTable","index":8,"n_rows":2,"n_cols":246,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["HCD Contract Number","Project Name","Sponsor Name","Sponsor Type","Project County","Geographic Region","Confidential Address?","Project Address","Project Address 2 (if applicable)","Project Address 3 (if applicable)","Project Address 4 (if applicable)","Project Address 5 (if applicable)","Project Address 6 (if applicable)","Project Address 7 (if applicable)","Cosponsor1 Name","Cosponsor1 Type","Cosponsor2 Name","Cosponsor2 Type","Preparer Name","Preparer Title","Preparer Phone #","Preparer Email","HCD Rep","Reporting Period","Overall Site Status","Date of Start of Construction","Explanation if Construction not Started","Years Occupied","Unit Type","Project Type","Project Type - Other Description","Has Unit Type or Project Type Changed?","Employ Housing First?","Was Occupancy Bonus Forfeited?","Has Flex Form been approved?","Milestone - Site Acquisition - Date Achieved","Milestone - Capital Expenditures - Current Due Date","Milestone - Capital Expenditures - Date Achieved","Milestone - Construction Completion - Current Due Date","Milestone - Construction Completion - Date Achieved","Milestone - Full Occupancy - Current Due Date","Milestone - Full Occupancy - Date Achieved","Milestone - Recorded Use Restriction - Current Due Date","Milestone - Recorded Use Restriction - Date Achieved","Milestone - COSR Expenditures - Current Due Date","Milestone - COSR Expenditures - Date Achieved","Interim to Perm Conversion Plan on File?","Interim to Perm Conversion Notice Form Submitted?","Date of Construction Start (Anticipated)","Date of Construction Start (Actual)","Number of Units - Pre-Conversion/Inteirm Phase (Actual)","Number of Units Offline During Construction","Number of Units - Post-Conversion/Perm Phase (Anticipated)","Date of Construction Completion (Anticipated)","Date of Construction Completion (Actual)","Date of Full Occupancy Post Conversion (Actual)","Date of Permanent Use Restriction Recorded (Actual)","Interim to Perm Completion Form Submitted?","Include in Events and Promotions?","Payee","Total HCD Award","Original Award - Capital","Original Award - COSR Awarded","Exp. Occupancy Bonus","Exp Occupancy Forfeited?","Original $ Award Acquisition+Rehab","Original $ Award on Master Leasing of Properties","Original $ Award on Conversion of NonRes to Res","Original $ Award New Const.","Original $ Award on Purchase of Aff. Covenants","Original $ Award on Relocation","Original $ Award COSR ","Flexed $ Award Acquisition+Rehab","Flexed $ Award on Master Leasing of Properties","Flexed $ Award on Conversion of NonRes to Res","Flexed $ Award New Const.","Flexed $ Award on Purchase of Aff. Covenants","Flexed $ Award on Relocation","Flexed $ Award COSR ","Total Disbursed.","Total Expended All Periods","$ Exp All Periods - Acq.","$ Exp All Periods - Rehab","$ Exp All Periods - Master Leasing","$ Exp All Periods - Conversion","$ Exp All Periods - New Constr.","$ Exp All Periods - Aff. Covenants","$ Exp All Periods - Relocation","$ Exp All Periods - COSR ","Total Expended This Period","$ Exp This Period - Acq.","$ Exp This Period - Rehab","$ Exp This Period - Master Leasing","$ Exp This Period - Conversion","$ Exp This Period - New Constr.","$ Exp This Period - Aff. Covenants","$ Exp This Period - Relocation","$ Exp This Period - COSR ","Undisbursed Funds","Unexpended Funds","Capital Expended - FY21-22","Capital Expended - FY22-23","Capital Expended - FY23-24","Capital Expended - FY24-25","Capital Expended - FY25-26","Capital Expended - FY26-27","Capital Expended - Total","Operating Expended - FY21-22","Operating Expended - FY22-23","Operating Expended - FY23-24","Operating Expended - FY24-25","Operating Expended - FY25-26","Operating Expended - FY26-27","Capital Match Source 1","Cap Match 1 Amount","Capital Match Source 2","Cap Match 2 Amount","Capital Match Source 3","Cap Match 3 Amount","Capital Match Source 4","Cap Match 4 Amount","Capital Match Source 5","Cap Match 5 Amount","Capital Match Source 6","Cap Match 6 Amount","Total Acquisition Match","Total Rehab Match","Total Relo Match","Total Other Capital Match","Total Non-HK Matching Sources - Capital","Total Cap Dev Cost","# PBVS","$ PBVS","Operating Match Source 1","Operating Match Amount 1 ","Operating Match Source 2","Operating Match Amount 2","Operating Match Source 3","Operating Match Amount 3","Operating Match Source 4","Operating Match Amount 4","Operating Match Source 5","Operating Match Amount 5","Total COSR Match","Total Other Match","Total Non-HK Matching Sources - Operating","Homeless Obligation %?","Chronic Homeless Obligation %?","Youth Obligation %?","Other Sub-Population Targeted","Waiver of AMI Increase?","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","HH Other Exits","Indv Other Exits","Chronic Homeless Other Exits","Minor Child Homeless Other Exits","TAY Homeless Other Exits","Seniors Homeless Other Exits","Vets Homeless Other Exits","# Project Sites","#HK Assisted Units \n(incl. mgr)","Asst 0-BR","Asst 1-BR","Asst 2-BR","Asst 3-BR+","Youth Units","Chronic Homeless Units","Experiencing Homelessness Units","Mobility Accessible Units","Hearing/Vision Accessible Units","Manager Units","Existing Tenant Units","Total Project Units","#HK Units","#HK Units Occupied with correct target population","# of HK Units Occupied with incorrect target population","HK Occ Rate.","Cost Per Unit","Total Rent Revenue","Total Operating Sources - Non-Homekey","Name of Operating Funding Source 1","Operating Funding Source 1 - Amount","Name of Operating Funding Source 2","Operating Funding Source 2 - Amount","Name of Operating Funding Source 3","Operating Funding Source 3 - Amount","Name of Operating Funding Source 4","Operating Funding Source 4 - Amount","Name of Operating Funding Source 5","Operating Funding Source 5 - Amount","Admin Exp. - HK","Admin Exp. - All Sources","Utilities Exp. - HK","Utilities Exp. - All sources","Operating/Mainten. Exp. - HK","Operating/Mainten. Exp. - All sources","Taxes/Insurance - HK","Taxes/Insurance - All Sources","Supportive Services Exp. - HK","Supportive Services Exp. - All sources","Total Op Costs - HK","Operating Sources - All Sources","Operating Expenditures - All Sources","Cash Flow this Reporting Period","Tenant Outreach","Anticipated Turnover","Description of Supportive Services","Lessons Learned","Proposed Dev Vision","Dev Vision Changes","Progress and Status securing Entitlements","Success Stories","Efforts advancing racial equity and inclusion","Commitment to Accessibility "]
[{"$f":"'Grantee Cert. + Project Status'!B5","v":0},{"$f":"'Grantee Cert. + Project Status'!E5","v":0},{"$f":"'Grantee Cert. + Project Status'!B6","v":0},{"$f":"'Grantee Cert. + Project Status'!E6","v":0},{"$f":"'Grantee Cert. + Project Status'!B11","v":0},{"$f":"'Grantee Cert. + Project Status'!E11","v":" "},{"$f":"'Grantee Cert. + Project Status'!$B$13","v":"Select One"},{"$f":"IF('Grantee Cert. + Project Status'!$B$13=\"Yes\",\"CONFIDENTIAL\",'Grantee Cert. + Project Status'!B16)","v":0},{"$f":"IF('Grantee Cert. + Project Status'!$B$13=\"Yes\",\"CONFIDENTIAL\",'Grantee Cert. + Project Status'!B17)","v":0},{"$f":"IF('Grantee Cert. + Project Status'!$B$13=\"Yes\",\"CONFIDENTIAL\",'Grantee Cert. + Project Status'!B18)","v":0},{"$f":"IF('Grantee Cert. + Project Status'!$B$13=\"Yes\",\"CONFIDENTIAL\",'Grantee Cert. + Project Status'!B19)","v":0},{"$f":"IF('Grantee Cert. + Project Status'!$B$13=\"Yes\",\"CONFIDENTIAL\",'Grantee Cert. + Project Status'!B20)","v":0},{"$f":"IF('Grantee Cert. + Project Status'!$B$13=\"Yes\",\"CONFIDENTIAL\",'Grantee Cert. + Project Status'!B21)","v":0},{"$f":"IF('Grantee Cert. + Project Status'!$B$13=\"Yes\",\"CONFIDENTIAL\",'Grantee Cert. + Project Status'!B22)","v":0},{"$f":"'Grantee Cert. + Project Status'!B7","v":0},{"$f":"'Grantee Cert. + Project Status'!E7","v":0},{"$f":"'Grantee Cert. + Project Status'!B8","v":0},{"$f":"'Grantee Cert. + Project Status'!E8","v":0},{"$f":"'Grantee Cert. + Project Status'!B9","v":0},{"$f":"'Grantee Cert. + Project Status'!E9","v":0},{"$f":"'Grantee Cert. + Project Status'!B10","v":0},{"$f":"'Grantee Cert. + Project Status'!E10","v":0},{"$f":"'6. Report Summary'!E65","v":"Name"},{"$f":"'Grantee Cert. + Project Status'!B4","v":0},{"$f":"'Grantee Cert. + Project Status'!C27","v":"Select One"},{"$f":"'Grantee Cert. + Project Status'!C30","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!C31","v":0},{"$f":"'Grantee Cert. + Project Status'!C32","v":"Select One"},{"$f":"'Grantee Cert. + Project Status'!C33","v":"Select One"},{"$f":"'Grantee Cert. + Project Status'!C34","v":"Select One"},{"$f":"'Grantee Cert. + Project Status'!C35","v":0},{"$f":"'Grantee Cert. + Project Status'!C36","v":"Select One"},{"$f":"'Grantee Cert. + Project Status'!C37","v":"Select One"},{"$f":"'Grantee Cert. + Project Status'!C38","v":"Select One"},{"$f":"'Grantee Cert. + Project Status'!C38","v":"Select One"},{"$f":"'Grantee Cert. + Project Status'!C44","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$B45","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$C45","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$B46","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$C46","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$B47","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$C47","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$B48","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$C48","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$B49","v":"00:00:00"},{"$f":"IF('Grantee Cert. + Project Status'!$C49=\"\",\"\",'Grantee Cert. + Project Status'!$C49)","v":""},{"$f":"'Grantee Cert. + Project Status'!$C53","v":"Select One"},{"$f":"'Grantee Cert. + Project Status'!$C54","v":"Select One"},{"$f":"'Grantee Cert. + Project Status'!$C55","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$C56","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$C57","v":0},{"$f":"'Grantee Cert. + Project Status'!$C58","v":0},{"$f":"'Grantee Cert. + Project Status'!$C59","v":0},{"$f":"'Grantee Cert. + Project Status'!$C60","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$C61","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$C62","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$C63","v":"00:00:00"},{"$f":"'Grantee Cert. + Project Status'!$C64","v":"Select One"},{"$f":"'Grantee Cert. + Project Status'!E73","v":"Select One"},{"$f":"'1. Expenditure Report'!H6","v":0},{"$f":"'1. Expenditure Report'!D30","v":0},{"$f":"'1. Expenditure Report'!D12+'1. Expenditure Report'!D14+'1. Expenditure Report'!D16+'1. Expenditure Report'!D18+'1. Expenditure Report'!D20+'1. Expenditure Report'!D23+'1. Expenditure Report'!D25","v":0},{"$f":"'1. Expenditure Report'!D27+'1. Expenditure Report'!D29","v":0},{"$f":"'1. Expenditure Report'!D29","v":0},{"$f":"'Grantee Cert. + Project Status'!C38","v":"Select One"},{"$f":"'1. Expenditure Report'!D12+'1. Expenditure Report'!D14","v":0},{"$f":"'1. Expenditure Report'!D16","v":0},{"$f":"'1. Expenditure Report'!D18","v":0},{"$f":"'1. Expenditure Report'!D20","v":0},{"$f":"'1. Expenditure Report'!D23","v":0},{"$f":"'1. Expenditure Report'!D25","v":0},{"$f":"'1. Expenditure Report'!D27","v":0},{"$f":"'1. Expenditure Report'!D13+'1. Expenditure Report'!D15","v":0},{"$f":"'1. Expenditure Report'!D17","v":0},{"$f":"'1. Expenditure Report'!D19","v":0},{"$f":"'1. Expenditure Report'!D21","v":0},{"$f":"'1. Expenditure Report'!D24","v":0},{"$f":"'1. Expenditure Report'!D26","v":0},{"$f":"'1. Expenditure Report'!D28","v":0},{"$f":"'1. Expenditure Report'!E30","v":0},{"$f":"'1. Expenditure Report'!E54","v":0},{"$f":"'1. Expenditure Report'!$E45","v":0},{"$f":"'1. Expenditure Report'!$E46","v":0},{"$f":"'1. Expenditure Report'!$E47","v":0},{"$f":"'1. Expenditure Report'!$E48","v":0},{"$f":"'1. Expenditure Report'!$E49","v":0},{"$f":"'1. Expenditure Report'!$E50","v":0},{"$f":"'1. Expenditure Report'!$E51","v":0},{"$f":"'1. Expenditure Report'!$E52","v":0},{"$f":"'1. Expenditure Report'!$F54","v":0},{"$f":"'1. Expenditure Report'!F45","v":0},{"$f":"'1. Expenditure Report'!$F46","v":0},{"$f":"'1. Expenditure Report'!$F47","v":0},{"$f":"'1. Expenditure Report'!$F48","v":0},{"$f":"'1. Expenditure Report'!$F49","v":0},{"$f":"'1. Expenditure Report'!$F50","v":0},{"$f":"'1. Expenditure Report'!$F51","v":0},{"$f":"'1. Expenditure Report'!F52","v":0},{"$f":"'6. Report Summary'!E17+'6. Report Summary'!E19","v":0},{"$f":"'1. Expenditure Report'!D30-'1. Expenditure Report'!D54","v":0},{"$f":"'1. Expenditure Report'!C60","v":0},{"$f":"'1. Expenditure Report'!D60","v":0},{"$f":"'1. Expenditure Report'!E60","v":0},{"$f":"'1. Expenditure Report'!F60","v":0},{"$f":"'1. Expenditure Report'!G60","v":0},{"$f":"'1. Expenditure Report'!H60","v":0},{"$f":"'1. Expenditure Report'!I60","v":0},{"$f":"'1. Expenditure Report'!C61","v":0},{"$f":"'1. Expenditure Report'!D61","v":0},{"$f":"'1. Expenditure Report'!E61","v":0},{"$f":"'1. Expenditure Report'!F61","v":0},{"$f":"'1. Expenditure Report'!G61","v":0},{"$f":"'1. Expenditure Report'!H61","v":0},{"$f":"'1. Expenditure Report'!$B69","v":0},{"$f":"'1. Expenditure Report'!$D69","v":0},{"$f":"'1. Expenditure Report'!$B70","v":0},{"$f":"'1. Expenditure Report'!$D70","v":0},{"$f":"'1. Expenditure Report'!$B71","v":0},{"$f":"'1. Expenditure Report'!$D71","v":0},{"$f":"'1. Expenditure Report'!$B72","v":0},{"$f":"'1. Expenditure Report'!$D72","v":0},{"$f":"'1. Expenditure Report'!$B73","v":0},{"$f":"'1. Expenditure Report'!$D73","v":0},{"$f":"'1. Expenditure Report'!$B74","v":0},{"$f":"'1. Expenditure Report'!$D74","v":0},{"$f":"SUMIF('1. Expenditure Report'!$G$69:$G$74,\"Acquisition\",'1. Expenditure Report'!$D$69:$D$74)","v":0},{"$f":"SUMIF('1. Expenditure Report'!$G$69:$G$74,\"Rehabilitation\",'1. Expenditure Report'!$D$69:$D$74)","v":0},{"$f":"SUMIF('1. Expenditure Report'!$G$69:$G$74,\"Relocation\",'1. Expenditure Report'!$D$69:$D$74)","v":0},{"$f":"SUMIF('1. Expenditure Report'!$G$69:$G$74,\"Other\",'1. Expenditure Report'!$D$69:$D$74)","v":0},{"$f":"'1. Expenditure Report'!$D75","v":0},{"$f":"'1. Expenditure Report'!$D$77","v":0},{"$f":"'1. Expenditure Report'!D83","v":0},{"$f":"'1. Expenditure Report'!H83","v":0},{"$f":"'1. Expenditure Report'!$B85","v":0},{"$f":"'1. Expenditure Report'!$D85","v":0},{"$f":"'1. Expenditure Report'!$B86","v":0},{"$f":"'1. Expenditure Report'!$D86","v":0},{"$f":"'1. Expenditure Report'!$B87","v":0},{"$f":"'1. Expenditure Report'!$D87","v":0},{"$f":"'1. Expenditure Report'!$B88","v":0},{"$f":"'1. Expenditure Report'!$D88","v":0},{"$f":"'1. Expenditure Report'!$B89","v":0},{"$f":"'1. Expenditure Report'!$D89","v":0},{"$f":"SUMIF('1. Expenditure Report'!$G$85:$G$89,\"Operating\",'1. Expenditure Report'!$D$85:$D$89)","v":0},{"$f":"SUMIF('1. Expenditure Report'!$G$85:$G$89,\"Other\",'1. Expenditure Report'!$D$85:$D$89)","v":0},{"$f":"EO2+EN2","v":0},{"$f":"'2.Standard Agreement Compliance'!G29","v":0},{"$f":"'2.Standard Agreement Compliance'!G31","v":0},{"$f":"'2.Standard Agreement Compliance'!G30","v":0},{"$f":"'2.Standard Agreement Compliance'!F33","v":0},{"$f":"'2.Standard Agreement Compliance'!F17","v":"Select One"},{"$f":"'2.Standard Agreement Compliance'!F12","v":"Select One"},{"$f":"'2.Standard Agreement Compliance'!F10","v":"Select One"},{"$f":"'2.Standard Agreement Compliance'!F11","v":"Select one"},{"$f":"'5. Progress and Outcomes'!C7+'5. Progress and Outcomes'!D7","v":0},{"$f":"'5. Progress and Outcomes'!D7+'5. Progress and Outcomes'!E7","v":0},{"$f":"'5. Progress and Outcomes'!C7","v":0},{"$f":"'5. Progress and Outcomes'!D7","v":0},{"$f":"'5. Progress and Outcomes'!C8+'5. Progress and Outcomes'!D8","v":0},{"$f":"'5. Progress and Outcomes'!C9+'5. Progress and Outcomes'!D9","v":0},{"$f":"'5. Progress and Outcomes'!C10+'5. Progress and Outcomes'!D10","v":0},{"$f":"'5. Progress and Outcomes'!C11+'5. Progress and Outcomes'!D11","v":0},{"$f":"'5. Progress and Outcomes'!C12+'5. Progress and Outcomes'!D12","v":0},{"$f":"'5. Progress and Outcomes'!E7","v":0},{"$f":"'5. Progress and Outcomes'!E6","v":0},{"$f":"'5. Progress and Outcomes'!E8","v":0},{"$f":"'5. Progress and Outcomes'!E9","v":0},{"$f":"'5. Progress and Outcomes'!E10","v":0},{"$f":"'5. Progress and Outcomes'!E11","v":0},{"$f":"'5. Progress and Outcomes'!E12","v":0},{"$f":"'5. Progress and Outcomes'!F7","v":0},{"$f":"'5. Progress and Outcomes'!F6","v":0},{"$f":"'5. Progress and Outcomes'!F8","v":0},{"$f":"'5. Progress and Outcomes'!F9","v":0},{"$f":"'5. Progress and Outcomes'!F10","v":0},{"$f":"'5. Progress and Outcomes'!F11","v":0},{"$f":"'5. Progress and Outcomes'!F12","v":0},{"$f":"'5. Progress and Outcomes'!G7","v":0},{"$f":"'5. Progress and Outcomes'!G6","v":0},{"$f":"'5. Progress and Outcomes'!G8","v":0},{"$f":"'5. Progress and Outcomes'!G9","v":0},{"$f":"'5. Progress and Outcomes'!G10","v":0},{"$f":"'5. Progress and Outcomes'!G11","v":0},{"$f":"'5. Progress and Outcomes'!G12","v":0},{"$f":"'5. Progress and Outcomes'!H6","v":0},{"$f":"'5. Progress and Outcomes'!$H7","v":0},{"$f":"'5. Progress and Outcomes'!$H8","v":0},{"$f":"'5. Progress and Outcomes'!$H9","v":0},{"$f":"'5. Progress and Outcomes'!$H10","v":0},{"$f":"'5. Progress and Outcomes'!$H11","v":0},{"$f":"'5. Progress and Outcomes'!$H12","v":0},{"$f":"'Grantee Cert. + Project Status'!B15","v":"Select One"},{"$f":"'2.Standard Agreement Compliance'!F61","v":0},{"$f":"SUMIFS('2.Standard Agreement Compliance'!E40:E56,'2.Standard Agreement Compliance'!F40:F56,0)-SUMIFS('2.Standard Agreement Compliance'!E40:E56,'2.Standard Agreement Compliance'!F40:F56,0,'2.Standard Agreement Compliance'!$B$40:$B$56,\"Non-Homekey Unit\")","v":0},{"$f":"SUMIFS('2.Standard Agreement Compliance'!E40:E56,'2.Standard Agreement Compliance'!F40:F56,1)-SUMIFS('2.Standard Agreement Compliance'!E40:E56,'2.Standard Agreement Compliance'!F40:F56,1,'2.Standard Agreement Compliance'!$B$40:$B$56,\"Non-Homekey Unit\")","v":0},{"$f":"SUMIFS('2.Standard Agreement Compliance'!E40:E56,'2.Standard Agreement Compliance'!F40:F56,2)-SUMIFS('2.Standard Agreement Compliance'!E40:E56,'2.Standard Agreement Compliance'!F40:F56,2,'2.Standard Agreement Compliance'!$B$40:$B$56,\"Non-Homekey Unit\")","v":0},{"$f":"SUMIFS('2.Standard Agreement Compliance'!E40:E56,'2.Standard Agreement Compliance'!F40:F56,\"3+\")-SUMIFS('2.Standard Agreement Compliance'!E40:E56,'2.Standard Agreement Compliance'!F40:F56,\"3+\",'2.Standard Agreement Compliance'!$B$40:$B$56,\"Non-Homekey Unit\")","v":0},{"$f":"'2.Standard Agreement Compliance'!F64","v":0},{"$f":"'2.Standard Agreement Compliance'!F63","v":0},{"$f":"'2.Standard Agreement Compliance'!F62","v":0},{"$f":"'2.Standard Agreement Compliance'!F65","v":0},{"$f":"'2.Standard Agreement Compliance'!F66","v":0},{"$f":"'2.Standard Agreement Compliance'!F70","v":0},{"$f":"SUMIF('2.Standard Agreement Compliance'!B40:B56,\"Existing Tenant\",'2.Standard Agreement Compliance'!E40:E56)","v":0},{"$f":"'2.Standard Agreement Compliance'!E57","v":0},{"$f":"'2.Standard Agreement Compliance'!F61","v":0},{"$f":"+SUM('2.Standard Agreement Compliance'!G40:G56)-SUMIF('2.Standard Agreement Compliance'!B40:E56,\"Non-Homekey Unit\",'2.Standard Agreement Compliance'!G40:G56)","v":0},{"$f":"SUM('2.Standard Agreement Compliance'!H40:H56)","v":0},{"$f":"'2.Standard Agreement Compliance'!G73","v":""},{"$f":"IFERROR($EA$2/$GW$2,\"\")","v":""},{"$f":"'3. Operating Costs'!G17","v":0},{"$f":"'3. Operating Costs'!F25","v":0},{"$f":"'3. Operating Costs'!$D20","v":"Please Enter Funding Source"},{"$f":"'3. Operating Costs'!$F20","v":0},{"$f":"'3. Operating Costs'!$D21","v":"Please Enter Funding Source"},{"$f":"'3. Operating Costs'!$F21","v":0},{"$f":"'3. Operating Costs'!$D22","v":"Please Enter Funding Source"},{"$f":"'3. Operating Costs'!$F22","v":0},{"$f":"'3. Operating Costs'!$D23","v":"Please Enter Funding Source"},{"$f":"'3. Operating Costs'!$F23","v":0},{"$f":"'3. Operating Costs'!$D24","v":"Please Enter Funding Source"},{"$f":"'3. Operating Costs'!$F24","v":0},{"$f":"'3. Operating Costs'!E48","v":0},{"$f":"'3. Operating Costs'!G48","v":0},{"$f":"'3. Operating Costs'!E54","v":0},{"$f":"'3. Operating Costs'!G54","v":0},{"$f":"'3. Operating Costs'!E68","v":0},{"$f":"'3. Operating Costs'!G68","v":0},{"$f":"'3. Operating Costs'!E77","v":0},{"$f":"'3. Operating Costs'!G77","v":0},{"$f":"'3. Operating Costs'!E84","v":0},{"$f":"'3. Operating Costs'!G84","v":0},{"$f":"'3. Operating Costs'!E86","v":0},{"$f":"'3. Operating Costs'!G26","v":0},{"$f":"'3. Operating Costs'!G92","v":0},{"$f":"'3. Operating Costs'!G93","v":0},{"$f":"'5. Progress and Outcomes'!B18","v":0},{"$f":"'5. Progress and Outcomes'!B20","v":0},{"$f":"'5. Progress and Outcomes'!B22","v":0},{"$f":"'5. Progress and Outcomes'!B24","v":0},{"$f":"'5. Progress and Outcomes'!B26","v":0},{"$f":"'5. Progress and Outcomes'!B28","v":0},{"$f":"'5. Progress and Outcomes'!B30","v":0},{"$f":"'5. Progress and Outcomes'!B32","v":0},{"$f":"'4. Equity Strategies'!$B$7","v":0},{"$f":"'4. Equity Strategies'!$B$9","v":0}]

{"sheet":"Site Data","index":9,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Contract Number","Sponsor","Project Name","Site Address","APN"]
[{"$f":"'Grantee Cert. + Project Status'!$B$5","v":0},{"$f":"Sponsor","v":0},{"$f":"'Grantee Cert. + Project Status'!$E$5","v":0},{"$f":"'Grantee Cert. + Project Status'!B16","v":0},{"$f":"'Grantee Cert. + Project Status'!C16","v":0}]
[{"$f":"'Grantee Cert. + Project Status'!$B$5","v":0},0,{"$f":"'Grantee Cert. + Project Status'!$E$5","v":0},{"$f":"'Grantee Cert. + Project Status'!B17","v":0},{"$f":"'Grantee Cert. + Project Status'!C17","v":0}]
[{"$f":"'Grantee Cert. + Project Status'!$B$5","v":0},0,{"$f":"'Grantee Cert. + Project Status'!$E$5","v":0},{"$f":"'Grantee Cert. + Project Status'!B18","v":0},{"$f":"'Grantee Cert. + Project Status'!C18","v":0}]
[{"$f":"'Grantee Cert. + Project Status'!$B$5","v":0},0,{"$f":"'Grantee Cert. + Project Status'!$E$5","v":0},{"$f":"'Grantee Cert. + Project Status'!B19","v":0},{"$f":"'Grantee Cert. + Project Status'!C19","v":0}]
[{"$f":"'Grantee Cert. + Project Status'!$B$5","v":0},0,{"$f":"'Grantee Cert. + Project Status'!$E$5","v":0},{"$f":"'Grantee Cert. + Project Status'!B20","v":0},{"$f":"'Grantee Cert. + Project Status'!C20","v":0}]
[{"$f":"'Grantee Cert. + Project Status'!$B$5","v":0},0,{"$f":"'Grantee Cert. + Project Status'!$E$5","v":0},{"$f":"'Grantee Cert. + Project Status'!$B21","v":0},{"$f":"'Grantee Cert. + Project Status'!C21","v":0}]
[{"$f":"'Grantee Cert. + Project Status'!$B$5","v":0},0,{"$f":"'Grantee Cert. + Project Status'!$E$5","v":0},{"$f":"'Grantee Cert. + Project Status'!$B22","v":0},{"$f":"'Grantee Cert. + Project Status'!C22","v":0}]

{"sheet":"Equity Data","index":10,"n_rows":2,"n_cols":47,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["HCD Contract","Sponsor","Project Name","Reporting Period","Total HK","Total CoC","# White HK","# White CoC","% Wt HK","% Wt CoC","# Latinx HK","# Latinx CoC","% Latinx HK","% Latinx CoC","# Black/AA HK","# Black/AA CoC","% Black/AA HK","% Black/AA CoC","# Asian HK","# Asian CoC","% Asian HK","% Asian CoC","# AIAN HK","# AIAN CoC","% AIAN HK","% AIAN CoC","# HI/PI HK","#HI/PI CoC","% HI/PI HK","% HI/PI CoC","# Multi HK","# Multi CoC","%Multi HK","%Multi CoC","# Unknown HK","# Unknown CoC","% Unknown HK","% Unknown CoC","Total Disabled (DA)","White DA","Latinx DA","Black DA","Asian DA ","AIAN DA","HI/PI DA","Multi DA","Unknown DA"]
[{"$f":"'Grantee Cert. + Project Status'!B5","v":0},{"$f":"'Grantee Cert. + Project Status'!B6","v":0},{"$f":"'Grantee Cert. + Project Status'!E5","v":0},{"$f":"'Grantee Cert. + Project Status'!B4","v":0},{"$f":"'4. Equity Strategies'!G15","v":0},{"$f":"'4. Equity Strategies'!C38","v":0},{"$f":"'4. Equity Strategies'!G17","v":0},{"$f":"'4. Equity Strategies'!G39","v":0},{"$f":"IFERROR(G2/E2,0)","v":0},{"$f":"IFERROR(H2/F2,0)","v":0},{"$f":"'4. Equity Strategies'!G19","v":0},{"$f":"'4. Equity Strategies'!G40","v":0},{"$f":"IFERROR(K2/$E$2,0)","v":0},{"$f":"IFERROR(L2/$E$2,0)","v":0},{"$f":"'4. Equity Strategies'!$G21","v":0},{"$f":"'4. Equity Strategies'!$G41","v":0},{"$f":"IFERROR(O2/$E$2,0)","v":0},{"$f":"IFERROR(P2/$E$2,0)","v":0},{"$f":"'4. Equity Strategies'!$G23","v":0},{"$f":"'4. Equity Strategies'!$G42","v":0},{"$f":"IFERROR(S2/$E$2,0)","v":0},{"$f":"IFERROR(T2/$E$2,0)","v":0},{"$f":"'4. Equity Strategies'!G25","v":0},{"$f":"'4. Equity Strategies'!$G43","v":0},{"$f":"IFERROR(W2/$E$2,0)","v":0},{"$f":"IFERROR(X2/$E$2,0)","v":0},{"$f":"'4. Equity Strategies'!G27","v":0},{"$f":"'4. Equity Strategies'!G44","v":0},{"$f":"IFERROR(AA2/$E$2,0)","v":0},{"$f":"IFERROR(AB2/$E$2,0)","v":0},{"$f":"'4. Equity Strategies'!G29","v":0},{"$f":"'4. Equity Strategies'!G45","v":0},{"$f":"IFERROR(AE2/$E$2,0)","v":0},{"$f":"IFERROR(AF2/$E$2,0)","v":0},{"$f":"'4. Equity Strategies'!G31","v":0},{"$f":"'4. Equity Strategies'!G46","v":0},{"$f":"IFERROR(AI2/$E$2,0)","v":0},{"$f":"IFERROR(AJ2/$E$2,0)","v":0},{"$f":"'4. Equity Strategies'!G16","v":0},{"$f":"'4. Equity Strategies'!G18","v":0},{"$f":"'4. Equity Strategies'!G20","v":0},{"$f":"'4. Equity Strategies'!G22","v":0},{"$f":"'4. Equity Strategies'!G24","v":0},{"$f":"'4. Equity Strategies'!G26","v":0},{"$f":"'4. Equity Strategies'!G28","v":0},{"$f":"'4. Equity Strategies'!G30","v":0},{"$f":"'4. Equity Strategies'!G32","v":0}]

{"sheet":"Risk Analysis Data","index":11,"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":"'Grantee Cert. + Project Status'!B5","v":0},{"$f":"Sponsor","v":0},{"$f":"'Grantee Cert. + Project Status'!B7","v":0},{"$f":"'Grantee Cert. + Project Status'!B8","v":0},{"$f":"'6. Report Summary'!M44","v":0},{"$f":"SUM('6. Report Summary'!M38:IM43)","v":0},{"$f":"'6. Report Summary'!M56","v":""},{"$f":"'6. Report Summary'!M23","v":""},{"$f":"SUM('6. Report Summary'!M24,'6. Report Summary'!M50,'6. Report Summary'!M51,'6. Report Summary'!M52,'6. Report Summary'!M53,'6. Report Summary'!M54,'6. Report Summary'!M55,'6. Report Summary'!M57,'6. Report Summary'!M58,'6. Report Summary'!M59,'6. Report Summary'!M60)","v":0},{"$f":"'6. Report Summary'!M63","v":0}]