Page 1 of 1

Wash Calculator

PostPosted: Sun May 12, 2013 7:46 am
by Dominator
Ok, so I have made a wash calculator for the TPW, McRum and BWKO. I am only just starting out so I am not sure about how to adjust ingredients. If you could give me any advice on any adjustments then I can get them loaded to the calculators page.

Recipe Caculator by Dominator

Re: Wash Calculator

PostPosted: Sun May 12, 2013 12:18 pm
by Distillnation
Nice to see people helping out with things like this!

Dominator wrote:I am only just starting out so I am not sure about how to adjust ingredients.


What do you mean by adjust ingredients?

Do you mean as in how to properly scale the ingredients for the washes?

If so, you work it out like this:

Scale = Desired_Wash_Volume / Original_Wash_Volume

Once you have your scale, you can start working out the ingredients:

Eg. TPW:

Scale = 20(L) / 25(L)
Scale = 0.8

Sugar = 5(kg) * 0.8
Sugar = 4

Etc, etc.

That is how you would make the spreadsheet if you didn't want to rely on constant values ie(D57*0.2), etc.

If that isn't what you meant, just say so and I'll try and help out with what you need :handgestures-thumbupleft:

Wash Calculator

PostPosted: Sun May 12, 2013 1:24 pm
by Dominator
Distillnation wrote:
What do you mean by adjust ingredients?

Do you mean as in how to properly scale the ingredients for the washes?

If so, you work it out like this:

Scale = Desired_Wash_Volume / Original_Wash_Volume

Once you have your scale, you can start working out the ingredients:

Eg. TPW:

Scale = 20(L) / 25(L)
Scale = 0.8

Sugar = 5(kg) * 0.8
Sugar = 4

Etc, etc.

That is how you would make the spreadsheet if you didn't want to rely on constant values ie(D57*0.2), etc.

If that isn't what you meant, just say so and I'll try and help out with what you need :handgestures-thumbupleft:


Yeah that's exactly how I have done it. I am just not sure if the scaling is linear for all the ingredients though. I have done it so if you double the wash volume it will simply double the sugar, grain, yeast etc.

Re: Wash Calculator

PostPosted: Sun May 12, 2013 1:50 pm
by Distillnation
If you use the formula for scaling, I wouldn't worry too much about it. I've put in a few values and it all works out fine (mathematically), and let's face it, in this hobby people aren't always following recipes 100%.

As long as it produces consistent results, that's all we will need.

It will definitely be handy for people who want to make these washes but don't want to use it at the original amounts.

Re: Wash Calculator

PostPosted: Sun May 12, 2013 2:05 pm
by Dominator
Distillnation wrote:It will definitely be handy for people who want to make these washes but don't want to use it at the original amounts.


Yeah that was the idea. Just trying to give a bit back to all the help I have already got from the forum. :handgestures-thumbupleft: :D

Re: Wash Calculator

PostPosted: Sun May 12, 2013 8:36 pm
by invisigoth
erm, good thread... but is tried and true really the place for this? :twisted: :whistle:

Re: Wash Calculator

PostPosted: Sun May 12, 2013 9:19 pm
by invisigoth
invisigoth wrote:erm, good thread... but is tried and true really the place for this? :twisted: :whistle:


i must have misread the section i was in. sorry :angry-banghead:

Re: Wash Calculator

PostPosted: Sun May 12, 2013 9:32 pm
by MacStill
nup! I moved it because you complained :teasing-neener:

Re: Wash Calculator

PostPosted: Thu May 15, 2014 11:08 am
by Urrazeb
I know it's an old thread but I am getting 404 not found for this.

Is there another excel spreadsheet for distilling/wash calculator somewhere? Could someone please post a link :handgestures-thumbupleft:

Wanting to keep track of what goes into a wash, price of unit and ultimatley a wash as a whole the method I used and also a wash converter for scaling down/up.

Be a great help if someone has already done this :pray:

Re: Wash Calculator

PostPosted: Thu Jan 25, 2018 4:40 pm
by A&O
I know it’s been a while, does anyone have a copy of Dominators spreadsheet? Or maybe something similar?

The link to the spreadsheet is broken or can’t find the file

Thanks

Re: Wash Calculator

PostPosted: Fri Jan 26, 2018 3:13 pm
by Distillnation
Here's a copy of the file I have. It's been that long that I don't remember if there were any other additions added to it, but figured it can't hurt to upload it again.

Re: Wash Calculator

PostPosted: Fri Jan 26, 2018 8:42 pm
by A&O