{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Self Scoring","Controls","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":69,"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":"Self Scoring","index":0,"n_rows":536,"n_cols":17,"rows_kept":536,"cut":false,"hidden":false,"merged":[[116,1,116,8],[117,1,117,8],[118,1,118,8],[123,0,123,8],[127,0,127,8],[121,0,121,8],[122,0,122,8],[186,0,186,6],[165,0,165,8],[171,0,171,8],[172,0,172,8],[177,1,177,8],[178,0,178,8],[174,0,174,8],[175,1,175,8],[176,1,176,8],[166,0,166,8],[180,1,180,8],[341,0,341,8],[206,1,206,8],[290,5,290,6],[294,0,294,4],[294,5,294,6],[212,1,212,8],[318,1,318,8],[321,0,321,8],[101,5,101,6],[125,0,125,4],[125,5,125,6],[119,1,119,8],[110,1,110,8],[111,1,111,8],[112,1,112,8],[154,1,154,3],[155,1,155,3],[113,1,113,8],[114,1,114,8],[115,1,115,8],[151,0,151,8],[138,0,138,8],[149,5,149,6],[152,0,152,1],[338,1,338,8],[329,0,329,8],[201,1,201,8],[204,1,204,8],[218,2,218,8],[256,2,256,8],[269,2,269,8],[228,1,228,8],[272,0,272,4],[272,5,272,6],[214,2,214,8],[217,2,217,8],[316,1,316,8],[325,1,325,8],[289,0,289,6],[213,1,213,8],[221,1,221,8],[215,3,215,8],[216,3,216,8],[222,1,222,8],[226,1,226,8],[209,1,209,8],[219,2,219,8],[225,1,225,8],[404,0,404,4],[404,5,404,6],[358,0,358,8],[347,2,347,8],[348,2,348,8],[345,0,345,8],[349,0,349,8],[367,0,367,8],[356,0,356,4],[356,5,356,6],[359,1,359,8],[351,0,351,8],[352,0,352,8],[360,1,360,8],[346,1,346,8],[378,0,378,8],[354,0,354,8],[236,0,236,8],[237,1,237,8],[239,1,239,8],[314,0,314,8],[304,1,304,8],[305,1,305,8],[306,1,306,8],[307,1,307,8],[308,1,308,8],[303,0,303,8],[310,0,310,8],[311,1,311,8],[312,1,312,8],[258,2,258,3],[258,4,258,6],[287,0,287,8],[182,0,182,8],[192,0,192,8],[205,1,205,8],[227,1,227,8],[181,0,181,8],[185,0,185,8],[194,0,194,8],[208,1,208,8],[183,0,183,8],[184,0,184,8],[199,2,199,8],[197,1,197,8],[198,2,198,8],[191,0,191,8],[189,0,189,8],[187,0,187,4],[187,5,187,6],[154,5,154,7],[128,0,128,8],[136,4,136,6],[149,0,149,4],[157,0,157,6],[161,0,161,6],[148,0,148,6],[136,0,136,1],[136,2,136,3],[152,4,152,6],[132,0,132,8],[133,0,133,8],[134,0,134,8],[135,0,135,8],[152,2,152,3],[164,0,164,8],[158,0,158,4],[158,5,158,6],[162,0,162,4],[162,5,162,6],[168,0,168,4],[155,5,155,7],[160,0,160,8],[179,1,179,8],[168,5,168,6],[170,0,170,8],[156,1,156,3],[4,2,4,3],[76,1,76,8],[68,1,68,8],[69,1,69,8],[51,1,51,8],[95,0,95,8],[99,0,99,8],[70,1,70,8],[72,0,72,8],[73,1,73,8],[80,1,80,8],[62,0,62,4],[62,5,62,6],[97,5,97,6],[61,0,61,6],[36,0,36,8],[46,0,46,6],[47,0,47,4],[47,5,47,6],[41,2,41,8],[15,1,15,8],[16,1,16,8],[18,1,18,8],[24,1,24,8],[74,0,74,8],[78,0,78,4],[78,5,78,6],[90,0,90,4],[90,5,90,6],[97,0,97,4],[77,0,77,6],[96,0,96,6],[101,0,101,1],[101,2,101,3],[82,0,82,8],[35,2,35,8],[27,0,27,8],[29,0,29,8],[34,0,34,8],[60,1,60,8],[54,2,54,8],[55,2,55,8],[56,2,56,8],[58,2,58,8],[57,2,57,8],[33,2,33,8],[30,0,30,8],[31,2,31,8],[32,2,32,8],[20,1,20,8],[22,1,22,8],[0,0,1,0],[14,1,14,8],[235,0,235,8],[3,2,3,6],[6,2,6,6],[7,2,7,6],[37,2,37,8],[38,2,38,8],[26,1,26,8],[9,2,9,6],[39,2,39,8],[40,2,40,8],[86,0,86,8],[53,1,53,8],[59,1,59,8],[5,2,5,3],[4,4,4,6],[5,4,5,6],[261,2,261,7],[253,2,253,8],[255,2,255,8],[257,2,257,8],[260,2,260,8],[43,2,43,8],[45,2,45,8],[50,1,50,8],[167,0,167,6],[245,1,245,8],[89,0,89,6],[52,1,52,8],[233,0,233,8],[200,1,200,8],[202,1,202,8],[230,1,230,8],[173,0,173,8],[258,0,258,1],[124,0,124,6],[88,0,88,8],[92,0,92,8],[100,0,100,8],[108,1,108,8],[109,1,109,8],[355,0,355,6],[350,0,350,8],[526,1,526,7],[530,1,530,7],[391,0,391,8],[390,0,390,8],[371,0,371,8],[372,0,372,8],[373,0,373,8],[376,0,376,8],[389,0,389,8],[380,0,380,8],[381,0,381,8],[382,0,382,8],[379,0,379,8],[386,0,386,8],[383,0,383,8],[384,0,384,8],[385,0,385,8],[500,0,502,8],[387,0,387,8],[388,0,388,8],[450,0,450,8],[451,0,451,8],[393,0,393,8],[392,0,392,8],[518,1,518,7],[522,1,522,7],[368,0,368,8],[369,0,369,8],[370,0,370,8],[361,1,361,8],[363,0,363,8],[364,0,364,8],[365,0,365,8],[366,0,366,8],[460,0,460,8],[453,1,453,8],[454,1,454,8],[455,1,455,8],[456,1,456,8],[457,1,457,8],[458,1,458,8],[377,0,377,8],[452,0,452,8],[459,0,459,8],[398,0,398,4],[398,5,398,6],[535,0,535,8],[462,0,462,8],[463,0,463,8],[464,0,464,8],[465,0,465,8],[529,1,529,7],[521,1,521,7],[525,1,525,7],[481,0,481,6],[479,0,479,8],[480,0,480,8],[473,0,473,8],[476,0,476,8],[477,0,477,8],[478,0,478,8],[467,0,467,4],[467,5,467,6],[471,0,471,4],[471,5,471,6],[482,0,482,6],[496,1,496,7],[497,1,497,7],[498,1,498,7],[483,0,488,8],[337,0,337,8],[336,2,336,8],[353,0,353,8],[339,2,339,8],[340,2,340,8],[343,2,343,8],[344,2,344,8],[263,3,263,8],[264,3,264,8],[265,3,265,8],[266,3,266,8],[267,3,267,8],[268,2,268,8],[270,2,270,8],[275,0,275,8],[271,0,271,6],[335,2,335,8],[324,0,324,8],[290,0,290,4],[293,0,293,6],[317,1,317,8],[301,0,301,8],[342,1,342,8],[334,1,334,8],[285,1,285,8],[286,1,286,8],[292,0,292,8],[296,0,296,8],[326,1,326,8],[327,1,327,8],[330,1,330,8],[331,1,331,8],[333,0,333,8],[262,3,262,8],[425,0,425,8],[461,1,461,8],[475,0,475,8],[422,0,422,8],[411,1,411,8],[418,1,418,8],[490,1,490,7],[420,1,420,8],[412,2,412,3],[436,0,436,8],[448,0,448,4],[448,5,448,6],[446,0,446,8],[423,0,423,8],[414,1,414,8],[421,2,421,3],[469,0,469,8],[415,2,415,3],[315,1,315,8],[277,0,277,8],[281,0,281,8],[283,0,283,8],[284,0,284,8],[491,1,491,7],[492,1,492,7],[493,1,493,7],[494,1,494,7],[495,1,495,7],[507,0,507,8],[129,0,129,8],[130,0,130,8],[137,0,137,8],[394,0,394,8],[397,0,397,6],[403,0,403,6],[447,0,447,6],[466,0,466,6],[470,0,470,6],[396,0,396,8],[395,0,395,8],[400,0,400,8],[401,0,401,8],[402,0,402,8],[426,0,426,8],[406,0,406,8],[408,0,408,8],[410,0,410,8]]}
[null,null,null,null,null,null,null,"Self-Scoring Worksheet"]
[null,null,null,null,null,null,null,"2016 Housing Tax Credit Program"]
[]
["Development Name:"]
["Development Number:",null,null,null," (D Number)"]
["Application Number:",null,null,null," (M Number)"]
["Development Location:"]
["Development City:"]
[]
["Workbook Path:"]
[]
["Please note the following:"]
[]
["1.       Minimum Point Requirements:"]
[null,"· Request for Minnesota Housing Finance Agency (Minnesota Housing) administered tax credits from the State’s volume cap must demonstrate the project is eligible for not less than 30 points."]
[null,"· Request for tax credits in association with Tax Exempt Bonds over and above the State’s allocation of Housing Tax Credits must demonstrate the project is eligible for not less than 30 points."]
[null,"· Minnesota Housing reserves the right to reject applications not meeting its Project Selection requirements as contained in the Procedural Manual, or to revise proposal features, and associated scoring, to ensure the project meets the requirements."]
["2.       Documentation of Points:"]
[null,"· Indicate the selection and/or preference priority points expected for your project.  Where multiple points per section are available please check the appropriate box ([]) for points claimed.  Attach directly to this self-scoring worksheet, a separate detail sheet and documentation that clearly supports points claimed.  Minnesota Housing will determine actual selection points awarded – points will not be awarded unless documentation is provided along with the application to justify the points claimed."]
["3.       Extended Duration:"]
[null,"·  All projects with the exception of those obtaining tax credits in association with Tax Exempt Bonds over and above the State’s allocation of Housing Tax Credits must maintain the duration of low-income use for a minimum of 30 years.  The owner agrees that the provisions of IRC §§ 42(h)(6)(E)(i)(II) and 42(h)(6)(F) (which provision would permit the owner to terminate the restrictions under this agreement at the end of the compliance period in the event Minnesota Housing does not present the owner with a qualified contract for the acquisition of the project) do not apply to the project, and that the Section 42 income and rental restrictions shall apply for the period of 30 years beginning with the first day of the compliance period in which the building is a part of a qualified low income housing project. "]
["4.       Design Standards:"]
[null,"· The project must meet the requirements in the Minnesota Housing Rental Housing Design/Construction Standards and be evidenced by a Design Standards Certification form executed by the owner and architect.  Additional design requirements will be imposed if Large Family Housing points are claimed/awarded or points are claimed/awarded which require specific design elements (i.e. High Speed Internet, Universal Design). "]
["5.       A Declaration of Land Use Restrictive Covenants:"]
[null,"· Covering the rent restrictions and occupancy requirements presented at selection must be recorded against the property."]
["6.       Affirmative Fair Housing:"]
[null,"· Affirmative Fair Housing Marketing Regulations, held as centrally important by Minnesota Housing, require that each applicant carry out an affirmative marketing program to attract prospective buyers or tenants of all majority and minority groups in the housing market area regardless of race, creed, color, religion, sex, national, origin, marital status, status with regard to public assistance, disability, sexual orientation, or familial status. All applicants must submit an Affirmative Fair Housing Marketing Plan at the time of 8609 documenting an acceptable plan to carry out an affirmative marketing program."]
["ROUND 1 – MINIMUM THRESHOLD REQUIREMENTS"]
[]
["For applications submitted in Round 1, all applicants statewide must meet one of the following threshold types.  Please indicate the Threshold item you meet:"]
["A. In the Metropolitan Area:"]
["1.",null,"New construction or substantial rehabilitation in which, for the term of the extended use period (term of the Declaration of Land Use Restrictive Covenants), at least 75 percent of the total tax credit units are single room occupancy units with rents affordable to households whose income does not exceed 30 percent of the area median income."]
["2.",null,"New Construction or substantial rehabilitation family housing projects that are not restricted to persons 55 years old or older in which, for the term of the extended use period (term of the Declaration of Land Use Restrictive Covenants), at least 75 percent of the total tax credit units contain two or more bedrooms and at least one-third of the 75 percent contain three or more bedrooms; or"]
["3.",null,"Substantial rehabilitation projects in neighborhoods targeted by the city for revitalization."]
["B. Outside the Metropolitan Area:"]
["1.",null,"Projects which meet a locally identified housing need and which are in short supply in the local housing market as evidenced by credible data such as local council resolution submitted with the application.  (For Threshold Letter – Sample Format, see HTC Procedural Manual, Reference Materials Index.)"]
["C. Projects that are not restricted to persons of a particular age group and in which, for the term of the extended use period (term of the Declaration of Land Use Restrictive Covenants), a percentage of the units are set aside and rented to persons:"]
["1.",null,"with a serious and persistent mental illness as defined in Minnesota Statutes § 245.462, Subdivision 20, paragraph (c);"]
["2.",null,"with a developmental disability as defined in United States Code, Title 42, Section 6001, paragraph (5), as amended;"]
["3.",null,"who have been assessed as drug dependent persons as defined in Minnesota Statutes § 254A.02, Subdivision 5, and are receiving or will receive care and treatment services provided by an approved treatment program as defined in Minnesota Statutes § 254A.02, Subdivision 2;"]
["4.",null,"with a brain injury as defined in Minnesota Statutes § 256B.093, Subdivision 4, paragraph (a); or"]
["5.",null,"with permanent physical disabilities that substantially limit major life activities, if at least 50 percent of the units in the project are accessible as provided under Minnesota Rules Chapter 1341."]
["D. Preserve Existing Subsidized Housing:"]
["1.",null,"Projects, whether or not restricted to persons of a particular age group, which preserve existing subsidized housing, if the use of tax credits is necessary to (1) prevent conversion to market rate use or (2) to remedy physical deterioration of the project which would result in loss of existing federal subsidies; or"]
["E.  Rural Development:"]
["1.",null,"Projects financed by Rural Development, which meet statewide distribution goals."]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["1. Household Targeting",null,null,null,null,"5 to 10 Points",null,{"$f":"Controls!F18","v":0},0]
[]
["Choose one of the following:"]
[null,"Large Family Housing - The proposal is for a project that provides family housing that is not restricted to persons 55 years old or older.  At least 75 percent of the total tax credit units must contain two or more bedrooms.  The tenant selection plan must give preference to families with minor children. – 10 Points"]
[null,"Single Room Occupancy Housing - At least 50 percent of the total tax credit units must be one bedroom or less with rents affordable to households whose incomes do not exceed 30 percent of AMI. – 10 Points"]
[null,"Special Populations - At least 10 percent and up to 25 percent of the total units are set aside and targeted to special populations* – 5 points"]
[null,"*Special Populations – Projects that are not restricted to persons of a particular age group and in which, for the term of the extended use period (Declaration of Land Use Restrictive Covenants), a percentage of the units are set aside and rented to persons with the following disabilities:"]
[null,"(a)","a serious and persistent mental illness as defined in Minn. Stat. § 245.462, subdivision 20, paragraph (c);"]
[null,"(b)","a developmental disability as defined in United States Code, Title 42, Section 6001, paragraph (5), as amended;"]
[null,"(c)","assessed as drug dependent as defined in Minn. Stat. § 254A.02, subdivision 5, and are receiving or will receive care and treatment services provided by an approved treatment program as defined in Minn. Stat. § 254A.02, Subdivision 2."]
[null,"(d)","a brain injury as defined in Minn. Stat. § 256B.093, Subdivision 4, paragraph (a); or"]
[null,"(e)","permanent physical disabilities that substantially limit major life activities, if at least 50 percent of the units in the project are accessible as provided under Minnesota Rules Chapter 1341."]
[null,"The applicant must contact the human services department for the county where the project will be located to discuss the proposal.  The applicant must submit a letter from the human services department indicating that its staff has reviewed the proposed project, and stating whether there is a need for such housing and if the project would be eligible for funds to assist with the social service needs of the residents."]
[null,"In addition, if the project will be delivering supportive services to residents in these units, the applicant must complete and submit the Supportive Housing application materials, including the narratives, forms and submittals identified in the Multifamily Rental Housing Common Application Request for Proposal Guide, and the Multifamily Rental Housing Common Application Checklist."]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["2. Strategically Targeted Resources ","     ",null,null,null,"10 to 12 Points",null,{"$f":"Controls!F22","v":0},0]
[]
[null,"The proposal is for the rehabilitation of an existing structure – 10 points"]
[]
["Note that for all HTC rehabilitation proposals:"]
["·         the amount of rehabilitation must exceed:"]
[null,"a) $5,000 per low-income unit for the project; and the greater of"]
[null,"b) $6,500 qualified basis per low-income unit per building [as annually increased by cost of living adjustment per Section 42(e)(3)(D)]; or"]
[null,"c) 20 percent of the adjusted basis."]
[]
["Calculation is based on rehabilitation hard costs and cannot include intermediary costs or soft costs identified in the application; plans and/or scope of work provided at the time of application."]
[null,"The rehabilitation proposal is part of a community revitalization or stabilization plan – 2 additional points"]
["Comprehensive plans and land use plans are not considered community revitalization plans. Must be evidenced by a letter from the local jurisdiction; verifying that the proposed project is part of an approved community revitalization area as established by resolution or other legal action."]
[null,null,null,null,"OR"]
[null,"The proposal is for new construction and will utilize existing sewer and water lines without substantial extensions –10 points"]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["3. Economic Integration ",null,null,null,null,"2 to 9 Points",null,{"$f":"Controls!F26","v":0},0]
[]
[null,"The proposed housing provides project economic integration by providing at least 25 percent but not greater than 80 percent of the total units in the project as qualified HTC low income units (does not include full-time manager or other common space units) * - 2 points"]
[null,"OR "]
["To promote economic integration, projects are awarded points for being located in higher income communities that are close to jobs."]
[null,"First Tier - The proposed housing is located in a census tract eligible for 9 point"]
[null,"Second Tier - The proposed housing is located in a census tract eligible for 7 points"]
["Economic integration areas maps and census tract listing are found on Minnesota Housing’s website: "]
["http://www.mnhousing.gov/get/MHFA_012464"]
["Additionally, find economic integration area map overlays in the agency's community profiles interactive mapping tool.  "]
["http://www.mnhousing.gov/wcs/Satellite?c=Page&cid=1373870285684&pagename=External%2FPage%2FEXTStandardLayout"]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["4. Workforce Housing Communities  ","     ",null,null,null,"5 Points",null,0,0]
[]
["Points are awarded for projects located in or near a city or township needing workforce housing (having a large number of jobs or job growth).  In the metropolitan area, project locations must be within 5 miles of a workforce housing city or township.  In Greater Minnesota, project locations must be within 10 miles of a workforce housing city or township. Workforce Housing Communities lists and maps are available on Minnesota Housing's website at: "]
["http://www.mnhousing.gov/get/MHFA_012445"]
["Additionally, find proximity to workforce housing in the agency's community profiles interactive mapping tool.  "]
["http://www.mnhousing.gov/wcs/Satellite?c=Page&cid=1373870285684&pagename=External%2FPage%2FEXTStandardLayout   "]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["5. Federal/Local/Philanthropic Contributions ","     ",null,null,null,"2 to 10 Points",null,{"$f":"Controls!J31","v":0},0]
[]
["Points are awarded for projects that are receiving contributions from the federal government; a local unit of government; an area employer; and/or a private philanthropic, religious or charitable organization.  "]
["Identity of Interest exclusion:  Contributions from any part of the ownership entity will be considered general partner cash and excluded from the calculation unless the contributions are awarded by local units of government or nonprofit charitable organizations pursuant to a funding competition."]
["Total Federal/Local/Philanthropic Contributions",null,null,null,null,"Development Cost",null,null,{"$f":"IF(scDev6=0,0,ROUND(C102/H102,3))","v":0}]
[null,"Total Federal/Local/Philanthropic Contributions divided by Development Cost equals percent rounded to the nearest tenth"]
[null,"20.1% and above – 10 points",null,null,null,"5.1 – 10% – 4 points"]
[null,"15.1 – 20% – 8 points",null,null,null,"2.1 – 5% – 2 points"]
[null,"10.1 – 15% – 6 points",null,null,null,"0 – 2% – 0 points"]
[]
["Federal/Local/Philanthropic Contributions include:"]
["·","Monetary grants/donations "]
["·","Tax increment financing - calculate Net Present Value (NPV) by using NPV discounted by Applicable Federal Rate (AFR)"]
["·","Tax abatement (calculate NPV by using NPV discounted by AFR)"]
["·","Land donation or city write down of the development site"]
["·","In-kind work and materials donated at no cost"]
["·","Local government donation/waiver of project specific costs, assessments or fees (e.g. SAC/WAC)"]
["·","Reservation land not subject to local property taxes"]
["·","Reservation land with long-term low cost leases"]
["·","Deferred loans with a minimum term that is co-terminus with the HTC Declaration with an interest rate at or below the AFR "]
["·","Grants from nonprofit charitable organizations converted to deferred loans with a minimum term that is co-terminus with the HTC Declaration with an interest rate at or below the AFR.  Award letter from the nonprofit charitable organization contributor must be provided at the time of application verifying the project specific (restricted) contribution"]
["·","Below Market Interest Rate (BMIR) Loans –calculate NPV based on the difference between the AFR and the BMIR rate (e.g. RD 515, NHASDA first mortgage).  "]
["·","Historic Tax Credits"]
[]
["To qualify for points for tax increment financing or tax abatement, there must be satisfactory documentation that the contribution is committed to the development at the time of application."]
["At the time of application, written documentation from the contributor justifying the amount and the terms of the contribution must be provided and be consistent with current market comparable costs.  The documentation must be in the form of a project specific letter of intent, city or council resolution, letter of approval, statement of agreement or eligibility, or memorandum of understanding.  In the case of Historic Tax Credits, at the time of application written documentation of eligibility through evidence of Historic Register listing or approval of Part 1—Evaluation of Significance."]
["Within 6 months of the date of selection (Minnesota Housing Board selection date) the applicant must provide Minnesota Housing with documentation of a firm commitment, authorization or approval of the federal/local/philanthropic contribution(s).  The documentation must state the amount, terms and conditions and be executed or approved at a minimum by the contributor.  Documentation containing words synonymous with “consider” or “may”, (as in “may award”) regarding the contribution, will not be considered acceptable.  Lack of acceptable documentation will result in the reevaluation and adjustment of the tax credits or RFP award, up to and including the total recapture of tax credits or RFP funds."]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["6. Financial Readiness to Proceed ","     ",null,null,null,"2 to 14 Points",null,{"$f":"Controls!M32","v":0},0]
[]
["Minnesota Housing shall award points to applicants who have secured funding commitments for one or more permanent funding sources at the time of application except that commitments for funding from Minnesota Housing and Funding Partners (i.e. Minnesota Department of Employment and Economic Development, Family Housing Fund, Greater Minnesota Housing Fund, Metropolitan Council Local Housing Incentive Account) are only included if obtained in a previous funding cycle/round.  "]
["Commitment documentation must state the amount, terms and conditions and be executed or approved by the lender or contributor and the applicant.  Documentation containing words synonymous with “consider” or “may”, (as in “may award”) regarding the commitment will not be considered acceptable.  Deferred Developer fee is not considered a permanent source of funding."]
["The calculation below must exclude first mortgage financing and any anticipated proceeds from the current tax credit request."]
["Syndication proceeds from tax credits awarded in a previous cycle/round may be included if verification is included in the application.  Acceptable verification is an executed syndicator agreement or executed Letter of Intent from the syndicator which is acceptable to Minnesota Housing;"]
["The executed Letter of Intent must:"]
["· Be current within 15 days of submission of the application"]
["· Contain a projected closing date for the development"]
["· Contain a projected equity price for the purchase of the credit"]
["· Contain a detailed explanation of the assumptions being used by the syndicator to arrive at the projected equity price"]
["Total eligible funding secured, awarded or committted*",null,null,null,"Divided by Total Development Cost*",null,null,null,{"$f":"IF(scDev8=0,0,ROUND(C137/H137,3))","v":0}]
["*excluding first mortgage financing and any anticipated proceeds from the current tax credit request"]
[{"$f":"\"Total eligible funding secured, awarded or committed (excluding first mortgage financing and any anticipated proceeds from the current tax credit request) \" & TEXT(C137,\"$0,0\") & \" Divided by Total Development Cost (excluding first mortgage financing and any anticipated proceeds from the current tax credit request) \" & TEXT(H137,\"$0,0\") & \" equals Percentage of Funds Committed \" & TEXT(I137,\"0.0%\") & \" (round to nearest tenth)\"","v":"Total eligible funding secured, awarded or committed (excluding first mortgage financing and any anticipated proceeds from the current tax credit request) $00 Divided by Total Development Cost (excluding first mortgage financing and any anticipated proceeds from the current tax credit request) $00 equals Percentage of Funds Committed 0.0% (round to nearest tenth)"}]
[null,"70% or more of funding secured, awarded or committed – 14 points"]
[null,"60% to 69.9% of funding secured, awarded or committed – 12 points"]
[null,"50% to 59.9% of funding secured, awarded or committed – 10 points"]
[null,"40% to 49.9% of funding secured, awarded or committed – 8 points"]
[null,"30% to 39.9% of funding secured, awarded or committed – 6 points"]
[null,"20% to 29.9% of funding secured, awarded or committed – 4 points"]
[null,"10% to 19.9% of funding secured, awarded or committed – 2 points"]
[null,"9.9% and below of funding secured, awarded or committed – 0 points"]
[]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["7. Intermediary Costs (Soft Costs) ","     ",null,null,null,"1 to 6 Points",null,{"$f":"IF(OR(scDev9=0,scDev10=0),0,Controls!P33)","v":0},0]
[]
["Points will be given to projects with the lowest intermediary costs on a sliding scale based on percentage of total development costs.  For HTC selected projects, this percentage will be enforced at issuance of the IRS Form 8609."]
["Intermediary cost ",null,null,null,"Divided by Total Development Cost",null,null,null,{"$f":"IF(scDev10=0,0,ROUND(C153/H153,3))","v":0}]
[null,"Intermediary Cost divided by Total Development Cost equals Intermediary Percentage rounded to the nearest tenth"]
[null,"0 .0 – 15% – 6 points",null,null,null,"25.1 – 30% – 1 point"]
[null,"15.1 – 20% – 3 points",null,null,null,"30.1 & over – 0 points"]
[null,"20.1 – 25% – 2 points"]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["8. Unacceptable Practices","     ",null,null,null,"-10 to -25 Points",null,0,0]
[]
["Minnesota Housing will impose penalty points for unacceptable practices as identified in Chapter 3 G. of the Housing Tax Credit Procedural Manual."]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["9. Eventual Tenant Ownership ","     ",null,null,null,"1 Point",null,0,0]
[]
["The proposal must include a financially viable plan to transfer 100 percent of the HTC unit ownership after the end of the 15-year compliance period from the initial ownership entity (or Minnesota Housing approved \"Transfer of Ownership\") of the project to tenant ownership."]
["The unit purchase price at time of sale must be affordable to buyers with incomes meeting HTC eligibility requirements.  To be eligible, the buyer must have an HTC qualifying income at the time of initial occupancy (HTC rental tenant) or time of purchase.  The plan must incorporate an ownership exit strategy and the provision of services including homeownership education and training.  The Declaration of Land Use Restrictive Covenants will contain provisions ensuring compliance with these home ownership program commitments by the Owner.  (Refer also to Chapter 4 W of the HTC Procedural Manual for additional information.)"]
["Until the time the HTC units are purchased by qualified tenants or in the event the HTC units are not acquired by qualified tenants, the owner will extend the duration of low-income use for the full extended use period (30 years). "]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["10. Temporary Priority – Foreclosed Properties ","     ",null,null,null,"5 or 10 Points",null,{"$f":"Controls!F36","v":0},0]
[]
["The proposal addresses a temporary housing priority and is eligible for the award of points by the Commissioner or the Board of Minnesota Housing pursuant to authority cited in the Rules of the Minnesota Housing."]
["(Note:  Points cannot be taken in this section for a Temporary Priority if a priority section has been specifically created for it elsewhere in this self-scoring worksheet.)"]
["Priority is given to applications proposing to acquire and rehabilitate a “Foreclosed Property” (A home or residential property has been foreclosed upon if any of the following conditions apply: a) the property’s current delinquency status is at least 60 days delinquent under the Mortgage Bankers of America delinquency calculation and the owner has been notified of this delinquency, or b) the property owner is 90 days or more delinquent on tax payments, or c) under state, local, or tribal law, foreclosure proceedings have been initiated or completed, or d) foreclosure proceedings have been completed and title has been transferred to an intermediary aggregator or servicer that is not an NSP grantee, subrecipient, contractor, developer, or end user.) or are located in a Foreclosure Priority Area identified by Minnesota Housing.  In cases where the project involves a “Foreclosed Property”, the proposed project cannot be a conversion (adaptive reuse/conversion to housing from another use)."]
["The project must consist of a minimum of 12 units and all units must be located on one parcel or contiguous site. "]
["Points may be claimed for only one of the following (maximum of ten (10) points): "]
[null,"For applications proposing to acquire and rehabilitate a Foreclosed Property or redevelop vacant land involved in a foreclosure action which is located in one of the designated Foreclosure Priority Areas. – 10 points"]
[null,"For applications proposing to acquire and rehabilitate a Foreclosed Property or redevelop vacant land involved in a foreclosure action which is not located in one of the designated Foreclosure Priority Areas. – 5 points"]
[null,"For applications proposing to acquire and rehabilitate a property that is located in one of the designated Foreclosure Priority Areas. – 5 points"]
["For applications proposing to acquire and rehabilitate a property which has been foreclosed, applicant must provide at the time of application; "]
[null,"· Evidence of applicant’s ownership rights to the property "]
[null,"· Narrative which clearly identifies (1) the number of tenant leases which are valid and in force and (2) the terms and conditions of those leases which would have a direct impact on Minnesota Housing’s analysis and underwriting of the project proposed in the application."]
["Note: Failure to acquire good title to the property will result in the reevaluation and adjustment of the tax credits or RFP award, up to and including the total recapture of tax credits or RFP funds. "]
["Foreclosures Priority Areas maps and zip code listing are found on Minnesota Housing’s website: "]
["http://www.mnhousing.gov/get/MHFA_012465"]
["  Additionally, find foreclosure priority area map overlays in the agency’s community profiles interactive mapping tool "]
["http://www.mnhousing.gov/wcs/Satellite?c=Page&cid=1373870285684&pagename=External%2FPage%2FEXTStandardLayout"]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["11. Preservation ","     ",null,null,null,"9 to 35 Points",null,{"$f":"Controls!F40","v":0},0]
[]
["IMPORTANT NOTE: DUAL APPLICATION & PRE-APPLICATION REQUIRED"]
[]
["Applicant claiming points under this section must submit dual application, as defined in the Multifamily Consolidated RFP Guide, if development contains 40 units or greater."]
["In order to be eligible for points under this section, applicant must participate in mandatory technical assistance session and provide required submissions prior to May 15, 2015 for HTC Round 1 and prior to December 15, 2015 for HTC Round 2, as detailed in the Housing Tax Credit Procedural Manual Section 7.A.4. Applicant must provide Agency’s “Preliminary Determination of Preservation Eligibility” letter which reflects threshold and points taken below.  "]
[]
["Choose one of the following three Thresholds:"]
[]
["  Risk of Loss Due to Market Conversion"]
[null,"1. Expiration of contract/use-restrictions"]
[null,null,"a.     Existing property at risk of conversion to market rate housing within five years of application date (attach copies of relevant expiring contracts including eligibility dates, loan documents that describe the ability to pre-pay the financing including required approvals and/or penalties or other evidence of eligibility for use-restricted units to convert to market rate); OR"]
[null,null,"b.    Existing tax credit developments must be eligible to exercise their option to file for a Qualified Contract, and have not previously exercised their option; AND"]
[null,"2. Market for conversion evidenced by low physical vacancy rate (4% or lower) for market rate comparable units (comparable units to be validated by Minnesota Housing at Minnesota Housing’s discretion); AND"]
[null,"3. The property’s ability to command market rents as evidenced by direct comparison to local market comparable units and amenities. Conversion scenario must result in sufficient additional revenue to fund improvements and amenities necessary to match market comparable units as evidenced by"]
[null," Three Year Conversion Model "]
[null,"http://www.mnhousing.gov/download/MHFA_1016826"]
[null,"and market study (Market comparable and improvement cost estimates to be validated by Minnesota Housing at Minnesota Housing’s discretion); AND"]
[null,"4. Location in a jobs growth or household growth area as defined in the Agency’s community profiles interactive mapping tool "]
[null,"http://www.mnhousing.gov/wcs/Satellite?c=Page&cid=1373870285684&pagename=External%2FPage%2FEXTStandardLayout"]
[null,"AND"]
[null,"5. Fifteen (15) or more years have passed since initial loan closing or most recent tax credit placed in service date."]
[null,"NOTE: Minnesota Housing, at its sole discretion, must agree that a market exists for a conversion to market rate housing.  "]
[" Risk of Loss Due to Critical Physical Needs "]
[]
[null,"1. Fifteen (15) or more years have passed since initial loan closing or most recent tax credit placed in service date; AND"]
[null,"2. Critical physical needs identified by third party assessment to support the following conclusions:"]
[null,null,"a.     As-is condition of a property’s physical component(s) does not meet:"]
[null,null,null," i. HUD’s Uniform Physical Condition Standards (UPCS), OR "]
[null,null,null,"ii. For building exterior components and mechanical systems for which UPCS does not provide a measure, critical need(s) supported by an independent third party professional certification; AND"]
[null,null,"b.       Repair/replacement of major physical plant components have been identified which will result in 15+ years sustained operations; AND"]
[null,null,"c.        Identified scope of critical physical needs exceeds the available reserves by at least $5,000 per unit, as evidenced by "]
[null,null,"Three Year Critical Needs Model; AND"]
[null,"http://www.mnhousing.gov/download/MHFA_1016827"]
[null,"3. Location in one of three geographic priority areas: jobs growth area, household growth area OR an area designated as having a large affordable housing gap, as evidenced in Minnesota Housing’s community profiles interactive mapping tool  "]
[null,"http://www.mnhousing.gov/wcs/Satellite?c=Page&cid=1373870285684&pagename=External%2FPage%2FEXTStandardLayout"]
[null,"or as evidenced by tribal housing authority waiting list."]
[" Risk of Loss Due to Ownership Capacity"]
[null,"1. Fifteen (15) or more years have passed since initial loan closing or most recent tax credit placed in service date; AND"]
[null,"2. Current ownership puts units at risk of remaining decent, safe, or affordable. Applicable events might include bankruptcy, insolvency, self-determination by nonprofit board; AND"]
[null,"3. Location in one of three geographic priority areas: jobs growth area, household growth area OR an area designated as having a large affordable housing gap, as evidenced in Minnesota Housing’s community profiles interactive mapping tool  "]
[null,"http://www.mnhousing.gov/wcs/Satellite?c=Page&cid=1373870285684&pagename=External%2FPage%2FEXTStandardLayout"]
[null,"or as evidenced by tribal housing authority waiting list."]
[null,"Minnesota Housing, at its sole discretion, must agree that a change in ownership is necessary for units to remain decent, safe, or affordable.  "]
[]
["SCORING:"]
["For projects meeting one of the three Thresholds above, choose points under Existing Federal Assistance or Critical Affordable Units at Risk of Loss below."]
["1. Existing Federal Assistance "]
["Definition: Any housing receiving project based rental assistance, operating subsidies, or mortgage interest reduction payments under a U.S. Department of Housing and Urban Development (“HUD”), U.S. Department of Agriculture Rural Development (“RD”), NAHASDA or other program that is not scheduled to sunset or expire."]
["In order to obtain points for existing federal assistance, the owner shall continue renewals of existing project based housing subsidy payment contract(s) for as long as the assistance is available. Except for “good cause” the owner must not evict existing subsidized residents and must continue to renew leases for those residents. "]
["1.a.","Existing Federally Assisted Units.- 25 points"]
[null,null,null,"AND"]
["1.b.","Score for the appropriate number of federally assisted units currently under contract for preservation: "]
[null,"i. Metro or Greater Minnesota MSA*"]
[null,null," 12-30 units – 1 point "]
[null,null," 31-60 units – 3 points"]
[null,null," 61-100 units – 7 points"]
[null,null," 101+ units – 10 points"]
[null,"* Greater Minnesota MSA (Metropolitan Statistical Area) as defined by HUD: Duluth, St. Cloud, Fargo/Moorhead, Rochester, Mankato, Lacrosse, Grand Forks, Minneapolis/St. Paul MSA outside of the 7 county metro (including Chisago, Isanti, Sherburne, and Wright Counties) Greater Minnesota MSAs are found on Minnesota Housing’s website: Census Tracts.  "]
[null,"Census Tract Link"]
[null,"ii. Greater Minnesota/Rural"]
[null,null,"8-20 units – 3 points"]
[null,null,"21-40 units – 5 points"]
[null,null,"41+ units – 10 points "]
[null,null,null,"OR"]
["2. Critical Affordable Units at Risk of Loss "]
["2.a ",null,"Any housing with a current recorded deed restriction limiting rent or income restrictions at or below the greater of 80% of statewide median income or area median income. Includes existing tax credit units, existing federal assistance not described in paragraph 1. above (i.e. 202, 236, etc.), or other programs limiting income and rent restrictions as stated above. "]
[null,null,null,null,"AND"]
[null,null,"Must also claim and be awarded points for at least three of the following scoring criteria: Economic Integration, Location Efficiency, Workforce Housing Communities, Temporary Priority – Foreclosed Properties, OR QCT/Community Revitalization; AND must also claim and be awarded points under Serves Lowest Income Tenants/Rent Reduction for either Option 1 OR Option 2, AND Option 3. - 9 points ",null,null,null,null,null,null,null,null,{"$f":"\"Number of scoring criteria receiving points - \" & test112a","v":"Number of scoring criteria receiving points - 0"},{"$f":"\"Option 1 or Option 2 claimed - \" &Controls!O49","v":"Option 1 or Option 2 claimed - No"},{"$f":"\"Option 3 - \"&Controls!O51","v":"Option 3 - No"},{"$f":"IF(AND(test112a>0,Controls!O49=TRUE,Controls!O51=TRUE),\"Show\",\"Hide\")","v":"Hide"}]
[null,null,{"$f":"IF(O256=\"Show\",L256 & \", \" & M256 & \", \" &N256,\"\")","v":""}]
["2.b ",null,"Funder Collaboration - 5 additional points for projects eligible under 2.a."]
["Funder Commitments",null,null,null,"Total Development Cost",null,null,null,{"$f":"IF(scDev12=0,0,ROUND(C259/H259,3))","v":0},null,{"$f":"IF(scDev12>0,IF(I259<0.1,\"The result of 11.2.b  must be equal to or exceed 10%. If not you must uncheck 11.2.b\",\"\"),\"\")","v":""}]
[null,null,"Funder Commitments divided by Total Development Cost equals percentage rounded to the nearest tenth"]
[null,null,{"$f":"\"Projects having Funder Commitments $$$ divided by Total Development Cost  $$$ equal to 10.0% or greater (rounded to the nearest tenth)\"","v":"Projects having Funder Commitments $$$ divided by Total Development Cost  $$$ equal to 10.0% or greater (rounded to the nearest tenth)"}]
[null,null,"Funder Commitments include:"]
[null,null,null,"· Debt forgiveness"]
[null,null,null,"· Assumption of debt"]
[null,null,null,"· Commitment of new funds"]
[null,null,null,"· Extension of loan term"]
[null,null,null,"· Forgiveness of interest payable"]
[null,null,null,"· Reduction in interest rate (measured as amount of interest saved over term of loan)"]
[null,null,"Commitments must contain no contingencies other than receipt of a tax credit award. At the time of application, written documentation from the funder justifying the amount and the terms of the contribution must be provided. Within six months of the date of selection (Minnesota Housing Board selection date) the applicant must provide Minnesota Housing with documentation of a firm commitment, authorization, or approval of the contribution. The documentation must state the amount, terms, and conditions, and be executed or approved at a minimum by the funder. Documentation containing words synonymous with “consider” or “may”, (as in “may award”) regarding the contribution, will not be considered acceptable.  Lack of acceptable documentation will result in the reevaluation and adjustment of the tax credits or RFP award, up to and including the total recapture of tax credits or RFP funds."]
[null,null,{"$f":"IF(AND(Controls!C53=TRUE,I259<0.1),\"The result of 11.2.b must be equal to or exceed 10%.  If not you must uncheck 11.2.b.\",\"\")","v":""}]
[null,null,"Points cannot be taken under 2.b. Funder Collaboration and the Federal/Local/Philanthropic Contributions scoring criterion for the same sources."]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["12. Permanent Housing for Individuals Experiencing Long-Term Homelessness ","     ",null,null,null,"5 to 110 Points",null,{"$f":"Controls!F54","v":0},0]
[]
[]
["Minnesota Housing Competitive Round or Tax Exempt Points (“non-Bonus” points) – 5 or 10 Points"]
[]
["“Non-Bonus” points will be awarded to permanent housing proposals in which a minimum of 5% (rounded up to the next full unit) of the total units, but no fewer than 4 units are set aside and rented to households experiencing long-term homelessness as defined in Minnesota Rules, Chapter 4900.3705:"]
[null,null,"5% to 9.99%, but no fewer than 4 units – 5 points"]
[null,null,"10% to 49.99%, but no fewer than 7 units – 7 points"]
[null,null,"50% to 100%, but no fewer than 20 units – 10 points"]
["Minnesota Housing Competitive Round or Non-Tax Exempt Points (“bonus” points) – 100 Points"]
[null,null,"Bonus Points – 100 points"]
["100 points (“bonus points”) will be available until a total of $1,975,000 (estimated 25 percent  of Minnesota Housing’s administered credit authority) in tax credits are awarded for qualifying permanent housing proposals with a minimum of 5% of units (rounded up to the next full unit), but no fewer than 4 units, targeting families with children or unaccompanied youth experiencing long-term homelessness selected in the 2016 Housing Tax Credit competitions.  For the purposes of this scoring category, an unaccompanied youth is defined as on his or her own without a parent or guardian and under age 25, including youth living with his/her own children. Once this maximum amount is reached, the 100 points (“bonus” points) will no longer be awarded for the remaining 2016 Tax Credit Program competitive funding rounds.  If qualified per the requirements of this section, applicants may claim the “bonus points”.  Minnesota Housing will make point reductions relating to the “bonus points” funding limits following its review of all applications in the funding round which claim these points.  Qualified proposals may earn a maximum of 10 points (“non-bonus” points) and may continue to compete in the appropriate set-aside."]
["To receive points under this category, the proposal must meet all of the following conditions:"]
["a)","the applicant must complete and submit the Supportive Housing application materials, including the narratives, forms and submittals identified in the Multifamily Rental Housing Common Application Request for Proposal Guide, and the  Multifamily Rental Housing Common Application Checklist; and"]
["b)","the applicant agrees to pursue and continue renewal of rental assistance, operating subsidy, or service funding contracts for as long as the funding is available."]
["A proposal which is awarded scoring points from this category and is selected to receive tax credits will be required to comply with the Long-Term Homelessness reporting requirements as defined by Minnesota Housing.  The Tax Credit Declaration of Land Use Restrictive Covenants, including a specific Rider to the Declaration, will contain performance requirements related to these long-term homelessness units and will be recorded with the property."]
[]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["13. High Speed Internet Access ","     ",null,null,null,"1 Point",null,0,0]
[]
["The development will provide High Speed Internet access via installation of all appropriate infrastructure and connections for cable, DSL or wireless internet service to every unit in the development.  This will be a design requirement if points are taken."]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["14. Location Efficiency ","     ",null,null,null,"1 to 9 Points",null,{"$f":"Controls!F59","v":0},0]
[]
["Points will be awarded for transit oriented developments or developments that promote location efficiency based on a combination of access to transportation and walkability."]
[]
[]
["Twin Cities Metropolitan Area:"]
[]
["In the Twin Cities Metropolitan area, points will be awarded for a combination of three areas: access to transit, walkability, and transit oriented development. "]
["1) Access to Transit:"]
["To receive points for access to transit in the Metropolitan area, a development must be:"]
[null,"Located within one half mile of a completed or planned LRT, BRT, or commuter rail station – 5 points; OR"]
[null,"Located within one quarter mile of a fixed route stop on Metro Transit’s Hi-Frequency Network – 4 points;  OR"]
[null,"Located within one quarter mile of a high service public transportation fixed route stop – 2 points; OR"]
[null,"Located within one half mile of an express bus route stop – 2 points; OR"]
[null,"Located within one half mile of a park and ride – 2 points"]
["2) Walkability:"]
["To receive points for walkability, a development must receive an award of points for Access to Transit above, and be:"]
[null,"Located in an area with a walk score of 70 or more according to www.walkscore.com** – 2 points; OR"]
[null,"Located in an area with a walk score between 50 and 69 according to www.walkscore.com** – 1 point;"]
["3) Transit Oriented Development:"]
["To receive up to 2 additional points for transit oriented development, a development must be located within one quarter mile of a completed or planned LRT, BRT, or commuter rail station. One point for a development which meets one of the following, and two points for a development which meets two or more of the following:"]
[null,"Parking:  Parking for residential units or visitors is not more than the smallest allowable parking minimum under local zoning requirements. If no residential parking or visitor parking is required under local zoning, no more than 0.2 visitor parking spaces per residential unit are provided. "]
[null,"Building Orientation and Connections:  Currently existing walkable or bikeable connections to station area via sidewalk or trail or funding secured to create such connections, and at least one accessible building entrance oriented toward such connections, and parking is not situated between building and station area."]
[null,"Density:  Site density at the maximum allowable density under the local comprehensive plan."]
[null,"Alternative Means:  Car sharing (Where one or more passenger automobiles are provided for common use by residents, bike storage, shared parking arrangements with adjacent property owners, etc. which results in a reduction in the local minimum parking requirement, and parking for residential units in not more than the local minimum parking requirement, or if no residential parking or visitor parking is required under local zoning, no more than 0.2 visitor parking spaces per residential unit are provided. "]
[]
["Greater Minnesota:"]
["In Greater Minnesota, location efficiency points will be awarded in a combination of access to transit and walkability in areas with fixed route transit service, and a combination of dial-a-ride, walkability, and access to jobs in areas without fixed route transit service."]
["A. For areas with fixed route transit service:"]
["1)    Access to Transit:"]
["To receive points for access to transit, a development in Greater Minnesota must be:"]
[null,"Located within one quarter mile of a public transportation fixed route stop – 7 points; OR"]
[null,"Located between one quarter mile and one half mile of a public transportation fixed route stop – 4 points; OR"]
[null,"Located less than one and one half mile of an express bus route stop or park and ride lot – 4 points; "]
["2)    Walkability:"]
["To receive points for walkability, a development must receive an award of points for Access to Transit above, and be:"]
[null,"Located in an area with a walk score of 70 or more according to www.walkscore.com** – 2 points; OR"]
[null,"Located in an area with a walk score between 50 and 69 according to www.walkscore.com** – 1 point;"]
["B. For areas without fixed route transit service:"]
["To receive four points for location efficiency, a development must be:"]
[null,"Located within a census tract that is within 5 miles of 2,000 low and moderate wage jobs for urban census tracts, or within 5 miles of 5,000 low and moderate wage jobs for rural census tracts, AND meets BOTH of the following:"]
[null,null,"The proposed housing has access to demand response/dial-a-ride* services during standard workday hours;  AND"]
[null,null,"The proposed housing is in an area with a walk score of 70 or more according to www.walkscore.com**  "]
["To receive three points for location efficiency, a development must be:"]
[null,"Located within a census tract that is within 5 miles of 2,000 low and moderate wage jobs for urban census tracts, or within 5 miles of 5,000 low and moderate wage jobs for rural census tracts, AND meets BOTH of the following:"]
[null,null,"The proposed housing has access to demand response/dial-a-ride* services during standard workday hours; AND  "]
[null,null,"The proposed housing is in an area with a walk score between 50 and 69 according to www.walkscore.com**  "]
["To receive two points for location efficiency, a development must be:"]
[null,"Located within a census tract that is within 5 miles of 2,000 low and moderate wage jobs for urban census tracts, or within 5 miles of 5,000 low and moderate wage jobs for rural census tracts, AND meets ONE of the following:"]
[null,null,"The proposed housing has access to demand response/dial-a-ride* services during standard workday hours; OR  "]
[null,null,"The proposed housing is in an area with a walk score of 70 or more according to www.walkscore.com**  "]
["To receive one point for location efficiency, a development must be:"]
[null,"Located within a census tract that is within 5 miles of 2,000 low and moderate wage jobs for urban census tracts, or within 5 miles of 5,000 low and moderate wage jobs for rural census tracts, AND meets ONE of the following:"]
[null,null,"The proposed housing has access to demand response/dial-a-ride* services during standard workday hours; OR  "]
[null,null,"The proposed housing is in an area with a walk score between 50 and 69 according to www.walkscore.com**  "]
["*Applicants must provide documentation of access and availability of service and describe how the service is a viable transit alternative that could be used for transportation to work, school, shopping, services and appointments. Minnesota Department of Transportation defines dial-a-ride as: “A demand-responsive service in which the vehicle is requested by telephone and vehicle routing is determined as requests are received.  Origin-to-destination service with some intermediate stops is offered.  Dial-A-Ride is a version of the taxicab using larger vehicles for short-to-medium distance trips in lower-density subregions”."]
["At the time of application, the applicant must submit a map identifying the location of the project with exact distances to the eligible public transit station/stop and include a copy of the route, span and frequency of service."]
["Access to transportation maps and census tract listings are found on Minnesota Housing’s website: "]
["  http://www.mnhousing.gov/get/MHFA_012466"]
["Additionally, find these details in the agency’s community profiles interactive mapping tool  "]
["http://www.mnhousing.gov/wcs/Satellite?c=Page&cid=1373870285684&pagename=External%2FPage%2FEXTStandardLayout"]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["15. Universal Design ","     ",null,null,null,"3 to 5 Points",null,{"$f":"Controls!F88","v":0},0]
[]
["Universal Design Unit Definition: A unit that includes all Minimum Essential Universal Design Features below, along with 8 Optional Features for units in a new construction or adaptive re-use project, and 4 Optional Features for units in a rehabilitation project. Type A accessible units (as referenced in Minnesota Housing’s Rental Housing Design and Construction Standards) are also considered to meet the definition of a Universal Design unit for the purposes of this scoring category."]
[null,"An elevator building with 100% of HTC units meeting the definition of a Universal Design Unit – 3 points; OR"]
[null,"A non-elevator building with at least 10% of HTC units meeting the definition of a Universal Design Unit – 3 points; OR"]
[null,"A project that is eligible for both 3 points under Universal Design for having units meeting the definition of a Universal Design Unit in the percentages required above AND either 3 points under the Serves Lowest Income Tenants/Rent Reduction scoring category for Option 4, OR at least 6 points under the Rental Assistance scoring category, OR at least 25 points under the Preservation scoring category. – 5 points"]
["Minimum Essential Universal Design Features "]
["· At least one bedroom or space that can be converted to a bedroom (without changing door locations for new construction or adaptive re-use) on an accessible level and connected to an accessible route."]
["· 42” minimum hallways for new construction or adaptive re-use"]
["· At least one three quarter bathroom on an accessible level with five foot open radius for new construction or adaptive re-use, and clear floor space of 30” x 48” for rehabilitation"]
["· Lever handles on all doors and fixtures"]
["· Provide wall blocking in all tub and shower areas for new construction or adaptive re-use, and for rehabilitation if showers are being replaced"]
["· Door thresholds flush with the floor with maximum threshold height of ½” beveled or ¼”square edged"]
["· Kitchen and laundry appliances have parallel approach clear floor space with all controls within maximum height of 48”. Range controls must have lockout feature. Stackable laundry units with a maximum reach range of 54” will meet this requirement"]
["· Kitchen sink area 30” wide minimum with cabinet panel concealing piping or a removable base cabinet"]
["· All common spaces and amenities provided in the housing development located on an accessible route"]
["· For new construction or adaptive re-use, deck or patio spaces have a step-less transition from dwelling unit meeting door threshold requirements, with decking gaps no greater than ¼”"]
["· Universal Design features are incorporated in an aesthetic, marketable, non-institutional manner"]
[]
["Optional Features "]
["· High contrast finish selections that include floor to wall transitions, top treads of stairs, counters and adjacent flooring and walls"]
["· Single lever, hands free or touch faucets"]
["· At least 50% of kitchen storage space within reach range. This can include pull-out shelves, full extension glide drawers or pantry design"]
["· A variety of work surface heights in kitchen and one five foot open radius"]
["· Roll under vanity or sink in twenty five percent of Universal Design qualifying units, rounded up to the nearest whole number"]
["·  Cabinet hardware with “D” type pull handles or operation for people with limited dexterity"]
["· Zero threshold shower or transfer space at tub is provided for minimum of half the qualifying Universal Design units, rounded up to the nearest whole number"]
["· Slip resistant flooring in kitchens and baths"]
["· Toilets provided with seats 17” – 19” from the floor"]
["· Windows are provided with maximum sill height of 36”, parallel clear floor space and locks/operating mechanism within 48” and easily operable with one hand. Sidelight or view window at main entry door from a seated position"]
["· Thermostats designed for visually impaired or ability to monitor and operate with electronic device such as a tablet computer"]
["· Closet storage is adjustable in a majority of the closets provided"]
["· Audio/Visual Doorbell"]
["· Covered entry with adequate lighting and interior or exterior bench space for parcels or groceries"]
["· Lettering and numbering with all characters and symbols contrasting with their background"]
["· Braille characters included to the left on all interior signage"]
["· Parking spaces provided for at least fifty percent of Universal Design qualifying units, rounded up to the nearest whole number, with a five foot wide adjacent auxiliary space connected to accessible route"]
["· Residential elevator or chair lift space structured for future use in multiple level homes"]
["· Enterprise Green Communities Model Specifications are used for applicable sections for the Universal Design qualifying units"]
["· On-site physical activity is provided for in a fitness area, biking or walking path or community garden"]
["· Other modifications which make units livable for disabled populations, as demonstrated by credible evidence provided in the application, at the sole discretion of Minnesota Housing"]
["Selection Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["16. Smoke Free Buildings ","     ",null,null,null,"1 Point",null,0,0]
[]
["One (1) point will be awarded for projects that will institute and maintain a written policy* prohibiting smoking in all the units and all common areas within the building/s of the project. The project must include a non-smoking clause in the lease for every household."]
["Projects awarded a point in this scoring criteria will be required to maintain the smoke-free policy for the term of the declaration. "]
["* The written policy must be submitted with the application and should include procedures regarding transitioning to smoke-free for existing residents and establishment of smoking areas outside of units and common areas if applicable. Consequences for violating the smoke-free policy are determined by owner but must be included in the written policy."]
["Preference Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["1. Serves Lowest Income Tenants/Rent Reduction    ","     ",null,null,null,"5 to 16 Points",null,{"$f":"Controls!F92","v":0},0]
[]
["Scores are based on gross rent level including utilities before rental assistance.  Eligible units must have rents affordable to households whose incomes do not exceed 30 percent or 50 percent of median income without rental assistance."]
[]
["In addition to the elected income limit of 50 percent or 60 percent AMI for the full term of the declaration (refer to the Minimum Set-Aside), the applicant agrees to maintain deeper rent structuring for which selection points are requested."]
[]
["Applicants may choose either option 1 or 2, and in addition, option 3 and/or option 4 for the development.  This selection will restrict rents only (tenant incomes will not be restricted to the 50 percent or 30 percent income level by claiming points in this section)."]
[null,{"$f":"\"Option 1 – A project in which 100 percent of the HTC unit rents representing \" & E413 & \" units are in the county 50 percent HUD area median rent limit – 10 points\"","v":"Option 1 – A project in which 100 percent of the HTC unit rents representing  units are in the county 50 percent HUD area median rent limit – 10 points"},null,null,null,null,null,null,null,null,null,{"$f":"IF(MAX(scDev13,scDev14)=0,\"\",scDev15/MAX(scDev13,scDev14))","v":""}]
[null,null,"Option 1 units",null,null,null,null,null,null,null,null,{"$f":"IF(Controls!C96=TRUE,IF(L412<0.3,\"Option 4 - 30% test not met.  Percentage as entered is only \"&TEXT(L412,\"0.0%\") & \"  You must uncheck Option 4.\",\"\"))","v":false}]
[]
[null,{"$f":"\"Option 2 – A project in which at least 50 percent of the HTC unit rents representing \" &E416 & \" units are at the county 50 percent HUD area median rent limit – 5 points\"","v":"Option 2 – A project in which at least 50 percent of the HTC unit rents representing  units are at the county 50 percent HUD area median rent limit – 5 points"}]
[null,null,"Option 2 units"]
[]
[null,null,null,"AND"]
[null,"Option 3 – In addition to Option 1 or 2, a project that restricts the rents of all the units identified in Option 1 or 2 to the 50 percent HUD area median rent limit for a minimum of ten years after the last placed in service date for any building in the property – 3 additional points"]
[null,null,null,"AND/OR"]
[null,{"$f":"\"Option 4 – In addition to Option 1 or 2, a project that further restricts 30 percent of the above restricted units to the county 30 percent HUD area median rent limit representing \" & E422 & \" units – 3 additional points\"","v":"Option 4 – In addition to Option 1 or 2, a project that further restricts 30 percent of the above restricted units to the county 30 percent HUD area median rent limit representing  units – 3 additional points"},null,null,null,null,null,null,null,null,null,{"$f":"IF(L413<>FALSE,L413,\"\")","v":""}]
[null,null,"Option 4 units"]
[{"$f":"IF(Controls!C96=TRUE,IF(L412<0.3,\"Option 4 - 30% test not met.  Percentage as entered is only \"&TEXT(L412,\"0.0%\") & \"  You must uncheck Option 4.\",\"\"),\"\")","v":""}]
["NOTE: If points are claimed/awarded for this category, then no points may be claimed/awarded from the selection priority category of Rental Assistance for the same units."]
["IMPORTANT"]
["If points are claimed/awarded for Options 1 or 2, all 50 percent rent restricted units must meet the 50 percent area median rent for a minimum of five years after the last placed in service date for any building in the property.  After the five year period has expired, rent may be increased to the 60 percent rent limit over a three year period with increases not to exceed the amount listed in the table below, provided that more restrictive threshold, selection priority or funding requirements do not apply."]
["If points are claimed/awarded for Option 4, all 30 percent rent restricted units must meet the 30 percent area median rent for a minimum of five years after the last placed in service date for any building in the property.  After the five year period has expired, rent may be increased to the 40 percent rent limit over a three-year period with increases not to exceed the amount listed in the table below, provided that more restrictive threshold, selection priority or funding requirements do not apply."]
[]
[null,null,"30% of 50%",null,"30% of 30%"]
[null,"YEAR","Rent Levels",null,"Rent Levels"]
[]
[null,"1 – 5","30% of 50%",null,"30% of 30%"]
[null,6,"30% of 53%",null,"30% of 33%"]
[null,7,"30% of 57%",null,"30% of 37%"]
[null,8,"30% of 60%",null,"30% of 40%"]
[]
["If points are claimed/awarded for this category’s Option 3, all 50 percent rent restricted units must meet the 50 percent area median rent for a minimum of ten years after the last placed in service date for any building in the property. After the ten year period has expired, rent may be increased to the 60 percent rent limit over a three year period with increases not to exceed the amount listed in the table below, provided that more restrictive threshold, selection priority, or funding requirements do not apply."]
[]
[null,null,"30% of 50%"]
[null,"YEAR","Rent Levels"]
[]
[null,"1 – 10","30% of 50%"]
[null,11,"30% of 53%"]
[null,12,"30% of 57%"]
[null,13,"30% of 60%"]
[]
["Minnesota Housing will incorporate these restrictions into the Declaration of Land Use Restrictive Covenants.  The applicant must demonstrate to sole satisfaction of Minnesota Housing that the property can achieve these reduced rents and remain financially feasible [IRC § 42(m)(2)].  Points are contingent upon financial plans demonstrating feasibility, positive cash flow on a 15-year pro forma and gaining Minnesota Housing management approval (for management, operational expenses, and cash flow assumptions)."]
["Preference Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["2. Rental Assistance ","     ",null,null,null,"4 to 21 Points",null,{"$f":"Controls!F97","v":0},0]
[]
["Priority is given to an owner that submits with the application a fully executed binding commitment (i.e. binding Resolution/binding Letter of Approval from the governing body) for project based rental assistance awarded in accordance with 24 CFR Ch. IX, Section 983.51 or are effectively project based by written contract. The assisted units must be located in buildings on the project site. A development that has existing rental assistance meeting the definition of federal assistance under the Preservation scoring category is not eligible for an award of points under Rental Assistance."]
["Rent for assisted units must be at or below Fair Market Rents (or appropriate payment standard for the project area).  Receiving these points and agreeing to a minimum number of assisted units does not release owners from their obligations under the Minnesota Human Rights Act and Section 42 prohibiting refusal to lease to the holder of a voucher of eligibility under Section 8 of the United States Housing Act of 1937 because of the status of the prospective tenant as such a holder."]
["A current request for Minnesota Housing Rental Assistance will not receive Rental Assistance points.  A past award of existing Rental Assistance will be counted toward meeting the required percentages.  Indicate the applicable combinations of the below components.  Points for A, B, C and D cannot be claimed in any combination.  "]
[null,"(A) For developments agreeing to set aside and having the required binding commitment for 100 percent of the total units for project based rental assistance – 17 points"]
[null,"(B) For developments agreeing to set aside and having the required binding commitment for at least 51 percent of the total units for project based rental assistance – 13 points"]
[null,"(C) For developments agreeing to set aside and having the required binding commitment for at least 20 percent but under 51 percent of the total units for project based rental assistance – 10 points"]
[null,"(D) For developments agreeing to set aside and having the required binding commitment for at least 10 percent but under 20 percent of the total units for the project based rental assistance – 6 points"]
[null,"(E) For selection components A, B, C, or D above, if, in addition, the above binding commitments are coupled with a binding commitment to provide the project based rental assistance for a minimum 10 year new or remaining contract term – 4 points"]
[null,"(F) For selection components A, B, C, or D above, if, in addition, the above binding commitments are coupled with a binding commitment to provide the project based rental assistance for a 4 to 9 year new or remaining contract term – 2 points"]
["NOTE: If points are claimed/ awarded under any of the above, then no points may be claimed/ awarded from the preference priority categories of Serves Lowest-Income Tenants/Rent Reduction for the same units."]
["NOTE:  Points cannot be claimed/ awarded under the Rental Assistance preference priority if points are claimed/ awarded for the same units for Existing Federal Assistance under the Preservation selection priority.  "]
[null,"(G) For developments that cooperatively develop a housing plan/agreement to provide other Rental Assistance (e.g. Section 8, portable tenant based, formal recommendation for McKinney Vento Shelter Plus Care rent assistance, or other similar programs approved by Minnesota Housing) to meet the existing need as evidenced at application by a letter of intent signed by both the applicant and the local housing authority or other similar entities – 4 points"]
["To receive these points, the applicant must comply with all program requirements for the assistance for which priority points were given, including maintaining rents within the appropriate payment standard for the project area in which the project is located for the full compliance and extended use period of the housing tax credits."]
["As a condition of Carryover or 8609, the applicant must submit a copy of the fully executed contract for the project-based rental assistance to be included in the development."]
["For project based rental assistance in conjunction with a binding commitment for an “extended term contract” at time of application the applicant must submit a binding commitment for the “extended term contract” for project based assistance for a minimum of 4 or 10 years which is signed by the Local Housing Authority or other similar entity.  As a condition of Carryover or 8609, the applicant must submit a fully executed copy of the “extended term contract” for the project based assistance to be included in the development."]
["For Other Rental Assistance (e.g.., Section 8, portable tenant based, formal recommendation for McKinney Vento Shelter Plus Care rent assistance or other similar rent assistance programs approved by Minnesota Housing), at time of application the applicant must submit a letter of intent to cooperatively develop a housing plan/agreement which is signed by the applicant and Local Housing Authority or other similar entity along, with the completed Agreement to Utilize Public Housing and Section 8 Waiting Lists.  As a condition of Carryover or 8609, the applicant must submit a fully executed copy of the cooperatively developed housing plan/agreement."]
["Preference Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["3. QCT/Community Revitalization ","     ",null,null,null,"1 Point",null,0,0]
[]
["A point is awarded to projects that are located in a Qualified Census Tract (See Qualified Census Tract – Reference Materials Index) and are part of a concerted plan that provides for community revitalization.  This must be evidenced by a letter from the local jurisdiction verifying that the proposed project is part of an approved community revitalization area as established by resolution or other legal action."]
["Preference Priorities",null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
["4. Cost Containment ","     ",null,null,null,"4 Points",null,0,0]
[]
["Four points will be available to the 50% of developments with the lowest costs within each development type/location group (subject to the methodology described in Revised Cost Containment Methodology"]
["http://www.mnhousing.gov/get/MHFA_1012112"]
["Applicants may claim these points and Minnesota Housing will make point reductions following its review of costs for all applications in the funding round."]
["Applications seeking 4% tax credits for use in conjunction with tax exempt bonds are not eligible to claim points through this Cost Containment priority.  Only applications seeking tax credits through Minnesota Housing’s 9% Competitive application process for tax credits are eligible to claim points through this priority."]
["NOTE:  Proposals that believe they have contained their costs should select these points."]
["Only proposals that claim cost containment points on the self-scoring worksheet and are awarded points through the process described above will receive cost containment points."]
["CAUTION:  If a project receives points under this criterion, failure to keep project costs under the applicable cost threshold will be considered an unacceptable practice and result in negative 4 points being awarded in all of the applicant’s tax credit submissions in the next funding round in which submissions are made."]
["If developers are concerned about their costs and keeping them within the “applicable cost threshold,” they should not claim the cost-containment points."]
["TOTAL POINTS","     ",null,null,null,null,null,{"$f":"SUM(score1a,score2a,score3a,score4a,score5a,score6a,score7a,score8a,score9a,score10a,score11a,score12a,score13a,score14a,score15a,score16a,bonus1a,bonus2a,bonus3a,bonus4a)","v":0},{"$f":"SUM(score1b,score2b,score3b,score4b,score5b,score6b,score7b,score8b,score9b,score10b,score11b,score12b,score13b,score14b,score15b,score16b,bonus1b,bonus2b,bonus3b,bonus4b)","v":0}]
[null,null,null,null,null,null,null,"Developer Claimed","Minnesota Housing Awarded"]
[{"$f":"IF(Controls!S40=\"YesM\",Q487,\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTICE OF DEFICIENCY - To receive points in 11.2.a you must choose and appropriate threshold and also claim and be awarded points for at least three of the following scoring criteria: Economic Integration, Location Efficiency, Workforce Housing Communities, Temporary Priority – Foreclosed Properties, OR QCT/Community Revitalization; AND must also claim and be awarded points under Serves Lowest Income Tenants/Rent Reduction for either Option 1 OR Option 2, AND Option 3.  See a recap of points claimed at right."]
[]
[]
[null,{"$f":"IF(Test112aMessage=\"YesM\",Controls!Y41,\"\")","v":""}]
[null,{"$f":"IF(Test112aMessage=\"YesM\",Controls!Y42,\"\")","v":""}]
[null,{"$f":"IF(Test112aMessage=\"YesM\",Controls!Y44,\"\")","v":""}]
[null,{"$f":"IF(Test112aMessage=\"YesM\",Controls!Y45,\"\")","v":""},{"$f":"L484","v":0}]
[null,{"$f":"IF(Test112aMessage=\"YesM\",Controls!Y43,\"\")","v":""},0]
[null,{"$f":"IF(Test112aMessage=\"YesM\",Controls!Y46,\"\")","v":""},0]
[null,{"$f":"IF(Test112aMessage=\"YesM\",Controls!Y48,\"\")","v":""},0]
[null,{"$f":"IF(Test112aMessage=\"YesM\",Controls!Y49,\"\")","v":""},0]
[null,{"$f":"IF(Test112aMessage=\"YesM\",Controls!Y50,\"\")","v":""},0]
[null,{"$f":"IF(Test112aMessage=\"YesM\",Controls!Y52,\"\")","v":""},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"IF(Controls!Q86=\"YesM\",Controls!S94,\"\")","v":""}]
[]
[]
[null,{"$f":"IF(q15test=\"YesM\",Controls!S88,\"\")","v":""}]
[null,{"$f":"IF(q15test=\"YesM\",Controls!S89,\"\")","v":""}]
[null,{"$f":"IF(q15test=\"YesM\",Controls!S90,\"\")","v":""}]
[]
["Under penalty of perjury, Owner hereby certifies the information provided herein is true and accurate."]
[]
[]
[]
["Name of Owner:"]
[]
[]
[]
[]
[]
["By:"]
[null,"(Signature)"]
[]
[]
["Of:","     "]
[null,"(Name of Legal Entity)"]
[]
[]
["Its:","     "]
[null,"(Title) (Managing General Partner)"]
[]
[]
[null,"     "]
[null,"(Print or type name of signatory)"]
[]
[]
[]
[]
["Note:  During the competition process, Minnesota Housing’s review of the submitted self-scoring worksheet is only to validate that the points claimed are eligible, to reduce points claimed if not eligible, and to determine points awarded.  Minnesota Housing will not award additional points which are not initially claimed by the Applicant/Owner.  Many performance obligations are created by the claiming of certain scoring points.  As such, Minnesota Housing cannot and will not assume the position of creating any such performance obligations on behalf of the Applicant/Owner.  In addition, applications funded under the Joint Powers Agreement must also comply with the suballocators selection criteria defined in their Qualified Allocation Plan."]

{"sheet":"Controls","index":1,"n_rows":108,"n_cols":25,"rows_kept":108,"cut":false,"hidden":true,"merged":[[59,0,69,0],[70,0,86,0]]}
["Criteria","Control","Value","Points","Earned","DevScore","MHScore"]
["ThA",null,{"$f":"COUNTIF(C3:C5,TRUE)","v":0}]
[null,"cbReq1",false]
[null,"cbReq2",false]
[null,"cbReq3",false]
["ThB",null,{"$f":"IF(C7=TRUE,1,0)","v":0}]
[null,"cbReq4",false]
["ThC",null,{"$f":"COUNTIF(C9:C13,TRUE)","v":0}]
[null,"cbReq5",false]
[null,"cbReq6",false]
[null,"cbReq7",false]
[null,"cbReq8",false]
[null,"cbReq9",false]
["ThD",null,{"$f":"IF(C15=TRUE,1,0)","v":0}]
[null,"cbReq10",false]
["ThE",null,{"$f":"IF(C17=TRUE,1,0)","v":0}]
[null,"cbReq11",false]
[1,null,null,null,null,{"$f":"SUM(E19:E21)","v":0}]
[null,"cb1a",false,10,{"$f":"IF(C19=TRUE,D19,0)","v":0}]
[null,"cb1b",false,10,{"$f":"IF(C20=TRUE,D20,0)","v":0}]
[null,"cb1c",false,5,0]
[2,null,null,null,null,{"$f":"SUM(E23:E25)","v":0}]
[null,"cb2a",false,10,0]
[null,"cb2b",false,2,0]
[null,"cb2c",false,10,0]
[3,null,null,null,null,{"$f":"SUM(E27:E29)","v":0}]
[null,"cb3a",false,2,0]
[null,"cb3b",false,9,0]
[null,"cb3c",false,7,0]
[4,null,null,null,null,{"$f":"score4a","v":0}]
[5,null,null,null,null,{"$f":"J31","v":0},null,5,{"$f":"'Self Scoring'!I102","v":0},{"$f":"VLOOKUP(I31,I32:J37,2,TRUE)","v":0}]
[6,null,{"$f":"'Self Scoring'!I137","v":0},null,null,{"$f":"M32","v":0},null,null,0,0,6,{"$f":"'Self Scoring'!I137","v":0},{"$f":"VLOOKUP(L32,L33:M40,2,TRUE)","v":0}]
[7,null,{"$f":"'Self Scoring'!I153","v":0},null,null,{"$f":"P33","v":6},null,null,2.0899999999999998E-2,2,null,0,0,7,{"$f":"'Self Scoring'!I153","v":0},{"$f":"VLOOKUP(O33,O34:P38,2,TRUE)","v":6}]
[8,null,null,null,null,{"$f":"score8a","v":0},null,null,5.0900000000000001E-2,4,null,0.1,2,null,0,6]
[9,null,null,null,null,{"$f":"score9a","v":0},null,null,0.1009,6,null,0.2,4,null,0.151,3,null,null,"To choose this option you must meet all the requirements.  You may need to go to Section 14 and Section 1 in the Preference Prioroties and first complete those selections.  Then return to this section to continue.  "]
[10,null,null,null,null,{"$f":"SUM(E37:E39)","v":0},null,null,0.15090000000000001,8,null,0.3,6,null,0.20100000000000001,2]
[null,"cb10a",false,10,{"$f":"IF(C37=TRUE,D37,0)","v":0},null,null,null,0.2009,10,null,0.4,8,null,0.251,1]
[null,"cb10b",false,5,0,null,null,null,null,null,null,0.5,10,null,0.30099999999999999,0]
[null,"cb10c",false,5,0,null,null,null,null,null,null,0.6,12]
[11,null,null,null,null,{"$f":"SUM(E41:E53)","v":0},null,null,null,null,null,0.7,14,null,null,null,null,null,{"$f":"IF(C52=FALSE,\"NoM\",IF(AND(test112a>=3,O49=\"Yes\",O51=\"Yes\"),\"NoM\",\"YesM\"))","v":"NoM"},null,null,{"$f":"Y42&Y43&Y44&Y45&Y46&Y48&Y49&Y50","v":"0 points for 3. Economic Integration0 points for 14. Location Efficency0 points for 4. Workforce Housing Communities0 points for 10. Temporary Priority – Foreclosed Properties0 points for Preference Priorities 3. QCT/Community Revitalization0 points for Option 1 Preference Priorities 1. Serves Lowest Income Tenants/Rent Reduction0 points for Option 2 Preference Priorities 1. Serves Lowest Income Tenants/Rent Reduction0 points for Option 3 Preference Priorities1. Serves Lowest Income Tenants/Rent Reduction"}]
[null,"cb11a",false,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.2.a associated points claimed are as follows:"]
[null,"cb11b",false,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q42>0,1,0)","v":0},null,{"$f":"F26","v":0},"3. Economic Integration",null,null,null,null,null,null,{"$f":"Q42 &\" points for \" & R42","v":"0 points for 3. Economic Integration"}]
[null,"cb11c",false,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q43>0,1,0)","v":0},null,{"$f":"F59","v":0},"14. Location Efficency",null,null,null,null,null,null,{"$f":"Q43 &\" points for \" & R43","v":"0 points for 14. Location Efficency"}]
[null,"cb11d",false,25,0,null,null,null,null,null,null,null,null,null,0,null,{"$f":"F30","v":0},"4. Workforce Housing Communities",null,null,null,null,null,null,{"$f":"Q44 &\" points for \" & R44","v":"0 points for 4. Workforce Housing Communities"}]
[null,"cb11e",false,1,0,null,null,null,null,null,null,null,null,null,0,null,{"$f":"F36","v":0},"10. Temporary Priority – Foreclosed Properties",null,null,null,null,null,null,{"$f":"Q45 &\" points for \" & R45","v":"0 points for 10. Temporary Priority – Foreclosed Properties"}]
[null,"cn11f",false,3,0,null,null,null,null,null,null,null,null,null,0,null,{"$f":"F105","v":0},"Preference Priorities 3. QCT/Community Revitalization",null,null,null,null,null,null,{"$f":"Q46 &\" points for \" & R46","v":"0 points for Preference Priorities 3. QCT/Community Revitalization"}]
[null,"cb11g",false,7,0,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O42:O46)","v":0},null,null,"AND",null,"Preference Priorities - 1"]
[null,"cb11h",false,10,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E93","v":0},"Option 1 Preference Priorities 1. Serves Lowest Income Tenants/Rent Reduction",null,null,null,null,null,null,{"$f":"Q48 &\" points for \" & R48","v":"0 points for Option 1 Preference Priorities 1. Serves Lowest Income Tenants/Rent Reduction"}]
[null,"cb11i",false,3,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(Q48:Q49)>0,\"Yes\",\"No\")","v":"No"},null,{"$f":"E94","v":0},"Option 2 Preference Priorities 1. Serves Lowest Income Tenants/Rent Reduction",null,null,null,null,null,null,{"$f":"Q49 &\" points for \" & R49","v":"0 points for Option 2 Preference Priorities 1. Serves Lowest Income Tenants/Rent Reduction"}]
[null,"cb11j",false,5,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E95","v":0},"Option 3 Preference Priorities1. Serves Lowest Income Tenants/Rent Reduction",null,null,null,null,null,null,{"$f":"Q50 &\" points for \" & R50","v":"0 points for Option 3 Preference Priorities1. Serves Lowest Income Tenants/Rent Reduction"}]
[null,"cb11k",false,10,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q52>0,\"Yes\",\"No\")","v":"No"},null,null,"AND"]
["112a","cb11l",false,9,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E96","v":0},"Option 4 Preference Priorities1. Serves Lowest Income Tenants/Rent Reduction",null,null,null,null,null,null,{"$f":"Q52 &\" points for \" & R52","v":"0 points for Option 4 Preference Priorities1. Serves Lowest Income Tenants/Rent Reduction"}]
["112b","cb11m",false,5,0,null,null,null,{"$f":"'Self Scoring'!I259","v":0},null,null,null,null,null,null,null,{"$f":"E53","v":0},"Points taken under 2.b. Funder Collaboration and the Federal/Local/Philanthropic Contributions scoring criterion for the same sources."]
[12,null,null,null,null,{"$f":"SUM(E55:E57,E108)","v":0}]
[null,"cb12a",false,5,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C52=FALSE,\"\",IF(OR(C41=TRUE,C42=TRUE,C43=TRUE),\"\",\"No Threshold Preference choosen for 11\"))","v":""}]
[null,"cb12b",false,7,0]
[null,"cb12c",false,10,{"$f":"IF(C57=TRUE,D57,0)","v":0}]
[13,null,null,null,{"$f":"IF(C58=TRUE,D58,0)","v":0},{"$f":"score13a","v":0}]
[14,null,null,null,null,{"$f":"MAX(H60,I60)","v":0},null,"TC","GM"]
["Twin Cities","cb14a",false,5,0,{"$f":"SUM(E60:E64)","v":0},null,{"$f":"SUM(F60,F65,F67)","v":0},{"$f":"SUM(F71,F76,F79,F82,F85)","v":0}]
[null,"cb14b",false,4,0]
[null,"cb14c",false,2,0]
[null,"cb14d",false,2,0]
[null,"cb14e",false,2,0]
[null,"cb14f",false,2,0,{"$f":"SUM(E65:E66)","v":0}]
[null,"cb14g",false,1,0]
[null,"cb14h",false,1,0,{"$f":"IF(SUM(E67:E70)=0,0,CHOOSE(SUM(E67:E70),1,2,2,2))","v":0}]
[null,"cb14i",false,1,0]
[null,"cb14j",false,1,0]
[null,"cb14k",false,1,0]
["Greater Minnesota","cb14l",false,7,0,{"$f":"SUM(E71:E75)","v":0}]
[null,"cb14m",false,4,0]
[null,"cb14n",false,4,0]
[null,"cb14o",false,2,0]
[null,"cb14p",false,1,0]
[null,"cb14q",{"$f":"IF(AND(C77,C78)=TRUE,TRUE,FALSE)","v":false},4,0,{"$f":"IF(C76=TRUE,D76,0)","v":0},null,null,"4 for 2"]
[null,"cb14r",false,null,0]
[null,"cb14s",false,null,0]
[null,"cb14t",{"$f":"IF(AND(C80,C81)=TRUE,TRUE,FALSE)","v":false},3,{"$f":"IF(C79=TRUE,D79,0)","v":0},{"$f":"IF(C79=TRUE,D79,0)","v":0},null,null,"3 for 2"]
[null,"cb14u",false]
[null,"cb14v",false]
[null,"cb14w",{"$f":"IF(OR(C83,C84)=TRUE,TRUE,FALSE)","v":false},2,{"$f":"IF(C82=TRUE,D82,0)","v":0},{"$f":"IF(C82=TRUE,D82,0)","v":0},null,null,"2 for 1"]
[null,"cb14x",false]
[null,"cb14y",false]
[null,"cb14z",{"$f":"IF(OR(C86,C87)=TRUE,TRUE,FALSE)","v":false},1,0,{"$f":"IF(C85=TRUE,D85,0)","v":0},null,null,"1 for 1"]
[null,"cb14aa",false,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q92=\"Y\",IF(C89=TRUE,\"NoM\",IF(C90=TRUE,\"NoM\",IF(AND(Q92=\"Y\",SUM(Q88:Q90)>0),\"NoM\",\"YesM\"))),\"NoM\")","v":"NoM"}]
[null,"cb14ab",false,null,null,null,null,null,null,null,null,null,null,null,null,null,"meets",null,"15c associated points claimed are as follows:"]
[15,null,null,null,null,{"$f":"SUM(E89:E91)","v":0},null,null,null,null,null,null,null,null,3,null,{"$f":"IF(E96=O88,1,0)","v":0},"P1",{"$f":"E96 & \" points for \" &\"Serves Lowest Income Tenants/Rent Reduction Option 4\"","v":"0 points for Serves Lowest Income Tenants/Rent Reduction Option 4"}]
[null,"cb15a",false,3,{"$f":"IF(C89=TRUE,D89,0)","v":0},null,null,null,null,null,null,null,null,null,6,null,{"$f":"IF(F97>=O89,1,0)","v":0},"P2",{"$f":"F97&\" points for \"&\"Rental Assistance\"","v":"0 points for Rental Assistance"}]
[null,"cb15b",false,3,0,null,null,null,null,null,null,null,null,null,25,null,{"$f":"IF(F40>=O90,1,0)","v":0},11,{"$f":"F40 & \" points for \" & \"Preservation\"","v":"0 points for Preservation"}]
[null,"cb15c",false,5,0]
["P -1",null,null,null,null,{"$f":"SUM(E93:E96)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F88>0,\"Y\",\"N\")","v":"N"},15,{"$f":"F88 & \" points under Universal Design (15c) for having units meeting the definition of a Universal Design Unit\"","v":"0 points under Universal Design (15c) for having units meeting the definition of a Universal Design Unit"}]
[null,"cb16a",false,10,{"$f":"IF(C93=TRUE,D93,0)","v":0}]
[null,"cb16b",false,5,{"$f":"IF(C94=TRUE,D94,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTICE OF DEFICIENCY - A project that is eligible for both 3 points under Universal Design for having units meeting the definition of a Universal Design Unit in the percentages required above AND either 3 points under the Serves Lowest Income Tenants/Rent Reduction scoring category for Option 4, OR at least 6 points under the Rental Assistance scoring category, OR at least 25 points under the Preservation scoring category."]
[null,"cb16c",false,3,0]
[null,"cb16d",false,3,0]
["P-2",null,null,null,null,{"$f":"SUM(E98:E104)","v":0}]
[null,"cb16e",false,17,0]
[null,"cb16f",false,13,0]
[null,"cb16g",false,10,0]
[null,"cb16h",false,6,0]
[null,"cb16i",false,4,0]
[null,"cb16j",false,2,0]
[null,"cb16k",false,4,0]
["P-3",null,null,null,null,{"$f":"bonus3a","v":0}]
["P-4",null,null,null,null,{"$f":"bonus4a","v":0}]
[16,null,null,null,null,{"$f":"score16a","v":0}]
[12,"cb12d",false,100,{"$f":"IF(C108=TRUE,D108,0)","v":0}]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}