Statistics Collector - Increment value in the same row

Question

question

Alice Fernandes asked Sep 9, '21 Alice Fernandes commented Dec 14, '21

Statistics Collector - Increment value in the same row

Good Morning! I have a question about consolidating data in a table using statistics collector.

A short description of the model and it's logics:

The boxes are created with the labels:

Material: Gold, Silver, Copper
Destination, 1, 2, 3 or 4
Weight: duniform(1,10,getstream(current))

Depending on which system each box pass through it'll get a label System: S1, S2 or S3.

At the event "on entry" of each queue destination, I would like to collect the Weight from each item, sorted by the system's and material's labels.

I attached an exemple of the type of table I would like to have at the end (red box). The lines are the destination of the item and every time a new box entry on a destination queue, the table will add the value of it's weight on the proper column System+Material.

My question is: is there a way for doing this in statistics collector? Or I'll necessary have to use the calculated tables?

The model is attached.

final-table-results.PNG

question_statistics-collector.fsm

Thanks in advance!

Best Regards

Software Version:

FlexSim 21.2.2

statistics collector calculated table flexsim 21.2.2

final-table-results.png (7.7 KiB)

question-statistics-collector.fsm (68.2 KiB)

Answer 1 · 2021-09-13T16:49:26Z

Ryan Clark answered Sep 13, '21 Alice Fernandes commented Dec 14, '21

Hello @Alice Fernandes,

I believe I was able to address your problem and achieve your intended result. I was able to do it using just the Statistics Collector by accessing the entering item's labels and incrementing the value in the table by the weight of the entering object in the appropriate cell.

Here's my modified version of your model: question-statistics-collector-rc-v3.fsm

I hope this helps! Let us know if you have further questions!

question-statistics-collector-rc-v3.fsm (75.6 KiB)

· 2

Alice Fernandes commented · Sep 13, 2021 at 05:51 PM

Hi @Ryan Clark, it helps! Thank you very much!

0 ·

Ryan Clark Alice Fernandes commented · Sep 13, 2021 at 08:36 PM

No problem! Glad to help!

0 ·

question