{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Contribution Calculator","CalculationSheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Contribution Calculator","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[26,2,26,4],[26,8,26,11],[28,2,28,5],[29,2,29,5],[29,6,29,7],[29,8,29,9],[14,2,14,5],[14,6,14,7],[14,8,14,9],[15,6,15,7],[15,8,15,9],[19,2,19,4],[19,8,19,11],[15,2,15,5],[16,2,16,5],[16,6,16,7],[16,8,16,9],[17,2,17,5],[22,10,22,11],[21,2,21,5],[22,2,22,5],[22,6,22,7],[22,8,22,9],[1,5,1,7],[1,8,1,9],[4,2,4,4],[4,9,4,11],[8,2,8,4],[8,8,8,11],[4,5,4,6],[6,5,6,7],[10,2,10,5],[12,2,12,5],[12,8,12,9],[13,8,13,9],[11,6,11,7],[13,2,13,5],[12,6,12,7],[13,6,13,7],[11,2,11,5],[11,8,11,9],[23,6,23,7],[23,8,23,9],[23,10,23,11],[24,6,24,7],[24,8,24,9],[24,10,24,11],[32,2,32,5],[32,6,32,7],[32,8,32,9],[29,10,29,11],[32,10,32,11],[31,2,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[10,10,10,11],[30,2,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[17,6,17,7],[17,8,17,9],[11,10,11,11],[12,10,12,11],[13,10,13,11],[14,10,14,11],[15,10,15,11],[16,10,16,11],[17,10,17,11],[23,2,23,5],[24,2,24,5]]}
["Randolph Board of Education",null,null,null,null,null,null,null,null,null,null,"Powered by"]
["Employee Contribution Calculator",null,null,null,null,"Per Paycheck Contribution",null,null,{"$f":"CalculationSheet!C68","v":0}]
["2023-2024"]
[]
[null,"Step 1","Enter your base salary",null,null,25000,null,null,"Step 2","Are you a 10 or 12 month employee?"]
[]
[null,null,null,null,"Step 3","Where you hired after 07/01/2020",null,null,"Yes"]
[]
[null,"Step 4","Select Medical Contract Type",null,null,null,null,null,"Your Contribution Percentage",null,null,null,{"$f":"CalculationSheet!D39","v":" "}]
[]
[null,"Pick Plan","Medical/ Rx Plans Offered",null,null,null,"Monthly Premium",null,"Annual Contribution",null,"Payperiod Contribution"]
[null,null,{"$f":"CalculationSheet!A2","v":"SHIF Aetna Managed Choice POS $5 (High Plan)"},null,null,null,{"$f":"CalculationSheet!B41","v":"Not Available"},null,{"$f":"CalculationSheet!E41","v":" "},null,{"$f":"CalculationSheet!F41","v":" "}]
[null,null,{"$f":"CalculationSheet!A3","v":"SHIF Aetna Managed Choice POS $25(Low Plan)"},null,null,null,{"$f":"CalculationSheet!B42","v":"Not Available"},null,{"$f":"CalculationSheet!E42","v":" "},null,{"$f":"CalculationSheet!F42","v":" "}]
[null,null,{"$f":"CalculationSheet!A4","v":"SHIF Aetna OAEC Savings Plus "},null,null,null,{"$f":"CalculationSheet!B43","v":"Not Available"},null,{"$f":"CalculationSheet!E43","v":" "},null,{"$f":"CalculationSheet!F43","v":" "}]
[null,null,{"$f":"CalculationSheet!A5","v":"SHIF Aetna OAMC HSA"},null,null,null,{"$f":"CalculationSheet!B44","v":"Not Available"},null,{"$f":"CalculationSheet!E44","v":" "},null,{"$f":"CalculationSheet!F44","v":" "}]
[null,null,{"$f":"CalculationSheet!A6","v":"SHIF Aetna NJEHP"},null,null,null,{"$f":"CalculationSheet!B45","v":" "},null,{"$f":"CalculationSheet!E45","v":" "},null,{"$f":"CalculationSheet!F45","v":" "},null,{"$f":"CalculationSheet!F39","v":" "}]
[null,null,{"$f":"CalculationSheet!A7","v":"SHIF Aetna GSHP"},null,null,null,{"$f":"CalculationSheet!B46","v":" "},null,{"$f":"CalculationSheet!E46","v":" "},null,{"$f":"CalculationSheet!F46","v":" "},null,{"$f":"CalculationSheet!G39","v":" "}]
[null,null,{"$f":"CalculationSheet!A8","v":"Medical Benefits Waived"},null,null,null,{"$f":"CalculationSheet!B47","v":" "},null,{"$f":"CalculationSheet!E47","v":" "},null,{"$f":"CalculationSheet!F47","v":" "}]
[]
[null,"Step 5","Select Rx Contract Type",null,null,null,null,null,"Your Contribution Percentage",null,null,null,{"$f":"CalculationSheet!D49","v":" "}]
[]
[null,"Pick Plan","Prescription Plans Offered",null,null,null,null,null,"Annual Contribution",null,"Payperiod Contribution"]
[null,null,{"$f":"CalculationSheet!A12","v":"Aetna Dental Premier"},null,null,null,{"$f":"CalculationSheet!B50","v":" "},null,{"$f":"CalculationSheet!C50","v":" "},null,{"$f":"CalculationSheet!F50","v":" "}]
[null,null,{"$f":"CalculationSheet!A13","v":"Aetna Dental Preferred"},null,null,null,{"$f":"CalculationSheet!B51","v":" "},null,{"$f":"CalculationSheet!C51","v":" "},null,{"$f":"CalculationSheet!F51","v":" "}]
[null,null,{"$f":"CalculationSheet!A14","v":"Aetna Dental DMO"},null,null,null,{"$f":"CalculationSheet!B52","v":" "},null,{"$f":"CalculationSheet!C52","v":" "},null,{"$f":"CalculationSheet!F52","v":" "}]
[]
[null,"Step 5","Select Dental Contract Type",null,null,null,"Three + People",null,"Your Contribution Percentage",null,null,null,{"$f":"CalculationSheet!D55","v":0.04}]
[]
[null,"Pick Plan","Dental Plans Offered",null,null,null,"Monthly Premium",null,"Annual Contribution",null,"Payperiod Contribution"]
[null,null,{"$f":"CalculationSheet!A20","v":"Aetna Dental Premier"},null,null,null,{"$f":"CalculationSheet!B56","v":131.44999999999999},null,{"$f":"CalculationSheet!C56","v":63.095999999999997},null,{"$f":"CalculationSheet!F56","v":" "}]
[null,null,{"$f":"CalculationSheet!A21","v":"Aetna Dental Preferred"},null,null,null,{"$f":"CalculationSheet!B57","v":110.85},null,{"$f":"CalculationSheet!C57","v":53.207999999999991},null,{"$f":"CalculationSheet!F57","v":" "}]
[null,null,{"$f":"CalculationSheet!A22","v":"Aetna Dental DMO"},null,null,null,{"$f":"CalculationSheet!B58","v":48.98},null,{"$f":"CalculationSheet!C58","v":23.510400000000001},null,{"$f":"CalculationSheet!F58","v":" "}]
[null,null,{"$f":"CalculationSheet!A23","v":"Waive Dental"},null,null,null,{"$f":"CalculationSheet!B59","v":0},null,{"$f":"CalculationSheet!C59","v":0},null,{"$f":"CalculationSheet!F59","v":" "}]
[]
[null,"NJEHP and GSHP prescription coverage is automatically included with the medical plan."]
[null,"The above amounts are estimates. Human Resources will verify the final amount to be deducted."]

{"sheet":"CalculationSheet","index":1,"n_rows":93,"n_cols":23,"rows_kept":93,"cut":false,"hidden":true,"merged":[[53,0,53,5],[17,3,17,7],[24,3,24,7],[60,0,60,5],[0,0,0,1],[33,0,33,1],[0,3,0,7],[36,0,36,5],[47,0,47,5],[10,3,10,7]]}
["Plans Offered and Coverage Types",null,null,"Medical Plan Rates",null,null,null,null,null,null,"Chapter 78"]
["SHIF Aetna Managed Choice POS $5 (High Plan)","Single",null,null,"Family","Member/Spouse","Parent/Child(ren)","Single",null,null,null,"Salary","Single","Parent/Child(ren)","Member/Spouse","Family"]
["SHIF Aetna Managed Choice POS $25(Low Plan)","Parent/Child(ren)",null,{"$f":"A2","v":"SHIF Aetna Managed Choice POS $5 (High Plan)"},3513.57,3017.28,2005.84,1358.42,null,null,0.01,"Less than $20,000",4.4999999999999998E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.03]
["SHIF Aetna OAEC Savings Plus ","Member/Spouse",null,{"$f":"A3","v":"SHIF Aetna Managed Choice POS $25(Low Plan)"},3074.57,2639.28,1754.84,1189.42,null,null,20000,"$20,000 - $24,999.99",5.5E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.03]
["SHIF Aetna OAMC HSA","Family",null,"SHIF Aetna OAEC Savings Plus ",3014.57,2587.2800000000002,1720.84,1165.42,null,null,24999.99,"$25,000 - $29,999.99",7.4999999999999997E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04]
["SHIF Aetna NJEHP",null,null,"SHIF Aetna OAMC HSA",2555,1891,1451,848,null,null,29999.99,"$30,000 - $34,999.99",0.1,0.06,0.06,0.05]
["SHIF Aetna GSHP","One Person",null,"SHIF Aetna NJEHP",3543.5,3042.58,2022.59,1370.28,null,null,34999.99,"$35,000 - $39,999.99",0.11,7.0000000000000007E-2,7.0000000000000007E-2,0.06]
["Medical Benefits Waived","Two People",null,"SHIF Aetna GSHP",3184.5,2733.58,1817.59,1231.28,null,null,39999.99,"$40,000 - $44,999.99",0.12,0.08,0.08,7.0000000000000007E-2]
["Not Used","Three + People",null,"Medical Benefits Waived",0,0,0,0,null,null,44999.99,"$45,000 - $49,999.99",0.14000000000000001,0.1,0.1,0.09]
[null,null,null,"Not Used",null,null,null,null,null,null,49999.99,"$50,000 - $54,999.99",0.2,0.15,0.15,0.12]
[null,null,null,"Rx Plan Rates",null,null,null,null,null,null,54999.99,"$55,000 - $59.999.99",0.23,0.17,0.17,0.14000000000000001]
["Aetna Dental Premier","Number of Months",null,null,"One Person","Two People","Three + People",null,null,null,59999.99,"$60,000 - $64,999.99",0.27,0.21,0.21,0.17]
["Aetna Dental Preferred",10,null,{"$f":"A12","v":"Aetna Dental Premier"},54.01,75.83,131.44999999999999,281.92,null,null,64999.99,"$65,000 - $69,999.99",0.28999999999999998,0.23,0.23,0.19]
["Aetna Dental DMO",12,null,{"$f":"A13","v":"Aetna Dental Preferred"},43.27,62.2,110.85,0,null,null,69999.990000000005,"$70,000 - $74,999.99 ",0.32,0.26,0.26,0.22]
[null,null,null,{"$f":"A14","v":"Aetna Dental DMO"},15.25,29.19,48.98,0,null,null,74999.990000000005,"$75,000 - $79,999.99",0.33,0.27,0.27,0.23]
[null,"7/1/2020 Hire Date",null,null,null,null,null,null,null,null,79999.990000000005,"$80,000 - $84,999.99",0.34,0.28000000000000003,0.28000000000000003,0.24]
[null,"Yes",null,null,null,null,null,null,null,null,84999.99,"$85,000 - $89,999.99",0.34,0.3,0.3,0.26]
[null,"No",null,"Dental Plan Rates",null,null,null,null,null,null,89999.99,"$90,000 - $94,999.99",0.34,0.3,0.3,0.28000000000000003]
[null,null,null,null,"One Person","Three + People","Two People",null,null,null,94999.99,"$95,000 - $99,999.99",0.35,0.3,0.3,0.28999999999999998]
["Aetna Dental Premier",null,null,{"$f":"A20","v":"Aetna Dental Premier"},54.01,131.44999999999999,75.83,null,null,null,99999.99,"$100,000 - $109,999.99",0.35,0.35,0.35,0.32]
["Aetna Dental Preferred","Single",null,{"$f":"A21","v":"Aetna Dental Preferred"},43.27,110.85,62.2,null,null,null,109999.99,"$110,000 and over",0.35,0.35,0.35,0.35]
["Aetna Dental DMO","Family",null,{"$f":"A22","v":"Aetna Dental DMO"},15.25,48.98,29.19,null,null,null,1000000]
["Waive Dental",null,null,{"$f":"A23","v":"Waive Dental"},0,0,0]
["Aetna Vision (for POS Enrolled Only)",null,null,null,null,null,null,null,null,null,"Chapter 78 Dental (less than 4 tiers)"]
["Vision Plan 3",null,null,"Vision Plan Rates",null,null,null,null,null,null,null,"Salary","One Party","Two Party","Three or More Party"]
["Vision Plan 4",null,null,"Family","Family","Member/Spouse","Parent/Child(ren)","Single",null,null,0.01,"Less than $20,000",4.4999999999999998E-2,3.5000000000000003E-2,0.03]
[null,null,null,{"$f":"A24","v":"Aetna Vision (for POS Enrolled Only)"},28.46,14.09,19.100000000000001,7.04,null,null,20000,"$20,000 - $24,999.99",5.5E-2,3.5000000000000003E-2,0.03]
[null,null,null,{"$f":"A24","v":"Aetna Vision (for POS Enrolled Only)"},1700,1200,700,200,null,null,24999.99,"$25,000 - $29,999.99",7.4999999999999997E-2,4.4999999999999998E-2,0.04]
[null,null,null,null,null,null,null,null,null,null,29999.99,"$30,000 - $34,999.99",0.1,0.06,0.05]
[null,null,null,null,null,null,null,null,null,null,34999.99,"$35,000 - $39,999.99",0.11,7.0000000000000007E-2,0.06]
[null,null,null,null,null,null,null,null,null,null,39999.99,"$40,000 - $44,999.99",0.12,0.08,7.0000000000000007E-2,null,null,null,{"$f":"A22","v":"Aetna Dental DMO"}]
[null,null,null,null,null,null,null,null,null,null,44999.99,"$45,000 - $49,999.99",0.14000000000000001,0.1,0.09,null,null,null,{"$f":"A23","v":"Waive Dental"}]
[null,null,null,null,null,null,null,null,null,null,49999.99,"$50,000 - $54,999.99",0.2,0.15,0.12]
[null,null,null,null,null,null,null,null,null,null,54999.99,"$55,000 - $59.999.99",0.23,0.17,0.14000000000000001]
["Benefit Surcharge Indicator",{"$f":"IF(B39>125000,1,0)","v":0},null,"Hire Date Indicator",{"$f":"'Contribution Calculator'!I7:I7","v":"Yes"},null,null,null,null,null,59999.99,"$60,000 - $64,999.99",0.27,0.21,0.17]
[null,null,null,null,null,null,null,null,null,null,64999.99,"$65,000 - $69,999.99",0.28999999999999998,0.23,0.19]
["Medical Contributions",null,null,null,null,null,null,null,null,null,69999.990000000005,"$70,000 - $74,999.99 ",0.32,0.26,0.22]
[null,"Salary","Contract Type","Chapter 78","Months","Chapter 44","GHSP",null,null,null,74999.990000000005,"$75,000 - $79,999.99",0.33,0.27,0.23,null,null,null,{"$f":"A25","v":"Vision Plan 3"},1800,1300,800,300]
["Medical Percentage",{"$f":"'Contribution Calculator'!F5","v":25000},{"$f":"'Contribution Calculator'!G9","v":0},{"$f":"IF(C39=\"Single\",VLOOKUP(B39,K3:P21,3),IF(C39=\"Parent/Child(ren)\",VLOOKUP(B39,K3:P21,4),IF(C39=\"Member/Spouse\",VLOOKUP(B39,K3:P21,5),IF(C39=\"Family\",VLOOKUP(B39,K3:P21,6),\" \"))))","v":" "},{"$f":"'Contribution Calculator'!M5","v":0},{"$f":"IF(C39=\"Single\",VLOOKUP(B39,K49:P56,3),IF(C39=\"Parent/Child(ren)\",VLOOKUP(B39,K49:P56,4),IF(C39=\"Member/Spouse\",VLOOKUP(B39,K49:P56,5),IF(C39=\"Family\",VLOOKUP(B39,K49:P56,6),\" \"))))","v":" "},{"$f":"IF(C39=\"Single\",VLOOKUP(B39,K62:P69,3),IF(C39=\"Parent/Child(ren)\",VLOOKUP(B39,K62:P69,4),IF(C39=\"Member/Spouse\",VLOOKUP(B39,K62:P69,5),IF(C39=\"Family\",VLOOKUP(B39,K62:P69,6),\" \"))))","v":" "},null,null,null,79999.990000000005,"$80,000 - $84,999.99",0.34,0.28000000000000003,0.24,null,null,null,{"$f":"A26","v":"Vision Plan 4"},1900,1400,900,400]
["Plan Name","Monthly Premium","Annual Contribution",null,"Annual Contribution","Per Payperiod","10 Month","12 Month",null,null,84999.99,"$85,000 - $89,999.99",0.34,0.3,0.26]
[{"$f":"A2","v":"SHIF Aetna Managed Choice POS $5 (High Plan)"},{"$f":"IFERROR(IF($E$35=\"Yes\",\"Not Available\",IF($E$35=\"No\",HLOOKUP($C$39,$E$2:$H$8,2),\" \")),\" \")","v":"Not Available"},{"$f":"IFERROR(SUM(B41*12)*$D$39,\" \")","v":" "},null,{"$f":"C41","v":" "},{"$f":"IF($E$39=10,G41,IF($E$39=12,H41,\" \"))","v":" "},{"$f":"IFERROR(E41/20,\" \")","v":" "},{"$f":"IFERROR(E41/24,\" \")","v":" "},null,null,89999.99,"$90,000 - $94,999.99",0.34,0.3,0.28000000000000003]
["SHIF Aetna Managed Choice POS $25(Low Plan)",{"$f":"IFERROR(IF($E$35=\"Yes\",\"Not Available\",IF($E$35=\"No\",HLOOKUP($C$39,$E$2:$H$8,3),\" \")),\" \")","v":"Not Available"},{"$f":"IFERROR(SUM(B42*12)*$D$39,\" \")","v":" "},null,{"$f":"C42","v":" "}," "," "," ",null,null,94999.99,"$95,000 - $99,999.99",0.35,0.3,0.28999999999999998]
["SHIF Aetna OAEC Savings Plus ",{"$f":"IFERROR(IF($E$35=\"Yes\",\"Not Available\",IF($E$35=\"No\",HLOOKUP($C$39,$E$2:$H$8,4),\" \")),\" \")","v":"Not Available"},{"$f":"IFERROR(SUM(B43*12)*$D$39,\" \")","v":" "},null,{"$f":"C43","v":" "}," "," "," ",null,null,99999.99,"$100,000 - $109,999.99",0.35,0.35,0.32]
["SHIF Aetna OAMC HSA",{"$f":"IFERROR(IF($E$35=\"Yes\",\"Not Available\",IF($E$35=\"No\",HLOOKUP($C$39,$E$2:$H$8,4),\" \")),\" \")","v":"Not Available"},{"$f":"IFERROR(SUM(B44*12)*$D$39,\" \")","v":" "},null,{"$f":"C44","v":" "}," "," "," ",null,null,109999.99,"$110,000 and over",0.35,0.35,0.35]
["SHIF Aetna NJEHP",{"$f":"IFERROR(HLOOKUP($C$39,$E$2:$H$8,6),\" \")","v":" "},{"$f":"IFERROR(IF(B45=\" \",\" \",SUM(B39*F39)),\" \")","v":" "},null,{"$f":"IF(B35=1,125000*F39,C45)","v":" "}," "," "," ",null,null,1000000]
["SHIF Aetna GSHP",{"$f":"IFERROR(HLOOKUP($C$39,$E$2:$H$8,7),\" \")","v":" "},{"$f":"IFERROR(IF(B46=\" \",\" \",SUM(B39*G39)),\" \")","v":" "},null,{"$f":"IF(B35=1,125000*G39,C46)","v":" "},{"$f":"IF($E$39=10,G46,IF($E$39=12,H46,\" \"))","v":" "},{"$f":"IFERROR(E46/20,\" \")","v":" "},{"$f":"IFERROR(E46/24,\" \")","v":" "},null,null,"Chapter 44 - NJEHP"]
["Medical Benefits Waived",{"$f":"IFERROR(HLOOKUP($C$39,$E$2:$H$9,8),\" \")","v":" "},{"$f":"IFERROR(SUM(B47*12)*$D$39,\" \")","v":" "},null,{"$f":"C47","v":" "},{"$f":"IF($E$39=10,G47,IF($E$39=12,H47,\" \"))","v":" "},null,null,null,null,null,"Salary","Single","Parent/Child(ren)","Member/Spouse","Family"]
["Rx Contributions",null,null,null,null,null,null,null,null,null,null,null,1.7000000000000001E-2,2.1999999999999999E-2,2.8000000000000001E-2,3.3000000000000002E-2]
["Rx Percentage",null,{"$f":"'Contribution Calculator'!G20","v":0},{"$f":"IF(C49=\"Single\",VLOOKUP(B39,K3:P21,3),IF(C49=\"Parent/Child(ren)\",VLOOKUP(B39,K3:P21,4),IF(C49=\"Member/Spouse\",VLOOKUP(B39,K3:P21,5),IF(C49=\"Family\",VLOOKUP(B39,K3:P21,6),\" \"))))","v":" "},{"$f":"'Contribution Calculator'!M5","v":0},null,null,null,null,null,0.01,"Up to 40,000",1.7000000000000001E-2,2.1999999999999999E-2,2.8000000000000001E-2,3.3000000000000002E-2]
[{"$f":"A12","v":"Aetna Dental Premier"},{"$f":"IFERROR(HLOOKUP($C$49,$E$12:$H$15,2),\" \")","v":" "},{"$f":"IFERROR(SUM(B50*12)*$D$49,\" \")","v":" "},null,{"$f":"C50","v":" "},{"$f":"IF($E$49=10,G50,IF($E$49=12,H50,\" \"))","v":" "},{"$f":"IFERROR(E50/20,\" \")","v":" "},{"$f":"IFERROR(E50/24,\" \")","v":" "},null,null,40000.99,"40001-50000",1.9E-2,2.5000000000000001E-2,3.3000000000000002E-2,3.9E-2]
[{"$f":"A13","v":"Aetna Dental Preferred"},{"$f":"IFERROR(HLOOKUP($C$49,$E$12:$H$15,3),\" \")","v":" "},{"$f":"IFERROR(SUM(B51*12)*$D$49,\" \")","v":" "},null," ",{"$f":"IF($E$39=10,G51,IF($E$39=12,H51,\" \"))","v":" "},{"$f":"IFERROR(E51/20,\" \")","v":" "},{"$f":"IFERROR(E51/24,\" \")","v":" "},null,null,50000.99,"50001-60000",2.1999999999999999E-2,2.8000000000000001E-2,3.9E-2,4.3999999999999997E-2]
[{"$f":"A14","v":"Aetna Dental DMO"},{"$f":"IFERROR(HLOOKUP($C$49,$E$12:$H$15,4),\" \")","v":" "},{"$f":"IFERROR(SUM(B52*12)*$D$49,\" \")","v":" "},null," ",{"$f":"IF($E$39=10,G52,IF($E$39=12,H52,\" \"))","v":" "},{"$f":"IFERROR(E52/20,\" \")","v":" "},{"$f":"IFERROR(E52/24,\" \")","v":" "},null,null,60000.99,"60001-70000",2.5000000000000001E-2,0.03,4.3999999999999997E-2,0.05]
[null,null,null,null,null,null,null,null,null,null,70000.990000000005,"70001-80000",2.8000000000000001E-2,3.3000000000000002E-2,0.05,5.5E-2]
["Dental Contributions",null,null,null,null,null,null,null,null,null,80000.990000000005,"80001-90000",0.03,3.5999999999999997E-2,5.5E-2,0.06]
["Dental Percentage",{"$f":"B39","v":25000},{"$f":"'Contribution Calculator'!G27","v":"Three + People"},{"$f":"IF(C55=\"One Person\",VLOOKUP(B39,K26:O44,3),IF(C55=\"Two People\",VLOOKUP(B39,K26:O44,4),IF(C55=\"Three + People\",VLOOKUP(B39,K26:O44,5),\" \")))","v":0.04},{"$f":"'Contribution Calculator'!M5","v":0},null,null,null,null,null,90000.99,"90001-100000",3.3000000000000002E-2,3.9E-2,0.06,6.6000000000000003E-2]
[{"$f":"A20","v":"Aetna Dental Premier"},{"$f":"IFERROR(HLOOKUP($C$55,$E$19:$G$23,2),\" \")","v":131.44999999999999},{"$f":"IFERROR(SUM(B56*12)*$D$55,\" \")","v":63.095999999999997},null,{"$f":"C56","v":63.095999999999997},{"$f":"IF($E$55=10,G56,IF($E$55=12,H56,\" \"))","v":" "},{"$f":"IFERROR(E56/20,\" \")","v":3.1547999999999998},{"$f":"IFERROR(E56/24,\" \")","v":2.629},null,null,100000.99,"100001-125000",3.5999999999999997E-2,4.3999999999999997E-2,6.6000000000000003E-2,7.1999999999999995E-2]
[{"$f":"A21","v":"Aetna Dental Preferred"},{"$f":"IFERROR(HLOOKUP($C$55,$E$19:$G$23,3),\" \")","v":110.85},{"$f":"IFERROR(SUM(B57*12)*$D$55,\" \")","v":53.207999999999991},null,{"$f":"C57","v":53.207999999999991},{"$f":"IF($E$39=10,G57,IF($E$39=12,H57,\" \"))","v":" "},{"$f":"IFERROR(E57/20,\" \")","v":2.6603999999999997},2.2169999999999996,null,null,100000000.98999999]
[{"$f":"A22","v":"Aetna Dental DMO"},{"$f":"IFERROR(HLOOKUP($C$55,$E$19:$G$23,4),\" \")","v":48.98},{"$f":"IFERROR(SUM(B58*12)*$D$55,\" \")","v":23.510400000000001},null,{"$f":"C58","v":23.510400000000001},{"$f":"IF($E$39=10,G58,IF($E$39=12,H58,\" \"))","v":" "},{"$f":"IFERROR(E58/20,\" \")","v":1.1755200000000001},0.97960000000000003]
[{"$f":"A23","v":"Waive Dental"},{"$f":"IFERROR(HLOOKUP($C$55,$E$19:$G$23,5),\" \")","v":0},{"$f":"IFERROR(SUM(B59*12)*$D$55,\" \")","v":0},null,{"$f":"C59","v":0},{"$f":"IF($E$39=10,G59,IF($E$39=12,H59,\" \"))","v":" "},{"$f":"IFERROR(E59/20,\" \")","v":0},0,null,null,"Chapter 44 - GSHP"]
[null,null,null,null,null,null,null,null,null,null,null,"Salary","Single","Parent/Child(ren)","Member/Spouse","Family"]
["Vision Contributions",null,null,null,null,null,null,null,null,null,null,null,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.6500000000000001E-2]
["Vision Percentage",{"$f":"B39","v":25000},{"$f":"'Contribution Calculator'!G27","v":"Three + People"},{"$f":"IF(C62=\"Single\",VLOOKUP(B39,K3:P21,3),IF(C62=\"Parent/Child(ren)\",VLOOKUP(B39,K3:P21,4),IF(C62=\"Member/Spouse\",VLOOKUP(B39,K3:P21,5),IF(C62=\"Family\",VLOOKUP(B39,K3:P21,6),\" \"))))","v":" "},{"$f":"E39","v":0},null,null,null,null,null,0.01,"Up to 40,000",1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.6500000000000001E-2]
[{"$f":"A23","v":"Waive Dental"},{"$f":"IFERROR(HLOOKUP($C$62,$S$35:$V$39,2),\" \")","v":" "},{"$f":"IFERROR(SUM(B63*12)*$D$62,\" \")","v":" "},{"$f":"IF($E$39=10,E63,IF($E$39=12,F63,\" \"))","v":" "},{"$f":"C63","v":" "},{"$f":"IF($E$55=10,G63,IF($E$55=12,H63,\" \"))","v":" "},{"$f":"IFERROR(E63/20,\" \")","v":" "},{"$f":"IFERROR(E63/24,\" \")","v":" "},null,null,40000.99,"40001-50000",1.4999999999999999E-2,1.4999999999999999E-2,1.6500000000000001E-2,1.95E-2]
[{"$f":"A24","v":"Aetna Vision (for POS Enrolled Only)"},{"$f":"IFERROR(HLOOKUP($C$62,$S$35:$V$39,3),\" \")","v":" "},{"$f":"IFERROR(SUM(B64*12)*$D$62,\" \")","v":" "},{"$f":"IF($E$39=10,E64,IF($E$39=12,F64,\" \"))","v":" "},{"$f":"C64","v":" "},{"$f":"IF($E$39=10,G64,IF($E$39=12,H64,\" \"))","v":" "},{"$f":"IFERROR(E64/20,\" \")","v":" "},{"$f":"IFERROR(E64/24,\" \")","v":" "},null,null,50000.99,"50001-60000",1.4999999999999999E-2,1.4999999999999999E-2,1.95E-2,2.1999999999999999E-2]
[{"$f":"A25","v":"Vision Plan 3"},{"$f":"IFERROR(HLOOKUP($C$62,$S$35:$V$39,4),\" \")","v":" "},{"$f":"IFERROR(SUM(B65*12)*$D$62,\" \")","v":" "},{"$f":"IF($E$39=10,E65,IF($E$39=12,F65,\" \"))","v":" "},{"$f":"C65","v":" "},{"$f":"IF($E$39=10,G65,IF($E$39=12,H65,\" \"))","v":" "},{"$f":"IFERROR(E65/20,\" \")","v":" "}," ",null,null,60000.99,"60001-70000",1.4999999999999999E-2,1.4999999999999999E-2,2.1999999999999999E-2,2.5000000000000001E-2]
[{"$f":"A26","v":"Vision Plan 4"},{"$f":"IFERROR(HLOOKUP($C$62,$S$35:$V$39,5),\" \")","v":" "},{"$f":"IFERROR(SUM(B66*12)*$D$62,\" \")","v":" "},{"$f":"IF($E$39=10,E66,IF($E$39=12,F66,\" \"))","v":" "},{"$f":"C66","v":" "},{"$f":"IF($E$39=10,G66,IF($E$39=12,H66,\" \"))","v":" "},{"$f":"IFERROR(E66/20,\" \")","v":" "}," ",null,null,70000.990000000005,"70001-80000",1.4999999999999999E-2,1.6500000000000001E-2,2.5000000000000001E-2,2.75E-2]
[null,null,null,null,null,null,null,null,null,null,80000.990000000005,"80001-90000",1.4999999999999999E-2,1.7999999999999999E-2,2.75E-2,0.03]
["Per Paycheck Total",null,{"$f":"IFERROR(SUM(C69+C77+C82),0)","v":0},null,null,null,null,null,null,null,90000.99,"90001-100000",1.6500000000000001E-2,1.95E-2,0.03,3.3000000000000002E-2]
["Medical Plan Selection Indicator",0,{"$f":"IFERROR(VLOOKUP(B69,B70:C76,2),0)","v":0},null,null,null,null,null,null,null,100000.99,"100001-125000",1.6500000000000001E-2,2.1999999999999999E-2,3.3000000000000002E-2,3.5999999999999997E-2]
[{"$f":"A2","v":"SHIF Aetna Managed Choice POS $5 (High Plan)"},1,{"$f":"IF('Contribution Calculator'!K12=\" \",0,'Contribution Calculator'!K12)","v":0},null,null,null,null,null,null,null,100000000.98999999]
["SHIF Aetna Managed Choice POS $25(Low Plan)",2,{"$f":"IF('Contribution Calculator'!K13=\" \",0,'Contribution Calculator'!K13)","v":0}]
["SHIF Aetna OAEC Savings Plus ",3,{"$f":"IF('Contribution Calculator'!K14=\" \",0,'Contribution Calculator'!K14)","v":0}]
["SHIF Aetna OAMC HSA",4,{"$f":"IF('Contribution Calculator'!K15=\" \",0,'Contribution Calculator'!K15)","v":0}]
["SHIF Aetna NJEHP",5,{"$f":"IF('Contribution Calculator'!K16=\" \",0,'Contribution Calculator'!K16)","v":0}]
["SHIF Aetna GSHP",6,{"$f":"IF('Contribution Calculator'!K17=\" \",0,'Contribution Calculator'!K17)","v":0}]
["Medical Benefits Waived",7,{"$f":"IF('Contribution Calculator'!K18=\" \",0,'Contribution Calculator'!K18)","v":0}]
["Rx Plan Selection Indicator",1,{"$f":"IFERROR(VLOOKUP(B77,B78:C80,2),0)","v":0}]
[{"$f":"A12","v":"Aetna Dental Premier"},1,{"$f":"IF('Contribution Calculator'!K23=\" \",0,'Contribution Calculator'!K23)","v":0}]
[{"$f":"A13","v":"Aetna Dental Preferred"},2,{"$f":"IF('Contribution Calculator'!K24=\" \",0,'Contribution Calculator'!K24)","v":0}]
[{"$f":"A14","v":"Aetna Dental DMO"},3,{"$f":"IF('Contribution Calculator'!K25=\" \",0,'Contribution Calculator'!K25)","v":0}]
[null,1]
["Dental Plan Selection Indicator",1,{"$f":"IFERROR(VLOOKUP(B82,B83:C86,2),0)","v":0}]
[{"$f":"A20","v":"Aetna Dental Premier"},1,{"$f":"IF('Contribution Calculator'!K30=\" \",0,'Contribution Calculator'!K30)","v":0}]
[{"$f":"A21","v":"Aetna Dental Preferred"},2,{"$f":"IF('Contribution Calculator'!K31=\" \",0,'Contribution Calculator'!K31)","v":0}]
[{"$f":"A22","v":"Aetna Dental DMO"},3,{"$f":"IF('Contribution Calculator'!K32=\" \",0,'Contribution Calculator'!K32)","v":0}]
[{"$f":"A23","v":"Waive Dental"},4,{"$f":"IF('Contribution Calculator'!K33=\" \",0,'Contribution Calculator'!K33)","v":0}]
[]
[]
["Vision",2,{"$f":"IFERROR(VLOOKUP(B89,B90:C93,2),0)","v":0}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},1,{"$f":"'Contribution Calculator'!K30","v":" "}]
[{"$f":"A34","v":0},2,{"$f":"'Contribution Calculator'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"A35","v":"Benefit Surcharge Indicator"},3,{"$f":"'Contribution Calculator'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"A36","v":0},4,{"$f":"'Contribution Calculator'!#REF!","v":{"$error":"#REF!"}}]