Mash pH prediction is different between calculators

[Silver_Is_Money]

Getting closer, but I'm still seeing only ERR:522 for the predicted mash pH.

 

[Big Monk]

Getting closer, but I'm still seeing only ERR:522 for the predicted mash pH.

I apologize but I'm not familiar with libre office so I can't really troubleshoot based on that. I have not seen any major pH estimations errors on my end and I have error logic incorporated.

Can you send me a screenshot of the error message?

 

[Silver_Is_Money]

PM sent with screen shot.

 

[Big Monk]

PM sent with screen shot.

Sorry I can't be more help. It is working fine for me in excel and google sheets.

I'll research it a bit more and if it's something I can fix I certainly will.

 

[Big Monk]

I think I know what's going on and I'm going to fix it in the morning.

 

[Silver_Is_Money]

I think I know what's going on and I'm going to fix it in the morning.

Thank you! I just tried the first release version from about a week ago again and it works fine with LibreOffice,

 

[Big Monk]

This version should fix your issue with Libre Office. Open Source versions and some older versions of Excel get very wonky when Data Validation and linking to other cells is involved.

I believe this version will be good:

http://www.********************/uncategorized/water-a-new-water-chemistry-spreadsheet/