I don't believe it will be compatible. Excel for Mac is a different beast.
Good thing I can duel boot windows then! Thanks for all your hard work on this and for sharing that with the community.
I don't believe it will be compatible. Excel for Mac is a different beast.
Downloaded V 1.07 last week and used for water adjustments for a Pale ale, vs Bru'n Water which I usually use. Water Engine pH was slightly lower than Bru'n Water and pretty much spot on with what my actual pH was. Awesome!
But this week, using V 1.09 for a Pilsner, I get a pH of 5.21 with Bru'n Water and my salt additions plus 1 mL of lactic acid, but Water Engine with same salts and lactic comes out to 5.660. I would have to up the lactic additions to 8.5 mL, which gets me to 5.214. I am using Mecca Grade Pelton Pilsner which is listed at 5.9 pH on their site and their Metolius Munich malt which lists at 5.75 pH. Both use 100% distilled water with BIAB full volume mash.
Seems like Water Engine may be the more accurate, since two base malts in a Pilsner without any acidulated malt and minor water adjustments (3.4 grams each of gypsum, CaCl and 2.6 Epsom Salt in 8.86 gallons) would need a healthy dose of acid to get down to the targeted pH.
Glad to hear it!
Did you model the Mecca malts as American Pilsner and Munich or as Euro Pilsner and Munich? Try it both ways because that Mecca Grade malt looks characteristically closer to euro malt than NA counterparts.
Just curious...
Glad to hear it!
Did you model the Mecca malts as American Pilsner and Munich or as Euro Pilsner and Munich? Try it both ways because that Mecca Grade malt looks characteristically closer to euro malt than NA counterparts.
Just curious...
So changing the Mecca Grade malts to European malts, but keeping their reported pH, drops the required amount of lactic to 7 mL from 8.5 to get to 5.2 pH. Keeping the malt database pH instead of actual, reduces it to 6.5 mL. So either way, it's still a big difference from Bru'n Water. Will play it safe and add half of the needed lactic, take my pH and then adjust from there.
Ok guys i have few questions:
What malt type should i consider for Chit malt?, on Brun'Water it recommends taking the mash pH after 15 minutes of the mash, is this the same for Water Engine?. if i add salt additions in sparge water, on Water Engine is on kettle additions?
ThanksChit malt is essentially undermodified Pils malt. I would try it as continental pils and if you feel that doesn’t work out well for estimation, try light crystal or flaked barley as a drop down.
I recommend a room temp sample at 30 minutes into the mash.
Kettle Minerals can either be added to the sparge water or directly to the kettle, whichever you prefer.
The altbier recipe matches exactly to ver 1.09 outcome.
I do miss the Solve for Alkalinity button, but just used what v1.09 did with my base water.
Very nice!
[Edit: Meant to mention this is Excel 2007, worked flawlessless, no changes that had not already been made for ver 1.09]
Thanks, that's what I figured. Same with try-retry on acid or NaCOH. What I feel like I need to figure out is how to titrate my phosphoric acid to find what it really is %-wise, and any malt I use for diph. There's gotta be some easy McGiver way with a coffee maker, an arduino, some dental floss and Tums.It was all or nothing with the solver. You can still find alkalinity by increasing or decreasing it to zero the balance value.
Thanks, that's what I figured. Same with try-retry on acid or NaCOH. What I feel like I need to figure out is how to titrate my phosphoric acid to find what it really is %-wise, and any malt I use for diph. There's gotta be some easy McGiver way with a coffee maker, an arduino, some dental floss and Tums.
Give circular reasoning a shot. If implemented correctly it becomes a lot like running solver without having to run solver.
claims to have a linky:
View attachment 622544
I know it won't run properly in Linux under LibreOffice, but I gave it a shot anyway. As @balrog stated, right out of the starting blocks it is looking for a file that resides only on your computer.
Preferences is Windows terminology. I made the change (albeit a bit differently, and under Options) in LibreOffice for Linux, setting Excel 2007 and newer to "Always Recalculate", and upon returning to the spreadsheet I was immediately greeted with a "Basic Run Time Error '423' Range". Once again I had to kill the spreadsheet to exit it.
I then reloaded it and the same error occurred.
Ah! The plot thickens. Not only is it a Libre issue, but also a Linux issue.
I'm trying to help you man!
Ah! The plot thickens. Not only is it a Libre issue, but also a Linux issue.
I'm trying to help you man!
Did the person using LibreOffice in Windows install the optional "Non-Linear Solver" package? I do not have it installed on my present Linux system, but it should be available. I only have the "default" Linux/LibreOffice Solver that can find solutions for linear equations.
OK! In the mean time I went ahead and installed the non-linear add-on to my Solver anyway.
Now back to the problem. This code line seems to be where it is always hanging up:
113 VStrike = Sheet3.Range("W21").Value
Bingo, it works now! Without changing anything else to the downloaded program, I added 3 grams CaCl2, 4 grams CaSO4, and 3.82 mL of 88% Lactic Acid, and mash pHz went to 5.400. Is this the same for you, as if so, I believe you have conquered the 'LibreOffice Calc' issue.
I do have my LibreOffice set to "Always Recalculate" Excel 2007 and newer spreadsheets. The Linux pathway to this setting is:
Tools, Options, LibreOffice Calc, Formula, ...
Back to not working in LibreOffice under Linux.
I use Linux and have this open in LibreOffice 6.1.5.2. Trying to sort it all out, but it is responding to my entries but no pH yet just showing ###.
Enter your email address to join: