Fermentation Temperature (°C) | |
Batch Volume (L) | |
Desired Cerbonation level (vols of CO2) | |
*Required Fermentation Pressure |
=((targetvolsco2+0.003342)/((0.01821+0.09011*Math.exp(-((temperature*(9/5))/43.11)))))-14.695 |
Actual Fermentation Pressure | |
Actual Carbonation Levels (vols of CO2) |
=((actualpressure+14.695)*(0.01821+0.09011*Math.exp(-((temperature*(9/5))/43.11))))-0.003342 |
Volume to Bottle (L) | |
Bulk Prime? | |
Bottle size | |
Dex/Sugar | |
Weight required (g) |
=IF(bulkprime="yes",IF(actualvolsco2>targetvolsco2,"NIL",IF(dexsugar="dex",(targetvolsco2-actualvolsco2)*4*voltobottle,(targetvolsco2-actualvolsco2)*4*voltobottle*0.91)),IF(dexsugar="dex",IF((actualvolsco2>targetvolsco2),"NIL",IF(bottlesize="750",(targetvolsco2-actualvolsco2)*4*0.75,(targetvolsco2-actualvolsco2)*4*0.375)),IF((actualvolsco2>targetvolsco2),"NIL",IF(bottlesize="750",(targetvolsco2-actualvolsco2)*4*0.75*0.91,(targetvolsco2-actualvolsco2)*4*0.375*0.91)))) |
Carb Drops/bottle |
=IF(bulkprime="no",IF((actualvolsco2>targetvolsco2),"NIL",IF(bottlesize="750",(actualvolsco2/targetvolsco2)*2,(actualvolsco2/targetvolsco2)*1)),"") |