Change global table values depending on an average value

Question

question

stefano L asked Nov 6, '19 tannerp commented Nov 13, '19

Change global table values depending on an average value

Hi,

How can I store the Capacity label value of items leaving the warehouse to be able to calculate the average? Afterwards I need to see this average and, if it is too high (close to 90%) or too low (close to 60%), change all the values of the global table ValueTable setting them all to 100 or 50 respectively. The Capacity label of items in the warehouse are updated every 10 seconds through the custom code "Capacity Update" in the process flow.

Model attached here:

mean-model.fsm

Thanks.

Software Version:

FlexSim 19.0.0

Software Version:

FlexSim 19.0.3

global table labels warehouse items average

mean-model.fsm (52.4 KiB)

Answer 1 · 2019-11-12T22:04:27Z

tannerp answered Nov 12, '19 tannerp commented Nov 13, '19

Hi @stefano L,

I'm not sure if this is what you're looking for, but I added a couple lines of code in your Capacity Update activity that check if the capacity is below 60 or above 90. If so, they will set all the values in the table to 50 or 100.

mean-model-updated.fsm

update-table-capacity.png (58.3 KiB)

mean-model-updated.fsm (53.1 KiB)

· 2

stefano L commented · Nov 13, 2019 at 10:03 PM

Thanks @tanner.p but actually, I was looking for a way to store the capacity values of the items Exiting the warehouse and then average these values. The result of the average allows to decide whether to modify the global table or not.

0 ·

tannerp stefano L commented · Nov 13, 2019 at 10:37 PM

That makes sense. I'm not sure how frequently you'll be evaluating the average capacity, but you should be able to do the same thing. The only difference would be that instead of updating values in a Global Table immediately, you can write the capacity values to Global Variables or perhaps another table and then average those based on a trigger whenever you're ready to evaluate.

1 ·

question