{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[null,null,"Plan Name","Findings","Examples","Comment"]
[null,null,"Basic AD&D","Cost is displaying as blank in Enrollment report, but displaying as 0 on confirmation Statement","XXXXX7406 DAMRON TIMOTHY\nXXXXX9730 GOODWIN BRENT\nXXXXX2828 SHEN JINGJING\nXXXXX7406 DAMRON TIMOTHY\nXXXXX9730 GOODWIN BRENT\nXXXXX2828 SHEN JINGJING\n","For this plan rate not mapped so value coming on report is an empty."]
[null,null,"Basic Life","Cost is displaying as blank in Enrollment report, but displaying as 0 on confirmation Statement","XXXXX4789 GOSS DONALD\nXXXXX8939 HANNIGAN ESTELITA\nXXXXX7513 COOK BRANDON\nXXXXX4789 GOSS DONALD\nXXXXX8939 HANNIGAN ESTELITA\nXXXXX7513 COOK BRANDON\n","For this plan rate not mapped so value coming on report is an empty."]
[null,null,"Guardian Dental Plan","No 0 or blank cost for any employee, verified cost for a employee.","XXXXX7375 GREENWOOD CHARLES\nXXXXX7375 GREENWOOD CHARLES\n"]
[null,null,"2018 Flexible Spending Account - Dependent","No 0 or blank cost for any employee, verified cost for a employee.","XXXXX2009 RADIL SARAH\nXXXXX2009 RADIL SARAH\n"]
[null,null,"2018 Flexible Spending Account - Healthcare\n2018 Flexible Spending Account - Healthcare\n","No 0 or blank cost for any employee, verified cost for employees mentioned in examples.","XXXXX6540 WETZEL DAVID\nXXXXX7682 BASS LARRY\nXXXXX6540 WETZEL DAVID\nXXXXX7682 BASS LARRY\n"]
[null,null,"2018 Health Savings Account\n2018 Health Savings Account\n","No 0 or blank cost for any employee, verified cost for employees mentioned in examples.","XXXXX6887 CASEY WILLIAM\nXXXXX6887 CASEY WILLIAM\n"]
[null,null,"Company Paid LTD","Cost is displaying as blank in Enrollment report, but displaying as 0 on confirmation Statement","XXXXX7217 SUMMONS GARY\nXXXXX1367 VIGH ANTHONY\nXXXXX7217 SUMMONS GARY\nXXXXX1367 VIGH ANTHONY\n","For this plan rate not mapped so value coming on report is an empty. "]
[null,null,"PPO Medical Plan","No 0 or blank cost for any employee, verified cost for employees mentioned in examples.","XXXXX6219 KOVACH CORY\nXXXXX7465 JIMENEZ DEVIN\nXXXXX6219 KOVACH CORY\nXXXXX7465 JIMENEZ DEVIN\n"]
[null,null,"Medical Enrollment Waiver\nMedical Enrollment Waiver\n","Cost is displaying as blank in Enrollment report, but displaying as 0 on confirmation Statement","XXXXX2551 KOVACH SONYA\nXXXXX8161 RITZ BLAKE\nXXXXX2551 KOVACH SONYA\nXXXXX8161 RITZ BLAKE\n","For this plan rate not mapped so value coming on report is an empty. "]
[null,null,"High Deductible Health Plan","No 0 or blank cost for any employee, verified cost for employees mentioned in examples.","XXXXX7561 MAGGARD STEVEN\nXXXXX7561 MAGGARD STEVEN\n"]
[null,null,"Company Paid STD\nCompany Paid STD\n","Cost is displaying as blank in Enrollment report, but displaying as 0 on confirmation Statement","XXXXX0847 FRYE STEVE\nXXXXX2833 WALL CAROLYN\nXXXXX0847 FRYE STEVE\nXXXXX2833 WALL CAROLYN\n","For this plan rate not mapped so value coming on report is an empty. "]
[null,null,"Child Voluntary Life\nChild Voluntary Life\n","Cost is dislaying on Confirmation Statement,  but displaying as blank on report.","XXXXX5942 GREGG HEATHER\nXXXXX0204 CALVERT KARLA\n\n\nXXXXX5942 GREGG HEATHER\nXXXXX0204 CALVERT KARLA\n\n\n","\n\nMapped rate for this plan getting terminated on 2018-07-31 but we are pulling report with end date as after termination date. So for now it is showing blank value. We have already open JIRA (i.e. WT-11650) for this.\n\nSuppose we have pulled report with or before date 2018-07-31 then it is showing proper values on Enrollment Report. Those elections are terminating after End date of report only for those records value will appear\n"]
[null,null,"Employee Voluntary Life\nEmployee Voluntary Life\n","Cost is dislaying on Confirmation Statement,  but displaying as blank on report.","XXXXX2834 MANNING ERICA\nXXXXX2834 MANNING ERICA\n","\n\nMapped rate for this plan getting terminated on 2018-07-31 but we are pulling report with end date as after termination date. So for now it is showing blank value. We have already open JIRA (i.e. WT-11650) for this.\n\nSuppose we have pulled report with or before date 2018-07-31 then it is showing proper values on Enrollment Report. Those elections are terminating after End date of report only for those records value will appear\n"]
[null,null,"Spouse Voluntary Life","Cost is dislaying on Confirmation Statement,  but displaying as blank on report.","XXXXX3310 PERRY LEAH\nXXXXX3310 PERRY LEAH\n","\n\nMapped rate for this plan getting terminated on 2018-07-31 but we are pulling report with end date as after termination date. So for now it is showing blank value. We have already open JIRA (i.e. WT-11650) for this.\n\nSuppose we have pulled report with or before date 2018-07-31 then it is showing proper values on Enrollment Report. Those elections are terminating after End date of report only for those records value will appear\n"]
[null,null,"Tobacco Surcharge\nTobacco Surcharge\n","No 0 or blank cost for any employee, verified cost for employees mentioned in examples.","XXXXX8781 RAWLINS KENNETH\nXXXXX8781 RAWLINS KENNETH\n"]
[null,null,"Vision","No 0 or blank cost for any employee, verified cost for employees mentioned in examples.","XXXXX2571 FOXX DAVID\n"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}