topic Re: How i can make my Queue pull Items, taking as a reference and excel schedule? in FlexSim Forum

How i can make my Queue pull Items, taking as a reference and excel schedule?

alex_ch — Fri, 21 Apr 2017 16:42:13 GMT

[ FlexSim 17.0.4 ]

I want that one of the queue in my project, get items from other queues, by taking as reference the schedule I have in excel...

The shedule look like this..

ID	MODEL
1	BLUE
2	YELLOW
3	YELLOW
4	RED
5	BLUE

So, before the main queue, I have another 3 queue's where they have an stock of items of each model.

QUEUE 1 = BLUE

QUEUE 2 = YELLOW

QUEUE 3 = RED

QUEUE 4 = SCHEDULE PULL ITEM'S (EXCEL REFERENCE)

ID	MODEL	GET FROM
1	BLUE	QUEUE 1
2	YELLOW	QUEUE 2
3	YELLOW	QUEUE 2
4	RED	QUEUE 3
5	BLUE	QUEUE1

I want this using excel because its an schedule of 504 items, so it's more easy to work with (I think) (I already know how to charge excel sheets to flexsim)

So it's posiible to do something like this? }

Thanks in advice.

Re: How i can make my Queue pull Items, taking as a reference and excel schedule?

kari_payton — Fri, 21 Apr 2017 18:33:37 GMT

@Alex Gf If you are familiar with process flow, you can setup a flow for the main queue to pull specific items from a list.

1- Create a label on the source that reads tableRow = 1 & tableColumn = 2. This will read the cell from the table to reference what queue to pull from.

2- Create a label to reference the number from the table

3- Pull that object from the list using the label you created as the partitionID (i.e. the reference to the queue).

4- Increment the tableRow value by 1 and loop.

This will create a loop through all of the rows on the table until the label "tableRow" > the number of rows int he table.

Also in order for this to work, you need to push the items to the list from the queue and push items with partitionID = to their queue number. I.E. Blue items come from Queue 1 so partitionID=1.

Sketch of what the process flow could look like:

It would help too if you post your model or an example.

Re: How i can make my Queue pull Items, taking as a reference and excel schedule?

alex_ch — Tue, 09 May 2017 13:14:39 GMT

Hi Kari, I just saw his answer and I think this could fix the problem, can you share with me the model to have a better understand of what you said. Thankss

Re: How i can make my Queue pull Items, taking as a reference and excel schedule?

tanmay_varshney — Tue, 17 Oct 2017 10:01:04 GMT

trial.fsm @Kari Payton can you help me how to increment the table rows in a process flow,
I have to similarly work in my model , I have 4 staging queue which will pull items with ref of table in sequence. No order has to be repeated, it has to be taken up queue as per its empty availability

Re: How i can make my Queue pull Items, taking as a reference and excel schedule?

kari_payton — Tue, 17 Oct 2017 14:28:14 GMT

9100-trial-1.fsm Notes in model process flow. @Trex