{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Main","DBase","State ID","Sch A","A","Sch B","B","Sch C","C","Sch D","D","LAYOUT","Sch E","E","Sch F","F","Sch G","G","Sch H","H","Adm Dec","ERROR LISTING","TIPS _ODC 2020","Adm"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3263,"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":"Main","index":0,"n_rows":20,"n_cols":33,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,0,2,35],[3,0,3,35],[6,0,7,35],[0,0,0,35],[1,0,1,3],[1,4,1,9],[1,10,1,16],[1,32,1,35],[1,17,1,31],[5,0,5,35],[4,0,4,35],[19,0,19,35],[18,0,18,35],[17,0,17,35],[14,0,14,35],[15,0,15,35],[16,0,16,35],[10,0,10,35],[11,0,11,35],[12,0,12,35],[13,0,13,35],[8,0,8,35],[9,0,9,35]]}
["Tennessee Outpatient Diagnostic Centers"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,null,"Facility Name:",null,null,null,null,null,null,{"$f":"A_Name","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]
[]
[" 2020 Joint Annual Report"]
[]
["TENNESSEE DEPARTMENT OF HEALTH\nHealth Statistics\n2nd Floor, Andrew Johnson Tower\n710 James Robertson Parkway\nNashville, TN 37243\nTelephone: (615) 741-1954   Fax: (615) 253-1688"]
[]
[]
["Schedule A - Identification"]
["Schedule B - Organization Structure"]
["Schedule C - Licensure, Certifications and Accreditation"]
["Schedule D - Availability and Utilization of Services/Equipment"]
["Schedule E - Patient Characteristics"]
["Schedule F - Financial Data"]
["Schedule G - Personnel"]
["Schedule H - Medical Staff"]
["Administrator's Declaration"]
["Find your State ID"]
["Tips",null,null,null,null,null,null,"Tips"]
["Error Listing - Facility Comments Required"]

{"sheet":"DBase","index":1,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["State\nID","Facility Name","Address","City","County","State","Zip"]
[0,"-","-","-","-","-","-",null,0]
["09014","McKenzie Medical Center","205 Hospital Drive, Suite A","McKenzie","Carroll","TN","38201",null,"09014",null,"TN"]
["19014","Premier Radiology Hermitage","5045 Old Hickory Boulevard, Suite 100","Hermitage","Davidson","TN","37076",null,"19014",null,"AL"]
["19024","Vanderbilt Imaging Belle Meade","4525 Harding Road, Suite 102","Nashville","Davidson","TN","37205",null,"19024",null,"AK"]
["19044","Premier Radiology Nashville","1800 Charlotte Avenue","Nashville","Davidson","TN","37203",null,"19044",null,"AZ"]
[19054,"Hillsboro Imaging","1909 Acklen Avenue","Nashville","Davidson","TN",37212,null,19054,null,"AZ"]
["19064","Specialty MRI","2018 Murphy Avenue, Suite 101","Nashville","Davidson","TN","37203",null,"19064",null,"CA"]
["19074","Imaging Alliance-Nashville Pet, LLC","52 White Bridge Road","Nashville","Davidson","TN","37203",null,"19074",null,"CO"]
["19084","Hughston Clinic Orthopaedics","394 Harding Place, Suite 101","Nashville","Davidson","TN","37211",null,"19084",null,"CT"]
["19094","Premier Radiology Belle Meade","28 White Bridge Road, Suite 111","Nashville","Davidson","TN","37205",null,"19094",null,"DE"]
["19104","Outpatient Diagnostic Center of Nashville","337 22nd Avenue North","Nashville","Davidson","TN","37203",null,"19104",null,"DC"]
["19114","Next Generation Imaging, LLC","1718 Charlotte Avenue, Suite B","Nashville","Davidson","TN","37203",null,"19114",null,"FL"]
[19164,"Premier Radiology-Antioch","3754 Murfreesboro Pike","Antioch","Davidson","TN",37013,null,19164,null,"GA"]
["19134","One Hundred Oaks Imaging","719 Thompson Lane, Suite 23300","Nashville","Davidson","TN","37204",null,"19134",null,"HI"]
["19144","Premier Radiology Saint Thomas Midtown","300 20th Avenue North, 202","Nashville","Davidson","TN","37203",null,"19144",null,"ID"]
[19154,"Premier Radiology Saint Thomas West","4230 Harding Pike","Nashville","Davidson","TN",37205,null,19154,null,"IN"]
["25014","Fentress Health Systems, LLC","208 West Central Avenue","Jamestown","Fentress","TN","38556",null,"25014",null,"IA"]
["26014","Summit Open MRI, Inc.","144 Hospital Road","Winchester","Franklin","TN","37398",null,"26014",null,"KS"]
["33034","Prime Imaging Chattanooga Outpatient Center","1301 McCallie Avenue","Chattanooga","Hamilton","TN","37404",null,"33034",null,"LA"]
["33054","Prime Imaging PET/CT of Chattanooga","2205 McCallie Avenue, Suite 400","Chattanooga","Hamilton","TN","37404",null,"33054",null,"ME"]
[33064,"Premier Imaging and Vein Center Gunbarrel","1604 Gunbarrel Road","Chattanooga","Hamilton","TN",37421,null,33064,null,"ME"]
["47014","East Tennessee Diagnostic Center","1415 Old Weisgarber Road, Suite 120","Knoxville","Knox","TN","37909",null,"47014",null,"MD"]
["47024","Outpatient Diagnostic Center of Knoxville","601 Hall of Fame Drive","Knoxville","Knox","TN","37915",null,"47024",null,"MA"]
["47034","East Tennessee Community Open MRI","1415 Old Weisgarber Road, Suite 150","Knoxville","Knox","TN","37909",null,"47034",null,"MI"]
["60014","Spring Hill Imaging Center, LLC","5421 Main Street","Spring Hill","Maury","TN","37174",null,"60014",null,"MN"]
["63014","Clarksville Imaging Center","2320 Wilma Rudolph Boulevard","Clarksville","Montgomery","TN","37040",null,"63014",null,"MS"]
["63024","Mobile MRI Medical Services","980 Professional Park Drive, Suite E","Clarksville","Montgomery","TN","37040",null,"63024",null,"MO"]
["71014","Premier Diagnostic Imaging Center","315 North Washington Avenue","Cookeville","Putnam","TN","38501",null,"71014",null,"MT"]
["75014","Premier Radiology Smyrna","741 President Place, Suite 100","Smyrna","Rutherford","TN","37167",null,"75014",null,"NE"]
["75024","Premier Radiology Murfreesboro","1840 Medical Center Parkway, Suite 101","Murfreesboro","Rutherford","TN","37129",null,"75024",null,"NV"]
["75034","The Imaging Center of Murfreesboro","1001 North Highland Avenue","Murfreesboro","Rutherford","TN","37130",null,"75034",null,"NH"]
["75044","Tennessee P.E.T. Scan Center, LLC","1840 Medical Center Parkway, Suite 100","Murfreesboro","Rutherford","TN","37129",null,"75044",null,"NJ"]
[75054,"Premier Radiology New Salem","2723 New Salem Highway","Murfreesboro","Rutherford","TN",37128,null,75054,null,"NM"]
["79014","Outpatient Diagnostic Center of Memphis","5130 Stage Road","Memphis","Shelby","TN","38134",null,"79014",null,"NC"]
["79044","East Memphis Pet Imaging, LLC","6005 Park Avenue, Suite 101B","Memphis","Shelby","TN","38119",null,"79044",null,"NC"]
[79054,"The Imaging Center at Wolf River","7800 Wolf River Boulevard, Suite 100","Germantown","Shelby","TN",38138,null,79054,null,"ND"]
["82014","Holston Medical Group @ Meadowview Lane","2033 Meadowview Lane, Suite 100","Kingsport","Sullivan","TN","37660",null,"82014",null,"OH"]
["82024","Sapling Grove Diagnostic Center","240 Medical Park Boulevard, Suite 1100","Bristol","Sullivan","TN","37620",null,"82024",null,"OK"]
["82034","Holston Valley Imaging Center","103 West Stone Drive","Kingsport","Sullivan","TN","37660",null,"82034",null,"OR"]
[83024,"Premier Radiology -Gallatin","110 ST. Blaise Road","Gallatin","Sumner","TN",37066,null,83024,null,"PA"]
[95024,"Lebanon PET SCAN","103 Physicians Way, Suite 200","Lebanon","Wilson","TN",37090,null,95024,null,"RI"]
["94014","Premier Radiology Cool Springs","3310 Aspen Grove Drive, Suite 101","Franklin","Williamson","TN","37067",null,"94014",null,"SC"]
["94024","Cool Springs Imaging","2009 Mallory Lane, Suite 150","Franklin","Williamson","TN","37067",null,"94024",null,"SD"]
["94034","Premier Radiology Brentwood","789 Old Hickory Boulevard","Brentwood","Williamson","TN","37027",null,"94034",null,"TX"]
["95014","Premier Radiology Mt. Juliet","5002 Crossing Circle, Suite 140","Mt. Juliet","Wilson","TN","37122",null,"95014",null,"UT"]
[null,null,null,null,null,null,null,null,null,null,"VT"]
[null,null,null,null,null,null,null,null,null,null,"VA"]
[null,null,null,null,null,null,null,null,null,null,"WA"]
[null,null,null,null,null,null,null,null,null,null,"WV"]
[null,null,null,null,null,null,null,null,null,null,"WI"]
[null,null,null,null,null,null,null,null,null,null,"WY"]

{"sheet":"State ID","index":2,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,0,1,8],[44,0,44,3]]}
[null,"State\nID","License\nNumber","2020 Tennessee Outpatient                                      Diagnostic Center Name","Address","City","State","Zip\nCode","County"]
[]
[]
[1,63014,14,"Clarksville Imaging Center","2320 Wilma Rudolph Boulevard","Clarksville","TN",37040,"Montgomery"]
[2,94024,18,"Cool Springs Imaging","2009 Mallory Lane, Suite 150","Franklin","TN",37067,"Williamson"]
[3,79044,56,"East Memphis Pet Imaging, LLC","6005 Park Avenue, Suite 101B","Memphis","TN",38119,"Shelby"]
[4,47034,48,"East Tennessee Community Open MRI","1415 Old Weisgarber Road, Suite 150","Knoxville","TN",37909,"Knox"]
[5,47014,16,"East Tennessee Diagnostic Center","1415 Old Weisgarber Road, Suite 120","Knoxville","TN",37909,"Knox"]
[6,19054,13,"Hillsboro Imaging","1909 Acklen Avenue","Nashville","TN",37212,"Davidson"]
[7,82014,21,"Holston Medical Group @ Meadow View Lane","2033 Meadowview Lane, Suite 100","Kingsport","TN",37660,"Sullivan"]
[8,19084,27,"Hughston Clinic Orthopaedics","394 Harding Place, Suite 101","Nashville","TN",37211,"Davidson"]
[9,19074,26,"Imaging Alliance-Nashville Pet, LLC","52 White Bridge Road","Nashville","TN",37203,"Davidson"]
[10,95024,60,"Lebanon PET SCAN Center, LLC","103 Physicians Way, Suite 100","Lebanon","TN",37090,"Wilson"]
[11,63024,58,"Mobile MRI Medical Services","980 Professional Park Drive, Suite E","Clarksville","TN",37040,"Montgomery"]
[12,19114,45,"Next Generation Imaging, LLC","1718 Charlotte Avenue, Suite B","Nashville","TN",37203,"Davidson"]
[13,19134,50,"One Hundred Oaks Imaging","719 Thompson Lane, Suite 23300","Nashville","TN",37204,"Davidson"]
[14,47024,37,"Outpatient Diagnostic Center of Knoxville","601 Hall of Fame Drive","Knoxville","TN",37915,"Knox"]
[15,19104,38,"Outpatient Diagnostic Center of Nashville","337 22nd Avenue North","Nashville","TN",37203,"Davidson"]
[16,71014,54,"Premier Diagnostic Imaging Center","315 North Washington Avenue","Cookeville","TN",38501,"Putnam"]
[17,19164,68,"Premier Radiology- Antioch","3754 Murfreesboro Pike, Suite 102","Antioch","TN",37013,"Davidson"]
[18,19094,1,"Premier Radiology Belle Meade","28 White Bridge Road, Suite 111","Nashville","TN",37205,"Davidson"]
[19,94034,9,"Premier Radiology Brentwood","789 Old Hickory Boulevard","Brentwood","TN",37027,"Williamson"]
[20,94014,8,"Premier Radiology Cool Springs","3310 Aspen Grove Drive, Suite 101","Franklin","TN",37067,"Williamson"]
[21,83024,67,"Premier Radiology Gallatin","110 ST Blaise Road","Gallatin","TN",37066,"Sumner"]
[22,19014,3,"Premier Radiology Hermitage","5045 Old Hickory Boulevard, Suite 100","Hermitage","TN",37076,"Davidson"]
[23,95014,60,"Premier Radiology Mt. Juliet","5002 Crossing Circle, Suite 140","Mt. Juliet","TN",37122,"Wilson"]
[24,75024,12,"Premier Radiology Murfreesboro","1840 Medical Center Parkway, Suite 101","Murfreesboro","TN",37129,"Rutherford"]
[25,19044,11,"Premier Radiology Nashville","1800 Charlotte Avenue","Nashville","TN",37203,"Davidson"]
[26,75054,65,"Premier Radiology New Salem","2723 New Salem Highway","Murfreesboro","TN",37129,"Rutherford"]
[27,19144,61,"Premier Radiology Saint Thomas Midtown","300 20th Avenue North, 202","Nashville","TN",37203,"Davidson"]
[28,19154,62,"Premier Radiology Saint Thomas West","4230 Harding Road","Nashville","TN",37205,"Davidson"]
[29,75014,10,"Premier Radiology Smyrna","741 President Place, Suite 100","Smyrna","TN",37167,"Rutherford"]
[30,33064,64,"Prime Imaging and Vein Center Gunbarrel","1604 Gunbarrel Road","Chattanooga","TN",33064,"Hamilton"]
[31,33034,33,"Prime Imaging Chattanooga Outpatient Center","1301 McCallie Avenue","Chattanooga","TN",37404,"Hamilton"]
[32,33054,49,"Prime Imaging PET/CT of Chattanooga","2205 McCallie Avenue, Suite 400","Chattanooga","TN",37404,"Hamilton"]
[33,82024,22,"Sapling Grove Diagnostic Center","240 Medical Park Boulevard, Suite 1100","Bristol","TN",37620,"Sullivan"]
[34,60014,28,"Spring Hill Imaging Center, LLC","5421 Main Street","Spring Hill","TN",37174,"Maury"]
[35,26014,19,"Summit Open MRI, Inc.","144 Hospital Road","Winchester","TN",37398,"Franklin"]
[36,75044,52,"Tennessee P.E.T. Scan Center, LLC","1840 Medical Center Parkway, Suite 100","Murfreesboro","TN",37129,"Rutherford"]
[37,79054,63,"The Imaging Center at Wolf River","7600 Wolf river Boulevard, Suite 100","Germantown","TN",38138,"Shelby"]
[38,19024,4,"Vanderbilt Imaging Belle Meade","4525 Harding Road, Suite 102","Nashville","TN",37205,"Davidson"]
[]
[]
[]
["CLOSED FACILITIES 2020"]
[1,9014,57,"McKenzie Medical Center","205 Hospital Drive","McKenzie","TN",38201,"Carroll"]
[2,19064,25,"Specialty MRI","2018 Murphy Avenue, Suite 101","Nashville","TN",37203,"Davidson"]
[3,19124,46,"Millennium MRI, LLC","1718 Charlotte Avenue, Suite B","Nashville","TN",37203,"Davidson"]
[4,25014,34,"Fentress Health Systems, LLC","208 West Central Avenue","Jamestown","TN",38556,"Fentress"]
[5,75034,32,"The Imaging Center of Murfreesboro","1001 North Highland Avenue","Murfreesboro","TN",37130,"Rutherford"]
[6,79014,39,"Outpatient Diagnostic Center of Memphis","5130 Stage Road","Memphis","TN",38134,"Shelby"]
[7,82034,24,"Holston Valley Imaging Center","103 West Stone Drive","Kingsport","TN",37660,"Sullivan"]
[8,90024,42,"Molecular Imaging Alliance","830 Suncrest Drive, Unit 2","Gray","TN",37615,"Washington"]

{"sheet":"Sch A","index":3,"n_rows":32,"n_cols":47,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,32,1,35],[0,37,0,39],[4,38,6,38],[14,37,16,37],[8,37,10,37],[14,38,17,38],[9,39,14,39],[8,38,10,38],[4,39,6,39],[0,0,0,35],[4,37,6,37],[9,21,9,26],[9,12,9,20],[9,27,9,35],[10,27,10,35],[10,12,10,20],[19,39,21,39],[23,5,23,13],[23,14,23,35],[21,38,23,38],[21,37,23,37],[21,22,21,29],[19,5,19,35],[20,33,20,35],[10,21,10,26],[15,5,15,11],[7,5,7,11],[2,0,2,35],[4,0,15,4],[9,5,9,11],[10,5,10,11],[14,12,14,35],[15,12,15,20],[15,21,15,26],[15,27,15,35],[12,5,12,32],[13,12,13,35],[12,33,12,35],[13,5,13,11],[1,0,1,3],[1,4,1,9],[1,10,1,16],[14,5,14,11],[11,5,11,11],[11,12,11,35],[6,5,6,32],[6,33,6,35],[8,5,8,11],[7,12,7,35],[8,12,8,35],[3,0,3,35],[4,5,4,11],[4,12,4,35],[5,5,5,11],[5,12,5,35],[23,0,24,4],[24,5,24,13],[26,0,26,35],[16,5,16,11],[17,5,17,11],[16,12,16,20],[16,27,16,35],[1,17,1,31],[25,39,29,39],[16,21,16,26],[25,0,25,35],[21,5,22,21],[20,5,20,32],[16,0,18,4],[17,12,17,35],[18,12,18,35],[18,5,18,11],[22,22,22,29],[27,0,27,35],[24,14,24,35],[19,0,22,4],[22,30,22,35],[21,30,21,35]]}
["2020  Tennessee - ODC - Provisional  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'Ok' = Likely no Error\n'Error' = Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,null,"Facility Name:",null,null,null,null,null,null,{"$f":"A_Name","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]
["Outpatient Diagnostic Centers Joint Annual Report - Schedule A - Identification"]
["According to the Department of Health Rules and Regulations Section 1200-8-35-.11 \"the Joint Annual Report of Outpatient Diagnostic Centers shall be filed with the department.\"  Please read all information carefully before completing your Joint Annual Report with data for the calendar year indicated on the first page.  Please complete all items on the Joint Annual Report.  Use 0 (zero) when appropriate.  Check all computations, especially where a total is required.  Please check all checkboxes.  Any items which appear to be inconsistent will be queried.  Facilities will be reported to the Board for Licensing Healthcare Facilities for both failure to file forms and failure to respond to queries.  A section for comments relating to the unique aspect of your agency is available at the end of each schedule."]
["2020                 Facility",null,null,null,null,"State ID",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State ID\nprovided?","Street\naddress\ndata\nprovided?","Yes/No\nChange\nName?"]
[null,null,null,null,null,"ODC Name",null,null,null,null,null,null,{"$f":"IF(AU8=\"#N/A\",\" \",AU8)","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A_StreetAddress=\"-\",0,1)","v":0},null,{"$f":"OR(A_NameChange=\"Yes\",A_NameChange=\"No\")","v":false}]
[null,null,null,null,null,"Did the facility name change during the reporting period?                                         Yes/No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,{"$f":"IF(A_City=\"-\",0,1)","v":0}]
[null,null,null,null,null,"If Yes, Prior Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A_StateID>=1,\"Ok\", \"Error\")","v":"Error"},{"$f":"IF(AO12=5,\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AQ6=TRUE,\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(A_County=\"-\",0,1)","v":0},null,{"$f":"IF(A_NameChange=\"Yes\",1,0)","v":0},null,null,null,{"$f":"VLOOKUP(A_StateID,DBase!$A:$G,2,FALSE)","v":"-"}]
[null,null,null,null,null,"Street Address",null,null,null,null,null,null,{"$f":"AU9","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prior\nName\ndata\nprovided","Facility\nPhone\ndata\nprovided?",null,{"$f":"IF(A_State=\"-\",0,1)","v":1},null,{"$f":"IF(A_PriorName=\"\",0,1)","v":0},null,null,null,{"$f":"VLOOKUP(A_StateID,DBase!$A:$G,3,FALSE)","v":"-"}]
[null,null,null,null,null,"City",null,null,null,null,null,null,{"$f":"AU10","v":"-"},null,null,null,null,null,null,null,null,"County",null,null,null,null,null,{"$f":"AU11","v":"-"},null,null,null,null,null,null,null,null,null,null,null,"Yes/No\nMailing\naddress\ndifferent\nthan\nStreet \naddress",{"$f":"IF(A_Zip=\"-\",0,1)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(A_StateID,DBase!$A:$G,4,FALSE)","v":"-"}]
[null,null,null,null,null,"State  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zip Code (5 digit)",null,null,null,null,null,{"$f":"AU13","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(A_StateID,DBase!$A:$E,5,FALSE)","v":"-"}]
[null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AQ8=AQ9,\"Ok\", \"Error\")","v":"Ok"},{"$f":"IF(A_Phone<>\"\",\"Ok\",\"Error\")","v":"Error"},null,{"$f":"SUM(AO6:AO11)","v":1},null,{"$f":"IF(A_MAYN=\"Yes\",6,0)","v":0},{"$f":"OR(AQ12=6,AQ13=1)","v":false},null,null,{"$f":"VLOOKUP(A_StateID,DBase!$A:$G,6,FALSE)","v":"-"}]
[null,null,null,null,null,"Mailing Address same as Street Address?  If Yes, proceed to next section.              Yes/No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,{"$f":"IF(A_MAYN=\"No\",1,0)","v":0},null,null,null,{"$f":"VLOOKUP(A_StateID,DBase!$A:$G,7,FALSE)","v":"-"}]
[null,null,null,null,null,"Mailing Address  ",null,null,null,null,null,null,{"$f":"IF(A_MAYN=\"Yes\",A_StreetAddress,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A_PrepName=\"\",0,1)","v":0},{"$f":"IF(A_MA<>\"\",1,0)","v":0}]
[null,null,null,null,null,"City",null,null,null,null,null,null,{"$f":"IF(A_MAYN=\"Yes\",A_City,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preparer\nData\nProvided?","Mailing address data provided?",null,null,{"$f":"IF(A_PrepPhone=\"\",0,1)","v":0},{"$f":"IF(A_MAC<>\"\",1,0)","v":0}]
[null,null,null,null,null,"State",null,null,null,null,null,null,{"$f":"IF(A_MAYN=\"Yes\",A_State,\"\")","v":""},null,null,null,null,null,null,null,null,"Zip Code (5 digit)",null,null,null,null,null,{"$f":"IF(A_MAYN=\"Yes\",A_Zip,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AR12=TRUE,\"Ok\",\"Error\")","v":"Error"},null,{"$f":"IF(A_PrepTitle=\"\",0,1)","v":0},{"$f":"IF(A_MAS<>\"\",1,0)","v":0}]
["2020          Preparer",null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A_PrepEMail=\"\",0,1)","v":0},{"$f":"IF(A_MAZ<>\"\",1,0)","v":0}]
[null,null,null,null,null,"Title",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP18=4,\"Ok\",\"Error\")","v":"Error"},null,null,null,{"$f":"SUM(AP13:AP17)","v":0},{"$f":"SUM(AQ12:AQ17)","v":0}]
[null,null,null,null,null,"E-Mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AQ19=TRUE,\"Ok\",\"Error\")","v":"Error"},null,null,null,{"$f":"OR(AQ18=5,AQ18=10)","v":false}]
["Reporting\nPeriod",null,null,null,null,"In the event your reporting period differs from that of January 1 through December 31 and/or is less than 365 days, due to new opening or a facility closure, please provide the data \nalong with the beginning and ending dates for the period of time you are reporting.\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes/No\nReporting\nPeriod",null,"Reporting Period Beginning and Ending Date(s) provided"]
[null,null,null,null,null,"Is the reporting period January 1 - December 31 of the year specified above?           Yes/No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,{"$f":"IF(AQ29=TRUE,\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"If unable to report based on above dates, provide\nbeginning and ending dates (used for all utilization\nand financial data):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beginning (mm/dd/yyyy)",null,null,null,null,null,null,null,{"$f":"IF(A_RptPeriodYN=\"Yes\",\"01/01/2020\",\"\")","v":""},null,null,null,null,null,null,"Admin-\nistrator's\nname,\nProvided","Medical\nDirector's\nname,\nProvided"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ending     (mm/dd/yyyy)",null,null,null,null,null,null,null,{"$f":"IF(A_RptPeriodYN=\"Yes\",\"12/31/2020\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(A_RptBegDate<>\"\",A_RptEndDate<>\"\"),\"Ok\",\"Error\")","v":"Error"}]
["Administration",null,null,null,null,"Administrator's Name"]
[null,null,null,null,null,"Medical Director's Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A_Admin<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(A_MedDir<>\"\",\"Ok\",\"Error\")","v":"Error"}]
["Go to Next Schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A_RptPeriodYN=\"No\",3,0)","v":0}]
["Return to Main Menu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A_RptBegDate=50544,1,0)","v":0}]
["Go to Error Listing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A_RptEndDate=40908,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AP26:AP28)","v":0},{"$f":"OR(A_RptPeriodYN=\"Yes\",A_RptPeriodYN=\"No\")","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A_RptBegDate","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A_RptEndDate","v":""}]

{"sheet":"A","index":4,"n_rows":4,"n_cols":27,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,1,2],[0,25,0,26]]}
["Facility ID Info",null,null,"Facility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preparer",null,null,null,"Reporting Period",null,null,"Administration"]
[null,null,null,null,null,"Name Change during year?",null,null,null,null,null,null,null,"Mailing Address"]
["State ID","Facility\nName","County","State ID","Name","Yes/No","Prior name","Street\nAddress","City","County","State","Zip Code","Phone","Yes/No","Address","City","State","Zip Code","Name","Phone","Title","E-Mail","Yes/No","Beginning\nDate\nmm/dd/yyyy","Ending\nDate\nmm/dd/yyyy","Administrator's\nName","Medical\nDirector's\nName"]
[{"$f":"A_StateID","v":0},{"$f":"A_Name","v":"-"},{"$f":"A_County","v":"-"},{"$f":"A_StateID","v":0},{"$f":"A_Name","v":"-"},{"$f":"A_NameChange","v":"-"},{"$f":"A_PriorName","v":0},{"$f":"A_StreetAddress","v":"-"},{"$f":"A_City","v":"-"},{"$f":"A_County","v":"-"},{"$f":"A_State","v":0},{"$f":"A_Zip","v":"-"},{"$f":"A_Phone","v":0},{"$f":"A_MAYN","v":"-"},{"$f":"A_MA","v":""},{"$f":"A_MAC","v":""},{"$f":"A_MAS","v":""},{"$f":"A_MAZ","v":""},{"$f":"A_PrepName","v":0},{"$f":"A_PrepPhone","v":0},{"$f":"A_PrepTitle","v":0},{"$f":"A_PrepEMail","v":0},{"$f":"A_RptPeriodYN","v":"-"},{"$f":"A_RptBegDate","v":""},{"$f":"A_RptEndDate","v":""},{"$f":"A_Admin","v":0},{"$f":"A_MedDir","v":0}]

{"sheet":"Sch B","index":5,"n_rows":55,"n_cols":45,"rows_kept":55,"cut":false,"hidden":false,"merged":[[22,38,24,38],[26,38,28,38],[18,39,22,39],[51,17,51,35],[48,7,48,9],[49,7,49,9],[50,7,50,9],[51,7,51,9],[48,10,48,35],[49,10,49,35],[50,10,50,35],[47,30,47,35],[41,19,41,35],[42,19,42,25],[42,26,42,29],[30,24,30,35],[28,8,28,35],[29,20,29,23],[29,24,29,35],[30,8,30,19],[29,4,29,7],[38,15,38,18],[39,7,42,9],[42,30,42,35],[48,0,51,3],[48,4,48,6],[49,4,49,6],[50,4,50,6],[51,4,51,6],[51,10,51,16],[43,7,47,9],[43,4,47,6],[47,26,47,29],[44,15,44,18],[44,19,44,35],[45,15,45,18],[46,15,46,18],[47,15,47,18],[43,19,43,35],[43,15,43,18],[43,10,47,14],[45,19,45,35],[46,19,46,35],[47,19,47,25],[39,10,42,14],[35,7,38,9],[35,4,38,6],[35,15,35,18],[35,19,35,35],[36,15,36,18],[37,15,37,18],[36,19,36,35],[37,19,37,35],[35,10,38,14],[38,30,38,35],[38,26,38,29],[31,0,32,3],[33,4,33,35],[34,4,34,6],[34,7,34,9],[34,10,34,35],[33,0,47,3],[31,4,31,6],[31,7,31,9],[31,10,31,28],[32,4,32,6],[32,7,32,9],[32,10,32,28],[31,32,31,35],[32,32,32,35],[31,29,31,31],[32,29,32,31],[39,4,42,6],[39,15,39,18],[40,15,40,18],[41,15,41,18],[42,15,42,18],[39,19,39,35],[40,19,40,35],[38,19,38,25],[7,0,7,35],[8,4,13,6],[13,7,13,8],[11,7,11,8],[5,4,5,7],[6,4,6,7],[1,10,1,16],[24,5,24,10],[25,5,25,10],[25,11,25,14],[6,8,6,19],[8,7,8,8],[9,7,9,8],[10,7,10,8],[17,9,17,35],[18,9,18,35],[10,9,10,35],[8,9,8,35],[14,7,14,8],[15,7,15,8],[20,9,20,35],[20,7,20,8],[14,9,14,35],[25,15,25,23],[52,0,52,35],[12,9,12,35],[13,9,13,35],[8,0,21,3],[14,4,16,6],[17,7,17,8],[18,7,18,8],[54,0,54,35],[53,0,53,35],[19,7,19,8],[21,15,21,35],[17,4,21,6],[23,15,23,35],[26,15,26,23],[27,0,30,3],[22,0,26,3],[26,4,26,10],[29,8,29,19],[26,11,26,14],[27,4,27,7],[28,4,28,7],[30,4,30,7],[30,20,30,23],[23,11,23,14],[0,37,0,39],[2,37,4,37],[5,8,5,19],[2,0,2,35],[3,0,6,3],[3,4,3,7],[4,4,4,7],[0,0,0,35],[1,0,1,3],[1,4,1,9],[5,20,5,23],[6,20,6,23],[3,8,3,35],[4,8,4,35],[5,24,5,35],[6,24,6,35],[1,32,1,35],[1,17,1,31],[29,37,30,37],[15,9,15,35],[9,37,10,37],[19,37,21,37],[9,9,9,35],[22,4,22,10],[21,7,21,8],[16,9,16,35],[21,9,21,14],[12,7,12,8],[24,11,24,14],[19,9,19,35],[22,11,22,35],[11,9,11,35],[23,5,23,10],[16,7,16,8],[27,8,27,35],[25,24,25,27],[26,24,26,27],[25,28,25,35],[26,28,26,35],[24,15,24,35],[22,37,24,37]]}
["2020  Tennessee  - ODC - Provisional  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'Ok' = Likely no Error\n'Error' = Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,null,"Facility Name:",null,null,null,null,null,null,{"$f":"A_Name","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,null,null,null,null,null,null,null,{"$f":"IF(B_OwName<>\"\",1,0)","v":0}]
["Outpatient Diagnostic Centers Joint Annual Report - Schedule B - Organization Structure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Owner\ndata,\nprovided",null,null,{"$f":"IF(B_OwStreet<>\"\",1,0)","v":0}]
["Owner",null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwCity<>\"\",1,0)","v":0}]
[null,null,null,null,"Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwPhone<>\"\",1,0)","v":0}]
[null,null,null,null,"City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO8=6,\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(B_OwState<>\"\",1,0)","v":0}]
[null,null,null,null,"State",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zip Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwZip<>\"\",1,0)","v":0}]
["The type of legal entity, except proprietorship, general partnerships and government entities, can be confirmed by \nentering the legal entity’s name into a search at the Secretary of State web site: \nhttp://www.tennesseeanytime.org/soscorp/. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AO2:AO7)","v":0}]
["Owner\nType",null,null,null,"For\nProfit",null,null,"^",null,"Proprietorship - a business owned by one person.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TypeProfProp=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"^",null,"General Partnership - an association of two or more persons to carry on as co-owners \nof a business or other undertaking for profit formed under § 61-1-202, predecessor law, \nor comparable law of another jurisdiction. TCA Title 61 Chapter 1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select only\none type of\nowner",null,null,{"$f":"IF(B_TypeProfPart=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"^",null,"Limited Partnership (LP) - a partnership formed by two or more persons under the laws \nof the state of Tennessee, and having one or more general partners and one or more \nlimited partners. TCA Title 61 Chapter 2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TypeProfLP=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"^",null,"Limited Liability Partnership (LLP) - governed by TCA § 61-1-106 (c).  The law of this \nstate governs relations among the partners and between the partners and the \npartnership and the liability of partners for an obligation of a limited liability partnership \nthat has filed an application as a limited liability partnership in this state.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP12=1,\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(B_TypeProfLLP=\"X\",1,0)","v":0},{"$f":"SUM(AO9:AO22)","v":0}]
[null,null,null,null,null,null,null,"^",null,"Limited Liability Company (LLC) - established by the “The Tennessee Limited Liability \nCompany Act” found in the Tennessee Code Annotated, § 48-201-101 through § \n48-248-606.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TypeProfLLC=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"^",null,"Corporation - defined by the “Tennessee Business Corporation Act” codified in TCA \nTitle 48 Chapters 11-27.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TypeProfCorp=\"X\",1,0)","v":0}]
[null,null,null,null,"Not\nfor\nProfit",null,null,"^",null,"Non-Religious Corporation or Association - defined by the “Tennessee Nonprofit \nCorporation Act” codified in TCA Title 48 Chapters 51-68.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TypeNotPNonRelg=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"^",null,"Religious Corporation or Association - either a corporation or association that is \norganized and operated primarily or exclusively for religious purposes.  Most of \nthe provisions of the Tennessee Nonprofit Corporation Act apply to a religious \ncorporation.  Exceptions are specified in TCA § 48-67-102.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TypeNotPRelg=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"^",null,"Limited Liability Company (LLC) - a company that is disregarded as an entity for federal \nincome tax purposes, and whose sole member is a nonprofit corporation, foreign or \ndomestic, incorporated under or subject to the provisions of the Tennessee Nonprofit \nCorporation Act and who is exempt from franchise and excise tax as not-for-profit as \ndefined in TCA § 67-4-1004(15).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other\nGovernment\nChecked,\nSpecify\nfield data\nprovided",null,null,{"$f":"IF(B_TypeNotPLLC=\"X\",1,0)","v":0}]
[null,null,null,null,"Govern-\nment",null,null,"^",null,"City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(B_TypeGovtOther=\"X\",B_TypeGovtOtherName<>\"\"),\"Ok\", IF(AND(B_TypeGovtOther=\"^\",B_TypeGovtOtherName=\"\"),\"Ok\",\"Error\"))","v":"Ok"},null,null,{"$f":"IF(B_TypeGovtCity=\"X\",1,0)","v":0},{"$f":"IF(B_TypeGovtOther=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"^",null,"County",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional\ndata\nprovided\nif managed\nby Contract \nwith firm\nor Other",{"$f":"IF(B_TypeGovtCounty=\"X\",1,0)","v":0},{"$f":"IF(B_TypeGovtOtherName<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,"^",null,"State",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TypeGovtState=\"X\",1,0)","v":0},{"$f":"SUM(AP18:AP19)","v":0}]
[null,null,null,null,null,null,null,"^",null,"Federal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TypeGovtFed=\"X\",1,0)","v":0},{"$f":"OR(AP20=0,AP20=2)","v":true}]
[null,null,null,null,null,null,null,"^",null,"Other\nGovernment,\nSpecify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TypeGovtOther=\"X\",1,0)","v":0}]
["Managed\nby",null,null,null,"Management is\nprovided by:",null,null,null,null,null,null,"If managed by contract or other, provide information below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mgmt\nprovided\nby\n(select\nonly one)","Mgmt\nother\nselected,\nprovide\nadditional\ndata"]
[null,null,null,null,"^","Owner",null,null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS25=TRUE,\"Ok\",\"Error\")","v":"Ok"},{"$f":"IF(B_MOwn=\"X\",1,0)","v":0},{"$f":"IF(B_MCon=\"X\",1,0)","v":0},{"$f":"IF(B_MName<>\"\",1,0)","v":0},{"$f":"IF(B_MPhone<>\"\",1,0)","v":0},{"$f":"SUM(AP24:AR26)","v":0}]
[null,null,null,null,"^","Contract with \nFirm",null,null,null,null,null,"Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_MCon=\"X\",1,0)","v":0},{"$f":"IF(B_MOth=\"X\",1,0)","v":0},{"$f":"IF(B_MStreet<>\"\",1,0)","v":0},{"$f":"IF(B_MState<>\"\",1,0)","v":0},{"$f":"OR(AS24=0,AS24=7)","v":true}]
[null,null,null,null,"^","Other, Specify",null,null,null,null,null,"City",null,null,null,null,null,null,null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO27=1,\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AS27=TRUE,\"Ok\",\"Error\")","v":"Ok"},null,{"$f":"IF(B_MOth=\"X\",1,0)","v":0},0,{"$f":"IF(B_MCity<>\"\",1,0)","v":0},{"$f":"IF(B_MZip<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"State",null,null,null,null,null,null,null,null,null,null,null,null,"Zip Code",null,null,null,null,null,null,null,null,null,null,null,null,null,"Building data\nprovided",null,{"$f":"SUM(AO24:AO26)","v":0},{"$f":"IF(B_MOth=\"X\",1,0)","v":0},{"$f":"IF(B_MOthS<>\"\",1,0)","v":0},{"$f":"AP27+AQ27","v":0},{"$f":"OR(AR27=0,AR27=2)","v":true}]
["Building\nOwner",null,null,null,"Name"]
[null,null,null,null,"Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_BOName<>\"\",1,0)","v":0},{"$f":"IF(B_BOState<>\"\",1,0)","v":0},{"$f":"SUM(AO29:AP31)","v":0}]
[null,null,null,null,"City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes/No\nQuestion",{"$f":"IF(AQ29=6,\"Ok\",\"Error\")","v":"Error"},null,{"$f":"IF(B_BOStreet<>\"\",1,0)","v":0},{"$f":"IF(B_BOPhone<>\"\",1,0)","v":0}]
[null,null,null,null,"State",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zip Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_BOCity<>\"\",1,0)","v":0},{"$f":"IF(B_BOZip<>\"\",1,0)","v":0}]
["Building",null,null,null,"Yes/No",null,null,"-",null,null,"Do you know the year of the original construction date?\nIf yes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year",null,null,null,null,null,null,null,{"$f":"IF(B_BYNCon<>\"-\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AS32=TRUE,\"Ok\",\"Error\")","v":"Ok"},null,null,{"$f":"IF(B_BYNCon=\"Yes\",1,0)","v":0},{"$f":"IF(B_BConYr<>\"\",1,0)","v":0},{"$f":"AP32+AQ32","v":0},{"$f":"OR(AR32=0,AR32=2)","v":true}]
[null,null,null,null,"Yes/No",null,null,"-",null,null,"Has the building had a major renovation? A major \nrenovation is any project that includes the addition \nof services or medical equipment.  If Yes, provide year.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year",null,null,null,null,null,null,null,{"$f":"IF(B_BYNRen<>\"-\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AS33=TRUE,\"Ok\",\"Error\")","v":"Ok"},null,null,{"$f":"IF(B_BYNRen=\"Yes\",1,0)","v":0},{"$f":"IF(B_BRenYr<>\"\",1,0)","v":0},{"$f":"AP33+AQ33","v":0},{"$f":"OR(AR33=0,AR33=2)","v":true}]
["Type of\nFacility",null,null,null,"Please check Yes or No in each of the four types to describe your facility and include the\ninformation requested for that type."]
[null,null,null,null,"Yes/No",null,null,"-",null,null,"Free-Standing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_FFSYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,"Yes/No",null,null,"-",null,null,"Hospital\nBased",null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_FHBYN=\"Yes\",1,0)","v":0},{"$f":"IF(B_FHBCI<>\"\",1,0)","v":0},{"$f":"SUM(AP36:AQ38)","v":0},{"$f":"OR(AR36=0,AR36=6)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_FHBYN<>\"-\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AS36=TRUE,\"Ok\",\"Error\")","v":"Ok"},null,null,{"$f":"IF(B_FHBNM<>\"\",1,0)","v":0},{"$f":"IF(B_FHBS<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_FHBST<>\"\",1,0)","v":0},{"$f":"IF(B_FHBZ<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State",null,null,null,null,null,null,null,null,null,null,"Zip Code"]
[null,null,null,null,"Yes/No",null,null,"-",null,null,"Doctor's\nOffice",null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_FDOYN=\"Yes\",1,0)","v":0},{"$f":"IF(B_FDOCI<>\"\",1,0)","v":0},{"$f":"SUM(AP40:AQ42)","v":0},{"$f":"OR(AR40=0,AR40=6)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_FDOYN<>\"-\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AS40=TRUE,\"Ok\",\"Error\")","v":"Ok"},null,null,{"$f":"IF(B_FDONM<>\"\",1,0)","v":0},{"$f":"IF(B_FDOS<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_FDOST<>\"\",1,0)","v":0},{"$f":"IF(B_FDOZ<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State",null,null,null,null,null,null,null,null,null,null,"Zip Code"]
[null,null,null,null,"Yes/No",null,null,"-",null,null,"Other",null,null,null,null,"Specify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_FOYN=\"Yes\",1,0)","v":0},{"$f":"IF(B_FOCI<>\"\",1,0)","v":0},{"$f":"SUM(AP44:AQ47)","v":0},{"$f":"OR(AR44=0,AR44=7)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_FOSep<>\"\",1,0)","v":0},{"$f":"IF(B_FOS<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_FOYN<>\"-\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AS44=TRUE,\"Ok\",\"Error\")","v":"Ok"},null,null,{"$f":"IF(B_FONM<>\"\",1,0)","v":0},{"$f":"IF(B_FOZ<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_FOST<>\"\",1,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State",null,null,null,null,null,null,null,null,null,null,"Zip Code"]
["Type of\nService",null,null,null,"Yes/No",null,null,"-",null,null,"Multi-Specialty",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TMSYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,"Yes/No",null,null,"-",null,null,"Limited-Purpose",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TLPYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,"Yes/No",null,null,"-",null,null,"Cancer Treatment and Radiation Clinic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TCYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,"Yes/No",null,null,"-",null,null,"Other, specify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_TOYN<>\"-\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AS52=TRUE,\"Ok\",\"Error\")","v":"Ok"},null,null,{"$f":"IF(B_TOYN=\"Yes\",1,0)","v":0},{"$f":"IF(B_TOSpe<>\"\",1,0)","v":0},{"$f":"AP52+AQ52","v":0},{"$f":"OR(AR52=0,AR52=2)","v":true}]
["Go to Next Schedule"]
["Return to Main Menu"]
["Go to Error Listing"]

{"sheet":"B","index":6,"n_rows":4,"n_cols":69,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,1,2],[1,45,1,50],[1,51,1,56],[1,57,1,63],[0,44,0,63],[0,40,1,43],[0,34,1,39],[0,24,0,33],[1,24,1,27]]}
["Facility ID Info",null,null,"Owner",null,null,null,null,null,"Owner Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Managed by",null,null,null,null,null,null,null,null,null,"Building Owner",null,null,null,null,null,"Building",null,null,null,"Type of Facility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of Service"]
[null,null,null,null,null,null,null,null,null,"For Profit",null,null,null,null,null,"Not for Profit",null,null,"Government",null,null,null,null,null,"Management is provided by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Free Standing","Hospital Based",null,null,null,null,null,"Doctor's office",null,null,null,null,null,"Other"]
["State ID","Facility\nName","County","Name","Street","City","State","Phone","Zip Code","Proprietor-\nship","Gneral\nPartnership","Limited \nPartnership\n(LP)","Limited\nLiability\nPartnership\n(LLP)","Limited \nLiability\nCompany\n(LLC)","Corporation","Non-\nReligious\nCorp or\nAssociation","Religious\nCorp or\nAssociation","Limited\nLiability\nCompany\n(LLC)","City","County","State","Federal","Other\nGovernment","Other\nGovernment\nSpecify","Owner","Contract \nwith firm","Other","Other,\nSpecify","Name","Street","City","State","Zip","Phone","Name","Street","City","State","Zip","Phone","Yes/No","Original\nContruction\nDate\nYear","Yes/No","Major\nrenovation\nYear","Yes/No","Yes/No","Name","Street","City","State","Zip","Yes/No","Name","Street","City","State","Zip","Yes/No","Specify","Name","Street","City","State","Zip","Yes/No","Yes/No","Yes/No","Yes/No","Other,\nspecify"]
[{"$f":"A_StateID","v":0},{"$f":"A_Name","v":"-"},{"$f":"A_County","v":"-"},{"$f":"B_OwName","v":0},{"$f":"B_OwStreet","v":0},{"$f":"B_OwCity","v":0},{"$f":"B_OwState","v":0},{"$f":"B_OwPhone","v":0},{"$f":"B_OwZip","v":0},{"$f":"B_TypeProfProp","v":"^"},{"$f":"B_TypeProfPart","v":"^"},{"$f":"B_TypeProfLP","v":"^"},{"$f":"B_TypeProfLLP","v":"^"},{"$f":"B_TypeProfLLC","v":"^"},{"$f":"B_TypeProfCorp","v":"^"},{"$f":"B_TypeNotPNonRelg","v":"^"},{"$f":"B_TypeNotPRelg","v":"^"},{"$f":"B_TypeNotPLLC","v":"^"},{"$f":"B_TypeGovtCity","v":"^"},{"$f":"B_TypeGovtCounty","v":"^"},{"$f":"B_TypeGovtState","v":"^"},{"$f":"B_TypeGovtFed","v":"^"},{"$f":"B_TypeGovtOther","v":"^"},{"$f":"B_TypeGovtOtherName","v":0},{"$f":"B_MOwn","v":"^"},{"$f":"B_MCon","v":"^"},{"$f":"B_MOth","v":"^"},{"$f":"B_MOthS","v":0},{"$f":"B_MName","v":0},{"$f":"B_MStreet","v":0},{"$f":"B_MCity","v":0},{"$f":"B_MState","v":0},{"$f":"B_MZip","v":0},{"$f":"B_MPhone","v":0},{"$f":"B_BOName","v":0},{"$f":"B_BOStreet","v":0},{"$f":"B_BOCity","v":0},{"$f":"B_BOState","v":0},{"$f":"B_MZip","v":0},{"$f":"B_BOPhone","v":0},{"$f":"B_BYNCon","v":"-"},{"$f":"B_BConYr","v":0},{"$f":"B_BYNRen","v":"-"},{"$f":"B_BRenYr","v":0},{"$f":"B_FFSYN","v":"-"},{"$f":"B_FHBYN","v":"-"},{"$f":"B_FHBNM","v":0},{"$f":"B_FHBST","v":0},{"$f":"B_FHBCI","v":0},{"$f":"B_FHBS","v":0},{"$f":"B_FHBZ","v":0},{"$f":"B_FDOYN","v":"-"},{"$f":"B_FDONM","v":0},{"$f":"B_FDOST","v":0},{"$f":"B_FDOCI","v":0},{"$f":"B_FDOS","v":0},{"$f":"B_FDOZ","v":0},{"$f":"B_FOYN","v":"-"},{"$f":"B_FOSep","v":0},{"$f":"B_FONM","v":0},{"$f":"B_FOST","v":0},{"$f":"B_FOCI","v":0},{"$f":"B_FOS","v":0},{"$f":"B_FOZ","v":0},{"$f":"B_TMSYN","v":"-"},{"$f":"B_TLPYN","v":"-"},{"$f":"B_TCYN","v":"-"},{"$f":"B_TOYN","v":"-"},{"$f":"B_TOSpe","v":0}]

{"sheet":"Sch C","index":7,"n_rows":28,"n_cols":41,"rows_kept":28,"cut":false,"hidden":false,"merged":[[21,31,21,35],[23,10,24,12],[20,31,20,35],[23,31,23,35],[19,25,19,30],[20,25,20,30],[27,0,27,35],[23,17,24,24],[19,10,20,12],[23,13,24,16],[21,17,22,24],[24,25,24,30],[26,0,26,35],[5,0,24,6],[19,31,19,35],[21,10,22,12],[25,0,25,35],[18,31,18,35],[17,7,18,9],[15,10,16,12],[17,10,18,12],[7,7,8,9],[17,13,18,24],[7,25,7,30],[8,25,8,30],[15,25,15,30],[16,25,16,30],[7,13,8,24],[9,13,10,24],[11,13,12,24],[13,13,14,24],[18,25,18,30],[9,25,9,30],[10,25,10,30],[17,25,17,30],[13,25,13,30],[14,25,14,30],[18,39,19,39],[1,38,2,38],[3,38,4,38],[15,31,15,35],[6,31,6,35],[7,31,7,35],[8,31,8,35],[9,31,9,35],[10,31,10,35],[3,31,3,35],[16,31,16,35],[17,31,17,35],[11,31,11,35],[1,17,1,31],[11,25,11,30],[12,25,12,30],[2,0,2,35],[6,25,6,30],[5,31,5,35],[12,31,12,35],[13,31,13,35],[5,25,5,30],[3,13,3,24],[14,31,14,35],[21,25,21,30],[22,25,22,30],[23,25,23,30],[22,31,22,35],[24,31,24,35],[5,10,6,12],[23,7,24,9],[21,7,22,9],[3,7,3,9],[9,7,10,9],[13,10,14,12],[13,7,14,9],[19,13,20,16],[19,17,20,24],[21,13,22,16],[4,7,4,9],[4,10,4,12],[7,10,8,12],[9,10,10,12],[11,10,12,12],[19,7,20,9],[11,7,12,9],[15,7,16,9],[15,13,16,24],[1,32,1,35],[4,31,4,35],[4,25,4,30],[4,13,4,24],[5,13,6,24],[0,37,0,39],[1,37,2,37],[1,39,2,39],[0,0,0,35],[1,0,1,3],[1,4,1,9],[1,10,1,16],[3,10,3,12],[3,0,4,6],[5,7,6,9],[3,25,3,30]]}
["2020 Tennessee  - ODC -  Provisional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'Ok' = Likely no Error\n'Error' = Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,null,"Facility Name:",null,null,null,null,null,null,{"$f":"A_Name","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,null,null,null,null,"Yes/No","Approval\nYear data\nprovided","Provider\nnumber\nprovided"]
["Outpatient Diagnostic Centers Joint Annual Report - Schedule C - Licensure, Certifications and Accreditation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Certifications",null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"Participation in TennCare",null,null,null,null,null,null,null,null,null,null,null,"Provider Number",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_TCYN=\"Yes\",C_TCYN=\"No\"=TRUE),\"Ok\",\"Error\")","v":"Error"},"Expiration\nYear data\nprovided",{"$f":"IF(AND(C_TCYN=\"Yes\",C_TCNum<>\"\"),\"Ok\",IF(AND(C_TCYN=\"No\",C_TCNum=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"Participation in Medicare",null,null,null,null,null,null,null,null,null,null,null,"Provider Number",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_MedYN=\"Yes\",C_MedYN=\"No\"=TRUE),\"Ok\",\"Error\")","v":"Error"},null,{"$f":"IF(AND(C_MedYN=\"Yes\",C_MedNum<>\"\"),\"Ok\",IF(AND(C_MedYN=\"No\",C_MedNum=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[" Accreditation and Audits",null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"Joint Commission on Accreditation \nof Healthcare Organizations \n(JCAHO)",null,null,null,null,null,null,null,null,null,null,null,"Approval Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_JCAHOYN=\"Yes\",C_JCAHOYN=\"no\"=TRUE),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(C_JCAHOYN=\"Yes\",C_JCAHOAY<>\"\"),\"Ok\",IF(AND(C_JCAHOYN=\"No\",C_JCAHOAY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiration Year",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C_JCAHOYN=\"Yes\",C_JCAHOEY<>\"\"),\"Ok\",IF(AND(C_JCAHOYN=\"No\",C_JCAHOEY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"Clinical laboratory Improvement Amendments (CLIA)",null,null,null,null,null,null,null,null,null,null,null,"Approval Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_CLIAYN=\"Yes\",C_CLIAYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(C_CLIAYN=\"Yes\",C_CLIAAY<>\"\"),\"Ok\",IF(AND(C_CLIAYN=\"No\",C_CLIAAY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiration Year",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C_CLIAYN=\"Yes\",C_CLIAEY<>\"\"),\"Ok\",IF(AND(C_CLIAYN=\"No\",C_CLIAEY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"Laboratory Proficiency Testing",null,null,null,null,null,null,null,null,null,null,null,"Approval Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_LPTYN=\"Yes\",C_LPTYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(C_LPTYN=\"Yes\",C_LPTAY<>\"\"),\"Ok\",IF(AND(C_LPTYN=\"No\",C_LPTAY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiration Year",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C_LPTYN=\"Yes\",C_LPTEY<>\"\"),\"Ok\",IF(AND(C_LPTYN=\"No\",C_LPTEY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"American Association of Blood \nBanks (AABB)",null,null,null,null,null,null,null,null,null,null,null,"Approval Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_AABBYN=\"Yes\",C_AABBYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(C_AABBYN=\"Yes\",C_AABBAY<>\"\"),\"Ok\",IF(AND(C_AABBYN=\"No\",C_AABBAY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiration Year",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C_AABBYN=\"Yes\",C_AABBEY<>\"\"),\"Ok\",IF(AND(C_AABBYN=\"No\",C_AABBEY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"American Osteopathic Association (AOA)",null,null,null,null,null,null,null,null,null,null,null,"Approval Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_AOAYN=\"Yes\",C_AOAYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(C_AOAYN=\"Yes\",C_AOAAY<>\"\"),\"Ok\",IF(AND(C_AOAYN=\"No\",C_AOAAY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiration Year",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C_AOAYN=\"Yes\",C_AOAEY<>\"\"),\"Ok\",IF(AND(C_AOAYN=\"No\",C_AOAEY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"College of American Pathologists (CAP)",null,null,null,null,null,null,null,null,null,null,null,"Approval Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_CAPYN=\"Yes\",C_CAPYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(C_CAPYN=\"Yes\",C_CAPAY<>\"\"),\"Ok\",IF(AND(C_CAPYN=\"No\",C_CAPAY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiration Year",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C_CAPYN=\"Yes\",C_CAPEY<>\"\"),\"Ok\",IF(AND(C_CAPYN=\"No\",C_CAPEY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"American College of Radiology \n(ACR)",null,null,null,null,null,null,null,null,null,null,null,"Approval Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_ACRYN=\"Yes\",C_ACRYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(C_ACRYN=\"Yes\",C_ACRAY<>\"\"),\"Ok\",IF(AND(C_ACRYN=\"No\",C_ACRAY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiration Year",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C_ACRYN=\"Yes\",C_ACREY<>\"\"),\"Ok\",IF(AND(C_ACRYN=\"No\",C_ACREY=\"\"),\"Ok\",\"Error\"))","v":"Error"},"Other data\nprovided"]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"Other (1), specify",null,null,null,null,null,null,null,null,null,null,null,"Approval Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_OTH1YN=\"Yes\",C_OTH1YN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(C_OTH1YN=\"Yes\",C_OTH1AY<>\"\"),\"Ok\",IF(AND(C_OTH1YN=\"No\",C_OTH1AY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiration Year",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C_OTH1YN=\"Yes\",C_OTH1EY<>\"\"),\"Ok\",IF(AND(C_OTH1YN=\"No\",C_OTH1EY=\"\"),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(C_OTH1YN=\"Yes\",C_OTH1S<>\"\",C_OTH1AY<>\"\",C_OTH1EY<>\"\"),\"Ok\", IF(AND(C_OTH1YN=\"No\",C_OTH1S=\"\",C_OTH1AY=\"\",C_OTH1EY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"Other (2), specify",null,null,null,null,null,null,null,null,null,null,null,"Approval Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_OTH2YN=\"Yes\",C_OTH2YN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(C_OTH2YN=\"Yes\",C_OTH2AY<>\"\"),\"Ok\",IF(AND(C_OTH2YN=\"No\",C_OTH2AY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiration Year",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C_OTH2YN=\"Yes\",C_OTH2EY<>\"\"),\"Ok\",IF(AND(C_OTH2YN=\"No\",C_OTH2EY=\"\"),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(C_OTH2YN=\"Yes\",C_OTH2S<>\"\",C_OTH2AY<>\"\",C_OTH2EY<>\"\"),\"Ok\",IF(AND(C_OTH2YN=\"No\",C_OTH2S=\"\",C_OTH2AY=\"\",C_OTH2EY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"Other (3), specify",null,null,null,null,null,null,null,null,null,null,null,"Approval Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C_OTH3YN=\"Yes\",C_OTH3YN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(C_OTH3YN=\"Yes\",C_OTH3AY<>\"\"),\"Ok\",IF(AND(C_OTH3YN=\"No\",C_OTH3AY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiration Year",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C_OTH3YN=\"Yes\",C_OTH3EY<>\"\"),\"Ok\",IF(AND(C_OTH3YN=\"No\",C_OTH3EY=\"\"),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(C_OTH3YN=\"Yes\",C_OTH3S<>\"\",C_OTH3S<>\"\",C_OTH3AY<>\"\",C_OTH3EY<>\"\"),\"Ok\",IF(AND(C_OTH3YN=\"No\",C_OTH3S=\"\",C_OTH3AY=\"\",C_OTH3EY=\"\"),\"Ok\",\"Error\"))","v":"Error"}]
["Go to Next Schedule"]
["Return to Main Menu"]
["Go to Error Listing"]

{"sheet":"C","index":8,"n_rows":4,"n_cols":40,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,1,2],[0,3,0,6],[1,3,1,4],[1,5,1,6]]}
["Facility ID Info",null,null,"Certifications",null,null,null,"Accreditation and Audits"]
[null,null,null,"TennCare",null,"Medicare",null,"JCAHO",null,null,"CLIA",null,null,"Lab Proficiency Testing",null,null,"AABB",null,null,"AOA",null,null,"CAP",null,null,"ACR",null,null,"Other 1",null,null,null,"Other 2",null,null,null,"Other 3"]
["State ID","Facility\nName","County","Yes/No","Provider\nNumber","Yes/No","Medicare\nNumber","Yes/No","Year\nmost\nrecently\nupdated","Year\nwill\nexpire","Yes/No","Year\nmost\nrecently\nupdated","Year\nwill\nexpire","Yes/No","Year\nmost\nrecently\nupdated","Year\nwill\nexpire","Yes/No","Year\nmost\nrecently\nupdated","Year\nwill\nexpire","Yes/No","Year\nmost\nrecently\nupdated","Year\nwill\nexpire","Yes/No","Year\nmost\nrecently\nupdated","Year\nwill\nexpire","Yes/No","Year\nmost\nrecently\nupdated","Year\nwill\nexpire","Yes/No","Specify","Year\nmost\nrecently\nupdated","Year\nwill\nexpire","Yes/No","Specify","Year\nmost\nrecently\nupdated","Year\nwill\nexpire","Yes/No","Specify","Year\nmost\nrecently\nupdated","Year\nwill\nexpire"]
[{"$f":"A_StateID","v":0},{"$f":"A_Name","v":"-"},{"$f":"A_County","v":"-"},{"$f":"C_TCYN","v":"-"},{"$f":"C_TCNum","v":0},{"$f":"C_MedYN","v":"-"},{"$f":"C_MedNum","v":0},{"$f":"C_JCAHOYN","v":"-"},{"$f":"C_JCAHOAY","v":0},{"$f":"C_JCAHOEY","v":0},{"$f":"C_CLIAYN","v":"-"},{"$f":"C_CLIAAY","v":0},{"$f":"C_CLIAEY","v":0},{"$f":"C_LPTYN","v":"-"},{"$f":"C_LPTAY","v":0},{"$f":"C_LPTEY","v":0},{"$f":"C_AABBYN","v":"-"},{"$f":"C_AABBAY","v":0},{"$f":"C_AABBEY","v":0},{"$f":"C_AOAYN","v":"-"},{"$f":"C_AOAAY","v":0},{"$f":"C_AOAEY","v":0},{"$f":"C_CAPYN","v":"-"},{"$f":"C_CAPAY","v":0},{"$f":"C_CAPEY","v":0},{"$f":"C_ACRYN","v":"-"},{"$f":"C_ACRAY","v":0},{"$f":"C_ACREY","v":0},{"$f":"C_OTH1YN","v":"-"},{"$f":"C_OTH1S","v":0},{"$f":"C_OTH1AY","v":0},{"$f":"C_OTH1EY","v":0},{"$f":"C_OTH2YN","v":"-"},{"$f":"C_OTH2S","v":0},{"$f":"C_OTH2AY","v":0},{"$f":"C_OTH2EY","v":0},{"$f":"C_OTH3YN","v":"-"},{"$f":"C_OTH3S","v":0},{"$f":"C_OTH3AY","v":0},{"$f":"C_OTH3EY","v":0}]

{"sheet":"Sch D","index":9,"n_rows":43,"n_cols":47,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,17,1,31],[3,41,5,41],[16,38,17,38],[16,39,17,39],[3,40,5,40],[37,39,38,40],[35,13,36,15],[35,28,36,31],[35,32,36,35],[35,16,36,19],[35,20,36,23],[35,24,36,27],[38,4,38,31],[36,37,38,37],[25,32,25,35],[27,32,27,35],[28,32,28,35],[26,32,26,35],[33,28,33,31],[33,32,33,35],[29,32,29,35],[30,32,30,35],[25,28,25,31],[29,28,29,31],[12,0,25,3],[37,0,38,3],[39,0,39,3],[37,28,37,31],[37,32,37,35],[37,4,37,27],[31,24,32,27],[34,28,34,31],[34,32,34,35],[36,4,36,12],[34,4,34,12],[34,13,34,15],[34,16,34,19],[34,20,34,23],[35,4,35,12],[33,4,33,12],[33,13,33,15],[33,16,33,19],[33,20,33,23],[34,24,34,27],[24,32,24,35],[33,24,33,27],[29,16,29,27],[30,16,30,27],[30,28,30,31],[28,16,28,27],[39,4,39,31],[38,32,38,35],[39,32,39,35],[24,28,24,31],[29,4,29,12],[30,4,30,12],[24,13,24,15],[25,13,25,15],[27,13,27,15],[28,13,28,15],[30,13,30,15],[26,13,26,15],[27,16,27,27],[25,4,25,12],[26,16,26,27],[27,28,27,31],[28,28,28,31],[26,28,26,31],[31,4,32,12],[31,13,32,15],[29,13,29,15],[22,32,22,35],[23,32,23,35],[14,32,14,35],[15,32,15,35],[18,32,18,35],[24,4,24,12],[17,20,17,23],[16,24,17,27],[20,28,20,31],[21,28,21,31],[20,32,20,35],[21,32,21,35],[22,28,22,31],[23,24,23,27],[18,28,18,31],[21,20,21,23],[21,16,21,19],[18,24,18,27],[19,24,19,27],[20,24,20,27],[18,16,18,19],[23,28,23,31],[23,16,23,19],[18,4,18,12],[41,0,41,35],[42,0,42,35],[40,0,40,35],[21,13,21,15],[23,4,23,12],[22,4,22,12],[22,13,22,15],[3,0,3,35],[16,4,17,12],[16,13,17,15],[16,16,16,23],[17,16,17,19],[21,24,21,27],[19,28,19,31],[21,4,21,12],[18,13,18,15],[19,13,19,15],[8,4,8,12],[19,32,19,35],[13,28,13,31],[5,16,5,27],[7,13,7,15],[7,32,7,35],[15,28,15,31],[0,37,0,41],[5,13,5,15],[2,0,2,35],[0,0,0,35],[1,0,1,3],[1,4,1,9],[1,10,1,16],[5,0,11,3],[5,4,5,12],[6,4,6,12],[11,4,11,12],[10,13,10,15],[11,13,11,15],[7,4,7,12],[9,28,9,31],[11,28,11,31],[11,32,11,35],[5,32,5,35],[5,28,5,31],[6,32,6,35],[8,28,8,31],[8,32,8,35],[9,32,9,35],[1,32,1,35],[13,32,13,35],[12,32,12,35],[12,28,12,31],[14,28,14,31],[12,16,12,27],[10,28,10,31],[6,16,11,27],[13,16,15,27],[9,4,9,12],[22,16,22,19],[13,4,13,12],[19,20,19,23],[23,13,23,15],[6,13,6,15],[8,13,8,15],[9,13,9,15],[12,13,12,15],[19,4,19,12],[20,4,20,12],[15,4,15,12],[14,4,14,12],[20,13,20,15],[15,13,15,15],[12,4,12,12],[10,4,10,12],[20,20,20,23],[20,16,20,19],[13,13,13,15],[19,16,19,19],[18,20,18,23],[14,13,14,15],[37,41,38,41],[4,37,5,37],[31,28,31,35],[32,28,32,31],[32,32,32,35],[7,28,7,31],[10,32,10,35],[17,28,17,31],[17,32,17,35],[16,28,16,35],[4,0,4,35],[6,28,6,31],[31,16,31,23],[32,16,32,19],[32,20,32,23],[28,4,28,12],[24,16,24,27],[25,16,25,27],[26,0,36,3],[26,4,26,12],[22,24,22,27],[27,4,27,12],[22,20,22,23],[23,20,23,23]]}
["2020 Tennessee - ODC -  Provisional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'Ok' = Likely no Error\n'Error' = Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,null,"Facility Name:",null,null,null,null,null,null,{"$f":"A_Name","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]
["Outpatient Diagnostic Centers Joint Annual Report -  Schedule D - Availability and Utilization of Services/Equipment"]
["If \"Yes\" provide information requested and indicate the number of patients and diagnostic procedures for those  \nservices during the reporting period.  Number of patients may include duplicates because the same patient may \nreceive several of the services listed.  Mobile units are units regularly transported to your facility that are not installed \nfor daily use.  Do not report equipment, patients or procedures already reported on a hospital Joint Annual Report.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes,\nindicated\nPatients \nand\nProc-\ndures\nprovided","Patients\nequal to\nor less\nthan\nProc-\ndures"]
["Do not enter zero.  Blank fields will represent zero patients and/or procedures.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes/No"]
["Cardio-\npulmonary",null,null,null,"Type of Service",null,null,null,null,null,null,null,null,"Yes/No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patients",null,null,null,"Procedures"]
[null,null,null,null,"Electroencephalogram (EEG)",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_CEEGYN=\"Yes\",D_CEEGYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_CEEGYN=\"Yes\",AQ7>=1),\"Ok\",IF(AND(D_CEEGYN=\"No\",AQ7=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_CEEGPRO>=D_CEEGPAT,\"Ok\",\"Error\")","v":"Ok"},{"$f":"SUM(AC7:AJ7)","v":0}]
[null,null,null,null,"Electrocardiogram (EKG)",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_CEKGYN=\"Yes\",D_CEKGYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_CEKGYN=\"Yes\",AQ8>=1),\"Ok\",IF(AND(D_CEKGYN=\"No\",AQ8=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_EKGPRO>=D_CEKGPAT,\"Ok\",\"Error\")","v":"Ok"},0]
[null,null,null,null,"Holter Monitoring",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_CHMYN=\"Yes\",D_CHMYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_CHMYN=\"Yes\",AQ9>=1),\"Ok\",IF(AND(D_CHMYN=\"No\",AQ9=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_CHMPRO>=D_CHMPAT,\"Ok\",\"Error\")","v":"Ok"},0]
[null,null,null,null,"Exercise Tolerance Testing",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_CETTYN=\"Yes\",D_CETTYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_CETTYN=\"Yes\",AQ10>=1),\"Ok\",IF(AND(D_CETTYN=\"No\",AQ10=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_CETTPRO>=D_CETTPAT,\"Ok\",\"Error\")","v":"Ok"},0]
[null,null,null,null,"Cardiac Catheterization",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_CCCYN=\"Yes\",D_CCCYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_CCCYN=\"Yes\",AQ11>=1),\"Ok\",IF(AND(D_CCCYN=\"No\",AQ11=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_CCCPRO>=D_CCCPAT,\"Ok\",\"Error\")","v":"Ok"},0]
[null,null,null,null,"Percutaneous Transluminal Coronary Angioplasty",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_CPTYN=\"Yes\",D_CPTYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_CPTYN=\"Yes\",AQ12>=1),\"Ok\",IF(AND(D_CPTYN=\"No\",AQ12=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_CPTPRO>=D_CPTPAT,\"Ok\",\"Error\")","v":"Ok"},0]
["Radiology",null,null,null,"Type of Service",null,null,null,null,null,null,null,null,"Yes/No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patients",null,null,null,"Procedures"]
[null,null,null,null,"Radiography (Diagnostic\nand Special Procedures-\n e.g. Angiography)",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_RRADYN=\"Yes\",D_RRADYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_RRADYN=\"Yes\",AQ14>=1),\"Ok\",IF(AND(D_RRADYN=\"No\",AQ14=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_RRADPRO>=D_RRADPAT,\"Ok\",\"Error\")","v":"Ok"},{"$f":"SUM(AC14:AJ14)","v":0}]
[null,null,null,null,"Ultrasound (General/Vascular/Cardiac)",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_RULTYN=\"Yes\",D_RULTYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_RULTYN=\"Yes\",AQ15>=1),\"Ok\",IF(AND(D_RULTYN=\"No\",AQ15=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_RULTPRO>=D_RULTPAT,\"Ok\",\"Error\")","v":"Ok"},{"$f":"SUM(AC15:AJ15)","v":0}]
[null,null,null,null,"Nuclear Medicine",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_RNMYN=\"Yes\",D_RNMYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_RNMYN=\"Yes\",AQ16>=1),\"Ok\",IF(AND(D_RNMYN=\"No\",AQ16=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_RNMPRO>=D_RNMPAT,\"Ok\",\"Error\")","v":"Ok"},{"$f":"SUM(AC16:AJ16)","v":0}]
[null,null,null,null,"Type of Equipment on Site",null,null,null,null,null,null,null,null,"Yes/No",null,null,"Number of Units",null,null,null,null,null,null,null,"If Mobile,\nnumber of\ndays per\nweek",null,null,null,"Fixed plus Mobile",null,null,null,null,null,null,null,null,null,"Yes,\nindicated\nnumber\nof units\nprovided","Mobile\nunits\nindicated,\ndays \nprovided"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed",null,null,null,"Mobile",null,null,null,null,null,null,null,"Patients",null,null,null,"Procedures"]
[null,null,null,null,"Positron Emission Tomography (PET scan)",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_RPETYN=\"Yes\",D_RPETYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(D_RPETYN=\"Yes\",AR19>=1),\"Ok\",IF(AND(D_RPETYN=\"No\",AR19=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(D_RPETM>=1,D_RPETN>=1),\"Ok\",IF(AND(D_RPETM=0,D_RPETN=0),\"Ok\",\"Error\"))","v":"Ok"},{"$f":"IF(AND(D_RPETYN=\"Yes\",AQ19>=1),\"Ok\",IF(AND(D_RPETYN=\"No\",AQ19=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_RPETPRO>=D_RPETPAT,\"Ok\",\"Error\")","v":"Ok"},{"$f":"SUM(AC19:AJ19)","v":0},{"$f":"SUM(Q19:X19)","v":0}]
[null,null,null,null,"Computed Tomography \n(CT scan)",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_RCTYN=\"Yes\",D_RCTYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(D_RCTYN=\"Yes\",AR20>=1),\"Ok\",IF(AND(D_RCTYN=\"No\",AR20=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(D_RCTM>=1,D_RCTN>=1),\"Ok\",IF(AND(D_RCTM=0,D_RCTN=0),\"Ok\",\"Error\"))","v":"Ok"},{"$f":"IF(AND(D_RCTYN=\"Yes\",AQ20>=1),\"Ok\",IF(AND(D_RCTYN=\"No\",AQ20=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_RCTPRO>=D_RCTPAT,\"Ok\",\"Error\")","v":"Ok"},0,0]
[null,null,null,null,"Ultrafast CT",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_RUTCYN=\"Yes\",D_RUTCYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(D_RUTCYN=\"Yes\",AR21>=1),\"Ok\",IF(AND(D_RUTCYN=\"No\",AR21=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(D_RUCTM>=1,D_RUCTN>=1),\"Ok\",IF(AND(D_RUCTM=0,D_RUCTN=0),\"Ok\",\"Error\"))","v":"Ok"},{"$f":"IF(AND(D_RUTCYN=\"Yes\",AQ21>=1),\"Ok\",IF(AND(D_RUTCYN=\"No\",AQ21=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_RUCTPRO>=D_RUCTPAT,\"Ok\",\"Error\")","v":"Ok"},0,0]
[null,null,null,null,"Magnetic Resonance Imaging (MRI)",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_RMCIYN=\"Yes\",D_RMCIYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(D_RMCIYN=\"Yes\",AR22>=1),\"Ok\",IF(AND(D_RMCIYN=\"No\",AR22=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(D_RMRIM>=1,D_RMRIN>=1),\"Ok\",IF(AND(D_RMRIM=0,D_RMRIN=0),\"Ok\",\"Error\"))","v":"Ok"},{"$f":"IF(AND(D_RMCIYN=\"Yes\",AQ22>=1),\"Ok\",IF(AND(D_RMCIYN=\"No\",AQ22=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_RMRIPRO>=D_RMRIPAT,\"Ok\",\"Error\")","v":"Ok"},0,0]
[null,null,null,null,"Hi-Field MRI and Open MRI",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_RHMRIYN=\"Yes\",D_RHMRIYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(D_RHMRIYN=\"Yes\",AR23>=1),\"Ok\",IF(AND(D_RHMRIYN=\"No\",AR23=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(D_RHMRIM>=1,D_RHMRIN>=1),\"Ok\",IF(AND(D_RHMRIM=0,D_RHMRIN=0),\"Ok\",\"Error\"))","v":"Ok"},{"$f":"IF(AND(D_RHMRIYN=\"Yes\",AQ23>=1),\"Ok\",IF(AND(D_RHMRIYN=\"No\",AQ23=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_RHMRIPRO>=D_RHMRIPAT,\"Ok\",\"Error\")","v":"Ok"},0,0]
[null,null,null,null,"Megavoltage Radiation Therapy",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_RMRTYN=\"Yes\",D_RMRTYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(D_RMRTYN=\"Yes\",AR24>=1),\"Ok\",IF(AND(D_RMRTYN=\"No\",AR24=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(D_RMRTM>=1,D_RMRTN>=1),\"Ok\",IF(AND(D_RMRTM=0,D_RMRTN=0),\"Ok\",\"Error\"))","v":"Ok"},{"$f":"IF(AND(D_RMRTYN=\"Yes\",AQ24>=1),\"Ok\",IF(AND(D_RMRTYN=\"No\",AQ24=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_RMRTPRO>=D_RMRTPAT,\"Ok\",\"Error\")","v":"Ok"},0,0]
[null,null,null,null,"Stereotactic Procedure (including breast Biopsy)",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_RSPYN=\"Yes\",D_RSPYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_RSPYN=\"Yes\",AQ25>=1),\"Ok\",IF(AND(D_RSPYN=\"No\",AQ25=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_RSPPRO>=D_RSPPAT,\"Ok\",\"Error\")","v":"Ok"},0]
[null,null,null,null,"Mammography",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_RMAMYN=\"Yes\",D_RMAMYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_RMAMYN=\"Yes\",AQ26>=1),\"Ok\",IF(AND(D_RMAMYN=\"No\",AQ26=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_RMAMPRO>=D_RMAMPAT,\"Ok\",\"Error\")","v":"Ok"},0]
["Other",null,null,null,"Type of Service",null,null,null,null,null,null,null,null,"Yes/No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patients",null,null,null,"Procedures"]
[null,null,null,null,"Vascular Embolization",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_OVEYN=\"Yes\",D_OVEYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_OVEYN=\"Yes\",AQ28>=1),\"Ok\",IF(AND(D_OVEYN=\"No\",AQ28=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_OVEPRO>=D_OVEPAT,\"Ok\",\"Error\")","v":"Ok"},{"$f":"SUM(AC28:AJ28)","v":0}]
[null,null,null,null,"Anesthesia",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_OAYN=\"Yes\",D_OAYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_OAYN=\"Yes\",AQ29>=1),\"Ok\",IF(AND(D_OAYN=\"No\",AQ29=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_OAPRO>=D_OAPAT,\"Ok\",\"Error\")","v":"Ok"},{"$f":"SUM(AC29:AJ29)","v":0}]
[null,null,null,null,"Ultrasound \n(ACR Accredited Breast/\nPelvic/OB)",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_OACRYN=\"Yes\",D_OACRYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_OACRYN=\"Yes\",AQ30>=1),\"Ok\",IF(AND(D_OACRYN=\"No\",AQ30=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_OACRPRO>=D_OACRPAT,\"Ok\",\"Error\")","v":"Ok"},{"$f":"SUM(AC30:AJ30)","v":0}]
[null,null,null,null,"Chemotherapy",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_OCYN=\"Yes\",D_OCYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(AND(D_OCYN=\"Yes\",AQ31>=1),\"Ok\",IF(AND(D_OCYN=\"No\",AQ31=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_OCPRO>=D_OCPAT,\"Ok\",\"Error\")","v":"Ok"},{"$f":"SUM(AC31:AJ31)","v":0}]
[null,null,null,null,"Type of Equipment on Site",null,null,null,null,null,null,null,null,"Yes/No",null,null,"Number of Units",null,null,null,null,null,null,null,"If Mobile,\nnumber of\ndays per\nweek",null,null,null,"Fixed plus Mobile"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed",null,null,null,"Mobile",null,null,null,null,null,null,null,"Patients",null,null,null,"Procedures",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC7:AF12)","v":0},{"$f":"SUM(AG7:AJ12)","v":0}]
[null,null,null,null,"Lithotripsy",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_OLYN=\"Yes\",D_OLYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(D_OLYN=\"Yes\",AR34>=1),\"Ok\",IF(AND(D_OLYN=\"No\",AR34=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(D_OLM>=1,D_OLN>=1),\"Ok\",IF(AND(D_OLM=0,D_OLN=0),\"Ok\",\"Error\"))","v":"Ok"},{"$f":"IF(AND(D_OLYN=\"Yes\",AQ34>=1),\"Ok\",IF(AND(D_OLYN=\"No\",AQ34=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_OLPRO>=D_OLPAT,\"Ok\",\"Error\")","v":"Ok"},{"$f":"SUM(AC34:AJ34)","v":0},{"$f":"SUM(Q34:X34)","v":0},{"$f":"SUM(AC14:AF16)","v":0},{"$f":"SUM(AG14:AJ16)","v":0}]
[null,null,null,null,"Bone Densitometry",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_OBDYN=\"Yes\",D_OBDYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(D_OBDYN=\"Yes\",AR35>=1),\"Ok\",IF(AND(D_OBDYN=\"No\",AR35=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(D_OBDM>=1,B_OBDN>=1),\"Ok\",IF(AND(D_OBDM=0,B_OBDN=0),\"Ok\",\"Error\"))","v":"Ok"},{"$f":"IF(AND(D_OBDYN=\"Yes\",AQ35>=1),\"Ok\",IF(AND(D_OBDYN=\"No\",AQ35=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_OBDPRO>=D_OBDPAT,\"Ok\",\"Error\")","v":"Ok"},{"$f":"SUM(AC35:AJ35)","v":0},{"$f":"SUM(Q35:X35)","v":0},{"$f":"SUM(AC19:AF26)","v":0},{"$f":"SUM(AG19:AJ26)","v":0}]
[null,null,null,null,"Other, Specify",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D_OSPYN=\"Yes\",D_OSPYN=\"No\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(D_OSPYN=\"Yes\",AR37>=1),\"Ok\",IF(AND(D_OSPYN=\"No\",AR37=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(AND(D_OOM>=1,D_OON>=1),\"Ok\",IF(AND(D_OOM=0,D_OON=0),\"Ok\",\"Error\"))","v":"Ok"},{"$f":"IF(AND(D_OSPYN=\"Yes\",AQ37>=1),\"Ok\",IF(AND(D_OSPYN=\"No\",AQ37=0),\"Ok\",\"Error\"))","v":"Error"},{"$f":"IF(D_OOPro>=D_OOPat,\"Ok\",\"Error\")","v":"Ok"},null,null,{"$f":"SUM(AC28:AF31)","v":0},{"$f":"SUM(AG28:AJ31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other\nanswered Yes,\nProvide Additional\ndata",null,null,null,null,{"$f":"SUM(AC36:AJ37)","v":0},{"$f":"SUM(Q36:X37)","v":0},{"$f":"SUM(AC34:AF37)","v":0},{"$f":"SUM(AG34:AJ37)","v":0},{"$f":"SUM(AJ36:AQ37)","v":0}]
["Total",null,null,null,"Total number of patients and diagnostic procedures during this reporting \nperiod.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AS38","v":0},null,null,null,{"$f":"AT38","v":0},null,null,null,null,null,null,"Unduplicated \npatients less than \nor equal to Total \nnumber of patients",null,"Rooms\ndata\nprovided",null,null,{"$f":"SUM(AS33:AS37)","v":0},{"$f":"SUM(AT33:AT37)","v":0}]
[null,null,null,null,"Total Unduplicated Patients:  The number of actual individuals served during the reporting period.  This may be less than the number of patients and diagnostic procedures reported."]
["Rooms",null,null,null,"Number of Diagnostic Procedure rooms.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D_OSPYN=\"Yes\",D_OOSP<>\"\"),\"Ok\",IF(AND(D_OSPYN=\"No\",D_OOSP=\"\"),\"Ok\",\"Error\"))","v":"Error"},null,{"$f":"IF(D_TOTPAT>=D_UDP,\"Ok\",\"Error\")","v":"Ok"},null,{"$f":"IF(D_ROOM<>\"\",\"Ok\",\"Error\")","v":"Error"}]
["Go to Next Schedule"]
["Return to Main Menu"]
["Go to Error Listing"]

{"sheet":"D","index":10,"n_rows":4,"n_cols":107,"rows_kept":4,"cut":false,"hidden":true,"merged":[[1,12,1,14],[1,15,1,17],[1,18,1,20],[1,21,1,23],[0,0,1,2],[1,3,1,5],[1,6,1,8],[1,9,1,11],[1,66,1,68],[1,69,1,71],[1,72,1,74],[1,75,1,77],[1,24,1,26],[1,27,1,29],[1,30,1,35],[1,60,1,65],[1,54,1,59],[1,48,1,53],[1,42,1,47],[1,36,1,41],[1,103,1,104],[1,78,1,80],[1,81,1,83],[1,96,1,102],[1,90,1,95],[1,84,1,89]]}
["Facility ID Info",null,null,"Cardiopulmonary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radiology",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals",null,null,"Rooms"]
[null,null,null,"Electroencephalogram (EEG)",null,null,"Electrocardiogram (EKG)",null,null,"Holter Monitoring",null,null,"Exercise Tolerance Testing",null,null,"Cardiac Catheterization",null,null,"Percutaneous Transiuminal Coronary \nAngioplasty",null,null,"Radiography (Diagnostic and Special\nProcedures e.g. Angiography)",null,null,"Ultrasound (General/Vascular/Cardiac)",null,null,"Nuclear medicine",null,null,"Positron Emission Tomography (PET scan)",null,null,null,null,null,"Computed Tomography (CT scan)",null,null,null,null,null,"Ultrafast CT",null,null,null,null,null,"Magnetic Resonance imaging (MRI)",null,null,null,null,null,"Hi Field MRI and Open MRI",null,null,null,null,null,"Megavoltage Rediation Therapy",null,null,null,null,null,"Stereotactic Procedure \n(including breast Biopsy)",null,null,"Mammography",null,null,"Vascular Embolization",null,null,"Anesthesia",null,null,"Ultrasound (ACR Accredited)",null,null,"Chemotherapy",null,null,"Lithotripsy",null,null,null,null,null,"Bone Densitometry",null,null,null,null,null,"Other",null,null,null,null,null,null,"Total",null,null,"Rooms"]
["State ID","Facility\nName","County","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Fixed\nUnits","Mobile\nUnits","Number\nof days\nmobile unit\nperweek","Patients","Procedures","Yes/No","Fixed\nUnits","Mobile\nUnits","Number\nof days\nmobile unit\nperweek","Patients","Procedures","Yes/No","Fixed\nUnits","Mobile\nUnits","Number\nof days\nmobile unit\nperweek","Patients","Procedures","Yes/No","Fixed\nUnits","Mobile\nUnits","Number\nof days\nmobile unit\nperweek","Patients","Procedures","Yes/No","Fixed\nUnits","Mobile\nUnits","Number\nof days\nmobile unit\nperweek","Patients","Procedures","Yes/No","Fixed\nUnits","Mobile\nUnits","Number\nof days\nmobile unit\nperweek","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Patients","Procedures","Yes/No","Fixed\nUnits","Mobile\nUnits","Number\nof days\nmobile unit\nperweek","Patients","Procedures","Yes/No","Fixed\nUnits","Mobile\nUnits","Number\nof days\nmobile unit\nperweek","Patients","Procedures","Yes/No","Specify","Fixed\nUnits","Mobile\nUnits","Number\nof days\nmobile unit\nperweek","Patients","Procedures","Patients","Procedures","Unduplicated\nPatients","Diagnostic\nprocedure\nrooms"]
[{"$f":"A_StateID","v":0},{"$f":"A_Name","v":"-"},{"$f":"A_County","v":"-"},{"$f":"D_CEEGYN","v":"-"},{"$f":"D_CEEGPAT","v":0},{"$f":"D_CEEGPRO","v":0},{"$f":"D_CEKGYN","v":"-"},{"$f":"D_CEKGPAT","v":0},{"$f":"D_EKGPRO","v":0},{"$f":"D_CHMYN","v":"-"},{"$f":"D_CHMPAT","v":0},{"$f":"D_CHMPRO","v":0},{"$f":"D_CETTYN","v":"-"},{"$f":"D_CETTPAT","v":0},{"$f":"D_CETTPRO","v":0},{"$f":"D_CCCYN","v":"-"},{"$f":"D_CCCPAT","v":0},{"$f":"D_CCCPRO","v":0},{"$f":"D_CPTYN","v":"-"},{"$f":"D_CPTPAT","v":0},{"$f":"D_CPTPRO","v":0},{"$f":"D_RRADYN","v":"-"},{"$f":"D_RRADPAT","v":0},{"$f":"D_RRADPRO","v":0},{"$f":"D_RULTYN","v":"-"},{"$f":"D_RULTPAT","v":0},{"$f":"D_RULTPRO","v":0},{"$f":"D_RNMYN","v":"-"},{"$f":"D_RNMPAT","v":0},{"$f":"D_RNMPRO","v":0},{"$f":"D_RPETYN","v":"-"},{"$f":"D_RPETF","v":0},{"$f":"D_RPETM","v":0},{"$f":"D_RPETN","v":0},{"$f":"D_RPETPAT","v":0},{"$f":"D_RPETPRO","v":0},{"$f":"D_RCTYN","v":"-"},{"$f":"D_RCTF","v":0},{"$f":"D_RCTM","v":0},{"$f":"D_RCTN","v":0},{"$f":"D_RCTPAT","v":0},{"$f":"D_RCTPRO","v":0},{"$f":"D_RUTCYN","v":"-"},{"$f":"D_RUCTF","v":0},{"$f":"D_RUCTM","v":0},{"$f":"D_RUCTN","v":0},{"$f":"D_RUCTPAT","v":0},{"$f":"D_RUCTPRO","v":0},{"$f":"D_RMCIYN","v":"-"},{"$f":"D_RMRIF","v":0},{"$f":"D_RMRIM","v":0},{"$f":"D_RMRIN","v":0},{"$f":"D_RMRIPAT","v":0},{"$f":"D_RMRIPRO","v":0},{"$f":"D_RHMRIYN","v":"-"},{"$f":"D_RHMRIF","v":0},{"$f":"D_RHMRIM","v":0},{"$f":"D_RHMRIN","v":0},{"$f":"D_RHMRIPAT","v":0},{"$f":"D_RHMRIPRO","v":0},{"$f":"D_RMRTYN","v":"-"},{"$f":"D_RMRTF","v":0},{"$f":"D_RMRTM","v":0},{"$f":"D_RMRTN","v":0},{"$f":"D_RMRTPAT","v":0},{"$f":"D_RMRTPRO","v":0},{"$f":"D_RSPYN","v":"-"},{"$f":"D_RSPPAT","v":0},{"$f":"D_RSPPRO","v":0},{"$f":"D_RMAMYN","v":"-"},{"$f":"D_RMAMPAT","v":0},{"$f":"D_RMAMPRO","v":0},{"$f":"D_OVEYN","v":"-"},{"$f":"D_OVEPAT","v":0},{"$f":"D_OVEPRO","v":0},{"$f":"D_OAYN","v":"-"},{"$f":"D_OAPAT","v":0},{"$f":"D_OAPRO","v":0},{"$f":"D_OACRYN","v":"-"},{"$f":"D_OACRPAT","v":0},{"$f":"D_OACRPRO","v":0},{"$f":"D_OCYN","v":"-"},{"$f":"D_OCPAT","v":0},{"$f":"D_OCPRO","v":0},{"$f":"D_OLYN","v":"-"},{"$f":"D_OLF","v":0},{"$f":"D_OLM","v":0},{"$f":"D_OLN","v":0},{"$f":"D_OLPAT","v":0},{"$f":"D_OLPRO","v":0},{"$f":"D_OBDYN","v":"-"},{"$f":"D_OBDF","v":0},{"$f":"D_OBDM","v":0},{"$f":"B_OBDN","v":0},{"$f":"D_OBDPAT","v":0},{"$f":"D_OBDPRO","v":0},{"$f":"D_OSPYN","v":"-"},{"$f":"D_OOSP","v":0},{"$f":"D_OOF","v":0},{"$f":"D_OOM","v":0},{"$f":"D_OON","v":0},{"$f":"D_OSPPAT","v":0},{"$f":"D_OSPPRO","v":0},{"$f":"D_TOTPAT","v":0},{"$f":"D_TOTPRO","v":0},{"$f":"D_UDP","v":0},{"$f":"D_ROOM","v":0}]

{"sheet":"LAYOUT","index":11,"n_rows":605,"n_cols":5,"rows_kept":605,"cut":false,"hidden":true,"merged":[]}
["A","Facility ID Info",null,"State ID"," A_StateID"]
["A",null,null,"Facility\nName"," A_Name"]
["A",null,null,"County"," A_County"]
["A","Facility",null,"State ID"," A_StateID"]
["A",null,null,"Name"," A_Name"]
["A",null,"Name Change during year?","Yes/No"," A_NameChange"]
["A",null,null,"Prior name"," A_PriorName"]
["A",null,null,"Street\nAddress"," A_StreetAddress"]
["A",null,null,"City"," A_City"]
["A",null,null,"County"," A_County"]
["A",null,null,"State"," A_State"]
["A",null,null,"Zip Code"," A_Zip"]
["A",null,"Mailing Address","Yes/No","A_MAYN"]
["A",null,null,"Address","A_MA"]
["A",null,null,"City","A_MAC"]
["A",null,null,"State","A_MAS"]
["A",null,null,"Zip Code","A_MAZ"]
["A",null,null,"Phone"," A_Phone"]
["A","Preparer",null,"Name"," A_PrepName"]
["A",null,null,"Phone"," A_PrepPhone"]
["A",null,null,"Title"," A_PrepTitle"]
["A",null,null,"E-Mail"," A_PrepEMail"]
["A","Reporting Period",null,"Yes/No"," A_RptPeriodYN"]
["A",null,null,"Beginning\nDate\nmm/dd/yyyy"," A_RptBegDate"]
["A",null,null,"Ending\nDate\nmm/dd/yyyy"," A_RptEndDate"]
["A","Administration",null,"Administrator's\nName"," A_Admin"]
["A",null,null,"Medical\nDirector's\nName"," A_MedDir"]
["B","Facility ID Info",null,"State ID","A_StateID"]
["B",null,null,"Facility\nName","A_Name"]
["B",null,null,"County","A_County"]
["B","Owner",null,"Name","B_OwName"]
["B",null,null,"Street","B_OwStreet"]
["B",null,null,"City","B_OwCity"]
["B",null,null,"State","B_OwState"]
["B",null,null,"Phone","B_OwPhone"]
["B",null,null,"Zip Code","B_OwZip"]
["B","Owner Type","For Profit","Proprietor-\nship","B_TypeProfProp"]
["B",null,null,"Gneral\nPartnership","B_TypeProfPart"]
["B",null,null,"Limited \nPartnership\n(LP)","B_TypeProfLP"]
["B",null,null,"Limited\nLiability\nPartnership\n(LLP)","B_TypeProfLLP"]
["B",null,null,"Limited \nLiability\nCompany\n(LLC)","B_TypeProfLLC"]
["B",null,null,"Corporation","B_TypeProfCorp"]
["B",null,"Not for Profit","Non-\nReligious\nCorp or\nAssociation","B_TypeNotPNonRelg"]
["B",null,null,"Religious\nCorp or\nAssociation","B_TypeNotPRelg"]
["B",null,null,"Limited\nLiability\nCompany\n(LLC)","B_TypeNotPLLC"]
["B",null,"Government","City","B_TypeGovtCity"]
["B",null,null,"County","B_TypeGovtCounty"]
["B",null,null,"State","B_TypeGovtState"]
["B",null,null,"Federal","B_TypeGovtFed"]
["B",null,null,"Other\nGovernment","B_TypeGovtOther"]
["B",null,null,"Other\nGovernment\nSpecify","B_TypeGovtOtherName"]
["B","Managed by","Management is provided by","Owner","B_MOwn"]
["B",null,null,"Contract \nwith firm","B_MCon"]
["B",null,null,"Other","B_MOth"]
["B",null,null,"Other,\nSpecify","B_MOthS"]
["B",null,null,"Name","B_MName"]
["B",null,null,"Street","B_MStreet"]
["B",null,null,"City","B_MCity"]
["B",null,null,"State","B_MState"]
["B",null,null,"Zip","B_MZip"]
["B",null,null,"Phone","B_MPhone"]
["B","Building Owner",null,"Name","B_BOName"]
["B",null,null,"Street","B_BOStreet"]
["B",null,null,"City","B_BOCity"]
["B",null,null,"State","B_BOState"]
["B",null,null,"Zip","B_MZip"]
["B",null,null,"Phone","B_BOPhone"]
["B","Building",null,"Yes/No","B_BYNCon"]
["B",null,null,"Original\nContruction\nDate\nYear","B_BConYr"]
["B",null,null,"Yes/No","B_BYNRen"]
["B",null,null,"Major\nrenovation\nYear","B_BRenYr"]
["B","Type of Facility","Free Standing","Yes/No","B_FFSYN"]
["B",null,"Hospital Based","Yes/No","B_FHBYN"]
["B",null,null,"Name","B_FHBNM"]
["B",null,null,"Street","B_FHBST"]
["B",null,null,"City","B_FHBCI"]
["B",null,null,"State","B_FHBS"]
["B",null,null,"Zip","B_FHBZ"]
["B",null,"Doctor's office","Yes/No","B_FDOYN"]
["B",null,null,"Name","B_FDONM"]
["B",null,null,"Street","B_FDOST"]
["B",null,null,"City","B_FDOCI"]
["B",null,null,"State","B_FDOS"]
["B",null,null,"Zip","B_FDOZ"]
["B",null,"Other","Yes/No","B_FOYN"]
["B",null,null,"Specify","B_FOSep"]
["B",null,null,"Name","B_FONM"]
["B",null,null,"Street","B_FOST"]
["B",null,null,"City","B_FOCI"]
["B",null,null,"State","B_FOS"]
["B",null,null,"Zip","B_FOZ"]
["B","Type of Service",null,"Yes/No","B_TMSYN"]
["B",null,null,"Yes/No","B_TLPYN"]
["B",null,null,"Yes/No","B_TCYN"]
["B",null,null,"Yes/No","B_TOYN"]
["B",null,null,"Other,\nspecify","B_TOSpe"]
["C","Facility ID Info",null,"State ID","A_StateID"]
["C",null,null,"Facility\nName","A_Name"]
["C",null,null,"County","A_County"]
["C","Certifications","TennCare","Yes/No","C_TCYN"]
["C",null,null,"Provider\nNumber","C_TCNum"]
["C",null,"Medicare","Yes/No","C_MedYN"]
["C",null,null,"Medicare\nNumber","C_MedNum"]
["C","Accreditation and Audits","JCAHO","Yes/No","C_JCAHOYN"]
["C",null,null,"Year\nmost\nrecently\nupdated","C_JCAHOAY"]
["C",null,null,"Year\nwill\nexpire","C_JCAHOEY"]
["C",null,"CLIA","Yes/No","C_CLIAYN"]
["C",null,null,"Year\nmost\nrecently\nupdated","C_CLIAAY"]
["C",null,null,"Year\nwill\nexpire","C_CLIAEY"]
["C",null,"Lab Proficiency Testing","Yes/No","C_LPTYN"]
["C",null,null,"Year\nmost\nrecently\nupdated","C_LPTAY"]
["C",null,null,"Year\nwill\nexpire","C_LPTEY"]
["C",null,"AABB","Yes/No","C_AABBYN"]
["C",null,null,"Year\nmost\nrecently\nupdated","C_AABBAY"]
["C",null,null,"Year\nwill\nexpire","C_AABBEY"]
["C",null,"AOA","Yes/No","C_AOAYN"]
["C",null,null,"Year\nmost\nrecently\nupdated","C_AOAAY"]
["C",null,null,"Year\nwill\nexpire","C_AOAEY"]
["C",null,"CAP","Yes/No","C_CAPYN"]
["C",null,null,"Year\nmost\nrecently\nupdated","C_CAPAY"]
["C",null,null,"Year\nwill\nexpire","C_CAPEY"]
["C",null,"ACR","Yes/No","C_ACRYN"]
["C",null,null,"Year\nmost\nrecently\nupdated","C_ACRAY"]
["C",null,null,"Year\nwill\nexpire","C_ACREY"]
["C",null,"Other 1","Yes/No","C_OTH1YN"]
["C",null,null,"Specify","C_OTH1S"]
["C",null,null,"Year\nmost\nrecently\nupdated","C_OTH1AY"]
["C",null,null,"Year\nwill\nexpire","C_OTH1EY"]
["C",null,"Other 2","Yes/No","C_OTH2YN"]
["C",null,null,"Specify","C_OTH2S"]
["C",null,null,"Year\nmost\nrecently\nupdated","C_OTH2AY"]
["C",null,null,"Year\nwill\nexpire","C_OTH2EY"]
["C",null,"Other 3","Yes/No","C_OTH3YN"]
["C",null,null,"Specify","C_OTH3S"]
["C",null,null,"Year\nmost\nrecently\nupdated","C_OTH3AY"]
["C",null,null,"Year\nwill\nexpire","C_OTH3EY"]
["D","Facility ID Info",null,"State ID","A_StateID"]
["D",null,null,"Facility\nName","A_Name"]
["D",null,null,"County","A_County"]
["D","Cardiopulmonary","Electroencephalogram (EEG)","Yes/No","D_CEEGYN"]
["D",null,null,"Patients","D_CEEGPAT"]
["D",null,null,"Procedures","D_CEEGPRO"]
["D",null,"Electrocardiogram (EKG)","Yes/No","D_CEKGYN"]
["D",null,null,"Patients","D_CEKGPAT"]
["D",null,null,"Procedures","D_EKGPRO"]
["D",null,"Holter Monitoring","Yes/No","D_CHMYN"]
["D",null,null,"Patients","D_CHMPAT"]
["D",null,null,"Procedures","D_CHMPRO"]
["D",null,"Exercise Tolerance Testing","Yes/No","D_CETTYN"]
["D",null,null,"Patients","D_CETTPAT"]
["D",null,null,"Procedures","D_CETTPRO"]
["D",null,"Cardiac Catheterization","Yes/No","D_CCCYN"]
["D",null,null,"Patients","D_CCCPAT"]
["D",null,null,"Procedures","D_CCCPRO"]
["D",null,"Percutaneous Transiuminal Coronary \nAngioplasty","Yes/No","D_CPTYN"]
["D",null,null,"Patients","D_CPTPAT"]
["D",null,null,"Procedures","D_CPTPRO"]
["D","Radiology","Radiography (Diagnostic and Special\nProcedures e.g. Angiography)","Yes/No","D_RRADYN"]
["D",null,null,"Patients","D_RRADPAT"]
["D",null,null,"Procedures","D_RRADPRO"]
["D",null,"Ultrasound (General/Vascular/Cardiac)","Yes/No","D_RULTYN"]
["D",null,null,"Patients","D_RULTPAT"]
["D",null,null,"Procedures","D_RULTPRO"]
["D",null,"Nuclear medicine","Yes/No","D_RNMYN"]
["D",null,null,"Patients","D_RNMPAT"]
["D",null,null,"Procedures","D_RNMPRO"]
["D",null,"Positron Emission Tomography (PET scan)","Yes/No","D_RPETYN"]
["D",null,null,"Fixed\nUnits","D_RPETF"]
["D",null,null,"Mobile\nUnits","D_RPETM"]
["D",null,null,"Number\nof days\nmobile unit\nperweek","D_RPETN"]
["D",null,null,"Patients","D_RPETPAT"]
["D",null,null,"Procedures","D_RPETPRO"]
["D",null,"Computed Tomography (CT scan)","Yes/No","D_RCTYN"]
["D",null,null,"Fixed\nUnits","D_RCTF"]
["D",null,null,"Mobile\nUnits","D_RCTM"]
["D",null,null,"Number\nof days\nmobile unit\nperweek","D_RCTN"]
["D",null,null,"Patients","D_RCTPAT"]
["D",null,null,"Procedures","D_RCTPRO"]
["D",null,"Ultrafast CT","Yes/No","D_RUTCYN"]
["D",null,null,"Fixed\nUnits","D_RUCTF"]
["D",null,null,"Mobile\nUnits","D_RUCTM"]
["D",null,null,"Number\nof days\nmobile unit\nperweek","D_RUCTN"]
["D",null,null,"Patients","D_RUCTPAT"]
["D",null,null,"Procedures","D_RUCTPRO"]
["D",null,"Magnetic Resonance imaging (MRI)","Yes/No","D_RMCIYN"]
["D",null,null,"Fixed\nUnits","D_RMRIF"]
["D",null,null,"Mobile\nUnits","D_RMRIM"]
["D",null,null,"Number\nof days\nmobile unit\nperweek","D_RMRIN"]
["D",null,null,"Patients","D_RMRIPAT"]
["D",null,null,"Procedures","D_RMRIPRO"]
["D",null,"Hi Field MRI and Open MRI","Yes/No","D_RHMRIYN"]
["D",null,null,"Fixed\nUnits","D_RHMRIF"]
["D",null,null,"Mobile\nUnits","D_RHMRIM"]
["D",null,null,"Number\nof days\nmobile unit\nperweek","D_RHMRIN"]
["D",null,null,"Patients","D_RHMRIPAT"]
["D",null,null,"Procedures","D_RHMRIPRO"]
["D",null,"Megavoltage Rediation Therapy","Yes/No","D_RMRTYN"]
["D",null,null,"Fixed\nUnits","D_RMRTF"]
["D",null,null,"Mobile\nUnits","D_RMRTM"]
["D",null,null,"Number\nof days\nmobile unit\nperweek","D_RMRTN"]
["D",null,null,"Patients","D_RMRTPAT"]
["D",null,null,"Procedures","D_RMRTPRO"]
["D",null,"Stereotactic Procedure \n(including breast Biopsy)","Yes/No","D_RSPYN"]
["D",null,null,"Patients","D_RSPPAT"]
["D",null,null,"Procedures","D_RSPPRO"]
["D",null,"Mammography","Yes/No","D_RMAMYN"]
["D",null,null,"Patients","D_RMAMPAT"]
["D",null,null,"Procedures","D_RMAMPRO"]
["D","Other","Vascular Embolization","Yes/No","D_OVEYN"]
["D",null,null,"Patients","D_OVEPAT"]
["D",null,null,"Procedures","D_OVEPRO"]
["D",null,"Anesthesia","Yes/No","D_OAYN"]
["D",null,null,"Patients","D_OAPAT"]
["D",null,null,"Procedures","D_OAPRO"]
["D",null,"Ultrasound (ACR Accredited)","Yes/No","D_OACRYN"]
["D",null,null,"Patients","D_OACRPAT"]
["D",null,null,"Procedures","D_OACRPRO"]
["D",null,"Chemotherapy","Yes/No","D_OCYN"]
["D",null,null,"Patients","D_OCPAT"]
["D",null,null,"Procedures","D_OCPRO"]
["D",null,"Lithotripsy","Yes/No","D_OLYN"]
["D",null,null,"Fixed\nUnits","D_OLF"]
["D",null,null,"Mobile\nUnits","D_OLM"]
["D",null,null,"Number\nof days\nmobile unit\nperweek","D_OLN"]
["D",null,null,"Patients","D_OLPAT"]
["D",null,null,"Procedures","D_OLPRO"]
["D",null,"Bone Densitometry","Yes/No","D_OBDYN"]
["D",null,null,"Fixed\nUnits","D_OBDF"]
["D",null,null,"Mobile\nUnits","D_OBDM"]
["D",null,null,"Number\nof days\nmobile unit\nperweek","B_OBDN"]
["D",null,null,"Patients","D_OBDPAT"]
["D",null,null,"Procedures","D_OBDPRO"]
["D",null,"Other","Yes/No","D_OSPYN"]
["D",null,null,"Specify","D_OSP"]
["D",null,null,"Patients","D_OSPPAT"]
["D",null,null,"Procedures","D_OSPPRO"]
["D","Totals","Total","Patients","D_TOTPAT"]
["D",null,null,"Procedures","D_TOTPRO"]
["D",null,null,"Unduplicated\nPatients","D_UDP"]
["D","Rooms","Rooms","Diagnostic\nprocedure\nrooms","D_ROOM"]
["E","Facility ID Info",null,"State ID","A_StateID"]
["E",null,null,"Facility\nName","A_Name"]
["E",null,null,"County","A_County"]
["E","Number of Patients, Served by Age, Gender and Race","Age 17 and Under","Male","E_17M"]
["E",null,null,"Female","E_17F"]
["E",null,null,"Total\nPatients\nServed","E_17PS"]
["E",null,null,"White","E_17W"]
["E",null,null,"Black","E_17B"]
["E",null,null,"Other","E_17O"]
["E",null,"Age 18-64","Male","E_64M"]
["E",null,null,"Female","E_64F"]
["E",null,null,"Total\nPatients\nServed","E_64PS"]
["E",null,null,"White","E_64W"]
["E",null,null,"Black","E_64B"]
["E",null,null,"Other","E_64O"]
["E",null,"Age 65-84","Male","E_84M"]
["E",null,null,"Female","E_84F"]
["E",null,null,"Total\nPatients\nServed","E_84PS"]
["E",null,null,"White","E_84W"]
["E",null,null,"Black","E_84B"]
["E",null,null,"Other","E_84O"]
["E",null,"Age 85 and Older","Male","E_85M"]
["E",null,null,"Female","E_85F"]
["E",null,null,"Total\nPatients\nServed","E_85PS"]
["E",null,null,"White","E_85W"]
["E",null,null,"Black","E_85B"]
["E",null,null,"Other","E_85O"]
["E",null,"Age Total Patients","Male","E_TM"]
["E",null,null,"Female","E_TF"]
["E",null,null,"Total\nPatients\nServed","E_TPS"]
["E",null,null,"White","E_TW"]
["E",null,null,"Black","E_TB"]
["E",null,null,"Other","E_TO"]
["E","Patients Served by Patient Origin","Tennessee Patients","Anderson","E_01"]
["E",null,null,"Bedford","E_02"]
["E",null,null,"Benton","E_03"]
["E",null,null,"Bledsoe","E_04"]
["E",null,null,"Blount","E_05"]
["E",null,null,"Bradley","E_06"]
["E",null,null,"Campbell","E_07"]
["E",null,null,"Cannon","E_08"]
["E",null,null,"Carroll","E_09"]
["E",null,null,"Carter","E_10"]
["E",null,null,"Cheatham","E_11"]
["E",null,null,"Chester","E_12"]
["E",null,null,"Claiborne","E_13"]
["E",null,null,"Clay","E_14"]
["E",null,null,"Cocke","E_15"]
["E",null,null,"Coffee","E_16"]
["E",null,null,"Crockett","E_17"]
["E",null,null,"Cumberland","E_18"]
["E",null,null,"Davidson","E_19"]
["E",null,null,"Decatur","E_20"]
["E",null,null,"DeKalb","E_21"]
["E",null,null,"Dickson","E_22"]
["E",null,null,"Dyer","E_23"]
["E",null,null,"Fayette","E_24"]
["E",null,null,"Fentress","E_25"]
["E",null,null,"Franklin","E_26"]
["E",null,null,"Gibson","E_27"]
["E",null,null,"Giles","E_28"]
["E",null,null,"Grainger","E_29"]
["E",null,null,"Greene","E_30"]
["E",null,null,"Grundy","E_31"]
["E",null,null,"Hamblen","E_32"]
["E",null,null,"Hamilton","E_33"]
["E",null,null,"Hancock","E_34"]
["E",null,null,"Hardeman","E_35"]
["E",null,null,"Hardin","E_36"]
["E",null,null,"Hawkins","E_37"]
["E",null,null,"Haywood","E_38"]
["E",null,null,"Henderson","E_39"]
["E",null,null,"Henry","E_40"]
["E",null,null,"Hickman","E_41"]
["E",null,null,"Houston","E_42"]
["E",null,null,"Humphreys","E_43"]
["E",null,null,"Jackson","E_44"]
["E",null,null,"Jefferson","E_45"]
["E",null,null,"Johnson","E_46"]
["E",null,null,"Knox","E_47"]
["E",null,null,"Lake","E_48"]
["E",null,null,"Lauderdale","E_49"]
["E",null,null,"Lawrence","E_50"]
["E",null,null,"Lewis","E_51"]
["E",null,null,"Lincoln","E_52"]
["E",null,null,"Loudon","E_53"]
["E",null,null,"McMinn","E_54"]
["E",null,null,"McNairy","E_55"]
["E",null,null,"Macon","E_56"]
["E",null,null,"Madison","E_57"]
["E",null,null,"Marion","E_58"]
["E",null,null,"Marshall","E_59"]
["E",null,null,"Maury","E_60"]
["E",null,null,"Meigs","E_61"]
["E",null,null,"Monroe","E_62"]
["E",null,null,"Montgomery","E_63"]
["E",null,null,"Moore","E_64"]
["E",null,null,"Morgan","E_65"]
["E",null,null,"Obion","E_66"]
["E",null,null,"Overton","E_67"]
["E",null,null,"Perry","E_68"]
["E",null,null,"Pickett","E_69"]
["E",null,null,"Polk","E_70"]
["E",null,null,"Putnam","E_71"]
["E",null,null,"Rhea","E_72"]
["E",null,null,"Roane","E_73"]
["E",null,null,"Robertson","E_74"]
["E",null,null,"Rutherford","E_75"]
["E",null,null,"Scott","E_76"]
["E",null,null,"Sequatchie","E_77"]
["E",null,null,"Sevier","E_78"]
["E",null,null,"Shelby","E_79"]
["E",null,null,"Smith","E_80"]
["E",null,null,"Stewart","E_81"]
["E",null,null,"Sullivan","E_82"]
["E",null,null,"Sumner","E_83"]
["E",null,null,"Tipton","E_84"]
["E",null,null,"Trousdale","E_85"]
["E",null,null,"Unicoi","E_86"]
["E",null,null,"Union","E_87"]
["E",null,null,"VanBuren","E_88"]
["E",null,null,"Warren","E_89"]
["E",null,null,"Washington","E_90"]
["E",null,null,"Wayne","E_91"]
["E",null,null,"Weakley","E_92"]
["E",null,null,"White","E_93"]
["E",null,null,"Williamson","E_94"]
["E",null,null,"Wilson","E_95"]
["E",null,null,"Unknown","E_96"]
["E",null,null,"TN\nTotal","E_TNTOT"]
["E",null,"Out-of-state Patients","Alabama","E_AL"]
["E",null,null,"Arkansas","E_AR"]
["E",null,null,"Georgia","E_GA"]
["E",null,null,"Kentucky","E_KY"]
["E",null,null,"Mississippi","E_MS"]
["E",null,null,"Missouri","E_MO"]
["E",null,null,"North\nCarolina","E_NC"]
["E",null,null,"Virginia","E_VA"]
["E",null,null,"Other\nState or\nCountry","E_OTHS"]
["E",null,null,"Total\nNon-TN\nPatients","E_NONTN"]
["E",null,null,"All\nPatients\nTotal","E_ALLTOT"]
["F","Facility ID Info",null,"State ID","A_StateID"]
["F",null,null,"Facility\nName","A_Name"]
["F",null,null,"County","A_County"]
["F","Expenses",null,"Payroll","F_EPAY"]
["F",null,null,"Fringe \nBenefits","F_EFB"]
["F",null,null,"Other\nOperating\nExpenses","F_EOOE"]
["F",null,null,"Depreciation \nExpense","F_EDE"]
["F",null,null,"Non-\nOperating\nExpense","F_ENOE"]
["F",null,null,"Total","F_ETOT"]
["F","Patient Revenue Government","Medicare","Gross\nPatient\nCharges","F_RGMGPC"]
["F",null,null,"Adjustment\nto\nCharges","F_RGMAC"]
["F",null,null,"Net\nPatient\nRevenue","F_RGMNPR"]
["F",null,"TennCare","Gross\nPatient\nCharges","f_rgtcgpc"]
["F",null,null,"Adjustment\nto\nCharges","F_RGTCAC"]
["F",null,null,"Net\nPatient\nRevenue","F_RGTCNPR"]
["F",null,"Other Government","Gross\nPatient\nCharges","F_RGOGGPC"]
["F",null,null,"Adjustment\nto\nCharges","F_RGOGAC"]
["F",null,null,"Net\nPatient\nRevenue","F_RGOGNPR"]
["F",null,"Total Government","Gross\nPatient\nCharges","F_RGTGGPC"]
["F",null,null,"Adjustment\nto\nCharges","F_RGTGAC"]
["F",null,null,"Net\nPatient\nRevenue","F_RGTGNPR"]
["F",null,"Self-Pay","Gross\nPatient\nCharges","F_RNGSPGPC"]
["F",null,null,"Adjustment\nto\nCharges","F_RNGSPAC"]
["F",null,null,"Net\nPatient\nRevenue","F_RNGSPNPR"]
["F",null,"Insurance","Gross\nPatient\nCharges","F_RNGIGPC"]
["F",null,null,"Adjustment\nto\nCharges","F_RNGIAC"]
["F",null,null,"Net\nPatient\nRevenue","F_RNGINPR"]
["F",null,"Other Non-Government","Gross\nPatient\nCharges","F_RNGNGGPC"]
["F",null,null,"Adjustment\nto\nCharges","F_RNGNGAC"]
["F",null,null,"Net\nPatient\nRevenue","F_RNGNGNPR"]
["F",null,"Total Non-Government","Gross\nPatient\nCharges","F_RNGTGPC"]
["F",null,null,"Adjustment\nto\nCharges","F_RNGTAC"]
["F",null,null,"Net\nPatient\nRevenue","F_RNGTNPR"]
["F",null,"Total Patient Revenue","Gross\nPatient\nCharges","F_RTOTGPC"]
["F",null,null,"Adjustment\nto\nCharges","F_RTOTAC"]
["F",null,null,"Net\nPatient\nRevenue","F_RTOTNPR"]
["F",null,null,"All Non-\nPatient\nRevenue","F_ANPR"]
["F",null,null,"Total\nNet\nRevenue","F_TOTNPR"]
["F","Non-Government Adjustment to Charges Subcatregories",null,"Bad Debt","F_NGBD"]
["F",null,null,"Charity\nCare","F_NGCC"]
["F",null,null,"Other","F_NGOTR"]
["F",null,null,"Total\nAdjustment\nto\nCharges","F_NGTOT"]
["G","Facility ID Info",null,"State ID"," A_StateID"]
["G",null,null,"Facility\nName"," A_Name"]
["G",null,null,"County"," A_County"]
["G","Type of Personnel by Service","Administrators","Employee\nFull-Time"," GADMEFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GADMEPT"]
["G",null,null,"Contract\nFull-Time"," GADMCFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GADMCPT"]
["G",null,"Midical Director","Employee\nFull-Time"," GMDEFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GMDEPT"]
["G",null,null,"Contract\nFull-Time"," GMDCFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GMDCPT"]
["G",null,"Physicians (M.D. And D.O.)","Employee\nFull-Time"," GPHEFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GPHEPT"]
["G",null,null,"Contract\nFull-Time"," GPHCFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GPHCPT"]
["G",null,"Dentists","Employee\nFull-Time"," GDEFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GDEPT"]
["G",null,null,"Contract\nFull-Time"," GDCFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GDCPT"]
["G",null,"Financial/Billing Personnel","Employee\nFull-Time"," GFBEFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GFBEPT"]
["G",null,null,"Contract\nFull-Time"," GFBCFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GFBCPT"]
["G",null,"Nursing (R.N., L.P.N., and Ancillary)","Employee\nFull-Time"," GNUREFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GNUREPT"]
["G",null,null,"Contract\nFull-Time"," GNURCFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GNURCPT"]
["G",null,"Medical Records","Employee\nFull-Time"," GMREFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GMREPT"]
["G",null,null,"Contract\nFull-Time"," GMRCFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GMRCPT"]
["G",null,"Registered Technologist","Employee\nFull-Time"," GRTEFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GRTEPT"]
["G",null,null,"Contract\nFull-Time"," GRTCFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GRTCPT"]
["G",null,"Technical","Employee\nFull-Time"," GTEFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GTEPT"]
["G",null,null,"Contract\nFull-Time"," GTCFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GTCPT"]
["G",null,"Maintenace/Services","Employee\nFull-Time"," GMAEFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GMAEPT"]
["G",null,null,"Contract\nFull-Time"," GMACFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GMACPT"]
["G",null,"Other 1","Specify"," GO1S"]
["G",null,null,"Employee\nFull-Time"," GO1EFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GO1EPT"]
["G",null,null,"Contract\nFull-Time"," GO1CFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GO1CPT"]
["G",null,"Other 2","Specify"," GO2S"]
["G",null,null,"Employee\nFull-Time"," GO2EFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GO2EPT"]
["G",null,null,"Contract\nFull-Time"," GO2CFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GO2CPT"]
["G",null,"Other 3","Specify"," GO3S"]
["G",null,null,"Employee\nFull-Time"," GO3EFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GO3EPT"]
["G",null,null,"Contract\nFull-Time"," GO3CFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GO3CPT"]
["G",null,"Total (System Calculation)","Employee\nFull-Time"," GTOTEFT"]
["G",null,null,"Employee\nPart-Time\nIn FTE"," GTOTEPT"]
["G",null,null,"Contract\nFull-Time"," GTOTCFT"]
["G",null,null,"Contract\nPart-Time\nIn FTE"," GTOTCPT"]
["G","Nursing Personnel","Registered Nurses - Associate","Number\nCurrently\nEmployed"," GRAN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GRAV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GRAAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GRAPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nClinical"," GRAEC"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nAdmin"," GRAEA"]
["G",null,"Registered Nurses - Diploma","Number\nCurrently\nEmployed"," GRDIN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GRDIV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GRAAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GRDIPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nClinical"," GRDIEC"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nAdmin"," GRDIEA"]
["G",null,"Registered Nurses - Bachelors","Number\nCurrently\nEmployed"," GRBN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GRBV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GRBAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GRBPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nClinical"," GRBEC"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nAdmin"," GRBEA"]
["G",null,"Registered Nurses - Masters","Number\nCurrently\nEmployed"," GRMN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GRMV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GRMAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GRMPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nClinical"," GRMEC"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nAdmin"," GRMEA"]
["G",null,"Registered Nurses - Doctorate","Number\nCurrently\nEmployed"," GRDON"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GRDOV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GRDOAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GRDOPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nClinical"," GRDOEC"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nAdmin"," GRCOEA"]
["G",null,"Registered Nurses - Total","Number\nCurrently\nEmployed"," GRTN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GRTV"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GRTPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nClinical"," GRTEC"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nAdmin"," GRTEA"]
["G",null,"Advanced Practice nurses - Nurse Practitioner","Number\nCurrently\nEmployed"," GANPN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GANPV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GANPAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GANPPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nClinical"," GANPEC"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nAdmin"," GANPEA"]
["G",null,"Advanced Practice nurses - Clinical Nurse Specialist","Number\nCurrently\nEmployed"," GACSN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GACSV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GACSAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GACSPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nClinical"," GACSEC"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nAdmin"," GACSEA"]
["G",null,"Advanced Practice nurses - Certified Registered Nurse Anesthetist","Number\nCurrently\nEmployed"," GANAN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GANAV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GANAAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GANAPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nClinical"," GANAEC"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nAdmin"," GANAEA"]
["G",null,"Advanced Practice nurses - Total","Number\nCurrently\nEmployed"," GATN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GATV"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GATPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nClinical"," GATEC"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths\nAdmin"," GATEA"]
["G",null,"Other Nursing Staff - Licensed Practical Nurses","Number\nCurrently\nEmployed"," GOLPN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GOLPV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GALPAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GOLPPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths"," GOLPE"]
["G",null,"Other Nursing Staff - Certified Nurses Aides","Number\nCurrently\nEmployed"," GOAN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GOAV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GOAAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GOAPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths"," GOAE"]
["G",null,"Other Nursing Staff - Other 1","Other 1\nSpecify"," GOO1S"]
["G",null,null,"Number\nCurrently\nEmployed"," GOO1N"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GOO1V"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GOO1AW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GOO1PA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths"," GOO1E"]
["G",null,"Other Nursing Staff - Other 2","Other 2\nSpecify"," GOO2S"]
["G",null,null,"Number\nCurrently\nEmployed"," GOO2N"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GOO2V"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GOO2AW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GOO2PA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths"," GOO2E"]
["G"," Contract Nursing Personnel",null,"Use Contract Nursing Yes/No"," GCYN"]
["G",null,"Registered Nurses","Number\nCurrently\nEmployed"," GCRNN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GCRNV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GCRNAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GCRNPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths"," GCRNE"]
["G",null,"Licensed practical Nurses","Number\nCurrently\nEmployed"," GCLPN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GCLPV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GCLPAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GCLPPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths"," GCLPE"]
["G",null,"Certified Nurse Aides","Number\nCurrently\nEmployed"," GCAN"]
["G",null,null,"Number of\nBudgeted \nVacancies"," GCAV"]
["G",null,null,"Average \n#Weeks\nRequired to\nRecruit Staff"," GCAAW"]
["G",null,null,"Number\nAdded in\nthe Past 12\nMonths"," GCAPA"]
["G",null,null,"Number\nEliminated in\nLast 12\nMonths"," GCAE"]
["H","Facility ID Info",null,"State ID","A_StateID"]
["H",null,null,"Facility\nName","A_Name"]
["H",null,null,"County","A_County"]
["H","Medical Staff","Cardiologist","Total\nMedical\nStaff","HCMS"]
["H",null,null,"Medical\nStaff\nBoard\nCertified","HCBC"]
["H",null,"Neurologists","Total\nMedical\nStaff","HNMS"]
["H",null,null,"Medical\nStaff\nBoard\nCertified","HNBC"]
["H",null,"Pathologist","Total\nMedical\nStaff","HPMS"]
["H",null,null,"Medical\nStaff\nBoard\nCertified","HPBC"]
["H",null,"Radiologist","Total\nMedical\nStaff","HRMS"]
["H",null,null,"Medical\nStaff\nBoard\nCertified","HRBC"]
["H",null,"Technician","Total\nMedical\nStaff","HTMS"]
["H",null,null,"Medical\nStaff\nBoard\nCertified","HTBC"]
["H",null,"Other 1","Specify","HO1S"]
["H",null,null,"Total\nMedical\nStaff","HO1MS"]
["H",null,null,"Medical\nStaff\nBoard\nCertified","HO1BC"]
["H",null,"Other 2","Specify","HO2S"]
["H",null,null,"Total\nMedical\nStaff","HO2MS"]
["H",null,null,"Medical\nStaff\nBoard\nCertified","HO2BC"]
["Adm","Facility ID Info",null,"State ID"," A_StateID"]
["Adm",null,null,"Facility\nName"," A_Name"]
["Adm",null,null,"County"," A_County"]
["Adm","Administrator's Declaration",null,"Yes/No"," AD_AdmDec"]
["Adm",null,null,"Date"," AD_AdmDecDate"]

{"sheet":"Sch E","index":12,"n_rows":56,"n_cols":42,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,38,23,39],[24,38,24,39],[39,37,51,38],[52,37,52,38],[1,17,1,31],[1,32,1,35],[47,0,52,5],[48,22,48,25],[49,22,49,25],[50,22,50,25],[48,26,48,31],[49,26,49,31],[50,26,50,31],[50,12,50,15],[48,16,48,21],[49,16,49,21],[51,6,51,31],[52,6,52,31],[48,32,48,35],[49,32,49,35],[50,32,50,35],[51,32,51,35],[52,32,52,35],[48,6,48,11],[49,6,49,11],[50,6,50,11],[48,12,48,15],[49,12,49,15],[47,6,47,11],[47,12,47,15],[47,16,47,21],[50,16,50,21],[47,22,47,25],[47,26,47,31],[47,32,47,35],[42,22,42,25],[43,22,43,25],[44,22,44,25],[45,22,45,25],[46,6,46,31],[46,32,46,35],[43,16,43,21],[44,16,44,21],[45,16,45,21],[45,6,45,11],[44,6,44,11],[42,26,42,31],[43,26,43,31],[44,26,44,31],[45,26,45,31],[40,32,40,35],[41,32,41,35],[42,32,42,35],[43,32,43,35],[44,32,44,35],[45,32,45,35],[32,26,32,31],[33,26,33,31],[32,32,32,35],[33,32,33,35],[34,32,34,35],[35,32,35,35],[34,26,34,31],[35,26,35,31],[36,26,36,31],[37,26,37,31],[38,26,38,31],[39,26,39,31],[36,32,36,35],[37,32,37,35],[38,32,38,35],[39,32,39,35],[40,22,40,25],[41,22,41,25],[40,26,40,31],[41,26,41,31],[34,22,34,25],[35,22,35,25],[36,22,36,25],[37,22,37,25],[38,22,38,25],[39,22,39,25],[40,16,40,21],[41,16,41,21],[42,16,42,21],[34,16,34,21],[35,16,35,21],[36,16,36,21],[37,16,37,21],[38,16,38,21],[39,16,39,21],[40,12,40,15],[41,12,41,15],[42,12,42,15],[43,12,43,15],[44,12,44,15],[45,12,45,15],[34,12,34,15],[35,12,35,15],[36,12,36,15],[37,12,37,15],[38,12,38,15],[39,12,39,15],[33,12,33,15],[32,16,32,21],[33,16,33,21],[32,22,32,25],[33,22,33,25],[31,16,31,21],[30,16,30,21],[28,22,28,25],[29,22,29,25],[28,12,28,15],[29,12,29,15],[28,16,28,21],[29,16,29,21],[20,26,20,31],[21,26,21,31],[22,26,22,31],[23,26,23,31],[24,26,24,31],[25,26,25,31],[24,16,24,21],[26,16,26,21],[26,22,26,25],[24,22,24,25],[25,22,25,25],[26,26,26,31],[25,16,25,21],[24,32,24,35],[27,12,27,15],[26,32,26,35],[21,16,21,21],[22,16,22,21],[23,16,23,21],[30,32,30,35],[31,32,31,35],[27,26,27,31],[28,26,28,31],[29,26,29,31],[30,26,30,31],[31,26,31,31],[27,32,27,35],[28,32,28,35],[29,32,29,35],[30,22,30,25],[31,22,31,25],[30,12,30,15],[27,22,27,25],[27,16,27,21],[18,22,18,25],[19,22,19,25],[20,22,20,25],[21,22,21,25],[25,32,25,35],[20,32,20,35],[21,12,21,15],[22,12,22,15],[23,12,23,15],[22,22,22,25],[23,22,23,25],[18,16,18,21],[18,12,18,15],[19,12,19,15],[20,12,20,15],[19,16,19,21],[20,16,20,21],[18,26,18,31],[19,26,19,31],[18,32,18,35],[19,32,19,35],[21,32,21,35],[22,32,22,35],[23,32,23,35],[14,26,14,31],[15,26,15,31],[16,26,16,31],[17,26,17,31],[14,32,14,35],[15,32,15,35],[16,32,16,35],[17,32,17,35],[15,16,15,21],[16,16,16,21],[17,16,17,21],[14,22,14,25],[15,22,15,25],[16,22,16,25],[17,22,17,25],[14,12,14,15],[15,12,15,15],[16,12,16,15],[17,12,17,15],[24,12,24,15],[25,12,25,15],[26,12,26,15],[32,12,32,15],[31,12,31,15],[41,6,41,11],[42,6,42,11],[43,6,43,11],[33,6,33,11],[34,6,34,11],[35,6,35,11],[36,6,36,11],[37,6,37,11],[38,6,38,11],[26,6,26,11],[15,6,15,11],[16,6,16,11],[17,6,17,11],[18,6,18,11],[19,6,19,11],[20,6,20,11],[39,6,39,11],[40,6,40,11],[27,6,27,11],[28,6,28,11],[29,6,29,11],[30,6,30,11],[31,6,31,11],[32,6,32,11],[0,37,0,39],[7,15,7,18],[8,15,8,18],[9,15,9,18],[10,15,10,18],[7,19,7,23],[8,19,8,23],[2,0,2,35],[0,0,0,35],[1,0,1,3],[7,24,7,27],[8,24,8,27],[9,24,9,27],[10,24,10,27],[1,4,1,9],[1,10,1,16],[6,19,6,23],[10,6,10,10],[9,11,9,14],[10,11,10,14],[7,6,7,10],[8,6,8,10],[7,11,7,14],[4,0,11,5],[55,0,55,35],[54,0,54,35],[53,0,53,35],[8,11,8,14],[10,19,10,23],[11,6,11,35],[5,24,5,27],[4,24,4,35],[5,28,5,31],[10,32,10,35],[7,28,7,31],[8,28,8,31],[9,28,9,31],[10,28,10,31],[6,28,6,31],[6,24,6,27],[12,6,12,35],[5,32,5,35],[6,11,6,14],[6,6,6,10],[5,11,5,14],[5,15,5,18],[4,6,5,10],[4,11,4,18],[1,37,5,37],[3,0,3,35],[7,32,7,35],[8,32,8,35],[9,32,9,35],[9,19,9,23],[9,6,9,10],[4,19,5,23],[12,0,46,5],[13,26,13,31],[13,32,13,35],[6,32,6,35],[14,6,14,11],[14,16,14,21],[13,6,13,11],[13,12,13,15],[13,16,13,21],[13,22,13,25],[6,15,6,18],[21,6,21,11],[22,6,22,11],[23,6,23,11],[24,6,24,11],[25,6,25,11]]}
["2020 Tennessee  - ODC -  Provisional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'Ok' = Likely no Error\n'Error' = Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,null,"Facility Name:",null,null,null,null,null,null,{"$f":"A_Name","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,null,null,null,null,"Patients by\ngender\nequal to\nPatients by\nrace"]
["Outpatient Diagnostic Centers  Joint Annual Report - Schedule E - Patient Characteristics"]
["Do not enter zero.  Blank fields will represent zero patients."]
["Number of \nPatients Served\nBy Age, Gender,\nand Race",null,null,null,null,null,"Age",null,null,null,null,"Gender",null,null,null,null,null,null,null,"Total Patients Served",null,null,null,null,"Race"]
[null,null,null,null,null,null,null,null,null,null,null,"Male",null,null,null,"Female",null,null,null,null,null,null,null,null,"White",null,null,null,"Black",null,null,null,"Other"]
[null,null,null,null,null,null,"17 and Under",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7:S7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((AO7=AP7),\"Ok\", \"Error\")","v":"Ok"},null,null,{"$f":"SUM(L7:S7)","v":0},{"$f":"SUM(Y7:AJ7)","v":0}]
[null,null,null,null,null,null,"18-64",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L8:S8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((AO8=AP8),\"OK\", \"Error\")","v":"OK"},null,null,{"$f":"SUM(L8:S8)","v":0},{"$f":"SUM(Y8:AJ8)","v":0}]
[null,null,null,null,null,null,"65-84",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L9:S9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((AO9=AP9),\"Ok\", \"Error\")","v":"Ok"},null,null,{"$f":"SUM(L9:S9)","v":0},{"$f":"SUM(Y9:AJ9)","v":0}]
[null,null,null,null,null,null,"85 and Older",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10:S10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((AO10=AP10),\"Ok\", \"Error\")","v":"Ok"},null,null,{"$f":"SUM(L10:S10)","v":0},{"$f":"SUM(Y10:AJ10)","v":0}]
[null,null,null,null,null,null,"Total Patients",null,null,null,null,{"$f":"SUM(L7:O10)","v":0},null,null,null,{"$f":"SUM(P7:S10)","v":0},null,null,null,{"$f":"SUM(T7:X10)","v":0},null,null,null,null,{"$f":"SUM(Y7:AB10)","v":0},null,null,null,{"$f":"SUM(AC7:AF10)","v":0},null,null,null,{"$f":"SUM(AG7:AJ10)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L11:S11)","v":0},{"$f":"SUM(Y11:AJ11)","v":0}]
[null,null,null,null,null,null,"Total Patients Served should match Total Unduplicated Patients in Schedule D.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cross Check\n\nNumber of\npatients\nserved in\nschedule E\n\nWith\n\nTotal\nUn-\nduplicated\npatients in\nschedule D"]
["Number of\nPatients Served\nby Patient\nOrigin\n\nTennessee\nPatients",null,null,null,null,null,"Please record the number of Tennessee and Non-Tennessee patients \nwho received services during the reporting period."]
[null,null,null,null,null,null,"County",null,null,null,null,null,"Number of Patients",null,null,null,"County",null,null,null,null,null,"Number of Patients",null,null,null,"County",null,null,null,null,null,"Number of Patients"]
[null,null,null,null,null,null," 1 Anderson",null,null,null,null,null,null,null,null,null,"33 Hamilton",null,null,null,null,null,null,null,null,null,"65 Morgan"]
[null,null,null,null,null,null," 2 Bedford",null,null,null,null,null,null,null,null,null,"34 Hancock",null,null,null,null,null,null,null,null,null,"66 Obion"]
[null,null,null,null,null,null," 3 Benton",null,null,null,null,null,null,null,null,null,"35 Hardeman",null,null,null,null,null,null,null,null,null,"67 Overton"]
[null,null,null,null,null,null," 4 Bledsoe",null,null,null,null,null,null,null,null,null,"36 Hardin",null,null,null,null,null,null,null,null,null,"68 Perry"]
[null,null,null,null,null,null," 5 Blount",null,null,null,null,null,null,null,null,null,"37 Hawkins",null,null,null,null,null,null,null,null,null,"69 Pickett"]
[null,null,null,null,null,null," 6 Bradley",null,null,null,null,null,null,null,null,null,"38 Haywood",null,null,null,null,null,null,null,null,null,"70 Polk"]
[null,null,null,null,null,null," 7 Campbell",null,null,null,null,null,null,null,null,null,"39 Henderson",null,null,null,null,null,null,null,null,null,"71 Putnam"]
[null,null,null,null,null,null," 8 Cannon",null,null,null,null,null,null,null,null,null,"40 Henry",null,null,null,null,null,null,null,null,null,"72 Rhea"]
[null,null,null,null,null,null," 9 Carroll",null,null,null,null,null,null,null,null,null,"41 Hickman",null,null,null,null,null,null,null,null,null,"73 Roane"]
[null,null,null,null,null,null,"10 Carter",null,null,null,null,null,null,null,null,null,"42 Houston",null,null,null,null,null,null,null,null,null,"74 Robertson"]
[null,null,null,null,null,null,"11 Cheatham",null,null,null,null,null,null,null,null,null,"43 Humphreys",null,null,null,null,null,null,null,null,null,"75 Rutherford",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((AO46=AO47),\"Ok\", \"Error\")","v":"Ok"}]
[null,null,null,null,null,null,"12 Chester",null,null,null,null,null,null,null,null,null,"44 Jackson",null,null,null,null,null,null,null,null,null,"76 Scott"]
[null,null,null,null,null,null,"13 Claiborne",null,null,null,null,null,null,null,null,null,"45 Jefferson",null,null,null,null,null,null,null,null,null,"77 Sequatchie"]
[null,null,null,null,null,null,"14 Clay",null,null,null,null,null,null,null,null,null,"46 Johnson",null,null,null,null,null,null,null,null,null,"78 Sevier"]
[null,null,null,null,null,null,"15 Cocke",null,null,null,null,null,null,null,null,null,"47 Knox",null,null,null,null,null,null,null,null,null,"79 Shelby"]
[null,null,null,null,null,null,"16 Coffee",null,null,null,null,null,null,null,null,null,"48 Lake",null,null,null,null,null,null,null,null,null,"80 Smith"]
[null,null,null,null,null,null,"17 Crockett",null,null,null,null,null,null,null,null,null,"49 Lauderdale",null,null,null,null,null,null,null,null,null,"81 Stewart"]
[null,null,null,null,null,null,"18 Cumberland",null,null,null,null,null,null,null,null,null,"50 Lawrence",null,null,null,null,null,null,null,null,null,"82 Sullivan"]
[null,null,null,null,null,null,"19 Davidson",null,null,null,null,null,null,null,null,null,"51 Lewis",null,null,null,null,null,null,null,null,null,"83 Sumner"]
[null,null,null,null,null,null,"20 Decatur",null,null,null,null,null,null,null,null,null,"52 Lincoln",null,null,null,null,null,null,null,null,null,"84 Tipton"]
[null,null,null,null,null,null,"21 DeKalb",null,null,null,null,null,null,null,null,null,"53 Loudon",null,null,null,null,null,null,null,null,null,"85 Trousdale"]
[null,null,null,null,null,null,"22 Dickson",null,null,null,null,null,null,null,null,null,"54 McMinn",null,null,null,null,null,null,null,null,null,"86 Unicoi"]
[null,null,null,null,null,null,"23 Dyer",null,null,null,null,null,null,null,null,null,"55 McNairy",null,null,null,null,null,null,null,null,null,"87 Union"]
[null,null,null,null,null,null,"24 Fayette",null,null,null,null,null,null,null,null,null,"56 Macon",null,null,null,null,null,null,null,null,null,"88 Van Buren"]
[null,null,null,null,null,null,"25 Fentress",null,null,null,null,null,null,null,null,null,"57 Madison",null,null,null,null,null,null,null,null,null,"89 Warren"]
[null,null,null,null,null,null,"26 Franklin",null,null,null,null,null,null,null,null,null,"58 Marion",null,null,null,null,null,null,null,null,null,"90 Washington",null,null,null,null,null,null,null,null,null,null,"Cross Check\n\nNumber of\npatients\nserved by\nAge, Gender,\n& Race\n\nWith\n\nNumber of\npatients\nserved by\nPatient  Origin             Should Equal the           Same Amount"]
[null,null,null,null,null,null,"27 Gibson",null,null,null,null,null,null,null,null,null,"59 Marshall",null,null,null,null,null,null,null,null,null,"91 Wayne"]
[null,null,null,null,null,null,"28 Giles",null,null,null,null,null,null,null,null,null,"60 Maury",null,null,null,null,null,null,null,null,null,"92 Weakley"]
[null,null,null,null,null,null,"29 Grainger",null,null,null,null,null,null,null,null,null,"61 Meigs",null,null,null,null,null,null,null,null,null,"93 White"]
[null,null,null,null,null,null,"30 Greene",null,null,null,null,null,null,null,null,null,"62 Monroe",null,null,null,null,null,null,null,null,null,"94 Williamson"]
[null,null,null,null,null,null,"31 Grundy",null,null,null,null,null,null,null,null,null,"63 Montgomery",null,null,null,null,null,null,null,null,null,"95 Wilson"]
[null,null,null,null,null,null,"32 Hamblen",null,null,null,null,null,null,null,null,null,"64 Moore",null,null,null,null,null,null,null,null,null,"96 Unknown",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D_UDP","v":0}]
[null,null,null,null,null,null,"Total Tennessee Patients",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((SUM(E_01:E_32))+(SUM(E_33:E_64))+(SUM(E_65:E_96)))","v":0},null,null,null,null,null,null,null,{"$f":"E_TPS","v":0}]
["Number of\nPatients Served\nby Patient\nOrigin\n\nOut-of-state\nPatients",null,null,null,null,null,"Out of State",null,null,null,null,null,"Number of\nPatients",null,null,null,"Out of State",null,null,null,null,null,"Number of\nPatients",null,null,null,"Out of State",null,null,null,null,null,"Number of\nPatients",null,null,null,null,null,null,null,{"$f":"E_ALLTOT","v":0}]
[null,null,null,null,null,null,"01 Alabama",null,null,null,null,null,null,null,null,null,"18 Kentucky",null,null,null,null,null,null,null,null,null,"34 North Carolina"]
[null,null,null,null,null,null,"04 Arkansas",null,null,null,null,null,null,null,null,null,"25 Mississippi",null,null,null,null,null,null,null,null,null,"47 Virginia"]
[null,null,null,null,null,null,"11 Georgia",null,null,null,null,null,null,null,null,null,"26 Missouri",null,null,null,null,null,null,null,null,null,"55 Other State or\nCountry"]
[null,null,null,null,null,null,"Total Non-Tennessee Patients",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((SUM(E_AL:E_GA))+(SUM(E_KY:E_MO))+(SUM(E_NC:E_OTHS)))","v":0}]
[null,null,null,null,null,null,"Total of Tennessee and Non-Tennessee Patients",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E_TNTOT+E_NONTN)","v":0},null,null,null,null,{"$f":"IF((AO47=AO48),\"Ok\", \"Error\")","v":"Ok"}]
["Go to Next Schedule"]
["Return to Main Menu"]
["Go to Error Listing"]

{"sheet":"E","index":13,"n_rows":4,"n_cols":141,"rows_kept":4,"cut":false,"hidden":true,"merged":[[1,21,1,26],[1,27,1,32],[0,3,0,32],[1,130,1,139],[0,0,1,2],[1,3,1,8],[1,9,1,14],[1,15,1,20]]}
["Facility ID Info",null,null,"Number of Patients, Served by Age, Gender and Race",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patients Served by Patient Origin"]
[null,null,null,"Age 17 and Under",null,null,null,null,null,"Age 18-64",null,null,null,null,null,"Age 65-84",null,null,null,null,null,"Age 85 and Older",null,null,null,null,null,"Age Total Patients",null,null,null,null,null,"Tennessee Patients",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Out-of-state Patients"]
["State ID","Facility\nName","County","Male","Female","Total\nPatients\nServed","White","Black","Other","Male","Female","Total\nPatients\nServed","White","Black","Other","Male","Female","Total\nPatients\nServed","White","Black","Other","Male","Female","Total\nPatients\nServed","White","Black","Other","Male","Female","Total\nPatients\nServed","White","Black","Other","Anderson","Bedford","Benton","Bledsoe","Blount","Bradley","Campbell","Cannon","Carroll","Carter","Cheatham","Chester","Claiborne","Clay","Cocke","Coffee","Crockett","Cumberland","Davidson","Decatur","DeKalb","Dickson","Dyer","Fayette","Fentress","Franklin","Gibson","Giles","Grainger","Greene","Grundy","Hamblen","Hamilton","Hancock","Hardeman","Hardin","Hawkins","Haywood","Henderson","Henry","Hickman","Houston","Humphreys","Jackson","Jefferson","Johnson","Knox","Lake","Lauderdale","Lawrence","Lewis","Lincoln","Loudon","McMinn","McNairy","Macon","Madison","Marion","Marshall","Maury","Meigs","Monroe","Montgomery","Moore","Morgan","Obion","Overton","Perry","Pickett","Polk","Putnam","Rhea","Roane","Robertson","Rutherford","Scott","Sequatchie","Sevier","Shelby","Smith","Stewart","Sullivan","Sumner","Tipton","Trousdale","Unicoi","Union","VanBuren","Warren","Washington","Wayne","Weakley","White","Williamson","Wilson","Unknown","TN\nTotal","Alabama","Arkansas","Georgia","Kentucky","Mississippi","Missouri","North\nCarolina","Virginia","Other\nState or\nCountry","Total\nNon-TN\nPatients","All\nPatients\nTotal"]
[{"$f":"A_StateID","v":0},{"$f":"A_Name","v":"-"},{"$f":"A_County","v":"-"},{"$f":"E_17M","v":0},{"$f":"E_17F","v":0},{"$f":"E_17PS","v":0},{"$f":"E_17W","v":0},{"$f":"E_17B","v":0},{"$f":"E_17O","v":0},{"$f":"E_64M","v":0},{"$f":"E_64F","v":0},{"$f":"E_64PS","v":0},{"$f":"E_64W","v":0},{"$f":"E_64B","v":0},{"$f":"E_64O","v":0},{"$f":"E_84M","v":0},{"$f":"E_84F","v":0},{"$f":"E_84PS","v":0},{"$f":"E_84W","v":0},{"$f":"E_84B","v":0},{"$f":"E_84O","v":0},{"$f":"E_85M","v":0},{"$f":"E_85F","v":0},{"$f":"E_85PS","v":0},{"$f":"E_85W","v":0},{"$f":"E_85B","v":0},{"$f":"E_85O","v":0},{"$f":"E_TM","v":0},{"$f":"E_TF","v":0},{"$f":"E_TPS","v":0},{"$f":"E_TW","v":0},{"$f":"E_TB","v":0},{"$f":"E_TO","v":0},{"$f":"E_01","v":0},{"$f":"E_02","v":0},{"$f":"E_03","v":0},{"$f":"E_04","v":0},{"$f":"E_05","v":0},{"$f":"E_06","v":0},{"$f":"E_07","v":0},{"$f":"E_08","v":0},{"$f":"E_09","v":0},{"$f":"E_10","v":0},{"$f":"E_11","v":0},{"$f":"E_12","v":0},{"$f":"E_13","v":0},{"$f":"E_14","v":0},{"$f":"E_15","v":0},{"$f":"E_16","v":0},{"$f":"E_17","v":0},{"$f":"E_18","v":0},{"$f":"E_19","v":0},{"$f":"E_20","v":0},{"$f":"E_21","v":0},{"$f":"E_22","v":0},{"$f":"E_23","v":0},{"$f":"E_24","v":0},{"$f":"E_25","v":0},{"$f":"E_26","v":0},{"$f":"E_27","v":0},{"$f":"E_28","v":0},{"$f":"E_29","v":0},{"$f":"E_30","v":0},{"$f":"E_31","v":0},{"$f":"E_32","v":0},{"$f":"E_33","v":0},{"$f":"E_34","v":0},{"$f":"E_35","v":0},{"$f":"E_36","v":0},{"$f":"E_37","v":0},{"$f":"E_38","v":0},{"$f":"E_39","v":0},{"$f":"E_40","v":0},{"$f":"E_41","v":0},{"$f":"E_42","v":0},{"$f":"E_43","v":0},{"$f":"E_44","v":0},{"$f":"E_45","v":0},{"$f":"E_46","v":0},{"$f":"E_47","v":0},{"$f":"E_48","v":0},{"$f":"E_49","v":0},{"$f":"E_50","v":0},{"$f":"E_51","v":0},{"$f":"E_52","v":0},{"$f":"E_53","v":0},{"$f":"E_54","v":0},{"$f":"E_55","v":0},{"$f":"E_56","v":0},{"$f":"E_57","v":0},{"$f":"E_58","v":0},{"$f":"E_59","v":0},{"$f":"E_60","v":0},{"$f":"E_61","v":0},{"$f":"E_62","v":0},{"$f":"E_63","v":0},{"$f":"E_64","v":0},{"$f":"E_65","v":0},{"$f":"E_66","v":0},{"$f":"E_67","v":0},{"$f":"E_68","v":0},{"$f":"E_69","v":0},{"$f":"E_70","v":0},{"$f":"E_71","v":0},{"$f":"E_72","v":0},{"$f":"E_73","v":0},{"$f":"E_74","v":0},{"$f":"E_75","v":0},{"$f":"E_76","v":0},{"$f":"E_77","v":0},{"$f":"E_78","v":0},{"$f":"E_79","v":0},{"$f":"E_80","v":0},{"$f":"E_81","v":0},{"$f":"E_82","v":0},{"$f":"E_83","v":0},{"$f":"E_84","v":0},{"$f":"E_85","v":0},{"$f":"E_86","v":0},{"$f":"E_87","v":0},{"$f":"E_88","v":0},{"$f":"E_89","v":0},{"$f":"E_90","v":0},{"$f":"E_91","v":0},{"$f":"E_92","v":0},{"$f":"E_93","v":0},{"$f":"E_94","v":0},{"$f":"E_95","v":0},{"$f":"E_96","v":0},{"$f":"E_TNTOT","v":0},{"$f":"E_AL","v":0},{"$f":"E_AR","v":0},{"$f":"E_GA","v":0},{"$f":"E_KY","v":0},{"$f":"E_MS","v":0},{"$f":"E_MO","v":0},{"$f":"E_NC","v":0},{"$f":"E_VA","v":0},{"$f":"E_OTHS","v":0},{"$f":"E_NONTN","v":0},{"$f":"E_ALLTOT","v":0}]

{"sheet":"Sch F","index":14,"n_rows":30,"n_cols":40,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,17,1,31],[1,32,1,35],[20,38,22,38],[1,37,3,37],[10,37,11,37],[10,38,11,38],[10,39,11,39],[10,0,22,5],[3,31,3,35],[4,0,9,5],[3,0,3,30],[4,6,4,30],[16,6,19,10],[16,17,16,21],[17,17,17,21],[16,22,16,23],[17,22,17,23],[18,22,18,23],[19,22,19,23],[18,11,18,16],[19,11,19,16],[7,31,7,35],[6,31,6,35],[10,6,10,35],[23,0,26,5],[29,0,29,35],[28,0,28,35],[27,0,27,35],[23,31,23,35],[24,31,24,35],[23,6,23,30],[24,6,24,30],[0,37,0,39],[9,6,9,30],[2,0,2,35],[0,0,0,35],[1,0,1,3],[1,4,1,9],[1,10,1,16],[5,31,5,35],[4,31,4,35],[5,6,5,30],[6,6,6,30],[7,6,7,30],[8,6,8,30],[9,31,9,35],[26,31,26,35],[25,6,25,30],[26,6,26,30],[22,6,22,30],[22,31,22,35],[20,17,20,21],[20,22,20,23],[20,24,20,28],[25,31,25,35],[20,29,20,30],[20,31,20,35],[21,6,21,30],[21,31,21,35],[20,6,20,16],[8,31,8,35],[16,29,16,30],[17,29,17,30],[16,11,16,16],[17,11,17,16],[16,24,16,28],[17,24,17,28],[18,29,18,30],[19,29,19,30],[16,31,16,35],[18,31,18,35],[19,31,19,35],[17,31,17,35],[18,24,18,28],[19,24,19,28],[18,17,18,21],[19,17,19,21],[12,29,12,30],[13,29,13,30],[14,29,14,30],[15,29,15,30],[14,24,14,28],[15,24,15,28],[15,31,15,35],[11,6,15,10],[15,11,15,16],[12,17,12,21],[13,17,13,21],[14,17,14,21],[15,17,15,21],[14,31,14,35],[13,31,13,35],[12,31,12,35],[15,22,15,23],[14,22,14,23],[13,22,13,23],[12,22,12,23],[12,24,12,28],[13,24,13,28],[11,31,11,35],[11,29,11,30],[11,17,11,21],[11,11,11,16],[11,24,11,28],[11,22,11,23],[12,11,12,16],[13,11,13,16],[14,11,14,16]]}
["2020  Tennessee - ODC - Provisional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'Ok' = Likely no Error\n'Error' = Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,null,"Facility Name:",null,null,null,null,null,null,{"$f":"A_Name","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,null,null,null,null,"Provide\nExpense\ndata"]
["Outpatient Diagnostic Centers Joint Annual Report - Schedule F - Financial Data"]
["Round all figures to the nearest dollar.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount"]
["Expenses",null,null,null,null,null,"Payroll - Include salaries for all full-time and part-time personnel who are\nincluded in Schedule G.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F_EPAY<>\"\",\"Ok\", \"Error\")","v":"Error"}]
[null,null,null,null,null,null,"Fringe Benefits - Social security, group insurance, retirement benefit, etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F_EFB<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,"Other Operating Expenses - Expenses for all contract staff, professional fees, \nenergy expense (oil, natural gas, electricity, etc.), and all other operating \nexpenses.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F_EOOE<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,"Depreciation Expense.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F_EDE<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,"Non-Operating Expense - Include all other expenses for interest, taxes, \nreal estate ease expenses, and other non-operating expenses.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F_ENOE<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AF5:AJ9)","v":0}]
["Patient\nRevenue",null,null,null,null,null,"Gross Patient Charges - The sum of the facility's established rate for all services rendered to \npatients during the reporting year.\nAdjustments to Charges - The difference between the gross patient charges and the actual \namount of payment received by the facility during the reporting period.  Adjustments to previous \nyears revenue, such as Medicare or TennCare prior adjustments, should be reported as non-\noperating revenue, not as current year adjustments.\nNet Patient Revenue - The difference obtained by subtracting adjustments to charges from gross \npatient charges.  This difference represents the actual amount of revenue that the facility received.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Provide\npatient \nrevenue\n(Gross\npatient\ncharges)\ndata","Provide\npatient\nrevenue\n(Adjustment\nto\ncharges)\ndata","Gross\npatient\ncharges\ngreater than\nor equal to\nAdjustment\nto \ncharges"]
[null,null,null,null,null,null,"Government",null,null,null,null,"Revenue Source",null,null,null,null,null,"Gross Patient\nCharges",null,null,null,null,"-",null,"Adjustment\nto Charges",null,null,null,null,"=",null,"Net Patient\nRevenue"]
[null,null,null,null,null,null,null,null,null,null,null,"Medicare",null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,{"$f":"(F_RGMGPC-F_RGMAC)","v":0},null,null,null,null,null,{"$f":"IF(F_RGMGPC<>\"\",\"Ok\", \"Error\")","v":"Error"},{"$f":"IF(F_RGMAC<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(F_RGMGPC>=F_RGMAC,\"Ok\", \"Error\")","v":"Ok"}]
[null,null,null,null,null,null,null,null,null,null,null,"TennCare",null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"=",null,{"$f":"(f_rgtcgpc-F_RGTCAC)","v":0},null,null,null,null,null,{"$f":"IF(f_rgtcgpc<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(F_RGTCAC<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(f_rgtcgpc>=F_RGTCAC,\"Ok\", \"Error\")","v":"Ok"}]
[null,null,null,null,null,null,null,null,null,null,null,"Other \nGovernment",null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"=",null,{"$f":"(F_RGOGGPC-F_RGOGAC)","v":0},null,null,null,null,null,{"$f":"IF(F_RGOGGPC<>\"\",\"Ok\", \"Error\")","v":"Error"},{"$f":"IF(F_RGOGAC<>\"\",\"Ok\", \"Error\")","v":"Error"},{"$f":"IF(F_RGOGGPC>=F_RGOGAC,\"Ok\", \"Error\")","v":"Ok"}]
[null,null,null,null,null,null,null,null,null,null,null,"Total \nGovernment",null,null,null,null,null,{"$f":"SUM(R13:V15)","v":0},null,null,null,null,"-",null,{"$f":"SUM(Y13:AC15)","v":0},null,null,null,null,"=",null,{"$f":"(F_RGTGGPC-F_RGTGAC)","v":0}]
[null,null,null,null,null,null,"Non-\nGovernment",null,null,null,null,"Self-Pay",null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"=",null,{"$f":"(F_RNGSPGPC-F_RNGSPAC)","v":0},null,null,null,null,null,{"$f":"IF(F_RNGSPGPC<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(F_RNGSPAC<>\"-\",\"Ok\",\"Error\")","v":"Ok"},{"$f":"IF(F_RNGSPGPC>=F_RNGSPAC,\"Ok\", \"Error\")","v":"Ok"}]
[null,null,null,null,null,null,null,null,null,null,null,"Insurance",null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"=",null,{"$f":"(F_RNGIGPC-F_RNGIAC)","v":0},null,null,null,null,null,{"$f":"IF(F_RNGIGPC<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(F_RNGIAC<>\"-\",\"Ok\",\"Error\")","v":"Ok"},{"$f":"IF(F_RNGIGPC>=F_RNGIAC,\"Ok\",\"Error\")","v":"Ok"}]
[null,null,null,null,null,null,null,null,null,null,null,"Other Non-\nGovernment",null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"=",null,{"$f":"(F_RNGNGGPC-F_RNGNGAC)","v":0},null,null,null,null,null,{"$f":"IF(F_RNGNGGPC<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(F_RNGNGAC<>\"-\",\"Ok\",\"Error\")","v":"Ok"},{"$f":"IF(F_RNGNGGPC>=F_RNGNGAC,\"Ok\",\"Error\")","v":"Ok"}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Non-\nGovernment",null,null,null,null,null,{"$f":"SUM(R17:V19)","v":0},null,null,null,null,"-",null,{"$f":"SUM(Y17:AC19)","v":0},null,null,null,null,"=",null,{"$f":"(F_RNGTGPC-F_RNGTAC)","v":0}]
[null,null,null,null,null,null,"Total Patient Revenue:\n(Total Government plus\nTotal Non-Government)",null,null,null,null,null,null,null,null,null,null,{"$f":"F_RGTGGPC+F_RNGTGPC","v":0},null,null,null,null,"-",null,{"$f":"F_RGTGAC+F_RNGTAC","v":0},null,null,null,null,"=",null,{"$f":"(F_RTOTGPC-F_RTOTAC)","v":0},null,null,null,null,null,"Provide\nNon-Patient\ndata","Provide\nother\nadjustments\nto\ncharges\ndata"]
[null,null,null,null,null,null,"All Non-Patient Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"IF(F_ANPR<>\"\",\"Ok\",\"Error\")","v":"Ok"}]
[null,null,null,null,null,null,"Total Net Revenue: Net Total Patient Revenue plus All Non-Patient Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(F_RTOTNPR+F_ANPR)","v":0}]
["Non-Government\nAdjustment to\nCharges\nSubcategories",null,null,null,null,null,"Bad Debt - Uncompensated care for which the facility directly billed the \npatient and for which the patient should reasonably be expected to pay.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F_NGBD<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,"Charity Care - Services provided to medically needy persons for which the \nfacility does not expect payment.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F_NGCC<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,"Other - Any other adjustments that are not appropriately reported in either \nBad Debt or Charity.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(F_NGOTR<>\"\",\"Ok\",\"Error\")","v":"Ok"}]
[null,null,null,null,null,null,"Total Non-Government Adjustment to Charges Subcategories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AF24:AJ26)","v":0}]
["Go to Next Schedule"]
["Return to Main Menu"]
["Go to Error Listing"]

{"sheet":"F","index":15,"n_rows":4,"n_cols":42,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,38,1,41],[0,0,1,2],[1,9,1,11],[1,12,1,14],[1,15,1,17],[1,18,1,20],[0,9,0,20],[1,21,1,23],[1,24,1,26],[1,27,1,29],[1,30,1,32],[1,33,1,35]]}
["Facility ID Info",null,null,"Expenses",null,null,null,null,null,"Patient Revenue Government",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-Government Adjustment to Charges Subcatregories"]
[null,null,null,null,null,null,null,null,null,"Medicare",null,null,"TennCare",null,null,"Other Government",null,null,"Total Government",null,null,"Self-Pay",null,null,"Insurance",null,null,"Other Non-Government",null,null,"Total Non-Government",null,null,"Total Patient Revenue"]
["State ID","Facility\nName","County","Payroll","Fringe \nBenefits","Other\nOperating\nExpenses","Depreciation \nExpense","Non-\nOperating\nExpense","Total","Gross\nPatient\nCharges","Adjustment\nto\nCharges","Net\nPatient\nRevenue","Gross\nPatient\nCharges","Adjustment\nto\nCharges","Net\nPatient\nRevenue","Gross\nPatient\nCharges","Adjustment\nto\nCharges","Net\nPatient\nRevenue","Gross\nPatient\nCharges","Adjustment\nto\nCharges","Net\nPatient\nRevenue","Gross\nPatient\nCharges","Adjustment\nto\nCharges","Net\nPatient\nRevenue","Gross\nPatient\nCharges","Adjustment\nto\nCharges","Net\nPatient\nRevenue","Gross\nPatient\nCharges","Adjustment\nto\nCharges","Net\nPatient\nRevenue","Gross\nPatient\nCharges","Adjustment\nto\nCharges","Net\nPatient\nRevenue","Gross\nPatient\nCharges","Adjustment\nto\nCharges","Net\nPatient\nRevenue","All Non-\nPatient\nRevenue","Total\nNet\nRevenue","Bad Debt","Charity\nCare","Other","Total\nAdjustment\nto\nCharges"]
[{"$f":"A_StateID","v":0},{"$f":"A_Name","v":"-"},{"$f":"A_County","v":"-"},{"$f":"F_EPAY","v":0},{"$f":"F_EFB","v":0},{"$f":"F_EOOE","v":0},{"$f":"F_EDE","v":0},{"$f":"F_ENOE","v":0},{"$f":"F_ETOT","v":0},{"$f":"F_RGMGPC","v":0},{"$f":"F_RGMAC","v":0},{"$f":"F_RGMNPR","v":0},{"$f":"f_rgtcgpc","v":0},{"$f":"F_RGTCAC","v":0},{"$f":"F_RGTCNPR","v":0},{"$f":"F_RGOGGPC","v":0},{"$f":"F_RGOGAC","v":0},{"$f":"F_RGOGNPR","v":0},{"$f":"F_RGTGGPC","v":0},{"$f":"F_RGTGAC","v":0},{"$f":"F_RGTGNPR","v":0},{"$f":"F_RNGSPGPC","v":0},{"$f":"F_RNGSPAC","v":0},{"$f":"F_RNGSPNPR","v":0},{"$f":"F_RNGIGPC","v":0},{"$f":"F_RNGIAC","v":0},{"$f":"F_RNGINPR","v":0},{"$f":"F_RNGNGGPC","v":0},{"$f":"F_RNGNGAC","v":0},{"$f":"F_RNGNGNPR","v":0},{"$f":"F_RNGTGPC","v":0},{"$f":"F_RNGTAC","v":0},{"$f":"F_RNGTNPR","v":0},{"$f":"F_RTOTGPC","v":0},{"$f":"F_RTOTAC","v":0},{"$f":"F_RTOTNPR","v":0},{"$f":"F_ANPR","v":0},{"$f":"F_TOTNPR","v":0},{"$f":"F_NGBD","v":0},{"$f":"F_NGCC","v":0},{"$f":"F_NGOTR","v":0},{"$f":"F_NGTOT","v":0}]

{"sheet":"Sch G","index":16,"n_rows":53,"n_cols":42,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,17,1,31],[1,32,1,35],[45,37,47,37],[41,37,43,37],[38,38,40,38],[13,38,17,38],[46,16,46,19],[48,16,48,19],[48,24,48,27],[45,9,45,35],[46,32,46,35],[48,32,48,35],[43,9,43,15],[39,16,39,19],[40,16,41,19],[42,24,43,27],[39,28,39,31],[40,28,41,31],[42,28,43,31],[39,32,39,35],[40,32,41,35],[42,32,43,35],[36,9,36,13],[36,14,36,17],[49,32,49,35],[47,32,47,35],[46,28,46,31],[48,28,48,31],[49,28,49,31],[47,28,47,31],[44,9,44,11],[44,12,44,14],[44,15,44,35],[49,16,49,19],[46,9,46,15],[48,9,48,15],[49,9,49,15],[47,9,47,15],[47,16,47,19],[49,24,49,27],[46,20,46,23],[48,20,48,23],[49,20,49,23],[47,20,47,23],[47,24,47,27],[46,24,46,27],[31,9,32,13],[37,32,37,35],[37,28,37,31],[37,24,37,27],[37,20,37,23],[38,9,38,15],[38,32,38,35],[39,20,39,23],[40,20,41,23],[39,24,39,27],[40,24,41,27],[37,9,37,15],[38,20,38,23],[38,24,38,27],[38,28,38,31],[33,22,33,25],[34,9,34,13],[35,9,35,13],[42,16,43,19],[39,9,39,15],[40,9,40,15],[41,9,41,15],[42,9,42,15],[42,20,43,23],[36,26,36,29],[36,22,36,25],[36,18,36,21],[37,16,37,19],[38,16,38,19],[30,14,30,17],[31,14,32,17],[33,14,33,17],[34,14,34,17],[35,14,35,17],[32,33,32,35],[33,18,33,21],[34,18,34,21],[35,18,35,21],[35,33,35,35],[35,26,35,29],[35,22,35,25],[34,22,34,25],[34,30,34,32],[30,22,30,25],[30,26,30,29],[30,18,30,21],[32,30,32,32],[34,33,34,35],[31,26,32,29],[33,26,33,29],[34,26,34,29],[31,22,32,25],[31,18,32,21],[27,33,27,35],[28,33,28,35],[29,33,29,35],[36,33,36,35],[30,30,30,32],[33,30,33,32],[33,33,33,35],[30,33,30,35],[31,30,31,35],[35,30,35,32],[36,30,36,32],[26,22,26,25],[27,22,27,25],[28,22,28,25],[29,22,29,25],[26,30,26,32],[27,30,27,32],[28,30,28,32],[29,30,29,32],[8,32,8,35],[9,32,9,35],[10,32,10,35],[11,32,11,35],[26,26,26,29],[27,26,27,29],[28,26,28,29],[29,26,29,29],[8,24,8,27],[9,24,9,27],[10,24,10,27],[11,24,11,27],[12,32,12,35],[8,28,8,31],[9,28,9,31],[10,28,10,31],[0,0,0,35],[1,0,1,3],[1,4,1,9],[1,10,1,16],[17,20,17,23],[13,24,13,27],[14,24,14,27],[15,24,15,27],[16,24,16,27],[2,0,2,35],[4,5,4,35],[15,28,15,31],[9,5,9,19],[10,5,10,19],[11,5,11,19],[12,5,12,19],[13,5,13,19],[14,5,14,19],[13,28,13,31],[16,28,16,31],[17,28,17,31],[15,32,15,35],[16,32,16,35],[17,32,17,35],[4,0,21,4],[25,30,25,32],[25,26,25,29],[25,22,25,25],[25,18,25,21],[25,14,25,17],[15,5,15,19],[16,5,16,19],[17,5,17,19],[11,28,11,31],[12,28,12,31],[13,20,13,23],[14,20,14,23],[15,20,15,23],[16,20,16,23],[12,24,12,27],[8,20,8,23],[9,20,9,23],[10,20,10,23],[11,20,11,23],[12,20,12,23],[50,0,50,35],[51,0,51,35],[52,0,52,35],[5,20,5,35],[6,20,6,27],[6,28,6,35],[7,20,7,23],[7,24,7,27],[7,28,7,31],[7,32,7,35],[37,5,43,8],[44,5,49,8],[22,0,49,4],[26,14,26,17],[27,14,27,17],[28,14,28,17],[29,14,29,17],[26,9,26,13],[26,18,26,21],[26,33,26,35],[20,28,20,31],[20,24,20,27],[31,5,36,8],[21,5,21,19],[0,37,0,39],[25,33,25,35],[25,9,25,13],[23,9,24,13],[23,14,24,17],[23,18,24,21],[23,22,24,25],[23,26,24,29],[23,30,23,35],[24,30,24,32],[21,20,21,23],[22,5,22,35],[24,33,24,35],[18,24,18,27],[18,28,18,31],[18,32,18,35],[21,24,21,27],[21,28,21,31],[21,32,21,35],[18,5,18,10],[19,32,19,35],[20,32,20,35],[19,28,19,31],[19,24,19,27],[27,9,27,13],[28,9,28,13],[29,9,29,13],[27,18,27,21],[28,18,28,21],[29,18,29,21],[30,9,30,13],[33,9,33,13],[3,0,3,35],[19,5,19,10],[20,5,20,10],[23,5,30,8],[19,20,19,23],[20,20,20,23],[18,11,18,19],[19,11,19,19],[20,11,20,19],[18,20,18,23],[8,5,8,19],[14,28,14,31],[13,32,13,35],[14,32,14,35],[17,24,17,27],[5,5,7,19]]}
["2020 Tennessee - ODC - Provisional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'Ok' = Likely no Error\n'Error' = Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,null,"Facility Name:",null,null,null,null,null,null,{"$f":"A_Name","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]
["Outpatient Diagnostic Centers Joint Annual Report - Schedule G - Personnel"]
["Do not enter zero.  Blank fields will represent zero personnel."]
["2020          Type of\nPersonnel\nby Service",null,null,null,null,"Please indicate the number of paid personnel as of the last day of the reporting period. Do not include\na type of personnel for which you do not provide that type of service.  For example, do not include \nPhysical Therapists unless you provide Physical Therapy services.   \nLeave the item blank if the value is unknown.  Full Time Equivalent (FTE) = Number of hours worked \nby part-time employees per week/40 hours per week. For example, three Registered Nurses, each \nworking 20 hours a week, the FTE would be (3x20)/40=1.5. Additional examples of FTEs: \n40 hours = 1 FTE; 30 hours = .75 FTE; 20 hours = .5 FTE; 10 hours = .25 FTE. For the purposes of\n this calculation, if your agency reimburses employees per visit rather than per hour worked, one \nvisit equals one hour in FTE. The sum of full-time personnel plus part-time personnel (in full-time \nequivalents) added together equal the total number of full-time equivalents."]
[null,null,null,null,null,"2020 Type Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Personnel by type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee",null,null,null,null,null,null,null,"Contract"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full-Time",null,null,null,"Part-Time\nIn FTE",null,null,null,"Full-Time",null,null,null,"Part-Time\nIn FTE"]
[null,null,null,null,null,"Administrators"]
[null,null,null,null,null,"Medical Director"]
[null,null,null,null,null,"Physicians (M.D.  And D.O.)"]
[null,null,null,null,null,"Dentists"]
[null,null,null,null,null,"Financial/Billing Personnel"]
[null,null,null,null,null,"Nursing (R.N., L.P.N., and Ancillary)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other\nPersonnel\nindicated,\nprovide \nadditional\ndata"]
[null,null,null,null,null,"Medical Records"]
[null,null,null,null,null,"Registered Technologist"]
[null,null,null,null,null,"Technical"]
[null,null,null,null,null,"Maintenance/Services"]
[null,null,null,null,null,"Other 1, Specify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AP19>=0.01,GO1S<>\"\"),\"Ok\",IF(AND(AP19=0,GO1S=\"\"),\"Ok\",\"Error\"))","v":"Ok"},null,null,{"$f":"SUM(U19:AJ19)","v":0}]
[null,null,null,null,null,"Other 2, Specify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AP20>=0.01,GO2S<>\"\"),\"Ok\",IF(AND(AP20=0,GO2S=\"\"),\"Ok\",\"Error\"))","v":"Ok"},null,null,{"$f":"SUM(U20:AJ20)","v":0}]
[null,null,null,null,null,"Other 3, Specify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AP21>=0.01,GO3S<>\"\"),\"Ok\",IF(AND(AP21=0,GO3S=\"\"),\"Ok\",\"Error\"))","v":"Ok"},null,null,{"$f":"SUM(U21:AJ21)","v":0}]
[null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U9:X21)","v":0},null,null,null,{"$f":"SUM(Y9:AB21)","v":0},null,null,null,{"$f":"SUM(AC9:AF21)","v":0},null,null,null,{"$f":"SUM(AG9:AJ21)","v":0}]
["2020          Nursing\nPersonnel",null,null,null,null,"Please indicate the number of personnel as of the last day of the reporting period."]
[null,null,null,null,null,"2020     Registered Nurses",null,null,null,"Highest\nEducation\nLevel",null,null,null,null,"Number\nCurrently\nEmployed",null,null,null,"Number of\nBudgeted\nVacancies",null,null,null,"Average\n# Weeks\nRequired to\nRecruit Staff",null,null,null,"Number\nAdded in\nthe Past 12\nMonths",null,null,null,"Number\nEliminated in the\nPast 12 Months"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinical",null,null,"Admin"]
[null,null,null,null,null,null,null,null,null,"Associate"]
[null,null,null,null,null,null,null,null,null,"Diploma"]
[null,null,null,null,null,null,null,null,null,"Bachelors"]
[null,null,null,null,null,null,null,null,null,"Masters"]
[null,null,null,null,null,null,null,null,null,"Doctorate"]
[null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(O26:R30)","v":0},null,null,null,{"$f":"SUM(S26:V30)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(AA26:AD30)","v":0},null,null,null,{"$f":"SUM(AE26:AG30)","v":0},null,null,{"$f":"SUM(AH26:AJ30)","v":0}]
[null,null,null,null,null,"2020     Advanced Practice Nurses",null,null,null,"Category",null,null,null,null,"Number\nCurrently\nEmployed",null,null,null,"Number of\nBudgeted\nVacancies",null,null,null,"Average\n# Weeks\nRequired to\nRecruit Staff",null,null,null,"Number\nAdded in\nthe Past 12\nMonths",null,null,null,"Number\nEliminated in the\nPast 12 Months"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinical",null,null,"Admin"]
[null,null,null,null,null,null,null,null,null,"Nurse\nPractitioner"]
[null,null,null,null,null,null,null,null,null,"Clinical\nNurse\nSpecialist"]
[null,null,null,null,null,null,null,null,null,"Certified\nRegistered\nNurse\nAnesthetist"]
[null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(O34:R36)","v":0},null,null,null,{"$f":"SUM(S34:V36)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(AA34:AD36)","v":0},null,null,null,{"$f":"SUM(AE34:AG36)","v":0},null,null,{"$f":"SUM(AH34:AJ36)","v":0}]
[null,null,null,null,null,"2020     Other Nurses",null,null,null,"Other Nursing Staff",null,null,null,null,null,null,"Number Currently Employed",null,null,null,"Number of Budgeted Vacancies",null,null,null,"Average #Weeks Required to Recruit Staff",null,null,null,"Number added in the Past 12 Months",null,null,null,"Number Eliminated in the Past 12 Months"]
[null,null,null,null,null,null,null,null,null,"Licensed Practical Nurses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other\nNurses \nindicated,\nprovide\nadditional\ndata"]
[null,null,null,null,null,null,null,null,null,"Certified Nurses Aides"]
[null,null,null,null,null,null,null,null,null,"Other 1, Specify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q41:AJ42)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes/No\nContract\nNursing",{"$f":"IF(AND(AP41>=1,GOO1S<>\"\"),\"Ok\",IF(AND(AP41=0,GOO1S=\"\"),\"Ok\",\"Error\"))","v":"Ok"}]
[null,null,null,null,null,null,null,null,null,"Other 2, Specify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q43:AJ44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AP43>=1,GOO2S<>\"\"),\"Ok\",IF(AND(AP43=0,GOO2S=\"\"),\"Ok\",\"Error\"))","v":"Ok"}]
[null,null,null,null,null,"2020     Contract Nursing",null,null,null,"Yes/No",null,null,"No",null,null,"Does your organization use contract nursing personnel?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(GCYN=\"Yes\",GCYN=\"No\"),\"Ok\",\"Error\")","v":"Ok"}]
[null,null,null,null,null,null,null,null,null,"If yes, indicate the number of contract personnel in the following categories:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract\nNursing\nchecked \nYes,\nprovide\nadditional\ndata"]
[null,null,null,null,null,null,null,null,null,"Contract Nursing Staff",null,null,null,null,null,null,"Number Currently Employed",null,null,null,"Number of Budgeted Vacancies",null,null,null,"Average #Weeks Required to Recruit Staff",null,null,null,"Number added in the Past 12 Months",null,null,null,"Number Eliminated in the Past 12 Months"]
[null,null,null,null,null,null,null,null,null,"Registered Nurses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q48:AJ50)","v":0}]
[null,null,null,null,null,null,null,null,null,"Licensed Practical Nurses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(GCYN=\"No\",AO48=0),\"Ok\",IF(AND(GCYN=\"Yes\",AO48>=1),\"Ok\",\"Error\"))","v":"Ok"}]
[null,null,null,null,null,null,null,null,null,"Certified Nurse Aids"]
[5]
["Return to Main Menu"]
["Go to Error Listing"]

{"sheet":"G","index":17,"n_rows":4,"n_cols":158,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,1,2],[1,39,1,42],[1,62,1,67],[1,68,1,73],[1,97,1,102],[1,103,1,108],[1,109,1,114],[1,115,1,119],[1,74,1,79],[1,80,1,85],[1,86,1,91],[1,92,1,96],[1,143,1,147],[1,148,1,152],[1,153,1,157],[1,120,1,124],[1,125,1,129],[1,130,1,135],[1,136,1,141]]}
["Facility ID Info",null,null,"Type of Personnel by Service",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nursing Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Contract Nursing Personnel"]
[null,null,null,"Administrators",null,null,null,"Midical Director",null,null,null,"Physicians (M.D. And D.O.)",null,null,null,"Dentists",null,null,null,"Financial/Billing Personnel",null,null,null,"Nursing (R.N., L.P.N., and Ancillary)",null,null,null,"Medical Records",null,null,null,"Registered Technologist",null,null,null,"Technical",null,null,null,"Maintenace/Services",null,null,null,"Other 1",null,null,null,null,"Other 2",null,null,null,null,"Other 3",null,null,null,null,"Total (System Calculation)",null,null,null,"Registered Nurses - Associate",null,null,null,null,null,"Registered Nurses - Diploma",null,null,null,null,null,"Registered Nurses - Bachelors",null,null,null,null,null,"Registered Nurses - Masters",null,null,null,null,null,"Registered Nurses - Doctorate",null,null,null,null,null,"Registered Nurses - Total",null,null,null,null,"Advanced Practice nurses - Nurse Practitioner",null,null,null,null,null,"Advanced Practice nurses - Clinical Nurse Specialist",null,null,null,null,null,"Advanced Practice nurses - Certified Registered Nurse Anesthetist",null,null,null,null,null,"Advanced Practice nurses - Total",null,null,null,null,"Other Nursing Staff - Licensed Practical Nurses",null,null,null,null,"Other Nursing Staff - Certified Nurses Aides",null,null,null,null,"Other Nursing Staff - Other 1",null,null,null,null,null,"Other Nursing Staff - Other 2",null,null,null,null,null,null,"Registered Nurses",null,null,null,null,"Licensed practical Nurses",null,null,null,null,"Certified Nurse Aides"]
["State ID","Facility\nName","County","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Specify","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Specify","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Specify","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Employee\nFull-Time","Employee\nPart-Time\nIn FTE","Contract\nFull-Time","Contract\nPart-Time\nIn FTE","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths\nClinical","Number\nEliminated in\nLast 12\nMonths\nAdmin","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths\nClinical","Number\nEliminated in\nLast 12\nMonths\nAdmin","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths\nClinical","Number\nEliminated in\nLast 12\nMonths\nAdmin","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths\nClinical","Number\nEliminated in\nLast 12\nMonths\nAdmin","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths\nClinical","Number\nEliminated in\nLast 12\nMonths\nAdmin","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths\nClinical","Number\nEliminated in\nLast 12\nMonths\nAdmin","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths\nClinical","Number\nEliminated in\nLast 12\nMonths\nAdmin","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths\nClinical","Number\nEliminated in\nLast 12\nMonths\nAdmin","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths\nClinical","Number\nEliminated in\nLast 12\nMonths\nAdmin","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths\nClinical","Number\nEliminated in\nLast 12\nMonths\nAdmin","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths","Other 1\nSpecify","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths","Other 2\nSpecify","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths","Use Contract Nursing Yes/No","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths","Number\nCurrently\nEmployed","Number of\nBudgeted \nVacancies","Average \n#Weeks\nRequired to\nRecruit Staff","Number\nAdded in\nthe Past 12\nMonths","Number\nEliminated in\nLast 12\nMonths"]
[{"$f":"A_StateID","v":0},{"$f":"A_Name","v":"-"},{"$f":"A_County","v":"-"},{"$f":"GADMEFT","v":0},{"$f":"GADMEPT","v":0},{"$f":"GADMCFT","v":0},{"$f":"GADMCPT","v":0},{"$f":"GMDEFT","v":0},{"$f":"GMDEPT","v":0},{"$f":"GMDCFT","v":0},{"$f":"GMDCPT","v":0},{"$f":"GPHEFT","v":0},{"$f":"GPHEPT","v":0},{"$f":"GPHCFT","v":0},{"$f":"GPHCPT","v":0},{"$f":"GDEFT","v":0},{"$f":"GDEPT","v":0},{"$f":"GDCFT","v":0},{"$f":"GDCPT","v":0},{"$f":"GFBEFT","v":0},{"$f":"GFBEPT","v":0},{"$f":"GFBCFT","v":0},{"$f":"GFBCPT","v":0},{"$f":"GNUREFT","v":0},{"$f":"GNUREPT","v":0},{"$f":"GNURCFT","v":0},{"$f":"GNURCPT","v":0},{"$f":"GMREFT","v":0},{"$f":"GMREPT","v":0},{"$f":"GMRCFT","v":0},{"$f":"GMRCPT","v":0},{"$f":"GRTEFT","v":0},{"$f":"GRTEPT","v":0},{"$f":"GRTCFT","v":0},{"$f":"GRTCPT","v":0},{"$f":"GTEFT","v":0},{"$f":"GTEPT","v":0},{"$f":"GTCFT","v":0},{"$f":"GTCPT","v":0},{"$f":"GMAEFT","v":0},{"$f":"GMAEPT","v":0},{"$f":"GMACFT","v":0},{"$f":"GMACPT","v":0},{"$f":"GO1S","v":0},{"$f":"GO1EFT","v":0},{"$f":"GO1EPT","v":0},{"$f":"GO1CFT","v":0},{"$f":"GO1CPT","v":0},{"$f":"GO2S","v":0},{"$f":"GO2EFT","v":0},{"$f":"GO2EPT","v":0},{"$f":"GO2CFT","v":0},{"$f":"GO2CPT","v":0},{"$f":"GO3S","v":0},{"$f":"GO3EFT","v":0},{"$f":"GO3EPT","v":0},{"$f":"GO3CFT","v":0},{"$f":"GO3CPT","v":0},{"$f":"GTOTEFT","v":0},{"$f":"GTOTEPT","v":0},{"$f":"GTOTCFT","v":0},{"$f":"GTOTCPT","v":0},{"$f":"GRAN","v":0},{"$f":"GRAV","v":0},{"$f":"GRAAW","v":0},{"$f":"GRAPA","v":0},{"$f":"GRAEC","v":0},{"$f":"GRAEA","v":0},{"$f":"GRDIN","v":0},{"$f":"GRDIV","v":0},{"$f":"GRAAW","v":0},{"$f":"GRDIPA","v":0},{"$f":"GRDIEC","v":0},{"$f":"GRDIEA","v":0},{"$f":"GRBN","v":0},{"$f":"GRBV","v":0},{"$f":"GRBAW","v":0},{"$f":"GRBPA","v":0},{"$f":"GRBEC","v":0},{"$f":"GRBEA","v":0},{"$f":"GRMN","v":0},{"$f":"GRMV","v":0},{"$f":"GRMAW","v":0},{"$f":"GRMPA","v":0},{"$f":"GRMEC","v":0},{"$f":"GRMEA","v":0},{"$f":"GRDON","v":0},{"$f":"GRDOV","v":0},{"$f":"GRDOAW","v":0},{"$f":"GRDOPA","v":0},{"$f":"GRDOEC","v":0},{"$f":"GRCOEA","v":0},{"$f":"GRTN","v":0},{"$f":"GRTV","v":0},{"$f":"GRTPA","v":0},{"$f":"GRTEC","v":0},{"$f":"GRTEA","v":0},{"$f":"GANPN","v":0},{"$f":"GANPV","v":0},{"$f":"GANPAW","v":0},{"$f":"GANPPA","v":0},{"$f":"GANPEC","v":0},{"$f":"GANPEA","v":0},{"$f":"GACSN","v":0},{"$f":"GACSV","v":0},{"$f":"GACSAW","v":0},{"$f":"GACSPA","v":0},{"$f":"GACSEC","v":0},{"$f":"GACSEA","v":0},{"$f":"GANAN","v":0},{"$f":"GANAV","v":0},{"$f":"GANAAW","v":0},{"$f":"GANAPA","v":0},{"$f":"GANAEC","v":0},{"$f":"GANAEA","v":0},{"$f":"GATN","v":0},{"$f":"GATV","v":0},{"$f":"GATPA","v":0},{"$f":"GATEC","v":0},{"$f":"GATEA","v":0},{"$f":"GOLPN","v":0},{"$f":"GOLPV","v":0},{"$f":"GALPAW","v":0},{"$f":"GOLPPA","v":0},{"$f":"GOLPE","v":0},{"$f":"GOAN","v":0},{"$f":"GOAV","v":0},{"$f":"GOAAW","v":0},{"$f":"GOAPA","v":0},{"$f":"GOAE","v":0},{"$f":"GOO1S","v":0},{"$f":"GOO1N","v":0},{"$f":"GOO1V","v":0},{"$f":"GOO1AW","v":0},{"$f":"GOO1PA","v":0},{"$f":"GOO1E","v":0},{"$f":"GOO2S","v":0},{"$f":"GOO2N","v":0},{"$f":"GOO2V","v":0},{"$f":"GOO2AW","v":0},{"$f":"GOO2PA","v":0},{"$f":"GOO2E","v":0},{"$f":"GCYN","v":"No"},{"$f":"GCRNN","v":0},{"$f":"GCRNV","v":0},{"$f":"GCRNAW","v":0},{"$f":"GCRNPA","v":0},{"$f":"GCRNE","v":0},{"$f":"GCLPN","v":0},{"$f":"GCLPV","v":0},{"$f":"GCLPAW","v":0},{"$f":"GCLPPA","v":0},{"$f":"GCLPE","v":0},{"$f":"GCAN","v":0},{"$f":"GCAV","v":0},{"$f":"GCAAW","v":0},{"$f":"GCAPA","v":0},{"$f":"GCAE","v":0}]

{"sheet":"Sch H","index":18,"n_rows":16,"n_cols":42,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,32,1,35],[6,30,6,35],[7,24,7,29],[7,30,7,35],[7,5,7,23],[14,0,14,35],[15,0,15,35],[12,12,12,23],[12,5,12,11],[0,0,0,35],[1,0,1,3],[1,4,1,9],[1,10,1,16],[6,5,6,23],[6,24,6,29],[10,5,10,23],[10,24,10,29],[10,30,10,35],[11,24,11,29],[11,30,11,35],[1,17,1,31],[8,30,8,35],[2,0,2,35],[3,0,3,35],[6,37,10,37],[12,30,12,35],[12,24,12,29],[0,37,0,39],[13,0,13,35],[4,0,12,4],[5,30,5,35],[9,24,9,29],[8,24,8,29],[5,24,5,29],[11,5,11,11],[11,12,11,23],[1,37,2,37],[1,38,2,38],[9,5,9,23],[8,5,8,23],[5,5,5,23],[4,5,4,35],[9,30,9,35]]}
["2020 Tennessee - ODC - Provisional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'Ok' = Likely no Error\n'Error' = Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,null,"Facility Name:",null,null,null,null,null,null,{"$f":"A_Name","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]
["Outpatient Diagnostic Centers Joint Annual Report - Schedule H - Medical Staff"]
["Do not enter zero.  Blank fields will represent zero medical staff."]
["2020     Medical\nStaff",null,null,null,null,"Include all physicians, whether considered active or associate.\nActive: Employed and practicing at the facility\nAssociate: Has privileges to practice at the facility but is not employed at the facility"]
[null,null,null,null,null,"Specialty",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Number of\nMedical Staff",null,null,null,null,null,"Number of Medical\nStaff who are\nBoard Certified"]
[null,null,null,null,null,"Cardiologist",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other, specified, please add Medical Staff or Board Certified"]
[null,null,null,null,null,"Neurologists"]
[null,null,null,null,null,"Pathologist"]
[null,null,null,null,null,"Radiologist"]
[null,null,null,null,null,"Technician"]
[null,null,null,null,null,"Other 1, specify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AO12>=1,HO1S<>\"\"),\"Ok\",IF(AND(AO12=0,HO1S=\"\"),\"Ok\", \"Error\"))","v":"Ok"},null,null,{"$f":"SUM(Y12:AJ12)","v":0},{"$f":"SUM(HCMS+HCBC)","v":0}]
[null,null,null,null,null,"Other 2, specify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AO13>=1,HO2S<>\"\"),\"Ok\",IF(AND(AO13=0,HO2S=\"\"),\"Ok\", \"Error\"))","v":"Ok"},null,null,{"$f":"SUM(Y13:AJ13)","v":0}]
["Go to Next Schedule"]
["Return to Main Menu"]
["Go to Error Listing"]

{"sheet":"H","index":19,"n_rows":4,"n_cols":19,"rows_kept":4,"cut":false,"hidden":true,"merged":[[1,16,1,18],[0,0,1,2],[1,7,1,8],[1,9,1,10],[1,13,1,15],[0,3,0,18],[1,3,1,4],[1,5,1,6],[1,11,1,12]]}
["Facility ID Info",null,null,"Medical Staff"]
[null,null,null,"Cardiologist",null,"Neurologists",null,"Pathologist",null,"Radiologist",null,"Technician",null,"Other 1",null,null,"Other 2"]
["State ID","Facility\nName","County","Total\nMedical\nStaff","Medical\nStaff\nBoard\nCertified","Total\nMedical\nStaff","Medical\nStaff\nBoard\nCertified","Total\nMedical\nStaff","Medical\nStaff\nBoard\nCertified","Total\nMedical\nStaff","Medical\nStaff\nBoard\nCertified","Total\nMedical\nStaff","Medical\nStaff\nBoard\nCertified","Specify","Total\nMedical\nStaff","Medical\nStaff\nBoard\nCertified","Specify","Total\nMedical\nStaff","Medical\nStaff\nBoard\nCertified"]
[{"$f":"A_StateID","v":0},{"$f":"A_Name","v":"-"},{"$f":"A_County","v":"-"},{"$f":"HCMS","v":0},{"$f":"HCBC","v":0},{"$f":"HNMS","v":0},{"$f":"HNBC","v":0},{"$f":"HPMS","v":0},{"$f":"HPBC","v":0},{"$f":"HRMS","v":0},{"$f":"HRBC","v":0},{"$f":"HTMS","v":0},{"$f":"HTBC","v":0},{"$f":"HO1S","v":0},{"$f":"HO1MS","v":0},{"$f":"HO1BC","v":0},{"$f":"HO2S","v":0},{"$f":"HO2MS","v":0},{"$f":"HO2BC","v":0}]

{"sheet":"Adm Dec","index":20,"n_rows":9,"n_cols":39,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,8,35],[5,0,5,5],[5,6,5,8],[5,9,5,35],[6,0,6,8],[6,9,6,17],[6,18,6,35],[1,38,2,38],[0,37,0,39],[7,0,7,35],[2,0,2,35],[0,0,0,35],[1,0,1,3],[1,4,1,9],[1,10,1,16],[1,17,1,31],[1,32,1,35],[3,0,3,1],[3,2,3,35],[4,0,4,1],[4,2,4,35],[4,38,5,38],[1,37,4,37]]}
["2020 Tennessee - ODC - Provisional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"'Ok' = Likely no Error\n'Error' = Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,null,"Facility Name:",null,null,null,null,null,null,{"$f":"A_Name","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,null,null,null,null,"Admin\nDeclaration Box\nChecked","Admin\nDeclaration 2019\n"]
["Outpatient Diagnostic Centers Joint Annual Report - Schedule Adm Dec - Administrator's Declaration"]
["-",null," Have you Saved and Renamed the report with your State ID and Facility name as instructed?  \n Example: \"12345 John Doe Imaging Center_ODC_2020\""]
["-",null," Have you Checked and Corrected all Errors on the Error Tab?  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Admin\nDeclaration\nDate Included"]
["Administrator's\nDeclaration",null,null,null,null,null,"-",null,null,"I, the administrator, declare that I have examined this report and to the best of my\nknowledge and belief, it is true, correct, and complete.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD_AdmDec=\"X\",\"Ok\",\"Error\")","v":"Error"}]
["Date (mm/dd/yyyy)\n(use slashes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD_AdmDecDate<>\"\",\"Ok\",\"Error\")","v":"Error"}]
["Return to Main Menu"]
["Go to Error Listing"]

{"sheet":"ERROR LISTING","index":21,"n_rows":150,"n_cols":6,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
["State           ID #","Ok/\nError","Return to\nschedule","Error\nNumber","2020  Provisional  Outpatient Diagnostic Centers                                    Error Message","Please provide an explanation of why the data cannot be changed \n(why an error may remain) for all error messages that are marked\n \"Error\"  Comments: "]
[{"$f":"A_StateID","v":0},{"$f":"'Sch A'!AL18","v":"Error"},"A_PrepName","A-01-03","Provide the data of the person preparing the Joint Annual Report."]
[0,{"$f":"'Sch A'!AL25","v":"Error"},"A_Admin","A-01-05","Provide the name of the Administrator, that is, the person responsible for the operations of the ODC."]
[0,{"$f":"'Sch A'!AM19","v":"Error"},"A_MA","A-02-03","Provide the data for the mailing address for the facility."]
[0,{"$f":"'Sch A'!AM25","v":"Error"},"A_MedDir","A-02-04","Provide the name of the Medical Director,"]
[0,{"$f":"'Sch A'!AN8","v":"Error"},"A_NameChange","A-03-01","Indicate Yes or No to the question about facility name change."]
[0,{"$f":"'Sch A'!AN16","v":"Error"},"A_MAYN","A-03-02","Indicate Yes or No to question about mailing address."]
[0,{"$f":"'Sch A'!AN23","v":"Error"},"A_RptBegDate","A_03-03","Provide reorting period Beginning and Ending dates."]
[0,{"$f":"'Sch B'!AL6","v":"Error"},"B_OwName","B-01-01","Provide additiional data for owner including Name, Street, City, State, Telephone, and Zip."]
[0,{"$f":"'Sch B'!AL12","v":"Error"},"B_TypeProfProp","B-01-02","Type of owner selected from Profit, Not for Profit, or Government, select only one."]
[0,{"$f":"'Sch B'!AL26","v":"Error"},"B_MOwn","B-01-04","Select Owner, Contract with firm, or Other in Managed by section."]
[0,{"$f":"'Sch B'!AL32","v":"Error"},"B_BYNCon","B-01-05","Indicate Yes or No to question about original construction date."]
[0,{"$f":"'Sch B'!AL33","v":"Error"},"B_BYNRen","B-01-06","Indicate Yes or No to question about major renovation."]
[0,{"$f":"'Sch B'!AL35","v":"Error"},"B_FFSYN","B-01-07","Indicate Yes or No to question about Free-Standing facility."]
[0,{"$f":"'Sch B'!AL37","v":"Error"},"B_FHBNM","B-01-08","Indicate Yes or No to question about Hospital Based."]
[0,{"$f":"'Sch B'!AL41","v":"Error"},"B_FDOYN","B-01-09","Indicate Yes or No to question about Doctor's Office."]
[0,{"$f":"'Sch B'!AL46","v":"Error"},"B_FOYN","B-01-10","Indicate Yes or No to question about Other facility."]
[0,"ok","B_TMSYN","B-01-11","Indicate Yes or No to question about Multi-Specialy service."]
[0,{"$f":"'Sch B'!AL50","v":"Error"},"B_TLPYN","B-01-12","Indicate Yes or No to question about Limited-Puropse service."]
[0,{"$f":"'Sch B'!AL51","v":"Error"},"B_TCYN","B-01-13","Indicate Yes or No to question about Cancer Treatment and Radiation Clinic service."]
[0,{"$f":"'Sch B'!AL52","v":"Error"},"B_TOYN","B-01-14","Indicate Yes or No to question about Other service."]
[0,{"$f":"'Sch B'!AM30","v":"Error"},"B_BOName","B-02-02","Provide additiional data for building owner including Name, Street, City, State, Telephone, and Zip."]
[0,{"$f":"'Sch C'!AL4","v":"Error"},"C_TCYN","C-01-01","Answer Yes or No to Participation in TennCare."]
[0,{"$f":"'Sch C'!AL5","v":"Error"},"C_MedYN","C-01-02","Answer Yes or No to Participatiion in Medicare."]
[0,{"$f":"'Sch C'!AL6","v":"Error"},"C_JCAHOYN","C-01-03","Answer Yes or No to Accreditation by Joint Commission on Accreditation of Healthcare Organizations."]
[0,{"$f":"'Sch C'!AL8","v":"Error"},"C_CLIAYN","C-01-04","Answer Yes or No to Accreditation by Clinical laboratory Improvement Amdndments."]
[0,{"$f":"'Sch C'!AL10","v":"Error"},"C_LPTYN","C-01-05","Answer Yes or No to Accreditation by Laboratory Proficiency Testing."]
[0,{"$f":"'Sch C'!AL12","v":"Error"},"C_AABBYN","C-01-06","Answer Yes or No to Accreditation by American Association of Blook Banks."]
[0,{"$f":"'Sch C'!AL14","v":"Error"},"C_AOAYN","C-01-07","Answer Yes or No to Accreditation by Amberican Osteopathic Association."]
[0,{"$f":"'Sch C'!AL16","v":"Error"},"C_CAPYN","C-01-08","Answer Yes or No to Accreditation by College of Amberican Pathologists."]
[0,{"$f":"'Sch C'!AL18","v":"Error"},"C_ACRYN","C-01-09","Answer Yes or No to Accreditation by American college of Radiology."]
[0,{"$f":"'Sch C'!AL20","v":"Error"},"C_OTH1YN","C-01-10","Answer Yes or No to Accreditation by Other 1."]
[0,{"$f":"'Sch C'!AL22","v":"Error"},"C_OTH2YN","C-01-11","Answer Yes or No to Accreditation by Other 2."]
[0,{"$f":"'Sch C'!AL24","v":"Error"},"C_OTH3YN","C-01-12","Answer Yes or No to Accreditation by Other 3."]
[0,{"$f":"'Sch C'!AM6","v":"Error"},"C_JCAHOAY","C-02-01","Yes answered to Joint Commission on Accreditation of Healthcare Organizations, provide Approval Year."]
[0,{"$f":"'Sch C'!AM7","v":"Error"},"C_JCAHOEY","C-02-02","Yes answered to Joint Commission on Accreditation of Healthcare Organizations, provide Expiration Year."]
[0,{"$f":"'Sch C'!AM8","v":"Error"},"C_CLIAAY","C-02-03","Yes answered to Clinical laboratory Improvement Amendments, provide Approval Year."]
[0,{"$f":"'Sch C'!AM9","v":"Error"},"C_CLIAEY","C-02-04","Yes answered to Clinical laboratory Improvement Amendments, provide Expiration Year."]
[0,{"$f":"'Sch C'!AM10","v":"Error"},"C_LPTAY","C-02-05","Yes answered to Laboratory Proficiency Testing, provide Approval Year."]
[0,{"$f":"'Sch C'!AM11","v":"Error"},"C_LPTEY","C-02-06","Yes answered to Laboratory Proficiency Testing, provide Expiration Year."]
[0,{"$f":"'Sch C'!AM12","v":"Error"},"C_AABBAY","C-02-07","Yes answered to American Association of Blood Banks, provide Approval Year."]
[0,{"$f":"'Sch C'!AM13","v":"Error"},"C_AABBEY","C-02-08","Yes answered to American Association of Blood Banks, Provide Expiration Year."]
[0,{"$f":"'Sch C'!AM14","v":"Error"},"C_AOAAY","C-02-09","Yes answered to American Osteopathic Association, Provide Approval Year."]
[0,{"$f":"'Sch C'!AM15","v":"Error"},"C_AOAEY","C-02-10","Yes answered to American Osteopathic Association, Provide Expiration Year."]
[0,{"$f":"'Sch C'!AM16","v":"Error"},"C_CAPAY","C-02-11","Yes answered to College of American Pathologists, Provide Approval Year."]
[0,{"$f":"'Sch C'!AM17","v":"Error"},"C_CAPEY","C-02-12","Yes answered to College of American Pathologists, Provide Expiration Year."]
[0,{"$f":"'Sch C'!AM18","v":"Error"},"C_ACRAY","C-02-13","Yes answered to American College of Radiology, Provide Approval Year."]
[0,{"$f":"'Sch C'!AM19","v":"Error"},"C_ACREY","C-02-14","Yes answered to American College of Radiology, Provide Expiration Year."]
[0,{"$f":"'Sch C'!AM20","v":"Error"},"C_OTH1AY","C-02-15","Yes answered to Other 1, Provide Approval Year"]
[0,{"$f":"'Sch C'!AM21","v":"Error"},"C_OTH1EY","C-02-16","Yes answered to Other 1, Provide Expiration Year"]
[0,{"$f":"'Sch C'!AM22","v":"Error"},"C_OTH2AY","C-02-17","Yes answered to Other 2, Provide Approval Year"]
[0,{"$f":"'Sch C'!AM23","v":"Error"},"C_OTH2EY","C-02-18","Yes answered to Other 2, Provide Expiration Year"]
[{"$f":"A_StateID","v":0},{"$f":"'Sch C'!AM24","v":"Error"},"C_OTH3AY","C-02-19","Yes answered to Other 3, Provide Approval Year"]
[0,{"$f":"'Sch C'!AM25","v":"Error"},"C_OTH3EY","C-02-20","Yes answered to Other 3, Provide Expiration Year"]
[0,{"$f":"'Sch C'!AN4","v":"Error"},"C_TCYN","C-03-01","Yes answered to Participation in TennCare, please provide Provider Number"]
[0,{"$f":"'Sch C'!AN5","v":"Error"},"C_MedYN","C-03-02","Yes answered to Participation in Medicare, please provide Provider Number"]
[0,{"$f":"'Sch C'!AN21","v":"Error"},"C_OTH1S","C-03-03","Yes answered to Other 1, Provide specific details"]
[0,{"$f":"'Sch C'!AN23","v":"Error"},"C_OTH2S","C-03-04","Yes answered to Other 2, Provide specific details"]
[0,{"$f":"'Sch C'!AN25","v":"Error"},"C_OTH3S","C-03-05","Yes answered to Other 3, Provide specific details"]
[0,{"$f":"'Sch D'!AL7","v":"Error"},"D_CEEGYN","D-01-01","Answer Yes or No to Electroencephalogram question."]
[0,{"$f":"'Sch D'!AL8","v":"Error"},"D_CEKGYN","D-01-02","Answer Yes or No to Electrocardiogram question."]
[0,{"$f":"'Sch D'!AL9","v":"Error"},"D_CHMYN","D-01-03","Answer Yes or No to Holter Monitoring question."]
[0,{"$f":"'Sch D'!AL10","v":"Error"},"D_CETTYN","D-01-04","Answer Yes or No to Excrcise Tolerance Testing question."]
[0,{"$f":"'Sch D'!AL11","v":"Error"},"D_CCCYN","D-01-05","Answer Yes or No to Cardiac Catheterization question."]
[0,{"$f":"'Sch D'!AL12","v":"Error"},"D_CPTYN","D-01-06","Answer Yes or No to Percutaneous Transiuminal Coronary Angioplasty question."]
[0,{"$f":"'Sch D'!AL14","v":"Error"},"D_RRADYN","D-01-07","Answer Yes or No to type of service Radiography question."]
[0,{"$f":"'Sch D'!AL15","v":"Error"},"D_RULTYN","D-01-08","Answer Yes or No to type of service Ultrasound question."]
[0,{"$f":"'Sch D'!AL16","v":"Error"},"D_RNMYN","D-01-09","Answer Yes or No to type of service Nuclear medicine question."]
[0,{"$f":"'Sch D'!AL19","v":"Error"},"D_RPETYN","D-01-10","Answer Yes or No to type of equipment Positron Emission Tomography question."]
[0,{"$f":"'Sch D'!AL20","v":"Error"},"D_RCTYN","D-01-11","Answer Yes or No to type of euqipment Computed Tomography question."]
[0,{"$f":"'Sch D'!AL21","v":"Error"},"D_RUTCYN","D-01-12","Answer Yes or No to type of equipment Ultrafast CT question."]
[0,{"$f":"'Sch D'!AL22","v":"Error"},"D_RMCIYN","D-01-13","Answer Yes or No to type of equipment Magnetic Resonance Imaging question."]
[0,{"$f":"'Sch D'!AL23","v":"Error"},"D_RHMRIYN","D-01-14","Answer Yes or No to type of equipment Hi Field MRI and Open MRI question."]
[0,{"$f":"'Sch D'!AL24","v":"Error"},"D_RMRTYN","D-01-15","Answer Yes or No to type of equipment Megavoltage Rediation Therapy question."]
[0,{"$f":"'Sch D'!AL25","v":"Error"},"D_RSPYN","D-01-16","Answer Yes or No to type of equipment Stereotactic Procedure question."]
[0,{"$f":"'Sch D'!AL26","v":"Error"},"D_RMAMYN","D-01-17","Answer Yes or No to type of equipment Mammography question."]
[0,{"$f":"'Sch D'!AL28","v":"Error"},"D_OVEYN","D-01-18","Answer Yes or No to other service Vascular Embolzation question."]
[0,{"$f":"'Sch D'!AL29","v":"Error"},"D_OAYN","D-01-19","Answer Yes or No to other service Anesthesia question."]
[0,{"$f":"'Sch D'!AL30","v":"Error"},"D_OACRYN","D-01-20","Answer Yes or No to other service Ultrasound question."]
[0,{"$f":"'Sch D'!AL31","v":"Error"},"D_OCYN","D-01-21","Answer Yes or No to other service Chemotherapy question."]
[0,{"$f":"'Sch D'!AL34","v":"Error"},"D_OLYN","D-01-22","Answer Yes or No to other type of equipment Lithotripsy question."]
[0,{"$f":"'Sch D'!AL35","v":"Error"},"D_OBDYN","D-01-23","Answer Yes or No to other type of equipment Bone Densitometry question."]
[0,{"$f":"'Sch D'!AL36","v":"Error"},"D_OSPYN","D-01-24","Answer Yes or No to other type of other equipment question. "]
[0,{"$f":"'Sch D'!AL40","v":"Error"},"D_OSP","D-01-25","Other type of equipment answered Yes, provide additional data."]
[0,{"$f":"'Sch D'!AM19","v":"Error"},"D_RPETF","D-02-01","Yes answered to Position Emission Tomography question, provide number of units."]
[0,{"$f":"'Sch D'!AM20","v":"Error"},"D_RCTF","D-02-02","Yes answered to Computed Tomography question, provide number of units."]
[0,{"$f":"'Sch D'!AM21","v":"Error"},"D_RUCTF","D-02-03","Yes answered to Ultrafast CT question, provide number of units."]
[0,{"$f":"'Sch D'!AM22","v":"Error"},"D_RMRIF","D-02-04","Yes answered to Magnetic Resonance Imaging question, provide number of units."]
[0,{"$f":"'Sch D'!AM23","v":"Error"},"D_RHMRIF","D-02-05","Yes answered to Hi Field MRI and Open MRI question, provide number of units."]
[0,{"$f":"'Sch D'!AM24","v":"Error"},"D_RMRTF","D-02-06","Yes answered to Megavoltage Rediation Therapy question, provide number of units."]
[0,{"$f":"'Sch D'!AM34","v":"Error"},"D_OLF","D-02-07","Yes answered to Lithotripsy question, provide number of units."]
[0,{"$f":"'Sch D'!AM35","v":"Error"},"D_OBDF","D-02-08","Yes answered to Bond Densitometry question, provide number of units."]
[0,{"$f":"'Sch D'!AM36","v":"Error"},"D_OOF","D-02-09","Yes answered to Other type of equipment question, provide number of units."]
[0,{"$f":"'Sch D'!AO7","v":"Error"},"D_CEEGPAT","D-04-01","Yes was indicated, provide Patients and Procedures data for Electroencephalogram question."]
[0,{"$f":"'Sch D'!AO8","v":"Error"},"D_CEKGPAT","D-04-02","Yes was indicated, provide Patients and Procedures data for Electrocardiogram question."]
[0,{"$f":"'Sch D'!AO9","v":"Error"},"D_CHMPAT","D-04-03","Yes was indicated, provide Patients and Procedures data for Holter Monitoring question."]
[0,{"$f":"'Sch D'!AO10","v":"Error"},"D_CETTPAT","D-04-04","Yes was indicated, provide Patients and Procedures data for Excrcise Tolerance Testing question."]
[0,{"$f":"'Sch D'!AO11","v":"Error"},"D_CCCPAT","D-04-05","Yes was indicated, provide Patients and Procedures data for Cardiac Catheterization question."]
[0,{"$f":"'Sch D'!AO12","v":"Error"},"D_CPTPAT","D-04-06","Yes was indicated, provide Patients and Procedures data for Percutaneous Transiuminal Coronary Angioplasty question."]
[0,{"$f":"'Sch D'!AO14","v":"Error"},"D_RRADPAT","D-04-07","Yes was indicated, provide Patients and Procedures data for type of service Radiography question."]
[0,{"$f":"'Sch D'!AO15","v":"Error"},"D_RUCTPAT","D-04-08","Yes was indicated, provide Patients and Procedures data for type of service Ultrasound question."]
[0,{"$f":"'Sch D'!AO16","v":"Error"},"D_RNMPAT","D-04-09","Yes was indicated, provide Patients and Procedures data for type of service Nuclear medicine question."]
[0,{"$f":"'Sch D'!AO19","v":"Error"},"D_RPETPAT","D-04-10","Yes was indicated, provide Patients and Procedures data for type of equipment Positron Emission Tomography question."]
[0,{"$f":"'Sch D'!AO20","v":"Error"},"D_RCTPAT","D-04-11","Yes was indicated, provide Patients and Procedures data for type of euqipment Computed Tomography question."]
[0,{"$f":"'Sch D'!AO21","v":"Error"},"D_RUCTPAT","D-04-12","Yes was indicated, provide Patients and Procedures data for type of equipment Ultrafast CT question."]
[0,{"$f":"'Sch D'!AO22","v":"Error"},"D_RMRIPAT","D-04-13","Yes was indicated, provide Patients and Procedures data for type of equipment Magnetic Resonance Imaging question."]
[0,{"$f":"'Sch D'!AO23","v":"Error"},"D_RHMRIPAT","D-04-14","Yes was indicated, provide Patients and Procedures data for type of equipment Hi Field MRI and Open MRI question."]
[0,{"$f":"'Sch D'!AO24","v":"Error"},"D_RMRTPAT","D-04-15","Yes was indicated, provide Patients and Procedures data for type of equipment Megavoltage Rediation Therapy question."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch D'!AO25","v":"Error"},"D_RSPPAT","D-04-16","Yes was indicated, provide Patients and Procedures data for type of equipment Stereotactic Procedure question."]
[0,{"$f":"'Sch D'!AO26","v":"Error"},"D_RMAMPAT","D-04-17","Yes was indicated, provide Patients and Procedures data for type of equipment Mammography question."]
[0,{"$f":"'Sch D'!AO28","v":"Error"},"D_OVEPAT","D-04-18","Yes was indicated, provide Patients and Procedures data for other service Vascular Embolzation question."]
[0,{"$f":"'Sch D'!AO29","v":"Error"},"D_OAPAT","D-04-19","Yes was indicated, provide Patients and Procedures data for other service Anesthesia question."]
[0,{"$f":"'Sch D'!AO30","v":"Error"},"D_OACRPAT","D-04-20","Yes was indicated, provide Patients and Procedures data for other service Ultrasound question."]
[0,{"$f":"'Sch D'!AO31","v":"Error"},"D_OCPAT","D-04-21","Yes was indicated, provide Patients and Procedures data for other service Chemotherapy question."]
[0,{"$f":"'Sch D'!AO34","v":"Error"},"D_OLPAT","D-04-22","Yes was indicated, provide Patients and Procedures data for other type of equipment Lithotripsy question."]
[0,{"$f":"'Sch D'!AO35","v":"Error"},"D_OBDPAT","D-04-23","Yes was indicated, provide Patients and Procedures data for other type of equipment Bone Densitometry question."]
[0,{"$f":"'Sch D'!AO36","v":"Error"},"D_OSPPAT","D-04-24","Yes was indicated, provide Patients and Procedures data for other type of other equipment question. "]
[0,{"$f":"'Sch D'!AP40","v":"Error"},"D_ROOM","D-05-25","Provide number of rooms data for diagnostic procedure rooms."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch E'!AL7","v":"Ok"},"E_17M","E-01-01","Patients by race and gender not equal for age 17 or younger."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch E'!AL8","v":"OK"},"E_64M","E-01-02","Patients by race and gender not equal for age 18-64."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch E'!AL9","v":"Ok"},"E_84M","E-01-03","Patients by race and gender not equal for age 65-84."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch E'!AL10","v":"Ok"},"E_85M","E-01-04","Patients by race and gender not equal for age 85 or older."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch E'!AL53","v":"Ok"},"E_17M","E-01-05","Cross Check - Number of patients served by Age, Gender, & Race With Number of patients served by Patient Origin"]
[0,{"$f":"'Sch F'!AL5","v":"Error"},"F_EPAY","F-01-01","Provide exprese data for Payroll."]
[0,{"$f":"'Sch F'!AL6","v":"Error"},"F_EFB","F-01-02","Provide expense data for Fring Benefits."]
[0,{"$f":"'Sch F'!AL7","v":"Error"},"F_EOOE","F-01-03","Provide expense data for Other Operating expenses."]
[0,{"$f":"'Sch F'!AL8","v":"Error"},"F_EDE","F-01-04","Provide expense data for Depreciation Expense."]
[0,{"$f":"'Sch F'!AL9","v":"Error"},"F_ENOE","F-01-05","Provide expense data for Non-Operating Expenses."]
[0,{"$f":"'Sch F'!AL13","v":"Error"},"F_RGMGPC","F-01-06","Provide Gross Patient Charges data for Medicare."]
[0,{"$f":"'Sch F'!AL14","v":"Error"},"f_rgtcgpc","F-01-07","Provide Gross Patient Charges data for TennCare"]
[0,{"$f":"'Sch F'!AL15","v":"Error"},"F_RGOGGPC","F-01-08","Provide Gross Patient Charges data for Other Government."]
[0,{"$f":"'Sch F'!AL17","v":"Error"},"F_RNGSPGPC","F-01-09","Provide Gross Patient Charges data for Self-Pay."]
[0,{"$f":"'Sch F'!AL18","v":"Error"},"F_RNGIGPC","F-01-10","Provide Gross Patient Charges data for Insurance."]
[0,{"$f":"'Sch F'!AL19","v":"Error"},"F_RNGNGGPC","F-01-11","Provide Gross Patient Charges data for Other Non-Government."]
[0,{"$f":"'Sch F'!AL22","v":"Ok"},"F_ANPR","F-01-12","Provide data for All-Non-Patient revenue."]
[0,{"$f":"'Sch F'!AM13","v":"Error"},"F_RGMAC","F-02-01","Provide Adjustment to Charges data for Medicare."]
[0,{"$f":"'Sch F'!AM14","v":"Error"},"F_RGTCAC","F-02-02","Provide Adjustment to Charges data for TennCare"]
[0,{"$f":"'Sch F'!AM15","v":"Error"},"F_RGOGAC","F-02-03","Provide Adjustment to Charges data for Other Government."]
[0,{"$f":"'Sch F'!AM17","v":"Ok"},"F_RNGSPAC","F-02-04","Provide Adjustment to Charges data for Self-Pay."]
[0,{"$f":"'Sch F'!AM18","v":"Ok"},"F_RNGIAC","F-02-05","Provide Adjustment to Charges data for Insurance."]
[0,{"$f":"'Sch F'!AM19","v":"Ok"},"F_RNGNGAC","F-02-06","Provide Adjustment to Charges data for Other Non-Government."]
[0,{"$f":"'Sch F'!AM24","v":"Error"},"F_NGBD","F-02-07","Provide data for Bad-Debt."]
[0,{"$f":"'Sch F'!AM25","v":"Error"},"F_NGCC","F-02-08","Provide data for Charity Care."]
[0,{"$f":"'Sch F'!AM26","v":"Ok"},"F_NGOTR","F-02-09","Provide data for Other Non-Government adjustments to charges."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch G'!AL45","v":"Ok"},"GCYN","G-01-01","Answer Yes or No to the use of contract nursing personnel.",""]
[0,{"$f":"'Sch G'!AL49","v":"Ok"},"GCYN","G-01-02","Yes was indicated for use of contract nurisng, provide additional details.",""]
[{"$f":"A_StateID","v":0},{"$f":"'Sch H'!AL12","v":"Ok"},"HO1S","H-01-01","Other Medical Staff 1 indicated, provide additional data."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch H'!AL13","v":"Ok"},"HO2S","H-01-02","Other Medical Staff 2 indicated, provide additional data.",""]
[0,{"$f":"'Adm Dec'!AL6","v":"Error"},"AD_AdmDec","Adm Dec-01-01","Administrator's Declaration was left blank; check the box.",""]
[0,{"$f":"'Adm Dec'!AM7","v":"Error"},"AD_AdmDecDate","Adm Dec-02-01","Administrator's Declaration date was left blank, provide date completed.",""]

{"sheet":"TIPS _ODC 2020","index":22,"n_rows":128,"n_cols":2,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://www.tn.gov/content"]

{"sheet":"Adm","index":23,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,1,2]]}
["Facility ID Info",null,null,"Administrator's Declaration"]
[]
["State ID","Facility\nName","County","Yes/No","Date"]
[{"$f":"A_StateID","v":0},{"$f":"A_Name","v":"-"},{"$f":"A_County","v":"-"},{"$f":"AD_AdmDec","v":"-"},{"$f":"AD_AdmDecDate","v":"00:00:00"}]