{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Status & Certification","2. RFFs and Award Changes","3. Expenditure Report","4. Budget Details","5. Operating Costs","6. Report Summary","Drop-Down","DataTable","Risk Analysis Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":58,"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":"1. Status & Certification","index":0,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[14,1,14,2],[15,3,15,4],[2,0,2,4],[3,1,3,2],[9,1,9,2],[10,1,10,2],[13,1,13,2],[34,0,34,3],[35,0,35,3],[36,0,36,3],[38,0,38,3],[37,0,37,3],[33,0,33,4],[32,0,32,4],[28,0,28,1],[25,0,25,4],[26,0,26,4],[27,0,27,1],[29,0,29,4],[30,0,30,4],[16,1,16,2],[15,0,15,2],[12,1,12,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[11,1,11,2]]}
["FY24-25 Expenditure Report - Project Status & Grantee Certification"]
["Instructions: 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 2. RFFs & Award Changes, 3. Expenditure Report, and 4. Budget Details. 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:","Select One",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","Select One",null,"Geographic Region",{"$f":"IF('1. Status & Certification'!$B11>0,_xlfn.XLOOKUP('1. Status & Certification'!$B11,'Drop-Down'!$A$9:$A$67,'Drop-Down'!$B$9:$B$67,\"Not Found\",0),\" \")","v":""}]
["Number of Homekey Units \n(including Manager Units)",null,null,"Total Number of Units"]
["Unit Type","Select One",null,"Project Type","Select One"]
["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","Select One"]
[{"$f":"_xlfn.IFS(OR(C29=\"Fully Occupied and Operational\",C29=\"Interim to Perm - Fully Occupied and Operational\"),\"The Project is fully occupied and operational.  Including this tab, you are required to complete tabs 2. RFFs & Award Changes through 5. Operating Costs\",OR(C29=\"Construction not yet started\",C29=\"Construction Complete - Leasing Up\",C29=\"Under Construction\",C29=\"Under Construction (Occupied Offsite)\",C29=\"Interim to Perm - Under Construction\",C29=\"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 2. RFFs & Award Changes through 4. Budget Details of this report. Tab 5. Operating Costs is not required for this report\",C29=\"Select One\",\"\")","v":""}]
[{"$f":"IF(C29=\"Select One\",\"\",\"HCD will complete tab 6. Report Summary.\")","v":""}]
[]
["3. 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(C29=\"Fully Occupied and Operational\",C29=\"Interim to Perm - Fully Occupied and Operational\"),\"This Project is fully occupied and operational.  Including this Tab, Tabs 2. RFFs & Award Changes through 5. Operating Costs must be completed\",\"Project is not yet fully occupied and operational. Including this tab, Tab 2. RFFs & Award Changes through Tab 4. Budget Details has been completed, as required. Tab 5.Operating Costs is not required for this report\")","v":"Project is not yet fully occupied and operational. Including this tab, Tab 2. RFFs & Award Changes through Tab 4. Budget Details has been completed, as required. Tab 5.Operating Costs is not required for this report"},null,null,null,"Select One"]
["Grantees shall submit their first Fiscal Year Expenditure Report (FYER) to the Department the first Fiscal Year following Standard Agreement execution. Each FYER will be due no later than July 31 for the prior Fiscal Year of July 1 to June 30. \nGrantees will be required to continue reporting annually until 100% of their Capital and COSR awards have been expended. \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"]
["Supporting Documentation: Grantee has attached to this Report supporting documentation ",null,null,null,"Select One"]
["Signature of Preparer Agency Authorized Official (Electronic, Typed Only)\n(does not need to be Homekey Authorized Representative per resolution)",null,null,null,"Date"]

{"sheet":"2. RFFs and Award Changes","index":1,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,1,10],[9,1,9,2],[10,1,10,2],[7,1,7,10],[8,1,8,10],[2,7,2,10],[3,7,3,10],[4,7,4,10],[5,7,5,10],[2,2,2,5],[3,2,3,5],[4,2,4,5],[5,2,5,5],[31,1,31,2],[11,1,11,2],[34,1,34,2],[25,1,25,5],[26,1,26,5],[24,1,24,5],[15,1,15,2],[16,1,16,2],[30,1,30,10],[17,1,17,2],[18,1,18,2],[19,1,19,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[24,6,24,7],[22,1,22,10],[23,1,23,10],[27,8,27,10],[28,8,28,10],[29,1,29,10],[24,8,24,10],[25,6,25,7],[26,6,26,7],[25,8,25,10],[26,8,26,10],[27,1,27,5],[28,1,28,5],[27,6,27,7],[28,6,28,7],[35,1,35,2],[32,1,32,2],[33,1,33,2],[41,1,41,2],[39,1,39,2],[40,1,40,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[41,7,41,8],[41,9,41,10],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[31,7,31,8],[32,7,32,8],[31,9,31,10],[33,7,33,8],[34,7,34,8]]}
[null,"FY24-25 Expenditure Report - 2. RFFs and Award Changes"]
[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('1. Status & Certification'!B5=\"\",\"\",'1. Status & Certification'!B5)","v":""},null,null,null,"HK Round",{"$f":"IF('1. Status & Certification'!$E$4=\"Select One\",\"\",'1. Status & Certification'!$E$4)","v":""}]
[null,"Project Name",{"$f":"IF('1. Status & Certification'!E5=\"\",\"\",'1. Status & Certification'!E5)","v":""},null,null,null,"Grantee",{"$f":"IF('1. Status & Certification'!$B$6=\"\",\"\",'1. Status & Certification'!$B$6)","v":""}]
[null,"Co-Grantee 1",{"$f":"IF('1. Status & Certification'!B7=\"\",\"-\",'1. Status & Certification'!B7)","v":"-"},null,null,null,"Co-Grantee 2",{"$f":"IF('1. Status & Certification'!$B$8=\"\",\"-\",'1. Status & Certification'!$B$8)","v":"-"}]
[null,"Reporting Period",{"$f":"IF('1. Status & Certification'!B4=\"Select One\",\"\",'1. Status & Certification'!B4)","v":""},null,null,null,"Payee"]
[]
[null,"1. Disbursements Summary"]
[null,"Instructions: Please enter disbursed amounts by RFF number."]
[null,"Eligible Use",null,"Total Amount Disbursed \n(requested by RFF Form and received)","RFF 1","RFF 2","RFF 3","RFF 4","RFF 5","RFF 6","HCD Use Only "]
[null,"Acquisition of motels, hotels, hostels, or other sites and assets (pursuant to NOFA §201 i.)",null,{"$f":"SUM(E11:J11)","v":0},null,null,null,null,null,null,"Select One"]
[null,"Rehabilitation of motels, hotels, hostels, or other sites and assets (pursuant to NOFA §201 i.)",null,0,null,null,null,null,null,null,"Select One"]
[null,"Master leasing of properties (pursuant to NOFA §201 ii.)",null,0,null,null,null,null,null,null,"Select One"]
[null,"Conversion of units from nonresidential to residential (pursuant to NOFA §201 iii.)",null,0,null,null,null,null,null,null,"Select One"]
[null,"New construction of dwelling units (pursuant to NOFA §201 iv.)",null,0,null,null,null,null,null,null,"Select One"]
[null,"Purchase of affordability covenants and restrictions for units (pursuant to NOFA §201 v.)",null,0,null,null,null,null,null,null,"Select One"]
[null,"Relocation costs for individuals who are being displaced as a result of Homekey project (pursuant to NOFA §201 vi.)",null,0,null,null,null,null,null,null,"Select One"]
[null,"Capitalized operating subsidies for units purchased, converted or altered (not including Expedited Occupancy Bonus) (pursuant to NOFA §201 vi.)",null,0,null,null,null,null,null,null,"Select One"]
[null,"Bonus for Occupying Project 8 Months from Award Date  (pursuant to NOFA §201 vi.)",null,0,null,null,null,null,null,null,"Select One"]
[null,"TOTAL:",null,{"$f":"SUM(D11:D19)","v":0},0,0,0,0,0,0]
[]
[]
[null,"2. Changes to Original Award Amounts"]
[null,"Instructions: Please answer the questions below regarding the Homekey award amounts - whether there have been funds abated or disencumbered after Standard Agreement Execution.  If the answer is yes to either question, please enter the award amount abated or disencumbered in the table below."]
[null,"Question",null,null,null,null,"Grantee Response",null,"HCD Verification"]
[null,"1. Have any Homekey Funds been abated post-Standard Agreement execution? If yes, please enter the amount in the Fund Abated column in the table below.",null,null,null,null,"Select One",null,"Select One"]
[null,"2. Have any Homekey Funds been disencumbered post-Standard Agreement execution? If yes, please enter the amount(s) in the Funds Disecnumbered column in the table below.",null,null,null,null,"Select One",null,"Select One"]
[null,"3. [Round 2 Only] Was the Occupancy Bonus Award forfeited? If yes, please include the forfeited amount in the Funds Disencumbered column in the table below, and select Yes to question 2 above.",null,null,null,null,"Select One",null,"Select One"]
[null,"4. [Round 2 Only] Has a Flex Form been submitted and approved by the Department? If yes, please enter the flexed amounts in the Flex column in the table below.",null,null,null,null,"Select One",null,"Select One"]
[null,"3. Original Award Amounts and Award Changes"]
[null,"Instructions: Please enter the Original Award amounts by eligible use category as they appear in the Standard Agreement.  Then please enter amounts if appicable - if a Flex Form has been submitted and approved, if funds have been abated, or if funds have been disencumbered"]
[null,"Eligible Use",null,"Original SA Award Amount","Flex SA Amount \n[R2 Only]","Amount of Funds Abated","Amount of Funds Disencumbered","Remaining Award Amount",null,"HCD Use Only"]
[null,"Acquisition of motels, hotels, hostels, or other sites and assets (pursuant to NOFA §201 i.)",null,null,null,null,null,{"$f":"IF(E33=\"\",D33-F33-G33,E33-F33-G33)","v":0},null,"Select One"]
[null,"Rehabilitation of motels, hotels, hostels, or other sites and assets (pursuant to NOFA §201 i.)",null,null,null,null,null,{"$f":"IF(E34=\"\",D34-F34-G34,E34-F34-G34)","v":0},null,"Select One"]
[null,"Master leasing of properties (pursuant to NOFA §201 ii.)",null,null,null,null,null,0,null,"Select One"]
[null,"Conversion of units from nonresidential to residential (pursuant to NOFA §201 iii.)",null,null,null,null,null,0,null,"Select One"]
[null,"New construction of dwelling units (pursuant to NOFA §201 iv.)",null,null,null,null,null,0,null,"Select One"]
[null,"Purchase of affordability covenants and restrictions for units (pursuant to NOFA §201 v.)",null,null,null,null,null,0,null,"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,0,null,"Select One"]
[null,"Capitalized operating subsidies for units purchased, converted or altered (not including Expedited Occupancy Bonus) (pursuant to NOFA §201 vi.)",null,null,null,null,null,0,null,"Select One"]
[null,"Bonus for Occupying Project 8 Months from Award Date \n(if forfeited, please include the amount in the Disencumbered column) (pursuant to NOFA §201 vi.)",null,null,"Bonus Awards Cannot be Flexed",null,null,{"$f":"D41-G41-F41","v":0},null,"Select One"]
[null,"Totals",null,{"$f":"SUM(D33:E41)","v":0},null,{"$f":"SUM(F33:F41)","v":0},{"$f":"SUM(G33:G41)","v":0},{"$f":"SUM(H33:I41)","v":0}]

{"sheet":"3. Expenditure Report","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,1,17,7],[18,1,25,8],[18,9,25,9],[0,1,0,9],[1,1,1,9],[2,1,2,9],[3,1,3,9],[16,1,16,9]]}
[null,"FY24-25 Expenditure Report - 3. Expenditure Report "]
[null,"Instructions: Please complete this tab and include proof of expenditures as instructed. This tab should be completed for every project."]
[null,"1. Proof of Expenditures Summary - Current Reporting Period"]
[null,"Instructions: Enter the amounts of Homekey funds expended this reporting period, as well as the current total expended across all reporting periods by Fiscal Year.  For any amount expended this reporting period, please proivde proof of expenditures in two methods: 1) General Ledger for FY24-25, 2) General Ledger for January 1, 2025 - June, 30, 2025. These two ledgers will help our program transition from Calendar year to Fiscal Year reporting."]
[null,"Eligible Use","FY 20-21\n(Jul 2020 - Jun 2021)","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)","Totals","Proof of Expenditures Submitted?","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":"SUM(C6:G6)","v":0},"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,0,"Select One","Select One"]
[null,"Master leasing of properties (pursuant to NOFA §201 ii.)",null,null,null,null,null,0,"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"]
[null,"New construction of dwelling units (pursuant to NOFA §201 iv.)",null,null,null,null,null,0,"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"]
[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,0,"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,0,"Select One","Select One"]
[null,"Bonus for Occupying Project 8 Months from Award Date (if applicable): (pursuant to NOFA §201 vi.)",null,null,null,null,null,0,"Select One","Select One"]
[null,"TOTAL:",{"$f":"SUM(C6:C14)","v":0},{"$f":"SUM(D6:D14)","v":0},{"$f":"SUM(E6:E14)","v":0},{"$f":"SUM(F6:F14)","v":0},{"$f":"SUM(ABS(G6:G14))","v":0},{"$f":"SUM((H6:H14))","v":0}]
[]
[null,"2. Changes to Previously Reported Expenditure Amounts"]
[null,"Have there been changes to previously reported expenditure amounts (either in prior Annual Reports, Milestone Completion Forms, etc.)? If yes, please provide a narrative explanation below.",null,null,null,null,null,null,"Select One","Select One"]
[null,null,null,null,null,null,null,null,null,"Select One"]

{"sheet":"4. Budget Details","index":3,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[26,5,28,11],[14,3,14,4],[1,1,1,11],[0,1,0,11],[12,3,12,4],[13,3,13,4],[14,1,14,2],[25,8,25,9],[25,10,25,11],[3,1,3,11],[2,1,2,11],[4,1,4,7],[12,5,14,11],[18,3,18,6],[18,7,18,8],[17,1,17,8],[9,3,9,4],[13,1,13,2],[8,1,8,2],[8,3,8,4],[6,10,6,11],[6,1,6,2],[6,3,6,4],[10,10,10,11],[10,1,10,2],[10,3,10,4],[10,8,10,9],[9,1,9,2],[11,1,11,2],[11,3,11,4],[11,8,11,9],[12,1,12,2],[4,8,4,11],[8,8,8,9],[8,10,8,11],[9,8,9,9],[9,10,9,11],[5,10,5,11],[6,8,6,9],[7,10,7,11],[5,1,5,2],[5,3,5,4],[5,8,5,9],[7,1,7,2],[7,3,7,4],[7,8,7,9],[20,8,20,9],[17,9,17,11],[18,1,18,2],[18,9,18,11],[19,1,19,2],[16,1,16,11],[11,10,11,11],[24,10,24,11],[23,8,23,9],[19,3,19,4],[19,8,19,9],[19,10,19,11],[21,8,21,9],[21,10,21,11],[22,8,22,9],[22,10,22,11],[23,10,23,11],[20,10,20,11],[24,8,24,9],[20,1,20,2],[20,3,20,4],[27,1,27,2],[27,3,27,4],[28,1,28,2],[28,3,28,4],[21,1,21,2],[21,3,21,4],[22,1,22,2],[22,3,22,4],[24,1,24,2],[24,3,24,4],[23,1,23,2],[23,3,23,4],[26,1,26,2],[26,3,26,4],[25,1,25,2],[25,3,25,4]]}
[null,"FY24-25 Expenditure Report - 4. Budget Details "]
[null,"Instructions: Please complete this tab and include proof of expenditures as instructed. This tab should be completed for every project."]
[null,"1. 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 drop-downs to note whether or not the funding source and amounts are the same as they appear in Exhibit E of the Standard Agreement, and add 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,null,null,"Select One"]
[null,"Source & Amount in Standard Agreement?",null,"Source of Funds",null,"Original Amount","New Amount","Lien Position","Type of Match",null,"Notes"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"TOTAL FROM NON-HOMEKEY SOURCES:",null,{"$f":"SUM(IF(G7=\"\",F7,G7))+SUM(IF(G8=\"\",F8,G8))+SUM(IF(G9=\"\",F9,G9))+SUM(IF(G10=\"\",F10,G10))+SUM(IF(G11=\"\",F11,G11))+SUM(IF(G12=\"\",F12,G12))","v":0},null,"HCD Notes:"]
[null,"TOTAL FROM HOMEKEY SOURCES:",null,{"$f":"SUM('2. RFFs and Award Changes'!H33:H39)","v":0}]
[null,"TOTAL DEVELOPMENT COST (Non-Homekey + Homekey Capital)",null,{"$f":"SUM(D14)+(D13)","v":0}]
[]
[null,"2. 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,null,null,"Select One"]
[null,"Number of Project-Based Vouchers (PBVs) in Project:",null,null,null,null,null,"Total Value of PBVs:"]
[null,"Source & Amount in Standard Agreement?",null,"Source of Funds",null,"Original Amount","New Amount","Lien Position","Type of Match",null,"Notes"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"Select One",null,null,null,null,null,null,"Select One"]
[null,"TOTAL FROM NON-HOMEKEY SOURCES:",null,{"$f":"SUM(IF(G21=\"\",F21,G21))+SUM(IF(G22=\"\",F22,G22))+SUM(IF(G23=\"\",F23,G23))+SUM(IF(G24=\"\",F24,G24))+SUM(IF(G25=\"\",F25,G25))+SUM(IF(G26=\"\",F26,G26))+J19","v":0},null,"HCD Notes:"]
[null,"TOTAL FROM HOMEKEY SOURCES:",null,{"$f":"SUM('2. RFFs and Award Changes'!H40:H41)","v":0}]
[null,"TOTAL OPERATING FUNDS (Non-Homekey + Homekey Operating)",null,{"$f":"SUM(D27:E28)","v":0}]

{"sheet":"5. Operating Costs","index":4,"n_rows":98,"n_cols":8,"rows_kept":98,"cut":false,"hidden":true,"merged":[[96,1,96,3],[88,1,88,3],[0,1,0,7],[1,1,1,7],[98,1,103,7],[97,1,97,7],[91,1,91,7],[96,4,96,7],[76,2,76,3],[95,6,95,7],[95,1,95,5],[93,1,93,5],[93,6,93,7],[94,1,94,5],[94,6,94,7],[92,1,92,7],[87,1,87,3],[61,2,61,3],[66,2,66,3],[55,2,55,3],[56,2,56,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[70,2,70,3],[85,2,85,3],[86,2,86,3],[72,2,72,3],[84,2,84,3],[6,1,6,7],[10,2,10,3],[31,1,31,7],[7,1,7,7],[8,2,8,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[11,2,11,3],[12,2,12,3],[20,2,20,3],[28,1,28,3],[17,2,17,3],[77,2,77,3],[73,2,73,3],[74,2,74,3],[81,2,81,3],[82,2,82,3],[78,2,78,3],[83,2,83,3],[75,2,75,3],[79,2,79,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],[43,2,43,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[65,2,65,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[44,2,44,3],[50,2,50,3],[52,2,52,3],[53,2,53,3],[47,2,47,3],[54,2,54,3],[42,2,42,3],[49,2,49,3],[48,2,48,3],[51,1,51,7],[57,1,57,7],[46,2,46,3],[69,2,69,3],[71,1,71,7],[80,1,80,7],[19,1,19,7],[9,1,9,7],[21,2,21,3],[32,1,32,7],[37,2,37,3],[38,2,38,3],[33,2,33,3],[35,2,35,3],[36,2,36,3],[34,1,34,7],[68,2,68,3],[67,2,67,3],[45,2,45,3]]}
[null,"FY24-25 Expenditure Report - 5. Operating Costs"]
[null,"Instructions: Please complete this tab only if the project is occupied and operational."]
[null,"Reporting Period:",null,{"$f":"IF('1. Status & Certification'!B4=\"Select One\",\"\",'1. Status & Certification'!B4)","v":""},null,"Project Name:",{"$f":"IF('1. Status & Certification'!E5=\"\",\"\",'1. Status & Certification'!E5)","v":""}]
[null,"Prepared By:",null,{"$f":"IF('1. Status & Certification'!B9=\"\",\"\",'1. Status & Certification'!B9)","v":""},null,"Project County:",{"$f":"IF('1. Status & Certification'!B11=\"Select One\",\"\",'1. Status & Certification'!B11)","v":""}]
[null,"Homekey Units (including manager units)",null,{"$f":"IF('1. Status & Certification'!B12:B12=\"\",\"\",'1. Status & Certification'!B12:B12)","v":""},null,"Total Units:",{"$f":"IF('1. Status & Certification'!E12:E12=\"\",\"\",'1. Status & Certification'!E12:E12)","v":""}]
[]
[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) If Accrued Interest was generated from Homekey Funds, please include the amount in column E.\n3) 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,"Rent Revenue:"]
[null,null,"Rent Revenue - Gross Potential",null,null,0,{"$f":"E11+F11","v":0}]
[null,null,"Vacancy Loss Rate",null,null,0,{"$f":"-(F12*F11)","v":0}]
[null,null,"Actual Rent Income",null,null,{"$f":"F11-(F11*F12)","v":0},{"$f":"E13+F13","v":0}]
[null,null,"Tenant Assistance Payments",null,null,0,{"$f":"E14+F14","v":0}]
[null,null,"Rent Revenue - Stores and Commercial",null,null,0,0]
[null,null,"Garage and Parking Spaces",null,null,0,0]
[null,null,"Flexible Subsidy Revenue",null,null,0,0]
[null,null,"Miscellaneous Rent Revenue",null,null,0,0]
[null,null,"Total Rent Revenue",null,null,{"$f":"SUM(F13:F18)","v":0},{"$f":"SUM(G13:G18)","v":0}]
[null,"Operating Funding Sources:"]
[null,null,"Amount of Homekey Funds Expended this Period",null,{"$f":"'3. Expenditure Report'!G13","v":0},null,{"$f":"E21+F21","v":0}]
[null,null,"Amount of Accrued Interest from Homekey Funds"]
[null,null,"Funding Source 1:","Please Enter Funding Source",null,0,{"$f":"E23+F23","v":0}]
[null,null,"Funding Source 2:","Please Enter Funding Source",null,0,0]
[null,null,"Funding Source 3:","Please Enter Funding Source",null,0,0]
[null,null,"Funding Source 4:","Please Enter Funding Source",null,0,0]
[null,null,"Funding Source 5:","Please Enter Funding Source",null,0,0]
[null,null,"Total Operating Funding",null,{"$f":"SUM(E21:E27)","v":0},{"$f":"SUM(F21:F27)","v":0},{"$f":"SUM(G21:G27)","v":0}]
[null,"Total Annual Operating Sources",null,null,{"$f":"E28","v":0},{"$f":"F28+F19","v":0},{"$f":"E29+F29","v":0}]
[]
[]
[null,"2. Annual Operating Expenditures"]
[null,"Instructions: Please fill out Operating Subsidy expenditures in this reporting period by category in columns E (for Homekey incoming funds) and F (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,"Administrative Expenses:"]
[null,null,"Conventions and Meetings",null,0,0,{"$f":"E36+F36","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(E36:E50)","v":0},{"$f":"SUM(F36:F50)","v":0},{"$f":"SUM(G36:G50)","v":0}]
[null,"Utilities:"]
[null,null,"Electricity",null,0,0,{"$f":"E53+F53","v":0}]
[null,null,"Water",null,0,0,{"$f":"E54+F54","v":0}]
[null,null,"Gas",null,0,0,0]
[null,null,"Sewer",null,0,0,0]
[null,null,"Total Utilities Expenses",null,{"$f":"SUM(E53:E56)","v":0},{"$f":"SUM(F53:F56)","v":0},{"$f":"SUM(G53:G56)","v":0}]
[null,"Operating and Maintenance Expenses:"]
[null,null,"Payroll",null,0,0,{"$f":"E59+F59","v":0}]
[null,null,"Supplies",null,0,0,{"$f":"E60+F60","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(E59:E70)","v":0},{"$f":"SUM(F59:F70)","v":0},{"$f":"SUM(G59:G70)","v":0}]
[null,"Taxes and Insurance:"]
[null,null,"Real Estate Taxes",null,0,0,{"$f":"E73+F73","v":0}]
[null,null,"Payroll Taxes (Project's Share)",null,0,0,{"$f":"E74+F74","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(E73:E79)","v":0},{"$f":"SUM(F73:F79)","v":0},{"$f":"SUM(G73:G79)","v":0}]
[null,"Supportive Services Costs:"]
[null,null,"Staff Supervisors Salaries",null,0,0,{"$f":"E82+F82","v":0}]
[null,null,"On-site Services Coordinator Salaries and Benefits",null,0,0,{"$f":"E83+F83","v":0}]
[null,null,"On-site Other Supportive Services Staff Salaries",null,0,0,{"$f":"E84+F84","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(E82:E86)","v":0},{"$f":"SUM(F82:F86)","v":0},{"$f":"SUM(G82:G86)","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,"Total Cost of Operations",null,null,{"$f":"(E51+E57+E71+E80+E87)","v":0},{"$f":"(F51+F57+F71+F80+F87)","v":0},{"$f":"(G51+G57+G71+G80+G87)","v":0}]
[]
[]
[null,"3. Operating Costs - Cash Flow"]
[null,"Cash Flow"]
[null,"Total Annual Operating Sources - All Sources",null,null,null,null,{"$f":"G29","v":0}]
[null,"Total Cost of Operations - All Sources",null,null,null,null,{"$f":"G89","v":0}]
[null,"(Total Operating Sources) - (Total Operating Expenditures) = Cash Flow this Reporting Period",null,null,null,null,{"$f":"G29-G89","v":0}]
[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":"6. Report Summary","index":5,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[54,1,54,3],[54,4,54,6],[45,1,45,3],[48,1,48,3],[49,1,49,3],[49,4,49,5],[46,1,46,3],[48,4,48,5],[47,1,47,3],[53,4,53,6],[46,6,46,10],[47,6,47,10],[48,6,48,10],[53,1,53,3],[55,1,55,3],[55,4,55,6],[34,1,34,10],[56,7,56,10],[56,1,56,3],[56,4,56,6],[55,7,55,10],[47,4,47,5],[53,7,53,10],[54,7,54,10],[44,1,44,3],[45,4,45,5],[52,1,52,10],[45,6,45,10],[49,6,49,10],[46,4,46,5],[44,4,44,5],[43,1,43,10],[44,6,44,10],[30,1,30,3],[31,1,31,3],[30,4,30,5],[31,4,31,5],[33,1,33,3],[33,4,33,5],[42,1,42,10],[39,6,39,10],[40,1,40,3],[40,4,40,5],[35,6,35,10],[36,6,36,10],[36,1,36,3],[35,4,35,5],[36,4,36,5],[35,1,35,3],[39,1,39,3],[39,4,39,5],[40,6,40,10],[38,1,38,10],[31,6,31,10],[33,6,33,10],[11,2,11,5],[27,6,27,10],[11,6,11,10],[12,6,12,10],[28,4,28,5],[14,1,14,10],[29,4,29,5],[26,1,26,10],[32,1,32,10],[28,6,28,10],[29,6,29,10],[30,6,30,10],[28,1,28,3],[29,1,29,3],[6,1,6,10],[7,6,7,10],[8,6,8,10],[9,6,9,10],[10,6,10,10],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[12,2,12,5],[27,1,27,3],[27,4,27,5],[2,8,2,10],[3,6,3,10],[4,6,4,10],[1,1,1,10],[0,1,0,10],[4,2,4,4],[2,4,2,6],[3,2,3,4]]}
[null,"FY24-FY25 Expenditure 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('1. Status & Certification'!B5=\"\",\"\",'1. Status & Certification'!B5)","v":""},"Project Name",{"$f":"IF('1. Status & Certification'!E5=\"\",\"\",'1. Status & Certification'!E5)","v":""},null,null,"HK Round",{"$f":"IF('1. Status & Certification'!E4=\"Select One\",\"\",'1. Status & Certification'!E4)","v":""}]
[null,"Grantee",{"$f":"IF('1. Status & Certification'!B6=\"\",\"\",'1. Status & Certification'!B6)","v":""},null,null,"Reporting Period",{"$f":"IF('1. Status & Certification'!B4=\"Select One\",\"\",'1. Status & Certification'!B4)","v":""}]
[null,"Co-Grantee 1",{"$f":"IF('1. Status & Certification'!B7=\"\",\"-\",'1. Status & Certification'!B7)","v":"-"},null,null,"Co-Grantee 2",{"$f":"IF('1. Status & Certification'!B8=\"\",\"-\",'1. Status & Certification'!B8)","v":"-"}]
[]
[null,"Fiscal Year Expenditure Report Review Summary"]
[null,"Review Category","Findings",null,null,null,"Action(s) Required"]
[null,"1. Status & Certification"]
[null,"2. RFFs & Award Changes"]
[null,"3. Expenditure Reports"]
[null,"4. Budget Details"]
[null,"5. Operating Costs"]
[]
[null,"2 & 3. Disbursements, Award Changes, and Expenditures"]
[null,"Eligible Use","Total Original Award Amounts","Total Amount Disbursed","Total Amount Undisbursed","Total Award Amounts Flexed \n[R2 Only]","Total Award Abated","Total Award Disencumbered","Total Adjusted Award Amounts","Total Award Expended","Total Remaining Award Unexpended"]
[null,"Acquisition of motels, hotels, hostels, or other sites and assets ",{"$f":"'2. RFFs and Award Changes'!D33","v":0},{"$f":"'2. RFFs and Award Changes'!D11","v":0},{"$f":"C17-D17","v":0},{"$f":"'2. RFFs and Award Changes'!E33","v":0},{"$f":"'2. RFFs and Award Changes'!F33","v":0},{"$f":"'2. RFFs and Award Changes'!G33","v":0},{"$f":"'2. RFFs and Award Changes'!H33","v":0},{"$f":"'3. Expenditure Report'!H6","v":0},{"$f":"'2. RFFs and Award Changes'!H33-J17","v":0}]
[null,"Rehabilitation of motels, hotels, hostels, or other sites and assets",{"$f":"'2. RFFs and Award Changes'!D34","v":0},{"$f":"'2. RFFs and Award Changes'!D12","v":0},{"$f":"C18-D18","v":0},{"$f":"'2. RFFs and Award Changes'!E34","v":0},{"$f":"'2. RFFs and Award Changes'!F34","v":0},{"$f":"'2. RFFs and Award Changes'!G34","v":0},{"$f":"'2. RFFs and Award Changes'!H34","v":0},{"$f":"'3. Expenditure Report'!H7","v":0},{"$f":"'2. RFFs and Award Changes'!H34-J18","v":0}]
[null,"Master leasing of properties",{"$f":"'2. RFFs and Award Changes'!D35","v":0},{"$f":"'2. RFFs and Award Changes'!D13","v":0},0,{"$f":"'2. RFFs and Award Changes'!E35","v":0},{"$f":"'2. RFFs and Award Changes'!F35","v":0},{"$f":"'2. RFFs and Award Changes'!G35","v":0},{"$f":"'2. RFFs and Award Changes'!H35","v":0},{"$f":"'3. Expenditure Report'!H8","v":0},{"$f":"'2. RFFs and Award Changes'!H35-J19","v":0}]
[null,"Conversion of units from nonresidential to residential",{"$f":"'2. RFFs and Award Changes'!D36","v":0},{"$f":"'2. RFFs and Award Changes'!D14","v":0},0,{"$f":"'2. RFFs and Award Changes'!E36","v":0},{"$f":"'2. RFFs and Award Changes'!F36","v":0},{"$f":"'2. RFFs and Award Changes'!G36","v":0},{"$f":"'2. RFFs and Award Changes'!H36","v":0},{"$f":"'3. Expenditure Report'!H9","v":0},{"$f":"'2. RFFs and Award Changes'!H36-J20","v":0}]
[null,"New construction of dwelling units",{"$f":"'2. RFFs and Award Changes'!D37","v":0},{"$f":"'2. RFFs and Award Changes'!D15","v":0},0,{"$f":"'2. RFFs and Award Changes'!E37","v":0},{"$f":"'2. RFFs and Award Changes'!F37","v":0},{"$f":"'2. RFFs and Award Changes'!G37","v":0},{"$f":"'2. RFFs and Award Changes'!H37","v":0},{"$f":"'3. Expenditure Report'!H10","v":0},{"$f":"'2. RFFs and Award Changes'!H37-J21","v":0}]
[null,"Purchase of affordability covenants and restrictions for units",{"$f":"'2. RFFs and Award Changes'!D38","v":0},{"$f":"'2. RFFs and Award Changes'!D16","v":0},0,{"$f":"'2. RFFs and Award Changes'!E38","v":0},{"$f":"'2. RFFs and Award Changes'!F38","v":0},{"$f":"'2. RFFs and Award Changes'!G38","v":0},{"$f":"'2. RFFs and Award Changes'!H38","v":0},{"$f":"'3. Expenditure Report'!H11","v":0},{"$f":"'2. RFFs and Award Changes'!H38-J22","v":0}]
[null,"Relocation costs for individuals who are being displaced as a result of Homekey project",{"$f":"'2. RFFs and Award Changes'!D39","v":0},{"$f":"'2. RFFs and Award Changes'!D17","v":0},0,{"$f":"'2. RFFs and Award Changes'!E39","v":0},{"$f":"'2. RFFs and Award Changes'!F39","v":0},{"$f":"'2. RFFs and Award Changes'!G39","v":0},{"$f":"'2. RFFs and Award Changes'!H39","v":0},{"$f":"'3. Expenditure Report'!H12","v":0},{"$f":"'2. RFFs and Award Changes'!H39-J23","v":0}]
[null,"Capitalized operating subsidies for units purchased, converted or altered (not including Expedited Occupancy Bonus)",{"$f":"'2. RFFs and Award Changes'!D40","v":0},{"$f":"'2. RFFs and Award Changes'!D18","v":0},0,{"$f":"'2. RFFs and Award Changes'!E40","v":0},{"$f":"'2. RFFs and Award Changes'!F40","v":0},{"$f":"'2. RFFs and Award Changes'!G40","v":0},{"$f":"'2. RFFs and Award Changes'!H40","v":0},{"$f":"'3. Expenditure Report'!H13","v":0},{"$f":"'2. RFFs and Award Changes'!H40-J24","v":0}]
[null,"Bonus for Occupying Project 8 Months from Award Date",{"$f":"'2. RFFs and Award Changes'!D41","v":0},{"$f":"'2. RFFs and Award Changes'!D19","v":0},0,"Bonus Award Amounts are Ineligible to Flex",{"$f":"'2. RFFs and Award Changes'!F41","v":0},{"$f":"'2. RFFs and Award Changes'!G41","v":0},{"$f":"'2. RFFs and Award Changes'!H41","v":0},{"$f":"'3. Expenditure Report'!H14","v":0},{"$f":"'2. RFFs and Award Changes'!H41-J25","v":0}]
[null,"Totals",{"$f":"SUM(C17:C25)","v":0},{"$f":"SUM(D17:D25)","v":0},{"$f":"SUM(E17:E25)","v":0},0,{"$f":"SUM(G17:G25)","v":0},0,0,0,0]
[null,"2.2 - Changes to Original Award Amounts"]
[null,"Question",null,null,"HCD Certification",null,"HCD Notes"]
[null,"1. Did the project have funds abated?",null,null,"Select One",null,null,null,null,null,null,null,{"$f":"IF(E29=\"Yes\",10,\"\")","v":""},10]
[null,"2. Did the project have funds disencumbered?",null,null,"Select One",null,null,null,null,null,null,null,{"$f":"IF(E30=\"Yes\",10,\"\")","v":""},10]
[null,"3. Did the Grantee accurately report on the status of the Bonus Award for Occupancy?",null,null,"Select One"]
[null,"4. Did the Grantee accurately report on any funds flexed?",null,null,"Select One"]
[null,"3.1 - Proof of Expenditures Summary - Current Reporting Period"]
[null,"5. 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(E34=\"No\",20,\"\")","v":""},20]
[null,"3.2 - Changes to Previously Reported Expenditure Amounts"]
[null,"6. Did the Grantee report that previously reported expenditures have changed?",null,null,"Select One",null,null,null,null,null,null,null,{"$f":"IF(E36=\"Yes - Grantee Reported Change\",5,\"\")","v":""},5]
[null,"7. If there amounts of expenditures reported changed, did Grantee provide an adequate explanation?",null,null,"Select One",null,null,null,null,null,null,null,{"$f":"IF(E37=\"No\",20,\"\")","v":""},20]
[]
[null,"4. Budget Details"]
[null,"8. Do the Sources of Funds listed in section 1. Total Development Costs and Non-Homekey Sources align with the Standard Agreement or a previously approved Budget Detail Adjustment Review Request (BAR)? If No, submission of a BAR form is required",null,null,"Select One",null,null,null,null,null,null,null,{"$f":"IF(E40=\"No\",5,\"\")","v":""},5]
[null,"9. Do the Sources of Funds listed in section 2. Total Operating Non-Homekey Sources align with the Standard Agreement or a previously approved Budget Detail Adjustment Request (BAR)? If No, Submissi onf a BAR form is required",null,null,"Select One",null,null,null,null,null,null,null,{"$f":"IF(E41=\"No\",5,\"\")","v":""},5]
[]
[null,"5. Operating Costs"]
[null,"5.3. - Operating Costs - Cash Flow"]
[null,"Category",null,null,"Amount",null,"HCD Notes"]
[null,"Operating Sources  - This Reporting Period",null,null,{"$f":"'5. Operating Costs'!G94:G94","v":0}]
[null,"Operating Expenditures - This Reporting Period",null,null,{"$f":"'5. Operating Costs'!G89","v":0}]
[null,"Available Cashflow - This Reporting Period",null,null,{"$f":"'5. Operating Costs'!G96:G96","v":0}]
[null,"Explanation for positive or negative cash flow",null,null,{"$f":"IF('5. Operating Costs'!E97:E97=\"\",\"\",'5. Operating Costs'!E97:E97)","v":""}]
[null,"10. Is the explanation for positive or negative cash flow acceptable?",null,null,"Select One",null,null,null,null,null,null,null,{"$f":"IF(E50=\"No\",10,\"\")","v":""},10]
[]
[]
[null,"6. Certification",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M15:M52)","v":0}]
[null,"Risk Assessment Score \n(over 50 Requires Section Chief Review)",null,null,{"$f":"M53","v":0},null,null,{"$f":"IF(E54>=50,\"Section Chief Signature Required\",\"\")","v":""},null,null,null,null,"max",{"$f":"SUM(N29:N53)","v":85}]
[null,"MGM Representative:",null,null,"Enter Name to Sign",null,null,"Enter Date to Sign"]
[null,"MGM Manager:",null,null,"Enter Name to Sign",null,null,"Enter Date to Sign"]
[null,"MGM Section Chief (if applicable):",null,null,"Enter Name to Sign",null,null,"Enter Date to Sign"]

{"sheet":"Drop-Down","index":6,"n_rows":189,"n_cols":3,"rows_kept":189,"cut":false,"hidden":true,"merged":[]}
["Reporting Period"]
["Select One"]
["July 1, 2024 - June 30, 2025 \n(Report Due July 31, 2025)"]
["July 1, 2025 - June 30, 2026 \n(Report Due July 31, 2026)"]
["July 1, 2026 - June 30, 2027 \n(Report Due July 31, 2027)"]
["July 1, 2027 - June 30, 2028 \n(Report Due July 31, 2028)"]
["July 1, 2028 - June 30, 2029 \n(Report Due July 31, 2029)"]
["Counties","Geographic Region"]
["Select One",{"$f":"\"\"","v":""}]
["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"]
["HCD Certification - Tabs 2, 3, and 6. Report Summary - 2.2 - 5"]
["Select One"]
["Yes"]
["No"]
["N/A"]
["Unit Type"]
["Select One"]
["Interim"]
["Permanent"]
["Interim to Perm."]
["Mix of Interim & Perm."]
["Standard Agreement Matching Fund Source Status"]
["Select One"]
["1. Original Source and Amount"]
["2. Original Source - Amount Increased"]
["3. Original Source - Amount Decreased"]
["4. New Source"]
["HCD Certification - Tab 1"]
["Select One"]
["No Findings"]
["HCD Corrected - Grantee to Contest if Needed"]
["Finding - Grantee Correction Required"]
["4. Budget Details - BAR"]
["Select One"]
["Yes - No BAR Form Submitted"]
["Yes - BAR Form under HCD Review"]
["No - No Changes from SA or Approved BAR"]
["3.2 - Changes to Previously Reported Expenditure Amounts"]
["Select One"]
["Yes - Grantee Reported Change"]
["No - No Change in Previous Reporting"]

{"sheet":"DataTable","index":7,"n_rows":2,"n_cols":170,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Reporting Period","HK Round","HCD Contract Number","Project Name","Sponsor Name","Sponsor Type","Project County","Geographic Region","Confidential Address?","Project Address","APN 1","Project Address 2 (if applicable)","APN 2 (if applicable)","Project Address 3 (if applicable)","APN 3 (if applicable)","Project Address 4 (if applicable)","APN 4 (if applicable)","Project Address 5 (if applicable)","APN 5 (if applicable)","Project Address 6 (if applicable)","APN 6 (if applicable)","Project Address 7 (if applicable)","APN 7 (if applicable)","Cosponsor1 Name","Cosponsor1 Type","Cosponsor2 Name","Cosponsor2 Type","Preparer Name","Preparer Title","Preparer Phone #","Preparer Email","HCD Rep","Overall Site Status","Number of HK Units (including Manger Units)","Total Number of Units","Unit Type","Project Type","Payee","Total HCD Award","Original Award - Capital","Original Award - COSR Awarded","Exp. Occupancy Bonus","Exp Occupancy Forfeited?","Original $ Award Acquisition","Original $ Award 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","Flexed $ Award 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 ","Abated $ Award Acquisition","Abated $ Award Rehab","Abated $ Award on Master Leasing of Properties","Abated $ Award on Conversion of NonRes to Res","Abated $ Award New Const.","Abated $ Award on Purchase of Aff. Covenants","Abated $ Award on Relocation","Abated $ Award COSR ","Disencumbered $ Award Acquisition","Disencumbered $ Award Rehab","Disencumbered $ Award on Master Leasing of Properties","Disencumbered $ Award on Conversion of NonRes to Res","Disencumbered $ Award New Const.","Disencumbered $ Award on Purchase of Aff. Covenants","Disencumbered $ Award on Relocation","Disencumbered $ Award COSR ","Total Disbursed.","Undisbursed Funds","Total Expended All Periods","Unexpended Funds","Capital Expended - FY20-21","Capital Expended - FY21-22","Capital Expended - FY22-23","Capital Expended - FY23-24","Capital Expended - FY24-25","Capital Expended - Total","Operating Expended - FY20-21","Operating Expended - FY21-22","Operating Expended - FY22-23","Operating Expended - FY23-24","Operating Expended - FY24-25","Capital Match Source 1","Cap Match 1 Amount - Original","Cap Match 1 Amount - New","Capital Match Source 2","Cap Match 2 Amount - Original","Cap Match 2 Amount - New","Capital Match Source 3","Cap Match 3 Amount - Original","Cap Match 3 Amount - New","Capital Match Source 4","Cap Match 4 Amount - Original","Cap Match 4 Amount - New","Capital Match Source 5","Cap Match 5 Amount - Original","Cap Match 5 Amount - New","Capital Match Source 6","Cap Match 6 Amount - Original","Cap Match 6 Amount - New","Total Acquisition Match - Original","Total Rehab Match - Original","Total Relo Match - Original","Total Other Capital Match - Original","Total Acquisition Match - New","Total Rehab Match - New","Total Relo Match - New","Total Other Capital Match - New","Total Non-HK Matching Sources - Capital","Total Cap Dev Cost","# PBVS","$ PBVS","Operating Match Source 1","Operating Match Amount 1 - Original","Operating Match Amount 1 - New","Operating Match Source 2","Operating Match Amount 2 - Original","Operating Match Amount 2 - New","Operating Match Source 3","Operating Match Amount 3 - Original","Operating Match Amount 3 - New","Operating Match Source 4","Operating Match Amount 4 - Original","Operating Match Amount 4 - New","Operating Match Source 5","Operating Match Amount 5 - Original","Operating Match Amount 5 - New","Operating Match Source 6","Operating Match Amount 6 - Original","Operating Match Amount 6 - New","Total COSR Match","Total Other Match","Total Non-HK Matching Sources - Operating","Cost Per Unit","Actual Rent Income","Accrued Interest on Homekey Funds","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","Risk Assessment Score"]
[{"$f":"'1. Status & Certification'!B4","v":"Select One"},{"$f":"'1. Status & Certification'!E4","v":"Select One"},{"$f":"'1. Status & Certification'!B5","v":0},{"$f":"'1. Status & Certification'!E5","v":0},{"$f":"Sponsor","v":0},{"$f":"'1. Status & Certification'!E6","v":0},{"$f":"'1. Status & Certification'!B11","v":"Select One"},{"$f":"'1. Status & Certification'!E11","v":""},{"$f":"'1. Status & Certification'!B15","v":"Select One"},{"$f":"'1. Status & Certification'!B18","v":0},{"$f":"'1. Status & Certification'!C18","v":0},{"$f":"IF('1. Status & Certification'!$B$15=\"Yes\",\"CONFIDENTIAL\",'1. Status & Certification'!B19)","v":0},{"$f":"'1. Status & Certification'!$C$19","v":0},{"$f":"IF('1. Status & Certification'!$B$15=\"Yes\",\"CONFIDENTIAL\",'1. Status & Certification'!B20)","v":0},{"$f":"'1. Status & Certification'!$C$20","v":0},{"$f":"IF('1. Status & Certification'!$B$15=\"Yes\",\"CONFIDENTIAL\",'1. Status & Certification'!B21)","v":0},{"$f":"'1. Status & Certification'!$C$21","v":0},{"$f":"IF('1. Status & Certification'!$B$15=\"Yes\",\"CONFIDENTIAL\",'1. Status & Certification'!B22)","v":0},{"$f":"'1. Status & Certification'!$C$22","v":0},{"$f":"IF('1. Status & Certification'!$B$15=\"Yes\",\"CONFIDENTIAL\",'1. Status & Certification'!B23)","v":0},{"$f":"'1. Status & Certification'!$C$23","v":0},{"$f":"IF('1. Status & Certification'!$B$15=\"Yes\",\"CONFIDENTIAL\",'1. Status & Certification'!B24)","v":0},{"$f":"'1. Status & Certification'!$C$24","v":0},{"$f":"'1. Status & Certification'!B7","v":0},{"$f":"'1. Status & Certification'!E7","v":0},{"$f":"'1. Status & Certification'!B8","v":0},{"$f":"'1. Status & Certification'!E8","v":0},{"$f":"'1. Status & Certification'!B9","v":0},{"$f":"'1. Status & Certification'!E9","v":0},{"$f":"'1. Status & Certification'!B10","v":0},{"$f":"'1. Status & Certification'!E10","v":0},{"$f":"'6. Report Summary'!E55","v":"Enter Name to Sign"},{"$f":"'1. Status & Certification'!C29","v":"Select One"},{"$f":"'1. Status & Certification'!B12","v":0},{"$f":"'1. Status & Certification'!E12","v":0},{"$f":"'1. Status & Certification'!B13","v":"Select One"},{"$f":"'1. Status & Certification'!E13","v":"Select One"},{"$f":"'2. RFFs and Award Changes'!H6","v":0},{"$f":"'2. RFFs and Award Changes'!D42","v":0},{"$f":"SUM('2. RFFs and Award Changes'!D33:D39)","v":0},{"$f":"'2. RFFs and Award Changes'!D40","v":0},{"$f":"'2. RFFs and Award Changes'!D41","v":0},{"$f":"'2. RFFs and Award Changes'!G28","v":"Select One"},{"$f":"SUM('2. RFFs and Award Changes'!D33)","v":0},{"$f":"SUM('2. RFFs and Award Changes'!D34)","v":0},{"$f":"'2. RFFs and Award Changes'!$D$35","v":0},{"$f":"'2. RFFs and Award Changes'!$D$36","v":0},{"$f":"'2. RFFs and Award Changes'!$D$37","v":0},{"$f":"'2. RFFs and Award Changes'!$D$38","v":0},{"$f":"'2. RFFs and Award Changes'!$D$39","v":0},{"$f":"'2. RFFs and Award Changes'!$D$40","v":0},{"$f":"SUM('2. RFFs and Award Changes'!E33)","v":0},{"$f":"SUM('2. RFFs and Award Changes'!E34)","v":0},{"$f":"'2. RFFs and Award Changes'!$E$35","v":0},{"$f":"'2. RFFs and Award Changes'!$E$36","v":0},{"$f":"'2. RFFs and Award Changes'!$E$37","v":0},{"$f":"'2. RFFs and Award Changes'!$E$38","v":0},{"$f":"'2. RFFs and Award Changes'!$E$39","v":0},{"$f":"'2. RFFs and Award Changes'!$E$40","v":0},{"$f":"SUM('2. RFFs and Award Changes'!F33)","v":0},{"$f":"SUM('2. RFFs and Award Changes'!F34)","v":0},{"$f":"'2. RFFs and Award Changes'!$F$35","v":0},{"$f":"'2. RFFs and Award Changes'!$F$36","v":0},{"$f":"'2. RFFs and Award Changes'!$F$37","v":0},{"$f":"'2. RFFs and Award Changes'!$F$38","v":0},{"$f":"'2. RFFs and Award Changes'!$F$39","v":0},{"$f":"'2. RFFs and Award Changes'!$F$40","v":0},{"$f":"'2. RFFs and Award Changes'!G33","v":0},{"$f":"'2. RFFs and Award Changes'!G34","v":0},{"$f":"'2. RFFs and Award Changes'!G35","v":0},{"$f":"'2. RFFs and Award Changes'!G36","v":0},{"$f":"'2. RFFs and Award Changes'!G37","v":0},{"$f":"'2. RFFs and Award Changes'!G38","v":0},{"$f":"'2. RFFs and Award Changes'!G39","v":0},{"$f":"SUM('2. RFFs and Award Changes'!G40,'2. RFFs and Award Changes'!G41)","v":0},{"$f":"'2. RFFs and Award Changes'!D20","v":0},{"$f":"'6. Report Summary'!D26","v":0},{"$f":"'3. Expenditure Report'!H15","v":0},{"$f":"'6. Report Summary'!K26","v":0},{"$f":"SUM('3. Expenditure Report'!C6:C12)","v":0},{"$f":"SUM('3. Expenditure Report'!D6:D12)","v":0},{"$f":"SUM('3. Expenditure Report'!E6:E12)","v":0},{"$f":"SUM('3. Expenditure Report'!F6:F12)","v":0},{"$f":"SUM('3. Expenditure Report'!G6:G12)","v":0},{"$f":"SUM('3. Expenditure Report'!H6:H12)","v":0},{"$f":"SUM('3. Expenditure Report'!C13:C14)","v":0},{"$f":"SUM('3. Expenditure Report'!D13:D14)","v":0},{"$f":"SUM('3. Expenditure Report'!E13:E14)","v":0},{"$f":"SUM('3. Expenditure Report'!F13:F14)","v":0},{"$f":"SUM('3. Expenditure Report'!G13:G14)","v":0},{"$f":"'4. Budget Details'!$D$7","v":0},{"$f":"'4. Budget Details'!F7","v":0},{"$f":"'4. Budget Details'!G7","v":0},{"$f":"'4. Budget Details'!$D$8","v":0},{"$f":"'4. Budget Details'!$F$8","v":0},{"$f":"'4. Budget Details'!$G$8","v":0},{"$f":"'4. Budget Details'!$D$9","v":0},{"$f":"'4. Budget Details'!$F$9","v":0},{"$f":"'4. Budget Details'!$G$9","v":0},{"$f":"'4. Budget Details'!$D$10","v":0},{"$f":"'4. Budget Details'!$F$10","v":0},{"$f":"'4. Budget Details'!$G$10","v":0},{"$f":"'4. Budget Details'!$D$11","v":0},{"$f":"'4. Budget Details'!$F$11","v":0},{"$f":"'4. Budget Details'!$G$11","v":0},{"$f":"'4. Budget Details'!$D$12","v":0},{"$f":"'4. Budget Details'!$F$12","v":0},{"$f":"'4. Budget Details'!$G$12","v":0},{"$f":"SUMIF('4. Budget Details'!$I$7:$I$12,\"Acquisition\",'4. Budget Details'!$F$7:$F$12)","v":0},{"$f":"SUMIF('4. Budget Details'!$I$7:$I$12,\"Rehabilitation\",'4. Budget Details'!$F$7:$F$12)","v":0},{"$f":"SUMIF('4. Budget Details'!$I$7:$I$12,\"Relocation\",'4. Budget Details'!$F$7:$F$12)","v":0},{"$f":"SUMIF('4. Budget Details'!$I$7:$I$12,\"Other\",'4. Budget Details'!$F$7:$F$12)","v":0},{"$f":"SUMIF('4. Budget Details'!$I$7:$I$12,\"Acquisition\",'4. Budget Details'!$G$7:$G$12)","v":0},{"$f":"SUMIF('4. Budget Details'!$I$7:$I$12,\"Rehabilitation\",'4. Budget Details'!$G$7:$G$12)","v":0},{"$f":"SUMIF('4. Budget Details'!$I$7:$I$12,\"Relocation\",'4. Budget Details'!$G$7:$G$12)","v":0},{"$f":"SUMIF('4. Budget Details'!$I$7:$I$12,\"Other\",'4. Budget Details'!$G$7:$G$12)","v":0},{"$f":"'4. Budget Details'!D13","v":0},{"$f":"'4. Budget Details'!D15","v":0},{"$f":"'4. Budget Details'!D19","v":0},{"$f":"'4. Budget Details'!J19","v":0},{"$f":"'4. Budget Details'!$D21","v":0},{"$f":"'4. Budget Details'!$F21","v":0},{"$f":"'4. Budget Details'!$G21","v":0},{"$f":"'4. Budget Details'!$D22","v":0},{"$f":"'4. Budget Details'!$F22","v":0},{"$f":"'4. Budget Details'!$G22","v":0},{"$f":"'4. Budget Details'!$D23","v":0},{"$f":"'4. Budget Details'!$F23","v":0},{"$f":"'4. Budget Details'!$G23","v":0},{"$f":"'4. Budget Details'!$D24","v":0},{"$f":"'4. Budget Details'!$F24","v":0},{"$f":"'4. Budget Details'!$G24","v":0},{"$f":"'4. Budget Details'!$D25","v":0},{"$f":"'4. Budget Details'!$F25","v":0},{"$f":"'4. Budget Details'!$G25","v":0},{"$f":"'4. Budget Details'!$D26","v":0},{"$f":"'4. Budget Details'!$F26","v":0},{"$f":"'4. Budget Details'!$G26","v":0},{"$f":"SUMIF('4. Budget Details'!$I$21:$I$25,\"Operating\",'4. Budget Details'!$F$21:$F$26)","v":0},{"$f":"SUMIF('4. Budget Details'!$I$21:$I$25,\"Other\",'4. Budget Details'!$F$21:$F$26)","v":0},{"$f":"EJ2+EI2","v":0},{"$f":"IFERROR(DN2/AI2,\"\")","v":""},{"$f":"'5. Operating Costs'!F13","v":0},{"$f":"'5. Operating Costs'!E22","v":0},{"$f":"'5. Operating Costs'!F29","v":0},{"$f":"'5. Operating Costs'!$D23","v":"Please Enter Funding Source"},{"$f":"'5. Operating Costs'!$F23","v":0},{"$f":"'5. Operating Costs'!$D24","v":"Please Enter Funding Source"},{"$f":"'5. Operating Costs'!$F24","v":0},{"$f":"'5. Operating Costs'!$D25","v":"Please Enter Funding Source"},{"$f":"'5. Operating Costs'!$F25","v":0},{"$f":"'5. Operating Costs'!$D26","v":"Please Enter Funding Source"},{"$f":"'5. Operating Costs'!$F26","v":0},{"$f":"'5. Operating Costs'!$D27","v":"Please Enter Funding Source"},{"$f":"'5. Operating Costs'!$F27","v":0},{"$f":"'5. Operating Costs'!E51","v":0},{"$f":"'5. Operating Costs'!G51","v":0},{"$f":"'5. Operating Costs'!E57","v":0},{"$f":"'5. Operating Costs'!G57","v":0},{"$f":"'5. Operating Costs'!E71","v":0},{"$f":"'5. Operating Costs'!G71","v":0},{"$f":"'5. Operating Costs'!E80","v":0},{"$f":"'5. Operating Costs'!G80","v":0},{"$f":"'5. Operating Costs'!E87","v":0},{"$f":"'5. Operating Costs'!G87","v":0},{"$f":"'5. Operating Costs'!E89","v":0},{"$f":"'5. Operating Costs'!G29","v":0},{"$f":"'5. Operating Costs'!G95","v":0},{"$f":"'5. Operating Costs'!G96","v":0},{"$f":"'6. Report Summary'!E54","v":0}]

{"sheet":"Risk Analysis Data","index":8,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract #","Sponsor","Coapplicant 1","Coapplicant 2","Unverified Expenditure Score","Other Compliance Concerns","Total Risk Score"]
[{"$f":"'1. Status & Certification'!B5","v":0},{"$f":"Sponsor","v":0},{"$f":"'1. Status & Certification'!B7","v":0},{"$f":"'1. Status & Certification'!B8","v":0},{"$f":"SUM('6. Report Summary'!M36:M37,'6. Report Summary'!M34)","v":0},{"$f":"SUM('6. Report Summary'!M29,'6. Report Summary'!M30,'6. Report Summary'!M40,'6. Report Summary'!M41,'6. Report Summary'!M50)","v":0},{"$f":"'6. Report Summary'!E54","v":0}]