Operation between results

Question

question

Alejandro C8 asked Jun 29, '20 Alejandro C8 commented Jul 7, '20

Operation between results

Hello, I have a simulation, with two owners on the one hand the number of pieces produced and on the other the number of good and bad pieces, I want to calculate the ratio of good pieces to the total, but I can not find how to operate between them

Thanks f

Software Version:

FlexSim 19.2.4

flexsim 19.2.4 multiple operations

relationsquality.jpg (33.6 KiB)

· 1

tannerp commented · Jul 06, 2020 at 04:51 PM

Hi @Alejandro C8, was my answer helpful? If so, please click the red "Accept" button on the answer. Otherwise, feel free to comment back with additional information (and your model, if you can), so we can help you. Thanks!

0 ·

Answer 1 · 2020-06-29T17:25:54Z

tannerp answered Jun 29, '20 Alejandro C8 commented Jul 7, '20

@Alejandro C8,

I didn't see a model attached to your question, so I went ahead and created one to demonstrate a possible solution. If you are using a Statistics Collector to gather quality and throughput data, making the calculations you described is relatively easy. To do this, we will use a Calculated Table.

In your model, I assume that you're tracking good and bad quality in a Statistics Collector, so the only things we need are a count of the total items and a count of the good quality items. Then we can create the ratio you specified. For the first metric, we can aggregate the count of the items.

For the second metric, we can aggregate the sum of the quality (based on good quality = 1; bad quality = 0).

Then we use these newly created columns to calculate the ratio.

So our raw data and results table look like this:

You can always adjust this method to meet the needs of your model. If you have questions about the Calculated Table or how I set things up here, feel free to reach out.

ratio good quality example_1.fsm

count-of-items.png (6.1 KiB)

sum-quality.png (5.3 KiB)

ratio-good.png (6.3 KiB)

calc-table-and-stats-collector.png (9.2 KiB)

ratio-good-quality-example-1.fsm (29.7 KiB)

· 1