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

Question

question

Noah Z asked Jun 08 2016 at 1:41 PM jing.c commented Jun 18 2016 at 9:10 AM

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 08 2016 at 2:46 PM Ben Wilson edited Jun 08 2016 at 3:11 PM

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

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

Phil BoBo answered Jun 08 2016 at 2:49 PM Brandon Peterson commented Jun 17 2016 at 3:03 PM

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 3:10 PM

Thanks for the examples!

0 ·

Noah Z commented · Jun 16 2016 at 1: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 3: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 2: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 08 2016 at 3:52 PM jing.c commented Jun 18 2016 at 9:10 AM

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

question