Statistics collector for Combiner

Question

question

Adarsh T asked Jan 13, '20 Jordan Johnson answered Jan 20, '20

Statistics collector for Combiner

Hello All,

I'm using a statistics collector to collect data from a combiner .

i'm able to collect the total number of Input / Output parts from the combiner.

But I also want to collect the input from only one particular input port of a combiner.

Note : I don't want to use the output from previous station (like sink in this model ).

Please find the attached sample model. (combiner-input-port-statistic-collector.fsm )

Thank you in advance..

Software Version:

FlexSim 19.1.1

statistics collector

q1.jpg (290.6 KiB)

combiner-input-port-statistic-collector.fsm (21.2 KiB)

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Braydn T commented · Jan 13, 2020 at 04:14 PM

@Adarsh T

I have a work around you can use:

What are you doing with the numbers after you collect them? If your combiners combine 6 items and 1 pallet, then you can divide the total number of inputted items by 7. If you want the number of pallets, then that's the number. If you want the number of items, then you can subtract that number from the total. Depending on what you do with the numbers you collect, you would execute that in different places.

There may also be a more elegant way to do this. If anyone has any input, feel free to chime in.

0 ·

Answer 1 · 2020-01-20T17:06:59Z

Jordan Johnson answered Jan 20, '20

To make the table you want, you need to do two steps. First, you need some way to record statistics per port per combiner. I used a Statistics Collector to do that. It has one row per combiner per port that items enter in, and it counts how many times items come in each port.

Next, you need to have a table that records those values once every hour. To do this, I also used a Statistics Collector. The second Statistics Collector records data every hour. It has a column for time. It also has a column set. A column set lets you specify a list of columns on reset. This way, if you change the number of objects in the group, the stats collector can add another column for that object automatically. So I made one column per combiner per port (just ports 1 and 2). Every hour, each of those columns looks up the the correct value in the first combiner.

combiner-input-port-statistic-collector-vs-time.fsm

combiner-input-port-statistic-collector-vs-time.fsm (24.6 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 2 · 2020-01-13T19:48:58Z

Jordan Johnson answered Jan 13, '20 Adarsh T commented Jan 17, '20

Here is a model with a table that shows the input through port 2 of each combiner:

combiner-input-port-statistic-collector-modified.fsm

Here are the steps to making the Statistics Collector:

Add a Timer event that fires at time 0, and does not repeat. Add a label to this event called Combiner, with the value of
```
Group("Group1").toFlatArray()<br>
```
Listen to Group1's OnEntry event. Add a Condition to this event with this code:
```
data.port == 2
```
Add a label to this event called Combiner with this value:
```
current
```
On the Data Recording tab, set the Row Creation Mode to Unique Row Values, and choose Combiner
Add the Combiner column. It should update when the row is added, and have the id of the row value.
Add the Input column. It should update with events. For the value, choose the pickoption for incrementing the current value. Make sure to connect this event to the Input column.

combiner-input-port-statistic-collector-modified.fsm (22.8 KiB)

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Adarsh T commented · Jan 17, 2020 at 01:24 PM

Hello Jordan,

Thank you for the solution

I need to collect the results as per attached excel file.

Is it possible to collect by using statistics collector or global tables by using custom code.

Can you please share us the example file or by the updating the same file.

book1.xlsx

0 ·

book1.xlsx (8.6 KiB)

question