{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Welcome to PPAQ","PPAQ Baseline","PPAQ Scoring and Interpretation","PPAQ Domains","Moving Forward","PPAQ Follow Up","PPAQ Follow-Up Scoring","PPAQ Score Comparison"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":18,"comments":4,"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":"Welcome to PPAQ","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,24,9],[24,10,24,12],[8,1,8,12],[9,2,9,12],[10,1,10,12],[11,2,11,12],[12,1,12,12],[17,2,17,12],[15,2,15,12],[16,1,16,12],[22,1,22,12],[23,2,23,12],[18,1,18,12],[19,2,19,12],[20,1,20,12],[21,2,21,12],[0,0,0,1],[0,2,0,12],[1,0,1,12],[3,0,3,12],[2,0,2,12],[4,0,4,12],[13,2,13,12],[14,1,14,12],[7,0,7,12],[5,0,6,12]]}
[null,null,"Primary Care Behavioral Health Provider Adherence Questionnaire (PPAQ) Toolkit"]
["Welcome to the PPAQ Toolkit"]
["The Primary Care Behavioral Health Provider Adherence Questionnaire (PPAQ) is a self-report instrument designed by investigators at the VA Center for Integrated Healthcare to assess how often behavioral health providers report engaging in certain behaviors or actions while providing services in primary care.  In particular, the PPAQ is intended for use by behavioral health providers to assess fidelity to models of primary care-mental health integration health services delivery, such as Primary Care Behavioral Health.\n\n\n"]
["Within this toolkit you will find:\n\n  • The PPAQ Worksheets (Baseline and Follow-Up)\n  • PPAQ Scoring and Interpretation Information\n  • PPAQ Domain Interpretation Information \n  • Steps for Moving Forward with your PPAQ Results"]
["Using the PPAQ Toolkit"]
["The key components of the Toolkit are organized into eight tabs, described in more detail below.  The Toolkit is designed to be user-friendly; step-by-step instructions for moving through each component of the toolkit are provided throughout.  Users are instructed to begin by completing the PPAQ worksheet, located on the following (second) tab.  They should then proceed through each of the subsequent tabs up to the Moving Forward tab. Users should return to the toolkit and complete the PPAQ Follow-Up worksheet at a later date.\n\n\n"]
[]
["An overview of each tab is provided below"]
[null,"Tab 1: Welcome to the PPAQ Toolkit"]
[null,null,"Provides and overview of Toolkit features and use."]
[null,"Tab 2: The PPAQ Baseline Worksheet"]
[null,null,"Provides the self-report form for completing the PPAQ Baseline assessment."]
[null,"Tab 3: PPAQ Baseline Scoring and Interpretation"]
[null,null,"Provides automatic scoring of the PPAQ Baseline worksheet and walks users through interpreting results."]
[null,"Tab 4: PPAQ Domains"]
[null,null,"Provides further interpretive information regarding results in relation to domains of PC-MHI practice."]
[null,"Tab 5: Moving Forward"]
[null,null,"Suggests a process for using the Toolkit results to guide practice improvements"]
[null,"Tab 6: PPAQ Follow Up"]
[null,null,"Provides the self-report form for completing the PPAQ Follow-Up assessment."]
[null,"Tab 7: PPAQ Follow-Up Scoring and Interpretation"]
[null,null,"Provides automatic scoring of the PPAQ Follow-Up worksheet and walks users through interpreting results."]
[null,"Tab 8: PPAQ Score Comparison"]
[null,null,"Provides an item-by-item and overall score comparison of your baseline and follow-up scores on the PPAQ."]
["\nIf you would like more background about the research behind the PPAQ, please right click the PowerPoint icon on the right and choose \"presentation object\" then choose \"open\" from the sub-menu.  Otherwise, click on the green arrow to begin the PPAQ Worksheet. Please note if you may need to \"enable editing\" and \"enable macros\" before beginning.Once completed the PPAQ toolkit has been formatted to be easily printed for paper copies\n"]

{"sheet":"PPAQ Baseline","index":1,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[4,0,4,12],[3,0,3,2],[1,0,1,12],[2,11,2,12],[34,0,34,10],[35,0,35,10],[36,0,36,10],[37,0,37,10],[38,0,38,10],[6,0,7,10],[6,11,7,12],[8,0,8,10],[8,11,8,12],[15,0,15,10],[25,0,25,10],[26,0,26,10],[29,0,29,10],[30,0,30,10],[31,0,31,10],[32,0,32,10],[33,0,33,10],[16,0,16,10],[17,0,17,10],[18,0,18,10],[19,0,19,10],[20,0,20,10],[21,0,21,10],[22,0,22,10],[23,0,23,10],[24,0,24,10],[5,0,5,12],[9,0,9,10],[9,11,9,12],[10,0,10,10],[10,11,10,12],[11,0,11,10],[12,0,12,10],[13,0,13,10],[14,0,14,10],[54,0,54,10],[55,0,55,10],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[27,0,27,10],[28,0,28,10],[53,11,53,12],[39,0,39,10],[40,0,40,10],[41,0,41,10],[42,0,42,10],[40,11,40,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[48,0,48,10],[49,0,49,10],[50,0,50,10],[51,0,51,10],[43,0,43,10],[44,0,44,10],[45,0,45,10],[46,0,46,10],[47,0,47,10],[52,0,52,10],[53,0,53,10],[2,3,2,9],[3,3,3,9],[2,0,2,2],[0,2,0,12],[0,0,0,1],[54,11,54,12],[55,11,55,12],[11,11,11,12],[12,11,12,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[45,11,45,12],[46,11,46,12],[47,11,47,12],[48,11,48,12],[49,11,49,12],[50,11,50,12],[51,11,51,12],[52,11,52,12]]}
[null,null,"Primary Care Behavioral Health Provider Adherence Questionnaire (PPAQ) Toolkit"]
["PPAQ Baseline Worksheet"]
["Provider: ",null,null,null,null,null,null,null,null,null,"Date: "]
["Clinic and Location: "]
["Instructions: For each item below, please indicate the frequency with which you typically engage in the behavior described while providing behavioral health services in primary care. Please do not leave any question blank. Click on the answer box next to each question to open the drop down box. Select your answer based on the PPAQ Response Categories. \n"]
["PPAQ Response Categories: 1=Never  2=Rarely  3=Sometimes  4=Often  5=Always"]
["Question ",null,null,null,null,null,null,null,null,null,null,"Answer"]
[]
["1. During clinical encounters with patients, I see patients for 30 minutes or less."]
["2. I manage patients reporting mild and moderate symptoms in primary care, and I refer those with more severe symptoms to specialty mental health services when possible."]
["3. During patient appointments, I discuss barriers to implementing a plan or adhering to treatment recommendations."]
["4. I accept referrals for patients with common mental health problems (i.e., depression, anxiety, etc.)."]
["5. During clinical encounters with a patient, I implement behavioral and/or cognitive interventions."]
["6. In introducing my role in the clinic to patients, I explain that I want to get an idea of what is and what is not working for the patient and then together develop a plan to help them manage their concerns."]
["7. During clinical encounters with patients, I triage patients to determine if they can be treated in primary care or should be referred to a specialty mental health or a community agency."]
["8. I accept referrals for patients who might benefit from brief, targeted behavioral health interventions for chronic pain."]
["9. I accept referrals for patients who might benefit from brief, targeted behavioral health interventions for adjustment to illness (e.g., diabetes, heart disease, spinal cord injury, TBI, etc.)."]
["10. My progress notes in the shared medical record include focused recommendations for the Primary Care Provider and/or primary care team."]
["11. I meet briefly with primary care staff as a team to provide both a behavioral health perspective and behavioral data."]
["12. My progress notes include focused recommendations for the patient."]
["13. I consult with various members of the primary care team (e.g., pharmacist, dietician) in addition to the Primary Care Provider about behavioral aspects of medical conditions (e.g., medications that cause nightmares.)"]
["14. At follow-up encounters with patients, I inquire about progress on goals or action plans set at the previous appointment."]
["15. I administer one or more brief validated measures (e.g., Patient Health Questionnaire-9, or PHQ-9) for an initial screening of symptoms of interest, or I review these findings if measures were administered by other primary care staff."]
["16. It takes 30 minutes or more for me to complete all documentation following the initial appointment."]
["17. Following patient appointments, I provide feedback to Primary Care Providers (based on their preferred method of communication) within 1 business day of an initial appointment."]
["18. During clinical encounters with patients, I clarify, confirm, and discuss the patient's concerns."]
["19. My progress notes include brief clinical impressions of the patient’s presenting problem(s)."]
["20. During a clinical encounter with a patient, I provide full neuropsychological, cognitive, or personality assessments."]
["21. I see patients for weekly, open-ended therapy."]
["22. In introducing my role in the clinic to patients, I explain that our appointments typically will be 30 minutes or less."]
["23. I provide suicide risk assessment for primary care patients in crisis and refer to a higher level of care as indicated."]
["24. I typically see patients for 50-minute appointments."]
["25. During patient appointments, I use local community resources to assist me in meeting the behavioral health needs of patients."]
["26. I provide education to the primary care team on behavioral health issues (e.g., presentations and handouts)."]
["27. I provide advice to the primary care team about appropriate referrals to specialty behavioral health services."]
["28. I provide family or couples therapy for 10 or more appointments per episode of care."]
["29. My progress notes include findings from functional assessments and brief screening."]
["30. I administer one or more brief validated measures (e.g., Patient Health Questionnaire-9, or PHQ-9) for follow up screening of symptoms of interest, or I review these findings if measures were administered by other primary care staff."]
["31. I routinely consult with Primary Care Providers to increase my knowledge about behavioral aspects of medical conditions, such as the role of anxiety in cardiac distress."]
["32. During a patient appointment, I provide full length empirically supported treatments, such as Prolonged Exposure or Dialectical Behavior Therapy."]
["33. Following clinical encounters with patients, I continue to provide feedback to the Primary Care Provider about follow-up appointments, when needed."]
["34. During clinical encounters with patients, I work with the patient to develop a specific plan to address their presenting problem and document this plan."]
["35. I accept referrals for patients who need lifestyle interventions (e.g., tobacco cessation, weight control, stress management)."]
["36. I accept referrals for patients in need of behavioral health interventions for medication issues (e.g., adherence)."]
["37. I typically see patients for 10 or more appointments per episode of care."]
["38. I accept referrals for patients in need of behavioral health interventions for adjustment to aging and issues specific to older patients."]
["39. During a patient appointment, I provide functional assessment, focused intervention, and address disposition."]
["40.  I accept referrals for patients from Primary Care Providers as a warm hand off (i.e., the Primary Care Provider introduces me to the patient)."]
["41. In introducing my role in the clinic to patients, I explain that I work with the Primary Care Providers in situations where good health care involves paying attention to physical health, habits, behaviors, emotional health and how those things interact."]
["42. I provide long-term (i.e., greater than 8 sessions) group psychotherapy."]
["43. I meet with a patient for greater than 50 minutes to gather a full psycho-social history and comprehensive psychiatric interview."]
["44. During a patient appointment, I typically provide medical social work services, including, but not limited to, assistance with disability claims, obtaining health insurance, and/or assisting with housing."]
["45. During clinical encounters with patients, I address the Primary Care Providers’ reason for referral."]
["46. I employ strategies to identify and prevent exacerbation of at-risk, sub-syndromal behaviors and symptoms."]
["47. I provide information regarding a patient's symptoms and functioning to assist Primary Care Providers (and/or clinical pharmacists, primary care psychiatrists, psychiatric nurse practitioners) in initiating or modifying common psychotropic medications, such as antidepressants."]
["48. I participate in primary care based clinical pathways for common health conditions, such as chronic pain or comorbid depression and cardiovascular disease."]

{"sheet":"PPAQ Scoring and Interpretation","index":2,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[27,0,27,1],[27,2,27,5],[27,6,27,7],[27,8,29,12],[28,0,28,1],[28,2,28,5],[28,6,28,7],[29,0,29,1],[29,2,29,5],[29,6,29,7],[24,8,26,12],[25,0,25,1],[25,2,25,5],[25,6,25,7],[26,0,26,1],[26,2,26,5],[26,6,26,7],[24,0,24,1],[24,2,24,5],[24,6,24,7],[21,0,21,1],[21,2,21,5],[21,6,21,7],[21,8,23,12],[22,0,22,1],[22,2,22,5],[22,6,22,7],[23,0,23,1],[23,2,23,5],[23,6,23,7],[1,0,1,12],[2,11,2,12],[20,0,20,1],[20,2,20,5],[20,6,20,7],[20,8,20,12],[2,0,2,2],[2,3,2,9],[3,3,3,9],[17,1,17,3],[17,6,17,8],[3,0,3,2],[4,0,4,12],[5,0,5,12],[8,11,9,12],[19,0,19,12],[33,0,33,1],[33,2,33,5],[33,6,33,7],[33,8,35,12],[34,0,34,1],[34,2,34,5],[34,6,34,7],[35,0,35,1],[35,2,35,5],[35,6,35,7],[31,0,31,12],[32,0,32,1],[32,2,32,5],[32,6,32,7],[32,8,32,12],[0,2,0,12],[0,0,0,1],[43,0,43,12],[39,0,39,1],[39,2,39,5],[39,6,39,7],[39,8,41,12],[40,0,40,1],[40,2,40,5],[40,6,40,7],[41,0,41,1],[41,2,41,5],[37,2,37,5],[37,6,37,7],[38,0,38,1],[38,2,38,5],[41,6,41,7],[36,8,38,12],[37,0,37,1],[62,0,62,12],[36,0,36,1],[36,2,36,5],[36,6,36,7],[38,6,38,7]]}
[null,null,"Primary Care Behavioral Health Provider Adherence Questionnaire (PPAQ) Toolkit"]
["Scoring and Interpretation Guide"]
["Provider: ",null,null,{"$f":"IF('PPAQ Baseline'!D3:J3=\"\",\"\",'PPAQ Baseline'!D3:J3)","v":""},null,null,null,null,null,null,"Date: ",{"$f":"IF('PPAQ Baseline'!L3:M3=\"\",\"\",'PPAQ Baseline'!L3:M3)","v":""}]
["Clinic and Location: ",null,null,{"$f":"IF('PPAQ Baseline'!D4:J4=\"\",\"\",'PPAQ Baseline'!D4:J4)","v":""}]
["Overview: The PPAQ items are summed to create two subscales.  The first subscale is for the PPAQ items that measure essential behaviors that are highly consistent with Primary Care Behavioral Health.  Higher scores on this subscale indicate higher fidelity.  The second subscale is for the PPAQ items that measure behaviors that are typically inconsistent with Primary Care Behavioral Health.  Higher scores on this subscale indicate lower fidelity.  "]
["Step 1: Your subscale scores are shown below:"]
["Item #","Value","Item #","Value","Item #","Value","Item #","Value","Item #","Value"]
[1,{"$f":"IF('PPAQ Baseline'!L9=\"\",\"\",'PPAQ Baseline'!L9)","v":""},11,{"$f":"IF('PPAQ Baseline'!L19=\"\",\"\",'PPAQ Baseline'!L19)","v":""},21,{"$f":"IF('PPAQ Baseline'!L29=\"\",\"\",'PPAQ Baseline'!L29)","v":""},31,{"$f":"IF('PPAQ Baseline'!L39=\"\",\"\",'PPAQ Baseline'!L39)","v":""},41,{"$f":"IF('PPAQ Baseline'!L49=\"\",\"\",'PPAQ Baseline'!L49)","v":""}]
[2,{"$f":"IF('PPAQ Baseline'!L10=\"\",\"\",'PPAQ Baseline'!L10)","v":""},12,{"$f":"IF('PPAQ Baseline'!L20=\"\",\"\",'PPAQ Baseline'!L20)","v":""},22,{"$f":"IF('PPAQ Baseline'!L30=\"\",\"\",'PPAQ Baseline'!L30)","v":""},32,{"$f":"IF('PPAQ Baseline'!L40=\"\",\"\",'PPAQ Baseline'!L40)","v":""},42,{"$f":"IF('PPAQ Baseline'!L50=\"\",\"\",'PPAQ Baseline'!L50)","v":""},null,"PPAQ Response Categories"]
[3,{"$f":"IF('PPAQ Baseline'!L11=\"\",\"\",'PPAQ Baseline'!L11)","v":""},13,{"$f":"IF('PPAQ Baseline'!L21=\"\",\"\",'PPAQ Baseline'!L21)","v":""},23,{"$f":"IF('PPAQ Baseline'!L31=\"\",\"\",'PPAQ Baseline'!L31)","v":""},33,{"$f":"IF('PPAQ Baseline'!L41=\"\",\"\",'PPAQ Baseline'!L41)","v":""},43,{"$f":"IF('PPAQ Baseline'!L51=\"\",\"\",'PPAQ Baseline'!L51)","v":""}]
[4,{"$f":"IF('PPAQ Baseline'!L12=\"\",\"\",'PPAQ Baseline'!L12)","v":""},14,{"$f":"IF('PPAQ Baseline'!L22=\"\",\"\",'PPAQ Baseline'!L22)","v":""},24,{"$f":"IF('PPAQ Baseline'!L32=\"\",\"\",'PPAQ Baseline'!L32)","v":""},34,{"$f":"IF('PPAQ Baseline'!L42=\"\",\"\",'PPAQ Baseline'!L42)","v":""},44,{"$f":"IF('PPAQ Baseline'!L52=\"\",\"\",'PPAQ Baseline'!L52)","v":""},null,1,"Never"]
[5,{"$f":"IF('PPAQ Baseline'!L13=\"\",\"\",'PPAQ Baseline'!L13)","v":""},15,{"$f":"IF('PPAQ Baseline'!L23=\"\",\"\",'PPAQ Baseline'!L23)","v":""},25,{"$f":"IF('PPAQ Baseline'!L33=\"\",\"\",'PPAQ Baseline'!L33)","v":""},35,{"$f":"IF('PPAQ Baseline'!L43=\"\",\"\",'PPAQ Baseline'!L43)","v":""},45,{"$f":"IF('PPAQ Baseline'!L53=\"\",\"\",'PPAQ Baseline'!L53)","v":""},null,2,"Rarely"]
[6,{"$f":"IF('PPAQ Baseline'!L14=\"\",\"\",'PPAQ Baseline'!L14)","v":""},16,{"$f":"IF('PPAQ Baseline'!L24=\"\",\"\",'PPAQ Baseline'!L24)","v":""},26,{"$f":"IF('PPAQ Baseline'!L34=\"\",\"\",'PPAQ Baseline'!L34)","v":""},36,{"$f":"IF('PPAQ Baseline'!L44=\"\",\"\",'PPAQ Baseline'!L44)","v":""},46,{"$f":"IF('PPAQ Baseline'!L54=\"\",\"\",'PPAQ Baseline'!L54)","v":""},null,3,"Sometimes"]
[7,{"$f":"IF('PPAQ Baseline'!L15=\"\",\"\",'PPAQ Baseline'!L15)","v":""},17,{"$f":"IF('PPAQ Baseline'!L25=\"\",\"\",'PPAQ Baseline'!L25)","v":""},27,{"$f":"IF('PPAQ Baseline'!L35=\"\",\"\",'PPAQ Baseline'!L35)","v":""},37,{"$f":"IF('PPAQ Baseline'!L45=\"\",\"\",'PPAQ Baseline'!L45)","v":""},47,{"$f":"IF('PPAQ Baseline'!L55=\"\",\"\",'PPAQ Baseline'!L55)","v":""},null,4,"Often"]
[8,{"$f":"IF('PPAQ Baseline'!L16=\"\",\"\",'PPAQ Baseline'!L16)","v":""},18,{"$f":"IF('PPAQ Baseline'!L26=\"\",\"\",'PPAQ Baseline'!L26)","v":""},28,{"$f":"IF('PPAQ Baseline'!L36=\"\",\"\",'PPAQ Baseline'!L36)","v":""},38,{"$f":"IF('PPAQ Baseline'!L46=\"\",\"\",'PPAQ Baseline'!L46)","v":""},48,{"$f":"IF('PPAQ Baseline'!L56=\"\",\"\",'PPAQ Baseline'!L56)","v":""},null,5,"Always"]
[9,{"$f":"IF('PPAQ Baseline'!L17=\"\",\"\",'PPAQ Baseline'!L17)","v":""},19,{"$f":"IF('PPAQ Baseline'!L27=\"\",\"\",'PPAQ Baseline'!L27)","v":""},29,{"$f":"IF('PPAQ Baseline'!L37=\"\",\"\",'PPAQ Baseline'!L37)","v":""},39,{"$f":"IF('PPAQ Baseline'!L47=\"\",\"\",'PPAQ Baseline'!L47)","v":""},"PPAQ-E",{"$f":"SUM(B8:B17,D8:D12,D14:D16,F9:F10,F12:F14,F16:F17,H8,H10:H13,H15:H17,J8,J12:J15)","v":0}]
[10,{"$f":"IF('PPAQ Baseline'!L18=\"\",\"\",'PPAQ Baseline'!L18)","v":""},20,{"$f":"IF('PPAQ Baseline'!L28=\"\",\"\",'PPAQ Baseline'!L28)","v":""},30,{"$f":"IF('PPAQ Baseline'!L38=\"\",\"\",'PPAQ Baseline'!L38)","v":""},40,{"$f":"IF('PPAQ Baseline'!L48=\"\",\"\",'PPAQ Baseline'!L48)","v":""},"PPAQ-I",{"$f":"SUM(D13,D17,F8,F11,F15,H9,H14,J9:J11)","v":0}]
[null,"Subscale Score 1: \nEssential Behaviors\nHigher score desired",null,null,{"$f":"+J16","v":0},"   out of\n/190","Subscale Score 2: Inconsistent Behaviors\nLower score desired",null,null,{"$f":"J17","v":0},"  out of\n/50"]
[]
["Step 2:  Your score for the first subscale (items essential for Primary Care Behavioral Health) is indicated under Provider Score with an arrow (←).  Scores in the green range are in the optimal range of fidelity, with yellow indicating moderate fidelity scores, and red indicating low fidelity scores."]
["Essential Items Possible Score",null,"Reference",null,null,null,"Provider Score ",null,"Interpretation"]
[190,null,"Highest Score ",null,null,null,{"$f":"IF(J16 = 190,\"←\",\"\")","v":""},null,"Your score is in the preferred level of fidelity for essential items. However, even within this range your practices might be improved by modifying any low items noted in Step 4 below.   "]
[null,null,null,null,null,null,{"$f":"IF(AND(J16<190,J16>139),\"←\",\"\")","v":""}]
[139,null,"Top third ",null,null,null,{"$f":"IF(J16 = 139,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(J16<139,J16>114),\"←\",\"\")","v":""},null,"Your score indicates a moderate level of fidelity for essential items.  Although several of your behaviors are in line with good practices, Step 4 will indicate which specific behaviors could be improved."]
[114,null,"Midpoint ",null,null,null,{"$f":"IF(J16 = 114,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(J16<114,J16>88),\"←\",\"\")","v":""}]
[88,null,"Bottom third ",null,null,null,{"$f":"IF(J16 = 88,\"←\",\"\")","v":""},null,"Your score indicates a low level of fidelity for essential items.  Although some of your behaviors are in line with good practices, Step 4 will assist in identifying and prioritizing areas for improvement. "]
[null,null,null,null,null,null,{"$f":"IF(AND(J16<88,J16>38),\"←\",\"\")","v":""}]
[38,null,"Lowest score ",null,null,null,{"$f":"IF(J16 = 38,\"←\",\"\")","v":""}]
[]
["Step 3:  Your score for the second subscale (items typically inconsistent with Primary Care Behavioral Health) is indicated under Provider Score with an arrow (←).  Scores in the green range are in the optimal range of fidelity, with yellow indicating moderate fidelity scores, and red indicating low fidelity scores."]
["Inconsistent Items Possible Score",null,"Reference",null,null,null,"Provider Score ",null,"Interpretation"]
[10,null,"Lowest Score ",null,null,null,{"$f":"IF(J17 = 10,\"←\",\"\")","v":""},null,"Your score is the preferred level of fidelity for these items. However, even within this range your practices might be improved by modifying any areas of suboptimal fidelity noted in Step 4 below.   "]
[null,null,null,null,null,null,{"$f":"IF(AND(J17>10,J17<23),\"←\",\"\")","v":""}]
[23,null,"Top third ",null,null,null,{"$f":"IF(J17 = 23,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(J17>23,J17<30),\"←\",\"\")","v":""},null,"Your score indicates a moderate level of fidelity for these items.  Although several of your behaviors are in line with good practices, Step 4 will indicate which specific behaviors could be improved."]
[30,null,"Midpoint",null,null,null,{"$f":"IF(J17 = 30,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(J17>30,J17<36),\"←\",\"\")","v":""}]
[36,null,"Bottom third ",null,null,null,{"$f":"IF(J17 = 36,\"←\",\"\")","v":""},null,"Your score indicates a low level of fidelity for these items. Although some of your behaviors are in line with good practices, Step 4 will assist in identifying and prioritizing areas for improvement."]
[null,null,null,null,null,null,{"$f":"IF(AND(J17>36,J17<50),\"←\",\"\")","v":""}]
[50,null,"Highest score",null,null,null,{"$f":"IF(J17 = 50,\"←\",\"\")","v":""}]
[]
["Step 4:  In addition to subscale scores noted above, the tables below identify specific areas of low fidelity that can be targeted for improvement.  An asterisk (*) appears for any individual item which scored in the low fidelity range.  Note that items for subscale 2  (behaviors that are typically inconsistent with Primary Care Behavioral Health) are shaded in gray. Place mouse cursor over item # to view question."]
["Item #","Answer","Low?",null,"Item #","Answer","Low?",null,"Item #","Answer","Low?"]
[1,{"$f":"IF(B8=1,\"Never\",IF(B8=2,\"Rarely\",IF(B8=3,\"Sometimes\",IF(B8=4,\"Often\",IF(B8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(B8<4,B8>0),\"*\",\"\")","v":""},null,17,{"$f":"IF(D14=1,\"Never\",IF(D14=2,\"Rarely\",IF(D14=3,\"Sometimes\",IF(D14=4,\"Often\",IF(D14=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(D14<4,D14>0),\"*\",\"\")","v":""},null,33,{"$f":"IF(H10=1,\"Never\",IF(H10=2,\"Rarely\",IF(H10=3,\"Sometimes\",IF(H10=4,\"Often\",IF(H10=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(H10<4,H10>0),\"*\",\"\")","v":""}]
[2,"",{"$f":"IF(AND(B9<4,B9>0),\"*\",\"\")","v":""},null,18,{"$f":"IF(D15=1,\"Never\",IF(D15=2,\"Rarely\",IF(D15=3,\"Sometimes\",IF(D15=4,\"Often\",IF(D15=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(D15<4,D15>0),\"*\",\"\")","v":""},null,34,{"$f":"IF(H11=1,\"Never\",IF(H11=2,\"Rarely\",IF(H11=3,\"Sometimes\",IF(H11=4,\"Often\",IF(H11=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(H11<4,H11>0),\"*\",\"\")","v":""}]
[3,"","",null,19,"","",null,35,"",""]
[4,"","",null,20,"",{"$f":"IF(AND(D17<6,D17>2),\"*\",\"\")","v":""},null,36,"",""]
[5,"","",null,21,{"$f":"IF(F8=1,\"Never\",IF(F8=2,\"Rarely\",IF(F8=3,\"Sometimes\",IF(F8=4,\"Often\",IF(F8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(F8<6,F8>2),\"*\",\"\")","v":""},null,37,"",{"$f":"IF(AND(H14<6,H14>2),\"*\",\"\")","v":""}]
[6,"","",null,22,{"$f":"IF(F9=1,\"Never\",IF(F9=2,\"Rarely\",IF(F9=3,\"Sometimes\",IF(F9=4,\"Often\",IF(F9=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(F9<4,F9>0),\"*\",\"\")","v":""},null,38,"",""]
[7,"","",null,23,"",{"$f":"IF(AND(F10<4,F10>0),\"*\",\"\")","v":""},null,39,"",""]
[8,"","",null,24,"",{"$f":"IF(AND(F11<6,F11>2),\"*\",\"\")","v":""},null,40,"",""]
[9,"","",null,25,"",{"$f":"IF(AND(F12<4,F12>0),\"*\",\"\")","v":""},null,41,{"$f":"IF(J8=1,\"Never\",IF(J8=2,\"Rarely\",IF(J8=3,\"Sometimes\",IF(J8=4,\"Often\",IF(J8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(J8<4,J8>0),\"*\",\"\")","v":""}]
[10,"","",null,26,"",{"$f":"IF(AND(F13<4,F13>0),\"*\",\"\")","v":""},null,42,{"$f":"IF(J9=1,\"Never\",IF(J9=2,\"Rarely\",IF(J9=3,\"Sometimes\",IF(J9=4,\"Often\",IF(J9=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(J9<6,J9>2),\"*\",\"\")","v":""}]
[11,{"$f":"IF(D8=1,\"Never\",IF(D8=2,\"Rarely\",IF(D8=3,\"Sometimes\",IF(D8=4,\"Often\",IF(D8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(D8<4,D8>0),\"*\",\"\")","v":""},null,27,"","",null,43,"",{"$f":"IF(AND(J10<6,J10>2),\"*\",\"\")","v":""}]
[12,"",{"$f":"IF(AND(D9<4,D9>0),\"*\",\"\")","v":""},null,28,"",{"$f":"IF(AND(F15<6,F15>2),\"*\",\"\")","v":""},null,44,"",""]
[13,"","",null,29,"",{"$f":"IF(AND(F16<4,F16>0),\"*\",\"\")","v":""},null,45,"",{"$f":"IF(AND(J12<4,J12>0),\"*\",\"\")","v":""}]
[14,"","",null,30,"",{"$f":"IF(AND(F17<4,F17>0),\"*\",\"\")","v":""},null,46,"",{"$f":"IF(AND(J13<4,J13>0),\"*\",\"\")","v":""}]
[15,"","",null,31,{"$f":"IF(H8=1,\"Never\",IF(H8=2,\"Rarely\",IF(H8=3,\"Sometimes\",IF(H8=4,\"Often\",IF(H8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(H8<4,H8>0),\"*\",\"\")","v":""},null,47,"",""]
[16,"",{"$f":"IF(AND(D13<6,D13>2),\"*\",\"\")","v":""},null,32,{"$f":"IF(H9=1,\"Never\",IF(H9=2,\"Rarely\",IF(H9=3,\"Sometimes\",IF(H9=4,\"Often\",IF(H9=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(H9<6,H9>2),\"*\",\"\")","v":""},null,48,"",""]
[]
["Please move to next page for step 5: PPAQ Domains"]

{"sheet":"PPAQ Domains","index":3,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[16,9,17,9],[21,1,21,8],[28,1,28,8],[29,0,33,0],[15,0,19,0],[0,1,0,9],[1,0,1,9],[13,0,13,9],[4,0,4,9],[5,0,5,9],[6,1,6,8],[7,0,12,0],[14,1,14,8],[20,0,20,9],[27,0,27,9],[19,1,19,5],[19,6,19,7],[22,0,26,0]]}
[null,"Primary Care Behavioral Health Provider Adherence Questionnaire (PPAQ) Toolkit"]
["PPAQ Domains"]
[]
[]
["Step 5:  PPAQ items can be grouped into one of four domains of practice.  Below you will find a description of each domain and the PPAQ items that are in each domain.  Items with low fidelity based on your responses appear in red text. Place your mouse over the question number to review item text. Domains with the most low fidelity items can be the starting point for improving your practice.  Links to clinical and educational resources relevant to that domain are provided."]
["Domain 1: Clinical Scope and Interventions"]
["Definition","Items in this domain",null,null,null,null,null,null,null,"Links to Relevant Clinical and Educational Resources"]
["This domain refers to integrated care provider behaviors related to providing clinical services to patients, including the type and nature of interventions utilized."]
[]
[null,"5,","20,","23,","28,","32,","37,","42,","43,"]
[null,null,null,"44,","46,",48]
[]
[]
["Domain 2: Practice and Session Management"]
["Definition","Items in this domain",null,null,null,null,null,null,null,"Links to Relevant Clinical and Educational Resources"]
["This domain refers to integrated care provider behaviors that characterize their overall approach to integrated health care using a population-based model. "]
[null,"1,","2,","3,","6,","7,","10,","12,","14,"]
[null,"15,","16,","18,","19,","21,","22,","24,","25,"]
[null,null,"29,","30,","34,","39,","41,",45]
[]
["Domain 3: Referral Management and Care Continuity"]
["Definition","Items in this domain",null,null,null,null,null,null,null,"Links to Relevant Clinical and Educational Resources"]
["This domain refers to integrated care provider behaviors related to the types of referrals they accept from PCPs, including advice to PCPs about referring to specialty mental health. "]
[]
[null,"4,","8,","9,","27,","35,","36,","38,",40]
[]
[]
["Domain 4: Consultation, Collaboration, and Interprofessional Communication"]
["Definition","Items in this domain",null,null,null,null,null,null,null,"Links to Relevant Clinical and Educational Resources"]
["This domain refers to integrated care provider behaviors related to communicating and collaborating with other members of the primary care team. "]
[]
[null,"11,","13,","17,","26,","31,","33,",47,null,"Consultation and Collaboration links to abstracts:"]

{"sheet":"Moving Forward","index":4,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[35,0,35,6],[33,0,33,6],[34,0,34,6],[27,0,27,5],[29,0,29,12],[31,0,31,12],[28,0,28,12],[32,0,32,7],[30,0,30,12],[44,2,46,2],[37,0,37,12],[38,0,39,12],[40,0,40,12],[41,0,41,12],[42,0,42,12],[44,5,46,5],[26,0,26,5],[25,0,25,1],[0,0,0,1],[0,2,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[14,0,14,12],[16,0,16,12],[22,0,22,12],[24,0,24,12],[6,0,6,12]]}
[null,null,"Primary Care Behavioral Health Provider Adherence Questionnaire (PPAQ) Toolkit"]
["Moving Forward with your PPAQ Results"]
["    The following steps are optional but can further assist you in applying the results of the PPAQ Toolkit.  Modifying some behaviors identified in the PPAQ can require more coordination and planning than others, including the support of supervisors or other primary care team members. The process below is one approach to address larger practice change goals."]
["\n"]
[]
[]
["The first step in the process is Prioritizing areas for change.  Based on the item analysis you conducted on tab 2 step 4, select one or two items of low adherence that seem the most feasible to address at this time.  The goal is to start small by identifying just one or two related behaviors to address.  "]
[]
[]
[]
[]
[]
[]
[]
["The second step is to Partner with integrated advocates or peers for assistance. This process can include reaching out to the designated integrated care champion at your facility, a colleague, your supervisor, or other experts who act as coaches and advocates for front line integrated care providers.  Sharing the results of your PPAQ self-assessment is a great way to receive additional support. If there is no one designated in these roles at your facility, consider joining or starting a local or regional peer support network of other integrated care providers.  Collaborating with peers can be an excellent way to share firsthand knowledge regarding integrated care practices.  "]
[]
["The third step is Accessing educational and clinical resources.  Several of these resources were listed in the PPAQ Scoring and Interpretation Guide.  There are additional resources available at the VA Center for Integrated Healthcare website that can assist you in meeting your goals for change. "]
[]
[]
[]
[]
[]
["The fourth step is an optional one, but is strongly recommended for more complex goals for change. If larger modifications to your practice are necessary, consider engaging in a structured quality improvement process.  Quality improvement can be as simple as conducting Plan-Do-Study-Act cycles that consist of breaking down a larger goal into several steps.  For practice changes that require inter-professional collaboration with primary care team members, consider if developing a small team of interested individuals can facilitate change.  Either way, you don’t need to be a quality improvement expert to use Plan-Do-Study-Act.  There are links to several resources at the end of this to assist you in this process. "]
[]
["Additional Resources to Assist with Moving Forward"]
["Key Websites:"]
[]
["Integrated Care Texts and Literature:"]
["Behavioral Consultation and Primary care: A guide to integrating services. Robinson, P. J., & Reiter, J. T. (2007). New York, NY: Springer."]
["Integrated Behavioral Health in Primary Care: Step-by-step guidance for assessment and intervention. Hunter, C. L., Goodie, J. L., Oordt, M. S., & Dobmeyer, A. C. (2009). Washington, DC: American Psychological Association."]
["Real Behavior Change in Primary Care: Improving patient outcomes & increasing job satisfaction.  Robinson, P. J., Gould, D. A., & Strosahl, K. D. (2010). Oakland, CA: New Harbinger."]
[]
[]
["Quality Improvement and Plan-Do-Study-Act (PDSA) Basics:"]
[]
[]
[]
["Contact Information "]
["It is our sincere hope that this presentation has been a source of learning and support in your role as an interated care provider that ultimately enhances the provision of care for patients and families.  For additional information about the PPAQ Toolkit or content of this presentation, contact: "]
[]
["Dr. Gregory P. Beehler, VA Center for Integrated Healthcare"]
[]
["Phone: 716-862-7934"]

{"sheet":"PPAQ Follow Up","index":5,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[3,0,3,2],[3,3,3,9],[4,0,4,12],[5,0,5,12],[6,0,7,10],[6,11,7,12],[0,0,0,1],[0,2,0,12],[1,0,1,12],[2,0,2,2],[2,3,2,9],[2,11,2,12],[11,0,11,10],[11,11,11,12],[12,0,12,10],[12,11,12,12],[13,0,13,10],[13,11,13,12],[8,0,8,10],[8,11,8,12],[9,0,9,10],[9,11,9,12],[10,0,10,10],[10,11,10,12],[17,0,17,10],[17,11,17,12],[18,0,18,10],[18,11,18,12],[19,0,19,10],[19,11,19,12],[14,0,14,10],[14,11,14,12],[15,0,15,10],[15,11,15,12],[16,0,16,10],[16,11,16,12],[23,0,23,10],[23,11,23,12],[24,0,24,10],[24,11,24,12],[25,0,25,10],[25,11,25,12],[20,0,20,10],[20,11,20,12],[21,0,21,10],[21,11,21,12],[22,0,22,10],[22,11,22,12],[29,0,29,10],[29,11,29,12],[30,0,30,10],[30,11,30,12],[31,0,31,10],[31,11,31,12],[26,0,26,10],[26,11,26,12],[27,0,27,10],[27,11,27,12],[28,0,28,10],[28,11,28,12],[35,0,35,10],[35,11,35,12],[36,0,36,10],[36,11,36,12],[37,0,37,10],[37,11,37,12],[32,0,32,10],[32,11,32,12],[33,0,33,10],[33,11,33,12],[34,0,34,10],[34,11,34,12],[41,0,41,10],[41,11,41,12],[42,0,42,10],[42,11,42,12],[43,0,43,10],[43,11,43,12],[38,0,38,10],[38,11,38,12],[39,0,39,10],[39,11,39,12],[40,0,40,10],[40,11,40,12],[47,0,47,10],[47,11,47,12],[48,0,48,10],[48,11,48,12],[49,0,49,10],[49,11,49,12],[44,0,44,10],[44,11,44,12],[45,0,45,10],[45,11,45,12],[46,0,46,10],[46,11,46,12],[53,0,53,10],[53,11,53,12],[54,0,54,10],[54,11,54,12],[55,0,55,10],[55,11,55,12],[50,0,50,10],[50,11,50,12],[51,0,51,10],[51,11,51,12],[52,0,52,10],[52,11,52,12]]}
[null,null,"Primary Care Behavioral Health Provider Adherence Questionnaire (PPAQ) Toolkit"]
["PPAQ Follow-Up Worksheet"]
["Provider: ",null,null,null,null,null,null,null,null,null,"Date: "]
["Clinic and Location: "]
["Instructions: For each item below, please indicate the frequency with which you typically engage in the behavior described while providing behavioral health services in primary care. Please do not leave any question blank. Click on the answer box next to each question to open the drop down box. Select your answer based on the PPAQ Response Categories. \n"]
["PPAQ Response Categories: 1=Never  2=Rarely  3=Sometimes  4=Often  5=Always"]
["Question ",null,null,null,null,null,null,null,null,null,null,"Answer"]
[]
["1. During clinical encounters with patients, I see patients for 30 minutes or less."]
["2. I manage patients reporting mild and moderate symptoms in primary care, and I refer those with more severe symptoms to specialty mental health services when possible."]
["3. During patient appointments, I discuss barriers to implementing a plan or adhering to treatment recommendations."]
["4. I accept referrals for patients with common mental health problems (i.e., depression, anxiety, etc.)."]
["5. During clinical encounters with a patient, I implement behavioral and/or cognitive interventions."]
["6. In introducing my role in the clinic to patients, I explain that I want to get an idea of what is and what is not working for the patient and then together develop a plan to help them manage their concerns."]
["7. During clinical encounters with patients, I triage patients to determine if they can be treated in primary care or should be referred to a specialty mental health or a community agency."]
["8. I accept referrals for patients who might benefit from brief, targeted behavioral health interventions for chronic pain."]
["9. I accept referrals for patients who might benefit from brief, targeted behavioral health interventions for adjustment to illness (e.g., diabetes, heart disease, spinal cord injury, TBI, etc.)."]
["10. My progress notes in the shared medical record include focused recommendations for the Primary Care Provider and/or primary care team."]
["11. I meet briefly with primary care staff as a team to provide both a behavioral health perspective and behavioral data."]
["12. My progress notes include focused recommendations for the patient."]
["13. I consult with various members of the primary care team (e.g., pharmacist, dietician) in addition to the Primary Care Provider about behavioral aspects of medical conditions (e.g., medications that cause nightmares.)"]
["14. At follow-up encounters with patients, I inquire about progress on goals or action plans set at the previous appointment."]
["15. I administer one or more brief validated measures (e.g., Patient Health Questionnaire-9, or PHQ-9) for an initial screening of symptoms of interest, or I review these findings if measures were administered by other primary care staff."]
["16. It takes 30 minutes or more for me to complete all documentation following the initial appointment."]
["17. Following patient appointments, I provide feedback to Primary Care Providers (based on their preferred method of communication) within 1 business day of an initial appointment."]
["18. During clinical encounters with patients, I clarify, confirm, and discuss the patient's concerns."]
["19. My progress notes include brief clinical impressions of the patient’s presenting problem(s)."]
["20. During a clinical encounter with a patient, I provide full neuropsychological, cognitive, or personality assessments."]
["21. I see patients for weekly, open-ended therapy."]
["22. In introducing my role in the clinic to patients, I explain that our appointments typically will be 30 minutes or less."]
["23. I provide suicide risk assessment for primary care patients in crisis and refer to a higher level of care as indicated."]
["24. I typically see patients for 50-minute appointments."]
["25. During patient appointments, I use local community resources to assist me in meeting the behavioral health needs of patients."]
["26. I provide education to the primary care team on behavioral health issues (e.g., presentations and handouts)."]
["27. I provide advice to the primary care team about appropriate referrals to specialty behavioral health services."]
["28. I provide family or couples therapy for 10 or more appointments per episode of care."]
["29. My progress notes include findings from functional assessments and brief screening."]
["30. I administer one or more brief validated measures (e.g., Patient Health Questionnaire-9, or PHQ-9) for follow up screening of symptoms of interest, or I review these findings if measures were administered by other primary care staff."]
["31. I routinely consult with Primary Care Providers to increase my knowledge about behavioral aspects of medical conditions, such as the role of anxiety in cardiac distress."]
["32. During a patient appointment, I provide full length empirically supported treatments, such as Prolonged Exposure or Dialectical Behavior Therapy."]
["33. Following clinical encounters with patients, I continue to provide feedback to the Primary Care Provider about follow-up appointments, when needed."]
["34. During clinical encounters with patients, I work with the patient to develop a specific plan to address their presenting problem and document this plan."]
["35. I accept referrals for patients who need lifestyle interventions (e.g., tobacco cessation, weight control, stress management)."]
["36. I accept referrals for patients in need of behavioral health interventions for medication issues (e.g., adherence)."]
["37. I typically see patients for 10 or more appointments per episode of care."]
["38. I accept referrals for patients in need of behavioral health interventions for adjustment to aging and issues specific to older patients."]
["39. During a patient appointment, I provide functional assessment, focused intervention, and address disposition."]
["40.  I accept referrals for patients from Primary Care Providers as a warm hand off (i.e., the Primary Care Provider introduces me to the patient)."]
["41. In introducing my role in the clinic to patients, I explain that I work with the Primary Care Providers in situations where good health care involves paying attention to physical health, habits, behaviors, emotional health and how those things interact."]
["42. I provide long-term (i.e., greater than 8 sessions) group psychotherapy."]
["43. I meet with a patient for greater than 50 minutes to gather a full psycho-social history and comprehensive psychiatric interview."]
["44. During a patient appointment, I typically provide medical social work services, including, but not limited to, assistance with disability claims, obtaining health insurance, and/or assisting with housing."]
["45. During clinical encounters with patients, I address the Primary Care Providers’ reason for referral."]
["46. I employ strategies to identify and prevent exacerbation of at-risk, sub-syndromal behaviors and symptoms."]
["47. I provide information regarding a patient's symptoms and functioning to assist Primary Care Providers (and/or clinical pharmacists, primary care psychiatrists, psychiatric nurse practitioners) in initiating or modifying common psychotropic medications, such as antidepressants."]
["48. I participate in primary care based clinical pathways for common health conditions, such as chronic pain or comorbid depression and cardiovascular disease."]

{"sheet":"PPAQ Follow-Up Scoring","index":6,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[17,1,17,3],[17,6,17,8],[0,0,0,1],[0,2,0,12],[1,0,1,12],[2,0,2,2],[2,3,2,9],[2,11,2,12],[3,0,3,2],[3,3,3,9],[4,0,4,12],[5,0,5,12],[8,11,9,12],[21,0,21,1],[21,2,21,5],[21,6,21,7],[21,8,23,12],[22,0,22,1],[22,2,22,5],[22,6,22,7],[23,0,23,1],[23,2,23,5],[23,6,23,7],[19,0,19,12],[20,0,20,1],[20,2,20,5],[20,6,20,7],[20,8,20,12],[24,8,26,12],[25,0,25,1],[25,2,25,5],[25,6,25,7],[26,0,26,1],[26,2,26,5],[26,6,26,7],[24,0,24,1],[24,2,24,5],[24,6,24,7],[27,0,27,1],[27,2,27,5],[27,6,27,7],[27,8,29,12],[28,0,28,1],[28,2,28,5],[28,6,28,7],[29,0,29,1],[29,2,29,5],[29,6,29,7],[33,0,33,1],[33,2,33,5],[33,6,33,7],[33,8,35,12],[34,0,34,1],[34,2,34,5],[34,6,34,7],[35,0,35,1],[35,2,35,5],[35,6,35,7],[31,0,31,12],[32,0,32,1],[32,2,32,5],[32,6,32,7],[32,8,32,12],[36,8,38,12],[37,0,37,1],[37,2,37,5],[37,6,37,7],[38,0,38,1],[38,2,38,5],[38,6,38,7],[36,0,36,1],[36,2,36,5],[36,6,36,7],[43,0,43,12],[62,0,62,12],[39,0,39,1],[39,2,39,5],[39,6,39,7],[39,8,41,12],[40,0,40,1],[40,2,40,5],[40,6,40,7],[41,0,41,1],[41,2,41,5],[41,6,41,7]]}
[null,null,"Primary Care Behavioral Health Provider Adherence Questionnaire (PPAQ) Toolkit"]
["Follow-Up Scoring and Interpretation Guide"]
["Provider: ",null,null,{"$f":"IF('PPAQ Follow Up'!D3:J3=\"\",\"\",'PPAQ Follow Up'!D3:J3)","v":""},null,null,null,null,null,null,"Date: ",{"$f":"IF('PPAQ Follow Up'!L3:M3=\"\",\"\",'PPAQ Follow Up'!L3:M3)","v":""}]
["Clinic and Location: ",null,null,{"$f":"IF('PPAQ Follow Up'!D4:J4=\"\",\"\",'PPAQ Follow Up'!D4:J4)","v":""}]
["Overview: The PPAQ items are summed to create two subscales.  The first subscale is for the PPAQ items that measure essential behaviors that are highly consistent with Primary Care Behavioral Health.  Higher scores on this subscale indicate higher fidelity.  The second subscale is for the PPAQ items that measure behaviors that are typically inconsistent with Primary Care Behavioral Health.  Higher scores on this subscale indicate lower fidelity.  "]
["Step 1: Your subscale scores are shown below:"]
["Item #","Value","Item #","Value","Item #","Value","Item #","Value","Item #","Value"]
[1,{"$f":"IF('PPAQ Follow Up'!L9=\"\",\"\",'PPAQ Follow Up'!L9)","v":""},11,{"$f":"IF('PPAQ Follow Up'!L19=\"\",\"\",'PPAQ Follow Up'!L19)","v":""},21,{"$f":"IF('PPAQ Follow Up'!L29=\"\",\"\",'PPAQ Follow Up'!L29)","v":""},31,{"$f":"IF('PPAQ Follow Up'!L39=\"\",\"\",'PPAQ Follow Up'!L39)","v":""},41,{"$f":"IF('PPAQ Follow Up'!L49=\"\",\"\",'PPAQ Follow Up'!L49)","v":""}]
[2,{"$f":"IF('PPAQ Follow Up'!L10=\"\",\"\",'PPAQ Follow Up'!L10)","v":""},12,{"$f":"IF('PPAQ Follow Up'!L20=\"\",\"\",'PPAQ Follow Up'!L20)","v":""},22,{"$f":"IF('PPAQ Follow Up'!L30=\"\",\"\",'PPAQ Follow Up'!L30)","v":""},32,{"$f":"IF('PPAQ Follow Up'!L40=\"\",\"\",'PPAQ Follow Up'!L40)","v":""},42,{"$f":"IF('PPAQ Follow Up'!L50=\"\",\"\",'PPAQ Follow Up'!L50)","v":""},null,"PPAQ Response Categories"]
[3,{"$f":"IF('PPAQ Follow Up'!L11=\"\",\"\",'PPAQ Follow Up'!L11)","v":""},13,{"$f":"IF('PPAQ Follow Up'!L21=\"\",\"\",'PPAQ Follow Up'!L21)","v":""},23,{"$f":"IF('PPAQ Follow Up'!L31=\"\",\"\",'PPAQ Follow Up'!L31)","v":""},33,{"$f":"IF('PPAQ Follow Up'!L41=\"\",\"\",'PPAQ Follow Up'!L41)","v":""},43,{"$f":"IF('PPAQ Follow Up'!L51=\"\",\"\",'PPAQ Follow Up'!L51)","v":""}]
[4,{"$f":"IF('PPAQ Follow Up'!L12=\"\",\"\",'PPAQ Follow Up'!L12)","v":""},14,{"$f":"IF('PPAQ Follow Up'!L22=\"\",\"\",'PPAQ Follow Up'!L22)","v":""},24,{"$f":"IF('PPAQ Follow Up'!L32=\"\",\"\",'PPAQ Follow Up'!L32)","v":""},34,{"$f":"IF('PPAQ Follow Up'!L42=\"\",\"\",'PPAQ Follow Up'!L42)","v":""},44,{"$f":"IF('PPAQ Follow Up'!L52=\"\",\"\",'PPAQ Follow Up'!L52)","v":""},null,1,"Never"]
[5,{"$f":"IF('PPAQ Follow Up'!L13=\"\",\"\",'PPAQ Follow Up'!L13)","v":""},15,{"$f":"IF('PPAQ Follow Up'!L23=\"\",\"\",'PPAQ Follow Up'!L23)","v":""},25,{"$f":"IF('PPAQ Follow Up'!L33=\"\",\"\",'PPAQ Follow Up'!L33)","v":""},35,{"$f":"IF('PPAQ Follow Up'!L43=\"\",\"\",'PPAQ Follow Up'!L43)","v":""},45,{"$f":"IF('PPAQ Follow Up'!L53=\"\",\"\",'PPAQ Follow Up'!L53)","v":""},null,2,"Rarely"]
[6,{"$f":"IF('PPAQ Follow Up'!L14=\"\",\"\",'PPAQ Follow Up'!L14)","v":""},16,{"$f":"IF('PPAQ Follow Up'!L24=\"\",\"\",'PPAQ Follow Up'!L24)","v":""},26,{"$f":"IF('PPAQ Follow Up'!L34=\"\",\"\",'PPAQ Follow Up'!L34)","v":""},36,{"$f":"IF('PPAQ Follow Up'!L44=\"\",\"\",'PPAQ Follow Up'!L44)","v":""},46,{"$f":"IF('PPAQ Follow Up'!L54=\"\",\"\",'PPAQ Follow Up'!L54)","v":""},null,3,"Sometimes"]
[7,{"$f":"IF('PPAQ Follow Up'!L15=\"\",\"\",'PPAQ Follow Up'!L15)","v":""},17,{"$f":"IF('PPAQ Follow Up'!L25=\"\",\"\",'PPAQ Follow Up'!L25)","v":""},27,{"$f":"IF('PPAQ Follow Up'!L35=\"\",\"\",'PPAQ Follow Up'!L35)","v":""},37,{"$f":"IF('PPAQ Follow Up'!L45=\"\",\"\",'PPAQ Follow Up'!L45)","v":""},47,{"$f":"IF('PPAQ Follow Up'!L55=\"\",\"\",'PPAQ Follow Up'!L55)","v":""},null,4,"Often"]
[8,{"$f":"IF('PPAQ Follow Up'!L16=\"\",\"\",'PPAQ Follow Up'!L16)","v":""},18,{"$f":"IF('PPAQ Follow Up'!L26=\"\",\"\",'PPAQ Follow Up'!L26)","v":""},28,{"$f":"IF('PPAQ Follow Up'!L36=\"\",\"\",'PPAQ Follow Up'!L36)","v":""},38,{"$f":"IF('PPAQ Follow Up'!L46=\"\",\"\",'PPAQ Follow Up'!L46)","v":""},48,{"$f":"IF('PPAQ Follow Up'!L56=\"\",\"\",'PPAQ Follow Up'!L56)","v":""},null,5,"Always"]
[9,{"$f":"IF('PPAQ Follow Up'!L17=\"\",\"\",'PPAQ Follow Up'!L17)","v":""},19,{"$f":"IF('PPAQ Follow Up'!L27=\"\",\"\",'PPAQ Follow Up'!L27)","v":""},29,{"$f":"IF('PPAQ Follow Up'!L37=\"\",\"\",'PPAQ Follow Up'!L37)","v":""},39,{"$f":"IF('PPAQ Follow Up'!L47=\"\",\"\",'PPAQ Follow Up'!L47)","v":""},"PPAQ-E",{"$f":"SUM(B8:B17,D8:D12,D14:D16,F9:F10,F12:F14,F16:F17,H8,H10:H13,H15:H17,J8,J12:J15)","v":0}]
[10,{"$f":"IF('PPAQ Follow Up'!L18=\"\",\"\",'PPAQ Follow Up'!L18)","v":""},20,{"$f":"IF('PPAQ Follow Up'!L28=\"\",\"\",'PPAQ Follow Up'!L28)","v":""},30,{"$f":"IF('PPAQ Follow Up'!L38=\"\",\"\",'PPAQ Follow Up'!L38)","v":""},40,{"$f":"IF('PPAQ Follow Up'!L48=\"\",\"\",'PPAQ Follow Up'!L48)","v":""},"PPAQ-I",{"$f":"SUM(D13,D17,F8,F11,F15,H9,H14,J9:J11)","v":0}]
[null,"Subscale Score 1: \nEssential Behaviors\nHigher score desired",null,null,{"$f":"+J16","v":0},"   out of\n/190","Subscale Score 2: Inconsistent Behaviors\nLower score desired",null,null,{"$f":"J17","v":0},"  out of\n/50"]
[]
["Step 2:  Your score for the first subscale (items essential for Primary Care Behavioral Health) is indicated under Provider Score with an arrow (←).  Scores in the green range are in the optimal range of fidelity, with yellow indicating moderate fidelity scores, and red indicating low fidelity scores."]
["Essential Items Possible Score",null,"Reference",null,null,null,"Provider Score ",null,"Interpretation"]
[190,null,"Highest Score ",null,null,null,{"$f":"IF(J16 = 190,\"←\",\"\")","v":""},null,"Your score is in the preferred level of fidelity for essential items. However, even within this range your practices might be improved by modifying any low items noted in Step 4 below.   "]
[null,null,null,null,null,null,{"$f":"IF(AND(J16<190,J16>139),\"←\",\"\")","v":""}]
[139,null,"Top third ",null,null,null,{"$f":"IF(J16 = 139,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(J16<139,J16>114),\"←\",\"\")","v":""},null,"Your score indicates a moderate level of fidelity for essential items.  Although several of your behaviors are in line with good practices, Step 4 will indicate which specific behaviors could be improved."]
[114,null,"Midpoint ",null,null,null,{"$f":"IF(J16 = 114,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(J16<114,J16>88),\"←\",\"\")","v":""}]
[88,null,"Bottom third ",null,null,null,{"$f":"IF(J16 = 88,\"←\",\"\")","v":""},null,"Your score indicates a low level of fidelity for essential items.  Although some of your behaviors are in line with good practices, Step 4 will assist in identifying and prioritizing areas for improvement. "]
[null,null,null,null,null,null,{"$f":"IF(AND(J16<88,J16>38),\"←\",\"\")","v":""}]
[38,null,"Lowest score ",null,null,null,{"$f":"IF(J16 = 38,\"←\",\"\")","v":""}]
[]
["Step 3:  Your score for the second subscale (items typically inconsistent with Primary Care Behavioral Health) is indicated under Provider Score with an arrow (←).  Scores in the green range are in the optimal range of fidelity, with yellow indicating moderate fidelity scores, and red indicating low fidelity scores."]
["Inconsistent Items Possible Score",null,"Reference",null,null,null,"Provider Score ",null,"Interpretation"]
[10,null,"Lowest Score ",null,null,null,{"$f":"IF(J17 = 10,\"←\",\"\")","v":""},null,"Your score is the preferred level of fidelity for these items. However, even within this range your practices might be improved by modifying any areas of suboptimal fidelity noted in Step 4 below.   "]
[null,null,null,null,null,null,{"$f":"IF(AND(J17>10,J17<23),\"←\",\"\")","v":""}]
[23,null,"Top third ",null,null,null,{"$f":"IF(J17 = 23,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(J17>23,J17<30),\"←\",\"\")","v":""},null,"Your score indicates a moderate level of fidelity for these items.  Although several of your behaviors are in line with good practices, Step 4 will indicate which specific behaviors could be improved."]
[30,null,"Midpoint",null,null,null,{"$f":"IF(J17 = 30,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(J17>30,J17<36),\"←\",\"\")","v":""}]
[36,null,"Bottom third ",null,null,null,{"$f":"IF(J17 = 36,\"←\",\"\")","v":""},null,"Your score indicates a low level of fidelity for these items. Although some of your behaviors are in line with good practices, Step 4 will assist in identifying and prioritizing areas for improvement."]
[null,null,null,null,null,null,{"$f":"IF(AND(J17>36,J17<50),\"←\",\"\")","v":""}]
[50,null,"Highest score",null,null,null,{"$f":"IF(J17 = 50,\"←\",\"\")","v":""}]
[]
["Step 4:  In addition to subscale scores noted above, the tables below identify specific areas of low fidelity that can be targeted for improvement.  An asterisk (*) appears for any individual item which scored in the low fidelity range.  Note that items for subscale 2  (behaviors that are typically inconsistent with Primary Care Behavioral Health) are shaded in gray. Place mouse cursor over item # to view question."]
["Item #","Answer","Low?",null,"Item #","Answer","Low?",null,"Item #","Answer","Low?"]
[1,{"$f":"IF(B8=1,\"Never\",IF(B8=2,\"Rarely\",IF(B8=3,\"Sometimes\",IF(B8=4,\"Often\",IF(B8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(B8<4,B8>0),\"*\",\"\")","v":""},null,17,{"$f":"IF(D14=1,\"Never\",IF(D14=2,\"Rarely\",IF(D14=3,\"Sometimes\",IF(D14=4,\"Often\",IF(D14=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(D14<4,D14>0),\"*\",\"\")","v":""},null,33,{"$f":"IF(H10=1,\"Never\",IF(H10=2,\"Rarely\",IF(H10=3,\"Sometimes\",IF(H10=4,\"Often\",IF(H10=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(H10<4,H10>0),\"*\",\"\")","v":""}]
[2,"",{"$f":"IF(AND(B9<4,B9>0),\"*\",\"\")","v":""},null,18,{"$f":"IF(D15=1,\"Never\",IF(D15=2,\"Rarely\",IF(D15=3,\"Sometimes\",IF(D15=4,\"Often\",IF(D15=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(D15<4,D15>0),\"*\",\"\")","v":""},null,34,{"$f":"IF(H11=1,\"Never\",IF(H11=2,\"Rarely\",IF(H11=3,\"Sometimes\",IF(H11=4,\"Often\",IF(H11=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(H11<4,H11>0),\"*\",\"\")","v":""}]
[3,"","",null,19,"","",null,35,"",""]
[4,"","",null,20,"",{"$f":"IF(AND(D17<6,D17>2),\"*\",\"\")","v":""},null,36,"",""]
[5,"","",null,21,{"$f":"IF(F8=1,\"Never\",IF(F8=2,\"Rarely\",IF(F8=3,\"Sometimes\",IF(F8=4,\"Often\",IF(F8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(F8<6,F8>2),\"*\",\"\")","v":""},null,37,"",{"$f":"IF(AND(H14<6,H14>2),\"*\",\"\")","v":""}]
[6,"","",null,22,{"$f":"IF(F9=1,\"Never\",IF(F9=2,\"Rarely\",IF(F9=3,\"Sometimes\",IF(F9=4,\"Often\",IF(F9=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(F9<4,F9>0),\"*\",\"\")","v":""},null,38,"",""]
[7,"","",null,23,"",{"$f":"IF(AND(F10<4,F10>0),\"*\",\"\")","v":""},null,39,"",""]
[8,"","",null,24,"",{"$f":"IF(AND(F11<6,F11>2),\"*\",\"\")","v":""},null,40,"",""]
[9,"","",null,25,"",{"$f":"IF(AND(F12<4,F12>0),\"*\",\"\")","v":""},null,41,{"$f":"IF(J8=1,\"Never\",IF(J8=2,\"Rarely\",IF(J8=3,\"Sometimes\",IF(J8=4,\"Often\",IF(J8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(J8<4,J8>0),\"*\",\"\")","v":""}]
[10,"","",null,26,"",{"$f":"IF(AND(F13<4,F13>0),\"*\",\"\")","v":""},null,42,{"$f":"IF(J9=1,\"Never\",IF(J9=2,\"Rarely\",IF(J9=3,\"Sometimes\",IF(J9=4,\"Often\",IF(J9=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(J9<6,J9>2),\"*\",\"\")","v":""}]
[11,{"$f":"IF(D8=1,\"Never\",IF(D8=2,\"Rarely\",IF(D8=3,\"Sometimes\",IF(D8=4,\"Often\",IF(D8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(D8<4,D8>0),\"*\",\"\")","v":""},null,27,"","",null,43,"",{"$f":"IF(AND(J10<6,J10>2),\"*\",\"\")","v":""}]
[12,"",{"$f":"IF(AND(D9<4,D9>0),\"*\",\"\")","v":""},null,28,"",{"$f":"IF(AND(F15<6,F15>2),\"*\",\"\")","v":""},null,44,"",""]
[13,"","",null,29,"",{"$f":"IF(AND(F16<4,F16>0),\"*\",\"\")","v":""},null,45,"",{"$f":"IF(AND(J12<4,J12>0),\"*\",\"\")","v":""}]
[14,"","",null,30,"",{"$f":"IF(AND(F17<4,F17>0),\"*\",\"\")","v":""},null,46,"",{"$f":"IF(AND(J13<4,J13>0),\"*\",\"\")","v":""}]
[15,"","",null,31,{"$f":"IF(H8=1,\"Never\",IF(H8=2,\"Rarely\",IF(H8=3,\"Sometimes\",IF(H8=4,\"Often\",IF(H8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(H8<4,H8>0),\"*\",\"\")","v":""},null,47,"",""]
[16,"",{"$f":"IF(AND(D13<6,D13>2),\"*\",\"\")","v":""},null,32,{"$f":"IF(H9=1,\"Never\",IF(H9=2,\"Rarely\",IF(H9=3,\"Sometimes\",IF(H9=4,\"Often\",IF(H9=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(H9<6,H9>2),\"*\",\"\")","v":""},null,48,"",""]
[]
["Please move to next page for step 8: PPAQ Score Comparison"]

{"sheet":"PPAQ Score Comparison","index":7,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[23,0,23,2],[23,3,23,8],[23,12,23,14],[23,15,25,20],[24,0,24,2],[22,0,22,2],[22,3,22,8],[22,12,22,14],[22,15,22,20],[24,3,24,8],[24,12,24,14],[25,0,25,2],[25,3,25,8],[25,12,25,14],[26,15,28,20],[27,0,27,2],[27,3,27,8],[27,12,27,14],[28,0,28,2],[28,3,28,8],[28,12,28,14],[26,0,26,2],[26,3,26,8],[26,12,26,14],[26,9,26,11],[27,9,27,11],[28,9,28,11],[29,0,29,2],[29,3,29,8],[29,12,29,14],[29,15,31,20],[30,0,30,2],[30,3,30,8],[30,12,30,14],[31,0,31,2],[31,3,31,8],[31,12,31,14],[29,9,29,11],[30,9,30,11],[31,9,31,11],[34,0,34,2],[34,3,34,8],[34,12,34,14],[34,15,34,20],[33,0,33,20],[34,9,34,11],[35,0,35,2],[35,3,35,8],[35,12,35,14],[35,15,37,20],[36,0,36,2],[36,3,36,8],[36,12,36,14],[37,0,37,2],[37,3,37,8],[37,12,37,14],[35,9,35,11],[36,9,36,11],[37,9,37,11],[43,3,43,8],[43,12,43,14],[41,9,41,11],[42,9,42,11],[43,9,43,11],[48,18,48,20],[38,15,40,20],[39,0,39,2],[39,3,39,8],[39,12,39,14],[40,0,40,2],[40,3,40,8],[40,12,40,14],[38,0,38,2],[38,3,38,8],[38,12,38,14],[38,9,38,11],[39,9,39,11],[40,9,40,11],[0,3,0,20],[1,0,1,20],[2,16,2,20],[3,17,3,20],[4,0,4,20],[5,0,5,20],[17,17,17,20],[18,17,18,20],[19,17,19,20],[8,16,9,17],[17,9,19,12],[17,13,17,14],[18,13,18,14],[19,13,19,14],[0,0,0,2],[2,0,2,3],[2,5,2,14],[17,4,17,5],[18,4,18,5],[17,0,19,3],[19,4,19,5],[3,0,3,3],[3,5,3,14],[49,18,49,20],[50,18,50,20],[51,18,51,20],[52,18,52,20],[53,18,53,20],[20,0,20,20],[44,0,44,20],[45,0,45,20],[46,18,46,20],[47,18,47,20],[32,0,32,20],[21,0,21,20],[22,9,22,11],[23,9,23,11],[24,9,24,11],[25,9,25,11],[41,0,41,2],[41,3,41,8],[41,12,41,14],[41,15,43,20],[42,0,42,2],[42,3,42,8],[42,12,42,14],[43,0,43,2],[64,0,64,20],[59,18,59,20],[60,18,60,20],[61,18,61,20],[62,18,62,20],[63,0,63,20],[54,18,54,20],[55,18,55,20],[56,18,56,20],[57,18,57,20],[58,18,58,20]]}
[null,null,null,"Primary Care Behavioral Health Provider Adherence Questionnaire (PPAQ) Toolkit"]
["Comparing Your Scores"]
["Provider: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date: "]
["Clinic and Location: "]
["Overview: The PPAQ items are summed to create two subscales.  The first subscale is for the PPAQ items that measure essential behaviors that are highly consistent with Primary Care Behavioral Health.  Higher scores on this subscale indicate higher fidelity.  The second subscale is for the PPAQ items that measure behaviors that are typically inconsistent with Primary Care Behavioral Health.  Higher scores on this subscale indicate lower fidelity. Here your current (follow-up) score is compared to your previous score to show how your performance on the PPAQ has changed since the last time you completed the toolkit. "]
["Step 1: Your subscale scores are shown below. Your change score reflects how your scores differ since the last time you completed the PPAQ."]
["Item #","Baseline","Follow-Up","Item #","Baseline","Follow-Up","Item #","Baseline","Follow-Up","Item #","Baseline","Follow-Up","Item #","Baseline","Follow-Up"]
[1,{"$f":"IF('PPAQ Baseline'!L9=\"\",\"\",'PPAQ Baseline'!L9)","v":""},{"$f":"IF('PPAQ Follow Up'!L9=\"\",\"\",'PPAQ Follow Up'!L9)","v":""},11,{"$f":"IF('PPAQ Baseline'!L19=\"\",\"\",'PPAQ Baseline'!L19)","v":""},{"$f":"IF('PPAQ Follow Up'!L19=\"\",\"\",'PPAQ Follow Up'!L19)","v":""},21,{"$f":"IF('PPAQ Baseline'!L29=\"\",\"\",'PPAQ Baseline'!L29)","v":""},{"$f":"IF('PPAQ Follow Up'!L29=\"\",\"\",'PPAQ Follow Up'!L29)","v":""},31,{"$f":"IF('PPAQ Baseline'!L39=\"\",\"\",'PPAQ Baseline'!L39)","v":""},{"$f":"IF('PPAQ Follow Up'!L39=\"\",\"\",'PPAQ Follow Up'!L39)","v":""},41,{"$f":"IF('PPAQ Baseline'!L49=\"\",\"\",'PPAQ Baseline'!L49)","v":""},{"$f":"IF('PPAQ Follow Up'!L49=\"\",\"\",'PPAQ Follow Up'!L49)","v":""}]
[2,{"$f":"IF('PPAQ Baseline'!L10=\"\",\"\",'PPAQ Baseline'!L10)","v":""},{"$f":"IF('PPAQ Follow Up'!L10=\"\",\"\",'PPAQ Follow Up'!L10)","v":""},12,{"$f":"IF('PPAQ Baseline'!L20=\"\",\"\",'PPAQ Baseline'!L20)","v":""},{"$f":"IF('PPAQ Follow Up'!L20=\"\",\"\",'PPAQ Follow Up'!L20)","v":""},22,{"$f":"IF('PPAQ Baseline'!L30=\"\",\"\",'PPAQ Baseline'!L30)","v":""},{"$f":"IF('PPAQ Follow Up'!L30=\"\",\"\",'PPAQ Follow Up'!L30)","v":""},32,{"$f":"IF('PPAQ Baseline'!L40=\"\",\"\",'PPAQ Baseline'!L40)","v":""},{"$f":"IF('PPAQ Follow Up'!L40=\"\",\"\",'PPAQ Follow Up'!L40)","v":""},42,{"$f":"IF('PPAQ Baseline'!L50=\"\",\"\",'PPAQ Baseline'!L50)","v":""},{"$f":"IF('PPAQ Follow Up'!L50=\"\",\"\",'PPAQ Follow Up'!L50)","v":""},null,"PPAQ Response Categories"]
[3,{"$f":"IF('PPAQ Baseline'!L11=\"\",\"\",'PPAQ Baseline'!L11)","v":""},{"$f":"IF('PPAQ Follow Up'!L11=\"\",\"\",'PPAQ Follow Up'!L11)","v":""},13,{"$f":"IF('PPAQ Baseline'!L21=\"\",\"\",'PPAQ Baseline'!L21)","v":""},{"$f":"IF('PPAQ Follow Up'!L21=\"\",\"\",'PPAQ Follow Up'!L21)","v":""},23,{"$f":"IF('PPAQ Baseline'!L31=\"\",\"\",'PPAQ Baseline'!L31)","v":""},{"$f":"IF('PPAQ Follow Up'!L31=\"\",\"\",'PPAQ Follow Up'!L31)","v":""},33,{"$f":"IF('PPAQ Baseline'!L41=\"\",\"\",'PPAQ Baseline'!L41)","v":""},{"$f":"IF('PPAQ Follow Up'!L41=\"\",\"\",'PPAQ Follow Up'!L41)","v":""},43,{"$f":"IF('PPAQ Baseline'!L51=\"\",\"\",'PPAQ Baseline'!L51)","v":""},{"$f":"IF('PPAQ Follow Up'!L51=\"\",\"\",'PPAQ Follow Up'!L51)","v":""}]
[4,{"$f":"IF('PPAQ Baseline'!L12=\"\",\"\",'PPAQ Baseline'!L12)","v":""},{"$f":"IF('PPAQ Follow Up'!L12=\"\",\"\",'PPAQ Follow Up'!L12)","v":""},14,{"$f":"IF('PPAQ Baseline'!L22=\"\",\"\",'PPAQ Baseline'!L22)","v":""},{"$f":"IF('PPAQ Follow Up'!L22=\"\",\"\",'PPAQ Follow Up'!L22)","v":""},24,{"$f":"IF('PPAQ Baseline'!L32=\"\",\"\",'PPAQ Baseline'!L32)","v":""},{"$f":"IF('PPAQ Follow Up'!L32=\"\",\"\",'PPAQ Follow Up'!L32)","v":""},34,{"$f":"IF('PPAQ Baseline'!L42=\"\",\"\",'PPAQ Baseline'!L42)","v":""},{"$f":"IF('PPAQ Follow Up'!L42=\"\",\"\",'PPAQ Follow Up'!L42)","v":""},44,{"$f":"IF('PPAQ Baseline'!L52=\"\",\"\",'PPAQ Baseline'!L52)","v":""},{"$f":"IF('PPAQ Follow Up'!L52=\"\",\"\",'PPAQ Follow Up'!L52)","v":""},null,1,"Never"]
[5,{"$f":"IF('PPAQ Baseline'!L13=\"\",\"\",'PPAQ Baseline'!L13)","v":""},{"$f":"IF('PPAQ Follow Up'!L13=\"\",\"\",'PPAQ Follow Up'!L13)","v":""},15,{"$f":"IF('PPAQ Baseline'!L23=\"\",\"\",'PPAQ Baseline'!L23)","v":""},{"$f":"IF('PPAQ Follow Up'!L23=\"\",\"\",'PPAQ Follow Up'!L23)","v":""},25,{"$f":"IF('PPAQ Baseline'!L33=\"\",\"\",'PPAQ Baseline'!L33)","v":""},{"$f":"IF('PPAQ Follow Up'!L33=\"\",\"\",'PPAQ Follow Up'!L33)","v":""},35,{"$f":"IF('PPAQ Baseline'!L43=\"\",\"\",'PPAQ Baseline'!L43)","v":""},{"$f":"IF('PPAQ Follow Up'!L43=\"\",\"\",'PPAQ Follow Up'!L43)","v":""},45,{"$f":"IF('PPAQ Baseline'!L53=\"\",\"\",'PPAQ Baseline'!L53)","v":""},{"$f":"IF('PPAQ Follow Up'!L53=\"\",\"\",'PPAQ Follow Up'!L53)","v":""},null,2,"Rarely"]
[6,{"$f":"IF('PPAQ Baseline'!L14=\"\",\"\",'PPAQ Baseline'!L14)","v":""},{"$f":"IF('PPAQ Follow Up'!L14=\"\",\"\",'PPAQ Follow Up'!L14)","v":""},16,{"$f":"IF('PPAQ Baseline'!L24=\"\",\"\",'PPAQ Baseline'!L24)","v":""},{"$f":"IF('PPAQ Follow Up'!L24=\"\",\"\",'PPAQ Follow Up'!L24)","v":""},26,{"$f":"IF('PPAQ Baseline'!L34=\"\",\"\",'PPAQ Baseline'!L34)","v":""},{"$f":"IF('PPAQ Follow Up'!L34=\"\",\"\",'PPAQ Follow Up'!L34)","v":""},36,{"$f":"IF('PPAQ Baseline'!L44=\"\",\"\",'PPAQ Baseline'!L44)","v":""},{"$f":"IF('PPAQ Follow Up'!L44=\"\",\"\",'PPAQ Follow Up'!L44)","v":""},46,{"$f":"IF('PPAQ Baseline'!L54=\"\",\"\",'PPAQ Baseline'!L54)","v":""},{"$f":"IF('PPAQ Follow Up'!L54=\"\",\"\",'PPAQ Follow Up'!L54)","v":""},null,3,"Sometimes"]
[7,{"$f":"IF('PPAQ Baseline'!L15=\"\",\"\",'PPAQ Baseline'!L15)","v":""},{"$f":"IF('PPAQ Follow Up'!L15=\"\",\"\",'PPAQ Follow Up'!L15)","v":""},17,{"$f":"IF('PPAQ Baseline'!L25=\"\",\"\",'PPAQ Baseline'!L25)","v":""},{"$f":"IF('PPAQ Follow Up'!L25=\"\",\"\",'PPAQ Follow Up'!L25)","v":""},27,{"$f":"IF('PPAQ Baseline'!L35=\"\",\"\",'PPAQ Baseline'!L35)","v":""},{"$f":"IF('PPAQ Follow Up'!L35=\"\",\"\",'PPAQ Follow Up'!L35)","v":""},37,{"$f":"IF('PPAQ Baseline'!L45=\"\",\"\",'PPAQ Baseline'!L45)","v":""},{"$f":"IF('PPAQ Follow Up'!L45=\"\",\"\",'PPAQ Follow Up'!L45)","v":""},47,{"$f":"IF('PPAQ Baseline'!L55=\"\",\"\",'PPAQ Baseline'!L55)","v":""},{"$f":"IF('PPAQ Follow Up'!L55=\"\",\"\",'PPAQ Follow Up'!L55)","v":""},null,4,"Often"]
[8,{"$f":"IF('PPAQ Baseline'!L16=\"\",\"\",'PPAQ Baseline'!L16)","v":""},{"$f":"IF('PPAQ Follow Up'!L16=\"\",\"\",'PPAQ Follow Up'!L16)","v":""},18,{"$f":"IF('PPAQ Baseline'!L26=\"\",\"\",'PPAQ Baseline'!L26)","v":""},{"$f":"IF('PPAQ Follow Up'!L26=\"\",\"\",'PPAQ Follow Up'!L26)","v":""},28,{"$f":"IF('PPAQ Baseline'!L36=\"\",\"\",'PPAQ Baseline'!L36)","v":""},{"$f":"IF('PPAQ Follow Up'!L36=\"\",\"\",'PPAQ Follow Up'!L36)","v":""},38,{"$f":"IF('PPAQ Baseline'!L46=\"\",\"\",'PPAQ Baseline'!L46)","v":""},{"$f":"IF('PPAQ Follow Up'!L46=\"\",\"\",'PPAQ Follow Up'!L46)","v":""},48,{"$f":"IF('PPAQ Baseline'!L56=\"\",\"\",'PPAQ Baseline'!L56)","v":""},{"$f":"IF('PPAQ Follow Up'!L56=\"\",\"\",'PPAQ Follow Up'!L56)","v":""},null,5,"Always"]
[9,{"$f":"IF('PPAQ Baseline'!L17=\"\",\"\",'PPAQ Baseline'!L17)","v":""},{"$f":"IF('PPAQ Follow Up'!L17=\"\",\"\",'PPAQ Follow Up'!L17)","v":""},19,{"$f":"IF('PPAQ Baseline'!L27=\"\",\"\",'PPAQ Baseline'!L27)","v":""},{"$f":"IF('PPAQ Follow Up'!L27=\"\",\"\",'PPAQ Follow Up'!L27)","v":""},29,{"$f":"IF('PPAQ Baseline'!L37=\"\",\"\",'PPAQ Baseline'!L37)","v":""},{"$f":"IF('PPAQ Follow Up'!L37=\"\",\"\",'PPAQ Follow Up'!L37)","v":""},39,{"$f":"IF('PPAQ Baseline'!L47=\"\",\"\",'PPAQ Baseline'!L47)","v":""},{"$f":"IF('PPAQ Follow Up'!L47=\"\",\"\",'PPAQ Follow Up'!L47)","v":""},"PPAQ-E",{"$f":"SUM(B8:B17,E8:E12,E14:E16,H9:H10,H12:H14,H16:H17,K8,K10:K13,K15:K17,N8,N12:N15)","v":0},{"$f":"SUM(C8:C17,F8:F12,F14:F16,I9:I10,I12:I14,I16:I17,L8,L10:L13,L15:L17,O8,O12:O15)","v":0}]
[10,{"$f":"IF('PPAQ Baseline'!L18=\"\",\"\",'PPAQ Baseline'!L18)","v":""},{"$f":"IF('PPAQ Follow Up'!L18=\"\",\"\",'PPAQ Follow Up'!L18)","v":""},20,{"$f":"IF('PPAQ Baseline'!L28=\"\",\"\",'PPAQ Baseline'!L28)","v":""},{"$f":"IF('PPAQ Follow Up'!L28=\"\",\"\",'PPAQ Follow Up'!L28)","v":""},30,{"$f":"IF('PPAQ Baseline'!L38=\"\",\"\",'PPAQ Baseline'!L38)","v":""},{"$f":"IF('PPAQ Follow Up'!L38=\"\",\"\",'PPAQ Follow Up'!L38)","v":""},40,{"$f":"IF('PPAQ Baseline'!L48=\"\",\"\",'PPAQ Baseline'!L48)","v":""},{"$f":"IF('PPAQ Follow Up'!L48=\"\",\"\",'PPAQ Follow Up'!L48)","v":""},"PPAQ-I",{"$f":"SUM(E13,E17,H8,H11,H15,K9,K14,N9:N11)","v":0},{"$f":"SUM(F13,F17,I8,I11,I15,L9,L14,O9:O11)","v":0}]
["Subscale 1: \nEssential Behaviors\nHigher score desired",null,null,null,"Baseline Score:",null,{"$f":"+N16","v":0},"   out of\n/190",null,"Subscale 2: Inconsistent Behaviors\nLower score desired",null,null,null,"Baseline Score:",null,{"$f":"N17","v":0},"  out of\n/50"]
[null,null,null,null,"Follow-Up  Score",null,{"$f":"+O16","v":0},"   out of\n/190",null,null,null,null,null,"Follow-Up  Score",null,{"$f":"O17","v":0},"  out of\n/50"]
[null,null,null,null,"Your Change Score:",null,{"$f":"IF(O16>0,\"+\",IF(O16<0,\"-\"))","v":false},{"$f":"ABS(O16-N16)","v":0},null,null,null,null,null,"Your Change  Score:",null,{"$f":"IF(O17>0,\"+\",IF(O17<0,\"-\"))","v":false},{"$f":"ABS(O17-N17)","v":0}]
[]
["Step 2:  Your score for the first subscale (items essential for Primary Care Behavioral Health) is indicated under Provider Score with an arrow (←).  Scores in the green range are in the optimal range of fidelity, with yellow indicating moderate fidelity scores, and red indicating low fidelity scores."]
["Essential Items Possible Score",null,null,"Reference",null,null,null,null,null,"Provider Baseline Score",null,null,"Provider Follow Up Score ",null,null,"Interpretation"]
[190,null,null,"Highest Score ",null,null,null,null,null,{"$f":"IF(N16 = 190,\"←\",\"\")","v":""},null,null,{"$f":"IF(O16 = 190,\"←\",\"\")","v":""},null,null,"Your score is in the preferred level of fidelity for essential items. However, even within this range your practices might be improved by modifying any low items noted in Step 4 below.   "]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N16<190,N16>139),\"←\",\"\")","v":""},null,null,{"$f":"IF(AND(O16<190,O16>139),\"←\",\"\")","v":""}]
[139,null,null,"Top third ",null,null,null,null,null,{"$f":"IF(N16 = 139,\"←\",\"\")","v":""},null,null,{"$f":"IF(O16 = 139,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N16<139,N16>114),\"←\",\"\")","v":""},null,null,{"$f":"IF(AND(O16<139,O16>114),\"←\",\"\")","v":""},null,null,"Your score indicates a moderate level of fidelity for essential items.  Although several of your behaviors are in line with good practices, Step 4 will indicate which specific behaviors could be improved."]
[114,null,null,"Midpoint ",null,null,null,null,null,{"$f":"IF(N16 = 114,\"←\",\"\")","v":""},null,null,{"$f":"IF(O16 = 114,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N16<114,N16>88),\"←\",\"\")","v":""},null,null,{"$f":"IF(AND(O16<114,O16>88),\"←\",\"\")","v":""}]
[88,null,null,"Bottom third ",null,null,null,null,null,{"$f":"IF(N16 = 88,\"←\",\"\")","v":""},null,null,{"$f":"IF(O16 = 88,\"←\",\"\")","v":""},null,null,"Your score indicates a low level of fidelity for essential items.  Although some of your behaviors are in line with good practices, Step 4 will assist in identifying and prioritizing areas for improvement. "]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N16<88,N16>38),\"←\",\"\")","v":""},null,null,{"$f":"IF(AND(O16<88,O16>38),\"←\",\"\")","v":""}]
[38,null,null,"Lowest score ",null,null,null,null,null,{"$f":"IF(N16 = 38,\"←\",\"\")","v":""},null,null,{"$f":"IF(O16 = 38,\"←\",\"\")","v":""}]
[]
["Step 3:  Your score for the second subscale (items typically inconsistent with Primary Care Behavioral Health) is indicated under Provider Score with an arrow (←).  Scores in the green range are in the optimal range of fidelity, with yellow indicating moderate fidelity scores, and red indicating low fidelity scores."]
["Inconsistent Items Possible Score",null,null,"Reference",null,null,null,null,null,"Provider Baseline Score",null,null,"Provider Follow Up Score ",null,null,"Interpretation"]
[10,null,null,"Lowest Score ",null,null,null,null,null,{"$f":"IF(N17 = 10,\"←\",\"\")","v":""},null,null,{"$f":"IF(O17 = 10,\"←\",\"\")","v":""},null,null,"Your score is the preferred level of fidelity for these items. However, even within this range your practices might be improved by modifying any areas of suboptimal fidelity noted in Step 4 below.   "]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N17>10,N17<23),\"←\",\"\")","v":""},null,null,{"$f":"IF(AND(O17>10,O17<23),\"←\",\"\")","v":""}]
[23,null,null,"Top third ",null,null,null,null,null,{"$f":"IF(N17 = 23,\"←\",\"\")","v":""},null,null,{"$f":"IF(O17 = 23,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N17>23,N17<30),\"←\",\"\")","v":""},null,null,{"$f":"IF(AND(O17>23,O17<30),\"←\",\"\")","v":""},null,null,"Your score indicates a moderate level of fidelity for these items.  Although several of your behaviors are in line with good practices, Step 4 will indicate which specific behaviors could be improved."]
[30,null,null,"Midpoint",null,null,null,null,null,{"$f":"IF(N17 = 30,\"←\",\"\")","v":""},null,null,{"$f":"IF(O17 = 30,\"←\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N17>30,N17<36),\"←\",\"\")","v":""},null,null,{"$f":"IF(AND(O17>30,O17<36),\"←\",\"\")","v":""}]
[36,null,null,"Bottom third ",null,null,null,null,null,{"$f":"IF(N17 = 36,\"←\",\"\")","v":""},null,null,{"$f":"IF(O17 = 36,\"←\",\"\")","v":""},null,null,"Your score indicates a low level of fidelity for these items. Although some of your behaviors are in line with good practices, Step 4 will assist in identifying and prioritizing areas for improvement."]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N17>36,N17<50),\"←\",\"\")","v":""},null,null,{"$f":"IF(AND(O17>36,O17<50),\"←\",\"\")","v":""}]
[50,null,null,"Highest score",null,null,null,null,null,{"$f":"IF(N17 = 50,\"←\",\"\")","v":""},null,null,{"$f":"IF(O17 = 50,\"←\",\"\")","v":""}]
[]
["Step 4:  In addition to subscale scores noted above, the tables below identify specific areas of low fidelity that can be targeted for improvement.  An asterisk (*) appears for any individual item which scored in the low fidelity range.  Note that items for subscale 2  (behaviors that are typically inconsistent with Primary Care Behavioral Health) are shaded in gray. Place mouse cursor over item # to view question. *BL = Baseline, F/U = Follow-Up"]
["Item #","BL","Low?","F/U","Low?",null,"Item #","BL","Low?","F/U","Low?",null,"Item #","BL","Low?","F/U","Low?"]
[1,{"$f":"IF(B8=1,\"Never\",IF(B8=2,\"Rarely\",IF(B8=3,\"Sometimes\",IF(B8=4,\"Often\",IF(B8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(B8<4,B8>0),\"*\",\"\")","v":""},{"$f":"IF(C8=1,\"Never\",IF(C8=2,\"Rarely\",IF(C8=3,\"Sometimes\",IF(C8=4,\"Often\",IF(C8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(C8<4,C8>0),\"*\",\"\")","v":""},null,17,{"$f":"IF(E14=1,\"Never\",IF(E14=2,\"Rarely\",IF(E14=3,\"Sometimes\",IF(E14=4,\"Often\",IF(E14=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(E14<4,E14>0),\"*\",\"\")","v":""},{"$f":"IF(F14=1,\"Never\",IF(F14=2,\"Rarely\",IF(F14=3,\"Sometimes\",IF(F14=4,\"Often\",IF(F14=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(F14<4,F14>0),\"*\",\"\")","v":""},null,33,{"$f":"IF(K10=1,\"Never\",IF(K10=2,\"Rarely\",IF(K10=3,\"Sometimes\",IF(K10=4,\"Often\",IF(K10=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(K10<4,K10>0),\"*\",\"\")","v":""},{"$f":"IF(L10=1,\"Never\",IF(L10=2,\"Rarely\",IF(L10=3,\"Sometimes\",IF(L10=4,\"Often\",IF(L10=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(L10<4,L10>0),\"*\",\"\")","v":""}]
[2,"","","","",null,18,{"$f":"IF(E15=1,\"Never\",IF(E15=2,\"Rarely\",IF(E15=3,\"Sometimes\",IF(E15=4,\"Often\",IF(E15=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(E15<4,E15>0),\"*\",\"\")","v":""},{"$f":"IF(F15=1,\"Never\",IF(F15=2,\"Rarely\",IF(F15=3,\"Sometimes\",IF(F15=4,\"Often\",IF(F15=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(F15<4,F15>0),\"*\",\"\")","v":""},null,34,"",{"$f":"IF(AND(K11<4,K11>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(L11<4,L11>0),\"*\",\"\")","v":""}]
[3,"","","","",null,19,{"$f":"IF(E16=1,\"Never\",IF(E16=2,\"Rarely\",IF(E16=3,\"Sometimes\",IF(E16=4,\"Often\",IF(E16=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(E16<4,E16>0),\"*\",\"\")","v":""},{"$f":"IF(F16=1,\"Never\",IF(F16=2,\"Rarely\",IF(F16=3,\"Sometimes\",IF(F16=4,\"Often\",IF(F16=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(F16<4,F16>0),\"*\",\"\")","v":""},null,35,"",{"$f":"IF(AND(K12<4,K12>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(L12<4,L12>0),\"*\",\"\")","v":""}]
[4,"","","","",null,20,{"$f":"IF(E17=1,\"Never\",IF(E17=2,\"Rarely\",IF(E17=3,\"Sometimes\",IF(E17=4,\"Often\",IF(E17=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(E17<6,E17>2),\"*\",\"\")","v":""},{"$f":"IF(F17=1,\"Never\",IF(F17=2,\"Rarely\",IF(F17=3,\"Sometimes\",IF(F17=4,\"Often\",IF(F17=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(F17<6,F17>2),\"*\",\"\")","v":""},null,36,"",{"$f":"IF(AND(K13<4,K13>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(L13<4,L13>0),\"*\",\"\")","v":""}]
[5,"","","","",null,21,{"$f":"IF(H8=1,\"Never\",IF(H8=2,\"Rarely\",IF(H8=3,\"Sometimes\",IF(H8=4,\"Often\",IF(H8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(H8<6,H8>2),\"*\",\"\")","v":""},{"$f":"IF(I8=1,\"Never\",IF(I8=2,\"Rarely\",IF(I8=3,\"Sometimes\",IF(I8=4,\"Often\",IF(I8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(I8<6,I8>2),\"*\",\"\")","v":""},null,37,"",{"$f":"IF(AND(K14<6,K14>2),\"*\",\"\")","v":""},"",{"$f":"IF(AND(L14<6,L14>2),\"*\",\"\")","v":""}]
[6,"","","","",null,22,"",{"$f":"IF(AND(H9<4,H9>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(I9<4,I9>0),\"*\",\"\")","v":""},null,38,"",{"$f":"IF(AND(K15<4,K15>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(L15<4,L15>0),\"*\",\"\")","v":""}]
[7,"","","","",null,23,"",{"$f":"IF(AND(H10<4,H10>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(I10<4,I10>0),\"*\",\"\")","v":""},null,39,"",{"$f":"IF(AND(K16<4,K16>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(L16<4,L16>0),\"*\",\"\")","v":""}]
[8,"","","","",null,24,"",{"$f":"IF(AND(H11<6,H11>2),\"*\",\"\")","v":""},"",{"$f":"IF(AND(I11<6,I11>2),\"*\",\"\")","v":""},null,40,"",{"$f":"IF(AND(K17<4,K17>0),\"*\",\"\")","v":""},{"$f":"IF(L17=1,\"Never\",IF(L17=2,\"Rarely\",IF(L17=3,\"Sometimes\",IF(L17=4,\"Often\",IF(L17=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(L17<4,L17>0),\"*\",\"\")","v":""}]
[9,"","","","",null,25,"",{"$f":"IF(AND(H12<4,H12>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(I12<4,I12>0),\"*\",\"\")","v":""},null,41,{"$f":"IF(N8=1,\"Never\",IF(N8=2,\"Rarely\",IF(N8=3,\"Sometimes\",IF(N8=4,\"Often\",IF(N8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(N8<4,N8>0),\"*\",\"\")","v":""},{"$f":"IF(O8=1,\"Never\",IF(O8=2,\"Rarely\",IF(O8=3,\"Sometimes\",IF(O8=4,\"Often\",IF(O8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(O8<4,O8>0),\"*\",\"\")","v":""}]
[10,"","",{"$f":"IF(C17=1,\"Never\",IF(C17=2,\"Rarely\",IF(C17=3,\"Sometimes\",IF(C17=4,\"Often\",IF(C17=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(C17<4,C17>0),\"*\",\"\")","v":""},null,26,"",{"$f":"IF(AND(H13<4,H13>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(I13<4,I13>0),\"*\",\"\")","v":""},null,42,"",{"$f":"IF(AND(N9<6,N9>2),\"*\",\"\")","v":""},{"$f":"IF(O9=1,\"Never\",IF(O9=2,\"Rarely\",IF(O9=3,\"Sometimes\",IF(O9=4,\"Often\",IF(O9=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(O9<6,O9>2),\"*\",\"\")","v":""}]
[11,{"$f":"IF(E8=1,\"Never\",IF(E8=2,\"Rarely\",IF(E8=3,\"Sometimes\",IF(E8=4,\"Often\",IF(E8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(E8<4,E8>0),\"*\",\"\")","v":""},{"$f":"IF(F8=1,\"Never\",IF(F8=2,\"Rarely\",IF(F8=3,\"Sometimes\",IF(F8=4,\"Often\",IF(F8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(F8<4,F8>0),\"*\",\"\")","v":""},null,27,"",{"$f":"IF(AND(H14<4,H14>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(I14<4,I14>0),\"*\",\"\")","v":""},null,43,"",{"$f":"IF(AND(N10<6,N10>2),\"*\",\"\")","v":""},"",{"$f":"IF(AND(O10<6,O10>2),\"*\",\"\")","v":""}]
[12,"",{"$f":"IF(AND(E9<4,E9>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(F9<4,F9>0),\"*\",\"\")","v":""},null,28,"",{"$f":"IF(AND(H15<6,H15>2),\"*\",\"\")","v":""},"",{"$f":"IF(AND(I15<6,I15>2),\"*\",\"\")","v":""},null,44,"",{"$f":"IF(AND(N11<6,N11>2),\"*\",\"\")","v":""},"",""]
[13,"",{"$f":"IF(AND(E10<4,E10>0),\"*\",\"\")","v":""},"","",null,29,"",{"$f":"IF(AND(H16<4,H16>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(I16<4,I16>0),\"*\",\"\")","v":""},null,45,"",{"$f":"IF(AND(N12<4,N12>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(O12<4,O12>0),\"*\",\"\")","v":""}]
[14,"",{"$f":"IF(AND(E11<4,E11>0),\"*\",\"\")","v":""},"","",null,30,"",{"$f":"IF(AND(H17<4,H17>0),\"*\",\"\")","v":""},{"$f":"IF(I17=1,\"Never\",IF(I17=2,\"Rarely\",IF(I17=3,\"Sometimes\",IF(I17=4,\"Often\",IF(I17=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(I17<4,I17>0),\"*\",\"\")","v":""},null,46,"",{"$f":"IF(AND(N13<4,N13>0),\"*\",\"\")","v":""},"",{"$f":"IF(AND(O13<4,O13>0),\"*\",\"\")","v":""}]
[15,"",{"$f":"IF(AND(E12<4,E12>0),\"*\",\"\")","v":""},"","",null,31,{"$f":"IF(K8=1,\"Never\",IF(K8=2,\"Rarely\",IF(K8=3,\"Sometimes\",IF(K8=4,\"Often\",IF(K8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(K8<4,K8>0),\"*\",\"\")","v":""},{"$f":"IF(L8=1,\"Never\",IF(L8=2,\"Rarely\",IF(L8=3,\"Sometimes\",IF(L8=4,\"Often\",IF(L8=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(L8<4,L8>0),\"*\",\"\")","v":""},null,47,"",{"$f":"IF(AND(N14<4,N14>0),\"*\",\"\")","v":""},"",""]
[16,"",{"$f":"IF(AND(E13<6,E13>2),\"*\",\"\")","v":""},"",{"$f":"IF(AND(F13<6,F13>2),\"*\",\"\")","v":""},null,32,{"$f":"IF(K9=1,\"Never\",IF(K9=2,\"Rarely\",IF(K9=3,\"Sometimes\",IF(K9=4,\"Often\",IF(K9=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(K9<6,K9>2),\"*\",\"\")","v":""},{"$f":"IF(L9=1,\"Never\",IF(L9=2,\"Rarely\",IF(L9=3,\"Sometimes\",IF(L9=4,\"Often\",IF(L9=5,\"Always\",\"\")))))","v":""},{"$f":"IF(AND(L9<6,L9>2),\"*\",\"\")","v":""},null,48,"",{"$f":"IF(AND(N15<4,N15>0),\"*\",\"\")","v":""},"",""]