question

Alejandro M16 avatar image
0 Likes"
Alejandro M16 asked Eric M commented

How to change imported excel file by date?

Hello,

In my source, on Mondays I am working with Import Line1, but on Tuesdays I must work with 
Import Line 2,because the configurations of lines 1 and 2 are different. 

How can I make this change?


Thanks for your attention
FlexSim 21.1.1
flexsim 21.1.1any other version
date-excel.png (33.9 KiB)
· 1
5 |100000

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

Eric M avatar image Eric M commented ·

Hi @Alejandro M16,

We haven't heard back from you. Were you able to solve your problem? If so, please add and accept an answer to let others know the solution. Or please respond to the previous comment so that we can continue to help you.

If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.

0 Likes 0 ·

1 Answer

Bruno Ricardo BM avatar image
0 Likes"
Bruno Ricardo BM answered Joerg Vogel commented

Hello Alejadron,

You could use an Arrival Schedule and put the ArrivalTime per day, but this have to be in seconds or the model Time Units that you select at the beggening of the model.

I will be you and example:

The first row is for the first day of the simulation (Monday), so I put 0 seconds at Arrivaltime.

The second day (Tuesday) I put 86400 seconds because is the equivalent of a day in seconds.

The third day (Wednesday) I put 172,800 seconds that is the equivalent for 2 days.

The only problem is that you have to have the same format in Excel to be imported.

Tell me if this works for you.

Greetings.
Bruno.


1622059588362.png (28.0 KiB)
1622059646488.png (253.1 KiB)
· 2
5 |100000

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

Alejandro M16 avatar image Alejandro M16 commented ·
That option doesn't help me,
because I'm using an Arrival Sequence on my arrivals.
Greetings,
Alejandro.
0 Likes 0 ·
Joerg Vogel avatar image Joerg Vogel Alejandro M16 commented ·

@Alejandro M16, I suggest you add a simplified model and an excel file to your question. That way we don’t have to guess what you did. Sometimes pictures aren’t enough to express, what you need. Many Thanks!

What is it, that you comment in a script formatted section.

0 Likes 0 ·