{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["HIPHUD","Appropriations","Milestone","2004","2005","2006","2007","2008","2009","2010","2011","2012","2012Data","Data","2013Data","2014Data","2015Data","2016Data","2017Data","2018Data","2019Data","ChartB","Milestones 14-15","Milestones 14-17","Milestones 15-16","Milestones 18-19 ","Milestones2"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"ChartB","index":21,"reason":"not_a_worksheet"}],"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":"HIPHUD","index":0,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[9,2,9,3],[18,2,18,3]]}
[]
["BIA / HIP",null,"Provides a grant to individuals to obtain standard housing."]
[null,null,1,"Serves the lowest income population strata, only applicants at or below 150% poverty level. Very narrowly"]
[null,null,null,"focused."]
[null,null,2,"HIP Program provides a grant to individuals which provides Standard housing to recipeints, through"]
[null,null,null," either financing the repair of an existing home or the purchase or construction of a new house. "]
[null,null,3," Serves individuals who can not qualify for needed financiing due to extremely low income."]
[null,null,4," Serves individuals who can qualify for needed financiing due to very low income and can obtain financing."]
[]
["HUD / NAHASDA",null,"Provides grants to TDHE's , to promote Housing and Community Development "]
[null,null,1,"Serves broad income range, up to 10% of projects are not income restricted, funds can be used for "]
[null,null,null,"housholds with annual incomes above the local median income, the remainder  of the funds must be used "]
[null,null,null,"for families earning less than 80% of median local income."]
[null,null,2,"No regulation in NAHASDA requires that repairs provided to a housing unit bring the entire house to uniform standard condition."]
[null,null,3,"There is no provision to grant an individual new housing, all existing homeownership programs require ability for mortgage payment. "]
[null,null,4,"HUD encourages leverage and/or repayment provisions."]
[]
[]
["HUD /ICDGB",null,"Provides grants to Tribes, TDHE's, and other eligible organizations, to undertake community development projects,"]
[null,null," including development of affordable Housing, and home repair projects."]
[null,null,1,"Is a competitive Grant, funding is irregular and intermittent …. Funds awarded only to highest rated applicant organizations. Focus on Community development, rather than individual assistance. Funding does not support a continous housing assistance pr"]
[null,null,2,"Regulation does not requires that repairs provided to a housing unit bring the entire house to uniform standard condition."]
[null,null,3,"There is no provision to grant an individual new housing."]
[null,null,4,"HUD encourages leverage of federal, state and local funds."]
[]
["HUD / 184",null,"Provides Guarentee authority for loans to qualified Individuals for home improvements and home purchase."]
[null,null,1,"Serves only individuals in mid to higher income range, with acceptable credit rating."]
[]
["USDA / RHS",null,"Provides low interest Loans and Grants to low income individuals for home repairs.  "]
[null,null,1,"504 Loan / Grant serves individuals who can qualify for the loan.. 62 years and older may also qualify for the grant. Requires loan repayment"]
[null,null,2," Maximum loan limit -$20,000        Maximum Grant limit - $7,500"]
[null,null,3," Does not require that the entire house be made standard"]
[]
[]
[]
[]
[]
[null," "]
[]
[null," "," ","  "]
[" "]

{"sheet":"Appropriations","index":1,"n_rows":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,0,1,16],[2,0,2,16]]}
["Office of Indian Services"]
["Housing Improvement Program"]
["In Thousands of Dollars"]
["Fiscal Year",2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017]
["Annual Appropriation",19634,19493,22901,23020,22216,18716,13800,13600,12600,12620,12619,8000,8009,8009,8021,8021]

{"sheet":"Milestone","index":2,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":true,"merged":[[15,17,16,18],[15,19,16,20],[15,21,16,22],[1,10,1,12],[15,10,16,12],[15,13,16,15],[1,13,1,15],[1,0,2,0],[15,0,16,0],[15,1,16,3],[15,4,16,6],[15,7,16,9],[1,1,1,3],[1,4,1,6],[1,7,1,9]]}
["Workload Data",null,"Greenbook Targets","Percent of Eligible Households Served",null,"Greenbook Targets","Percent of Eligible Households Served",null,"Greenbook Targets","Percent of Eligible Households Served",null,"Greenbook Targets","Percent of Eligible Households Served",null,"Greenbook Targets","Percent of Eligible Households Served"]
["Targets","FY2004",null,null,"FY2005",null,null,"FY 2006        ",null,null,"FY 2007        ",null,null,"FY 2008"]
[null,null,"Estimate","Actual",null,"Estimate","Actual",null,"Estimate","Actual",null,"Estimate","Actual",null,"Estimate","Actual"]
["Renovations",null,132,104,null,132,132,null,132,86,null,{"$f":"SUM(C4+F4+I4)/4.25","v":93.17647058823529},138,null,{"$f":"SUM(F4+I4+L4)/4.25","v":84.041522491349482},68]
["New /Replacement",null,298,189,null,298,182,null,298,162,null,{"$f":"SUM(C5+F5+I5)/4.25","v":210.35294117647058},195,null,{"$f":"SUM(F5+I5+L5)/4.25","v":189.73010380622839},121]
["Total Households Served","Total",430,{"$f":"SUM(C31:D31)","v":293},"Total",430,{"$f":"SUM(G4:G5)","v":314},"Total",430,{"$f":"SUM(J4:J5)","v":248},"Total",{"$f":"SUM(L4:L5)","v":303.52941176470586},{"$f":"SUM(M4:M5)","v":333},"Total",{"$f":"SUM(O4:O5)","v":273.77162629757788},{"$f":"SUM(P4:P5)","v":189}]
[]
["Percentage Targets "]
["Renovations",2309,{"$f":"C4/B9","v":5.7167605023819838E-2},{"$f":"D4/B9","v":4.5041143352100479E-2},2904,4.5454545454545456E-2,{"$f":"G4/E9","v":4.5454545454545456E-2},2649,{"$f":"I4/H9","v":4.9830124575311441E-2},{"$f":"J4/H9","v":3.2465081162702907E-2},{"$f":"SUM(E9+H9)/1.5","v":3702},{"$f":"L4/K9","v":2.5169224902278575E-2},{"$f":"M4/K9","v":3.7277147487844407E-2},{"$f":"SUM(H9+K9)/1.5","v":4234},{"$f":"O4/N9","v":1.9849202288934692E-2},{"$f":"P4/N9","v":1.6060462919225318E-2}]
["New Construction ",3520,{"$f":"C5/B10","v":8.4659090909090906E-2},{"$f":"D5/B10","v":5.369318181818182E-2},4055,7.3489519112207149E-2,{"$f":"G5/E10","v":4.4882860665844633E-2},4459,{"$f":"I5/H10","v":6.6831128055617847E-2},{"$f":"J5/H10","v":3.6331015922852657E-2},{"$f":"SUM(E10+H10)/1.5","v":5676},{"$f":"L5/K10","v":3.7060067155826389E-2},{"$f":"M5/K10","v":3.4355179704016914E-2},{"$f":"SUM(H10+K10)/1.5","v":6756.666666666667},{"$f":"O5/N10","v":2.8080429769052055E-2},{"$f":"P5/N10","v":1.7908238776517021E-2}]
["Total Households Served",{"$f":"SUM(B9:B10)","v":5829},{"$f":"C6/B11","v":7.3769085606450513E-2},{"$f":"D6/B11","v":5.02659118202093E-2},6959,6.1790487138956747E-2,{"$f":"G6/E11","v":4.5121425492168417E-2},7108,{"$f":"I6/H11","v":6.0495216657287562E-2},{"$f":"J6/H11","v":3.4890264490714688E-2},{"$f":"SUM(E11+H11)/1.5","v":9378},{"$f":"L6/K11","v":3.2366113431937071E-2},{"$f":"M6/K11","v":3.5508637236084453E-2},{"$f":"SUM(H11+K11)/1.5","v":10990.666666666666},{"$f":"O6/N11","v":2.4909464967024557E-2},{"$f":"P6/N11","v":1.7196409074366131E-2}]
[]
[]
[]
[]
[null,"FY2004 ",null,null,"FY2005",null,null,"FY2006 ",null,null,"FY2007",null,null,"FY2008",null,null,null,"2004 Percent",null,"2005 Percent",null,"2006 Percent"]
[]
["Region","# of Eligible Households","Number of Eligible Households Category B Served","Number of Eligible Households Category C Served","# of Eligible Households","Number of Eligible Households Category B Served","Number of Eligible Households Category C Served","# of Eligible Households","Number of Eligible Households Category B Served","Number of Eligible Households Category C Served","# of Eligible Households","Number of Eligible Households Category B Served","Number of Eligible Households Category C Served","# of Eligible Households","Number of Eligible Households Category B Served","Number of Eligible Households Category C Served",null,"Number of Eligible Applicants Cat B","Number of Eligible Applicants Cat C","Number of Eligible Applicants Cat B","Number of Eligible ApplicantsCat C","Number of Eligible ApplicantsCat B","Number of Eligible ApplicantsCat C"]
["ALASKA",806,6,31,987,16,26,1153,16,16,668,13,26,1090,7,16,null,306,500,342,645,374,779]
["EASTERN OKLAHOMA",369,13,4,683,24,6,411,11,6,346,15,5,332,8,3,null,26,24,44,23,355,56]
["EASTERN ",50,13,2,67,19,6,76,3,2,81,3,2,75,3,1,null,314,55,655,28,65,11]
["GREAT PLAINS",615,11,31,779,10,28,997,11,30,813,53,30,870,10,17,null,229,386,270,509,315,682]
["MIDWEST",462,9,14,250,12,12,242,3,7,317,2,7,423,0,13,null,136,326,133,117,83,159]
["NAVAJO",633,2,38,1022,2,31,778,0,36,626,0,35,684,1,18,null,19,614,21,1001,11,767]
["NORTHWEST",148,1,3,144,1,3,160,4,3,172,3,3,172,5,1,null,85,63,90,54,90,70]
["PACIFIC",477,4,10,606,4,10,702,6,22,579,4,23,711,6,12,null,100,377,88,518,93,609]
["ROCKY MOUNTAIN",437,22,6,581,14,10,653,15,6,750,13,10,341,10,3,null,137,300,417,164,466,187]
["SOUTHERN PLAINS",541,12,16,486,12,16,548,19,7,576,16,9,597,2,9,null,449,92,391,95,414,134]
["SOUTHWEST",404,5,12,365,5,12,396,1,13,376,1,13,337,2,6,null,182,222,151,214,137,259]
["WESTERN",887,6,22,989,13,22,992,13,30,995,15,32,892,14,22,null,326,561,302,687,246,746]
["TOTAL",5829,104,189,6959,132,182,7108,{"$f":"SUM(I20:I30)","v":86},{"$f":"SUM(J20:J30)","v":162},{"$f":"SUM(K19:K30)","v":6299},138,195,6524,68,121,null,{"$f":"SUM(R19:R30)","v":2309},{"$f":"SUM(S19:S30)","v":3520},2904,4055,2649,4459]
[null,null,"Total Served",293,null,"Total Served",314,null,"Total Served",{"$f":"I31+J31","v":248},null,null,{"$f":"L31+M31","v":333},null,null,{"$f":"O31+P31","v":189},null,null,{"$f":"SUM(R31:S31)","v":5829},null,{"$f":"SUM(T31:U31)","v":6959},null,{"$f":"SUM(V31:W31)","v":7108}]
[]
[]
[]
[]
["Region","93-638","OSG","Subtotal","Total","Cat B","Cat C-1","Cat C-2","Total"]
["ALASKA",2606911,2072450,{"$f":"SUM(B38:C38)","v":4679361},4679361.1877988596,13,19,7,{"$f":"SUM(F38:H38)","v":39}]
["EASTERN OKLAHOMA",266959,640000,906959,906958.56876284606,15,5,0,20]
["EASTERN ",170813,0,170813,170812.94506283308,3,2,0,5]
["GREAT PLAINS",2972305,0,2972305,2972305.4785925783,13,12,18,43]
["MIDWEST",533304,194060,727364,727364.23435210192,2,3,4,9]
["NAVAJO",2703129,0,2703129,2703129.0429238291,0,23,12,35]
["NORTHWEST",434811,0,434811,434810.769717235,3,2,1,6]
["PACIFIC",1956129,585000,2541129,2541128.6583125577,4,12,11,27]
["ROCKY MOUNTAIN",1409200,183609,1592809,1592808.6903091096,13,8,2,23]
["SOUTHERN PLAINS",1274935,0,1274935,1274935.1940520597,16,5,4,25]
["SOUTHWEST",1159690,0,1159690,1159690.2361334485,1,10,3,14]
["WESTERN",2903344,150000,3053344,3053343.9939825428,15,12,20,47]
["TOTAL",{"$f":"SUM(B38:B49)","v":18391530},{"$f":"SUM(C38:C49)","v":3825119},22216649,{"$f":"SUM(E38:E49)","v":22216649},{"$f":"SUM(F38:F49)","v":98},{"$f":"SUM(G38:G49)","v":113},{"$f":"SUM(H38:H49)","v":82},293]
[]
[null,null,null,"OSG"]
["Available BIA HIP",18326535,null,"Available",{"$f":"B54","v":3890114}]
["Available OSG HIP",3890114,null,"Obligated",{"$f":"C50","v":3825119}]
["Total Amount Available",{"$f":"SUM(B53:B54)","v":22216649},null,"Balance",{"$f":"E53-E54","v":64995}]

{"sheet":"2004","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,"# of Eligible Cat B","# of Eligible Cat C-1","# of Eligible Cat C-2","Total # Cat C","# of Eligible Applicants","Cost of Cat B Need","Total Cost Estimate of Need","AMT AVAILABLE FOR DISTR. W/in REGION",35000]
["ALASKA",306,309,191,500,806,{"$f":"B2*43750","v":13387500},138216871,4148068]
["EASTERN OKLAHOMA",314,53,2,55,369,{"$f":"B3*$J$1","v":10990000},17553346,1050583]
["EASTERN ",26,20,4,24,50,{"$f":"B4*$J$1","v":910000},4381323,179520]
["GREAT PLAINS",229,313,73,386,615,8015000,59523260,2312622]
["MIDWEST",136,77,246,323,462,4760000,51284576,1850929]
["NAVAJO",19,137,477,614,633,665000,86627456,2850929]
["NORTHWEST",85,57,6,63,148,2975000,12256523,518164]
["PACIFIC",100,163,214,377,477,3500000,66478078,2170590]
["ROCKY MOUNTAIN",276,137,24,161,437,9660000,31342228,1440030]
["SOUTHERN PLAINS",449,58,34,92,541,15715000,26649958,1557256]
["SOUTHWEST",182,128,94,222,404,6370000,35994992,1461542]
["WESTERN",326,128,433,561,887,11410000,86763301,3352406]
["TOTAL",2448,1580,1798,3378,5829,{"$f":"SUM(G2:G13)","v":88357500},617071912,22892639]
["TOTAL AMOUNT AVAILABLE THIS FY:",null,null,null,null,null,null,null,{"$f":"SUM(I16:I17)","v":22900903}]
["Available from BIA HIP:",null,null,null,null,null,null,null,18948499]
["Available from BIA OSG:",null,null,null,null,null,null,null,3952404]

{"sheet":"2005","index":4,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,"# of Eligible Cat B","# of Eligible Cat C-1","# of Eligible Cat C-2","Total # Cat C","# of Eligible Applicants","Cost of Cat B Need","Total Cost Estimate of Need","AMT AVAILABLE FOR DISTR. W/in REGION",35000]
["ALASKA",342,358,287,645,987,{"$f":"B2*43750","v":14962500},175542016,4345306.3313002735]
["EASTERN OKLAHOMA",655,27,1,28,683,{"$f":"B3*$J$1","v":22925000},26178989,1534264.5434820696]
["EASTERN ",44,18,5,23,67,{"$f":"B4*$J$1","v":1540000},4936199,187102.62181768107]
["GREAT PLAINS",270,309,200,509,779,9450000,77535261,2486697.6668240926]
["MIDWEST",133,76,41,117,250,4655000,21058586,738940.94649018208]
["NAVAJO",21,438,563,1001,1022,735000,140879004,3867524.1865393957]
["NORTHWEST",90,46,8,54,144,3150000,11169575,410791.7605231746]
["PACIFIC",88,164,354,518,606,3080000,89340364,2382983.7599811]
["ROCKY MOUNTAIN",417,130,34,164,581,14595000,36657613,1527487.581479368]
["SOUTHERN PLAINS",391,68,27,95,486,13685000,24936335,1189217.3305096654]
["SOUTHWEST",151,190,24,214,365,5285000,33644094,1123647.3468688538]
["WESTERN",302,129,558,687,989,10570000,102950297,3226800.924184144]
["TOTAL",2904,1953,2102,4055,6959,{"$f":"SUM(G2:G13)","v":104632500},744828333,23020765]
["TOTAL AMOUNT AVAILABLE THIS FY:",35000,null,null,null,null,null,null,23020765]
["Available from BIA HIP:",null,null,null,null,null,null,null,19068361]
["Available from BIA OSG:",null,null,null,null,null,null,null,3952404]

{"sheet":"2006","index":5,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,"# of Eligible Cat B","# of Eligible Cat C-1","# of Eligible Cat C-2","Total # Cat C","# of Eligible Applicants","Cost of Cat B Need","Total Cost Estimate of Need","AMT AVAILABLE FOR DISTR. W/in REGION",35000]
["ALASKA",374,446,333,779,1153,{"$f":"B2*43750","v":16362500},208500867,4679361.1877988586]
["EASTERN OKLAHOMA",355,55,1,56,411,{"$f":"B3*$J$1","v":12425000},19176616,906958.56876284606]
["EASTERN ",65,11,0,11,76,{"$f":"B4*$B$15","v":2275000},3770873,170812.94506283308]
["GREAT PLAINS",315,258,424,682,997,11025000,102473056,2972305.4785925783]
["MIDWEST",83,59,100,159,242,2905000,25300752,727364.23435210204]
["NAVAJO",11,363,404,767,778,385000,107768068,2703129.0429238291]
["NORTHWEST",89,62,8,70,160,3115000,13388002,434810.769717235]
["PACIFIC",97,202,428,630,702,3395000,104635753,2541128.6583125577]
["ROCKY MOUNTAIN",417,130,34,164,653,14595000,41469256,1592808.6903091096]
["SOUTHERN PLAINS",414,89,45,134,548,14490000,30326334,1274935.1940520597]
["SOUTHWEST",134,172,80,252,396,4690000,39188147,1159690.2361334485]
["WESTERN",246,164,582,746,992,8610000,108911305,3053343.9939825428]
["TOTAL",2600,2011,2439,4450,7108,{"$f":"SUM(G2:G13)","v":94272500},804909029,22216649]
["TOTAL AMOUNT AVAILABLE THIS FY:",35000,null,null,null,null,null,null,{"$f":"SUM(I16+I17-I18)","v":22216649}]
["Available from BIA HIP:",null,null,null,null,null,null,null,18326535]
["Available from BIA OSG:",null,null,null,null,null,null,null,3890114]

{"sheet":"2007","index":6,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"# of Eligible Cat B","# of Eligible Cat C-1","# of Eligible Cat C-2","Total # Cat C","# of Eligible Applicants","Cost of Cat B Need","Total Cost Estimate of Need","AMT AVAILABLE FOR DISTR. W/in REGION",35000]
["ALASKA",235,272,161,433,668,{"$f":"B2*43750","v":10281250},117067863,3289626.427845235]
["EASTERN OKLAHOMA",71,8,2,10,346,{"$f":"B3*$J$1","v":2485000},12719070,858548.47715868196]
["EASTERN ",339,7,0,7,81,{"$f":"B4*$J$1","v":11865000},3840110,216206.19264277798]
["GREAT PLAINS",260,289,264,553,813,9100000,83111242,2956329.8830505498]
["MIDWEST",154,128,35,163,317,5390000,28414459,1082291.928984649]
["NAVAJO",2,298,326,624,626,70000,87432496,2689824.80522695]
["NORTHWEST",102,54,16,70,172,3570000,13823785,559124.55590804899]
["PACIFIC",61,139,379,518,579,2135000,88234061,2617822.6890456397]
["ROCKY MOUNTAIN",589,135,26,161,750,20615000,42304624,2120957.2509216177]
["SOUTHERN PLAINS",460,80,36,116,576,16100000,29766889,1580855.3232781845]
["SOUTHWEST",123,175,78,253,376,4305000,37952969,1358706.0685099436]
["WESTERN",242,150,603,753,995,8470000,109743642,3759750.3974277247]
["TOTAL",2638,1735,1926,3661,6299,{"$f":"B14*$B$15","v":92330000},654411210,23090044]
["TOTAL AMOUNT AVAILABLE THIS FY:",35000,null,null,null,null,null,null,{"$f":"SUM(I16+I17)","v":23090044}]
["Available from BIA HIP:",null,null,null,null,null,null,null,18824000]
["Available from BIA OSG:",null,null,null,null,null,null,null,4266044]

{"sheet":"2008","index":7,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"# of Eligible Cat B","# of Eligible Cat C-1","# of Eligible Cat C-2","Total # Cat C","# of Eligible Applicants","Cost of Cat B Need","Total Cost Estimate of Need","AMT AVAILABLE FOR DISTR. W/in REGION",35000]
["ALASKA",365,500,225,725,1090,{"$f":"$B$2*43750","v":15968750},194743291,2913515.6980605558]
["EASTERN OKLAHOMA",320,12,0,12,332,{"$f":"B3*$J$1","v":11200000},12613857,459568.11393205589]
["EASTERN ",43,29,3,32,75,{"$f":"B4*$J$1","v":1505000},5740043,130298.84936744836]
["GREAT PLAINS",247,387,236,623,870,8645000,92029335,1744572.3646438404]
["MIDWEST",191,164,68,232,423,6685000,39351037,798805.11573501094]
["NAVAJO",2,126,556,682,684,70000,95552728,1584122.5513737828]
["NORTHWEST",102,54,16,70,172,3570000,13823785,304864.66887444892]
["PACIFIC",105,164,442,606,711,3675000,104798041,1696797.5881325]
["ROCKY MOUNTAIN",250,83,8,91,341,8750000,20981749,545553.77064891404]
["SOUTHERN PLAINS",470,72,31,103,597,16450000,29853424,892089.70285772101]
["SOUTHWEST",123,175,78,253,337,4305000,31406805,636915.29325335333]
["WESTERN",224,137,531,668,892,7840000,96998989,1812896.2831203686]
["TOTAL",2442,1903,2194,4097,6524,{"$f":"SUM(G2:G13)","v":88663750},737893084,13520000]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I16+I18+I19)","v":13520000}]
[null,null,null,null,null,null,null,null,13520000]
[null,null,null,null,null,null,null,null,0]

{"sheet":"2009","index":8,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,"# of Eligible Cat B","# of Eligible Cat C-1","# of Eligible Cat C-2","Total # Cat C","# of Eligible Applicants","Cost of Cat B Need","Total Cost Estimate of Need","AMT AVAILABLE FOR DISTR. W/in REGION",35000]
["ALASKA",459,null,null,797,1256,0.23896164424065752,217965315,2913515.6980605558]
["EASTERN OKLAHOMA",33,null,null,2,35,3.5929295054358658E-3,1393656,459568.11393205589]
["EASTERN ",37,null,null,58,95,1.2931526050217612E-2,8635880,130298.84936744836]
["GREAT PLAINS",350,null,null,677,1027,0.14598985487757032,102812242,1744572.3646438404]
["MIDWEST",153,null,null,219,372,5.220719120490315E-2,36212939,798805.11573501094]
["NAVAJO",0,null,null,510,510,8.5826356455141278E-2,71402040,1584122.5513737828]
["NORTHWEST",173,null,null,79,252,3.0827743801785934E-2,17603572,304864.66887444892]
["PACIFIC",104,null,null,607,847,0.14456392802364643,121674285,1696797.5881325]
["ROCKY MOUNTAIN",224,null,null,139,363,4.5162140192916242E-2,26510791,545553.77064891404]
["SOUTHERN PLAINS",442,null,null,162,600,6.5096173138724706E-2,29238628,892089.70285772101]
["SOUTHWEST",82,null,null,201,283,4.0974391523063702E-2,29468830,636915.29325335333]
["WESTERN",105,null,null,705,890,0.13386612098593725,100318461,1812896.2831203686]
["TOTAL",{"$f":"SUM(B2:B13)","v":2162},null,null,{"$f":"SUM(E2:E13)","v":4156},{"$f":"SUM(F2:F13)","v":6530},1,763236639,13520000]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I16+I18+I19)","v":13520000}]
[null,null,null,null,null,null,null,null,13520000]
[null,null,null,null,null,null,null,null,0]

{"sheet":"2010","index":9,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"# of Eligible Cat B","# of Eligible Cat C-1","# of Eligible Cat C-2","Total # Cat C","# of Eligible Applicants","Cost of Cat B Need","Total Cost Estimate of Need","AMT AVAILABLE FOR DISTR. W/in REGION",35000]
["ALASKA",474,630,257,{"$f":"SUM(C2:D2)","v":887},1361,0.23896164424065752,239427319,2913515.6980605558]
["EASTERN OKLAHOMA",54,11,0,{"$f":"SUM(C3:D3)","v":11},65,3.5929295054358658E-3,3226746,459568.11393205589]
["EASTERN ",44,18,12,30,74,1.2931526050217612E-2,5092291,130298.84936744836]
["GREAT PLAINS",258,258,763,1021,1279,0.14598985487757032,145810290,1744572.3646438404]
["MIDWEST",93,47,24,71,164,5.220719120490315E-2,13414740,798805.11573501094]
["NAVAJO",0,287,297,584,583,8.5826356455141278E-2,81762336,1584122.5513737828]
["NORTHWEST",231,73,32,105,336,3.0827743801785934E-2,23408606,304864.66887444892]
["PACIFIC",126,220,499,719,845,0.14456392802364643,121802512,1696797.5881325]
["ROCKY MOUNTAIN",264,226,19,245,509,4.5162140192916242E-2,48146348,545553.77064891404]
["SOUTHERN PLAINS",413,138,16,154,567,6.5096173138724706E-2,32496205,892089.70285772101]
["SOUTHWEST",57,103,68,171,228,4.0974391523063702E-2,24511942,636915.29325335333]
["WESTERN",289,92,592,684,973,0.13386612098593725,99287714,1812896.2831203686]
["TOTAL",{"$f":"SUM(B2:B13)","v":2303},{"$f":"SUM(C2:C13)","v":2103},{"$f":"SUM(D2:D13)","v":2579},{"$f":"SUM(E2:E13)","v":4682},{"$f":"SUM(F2:F13)","v":6984},1,838387049,13520000]
["TOTAL AMOUNT AVAILABLE THIS FY:",13520000,null,null,null,null,null,null,13520000]
[null,null,null,null,null,null,null,null,13520000]
[null,null,null,null,null,null,null,null,0]

{"sheet":"2011","index":10,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Item","# of Eligible Cat B","# of Eligible Cat C-1","# of Eligible Cat C-2","Total # Cat C","# of Eligible Applicants","Cost of Cat B Need","Total Cost Estimate of Need","AMT AVAILABLE FOR DISTR. W/in REGION",35000]
["ALASKA",477,665,309,{"$f":"SUM(C2:D2)","v":974},1451,{"$f":"B2*43750","v":20868750},261418632,2913515.6980605558]
["EASTERN OKLAHOMA",141,4,0,{"$f":"SUM(C3:D3)","v":4},145,{"$f":"B3*J$1","v":4935000},5179020,459568.11393205589]
["EASTERN ",27,37,4,41,68,{"$f":"B4*J$1","v":945000},10243571,130298.84936744836]
["GREAT PLAINS",366,634,90,724,1090,12810000,109761354,1744572.3646438404]
["MIDWEST",218,49,37,86,304,7630000,27783626,798805.11573501094]
["NAVAJO",0,350,316,666,666,0,93242664,1584122.5513737828]
["NORTHWEST",235,77,27,104,339,8225000,23421011,304864.66887444892]
["PACIFIC",147,217,431,648,795,5145000,172267790,1696797.5881325]
["ROCKY MOUNTAIN",510,195,23,218,728,17850000,47192944,545553.77064891404]
["SOUTHERN PLAINS",409,134,16,150,559,14315000,31893548,892089.70285772101]
["SOUTHWEST",58,117,76,193,251,2030000,27481850,636915.29325335333]
["WESTERN",222,64,643,707,929,7770000,153495146,1812896.2831203686]
["TOTAL",2810,2543,1972,4515,7325,{"$f":"SUM(G2:G13)","v":102523750},963381156,13520000]
["TOTAL AMOUNT AVAILABLE THIS FY:",null,null,null,null,null,null,null,13520000]
[null,null,null,null,null,null,null,null,13520000]
[null,null,null,null,null,null,null,null,0]

{"sheet":"2012","index":11,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"# of Eligible Cat B","# of Eligible Cat C-1","# of Eligible Cat C-2","Total # Cat C","# of Eligible Applicants","Cost of Cat B Need","Total Cost Estimate of Need","AMT AVAILABLE FOR DISTR. W/in REGION",35000]
["ALASKA",536,781,335,{"$f":"SUM(C2:D2)","v":1116},1652,{"$f":"B2*43750","v":23450000},265572685.5,3305561.0961207086]
["EASTERN OKLAHOMA",78,10,17,{"$f":"SUM(C3:D3)","v":27},105,{"$f":"B3*J$1","v":2730000},3395000,174300.92205671969]
["EASTERN ",194,0,0,0,194,{"$f":"B4*J$1","v":6790000},4710852.5,116450.86423407936]
["GREAT PLAINS",540,647,266,913,1453,18900000,114287656.5,1989309.6863946454]
["MIDWEST",237,44,26,70,307,8295000,14261138,344231.86670423945]
["NAVAJO",0,364,329,693,693,0,87445165.5,1202261.0761450029]
["NORTHWEST",50,59,8,67,117,1750000,10026689,166525.84359628623]
["PACIFIC",143,253,462,715,858,5005000,113772566.5,1530895.415469774]
["ROCKY MOUNTAIN",535,203,29,232,767,18725000,37036834,870848.67360054213]
["SOUTHERN PLAINS",409,134,16,150,559,14315000,22540621,600422.12770870572]
["SOUTHWEST",47,59,60,119,166,1645000,15124000.5,243179.03009442339]
["WESTERN",216,98,498,596,812,7560000,74338695.5,1192286.3978748729]
["TOTAL",2985,2652,2046,4698,7683,{"$f":"SUM(G2:G13)","v":109165000},762511904.5,11736272.999999998]
["TOTAL AMOUNT AVAILABLE THIS FY:",null,null,null,null,null,null,null,11736273]
[null,null,null,null,null,null,null,null,13520000]
[null,null,null,null,null,null,null,null,0]

{"sheet":"2012Data","index":12,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["2012 Estimated Total Need in # of applicants and Associated Cost"]
["Item","# of Eligible    Cat B"," #  of Eligible    Cat C","# of Eligible Applicants","Cost of              Cat B Need","Cost of               Cat C Need","Total Estimate    of Need","2012 AMT AVAILABLE FOR DISTR. W/in REGION","Percentage of Funding to Need"]
["ALASKA",536,1116,1652,23450000,{"$f":"G3-E3","v":242122685.5},{"$f":"(531145371)/2","v":265572685.5},3295555.359381312,{"$f":"H3/H$15","v":0.28165339167900311}]
["EASTERN OKLAHOMA",78,27,105,2730000,{"$f":"G4-E4","v":665000},{"$f":"(6790000)/2","v":3395000},173773.32353749088,{"$f":"H4/H$15","v":1.4851471336489844E-2}]
["EASTERN ",194,0,194,6790000,-2079147.5,{"$f":"(9421705)/2","v":4710852.5},116098.37439749191,9.9223036337071704E-3]
["GREAT PLAINS",540,913,1453,18900000,95387656.5,{"$f":"(228575313)/2","v":114287656.5},1983288.1643484924,0.16950097244624809]
["MIDWEST",237,70,307,8295000,5966138,{"$f":"(28522276)/2","v":14261138},343189.8973273625,2.9330594704489191E-2]
["NAVAJO",0,693,693,0,87445165.5,{"$f":"(174890331)/2","v":87445165.5},1198621.9034084748,0.10243976738995444]
["NORTHWEST",50,67,117,1750000,8276689,{"$f":"(20053378)/2","v":10026689},166021.77977689842,1.4188988582345198E-2]
["PACIFIC",143,715,858,5005000,108767566.5,{"$f":"(227545133)/2","v":113772566.5},1526261.4861436102,0.1304413603423995]
["ROCKY MOUNTAIN",535,232,767,18725000,18311834,{"$f":"(74073668)/2","v":37036834},868212.666485706,7.420146699046129E-2]
["SOUTHERN PLAINS",409,150,559,14315000,8225621,{"$f":"(45081242)/2","v":22540621},598604.68565645861,5.1159522934470396E-2]
["SOUTHWEST",47,119,166,1645000,13479000.5,{"$f":"(30248001)/2","v":15124000.5},242442.94164078022,2.0720294261595943E-2]
["WESTERN",216,596,812,7560000,66778695.5,{"$f":"(148677391)/2","v":74338695.5},1188677.417895922,0.10158986569883584]
["TOTAL",2985,4698,7683,109165000,653346904.5,{"$f":"(1525023809)/2","v":762511904.5},11700748]

{"sheet":"Data","index":13,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
["Item","# of Eligible Cat B","Total # Cat C","# of Eligible Applicants","Cost of Cat B Estimate Need","Total Cat B & C Estimate of Need"]
["ALASKA",365,725,1090,20868750,261418632]
["EASTERN OKLAHOMA",320,12,332,4935000,5179020]
["EASTERN ",43,32,75,945000,10243571]
["GREAT PLAINS",247,623,870,12810000,109761354]
["MIDWEST",191,232,423,7630000,27783626]
["NAVAJO",2,682,684,0,93242664]
["NORTHWEST",102,70,172,8225000,23421011]
["PACIFIC",105,606,711,5145000,172267790]
["ROCKY MOUNTAIN",250,91,341,17850000,47192944]
["SOUTHERN PLAINS",470,103,597,14315000,31893548]
["SOUTHWEST",123,253,337,2030000,27481850]
["WESTERN",224,668,892,7770000,153495146]
["TOTAL",2442,4097,6524,102523750,963381156]

{"sheet":"2013Data","index":14,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["2013 Estimated Total Need in # of applicants and Associated Cost"]
["Item","# of Eligible    Cat B"," #  of Eligible    Cat C","# of Eligible Applicants","Cost of              Cat B Need","Cost of               Cat C Need","Total Estimate    of Need","2013 AMT AVAILABLE FOR DISTR. W/in REGION","Percentage of Funding to Need"]
["ALASKA",590,1364,1954,25812500,312682370,{"$f":"SUM(E3:F3)","v":338494870},3402980.7372984025,{"$f":"H3/G3","v":1.0053271227709899E-2}]
["EASTERN OKLAHOMA",198,8,206,6930000,785981,{"$f":"SUM(E4:F4)","v":7715981},164146.5205108774,{"$f":"H4/G4","v":2.1273577593163773E-2}]
["EASTERN ",74,32,106,2590000,4081703.5,6671703.5,105101.98149762221,1.5753395140779593E-2]
["GREAT PLAINS",528,1347,1875,18480000,155541447,174021447,2309985.2719495189,1.3274141272653129E-2]
["MIDWEST",232,103,335,8120000,14109713,22229713,339780.32672277599,1.5284962370984097E-2]
["NAVAJO",0,702,702,0,88580817,88580817,1038843.9942003498,1.1727640694489753E-2]
["NORTHWEST",89,84,173,3115000,11484556.5,14599556.5,199145.60941359252,1.3640524588099133E-2]
["PACIFIC",131,383,514,4585000,58920925,63505925,737048.67565953208,1.1605982837971924E-2]
["ROCKY MOUNTAIN",527,84,680,18445000,18020692,36465692,627331.15055013122,1.7203324992437583E-2]
["SOUTHERN PLAINS",407,153,564,14245000,16117229,30362229,524482.59504693199,1.7274179542184864E-2]
["SOUTHWEST",47,157,166,1645000,14301500.5,15946500.5,207974.98476925443,1.3042045480088527E-2]
["WESTERN",166,835,1001,5810000,76585683.523809522,82395683.523809522,1321983.1523810108,1.6044325331666227E-2]
["TOTAL",{"$f":"SUM(B3:B14)","v":2989},{"$f":"SUM(C3:C14)","v":5252},{"$f":"SUM(D3:D14)","v":8276},{"$f":"SUM(E3:E14)","v":109777500},{"$f":"SUM(F3:F14)","v":771212618.02380955},880990118.02380955,10978805,1.2461893471208366E-2]

{"sheet":"2014Data","index":15,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["2014 Estimated Total Need in # of applicants and Associated Cost"]
["Item","# of Eligible    Cat B"," #  of Eligible    Cat C","# of Eligible Applicants","Cost of              Cat B Need","Cost of               Cat C Need","Total Estimate    of Need","2014 AMT AVAILABLE FOR DISTR. W/in REGION","Percentage of Funding to Need"]
["ALASKA",351,759,1110,15356250,174130840.5,{"$f":"SUM(E3:F3)","v":189487090.5},1566302.8497911547,{"$f":"H3/G3","v":8.2660135086677824E-3}]
["EASTERN OKLAHOMA",93,13,106,3255000,1275536,{"$f":"SUM(E4:F4)","v":4530536},71358.132017430267,{"$f":"H4/G4","v":1.5750483390360493E-2}]
["EASTERN ",157,8,165,5495000,1148812,6643812,107708.51699176872,1.6211855030179769E-2]
["GREAT PLAINS",488,1169,1657,17080000,135041367.5,152121367.5,1646702.3042763483,1.0824924409625415E-2]
["MIDWEST",167,93,260,5845000,12848555,18693555,221824.50559318272,1.1866362796866767E-2]
["NAVAJO",0,802,802,0,101199167,101199167,968525.52952335821,9.5704891476365433E-3]
["NORTHWEST",56,51,107,1960000,6877949,8837949,98687.219031288972,1.1166303294043558E-2]
["PACIFIC",172,438,610,6020000,68146402,74166402,705199.4165615224,9.5083406710429665E-3]
["ROCKY MOUNTAIN",555,173,728,19425000,20811953,40236953,547351.54867442988,1.3603205706814576E-2]
["SOUTHERN PLAINS",390,148,538,13650000,15180486,28830486,401510.44225755014,1.3926592921727026E-2]
["SOUTHWEST",25,161,186,875000,19266287.5,20141287.5,204246.25803811284,1.0140675368350352E-2]
["WESTERN",90,742,832,3150000,87216323,90366323,917155.27724385285,1.0149303930888644E-2]
["TOTAL",{"$f":"SUM(B3:B14)","v":2544},4557,{"$f":"SUM(D3:D14)","v":7101},{"$f":"SUM(E3:E14)","v":92111250},{"$f":"SUM(F3:F14)","v":643143678.5},735254928.5,7456572,1.0141478432809988E-2]

{"sheet":"2015Data","index":16,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["2015 Estimated Total Need in # of Applicants and Associated Cost"]
["Item","# of Eligible    Cat B"," #  of Eligible    Cat C-1"," #  of Eligible    Cat C-2","# of Eligible Applicants","Cost of              Cat B Need","Cost of               Cat C Need","Total Estimate    of Need","2015 AMT AVAILABLE FOR DISTR. W/in REGION","Percentage of Funding to Need"]
["ALASKA",273,312,227,812,11943750,135860244.5,{"$f":"SUM(F3:G3)","v":147803994.5},1136437.5324027832,{"$f":"I3/H3","v":7.688814745820575E-3}]
["EASTERN OKLAHOMA",64,5,0,69,2240000,559295.5,{"$f":"SUM(F4:G4)","v":2799295.5},43266.038271790821,{"$f":"I4/H4","v":1.5456045377056771E-2}]
["EASTERN ",129,16,16,161,4515000,4094995,{"$f":"SUM(F5:G5)","v":8609995},113462.33462052836,1.3177979153359365E-2]
["GREAT PLAINS",612,1128,409,2149,21420000,196505735.5,{"$f":"SUM(F6:G6)","v":217925735.5},2143571.1533921994,9.8362460425983032E-3]
["MIDWEST",28,9,15,52,980000,3361129,4341129,45892.705659476538,1.0571606063647623E-2]
["NAVAJO",3,580,270,853,105000,107255975,107360975,979613.00631335122,9.1244794145484542E-3]
["NORTHWEST",61,10,14,85,2135000,3044937,5179937,63800.854057910139,1.2316916992988551E-2]
["PACIFIC",215,228,287,730,7525000,79122621.5,86647621.5,792365.70219404472,9.1446907425386716E-3]
["ROCKY MOUNTAIN",693,154,11,858,24255000,19936396,44191396,595465.56841741013,1.3474694676253498E-2]
["SOUTHERN PLAINS",401,135,20,556,14035000,15888828.5,29923828.5,396809.56534334511,1.3260654977465371E-2]
["SOUTHWEST",25,104,57,186,875000,19266287.5,20141287.5,194619.79500072752,9.6627286116007984E-3]
["WESTERN",93,135,537,765,3255000,79231361,82486361,799522.74432643282,9.6927872030435781E-3]
["TOTAL",{"$f":"SUM(B3:B14)","v":2597},2816,1863,{"$f":"SUM(E3:E14)","v":7276},{"$f":"SUM(F3:F14)","v":93283750},{"$f":"SUM(G3:G14)","v":664127806},757411556,7304827,9.6444620393407367E-3]

{"sheet":"2016Data","index":17,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["2016 Estimated Total Need in # of Applicants and Associated Cost"]
["Item","# of Eligible Cat A","# of Eligible Cat B"," #  of Eligible Cat C-1"," #  of Eligible Cat C-2","# of Eligible Applicants","Cost of Cat B Need","Cost of Cat C Need","Total Estimate of Need","2017 REGION DISTR AMT REGION","Percentage of Funding to Need",0.05,0.1,7.4999999999999997E-2,{"$f":"L2*I15","v":35758275.700000003},{"$f":"N2*I15","v":53637413.549999997},{"$f":"M2*I15","v":71516551.400000006}]
["ALASKA",23,272,419,362,{"$f":"SUM(B3:E3)","v":1076},11900000,190366248,{"$f":"SUM(G3:H3)","v":202266248},1582255.4866198059,{"$f":"J3/I3","v":7.8226372529528795E-3}]
["EASTERN OKLAHOMA",20,96,5,0,{"$f":"SUM(B4:E4)","v":121},1920000,562562,{"$f":"SUM(G4:H4)","v":2482562},85760.299512780315,{"$f":"J4/I4","v":3.4545078637625293E-2}]
["EASTERN ",0,55,1,0,56,3300000,165273,3465273,40511.399627292296,1.1690680540116839E-2]
["GREAT PLAINS",0,741,965,228,1934,44460000,153713008,198173008,1940732.8020828061,9.7931238046445063E-3]
["MIDWEST",4,8,7,11,30,280000,3650795,3930795,32780.776244960412,8.339477445392195E-3]
["NAVAJO",0,9,487,289,785,540000,36467031.5,37007031.5,967019.20770652348,2.6130688372195524E-2]
["NORTHWEST",0,20,3,2,25,376564.5,225788,602352.5,17117.96247345649,2.8418513201914974E-2]
["PACIFIC",0,297,259,308,864,17820000,87825152,105645152,1005231.44033206,9.5151686689045611E-3]
["ROCKY MOUNTAIN",5,334,35,9,383,20040000,5300485,25340485,295871.62414449343,1.1675846936019316E-2]
["SOUTHERN PLAINS",0,355,127,20,502,12600000,15173329,27773329,417560.98442515364,1.5034603321235046E-2]
["SOUTHWEST",0,44,15,14,73,2640000,3562680,{"$f":"SUM(G13:H13)","v":6202680},66909.482479058875,1.0787189163242158E-2]
["WESTERN",1,140,118,616,875,8400000,93876598,102276598,1016309.5343516089,9.9368726984017299E-3]
["TOTAL",{"$f":"SUM(B3:B14)","v":53},2371,2441,1859,{"$f":"SUM(F3:F14)","v":6724},{"$f":"SUM(G3:G14)","v":124276564.5},{"$f":"SUM(H3:H14)","v":590888949.5},715165514,7304827,1.0214176798239744E-2]

{"sheet":"2017Data","index":18,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["2017 Estimated Total Need in # of Applicants and Associated Cost"]
["Item","Eligible Cat A","Eligible Cat B"," Eligible Cat C-1"," Eligible Cat C-2","Eligible Applicants","Cost of Cat A & B Need","Cost of Cat C Need","Total Estimate of Need","2017 REGION DISTR AMT REGION","Percentage of Funding to Need",0.05,0.1,7.4999999999999997E-2,{"$f":"L2*I15","v":42791677.5},{"$f":"N2*I15","v":64187516.25},{"$f":"M2*I15","v":85583355}]
["ALASKA",9,175,402,303,{"$f":"SUM(B3:E3)","v":889},13215000,199068603,{"$f":"SUM(G3:H3)","v":212283603},1735939,{"$f":"J3/I3","v":8.1774521228566103E-3}]
["EASTERN OKLAHOMA",1,49,3,1,{"$f":"SUM(B4:E4)","v":54},2947500,788674,{"$f":"SUM(G4:H4)","v":3736174},43847,{"$f":"J4/I4","v":1.17358024545966E-2}]
["EASTERN ",0,67,6,4,77,4020000,2098082,6118082,64814,1.059384297235637E-2]
["GREAT PLAINS",0,749,912,97,1758,44940000,232604669,277544669,1879404,6.7715370169837419E-3]
["MIDWEST",5,49,20,22,96,2977500,6419173,9396673,104542,1.1125427052745157E-2]
["NAVAJO",1,8,377,344,730,487500,90978304,91465804,990253,1.0826483305170531E-2]
["NORTHWEST",1,12,5,0,18,22500,706115,728615,15143,2.0783266883058954E-2]
["PACIFIC",0,323,250,311,884,19380000,85897013,105277013,1094655,1.0397853898077446E-2]
["ROCKY MOUNTAIN",1,444,83,8,536,26647500,11209399,37856899,470586,1.2430653657078463E-2]
["SOUTHERN PLAINS",0,353,128,20,501,21180000,30346658,51526658,455685,8.8436746664221841E-3]
["SOUTHWEST",0,27,24,28,79,1620000,12667486,{"$f":"SUM(G13:H13)","v":14287486},89718,6.2794812187392524E-3]
["WESTERN",0,142,70,241,453,8550000,37061874,45611874,519722,1.1394445227135373E-2]
["TOTAL",{"$f":"SUM(B3:B14)","v":18},2398,2280,1379,{"$f":"SUM(F3:F14)","v":6075},{"$f":"SUM(G3:G14)","v":145987500},{"$f":"SUM(H3:H14)","v":709846050},855833550,{"$f":"SUM(J3:J14)","v":7464308},8.7216819205089592E-3]

{"sheet":"2018Data","index":19,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["2018 Estimated Total Need in # of Applicants and Associated Cost"]
["Item","Eligible Cat A","Eligible Cat B"," Eligible Cat C-1"," Eligible Cat C-2","Eligible Applicants","Cost of Cat A & B Need","Cost of Cat C Need","Total Estimate of Need","2018 REGION DISTR AMT TO REGION","Percentage of Funding to Need",0.05,0.1,7.4999999999999997E-2,{"$f":"L2*I15","v":45345731.300000004},{"$f":"N2*I15","v":68018596.950000003},{"$f":"M2*I15","v":90691462.600000009}]
["ALASKA",0,285,377,862,{"$f":"SUM(B3:E3)","v":1524},21375000,347243380,{"$f":"SUM(G3:H3)","v":368618380},2426454,{"$f":"J3/I3","v":6.5825637885989297E-3}]
["EASTERN OKLAHOMA",6,89,2,0,{"$f":"SUM(B4:E4)","v":97},5385000,195822,{"$f":"SUM(G4:H4)","v":5580822},64276,{"$f":"J4/I4","v":1.15172997812867E-2}]
["EASTERN ",22,29,2,3,56,2506357,821679,3328036,36593,1.0995373848119432E-2]
["GREAT PLAINS",0,808,1003,66,1877,48480000,123270905,171750905,1659022,9.6594658409514637E-3]
["MIDWEST",1,50,13,7,71,3007500,3073010,6080510,58209,9.5730456820233827E-3]
["NAVAJO",0,1,495,376,872,60000,109905829,109965829,958404,8.7154710578319743E-3]
["NORTHWEST",4,0,19,6,29,90000,3197036,3287036,29929,9.1051634359952255E-3]
["PACIFIC",1,286,248,334,869,17167500,85746657,102914157,885428,8.6035587892927118E-3]
["ROCKY MOUNTAIN",1,495,52,6,554,29707500,7001921,36709421,391374,1.0661404874786775E-2]
["SOUTHERN PLAINS",0,368,126,21,515,22080000,15081010,37161010,390143,1.0498718953010158E-2]
["SOUTHWEST",0,26,27,28,81,1560000,6691585,{"$f":"SUM(G13:H13)","v":8251585},76606,9.2837921441759376E-3]
["WESTERN",1,183,61,301,546,10987500,42279435,53266935,507068,9.5193763260454159E-3]
["TOTAL",{"$f":"SUM(B3:B14)","v":36},2620,2425,2010,{"$f":"SUM(F3:F14)","v":7091},{"$f":"SUM(G3:G14)","v":162406357},{"$f":"SUM(H3:H14)","v":744508269},906914626,{"$f":"SUM(J3:J14)","v":7483506},8.2516102237830714E-3]

{"sheet":"2019Data","index":20,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["2019 Estimated Total Need in # of Applicants and Associated Cost"]
["Item","Eligible Cat A","Eligible Cat B"," Eligible Cat C-1"," Eligible Cat C-2","Eligible Applicants","Cost of Cat A & B Need","Cost of Cat C Need","Total Estimate of Need","2019 REGION DISTR AMT TO REGION","Percentage of Funding to Need",0.05,0.1,7.4999999999999997E-2,{"$f":"L2*I15","v":50516955.300000004},{"$f":"N2*I15","v":75775432.950000003},{"$f":"M2*I15","v":101033910.60000001}]
["ALASKA",6,214,481,1016,{"$f":"SUM(B3:E3)","v":1717},16110000,420847981,{"$f":"SUM(G3:H3)","v":436957981},2905715,{"$f":"J3/I3","v":6.6498728169471291E-3}]
["EASTERN OKLAHOMA",1,41,0,0,42,827500,0,{"$f":"SUM(G4:H4)","v":827500},30253,{"$f":"J4/I4","v":3.6559516616314201E-2}]
["EASTERN ",21,25,3,2,51,1657500,889900,2547400,37578,1.4751511344900683E-2]
["GREAT PLAINS",0,950,1083,63,2096,57000000,166632322,223632322,1946726,8.7050296781339149E-3]
["MIDWEST",0,38,3,2,43,2280000,822517,3102517,31407,1.0123071041995902E-2]
["NAVAJO",0,4,511,309,824,240000,127680970,127920970,943603,7.3764528208314865E-3]
["NORTHWEST",0,30,25,6,61,1800000,5033233,6833233,58232,8.5218812237194304E-3]
["PACIFIC",3,124,72,148,347,7462500,84458429,91920929,406966,4.4273486400469254E-3]
["ROCKY MOUNTAIN",3,62,28,2,95,3742500,4554453,8296953,83686,1.0086353387803932E-2]
["SOUTHERN PLAINS",0,353,128,20,501,21180000,19995637,41175637,430850,1.0463711830371926E-2]
["SOUTHWEST",0,36,14,31,81,2160000,6771057,{"$f":"SUM(G13:H13)","v":8931057},82422,9.2286948790048038E-3]
["WESTERN",2,140,79,248,469,8415000,49777607,58192607,514560,8.8423603362537094E-3]
["TOTAL",{"$f":"SUM(B3:B14)","v":36},2017,2427,1847,{"$f":"SUM(F3:F14)","v":6327},{"$f":"SUM(G3:G14)","v":122875000},{"$f":"SUM(H3:H14)","v":887464106},1010339106,{"$f":"SUM(J3:J14)","v":7471998},7.3955347819626019E-3]

{"sheet":"Milestones 14-15","index":22,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":true,"merged":[[0,1,0,2],[0,5,0,6],[1,0,2,0],[1,1,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,6],[1,7,2,7],[1,8,2,8],[13,0,14,0],[13,1,14,4],[31,0,32,0],[31,1,32,4],[31,5,32,8],[13,5,14,8]]}
["Workload Data","FY 2014",null,"Greenbook Targets","Percent of Eligible Households Served","FY 2015",null,"Greenbook Targets","Percent of Eligible Households Served"]
["Targets",8000000,null,"Estimate","Actual",8009000,null,"Estimate","Actual"]
[]
["Renovations",null,null,75,{"$f":"C29","v":34},null,45,75,{"$f":"G29","v":44}]
["Replacement",null,null,40,{"$f":"D29","v":50},null,42,40,{"$f":"H29","v":42}]
["New Units",null,null,40,{"$f":"E29","v":15},null,13,40,{"$f":"I29","v":13}]
["Total Households Served",null,null,{"$f":"SUM(D4:D6)","v":155},{"$f":"E30","v":99},null,{"$f":"SUM(G4:G6)","v":100},{"$f":"SUM(H4:H6)","v":155},{"$f":"IF(I30=0,\"0\",I30)","v":99}]
["Percentage Targets "]
["Renovations",null,{"$f":"B47","v":2549},{"$f":"D4/C9","v":2.9423303256178895E-2},{"$f":"E4/C9","v":1.3338564142801098E-2},null,2594,{"$f":"H4/G9","v":2.8912875867386275E-2},{"$f":"I4/G9","v":1.6962220508866616E-2}]
["Replacement",null,{"$f":"C47","v":3045},{"$f":"D5/C10","v":1.3136288998357963E-2},{"$f":"E5/C10","v":1.6420361247947456E-2},null,2816,{"$f":"H5/G10","v":1.4204545454545454E-2},{"$f":"I5/G10","v":1.4914772727272728E-2}]
["New Units",null,{"$f":"D47","v":1473},{"$f":"D6/C11","v":2.7155465037338764E-2},{"$f":"E6/C11","v":1.0183299389002037E-2},null,1863,{"$f":"H6/G11","v":2.147074610842727E-2},{"$f":"I6/G11","v":6.9779924852388618E-3}]
["Total Households Served",null,{"$f":"SUM(C9:C11)","v":7067},{"$f":"D7/C12","v":2.1932927692089994E-2},{"$f":"E7/C12","v":1.4008773171076835E-2},null,{"$f":"SUM(G9:G11)","v":7273},{"$f":"H7/G12","v":2.131170081121958E-2},{"$f":"I7/G12","v":1.361198955039186E-2}]
[]
[null,"FY 2014",null,null,null,"FY 2015"]
[]
["Region","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served"]
["ALASKA",1112,2,7,1,812,0,5,1]
["EASTERN OKLAHOMA",107,0,1,0,69,2,0,0]
["EASTERN ",165,5,1,0,161,7,0,0]
["GREAT PLAINS",1656,4,25,4,2149,13,21,5]
["MIDWEST",122,8,0,0,52,2,0,0]
["NAVAJO",804,0,6,1,853,0,8,0]
["NORTHWEST",37,3,0,0,85,2,0,0]
["PACIFIC",742,1,3,2,730,3,3,2]
["ROCKY MOUNTAIN",728,5,0,3,858,8,1,1]
["SOUTHERN PLAINS",539,1,3,0,556,3,2,0]
["SOUTHWEST",186,0,1,1,186,2,0,0]
["WESTERN",834,5,3,3,765,2,2,4]
["TOTAL",{"$f":"SUM(B17:B28)","v":7032},{"$f":"SUM(C17:C28)","v":34},{"$f":"SUM(D17:D28)","v":50},15,{"$f":"SUM(F17:F28)","v":7276},{"$f":"SUM(G17:G28)","v":44},{"$f":"SUM(H17:H28)","v":42},{"$f":"SUM(I17:I28)","v":13}]
[null,null,null,null,{"$f":"SUM(C29:E29)","v":99},null,null,null,{"$f":"SUM(G29:J29)","v":99}]
[]
[null,"2014 Percent",null,null,null,"2015 Percent"]
[]
["Region","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total"]
["ALASKA",351,588,173,{"$f":"SUM(B35:D35)","v":1112},273,312,227,{"$f":"SUM(F35:H35)","v":812}]
["EASTERN OKLAHOMA",94,13,0,{"$f":"SUM(B36:D36)","v":107},64,5,0,{"$f":"SUM(F36:H36)","v":69}]
["EASTERN ",157,4,4,165,129,16,16,161]
["GREAT PLAINS",488,1003,165,1656,612,1128,409,2149]
["MIDWEST",122,40,30,192,28,9,15,52]
["NAVAJO",0,525,179,704,3,580,270,853]
["NORTHWEST",23,14,0,37,61,10,14,85]
["PACIFIC",189,343,210,742,215,228,287,730]
["ROCKY MOUNTAIN",555,155,18,728,693,154,11,858]
["SOUTHERN PLAINS",390,133,16,539,401,135,20,556]
["SOUTHWEST",90,104,57,251,25,104,57,186]
["WESTERN",90,123,621,834,93,135,537,765]
["TOTAL",{"$f":"SUM(B35:B46)","v":2549},{"$f":"SUM(C35:C46)","v":3045},{"$f":"SUM(D35:D46)","v":1473},{"$f":"SUM(B47:D47)","v":7067},{"$f":"SUM(F35:F46)","v":2597},{"$f":"SUM(G35:G46)","v":2816},{"$f":"SUM(H35:H46)","v":1863},{"$f":"SUM(F47:H47)","v":7276}]

{"sheet":"Milestones 14-17","index":23,"n_rows":49,"n_cols":20,"rows_kept":49,"cut":false,"hidden":true,"merged":[[33,13,34,17],[0,1,0,2],[0,5,0,6],[0,9,0,10],[0,13,0,14],[1,7,2,7],[1,17,2,17],[1,9,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,14],[1,15,2,15],[15,9,16,12],[15,13,16,17],[33,9,34,12],[15,0,16,0],[15,1,16,4],[33,0,34,0],[33,1,34,4],[1,8,2,8],[15,5,16,8],[33,5,34,8],[1,0,2,0],[1,1,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,6]]}
["Workload Data","FY 2014",null,"Greenbook Targets","Percent of Eligible Households Served","FY 2015",null,"Greenbook Targets","Percent of Eligible Households Served","FY 2016",null,"Greenbook Targets","Percent of Eligible Households Served","FY 2017",null,"Greenbook Targets",null,"Percent of Eligible Households Served"]
["Targets",8000000,null,"Estimate","Actual",8009000,null,"Estimate","Actual",8021000,null,"Estimate","Actual",8021000,null,"Estimate",null,"Actual"]
[]
["Renovations",null,null,75,{"$f":"C31","v":34},null,45,75,{"$f":"G31","v":44},null,45,75,{"$f":"K31","v":45},null,31,75,null,{"$f":"O31","v":31},null,{"$f":"O4/R4","v":1}]
["Replacement",null,null,40,{"$f":"D31","v":50},null,42,40,{"$f":"H31","v":42},null,42,40,{"$f":"L31","v":42},null,24,40,null,{"$f":"P31","v":24}]
["New Units",null,null,40,{"$f":"E31","v":15},null,13,40,{"$f":"I31","v":13},null,13,40,{"$f":"M31","v":13},null,12,40,null,{"$f":"R31","v":24}]
["Downpayment ",null,null,null,null,null,null,null,null,null,null,null,null,null,24,24,null,{"$f":"R32","v":91}]
["Total Households Served",null,null,{"$f":"SUM(D4:D6)","v":155},{"$f":"E32","v":99},null,{"$f":"SUM(G4:G6)","v":100},{"$f":"SUM(H4:H6)","v":155},{"$f":"IF(I32=0,\"0\",I32)","v":99},null,{"$f":"SUM(K4:K6)","v":100},{"$f":"SUM(L4:L6)","v":155},{"$f":"IF(M32=0,\"0\",M32)","v":100},null,{"$f":"SUM(O4:O7)","v":91},90,null,{"$f":"IF(R32=0,\"0\",R32)","v":91}]
["Percentage Targets "]
["Renovations",null,{"$f":"B49","v":2549},{"$f":"D4/C10","v":2.9423303256178895E-2},{"$f":"E4/C10","v":1.3338564142801098E-2},null,2594,{"$f":"H4/G10","v":2.8912875867386275E-2},{"$f":"I4/G10","v":1.6962220508866616E-2},null,2594,{"$f":"L4/K10","v":2.8912875867386275E-2},{"$f":"M4/K10","v":1.7347725520431765E-2},null,2398,{"$f":"P4/O10","v":3.1276063386155128E-2},null,{"$f":"R4/O10","v":1.292743953294412E-2}]
["Replacement",null,{"$f":"C49","v":3045},{"$f":"D5/C11","v":1.3136288998357963E-2},{"$f":"E5/C11","v":1.6420361247947456E-2},null,2816,{"$f":"H5/G11","v":1.4204545454545454E-2},{"$f":"I5/G11","v":1.4914772727272728E-2},null,2816,{"$f":"L5/K11","v":1.4204545454545454E-2},{"$f":"M5/K11","v":1.4914772727272728E-2},null,2280,{"$f":"P5/O11","v":1.7543859649122806E-2},null,{"$f":"R5/O11","v":1.0526315789473684E-2}]
["New Units",null,{"$f":"D49","v":1473},{"$f":"D6/C12","v":2.7155465037338764E-2},{"$f":"E6/C12","v":1.0183299389002037E-2},null,1863,{"$f":"H6/G12","v":2.147074610842727E-2},{"$f":"I6/G12","v":6.9779924852388618E-3},null,1863,{"$f":"L6/K12","v":2.147074610842727E-2},{"$f":"M6/K12","v":6.9779924852388618E-3},null,1379,{"$f":"P6/O12","v":2.9006526468455404E-2},null,{"$f":"R6/O12","v":1.7403915881073241E-2}]
["Downpayment "]
["Total Households Served",null,{"$f":"SUM(C10:C12)","v":7067},{"$f":"D8/C14","v":2.1932927692089994E-2},{"$f":"E8/C14","v":1.4008773171076835E-2},null,{"$f":"SUM(G10:G12)","v":7273},{"$f":"H8/G14","v":2.131170081121958E-2},{"$f":"I8/G14","v":1.361198955039186E-2},null,{"$f":"SUM(K10:K12)","v":7273},{"$f":"L8/K14","v":2.131170081121958E-2},{"$f":"M8/K14","v":1.3749484394335213E-2},null,6057,{"$f":"P8/O14","v":1.4858841010401188E-2},null,{"$f":"R8/O14","v":1.5023939243850091E-2}]
[]
[null,"FY 2014",null,null,null,"FY 2015",null,null,null,"FY 2016",null,null,null,"FY 2017"]
[]
["Region","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served","# of Eligible Households Category D Served"]
["ALASKA",1112,2,7,1,812,0,5,1,812,1,5,1,889,5,1,3,10,"ALASKA"]
["EASTERN OKLAHOMA",107,0,1,0,69,2,0,0,69,2,0,0,54,1,0,0,0,"EASTERN OKLAHOMA"]
["EASTERN ",165,5,1,0,161,7,0,0,161,7,0,0,77,0,0,0,0,"EASTERN "]
["GREAT PLAINS",1656,4,25,4,2149,13,21,5,2149,13,21,5,1758,9,7,3,14,"GREAT PLAINS"]
["MIDWEST",122,8,0,0,52,2,0,0,52,2,0,0,96,2,0,0,0,"MIDWEST"]
["NAVAJO",804,0,6,1,850,0,8,0,850,0,8,0,730,0,9,2,0,"NAVAJO"]
["NORTHWEST",37,3,0,0,85,2,0,0,85,2,0,0,18,1,0,0,0,"NORTHWEST"]
["PACIFIC",742,1,3,2,730,3,3,2,730,3,3,2,884,3,3,3,0,"PACIFIC"]
["ROCKY MOUNTAIN",728,5,0,3,858,8,1,1,858,8,1,1,536,0,0,0,0,"ROCKY MOUNTAIN"]
["SOUTHERN PLAINS",539,1,3,0,556,3,2,0,556,3,2,0,501,1,2,1,0,"SOUTHERN PLAINS"]
["SOUTHWEST",186,0,1,1,186,2,0,0,186,2,0,0,79,3,0,0,0,"SOUTHWEST"]
["WESTERN",834,5,3,3,765,2,2,4,765,2,2,4,453,6,2,0,0,"WESTERN"]
["TOTAL",{"$f":"SUM(B19:B30)","v":7032},{"$f":"SUM(C19:C30)","v":34},{"$f":"SUM(D19:D30)","v":50},15,7273,44,42,13,7273,45,42,13,6075,31,{"$f":"SUM(P19:P30)","v":24},{"$f":"SUM(Q19:Q30)","v":12},24,"TOTAL"]
[null,null,null,null,{"$f":"SUM(C31:E31)","v":99},null,null,null,{"$f":"SUM(G31:I31)","v":99},null,null,null,{"$f":"SUM(K31:M31)","v":100},null,null,null,null,{"$f":"SUM(O31:S31)","v":91}]
[]
[null,"2014 Percent",null,null,null,"2015 Percent",null,null,null,"2016 Percent",null,null,null,"2017 Percent"]
[]
["Region","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","# of Eligible Applicants             Cat D","Total"]
["ALASKA",351,588,173,{"$f":"SUM(B37:D37)","v":1112},273,312,227,{"$f":"SUM(F37:H37)","v":812},273,312,227,{"$f":"SUM(J37:L37)","v":812},175,402,303,0,{"$f":"SUM(N37:Q37)","v":880},"ALASKA"]
["EASTERN OKLAHOMA",94,13,0,{"$f":"SUM(B38:D38)","v":107},64,5,0,{"$f":"SUM(F38:H38)","v":69},64,5,0,{"$f":"SUM(J38:L38)","v":69},49,3,1,0,53,"EASTERN OKLAHOMA"]
["EASTERN ",157,4,4,165,129,16,16,161,129,16,16,161,67,6,4,0,77,"EASTERN "]
["GREAT PLAINS",488,1003,165,1656,612,1128,409,2149,612,1128,409,2149,749,912,97,0,1758,"GREAT PLAINS"]
["MIDWEST",122,40,30,192,28,9,15,52,28,9,15,52,49,20,22,0,91,"MIDWEST"]
["NAVAJO",0,525,179,704,0,580,270,850,0,580,270,850,8,377,344,0,729,"NAVAJO"]
["NORTHWEST",23,14,0,37,61,10,14,85,61,10,14,85,12,5,0,0,17,"NORTHWEST"]
["PACIFIC",189,343,210,742,215,228,287,730,215,228,287,730,323,250,311,0,884,"PACIFIC"]
["ROCKY MOUNTAIN",555,155,18,728,693,154,11,858,693,154,11,858,444,83,8,0,535,"ROCKY MOUNTAIN"]
["SOUTHERN PLAINS",390,133,16,539,401,135,20,556,401,135,20,556,353,128,20,0,501,"SOUTHERN PLAINS"]
["SOUTHWEST",90,104,57,251,25,104,57,186,25,104,57,186,27,24,28,0,79,"SOUTHWEST"]
["WESTERN",90,123,621,834,93,135,537,765,93,135,537,765,142,70,241,0,453,"WESTERN"]
["TOTAL",{"$f":"SUM(B37:B48)","v":2549},{"$f":"SUM(C37:C48)","v":3045},{"$f":"SUM(D37:D48)","v":1473},{"$f":"SUM(B49:D49)","v":7067},{"$f":"SUM(F37:F48)","v":2594},{"$f":"SUM(G37:G48)","v":2816},{"$f":"SUM(H37:H48)","v":1863},{"$f":"SUM(F49:H49)","v":7273},{"$f":"SUM(J37:J48)","v":2594},{"$f":"SUM(K37:K48)","v":2816},{"$f":"SUM(L37:L48)","v":1863},{"$f":"SUM(J49:L49)","v":7273},{"$f":"SUM(N37:N48)","v":2398},{"$f":"SUM(O37:O48)","v":2280},{"$f":"SUM(P37:P48)","v":1379},{"$f":"SUM(Q37:Q48)","v":0},{"$f":"SUM(N49:P49)","v":6057},"TOTAL"]

{"sheet":"Milestones 15-16","index":24,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":true,"merged":[[0,1,0,2],[0,5,0,7],[0,9,0,10],[1,0,2,0],[1,1,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,7],[1,8,2,8],[12,5,12,7],[1,9,2,9],[1,10,2,10],[3,5,3,7],[4,5,4,7],[5,5,5,7],[6,5,6,7],[7,5,7,7],[8,5,8,7],[9,5,9,7],[10,5,10,7],[11,5,11,7],[14,0,15,0],[14,1,15,4],[14,5,15,9],[32,0,33,0],[32,1,33,4],[32,5,33,9]]}
["Workload Data","FY 2015",null,"Greenbook Targets","Percent of Eligible Households Served","FY 2016",null,null,"Greenbook Targets","Percent of Eligible Households Served"]
["Targets",8009000,null,"Estimate","Actual","Targets",8021000,null,null,"Estimate","Actual"]
[]
["Temporary",null,null,null,null,"Temporary "]
["Renovations",null,45,75,{"$f":"C30","v":44},"Renovations",null,null,45,45,{"$f":"H30","v":37}]
["Replacement",null,42,40,{"$f":"D30","v":42},"Replacements",null,null,42,42,{"$f":"I30","v":25}]
["New Units",null,13,40,{"$f":"E30","v":13},"New Units",null,null,13,13,{"$f":"J30","v":12}]
["Total Households Served",null,{"$f":"SUM(C5:C7)","v":100},{"$f":"SUM(D5:D7)","v":155},{"$f":"IF(E31=0,\"0\",E31)","v":99},"Total Households Served",null,null,{"$f":"SUM(I5:I7)","v":100},{"$f":"SUM(J5:J7)","v":100},{"$f":"IF(K31=0,\"0\",K31)","v":91}]
["Percentage Targets ",null,null,null,null,"Percentage Targets"]
["Renovations",null,2594,{"$f":"D5/C10","v":2.8912875867386275E-2},{"$f":"E5/C10","v":1.6962220508866616E-2},"Renovations",null,null,2594,2594,{"$f":"K5/J10","v":1.4263685427910563E-2}]
["Replacement",null,2816,{"$f":"D6/C11","v":1.4204545454545454E-2},{"$f":"E6/C11","v":1.4914772727272728E-2},"Replacements",null,null,2816,2816,{"$f":"K6/J11","v":8.8778409090909099E-3}]
["New Units",null,1863,{"$f":"D7/C12","v":2.147074610842727E-2},{"$f":"E7/C12","v":6.9779924852388618E-3},"New Units",null,null,1863,1863,{"$f":"K7/J12","v":6.4412238325281803E-3}]
["Total Households Served",null,{"$f":"SUM(C10:C12)","v":7273},{"$f":"D8/C13","v":2.131170081121958E-2},{"$f":"E8/C13","v":1.361198955039186E-2},"Total Households Served",null,null,{"$f":"SUM(I10:I12)","v":7273},{"$f":"SUM(J10:J12)","v":7273},{"$f":"K8/J13","v":1.2512030798845043E-2}]
[]
[null,"FY 2015",null,null,null,"FY 2016"]
[]
["Region","# of Eligible Households","# of Eligible Household Category B Served","# of Eligible Household Category C-1 Served","# of Eligible Household Category C-2 Served","# of Eligible Households","# of Household Category A Served","# of  Household Category B Served","# of Household Category C-1 Served","# of  Household Category C-2 Served","# of  Household Category D Served"]
["ALASKA",812,0,5,1,1026,1,3,6,0,3]
["EASTERN OKLAHOMA",69,2,0,0,101,0,2,0,0,0]
["EASTERN ",161,7,0,0,56,0,0,0,0,0]
["GREAT PLAINS",2149,13,21,5,1934,0,10,10,1,13]
["MIDWEST",52,2,0,0,26,0,1,0,0,0]
["NAVAJO",853,0,8,0,785,0,0,3,4,0]
["NORTHWEST",85,2,0,0,25,0,1,0,0,0]
["PACIFIC",730,3,3,2,864,0,10,1,3,0]
["ROCKY MOUNTAIN",858,8,1,1,378,0,4,0,0,0]
["SOUTHERN PLAINS",556,3,2,0,452,0,3,2,0,0]
["SOUTHWEST",186,2,0,0,73,0,1,0,0,0]
["WESTERN",765,2,2,4,874,0,2,3,4,0]
["TOTAL",{"$f":"SUM(B18:B29)","v":7276},{"$f":"SUM(C18:C29)","v":44},{"$f":"SUM(D18:D29)","v":42},{"$f":"SUM(E18:E29)","v":13},{"$f":"SUM(F18:F29)","v":6594},{"$f":"SUM(G18:G29)","v":1},37,25,12,16]
[null,null,null,null,{"$f":"SUM(C30:E30)","v":99},null,null,null,null,null,{"$f":"SUM(G30:K30)","v":91}]
[]
[null,"2015 Percent",null,null,null,"2016 Percent"]
[]
["Region","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total","# of Eligible Applicants       Cat A","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","# of Eligible Applicants             Cat D","Total"]
["ALASKA",273,312,227,{"$f":"SUM(B36:D36)","v":812},23,272,419,335,null,{"$f":"SUM(F36:J36)","v":1049}]
["EASTERN OKLAHOMA",64,5,0,{"$f":"SUM(B37:D37)","v":69},20,96,5,0,null,{"$f":"SUM(F37:J37)","v":121}]
["EASTERN ",129,16,16,161,0,55,1,0,null,56]
["GREAT PLAINS",612,1128,409,2149,0,741,965,228,null,1934]
["MIDWEST",28,9,15,52,4,8,7,11,null,30]
["NAVAJO",3,580,270,853,0,9,487,289,null,785]
["NORTHWEST",61,10,14,85,0,20,3,2,null,25]
["PACIFIC",215,228,287,730,0,297,259,308,null,864]
["ROCKY MOUNTAIN",693,154,11,858,5,334,35,9,null,383]
["SOUTHERN PLAINS",401,135,20,556,0,305,127,20,null,452]
["SOUTHWEST",25,104,57,186,0,44,15,14,null,73]
["WESTERN",93,135,537,765,1,140,118,616,null,875]
["TOTAL",{"$f":"SUM(B36:B47)","v":2597},{"$f":"SUM(C36:C47)","v":2816},{"$f":"SUM(D36:D47)","v":1863},{"$f":"SUM(B48:D48)","v":7276},{"$f":"SUM(F36:F47)","v":53},{"$f":"SUM(G36:G47)","v":2321},{"$f":"SUM(H36:H47)","v":2441},{"$f":"SUM(I36:I47)","v":1832},null,{"$f":"SUM(F48:J48)","v":6647}]

{"sheet":"Milestones 18-19 ","index":25,"n_rows":49,"n_cols":30,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,5,0,6],[0,9,0,10],[0,13,0,14],[1,0,2,0],[1,1,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,6],[1,7,2,7],[1,17,2,17],[15,0,16,0],[15,1,16,4],[15,5,16,8],[15,9,16,12],[15,13,16,17],[1,8,2,8],[1,9,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,14],[1,15,2,15],[33,0,34,0],[33,1,34,4],[33,5,34,8],[33,9,34,12],[33,13,34,17],[1,20,2,20],[1,22,2,22],[15,18,16,22],[33,18,34,22],[0,18,0,19],[1,18,2,19],[33,23,34,27],[0,23,0,24],[1,23,2,24],[1,25,2,25],[1,27,2,27],[15,23,16,27]]}
["Workload Data","FY 2014",null,"Greenbook Targets","Percent of Eligible Households Served","FY 2015",null,"Greenbook Targets","Percent of Eligible Households Served","FY 2016",null,"Greenbook Targets","Percent of Eligible Households Served","FY 2017",null,"Greenbook Targets",null,"Percent of Eligible Households Served","FY 2018",null,"Greenbook Targets",null,"Percent of Eligible Households Served","FY 2019",null,"Greenbook Targets",null,"Percent of Eligible Households Served"]
["Targets",8000000,null,"Estimate","Actual",8009000,null,"Estimate","Actual",8021000,null,"Estimate","Actual",8021000,null,"Estimate",null,"Actual",8021000,null,"Estimate",null,"Actual",8021000,null,"Estimate",null,"Actual"]
[]
["Renovations",null,null,75,{"$f":"C31","v":34},null,45,75,{"$f":"G31","v":45},null,45,75,{"$f":"K31","v":47},null,31,75,null,{"$f":"O31","v":31},null,34,75,null,{"$f":"T31","v":34},null,34,75,null,{"$f":"Y31","v":22}]
["Replacement",null,null,40,{"$f":"D31","v":50},null,42,40,{"$f":"H31","v":42},null,42,40,{"$f":"L31","v":27},null,24,40,null,{"$f":"P31","v":24},null,16,40,null,{"$f":"U31","v":16},null,16,40,null,{"$f":"Z31","v":22}]
["New Units",null,null,40,{"$f":"E31","v":15},null,13,40,{"$f":"I31","v":13},null,13,40,{"$f":"M31","v":21},null,12,40,null,{"$f":"R31","v":24},null,21,40,null,{"$f":"W31","v":16},null,21,40,null,{"$f":"AB31","v":35}]
["Downpayment ",null,null,null,null,null,null,null,null,null,null,null,null,null,24,24,null,{"$f":"R32","v":13680},null,16,24,null,{"$f":"W32","v":6509},null,16,24,null,{"$f":"AB32","v":0}]
["Total Households Served",null,null,{"$f":"SUM(D4:D6)","v":155},{"$f":"E32","v":99},null,{"$f":"SUM(G4:G6)","v":100},{"$f":"SUM(H4:H6)","v":155},{"$f":"IF(I32=0,\"0\",I32)","v":100},null,{"$f":"SUM(K4:K6)","v":100},{"$f":"SUM(L4:L6)","v":155},{"$f":"IF(M32=0,\"0\",M32)","v":95},null,{"$f":"SUM(O4:O7)","v":91},90,null,{"$f":"IF(R32=0,\"0\",R32)","v":13680},null,{"$f":"SUM(T4:T7)","v":87},90,null,{"$f":"IF(W32=0,\"0\",W32)","v":6509},null,{"$f":"SUM(Y4:Y7)","v":87},90,null,{"$f":"IF(AB32=0,\"0\",AB32)","v":"0"}]
["Percentage Targets "]
["Renovations",null,{"$f":"B49","v":2549},{"$f":"D4/C10","v":2.9423303256178895E-2},{"$f":"E4/C10","v":1.3338564142801098E-2},null,2594,{"$f":"H4/G10","v":2.8912875867386275E-2},{"$f":"I4/G10","v":1.7347725520431765E-2},null,2411,{"$f":"L4/K10","v":3.1107424305267525E-2},{"$f":"M4/K10","v":1.9493985897967647E-2},null,2398,{"$f":"P4/O10","v":3.1276063386155128E-2},null,{"$f":"R4/O10","v":1.292743953294412E-2},null,2698,{"$f":"U4/T10","v":2.7798369162342476E-2},null,{"$f":"W4/T10","v":1.2601927353595256E-2},null,2698,{"$f":"Z4/Y10","v":2.7798369162342476E-2},null,{"$f":"AB4/Y10","v":8.1541882876204601E-3}]
["Replacement",null,{"$f":"C49","v":3045},{"$f":"D5/C11","v":1.3136288998357963E-2},{"$f":"E5/C11","v":1.6420361247947456E-2},null,2816,{"$f":"H5/G11","v":1.4204545454545454E-2},{"$f":"I5/G11","v":1.4914772727272728E-2},null,2454,{"$f":"L5/K11","v":1.6299918500407497E-2},{"$f":"M5/K11","v":1.1002444987775062E-2},null,2280,{"$f":"P5/O11","v":1.7543859649122806E-2},null,{"$f":"R5/O11","v":1.0526315789473684E-2},null,2470,{"$f":"U5/T11","v":1.6194331983805668E-2},null,{"$f":"W5/T11","v":6.4777327935222669E-3},null,2470,{"$f":"Z5/Y11","v":1.6194331983805668E-2},null,{"$f":"AB5/Y11","v":8.9068825910931168E-3}]
["New Units",null,{"$f":"D49","v":1473},{"$f":"D6/C12","v":2.7155465037338764E-2},{"$f":"E6/C12","v":1.0183299389002037E-2},null,1863,{"$f":"H6/G12","v":2.147074610842727E-2},{"$f":"I6/G12","v":6.9779924852388618E-3},null,1874,{"$f":"L6/K12","v":2.1344717182497332E-2},{"$f":"M6/K12","v":1.1205976520811099E-2},null,1379,{"$f":"P6/O12","v":2.9006526468455404E-2},null,{"$f":"R6/O12","v":1.7403915881073241E-2},null,2008,{"$f":"U6/T12","v":1.9920318725099601E-2},null,{"$f":"W6/T12","v":7.9681274900398405E-3},null,2008,{"$f":"Z6/Y12","v":1.9920318725099601E-2},null,{"$f":"AB6/Y12","v":1.743027888446215E-2}]
["Downpayment "]
["Total Households Served",null,{"$f":"SUM(C10:C12)","v":7067},{"$f":"D8/C14","v":2.1932927692089994E-2},{"$f":"E8/C14","v":1.4008773171076835E-2},null,{"$f":"SUM(G10:G12)","v":7273},{"$f":"H8/G14","v":2.131170081121958E-2},{"$f":"I8/G14","v":1.3749484394335213E-2},null,6739,{"$f":"L8/K14","v":2.3000445169906514E-2},{"$f":"M8/K14","v":1.4097047039620121E-2},null,{"$f":"SUM(O10:O12)","v":6057},{"$f":"P8/O14","v":1.4858841010401188E-2},null,{"$f":"R8/O14","v":2.2585438335809807},null,7176,{"$f":"U8/T14","v":1.254180602006689E-2},null,{"$f":"W8/T14","v":0.90705128205128205},null,7176,{"$f":"Z8/Y14","v":1.254180602006689E-2},null,{"$f":"AB8/Y14","v":0}]
[]
[null,"FY 2014",null,null,null,"FY 2015",null,null,null,"FY 2016",null,null,null,"FY 2017",null,null,null,null,"FY 2018",null,null,null,null,"FY 2019"]
[]
["Region","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served","# of Eligible Households Category D Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served","# of Eligible Households Category D Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C-1 Served","# of Eligible Households Category C-2 Served","# of Eligible Households Category D Served"]
["ALASKA",1112,2,7,1,812,1,5,1,1076,4,6,0,889,5,1,3,10,1524,8,5,4,6,1717,2,6,8,7,null,"ALASKA"]
["EASTERN OKLAHOMA",107,0,1,0,69,2,0,0,121,2,0,0,54,1,0,0,0,59,0,0,0,0,42,1,0,0,0,null,"EASTERN OKLAHOMA"]
["EASTERN ",165,5,1,0,161,7,0,0,56,7,0,0,77,0,0,0,0,97,1,0,0,0,51,0,0,0,0,null,"EASTERN "]
["GREAT PLAINS",1656,4,25,4,2149,13,21,5,1934,10,11,13,1758,9,7,3,14,1901,6,7,3,10,2096,8,5,5,28,null,"GREAT PLAINS"]
["MIDWEST",122,8,0,0,52,2,0,0,30,1,0,0,96,2,0,0,0,71,3,0,0,0,41,1,0,0,0,null,"MIDWEST"]
["NAVAJO",804,0,6,1,850,0,8,0,785,3,4,0,730,0,9,2,0,872,0,0,6,0,824,0,4,3,0,null,"NAVAJO"]
["NORTHWEST",37,3,0,0,85,2,0,0,25,1,0,0,18,1,0,0,0,29,1,0,0,0,61,1,0,0,0,null,"NORTHWEST"]
["PACIFIC",742,1,3,2,730,3,3,2,864,10,1,3,884,3,3,3,0,929,3,2,3,0,347,2,2,0,0,null,"PACIFIC"]
["ROCKY MOUNTAIN",728,5,0,3,858,8,1,1,384,4,0,0,536,0,0,0,0,554,6,0,0,0,94,6,0,0,0,null,"ROCKY MOUNTAIN"]
["SOUTHERN PLAINS",539,1,3,0,556,3,2,0,508,3,2,0,501,1,2,1,0,515,0,1,2,0,501,0,3,0,0,null,"SOUTHERN PLAINS"]
["SOUTHWEST",186,0,1,1,186,2,0,0,81,0,0,1,79,3,0,0,0,81,1,0,1,0,81,1,0,1,0,null,"SOUTHWEST"]
["WESTERN",834,5,3,3,765,2,2,4,875,2,3,4,453,6,2,0,0,546,5,1,2,0,469,0,2,2,0,null,"WESTERN"]
["TOTAL",{"$f":"SUM(B19:B30)","v":7032},{"$f":"SUM(C19:C30)","v":34},{"$f":"SUM(D19:D30)","v":50},15,7273,45,42,13,6739,47,27,21,6075,31,{"$f":"SUM(P19:P30)","v":24},{"$f":"SUM(Q19:Q30)","v":12},24,{"$f":"SUM(S19:S30)","v":7178},{"$f":"SUM(T19:T30)","v":34},{"$f":"SUM(U19:U30)","v":16},{"$f":"SUM(V19:V30)","v":21},{"$f":"SUM(W19:W30)","v":16},{"$f":"SUM(X19:X30)","v":6324},{"$f":"SUM(Y19:Y30)","v":22},{"$f":"SUM(Z19:Z30)","v":22},{"$f":"SUM(AA19:AA30)","v":19},{"$f":"SUM(AB19:AB30)","v":35}]
[null,null,null,null,{"$f":"SUM(C31:E31)","v":99},null,null,null,{"$f":"SUM(G31:I31)","v":100},null,null,null,{"$f":"SUM(K31:M31)","v":95},null,null,null,null,{"$f":"SUM(O31:X31)","v":13680},null,null,null,null,{"$f":"SUM(T31:AC31)","v":6509}]
[]
[null,"2014 Percent",null,null,null,"2015 Percent",null,null,null,"2016 Percent",null,null,null,"2017 Percent",null,null,null,null,"2018 Percent",null,null,null,null,"2019 Percent"]
[]
["Region","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","# of Eligible Applicants             Cat D","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","# of Eligible Applicants             Cat D","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","# of Eligible Applicants             Cat D","Total"]
["ALASKA",351,588,173,{"$f":"SUM(B37:D37)","v":1112},273,312,227,{"$f":"SUM(F37:H37)","v":812},295,419,362,{"$f":"SUM(J37:L37)","v":1076},175,402,303,0,{"$f":"SUM(N37:Q37)","v":880},285,377,862,0,{"$f":"SUM(S37:V37)","v":1524},220,481,1016,0,{"$f":"SUM(X37:AA37)","v":1717},null,"ALASKA"]
["EASTERN OKLAHOMA",94,13,0,{"$f":"SUM(B38:D38)","v":107},64,5,0,{"$f":"SUM(F38:H38)","v":69},116,5,0,{"$f":"SUM(J38:L38)","v":121},49,3,1,0,53,54,2,3,0,59,42,0,0,0,42,null,"EASTERN OKLAHOMA"]
["EASTERN ",157,4,4,165,129,16,16,161,55,1,0,56,67,6,4,0,77,95,2,0,0,97,46,3,2,0,51,null,"EASTERN "]
["GREAT PLAINS",488,1003,165,1656,612,1128,409,2149,741,965,228,1934,749,912,97,0,1758,823,1013,65,0,1901,950,1083,63,0,2096,null,"GREAT PLAINS"]
["MIDWEST",122,40,30,192,28,9,15,52,12,7,11,30,49,20,22,0,91,51,13,7,0,71,38,2,1,0,41,null,"MIDWEST"]
["NAVAJO",0,525,179,704,0,580,270,850,9,487,289,785,8,377,344,0,729,1,495,376,0,872,4,511,309,0,824,null,"NAVAJO"]
["NORTHWEST",23,14,0,37,61,10,14,85,20,3,2,25,12,5,0,0,17,4,19,6,0,29,30,25,6,0,61,null,"NORTHWEST"]
["PACIFIC",189,343,210,742,215,228,287,730,297,259,308,864,323,250,311,0,884,311,283,336,0,930,127,72,148,0,347,null,"PACIFIC"]
["ROCKY MOUNTAIN",555,155,18,728,693,154,11,858,339,35,10,384,444,83,8,0,535,496,52,6,0,554,64,28,2,0,94,null,"ROCKY MOUNTAIN"]
["SOUTHERN PLAINS",390,133,16,539,401,135,20,556,360,128,20,508,353,128,20,0,501,368,126,21,0,515,353,128,20,0,501,null,"SOUTHERN PLAINS"]
["SOUTHWEST",90,104,57,251,25,104,57,186,26,27,28,81,27,24,28,0,79,26,27,28,0,81,36,18,27,0,81,null,"SOUTHWEST"]
["WESTERN",90,123,621,834,93,135,537,765,141,118,616,875,142,70,241,0,453,184,61,298,0,543,142,79,248,0,469,null,"WESTERN"]
["TOTAL",{"$f":"SUM(B37:B48)","v":2549},{"$f":"SUM(C37:C48)","v":3045},{"$f":"SUM(D37:D48)","v":1473},{"$f":"SUM(B49:D49)","v":7067},{"$f":"SUM(F37:F48)","v":2594},{"$f":"SUM(G37:G48)","v":2816},{"$f":"SUM(H37:H48)","v":1863},{"$f":"SUM(F49:H49)","v":7273},{"$f":"SUM(J37:J48)","v":2411},{"$f":"SUM(K37:K48)","v":2454},{"$f":"SUM(L37:L48)","v":1874},{"$f":"SUM(J49:L49)","v":6739},{"$f":"SUM(N37:N48)","v":2398},{"$f":"SUM(O37:O48)","v":2280},{"$f":"SUM(P37:P48)","v":1379},{"$f":"SUM(Q37:Q48)","v":0},{"$f":"SUM(N49:P49)","v":6057},{"$f":"SUM(S37:S48)","v":2698},{"$f":"SUM(T37:T48)","v":2470},{"$f":"SUM(U37:U48)","v":2008},{"$f":"SUM(V37:V48)","v":0},{"$f":"SUM(S49:U49)","v":7176},{"$f":"SUM(X37:X48)","v":2052},{"$f":"SUM(Y37:Y48)","v":2430},{"$f":"SUM(Z37:Z48)","v":1842},{"$f":"SUM(AA37:AA48)","v":0},{"$f":"SUM(X49:Z49)","v":6324}]

{"sheet":"Milestones2","index":26,"n_rows":50,"n_cols":35,"rows_kept":50,"cut":false,"hidden":true,"merged":[[34,19,35,21],[34,22,35,25],[34,26,35,29],[15,19,16,21],[15,22,16,25],[15,26,16,29],[1,26,2,27],[34,13,35,15],[34,16,35,18],[6,16,7,18],[15,0,16,0],[15,1,16,3],[15,4,16,6],[15,7,16,9],[15,10,16,12],[15,13,16,15],[15,16,16,18],[34,0,35,0],[34,1,35,3],[34,4,35,6],[34,7,35,9],[34,10,35,12],[1,13,1,15],[1,16,1,18],[1,19,1,21],[1,22,2,23],[1,24,1,25],[1,0,2,0],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,1,12],[1,30,2,31],[1,32,1,33],[15,30,16,33],[34,30,35,33],[1,28,1,29]]}
["Workload Data",null,"Greenbook Targets","Percent of Eligible Households Served",null,"Greenbook Targets","Percent of Eligible Households Served",null,"Greenbook Targets","Percent of Eligible Households Served",null,"Greenbook Targets","Percent of Eligible Households Served",null,"Greenbook Targets","Percent of Eligible Households Served",null,"Greenbook Targets","Percent of Eligible Households Served",null,"Greenbook Targets","Percent of Eligible Households Served",null,null,"Greenbook Targets","Percent of Eligible Households Served",null,null,"Greenbook Targets","Percent of Eligible Households Served",null,null,"Greenbook Targets","Percent of Eligible Households Served"]
["Targets","FY2004",null,null,"FY2005",null,null,"FY 2006        ",null,null,"FY 2007        ",null,null,"FY 2008",null,null,"FY 2009",null,null,"FY 2010",null,null,"Targets",null,"FY 2011",null,"Targets",null,"FY 2012",null,"Targets",null,"FY 2013"]
[null,null,"Estimate","Actual",null,"Estimate","Actual",null,"Estimate","Actual",null,"Estimate","Actual",null,"Estimate","Actual",null,"Estimate","Actual",null,"Estimate","Actual",null,null,"Estimate","Actual",null,null,"Estimate","Actual",null,null,"Estimate","Actual"]
["Renovations",null,132,104,null,132,132,null,132,86,null,{"$f":"SUM(C4+F4+I4)/4.25","v":93.17647058823529},97,null,{"$f":"SUM(F4+I4+L4)/4.25","v":84.041522491349482},65,null,{"$f":"SUM(I4+L4+O4)/4.25","v":72.757174842255253},84,null,{"$f":"SUM(L4+O4+R4)/4.25","v":58.81768656984471},{"$f":"U31","v":71},null,null,{"$f":"SUM(P4+S4+V4)/4.25","v":51.764705882352942},{"$f":"Y31","v":63},null,null,60,56,null,null,60,null,"Renovations"]
["New /Replacement",null,298,189,null,298,182,null,298,162,null,{"$f":"SUM(C5+F5+I5)/4.25","v":210.35294117647058},200,null,{"$f":"SUM(F5+I5+L5)/4.25","v":189.73010380622839},114,null,{"$f":"SUM(I5+L5+O5)/4.25","v":164.25483411357624},82,null,{"$f":"SUM(L5+O5+R5)/4.25","v":132.78538331677063},{"$f":"V31","v":84},null,null,{"$f":"SUM(P5+S5+V5)/4.25","v":65.882352941176464},{"$f":"Z31","v":89},null,null,80,77,null,null,80,null,"New /Replacement"]
["Total Households Served","Total",430,{"$f":"SUM(C31:D31)","v":293},"Total",430,{"$f":"SUM(G4:G5)","v":314},"Total",430,{"$f":"SUM(J4:J5)","v":248},"Total",{"$f":"SUM(L4:L5)","v":303.52941176470586},{"$f":"SUM(M4:M5)","v":297},"Total",{"$f":"SUM(O4:O5)","v":273.77162629757788},{"$f":"SUM(P4:P5)","v":179},"Total",{"$f":"SUM(R4:R5)","v":237.0120089558315},{"$f":"SUM(S4:S5)","v":166},"Total",170,{"$f":"SUM(V4:V5)","v":155},null,"Total",170,{"$f":"SUM(Z4:Z5)","v":152},null,"Total",140,133,null,"Total",140,null,"Total Households Served"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage of Target"]
["Percentage Targets "]
["Renovations",2309,{"$f":"C4/B9","v":5.7167605023819838E-2},{"$f":"D4/B9","v":4.5041143352100479E-2},2904,4.5454545454545456E-2,{"$f":"G4/E9","v":4.5454545454545456E-2},2649,{"$f":"I4/H9","v":4.9830124575311441E-2},{"$f":"J4/H9","v":3.2465081162702907E-2},{"$f":"K50","v":2175},{"$f":"L4/K9","v":4.283975659229209E-2},{"$f":"M4/K9","v":4.4597701149425288E-2},{"$f":"N50","v":2473},{"$f":"O4/N9","v":3.3983632224565095E-2},{"$f":"P4/N9","v":2.6283865750101092E-2},{"$f":"Q50","v":2162},{"$f":"R4/Q9","v":3.3652717318341928E-2},{"$f":"S4/Q9","v":3.8852913968547641E-2},{"$f":"T50","v":2303},{"$f":"U4/T9","v":2.5539594689467961E-2},{"$f":"V4/T9","v":3.0829353017802867E-2},null,{"$f":"W50","v":2810},{"$f":"Y4/X9","v":1.8421603516851581E-2},{"$f":"Z4/X9","v":2.2419928825622777E-2},null,2985,{"$f":"AC4/AB9","v":2.0100502512562814E-2},{"$f":"AD4/AB9","v":1.8760469011725293E-2},null,2989,{"$f":"AG4/AF9","v":2.0073603211776515E-2},{"$f":"AH4/AF9","v":0}]
["New Construction ",3520,{"$f":"C5/B10","v":8.4659090909090906E-2},{"$f":"D5/B10","v":5.369318181818182E-2},4055,7.3489519112207149E-2,{"$f":"G5/E10","v":4.4882860665844633E-2},4459,{"$f":"I5/H10","v":6.6831128055617847E-2},{"$f":"J5/H10","v":3.6331015922852657E-2},{"$f":"L50","v":4119},{"$f":"L5/K10","v":5.1068934492952314E-2},{"$f":"M5/K10","v":4.8555474629764506E-2},{"$f":"O50","v":4050},{"$f":"O5/N10","v":4.6846939211414418E-2},{"$f":"P5/N10","v":2.8148148148148148E-2},{"$f":"R50","v":4156},{"$f":"R5/Q10","v":3.9522337370927869E-2},{"$f":"S5/Q10","v":1.973051010587103E-2},{"$f":"U50","v":5032},{"$f":"U5/T10","v":2.6388192233062525E-2},{"$f":"V5/T10","v":1.6693163751987282E-2},null,{"$f":"SUM(X50:Y50)","v":4515},{"$f":"Y5/X10","v":1.4591883264933879E-2},{"$f":"Z5/X10","v":1.9712070874861574E-2},null,4698,{"$f":"AC5/AB10","v":1.7028522775649212E-2},{"$f":"AD5/AB10","v":1.6389953171562367E-2},null,5287,{"$f":"AG5/AF10","v":1.5131454511064877E-2},{"$f":"AH5/AF10","v":0}]
["Total Households Served",{"$f":"SUM(B9:B10)","v":5829},{"$f":"C6/B11","v":7.3769085606450513E-2},{"$f":"D6/B11","v":5.02659118202093E-2},6959,6.1790487138956747E-2,{"$f":"G6/E11","v":4.5121425492168417E-2},7108,{"$f":"I6/H11","v":6.0495216657287562E-2},{"$f":"J6/H11","v":3.4890264490714688E-2},{"$f":"M50","v":6294},{"$f":"L6/K11","v":4.8225200471036837E-2},{"$f":"M6/K11","v":4.718779790276454E-2},{"$f":"P50","v":6523},{"$f":"O6/N11","v":4.1970201793281904E-2},2.7441361336808218E-2,{"$f":"S50","v":6318},{"$f":"R6/Q11","v":3.7513771597947373E-2},2.6274137385248496E-2,{"$f":"V50","v":7335},{"$f":"U6/T11","v":2.3176550783912748E-2},2.1131561008861623E-2,null,{"$f":"Z50","v":7325},{"$f":"Y6/X11","v":2.3208191126279865E-2},2.0750853242320819E-2,null,7683,{"$f":"AC6/AB11","v":1.8222048678901471E-2},1.7310946244956396E-2,null,8276,{"$f":"AG6/AF11","v":1.6916384726921217E-2},0]
[]
[]
[]
[]
[null,"FY2004 ",null,null,"FY2005",null,null,"FY2006 ",null,null,"FY2007",null,null,"FY 2008",null,null,"FY 2009",null,null,"FY 2010",null,null,"FY 2011",null,null,null,"FY 2012",null,null,null,"FY 2013"]
[]
["Region","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C Served","# of Eligible Households","# of Eligible Households Category B Served","# of Eligible Households Category C Served","# of Eligible Households",null,"# of Eligible Households Category B Served","# of Eligible Households Category C Served","# of Eligible Households",null,"# of Eligible Households Category B Served","# of Eligible Households Category C Served","# of Eligible Households",null,"# of Eligible Households Category B Served","# of Eligible Households Category C Served"]
["ALASKA",806,6,31,987,16,26,1153,16,16,668,10,17,1090,7,16,1269,12,16,1361,1,16,1451,null,8,16,1652,null,2,18,1954]
["EASTERN OKLAHOMA",369,13,4,683,24,6,411,11,6,346,15,5,332,8,3,35,1,0,65,3,0,145,null,4,0,194,null,8,1,206]
["EASTERN ",50,13,2,67,19,6,76,3,2,81,4,2,75,3,1,95,7,1,74,1,0,68,null,7,0,105,null,10,0,106]
["GREAT PLAINS",615,11,31,779,10,28,997,11,30,813,6,34,870,10,17,1023,17,12,1279,9,18,1090,null,6,14,1453,null,9,15,1875]
["MIDWEST",462,9,14,250,12,12,242,3,7,317,5,8,423,7,6,372,3,6,164,4,1,304,null,1,4,307,null,5,1,335]
["NAVAJO",633,2,38,1022,2,31,778,0,36,626,0,35,684,1,18,515,7,3,583,0,10,666,null,0,9,693,null,0,10,702]
["NORTHWEST",148,1,3,144,1,3,160,4,3,172,1,5,171,5,1,252,6,1,366,11,0,339,null,11,0,117,null,1,1,173]
["PACIFIC",477,4,10,606,4,10,702,6,22,579,1,21,711,6,12,847,7,12,845,8,12,795,null,2,12,858,null,5,10,514]
["ROCKY MOUNTAIN",437,22,6,581,14,10,653,15,6,750,21,12,341,10,3,363,7,3,509,10,5,728,null,10,5,767,null,8,4,680]
["SOUTHERN PLAINS",541,12,16,486,12,16,548,19,7,576,15,11,597,2,9,604,3,7,567,3,6,559,null,3,6,559,null,3,5,564]
["SOUTHWEST",404,5,12,365,5,12,396,1,13,376,12,2,337,2,6,283,3,4,228,2,3,251,null,1,3,166,null,1,2,166]
["WESTERN",887,6,22,989,13,22,992,13,30,995,7,48,892,4,22,890,11,17,1127,19,13,929,null,10,20,812,null,4,10,1001]
["TOTAL",5829,104,189,6959,132,182,7108,{"$f":"SUM(I20:I30)","v":86},{"$f":"SUM(J20:J30)","v":162},{"$f":"SUM(K19:K30)","v":6299},{"$f":"SUM(L19:L30)","v":97},200,6523,65,114,6548,84,82,7168,{"$f":"SUM(U19:U30)","v":71},{"$f":"SUM(V19:V30)","v":84},7325,null,63,89,7683,null,56,77,8276]
[null,null,"Total Served",293,null,"Total Served",314,null,"Total Served",{"$f":"I31+J31","v":248},null,null,{"$f":"L31+M31","v":297},null,null,{"$f":"O31+P31","v":179},null,null,{"$f":"R31+S31","v":166},null,null,{"$f":"SUM(U31:V31)","v":155},null,null,null,{"$f":"SUM(Y31:Z31)","v":152},null,null,null,133]
[]
[]
[null,"2004 Percent",null,null,"2005 Percent",null,null,"2006 Percent",null,null,"2007 Percent",null,null,"2008 Percent",null,null,"2009 Percent",null,null,"2010 Percent",null,null,"2011 Percent",null,null,null,"2012 Percent",null,null,null,"2013 Percent"]
[]
["Region","# of Eligible Applicants     Cat B","# of Eligible Applicants       Cat C","Total","# of Eligible Applicants        Cat B","# of Eligible Applicants        Cat C","Total","# of Eligible Applicants         Cat B","# of Eligible Applicants         Cat C","Total","# of Eligible Applicants     Cat B","# of Eligible Applicants         Cat C","Total","# of Eligible Applicants             Cat B","# of Eligible Applicants        Cat C","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants             Cat C","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants             Cat C","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total","# of Eligible Applicants       Cat B","# of Eligible Applicants       Cat C-1","# of Eligible Applicants             Cat C-2","Total"]
["ALASKA",306,500,{"$f":"SUM(B38:C38)","v":806},342,645,{"$f":"SUM(E38:F38)","v":987},374,779,{"$f":"SUM(H38:I38)","v":1153},235,433,{"$f":"SUM(K38:L38)","v":668},365,725,{"$f":"SUM(N38:O38)","v":1090},459,797,{"$f":"SUM(Q38:R38)","v":1256},474,887,{"$f":"SUM(T38:U38)","v":1361},477,665,309,{"$f":"SUM(W38:Y38)","v":1451},536,781,335,{"$f":"SUM(AA38:AC38)","v":1652},590,954,410,{"$f":"SUM(AE38:AG38)","v":1954}]
["EASTERN OKLAHOMA",26,24,{"$f":"SUM(B39:C39)","v":50},44,23,{"$f":"SUM(E39:F39)","v":67},355,56,{"$f":"SUM(H39:I39)","v":411},339,7,{"$f":"SUM(K39:L39)","v":346},320,12,{"$f":"SUM(N39:O39)","v":332},33,2,{"$f":"SUM(Q39:R39)","v":35},54,11,{"$f":"SUM(T39:U39)","v":65},141,4,0,{"$f":"SUM(W39:Y39)","v":145},78,10,17,{"$f":"SUM(AA39:AC39)","v":105},198,8,0,{"$f":"SUM(AE39:AG39)","v":206}]
["EASTERN ",314,55,369,655,28,683,65,11,76,71,9,80,43,32,75,37,58,95,44,30,74,27,37,4,68,194,0,0,194,74,24,8,106]
["GREAT PLAINS",229,386,615,270,509,779,315,682,997,260,553,813,247,623,870,350,677,1027,258,1021,1279,366,634,90,1090,540,647,266,1453,528,984,363,1875]
["MIDWEST",136,326,462,133,117,250,83,159,242,154,163,317,191,232,423,153,219,372,93,71,164,218,49,37,304,237,44,26,307,232,64,39,335]
["NAVAJO",19,614,633,21,1001,1022,11,767,778,2,624,626,2,682,684,0,510,510,0,583,583,0,350,316,666,0,364,329,693,0,469,233,702]
["NORTHWEST",85,63,148,90,54,144,90,70,160,102,70,172,103,68,171,173,79,252,231,105,336,235,77,27,339,50,59,8,117,89,64,20,173]
["PACIFIC",100,377,477,88,518,606,93,609,702,57,518,575,104,607,711,104,607,711,126,719,845,147,217,431,795,143,253,462,858,131,185,198,514]
["ROCKY MOUNTAIN",137,300,437,417,164,581,466,187,653,161,589,750,250,91,341,224,139,363,264,245,509,510,195,23,728,535,203,29,767,527,127,26,680]
["SOUTHERN PLAINS",449,92,541,391,95,486,414,134,548,460,116,576,489,108,597,442,162,604,413,154,567,409,134,16,559,409,134,16,559,407,134,23,564]
["SOUTHWEST",182,222,404,151,214,365,137,259,396,92,284,376,135,202,337,82,201,283,57,171,228,58,117,76,251,47,59,60,166,47,59,60,166]
["WESTERN",326,561,887,302,687,989,246,746,992,242,753,995,224,668,892,105,705,810,289,1035,1324,222,64,643,929,216,98,498,812,166,203,632,1001]
["TOTAL",{"$f":"SUM(B38:B49)","v":2309},{"$f":"SUM(C38:C49)","v":3520},{"$f":"SUM(D38:D49)","v":5829},2904,4055,{"$f":"SUM(E50:F50)","v":6959},2649,4459,7108,{"$f":"SUM(K38:K49)","v":2175},{"$f":"SUM(L38:L49)","v":4119},6294,{"$f":"SUM(N38:N49)","v":2473},{"$f":"SUM(O38:O49)","v":4050},6523,{"$f":"SUM(Q38:Q49)","v":2162},{"$f":"SUM(R38:R49)","v":4156},6318,{"$f":"SUM(T38:T49)","v":2303},{"$f":"SUM(U38:U49)","v":5032},{"$f":"SUM(T50:U50)","v":7335},{"$f":"SUM(W38:W49)","v":2810},{"$f":"SUM(X38:X49)","v":2543},{"$f":"SUM(Y38:Y49)","v":1972},7325,{"$f":"SUM(AA38:AA49)","v":2985},{"$f":"SUM(AB38:AB49)","v":2652},{"$f":"SUM(AC38:AC49)","v":2046},{"$f":"SUM(AD38:AD49)","v":7683},2989,3275,2012,8276]