[ FlexSim 21.1.0 ]
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
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.
