{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["HC Payroll Calculator"],"not_rendered":{"charts":0,"images":0,"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":"HC Payroll Calculator","index":0,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[33,1,35,9],[18,1,19,1],[1,1,1,9],[19,4,19,5],[19,6,19,7],[19,8,19,9],[18,6,18,9],[18,2,18,5],[19,2,19,3],[4,1,5,1],[4,2,4,5],[4,6,4,9],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9]]}
[]
[null,"Healthcare Payroll Contribution Calculator"]
[null,"Enter Annual Salary:",30000,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-10-07"}]
[]
[null,2025,"FACULTY/STAFF",null,null,null,"TECH SERVICE"]
[null,null,"Lion Advantage HSA\nLion Advantage Flex",null,"Lion Traditional",null,"Lion Advantage",null,"Lion Traditional"]
[null,"Rates","%","Annual$","%","Annual$","%","Annual$","%","Annual$"]
[null,"E (Individual)",9.1000000000000004E-3,{"$f":"+$F$38*$C8","v":273},1.7399999999999999E-2,{"$f":"+$F$38*$E8","v":522},2.1000000000000001E-2,{"$f":"+$F$38*$G8","v":630},3.5099999999999999E-2,{"$f":"+$F$38*$I8","v":1053}]
[null,"S (Two Person)",2.1899999999999999E-2,{"$f":"+$F$38*$C9","v":657},4.2599999999999999E-2,{"$f":"+$F$38*$E9","v":1278},4.2000000000000003E-2,{"$f":"+$F$38*$G9","v":1260},7.0199999999999999E-2,{"$f":"+$F$38*$I9","v":2106}]
[null,"C (Parent Child)",2.0299999999999999E-2,{"$f":"+$F$38*$C10","v":609},3.95E-2,{"$f":"+$F$38*$E10","v":1185},3.8899999999999997E-2,{"$f":"+$F$38*$G10","v":1167},6.4899999999999999E-2,{"$f":"+$F$38*$I10","v":1947}]
[null,"D (Family)",2.7900000000000001E-2,{"$f":"+$F$38*$C11","v":837},5.4199999999999998E-2,{"$f":"+$F$38*$E11","v":1626},5.2499999999999998E-2,{"$f":"+$F$38*$G11","v":1575},8.7800000000000003E-2,{"$f":"+$F$38*$I11","v":2634}]
[]
[null,"Per Pay Deduction","Monthly","Biweekly","Monthly","Biweekly","Monthly","Biweekly","Monthly","Biweekly"]
[null,"E (Individual)",{"$f":"+$D8/12","v":22.75},{"$f":"+$D8/26","v":10.5},{"$f":"+$F8/12","v":43.5},{"$f":"+$F8/26","v":20.076923076923077},{"$f":"+$H8/12","v":52.5},{"$f":"+$H8/26","v":24.23076923076923},{"$f":"+$J8/12","v":87.75},{"$f":"+$J8/26","v":40.5}]
[null,"S (Two Person)",{"$f":"+$D9/12","v":54.75},{"$f":"+$D9/26","v":25.26923076923077},{"$f":"+$F9/12","v":106.5},{"$f":"+$F9/26","v":49.153846153846153},{"$f":"+$H9/12","v":105},{"$f":"+$H9/26","v":48.46153846153846},{"$f":"+$J9/12","v":175.5},{"$f":"+$J9/26","v":81}]
[null,"C (Parent Child)",{"$f":"+$D10/12","v":50.75},{"$f":"+$D10/26","v":23.423076923076923},{"$f":"+$F10/12","v":98.75},{"$f":"+$F10/26","v":45.57692307692308},{"$f":"+$H10/12","v":97.25},{"$f":"+$H10/26","v":44.884615384615387},{"$f":"+$J10/12","v":162.25},{"$f":"+$J10/26","v":74.884615384615387}]
[null,"D (Family)",{"$f":"+$D11/12","v":69.75},{"$f":"+$D11/26","v":32.192307692307693},{"$f":"+$F11/12","v":135.5},{"$f":"+$F11/26","v":62.53846153846154},{"$f":"+$H11/12","v":131.25},{"$f":"+$H11/26","v":60.57692307692308},{"$f":"+$J11/12","v":219.5},{"$f":"+$J11/26","v":101.30769230769231}]
[]
[null,2024,"FACULTY/STAFF",null,null,null,"TECH SERVICE"]
[null,null,"Lion Advantage",null,"Lion Traditional",null,"Lion Advantage",null,"Lion Traditional"]
[null,"Rates","%","Annual$","%","Annual$","%","Annual$","%","Annual$"]
[null,"E (Individual)",8.0000000000000002E-3,{"$f":"+$F$39*$C22","v":240},1.54E-2,{"$f":"+$F$39*$E22","v":462},1.4500000000000001E-2,{"$f":"+$F$39*$G22","v":435},2.9700000000000001E-2,{"$f":"+$F$39*$I22","v":891}]
[null,"S (Two Person)",1.9300000000000001E-2,{"$f":"+$F$39*$C23","v":579},3.7600000000000001E-2,{"$f":"+$F$39*$E23","v":1128},3.1399999999999997E-2,{"$f":"+$F$39*$G23","v":941.99999999999989},6.4000000000000001E-2,{"$f":"+$F$39*$I23","v":1920}]
[null,"C (Parent Child)",1.7899999999999999E-2,{"$f":"+$F$39*$C24","v":537},3.49E-2,{"$f":"+$F$39*$E24","v":1047},2.93E-2,{"$f":"+$F$39*$G24","v":879},5.9799999999999999E-2,{"$f":"+$F$39*$I24","v":1794}]
[null,"D (Family)",2.46E-2,{"$f":"+$F$39*$C25","v":738},4.7899999999999998E-2,{"$f":"+$F$39*$E25","v":1437},3.9399999999999998E-2,{"$f":"+$F$39*$G25","v":1182},8.0299999999999996E-2,{"$f":"+$F$39*$I25","v":2409}]
[]
[null,"Per Pay Deduction","Monthly","Biweekly","Monthly","Biweekly","Monthly","Biweekly","Monthly","Biweekly"]
[null,"E (Individual)",{"$f":"+$D22/12","v":20},{"$f":"+$D22/26","v":9.2307692307692299},{"$f":"+$F22/12","v":38.5},{"$f":"+$F22/26","v":17.76923076923077},{"$f":"+$H22/12","v":36.25},{"$f":"+$H22/26","v":16.73076923076923},{"$f":"+$J22/12","v":74.25},{"$f":"+$J22/26","v":34.269230769230766}]
[null,"S (Two Person)",{"$f":"+$D23/12","v":48.25},{"$f":"+$D23/26","v":22.26923076923077},{"$f":"+$F23/12","v":94},{"$f":"+$F23/26","v":43.384615384615387},{"$f":"+$H23/12","v":78.499999999999986},{"$f":"+$H23/26","v":36.230769230769226},{"$f":"+$J23/12","v":160},{"$f":"+$J23/26","v":73.84615384615384}]
[null,"C (Parent Child)",{"$f":"+$D24/12","v":44.75},{"$f":"+$D24/26","v":20.653846153846153},{"$f":"+$F24/12","v":87.25},{"$f":"+$F24/26","v":40.269230769230766},{"$f":"+$H24/12","v":73.25},{"$f":"+$H24/26","v":33.807692307692307},{"$f":"+$J24/12","v":149.5},{"$f":"+$J24/26","v":69}]
[null,"D (Family)",{"$f":"+$D25/12","v":61.5},{"$f":"+$D25/26","v":28.384615384615383},{"$f":"+$F25/12","v":119.75},{"$f":"+$F25/26","v":55.269230769230766},{"$f":"+$H25/12","v":98.5},{"$f":"+$H25/26","v":45.46153846153846},{"$f":"+$J25/12","v":200.75},{"$f":"+$J25/26","v":92.65384615384616}]
[]
[]
[null,"PLEASE NOTE:  This calculator is intended to show an estimated pay period deduction for the different coverage types. The information contained in this calculator was taken from various sources. While every effort was taken to accurately report deductions for the benefits you selected, discrepancies or errors are possible. In the case of a discrepancy between this summary and the amounts deducted from your paycheck, the paycheck deductions for your contributions will prevail."]
[]
[]
[]
[null,null,null,null,"2024Premium Salary:",{"$f":"IF(C3<200000,+C3,200000)","v":30000}]
[null,null,null,null,"2025Premium Salary:",{"$f":"IF(C3<200000,+C3,200000)","v":30000}]