{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Census 2-50 Hlth Dent Life","Instructions","Sample Census"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Census 2-50 Hlth Dent Life","index":0,"n_rows":17,"n_cols":26,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,4,5,6],[9,17,9,24],[9,4,9,9],[8,4,8,9],[0,3,0,24],[3,12,3,19],[2,12,2,19],[2,4,2,6],[3,4,3,6],[4,4,4,6],[4,12,4,19],[5,12,5,19],[10,0,10,13],[6,4,6,6],[7,4,7,6],[7,12,7,13],[6,12,6,15],[7,15,7,19],[6,17,6,19],[8,15,8,16],[8,17,8,19]]}
[null,null,null,"Please Note: This is ONLY used for obtaining quotes.  It is NOT used to process OR initiate enrollment changes (including employee additions, deletions or changes in employee status).\nNor is it acceptable as a request or authorization to make such changes.\nINSTRUCTIONS: Move mouse over the Header of each Column OR located on Worksheet 2 (Instructions Tab)"]
[]
[null,null,null,"Date of Census:",null,null,null,null,null,null,null,"*Requested Effective Date:"]
[null,null,null,"Co Name:",null,null,null,null,null,null,null,"Bus. Description:"]
[null,null,null,"SIC Code:",null,null,null,null,null,null,null,"Payroll Cycle:"]
[null,null,null,"Contact Name:",null,null,null,null,null,null,null,"Employer Contribution:"]
[null,null,null,"Address:",null,null,null,null,null,null,null,"City/State:",null,null,null,null,"Zip Code:"]
[null,null,null,"Telephone:",null,null,null,null,null,null,null,"Fax:",null,null,"Email:"]
[null,null,null,"Current Carrier:","MEC",null,null,null,null,null,null,null,null,null,null,"Avg # Emp:",null,60]
[null,null,null,"Requested Benefits:","Management Carve Out",null,null,null,null,null,null,null,null,null,null,null,"Current Benefits(Dr Copay/RX Copay/ Ded / CoInsurance):"]
[]
["Employee Record #","Associated w Employee Record #","*Relationship","Last Name","First Name","DOB","Gender","Home Zip","Home State","Work Zip","Tobacco Y/N","Medical","Dental","Vision","Life","* Life Volume","Disability","**Annual Salary\n(est if hrly)","Job Title"," # Children\n","Medicare Enrollee","Cobra or State Continuation","Smoker","Retired","Disabled","Complete Y/N"]
[1,null,"Employee",null,null,null,null,null,"TX"]
[2,null,"Employee",null,null,null,null,null,"TX"]
[3,null,"Employee",null,null,null,null,null,"TX"]
[4,null,"Employee",null,null,null,null,null,"TX"]
[5,null,"Employee",null,null,null,null,null,"TX"]

{"sheet":"Instructions","index":1,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Timeline:","Once plans are selected, we recommend allowing two weeks for applications to be processed in order to receive final rates prior to the requested effective date."]
[null,"*Please note: applications submitted with less than two weeks lead time, may not receive approval/final rates until after the effective date (in some cases, you may experience a delay of as much as 10 business days)."]
["Instructions:","The following fields MUST be completed in full for All Eligible Employees."]
["Employee Record #","Used to number only the Employees (no number here for Spouse or Child)\n"]
["Associated w Employee Record #","Blank for Employee.\nPut the number corresponding to the Employee Record # in this field when Spouse or Child "]
["*Relationship","Employee\nSpouse\nChild\n"]
["Last Name"]
["First Name"]
["DOB","Type MMDDYY\n"]
["Gender","Male or Female"]
["Home Zip"]
["Work Zip"]
["Medical","EE - Employee Only\nES - Employee + Spouse\nEC - Employee + Child\nEF - Employee + Spouse + Child\nW - Waiving Coverage"]
["Dental","EE - Employee Only\nES - Employee + Spouse\nEC - Employee + Child\nEF - Employee + Spouse + Child\nW - Waiving Coverage"]
["Vision","EE - Employee Only\nES - Employee + Spouse\nEC - Employee + Child\nEF - Employee + Spouse + Child\nW - Waiving Coverage"]
["Life","EE - Employee Only\nES - Employee + Spouse\nEC - Employee + Child\nEF - Employee + Spouse + Child\nW - Waiving Coverage"]
["Life Volume"]
["Disability"]
["Annual Salary\n(est if hrly)","Required Only if you are insterested in obtaining quotes for Group Disability\nOR\nSalary Based Life Insurance\nAnnual Salary: required ONLY if you are interested in obtaining quotes for Group Disability, or salary based Life Insurance.\nFor hourly employees, provide estimate of annual salary.\nFor commissioned employees, provide previous year's total salary including commission OR (if not available) estimated amt for current year."]
[" # Children\n"]
["Medicare Enrollee"]
["Cobra or State Continuation"]
["Smoker"]
["Retired"]
["Disabled"]

{"sheet":"Sample Census","index":2,"n_rows":33,"n_cols":23,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,4,4,6],[0,3,0,21],[2,4,2,6],[2,10,2,16],[3,4,3,6],[3,10,3,16],[10,0,10,11],[5,4,5,6],[6,4,6,6],[6,10,6,13],[6,15,6,16],[7,4,7,6],[7,10,7,11],[7,13,7,16],[8,4,8,8],[8,13,8,14],[8,15,8,16],[9,4,9,8],[9,15,9,21]]}
[null,null,null,"Please Note: This is ONLY used for obtaining quotes.  It is NOT used to process OR initiate enrollment changes (including employee additions, deletions or changes in employee status).\nNor is it acceptable as a request or authorization to make such changes.\nINSTRUCTIONS: Move mouse over the Header of each Column OR located on Worksheet 2 (Instructions Tab)"]
[]
[null,null,null,"Date of Census:","2015-01-01",null,null,null,null,"*Requested Effective Date:","2015-03-01"]
[null,null,null,"Co Name:","Sample Company",null,null,null,null,"Bus. Description:","Insurance Office"]
[null,null,null,"SIC Code:"]
[null,null,null,"Contact Name:","Jane Doe"]
[null,null,null,"Address:","123 Main Street",null,null,null,null,"City/State:","Austin, TX",null,null,null,"Zip Code:",78711]
[null,null,null,"Telephone:","512-234-4567",null,null,null,null,"Fax:","512-345-6789",null,"Email:","janedoe@sample.com"]
[null,null,null,"Current Carrier:","Humana",null,null,null,null,null,null,null,null,"Avg # Emp:",null,10]
[null,null,null,"Requested Benefits:","Similar",null,null,null,null,null,null,null,null,null,"Current Benefits(Dr Copay/RX Copay/ Ded / CoInsurance):","80/60 $2000 Ded, $5000 OOP   RX  20/5070"]
[]
["Employee Record #","Associated w Employee Record #","*Relationship","Last Name","First Name","DOB","Gender","Home Zip","Work Zip","Medical","Dental","Vision","Life","* Life Volume","Disability","**Annual Salary\n(est if hrly)"," # Children\n","Medicare Enrollee","Cobra or State Continuation","Smoker","Retired","Disabled","Waivers"]
[1,1,"Employee","Able","Jane","1980-10-01","F",78701,78711,"EE","EE ","EE",null,null,null,null,null,"N","N","N","N","N"]
[2,2,"Employee","Brown","Barry","1981-07-01","M",78701,78711,"W","W","W",null,null,null,null,null,"N","N","N","N","N","GrpCovg -Spouse"]
[3,3,"Employee","Green","Bob","1974-01-01","M",78702,78711,"EF","EF","EF",null,null,null,null,3,"N","N","N","N","N"]
[null,3,"Spouse","Green","Lisa","1975-02-02","F",78702," ",null,null,null,null,null,null,null,null,"N","N","N","N","N"]
[null,3,"Child","Green","Linda","2000-01-01","F",78702,null,null,null,null,null,null,null,null,null,"N","N","N","N","N"]
[null,3,"Child","Green","Bill","2003-02-02","M",78702,null,null,null,null,null,null,null,null,null,"N","N","N","N","N"]
[null,3,"Child","Green","Andrew","2005-03-03","M",78702,null,null,null,null,null,null,null,null,null,"N","N","N","N","N"]
[4,4,"Employee","Jones","Julia","1965-05-05","F",78703,78711,"ES","ES","ES",null,null,null,null,null,"N","N","N","N","N"]
[null,4,"Spouse","Jones","Joe","1964-06-06","M",78703,null,null,null,null,null,null,null,null,null,"N","N","N","N","N"]
[5,5,"Employee","Moore","Janet","1968-04-04","F",78705,78711,"EE","EE ","EE",null,null,null,null,null,"N","N","N","N","N"]
[6,6,"Employee","Nixon","Pam","1972-02-01","F",78721,78711,"W","W","W",null,null,null,null,null,"N","N","N","N","N","No Coverage"]
[7,7,"Employee","Norton","Jim","1973-04-01","M",78706,78711,"EE","EE ","EE",null,null,null,null,null,"N","N","N","N","N"]
[8,8,"Employee","Randle","Henry","1978-03-02","M",78708,78711,"EE","EE ","EE",null,null,null,null,null,"N","N","N","N","N"]
[9,9,"Employee","Robinson","JoAnn","1983-01-01","F",78712,78711,"EE","EE ","EE",null,null,null,null,null,"N","N","N","N","N"]
[10,10,"Employee","Sanderson","Millie","1979-02-01","F",78713,78711,"EC","EC","EC",null,null,null,null,1,"N","N","N","N","N"]
[null,10,"Child","Sanderson","Amanda","2001-01-01","F",78713,null,null,null,null,null,null,null,null,null,"N","N","N","N","N"]
[11,11,"Employee","Smith","James","1981-02-01","M",78723,78711,"EC","EC","EC",null,null,null,null,2,"N","N","N","N","N"]
[null,11,"Child","Smith","Jonathan","2014-04-01","M",78723,null,null,null,null,null,null,null,null,null,"N","N","N","N","N"]
[" ",11,"Child","Smith","Aaron","2012-02-01","M",78723," "," "," "," ",null,null,null,null,null,"N","N","N","N","N"]
[12,12,"Employee","White","George","1981-07-01","M",78745,78711,"EE","EE ","EE",null,null,null,null,null,"N","N","N","N","N"]
[13,13,"Employee","Willett","Amy","1948-09-15","F",78751,78711,"W","W","W",null,null,null,null,null,"N","N","N","N","N","Medicare"]