{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["EST Hold Harmless FY23"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"EST Hold Harmless FY23","index":0,"n_rows":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,3,32,10],[0,0,0,18],[1,0,1,18],[3,7,3,10],[4,0,8,0],[4,1,5,6],[4,7,5,12],[4,13,5,18],[6,1,6,4],[6,7,6,10],[6,13,6,16],[7,1,7,4],[7,7,7,10],[7,13,7,16],[30,0,30,18]]}
["COMMONWEALTH OF MASSACHUSETTS"]
["ESTIMATED HOLD HARMLESS ALLOCATIONS FOR FISCAL YEAR 2023 AND ALLOCATIONS FOR FISCAL YEAR 2022 COMPARED\n FOR WIOA TITLE I ADULT,  DISLOCATED WORKER, AND YOUTH PROGRAMS"]
[]
[]
["MASSHIRE\nWORKFORCE \nAREAS","WIOA TITLE I ADULT HOLD HARMLESS ALLOCATION ESTIMATES FOR FY 2023",null,null,null,null,null,"WIOA TITLE I DISLOCATED WORKER HOLD HARMLESS ALLOCATION ESTIMATES FOR FY 2023",null,null,null,null,null,"WIOA TITLE 1 YOUTH HOLD HARMLESS ALLOCATION ESTIMATES FOR FY23"]
[]
[null,"FY23 Adult Hold-Harmless Level ",null,null,null,"FY 2023","Adult Total","FY23 DW Hold-Harmless Level ",null,null,null,"FY 2023","DW Total","FY23Youth Hold-Harmless Level ",null,null,null,"FY 2023","Youth Total"]
[null,"90% of the Average Adult Share for the Prior 2 Years",null,null,null,"Adult Estimate","Allocation","90% of the Average DW Share for the Prior 2 Years",null,null,null,"DW Estimate","Allocation","90% of the Average Youth Share for the Prior 2 Years",null,null,null,"Youth Estimate","Allocation"]
[null,"FY22","FY21","Average","90%HH","HOLD HARMLESS","FY 2022","FY22","FY21","Average","90% HH","HOLD HARMLESS","FY 2022","FY22","FY21","Average","90%HH","HOLD HARMLESS","FY 2022"]
["Berkshire County",2.7E-2,3.3099999999999997E-2,{"$f":"+(B10+C10)/2","v":3.005E-2},{"$f":"ROUND(D10*0.9,4)","v":2.7E-2},{"$f":"E10*$F$27","v":374659.18199999997},288199,3.0499999999999999E-2,3.3300000000000003E-2,{"$f":"+(H10+I10)/2","v":3.1899999999999998E-2},{"$f":"ROUND(J10*0.9,4)","v":2.87E-2},{"$f":"K10*$L$27","v":385736.4952},369652,2.7099999999999999E-2,3.3099999999999997E-2,{"$f":"+(N10+O10)/2","v":3.0099999999999998E-2},{"$f":"ROUND(P10*0.9,4)","v":2.7099999999999999E-2},{"$f":"Q10*$R$27","v":441415.77549999999},339551]
["Boston",0.1232,0.12590000000000001,0.12455000000000001,{"$f":"ROUND(D11*0.9,4)","v":0.11210000000000001},{"$f":"E11*$F$27","v":1555529.4186},1315043,9.2399999999999996E-2,8.0500000000000002E-2,{"$f":"+(H11+I11)/2","v":8.6449999999999999E-2},{"$f":"ROUND(J11*0.9,4)","v":7.7799999999999994E-2},{"$f":"K11*$L$27","v":1045655.0288},1119864,0.1341,0.1401,0.1371,{"$f":"ROUND(P11*0.9,4)","v":0.1234},{"$f":"Q11*$R$27","v":2009989.1769999999},1680212]
["Bristol County",6.7900000000000002E-2,7.3099999999999998E-2,7.0500000000000007E-2,6.3500000000000001E-2,881142.89100000006,724768,7.2400000000000006E-2,7.8899999999999998E-2,7.5649999999999995E-2,6.8099999999999994E-2,915284.15759999992,877469,6.2899999999999998E-2,6.7199999999999996E-2,6.5049999999999997E-2,5.8500000000000003E-2,952871.6925,788108]
["Brockton",4.7800000000000002E-2,5.6599999999999998E-2,5.2199999999999996E-2,4.7E-2,652184.50199999998,510220,4.7399999999999998E-2,4.53E-2,4.6350000000000002E-2,4.1700000000000001E-2,560460.3432,574476,4.82E-2,5.8299999999999998E-2,5.3249999999999999E-2,4.7899999999999998E-2,780214.59950000001,603924]
["Cape Cod & Islands",4.3999999999999997E-2,4.9399999999999999E-2,4.6699999999999998E-2,4.2000000000000003E-2,582803.17200000002,469658,4.5499999999999999E-2,5.3499999999999999E-2,4.9500000000000002E-2,4.4600000000000001E-2,599437.20160000003,551448,4.1799999999999997E-2,4.6800000000000001E-2,4.4299999999999999E-2,3.9899999999999998E-2,649907.35950000002,523735]
["Central Mass",7.3999999999999996E-2,6.9800000000000001E-2,7.1899999999999992E-2,6.4699999999999994E-2,897794.41019999993,789880,7.6700000000000004E-2,8.5800000000000001E-2,8.1250000000000003E-2,7.3099999999999998E-2,982485.63760000002,929584,7.0999999999999994E-2,6.8699999999999997E-2,6.9849999999999995E-2,6.2899999999999998E-2,1024540.6745,889597]
["Franklin/Hampshire",2.81E-2,2.5700000000000001E-2,2.69E-2,2.4199999999999999E-2,335805.6372,299941,3.1199999999999999E-2,3.5499999999999997E-2,3.3349999999999998E-2,0.03,403208.88,378136,4.6300000000000001E-2,4.3499999999999997E-2,4.4899999999999995E-2,4.0399999999999998E-2,658051.56199999992,580118]
["Greater Lowell",3.8300000000000001E-2,4.1399999999999999E-2,3.9849999999999997E-2,3.5900000000000001E-2,498157.94940000004,408816,4.6100000000000002E-2,4.65E-2,4.6300000000000001E-2,4.1700000000000001E-2,560460.3432,558720,3.6499999999999998E-2,3.9600000000000003E-2,3.805E-2,3.4200000000000001E-2,557063.451,457328]
["Gtr New Bedford",4.99E-2,5.6800000000000003E-2,5.3350000000000002E-2,4.8000000000000001E-2,666060.76800000004,532635,4.87E-2,5.3499999999999999E-2,5.11E-2,4.5999999999999999E-2,618253.61600000004,590232,4.9200000000000001E-2,5.5899999999999998E-2,5.2549999999999999E-2,4.7300000000000002E-2,770441.55650000006,616453]
["Hampden County",0.14019999999999999,0.16889999999999999,0.15454999999999999,0.1391,1930188.6006,1496502,7.2400000000000006E-2,8.3299999999999999E-2,7.7850000000000003E-2,7.0099999999999996E-2,942164.74959999998,877469,0.14000000000000001,0.16819999999999999,0.15410000000000001,0.13869999999999999,2259201.7734999997,1754136]
["Merrimack Valley",6.2600000000000003E-2,6.2100000000000002E-2,6.2350000000000003E-2,5.6099999999999997E-2,778458.52259999991,668196,6.0299999999999999E-2,6.4399999999999999E-2,6.2350000000000003E-2,5.6099999999999997E-2,754000.60560000001,730821,5.9900000000000002E-2,5.91E-2,5.9499999999999997E-2,5.3600000000000002E-2,873058.50800000003,750520]
["Metro North",7.2099999999999997E-2,5.8999999999999997E-2,6.5549999999999997E-2,5.8999999999999997E-2,818699.6939999999,769599,0.10680000000000001,7.5300000000000006E-2,9.1050000000000006E-2,8.1900000000000001E-2,1100760.2424000001,1294389,6.8199999999999997E-2,5.2200000000000003E-2,6.0200000000000004E-2,5.4199999999999998E-2,882831.55099999998,854515]
["Metro South/West",6.8900000000000003E-2,5.28E-2,6.0850000000000001E-2,5.4800000000000001E-2,760419.37679999997,735442,9.1200000000000003E-2,9.2899999999999996E-2,9.2049999999999993E-2,8.2799999999999999E-2,1112856.5088,1105321,7.3300000000000004E-2,5.67E-2,6.5000000000000002E-2,5.8500000000000003E-2,952871.6925,918415]
["North Central",3.5900000000000001E-2,3.6499999999999998E-2,3.6199999999999996E-2,3.2599999999999997E-2,452366.27159999998,383198,3.9699999999999999E-2,4.4400000000000002E-2,4.2050000000000004E-2,3.78E-2,508043.1888,481154,2.98E-2,3.3000000000000002E-2,3.1399999999999997E-2,2.8299999999999999E-2,460961.8615,373380]
["North Shore",5.6800000000000003E-2,4.02E-2,4.8500000000000001E-2,4.3700000000000003E-2,606392.82420000003,606286,6.3399999999999998E-2,5.7500000000000002E-2,6.0450000000000004E-2,5.4399999999999997E-2,731152.10239999997,768392,5.33E-2,3.5799999999999998E-2,4.4549999999999999E-2,4.0099999999999997E-2,653165.0405,667825]
["South Shore",6.3299999999999995E-2,4.87E-2,5.5999999999999994E-2,5.04E-2,699363.8064,675667,7.5300000000000006E-2,6.9400000000000003E-2,7.2349999999999998E-2,6.5100000000000005E-2,874963.26960000012,912617,5.8400000000000001E-2,4.1799999999999997E-2,5.0099999999999999E-2,4.5100000000000001E-2,734607.06550000003,731725]
["TOTAL HH 90%",0.99999999999999989,1,{"$f":"SUM(D10:D25)","v":1},{"$f":"SUM(E10:E25)","v":0.90009999999999979},{"$f":"SUM(F10:F25)","v":12490027.026600001},10674051,1,0.99999999999999989,{"$f":"SUM(J10:J25)","v":1},{"$f":"SUM(K10:K25)","v":0.89990000000000003},{"$f":"SUM(L10:L25)","v":12094922.3704},12119744,0.99999999999999989,1,{"$f":"SUM(P10:P25)","v":1},{"$f":"SUM(Q10:Q25)","v":0.90010000000000012},{"$f":"SUM(R10:R25)","v":14661193.340499999},12529542]
["FY23 Total Estimated Workforce Area Program Share",null,null,null,null,13876266,null,null,null,null,null,13440296,null,null,null,null,null,16288405]
["FY23 Total Estimated State Program Allotment",null,null,null,null,16325019,null,null,null,null,null,22400494,null,null,null,null,null,19162829]
["FY 2023 Estimated WIOA State Allotments were provided in Training and Employmnet Notice (TEN) 20-21, issued on Febriary 2. 2022"]
["Hold  Haemless:  Each MassHIre Workforce Area must receive a minimum percentage (or stop loss) to ensure that no local area receives an allocation percentage that is less than 90 percent of the average allocation percentage received by the local area for the previous two years (FY22 and FY21)."]
["Important Note:  The funding levels in TEN 20-21 can provide states with a general idea of how their funding may change in FY232.   Data are not meant to predict allocations.  ETA: 1) used the data that ETA will use to calculate the actual FY 2023 allotments, and 2) estimated funding based on the full year FY 2022 funding levels for these programs. "]
[]
["MassHire Department of Career Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Prepared:  02.03.22"]