Gravity and Volume Simulator

How to get most out of brewing with your Braumeister? Help others and share your tips/best practices.

Gravity and Volume Simulator

Unread postby leosardinha » Thu May 22, 2014 9:08 pm

I have a 50L braumeister but I brew aiming 19L for bottling, or simply the volume of a post mix.

I was having some thoughts lately of how to brew different OG brews using the short malt pipe and the large one.

So I ended up with a calculator that looks like this, my effiency is not that good because I need to start treating my water, but as that increases I can just change the efficiency.

I wanted to get your impressions to see if I made any mistake or if this is a good aproach.

simulator.jpg


The values in it simulate the last brew I made, a Belgian Strong Golden Ale and they hit exactly what I got.

Simulator.xlsx
(11.08 KiB) Downloaded 248 times
Baleia Brewing Co.
User avatar
leosardinha
 
Posts: 122
Joined: Fri Jan 24, 2014 10:06 am
Location: Maidenhead, UK
Model: 20 litres (2015)

Re: Gravity and Volume Simulator

Unread postby paulg » Fri May 23, 2014 5:05 pm

thanks for that
it looks like basically you are adding the standard amount of water and then sparging to get total amount,this was what I expected.
I can see losses to grain absorbsion is taken into account in calculation of wort after mash ,I will give the spread sheet a try when the the BM arrives in a few weeks time

Paul
paulg
 
Posts: 197
Joined: Mon Apr 28, 2014 6:49 am
Location: corfu greece,formally suffolk/essex border england
Model: 50 litres

Re: Gravity and Volume Simulator

Unread postby leosardinha » Fri May 23, 2014 6:13 pm

Yes Paul, I tried to play with the mash in water volume a couple times, but I figured that the best was to have a standard ammount and then use the variable sparge volume to fine tune the final volume.

I have included losses related to grain absorption, boil off, trub/deadspace and loss with yeast slurry/dryhopping.

My Idea was to try to understand which malt pipe should I use to brew and what gravity I could reach based on the grain/adjunct used + boil time
Baleia Brewing Co.
User avatar
leosardinha
 
Posts: 122
Joined: Fri Jan 24, 2014 10:06 am
Location: Maidenhead, UK
Model: 20 litres (2015)

Re: Gravity and Volume Simulator

Unread postby niels » Wed Jun 11, 2014 6:25 pm

I'm planning a brew day before the end of the month. I'll try your tool and let you know how it goes.

- Niels
User avatar
niels
Site Admin
 
Posts: 1056
Joined: Mon Dec 02, 2013 8:08 pm
Location: Belgium
Model: 50 litres

Re: Gravity and Volume Simulator

Unread postby leosardinha » Wed Jun 11, 2014 9:03 pm

niels wrote:I'm planning a brew day before the end of the month. I'll try your tool and let you know how it goes.

- Niels


Nice, thank you!
Baleia Brewing Co.
User avatar
leosardinha
 
Posts: 122
Joined: Fri Jan 24, 2014 10:06 am
Location: Maidenhead, UK
Model: 20 litres (2015)

Re: Gravity and Volume Simulator

Unread postby stokie brewer » Mon Nov 17, 2014 9:55 am

Hi all,

Has anyone got any feedback from using this calculator? I have the BM50l and would like to do a short pipe brew to start.

Does anyone have a suitable profile for Beersmith 2?

Thanks

Jez
A fine beer may be judged with only one sip, but it's better to be thoroughly sure.
stokie brewer
 
Posts: 21
Joined: Tue Nov 04, 2014 8:53 am
Model: 50 litres

Re: Gravity and Volume Simulator

Unread postby Fritzkellerbrau » Mon Nov 17, 2014 4:24 pm

Hi Jez

Following are my water calcs used in my last two brews (20l short pipe in 50l BM):

Water: 36.6l
Grain absorption. -3.06 (5.35kg grain)
Boil off (90min). -6.00
Cooling loss -1.10
Trub. -4.00

Into fermenter = 22.5

On my last brew used 37l (7 liters for sparge) . Beersmith had 22l at 1.055OG and I ended with about 23.5l at 1.05OG. Had quite a bit less loss to trub.
User avatar
Fritzkellerbrau
 
Posts: 92
Joined: Tue Apr 15, 2014 4:58 pm
Location: Joburg South Africa
Model: 50 litres

Re: Gravity and Volume Simulator

Unread postby leosardinha » Mon Nov 17, 2014 5:05 pm

I am the author so my feedback is biased.

But I am abandoning beersmith as the "efficiency" calculation is really far, after 10+ brews I just can't find the right tune.

Now I am using this calculator + brew journal to formulate recipes.

The efficiency on this calculator is the brewhouse efficiency. OG/volume into fermenter
Baleia Brewing Co.
User avatar
leosardinha
 
Posts: 122
Joined: Fri Jan 24, 2014 10:06 am
Location: Maidenhead, UK
Model: 20 litres (2015)

Re: Gravity and Volume Simulator

Unread postby BrauTim » Wed Nov 19, 2014 11:41 am

leosardinha wrote:I am the author so my feedback is biased.

But I am abandoning beersmith as the "efficiency" calculation is really far, after 10+ brews I just can't find the right tune.

Now I am using this calculator + brew journal to formulate recipes.

The efficiency on this calculator is the brewhouse efficiency. OG/volume into fermenter


I am also finding it difficult to hit the sweet spot with Beersmith, so I'll give your spreadsheet a go on a brew this weekend and see how it goes.
To brew or not to brew, that would be a stupid question !
User avatar
BrauTim
 
Posts: 541
Joined: Sun Feb 02, 2014 1:03 pm
Location: England
Model: 50 litres

Re: Gravity and Volume Simulator

Unread postby BrauTim » Wed Nov 19, 2014 4:00 pm

@leosardinha

I've just had a play with the spreadsheet, seems to be really good, one item I'm not fully understanding is the amount of sugar points that are available from the grain, is this the amount after mash or after boil? It looks like it could be after boil as it takes the number of litres from the water calculator section and uses this in the gravity calculator, if this is the case any idea what the calculation should be to predict what the pre-boil points should be?
To brew or not to brew, that would be a stupid question !
User avatar
BrauTim
 
Posts: 541
Joined: Sun Feb 02, 2014 1:03 pm
Location: England
Model: 50 litres

Re: Gravity and Volume Simulator

Unread postby piet_v » Thu Nov 20, 2014 9:42 am

BrauTim wrote:It looks like it could be after boil

Correct
BrauTim wrote:any idea what the calculation should be to predict what the pre-boil points should be

after boil -> 20 L
after boil -> 50 pts
Before boil -> 23 L

then 20 x 50 = 1000 = 23 x 43,48 (no sugar is lost during boil)

Rocket science eh :lol:
User avatar
piet_v
 
Posts: 70
Joined: Mon Jan 20, 2014 8:42 pm
Location: Belgium
Model: 20 litres

Re: Gravity and Volume Simulator

Unread postby BrauTim » Thu Nov 20, 2014 11:40 am

piet_v wrote:
BrauTim wrote:It looks like it could be after boil

Correct
BrauTim wrote:any idea what the calculation should be to predict what the pre-boil points should be

after boil -> 20 L
after boil -> 50 pts
Before boil -> 23 L

then 20 x 50 = 1000 = 23 x 43,48 (no sugar is lost during boil)

Rocket science eh :lol:


Thanks, I'm good at rocket science just not at maths :D
To brew or not to brew, that would be a stupid question !
User avatar
BrauTim
 
Posts: 541
Joined: Sun Feb 02, 2014 1:03 pm
Location: England
Model: 50 litres

Re: Gravity and Volume Simulator

Unread postby leosardinha » Mon Nov 24, 2014 3:39 pm

@BrauTim, thanks for the feedback! nice to know that it was a good effort hehe

and thanks to piet_v for solving the questions before me haha
Baleia Brewing Co.
User avatar
leosardinha
 
Posts: 122
Joined: Fri Jan 24, 2014 10:06 am
Location: Maidenhead, UK
Model: 20 litres (2015)

Re: Gravity and Volume Simulator

Unread postby BrauTim » Mon Nov 24, 2014 4:04 pm

leosardinha wrote:@BrauTim, thanks for the feedback! nice to know that it was a good effort hehe

and thanks to piet_v for solving the questions before me haha


I brewed this weekend and used Beersmith as well as your spreadsheet, I got my crush spot on so my efficiency hit just over 80%, your spreadsheet and Beersmith almost matched, I wouldn't say that either is the most accurate, there are too many variables to affect the numbers on brewday, but both were close enough for me. So I'll use the spreadsheet to get an idea about what I need in terms of volume, OG and grain quantities and then tweak my design in Beersmith and on the day as long as the moons are aligned it will all work out.

A great planning addition, many thanks.
To brew or not to brew, that would be a stupid question !
User avatar
BrauTim
 
Posts: 541
Joined: Sun Feb 02, 2014 1:03 pm
Location: England
Model: 50 litres


Return to General / Tips and Tricks

Who is online

Users browsing this forum: grooves and 1 guest