question

Dhuey C avatar image
0 Likes"
Dhuey C asked Matthew Gillespie edited

How to format data into data table

I am able to listen to desired input and output of two different processors. I am having trouble setting up the data table so the line represents each item and the columns are the simulation time for each listened events. I can get one or the other but not both the users manual was not clear.

FlexSim 17.2.5
statistics collector
· 4
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.

tannerp avatar image tannerp commented ·

So you'd like a processor to change its processing time based on what kind of item it is processing? You can access data from a table like shown below:

Maybe I misunderstood your question, though. Let us know more details about your model if you still need help with this.

0 Likes 0 ·
data-table-lookup.png (8.3 KiB)
Dhuey C avatar image Dhuey C commented ·

That is not what I am looking to do. I created a Statistics collector, and the created two events on the listening tab (Entry to processor 1 and exit of processor 3) on the Where I need help is the data recording tab. The output I want in the data table is col 1 simulation time enter processor 1, col 2 simulation time exit processor 2. The row represents each item. so there will be many rows one for each item. I will then calculate the time between the two listening points. Thanks

0 Likes 0 ·
Dhuey C avatar image Dhuey C commented ·

the output I am getting is the entry time in both columns for each part. so its almost there......

0 Likes 0 ·
Joshua S avatar image Joshua S Dhuey C commented ·

@Dhuey C

You can share what you have so far and we can take a look at it.

1 Like 1 ·

1 Answer

Raja Sekaran avatar image
2 Likes"
Raja Sekaran answered Dhuey C commented

@Dhuey C

I have attached the sample model. In that, The Object column is updated when a new row is added in the statistic collector and Start time and End time columns are updated by event dependency. This will helps to capture the two listening events in a single row. I hope this is what you are looking for.

Thanks

support-statisticscollectoreventdependency.fsm (Version 18.0.1)


screenshot-statisticscollector.png (25.9 KiB)
support-statisticscollectoreventdependency.fsm (21.0 KiB)
· 2
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.

Isaac Litster avatar image Isaac Litster commented ·

Hi @Dhuey C

Does Raja's answer work as a solution for you? If so, please click the Accept button below.

Thank you

0 Likes 0 ·
Dhuey C avatar image Dhuey C Isaac Litster commented ·

yes, thanks

0 Likes 0 ·