Hello

I’d like the Mobile Robot to execute transportation tasks according to an external Excel schedule that contains a timestamp, start point, and destination. (see below table)

image629×120 2.49 KB

So far, I know there might be two possible approaches but not sure if they are practical:

1. Feeder Table (CSV)
   Convert the Excel schedule into a feeder CSV.
   Each start–destination pair requires a separate product type and process flow, which results in roughly2,000 product/flow setupsin our case—making this approach impractical.
2. Excel Reader + Product Property Routing
   Use the Excel Reader to load routing data, write these values into Product Properties, and let downstream processes route the product using Product Property Filters.
   This works for routing, but it seemscannot trigger product release based on the timestampsin the Excel file.

I’d like to ask your help/suggestion on above approaches, or if there are any other solutions, thanks

Hi, for the second approach, with the Excel Reader, you can use “SimTime()” to get the actual time and wait until it’s time to create a new product.

One solution would be to use an If-loop in which you check ifTiming <= SimTime()". If yes you can create the product, if not wait 1s for example.

The other solution would be to add a Real-Property to the process to calculate the remaining time before you need to create a new product –>Delay = Timing - SimTime(). And then use a Delay in which you use this property as Expression.

grafik1370×1252 201 KB

You can also try this AddOn, which allows you to read an Excel file directly in a process :VariablesCache + TransportPatternIn helper

Hello Tilma

Could you please share this layout? not sure what it needs NextProcess (in Product) and SendSignal (in Process Node).

Hello,

I didn’t save the layout…

The product propertyNextProcesswas just a test to transport the product to the correct Machine process using the property filters in TransportIn (NextProcess = Start at the begining, and after having been processed once, NextProcess = Destination). It might also be possible to use theGetFlowStep+SetNextFlowStepstatements to adjust the flow for each product.

The statementSendSignalis used with the ExcelReader to read the next row of the table by triggering the signal “TriggerRead”.

Hello Tilma

As I tried to duplicate your layout, it shows this error in the filter. Do you know why it is?

image958×514 75.2 KB

Excel Read Test.xlsx(8.7 KB)

Excel Reader Test.vcmx(275.9 KB)

The propertyStartis a string, so inComparisonValueyou need to write“A"not justA

Thank you, Tilma, now it works.

Hello Tilma

I would also like to record the real robot pick time and the product arrival time and export to an excel, so that I can see what’s the delay. Do you know how to do? thanks.