I know how t calculate the travel time between two control points before hand. I want to use a tracked variable to record and plot the time an AGV takes to travel between any two control points along its travel path.
e.g. travel time between CP1 and CP3, or CP6 and CP8.
How do I accomplish this using a tracked variable of the type time series? I have not added any statistics collector to the model since I am not sure if this can be done. Ho do I go about doing this?
I think the best setup to capture this would be if the AGV was actually given a travel task to TRAVEL TO CP1 and then TRAVEL TO CP3. Unfortunately, the AGV currently travels THROUGH CP1 and THROUGH CP3, meaning you can't listen to the On Arrival triggers for the control points.
That said, you can listen for the AGVs to Acquire the control points AFTER CP1 and AFTER CP3 because they will only acquire these control points when they arrive at CP1 and CP3.
Hopefully this is making sense so far.
To capture the times at which the AGVs pass over CP1 and CP3, you can set up a statistics collector to listen to the On Allocation triggers for the control points described above. You can set up the stats collector to save the AGV, the time for CP1, and the time for CP3 as columns.
Note that the row value is always data.agv and the CP1Time and CP3Time columns are updated by events.
Once we have this raw data, you can now calculate the time that it takes for the AGVs to travel between CP1 and CP3 using a Calculated Table. I'm not sure whether you want average times or if you want to calculate each individual time. I went ahead and calculated individual times, but it's easy to aggregate these.
I'm not sure how you'd like this plotted. Did you have an example or something in mind? Maybe a histogram for all the travel times?
Here's an updated version of the model with the Stats Collector and Calculated Table. Feel free to comment back with any questions.
@tanner.p I understand it clearly thanks to your explanation. Based on your calculated table, I tried to add another table to aggregate individual times and plot them into a basic table chart. The aggregation operation was successful, although while plotting only one row was displayed, where the value was updated by the task executer. How do I display aggregated time for each task executer on separate rows?
Many thanks!
Great question. Did you add a column for the "AGV" value? If so, you can add "GROUP BY" logic so that it shows the aggregated value for each of the unique AGV column values.
Unfortunately, I couldn't find a way to achieve this using default pick-list options, but if you're familiar with SQL queries, it's just one line that you have to add. If you go to the "Calculations" tab of the calculated table and click "Enable Direct Editing" (you'll have to OK the message box), then you can type directly into the query. Just add the following:
GROUP BY [AGV]
Where [AGV] is the name of the AGV column in your model. I updated the example model from this post to include this as well for reference. Thanks.
12 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
