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

Question

question

Alex Gf asked Apr 21, '17 Trex commented Oct 17, '17

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

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.

Software Version:

FlexSim 17.0.4

flowitem pull from list pull schedule queue strategy

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2017-04-21T18:33:37Z

Kari Payton answered Apr 21, '17 Trex commented Oct 17, '17

@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.

capturehelp.png (50.3 KiB)

capturehelp2.png (7.9 KiB)

· 3

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Alex Gf commented · May 09, 2017 at 01:14 PM

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

0 ·

Trex commented · Oct 17, 2017 at 10:01 AM

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

0 ·

trial.fsm (24.2 KiB)

Kari Payton Trex commented · Oct 17, 2017 at 02:28 PM

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

1 ·

9100-trial-1.fsm (28.9 KiB)

question