Proportion Days Covered (PDC) formula on excel

This forum made possible through the generous support of SDN members, donors, and sponsors. Thank you.

ice712

Full Member
10+ Year Member
Joined
May 24, 2013
Messages
121
Reaction score
8
Does anyone know the formula on excel to calculate PDC? I am doing a project, in which I need to calculate the PDC for all the chronic medications the patient is on; so it will be involving many drugs/patient. Is there such formula to use on excel sheet? I don't have any basic knowledge to use stastisc tools, so that wouldn't be a possible way.

I searched the web and couldn't find anything....

Thanks very much in advance!!!

Members don't see this ad.
 
Does anyone know the formula on excel to calculate PDC? I am doing a project, in which I need to calculate the PDC for all the chronic medications the patient is on; so it will be involving many drugs/patient. Is there such formula to use on excel sheet? I don't have any basic knowledge to use stastisc tools, so that wouldn't be a possible way.

I searched the web and couldn't find anything....

Thanks very much in advance!!!
What format is your data in?
 
What format is your data in?
I am sorry, I don't really understand your question. But the study was just started so I haven't started inputting the fill dates yet. I don't know if there is such formual to calcualte PDC on excel.
 
Members don't see this ad :)
I am sorry, I don't really understand your question. But the study was just started so I haven't started inputting the fill dates yet. I don't know if there is such formual to calcualte PDC on excel.
If you're going to manually enter all the dates and day supplies, you can use something like this

I made one guess, though. It assumes that the days after the final fill are covered for the duration of that supply. I can change it to calculate disregarding the final fill if that's how Medicare does it. Does anyone know which way they do it?
 
If you're going to manually enter all the dates and day supplies, you can use something like this

I made one guess, though. It assumes that the days after the final fill are covered for the duration of that supply. I can change it to calculate disregarding the final fill if that's how Medicare does it. Does anyone know which way they do it?


Thank you so much for your sample. I was thinking sometime like that too but it involves more than 100 participants, it would be unrealistic to do this more than 100 times.
 
Thank you so much for your sample. I was thinking sometime like that too but it involves more than 100 participants, it would be unrealistic to do this more than 100 times.
That's why I asked what format your data was in. If you're manually entering it, this is the only way. If you're using data that is already formatted, it can be more efficient.

Also, you need to do this for each drug, not each patient. So, for 100 patients, it would probably be 300-600 of these.
 
That's why I asked what format your data was in. If you're manually entering it, this is the only way. If you're using data that is already formatted, it can be more efficient.

Also, you need to do this for each drug, not each patient. So, for 100 patients, it would probably be 300-600 of these.

Now I get what you were saying... I better consult my preceptor then; it would be over 1000 of these :scared:
 
If you're going to manually enter all the dates and day supplies, you can use something like this

I made one guess, though. It assumes that the days after the final fill are covered for the duration of that supply. I can change it to calculate disregarding the final fill if that's how Medicare does it. Does anyone know which way they do it?

Hey, do you have the formula's you put into excel for it to calculate the days late and days covered? (I know this was posted a few years ago, so I understand if you no longer have the math/formula for excel)
 
Hey, do you have the formula's you put into excel for it to calculate the days late and days covered? (I know this was posted a few years ago, so I understand if you no longer have the math/formula for excel)
I had tried to post a link to the google spreadsheet so people could see the formulas and the forum forces it to be embedded. I attached it as an excel file here. It only goes to 30 fills, since people aren't likely to need more than 12 and going to very high numbers makes excel angry. But it could be changed to a higher row count if need be. Just fill in the fill date and duration, and don't skip any lines.
 

Attachments

Top