{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["GROUP INFO & CENSUS"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"GROUP INFO & CENSUS","index":0,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[4,8,4,9],[2,4,2,5],[3,4,3,5],[2,7,2,8]]}
[]
[{"$nulls":12},"Definitions"]
[null,null,null,"Group Name:",null,null,"Address:",{"$nulls":5},"Coverage Type"]
[null,null,null,"4-Digit SIC Code:",null,null,"City:",{"$nulls":5},"EE: Employee Only"]
[null,null,null,"Effective Date:",null,null,"State:",null,"Total # of EE's:",null,null,null,"ES: Employee + Spouse"]
[null,null,null,"Broker/Agent Contact:",null,null,"Zip:",null,null,"# of Enrolled EE's:",null,null,"EC: Employee + Child(ren)"]
[{"$nulls":12},"EF: Family"]
[{"$nulls":12},"W: Waiving Coverage"]
[null,"First Name","Last Name","DOB","Gender","Coverage Type (EE, ES, EC, EF)","EE Yearly Income ","Spouse DOB","Number of Dependents","State","ZIP"]
[null,"John","Smith","1990-11-12","M","EF",50000,"1990-11-12",1,"PA",12345]
{"$rows_empty":10}
[{"$nulls":9},{"$f":"IF(I21=\"\",\"\",INT(YEARFRAC(I21,TODAY())))","v":""}]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},{"$f":"IF(I69=\"\",\"\",INT(YEARFRAC(I69,TODAY())))","v":""}]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]