question

Anirudha Keragodu Suresh avatar image
0 Likes"
Anirudha Keragodu Suresh asked Ralf Gruber answered

How to input data to Source using excel, data is spread across various dates.

model.zip

Dear Community members,

I am trying to calculate machine occupancy rate spread across a month.

The readings are taken in a specific time interval everyday. I tried to use "Arrival Schedule" in Arrival Style and then using excel option, imported the data. But when Arrival Date is in the first column the model doesn't run.

It would be of great help to know the other procedures to update the data according to date.

Thanks

FlexSim 17.0.2
importing data from excel file to source
model.zip (43.6 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
Ralf Gruber avatar image
1 Like"
Ralf Gruber answered Ralf Gruber edited

Ani,

the Arrival table format of the Source requires the Arrival time being one value based upon model time units. In the model attached I have used a ProcessFlow to get the timing right. Be aware, that I adjusted the model date and time format to the format in the GlobalTable you provided. The calculation of the arrival time is done in the "Calculate next Arrival" activity.

I just noticed that you posted your question in the FlexSim HC section. I moved it into the FlexSim section.

Good Luck

Ralf

datetimearrival-rg.fsm


datetimearrival-rg.fsm (22.8 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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