{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Ewing","Calculations","Legacy Plan Table","NJEHP Table","GSHP Table","Rates as of 202507"],"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/25 to 6/30/26"]
[]
[null,"Enter Estimated Annual Pensionable Salary",null,null,null,null,"Select 10 or 12 Month Employee"]
[null,null,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":" "},{"$f":"Calculations!C50","v":" "},{"$f":"Calculations!D50","v":" "},{"$f":"Calculations!E50","v":" "}]
[null,"Aetna Choice POS II $15 & Rx",null,null,{"$f":"Calculations!B51","v":" "},{"$f":"Calculations!C51","v":" "},{"$f":"Calculations!D51","v":" "},{"$f":"Calculations!E51","v":" "}]
[null,"Aetna Choice POS II $15/$25 & Rx",null,null,{"$f":"Calculations!B52","v":" "},{"$f":"Calculations!C52","v":" "},{"$f":"Calculations!D52","v":" "},{"$f":"Calculations!E52","v":" "}]
[null,"Aetna Choice POS II $20/$20 & Rx",null,null,{"$f":"Calculations!B53","v":" "},{"$f":"Calculations!C53","v":" "},{"$f":"Calculations!D53","v":" "},{"$f":"Calculations!E53","v":" "}]
[null,"Aetna Choice POS II $20/$35 & Rx",null,null,{"$f":"Calculations!B54","v":" "},{"$f":"Calculations!C54","v":" "},{"$f":"Calculations!D54","v":" "},{"$f":"Calculations!E54","v":" "}]
[null,"Aetna HMO $10 & Rx",null,null,{"$f":"Calculations!B55","v":" "},{"$f":"Calculations!C55","v":" "},{"$f":"Calculations!D55","v":" "},{"$f":"Calculations!E55","v":" "}]
[null,"Aetna HMO $15/$25 & Rx",null,null,{"$f":"Calculations!B56","v":" "},{"$f":"Calculations!C56","v":" "},{"$f":"Calculations!D56","v":" "},{"$f":"Calculations!E56","v":" "}]
[null,"Aetna HMO $20/$30 & Rx",null,null,{"$f":"Calculations!B57","v":" "},{"$f":"Calculations!C57","v":" "},{"$f":"Calculations!D57","v":" "},{"$f":"Calculations!E57","v":" "}]
[]
[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":" "},{"$f":"Calculations!C14","v":" "},{"$f":"Calculations!D14","v":" "},{"$f":"Calculations!E14","v":" "}]
[null,"GSHP & Rx",null,null,{"$f":"Calculations!B15","v":" "},{"$f":"Calculations!C15","v":" "},{"$f":"Calculations!D15","v":" "},{"$f":"Calculations!E15","v":" "}]
[]
[]
["*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":0}]
["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":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$2,'Legacy Plan Table'!$A$1:$F$21,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$2,'Legacy Plan Table'!$A$1:$F$21,5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$2,'Legacy Plan Table'!$A$1:$F$21,6)","v":{"$error":"#N/A"}}]
["NJEHP Rate",{"$f":"VLOOKUP($B$2,'NJEHP Table'!$A$1:$F$11,3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$2,'NJEHP Table'!$A$1:$F$11,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$2,'NJEHP Table'!$A$1:$F$11,5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$2,'NJEHP Table'!$A$1:$F$11,6)","v":{"$error":"#N/A"}}]
["GSHP Rate",{"$f":"VLOOKUP($B$2,'GSHP Table'!$A$1:$F$11,3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$2,'GSHP Table'!$A$1:$F$11,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$2,'GSHP Table'!$A$1:$F$11,5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$2,'GSHP Table'!$A$1:$F$11,6)","v":{"$error":"#N/A"}}]
[]
["NJEHP Annual Employee Contribution",{"$f":"IF($B$4=0,B8*$B$2,B8*125000)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["GSHP Annual Employee Contribution",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["NJEHP Per Paycheck Employee Contribution",{"$f":"IFERROR(IF($B$3=1,B11/20,IF($B$3=2,B11/24,0)),\" \")","v":" "}," "," "," "]
["GSHP Per Paycheck Employee Contribution"," "," "," "," "]
[]
["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 202507'!B20","v":1669.77},{"$f":"'Rates as of 202507'!B21","v":2903.2799999999997},{"$f":"'Rates as of 202507'!B22","v":3446.76},{"$f":"'Rates as of 202507'!B23","v":4619.8900000000003}]
["Aetna Choice POS II $15 & Rx",{"$f":"'Rates as of 202507'!C20","v":1624.77},{"$f":"'Rates as of 202507'!C21","v":2820.2799999999997},{"$f":"'Rates as of 202507'!C22","v":3349.76},{"$f":"'Rates as of 202507'!C23","v":4483.8900000000003}]
["Aetna Choice POS II $15/$25 & Rx",{"$f":"'Rates as of 202507'!D20","v":1576.77},{"$f":"'Rates as of 202507'!D21","v":2732.2799999999997},{"$f":"'Rates as of 202507'!D22","v":3258.76},{"$f":"'Rates as of 202507'!D23","v":4351.8900000000003}]
["Aetna Choice POS II $20/$20 & Rx",{"$f":"'Rates as of 202507'!E20","v":1503.77},{"$f":"'Rates as of 202507'!E21","v":2604.2799999999997},{"$f":"'Rates as of 202507'!E22","v":3119.76},{"$f":"'Rates as of 202507'!E23","v":4152.8900000000003}]
["Aetna Choice POS II $20/$35 & Rx",{"$f":"'Rates as of 202507'!F20","v":1364.77},{"$f":"'Rates as of 202507'!F21","v":2339.2799999999997},{"$f":"'Rates as of 202507'!F22","v":2837.76},{"$f":"'Rates as of 202507'!F23","v":3749.8900000000003}]
["Aetna HMO $10 & Rx",{"$f":"'Rates as of 202507'!G20","v":1564.77},{"$f":"'Rates as of 202507'!G21","v":2718.2799999999997},{"$f":"'Rates as of 202507'!G22","v":3241.76},{"$f":"'Rates as of 202507'!G23","v":4325.8900000000003}]
["Aetna HMO $15/$25 & Rx",{"$f":"'Rates as of 202507'!H20","v":1467.77},{"$f":"'Rates as of 202507'!H21","v":2536.2799999999997},{"$f":"'Rates as of 202507'!H22","v":3043.76},{"$f":"'Rates as of 202507'!H23","v":4047.8900000000003}]
["Aetna HMO $20/$30 & Rx",{"$f":"'Rates as of 202507'!I20","v":1404.77},{"$f":"'Rates as of 202507'!I21","v":2420.2799999999997},{"$f":"'Rates as of 202507'!I22","v":2922.76},{"$f":"'Rates as of 202507'!I23","v":3868.8900000000003}]
[]
["Annual Full Premium"]
[{"$f":"A19","v":"Aetna Choice POS II $10 & Rx"},{"$f":"B19*12","v":20037.239999999998},34839.360000000001,41361.120000000003,55438.680000000008]
["Aetna Choice POS II $15 & Rx",19497.239999999998,33843.360000000001,40197.120000000003,53806.680000000008]
["Aetna Choice POS II $15/$25 & Rx",18921.239999999998,32787.360000000001,39105.120000000003,52222.680000000008]
["Aetna Choice POS II $20/$20 & Rx",18045.239999999998,31251.359999999997,37437.120000000003,49834.680000000008]
["Aetna Choice POS II $20/$35 & Rx",16377.24,28071.359999999997,34053.120000000003,44998.680000000008]
["Aetna HMO $10 & Rx",18777.239999999998,32619.359999999997,38901.120000000003,51910.680000000008]
["Aetna HMO $15/$25 & Rx",17613.239999999998,30435.359999999997,36525.120000000003,48574.680000000008]
["Aetna HMO $20/$30 & Rx",16857.239999999998,29043.359999999997,35073.120000000003,46426.680000000008]
[]
["Annual Employee Contribution"]
[{"$f":"A19","v":"Aetna Choice POS II $10 & Rx"},{"$f":"B29*B$7","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Aetna Choice POS II $15 & Rx",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Aetna Choice POS II $15/$25 & Rx",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Aetna Choice POS II $20/$20 & Rx",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Aetna Choice POS II $20/$35 & Rx",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Aetna HMO $10 & Rx",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Aetna HMO $15/$25 & Rx",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Aetna HMO $20/$30 & Rx",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
["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":" "}," "," "," "]
["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"," "," "," "," "]

{"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]
[25000,"$25,000 - $29,999.99",0.04,0.04,0.04,0.04]
[30000,"$30,000 - $34,999.99",0.04,0.04,0.04,0.04]
[35000,"$35,000 - $39,999.99",0.04,0.04,0.04,0.04]
[40000,"$40,000 - $44,999.99",0.04,0.04,0.04,0.04]
[45000,"$45,000 - $49,999.99",0.04,0.04,0.04,0.04]
[50000,"$50,000 - $54,999.99",0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001]
[55000,"$55,000 - $59.999.99",0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001]
[]
[60000,"$60,000 - $64,999.99",0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001]
[65000,"$65,000 - $69,999.99",0.19,0.19,0.19,0.19]
[70000,"$70,000 - $74,999.99 ",0.19,0.19,0.19,0.19]
[75000,"$75,000 - $79,999.99",0.25,0.25,0.25,0.25]
[80000,"$80,000 - $84,999.99",0.25,0.25,0.25,0.25]
[85000,"$85,000 - $89,999.99",0.25,0.25,0.25,0.25]
[90000,"$90,000 - $94,999.99",0.25,0.25,0.25,0.25]
[95000,"$95,000 - $99,999.99",0.25,0.25,0.25,0.25]
[100000,"$100,000 - $109,999.99",0.25,0.25,0.25,0.25]
[110000,"$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,"LE Peer Reviewed 4/2/2025"]

{"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,"LE Peer Reviewed 4/5/2025"]

{"sheet":"Rates as of 202507","index":5,"n_rows":26,"n_cols":9,"rows_kept":26,"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",1241,1196,1148,1075,936,1136,1039,976]
["Parent/Child",2303,2220,2132,2004,1739,2118,1936,1820]
["EE/Spouse",2482,2385,2294,2155,1873,2277,2079,1958]
["Family",3548,3412,3280,3081,2678,3254,2976,2797]
[]
[null,"Legacy Rx"]
[]
[null,"RX"]
["Single",428.77]
["Parent/Child",600.28]
["EE/Spouse",964.76]
["Family",1071.8900000000001]
[]
[null,"Total Legacy Medical & Rx 7/1/2025 to 6/30/2026"]
[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":1669.77},{"$f":"C5+B13","v":1624.77},{"$f":"D5+B13","v":1576.77},{"$f":"E5+B13","v":1503.77},{"$f":"F5+B13","v":1364.77},{"$f":"G5+B13","v":1564.77},{"$f":"H5+B13","v":1467.77},{"$f":"I5+B13","v":1404.77}]
["Parent/Child",{"$f":"B6+B14","v":2903.2799999999997},{"$f":"C6+B14","v":2820.2799999999997},{"$f":"D6+B14","v":2732.2799999999997},{"$f":"E6+B14","v":2604.2799999999997},{"$f":"F6+B14","v":2339.2799999999997},{"$f":"G6+B14","v":2718.2799999999997},{"$f":"H6+B14","v":2536.2799999999997},{"$f":"I6+B14","v":2420.2799999999997}]
["EE/Spouse",3446.76,3349.76,3258.76,3119.76,2837.76,3241.76,3043.76,2922.76]
["Family",4619.8900000000003,4483.8900000000003,{"$f":"D8+B16","v":4351.8900000000003},4152.8900000000003,3749.8900000000003,4325.8900000000003,4047.8900000000003,3868.8900000000003]
[]
[]
["LE Peer Reviewed 4/2/2025"]