formula for the weather distribution

Method for Allocating FY 2004 LIHEAP Contingency Funds $99,410,000 FINAL 5-Feb-04 40% Funds Block Percentage; 60% Funds Excess HDDs/Relative Share Block Grant A B C D E F G H Block Grant Allotment Percents State Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware D.C. Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada 0.00860045 0.00548986 0.00415928 0.00656255 0.04613891 0.01608720 0.02098632 0.00278553 0.00325921 0.01360848 0.01075959 0.00108355 0.00627508 0.05808651 0.02629994 0.01863912 0.00855992 0.01368640 0.00879264 0.01359579 0.01606896 0.04197959 0.05514805 0.03973105 0.00737355 0.02320202 0.00736027 0.00921776 0.00195349 Awards Based on Block Grant Allocation % $39,710,149 (Col B x $39,710,149) States With 65 or more Excess HDDs Month of January 19 States 19 States Excess HDDs Block Grant Allotment Percents 0.0000000 0.00548986 0.0000000 0.0000000 0.0000000 0.0000000 0.02098632 0.00278553 0.00325921 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.01359579 0.01606896 0.04197959 0.05514805 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 Percentage Each State Relative to Total (Col D x Col E) Awards Based on Excess HDDs $59,565,222 (Col F x $59,565,222) Total All States Block + HDDs $99,410,000 (Col C + Col G) $341,525 $218,003 $165,166 $260,600 $1,832,183 $638,825 $833,370 $110,614 $129,424 $540,395 $427,265 $43,028 $249,184 $2,306,624 $1,044,375 $740,162 $339,916 $543,489 $349,157 $539,891 $638,101 $1,667,016 $2,189,937 $1,577,726 $292,805 $921,356 $292,277 $366,039 $77,573 144 231 158 135 161 153 263 101 0.00% 1.08% 0.00% 0.00% 0.00% 0.00% 4.11% 0.55% 0.64% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.66% 3.15% 8.23% 10.81% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $0 $640,955 $0 $0 $0 $0 $2,450,204 $325,217 $380,521 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,587,342 $1,876,091 $4,901,220 $6,438,670 $0 $0 $0 $0 $0 $0 $341,525 $858,958 $165,166 $260,600 $1,832,183 $638,825 $3,283,574 $435,831 $509,945 $540,395 $427,265 $43,028 $249,184 $2,306,624 $1,044,375 $740,162 $339,916 $543,489 $349,157 $2,127,233 $2,514,192 $6,568,236 $8,628,607 $1,577,726 $292,805 $921,356 $292,277 $366,039 $77,573 Method for Allocating FY 2004 LIHEAP Contingency Funds $99,410,000 FINAL 5-Feb-04 40% Funds Block Percentage; 60% Funds Excess HDDs/Relative Share Block Grant A B C D E F G H Block Grant Allotment Percents State New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming 0.00794588 0.03897152 0.00520713 0.12724791 0.01896380 0.00799548 0.05138620 0.00790558 0.01246826 0.06835090 0.00691008 0.00683051 0.00649373 0.01386403 0.02263997 0.00747576 0.00595572 0.01957379 0.02050857 0.00905733 0.03576365 0.00299313 100.0% Territories Total to States $134,629 $99,275,371 Awards Based on Block Grant Allocation % $39,710,149 (Col B x $39,710,149) States With 65 or more Excess HDDs Month of January 19 States 129 198 201 65 102 19 States Excess HDDs Block Grant Allotment Percents 0.00794588 0.03897152 0.0000000 0.12724791 0.0000000 0.00799548 0.05138620 0.0000000 0.0000000 0.06835090 0.00691008 0.0000000 0.0000000 0.0000000 0.0000000 0.00747576 0.00595572 0.01957379 0.0000000 0.00905733 0.0000000 0.0000000 0.51018388 Percentage Each State Relative to Total (Col D x Col E) Awards Based on Excess HDDs $59,565,222 (Col F x $59,565,222) Total All States Block + HDDs $99,410,000 (Col C + Col G) $315,532 $1,547,565 $206,776 $5,053,030 $753,055 $317,502 $2,040,554 $313,932 $495,116 $2,714,224 $274,400 $271,241 $257,867 $550,543 $899,037 $296,864 $236,503 $777,278 $814,398 $359,668 $1,420,180 $118,858 $39,710,149 175 217 145 205 99 68 1.56% 7.64% 0.00% 24.94% 0.00% 1.57% 10.07% 0.00% 0.00% 13.40% 1.35% 0.00% 0.00% 0.00% 0.00% 1.47% 1.17% 3.84% 0.00% 1.78% 0.00% 0.00% 100.0% $927,701 $4,550,021 $0 $14,856,505 $0 $933,492 $5,999,465 $0 $0 $7,980,136 $806,769 $0 $0 $0 $0 $872,813 $695,345 $2,285,288 $0 $1,057,467 $0 $0 $59,565,222 Territories Grand Total $1,243,233 $6,097,586 $206,776 $19,909,535 $753,055 $1,250,994 $8,040,019 $313,932 $495,116 $10,694,360 $1,081,169 $271,241 $257,867 $550,543 $899,037 $1,169,677 $931,848 $3,062,566 $814,398 $1,417,135 $1,420,180 $118,858 $99,275,371 $134,629 $99,410,000 Heating Degree Day Data January 2004 (from Climate Prediction Center, National Weather Service) All States Alabama............................. Alaska................................ Arizona.............................. Arkansas............................ California........................... Colorado............................ Connecticut........................ Delaware............................ District of Columbia.......... Florida................................ Georgia.............................. Hawaii............................... Idaho.................................. Illinois................................ Indiana............................... Iowa................................... Kansas............................... Kentucky............................ Louisiana........................... Maine................................. Maryland............................ Massachusetts.................... Michigan............................ Minnesota.......................... Mississippi......................... Missouri............................. Montana............................. Nebraska............................ Nevada............................... New Hampshire................. New Jersey......................... New Mexico....................... New York.......................... North Carolina................... North Dakota..................... Ohio................................... Oklahoma........................... Oregon............................... Pennsylvania...................... Rhode Island...................... South Carolina................... South Dakota..................... Tennessee........................... Texas.................................. Utah................................... Vermont............................. Virginia.............................. Washington........................ West Virginia..................... Wisconsin.......................... Wyoming........................... Total HDD 670 1786 427 747 476 1177 1408 1154 1067 188 673 0 1257 1325 1274 1436 1069 1010 435 1617 1172 1472 1426 1754 608 1126 1413 1312 721 1534 1289 853 1389 817 1860 1301 781 831 1334 1330 687 1479 855 431 1352 1693 1041 893 1129 1541 1294 Excess HDD -10 144 -65 -89 -8 -62 231 158 135 -25 -7 0 45 -1 47 -25 -56 7 -54 161 153 263 101 34 -33 -23 32 -13 -43 129 198 -87 201 32 65 102 -115 15 175 217 21 -24 -34 -103 145 205 99 16 68 28 -82 Excess % -1% 9% -13% -11% -2% -5% 20% 16% 14% -12% -1% 0% 4% 0% 4% -2% -5% 1% -11% 11% 15% 22% 8% 2% -5% -2% 2% -1% -6% 9% 18% -9% 17% 4% 4% 9% -13% 2% 15% 19% 3% -2% -4% -19% 12% 14% 11% 2% 6% 2% -6% January Month Sort Month Massachusetts................. Connecticut..................... Rhode Island................... Vermont.......................... New York....................... New Jersey...................... Pennsylvania................... Maine.............................. Delaware......................... Maryland......................... Utah................................ Alaska............................. District of Columbia....... New Hampshire.............. Ohio................................ Michigan......................... Virginia........................... West Virginia.................. North Dakota.................. 1472 1408 1330 1693 1389 1289 1334 1617 1154 1172 1352 1786 1067 1534 1301 1426 1041 1129 1860 HDD Escess 263 231 217 205 201 198 175 161 158 153 145 144 135 129 102 101 99 68 65 HDD Excess % 22% 20% 19% 14% 17% 18% 15% 11% 16% 15% 12% 9% 14% 9% 9% 8% 11% 6% 4% CUT OFF 65 or more excess HDDs for January Indiana............................ Idaho............................... Minnesota....................... Montana.......................... North Carolina................ Wisconsin....................... South Carolina................ Washington..................... Oregon............................ Kentucky......................... Hawaii............................ Illinois............................. Georgia........................... California........................ Alabama.......................... Nebraska......................... Missouri.......................... South Dakota.................. Florida............................. Iowa................................ Mississippi...................... Tennessee........................ Nevada............................ Louisiana........................ Kansas............................ Colorado......................... Arizona........................... Wyoming........................ New Mexico.................... Arkansas......................... Texas............................... Oklahoma........................ 1274 1257 1754 1413 817 1541 687 893 831 1010 0 1325 673 476 670 1312 1126 1479 188 1436 608 855 721 435 1069 1177 427 1294 853 747 431 781 47 45 34 32 32 28 21 16 15 7 0 -1 -7 -8 -10 -13 -23 -24 -25 -25 -33 -34 -43 -54 -56 -62 -65 -82 -87 -89 -103 -115 4% 4% 2% 2% 4% 2% 3% 2% 2% 1% 0% 0% -1% -2% -1% -1% -2% -2% -12% -2% -5% -4% -6% -11% -5% -5% -13% -6% -9% -11% -19% -13% States with 65 or more HDDs in excess of norm for month of January HDD Month 1786 1408 1154 1067 1617 1172 1472 1426 1534 1289 1389 1860 1301 1334 1330 1352 1693 1041 1129 HDD Escess 144 231 158 135 161 153 263 101 129 198 201 65 102 175 217 145 205 99 68 HDD Excess % 9% 20% 16% 14% 11% 15% 22% 8% 9% 18% 17% 4% 9% 15% 19% 12% 14% 11% 6% 19 States Alaska............................. Connecticut..................... Delaware......................... District of Columbia....... Maine.............................. Maryland......................... Massachusetts................. Michigan......................... New Hampshire.............. New Jersey...................... New York....................... North Dakota.................. Ohio................................ Pennsylvania................... Rhode Island................... Utah................................ Vermont.......................... Virginia........................... West Virginia..................