How to retrieve value by percentage from global table

Question

question

Pinakin K asked May 17, '18 Matthew Gillespie edited May 17, '18

How to retrieve value by percentage from global table

I want to use this table for taking the values from the 2nd column and giving that value to a Process Flow label. And I also want to use these values in the source, like create by percentage, but i want to reference to global table

Software Version:

FlexSim 18.0.3

global table

percentage.png (3.0 KiB)

Answer 1 · 2018-05-17T15:12:55Z

Matthew Gillespie answered May 17, '18 Matthew Gillespie edited May 17, '18

You should use the dempirical command. You already have the global table set up correctly.

dempirical("GlobalTable1")

This command uses the first column for percentage values and the second column for return values.

You can also use the empirical and cempirical commands, which are similar but include some interpolation between values.

See the attached model.

valuebypercentdempirical.fsm

dempirical.png (9.7 KiB)

valuebypercentdempirical.fsm (22.7 KiB)

Answer 2 · 2018-05-17T14:51:28Z

Emily Hardy answered May 17, '18 Pinakin K commented May 17, '18

One way to do this is to create a trigger that sets the Item Type upon creation based on percentage, and then sample the global table.

You can also sample the Type if you would like. I've attached a sample model with the above logic that also changes the color depending on the Type. Hope this helps!

pinakin-support.fsm

2018-05-17-08-52-32-flexsim-2018.png (48.5 KiB)

pinakin-support.fsm (17.7 KiB)

· 1

Pinakin K commented · May 17, 2018 at 03:10 PM

thank you!

I want to use this in a process flow, i won't be using 3d environment for this. I want to create tokens using these percentages, and also would like to give the values of the second column to one of the process flow labels i have specified.

0 ·

question