{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Application Capacity Scorecard","KY BoS CoC Fair Housing Survey"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Application Capacity Scorecard","index":0,"n_rows":138,"n_cols":12,"rows_kept":138,"cut":false,"hidden":false,"merged":[[5,1,5,10],[100,6,100,7],[103,6,103,7],[106,6,106,7],[4,1,4,9],[3,1,3,9],[20,2,21,9],[21,10,22,10],[7,1,7,4],[7,5,7,9],[12,1,13,1],[12,2,13,10],[71,2,72,9],[63,2,64,9],[44,2,45,9],[74,2,75,9],[54,2,54,9],[60,2,60,9],[39,2,39,9],[40,2,41,9],[47,2,48,9],[50,2,51,9],[57,2,58,9],[53,2,53,9],[66,2,66,9],[18,11,19,11],[16,1,16,9],[9,2,10,9],[9,1,10,1],[78,2,78,9],[23,2,24,9],[36,2,37,9],[18,10,19,10],[17,2,18,9],[31,10,32,10],[31,11,32,11],[30,2,31,9],[28,2,28,9],[26,2,26,9],[24,11,25,11],[21,11,22,11],[34,11,35,11],[34,10,35,10],[33,2,34,8],[24,10,25,10],[37,10,38,10],[43,1,43,9],[77,1,77,9],[68,2,69,9],[64,11,65,11],[41,11,42,11],[48,11,49,11],[51,11,52,11],[58,11,59,11],[60,11,62,11],[53,10,56,10],[60,10,62,10],[64,10,65,10],[41,10,42,10],[48,10,49,10],[51,10,52,10],[58,10,59,10],[45,10,46,10],[80,2,81,9],[81,10,82,10],[97,6,97,7],[75,11,76,11],[69,11,70,11],[72,11,73,11],[72,10,73,10],[69,10,70,10],[75,10,76,10],[107,2,108,9],[108,10,109,10],[104,2,105,9],[105,10,106,10],[81,11,82,11],[91,2,92,9],[89,1,89,10],[119,1,119,10],[92,10,94,10],[92,11,94,11],[95,2,96,9],[96,10,97,10],[96,11,97,11],[98,2,99,9],[99,10,100,10],[99,11,100,11],[101,2,102,9],[102,10,103,10],[102,11,103,11],[105,11,106,11],[83,2,83,9],[85,2,85,9],[90,1,90,10],[87,2,87,9],[137,1,137,10],[138,1,141,10],[132,1,135,10],[112,2,112,6],[112,8,112,9],[111,8,111,9],[110,1,110,9],[131,1,131,10],[115,2,116,10],[115,1,116,1],[125,1,125,10],[126,1,129,10],[120,1,123,10]]}
[null,"APPLICANT Capacity Scorecard"]
[]
[]
[null,"Entity Name",null,null,null,null,null,null,null,null,"Date"]
[]
[null,"Project Name: "]
[]
[null,"Type of Scorecard",null,null,null,"Continuum of Care"]
[]
[null,"!","KHC's Credit Committee will consider applications in their entirety in approving entities for funding, and will consider such criteria as concentrations of risk, total funds outstanding, and all other risk factors it deems appropriate."]
[]
[]
[null,"!","PLEASE NOTE:  Kentucky Housing Corporation considers a final Capacity Score of 60% to be a minimum threshold, and will make that final score determination.  \nIf your score is near or below that percentile, it is unlikely that your entity will be eligible for funding.  Scoring above the minimum capacity threshold does not guarantee funding. The choice to proceed with completing the balance of the application is at your own discretion. "]
[]
[]
[]
[null," Experience and Capacity",null,null,null,null,null,null,null,null,"Scoring","Max \nPoints"]
[null,1,"Is the entity, any of its staff, or any member of a development team* currently suspended or debarred by KHC or another funding agency?",null,null,null,null,null,null,null,null,{"$f":"IF(K18=\"N/A\",\"0\",\"5\")","v":"5"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K18=\"Yes\",$D$20,IF(K18=\"No\",$F$20,\"0\"))","v":"0"}]
[null,null,"Yes = ",-100,"No = ",5]
[null,2,"Has the entity, any of its staff, or any member of a development team* received or administered funds for one or more federal housing programs for at least 3 of the past 5 years (from application due date)?",null,null,null,null,null,null,null,null,{"$f":"IF(K21=\"N/A\",\"0\",\"5\")","v":"5"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K21=\"Yes\",$D$23,IF(K21=\"No\",$F$23,\"0\"))","v":"0"}]
[null,null,"Yes = ",5,"No = ",0]
[null,3,"Has the entity, any of its staff, or any member of a development team* received funds for or administered this particular program for at least 3 of the past 5 years (from application due date)?",null,null,null,null,null,null,null,null,{"$f":"IF(K24=\"N/A\",\"0\",\"5\")","v":"5"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K24=\"Yes\",$D$26,IF(K24=\"No\",$F$26,\"0\"))","v":"0"}]
[null,null,"Yes = ",5,"No = ",0]
[null,4,"Has there been staff turnover or entity reorganization that has negatively or positively affected your capacity?",null,null,null,null,null,null,null,null,{"$f":"IF(K27=\"N/A\",\"0\",\"5\")","v":"5"}]
[null,null,"Negatively = ",0,"Positively = ",5,"N/A = ","Not Factored",null,null,{"$f":"IF(K27=\"Negatively\",$D$28,IF(K27=\"Positively\",$F$28,\"0\"))","v":"0"}]
[null,5,"Does the entity have effective procedures and controls for program/project management?",null,null,null,null,null,null,null,null,{"$f":"IF(K29=\"N/A\",\"0\",\"5\")","v":"5"}]
[null,null,"Yes = ",5,"No = ",0,null,null,null,null,{"$f":"IF(K29=\"Yes\",$D$30,IF(K29=\"No\",$F$30,\"0\"))","v":"0"}]
[null,6,"Is the entity aware of any information that has been provided to KHC (e.g. by auditors, other funders, other agencies) that would highlight potential risk to KHC if this application is approved?",null,null,null,null,null,null,null,null,{"$f":"IF(K31=\"N/A\",\"0\",\"5\")","v":"5"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K31=\"Yes\",$D$33,IF(K31=\"No\",$F$33,\"0\"))","v":"0"}]
[null,null,"Yes = ",0,"No = ",5]
[null,7,"Does the entity provide reports or other requested documentation in a timely manner as defined by the timelines in KHC's written agreement(s)?",null,null,null,null,null,null,null,null,"5"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K34=\"Yes\",$D$36,IF(K34=\"No\",$F$36,\"0\"))","v":"0"}]
[null,null,"Yes = ",5,"No = ",0,"N/A = ","Not Factored"]
[null,8,"Does the entity, staff, or member of a development team* have any outstanding lawsuits filed against them that could result in suspension or debarment as defined in KHC’s policy?",null,null,null,null,null,null,null,null,"5"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K37=\"Yes\",$D$39,IF(K37=\"No\",$F$39,\"0\"))","v":"0"}]
[null,null,"Yes = ",0,"No = ",5]
[null,"8A","If you answered “yes” to question 8, please provide further explanation in the 8A text box at the bottom of the scorecard."]
[null,9,"Has any of the entity staff or member of a development team* been jailed, convicted of a felony, or is currently under criminal investigation for activities related to the organization's work?",null,null,null,null,null,null,null,null,"5"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K41=\"Yes\",$D$43,IF(K41=\"No\",$F$43,\"0\"))","v":"0"}]
[null,null,"Yes = ",0,"No = ",5]
[null," Monitoring History"]
[null,10,"If previous funding was for the construction or rehabilitation (including weatherization) of units, were there any issues with construction quality as defined in the KHC construction guidelines? ",null,null,null,null,null,null,null,null,"5"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K45=\"Yes\",$D$47,IF(K45=\"No\",$F$47,\"0\"))","v":"0"}]
[null,null,"Yes = ",0,"No = ",5,"N/A = ","Not Factored"]
[null,11,"Has the entity staff or member of a development team* been cooperative and timely in response to previous compliance reviews?",null,null,null,null,null,null,null,null,"5"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K48=\"Yes\",$D$50,IF(K48=\"No\",$F$50,\"0\"))","v":"0"}]
[null,null,"Yes = ",5,"No = ",0,"N/A = ","Not Factored"]
[null,12,"Has the entity or any member of a development team* had funds from any KHC program area recaptured as a result of noncompliance in the past 3 years (from application due date)? If \"Yes,\" please answer #12A below.",null,null,null,null,null,null,null,null,{"$f":"IF(K51=\"N/A\",\"0\",\"5\")","v":"5"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K51=\"Yes\",$D$53,IF(K51=\"No\",$F$53,\"0\"))","v":"0"}]
[null,null,"Yes = ",-20,"No = ",5,"N/A = ","Not Factored"]
[null,"12A","If you answered \"Yes\" to #12, from what program(s) were the funds recaptured?",null,null,null,null,null,null,null,"Please use checkboxes to select applicable programs"]
[null,null,"*Please explain this situation in the 12A text box at the bottom of the scorecard."]
[null,null,"HOME","LIHTC","ESG","HOPWA"]
[null,null,"AHTF  ","SMAL","CoC","Other    "]
[null,13,"Has the entity or any member of a development team* voluntarily returned funds from any KHC program area to KHC within the past 3 years (from application due date)? If \"Yes,\" please answer #13A and #13B below.",null,null,null,null,null,null,null,null,{"$f":"IF(K58=\"N/A\",\"0\",\"15\")","v":"15"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K58=\"Yes\",$D$60,IF(K58=\"No\",$F$60,\"0\"))","v":"0"}]
[null,null,"Yes = ",0,"No = ",15,"N/A = ","Not Factored"]
[null,"13A","If you answered \"Yes\" to #13, from what program(s) were the funds voluntarily returned?",null,null,null,null,null,null,null,"Please use checkboxes to select applicable programs"]
[null,null,"HOME","LIHTC","ESG","HOPWA"]
[null,null,"AHTF  ","SMAL","CoC","Other    "]
[null,"13B","If funds were voluntarily returned, to the best of your knowledge, were they either: less than 3% of the allocation; or re-allocated; and/or resulted in no loss or penalty to KHC? Please explain this situation in the 13B text box at the bottom of the Scorecard.",null,null,null,null,null,null,null,null,{"$f":"IF(K64=\"\",\"0\",IF(K64=\"N/A\",\"0\",\"5\"))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K64=\"Yes\",$D$66,IF(K64=\"No\",$F$66,\"0\"))","v":"0"}]
[null,null,"Yes = ",5,"No = ",0,"N/A = ","Not Factored"]
[null,14,"How much KHC funding does your agency currently have outstanding?",null,null,null,null,null,null,null,null,{"$f":"IF(K67=\"N/A\",\"0\",\"10\")","v":"10"}]
[null,null,"$0 - $49,999 =",10,null,"$50,000 - $99,999 = ",5,"Over $100,000 = ",0,null,{"$f":"IF(K67=\"$0 - $49999\",$D$68,IF(K67=\"$50000 - $99999\",$G$68,IF(K67=\"Over $100000\",$I$68,\"0\")))","v":"0"}]
[null,15,"Does the entity or any member of a development team* have any projects on which there are outstanding compliance findings that have not been resolved within the correction timeframe?",null,null,null,null,null,null,null,null,"5"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K69=\"Yes\",$D$71,IF(K69=\"No\",$F$71,\"0\"))","v":"0"}]
[null,null,"Yes = ",0,"No = ",5,"N/A = ","Not Factored"]
[null,16,"Does the entity or any member of a development team* have any KHC-funded projects that are currently, or have been, delinquent within the past 3 years (from application due date)? If your answer is \"Yes,\" please answer #16A below.",null,null,null,null,null,null,null,null,"5"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K72=\"Yes\",$D$74,IF(K72=\"No\",$F$74,\"0\"))","v":"0"}]
[null,null,"Yes = ",0,"No = ",5,"N/A = ","Not Factored"]
[null,"16A","If you answered \"Yes\" to #16, has the entity, owner, or developer worked with KHC to restructure or otherwise provide financial support for the project?",null,null,null,null,null,null,null,null,{"$f":"IF(K75=\"\",\"0\",IF(K75=\"N/A\",\"0\",\"5\"))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K75=\"Yes\",$D$77,IF(K75=\"No\",$F$77,\"0\"))","v":"0"}]
[null,null,"Yes = ",5,"No = ",0,"N/A = ","Not Factored"]
[null," Financial Management"]
[null,17,"Does the entity have effective procedures and controls for financial management?",null,null,null,null,null,null,null,null,{"$f":"IF(K79=\"N/A\",\"0\",\"10\")","v":"10"}]
[null,null,"Yes = ",10,"No = ",0,null,null,null,null,{"$f":"IF(K79=\"Yes\",$D$80,IF(K79=\"No\",$F$80,\"0\"))","v":"0"}]
[null,18,"Does the entiy provide proper documentation for draw requests (i.e. receipts, reports, supporting documents as requested) if previously funded?",null,null,null,null,null,null,null,null,"5"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K81=\"Yes\",$D$83,IF(K81=\"No\",$F$83,\"0\"))","v":"0"}]
[null,null,"Yes = ",5,"No = ",0,"N/A = ","Not Factored"]
[null,19,"Does the entity have a system in place to accurately track receipts, expenditures, and budgets?",null,null,null,null,null,null,null,null,"5"]
[null,null,"Yes = ",5,"No = ",0,null,null,null,null,{"$f":"IF(K84=\"Yes\",$D$85,IF(K84=\"No\",$F$85,\"0\"))","v":"0"}]
[null,20,"Do the entity's financial reports indicate cash flow problems?",null,null,null,null,null,null,null,null,"5"]
[null,null,"Yes = ",0,"No = ",5,null,null,null,null,{"$f":"IF(K86=\"Yes\",$D$87,IF(K86=\"No\",$F$87,\"0\"))","v":"0"}]
[null,21,"Does the entity have a system in place to track and report proper time records for all staff associated with this project?",null,null,null,null,null,null,null,null,"5"]
[null,null,"Yes = ",5,"No = ",0,null,null,null,null,{"$f":"IF(K88=\"Yes\",$D$89,IF(K88=\"No\",$F$89,\"0\"))","v":"0"}]
[null,{"$f":"IF(F8=\"Multifamily Projects\",\"Additional Questions for Multifamily Projects\",IF(F8=\"Residential Production\",\"Additional Questions for Residential Production\",IF(F8=\"Counseling Agencies\",\"Additional Questions for Counseling Agencies\",IF(F8=\"Continuum of Care\",\"Additional Questions for Continuum of Care\",\"Additional Questions\"))))","v":"Additional Questions for Continuum of Care"}]
[null,"Note that this section will only affect your score if additional questions have been established for your project"]
[null,22,"Did your project(s) have unused funds exceeding 3% of your total project award at the end of your grant term for HUD program years 2010, 2011 or 2012?  (Choose from drop down A, B, C, or D) ",null,null,null,null,null,null,null,null,{"$f":"IF(K92=\"Yes\",\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K92=\"A\",F94,IF(K92=\"B\",F95,IF(K92=\"C\",J94,IF(K92=\"D\",J95,\"0\"))))","v":"0"}]
[null,null," A. No unused funds exceeding 3% in any year",null,null,10,"C. Unused funds exceeding 3% in two years",null,null,-10]
[null,null,"B. Unused funds exceeding 3% in only one year",null,null,-5,"D. unused funds exceeding 3% in three years",null,null,-15]
[null,23,"For 2013 awarded grants, if your project's grant term has CLOSED, did your program have any unused funds? ",null,null,null,null,null,null,null,null,{"$f":"IF(K96=\"Yes\",\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K96=\"Yes\",D98,IF(K96=\"No\",F98,\"0\"))","v":"0"}]
[null,null,"Yes = ",-5,"No = ",0,"N/A = Not Factored"]
[null,"23A","If your 2013 project is still OPEN, is your program on track to expend down all 2013 awarded grant funds?  ",null,null,null,null,null,null,null,null,{"$f":"IF(K99=\"Yes\",\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K99=\"Yes\",D101,IF(K99=\"No\",F101,\"0\"))","v":"0"}]
[null,null,"Yes = ",0,"No = ",-5,"N/A = Not Factored"]
[null,24,"If you answered 'NO' to 23A, how much of your 2013 awarded funds do you anticipate will be left unspent at the end of the grant term?  ",null,null,null,null,null,null,null,null,{"$f":"IF(K102=\"Yes\",\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K102=\"Yes\",D104,IF(K102=\"No\",F104,\"0\"))","v":"0"}]
[null,null,"4% or more = ",-5,"3% or less = ",0,"N/A = Not Factored"]
[null,25,"If your program has unused funds from prior years, has your agency already reduced this project budget through the application process in prior years or in the upcoming 2015 application (as indicated in your Intent to Apply) to prevent any unused funds at the end of your HUD 2015 grant term? ",null,null,null,null,null,null,null,null,{"$f":"IF(K105=\"Yes\",\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K105=\"Yes\",D107,IF(K105=\"No\",F107,\"0\"))","v":"0"}]
[null,null,"Yes = ",10,"No = ",0,"N/A = Not Factored"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K108=\"Yes\",\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K108=\"Yes\",D110,IF(K108=\"No\",F110,\"0\"))","v":"0"}]
[]
[null," Total Score",null,null,null,null,null,null,null,null,{"$f":"K19+K22+K25+K28+K30+K32+K35+K38+K42+K46+K49+K52+K59+K65+K68+K70+K73+K76+K80+K82+K85+K87+K89+K93+K97+K100+K103+K106+K109","v":0}]
[null,null,null,null,null,null,null,null,"Points Possible",null,{"$f":"L18+L21+L24+L27+L29+L31+L34+L37+L41+L45+L48+L51+L58+L64+L67+L69+L72+L75+L79+L81+L84+L86+L88+L92+L96+L99+L102+L105+L108","v":125}]
[null,null,"* Footnote: \"Development team\" refers to entities or individuals that may be associated with the application as defined in the program guidelines.",null,null,null,null,null,"Score Percentage",null,{"$f":"K111/(K112)","v":0}]
[]
[]
[null,"!","PLEASE NOTE:  Kentucky Housing Corporation considers a final Capacity Score of 60% to be a minimum threshold, and will make that final score determination.  \nIf your score is near or below that percentile, it is unlikely that your agency will be eligible for funding.  Scoring above the minimum capacity threshold does not guarantee funding. The choice to proceed with completing the balance of the application is at your own discretion. "]
[]
[]
[]
[null," Follow-up to #8A -- Please explain any applicable outstanding lawsuits referred to in #8."]
[]
[]
[]
[]
[]
[null," Follow-up to #12A -- Please explain why funds were recaptured by KHC."]
[]
[]
[]
[]
[]
[null," Follow-up to #13B -- Please explain why funds were voluntarily returned to KHC."]
[]
[]
[]
[]
[]
[null," Follow-up to any other section needed."]

{"sheet":"KY BoS CoC Fair Housing Survey","index":1,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,0,4,9],[11,0,11,9],[40,0,40,11],[0,0,0,9],[41,0,63,9],[12,0,12,9],[13,0,13,3],[8,0,8,9],[2,0,2,8],[7,0,7,10],[10,0,10,7],[6,0,6,9],[9,0,9,9],[5,0,5,9],[1,0,1,9],[3,0,3,8]]}
["Kentucky Balance of State Continuum of Care Fair Housing Survey"]
[]
["Entity Name",null,null,null,null,null,null,null,null,"Date"]
[]
["Project Name: "]
["All entities applying for funds through the 2015 Continuum of Care (CoC) application process are require to complete a Fair Housing Survey for each project administered by entity. If an entity cannot demonstrate that a new or renewal project will address one of the impediments, the project may be subject to not being allowed to move forward in application process or funds being reallocated to another project.  "]
[]
["The Twenty-Five Impediments to Fair Housing are listed on pages 12 to 15 of KHC’s Our Right to Choose Where We Live"]
["http://www.kyhousing.org/Resources/Data-Library/Documents/2014AnalysisofImpediments.pdf"]
[]
["1. Does this project address any of the Twenty-Five Impediments to Fair Housing?",null,null,null,null,null,null,null,null,null,null,"Click onto box and select from drop down, Yes or No."]
[]
["2. If yes, list which impediments this project will help to reduce or eliminate. "]
["(Mark all that apply with an X) "]
[null,"Credit"]
[null,"Appraisals"]
[null,"Lending"]
[null,"Predatory Practices"]
[null,"Environmental"]
[null,"Zoning"]
[null,"Insurance"]
[null,"Tax Credit Projects"]
[null,"Foreclosures"]
[null,"Miscellaneous"]
[null,"Inadequate State and Local Laws"]
[null,"Criminal Justice System"]
[null,"Fair Housing"]
[null,"Connectivity: Transportation and Internet"]
[null,"Inadequate Affordable Housing Stock"]
[null,"Mobile Homes"]
[null,"LGBT"]
[null,"Elderly"]
[null,"Individuals with Disabilities"]
[null,"Domestic Violence Victims"]
[null,"Immigrants"]
[null,"Families with Children"]
[null,"Rural"]
[null,"Public Culture"]
[null,"Education"]
[]
["3. Explain how this project will help to reduce or eliminate the identified impediments to fair housing."]
["(Type Text Here)"]