Just found this Excel spreadsheet on the internet. May be of interest:
Here's where I am being VERY stupid and this comment is aimed at @cothermandistilling as I need his help.
I have done an amount of distilling using the lab still using seperate distillations for coriander, juniper, liqurice, cinnamon etc.
Okay so based on the Excel spreadsheet where start diluted alcohol was 50% and 1 litre, the end combined distilled product was at approx 81%. Final distilled product was at approx 550ml to 600ml.
The seperate botanicals were as per 100g/l, 10g/l and 1 g/l, this depending on the botanical.
Using a pippette I have done some mixes of the above and it tastes awsome.
But I now need to work backwards for the all in one combined dry botanical mix and get dry g/l portions and here is where I am being VERY VERY stupid and need some help.
Please can I get some practical examples based on above.
I use bottled spring water to dilute and I use volume method.
To work out correct volumes I made up an excel spreadsheet that accounts for collapse (or whatever you call it).
I should probably get a decent set of scales. Some of my food recipes are converted to grains as my powder scales are the only accurate ones I have =))
@jacksonbrown said: Anyone done up an excel spreadsheet to spit out recipes?
yep.. just gotta search ;-)
@richard said: Just received my new toy
Time to start building up the library.
Anyone done up an excel spreadsheet to spit out recipes?
This is high on my list of things to do.
If the samples are standardised then it should be pretty easy to convert the 'mixed by hand bottle of perfection' into a repeatable, single batch, production recipe.
A little donation to the group... An Excel Spreadsheet (XLSX) for your Gin Basket..
I would be happy to add a few common items if I missed something.. (No, I am not adding bacon)
set the batch size, set the desired grams per liter, and you are set.
The right two columns are if you made single botanical extractions to use, this is especially helpful when the concentration is .005 grams/liter and you are making 100ml to test...
Plot enough data points to use a curve generator to create a curve equation with an acceptable R squared value. Enter that equation into an Excel spreadsheet. Now you have a continuous function, so no interpolation is required.
Sometimes smart people piss me off when my eyes glaze over =))
Water flow? If I can hold my hand on the top half of the dephlem for 8 seconds that's fores, 6 seconds that's heads, 4 seconds is hearts. I have that in an Excel spreadsheet somewhere...
OK, this has bugged me long enough....
Here is an Excel spreadsheet I put together, it is on the low side, at 10x the cooling water as the distillate, maybe I made errors, maybe it is more inefficient than we thought... but it is a starting point..
preview:
I'll add it to the calcs discussion, but I can't add it to the online calculator page because obviously it's an Excel spreadsheet. If someone would have some time and knowledge to convert this into HTML/PHP/JS (in a rush only @DistilliTraK comes to mind?)?