{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["EnableMacros","Business Rules","Names"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":11,"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","formulas":"cached_only"}

{"sheet":"EnableMacros","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15]],"flags":["formulas_cached_only"]}
["Business Rules Template"]
[]
[]
[]
[]
[null,"If you are seeing this sheet, macros are not enabled, please follow the following steps: "]
[]
[]
[null,"If using Excel 2003:"]
[null,"1. Set the macro security setting to Medium (Recommended) or Low.  To change the macro security setting, select Tools-> "]
[null,"       Macro->Security."]
[null,"2. If the macro security setting is set to Medium, select Enable Macros when opening the workbook."]
[]
[]
[null,"If using Excel 2007 and 2010:"]
[null,"1. Set the macro security setting to Disable macros with notifications (Recommended) or Enable all macros. To change"]
[null,"    the macro security setting, click the Office Button and select Excel Option -> Trust Center -> Trust Center Settings -> "]
[null,"    Macro Settings."]
[null,"2. If the macro security setting is set to Disable macros with notifications, click the Option button and select Enable this "]
[null,"    content."]
[]
[]
[null,"Note: This screen will flash momentarily when you save or finalize this workbook."]

{"sheet":"Business Rules","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["Business Rules Template v1.0",null,"Instructions: ","Enter the Issuer Rule on the first row (no Product ID or Plan ID)."]
[null,null,null,"Enter only a Product ID for Product Rules."]
[null,null,null,"Enter only a Plan ID for Plan Rules."]
[null,null,null,"For each Product rule, enter only the Product ID and the business rules that differ from the Issuer Rule."]
[null,null,null,"For each Plan rule, enter only the Plan ID and the business rules that differ from the Product or Issuer Rule"]
[]
["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?"]

{"sheet":"Names","index":2,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["There are rates specifically for couples and for families (not just addition of individual rates)","Yes",1,"Click to select","Yes","Age on effective date","No Tobacco use for at least [x] months","Spouse"]
["A different rate (specifically for parties of two or more)for each enrollee is added together","Not Applicable",2,null,"No","Age on January 1st of the effective date year","Not Applicable","Father or Mother"]
[null,null,"3 or more",null,null,"Age on insurance date (age on birthday nearest the effective date)",null,"Grandfather or Grandmother"]
[{"$nulls":5},"Age on January 1st or July 1st ",null,"Grandson or Granddaughter"]
[{"$nulls":7},"Uncle or Aunt"]
[{"$nulls":7},"Nephew or Niece"]
[{"$nulls":7},"Cousin"]
[{"$nulls":7},"Adopted Child"]
[{"$nulls":7},"Foster Child"]
[{"$nulls":7},"Son-in-law or Daughter-in-law"]
[{"$nulls":7},"Brother-in-law or Sister-in-law"]
[{"$nulls":7},"Father-in-law or Mother-in-law"]
[{"$nulls":7},"Brother or Sister"]
[{"$nulls":7},"Ward"]
[{"$nulls":7},"Stepparent"]
[{"$nulls":7},"Stepson or Stepdaughter"]
[{"$nulls":7},"Self"]
[{"$nulls":7},"Child"]
[{"$nulls":7},"Sponsored Dependent"]
[{"$nulls":7},"Dependent on a Minor Dependent"]
[{"$nulls":7},"Ex-Spouse"]
[{"$nulls":7},"Guardian"]
[{"$nulls":7},"Court Appointed Guardian"]
[{"$nulls":7},"Collateral Dependent"]
[{"$nulls":7},"Life Partner"]
[{"$nulls":7},"Annultant"]
[{"$nulls":7},"Trustee"]
[{"$nulls":7},"Other Relationship"]
[{"$nulls":7},"Other Relative"]