Difference between revisions of "Tables for Conversions and Calculations"

From German brewing and more
Jump to: navigation, search
(→‎Efficiency troubleshooting)
 
(12 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 suite that supports Excel spreadsheets.''
 +
 
===Hydrometer/Refractometer correction===
 
===Hydrometer/Refractometer correction===
 
[http://www.braukaiser.com/documents/hydrometer_conversion_tables.pdf Hydrometer conversion tables]
 
[http://www.braukaiser.com/documents/hydrometer_conversion_tables.pdf Hydrometer conversion tables]
Line 16: 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 ===
  
−
A simple Excel spread sheet for blending brewing water and calculating salt additions.  
+
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
  
−
* [http://braukaiser.com/documents/water_calculator.xls water_calculator.xls]
+
* [http://braukaiser.com/documents/Kaiser_water_calculator.xls Kaiser_water_calculator.xls]
−
* [http://braukaiser.com/documents/water_calc_mobile.xls water_calc_mobile.xls] formated to me used on mobile devices running a spreadsheet application (e.g. Mariner Calc on iPhone/iPod)
+
* [http://braukaiser.com/documents/Kaiser_water_calculatorUS_units.xls Kaiser_water_calculator_US_units.xls]
  
 
=== Efficiency troubleshooting ===
 
=== Efficiency troubleshooting ===
Line 31: 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===
 +
 +
* [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 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

Retrieved from "http://braukaiser.com/wiki/index.php?title=Tables_for_Conversions_and_Calculations&oldid=4815"