Assign Aircraft leaving the gate according to our set date and time in table

[River]

We are simulating the aircraft will leaving the gate according to our real data history.

How can i import the table in simio and let the aircraft leave the gate accouring to the time and date?

Also some gate will have more than one different time and date that aircraft will departure the gate. How can i do it as well?

 

[ViniciusF]

One way to do it is to have two tables. One with the gates (object property) to be a column key, and another with foreign key property and the departure times. 

Below follows an example.

Hope it helps.

Arrival_Gates.spfx

[River]

Thank you

We follow your method by importing the about 1000 data from excel using Key and Foreign Key. But the simulation is wrong that the all aircraft depart their gate once in different time but not individually according to date and time that we import. 

Maybe it is a large file to you that over 200 item for u to run, but can you help me find what's wrong with it?

20230315 FullGate version 4.spfx

[ViniciusF]

First of all, your column of gates should be of the type Object Property, not String.

After you change its type, you need to set Auto-Set Table Row Reference to True. 

It should work now.

[River]

We used your method before and it WORK!!

 

But we keep changing and modifying our simulation. Today we imported a new data again but still have the same issue... we followed your method already... 

 

20230401 FullGate version 13.spfx Departure.xlsx Gate.xlsx

[ViniciusF]

Well, there are two problems in your model:

First, there are many gates that are not following the data table.

Second: every gate should be on the Gate table, regardless if they will have flights or not. If not, they will create entities on every single arrival of the departure table. You have many gates that are not included on Gate table.

[River]

Many thanks! I just imported less data from the gate table, but we have a lot of gates that did not have flight, how can we stop the creation and generation on the gate that it don't have flight?

[ViniciusF]

Import ALL gates to the gate data table, regardless if they have flights or not. Make sure all Gate objects are following the departure arrivals. Done.

If you have any questions, pm me.