Using Excel data to parameter a source

Question

question

Cyrine S asked Jun 27, '18 Allister Wilson answered Jul 2, '18

Using Excel data to parameter a source

I'm trying to create a source with 3 types of products (different color for each, column 1 in Table). I want to use a different inter-arrival-time each time (column 2 ) and each product should be sent to a different conveyor for output (column 3 in table).

1-Do you have a simple Flexscript example on how to use Excel data to parameter a source please ?

2-When importing the data i remarked that there is some '0' in the GlobalTable instead of the values in my excel file. Do you know how i can fix this please.

Thank you in advance for your answers.

Software Version:

FlexSim 18.1.1

flexscript source excel import treenode input

flec.png (41.2 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.

tannerp commented · Jun 27, 2018 at 02:09 PM

Are the 0 values in the FlexSim table supposed to be something else in your Excel file? In other words, the Excel table does not have the 0s shown in your picture and you'd like it to import other values instead of the 0s?

Also, in order to use the labels as a parameter on the items, you should think of them as a label value that needs to be assigned. Then you pull them from the list. For more info on this, you can look in the User Manual under the Excel Interface section.

0 ·

excel-user-manual.png (63.0 KiB)

Answer 1 · 2018-07-02T10:33:02Z

Allister Wilson answered Jul 2, '18

This question was handled by email and can be closed.

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.

question