How then can you state that it is merely smoke and mirrors? Only the later generations of my software have transitioned to a system based purely upon logarithms. Earlier versions did not use logs at all. Then there were attempted hybrid engines mixing logs and other methods. Then lastly the pure log based engine.
I’ve seen your latest sheet.
I am going to include your sheet in my analysis tomorrow. Again, I will never disclose any behind the scenes details. You should know that opening a protected sheet in Google sheets bypasses all protection. There is no way around it. I don’t bother with sheet protection anymore for that reason.
It part of the reason I went to Macros and the solver.
I can explain to you privately why I think the log thing is smoke and mirrors and a dead end. Also, like I told Vince, thinking you’ve bypassed color based prediction because you jettison color based acidity proxies altogether is not realistic. Either you base a malts acidity on a color proxy or it’s titration characteristics. Sidestepping it altogether and just using a malts DI pH is not a complete picture.
I don’t have anything against you personally Larry. I do find it a bit annoying how you market MME with vieled digs at other programs, Brun Water in particular, without fully understanding your own, but that in no way shape or form means I don’t think you’re a nice guy. I’ve interacted enough in private conversation to know that you mean well.
Tomorrow it’s my hope that we will all learn a lot about how these things receive equal inputs and how playing around with them a little can tighten the spread between them. I think, at least as far as the color based sheets are concerned, you see a parity that may not otherwise be obvious.
Keep in mind that I’m only going to analyze Grist pH, as I feel differences between how sheets model the other parameters is not interesting. It’s so easy to use the right calcs for Source Water, Minerals, Acids, Bases, etc. that there should really be no difference between all the known sheets.
Grist modeling is where the disparities and interesting bits lie.