# Medication Dose Calculation Worksheet - Excel by usc41480

VIEWS: 0 PAGES: 3

• pg 1
```									                               MedRec-HC 4 - Percentage of Medication Discrepancies Identified by Type

100%

90%

80%

70%

60%
Percent

50%

40%

30%

20%

10%

0%
Nov Jan Mar May Jul Sep Nov Jan Mar May Jul Sep Nov Jan Mar May Jul Sep Nov Jan Mar May Jul Sep Nov
2007 2008 2008 2008 2008 2008 2008 2009 2009 2009 2009 2009 2009 2010 2010 2010 2010 2010 2010 2011 2011 2011 2011 2011 2011
Month
Percentage of medications with NO associated discrepancy in this month's sample. Subtract 4.03 from 4.02 and divide by # 4.02 . Multiply by 100.
A 1 -Percentage of medication discrepancies associated with a Medication not currently prescribed. Divide # 4.04 by # 4.03. Multiply by 100.
A 2 - Percentage of medication discrepancies associated with No Longer Taking Medication as prescribed. Divide # 4.05 by # 4.03. Multiply by 100.
A 3 - Percentage of medication discrepancies associated with Over-The-Counter (OTC) medications not taken as directed. Divide # 4.06 by # 4.03. Multiply by 100.
A 4 - Percentage of medication discrepancies associated with a Drug Allergy. Divide # 4.07 by # 4.03. Multiply by 100.
A 5 - Percentage of medication discrepancies associated with a Drug Duplication. Divide # 4.08 by # 4.03. Multiply by 100.
A 6 - Percentage of medication discrepancies associated with a Drug Interaction. Divide # 4.09 by # 4.03. Multiply by 100.
A 7 - Percentage of medication discrepancies associated with a Drug Formulation. Divide # 4.10 by # 4.03. Multiply by 100.
B 1 -Percentage of medication discrepancies associated with a Difference in Dose. Divide # 4.11 by # 4.03. Multiply by 100.
C 1 -Percentage of medication discrepancies associated with a Difference in Route. Divide # 4.12 by # 4.03. Multiply by 100.
D 1 - Percentage of medication discrepancies associated with a Difference in Frequency. Divide # 4.13 by # 4.03. Multiply by 100.
E 1 - Percentage of medication discrepancies associated with the Other medication discrepancies. Divide # 4.14 by # 4.03. Multiply by 100.
MedRec-HC 4 - Percentage of Medication Discrepancies Identified by Type - Measurement Worksheet
Intervention: Prevention of Adverse Drug Events in Home Care Through Medication Reconciliation                                                                                                                                                                                                                   Baseline
Definition               The classification of each medication as a discrepancy and the assignment of the discrepencies to a classification category. Each
medication order identified as having a discrepancy may be assigned to only one "discrepancy category". Clinicians can select whichever
they think is the most important. However, for those medication orders for which more than one discrepancy category applies equally it is
often helpful to follow the alphabetical order e.g A1, A2, A3...E1. For example: for a medication order which is for an incorrect medication
(A1), and dose (B1) and route (C1) - select A1.                                                                                                                                                                                                                                         Early
Transfer
Goal                    100% of discrepancies are coded                                                                                                                                                                                                                                                          Full
Discharge
Data Collection Details
Organization Name                                                                                                                    Team #
Health Region                                                                                                                        Point of Transfer
Client Sample           Describe the source of the client sample e.g., clients >65 years old; clients >75 years old; clients with >4 admit meds; clients with >5 admit meds etc.

2007                                                    2008                                                                            2009                                                                    2010                                                                      2011
Nov     Dec     Jan     Feb     Mar     Apr    May     Jun      Jul    Aug     Sep     Oct     Nov   Dec   Jan   Feb   Mar   Apr   May   Jun   Jul   Aug   Sep   Oct   Nov   Dec   Jan   Feb   Mar   Apr   May   Jun   Jul   Aug   Sep     Oct   Nov   Dec   Jan   Feb   Mar   Apr   May   Jun   Jul   Aug   Sep   Oct   Nov   Dec
Calculation of Denominator
Implementation Stage

4.01 Total number of clients in this month's sample with a
completed Best Possible Medication History (BPMH).
4.02 Total number of medications with or without a
discrepancy identified in the sample for this reporting
period.
4.03 Total number of medications with a discrepancy
identified in the sample for this reporting period.
Calculation of Numerator
4.04 A1 -Total number of medication discrepancies in
month's sample (# 4.03) associated with a
Medication not currently prescribed. That is,
prescription medications which the client is now taking
but is not currently prescribed by the prescriber
(includes samples, prescription medications and non-
prescription medications).
4.05 A2 - Total number of medication discrepancies in
month's sample (# 4.02) associated with a clients No
Longer Taking Medication as prescribed. That is,
the client is no longer taking the medication but it has
been prescribed.
4.06 A3 -Total number of medication discrepancies in
month's sample (# 4.02) associated with Over-The-
Counter (OTC) medication not taken as
prescribed. That is, the Client has not been taking
OTC medication as directed by family physician/RN
(NP)
4.07 A4 -Total number of medication discrepancies in
month's sample (# 4.02) associated with a Drug
Allergy. That is, the Client has a clinically significant
medication allergy to prescribed medication

4.08 A5 - Total number of medication discrepancies in
month's sample (# 4.02) associated with a Drug
Duplication. That is, the Client has inadvertently
been prescribed two medications from the same
therapeutic class
4.09 A6 -Total number of medication discrepancies in
month's sample (# 4.02) associated with a Drug
Interaction. That is, the Client has a clinically
significant drug interaction to prescribed medication.
4.10 A7 -Total number of medication discrepancies in
month's sample (# 4.02) associated with a Drug
Formulation i.e. sustained release vs. immediate
release- incorrect or omitted.
4.11 B1 -Total number of medication discrepancies in
month's sample (# 4.02) associated with a
Difference in Dose . That is, the dose that the client
has been taking is/are different from what was
prescribed.
4.12 C 1 -Total number of medication discrepancies in
month's sample (# 4.02) associated with a
Difference in Route. That is, frequency that the
client has been taking is/are different from what was
prescribed.
4.13 D 1 -Total number of medication discrepancies in
month's sample (# 4.02) associated with a
Difference in Frequency. That is, the route that the
client has been taking is/are different from what was
prescribed.
4.14 E 1 -Total number of medication discrepancies in
month's sample (# 4.02) associated with Other
medication discrepancies. That is, there are other
discrepancies not identified above which may cause
harm to the client (includes illegible orders).
Final Calculation
4.15 Percentage of medications with NO associated
discrepancy in this month's sample. Subtract 4.03                 #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
from 4.02 and divide by # 4.02 . Multiply by 100.
4.16 A 1 -Percentage of medication discrepancies
associated with a Medication not currently
#### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
prescribed. Divide # 4.04 by # 4.03. Multiply by 100.

4.17 A 2 - Percentage of medication discrepancies
associated with No Longer Taking Medication as                   #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
prescribed. Divide # 4.05 by # 4.03. Multiply by 100.
4.18 A 3 - Percentage of medication discrepancies
associated with Over-The-Counter (OTC)
#### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
medications not taken as directed. Divide # 4.06
by # 4.03. Multiply by 100.
4.19 A 4 - Percentage of medication discrepancies
associated with a Drug Allergy. Divide # 4.07 by #               #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
4.03. Multiply by 100.
4.20 A 5 - Percentage of medication discrepancies
associated with a Drug Duplication. Divide # 4.08                #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
by # 4.03. Multiply by 100.
4.20 A 6 - Percentage of medication discrepancies
associated with a Drug Interaction. Divide # 4.09 by #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
# 4.03. Multiply by 100.
4.22 A 7 - Percentage of medication discrepancies
associated with a Drug Formulation. Divide # 4.10                #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
by # 4.03. Multiply by 100.
4.23 B 1 -Percentage of medication discrepancies
associated with a Difference in Dose. Divide # 4.11              #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
by # 4.03. Multiply by 100.
4.24 C 1 -Percentage of medication discrepancies
associated with a Difference in Route. Divide #                  #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
4.12 by # 4.03. Multiply by 100.
4.25 D 1 - Percentage of medication discrepancies
associated with a Difference in Frequency. Divide                #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
# 4.13 by # 4.03. Multiply by 100.
4.26 E 1 - Percentage of medication discrepancies
associated with the Other medication discrepancies.              #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### #### ####
Divide # 4.14 by # 4.03. Multiply by 100.
GOAL*:
Data Year Data Month   Completed By   Email   Phone Number   Date of Submission (dd/mm/yyyy)

2007        Nov
Dec

2008        Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec

2009        Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec

2010        Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec

2011        Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec

```
To top