Variable AnomalyFocusConst

Type Declaration

• ReadonlyAverage: "average"

  An average over the wrong cells.

• ReadonlyColorCoding: "colorCoding"

  A cell whose font color is not its role's (inputs, links, calculations).

• ReadonlyCrossSheetReference: "crossSheetReference"

  A link to another sheet that reads the wrong row or column.

• ReadonlyDeletedRows: "deletedRows"

  Rows deleted from a model, which leaves references shifted and #REF!.

• ReadonlyDoubleCounting: "doubleCounting"

  A cell or a subtotal counted twice in a sum.

• ReadonlyEmbeddedHardcode: "embeddedHardcode"

  A typed number where a reference belongs.

• ReadonlyLookup: "lookup"

  A lookup that matches approximately, or reads arrays that do not line up.

• ReadonlyReferenceAnchoring: "referenceAnchoring"

  A reference relative where it should be absolute, or the reverse.

• ReadonlySignConvention: "signConvention"

  A term added that should be taken away, or the reverse.

• ReadonlyUnitMismatch: "unitMismatch"

  A value in the wrong unit: a monthly figure in a daily formula, a percent typed as a whole number.