ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   alert for medications (https://www.excelbanter.com/excel-discussion-misc-queries/187752-alert-medications.html)

Griff

alert for medications
 
My wife just got out of the hospital and she has several meds during the day
and night. Each medication has different frequencies; some for 4 hours, 6
hours, 12 hours and 24 hours. I've created a spreadsheet that has the 'time
taken' and excel figures out the 'next dose' time dependent on each med.
These meds control pain and she is fine if I make sure that they are on time,
but if they are late it's not good.
What I would like is to have the program alarm somehow that a med is due.
Is that possible?

Bob I

alert for medications
 
Set them up as appointments in Outlook Calendar?

Griff wrote:

My wife just got out of the hospital and she has several meds during the day
and night. Each medication has different frequencies; some for 4 hours, 6
hours, 12 hours and 24 hours. I've created a spreadsheet that has the 'time
taken' and excel figures out the 'next dose' time dependent on each med.
These meds control pain and she is fine if I make sure that they are on time,
but if they are late it's not good.
What I would like is to have the program alarm somehow that a med is due.
Is that possible?



Griff

alert for medications
 
Sounds like a good solution. I've been searching in the help files for how
to set the 'next dose' column as an appointment in Outlook calendar but
haven't found anything. I would think that is done in Excel,,,,right?

"Bob I" wrote:

Set them up as appointments in Outlook Calendar?

Griff wrote:

My wife just got out of the hospital and she has several meds during the day
and night. Each medication has different frequencies; some for 4 hours, 6
hours, 12 hours and 24 hours. I've created a spreadsheet that has the 'time
taken' and excel figures out the 'next dose' time dependent on each med.
These meds control pain and she is fine if I make sure that they are on time,
but if they are late it's not good.
What I would like is to have the program alarm somehow that a med is due.
Is that possible?




Bob I

alert for medications
 
make each pill time in the day a daily recurrence. The 4AM green pill,
the 8AM green pill, the 12PM green pill, the 6AM red pill, the 12PM red
pill, the 6PM red pill,

Griff wrote:

Sounds like a good solution. I've been searching in the help files for how
to set the 'next dose' column as an appointment in Outlook calendar but
haven't found anything. I would think that is done in Excel,,,,right?

"Bob I" wrote:


Set them up as appointments in Outlook Calendar?

Griff wrote:


My wife just got out of the hospital and she has several meds during the day
and night. Each medication has different frequencies; some for 4 hours, 6
hours, 12 hours and 24 hours. I've created a spreadsheet that has the 'time
taken' and excel figures out the 'next dose' time dependent on each med.
These meds control pain and she is fine if I make sure that they are on time,
but if they are late it's not good.
What I would like is to have the program alarm somehow that a med is due.
Is that possible?






All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com