{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover Page","Vision","NA Standards","Reference","Help","Utility"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"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":"Cover Page","index":0,"n_rows":270,"n_cols":12,"rows_kept":270,"cut":false,"hidden":false,"merged":[[9,6,9,9],[1,1,1,11],[6,6,7,9],[10,3,10,4],[11,3,13,4],[3,3,3,4],[3,6,3,9],[4,6,4,9],[5,6,5,9],[10,6,10,9],[8,6,8,9]]}
["Help"]
[null,"Network Compliance and Waiver Request"]
[]
[null,null,null,"Filing information",null,null,"Service area designation instructions"]
[null,null,null,"Insurer name",null,null,"Use the check boxes below to select the counties within the network's service area.  "]
[null,null,null,"NAIC number",null,null,"At least one county must be selected for other worksheets to work properly."]
[null,null,null,"Network name",null,null,"For counties with fewer than three occurrences on the Vision sheet, the displayed count of occurrences will highlight red."]
[null,null,null,"Network ID"]
[null,null,null,"SERFF tracking No",null,null,"Counties appear bold if they are on Vision but unchecked here. "]
[]
[null,null,null,null,null,null,{"$f":"IF(GetExcelVersion()>=13,\"\", \"This workbook is best with Excel 2013 or higher.\")","v":""}]
[]
[]
[null,null,null,null,null,null,"Service Area","County","Specialties Count*","County Designation"]
[null,null,null,null,null,null,false,"Anderson",{"$f":"IF(COUNTIF(Vision[County],countyNames)=0,\"N/A\",COUNTIF(Vision[County],countyNames))","v":"N/A"},"Micro"]
[null,null,null,null,null,null,false,"Andrews","N/A","Rural"]
[null,null,null,null,null,null,false,"Angelina","N/A","Metro"]
[null,null,null,null,null,null,false,"Aransas","N/A","Micro"]
[null,null,null,null,null,null,false,"Archer","N/A","CEAC"]
[null,null,null,null,null,null,false,"Armstrong","N/A","CEAC"]
[null,null,null,null,null,null,false,"Atascosa","N/A","Micro"]
[null,null,null,null,null,null,false,"Austin","N/A","Rural"]
[null,null,null,null,null,null,false,"Bailey","N/A","CEAC"]
[null,null,null,null,null,null,false,"Bandera","N/A","Rural"]
[null,null,null,null,null,null,false,"Bastrop","N/A","Metro"]
[null,null,null,null,null,null,false,"Baylor","N/A","CEAC"]
[null,null,null,null,null,null,false,"Bee","N/A","Rural"]
[null,null,null,null,null,null,false,"Bell","N/A","Metro"]
[null,null,null,null,null,null,false,"Bexar","N/A","Large Metro"]
[null,null,null,null,null,null,false,"Blanco","N/A","Rural"]
[null,null,null,null,null,null,false,"Borden","N/A","CEAC"]
[null,null,null,null,null,null,false,"Bosque","N/A","Rural"]
[null,null,null,null,null,null,false,"Bowie","N/A","Metro"]
[null,null,null,null,null,null,false,"Brazoria","N/A","Metro"]
[null,null,null,null,null,null,false,"Brazos","N/A","Metro"]
[null,null,null,null,null,null,false,"Brewster","N/A","CEAC"]
[null,null,null,null,null,null,false,"Briscoe","N/A","CEAC"]
[null,null,null,null,null,null,false,"Brooks","N/A","CEAC"]
[null,null,null,null,null,null,false,"Brown","N/A","Rural"]
[null,null,null,null,null,null,false,"Burleson","N/A","Rural"]
[null,null,null,null,null,null,false,"Burnet","N/A","Micro"]
[null,null,null,null,null,null,false,"Caldwell","N/A","Micro"]
[null,null,null,null,null,null,false,"Calhoun","N/A","Rural"]
[null,null,null,null,null,null,false,"Callahan","N/A","Rural"]
[null,null,null,null,null,null,false,"Cameron","N/A","Metro"]
[null,null,null,null,null,null,false,"Camp","N/A","Micro"]
[null,null,null,null,null,null,false,"Carson","N/A","CEAC"]
[null,null,null,null,null,null,false,"Cass","N/A","Rural"]
[null,null,null,null,null,null,false,"Castro","N/A","CEAC"]
[null,null,null,null,null,null,false,"Chambers","N/A","Micro"]
[null,null,null,null,null,null,false,"Cherokee","N/A","Micro"]
[null,null,null,null,null,null,false,"Childress","N/A","CEAC"]
[null,null,null,null,null,null,false,"Clay","N/A","CEAC"]
[null,null,null,null,null,null,false,"Cochran","N/A","CEAC"]
[null,null,null,null,null,null,false,"Coke","N/A","CEAC"]
[null,null,null,null,null,null,false,"Coleman","N/A","CEAC"]
[null,null,null,null,null,null,false,"Collin","N/A","Large Metro"]
[null,null,null,null,null,null,false,"Collingsworth","N/A","CEAC"]
[null,null,null,null,null,null,false,"Colorado","N/A","Rural"]
[null,null,null,null,null,null,false,"Comal","N/A","Metro"]
[null,null,null,null,null,null,false,"Comanche","N/A","Rural"]
[null,null,null,null,null,null,false,"Concho","N/A","CEAC"]
[null,null,null,null,null,null,false,"Cooke","N/A","Rural"]
[null,null,null,null,null,null,false,"Coryell","N/A","Micro"]
[null,null,null,null,null,null,false,"Cottle","N/A","CEAC"]
[null,null,null,null,null,null,false,"Crane","N/A","CEAC"]
[null,null,null,null,null,null,false,"Crockett","N/A","CEAC"]
[null,null,null,null,null,null,false,"Crosby","N/A","CEAC"]
[null,null,null,null,null,null,false,"Culberson","N/A","CEAC"]
[null,null,null,null,null,null,false,"Dallam","N/A","CEAC"]
[null,null,null,null,null,null,false,"Dallas","N/A","Large Metro"]
[null,null,null,null,null,null,false,"Dawson","N/A","Rural"]
[null,null,null,null,null,null,false,"DeWitt","N/A","Rural"]
[null,null,null,null,null,null,false,"Deaf Smith","N/A","Rural"]
[null,null,null,null,null,null,false,"Delta","N/A","Metro"]
[null,null,null,null,null,null,false,"Denton","N/A","Rural"]
[null,null,null,null,null,null,false,"Dickens","N/A","CEAC"]
[null,null,null,null,null,null,false,"Dimmit","N/A","CEAC"]
[null,null,null,null,null,null,false,"Donley","N/A","CEAC"]
[null,null,null,null,null,null,false,"Duval","N/A","CEAC"]
[null,null,null,null,null,null,false,"Eastland","N/A","Rural"]
[null,null,null,null,null,null,false,"Ector","N/A","Metro"]
[null,null,null,null,null,null,false,"Edwards","N/A","CEAC"]
[null,null,null,null,null,null,false,"El Paso","N/A","Metro"]
[null,null,null,null,null,null,false,"Ellis","N/A","Metro"]
[null,null,null,null,null,null,false,"Erath","N/A","Rural"]
[null,null,null,null,null,null,false,"Falls","N/A","Rural"]
[null,null,null,null,null,null,false,"Fannin","N/A","Rural"]
[null,null,null,null,null,null,false,"Fayette","N/A","Rural"]
[null,null,null,null,null,null,false,"Fisher","N/A","CEAC"]
[null,null,null,null,null,null,false,"Floyd","N/A","CEAC"]
[null,null,null,null,null,null,false,"Foard","N/A","CEAC"]
[null,null,null,null,null,null,false,"Fort Bend","N/A","Metro"]
[null,null,null,null,null,null,false,"Franklin","N/A","Rural"]
[null,null,null,null,null,null,false,"Freestone","N/A","Rural"]
[null,null,null,null,null,null,false,"Frio","N/A","Rural"]
[null,null,null,null,null,null,false,"Gaines","N/A","Rural"]
[null,null,null,null,null,null,false,"Galveston","N/A","Metro"]
[null,null,null,null,null,null,false,"Garza","N/A","CEAC"]
[null,null,null,null,null,null,false,"Gillespie","N/A","Rural"]
[null,null,null,null,null,null,false,"Glasscock","N/A","CEAC"]
[null,null,null,null,null,null,false,"Goliad","N/A","CEAC"]
[null,null,null,null,null,null,false,"Gonzales","N/A","Rural"]
[null,null,null,null,null,null,false,"Gray","N/A","Rural"]
[null,null,null,null,null,null,false,"Grayson","N/A","Metro"]
[null,null,null,null,null,null,false,"Gregg","N/A","Metro"]
[null,null,null,null,null,null,false,"Grimes","N/A","Rural"]
[null,null,null,null,null,null,false,"Guadalupe","N/A","Metro"]
[null,null,null,null,null,null,false,"Hale","N/A","Rural"]
[null,null,null,null,null,null,false,"Hall","N/A","CEAC"]
[null,null,null,null,null,null,false,"Hamilton","N/A","CEAC"]
[null,null,null,null,null,null,false,"Hansford","N/A","CEAC"]
[null,null,null,null,null,null,false,"Hardeman","N/A","CEAC"]
[null,null,null,null,null,null,false,"Hardin","N/A","Micro"]
[null,null,null,null,null,null,false,"Harris","N/A","Large Metro"]
[null,null,null,null,null,null,false,"Harrison","N/A","Micro"]
[null,null,null,null,null,null,false,"Hartley","N/A","CEAC"]
[null,null,null,null,null,null,false,"Haskell","N/A","CEAC"]
[null,null,null,null,null,null,false,"Hays","N/A","Metro"]
[null,null,null,null,null,null,false,"Hemphill","N/A","CEAC"]
[null,null,null,null,null,null,false,"Henderson","N/A","Micro"]
[null,null,null,null,null,null,false,"Hidalgo","N/A","Metro"]
[null,null,null,null,null,null,false,"Hill","N/A","Rural"]
[null,null,null,null,null,null,false,"Hockley","N/A","Rural"]
[null,null,null,null,null,null,false,"Hood","N/A","Metro"]
[null,null,null,null,null,null,false,"Hopkins","N/A","Rural"]
[null,null,null,null,null,null,false,"Houston","N/A","Rural"]
[null,null,null,null,null,null,false,"Howard","N/A","Rural"]
[null,null,null,null,null,null,false,"Hudspeth","N/A","CEAC"]
[null,null,null,null,null,null,false,"Hunt","N/A","Metro"]
[null,null,null,null,null,null,false,"Hutchinson","N/A","Rural"]
[null,null,null,null,null,null,false,"Irion","N/A","CEAC"]
[null,null,null,null,null,null,false,"Jack","N/A","CEAC"]
[null,null,null,null,null,null,false,"Jackson","N/A","Rural"]
[null,null,null,null,null,null,false,"Jasper","N/A","Rural"]
[null,null,null,null,null,null,false,"Jeff Davis","N/A","CEAC"]
[null,null,null,null,null,null,false,"Jefferson","N/A","Metro"]
[null,null,null,null,null,null,false,"Jim Hogg","N/A","CEAC"]
[null,null,null,null,null,null,false,"Jim Wells","N/A","Rural"]
[null,null,null,null,null,null,false,"Johnson","N/A","Metro"]
[null,null,null,null,null,null,false,"Jones","N/A","Rural"]
[null,null,null,null,null,null,false,"Karnes","N/A","Rural"]
[null,null,null,null,null,null,false,"Kaufman","N/A","Metro"]
[null,null,null,null,null,null,false,"Kendall","N/A","Micro"]
[null,null,null,null,null,null,false,"Kenedy","N/A","CEAC"]
[null,null,null,null,null,null,false,"Kent","N/A","CEAC"]
[null,null,null,null,null,null,false,"Kerr","N/A","Micro"]
[null,null,null,null,null,null,false,"Kimble","N/A","CEAC"]
[null,null,null,null,null,null,false,"King","N/A","CEAC"]
[null,null,null,null,null,null,false,"Kinney","N/A","CEAC"]
[null,null,null,null,null,null,false,"Kleberg","N/A","Rural"]
[null,null,null,null,null,null,false,"Knox","N/A","CEAC"]
[null,null,null,null,null,null,false,"La Salle","N/A","Micro"]
[null,null,null,null,null,null,false,"Lamar","N/A","Rural"]
[null,null,null,null,null,null,false,"Lamb","N/A","Rural"]
[null,null,null,null,null,null,false,"Lampasas","N/A","CEAC"]
[null,null,null,null,null,null,false,"Lavaca","N/A","Rural"]
[null,null,null,null,null,null,false,"Lee","N/A","Rural"]
[null,null,null,null,null,null,false,"Leon","N/A","Rural"]
[null,null,null,null,null,null,false,"Liberty","N/A","Micro"]
[null,null,null,null,null,null,false,"Limestone","N/A","Rural"]
[null,null,null,null,null,null,false,"Lipscomb","N/A","CEAC"]
[null,null,null,null,null,null,false,"Live Oak","N/A","Rural"]
[null,null,null,null,null,null,false,"Llano","N/A","Rural"]
[null,null,null,null,null,null,false,"Loving","N/A","CEAC"]
[null,null,null,null,null,null,false,"Lubbock","N/A","Metro"]
[null,null,null,null,null,null,false,"Lynn","N/A","CEAC"]
[null,null,null,null,null,null,false,"Madison","N/A","CEAC"]
[null,null,null,null,null,null,false,"Marion","N/A","Metro"]
[null,null,null,null,null,null,false,"Martin","N/A","CEAC"]
[null,null,null,null,null,null,false,"Mason","N/A","Rural"]
[null,null,null,null,null,null,false,"Matagorda","N/A","Rural"]
[null,null,null,null,null,null,false,"Maverick","N/A","CEAC"]
[null,null,null,null,null,null,false,"McCulloch","N/A","CEAC"]
[null,null,null,null,null,null,false,"McLennan","N/A","Rural"]
[null,null,null,null,null,null,false,"McMullen","N/A","Micro"]
[null,null,null,null,null,null,false,"Medina","N/A","Micro"]
[null,null,null,null,null,null,false,"Menard","N/A","CEAC"]
[null,null,null,null,null,null,false,"Midland","N/A","Metro"]
[null,null,null,null,null,null,false,"Milam","N/A","Rural"]
[null,null,null,null,null,null,false,"Mills","N/A","CEAC"]
[null,null,null,null,null,null,false,"Mitchell","N/A","CEAC"]
[null,null,null,null,null,null,false,"Montague","N/A","Rural"]
[null,null,null,null,null,null,false,"Montgomery","N/A","Metro"]
[null,null,null,null,null,null,false,"Moore","N/A","Rural"]
[null,null,null,null,null,null,false,"Morris","N/A","Rural"]
[null,null,null,null,null,null,false,"Motley","N/A","CEAC"]
[null,null,null,null,null,null,false,"Nacogdoches","N/A","Micro"]
[null,null,null,null,null,null,false,"Navarro","N/A","Micro"]
[null,null,null,null,null,null,false,"Newton","N/A","Rural"]
[null,null,null,null,null,null,false,"Nolan","N/A","Rural"]
[null,null,null,null,null,null,false,"Nueces","N/A","Metro"]
[null,null,null,null,null,null,false,"Ochiltree","N/A","Rural"]
[null,null,null,null,null,null,false,"Oldham","N/A","CEAC"]
[null,null,null,null,null,null,false,"Orange","N/A","Metro"]
[null,null,null,null,null,null,false,"Palo Pinto","N/A","Rural"]
[null,null,null,null,null,null,false,"Panola","N/A","Rural"]
[null,null,null,null,null,null,false,"Parker","N/A","Metro"]
[null,null,null,null,null,null,false,"Parmer","N/A","Rural"]
[null,null,null,null,null,null,false,"Pecos","N/A","CEAC"]
[null,null,null,null,null,null,false,"Polk","N/A","Micro"]
[null,null,null,null,null,null,false,"Potter","N/A","Metro"]
[null,null,null,null,null,null,false,"Presidio","N/A","CEAC"]
[null,null,null,null,null,null,false,"Rains","N/A","Micro"]
[null,null,null,null,null,null,false,"Randall","N/A","Metro"]
[null,null,null,null,null,null,false,"Reagan","N/A","CEAC"]
[null,null,null,null,null,null,false,"Real","N/A","CEAC"]
[null,null,null,null,null,null,false,"Red River","N/A","Rural"]
[null,null,null,null,null,null,false,"Reeves","N/A","CEAC"]
[null,null,null,null,null,null,false,"Refugio","N/A","CEAC"]
[null,null,null,null,null,null,false,"Roberts","N/A","CEAC"]
[null,null,null,null,null,null,false,"Robertson","N/A","Rural"]
[null,null,null,null,null,null,false,"Rockwall","N/A","Metro"]
[null,null,null,null,null,null,false,"Runnels","N/A","CEAC"]
[null,null,null,null,null,null,false,"Rusk","N/A","Micro"]
[null,null,null,null,null,null,false,"Sabine","N/A","Rural"]
[null,null,null,null,null,null,false,"San Augustine","N/A","Rural"]
[null,null,null,null,null,null,false,"San Jacinto","N/A","Rural"]
[null,null,null,null,null,null,false,"San Patricio","N/A","Metro"]
[null,null,null,null,null,null,false,"San Saba","N/A","CEAC"]
[null,null,null,null,null,null,false,"Schleicher","N/A","CEAC"]
[null,null,null,null,null,null,false,"Scurry","N/A","Rural"]
[null,null,null,null,null,null,false,"Shackelford","N/A","CEAC"]
[null,null,null,null,null,null,false,"Shelby","N/A","Rural"]
[null,null,null,null,null,null,false,"Sherman","N/A","CEAC"]
[null,null,null,null,null,null,false,"Smith","N/A","Metro"]
[null,null,null,null,null,null,false,"Somervell","N/A","Rural"]
[null,null,null,null,null,null,false,"Starr","N/A","Micro"]
[null,null,null,null,null,null,false,"Stephens","N/A","Rural"]
[null,null,null,null,null,null,false,"Sterling","N/A","CEAC"]
[null,null,null,null,null,null,false,"Stonewall","N/A","CEAC"]
[null,null,null,null,null,null,false,"Sutton","N/A","CEAC"]
[null,null,null,null,null,null,false,"Swisher","N/A","CEAC"]
[null,null,null,null,null,null,false,"Tarrant","N/A","Large Metro"]
[null,null,null,null,null,null,false,"Taylor","N/A","Metro"]
[null,null,null,null,null,null,false,"Terrell","N/A","CEAC"]
[null,null,null,null,null,null,false,"Terry","N/A","Rural"]
[null,null,null,null,null,null,false,"Throckmorton","N/A","CEAC"]
[null,null,null,null,null,null,false,"Titus","N/A","Micro"]
[null,null,null,null,null,null,false,"Tom Green","N/A","Micro"]
[null,null,null,null,null,null,false,"Travis","N/A","Large Metro"]
[null,null,null,null,null,null,false,"Trinity","N/A","Rural"]
[null,null,null,null,null,null,false,"Tyler","N/A","Rural"]
[null,null,null,null,null,null,false,"Upshur","N/A","Micro"]
[null,null,null,null,null,null,false,"Upton","N/A","CEAC"]
[null,null,null,null,null,null,false,"Uvalde","N/A","Rural"]
[null,null,null,null,null,null,false,"Val Verde","N/A","Rural"]
[null,null,null,null,null,null,false,"Van Zandt","N/A","Micro"]
[null,null,null,null,null,null,false,"Victoria","N/A","Metro"]
[null,null,null,null,null,null,false,"Walker","N/A","Metro"]
[null,null,null,null,null,null,false,"Waller","N/A","Metro"]
[null,null,null,null,null,null,false,"Ward","N/A","Rural"]
[null,null,null,null,null,null,false,"Washington","N/A","Micro"]
[null,null,null,null,null,null,false,"Webb","N/A","Metro"]
[null,null,null,null,null,null,false,"Wharton","N/A","Rural"]
[null,null,null,null,null,null,false,"Wheeler","N/A","CEAC"]
[null,null,null,null,null,null,false,"Wichita","N/A","Metro"]
[null,null,null,null,null,null,false,"Wilbarger","N/A","Rural"]
[null,null,null,null,null,null,false,"Willacy","N/A","Rural"]
[null,null,null,null,null,null,false,"Williamson","N/A","Metro"]
[null,null,null,null,null,null,false,"Wilson","N/A","Micro"]
[null,null,null,null,null,null,false,"Winkler","N/A","CEAC"]
[null,null,null,null,null,null,false,"Wise","N/A","Micro"]
[null,null,null,null,null,null,false,"Wood","N/A","Micro"]
[null,null,null,null,null,null,false,"Yoakum","N/A","CEAC"]
[null,null,null,null,null,null,false,"Young","N/A","Rural"]
[null,null,null,null,null,null,false,"Zapata","N/A","Rural"]
[null,null,null,null,null,null,false,"Zavala","N/A","CEAC"]
[]
[null," ",null,null,null,null,null,null,null,null,null," "]

{"sheet":"Vision","index":1,"n_rows":8,"n_cols":26,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Vision Help"]
[]
[]
[null,"TIC §1301.00553(b)","TIC §1301.0055","TIC §1301.0055","TIC §1301.0055(b)","TIC §1301.0055(b)(3)","TIC §1301.00555","TIC §1301.0055(a)(5)","TIC §1301.0055(a)(3)","TIC §1301.0056(e)(4)","TIC §1301.0055(a)(6)","TIC §1301.0055(a)(3)",null,"TIC §1301.0055"]
[null,"28 TAC §3.3712(c)(2)","28 TAC §3.3712(c)(2)","28 TAC §3.3712(c)(2)(A)","28 TAC §3.3712(c)(2)(A)","28 TAC §3.3712(c)(2)(B)","28 TAC §3.3712(c)(2)(B)","28 TAC §3.3712(c)(2)(C)(ii)","28 TAC §3.3712(c)(2)(C)(i)","28 TAC §3.3712(c)(2)(C)(iii)","28 TAC §3.3712(c)(2)(C)(iii)","28 TAC §3.3712(c)(2)(C)(iv)",null,"28 TAC §3.3712(c)(2)(c )"]
[null,"County designation","County","Specialty type","Number of preferred providers within the county","Percentage of insureds with sufficient choice","Compliant with appointment wait time","Years a waiver for this deficiency has been granted","Reason preferred providers are not available","Number of non-contracted physicians and providers available within the service area and applicable time and distance standards that could resolve the deficiency","Source used to identify available physicians and providers","Access plan summary","Comments","Network adequacy status","SERFF tracking No.","NAIC No.","Insurer","Network ID","Network name","Hearing Date","Waiver decision date","Waiver start date","Waiver end date","Waiver status","Good faith met","Good faith deficiency"]
[null,"CountyType","County","Specialty","Providers","SufficientPercent","WaitComply","WaiverYears","ProviderReason","ResolvedCount","Source","Summary","Comments","StandardsMet","SERFFTracking","NAICID","Insurer","NetworkID","NetworkName","HearingDate","DecisionDate","StartDate","EndDate","WaiverStatus","GoodFaithMet","GoodFaithDeficient"]
[null,{"$f":"IF(Vision[[#This Row],[County]]=\"\",\"\",(_xlfn.XLOOKUP(Vision[[#This Row],[County]],CountyTable[County],CountyTable[CountyDesignation],\"Error\")))","v":""},null,null,null,null,"N/A",null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(Vision[[#This Row],[SufficientPercent]]), ISBLANK(Vision[[#This Row],[WaitComply]])), \"\",\n    IF(AND(LEFT(Vision[[#This Row],[ProviderReason]], 20) = \"The covered services\", LEFT(Vision[[#This Row],[Summary]], 23) = \"Covered vision services\"), \"N/A\",\n        IF(AND(Vision[[#This Row],[SufficientPercent]]=1, OR(Vision[[#This Row],[WaitComply]]=\"Yes\", Vision[[#This Row],[WaitComply]]=\"N/A\")),\n            \"Adequate\",\n            IF(OR(Vision[[#This Row],[WaitComply]]=\"N/A - No Enrollees\", Vision[[#This Row],[ProviderReason]] = \"N/A - No Enrollees\"), \"N/A - No Enrollees\",\n                IF(OR(AND(Vision[[#This Row],[WaitComply]]=\"No\", LEFT(Vision[[#This Row],[ProviderReason]], 12)=\"Insufficient\"), LEFT(Vision[[#This Row],[Summary]], 12)=\"Insufficient\"),\n                    \"Waiver requested due to insufficient number of available providers\",\n                    IF(OR(Vision[[#This Row],[SufficientPercent]]<1, Vision[[#This Row],[WaitComply]]=\"No\"),\n                        \"Waiver Requested\",\n                        \"ERROR - Uncategorized Case\"\n                    )\n                )\n            )\n        )\n    )\n)","v":""},{"$f":"IF(SERFFTracking<>\"\",SERFFTracking,\"\")","v":""},{"$f":"IF(NAICID<>\"\",NAICID,\"\")","v":""},{"$f":"IF(InsurerName<>\"\",InsurerName,\"\")","v":""},{"$f":"IF(NetworkID<>\"\",NetworkID,\"\")","v":""},{"$f":"IF(NetworkName<>\"\",NetworkName,\"\")","v":""}]

{"sheet":"NA Standards","index":2,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,11],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11]]}
["Standards Help"]
[null,"Network Adequacy Time and Distance Standards"]
[null,null,"Maximum Time and Distance Standards (Time is measured in minutes and distance is measured in miles)"]
[null,"Specialty Types","Large Metro County",null,"Metro County",null,"Micro County",null,"Rural County",null,"Counties with Extreme Access Considerations (CEAC)"]
[null,null,"Time","Distance","Time","Distance","Time","Distance","Time ","Distance","Time","Distance"]
[null,"Ophthalmologist",20,10,30,20,50,35,75,60,95,85]
[null,"Optometrist","NA",75,"NA",75,"NA",75,"NA",75,"NA",75]
[null,"Therapeutic Optometrist","NA",75,"NA",75,"NA",75,"NA",75,"NA",75]

{"sheet":"Reference","index":3,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Vision Reasons preferred providers are not available"]
[null,"Available provider(s) declined to contract because insurer is too new/unknown"]
[null,"Available provider(s) do not contract with commercial insurance companies"]
[null,"In active contract negotiations"]
[null,"Insufficient number of available providers"]
[null,"Unable to agree on reimbursement rate"]
[null,"Unable to contact provider/Provider did not respond to outreach attempts"]
[null,"Other (explain in comment column)"]
[null,"The covered services are available within applicable network adequacy standards through a combination of preferred optometrists, ophthalmologists, and therapeutic optometrists."]
[]
[null,"Vision Access Plan Summary"]
[null,"Covered vision services are available within the time and distance network adequacy standards applicable to ophthalmology specialists under Insurance Code §1301.00553 through a combination of in-network optometrists, ophthalmologists, and therapeutic optometrists."]
[null,"Insufficient number of optometrist, ophthalmologist, or therapeutic optometrist providers delivering covered vision services are currently practicing within the applicable network adequacy standards. Procedures are in place for insurer to comply with the access plan requirements in 28 TAC §3.3707."]
[null,"Not Applicable - No enrollees currently reside in the county. For any new enrollees residing within the county, insurer will comply with the access plan requirements in 28 TAC §3.3707."]
[null,"Unable to contract with available providers. Procedures are in place for insurer to comply with the access plan requirements in 28 TAC §3.3707"]

{"sheet":"Help","index":4,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,2,37,12],[28,3,28,4],[28,5,28,13],[14,2,14,12],[26,3,26,4],[32,2,32,12],[25,3,25,4],[24,2,24,4],[15,2,15,8],[18,2,19,8],[20,2,21,8],[16,2,16,12],[27,5,27,13],[34,2,34,12],[27,3,27,4],[12,2,12,12],[17,2,17,12],[26,5,26,13],[25,5,25,13],[13,2,13,8],[15,9,15,12],[18,9,19,12],[20,9,21,12],[13,9,13,12],[11,2,11,12],[9,9,9,12],[2,2,2,8],[10,2,10,8],[9,2,9,8],[3,2,3,11],[4,2,4,11],[5,2,5,11],[10,9,10,12]]}
["Help sheet",null,"Cover page","Vision","NA Standards"]
[null,"Cover page"]
[null,null,"Macros are required for this Workbook to function"]
[null,null,"Excel version 13 or higher is recommended (that's the version from 2013). A current version of Excel is preferred. If you don't see a message below the Service area designation instructions section you have a version that supports the required features. "]
[null,null,"For best results, select the counties in your service area on the Cover page before working on the Vision worksheet."]
[null,null,"County names will appear bold when you have county data in the Vision sheet but the county isn't checked in the Counties list. The Specialties Count column displays the number of specialties for each county. If there aren't three the cell will highlight red."]
[]
[]
[null,"Vision"]
[null,null,"Select the counties where you offer plans on the Cover Page worksheet first. When none are selected the \"Choose counties\" button appears disabled"]
[null,null,"Use the \"Add counties\" button on the Vision worksheet BEFORE pasting data into the worksheet. Pasting into the empty worksheet can be very slow and is not recommended."]
[null,null,"For each county checked on the Cover page, the Add counties button adds rows to the table for the three specialty categories: Ophthalmologist, Optometrist, and Therapeutic Optometrist."]
[null,null,"If the counties and Specialties on the Cover Sheet and in the Vision sheet match, nothing happens when you click Add counties. If there are no changes, it will alert you. Additional clicks will only change the table if there are missing counties or missing or misspelled specialties. If any of the entries have a typo they will be highlighted yellow. You can correct these by selecting the correct spelling from the in-cell menu. You should check for typos before clicking Add counties if you have pasted county data in."]
[null,null,"You can delete rows in the table by selecting any cell in a row (or multiple rows) then clicking the \"Delete selected rows\" button."]
[null,null,"You can paste over the rows in the worksheet with your own list of counties and specialties if necessary. Paste values when you do. Some columns are protected and should not be pasted over."]
[null,null," While in Paste/Sort mode the worksheet is unprotected and it is possible to delete critical formulas so avoid deleting cell contents. Click Exit Paste/Sort Mode as soon as you have finished your task to preserve the sheet's function."]
[null,null,"Sort and filter the data in the table by clicking the \"Enter Paste/Sort Mode\" button. Perform any sorting and filtering and then click \"Exit Paste/Sort Mode\""]
[null,null,"Normally it is only possible to add rows in the table using the \"Add counties\" button. If you need to paste data that would NOT require the table to grow, such as pasting data into a column that already contains enough rows, Paste/Sort mode is not required. When you need to paste data that WOULD cause the table to expand, you need to enter Paste/Sort mode. In this mode, the table will expand when you paste more rows than exist in the table. Large pastes that grow the table may be slow."]
[null,null,"This reveals the columns for TDI use only."]
[]
[null,null,"Allows TDI staff to edit columns that are for agency use only. Requires a password."]
[]
[]
[]
[null,null,"Color Key"]
[null,null,null,"Action Required, cell must be filled",null,"The yellow indicates errors or required or invalid data that must be corrected before submitting."]
[null,null,null,"Leave blank/Locked cell",null,"The dark blue background indicates filled by formulas or macros and are not editable."]
[null,null,null,"Waiver Requested/ Waiver Requested due to insufficient number of providers",null,"The pink background in the Network Adequacy column indicates a waiver must be requested."]
[null,null,null,"Adequate",null,"The green background in the Network Adequacy column indicates no waiver is required."]
[]
[]
[null,"NA Standards"]
[null,null,"The Network Adequacy Time and Distance Standards worksheet contains a reference by specialty of acceptable time and distance standards based on county types. It is able to be copied and pasted but has no user editable content."]
[null,"Reference"]
[null,null,"The Reference worksheet includes tables containing the options for Reason preferred providers are not available and Access plan summary columns. It is able to be copied and pasted but has no user editable content."]
[]
[null,"Utility"]
[null,null,"This Worksheet contains various lists used in calculations throughout the Workbook. For TDI's use only. "]

{"sheet":"Utility","index":5,"n_rows":256,"n_cols":11,"rows_kept":256,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Utility Help"]
[null,"County","CountyDesignation",null,"Vision Specialties",null,"Waiver Status",null,"Good Faith",null,"Good Faith Deficiency"]
[null,"Anderson","Micro",null,"Ophthalmologist",null,"Approved",null,"Yes",null,"N/A - Insufficient number of available providers"]
[null,"Andrews","Rural",null,"Optometrist",null,"Denied",null,"No",null,"Insufficient number of contract attempts made"]
[null,"Angelina","Metro",null,"Therapeutic Optometrist",null,"Pending",null,"N/A",null,"Insufficient number of contact methods used for outreach of unresponsive providers"]
[null,"Aransas","Micro",null,null,null,"Withdrawn",null,null,null,"No outreach attempts"]
[null,"Archer","CEAC",null,null,null,null,null,null,null,"Limited number of out-of-network providers outreached"]
[null,"Armstrong","CEAC",null,"Vision Reasons",null,null,null,null,null,"Evidence submitted by witnesses through hearing process"]
[null,"Atascosa","Micro",null,"Available provider(s) declined to contract because insurer is too new/unknown",null,"Non-contracted",null,null,null,"Narrow Network"]
[null,"Austin","Rural",null,"Available provider(s) do not contract with commercial insurance companies",null,"Replace with a number",null,null,null,"N/A"]
[null,"Bailey","CEAC",null,"In active contract negotiations",null,"Unknown"]
[null,"Bandera","Rural",null,"Insufficient number of available providers"]
[null,"Bastrop","Metro",null,"N/A - No enrollees",null,"Waiver Years",null,null,null,"Compliant with appointment wait time"]
[null,"Baylor","CEAC",null,"Unable to agree on reimbursement rate",null,"N/A",null,null,null,"Yes"]
[null,"Bee","Rural",null,"Unable to contact provider/Provider did not respond to outreach attempts",null,2024,null,null,null,"No"]
[null,"Bell","Metro",null,"Other (explain in comment column)",null,2025,null,null,null,"N/A - No enrollees"]
[null,"Bexar","Large Metro",null,"The covered services are available within applicable network adequacy standards through a combination of preferred optometrists, ophthalmologists, and therapeutic optometrists.",null,"2024, 2025",null,null,null,"N/A"]
[null,"Blanco","Rural"]
[null,"Borden","CEAC"]
[null,"Bosque","Rural",null,"Vision Access Plan Summary"]
[null,"Bowie","Metro",null,"Covered vision services are available within the time and distance network adequacy standards applicable to ophthalmology specialists under Insurance Code §1301.00553 through a combination of in-network optometrists, ophthalmologists, and therapeutic optometrists."]
[null,"Brazoria","Metro",null,"Insufficient number of optometrist, ophthalmologist, or therapeutic optometrist providers delivering covered vision services are currently practicing within the applicable network adequacy standards. Procedures are in place for insurer to comply with the access plan requirements in 28 TAC §3.3707."]
[null,"Brazos","Metro",null,"N/A - No enrollees currently reside in the county. For any new enrollees residing within the county, insurer will comply with the access plan requirements in 28 TAC §3.3707"]
[null,"Brewster","CEAC",null,"Unable to contract with available providers. Procedures are in place for insurer to comply with the access plan requirements in 28 TAC §3.3707"]
[null,"Briscoe","CEAC"]
[null,"Brooks","CEAC"]
[null,"Brown","Rural"]
[null,"Burleson","Rural"]
[null,"Burnet","Micro"]
[null,"Caldwell","Micro"]
[null,"Calhoun","Rural"]
[null,"Callahan","Rural"]
[null,"Cameron","Metro"]
[null,"Camp","Micro"]
[null,"Carson","CEAC"]
[null,"Cass","Rural"]
[null,"Castro","CEAC"]
[null,"Chambers","Micro"]
[null,"Cherokee","Micro"]
[null,"Childress","CEAC"]
[null,"Clay","CEAC"]
[null,"Cochran","CEAC"]
[null,"Coke","CEAC"]
[null,"Coleman","CEAC"]
[null,"Collin","Large Metro"]
[null,"Collingsworth","CEAC"]
[null,"Colorado","Rural"]
[null,"Comal","Metro"]
[null,"Comanche","Rural"]
[null,"Concho","CEAC"]
[null,"Cooke","Rural"]
[null,"Coryell","Micro"]
[null,"Cottle","CEAC"]
[null,"Crane","CEAC"]
[null,"Crockett","CEAC"]
[null,"Crosby","CEAC"]
[null,"Culberson","CEAC"]
[null,"Dallam","CEAC"]
[null,"Dallas","Large Metro"]
[null,"Dawson","Rural"]
[null,"DeWitt","Rural"]
[null,"Deaf Smith","Rural"]
[null,"Delta","Metro"]
[null,"Denton","Rural"]
[null,"Dickens","CEAC"]
[null,"Dimmit","CEAC"]
[null,"Donley","CEAC"]
[null,"Duval","CEAC"]
[null,"Eastland","Rural"]
[null,"Ector","Metro"]
[null,"Edwards","CEAC"]
[null,"El Paso","Metro"]
[null,"Ellis","Metro"]
[null,"Erath","Rural"]
[null,"Falls","Rural"]
[null,"Fannin","Rural"]
[null,"Fayette","Rural"]
[null,"Fisher","CEAC"]
[null,"Floyd","CEAC"]
[null,"Foard","CEAC"]
[null,"Fort Bend","Metro"]
[null,"Franklin","Rural"]
[null,"Freestone","Rural"]
[null,"Frio","Rural"]
[null,"Gaines","Rural"]
[null,"Galveston","Metro"]
[null,"Garza","CEAC"]
[null,"Gillespie","Rural"]
[null,"Glasscock","CEAC"]
[null,"Goliad","CEAC"]
[null,"Gonzales","Rural"]
[null,"Gray","Rural"]
[null,"Grayson","Metro"]
[null,"Gregg","Metro"]
[null,"Grimes","Rural"]
[null,"Guadalupe","Metro"]
[null,"Hale","Rural"]
[null,"Hall","CEAC"]
[null,"Hamilton","CEAC"]
[null,"Hansford","CEAC"]
[null,"Hardeman","CEAC"]
[null,"Hardin","Micro"]
[null,"Harris","Large Metro"]
[null,"Harrison","Micro"]
[null,"Hartley","CEAC"]
[null,"Haskell","CEAC"]
[null,"Hays","Metro"]
[null,"Hemphill","CEAC"]
[null,"Henderson","Micro"]
[null,"Hidalgo","Metro"]
[null,"Hill","Rural"]
[null,"Hockley","Rural"]
[null,"Hood","Metro"]
[null,"Hopkins","Rural"]
[null,"Houston","Rural"]
[null,"Howard","Rural"]
[null,"Hudspeth","CEAC"]
[null,"Hunt","Metro"]
[null,"Hutchinson","Rural"]
[null,"Irion","CEAC"]
[null,"Jack","CEAC"]
[null,"Jackson","Rural"]
[null,"Jasper","Rural"]
[null,"Jeff Davis","CEAC"]
[null,"Jefferson","Metro"]
[null,"Jim Hogg","CEAC"]
[null,"Jim Wells","Rural"]
[null,"Johnson","Metro"]
[null,"Jones","Rural"]
[null,"Karnes","Rural"]
[null,"Kaufman","Metro"]
[null,"Kendall","Micro"]
[null,"Kenedy","CEAC"]
[null,"Kent","CEAC"]
[null,"Kerr","Micro"]
[null,"Kimble","CEAC"]
[null,"King","CEAC"]
[null,"Kinney","CEAC"]
[null,"Kleberg","Rural"]
[null,"Knox","CEAC"]
[null,"La Salle","Micro"]
[null,"Lamar","Rural"]
[null,"Lamb","Rural"]
[null,"Lampasas","CEAC"]
[null,"Lavaca","Rural"]
[null,"Lee","Rural"]
[null,"Leon","Rural"]
[null,"Liberty","Micro"]
[null,"Limestone","Rural"]
[null,"Lipscomb","CEAC"]
[null,"Live Oak","Rural"]
[null,"Llano","Rural"]
[null,"Loving","CEAC"]
[null,"Lubbock","Metro"]
[null,"Lynn","CEAC"]
[null,"Madison","CEAC"]
[null,"Marion","Metro"]
[null,"Martin","CEAC"]
[null,"Mason","Rural"]
[null,"Matagorda","Rural"]
[null,"Maverick","CEAC"]
[null,"McCulloch","CEAC"]
[null,"McLennan","Rural"]
[null,"McMullen","Micro"]
[null,"Medina","Micro"]
[null,"Menard","CEAC"]
[null,"Midland","Metro"]
[null,"Milam","Rural"]
[null,"Mills","CEAC"]
[null,"Mitchell","CEAC"]
[null,"Montague","Rural"]
[null,"Montgomery","Metro"]
[null,"Moore","Rural"]
[null,"Morris","Rural"]
[null,"Motley","CEAC"]
[null,"Nacogdoches","Micro"]
[null,"Navarro","Micro"]
[null,"Newton","Rural"]
[null,"Nolan","Rural"]
[null,"Nueces","Metro"]
[null,"Ochiltree","Rural"]
[null,"Oldham","CEAC"]
[null,"Orange","Metro"]
[null,"Palo Pinto","Rural"]
[null,"Panola","Rural"]
[null,"Parker","Metro"]
[null,"Parmer","Rural"]
[null,"Pecos","CEAC"]
[null,"Polk","Micro"]
[null,"Potter","Metro"]
[null,"Presidio","CEAC"]
[null,"Rains","Micro"]
[null,"Randall","Metro"]
[null,"Reagan","CEAC"]
[null,"Real","CEAC"]
[null,"Red River","Rural"]
[null,"Reeves","CEAC"]
[null,"Refugio","CEAC"]
[null,"Roberts","CEAC"]
[null,"Robertson","Rural"]
[null,"Rockwall","Metro"]
[null,"Runnels","CEAC"]
[null,"Rusk","Micro"]
[null,"Sabine","Rural"]
[null,"San Augustine","Rural"]
[null,"San Jacinto","Rural"]
[null,"San Patricio","Metro"]
[null,"San Saba","CEAC"]
[null,"Schleicher","CEAC"]
[null,"Scurry","Rural"]
[null,"Shackelford","CEAC"]
[null,"Shelby","Rural"]
[null,"Sherman","CEAC"]
[null,"Smith","Metro"]
[null,"Somervell","Rural"]
[null,"Starr","Micro"]
[null,"Stephens","Rural"]
[null,"Sterling","CEAC"]
[null,"Stonewall","CEAC"]
[null,"Sutton","CEAC"]
[null,"Swisher","CEAC"]
[null,"Tarrant","Large Metro"]
[null,"Taylor","Metro"]
[null,"Terrell","CEAC"]
[null,"Terry","Rural"]
[null,"Throckmorton","CEAC"]
[null,"Titus","Micro"]
[null,"Tom Green","Micro"]
[null,"Travis","Large Metro"]
[null,"Trinity","Rural"]
[null,"Tyler","Rural"]
[null,"Upshur","Micro"]
[null,"Upton","CEAC"]
[null,"Uvalde","Rural"]
[null,"Val Verde","Rural"]
[null,"Van Zandt","Micro"]
[null,"Victoria","Metro"]
[null,"Walker","Metro"]
[null,"Waller","Metro"]
[null,"Ward","Rural"]
[null,"Washington","Micro"]
[null,"Webb","Metro"]
[null,"Wharton","Rural"]
[null,"Wheeler","CEAC"]
[null,"Wichita","Metro"]
[null,"Wilbarger","Rural"]
[null,"Willacy","Rural"]
[null,"Williamson","Metro"]
[null,"Wilson","Micro"]
[null,"Winkler","CEAC"]
[null,"Wise","Micro"]
[null,"Wood","Micro"]
[null,"Yoakum","CEAC"]
[null,"Young","Rural"]
[null,"Zapata","Rural"]
[null,"Zavala","CEAC"]