copy globaltable to proces flow: schedule source using flexscript

Question

question

David VC asked Dec 19, '18 David VC commented Dec 19, '18

copy globaltable to proces flow: schedule source using flexscript

Hi

I want to do the same thing as the below but now for a schedule source in process flow. I was thinking about importing my excel sheet as a globaltable and then copy this to my schedule source. Can this be done or is there a better way? I don't want to copy paste manually as the purpose is to use my model in the experimenter and thus it should only rely on the given globalvariables and the copying should also be done in the code.

excelopen("FileName.xlsx");//ie "C:/Users/user/Documents/Book1.xlsx"
excelsetsheet("Sheet"+numtostring(Sheet));//Global Variable named Sheet
excelimporttable("GlobalTable1",num_startRow,num_startCol,num_Rows,num_Cols);
excelclose(0);

best regards

David

Software Version:

FlexSim 18.2.2

excel import copy globaltable process flow schedule source

Answer 1 · 2018-12-19T17:40:18Z

Joshua S answered Dec 19, '18 David VC commented Dec 19, '18

Here's a way you can integrate your changing scenarios with your scheduled source. This creates a token for every row in your table, then assigns all the labels that would be found in your table to the token, and even sets a delay for the time you would normally set for arrival time. process-flow-scheduled-source.fsm

process-flow-scheduled-source.fsm (23.7 KiB)

· 1

David VC commented · Dec 19, 2018 at 06:06 PM

Thanks a lot!

0 ·

question