{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Business Rules","Sheet1"],"not_rendered":{"macros":1,"defined_names":2},"read":"row_number_cap","date_system":"1900"}

{"sheet":"Business Rules","index":0,"n_rows":1048576,"n_cols":13,"rows_kept":1048576,"read":"row_number_cap"}
["Business Rules Template v1.5",null,"To validate the template, press Validate button or Ctrl + Shift + V. To finalize the template, press Finalize button or Ctrl + Shift + F."]
["Go to cell C1 for instructions",null,"Enter the Issuer Rule on the first row (no Product ID or Plan ID)."]
[null,null,"For each Product rule, enter only the Product ID and the business rules that differ from the Issuer Rule."]
[null,null,"For each Plan rule, enter only the Plan ID and the business rules that differ from the Product or Issuer Rule"]
[]
[]
["HIOS Issuer ID*"]
["TIN*"]
["Product ID","Plan ID \n(Standard Component)","How are rates for contracts covering two or more enrollees calculated?","What are the maximum number of under age (under 21) dependents used to quote a two parent family?","What are the maximum number of under age (under 21) dependents used to quote a single parent family?","Is there a maximum age for a dependent?","What are the maximum number of children used to quote a children-only contract?","Are domestic partners treated the same as secondary subscribers?","Are same-sex partners treated the same as secondary subscribers?","How is age determined for rating and eligibility purposes?","How is tobacco status determined for subscribers and dependents?","What relationships between primary and dependent are allowed, and is the dependent required to live in the same household as the primary subscriber?","Is composite rating available? "]
{"$rows_empty":1048564}
[{"$nulls":3},1]
[null,null,"There are rates specifically for couples and for families (not just addition of individual rates)",2,null,"Yes",null,"Yes",null,null,"No Tobacco use for at least [x] months"]
[null,null,"A different rate (specifically for parties of two or more) for each enrollee is added together","3 or more",null,"Not Applicable",null,"No",null,null,"Not Applicable","Click to select"]

{"sheet":"Sheet1","index":1,"n_rows":8,"n_cols":1,"rows_kept":8,"hidden":true}
["Age on effective date"]
["Age on January 1st of the effective date year"]
["Age on insurance date (age on birthday nearest the effective date)"]
["Age on January 1st or July 1st"]
[]
[]
["Individual rating only"]
["Composite rating available"]