{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Scoring Notes","Developer Scoring","MHDC Score","CB and US Counties","County Table","CHAS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":37,"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":"Scoring Notes","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Phase III - General Scoring:"]
[null,"Income Targeting:","Units for Income Targeting must be designated properly in the \"AMGI Designation\" column on the \"VIIa. Development Plan\" worksheet within the FIN-100."]
[null,"Mixed Income Development","A development must have at least 10% market rate units or 10% Income Averaging Units at 80% AMI to qualify for these points. The market rate units must be designated properly in the \"Market\" column under \"Primary Unit Designation\" on the \"VIIa. Development Plan\" worksheet within the FIN-100. 80% units qualifying under the Income Average Set-Aside must be designated at 80% in the \"AMGI Designation\" column on the \"VIIa. Development Plan\" worksheet within the FIN-100."]
[null,"Tenant Ownership","Developments must have a \"Homeownership Plan\" exhibit within their application package to qualify for points in this category."]
[null,"Permanent Supportive Housing / Vulnerable Population","Units must be designated properly in the \"SA - Vuln - Pop\" or \"SA - Permanent Supportive Housing\" column on the \"VIIa. Development Plan\" worksheet within the FIN-100. Rents for these units must meet rent guidelines specified in the QAP."]
[null,"Preservation","If the development has MHDC financing or is encumbered by a LURA and/or Regulatory Agreement with MHDC, it must have a preservation letter from MHDC. If the development has HUD financing, it must have both a MHDC and a HUD letter of preservation. If the development has Rural Development financing, it must have both a MHDC and a Rural Development letter of preservation."]
[null,"Extented Compliance","Developments must waive their right to opt-out and specify how many years they are extending their \"Compliance Period\" on the \"IX. Tax Credit Addendum\" spreadsheet within the FIN-100 to qualify for points in this category."]
[null,"Leveraged Funds","Points are only allowed for qualified funds that are permanent financing."]
[null,"Rental Assitance","The amount of rental assistance required to qualify for points in this category is calculated as the difference between net rent and 30% of household income. The minimum amount of available rent assistance per assisted unit must be at least 15% of net rent for a minimum of three years. Please see the Developer Guide for additional detail."]

{"sheet":"Developer Scoring","index":1,"n_rows":140,"n_cols":8,"rows_kept":140,"cut":false,"hidden":false,"merged":[[142,2,153,5],[5,5,5,6],[0,1,0,6],[57,2,57,4],[133,2,135,5],[1,3,1,6],[4,3,4,6],[2,5,2,6],[7,1,7,6],[139,2,140,5],[85,2,85,4]]}
[null,"Please complete BROWN colored cells"]
[null,"Property Name:"]
[null,"Target Population:",null,null,"   Type of Construction:   "]
[]
[null,"Developer:",null,null,null,null,null,{"$f":"IF(AND(D3=\"Family\",(OR(F3=\"New\",F3=\"New + Rehab\"))),1,IF(AND(D3=\"Senior\",(OR(F3=\"New\",F3=\"New + Rehab\"))),2,IF(AND(D3=\"Family\",(OR(F3<>\"New\",F3<>\"New + Rehab\"))),3,IF(AND(D3=\"Senior\",(OR(F3<>\"New\",F3<>\"New + Rehab\"))),4))))","v":false}]
[null,"County:",null,"Select","   Self-Score Total Points:   ",{"$f":"F122","v":0}]
[]
[null,"MHDC has NOT included the following categories for self-scoring: Services, Opportunity Area, Economic Development, Credit Efficiency and Development Team Prior Performance. However; questions about some of these categories need completed at the bottom of this spreadsheet."]
[]
[null,"v1.0.072823"]
[]
[]
[null,null,"Phase I - Threshold Documents"]
[]
[null,null,"Executed FIN-100",null,null,"Select"]
[]
[null,null,"Application Fee",null,null,"Select"]
[]
[null,null,"Questionnaire",null,null,"Select"]
[]
[null,null,"Financing Letters of Intent",null,null,"Select"]
[]
[null,null,"Notifications"]
[null,null,"Chief Executive of Local Jurisdiction",null,null,"Select"]
[null,null,"State Senator",null,null,"Select"]
[null,null,"State Representative",null,null,"Select"]
[null,null,"Executive Director of Local HFA",null,null,"Select"]
[]
[null,null,"Economic Impact to Missouri (provided in FIN-100)"]
[null,null,"Proposed Services",null,null,"Select"]
[null,null,"Number of employees in Missouri",null,null,"Select"]
[null,null,"Percent of hard and soft costs from MO based firms",null,null,"Select"]
[null,null,"Projected Medicaid Savings (Sr. and Supportive Housing only)",null,null,"Select"]
[]
[null,null,"Pass/Fail",null,null,{"$f":"IF(OR(F15=\"No\",F17=\"No\",F19=\"No\",F21=\"No\",F24=\"No\",F25=\"No\",F26=\"No\",F27=\"No\",F30=\"No\",F31=\"No\",F32=\"No\",F33=\"No\",F15=\"Select\",F17=\"Select\",F19=\"Select\",F21=\"Select\",F24=\"Select\",F25=\"Select\",F26=\"Select\",F27=\"Select\",F30=\"Select\",F31=\"Select\",F32=\"Select\",F33=\"Select\"),\"Fail\",\"Pass\")","v":"Fail"}]
[]
[null,null,"Phase II - Priority Scoring"]
[]
[null,null,"Priority Group"]
[null,null,"Workforce Housing",null,null,"Select"]
[null,null,"Non-Profit (as defined in section III of 2023 QAP)",null,null,"Select"]
[null,null,"Service Enriched including Veterans Housing",null,null,"Select"]
[null,null,"Permanent Supportive Housing, Vulnerable Populations, and Independence Enabling",null,null,"Select"]
[null,null,"Preservation",null,null,"Select"]
[null,null,"CDBG-DR",null,null,"Select"]
[null,null,"HOME CHDO",null,null,"Select"]
[null,null,"Opportunity Area (as defined in section III of 2023 QAP)",null,null,"Select"]
[null,null,"Opportunity Zone (as enacted under the 2017 Tax Cuts & Jobs Act)",null,null,"Select"]
[]
[null,null,"Phase II Points",null,null,{"$f":"IF(OR(F40=\"Yes\",F41=\"Yes\",F42=\"Yes\",F43=\"Yes\",F44=\"Yes\",F45=\"Yes\",F46=\"Yes\",F47=\"Yes\",F48=\"Yes\"),45,0)","v":0}]
[]
[null,null,"Phase III - General Scoring"]
[]
[null,null,"Development Characteristics "]
[]
[null,null,"Income Targeting (max 10 pts) (no more than 1 category)"]
[null,null,"Location",null,null,"Select"]
[null,null,{"$f":"IF(F57=\"SL/KC\",\">15% of units at 30% AMI (10 pts)\",IF(F57=\"Rural MSA\",\">12.5% of units at 30% AMI (10 pts)\",IF(F57=\"Rural Non-MSA\",\">10% of units at 30% AMI (10 pts)\",\"Select Location Above\")))","v":"Select Location Above"},null,null,0]
[null,null,{"$f":"IF(F57=\"SL/KC\",\">10% of units at 30% AMI (6 pts)\",IF(F57=\"Rural MSA\",\">7.5% of units at 30% AMI (6 pts)\",IF(F57=\"Rural Non-MSA\",\">5% of units at 30% AMI (6 pts)\",\"Select Location Above\")))","v":"Select Location Above"},null,null,0]
[null,null,{"$f":"IF(F57=\"SL/KC\",\">10% of units at 40% AMI (4 pts)\",IF(F57=\"Rural MSA\",\">7.5% of units at 40% AMI (4 pts)\",IF(F57=\"Rural Non-MSA\",\">5% of units at 40% AMI (4 pts)\",\"Select Location Above\")))","v":"Select Location Above"},null,null,0]
[null,{"$f":"MAX(F58:F61)","v":0},{"$f":"IF(F57=\"SL/KC\",\">10% of units at 50% AMI (2 pts)\",IF(F57=\"Rural MSA\",\">7.5% of units at 50% AMI (2) pts)\",IF(F57=\"Rural Non-MSA\",\">5% of units at 50% AMI (2 pts)\",\"Select Location Above\")))","v":"Select Location Above"},null,null,0]
[]
[null,null,"Mixed Income Development (10 pts)",null,null,0]
[]
[null,null,"Tenant Ownership (5 pts)",null,null,0]
[]
[null,null,"Permanent Supportive Housing / Vulnerable Population (5 pts)",null,null,0]
[]
[null,null,"Previous Phase Success (1 pt)",null,null,0]
[]
[null,null,"Site Location (max 15 pts based on County selection at Top)"]
[null,null,"Cost Burdened Households 1a (no more than 1 category)"]
[null,null,"> 20% Cost Burden (10 pts)",null,null,{"$f":"IFERROR(IF((VLOOKUP(D6,'CB and US Counties'!A5:G119,7,FALSE))=10,10,0),0)","v":0}]
[null,null,"> 15% Cost Burden (7 pts)",null,null,{"$f":"IFERROR(IF((VLOOKUP(D6,'CB and US Counties'!A5:G119,7,FALSE))=7,7,0),0)","v":0}]
[null,null,"> 10% Cost Burden (5 pts)",null,null,{"$f":"IFERROR(IF((VLOOKUP(D6,'CB and US Counties'!A5:G119,7,FALSE))=5,5,0),0)","v":0}]
[null,{"$f":"MAX(F73:F75)","v":0},"Rural Underserved County - 2a (5 pts)",null,null,{"$f":"IFERROR(VLOOKUP(D6,'CB and US Counties'!A5:H119,8,FALSE),0)","v":0}]
[]
[null,null,"Preservation (10 pts)",null,null,0]
[]
[null,null,"Extended Compliance (up to 5 pts) (no more than 1 category)"]
[null,null,null,"5 - 9 yrs (Total Compliance Period 20-24 yrs)",null,0]
[null,null,"Zoned (10 pts)","10 - 14 yrs (Total Compliance Period 25-29 yrs)",null,0]
[null,{"$f":"MAX(F81:F83)","v":0},"Not Zoned but with Waiver (10 pts)",">=15 yrs (Total Compliance Period 30+ yrs)",null,0]
[]
[null,null,"Use of Resources (max 10 pts)"]
[null,null,"Construction Leverage Funds (min Construction Loan > = 50% TDC) (0,1,3 or 5 pts)",null,null,0]
[null,null,"Permanent Leverage Funds "]
[null,null,"> 2.5% (3 pts)",null,null,0]
[null,{"$f":"MAX(F88:F90)","v":0},"> 5% (5 pts)",null,null,0]
[null,{"$f":"IF(B89+F86>10,10,F86+B89)","v":0},"> 7.5% (10 pts)",null,null,0]
[]
[null,null,"Federal Historic Tax Credits (5 pts)",null,null,0]
[]
[null,null,"National Housing Trust Fund (3 pts)",null,null,0]
[]
[null,null,"HOME CHDO - requesting no LIHTC (10 pts)",null,null,0]
[]
[null,null,"Total Development Costs (10 pts for being under limits)",null,null,0]
[]
[null,null,"Rental Assistance (5 pts)",null,null,0]
[]
[null,null,"Credit Efficiency (-5/0/5 pts)",null,null,0]
[null,null,"Total Credit Efficiency",null,null,{"$f":"IFERROR((F104*F105/E114),0)","v":0}]
[null,null,"Total 4% or 9% Qualified Basis (including acquisition basis)",null,null,0]
[null,null,"Applicable Fraction (must complete)",null,null,0]
[null,null,null,"# Total Units","# LIHTC Units"]
[null,null,"Studio BR",null,null,null,null,{"$f":"IF(AND(H5=1,F103<85000),5,IF(AND(H5=1,F103>90000),-5,IF(AND(H5=1,F103>=85000,F103<=90000),0,0)))","v":0}]
[null,null,"1 Bedroom",null,null,null,null,{"$f":"IF(AND(H5=2,F103<80000),5,IF(AND(H5=2,F103>85000),-5,IF(AND(H5=2,F103>=80000,F103<=85000),0,0)))","v":0}]
[null,null,"2 Bedroom",null,null,null,null,{"$f":"IF(AND(H5=3,F103<65000),5,IF(AND(H5=3,F103>70000),-5,IF(AND(H5=3,F103>=65000,F103<=70000),0,0)))","v":0}]
[null,null,"3 Bedroom",null,null,null,null,{"$f":"IF(AND(H5=4,F103<45000),5,IF(AND(H5=4,F103>50000),-5,IF(AND(H5=4,F103>=45000,F103<=50000),0,0)))","v":0}]
[null,null,"4 Bedroom",null,null,null,null,{"$f":"SUM(H107:H110)","v":0}]
[null,null,"5 Bedroom"]
[null,null,"Totals",{"$f":"SUM(D107:D112)","v":0},{"$f":"SUM(E107:E112)","v":0}]
[null,null,"Total Bedrooms",null,{"$f":"(1*E107)+(1*E108)+(2*E109)+(3*E110)+(4*E111)+(5*E112)","v":0}]
[]
[null,null,"Development Team"]
[]
[null,null,"HOME CHDO (5 pts)",null,null,0]
[null,null,"(as defined in section III of the 2022 QAP)"]
[]
[]
[null,null,"Phase III Objective Points",null,null,{"$f":"F118+F102+F100+F98+F96+F94+F92+B90+B83+F78+F76+B76+F69+F67+F65+F63+B61+F50","v":0}]
[]
[]
[null,null,"Subjective Categories"]
[]
[null,null,"Are you applying under the Service Enriched priority?",null,null,"Select"]
[]
[null,null,"You have applied under the Opportunity Area priority as noted above?",null,null,"Select"]
[]
[null,null,"Are you requesting MHDC to evaluate the application for points",null,null,"Select"]
[null,null,"available under the Economic Development category?"]
[]
[null,null,"Please note that the above subjective priorities and categories require related exhibits to be submitted with the application for evaluation and consideration."]
[]
[]
[]
[]
[]
[null,null,"Developer comments on items associated with scoring including comments Asset Management should consider when scoring prior performance:"]

{"sheet":"MHDC Score","index":2,"n_rows":142,"n_cols":14,"rows_kept":142,"cut":false,"hidden":true,"merged":[[69,12,69,13],[1,3,1,5],[3,3,3,5],[2,5,2,6],[143,1,147,7],[5,1,7,7],[56,2,56,4],[135,2,137,5],[84,2,84,4]]}
[]
[null,"Property Name:",null,{"$f":"'Developer Scoring'!D2:G2","v":0},null,null,"Total Points:   ",{"$f":"G121+G126+G128+G131+G134","v":0}]
[null,"Target Population:",null,{"$f":"'Developer Scoring'!D3","v":0},"   Type of Construction:   ",{"$f":"'Developer Scoring'!F3:G3","v":0}]
[null,"Developer:",null,{"$f":"'Developer Scoring'!D5:G5","v":0},null,null,"County:   ","Select"]
[null,null,null,null,null,null,null,{"$f":"IF(AND(D3=\"Family\",(OR(F3=\"New\",F3=\"New + Rehab\"))),1,IF(AND(D3=\"Senior\",(OR(F3=\"New\",F3=\"New + Rehab\"))),2,IF(AND(D3=\"Family\",(OR(F3<>\"New\",F3<>\"New + Rehab\"))),3,IF(AND(D3=\"Senior\",(OR(F3<>\"New\",F3<>\"New + Rehab\"))),4))))","v":false}]
[null,"MHDC has NOT included the following categories for self-scoring: Services; Opportunity Area; Economic Development and; Development Team Prior Performance. However, questions about some these categories need completed at the bottom of this spreadsheet."]
[]
[]
[]
[]
[]
[null,null,"Phase I - Threshold Documents"]
[]
[null,null,"Executed FIN-100",null,null,{"$f":"'Developer Scoring'!F15","v":"Select"},"Select"]
[]
[null,null,"Application Fee",null,null,{"$f":"'Developer Scoring'!F17","v":"Select"},"Select"]
[]
[null,null,"Narrative",null,null,{"$f":"'Developer Scoring'!F19","v":"Select"},"Select"]
[]
[null,null,"Financing Letters of Intent",null,null,{"$f":"'Developer Scoring'!F21","v":"Select"},"Select"]
[]
[null,null,"Notifications"]
[null,null,"Chief Executive of Local Jurisdiction",null,null,{"$f":"'Developer Scoring'!F24","v":"Select"},"Select"]
[null,null,"State Senator",null,null,{"$f":"'Developer Scoring'!F25","v":"Select"},"Select"]
[null,null,"State Representative",null,null,{"$f":"'Developer Scoring'!F26","v":"Select"},"Select"]
[null,null,"Executive Director of Local HFA",null,null,{"$f":"'Developer Scoring'!F27","v":"Select"},"Select"]
[]
[null,null,"Economic Impact to Missouri (provided in FIN-100)"]
[null,null,"Proposed Services",null,null,{"$f":"'Developer Scoring'!F30","v":"Select"},"Select"]
[null,null,"Number of employees in Missouri",null,null,{"$f":"'Developer Scoring'!F31","v":"Select"},"Select"]
[null,null,"Percent of hard and soft costs from MO based firms",null,null,{"$f":"'Developer Scoring'!F32","v":"Select"},"Select"]
[null,null,"Projected Medicaid Savings (Sr. and Supportive Housing only)",null,null,{"$f":"'Developer Scoring'!F33","v":"Select"},"Select"]
[]
[null,null,"Pass/Fail",null,null,{"$f":"'Developer Scoring'!F35","v":"Fail"},{"$f":"IF(OR(G14=\"No\",G16=\"No\",G18=\"No\",G20=\"No\",G23=\"No\",G24=\"No\",G25=\"No\",G26=\"No\",G29=\"No\",G30=\"No\",G31=\"No\",G32=\"No\",G14=\"Select\",G16=\"Select\",G18=\"Select\",G20=\"Select\",G23=\"Select\",G24=\"Select\",G25=\"Select\",G26=\"Select\",G29=\"Select\",G30=\"Select\",G31=\"Select\",G32=\"Select\"),\"Fail\",\"Pass\")","v":"Fail"}]
[]
[null,null,"Phase II - Priority Scoring"]
[]
[null,null,"Priority Group"]
[null,null,"Workforce Housing",null,null,{"$f":"'Developer Scoring'!F40","v":"Select"},"Select",null,null,"Workforce only for counties whose AMI is lower than the State Wide Median Income of $81,700"]
[null,null,"Non-Profit (as defined in section III of 2022 QAP)",null,null,{"$f":"'Developer Scoring'!F41","v":"Select"},"Select",null,null,"LIHTC Set-Aside and/or CHDO Set-Aside qualifies"]
[null,null,"Service Enriched including Veterans Housing",null,null,{"$f":"'Developer Scoring'!F42","v":"Select"},"Select"]
[null,null,"Special Needs, Vulnerable Populations, and Independence Enabling",null,null,{"$f":"'Developer Scoring'!F43","v":"Select"},"Select"]
[null,null,"Preservation",null,null,{"$f":"'Developer Scoring'!F44","v":"Select"},"Select",null,null,"Must have Preservation Letter to qualify - always MHDC and then RD or HUD if applicable"]
[null,null,"CDBG-DR",null,null,{"$f":"'Developer Scoring'!F45","v":"Select"},"Select"]
[null,null,"HOME CHDO",null,null,{"$f":"'Developer Scoring'!F46","v":"Select"},"Select",null,null,"Must be a qualified CHDO - Ask Julie Smith"]
[null,null,"Opportunity Area (as defined in section III of 2022 QAP)",null,null,{"$f":"'Developer Scoring'!F47","v":"Select"},"Select"]
[null,null,"Opportunity Zone (as enacted under the 2017 Tax Cuts & Jobs Act)",null,null,{"$f":"'Developer Scoring'!F48","v":"Select"},"Select",null,null,"https://ded.mo.gov/sites/default/files/Opportunity%20Zone%20List_0.pdf"]
[]
[null,null,"Phase II Points",null,null,{"$f":"IF(OR(F39=\"Yes\",F40=\"Yes\",F41=\"Yes\",F42=\"Yes\",F43=\"Yes\",F44=\"Yes\",F45=\"Yes\",F46=\"Yes\",F47=\"Yes\"),45,0)","v":0},{"$f":"IF(OR(G39=\"Yes\",G40=\"Yes\",G41=\"Yes\",G42=\"Yes\",G43=\"Yes\",G44=\"Yes\",G45=\"Yes\",G46=\"Yes\",G47=\"Yes\"),45,0)","v":0}]
[]
[null,null,"Phase III - General Scoring"]
[]
[null,null,"Development Characteristics "]
[]
[null,null,"Income Targeting (max 10 pts) (no more than 1 category)",null,null,null,null,null,null,"Income Averaging = unavailable points"]
[null,null,"Location",null,null,{"$f":"'Developer Scoring'!F57","v":"Select"},{"$f":"IFERROR(VLOOKUP(H4,'County Table'!A2:B117,2,FALSE),\"\")","v":"NA"},null,null,"The % per location will populate after the county is completed at top of spreadsheet"]
[null,null,{"$f":"IFERROR(IF(OR(G56=\"STL\",G56=\"KC\"),\">15% of units at 30% AMI (10 pts)\",IF(G56=\"OSM\",\">12.5% of units at 30% AMI (10 pts)\",IF(G56=\"OSR\",\">10% of units at 30% AMI (10 pts)\",\"Select County at Top\"))),\"Select County at Top\")","v":"Select County at Top"},null,null,{"$f":"'Developer Scoring'!F58","v":0},0]
[null,null,{"$f":"IFERROR(IF(OR(G56=\"STL\",G56=\"KC\"),\">10% of units at 30% AMI (6 pts)\",IF(G56=\"OSM\",\">7.5% of units at 30% AMI (6 pts)\",IF(G56=\"OSR\",\">5% of units at 30% AMI (6 pts)\",\"Select County at Top\"))),\"Select County at Top\")","v":"Select County at Top"},null,null,{"$f":"'Developer Scoring'!F59","v":0},0]
[null,null,{"$f":"IFERROR(IF(OR(G56=\"STL\",G56=\"KC\"),\">10% of units at 40% AMI (4 pts)\",IF(G56=\"OSM\",\">7.5% of units at 40% AMI (4 pts)\",IF(G56=\"OSR\",\">5% of units at 40% AMI (4 pts)\",\"Select County at Top\"))),\"Select County at Top\")","v":"Select County at Top"},null,null,{"$f":"'Developer Scoring'!F60","v":0},0]
[null,{"$f":"MAX(G57:G60)","v":0},{"$f":"IFERROR(IF(OR(G56=\"STL\",G56=\"KC\"),\">10% of units at 50% AMI (2 pts)\",IF(G56=\"OSM\",\">7.5% of units at 50% AMI (2 pts)\",IF(G56=\"OSR\",\">5% of units at 50% AMI (2 pts)\",\"Select County at Top\"))),\"Select County at Top\")","v":"Select County at Top"},null,null,{"$f":"'Developer Scoring'!F61","v":0},0]
[]
[null,null,"Mixed Income Development (10 pts)",null,null,{"$f":"'Developer Scoring'!F63","v":0},0,null,null,"Must have at least 10% market or Income Averaging units at 80% AMI.  WF counts as market."]
[]
[null,null,"Tenant Ownership (5 pts)",null,null,{"$f":"'Developer Scoring'!F65","v":0},0,null,null,"Mostly SF rentals - developments intended for 100% eventual tenant ownership.  Must include tenant ownership plan."]
[]
[null,null,"Permanent Supportive Housing / Vulnerable Population (5 pts)",null,null,{"$f":"'Developer Scoring'!F67","v":0},0,null,null,"At least 15% of total units must be set-aside"]
[]
[null,null,"Previous Phase Success (1 pt)",null,null,{"$f":"'Developer Scoring'!F69","v":0},0,null,null,"Any previous phase - must have vacancy rate <5%, waitlist and be within 1/2 mile of 1st phase.  (Information of form 1300 of market study.)"]
[]
[null,null,"Site Location (max 15 pts based on County selection at Top)",null,null,null,null,null,null,null,null,null,"Underserved Counties (2023)"]
[null,null,"Cost Burdened Households 1a (no more than 1 category)",null,null,null,null,null,null,"See Rent Burdened spreadsheet",null,null,"Andrew","Cedar"]
[null,null,"> 20% Cost Burden (10 pts)",null,null,{"$f":"'Developer Scoring'!F73","v":0},{"$f":"IFERROR(IF((VLOOKUP(H4,'CB and US Counties'!A5:G119,7,FALSE))=10,10,0),0)","v":0},null,null,null,null,null,"Dent","Daviess"]
[null,null,"> 15% Cost Burden (7 pts)",null,null,{"$f":"'Developer Scoring'!F74","v":0},{"$f":"IFERROR(IF((VLOOKUP(H4,'CB and US Counties'!A5:G119,7,FALSE))=7,7,0),0)","v":0},null,null,null,null,null,"Iron","Hickory"]
[null,null,"> 10% Cost Burden (5 pts)",null,null,{"$f":"'Developer Scoring'!F75","v":0},{"$f":"IFERROR(IF((VLOOKUP(H4,'CB and US Counties'!A5:G119,7,FALSE))=5,5,0),0)","v":0},null,null,null,null,null,"McDonald","New Madrid"]
[null,{"$f":"MAX(G72:G74)","v":0},"Rural Underserved County - 2a (5 pts)",null,null,{"$f":"'Developer Scoring'!F76","v":0},{"$f":"IFERROR(VLOOKUP(H4,'CB and US Counties'!A5:H119,8,FALSE),0)","v":0},null,null,null,null,null,"Ralls","Wright"]
[]
[null,null,"Preservation (10 pts)",null,null,{"$f":"'Developer Scoring'!F78","v":0},0,null,null,"Must have preservation letter to qualify - always MHDC and then RD or HUD if applicable."]
[]
[null,null,"Extended Compliance (up to 5 pts) (no more than 1 category)"]
[null,null,null,"5 - 9 yrs (Total Compliance Period 20-24 yrs)",null,{"$f":"'Developer Scoring'!F81","v":0},0,null,null,"This must be noted in the FIN-100 on the Tax Credit Addendum tab within the \"Opt-Out\" question"]
[null,null,"Zoned (10 pts)","10 - 14 yrs (Total Compliance Period 25-29 yrs)",null,{"$f":"'Developer Scoring'!F82","v":0},0]
[null,{"$f":"MAX(G80:G82)","v":0},"Not Zoned but with Waiver (10 pts)",">=15 yrs (Total Compliance Period 30+ yrs)",null,{"$f":"'Developer Scoring'!F83","v":0},0]
[]
[null,null,"Use of Resources  (max 10 pts)"]
[null,null,"Construction Leverage Funds (min Construction Loan > = 50% TDC)            (0,1,3 or 5 pts)",null,null,{"$f":"'Developer Scoring'!F86","v":0},0,null,null,"MHDC resource, private bank loans and affiliated part grant funds are not eligible for points in this category."]
[null,null,"Permanent Leverage Funds"]
[null,null,"> 2.5% (3 pts)",null,null,{"$f":"'Developer Scoring'!F88","v":0},0,null,null,"MHDC resource, private bank loans and affiliated part grant funds are not eligible for points in this category."]
[null,{"$f":"MAX(G87:G89)","v":0},"> 5% (5 pts)",null,null,{"$f":"'Developer Scoring'!F89","v":0},0]
[null,{"$f":"IF(B88+G85>10,10,G85+B88)","v":0},"> 7.5% (10 pts)",null,null,{"$f":"'Developer Scoring'!F90","v":0},0]
[]
[null,null,"Federal Historic Tax Credits (5 pts)",null,null,{"$f":"'Developer Scoring'!F92","v":0},0,null,null,"To qualify, development must not request MO state historic credits & MO LIHTC"]
[]
[null,null,"National Housing Trust Fund ",null,null,{"$f":"'Developer Scoring'!F94","v":0},0]
[]
[null,null,"HOME CHDO - requesting no LIHTC (10 pts)",null,null,{"$f":"'Developer Scoring'!F96","v":0},0,null,null,"Only qualify if development is HOME/CHDO only - no tax credits"]
[]
[null,null,"Total Development Costs (10 pts for being under limits)",null,null,{"$f":"'Developer Scoring'!F98","v":0},0]
[]
[null,null,"Rental Assistance (5 pts)",null,null,{"$f":"'Developer Scoring'!F100","v":0},0,null,null,"Must have 15% units with rental assistance commitment letter for at least 3 years."]
[]
[null,null,"Credit Efficiency ",null,null,"N/A",0]
[null,null,"Total Credit Efficiency",null,null,{"$f":"'Developer Scoring'!F103","v":0},{"$f":"IFERROR((G103/L113*G104),0)","v":0}]
[null,null,"Total 4% or 9% Qualified Basis (including acquisition basis)",null,null,{"$f":"'Developer Scoring'!F104","v":0},0]
[null,null,"Credit Efficiency (up to 7 pts.)",null,null,0,0,null,null,"Per Jesse"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(AND(H5=1,G102<85000),5,IF(AND(H5=1,G102>90000),-5,IF(AND(H5=1,G102>=85000,G102<=90000),0,0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(H5=2,G102<80000),5,IF(AND(H5=2,G102>85000),-5,IF(AND(H5=2,G102>=80000,G102<=85000),0,0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(H5=3,G102<65000),5,IF(AND(H5=3,G102>70000),-5,IF(AND(H5=3,G102>=65000,G102<=70000),0,0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(H5=4,G102<45000),5,IF(AND(H5=4,G102>50000),-5,IF(AND(H5=4,G102>=45000,G102<=50000),0,0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H107:H110)","v":0}]
[]
[]
[]
[null,null,"Development Team"]
[]
[null,null,"HOME CHDO (5 pts)",null,null,{"$f":"'Developer Scoring'!F118","v":0},0,null,null,"LIHTC Set-Aside and/or CHDO Set-Aside qualifies (No 4% Applications)"]
[null,null,"(as defined in section III of the 2022 QAP)"]
[]
[]
[null,null,"Phase III Objective Points",null,null,{"$f":"'Developer Scoring'!F122","v":0},{"$f":"IFERROR((G117+G104+G99+G97+G95+G93+G91+B89+B82+G77+B75+G68+G66+G64+G62+B60+G49+G75),0)","v":0}]
[]
[]
[null,null,"Subjective Categories"]
[]
[null,null,"Are you applying under the Service Enriched priority? (up to 5 pts)",null,null,{"$f":"'Developer Scoring'!F127","v":"Select"},0,null,null,"Per Remona"]
[]
[null,null,"You have applied under the Opportunity Area priority. ",null,null,{"$f":"'Developer Scoring'!F129","v":"Select"},0,null,null,"Per Jesse"]
[null,null,"(7 pts if nothing the rest of \"Site Location\" category < 7 points)"]
[]
[null,null,"Are you requesting MHDC to evaluate the application for points",null,null,{"$f":"'Developer Scoring'!F131","v":"Select"},0,null,null,"Per Annette"]
[null,null,"available under the Economic Development category? (5 pts.)"]
[]
[null,null,"Developer Team Evaluation",null,null,null,0,null,null,"Per Team"]
[]
[null,null,"Please note that the above subjective priorities and category require related exhibits to be submitted with the application for evaluation and consideration."]
[]
[]
[]
[]
[]
[null,"MHDC Scoring Comments:"]

{"sheet":"CB and US Counties","index":3,"n_rows":120,"n_cols":16,"rows_kept":120,"cut":false,"hidden":true,"merged":[[0,0,0,26],[1,0,1,26]]}
["Severe Cost Burdened Renter Households"]
["(For use with 2023 QAP)"]
[]
["County","Total Households","Renter Households","Renter Households w/ 50% or more CB","% of All Households","Severe Cost Burden % of All Renter Households"]
["Adair",4012,664,224,0.33734939759036142,0.27363184079601988,10,0,null,null,null,null,null,null,null,1]
["Boone",6640,3095,878,0.2836833602584814,0.26538474202364098,10,0,null,null,null,null,null,null,null,1]
["Randolph",4298,1161,329,0.2833763996554694,0.25518672199170123,10,0,null,null,null,null,null,null,null,1]
["St. Louis City",4830,1512,408,0.26984126984126983,0.25285502290470352,10,0,null,null,null,null,null,null,null,1]
["Warren",8060,1363,351,0.2575201760821717,0.25009345794392523,10,0]
["Lincoln",71919,31631,8073,0.25522430527014639,0.24512195121951219,10,0,null,null,null,null,null,null,null,1]
["Phelps",4426,769,194,0.25227568270481143,0.23710601719197708,10,0,null,null,null,null,null,null,null,1]
["Ralls",143566,80228,19673,0.24521364112280003,0.23664122137404581,10,5,null,null,null,null,null,null,null,1]
["Texas",127532,55786,13350,0.23930735309934392,0.23106796116504855,10,0,null,null,null,null,null,null,null,1]
["Benton",4851,1432,324,0.22625698324022347,0.22657342657342658,10,0,null,null,null,null,null,null,null,1]
["Greene",9078,3489,785,0.22499283462310118,0.22629998122770789,10,0,null,null,null,null,null,null,null,1]
["Oregon",30215,10299,2262,0.21963297407515292,0.22535211267605634,10,0]
["Morgan",18213,7322,1592,0.21742693253209505,0.22302158273381295,10,0]
["Cape Girardeau",19818,3898,846,0.21703437660338634,0.22067932067932067,10,0]
["Madison",4973,978,212,0.21676891615541921,0.21708185053380782,10,0]
["Vernon",33642,12760,2749,0.21543887147335422,0.21601731601731602,10,0]
["Dunklin",291532,121133,26007,0.21469789405034137,0.21530054644808744,10,0]
["St. Louis",409658,129943,27736,0.21344743464442101,0.21469793615014468,10,0]
["Mississippi",8294,2165,461,0.21293302540415704,0.21336760925449871,10,0]
["Dent",13129,2689,569,0.21160282632949051,0.21165644171779141,10,5]
["Scott",1698,361,75,0.2077562326869806,0.20766129032258066,10,0]
["Hickory",15557,4943,1012,0.20473396722638074,0.20751879699248121,10,5]
["Jackson",8510,3567,724,0.20297168488926268,0.20477669303227355,10,0]
["Howell",3361,1050,213,0.20285714285714285,0.19830148619957538,7,0]
["Pemiscot",12119,4647,931,0.20034430815579943,0.19798657718120805,7,0]
["Barry",15342,5185,1029,0.19845708775313403,0.1963276836158192,7,0]
["Buchanan",3460,706,140,0.19830028328611898,0.19603078169299312,7,0]
["Nodaway",6342,1630,320,0.19631901840490798,0.19527834450597492,7,0]
["Crawford",46461,16903,3275,0.19375258829793529,0.19101123595505617,7,0]
["Ste. Genevieve",7281,2741,529,0.19299525720539948,0.1906474820143885,7,0]
["Maries",6977,1691,324,0.19160260201064458,0.18941798941798943,7,0]
["Johnson",9852,2347,449,0.19130805283340435,0.18883841661258924,7,0]
["Dallas",9798,2661,509,0.19128147313040211,0.18771331058020477,7,0]
["St. Francois",4998,1970,367,0.18629441624365481,0.1874116891457932,7,0]
["Jasper",4132,602,112,0.18604651162790697,0.18510573092246399,7,0]
["Bollinger",13872,3597,668,0.18571031415068112,0.18497109826589594,7,0]
["Pettis",16193,5000,895,0.17899999999999999,0.18290946083418108,7,0]
["DeKalb",8872,2568,457,0.1779595015576324,0.18274978650725876,7,0]
["Putnam",24572,7882,1402,0.17787363613296117,0.18157894736842106,7,0]
["Ray",22390,7721,1360,0.17614298665975911,0.18095739084692267,7,0]
["Lafayette",12711,3698,648,0.1752298539751217,0.17748344370860927,7,0]
["Washington",8766,1945,340,0.17480719794344474,0.17681940700808627,7,0]
["Stoddard",5438,1370,237,0.17299270072992701,0.1767467550400442,7,0]
["Taney",11833,3675,634,0.17251700680272108,0.17643540669856458,7,0]
["Butler",19931,7492,1282,0.17111585691404163,0.17600700525394045,7,0]
["Wright",41127,9362,1553,0.16588335825678274,0.17544757033248082,7,5]
["Cass",92514,29268,4854,0.16584665846658467,0.17512064343163539,7,0]
["Iron",17300,3207,528,0.1646398503274088,0.17446808510638298,7,5]
["Wayne",149472,27568,4521,0.16399448636099825,0.17391304347826086,7,0]
["New Madrid",6355,1810,295,0.16298342541436464,0.17293804637020144,7,5]
["Jefferson",1687,360,58,0.16111111111111112,0.17261556465769456,7,0]
["Chariton",40397,9921,1590,0.16026610220743875,0.1721170395869191,7,0]
["Ozark",6565,1963,314,0.1599592460519613,0.17197452229299362,7,0]
["Polk",6412,1576,252,0.15989847715736041,0.17194950911640955,7,0]
["Ripley",9284,2680,426,0.15895522388059702,0.16901408450704225,7,0]
["Pulaski",9278,2186,342,0.15645013723696249,0.16818361693707953,7,0]
["Cedar",5317,925,143,0.1545945945945946,0.16814159292035399,7,5]
["Camden",11545,3461,535,0.15457960127130888,0.16557377049180327,7,0]
["Clay",9349,2754,425,0.15432098765432098,0.16349541930937281,7,0]
["St. Charles",16358,5904,897,0.15193089430894308,0.1604297224709042,7,0]
["Barton",7252,1384,210,0.15173410404624277,0.1588850174216028,7,0]
["Christian",3800,1155,175,0.15151515151515152,0.15849056603773584,7,0]
["Franklin",3808,1012,153,0.15118577075098813,0.15566265060240964,7,0]
["Douglas",12689,2118,318,0.1501416430594901,0.15196078431372548,7,0]
["Henry",15061,7184,1077,0.14991648106904232,0.15127701375245581,7,0]
["Livingston",11537,4070,610,0.14987714987714987,0.15104166666666666,7,0]
["Marion",5573,1674,250,0.14934289127837516,0.15104166666666666,7,0]
["Worth",32487,8215,1224,0.14899573950091297,0.14925373134328357,5,0]
["Platte",7639,1437,214,0.14892136395267919,0.145522949586155,5,0]
["Carter",84978,17393,2590,0.14891048122808026,0.14203454894433781,5,0]
["Scotland",4102,1101,162,0.14713896457765668,0.13924050632911392,5,0]
["Caldwell",39918,13110,1895,0.14454614797864226,0.13837209302325582,5,0]
["Newton",22123,6125,882,0.14399999999999999,0.13768924302788846,5,0]
["Lawrence",6653,1900,263,0.13842105263157894,0.13763702801461633,5,0]
["Linn",5002,1207,165,0.13670256835128416,0.13745454545454547,5,0]
["Montgomery",2723,619,83,0.13408723747980614,0.13655172413793104,5,0]
["Daviess",2633,630,84,0.13333333333333333,0.13636363636363635,5,5]
["Laclede",14413,4618,609,0.13187527067994803,0.13364595545134819,5,0]
["Webster",3002,600,79,0.13166666666666665,0.13263785394932937,5,0]
["Stone",5907,1967,258,0.13116420945602442,0.13203463203463203,5,0]
["Bates",13697,2984,383,0.12835120643431636,0.13183098591549297,5,0]
["Cole",3597,846,106,0.12529550827423167,0.1307498741821842,5,0]
["Callaway",14849,4263,526,0.12338728594886231,0.12974238875878219,5,0]
["Cooper",5908,1517,187,0.12326961107448912,0.12910662824207492,5,0]
["Moniteau",3703,886,108,0.12189616252821671,0.12510154346060115,5,0]
["Clinton",30291,9960,1200,0.12048192771084337,0.12447916666666667,5,0]
["Audrain",5450,1279,152,0.11884284597341674,0.12139130434782609,5,0]
["Saline",1333,284,33,0.11619718309859155,0.12080808080808081,5,0]
["Pike",808,149,17,0.11409395973154363,0.12010723860589813,5,0]
["Reynolds",2580,464,52,0.11206896551724138,0.11796733212341198,5,0]
["Lewis",3900,1278,141,0.11032863849765258,0.11578947368421053,5,0]
["Dade",8100,1795,196,0.10919220055710306,0.11532846715328467,5,0]
["Grundy",5273,853,93,0.10902696365767878,0.11235955056179775,5,0]
["St. Clair",2549,787,83,0.10546378653113088,0.11235955056179775,5,0]
["Macon",1440,440,45,0.10227272727272728,0.11225188227241616,5,0]
["Atchison",16233,4129,419,0.10147735529183821,0.1111111111111111,5,0]
["Perry",4995,1365,138,0.1010989010989011,0.11051212938005391,5,0]
["Miller",1400,210,21,0.1,0.11042231693142193,5,0]
["Clark",6799,1459,144,9.8697738176833444E-2,0.1076923076923077,5,0]
["Shannon",3731,929,91,9.7954790096878366E-2,0.10596026490066225,5,0]
["Monroe",2010,471,45,9.5541401273885357E-2,0.10329670329670329,5,0]
["Schuyler",8235,2406,227,9.4347464671654196E-2,0.10321100917431193,5,0]
["Andrew",8393,2678,248,9.2606422703510077E-2,9.8859315589353611E-2,0,5]
["Knox",4120,806,66,8.1885856079404462E-2,9.765625E-2,0,0]
["Holt",3063,770,62,8.0519480519480519E-2,9.4537815126050417E-2,0,0]
["Osage",7577,2002,158,7.8921078921078927E-2,9.2105263157894732E-2,0,0]
["McDonald",4082,839,65,7.7473182359952319E-2,8.9376715013720104E-2,0,5]
["Harrison",3028,789,59,7.477820025348543E-2,8.6486486486486491E-2,0,0]
["Gasconade",2495,598,44,7.3578595317725759E-2,8.461538461538462E-2,0,0]
["Carroll",10452,2771,192,6.9289065319379284E-2,8.3333333333333329E-2,0,0]
["Mercer",6154,1283,85,6.6250974279033509E-2,7.6923076923076927E-2,0,0]
["Howard",3518,968,63,6.5082644628099179E-2,6.5306122448979598E-2,0,0]
["Sullivan",2334,659,40,6.0698027314112293E-2,5.545286506469501E-2,0,0]
["Gentry",2485,605,36,5.9504132231404959E-2,5.3030303030303032E-2,0,0]
["Shelby",2218,583,26,4.4596912521440824E-2,4.7543581616481777E-2,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H5:H119)","v":50}]

{"sheet":"County Table","index":4,"n_rows":117,"n_cols":5,"rows_kept":117,"cut":false,"hidden":true,"merged":[]}
["County","Region","County","PH Zone City","PH Zone #"]
["Adair","OSR","Adair","Columbia",2]
["Andrew","OSR","Andrew","Kansas City",1]
["Atchison","OSR","Atchison","Kansas City",1]
["Audrain","OSR","Audrain","Columbia",2]
["Barry","OSR","Barry","Springfield",4]
["Barton","OSR","Barton","Springfield",4]
["Bates","OSR","Bates","Kansas City",1]
["Benton","OSR","Benton","Columbia",2]
["Bollinger","OSM","Bollinger","St. Louis",3]
["Boone","OSM","Boone","Columbia",2]
["Buchanan","OSR","Buchanan","Kansas City",1]
["Butler","OSR","Butler","St. Louis",3]
["Caldwell","OSR","Caldwell","Kansas City",1]
["Callaway","OSM","Callaway","Columbia",2]
["Camden","OSR","Camden","Columbia",2]
["Cape Girardeau","OSM","Cape Girardeau","St. Louis",3]
["Carroll","OSR","Carroll","Kansas City",1]
["Carter","OSR","Carter","St. Louis",3]
["Cass","KC","Cass","Kansas City",1]
["Cedar","OSR","Cedar","Springfield",4]
["Chariton","OSR","Chariton","Columbia",2]
["Christian","OSR","Christian","Springfield",4]
["Clark","OSR","Clark","Columbia",2]
["Clay","KC","Clay","Kansas City",1]
["Clinton","OSR","Clinton","Kansas City",1]
["Cole","OSM","Cole","Columbia",2]
["Cooper","OSM","Cooper","Columbia",2]
["Crawford","OSR","Crawford","St. Louis",3]
["Dade","OSR","Dade","Springfield",4]
["Dallas","OSR","Dallas","Springfield",4]
["Daviess","OSR","Daviess","Kansas City",1]
["Dekalb","OSR","Dekalb","Kansas City",1]
["Dent","OSR","Dent","St. Louis",3]
["Douglas","OSR","Douglas","Springfield",4]
["Dunklin","OSR","Dunklin","St. Louis",3]
["Franklin","STL","Franklin","St. Louis",3]
["Gasconade","OSR","Gasconade","St. Louis",3]
["Gentry","OSR","Gentry","Kansas City",1]
["Greene","OSM","Greene","Springfield",4]
["Grundy","OSR","Grundy","Kansas City",1]
["Harrison","OSR","Harrison","Kansas City",1]
["Henry","OSR","Henry","Kansas City",1]
["Hickory","OSR","Hickory","Columbia",2]
["Holt","OSR","Holt","Kansas City",1]
["Howard","OSM","Howard","Columbia",2]
["Howell","OSR","Howell","Springfield",4]
["Iron","OSR","Iron","St. Louis",3]
["Jackson","KC","Jackson","Kansas City",1]
["Jasper","OSM","Jasper","Springfield",4]
["Jefferson","STL","Jefferson","St. Louis",3]
["Johnson","OSR","Johnson","Kansas City",1]
["Knox","OSR","Knox","Columbia",2]
["Laclede","OSR","Laclede","Springfield",4]
["Lafayette","OSR","Lafayette","Kansas City",1]
["Lawrence","OSR","Lawrence","Springfield",4]
["Lewis","OSR","Lewis","Columbia",2]
["Lincoln","OSR","Lincoln","St. Louis",3]
["Linn","OSR","Linn","Columbia",2]
["Livingston","OSR","Livingston","Kansas City",1]
["Macon","OSR","Macon","Columbia",2]
["Madison","OSR","Madison","St. Louis",3]
["Maries","OSR","Maries","Columbia",2]
["Marion","OSR","Marion","Columbia",2]
["McDonald","OSR","McDonald","Springfield",4]
["Mercer","OSR","Mercer","Kansas City",1]
["Miller","OSR","Miller","Columbia",2]
["Mississippi","OSR","Mississippi","St. Louis",3]
["Moniteau","SOM","Moniteau","Columbia",2]
["Monroe","OSR","Monroe","Columbia",2]
["Montgomery","OSR","Montgomery","St. Louis",3]
["Morgan","OSR","Morgan","Columbia",2]
["New Madrid","OSR","New Madrid","St. Louis",3]
["Newton","OSM","Newton","Springfield",4]
["Nodaway","OSR","Nodaway","Kansas City",1]
["Oregon","OSR","Oregon","St. Louis",3]
["Osage","OSM","OSRage","Columbia",2]
["Ozark","OSR","Ozark","Springfield",4]
["Pemiscot","OSR","Pemiscot","St. Louis",3]
["Perry","OSR","Perry","St. Louis",3]
["Pettis","OSR","Pettis","Columbia",2]
["Phelps","OSR","Phelps","Springfield",4]
["Pike","OSR","Pike","St. Louis",3]
["Platte","KC","Platte","Kansas City",1]
["Polk","OSR","Polk","Springfield",4]
["Pulaski","OSR","Pulaski","Springfield",4]
["Putnam","OSR","Putnam","Columbia",2]
["Ralls","OSR","Ralls","Columbia",2]
["Randolph","OSR","Randolph","Columbia",2]
["Ray","KC","Ray","Kansas City",1]
["Reynolds","OSR","Reynolds","St. Louis",3]
["Ripley","OSR","Ripley","St. Louis",3]
["Saline","OSR","Saline","Columbia",2]
["Schuyler","OSR","Schuyler","Columbia",2]
["Scotland","OSR","Scotland","Columbia",2]
["Scott","OSR","Scott","St. Louis",3]
["Select","NA","Select","NA",9]
["Shannon","OSR","Shannon","St. Louis",3]
["Shelby","OSR","Shelby","Columbia",2]
["St Charles","STL","St Charles","St. Louis",3]
["St Clair","OSR","St Clair","Kansas City",1]
["St Francois","OSR","St Francois","St. Louis",3]
["St Louis City","STL","St Louis City","St. Louis",3]
["St Louis","STL","St Louis County","St. Louis",3]
["Ste Genevieve","OSR","Ste Genevieve","St. Louis",3]
["Stoddard","OSR","Stoddard","St. Louis",3]
["Stone","OSR","Stone","Springfield",4]
["Sullivan","OSR","Sullivan","Columbia",2]
["Taney","OSR","Taney","Springfield",4]
["Texas","OSR","Texas","Springfield",4]
["Vernon","OSR","Vernon","Kansas City",1]
["Warren","OSR","Warren","St. Louis",3]
["Washington","OSR","Washington","St. Louis",3]
["Wayne","OSR","Wayne","St. Louis",3]
["Webster","OSR","Webster","Springfield",4]
["Worth","OSR","Worth","Kansas City",1]
["Wright","OSR","Wright","Springfield",4]

{"sheet":"CHAS","index":5,"n_rows":1148,"n_cols":8,"rows_kept":1148,"cut":false,"hidden":true,"merged":[]}
["County","Rent Burden <=30%","Rent Burden >30% to <=50%","Rent Burden >50%","Rent Burden not available","Total Rented","30% + 50% Rent Burdened","% Rent Burdened"]
["Clark",575,100,20,10,700,120,0.17391304347826086]
["Mercer",285,33,39,10,360,72,0.20571428571428571]
["Gentry",555,89,59,0,695,148,0.21294964028776978]
["Worth",185,38,18,4,240,56,0.23728813559322035]
["Atchison",570,113,70,10,765,183,0.24238410596026491]
["Shelby",510,125,40,4,675,165,0.24590163934426229]
["Lewis",785,145,115,10,1050,260,0.25]
["DeKalb",1045,205,144,4,1395,349,0.25089863407620416]
["Shannon",575,104,90,10,780,194,0.25194805194805192]
["Schuyler",365,48,85,15,515,133,0.26600000000000001]
["Holt",465,93,74,15,640,167,0.26719999999999999]
["Pike",1290,340,165,35,1830,505,0.28133704735376047]
["Daviess",475,90,99,4,665,189,0.28593040847201212]
["Maries",665,149,119,4,940,268,0.28632478632478631]
["Sullivan",430,75,100,10,620,175,0.28688524590163933]
["McDonald",1625,315,345,35,2325,660,0.28820960698689957]
["Knox",280,73,40,0,390,113,0.28974358974358977]
["Livingston",1215,239,270,115,1845,509,0.29421965317919074]
["Chariton",475,85,114,4,680,199,0.29437869822485208]
["Osage",595,179,78,35,880,257,0.30414201183431955]
["Lawrence",2785,623,600,50,4060,1223,0.30498753117206984]
["Andrew",1030,274,179,85,1570,453,0.30505050505050507]
["Ralls",495,75,145,0,715,220,0.30769230769230771]
["Bates",1330,350,250,10,1940,600,0.31088082901554404]
["Dallas",1125,244,270,20,1665,514,0.31246200607902735]
["Macon",1075,345,145,35,1595,490,0.3141025641025641]
["Cole",6255,1580,1385,310,9535,2965,0.3214092140921409]
["Scotland",315,50,100,4,465,150,0.32537960954446854]
["St Clair",615,180,115,10,915,295,0.32596685082872928]
["Harrison",685,165,172,10,1035,337,0.32878048780487806]
["Iron",810,179,225,25,1235,404,0.33388429752066118]
["Grundy",840,165,255,15,1270,420,0.33466135458167329]
["Monroe",610,200,110,15,940,310,0.33513513513513515]
["Linn",865,230,210,4,1310,440,0.33690658499234305]
["Audrain",1855,580,365,115,2910,945,0.33810375670840787]
["Perry",1065,385,175,10,1635,560,0.3446153846153846]
["Webster",2335,680,560,50,3625,1240,0.34685314685314683]
["Caldwell",600,129,194,10,940,323,0.34731182795698923]
["Dent",1065,340,230,55,1685,570,0.34969325153374231]
["Reynolds",340,80,105,4,530,185,0.35171102661596959]
["Pulaski",4930,1410,1285,150,7780,2695,0.35321100917431192]
["Cooper",1220,370,300,35,1925,670,0.35449735449735448]
["Washington",1040,260,320,25,1645,580,0.35802469135802467]
["Marion",2425,760,605,115,3915,1365,0.35921052631578948]
["Callaway",2830,840,745,65,4475,1585,0.35941043083900226]
["Moniteau",905,399,115,10,1430,514,0.36197183098591551]
["Clinton",1345,410,355,15,2125,765,0.36255924170616116]
["Ray",1235,465,235,10,1940,700,0.36269430051813473]
["Bollinger",550,170,149,40,915,319,0.36457142857142855]
["Ste Genevieve ",995,293,274,0,1555,567,0.36463022508038584]
["Newton",4035,1380,945,85,6450,2325,0.3652788688138256]
["Lafayette",2130,555,675,80,3445,1230,0.36552748885586922]
["Henry",1480,495,364,25,2360,859,0.36788008565310493]
["Wright",1440,445,405,80,2375,850,0.37037037037037035]
["Dade",435,119,138,10,700,257,0.37246376811594201]
["Miller",1415,575,280,15,2285,855,0.37665198237885461]
["Franklin",6700,2300,1765,130,10895,4065,0.37761263353460289]
["Clay",16380,5545,4394,315,26635,9939,0.37762158054711248]
["Morgan",1195,315,414,45,1970,729,0.37870129870129871]
["Scott",2895,770,1010,65,4745,1780,0.38034188034188032]
["Platte",8155,2560,2515,110,13340,5075,0.3835978835978836]
["Ripley",810,305,195,15,1315,500,0.38461538461538464]
["St Charles",17400,6030,4860,365,28665,10890,0.38480565371024733]
["Jefferson",9805,2885,3250,160,16100,6135,0.38488080301129235]
["Carter",455,170,114,4,740,284,0.3858695652173913]
["Gasconade",945,265,335,15,1565,600,0.38709677419354838]
["Stoddard",2210,905,499,45,3660,1404,0.38838174273858922]
["Howell",2955,880,1020,80,4940,1900,0.39094650205761317]
["Putnam",315,143,65,50,580,208,0.39245283018867927]
["Cass",5630,1930,1740,130,9425,3670,0.39483593329747174]
["Taney",5415,2025,1515,145,9105,3540,0.3950892857142857]
["Barton",900,385,205,60,1550,590,0.39597315436241609]
["Carroll",560,230,144,4,945,374,0.39744952178533477]
["Saline",1700,624,505,30,2865,1129,0.39823633156966493]
["Montgomery",795,195,330,15,1330,525,0.39923954372623577]
["Barry",1965,640,670,55,3330,1310,0.4]
["Pettis",3130,1110,985,75,5300,2095,0.40095693779904307]
["Cape Girardeau",5980,1840,2220,475,10510,4060,0.40458395615346288]
["Vernon",1650,504,625,30,2810,1129,0.40611510791366906]
["Howard",525,224,130,45,915,354,0.40689655172413791]
["St Francois",4625,1349,1835,140,7950,3184,0.40768245838668377]
["Mississippi",1220,395,450,45,2105,845,0.41019417475728154]
["Texas",1465,444,600,55,2570,1044,0.41510934393638171]
["Christian",4615,1950,1390,100,8050,3340,0.42012578616352203]
["Stone",1540,585,529,30,2680,1114,0.42037735849056601]
["New Madrid",1620,604,585,70,2885,1189,0.42238010657193603]
["Lincoln",2400,795,965,170,4335,1760,0.42256902761104442]
["Cedar",1085,520,270,4,1870,790,0.42336548767416937]
["Dunklin",2675,1015,975,70,4730,1990,0.42703862660944208]
["Pemiscot",1765,715,604,150,3235,1319,0.42755267423014587]
["Crawford",1435,484,603,35,2570,1087,0.42879684418145958]
["Hickory",410,170,140,45,760,310,0.43356643356643354]
["St Louis",67035,25965,25780,2940,121725,51745,0.43561897545986444]
["Jasper",9060,3685,3310,220,16270,6995,0.43582554517133959]
["Buchanan",6815,2570,2720,235,12335,5290,0.43719008264462811]
["Ozark",535,250,170,30,990,420,0.4375]
["Butler",3245,1405,1190,145,5990,2595,0.44396920444824639]
["Nodaway",2010,744,893,110,3760,1637,0.44849315068493151]
["Wayne",710,285,290,35,1315,575,0.44921875]
["Camden",2000,870,764,30,3665,1634,0.44951856946354884]
["Phelps",3450,1430,1400,390,6675,2830,0.45027844073190137]
["Laclede",2405,755,1220,25,4400,1975,0.4514285714285714]
["Randolph",1200,454,535,30,2215,989,0.45263157894736844]
["Johnson",4360,1785,1830,115,8090,3615,0.45329153605015676]
["Jackson",61145,23710,26985,3175,115005,50695,0.4533220066171868]
["Douglas",625,260,255,4,1140,515,0.45334507042253519]
["Warren",1395,580,580,60,2615,1160,0.45401174168297453]
["Polk",2135,1035,815,30,4005,1850,0.46540880503144655]
["Madison",630,325,225,10,1190,550,0.46610169491525422]
["Benton",755,275,389,75,1495,664,0.46760563380281689]
["Greene",25365,11155,11700,1455,49675,22855,0.47397345499792615]
["Oregon",505,265,224,10,1010,489,0.48899999999999999]
["St Louis City",38540,16575,20934,3465,79515,37509,0.49321499013806708]
["Boone",14535,6115,8520,1610,30785,14635,0.50162810625535559]
["Adair",1540,730,1245,345,3875,1975,0.55949008498583575]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]