damo.otenko Beer Gallery Player /tracks

Pressure Calculator

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)),"")