{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calculator"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Calculator","index":0,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,5,37,8],[2,5,3,8],[25,5,27,8],[35,5,36,8],[7,6,9,8],[31,5,32,8],[24,5,24,8],[6,5,6,8],[28,5,28,8],[29,5,29,8]]}
[]
[]
[null,null,null,null,null,"OPIOID DOSE CALCULATOR"]
[]
[null,null,null,null,null,"Optional:  ","Patient name:"]
[null,null,null,null,null,null,"Today's date:",null,{"$f":"TODAY()","v":"2024-08-13"}]
[]
[null,null,null,null,null,"Instructions:","Fill in the mg per day* for whichever opioids your patient is taking.  For transdermal products, enter the total patch strength. The spreadsheet will automatically calculate the total morphine equivalents per day.  "]
[]
[]
[null,null,null,null,null,"Opioid (oral or transdermal):","mg per day*:",null,"Morphine equivalents:"]
[null,null,null,null,null,"*Buprenorphine transdermal (in mcg/hr)",null,null,{"$f":"G12*2.2","v":0}]
[null,null,null,null,null,"Codeine",null,null,{"$f":"G13*0.15","v":0}]
[null,null,null,null,null,"Fentanyl transdermal (in mcg/hr)",null,null,{"$f":"G14*2.4","v":0}]
[null,null,null,null,null,"Hydrocodone",null,null,{"$f":"G15*1","v":0}]
[null,null,null,null,null,"Hydromorphone",null,null,{"$f":"G16*5","v":0}]
[null,null,null,null,null,"Methadone ",null,null,{"$f":"IF(G17<=20,G17*4,IF(AND(G17>20,G17<=40),G17*8,IF(AND(G17>40,G17<=60),G17*10,IF(G17>60,G17*12))))","v":0}]
[null,null,null,null,null,"Morphine",null,null,{"$f":"G18*1","v":0}]
[null,null,null,null,null,"Oxycodone",null,null,{"$f":"G19*1.5","v":0}]
[null,null,null,null,null,"Oxymorphone",null,null,{"$f":"G20*3","v":0}]
[null,null,null,null,null,"Tapentadol",null,null,{"$f":"G21*0.4","v":0}]
[null,null,null,null,null,"Tramadol",null,null,{"$f":"G22*0.2","v":0}]
[]
[null,null,null,null,null,"TOTAL daily morphine equivalent dose (MED) =",null,null,{"$f":"SUM(I12:I23)","v":0}]
[null,null,null,null,null,"* Note: All doses expressed in mg per day with exception of buprenorphine and fentanyl transdermal, which are expressed in mcg per hour"]
[null,null,null,null,null,"If this value is less than 120mg Morphine Equivalent Dose (MED), please follow Part I of the AMDG Interagency Guideline on Opioid Dosing for Chronic Non-cancer Pain.  Referral for pain management consultation is required before exceeding 120mg MED daily.  See:"]
[]
[]
[null,null,null,null,null,"www.agencymeddirectors.wa.gov/opioiddosing.asp"]
[null,null,null,null,null,"www.doh.wa.gov/hsqa/professions/painmanagement/"]
[null,null,null,null,null," "]
[null,null,null,null,null,"If this value is greater than 120mg MED, please follow Part II of the AMDG Interagency Guideline on Opioid Dosing for Chronic Non-cancer Pain.  See: www.agencymeddirectors.wa.gov/opioiddosing.asp"]
[]
[]
[]
[null,null,null,null,null,"CAUTION:  This calculator should NOT be used to determine doses when converting a patient from one opioid to another.  This is especially important for fentanyl and methadone conversions.  Equianalgesic dose ratios are only approximations and do not account for genetic factors, incomplete cross-tolerance, and pharmacokinetics.  *Buprenorphine has partial µ-opioid receptor agonist activity with resultant ceiling effects compared with full µ-opioid receptor agonists. Buprenorphine transdermal is NOT approved for opioid use disorder, and its inclusion in this calculator should not be applied to clinical decisions related to the management of opioid use disorder. "]
[]
[null,null,null,null,null,"This opioid dose calculator was developed by the Washington State Agency Medical Directors' Group to be used in conjunction with the Interagency Guideline on Opioid Dosing for Chronic Non-cancer Pain.  For more information, please refer to the guideline at:\nhttp://www.agencymeddirectors.wa.gov/opioiddosing.asp\n"]