Control Point Statistics - Travel Time using Tracked Variable

Question

question

Amit Kulkarni asked Feb 12 2021 at 12:15 AM Amit Kulkarni commented Feb 13 2021 at 6:31 PM

Control Point Statistics - Travel Time using Tracked Variable

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?

AGV_Statistics_Collector_Travel_Time.fsm

Software Version:

FlexSim 21.0.2

statistics collector flexsim 21.0.2 control points tracked variable travel time

agv-statistics-collector-travel-time.fsm (127.7 KiB)

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2021-02-13T15:28:34Z

tannerp answered Feb 13 2021 at 3:28 PM Amit Kulkarni commented Feb 13 2021 at 6:31 PM

@Amit Kulkarni,

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.

agv-statistics-collector-travel-time_1.fsm

1613229914429.png (74.7 KiB)

1613230044914.png (65.3 KiB)

agv-statistics-collector-travel-time-1.fsm (130.5 KiB)

· 3

Amit Kulkarni commented · Feb 13 2021 at 5:13 PM

@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!

0 ·

tannerp Amit Kulkarni commented · Feb 13 2021 at 6:10 PM

@Amit Kulkarni

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.

agv-statistics-collector-travel-time_2.fsm

0 ·

agv-statistics-collector-travel-time-2.fsm (137.0 KiB)

Amit Kulkarni tannerp commented · Feb 13 2021 at 6:31 PM

Great! Many thanks!

0 ·

question