{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Ewing","Calculations","Legacy Plan Table","NJEHP Table","GSHP Table","Rates as of 20240701"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Ewing","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[5,1,5,4],[8,1,8,7],[20,1,20,7],[11,1,11,3],[18,1,18,3],[17,1,17,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[9,1,9,7],[23,1,23,3],[22,1,22,3],[21,1,21,3],[10,1,10,3],[19,1,19,3]]}
["Ewing Township Board of Education",null,null,null,null,null,"Powered by"]
["Employee Health Benefits Calculator"]
["Effective 7/1/24 to 6/30/25"]
[]
[null,"Enter Estimated Annual Pensionable Salary",null,null,null,null,"Select 10 or 12 Month Employee"]
[null,75000,null,null,null,null,"10 Month"]
[]
[]
[null,"Legacy Medical and Rx Plans (per pay period)"]
[null,"These plans are only available to employees hired prior to July 1, 2020"]
[null,null,null,null,"Single","Parent/Child(ren)","2 Adult","Family"]
[null,"Aetna Choice POS II $10 & Rx",null,null,{"$f":"Calculations!B50","v":230.31300000000002},{"$f":"Calculations!C50","v":399.44849999999997},{"$f":"Calculations!D50","v":475.71900000000005},{"$f":"Calculations!E50","v":636.45150000000001}]
[null,"Aetna Choice POS II $15 & Rx",null,null,{"$f":"Calculations!B51","v":224.16300000000001},{"$f":"Calculations!C51","v":388.19849999999997},{"$f":"Calculations!D51","v":462.51900000000006},{"$f":"Calculations!E51","v":617.85149999999999}]
[null,"Aetna Choice POS II $15/$25 & Rx",null,null,{"$f":"Calculations!B52","v":217.56300000000002},{"$f":"Calculations!C52","v":376.19849999999997},{"$f":"Calculations!D52","v":450.06900000000007},{"$f":"Calculations!E52","v":599.85149999999999}]
[null,"Aetna Choice POS II $20/$20 & Rx",null,null,{"$f":"Calculations!B53","v":207.66300000000001},{"$f":"Calculations!C53","v":358.64849999999996},{"$f":"Calculations!D53","v":431.16900000000004},{"$f":"Calculations!E53","v":572.70150000000001}]
[null,"Aetna Choice POS II $20/$35 & Rx",null,null,{"$f":"Calculations!B54","v":188.613},{"$f":"Calculations!C54","v":322.49849999999998},{"$f":"Calculations!D54","v":392.61900000000003},{"$f":"Calculations!E54","v":517.65150000000006}]
[null,"Aetna HMO $10 & Rx",null,null,{"$f":"Calculations!B55","v":215.91300000000001},{"$f":"Calculations!C55","v":374.24849999999998},{"$f":"Calculations!D55","v":447.81900000000007},{"$f":"Calculations!E55","v":596.25150000000008}]
[null,"Aetna HMO $15/$25 & Rx",null,null,{"$f":"Calculations!B56","v":202.71300000000002},{"$f":"Calculations!C56","v":349.49849999999998},{"$f":"Calculations!D56","v":420.81900000000007},{"$f":"Calculations!E56","v":558.30150000000003}]
[null,"Aetna HMO $20/$30 & Rx",null,null,{"$f":"Calculations!B57","v":194.16300000000001},{"$f":"Calculations!C57","v":333.59849999999994},{"$f":"Calculations!D57","v":404.31900000000002},{"$f":"Calculations!E57","v":534.00150000000008}]
[]
[null,"Estimated NJEHP & GSHP  (per pay period)"]
[null,null,null,null,"Single","Parent/Child(ren)","2 Adult","Family"]
[null,"NJEHP & Rx",null,null,{"$f":"Calculations!B14","v":105},{"$f":"Calculations!C14","v":123.75},{"$f":"Calculations!D14","v":187.5},{"$f":"Calculations!E14","v":206.25}]
[null,"GSHP & Rx",null,null,{"$f":"Calculations!B15","v":56.25},{"$f":"Calculations!C15","v":61.875},{"$f":"Calculations!D15","v":93.75},{"$f":"Calculations!E15","v":103.125}]
[]
[]
["*NJEHP and GSHP are based on a percentage of pensionable salary. Final contribution amount will be determined by payroll."]

{"sheet":"Calculations","index":1,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":true,"merged":[[37,0,37,4],[48,0,48,4],[27,0,27,4],[16,0,16,4]]}
[]
["Salary from Calculator Sheet",{"$f":"Ewing!B6","v":75000}]
["Month Employment Indicator",{"$f":"IF(C3=\"10 Month\",1,IF(C3=\"12 Month\",2,0))","v":1},{"$f":"Ewing!$G$6","v":"10 Month"},"10 Month","12 Month"]
["NJEHP Contribution Max",{"$f":"IF(B2>125000,1,0)","v":0}]
[]
[null,"Single","P+C","2ADULT","FAMILY"]
["Chapter 78 Rate (Legacy Plans)",{"$f":"VLOOKUP($B$2,'Legacy Plan Table'!$A$1:$F$21,3)","v":0.25},{"$f":"VLOOKUP($B$2,'Legacy Plan Table'!$A$1:$F$21,4)","v":0.25},{"$f":"VLOOKUP($B$2,'Legacy Plan Table'!$A$1:$F$21,5)","v":0.25},{"$f":"VLOOKUP($B$2,'Legacy Plan Table'!$A$1:$F$21,6)","v":0.25}]
["NJEHP Rate",{"$f":"VLOOKUP($B$2,'NJEHP Table'!$A$1:$F$11,3)","v":2.8000000000000001E-2},{"$f":"VLOOKUP($B$2,'NJEHP Table'!$A$1:$F$11,4)","v":3.3000000000000002E-2},{"$f":"VLOOKUP($B$2,'NJEHP Table'!$A$1:$F$11,5)","v":0.05},{"$f":"VLOOKUP($B$2,'NJEHP Table'!$A$1:$F$11,6)","v":5.5E-2}]
["GSHP Rate",{"$f":"VLOOKUP($B$2,'GSHP Table'!$A$1:$F$11,3)","v":1.4999999999999999E-2},{"$f":"VLOOKUP($B$2,'GSHP Table'!$A$1:$F$11,4)","v":1.6500000000000001E-2},{"$f":"VLOOKUP($B$2,'GSHP Table'!$A$1:$F$11,5)","v":2.5000000000000001E-2},{"$f":"VLOOKUP($B$2,'GSHP Table'!$A$1:$F$11,6)","v":2.75E-2}]
[]
["NJEHP Annual Employee Contribution",{"$f":"IF($B$4=0,B8*$B$2,B8*125000)","v":2100},2475,3750,4125]
["GSHP Annual Employee Contribution",1125,1237.5,1875,2062.5]
[]
["NJEHP Per Paycheck Employee Contribution",{"$f":"IFERROR(IF($B$3=1,B11/20,IF($B$3=2,B11/24,0)),\" \")","v":105},123.75,187.5,206.25]
["GSHP Per Paycheck Employee Contribution",56.25,61.875,93.75,103.125]
[]
["Monthly Full Premium"]
["Plan Name","Single Rate","P+C Rate","2 Adult Rate","Family Rate"]
["Aetna Choice POS II $10 & Rx",{"$f":"'Rates as of 20240701'!B20","v":1535.42},{"$f":"'Rates as of 20240701'!B21","v":2662.99},{"$f":"'Rates as of 20240701'!B22","v":3171.46},{"$f":"'Rates as of 20240701'!B23","v":4243.01}]
["Aetna Choice POS II $15 & Rx",{"$f":"'Rates as of 20240701'!C20","v":1494.42},{"$f":"'Rates as of 20240701'!C21","v":2587.9899999999998},{"$f":"'Rates as of 20240701'!C22","v":3083.46},{"$f":"'Rates as of 20240701'!C23","v":4119.01}]
["Aetna Choice POS II $15/$25 & Rx",{"$f":"'Rates as of 20240701'!D20","v":1450.42},{"$f":"'Rates as of 20240701'!D21","v":2507.9899999999998},{"$f":"'Rates as of 20240701'!D22","v":3000.46},{"$f":"'Rates as of 20240701'!D23","v":3999.01}]
["Aetna Choice POS II $20/$20 & Rx",{"$f":"'Rates as of 20240701'!E20","v":1384.42},{"$f":"'Rates as of 20240701'!E21","v":2390.9899999999998},{"$f":"'Rates as of 20240701'!E22","v":2874.46},{"$f":"'Rates as of 20240701'!E23","v":3818.01}]
["Aetna Choice POS II $20/$35 & Rx",{"$f":"'Rates as of 20240701'!F20","v":1257.42},{"$f":"'Rates as of 20240701'!F21","v":2149.9899999999998},{"$f":"'Rates as of 20240701'!F22","v":2617.46},{"$f":"'Rates as of 20240701'!F23","v":3451.01}]
["Aetna HMO $10 & Rx",{"$f":"'Rates as of 20240701'!G20","v":1439.42},{"$f":"'Rates as of 20240701'!G21","v":2494.9899999999998},{"$f":"'Rates as of 20240701'!G22","v":2985.46},{"$f":"'Rates as of 20240701'!G23","v":3975.01}]
["Aetna HMO $15/$25 & Rx",{"$f":"'Rates as of 20240701'!H20","v":1351.42},{"$f":"'Rates as of 20240701'!H21","v":2329.9899999999998},{"$f":"'Rates as of 20240701'!H22","v":2805.46},{"$f":"'Rates as of 20240701'!H23","v":3722.01}]
["Aetna HMO $20/$30 & Rx",{"$f":"'Rates as of 20240701'!I20","v":1294.42},{"$f":"'Rates as of 20240701'!I21","v":2223.9899999999998},{"$f":"'Rates as of 20240701'!I22","v":2695.46},{"$f":"'Rates as of 20240701'!I23","v":3560.01}]
[]
["Annual Full Premium"]
[{"$f":"A19","v":"Aetna Choice POS II $10 & Rx"},{"$f":"B19*12","v":18425.04},31955.879999999997,38057.520000000004,50916.12]
["Aetna Choice POS II $15 & Rx",17933.04,31055.879999999997,37001.520000000004,49428.12]
["Aetna Choice POS II $15/$25 & Rx",17405.04,30095.879999999997,36005.520000000004,47988.12]
["Aetna Choice POS II $20/$20 & Rx",16613.04,28691.879999999997,34493.520000000004,45816.12]
["Aetna Choice POS II $20/$35 & Rx",15089.04,25799.879999999997,31409.52,41412.120000000003]
["Aetna HMO $10 & Rx",17273.04,29939.879999999997,35825.520000000004,47700.12]
["Aetna HMO $15/$25 & Rx",16217.04,27959.879999999997,33665.520000000004,44664.12]
["Aetna HMO $20/$30 & Rx",15533.04,26687.879999999997,32345.52,42720.12]
[]
["Annual Employee Contribution"]
[{"$f":"A19","v":"Aetna Choice POS II $10 & Rx"},{"$f":"B29*B$7","v":4606.26},7988.9699999999993,9514.380000000001,12729.03]
["Aetna Choice POS II $15 & Rx",4483.26,7763.9699999999993,9250.380000000001,12357.03]
["Aetna Choice POS II $15/$25 & Rx",4351.26,7523.9699999999993,9001.380000000001,11997.03]
["Aetna Choice POS II $20/$20 & Rx",4153.26,7172.9699999999993,8623.380000000001,11454.03]
["Aetna Choice POS II $20/$35 & Rx",3772.26,6449.9699999999993,7852.38,10353.030000000001]
["Aetna HMO $10 & Rx",4318.26,7484.9699999999993,8956.380000000001,11925.03]
["Aetna HMO $15/$25 & Rx",4054.26,6989.9699999999993,8416.380000000001,11166.03]
["Aetna HMO $20/$30 & Rx",3883.26,6671.9699999999993,8086.38,10680.03]
[]
[]
["Employee Per Paycheck Contribution"]
[{"$f":"A19","v":"Aetna Choice POS II $10 & Rx"},{"$f":"IFERROR(IF($B$3=1,B39/20,IF($B$3=2,B39/24,0)),\" \")","v":230.31300000000002},399.44849999999997,475.71900000000005,636.45150000000001]
["Aetna Choice POS II $15 & Rx",224.16300000000001,388.19849999999997,462.51900000000006,617.85149999999999]
["Aetna Choice POS II $15/$25 & Rx",217.56300000000002,376.19849999999997,450.06900000000007,599.85149999999999]
["Aetna Choice POS II $20/$20 & Rx",207.66300000000001,358.64849999999996,431.16900000000004,572.70150000000001]
["Aetna Choice POS II $20/$35 & Rx",188.613,322.49849999999998,392.61900000000003,517.65150000000006]
["Aetna HMO $10 & Rx",215.91300000000001,374.24849999999998,447.81900000000007,596.25150000000008]
["Aetna HMO $15/$25 & Rx",202.71300000000002,349.49849999999998,420.81900000000007,558.30150000000003]
["Aetna HMO $20/$30 & Rx",194.16300000000001,333.59849999999994,404.31900000000002,534.00150000000008]

{"sheet":"Legacy Plan Table","index":2,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[null,"Salary","Single","Parent/Child(ren)","Member/Spouse","Family"]
[0.01,"Less than $20,000",0.04,0.04,0.04,0.04]
[20000,"$20,000 - $24,999.99",0.04,0.04,0.04,0.04]
[24999.99,"$25,000 - $29,999.99",0.04,0.04,0.04,0.04]
[29999.99,"$30,000 - $34,999.99",0.04,0.04,0.04,0.04]
[34999.99,"$35,000 - $39,999.99",0.04,0.04,0.04,0.04]
[39999.99,"$40,000 - $44,999.99",0.04,0.04,0.04,0.04]
[44999.99,"$45,000 - $49,999.99",0.04,0.04,0.04,0.04]
[49999.99,"$50,000 - $54,999.99",0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001]
[54999.99,"$55,000 - $59.999.99",0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001]
[]
[59999.99,"$60,000 - $64,999.99",0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001]
[64999.99,"$65,000 - $69,999.99",0.19,0.19,0.19,0.19]
[69999.990000000005,"$70,000 - $74,999.99 ",0.19,0.19,0.19,0.19]
[74999.990000000005,"$75,000 - $79,999.99",0.25,0.25,0.25,0.25]
[79999.990000000005,"$80,000 - $84,999.99",0.25,0.25,0.25,0.25]
[84999.99,"$85,000 - $89,999.99",0.25,0.25,0.25,0.25]
[89999.99,"$90,000 - $94,999.99",0.25,0.25,0.25,0.25]
[94999.99,"$95,000 - $99,999.99",0.25,0.25,0.25,0.25]
[99999.99,"$100,000 - $109,999.99",0.25,0.25,0.25,0.25]
[109999.99,"$110,000 and over",0.25,0.25,0.25,0.25]
[1000000]

{"sheet":"NJEHP Table","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,"Salary","Single","Parent/Child(ren)","Member/Spouse","Family"]
[null,null,1.7000000000000001E-2,2.1999999999999999E-2,2.8000000000000001E-2,3.3000000000000002E-2]
[0.01,"Up to 40,000",1.7000000000000001E-2,2.1999999999999999E-2,2.8000000000000001E-2,3.3000000000000002E-2]
[40000.99,"40001-50000",1.9E-2,2.5000000000000001E-2,3.3000000000000002E-2,3.9E-2]
[50000.99,"50001-60000",2.1999999999999999E-2,2.8000000000000001E-2,3.9E-2,4.3999999999999997E-2]
[60000.99,"60001-70000",2.5000000000000001E-2,0.03,4.3999999999999997E-2,0.05]
[70000.990000000005,"70001-80000",2.8000000000000001E-2,3.3000000000000002E-2,0.05,5.5E-2]
[80000.990000000005,"80001-90000",0.03,3.5999999999999997E-2,5.5E-2,0.06]
[90000.99,"90001-100000",3.3000000000000002E-2,3.9E-2,0.06,6.6000000000000003E-2]
[100000.99,"100001-125000",3.5999999999999997E-2,4.3999999999999997E-2,6.6000000000000003E-2,7.1999999999999995E-2]
[100000000.98999999]
[]
[]
[]
[]
[]
[]
[]
[null,"peer reviewed Liz 4/6/23"]

{"sheet":"GSHP Table","index":4,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":true,"merged":[[11,10,11,12],[11,2,11,4]]}
[null,"Salary","Single","Parent/Child(ren)","Member/Spouse","Family",null,null,null,"Salary","Single","Parent/Child(ren)","Member/Spouse","Family"]
[null,null,{"$f":"IF(K2/2<0.015,0.015,K2/2)","v":1.4999999999999999E-2},{"$f":"IF(L2/2<0.015,0.015,L2/2)","v":1.4999999999999999E-2},{"$f":"IF(M2/2<0.015,0.015,M2/2)","v":1.4999999999999999E-2},{"$f":"IF(N2/2<0.015,0.015,N2/2)","v":1.6500000000000001E-2},null,null,null,null,1.7000000000000001E-2,2.1999999999999999E-2,2.8000000000000001E-2,3.3000000000000002E-2]
[0.01,"Up to 40,000",{"$f":"IF(K3/2<0.015,0.015,K3/2)","v":1.4999999999999999E-2},{"$f":"IF(L3/2<0.015,0.015,L3/2)","v":1.4999999999999999E-2},{"$f":"IF(M3/2<0.015,0.015,M3/2)","v":1.4999999999999999E-2},{"$f":"IF(N3/2<0.015,0.015,N3/2)","v":1.6500000000000001E-2},null,null,0.01,"Up to 40,000",1.7000000000000001E-2,2.1999999999999999E-2,2.8000000000000001E-2,3.3000000000000002E-2]
[40000.99,"40001-50000",1.4999999999999999E-2,1.4999999999999999E-2,1.6500000000000001E-2,1.95E-2,null,null,40000.99,"40001-50000",1.9E-2,2.5000000000000001E-2,3.3000000000000002E-2,3.9E-2]
[50000.99,"50001-60000",1.4999999999999999E-2,1.4999999999999999E-2,1.95E-2,2.1999999999999999E-2,null,null,50000.99,"50001-60000",2.1999999999999999E-2,2.8000000000000001E-2,3.9E-2,4.3999999999999997E-2]
[60000.99,"60001-70000",1.4999999999999999E-2,1.4999999999999999E-2,2.1999999999999999E-2,2.5000000000000001E-2,null,null,60000.99,"60001-70000",2.5000000000000001E-2,0.03,4.3999999999999997E-2,0.05]
[70000.990000000005,"70001-80000",1.4999999999999999E-2,1.6500000000000001E-2,2.5000000000000001E-2,2.75E-2,null,null,70000.990000000005,"70001-80000",2.8000000000000001E-2,3.3000000000000002E-2,0.05,5.5E-2]
[80000.990000000005,"80001-90000",1.4999999999999999E-2,1.7999999999999999E-2,2.75E-2,0.03,null,null,80000.990000000005,"80001-90000",0.03,3.5999999999999997E-2,5.5E-2,0.06]
[90000.99,"90001-100000",1.6500000000000001E-2,1.95E-2,0.03,3.3000000000000002E-2,null,null,90000.99,"90001-100000",3.3000000000000002E-2,3.9E-2,0.06,6.6000000000000003E-2]
[100000.99,"100001-125000",1.7999999999999999E-2,2.1999999999999999E-2,3.3000000000000002E-2,3.5999999999999997E-2,null,null,100000.99,"100001-125000",3.5999999999999997E-2,4.3999999999999997E-2,6.6000000000000003E-2,7.1999999999999995E-2]
[100000000.98999999,null,null,null,null,null,null,null,100000000.98999999]
[null,null,"GSHP Table",null,null,null,null,null,null,null,"NJEHP Table"]
[]
[]
[]
[]
[]
[]
[]
[null,"peer reviewed Liz 4/6/23"]

{"sheet":"Rates as of 20240701","index":5,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Legacy Medical"]
[null,"Aetna Choice POS II $10","Aetna Choice POS II $15","Aetna Choice POS II $15/$25","Aetna Choice POS II $20/$20","Aetna Choice POS II $20/$35","Aetna HMO $10","Aetna HMO $15/$25","Aetna HMO $20/$30"]
["Single",1129,1088,1044,978,851,1033,945,888]
["Parent/Child",2094,2019,1939,1822,1581,1926,1761,1655]
["EE/Spouse",2257,2169,2086,1960,1703,2071,1891,1781]
["Family",3227,3103,2983,2802,2435,2959,2706,2544]
[]
[null,"Legacy Rx"]
[]
[null,"RX"]
["Single",406.42]
["Parent/Child",568.99]
["EE/Spouse",914.46]
["Family",1016.01]
[]
[null,"Total Legacy Medical & Rx 7/1/2024 to 6/30/2025"]
[null,"Aetna Choice POS II $10 + RX","Aetna Choice POS II $15 + RX","Aetna Choice POS II $15/$25 + RX","Aetna Choice POS II $20/$20 + RX","Aetna Choice POS II $20/$35 + RX","Aetna HMO $10 + RX","Aetna HMO $15/$25 + RX","Aetna HMO $20/$30 + RX"]
["Single",{"$f":"B5+B13","v":1535.42},{"$f":"C5+B13","v":1494.42},{"$f":"D5+B13","v":1450.42},{"$f":"E5+B13","v":1384.42},{"$f":"F5+B13","v":1257.42},{"$f":"G5+B13","v":1439.42},{"$f":"H5+B13","v":1351.42},{"$f":"I5+B13","v":1294.42}]
["Parent/Child",{"$f":"B6+B14","v":2662.99},{"$f":"C6+B14","v":2587.9899999999998},{"$f":"D6+B14","v":2507.9899999999998},{"$f":"E6+B14","v":2390.9899999999998},{"$f":"F6+B14","v":2149.9899999999998},{"$f":"G6+B14","v":2494.9899999999998},{"$f":"H6+B14","v":2329.9899999999998},{"$f":"I6+B14","v":2223.9899999999998}]
["EE/Spouse",3171.46,3083.46,3000.46,2874.46,2617.46,2985.46,2805.46,2695.46]
["Family",4243.01,4119.01,3999.01,3818.01,3451.01,3975.01,3722.01,3560.01]