{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","URL Template","lookups"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Instructions","index":0,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,0,10,7]]}
["Workbook Instructions"]
[]
["Instructions for URL Template sheet:"]
["To validate, select the Validate button or press Ctrl + Shift + I."]
["Upon selecting Validate, rows in the template will be filtered to display only those containing errors.  "]
["To remove the error filter and display all rows of data, select the Show Data button or press Ctrl + Shift + S"]
[]
["To validate and finalize, select the Finalize button or press Ctrl + Shift + F."]
["        The XML file will be saved in the same folder as this template"]
[]
["This template should contain all Plan IDs found on the Plan Benefits and Rates templates.  Failure to provide all plans will result in a submission validation error.  "]
["Values for the URL fields of each Plan ID must be entered.  If there is no URL value, enter N/A."]
[]
["When ready to begin using the template, select the Begin button below or press Ctrl + Shift + B or manually navigate to the next tab titled URL Template."]

{"sheet":"URL Template","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["2021 RBIS URL CollectionTemplate v1.0"]
["HIOS Issuer ID *",12345]
["Market Coverage *","Small Group"]
[]
["URL data or an indication of \"N/A, NA, or Not Applicable\" must be provided for all Plan IDs submitted to RBIS",null,null,"-"]
["For data collection within RBIS, only Off Exchange plans (variant type 00) are collected here."]
["* indicates the field is required"]
[]
[]
["Plan ID *","Plan-level payment URL *","Off Exchange Plan Variant (00) Summary of Benefits and Coverage URL *","Off Exchange Plan Variant (00) Brochure URL *"]
["23456VA0100999","https://www.insuranceprovider.com/abc.html","https://www.insuranceprovider.com/planxyz_sbc.pdf","https://www.insuranceprovider.com/brochure.pdf"]
["12345VA0100001","https://www.insuranceprovider.com/abc.html","https://www.insuranceprovider.com/planxyz_sbc.pdf",null,"N"]
["12345VA0100002","https://www.insuranceprovider.com/abc.html",null,"https://www.insuranceprovider.com/brochure.pdf","N"]
["12345VA0100003",null,"https://www.insuranceprovider.com/planxyz_sbc.pdf","https://www.insuranceprovider.com/brochure.pdf","Y"]
["12345VA0100004","https://www.insuranceprovider.com/abc.html","https://www.insuranceprovider.com/planxyz_sbc.pdf","https://www.insuranceprovider.com/brochure.pdf","N"]
["12345VA0100005","na","N/A","Not Applicable","Y"]
["12345VA0100002","https://www.insuranceprovider.com/abc.html","https://www.insuranceprovider.com/planxyz_sbc.pdf","https://www.insuranceprovider.com/brochure.pdf","Y"]
[null,null,null,null,"N"]

{"sheet":"lookups","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Market Coverage",null,null,"Validation Error Messages"]
["Individual",null,null,"ERROR:  Issuer ID must contain 5 numeric characters"]
["Small Group",null,null,"ERROR:  Market Coverage must be Individual or Small Group"]
[null,null,null,"ERROR:  The Plan ID is not in the proper format:\n1)   Plan ID must be 14 characters\n2)   Plan ID must be in the following format (example 12345VA1234567): \n      a.  5 digit Issuer ID followed by \n      b.  2 digit State abbreviation followed by\n      c.  7 numeric characters \n3)   The Issuer ID must match the Issuer ID in Cell B2"]
[null,null,null,"ERROR:  URL field contains one or more of the following errors:\n1)   URL cannot be blank, enter N/A if there is no value\n2)   URL cannot contain the following invalid characters @ ^ * ( ) < > \\ | ` ‘ { } [ ]\n3)   URL must be a properly formatted URL. Examples of a properly formatted URL include:\n       a.   http://www.test.com/linkdetails.html\n       b.   https://www.test.com/docinfo.pdf"]