{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Compare FY27 FY26 06162026","Adult FY27 06162026"," Youth FY27 06162026","Dis Wrk FY27 0662026"," Awards FY27 Adult 06162026 "," Awards FY27 Youth 06162026","Awards FY27 DWrk 06162026","Adult HH ","Youth HH"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":9,"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":"Compare FY27 FY26 06162026","index":0,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,3,33,9],[6,14,8,14],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,5,9,5],[7,10,9,10],[7,11,9,11],[5,5,6,8],[5,9,6,12],[7,8,9,8],[7,9,9,9],[0,0,0,12],[5,0,9,0],[5,1,6,4],[7,6,9,6],[7,7,9,7],[7,12,9,12]]}
["ATTACHMENT - 1 "]
[null,null,null,null,null,"                                 COMMONWEALTH OF MASSACHUSETTS"]
[null,null,null,"                                                                                                                               INITIAL ALLOCATIONS FOR  FISCAL YEAR 2027 AND ALLOCATIONS FOR FISCAL YEAR 2026 COMPARED"]
[null,null,null,null,"FOR WIOA TITLE I ADULT, YOUTH, AND DISLOCATED WORKER"]
[]
["MASSHIRE\nWORKFORCE \nAREAS","WIOA TITLE I ADULT  ",null,null,null,"          WIOA TITLE I DISLOCATED WORKER ",null,null,null,"WIOA TITLE I YOUTH"]
[]
[null,"\nFY 2026\nAllocation","Initial\nFY 2027\nAllocation1","Change \nfrom \nFY 2026","% Change\nfrom\nFY 2026","\nFY 2026\nAllocation","Initial \nFY 2027\nAllocation1","Change \nfrom \nFY 2026","% Change\nfrom\nFY 2026","\nFY 2026\nAllocation","Initial \nFY 2027\nAllocation1","Change \nfrom \nFY 2026","% Change\nfrom\nFY 2026"]
[]
[]
["Berkshire County",273390,336229,{"$f":"C11-B11","v":62839},{"$f":"D11/B11","v":0.2298511284245949},299163,289218,{"$f":"G11-F11","v":-9945},{"$f":"H11/F11","v":-3.3242747264868984E-2},324758,411589,{"$f":"K11-J11","v":86831},{"$f":"L11/J11","v":0.26737139654758313}]
["Boston",1732295,2025378,{"$f":"C12-B12","v":293083},0.16918769609102377,1073340,921014,{"$f":"G12-F12","v":-152326},-0.14191775206365179,2220412,2677218,{"$f":"K12-J12","v":456806},0.20573028789251724]
["Bristol County",721997,898211,176214,0.24406472603071758,700192,645670,-54522,-7.7867213564279517E-2,745794,955340,209546,0.28097034838038387]
["Brockton",680989,797342,116353,0.17085885381408511,494316,505864,11548,2.3361574377523689E-2,802647,957228,154581,0.1925890210765131]
["Cape Cod & Islands",721997,845375,123378,{"$f":"D15/B15","v":0.17088436655553971},562941,486654,-76287,-0.13551508950316285,797306,944012,146706,0.18400212716322215]
["Central Mass",914612,1301686,387074,0.42321115401940934,810635,806223,-4412,-5.4426468139174844E-3,1036983,1483987,447004,0.4310620328394969]
["Franklin/Hampshire",319369,509146,189777,0.5942248621500521,331331,358967,27636,8.3409038091817544E-2,610344,932684,322340,0.52812839972212389]
["Greater Lowell",369076,445103,76027,0.2059928036501967,537207,532511,-4696,-8.7415093250832552E-3,399481,490886,91405,0.22880938017077157]
["Gtr New Bedford",513227,938238,425011,0.82811504460988994,499677,475803,-23874,-4.777886514688489E-2,576230,1013869,437639,0.75948666331152492]
["Hampden County",1548378,1790018,241640,0.15606008351965733,748444,738871,-9573,-1.279053609889317E-2,1672882,2005082,332200,0.19857945748713896]
["Merrimack Valley",1046336,1197615,151279,0.14457975258425593,632639,639750,7111,1.1240217564835554E-2,1150515,1338609,188094,0.16348678635219879]
["Metro North",1052550,1484210,431660,0.41010878343071588,1043318,1102321,59003,5.6553227299826134E-2,1253817,1646357,392540,0.31307599115341395]
["Metro South/West",726968,867790,140822,0.19371141508291975,1120520,1100873,-19647,-1.75338235819084E-2,926853,1125262,198409,0.21406738716927065]
["North Central",428725,664452,235727,0.54983264330281645,466437,493954,27517,5.8994033492197229E-2,421036,674025,252989,0.60087260946807397]
["North Shore",672290,895009,222719,0.33128411846078332,629422,803494,174072,0.2765584933478652,705087,1053517,348430,0.4941659681713037]
["South Shore",704600,1015091,310491,0.44066278739710474,773106,771047,-2059,-2.6632829133391798E-3,725676,1170575,444899,0.61308214685341667]
["TOTAL",12426799,16010892,{"$f":"C27-B27","v":3584093},0.28841642968555298,10722688,10672234,{"$f":"G27-F27","v":-50454},{"$f":"H27/F27","v":-4.705350001790596E-3},14369821,18880241,4510420,0.31388143248270106]
[]
["FY 2027 Total allotment for workforce areas assumes Governor's Reserve for statewide activities at 15% for the period 7/1/26 - 6/30/27."]
["1.  FY 2027 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 10-25, April 28,2026"]
[]
["       SSTA Combo Codes:","             WIOA ADULT RETAINED DCSL_FWIA_ADT_RT_EOL24O",null,null,null,"WIOA YOUTH RETAINED DCSL_FWIA_YTH_RT_EOL241",null,null,null,"WIOA DISLOCATED WORKER RETAINED DESL_FWIA_DWK_RT_EOL242"]
[]
["MassHire Department of Career Services",null,null,null,null,null,null,null,null,null,"Date:","2026-06-16"]

{"sheet":"Adult FY27 06162026","index":1,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15],[4,0,8,0],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,8,4,11],[6,1,7,2],[6,3,7,4],[5,1,5,2],[6,5,7,6],[6,8,6,11],[7,8,7,11],[34,5,34,12],[5,3,5,4],[5,5,5,6],[5,8,5,11],[5,22,5,23],[5,27,5,30],[6,20,7,21],[6,24,7,25],[4,19,8,19],[4,20,4,21],[4,22,4,23],[6,22,7,23],[6,27,6,30],[7,27,7,30],[4,24,4,25],[4,27,4,30],[5,20,5,21],[5,24,5,25]]}
["ATTACHMENT  - 2"]
["COMMONWEALTH OF MASSACHUSETTS"]
[" FISCAL YEAR 2027 WIOA TITLE I FORMULA ALLOCATION SHARES FOR ADULT ACTIVITIES\nWITH HOLD HARMLESS ADJUSTMENT "]
[]
["  MASSHIRE\nWORKFORCE \nAREAS","A",null,"B",null,"C",null,"D","E",null,null,null,"F","G","H","I"]
[null,"1/3 Weight",null,"1/3 Weight",null,"1/3 Weight",null,"Unadjusted","Hold Harmless Level FY27",null,null,null,"Adjusted",null,"Fiscal Year 2027"]
[null,"Disadvantaged\nAdults*",null,"Unemployed\nin ASUs",null,"Excess Unemployed\nin ASUs",null,"Formula","Hold-Harmless Level = 90% of ",null,null,null,"Formula","Total","Program 90%","Admin 10%"]
[null,null,null,null,null,null,null,"(A+B+C)/3","Avg Adult Share (Prior 2 Years) ",null,null,null,"Share**","Allocation","Amount","Amount"]
[null,"Count","Pct","Count","Pct","Count","Pct","Unadj Share","FY26","FY25","Average","90%HH","FY27","FY27","FY27","FY27"]
["Berkshire County",9020,{"$f":"+B10/460507","v":1.9587107253527091E-2},1939,{"$f":"+D10/107796","v":1.7987680433411257E-2},591,{"$f":"+F10/38522","v":1.5341882560614714E-2},{"$f":"+(C10+E10+G10)/3","v":1.7638890082517688E-2},2.1999999999999999E-2,2.4617816456007427E-2,{"$f":"+(I10+J10)/2","v":2.3308908228003713E-2},{"$f":"ROUND(K10*0.9,4)","v":2.1000000000000001E-2},2.1000000000000001E-2,{"$f":"ROUND(M10*$N$26,0)","v":336229},{"$f":"ROUND(N10*0.9,0)","v":302606},{"$f":"(N10-O10)","v":33623}]
["Boston",70920,{"$f":"+B11/460507","v":0.15400417366076954},12093,{"$f":"+D11/107796","v":0.1121841255705221},4192,{"$f":"+F11/38522","v":0.10882093349254972},0.12500307757461379,0.1394,0.14173552561847122,{"$f":"+(I11+J11)/2","v":0.14056776280923561},{"$f":"ROUND(K11*0.9,4)","v":0.1265},0.1265,{"$f":"ROUND(M11*$N$26,0)","v":2025378},{"$f":"ROUND(N11*0.9,0)","v":1822840},{"$f":"N11-O11","v":202538}]
["Bristol County",25014,5.4318392554293417E-2,6205,5.7562432743329991E-2,2438,6.328851046155444E-2,5.8389778586392625E-2,5.8099999999999999E-2,6.4615032467218669E-2,6.1357516233609334E-2,5.5199999999999999E-2,5.6099999999999997E-2,898211,{"$f":"ROUND(N12*0.9,0)","v":808390},89821]
["Brockton",15530,3.37237001826248E-2,6387,5.9250807080040074E-2,2239,5.8122631223716317E-2,5.0365712828793728E-2,5.4800000000000001E-2,5.3697962152410073E-2,5.4248981076205037E-2,4.8800000000000003E-2,4.9799999999999997E-2,797342,{"$f":"ROUND(N13*0.9,0)","v":717608},79734]
["Cape Cod & Islands",11780,2.5580501490748239E-2,6520,6.0484619095328214E-2,2290,5.944655002336327E-2,4.8503890203146577E-2,5.8099999999999999E-2,5.9338180824326854E-2,5.871909041216343E-2,5.28E-2,5.28E-2,845375,760838,84537]
["Central Mass",42118,9.1460064667855209E-2,10200,9.4623177112323278E-2,3088,8.0161985359015628E-2,8.8748409046398039E-2,7.3599999999999999E-2,6.8099999999999994E-2,7.0849999999999996E-2,6.3799999999999996E-2,8.1299999999999997E-2,1301686,1171517,130169]
["Franklin/Hampshire",16425,3.5667210270419344E-2,2680,2.4861775947159451E-2,1826,4.7401484865790974E-2,3.5976823694456588E-2,2.5700000000000001E-2,2.8302679103012825E-2,2.7001339551506413E-2,2.4299999999999999E-2,3.1800000000000002E-2,509146,458231,50915]
["Greater Lowell",19253,4.1808267843919854E-2,1169,1.0844558239637835E-2,1167,3.0294377238980322E-2,2.7649067774179335E-2,2.9700000000000001E-2,3.2099999999999997E-2,3.0899999999999997E-2,2.7799999999999998E-2,2.7799999999999998E-2,445103,400593,44510]
["Gtr New Bedford",18017,3.9124269555077341E-2,8702,8.0726557571709531E-2,3069,7.9668760708166766E-2,6.6506529278317891E-2,4.1300000000000003E-2,4.7764987183790825E-2,4.4532493591895414E-2,4.0099999999999997E-2,5.8599999999999999E-2,938238,844414,93824]
["Hampden County",46011,9.9913790669848665E-2,10516,9.7554640246391336E-2,4005,0.10396656456051087,0.10047833182558363,0.1246,0.12386864212312304,0.12423432106156151,0.1118,0.1118,1790018,{"$f":"ROUND(N19*0.9,0)","v":1611016},179002]
["Merrimack Valley",26402,5.7332461830113333E-2,8414,7.8054844335596868E-2,3327,8.6366232282851355E-2,7.3917846149520516E-2,8.4199999999999997E-2,8.1982436613971657E-2,8.309121830698582E-2,7.4800000000000005E-2,7.4800000000000005E-2,1197615,1077854,119761]
["Metro North",49290,0.10703420360602553,11463,0.10633975286652567,3717,9.6490317221328073E-2,0.10328809123129308,8.4699999999999998E-2,6.5500000000000003E-2,7.51E-2,6.7599999999999993E-2,9.2700000000000005E-2,1484210,1335789,148421]
["Metro South/West",36546,7.9360357171552223E-2,1287,1.1939218523878437E-2,423,1.0980738279424744E-2,3.4093437991618465E-2,5.8500000000000003E-2,6.2E-2,6.0249999999999998E-2,5.4199999999999998E-2,5.4199999999999998E-2,867790,781011,86779]
["North Central",19568,4.2492296534037487E-2,4768,4.4231696908976215E-2,1454,3.774466538601319E-2,4.1489552943008969E-2,3.4500000000000003E-2,3.6321948974648036E-2,3.5410974487324019E-2,3.1899999999999998E-2,4.1500000000000002E-2,664452,598007,66445]
["North Shore",28614,6.2135863298494923E-2,6815,6.3221269805929722E-2,2062,5.3527854213176886E-2,5.9628329105867177E-2,5.4100000000000002E-2,5.1254788483019446E-2,5.2677394241509724E-2,4.7399999999999998E-2,5.5899999999999998E-2,895009,805508,89501]
["South Shore",25999,5.6457339410692996E-2,8638,8.0132843519240049E-2,2634,6.837651212294274E-2,6.8322231684291926E-2,5.67E-2,5.8799999999999998E-2,5.7749999999999996E-2,5.1999999999999998E-2,6.3399999999999998E-2,1015091,{"$f":"ROUND(N25*0.9,0)","v":913582},101509]
["TOTAL",{"$f":"SUM(B10:B25)","v":460507},1.0000000000000002,{"$f":"SUM(D10:D25)","v":107796},{"$f":"SUM(E10:E25)","v":1},{"$f":"SUM(F10:F25)","v":38522},{"$f":"SUM(G10:G25)","v":0.99999999999999989},0.99998484285058375,1,{"$f":"SUM(J10:J25)","v":1},{"$f":"SUM(K10:K25)","v":1},{"$f":"SUM(L10:L25)","v":0.9},{"$f":"SUM(M10:M25)","v":1},16010892,{"$f":"ROUND(N26*0.9,0)","v":14409803},1601089]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N10:N26)","v":32021785},{"$f":"SUM(O10:O26)","v":28819607},{"$f":"SUM(P9:P9)","v":0}]
[]
["Data on ASU unemployed and ASU excess unemployment data are for the 7/1/24 - 6/30/25 benchmark period used for state ASU determination for FY27",null,null,null,null,null,null,null,null,null,null,null," ",null,"Program Name","WIOA ADT LOCAL"]
["   * Economically Disadvantaged Adult source: special tabulations of American Community Survey (ACS) from Census Bureau based on data collected 1/1/2016-12/31/20. ETA Reference TEGL 01-23, 7/31/2023.   ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Dates","7/1/2026-6/30/2027"]
["    **Unadjusted formula shares (D) were adjusted to ensure that each area's formula share was at or above the area's 90% hold-harmless level (E). Totals may not add due to rounding.",null,null,null,null,null,null,null,null,null,null,null,null,null,"SSTA Code RETAINED","DCSL_FWIA_ADT_RT_EOL24O"]
["FY 2027 total allotment for workforce areas assumes Governor's Reserve for statewide activities at 15% for the period 7/1/26 - 6/30/27.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phase Code",6502]
["FY 2027 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 10-25, April 28,2026",null,null,null,null,null,null,null,null,null,null,null,null,null,"Appropriation",70031630]
[]
["Prepared by:  MassHire Department of Career Services",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","2026-06-16"]

{"sheet":" Youth FY27 06162026","index":2,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,0,3,15],[5,0,9,0],[5,5,5,6],[5,8,5,11],[5,1,5,2],[5,3,5,4],[6,1,6,2],[7,1,8,2],[7,8,7,11],[7,5,8,6],[8,8,8,11],[35,5,35,12],[6,3,6,4],[6,5,6,6],[6,8,6,11],[7,3,8,4]]}
["ATTACHMENT  -  3"]
["COMMONWEALTH OF MASSACHUSETTS"]
["  FISCAL YEAR 2027 WIOA TITLE I FORMULA ALLOCATION SHARES FOR YOUTH ACTIVITIES\nWITH HOLD HARMLESS ADJUSTMENT"]
[]
[]
["MASSHIRE\nWORKFORCE \nAREAS","A",null,"B",null,"C",null,"D","E",null,null,null,"F","G","H","I"]
[null,"1/3 Weight",null,"1/3 Weight",null,"1/3 Weight",null,"Unadjusted","Hold Harmless Level FY27",null,null,null,"Adjusted","Fiscal Year 2027","Fiscal Year 2027","Fiscal Year 2027"]
[null,"Disadvantaged\nYouth*",null,"Unemployed\nin ASUs",null,"Excess Unemployed\nin ASUs",null,"Formula","Hold-Harmless Level = 90% of ",null,null,null,"Formula","Total","Program 90%","Admin 10%"]
[null,null,null,null,null,null,null,"(A+B+C)/3","Avg Youth Share (Prior 2 Years) ",null,null,null,"Share**","Allocation","Amount","Amount"]
[null,"Count","Pct","Count","Pct","Count","Pct","Unadj Share","FY26","FY25","Average","90%HH","FY27","FY27","FY27","FY27"]
["Berkshire County",2982,{"$f":"+B11/122769","v":2.4289519341201771E-2},1939,{"$f":"+D11/107796","v":1.7987680433411257E-2},591,{"$f":"+F11/38522","v":1.5341882560614714E-2},{"$f":"+(C11+E11+G11)/3","v":1.9206360778409249E-2},2.2599999999999999E-2,2.5765010704837683E-2,{"$f":"+(I11+J11)/2","v":2.4182505352418841E-2},{"$f":"ROUND(K11*0.9,4)","v":2.18E-2},2.18E-2,{"$f":"ROUND(M11*$N$27,0)","v":411589},{"$f":"ROUND(N11*0.9,0)","v":370430},{"$f":"N11-O11","v":41159}]
["Boston",25310,{"$f":"+B12/122769","v":0.20615953538759785},12093,{"$f":"+D12/107796","v":0.1121841255705221},4192,{"$f":"+F12/38522","v":0.10882093349254972},0.14238819815022322,0.15451918739754983,0.15845968693248297,0.1564894371650164,{"$f":"ROUND(K12*0.9,4)","v":0.14080000000000001},0.14180000000000001,{"$f":"ROUND(M12*$N$27,0)","v":2677218},{"$f":"ROUND(N12*0.9,0)","v":2409496},{"$f":"(N12-O12)","v":267722}]
["Bristol County",4075,3.3192418281488001E-2,6205,5.7562432743329991E-2,2438,6.328851046155444E-2,5.1347787162124146E-2,5.1900000000000002E-2,5.823556428636855E-2,5.506778214318428E-2,4.9599999999999998E-2,5.0599999999999999E-2,{"$f":"ROUND(M13*$N$27,0)","v":955340},{"$f":"ROUND(N13*0.9,0)","v":859806},{"$f":"N13-O13","v":95534}]
["Brockton",4455,3.6287662194853749E-2,6387,5.9250807080040074E-2,2239,5.8122631223716317E-2,5.1220366832870047E-2,5.5856440420348014E-2,5.4771122026035873E-2,5.5313781223191943E-2,4.9799999999999997E-2,5.0700000000000002E-2,957228,861505,95723]
["Cape Cod & Islands",1367,1.1134732709397323E-2,6520,6.0484619095328214E-2,2290,5.944655002336327E-2,4.3688633942696266E-2,5.5484733766967276E-2,5.5645838863991492E-2,5.5565286315479384E-2,0.05,0.05,{"$f":"ROUND(M15*$N$27,0)","v":944012},849611,{"$f":"(N15-O15)","v":94401}]
["Central Mass",11241,9.1562202184590574E-2,10200,9.4623177112323278E-2,3088,8.0161985359015628E-2,8.8782454885309836E-2,7.2163941493216657E-2,6.7000000000000004E-2,6.9581970746608324E-2,6.2600000000000003E-2,7.8600000000000003E-2,1483987,1335588,148399]
["Franklin/Hampshire",11495,9.3631128379313991E-2,2680,2.4861775947159451E-2,1826,{"$f":"+F17/38522","v":4.7401484865790974E-2},5.5298129730754798E-2,4.2473986563910993E-2,4.6853065368222369E-2,4.4663525966066681E-2,4.02E-2,4.9399999999999999E-2,932684,839416,93268]
["Greater Lowell",4559,3.7134781581669642E-2,1169,1.0844558239637835E-2,1167,3.0294377238980322E-2,2.6091239020095931E-2,2.7799999999999998E-2,2.98E-2,2.8799999999999999E-2,2.5899999999999999E-2,2.5999999999999999E-2,490886,441797,49089]
["Gtr New Bedford",3670,2.9893539900137656E-2,8702,8.0726557571709531E-2,3069,7.9668760708166766E-2,6.342961939333798E-2,4.0099999999999997E-2,4.5659328248753579E-2,4.2879664124376785E-2,3.8600000000000002E-2,5.3699999999999998E-2,1013869,912482,101387]
["Hampden County",9991,8.1380478785361129E-2,10516,9.7554640246391336E-2,4005,0.10396656456051087,9.4300561197421098E-2,0.11641636299931643,0.11965786456724327,0.11803711378327986,0.1062,0.1062,{"$f":"ROUND(M20*$N$27,0)","v":2005082},1804574,{"$f":"(N20-O20)","v":200508}]
["Merrimack Valley",5098,4.1525140711417378E-2,8414,7.8054844335596868E-2,3327,8.6366232282851355E-2,6.8648739109955212E-2,8.0064652744841994E-2,7.752319359316423E-2,7.8793923169003105E-2,7.0900000000000005E-2,7.0900000000000005E-2,1338609,1204748,{"$f":"(N21-O21)","v":133861}]
["Metro North",11839,9.6433138658781933E-2,11463,0.10633975286652567,3717,9.6490317221328073E-2,9.9754402915545215E-2,8.7253462180607505E-2,6.25E-2,7.4876731090303753E-2,6.7400000000000002E-2,8.72E-2,1646357,1481721,164636]
["Metro South/West",12789,0.10417124844219632,1287,1.1939218523878437E-2,423,1.0980738279424744E-2,4.2363735081833165E-2,6.4500000000000002E-2,6.7900000000000002E-2,6.6200000000000009E-2,5.96E-2,5.96E-2,1125262,1012736,112526]
["North Central",3075,2.5047039562104439E-2,4768,4.4231696908976215E-2,1454,3.774466538601319E-2,3.5674467285697946E-2,2.93E-2,3.0729325408899933E-2,3.0014662704449968E-2,2.7E-2,3.5700000000000003E-2,674025,606623,67402]
["North Shore",6234,5.0778290936637098E-2,6815,6.3221269805929722E-2,2062,5.3527854213176886E-2,5.5842471651914562E-2,4.9067232433241299E-2,4.7899999999999998E-2,4.8483616216620645E-2,4.36E-2,5.5800000000000002E-2,1053517,948165,105352]
["South Shore",4589,3.7379142943251148E-2,8638,8.0132843519240049E-2,2634,6.837651212294274E-2,6.1962832861811312E-2,5.0500000000000003E-2,5.16E-2,5.1049999999999998E-2,4.5900000000000003E-2,6.2E-2,{"$f":"ROUND(M26*$N$27,0)","v":1170575},1053518,{"$f":"(N26-O26)","v":117057}]
["TOTAL",{"$f":"SUM(B11:B26)","v":122769},0.99999999999999978,{"$f":"SUM(D11:D26)","v":107796},1,{"$f":"SUM(F11:F26)","v":38522},0.99999999999999989,1,0.99999999999999978,0.99999999999999978,{"$f":"SUM(K11:K26)","v":1},{"$f":"SUM(L11:L26)","v":0.89990000000000003},0.99999999999999978,18880241,{"$f":"SUM(O11:O26)","v":16992216},{"$f":"SUM(P11:P26)","v":1888024}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M11:M27)","v":1.9999999999999996},{"$f":"SUM(N11:N26)","v":18880240},{"$f":"SUM(O11:O27)","v":33984432},{"$f":"SUM(P11:P27)","v":3776048}]
[]
["Data on ASU unemployed and ASU excess unemployment data are for the 7/1/24 - 6/30/25 benchmark period used for state ASU determination for FY27",null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Name","WIOA YOUTH"]
["* Economically Disadvantaged Adult source: special tabulations of American Community Survey (ACS) from Census Bureau on data collected 1/1/2016-12/31/20. ETA Reference TEGL 01-23, 7/31/2023. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Dates","4/1/2026-6/30/2027"]
["**Unadjusted formula shares (D) were adjusted to ensure that each area's formula share was at or above the area's 90% hold-harmless level (E). Totals may not add due to rounding.",null,null,null,null,null,null,null,null,null,null,null,null,null,"SSTA Code RETAINED","DCSL_FWIA_YTH_RT_EOL241"]
["FY 2027 total allotment for workforce areas assumes Governor's Reserve for statewide activities at 15% for the period 7/1/26 - 6/30/27.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phase Code",6501]
["FY 2027 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 10-25, April 28,2026",null,null,null,null,null,null,null,null,null,null,null,null,null,"Appropriation",70031631]
[]
["Prepared by:  MassHire Department of Career Services",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","2026-06-16"]

{"sheet":"Dis Wrk FY27 0662026","index":3,"n_rows":35,"n_cols":25,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,6,34,8],[34,21,34,22],[7,5,8,6],[7,11,8,12],[7,13,8,13],[7,17,7,20],[8,17,8,20],[5,17,5,20],[6,1,6,2],[6,3,6,4],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,17,6,20],[5,5,5,6],[5,11,5,12],[3,4,3,9],[5,0,9,0],[5,1,5,2],[5,3,5,4],[5,7,5,8],[5,9,5,10],[7,1,8,2],[7,3,8,4],[7,7,8,8],[7,9,8,10],[6,5,6,6],[0,0,0,14],[0,15,0,22],[1,0,1,14],[1,15,1,22],[2,0,2,14],[2,15,2,22]]}
["ATTACHMENT  -  4 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ATTACHMENT  -  4 "]
["COMMONWEALTH OF MASSACHUSETTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMMONWEALTH OF MASSACHUSETTS"]
[" FISCAL YEAR 2027 WIOA TITLE I FORMULA ALLOCATION SHARES FOR DISLOCATED WORKERS\nWITH HOLD HARMLESS ADJUSTMENT ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FISCAL YEAR 2027 WIOA TITLE I FORMULA ALLOCATION SHARES \nFOR DISLOCATED WORKERS WITH HOLD HARMLESS ADJUSTMENT "]
[]
[]
["MASSHIRE\nWORKFORCE \nAREAS","A",null,"B",null,"C",null,"C",null,"D",null,"E",null,"F","G","H","I","J",null,null,null,"K","L","M","N"]
[null,"27.78% Weight",null,"27.78% Weight",null,"0% Weight",null,"11.10% Weight",null,"16.67% Weight",null,"16.67% Weight",null,"Weighted","Calculated","Adjusted","Fiscal Year 2027","Hold Harmless Level Fiscal Year 2027",null,null,null,"Adjusted","Fiscal Year 2027","Fiscal Year 2027","Fiscal Year 2027"]
[null,"CY25 Average\nMonthly UI Claimants",null,"CY25 Annual Avg\nUnemp. Rate",null,"CY23 Claimants\nin Mass Layoffs",null,"3-Year Job Loss in\nDeclining Indus.",null,"CY25 Avg Lng Trm\nUI Claims (26+Wks)",null,"CY25 Annual Total\nof UI Exhaustees ",null,"Formula\nShare","Hold","Formula","Total","Hold-Harmless Level = 90% of ",null,null,null,"Formula","Total \nAllocation","Program 90%   \nAmount","Admin. 10%\nAmount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harmless","Share*","Allocation","Avg Dislocated Worker Share (Prior 2 Years) ",null,null,null,"Share","Allocation","Total","Amount"]
[null,"Count","Pct","Count","Pct","Count","Pct","Count","Pct","Count","Pct","Count","Pct","FY27","FY27","FY27","FY27","FY26","FY25","Average","90% HH","FY27","FY27","FY27","FY27"]
["Berkshire County",889,{"$f":"+B11/B27","v":1.482482031784148E-2},4.4000000000000004,{"$f":"+D11/$D$27","v":5.8823529411764712E-2},null,null,1661,{"$f":"+H11/H27","v":1.1996504329864146E-2},542,{"$f":"+J11/J27","v":1.5755355948954972E-2},598,{"$f":"+L11/L27","v":1.6340137169713366E-2},{"$f":"ROUND(C11*0.2778+E11*0.2778+I11*0.1111+K11*0.1667+M11*0.1667,4)","v":2.7099999999999999E-2},2.58E-2,2.7099999999999999E-2,289218,2.7900000000000001E-2,2.9499999999999998E-2,{"$f":"+(R11+S11)/2","v":2.87E-2},{"$f":"ROUND(T11*0.9,4)","v":2.58E-2},2.7099999999999999E-2,{"$f":"ROUND(V11*$W$27,0)","v":289218},{"$f":"ROUND(W11*0.9,0)","v":260296},{"$f":"(W11-X11)","v":28922}]
["Boston",6000,{"$f":"+B12/B27","v":0.10005503026664665},4.4000000000000004,{"$f":"+D12/$D$27","v":5.8823529411764712E-2},"     Data not available ",null,23542,{"$f":"H12/H27","v":0.17003112879811061},1118,{"$f":"+J12/J27","v":3.249905526002151E-2},1019,{"$f":"+L12/L27","v":2.7843812334344346E-2},{"$f":"ROUND(C12*0.2778+E12*0.2778+I12*0.1111+K12*0.1667+M12*0.1667,4)","v":7.3099999999999998E-2},8.6300000000000002E-2,8.6300000000000002E-2,921014,0.10009999999999999,9.1700000000000004E-2,{"$f":"+(R12+S12)/2","v":9.5899999999999999E-2},{"$f":"ROUND(T12*0.9,4)","v":8.6300000000000002E-2},8.6300000000000002E-2,921014,{"$f":"ROUND(W12*0.9,0)","v":828913},{"$f":"(W12-X12)","v":92101}]
["Bristol County",3663,{"$f":"+B13/B27","v":6.1083595977787786E-2},4.9000000000000004,{"$f":"+D13/$D$27","v":6.5508021390374344E-2},"         for this factor.",null,4447,{"$f":"H13/H27","v":3.211827498790238E-2},1855,{"$f":"+J13/J27","v":5.3922851079910468E-2},1948,{"$f":"+L13/L27","v":5.3228406700002735E-2},5.6599999999999998E-2,6.0499999999999998E-2,6.0499999999999998E-2,645670,6.5299999999999997E-2,6.9199999999999998E-2,6.7250000000000004E-2,6.0499999999999998E-2,6.0499999999999998E-2,645670,{"$f":"ROUND(W13*0.9,0)","v":581103},{"$f":"W13-X13","v":64567}]
["Brockton",2541,{"$f":"+B14/B27","v":4.237330531792486E-2},4.9000000000000004,{"$f":"+D14/$D$27","v":6.5508021390374344E-2},null,null,1738,{"$f":"H14/H27","v":1.2552633669659172E-2},1650,{"$f":"+J14/J27","v":4.796372198482602E-2},1766,{"$f":"+L14/L27","v":4.8255321474437798E-2},4.7399999999999998E-2,4.2599999999999999E-2,4.7399999999999998E-2,505864,4.6100000000000002E-2,4.8500000000000001E-2,4.7300000000000002E-2,4.2599999999999999E-2,4.7399999999999998E-2,505864,455278,50586]
["Cape Cod & Islands",2888,{"$f":"+B15/B27","v":4.8159821235012591E-2},5.3,7.0855614973262038E-2,"       Factor weight ",null,1351,{"$f":"H15/H27","v":9.7575420527672846E-3},662,{"$f":"+J15/J27","v":1.9243626638760503E-2},1009,{"$f":"+L15/L27","v":2.757056589337924E-2},4.2000000000000003E-2,4.5600000000000002E-2,4.5600000000000002E-2,486654,5.2499999999999998E-2,4.8899999999999999E-2,5.0699999999999995E-2,4.5600000000000002E-2,4.5600000000000002E-2,486654,437989,48665]
["Central Mass",5264,{"$f":"+B16/B27","v":8.7781613220604668E-2},4.5,6.0160427807486636E-2,"          (10%) was",null,5890,{"$f":"H16/H27","v":4.2540283264840349E-2},3218,{"$f":"+J16/J27","v":9.3543792331618261E-2},3356,{"$f":"+L16/L27","v":9.1701505587889712E-2},7.6700000000000004E-2,7.0300000000000001E-2,7.5543979057591623E-2,806223,7.5600000000000001E-2,8.0600000000000005E-2,7.8100000000000003E-2,7.0300000000000001E-2,7.5543979057591623E-2,806223,725601,80622]
["Franklin/Hampshire",1562,{"$f":"+B17/B27","v":2.6047659546083679E-2},4.3,5.7486631016042782E-2,"         apportioned ",null,2123,{"$f":"H17/H27","v":1.5333280368634305E-2},1012,{"$f":"+J17/J27","v":2.9417749484026628E-2},1115,{"$f":"+L17/L27","v":3.0466978167609366E-2},3.49E-2,2.7900000000000001E-2,3.3635602094240838E-2,358967,3.09E-2,3.1099999999999999E-2,3.1E-2,2.7900000000000001E-2,3.3635602094240838E-2,358967,{"$f":"ROUND(W17*0.9,0)","v":323070},35897]
["Greater Lowell",2657,{"$f":"+B18/B27","v":4.4307702569746692E-2},4.5999999999999996,6.1497326203208552E-2,"       across the five ",null,5769,{"$f":"H18/H27","v":4.1666365730876731E-2},1746,{"$f":"+J18/J27","v":5.0754338536670447E-2},1826,{"$f":"+L18/L27","v":4.9894800120228434E-2},5.0799999999999998E-2,4.58E-2,4.9896858638743456E-2,532511,5.0099999999999999E-2,5.16E-2,5.0849999999999999E-2,4.58E-2,4.9896858638743456E-2,532511,479260,53251]
["Gtr New Bedford",2364,{"$f":"+B19/B27","v":3.942168192505878E-2},5.5,7.3529411764705885E-2,"      remaining factors.",null,1867,{"$f":"H19/H27","v":1.3484330875289802E-2},1197,{"$f":"+J19/J27","v":3.4795500130810147E-2},1347,{"$f":"+L19/L27","v":3.6806295597999833E-2},4.48E-2,4.36E-2,4.458324607329843E-2,475803,4.6600000000000003E-2,5.0200000000000002E-2,4.8399999999999999E-2,4.36E-2,4.458324607329843E-2,475803,428223,47580]
["Hampden County",4129,{"$f":"+B20/B27","v":6.8854536661830668E-2},5.5,7.3529411764705885E-2,null,null,6492,{"$f":"H20/H27","v":4.6888203557783281E-2},2570,{"$f":"+J20/J27","v":7.4707130606668407E-2},2827,{"$f":"+L20/L27","v":7.7246768860835591E-2},7.0099999999999996E-2,6.5299999999999997E-2,6.9232984293193717E-2,738871,6.9800000000000001E-2,7.5399999999999995E-2,7.2599999999999998E-2,6.5299999999999997E-2,6.9232984293193717E-2,738871,664984,73887]
["Merrimack Valley",3369,{"$f":"+B21/B27","v":5.6180899494722096E-2},4.8,6.4171122994652413E-2,null,null,5769,{"$f":"H21/H27","v":4.1666365730876731E-2},2366,{"$f":"+J21/J27","v":6.8777070433999013E-2},2592,{"$f":"+L21/L27","v":7.0825477498155584E-2},6.13E-2,5.3800000000000001E-2,5.9945287958115184E-2,639750,5.8999999999999997E-2,6.0600000000000001E-2,5.9799999999999999E-2,5.3800000000000001E-2,5.9945287958115184E-2,639750,575775,63975]
["Metro North",6651,{"$f":"+B22/B27","v":0.11091100105057781},4,5.3475935828877004E-2,null,null,24392,{"$f":"H22/H27","v":0.17617021891273102},4423,{"$f":"+J22/J27","v":0.12857184384174877},4486,{"$f":"+L22/L27","v":0.12257835341694674},0.1071,8.5999999999999993E-2,0.10328874345549738,1102321,9.7299999999999998E-2,9.3700000000000006E-2,9.5500000000000002E-2,8.5999999999999993E-2,0.10328874345549738,{"$f":"ROUND(V22*$W$27,0)-1","v":1102321},{"$f":"ROUND(W22*0.9,0)","v":992089},{"$f":"(W22-X22)","v":110232}]
["Metro South/West",6717,{"$f":"+B23/B27","v":0.11201160638351093},4,5.3475935828877004E-2,null,null,20158,{"$f":"H23/H27","v":0.14559032768296293},4551,{"$f":"+J23/J27","v":0.13229266591087468},4729,{"$f":"+L23/L27","v":0.12921824193239884},0.1057,9.1600000000000001E-2,0.10315314136125654,1100873,0.1045,9.9099999999999994E-2,0.1018,9.1600000000000001E-2,0.10315314136125654,{"$f":"ROUND(V23*$W$27,0)-1","v":1100873},{"$f":"ROUND(W23*0.9,0)","v":990786},{"$f":"(W23-X23)","v":110087}]
["North Central",2551,{"$f":"+B24/B27","v":4.2540063701702602E-2},4.9000000000000004,6.5508021390374344E-2,null,null,2624,{"$f":"H24/H27","v":1.8951732306781165E-2},1619,{"$f":"+J24/J27","v":4.7062585389959596E-2},1772,{"$f":"+L24/L27","v":4.8419269339016857E-2},4.8000000000000001E-2,3.85E-2,4.6284031413612564E-2,493954,4.3499999999999997E-2,4.2099999999999999E-2,4.2799999999999998E-2,3.85E-2,4.6284031413612564E-2,493954,444559,49395]
["North Shore",3774,{"$f":"+B25/B27","v":6.2934614037720743E-2},4.5,6.0160427807486636E-2,null,null,24392,{"$f":"H25/H27","v":0.17617021891273102},2740,{"$f":"+J25/J27","v":7.9648847417226248E-2},2925,{"$f":"+L25/L27","v":7.9924583982293629E-2},8.0399999999999999E-2,5.21E-2,7.5288219895287958E-2,803494,5.8700000000000002E-2,5.7000000000000002E-2,5.7849999999999999E-2,5.21E-2,7.5288219895287958E-2,803494,723145,80349]
["South Shore",4948,{"$f":"+B26/B27","v":8.2512048293227946E-2},4.3,5.7486631016042782E-2,null,null,6242,{"$f":"H26/H27","v":4.5082588818189037E-2},3132,{"$f":"+J26/J27","v":9.1043865003924307E-2},3282,{"$f":"+L26/L27","v":8.9679481924747936E-2},7.3999999999999996E-2,6.4299999999999996E-2,7.2247905759162304E-2,771047,7.2099999999999997E-2,7.0800000000000002E-2,7.145E-2,6.4299999999999996E-2,7.2247905759162304E-2,771047,693942,77105]
["TOTAL",{"$f":"SUM(B11:B26)","v":59967},{"$f":"SUM(C11:C26)","v":1},{"$f":"SUM(D11:D26)","v":74.8},{"$f":"SUM(E11:E26)","v":1},null,null,{"$f":"SUM(H11:H26)","v":138457},{"$f":"SUM(I11:I26)","v":0.99999999999999989},{"$f":"SUM(J11:J26)","v":34401},1,36597,1,1.0000000000000002,0.9,1,10672234,1,1,{"$f":"SUM(T11:T26)","v":0.99999999999999989},{"$f":"SUM(U11:U26)","v":0.9},1,10672234,{"$f":"SUM(X11:X26)","v":9605013},{"$f":"SUM(Y11:Y26)","v":1067221}]
[]
[null,"Calculation of FY 2027 Dislocated Worker Local Program Allocations with Factor Weights Approved June 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Name","WIOA DWK LOCAL"]
[null,"**Unadjusted formula shares (D) were adjusted to ensure that each area's formula share was at or above the area's 90% hold-harmless level (E). Totals may not add due to rounding.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Dates","7/1/2026-6/30/2027"]
[null,"FY 2027 total allotment for workforce areas assumes Governor's Reserve for statewide activities at 15% for the period 7/1/25 - 6/30/26.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSTA Code RETAINED","DCSL_FWIA_YTH_RT_EOL241"]
[null,"FY 2027 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 10-25, April 28,2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phase Code",6503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appropriation",70031778]
[]
[null,"Prepared by:  MassHire Department of Career Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:  ","2026-06-16"]

{"sheet":" Awards FY27 Adult 06162026 ","index":4,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,4,31,6],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,8,0],[5,2,5,4]]}
["ATTACHMENT  -   5"]
["COMMONWEALTH OF MASSACHUSETTS"]
["FISCAL YEAR 2027 WIOA TITLE I FORMULA ALLOCATIONS FOR ADULT ACTIVITIES"]
["FUNDING AVAILABILITY "]
[]
["MASSHIRE\nWORKFORCE \nAREAS","Adjusted","Fiscal Year 2027 Adult"]
[null,"Formula","Total","Program 90%","Admin 10%","                    Funds Available as of July 1, 2026",null,null,"                Funds Available as of October 1, 2026"]
[null,"Share**","Allocation","Amount","Amount","                         DOL Notice of Award (NOA)",null,null,"                      DOL Notice of Award (NOA)"]
[null,"FY27","FY27","FY27","FY27","Total","90% Program","10% Admin","Total","90% Program","10% Admin"]
["Berkshire County",2.1000000000000001E-2,336229,{"$f":"ROUND(C10*0.9,0)","v":302606},{"$f":"(C10-D10)","v":33623},{"$f":"ROUND(B10*$F$26,0)","v":62850},{"$f":"ROUND(F10*0.9,0)","v":56565},{"$f":"F10-G10","v":6285},{"$f":"C10-F10","v":273379},{"$f":"D10-G10","v":246041},{"$f":"E10-H10","v":27338}]
["Boston",0.1265,2025378,{"$f":"ROUND(C11*0.9,0)","v":1822840},{"$f":"C11-D11","v":202538},{"$f":"ROUND(B11*$F$26,0)","v":378594},{"$f":"ROUND(F11*0.9,0)","v":340735},{"$f":"F11-G11","v":37859},{"$f":"C11-F11","v":1646784},1482105,164679]
["Bristol County",5.6099999999999997E-2,898211,{"$f":"ROUND(C12*0.9,0)","v":808390},89821,{"$f":"ROUND(B12*$F$26,0)","v":167898},151108,16790,730313,657282,73031]
["Brockton",4.9799999999999997E-2,797342,{"$f":"ROUND(C13*0.9,0)","v":717608},79734,149043,134139,14904,648299,583469,64830]
["Cape Cod & Islands",5.28E-2,845375,760838,84537,158022,142220,15802,687353,618618,68735]
["Central Mass",8.1299999999999997E-2,1301686,1171517,130169,243317,218985,24332,1058369,952532,105837]
["Franklin/Hampshire",3.1800000000000002E-2,509146,458231,50915,{"$f":"ROUND(B16*$F$26,0)","v":95172},{"$f":"ROUND(F16*0.9,0)","v":85655},9517,413974,372576,41398]
["Greater Lowell",2.7799999999999998E-2,445103,400593,44510,83201,74881,8320,361902,325712,36190]
["Gtr New Bedford",5.8599999999999999E-2,938238,844414,93824,175380,157842,17538,762858,686572,76286]
["Hampden County",0.1118,1790018,{"$f":"ROUND(C19*0.9,0)","v":1611016},179002,{"$f":"ROUND(B19*$F$26,0)","v":334599},301139,33460,{"$f":"C19-F19","v":1455419},1309877,145542]
["Merrimack Valley",7.4800000000000005E-2,1197615,1077854,119761,223864,201478,22386,973751,876376,97375]
["Metro North",9.2700000000000005E-2,1484210,1335789,148421,277436,249692,27744,1206774,1086097,120677]
["Metro South/West",5.4199999999999998E-2,867790,781011,86779,162212,145991,16221,705578,635020,70558]
["North Central",4.1500000000000002E-2,664452,598007,66445,124203,111783,12420,540249,486224,54025]
["North Shore",5.5899999999999998E-2,895009,805508,89501,167299,150569,16730,727710,654939,72771]
["South Shore",6.3399999999999998E-2,1015091,{"$f":"ROUND(C25*0.9,0)","v":913582},101509,189746,170771,18975,825345,742811,82534]
["TOTAL",{"$f":"SUM(B10:B25)","v":1},{"$f":"SUM(C10:C25)","v":16010893},{"$f":"SUM(D10:D25)","v":14409804},{"$f":"SUM(E10:E25)","v":1601089},2992834,{"$f":"SUM(G10:G25)","v":2693553},{"$f":"SUM(H10:H25)","v":299283},13018058,11716251,1301806]
["Source:"]
["     1.  FY 2027 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 10-25, April 28,2026"]
["USDOL will issue allotments in two Notices of Award (NOA) one for July 1, 2026 (base allotment) and one for October 1, 2026 (advance allotment).  \n Totals may not add due to rounding."]
["Totals may not add due to rounding."]
[]
["Prepared by:  MassHire Department of Career Services",null,null,null,null,null,null,null,null," Date:","2026-06-16"]

{"sheet":" Awards FY27 Youth 06162026","index":5,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,4,32,6],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,8,0],[5,2,5,4]]}
["ATTACHMENT  -  6"]
["COMMONWEALTH OF MASSACHUSETTS"]
["FISCAL YEAR 2027 WIOA TITLE I FORMULA ALLOCATIONS FOR YOUTH ACTIVITIES"]
["FUNDING AVAILABILITY "]
[]
["MASSHIRE\nWORKFORCE\nAREAS","Adjusted"," Fiscal Year 2027 Youth "]
[null,"Formula","Total","Program 90%","Admin 10%","                     Funds Available as of April 1, 2026",null,null,"                     Funds Available as of October 1, 2026"]
[null,"Share","Allocation","Amount","Amount","                             DOL Notice of Award (NOA)",null,null,"                             DOL Notice of Award (NOA)"]
[null,"FY257","FY27","FY27","FY27","Total","90% Program","10% Admin","Total","90% Program","10% Admin"]
["Berkshire County",2.18E-2,411589,370430,41159,411589,370430,41159]
["Boston",0.14180000000000001,2677218,2409496,267722,2677218,2409496,267722]
["Bristol County",5.0599999999999999E-2,955340,859806,95534,955340,859806,95534]
["Brockton",5.0700000000000002E-2,957228,861505,95723,957228,861505,95723]
["Cape Cod & Islands",0.05,944012,849611,94401,944012,849611,94401]
["Central Mass",7.8600000000000003E-2,1483987,1335588,148399,1483987,1335588,148399]
["Franklin/Hampshire",4.9399999999999999E-2,932684,839416,93268,932684,839416,93268]
["Greater Lowell",2.5999999999999999E-2,490886,441797,49089,490886,441797,49089]
["Gtr New Bedford",5.3699999999999998E-2,1013869,912482,101387,1013869,912482,101387]
["Hampden County",0.1062,2005082,1804574,200508,2005082,1804574,200508]
["Merrimack Valley",7.0900000000000005E-2,1338609,1204748,133861,1338609,1204748,133861]
["Metro North",8.72E-2,1646357,1481721,164636,1646357,1481721,164636]
["Metro South/West",5.96E-2,1125262,1012736,112526,1125262,1012736,112526]
["North Central",3.5700000000000003E-2,674025,606623,67402,674025,606623,67402]
["North Shore",5.5800000000000002E-2,1053517,948165,105352,1053517,948165,105352]
["South Shore",6.2E-2,1170575,1053518,117057,1170575,1053518,117057]
["TOTAL",0.99999999999999978,{"$f":"SUM(C10:C25)","v":18880240},{"$f":"SUM(D10:D25)","v":16992216},1888024,18880240,16992216,1888024]
["Source:"]
[null,null,null," "]
["     1.  FY 2027 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 10-25, April 28,2026"]
["USDOL will issue allotments in two Notices of Award (NOA) one for July 1, 2026 (base allotment) and one for October 1, 2026 (advance allotment).  \n Totals may not add due to rounding."]
["Totals may not add due to rounding."]
[]
["Prepared by:  MassHire Department of Career Services",null,null,null,null,null,null,null,"Date:","2026-06-16"]

{"sheet":"Awards FY27 DWrk 06162026","index":6,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,4,30,6],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,8,0],[5,2,5,4]]}
["ATTACHMENT  -  7"]
["COMMONWEALTH OF MASSACHUSETTS"]
["FISCAL YEAR 2027 WIOA TITLE I FORMULA ALLOCATIONS FOR DISCLOCATED WORKER PROGRAMS"]
["FUNDING AVAILABILITY "]
[]
["MASSHIRE\nWORKFORCE\nAREAS","Adjusted","Fiscal Year 2027"]
[null,"Formula","Total","Program 90%","Admin 10%","                           Funds Available as of July 1, 2026",null,null,"                           Funds Available as of October 1, 2026"]
[null,"Share","Allocation","Amount","Amount","                                  DOL Notice of Award (NOA)",null,null,"                                  DOL Notice of Award (NOA)"]
[null,"FY27","FY27","FY27","FY27","Total","90% Program","10% Admin","Total","90% Program","10% Admin"]
["Berkshire County",2.7099999999999999E-2,289218,260296,28922,{"$f":"ROUND(B10*$F$26,0)","v":62196},{"$f":"ROUND(F10*0.9,0)","v":55976},{"$f":"F10-G10","v":6220},{"$f":"C10-F10","v":227022},{"$f":"D10-G10","v":204320},{"$f":"E10-H10","v":22702}]
["Boston",8.6300000000000002E-2,921014,828913,92101,{"$f":"ROUND(B11*$F$26,0)","v":198062},178256,{"$f":"F11-G11","v":19806},{"$f":"C11-F11","v":722952},650657,72295]
["Bristol County",6.0499999999999998E-2,645670,581103,64567,138850,124965,13885,506820,456138,50682]
["Brockton",4.7399999999999998E-2,505864,455278,50586,108785,97907,10878,397079,357371,39708]
["Cape Cod & Islands",4.5600000000000002E-2,486654,437989,48665,104654,94189,10465,382000,343800,38200]
["Central Mass",7.5543979057591623E-2,806223,725601,80622,173377,156039,17338,632846,569562,63284]
["Franklin/Hampshire",3.3635602094240838E-2,358967,323070,35897,77195,69476,7719,281772,253594,28178]
["Greater Lowell",4.9896858638743456E-2,532511,479260,53251,114516,103064,11452,417995,376196,41799]
["Gtr New Bedford",4.458324607329843E-2,475803,428223,47580,102321,92089,10232,373482,336134,37348]
["Hampden County",6.9232984293193717E-2,738871,664984,73887,158893,143004,15889,579978,521980,57998]
["Merrimack Valley",5.9945287958115184E-2,639750,575775,63975,137577,123819,13758,502173,451956,50217]
["Metro North",0.10328874345549738,1102321,992089,110232,237052,213347,23705,865269,778742,86527]
["Metro South/West",0.10315314136125654,1100873,990786,110087,236741,213067,23674,864132,777719,86413]
["North Central",4.6284031413612564E-2,493954,444559,49395,106224,{"$f":"ROUND(F23*0.9,0)","v":95602},{"$f":"F23-G23","v":10622},387730,348957,38773]
["North Shore",7.5288219895287958E-2,803494,723145,80349,172790,{"$f":"ROUND(F24*0.9,0)","v":155511},17279,630704,567634,63070]
["South Shore",7.2247905759162304E-2,771047,693942,77105,{"$f":"ROUND(B25*$F$26,0)","v":165812},{"$f":"ROUND(F25*0.9,0)","v":149231},16581,605235,544711,60524]
["TOTAL",1,{"$f":"SUM(C10:C25)","v":10672234},{"$f":"SUM(D10:D25)","v":9605013},{"$f":"SUM(E10:E25)","v":1067221},2295046,{"$f":"SUM(G10:G25)","v":2065542},{"$f":"SUM(H10:H25)","v":229503},{"$f":"C26-F26","v":8377188},{"$f":"SUM(J10:J25)","v":7539471},{"$f":"SUM(K10:K25)","v":837718}]
["Source:"]
["       1. FY 2027 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 10-25, April 28,2026"]
["USDOL will issue allotments in two Notices of Award (NOA) one for July 1, 2025 (base allotment) and one for October 1, 2025 (advance allotment). Totals may not add due to rounding. \n "]
[]
["Prepared by:  MassHire Department of Career Services",null,null,null,null,null,null,null," Date: ","2026-06-16"]

{"sheet":"Adult HH ","index":7,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["2007-04-15"]
["FY2008 WIA Title I Adult HH Calculation"]
[]
[null,null,null,"Hold"]
[null,"Straight","90% Hold","Harmless","Formula ","Adjusted"," Adjusted"]
["Areas","Formula","Harmless",0.9,"If> Hold-","Formula ","FY2008 Formula"]
[null,"Share","Share","If > Formula","Harmless","F x (100-D/Total F)","Share"]
["Berkshire County",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C8","v":{"$error":"#REF!"}},null,{"$f":"+E8*(76.84/81.64)","v":0},{"$f":"D8","v":{"$error":"#REF!"}}]
["Boston",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B9","v":{"$error":"#REF!"}},{"$f":"+E9*(76.84/81.64)","v":{"$error":"#REF!"}},{"$f":"F9","v":{"$error":"#REF!"}}]
["Bristol County",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B10","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F10","v":{"$error":"#REF!"}}]
["Brockton",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B11","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F11","v":{"$error":"#REF!"}}]
["Cape Cod & Islands",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C12","v":{"$error":"#REF!"}},null,0,{"$f":"D12","v":{"$error":"#REF!"}}]
["Central Mass",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B13","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F13","v":{"$error":"#REF!"}}]
["Franklin/Hampshire",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B14","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F14","v":{"$error":"#REF!"}}]
["Greater Lowell",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B15","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F15","v":{"$error":"#REF!"}}]
["Gtr New Bedford",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C16","v":{"$error":"#REF!"}},null,0,{"$f":"D16","v":{"$error":"#REF!"}}]
["Hampden County",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B17","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F17","v":{"$error":"#REF!"}}]
["Lower Merrimack",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C18","v":{"$error":"#REF!"}},null,0,{"$f":"D18","v":{"$error":"#REF!"}}]
["Metro North",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F19","v":{"$error":"#REF!"}}]
["Metro South/West",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B20","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F20","v":{"$error":"#REF!"}}]
["North Central",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B21","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F21","v":{"$error":"#REF!"}}]
["North Shore",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B22","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F22","v":{"$error":"#REF!"}}]
["South Coastal",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B23","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F23","v":{"$error":"#REF!"}}]
["TOTAL",1,0.9,{"$f":"SUM(D8:D23)","v":{"$error":"#REF!"}},{"$f":"SUM(E8:E23)","v":{"$error":"#REF!"}},{"$f":"SUM(F8:F23)","v":{"$error":"#REF!"}},{"$f":"SUM(G8:G23)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,1]
[null,null,null,null,null,{"$f":"D24","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"+F26-F27","v":{"$error":"#REF!"}}]

{"sheet":"Youth HH","index":8,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["2007-04-15"]
["FY2008 WIA Title I Youth HH Calculation"]
[null,"b","c","d","e","f","g"]
[null,"v",null,"Hold",null,null,"not rounded"]
[null,"Straight","90% Hold","Harmless","Formula ","Adjusted","Final Adjusted"]
["Areas","Formula","Harmless",0.9,"If> Hold-","Formula ","FY2008 Formula"]
[null,"Share","Share","If > Formula","Harmless","F x (100-E/Total F)","Share"]
["Berkshire County",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C8","v":{"$error":"#REF!"}},null,{"$f":"+E8*(74.12/78.4)","v":0},{"$f":"(+D8)","v":{"$error":"#REF!"}}]
["Boston",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B9","v":{"$error":"#REF!"}},{"$f":"+E9*(74.12/78.4)","v":{"$error":"#REF!"}},{"$f":"F9","v":{"$error":"#REF!"}}]
["Bristol County",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B10","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F10","v":{"$error":"#REF!"}}]
["Brockton",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B11","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+F11","v":{"$error":"#REF!"}}]
["Cape Cod & Islands",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C12","v":{"$error":"#REF!"}},null,0,{"$f":"D12","v":{"$error":"#REF!"}}]
["Central Mass",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,8.4699999999999998E-2,8.0076071428571427E-2,{"$f":"F13","v":8.0076071428571427E-2}]
["Franklin/Hampshire",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B14","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+F14","v":{"$error":"#REF!"}}]
["Greater Lowell",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},4.5400000000000003E-2,null,0,{"$f":"D15","v":4.5400000000000003E-2}]
["Gtr New Bedford",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C16","v":{"$error":"#REF!"}},null,0,{"$f":"+D16","v":{"$error":"#REF!"}}]
["Hampden County",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B17","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F17","v":{"$error":"#REF!"}}]
["Lower Merrimack",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C18","v":{"$error":"#REF!"}},null,0,{"$f":"+D18","v":{"$error":"#REF!"}}]
["Metro North",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+F19","v":{"$error":"#REF!"}}]
["Metro South/West",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,3.7499999999999999E-2,3.5452806122448978E-2,{"$f":"F20","v":3.5452806122448978E-2}]
["North Central",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B21","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+F21","v":{"$error":"#REF!"}}]
["North Shore",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B22","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+F22","v":{"$error":"#REF!"}}]
["South Coastal",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,5.0599999999999999E-2,4.7837653061224485E-2,{"$f":"F23","v":4.7837653061224485E-2}]
["TOTAL",1,0.9,{"$f":"SUM(D8:D23)","v":{"$error":"#REF!"}},{"$f":"SUM(E8:E23)","v":{"$error":"#REF!"}},{"$f":"SUM(F8:F23)","v":{"$error":"#REF!"}},{"$f":"SUM(G8:G23)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,1]
[null,null,null,null,null,{"$f":"+D24","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"+F26-F27","v":{"$error":"#REF!"}}]