{"text_format":"3","workbook":"xlsx","n_sheets":20,"sheets":["Instructions","Section 1","Section 2","Section 3","Section 3 (1)","Section 4","Section 5","Section 6","Section 7","Section 8","Section 9","Section 10","Section 11","Section 12","Section 13","Section 14","Section 15","Section 16","Section 16 (1)","Section 16 - Funds - Signature"],"not_rendered":{"images":124,"macros":1,"defined_names":224,"comments":19},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Section 1","index":1,"n_rows":55,"n_cols":3,"rows_kept":55,"merged":[[9,0,9,1],[11,0,11,1],[13,0,13,2],[20,0,20,2],[22,0,22,2],[23,0,23,1],[24,0,24,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[31,0,31,1],[32,0,32,2],[33,0,33,1],[34,0,34,2],[35,0,35,2],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[48,0,48,1],[52,0,52,2],[54,0,54,2]]}
[]
["SECTION 1: COVER PAGE"]
[]
["(1) Grant Number:"]
[]
["(2) Recipient Program Year:"]
[]
["(3) Federal Fiscal Year:"]
[]
["(4)       Initial Plan (Complete this Section then proceed to Section 2)",null,"  "]
[]
["(5)       Amended Plan (Complete this Section and Section 16)"]
["          "]
["(6)       Annual Performance Report (Complete items 27-30 and proceed to Section 3)"]
[]
["(7)       Tribe"]
[]
["(8)       TDHE"]
[]
["(9) Name of Recipient:"]
[]
["(10) Contact Person:"]
[]
["(11) Telephone Number with Area Code:"]
[]
["(12) Mailing Address:"]
[]
[]
[]
["(13) City:","(14) State:","(15) Zip Code:"]
[]
["(16) Fax Number with Area Code (if available):"]
[]
["(17) Email Address (if available):"]
[]
["(18) If TDHE, List Tribes Below:"]
[]
["(19) Tax Identification Number:"]
["(20) DUNS Number:"]
["(21) CCR Expiration Date:"]
["(22) IHBG Fiscal Year Formula Amount:"]
["(23) Name of Authorized IHP Submitter: "]
["(24) Title of Authorized IHP Submitter: "]
["(25) Signature of Authorized IHP Submitter: "]
["(26) IHP Submission Date: "]
["(27) Name of Authorized APR Submitter: "]
["(28) Title of Authorized APR Submitter: "]
["(29) Signature of Authorized APR Submitter: "]
["(30) APR Submission Date: "]
[]
[]
[]
["Certification: The information contained in this document is accurate and reflects the activities actually planned or accomplished during the program year.  Activities planned and accomplished are eligible under applicable statutes and regulations."]
[]
["Warning: If you knowingly make a false statement on this form, you may be subject to civil or criminal penalties under Section 1001 of Title 18 of the United States Code.  In addition, any person who knowingly and materially violates any required disclosure of information, including intentional disclosure, is subject to a civil money penalty not to exceed $10,000 for each violation."]

{"sheet":"Section 2","index":2,"n_rows":30,"n_cols":3,"rows_kept":30,"merged":[[0,0,0,2],[5,0,5,2],[7,1,7,2],[23,0,23,2],[26,0,26,2],[29,0,29,2]]}
["ONE YEAR PLAN & ANNUAL PERFORMANCE REPORT"]
[]
["SECTION 2: HOUSING NEEDS "]
["NAHASDA § 102(b)(2)(B)"]
[]
["(1)   Type of Need: Check the appropriate box(es) below to describe the estimated types of housing needs and the need for other assistance for low-income Indian families (column B) and all Indian  families (column C) inside and outside the jurisdiction.  "]
[]
[null,"Check All That Apply"]
["(A) ","(B)","(C)"]
["Type of Need"]
[null,"Low-Income Indian Families","All Indian Families"]
["(1)     Overcrowded Households "]
["(2)     Renters Who Wish to Become Owners "]
["(3)     Substandard Units Needing Rehabilitation"]
["(4)     Homeless Households "]
["(5)     Households Needing Affordable Rental Units"]
["(6)     College Student Housing "]
["(7)     Disabled Households Needing Accessibility"]
["(8)     Units Needing Energy Efficiency Upgrades"]
["(9)     Infrastructure to Support Housing"]
["(10)  Other (specify below)"]
[]
[]
["(2)   Other Needs. (Describe the “Other” needs below.  Note: this text is optional for all needs except “Other.”): "]
[]
[]
["(3) Planned Program Benefits. (Describe below how your planned programs and activities will address the needs of low income families identified above.  Also describe how your planned programs will address the various types of housing assistance needs.  NAHASDA  § 102(b)(2)(B)):  "]
[]
[]
["(4)   Geographic Distribution. (Describe below how the assistance will be distributed throughout the geographic area and how this geographic distribution is consistent with the needs of low income families.  NAHASDA § 102(b)(2)(B)(i)):  "]

{"sheet":"Section 3","index":3,"n_rows":100,"n_cols":27,"rows_kept":100,"hidden":true,"merged":[[5,0,6,3],[24,0,24,1],[24,2,24,3],[25,0,25,1],[25,2,25,3],[26,0,26,1],[26,2,26,3],[27,0,27,1],[27,2,27,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[30,0,30,1],[30,2,30,3],[33,0,33,3],[34,0,34,3],[36,0,36,3],[39,0,39,3],[45,0,45,3],[47,1,47,2],[48,0,48,2],[50,0,50,2],[51,0,51,2],[52,0,52,2],[54,0,54,2],[55,0,55,3],[57,0,57,3],[59,0,59,3],[61,0,61,3],[63,0,63,3],[99,0,99,3]]}
[null,null,"",{"$nulls":10},"(1) Modernization of 1937 Act Housing [202(1)]","(1) Reduce over-crowding "]
["SECTION 3: PROGRAM DESCRIPTIONS",{"$nulls":11},1,"(2) Operation of 1937 Act Housing [202(1)]","(2) Assist renters to become homeowners"]
["NAHASDA §§ 102(b)(2)(A), 233(a), 235(c),  404(b); 24 CFR §1000.512  ",{"$nulls":11},2,"(3) Acquisition of Rental Housing [202(2)]","(3) Improve quality of substandard units"]
[{"$nulls":12},3,"(4) Construction of Rental Housing [202(2)]","(4) Improve quality of existing infrastructure "]
["Planning and Reporting Program Year Activities",{"$nulls":11},4,"(5) Rehabilitation of Rental Housing [202(2)]","(5) Address homelessness"]
["For the IHP, the purpose of this section is to describe each program that will be operating during the 12-month program year.  Each program must include the eligible activity, its intended outcome, planned outputs, who will be assisted, and types and levels of assistance.  Each of the eligible activities has a specific, measurable output, as shown below.  Copy and paste text boxes 1.1 through 1.10 as often as needed so that all of your planned programs are included.  For the APR, the purpose of this section is to describe your accomplishments, actual outputs, and any reasons for delays.   ",{"$nulls":11},5,"(6) Acquisition of Land for Rental Housing Development [202(2)] ","(6) Assist affordable housing for low income households"]
[{"$nulls":13},"(7) Development of Emergency Shelters [202(2)]","(7) Create new affordable rental units"]
[{"$nulls":12},6,"(8) Conversion of Other Structures to Affordable Housing [202(2)]","(8) Assist affordable housing for college students"]
["Eligible Activity May Include (citations below all reference sections in NAHASDA):",{"$nulls":11},8,"(9) Other Rental Housing Development [202(2)] ","(9) Provide accessibility for disabled/elderly persons"]
["Eligible Activity","Output Measure","Eligible Activity","Output Measure",{"$nulls":9},"(10) Acquisition of Land for Homebuyer Unit Development [202(2)]","(10) Improve energy efficiency"]
["(1) Modernization of 1937 Act Housing [202(1)]","Units","(13) Down Payment/Closing Cost Assistance [202(2)]","Units",{"$nulls":8},9,"(11) New Construction of Homebuyer Units [202(2)]","(11) Reduction in crime reports"]
["(2) Operation of 1937 Act Housing [202(1)]","Units","(14) Lending Subsidies for Homebuyers (Loan) [202(2)]","Units",{"$nulls":8},10,"(12) Acquisition of Homebuyer Units [202(2)]","(12) Other – must provide description in boxes 1.4 (IHP) and 1.5 (APR) below"]
["(3) Acquisition of Rental Housing [202(2)]","Units","(15) Other Homebuyer Assistance Activities [202(2)]","Units",{"$nulls":8},11,"(13) Down Payment/Closing Cost Assistance [202(2)]"]
["(4) Construction of Rental Housing [202(2)]","Units","(16) Rehabilitation Assistance to Existing Homeowners [202(2)]","Units",{"$nulls":8},12,"(14) Lending Subsidies for Homebuyers (Loan) [202(2)]"]
["(5) Rehabilitation of Rental Housing [202(2)]","Units","(17) Tenant Based Rental Assistance [202(3)]","Households",{"$nulls":8},13,"(15) Other Homebuyer Assistance Activities [202(2)]"]
["(6) Acquisition of Land for Rental Housing Development [202(2)] ","Acres","(18) Other Housing Services [202(3)]","Households",{"$nulls":8},14,"(16) Rehabilitation Assistance to Existing Homeowners [202(2)]"]
["(7) Development of Emergency Shelters [202(2)]","Households","(19) Housing Management Services [202(4)]","Households",{"$nulls":8},15,"(17) Tenant Based Rental Assistance [202(3)]"]
["(8) Conversion of Other Structures to Affordable Housing [202(2)]","Units","(20) Operation and Maintenance of NAHASDA-Assisted Units [202(4)]","Units",{"$nulls":8},16,"(18) Other Housing Services [202(3)]"]
["(9) Other Rental Housing Development [202(2)] ","Units","(21) Crime Prevention and Safety [202(5)]","Dollars",{"$nulls":8},17,"(19) Housing Management Services [202(4)]"]
["(10) Acquisition of Land for Homebuyer Unit Development [202(2)]","Acres","(22) Model Activities [202(6)]","Dollars",{"$nulls":8},18,"(20) Operation and Maintenance of NAHASDA-Assisted Units [202(4)]"]
["(11) New Construction of Homebuyer Units [202(2)]","Units","(23) Self-Determination Program [231-235] ","Units/Dollars",{"$nulls":8},19,"(21) Crime Prevention and Safety [202(5)]"]
["(12) Acquisition of Homebuyer Units [202(2)]","Units","(24) Infrastructure to Support Housing [202(2)] ","Dollars",{"$nulls":8},20,"(22) Model Activities [202(6)]"]
[{"$nulls":12},22,"(23) Self-Determination Program [231-235] "]
["Outcome May Include:",{"$nulls":11},23,"(24) Infrastructure to Support Housing [202(2)] "]
[]
["(1) Reduce over-crowding ",null,"(7) Create new affordable rental units"]
["(2) Assist renters to become homeowners",null,"(8) Assist affordable housing for college students"]
["(3) Improve quality of substandard units",null,"(9) Provide accessibility for disabled/elderly persons"]
["(4) Improve quality of existing infrastructure ",null,"(10) Improve energy efficiency"]
["(5) Address homelessness",null,"(11) Reduction in crime reports"]
["(6) Assist affordable housing for low income households",null,"(12) Other – must provide description in boxes 1.4 (IHP) and 1.5 (APR) below"]
[]
["IHP: PLANNED PROGRAM YEAR ACTIVITIES (NAHASDA § 102(b)(2)(A))"]
["For each planned activity, complete all the non-shaded sections below.  It is recommended that for each program name you assign a unique identifier to help distinguish individual programs.   This unique number can be any number of your choosing, but it should be simple and clear so that you and HUD can track tasks and results under the program and collect appropriate file documentation tied to this program.  "]
["§  One way to number your programs is chronologically.  For example, you could number your programs 2011-1, "]
["    2011-2, 2011-3 etc."]
["§  Or, you may wish to number the programs based on type.  For example rental 1, rental 2, homebuyer1,"]
["    homebuyer 2 etc.  This type of numbering system might be appropriate if you have many programs"]
["    that last over several years."]
["§  Finally, you may wish to use an outline style of numbering.  For example, all programs under your first"]
["    eligible activity would start with the number 1 and then be consecutively numbered as 1.1, 1.2, 1.3 etc. "]
["    The programs under the second eligible activity would be numbered as 2.1, 2.2, 2.3 etc."]
[]
["APR: REPORTING ON PROGRAM YEAR PROGRESS (NAHASDA § 404(b))"]
[]
["Complete the shaded section of text below to describe your completed program tasks and actual results.  Only report on activities completed during the 12-month program year.  Financial data should be presented using the same basis of accounting as the Schedule of Expenditures of Federal Awards (SEFA) in the annual OMB Circular A-133 audit.  For unit accomplishments, only count units when the unit was completed and occupied during the year.  For households, only count the household if it received the assistance during the previous 12-month program year."]
[{"$nulls":26},1]
["1.1. Program Name and Unique Identifier:   "]
["1.2. Program Description (This should be the description of the planned program.):"]
[]
["1.3. Eligible Activity Number (Select one activity from the Eligible Activity list.):"]
["1.4. Intended Outcome Number (Select one outcome from the Outcome list.): "]
["Describe Other Intended Outcome (Only if you selected \"Other\" above):"]
[]
["1.5. Actual Outcome Number (In the APR identify the actual outcome from the Outcome list.):"]
["Describe Other Actual Outcome (Only if you selected \"Other\" above):"]
[]
["1.6. Who Will Be Assisted (Describe the types of households that will be assisted under the program. Please note: assistance made available to families whose incomes fall within 80 to 100 percent of the median should be included as a separate program within this section.):"]
[]
["1.7. Types and Level of Assistance (Describe the types and the level of assistance that will be provided to each household, as applicable.): "]
[]
["1.8. APR: Describe the accomplishments for the APR in the 12-month program year. "]
[]
["1.9:  Planned and Actual Outputs for 12-Month Program Year "]
[]
["Eligible Activity","Output Measure","Output Completion"]
["(1) Modernization of 1937 Act Housing ","Units","All work completed and unit passed final inspection"]
["(2) Operation of 1937 Act Housing ","Units","Number of units in inventory"]
["(3) Acquisition of Rental Housing ","Units","When recipient takes title to the unit"]
["(4) Construction of Rental Housing ","Units","All work completed and unit passed final inspection"]
["(5) Rehabilitation of Rental Housing ","Units","All work completed and unit passed final inspection"]
["(6) Acquisition of Land for Rental Housing Development ","Units (based on the number of units the land will be used for)","When recipient takes title to the land"]
["(7) Development of Emergency Shelters ","Households","Number of households served at any one time, based on capacity of the shelter"]
["(8) Conversion of Other Structures to Affordable Housing ","Units","All work completed and unit passed final inspection"]
["(9) Other Rental Housing Development ","Units","All work completed and unit passed final inspection"]
["(10) Acquisition of Land for Homebuyer Unit Development ","Units (based on the number of units the land will be used for)","When recipient takes title to the land"]
["(11) New Construction of Homebuyer Units ","Units","All work completed and unit passed final inspection"]
["(12) Acquisition of Homebuyer Units","Units","When recipient takes title to the unit"]
["(13) Down Payment/Closing Cost Assistance","Units","When binding commitment signed"]
["(14) Lending Subsidies for Homebuyers (Loan)","Units","When binding commitment signed"]
["(15) Other Homebuyer Assistance Activities","Units","When binding commitment signed"]
["(16) Rehabilitation Assistance to Existing Homeowners","Units","All work completed and unit passed final inspection"]
["(17) Infrastructure to Support Housing","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(18) Other Housing Service","Households","Count each household once per year"]
["(19) Tenant Based Rental Assistance","Households","Count each household once per year"]
["(20) Operation and Maintenance of NAHASDA-Assisted Units","Units","Number of units in inventory"]
["(21) Housing Management Services","Households","Count each household once per year"]
["(22) Crime Prevention and Safety","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(23) Model Activities","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(24) Self-Determination Program"]
["Acquisition","Units","When recipient takes title to the unit"]
["Construction","Units","All work completed and unit passed final inspection"]
["Rehabilitation","Units","All work completed and unit passed final inspection"]
["Infrastructure","N/A","Dollars spent (report in Uses of Funding Table only)"]
[]
["Planned Number of Units to be Completed in Year Under this Program","Planned Number of Households To Be Served in Year Under this Program","Planned Number of Acres To Be Purchased in Year Under this Program"]
[]
["APR: Actual Number of Units Completed in Program Year","APR: Actual Number of Households Served in Program Year","APR: Actual Number of Acres Purchased in Program Year"]
[]
["1.10:  APR: If the program is behind schedule, explain why.  (24 CFR § 1000.512(b)(2))"]

{"sheet":"Section 3 (1)","index":4,"n_rows":100,"n_cols":27,"rows_kept":100,"merged":[[5,0,6,3],[24,0,24,1],[24,2,24,3],[25,0,25,1],[25,2,25,3],[26,0,26,1],[26,2,26,3],[27,0,27,1],[27,2,27,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[30,0,30,1],[30,2,30,3],[33,0,33,3],[34,0,34,3],[36,0,36,3],[39,0,39,3],[45,0,45,3],[47,1,47,2],[48,0,48,2],[50,0,50,2],[51,0,51,2],[52,0,52,2],[54,0,54,2],[55,0,55,3],[57,0,57,3],[59,0,59,3],[61,0,61,3],[63,0,63,3],[99,0,99,3]]}
[null,null,""]
["SECTION 3: PROGRAM DESCRIPTIONS"]
["NAHASDA §§ 102(b)(2)(A), 233(a), 235(c),  404(b); 24 CFR §1000.512  "]
[]
["Planning and Reporting Program Year Activities"]
["For the IHP, the purpose of this section is to describe each program that will be operating during the 12-month program year.  Each program must include the eligible activity, its intended outcome, planned outputs, who will be assisted, and types and levels of assistance.  Each of the eligible activities has a specific, measurable output, as shown below.  Copy and paste text boxes 1.1 through 1.10 as often as needed so that all of your planned programs are included.  For the APR, the purpose of this section is to describe your accomplishments, actual outputs, and any reasons for delays.   "]
[]
[]
["Eligible Activity May Include (citations below all reference sections in NAHASDA):"]
["Eligible Activity","Output Measure","Eligible Activity","Output Measure"]
["(1) Modernization of 1937 Act Housing [202(1)]","Units","(13) Down Payment/Closing Cost Assistance [202(2)]","Units"]
["(2) Operation of 1937 Act Housing [202(1)]","Units","(14) Lending Subsidies for Homebuyers (Loan) [202(2)]","Units"]
["(3) Acquisition of Rental Housing [202(2)]","Units","(15) Other Homebuyer Assistance Activities [202(2)]","Units"]
["(4) Construction of Rental Housing [202(2)]","Units","(16) Rehabilitation Assistance to Existing Homeowners [202(2)]","Units"]
["(5) Rehabilitation of Rental Housing [202(2)]","Units","(17) Infrastructure to Support Housing [202(2)] ","Dollars"]
["(6) Acquisition of Land for Rental Housing Development [202(2)] ","Acres","(18) Other Housing Services [202(3)]","Households"]
["(7) Development of Emergency Shelters [202(2)]","Households","(19) Tenant Based Rental Assistance [202(3)]","Households"]
["(8) Conversion of Other Structures to Affordable Housing [202(2)]","Units","(20) Operation and Maintenance of NAHASDA-Assisted Units [202(4)]","Units"]
["(9) Other Rental Housing Development [202(2)] ","Units","(21) Housing Management Services [202(4)]","Households"]
["(10) Acquisition of Land for Homebuyer Unit Development [202(2)]","Acres","(22) Crime Prevention and Safety [202(5)]","Dollars"]
["(11) New Construction of Homebuyer Units [202(2)]","Units","(23) Model Activities [202(6)]","Dollars"]
["(12) Acquisition of Homebuyer Units [202(2)]","Units","(24) Self-Determination Program [231-235] ","Units/Dollars"]
[]
["Outcome May Include:"]
[]
["(1) Reduce over-crowding ",null,"(7) Create new affordable rental units"]
["(2) Assist renters to become homeowners",null,"(8) Assist affordable housing for college students"]
["(3) Improve quality of substandard units",null,"(9) Provide accessibility for disabled/elderly persons"]
["(4) Improve quality of existing infrastructure ",null,"(10) Improve energy efficiency"]
["(5) Address homelessness",null,"(11) Reduction in crime reports"]
["(6) Assist affordable housing for low income households",null,"(12) Other – must provide description in boxes 1.4 (IHP) and 1.5 (APR) below"]
[]
["IHP: PLANNED PROGRAM YEAR ACTIVITIES (NAHASDA § 102(b)(2)(A))"]
["For each planned activity, complete all the non-shaded sections below.  It is recommended that for each program name you assign a unique identifier to help distinguish individual programs.   This unique number can be any number of your choosing, but it should be simple and clear so that you and HUD can track tasks and results under the program and collect appropriate file documentation tied to this program.  "]
["§  One way to number your programs is chronologically.  For example, you could number your programs 2011-1, "]
["    2011-2, 2011-3 etc."]
["§  Or, you may wish to number the programs based on type.  For example rental 1, rental 2, homebuyer1,"]
["    homebuyer 2 etc.  This type of numbering system might be appropriate if you have many programs"]
["    that last over several years."]
["§  Finally, you may wish to use an outline style of numbering.  For example, all programs under your first"]
["    eligible activity would start with the number 1 and then be consecutively numbered as 1.1, 1.2, 1.3 etc. "]
["    The programs under the second eligible activity would be numbered as 2.1, 2.2, 2.3 etc."]
[]
["APR: REPORTING ON PROGRAM YEAR PROGRESS (NAHASDA § 404(b))"]
[]
["Complete the shaded section of text below to describe your completed program tasks and actual results.  Only report on activities completed during the 12-month program year.  Financial data should be presented using the same basis of accounting as the Schedule of Expenditures of Federal Awards (SEFA) in the annual OMB Circular A-133 audit.  For unit accomplishments, only count units when the unit was completed and occupied during the year.  For households, only count the household if it received the assistance during the previous 12-month program year."]
[]
["1.1. Program Name and Unique Identifier:   ",{"$nulls":25},1]
["1.2. Program Description (This should be the description of the planned program.):"]
[]
["1.3. Eligible Activity Number (Select one activity from the Eligible Activity list.):"]
["1.4. Intended Outcome Number (Select one outcome from the Outcome list.): "]
["Describe Other Intended Outcome (Only if you selected \"Other\" above):"]
[]
["1.5. Actual Outcome Number (In the APR identify the actual outcome from the Outcome list.):"]
["Describe Other Actual Outcome (Only if you selected \"Other\" in above):"]
[]
["1.6. Who Will Be Assisted (Describe the types of households that will be assisted under the program. Please note: assistance made available to families whose incomes fall within 80 to 100 percent of the median should be included as a separate program within this section.):"]
[]
["1.7. Types and Level of Assistance (Describe the types and the level of assistance that will be provided to each household, as applicable.): "]
[]
["1.8. APR: Describe the accomplishments for the APR in the 12-month program year. "]
[]
["1.9:  Planned and Actual Outputs for 12-Month Program Year "]
[]
["Eligible Activity","Output Measure","Output Completion"]
["(1) Modernization of 1937 Act Housing ","Units","All work completed and unit passed final inspection"]
["(2) Operation of 1937 Act Housing ","Units","Number of units in inventory"]
["(3) Acquisition of Rental Housing ","Units","When recipient takes title to the unit"]
["(4) Construction of Rental Housing ","Units","All work completed and unit passed final inspection"]
["(5) Rehabilitation of Rental Housing ","Units","All work completed and unit passed final inspection"]
["(6) Acquisition of Land for Rental Housing Development ","Units (based on the number of units the land will be used for)","When recipient takes title to the land"]
["(7) Development of Emergency Shelters ","Households","Number of households served at any one time, based on capacity of the shelter"]
["(8) Conversion of Other Structures to Affordable Housing ","Units","All work completed and unit passed final inspection"]
["(9) Other Rental Housing Development ","Units","All work completed and unit passed final inspection"]
["(10) Acquisition of Land for Homebuyer Unit Development ","Units (based on the number of units the land will be used for)","When recipient takes title to the land"]
["(11) New Construction of Homebuyer Units ","Units","All work completed and unit passed final inspection"]
["(12) Acquisition of Homebuyer Units","Units","When recipient takes title to the unit"]
["(13) Down Payment/Closing Cost Assistance","Units","When binding commitment signed"]
["(14) Lending Subsidies for Homebuyers (Loan)","Units","When binding commitment signed"]
["(15) Other Homebuyer Assistance Activities","Units","When binding commitment signed"]
["(16) Rehabilitation Assistance to Existing Homeowners","Units","All work completed and unit passed final inspection"]
["(17) Infrastructure to Support Housing","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(18) Other Housing Services","Households","Count each household once per year"]
["(19) Tenant Based Rental Assistance","Households","Count each household once per year"]
["(20) Operation and Maintenance of NAHASDA-Assisted Units","Units","Number of units in inventory"]
["(21) Housing Management Services","Households","Count each household once per year"]
["(22) Crime Prevention and Safety","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(23) Model Activities","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(24) Self-Determination Program"]
["Acquisition","Units","When recipient takes title to the unit"]
["Construction","Units","All work completed and unit passed final inspection"]
["Rehabilitation","Units","All work completed and unit passed final inspection"]
["Infrastructure","N/A","Dollars spent (report in Uses of Funding Table only)"]
[]
["Planned Number of Units to be Completed in Year Under this Program","Planned Number of Households To Be Served in Year Under this Program","Planned Number of Acres To Be Purchased in Year Under this Program"]
[]
["APR: Actual Number of Units Completed in Program Year","APR: Actual Number of Households Served in Program Year","APR: Actual Number of Acres Purchased in Program Year"]
[]
["1.10:  APR: If the program is behind schedule, explain why.  (24 CFR § 1000.512(b)(2))"]

{"sheet":"Section 4","index":5,"n_rows":9,"n_cols":1,"rows_kept":9}
[]
["SECTION 4: MAINTAINING 1937 ACT UNITS, DEMOLITION, AND DISPOSITION "]
["NAHASDA §§ 102(b)(2)(A)(v), 102(b)(2)(A)(iv)(I-III)"]
[]
[]
["(1)   Maintaining 1937 Act Units (NAHASDA § 102(b)(2)(A)(v)) (Describe specifically how you will maintain and operate your 1937 Act housing units in order to ensure that these units will remain viable.):   "]
[]
[]
["(2)   Demolition and Disposition (NAHASDA § 102(b)(2)(A)(iv)(I-III), 24 CFR 1000.134) (Describe any planned demolition or disposition of 1937 Act housing units.  Be certain to include the timetable for any planned demolition or disposition and any other information required by HUD with respect to the demolition or disposition.):  "]

{"sheet":"Section 5","index":6,"n_rows":67,"n_cols":15,"rows_kept":67,"merged":[[4,0,4,10],[5,0,5,5],[5,6,5,10],[6,0,6,5],[6,6,6,10],[7,0,7,5],[7,6,7,10],[8,0,8,5],[8,6,8,10],[9,0,9,5],[9,6,9,10],[10,0,10,5],[10,6,10,10],[11,0,11,5],[11,6,11,10],[12,0,12,5],[12,6,12,10],[13,0,13,5],[13,6,13,10],[15,0,15,12],[17,3,17,7],[17,8,17,13],[18,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[32,0,32,2],[40,0,40,12],[42,2,42,7],[42,8,42,13],[43,2,43,3],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[43,12,43,13],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[44,12,44,13],[45,0,45,1],[45,2,45,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[45,12,45,13],[46,0,46,1],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[46,12,46,13],[47,0,47,1],[47,2,47,3],[47,4,47,5],[47,6,47,7],[47,8,47,9],[47,10,47,11],[47,12,47,13],[48,0,48,1],[48,2,48,3],[48,4,48,5],[48,6,48,7],[48,8,48,9],[48,10,48,11],[48,12,48,13],[56,0,63,9],[66,0,70,9]]}
[]
["SECTION 5: BUDGETS"]
["NAHASDA §§ 102(b)(2)(C), 404(b)"]
[]
["(1)   Planned Grant-Based Budget for Eligible Programs (In the table below show how you plan to spend the total amount of that year’s IHBG funds based on the estimated formula allocation or the final formula allocation.  This table should include only planned IHBG funds and not program income or funding from any other source.)"]
["Eligible Activity",{"$nulls":5},"Planned IHBG Budget"]
["(1)   Indian Housing Assistance"]
["(2)   Development"]
["(3)   Housing Services"]
["(4)   Housing Management Services"]
["(5)   Crime Prevention and Safety Activities"]
["(6)   Model Activities"]
["(7)   Planning and Administration"]
["TOTAL",{"$nulls":5},{"$f":"SUM(G7:G13)","v":{"v":0,"d":"$0.00"}}]
[]
["(2) Estimated Sources of Funding (NAHASDA § 102(b)(2)(C)(i)) (Complete the non-shaded portions of the chart below to describe your estimated or anticipated sources of funding for the 12-month program year.  APR Actual Sources of Funding -- Please complete the shaded portions of the chart below to describe your actual funds received.  Only report on funds actually received and under a grant agreement or other binding commitment during the 12-month program year.)  "]
[]
[{"$nulls":3},"IHP",{"$nulls":4},"APR"]
["SOURCE",null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)","(K)"]
[{"$nulls":3},"Estimated amount on hand at beginning of program year","Estimated amount to be received during 12-month program year","Estimated total sources of funds      (A+B)","Estimated funds to be expended during 12-month program year","Estimated unexpended funds remaining at end of program year  (C-D)","Actual amount on hand at beginning of program year","Actual amount received during 12-month program year","Actual total sources of funding (F+G)","Actual funds expended during 12-month program year","Actual unexpended funds remaining at end of 12-month program year     (H - I)","Actual unexpended funds obligated but not expended at end of 12-month program year"]
["1. IHBG Funds",null,null,{"v":1,"d":"$1"},null,{"$f":"SUM(D21:E21)","v":{"v":1,"d":"$1"}},null,{"$f":"(F21-G21)","v":{"v":1,"d":"$1"}},null,null,{"$f":"SUM(I21:J21)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K21-L21)","v":{"v":0,"d":"$0"}}]
["2. IHBG Program Income",{"$nulls":4},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
["3. Title VI",{"$nulls":4},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
["4. Title VI Program Income",{"$nulls":4},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
["5. 1937 Act Operating Reserves",{"$nulls":4},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
["6. Carry Over 1937 Act Funds",{"$nulls":4},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
["LEVERAGED FUNDS"]
["7. ICDBG Funds",{"$nulls":4},{"$f":"SUM(D28:E28)","v":{"v":0,"d":"$0"}},null,{"$f":"(F28-G28)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(I28:J28)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K28-L28)","v":{"v":0,"d":"$0"}}]
["8. Other Federal Funds",{"$nulls":4},{"$f":"SUM(D29:E29)","v":{"v":0,"d":"$0"}},null,{"$f":"(F29-G29)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(I29:J29)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K29-L29)","v":{"v":0,"d":"$0"}}]
["9. LIHTC",{"$nulls":4},{"$f":"SUM(D30:E30)","v":{"v":0,"d":"$0"}},null,{"$f":"(F30-G30)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(I30:J30)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K30-L30)","v":{"v":0,"d":"$0"}}]
["10. Non-Federal Funds",{"$nulls":4},{"$f":"SUM(D31:E31)","v":{"v":0,"d":"$0"}},null,{"$f":"(F31-G31)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(I31:J31)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K31-L31)","v":{"v":0,"d":"$0"}}]
["TOTAL",null,null,{"$f":"SUM(D21:D31)","v":{"v":1,"d":"$1"}},{"$f":"SUM(E21:E31)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F21:F31)","v":{"v":1,"d":"$1"}},{"$f":"SUM(G21:G31)","v":{"v":0,"d":"$0"}},{"v":1,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["TOTAL Columns C & H, 2 through 10",{"$nulls":4},{"$f":"SUM(F22:F31)","v":{"v":0,"d":"$0"}},{"$nulls":4},{"$f":"SUM(K22:K31)","v":{"v":0,"d":"$0"}}]
["Notes:"]
["a. For the IHP, fill in columns A, B, C, D, and E (non-shaded columns). For the APR, fill in columns F, G, H, I, J, and K (shaded columns)."]
["b. Total of Column D should match the total of Column N from the Uses of Funding table below."]
["c. Total of Column I should match the Total of Column Q from the Uses of Funding table below."]
["d.  For the IHP, describe any estimated leverage in Line 4 below (Estimated Sources or Uses of Funding table). For the APR, describe actual leverage in Line 5 below"]
[]
[]
["(3) Uses of Funding (NAHASDA § 102(b)(2)(C)(ii)) (Note that the budget should not exceed the total funds on hand and insert as many rows as needed to include all the programs identified in Section 3.  Actual expenditures in the APR section are for the 12-month program year.)  "]
[]
[null,null,"IHP",{"$nulls":5},"APR"]
[null,null,"(L)",null,"(M)",null,"(N)",null,"(O)",null,"(P)",null,"(Q)"]
["PROGRAM NAME",null,"Prior and current year IHBG (only) funds to be expended in 12-month program year",null,"Total all other funds to be expended in 12-month program year",null,"Total funds to be expended in 12-month program year         (L+M)",null,"Total IHBG (only) funds expended in 12-month program year",null,"Total all other funds expended in 12-month program year",null,"Total funds expended in 12-month program year (O+P)"]
[{"$nulls":6},{"$f":"SUM(C46:E46)","v":{"v":0,"d":"$0"}},{"$nulls":5},{"$f":"SUM(I46:K46)","v":{"v":0,"d":"$0"}},null,"Section 3 (1)"]
["Planning and Administration",{"$nulls":5},{"v":0,"d":"$0"},{"$nulls":5},{"v":0,"d":"$0"}]
["Loan repayment - describe in 4 & 5 below",{"$nulls":5},{"v":0,"d":"$0"},{"$nulls":5},{"v":0,"d":"$0"}]
["TOTAL",null,{"$f":"SUM(C46:C48)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(E46:E48)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},null,{"$f":"SUM(I46:I48)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K46:K48)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
["Notes:"]
["a. Total of Column L cannot exceed the IHBG funds from Column C, Row 1 from the Estimated Sources of Funding table in Line 2 above. "]
["b. Total of Column M cannot exceed the total from Column C, Rows 2-10 from the Estimated Sources of Funding table in Line 2 above.  "]
["c. Total of Column O cannot exceed total IHBG funds received in Column H, Row 1 from the Estimated Sources of Funding table in Line 2 above."]
["d. Total of Column P cannot exceed total of Column H, Rows 2-10 of the Estimated Sources of Funding table in Line 2 above."]
["e. Total of Column Q should equal total of Column I of the Estimated Sources of Funding table in Line 2 above."]
[]
["(4) Estimated Sources or Uses of Funding (NAHASDA § 102(b)(2)(C)).  (Provide any additional information about the estimated sources or uses of funding, including leverage (if any).  You must provide the relevant information for any planned loan repayment listed in the Uses Table on the previous page.  This planned loan repayment can be associated with Title VI or with private or tribal funding that is used for an eligible activity described in an IHP that has been determined to be in compliance by HUD.  The text must describe which specific loan is planned to be repaid and the NAHASDA-eligible activity and program associated with this loan):  "]
{"$rows_empty":9}
["(5) APR (NAHASDA § 404(b)) (Enter any additional information about the actual sources or uses of funding, including leverage (if any).  You must provide the relevant information for any actual loan repayment listed in the Uses Table on the previous page.  The text must describe which loan was repaid and the NAHASDA-eligible activity and program associated with this loan.):"]

{"sheet":"Section 6","index":7,"n_rows":64,"n_cols":4,"rows_kept":64,"merged":[[4,0,9,5],[12,0,14,5],[21,0,21,5],[27,0,27,5],[33,0,33,5],[35,0,35,5],[37,0,37,5],[40,0,43,5],[44,0,44,2],[46,0,46,5],[49,0,49,5],[51,0,51,3],[53,0,53,1],[54,0,54,1],[56,0,58,3],[60,0,60,3],[62,0,62,1],[63,0,63,1]]}
[]
["SECTION 6:  OTHER SUBMISSION ITEMS"]
["NAHASDA §§ 102(b)(2)(C)(ii), 201(b)(5), 202(6), 205(a)(2), 209"]
[]
["(1)   Useful Life/Affordability Period(s) (NAHASDA § 205, 24 CFR § 1000.142) (Identify the useful life of each housing unit constructed, acquired, or rehabilitated with IHBG funds, including housing units to be constructed, acquired, or rehabilitated with IHBG funds in the 12 month period.   Exclude Mutual Help units.  "]
{"$rows_empty":7}
["(2)   Model Housing and Over-Income Activities (24 CFR § 1000.108) ( If you wish to undertake a model housing activity or wish to serve non-low-income households during the 12-month program year, those activities may be described here, in the program description section of the 1-year plan, or as a separate submission.):"]
[" "]
[]
[]
[]
["(3)   Tribal and Other Indian Preference (NAHASDA § 201(b)(5), 24 CFR § 1000.120)"]
[" If preference will be given to tribal members or other Indian families, the preference policy must be "]
[" described. This information may be provided here or in the program description section of the 1-year plan."]
[]
["      Does the Tribe have a preference policy?  "]
[]
["If yes, describe the policy."]
[]
[]
["(4)   Anticipated Planning and Administration Expenses (NAHASDA § 102(b)(2)(C)(ii), 24 CFR § 1000.238)"]
["Do you intend to use more than 20% of your current grant for Planning and Administration?  "]
[" "]
["If yes, describe why the additional funds are needed for Planning and Administration.  "]
[]
[]
["(5)   Actual Planning and Administration Expenses (NAHASDA § 102(b)(2)(C)(ii), 24 CFR § 1000.238)"]
["Did you expend more than 20% of your current grant for Planning and Administration? "]
[]
["If yes, did you receive HUD approval to exceed the 20% cap on Planning and Administration costs? "]
[" "]
["If you did not receive approval for spending more than 20% of your current grant on planning and administration costs, describe the reason(s) for exceeding the 20% cap. (See Section 6, Line 5 of the Guidance for information on carry-over of unspent planning and administration expenses.) "]
[]
[]
["(6) Expanded Formula Area - Verification of Substantial Housing Services (24 CFR § 1000.302(3))  If your tribe has an expanded formula area (i.e., an area that was justified based on housing services provided rather than the list of areas defined in 24 CFR § 1000.302 Formula Area (1)), the tribe must demonstrate that it is continuing to provide substantial housing services to that expanded formula area.   Does the tribe have an expanded formula area? "]
[]
[]
[]
["                                     If no, proceed to Section 7."]
[]
["If yes, list each separate geographic area that has been added to the Tribe’s formula area and the documented number of Tribal members residing there. "]
[]
[]
["For each separate formula area expansion, list the budgeted amount of IHBG and other funds to be provided to all American Indian and Alaska Native (AIAN) households and to only those AIAN households with incomes 80% of median income or lower during the recipient’s 12-month program year:"]
[]
["Total Expenditures on Affordable Housing Activities for:"]
[null,null,"All AIAN Househods","AIAN Households with Incomes 80% or Less of Median Income"]
["IHBG Funds:"]
["Funds from Other Sources:"]
[]
["(7) APR:  If answered \"Yes\" in Line 6, for each separate formula area, list the actual amount of IHBG and other funds expended for all AIAN households and for only AIAN households with incomes 80% of median income or lower during the recipient's 12-month program year. "]
[]
[]
[]
["Total Expenditures on Affordable Housing Activities for:"]
[null,null,"All AIAN Househods","AIAN Households with Incomes 80% or Less of Median Income"]
["IHBG Funds:"]
["Funds from Other Sources:"]

{"sheet":"Section 7","index":8,"n_rows":21,"n_cols":1,"rows_kept":21,"merged":[[4,0,4,9],[8,0,8,9],[10,0,10,9],[11,0,11,9],[14,0,14,9],[16,0,16,9],[18,0,18,9],[20,0,20,9]]}
[]
["SECTION 7:  INDIAN HOUSING PLAN CERTIFICATION OF COMPLIANCE    "]
["NAHASDA § 102(b)(2)(D)"]
[]
["By signing the IHP, you certify that you have all required policies and procedures in place in order to operate any planned IHBG programs."]
[]
[]
["(1) In accordance with applicable statutes, the recipient certifies that:"]
["It will comply with title II of the Civil Rights Act of 1968 in carrying out this Act, to the extent that such title is applicable, and other applicable federal statutes."]
[]
["(2) In accordance with 24 CFR 1000.328, the recipient receiving less than $200,000 under FCAS certifies that:"]
["There are households within its jurisdiction at or below 80 percent of median income."]
[]
["(3) The following certifications will only apply where applicable based on program activities."]
["a. It will maintain adequate insurance coverage for housing units that are owned and operated or assisted with grant amounts provided under NAHASDA, in compliance with such requirements as may be established by HUD;"]
[]
["b. Policies are in effect and are available for review by HUD and the public governing the eligibility, admission, and occupancy of families for housing assisted with grant amounts provided under NAHASDA;"]
[]
["c. Policies are in effect and are available for review by HUD and the public governing rents charged, including the methods by which such rents or homebuyer payments are determined, for housing assisted with grant amounts provided under NAHASDA; and"]
[]
["d. Policies are in effect and are available for review by HUD and the public governing the management and maintenance of housing assisted with grant amounts provided under NAHASDA."]

{"sheet":"Section 8","index":9,"n_rows":14,"n_cols":1,"rows_kept":14,"merged":[[1,0,1,5],[2,0,2,5],[7,0,7,10],[8,0,8,10],[9,0,9,4],[9,5,9,10],[10,0,10,4],[10,5,11,10],[11,0,11,4],[12,0,12,4],[12,5,12,10],[13,0,13,4],[13,5,13,10]]}
[]
["SECTION 8:  IHP TRIBAL CERTIFICATION "]
["NAHASDA § 102(c)"]
[]
[" This certification is used when a Tribally Designated Housing Entity (TDHE) prepares the IHP on behalf of a tribe. "]
[" This certification must be executed by the recognized tribal government covered under the IHP."]
["(1) The recognized tribal government of the grant beneficiary certifies that:"]
["(2)      It had an opportunity to review the IHP and has authorized the submission of the IHP by the TDHE; or"]
["(3)      It has delegated to such TDHE the authority to submit an IHP on behalf of the Tribe without prior review by   the Tribe."]
["(4)  Tribe:"]
["(5)  Authorized Official’s Name and"]
["      Title:"]
["(6)  Authorized Official’s Signature:"]
["(7)  Date (MM/DD/YYYY):"]

{"sheet":"Section 9","index":10,"n_rows":11,"n_cols":1,"rows_kept":11,"merged":[[2,0,2,6],[6,0,6,10],[7,0,7,10],[8,0,8,10]]}
[]
["SECTION 9:  TRIBAL WAGE RATE CERTIFICATION  "]
["NAHASDA §§ 102(b)(2)(D)(vi), 104(b)"]
[]
[" By signing the IHP, you certify whether you will use tribally determined wages, Davis-Bacon wages, or HUD "]
[" determined wages.  Check only the applicable box below.  "]
["(1)     You will use tribally determined wage rates when required for IHBG-assisted construction or maintenance activities.   The Tribe has appropriate laws and regulations in place in order for it to determine and distribute prevailing wages.  "]
["(2)     You will use Davis-Bacon or HUD determined wage rates when required for IHBG-assisted construction or maintenance activities. "]
["(3)      You will use Davis-Bacon and/or HUD determined wage rates when required for IHBG-assisted construction except for the activities described below. "]
[]
["(4) List the activities using tribally determined wage rates: "]

{"sheet":"Section 10","index":11,"n_rows":19,"n_cols":1,"rows_kept":19,"merged":[[6,0,6,10],[8,0,8,10],[10,0,10,10],[14,0,14,10],[18,0,18,10]]}
[]
["SECTION 10:  SELF-MONITORING"]
["NAHASDA § 403(b), 24 CFR §§ 1000.26, 85.37, 85.40"]
[]
["(1)   Do you have a procedure and/or policy for self-monitoring?"]
[]
[]
[]
["(2)   Pursuant to 24 CFR § 1000.502 (b) where the recipient is a TDHE, did the TDHE provide periodic progress reports including the self-monitoring report, Annual Performance Report, and audit reports to the Tribe? "]
[]
[]
[]
["(3)   Did you conduct self-monitoring, including monitoring sub-recipients?"]
[]
[]
[]
[]
[]
["(4) Self-Monitoring Results.  (Describe the results of the monitoring activities, including inspections for this program year.):"]

{"sheet":"Section 11","index":12,"n_rows":24,"n_cols":7,"rows_kept":24,"merged":[[4,0,4,6],[5,1,5,3],[6,0,6,1],[7,0,7,1],[8,2,8,6],[12,0,12,1],[13,2,13,6],[18,0,18,1],[19,0,19,1],[21,3,21,6],[23,0,23,6]]}
[]
["SECTION 11:  INSPECTIONS"]
["NAHASDA § 403(b)                                            "]
[]
["    (1)   Inspection of Units (Use the table below to record the results of recurring inspections of assisted housing.)     "]
[]
["Activity",null,"Total Number of Units","Units in standard condition","Units needing rehabilitation","Units needing to be replaced","Total number of units inspected"]
["(a)",null,"(b)","(c)","(d)","(e)","(f)"]
[1,"1937 Housing Act Units:"]
[null,"a. Rental",{"$nulls":4},{"$f":"SUM(D10:F10)","v":0}]
[null,"b. Homeownership",{"$nulls":4},{"$f":"SUM(D11:F11)","v":0}]
[null,"c. Other",{"$nulls":4},{"$f":"SUM(D12:F12)","v":0}]
["1937 Act Subtotal",null,{"$f":"SUM(C10:C12)","v":0},{"$f":"SUM(D10:D12)","v":0},{"$f":"SUM(E10:E12)","v":0},{"$f":"SUM(F10:F12)","v":0},{"$f":"SUM(D13:F13)","v":0}]
[2,"NAHASDA assisted  units:"]
[null,"a. Rental",{"$nulls":4},{"$f":"SUM(D15:F15)","v":0}]
[null,"b. Homeownership",{"$nulls":4},0]
[null,"c. RentalAssistance",{"$nulls":4},0]
[null,"d. Other",{"$nulls":4},0]
["NAHASDA Subtotal",null,{"$f":"SUM(C15:C18)","v":0},{"$f":"SUM(D15:D18)","v":0},{"$f":"SUM(E15:E18)","v":0},{"$f":"SUM(F15:F18)","v":0},0]
["Total",null,{"$f":"C13+C19","v":0},{"$f":"D13+D19","v":0},{"$f":"E13+E19","v":0},{"$f":"F13+F19","v":0},0]
[]
["(2)   Did you comply with your inspection policy:"]
[]
["(3)    If no, why not:"]

{"sheet":"Section 12","index":13,"n_rows":11,"n_cols":1,"rows_kept":11,"merged":[[8,0,8,10],[10,0,10,10]]}
[]
["SECTION 12:  AUDITS"]
["24 CFR § 1000.544"]
[]
["This section is used to indicate whether an audit is required, based on a review of your financial records.  "]
[]
["Did you expend less than $500,000 in total Federal awards for the reporting period covered by the APR?"]
[]
[]
[]
["If Yes, an audit is not required.  If No, an audit is required to be submitted to the Federal Audit Clearinghouse and your Area Office of Native American Programs. "]

{"sheet":"Section 13","index":14,"n_rows":18,"n_cols":1,"rows_kept":18,"merged":[[7,0,7,10],[11,0,11,10],[14,0,14,10],[17,0,17,10]]}
[]
["SECTION 13: PUBLIC ACCOUNTABILITY"]
["24 CFR § 1000.518"]
[]
["(1).  Did you make this APR available to the citizens in your jurisdiction before it was submitted to HUD "]
["       (24 CFR § 1000.518)?"]
[]
[]
[]
["(2)   If you are a TDHE, did you submit this APR to the Tribe (24 CFR § 1000.512)?"]
[]
[]
[]
[]
["(3)    If you answered “No” to question #1 and/or #2, provide an explanation as to why not and indicate when you will do so. "]
[]
[]
["(4) Summarize any comments received from the Tribe and/or the citizens (NAHASDA § 404(d))."]

{"sheet":"Section 14","index":15,"n_rows":11,"n_cols":1,"rows_kept":11,"merged":[[6,0,6,9],[7,0,7,4],[7,5,7,9],[8,0,8,4],[8,5,8,9],[10,0,10,9]]}
[]
["SECTION 14:  JOBS SUPPORTED BY NAHASDA"]
["NAHASDA § 404(b)"]
[]
["Use the table below to record the number of jobs supported with IHBG funds."]
[]
["Indian Housing Block Grant Assistance (IHBG)"]
["(1) Number of Permanent Jobs Supported"]
["(2) Number of Temporary Jobs Supported"]
[]
["(3) Narrative (optional):"]

{"sheet":"Section 15","index":16,"n_rows":22,"n_cols":1,"rows_kept":22,"merged":[[4,0,4,10],[5,0,5,10],[7,0,7,10],[8,0,8,10],[11,0,11,10],[14,0,14,10],[17,0,17,4],[17,5,17,10],[18,0,18,4],[18,5,19,10],[19,0,19,4],[20,0,20,4],[20,5,20,10],[21,0,21,4],[21,5,21,10]]}
[]
["SECTION 15: IHP WAIVER REQUESTS"]
["NAHASDA § 101(b)(2)"]
[]
["THIS SECTION IS ONLY REQUIRED IF THE RECIPIENT IS REQUESTING A WAIVER OF AN IHP SECTION OR A WAIVER OF THE IHP SUBMISSION DUE DATE. "]
["A waiver is valid for a period not to exceed 90 days.  Fill out the form below if you are requesting a waiver of one or more sections of the IHP.  NOTE: This is NOT a waiver of the IHBG program requirements but rather a request to waive some of the IHP submission items.    "]
[]
["(1) List below the sections of the IHP where you are requesting a waiver and/or a waiver of the IHP due date. "]
["    (List the requested waiver sections by name and section number):"]
[]
[]
["(2) Describe the reasons that you are requesting this waiver (Describe completely why you are unable to complete a particular section of the IHP or could not submit the IHP by the required due date.):"]
[]
[]
["(3)  Describe the actions you will take in order to ensure that you are able to submit a complete IHP in the future and/or submit the IHP by the required due date. (This section should completely describe the procedural, staffing or technical corrections that you will make in order to submit a complete IHP in the future and/or submit the IHP by the required due date.):      "]
[]
[]
["(4) Recipient:"]
["(5)  Authorized Official’s Name and"]
["       Title:"]
["(6)  Authorized Official’s Signature:"]
["(7)  Date (MM/DD/YYYY):"]

{"sheet":"Section 16","index":17,"n_rows":100,"n_cols":27,"rows_kept":100,"hidden":true,"merged":[[4,0,4,3],[7,0,7,3],[24,0,24,1],[24,2,24,3],[25,0,25,1],[25,2,25,3],[26,0,26,1],[26,2,26,3],[27,0,27,1],[27,2,27,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[30,0,30,1],[30,2,30,3],[33,0,33,3],[34,0,34,3],[36,0,36,3],[39,0,39,3],[45,0,45,3],[47,1,47,2],[48,0,48,2],[50,0,50,2],[51,0,51,2],[52,0,52,2],[54,0,54,2],[55,0,55,3],[57,0,57,3],[59,0,59,3],[61,0,61,3],[63,0,63,3],[99,0,99,3]]}
[null,null,"",{"$nulls":10},"(1) Modernization of 1937 Act Housing [202(1)]","(1) Reduce over-crowding "]
["SECTION 16: IHP AMENDMENTS",{"$nulls":11},1]
["NAHASDA §§ 24 CFR §1000.512  ",{"$nulls":11},2]
[]
["Use this section for IHP amendments only."]
[]
["Planning and Reporting Program Year Activities",{"$nulls":11},3]
["Fill out the text below to summarize your IHP amendment.  This amendment is only required to be submitted to the HUD Area Office of Native American Programs when (1) the recipient is adding a new activity that was not described in the current One-Year Plan that has been determined to be in compliance by HUD or (2) to reduce the amount of funding that was previously budgeted for the operation and maintenance of 1937 Act housing under NAHASDA § 202(1).  All other amendments will be reflected in the APR and do not need to be submitted to HUD.  ",{"$nulls":11},4]
[]
["Eligible Activity","Output Measure","Eligible Activity","Output Measure",{"$nulls":9},"(10) Acquisition of Land for Homebuyer Unit Development [202(2)]","(10) Improve energy efficiency"]
["(1) Modernization of 1937 Act Housing [202(1)]","Units","(13) Down Payment/Closing Cost Assistance [202(2)]","Units",{"$nulls":8},9,"(11) New Construction of Homebuyer Units [202(2)]","(11) Reduction in crime reports"]
["(2) Operation of 1937 Act Housing [202(1)]","Units","(14) Lending Subsidies for Homebuyers (Loan) [202(2)]","Units",{"$nulls":8},10,"(12) Acquisition of Homebuyer Units [202(2)]","(12) Other – must provide description in boxes 1.4 (IHP) and 1.5 (APR) below"]
["(3) Acquisition of Rental Housing [202(2)]","Units","(15) Other Homebuyer Assistance Activities [202(2)]","Units",{"$nulls":8},11,"(13) Down Payment/Closing Cost Assistance [202(2)]"]
["(4) Construction of Rental Housing [202(2)]","Units","(16) Rehabilitation Assistance to Existing Homeowners [202(2)]","Units",{"$nulls":8},12,"(14) Lending Subsidies for Homebuyers (Loan) [202(2)]"]
["(5) Rehabilitation of Rental Housing [202(2)]","Units","(17) Tenant Based Rental Assistance [202(3)]","Households",{"$nulls":8},13,"(15) Other Homebuyer Assistance Activities [202(2)]"]
["(6) Acquisition of Land for Rental Housing Development [202(2)] ","Acres","(18) Other Housing Services [202(3)]","Households",{"$nulls":8},14,"(16) Rehabilitation Assistance to Existing Homeowners [202(2)]"]
["(7) Development of Emergency Shelters [202(2)]","Households","(19) Housing Management Services [202(4)]","Households",{"$nulls":8},15,"(17) Tenant Based Rental Assistance [202(3)]"]
["(8) Conversion of Other Structures to Affordable Housing [202(2)]","Units","(20) Operation and Maintenance of NAHASDA-Assisted Units [202(4)]","Units",{"$nulls":8},16,"(18) Other Housing Services [202(3)]"]
["(9) Other Rental Housing Development [202(2)] ","Units","(21) Crime Prevention and Safety [202(5)]","Dollars",{"$nulls":8},17,"(19) Housing Management Services [202(4)]"]
["(10) Acquisition of Land for Homebuyer Unit Development [202(2)]","Acres","(22) Model Activities [202(6)]","Dollars",{"$nulls":8},18,"(20) Operation and Maintenance of NAHASDA-Assisted Units [202(4)]"]
["(11) New Construction of Homebuyer Units [202(2)]","Units","(23) Self-Determination Program [231-235] ","Units/Dollars",{"$nulls":8},19,"(21) Crime Prevention and Safety [202(5)]"]
["(12) Acquisition of Homebuyer Units [202(2)]","Units","(24) Infrastructure to Support Housing [202(2)] ","Dollars",{"$nulls":8},20,"(22) Model Activities [202(6)]"]
[{"$nulls":12},22,"(23) Self-Determination Program [231-235] "]
["Outcome May Include:",{"$nulls":11},23,"(24) Infrastructure to Support Housing [202(2)] "]
[]
["(1) Reduce over-crowding ",null,"(7) Create new affordable rental units"]
["(2) Assist renters to become homeowners",null,"(8) Assist affordable housing for college students"]
["(3) Improve quality of substandard units",null,"(9) Provide accessibility for disabled/elderly persons"]
["(4) Improve quality of existing infrastructure ",null,"(10) Improve energy efficiency"]
["(5) Address homelessness",null,"(11) Reduction in crime reports"]
["(6) Assist affordable housing for low income households",null,"(12) Other – must provide description in boxes 1.4 (IHP) and 1.5 (APR) below"]
[]
["IHP: PLANNED PROGRAM YEAR ACTIVITIES (NAHASDA § 102(b)(2)(A))"]
["For each planned activity, complete all the non-shaded sections below.  It is recommended that for each program name you assign a unique identifier to help distinguish individual programs.   This unique number can be any number of your choosing, but it should be simple and clear so that you and HUD can track tasks and results under the program and collect appropriate file documentation tied to this program.  "]
["§  One way to number your programs is chronologically.  For example, you could number your programs 2011-1, "]
["    2011-2, 2011-3 etc."]
["§  Or, you may wish to number the programs based on type.  For example rental 1, rental 2, homebuyer1,"]
["    homebuyer 2 etc.  This type of numbering system might be appropriate if you have many programs"]
["    that last over several years."]
["§  Finally, you may wish to use an outline style of numbering.  For example, all programs under your first"]
["    eligible activity would start with the number 1 and then be consecutively numbered as 1.1, 1.2, 1.3 etc. "]
["    The programs under the second eligible activity would be numbered as 2.1, 2.2, 2.3 etc."]
[]
["APR: REPORTING ON PROGRAM YEAR PROGRESS (NAHASDA § 404(b))"]
[]
["Complete the shaded section of text below to describe your completed program tasks and actual results.  Only report on activities completed during the 12-month program year.  Financial data should be presented using the same basis of accounting as the Schedule of Expenditures of Federal Awards (SEFA) in the annual OMB Circular A-133 audit.  For unit accomplishments, only count units when the unit was completed and occupied during the year.  For households, only count the household if it received the assistance during the previous 12-month program year."]
[{"$nulls":26},1]
["1.1. Program Name and Unique Identifier:   "]
["1.2. Program Description (This should be the description of the planned program.):"]
[]
["1.3. Eligible Activity Number (Select one activity from the Eligible Activity list.):"]
["1.4. Intended Outcome Number (Select one outcome from the Outcome list.): "]
["Describe Other Intended Outcome (Only if you selected \"Other\" above):"]
[]
["1.5. Actual Outcome Number (In the APR identify the actual outcome from the Outcome list.):"]
["Describe Other Actual Outcome (Only if you selected \"Other\" above):"]
[]
["1.6. Who Will Be Assisted (Describe the types of households that will be assisted under the program. Please note: assistance made available to families whose incomes fall within 80 to 100 percent of the median should be included as a separate program within this section.):"]
[]
["1.7. Types and Level of Assistance (Describe the types and the level of assistance that will be provided to each household, as applicable.): "]
[]
["1.8. APR: Describe the accomplishments for the APR in the 12-month program year. "]
[]
["1.9:  Planned and Actual Outputs for 12-Month Program Year "]
[]
["Eligible Activity","Output Measure","Output Completion"]
["(1) Modernization of 1937 Act Housing ","Units","All work completed and unit passed final inspection"]
["(2) Operation of 1937 Act Housing ","Units","Number of units in inventory"]
["(3) Acquisition of Rental Housing ","Units","When recipient takes title to the unit"]
["(4) Construction of Rental Housing ","Units","All work completed and unit passed final inspection"]
["(5) Rehabilitation of Rental Housing ","Units","All work completed and unit passed final inspection"]
["(6) Acquisition of Land for Rental Housing Development ","Units (based on the number of units the land will be used for)","When recipient takes title to the land"]
["(7) Development of Emergency Shelters ","Households","Number of households served at any one time, based on capacity of the shelter"]
["(8) Conversion of Other Structures to Affordable Housing ","Units","All work completed and unit passed final inspection"]
["(9) Other Rental Housing Development ","Units","All work completed and unit passed final inspection"]
["(10) Acquisition of Land for Homebuyer Unit Development ","Units (based on the number of units the land will be used for)","When recipient takes title to the land"]
["(11) New Construction of Homebuyer Units ","Units","All work completed and unit passed final inspection"]
["(12) Acquisition of Homebuyer Units","Units","When recipient takes title to the unit"]
["(13) Down Payment/Closing Cost Assistance","Units","When binding commitment signed"]
["(14) Lending Subsidies for Homebuyers (Loan)","Units","When binding commitment signed"]
["(15) Other Homebuyer Assistance Activities","Units","When binding commitment signed"]
["(16) Rehabilitation Assistance to Existing Homeowners","Units","All work completed and unit passed final inspection"]
["(17) Infrastructure to Support Housing","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(18) Other Housing Service","Households","Count each household once per year"]
["(19) Tenant Based Rental Assistance","Households","Count each household once per year"]
["(20) Operation and Maintenance of NAHASDA-Assisted Units","Units","Number of units in inventory"]
["(21) Housing Management Services","Households","Count each household once per year"]
["(22) Crime Prevention and Safety","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(23) Model Activities","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(24) Self-Determination Program"]
["Acquisition","Units","When recipient takes title to the unit"]
["Construction","Units","All work completed and unit passed final inspection"]
["Rehabilitation","Units","All work completed and unit passed final inspection"]
["Infrastructure","N/A","Dollars spent (report in Uses of Funding Table only)"]
[]
["Planned Number of Units to be Completed in Year Under this Program","Planned Number of Households To Be Served in Year Under this Program","Planned Number of Acres To Be Purchased in Year Under this Program"]
[]
["APR: Actual Number of Units Completed in Program Year","APR: Actual Number of Households Served in Program Year","APR: Actual Number of Acres Purchased in Program Year"]
[]
["1.10:  APR: If the program is behind schedule, explain why.  (24 CFR § 1000.512(b)(2))"]

{"sheet":"Section 16 (1)","index":18,"n_rows":100,"n_cols":27,"rows_kept":100,"hidden":true,"merged":[[4,0,4,3],[7,0,7,3],[24,0,24,1],[24,2,24,3],[25,0,25,1],[25,2,25,3],[26,0,26,1],[26,2,26,3],[27,0,27,1],[27,2,27,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[30,0,30,1],[30,2,30,3],[33,0,33,3],[34,0,34,3],[36,0,36,3],[39,0,39,3],[45,0,45,3],[47,1,47,2],[48,0,48,2],[50,0,50,2],[51,0,51,2],[52,0,52,2],[54,0,54,2],[55,0,55,3],[57,0,57,3],[59,0,59,3],[61,0,61,3],[63,0,63,3],[99,0,99,3]]}
[null,null,""]
["SECTION 16: IHP AMENDMENTS"]
["NAHASDA §§ 24 CFR §1000.512  "]
[]
["Use this section for IHP amendments only."]
[]
["Planning and Reporting Program Year Activities"]
["Fill out the text below to summarize your IHP amendment.  This amendment is only required to be submitted to the HUD Area Office of Native American Programs when (1) the recipient is adding a new activity that was not described in the current One-Year Plan that has been determined to be in compliance by HUD or (2) to reduce the amount of funding that was previously budgeted for the operation and maintenance of 1937 Act housing under NAHASDA § 202(1).  All other amendments will be reflected in the APR and do not need to be submitted to HUD.  "]
[]
["Eligible Activity","Output Measure","Eligible Activity","Output Measure"]
["(1) Modernization of 1937 Act Housing [202(1)]","Units","(13) Down Payment/Closing Cost Assistance [202(2)]","Units"]
["(2) Operation of 1937 Act Housing [202(1)]","Units","(14) Lending Subsidies for Homebuyers (Loan) [202(2)]","Units"]
["(3) Acquisition of Rental Housing [202(2)]","Units","(15) Other Homebuyer Assistance Activities [202(2)]","Units"]
["(4) Construction of Rental Housing [202(2)]","Units","(16) Rehabilitation Assistance to Existing Homeowners [202(2)]","Units"]
["(5) Rehabilitation of Rental Housing [202(2)]","Units","(17) Infrastructure to Support Housing [202(2)] ","Dollars"]
["(6) Acquisition of Land for Rental Housing Development [202(2)] ","Acres","(18) Other Housing Services [202(3)]","Households"]
["(7) Development of Emergency Shelters [202(2)]","Households","(19) Tenant Based Rental Assistance [202(3)]","Households"]
["(8) Conversion of Other Structures to Affordable Housing [202(2)]","Units","(20) Operation and Maintenance of NAHASDA-Assisted Units [202(4)]","Units"]
["(9) Other Rental Housing Development [202(2)] ","Units","(21) Housing Management Services [202(4)]","Households"]
["(10) Acquisition of Land for Homebuyer Unit Development [202(2)]","Acres","(22) Crime Prevention and Safety [202(5)]","Dollars"]
["(11) New Construction of Homebuyer Units [202(2)]","Units","(23) Model Activities [202(6)]","Dollars"]
["(12) Acquisition of Homebuyer Units [202(2)]","Units","(24) Self-Determination Program [231-235] ","Units/Dollars"]
[]
["Outcome May Include:"]
[]
["(1) Reduce over-crowding ",null,"(7) Create new affordable rental units"]
["(2) Assist renters to become homeowners",null,"(8) Assist affordable housing for college students"]
["(3) Improve quality of substandard units",null,"(9) Provide accessibility for disabled/elderly persons"]
["(4) Improve quality of existing infrastructure ",null,"(10) Improve energy efficiency"]
["(5) Address homelessness",null,"(11) Reduction in crime reports"]
["(6) Assist affordable housing for low income households",null,"(12) Other – must provide description in boxes 1.4 (IHP) and 1.5 (APR) below"]
[]
["IHP: PLANNED PROGRAM YEAR ACTIVITIES (NAHASDA § 102(b)(2)(A))"]
["For each planned activity, complete all the non-shaded sections below.  It is recommended that for each program name you assign a unique identifier to help distinguish individual programs.   This unique number can be any number of your choosing, but it should be simple and clear so that you and HUD can track tasks and results under the program and collect appropriate file documentation tied to this program.  "]
["§  One way to number your programs is chronologically.  For example, you could number your programs 2011-1, "]
["    2011-2, 2011-3 etc."]
["§  Or, you may wish to number the programs based on type.  For example rental 1, rental 2, homebuyer1,"]
["    homebuyer 2 etc.  This type of numbering system might be appropriate if you have many programs"]
["    that last over several years."]
["§  Finally, you may wish to use an outline style of numbering.  For example, all programs under your first"]
["    eligible activity would start with the number 1 and then be consecutively numbered as 1.1, 1.2, 1.3 etc. "]
["    The programs under the second eligible activity would be numbered as 2.1, 2.2, 2.3 etc."]
[]
["APR: REPORTING ON PROGRAM YEAR PROGRESS (NAHASDA § 404(b))"]
[]
["Complete the shaded section of text below to describe your completed program tasks and actual results.  Only report on activities completed during the 12-month program year.  Financial data should be presented using the same basis of accounting as the Schedule of Expenditures of Federal Awards (SEFA) in the annual OMB Circular A-133 audit.  For unit accomplishments, only count units when the unit was completed and occupied during the year.  For households, only count the household if it received the assistance during the previous 12-month program year."]
[]
["1.1. Program Name and Unique Identifier:   ",{"$nulls":25},1]
["1.2. Program Description (This should be the description of the planned program.):"]
[]
["1.3. Eligible Activity Number (Select one activity from the Eligible Activity list.):"]
["1.4. Intended Outcome Number (Select one outcome from the Outcome list.): "]
["Describe Other Intended Outcome (Only if you selected \"Other\" above):"]
[]
["1.5. Actual Outcome Number (In the APR identify the actual outcome from the Outcome list.):"]
["Describe Other Actual Outcome (Only if you selected \"Other\" in above):"]
[]
["1.6. Who Will Be Assisted (Describe the types of households that will be assisted under the program. Please note: assistance made available to families whose incomes fall within 80 to 100 percent of the median should be included as a separate program within this section.):"]
[]
["1.7. Types and Level of Assistance (Describe the types and the level of assistance that will be provided to each household, as applicable.): "]
[]
["1.8. APR: Describe the accomplishments for the APR in the 12-month program year. "]
[]
["1.9:  Planned and Actual Outputs for 12-Month Program Year "]
[]
["Eligible Activity","Output Measure","Output Completion"]
["(1) Modernization of 1937 Act Housing ","Units","All work completed and unit passed final inspection"]
["(2) Operation of 1937 Act Housing ","Units","Number of units in inventory"]
["(3) Acquisition of Rental Housing ","Units","When recipient takes title to the unit"]
["(4) Construction of Rental Housing ","Units","All work completed and unit passed final inspection"]
["(5) Rehabilitation of Rental Housing ","Units","All work completed and unit passed final inspection"]
["(6) Acquisition of Land for Rental Housing Development ","Units (based on the number of units the land will be used for)","When recipient takes title to the land"]
["(7) Development of Emergency Shelters ","Households","Number of households served at any one time, based on capacity of the shelter"]
["(8) Conversion of Other Structures to Affordable Housing ","Units","All work completed and unit passed final inspection"]
["(9) Other Rental Housing Development ","Units","All work completed and unit passed final inspection"]
["(10) Acquisition of Land for Homebuyer Unit Development ","Units (based on the number of units the land will be used for)","When recipient takes title to the land"]
["(11) New Construction of Homebuyer Units ","Units","All work completed and unit passed final inspection"]
["(12) Acquisition of Homebuyer Units","Units","When recipient takes title to the unit"]
["(13) Down Payment/Closing Cost Assistance","Units","When binding commitment signed"]
["(14) Lending Subsidies for Homebuyers (Loan)","Units","When binding commitment signed"]
["(15) Other Homebuyer Assistance Activities","Units","When binding commitment signed"]
["(16) Rehabilitation Assistance to Existing Homeowners","Units","All work completed and unit passed final inspection"]
["(17) Infrastructure to Support Housing","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(18) Other Housing Services","Households","Count each household once per year"]
["(19) Tenant Based Rental Assistance","Households","Count each household once per year"]
["(20) Operation and Maintenance of NAHASDA-Assisted Units","Units","Number of units in inventory"]
["(21) Housing Management Services","Households","Count each household once per year"]
["(22) Crime Prevention and Safety","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(23) Model Activities","N/A","Dollars spent (report in Uses of Funding Table only)"]
["(24) Self-Determination Program"]
["Acquisition","Units","When recipient takes title to the unit"]
["Construction","Units","All work completed and unit passed final inspection"]
["Rehabilitation","Units","All work completed and unit passed final inspection"]
["Infrastructure","N/A","Dollars spent (report in Uses of Funding Table only)"]
[]
["Planned Number of Units to be Completed in Year Under this Program","Planned Number of Households To Be Served in Year Under this Program","Planned Number of Acres To Be Purchased in Year Under this Program"]
[]
["APR: Actual Number of Units Completed in Program Year","APR: Actual Number of Households Served in Program Year","APR: Actual Number of Acres Purchased in Program Year"]
[]
["1.10:  APR: If the program is behind schedule, explain why.  (24 CFR § 1000.512(b)(2))"]

{"sheet":"Section 16 - Funds - Signature","index":19,"n_rows":60,"n_cols":15,"rows_kept":60,"hidden":true,"merged":[[4,0,4,10],[5,0,5,5],[5,6,5,10],[6,0,6,5],[6,6,6,10],[7,0,7,5],[7,6,7,10],[8,0,8,5],[8,6,8,10],[9,0,9,5],[9,6,9,10],[10,0,10,5],[10,6,10,10],[11,0,11,5],[11,6,11,10],[12,0,12,5],[12,6,12,10],[13,0,13,5],[13,6,13,10],[15,0,15,12],[17,3,17,7],[17,8,17,13],[18,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[32,0,32,2],[40,0,40,13],[42,2,42,7],[42,8,42,13],[43,2,43,3],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[43,12,43,13],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[44,12,44,13],[45,0,45,1],[45,2,45,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[45,12,45,13],[46,0,46,1],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[46,12,46,13],[47,0,47,1],[47,2,47,3],[47,4,47,5],[47,6,47,7],[47,8,47,9],[47,10,47,11],[47,12,47,13],[48,0,48,1],[48,2,48,3],[48,4,48,5],[48,6,48,7],[48,8,48,9],[48,10,48,11],[48,12,48,13],[56,0,56,2],[56,3,56,9],[57,0,57,2],[57,3,57,9],[58,0,58,2],[58,3,58,9],[59,0,59,2],[59,3,59,9]]}
{"$rows_empty":15}
["(10) Estimated Sources of Funding (NAHASDA § 102(b)(2)(C)(i)) (Complete the non-shaded portions of the chart below to describe your estimated or anticipated sources of funding for the 12-month program year.  APR Actual Sources of Funding -- Please complete the shaded portions of the chart below to describe your actual funds received.  Only report on funds actually received and under a grant agreement or other binding commitment during the 12-month program year.)  "]
[]
[{"$nulls":3},"IHP",{"$nulls":4},"APR"]
["SOURCE",null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)","(K)"]
[{"$nulls":3},"Estimated amount on hand at beginning of program year","Estimated amount to be received during 12-month program year","Estimated total sources of funds      (A+B)","Estimated funds to be expended during 12-month program year","Estimated unexpended funds remaining at end of program year  (C-D)","Actual amount on hand at beginning of program year","Actual amount received during 12-month program year","Actual total sources of funding (F+G)","Actual funds expended during 12-month program year","Actual unexpended funds remaining at end of 12-month program year     (H - I)","Actual unexpended funds obligated but not expended at end of 12-month program year"]
["1. IHBG Funds",{"$nulls":4},{"$f":"SUM(D21:E21)","v":{"v":0,"d":"$0"}},null,{"$f":"(F21-G21)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(I21:J21)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K21-L21)","v":{"v":0,"d":"$0"}}]
["2. IHBG Program Income",{"$nulls":4},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
["3. Title VI",{"$nulls":4},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
["4. Title VI Program Income",{"$nulls":4},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
["5. 1937 Act Operating Reserves",{"$nulls":4},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
["6. Carry Over 1937 Act Funds",{"$nulls":4},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
["LEVERAGED FUNDS"]
["7. ICDBG Funds",{"$nulls":4},{"$f":"SUM(D28:E28)","v":{"v":0,"d":"$0"}},null,{"$f":"(F28-G28)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(I28:J28)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K28-L28)","v":{"v":0,"d":"$0"}}]
["8. Other Federal Funds",{"$nulls":4},{"$f":"SUM(D29:E29)","v":{"v":0,"d":"$0"}},null,{"$f":"(F29-G29)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(I29:J29)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K29-L29)","v":{"v":0,"d":"$0"}}]
["9. LIHTC",{"$nulls":4},{"$f":"SUM(D30:E30)","v":{"v":0,"d":"$0"}},null,{"$f":"(F30-G30)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(I30:J30)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K30-L30)","v":{"v":0,"d":"$0"}}]
["10. Non-Federal Funds",{"$nulls":4},{"$f":"SUM(D31:E31)","v":{"v":0,"d":"$0"}},null,{"$f":"(F31-G31)","v":{"v":0,"d":"$0"}},null,null,{"$f":"SUM(I31:J31)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K31-L31)","v":{"v":0,"d":"$0"}}]
["TOTAL",null,null,{"$f":"SUM(D21:D31)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E21:E31)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F21:F31)","v":{"v":0,"d":"$0"}},{"$f":"SUM(G21:G31)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["TOTAL Columns C & H, 2 through 10",{"$nulls":4},{"$f":"SUM(F22:F31)","v":{"v":0,"d":"$0"}},{"$nulls":4},{"$f":"SUM(K22:K31)","v":{"v":0,"d":"$0"}}]
["Notes:"]
["a. For the IHP, fill in columns A, B, C, D, and E (non-shaded columns). For the APR, fill in columns F, G, H, I, J, and K (shaded columns)."]
["b. Total of Column D should match the total of Column N from the Uses of Funding table below."]
["c. Total of Column I should match the Total of Column Q from the Uses of Funding table below."]
["d.  For the IHP, describe any estimated leverage in Line 4 below (Estimated Sources or Uses of Funding table). For the APR, describe actual leverage in Line 5 below"]
[]
[]
["(11) Amended Uses of Funding (NAHASDA § 102(b)(2)(C)(ii)) (Note that the budget should not exceed the total funds on hand and insert as many rows as needed to include all the programs identified in Section 3.  Actual expenditures in the APR section are for the 12-month program year.)  "]
[]
[null,null,"IHP",{"$nulls":5},"APR"]
[null,null,"(L)",null,"(M)",null,"(N)",null,"(O)",null,"(P)",null,"(Q)"]
["PROGRAM NAME",null,"Prior and current year IHBG (only) funds to be expended in 12-month program year",null,"Total all other funds to be expended in 12-month program year",null,"Total funds to be expended in 12-month program year         (L+M)",null,"Total IHBG (only) funds expended in 12-month program year",null,"Total all other funds expended in 12-month program year",null,"Total funds expended in 12-month program year (O+P)"]
[{"$nulls":6},{"$f":"SUM(C46:E46)","v":{"v":0,"d":"$0"}},{"$nulls":5},{"$f":"SUM(I46:K46)","v":{"v":0,"d":"$0"}},null,"Section 16 (1)"]
["Planning and Administration",{"$nulls":5},{"v":0,"d":"$0"},{"$nulls":5},{"v":0,"d":"$0"}]
["Loan repayment - describe in 4 & 5 below",{"$nulls":5},{"v":0,"d":"$0"},{"$nulls":5},{"v":0,"d":"$0"}]
["TOTAL",null,{"$f":"SUM(C46:C48)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(E46:E48)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},null,{"$f":"SUM(I46:I48)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(K46:K48)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
["Notes:"]
["a. Total of Column L cannot exceed the IHBG funds from Column C, Row 1 from the Estimated Sources of Funding table in Line 2 above. "]
["b. Total of Column M cannot exceed the total from Column C, Rows 2-10 from the Estimated Sources of Funding table in Line 2 above.  "]
["c. Total of Column O cannot exceed total IHBG funds received in Column H, Row 1 from the Estimated Sources of Funding table in Line 2 above."]
["d. Total of Column P cannot exceed total of Column H, Rows 2-10 of the Estimated Sources of Funding table in Line 2 above."]
["e. Total of Column Q should equal total of Column I of the Estimated Sources of Funding table in Line 2 above."]
[]
["(12) Recipient:"]
["(13)  Authorized Official’s Name and Title:"]
["(14)  Authorized Official’s Signature:"]
["(15)  Date (MM/DD/YYYY):"]