{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["MISSION DEDUCTIONS CROSSWALK","WT Plans, Class, Tier","Rates (eff 7-1-2017)","C Suite Codes"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":1,"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":"MISSION DEDUCTIONS CROSSWALK","index":0,"n_rows":83,"n_cols":11,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["NOTE","MNEMONIC","DESCRIPTION","DED PAY \nCODE W#","Plans in WORKTERRA","Class2","Coverage Tier","Standard or \nVariable rate","Smoker","Notes","Payroll Audit Excel .xls file"]
["Post Tax","LTD","LONG TERM DISABILITY",130,"LTD 60% to $10k\nVoluntary LTD 60%","Csuite\nFull Time Employees\nPart Time Employees","Employee Only","Variable"]
["Post Tax","SUPPLIFE"," SUPP EMPLOYEE LIFE",131,"Supplemental Employee Life\nSupplemental Employee Life (80+)","Csuite\nFull Time Employees\nPart Time Employees","Employee Only","Variable"]
["Post Tax","CHLDLIFE"," SUPP CHILD LIFE",132,"Child Life","Csuite\nFull Time Employees\nPart Time Employees","Child Only","Variable"]
["Post Tax","SPSLIFE","SUPP SPOUSE LIFE",133,"Spouse Life","Csuite\nFull Time Employees\nPart Time Employees","Spouse Only","Variable"]
["Post Tax","STD","SHORT TERM DISABILITY",135,"Voluntary STD 60%","Full Time Employees\nPart Time Employees","Employee Only","Variable"]
["Post Tax","METLAW","METLAW LEGAL",235,"Hyatt Legal Plan","Csuite\nFull Time Employees\nPart Time Employees","Employee Only","Variable",null,"Employee Only"]
["Pre Tax","DCF","DEPENDENT CARE FLEX ","005.1","2017 Dependent Care Spending Account","Csuite\nFull Time Employees\nPart Time Employees","Employee Only","Variable",null,"Employee Only"]
["Pre Tax","HCF","HEALTH CARE FLEX","005.2","2017 Healthcare Spending Account","Csuite\nFull Time Employees\nPart Time Employees","Employee Only","Variable",null,"Employee Only"]
["Pre Tax","EPOFTEE","EPO FT EMP ","006.1","EPO Plan\nEPOPlan","Full Time Employees","Employee Only","Standard"]
["Pre Tax","EPOFTSP","EPO FT E+SPOUSE","006.2","EPO Plan\nEPOPlan","Full Time Employees","Employee + Spouse","Standard"]
["Pre Tax","EPOFTCH","EPO FT E+CHILD(S)","006.3","EPO Plan\nEPOPlan","Full Time Employees","Employee + Child(ren)","Standard"]
["Pre Tax","EPOFTFM","EPO FT E+FAMILY","006.4","EPO Plan\nEPOPlan","Full Time Employees","Employee + Family","Standard"]
["Pre Tax","EPOPTEE","EPO PT EMP ","006.13","EPO Plan\nEPOPlan","Part Time Employees","Employee Only","Standard"]
["Pre Tax","EPOPTSP","EPO PT E+SPOUSE","006.14","EPO Plan\nEPOPlan","Part Time Employees","Employee + Spouse","Standard"]
["Pre Tax","EPOPTCH","EPO PT E+CHILD(S)","006.15","EPO Plan\nEPOPlan","Part Time Employees","Employee + Child(ren)","Standard"]
["Pre Tax","EPOPTFM","EPO PT E+FAMILY","006.16","EPO Plan\nEPOPlan","Part Time Employees","Employee + Family","Standard"]
["Pre Tax","EPOSFTEE","EPOS FT EMP ","006.5","EPO Plan\nEPOPlan","Full Time Employees","Employee Only","Standard","Smoker"]
["Pre Tax","EPOSFTSP","EPOS FT E+SPOUSE","006.6","EPO Plan\nEPOPlan","Full Time Employees","Employee + Spouse","Standard","Smoker"]
["Pre Tax","EPOSFTCH","EPOS FT E+CHILD(S)","006.7","EPO Plan\nEPOPlan","Full Time Employees","Employee + Child(ren)","Standard","Smoker"]
["Pre Tax","EPOSFTFM","EPOS FT E+FAMILY","006.8","EPO Plan\nEPOPlan","Full Time Employees","Employee + Family","Standard","Smoker"]
["Pre Tax","EPOSPTEE","EPOS PT EMP ","006.17","EPO Plan\nEPOPlan","Part Time Employees","Employee Only","Standard","Smoker"]
["Pre Tax","EPOSPTSP","EPOS PT E+SPOUSE","006.18","EPO Plan\nEPOPlan","Part Time Employees","Employee + Spouse","Standard","Smoker"]
["Pre Tax","EPOSPTCH","EPOS PT E+CHILD(S)","006.19","EPO Plan\nEPOPlan","Part Time Employees","Employee + Child(ren)","Standard","Smoker"]
["Pre Tax","EPOSPTFM","EPOS PT E+FAMILY","006.20","EPO Plan\nEPOPlan","Part Time Employees","Employee + Family","Standard","Smoker"]
["Pre Tax","VPFPPDEE","VALUE PLAN EMP ONLY","006.9","Value Plan\nValuePlan","Full Time Employees\nPart Time Employees\nPer Diems","Employee Only","Standard"]
["Pre Tax","VPFPPDSP","VALUE PLAN EMP&SPOUSE","006.10","Value Plan\nValuePlan","Full Time Employees\nPart Time Employees\nPer Diems","Employee + Spouse","Standard"]
["Pre Tax","VPFPPDCH","VALUE PLAN EMP&CHILD","006.11","Value Plan\nValuePlan","Full Time Employees\nPart Time Employees\nPer Diems","Employee + Child(ren)","Standard"]
["Pre Tax","VPFPPDFM","VALUE PLAN EMP&FAMILY","006.12","Value Plan\nValuePlan","Full Time Employees\nPart Time Employees\nPer Diems","Employee + Family","Standard"]
["Pre Tax","DPPOHEE","DNTL PPO HIGH EMP","020.1","Delta Dental PPO High Plan","Full Time Employees\nPart Time Employees","Employee Only","Standard"]
["Pre Tax","DPPOHES","DNTL PPO HIGH E+SPOUSE","020.2","Delta Dental PPO High Plan","Full Time Employees\nPart Time Employees","Employee + Spouse","Standard"]
["Pre Tax","DPPOHEC","DNTL PPO HIGH E+CHILD(S)","020.3","Delta Dental PPO High Plan","Full Time Employees\nPart Time Employees","Employee + Child(ren)","Standard"]
["Pre Tax","DPPOHEF","DNTL PPO HIGH E+FAMILY","020.4","Delta Dental PPO High Plan","Full Time Employees\nPart Time Employees","Employee + Family","Standard"]
["Pre Tax","DPPOLEE","DNTL PPO LOW EMP","020.5","Delta Dental PPO Low Plan","Full Time Employees\nPart Time Employees","Employee Only","Standard"]
["Pre Tax","DPPOLES","DNTL PPO LOW E+SPOUSE","020.6","Delta Dental PPO Low Plan","Full Time Employees\nPart Time Employees","Employee + Spouse","Standard"]
["Pre Tax","DPPOLEC","DNTL PPO LOW E+CHILD(S)","020.7","Delta Dental PPO Low Plan","Full Time Employees\nPart Time Employees","Employee + Child(ren)","Standard"]
["Pre Tax","DPPOLEF","DNTL PPO LOW E+FAMILY","020.8","Delta Dental PPO Low Plan","Full Time Employees\nPart Time Employees","Employee + Family","Standard"]
["Pre Tax","VSPBEE","VSP B EMP","060.1","Vision Plan B - Basic Plan","Full Time Employees\nPart Time Employees","Employee Only","Standard"]
["Pre Tax","VSPBES","VSP B E+SPOUSE","060.2","Vision Plan B - Basic Plan","Full Time Employees\nPart Time Employees","Employee + Spouse","Standard"]
["Pre Tax","VSPBEC","VSP B E+CHILD(S)","060.3","Vision Plan B - Basic Plan","Full Time Employees\nPart Time Employees","Employee + Child(ren)","Standard"]
["Pre Tax","VSPBEF","VSP B E+FAMILY","060.4","Vision Plan B - Basic Plan","Full Time Employees\nPart Time Employees","Employee + Family","Standard"]
["Pre Tax","VSPCEE","VSP C EMP","060.5","Vision Plan C- Premium Plan","Full Time Employees\nPart Time Employees","Employee Only","Standard"]
["Pre Tax","VSPCES","VSP C E+SPOUSE","060.6","Vision Plan C- Premium Plan","Full Time Employees\nPart Time Employees","Employee + Spouse","Standard"]
["Pre Tax","VSPCEC","VSP C E+CHILD(S)","060.7","Vision Plan C- Premium Plan","Full Time Employees\nPart Time Employees","Employee + Child(ren)","Standard"]
["Pre Tax","VSPCEF","VSP C E+FAMILY","060.8","Vision Plan C- Premium Plan","Full Time Employees\nPart Time Employees","Employee + Family","Standard"]
["Pre Tax","EPOCEE","EPOCEE","006.21","EPO Plan\nEPOPlan","Csuite","Employee Only","Standard"]
["Pre Tax","EPOCE+SP","EPOCE+SP","006.22","EPO Plan\nEPOPlan","Csuite","Employee + Spouse","Standard"]
["Pre Tax","EPOCE+CH","EPOCE+CH","006.23","EPO Plan\nEPOPlan","Csuite","Employee + Child(ren)","Standard"]
["Pre Tax","EPOCE+FM","EPOCE+FM","006.24","EPO Plan\nEPOPlan","Csuite","Employee + Family","Standard"]
["Pre Tax","EPOCVEE","EPOCVEE","006.29","Value Plan\nValuePlan","Csuite","Employee Only","Standard"]
["Pre Tax","EPOCVESP","EPOCVE+SP","006.30","Value Plan\nValuePlan","Csuite","Employee + Spouse","Standard"]
["Pre Tax","EPOCVECH","EPOCVE+CH","006.31","Value Plan\nValuePlan","Csuite","Employee + Child(ren)","Standard"]
["Pre Tax","EPOCVEFM","EPOCVE+FM","006.32","Value Plan\nValuePlan","Csuite","Employee + Family","Standard"]
["Pre Tax","DPPOHCEE","DPPOHCEE","020.9","Delta Dental PPO High Plan","Csuite","Employee Only","Standard"]
["Pre Tax","DPPOHCES","DPPOHCE+SP","020.10","Delta Dental PPO High Plan","Csuite","Employee + Spouse","Standard"]
["Pre Tax","DPPOHCEC","DPPOHCE+CH","020.11","Delta Dental PPO High Plan","Csuite","Employee + Child(ren)","Standard"]
["Pre Tax","DPPOHCEF","DPPOHCE+FM","020.12","Delta Dental PPO High Plan","Csuite","Employee + Family","Standard"]
["Pre Tax","DPPOLCEE","DPPOLCEE","020.13","Delta Dental PPO Low Plan","Csuite","Employee Only","Standard"]
["Pre Tax","DPPOLCES","DPPOLCE+SP","020.14","Delta Dental PPO Low Plan","Csuite","Employee + Spouse","Standard"]
["Pre Tax","DPPOLCEC","DPPOLCE+CH","020.15","Delta Dental PPO Low Plan","Csuite","Employee + Child(ren)","Standard"]
["Pre Tax","DPPOLCEF","DPPOLCE+FM","020.16","Delta Dental PPO Low Plan","Csuite","Employee + Family","Standard"]
["Pre Tax","VSPBCEE","VSPBCEE","020.17","Vision Plan B - Basic Plan","Csuite","Employee Only","Standard"]
["Pre Tax","VSPBCES","VSPBCE+SP","020.18","Vision Plan B - Basic Plan","Csuite","Employee + Spouse","Standard"]
["Pre Tax","VSPBCEC","VSPBCE+CH","020.19","Vision Plan B - Basic Plan","Csuite","Employee + Child(ren)","Standard"]
["Pre Tax","VSPBCEF","VSPBCE+FM","020.20","Vision Plan B - Basic Plan","Csuite","Employee + Family","Standard"]
["Pre Tax","VSPCCEE","VSPCCEE","020.21","Vision Plan C- Premium Plan","Csuite","Employee Only","Standard"]
["Pre Tax","VSPCCES","VSPCCE+SP","020.22","Vision Plan C- Premium Plan","Csuite","Employee + Spouse","Standard"]
["Pre Tax","VSPCCEC","VSPCCE+CH","020.23","Vision Plan C- Premium Plan","Csuite","Employee + Child(ren)","Standard"]
["Pre Tax","VSPCCEF","VSPCCE+FM","020.24","Vision Plan C- Premium Plan","Csuite","Employee + Family","Standard"]
["EARNING CODE","OPTOUT","MEDICAL OPTOUT",1.155,"Waive Medical Opt Out","Csuite\nFull Time Employees\nPart Time Employees","Employee Only","Standard",null,"do not map","Map on this file"]
["Post Tax","EAPER","EAP EMPLOYER",300,"Employee Assistance Program","Full Time Employees\nPart Time Employees\nCsuite","Employee Only","Variable",null,"do not map","Map on this file"]
["Post Tax","BSCLF","BASIC LIFE",136,"Basic Life 1x Salary Up to $50k\nBasic Life AD&D 1x Salary -Benefit exceeding $50000 is subject to tax\nBasic Life AD&D Flat $500000 - Benefit exceeding $50000 is subject to tax\nBasic Life Flat 50k","Full Time Employees","Employee Only","Variable",null,"do not map","Map on this file"]
[null,"Waive","Medical Waive","n/a","Waive Medical","Csuite\nFull Time Employees\nPart Time Employees","Employee Only","Standard",null,"do not use","do not use"]
["Post Tax","S AD&D","SPOUSE AD&D",134,"plan not built",null,null,null,null,"do not use"]
["Post Tax","TMKUL","TRUSTMARK UNIVERSAL LIFE",236,"plan not built",null,null,null,null,"do not use"]
["Post Tax","TMKBO","TMK CILL&CANCER",231,"plan not built",null,null,null,null,"do not use"]
["Post Tax","TMKCA","TMK CANCER ",232,"plan not built",null,null,null,null,"do not use"]
["Post Tax","TMKIDI","TRUSTMARK STD",233,"plan not built",null,null,null,null,"do not use"]
["Post Tax","TMKACC","TRMK ACCIDENT",234,"plan not built",null,null,null,null,"do not use"]
["Pre Tax","EPOCSEE","EPOCSEE","006.25","plan not built","Csuite","Employee Only",null,"smoker","do not use"]
["Pre Tax","EPOCSESP","EPOCSE+SP","006.26","plan not built","Csuite","Employee + Spouse",null,"smoker","do not use"]
["Pre Tax","EPOCSECH","EPOCSE+CH","006.27","plan not built","Csuite","Employee + Child(ren)",null,"smoker","do not use"]
["Pre Tax","EPOCSEFM","EPOCSE+FM","006.28","plan not built","Csuite","Employee + Family",null,"smoker","do not use"]

{"sheet":"WT Plans, Class, Tier","index":1,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["EBS Plan Design Names","Class","Coverage Tier"]
["2017 Dependent Care Spending Account","Csuite","Employee"]
["2017 Healthcare Spending Account","Full Time Employees","Employee + Child"]
["Basic Life 1x Salary Up to $50k","Part Time Employees","Employee + Children"]
["Basic Life AD&D 1x Salary -Benefit exceeding $50000 is subject to tax","Per Diems","Employee + Spouse"]
["Basic Life AD&D Flat $500000 - Benefit exceeding $50000 is subject to tax",null,"Employee + Spouse + 1 Child"]
["Basic Life Flat 50k",null,"Employee, Spouse + 2+ Children"]
["Child Life"]
["Delta Dental PPO High Plan"]
["Delta Dental PPO Low Plan"]
["EPO Plan"]
["EPOPlan"]
["Hyatt Legal Plan"]
["LTD 60% to $10k"]
["Spouse Life"]
["Supplemental Employee Life"]
["Supplemental Employee Life (80+)"]
["Value Plan"]
["ValuePlan"]
["Vision Plan B - Basic Plan"]
["Vision Plan C- Premium Plan"]
["Voluntary LTD 60%"]
["Voluntary STD 60%"]
["Waive Medical"]
["Waive Medical Opt Out"]

{"sheet":"Rates (eff 7-1-2017)","index":2,"n_rows":61,"n_cols":26,"rows_kept":61,"cut":false,"hidden":false,"merged":[[50,0,51,0],[6,17,6,18],[28,0,29,0],[13,0,14,0],[35,0,36,0],[43,0,44,0],[12,17,12,18],[28,17,28,18],[36,17,36,18],[42,17,42,18],[43,17,43,18],[3,0,4,0],[3,1,3,4],[3,6,3,9],[3,11,4,11],[3,12,4,12]]}
["MISSION REGIONAL MEDICAL CENTER"]
["Master Rate Sheet 'Effective 7/1/2017 through 12/31/2017",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRIME DEDUCTION CODES"]
[]
["PLAN NAME","FULL-TIME EMPLOYEES",null,null,null,null,"PART-TIME EMPLOYEES",null,null,null,null,"TOTAL \nRATES","COBRA \nRATES"]
[null,"Employee","Employee","Prime","Prime","%ER","Employee","Employee","Prime","Prime","%ER",null,null,"good",null,null,null,null,null,"Withholding # - Full Time","MNEMONIC","CHECK CAPTION","XXXXX","Withholding # - Part Time","MNEMONIC","CHECK CAPTION"]
[]
["EPO Plan","EMPLOYEE",null,"PRIME",null,null,"EMPLOYEE",null,"PRIME",null,null,null,null,null,null,null,null,"Rounding Error Check"]
[null,"per pay period (26)",{"$f":"E8","v":"per month"},"per pay period (26)","per month",null,"per pay period (26)",{"$f":"J8","v":"per month"},"per pay period (26)","per month",null,"per month","per month",null,null,null,null,"FT","PT"]
["Employee Only",{"$f":"C9*12/26","v":0},0,{"$f":"E9*12/26","v":246.75666230769232},{"$f":"+L9-C9","v":534.63943500000005},{"$f":"E9/L9","v":1},{"$f":"H9*12/26","v":78.433846153846147},169.94,{"$f":"J9*12/26","v":168.32281615384619},{"$f":"L9-H9","v":364.69943500000005},{"$f":"J9/L9","v":0.68214091801888876},{"$f":"[1]Harlingen!N10","v":534.63943500000005},{"$f":"L9*1.02","v":545.3322237000001},null,null,null,null,{"$f":"IF(ROUND($C9,2)+ROUND($E9,2)=ROUND($L9,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H9,2)+ROUND($J9,2)=ROUND($L9,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"006.1","EPOFTEE","EPO FT EMP ",null,"006.13","EPOPTEE","EPO PT EMP "]
["Employee + Spouse",{"$f":"C10*12/26","v":52.292307692307688},113.3,{"$f":"E10*12/26","v":441.23611615384624},{"$f":"+L10-C10","v":956.0115850000002},{"$f":"E10/L10","v":0.89404397970681304},{"$f":"H10*12/26","v":156.88153846153847},339.91,{"$f":"J10*12/26","v":336.64688538461542},{"$f":"L10-H10","v":729.40158500000007},{"$f":"J10/L10","v":0.68212258730929209},{"$f":"[1]Harlingen!N11","v":1069.3115850000002},{"$f":"L10*1.02","v":1090.6978167000002},null,null,null,null,{"$f":"IF(ROUND($C10,2)+ROUND($E10,2)=ROUND($L10,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H10,2)+ROUND($J10,2)=ROUND($L10,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"006.2","EPOFTSP","EPO FT E+SPOUSE",null,"006.14","EPOPTSP","EPO PT E+SPOUSE"]
["Employee + Child(ren)",{"$f":"C11*12/26+0.01","v":42.794615384615383},92.7,{"$f":"E11*12/26","v":401.38945615384614},{"$f":"+L11-C11","v":869.67715499999997},{"$f":"E11/L11","v":0.90367601774587003},{"$f":"H11*12/26","v":130.72615384615386},283.24,{"$f":"J11*12/26","v":313.44791769230773},{"$f":"L11-H11","v":679.13715500000001},{"$f":"J11/L11","v":0.7056871118267557},{"$f":"[1]Harlingen!N12","v":962.37715500000002},{"$f":"L11*1.02","v":981.62469810000005},null,null,null,null,{"$f":"IF(ROUND($C11,2)+ROUND($E11,2)=ROUND($L11,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","006.3","EPOFTCH","EPO FT E+CHILD(S)",null,"006.15","EPOPTCH","EPO PT E+CHILD(S)"]
["Employee + Family",{"$f":"C12*12/26","v":106.96615384615384},231.76,{"$f":"E12*12/26","v":633.32899846153839},{"$f":"+L12-C12","v":1372.2128299999999},{"$f":"E12/L12","v":0.85550877442231987},{"$f":"H12*12/26","v":261.46615384615382},566.51,{"$f":"J12*12/26","v":478.82899846153845},{"$f":"L12-H12","v":1037.4628299999999},{"$f":"J12/L12","v":0.64680823178282887},{"$f":"[1]Harlingen!N13","v":1603.9728299999999},{"$f":"L12*1.02","v":1636.0522865999999},null,null,null,null,{"$f":"IF(ROUND($C12,2)+ROUND($E12,2)=ROUND($L12,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","006.4","EPOFTFM","EPO FT E+FAMILY",null,"006.16","EPOPTFM","EPO PT E+FAMILY"]
[]
["EPO \nw/Smoker Surcharge","EMPLOYEE",null,"PRIME",null,null,"EMPLOYEE",null,"PRIME"]
[null,"per pay period (26)",{"$f":"E15","v":"per month"},"per pay period (26)","per month",null,"per pay period (26)",{"$f":"J15","v":"per month"},"per pay period (26)","per month",null,"per month","per month"]
["Employee Only",{"$f":"C16*12/26","v":13.846153846153847},{"$f":"+C9+30","v":30},{"$f":"E16*12/26","v":232.91050846153848},{"$f":"+L16-C16","v":504.63943500000005},{"$f":"E16/L16","v":0.94388741638558704},{"$f":"H16*12/26","v":92.279999999999987},{"$f":"+H9+30","v":199.94},{"$f":"J16*12/26","v":154.47666230769235},{"$f":"L16-H16","v":334.69943500000005},{"$f":"J16/L16","v":0.62602833440447581},{"$f":"+L9","v":534.63943500000005},{"$f":"L16*1.02","v":545.3322237000001},null,null,null,null,{"$f":"IF(ROUND($C16,2)+ROUND($E16,2)=ROUND($L16,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H16,2)+ROUND($J16,2)=ROUND($L16,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"006.5","EPOSFTEE","EPOS FT EMP ",null,"006.17","EPOSPTEE","EPOS PT EMP "]
["Employee + Spouse",{"$f":"C17*12/26","v":66.138461538461542},{"$f":"+C10+30","v":143.30000000000001},{"$f":"E17*12/26","v":427.38996230769237},{"$f":"+L17-C17","v":926.0115850000002},{"$f":"E17/L17","v":0.86598854626642807},{"$f":"H17*12/26","v":170.72769230769231},{"$f":"+H10+30","v":369.91},{"$f":"J17*12/26","v":322.80073153846155},{"$f":"L17-H17","v":699.40158500000007},{"$f":"J17/L17","v":0.65406715386890713},{"$f":"+L10","v":1069.3115850000002},{"$f":"L17*1.02","v":1090.6978167000002},null,null,null,null,{"$f":"IF(ROUND($C17,2)+ROUND($E17,2)=ROUND($L17,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H17,2)+ROUND($J17,2)=ROUND($L17,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"006.6","EPOSFTSP","EPOS FT E+SPOUSE",null,"006.18","EPOSPTSP","EPOS PT E+SPOUSE"]
["Employee + Child(ren)",{"$f":"C18*12/26","v":56.630769230769232},{"$f":"+C11+30","v":122.7},{"$f":"E18*12/26","v":387.54330230769233},{"$f":"+L18-C18","v":839.67715499999997},{"$f":"E18/L18","v":0.87250320795488956},{"$f":"H18*12/26","v":144.5723076923077},{"$f":"+H11+30","v":313.24},{"$f":"J18*12/26","v":299.60176384615386},{"$f":"L18-H18","v":649.13715500000001},{"$f":"J18/L18","v":0.67451430203577512},{"$f":"+L11","v":962.37715500000002},{"$f":"L18*1.02","v":981.62469810000005},null,null,null,null,{"$f":"IF(ROUND($C18,2)+ROUND($E18,2)=ROUND($L18,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","006.7","EPOSFTCH","EPOS FT E+CHILD(S)",null,"006.19","EPOSPTCH","EPOS PT E+CHILD(S)"]
["Employee + Family",{"$f":"C19*12/26","v":120.81230769230768},{"$f":"+C12+30","v":261.76},{"$f":"E19*12/26","v":619.48284461538458},{"$f":"+L19-C19","v":1342.2128299999999},{"$f":"E19/L19","v":0.836805215709296},{"$f":"H19*12/26","v":275.31230769230768},{"$f":"+H12+30","v":596.51},{"$f":"J19*12/26","v":464.98284461538458},{"$f":"L19-H19","v":1007.4628299999999},{"$f":"J19/L19","v":0.628104673069805},{"$f":"+L12","v":1603.9728299999999},{"$f":"L19*1.02","v":1636.0522865999999},null,null,null,null,{"$f":"IF(ROUND($C19,2)+ROUND($E19,2)=ROUND($L19,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","006.8","EPOSFTFM","EPOS FT E+FAMILY",null,"006.20","EPOSPTFM","EPOS PT E+FAMILY"]
[]
["VALUE PLAN","EMPLOYEE",null,"PRIME",null,null,"EMPLOYEE",null,"PRIME"]
[null,"per pay period (26)",{"$f":"E22","v":"per month"},"per pay period (26)","per month",null,"per pay period (26)",{"$f":"J22","v":"per month"},"per pay period (26)","per month",null,"per month","per month"]
["Employee Only",{"$f":"C23*12/26","v":42.641538461538467},{"$f":"'[1]Prime Legacy'!C28","v":92.39},{"$f":"E23*12/26","v":148.6397351538462},{"$f":"+L23-C23","v":322.05275950000009},{"$f":"E23/L23","v":0.77707416070807245},{"$f":"H23*12/26","v":42.641538461538467},{"$f":"+C23","v":92.39},{"$f":"J23*12/26","v":148.6397351538462},{"$f":"L23-H23","v":322.05275950000009},{"$f":"J23/L23","v":0.77707416070807245},{"$f":"+'[1]Prime Legacy'!N28","v":414.44275950000008},{"$f":"L23*1.02","v":422.73161469000007},null,null,null,null,{"$f":"IF(ROUND($C23,2)+ROUND($E23,2)=ROUND($L23,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H23,2)+ROUND($J23,2)=ROUND($L23,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"006.9","VPFPPDEE","VALUE PLAN EMP ONLY"]
["Employee + Spouse",{"$f":"C24*12/26","v":91.199999999999989},{"$f":"'[1]Prime Legacy'!C29","v":197.6},{"$f":"E24*12/26","v":291.36805315384623},{"$f":"+L24-C24","v":631.29744850000009},{"$f":"E24/L24","v":0.76161104083794273},{"$f":"H24*12/26","v":91.199999999999989},{"$f":"+C24","v":197.6},{"$f":"J24*12/26","v":291.36805315384623},{"$f":"L24-H24","v":631.29744850000009},{"$f":"J24/L24","v":0.76161104083794273},{"$f":"+'[1]Prime Legacy'!N29","v":828.89744850000011},{"$f":"L24*1.02","v":845.47539747000008},null,null,null,null,{"$f":"IF(ROUND($C24,2)+ROUND($E24,2)=ROUND($L24,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H24,2)+ROUND($J24,2)=ROUND($L24,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"006.10","VPFPPDSP","VALUE PLAN EMP&SPOUSE"]
["Employee + Child(ren)",{"$f":"C25*12/26","v":76.15384615384616},{"$f":"'[1]Prime Legacy'!C30","v":165},{"$f":"E25*12/26","v":268.15354753846157},{"$f":"+L25-C25","v":580.99935300000004},{"$f":"E25/L25","v":0.77882018350758542},{"$f":"H25*12/26","v":76.15384615384616},{"$f":"+C25","v":165},{"$f":"J25*12/26","v":268.15354753846157},{"$f":"L25-H25","v":580.99935300000004},{"$f":"J25/L25","v":0.77882018350758542},{"$f":"+'[1]Prime Legacy'!N30","v":745.99935300000004},{"$f":"L25*1.02","v":760.91934006000008},null,null,null,null,{"$f":"IF(ROUND($C25,2)+ROUND($E25,2)=ROUND($L25,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","006.11","VPFPPDCH","VALUE PLAN EMP&CHILD"]
["Employee + Family",{"$f":"C26*12/26","v":151.98461538461541},{"$f":"'[1]Prime Legacy'!C31","v":329.3},{"$f":"E26*12/26","v":421.87021730769237},{"$f":"+L26-C26","v":914.05213750000007},{"$f":"E26/L26","v":0.73515145865102927},{"$f":"H26*12/26","v":151.98461538461541},{"$f":"+C26","v":329.3},{"$f":"J26*12/26","v":421.87021730769237},{"$f":"L26-H26","v":914.05213750000007},{"$f":"J26/L26","v":0.73515145865102927},{"$f":"+'[1]Prime Legacy'!N31","v":1243.3521375},{"$f":"L26*1.02","v":1268.2191802500001},null,null,null,null,{"$f":"IF(ROUND($C26,2)+ROUND($E26,2)=ROUND($L26,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","006.12","VPFPPDFM","VALUE PLAN EMP&FAMILY"]
[]
[]
["DELTA DENTAL \nPPO HIGH","EMPLOYEE",null,"PRIME",null,null,"EMPLOYEE",null,"PRIME",null,null,null,null,null,null,null,null,"Rounding Error Check"]
[null,"per pay period (26)",{"$f":"E30","v":"per month"},"per pay period (26)","per month",null,"per pay period (26)",{"$f":"J30","v":"per month"},"per pay period (26)","per month",null,"per month","per month",null,null,null,null,"FT","PT"]
["Employee Only",{"$f":"+[1]KNAPP!B32","v":2.870769230769231},{"$f":"B31*26/12","v":6.22},{"$f":"E31*12/26","v":9.1753846153846172},{"$f":"+L31-C31","v":19.880000000000003},{"$f":"E31/L31","v":0.76168582375478933},{"$f":"+[1]KNAPP!I32","v":2.870769230769231},{"$f":"G31*26/12","v":6.22},{"$f":"J31*12/26","v":9.1753846153846172},{"$f":"L31-H31","v":19.880000000000003},{"$f":"J31/L31","v":0.76168582375478933},26.1,{"$f":"L31*1.02","v":26.622000000000003},null,null,null,{"$f":"+(B31+D31)*26/12","v":26.100000000000005},{"$f":"IF(ROUND($C31,2)+ROUND($E31,2)=ROUND($L31,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H31,2)+ROUND($J31,2)=ROUND($L31,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"020.1","DPPOHEE","DNTL PPO HIGH EMP"]
["Employee + Spouse",{"$f":"+[1]KNAPP!B33","v":12.318461538461539},{"$f":"B32*26/12","v":26.69},{"$f":"E32*12/26","v":13.550769230769228},{"$f":"+L32-C32","v":29.359999999999996},{"$f":"E32/L32","v":0.52381801962533447},{"$f":"+[1]KNAPP!I33","v":12.318461538461539},{"$f":"G32*26/12","v":26.69},{"$f":"J32*12/26","v":13.550769230769228},{"$f":"L32-H32","v":29.359999999999996},{"$f":"J32/L32","v":0.52381801962533447},56.05,{"$f":"L32*1.02","v":57.170999999999999},null,null,null,{"$f":"+(B32+D32)*26/12","v":56.04999999999999},{"$f":"IF(ROUND($C32,2)+ROUND($E32,2)=ROUND($L32,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H32,2)+ROUND($J32,2)=ROUND($L32,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"020.2","DPPOHES","DNTL PPO HIGH E+SPOUSE"]
["Employee + Child(ren)",{"$f":"+[1]KNAPP!B34","v":14.916923076923078},{"$f":"B33*26/12","v":32.32},{"$f":"E33*12/26","v":16.412307692307689},{"$f":"+L33-C33","v":35.559999999999995},{"$f":"E33/L33","v":0.52386564525633472},{"$f":"+[1]KNAPP!I34","v":14.916923076923078},{"$f":"G33*26/12","v":32.32},{"$f":"J33*12/26","v":16.412307692307689},{"$f":"L33-H33","v":35.559999999999995},{"$f":"J33/L33","v":0.52386564525633472},67.88,{"$f":"L33*1.02","v":69.2376},null,null,null,{"$f":"+(B33+D33)*26/12","v":67.88},{"$f":"IF(ROUND($C33,2)+ROUND($E33,2)=ROUND($L33,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","020.3","DPPOHEC","DNTL PPO HIGH E+CHILD(S)"]
["Employee + Family",{"$f":"+[1]KNAPP!B35","v":16.753846153846151},{"$f":"B34*26/12","v":36.29999999999999},{"$f":"E34*12/26","v":18.433846153846158},{"$f":"+L34-C34","v":39.940000000000005},{"$f":"E34/L34","v":0.52387198321091299},{"$f":"+[1]KNAPP!I35","v":16.753846153846151},{"$f":"G34*26/12","v":36.29999999999999},{"$f":"J34*12/26","v":18.433846153846158},{"$f":"L34-H34","v":39.940000000000005},{"$f":"J34/L34","v":0.52387198321091299},76.239999999999995,{"$f":"L34*1.02","v":77.764799999999994},null,null,null,{"$f":"+(B34+D34)*26/12","v":76.239999999999995},{"$f":"IF(ROUND($C34,2)+ROUND($E34,2)=ROUND($L34,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","020.4","DPPOHEF","DNTL PPO HIGH E+FAMILY"]
[]
["DELTA DENTAL\n PPO LOW","EMPLOYEE",null,"PRIME",null,null,"EMPLOYEE",null,"PRIME"]
[null,"per pay period (26)",{"$f":"E37","v":"per month"},"per pay period (26)","per month",null,"per pay period (26)",{"$f":"J37","v":"per month"},"per pay period (26)","per month",null,"per month","per month"]
["Employee Only",{"$f":"+[1]KNAPP!B39","v":2.2707692307692309},{"$f":"B38*26/12","v":4.9200000000000008},{"$f":"E38*12/26","v":8.2523076923076921},{"$f":"+L38-C38","v":17.88},{"$f":"E38/L38","v":0.78421052631578936},{"$f":"+[1]KNAPP!I39","v":2.2707692307692309},{"$f":"G38*26/12","v":4.9200000000000008},{"$f":"J38*12/26","v":8.2523076923076921},{"$f":"L38-H38","v":17.88},{"$f":"J38/L38","v":0.78421052631578936},22.8,{"$f":"L38*1.02","v":23.256},null,null,null,{"$f":"+(B38+D38)*26/12","v":22.8},{"$f":"IF(ROUND($C38,2)+ROUND($E38,2)=ROUND($L38,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H38,2)+ROUND($J38,2)=ROUND($L38,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"020.5","DPPOLEE","DNTL PPO LOW EMP"]
["Employee + Spouse",{"$f":"+[1]KNAPP!B40","v":9.7430769230769236},{"$f":"B39*26/12","v":21.110000000000003},{"$f":"E39*12/26","v":12.830769230769228},{"$f":"+L39-C39","v":27.799999999999994},{"$f":"E39/L39","v":0.56839092210181963},{"$f":"+[1]KNAPP!I40","v":9.7430769230769236},{"$f":"G39*26/12","v":21.110000000000003},{"$f":"J39*12/26","v":12.830769230769228},{"$f":"L39-H39","v":27.799999999999994},{"$f":"J39/L39","v":0.56839092210181963},48.91,{"$f":"L39*1.02","v":49.888199999999998},null,null,null,{"$f":"+(B39+D39)*26/12","v":48.91},{"$f":"IF(ROUND($C39,2)+ROUND($E39,2)=ROUND($L39,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H39,2)+ROUND($J39,2)=ROUND($L39,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"020.6","DPPOLES","DNTL PPO LOW E+SPOUSE"]
["Employee + Child(ren)",{"$f":"+[1]KNAPP!B41","v":11.963076923076924},{"$f":"B40*26/12","v":25.92},{"$f":"E40*12/26","v":15.75230769230769},{"$f":"+L40-C40","v":34.129999999999995},{"$f":"E40/L40","v":0.56835970024979177},{"$f":"+[1]KNAPP!I41","v":11.963076923076924},{"$f":"G40*26/12","v":25.92},{"$f":"J40*12/26","v":15.75230769230769},{"$f":"L40-H40","v":34.129999999999995},{"$f":"J40/L40","v":0.56835970024979177},60.05,{"$f":"L40*1.02","v":61.250999999999998},null,null,null,{"$f":"+(B40+D40)*26/12","v":60.050000000000004},{"$f":"IF(ROUND($C40,2)+ROUND($E40,2)=ROUND($L40,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","020.7","DPPOLEC","DNTL PPO LOW E+CHILD(S)"]
["Employee + Family",{"$f":"+[1]KNAPP!B42","v":12.761538461538461},{"$f":"B41*26/12","v":27.649999999999995},{"$f":"E41*12/26","v":16.804615384615389},{"$f":"+L41-C41","v":36.410000000000011},{"$f":"E41/L41","v":0.56837339993755864},{"$f":"+[1]KNAPP!I42","v":12.761538461538461},{"$f":"G41*26/12","v":27.649999999999995},{"$f":"J41*12/26","v":16.804615384615389},{"$f":"L41-H41","v":36.410000000000011},{"$f":"J41/L41","v":0.56837339993755864},64.06,{"$f":"L41*1.02","v":65.341200000000001},null,null,null,{"$f":"+(B41+D41)*26/12","v":64.06},{"$f":"IF(ROUND($C41,2)+ROUND($E41,2)=ROUND($L41,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","020.8","DPPOLEF","DNTL PPO LOW E+FAMILY"]
[]
[]
["VSP CHOICE \nPLAN B","EMPLOYEE",null,"PRIME",null,null,"EMPLOYEE",null,"PRIME",null,null,null,null,null,null,null,null,"Rounding Error Check"]
[null,"per pay period (26)","per month","per pay period (26)","per month",null,"per pay period (26)","per month","per pay period (26)","per month",null,"per month","per month",null,null,null,null,"FT","PT"]
["Employee Only",{"$f":"C46*12/26","v":3.503076923076923},{"$f":"L46","v":7.59},{"$f":"E46*12/26","v":0},{"$f":"L46-C46","v":0},{"$f":"E46/L46","v":0},{"$f":"H46*12/26","v":3.503076923076923},{"$f":"+L46","v":7.59},{"$f":"J46*12/26","v":0},{"$f":"L46-H46","v":0},{"$f":"J46/L46","v":0},{"$f":"+'[1]Prime Legacy'!N59","v":7.59},{"$f":"L46*1.02","v":7.7417999999999996},null,null,null,null,{"$f":"IF(ROUND($C46,2)+ROUND($E46,2)=ROUND($L46,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H46,2)+ROUND($J46,2)=ROUND($L46,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"060.1","VSPBEE","VSP B EMP"]
["Employee + Spouse",{"$f":"C47*12/26","v":5.6076923076923082},{"$f":"L47","v":12.15},{"$f":"E47*12/26","v":0},{"$f":"L47-C47","v":0},{"$f":"E47/L47","v":0},{"$f":"H47*12/26","v":5.6076923076923082},{"$f":"+L47","v":12.15},{"$f":"J47*12/26","v":0},{"$f":"L47-H47","v":0},{"$f":"J47/L47","v":0},{"$f":"+'[1]Prime Legacy'!N60","v":12.15},{"$f":"L47*1.02","v":12.393000000000001},null,null,null,null,{"$f":"IF(ROUND($C47,2)+ROUND($E47,2)=ROUND($L47,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H47,2)+ROUND($J47,2)=ROUND($L47,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"060.2","VSPBES","VSP B E+SPOUSE"]
["Employee + Child(ren)",{"$f":"C48*12/26","v":5.7323076923076917},{"$f":"L48","v":12.42},{"$f":"E48*12/26","v":0},{"$f":"L48-C48","v":0},{"$f":"E48/L48","v":0},{"$f":"H48*12/26","v":5.7323076923076917},{"$f":"+L48","v":12.42},{"$f":"J48*12/26","v":0},{"$f":"L48-H48","v":0},{"$f":"J48/L48","v":0},{"$f":"+'[1]Prime Legacy'!N61","v":12.42},{"$f":"L48*1.02","v":12.6684},null,null,null,null,{"$f":"IF(ROUND($C48,2)+ROUND($E48,2)=ROUND($L48,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","060.3","VSPBEC","VSP B E+CHILD(S)"]
["Employee + Family",{"$f":"C49*12/26","v":9.4292307692307684},{"$f":"L49","v":20.43},{"$f":"E49*12/26","v":0},{"$f":"L49-C49","v":0},{"$f":"E49/L49","v":0},{"$f":"H49*12/26","v":9.4292307692307684},{"$f":"+L49","v":20.43},{"$f":"J49*12/26","v":0},{"$f":"L49-H49","v":0},{"$f":"J49/L49","v":0},{"$f":"+'[1]Prime Legacy'!N62","v":20.43},{"$f":"L49*1.02","v":20.8386},null,null,null,null,{"$f":"IF(ROUND($C49,2)+ROUND($E49,2)=ROUND($L49,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","060.4","VSPBEF","VSP B E+FAMILY"]
[]
["VSP CHOICE\n PLAN C","EMPLOYEE",null,"PRIME",null,null,"EMPLOYEE",null,"PRIME"]
[null,"per pay period (26)","per month","per pay period (26)","per month",null,"per pay period (26)","per month","per pay period (26)","per month",null,"per month","per month"]
["Employee Only",{"$f":"C53*12/26","v":4.1215384615384618},{"$f":"L53","v":8.93},{"$f":"E53*12/26","v":0},{"$f":"L53-C53","v":0},{"$f":"E53/L53","v":0},{"$f":"H53*12/26","v":4.1215384615384618},{"$f":"+L53","v":8.93},{"$f":"J53*12/26","v":0},{"$f":"L53-H53","v":0},{"$f":"J53/L53","v":0},{"$f":"+'[1]Prime Legacy'!N66","v":8.93},{"$f":"L53*1.02","v":9.1085999999999991},null,null,null,null,{"$f":"IF(ROUND($C53,2)+ROUND($E53,2)=ROUND($L53,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H53,2)+ROUND($J53,2)=ROUND($L53,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"060.5","VSPCEE","VSP C EMP"]
["Employee + Spouse",{"$f":"C54*12/26","v":6.6046153846153848},{"$f":"L54","v":14.31},{"$f":"E54*12/26","v":0},{"$f":"L54-C54","v":0},{"$f":"E54/L54","v":0},{"$f":"H54*12/26","v":6.6046153846153848},{"$f":"+L54","v":14.31},{"$f":"J54*12/26","v":0},{"$f":"L54-H54","v":0},{"$f":"J54/L54","v":0},{"$f":"+'[1]Prime Legacy'!N67","v":14.31},{"$f":"L54*1.02","v":14.596200000000001},null,null,null,null,{"$f":"IF(ROUND($C54,2)+ROUND($E54,2)=ROUND($L54,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},{"$f":"IF(ROUND($H54,2)+ROUND($J54,2)=ROUND($L54,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"060.6","VSPCES","VSP C E+SPOUSE"]
["Employee + Child(ren)",{"$f":"C55*12/26","v":6.7476923076923079},{"$f":"L55","v":14.62},{"$f":"E55*12/26","v":0},{"$f":"L55-C55","v":0},{"$f":"E55/L55","v":0},{"$f":"H55*12/26","v":6.7476923076923079},{"$f":"+L55","v":14.62},{"$f":"J55*12/26","v":0},{"$f":"L55-H55","v":0},{"$f":"J55/L55","v":0},{"$f":"+'[1]Prime Legacy'!N68","v":14.62},{"$f":"L55*1.02","v":14.9124},null,null,null,null,{"$f":"IF(ROUND($C55,2)+ROUND($E55,2)=ROUND($L55,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","060.7","VSPCEC","VSP C E+CHILD(S)"]
["Employee + Family",{"$f":"C56*12/26","v":10.883076923076922},{"$f":"L56","v":23.58},{"$f":"E56*12/26","v":0},{"$f":"L56-C56","v":0},{"$f":"E56/L56","v":0},{"$f":"H56*12/26","v":10.883076923076922},{"$f":"+L56","v":23.58},{"$f":"J56*12/26","v":0},{"$f":"L56-H56","v":0},{"$f":"J56/L56","v":0},{"$f":"+'[1]Prime Legacy'!N69","v":23.58},{"$f":"L56*1.02","v":24.051599999999997},null,null,null,null,{"$f":"IF(ROUND($C56,2)+ROUND($E56,2)=ROUND($L56,2),\"-\",\"ROUNDING ERROR!\")","v":"-"},"-","060.8","VSPCEF","VSP C E+FAMILY"]
[]
[]
["EAP","EMPLOYEE",null,"PRIME",null,null,"EMPLOYEE",null,"PRIME"]
["(Bundled w/Basic Life through SunLife)","per pay period (26)","per month","per pay period (26)","per month",null,"per pay period (26)","per month","per pay period (26)","per month",null,"per month","per month"]
["Employee Only",0,0,0,0,{"$f":"E61/L61","v":0},{"$f":"B61","v":0},{"$f":"C61","v":0},{"$f":"J61*12/26","v":0.48461538461538467},1.05,{"$f":"J61/L61","v":1},1.05,"N/A"]

{"sheet":"C Suite Codes","index":3,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":false,"merged":[[2,2,3,2]]}
[null,null,"Mission Regional Medical Center"]
[null,null,"C-SUITE"]
[null,"C-Suite","PLAN NAME"]
["C-Suite Ded#","Ded Codes"]
[]
[null,null,"EPO Plan"]
[]
["006.21","EPOCEE","Employee Only"]
["006.22","EPOCE+SP","Employee + Spouse"]
["006.23","EPOCE+CH","Employee + Child(ren)"]
["006.24","EPOCE+FM","Employee + Family"]
[]
[null,null,"EPO Plan w/Smoker Surcharge","do not use"]
[]
["006.25","EPOCSEE","Employee Only"]
["006.26","EPOCSE+SP","Employee + Spouse"]
["006.27","EPOCSE+CH","Employee + Child(ren)"]
["006.28","EPOCSE+FM","Employee + Family"]
[]
[null,null,"VALUE PLAN"]
[]
["006.29","EPOCVEE","Employee Only"]
["006.30","EPOCVE+SP","Employee + Spouse"]
["006.31","EPOCVE+CH","Employee + Child(ren)"]
["006.32","EPOCVE+FM","Employee + Family"]
[]
[]
[null,null,"DELTA DENTAL PPO HIGH PLAN"]
[null,null,"Moved to Delta effective 1/1/2017"]
["020.9","DPPOHCEE","Employee Only"]
["020.10","DPPOHCE+SP","Employee + Spouse"]
["020.11","DPPOHCE+CH","Employee + Child(ren)"]
["020.12","DPPOHCE+FM","Employee + Family"]
[]
[null,null,"DELTA DENTAL PPO LOW PLAN"]
[null,null,"Moved to Delta effective 1/1/2017"]
["020.13","DPPOLCEE","Employee Only"]
["020.14","DPPOLCE+SP","Employee + Spouse"]
["020.15","DPPOLCE+CH","Employee + Child(ren)"]
["020.16","DPPOLCE+FM","Employee + Family"]
[]
[]
[null,null,"VSP VISION CHOICE PLAN B"]
[null,null,"New Plan Effective 1/1/2016"]
["020.17","VSPBCEE","Employee Only"]
["020.18","VSPBCE+SP","Employee + Spouse"]
["020.19","VSPBCE+CH","Employee + Child(ren)"]
["020.20","VSPBCE+FM","Employee + Family"]
[]
[null,null,"VSP VISION CHOICE PLAN C"]
[null,null,"New Plan Effective 1/1/2016"]
["020.21","VSPCCEE","Employee Only"]
["020.22","VSPCCE+SP","Employee + Spouse"]
["020.23","VSPCCE+CH","Employee + Child(ren)"]
["020.24","VSPCCE+FM","Employee + Family"]
[]
[]
[null,null,"EAP (Employee Assistance Program)"]
[null,null,"(Bundled with Basic Life through Sun Life)"]
[null,null,"Employee Only"]