{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main Menu","Calculate","Calculations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Main Menu","index":0,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,null,"Employer Cost Of Layoffs Calculator - 2019"]
[null,"This calculator estimates the increase in UI taxes that will result in the following year after making a layoff in the"]
[null," current year.  Also, an estimate is provided of how many layoffs an employer can make before reaching the maximum"]
[null," tax rate in the state's tax schedule, (after which no further tax increases will take place).  While the calculator was   "]
[null,"constructed for tax year 2019, any year can be used with the understanding that differences will result due to changes in state law."]
[null,"For a description of the calculator methodology see: https://www.bls.gov/opub/mlr/2020/article/the-cost-of-layoffs-in-ui-taxes.htm"]
[null,"Actual added tax amount may vary, employers should contact their state office for assistance."]
[null,"© CRUIS 2021"]
[null,"Inputs:"]
[null,null,"State:",null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,"Average Number of Employees Employed by the Company in 2018:",null,null,null,null,null,null,null,null,null,5]
[null,null,"The number of those Employees that earn less than the "]
[null,null,"State Unemployment Insurance Taxable Wage Base:",null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Total Wages Paid by Employer in Last Calendar Year (000):",null,null,null,null,null,null,null,null,null,200]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Number of Planned Layoffs in 2018:",null,null,null,null,null,null,null,null,3," ",null," "," "]
[null,null,null,null," ",null," ",null,null,null,null," "]
[]
[null,"Output:"]
[null,null,"1) Employer will pay approximately this much more in taxes"]
[null,null,"per employee in 2019 as a result of these layoffs1: ",null,null,null,null,null,null,null,null,null,{"$f":"+Calculations!BI12","v":833.39622641509425}]
[]
[null,null,"2) For a total increase in UI Taxes as a percent of total wages of:",null,null,null,null,null,null,null,null,null,{"$f":"+Calculations!BI15","v":2.0834905660377358E-2}]
[]
[null,null,"3) In this state, The employer's tax rate will vary between ",null,null,null,null,null,null,null,{"$f":"+Calculations!BI16/100","v":1.4999999999999999E-2},"and",{"$f":"+Calculations!BI17/100","v":6.2E-2}]
[]
[null,null,"4) The Estimated Number of Layoffs the Employer would need "]
[null,null,"to make in 2018 in order to reach the maximum tax "]
[null,null,"rate in the State's tax schedule in 20192:",null,null,null,null,null,null,null,null,null,{"$f":"+Calculations!BI13","v":3}]
[]
[null,"Assumptions:"]
[null,"*  Each laid off employee receives the average total Unemployment Insurance benefits per claimant paid in the last year."]
[null,"* All employee benefits are assigned to the employer's state experience rating formulation."]
[null,"* Employer cannot lay off more emolyees than listed as employed."]
[null,"Notes:"]
[null,"1. Applicable only for employers that are not assigned the minimum tax rate in Reserve Ratio experience rating states and "]
[null,"those not already at the maximum tax rate in any state. "]
[]
[null,"2. This amount represents the minimum number of layoffs needed to move an employer to the maximum tax rate, if in  "]
[null,"the current year they are assigned the lowest tax rate in the state tax schedule. Employers assigned a rate higher than "]
[null,"the minimum rate could need fewer layoffs to reach the maximum tax rate."]
[null," "]
[]
[null," "]

{"sheet":"Calculate","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calculations","index":2,"n_rows":129,"n_cols":62,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
[null,null,"Calculations for Estimated Marginal Impact of Making Layoffs for an Individual Employer and the Number of Layoffs Needed to Reach the Maximum Tax Rate"]
[null," "]
[]
[null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Input Data",null,null,null,null,null,null,null,"User Inputs",null,null,null,"Calculated Variables based on Inputs",null,null,null,null,null,null,null,null,"Outputs",null,null,null,null,null," INPUTS- From State Law",null,null,null,null,null,null,null,null,null,null,"Calculations from State law",null,null,null,null,null,null,null,null,null,null,null,null,"Calculations For Output of Marginal Tax Cost Screen"]
[null,null,2019,2018,2019,2019,2019,2019,2019,2019,null,null,null,null,null,"%MTWB < is avg Wage",null,null,null,"Up to Max Ben Rat",null,null,null,null,"For each employee making the tax base ",null,"Output Analysis Check",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"chg. In tax per Chg in Interval"]
[null,null,null,"Average Benefits per ","MTC","Max Intervl in Exp. Tax Tabl ","Max Intervl in Exp. Tax Tabl ","Avg. tax rate Chng","Years in State Exp Rate",null,null,null,null," ",null,0.66600000000000004,"Tot bens","Bens Charg- Cont","Tot Ben ratio","Due to max amt of","Num. of intervals ","Tot Bens Needed",null,null,"employer will pay this much more in taxes",null,null,null,null,null,null,null,2019,2019,2019,2019,2019,2019,2019,2019,null,2019,null,"Reserve Ratio","Adjustment Factor","Diff. Betwn",null,null,"slope of state sched.","Avg Tax Chg per Intvl","Max Intervl in Tax Tabl ","Adj Max Interval",null,null,null,"ABB","State",null,"Year"]
[null,null,null,"First Payment","Per Emp Tax Diff /","MAXBENRATIO (%)","MAXBENRATIO (%)","     per interval","Formula for Averaging","Avg Tax Rate Chg per",null,"Number of ","Number of ","Employer","Employer Est. ","Amt of Tax Wages","Charged","for Res Rat St's","Charged","Bens Needed to reach"," the Ben Ratio Takes","to reach Max interval","Include. Cont for RR",null,"next year",null,"Tot. Tax Payment/",null,"Diff (Benefits- tax Pay)",null,null,null,null,"Maximum","Statutory","Statutory","Min. Exper. Rate","Max Exper.","Years in","Avg Cont. Rate",null,"# Intervals","# of Intervals to","Adj.fac for Bal+Cont",3.7,"Max-Min ","Est Contributions",null,"Marginal tax cost ","Average Slope","MAXBENRATIO (%)","for Res. Ratio bal.",null,null,1,"AK","Alaska",1,2010," "," ",8]
[null,null,"Exp. Rat. Type","Tot Ben / First Pays","Exper Intrvl Diff","BR: Max Intrl* Yrs",null," Tax Range  / Intrvls ","For benefit Ratio States","Interval  * Years in formula",null,"Employees","Employees < Base","Tot wags","Curr yr layoffs","Input ","avg ben* inp lay",null," ","max interval","Ben rato/benRat perintrvl","over yrs in Frmla","Add Avg. Contrib.",null,"Total change in per employee tax cost as ","Payment as a","Total Benefits Charg.","Total payment","one year",null,"State","State","Experience Formula","Taxable","Min. Tax","Max. Tax","Interval","interval","Exp Rating Formula","Per Employer",null," ","rep. 1% chg.","From Avg.Res. Rat Bal.","Final adj Intervals","Exp rate","for the Employer",null,"Chg. In Tax per 1%","Tax Range / intervls","Max Intrvl(%)* Yrs-in frmula","Max Intrvl(%)* Yrs-in frmula","Max Tax capacity",null,2,"AL","ALABAMA",2,2011,"STATE:",5," "]
["ABB.","STATE",null,"From 394 report","( Column BI)","RR: Diff in Max Min Exp Rt",null,"Column AO","Res. Ratio States= 1",null,null,null,null,"  (000)",null,">Base + < Base",null,null,null,"Reduced for rounding",null,null,null,null,"a result of these layoffs","% of tot. Wages","one yr.",null,null,null,null,null,null,"Wage Base","Rate","Rate"," ",null,null,"(for Res Ratio)",null,null,null," ",null,null,null,null," "," ","For BenRatio or just Res Rat","RR: Adj Diff of max min","Max Tax rate  * MTWB",null,3,"AR","ARKANSAS",3,2012,"YR:",{"$f":"INDEX($BG$8:$BG$17,MATCH($BJ$8,$BF$8:$BF$17,0))","v":2017}," "]
["AK","Alaska","Payroll Decline",4530.512491359731,{"$f":"+AW11","v":83.600000000000023},{"$f":"+AY11","v":"NA"},"NA",{"$f":"+AX11","v":2.0952380952380953E-3},3,{"$f":"+H11*I11","v":6.285714285714286E-3},null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},{"$f":"+((L11-M11)*(AH11))+(M11*(AH11*$P$7))","v":172846.8},{"$f":"+D11*O11","v":13591.537474079192},{"$f":"IF(AG11=\"Reserve Ratio\",Q11-AU11,Q11)","v":13591.537474079192},{"$f":"+R11/P11","v":7.8633434197677904E-2},{"$f":"+W11/P11","v":{"$error":"#VALUE!"}},{"$f":"+S11/(J11)","v":12.509864531448757},{"$f":"+(F11)*(P11)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG10=\"Reserve Ratio\",V11-AU11,V11)","v":{"$error":"#VALUE!"}},null,{"$f":"+U11*E11","v":1045.8246748291165},{"$f":"+AB11/(N11*1000)","v":2.6145616870727913E-2},{"$f":"+(AB11)/Q11","v":0.38473376423514943},{"$f":"IF(O11>M75,((L11)*Y11),((L11)*Y11))","v":5229.1233741455826},{"$f":"+Q11-AB11","v":8362.4140999336087},null,"AK","ALASKA","Payroll Decline",39900,1.5,5.9,0,21,3,1,null,21,{"$f":"IF(AT11>AP11,AP11,AT11)","v":21}," ",{"$f":"IF(C11=\"Reserve Ratio\",AQ11/($AS$8+AR11),AQ11)","v":21},{"$f":"+AL11-AK11","v":21},{"$f":"+((AN11/100)*P11)","v":1728.4679999999998},null,{"$f":"+((AH11*(AJ11/100))-(AH11*(AI11/100))) /(AQ11)","v":83.600000000000023},{"$f":"+((AJ11-AI11)/100)/AS11","v":2.0952380952380953E-3},"NA","NA",{"$f":"+(AJ11/100)*AH11","v":2354.1000000000004},null,4,"AZ","ARIZONA",4,2013,"CALCULATION"]
["AL","Alabama","Benefit Ratio",2876.0403754205772,{"$f":"+AW12","v":68.333333333333329},{"$f":"+AY12","v":0.21600000000000003},{"$f":"+AT12/100","v":7.2000000000000008E-2},{"$f":"+AX12","v":8.5416666666666662E-3},3,{"$f":"+H12*I12","v":2.5624999999999998E-2},null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},{"$f":"+((L12-M12)*(AH12))+(M12*(AH12*$P$7))","v":34656},8628.1211262617326,8628.1211262617326,{"$f":"+Q12/P12","v":0.24896471393876191},{"$f":"+W12/P12","v":0.21600000000000003},{"$f":"IF(S12>T12,T12/(J12),S12/J12)","v":8.429268292682929},7485.6960000000008,{"$f":"IF(AG12=\"Reserve Ratio\",V12+AU12,V12)","v":7485.6960000000008},null,576.00000000000011,1.4400000000000003E-2,{"$f":"+(AB12)/Q12","v":0.33379225417154118},{"$f":"IF(O12>M76,((L12)*Y12),((L12)*Y12))","v":2880.0000000000005},5748.1211262617326,null,"AL","ALABAMA","Benefit Ratio",8000,0.65,6.8,0,7.2,3,1.2,null,26,7.2," ",7.2,7.2,415.87200000000001,null,{"$f":"+((AH12*(AJ12/100))-(AH12*(AI12/100))) /(AQ12)","v":68.333333333333329},8.5416666666666662E-3,{"$f":"IF(AG12=\"Benefit Ratio\",(AL12/100)*AM12,(AT12/100))","v":0.21600000000000003},{"$f":"IF(AG12=\"Benefit Ratio\",(AL12/100)*AM12,(AS12/100))","v":0.21600000000000003},{"$f":"+(AJ12/100)*AH12","v":544},null,5,"CA","CALIFORNIA",5,2014,"MTC",{"$f":"SUMIFS($Y$11:$Y$63,$BC$8:$BC$60,\"=\"&$BI$9)","v":833.39622641509425}]
["AR","Arkansas","Reserve Ratio",2558.8865096359741,59.296482412060307,9.9499999999999991E-2,{"$f":"+AT13/100","v":9.9499999999999991E-2},2.2479296482412064E-2,1,2.2479296482412064E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},{"$f":"+((L13-M13)*(AH13))+(M13*(AH13*$P$7))","v":43320},7676.6595289079223,7039.8555289079222,0.17720820703850237,{"$f":"+W13/P13","v":0.11419999999999998},5.0802301615333354,4310.3399999999992,4947.1439999999993,null,301.23977842257972,7.5309944605644928E-3,0.19620498817760773,1506.1988921128986,6170.4606367950237,null,"AR","ARKANSAS","Reserve Ratio",10000,0.1,6,0,9.9499999999999993,3,1.47,null,13,9.9499999999999993,9.0999999999999998E-2,2.6246372988657343,9.9499999999999993,636.80399999999997,null,{"$f":"+((AH13*(AJ13/100))-(AH13*(AI13/100))) /(AQ13)","v":59.296482412060307},2.2479296482412064E-2,9.9499999999999991E-2,{"$f":"IF(AG13=\"Benefit Ratio\",(AL13/100)*AM13,(AS13/100))","v":2.6246372988657344E-2},600,null,6,"CO","COLORADO",6,2015,"Max Layoffs",{"$f":"SUMIFS($M$75:$M$127,$BC$8:$BC$60,\"=\"&$BI$9)","v":3}]
["AZ","Arizona","Reserve Ratio",3399.5269645849976,34.300000000000004,0.26,0.26,1.8595500000000004E-2,1,1.8595500000000004E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},{"$f":"+((L14-M14)*(AH14))+(M14*(AH14*$P$7))","v":30324},10198.580893754992,9728.558893754991,0.33632043575237408,0.27550000000000002,14.815412330940278,7884.2400000000007,8354.2620000000006,null,508.16864295125163,1.2704216073781291E-2,0.24913693789614594,2540.843214756258,7657.7376789987338,null,"AZ","ARIZONA","Reserve Ratio",7000,0.04,11.8,-13,13,3,1.55,null,24,24,9.5000000000000001E-2,6.3241106719367579,26,470.02199999999999,null,{"$f":"+((AH14*(AJ14/100))-(AH14*(AI14/100))) /(AQ14)","v":34.300000000000004},1.8595500000000004E-2,0.26,6.3241106719367585E-2,826,null,7,"CT","CONNECTICUT",7,2016,"Layoffs in ER yrs for Max rate",{"$f":"SUMIFS($N$75:$N$127,$BC$8:$BC$60,\"=\"&$BI$9)","v":1}]
["CA","California","Reserve Ratio",5481.9208274055509,8.6578947368421044,0.4,0.4,4.588684210526316E-3,1,4.588684210526316E-3,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},{"$f":"+((L15-M15)*(AH15))+(M15*(AH15*$P$7))","v":30324},16445.762482216654,15181.251682216654,0.54233486618574911,0.44170000000000004,96.258530710558006,12129.6,13394.1108,null,833.39622641509425,2.0834905660377358E-2,0.25337719285325722,4166.9811320754716,12278.781350141184,null,"CA","CALIFORNIA","Reserve Ratio",7000,1.5,6.2,-20,20,3,4.17,null,38,38,0.01,10.242587601078167,40,1264.5108,null,8.6578947368421044,4.588684210526316E-3,0.4,0.10242587601078167,434,null,8,"DC","DISTRICT OF COLUMBIA",8,2017,"Total Tax: % of Total Wages",{"$f":"SUMIFS($Z$11:$Z$63,$BC$8:$BC$60,\"=\"&$BI$9)","v":2.0834905660377358E-2}]
["CO","Colorado","Reserve Ratio",5791.4913943204056,37.939615384615387,0.45,0.45,1.0860576923076924E-2,1,1.0860576923076924E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},{"$f":"+((L16-M16)*(AH16))+(M16*(AH16*$P$7))","v":56749.2},17374.474182961218,16506.211422961216,0.30616245132902697,0.46530000000000005,28.190256696076851,25537.14,26405.402760000001,null,1069.5274966427341,2.6738187416068353E-2,0.30778701138811942,5347.6374832136707,12026.836699747546,null,"CO","COLORADO","Reserve Ratio",13100,0.62,8.15,-25,20,3,1.53,null,26,26,0.05,6.9333333333333336,45,868.26276000000007,null,37.939615384615387,1.0860576923076924E-2,0.45,6.933333333333333E-2,1067.6500000000001,null,9,"DE","DELAWARE",9,2018,"Minimum Tax Rate",{"$f":"SUMIFS($AI$11:$AI$63,$BC$8:$BC$60,\"=\"&$BI$9)","v":1.5}]
["CT","Connecticut","Benefit Ratio",5575.8893657606104,136.11111111111111,0.16200000000000003,5.4000000000000006E-2,9.0740740740740747E-3,3,2.7222222222222224E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},64980,16727.668097281832,16727.668097281832,0.25742794855773826,0.16200000000000003,5.9510204081632665,10526.760000000002,10526.760000000002,null,810.00000000000023,2.0250000000000004E-2,0.24211384255394849,4050.0000000000009,12677.668097281832,null,"CT","CONNECTICUT","Benefit Ratio",15000,0.5,5.4,0,5.4,3,3.49,null,5.4,5.4," ",5.4,5.4,2267.8020000000001,null,136.11111111111111,9.0740740740740747E-3,0.16200000000000003,0.16200000000000003,810.00000000000011,null,10,"FL","FLORIDA",10,2019,"Maximum Tax Rate",{"$f":"SUMIFS($AJ$11:$AJ$63,$BC$8:$BC$60,\"=\"&$BI$9)","v":6.2}]
["DC","District of Columbia","Reserve Ratio",5839.1659681475276,28.588235294117652,0.18,0.18,1.2070588235294121E-2,1,1.2070588235294121E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},38988,17517.497904442582,16558.393104442581,0.44930486058383556,0.2046,16.950292397660814,7017.84,7976.9448000000002,null,484.57894736842098,1.2114473684210526E-2,0.13831283155042587,2422.894736842105,15094.603167600477,null,"DC","DISTRICT OF COLUMBIA","Reserve Ratio",9000,1.6,7.0000000000000009,-10,8,3,2.46,null,17,17,0.1,4.473684210526315,18,959.10480000000007,null,28.588235294117652,1.2070588235294121E-2,0.18,4.4736842105263151E-2,630.00000000000011,null,11,"GA","GEORGIA",11,2020,"Years in ER Formula:",{"$f":"SUMIFS($AM$11:$AM$63,$BC$8:$BC$60,\"=\"&$BI$9)","v":3}]
["DE","Delaware","Benefit Wage",4273.1542233579667,162.9375,0.24599999999999997,8.199999999999999E-2,9.8750000000000001E-3,3,2.9624999999999999E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},71478,12819.462670073899,12819.462670073899,0.17934836831016396,0.24599999999999994,6.0539533606806399,17583.587999999996,17583.587999999996,null,986.4160257059018,2.4660400642647545E-2,0.38473376423514932,4932.0801285295092,7887.3825415443898,null,"DE","DELAWARE","Benefit Ratio",16500,0.1,8,0,8.1999999999999993,3,1.49,null,8,8," ",8,8.1999999999999993,1065.0222000000001,null,162.9375,9.8750000000000001E-3,0.24599999999999997,0.24599999999999997,1320,null,12,"HI","HAWAII",12,2021]
["FL","Florida","Benefit Ratio",2270.6409471586544,68.703703703703709,0.16200000000000003,5.4000000000000006E-2,9.8148148148148144E-3,3,2.9444444444444443E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},30324,6811.9228414759637,6811.9228414759637,0.22463800426975214,0.16200000000000003,5.5018867924528312,4912.4880000000012,4912.4880000000012,null,378.00000000000011,9.4500000000000018E-3,0.27745469876615447,1890.0000000000005,4921.9228414759637,null,"FL","FLORIDA","Benefit Ratio",7000,0.1,5.4,0,5.4,3,0.54,null,5.4,5.4," ",5.4,5.4,163.74960000000002,null,68.703703703703709,9.8148148148148144E-3,0.16200000000000003,0.16200000000000003,378.00000000000006,null,13,"IA","IOWA",13,2022]
["GA","Georgia","Reserve Ratio",2182.8046806828606,31.375255623721884,0.2445,0.2445,1.2365153374233129E-2,1,1.2365153374233129E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},41154,6548.4140420485819,5988.7196420485816,0.15911974636848378,0.2581,12.868400540834552,10062.153,10621.847400000001,null,403.74935643712502,1.0093733910928125E-2,0.30828025980380552,2018.7467821856251,4529.6672598629566,null,"GA","GEORGIA","Reserve Ratio",9500,2.5000000000000001E-2,8.1,-15.5,8.9499999999999993,3,1.36,null,45,24.45,4.3999999999999997E-2,6.5304487179487172,24.45,559.69440000000009,null,31.375255623721884,1.2365153374233129E-2,0.2445,6.530448717948717E-2,769.5,null,14,"ID","IDAHO",14,2023]
["HI","Hawaii","Reserve Ratio",6905.2365509347574,154.16470588235296,0.17,0.17,1.2432000000000002E-2,1,1.2432000000000002E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},202737.6,20715.709652804271,18465.322292804271,0.10217990966058724,0.18110000000000004,8.2191047024281865,34465.392000000007,36715.779360000008,null,1267.0958590661055,3.1677396476652638E-2,0.30582970129980069,6335.4792953305277,14380.230357473743,null,"HI","HAWAII","Reserve Ratio",46800,0,5.6000000000000005,-2,15,3,1.1100000000000001,null,20,17,7.3999999999999996E-2,4.5045045045045047,17,2250.3873600000002,null,154.16470588235296,1.2432000000000002E-2,0.17,4.504504504504505E-2,2620.8000000000002,null,15,"IL","ILLINOIS",15,2024]
["IA","Iowa","Benefit Ratio",4893.9970836033699,106.78571428571429,1.05,0.21,3.5714285714285713E-3,5,1.7857142857142856E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},129526.8,14681.99125081011,14681.99125081011,0.11335099184732511,1.05,6.3476555434502062,136003.14000000001,136003.14000000001,null,677.83893124700421,1.6945973281175107E-2,0.23084025854108961,3389.1946562350213,11292.796594575088,null,"IA","IOWA","Benefit Ratio",29900,0,7.5,0,21,5,1.25,null,21,21," ",21,21,1619.085,null,106.78571428571429,3.5714285714285713E-3,1.05,1.05,2242.5,null,16,"IN","INDIANA",16,2025]
["ID","Idaho","Reserve Ratio",2829.0297484533025,181.0526315789474,0.114,0.114,1.6747368421052632E-2,1,1.6747368421052632E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},173280,8487.0892453599081,6892.9132453599086,4.8979046891504549E-2,0.1232,2.9245816811394922,19753.920000000002,21348.096000000001,null,529.50320963788715,1.3237580240947179E-2,0.31194629532579682,2647.5160481894359,5839.5731971704718,null,"ID","IDAHO","Reserve Ratio",40000,0.24,5.4,-5.4,6,4,0.92,null,14,11.4,0,3.0810810810810811,11.4,1594.1759999999999,null,181.0526315789474,1.6747368421052632E-2,0.114,3.0810810810810812E-2,2160.0000000000005,null,17,"KS","KANSAS"]
["IL","Illinois","Benefit Ratio",5649.4934465328988,98.665714285714287,0.252,8.4000000000000005E-2,7.6130952380952382E-3,3,2.2839285714285715E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},56142.720000000001,16948.480339598696,16948.480339598696,0.30188206662589018,0.252,11.033620015637217,14147.96544,14147.96544,null,1088.6400000000001,2.7216000000000004E-2,0.32116153725490199,5443.2000000000007,11505.280339598696,null,"IL","ILLINOIS","Benefit Ratio",12960,0.47499999999999998,6.87,0,8.4,3,2.2400000000000002,null,8.4,8.4,{"$f":"+$AS$8","v":3.7},8.4,8.4,1257.5969280000002,null,98.665714285714287,7.6130952380952382E-3,0.252,0.252,890.35199999999998,null,18,"KY","KENTUCKY"]
["IN","Indiana","Reserve Ratio",3496.9743035051306,72.833333333333329,0.09,0.09,2.8366666666666662E-2,1,2.8366666666666662E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},41154,10490.922910515392,9828.3435105153912,0.25491866915768557,0.10609999999999999,3.7403055229142188,3703.8599999999997,4366.4393999999993,null,272.41891891891891,6.8104729729729727E-3,0.12983553555896624,1362.0945945945946,9128.8283159207967,null,"IN","INDIANA","Reserve Ratio",9500,0.5,7.3999999999999995,-6,3,3,1.61,null,21,9,0,2.4324324324324325,9,662.57939999999996,null,72.833333333333329,2.8366666666666662E-2,0.09,2.4324324324324326E-2,703,null,19,"LA","LOUISIANA"]
["KS","Kansas","Reserve Ratio",2937.2267145852052,19.88,0.5,0.5,5.4101999999999996E-3,1,5.4101999999999996E-3,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},60648,8811.6801437556151,7883.7657437556154,0.14529218018328083,0.51529999999999998,26.855232742464388,30324,31251.914400000001,null,533.88202692019195,1.3347050673004799E-2,0.30293997183870019,2669.4101346009597,6142.2700091546558,null,"KS","KANSAS","Reserve Ratio",14000,0,7.1,-18,32,3,1.53,null,50,50,0.11,13.123359580052494,50,927.91440000000011,null,19.88,5.4101999999999996E-3,0.5,0.13123359580052493,993.99999999999989,null,20,"MA","MASSACHUSETTS"]
["KY","Kentucky","Reserve Ratio",5912.5013482903678,57.09375,0.16,0.16,2.0265562500000001E-2,1,2.0265562500000001E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},45486,17737.504044871104,16946.047644871105,0.3899552399611112,0.1774,8.7537663955787064,7277.76,8069.2164000000002,null,499.78535014757176,1.2494633753689295E-2,0.14088378750562919,2498.926750737859,15238.577294133245,null,"KY","KENTUCKY","Reserve Ratio",10500,0.3,9,-8,8,3,1.74,null,22,16,2.7E-2,4.292997048564529,16,791.45639999999992,null,57.09375,2.0265562500000001E-2,0.16,4.2929970485645293E-2,945,null,21,"MD","MARYLAND"]
["LA","Louisiana","Reserve Ratio",4133.5106907084446,12.446575342465755,0.36499999999999999,0.36499999999999999,5.9678904109589041E-3,1,5.9678904109589041E-3,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},33356.400000000001,12400.532072125334,11913.528632125333,0.37175870513980325,0.37959999999999999,62.293152109016376,12175.085999999999,12662.08944,null,775.33641104455182,1.9383410276113795E-2,0.31262223529399996,3876.6820552227591,8523.8500169025756,null,"LA","LOUISIANA","Reserve Ratio",7700,0.1,6,-27,9.5,3,1.46,null,62,36.5,-8.0000000000000002E-3,9.8862405200433372,36.5,487.00344000000001,null,12.446575342465755,5.9678904109589041E-3,0.36499999999999999,9.8862405200433379E-2,462,null,22,"ME","MAINE"]
["MA","Massachusetts","Reserve Ratio",7856.4492231894756,64.983870967741936,0.31,0.31,1.6202645161290323E-2,1,1.6202645161290323E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},64980,23569.347669568426,21048.123669568427,0.36271695397920017,0.34879999999999994,21.527349178350008,20143.8,22665.023999999998,null,1398.9304812834223,3.4973262032085561E-2,0.29676902833625135,6994.6524064171117,16574.695263151312,null,"MA","MASSACHUSETTS","Reserve Ratio",15000,0.94,14.37,-15,16,2,3.88,null,40,31,0.04,8.2887700534759361,31,2521.2240000000002,null,64.983870967741936,1.6202645161290323E-2,0.31,8.2887700534759357E-2,2155.5,null,23,"MI","MICHIGAN"]
["MD","Maryland","Benefit Ratio",5737.5721124340243,93.00911854103343,0.19739999999999999,6.5799999999999997E-2,1.0942249240121582E-2,3,3.2826747720364743E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},36822,17212.716337302074,17212.716337302074,0.46745739876438203,0.19739999999999999,6.0133888888888887,7268.6628000000001,7268.6628000000001,null,559.29999999999995,1.39825E-2,0.16246709381596211,2796.5,14416.216337302074,null,"MD","MARYLAND","Benefit Ratio",8500,0.3,7.5,0,6.58,3,2.0561349435833272,null,9.4600000000000009,6.58," ",6.58,6.58,757.1100089262527,null,93.00911854103343,1.0942249240121582E-2,0.19739999999999999,0.19739999999999999,637.5,null,24,"MN","MINNESOTA"]
["ME","Maine","Reserve Ratio",4244.2312547336533,32.400000000000006,0.2,0.2,1.0341000000000001E-2,1,1.0341000000000001E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},51984,12732.69376420096,11770.98976420096,0.24493486003772239,0.21850000000000003,21.129484575959772,10396.800000000001,11358.504000000001,null,684.59530026109678,1.7114882506527419E-2,0.26883364704250334,3422.9765013054839,9309.7172628954759,null,"ME","MAINE","Reserve Ratio",12000,0,5.4,0,20,3,1.85,null,20,20,0.13,5.2219321148825069,20,961.70400000000018,null,32.400000000000006,1.0341000000000001E-2,0.2,5.2219321148825069E-2,648.00000000000011,null,25,"MO","MISSOURI"]
["MI","Michigan","Benefit Ratio",3662.1887856125531,55.048543689320383,0.10300000000000001,0.10300000000000001,6.1165048543689315E-3,3,1.8349514563106795E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},38988,10986.566356837659,9781.8371568376588,0.28179353536569351,0.13389999999999999,7.2971957671957677,4015.7640000000001,5220.4931999999999,null,401.7,1.0042499999999999E-2,0.18281416911936085,2008.5,8978.0663568376585,null,"MI","MICHIGAN","Reserve Ratio",9000,0,6.3,0,10.3,5,3.09,null,10.3,10.3," ",10.3,10.3,1204.7292,null,55.048543689320383,6.1165048543689315E-3,0.10300000000000001,0.10300000000000001,567,null,26,"MS","MISSISSIPPI"]
["MN","Minnesota","Benefit Ratio",6580.3517739025856,338.10055865921788,0.35799999999999998,8.9499999999999996E-2,9.9441340782122929E-3,4,3.9776536312849171E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},147288,19741.055321707758,19741.055321707758,0.13403030336285207,0.35799999999999998,3.3695820648806905,52729.103999999999,52729.103999999999,null,1139.2575785842423,2.8481439464606056E-2,0.28855032317636181,5696.2878929212111,14044.767428786547,null,"MN","MINNESOTA","Benefit Ratio",34000,0.1,9,0,8.9499999999999993,4,1.1399999999999999,null,8.9499999999999993,8.9499999999999993," ",8.9499999999999993,8.9499999999999993,1679.0831999999998,null,338.10055865921788,9.9441340782122929E-3,0.35799999999999998,0.35799999999999998,3060,null,27,"MT","MONTANA"]
["MO","Missouri","Reserve Ratio",3065.1375709312861,30.999999999999996,0.27,0.27,9.80375E-3,1,9.80375E-3,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},51984,9195.4127127938591,8633.985512793859,0.17688928733444634,0.28079999999999999,18.043023061017095,14035.68,14597.1072,null,559.33371489152989,1.3983342872288246E-2,0.30413736303173849,2796.6685744576494,6398.7441383362093,null,"MO","MISSOURI","Reserve Ratio",12000,0,6.9749999999999996,-12,15,3,1.08,null,38,27,9.5000000000000001E-2,7.1146245059288526,27,561.42720000000008,null,30.999999999999996,9.80375E-3,0.27,7.1146245059288529E-2,836.99999999999989,null,28,"NC","NORTH CAROLINA"]
["MS","Mississippi","Benefit Ratio",2500.442310122583,140,0.16200000000000003,5.4000000000000006E-2,0.01,3,0.03,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},60648,7501.3269303677489,7501.3269303677489,0.12368630342909492,0.16200000000000003,4.1228767809698308,9824.9760000000024,9824.9760000000024,null,577.20274933577628,1.4430068733394407E-2,0.38473376423514927,2886.0137466788815,4615.3131836888679,null,"MS","MISSISSIPPI","Benefit Ratio",14000,0,5.4,0,5.4,3,0.46,null,5.4,5.4," ",5.4,5.4,278.98079999999999,null,140,0.01,0.16200000000000003,0.16200000000000003,756.00000000000011,null,29,"ND","NORTH DAKOTA"]
["MT","Montana","Reserve Ratio",4585.7921900866686,100.98,0.2,0.2,1.1523960000000001E-2,1,1.1523960000000001E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},142956,13757.376570260007,12127.678170260007,9.6235041343210551E-2,0.2114,8.350865617653179,28591.200000000001,30220.898400000002,null,843.27041007061803,2.108176025176545E-2,0.30647936609279014,4216.3520503530899,9541.0245199069177,null,"MT","MONTANA","Reserve Ratio",33000,0,6.12,-10,10,3,1.1399999999999999,null,20,20,6.6000000000000003E-2,5.3106744556558683,20,1629.6983999999998,null,100.98,1.1523960000000001E-2,0.2,5.3106744556558685E-2,2019.6000000000001,null,30,"NE","NEBRASKA"]
["NC","North Carolina","Reserve Ratio",2144.8379663545425,168.91463414634148,8.199999999999999E-2,8.199999999999999E-2,2.5719512195121957E-2,1,2.5719512195121957E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},105267.6,6434.5138990636278,5897.6491390636274,6.1125302553336709E-2,8.7099999999999997E-2,2.3766120480671451,8631.9431999999997,9168.8079600000001,null,401.44455460704916,1.0036113865176229E-2,0.31194629532579665,2007.2227730352458,4427.2911260283818,null,"NC","NORTH CAROLINA","Reserve Ratio",24300,0.06,5.76,-4.2,4,3,0.51,null,36,8.1999999999999993,0,2.2162162162162158,8.1999999999999993,536.86476000000005,null,168.91463414634148,2.5719512195121957E-2,8.199999999999999E-2,2.2162162162162158E-2,1399.68,null,31,"NH","NEW HAMPSHIRE"]
["ND","North Dakota","Reserve Ratio",6044.526656536962,177.38071065989845,0.19700000000000004,0.19700000000000004,1.8127918781725889E-2,1,1.8127918781725889E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},157684.79999999999,18133.579969610888,16067.909089610888,0.11499890902364013,0.21010000000000004,6.3437458214765634,31063.905600000002,33129.576480000003,null,1125.2581420592742,2.8131453551481854E-2,0.31026916470576549,5626.2907102963709,12507.289259314517,null,"ND","NORTH DAKOTA","Reserve Ratio",36400,0.15,9.75,-17.350000000000001,2.35,3,1.31,null,20,19.700000000000003,0.02,5.295698924731183,19.700000000000003,2065.6708800000001,null,177.38071065989845,1.8127918781725889E-2,0.19700000000000004,5.2956989247311827E-2,3549,null,32,"NJ","NEW JERSEY"]
["NE","Nebraska","Reserve Ratio",3896.8827713839569,24.300000000000004,0.2,0.2,1.0287000000000001E-2,1,1.0287000000000001E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},38988,11690.648314151871,11363.149114151871,0.29985247548353011,0.2084,20.258578788762513,7797.6,8125.0992000000006,null,492.28346456692913,1.230708661417323E-2,0.21054583601279223,2461.4173228346458,9229.2309913172248,null,"NE","NEBRASKA","Reserve Ratio",9000,0,5.4,0,20,4,0.84,null,20,20,0.11,5.2493438320209975,20,327.49919999999997,null,24.300000000000004,1.0287000000000001E-2,0.2,5.2493438320209973E-2,486.00000000000006,null,33,"NM","NEW MEXICO"]
["NH","New Hampshire","Reserve Ratio",4093.3950357593603,30.925373134328357,0.33500000000000002,0.33500000000000002,8.2946268656716431E-3,1,8.2946268656716431E-3,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},60648,12280.185107278081,11737.856298511422,0.20248293607832213,0.34394223731642692,24.411337526986685,20317.080000000002,20859.408808766661,null,754.92972173009571,1.8873243043252393E-2,0.30737717515457991,3774.6486086504783,8505.5364986276036,null,"NH","NEW HAMPSHIRE","Reserve Ratio",14000,0.1,7.5,-7.5,26,3,0.89422373164269175,null,49,33.5,5.5E-2,8.9214380825565911,33.5,542.32880876665968,null,30.925373134328357,8.2946268656716431E-3,0.33500000000000002,8.9214380825565917E-2,1050,null,34,"NV","NEVADA"]
["NJ","New Jersey","Reserve Ratio",6963.9494504707691,61.428571428571438,0.52,0.52,6.6910714285714299E-3,1,6.6910714285714299E-3,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},149020.79999999999,20891.848351412307,18582.025951412306,0.14019417659422248,0.53549999999999998,20.952425645253424,77490.815999999992,79800.638399999996," ",1287.0775753512819,3.2176939383782049E-2,0.30803343813863032,6435.3878767564092,14456.460474655898,null,"NJ","NEW JERSEY","Reserve Ratio",34400,0.4,5.4,-35,17,4,1.55,null,28,28,4.7E-2,7.4726447824926598,52,2309.8224,null,61.428571428571438,6.6910714285714299E-3,0.52,7.4726447824926601E-2,1857.6000000000001,null,35,"NY","NEW YORK"]
["NM","New Mexico","Benefit Ratio",4952.2087653568005,196.46250000000001,0.192,6.4000000000000001E-2,7.9218750000000001E-3,3,2.3765624999999999E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},107433.60000000001,{"$f":"+D43*O43","v":14856.626296070401},{"$f":"IF(AG43=\"Reserve Ratio\",Q43-AU43,Q43)","v":14856.626296070401},{"$f":"+Q43/P43","v":0.13828659093682424},0.192,5.8187651676244263,{"$f":"+(F43)*(P43)","v":20627.251200000002},20627.251200000002," ",{"$f":"+U43*E43","v":1143.169151744414},{"$f":"+AB43/(N43*1000)","v":2.8579228793610349E-2},0.38473376423514938,5715.8457587220701,{"$f":"+Q43-AB43","v":9140.7805373483316},null,"NM","NEW MEXICO","Benefit Ratio",24800,0.33,5.4,0,6.4,3,1.05,null,30,{"$f":"IF(AT43>AP43,AP43,AT43)","v":6.4}," ",{"$f":"IF(C43=\"Reserve Ratio\",AQ43/($AS$8+AR43),AQ43)","v":6.4},{"$f":"+AL43-AK43","v":6.4},{"$f":"+((AN43/100)*P43)","v":1128.0528000000002},null,196.46250000000001,{"$f":"+((AJ43-AI43)/100)/AS43","v":7.9218750000000001E-3},0.192,0.192,1339.2,null,36,"OH","OHIO"]
["NV","Nevada","Reserve Ratio",4912.419251792433,89.26666666666668,0.22399999999999998,0.22399999999999998,1.0714861111111113E-2,1,1.0714861111111113E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},135158.39999999999,14737.257755377299,12236.8273553773,0.10903693559096067,0.24249999999999999,{"$f":"IF(S44>T44,T44/(J44),S44/J44)","v":10.176234153692519},30275.481599999996,{"$f":"IF(AG44=\"Reserve Ratio\",V44+AU44,V44)","v":32775.911999999997}," ",908.39850211961902,2.2709962552990473E-2,0.30819794197742262,4541.9925105980947,10195.265244779204,null,"NV","NEVADA","Reserve Ratio",31200,0.25,5.4,-17.2,5.2,3,1.85,null,18,18,4.4999999999999998E-2,4.8064085447263016,22.4,2500.4304000000002,null,89.26666666666668,1.0714861111111113E-2,{"$f":"IF(AG44=\"Benefit Ratio\",(AL44/100)*AM44,(AT44/100))","v":0.22399999999999998},4.8064085447263018E-2,1684.8000000000002,null,37,"OK","OKLAHOMA"]
["NY","New York","Reserve Ratio",5035.2812353232712,24.872727272727275,0.33,0.33,8.2320000000000015E-3,1,8.2320000000000015E-3,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},49384.800000000003,15105.843705969814,14044.070505969814,0.30588042689187389,0.35150000000000003,37.157486259945799,16296.984000000002,17358.757200000004,null,924.20802188374284,2.3105200547093571E-2,0.30591075873454748,4621.0401094187146,10484.803596551099,null,"NY","NEW YORK","Reserve Ratio",11400,0,7.2,-21,12,5,2.15,null,66,33,7.2999999999999995E-2,8.7463556851311957,33,1061.7732000000001,null,24.872727272727275,8.2320000000000015E-3,0.33,8.7463556851311963E-2,820.80000000000007,null,38,"OR","OREGON"]
["OH","Ohio","Reserve Ratio",5057.7414150140385,24.867647058823529,0.34,0.34,9.8187941176470575E-3,1,9.8187941176470575E-3,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},41154,15173.224245042114,14226.682245042115,0.36869379027657373,0.36299999999999999,36.969916636462493,13992.36,14938.902,null,919.35483870967755,2.2983870967741942E-2,0.30295302562673154,4596.7741935483882,10576.450051493726,null,"OH","OHIO","Reserve Ratio",9500,0.3,9.1999999999999993,-20,14,3,2.2999999999999998,null,40,34,5.0999999999999997E-2,9.064249533457744,34,946.54200000000003,null,24.867647058823529,9.8187941176470575E-3,0.34,9.0642495334577439E-2,874,null,39,"PA","PENNSYLVANIA"]
["OK","Oklahoma","Benefit Wage",5549.6587030716728,177.70909090909092,0.30000000000000004,0.1,9.8181818181818196E-3,3,2.9454545454545459E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},78409.2,16648.976109215018,16648.976109215018,0.21233447234782421,0.30000000000000004,7.2088864068705742,23522.760000000002,23522.760000000002,null,1281.0846498318726,3.2027116245796815E-2,0.38473376423514921,6405.423249159363,10243.552860055655,null,"OK","OKLAHOMA","Benefit Ratio",18100,0.1,5.5,0,10,3,1.04,null,5.5,5.5," ",5.5,10,815.45567999999992,null,177.70909090909092,9.8181818181818196E-3,0.30000000000000004,0.30000000000000004,995.5,null,40,"PR","PUERTO RICO"]
["OR","Oregon","Benefit Ratio",5886.4357315061543,81.2,0.67500000000000004,0.22500000000000001,2E-3,3,6.0000000000000001E-3,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},175879.2,17659.307194518464,17659.307194518464,0.10040588764628486,0.67500000000000004,16.734314607714143,118718.46000000002,118718.46000000002,null,1358.8263461463885,3.397065865365971E-2,0.38473376423514927,6794.1317307319423,10865.175463786522,null,"OR","OREGON","Benefit Ratio",40600,0.9,5.4,0,22.5,3,1.91,null,30,22.5," ",22.5,22.5,3359.2927199999999,null,81.2,2E-3,0.67500000000000004,0.67500000000000004,2192.4,null,41,"RI","RHODE ISLAND"]
["PA","Pennsylvania","Benefit Ratio",5197.1482733042112,80.025925925925918,0.32400000000000007,0.10800000000000001,8.0025925925925924E-3,3,2.4007777777777777E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},43320,15591.444819912635,15591.444819912635,0.35991331532577642,0.32400000000000007,13.495626417364745,14035.680000000002,14035.680000000002,null,1080,2.7E-2,0.34634378419525191,5400,10191.444819912635,null,"PA","PENNSYLVANIA","Benefit Ratio",10000,2.3904999999999998,11.033300000000001,0,10.8,3,5.15,null,10.8,10.8," ",10.8,10.8,2230.98,null,80.025925925925918,8.0025925925925924E-3,0.32400000000000007,0.32400000000000007,1103.33,null,42,"SC","SOUTH CAROLINA"]
["PR","Puerto Rico","Reserve Ratio",2225.1736651114566,14.000000000000004,0.2,0.2,7.4000000000000003E-3,1,7.4000000000000003E-3,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},30324,6675.5209953343692,5820.384195334369,0.22013985606563677,0.22820000000000001,29.748629198059021,6064.8,6919.9368000000004,null,416.48080877282638,1.041202021932066E-2,0.31194629532579676,2082.4040438641318,4593.1169514702378,null,"PR","PUERTO RICO","Reserve Ratio",7000,1.4,5.4,-10,10,3,2.82,null,22,20,0,5.4054054054054053,20,855.13679999999999,null,14.000000000000004,7.4000000000000003E-3,0.2,5.405405405405405E-2,378.00000000000006,null,43,"SD","SOUTH DAKOTA"]
["RI","Rhode Island","Reserve Ratio",5130.6331800495227,81.183999999999997,0.41,0.41,1.2968799999999999E-2,1,1.2968799999999999E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},102235.2,15391.899540148568,12866.690100148568,0.15055381649518532,0.43469999999999992,11.60892422546306,41916.431999999993,44441.641439999992,null,942.45890431999305,2.3561472607999828E-2,0.30615418904653796,4712.2945215999653,10679.605018548602,null,"RI","RHODE ISLAND","Reserve Ratio",23600,1.1000000000000001,9.6999999999999993,-24,17,3,2.4700000000000002,null,25,25,7.0000000000000007E-2,6.6312997347480103,41,2525.2094400000001,null,81.183999999999997,1.2968799999999999E-2,0.41,6.6312997347480099E-2,2289.1999999999998,null,44,"TN","TENNESSEE"]
["SC","South Carolina","Benefit Ratio",3204.7833806093504,50.400000000000006,0.60000000000000009,0.2,3.6000000000000003E-3,3,1.0800000000000001E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},60648,9614.3501418280503,9614.3501418280503,0.15852707660315346,0.60000000000000009,14.678433018810505,36388.800000000003,36388.800000000003,null,739.79302414804954,1.8494825603701238E-2,0.38473376423514932,3698.9651207402476,5915.3850210878027,null,"SC","SOUTH CAROLINA","Benefit Ratio",14000,0,5.4,0,20,3,1.35,null,15,15," ",15,20,818.74800000000005,null,50.400000000000006,3.6000000000000003E-3,0.60000000000000009,0.60000000000000009,756.00000000000011,null,45,"TX","TEXAS"]
["SD","South Dakota","Reserve Ratio",4931.0411435194128,163.08139534883722,8.5999999999999993E-2,8.5999999999999993E-2,4.0259360465116287E-2,1,4.0259360465116287E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},64980,14793.123430558238,14442.231430558239,0.22765656248935423,9.1399999999999995E-2,2.2702794814437199,5588.28,5939.1719999999996,null,370.24034566567644,9.2560086416419111E-3,0.1251393417366034,1851.2017283283822,12941.921702229856,null,"SD","SOUTH DAKOTA","Reserve Ratio",15000,0,9.35,-7,1.6,3,0.54,null,26,8.6,3.0000000000000001E-3,2.3224412638401293,8.6,350.892,null,163.08139534883722,4.0259360465116287E-2,8.5999999999999993E-2,2.3224412638401293E-2,1402.5,null,46,"UT","UTAH"]
["TN","Tennessee","Reserve Ratio",3482.8911414720142,29.137499999999999,0.24,0.24,1.5775875000000002E-2,1,1.5775875000000002E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},{"$f":"+((L54-M54)*(AH54))+(M54*(AH54*$P$7))","v":30324},10448.673424416043,10112.443300232202,0.34456778210051586,0.25108792125655721,15.915942618495468,7277.7599999999993,7613.9901241838406,null,463.75077804641165,1.1593769451160292E-2,0.22191849587467122,2318.7538902320584,8129.919534183985,null,"TN","TENNESSEE","Reserve Ratio",7000,0.01,10,-10,14,3,1.1087921256557238,null,24,24,0.09,6.3324538258575194,24,336.23012418384167,null,29.137499999999999,1.5775875000000002E-2,0.24,6.3324538258575189E-2,700,null,47,"VA","VIRGINIA"]
["TX","Texas","Benefit Ratio",5366.1412578657018,65.454545454545453,0.2475,8.2500000000000004E-2,7.2727272727272727E-3,3,2.181818181818182E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},38988,16098.423773597106,16098.423773597106,0.41290714511124205,0.24750000000000003,11.34375,9649.5300000000007,9649.5300000000007,null,742.5,1.8562499999999999E-2,0.23061263961064568,3712.5,12385.923773597106,null,"TX","TEXAS","Benefit Ratio",9000,0,6,0,8.25,3,1.93,null,8.25,8.25," ",8.25,8.25,752.46839999999986,null,65.454545454545453,7.2727272727272727E-3,0.2475,0.2475,540,null,48,"VI","VIRGIN ISLANDS"]
["UT","Utah","Benefit Ratio",4492.4476313780169,308.87500000000006,0.32,0.08,8.7500000000000008E-3,4,3.5000000000000003E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},152919.6,13477.34289413405,13477.34289413405,8.8133521760023231E-2,0.32,2.5181006217149493,48934.272000000004,48934.272000000004,null,777.77832953220513,1.9444458238305127E-2,0.28855032317636198,3888.8916476610257,9588.4512464730251,null,"UT","UTAH","Benefit Ratio",35300,0,7,0,8,4,0.41,null,8,8," ",8,8,626.97035999999991,null,308.87500000000006,8.7500000000000008E-3,0.32,0.32,2471.0000000000005,null,49,"VT","VERMONT"]
["VA","Virginia","Benefit Ratio",4379.1009664292978,323.3,0.2,0.05,1.2200000000000001E-2,4,4.8800000000000003E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},114798,13137.302899287894,13137.302899287894,0.11443843010581974,0.2,2.3450497972504043,22959.600000000002,22959.600000000002,null,758.15459945105579,1.8953864986276395E-2,0.28855032317636198,3790.7729972552788,9346.5299020326147,null,"VA","VIRGINIA","Benefit Ratio",26500,0.1,6.2,0,5,4,1.1299999999999999,null,5,5," ",5,5,1297.2174,null,323.3,1.2200000000000001E-2,0.2,0.2,1643,null,50,"WA","WASHINGTON"]
["VI","Virgin Islands","Reserve Ratio",7583.8011226944664,8.8888888888886991E-2,0.09,0.09,4.1111111111110235E-5,1,4.1111111111110235E-5,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},34656,22751.4033680834,21954.3153680834,0.65649247945762346,0.11299999999999999,2748.648648648707,3119.04,3916.1279999999997,null,244.32432432432429,6.1081081081081076E-3,5.3694341481166051E-2,1221.6216216216214,21529.78174646178,null,"VI","VIRGIN ISLANDS","Reserve Ratio",8000,2.4900000000000002,2.5,0,9,3,2.2999999999999998,null,9,9,0,2.4324324324324325,9,797.08799999999997,null,8.8888888888886991E-2,4.1111111111110235E-5,0.09,2.4324324324324326E-2,200,null,51,"WI","WISCONSIN"]
["VT","Vermont","Benefit Ratio",4012.3877792469902,139.79220779220779,0.23099999999999998,7.6999999999999999E-2,8.9610389610389612E-3,3,2.6883116883116884E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},67579.199999999997,12037.163337740971,12037.163337740971,0.17811935237086221,0.23099999999999998,6.6256957162108163,15610.795199999999,15610.795199999999,null,926.22063232848348,2.3155515808212086E-2,0.38473376423514927,4631.103161642417,7406.0601760985537,null,"VT","VERMONT","Benefit Ratio",15600,0.8,7.7,0,7.7,3,3.3,null,21,7.7," ",7.7,7.7,2230.1136000000001,null,139.79220779220779,8.9610389610389612E-3,0.23099999999999998,0.23099999999999998,1201.2,null,52,"WV","WEST VIRGINIA"]
["WA","Washington","Benefit Ratio",6670.4258582045532,471.78947368421058,0.22800000000000001,5.7000000000000002E-2,9.4736842105263164E-3,4,3.7894736842105266E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},215733.6,20011.277574613661,20011.277574613661,9.275920660765713E-2,0.22800000000000001,2.447812396590952,49187.260800000004,49187.260800000004,null,1154.8521222653314,2.8871303056633286E-2,0.28855032317636198,5774.2606113266575,14237.016963287004,null,"WA","WASHINGTON","Benefit Ratio",49800,0,5.4,0,5.7,4,1,null,5.7,5.7," ",5.7,5.7,2157.3360000000002,null,471.78947368421058,9.4736842105263164E-3,0.22800000000000001,0.22800000000000001,2689.2000000000003,null,53,"WY","WYOMING"]
["WI","Wisconsin","Reserve Ratio",3468.7646342605599,71.333333333333329,0.21,0.21,1.9173380952380952E-2,1,1.9173380952380952E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},60648,10406.293902781679,9448.055502781679,0.17158511249804906,0.2258,8.949131763677892,12736.08,13694.3184,null,638.37139914235627,1.5959284978558908E-2,0.30672370255260373,3191.8569957117816,7214.4369070698976,null,"WI","WISCONSIN","Reserve Ratio",14000,0,10.7,-6,15,3,1.58,null,23,21,6.3E-2,5.5806537337230928,21,958.23840000000007,null,71.333333333333329,1.9173380952380952E-2,0.21,5.5806537337230927E-2,1498]
["WV","West Virginia","Reserve Ratio",3771.7518182634462,48,0.18,0.18,1.5319999999999999E-2,1,1.5319999999999999E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},51984,11315.255454790338,9896.0922547903392,0.21766804122018965,0.20729999999999996,13.531331592689293,9357.119999999999,10776.283199999998,null,649.50391644908609,1.6237597911227152E-2,0.28700364699858244,3247.5195822454307,8067.7358725449076,null,"WV","WEST VIRGINIA","Reserve Ratio",12000,1.5,7.5,0,18,3,2.73,null,15,15,0.13,3.9164490861618799,18,1419.1632,null,48,1.5319999999999999E-2,0.18,3.91644908616188E-2,900]
["WY","Wyoming","Benefit Ratio",4703.4254143646413,244.23076923076923,0.26519999999999999,8.8399999999999992E-2,9.6153846153846159E-3,3,2.8846153846153848E-2,null,{"$f":"+'Main Menu'!$M$12","v":5},{"$f":"+'Main Menu'!$M$14","v":2},{"$f":"+'Main Menu'!$M$16","v":200},{"$f":"+'Main Menu'!$L$18","v":3},110032.8,14110.276243093924,14110.276243093924,0.12823700063157462,0.26519999999999999,4.4455493552279197,29180.698560000001,29180.698560000001,null,1085.7399386806651,2.7143498467016625E-2,0.38473376423514921,5428.699693403325,8681.5765496905988,null,"WY","WYOMING","Benefit Ratio",25400,0,8.5,0,8.84,3,1.45,null,10,8.84," ",8.84,8.84,1595.4756,null,244.23076923076923,9.6153846153846159E-3,0.26519999999999999,0.26519999999999999,2159]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Calculation of Maximum Layoffs to Reach Maximum Tax Rate"]
[]
[null,null,"Input Data"," "," ",null,null,null,null,null,null,"OUTPUTS",null,null,"Est. Num. of Layoffs"]
[null,null,null,"Average Benefits per ","Max Intervl in Exp. Tax Tabl ","Max Intervl in Exp. Tax Tabl ","Taxable Wages","Tot Bens Needed","Tot Bens needed - ","Tot Bens Needed",null,"Est. of layoffs  to",null,null,"to Reach Max tax Rate","Proportion of "]
[null,null,"Exper. Rating","First Payment","MAXBENRATIO (%)","MAXBENRATIO (%)","Input ","to reach Max interval","with cont. for Res. Rat","to reach Max interval",null,"reach max.","Final Layoffs Include:","Estimate of Layoffs in each  ","next year for employer","Employees Laid off"]
["ABB.","STATE","Method","Tot Ben / First Pays","BR: Max Intrl* Yrs",null,"> Base + < Base","over yrs in Frmla","(Tot Bens  + Avg. Cont.)","over yrs in Frmla","Include. Cont for RR","next year for lowest","Num of Employees","of the years in ER Formula","already at Max.(exactly)","to Reach max:"]
[null,null,null,"From 394 report","RR: Diff in Max Min Exp Rt",null,null,"(Max Intrvl. * Tax Wages)",null,"for Input Employer",null,"rated employer"]
["AK","Alaska","Payroll Decline",4530.512491359731,{"$f":"+AY11","v":"NA"},"NA",{"$f":"+((L11-M11)*(AH11))+(M11*(AH11*0.666))","v":172846.8},{"$f":"+E75*G75","v":{"$error":"#VALUE!"}},{"$f":"IF(C75=\"Reserve Ratio\",H75-AU11,H75)","v":{"$error":"#VALUE!"}},{"$f":"+F75*G75","v":{"$error":"#VALUE!"}},{"$f":"IF(C75=\"Reserve Ratio\",AU11,J75)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(I75/D75,0)","v":{"$error":"#VALUE!"}},"NA",{"$f":"+M75/AM11","v":{"$error":"#VALUE!"}},{"$f":"+K75/D75","v":{"$error":"#VALUE!"}},{"$f":"+M75/L11","v":{"$error":"#VALUE!"}}]
["AL","Alabama","Benefit Ratio",2876.0403754205772,{"$f":"+AY12","v":0.21600000000000003},{"$f":"+AT12/100","v":7.2000000000000008E-2},34656,7485.6960000000008,{"$f":"IF(C76=\"Reserve Ratio\",H76+AU12,H76)","v":7485.6960000000008},{"$f":"+F76*G76","v":2495.2320000000004},2495.2320000000004,{"$f":"ROUNDUP(I76/D76,0)","v":3},{"$f":"+IF(L76>L12,L12,L76)","v":3},{"$f":"ROUNDUP(M76/AM12,0)","v":1},0.86759282704266993,0.6]
["AR","Arkansas","Reserve Ratio",2558.8865096359741,{"$f":"+AY13","v":9.9499999999999991E-2},{"$f":"+AT13/100","v":9.9499999999999991E-2},43320,4310.3399999999992,4947.1439999999993,{"$f":"+F77*G77","v":4310.3399999999992},636.80399999999997,2,2,{"$f":"ROUNDUP(M77/AM13,0)","v":1},0.24885980585774059,0.4]
["AZ","Arizona","Reserve Ratio",3399.5269645849976,0.26,0.26,30324,7884.2400000000007,8354.2620000000006,7884.2400000000007,470.02199999999999,3,3,{"$f":"ROUNDUP(M78/AM14,0)","v":1},0.13826100069112957,0.6]
["CA","California","Reserve Ratio",5481.9208274055509,0.4,0.4,30324,12129.6,13394.1108,12129.6,1264.5108,3,3,1,0.2306692927191471,0.6]
["CO","Colorado","Reserve Ratio",5791.4913943204056,0.45,0.45,56749.2,25537.14,26405.402760000001,25537.14,868.26276000000007,5,5,2,0.14992040924924574,1]
["CT","Connecticut","Benefit Ratio",5575.8893657606104,0.16200000000000003,5.4000000000000006E-2,64980,10526.760000000002,10526.760000000002,3508.9200000000005,3508.9200000000005,2,2,1,0.62930229956622297,0.4]
["DC","District of Columbia","Reserve Ratio",5839.1659681475276,0.18,0.18,38988,7017.84,7976.9448000000002,7017.84,959.10480000000007,2,2,1,0.16425373165138438,0.4]
["DE","Delaware","Benefit Wage",4273.1542233579667,0.24599999999999997,8.199999999999999E-2,71478,17583.587999999996,17583.587999999996,5861.195999999999,5861.195999999999,5,5,2,1.3716322167736095,1]
["FL","Florida","Benefit Ratio",2270.6409471586544,0.16200000000000003,5.4000000000000006E-2,30324,4912.4880000000012,4912.4880000000012,1637.4960000000001,1637.4960000000001,3,3,1,0.72116025303298859,0.6]
["GA","Georgia","Reserve Ratio",2182.8046806828606,0.2445,0.2445,41154,10062.153,10621.847400000001,10062.153,559.69440000000009,5,5,2,0.25641066511956873,1]
["HI","Hawaii","Reserve Ratio",6905.2365509347574,0.17,0.17,202737.6,34465.392000000007,36715.779360000008,34465.392000000007,2250.3873600000002,6,5,2,0.32589576669829895,1]
["IA","Iowa","Benefit Ratio",4893.9970836033699,1.05,0.21,129526.8,136003.14000000001,136003.14000000001,27200.628000000001,27200.628000000001,28,5,1,5.5579575417263269,1]
["ID","Idaho","Reserve Ratio",2829.0297484533025,0.114,0.114,173280,19753.920000000002,21348.096000000001,19753.920000000002,1594.1759999999999,8,5,2,0.56350626955109739,1]
["IL","Illinois","Benefit Ratio",5649.4934465328988,0.252,8.4000000000000005E-2,56142.720000000001,14147.96544,14147.96544,4715.98848,4715.98848,3,3,1,0.83476306763294117,0.6]
["IN","Indiana","Reserve Ratio",3496.9743035051306,0.09,0.09,41154,3703.8599999999997,4366.4393999999993,3703.8599999999997,662.57939999999996,2,2,1,0.18947219581678801,0.4]
["KS","Kansas","Reserve Ratio",2937.2267145852052,0.5,0.5,60648,30324,31251.914400000001,30324,927.91440000000011,11,5,2,0.31591514383016911,1]
["KY","Kentucky","Reserve Ratio",5912.5013482903678,0.16,0.16,45486,7277.76,8069.2164000000002,7277.76,791.45639999999992,2,2,1,0.13386151704284244,0.4]
["LA","Louisiana","Reserve Ratio",4133.5106907084446,0.36499999999999999,0.36499999999999999,33356.400000000001,12175.085999999999,12662.08944,12175.085999999999,487.00344000000001,4,4,2,0.11781835743033538,0.8]
["MA","Massachusetts","Reserve Ratio",7856.4492231894756,0.31,0.31,64980,20143.8,22665.023999999998,20143.8,2521.2240000000002,3,3,2,0.32091138482232323,0.6]
["MD","Maryland","Benefit Ratio",5737.5721124340243,0.19739999999999999,6.5799999999999997E-2,36822,7268.6628000000001,7268.6628000000001,2422.8876,2422.8876,2,2,1,0.42228447024644877,0.4]
["ME","Maine","Reserve Ratio",4244.2312547336533,0.2,0.2,51984,10396.800000000001,11358.504000000001,10396.800000000001,961.70400000000018,3,3,1,0.22659085763232095,0.6]
["MI","Michigan","Reserve Ratio",3662.1887856125531,0.10300000000000001,0.10300000000000001,38988,4015.7640000000001,5220.4931999999999,4015.7640000000001,1204.7292,2,2,1,0.32896425349041419,0.4]
["MN","Minnesota","Benefit Ratio",6580.3517739025856,0.35799999999999998,8.9499999999999996E-2,147288,52729.103999999999,52729.103999999999,13182.276,13182.276,9,5,2,2.0032783129133587,1]
["MO","Missouri","Reserve Ratio",3065.1375709312861,0.27,0.27,51984,14035.68,14597.1072,14035.68,561.42720000000008,5,5,2,0.1831654165621743,1]
["MS","Mississippi","Benefit Ratio",2500.442310122583,0.16200000000000003,5.4000000000000006E-2,60648,9824.9760000000024,9824.9760000000024,3274.9920000000002,3274.9920000000002,4,4,2,1.3097650710603459,0.8]
["MT","Montana","Reserve Ratio",4585.7921900866686,0.2,0.2,142956,28591.200000000001,30220.898400000002,28591.200000000001,1629.6983999999998,7,5,2,0.35537990655638485,1]
["NC","North Carolina","Reserve Ratio",2144.8379663545425,8.199999999999999E-2,8.199999999999999E-2,105267.6,8631.9431999999997,9168.8079600000001,8631.9431999999997,536.86476000000005,5,5,2,0.25030550951710268,1]
["ND","North Dakota","Reserve Ratio",6044.526656536962,0.19700000000000004,0.19700000000000004,157684.79999999999,31063.905600000002,33129.576480000003,31063.905600000002,2065.6708800000001,6,5,2,0.34174237245956113,1]
["NE","Nebraska","Reserve Ratio",3896.8827713839569,0.2,0.2,38988,7797.6,8125.0992000000006,7797.6,327.49919999999997,3,3,1,8.4041327187189263E-2,0.6]
["NH","New Hampshire","Reserve Ratio",4093.3950357593603,0.33500000000000002,0.33500000000000002,60648,20317.080000000002,20859.408808766661,20317.080000000002,542.32880876665968,6,5,2,0.13248875420743578,1]
["NJ","New Jersey","Reserve Ratio",6963.9494504707691,0.52,0.52,149020.79999999999,77490.815999999992,79800.638399999996,77490.815999999992,2309.8224,12,5,2,0.33168282113877978,1]
["NM","New Mexico","Benefit Ratio",4952.2087653568005,0.192,6.4000000000000001E-2,{"$f":"+((L43-M43)*(AH43))+(M43*(AH43*0.666))","v":107433.60000000001},{"$f":"+E107*G107","v":20627.251200000002},20627.251200000002,6875.7504000000008,{"$f":"IF(C107=\"Reserve Ratio\",AU43,J107)","v":6875.7504000000008},5,5,2,{"$f":"+K107/D107","v":1.3884209502837086},{"$f":"+M107/L43","v":1}]
["NV","Nevada","Reserve Ratio",4912.419251792433,0.22399999999999998,0.22399999999999998,135158.39999999999,30275.481599999996,{"$f":"IF(C108=\"Reserve Ratio\",H108+AU44,H108)","v":32775.911999999997},30275.481599999996,2500.4304000000002,7,{"$f":"+IF(L108>L44,L44,L108)","v":5},2,0.50900183226170048,1]
["NY","New York","Reserve Ratio",5035.2812353232712,0.33,0.33,49384.800000000003,16296.984000000002,17358.757200000004,16296.984000000002,1061.7732000000001,4,4,1,0.2108667123797372,0.8]
["OH","Ohio","Reserve Ratio",5057.7414150140385,0.34,0.34,41154,13992.36,14938.902,13992.36,946.54200000000003,3,3,1,0.1871471715003391,0.6]
["OK","Oklahoma","Benefit Wage",5549.6587030716728,0.30000000000000004,0.1,78409.2,23522.760000000002,23522.760000000002,7840.92,7840.92,5,5,2,1.4128652624458042,1]
["OR","Oregon","Benefit Ratio",5886.4357315061543,0.67500000000000004,0.22500000000000001,175879.2,118718.46000000002,118718.46000000002,39572.820000000007,39572.820000000007,21,5,2,6.722713337069691,1]
["PA","Pennsylvania","Benefit Ratio",5197.1482733042112,0.32400000000000007,0.10800000000000001,43320,14035.680000000002,14035.680000000002,4678.5600000000004,4678.5600000000004,3,3,1,0.90021676388029892,0.6]
["PR","Puerto Rico","Reserve Ratio",2225.1736651114566,0.2,0.2,30324,6064.8,6919.9368000000004,6064.8,855.13679999999999,4,4,2,0.38430115069565463,0.8]
["RI","Rhode Island","Reserve Ratio",5130.6331800495227,0.41,0.41,102235.2,41916.431999999993,44441.641439999992,41916.431999999993,2525.2094400000001,9,5,2,0.492182806952421,1]
["SC","South Carolina","Benefit Ratio",3204.7833806093504,0.60000000000000009,0.2,60648,36388.800000000003,36388.800000000003,12129.6,12129.6,12,5,2,3.7848423932146407,1]
["SD","South Dakota","Reserve Ratio",4931.0411435194128,8.5999999999999993E-2,8.5999999999999993E-2,64980,5588.28,5939.1719999999996,5588.28,350.892,2,2,1,7.1159819962394233E-2,0.4]
["TN","Tennessee","Reserve Ratio",3482.8911414720142,0.24,0.24,30324,7277.7599999999993,7613.9901241838406,7277.7599999999993,336.23012418384167,3,3,1,9.6537649477536319E-2,0.6]
["TX","Texas","Benefit Ratio",5366.1412578657018,0.2475,8.2500000000000004E-2,38988,9649.5300000000007,9649.5300000000007,3216.51,3216.51,2,2,1,0.59940837287599025,0.4]
["UT","Utah","Benefit Ratio",4492.4476313780169,0.32,0.08,152919.6,48934.272000000004,48934.272000000004,12233.568000000001,12233.568000000001,11,5,2,2.7231409253506351,1]
["VA","Virginia","Benefit Ratio",4379.1009664292978,0.2,0.05,114798,22959.600000000002,22959.600000000002,5739.9000000000005,5739.9000000000005,6,5,2,1.3107484947259147,1]
["VI","Virgin Islands","Reserve Ratio",7583.8011226944664,0.09,0.09,34656,3119.04,3916.1279999999997,3119.04,797.08799999999997,1,1,1,0.10510402199428995,0.2]
["VT","Vermont","Benefit Ratio",4012.3877792469902,0.23099999999999998,7.6999999999999999E-2,67579.199999999997,15610.795199999999,15610.795199999999,5203.5983999999999,5203.5983999999999,4,4,2,1.2968832242272867,0.8]
["WA","Washington","Benefit Ratio",6670.4258582045532,0.22800000000000001,5.7000000000000002E-2,215733.6,49187.260800000004,49187.260800000004,12296.815200000001,12296.815200000001,8,5,2,1.8434827792703892,1]
["WI","Wisconsin","Reserve Ratio",3468.7646342605599,0.21,0.21,60648,12736.08,13694.3184,12736.08,958.23840000000007,4,4,2,0.27624774265039426,0.8]
["WV","West Virginia","Reserve Ratio",3771.7518182634462,0.18,0.18,51984,9357.119999999999,10776.283199999998,9357.119999999999,1419.1632,3,3,1,0.37626102362519637,0.6]
["WY","Wyoming","Benefit Ratio",4703.4254143646413,0.26519999999999999,8.8399999999999992E-2,110032.8,29180.698560000001,29180.698560000001,9726.899519999999,9726.899519999999,7,5,2,2.0680458736080438,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(M76:M127)","v":3.8269230769230771}]