How can Processor import from excel with diff. processing time

Question

question

Hassan D asked Apr 30, '18 Hassan D commented May 2, '18

How can Processor import from excel with diff. processing time

I have been trying this for quite sometime before I can ask question here, but i cannot. I have a Source which have 5 parts (from global table), it sends parts to Processor in which i need to import data from excel (processing time) based on part name. Because different parts have different times. I have imported the excel file to global table but which option to use in the Processor ?

Software Version:

FlexSim 17.1.6

excel import processortime

1.jpg (25.3 KiB)

2.jpg (40.0 KiB)

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 · 2018-04-30T20:23:16Z

Michael Machado answered Apr 30, '18 Hassan D commented May 2, '18

Attached you can see a model as an example that solves what you need using the first option that I tod you. Also, you could consider using another picklist 'Values By Case' as you can see in the image below based on the type of the product (item.Type). modeltest.fsm

source-v.png (36.1 KiB)

modeltest.fsm (22.5 KiB)

· 1

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.

Hassan D commented · May 02, 2018 at 07:39 AM

Thank you very much for your quick response.

0 ·

Answer 2 · 2018-04-30T13:57:34Z

Michael Machado answered Apr 30, '18 Hassan D commented Apr 30, '18

I would include type and quantity inside Source, using Arrival Sequence (for that you can import direct from Excel as you can see below). You can mark 'Repeat Schedule/Sequence' if that is the logic of the process that you are modeling.

For the process time, I would choose the picklist 'By GlobalTable Lookup' as you can see the image below. Different parts with respective process time. In the row space keep 'item.Type' and in the column you can use label to read each column based on the type of the item (your product).

source1.png (24.1 KiB)

byglobaltablelookup.png (30.7 KiB)

· 1

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.

Hassan D commented · Apr 30, 2018 at 02:16 PM

Thank you very much is almost everything i require to know. Just one confusion is that can you attach another image of processor properties with everything filled based on my data ?

0 ·

3.jpg (129.7 KiB)

question