Description

Returns information about a parameter cell’s input grid. It tells if the grid is imported, not imported, or has warnings. Optionally checks for AOC-related information and returns a default value if no valid data is found.

Syntax

=MM_INPUTSTATUS(InputGridCell, CheckAOCInput, DefaultValue)

• InputGridCell
  A reference to a cell within the /INPUT from which information is to be retrieved.
• CheckAOCInput (optional)
  Boolean. Set to TRUE to apply the check on the AOC values. Default is FALSE.
• DefaultValue (optional)
  The value to display in Excel. Default is “No file imported”.

Remarks

The possible outcomes of the functions are the following:

• No file imported – Indicates that no input file has been imported.
• File imported – Indicates that the input file has been successfully imported without any issues.
• File imported with warnings – Indicates that the input file was imported, but some warnings or non-critical issues were detected.