Hi, I'm working on my dashboard of my model and right now I have a table that records when a token from a specific machine goes to "process time", is there a way I can add another column counting the tokens of each machine (for example the ML00 goes from 1 to 487)? This counter will help to analyze the data in excel.
Yes, you can do that, albeit a tiny bit 'hacky'.
Creating one row per combiner is easily done by using a Column Set (see documentation for details). As long as any new combiners are in the "Combiners" group, a column will be created for it.
The exit event will update all of those columns. However in the "Event Value" field, you can use code so the current model time is only written to the cell if the 'column value' is equal to the combiner name on the token. Otherwise it keeps the current value.
I also activated path caching in the A* navigator. It will speed up the run speed considerably.
That worked perfectly, right now I have just another problem.
I've assign a label with "batchweight" and I wanted to get a table in the dashboard that would tell me the total weight from each combiner.
How can I sum the weights?
Option 1:
This would use a single Statistics Collector. Listen to some Entry or Exit event of the token. Use the combiner name as the row value and do not finish the row. Have one column show the combiner name and one for the total weight. The total weight column should have a "Row Add Value" of 0 and an "Event Value" of "data.currentValue + data.token.batchweight" and be updated by the event that creates the row.
Option 2:
Use a Statistics Collector to create a separate row for each token, storing the combiner name and weight of that token. Then use a Calculated Table to sum the weights together, partitioned by the combiner name.
12 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
