{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Scoring Notes","Developer Scoring","MHDC Score","CB and US Counties","County Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":41,"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":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"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,"Homeownership Opportunity","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 a HUD letter of preservation. If the development has Rural Development financing, it must have a Rural Development letter of preservation."]
[null,"Extended Compliance","Developments must waive their right to opt-out at 15 years extending their \"Compliance Period\" to 30 on the \"IX. Tax Credit Addendum\" spreadsheet within the FIN-100 to qualify for points in this category."]
[null,"Rental Assistance","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 five years. Please see the Developer Guide for additional detail."]

{"sheet":"Developer Scoring","index":1,"n_rows":134,"n_cols":8,"rows_kept":134,"cut":false,"hidden":false,"merged":[[4,5,4,6],[0,1,0,6],[60,2,60,4],[1,3,1,6],[3,3,3,6],[2,5,2,6],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[98,2,98,4],[94,2,94,3],[6,1,8,6],[136,2,147,5],[133,2,134,5],[91,2,91,4],[99,2,99,4],[84,2,84,3],[86,2,86,3],[71,5,72,5]]}
[null,"Please complete the light colored cells.  The numbers in the blue colored cells will autopopulate."]
[null,"Development Name:"]
[null,"Occupancy:",null,null,"   Type of Construction:   "]
[null,"Developer Name:",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,null,"   Self-Score Total Points:   ",{"$f":"F132","v":0}]
[]
[null,"Note that scoring for Credit Efficiency (up to 7 pts), Development Team Prior Performance (up to 25 pts), and subjective review of Service Enriched and Supportive Housing (up to 5 pts) are not included in the self-scoring.  The qualified score will be added to the total proposal score during MHDC's review."]
[]
[]
[]
[]
[]
[null,null,"Phase I - Threshold Documents"]
[]
[null,null,"Executed FIN-100 Application Workbook, FIN-100 Addendum, Fin-101 Identity of Parties ",null,null,"Select"]
[]
[null,null,"Application Fee",null,null,"Select"]
[]
[null,null,"Development Questionnaire",null,null,"Select"]
[]
[null,null,"Market Study, Form 1300",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\",F23=\"No\",F26=\"No\",F27=\"No\",F28=\"No\",F29=\"No\",F32=\"No\",F33=\"No\",F34=\"No\",F35=\"No\",F15=\"Select\",F17=\"Select\",F19=\"Select\",F23=\"Select\",F26=\"Select\",F27=\"Select\",F28=\"Select\",F29=\"Select\",F32=\"Select\",F33=\"Select\",F34=\"Select\",F35=\"Select\"),\"Fail\",\"Pass\")","v":"Fail"}]
[]
[null,null,"Phase II - Priority Scoring"]
[]
[null,null,"Priority Group"]
[null,null,"Non-Profit (as defined in section III of 2027 QAP)",null,null,"Select"]
[null,null,"HOME CHDO",null,null,"Select"]
[null,null,"Supportive Housing",null,null,"Select"]
[null,null,"Service Enriched, including Veterans Housing",null,null,"Select"]
[null,null,"Preservation",null,null,"Select"]
[null,null,"CDBG-DR",null,null,"Select"]
[null,null,"Workforce Housing",null,null,"Select"]
[null,null,"Opportunity Area (as defined in section III of 2027 QAP)",null,null,"Select"]
[null,null,"50% Maximus Pilot",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(F42=\"Yes\",F43=\"Yes\",F44=\"Yes\",F45=\"Yes\",F46=\"Yes\",F47=\"Yes\",F48=\"Yes\",F49=\"Yes\",F50=\"Yes\"),45,0)","v":0}]
[]
[null,null,"Phase III - General Scoring"]
[]
[null,null,"Development Characteristics "]
[]
[null,null,"Income Targeting (max 13 pts) (no more than 1 category)"]
[null,null,"Location",null,null,{"$f":"IFERROR(VLOOKUP(D5,'County Table'!A2:F117,6,FALSE),\"\")","v":""}]
[null,null,{"$f":"IF(F60=\"SL/KC\",\">15% of units at 30% AMI (13 pts)\",IF(F60=\"OSM\",\">12.5% of units at 30% AMI (13 pts)\",IF(F60=\"OSR\",\">10% of units at 30% AMI (13 pts)\",\"Select Location Above\")))","v":"Select Location Above"},null,null,0]
[null,null,{"$f":"IF(F60=\"SL/KC\",\">10% of units at 30% AMI (9 pts)\",IF(F60=\"OSM\",\">7.5% of units at 30% AMI (9 pts)\",IF(F60=\"OSR\",\">5% of units at 30% AMI (9 pts)\",\"Select Location Above\")))","v":"Select Location Above"},null,null,0]
[null,null,{"$f":"IF(F60=\"SL/KC\",\">10% of units at 40% AMI (4 pts)\",IF(F60=\"OSM\",\">7.5% of units at 40% AMI (4 pts)\",IF(F60=\"OSR\",\">5% of units at 40% AMI (4 pts)\",\"Select Location Above\")))","v":"Select Location Above"},null,null,0]
[null,{"$f":"MAX(F61:F64)","v":0},{"$f":"IF(F60=\"SL/KC\",\">10% of units at 50% AMI (2 pts)\",IF(F60=\"OSM\",\">7.5% of units at 50% AMI (2) pts)\",IF(F60=\"OSR\",\">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,"Homeownership Opportunity (5 pts)",null,null,0]
[]
[null,null,"Housing Priorities (max 5 pts + 5 additional pts with MHDC review for total of 10 max pts)"]
[null,null,null,"Select",null,{"$f":"_xlfn.IFS(D71=\"Service Enriched\",5,D71=\"Supportive Housing\",5,D71=\"Both\",5,D71=\"Select\",0)","v":0}]
[null,null,null,"Service Enriched Review (up to 5 pts)",null,"Per MHDC Review"]
[null,null,null,"Supportive Housing Review (up to 5 pts)"]
[]
[null,null,"Extended Compliance (5 pts)",null,null,0]
[]
[null,null,"Previous Phase Success (1 pt)",null,null,0]
[]
[null,null,"Site Location"]
[null,null,"Site Location (higest scoring category of a or b will be reflected in score total below)"]
[null,null,"a) Cost Burdened Households (no more than 1 category)"]
[null,null,null,"> 20% Cost Burden (10 pts)",null,{"$f":"IFERROR(IF((VLOOKUP(D5,'CB and US Counties'!A5:G119,7,FALSE))=10,10,0),0)","v":0}]
[null,null,null,"> 15% Cost Burden (7 pts)",null,{"$f":"IFERROR(IF((VLOOKUP(D5,'CB and US Counties'!A5:G119,7,FALSE))=7,7,0),0)","v":0}]
[null,null,null,"> 10% Cost Burden (5 pts)",null,{"$f":"IFERROR(IF((VLOOKUP(D5,'CB and US Counties'!A5:G119,7,FALSE))=5,5,0),0)","v":0}]
[null,{"$f":"MAX(F82:F85)","v":0},"b) Opportunity Area (7 pts)",null,null,0]
[]
[null,null,"Rural Underserved County (5 pts)",null,null,{"$f":"IFERROR(IF((VLOOKUP(D5,'CB and US Counties'!A5:H119,8,FALSE))=5,5,0),0)","v":0}]
[]
[null,null,"Preservation (up to 15 pts)",null,null,0]
[]
[null,null,"Use of Resources"]
[null,null,"Construction Leverage Funds (min Construction Loan > = 50% TDC) (0,1,3 or 5 pts)",null,null,0]
[]
[null,null,"Leveraged Funds (max 13 pts for all categories)"]
[null,null,"a) Favorable Financing (up to 7 pts)"]
[null,null,"> 2.5% (3 pts)",null,null,0]
[null,{"$f":"MAX(F96:F98)","v":0},"> 5% (5 pts)",null,null,0]
[null,{"$f":"IF((B97+F99+F100)>13,13,(F100+F99+B97))","v":0},"> 7.5% (7 pts)",null,null,0]
[null,null,"b) Local Government Support (3 pts)",null,null,0]
[null,null,"c) CDBG-DR Funds (3 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,{"$f":"MAX(F108:F108)","v":0},"Project-based Rental Assistance (max 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((F112*F113/E122),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(H4=1,F111<85000),5,IF(AND(H4=1,F111>90000),-5,IF(AND(H4=1,F111>=85000,F111<=90000),0,0)))","v":0}]
[null,null,"1 Bedroom",null,null,null,null,{"$f":"IF(AND(H4=2,F111<80000),5,IF(AND(H4=2,F111>85000),-5,IF(AND(H4=2,F111>=80000,F111<=85000),0,0)))","v":0}]
[null,null,"2 Bedroom",null,null,null,null,{"$f":"IF(AND(H4=3,F111<65000),5,IF(AND(H4=3,F111>70000),-5,IF(AND(H4=3,F111>=65000,F111<=70000),0,0)))","v":0}]
[null,null,"3 Bedroom",null,null,null,null,{"$f":"IF(AND(H4=4,F111<45000),5,IF(AND(H4=4,F111>50000),-5,IF(AND(H4=4,F111>=45000,F111<=50000),0,0)))","v":0}]
[null,null,"4 Bedroom",null,null,null,null,{"$f":"SUM(H115:H118)","v":0}]
[null,null,"5 Bedroom"]
[null,null,"Totals",{"$f":"SUM(D115:D120)","v":0},{"$f":"SUM(E115:E120)","v":0}]
[null,null,"Total Bedrooms",null,{"$f":"(1*E115)+(1*E116)+(2*E117)+(3*E118)+(4*E119)+(5*E120)","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,"Development Team"]
[null,null,"Development Team Prior Performance (max 25 pts)",null,null,"Per MHDC Review"]
[]
[null,null,"Phase III Objective Points",null,null,{"$f":"F126+F110+F106+F104+F102+B85+B108+B98+F89+F77+F71+F68+F66+B64+F75+F53+F87","v":0}]
[]
[null,null,"Developer comments on items associated with scoring including comments MHDC should consider when scoring prior performance:"]

{"sheet":"MHDC Score","index":2,"n_rows":147,"n_cols":15,"rows_kept":147,"cut":false,"hidden":true,"merged":[[2,5,2,6],[78,13,78,14],[1,3,1,6],[136,1,142,8],[6,1,8,8],[59,2,59,4],[88,2,88,4],[1,1,1,2],[3,1,3,2],[4,1,4,2],[79,6,82,6],[2,1,2,2],[2,7,2,8],[3,3,3,6]]}
[]
[null,"Development Name:",null,{"$f":"'Developer Scoring'!D2","v":0}]
[null,"Occupancy:",null,{"$f":"'Developer Scoring'!D3","v":0},null,"Type of Construction:",null,{"$f":"'Developer Scoring'!F3","v":0}]
[null,"Developer Name:",null,{"$f":"'Developer Scoring'!D4","v":0}]
[null,"County:",null,{"$f":"'Developer Scoring'!D5","v":0},null,null,null,"Total Points:   ",{"$f":"H52+H131","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(D4=\"Family\",(OR(G4=\"New\",G4=\"New + Rehab\"))),1,IF(AND(D4=\"Senior\",(OR(G4=\"New\",G4=\"New + Rehab\"))),2,IF(AND(D4=\"Family\",(OR(G4<>\"New\",G4<>\"New + Rehab\"))),3,IF(AND(D4=\"Senior\",(OR(G4<>\"New\",G4<>\"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,null,"Developer Points","MHDC Points"]
[]
[null,null,"Executed FIN-100",null,null,null,{"$f":"'Developer Scoring'!F15","v":"Select"},"Select"]
[]
[null,null,"Application Fee",null,null,null,{"$f":"'Developer Scoring'!F17","v":"Select"},"Select"]
[]
[null,null,"Development Questionnaire",null,null,null,{"$f":"'Developer Scoring'!F19","v":"Select"},"Select"]
[]
[null,null,"Market Study",null,null,null,{"$f":"'Developer Scoring'!F21","v":"Select"},"Select"]
[]
[null,null,"Financing Letters of Intent",null,null,null,{"$f":"'Developer Scoring'!F23","v":"Select"},"Select"]
[]
[null,null,"Notifications"]
[null,null,"Chief Executive of Local Jurisdiction",null,null,null,{"$f":"'Developer Scoring'!F26","v":"Select"},"Select"]
[null,null,"State Senator",null,null,null,{"$f":"'Developer Scoring'!F27","v":"Select"},"Select"]
[null,null,"State Representative",null,null,null,{"$f":"'Developer Scoring'!F28","v":"Select"},"Select"]
[null,null,"Executive Director of Local HFA",null,null,null,{"$f":"'Developer Scoring'!F29","v":"Select"},"Select"]
[]
[null,null,"Economic Impact to Missouri (provided in FIN-100)"]
[null,null,"Proposed Services",null,null,null,{"$f":"'Developer Scoring'!F32","v":"Select"},"Select"]
[null,null,"Number of employees in Missouri",null,null,null,{"$f":"'Developer Scoring'!F33","v":"Select"},"Select"]
[null,null,"Percent of hard and soft costs from MO based firms",null,null,null,{"$f":"'Developer Scoring'!F34","v":"Select"},"Select"]
[null,null,"Projected Medicaid Savings (Sr. and Supportive Housing only)",null,null,null,{"$f":"'Developer Scoring'!F35","v":"Select"},"Select"]
[]
[null,null,"Pass/Fail",null,null,null,{"$f":"'Developer Scoring'!F37","v":"Fail"},{"$f":"IF(OR(H15=\"No\",H17=\"No\",H19=\"No\",H23=\"No\",H26=\"No\",H27=\"No\",H28=\"No\",H29=\"No\",H32=\"No\",H33=\"No\",H34=\"No\",H35=\"No\",H15=\"Select\",H17=\"Select\",H19=\"Select\",H23=\"Select\",H26=\"Select\",H27=\"Select\",H28=\"Select\",H29=\"Select\",H32=\"Select\",H33=\"Select\",H34=\"Select\",H35=\"Select\"),\"Fail\",\"Pass\")","v":"Fail"}]
[]
[null,null,"Phase II - Priority Scoring",null,null,null,"Developer Points","MHDC Points"]
[]
[null,null,"Priority Group"]
[null,null,"Non-Profit (as defined in section III of 2027 QAP)",null,null,null,{"$f":"'Developer Scoring'!F42","v":"Select"},"Select",null,null,"LIHTC Set-Aside and/or CHDO Set-Aside qualifies"]
[null,null,"HOME CHDO",null,null,null,{"$f":"'Developer Scoring'!F43","v":"Select"},"Select",null,null,"Must be a qualified CHDO - Ask Cristina Dusenbery"]
[null,null,"Supportive Housing",null,null,null,{"$f":"'Developer Scoring'!F44","v":"Select"},"Select"]
[null,null,"Service Enriched, including Veterans Housing",null,null,null,{"$f":"'Developer Scoring'!F45","v":"Select"},"Select"]
[null,null,"Preservation",null,null,null,{"$f":"'Developer Scoring'!F46","v":"Select"},"Select",null,null,"Must meet Preservation requirements"]
[null,null,"CDBG-DR",null,null,null,{"$f":"'Developer Scoring'!F47","v":"Select"},"Select",null,null,"Must have a funding commitment for CDBG-DR resources"]
[null,null,"Workforce Housing",null,null,null,{"$f":"'Developer Scoring'!F48","v":"Select"},"Select",null,null,"Workforce only for counties whose AMI is lower than the State Wide Median Income of $96,000"]
[null,null,"Opportunity Area (as defined in section III of 2027 QAP)",null,null,null,{"$f":"'Developer Scoring'!F49","v":"Select"},"Select"]
[null,null,"Opportunity Zone (as enacted under the 2017 Tax Cuts & Jobs Act)",null,null,null,{"$f":"'Developer Scoring'!F51","v":"Select"},"Select",null,null,"https://ded.mo.gov/sites/default/files/Opportunity%20Zone%20List_0.pdf"]
[]
[null,null,"Phase II Points",null,null,null,{"$f":"IF(OR(G42=\"Yes\",G43=\"Yes\",G44=\"Yes\",G45=\"Yes\",G46=\"Yes\",G47=\"Yes\",G48=\"Yes\",G49=\"Yes\",G50=\"Yes\"),45,0)","v":0},{"$f":"IF(OR(H42=\"Yes\",H43=\"Yes\",H44=\"Yes\",H45=\"Yes\",H46=\"Yes\",H47=\"Yes\",H48=\"Yes\",H49=\"Yes\",H50=\"Yes\"),45,0)","v":0}]
[]
[null,null,"Phase III - General Scoring",null,null,"Maximum Points","Developer Points","MHDC Points"]
[]
[null,null,"Development Characteristics "]
[]
[null,null,"Income Targeting (no more than 1 category)",null,null,null,null,null,null,null,"Income Averaging = unavailable points"]
[null,null,"Location",null,null,null,{"$f":"'Developer Scoring'!F60","v":""},{"$f":"IFERROR(VLOOKUP('Developer Scoring'!D5,'County Table'!A2:B117,2,FALSE),\"\")","v":""},null,null,"The % per location will populate after the county is completed at top of spreadsheet"]
[null,null,{"$f":"IFERROR(IF(OR(H59=\"STL\",H59=\"KC\"),\">15% of units at 30% AMI (13 pts)\",IF(H59=\"OSM\",\">12.5% of units at 30% AMI (13 pts)\",IF(H59=\"OSR\",\">10% of units at 30% AMI (13 pts)\",\"Select County at Top\"))),\"Select County at Top\")","v":"Select County at Top"},null,null,13,{"$f":"'Developer Scoring'!F61","v":0},0]
[null,null,{"$f":"IFERROR(IF(OR(H59=\"STL\",H59=\"KC\"),\">10% of units at 30% AMI (9 pts)\",IF(H59=\"OSM\",\">7.5% of units at 30% AMI (9 pts)\",IF(H59=\"OSR\",\">5% of units at 30% AMI (9 pts)\",\"Select County at Top\"))),\"Select County at Top\")","v":"Select County at Top"},null,null,9,{"$f":"'Developer Scoring'!F62","v":0},0]
[null,null,{"$f":"IFERROR(IF(OR(H59=\"STL\",H59=\"KC\"),\">10% of units at 40% AMI (4 pts)\",IF(H59=\"OSM\",\">7.5% of units at 40% AMI (4 pts)\",IF(H59=\"OSR\",\">5% of units at 40% AMI (4 pts)\",\"Select County at Top\"))),\"Select County at Top\")","v":"Select County at Top"},null,null,4,{"$f":"'Developer Scoring'!F63","v":0},0]
[null,{"$f":"MAX(H60:H63)","v":0},{"$f":"IFERROR(IF(OR(H59=\"STL\",H59=\"KC\"),\">10% of units at 50% AMI (2 pts)\",IF(H59=\"OSM\",\">7.5% of units at 50% AMI (2 pts)\",IF(H59=\"OSR\",\">5% of units at 50% AMI (2 pts)\",\"Select County at Top\"))),\"Select County at Top\")","v":"Select County at Top"},null,null,2,{"$f":"'Developer Scoring'!F64","v":0},0]
[]
[null,null,"Mixed Income Development",null,null,10,{"$f":"'Developer Scoring'!F66","v":0},0,null,null,"Must have at least 10% market or Income Averaging units at 80% AMI."]
[]
[null,null,"Homeownership",null,null,5,{"$f":"'Developer Scoring'!F68","v":0},0,null,null,"Single Family or Duplex ONLY - developments intended for 100% eventual tenant ownership.  Must include tenant ownership plan."]
[]
[null,null,"Housing Priorities (no more than 1 category)"]
[null,{"$f":"H70+B71","v":0},null,"Priority Selection",{"$f":"'Developer Scoring'!D71","v":"Select"},5,{"$f":"'Developer Scoring'!F71","v":0},0,null,null,"At least 15% of total units must be set-aside"]
[null,{"$f":"MAX(H71:H72)","v":0},null,"Service Enriched Subjective Score",null,5,null,0]
[null,null,null,"Set-Aside Preference Subjective Score",null,5,null,0]
[]
[null,{"$f":"MAX(H74:H74)","v":0},"Extended Compliance",null,null,5,{"$f":"'Developer Scoring'!F75","v":0},0]
[]
[null,null,"Previous Phase Success",null,null,1,{"$f":"'Developer Scoring'!F77","v":0},0,null,null,"Any previous phase - must be same vacancy rate <5%, waitlist and be within 1/2 mile of 1st phase.  (Information of form 1300 of market study.)"]
[]
[null,null,"Site Location"]
[null,null,"Cost Burdened Households (no more than 1 category)",null,null,null,null,null,null,null,"See Rent Burdened spreadsheet",null,null,"Underserved Counties (2027)"]
[null,null,"> 20% Cost Burden",null,null,10,{"$f":"'Developer Scoring'!B85","v":0},{"$f":"IFERROR(IF((VLOOKUP($I$5,'CB and US Counties'!A5:G119,7,FALSE))=10,10,0),0)","v":0},null,null,null,null,null,"Bates","Iron"]
[null,null,"> 15% Cost Burden",null,null,7,null,{"$f":"IFERROR(IF((VLOOKUP(I5,'CB and US Counties'!A5:G119,7,FALSE))=7,7,0),0)","v":0},null,null,null,null,null,"Caldwell","Lafayette"]
[null,null,"> 10% Cost Burden",null,null,5,null,{"$f":"IFERROR(IF((VLOOKUP(I5,'CB and US Counties'!A5:G119,7,FALSE))=5,5,0),0)","v":0},null,null,null,null,null,"Gasconade","Pemiscot"]
[null,null,null,"Opportunity Area",null,7,null,0,null,null,null,null,null,"Hickory","Wayne"]
[null,{"$f":"MAX(H80:H82)","v":0},"Rural Underserved County",null,null,5,{"$f":"'Developer Scoring'!F87","v":0},{"$f":"IFERROR(VLOOKUP(I5,'CB and US Counties'!A5:H119,8,FALSE),0)","v":0},null,null,null,null,null,"Howard","Wright"]
[]
[null,null,"Preservation",null,null,15,{"$f":"'Developer Scoring'!F89","v":0},0,null,null,"Must meet preservation requirements to qualify - MHDC/RD/HUD as applicable."]
[]
[null,null,"Use of Resources"]
[null,null,"Construction Leverage Funds (min Construction Loan > = 50% TDC)            (0,1,3 or 5 pts)",null,null,null,{"$f":"'Developer Scoring'!F92","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,"Leveraged Funds (up to 13 pts)"]
[null,null,null,"Favorable Financing"]
[null,null,"> 2.5%",null,null,3,{"$f":"'Developer Scoring'!F96","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(H92:H94)","v":0},"> 5%",null,null,5,{"$f":"'Developer Scoring'!F97","v":0},0]
[null,{"$f":"IF((B93+H95+H96)>10,10,(H95+H96+B93))","v":0},"> 7.5%",null,null,7,{"$f":"'Developer Scoring'!F98","v":0},0]
[null,null,"Lo","Local Government Support",null,3,{"$f":"'Developer Scoring'!F99","v":0},0]
[null,null,null,"CDBG-DR Funds",null,3,{"$f":"'Developer Scoring'!F100","v":0},0]
[]
[null,null,"National Housing Trust Fund ",null,null,null,{"$f":"'Developer Scoring'!F102","v":0},0]
[]
[null,null,"HOME CHDO - requesting no LIHTC (10 pts)",null,null,null,{"$f":"'Developer Scoring'!F104","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,null,{"$f":"'Developer Scoring'!F106","v":0},0]
[]
[null,{"$f":"MAX(H104:H104)","v":0},"Project Based Rental Assistance",null,null,5,{"$f":"'Developer Scoring'!F108","v":0},0]
[]
[null,null,"Credit Efficiency ",null,null,null,"N/A",0]
[null,null,"Total Credit Efficiency",null,null,null,{"$f":"'Developer Scoring'!F111","v":0},{"$f":"IFERROR((H108/M118*H109),0)","v":0}]
[null,null,"Total 4% or 9% Qualified Basis (including acquisition basis)",null,null,null,{"$f":"'Developer Scoring'!F112","v":0},0]
[null,null,"Credit Efficiency (up to 7 pts)",null,null,7,null,0,null,null,"Per Julie"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(I6=1,H107<85000),5,IF(AND(I6=1,H107>90000),-5,IF(AND(I6=1,H107>=85000,H107<=90000),0,0)))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(I6=2,H107<80000),5,IF(AND(I6=2,H107>85000),-5,IF(AND(I6=2,H107>=80000,H107<=85000),0,0)))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(I6=3,H107<65000),5,IF(AND(I6=3,H107>70000),-5,IF(AND(I6=3,H107>=65000,H107<=70000),0,0)))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(I6=4,H107<45000),5,IF(AND(I6=4,H107>50000),-5,IF(AND(I6=4,H107>=45000,H107<=50000),0,0)))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I112:I115)","v":0}]
[]
[]
[]
[null,null,"Development Team"]
[]
[null,null,"Non-Profit and HOME CHDO (5 pts)",null,null,null,{"$f":"'Developer Scoring'!F126","v":0},0,null,null,"LIHTC Set-Aside and/or CHDO Set-Aside qualifies (No 4% Applications)"]
[]
[null,null,"Credit Efficiency ",null,null,null,"N/A",0]
[null,null,"Total Credit Efficiency",null,null,null,{"$f":"'Developer Scoring'!F130","v":"Per MHDC Review"},{"$f":"IFERROR((H126/#REF!*H128),0)","v":0}]
[null,null,"Total 4% or 9% Qualified Basis (including acquisition basis)",null,null,null,{"$f":"'Developer Scoring'!F131","v":0},0]
[null,null,"Development Team"]
[null,null,"Development Team Prior Performance (25 pts)",null,null,25,null,0,null,null,"Per Julie"]
[null,null,"(as defined in section III of the 2025 QAP)"]
[]
[]
[null,null,"Phase III Total Points",null,null,null,{"$f":"'Developer Scoring'!F132","v":0},{"$f":"IFERROR((H122+H109+H102+H100+H98+#REF!+B104+B94+B74+B70+#REF!+H86+B84+H76+H67+H65+B63+H52+H84+H128),0)","v":0}]
[]
[]
[null,"MHDC Scoring Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"  "]

{"sheet":"CB and US Counties","index":3,"n_rows":141,"n_cols":8,"rows_kept":141,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7]]}
["Severe Cost Burdened Renter Households"]
["(For use with 2027 QAP)"]
[]
["County","Total Households","Renter Households","Renter Households w/ 50% or more CB","% of All Households","Severe Cost Burden % of All Renter Households","Cost Burdened","Rural Underserved"]
["Adair",4010,3380,580,6.5536723163841806E-2,0.17159763313609466,7,0]
["Andrew",4300,1480,120,1.7505470459518599E-2,8.1081081081081086E-2,0,0]
["Atchison",6640,660,65,2.7777777777777776E-2,9.8484848484848481E-2,0,0]
["Audrain",8060,2510,355,4.0112994350282483E-2,0.14143426294820718,5,0]
["Barry",4425,3595,600,4.4960659423004867E-2,0.16689847009735745,7,0]
["Barton",71920,1335,265,5.9350503919372903E-2,0.19850187265917604,7,0]
["Bates",143565,1595,239,4.0439932318104908E-2,0.14984326018808777,5,5]
["Benton",127530,1415,370,4.5650832819247381E-2,0.26148409893992935,10,0]
["Bollinger",4830,740,124,3.2717678100263853E-2,0.16756756756756758,7,0]
["Boone",4850,31515,8365,0.11306345880921809,0.26542916071711881,10,0]
["Buchanan",30215,12215,2765,8.3270591778346628E-2,0.22636103151862463,10,0]
["Butler",19820,5635,915,5.6429232192414434E-2,0.16237799467613132,7,0]
["Caldwell",4975,695,63,1.8367346938775512E-2,9.0647482014388492E-2,0,5]
["Callaway",18215,3630,470,2.9504080351537978E-2,0.12947658402203857,5,0]
["Camden",9080,2985,385,2.3583460949464011E-2,0.12897822445561138,5,0]
["Cape Girardeau",13130,10375,2320,7.375615959306947E-2,0.2236144578313253,10,0]
["Carroll",291530,975,49,1.4736842105263158E-2,5.0256410256410255E-2,0,0]
["Carter",33640,590,69,3.5844155844155845E-2,0.11694915254237288,5,0]
["Cass",409660,9900,1765,4.261740915127369E-2,0.17828282828282829,7,0]
["Cedar",1700,1450,250,4.6339202965708988E-2,0.17241379310344829,7,0]
["Chariton",8295,475,35,1.3618677042801557E-2,7.3684210526315783E-2,0,0]
["Christian",3360,8045,1385,4.1660400060159419E-2,0.17215661901802362,7,0]
["Clark",12120,495,84,3.6585365853658534E-2,0.16969696969696971,7,0]
["Clay",8510,31650,5360,5.3994157348645107E-2,0.16935229067930491,7,0]
["Clinton",6340,1935,205,2.564102564102564E-2,0.10594315245478036,5,0]
["Cole",15555,9870,1360,4.5288045288045288E-2,0.13779128672745694,5,0]
["Cooper",4130,1415,240,3.9571310799670238E-2,0.16961130742049471,7,0]
["Crawford",46460,2490,324,3.4970318402590392E-2,0.13012048192771083,5,0]
["Dade",9800,715,55,1.8425460636515914E-2,7.6923076923076927E-2,0,0]
["Dallas",5000,1610,250,3.840245775729647E-2,0.15527950310559005,7,0]
["Daviess",15340,665,100,3.3156498673740056E-2,0.15037593984962405,7,0]
["Dekalb",13870,1120,94,2.5371120107962213E-2,8.3928571428571422E-2,0,0]
["Dent",6975,1465,230,3.9792387543252594E-2,0.15699658703071673,7,0]
["Douglas",5440,865,150,3.3112582781456956E-2,0.17341040462427745,7,0]
["Dunklin",7280,4175,684,6.1649391617845876E-2,0.16383233532934133,7,0]
["Franklin",8765,9305,1635,3.9703739679456049E-2,0.17571198280494357,7,0]
["Gasconade",9850,1150,140,2.3529411764705882E-2,0.12173913043478261,5,5]
["Gentry",16195,570,49,2.0985010706638114E-2,8.5964912280701758E-2,0,0]
["Greene",8870,56710,12765,9.771500746354346E-2,0.22509257626520895,10,0]
["Grundy",11835,1210,175,4.6174142480211081E-2,0.14462809917355371,5,0]
["Harrison",24570,865,185,6.2184873949579833E-2,0.2138728323699422,10,0]
["Henry",12710,2570,448,4.8695652173913043E-2,0.17431906614785991,7,0]
["Hickory",3460,615,220,6.3309352517985612E-2,0.35772357723577236,10,5]
["Holt",1685,375,19,1.0913268236645606E-2,5.0666666666666665E-2,0,0]
["Howard",41125,615,140,4.2105263157894736E-2,0.22764227642276422,10,5]
["Howell",92515,4810,935,6.1271297509829618E-2,0.1943866943866944,7,0]
["Iron",149470,835,170,4.4795783926218712E-2,0.20359281437125748,10,5]
["Jackson",6355,123945,27225,9.1421951342366387E-2,0.21965387873653636,10,0]
["Jasper",19930,17465,3560,7.5551782682512739E-2,0.20383624391640423,10,0]
["Jefferson",17300,16675,2455,2.851004529090698E-2,0.14722638680659669,5,0]
["Johnson",6410,7600,1135,5.5177442877977635E-2,0.14934210526315789,5,0]
["Knox",5315,175,15,1.3157894736842105E-2,8.5714285714285715E-2,0,0]
["Laclede",22390,4285,465,3.2631578947368421E-2,0.10851808634772463,5,0]
["Lafayette",40395,2970,575,4.7520661157024795E-2,0.19360269360269361,7,5]
["Lawrence",9280,4270,525,3.6169479848432655E-2,0.12295081967213115,5,0]
["Lewis",9350,780,125,3.7582681900180395E-2,0.16025641025641027,7,0]
["Lincoln",3810,4580,1070,4.9127640036730945E-2,0.23362445414847161,10,0]
["Linn",11545,1100,184,3.9065817409766453E-2,0.16727272727272727,7,0]
["Livingston",7250,1665,170,3.1307550644567222E-2,0.1021021021021021,5,0]
["Macon",3800,1350,205,3.5253654342218402E-2,0.15185185185185185,7,0]
["Madison",6565,1005,175,3.8084874863982592E-2,0.17412935323383086,7,0]
["Maries",5575,915,190,5.2924791086350974E-2,0.20765027322404372,10,0]
["Marion",7640,3515,585,5.2185548617305975E-2,0.16642958748221906,7,0]
["Mcdonald",16360,2800,320,3.8231780167264036E-2,0.11428571428571428,5,0]
["Mercer",15060,260,25,2.0161290322580645E-2,9.6153846153846159E-2,0,0]
["Miller",9285,2495,115,1.1408730158730158E-2,4.6092184368737472E-2,0,0]
["Mississippi",32485,1850,390,8.4580351333767081E-2,0.21081081081081082,10,0]
["Moniteau",4100,1320,205,3.6053464650017589E-2,0.1553030303030303,7,0]
["Monroe",84980,825,74,2.1700879765395895E-2,8.9696969696969692E-2,0,0]
["Montgomery",11535,1190,144,3.1101511879049675E-2,0.12100840336134454,5,0]
["Morgan",22125,1580,330,4.2801556420233464E-2,0.20886075949367089,10,0]
["New Madrid",12690,2380,335,5.003734129947722E-2,0.1407563025210084,5,0]
["Newton",39920,5650,745,3.4026033340945422E-2,0.13185840707964602,5,0]
["Nodaway",2635,3020,630,7.6642335766423361E-2,0.20860927152317882,10,0]
["Oregon",5000,985,205,6.101190476190476E-2,0.20812182741116753,10,0]
["Osage",14415,880,134,2.576923076923077E-2,0.15227272727272728,7,0]
["Ozark",6655,760,69,1.9436619718309858E-2,9.0789473684210531E-2,0,0]
["Pemiscot",5905,2745,715,0.11421725239616613,0.26047358834244078,10,5]
["Perry",3705,1635,190,2.604523646333105E-2,0.11620795107033639,5,0]
["Pettis",810,5010,794,4.7687687687687691E-2,0.15848303393213573,7,0]
["Phelps",14850,7075,1705,9.6847486509514344E-2,0.24098939929328622,10,0]
["Pike",1335,1660,225,3.5885167464114832E-2,0.13554216867469879,5,0]
["Platte",5910,14305,2335,5.4954106848670276E-2,0.16322963998601889,7,0]
["Polk",2725,3340,500,4.2753313381787089E-2,0.1497005988023952,5,0]
["Pulaski",2580,6700,990,6.3400576368876083E-2,0.14776119402985075,5,0]
["Putnam",5450,330,60,3.4071550255536626E-2,0.18181818181818182,7,0]
["Ralls",13695,525,70,1.7565872020075281E-2,0.13333333333333333,5,0]
["Randolph",30290,2890,455,5.0304035378662244E-2,0.157439446366782,7,0]
["Ray",3000,1885,249,2.8604250430786904E-2,0.13209549071618037,5,0]
["Reynolds",5275,455,50,2.178649237472767E-2,0.10989010989010989,5,0]
["Ripley",3900,800,140,3.5989717223650387E-2,0.17499999999999999,7,0]
["Saline",16235,2155,275,3.5324341682723186E-2,0.12761020881670534,5,0]
["Schuyler",2010,325,20,1.5923566878980892E-2,6.1538461538461542E-2,0,0]
["Scotland",8235,305,45,2.9411764705882353E-2,0.14754098360655737,5,0]
["Scott",8395,4760,1000,6.633499170812604E-2,0.21008403361344538,10,0]
["Shannon",6800,505,45,1.6423357664233577E-2,8.9108910891089105E-2,0,0]
["Shelby",1440,620,44,1.8763326226012792E-2,7.0967741935483872E-2,0,0]
["St Charles",8100,30125,4675,2.9970830528576464E-2,0.15518672199170125,7,0]
["St Clair",2550,930,115,2.9336734693877552E-2,0.12365591397849462,5,0]
["St Francois",4995,7400,1035,4.3423536815607303E-2,0.13986486486486485,5,0]
["St Louis",3730,130240,28280,6.8710821711453429E-2,0.21713759213759215,10,0]
["St Louis city",2220,78885,18449,0.12978543791769259,0.23387209228623945,10,0]
["Ste Genevieve",3595,1330,180,2.553191489361702E-2,0.13533834586466165,5,0]
["Stoddard",1400,3300,410,3.5933391761612622E-2,0.12424242424242424,5,0]
["Stone",3065,1935,320,2.5498007968127491E-2,0.16537467700258399,7,0]
["Sullivan",4120,515,44,2.2222222222222223E-2,8.5436893203883493E-2,0,0]
["Taney",7575,7195,1473,6.8559460088433791E-2,0.20472550382209867,10,0]
["Texas",2495,2215,320,3.5184167124793844E-2,0.14446952595936793,5,0]
["Vernon",4080,2250,310,4.0129449838187704E-2,0.13777777777777778,5,0]
["Warren",10450,2565,555,4.2643104110641566E-2,0.21637426900584794,10,0]
["Washington",3030,1935,284,3.1946006749156354E-2,0.14677002583979329,5,0]
["Wayne",3520,1155,195,4.3721973094170405E-2,0.16883116883116883,7,5]
["Webster",6155,3205,290,2.1386430678466076E-2,9.0483619344773794E-2,0,0]
["Worth",2335,155,15,1.9455252918287938E-2,9.6774193548387094E-2,0,0]
["Wright",2485,1540,175,2.5697503671071951E-2,0.11363636363636363,5,5]
[null,null,null,null,null,null,null,{"$f":"SUM(H5:H119)","v":50}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Select"]
[null,null,null,null,null,"Service Enriched"]
[null,null,null,null,null,"Supportive Housing"]

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