Pie State vs Time in an excel table.

Question

question

wei-ting L asked Nov 1, '18 Joshua S commented Nov 12, '18

Pie State vs Time in an excel table.

Is there a way to export the state pie to an excel and analyze it?

I want the pie status's information every day.

My dashboard is showing the "current" state of my machine's status. But I want the entire duration's information. From simulated day 1 to simulated day 31. In an excel table, showing that day 1's utilization rate is 20%, the idle rate is 80%. Days 2's utilization rate is 40%...... So the table should have many rows, each row represents one day. And the columns will show the status' of my machine.

Is there a way to do that?

Software Version:

FlexSim 18.2.2

state pie pie

state.png (14.5 KiB)

Answer 1 · 2018-11-02T12:21:31Z

Sam Stubbs answered Nov 2, '18 Joshua S commented Nov 12, '18

Yes you can export the table data of a chart into a CSV format that can be read by Excel.

If you're using one of the templates, you can open the chart's properties, open up the Advanced tab, and click on the Export Data button.

If you're using your own custom Statistic Collector for the chart you can select the General Tab in the Stats Collector's property window, and select the button Export Table from there.

· 6

wei-ting L commented · Nov 02, 2018 at 04:36 PM

Yes I know I can export the data by selecting chart's properties. But the problem is that it only shows the current model time's statues. It does not show the status vs time. So I don't know the changes of statues over time.

0 ·

Joshua S wei-ting L commented · Nov 05, 2018 at 10:15 PM

Do you want the stats to be accumulating, or reset every day?

0 ·

wei-ting L Joshua S commented · Nov 05, 2018 at 10:28 PM

Accumulating everyday.

So it should be something similar to this:

And the model records the status everyday.

0 ·

Show more comments

wei-ting L commented · Nov 09, 2018 at 12:09 AM

Hi Joshua,

The model you attached does not show each day's utilization/idle rate.

Do you know how should I set up the model?

0 ·

Joshua S wei-ting L commented · Nov 12, 2018 at 10:50 PM

@wei-ting L

Take a look at this model, everything is being calculated in StatisticsCollector1, so after so many days you can stop the model, right click the StatisticsCollector1, and export it as an excel file.

exportdaily-1.fsm

0 ·

exportdaily-1.fsm (32.4 KiB)

question