Average Input for every hour of the day

Question

question

Ashwath M asked Nov 17 2022 at 6:03 PM Ashwath M commented Nov 22 2022 at 8:05 PM

Average Input for every hour of the day

Hi,

I'm looking to get the average input for every hour of the day. A statistic collector would be ideal for this, having a table with each row having the duration of that day and a second column that computes the average input during that specific hour of that day (Example like below). Any thoughts on how this can be executed when the model is run for longer periods of time? Appreciate the inputs!

Software Version:

FlexSim 22.0.6

statistics collector time average content

1668707862215.png (3.9 KiB)

Answer 1 · 2022-11-17T20:44:28Z

Jeanette F answered Nov 17 2022 at 8:44 PM Ashwath M commented Nov 22 2022 at 8:05 PM

Hello @Ashwath M,

Pull an output by hour chart from the library into the dashboard. Select the chart and in the properties window go to the last tab called advanced and select the install button.

A window will appear like the one below. Select OK.

Two statistics collectors will show up in the toolbox. Open the statistics collector called by hour collector (not the core collector). In the first tab called Events there is a list of Events. Select the one called "Core- On Row FInished". Next to the object field is a dropper icon. Select the dropper and select the core collector and the event On Row Added. You can rename the collectors and their events so they match with input instead of output.

Your chart should then run and show the input by hour.

Input by hour.fsm

1668716997638.png (539 B)

1668717005859.png (11.6 KiB)

1668717649566.png (53.6 KiB)

1668720116791.png (8.3 KiB)

input-by-hour.fsm (38.3 KiB)

· 3

Ashwath M commented · Nov 17 2022 at 9:14 PM

Hi @Jeanette F Thank you for the inputs. What i am looking for is the Input with respect to each hour of a day. If I run a simulation for 30 days, I'm looking to get the average input for different time intervals within a day (9Am to 10AM, 3PM to 4PM, etc. ); I'm trying to analyze the input at different 1 hour time intervals. Do you know how this can be done? Something like the below (This should be the average for a model run of 30 days+) ; Essentially the Statistics Collector would need to have 24 rows (Each row having one hour time interval) and a column that keeps updating the average input for that specific hour interval. Thank you!

0 ·

1668719480795.png (4.4 KiB)

Jeanette F ♦♦ Ashwath M commented · Nov 17 2022 at 9:39 PM

Hello @Jeanette F,

I changed the Time column in the statistics collector so it displays the time of day.

I added a calculated table that looks at the statistics collector and partitions by the time of day and averages the input.

Input by hour_1.fsm

0 ·

1668720960349.png (89.5 KiB)

input-by-hour-1.fsm (39.9 KiB)

Ashwath M Jeanette F ♦♦ commented · Nov 22 2022 at 8:05 PM

Thanks @Jeanette F that worked. Appreciate the inputs

0 ·

question