Bolverks mash bill calculator

[Bolverk]

Howdy all,

I'm sharing my mash bill calculator.
(Keep in mind, this is based on average PPG and DPs, so if you know your corn is a little more or less change it as you see fit.)

Enter the size of the ferment you want to do (this includes the grain so if you intend to lauter make sure you add 30% to your ferment size.)
The last 2 of the SG you want
The percentage of each grain

it will figure the weight needed and the DP of your bill

You can change the needed DP. I keep it at 30, if you want a more complete mash, enter 35 or even 40.

Please let me know if you have any questions.

[Yummyrum]

Looks cool Bolverk ,although I've never done mixed grains before .
Any chance of a Metric version ....pprrrease

[Bolverk]

You got it man, I'll do it in the morning

[Bradster68]

Calculator won't open for me.
But other one does. I got a new pixel 8 android phone. Does it require a PC to open

[Bolverk]

Calculator won't open for me.
But other one does. I got a new pixel 8 android phone. Does it require a PC to open

It's an excel doc, guess it depends on your phone?

[Bradster68]

Calculator won't open for me.
But other one does. I got a new pixel 8 android phone. Does it require a PC to open

It's an excel doc, guess it depends on your phone?

[Bolverk]

Looks cool Bolverk ,although I've never done mixed grains before .
Any chance of a Metric version ....pprrrease

Updated original upload, it has 2 tabs Imperial and Metric

[scubatech]

Awesome! I was just working on one of these. Use YLAY almost exclusively, so I was building something with PPG instead of using DP.

[Bolverk]

Awesome! I was just working on one of these. Use YLAY almost exclusively, so I was building something with PPG instead of using DP.

Nice! You can pretty much ignore the DP side then

[AlZilla]

Very generous. Thanks!

[Yummyrum]

Bolverk thanks but I only seem to see a metric version now ( but with DP in lb )
Is there a way to switch between the two in your sheet or am I just having a Yummy moment

[bilgriss]

There are two worksheets in the spreadsheet you can choose between, imperial or metric. Bottom left.

[Yummyrum]

There are two worksheets in the spreadsheet you can choose between, imperial or metric. Bottom left.

Doh
Thanks bilgriss
Yes there are

[Bolverk]

Bolverk thanks but I only seem to see a metric version now ( but with DP in lb )
Is there a way to switch between the two in your sheet or am I just having a Yummy moment

Sorry I missed that header, all the calcs are metric, you can update that to DP per Kg

[Bolverk]

Removed the doc because it had my personal info on it, I'll reload the doc when I figure out how to remove it.