Difference between revisions of "Tables for Conversions and Calculations"
From German brewing and more
(→water calculator) |
|||
| (15 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/ | + | * [http://braukaiser.com/documents/Kaiser_water_calculator.xls Kaiser_water_calculator.xls] |
| − | * [http://braukaiser.com/documents/ | + | * [http://braukaiser.com/documents/Kaiser_water_calculatorUS_units.xls Kaiser_water_calculator_US_units.xls] |
=== Efficiency troubleshooting === | === Efficiency troubleshooting === | ||
| Line 28: | Line 34: | ||
A simple Excel spread sheet that can list the various losses of efficiency that happen during mash and lauter: | A simple Excel spread sheet that can list the various losses of efficiency that happen during mash and lauter: | ||
| − | * [http://braukaiser.com/documents/efficiency_calculator.xls Efficiency-Troubleshooting-Spreadsheet] ( | + | * [http://braukaiser.com/documents/efficiency_calculator.xls Efficiency-Troubleshooting-Spreadsheet] (desktop screen version) |
| − | * [http://braukaiser.com/documents/ | + | * [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.
Contents
Hydrometer/Refractometer correction
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
- Kaiser_Brix_Plato_SG_table.pdf conversion table that allows conversion of wort refractometer readings 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:
- Efficiency-Troubleshooting-Spreadsheet (desktop screen version)
- Efficiency-Troubleshooting-Spreadsheet (XLS version optimized for use with mobile devices running a spread sheet application like Mariner Calc for iPhone/iPod touch) (v1.5i which includes error analysis)
- 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
Carbonation calulator
- Kaiser_carbonation_calculator_US.xls - preloaded with U.S. units
- Kaiser_carbonation_calculator_metric.xls - preloaded with metric units
