More Excel help please

unrecordings

The other thing of course, unless you addressed this in post #9 is to try to get on double repeats for each med then build in a months padding on your repeats to allow for oversights or delays. The doc should allow this on the basis of mobility or complicated circumstances

Gers

Timpu wrote: »

Your basic logic seems sound but does need to be run through with dummy data to catch any slip ups. Don't forget weekends, public holidays, any holidays you have booked too, delays at the surgery/pharmacy end. All will need a time buffer.

Most pharmacies offer to take on repeat prescriptions. I have tried this with a few different pharmacy. I found the chain high street ones much less reliable than the local independent one. I currently use an online pharmacy who support the prescription requests and get meds to you on time. It's the one that advertises a lot. Go and chat to your pharmacist, see if they'll help.

Thanks, I've been tweaking and testing and think I've cracked it!

My DM uses an independent pharmacy one which isn't linked to her surgery or delivers. I've asked them about dosettes but they have their full quota.

The surgery posts out scripts to them as I leave SAEs on a regular basis.

unrecordings wrote: »

The other thing of course, unless you addressed this in post #9 is to try to get on double repeats for each med then build in a months padding on your repeats to allow for oversights or delays. The doc should allow this on the basis of mobility or complicated circumstances

Tried that too.. couldn't even get some a week early! Everything is online with set amounts.

Still tweaking here.

grumbler

Gers wrote: »

Hi again

I'm trying to construct a spreadsheet which will ensure I can order my elderly DM's medicines on time.

They all have different dates so I need help to order the next batches on time and not annoy the surgery by asking them to do a script urgently.

My own amateur efforts have tried this where A2 is the date of the previous script (18/01/20) and 112 is the number of tabs dispensed.

=SUM(A2+112)

That seems to work as it gave me a date of 09/05/20 in B2.Is this simple method enough to be rigourous?

I also need a column with a date about 10 days before the 09/05/20 (for instance) date so I can order a new script.

I assume it would be another simple case of the first answer B2) minus ten?

Thanks

Gers wrote: »

My simple method is pants!

I haven't taken into account the dosage. Back to my simple drawing board - any help appreciatd.

A2 - date
B2 - amount
C2 - daily dosage

Next date for ordering =A2+B2/C2-10

It would be nice to use conditional formatting so that the cell changes the colour as the current date gets closer the the calculated date.

that

https://imgur.com/a/URz8yHn

Gers

grumbler wrote: »

A2 - date
B2 - amount
C2 - daily dosage

Next date for ordering =A2+B2/C2-10

It would be nice to use conditional formatting so that the cell changes the colour as the current date gets closer the the calculated date.

that wrote: »

https://imgur.com/a/URz8yHn

Thanks for these two examples, I really appreciate it.

I will experiment with them later today.

unforeseen

that wrote: »

https://imgur.com/a/URz8yHn

Don't you need daily dose in there to calculate when they run out?

The end date will be (total tabs/daily dose) + start date

that

Personally would put it into my phone calendar, however on the spreadsheet would modify 'Total Tabs' (B4 etc) to 'No Daily Doses' and change the formula from B2*B3 to B2*B3/2/4 where you take two tables four times a day

Gers

I've been tinkering and tweaking my spreadsheet. Moved away from a worksheet for each med to follow the formatting example from THAT - thanks.

There'll be the names of the meds above each batch of columns.



Think I'm happy with it so :T to all those who helped with a solution.