{"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":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,1,34,9],[18,1,19,1],[4,1,5,1],[1,1,1,9],[18,2,18,5],[18,6,18,9],[5,4,5,5],[5,6,5,7],[5,8,5,9],[19,2,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,9],[4,6,4,9],[4,2,4,5],[5,2,5,3]]}
[]
[null,"Healthcare Payroll Contribution Calculator"]
[null,"Enter Annual Salary:",40000,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-10-18"}]
[]
[null,2020,"FACULTY/STAFF",null,null,null,"TECH SERVICE"]
[null,null,"PPO Savings Plan",null,"PPO Plan",null,"PPO Savings Plan",null,"PPO Plan"]
[null,"Rates","%","Annual$","%","Annual$","%","Annual$","%","Annual$"]
[null,"E (Individual)",7.7999999999999996E-3,{"$f":"+$F$37*$C8","v":312},1.5100000000000001E-2,{"$f":"+$F$37*$E8","v":604},1.41E-2,{"$f":"+$F$37*$G8","v":564},2.8799999999999999E-2,{"$f":"+$F$37*$I8","v":1152}]
[null,"S (Two Person)",1.89E-2,{"$f":"+$F$37*$C9","v":756},3.6799999999999999E-2,{"$f":"+$F$37*$E9","v":1472},3.0499999999999999E-2,{"$f":"+$F$37*$G9","v":1220},6.2100000000000002E-2,{"$f":"+$F$37*$I9","v":2484}]
[null,"C (Parent Child)",1.7500000000000002E-2,{"$f":"+$F$37*$C10","v":700.00000000000011},3.4099999999999998E-2,{"$f":"+$F$37*$E10","v":1364},2.8400000000000002E-2,{"$f":"+$F$37*$G10","v":1136},5.8000000000000003E-2,{"$f":"+$F$37*$I10","v":2320}]
[null,"D (Family)",2.41E-2,{"$f":"+$F$37*$C11","v":964},4.6899999999999997E-2,{"$f":"+$F$37*$E11","v":1876},3.8199999999999998E-2,{"$f":"+$F$37*$G11","v":1528},7.7899999999999997E-2,{"$f":"+$F$37*$I11","v":3116}]
[]
[null,"Per Pay Deduction","Monthly","Biweekly","Monthly","Biweekly","Monthly","Biweekly","Monthly","Biweekly"]
[null,"E (Individual)",{"$f":"+$D8/12","v":26},{"$f":"+$D8/26","v":12},{"$f":"+$F8/12","v":50.333333333333336},{"$f":"+$F8/26","v":23.23076923076923},{"$f":"+$H8/12","v":47},{"$f":"+$H8/26","v":21.692307692307693},{"$f":"+$J8/12","v":96},{"$f":"+$J8/26","v":44.307692307692307}]
[null,"S (Two Person)",{"$f":"+$D9/12","v":63},{"$f":"+$D9/26","v":29.076923076923077},{"$f":"+$F9/12","v":122.66666666666667},{"$f":"+$F9/26","v":56.615384615384613},{"$f":"+$H9/12","v":101.66666666666667},{"$f":"+$H9/26","v":46.92307692307692},{"$f":"+$J9/12","v":207},{"$f":"+$J9/26","v":95.538461538461533}]
[null,"C (Parent Child)",{"$f":"+$D10/12","v":58.333333333333343},{"$f":"+$D10/26","v":26.923076923076927},{"$f":"+$F10/12","v":113.66666666666667},{"$f":"+$F10/26","v":52.46153846153846},{"$f":"+$H10/12","v":94.666666666666671},{"$f":"+$H10/26","v":43.692307692307693},{"$f":"+$J10/12","v":193.33333333333334},{"$f":"+$J10/26","v":89.230769230769226}]
[null,"D (Family)",{"$f":"+$D11/12","v":80.333333333333329},{"$f":"+$D11/26","v":37.07692307692308},{"$f":"+$F11/12","v":156.33333333333334},{"$f":"+$F11/26","v":72.15384615384616},{"$f":"+$H11/12","v":127.33333333333333},{"$f":"+$H11/26","v":58.769230769230766},{"$f":"+$J11/12","v":259.66666666666669},{"$f":"+$J11/26","v":119.84615384615384}]
[]
[null,2019,"FACULTY/STAFF",null,null,null,"TECH SERVICE"]
[null,null,"PPO Savings Plan",null,"PPO Plan",null,"PPO Savings Plan",null,"PPO Plan"]
[null,null,"%","Annual$","%","Annual$","%","Annual$","%","Annual$"]
[null,null,7.7999999999999996E-3,{"$f":"+$F$37*$C22","v":312},1.5100000000000001E-2,{"$f":"+$F$37*$E22","v":604},1.3100000000000001E-2,{"$f":"+$F$37*$G22","v":524},2.7099999999999999E-2,{"$f":"+$F$37*$I22","v":1084}]
[null,null,1.89E-2,{"$f":"+$F$37*$C23","v":756},3.6799999999999999E-2,{"$f":"+$F$37*$E23","v":1472},2.6200000000000001E-2,{"$f":"+$F$37*$G23","v":1048},5.8599999999999999E-2,{"$f":"+$F$37*$I23","v":2344}]
[null,null,1.7500000000000002E-2,{"$f":"+$F$37*$C24","v":700.00000000000011},3.4099999999999998E-2,{"$f":"+$F$37*$E24","v":1364},2.46E-2,{"$f":"+$F$37*$G24","v":984},5.4699999999999999E-2,{"$f":"+$F$37*$I24","v":2188}]
[null,null,2.41E-2,{"$f":"+$F$37*$C25","v":964},4.6899999999999997E-2,{"$f":"+$F$37*$E25","v":1876},3.2399999999999998E-2,{"$f":"+$F$37*$G25","v":1296},7.3499999999999996E-2,{"$f":"+$F$37*$I25","v":2940}]
[]
[null,"Per Pay Deduction","Monthly","Biweekly","Monthly","Biweekly","Monthly","Biweekly","Monthly","Biweekly"]
[null,"E (Individual)",{"$f":"+$D22/12","v":26},{"$f":"+$D22/26","v":12},{"$f":"+$F22/12","v":50.333333333333336},{"$f":"+$F22/26","v":23.23076923076923},{"$f":"+$H22/12","v":43.666666666666664},{"$f":"+$H22/26","v":20.153846153846153},{"$f":"+$J22/12","v":90.333333333333329},{"$f":"+$J22/26","v":41.692307692307693}]
[null,"S (Two Person)",{"$f":"+$D23/12","v":63},{"$f":"+$D23/26","v":29.076923076923077},{"$f":"+$F23/12","v":122.66666666666667},{"$f":"+$F23/26","v":56.615384615384613},{"$f":"+$H23/12","v":87.333333333333329},{"$f":"+$H23/26","v":40.307692307692307},{"$f":"+$J23/12","v":195.33333333333334},{"$f":"+$J23/26","v":90.15384615384616}]
[null,"C (Parent Child)",{"$f":"+$D24/12","v":58.333333333333343},{"$f":"+$D24/26","v":26.923076923076927},{"$f":"+$F24/12","v":113.66666666666667},{"$f":"+$F24/26","v":52.46153846153846},{"$f":"+$H24/12","v":82},{"$f":"+$H24/26","v":37.846153846153847},{"$f":"+$J24/12","v":182.33333333333334},84.15384615384616]
[null,"D (Family)",{"$f":"+$D25/12","v":80.333333333333329},{"$f":"+$D25/26","v":37.07692307692308},{"$f":"+$F25/12","v":156.33333333333334},{"$f":"+$F25/26","v":72.15384615384616},{"$f":"+$H25/12","v":108},{"$f":"+$H25/26","v":49.846153846153847},{"$f":"+$J25/12","v":245},113.07692307692308]
[]
[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,"Premium Salary:",{"$f":"IF(C3<140000,+C3,140000)","v":40000}]