Jump to content
Altostrata

How to calculate dosages and dilutions? Spreadsheets and calculators

Recommended Posts

Altostrata

For spreadsheets and calculators, jump to these links:

 

Excel spreadsheet to calculate dose weights using a scale

Songbird's spreadsheet, explanation is below in this post with download links to Excel files.

You will need MS Excel or equivalent (e.g. Open Office) to use this.

 

Online spreadsheet for dose taper calculations

This is a Google doc from Brassmonkey -- There are different tabs at the bottom; one shows the "Brassmonkey Slide". 

Feel free to download this: Select File (in the spreadsheet, not in your browser), then download. 

 

nz11's THE WORKS spreadsheet

See .zip file for download at the bottom of the linked post.

 

Tapering calculator at ReversePsychiatry.org

This is an online calculator by DoctorMussyWasHere.

 

Simple Brassmonkey Slide Tapering Spreadsheet

Jozeff's tapering spreadsheet using the Brassmonkey Slide method - download link is in the top post.  

You will need MS Excel or equivalent (e.g. Open Office) to use this.

 

Micro Taper Off Calculator with built-in 2-week hold

An online calculator using the Brassmonkey Slide method.

 

Calculators to help you create your own taper plan

Online planners for antidepressant and benzo tapering.

 

03 07 18 Merged several topics about spreadsheets and calculators.

03 06 19 Moved calculator links to top and added additional links.


 

This link not working - I have googled but can't find it - if you do, please post the link - thanks.  CC



Here is an explanation of drug dilutions, for those who like to look at a handbook:

 

http://www.baxterhealthcare.co.uk/downloads/healthcare_professionals/therapies/pharmacy_services/ps_calc_guide.pdf

 

Also useful for converting liquid meeasurements http://www.onlineconversion.com

 

Thanks to our member Angel7366, who supplied these tips.

 

 

Edited by ChessieCat
updated link

Share this post


Link to post
Share on other sites
Songbird

Admin note: Also see Using a digital scale to measure doses, which explains more about the scale itself and how to measure small amounts on it.

 

Calculate dose weights using a scale - Excel spreadsheet

 

Dose_weights_SA.xlsx

 

Dose_weights_SA.xls

 

If you are tapering using a scale, you will need to convert each dose to a weight so that you know what your scale should be displaying for the dose you want. The instructions are actually inside the spreadsheet but here is a little more detail:

1. Enter the dose of one whole pill in the orange cell (e.g. if your pills are 20mg pills then type in 20, or if your pills are 10mg pills then type in 10). Press tab.

2. Enter the weight of one whole pill - after calibrating your scale, making sure it is in 'gram' mode, weigh one pill and type the weight in the turqoise cell (e.g. 0.336). Press tab. (Note: some people like to weigh several pills and take an average in case the weights of the pills vary).

3. Enter the percentage drops you want to do for your taper in the green cell (e.g for 10% type in 10, for 5% type in 5). Press tab.

4. Enter the starting dose for your taper in the yellow cell. (For some people this will be the same as the dose of one whole pill above, if you are currently taking one whole pill as your dose.) Press tab.

The spreadsheet will now calculate your doses and the corresponding weights for your taper. For whichever dose you are dropping to (in the yellow), your scale should say the number in turquoise next to it. i.e. that's what you are aiming for when you cut and weigh your pills.

The spreadsheet has been protected so that you can only type in the cells you need to enter data into. This is to prevent you messing it up by accidentally typing other places! I hope this makes some sense. Any questions, just ask.


 

 

Edited by Songbird
moved links to top

Share this post


Link to post
Share on other sites
Altostrata

Thanks so much, Songbird.

 

Please note you will need Microsoft Excel or some other program that can read Excel spreadsheets to use this tool.

Share this post


Link to post
Share on other sites
Songbird

If you don't have Microsoft Office, you can download Open Office which is similar to MS Office and can open MS Office files, but it is FREE.

Share this post


Link to post
Share on other sites
Songbird

I have included a second worksheet for those who are doing drops of so many mg rather than a percentage.  If you are doing, say, 0.5mg drops, you enter this is the green cell.  The only problem with this method is that with the same drop each time your percentage drop gets bigger and bigger, so you really need to reduce your drops as your dose gets lower.  The spreadsheet shows you what percentage each drop is so you can see when it will start to get too high.  When you want to change your drop you can create a copy of the worksheet, change the drop amount and enter your current dose as the starting dose.

Share this post


Link to post
Share on other sites
ladybug

Hi Songbird,

 

just wanted to say thank you for providing us the spreadsheet. I downloaded both of them and I think it would be really helpful for those thinking of tapering from their ADs. I know weighing your dose is better and I'm actually planning on buying a scale but when I've checked Amazon, all the Gemini scales look the same but different prices. I don't really know which one to pick, please advice me which one is the genuine scale,  thank you.

 

Cheers,

DePrssd5

 

I've used the Gemini-20 scale for years and I believe this is the one most scale users use. I recently ordered a new one after my old one started acting up, and it didn't work and I had to return it. I'm afraid their quality is not as good as it used to be. This was my 4th scale. They seem to last about a year or two and then stop working as well. I will probably order another one and hope it was just a one time thing. It's a good deal at only 22 US dollars and gets the job done.

Share this post


Link to post
Share on other sites
DePrssd5

Hi LB,

 

Thanks for the quick response, so what does it actually show or do when you said it wasn't working. Just in case it doesn't measure the weights accurately. But you are right, the price is quite affordable but I need to pay more coz I live in Australia. But it's ok as long as it does iit's job. Thanks you once again LB, good luck on the taper.

Share this post


Link to post
Share on other sites
ladybug

Hi LB,

 

Thanks for the quick response, so what does it actually show or do when you said it wasn't working. Just in case it doesn't measure the weights accurately. But you are right, the price is quite affordable but I need to pay more coz I live in Australia. But it's ok as long as it does iit's job. Thanks you once again LB, good luck on the taper.

 

When it's stops working as well, the weight readings bounce around frequently. I weigh the pill pieces with the calibration weight on the pan as this puts it in the middle of the weighing range which is supposed to help with accuracy. The calibration weights are usually 10g so I try to get it to read as close to 10g as possible. I will usually accept +/- .002g and then adjust my pill weights accordingly. But, when it starts reading much more than that, say 10.010g and frequent calibrations, new batteries, etc. don't help then I give up and order a new one. My very stability depends upon this scale so I need it to be accurate as possible. I hope this helps. And if you have any questions when you receive the scale, I'll be happy to help you!

Share this post


Link to post
Share on other sites
Jlynn

Is there a spreadsheet for tapering 10% using the liquid Paxil? I know there used to be one on PP and I can't find one online anywhere! If I was smarter with Excel I would create one but I am not :( 

Share this post


Link to post
Share on other sites
Songbird

I don't think you would need a special spreadsheet for that.  How many mg per ml is your liquid?  You could probably use the weight column as a ml column.

Share this post


Link to post
Share on other sites
Jlynn

It is 10 mg / 5 ml for the paxil liquid. So if I were to taper to say 16.2 mg how many ml would that be? I am so bad at math and my brain is swiss cheese at the moment!

Share this post


Link to post
Share on other sites
Songbird

It is 10 mg / 5 ml for the paxil liquid. So if I were to taper to say 16.2 mg how many ml would that be? I am so bad at math and my brain is swiss cheese at the moment!

 

You can use the weight column as a ml column.  So enter 10 in the gold cell, then enter 5 in the turquoise cell.  Are you currently taking 20mg?  So you would enter 20mg in the yellow column. 

 

Using the percentage drop from the green cell (e.g. 10%), your dose drops will be shown in the pale yellow cells.  You can then use your syringe to measure out the doses shown in the pale turquoise cells.

 

Try this and you'll see that to get a dose of 16.2mg you'll need 8.1ml liquid.

Share this post


Link to post
Share on other sites
pattypurple

Hi there. New to all of this. I'm embarrassed to say I have difficulty with math (due to ECT and hey, maybe also due to all these meds(?!)). Can someone tell me what is 10% of 5mg? Is that .5mg? Do you multiply by .10 and then subtract that from the total dose? 

 

Thank you for not laughing or screaming or sighing (or at least keeping it to yourself!)

[bows head in shame]

 

Edited by Altostrata
merged related topics

Share this post


Link to post
Share on other sites
dalsaan

Hi there. New to all of this. I'm embarrassed to say I have difficulty with math (due to ECT and hey, maybe also due to all these meds(?!)). Can someone tell me what is 10% of 5mg? Is that .5mg? Do you multiply by .10 and then subtract that from the total dose? 

Thank you for not laughing or screaming or sighing (or at least keeping it to yourself!)

[bows head in shame]

 

No need to bow your head in shame - that is the way to calculate your dose reductions.  Dose X .10 = amount to be deducted from current dose

Share this post


Link to post
Share on other sites
bluebalu86

Hi patty

 

This is what I could do. I will have my father help out with this when he comes home he's really good with math. I calculated these with an Excel spreadsheet. This is the dose minus 10% of the dose, starting from 5 mg. If you are using an Excel spreadsheet you should create two separate columns A and B. A is where you write the current dose, and for B you use the formula B1=(A1-(A1*10%)). Then you copy the formula all across the column and it calculates each new dose.

 

These are the numbers I came up with. May or may not be correct. 

 

5.00 4.50 4.05 3.65 3.29 2.96 2.66 2.39 2.15 1.94 1.75 1.58 1.42 1.28 1.15 1.04 0.94 0.85 0.77 0.69 0.62 0.56 0.50 0.45 0.41 0.37 0.33 0.30 0.27 0.24 0.22 0.20 0.18 0.16 0.14 0.13 0.12 0.11 0.10 0.09 0.08 0.07 0.06

Share this post


Link to post
Share on other sites
bluebalu86

You're most welcome. Make sure you double check everything. If X is the old dose and Y is the new dose, you do the math like this:

 

Y = X-(0.1 x X)

Share this post


Link to post
Share on other sites
Skyler

I just came across a math tool that will calculate the % of however many mgs. you want to cut.  Use the first box, and enter % you want to reduce in the first space, and the number of mgs. you are taking in the second, then hit calculate.  Just do the same with each successive dose, and it will give you the figures you need for your taper.

Share this post


Link to post
Share on other sites
BuddhaMama

I understand how to calculate 5% of my original dose (15mg - .75mg=14.25mg), but what I don't understand is how to translate this to my 1ml syringe. If my suspension liquid contains 15mg per 1ml, how do I calculate 14.25mg in a 1ml syringe?

Share this post


Link to post
Share on other sites
nz11

okay after doing a search i found that remeron can be bought in 15mg per ml solution.

 

I was just surprised that you can dissolve 15 mg in just 1 ml but apparently you can.

 

okay in that case if you want 14.25 mg you need to take 0.95 ml.

 

You simply divide the desired mg dose by 15 and take that in mls.

 

nz11

note to myself:  2 dp is needed in my liquid spreadsheet calculator not one.

Share this post


Link to post
Share on other sites
ChessieCat

 

Hi there. New to all of this. I'm embarrassed to say I have difficulty with math (due to ECT and hey, maybe also due to all these meds(?!)). Can someone tell me what is 10% of 5mg? Is that .5mg? Do you multiply by .10 and then subtract that from the total dose? 

Thank you for not laughing or screaming or sighing (or at least keeping it to yourself!)

[bows head in shame]

 

No need to bow your head in shame - that is the way to calculate your dose reductions.  Dose X .10 = amount to be deducted from current dose

 

 

I find it easier to just multiply the dose by 0.90 for a 10% decrease or 0.95 for a 5% decrease.

 

Or you can use the above way and then double check by multiplying by my suggested method.

 

Explanation:  0.90 = 90% and 0.95 = 95% so you are calculating the amount of dose you need, not what you need to deduct.  Doing it this way means one less calculation therefore reducing the risk of error.

Share this post


Link to post
Share on other sites
Madeleine

Somebody posted a spreadsheet on the site that is a dose calculator.  Does anyone know where I can find it. I saw it but now don't know where it was.


Many thanks!

 

M.

 

Edited by Altostrata
deleted Mod Note

Share this post


Link to post
Share on other sites
ChessieCat

Here's what I have found:

 

Excel spreadsheet to calculate dose weights using a scale

 

Online spreadsheet for dose taper calculations

This is a Google doc -- There are different tabs at the bottom. Feel free to download this: Select File (in the spreadsheet not in your browser), then download. 

 

nz11's THE WORKS spreadsheet

Edited by Altostrata
updated links & added additional information

Share this post


Link to post
Share on other sites
Madeleine

Thank you!

Share this post


Link to post
Share on other sites
BuddhaMama

okay after doing a search i found that remeron can be bought in 15mg per ml solution.

 

I was just surprised that you can dissolve 15 mg in just 1 ml but apparently you can.

 

okay in that case if you want 14.25 mg you need to take 0.95 ml.

 

You simply divide the desired mg dose by 15 and take that in mls.

 

nz11

note to myself:  2 dp is needed in my liquid spreadsheet calculator not one.

 

I think the reason I'm having such a hard time with the syringe is because I want to do the BrassMonkey slide method of 2.5% decreases. My 1ml syringe only has 5 tick marks between each 10th of a ml. So, my first decrease of 2.5% would fall somewhere between the tick marks that lie between 1ml and .9ml, which makes me feel like it's a lot less accurate and therefore more likely to throw my body off. I'm super duper sensitive. Should I use a digital scale? all the searching I've done on SA regarding scale usage seems to only discuss tablets, powders and beads, not liquids. Help please!

Share this post


Link to post
Share on other sites
LexAnger

You can dilute the liquid 10 times by adding water into it, then the measure should be much more accurate.

Share this post


Link to post
Share on other sites
Faye

Thank you for posting this advice I've found it extremely helpful. X

Share this post


Link to post
Share on other sites
scallywag

Brilliant! Bravo! Thank you Dr. Mussy.

Share this post


Link to post
Share on other sites
Shep

Yes, thank you, Dr. Mussy. It works great on my laptop and I tried it on my cell phone and it works great there, as well. 

Share this post


Link to post
Share on other sites
nz11

Just spotted this

Great job Dr Mussy.

I really like the title too.

Share this post


Link to post
Share on other sites
LiaJ

Amazing. You are a wizard!! 😊 Thank you!

Share this post


Link to post
Share on other sites
DoctorMussyWasHere

Thanks!

I have plans for services (eg. graphs, calendars) which will support, but not affect the core calculator,

but things are a little hectic right now so it may take a few months.

Share this post


Link to post
Share on other sites
manymoretodays

Awesome.  Truly!!!  5 stars(with 5 being excellent!)

 

Important to note that 0,1 is the same as 0.1

 

Also for me, for just looking at in the morning.........it took a few, to realize that each successive decrease in dosage, is listed vertically, and numbered 1-22.  At first glance I wasn't sure what all the numbers meant.

 

Another Bravo, and yes, excellent title.  Well done.

Edited by manymoretodays

Share this post


Link to post
Share on other sites
DoctorMussyWasHere

Thanks manymoretodays,

 

I am taking note of suggestions, though I probably won't be able to implement most of them for a while..

 

Things are somewhat turbulent at the moment, and in the middle of it I'm tackling some technologies - namely Vue.js - which will make a wider range of services related to the calculator possible.

 

But your suggestion may be simple enough. That checkbox in Advanced Settings called "Style the output".. do you think perhaps it should look something like that all the time to make it clearer? Are others in agreement ie. did anyone else find it confusing at first?

 

About the 0,1 or 0.1 - what platform are you on: Mac, Windows or Linux (or mobile)?

I'm on a Mac, and MacOS tends to force the comma in input fields, though I believe recent versions of Windows does the same.

I think dot (point) rather than comma would be better, I agree.

it's proven trickier to achieve that one would expect, but I'll get there soon.

 

DM

 

 

Share this post


Link to post
Share on other sites
manymoretodays

Ha.  Loved the "Style the Output" made it clearer.  Much.  Windows desktop is what I used to view.......and an older version.

Edited by manymoretodays

Share this post


Link to post
Share on other sites

×
×
  • Create New...