Average Sheet Area
Calculate the average (statistical mean) of all the numerical values in an area of a Simul8 spreadsheet. Blank or text cells in the area will not be included in calculating the average.
Parameters
- Sheet location of left/top of the area eg MySheet[5,2] if the area starts at column 5, row 2
- Number of columns in the area
- Number of rows in the area
- A data item (global or local) to receive the returned average