Way to pull global table column statistics for Experimenter Performance Measure?

Question

question

Noah Z asked Jun 8, '16 jing.c commented Jun 18, '16

Way to pull global table column statistics for Experimenter Performance Measure?

I'd like to tally global table column statistics and report out on them by experimenter run. I know we can pull individual global table values but is there a built-in function that allows me to report summary info on column data from a global table automatically such as: SUM, STDEV, AVERAGE without me having to loop through the rows of the column and calculate the statistics in the OnRunStop trigger?

Software Version:

FlexSim 7.7.4

global table experimenter statistics data functions

Answer 1 · 2016-06-08T14:46:47Z

Regan Blackett answered Jun 8, '16 Ben Wilson edited Jun 8, '16

Noah,

I think the getdatastat() function is just what you are looking for:

https://answers.flexsim.com/articles/14290/getdatastat-4.html

Basically it can look at a set of data and give you it's Min, Max, Sum, Stddev, or Variance. You could probably write your own experiment performance measure that returns the result of getdatastat() to get you where you need to go.

· 1

Noah Z commented · Jun 08, 2016 at 03:10 PM

This is exactly what I needed. Thanks!

1 ·

Answer 2 · 2016-06-08T14:49:52Z

Phil BoBo answered Jun 8, '16 Brandon Peterson commented Jun 17, '16

You can use the getdatastat() command, such as:

int column = 1;

double sum = getdatastat(STAT_SUM, gettablerows("GlobalTable1"), gettablenum("GlobalTable1", count, column));

double stddev = getdatastat(STAT_STD_DEV, gettablerows("GlobalTable1"), gettablenum("GlobalTable1", count, column));

double average = getdatastat(STAT_MEAN, gettablerows("GlobalTable1"), gettablenum("GlobalTable1", count, column));

· 4

Noah Z commented · Jun 08, 2016 at 03:10 PM

Thanks for the examples!

0 ·

Noah Z commented · Jun 16, 2016 at 01:56 PM

Hi @phil.bobo,

I have a global table with columns that have different quantities of numbers (i.e. column 1 has 300 values and column 2 has 450 values (these vary from run to run)) and I am trying to pull the mean of the columns but getdatastat() function pulls the whole column (all the zeros after the real data). Is there a way to tell getdatastat() to ignore cells with zero values?

0 ·

Brandon Peterson ♦ Noah Z commented · Jun 17, 2016 at 03:03 PM

Noah,

Check out the functions that I put into a user library in the other answer to this question. You can specify a range in those functions which will allow you to limit the amount of the column that is used or to use multiple columns.

1 ·

Adrian Haws Noah Z commented · Jun 16, 2016 at 02:59 PM

@Noah Zenker With the new Answers forum questions should be asked individually so as to make it easier for others to benefit from them. I've reposted this second question here.

This is a link to an article on the "best practices" for using this Answers site.

0 ·

Answer 3 · 2016-06-08T15:52:52Z

Brandon Peterson answered Jun 8, '16 jing.c commented Jun 18, '16

If you have trouble understanding how the getdatastat() function works then here is a user library with some functions for finding the Min, Max, Ave, Variance, and Standard Deviation from a range within a table. I included a sample model that has demo code in a script window that prints the results to the output console.

The functions I wrote do the calculations manually but I could have used the same commands that Regan and Phil replied with. I'm not sure which method would be faster.

Good Luck,

Brandon

rangecommands-v2016.zip (1.5 KiB)

rangecommandstest.fsm (23.4 KiB)

· 1

jing.c commented · Jun 18, 2016 at 09:10 AM

Thanks Brandon! I think it can be very useful!

And I updated your commands to guarantee not use deprecated command such as parval() or parnode() for avoiding these commands invalid in furtrue version.

BTW, I had test your command can be use in bundle data, so I change a little in Parameters.

ucrangestats-jingv16.fsm

1 ·

ucrangestats-jingv16.fsm (27.0 KiB)

question