Difference between revisions of "Tables for Conversions and Calculations"

From German brewing and more
Jump to: navigation, search
(Efficiency troubleshooting)
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
''If you don't own a copy of Microsoft Excel, check out [http://www.openoffice.org OpenOffice.org] which is a free office suit that supports Excel spreadsheets.''
+
''If you don't own a copy of Microsoft Excel, check out [http://www.openoffice.org OpenOffice.org] which is a free office suite that supports Excel spreadsheets.''
  
 
===Hydrometer/Refractometer correction===
 
===Hydrometer/Refractometer correction===
Line 18: Line 18:
 
* range 1.000 – 1.120 SG to gravity points conversion with Celsius scale
 
* range 1.000 – 1.120 SG to gravity points conversion with Celsius scale
 
* range 1.000 – 1.120 SG to gravity points conversion with Fahrenheit scale
 
* range 1.000 – 1.120 SG to gravity points conversion with Fahrenheit scale
 +
 +
=== refractometer Brix to Plato and SG ===
 +
 +
* [http://braukaiser.com/download/Kaiser_Brix_Plato_SG_table.pdf Kaiser_Brix_Plato_SG_table.pdf] conversion table that allows conversion of wort refractometer readings to Plato and SG
  
 
=== water calculator ===
 
=== water calculator ===
Line 24: Line 28:
  
 
* [http://braukaiser.com/documents/Kaiser_water_calculator.xls Kaiser_water_calculator.xls]
 
* [http://braukaiser.com/documents/Kaiser_water_calculator.xls Kaiser_water_calculator.xls]
 +
* [http://braukaiser.com/documents/Kaiser_water_calculatorUS_units.xls Kaiser_water_calculator_US_units.xls]
  
 
=== Efficiency troubleshooting ===
 
=== Efficiency troubleshooting ===
Line 32: Line 37:
 
* [http://braukaiser.com/documents/eff_calc_mobile.xls Efficiency-Troubleshooting-Spreadsheet] (XLS version optimized for use with mobile devices running a spread sheet application like [http://www.marinersoftware.com/sitepage.php?page=136 Mariner Calc for iPhone/iPod touch]) (v1.5i which includes error analysis)
 
* [http://braukaiser.com/documents/eff_calc_mobile.xls Efficiency-Troubleshooting-Spreadsheet] (XLS version optimized for use with mobile devices running a spread sheet application like [http://www.marinersoftware.com/sitepage.php?page=136 Mariner Calc for iPhone/iPod touch]) (v1.5i which includes error analysis)
 
* [http://braukaiser.com/documents/efficiency_calculator_mobile.xml Efficiency-Troubleshooting-Spreadsheet] (XML version optimized for use with mobile devices running a spread sheet application)
 
* [http://braukaiser.com/documents/efficiency_calculator_mobile.xml Efficiency-Troubleshooting-Spreadsheet] (XML version optimized for use with mobile devices running a spread sheet application)
 +
 +
=== Batch Sparge and Party Gyle simulator ===
 +
 +
This is a spreadsheet that allows you to estimate your batch sparge efficiency and plan party gyle brewing
 +
 +
* [http://braukaiser.com/documents/batch_sparge_simulator.xls batch_sparge_simulator.xls]
  
 
===Carbonation calulator===
 
===Carbonation calulator===
  
* [http://braukaiser.com/documents/Kaiser_carbonation_calculator_US.xls] - preloaded with U.S. units
+
* [http://braukaiser.com/documents/Kaiser_carbonation_calculator_US.xls Kaiser_carbonation_calculator_US.xls] - preloaded with U.S. units
* [http://braukaiser.com/documents/Kaiser_carbonation_calculator_metric.xls] - preloaded with metric units
+
* [http://braukaiser.com/documents/Kaiser_carbonation_calculator_metric.xls Kaiser_carbonation_calculator_metric.xls] - preloaded with metric units

Latest revision as of 20:51, 9 March 2012

If you don't own a copy of Microsoft Excel, check out OpenOffice.org which is a free office suite that supports Excel spreadsheets.

Hydrometer/Refractometer correction

Hydrometer conversion tables

This is a set of tables that you can use to convert and temperature correct a hydrometer or refractometer reading. Tables for precision hydrometers (0.990– 1.020 SG) and regular range hydrometers are available. In addition to that various combinations with regard to the temperature scale being used.

  • range 0.990 – 1.020 to Plato conversion with Celsius scale
  • range 0.990 – 1.020 to Plato conversion with Fahrenheit scale
  • range 0.990 – 1.020 to SG conversion with Celsius scale
  • range 0.990 – 1.020 to SG conversion with Fahrenheit scale
  • range 0 – 30 Plato/Brix to Plato conversion with Celsius scale
  • range 0 – 30 Plato/Brix to Plato conversion with Fahrenheit scale
  • range 0 – 30 Plato/Brix to gravity points conversion with Celsius scale
  • range 0 – 30 Plato/Brix to gravity points conversion with Fahrenheit scale
  • range 1.000 – 1.120 SG to Plato conversion with Celsius scale
  • range 1.000 – 1.120 SG to Plato conversion with Fahrenheit scale
  • range 1.000 – 1.120 SG to gravity points conversion with Celsius scale
  • range 1.000 – 1.120 SG to gravity points conversion with Fahrenheit scale

refractometer Brix to Plato and SG

water calculator

A simple Excel spread sheet for blending brewing water and calculating salt additions. It also handles dissolved chalk and predicts the mash pH shift based on residual alkalinity and mash thickness. It is formatted such that it works well on a desktop/laptop computer and on a mobile device

Efficiency troubleshooting

A simple Excel spread sheet that can list the various losses of efficiency that happen during mash and lauter:

Batch Sparge and Party Gyle simulator

This is a spreadsheet that allows you to estimate your batch sparge efficiency and plan party gyle brewing

Carbonation calulator