Page 1 of 1

Recipe Calculator

PostPosted: Wed Jul 27, 2016 1:37 pm
by Horn_Bee
Good afternoon everyone,

I wasn’t sure where to post this, so mods please feel free to move to the correct place or delete if this has been covered before/isn't helpful…

While looking through the recipe sections I noticed that there isn’t a standard wash size being used across the board, which is completely understandable but means that the recipe often needs to be re-calculated to suit the individual’s personal equipment (fermenter size, boiler size, etc.). Going from this I started to develop a calculator that can automatically determine the volume of material needed depending on the size of the batch you wish to make. I threw in a few of the recipes that I am interested in, as well as a “blank” page as well that allows any recipe to be added in and adjusted as needed.

The calculator can be downloaded here: https://drive.google.com/file/d/0B64deEV718hLTnpwdFFXbjRHcE0/view?usp=sharing

To determine the new measurements for the pre-filled recipes all you need to do is enter the size of the wash you want to make (highlighted in green), and the adjusted measurements will be displayed (highlighted in blue). For the blank recipe you just need to enter the ingredients, the original volumes, the size of the original wash and the size of the wash you wish to make (all highlighted in green) and the adjusted measurements will automatically be calculated and displayed (highlighted in blue).

I figured that I’d throw it up here for anyone who might be interested in using it. Please feel free to modify it and improve it as you wish! :handgestures-thumbupleft:

Mick

Re: Recipe Calculator

PostPosted: Wed Jul 27, 2016 1:42 pm
by Zak Griffin
I'll have a play with this when I get home, sounds handy though! :handgestures-thumbupleft:

Re: Recipe Calculator

PostPosted: Wed Jul 27, 2016 1:56 pm
by coffe addict
Well that's just awesome will save me having to do math

Re: Recipe Calculator

PostPosted: Wed Jul 27, 2016 2:45 pm
by Horn_Bee
**UPDATE**

The calculator contains the following pre-loaded recipes:

• TPW
• Kale Neutral
• WBAB
• CFW
• NutriGran Whiskey
• MacRum
• Hook Rum
• MacWhisky
• WPSOW
• Blank (for any other recipes)

Hope you find it useful :handgestures-thumbupleft:

Mick

Re: Recipe Calculator

PostPosted: Wed Jul 27, 2016 2:55 pm
by Doubleuj
Nice job, just to point out to people you don't need to increase the amount of yeast, especially if you rehydrate.

Re: Recipe Calculator

PostPosted: Wed Jul 27, 2016 3:18 pm
by Nino
Doubleuj wrote:Nice job, just to point out to people you don't need to increase the amount of yeast, especially if you rehydrate.


:text-+1: Thankyou very much it will be very useful :D

Re: Recipe Calculator

PostPosted: Wed Jul 27, 2016 4:03 pm
by maddogpearse
Been here for 10 seconds and already making some valuable contributions. Cheers Horn bee. I'm sure a lot will find that very helpful! :clap:

Re: Recipe Calculator

PostPosted: Wed Jul 27, 2016 5:14 pm
by prawnz
Hmmm , doesnt seem to work for me .

Do I need to have MS Office on the computer ?

Re: Recipe Calculator

PostPosted: Wed Jul 27, 2016 5:58 pm
by Horn_Bee
prawnz wrote:Hmmm , doesnt seem to work for me .

Do I need to have MS Office on the computer ?


G'day prawnz,

I made it up on Excel, but when you click on the link you should be able to either download it to your PC and open via MS Office or open it directly from the link through Google Sheets. :handgestures-thumbupleft:

Image

Re: Recipe Calculator

PostPosted: Wed Jul 27, 2016 6:02 pm
by Horn_Bee
maddogpearse wrote:Been here for 10 seconds and already making some valuable contributions. Cheers Horn bee. I'm sure a lot will find that very helpful! :clap:


Cheers maddog,

Hopefully it comes in handy ;-)

Mick

Re: Recipe Calculator

PostPosted: Wed Jul 27, 2016 6:41 pm
by rumdidlydum
Great work mate. :handgestures-thumbupleft:

Those who would like to use it should bookmark the page for easy and quick reference :D

Re: Recipe Calculator

PostPosted: Thu Jul 28, 2016 5:05 pm
by TasSpirits
Cheers Mate :clap:

Re: Recipe Calculator

PostPosted: Fri Jul 29, 2016 1:08 pm
by Fishws
Horn_Bee that's fantastic, many thanks,

Warren