How to read orders from a spreadsheet to simulate the behaviors of different order mixes in the manufacturing process.

Question

question

Victor Perazzoli asked Nov 1, '16 Phil BoBo commented Nov 3, '16

How to read orders from a spreadsheet to simulate the behaviors of different order mixes in the manufacturing process.

I am currently creating 300 items by using uniform distributions to assign orders numbers and sizes to each item. I need to use the spreadsheet as input source

Attached is an illustration of what I am trying to do. Each item belongs to an order and each item has a different size for there are different quantities or product

Any insight is appreciated.

Software Version:

FlexSim 16.2.1

spreadsheet reading

question.pdf (184.7 KiB)

current-process.fsm (44.1 KiB)

Answer 1 · 2016-11-01T16:36:14Z

Sam Stubbs answered Nov 1, '16 Phil BoBo commented Nov 3, '16

You could just have the source be a scheduled source (with the scheduled time being time 0). Then you could just copy the values to the scheduled table.

I've attached your model below:

3443-current-process.fsm

schedulesource.png (31.5 KiB)

3443-current-process.fsm (44.2 KiB)

· 2

Ben Wilson ♦♦ commented · Nov 01, 2016 at 07:03 PM

Instead of copy/pasting your data from Excel to FlexSim, you could also set up an Excel import to import your data directly to the Source's schedule:

1 ·

2016-11-01-13-06-16-excel-interface.png (14.1 KiB)

Victor Perazzoli commented · Nov 03, 2016 at 02:13 PM

Thank you, that works!

0 ·

question

How to read orders from a spreadsheet to simulate the behaviors of different order mixes in the manufacturing process.

1 Answer

Write an Answer

Things to know…

question details