Odd Brun Water screen

[Beer-lord]

I'm somewhat Excel dumb but in all the years I've used Brun Water, I've never seen these lines with arrows before and have no idea what they are. I deleted the version 5.5 and downloaded it new but they still show up. Can someone tell me what this is and how I can remove them?

Nothing I do changes the ph value.

 

[Big Monk]

I'm somewhat Excel dumb but in all the years I've used Brun Water, I've never seen these lines with arrows before and have no idea what they are. I deleted the version 5.5 and downloaded it new but they still show up. Can someone tell me what this is and how I can remove them?

Nothing I do changes the ph value.
View attachment 606803

This are dependent/precedent arrows. They link cells connected to one another by variables.

Try Formulas -> Remove Arrows

 

[Beer-lord]

The remove arrows options is greyed out. It's weird because I've been using Brun Water for years and have never, ever seen this in any of the 5 versions I've used.

 

[dmr]

I believe the issue is a case of circular references that Excel cannot resolve. I've seen this issue in the free version 1.24, I believe.

 

[MT_Keg]

I believe there is a setting in the options to allow for iterative calculations:

In Excel (windows), go to File/Options/Formulas and enable Iterative Calculation. In Excel (mac), go to Preferences and then look under heading “Formulas and Calculation” and open “Calculation”, then click box “Use iterative calculation”. In LibreOffice, go to Tools/Options/LibreOffice Calc/Calculate and enable Iterative References.

 

[Big Monk]

I believe there is a setting in the options to allow for iterative calculations:

In Excel (windows), go to File/Options/Formulas and enable Iterative Calculation. In Excel (mac), go to Preferences and then look under heading “Formulas and Calculation” and open “Calculation”, then click box “Use iterative calculation”. In LibreOffice, go to Tools/Options/LibreOffice Calc/Calculate and enable Iterative References.

In most cases you don’t want to allow circular references. It usually means there is a code error somewhere.

Maybe Martin can chime in.

 

[MT_Keg]

In most cases you don’t want to allow circular references. It usually means there is a code error somewhere.

Maybe Martin can chime in.

Totally agree with you! In this case, it seems to be part of the methodology the developer used. I pulled the instructions from the hyperlink below.

https://sites.google.com/site/brunwater/home/troubleshooting

 

[mabrungard]

In most cases you don’t want to allow circular references. It usually means there is a code error somewhere.

There is no problem with circular references unless a Diverging Solution is possible. That is not the case in their use in Bru'n Water. The current mash pH result is used in subsequent calculations. Circular References are on purpose and quite useful in the program.

As mentioned, its easy to resolve the arrows as pointed out above.