I wanted a different way to view vial options and calculate doses, so I made a spreadsheet. Some of you may be interested in using it too.
While the spreadsheet is large, it only asks you to think about TWO NUMBERS... The amount of product in a vial (in mg) and the amount of bac used (in mL). It calculates everything else for you based on common dosing protocols. If you are doing your own thing, you can customize the doses too.
Please consider this a preview, and if you take a look at the spreadsheet... please help me check my math, and let me know if there are better default dose values to choose.
https://docs.google.com/spreadsheets/d/1wCjjVoozucZX7c4f0feLvKbul1eJSs90sMw2ahCrZNg/edit?usp=sharing
It works like this...
The left side has a list of vials with amounts (in mg) that will look familiar to anyone who has looked at a peppy price list.
The left side also allows you to fill in some amount of bacteriostatic water that you'd use to reconstitute that vial. 2 mL is prefilled.
You then select a product from the drop-down menu below the table. The spreadsheet looks up the typical doses for that product. For example, for sema, it fetches 0.25 mg, 0.5 mg, 1.0 mg, and 2.4 mg as the four dose tiers. Currently, only reta, sema, and tirz are supported. However, you can edit the values and I provided a Custom product so you can put in your own dosing tiers for anything -- up to 6 tiers, in fact.
Then, for each vial, it calculates how much you'd need to draw to get that dose. It shows those values in mL and in units. It will also calculate how many doses per vial, and vials that don't make a single dose or any doses that are too big or small for normal insulin syringes get marked in red.
Obviously, not all of the values are realistic. No one is buying sema in 0.25 mg vials, nor 1000 mg vials. So... Just ignore those rows. If you only care about a few rows like 5-10-20 mg, select the ones you don't care about, right-click, and Hide them. (You can also edit the values in Column A freely if you really want to.)
Lastly, the orange shading shows you if that dose needs a 30, 50, or 100 unit syringe.
Example: Say we are just starting sema at the first tier, 0.25 mg. We have a 2 mg vial, to which we add 2 mL BAC. Row 7 shows that we need 0.25 mL or 25 units, that it should fit in a 30U (or greater) syringe, and that our vial is good for 8 doses. If we had some nonstandard vial, we would just type the amount (in mg) into cell A2, put the BAC (in mL) into B2, and get our report that way.
The tab where dosing tiers is defined looks like this. You can customize the values if you wish.
That's it!
While the spreadsheet is large, it only asks you to think about TWO NUMBERS... The amount of product in a vial (in mg) and the amount of bac used (in mL). It calculates everything else for you based on common dosing protocols. If you are doing your own thing, you can customize the doses too.
Please consider this a preview, and if you take a look at the spreadsheet... please help me check my math, and let me know if there are better default dose values to choose.
https://docs.google.com/spreadsheets/d/1wCjjVoozucZX7c4f0feLvKbul1eJSs90sMw2ahCrZNg/edit?usp=sharing
It works like this...
The left side has a list of vials with amounts (in mg) that will look familiar to anyone who has looked at a peppy price list.
The left side also allows you to fill in some amount of bacteriostatic water that you'd use to reconstitute that vial. 2 mL is prefilled.
You then select a product from the drop-down menu below the table. The spreadsheet looks up the typical doses for that product. For example, for sema, it fetches 0.25 mg, 0.5 mg, 1.0 mg, and 2.4 mg as the four dose tiers. Currently, only reta, sema, and tirz are supported. However, you can edit the values and I provided a Custom product so you can put in your own dosing tiers for anything -- up to 6 tiers, in fact.
Then, for each vial, it calculates how much you'd need to draw to get that dose. It shows those values in mL and in units. It will also calculate how many doses per vial, and vials that don't make a single dose or any doses that are too big or small for normal insulin syringes get marked in red.
Obviously, not all of the values are realistic. No one is buying sema in 0.25 mg vials, nor 1000 mg vials. So... Just ignore those rows. If you only care about a few rows like 5-10-20 mg, select the ones you don't care about, right-click, and Hide them. (You can also edit the values in Column A freely if you really want to.)
Lastly, the orange shading shows you if that dose needs a 30, 50, or 100 unit syringe.
Example: Say we are just starting sema at the first tier, 0.25 mg. We have a 2 mg vial, to which we add 2 mL BAC. Row 7 shows that we need 0.25 mL or 25 units, that it should fit in a 30U (or greater) syringe, and that our vial is good for 8 doses. If we had some nonstandard vial, we would just type the amount (in mg) into cell A2, put the BAC (in mL) into B2, and get our report that way.
The tab where dosing tiers is defined looks like this. You can customize the values if you wish.
That's it!
(Just kidding... We need it though)
