{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Template","Life","PlanData","GenericRule","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Template","index":0,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":true,"merged":[[12,1,12,6],[0,0,0,9],[2,0,2,9],[3,1,3,6],[4,1,4,6],[5,1,5,6],[6,1,6,6],[7,1,7,6],[8,1,8,6],[9,1,9,6],[10,1,10,6],[11,1,11,6],[24,1,24,6],[13,1,13,6],[14,1,14,6],[15,1,15,6],[16,1,16,6],[17,1,17,6],[18,1,18,6],[19,1,19,6],[20,1,20,6],[21,1,21,6],[22,1,22,6],[23,1,23,6],[25,1,25,6],[27,0,27,1],[28,1,28,6],[29,1,29,6],[35,1,35,6]]}
["Life Rates"]
[]
["Rate Details"]
["Rate Id",0]
["Rate Name"]
["Start Date",null,null,null,null,null,null,"(in format, mm/dd/yyyy)"]
["End Date",null,null,null,null,null,null,"(in format, mm/dd/yyyy)"]
["Effective Date Rule"]
["Effective Date Waiting Period Option"]
["Effective Date Waiting Period Days"]
["Termination Date Rule"]
["Termination Date Waiting Period Options"]
["Termination Date Waiting Period Days"]
["Benefit Template","Life"]
["Rate Table Basis","Age"]
["Consider Age Of","Default"]
["Plan Costs Calculation Basis","Specific Date Selection"]
["Month (Specific Date Selection)","January"]
["Day (Specific Date Selection)",31]
["Year (Specific Date Selection)","Current Year"]
["Coverage Divisor"]
["Coverage Divisor Basis","Covered Salary"]
["% Of Employer Pre Tax Cost"]
["% Of Employer Post Tax Cost"]
["Maximum Covered Salary"]
["Cobra Rate","No"]
[]
["Sub Rate Details"]
["Sub Rate Id",0]
["Sub Rate Name"]
[]
["Employee and Spouse Costs"]
["Member Type","Employee And Spouse Cost ID","Age Range","Gender","Pre Tax Cost","Post Tax Cost","Coverage Amount"]
[]
["Rate Plan Mapping"]
["Rate Plan Mapping",null,null,null,null,null,null,"              (Multi select dropdown)"]
[]
["End Of Rate"]

{"sheet":"Life","index":1,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[27,0,27,1],[28,1,28,6],[29,1,29,6],[37,1,37,6],[21,1,21,6],[22,1,22,6],[23,1,23,6],[24,1,24,6],[25,1,25,6],[20,1,20,6],[7,1,7,6],[8,1,8,6],[9,1,9,6],[10,1,10,6],[11,1,11,6],[12,1,12,6],[13,1,13,6],[14,1,14,6],[15,1,15,6],[16,1,16,6],[17,1,17,6],[18,1,18,6],[19,1,19,6],[6,1,6,6],[0,0,0,9],[2,0,2,9],[3,1,3,6],[4,1,4,6],[5,1,5,6]]}
["Life Rates"]
[]
["Rate Details"]
["Rate Id",0]
["Rate Name","Alankar Life Rate"]
["Start Date","2017-01-01",null,null,null,null,null,"(in format, mm/dd/yyyy)"]
["End Date","2017-12-31",null,null,null,null,null,"(in format, mm/dd/yyyy)"]
["Effective Date Rule"]
["Effective Date Waiting Period Option"]
["Effective Date Waiting Period Days"]
["Termination Date Rule"]
["Termination Date Waiting Period Options"]
["Termination Date Waiting Period Days"]
["Benefit Template","Life"]
["Rate Table Basis","Age"]
["Consider Age Of","Default"]
["Plan Costs Calculation Basis","Specific Date Selection"]
["Month (Specific Date Selection)","January"]
["Day (Specific Date Selection)",31]
["Year (Specific Date Selection)","Current Year"]
["Coverage Divisor",1000]
["Coverage Divisor Basis","Covered Salary"]
["% Of Employer Pre Tax Cost",100]
["% Of Employer Post Tax Cost",100]
["Maximum Covered Salary"]
["Cobra Rate","No"]
[]
["Sub Rate Details"]
["Sub Rate Id",0]
["Sub Rate Name","Sub 1"]
[]
["Employee and Spouse Costs"]
["Member Type","Employee And Spouse Cost ID","Age Range","Gender","Pre Tax Cost","Post Tax Cost","Coverage Amount"]
["Employee",0,"5-15","Both",20,30]
["Employee",0,"1-20","Both",10,10]
[]
["Rate Plan Mapping"]
["Rate Plan Mapping",null,null,null,null,null,null,"              (Multi select dropdown)"]
[]
["End Of Rate"]

{"sheet":"PlanData","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"GenericRule","index":3,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["All Status Rule~1~1","Cigna"]
["2016 1095c Rule~1~1","Delta Dental AZ"]
["A SP~0~0","Discovery"]
["Alan SP Rule~1~1","Hartford"]
["CH SP~0~0","Curalinc"]
["Euro Rule~1~1","Health Advocate"]
["FT~1~1","Legal Shield"]
["InActive Status Rule~1~1","Cigna International"]
["new rule~1~1","State of Ca"]
["Rule 26~0~0","HSA Bank"]
["Rule_10~1~1","Healthnet"]
["Rule_100~1~1","Kaiser Permanente"]
["Rule_101~1~1","Unum"]
["Rule_11~1~1","The Standard Insurance-Life"]
["Rule_12~1~1","test"]
["Rule_13~1~1"]
["Rule_14~1~1"]
["Rule_15~1~1"]
["Rule_16~1~1"]
["Rule_17~1~1"]
["Rule_18~1~1"]
["Rule_19~1~1"]
["Rule_20~1~1"]
["Rule_21~1~1"]
["Rule_22~1~1"]
["Rule_23~1~1"]
["Rule_24~1~1"]
["Rule_25~0~0"]
["Rule_26~1~1"]
["Rule_33~0~0"]
["Rule_39~0~0"]
["Rule_41~1~1"]
["Rule_5~1~1"]
["Rule_6~1~1"]
["Rule_7~1~1"]
["Rule_8~1~1"]
["Rule_9~0~0"]
["sss~0~0"]
["Test~0~0"]
["testing~1~1"]

{"sheet":"Data","index":4,"n_rows":122,"n_cols":8,"rows_kept":122,"cut":false,"hidden":true,"merged":[[116,0,116,1],[117,1,117,6],[118,1,118,6]]}
["First of Month following Date of Change","Date of Termination",null,"FirstCheck",1,1,"January",1]
["First of Month following XX Days","End of Month",null,null,2,2,"February",2]
["First of Month following XX Months","Use Waiting Period",null,null,3,3,"March",3]
["XX Days from the Date of Change","First of the month following or coincident with Date of Change",null,null,4,4,"April",4]
["XX Months from the Date of Change","Next Pay Period Start Date",null,null,5,5,"May",5]
["XX Days From Next Pay Period Start Date","Next Pay Period End Date",null,null,6,6,"June",6]
["XX Days From Next Pay Period End Date","Next Pay Date",null,null,7,7,"July",7]
["XX Days From Next Pay Date","End of following month",null,null,8,8,"August",8]
["Pay Period Start Date After XX Pay Period","End of last month of Date of Birth",null,null,9,9,"September",9]
["XX Days before the Date of Change","Day of Termination less than 15 then End of Month else End of Following Month",null,null,10,10,"October",10]
[null,null,null,null,11,11,"November",11]
[null,null,null,null,12,12,"December",12]
[null,null,null,null,13,13,null,13]
[null,null,null,null,14,14,null,14]
[null,null,null,null,15,15,null,15]
[null,null,null,null,16,16,null,16]
[null,null,null,null,17,17,null,17]
[null,null,null,null,18,18,null,18]
[null,null,null,null,19,19,null,19]
[null,null,null,null,20,20,null,20]
[null,null,null,null,21,21,null,21]
[null,null,null,null,22,22,null,22]
[null,null,null,null,23,23,null,23]
[null,null,null,null,24,24,null,24]
[null,null,null,null,25,25,null,25]
[null,null,null,null,26,26,null,26]
[null,null,null,null,27,27,null,27]
[null,null,null,null,28,28,null,28]
[null,null,null,null,29,29,null,29]
[null,null,null,null,30,30,null,30]
[null,null,null,null,31,31,null,31]
[null,null,null,null,32,32]
[null,null,null,null,33,33]
[null,null,null,null,34,34]
[null,null,null,null,35,35]
[null,null,null,null,36,36]
[null,null,null,null,37,37]
[null,null,null,null,38,38]
[null,null,null,null,39,39]
[null,null,null,null,40,40]
[null,null,null,null,41,41]
[null,null,null,null,42,42]
[null,null,null,null,43,43]
[null,null,null,null,44,44]
[null,null,null,null,45,45]
[null,null,null,null,46,46]
[null,null,null,null,47,47]
[null,null,null,null,48,48]
[null,null,null,null,49,49]
[null,null,null,null,50,50]
[null,null,null,null,51,51]
[null,null,null,null,52,52]
[null,null,null,null,53,53]
[null,null,null,null,54,54]
[null,null,null,null,55,55]
[null,null,null,null,56,56]
[null,null,null,null,57,57]
[null,null,null,null,58,58]
[null,null,null,null,59,59]
[null,null,null,null,60,60]
[null,null,null,null,61,61]
[null,null,null,null,62,62]
[null,null,null,null,63,63]
[null,null,null,null,64,64]
[null,null,null,null,65,65]
[null,null,null,null,66,66]
[null,null,null,null,67,67]
[null,null,null,null,68,68]
[null,null,null,null,69,69]
[null,null,null,null,70,70]
[null,null,null,null,71,71]
[null,null,null,null,72,72]
[null,null,null,null,73,73]
[null,null,null,null,74,74]
[null,null,null,null,75,75]
[null,null,null,null,76,76]
[null,null,null,null,77,77]
[null,null,null,null,78,78]
[null,null,null,null,79,79]
[null,null,null,null,80,80]
[null,null,null,null,81,81]
[null,null,null,null,82,82]
[null,null,null,null,83,83]
[null,null,null,null,84,84]
[null,null,null,null,85,85]
[null,null,null,null,86,86]
[null,null,null,null,87,87]
[null,null,null,null,88,88]
[null,null,null,null,89,89]
[null,null,null,null,90,90]
[null,null,null,null,91,91]
[null,null,null,null,92,92]
[null,null,null,null,93,93]
[null,null,null,null,94,94]
[null,null,null,null,95,95]
[null,null,null,null,96,96]
[null,null,null,null,97,97]
[null,null,null,null,98,98]
[null,null,null,null,99,99]
[null,null,null,null,100,100]
[null,null,null,null,101,101]
[null,null,null,null,102,102]
[null,null,null,null,103,103]
[null,null,null,null,104,104]
[null,null,null,null,105,105]
[null,null,null,null,106,106]
[null,null,null,null,107,107]
[null,null,null,null,108,108]
[null,null,null,null,109,109]
[null,null,null,null,110,110]
[]
[]
[]
[]
[]
[]
["Sub Rate Details"]
["Sub Rate Id",0]
["Sub Rate Name"]
[]
["Employee and Spouse Costs"]
["Member Type","Employee And Spouse Cost ID","Age Range","Gender","Pre Tax Cost","Post Tax Cost","Coverage Amount"]