I updated the reconstitution and dosing calculator I made so that it can also track your personal freezer stash of up to 35 items. I also increased the number of custom products you can use from 1 to 25.
You can easily define a custom product on the DOSES tab by entering its name and up to 6 typical doses.
The new FREEZER tab now lets you choose a different product for each row, drawing from the standards I put in plus all of your custom products. There are cells to add notes like a link to the test report. Most importantly, you may enter the actual weight of the product from the test report plus the actual amount of bac water used. This gives you a customized dosing report for a specific vial -- or kit, if you reconstitute them all the same way.
The spreadsheet comes with a couple of samples to give you an idea of how to use it.
I chose not to add inventory tracking and pricing information, as the spreadsheet is already very wide. I'm open to feedback, though.
Check it out here. Note that you will need to do File>Make a Copy to get your own editable version into your personal Google account, where no one else can see it.
https://docs.google.com/spreadsheets/d/1wCjjVoozucZX7c4f0feLvKbul1eJSs90sMw2ahCrZNg/edit?usp=sharing
You can easily define a custom product on the DOSES tab by entering its name and up to 6 typical doses.
The new FREEZER tab now lets you choose a different product for each row, drawing from the standards I put in plus all of your custom products. There are cells to add notes like a link to the test report. Most importantly, you may enter the actual weight of the product from the test report plus the actual amount of bac water used. This gives you a customized dosing report for a specific vial -- or kit, if you reconstitute them all the same way.
The spreadsheet comes with a couple of samples to give you an idea of how to use it.
I chose not to add inventory tracking and pricing information, as the spreadsheet is already very wide. I'm open to feedback, though.
Check it out here. Note that you will need to do File>Make a Copy to get your own editable version into your personal Google account, where no one else can see it.
https://docs.google.com/spreadsheets/d/1wCjjVoozucZX7c4f0feLvKbul1eJSs90sMw2ahCrZNg/edit?usp=sharing
