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

Related Commands

See Also