kickert

07-05-2012, 11:12

In the FAQ area the bourbon proof calculator is now a dead link...any chance that will get fixed? It's a great tool and I use in on a regular basis! ;)

Bob had mentioned not having access to the bourbon proof calculator, so I thought I would upload a version I designed when I worked at the distillery.

It is just an excel file that has has every possible conversion you could want. It tells you how much water to add to a high proof spirit to bring it down to a specific proof. It tells you how much high proof spirit to add to a low proof spirit to bring it up to a certain amount (wanna raise WT80 to 101 by adding rare breed??). It even tells you how much of a high proof spirit you will need to reach a specific amount of a lower proof spirit. (You can turn 630ml of Weller Antique into 750ml of Weller Special Reserve with 120ml of water).

If you are super nerdy and work with bulk spirits and a hydrometer, it tells you how to gauge your starting proof and/or starting amount by the change in proof when adding water. Then, there are a few general conversions and some distillery specific calculations (wine gallons into proof gallons and finding volume based on weight of gns). There is also a simple sheet that allows you track historic changes (useful when trying to get a large batch down to a specific proof).

Thought it might be of use you all. You can find it here:

http://kickert.info/blog/wp-content/uploads/2012/07/Proofing-Calculator.xls

-bk

Bob had mentioned not having access to the bourbon proof calculator, so I thought I would upload a version I designed when I worked at the distillery.

It is just an excel file that has has every possible conversion you could want. It tells you how much water to add to a high proof spirit to bring it down to a specific proof. It tells you how much high proof spirit to add to a low proof spirit to bring it up to a certain amount (wanna raise WT80 to 101 by adding rare breed??). It even tells you how much of a high proof spirit you will need to reach a specific amount of a lower proof spirit. (You can turn 630ml of Weller Antique into 750ml of Weller Special Reserve with 120ml of water).

If you are super nerdy and work with bulk spirits and a hydrometer, it tells you how to gauge your starting proof and/or starting amount by the change in proof when adding water. Then, there are a few general conversions and some distillery specific calculations (wine gallons into proof gallons and finding volume based on weight of gns). There is also a simple sheet that allows you track historic changes (useful when trying to get a large batch down to a specific proof).

Thought it might be of use you all. You can find it here:

http://kickert.info/blog/wp-content/uploads/2012/07/Proofing-Calculator.xls

-bk