topic Re: Help Needed with Dynamic Excel Updates for Source Arrival Schedule in FlexSim Forum

Help Needed with Dynamic Excel Updates for Source Arrival Schedule

Stefano12 — Sat, 15 Jun 2024 17:30:23 GMT

[ FlexSim 24.1.0 ]

Hi All!

Sorry for the long text, I think this should be fairly easy for the experienced.

I'm trying to build a simple digital twin experiment. My goal is to add new items to a queue every time I add a new row to an Excel sheet. Since this is a digital twin experiment, the row will be added while the simulation is running.

Here's what I have so far:

I managed to connect an Excel sheet to the "arrival schedule" table of a source, and that part is working fine.

2, However, when I update the Excel sheet with more rows (considering I'm adding future arrival times that the model hasn't reached yet), the "arrival schedule" table is updated, but the model doesn't reflect these changes unless I reset it. This defeats the purpose of having "live" updates.

My questions:

How can I force the source to "recheck" the Excel table for updates without resetting the simulation? The table updates, but the Source isn't creating new items after the simulation starts running.
How can I convert dates from Excel to FlexSim time format? Ideally, I would like to use arrival times in mm/dd/yyyy hh:mm format instead of seconds. Any tips on handling this conversion would be greatly appreciated. I saw this post, but couldn't really figure out where to put that line of code.
How can I use scheduled arrivals in a process flow? I attempted a global table lookup based on the Excel sheet, but it didn't work. If someone could explain how to fill out the table for scheduled arrivals in process flow, that would be very helpful.

Thanks in advance for any guidance or solutions you can provide!

schedule-source.xlsx

process-flow-scheduled-source1.fsm

Re: Help Needed with Dynamic Excel Updates for Source Arrival Schedule

joerg_vogel_HsH — Mon, 17 Jun 2024 07:23:58 GMT

https://docs.flexsim.com/en/24.1/Reference/CodingInFlexSim/FlexScriptAPIReference/Data/DateTime.html#Method-fromExcelTime

please consider to use a different arrival mode for a source. If you use instead an interarrival time you can read a next time arrival difference from an excel file while a model runs. Please be aware of that you must already know the next time interval when previous item is created. If you cannot realize this condition then you can only create an item by code directly in your model without a source.

Re: Help Needed with Dynamic Excel Updates for Source Arrival Schedule

Stefano12 — Tue, 18 Jun 2024 00:26:02 GMT

Thanks for the reply! Sorry, what do you mean by creating an item by code directly? Is it using the Flexsim command console?

Re: Help Needed with Dynamic Excel Updates for Source Arrival Schedule

joerg_vogel_HsH — Tue, 18 Jun 2024 06:29:03 GMT

You get Items by code or process flow activity.

process flow: create object

command: treenode.copy method already existing item from Flowitem bin.

Re: Help Needed with Dynamic Excel Updates for Source Arrival Schedule

Jeanette_Fullmer — Fri, 21 Jun 2024 13:52:30 GMT

Hi @Stefano, was Joerg Vogel's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.