{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["EnableMacros","Rate Table","names"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":9,"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"]}
["Rates 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":"Rate Table","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":true,"merged":[[10,6,10,12],[5,2,5,4]],"flags":["formulas_cached_only"]}
["Rates Table Template v1.0","Instructions: ","All fields with an asterisk (*) are required."]
[null,null,"Enter the rate data for subscriber type in the table below using one row per plan."]
[null,null,"Enter a rate for every age band for each plan."]
[null,null,"If Family Option is taken, enter rates for all Family Tier variances."]
[null,null,"If Tobacco User/Non-Tobacco user, enter Non-Tobacco and Tobacco rate"]
["Issuer ID*"]
["Federal TIN*"]
["Rate Effective Date*"]
["Rate Expiration Date*"]
[]
[{"$nulls":6},"Family Tier"]
["Plan ID*","Rating Area ID*","Tobacco*","Age*","Individual Rate*","Individual Tobacco Rate*","Couple *","Primary Subscriber and One Dependent*","Primary Subscriber and Two Dependents*","Primary Subscriber and Three or More Dependents*","Couple and One Dependent*","Couple and Two Dependents*","Couple and Three or More Dependents*"]
["Required:\nEnter the 14-character Plan ID","Required:\nSelect the Rating Area ID","Require:\nSelect if Tobacco use of subscriber is used to determine if a person is eligible for a rate from a plan","Required:\nSelect the age of a subscriber eligible for the rate","Required:\nEnter the rate of an Individual Non-Tobacco or No Preference enrollee on a plan","Required:\nEnter the rate of an Individual tobacco enrollee on a plan","Required:\nEnter the rate of a couple based on the pairing of a primary enrollee and a secondary subscriber (e.g. husband and spouse)","Required:\nEnter the rate of a family based on a single parent with one dependent","Required:\nEnter the rate of a family based on a single parent with two dependents","Required:\nEnter the rate of a family based on a single parent with three or more dependents","Required:\nEnter the rate of a family based on a couple with one dependent","Required:\nEnter the rate of a family based on a couple with two dependents","Required:\nEnter the rate of a family based on a couple with three or more dependents"]

{"sheet":"names","index":2,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["Rating Area 1","Family Option","Tobacco User/Non-Tobacco User"]
["Rating Area 2","0-20","No Preference"]
["Rating Area 3",21]
["Rating Area 4",22]
["Rating Area 5",23]
["Rating Area 6",24]
["Rating Area 7",25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,"65 and over"]