{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Homebuyer","Instructions","Homeowner Rehab SETUP","Homeowner Rehab CHANGE ORDER","Rental","Homeowner Rehab CLOSEOUT","NDHFA use only - Master Data","Drop Down Options"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":40,"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":"Homebuyer","index":0,"n_rows":150,"n_cols":2,"rows_kept":150,"cut":false,"hidden":true,"merged":[[38,2,38,3],[33,2,33,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[136,0,136,1],[137,0,137,1],[144,0,144,1],[39,2,39,3],[40,2,40,3],[41,2,41,3],[125,0,125,1],[127,0,127,1]]}
["HOMEBUYER, HOMEOWNER, RENTAL ASSISTANCE HOUSING SETUP"]
["NORTH DAKOTA DEPARTMENT OF COMMERCE"]
["DIVISION OF COMMUNITY SERVICES "]
["SFN 61021 (01/2016)"]
["Page 1"]
["Recipient","Client Identifier"]
[]
["Instrument Number","Tenure Type"]
[]
["Activity Setup Type","Ownership Code"]
[]
["Regular HOME Funds","Program Income Funds"]
[]
["Other Funds","Estimated Total Cost"]
[null,{"$f":"SUM(A13+B13+A15)","v":0}]
["County","Homeowner Property"]
[]
["Rental Property","Units"]
[]
["HOME Assisted Units","Loan Guarantee"]
[]
["Rent Exception","Mixed Income"]
[]
["Mixed Use","FHA Insurance"]
[]
["504 Accessible","If Yes, Number of Units"]
[]
["CHDO Loan","CHDO Code"]
[]
["CHDO Pre-Development Loan"]
[]
[]
["Please list the HOME funds used for each of the following:"]
["Acquisition","Contingencies"]
[]
["Developers Fees","Electrical"]
[]
["General Construction","Plumbing"]
[]
["Recording Fees","Soft Costs"]
[]
["Weatherization","Total"]
[null,{"$f":"SUM(A35+B35+A37+B37+A39+B39+A41+B41+A43)","v":0}]
[]
["Enter Lead Based Paint Information Only if Applicable"]
["Exterior Paint Stabilization Amount:","Exterior Paint Stabilization Square Feet:"]
[]
["Interior Paint Stabilization Amount:","Interior Paint Stabilization Square Feet:"]
[]
["Clearance Testing","Relocation"]
[]
["Risk Assessment","Soil Cover"]
[]
["Testing","Unit Cleanup"]
[]
["Unit Preparation","Total Number of Unit Preparation"]
[]
["Window work","Total"]
[null,{"$f":"SUM(A47+A49+A51+B51+B53+A53+A55+B55+A57+A59)","v":0}]
[]
["Address 1"]
["Address Type","Telephone"]
[]
["First Name","Last Name"]
[]
["Address","City"]
[]
["State","ZIP Code"]
[]
[]
["Address 2"]
["Address Type","Telephone"]
[]
["First Name","Last Name"]
[]
["Address","City"]
[]
["State","ZIP Code"]
[]
[]
["Address 3"]
["Address Type","Telephone"]
[]
["First Name","Last Name"]
[]
["Address","City"]
[]
["State","ZIP Code"]
[]
[]
["Address 4"]
["Address Type","Telephone"]
[]
["First Name","Last Name"]
[]
["Address","City"]
[]
["State","ZIP Code"]
[]
[]
["Household 1"]
["Unit Number","Number of Bedrooms"]
[]
["Occupancy","Tenant Contribution"]
[]
["Subsidy Amount","Total Rent"]
[null,{"$f":"SUM(B105+A107)","v":0}]
["Ethnicity/Hispanic","Race-Head of Household"]
[]
["Gender-Head of Household","Type of Household"]
[]
["Rental Assistance","Monthly Gross Income"]
[]
["Size of Household","Annual Income"]
[null,{"$f":"B113*12","v":0}]
["Families with Children Over the Age of 18","Percent of Area Median Income"]
[]
["People with Disabilities"]
[]
[]
["HOME Objective"]
["The objective of this project is to: Provide Decent Housing"]
[]
["HOME Outcome"]
["The Outcome (or expected result) of this project is to increase:"]
[]
[]
["Note:  Normally the expected outcome for a HOME project is to increase the affordability of housing."]
[]
["Activity"]
["Project Location","Purpose of Activity"]
[]
["Purpose of Activity","Purpose of Activity"]
[]
["Purpose of Activity","Purpose of Activity"]
[]
["Will the activity be carried out by a faith-based organization:"]
[]
[]
["Signature of Authorized Official ","Date"]
[]
["Printed Name of Authorized Official","Title"]
[]
[]
["DCS Use Only"]
["IDIS","Release of Funds Date"]
[]
["Signature of DCS Staff","Date"]
[]
["Printed Name of DCS Staff","Title"]

{"sheet":"Instructions","index":1,"n_rows":83,"n_cols":1,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["HOMEOWNER REHABILITATION SETUP"]
["NORTH DAKOTA HOUSING FINANCE AGENCY"]
["Community Housing and Grants Management Division"]
["SFN 61021 (08/24)"]
["Page 1"]
[]
["For all Homeowner Rehabilitation Projects, please use the following instructions:"]
[]
["1) Fill out the Environmental Forms and submit to NDHFA. No work may begin on the project until you have"]
["received a signed release of funds (ROF) from NDHFA staff. Once you have received ROF, you may"]
["begin to sign contracts and begin construction. "]
["If work begins prior to receiving a ROF from NDHFA, the entire project is subject to re-payment"]
["and the agency completing the work will be responsible for all associated costs."]
["The Environmental Forms that must be completed can be found on the NDHFA website, Compliance Forms"]
["under Single Family Rehab"]
["a)  Site Specific Checklist"]
["b)  Floodplain Clearance"]
["c)  Section 106 Clearance"]
[]
["2) Complete the Homeowner Rehab SETUP form on EXCEL (see the 2nd tab of this form)."]
["Please fill in all of the fields on the Homeowner Rehab setup form.  Save the Excel form to your "]
["computer (perhaps create a folder on your computer for this specific project.) Then email the EXCEL "]
["version of the setup to NDHFA staff hfaplanning@nd.gov. It is helpful if we receive the setup prior to any "]
["cash requests, as we have to set up the project in IDIS and fund it. "]
[]
["NDHFA requires that the CPD Income Eligibility Calculator is used on every homeowner requesting"]
["rehab assistance. Please go to the following website: https://www.hudexchange.info/incomecalculator/  "]
["You will be required to create a log in on the HUD Exchange. There is a manual available on their website"]
["to walk you through the calculations. Your agency's homeowner rehab policy and procedures must"]
["indicate the income definition used for your program from one of the following:  24 CFR Part 5 (Section 8), "]
["Census Long Form, or the IRS Form 1040 Adjusted Gross Income.  The chosen income definition must"]
["be used for all homeowner rehab program participants.  Please print a copy of the CPD Income Calculator"]
["results for each client file. "]
[]
["Please ensure that the contractor selected to complete the work is not on the list of debarred contractors"]
["on the SAMS.gov website.  Please print out the search results from SAMS.gov, dated prior to awarding "]
["the contractor the job.  The SAMS.gov website has had a number of updates and changes in the last year."]
["There is no cost to use the SAMS.gov website.  Contractors will need to ensure they are registered on the"]
["SAMS.gov website annually.  Please visit SAMS.gov for their registration requirements.  "]
[]
["NDHFA recommends that all agencies have their own set of policies and procedures as it relates to the "]
["Homeowner Rehab program.  Included in those procedures, each agency should have an established"]
["'Walk Away Policy,' stating situations and circumstances in which the agency may walk away from a project."]
["The 'Walk Away Policy' must be signed and dated by the homeowner during application.  In addition,"]
["a preliminary LURA (Land Use Restrictive Covenance) should be signed prior to work beginning, stating"]
["the Period of Affordability and pay back period.  At project completion, an updated LURA should be signed,"]
["dated and recorded by the county recorder.  All LURAs should be filed and recorded within 30 days of"]
["completion. It is the agency's responsibility to release the LURA once the Period of Affordability has been"]
["satisfied and send proof of the release to NDHFA."]
[]
["3) Request Funds:  Once you have the project set up and NDHFA has issued an IDIS number to you,"]
["you may begin to request funds.  To request funds, please fill out the 'Request for Funds' "]
["SFN 59131 form found on the NDHFA website, Compliance Forms page under Single Family Rehab. "]
["Please fill out this form form and ensure that the authorized signer on your account is signing the request.  "]
["All cash requests must be sent to hfaplanning@nd.gov, as noted on page 2 of the 'Request for Funds' form"]
["Please include the assigned IDIS number on the cash request."]
[]
["4) Change orders:  Should the rehabilitation require a change order, please open your original setup "]
["form that is saved for this project on your computer.  Complete the CHANGE ORDER tab.  Then save"]
["the Excel document and send that Excel document to NDHFA staff hfainfo@nd.gov. "]
["NDHFA will need to work with the Rehab and Fiscal staff at your agency and add/decrease funding for "]
["the project."]
[]
["5) Closeout. Open up the most recent Excel file for this project (whether it was the original setup, or"]
["an updated form if you had change order(s) in the project.)  Go to the Homeowner Rehab CLOSEOUT"]
["tab.  Please complete all of the fields in the rehab closeout tab then save the EXCEL file and send an"]
["email to NDHFA staff hfainfo@nd.gov with the EXCEL attachment including all of the closeout information."]
["If you have a final cash request, you may include that PDF also. Please note, that NDHFA will hold the "]
["remaining 10% of HOME funds in the final cash request until the final closeout is received. "]
[]
["Nice work! Now, make sure you have your project binder assembled and TAKE PHOTOS of completed "]
["work immediately for monitoring purposes."]
[]
["*Note, Semi-Annual Progress Reports due January 31 and July 31 each year. "]
["Please be sure to work with your agency and submit the Semi-Annual Progress Reports to NDHFA"]
["by the specified deadlines."]
[]
["**For final grant closeout, please work with your agency and submit the grant closeout for all HOME funds."]
["Please pay attention to your financial award and grant end date.  Should your agency need more time to "]
["spend the funds, please submit an amendment to NDHFA prior to your financial award end date."]
[]
["Please refer to the annual HOME Program Distribution Statement found on the NDHFA website for more"]
["program information."]

{"sheet":"Homeowner Rehab SETUP","index":2,"n_rows":105,"n_cols":2,"rows_kept":105,"cut":false,"hidden":false,"merged":[[89,0,91,1],[26,2,26,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[38,2,38,3],[49,1,51,1]]}
["HOMEOWNER REHABILITATION SETUP"]
["NORTH DAKOTA HOUSING FINANCE AGENCY"]
["Community Housing and Grants Management"]
[{"$f":"Instructions!A4","v":"SFN 61021 (08/24)"}]
["Page 2"]
[]
["For a list of instructions, please go to the 'instructions' tab.  Thank you!"]
[]
["Recipient","Client's Last Name"]
["Affordable Housing Developers, Inc."]
["Instrument Number (Located on Financial Award)","Estimated HOME Funds - Hard Construction Costs"]
[null,{"$f":"B30+A38+B38+A40+B40+B42+A20+B20+B22","v":0}]
["Release of Funds Date (Date NDHFA signed ROF)","Estimated HOME Funds - Soft Costs "]
[null,{"$f":"A35+A42+A46+A52+A50+A22","v":0}]
["IDIS Number (NDHFA will provide, please fill in once known)","Estimated Total HOME Funds"]
[null,{"$f":"B12+B14","v":0}]
[]
["Grand Forks CLT - Acquisition/Homebuyer Down Payment Assistance Program Only:"]
["Estimated HOME Funds for Acquisition","Estimated HOME Funds for down payment assistance"]
[]
["Developers Fees","Contingencies"]
[]
[]
["Please list the HOME funds used for each of the following:"]
["Acquisition","Electrical"]
[]
["General Construction","Plumbing"]
[]
["Weatherization","Total "]
[null,{"$f":"SUM(A26+B26+A28+B28+A30)","v":0}]
[]
["Enter Lead Based Paint (LBP) Information Only if Applicable"]
["Pre Construction LBP Costs"]
["Risk Assessment / Testing (If built prior to 1978)","Year the house was built"]
[]
["Post Construction LBP Costs"]
["Exterior Paint Stabilization Amount","Window work"]
[]
["Interior Paint Stabilization Amount","Soil Cover"]
[]
["Clearance Testing","Unit Cleanup"]
[]
[]
["Relocation Costs"]
["Relocation Costs","Relocation Notes:"]
[]
[]
["Miscellaneous Soft Costs"]
["Soft Costs","Soft Costs Notes:"]
[]
["Recording Fees"]
[]
[]
["Address"]
["Address Type","Telephone"]
[]
["First Name","Last Name"]
[]
["Address","City"]
[]
["County","ZIP Code"]
[]
["Ownership Code","Homeowner Property"]
[]
["Occupancy"]
[]
[]
["Household Characteristics"]
["Number of Bedrooms","Race-Head of Household"]
[]
["Hispanic/Latino","Type of Household"]
[]
["Gender-Head of Household","People with Disabilities"]
[]
["Size of Household","Families with Children Over the Age of 18"]
[]
["Annual Gross Income ","Year HOME Income Limits Used"]
[]
["HOME Income Limit"]
[]
[]
["Please print the CPD Income Calculator Income Summary for the client file."]
["https://www.hudexchange.info/incomecalculator/"]
[]
["HOME Objective"]
["The objective of this project is to: Provide Decent Affordable Housing"]
[]
["HOME Outcome"]
["The Outcome (or expected result) of this project is to increase:"]
[]
[]
[]
[]
["Activity: check any and all that apply"]
["Special Characteristics:","Special Characteristics:"]
[]
["Special Characteristics:","Special Characteristics:"]
[]
["Special Characteristics:","Special Characteristics:"]
[]
["Will the activity be carried out by a faith-based organization:"]
[]
[]
["Agency Staff Information:"]
["Submitted to NDHFA by:","Date Submitted to NDHFA"]

{"sheet":"Homeowner Rehab CHANGE ORDER","index":3,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[[47,0,51,1],[21,0,24,1],[34,0,37,1]]}
["HOMEOWNER REHABILITATION CHANGE ORDER"]
["NORTH DAKOTA HOUSING FINANCE AGENCY"]
["Community Housing and Grants Management Division"]
[{"$f":"Instructions!A4","v":"SFN 61021 (08/24)"}]
["Page 3"]
[]
["Recipient","Client's Last Name"]
[{"$f":"'Homeowner Rehab SETUP'!A10","v":"Affordable Housing Developers, Inc."},{"$f":"'Homeowner Rehab SETUP'!B10","v":0}]
["Instrument Number (Found on Financial Award)","Orignal Amount of Estimated HOME Funds"]
[{"$f":"'Homeowner Rehab SETUP'!A12","v":0},{"$f":"'Homeowner Rehab SETUP'!B16","v":0}]
["IDIS Number (NDHFA will provide)","Release of Funds Date (Date NDHFA signed ROF)"]
[{"$f":"'Homeowner Rehab SETUP'!A16","v":0},{"$f":"'Homeowner Rehab SETUP'!A14","v":"00:00:00"}]
[]
["Change Order #1"]
["Additional HOME Funds Requested - Hard Costs","Instrument Number of Additional Funds Requested"]
[]
["Additonal HOME Funds Requested - Soft Costs","Current Project Total Estimate"]
[null,{"$f":"B10+A16+A18","v":0}]
["Date Approved by NDHFA"]
[]
["Reason for Change Order (Narrative Required):"]
[]
[]
[]
[]
[]
["Change Order #2"]
["Additional HOME Funds Requested - Hard Costs","Instrument Number of Additional Funds Requested"]
[]
["Additional HOME Funds Requested - Soft Costs","Current Project Total Estimate"]
[null,{"$f":"B10+A16+A18+A29+A31","v":0}]
["Date Approved by NDHFA"]
[]
["Reason for Change Order (Narrative Required):"]
[]
[]
[]
[]
[]
["Change Order #3"]
["Additional HOME Funds Requested - Hard Costs","Instrument Number of Additional Funds Requested"]
[]
["Additional HOME Funds Requested - Soft Costs","Current Project Total Estimate"]
[null,{"$f":"B10+A16+A18+A29+A31+A42+A44","v":0}]
["Date Approved by NDHFA"]
[]
["Reason for Change Order (Narrative Required):"]

{"sheet":"Rental","index":4,"n_rows":327,"n_cols":2,"rows_kept":327,"cut":false,"hidden":true,"merged":[[41,2,41,3],[314,0,314,1],[321,0,321,1],[33,2,33,3],[35,2,35,3],[302,0,302,1],[304,0,304,1],[313,0,313,1],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3]]}
["HOMEBUYER, HOMEOWNER, RENTAL ASSISTANCE HOUSING SETUP"]
["NORTH DAKOTA DEPARTMENT OF COMMERCE"]
["DIVISION OF COMMUNITY SERVICES "]
["SFN 61021 (01/2016)"]
["Page 3"]
["Recipient","Client Identifier"]
[]
["Instrument Number","Tenure Type"]
[]
["Activity Setup Type","Ownership Code"]
[]
["Regular HOME Funds","Program Income Funds"]
[]
["Other Funds","Estimated Total Cost"]
[null,{"$f":"SUM(A13+B13+A15)","v":0}]
["County","Homeowner Property"]
[]
["Rental Property","Units"]
[]
["HOME Assisted Units","Loan Guarantee"]
[]
["Rent Exception","Mixed Income"]
[]
["Mixed Use","FHA Insurance"]
[]
["504 Accessible","If Yes, Number of Units"]
[]
["CHDO Loan","CHDO Code"]
[]
["CHDO Pre-Development Loan"]
[]
[]
["Please list the HOME funds used for each of the following:"]
["Acquisition","Contingencies"]
[]
["Developers Fees","Electrical"]
[]
["General Construction","Plumbing"]
[]
["Recording Fees","Soft Costs"]
[]
["Weatherization","Total"]
[null,{"$f":"SUM(A35+B35+A37+B37+A39+B39+A41+B41+A43)","v":0}]
[]
["Enter Lead Based Paint Information Only if Applicable"]
["Exterior Paint Stabilization Amount:","Exterior Paint Stabilization Square Feet:"]
[]
["Interior Paint Stabilization Amount:","Interior Paint Stabilization Square Feet:"]
[]
["Clearance Testing","Relocation"]
[]
["Risk Assessment","Soil Cover"]
[]
["Testing","Unit Cleanup"]
[]
["Unit Preparation","Total Number of Unit Preparation"]
[]
["Window work","Total"]
[null,{"$f":"SUM(A47+A49+A51+B51+B53+A53+A55+B55+A57+A59)","v":0}]
[]
["Address 1"]
["Address Type","Telephone"]
[]
["First Name","Last Name"]
[]
["Address","City"]
[]
["State","ZIP Code"]
[]
[]
["Address 2"]
["Address Type","Telephone"]
[]
["First Name","Last Name"]
[]
["Address","City"]
[]
["State","ZIP Code"]
[]
[]
["Address 3"]
["Address Type","Telephone"]
[]
["First Name","Last Name"]
[]
["Address","City"]
[]
["State","ZIP Code"]
[]
[]
["Address 4"]
["Address Type","Telephone"]
[]
["First Name","Last Name"]
[]
["Address","City"]
[]
["State","ZIP Code"]
[]
[]
["Household 1"]
["Unit Number","Number of Bedrooms"]
[]
["Occupancy","Tenant Contribution"]
[]
["Subsidy Amount","Total Rent"]
[null,{"$f":"SUM(B105+A107)","v":0}]
["Ethnicity/Hispanic","Race-Head of Household"]
[]
["Gender-Head of Household","Type of Household"]
[]
["Rental Assistance","Monthly Gross Income"]
[]
["Size of Household","Annual Income"]
[null,{"$f":"B113*12","v":0}]
["Families with Children Over the Age of 18","Percent of Area Median Income"]
[]
["People with Disabilities"]
[]
[]
["Household 2"]
["Unit Number","Number of Bedrooms"]
[]
["Occupancy","Tenant Contribution"]
[]
["Subsidy Amount","Total Rent"]
[null,{"$f":"SUM(B125+A127)","v":0}]
["Ethnicity/Hispanic","Race-Head of Household"]
[]
["Gender-Head of Household","Type of Household"]
[]
["Rental Assistance","Monthly Gross Income"]
[]
["Size of Household","Annual Income"]
[null,{"$f":"B133*12","v":0}]
["Families with Children Over the Age of 18","Percent of Area Median Income"]
[]
["People with Disabilities"]
[]
[]
["Household 3"]
["Unit Number","Number of Bedrooms"]
[]
["Occupancy","Tenant Contribution"]
[]
["Subsidy Amount","Total Rent"]
[null,{"$f":"SUM(B145+A147)","v":0}]
["Ethnicity/Hispanic","Race-Head of Household"]
[]
["Gender-Head of Household","Type of Household"]
[]
["Rental Assistance","Monthly Gross Income"]
[]
["Size of Household","Annual Income"]
[null,{"$f":"B153*12","v":0}]
["Families with Children Over the Age of 18","Percent of Area Median Income"]
[]
["People with Disabilities"]
[]
[]
["Household 4"]
["Unit Number","Number of Bedrooms"]
[]
["Occupancy","Tenant Contribution"]
[]
["Subsidy Amount","Total Rent"]
[null,{"$f":"SUM(B165+A167)","v":0}]
["Ethnicity/Hispanic","Race-Head of Household"]
[]
["Gender-Head of Household","Type of Household"]
[]
["Rental Assistance","Monthly Gross Income"]
[]
["Size of Household","Annual Income"]
[null,{"$f":"B173*12","v":0}]
["Families with Children Over the Age of 18","Percent of Area Median Income"]
[]
["People with Disabilities"]
[]
[]
["Household 5"]
["Unit Number","Number of Bedrooms"]
[]
["Occupancy","Tenant Contribution"]
[]
["Subsidy Amount","Total Rent"]
[null,{"$f":"SUM(B185+A187)","v":0}]
["Ethnicity/Hispanic","Race-Head of Household"]
[]
["Gender-Head of Household","Type of Household"]
[]
["Rental Assistance","Monthly Gross Income"]
[]
["Size of Household","Annual Income"]
[null,{"$f":"B193*12","v":0}]
["Families with Children Over the Age of 18","Percent of Area Median Income"]
[]
["People with Disabilities"]
[]
[]
["Household 6"]
["Unit Number","Number of Bedrooms"]
[]
["Occupancy","Tenant Contribution"]
[]
["Subsidy Amount","Total Rent"]
[null,{"$f":"SUM(B205+A207)","v":0}]
["Ethnicity/Hispanic","Race-Head of Household"]
[]
["Gender-Head of Household","Type of Household"]
[]
["Rental Assistance","Monthly Gross Income"]
[]
["Size of Household","Annual Income"]
[null,{"$f":"B213*12","v":0}]
["Families with Children Over the Age of 18","Percent of Area Median Income"]
[]
["People with Disabilities"]
[]
[]
["Household 7"]
["Unit Number","Number of Bedrooms"]
[]
["Occupancy","Tenant Contribution"]
[]
["Subsidy Amount","Total Rent"]
[null,{"$f":"SUM(B225+A227)","v":0}]
["Ethnicity/Hispanic","Race-Head of Household"]
[]
["Gender-Head of Household","Type of Household"]
[]
["Rental Assistance","Monthly Gross Income"]
[]
["Size of Household","Annual Income"]
[null,{"$f":"B233*12","v":0}]
["Families with Children Over the Age of 18","Percent of Area Median Income"]
[]
["People with Disabilities"]
[]
[]
["Household 8"]
["Unit Number","Number of Bedrooms"]
[]
["Occupancy","Tenant Contribution"]
[]
["Subsidy Amount","Total Rent"]
[null,{"$f":"SUM(B245+A247)","v":0}]
["Ethnicity/Hispanic","Race-Head of Household"]
[]
["Gender-Head of Household","Type of Household"]
[]
["Rental Assistance","Monthly Gross Income"]
[]
["Size of Household","Annual Income"]
[null,{"$f":"B253*12","v":0}]
["Families with Children Over the Age of 18","Percent of Area Median Income"]
[]
["People with Disabilities"]
[]
[]
["Household 9"]
["Unit Number","Number of Bedrooms"]
[]
["Occupancy","Tenant Contribution"]
[]
["Subsidy Amount","Total Rent"]
[null,{"$f":"SUM(B265+A267)","v":0}]
["Ethnicity/Hispanic","Race-Head of Household"]
[]
["Gender-Head of Household","Type of Household"]
[]
["Rental Assistance","Monthly Gross Income"]
[]
["Size of Household","Annual Income"]
[null,{"$f":"B273*12","v":0}]
["Families with Children Over the Age of 18","Percent of Area Median Income"]
[]
["People with Disabilities"]
[]
[]
["Household 10"]
["Unit Number","Number of Bedrooms"]
[]
["Occupancy","Tenant Contribution"]
[]
["Subsidy Amount","Total Rent"]
[null,{"$f":"SUM(B285+A287)","v":0}]
["Ethnicity/Hispanic","Race-Head of Household"]
[]
["Gender-Head of Household","Type of Household"]
[]
["Rental Assistance","Monthly Gross Income"]
[]
["Size of Household","Annual Income"]
[null,{"$f":"B293*12","v":0}]
["Families with Children Over the Age of 18","Percent of Area Median Income"]
[]
["People with Disabilities"]
[]
[]
["HOME Outcome "]
["The Outcome (or expected result) of this project is to increase:"]
[]
[]
["Note:  Normally the expected outcome for a HOME project is to increase the affordability of housing."]
[]
["Activity"]
["Project Location","Purpose of Activity"]
[]
["Purpose of Activity","Purpose of Activity"]
[]
["Purpose of Activity","Purpose of Activity"]
[]
["Will the activity be carried out by a faith-based organization:"]
[]
[]
["Signature of Authorized Official ","Date"]
[]
["Printed Name of Authorized Official","Title"]
[]
[]
["DCS Use Only"]
["IDIS","Release of Funds Date"]
[]
["Signature of DCS Staff","Date"]
[]
["Printed Name of DCS Staff","Title"]

{"sheet":"Homeowner Rehab CLOSEOUT","index":5,"n_rows":44,"n_cols":2,"rows_kept":44,"cut":false,"hidden":false,"merged":[[13,0,15,1],[34,0,36,1]]}
["HOMEOWNER REHABILITATION CLOSE OUT"]
[{"$f":"'Homeowner Rehab SETUP'!A2","v":"NORTH DAKOTA HOUSING FINANCE AGENCY"}]
[{"$f":"'Homeowner Rehab SETUP'!A3","v":"Community Housing and Grants Management"}]
[{"$f":"'Homeowner Rehab SETUP'!A4","v":"SFN 61021 (08/24)"}]
["Page 4"]
[]
["Recipient","Client's Last Name"]
[{"$f":"'Homeowner Rehab SETUP'!A10","v":"Affordable Housing Developers, Inc."},{"$f":"'Homeowner Rehab SETUP'!B10","v":0}]
["Instrument Number ","Total HOME Funds"]
[{"$f":"'Homeowner Rehab SETUP'!A12","v":0},{"$f":"'Homeowner Rehab CHANGE ORDER'!B44","v":0}]
["IDIS Number (NDHFA provided at setup)","Release of Funds Date (Date NDHFA signed ROF)"]
[{"$f":"'Homeowner Rehab SETUP'!A16","v":0},{"$f":"'Homeowner Rehab SETUP'!A14","v":"00:00:00"}]
["Completion Narrative: (An optional description of accomplishments occurring for the activity.)"]
[]
[]
[]
["HOME Units Completed that are Section 504 Accessible","Total HOME-Assisted Units that Qualify as Energy Star"]
[]
["Property FHA Insured","Value After Rehabilitation"]
[]
["Applicable Lead Based Paint Requirement:","Lead Hazard Remediation Actions:"]
[]
[]
["Final Project Costs"]
["Total HOME Funds in Project","Owner Cash Contributions"]
[{"$f":"B10","v":0}]
["Other Federal Funds","State or Local Funds"]
[]
["Private Loans/Grants/Bonds","Total"]
[null,{"$f":"SUM(A26+B26+A28+B28+A30)","v":0}]
["Form of HOME Assistance:"]
[]
[]
["Please provide comments on any match provided to the project:"]
[]
[]
[]
[]
["Period of Affordability"]
["Period of Affordability"]
[]
[]
["NDHFA Use Only:"]
["Date Completed in IDIS","Period of Affordability End Date"]

{"sheet":"NDHFA use only - Master Data","index":6,"n_rows":12,"n_cols":34,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["HOMEOWNER REHABILITATION MASTER DATA"]
[{"$f":"'Homeowner Rehab SETUP'!A2","v":"NORTH DAKOTA HOUSING FINANCE AGENCY"}]
[{"$f":"'Homeowner Rehab SETUP'!A3","v":"Community Housing and Grants Management"}]
[{"$f":"'Homeowner Rehab SETUP'!A4","v":"SFN 61021 (08/24)"}]
["Page 5"]
[]
["Date Closed in IDIS","Open/Closed",{"$f":"'Homeowner Rehab SETUP'!A9","v":"Recipient"},"Client's Last Name","IDIS No.","Date Submitted to NDHFA","Regular HOME Funds","Soft Costs","Estimated Total Cost","CLT-Acquisition","CLT-Down Payment","Year House Built","Address","City","County","Homeowner Property","# of Bedrooms","Race-Head of Household","Ethnicity/Hispanic","Type of Household","Gender-Head of Household","Ppl. w/ Disabilities","Size of Household","Families with Children Over the Age of 18","% AMI","Applicable Lead Paint Requirement","Lead Hazard Remediation Actions","HOME Funds","Owner Cash Contributions","Other Federal Funds","State/Local Funds","Private grants/loans/bonds","Total","POA"]
[{"$f":"'Homeowner Rehab CLOSEOUT'!A45","v":"00:00:00"},null,{"$f":"'Homeowner Rehab SETUP'!A10","v":"Affordable Housing Developers, Inc."},{"$f":"'Homeowner Rehab SETUP'!B10","v":0},{"$f":"'Homeowner Rehab SETUP'!A16","v":0},{"$f":"'Homeowner Rehab SETUP'!B106","v":"00:00:00"},{"$f":"'Homeowner Rehab SETUP'!B12","v":0},{"$f":"'Homeowner Rehab SETUP'!B14","v":0},{"$f":"'Homeowner Rehab SETUP'!B16","v":0},{"$f":"'Homeowner Rehab SETUP'!A20","v":0},{"$f":"'Homeowner Rehab SETUP'!B20","v":0},{"$f":"'Homeowner Rehab SETUP'!B35","v":0},{"$f":"'Homeowner Rehab SETUP'!A60","v":0},{"$f":"'Homeowner Rehab SETUP'!B60","v":0},{"$f":"'Homeowner Rehab SETUP'!A62","v":0},{"$f":"'Homeowner Rehab SETUP'!B64","v":0},{"$f":"'Homeowner Rehab SETUP'!A70","v":0},{"$f":"'Homeowner Rehab SETUP'!B70","v":0},{"$f":"'Homeowner Rehab SETUP'!A72","v":0},{"$f":"'Homeowner Rehab SETUP'!B72","v":0},{"$f":"'Homeowner Rehab SETUP'!A74","v":0},{"$f":"'Homeowner Rehab SETUP'!B74","v":0},{"$f":"'Homeowner Rehab SETUP'!A76","v":0},{"$f":"'Homeowner Rehab SETUP'!B76","v":0},{"$f":"'Homeowner Rehab SETUP'!A80","v":0},{"$f":"'Homeowner Rehab CLOSEOUT'!A22","v":0},{"$f":"'Homeowner Rehab CLOSEOUT'!B22","v":0},{"$f":"'Homeowner Rehab CLOSEOUT'!A26","v":0},{"$f":"'Homeowner Rehab CLOSEOUT'!B26","v":0},{"$f":"'Homeowner Rehab CLOSEOUT'!A28","v":0},{"$f":"'Homeowner Rehab CLOSEOUT'!B28","v":0},{"$f":"'Homeowner Rehab CLOSEOUT'!A30","v":0},{"$f":"'Homeowner Rehab CLOSEOUT'!B30","v":0},{"$f":"'Homeowner Rehab CLOSEOUT'!A41","v":0}]
[]
[null,"Homebuyer",{"$f":"Homebuyer!A7","v":0},{"$f":"Homebuyer!B7","v":0},{"$f":"Homebuyer!A147","v":0},null,{"$f":"Homebuyer!A13","v":0},null,{"$f":"Homebuyer!B15","v":0},null,null,null,{"$f":"Homebuyer!A67","v":0},{"$f":"Homebuyer!B67","v":0},{"$f":"Homebuyer!A69","v":0},{"$f":"Homebuyer!B17","v":0},{"$f":"Homebuyer!B103","v":0},{"$f":"Homebuyer!B109","v":0},{"$f":"Homebuyer!A109","v":0},{"$f":"Homebuyer!B111","v":0},{"$f":"Homebuyer!A111","v":0},{"$f":"Homebuyer!A119","v":0},{"$f":"Homebuyer!A115","v":0},{"$f":"Homebuyer!A117","v":0},{"$f":"Homebuyer!B117","v":0}]
[]
[null,"Rental",{"$f":"Rental!A7","v":0},{"$f":"Rental!B7","v":0},{"$f":"Rental!A324","v":0},null,{"$f":"Rental!A13","v":0},null,{"$f":"Rental!B15","v":0},null,null,null,{"$f":"Rental!A67","v":0},{"$f":"Rental!B67","v":0},{"$f":"Rental!A69","v":0},{"$f":"Rental!B17","v":0},{"$f":"Rental!B103","v":0},{"$f":"Rental!B109","v":0},{"$f":"Rental!A109","v":0},{"$f":"Rental!B111","v":0},{"$f":"Rental!A111","v":0},{"$f":"Rental!A119","v":0},{"$f":"Rental!A115","v":0},{"$f":"Rental!A117","v":0},{"$f":"Rental!B117","v":0}]

{"sheet":"Drop Down Options","index":7,"n_rows":144,"n_cols":6,"rows_kept":144,"cut":false,"hidden":true,"merged":[]}
["SFN     (5/18)"]
["Page 6"]
[]
["Affordable Housing Developers, Inc.",null,"05S","24 CFR Part 5 (Section 8)"]
["Cass County Housing Authority ",null,"05T","Census Long Form"]
["City of Bismarck",null,12,"IRS Form 1040 Adjusted Gross Income"]
["City of Fargo",null,13]
["City of Grand Forks ",null,"14A"]
["CAP I & VIII - Dickinson/Williston",null,"14B"]
["CAP II - Minot ",null,"14G"]
["CAP III - Dakota Prairie ",null,"14I"]
["CAP IV - Red River Valley",null,"21A"]
["CAP V - SENDCAA",null,"21H"]
["CAP VI - Jamestown",null,"21I"]
["CAP VII - Bismarck ",null,"O"]
["Grand Forks Community Land Trust (GF CLT)"]
["Great Plains Housing Authority ",null,"Acquisition"]
[null,null,"Acquisition and New Construction"]
["Yes",null,"Acquisition and Rehabilitation"]
["No",null,"New Construction"]
[]
["Female",null,"Corporation"]
["Male ",null,"Individual"]
["Other",null,"Non-For-Profit"]
["Elderly",null,"Other"]
["Other",null,"Partnership"]
["Single Parent",null,"Publicly Owned"]
["Two Parent"]
["Single / Non-elderly",null,"1-4 Single Family"]
["Vacant",null,"Condominium"]
[null,null,"Cooperative"]
["1 Bedroom",null,"Manufactured Home"]
["2 Bedrooms"]
["3 Bedrooms",null,"Cooperative"]
["4 Bedrooms",null,"Other "]
["5 or more Bedrooms",null,"SRO"]
["Group Home"]
["SRO or Efficiency ",null,"Developed"]
[null,null,"Owned"]
["1 Person",null,"Sponsored"]
["2 People"]
["3 People",null,"Acquisition","Acquisition"]
["4 People",null,"Acquisition and New Construction","Acquisition and New Construction"]
["5 People",null,"Acquisition and Rehabilitation","Acquisition and Rehabilitation"]
["6 People ",null,"New Construction","New Construction"]
["7 People",null,"Rehabilitation","Rehabilitation",null,"Rehabilitation"]
["8 People or More"]
["Vacant Unit",null,"Owner "]
[null,null,"Tenant"]
[null,null,"Vacant"]
["0% - 30% HOME Income Limits"]
["31% - 50% HOME Income Limits",null,"HOME Tenant Based Rental Assistance (TBRA)"]
["51% - 60% HOME Income Limits",null,"No Assistance"]
["61% - 80% HOME Income Limits",null,"Other"]
[null,null,"Section 8"]
[null,null,"Vacant Unit"]
["Adams County"]
["Barnes County",null,"Homebuyer"]
["Benson County",null,"Homeowner"]
["Billings County",null,"Rental"]
["Bottineau County"]
["Bowman County"]
["Burke County"]
["Burleigh County",null,"Housing constructed before 1978"]
["Cass County",null,"Exempt:  Housing Constructed 1978 or Later"]
["Cavalier County",null,"Otherwise Exempt"]
["Dickey County"]
["Divide County",null,"Lead Safe Work Practices (24 CFR 35.930 (b))  (Hard costs <=$5,000)"]
["Dunn County",null,"Interim Controls or Standard Practices (24 CFR 25.930 (c)) (Hard Costs $5,000-$25,000)"]
["Eddy County",null,"Abatement (24 CFR 35.930 (d))  (Hard costs > $25,000)"]
["Emmons County"]
["Foster County"]
["Golden Valley County",null,"5 Years"]
["Grand Forks County",null,"10 Years"]
["Grant County",null,"15 Years"]
["Griggs County",null,"20 Years"]
["Hettinger County"]
["Kidder County"]
["LaMoure County",null,2017]
["Logan County",null,2018]
["McHenry County",null,2019]
["McIntosh County",null,2020]
["McKenzie County",null,2021]
["McLean County",null,2022]
["Mercer County",null,2023]
["Morton County",null,2024]
["Mountrail County"]
["Nelson County"]
["Oliver County"]
["Pembina County"]
["Pierce County"]
["Ramsey County"]
["Ransom County"]
["Renville County"]
["Richland County"]
["Rolette County"]
["Sargent County"]
["Sheridan County"]
["Sioux County"]
["Slope County"]
["Stark County"]
["Steele County"]
["Stutsman County"]
["Towner County"]
["Traill County"]
["Walsh County"]
["Ward County"]
["Wells County"]
["Williams County"]
[]
["White"]
["Black / African American"]
["Asian"]
["American Indian / Alaskan Native"]
["Native Hawaiian / Other Pacific Islander"]
["American Indian / Alaskan Native and White"]
["Asian and White"]
["Black / African American and White"]
["American Indian / Alaskan Native / Black / African American"]
["Other Multi-Racial"]
[]
["Owner Mailing"]
["Property"]
["Property Mailing"]
["Property Owner"]
[]
["Availability/Accessibility: Applies to activities that make housing available or accessible to LMI families, including persons with disabilities."]
["Affordability:  Applies to activities that provide affordability in a variety of ways to LMI families.  It can include the creation or maintenance of affordable housing.  Affordability is an appropriate objective whenever an activity is lowering the cost, improving the quality, or increasing the affordability of the housing."]
["Sustainability:  Applies to activities that are aimed at improving communities or neighborhoods, helping to make them livable or viable by providing benefits to LMI families."]
[]
["CDBG Strategy Area"]
["Local Target Area",null,"Help prevent homelessness"]
["Presidential declared major disaster area",null,"Help the Homeless"]
["Historic Preservation Area",null,"Help those with HIV/AIDS"]
["Brownfiend Redevelopment Area",null,"Primarily help persons with disabilities"]
["Conversion from Non-Residential to Residential Use",null,"Generate Program Income"]
[]
[]
[]
["Form of HOME Assistance:"]
["Deferred Payment Loan"]
["Grant"]
["Amortized Loan"]
["Other"]