![]() ![]() ![]() The most important thing to decide up front is whether the model you are trying to build actually is of a circular nature. Especially important: Devise a way to clearly indicate the circular reference chain. If -and only if- you are convinced you really need circular references to solve your problem, meticulously document your model, stating clearly what your intentions are and how the model functions. Distillation plants often have such streams and if you want to calculate a model of such plant, using a circular reference may be a good way to model your process. Examples may include models of a chemical facility where (part of) an input stream of a process is a recycled output stream of the same process. Some people deliberately create (sets of) circular reference chains to have a calculation model do iterative calculations. These are the realm of the experienced Excel developer, the Excel whizz kid who (thinks he) knows what he is doing. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |