Page 1 of 1

New Brewing Software

Posted: Thu Jul 19, 2018 11:12 pm
by Big Monk
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.

Re: New Brewing Software

Posted: Tue Jul 24, 2018 9:05 pm
by Big Monk
Looks like I’ll be releasing a 2 versions, both with a metric/English switch built in, 1 using percentage based recipe input (my preference) and weight/mass based (A.J.’s preference).

Any people want to β test the sheet? I’m looking for people who plan on brewing this week.

Re: New Brewing Software

Posted: Tue Aug 28, 2018 9:42 am
by rzwahr
Are you still looking for people to evaluate the sheet, or has it already been released?

Re: New Brewing Software

Posted: Fri Aug 31, 2018 1:30 pm
by caedus
I am brewing every week. I am a commercial brewer now, trying to apply some of the methods learned here to my 7bbl brewhouse.

I would love to see your pH calculator. I have my own, but it sometimes gets a bit wonky because I am neither a water chemist, nor a programmer.