{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Compare FY26 FY25 060325","Adult FY26 060325"," Youth FY26 060325","Dis Wrk FY26 060325"," Awards FY26 Adult 060325"," Awards FY26 Youth 060323","Awards FY26 DWrk 0603623","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 FY26 FY25 060325","index":0,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,3,32,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],[1,0,1,12],[2,0,2,12],[4,5,4,8],[5,0,9,0],[5,1,6,4],[7,6,9,6],[7,7,9,7],[7,12,9,12]]}
["ATTACHMENT - 1 "]
["COMMONWEALTH OF MASSACHUSETTS"]
["ALLOCATIONS FOR FISCAL YEAR 2026 AND ALLOCATIONS FOR FISCAL YEAR 2025 COMPARED\n 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,"FY 2025\nAllocation","\nFY 2026\nAllocation1","Change \nfrom \nFY 2025","% Change\nfrom\nFY 2025","\nFY 2025\nAllocation","\nFY 2026\nAllocation1","Change \nfrom \nFY 2025","% Change\nfrom\nFY 2026","\nFY 2025\nAllocation","\nFY 2026\nAllocation1","Change \nfrom \nFY 2025","% Change\nfrom\nFY 2025"]
[]
[]
["Berkshire County",339892,273390,{"$f":"C11-B11","v":-66502},{"$f":"D11/B11","v":-0.19565626728490226},351528,299163,{"$f":"G11-F11","v":-52365},{"$f":"H11/F11","v":-0.14896395166245646},414493,324758,{"$f":"K11-J11","v":-89735},{"$f":"L11/J11","v":-0.21649340278364171}]
["Boston",1956903,1732295,{"$f":"C12-B12","v":-224608},-0.11477727817883666,1092717,1073340,{"$f":"G12-F12","v":-19377},-1.7732862214095691E-2,2549210,2220412,{"$f":"K12-J12","v":-328798},-0.12898035077533823]
["Bristol County",892122,721997,-170125,-0.19069701229204078,824602,700192,-124410,-0.15087278468885595,936861,745794,-191067,-0.20394380809960069]
["Brockton",741393,680989,-60404,-8.1473658370122187E-2,577936,494316,-83620,-0.14468730101602945,881127,802647,-78480,-8.9067750732868253E-2]
["Cape Cod & Islands",819266,721997,-97269,{"$f":"D15/B15","v":-0.11872700685735768},582703,562941,-19762,-3.3914361175418697E-2,895199,797306,-97893,-0.10935333931338172]
["Central Mass",940238,914612,-25626,-2.725480144388974E-2,960447,810635,-149812,-0.15598153776314569,1077858,1036983,-40875,-3.7922435051741511E-2]
["Franklin/Hampshire",390768,319369,-71399,-0.18271455185685626,370594,331331,-39263,-0.10594612972687091,753746,610344,-143402,-0.19025241924998607]
["Greater Lowell",443196,369076,-74120,-0.16723977653227917,614877,537207,-77670,-0.12631794651613248,479406,399481,-79925,-0.16671672861833184]
["Gtr New Bedford",659478,513227,-146251,-0.22176782242925466,598194,499677,-98517,-0.16469071906438379,734542,576230,-158312,-0.21552477598285735]
["Hampden County",1710220,1548378,-161842,-9.4632269532574753E-2,898482,748444,-150038,-0.16699054627694265,1924988,1672882,-252106,-0.13096497224917766]
["Merrimack Valley",1131909,1046336,-85573,-7.5600600401622392E-2,722123,632639,-89484,-0.12391794749647914,1247150,1150515,-96635,-7.7484665036282721E-2]
["Metro North",904340,1052550,148210,0.16388747594931111,1116549,1043318,-73231,-6.5586911098393347E-2,1005465,1253817,248352,0.24700213334128984]
["Metro South/West",856017,726968,-129049,-0.15075518360032569,1180896,1120520,-60376,-5.1127279624962739E-2,1092337,926853,-165484,-0.15149537184952996]
["North Central",501487,428725,-72762,-0.14509249492010759,501673,466437,-35236,-7.0236987041359611E-2,494356,421036,-73320,-0.14831417035496686]
["North Shore",707661,672290,-35371,-4.9982972072786264E-2,679224,629422,-49802,-7.332190853091175E-2,770588,705087,-65501,-8.5001323664526313E-2]
["South Shore",811835,704600,-107235,-0.13208964875867632,843668,773106,-70562,-8.3637165330438037E-2,830112,725676,-104436,-0.12580952931652598]
["TOTAL",13806725,12426799,-1379926,-9.9945932145385677E-2,11916213,10722688,{"$f":"G27-F27","v":-1193525},{"$f":"H27/F27","v":-0.10015975713089385},16087438,14369821,-1717617,-0.10676759096134512]
[]
[]
["FY 2026 Total allotment for workforce areas assumes Governor's Reserve for statewide activities at 15% for the period 7/1/25 - 6/30/26."]
["1.  FY 2026 state program allotments published in Training and Employment Guidance Letter (TEGL) 11-24-23, May 20,2025"]
[]
["MassHire Department of Career Services",null,null,null,null,null,null,null,null,null,"Date:","2025-06-03"]

{"sheet":"Adult FY26 060325","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],[5,13,5,15],[6,5,7,6],[6,8,6,11],[29,0,29,15],[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 2026 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 FY26",null,null,null,"Adjusted","Fiscal Year 2026"]
[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","FY24","FY25","Average","90%HH","FY26","FY26","FY26","FY26"]
["Berkshire County",9020,{"$f":"+B10/460507","v":1.9587107253527091E-2},465,{"$f":"+D10/45435","v":1.0234400792340706E-2},163,{"$f":"+F10/14817","v":1.1000877370587839E-2},{"$f":"+(C10+E10+G10)/3","v":1.3607461805485213E-2},2.4299999999999999E-2,2.4617816456007427E-2,{"$f":"+(I10+J10)/2","v":2.4458908228003715E-2},{"$f":"ROUND(K10*0.9,4)","v":2.1999999999999999E-2},2.1999999999999999E-2,{"$f":"ROUND(M10*$N$26,0)","v":273390},{"$f":"ROUND(N10*0.9,0)","v":246051},{"$f":"(N10-O10)","v":27339}]
["Boston",70920,{"$f":"+B11/460507","v":0.15400417366076954},6424,{"$f":"+D11/45435","v":0.1413887971827886},2020,{"$f":"+F11/14817","v":0.13632989134102719},{"$f":"+(C11+E11+G11)/3","v":0.1439076207281951},0.12939999999999999,0.14173552561847122,0.1355677628092356,{"$f":"ROUND(K11*0.9,4)","v":0.122},0.1394,{"$f":"ROUND(M11*$N$26,0)-1","v":1732295},{"$f":"ROUND(N11*0.9,0)","v":1559066},{"$f":"N11-O11","v":173229}]
["Bristol County",25014,5.4318392554293417E-2,2239,4.9279190051722238E-2,835,5.6354187757305794E-2,5.3317256787773819E-2,6.4399999999999999E-2,6.4615032467218669E-2,6.4507516233609341E-2,5.8099999999999999E-2,5.8099999999999999E-2,{"$f":"ROUND(M12*$N$26,0)","v":721997},{"$f":"ROUND(N12*0.9,0)","v":649797},72200]
["Brockton",15530,3.37237001826248E-2,3188,7.0166171453725099E-2,1051,7.0932037524465141E-2,5.8273969720271677E-2,4.9599999999999998E-2,5.3697962152410073E-2,5.1648981076205039E-2,4.65E-2,5.4800000000000001E-2,680989,{"$f":"ROUND(N13*0.9,0)","v":612890},68099]
["Cape Cod & Islands",11780,2.5580501490748239E-2,3570,7.8573786728293168E-2,1357,9.1583991361274208E-2,6.5246093193438534E-2,4.3499999999999997E-2,5.9338180824326854E-2,5.1419090412163429E-2,4.6300000000000001E-2,5.8099999999999999E-2,721997,649797,72200]
["Central Mass",42118,9.1460064667855209E-2,3071,6.7591064157587769E-2,975,6.5802794087872041E-2,7.4951307637771677E-2,7.7299999999999994E-2,6.8099999999999994E-2,7.2699999999999987E-2,6.54E-2,7.3599999999999999E-2,914612,823151,91461]
["Franklin/Hampshire",16425,3.5667210270419344E-2,792,1.7431495543083524E-2,247,1.6670041168927584E-2,2.3256248994143486E-2,2.8799999999999999E-2,2.8302679103012825E-2,2.8551339551506412E-2,2.5700000000000001E-2,2.5700000000000001E-2,319369,287432,31937]
["Greater Lowell",19253,4.1808267843919854E-2,575,1.2655441839991196E-2,185,1.2485658365391105E-2,2.231645601643405E-2,3.4000000000000002E-2,3.2099999999999997E-2,3.3049999999999996E-2,2.9700000000000001E-2,2.9700000000000001E-2,369076,332168,36908]
["Gtr New Bedford",18017,3.9124269555077341E-2,1865,4.1047650489710576E-2,621,4.1911318080583113E-2,4.0694412708457008E-2,4.41E-2,4.7764987183790825E-2,4.5932493591895412E-2,4.1300000000000003E-2,4.1300000000000003E-2,513227,461904,51323]
["Hampden County",46011,9.9913790669848665E-2,6310,0.13887971827885992,2014,0.13592495106971722,0.12490615333947526,0.12570000000000001,0.12386864212312304,0.12478432106156152,0.1123,0.1246,{"$f":"ROUND(M19*$N$26,0)-1","v":1548378},{"$f":"ROUND(N19*0.9,0)","v":1393540},154838]
["Merrimack Valley",26402,5.7332461830113333E-2,5031,0.11072961373390558,1541,0.10400215968144699,9.0688078415155304E-2,7.4499999999999997E-2,8.1982436613971657E-2,7.8241218306985827E-2,7.0400000000000004E-2,8.4199999999999997E-2,1046336,941702,104634]
["Metro North",49290,0.10703420360602553,4604,0.10133157257620777,1428,9.6375784571775661E-2,0.10158052025133631,7.1900000000000006E-2,6.5500000000000003E-2,6.8700000000000011E-2,6.1800000000000001E-2,8.4699999999999998E-2,1052550,947295,105255]
["Metro South/West",36546,7.9360357171552223E-2,1181,2.5993177066138441E-2,426,2.8750759263008706E-2,4.4701431166899792E-2,6.7900000000000002E-2,6.2E-2,6.4950000000000008E-2,5.8500000000000003E-2,5.8500000000000003E-2,726968,654271,72697]
["North Central",19568,4.2492296534037487E-2,1391,3.061516452074392E-2,451,3.0438010393466965E-2,3.451515714941613E-2,4.0300000000000002E-2,3.6321948974648036E-2,3.8310974487324019E-2,3.4500000000000003E-2,3.4500000000000003E-2,428725,385853,42872]
["North Shore",28614,6.2135863298494923E-2,2356,5.1854297347859582E-2,722,4.8727812647634476E-2,5.4239324431329665E-2,5.7000000000000002E-2,5.1254788483019446E-2,5.4127394241509724E-2,4.87E-2,5.4100000000000002E-2,672290,605061,67229]
["South Shore",25999,5.6457339410692996E-2,2373,5.2228458237041926E-2,781,5.270972531551596E-2,5.379850765441696E-2,6.7299999999999999E-2,5.8799999999999998E-2,6.3049999999999995E-2,5.67E-2,5.67E-2,704600,{"$f":"ROUND(N25*0.9,0)","v":634140},70460]
["TOTAL",{"$f":"SUM(B10:B25)","v":460507},1.0000000000000002,{"$f":"SUM(D10:D25)","v":45435},{"$f":"SUM(E10:E25)","v":1},{"$f":"SUM(F10:F25)","v":14817},{"$f":"SUM(G10:G25)","v":1},1,0.99999999999999989,1,{"$f":"SUM(K10:K25)","v":1},{"$f":"SUM(L10:L25)","v":0.89989999999999992},0.99998484285058375,12426799,{"$f":"SUM(O10:O25)","v":11184118},{"$f":"SUM(P10:P25)","v":1242681}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N10:N26)","v":24853598},{"$f":"SUM(O10:O26)","v":22368236},{"$f":"SUM(P9:P24)","v":1172221}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N10:N25)","v":12426799},{"$f":"SUM(O10:O25)","v":11184118},1242681]
["Data on ASU unemployed and ASU excess unemployment data are for the 7/1/23 - 6/30/24 benchmark period used for state ASU determination for FY26.",null,null,null,null,null,null,null,null,null,null,null," "]
["* 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.   "]
["**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."]
["FY 2026 total allotment for workforce areas assumes Governor's Reserve for statewide activities at 15% for the period 7/1/25 - 6/30/26."]
["FY 2026 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 11-24, May 20, 2025."]
[]
["Prepared by:  MassHire Department of Career Services",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","2025-06-03"]

{"sheet":" Youth FY26 060325","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],[35,5,35,12],[6,3,6,4],[6,5,6,6],[6,8,6,11],[30,0,30,15],[7,3,8,4],[6,1,6,2],[7,1,8,2],[7,8,7,11],[6,13,6,15],[7,5,8,6],[8,8,8,11]]}
["ATTACHMENT  -  3"]
["COMMONWEALTH OF MASSACHUSETTS"]
["  FISCAL YEAR 2026 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 FY26",null,null,null,"Adjusted","Fiscal Year 2026"]
[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","FY24","FY25","Average","90%HH","FY26","FY26","FY26","FY26"]
["Berkshire County",2982,{"$f":"+B11/122769","v":2.4289519341201771E-2},465,{"$f":"+D11/45435","v":1.0234400792340706E-2},163,{"$f":"+F11/14817","v":1.1000877370587839E-2},{"$f":"+(C11+E11+G11)/3","v":1.517493250137677E-2},2.4400000000000002E-2,2.5765010704837683E-2,{"$f":"+(I11+J11)/2","v":2.5082505352418842E-2},{"$f":"ROUND(K11*0.9,4)","v":2.2599999999999999E-2},2.2599999999999999E-2,{"$f":"ROUND(M11*$N$27,0)","v":324758},{"$f":"ROUND(N11*0.9,0)+1","v":292283},{"$f":"N11-O11","v":32475}]
["Boston",25310,{"$f":"+B12/122769","v":0.20615953538759785},6424,{"$f":"+D12/45435","v":0.1413887971827886},2020,{"$f":"+F12/$F$27","v":0.13632989134102719},{"$f":"+(C12+E12+G12)/3","v":0.16129274130380453},0.1452,0.15845968693248297,0.15182984346624148,{"$f":"ROUND(K12*0.9,4)","v":0.1366},0.15451918739754983,{"$f":"ROUND(M12*$N$27,0)-1","v":2220412},{"$f":"ROUND(N12*0.9,0)","v":1998371},{"$f":"(N12-O12)","v":222041}]
["Bristol County",4075,3.3192418281488001E-2,2239,4.9279190051722238E-2,835,{"$f":"+F13/$F$27","v":5.6354187757305794E-2},4.6275265363505347E-2,5.7099999999999998E-2,5.823556428636855E-2,5.7667782143184271E-2,5.1900000000000002E-2,5.1900000000000002E-2,{"$f":"ROUND(M13*$N$27,0)","v":745794},{"$f":"ROUND(N13*0.9,0)","v":671215},{"$f":"N13-O13","v":74579}]
["Brockton",4455,3.6287662194853749E-2,3188,7.0166171453725099E-2,1051,{"$f":"+F14/$F$27","v":7.0932037524465141E-2},5.9128623724347996E-2,5.0099999999999999E-2,5.4771122026035873E-2,5.2435561013017939E-2,4.7199999999999999E-2,5.5856440420348014E-2,802647,722382,80265]
["Cape Cod & Islands",1367,1.1134732709397323E-2,3570,7.8573786728293168E-2,1357,{"$f":"+F15/$F$27","v":9.1583991361274208E-2},6.043083693298823E-2,3.8600000000000002E-2,5.5645838863991492E-2,4.7122919431995744E-2,4.24E-2,5.5484733766967276E-2,{"$f":"ROUND(M15*$N$27,0)","v":797306},717575,{"$f":"(N15-O15)","v":79731}]
["Central Mass",11241,9.1562202184590574E-2,3071,6.7591064157587769E-2,975,6.5802794087872041E-2,7.4985353476683461E-2,7.6799999999999993E-2,6.7000000000000004E-2,7.1899999999999992E-2,6.4699999999999994E-2,7.2163941493216657E-2,1036983,933285,103698]
["Franklin/Hampshire",11495,9.3631128379313991E-2,792,1.7431495543083524E-2,247,1.6670041168927584E-2,4.2577555030441701E-2,4.7E-2,4.6853065368222369E-2,4.6926532684111184E-2,4.2200000000000001E-2,4.2473986563910993E-2,610344,549310,61034]
["Greater Lowell",4559,3.7134781581669642E-2,575,1.2655441839991196E-2,185,1.2485658365391105E-2,2.0758627262350646E-2,3.1899999999999998E-2,2.98E-2,3.0849999999999999E-2,2.7799999999999998E-2,2.7799999999999998E-2,399481,359533,39948]
["Gtr New Bedford",3670,2.9893539900137656E-2,1865,4.1047650489710576E-2,621,4.1911318080583113E-2,3.761750282347711E-2,4.3400000000000001E-2,4.5659328248753579E-2,4.452966412437679E-2,4.0099999999999997E-2,4.0099999999999997E-2,576230,518607,57623]
["Hampden County",9991,8.1380478785361129E-2,6310,0.13887971827885992,2014,0.13592495106971722,0.11872838271131277,0.12540000000000001,0.11965786456724327,0.12252893228362163,0.1103,0.11641636299931643,{"$f":"ROUND(M20*$N$27,0)","v":1672882},1505594,{"$f":"(N20-O20)","v":167288}]
["Merrimack Valley",5098,4.1525140711417378E-2,5031,0.11072961373390558,1541,0.10400215968144699,8.541897137559E-2,6.8900000000000003E-2,7.752319359316423E-2,7.3211596796582123E-2,6.59E-2,8.0064652744841994E-2,1150515,1035464,{"$f":"(N21-O21)","v":115051}]
["Metro North",11839,9.6433138658781933E-2,4604,0.10133157257620777,1428,9.6375784571775661E-2,9.8046831935588455E-2,6.7900000000000002E-2,6.25E-2,6.5200000000000008E-2,5.8700000000000002E-2,8.7253462180607505E-2,1253817,1128435,125382]
["Metro South/West",12789,0.10417124844219632,1181,2.5993177066138441E-2,426,2.8750759263008706E-2,5.2971728257114492E-2,7.5399999999999995E-2,6.7900000000000002E-2,7.1649999999999991E-2,6.4500000000000002E-2,6.4500000000000002E-2,926853,834168,92685]
["North Central",3075,2.5047039562104439E-2,1391,3.061516452074392E-2,451,3.0438010393466965E-2,2.8700071492105111E-2,3.4299999999999997E-2,3.0729325408899933E-2,3.2514662704449963E-2,2.93E-2,2.93E-2,421036,378932,42104]
["North Shore",6234,5.0778290936637098E-2,2356,5.1854297347859582E-2,722,4.8727812647634476E-2,5.045346697737705E-2,5.2900000000000003E-2,4.7899999999999998E-2,5.04E-2,4.5400000000000003E-2,4.9067232433241299E-2,705087,634578,70509]
["South Shore",4589,3.7379142943251148E-2,2373,5.2228458237041926E-2,781,5.270972531551596E-2,4.743910883193634E-2,6.0699999999999997E-2,5.16E-2,5.6149999999999999E-2,5.0500000000000003E-2,5.0500000000000003E-2,{"$f":"ROUND(M26*$N$27,0)","v":725676},653108,{"$f":"(N26-O26)","v":72568}]
["TOTAL",{"$f":"SUM(B11:B26)","v":122769},0.99999999999999978,30618,1,14817,1,1,0.99999999999999989,0.99999999999999978,{"$f":"SUM(K11:K26)","v":1},{"$f":"SUM(L11:L26)","v":0.9000999999999999},0.99999999999999978,14369821,{"$f":"SUM(O11:O26)","v":12932840},{"$f":"(N27-O27)","v":1436981}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M11:M27)","v":1.9999999999999998},{"$f":"SUM(N11:N26)","v":14369821},{"$f":"SUM(O11:O27)","v":25865680},{"$f":"SUM(P11:P27)","v":2873962}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N11:N26)","v":14369821},{"$f":"SUM(O11:O26)","v":12932840},1436981]
["Data on ASU unemployed and ASU excess unemployment data are for the 7/1/23 - 6/30/24 benchmark period used for state ASU determination for FY26."]
["* 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. "]
["**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."]
["FY 2026 total allotment for workforce areas assumes Governor's Reserve for statewide activities at 15% for the period 7/1/25 - 6/30/26."]
["FY 2026 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 11-24, May 20, 2025."]
[]
["Prepared by:  MassHire Department of Career Services",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","2025-06-03"]

{"sheet":"Dis Wrk FY26 060325","index":3,"n_rows":34,"n_cols":25,"rows_kept":34,"cut":false,"hidden":false,"merged":[[28,13,28,20],[7,23,8,23],[7,24,8,24],[8,17,8,20],[33,6,33,8],[33,11,33,12],[33,21,33,22],[7,5,8,6],[7,22,8,22],[10,5,25,6],[6,22,6,24],[7,1,8,2],[7,3,8,4],[7,7,8,8],[7,9,8,10],[7,11,8,12],[7,13,8,13],[7,16,8,16],[7,17,7,20],[6,5,6,6],[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],[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 2026 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 2026 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 2026","Hold Harmless Level Fiscal Year 2026",null,null,null,"Adjusted","Fiscal Year 2026"]
[null,"CY24 Average\nMonthly UI Claimants",null,"CY24 Annual Avg\nUnemp. Rate",null,"CY23 Claimants\nin Mass Layoffs",null,"3-Year Job Loss in\nDeclining Indus.",null,"CY24 Avg Lng Trm\nUI Claims (26+Wks)",null,"CY24 Annual Total\nof UI Exhaustees ",null,"Formula\nShare","Hold","Formula"," Total \nAllocation","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*",null,"Avg Dislocated Worker Share (Prior 2 Years) ",null,null,null,"Share"]
[null,"Count","Pct","Count","Pct","Count","Pct","Count","Pct","Count","Pct","Count","Pct","FY26","FY26","FY26","FY25","FY24","FY25","Average","90% HH","FY26","FY26","FY26","FY26"]
["Berkshire County",915,{"$f":"+B11/B27","v":1.4518509115719658E-2},4,{"$f":"+D11/$D$27","v":5.9612518628912078E-2},"\nData not available \nfor this factor.\n\nFactor weight \n(10%) was\napportioned \nacross the five remaining factors.",null,1534,{"$f":"+H11/H27","v":7.2541898384595018E-3},515,{"$f":"+J11/J27","v":1.1277783860724843E-2},836,{"$f":"+L11/L27","v":1.415389824769322E-2},{"$f":"ROUND(C11*0.2778+E11*0.2778+I11*0.1111+K11*0.1667+M11*0.1667,4)","v":2.5600000000000001E-2},2.7900000000000001E-2,2.7900000000000001E-2,{"$f":"ROUND(P11*$W$27,0)","v":299163},3.2599999999999997E-2,2.9499999999999998E-2,{"$f":"+(R11+S11)/2","v":3.1049999999999998E-2},{"$f":"ROUND(T11*0.9,4)","v":2.7900000000000001E-2},2.7900000000000001E-2,{"$f":"ROUND(V11*$W$27,0)","v":299163},{"$f":"ROUND(W11*0.9,0)","v":269247},{"$f":"(W11-X11)","v":29916}]
["Boston",5901,{"$f":"+B12/B27","v":9.3632483379083822E-2},3.9,{"$f":"+D12/$D$27","v":5.8122205663189271E-2},null,null,46824,{"$f":"+H12/H27","v":0.22142776075360346},4684,{"$f":"+J12/J27","v":0.10257308660900033},6002,{"$f":"+L12/L27","v":0.1016168627782951},{"$f":"ROUND(C12*0.2778+E12*0.2778+I12*0.1111+K12*0.1667+M12*0.1667,4)","v":0.1008},8.2400000000000001E-2,0.10009999999999999,{"$f":"ROUND(P12*$W$27,0)","v":1073341},9.1499999999999998E-2,9.1700000000000004E-2,{"$f":"+(R12+S12)/2","v":9.1600000000000001E-2},{"$f":"ROUND(T12*0.9,4)","v":8.2400000000000001E-2},0.10009999999999999,{"$f":"ROUND(V12*$W$27,0)-1","v":1073340},{"$f":"ROUND(W12*0.9,0)","v":966006},{"$f":"(W12-X12)","v":107334}]
["Bristol County",5506,{"$f":"+B13/B27","v":8.7364930263554574E-2},4.4000000000000004,{"$f":"+D13/$D$27","v":6.5573770491803296E-2},null,null,8173,{"$f":"+H13/H27","v":3.8649604660840615E-2},2490,{"$f":"+J13/J27","v":5.4527537501368663E-2},3365,{"$f":"+L13/L27","v":5.6971133496994834E-2},6.54E-2,6.25E-2,6.5299999999999997E-2,{"$f":"ROUND(P13*$W$27,0)","v":700192},6.9599999999999995E-2,6.9199999999999998E-2,6.9399999999999989E-2,6.25E-2,6.5299999999999997E-2,{"$f":"ROUND(V13*$W$27,0)","v":700192},{"$f":"ROUND(W13*0.9,0)","v":630173},{"$f":"W13-X13","v":70019}]
["Brockton",2538,{"$f":"+B14/B27","v":4.0271012170160103E-2},4.4000000000000004,{"$f":"+D14/$D$27","v":6.5573770491803296E-2},null,null,4334,{"$f":"+H14/H27","v":2.0495214315439034E-2},2001,{"$f":"+J14/J27","v":4.3819117486039637E-2},2563,{"$f":"+L14/L27","v":4.3392872259375263E-2},4.6199999999999998E-2,4.3400000000000001E-2,4.6100000000000002E-2,494316,4.7899999999999998E-2,4.8500000000000001E-2,4.82E-2,4.3400000000000001E-2,4.6100000000000002E-2,494316,444884,49432]
["Cape Cod & Islands",2923,{"$f":"+B15/B27","v":4.6379893054916459E-2},4.9000000000000004,7.3025335320417301E-2,null,null,13521,{"$f":"+H15/H27","v":6.3939961411871526E-2},1296,{"$f":"+J15/J27","v":2.8380597832037665E-2},2722,{"$f":"+L15/L27","v":4.6084821806484384E-2},5.2699999999999997E-2,4.6899999999999997E-2,5.2499999999999998E-2,562941,5.5399999999999998E-2,4.8899999999999999E-2,5.2150000000000002E-2,4.6899999999999997E-2,5.2499999999999998E-2,562941,506647,56294]
["Central Mass",5541,{"$f":"+B16/B27","v":8.7920283071259694E-2},4,5.9612518628912078E-2,null,null,12296,{"$f":"+H16/H27","v":5.8147013203192981E-2},3896,{"$f":"+J16/J27","v":8.5316982371619401E-2},4985,{"$f":"+L16/L27","v":8.4398543976974522E-2},7.5700000000000003E-2,7.1900000000000006E-2,7.5600000000000001E-2,810635,7.9200000000000007E-2,8.0600000000000005E-2,7.9899999999999999E-2,7.1900000000000006E-2,7.5600000000000001E-2,810635,729572,81063]
["Franklin/Hampshire",1528,{"$f":"+B17/B27","v":2.4245116862097963E-2},3.8,5.663189269746647E-2,null,null,2227,{"$f":"+H17/H27","v":1.0531343396511936E-2},995,{"$f":"+J17/J27","v":2.1789116391109163E-2},1320,{"$f":"+L17/L27","v":2.2348260391094558E-2},3.1E-2,2.9399999999999999E-2,3.09E-2,331331,3.4299999999999997E-2,3.1099999999999999E-2,3.27E-2,2.9399999999999999E-2,3.09E-2,331331,{"$f":"ROUND(W17*0.9,0)","v":298198},33133]
["Greater Lowell",3282,{"$f":"+B18/B27","v":5.2076226139663298E-2},4.0999999999999996,6.1102831594634872E-2,null,null,4758,{"$f":"+H18/H27","v":2.2500283736238792E-2},2297,{"$f":"+J18/J27","v":5.0301105879776632E-2},2829,{"$f":"+L18/L27","v":4.7896385338186742E-2},5.0299999999999997E-2,4.4200000000000003E-2,5.0099999999999999E-2,537207,4.6699999999999998E-2,5.16E-2,4.9149999999999999E-2,4.4200000000000003E-2,5.0099999999999999E-2,537207,483486,53721]
["Gtr New Bedford",2452,{"$f":"+B19/B27","v":3.8906430985513225E-2},5.0999999999999996,7.6005961251862889E-2,null,null,3275,{"$f":"+H19/H27","v":1.5487269700752846E-2},1632,{"$f":"+J19/J27","v":3.5738530603306687E-2},2300,{"$f":"+L19/L27","v":3.8940150681452637E-2},4.6100000000000002E-2,4.6600000000000003E-2,4.6600000000000003E-2,499677,5.3400000000000003E-2,5.0200000000000002E-2,5.1799999999999999E-2,4.6600000000000003E-2,4.6600000000000003E-2,499677,449709,49968]
["Hampden County",4428,{"$f":"+B20/B27","v":7.0260063786236768E-2},5.0999999999999996,7.6005961251862889E-2,null,null,7914,{"$f":"+H20/H27","v":3.7424809896720007E-2},3260,{"$f":"+J20/J27","v":7.1389466768860182E-2},4334,{"$f":"+L20/L27","v":7.3376788284093789E-2},6.8900000000000003E-2,6.9800000000000001E-2,6.9800000000000001E-2,748444,7.9799999999999996E-2,7.5399999999999995E-2,7.7600000000000002E-2,6.9800000000000001E-2,6.9800000000000001E-2,748444,673600,74844]
["Merrimack Valley",4008,{"$f":"+B21/B27","v":6.3595830093775285E-2},4.3,6.4083457526080481E-2,null,null,7343,{"$f":"+H21/H27","v":3.4724586690878828E-2},2729,{"$f":"+J21/J27","v":5.9761305157122524E-2},3501,{"$f":"+L21/L27","v":5.927368153728943E-2},5.9200000000000003E-2,5.3400000000000003E-2,5.8999999999999997E-2,632639,5.8099999999999999E-2,6.0600000000000001E-2,5.935E-2,5.3400000000000003E-2,5.8999999999999997E-2,632639,569375,63264]
["Metro North",6412,{"$f":"+B22/B27","v":0.10174063437157863},3.5,5.2160953800298067E-2,null,null,31680,{"$f":"+H22/H27","v":0.14981273408239701},5414,{"$f":"+J22/J27","v":0.11855907149895982},6594,{"$f":"+L22/L27","v":0.11163971895369508},9.7799999999999998E-2,8.3299999999999999E-2,9.7299999999999998E-2,1043318,9.1300000000000006E-2,9.3700000000000006E-2,9.2499999999999999E-2,8.3299999999999999E-2,9.7299999999999998E-2,1043318,938986,104332]
["Metro South/West",6568,{"$f":"+B23/B27","v":0.10421592117163575},3.5,5.2160953800298067E-2,null,null,39467,{"$f":"+H23/H27","v":0.18663696894033974},5938,{"$f":"+J23/J27","v":0.13003394284462938},6885,{"$f":"+L23/L27","v":0.11656649453991365},0.1053,8.3299999999999999E-2,0.1045,1120521,8.5999999999999993E-2,9.9099999999999994E-2,9.2549999999999993E-2,8.3299999999999999E-2,0.1045,{"$f":"ROUND(V23*$W$27,0)-1","v":1120520},1008468,{"$f":"(W23-X23)","v":112052}]
["North Central",2506,{"$f":"+B24/B27","v":3.9763261031686842E-2},4.3,6.4083457526080481E-2,null,null,3694,{"$f":"+H24/H27","v":1.7468694434986571E-2},1769,{"$f":"+J24/J27","v":3.8738640096353881E-2},2293,{"$f":"+L24/L27","v":3.882163717937865E-2},4.3700000000000003E-2,3.85E-2,4.3499999999999997E-2,466437,4.3400000000000001E-2,4.2099999999999999E-2,4.2749999999999996E-2,3.85E-2,4.3499999999999997E-2,466437,419793,46644]
["North Shore",3693,{"$f":"+B25/B27","v":5.8597654824429177E-2},3.9,5.8122205663189271E-2,null,null,11978,{"$f":"+H25/H27","v":5.6643211137593158E-2},2795,{"$f":"+J25/J27","v":6.1206613380050366E-2},3576,{"$f":"+L25/L27","v":6.0543469059510711E-2},5.8999999999999997E-2,5.1900000000000002E-2,5.8700000000000002E-2,629422,5.8299999999999998E-2,5.7000000000000002E-2,5.765E-2,5.1900000000000002E-2,5.8700000000000002E-2,629422,566480,62942]
["South Shore",4822,{"$f":"+B26/B27","v":7.6511749678688734E-2},3.9,5.8122205663189271E-2,null,null,12446,{"$f":"+H26/H27","v":5.8856353800174024E-2},3954,{"$f":"+J26/J27","v":8.658710171904084E-2},4960,{"$f":"+L26/L27","v":8.3975281469567425E-2},7.2400000000000006E-2,6.4500000000000002E-2,7.2099999999999997E-2,773106,7.2499999999999995E-2,7.0800000000000002E-2,7.1649999999999991E-2,6.4500000000000002E-2,7.2099999999999997E-2,773106,695795,77311]
["TOTAL",{"$f":"SUM(B11:B26)","v":63023},{"$f":"SUM(C11:C26)","v":1},{"$f":"SUM(D11:D26)","v":67.099999999999994},{"$f":"SUM(E11:E26)","v":1},null,null,{"$f":"SUM(H11:H26)","v":211464},{"$f":"SUM(I11:I26)","v":1.0000000000000002},45665,1.0000000000000002,59065,1,1.0001,0.89990000000000014,1,10722688,1,1,{"$f":"SUM(T11:T26)","v":0.99999999999999989},{"$f":"SUM(U11:U26)","v":0.89990000000000014},1,10722688,{"$f":"SUM(X11:X26)","v":9650419},{"$f":"SUM(Y11:Y26)","v":1072269}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W11:W26)","v":10722688},{"$f":"SUM(X11:X26)","v":9650419},{"$f":"SUM(Y11:Y26)","v":1072269}]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Calculation of FY 2026 Dislocated Worker Local Program Allocations with Factor Weights Approved June  2025."]
[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,"FY 2026 total allotment for workforce areas assumes Governor's Reserve for statewide activities at 15% for the period 7/1/25 - 6/30/26."]
[null,"FY 2026 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 11-24, May 20, 2025"]
[null,"Prepared by:  MassHire Department of Career Services",null,null,null,null,null,null,null,null,null,"2025-06-03",null,null,null,"Prepared by:  MassHire Department of Career Services",null,null,null,null,null,"2026-06-03"]

{"sheet":" Awards FY26 Adult 060325","index":4,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,10,32,11],[29,0,29,10],[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],[5,5,7,7],[5,8,7,10]]}
["ATTACHMENT  -   5"]
["COMMONWEALTH OF MASSACHUSETTS"]
["FISCAL YEAR 2026 WIOA TITLE I FORMULA ALLOCATIONS FOR ADULT ACTIVITIES"]
["FUNDING AVAILABILITY"]
[]
["MASSHIRE\nWORKFORCE \nAREAS","Adjusted","Fiscal Year 2026 Adult",null,null,"Funds Available as of July 1, 2025\nDOL Notice of Award (NOA)",null,null," Funds Available as of October 1, 2025\nDOL Notice of Award (NOA)"]
[null,"Formula","Total","Program 90%","Admin 10%"]
[null,"Share","Allocation","Amount","Amount"]
[null,"FY26","FY26","FY26","FY26","Total","90% Program","10% Admin","Total","90% Program","10% Admin"]
["Berkshire County",2.1999999999999999E-2,273390,246051,27339,{"$f":"ROUND(B10*$F$26,0)","v":53206},{"$f":"ROUND(F10*0.9,0)","v":47885},{"$f":"F10-G10","v":5321},{"$f":"C10-F10","v":220184},{"$f":"D10-G10","v":198166},{"$f":"E10-H10","v":22018}]
["Boston",0.1394,1732295,1559066,173229,{"$f":"ROUND(B11*$F$26,0)","v":337130},{"$f":"ROUND(F11*0.9,0)","v":303417},{"$f":"F11-G11","v":33713},{"$f":"C11-F11","v":1395165},1255649,139516]
["Bristol County",5.8099999999999999E-2,721997,649797,72200,{"$f":"ROUND(B12*$F$26,0)","v":140511},126460,14051,581486,523337,58149]
["Brockton",5.4800000000000001E-2,680989,612890,68099,132530,119277,13253,548459,493613,54846]
["Cape Cod & Islands",5.8099999999999999E-2,721997,649797,72200,140511,126460,14051,581486,523337,58149]
["Central Mass",7.3599999999999999E-2,914612,823151,91461,177997,160197,17800,736615,662954,73661]
["Franklin/Hampshire",2.5700000000000001E-2,319369,287432,31937,{"$f":"ROUND(B16*$F$26,0)","v":62154},{"$f":"ROUND(F16*0.9,0)","v":55939},6215,257215,231493,25722]
["Greater Lowell",2.9700000000000001E-2,369076,332168,36908,71828,64645,7183,297248,267523,29725]
["Gtr New Bedford",4.1300000000000003E-2,513227,461904,51323,99881,89893,9988,413346,372011,41335]
["Hampden County",0.1246,1548378,1393540,154838,{"$f":"ROUND(B19*$F$26,0)","v":301337},271203,30134,{"$f":"C19-F19","v":1247041},1122337,124704]
["Merrimack Valley",8.4199999999999997E-2,1046336,941702,104634,203632,183269,20363,842704,758433,84271]
["Metro North",8.4699999999999998E-2,1052550,947295,105255,204842,184358,20484,847708,762937,84771]
["Metro South/West",5.8500000000000003E-2,726968,654271,72697,141479,127331,14148,585489,526940,58549]
["North Central",3.4500000000000003E-2,428725,385853,42872,83436,75092,8344,345289,310761,34528]
["North Shore",5.4100000000000002E-2,672290,605061,67229,130837,117753,13084,541453,487308,54145]
["South Shore",5.67E-2,704600,634140,70460,137125,123413,13712,567475,510727,56748]
["TOTAL",0.99998484285058375,12426799,11184118,1242681,2418436,{"$f":"SUM(G10:G25)","v":2176592},{"$f":"SUM(H10:H25)","v":241844},{"$f":"SUM(I10:I25)","v":10008363},9007526,1000837]
[null,null,{"$f":"SUM(C10:C25)","v":12426799},{"$f":"SUM(D10:D25)","v":11184118},1242681,2418436,2176592,241844,10008363,9007526,1000837]
["Source:"]
["1.  FY 2026 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 11-24, May 20, 2025."]
["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).  \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:","2025-06-03"]

{"sheet":" Awards FY26 Youth 060323","index":5,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[30,0,30,10],[33,4,33,6],[33,10,33,11],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,8,0],[5,2,5,4],[5,5,7,7],[5,8,7,10]]}
["ATTACHMENT  -  6"]
["COMMONWEALTH OF MASSACHUSETTS"]
["FISCAL YEAR 2026 WIOA TITLE I FORMULA ALLOCATIONS FOR YOUTH ACTIVITIES"]
["FUNDING AVAILABILITY"]
[]
["MASSHIRE\nWORKFORCE\nAREAS","Adjusted"," Fiscal Year 2026 Youth ",null,null," Funds Available as of April 1, 2025\nDOL Notice of Award (NOA)",null,null,"Funds Available as of October 1, 2025\nDOL Notice of Award (NOA)"]
[null,"Formula","Total","Program 90%","Admin 10%"]
[null,"Share","Allocation","Amount","Amount"]
[null,"FY26","FY26","FY26","FY26","Total","90% Program","10% Admin","Total","90% Program","10% Admin"]
["Berkshire County",2.2599999999999999E-2,324758,292283,32475,324758,292283,32475]
["Boston",0.15451918739754983,2220412,1998371,222041,2220412,1998371,222041]
["Bristol County",5.1900000000000002E-2,745794,671215,74579,745794,671215,74579]
["Brockton",5.5856440420348014E-2,802647,722382,80265,802647,722382,80265]
["Cape Cod & Islands",5.5484733766967276E-2,797306,717575,79731,797306,717575,79731]
["Central Mass",7.2163941493216657E-2,1036983,933285,103698,1036983,933285,103698]
["Franklin/Hampshire",4.2473986563910993E-2,610344,549310,61034,610344,549310,61034]
["Greater Lowell",2.7799999999999998E-2,399481,359533,39948,399481,359533,39948]
["Gtr New Bedford",4.0099999999999997E-2,576230,518607,57623,576230,518607,57623]
["Hampden County",0.11641636299931643,1672882,1505594,167288,1672882,1505594,167288]
["Merrimack Valley",8.0064652744841994E-2,1150515,1035464,115051,1150515,1035464,115051]
["Metro North",8.7253462180607505E-2,1253817,1128435,125382,1253817,1128435,125382]
["Metro South/West",6.4500000000000002E-2,926853,834168,92685,926853,834168,92685]
["North Central",2.93E-2,421036,378932,42104,421036,378932,42104]
["North Shore",4.9067232433241299E-2,705087,634578,70509,705087,634578,70509]
["South Shore",5.0500000000000003E-2,725676,653108,72568,725676,653108,72568]
["TOTAL",0.99999999999999978,{"$f":"+SUM(C10:C25)","v":14369821},12932840,1436981,{"$f":"+SUM(F10:F25)","v":14369821},{"$f":"+SUM(G10:G25)","v":12932840},1436981]
[]
["Source:"]
[null,null,null," "]
["1.  FY 2026 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 11-24, May 20, 2025."]
["USDOL will issue the allotment for yout in one Notice of Award (NOA) for April 1, 2025.  \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:","2025-06-03"]

{"sheet":"Awards FY26 DWrk 0603623","index":6,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,8,7,10],[28,0,28,10],[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],[5,5,7,7]]}
["ATTACHMENT  -  7"]
["COMMONWEALTH OF MASSACHUSETTS"]
["FISCAL YEAR 2026 WIOA TITLE I FORMULA ALLOCATIONS FOR DISCLOCATED WORKER PROGRAMS"]
["FUNDING AVAILABILITY"]
[]
["MASSHIRE\nWORKFORCE\nAREAS","Adjusted","Fiscal Year 2026",null,null,"Funds Available as of July 1, 2025\nDOL Notice of Award (NOA)",null,null," Funds Available as of October 1, 2025\nDOL Notice of Award (NOA)"]
[null,"Formula","Total","Program 90%","Admin 10%"]
[null,"Share","Allocation","Amount","Amount"]
[null,"FY26","FY26","FY26","FY26","Total","90% Program","10% Admin","Total","90% Program","10% Admin"]
["Berkshire County",2.7900000000000001E-2,299163,269247,29916,{"$f":"ROUND(B10*$F$26,0)","v":63856},{"$f":"ROUND(F10*0.9,0)","v":57470},{"$f":"F10-G10","v":6386},{"$f":"C10-F10","v":235307},{"$f":"D10-G10","v":211777},{"$f":"E10-H10","v":23530}]
["Boston",0.10009999999999999,1073340,966006,107334,{"$f":"ROUND(B11*$F$26,0)","v":229104},206194,{"$f":"F11-G11","v":22910},{"$f":"C11-F11","v":844236},759812,84424]
["Bristol County",6.5299999999999997E-2,700192,630173,70019,149456,134510,14946,550736,495663,55073]
["Brockton",4.6100000000000002E-2,494316,444884,49432,105512,94961,10551,388804,349923,38881]
["Cape Cod & Islands",5.2499999999999998E-2,562941,506647,56294,120160,108144,12016,442781,398503,44278]
["Central Mass",7.5600000000000001E-2,810635,729572,81063,173030,155727,17303,637605,573845,63760]
["Franklin/Hampshire",3.09E-2,331331,298198,33133,70723,63651,7072,260608,234547,26061]
["Greater Lowell",5.0099999999999999E-2,537207,483486,53721,114667,103200,11467,422540,380286,42254]
["Gtr New Bedford",4.6600000000000003E-2,499677,449709,49968,106656,95990,10666,393021,353719,39302]
["Hampden County",6.9800000000000001E-2,748444,673600,74844,159755,143780,15975,588689,529820,58869]
["Merrimack Valley",5.8999999999999997E-2,632639,569375,63264,135037,121533,13504,497602,447842,49760]
["Metro North",9.7299999999999998E-2,1043318,938986,104332,222696,200426,22270,820622,738560,82062]
["Metro South/West",0.1045,1120520,1008468,112052,239175,215258,23917,881345,793210,88135]
["North Central",4.3499999999999997E-2,466437,419793,46644,99561,{"$f":"ROUND(F23*0.9,0)","v":89605},{"$f":"F23-G23","v":9956},366876,330188,36688]
["North Shore",5.8700000000000002E-2,629422,566480,62942,134350,{"$f":"ROUND(F24*0.9,0)","v":120915},13435,495072,445565,49507]
["South Shore",7.2099999999999997E-2,773106,695795,77311,165019,{"$f":"ROUND(F25*0.9,0)","v":148517},16502,608087,547278,60809]
["TOTAL",1,10722688,9650419,1072269,2288756,{"$f":"SUM(G10:G25)","v":2059881},{"$f":"SUM(H10:H25)","v":228876},{"$f":"C26-F26","v":8433932},{"$f":"SUM(J10:J25)","v":7590538},{"$f":"SUM(K10:K25)","v":843393}]
["Source:"]
["1.  FY 2026 Initial state program allotments published in Training and Employment Guidance Letter (TEGL) 11-24, May 20, 2025."]
["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,null," Date: ","2025-06-03"]

{"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!"}}]