{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["HARMS Patient Master List","UDT Selection List","Recall List"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HARMS Patient Master List","index":0,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[6,0,6,7],[3,1,5,7],[0,8,1,11],[0,0,5,0],[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,8,4,11]]}
[null,"Urine Drug Testing Randomization: Patient Master List and Randomization",null,null,null,null,null,null,"*Note: When you open this file, you may get a message that “Macros have been disabled”. If so, click “Enable Content” for it to work properly."]
[null,"Background: This spreadsheet is a “one-stop-shop” when selecting your HARMS Program patients for urine drug testing. This tab of the spreadsheet maintains the master list of patient names and risk categories, and randomly generates the months for each patient to provide a UDT. The UDT Selection List tab at the bottom generates a user-friendly list for each month that can be used by booking staff to book patients in for their tests. \n"]
[null,"Randomization protocol: Patients are selected for UDT at a rate concordant with their risk, in the following manner: Low Risk (Level 1-2) – 1 UDT per year; Medium Risk (Level 3) – 2 UDT per year; High Risk (Level 4) – 6 UDT per year; Structured (very high risk – Level 5) and Addiction (level 6) patients are not selected in the same randomized manner. Instead, patients in these categories typically provide a scheduled UDT every 1-2 weeks or in accordance with physician instructions.\nIn addition to the months per year selection, clinics have the option of an additional randomization of 5% of patients each month (including Level 5 and 6). This ensures that any patient could be selected any month and avoids the scenario where a patient knows he/she has already provided the number of UDT for the year so won’t be selected again. See UDT Selection List tab for more details."]
[null,"How to use this:\n1) First time use - enter all patient names and select their risk from the dropdown menu. Once all names are entered, click “Generate All\" at the top and this will randomly select the appropriate number of months for that risk category for each patient. You can then go to UDT Selection List tab to view a list of patients organized for any given month.\n2) New patient - if you are just adding a new patient(s) to an existing list, enter the patient name in the next row, select risk category, and click “Generate New” at the top.\n3) Patient risk category change - click the risk category and select the new category. Delete the old randomization months for that patient and select “Generate New”.\n4) New year - to generate completely new randomized months for everyone (for example 12 months after generating the initial list, when you need a new list), simply select “Generate All” and select “Yes” when asked about overwriting data.\nOnce random months have been generated, click on UDT Selection List tab at the bottom and follow instructions there for booking.",null,null,null,null,null,null,"Summary of buttons: \nGenerate All: replaces all of the randomly generated months for all patients.\nGenerate New: generates random months only for new patients (ie patients that have all blanks under \"Month for random UDT\" columns)"]
[]
[]
[]
["Name","Risk Category","Month for random UDT","Month for random UDT","Month for random UDT","Month for random UDT","Month for random UDT","Month for random UDT","Prescribing physician (MRP)",null,null,null,null,null,null,"Low (Level 1-2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium (Level 3)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High (Level 4)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Structured (Very High - Level 5)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Addiction (Level 6)"]

{"sheet":"UDT Selection List","index":1,"n_rows":8,"n_cols":24,"rows_kept":8,"cut":false,"hidden":false,"merged":[[4,0,4,1],[0,2,0,7],[1,2,3,7],[4,2,4,7]]}
[null,null,"Urine Drug Testing Randomization: Patient Lists for Booking"]
[null,null,"Background: This tab of the spreadsheet generates a user-friendly list for each month that can be used by booking staff to book patients in for their tests. The HARMS Patient Master List tab maintains the actual data (master list of patient names and risk categories, and randomly generated months for each patient), and this sheet simply organizes that data. It also offers the option of an additional randomization of 5% of patients each month (including for risk categories Level 5 and 6). This 5% additional randomization option ensures that any patient could be selected any month and avoids the scenario where a patient knows he/she has already provided the number of UDT for the year so won’t be selected again."]
[]
[]
[null,null,"How to use this: This sheet simply compiles the data from the HARMS Patient Master List tab. When you first create your patient master list, and anytime you change something in the HARMS Patient Master List (new patient, new risk category, etc.), click “Pull All Months” here and this tab will be updated to reflect any changes there. You don’t have to worry about clicking a button here and losing any data in the HARMS Patient Master List (click “yes” when this overwrite warning comes up – it’s just updating this tab). In this sheet you will notice that there are two lists of patients for each month. The [month] column is a list of patients for that month randomly generated in the HARMS Patient Master List tab, using the 1/2/6 random months per year (for low/medium/high risk patients, respectively). If your clinic chooses to use the option of selecting an additional 5% of patients each month, the [month] (Random) column contains this list for each month. To generate this 5% randomization list, simply click “Monthly Random” and it will randomly select 5% of all patients from the master list and list them under the [month] (Random) column for the current month. At the discretion of your clinic, if someone is on both the [month] and [month] (Random) lists for the same month then you may consider only booking him/her one UDT that month. "]
["January","January (Random)","February ","February (Random)","March","March (Random)","April","April (Random)","May","May (Random)","June","June (Random)","July","July (Random)","August","August (Random)","September","September (Random)","October","October (Random)","November","November (Random)","December","December (Random)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Patient 3"]

{"sheet":"Recall List","index":2,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,1,6,1],[5,2,5,3],[5,4,5,5],[1,2,3,6],[4,2,4,6],[0,2,0,6],[0,0,4,1],[5,6,5,7],[5,0,6,0]]}
[null,null,"Urine Drug Testing Randomization: Recall List"]
[null,null,"Background: This tab of the spreadsheet is meant to keep track of patients that, despite being selected for a UDT, are not providing one. This could be due to, among others: difficulties reaching the patient, patient travel or work schedule interference, cancellations, \"no-shows\", or inability to urinate at the time of the appointment. The general idea of a recall list is that if someone is selected to provide a UDT then we want to make sure that a UDT is provided (better late than never). What we found when we first analyzed HARMS was that some patients were randomized, but fell through the cracks and never provided a UDT, so this is meant to minimize the chance of that happening."]
[]
[]
[null,null,"How to use this: Copy and paste the patient's name into the name column. Enter the date that the patient was randomized, and document each attempt at contacting the patient. Enter the action taken. It is recommended that the prescribing physician be contacted if patient does not provide a UDT fore more than 1-2 months after being selected, or if there are two no-shows or last-minute cancellations. Once a patient provides a UDT, name can be removed from this list."]
["Name","Date randomized","Attempt #1",null,"Attempt #2",null,"Attempt #3",null,"Attempt #4",null,"Attempt #5",null,"Attempt #6",null,"General Ongoing Comments"]
[null,null,"Reason for failure to provide UDT","Action taken and general comments","Reason for failure to provide UDT","Action taken and general comments","Reason for failure to provide UDT","Action taken and general comments","Reason for failure to provide UDT","Action taken and general comments","Reason for failure to provide UDT","Action taken and general comments","Reason for failure to provide UDT","Action taken and general comments","Reason for failure to provide UDT","Action taken and general comments"]
["Example Patient","2019-01-01","Eg: didn't answer phone - left message, or no-show, or cancellation, etc.","Eg: no action taken, or Physician notified, etc."]