How to write a drug accountability formula?

[orlandomedic]

I work in clinical research and would like a program to calculate a patient's medication compliance between visits and to share with the whole team. This would make a lot of people happy and it's something we can print and place in the chart.
Formula
Calculate the percentage difference between two numbers(Total dispensed - returned) / (Days between visits x dose[# of pills])
Example:
(200-120) / (31 x 3) = 80 / 93 = 0.86 x 100 = 86%
Any help would be greatly appreciated!!

 

[shg]

Looks like you've got it sorted -- what's your question?

 

[orlandomedic]

Hi,
How would I wite this formula in a language to use in excel ?
Thank you!

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][td="bgcolor:#C0C0C0"]

E​

[/td][td="bgcolor:#C0C0C0"]

F​

[/td][td="bgcolor:#C0C0C0"]

G​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

Visit​

[/td][td="bgcolor:#F3F3F3"]

Dispensed​

[/td][td="bgcolor:#F3F3F3"]

Dose​

[/td][td="bgcolor:#F3F3F3"]

Visit​

[/td][td="bgcolor:#F3F3F3"]

Returned​

[/td][td="bgcolor:#F3F3F3"]

Compliance​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

1 Jan 2018​

[/td][td]

200​

[/td][td]

3​

[/td][td]

1 Feb 2018​

[/td][td]

120​

[/td][td="bgcolor:#E5E5E5"]

86%​

[/td][td]F2: =(B2 - E2) / ((D2 - A2) * C2)[/td][/tr]
[/table]

 

[orlandomedic]

Thank you very much!!I am going to try this right away!

 

[shg]

Y'er welcome.