In this week’s Friday tip, we will look at referencing a cell within an internal spreadsheet, using the spreadsheet button within the formula editor.
Let’s imagine that we have a factory, which is modeled using the simple simulation below:
Within our simulation, we will have an internal spreadsheet which contains the timings for each of the machines. In this example, I will call this “ssTimings”. In most real-life examples, we would not simply have a spreadsheet with the machine name and the processing time: Continue reading