{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Table of Contents","Surveyor Instructions","File List - completed by NCQA","File Review Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Table of Contents","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["CM File Review Workbook"]
["Table of Contents"]
[]
[]
["TAB 1:",null,"Surveyor Instructions"]
[]
["TAB 2:",null,"File List - completed by NCQA"]
[]
["TAB 3:",null,"File Review Worksheet"]

{"sheet":"Surveyor Instructions","index":1,"n_rows":173,"n_cols":2,"rows_kept":173,"cut":false,"hidden":false,"merged":[[169,1,169,4],[171,1,171,4],[164,1,164,4],[165,1,165,4],[166,1,166,4],[167,1,167,4],[168,1,168,4],[116,0,116,1],[81,0,81,1],[0,0,0,1],[1,0,1,1],[3,0,3,1],[5,1,6,1],[23,0,23,1],[10,0,10,1],[16,0,16,1],[172,1,172,4],[28,0,28,1],[18,0,18,1],[47,0,47,1],[20,0,20,1],[21,0,21,1],[26,0,26,1],[19,0,19,1],[41,0,41,1],[24,0,24,1],[42,0,42,1],[43,0,43,1],[45,0,45,1],[55,0,55,1],[112,0,112,1],[114,0,114,1]]}
["CM File Review Workbook"]
["Surveyor Instructions"]
[]
["File Review Worksheet Overview"]
[]
["Purpose","The purpose of the attached file review worksheet is to evaluate an organization's documented processes for its Case Management program. The applicable standard/elements are QI 5G (Case-Management Files - Initial Assessment) and QI 5H (Case Management Files - Ongoing Management)."]
[]
[]
[null,"These instructions explain how you review the file review sample, including which elements are applicable to the files selected and how files are scored. Prior to the survey, NCQA works with the organization to identify the files for review. These instructions also describe how the file review samples are identified."]
[]
["Helpful Worksheet Features"]
[]
["1. The worksheets are color-coded as follows:"]
[" Gray or colored cells indicate no surveyor input is required. "]
[" Non-shaded or white cells indicate that surveyor input is required. "]
[]
["2. The worksheets are protected from invalid input. You will be prompted by ERROR  or #VALUE!  messages when invalid entries are made.  "]
[]
["3.  Fill out the worksheet by: (a) choosing one of the valid responses provided in a drop down list in each cell or (b) typing in any one of the valid responses included in a cell's drop down list verbatim.  "]
[" The drop down list for a cell can be accessed by clicking on the downward pointing arrow that appears to the right of the cell when the cell is selected. If no arrow appears when the cell is selected, then no drop down list is available for that cell. "]
[" Please do not copy and paste or cut and paste responses from one cell to another as doing so will overwrite the original validation criteria and formatting for the affected cells.  Please use the cell drop down lists or hard enter the appropriate valid responses, which are delineated below."]
[" To delete the contents of a cell either (a) choose the blank entry from the drop down list of valid responses or (b) use the Backspace or Delete keys. Do not use the space bar to empty the contents of a cell as it is an invalid entry and results in an error message."]
[]
["4. The file review worksheets have been formatted so that the element/factor information and basic file information remains visible as row and column headers as you scroll through the worksheet."]
[" To freeze the row and column headers on these worksheets in a different manner choose Unfreeze Panes under the Window menu at any time. Click the cell below and to the right of where you want the new \"freeze\" to occur. On the \nWindow menu, click Freeze Panes."]
[]
[" 5. The file review worksheet has a yellow hyper-button (labeled \"Instructions\") in the upper left hand corner of the column header that, when clicked on, will take you to these instructions. "]
[]
["File Review Instructions"]
[]
["Selecting files","At the start of the survey, the organization presents the 40 Case Management files identified by NCQA for review. Although you will review a maximum of 30 files for each element/factor, 10 additional files are selected as an oversample in case a file or element/factors within a file are Not Applicable (NA). The files are selected according to the following rules:"]
[]
[" "," The file selection will include cases that are active or closed within the look-back period prior to the survey listed below. The member must be enrolled or have been enrolled in the program at least 60 days. "]
[]
[]
[null,"HPA 2016"]
[null,"For First Surveys: NCQA reviews a random sample of complex case management files selected from cases opened within the 6 months prior to the survey."]
[null,"For Renewal Surveys: NCQA reviews a random sample of complex case management files selected from cases opened within the 12 months prior to the survey."]
[]
[null," The  information contained in columns 2 - 6 of the file review worksheet auto populates.  The organization can select the files by member ID or another systematic method. When selecting files, the organization may query several databases of patient files. A copy of the file review worksheet is sent to the NCQA survey team member performing the file review."]
[]
["Note: If any questions or concerns about this process arise while on site, contact your ASC for clarification."]
["Important Notes About Not Applicable Files and Using the NA Scoring"]
["Not Applicable Files (NA): The file list may inadvertently include a file which is NA - either because it has been active <60 days in the Look-back period or because the organization is not able to contact the member after the required number of attempts in the initial 30 day assessment period. \n\nIf you believe a file is NA, carefully review the requirements in the SGs for confirmation and notify your ASC.\n\nFor a file that is fully Not Applicable, score each factor of both elements Not Applicable (NA) and go on to score the next file. You are required to describe the reason the file is Not Applicable in the comment column of the worksheet. "]
[]
["If a file is applicable/eligible, then all factors of both elements are applicable. Although the worksheet has functionality to score an individual factor NA, by policy, individual factors may not be scored NA in the case management file review worksheet. Use NA only to score an entire file NA.\n\nRationale: For Element G, the element is scoring on the initial assessment of each factor; assessment is always applicable as it is how the organization determines the applicability of each factor for actual case management.  Because all factors are potentially applicable to any case, the case file/record must document assessment. For example, if after assessment, the case manager determines that it is not appropriate or necessary to discuss life planning with the member. The case manager must have made an assessment to reach this conclusion and the case must document the results of the assessment, not simply NA or a null field. A completed assessment is scored Yes. If the case documentation is silent/null, then the factor is scored No and not NA. A verbal explanation by the organization provided during the file review as to why the factor is NA is not sufficient.\n\nSimilarly, for QI 5H, all factors for ongoing management are applicable to all eligible cases.\n\nIf you feel a factor should be NA, you must discuss it with your ASC and receive Policy confirmation before scoring an individual factor NA."]
[]
["Instructions for Completing the File Review Worksheet"]
[]
["Cell C3:","Type in the name of the organization."]
[]
["Cell C4:","Type in your name."]
[]
["Cell C5:","Type in survey date(s) in the format mm/dd/yy .Enter only a single date (the first day of the onsite)"]
[]
["For each file, review each element/factor individually according to the 2016 HPA Standards and Guidelines and the directions provided below.  "]
[]
["Column 1:\n","The numbers in this column correspond to the list of dates for file selection provided by NCQA. If a file (and therefore, the corresponding date) is not usable for the review, make a note in the comment column of the file review worksheet. This allows NCQA to match the list to the file review worksheet."]
[]
["Column 2:","Case ID - This information will be populated by NCQA. "]
[]
["Column 3: ","Case Active or Closed? Type or choose (from the in-cell drop down list):"]
[null," \"Active\" - If the case is active."]
[null," \"Closed\" - If the case is closed."]
[null,"This information will be populated by NCQA. Please verify onsite."]
["Column 4: ","Program - Type in the name of the program associated with the file."]
[null,"This information will be populated by NCQA. Please verify onsite."]
[]
["Column 5: ","Delegate Name, If applicable - Type in the name of the program associated with the file."]
[null,"This information will be populated by NCQA. Please verify onsite. Note that if the delegate is NCQA-Accredited, Autocredit may be applicable."]
[]
["Column 6: ","Date Enrolled - Type the date in the format mm/dd/yy (e.g. 01/01/15)."]
[null,"This information will be populated by NCQA. Please verify onsite."]
["Column 7: ","Date Closed - Type the date in the format mm/dd/yy (e.g. 01/01/15)."]
[]
["Column 8: ","Enrolled at least 60 days - Valid responses include:  "]
[null,"This information is automatically calculated based on cell C5, Columns 3, 6 and 7"]
[]
["Column 9: ","Eligibility Date: Date member meets eligibility criteria established for the program."]
[null,"Type the date in the format mm/dd/yyy (e.g. 01/01/15)"]
[]
["The following columns evaluate each file for the factors required in the initial assessment. To meet a factor, two criteria must be met: \n1) the relevant assessment must have been conducted and \n2) it must be completed within 30 days of the member's eligibility for the program.\n\nIf all factors were completed on the same date. you may enter that date once (see instructions for columns 10 and 11). Otherwise, you must enter a date for each assessment.\n\nThe worksheet will calculate if the date is within 30 days of eligibility and score each factor."]
[]
["Column 10:","Was the initial assessment completed on a single  day?  Valid responses are:"]
[null," \"Yes\" - If the assessments and evaluations for all 9 factors were completed on the same day"]
[null," \"No\" - If the some assessments or evaluations occurred on different days"]
[]
["Column 11:","Date of initial assessment if on one day. If the assessments/evaluations were all completed on a single date, enter that date in the format mm/dd/yy (e.g. 01/01/15)\nNote: this cell will be blacked out if Column 10 has a value of \"No\""]
[]
["Columns 12A-C though 22A-C","These columns are used to score  QI 5G. For each set, the factor is listed. \n\nEach factor is scored based on 1)  the completion of the assessment or evaluation and 2) the date of the assessment/evaluation.\n\nFor each of Column A and Column B, enter data as directed below.\n\nColumn C will calculate the score for the factor."]
[]
["    Column A","Complete?  In this column, document if the assessment/evaluation required by the factor was completed. Valid responses include:  "]
[null," \"Yes\" - If the element/factor is present."]
[null," \"No\" - If the element/factor is not present."]
[null," \"NA\" - If the entire file is not applicable. Please be sure to read \"Important Notes\", above."]
[null," \"AC\" - If the element/factor is eligible for automatic credit."]
[]
["    Column B","Complete Column B for each factor only if assessments/evaluations were completed on more than one day."]
[null,"\nNote: this cell will be blacked out if Column 10 has a value of \"Yes\" indicating all assessments/evaluations were on the same day.\n\nEnter that date in the format mm/dd/yy (e.g. 01/01/10)\n"]
[]
["    Column C","The score for the factor displays here."]
[]
["Columns 23A-B though 27A-B","These columns are used to score  QI 5H, factors 1-5. You enter responses only in Column A.  Valid responses include:  "]
[null," \"Yes\" - If the element/factor is present."]
[null," \"No\" - If the element/factor is not present."]
[null," \"NA\" - If the entire file is not applicable. Please be sure to read \"Important Notes\", above."]
[null," \"AC\" - If the element/factor is eligible for automatic credit."]
[]
[null,"The score for the factor displays in column B."]
[]
["Column 28: ","A column for comments is included in each file review worksheet. The cell will turn yellow when a comment is required. Please briefly explain findings of non-performance or provide the reason(s) why an entire case file has been scored Not Applicable in this  column. "]
[]
["For detailed information on the specific criteria and requirements used to determine compliance for each element, please refer to the Standards and Guidelines."]
[]
["Scoring Files"]
[]
["Scoring Notes, in row 13,  provide a reference to assist you in determining whether additional files need to be reviewed. An explanation of each of the notes is provided below the scoring section of the worksheet."]
[]
["Step 1"]
["DENOM <8:","Evaluate the first 8 files for all elements/factors from the list provided by NCQA. Files must be reviewed in the order they appear on the list provided by NCQA. "]
[]
["STOP","For any element that the organization demonstrates compliance (Yes in the Compliance row) for each of the first 8 files, indicated by an 8/8 Compliance Ratio, stop reviewing files for that element/factor and enter a score of HIGH in the Survey Tool. You may leave the rest of the files/worksheet blank for that element."]
[]
["RATIO <8/8:","If, because of NA files, you have not scored at least 8 applicable files for an element/factor within the first 8 files on the list (e.g. you may have a Compliance Ratio of 7/7 6/6, 6/7, etc.), review additional files until you have reviewed at least 8 applicable files for the element/factor. "]
[]
["STOP","When you have reviewed at least 8 applicable files for the element/factor, if the organization demonstrates a Compliance Ratio of 8/8, stop reviewing files for that element/factor and enter a score of HIGH in the Survey Tool. You may leave the rest of the files/worksheet blank for that element/factor."]
[]
["Review files:","For any element/factor in which the organization scores a Compliance Ratio less than 8/8, continue to review files (including those in the oversample) for the element/factor until you have a denominator of 30 applicable files or you have exhausted the oversample."]
[]
[null,"Since some files may be NA for an element/factor, you will need to continue to review files (including those in the oversample) for the element/factor until you have a denominator of 30 applicable files or you have exhausted the oversample. In some cases, surveyors may have fewer than 30 applicable files to review for some elements/factors, even after a review of the entire oversample. In this case, there will be fewer than 30 files in the final denominator. A denominator of less than 30 is only appropriate if the oversample is exhausted. "]
[]
["COMPLETE(30)","Once you have reviewed 30 applicable files, stop and enter the resulting score in the Survey Tool. You may leave the rest of the files/worksheet blank for that element/factor."]
[null,"or"]
["COMPLETE(40)","Once you have exhausted the oversample, stop and enter the resulting score in the Survey Tool. "]
[]
["The following Summary Statistics are automatically calculated at the bottom of the worksheet: "]
[null," Files Compliant: A count of the files scored Yes in the Compliance fields above."]
[null," Files Not Compliant: A count of the files scored No in the Compliance fields above."]
[null," Files Not Applicable: A count of the files scored NA in the Compliance fields above. "]
[null," Total Files Reviewed: A count of the files scored as Yes, No and NA in the Compliance fields above."]
[]
["In addition, the following Scoring information is also calculated at the bottom of the worksheet: "]
[null," Compliance Ratio: The count of the Files Compliant (Yes) over the count of the Total Applicable Files (Yes + No)."]
[null," Percentage Compliant: The Compliance Ratio (defined above) displayed as a percentage."]
[null," Score: High, Medium or Low is returned based on the files reviewed as follows: "]
[null," If the Files Compliant is 27–30 for an element/factor, or 90 - 100%, the score is HIGH for that element/factor"]
[null," If the Files Compliant is 18–26 for an element/factor, or 60–89%, the score is MEDIUM for that element/factor"]
[null," If the Files Compliant is 0–17, or 0 - 59%, the score is LOW for that element/factor."]
[null," An X in the Score field indicates that no Score is available - please see the Scoring Notes for an explanation of how to proceed with the file review to achieve a Score."]
[null," An \"ERROR\" message appears in the \"Scoring Notes\" and \"Score\" fields for an element/factor/factor if a response for one or more of the files is not consistent with the response rules provided herein. An \"ERROR\" message will also appear in the Compliance field of the affected file."]
["Step 2"]
[null,"After completing the file review for all element/factors, confirm all findings with the  appropriate organization staff. If an element/factor is not present, you must allow the organization staff the opportunity to locate it for you."]
[]
[null,"Sign your name and document the name of the organization's staff member with whom you reviewed the results in the space provided at the very bottom of the worksheet. Do not ask organization staff to sign the worksheet.  "]
[null,"The surveyor completing the file review should save their workbook as CM File Review Results.xls "]
["Step 3"]
[null,"The score for each element/factor must be entered into the Interactive Reivew Tool as follows.  "]
[]
[null,"1. Log into the Interactive Review Tool."]
[]
[null,"2. Score each file review factor/element (QI 5G and QI 5H) by clicking the appropriate scoring radio buttons (High, Medium, or Low) based on the score information at the bottom of the CM worksheet.  "]
[null," CM File review results are recorded in QI 5G and QI 5H."]
["Step 4"]
[null,"Attach the \"CM File Review Results.xls\" file to the Interactive Review Tool by:                                                          "]
[null,"1.   Attach the worksheet to the \"Manage Workbook\" section located at the top of the navigation in IRT. You can also access this section under the Actions button."]
[null,"2.  Use the browse function (Choose File) to locate the Worksheet"]
[null,"3.  A path file box will open up, go to where your Worksheet is saved and select your file."]
[null,"4.  Select \"Open\" "]
[null,"5.  Be sure that the file name is \"CM results\""]
[null,"6.  Click save."]
[]
[]
[null,"To confirm: your e-mail for IRT should be listed under the last uploaded column and the file name is listed after the \"Choose File\" button."]

{"sheet":"File List - completed by NCQA","index":2,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,0,2,1],[1,0,1,1],[0,0,0,1],[3,0,3,1]]}
["Organization:"]
["Onsite Date:"]
["Accred Code:"]
[]
[]
[null,"Case ID","Case Active or Closed","Program","Delegate Name, If Applicable","Date Enrolled"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]

{"sheet":"File Review Worksheet","index":3,"n_rows":84,"n_cols":88,"rows_kept":84,"cut":false,"hidden":false,"merged":[[10,74,10,75],[9,11,9,65],[10,61,10,65],[10,66,10,67],[10,68,10,69],[10,70,10,71],[10,72,10,73],[10,26,10,30],[10,41,10,45],[10,46,10,50],[10,51,10,55],[10,56,10,60],[9,66,9,75],[10,31,10,35],[10,36,10,40],[5,2,5,7],[10,11,10,15],[10,16,10,20],[10,21,10,25],[9,4,13,4],[5,10,5,21],[6,10,6,21],[9,6,13,6],[9,7,13,7],[9,8,13,8],[9,9,13,9],[9,10,13,10],[13,11,13,15],[13,16,13,20],[13,21,13,25],[70,0,70,74],[71,0,71,74],[73,5,73,16],[75,5,75,16],[65,0,65,74],[66,0,66,74],[67,0,67,74],[68,0,68,74],[69,0,69,74],[13,26,13,30],[13,31,13,35],[13,36,13,40],[13,41,13,45],[13,46,13,50],[9,76,12,76],[11,11,11,15],[11,16,11,20],[11,21,11,25],[11,26,11,30],[11,31,11,35],[11,36,11,40],[11,41,11,45],[11,46,11,50],[11,51,11,55],[11,66,11,67],[11,68,11,69],[11,70,11,71],[11,72,11,73],[11,74,11,75],[11,56,11,60],[9,0,13,0],[9,1,13,1],[9,2,13,2],[9,3,13,3],[9,5,13,5],[1,2,2,7],[2,9,2,21],[3,2,3,7],[3,10,3,21],[4,2,4,7],[4,10,4,21],[11,61,11,65],[13,61,13,65],[13,74,13,75],[13,51,13,55],[13,66,13,67],[13,68,13,69],[13,70,13,71],[13,72,13,73],[13,56,13,60]]}
["CM File Review Worksheet"]
[]
["Organization Name:",null,null,null,null,null,null,null,null,"Response Key"]
["Surveyor Name",null,null,null,null,null,null,null,null,"Yes =","Evidence of element present (as defined)"]
["Date:",null,null,null,null,null,null,null,null,"No = ","Evidence of element not present "]
[null,null,"Case Management Accreditation",null,null,null,null,null,null,"NA =","File does not meet sample criteria. Use when file is NA; individual factors may not be NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health Plan Accreditation"]
[null,null,null,null,null,null,null,null,null,"AC =","File is managed by NCQA Accredited or Certified Delegate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case Management Accreditation"]
["CONFIRM ALL FINDINGS WITH THE APPROPRIATE STAFF"]
[1,2,3,4,5,6,7,8,9,10,11,"12A","12B",null,null,"12C","13A","13B",null,null,"13C","14A","14B",null,null,"14C","15A","15B",null,null,"15C","16A","16B",null,null,"16C","17A","17B",null,null,"17C",{"$f":"IF(C6 = \"Case Management Accreditation\",\"18A\",\"16A\")","v":"18A"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"18B\",\"16B\")","v":"18B"},null,null,{"$f":"IF(C6 = \"Case Management Accreditation\",\"18C\",\"16C\")","v":"18C"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"19A\",\"17A\")","v":"19A"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"19B\",\"17B\")","v":"19B"},null,null,{"$f":"IF(C6 = \"Case Management Accreditation\",\"19C\",\"17C\")","v":"19C"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"20A\",\"18A\")","v":"20A"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"20C\",\"18B\")","v":"20C"},"21A","21B",{"$f":"IF(C6 = \"Case Management Accreditation\",\"20C\",\"18C\")","v":"20C"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"21A\",\"19A\")","v":"21A"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"21B\",\"19B\")","v":"21B"},"21A","21B",{"$f":"IF(C6 = \"Case Management Accreditation\",\"21C\",\"19C\")","v":"21C"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"22A\",\"20A\")","v":"22A"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"22B\",\"20B\")","v":"22B"},"21A","21B",{"$f":"IF(C6 = \"Case Management Accreditation\",\"22C\",\"20C\")","v":"22C"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"23A\",\"21A\")","v":"23A"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"23B\",\"21B\")","v":"23B"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"24A\",\"22A\")","v":"24A"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"24B\",\"22B\")","v":"24B"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"25A\",\"23A\")","v":"25A"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"25B\",\"23B\")","v":"25B"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"26A\",\"24A\")","v":"26A"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"26B\",\"24B\")","v":"26B"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"27A\",\"25A\")","v":"27A"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"27B\",\"25B\")","v":"27B"},{"$f":"IF(C6 = \"Case Management Accreditation\",\"28\",\"26\")","v":"28"}]
[null,"Case ID","Case \nActive\n or \nClosed?","Program","Delegate, if applicable","Date Enrolled","Date Closed","Enrolled at least 60 days","Date member met eligibility criteria established for program)","Initial Assessment all completed on a single date? (Yes/No)","If Initial Assessment was completed on a single date, enter date below","QI 5G Initial Assessment or Evaluatioon (as factor reads) of:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QI 5H - Ongoing Management",null,null,null,null,null,null,null,null,null,"COMMENT REQUIRED FOR ANY NA OR NO, INDICATED BY COMMENT CELL TURNING YELLOW\n\nNOTE: In general, NA is used only to when a whole file is NA. NA is not allowed for any individual factor; please check with NCQA and receive policy comfirmation before scoring any factor NA"]
[null,null,null,null,null,null,null,null,null,null,null," Factor 1:",null,null,null,null," Factor 2:",null,null,null,null," Factor 3: ",null,null,null,null," Factor 4: ",null,null,null,null,"Factor 5:",null,null,null,null,"Factor 6: ",null,null,null,null,{"$f":"IF(C6 = \"Case Management Accreditation\",\"Factor 7:\",\"Factor 5:\")","v":"Factor 7:"},null,null,null,null,{"$f":"IF(C6 = \"Case Management Accreditation\",\"Factor 8:\",\"Factor 6:\")","v":"Factor 8:"},null,null,null,null,{"$f":"IF(C6 = \"Case Management Accreditation\",\"Factor 9:\",\"Factor 7:\")","v":"Factor 9:"},null,null,null,null,{"$f":"IF(C6 = \"Case Management Accreditation\",\"Factor 10:\",\"Factor 8:\")","v":"Factor 10:"},null,null,null,null,{"$f":"IF(C6 = \"Case Management Accreditation\",\"Factor 11:\",\"Factor 9:\")","v":"Factor 11:"},null,null,null,null," Factor 1: ",null,"Factor 2: ",null," Factor 3: ",null," Factor 4:",null," Factor 5:"]
[null,null,null,null,null,null,null,null,null,null,null," Initial assessment of member health status, including condition-specific issues",null,null,null,null," Documentation of clinical history, including medications ",null,null,null,null,"Initial assessment of the activities of daily living ",null,null,null,null,"Initial assessment of mental health status, including cognitive functions ",null,null,null,null,"Initial assessment of psychosocial issues ",null,null,null,null,"Evaluation of cultural and linguistic needs, preferences or limitations. ",null,null,null,null,"Evaluation of visual and hearing needs, preferences or limitations. ",null,null,null,null,"Evaluation of caregiver resources and involvement. ",null,null,null,null,"Evaluation of available benefits.",null,null,null,null," Evaluation of available benefits from the organization & community resources",null,null,null,null,"Assessment of life-planning activities.",null,null,null,null,"Development of case management plans, including prioritized goals",null," Identification of barriers to meeting goals and complying with the plans",null,"Development of schedules for follow-up and communication with members ",null," Development and communication of member self-management plans",null,"Assessment of progress against CCM plans and goals, and modification as needed"]
[null,null,null,null,null,null,null,null,null,null,null,"Complete","Date Complete (if not 1 day)",null,null,"Factor Met?","Complete","Date Complete (if not 1 day)",null,null,"Factor Met?","Complete","Date Complete (if not 1 day)",null,null,"Factor Met?","Complete","Date Complete (if not 1 day)",null,null,"Factor Met?","Complete","Date Complete (if not 1 day)",null,null,"Factor Met?","Complete","Date Complete (if not 1 day)",null,null,"Factor Met?","Complete","Date Complete (if not 1 day)",null,null,"Factor Met?","Complete","Date Complete (if not 1 day)",null,null,"Factor Met?","Complete","Date Complete (if not 1 day)",null,null,"Factor Met?","Complete","Date Complete (if not 1 day)",null,null,"Factor Met?","Complete","Date Complete (if not 1 day)",null,null,"Factor Met?","Complete","Factor Met","Complete","Factor Met","Complete","Factor Met","Complete","Factor Met","Complete","Factor Met"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(P56=8,P60=8),\"STOP\",IF(P60>=30,\"COMPLETE(30)\",IF(P59>=40,\"COMPLETE(40)\",IF(P60<8,\"DENOM <8\",IF(AND(P60=8,P56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,null,null,null,{"$f":"IF(AND(U56=8,U60=8),\"STOP\",IF(U60>=30,\"COMPLETE(30)\",IF(U59>=40,\"COMPLETE(40)\",IF(U60<8,\"DENOM <8\",IF(AND(U60=8,U56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,null,null,null,{"$f":"IF(AND(Z56=8,Z60=8),\"STOP\",IF(Z60>=30,\"COMPLETE(30)\",IF(Z59>=40,\"COMPLETE(40)\",IF(Z60<8,\"DENOM <8\",IF(AND(Z60=8,Z56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,null,null,null,{"$f":"IF(AND(AE56=8,AE60=8),\"STOP\",IF(AE60>=30,\"COMPLETE(30)\",IF(AE59>=40,\"COMPLETE(40)\",IF(AE60<8,\"DENOM <8\",IF(AND(AE60=8,AE56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,null,null,null,{"$f":"IF(AND(AJ56=8,AJ60=8),\"STOP\",IF(AJ60>=30,\"COMPLETE(30)\",IF(AJ59>=40,\"COMPLETE(40)\",IF(AJ60<8,\"DENOM <8\",IF(AND(AJ60=8,AJ56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,null,null,null,{"$f":"IF(AND(AO56=8,AO60=8),\"STOP\",IF(AO60>=30,\"COMPLETE(30)\",IF(AO59>=40,\"COMPLETE(40)\",IF(AO60<8,\"DENOM <8\",IF(AND(AO60=8,AO56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,null,null,null,{"$f":"IF(AND(AT56=8,AT60=8),\"STOP\",IF(AT60>=30,\"COMPLETE(30)\",IF(AT59>=40,\"COMPLETE(40)\",IF(AT60<8,\"DENOM <8\",IF(AND(AT60=8,AT56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,null,null,null,{"$f":"IF(AND(AY56=8,AY60=8),\"STOP\",IF(AY60>=30,\"COMPLETE(30)\",IF(AY59>=40,\"COMPLETE(40)\",IF(AY60<8,\"DENOM <8\",IF(AND(AY60=8,AY56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,null,null,null,{"$f":"IF(AND(BD56=8,BD60=8),\"STOP\",IF(BD60>=30,\"COMPLETE(30)\",IF(BD59>=40,\"COMPLETE(40)\",IF(BD60<8,\"DENOM <8\",IF(AND(BD60=8,BD56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,null,null,null,{"$f":"IF(AND(BI56=8,BI60=8),\"STOP\",IF(BI60>=30,\"COMPLETE(30)\",IF(BI59>=40,\"COMPLETE(40)\",IF(BI60<8,\"DENOM <8\",IF(AND(BI60=8,BI56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,null,null,null,{"$f":"IF(AND(BN56=8,BN60=8),\"STOP\",IF(BN60>=30,\"COMPLETE(30)\",IF(BN59>=40,\"COMPLETE(40)\",IF(BN60<8,\"DENOM <8\",IF(AND(BN60=8,BN56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,null,null,null,{"$f":"IF(AND(BP56=8,BP60=8),\"STOP\",IF(BP60=30,\"COMPLETE(30)\",IF(BP59>=40,\"COMPLETE(40)\",IF(BP60<8,\"DENOM <8\",IF(AND(BP60=8,BP56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,{"$f":"IF(AND(BR56=8,BR60=8),\"STOP\",IF(BR60=30,\"COMPLETE(30)\",IF(BR59>=40,\"COMPLETE(40)\",IF(BR60<8,\"DENOM <8\",IF(AND(BR60=8,BR56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,{"$f":"IF(AND(BT56=8,BT60=8),\"STOP\",IF(BT60=30,\"COMPLETE(30)\",IF(BT59>=40,\"COMPLETE(40)\",IF(BT60<8,\"DENOM <8\",IF(AND(BT60=8,BT56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,{"$f":"IF(AND(BV56=8,BV60=8),\"STOP\",IF(BV60=30,\"COMPLETE(30)\",IF(BV59>=40,\"COMPLETE(40)\",IF(BV60<8,\"DENOM <8\",IF(AND(BV60=8,BV56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"},null,{"$f":"IF(AND(BX56=8,BX60=8),\"STOP\",IF(BX60=30,\"COMPLETE(30)\",IF(BX59>=40,\"COMPLETE(40)\",IF(BX60<8,\"DENOM <8\",IF(AND(BX60=8,BX56<8),\"RATIO <8/8\",\"REVIEW FILES\")))))","v":"DENOM <8"}]
[1,{"$f":"+'File List - completed by NCQA'!B7","v":0},{"$f":"+'File List - completed by NCQA'!C7","v":0},{"$f":"+'File List - completed by NCQA'!D7","v":0},{"$f":"+'File List - completed by NCQA'!E7","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F7","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F7=\"\",\"\",IF(AND(C15=\"closed\",G15=\"\"),\"\",IF(AND(C15=\"closed\",(G15-F15)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C15=\"active\",($C$5-F15)>=60),\"Yes\",\"No\")))))","v":""},null,null,null,null,null,{"$f":"IF($K15=\"\",\"\",ABS($K15-$I15))","v":""},{"$f":"IF(M15=\"\",\"\",ABS(M15-$I15))","v":""},{"$f":"IF(OR($H15=\"No\",L15=\"NA\"),\"NA\",IF(L15=\"AC\",\"Yes\",IF(L15=\"\",\"\",IF(AND(L15=\"Yes\",N15<=30),\"Yes\",IF(AND(L15=\"Yes\",O15<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K15=\"\",\"\",ABS($K15-$I15))","v":""},{"$f":"IF(R15=\"\",\"\",ABS(R15-$I15))","v":""},{"$f":"IF(OR($H15=\"No\",Q15=\"NA\"),\"NA\",IF(Q15=\"AC\",\"Yes\",IF(Q15=\"\",\"\",IF(AND(Q15=\"Yes\",S15<=30),\"Yes\",IF(AND(Q15=\"Yes\",T15<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K15=\"\",\"\",ABS($K15-$I15))","v":""},{"$f":"IF(W15=\"\",\"\",ABS(W15-$I15))","v":""},{"$f":"IF(OR($H15=\"No\",V15=\"NA\"),\"NA\",IF(V15=\"AC\",\"Yes\",IF(V15=\"\",\"\",IF(AND(V15=\"Yes\",X15<=30),\"Yes\",IF(AND(V15=\"Yes\",Y15<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K15=\"\",\"\",ABS($K15-$I15))","v":""},{"$f":"IF(AB15=\"\",\"\",ABS(AB15-$I15))","v":""},{"$f":"IF(OR($H15=\"No\",AA15=\"NA\"),\"NA\",IF(AA15=\"AC\",\"Yes\",IF(AA15=\"\",\"\",IF(AND(AA15=\"Yes\",AC15<=30),\"Yes\",IF(AND(AA15=\"Yes\",AD15<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K15=\"\",\"\",ABS($K15-$I15))","v":""},{"$f":"IF(AG15=\"\",\"\",ABS(AG15-$I15))","v":""},{"$f":"IF(OR($H15=\"No\",AF15=\"NA\"),\"NA\",IF(AF15=\"AC\",\"Yes\",IF(AF15=\"\",\"\",IF(AND(AF15=\"Yes\",AH15<=30),\"Yes\",IF(AND(AF15=\"Yes\",AI15<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K15=\"\",\"\",ABS($K15-$I15))","v":""},{"$f":"IF(AL15=\"\",\"\",ABS(AL15-$I15))","v":""},{"$f":"IF(OR($H15=\"No\",AK15=\"NA\"),\"NA\",IF(AK15=\"AC\",\"Yes\",IF(AK15=\"\",\"\",IF(AND(AK15=\"Yes\",AM15<=30),\"Yes\",IF(AND(AK15=\"Yes\",AN15<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K15=\"\",\"\",ABS($K15-$I15))","v":""},{"$f":"IF(AQ15=\"\",\"\",ABS(AQ15-$I15))","v":""},{"$f":"IF(OR($H15=\"No\",AP15=\"NA\"),\"NA\",IF(AP15=\"AC\",\"Yes\",IF(AP15=\"\",\"\",IF(AND(AP15=\"Yes\",AR15<=30),\"Yes\",IF(AND(AP15=\"Yes\",AS15<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K15=\"\",\"\",ABS($K15-$I15))","v":""},{"$f":"IF(AV15=\"\",\"\",ABS(AV15-$I15))","v":""},{"$f":"IF(OR($H15=\"No\",AU15=\"NA\"),\"NA\",IF(AU15=\"AC\",\"Yes\",IF(AU15=\"\",\"\",IF(AND(AU15=\"Yes\",AW15<=30),\"Yes\",IF(AND(AU15=\"Yes\",AX15<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K15=\"\",\"\",ABS($K15-$I15))","v":""},{"$f":"IF(BA15=\"\",\"\",ABS(BA15-$I15))","v":""},{"$f":"IF(OR($H15=\"No\",AZ15=\"NA\"),\"NA\",IF(AZ15=\"AC\",\"Yes\",IF(AZ15=\"\",\"\",IF(AND(AZ15=\"Yes\",BB15<=30),\"Yes\",IF(AND(AZ15=\"Yes\",BC15<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K15=\"\",\"\",ABS($K15-$I15))","v":""},{"$f":"IF(BF15=\"\",\"\",ABS(BF15-$I15))","v":""},{"$f":"IF(OR($H15=\"No\",BE15=\"NA\"),\"NA\",IF(BE15=\"AC\",\"Yes\",IF(BE15=\"\",\"\",IF(AND(BE15=\"Yes\",BG15<=30),\"Yes\",IF(AND(BE15=\"Yes\",BH15<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K15=\"\",\"\",ABS($K15-$I15))","v":""},{"$f":"IF(BK15=\"\",\"\",ABS(BK15-$I15))","v":""},{"$f":"IF(OR($H15=\"No\",BJ15=\"NA\"),\"NA\",IF(BJ15=\"AC\",\"Yes\",IF(BJ15=\"\",\"\",IF(AND(BJ15=\"Yes\",BL15<=30),\"Yes\",IF(AND(BJ15=\"Yes\",BM15<=30),\"Yes\",\"No\")))))","v":""},null,{"$f":"IF($H15=\"No\",\"NA\",IF(BO15=\"AC\",\"Yes\",BO15))","v":0},null,{"$f":"IF($H15=\"No\",\"NA\",IF(BQ15=\"AC\",\"Yes\",BQ15))","v":0},null,{"$f":"IF($H15=\"No\",\"NA\",IF(BS15=\"AC\",\"Yes\",BS15))","v":0},null,{"$f":"IF($H15=\"No\",\"NA\",IF(BU15=\"AC\",\"Yes\",BU15))","v":0},null,{"$f":"IF($H15=\"No\",\"NA\",IF(BW15=\"AC\",\"Yes\",BW15))","v":0},null,{"$f":"COUNTIF(L15:BX15,\"NO\")+COUNTIF(L15:BX15,\"NA\")","v":0}]
[2,{"$f":"+'File List - completed by NCQA'!B8","v":0},{"$f":"+'File List - completed by NCQA'!C8","v":0},{"$f":"+'File List - completed by NCQA'!D8","v":0},{"$f":"+'File List - completed by NCQA'!E8","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F8","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F8=\"\",\"\",IF(AND(C16=\"closed\",G16=\"\"),\"\",IF(AND(C16=\"closed\",(G16-F16)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C16=\"active\",($C$5-F16)>=60),\"Yes\",\"No\")))))","v":""},null,null,null,null,null,{"$f":"IF($K16=\"\",\"\",ABS($K16-$I16))","v":""},{"$f":"IF(M16=\"\",\"\",ABS(M16-$I16))","v":""},{"$f":"IF(OR($H16=\"No\",L16=\"NA\"),\"NA\",IF(L16=\"AC\",\"Yes\",IF(L16=\"\",\"\",IF(AND(L16=\"Yes\",N16<=30),\"Yes\",IF(AND(L16=\"Yes\",O16<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K16=\"\",\"\",ABS($K16-$I16))","v":""},{"$f":"IF(R16=\"\",\"\",ABS(R16-$I16))","v":""},{"$f":"IF(OR($H16=\"No\",Q16=\"NA\"),\"NA\",IF(Q16=\"AC\",\"Yes\",IF(Q16=\"\",\"\",IF(AND(Q16=\"Yes\",S16<=30),\"Yes\",IF(AND(Q16=\"Yes\",T16<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K16=\"\",\"\",ABS($K16-$I16))","v":""},{"$f":"IF(W16=\"\",\"\",ABS(W16-$I16))","v":""},{"$f":"IF(OR($H16=\"No\",V16=\"NA\"),\"NA\",IF(V16=\"AC\",\"Yes\",IF(V16=\"\",\"\",IF(AND(V16=\"Yes\",X16<=30),\"Yes\",IF(AND(V16=\"Yes\",Y16<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K16=\"\",\"\",ABS($K16-$I16))","v":""},{"$f":"IF(AB16=\"\",\"\",ABS(AB16-$I16))","v":""},{"$f":"IF(OR($H16=\"No\",AA16=\"NA\"),\"NA\",IF(AA16=\"AC\",\"Yes\",IF(AA16=\"\",\"\",IF(AND(AA16=\"Yes\",AC16<=30),\"Yes\",IF(AND(AA16=\"Yes\",AD16<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K16=\"\",\"\",ABS($K16-$I16))","v":""},{"$f":"IF(AG16=\"\",\"\",ABS(AG16-$I16))","v":""},{"$f":"IF(OR($H16=\"No\",AF16=\"NA\"),\"NA\",IF(AF16=\"AC\",\"Yes\",IF(AF16=\"\",\"\",IF(AND(AF16=\"Yes\",AH16<=30),\"Yes\",IF(AND(AF16=\"Yes\",AI16<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K16=\"\",\"\",ABS($K16-$I16))","v":""},{"$f":"IF(AL16=\"\",\"\",ABS(AL16-$I16))","v":""},{"$f":"IF(OR($H16=\"No\",AK16=\"NA\"),\"NA\",IF(AK16=\"AC\",\"Yes\",IF(AK16=\"\",\"\",IF(AND(AK16=\"Yes\",AM16<=30),\"Yes\",IF(AND(AK16=\"Yes\",AN16<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K16=\"\",\"\",ABS($K16-$I16))","v":""},{"$f":"IF(AQ16=\"\",\"\",ABS(AQ16-$I16))","v":""},{"$f":"IF(OR($H16=\"No\",AP16=\"NA\"),\"NA\",IF(AP16=\"AC\",\"Yes\",IF(AP16=\"\",\"\",IF(AND(AP16=\"Yes\",AR16<=30),\"Yes\",IF(AND(AP16=\"Yes\",AS16<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K16=\"\",\"\",ABS($K16-$I16))","v":""},{"$f":"IF(AV16=\"\",\"\",ABS(AV16-$I16))","v":""},{"$f":"IF(OR($H16=\"No\",AU16=\"NA\"),\"NA\",IF(AU16=\"AC\",\"Yes\",IF(AU16=\"\",\"\",IF(AND(AU16=\"Yes\",AW16<=30),\"Yes\",IF(AND(AU16=\"Yes\",AX16<=30),\"Yes\",\"No\")))))","v":""},null,null,{"$f":"IF($K16=\"\",\"\",ABS($K16-$I16))","v":""},{"$f":"IF(BA16=\"\",\"\",ABS(BA16-$I16))","v":""},"",null,null,{"$f":"IF($K16=\"\",\"\",ABS($K16-$I16))","v":""},{"$f":"IF(BF16=\"\",\"\",ABS(BF16-$I16))","v":""},"",null,null,{"$f":"IF($K16=\"\",\"\",ABS($K16-$I16))","v":""},{"$f":"IF(BK16=\"\",\"\",ABS(BK16-$I16))","v":""},"",null,{"$f":"IF($H16=\"No\",\"NA\",IF(BO16=\"AC\",\"Yes\",BO16))","v":0},null,0,null,0,null,0,null,0,null,0]
[3,{"$f":"+'File List - completed by NCQA'!B9","v":0},{"$f":"+'File List - completed by NCQA'!C9","v":0},{"$f":"+'File List - completed by NCQA'!D9","v":0},{"$f":"+'File List - completed by NCQA'!E9","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F9","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F9=\"\",\"\",IF(AND(C17=\"closed\",G17=\"\"),\"\",IF(AND(C17=\"closed\",(G17-F17)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C17=\"active\",($C$5-F17)>=60),\"Yes\",\"No\")))))","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,{"$f":"IF($H17=\"No\",\"NA\",IF(BO17=\"AC\",\"Yes\",BO17))","v":0},null,{"$f":"IF($H17=\"No\",\"NA\",IF(BQ17=\"AC\",\"Yes\",BQ17))","v":0},null,{"$f":"IF($H17=\"No\",\"NA\",IF(BS17=\"AC\",\"Yes\",BS17))","v":0},null,{"$f":"IF($H17=\"No\",\"NA\",IF(BU17=\"AC\",\"Yes\",BU17))","v":0},null,{"$f":"IF($H17=\"No\",\"NA\",IF(BW17=\"AC\",\"Yes\",BW17))","v":0},null,0]
[4,{"$f":"+'File List - completed by NCQA'!B10","v":0},{"$f":"+'File List - completed by NCQA'!C10","v":0},{"$f":"+'File List - completed by NCQA'!D10","v":0},{"$f":"+'File List - completed by NCQA'!E10","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F10","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F10=\"\",\"\",IF(AND(C18=\"closed\",G18=\"\"),\"\",IF(AND(C18=\"closed\",(G18-F18)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C18=\"active\",($C$5-F18)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[5,{"$f":"+'File List - completed by NCQA'!B11","v":0},{"$f":"+'File List - completed by NCQA'!C11","v":0},{"$f":"+'File List - completed by NCQA'!D11","v":0},{"$f":"+'File List - completed by NCQA'!E11","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F11","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F11=\"\",\"\",IF(AND(C19=\"closed\",G19=\"\"),\"\",IF(AND(C19=\"closed\",(G19-F19)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C19=\"active\",($C$5-F19)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[6,{"$f":"+'File List - completed by NCQA'!B12","v":0},{"$f":"+'File List - completed by NCQA'!C12","v":0},{"$f":"+'File List - completed by NCQA'!D12","v":0},{"$f":"+'File List - completed by NCQA'!E12","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F12","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F12=\"\",\"\",IF(AND(C20=\"closed\",G20=\"\"),\"\",IF(AND(C20=\"closed\",(G20-F20)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C20=\"active\",($C$5-F20)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[7,{"$f":"+'File List - completed by NCQA'!B13","v":0},{"$f":"+'File List - completed by NCQA'!C13","v":0},{"$f":"+'File List - completed by NCQA'!D13","v":0},{"$f":"+'File List - completed by NCQA'!E13","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F13","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F13=\"\",\"\",IF(AND(C21=\"closed\",G21=\"\"),\"\",IF(AND(C21=\"closed\",(G21-F21)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C21=\"active\",($C$5-F21)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[8,{"$f":"+'File List - completed by NCQA'!B14","v":0},{"$f":"+'File List - completed by NCQA'!C14","v":0},{"$f":"+'File List - completed by NCQA'!D14","v":0},{"$f":"+'File List - completed by NCQA'!E14","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F14","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F14=\"\",\"\",IF(AND(C22=\"closed\",G22=\"\"),\"\",IF(AND(C22=\"closed\",(G22-F22)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C22=\"active\",($C$5-F22)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[9,{"$f":"+'File List - completed by NCQA'!B15","v":0},{"$f":"+'File List - completed by NCQA'!C15","v":0},{"$f":"+'File List - completed by NCQA'!D15","v":0},{"$f":"+'File List - completed by NCQA'!E15","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F15","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F15=\"\",\"\",IF(AND(C23=\"closed\",G23=\"\"),\"\",IF(AND(C23=\"closed\",(G23-F23)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C23=\"active\",($C$5-F23)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[10,{"$f":"+'File List - completed by NCQA'!B16","v":0},{"$f":"+'File List - completed by NCQA'!C16","v":0},{"$f":"+'File List - completed by NCQA'!D16","v":0},{"$f":"+'File List - completed by NCQA'!E16","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F16","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F16=\"\",\"\",IF(AND(C24=\"closed\",G24=\"\"),\"\",IF(AND(C24=\"closed\",(G24-F24)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C24=\"active\",($C$5-F24)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[11,{"$f":"+'File List - completed by NCQA'!B17","v":0},{"$f":"+'File List - completed by NCQA'!C17","v":0},{"$f":"+'File List - completed by NCQA'!D17","v":0},{"$f":"+'File List - completed by NCQA'!E17","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F17","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F17=\"\",\"\",IF(AND(C25=\"closed\",G25=\"\"),\"\",IF(AND(C25=\"closed\",(G25-F25)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C25=\"active\",($C$5-F25)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[12,{"$f":"+'File List - completed by NCQA'!B18","v":0},{"$f":"+'File List - completed by NCQA'!C18","v":0},{"$f":"+'File List - completed by NCQA'!D18","v":0},{"$f":"+'File List - completed by NCQA'!E18","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F18","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F18=\"\",\"\",IF(AND(C26=\"closed\",G26=\"\"),\"\",IF(AND(C26=\"closed\",(G26-F26)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C26=\"active\",($C$5-F26)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[13,{"$f":"+'File List - completed by NCQA'!B19","v":0},{"$f":"+'File List - completed by NCQA'!C19","v":0},{"$f":"+'File List - completed by NCQA'!D19","v":0},{"$f":"+'File List - completed by NCQA'!E19","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F19","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F19=\"\",\"\",IF(AND(C27=\"closed\",G27=\"\"),\"\",IF(AND(C27=\"closed\",(G27-F27)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C27=\"active\",($C$5-F27)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[14,{"$f":"+'File List - completed by NCQA'!B20","v":0},{"$f":"+'File List - completed by NCQA'!C20","v":0},{"$f":"+'File List - completed by NCQA'!D20","v":0},{"$f":"+'File List - completed by NCQA'!E20","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F20","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F20=\"\",\"\",IF(AND(C28=\"closed\",G28=\"\"),\"\",IF(AND(C28=\"closed\",(G28-F28)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C28=\"active\",($C$5-F28)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[15,{"$f":"+'File List - completed by NCQA'!B21","v":0},{"$f":"+'File List - completed by NCQA'!C21","v":0},{"$f":"+'File List - completed by NCQA'!D21","v":0},{"$f":"+'File List - completed by NCQA'!E21","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F21","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F21=\"\",\"\",IF(AND(C29=\"closed\",G29=\"\"),\"\",IF(AND(C29=\"closed\",(G29-F29)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C29=\"active\",($C$5-F29)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[16,{"$f":"+'File List - completed by NCQA'!B22","v":0},{"$f":"+'File List - completed by NCQA'!C22","v":0},{"$f":"+'File List - completed by NCQA'!D22","v":0},{"$f":"+'File List - completed by NCQA'!E22","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F22","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F22=\"\",\"\",IF(AND(C30=\"closed\",G30=\"\"),\"\",IF(AND(C30=\"closed\",(G30-F30)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C30=\"active\",($C$5-F30)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[17,{"$f":"+'File List - completed by NCQA'!B23","v":0},{"$f":"+'File List - completed by NCQA'!C23","v":0},{"$f":"+'File List - completed by NCQA'!D23","v":0},{"$f":"+'File List - completed by NCQA'!E23","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F23","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F23=\"\",\"\",IF(AND(C31=\"closed\",G31=\"\"),\"\",IF(AND(C31=\"closed\",(G31-F31)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C31=\"active\",($C$5-F31)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[18,{"$f":"+'File List - completed by NCQA'!B24","v":0},{"$f":"+'File List - completed by NCQA'!C24","v":0},{"$f":"+'File List - completed by NCQA'!D24","v":0},{"$f":"+'File List - completed by NCQA'!E24","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F24","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F24=\"\",\"\",IF(AND(C32=\"closed\",G32=\"\"),\"\",IF(AND(C32=\"closed\",(G32-F32)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C32=\"active\",($C$5-F32)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[19,{"$f":"+'File List - completed by NCQA'!B25","v":0},{"$f":"+'File List - completed by NCQA'!C25","v":0},{"$f":"+'File List - completed by NCQA'!D25","v":0},{"$f":"+'File List - completed by NCQA'!E25","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F25","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F25=\"\",\"\",IF(AND(C33=\"closed\",G33=\"\"),\"\",IF(AND(C33=\"closed\",(G33-F33)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C33=\"active\",($C$5-F33)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[20,{"$f":"+'File List - completed by NCQA'!B26","v":0},{"$f":"+'File List - completed by NCQA'!C26","v":0},{"$f":"+'File List - completed by NCQA'!D26","v":0},{"$f":"+'File List - completed by NCQA'!E26","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F26","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F26=\"\",\"\",IF(AND(C34=\"closed\",G34=\"\"),\"\",IF(AND(C34=\"closed\",(G34-F34)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C34=\"active\",($C$5-F34)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[21,{"$f":"+'File List - completed by NCQA'!B27","v":0},{"$f":"+'File List - completed by NCQA'!C27","v":0},{"$f":"+'File List - completed by NCQA'!D27","v":0},{"$f":"+'File List - completed by NCQA'!E27","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F27","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F27=\"\",\"\",IF(AND(C35=\"closed\",G35=\"\"),\"\",IF(AND(C35=\"closed\",(G35-F35)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C35=\"active\",($C$5-F35)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[22,{"$f":"+'File List - completed by NCQA'!B28","v":0},{"$f":"+'File List - completed by NCQA'!C28","v":0},{"$f":"+'File List - completed by NCQA'!D28","v":0},{"$f":"+'File List - completed by NCQA'!E28","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F28","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F28=\"\",\"\",IF(AND(C36=\"closed\",G36=\"\"),\"\",IF(AND(C36=\"closed\",(G36-F36)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C36=\"active\",($C$5-F36)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[23,{"$f":"+'File List - completed by NCQA'!B29","v":0},{"$f":"+'File List - completed by NCQA'!C29","v":0},{"$f":"+'File List - completed by NCQA'!D29","v":0},{"$f":"+'File List - completed by NCQA'!E29","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F29","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F29=\"\",\"\",IF(AND(C37=\"closed\",G37=\"\"),\"\",IF(AND(C37=\"closed\",(G37-F37)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C37=\"active\",($C$5-F37)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[24,{"$f":"+'File List - completed by NCQA'!B30","v":0},{"$f":"+'File List - completed by NCQA'!C30","v":0},{"$f":"+'File List - completed by NCQA'!D30","v":0},{"$f":"+'File List - completed by NCQA'!E30","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F30","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F30=\"\",\"\",IF(AND(C38=\"closed\",G38=\"\"),\"\",IF(AND(C38=\"closed\",(G38-F38)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C38=\"active\",($C$5-F38)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[25,{"$f":"+'File List - completed by NCQA'!B31","v":0},{"$f":"+'File List - completed by NCQA'!C31","v":0},{"$f":"+'File List - completed by NCQA'!D31","v":0},{"$f":"+'File List - completed by NCQA'!E31","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F31","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F31=\"\",\"\",IF(AND(C39=\"closed\",G39=\"\"),\"\",IF(AND(C39=\"closed\",(G39-F39)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C39=\"active\",($C$5-F39)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[26,{"$f":"+'File List - completed by NCQA'!B32","v":0},{"$f":"+'File List - completed by NCQA'!C32","v":0},{"$f":"+'File List - completed by NCQA'!D32","v":0},{"$f":"+'File List - completed by NCQA'!E32","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F32","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F32=\"\",\"\",IF(AND(C40=\"closed\",G40=\"\"),\"\",IF(AND(C40=\"closed\",(G40-F40)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C40=\"active\",($C$5-F40)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[27,{"$f":"+'File List - completed by NCQA'!B33","v":0},{"$f":"+'File List - completed by NCQA'!C33","v":0},{"$f":"+'File List - completed by NCQA'!D33","v":0},{"$f":"+'File List - completed by NCQA'!E33","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F33","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F33=\"\",\"\",IF(AND(C41=\"closed\",G41=\"\"),\"\",IF(AND(C41=\"closed\",(G41-F41)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C41=\"active\",($C$5-F41)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[28,{"$f":"+'File List - completed by NCQA'!B34","v":0},{"$f":"+'File List - completed by NCQA'!C34","v":0},{"$f":"+'File List - completed by NCQA'!D34","v":0},{"$f":"+'File List - completed by NCQA'!E34","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F34","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F34=\"\",\"\",IF(AND(C42=\"closed\",G42=\"\"),\"\",IF(AND(C42=\"closed\",(G42-F42)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C42=\"active\",($C$5-F42)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[29,{"$f":"+'File List - completed by NCQA'!B35","v":0},{"$f":"+'File List - completed by NCQA'!C35","v":0},{"$f":"+'File List - completed by NCQA'!D35","v":0},{"$f":"+'File List - completed by NCQA'!E35","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F35","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F35=\"\",\"\",IF(AND(C43=\"closed\",G43=\"\"),\"\",IF(AND(C43=\"closed\",(G43-F43)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C43=\"active\",($C$5-F43)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[30,{"$f":"+'File List - completed by NCQA'!B36","v":0},{"$f":"+'File List - completed by NCQA'!C36","v":0},{"$f":"+'File List - completed by NCQA'!D36","v":0},{"$f":"+'File List - completed by NCQA'!E36","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F36","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F36=\"\",\"\",IF(AND(C44=\"closed\",G44=\"\"),\"\",IF(AND(C44=\"closed\",(G44-F44)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C44=\"active\",($C$5-F44)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[31,{"$f":"+'File List - completed by NCQA'!B37","v":0},{"$f":"+'File List - completed by NCQA'!C37","v":0},{"$f":"+'File List - completed by NCQA'!D37","v":0},{"$f":"+'File List - completed by NCQA'!E37","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F37","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F37=\"\",\"\",IF(AND(C45=\"closed\",G45=\"\"),\"\",IF(AND(C45=\"closed\",(G45-F45)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C45=\"active\",($C$5-F45)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[32,{"$f":"+'File List - completed by NCQA'!B38","v":0},{"$f":"+'File List - completed by NCQA'!C38","v":0},{"$f":"+'File List - completed by NCQA'!D38","v":0},{"$f":"+'File List - completed by NCQA'!E38","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F38","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F38=\"\",\"\",IF(AND(C46=\"closed\",G46=\"\"),\"\",IF(AND(C46=\"closed\",(G46-F46)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C46=\"active\",($C$5-F46)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[33,{"$f":"+'File List - completed by NCQA'!B39","v":0},{"$f":"+'File List - completed by NCQA'!C39","v":0},{"$f":"+'File List - completed by NCQA'!D39","v":0},{"$f":"+'File List - completed by NCQA'!E39","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F39","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F39=\"\",\"\",IF(AND(C47=\"closed\",G47=\"\"),\"\",IF(AND(C47=\"closed\",(G47-F47)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C47=\"active\",($C$5-F47)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[34,{"$f":"+'File List - completed by NCQA'!B40","v":0},{"$f":"+'File List - completed by NCQA'!C40","v":0},{"$f":"+'File List - completed by NCQA'!D40","v":0},{"$f":"+'File List - completed by NCQA'!E40","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F40","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F40=\"\",\"\",IF(AND(C48=\"closed\",G48=\"\"),\"\",IF(AND(C48=\"closed\",(G48-F48)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C48=\"active\",($C$5-F48)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[35,{"$f":"+'File List - completed by NCQA'!B41","v":0},{"$f":"+'File List - completed by NCQA'!C41","v":0},{"$f":"+'File List - completed by NCQA'!D41","v":0},{"$f":"+'File List - completed by NCQA'!E41","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F41","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F41=\"\",\"\",IF(AND(C49=\"closed\",G49=\"\"),\"\",IF(AND(C49=\"closed\",(G49-F49)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C49=\"active\",($C$5-F49)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[36,{"$f":"+'File List - completed by NCQA'!B42","v":0},{"$f":"+'File List - completed by NCQA'!C42","v":0},{"$f":"+'File List - completed by NCQA'!D42","v":0},{"$f":"+'File List - completed by NCQA'!E42","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F42","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F42=\"\",\"\",IF(AND(C50=\"closed\",G50=\"\"),\"\",IF(AND(C50=\"closed\",(G50-F50)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C50=\"active\",($C$5-F50)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[37,{"$f":"+'File List - completed by NCQA'!B43","v":0},{"$f":"+'File List - completed by NCQA'!C43","v":0},{"$f":"+'File List - completed by NCQA'!D43","v":0},{"$f":"+'File List - completed by NCQA'!E43","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F43","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F43=\"\",\"\",IF(AND(C51=\"closed\",G51=\"\"),\"\",IF(AND(C51=\"closed\",(G51-F51)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C51=\"active\",($C$5-F51)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[38,{"$f":"+'File List - completed by NCQA'!B44","v":0},{"$f":"+'File List - completed by NCQA'!C44","v":0},{"$f":"+'File List - completed by NCQA'!D44","v":0},{"$f":"+'File List - completed by NCQA'!E44","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F44","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F44=\"\",\"\",IF(AND(C52=\"closed\",G52=\"\"),\"\",IF(AND(C52=\"closed\",(G52-F52)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C52=\"active\",($C$5-F52)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[39,{"$f":"+'File List - completed by NCQA'!B45","v":0},{"$f":"+'File List - completed by NCQA'!C45","v":0},{"$f":"+'File List - completed by NCQA'!D45","v":0},{"$f":"+'File List - completed by NCQA'!E45","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F45","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F45=\"\",\"\",IF(AND(C53=\"closed\",G53=\"\"),\"\",IF(AND(C53=\"closed\",(G53-F53)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C53=\"active\",($C$5-F53)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,null,0]
[40,{"$f":"+'File List - completed by NCQA'!B46","v":0},{"$f":"+'File List - completed by NCQA'!C46","v":0},{"$f":"+'File List - completed by NCQA'!D46","v":0},{"$f":"+'File List - completed by NCQA'!E46","v":"00:00:00"},{"$f":"+'File List - completed by NCQA'!F46","v":"00:00:00"},null,{"$f":"IF('File List - completed by NCQA'!F46=\"\",\"\",IF(AND(C54=\"closed\",G54=\"\"),\"\",IF(AND(C54=\"closed\",(G54-F54)>=60),\"Yes\",IF($C$5=\"\",\"ERROR\",IF(AND(C54=\"active\",($C$5-F54)>=60),\"Yes\",\"No\")))))","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,0,null,0,null,0,null,0,null,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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($H55=\"No\",\"NA\",IF(BQ55=\"AC\",\"Yes\",BQ55))","v":0},null,{"$f":"IF($H55=\"No\",\"NA\",IF(BS55=\"AC\",\"Yes\",BS55))","v":0},null,{"$f":"IF($H55=\"No\",\"NA\",IF(BU55=\"AC\",\"Yes\",BU55))","v":0},null,{"$f":"IF($H55=\"No\",\"NA\",IF(BW55=\"AC\",\"Yes\",BW55))","v":0}]
["Files Compliant (Yes): ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(P15:P54,\"Yes\")","v":0},null,null,null,null,{"$f":"COUNTIF(U15:U54,\"Yes\")","v":0},null,null,null,null,{"$f":"COUNTIF(Z15:Z54,\"Yes\")","v":0},null,null,null,null,{"$f":"COUNTIF(AE15:AE54,\"Yes\")","v":0},null,null,null,null,{"$f":"COUNTIF(AJ15:AJ54,\"Yes\")","v":0},null,null,null,null,{"$f":"COUNTIF(AO15:AO54,\"Yes\")","v":0},null,null,null,null,{"$f":"COUNTIF(AT15:AT54,\"Yes\")","v":0},null,null,null,null,{"$f":"COUNTIF(AY15:AY54,\"Yes\")","v":0},null,null,null,null,{"$f":"COUNTIF(BD15:BD54,\"Yes\")","v":0},null,null,null,null,{"$f":"COUNTIF(BI15:BI54,\"Yes\")","v":0},null,null,null,null,{"$f":"COUNTIF(BN15:BN54,\"Yes\")","v":0},null,{"$f":"COUNTIF(BP15:BP54,\"Yes\")","v":0},null,{"$f":"COUNTIF(BR15:BR54,\"Yes\")","v":0},null,{"$f":"COUNTIF(BT15:BT54,\"Yes\")","v":0},null,{"$f":"COUNTIF(BV15:BV54,\"Yes\")","v":0},null,{"$f":"COUNTIF(BX15:BX54,\"Yes\")","v":0},null,{"$f":"COUNTIF(BX15:BX54,\"Yes\")","v":0}]
["Files Not Compliant (No): ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(P15:P54,\"No\")","v":0},null,null,null,null,{"$f":"COUNTIF(U15:U54,\"No\")","v":0},null,null,null,null,{"$f":"COUNTIF(Z15:Z54,\"No\")","v":0},null,null,null,null,{"$f":"COUNTIF(AE15:AE54,\"No\")","v":0},null,null,null,null,{"$f":"COUNTIF(AJ15:AJ54,\"No\")","v":0},null,null,null,null,{"$f":"COUNTIF(AO15:AO54,\"No\")","v":0},null,null,null,null,{"$f":"COUNTIF(AT15:AT54,\"No\")","v":0},null,null,null,null,{"$f":"COUNTIF(AY15:AY54,\"No\")","v":0},null,null,null,null,{"$f":"COUNTIF(BD15:BD54,\"No\")","v":0},null,null,null,null,{"$f":"COUNTIF(BI15:BI54,\"No\")","v":0},null,null,null,null,{"$f":"COUNTIF(BN15:BN54,\"No\")","v":0},null,{"$f":"COUNTIF(BP15:BP54,\"No\")","v":0},null,{"$f":"COUNTIF(BR15:BR54,\"No\")","v":0},null,{"$f":"COUNTIF(BT15:BT54,\"No\")","v":0},null,{"$f":"COUNTIF(BV15:BV54,\"No\")","v":0},null,{"$f":"COUNTIF(BX15:BX54,\"No\")","v":0},null,{"$f":"COUNTIF(BX15:BX54,\"No\")","v":0}]
["Files Not Applicable (NA): ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(P15:P54,\"NA\")","v":0},null,null,null,null,{"$f":"COUNTIF(U15:U54,\"NA\")","v":0},null,null,null,null,{"$f":"COUNTIF(Z15:Z54,\"NA\")","v":0},null,null,null,null,{"$f":"COUNTIF(AE15:AE54,\"NA\")","v":0},null,null,null,null,{"$f":"COUNTIF(AJ15:AJ54,\"NA\")","v":0},null,null,null,null,{"$f":"COUNTIF(AO15:AO54,\"NA\")","v":0},null,null,null,null,{"$f":"COUNTIF(AT15:AT54,\"NA\")","v":0},null,null,null,null,{"$f":"COUNTIF(AY15:AY54,\"NA\")","v":0},null,null,null,null,{"$f":"COUNTIF(BD15:BD54,\"NA\")","v":0},null,null,null,null,{"$f":"COUNTIF(BI15:BI54,\"NA\")","v":0},null,null,null,null,{"$f":"COUNTIF(BN15:BN54,\"NA\")","v":0},null,{"$f":"COUNTIF(BP15:BP54,\"NA\")","v":0},null,{"$f":"COUNTIF(BR15:BR54,\"NA\")","v":0},null,{"$f":"COUNTIF(BT15:BT54,\"NA\")","v":0},null,{"$f":"COUNTIF(BV15:BV54,\"NA\")","v":0},null,{"$f":"COUNTIF(BX15:BX54,\"NA\")","v":0},null,{"$f":"COUNTIF(BX15:BX54,\"NA\")","v":0}]
["Total Files Reviewed (Yes + No + NA):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P56:P58)","v":0},null,null,null,null,{"$f":"SUM(U56:U58)","v":0},null,null,null,null,{"$f":"SUM(Z56:Z58)","v":0},null,null,null,null,{"$f":"SUM(AE56:AE58)","v":0},null,null,null,null,{"$f":"SUM(AJ56:AJ58)","v":0},null,null,null,null,{"$f":"SUM(AO56:AO58)","v":0},null,null,null,null,{"$f":"SUM(AT56:AT58)","v":0},null,null,null,null,{"$f":"SUM(AY56:AY58)","v":0},null,null,null,null,{"$f":"SUM(BD56:BD58)","v":0},null,null,null,null,{"$f":"SUM(BI56:BI58)","v":0},null,null,null,null,{"$f":"SUM(BN56:BN58)","v":0},null,{"$f":"SUM(BP56:BP58)","v":0},null,{"$f":"SUM(BR56:BR58)","v":0},null,{"$f":"SUM(BT56:BT58)","v":0},null,{"$f":"SUM(BV56:BV58)","v":0},null,{"$f":"SUM(BX56:BX58)","v":0},null,{"$f":"SUM(BZ56:BZ58)","v":0}]
["Total Applicable Files (Yes + No):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P56+P57","v":0},null,null,null,null,{"$f":"U56+U57","v":0},null,null,null,null,{"$f":"Z56+Z57","v":0},null,null,null,null,{"$f":"AE56+AE57","v":0},null,null,null,null,{"$f":"AJ56+AJ57","v":0},null,null,null,null,{"$f":"AO56+AO57","v":0},null,null,null,null,{"$f":"AT56+AT57","v":0},null,null,null,null,{"$f":"AY56+AY57","v":0},null,null,null,null,{"$f":"BD56+BD57","v":0},null,null,null,null,{"$f":"BI56+BI57","v":0},null,null,null,null,{"$f":"BN56+BN57","v":0},null,{"$f":"BP56+BP57","v":0},null,{"$f":"BR56+BR57","v":0},null,{"$f":"BT56+BT57","v":0},null,{"$f":"BV56+BV57","v":0},null,{"$f":"BX56+BX57","v":0},null,{"$f":"BZ56+BZ57","v":0}]
[]
["Compliance Ratio:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P56,\"/\",P60)","v":"0/0"},null,null,null,null,{"$f":"CONCATENATE(U56,\"/\",U60)","v":"0/0"},null,null,null,null,{"$f":"CONCATENATE(Z56,\"/\",Z60)","v":"0/0"},null,null,null,null,{"$f":"CONCATENATE(AE56,\"/\",AE60)","v":"0/0"},null,null,null,null,{"$f":"CONCATENATE(AJ56,\"/\",AJ60)","v":"0/0"},null,null,null,null,{"$f":"CONCATENATE(AO56,\"/\",AO60)","v":"0/0"},null,null,null,null,{"$f":"CONCATENATE(AT56,\"/\",AT60)","v":"0/0"},null,null,null,null,{"$f":"CONCATENATE(AY56,\"/\",AY60)","v":"0/0"},null,null,null,null,{"$f":"CONCATENATE(BD56,\"/\",BD60)","v":"0/0"},null,null,null,null,{"$f":"CONCATENATE(BI56,\"/\",BI60)","v":"0/0"},null,null,null,null,{"$f":"CONCATENATE(BN56,\"/\",BN60)","v":"0/0"},null,{"$f":"CONCATENATE(BP56,\"/\",BP60)","v":"0/0"},null,{"$f":"CONCATENATE(BP56,\"/\",BP60)","v":"0/0"},null,{"$f":"CONCATENATE(BT56,\"/\",BT60)","v":"0/0"},null,{"$f":"CONCATENATE(BV56,\"/\",BV60)","v":"0/0"},null,{"$f":"CONCATENATE(BX56,\"/\",BX60)","v":"0/0"},null,{"$f":"CONCATENATE(BZ56,\"/\",BZ60)","v":"0/0"}]
["Percentage Compliant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P60=0,0,P56/P60)","v":0},null,null,null,null,{"$f":"IF(U60=0,0,U56/U60)","v":0},null,null,null,null,{"$f":"IF(Z60=0,0,Z56/Z60)","v":0},null,null,null,null,{"$f":"IF(AE60=0,0,AE56/AE60)","v":0},null,null,null,null,{"$f":"IF(AJ60=0,0,AJ56/AJ60)","v":0},null,null,null,null,{"$f":"IF(AO60=0,0,AO56/AO60)","v":0},null,null,null,null,{"$f":"IF(AT60=0,0,AT56/AT60)","v":0},null,null,null,null,{"$f":"IF(AY60=0,0,AY56/AY60)","v":0},null,null,null,null,{"$f":"IF(BD60=0,0,BD56/BD60)","v":0},null,null,null,null,{"$f":"IF(BI60=0,0,BI56/BI60)","v":0},null,null,null,null,{"$f":"IF(BN60=0,0,BN56/BN60)","v":0},null,{"$f":"IF(BP60=0,0,BP56/BP60)","v":0},null,{"$f":"IF(BP60=0,0,BP56/BP60)","v":0},null,{"$f":"IF(BT60=0,0,BT56/BT60)","v":0},null,{"$f":"IF(BV60=0,0,BV56/BV60)","v":0},null,{"$f":"IF(BX60=0,0,BX56/BX60)","v":0},null,{"$f":"IF(BZ60=0,0,BZ56/BZ60)","v":0}]
["Score:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(P14:P54,\"ERROR\"),\"ERROR\",IF(OR(L14=\"DENOM <8\",L14=\"RATIO <8/8\",L14=\"REVIEW FILES\"),\"X\",IF(P63>=0.9,\"HIGH\",IF(P63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,null,null,null,{"$f":"IF(COUNTIF(U14:U54,\"ERROR\"),\"ERROR\",IF(OR(Q14=\"DENOM <8\",Q14=\"RATIO <8/8\",Q14=\"REVIEW FILES\"),\"X\",IF(U63>=0.9,\"HIGH\",IF(U63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,null,null,null,{"$f":"IF(COUNTIF(Z14:Z54,\"ERROR\"),\"ERROR\",IF(OR(V14=\"DENOM <8\",V14=\"RATIO <8/8\",V14=\"REVIEW FILES\"),\"X\",IF(Z63>=0.9,\"HIGH\",IF(Z63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,null,null,null,{"$f":"IF(COUNTIF(AE14:AE54,\"ERROR\"),\"ERROR\",IF(OR(AA14=\"DENOM <8\",AA14=\"RATIO <8/8\",AA14=\"REVIEW FILES\"),\"X\",IF(AE63>=0.9,\"HIGH\",IF(AE63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,null,null,null,{"$f":"IF(COUNTIF(AJ14:AJ54,\"ERROR\"),\"ERROR\",IF(OR(AF14=\"DENOM <8\",AF14=\"RATIO <8/8\",AF14=\"REVIEW FILES\"),\"X\",IF(AJ63>=0.9,\"HIGH\",IF(AJ63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,null,null,null,{"$f":"IF(COUNTIF(AO14:AO54,\"ERROR\"),\"ERROR\",IF(OR(AK14=\"DENOM <8\",AK14=\"RATIO <8/8\",AK14=\"REVIEW FILES\"),\"X\",IF(AO63>=0.9,\"HIGH\",IF(AO63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,null,null,null,{"$f":"IF(COUNTIF(AT14:AT54,\"ERROR\"),\"ERROR\",IF(OR(AP14=\"DENOM <8\",AP14=\"RATIO <8/8\",AP14=\"REVIEW FILES\"),\"X\",IF(AT63>=0.9,\"HIGH\",IF(AT63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,null,null,null,{"$f":"IF(COUNTIF(AY14:AY54,\"ERROR\"),\"ERROR\",IF(OR(AU14=\"DENOM <8\",AU14=\"RATIO <8/8\",AU14=\"REVIEW FILES\"),\"X\",IF(AY63>=0.9,\"HIGH\",IF(AY63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,null,null,null,{"$f":"IF(COUNTIF(BD14:BD54,\"ERROR\"),\"ERROR\",IF(OR(AZ14=\"DENOM <8\",AZ14=\"RATIO <8/8\",AZ14=\"REVIEW FILES\"),\"X\",IF(BD63>=0.9,\"HIGH\",IF(BD63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,null,null,null,{"$f":"IF(COUNTIF(BI14:BI54,\"ERROR\"),\"ERROR\",IF(OR(BE14=\"DENOM <8\",BE14=\"RATIO <8/8\",BE14=\"REVIEW FILES\"),\"X\",IF(BI63>=0.9,\"HIGH\",IF(BI63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,null,null,null,{"$f":"IF(COUNTIF(BN14:BN54,\"ERROR\"),\"ERROR\",IF(OR(BJ14=\"DENOM <8\",BJ14=\"RATIO <8/8\",BJ14=\"REVIEW FILES\"),\"X\",IF(BN63>=0.9,\"HIGH\",IF(BN63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,{"$f":"IF(COUNTIF(BP14:BP54,\"ERROR\"),\"ERROR\",IF(OR(BO14=\"DENOM <8\",BO14=\"RATIO <8/8\",BO14=\"REVIEW FILES\"),\"X\",IF(BP63>=0.9,\"HIGH\",IF(BP63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,{"$f":"IF(COUNTIF(BR14:BR54,\"ERROR\"),\"ERROR\",IF(OR(BQ14=\"DENOM <8\",BQ14=\"RATIO <8/8\",BQ14=\"REVIEW FILES\"),\"X\",IF(BR63>=0.9,\"HIGH\",IF(BR63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,{"$f":"IF(COUNTIF(BT14:BT54,\"ERROR\"),\"ERROR\",IF(OR(BS14=\"DENOM <8\",BS14=\"RATIO <8/8\",BS14=\"REVIEW FILES\"),\"X\",IF(BT63>=0.9,\"HIGH\",IF(BT63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,{"$f":"IF(COUNTIF(BV14:BV54,\"ERROR\"),\"ERROR\",IF(OR(BU14=\"DENOM <8\",BU14=\"RATIO <8/8\",BU14=\"REVIEW FILES\"),\"X\",IF(BV63>=0.9,\"HIGH\",IF(BV63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,{"$f":"IF(COUNTIF(BX14:BX54,\"ERROR\"),\"ERROR\",IF(OR(BW14=\"DENOM <8\",BW14=\"RATIO <8/8\",BW14=\"REVIEW FILES\"),\"X\",IF(BX63>=0.9,\"HIGH\",IF(BX63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"},null,{"$f":"IF(COUNTIF(BX14:BX54,\"ERROR\"),\"ERROR\",IF(OR(BW14=\"DENOM <8\",BW14=\"RATIO <8/8\",BW14=\"REVIEW FILES\"),\"X\",IF(62>=0.9,\"HIGH\",IF(BZ63>=0.6,\"MEDIUM\",\"LOW\"))))","v":"X"}]
[]
["DENOM <8: The DENOMINATOR in the RATIO is <8 for the element. Review additional files until you have reviewed at least 8 files for the factor."]
["RATIO <8/8: The RATIO for the element is <8/8. Review additional files until you have reviewed 30 applicable files for the factor."]
["STOP: The RATIO for the factor is at least 8/8, stop and enter a score of HIGH in the Survey Tool. "]
["Review Files...: Continue to review files (including those in the oversample) for the factor until you have a denominator of 30 applicable files or you have exhausted the oversample."]
["COMPLETE(30): You have reviewed 30 applicable files. Stop and enter the score in the Survey Tool. "]
["COMPLETE(40): You have exhausted the oversample. Stop and enter the score in the Survey Tool. "]
["ERROR: An \"ERROR\" message will appear in the \"Scoring Notes\" and \"Score\" fields for an element if a response for one or more of the files is not consistent with the response rules provided in the Directions for Completing the Worksheets tab of this workbook. Please see the hidden comment in the column header for a specific explanation of the ERROR messages for that column."]
[]
[null,null,null,"I, ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," reviewed the results of the file review with "]
[null,null,null,null,null,"(Surveyor's name)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"of the organization's staff."]
[null,null,null,null,null,"(Organization staff member's name)"]
[]
[]
["Drop Down Lists"]
["Yes","Active"]
["No","Closed"]
["NA"]
["AC"]