Circuit Breaker

[Anonymous]

Thanks for the tutorial on adding a circuit breaker to models with circular references. If I were to incorporate one into my own model, how would I know where to add the conditional formula IF(circuit breaker=”on”,1,…)? The video states that it needs to added to a couple different formulas to work properly but how do you know which formulas to apply it to if the whole sheet reads #VALUE/#REF?

[Michael Belasco]

Thanks for the question and it’s a really good one. At a high level, the answer is you need to input the circuit breaker formula wherever there is a circular reference until they have all been eliminated when the circuit breaker turns on. Below is how I go about the process of finding these cells in a sea of cells with errors. I hope this is helpful and if any of the video is unclear, please let me know.

Thanks,

MB

[Author]

Posts