How to calculate dosages and dilutions? Spreadsheets and calculators

[ThroughTheForceField]

You're welcome. I made that keeping in mind that people would want to go down in no lesser than multiples of 0.01mg. So, your goal might be to taper down from 25mg to 23.5 mg or 22.21mg, but not 22.237mg. If you wanted something like 22.237mg, the previous code would still work but the precise values won't be that precise. I can't see why someone would want to go down to something like 22.237mg anyway (it's a different thing if a volume you take gives that, but not the goal of tapering down).

 

In any case, I should have raised an Exception keeping that in mind, so that a person can't use more than 2 digits after the decimal place in the drug weight they require. It'll just make the code longer and longer if I start putting every triviality in. If anyone wants that though, here it is:

def voltotake(med_wt,med_needed,max_vol=120,approx=0.008):
    if len(str(med_needed).split('.'))>1:
        if len(str(med_needed).split('.')[1])>2:
            raise Exception("Please don't enter more than 2 digits after the decimal in the drug weight you require.")
    print('Precise Values:')
    for vol_take in range(1,max_vol+1):
        conc, med_rmv = med_wt/vol_take, med_wt - med_needed
        vol_rmv = med_rmv/conc
        if abs(round(vol_rmv,1) - round(vol_rmv,3))==0:
            med_act_wt = med_wt - (round(vol_rmv,1)*conc)
            print('volume_to_take:', vol_take, 'volume_to_remove:', round(vol_rmv,1), 'consumption_weight:', med_act_wt)
    print('\nApproximate Values:')
    for vol_take in range(1,max_vol+1):
        conc, med_rmv = med_wt/vol_take, med_wt - med_needed
        vol_rmv = med_rmv/conc
        if 0.0001<=abs(round(vol_rmv,1)-round(vol_rmv,3))<=approx:
            med_act_wt = med_wt - round(vol_rmv,1)*conc
            print('volume_to_take:', vol_take, 'volume_to_remove:', round(vol_rmv,1), 'actual_consumption_weight:', med_act_wt)

voltotake(300,293)