We often get calls from customers who have copied a model to another computer and then get the dreaded “…file was not found” message when they open the model. It may be a missing picture, Excel spreadsheet or some other imported file. When copying a model from one computer to another, you may need to …
One of the questions I often get asked in both my professional and personal life is “What is Systems Thinking?” It seems like a simple question but the answer can be very different depending on who you’re talking to. Much of my career has been involved in the development of software so it is only …
Version 9.1.2 adds the ability to incorporate non-regularly sampled data easily into your models. Many people use the graphical function for historical records of data. The graphical function, however, assumes a fixed interval along the x-axis. This can make it difficult to use data like the following:
While it is easy to determine the fixed interval to use to capture all of these points (1 day), it is more difficult to determine what data points to use for the missing intermediate 1-day values. There are also many cases where it is very difficult to find a fixed interval that works for a given dataset.
The LOOKUPXY built-in was specifically added to address this issue. It is unique in that it requires two separate graphical functions: one for the x-coordinates of each pair and one for the y-coordinates of each pair. The number of points in each graphical function should match; if they do not, extraneous points are ignored. The data values (x-coordinates and y-coordinates) are both entered by the user as the y-values in each graphical function. The x-values in each graphical function are ignored; only the number of points matter. It is a good idea, though, to run the x-axis of both from one to the number of points. That way, it is easy to verify that the values in each graphical function properly align with one another. In addition, the x-coordinates should be in increasing order. If they are not, however, the program will automatically readjust them when the model is first run.