Looking for help on improving my excel sheet

[mooner09]

Hi all

Look for some help creating a code that ill allow me to eliminate as much human error as possible from my spreadsheet that creates reducing dose charts for patients within the NHS

I made the table to speed up this process (we used to handwrite them) however there is still some human error that can cause delays

Example.png

This is what the current form look like, they are formatted to be printed out and will calculate the amount of tablets we will require for the said patients specified dosage scheme what i'm looking for help is a way for the user to fill in the cells to the right and the form populate in the way that's displayed within the form

apologies if ive not explain this very well essentially i need them to put in the initial amount of days they will be taking a set dose for then how often they will be reducing down to 0 tablets

Any help greatly appreciated

many thanks

Tom

[etaf]

quite a few things could be done

why not post a sample sheet rather than an image - will make it easier for people to help
do you need to have tablets in each cell - rather than just a number ?

do you have the tablets used and size anywhere - so that entering 25mg as starting dose - can work out thats 5 tabs
also by how much it reduces in each section s well as the number of days

How many tabs are in a box

[mooner09]

Hi thank you for the reply sorry ive taken till today to pick it up

Sorry i didnt realise i could post a copy of the worksheet, new to this forum. My works browsers are never updated and wont allow me to at the moment, ill find a work around.

It would be helpful to have "Tablets" in each cell only for clarity as most of the people who require these charts are eldarly.

I did have the calculation in the first cell of each form to work out the 25mg = 5 tablets.

The reductions are always usually by 5mg until stopping, howver the amount of days is where the variation is. For example lets say someone is taking 25mg but will need to stay on this dose for the next 17 days before reducing by one tablet every 7 days. some people are much simplier but there are some peoples doses which are alot more random than the bog standard reducing every 7 or 5 days.

there are 28 tablets in most boxes but ive worked out the caluations for these box sizes at the bottom of each chart.

Tom

[etaf]

Just make sure their is no names or personal information in the sheet , it is a public forum

[mooner09]

Hi, should be anything sensitive in the sheet, hopefully ive managed to attach it

Many Thanks

Tom

[etaf]

just as a first pass , just to make sure dont do to much wrong
i have added the formula - but shows the main dose and then just flags - 2nd, 3rd 4th
So by how much does the dose reduce ?

just one tablet - based on the Dose

so in my example of 100Mg
would that reduce to 95Mg

Then the next example I have an entry for dose reduction which reduces by that amount for each of the days

As i say this is just a draft and will need some error handling - if the reduction is only 1 or 2 or 3 times

i added the days just to see it changed correctly - ignore H & P

[etaf]

I have added bit of Error checking

Data Validation in the Reduction - so the days have to be greater than previous day
Data Validation the reduction has to be a whole tablet , based on dose per tablet
Conditional formatting for 0 or negative to go white and no tablets in cell shown
Conditional formatting on the dates to show the change in dosage
Leave the days reduction blank and it only calculates previous dates - Ie you can use 1 or 2 or 3 days reduction

[mooner09]

Thank you for your help on this,

This is exactly what I was looking for !!

the maximum amount of reductions would be 9 from our highest dose of 45mg that usually comes through the department, anything about this dose
is usually for patients who we don't supply charts for.

How difficult is it for me to add in a total of 9 reductions as a maximum ?

Many Thanks again

Tom

[etaf]

What version of Excel are you using ?
if 2003 - then no , a different approach will be needed as you cannot nest that many IFs