New Brewing Software
Posted: Thu Jul 19, 2018 11:12 pm
I’d like to announce the fruit of a recent collaboration between A.J. deLange and I which I’ve tentatively titled “The deLange-Scott Brewing Engine”.
It is a brewing spreadsheet which incorporates the proton deficit/charge accounting method of pH estimation long lauded by A.J.. Essentially it is a second generation pH estimation algorithm that finally leaves behind color based acidity approximations and other assumptions made by readily available water chemistry software and implements a technically and scientifically sound pH estimation method. In addition, it also allows for recipe input, bitterness estimation, color estimation, volume tracking and equipment profile, and extract estimation (including either No-Sparge or Batch Sparge).
It incorporates the common Low Oxygen brewing features such as metabisulfite dosing for mash and sparge water and Morey equation modifier for accounting for the lack of color pickup in the presence of oxygen.
In addition to a rigorously prepared set of calculations it utilizes the embedded Excel Solver and Macro buttons to offer unparalleled user control over the target pH and amounts of acid/base components to be used.
The sheet will be offered for free but protected to safeguard the integrity of the calculations and algorithm.
It should be available sometime next week following peer review by A.J. and the subsequent comment incorporation, error checking, and final formatting.
It is a brewing spreadsheet which incorporates the proton deficit/charge accounting method of pH estimation long lauded by A.J.. Essentially it is a second generation pH estimation algorithm that finally leaves behind color based acidity approximations and other assumptions made by readily available water chemistry software and implements a technically and scientifically sound pH estimation method. In addition, it also allows for recipe input, bitterness estimation, color estimation, volume tracking and equipment profile, and extract estimation (including either No-Sparge or Batch Sparge).
It incorporates the common Low Oxygen brewing features such as metabisulfite dosing for mash and sparge water and Morey equation modifier for accounting for the lack of color pickup in the presence of oxygen.
In addition to a rigorously prepared set of calculations it utilizes the embedded Excel Solver and Macro buttons to offer unparalleled user control over the target pH and amounts of acid/base components to be used.
The sheet will be offered for free but protected to safeguard the integrity of the calculations and algorithm.
It should be available sometime next week following peer review by A.J. and the subsequent comment incorporation, error checking, and final formatting.