Spreadsheet: 492585ff-d3f7-4669-a91f-19e152ad28da
Sheet: Sheet1

Planning Estimates on Unmet Need for Formula and Competitive Grantees as of 11-30-2011 (Data taken from PY 2010-11 Performance Reports,  January 12, 2012 edition) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
HOPWA Grantee Name | Grant Number | St | HUD Region | # of Unmet Needs for TBRA | #of Unmet Needs for STRMU | # of Unmet Needs for FBHA | Total # of Households that have unmet housing needs | Sum of Unmet Need for TBRA, STRMU and [NAME] (Data Check) | # of Households receiving HOPWA Housing Assistance | # of Households receiving leveraged Housing Assistance | % Served (leveraged and HOPWA HH)
Alaska Housing Finance Corporation | AK-H080001 | AK | 10 - NW/Alaska | 11 | 11 | 2 | 21 | 24 | 34 | 15 | 0.7
Alaska Housing Finance Corporation | AK-H090008 | AK | 10 - NW/Alaska | 15 | 10 | 0 | 25 | 25 | 40 | 57 | 0.7950819672131147
City of Birmingham |  | AL | 04 - SE/Caribbean | 380 | 287 | 427 | 1094 | 1094 | 218 | 0 | 0.1661585365853659
State of Alabama |  | AL | 04 - SE/Caribbean | 1082 | 1220 | 1472 | 3774 | 3774 | 192 | 0 | 0.04841149773071105
State of Arkansas |  | AR | 06 - Southwest | 68 | 0 | 0 | 68 | 68 | 224 | 0 | 0.7671232876712328
City of Phoenix |  | AZ | 09 - Pacific/Hawaii | 250 |  | 250 | 500 | 500 | 493 | 0 | 0.4964753272910373
City of Tucson |  | AZ | 09 - Pacific/Hawaii | 40 | 50 | 55 | 145 | 145 | 146 | 0 | 0.5017182130584192
State of Arizona |  | AZ | 09 - Pacific/Hawaii | 7 | 2 | 0 | 9 | 9 | 61 | 0 | 0.8714285714285714
City of Los Angeles |  | CA | 09 - Pacific/Hawaii | 728 | 0 | 543 | 1271 | 1271 | 2225 | 0 | 0.636441647597254
City of Oakland |  | CA | 09 - Pacific/Hawaii | 729 | 2431 | 1701 | 4861 | 4861 | 350 | 214 | 0.103963133640553
City of Riverside |  | CA | 09 - Pacific/Hawaii | 850 | 1053 | 528 | 2431 | 2431 | 399 | 0 | 0.1409893992932862
City of Sacramento |  | CA | 09 - Pacific/Hawaii | 22 | 435 | 56 | 513 | 513 | 719 | 0 | 0.5836038961038961
City of San Diego |  | CA | 09 - Pacific/Hawaii | 2869 | 228 | 898 | 3995 | 3995 | 653 | 0 | 0.1404905335628227
City of San Francisco |  | CA | 09 - Pacific/Hawaii | 13000 | 13000 | 1500 | 15000 | 27500 | 755 | 615 | 0.08368967623701894
City of San Jose |  | CA | 09 - Pacific/Hawaii | 0 | 0 | 0 | 283 | 0 | 130 | 0 | 0.3147699757869249
City of Santa Ana |  | CA | 09 - Pacific/Hawaii | 221 | 91 | 0 | 312 | 312 | 216 | 0 | 0.4090909090909091
State of California |  | CA | 09 - Pacific/Hawaii | 62 | 250 | 4 | 316 | 316 | 1290 | 183 | 0.8233650083845724
City of Denver |  | CO | 08 - Rocky Mountain | 300 | 0 | 33 | 333 | 333 | 234 | 0 | 0.4126984126984127
State of Colorado |  | CO | 08 - Rocky Mountain | 201 | 21 | 0 | 222 | 222 | 108 | 0 | 0.3272727272727273
City of Bridgeport |  | CT | 01 - New England | 4 | 1 | 10 | 58 | 15 | 80 | 0 | 0.5797101449275363
City of Hartford |  | CT | 01 - New England | 100 | 220 | 80 | 400 | 400 | 141 | 0 | 0.2606284658040666
City of New Haven |  | CT | 01 - New England | 94 | 18 | 12 | 124 | 124 | 132 | 26 | 0.5602836879432624
State of Connecticut |  | CT | 01 - New England | 67 | 2 | 23 | 92 | 92 | 24 | 25 | 0.3475177304964539
District of Columbia |  | DC | 03 - Mid-Atlantic | 220 | 50 | 41 | 311 | 311 | 1220 | 70 | 0.8057464084946908
City of Wilmington |  | DE | 03 - Mid-Atlantic | 172 | 0 | 13 | 185 | 185 | 182 | 0 | 0.4959128065395095
State of Delaware |  | DE | 03 - Mid-Atlantic | 59 | 0 | 10 | 69 | 69 | 34 | 0 | 0.3300970873786408
City of Ft. Lauderdale |  | FL | 04 - SE/Caribbean | 218 | 573 | 171 | 962 | 962 | 926 | 454 | 0.5892399658411615
City of Jacksonville |  | FL | 04 - SE/Caribbean | 0 | 1000 | 50 | 1050 | 1050 | 1507 | 0 | 0.5893625342197888
City of Miami |  | FL | 04 - SE/Caribbean | 8934 | 0 | 0 | 8934 | 8934 | 1094 | 0 | 0.1090945353011568
City of Orlando |  | FL | 04 - SE/Caribbean | 82 | 24 | 24 | 130 | 130 | 895 | 0 | 0.8731707317073171
City of Tampa |  | FL | 04 - SE/Caribbean | 13 | 382 | 39 | 434 | 434 | 447 | 283 | 0.627147766323024
City of West Palm Beach |  | FL | 04 - SE/Caribbean | 234 | 0 | 0 | 234 | 234 | 311 | 272 | 0.7135862913096696
State of Florida |  | FL | 04 - SE/Caribbean | 0 | 0 | 0 | 0 | 0 | 2647 | 84 | 1
City of Atlanta |  | GA | 04 - SE/Caribbean | 1775 | 3417 | 4991 | 10183 | 10183 | 1641 | 46 | 0.14212299915754
City of Augusta |  | GA | 04 - SE/Caribbean | 8 | 69 | 21 | 98 | 98 | 91 | 0 | 0.4814814814814815
State of Georgia |  | GA | 04 - SE/Caribbean | 167 | 81 | 159 | 407 | 407 | 411 | 141 | 0.5755995828988529
City of Savannah | GA-H070010 | GA | 04 - SE/Caribbean | 324 | 138 | 109 | 571 | 571 | 62 | 0 | 0.09794628751974724
City of Honolulu |  | HI | 09 - Pacific/Hawaii | 212 | 0 | 5 | 217 | 217 | 49 | 0 | 0.1842105263157895
State of Hawaii |  | HI | 09 - Pacific/Hawaii | 34 | 0 | 0 | 50 | 34 | 31 | 44 | 0.6
State of Iowa |  | IA | 07 - Great Plains | 26 | 53 | 0 | 79 | 79 | 109 | 9 | 0.5989847715736041
Idaho Housing & Finance Association | ID-H080004 | ID | 10 - NW/Alaska | 110 | 6 | 0 | 116 | 116 | 117 | 16 | 0.5341365461847389
City of Chicago |  | IL | 05 - Midwest | 400 | 800 | 200 | 1400 | 1400 | 1487 | 0 | 0.5150675441634915
State of Illinois |  | IL | 05 - Midwest | 369 | 0 | 67 | 436 | 436 | 733 | 0 | 0.6270316509837468
City of Indianapolis |  | IN | 05 - Midwest | 324 | 701 | 0 | 1025 | 1025 | 296 | 120 | 0.2886884108258154
State of Indiana |  | IN | 05 - Midwest | 74 | 117 | 27 | 218 | 218 | 448 | 136 | 0.7281795511221946
State of Kansas |  | KS | 07 - Great Plains | 4 | 22 | 0 | 26 | 26 | 144 | 0 | 0.8470588235294118
City of Louisville |  | KY | 04 - SE/Caribbean | 45 | 0 | 0 | 45 | 45 | 451 | 0 | 0.9092741935483871
Commonwealth of Kentucky |  | KY | 04 - SE/Caribbean | 43 | 0 | 0 | 43 | 43 | 329 | 73 | 0.903370786516854
City of Baton Rouge |  | LA | 06 - Southwest | 0 | 0 | 60 | 60 | 60 | 675 | 8 | 0.9192462987886945
City of New Orleans |  | LA | 06 - Southwest | 0 | 66 | 41 | 107 | 107 | 659 | 164 | 0.8849462365591397
State of Louisiana |  | LA | 06 - Southwest | 76 | 249 | 0 | 325 | 325 | 783 | 0 | 0.7066787003610109
City of Boston |  | MA | 01 - New England | 882 | 0 | 56 | 938 | 938 | 296 | 34 | 0.2602523659305994
City of Lowell |  | MA | 01 - New England | 204 | 0 | 0 | 204 | 204 | 28 | 0 | 0.1206896551724138
City of Lynn |  | MA | 01 - New England | 9 | 0 | 0 | 9 | 9 | 70 | 0 | 0.8860759493670886
City of Springfield |  | MA | 01 - New England | 325 | 556 | 10 | 891 | 891 | 110 | 0 | 0.1098901098901099
City of Worcester |  | MA | 01 - New England | 125 | 38 | 4 | 167 | 167 | 50 | 30 | 0.3238866396761134
State of Massachusetts |  | MA | 01 - New England | 2600 | 400 | 600 | 3600 | 3600 | 0 | 0 | 0
City of Baltimore |  | MD | 03 - Mid-Atlantic | 564 | 0 | 0 | 564 | 564 | 843 | 0 | 0.5991471215351812
State of Maryland |  | MD | 03 - Mid-Atlantic | 16 | 0 | 0 | 16 | 16 | 105 | 0 | 0.8677685950413223
Frannie Peabody Center | ME-H090003 | ME | 01 - New England | 53 | 0 | 0 | 53 | 53 | 46 | 15 | 0.5350877192982456
Frannie Peabody Center | ME-H090019 | ME | 01 - New England | 65 | 0 | 0 | 65 | 65 | 138 | 1 | 0.6813725490196079
Frannie Peabody Center | ME-H090020 | ME | 01 - New England | 39 | 0 | 0 | 39 | 39 | 43 | 19 | 0.6138613861386139
City of Detroit |  | MI | 05 - Midwest | 1475 | 1967 | 75 | 3517 | 3517 | 246 | 0 | 0.06537337230932766
State of Michigan |  | MI | 05 - Midwest | 133 | 399 | 0 | 532 | 532 | 281 | 18 | 0.3598074608904934
City of Minneapolis |  | MN | 05 - Midwest | 70 | 0 | 0 | 70 | 70 | 148 | 0 | 0.6788990825688074
State of Minnesota |  | MN | 05 - Midwest | 0 | 9 | 0 | 9 | 9 | 155 | 0 | 0.9451219512195121
City of Kansas City |  | MO | 07 - Great Plains | 266 | 161 | 273 | 700 | 700 | 300 | 10 | 0.3069306930693069
City of St. Louis |  | MO | 07 - Great Plains | 123 | 206 | 6 | 335 | 335 | 449 | 0 | 0.5727040816326531
State of Missouri |  | MO | 07 - Great Plains | 0 | 0 | 0 | 0 | 0 | 249 | 0 | 1
City of Jackson |  | MS | 04 - SE/Caribbean | 18 | 1622 | 0 | 1640 | 1640 | 385 | 0 | 0.1901234567901235
State of Mississippi |  | MS | 04 - SE/Caribbean | 20 | 1537 | 0 | 2208 | 1557 | 651 | 0 | 0.2277019937040923
State of Montana | MT-H080010 | MT | 08 - Rocky Mountain | 214 | 26 | 0 | 240 | 240 | 117 | 126 | 0.5031055900621118
State of Montana | MT-H090022 | MT | 08 - Rocky Mountain | 218 | 8 | 0 | 226 | 226 | 101 | 0 | 0.308868501529052
City of Charlotte |  | NC | 04 - SE/Caribbean | 0 | 0 | 0 | 1000 | 0 | 147 | 0 | 0.1281604184829991
State of North Carolina |  | NC | 04 - SE/Caribbean | 35 | 0 | 0 | 35 | 35 | 1722 | 0 | 0.9800796812749004
Wake County |  | NC | 04 - SE/Caribbean | 964 | 0 | 0 | 964 | 964 | 284 | 0 | 0.2275641025641026
State of Nebraska |  | NE | 07 - Great Plains | 350 | 170 | 40 | 560 | 560 | 128 | 36 | 0.2265193370165746
City of Nashua | NH-H090005 | NH | 01 - New England | 10 | 0 | 0 | 10 | 10 | 35 | 0 | 0.7777777777777778
Harbor Homes, Inc. | NH-H080011 | NH | 01 - New England | 12 | 0 | 0 | 12 | 12 | 25 | 4 | 0.7073170731707317
State of New Hampshire | NH-H080012 | NH | 01 - New England | 8 | 16 | 0 | 24 | 24 | 92 | 53 | 0.8579881656804734
State of New Hampshire | NH-H090023 | NH | 01 - New England | 3 | 31 | 0 | 34 | 34 | 49 | 59 | 0.7605633802816901
City of Camden |  | NJ | 02 - NewYork/New Jersey | 54 | 0 | 0 | 54 | 54 | 65 | 0 | 0.5462184873949579
City of Jersey City |  | NJ | 02 - NewYork/New Jersey | 210 | 88 | 0 | 298 | 298 | 319 | 224 | 0.6456599286563615
City of Newark |  | NJ | 02 - NewYork/New Jersey | 367 | 0 | 0 | 367 | 367 | 694 | 0 | 0.6540999057492931
City of Paterson |  | NJ | 02 - NewYork/New Jersey | 112 | 64 | 25 | 439 | 201 | 175 | 0 | 0.2850162866449512
State of New Jersey |  | NJ | 02 - NewYork/New Jersey | 1000 | 0 | 30 | 1600 | 1030 | 191 | 0 | 0.106644332774986
Township of Edison |  | NJ | 02 - NewYork/New Jersey | 122 | 0 | 0 | 122 | 122 | 125 | 0 | 0.5060728744939271
State of New Mexico |  | NM | 06 - Southwest | 15 | 147 | 8 | 170 | 170 | 662 | 0 | 0.7956730769230769
City of Las Vegas |  | NV | 09 - Pacific/Hawaii | 175 | 780 | 500 | 1455 | 1455 | 265 | 1 | 0.1545613015688553
State of Nevada |  | NV | 09 - Pacific/Hawaii | 0 | 13 | 0 | 13 | 13 | 147 | 0 | 0.91875
City of Albany |  | NY | 02 - NewYork/New Jersey | 46 | 0 | 10 | 56 | 56 | 132 | 0 | 0.7021276595744681
City of Buffalo |  | NY | 02 - NewYork/New Jersey | 500 | 50 | 100 | 650 | 650 | 179 | 0 | 0.2159227985524729
City of New York City |  | NY | 02 - NewYork/New Jersey | 0 | 0 | 935 | 935 | 935 | 4460 | 25095 | 0.9693342079370285
City of Poughkeepsie |  | NY | 02 - NewYork/New Jersey | 953 | 0 | 0 | 953 | 953 | 105 | 0 | 0.09924385633270322
City of Rochester |  | NY | 02 - NewYork/New Jersey | 200 | 100 | 30 | 330 | 330 | 266 | 0 | 0.4463087248322148
State of New York |  | NY | 02 - NewYork/New Jersey | 162 | 0 | 0 | 162 | 162 | 442 | 20 | 0.7403846153846154
Town of Islip |  | NY | 02 - NewYork/New Jersey | 0 | 0 | 832 | 832 | 832 | 7 | 7 | 0.01654846335697399
City of Cincinnati |  | OH | 05 - Midwest | 55 | 0 | 0 | 55 | 55 | 171 | 110 | 0.8363095238095238
City of Cleveland |  | OH | 05 - Midwest | 250 | 624 | 9 | 883 | 883 | 285 | 0 | 0.2440068493150685
City of Columbus |  | OH | 05 - Midwest | 112 | 0 | 9 | 121 | 121 | 203 | 92 | 0.7091346153846154
State of Ohio |  | OH | 05 - Midwest | 24 | 363 | 0 | 387 | 387 | 794 | 17 | 0.6769616026711185
City of Oklahoma City |  | OK | 06 - Southwest | 290 | 260 | 110 | 660 | 660 | 129 | 0 | 0.1634980988593156
City of Tulsa |  | OK | 06 - Southwest | 33 | 45 | 4 | 82 | 82 | 87 | 0 | 0.514792899408284
State of Oklahoma |  | OK | 06 - Southwest | 1218 | 2795 | 548 | 4561 | 4561 | 104 | 0 | 0.02229367631296892
City of Portland |  | OR | 10 - NW/Alaska | 77 | 68 | 486 | 631 | 631 | 212 | 23 | 0.2713625866050808
State of Oregon |  | OR | 10 - NW/Alaska | 124 | 0 | 0 | 124 | 124 | 82 | 0 | 0.3980582524271845
City of Philadelphia |  | PA | 03 - Mid-Atlantic | 7750 | 200 | 50 | 8000 | 8000 | 943 | 290 | 0.1335427271742662
City of Pittsburgh |  | PA | 03 - Mid-Atlantic | 126 | 0 | 0 | 126 | 126 | 162 | 0 | 0.5625
State of Pennsylvania |  | PA | 03 - Mid-Atlantic | 79 | 41 | 0 | 120 | 120 | 629 | 170 | 0.8694232861806311
[NAME] (inc. # for Puerto Rico) |  | PR | 04 - SE/Caribbean | 392 | 1240 | 16032 | 17664 | 17664 | 1237 | 181 | 0.07431086888166859
City of Providence |  | RI | 01 - New England | 165 | 0 | 109 | 274 | 274 | 113 | 6 | 0.3027989821882952
City of Charleston |  | SC | 04 - SE/Caribbean | 115 | 221 | 20 | 356 | 356 | 261 | 0 | 0.4230145867098866
City of Columbia |  | SC | 04 - SE/Caribbean | 418 | 370 | 278 | 1911 | 1066 | 135 | 0 | 0.06598240469208211
State of South Carolina |  | SC | 04 - SE/Caribbean | 88 | 1462 | 0 | 1550 | 1550 | 555 | 0 | 0.2636579572446556
City of Memphis |  | TN | 04 - SE/Caribbean | 8 | 0 | 11 | 19 | 19 | 396 | 0 | 0.9542168674698795
City of Nashville |  | TN | 04 - SE/Caribbean | 490 | 2651 | 79 | 4371 | 3220 | 372 | 0 | 0.0784313725490196
State of Tennessee |  | TN | 04 - SE/Caribbean | 0 | 177 | 0 | 177 | 177 | 551 | 0 | 0.7568681318681318
City of Austin |  | TX | 06 - Southwest | 440 | 653 | 327 | 1420 | 1420 | 343 | 0 | 0.1945547362450369
City of Dallas |  | TX | 06 - Southwest | 1511 | 2748 | 620 | 4879 | 4879 | 660 | 71 | 0.1303030303030303
City of El Paso |  | TX | 06 - Southwest | 51 | 0 | 0 | 51 | 51 | 60 | 0 | 0.5405405405405406
City of Fort Worth |  | TX | 06 - Southwest | 100 | 100 | 25 | 225 | 225 | 233 | 0 | 0.5087336244541485
City of Houston |  | TX | 06 - Southwest | 645 | 597 | 122 | 1364 | 1364 | 1538 | 0 | 0.5299793246037215
City of San Antonio |  | TX | 06 - Southwest | 68 | 0 | 11 | 79 | 79 | 209 | 0 | 0.7256944444444444
State of Texas |  | TX | 06 - Southwest | 32 | 45 | 0 | 77 | 77 | 1096 | 81 | 0.9385964912280702
Virgin Islands Community AIDS Resource and Educ | VI-H080015 | VI | 04 - SE/Caribbean | 0 | 0 | 9 | 9 | 9 | 42 | 0 | 0.8235294117647058
City of Salt Lake City |  | UT | 08 - Rocky Mountain | 60 | 20 | 0 | 80 | 80 | 129 | 0 | 0.6172248803827751
State of Utah |  | UT | 08 - Rocky Mountain | 1 | 0 | 0 | 1 | 1 | 39 | 0 | 0.975
City of Richmond |  | VA | 03 - Mid-Atlantic | 650 | 1640 | 538 | 2828 | 2828 | 115 | 0 | 0.03907577302072715
City of Virginia Beach |  | VA | 03 - Mid-Atlantic | 107 | 290 | 98 | 495 | 495 | 327 | 0 | 0.3978102189781022
State of Virginia |  | VA | 03 - Mid-Atlantic | 83 | 111 | 4 | 198 | 198 | 279 | 0 | 0.5849056603773585
Burlington Housing Authority | VT-H090025 | VT | 01 - New England | 8 | 0 | 0 | 8 | 8 | 11 | 0 | 0.5789473684210527
Vermont Housing and Conservation Board | VT-H080016 | VT | 01 - New England | 32 | 115 | 5 | 152 | 152 | 142 | 0 | 0.4829931972789115
City of Seattle |  | WA | 10 - NW/Alaska | 192 | 207 | 514 | 424 | 913 | 225 | 0 | 0.3466872110939908
State of Washington |  | WA | 10 - NW/Alaska | 124 | 15 | 4 | 143 | 143 | 262 | 48 | 0.6843267108167771
City of Milwaukee |  | WI | 05 - Midwest | 2 | 8 | 77 | 87 | 87 | 257 | 4 | 0.75
State of Wisconsin |  | WI | 05 - Midwest | 5 | 63 | 0 | 68 | 68 | 186 | 0 | 0.7322834645669292
State of West Virginia |  | WV | 03 - Mid-Atlantic | 16 | 15 | 10 | 41 | 41 | 209 | 0 | 0.836
Wyoming Dept.  of Health | WY-H080018 | WY | 08 - Rocky Mountain | 2 | 3 | 0 | 5 | 5 | 27 | 20 | 0.9038461538461539
City of Warren | No Report Submitted |  |  | - | - | - | - | - | - | - | -
HH Served from Competitive Grants in Formula areas |  | US |  |  |  |  |  |  | 4254 | 873
HH Served with Leveraged Funds |  | US |  |  |  |  |  |  |  | 30793
Total |  |  |  | 63683 | 52613 | 37265 | 145366 | 153561 | 60234 | 30793 | 0.3850663936749396
NOTE:  This is a compilation of planning information and estimates as well as from know wait lists reported by HOPWA grantees; some reports are pending validation.  (11-30-2011 data set, 1-12-12 edition)
**n= 140; with 1 report missing.  Information provided  by HOPWA Grantees has not been verified, i.e. Not consistent with standardization as actual data.  Does not distribute by state the HH or housing outputs from 80 competitive grants operating in formula areas.    Some duplication is possible in reports in nonformula areas.
**Not inclusive of leveraged resources for housing costs, e.g. State of Massachusetts coordinates permanent housing placement and supportive services with HOPWA funds.