topic Satisfy demand according to time, type in FlexSim Forum

Satisfy demand according to time, type

nelson_g2 — Mon, 22 Jul 2019 15:10:36 GMT

help.fsm hel.xlsxHello I need help with the following model, I need to extract the specific units and specific amounts in the excel to the hangars (queues) of the system at the time specified by the excel, how can I do this? thanks for your attention

Re: Satisfy demand according to time, type

sam_stubbsYXX86 — Mon, 22 Jul 2019 16:26:04 GMT

Just to clarify, you want the specific Queue to pull the item from the rack at the specified time and quantity?

If this is the case, then first, rather than use ports from the rack, I would push all of the items on the rack to a list.

Next I would set up a Process Flow with a Scheduled Source.

From there, I would import the table using the Excel Importer. (Either import it to a Global table within your model, or arrange the columns in your Excel File to match a scheduled source with Time / Name / Quantity as the columns, and import the table directly to the Scheduled Source.) This will cause the scheduled source to produce the quantity of tokens at the specified time, and you can include the queue they are supposed to go to as a label.

Then just have each of the tokens pull the appropriate item from the list, and move it to the appropriate queue, with a Move Object activity.

Is this the functionality you're looking for in your model?

Re: Satisfy demand according to time, type

nelson_g2 — Tue, 23 Jul 2019 00:05:37 GMT

yes, this is the functionality, can you do example?

Re: Satisfy demand according to time, type

joseph_g3 — Fri, 26 Jul 2019 16:35:24 GMT

@nelson G2

Here's an example you can look at: moveitemsbytable.fsm

I eliminated the sink in this example so that you can see the items arriving at all the hangars.