{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["1. Introduction","2. Self-Assessment","3. Dashboard","(Worksheet)"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":97,"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":"1. Introduction","index":0,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,3,13,11],[14,3,14,11],[15,3,15,11],[17,3,17,11],[18,3,18,11],[16,3,16,11],[8,3,8,11],[9,3,9,11],[10,3,10,11],[11,3,11,11],[12,3,12,11],[5,1,5,13],[2,1,2,13],[4,1,4,13],[6,3,6,11],[7,3,7,11],[19,3,19,11],[20,3,20,11],[21,3,21,11],[28,3,28,11],[29,3,29,11],[22,3,22,11],[23,5,23,6],[24,5,24,6],[25,5,25,6],[23,7,23,9],[24,7,24,9],[25,7,25,9],[26,7,26,9],[26,5,26,6],[34,3,34,11],[30,3,30,11],[31,3,31,11],[32,3,32,11],[33,3,33,11]]}
[]
[]
[]
[]
[null,"This tool will help you assess the current efficiency and maturity of your Credentialing Office within each of the major challenge areas identified in the PARAS 0036 Airport Credentialing Efficiency Toolkit. Use the results of this tool to develop your Credentialing Office Management Improvement Roadmap."]
[null,"This tool is intended to supply general information only, not specific professional or personal advice, and is not intended to be used as a substitute for professional advice. Use this document, either in whole or in part, as a basis and guide for performing a self assessment of  your internal Credentialing Office operations."]
[null,null,null,"INSTRUCTIONS: (All inputs are on the Self Assessment tab)"]
[]
[null,null,null,"1. On the Self Assessment tab, use the radio buttons to answer \"Yes\" or \"No\" for each of the questions in all Challenge Areas. Input is only required in the yellow fields."]
[]
[null,null,null,"2. Once all questions are answered for a topic, the Maturity Level for that Challenge Area will change to identify the current status. "]
[]
[null,null,null,"3. After all questions are answered, proceed to the Dashboard tab to see graphical representation of the current Credentialing Office efficiency and Recommendations for areas of improvement."]
[]
[null,null,null,"4. As recommendations are implemented to your Credentialing Office operations, update the relevant questions to reflect improvements."]
[]
[null,null,null,"5. The Self-Assessment and Dashboard pages can be printed to document current conditions."]
[]
[null,null,null,"Notes:"]
[]
[null,null,null,"1. Maturity Levels are a HIGH, MEDIUM, or LOW designation based on the percentage of \"Yes\" answers."]
[]
[null,null,null,"2. Maturity Levels result in the following Assessment Summaries:"]
[null,null,null,null,null,"Maturity Level",null,"Assessment Summary"]
[null,null,null,null,null,"HIGH",null,"Adequate"]
[null,null,null,null,null,"MEDIUM",null,"Needs Improvement"]
[null,null,null,null,null,"LOW",null,"Needs Immediate Attention"]
[]
[null,null,null,"3. The tool will automatically update Maturity Levels and Assessment Summaries as answers are updated."]
[]
[null,null,null,"4. Save the Self-Assessment form each time you make changes, to document progress."]
[]
[null,null,null,"5. Use the Reset button to clear all Self-Assessment answers. It is recommended that you save your work before resetting the form."]

{"sheet":"2. Self-Assessment","index":1,"n_rows":123,"n_cols":12,"rows_kept":123,"cut":false,"hidden":false,"merged":[[3,7,3,12],[70,1,70,6],[23,6,31,6],[51,6,58,6],[61,6,69,6],[6,6,9,6],[14,6,16,6],[17,6,18,6],[23,5,31,5],[34,6,41,6],[34,5,41,5],[14,1,14,3],[15,1,15,3],[59,1,59,6],[44,6,48,6],[12,1,12,3],[13,1,13,3],[72,5,76,5],[77,1,77,6],[72,6,76,6],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[117,5,120,5],[44,5,48,5],[51,5,58,5],[61,5,69,5],[10,6,13,6],[103,1,103,6],[109,1,109,6],[49,1,49,6],[117,6,120,6],[79,6,83,6],[86,6,89,6],[92,6,95,6],[98,6,102,6],[105,6,108,6],[84,1,84,6],[90,1,90,6],[96,1,96,6],[111,5,114,5],[105,5,108,5],[98,5,102,5],[86,5,89,5],[92,5,95,5],[111,6,114,6],[1,1,1,5],[122,1,122,2],[3,1,3,2],[3,3,3,4],[2,3,2,4],[4,3,4,4],[5,1,5,2],[5,3,5,4],[16,1,16,3],[17,1,17,3],[18,1,18,3],[21,1,21,6],[32,1,32,6],[115,1,115,6],[79,5,83,5],[42,1,42,6]]}
[]
[null,"Current Credentialing Office Operations and Practices",null,null,null,null,{"$f":"TODAY()","v":"2022-03-30"}]
[]
[null,"Consider each of the questions listed below as it pertains to the current state of your Credentialing Office. Use the drop-down boxes in column C to select your response. ",null,"HIDE COLUMNS",null,"The Maturity Level indicator for each area will provide a high-level assessment of your current efficiency for that area, resulting in the Assessment Summary below. ","Below are resources to help address the areas needing work. ","Hide and protect these columns."]
[null,null,null,null,null,null,null,null,null,null,"Maturity Level Formula: Yes vs No answers"]
[null,"Topic",null,null,null,"Assessment Summary","Results",null,null,null,"Threshold","Used in Formula"]
[null,"Staff Availability and Job Duty Assignments",null,null,null,{"$f":"IF(STAFFMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(STAFFMAT=\"HIGH\",\"Adequate\",IF(STAFFMAT=\"MEDIUM\",\"Needs Improvement\",IF(STAFFMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"},"The Dashboard worksheet provides graphical representation of this assessment and provides recommendations for areas of improvement.",null,null,null,"High = above 80%",0.8]
[null,"Credentialing Office Location and Layout",null,null,null,{"$f":"IF(OFFMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(OFFMAT=\"HIGH\",\"Adequate\",IF(OFFMAT=\"MEDIUM\",\"Needs Improvement\",IF(OFFMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"},null,null,null,null,"Medium = 60%-80%","(Assumed)"]
[null,"Appointments and Scheduling",null,null,null,{"$f":"IF(SCHEDMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(SCHEDMAT=\"HIGH\",\"Adequate\",IF(SCHEDMAT=\"MEDIUM\",\"Needs Improvement\",IF(SCHEDMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"},null,null,null,null,"Low - below 60%",0.6]
[null,"Authorized Signatory Responsibilities ",null,null,null,{"$f":"IF(ASMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(ASMAT=\"Not Evaluated\",\"Not Evaluated\",IF(ASMAT=\"HIGH\",\"Adequate\",IF(ASMAT=\"MEDIUM\",\"Needs Improvement\",IF(ASMAT=\"LOW\",\"Needs Immediate Attention\")))))","v":"INCOMPLETE"},null,null,null,null,"Adjust the value to affect Maturity Level Results"]
[null,"Leveraging Available Technology",null,null,null,{"$f":"IF(TECHMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(TECHMAT=\"HIGH\",\"Adequate\",IF(TECHMAT=\"MEDIUM\",\"Needs Improvement\",IF(TECHMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"},"GO TO DASHBOARD"]
[null,"Ensuring Complete and Accurate Application Submissions",null,null,null,{"$f":"IF(ACCMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(ACCMAT=\"HIGH\",\"Adequate\",IF(ACCMAT=\"MEDIUM\",\"Needs Improvement\",IF(ACCMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"}]
[null,"Document Verification",null,null,null,{"$f":"IF(VERIMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(VERIMAT=\"HIGH\",\"Adequate\",IF(VERIMAT=\"MEDIUM\",\"Needs Improvement\",IF(VERIMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"}]
[null,"Applicant Assistance (language barrier, ADA, illiteracy, etc.)",null,null,null,{"$f":"IF(ASSISTMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(ASSISTMAT=\"HIGH\",\"Adequate\",IF(ASSISTMAT=\"MEDIUM\",\"Needs Improvement\",IF(ASSISTMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"}]
[null,"Forms and Instructions",null,null,null,{"$f":"IF(FORMSMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(FORMSMAT=\"HIGH\",\"Adequate\",IF(FORMSMAT=\"MEDIUM\",\"Needs Improvement\",IF(FORMSMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"},"Keep updating your answers as you make improvements to see your progress. Save this form after each update."]
[null,"Relevant Metrics and Reporting",null,null,null,{"$f":"IF(METMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(METMAT=\"HIGH\",\"Adequate\",IF(METMAT=\"MEDIUM\",\"Needs Improvement\",IF(METMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"}]
[null,"Supporting Airport Peer Communications",null,null,null,{"$f":"IF(PEERMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(PEERMAT=\"HIGH\",\"Adequate\",IF(PEERMAT=\"MEDIUM\",\"Needs Improvement\",IF(PEERMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"}]
[null,"Effectively Implementing New Processes",null,null,null,{"$f":"IF(IMPMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(IMPMAT=\"HIGH\",\"Adequate\",IF(IMPMAT=\"MEDIUM\",\"Needs Improvement\",IF(IMPMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"},"RESET FORM (Save a Copy first)"]
[null,"Forecasting and Future Planning for Demand",null,null,null,{"$f":"IF(FUTUREMAT=\"INCOMPLETE\",\"INCOMPLETE\",IF(FUTUREMAT=\"HIGH\",\"Adequate\",IF(FUTUREMAT=\"MEDIUM\",\"Needs Improvement\",IF(FUTUREMAT=\"LOW\",\"Needs Immediate Attention\"))))","v":"INCOMPLETE"}]
[]
[null,"Assessment Questions","Responses",null,null,"Maturity Level","Resources","Category","Level","Count"]
[null,"Staffing Availability and Job Duty Assignments"]
[null,"Are Credentialing Office staffing levels sufficient to consistently meet typical credential application activity? ",null,{"$f":"IF($E23=1,\"Yes\",IF($E23=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(STAFF)>0,\"INCOMPLETE\",IF((COUNTIF(STAFF,\"Yes\")/COUNTA(STAFF))>HIGH,\"HIGH\",IF((COUNTIF(STAFF,\"Yes\")/COUNTA(STAFF))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.1","Staff availability",null,{"$f":"COUNTIFS(STAFF,\"No\",STAFFCAT:STAFFCAT,H23)","v":0}]
[null,"Are you able to manage periodic high-volume credentialing demands for contract staff, construction projects, or tenant activity?  ",null,{"$f":"IF($E24=1,\"Yes\",IF($E24=2,\"No\",\"\"))","v":""},0,"The questions in this section deal with staffing and operations of the Credentialing Office, addressing efficiencies, common processing challenges, and best-practice operations. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on improving resource utilization in Credentialing Offices by illustrating approaches for resource management, and by highlighting areas for potential improvement with automation or process refinement.","Staff availability",null,{"$f":"COUNTIFS(STAFF,\"No\",STAFFCAT:STAFFCAT,H24)","v":0}]
[null,"Do Credentialing Office processes operate smoothly with minimal bottlenecks?",null,"",0,null,null,"Operational efficiency",null,{"$f":"COUNTIFS(STAFF,\"No\",STAFFCAT:STAFFCAT,H25)","v":0}]
[null,"Are processes automated, where appropriate, to eliminate time consuming manual activities?",null,"",0,null,null,"Automation",null,{"$f":"COUNTIFS(STAFF,\"No\",STAFFCAT:STAFFCAT,H26)","v":0}]
[null,"Do you have a sufficient number of supervisors and managers to support credentialing staff?",null,"",0,null,null,"Staff development",null,{"$f":"COUNTIFS(STAFF,\"No\",STAFFCAT:STAFFCAT,H27)","v":0}]
[null,"Do you have sufficient number of Trusted Agents for credentialing operations?",null,"",0,null,null,"Staff availability",{"$f":"IF(D28=\"No\",STAFFMAT,\"\")","v":""},{"$f":"COUNTIFS(STAFF,\"No\",STAFFCAT:STAFFCAT,H28)","v":0}]
[null,"Is there documented guidance for Credentialing Office staff roles and responsibilities?",null,"",0,null,null,"Staff resources","",{"$f":"COUNTIFS(STAFF,\"No\",STAFFCAT:STAFFCAT,H29)","v":0}]
[null,"Does staff have adequate training to perform their Credentialing Office duties?",null,"",0,null,null,"Staff resources","",{"$f":"COUNTIFS(STAFF,\"No\",STAFFCAT:STAFFCAT,H30)","v":0}]
[null,"Do you have back-up staff resources (whose normal duties are in other operations or security functions) available to fill in during staff shortages?",null,"",0,null,null,"Staff availability","",{"$f":"COUNTIFS(STAFF,\"No\",STAFFCAT:STAFFCAT,H31)","v":0}]
[null,"Do you have a plan for handling peak demand when it exceeds available resources?",null,"",0,null,null,"Operational efficiency","",{"$f":"COUNTIFS(STAFF,\"No\",STAFFCAT:STAFFCAT,H32)","v":0}]
[null,"Credentialing Office Location and Layout"]
[null,"Is/are the Credentialing Office(s) in a convenient location for the majority of applicants?",null,{"$f":"IF($E34=1,\"Yes\",IF($E34=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(OFFICE)>0,\"INCOMPLETE\",IF((COUNTIF(OFFICE,\"Yes\")/COUNTA(OFFICE))>HIGH,\"HIGH\",IF((COUNTIF(OFFICE,\"Yes\")/COUNTA(OFFICE))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.2","Space planning",{"$f":"IF(D34=\"No\",OFFMAT,\"\")","v":""},{"$f":"COUNTIFS(OFFICE,\"No\",OFFICECAT:OFFICECAT,H34)","v":0}]
[null,"Is the Credentialing Office layout developed to support an effective workflow process?",null,{"$f":"IF($E35=1,\"Yes\",IF($E35=2,\"No\",\"\"))","v":""},0,"The questions in this section deal with the Credentialing Office physical space allocation, layout, and location related to its support of efficient operations and accessibility for applicants. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on optimizing Credentialing Office design and location.","Space planning","",{"$f":"COUNTIFS(OFFICE,\"No\",OFFICECAT:OFFICECAT,H35)","v":0}]
[null,"Is there sufficient space in the Credentialing Office to meet processing needs?",null,"",0,null,null,"Space planning","",{"$f":"COUNTIFS(OFFICE,\"No\",OFFICECAT:OFFICECAT,H36)","v":0}]
[null,"Do you have sufficient, dedicated training space?",null,"",0,null,null,"Training resources","",{"$f":"COUNTIFS(OFFICE,\"No\",OFFICECAT:OFFICECAT,H37)","v":0}]
[null,"Do you have sufficient, dedicated waiting space?",null,"",0,null,null,"Space planning","",{"$f":"COUNTIFS(OFFICE,\"No\",OFFICECAT:OFFICECAT,H38)","v":0}]
[null,"Does the Credentialing Office have sufficient space for back-office operations?",null,"",0,null,null,"Space planning","",{"$f":"COUNTIFS(OFFICE,\"No\",OFFICECAT:OFFICECAT,H39)","v":0}]
[null,"Is the Credentialing Office equipment easily accessible to all staff?",null,"",0,null,null,"CO workstations","",{"$f":"COUNTIFS(OFFICE,\"No\",OFFICECAT:OFFICECAT,H40)","v":0}]
[null,"Does each credentialing workstation have all peripherals required for operations?",null,"",0,null,null,"CO workstations","",{"$f":"COUNTIFS(OFFICE,\"No\",OFFICECAT:OFFICECAT,H41)","v":0}]
[null,"Do you believe the current space and layout of your Credentialing Office(s) are effective?",null,"",0,null,null,"Space planning","",{"$f":"COUNTIFS(OFFICE,\"No\",OFFICECAT:OFFICECAT,H42)","v":0}]
[null,"Appointments & Scheduling"]
[null,"Do applicants have easy access to information needed for the badge application process without staff interaction? ",null,{"$f":"IF($E44=1,\"Yes\",IF($E44=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(SCHED)>0,\"INCOMPLETE\",IF((COUNTIF(SCHED,\"Yes\")/COUNTA(SCHED))>HIGH,\"HIGH\",IF((COUNTIF(SCHED,\"Yes\")/COUNTA(SCHED))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.3","Employee resources",{"$f":"IF(D44=\"No\",SCHEDMAT,\"\")","v":""},{"$f":"COUNTIFS(SCHED,\"No\",SCHEDCAT:SCHEDCAT,H44)","v":0}]
[null,"Can applicants schedule appointments without Credentialing Office staff involvement?",null,{"$f":"IF($E45=1,\"Yes\",IF($E45=2,\"No\",\"\"))","v":""},0,"The questions in this section deal with appointments and scheduling for credentialing activities, related to effective operations, applicant coordination and timely processing. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section provides a review of challenges related to appointments and scheduling, methods airports have used to overcome those challenges, and available alternatives.","Scheduling process","",{"$f":"COUNTIFS(SCHED,\"No\",SCHEDCAT:SCHEDCAT,H45)","v":0}]
[null,"Does your credentialing policy address appointment “no-shows” to reduce the negative impact on operations?",null,"",0,null,null,"Scheduling process","",{"$f":"COUNTIFS(SCHED,\"No\",SCHEDCAT:SCHEDCAT,H46)","v":0}]
[null,"Does your credentialing operation have a policy or process to effectively address walk-in clients?",null,"",0,null,null,"Scheduling","",{"$f":"COUNTIFS(SCHED,\"No\",SCHEDCAT:SCHEDCAT,H47)","v":0}]
[null,"Is your Credentialing Office able to effectively manage waiting clients when they come in for services?",null,"",0,null,null,"Scheduling process","",{"$f":"COUNTIFS(SCHED,\"No\",SCHEDCAT:SCHEDCAT,H48)","v":0}]
[null,"Do you have a process to effectively remind badgeholders of pending renewal dates?",null,"",0,null,null,"Scheduling process","",{"$f":"COUNTIFS(SCHED,\"No\",SCHEDCAT:SCHEDCAT,H49)","v":0}]
[null,"Authorized Signatory Responsibilities "]
[null,"Do you use an Authorized Signatory for security badge applications? (If No, do not answer the rest of this section.)",null,{"$f":"IF($E51=1,\"Yes\",IF($E51=2,\"No\",\"\"))","v":""},0,{"$f":"IF(D51=\"No\",\"Not Evaluated\",IF(COUNTBLANK(AUTHSIG)>0,\"INCOMPLETE\",IF((COUNTIF(AUTHSIG,\"Yes\")/COUNTA(AUTHSIG))>HIGH,\"HIGH\",IF((COUNTIF(AUTHSIG,\"Yes\")/COUNTA(AUTHSIG))>LOW,\"MEDIUM\",\"LOW\"))))","v":"INCOMPLETE"},"REPORT SECTION 2.4",null,{"$f":"IF(D51=\"No\",ASMAT,\"\")","v":""},{"$f":"COUNTIFS(AUTHSIG,\"No\",AUTHCAT:AUTHCAT,H51)","v":{"$error":"#VALUE!"}}]
[null,"Do Authorized Signatory applicants have easy access to Authorized Signatory roles and responsibilities information without staff interaction?",null,{"$f":"IF($E52=1,\"Yes\",IF($E52=2,\"No\",\"\"))","v":""},0,"The questions in this section deal with coordination of Authorized Signatories related to effective credentialing operations, applicant coordination, and accurate processing. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on methods for successful Authorized Signatory program implementation and identifying strategies used to ensure Authorized Signatory compliance.","AS Technology","",{"$f":"COUNTIFS(AUTHSIG,\"No\",AUTHCAT:AUTHCAT,H52)","v":{"$error":"#VALUE!"}}]
[null,"Does the Credentialing Office provide specific training for the Authorized Signatory?",null,"",0,null,null,"AS Policy","",{"$f":"COUNTIFS(AUTHSIG,\"No\",AUTHCAT:AUTHCAT,H53)","v":{"$error":"#VALUE!"}}]
[null,"Is the training provided online?",null,"",0,null,null,"AS Engagement","",{"$f":"COUNTIFS(AUTHSIG,\"No\",AUTHCAT:AUTHCAT,H54)","v":{"$error":"#VALUE!"}}]
[null,"Does Authorized Signatory recertification involve training? ",null,"",0,null,null,"AS Policy","",{"$f":"COUNTIFS(AUTHSIG,\"No\",AUTHCAT:AUTHCAT,H55)","v":{"$error":"#VALUE!"}}]
[null,"Are pre-defined access privileges listed for the Authorized Signatory to assign to applicants? ",null,"",0,null,null,"AS Engagement","",{"$f":"COUNTIFS(AUTHSIG,\"No\",AUTHCAT:AUTHCAT,H56)","v":{"$error":"#VALUE!"}}]
[null,"Is the Authorized Signatory fully responsible for the application process of their employees?",null,"",0,null,null,"AS Engagement","",{"$f":"COUNTIFS(AUTHSIG,\"No\",AUTHCAT:AUTHCAT,H57)","v":{"$error":"#VALUE!"}}]
[null,"Do you have an effective means of communication with the Authorized Signatory for credentialing matters?",null,"",0,null,null,"AS Technology","",{"$f":"COUNTIFS(AUTHSIG,\"No\",AUTHCAT:AUTHCAT,H58)","v":{"$error":"#VALUE!"}}]
[null,"Do you have procedures in place to ensure/enforce  Authorized Signatories perform their roles and responsbilities accordingly?",null,"",0,null,null,"AS Engagement","",{"$f":"COUNTIFS(AUTHSIG,\"No\",AUTHCAT:AUTHCAT,H59)","v":{"$error":"#VALUE!"}}]
[null,"Leveraging Available Technology"]
[null,"Does your credentialing process provide a single point of data entry for all systems?",null,{"$f":"IF($E61=1,\"Yes\",IF($E61=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(TECH)>0,\"INCOMPLETE\",IF((COUNTIF(TECH,\"Yes\")/COUNTA(TECH))>HIGH,\"HIGH\",IF((COUNTIF(TECH,\"Yes\")/COUNTA(TECH))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.5","Tech Optimization",{"$f":"IF(D61=\"No\",TECHMAT,\"\")","v":""},{"$f":"COUNTIFS(TECH,\"No\",TECHCAT:TECHCAT,H61)","v":0}]
[null,"Is your current background check request process automated?",null,{"$f":"IF($E62=1,\"Yes\",IF($E62=2,\"No\",\"\"))","v":""},0,"The questions in this section deal with the use of current technologies and systems to support credentialing operations. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on identifying the types of technologies being implemented in Credentialing Offices, as well as adaptation issues or impediments for the use of technology.","Automation","",{"$f":"COUNTIFS(TECH,\"No\",TECHCAT:TECHCAT,H62)","v":0}]
[null,"Does your current fingerprinting process meet your needs?",null,"",0,null,null,"Tech Optimization","",{"$f":"COUNTIFS(TECH,\"No\",TECHCAT:TECHCAT,H63)","v":0}]
[null,"Does your current privilege management solution for access control meet your needs?",null,"",0,null,null,"Tech Optimization","",{"$f":"COUNTIFS(TECH,\"No\",TECHCAT:TECHCAT,H64)","v":0}]
[null,"Does your airside driver privilege management solution meet your needs?",null,"",0,null,null,"Tech Optimization","",{"$f":"COUNTIFS(TECH,\"No\",TECHCAT:TECHCAT,H65)","v":0}]
[null,"Does your current No Fly List solution meet your needs?",null,"",0,null,null,"Tech Optimization","",{"$f":"COUNTIFS(TECH,\"No\",TECHCAT:TECHCAT,H66)","v":0}]
[null,"Do you utilize a Computer Based Training (CBT) solution? ",null,"",0,null,null,"Tech Optimization","",{"$f":"COUNTIFS(TECH,\"No\",TECHCAT:TECHCAT,H67)","v":0}]
[null,"Does your training solution automatically notify your credentialing system of completed training?",null,"",0,null,null,"Automation","",{"$f":"COUNTIFS(TECH,\"No\",TECHCAT:TECHCAT,H68)","v":0}]
[null,"Does your appointment management solution meet your needs?",null,"",0,null,null,"Tech Optimization","",{"$f":"COUNTIFS(TECH,\"No\",TECHCAT:TECHCAT,H69)","v":0}]
[null,"Do you believe the credentialing process has too many manual processes?",null,"",0,null,null,"Tech Optimization","",{"$f":"COUNTIFS(TECH,\"No\",TECHCAT:TECHCAT,H70)","v":0}]
[null,"Ensuring Complete and Accurate Application Submissions"]
[null,"Do you believe your processes provides sufficient control for badge application accuracy? ",null,{"$f":"IF($E72=1,\"Yes\",IF($E72=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(ACCURACY)>0,\"INCOMPLETE\",IF((COUNTIF(ACCURACY,\"Yes\")/COUNTA(ACCURACY))>HIGH,\"HIGH\",IF((COUNTIF(ACCURACY,\"Yes\")/COUNTA(ACCURACY))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.6","Applicant engagement",{"$f":"IF(D72=\"No\",ACCMAT,\"\")","v":""},{"$f":"COUNTIFS(ACCURACY,\"No\",ACCUCAT:ACCUCAT,H72)","v":0}]
[null,"Do you keep metrics on application form errors or omissions?",null,{"$f":"IF($E73=1,\"Yes\",IF($E73=2,\"No\",\"\"))","v":""},0,"The questions in this section deal with methods to help insure application forms accuracy and completeness. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on incomplete and inaccurate submissions to the Credentialing Office, including understanding the scope of the issue, examining associated responsibilities, and documenting strategies to best address the issue. ","Forms Accuracy","",{"$f":"COUNTIFS(ACCURACY,\"No\",ACCUCAT:ACCUCAT,H73)","v":0}]
[null,"Do you believe the current process is sufficient to reduce application form errors?",null,"",0,null,null,"Forms Accuracy","",{"$f":"COUNTIFS(ACCURACY,\"No\",ACCUCAT:ACCUCAT,H74)","v":0}]
[null,"Does your Credentialing Office manual and training provide guidance to promote more accurate applications?",null,"",0,null,null,"Forms Accuracy","",{"$f":"COUNTIFS(ACCURACY,\"No\",ACCUCAT:ACCUCAT,H75)","v":0}]
[null,"Do you utilize field-fillable electronic PDF application forms to minimize errors where appropriate?",null,"",0,null,null,"Forms","",{"$f":"COUNTIFS(ACCURACY,\"No\",ACCUCAT:ACCUCAT,H76)","v":0}]
[null,"Do you track the most common mistakes made on application forms?",null,"",0,null,null,"Forms Accuracy","",{"$f":"COUNTIFS(ACCURACY,\"No\",ACCUCAT:ACCUCAT,H77)","v":0}]
[null,"Document Verification"]
[null,"Do you carry out regular audits or reviews of your document verification processes?",null,{"$f":"IF($E79=1,\"Yes\",IF($E79=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(VERIFI)>0,\"INCOMPLETE\",IF(((COUNTIF(VERIFI,\"Yes\")+1)/COUNTA(VERIFI))>HIGH,\"HIGH\",IF(((COUNTIF(VERIFI,\"Yes\")+3)/COUNTA(VERIFI))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.7","Document verify",{"$f":"IF(D79=\"No\",VERIMAT,\"\")","v":""},{"$f":"COUNTIFS(VERIFI,\"No\",VERIFICAT:VERIFICAT,H79)","v":0}]
[null,"Does staff receive training on proper document and identification verification methods?",null,{"$f":"IF($E80=1,\"Yes\",IF($E80=2,\"No\",\"\"))","v":""},0,"The questions in this section deal with methods and processes to verify applicant Identification Documentation. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on gathering methods utilized by COs to equip staff with the knowledge and tools needed to efficiently and adequately verify applicants’ identity documents.","Document verify",{"$f":"IF(D80=\"No\",VERIMAT,\"\")","v":""},{"$f":"COUNTIFS(VERIFI,\"No\",VERIFICAT:VERIFICAT,H80)","v":0}]
[null,"Do you have other resources, such as CBP, to assist in training and verification processes?",null,"",0,null,null,"Document verify",{"$f":"IF(D81=\"No\",VERIMAT,\"\")","v":""},{"$f":"COUNTIFS(VERIFI,\"No\",VERIFICAT:VERIFICAT,H81)","v":0}]
[null,"Do you have a documented process for application document verification?",null,"",0,null,null,"Document verify",{"$f":"IF(D82=\"No\",VERIMAT,\"\")","v":""},{"$f":"COUNTIFS(VERIFI,\"No\",VERIFICAT:VERIFICAT,H82)","v":0}]
[null,"Are fraudulent documents typically caught before the security badge has been issued?",null,"",0,null,null,"Document verify"]
[null,"Are staff provided training to help identify imposter documents?",null,"",0,null,null,"Document verify",{"$f":"IF(D84=\"No\",VERIMAT,\"\")","v":""},{"$f":"COUNTIFS(VERIFI,\"No\",VERIFICAT:VERIFICAT,H84)","v":0}]
[null,"Applicant Assistance (language barrier, ADA, illiteracy, etc.)"]
[null,"Do you provide staff training for Americans With Disabilities (ADA) Customer Service?",null,{"$f":"IF($E86=1,\"Yes\",IF($E86=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(ASSIST)>0,\"INCOMPLETE\",IF(((COUNTIF(ASSIST,\"Yes\")+2)/COUNTA(ASSIST))>HIGH,\"HIGH\",IF(((COUNTIF(ASSIST,\"Yes\")+5)/COUNTA(ASSIST))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.8","ADA resources",{"$f":"IF(D86=\"No\",ASSISTMAT,\"\")","v":""},{"$f":"COUNTIFS(ASSIST,\"No\",ASSISTCAT:ASSISTCAT,H86)","v":0}]
[null,"Does access to the Credentialing Office accommodate individuals in a wheelchair?",null,{"$f":"IF($E87=1,\"Yes\",IF($E87=2,\"No\",\"\"))","v":""},0,"The questions in this section deal with accessibility assistance for applicants with disabilities. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on identifying gaps where resources may be needed to improve operational efficiency when working with applicants who need additional assistance.  ","ADA accessibility",{"$f":"IF(D87=\"No\",ASSISTMAT,\"\")","v":""},{"$f":"COUNTIFS(ASSIST,\"No\",ASSISTCAT:ASSISTCAT,H87)","v":0}]
[null,"Do credentialing workstation configurations accommodate individuals in a wheelchair?",null,"",0,null,null,"ADA accessibility",{"$f":"IF(D88=\"No\",ASSISTMAT,\"\")","v":""},{"$f":"COUNTIFS(ASSIST,\"No\",ASSISTCAT:ASSISTCAT,H88)","v":0}]
[null,"Does the Credentialing Office provide large font documents for individuals with reduced eyesight?",null,"",0,null,null,"ADA accessibility",{"$f":"IF(D89=\"No\",ASSISTMAT,\"\")","v":""},{"$f":"COUNTIFS(ASSIST,\"No\",ASSISTCAT:ASSISTCAT,H89)","v":0}]
[null,"Does the Credentialing Office provide language assistance services such as interpreters and multi-lingual instructions?",null,"",0,null,null,"Language",{"$f":"IF(D90=\"No\",ASSISTMAT,\"\")","v":""},{"$f":"COUNTIFS(ASSIST,\"No\",ASSISTCAT:ASSISTCAT,H90)","v":0}]
[null,"Forms and Instructions"]
[null,"Do you have a single, unified form for all badge applications and renewals?",null,{"$f":"IF($E92=1,\"Yes\",IF($E92=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(FORMS)>0,\"INCOMPLETE\",IF(((COUNTIF(FORMS,\"Yes\")+1)/COUNTA(FORMS))>HIGH,\"HIGH\",IF(((COUNTIF(FORMS,\"Yes\")+2)/COUNTA(FORMS))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.9","Forms",{"$f":"IF(D92=\"No\",FORMSMAT,\"\")","v":""},{"$f":"COUNTIFS(FORMS,\"No\",FORMSCAT:FORMSCAT,H92)","v":0}]
[null,"Does your application provide a list of acceptable applicant identifications for badge applications?",null,{"$f":"IF($E93=1,\"Yes\",IF($E93=2,\"No\",\"\"))","v":""},0,"The questions in this section are related to forms, templates and support documents used in credentialing operations. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on identifying the various methods used by airports to collect applicant data, and helping the Credentialing Office modify forms to improve processing efficiencies. ","Forms","",{"$f":"COUNTIFS(FORMS,\"No\",FORMSCAT:FORMSCAT,H93)","v":0}]
[null,"Are your badge application and instructions available in common non-English languages for your area?",null,"",0,null,null,"Language","",{"$f":"COUNTIFS(FORMS,\"No\",FORMSCAT:FORMSCAT,H94)","v":0}]
[null,"Are all forms and instructions available on your airport website?",null,"",0,null,null,"Forms","",{"$f":"COUNTIFS(FORMS,\"No\",FORMSCAT:FORMSCAT,H95)","v":0}]
[null,"Are all forms field-fillable and submitted electronically?",null,"",0,null,null,"Forms","",{"$f":"COUNTIFS(FORMS,\"No\",FORMSCAT:FORMSCAT,H96)","v":0}]
[null,"Relevant Metrics and Reporting"]
[null,"Do you prepare metrics to help monitor and evaluate your credentialing process efficiency?",null,{"$f":"IF($E98=1,\"Yes\",IF($E98=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(METRICS)>0,\"INCOMPLETE\",IF(((COUNTIF(METRICS,\"Yes\")+1)/COUNTA(METRICS))>HIGH,\"HIGH\",IF(((COUNTIF(METRICS,\"Yes\")+2)/COUNTA(METRICS))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.10","Metrics",{"$f":"IF(D98=\"No\",METMAT,\"\")","v":""},{"$f":"COUNTIFS(METRICS,\"No\",METCAT:METCAT,H98)","v":0}]
[null,"Are these metrics shared with airport management?",null,{"$f":"IF($E99=1,\"Yes\",IF($E99=2,\"No\",\"\"))","v":""},0,"The questions in this section are consider reporting and metrics use to monitor the performance of the credentialing operations. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on determining how captured data is used by airports and identifying additional opportunities for reporting.","Metrics","",{"$f":"COUNTIFS(METRICS,\"No\",METCAT:METCAT,H99)","v":0}]
[null,"Are you able to easily access data and create reports to assist credentialing operations?",null,"",0,null,null,"Metrics","",{"$f":"COUNTIFS(METRICS,\"No\",METCAT:METCAT,H100)","v":0}]
[null,"Are you able to easily create reports to assist with badge audits?",null,"",0,null,null,"Audit"]
[null,"Do your systems provide the reports you need without external software or processes?",null,"",0,null,null,"Metrics","",{"$f":"COUNTIFS(METRICS,\"No\",METCAT:METCAT,H102)","v":0}]
[null,"Do you feel you have adequate reporting capabilities for credential management activities?",null,"",0,null,null,"Staff engagement","",{"$f":"COUNTIFS(METRICS,\"No\",METCAT:METCAT,H103)","v":0}]
[null,"Supporting Airport Peer Communications"]
[null,"Do you currently interact with other airports to share information on credentialing process and challenges?",null,{"$f":"IF($E105=1,\"Yes\",IF($E105=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(PEER)>0,\"INCOMPLETE\",IF((COUNTIF(PEER,\"Yes\")/COUNTA(PEER))>HIGH,\"HIGH\",IF((COUNTIF(PEER,\"Yes\")/COUNTA(PEER))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.11","Peer groups",{"$f":"IF(D105=\"No\",PEERMAT,\"\")","v":""},{"$f":"COUNTIFS(PEER,\"No\",PEERCAT:PEERCAT,H105)","v":0}]
[null,"Do you believe airport peers provide effective information to assist in development of your Credentialing Operations?",null,{"$f":"IF($E106=1,\"Yes\",IF($E106=2,\"No\",\"\"))","v":""},0,"The questions in this section identify peer collaboration activities to support credentialing operations development. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on strategies that airports can utilize to expand peer communications and further promote industry collaboration.","Peer resources","",{"$f":"COUNTIFS(PEER,\"No\",PEERCAT:PEERCAT,H106)","v":0}]
[null,"Do you or have you used the Homeland Security Information Network for information on credential processing?",null,"",0,null,null,"Peer resources","",{"$f":"COUNTIFS(PEER,\"No\",PEERCAT:PEERCAT,H107)","v":0}]
[null,"Has your operation been able to contribute to the development of other airports' credentialing services?",null,"",0,null,null,"Peer groups","",{"$f":"COUNTIFS(PEER,\"No\",PEERCAT:PEERCAT,H108)","v":0}]
[null,"Do you have access to an airport peer group for your region?",null,"",0,null,null,"Peer resources","",{"$f":"COUNTIFS(PEER,\"No\",PEERCAT:PEERCAT,H109)","v":0}]
[null,"Effectively Implementing New Processes"]
[null,"Do you have a formal program for reviewing and updating business processes on a periodic basis?",null,{"$f":"IF($E111=1,\"Yes\",IF($E111=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(IMPL)>0,\"INCOMPLETE\",IF((COUNTIF(IMPL,\"Yes\")/COUNTA(IMPL))>HIGH,\"HIGH\",IF((COUNTIF(IMPL,\"Yes\")/COUNTA(IMPL))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.12","Operational efficiency",{"$f":"IF(D111=\"No\",IMPMAT,\"\")","v":""},{"$f":"COUNTIFS(IMPL,\"No\",IMPLCAT:IMPLCAT,H111)","v":0}]
[null,"Has the Credentialing Office ever engaged in a business process review?",null,{"$f":"IF($E112=1,\"Yes\",IF($E112=2,\"No\",\"\"))","v":""},0,"The questions in this section consider activities that review and develop credentialing operations processes. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on identifying and determining the effectiveness of common best practices utilized by airports for implementing new processes. ","Operational efficiency","",{"$f":"COUNTIFS(IMPL,\"No\",IMPLCAT:IMPLCAT,H112)","v":0}]
[null,"Do you provide surveys to airport employees for feedback on Credentialing Office operations?",null,"",0,null,null,"Applicant engagement","",{"$f":"COUNTIFS(IMPL,\"No\",IMPLCAT:IMPLCAT,H113)","v":0}]
[null,"Do you have a means for Credentialing Office staff to provide input on operational efficiency? ",null,"",0,null,null,"Staff engagement","",{"$f":"COUNTIFS(IMPL,\"No\",IMPLCAT:IMPLCAT,H114)","v":0}]
[null,"Do you conduct reviews to ensure new processes have been fully implemented? ",null,"",0,null,null,"Operational efficiency","",{"$f":"COUNTIFS(IMPL,\"No\",IMPLCAT:IMPLCAT,H115)","v":0}]
[null,"Forecasting and Future Planning for Demand"]
[null,"Do you have a process to accommodate a mass enrollment for a project that requires a large number of security badges to be issued?",null,{"$f":"IF($E117=1,\"Yes\",IF($E117=2,\"No\",\"\"))","v":""},0,{"$f":"IF(COUNTBLANK(FUTURE)>0,\"INCOMPLETE\",IF((COUNTIF(FUTURE,\"Yes\")/COUNTA(FUTURE))>HIGH,\"HIGH\",IF((COUNTIF(FUTURE,\"Yes\")/COUNTA(FUTURE))>LOW,\"MEDIUM\",\"LOW\")))","v":"INCOMPLETE"},"REPORT SECTION 2.13","Forecasting",{"$f":"IF(D117=\"No\",FUTUREMAT,\"\")","v":""},{"$f":"COUNTIFS(FUTURE,\"No\",FUTCAT:FUTCAT,H117)","v":0}]
[null,"Do other airport departments (such as procurement, properties, engineering, capital program office, etc.) provide input to assist you with forecasting demand?",null,{"$f":"IF($E118=1,\"Yes\",IF($E118=2,\"No\",\"\"))","v":""},0,"The questions in this section address forecasting activities to identify future increases in credentialing demands. A higher number of negative responses drives the Maturity Level down, indicating opportunities for improvement.","This section focuses on methods to plan for and manage staff demand to increase operational efficiency. ","Forecasting","",{"$f":"COUNTIFS(FUTURE,\"No\",FUTCAT:FUTCAT,H118)","v":0}]
[null,"Do you incorporate upcoming credentialing activity into your Credentialing Office staffing level planning?",null,"",0,null,null,"Forecasting","",{"$f":"COUNTIFS(FUTURE,\"No\",FUTCAT:FUTCAT,H119)","v":0}]
[null,"Do you have a resource for forecasting expected credentialing demand growth as well as future mass enrollment events?",null,"",0,null,null,"Forecasting","",{"$f":"COUNTIFS(FUTURE,\"No\",FUTCAT:FUTCAT,H120)","v":0}]
[null,"Do airport tenants and employers provide input to assist you with forecasting? ",null,"",0,null,null,"Forecasting","",{"$f":"COUNTIFS(FUTURE,\"No\",FUTCAT:FUTCAT,H121)","v":0}]
[]
[null,"ONCE YOU HAVE COMPLETED THIS SURVEY YOU CAN:"]

{"sheet":"3. Dashboard","index":2,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":false,"merged":[[27,1,27,3],[1,1,1,2]]}
[]
[null,"Credentialing Office Development Dashboard",null,{"$f":"TODAY()","v":"2022-03-30"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"As recommendations are implemented, update the appropriate responses on the Self-Assessment workseet to see improvements.",null,"RETURN TO Self-asssessment Sheet"]
[]
[null,"RECOMMENDATIONS"]
[null,"NEEDS IMMEDIATE ATTENTION","NEEDS IMPROVEMENT","ADEQUATE"]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(1:1))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(1:1))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(1:1))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(2:2))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(2:2))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(2:2))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(3:3))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(3:3))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(3:3))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(4:4))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(4:4))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(4:4))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(5:5))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(5:5))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(5:5))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(6:6))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(6:6))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(6:6))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(7:7))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(7:7))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(7:7))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(8:8))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(8:8))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(8:8))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(9:9))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(9:9))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(9:9))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(10:10))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(10:10))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(10:10))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(11:11))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(11:11))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(11:11))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(12:12))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(12:12))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(12:12))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(13:13))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(13:13))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(13:13))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(14:14))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(14:14))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(14:14))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(15:15))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(15:15))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(15:15))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(16:16))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(16:16))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(16:16))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(17:17))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(17:17))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(17:17))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(18:18))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(18:18))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(18:18))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(19:19))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(19:19))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(19:19))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(20:20))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(20:20))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(20:20))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(21:21))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(21:21))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(21:21))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(22:22))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(22:22))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(22:22))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(23:23))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(23:23))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(23:23))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(LOWREC,SMALL(IF(\"\"=LOWREC,\"\",ROW(LOWREC)-ROW(LRSTART)+1),ROW(24:24))),\"\")","v":""},{"$f":"IFERROR(INDEX(MEDREC,SMALL(IF(\"\"=MEDREC,\"\",ROW(MEDREC)-ROW(MRSTART)+1),ROW(24:24))),\"\")","v":""},{"$f":"IFERROR(INDEX(HIREC,SMALL(IF(\"\"=HIREC,\"\",ROW(HIREC)-ROW(HRSTART)+1),ROW(24:24))),\"\")","v":""}]

{"sheet":"(Worksheet)","index":3,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":true,"merged":[[1,1,1,4]]}
[null,null,null,null,"THIS WORKSHEET WILL BE HIDDEN"]
[null,"RECOMMENDATION LIST"]
[]
[null,"Category","Count","Level","Recommendation",null,"Area","Needs Immediate Attention","NA1","NA2","Needs Improvement","NA3","NA4","Adequate","NA5","NA6","Status"]
[1,"Staff resources",{"$f":"COUNTIF(CAT,B5)","v":2},{"$f":"_xlfn.XLOOKUP(B5,RESPCAT,RESPLEV,\"\",0)","v":{"$error":"#NAME?"}},"Develop staff self-assessment procedures to increase operational proficiency",null,"Staffing Availability & Job Duty Assignments",{"$f":"IF(STAFFMAT=\"LOW\",(COUNTIF(STAFF,\"Yes\")/COUNTA(STAFF))*10,\"\")","v":""},null,null,{"$f":"IF(STAFFMAT=\"MEDIUM\",(COUNTIF(STAFF,\"Yes\")/COUNTA(STAFF))*10,\"\")","v":""},null,null,{"$f":"IF(STAFFMAT=\"HIGH\",(COUNTIF(STAFF,\"Yes\")/COUNTA(STAFF))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F7","v":"INCOMPLETE"}]
[2,"Operational efficiency",2,{"$error":"#NAME?"},"Develop operations improvement program to regulary review processes for effectiveness",null,"Credentialing Office Location & Layout",{"$f":"IF(OFFMAT=\"LOW\",(COUNTIF(OFFICE,\"Yes\")/COUNTA(OFFICE))*10,\"\")","v":""},null,null,{"$f":"IF(OFFMAT=\"MEDIUM\",(COUNTIF(OFFICE,\"Yes\")/COUNTA(OFFICE))*10,\"\")","v":""},null,null,{"$f":"IF(OFFMAT=\"HIGH\",(COUNTIF(OFFICE,\"Yes\")/COUNTA(OFFICE))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F8","v":"INCOMPLETE"}]
[3,"Applicant resources",1,{"$error":"#NAME?"},"Develop applicant self-service tools to free up CO staff",null,"Appointments & Scheduling",{"$f":"IF(SCHEDMAT=\"LOW\",(COUNTIF(SCHED,\"Yes\")/COUNTA(SCHED))*10,\"\")","v":""},null,null,{"$f":"IF(SCHEDMAT=\"MEDIUM\",(COUNTIF(SCHED,\"Yes\")/COUNTA(SCHED))*10,\"\")","v":""},null,null,{"$f":"IF(SCHEDMAT=\"HIGH\",(COUNTIF(SCHED,\"Yes\")/COUNTA(SCHED))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F9","v":"INCOMPLETE"}]
[4,"Forms",2,{"$error":"#NAME?"},"Develop electronically fillable forms and submission",null,{"$f":"IF('2. Self-Assessment'!D51=\"No\",\"*Authorized Signatory Not Evaluated\",\"Authorized Signatory Responsibilities\")","v":"Authorized Signatory Responsibilities"},{"$f":"IF('2. Self-Assessment'!D51=\"No\",\"\",IF(ASMAT=\"LOW\",(COUNTIF(AUTHSIG,\"Yes\")/COUNTA(AUTHSIG))*10,\"\"))","v":""},null,null,{"$f":"IF('2. Self-Assessment'!D51=\"No\",\"\",IF(ASMAT=\"MEDIUM\",(COUNTIF(AUTHSIG,\"Yes\")/COUNTA(AUTHSIG))*10,\"\"))","v":""},null,null,{"$f":"IF('2. Self-Assessment'!D51=\"No\",\"\",IF(ASMAT=\"HIGH\",(COUNTIF(AUTHSIG,\"Yes\")/COUNTA(AUTHSIG))*10,\"\"))","v":""},null,null,{"$f":"'2. Self-Assessment'!$F10","v":"INCOMPLETE"}]
[5,"Staff resources",2,{"$error":"#NAME?"},"Expand Credentialing Office staff training resources",null,"Leveraging Available Technology",{"$f":"IF(TECHMAT=\"LOW\",(COUNTIF(TECH,\"Yes\")/COUNTA(TECH))*10,\"\")","v":""},null,null,{"$f":"IF(TECHMAT=\"MEDIUM\",(COUNTIF(TECH,\"Yes\")/COUNTA(TECH))*10,\"\")","v":""},null,null,{"$f":"IF(TECHMAT=\"HIGH\",(COUNTIF(TECH,\"Yes\")/COUNTA(TECH))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F11","v":"INCOMPLETE"}]
[6,"Operational efficiency",2,{"$error":"#NAME?"},"Assign dedicated Credentialing Office staff responsibilities",null,"Application Completeness & Accuracy",{"$f":"IF(ACCMAT=\"LOW\",(COUNTIF(ACCURACY,\"Yes\")/COUNTA(ACCURACY))*10,\"\")","v":""},null,null,{"$f":"IF(ACCMAT=\"MEDIUM\",(COUNTIF(ACCURACY,\"Yes\")/COUNTA(ACCURACY))*10,\"\")","v":""},null,null,{"$f":"IF(ACCMAT=\"HIGH\",(COUNTIF(ACCURACY,\"Yes\")/COUNTA(ACCURACY))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F12","v":"INCOMPLETE"}]
[7,"Staff availability",2,{"$error":"#NAME?"},"Develop a strong hiring & retention program to reduce staff turnover",null,"Document Verification",{"$f":"IF(VERIMAT=\"LOW\",(COUNTIF(VERIFI,\"Yes\")/COUNTA(VERIFI))*10,\"\")","v":""},null,null,{"$f":"IF(VERIMAT=\"MEDIUM\",(COUNTIF(VERIFI,\"Yes\")/COUNTA(VERIFI))*10,\"\")","v":""},null,null,{"$f":"IF(VERIMAT=\"HIGH\",(COUNTIF(VERIFI,\"Yes\")/COUNTA(VERIFI))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F13","v":"INCOMPLETE"}]
[8,"Staff availability",2,{"$error":"#NAME?"},"Cross-train non-credentialling staff to support busy times",null,"Applicant Assistance ",{"$f":"IF(ASSISTMAT=\"LOW\",(COUNTIF(ASSIST,\"Yes\")/COUNTA(ASSIST))*10,\"\")","v":""},null,null,{"$f":"IF(ASSISTMAT=\"MEDIUM\",(COUNTIF(ASSIST,\"Yes\")/COUNTA(ASSIST))*10,\"\")","v":""},null,null,{"$f":"IF(ASSISTMAT=\"HIGH\",(COUNTIF(ASSIST,\"Yes\")/COUNTA(ASSIST))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F14","v":"INCOMPLETE"}]
[9,"Staff development",1,{"$error":"#NAME?"},"Develop staff succession planning program to support position replacement and growth",null,"Forms & Instructions",{"$f":"IF(FORMSMAT=\"LOW\",(COUNTIF(FORMS,\"Yes\")/COUNTA(FORMS))*10,\"\")","v":""},null,null,{"$f":"IF(FORMSMAT=\"MEDIUM\",(COUNTIF(FORMS,\"Yes\")/COUNTA(FORMS))*10,\"\")","v":""},null,null,{"$f":"IF(FORMSMAT=\"HIGH\",(COUNTIF(FORMS,\"Yes\")/COUNTA(FORMS))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F15","v":"INCOMPLETE"}]
[10,null,0,{"$error":"#NAME?"},null,null,"Relevant Metrics & Reporting",{"$f":"IF(METMAT=\"LOW\",(COUNTIF(METRICS,\"Yes\")/COUNTA(METRICS))*10,\"\")","v":""},null,null,{"$f":"IF(METMAT=\"MEDIUM\",(COUNTIF(METRICS,\"Yes\")/COUNTA(METRICS))*10,\"\")","v":""},null,null,{"$f":"IF(METMAT=\"HIGH\",(COUNTIF(METRICS,\"Yes\")/COUNTA(METRICS))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F16","v":"INCOMPLETE"}]
[11,"Space planning",2,{"$error":"#NAME?"},"Review space allocation needs for each credentialing activity",null,"Supporting Airport Peer Communications",{"$f":"IF(PEERMAT=\"LOW\",(COUNTIF(PEER,\"Yes\")/COUNTA(PEER))*10,\"\")","v":""},null,null,{"$f":"IF(PEERMAT=\"MEDIUM\",(COUNTIF(PEER,\"Yes\")/COUNTA(PEER))*10,\"\")","v":""},null,null,{"$f":"IF(PEERMAT=\"HIGH\",(COUNTIF(PEER,\"Yes\")/COUNTA(PEER))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F17","v":"INCOMPLETE"}]
[12,"Space planning",2,{"$error":"#NAME?"},"Identify effective location for Credentialing Office resources",null,"Effectively Implementing New Processes",{"$f":"IF(IMPMAT=\"LOW\",(COUNTIF(IMPL,\"Yes\")/COUNTA(IMPL))*10,\"\")","v":""},null,null,{"$f":"IF(IMPMAT=\"MEDIUM\",(COUNTIF(IMPL,\"Yes\")/COUNTA(IMPL))*10,\"\")","v":""},null,null,{"$f":"IF(IMPMAT=\"HIGH\",(COUNTIF(IMPL,\"Yes\")/COUNTA(IMPL))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F18","v":"INCOMPLETE"}]
[13,"CO workstations",1,{"$error":"#NAME?"},"Develop credentialling workstations to provide all resources",null,"Forecasting & Future Planning for Demand ",{"$f":"IF(FUTUREMAT=\"LOW\",(COUNTIF(FUTURE,\"Yes\")/COUNTA(FUTURE))*10,\"\")","v":""},null,null,{"$f":"IF(FUTUREMAT=\"MEDIUM\",(COUNTIF(FUTURE,\"Yes\")/COUNTA(FUTURE))*10,\"\")","v":""},null,null,{"$f":"IF(FUTUREMAT=\"HIGH\",(COUNTIF(FUTURE,\"Yes\")/COUNTA(FUTURE))*10,\"\")","v":""},null,null,{"$f":"'2. Self-Assessment'!$F19","v":"INCOMPLETE"}]
[14,"Training resources",2,{"$error":"#NAME?"},"Develop remote CBT training center to free up CO space and improve employee access"]
[15,"Training resources",2,{"$error":"#NAME?"},"Develop on-line training resources to reduce staff involvement and free up CO space",null,"RESPCAT","Column of response categories"]
[16,"Scheduling tools",2,{"$error":"#NAME?"},"Develop self-service appointment scheduling system to reduce staff involvement",null,"RESPLEV","Column of Level for responses"]
[17,null,0,{"$error":"#NAME?"}]
[18,"Scheduling process",2,{"$error":"#NAME?"},"Optimize scheduling process to reduce walk-ins and no-shows",null,null,"LOW","CT","REC","MEDIUM","CT","REC","HIGH","CT","REC"]
[19,"Scheduling tools",2,{"$error":"#NAME?"},"Develop Credentialing Office staff resource calendar to manage CO staff availability more effectively",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(1:1))),\"\")","v":""},{"$f":"IF(H23=\"\",\"\",((COUNTIF($H$23:$H$46,H23))-(COUNTIF($H23:$H46,H23))+1))","v":""},{"$f":"IF(H23=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H23=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I23,I23)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I23,I23))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(1:1))),\"\")","v":""},{"$f":"IF(K23=\"\",\"\",((COUNTIF($K$23:$K$46,K23))-(COUNTIF($K23:$K46,K23))+1))","v":""},{"$f":"IF(L23=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K23=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L23,L23)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L23,L23))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(1:1))),\"\")","v":""},{"$f":"IF(N23=\"\",\"\",((COUNTIF($N$23:$N$46,N23))-(COUNTIF($N23:$N46,N23))+1))","v":""},{"$f":"IF(N23=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N23=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O23,O23)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O23,O23))))),\"\"))","v":""}]
[20,"Scheduling process",2,{"$error":"#NAME?"},"Cap Credentialing Office demand by resources and staff capacity available",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(2:2))),\"\")","v":""},"",{"$f":"IF(H24=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H24=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I24,I24)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I24,I24))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(2:2))),\"\")","v":""},{"$f":"IF(K24=\"\",\"\",((COUNTIF($K$23:$K$46,K24))-(COUNTIF($K24:$K47,K24))+1))","v":""},{"$f":"IF(L24=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K24=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L24,L24)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L24,L24))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(2:2))),\"\")","v":""},{"$f":"IF(N24=\"\",\"\",((COUNTIF($N$23:$N$46,N24))-(COUNTIF($N24:$N47,N24))+1))","v":""},{"$f":"IF(N24=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N24=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O24,O24)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O24,O24))))),\"\"))","v":""}]
[21,null,0,{"$error":"#NAME?"},null,null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(3:3))),\"\")","v":""},"",{"$f":"IF(H25=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H25=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I25,I25)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I25,I25))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(3:3))),\"\")","v":""},"",{"$f":"IF(L25=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K25=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L25,L25)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L25,L25))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(3:3))),\"\")","v":""},"",{"$f":"IF(N25=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N25=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O25,O25)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O25,O25))))),\"\"))","v":""}]
[22,"AS Policy",2,{"$error":"#NAME?"},"Develop Authorized Signatory guidelines for onboarding, training, and enforcement",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(4:4))),\"\")","v":""},"",{"$f":"IF(H26=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H26=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I26,I26)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I26,I26))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(4:4))),\"\")","v":""},"",{"$f":"IF(L26=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K26=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L26,L26)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L26,L26))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(4:4))),\"\")","v":""},"",{"$f":"IF(N26=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N26=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O26,O26)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O26,O26))))),\"\"))","v":""}]
[23,"AS Technology",1,{"$error":"#NAME?"},"Leverage technology to support Authorized Signatory responsibilities",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(5:5))),\"\")","v":""},"",{"$f":"IF(H27=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H27=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I27,I27)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I27,I27))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(5:5))),\"\")","v":""},"",{"$f":"IF(L27=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K27=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L27,L27)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L27,L27))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(5:5))),\"\")","v":""},"",{"$f":"IF(N27=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N27=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O27,O27)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O27,O27))))),\"\"))","v":""}]
[24,"AS Policy",2,{"$error":"#NAME?"},"Maximize Authorized Signatory engagement in credentialing process",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(6:6))),\"\")","v":""},{"$f":"IF(H28=\"\",\"\",((COUNTIF($H$23:$H$46,H28))-(COUNTIF($H28:$H52,H28))+1))","v":""},{"$f":"IF(H28=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H28=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I28,I28)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I28,I28))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(6:6))),\"\")","v":""},"",{"$f":"IF(L28=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K28=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L28,L28)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L28,L28))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(6:6))),\"\")","v":""},"",{"$f":"IF(N28=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N28=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O28,O28)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O28,O28))))),\"\"))","v":""}]
[25,"AS Engagement",2,{"$error":"#NAME?"},"Incentivize Authorized Signatory positive behavior",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(7:7))),\"\")","v":""},"",{"$f":"IF(H29=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H29=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I29,I29)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I29,I29))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(7:7))),\"\")","v":""},"",{"$f":"IF(L29=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K29=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L29,L29)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L29,L29))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(7:7))),\"\")","v":""},"",{"$f":"IF(N29=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N29=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O29,O29)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O29,O29))))),\"\"))","v":""}]
[26,"AS Engagement",2,{"$error":"#NAME?"},"Build community through communication via email or newsletters",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(8:8))),\"\")","v":""},"",{"$f":"IF(H30=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H30=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I30,I30)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I30,I30))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(8:8))),\"\")","v":""},"",{"$f":"IF(L30=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K30=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L30,L30)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L30,L30))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(8:8))),\"\")","v":""},"",{"$f":"IF(N30=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N30=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O30,O30)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O30,O30))))),\"\"))","v":""}]
[27,null,0,{"$error":"#NAME?"},null,null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(9:9))),\"\")","v":""},"",{"$f":"IF(H31=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H31=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I31,I31)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I31,I31))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(9:9))),\"\")","v":""},"",{"$f":"IF(L31=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K31=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L31,L31)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L31,L31))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(9:9))),\"\")","v":""},"",{"$f":"IF(N31=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N31=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O31,O31)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O31,O31))))),\"\"))","v":""}]
[28,"Tech Optimization",1,{"$error":"#NAME?"},"Identify opportunities to expand on capabilities of existing credentialing systems",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(10:10))),\"\")","v":""},"",{"$f":"IF(H32=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H32=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I32,I32)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I32,I32))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(10:10))),\"\")","v":""},"",{"$f":"IF(L32=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K32=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L32,L32)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L32,L32))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(10:10))),\"\")","v":""},"",{"$f":"IF(N32=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N32=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O32,O32)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O32,O32))))),\"\"))","v":""}]
[29,"Automation",1,{"$error":"#NAME?"},"Identify solutions to automate credentialing processes and reduce staff involvement",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(11:11))),\"\")","v":""},"",{"$f":"IF(H33=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H33=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I33,I33)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I33,I33))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(11:11))),\"\")","v":""},"",{"$f":"IF(L33=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K33=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L33,L33)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L33,L33))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(11:11))),\"\")","v":""},"",{"$f":"IF(N33=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N33=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O33,O33)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O33,O33))))),\"\"))","v":""}]
[30,"Integration",1,{"$error":"#NAME?"},"Identify integration options between systems to reduce manual data entry",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(12:12))),\"\")","v":""},"",{"$f":"IF(H34=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H34=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I34,I34)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I34,I34))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(12:12))),\"\")","v":""},"",{"$f":"IF(L34=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K34=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L34,L34)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L34,L34))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(12:12))),\"\")","v":""},"",{"$f":"IF(N34=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N34=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O34,O34)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O34,O34))))),\"\"))","v":""}]
[31,null,0,{"$error":"#NAME?"},"Develop online scheduling tool (repeated)",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(13:13))),\"\")","v":""},"",{"$f":"IF(H35=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H35=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I35,I35)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I35,I35))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(13:13))),\"\")","v":""},"",{"$f":"IF(L35=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K35=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L35,L35)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L35,L35))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(13:13))),\"\")","v":""},"",{"$f":"IF(N35=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N35=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O35,O35)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O35,O35))))),\"\"))","v":""}]
[32,null,0,{"$error":"#NAME?"},null,null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(14:14))),\"\")","v":""},"",{"$f":"IF(H36=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H36=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I36,I36)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I36,I36))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(14:14))),\"\")","v":""},"",{"$f":"IF(L36=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K36=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L36,L36)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L36,L36))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(14:14))),\"\")","v":""},"",{"$f":"IF(N36=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N36=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O36,O36)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O36,O36))))),\"\"))","v":""}]
[33,"Applicant engagement",{"$f":"COUNTIF(CAT,B37)","v":1},{"$f":"_xlfn.XLOOKUP(B37,RESPCAT,RESPLEV,\"\",0)","v":{"$error":"#NAME?"}},"Review process & instructions to ensure effective applicant experience",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(15:15))),\"\")","v":""},"",{"$f":"IF(H37=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H37=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I37,I37)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I37,I37))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(15:15))),\"\")","v":""},"",{"$f":"IF(L37=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K37=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L37,L37)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L37,L37))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(15:15))),\"\")","v":""},"",{"$f":"IF(N37=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N37=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O37,O37)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O37,O37))))),\"\"))","v":""}]
[34,null,0,{"$error":"#NAME?"},"Develop electronic forms submission to improve accuracy (Repeated)",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(16:16))),\"\")","v":""},"",{"$f":"IF(H38=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H38=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I38,I38)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I38,I38))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(16:16))),\"\")","v":""},"",{"$f":"IF(L38=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K38=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L38,L38)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L38,L38))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(16:16))),\"\")","v":""},"",{"$f":"IF(N38=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N38=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O38,O38)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O38,O38))))),\"\"))","v":""}]
[35,"Forms Accuracy",1,{"$error":"#NAME?"},"Enforce AS responsibility in forms submission completeness, accuracy, and supporting documents",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(17:17))),\"\")","v":""},"",{"$f":"IF(H39=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H39=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I39,I39)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I39,I39))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(17:17))),\"\")","v":""},"",{"$f":"IF(L39=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K39=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L39,L39)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L39,L39))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(17:17))),\"\")","v":""},"",{"$f":"IF(N39=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N39=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O39,O39)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O39,O39))))),\"\"))","v":""}]
[36,null,0,{"$error":"#NAME?"},null,null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(18:18))),\"\")","v":""},"",{"$f":"IF(H40=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H40=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I40,I40)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I40,I40))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(18:18))),\"\")","v":""},"",{"$f":"IF(L40=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K40=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L40,L40)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L40,L40))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(18:18))),\"\")","v":""},"",{"$f":"IF(N40=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N40=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O40,O40)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O40,O40))))),\"\"))","v":""}]
[37,"Document verify",2,{"$error":"#NAME?"},"Develop required ID documents guidelines and training for Credentialing Office staff",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(19:19))),\"\")","v":""},"",{"$f":"IF(H41=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H41=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I41,I41)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I41,I41))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(19:19))),\"\")","v":""},"",{"$f":"IF(L41=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K41=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L41,L41)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L41,L41))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(19:19))),\"\")","v":""},"",{"$f":"IF(N41=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N41=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O41,O41)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O41,O41))))),\"\"))","v":""}]
[38,"Document verify",2,{"$error":"#NAME?"},"Develop Credentialing Office staff resources for document verification",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(20:20))),\"\")","v":""},"",{"$f":"IF(H42=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H42=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I42,I42)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I42,I42))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(20:20))),\"\")","v":""},"",{"$f":"IF(L42=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K42=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L42,L42)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L42,L42))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(20:20))),\"\")","v":""},"",{"$f":"IF(N42=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N42=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O42,O42)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O42,O42))))),\"\"))","v":""}]
[39,null,0,{"$error":"#NAME?"},null,null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(21:21))),\"\")","v":""},"",{"$f":"IF(H43=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H43=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I43,I43)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I43,I43))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(21:21))),\"\")","v":""},"",{"$f":"IF(L43=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K43=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L43,L43)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L43,L43))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(21:21))),\"\")","v":""},"",{"$f":"IF(N43=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N43=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O43,O43)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O43,O43))))),\"\"))","v":""}]
[40,"Language",1,{"$error":"#NAME?"},"Enhance application process to support applicant language needs",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(22:22))),\"\")","v":""},"",{"$f":"IF(H44=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H44=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I44,I44)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I44,I44))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(22:22))),\"\")","v":""},"",{"$f":"IF(L44=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K44=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L44,L44)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L44,L44))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(22:22))),\"\")","v":""},"",{"$f":"IF(N44=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N44=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O44,O44)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O44,O44))))),\"\"))","v":""}]
[41,"ADA resources",1,{"$error":"#NAME?"},"Leverage online resources to support applicant assistance needs",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(23:23))),\"\")","v":""},"",{"$f":"IF(H45=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H45=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I45,I45)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I45,I45))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(23:23))),\"\")","v":""},"",{"$f":"IF(L45=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K45=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L45,L45)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L45,L45))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(23:23))),\"\")","v":""},"",{"$f":"IF(N45=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N45=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O45,O45)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O45,O45))))),\"\"))","v":""}]
[42,"ADA accessibility",1,{"$error":"#NAME?"},"Review Credentialing Office layout and services to improve ADA accessibility",null,null,{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"LOW\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(24:24))),\"\")","v":""},"",{"$f":"IF(H46=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(H46=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I46,I46)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,I46,I46))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"MEDIUM\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(24:24))),\"\")","v":""},"",{"$f":"IF(L46=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(K46=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L46,L46)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,L46,L46))))),\"\"))","v":""},{"$f":"IFERROR(INDEX(RESPCAT,SMALL(IF(\"HIGH\"=RESPLEV,ROW(RESPLEV)-ROW(LEVSTART)+1),ROW(24:24))),\"\")","v":""},"",{"$f":"IF(N46=\"\",\"\",IFERROR(INDEX(REC,SMALL(IF(N46=CAT,ROW(CAT)-ROW($B$5)+1),ROW(INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O46,O46)):INDIRECT(_xlfn.TEXTJOIN(\":\",FALSE,O46,O46))))),\"\"))","v":""}]
[43,null,0,{"$error":"#NAME?"}]
[44,"Forms",2,{"$error":"#NAME?"},"Develop unified form to minimize and simplify application processes",null,null,null,"Assessment Count"]
[45,null,0,{"$error":"#NAME?"},null,null,null,"Needs Immediate Attention",{"$f":"COUNTIF($Q$5:$Q$17,H49)","v":0}]
[46,null,0,{"$error":"#NAME?"},null,null,null,"Needs Improvement",{"$f":"COUNTIF($Q$5:$Q$17,H50)","v":0}]
[47,"Metrics",1,{"$error":"#NAME?"},"Establish metrics to evaluate Credentialing Office performance",null,null,"Adequate",0]
[48,"Audit",1,{"$error":"#NAME?"},"Develop audit to continually evaluate unaccounted badges",null,null,"Incomplete",13]
[49,"Staff engagement",1,{"$error":"#NAME?"},"Conduct regular office meetings to identify challenges and trends"]
[50,null,0,{"$error":"#NAME?"}]
[51,"Peer groups",1,{"$error":"#NAME?"},"Participate in regional airport community group"]
[52,"Peer resources",1,{"$error":"#NAME?"},"Identify peer resources for common Credentialing Office needs"]
[53,null,0,{"$error":"#NAME?"}]
[54,"Forecasting",2,{"$error":"#NAME?"},"Engage other departments and employers that drive high demand times to provide advanced notice"]
[55,"Forecasting",2,{"$error":"#NAME?"},"Implement forecasting tool to identify growth trends for future staffing needs"]
[56,null,0,{"$error":"#NAME?"}]
[57,null,0,{"$error":"#NAME?"}]
[58,null,0,{"$error":"#NAME?"}]
[59,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"COUNTIF(CAT,B68)","v":0}]
[null,null,0]
[null,null,0]