Date Time Source Excel Import

Question

question

Idoia A asked Mar 7, '19 Clair A commented Oct 12, '20

Date Time Source Excel Import

Hello,

I am trying to use the Date Time Source importing the schedule from Excel. I am using a weekly repetition, the problem is that every time I import the Excel file, the table changes: Monday and Tuesday are replaced by Quantity and Name, so the source doesn't work. This happens in the advanced table as well, it doesn't look as it should.

It's the first time I have tried to import an Excel file so I may have done something wrong while importing, I would appreciate any help. I attach pictures.

Thank you in advance,

Idoia

Software Version:

FlexSim 19.0.2

importing data from excel file to source

datetimesourcetable.png (34.6 KiB)

datetimesourceadvanced.png (32.4 KiB)

excelschedule.png (27.2 KiB)

· 4

Joshua S commented · Mar 21, 2019 at 10:16 PM

@Idoia A

Add a new arrival source, go in to edit it, change the Quantity to maanantai, and Name to tiistai, then click the excel import and do the whole excel import routine. See if this works or if you still get issues showing up.

This method seemed to work, but still looking into why it doesn't work normally.

1 ·

Idoia A Joshua S commented · Mar 22, 2019 at 07:44 AM

It seems to work with your method, thank you. Now I have a question about updating the values of the table from the excel file. Should I import the excel table every time the model is reset, by using OnModelReset trigger? If so, how should I do it? Or is there another way to do it? Let me know if I should post another question with this matter.

Thanks a lot.

0 ·

tannerp commented · Mar 08, 2019 at 10:29 PM

@Idoia A, Is there any chance you could upload the files you're working with so we can attempt to import them? If they contain proprietary information, you may upload them in a private question so that only a few of us at FlexSim U.S. will see them.

0 ·

Idoia A tannerp commented · Mar 12, 2019 at 09:02 AM

@Tanner Poulton, Hello.

Sorry for the late answer, I attach a simplified version of the model I'm working on, as well as the Excel file. The Date Time Source is being used in the Task Executer Flow ("Forklift2").

Thank you,

Idoia

datetimesource.zip

0 ·

datetimesource.zip (306.7 KiB)

Answer 1 · 2019-03-22T19:38:21Z

Joshua S answered Mar 22, '19 Clair A commented Oct 12, '20

@Idoia A

I talked with one of the developers and he said the UI for that table can be misleading. There are 2 buttons in the top right of the window, "Table" and "Advanced". The Table option is a basic outline of the week, but the Advanced option shows a more complete and real representation of how the schedule is working.

The first and second columns with be the start and end times, or Start Time and duration, but the next 2 columns need to be quantity for how many tokens will be created and the second needs to be name for the name of the tokens being created. In the normal view of the UI, anything else after that are labels. So you will need the format of the table you are importing to look more like this

which will account for your whole week in second.

Then you can toggle this button to have the model import the excel file every time the excel file changes on reset.

Sorry for the confusion.

pic1.png (64.6 KiB)

pic2.png (28.4 KiB)

· 2

Idoia A commented · Mar 25, 2019 at 01:40 PM

Thank you for clarifying, the tables look as they should now.

0 ·

Clair A commented · Oct 12, 2020 at 10:32 AM

Thanks @Joshua S. One of our users did a similar mistake, the data in his Excel file had 4 columns exactly like the table shown by default in the arrivals window:

Start (DD:)HH:MM:SS
End (DD:)HH:MM:SS
Quantity
Name

So we corrected his Excel file to have instead:

Start Time (in model units)
Duration (in model units)
Quantity
Name

I agree that the UI for the table can be misleading. I notify @Jordan Johnson if he has ideas of improvement.

0 ·

question