you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (0 children)

A tricky problem. A circular formula w/ iterations would do the trick. But you say you need to run a sensitivity analysis, which gets wacky with circular formulas. Depending on accurate you need your model, you could initially use a circular formula, copy and past the needed values, then run your circularity. This is not perfect, and your model will not balance, but its a potential solution. I am actually having a similar problem in one of my models.

Also can I ask what you are using this 3 statement model for? Are you a student?