{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Overview","Aid Funds Worksheet","LFHE Worksheet","Data Upload","AidCerts","FYears"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Overview","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Local and Statewide Affordable Housing Aid (LAHA and SAHA) Annual Reporting to Minnesota Housing:\nInstructions for Completing and Submitting this Annual Reporting Workbook"]
["Version 1.0.4 (Final) (November 2025)"]
["To complete:","1. Review the Aid Funds Worksheet and LFHE Worksheet (the other two \"tabs\" in this Excel Workbook) to familiarize yourself with them."]
[null,"2. Select the name of the Aid Recipient (city, county or Tribal Nation) for which you are   completing this workbook from the dropdown in Cell B5 of the Aid Funds Worksheet."]
[null,"3. Complete the Aid Funds Worksheet according to the instructions in that worksheet."]
[null,"4. Complete the LFHE Worksheet according to the instructions in that worksheet."]
["To submit:","Please save this Annual Reporting Workbook using the naming convention \"[Name of Aid Recipient]_2025 Annual Reporting Workbook\" and upload to the Box.com folder specified by Minnesota Housing staff for this purpose."]
[null,"To ensure access to the specified Box.com folder, provide Minnesota Housing with contact information for up to three staff members of the Aid Recipient who need access using this link: "]
[null,"Provide primary contact information for purposes of LAHA and SAHA reporting."]
[null,"These staff contacts will be granted permission in Box.com to share access with others in their organization."]
["For more information:","Review the reporting instructions at Minnesota Housing's Local Government Housing Programs webpage:"]
[null,"https://mnhousing.gov/local-government/local-and-statewide-affordable-housing-aid.html"]
[null,"Please direct any questions or concerns about the instructions or this workbook to localhousingaid.mhfa@state.mn.us. Please do not email this workbook."]
["End of worksheet."]

{"sheet":"Aid Funds Worksheet","index":1,"n_rows":108,"n_cols":15,"rows_kept":108,"cut":false,"hidden":false,"merged":[[77,1,77,3],[74,1,74,3],[71,1,71,3]]}
["2025 Local and Statewide Affordable Housing Aid (LAHA and SAHA) Annual Report to Minnesota Housing: \nAid Fund Expenditures and Commitments Worksheet"]
[{"$f":"Overview!A2","v":"Version 1.0.4 (Final) (November 2025)"}]
["Visit Minnesota Housing's Local and Statewide Affordable Housing Aid web page for complete LAHA and SAHA reporting forms and instructions, including definitions of capitalized terms."]
["Aid Recipient (City, County or Tribal Nation)","Aid Recipient"]
["Please select the name of the Aid Recipient from the dropdown to the right."]
["SECTION 1: SUMMARY OF AID CERTIFIED TO DATE",null,null,null,null,"AID RECIPIENT NOTES"]
["Minnesota Housing's records indicate the Aid Recipient identified above received or has been certified by the Department of Revenue to receive the aid shown below. There is nothing to complete in this section. However, if  any of this information is incorrect, please email\n"]
["localhousingaid.mhfa@state.mn.us.\n",null,null,null,null,"The space below is reserved for notes the Aid Recipient may wish to keep."]
["To review aid certifications, visit the Department of Revenue's Aids, Credits, Levies and Budgeting website."]
["Type of Aid","Amount(s) Certified for Aid Year 2023 (SAHA Only)","Amount(s) Certified for Aid Year 2024","Amount(s) Certified for Aid Year 2025","Total",null,null,"Actual Expenditure","Expenditure from 2023 Aid Funds","Aid Year 2023 Unexpended Balance","Expenditure from 2024 Aid Funds","Aid Year 2024 Unexpended balance","Expenditure from 2025 Aid Funds","Aid Year 2025 Unexpended Balance","Total Unexpended Balance"]
["LAHA ",{"$f":"IF($B$5=\"\",\"Select Aid Recipient above\",VLOOKUP($B$5,AidCerts!$A$3:$H$204,6,FALSE))","v":"Select Aid Recipient above"},{"$f":"IF($B$5=\"\",\"Select Aid Recipient above\",VLOOKUP($B$5,AidCerts!$A$3:$H$204,7,FALSE))","v":"Select Aid Recipient above"},{"$f":"IF($B$5=\"\",\"Select Aid Recipient above\",VLOOKUP($B$5,AidCerts!$A$3:$H$204,8,FALSE))","v":"Select Aid Recipient above"},{"$f":"SUM(B11:D11)","v":0},null,"Starting",0,0,{"$f":"B13","v":"Select Aid Recipient above"},0,{"$f":"C13","v":"Select Aid Recipient above"},0,{"$f":"D13","v":"Select Aid Recipient above"},{"$f":"J11+L11+N11","v":{"$error":"#VALUE!"}}]
["SAHA ",{"$f":"IF($B$5=\"\",\"Select Aid Recipient above\",VLOOKUP($B$5,AidCerts!$A$3:$H$204,3,FALSE))","v":"Select Aid Recipient above"},{"$f":"IF($B$5=\"\",\"Select Aid Recipient above\",VLOOKUP($B$5,AidCerts!$A$3:$H$204,4,FALSE))","v":"Select Aid Recipient above"},{"$f":"IF($B$5=\"\",\"Select Aid Recipient above\",VLOOKUP($B$5,AidCerts!$A$3:$H$204,5,FALSE))","v":"Select Aid Recipient above"},{"$f":"SUM(B12:D12)","v":0},null,"2023 Expenditure 1",{"$f":"IF(ISBLANK(B23),0,B23)","v":0},{"$f":"MIN(J11,B23)","v":0},{"$f":"J11-I12","v":{"$error":"#VALUE!"}},{"$f":"IF(J12<=0,MIN(H12-I12,L11),0)","v":{"$error":"#VALUE!"}},{"$f":"L11-K12","v":{"$error":"#VALUE!"}},{"$f":"IF(L12<=0,MIN(H12-I12-K12,N11),0)","v":{"$error":"#VALUE!"}},{"$f":"N11-M12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["TOTAL",{"$f":"IF($B$5=\"\",\"Select Aid Recipient above\",B11+B12)","v":"Select Aid Recipient above"},{"$f":"IF($B$5=\"\",\"Select Aid Recipient above\",C11+C12)","v":"Select Aid Recipient above"},{"$f":"IF($B$5=\"\",\"Select Aid Recipient above\",D11+D12)","v":"Select Aid Recipient above"},{"$f":"SUM(B13:D13)","v":0},null,"2023 Expenditure 2",{"$f":"B24","v":0},{"$f":"MIN(J12,B24)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Commitment Deadline (LAHA and SAHA)","2026-12-31","2027-12-31","2028-12-31","N/A",null,"2023 Expenditure 3",{"$f":"B25","v":0},{"$f":"MIN(J13,B25)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["LAHA Expenditure Deadline","N/A",{"$f":"C14+365","v":"2028-12-30"},{"$f":"D14+365","v":"2029-12-31"},"N/A",null,"2023 Expenditure 4",{"$f":"B26","v":0},{"$f":"MIN(J14,B26)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["SAHA Expenditure Deadline","2027-12-31",{"$f":"C15","v":"2028-12-30"},{"$f":"D15","v":"2029-12-31"},"N/A",null,"2024 Expenditure 1",{"$f":"C23","v":0},{"$f":"MIN(J15,C23)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["SECTION 2: AID EXPENDITURES\n",null,null,null,null,null,"2024 Expenditure 2",{"$f":"C24","v":0},{"$f":"MIN(J16,C24)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Please complete the chart below to indicate how Aid Funds have been expended, according to the qualifying project category and date expended.",null,null,null,null,null,"2024 Expenditure 3",{"$f":"C25","v":0},{"$f":"MIN(J17,C25)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["To ensure this Worksheet calculates correctly: If any cells in Section 2 or 3 appear highlighted in yellow, click the \"Clear Highlighting in Sections 2 and 3\" button to the right."]
["Aid Available to Expend During All or Part of Each Calendar Year\nAid Funds are considered available to expend once certified by the Minnesota Department of Revenue. However, if the Aid Recipient's policies and procedures, or laws, rules or regulations governing the Aid Recipient's expenditures of Aid Funds, are more restrictive, then the AId Recipient must follow those restrictions.\n","Available to Expend During Calendar Year 2023\n(7/1/2023-12/31/2023)","Available to Expend During Calendar Year 2024\n(1/1/2024-12/31/2024)","Available to Expend During Calendar Year 2025\nThrough Nov. 30 (1/1/2025-11/30/2025)","Total\n(7/1/2023-11/30/2025)"]
["Aid available to expend",{"$f":"IFERROR(IF(B12-C31-D31<0,0,B12-C31-D31),0)","v":0},{"$f":"IFERROR(IF(B12+C11+C12-B31-D31<0,0,B12+C11+C12-B31-D31),0)","v":0},{"$f":"IFERROR(E13-B31-C31,0)","v":0},{"$f":"E13","v":0}]
["Qualifying Project Category\nNote that amounts certified for the 2023 Aid Year can be spent only on categories 1-4.","Aid Expended in Calendar Year 2023\n(7/1/2023-12/31/2023)","Aid Expended in Calendar Year 2024\n(1/1/2024-12/31/2024)","Aid Expended in Calendar Year 2025\nThrough Nov. 30 (1/1/2025-11/30/2025)","Total\n(7/1/2023-11/30/2025)",null,"2024 Expenditure 4",{"$f":"C26","v":0},{"$f":"MIN(J18,C26)","v":{"$error":"#VALUE!"}},{"$f":"J18-I22","v":{"$error":"#VALUE!"}},{"$f":"IF(J22<=0,MIN(H22-I22,L18),0)","v":{"$error":"#VALUE!"}},{"$f":"L18-K22","v":{"$error":"#VALUE!"}},{"$f":"IF(L22<=0,MIN(H22-I22-K22,N18),0)","v":{"$error":"#VALUE!"}},{"$f":"N18-M22","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["1. Emergency rental assistance for households at or below 80% AMI",0,0,0,{"$f":"SUM(B23:D23)","v":0},null,"2024 Expenditure 5",{"$f":"C27","v":0},0,{"$error":"#VALUE!"},{"$f":"MIN(H23-I23,L22)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(L23<=0,MIN(H23-I23-K23,N22),0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["2. Financial support to nonprofit affordable housing providers",0,0,0,0,null,"2024 Expenditure 6",{"$f":"C28","v":0},0,{"$error":"#VALUE!"},{"$f":"MIN(H24-I24,L23)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["3. Market Rate Residential Rental Property development (Greater Minnesota SAHA only; see reporting instructions for additional conditions)",0,0,0,0,null,"2024 Expenditure 7",{"$f":"C29","v":0},0,{"$error":"#VALUE!"},{"$f":"MIN(H25-I25,L24)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["4. Affordable Housing Development and Financing ",0,0,0,0,null,"2024 Expenditure 8",{"$f":"C30","v":0},0,{"$error":"#VALUE!"},{"$f":"MIN(H26-I26,L25)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["5. Operations and management of financially distressed residential properties",null,0,0,0,null,"2025 Expenditure 1",{"$f":"D23","v":0},{"$f":"MIN(J26,D23)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(J27<=0,MIN(H27-I27,L26),0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["6. Supportive services for supportive housing",null,0,0,0,null,"2025 Expenditure 2",0,{"$f":"MIN(J27,D24)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(J28<=0,MIN(H28-I28,L27),0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["7. Emergency shelter operations",null,0,0,0,null,"2025 Expenditure 3",0,{"$f":"MIN(J28,D25)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(J29<=0,MIN(H29-I29,L28),0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["8. Other project(s), subject to approval by Minnesota Housing (If entering Expenditures on this row, please complete Section 5A.)",null,0,0,0,null,"2025 Expenditure 4",0,{"$f":"MIN(J29,D26)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(J30<=0,MIN(H30-I30,L29),0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["TOTAL EXPENDITURES ON QUALIFYING PROJECTS",{"$f":"SUM(B23:B30)","v":0},{"$f":"SUM(C23:C30)","v":0},{"$f":"SUM(D23:D30)","v":0},{"$f":"SUM(E23:E30)","v":0},null,"2025 Expenditure 5",0,0,{"$error":"#VALUE!"},{"$f":"MIN(H31-I31,L30)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["AID EXPENDED BY TRANSFER TO A LOCAL HOUSING TRUST FUND (See Section 5C.)","Not allowable in Calendar Years 2023-2025",null,null,0,null,"2025 Expenditure 6",0,0,{"$error":"#VALUE!"},{"$f":"MIN(H32-I32,L31)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["AID FUNDS NOT YET EXPENDED (Based on dates certified and Expended, as of the end of the reporting period.)",{"$f":"IFERROR(IF(B12-C31-D31-B31<0,0,B12-C31-D31-B31),0)","v":0},{"$f":"IFERROR(IF(B12+C11+C12-B31-C31-D31<0,0,B12+C11+C12-B31-C31-D31),0)","v":0},{"$f":"IF(E13-B31-C31-D31<0,\"ERROR, LESS THAN ZERO\",E13-B31-C31-D31)","v":0},{"$f":"IF(E31>E13,\"ERROR,EXPENDITURES EXCEED CERTIFIED AID\",E13-E31-E32)","v":0},null,"2025 Expenditure 7",0,0,{"$error":"#VALUE!"},{"$f":"MIN(H33-I33,L32)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["SECTION 3: COMMITMENTS OF UNEXPENDED AID\n",null,null,null,null,null,"2025 Expenditure 8",0,0,{"$error":"#VALUE!"},{"$f":"MIN(H34-I34,L33)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Please complete the chart below to indicate how unexpended Aid Funds (the total in Cell E33 above) have been committed, according to the date committed.",null,null,null,null,null,"Remaining balance or carryover",null,0,{"$f":"J34","v":{"$error":"#VALUE!"}},0,{"$f":"L34","v":{"$error":"#VALUE!"}},0,{"$f":"N34","v":{"$error":"#VALUE!"}},{"$f":"O34","v":{"$error":"#VALUE!"}}]
["To ensure this Worksheet calculates correctly: If any cells in Section 2 or 3 appear highlighted in yellow, click the \"Clear Highlighting in Sections 2 and 3\" button to the right."]
["UNEXPENDED aid available to commit during all or part of each calendar year\nAid Funds are considered available to commit once certified by the Minnesota Department of Revenue. However, if the Aid Recipient's policies and procedures, or laws, rules or regulations governing the Aid Recipient's commitment of Aid Funds, are more restrictive, then the AId Recipient must follow those restrictions.","Available to Commit: Calendar Year 2023\n(7/1/2023-12/31/2023)","Available to Commit: Calendar Year 2024\n(1/1/2024-12/31/2024)","Available to Commit: Calendar Year 2025\nThrough Nov. 30 (1/1/2025-11/30/2025)","Total\n(7/1/2023-11/30/2025)"]
["UNEXPENDED aid available to commit",{"$f":"IFERROR(B33,0)","v":0},{"$f":"IFERROR(C33,0)","v":0},{"$f":"IFERROR(D33,0)","v":0},{"$f":"E13-E31","v":0}]
["Qualifying Project Category \nNote that amounts certified for the 2023 Aid Year can be spent only on categories 1-4.","Unexpended Aid Committed \nin Calendar Year 2023\n(7/1/2023-12/31/2023)","Unexpended Aid Committed \nin Calendar Year 2024\n(1/1/2024-12/31/2024)","Unexpended Aid Committed\nin Calendar Year 2025\nThrough Nov. 30 (1/1/2025-11/30/2025)","Total\n(7/1/2023-11/30/2025)"]
["1. Emergency rental assistance for households at or below 80% AMI",0,0,0,{"$f":"SUM(B40:D40)","v":0},null,null,"Actual Funds Committed","Commitment from 2023 Aid Funds","Aid Year 2023 Uncommitted Balance","Commitment from 2024 Aid Funds","Aid Year 2024 Uncommitted balance","Commitment from 2025 Aid Funds","Aid Year 2025 Uncommitted Balance","Total Uncommitted and Unexpended Balance"]
["2. Financial support to nonprofit affordable housing providers",0,0,0,0,null,"Starting",0,0,{"$f":"J35","v":{"$error":"#VALUE!"}},0,{"$f":"L35","v":{"$error":"#VALUE!"}},0,{"$f":"N35","v":{"$error":"#VALUE!"}},{"$f":"J41+L41+N41","v":{"$error":"#VALUE!"}}]
["3. Market Rate Residential Rental Property development (Greater Minnesota SAHA only; see reporting instructions for additional conditions)",0,0,0,0,null,"2023 Commitment 1",{"$f":"B40","v":0},{"$f":"MIN(J41,B40)","v":{"$error":"#VALUE!"}},{"$f":"J41-I42","v":{"$error":"#VALUE!"}},{"$f":"IF(J42<=0,MIN(H42-I42,L41),0)","v":{"$error":"#VALUE!"}},{"$f":"L41-K42","v":{"$error":"#VALUE!"}},{"$f":"IF(L42<=0,MIN(H42-I42-K42,N41),0)","v":{"$error":"#VALUE!"}},{"$f":"N41-M42","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["4. Affordable Housing Development and Financing",0,0,0,0,null,"2023 Commitment 2",{"$f":"B41","v":0},{"$f":"MIN(J42,B41)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["5. Operations and management of financially distressed residential properties",null,0,0,0,null,"2023 Commitment 3",{"$f":"B42","v":0},{"$f":"MIN(J43,B42)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["6. Supportive services for supportive housing",null,0,0,0,null,"2023 Commitment 4",{"$f":"B43","v":0},{"$f":"MIN(J44,B43)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["7. Emergency shelter operations",null,0,0,0,null,"2024 Commitment 1",{"$f":"C40","v":0},{"$f":"MIN(J45,C40)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["8. Other project(s), subject to approval by Minnesota Housing. (If entering Commitments on this row, please complete Section 5A.)",null,0,0,0,null,"2024 Commitment 2",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["TOTAL ACTIVE COMMITMENTS at end of reporting period",{"$f":"SUM(B40:B47)","v":0},{"$f":"SUM(C40:C47)","v":0},{"$f":"SUM(D40:D47)","v":0},{"$f":"D48","v":0},null,"2024 Commitment 3",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["TOTAL EXPENDITURES PLUS ACTIVE COMMITMENTS",{"$f":"B31+B48","v":0},{"$f":"C31+C48","v":0},{"$f":"D31+D48","v":0},{"$f":"E31+D48","v":0},null,"2024 Commitment 4",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["SECTION 4: AID POTENTIALLY SUBJECT TO RECAPTURE\n",null,null,null,null,null,"2024 Commitment 5",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["According to the information provided above, Aid Funds in the amounts shown below are potentially subject to recapture. Note that Commitments and Expenditures are presumed to be drawn first from the earliest Aid Year balance (2023 for SAHA and 2024 for LAHA). ",null,null,null,null,null,"2024 Commitment 6",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["There is nothing to complete in this section.",null,null,null,null,null,"2024 Commitment 7",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Section 4A: Uncommitted Aid Funds potentially subject to recapture.",null,null,null,null,null,"2024 Commitment 8",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Aid certified for Aid Year 2023 subject to recapture if not committed to (a) Qualifying Project(s) by December 31, 2026 and expended  by December 31, 2027.",null,null,null,{"$f":"IF(IFERROR($B$13-SUM(E23:E26,E40:E43),0)<0, 0, (IFERROR($B$13-SUM(E23:E26,E40:E43),0)))","v":0},null,"2025 Commitment 1",{"$f":"D40","v":0},{"$f":"MIN(J53,D40)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Aid certified for Aid Year 2024 subject to recapture if not committed to (a) Qualifying Project(s) by December 31, 2027 and expended by December 31, 2028.",null,null,null,{"$f":"IFERROR(L62,0)","v":0},null,"2025 Commitment 2",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Aid certified for Aid Year 2025 subject to recapture if not committed to (a) Qualifying Project(s) by December 31, 2028 and expended by December 31, 2029.",null,null,null,{"$f":"IFERROR(N62,0)","v":0},null,"2025 Commitment 3",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Total uncommitted Aid Funds potentially subject to recapture",null,null,null,{"$f":"SUM(E54:E56)","v":0},null,"2025 Commitment 4",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Section 4B: Unexpended Aid Funds potentially subject to recapture.",null,null,null,null,null,"2025 Commitment 5",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Aid certified for Aid Year 2023 subject to recapture if not expended by December 31, 2027.",null,null,null,{"$f":"IF(IFERROR($B$13-SUM(E23:E26),0)<0, 0, (IFERROR($B$13-SUM(E23:E26),0)))","v":0},null,"2025 Commitment 6",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Aid certified for Aid Year 2024 subject to recapture if not  expended by December 31, 2028.",null,null,null,{"$f":"IFERROR(L35,0)","v":0},null,"2025 Commitment 7",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Aid certified for Aid Year 2025 subject to recapture if not  expended by December 31, 2029.",null,null,null,{"$f":"IFERROR(N35,0)","v":0},null,"2025 Commitment 8",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Total Unexpended Aid Funds potentially subject to recapture",null,null,null,{"$f":"SUM(E59:E61)","v":0},null,"Remaining balance or carryover",null,0,{"$f":"J61","v":{"$error":"#VALUE!"}},0,{"$f":"L61","v":{"$error":"#VALUE!"}},0,{"$f":"N61","v":{"$error":"#VALUE!"}},{"$f":"O61","v":{"$error":"#VALUE!"}}]
["Section 4C: Total Aid Funds potentially subject to recapture. Note that this is not necessarily the same as the sum of Section 4A and Section 4B, since 4B may include both committed and uncommitted balances."]
["Total unexpended and/or uncommitted Aid Funds potentially subject to recapture",null,null,null,{"$f":"IFERROR(MAX(E57,E62),0)","v":0}]
["SECTION 5: NARRATIVE AND CERTIFICATION\n"]
["In the boxes to the right, please provide contact information for the person submmiting this form.","<Name of the person completing this form>"]
["Email address","<Email address>"]
["Confirm email address","<Re-enter Email address to confirm>"]
["Phone","<Phone Number>"]
["Section 5A: Description of other project(s) subject to Minnesota Housing approval"]
["Is description required?",{"$f":"IF(E30>0,\"Yes.\",IF(E47>0,\"Yes.\",\"No.\"))","v":"No."}]
["If description is required because the Aid Recipient committed Aid Funds to or expended Aid Funds on \"Other project(s), subject to approval by Minnesota Housing,\" please describe:\n\n1. The project or projects for which Aid Funds have been expended or committed.\n2. Why the project(s) does/do not fit another Qualifying Project Category.\n3. Whether and when Minnesota Housing staff previously approved the project or projects as Qualifying (please send documentation if available).\n4. Whether and how the project(s) contribute to the creation and preservation of affordable and/or workforce housing, keep families and individuals from losing housing, or help those experiencing homelessness find housing.","<If description of other projects is required, please enter it here .>"]
["Section 5B: Location of Unspent funds. Aid Recipients are required by statute to describe the location of any unspent Aid Funds. "]
["Is explanation required?",{"$f":"IF(E33>0,\"Yes.\",\"No.\")","v":"No."}]
["If any Aid Funds remain unspent:\n\nPlease explain in the box to the right the location of unspent funds. For example, whether they are held by the Aid Recipient or by a third party or parties, and in which type of account or accounts.","<If explanation of the location of unspent funds is required, please enter it here .>"]
["Section 5C: Demonstration of a Tier I City or County related to Aid expenditure by transfer to a Local Housing Trust Fund."]
["Is demonstration required?",{"$f":"IF(E32>0,\"Yes.\",\"No.\")","v":"No."}]
["If the Aid Recipient is expending Aid Funds by transferring them to a  Local Housing Trust Fund, please explain in the box to the right  the factors outside the Aid Recipient's control that prevented the Aid Recipient from otherwise meeting the Expenditure Deadline.","<This Section 5C is provided for informational purposes only. Minnesota Housing anticipates it will begin accepting demonstrations from Aid Recipients that are cities or counties no earlier than late 2026, though only in connection with Aid Funds certified for Aid Year 2023 that the Aid Recipient Committed to (a) Qualifying Project(s) by December 31, 2026. By statute, neither Tribal Nations nor grantees under Minnesota Housing's Greater Minnesota Small Cities (Tier II Cities) Housing Aid Grant Program may spend funds by transferring them to a Local Housing Trust Fund.>"]
["Section 5D: Certification."]
["By submitting this form, the Aid Recipient certifies:"]
["1. The statements and information provided in this Aid Fund Commitments and Expenditures Worksheet and any required attachments are, based upon reasonable inquiry and belief, true, correct and complete."]
["2. The Aid Recipient has prioritized projects that provide affordable housing to Low-Income Households."]
["3. The Aid Recipient understands that failure to submit timely and accurate reports, or to timely commit and expend Aid Funds only on Qualifying Projects, may result in a need for the Aid Recipient to pay Aid Funds to Minnesota Housing."]
["4. The Aid Recipient commits to using Aid Funds to supplement, not supplant, existing Locally Funded Housing Expenditures, so that the Aid Recipient is using the Aid Funds to create new or to expand existing housing programs."]
["5. All Aid Funds have been and will be used only in accordance with all applicable laws, rules and regulations, including Minn. Stat. 477A.35 or 477A.36, or both, as applicable."]
["SUBMITTAL INSTRUCTIONS"]
["Please save this Workbook in Excel format using the naming convention \"[Name of Aid Recipient]_[Year] Annual Reporting Workbook,\" complete the LFHE Worksheet, re-save, and upload this Workbook to the Box.com folder specified by Minnesota Housing. "]
[{"$f":"A1&\" \"&A2","v":"2025 Local and Statewide Affordable Housing Aid (LAHA and SAHA) Annual Report to Minnesota Housing: \nAid Fund Expenditures and Commitments Worksheet Version 1.0.4 (Final) (November 2025)"},null,null,"Date User Prepared:",{"$f":"LastSavedTimeStamp()","v":"2025-10-01T16:47:58"}]
[]
[]
["Aid Recipient Notes"]
["The space below is reserved for any additional notes the Aid Recipient may wish to keep."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["End of Worksheet."]

{"sheet":"LFHE Worksheet","index":2,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,1,20,3]]}
["2025 Local and Statewide Affordable Housing Aid (LAHA and SAHA) Annual Report to Minnesota Housing:\n Locally Funded Housing Expenditures Worksheet"]
[{"$f":"Overview!A2","v":"Version 1.0.4 (Final) (November 2025)"}]
["NOTE: Locally funded housing expenditures are NOT the same as expenditures of Aid Funds. Do not include expenditures of Local or Statewide Affordable Housing Aid in this Worksheet."]
["\"Locally funded housing expenditures\" are expenditures of the Aid Recipient, including expenditures by a public corporation or  legal entity created by the Aid Recipient, that are:"]
["(1) funded from the Aid Recipient's general fund, a property tax levy of the Aid Recipient or its housing and redevelopment authority, or unrestricted money available to the Aid Recipient, but not including tax increments; and  "]
["(2) expended on certain activities during the Aid Recipient's two prior fiscal years. (For a list of those certain activities, see the \"Activity\" list below, in Cells A13 through A18)."]
["Visit Minnesota Housing's Local and Statewide Affordable Housing Aid web page for complete LAHA and SAHA reporting forms and instructions, including definitions of capitalized terms."]
["Aid Recipient (City, County or Tribal Nation)","Aid Recipient",null,"Date User Prepared (Last Saved):"]
["Please select the name of the Aid Recipient from the dropdown in the \"Aid Funds Worksheet\" tab.",{"$f":"IF(ISBLANK('Aid Funds Worksheet'!B5),\"\",'Aid Funds Worksheet'!B5)","v":""},null,{"$f":"TEXT(LastSavedTimeStamp(),\"MMMM D, YYYY\")","v":"October 2, 2025"}]
["Section 1: Two Prior Fiscal Years' Locally Funded Housing Expenditures.",null,null,null,"Aid Recipient Notes"]
["In the table below, enter the Aid Recipient's locally funded housing expenditures for each of its prior two fiscal years."]
["Activity","Total Locally Funded Housing Expenditures During the Aid Recipient's 2023 Fiscal Year","Total Locally Funded Housing Expenditures During the Aid Recipient's \n2024 Fiscal Year","Year-to-Year Change","The space below is reserved for notes the Aid Recipient may wish to keep."]
["Financial assistance to residents in arrears on rent, mortgage, utilities or property tax payments",0,0,{"$f":"C13-B13","v":0}]
["Support services, case management services, and legal services for residents in arrears on rent, mortgage, utilities or property tax payments",0,0,0]
["Down payment assistance or homeownership education, counseling and training",0,0,0]
["Acquisition, construction, rehabilitation, adaptive reuse, improvement, financing and infrastructure of residential dwellings",0,0,0]
["Costs of operating emergency shelter, transitional housing, supportive housing or publicly owned housing, including costs of providing case management services and support services",0,0,0]
["Rental assistance",0,0,0]
["TOTAL",{"$f":"SUM(B13:B18)","v":0},{"$f":"SUM(C13:C18)","v":0},0]
["Section 2: Explanation of Year-to-Year Reduction\nIs explanation of a reduction required?",{"$f":"IF(D13<0,\"Yes, one or more Locally Funded Housing Expenditures has been reduced. See below for further instruction.\",IF(D14<0,\"Yes, one or more Locally Funded Housing Expenditures has been reduced. See below for further instruction.\",IF(D15<0,\"Yes, one or more Locally Funded Housing Expenditures has been reduced. See below for further instruction.\",IF(D16<0,\"Yes, one or more Locally Funded Housing Expenditures has been reduced. See below for further instruction.\",IF(D17<0,\"Yes, one or more Locally Funded Housing Expenditures has been reduced. See below for further instruction.\",IF(D18<0,\"Yes, one or more Locally Funded Housing Expenditures has been reduced. See below for further instruction.\",\"No\"))))))","v":"No"}]
["If explanation is required:\n\na. Please explain in the box to the right the reason for reduction of each locally funded housing expenditure from one fiscal year to the next. If sending additional explanation, please write \"sending additional explanation.\"\n\nAND\n\n\nb. Also explain in the box to the right where on the Aid Recipient's website (a web address/URL) members of the public can find the certification required by statute. This certification should include the following language:\n\n\"As a condition of receiving housing aid funds from the State of Minnesota, the [Name of Aid Recipient] must commit to using housing aid funds to supplement, not supplant, existing locally funded housing expenditures, so that the [Name of Aid Recipient] is using the funds to create new or to expand existing housing programs. Between [second-prior fiscal year] and [prior fiscal year], the [Name of Aid Recipient] reduced its expenditure on [List each activity where there was a year-to-year reduction] by $[amount of reduction]. The reason the [Name of Aid Recipient] reduced [this/these] expenditure(s) is: [reason for reduction].\"","<If explanation of a reduction in locally funded housing expenditures is required, please enter it here according to the instructions found in the box to the left.>"]
["Section 3: Certification"]
["By submitting this form, the Aid Recipient certifies:"]
["1. The statements and information provided in this LFHE Worksheet are, based upon reasonable inquiry and belief, true, correct and complete."]
["2. The Aid Recipient commits to using Aid Funds to supplement, not supplant, existing Locally Funded Housing Expenditures, so that the Aid Recipient is using the Aid Funds to create new or to expand existing housing programs."]
["SUBMITTAL INSTRUCTIONS"]
["Please save this Workbook in Excel format using the naming convention \"[Name of Aid Recipient]_[Year] Annual Reporting Workbook,\" complete the Aid Funds Worksheet, re-save, and upload to the Box.com folder specified by Minnesota Housing. "]
[{"$f":"A1&\" \"&A2","v":"2025 Local and Statewide Affordable Housing Aid (LAHA and SAHA) Annual Report to Minnesota Housing:\n Locally Funded Housing Expenditures Worksheet Version 1.0.4 (Final) (November 2025)"},null,null,{"$f":"\"Date User Prepared:   \"&TEXT(LastSavedTimeStamp(),\"MMMM D, YYYY\")","v":"Date User Prepared:   October 2, 2025"}]
["End of Worksheet."]

{"sheet":"Data Upload","index":3,"n_rows":2,"n_cols":92,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Aid Recepient","2023 SAHA","2024 SAHA","2025 SAHA","2024 LAHA","2025 LAHA","2023 Expended 1","2023 Expended 2","2023 Expended 3","2023 Expended 4","2024 Expended 1","2024 Expended 2","2024 Expended 3","2024 Expended 4","2024 Expended 5","2024 Expended 6","2024 Expended 7","2024 Expended 8","2025 Expended 1","2025 Expended 2","2025 Expended 3","2025 Expended 4","2025 Expended 5","2025 Expended 6","2025 Expended 7","2025 Expended 8","Total Expended 1","Total Expended 2","Total Expended 3","Total Expended 4","Total Expended 5","Total Expended 6","Total Expended 7","Total Expended 8","Total Not Expended","2023 Committed 1","2023 Committed 2","2023 Committed 3","2023 Committed 4","2024 Committed 1","2024 Committed 2","2024 Committed 3","2024 Committed 4","2024 Committed 5","2024 Committed 6","2024 Committed 7","2024 Committed 8","2025 Committed 1","2025 Committed 2","2025 Committed 3","2025 Committed 4","2025 Committed 5","2025 Committed 6","2025 Committed 7","2025 Committed 8","Total Commitments","Total Commitments + Expenditures","2023 Uncommitted Recapture","2024 Uncommitted Recpature","2025 Uncommitted Recapture","Total Uncommitted Recapture","2023 Unexpended Recapture","2024 Unexpended Recapture","2025 Unexpended Recapture","Total Unexpended Recapture","Total Unexpended and/or Uncommited Recapture","Name","Email","Phone","5a Description Required","5a Description","5b Explanation Required","5b Explanation","5c Demonstration Required","5c Demonstration","Date Prepared","2023 Financial assistance to residents in arrears on rent, mortgage, utilities or property tax payments","2023 Support services, case management services, and legal services for residents in arrears on rent, mortgage, utilities or property tax payments","2023 Down payment assistance or homeownership education, counseling and training","2023 Acquisition, construction, rehabilitation, adaptive reuse, improvement, financing and infrastructure of residential dwellings","2023 Costs of operating emergency shelter, transitional housing, supportive housing or publicly owned housing, including costs of providing case management services and support services","2023 Rental assistance","Total Expenditures 2023 Fiscal Year","2024 Financial assistance to residents in arrears on rent, mortgage, utilities or property tax payments","2024 Support services, case management services, and legal services for residents in arrears on rent, mortgage, utilities or property tax payments","2024 Down payment assistance or homeownership education, counseling and training","2024 Acquisition, construction, rehabilitation, adaptive reuse, improvement, financing and infrastructure of residential dwellings","2024 Costs of operating emergency shelter, transitional housing, supportive housing or publicly owned housing, including costs of providing case management services and support services","2024 Rental assistance","Total Expenditures 2024 Fiscal Year","2 Explanation Required","2 Explanation"]
[{"$f":"'Aid Funds Worksheet'!$B$5","v":0},{"$f":"'Aid Funds Worksheet'!B12","v":"Select Aid Recipient above"},{"$f":"'Aid Funds Worksheet'!C12","v":"Select Aid Recipient above"},{"$f":"'Aid Funds Worksheet'!D12","v":"Select Aid Recipient above"},{"$f":"'Aid Funds Worksheet'!C11","v":"Select Aid Recipient above"},{"$f":"'Aid Funds Worksheet'!D11","v":"Select Aid Recipient above"},{"$f":"'Aid Funds Worksheet'!B23","v":0},{"$f":"'Aid Funds Worksheet'!B24","v":0},{"$f":"'Aid Funds Worksheet'!B25","v":0},{"$f":"'Aid Funds Worksheet'!B26","v":0},{"$f":"'Aid Funds Worksheet'!C23","v":0},{"$f":"'Aid Funds Worksheet'!C24","v":0},{"$f":"'Aid Funds Worksheet'!C25","v":0},{"$f":"'Aid Funds Worksheet'!C26","v":0},{"$f":"'Aid Funds Worksheet'!C27","v":0},{"$f":"'Aid Funds Worksheet'!C28","v":0},{"$f":"'Aid Funds Worksheet'!C29","v":0},{"$f":"'Aid Funds Worksheet'!C30","v":0},{"$f":"'Aid Funds Worksheet'!D23","v":0},{"$f":"'Aid Funds Worksheet'!D24","v":0},{"$f":"'Aid Funds Worksheet'!D25","v":0},{"$f":"'Aid Funds Worksheet'!D26","v":0},{"$f":"'Aid Funds Worksheet'!D27","v":0},{"$f":"'Aid Funds Worksheet'!D28","v":0},{"$f":"'Aid Funds Worksheet'!D29","v":0},{"$f":"'Aid Funds Worksheet'!D30","v":0},{"$f":"'Aid Funds Worksheet'!E23","v":0},{"$f":"'Aid Funds Worksheet'!E24","v":0},{"$f":"'Aid Funds Worksheet'!E25","v":0},{"$f":"'Aid Funds Worksheet'!E26","v":0},{"$f":"'Aid Funds Worksheet'!E27","v":0},{"$f":"'Aid Funds Worksheet'!E28","v":0},{"$f":"'Aid Funds Worksheet'!E29","v":0},{"$f":"'Aid Funds Worksheet'!E30","v":0},{"$f":"'Aid Funds Worksheet'!E33","v":0},{"$f":"'Aid Funds Worksheet'!B40","v":0},{"$f":"'Aid Funds Worksheet'!B41","v":0},{"$f":"'Aid Funds Worksheet'!B42","v":0},{"$f":"'Aid Funds Worksheet'!B43","v":0},{"$f":"'Aid Funds Worksheet'!C40","v":0},{"$f":"'Aid Funds Worksheet'!C41","v":0},{"$f":"'Aid Funds Worksheet'!C42","v":0},{"$f":"'Aid Funds Worksheet'!C43","v":0},{"$f":"'Aid Funds Worksheet'!C44","v":0},{"$f":"'Aid Funds Worksheet'!C45","v":0},{"$f":"'Aid Funds Worksheet'!C46","v":0},{"$f":"'Aid Funds Worksheet'!C47","v":0},{"$f":"'Aid Funds Worksheet'!D40","v":0},{"$f":"'Aid Funds Worksheet'!D41","v":0},{"$f":"'Aid Funds Worksheet'!D42","v":0},{"$f":"'Aid Funds Worksheet'!D43","v":0},{"$f":"'Aid Funds Worksheet'!D44","v":0},{"$f":"'Aid Funds Worksheet'!D45","v":0},{"$f":"'Aid Funds Worksheet'!D46","v":0},{"$f":"'Aid Funds Worksheet'!D47","v":0},{"$f":"'Aid Funds Worksheet'!E48","v":0},{"$f":"'Aid Funds Worksheet'!E49","v":0},{"$f":"'Aid Funds Worksheet'!E54","v":0},{"$f":"'Aid Funds Worksheet'!E55","v":0},{"$f":"'Aid Funds Worksheet'!E56","v":0},{"$f":"'Aid Funds Worksheet'!E57","v":0},{"$f":"'Aid Funds Worksheet'!E59","v":0},{"$f":"'Aid Funds Worksheet'!E60","v":0},{"$f":"'Aid Funds Worksheet'!E61","v":0},{"$f":"'Aid Funds Worksheet'!E62","v":0},{"$f":"'Aid Funds Worksheet'!E64","v":0},{"$f":"'Aid Funds Worksheet'!B66","v":"<Name of the person completing this form>"},{"$f":"'Aid Funds Worksheet'!B67","v":"<Email address>"},{"$f":"'Aid Funds Worksheet'!B68","v":"<Re-enter Email address to confirm>"},{"$f":"'Aid Funds Worksheet'!B71","v":"No."},{"$f":"'Aid Funds Worksheet'!B72","v":"<If description of other projects is required, please enter it here .>"},{"$f":"'Aid Funds Worksheet'!B74","v":"No."},{"$f":"'Aid Funds Worksheet'!B75","v":"<If explanation of the location of unspent funds is required, please enter it here .>"},{"$f":"'Aid Funds Worksheet'!B77","v":"No."},{"$f":"'Aid Funds Worksheet'!B78","v":"<This Section 5C is provided for informational purposes only. Minnesota Housing anticipates it will begin accepting demonstrations from Aid Recipients that are cities or counties no earlier than late 2026, though only in connection with Aid Funds certified for Aid Year 2023 that the Aid Recipient Committed to (a) Qualifying Project(s) by December 31, 2026. By statute, neither Tribal Nations nor grantees under Minnesota Housing's Greater Minnesota Small Cities (Tier II Cities) Housing Aid Grant Program may spend funds by transferring them to a Local Housing Trust Fund.>"},{"$f":"'Aid Funds Worksheet'!E88","v":"2025-10-01T16:47:58"},{"$f":"'LFHE Worksheet'!B13","v":0},{"$f":"'LFHE Worksheet'!B14","v":0},{"$f":"'LFHE Worksheet'!B15","v":0},{"$f":"'LFHE Worksheet'!B16","v":0},{"$f":"'LFHE Worksheet'!B17","v":0},{"$f":"'LFHE Worksheet'!B19","v":0},{"$f":"'LFHE Worksheet'!B19","v":0},{"$f":"'LFHE Worksheet'!C13","v":0},{"$f":"'LFHE Worksheet'!C14","v":0},{"$f":"'LFHE Worksheet'!C15","v":0},{"$f":"'LFHE Worksheet'!C16","v":0},{"$f":"'LFHE Worksheet'!C17","v":0},{"$f":"'LFHE Worksheet'!C18","v":0},{"$f":"'LFHE Worksheet'!C19","v":0},{"$f":"'LFHE Worksheet'!B20","v":"No"},{"$f":"'LFHE Worksheet'!B21","v":"<If explanation of a reduction in locally funded housing expenditures is required, please enter it here according to the instructions found in the box to the left.>"}]

{"sheet":"AidCerts","index":4,"n_rows":204,"n_cols":8,"rows_kept":204,"cut":false,"hidden":true,"merged":[]}
["City and county information as of May 30, 2025; Tribal Nations information as of 9.22.2025."]
["AID RECIPIENT","Type of Aid Recipient","2023 SAHA","2024 SAHA","2025 SAHA","2023 LAHA","2024 LAHA","2025 LAHA"]
["Aitkin County","County",97222,97222,41754,0,0,0]
["Anoka County","County",417202,417202,179909,0,3390611.15,9123550.3699999992]
["Becker County","County",115216,115216,48848,0,0,0]
["Beltrami County","County",131410,131410,53725,0,0,0]
["Benton County","County",120480,120480,50314,0,0,0]
["Big Stone County","County",83139,83139,35253,0,0,0]
["Blue Earth County","County",165141,165141,69985,0,0,0]
["Bois Forte Band of Chippewa","Tribal Nation",385715,245455,120000,0,0,0]
["Brown County","County",99826,99826,43239,0,0,0]
["Carlton County","County",111092,111092,47700,0,0,0]
["Carver County","County",170595,170595,73460,0,1630367.98,4285474.79]
["Cass County","County",112343,112343,47751,0,0,0]
["Chippewa County","County",91734,91734,39334,0,0,0]
["Chisago County","County",130416,130416,55020,0,0,0]
["City of Albert Lea","City",89520,89520,37415,0,0,0]
["City of Alexandria","City",101341,101341,38219,0,0,0]
["City of Andover","City",0,0,0,0,98152.49,255105.13]
["City of Anoka","City",0,0,0,0,118154.37,300785.48]
["City of Apple Valley","City",0,0,0,0,282732.21000000002,764230.98]
["City of Austin","City",120070,120070,45513,0,0,0]
["City of Bemidji","City",113627,113627,41944,0,0,0]
["City of Big Lake","City",34074,34074,16158,0,0,0]
["City of Blaine","City",0,0,0,0,292706.63,772363.98]
["City of Bloomington","City",0,0,0,0,567427.48,1478986.21]
["City of Brainerd","City",96242,96242,40121,0,0,0]
["City of Brooklyn Center","City",0,0,0,0,188983.33,511430.2]
["City of Brooklyn Park","City",0,0,0,0,464128.62,1182131.67]
["City of Buffalo","City",84884,84884,37709,0,0,0]
["City of Burnsville","City",0,0,0,0,405820.74,1141331.1200000001]
["City of Cambridge","City",0,0,29983,0,0,0]
["City of Champlin","City",0,0,0,0,103882.47,279775.23]
["City of Chanhassen","City",0,0,0,0,126855.46,307291.88]
["City of Chaska","City",0,0,0,0,130038.78,339010.59]
["City of Cloquet","City",64810,64810,28473,0,0,0]
["City of Columbia Heights","City",0,0,0,0,142878.19,390248.49]
["City of Coon Rapids","City",0,0,0,0,355471.16,973249.1]
["City of Cottage Grove","City",0,0,0,0,125476.02,395263.84]
["City of Crystal","City",0,0,0,0,127279.9,347956.89]
["City of Dayton","City",0,0,0,0,0,73197.009999999995]
["City of Detroit Lakes","City",0,0,24276,0,0,0]
["City of Duluth","City",519641,519641,228018,0,0,0]
["City of Eagan","City",0,0,0,0,346610.91,891647.99]
["City of East Bethel","City",0,0,0,0,25466.59,96240.51]
["City of Eden Prairie","City",0,0,0,0,268672.53000000003,729801.28]
["City of Edina","City",0,0,0,0,339342.32,875381.99]
["City of Elk River","City",94063,94063,42592,0,0,0]
["City of Fairmont","City",54797,54797,22551,0,0,0]
["City of Faribault","City",103798,103798,47494,0,0,0]
["City of Farmington","City",0,0,0,0,88549.46,244803.33]
["City of Fergus Falls","City",100275,100275,40219,0,0,0]
["City of Forest Lake","City",0,0,0,0,118578.81,311900.58]
["City of Fridley","City",0,0,0,0,163516.74,462361.1]
["City of Golden Valley","City",0,0,0,0,137095.15,343754.84]
["City of Grand Rapids","City",72228,72228,34160,0,0,0]
["City of Ham Lake","City",0,0,0,0,61066.76,162388.92000000001]
["City of Hastings","City",0,0,0,0,114387.44,284519.48]
["City of Hermantown","City",55399,55399,21531,0,0,0]
["City of Hibbing","City",66896,66896,33434,0,0,0]
["City of Hopkins","City",0,0,0,0,172642.26,469274.15]
["City of Hugo","City",0,0,0,0,59740.38,185025.77]
["City of Hutchinson","City",68658,68658,30649,0,0,0]
["City of Inver Grove Heights","City",0,0,0,0,200443.29,491911]
["City of Lake Elmo","City",0,0,0,0,48810.97,146394.01999999999]
["City of Lakeville","City",0,0,0,0,229464.59,635458.47]
["City of Lino Lakes","City",0,0,0,0,88284.18,247107.68]
["City of Little Canada","City",0,0,0,0,75020.33,196954.17]
["City of Mankato","City",288957,288957,123108,0,0,0]
["City of Maple Grove","City",0,0,0,0,265701.43,754878.03]
["City of Maplewood","City",0,0,0,0,221506.29,587609.31000000006]
["City of Marshall","City",72506,72506,29689,0,0,0]
["City of Mendota Heights","City",0,0,0,0,43876.81,123621.61]
["City of Minneapolis","City",0,0,0,0,3274101.65,8595226.4100000001]
["City of Minnetonka","City",0,0,0,0,321515.71000000002,800422.83]
["City of Monticello","City",60870,60870,25355,0,0,0]
["City of Moorhead","City",260817,260817,114558,0,0,0]
["City of Mounds View","City",0,0,0,0,71412.570000000007,190312.22]
["City of New Brighton","City",0,0,0,0,142719.01999999999,362731.84]
["City of New Hope","City",0,0,0,0,181714.74,433760.05]
["City of New Ulm","City",53684,53684,24453,0,0,0]
["City of North Branch","City",49929,49929,20355,0,0,0]
["City of North Mankato","City",66016,66016,26512,0,0,0]
["City of North St. Paul","City",0,0,0,0,84570.3,200342.92]
["City of Northfield","City",75056,75056,31885,0,0,0]
["City of Oakdale","City",0,0,0,0,178743.63,462072.1]
["City of Otsego","City",52757,52757,23786,0,0,0]
["City of Owatonna","City",133051,133051,56357,0,0,0]
["City of Plymouth","City",0,0,0,0,363111.14,933261.85]
["City of Prior Lake","City",0,0,0,0,109824.67,266897.98]
["City of Ramsey","City",0,0,0,0,118897.15,316780.38]
["City of Red Wing","City",95500,95500,40748,0,0,0]
["City of Richfield","City",0,0,0,0,233602.92,643862.56999999995]
["City of Robbinsdale","City",0,0,0,0,103298.86,260120.48]
["City of Rochester","City",545926,545926,250117,0,0,0]
["City of Rogers","City",0,0,0,0,32204.63,81601.11]
["City of Rosemount","City",0,0,0,0,85047.8,232874.92]
["City of Roseville","City",0,0,0,0,211213.54,563752.51]
["City of Sartell","City",84606,84606,39376,0,0,0]
["City of Sauk Rapids","City",56048,56048,23453,0,0,0]
["City of Savage","City",0,0,0,0,146432.9,407869.99]
["City of Shakopee","City",0,0,0,0,212327.7,552366.31000000006]
["City of Shoreview","City",0,0,0,0,130516.28,334672.99]
["City of South St. Paul","City",0,0,0,0,120170.48,313527.18]
["City of St. Cloud","City",375973,375973,159208,0,0,0]
["City of St. Louis Park","City",0,0,0,0,330429.02,848543.09]
["City of St. Michael","City",43670,43670,20472,0,0,0]
["City of St. Paul","City",0,0,0,0,2154208.31,5715601.9000000004]
["City of St. Peter","City",44412,44412,19021,0,0,0]
["City of Stillwater","City",0,0,0,0,94703.88,263644.78000000003]
["City of Vadnais Heights","City",0,0,0,0,80007.539999999994,209424.77]
["City of Victoria","City",0,0,0,0,19046.89,45951.45]
["City of Waconia","City",0,0,0,0,73322.559999999998,189363.37]
["City of West St. Paul","City",0,0,0,0,178000.86,455854.7]
["City of White Bear Lake","City",0,0,0,0,152905.66,425220.39]
["City of Willmar","City",101017,101017,43003,0,0,0]
["City of Winona","City",144224,144224,66319,0,0,0]
["City of Woodbury","City",0,0,0,0,301991.32,844476.59]
["City of Worthington","City",54658,54658,21766,0,0,0]
["Clay County","County",160402,160402,68698,0,0,0]
["Clearwater County","County",87386,87386,36798,0,0,0]
["Cook County","County",85028,85028,36266,0,0,0]
["Cottonwood County","County",88448,88448,37441,0,0,0]
["Crow Wing County","County",157496,157496,67171,0,0,0]
["Dakota County","County",516862,516862,223035,0,4103737.26,10926496.67]
["Dodge County","County",93433,93433,40097,0,0,0]
["Douglas County","County",125453,125453,51735,0,0,0]
["Faribault County","County",90527,90527,38594,0,0,0]
["Fillmore County","County",97456,97456,41342,0,0,0]
["Fond du Lac Band of Lake Superior Chippewa","Tribal Nation",385714,245454,120000,0,0,0]
["Freeborn County","County",108364,108364,45969,0,0,0]
["Goodhue County","County",131220,131220,55080,0,0,0]
["Grand Portage Band of Lake Superior Chippewa","Tribal Nation",385715,245454,120000,0,0,0]
["Grant County","County",84883,84883,36174,0,0,0]
["Hennepin County","County",1721944,1721944,727857,0,12451444.689999999,32714382.07]
["Houston County","County",96037,96037,40773,0,0,0]
["Hubbard County","County",101312,101312,43845,0,0,0]
["Isanti County","County",122212,122212,52489,0,0,0]
["Itasca County","County",129700,129700,55312,0,0,0]
["Jackson County","County",87062,87062,36831,0,0,0]
["Kanabec County","County",96260,96260,40842,0,0,0]
["Kandiyohi County","County",122693,122693,51249,0,0,0]
["Kittson County","County",80781,80781,34378,0,0,0]
["Koochiching County","County",92349,92349,38029,0,0,0]
["Lac qui Parle County","County",83765,83765,35766,0,0,0]
["Lake County","County",90572,90572,38487,0,0,0]
["Lake of the Woods County","County",81340,81340,35058,0,0,0]
["Le Sueur County","County",106520,106520,45146,0,0,0]
["Leech Lake Band of Ojibwe","Tribal Nation",385714,245454,120000,0,0,0]
["Lincoln County","County",84033,84033,35577,0,0,0]
["Lower Sioux Indian Community","Tribal Nation",0,245455,120000,0,0,0]
["Lyon County","County",104699,104699,44105,0,0,0]
["Mahnomen County","County",83251,83251,35410,0,0,0]
["Marshall County","County",86034,86034,36285,0,0,0]
["Martin County","County",98920,98920,41837,0,0,0]
["McLeod County","County",114903,114903,48908,0,0,0]
["Meeker County","County",100597,100597,42198,0,0,0]
["Mille Lacs Band of Ojibwe","Tribal Nation",385714,245455,120000,0,0,0]
["Mille Lacs County","County",109795,109795,46775,0,0,0]
["Morrison County","County",112042,112042,49009,0,0,0]
["Mower County","County",118725,118725,49088,0,0,0]
["Murray County","County",84536,84536,35956,0,0,0]
["Nicollet County","County",110745,110745,46446,0,0,0]
["Nobles County","County",97132,97132,40852,0,0,0]
["Norman County","County",83955,83955,35743,0,0,0]
["Olmsted County","County",241654,241654,105536,0,0,0]
["Otter Tail County","County",143671,143671,60846,0,0,0]
["Pennington County","County",93489,93489,39699,0,0,0]
["Pine County County","County",110119,110119,46761,0,0,0]
["Pipestone County","County",85643,85643,36428,0,0,0]
["Polk County","County",113550,113550,47686,0,0,0]
["Pope County","County",90147,90147,38358,0,0,0]
["Prairie Island Indian Community","Tribal Nation",0,245455,120000,0,0,0]
["Ramsey County","County",802161,802161,338397,0,6011349.6299999999,15929046.060000001]
["Red Lake County","County",82145,82145,34753,0,0,0]
["Red Lake Nation","Tribal Nation",385714,245454,120000,0,0,0]
["Redwood County","County",91063,91063,38566,0,0,0]
["Renville County","County",90359,90359,38376,0,0,0]
["Rice County","County",142218,142218,60795,0,0,0]
["Rock County","County",86381,86381,37108,0,0,0]
["Roseau County","County",90516,90516,38959,0,0,0]
["Scott County","County",211165,211165,89970,0,1903375.92,5072207.87]
["Shakopee Mdewakanton Sioux Community","Tribal Nation",0,245455,0,0,0,0]
["Sherburne County","County",157429,157429,68023,0,0,0]
["Sibley County","County",91857,91857,38867,0,0,0]
["St Louis County","County",321342,321342,137274,0,0,0]
["Stearns County","County",243252,243252,103699,0,0,0]
["Steele County","County",119261,119261,50532,0,0,0]
["Stevens County","County",86135,86135,36849,0,0,0]
["Swift County","County",88683,88683,37886,0,0,0]
["Todd County","County",99971,99971,42827,0,0,0]
["Traverse County","County",81262,81262,34517,0,0,0]
["Upper Sioux Community","Tribal Nation",0,245455,120000,0,0,0]
["Wabasha County","County",101100,101100,43614,0,0,0]
["Wadena County","County",93723,93723,40000,0,0,0]
["Waseca County","County",98138,98138,41338,0,0,0]
["Washington County","County",322672,322672,139277,0,2718726.98,7362701.5499999998]
["Watonwan County","County",87129,87129,37099,0,0,0]
["White Earth Nation","Tribal Nation",385714,245454,120000,0,0,0]
["Wilkin County","County",84894,84894,35752,0,0,0]
["Winona County","County",132885,132885,57588,0,0,0]
["Wright County","County",204973,204973,86879,0,0,0]
["Yellow Medicine County","County",86325,86325,36798,0,0,0]
["ALL COMBINED","ALL",{"$f":"SUM(C3:C203)","v":20250000},20250000,8750000,0,48314420.43,128117789.09000002]

{"sheet":"FYears","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Prior Fiscal Years",null,"Second Prior FY"]
["January 1, 2024 - December 31, 2024",null,"January 1, 2023 - December 31, 2023"]
["July 1, 2023 - June 30, 2024",null,"July 1, 2022 - June 30, 2023"]
["October 1, 2023 - September 30, 2024",null,"October 1, 2022 - September 30, 2023"]
[]
[]
[]
[]
["Prior Two Fiscal Years"]
["January 1, 2023 - December 31, 2024"]
["July 1, 2022 - June 30, 2024"]
["October 1, 2022 - September 30, 2024"]