Simple utility spreadsheet(s) for playing "what if" with respect to pre and post boil volumes and SG's.

[Silver_Is_Money]

A calculator (in two versions) focused upon projecting post boil and cooling volume based upon the input of pre boil volume plus pre and post boil SG's, but also offering several other useful "what if" type applications/derivations of use with respect to volumes and SG's. Download by pressing the "down" arrow seen sitting next to the printer icon in the upper right hand corner, then run in Excel or LibreOffice Calc.

Link to the free Gallons and Pounds version:
https://drive.google.com/file/d/1SNPPOhg4pMVOQNJt3jh0xuv2DbKg6VhY/view?usp=sharing

Link to the free Metric version:
https://drive.google.com/file/d/1br8rGBYz538qenyWUAqKQBG-F9PiJJq6/view?usp=sharing
If this utility is welcomed, I will add a sheet/tab for it to a future version of 'Mash Made Easy'.

 

[Brooothru]

A calculator (in two versions) focused upon projecting post boil and cooling volume based upon the input of pre boil volume plus pre and post boil SG's, but also offering several other useful "what if" type applications/derivations of use with respect to volumes and SG's. Download by pressing the "down" arrow seen sitting next to the printer icon in the upper right hand corner, then run in Excel or LibreOffice Calc.

Link to the free Gallons and Pounds version:
https://drive.google.com/file/d/1SNPPOhg4pMVOQNJt3jh0xuv2DbKg6VhY/view?usp=sharing

Link to the free Metric version:
https://drive.google.com/file/d/1br8rGBYz538qenyWUAqKQBG-F9PiJJq6/view?usp=sharing
If this utility is welcomed, I will add a sheet/tab for it to a future version of 'Mash Made Easy'.

Yikes! Where were you when I needed that? I just finished a months' long project of building a work flow Excel sheet to do that, refining it down to the 1/10th liter for every step from pre-strike volume to chilled wort into the fermenter. After three months and five brew batches I finally got everything dialed in for my specific setup. While I'm happy with the end result, it isn't as readily adaptable to other equipment profiles unless you have a 20L Braumeister since the boil-off and deadspace & trub losses are a bit unique.

By the way, nice work!