Mash / Wash Calculator & Estimator Spreadsheet v1.5

Distillation methods and improvements.

Moderator: Site Moderator

Post Reply
hpby98
Site Donor
Site Donor
Posts: 314
Joined: Thu Jun 01, 2017 3:38 pm
Location: New Zealand

Mash / Wash Calculator & Estimator Spreadsheet v1.5

Post by hpby98 »

Howdy All,

An update to my previous spreadsheet

1) Nothing is locked in it - all formulas can be reviewed
2) Temperature calibration for SG is from here: https://www.homebrewtalk.com/forum/thre ... st-4481380" onclick="window.open(this.href);return false;" rel="nofollow
3) It's part of a bigger workbook that I'm working on, formulas all work, just need to tidy a bit more

To Use:

It is in °C, and in litres. Although if you just ignore the word Litres in the heading and substitute Gallons it should work exactly the same. Changing to Fahrenheit would be a bit more work.

There is sample data - you can delete anything in the colored cells - but only edit the colored cells for best results please, as white cells will be formulas.

SG Calibration = 60°F is 15.55556°C and most modern Hydrometers should be calibrated for 60°F - check yours though
SG Multiplier = I've seen both 129 and 131 referenced.
Desired Final % = What proof you expect the end result to be, which will then be used to calculate approximate quantities for your runs
Size = Wash / Mash size in Litres
Goal = Final SG you're shooting for


Really, all that is required is the date / time, the SG reading and the temperature reading - the sheet will handle the rest


It is attached as an OpenOffice calc document - and sample data is included.

Clear the Yellow Cells to start using your own data in it - and only add your data to these cells

Ctrl + shift + alt + ";" key in Google Sheets = inserts current date and time in the cell.

Excel Users - Quick Fix
After opening do a Find and Replace:
Find " =0 "
Replace with " =False "



Image

https://i.imgur.com/hGLjHx3.png" onclick="window.open(this.href);return false;" rel="nofollow
Attachments
Calc v1.5.zip
(88.65 KiB) Downloaded 441 times
Post Reply