question

Victor Perazzoli avatar image
0 Likes"
Victor Perazzoli asked Phil BoBo commented

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

question.pdf current-process.fsm

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.

FlexSim 16.2.1
spreadsheetreading
question.pdf (184.7 KiB)
current-process.fsm (44.1 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

Sam Stubbs avatar image
0 Likes"
Sam Stubbs answered Phil BoBo commented

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
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Ben Wilson avatar image Ben Wilson ♦♦ commented ·

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 Like 1 ·
2016-11-01-13-06-16-excel-interface.png (14.1 KiB)
Victor Perazzoli avatar image Victor Perazzoli commented ·

Thank you, that works!

0 Likes 0 ·