{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Template","Instructions","Descriptions"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":58,"comments":1,"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":"Template","index":0,"n_rows":66,"n_cols":27,"rows_kept":66,"cut":false,"hidden":false,"merged":[[8,8,8,11],[0,0,0,1],[9,3,9,5],[10,7,14,7],[10,1,14,1],[0,4,0,5],[10,11,10,12],[14,8,14,9],[10,3,21,5],[18,8,18,9],[20,8,20,9],[12,10,27,16],[22,8,22,9]]}
["Add Facility",null,"Add Multiple Facilities","Set PY","Remove Facility"]
["ASC_PROVIDER_NPI","ASC_PYR","ASC_1_NUMERATOR","ASC_1_DENOMINATOR","ASC_2_NUMERATOR","ASC_2_DENOMINATOR","ASC_3_NUMERATOR","ASC_3_DENOMINATOR","ASC_4_NUMERATOR","ASC_4_DENOMINATOR","ASC_9_POP_SIZE","ASC_9_SAMP_SIZE","ASC_9_SAMP_FREQ","ASC_9_NUMERATOR","ASC_9_DENOMINATOR","ASC_11_POP_SIZE","ASC_11_SAMP_SIZE","ASC_11_SAMP_FREQ","ASC_11_NUMERATOR","ASC_11_DENOMINATOR","ASC_13_POP_SIZE","ASC_13_SAMP_SIZE","ASC_13_SAMP_FREQ","ASC_13_NUMERATOR","ASC_13_DENOMINATOR","ASC_14_NUMERATOR","ASC_14_DENOMINATOR"]
[9999999990,2027]
[9999999991,2027]
[9999999992,2027]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Interactive Tools (Clickable Options):"]
[null,"Required:",null,"Description:",null,null,null,"Example:"]
[null,null,null,"Click a Header to learn more",null,null,null,null,null,"Quick Check",null,"Create CSV File"]
[]
[null,null,null,null,null,null,null,null,"NPI Length:"]
[]
[null,null,null,null,null,null,null,null,"Required Fields:"]
[]
[null,null,null,null,null,null,null,null,"Num/Denom Size:"]
[]
[null,null,null,null,null,null,null,null,"Pop/Samp Size:"]
[]
[null,null,null,null,null,null,null,null,"Payment Year:"]
[]
[null,null,null,null,null,null,null,null,"Equal Denominator:"]
[]
[]
["ASC_PROVIDER_NPI","10*","Numeric","Y","1234567890","National Provider ID (NPI)"]
["ASC_PYR",4,"Numeric","Y",2016,"Payment Year"]
["ASC_SURGERY_CHECKLIST",1,"Numeric","Y","2","Did you facility use a safe surgery checklist based on accepted standards of practice during the designated period?\nValid Values\n1=Yes\n2=No\n"]
["ASC_7_EYE","9","Numeric","Y","25","Eye Count\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_7_GASTROINTESTINAL","9","Numeric","Y",200,"Gastrointestinal Count\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_7_GENITOURINARY","9","Numeric","Y",36,"Genitourinary Count\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_7_MUSCULOSKELETAL","9","Numeric","Y",298,"Musculoskeletal Count\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_7_NERVOUS","9","Numeric","Y",540,"Nervous Count \nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_7_RESPIRATORY","9","Numeric","Y",1000,"Respiratory Count\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_7_SKIN","9","Numeric","Y",420,"Skin Count\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_7_MULTI_SYSTEM","9","Numeric","Y",918,"Multi-System Count\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_9_POP_SIZE","9","Numeric","N",300,"What was your hospital's Total Population?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_9_SAMP_SIZE","9","Numeric","N",300,"What was your hospital's sample size?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n\n"]
["ASC_9_SAMP_FREQ",1,"Numeric","N",4,"What was your hospital's sampling frequency?\nValid Values\n1=Monthly\n2=Quarterly\n3=Not Sampled\n4=N/A - Submission not required"]
["ASC_9_NUMERATOR","9","Numeric","Y","25","Patients who have a recommended follow-up interval of at least 10 years for repeat colonoscopy documented in their colonoscopy  report.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_9_DENOMINATOR","9","Numeric","Y","50","All patients aged 50 years and older receiving screening colonoscopy without biopsy or polypectomy\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n\n"]
["ASC_10_POP_SIZE","9","Numeric","N",600,"Your hospital's Total Population?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_10_SAMP_SIZE","9","Numeric","N",250,"What was your hospital's sample size?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n\n"]
["ASC_10_SAMP_FREQ",1,"Numeric","N",1,"What was your hospital's frequency?\nValid Values:\n1=Monthly \n2=Quarterly\n3=Not Sampled\n4= N/A - Submission not required"]
["ASC_10_NUMERATOR","9","Numeric","Y",12,"Patients who had an interval of 3 or more years since their last  colonoscopy. \nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_10_DENOMINATOR","9","Numeric","Y",200,"All patients 18 years and older receiving a surveillance colonoscopy with a diagnosis for history of colonic polyp(s)\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_11_POP_SIZE","9","Numeric","N",1000,"What was your hospital's Total Population?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_11_SAMP_SIZE","9","Numeric","N",300,"What was your hospital's sample size?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_11_SAMP_FREQ","1","Numeric","N",1,"What was your hospital's sampling frequency?\nValid Values:\n1=Monthly \n2=Quarterly\n3=Not Sampled\n4=N/A - Submission not required"]
["ASC_11_NUMERATOR","9","Numeric","N",25,"Patients who had an improvement in visual function achieved within 90 days following cataract surgery, based on completing both a pre-operative and post-operative visual function instrument.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_11_DENOMINATOR","9","Numeric","N",36,"All patients 18 years and older who had cataract surgery and completed both a pre-operative and post-operative visual function instrument.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_13_POP_SIZE","9","Numeric","N",1000,"What was your hospital's Total Population?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_13_SAMP_SIZE","9","Numeric","N",300,"What was your hospital's sample size?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_13_SAMP_FREQ","1","Numeric","N",1,"What was your hospital's sampling frequency?\nValid Values:\n1=Monthly \n2=Quarterly\n3=Not Sampled\n4=N/A - Submission not required"]
["ASC_13_NUMERATOR","9","Numeric","Y",25,"Patients who had an improvement in visual function achieved within 90 days following cataract surgery, based on completing both a pre-operative and post-operative visual function instrument.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_13_DENOMINATOR","9","Numeric","Y",36,"All patients 18 years and older who had cataract surgery and completed both a pre-operative and post-operative visual function instrument.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_14_NUMERATOR","9","Numeric","Y",25,"Patients who had an improvement in visual function achieved within 90 days following cataract surgery, based on completing both a pre-operative and post-operative visual function instrument.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC_14_DENOMINATOR","9","Numeric","Y",36,"All patients 18 years and older who had cataract surgery and completed both a pre-operative and post-operative visual function instrument.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_1_NUMERATOR","9","Numeric","Y","0","ASC admissions experiencing a burn prior to discharge.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_1_DENOMINATOR","9","Numeric","Y","280","All ASC admissions.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_2_NUMERATOR","9","Numeric","Y","1","ASC admissions experiencing a fall within the confines of the ASC.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_2_DENOMINATOR","9","Numeric","Y","280","All ASC admissions.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_3_NUMERATOR","9","Numeric","Y","0","All ASC admissions experiencing a wrong site, wrong side, wrong patient, wrong procedure, or wrong implant.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_3_DENOMINATOR","9","Numeric","Y","280","All ASC admissions.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_4_NUMERATOR","9","Numeric","Y","2","ASC admissions requiring a hospital transfer or hospital admission upon discharge from the ASC.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC_4_DENOMINATOR","9","Numeric","Y","280","All ASC admissions.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]

{"sheet":"Instructions","index":1,"n_rows":53,"n_cols":21,"rows_kept":53,"cut":false,"hidden":false,"merged":[[5,20,18,21],[4,6,4,7],[60,0,60,8],[0,0,1,8],[4,0,5,5],[34,1,34,7],[46,9,46,16],[48,9,48,16],[50,9,50,16],[52,9,52,16],[3,9,3,12],[18,10,18,18],[16,10,17,18],[15,10,15,19],[22,0,22,8]]}
["How To: Using the ASCQR Web-Based Measure Submission Worksheet"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Using the Interactive Worksheet"]
["This worksheet was designed to allow you to examine the structure of the submission file and build your own csv for submission.",null,null,null,null,null,"**Enable Content for this document to function**"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scroll Down for More\n"]
[]
["Exploring the file structure"]
["By clicking once on a header cell, you will bring up key information about the field. "]
["This information includes:"]
["·         If the field is required"]
["·         The possible valid values required for the field ",null,null,null,null,null,null,null,null,null,"Begin by entering data and National Provider Identifiers (NPIs) for as many facilities as necessary. "]
["·         An example of a valid value",null,null,null,null,null,null,null,null,null,"Next, enter the appropriate values for each NPI and fill in the desired fields starting with ASC_9_POP_SIZE. "]
[null,null,null,null,null,null,null,null,null,null,"It is not mandatory to enter data for ASC_PYR at this time; rather, you may click the \"Set PY\" button at the top."]
[]
[null,null,null,null,null,null,null,null,null,null,"To set the payment year to 2023 for all the facilities at the same time, select \"Set PY.\"    \nThe default value will be PY 2023 (The encounter occurs in 2021, will be reported in 2022, and used for payment determination in 2023)\n"]
[null,null,null,null,null,null,null,null,null,null,"To input information for more than two ASCs, click \"Add Facility\" at the top of the table. This will automatically add a row to the bottom of the table.\nTo add multiple facilities at once, click \"Add Multiple Facilities\" and enter the number of additional facilities you would like to include.\nDo not insert a row on your own; this will cause an error function within the worksheet."]
[]
[null,null,null,null,null,null,null,null,null,null,"To remove a facility, click \"Remove Facility\" at the top of the table. Then follow the on-screen prompt to specify the worksheet row number you would like to remove. \nYou may choose to delete the row yourself by right-clicking the desired row number; however, the default option will remove the last row in the worksheet.\n"]
["Using Quick Check",null,null,null,null,null,null,null,null,"Quick Check Screen"]
[]
[]
["The Quick Check feature allows you to review the worksheet you have created. This feature will highlight five primary areas of concern that cause errors in QualityNet's External File Online Tool."]
["Quick Check will verify that:"]
[null,"All NPIs are exactly 10 digits in length."]
[null,"All Required Fields have valid values."]
[null,"All Numerators and Denominators have logical values."]
[null,"All Population and Sample Size values are logical based on the Sampling Frequency indicated."]
["                All Payment Year values have been entered."]
["If there is an error, Quick Check will:"]
[null,"Highlight any incorrect or missing values in Red"]
[null,"Produce a descriptive error code for that error"]
[null,"If you see five Green Boxes with text stating \"Pass,\" you are good to go! "]
[]
[null,"If you receive one or more red boxes, fix the issue that is indicated, and then click \"Re-Test.\" You will then clear the formatting and error codes to locate additional errors that require attention.\nIf you encounter an error code and need assistance troubleshooting, send an email to oqrsupport@hsag.com with the subject line \"ASC WBM Submission Tool.\"\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quick Check Results Screen",null,null,null,null,null,null,null,null,"Creating a CSV File"]
[]
[null,null,null,null,null,null,null,null,null,"Once you have used \"Quick Check\", you can click \"Create CSV File\". This copies the entire table and pastes it into a new spreadsheet saved as a CSV file for you."]
[]
[null,null,null,null,null,null,null,null,null,"Do not change the file name. This file name is generated automatically and ensures that you do not fail the Secure File Submission (SFS) Tool validation check for file naming convention."]
[]
[null,null,null,null,null,null,null,null,null,"The file is saved in the same directory location where your worksheet has been saved, i.e., desktop, documents, downloads."]
[]
[null,null,null,null,null,null,null,null,null,"The resulting file is ready for upload to SFS in HQR.\nClick here to go to QualityNet."]

{"sheet":"Descriptions","index":2,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["ASC Web-Based Measures"]
["File Name: ASC_WBM_PY20YY_mm_dd_yyyy.csv"]
[]
[]
["Logical Field Name","Physical Field Name","Max Field Length","Type","Required Data?","Example","Description"]
["Provider ID ","ASC_PROVIDER_NPI","10*","Numeric","Y","1234567890","National Provider ID (NPI) *Must be exactly 10 Digits Long"]
["Payment Year","ASC_PYR",4,"Numeric","Y",2016,"Payment Year"]
["ASC-6: Safe Surgery Checklist","ASC_SURGERY_CHECKLIST",1,"Numeric","Y","1","Discontinued Measure, Enter 1\nValid Values\n1=Yes\n2=No\n"]
["ASC-7: Eye Aggregate Count","ASC_7_EYE","9","Numeric","Y","0","Discontinued Measure Enter 0\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-7: Gastrointestinal Aggregate Count","ASC_7_GASTROINTESTINAL","9","Numeric","Y","0","Discontinued Measure Enter 0\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-7: Genitourinary Aggregate Count","ASC_7_GENITOURINARY","9","Numeric","Y","0","Discontinued Measure Enter 0\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-7: Musculoskeletal Aggregate Count","ASC_7_MUSCULOSKELETAL","9","Numeric","Y","0","Discontinued Measure Enter 0\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-7: Nervous Aggregate Count","ASC_7_NERVOUS","9","Numeric","Y","0","Discontinued Measure Enter 0\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-7: Respiratory Aggregate Count","ASC_7_RESPIRATORY","9","Numeric","Y","0","Discontinued Measure Enter 0\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-7: Skin Aggregate Count","ASC_7_SKIN","9","Numeric","Y","0","Discontinued Measure Enter 0\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-7: Multi-System Aggregate Count","ASC_7_MULTI_SYSTEM","9","Numeric","Y","0","Discontinued Measure Enter 0\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-9: Endoscopy/Polyp Surveillance Population Size","ASC_9_POP_SIZE","9","Numeric","N",300,"What was your hospital's Total Population?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-9: Endoscopy/Polyp Surveillance Sample Size","ASC_9_SAMP_SIZE","9","Numeric","N",300,"What was your hospital's sample size?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n\n"]
["ASC-9: Endoscopy/Polyp Surveillance Sampling Frequency","ASC_9_SAMP_FREQ",1,"Numeric","N",4,"What was your hospital's sampling frequency?\nValid Values\n1=Monthly\n2=Quarterly\n3=Not Sampled\n4=N/A - Submission not required"]
["ASC-9: Endoscopy/Polyp Surveillance Numerator","ASC_9_NUMERATOR","9","Numeric","Y","25","Patients who have a recommended follow-up interval of at least 10 years for repeat colonoscopy documented in their colonoscopy  report.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-9: Endoscopy/Polyp Surveillance Denominator","ASC_9_DENOMINATOR","9","Numeric","Y","50","All patients aged 50 years and older receiving screening colonoscopy without biopsy or polypectomy\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n\n"]
["ASC-10: Colonoscopy Surveillance Population Size","ASC_10_POP_SIZE","9","Numeric","N",600,"Your hospital's Total Population?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC-10: Colonoscopy Surveillance Sample Size","ASC_10_SAMP_SIZE","9","Numeric","N",250,"What was your hospital's sample size?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n\n"]
["ASC-10: Colonoscopy Surveillance Sampling Frequency","ASC_10_SAMP_FREQ",1,"Numeric","N",1,"What was your hospital's frequency?\nValid Values:\n1=Monthly \n2=Quarterly\n3=Not Sampled\n4= N/A - Submission not required"]
["ASC-10: Colonoscopy Surveillance Numerator","ASC_10_NUMERATOR","9","Numeric","Y",12,"Patients who had an interval of 3 or more years since their last  colonoscopy. \nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]
["ASC-10: Colonoscopy Surveillance Denominator","ASC_10_DENOMINATOR","9","Numeric","Y",200,"All patients 18 years and older receiving a surveillance colonoscopy with a diagnosis for history of colonic polyp(s)\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-11: Cataracts Population Size","ASC_11_POP_SIZE","9","Numeric","N",1000,"What was your hospital's Total Population?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-11: Cataracts Sample Size","ASC_11_SAMP_SIZE","9","Numeric","N",300,"What was your hospital's sample size?\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-11: Cataracts Sampling Frequency","ASC_11_SAMP_FREQ","1","Numeric","N",1,"What was your hospital's sampling frequency?\nValid Values:\n1=Monthly \n2=Quarterly\n3=Not Sampled\n4=N/A - Submission not required"]
["ASC-11: Cataracts Numerator","ASC_11_NUMERATOR","9","Numeric","N",25,"Patients who had an improvement in visual function achieved within 90 days following cataract surgery, based on completing both a pre-operative and post-operative visual function instrument.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)"]
["ASC-11: Cataracts Denominator","ASC_11_DENOMINATOR","9","Numeric","N",36,"All patients 18 years and older who had cataract surgery and completed both a pre-operative and post-operative visual function instrument.\nValid Value:\nZero or Positive Whole Number (0,1,2,3,…,999999999)\n"]