Is it possible to import unbounded parameters ?

Question

question

Leah R asked Apr 30, '21 Leah R commented Apr 30, '21

Hi everyone !

I'm trying to import parameters into my model from an Excel file. I have both "hh:mm:ss" format and number format.

After each importation, I have a message similar to this :

I have tried to modify the bound of the parameter cell but at every new importation it is reset to a maximum of 10.

Is it possible to change that ?

Also, is it possible to have a "hh:mm:ss" parameter in flexsim ?

Thank you in advance !

Leah

Software Version:

FlexSim 21.1.0

Answer 1 · 2021-04-30T10:40:26Z

Clair A answered Apr 30, '21 Leah R commented Apr 30, '21

Hi Leah,

As you noticed, model parameters are strict: you can configure model parameters to only accept certain values (see https://docs.flexsim.com/en/21.1/ModelLogic/ModelParameters/ for more information).

Since you don't want your parameters to be strict, I would recommend to simply use a Global Table instead:

About importing date & time, it's easier to convert in Excel the date & time into the arrival time in model units.

For example, let's assume you want to import your schedule into a Date Time Source:

If you toggle the Advanced button, this is actually the way your data should look if you want to import it from Excel:

Actually if I were in this situation, I would rather build my Excel file this way:

With the Start Time and Duration columns being the result of a calculation from the Start (DD:)HH:MM:SS and End (DD:)HH:MM:SS columns.

Hope this helps.

· 1

Leah R commented · Apr 30, 2021 at 03:29 PM

Thank you, that is very insightful ! I'm going to apply the changes right now :)

0 ·