- Joined
- Sep 27, 2012
- Messages
- 14
- Reaction score
- 4
- Points
- 3
G'day,
I've been trying to create a spreadsheet to replicate the Gyle Calc - just for fun and to better understand the functions involved.
I've got it pretty close, but it returns a different enough result to your calc that I thought I'd ask ...
So...
I take the wort OG and FG and convert from SG to Plato p=259-(259/sg)
I take the desired vol CO2 and convert to g/l - vol co2 x 1.96
I take the fermentation temp and find the existing CO2 on a table - 20c gives 0.86 - which is then converted to g/l 1.69 and subtract that from the rqd CO2 - so for 2.4vol (4.7 g/l) the required extra g/l is 3.02
Then (0.24*vol*CO2 rqd) / (OG-FG) which spits out the amount of gyle required.
but for 20 litres of 1.040 - 1.010 at 20c I get 1.96litres required, while your calc get 2.3l required.
So.. what am I missing?
Thanks for your help if you can!
Rhys
I've been trying to create a spreadsheet to replicate the Gyle Calc - just for fun and to better understand the functions involved.
I've got it pretty close, but it returns a different enough result to your calc that I thought I'd ask ...
So...
I take the wort OG and FG and convert from SG to Plato p=259-(259/sg)
I take the desired vol CO2 and convert to g/l - vol co2 x 1.96
I take the fermentation temp and find the existing CO2 on a table - 20c gives 0.86 - which is then converted to g/l 1.69 and subtract that from the rqd CO2 - so for 2.4vol (4.7 g/l) the required extra g/l is 3.02
Then (0.24*vol*CO2 rqd) / (OG-FG) which spits out the amount of gyle required.
but for 20 litres of 1.040 - 1.010 at 20c I get 1.96litres required, while your calc get 2.3l required.
So.. what am I missing?
Thanks for your help if you can!
Rhys