{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Data","Lookup"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["2019 Annual Network Adequcy Analysis - Dental Provider Data Submission Instructions"]
[]
["Please complete the Data tab for all the provider types/specialties listed in the Lookup tab, keeping in mind the following guidance:"]
["1 row per provider / address / specialty"]
["Provider network should be representative of the contracted network as of April 1, 2020."]
["Plan Sponsor Name - Must be the exactly the same in each cell. Note, you must also enter the same Plan Sponsor Name in the Lookup tab under Valid Plan Sponsor Name (cell A2)."]
["NPI - Must be 10 characters"]
["FacilityName - Can be left blank on Data tab."]
["FirstName - Must be valid specialty code from column C on Lookup tab and FirstName cannot be blank on Data tab"]
["LastName - Must be valid specialty code from column C on Lookup tab and LastName cannot be blank on Data tab"]
["Phone - Must be 10 characters"]
["Address - Cannot be blank"]
["Address2 - No validations"]
["City - Cannot be blank"]
["State - Must be 2 characters"]
["SpecialtyCode - Must be valid code from column C on Lookup tab."]
["SpecialtyDescription - Cannot be blank"]
[]
["Data Validation: Upon completion of populating the template, in cell A1, you should see a Validation button. Please select the button and confirm all cells pass the validation. If necessary, please correct any red highlighted cells and rerun the validation."]

{"sheet":"Data","index":1,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Please correct any red highlighted cells and rerun validation"]
["Plan Sponsor Name","NPI","Facility Name","First Name","Last Name","Phone","Address","Address2","City","State ","ZIP","Specialty Code","Specialty Description"]

{"sheet":"Lookup","index":2,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Valid Plan Sponsor Name",null,"Valid Provider SpecCode","Provider Specialty Description",null,"Valid Facility SpecCode","Facility Specialty Description",null,"All SpecCodes"]
[null,null,"P201","Pediatric Dentist",null,null,null,null,"P201"]
[null,null,"201","General Dentists",null,null,null,null,"201"]
[null,null,"202","Orthodontist",null,null,null,null,"202"]