{"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"]
[" 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":377684.58600000001},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":390373.35330000002},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":446348.4633},339551]
["Boston",0.1232,0.12590000000000001,0.12455000000000001,{"$f":"ROUND(D11*0.9,4)","v":0.11210000000000001},{"$f":"E11*$F$27","v":1568090.4478},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":1058224.6302},1119864,0.1341,0.1401,0.1371,{"$f":"ROUND(P11*0.9,4)","v":0.1234},{"$f":"Q11*$R$27","v":2032450.1982},1680212]
["Bristol County",6.7900000000000002E-2,7.3099999999999998E-2,7.0500000000000007E-2,6.3500000000000001E-2,888258.19299999997,724768,7.2400000000000006E-2,7.8899999999999998E-2,7.5649999999999995E-2,6.8099999999999994E-2,926286.59789999994,877469,6.2899999999999998E-2,6.7199999999999996E-2,6.5049999999999997E-2,5.8500000000000003E-2,963519.74550000008,788108]
["Brockton",4.7800000000000002E-2,5.6599999999999998E-2,5.2199999999999996E-2,4.7E-2,657450.946,510220,4.7399999999999998E-2,4.53E-2,4.6350000000000002E-2,4.1700000000000001E-2,567197.52029999997,574476,4.82E-2,5.8299999999999998E-2,5.3249999999999999E-2,4.7899999999999998E-2,788933.26169999992,603924]
["Cape Cod & Islands",4.3999999999999997E-2,4.9399999999999999E-2,4.6699999999999998E-2,4.2000000000000003E-2,587509.35600000003,469658,4.5499999999999999E-2,5.3499999999999999E-2,4.9500000000000002E-2,4.4600000000000001E-2,606642.91139999998,551448,4.1799999999999997E-2,4.6800000000000001E-2,4.4299999999999999E-2,3.9899999999999998E-2,657169.87769999995,523735]
["Central Mass",7.3999999999999996E-2,6.9800000000000001E-2,7.1899999999999992E-2,6.4699999999999994E-2,905044.17459999991,789880,7.6700000000000004E-2,8.5800000000000001E-2,8.1250000000000003E-2,7.3099999999999998E-2,994295.89289999998,929584,7.0999999999999994E-2,6.8699999999999997E-2,6.9849999999999995E-2,6.2899999999999998E-2,1035989.6067,889597]
["Franklin/Hampshire",2.81E-2,2.5700000000000001E-2,2.69E-2,2.4199999999999999E-2,338517.29560000001,299941,3.1199999999999999E-2,3.5499999999999997E-2,3.3349999999999998E-2,0.03,408055.76999999996,378136,4.6300000000000001E-2,4.3499999999999997E-2,4.4899999999999995E-2,4.0399999999999998E-2,665405.08919999993,580118]
["Greater Lowell",3.8300000000000001E-2,4.1399999999999999E-2,3.9849999999999997E-2,3.5900000000000001E-2,502180.61620000005,408816,4.6100000000000002E-2,4.65E-2,4.6300000000000001E-2,4.1700000000000001E-2,567197.52029999997,558720,3.6499999999999998E-2,3.9600000000000003E-2,3.805E-2,3.4200000000000001E-2,563288.46660000004,457328]
["Gtr New Bedford",4.99E-2,5.6800000000000003E-2,5.3350000000000002E-2,4.8000000000000001E-2,671439.26399999997,532635,4.87E-2,5.3499999999999999E-2,5.11E-2,4.5999999999999999E-2,625685.51399999997,590232,4.9200000000000001E-2,5.5899999999999998E-2,5.2549999999999999E-2,4.7300000000000002E-2,779051.00790000008,616453]
["Hampden County",0.14019999999999999,0.16889999999999999,0.15454999999999999,0.1391,1945775.0338000001,1496502,7.2400000000000006E-2,8.3299999999999999E-2,7.7850000000000003E-2,7.0099999999999996E-2,953490.31589999993,877469,0.14000000000000001,0.16819999999999999,0.15410000000000001,0.13869999999999999,2284447.6700999998,1754136]
["Merrimack Valley",6.2600000000000003E-2,6.2100000000000002E-2,6.2350000000000003E-2,5.6099999999999997E-2,784744.6398,668196,6.0299999999999999E-2,6.4399999999999999E-2,6.2350000000000003E-2,5.6099999999999997E-2,763064.28989999997,730821,5.9900000000000002E-2,5.91E-2,5.9499999999999997E-2,5.3600000000000002E-2,882814.67280000006,750520]
["Metro North",7.2099999999999997E-2,5.8999999999999997E-2,6.5549999999999997E-2,5.8999999999999997E-2,825310.76199999999,769599,0.10680000000000001,7.5300000000000006E-2,9.1050000000000006E-2,8.1900000000000001E-2,1113992.2520999999,1294389,6.8199999999999997E-2,5.2200000000000003E-2,6.0200000000000004E-2,5.4199999999999998E-2,892696.92660000001,854515]
["Metro South/West",6.8900000000000003E-2,5.28E-2,6.0850000000000001E-2,5.4800000000000001E-2,766559.82640000002,735442,9.1200000000000003E-2,9.2899999999999996E-2,9.2049999999999993E-2,8.2799999999999999E-2,1126233.9251999999,1105321,7.3300000000000004E-2,5.67E-2,6.5000000000000002E-2,5.8500000000000003E-2,963519.74550000008,918415]
["North Central",3.5900000000000001E-2,3.6499999999999998E-2,3.6199999999999996E-2,3.2599999999999997E-2,456019.16679999995,383198,3.9699999999999999E-2,4.4400000000000002E-2,4.2050000000000004E-2,3.78E-2,514150.27020000003,481154,2.98E-2,3.3000000000000002E-2,3.1399999999999997E-2,2.8299999999999999E-2,466112.97089999996,373380]
["North Shore",5.6800000000000003E-2,4.02E-2,4.8500000000000001E-2,4.3700000000000003E-2,611289.49660000007,606286,6.3399999999999998E-2,5.7500000000000002E-2,6.0450000000000004E-2,5.4399999999999997E-2,739941.12959999999,768392,5.33E-2,3.5799999999999998E-2,4.4549999999999999E-2,4.0099999999999997E-2,660463.9622999999,667825]
["South Shore",6.3299999999999995E-2,4.87E-2,5.5999999999999994E-2,5.04E-2,705011.22719999996,675667,7.5300000000000006E-2,6.9400000000000003E-2,7.2349999999999998E-2,6.5100000000000005E-2,885481.02090000012,912617,5.8400000000000001E-2,4.1799999999999997E-2,5.0099999999999999E-2,4.5100000000000001E-2,742816.0773,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":12590885.0318},10674051,1,0.99999999999999989,{"$f":"SUM(J10:J25)","v":1},{"$f":"SUM(K10:K25)","v":0.89990000000000003},{"$f":"SUM(L10:L25)","v":12240312.914099999},12119744,0.99999999999999989,1,{"$f":"SUM(P10:P25)","v":1},{"$f":"SUM(Q10:Q25)","v":0.90010000000000012},{"$f":"SUM(R10:R25)","v":14825027.7423},12529542]
["FY23 Total Workforce Area Program Share",null,null,null,null,13988318,null,null,null,null,null,13601859,null,null,null,null,null,16470423]
["FY23 Total State Program Allotment",null,null,null,null,16456845,null,null,null,null,null,22669765,null,null,null,null,null,19376968]
["FY 2023 (PY 2022)  WIOA State Allotments were provided in Training and Employmnet Guidance Letter No. 9-21, May 6, 2022."]
["Hold  Harmless:  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 are based on the Allotments provided by ETA in Training and Employment Guidance Letter No. 9-21, Workforce Innnovaton and Opportunity Act (WIOA) Adult, Dislocated Worker and Youth Activities Program Allotments for Program Year (PY) 2022; PY 2022 Allotments for the Wagner-Peyser Act Employment Service (ES) Program; and PY 2022 Allotments of Workforce Information Grants to States. "]
[]
["MassHire Department of Career Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Prepared:  05.13.22"]