{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Transmittal","PolicyTypes","Notes","Policies","Certificates"],"not_rendered":{"images":1,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Transmittal","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[0,1,0,2]],"flags":["formulas_cached_only"]}
[null,"Enter Data in the shaded areas only"]
["Table Reference","Field Name","Data Entry",{"$nulls":5},"Invalid Data Entry"]
["CoCode","Company Code",{"$nulls":6},"The entry does not conform to the field's specifications.  "]
["ReportYear","Reporting Year"]
["FYEndDate","Date Fiscal Year Ends"]
[null,"Contact Person Information"]
["ContactPersonFN","  First Name"]
["ContactPersonLN","  Last Name"]
["ContactAddress1","  Mailing Address Line 1"]
["ContactAddress2","  Mailing Address Line 2"]
["ContactCity","  Mailing Address City"]
["ContactSTABBR","  Mailing Address 2-Letter State Abbreviation"]
["ContactZip","  Mailing Zip Code"]
["ContactPhone","  Voice Phone Number"]
["ContactEmail","  e-mail Address"]

{"sheet":"PolicyTypes","index":1,"n_rows":1,"n_cols":19,"rows_kept":1,"flags":["formulas_cached_only"]}
["Policy Type","Coverage Category","Network Restrictions Indicator","Outpatient/ Physician Cost Sharing Type","Outpatient/ Physician Cost Sharing Amount","Outpatient/ Physician Coinsurance","Outpatient/ Physician Coinsurance Amount","Hospital Cost Sharing Indicator","Hospital Cost Sharing Amount","Hospital Coinsurance","Hospital Coinsurance Amount","Prescription Drug Coverage Indicator","Prescription Drug Coverage Cost Sharing Indicator","Prescripton Drug Coverage Maximum","Calendar Year or Lifetime Maximum","Physician and Hospital Cost Sharing Interaction Indicator","Maternity Coverage Indicator","MSA/HAS Indicator","Base Rate PMPM"]

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

{"sheet":"Policies","index":3,"n_rows":1,"n_cols":13,"rows_kept":1,"flags":["formulas_cached_only"]}
["Policy ID","Market Category","Geographic Location (County Code)","Policy Type","Premium","Claims","Effective Months","Total Number of Employees (Group Only)","Geographic Location Factor (Group Only)","Industry Factor (Group Only)","Health Status Factor","Group Size Factor (Group Only)","Tobacco Use Factor (Indiv Policies Only)"]

{"sheet":"Certificates","index":4,"n_rows":1,"n_cols":5,"rows_kept":1,"flags":["formulas_cached_only"]}
["Policy ID","Certificate Holder Geographic Location","Number of Certificate Holders (Enrolled Employees)","Number of Covered Lives","Sum of Membership Factors"]