Problem with circular reference

[sakaria_123]

I want to create a formula that adjusts the the system capacity (dependent on max, min, and size) based on the tank inventory. The tank inventory depends on different things as stated in the formula.

Problem that accurs:
- req bio cell, comes from diff between produced and required, and the bio produced comes from system again (is this the reasoning for the circular loop)
- i want the tank to never get lower kg then 10, but the thing is that this cell is supposed to say to the system: "produced more bio for me to never get so low, if the tank is too low, produce more, if the tank is full, produce less ", i want this system to be optimilized

formulas:
system size meet energy =A17/$B$4
System =MIN(IF(K17>$B$8,$B$3*$B$7*100,IF(K17<$B$8,$B$3*$B$6*1000,$B$3*1000)))
biogas produced:=C17*($B$5/$B$4)
biogas required =A17*($B$5/$B$4)
diff req - produced =E17-D17
energy from system =D17*$B$5
additional heat = =G17-A17
req biogas to tank =IF(F17 < 0, ABS(F17), 0)
adding to tank =IF(I17 > 0, G17, 0)
tank inventory =MAX(MIN(B10-I17+J17,B8),B9)

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Problem with loop in excel, circular references that creates errors
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[sakaria_123]

Okey thanks!

Could i get help with this one: Problem with loop in excel, circular references that creates errors
I have cross-posted from another website.

It would be easier if you answered here in this forum.
Thanks in advance.

 

[sakaria_123]

Could someone help me?