How to put arrival time in date and time format in source in Arrival schdeule

Question

question

Raashid Mohammed asked Aug 25 2016 at 6:27 PM Logan Gold commented Dec 15 2017 at 6:01 PM

How to put arrival time in date and time format in source in Arrival schdeule

I have two questions

1. how to put arrival time in SOURCE arrival schedule in date and time format

for example something like this 8/2/2016 4:00:00 PM instead of seconds

2. how to change to simulation start date and time

currently my model runs with model start time

8:00:00 AM Thu 25 Aug 2016

how can change that before simulation run

please help

thanks

Raashid

Software Version:

Choose One

date

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2016-08-25T21:15:51Z

Logan Gold answered Aug 25 2016 at 9:15 PM Logan Gold commented Dec 15 2017 at 6:01 PM

1.) The ArrivalTime column of a Source's Arrival Schedule always needs a value that is a number. However, you can use the convert() command to convert a date/time format into model time. So you could have a Global Table with all the date/time information you want to convert to be used in a Source's Arrival Schedule. Then, use something like the Source's OnReset trigger to convert the values in the Global Table to be used in the Arrival Schedule. Using 8:00:00 AM Thu 25 Aug 2016 as a model's start time, this command will return 3600:

convert("9:00:00 AM Thu 25 Aug 2016", DATETIME_STR, MODEL_TIME);

2.) Go to Edit, then Model Settings. The Model Settings window has two fields for Model Start Time - the time and date. You can make changes in either field to change the Model Start Time.

· 4

Raashid Mohammed commented · Aug 25 2016 at 9:26 PM

Thank you

How do I connect global table to source arrival schedule ?

I know how to import directly from excel but don't know how to import from global table to source

For the model start time instead changing the time by going to the settings. is there a way I can lookup value and change the model start time on Model reset ?

0 ·

Logan Gold ♦♦ Raashid Mohammed commented · Aug 26 2016 at 10:13 PM

Here is an example model of how you can connect a Global Table to a Sourcen's arrival schedule:

sourceschedule-datetimeformat-example-v16-1-2.fsm

GlobalTable1 is set up with the time/date format I want to use in the Source. To use the convert() command, the format needs to be exactly what you see here.

In the Source's OnReset trigger, I used code to reference those times/dates in the Global Table, convert them into model time using the convert() command, then copy that number into the Source's Arrivals Table. I was able to use a command called getvarnode() to get a reference to the arrival table - it is a variable in the Source's tree called schedule. Since this variable is a table itself, I used the settablenum() command to make the changes.

To change the Model Start Time with code in the OnModelReset trigger, you'd need to do something like:

treenode startNode = node("/Tools/ModelUnits/ModelDateTime/start", model());
double startTime = convert("8:00:00 AM Fri 26 Aug 2016", DATETIME_STR, FS_DATETIME);
set(startNode, startTime);
applicationcommand("convertunixtime", startNode, startTime);

Where the first parameter in the convert() command (the string with the time and date) is the value that you want to change the model's start time to. That string is getting converted into a format called FlexSim datetime, which is a number that is needed in the application command called convertunixtime. So if you are starting with a different format, it needs to be converted into the FlexSim datetime format before being used in the convertunixtime application command.

1 ·

sourceschedule-datetimeformat-example-v16-1-2.fsm (82.0 KiB)

christophe C2 Logan Gold ♦♦ commented · Dec 05 2017 at 2:46 PM

@Logan Gold

I have the same problem.

I want to use a one year excel schedule by date, representing my Working order. Each working order includes a quantity of pieces to be produce.

How can I add some quantity in the exemple you have linked to your answer ?

For exemple,

I would like to have 25 pieces out of my source on the 01/08/2017 at 07:00 AM ?

0 ·

Show more comments

question