Find Maximum Value in Sheet Area

Quickly search an area of a Simul8 spreadsheet and return the location (in column/row coordinates) of the maximum (highest) value in the area.

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 column number of the located cell

• A data item (global or local) to receive the returned row number of the located cell

If no suitable location is found (for example if the size of the area is improperly defined, or it contains no numerical values then column and row are returned as -1. The search is from minus infinity to plus infinity, so -1000 is considered lower than +100.