{
  "schemaVersion": 1,
  "testSet": {
    "version": 1,
    "libraryVersion": "0.3.0",
    "checksum": "bdf94c76df81ea1fa2e1bf96a557c41b21a0f11ea11ae612fcccc35157d7275a",
    "totalTests": 2350,
    "publishedExamples": 177,
    "formulaTests": 2000,
    "editSequenceTests": 250,
    "workbookTests": 100,
    "localPassed": 2290,
    "reviewedResults": 0,
    "missingReviewedResults": 2290,
    "unsupported": 60,
    "warningChecks": 28,
    "knownDifferences": 1,
    "regressions": 0
  },
  "filterOptions": {
    "features": [
      {
        "value": "operator:add",
        "label": "Operator · add"
      },
      {
        "value": "function:IF",
        "label": "Function · IF"
      },
      {
        "value": "function:COUNTIF",
        "label": "Function · COUNTIF"
      },
      {
        "value": "function:VLOOKUP",
        "label": "Function · VLOOKUP"
      },
      {
        "value": "function:FILTER",
        "label": "Function · FILTER"
      },
      {
        "value": "feature:workbook-round-trip",
        "label": "Feature · Workbook round-trip"
      },
      {
        "value": "function:SUM",
        "label": "Function · SUM"
      },
      {
        "value": "function:AVERAGE",
        "label": "Function · AVERAGE"
      },
      {
        "value": "function:MIN",
        "label": "Function · MIN"
      },
      {
        "value": "function:MAX",
        "label": "Function · MAX"
      },
      {
        "value": "function:COUNT",
        "label": "Function · COUNT"
      },
      {
        "value": "function:ABS",
        "label": "Function · ABS"
      },
      {
        "value": "function:ROUND",
        "label": "Function · ROUND"
      },
      {
        "value": "function:SQRT",
        "label": "Function · SQRT"
      },
      {
        "value": "function:MOD",
        "label": "Function · MOD"
      },
      {
        "value": "function:POW",
        "label": "Function · POW"
      },
      {
        "value": "function:AND",
        "label": "Function · AND"
      },
      {
        "value": "function:OR",
        "label": "Function · OR"
      },
      {
        "value": "function:NOT",
        "label": "Function · NOT"
      },
      {
        "value": "function:FLOOR",
        "label": "Function · FLOOR"
      },
      {
        "value": "function:CEILING",
        "label": "Function · CEILING"
      },
      {
        "value": "function:INT",
        "label": "Function · INT"
      },
      {
        "value": "function:TRUNC",
        "label": "Function · TRUNC"
      },
      {
        "value": "function:SIGN",
        "label": "Function · SIGN"
      },
      {
        "value": "function:PI",
        "label": "Function · PI"
      },
      {
        "value": "function:IFERROR",
        "label": "Function · IFERROR"
      },
      {
        "value": "function:IFNA",
        "label": "Function · IFNA"
      },
      {
        "value": "function:IFS",
        "label": "Function · IFS"
      },
      {
        "value": "function:SWITCH",
        "label": "Function · SWITCH"
      },
      {
        "value": "function:XOR",
        "label": "Function · XOR"
      },
      {
        "value": "function:TRUE",
        "label": "Function · TRUE"
      },
      {
        "value": "function:FALSE",
        "label": "Function · FALSE"
      },
      {
        "value": "function:ISBLANK",
        "label": "Function · ISBLANK"
      },
      {
        "value": "function:ISNUMBER",
        "label": "Function · ISNUMBER"
      },
      {
        "value": "function:ISTEXT",
        "label": "Function · ISTEXT"
      },
      {
        "value": "function:ISLOGICAL",
        "label": "Function · ISLOGICAL"
      },
      {
        "value": "function:ISERROR",
        "label": "Function · ISERROR"
      },
      {
        "value": "function:ISERR",
        "label": "Function · ISERR"
      },
      {
        "value": "function:ISNA",
        "label": "Function · ISNA"
      },
      {
        "value": "function:TYPE",
        "label": "Function · TYPE"
      },
      {
        "value": "function:N",
        "label": "Function · N"
      },
      {
        "value": "function:T",
        "label": "Function · T"
      },
      {
        "value": "function:COUNTA",
        "label": "Function · COUNTA"
      },
      {
        "value": "function:LEN",
        "label": "Function · LEN"
      },
      {
        "value": "function:LEFT",
        "label": "Function · LEFT"
      },
      {
        "value": "function:RIGHT",
        "label": "Function · RIGHT"
      },
      {
        "value": "function:MID",
        "label": "Function · MID"
      },
      {
        "value": "function:CONCAT",
        "label": "Function · CONCAT"
      },
      {
        "value": "function:UPPER",
        "label": "Function · UPPER"
      },
      {
        "value": "function:LOWER",
        "label": "Function · LOWER"
      },
      {
        "value": "function:TRIM",
        "label": "Function · TRIM"
      },
      {
        "value": "function:TEXT",
        "label": "Function · TEXT"
      },
      {
        "value": "function:EXACT",
        "label": "Function · EXACT"
      },
      {
        "value": "function:DATE",
        "label": "Function · DATE"
      },
      {
        "value": "function:DATEVALUE",
        "label": "Function · DATEVALUE"
      },
      {
        "value": "function:DAY",
        "label": "Function · DAY"
      },
      {
        "value": "function:MONTH",
        "label": "Function · MONTH"
      },
      {
        "value": "function:YEAR",
        "label": "Function · YEAR"
      },
      {
        "value": "function:TODAY",
        "label": "Function · TODAY"
      },
      {
        "value": "function:NOW",
        "label": "Function · NOW"
      },
      {
        "value": "function:COUNTIFS",
        "label": "Function · COUNTIFS"
      },
      {
        "value": "function:SUMIF",
        "label": "Function · SUMIF"
      },
      {
        "value": "function:SUMIFS",
        "label": "Function · SUMIFS"
      },
      {
        "value": "function:AVERAGEIF",
        "label": "Function · AVERAGEIF"
      },
      {
        "value": "function:AVERAGEIFS",
        "label": "Function · AVERAGEIFS"
      },
      {
        "value": "function:INDEX",
        "label": "Function · INDEX"
      },
      {
        "value": "function:MATCH",
        "label": "Function · MATCH"
      },
      {
        "value": "function:HLOOKUP",
        "label": "Function · HLOOKUP"
      },
      {
        "value": "function:XLOOKUP",
        "label": "Function · XLOOKUP"
      },
      {
        "value": "function:NA",
        "label": "Function · NA"
      },
      {
        "value": "function:SORT",
        "label": "Function · SORT"
      },
      {
        "value": "function:UNIQUE",
        "label": "Function · UNIQUE"
      },
      {
        "value": "function:LET",
        "label": "Function · LET"
      },
      {
        "value": "function:PRODUCT",
        "label": "Function · PRODUCT"
      },
      {
        "value": "function:SUMPRODUCT",
        "label": "Function · SUMPRODUCT"
      },
      {
        "value": "function:POWER",
        "label": "Function · POWER"
      },
      {
        "value": "function:EXP",
        "label": "Function · EXP"
      },
      {
        "value": "function:LN",
        "label": "Function · LN"
      },
      {
        "value": "function:LOG",
        "label": "Function · LOG"
      },
      {
        "value": "function:LOG10",
        "label": "Function · LOG10"
      },
      {
        "value": "function:ROUNDUP",
        "label": "Function · ROUNDUP"
      },
      {
        "value": "function:ROUNDDOWN",
        "label": "Function · ROUNDDOWN"
      },
      {
        "value": "function:MROUND",
        "label": "Function · MROUND"
      },
      {
        "value": "function:EVEN",
        "label": "Function · EVEN"
      },
      {
        "value": "function:ODD",
        "label": "Function · ODD"
      },
      {
        "value": "function:QUOTIENT",
        "label": "Function · QUOTIENT"
      },
      {
        "value": "function:GCD",
        "label": "Function · GCD"
      },
      {
        "value": "function:LCM",
        "label": "Function · LCM"
      },
      {
        "value": "function:SUBTOTAL",
        "label": "Function · SUBTOTAL"
      },
      {
        "value": "function:TEXTJOIN",
        "label": "Function · TEXTJOIN"
      },
      {
        "value": "function:SUBSTITUTE",
        "label": "Function · SUBSTITUTE"
      },
      {
        "value": "function:REPLACE",
        "label": "Function · REPLACE"
      },
      {
        "value": "function:FIND",
        "label": "Function · FIND"
      },
      {
        "value": "function:SEARCH",
        "label": "Function · SEARCH"
      },
      {
        "value": "function:VALUE",
        "label": "Function · VALUE"
      },
      {
        "value": "function:CLEAN",
        "label": "Function · CLEAN"
      },
      {
        "value": "function:REPT",
        "label": "Function · REPT"
      },
      {
        "value": "function:CHAR",
        "label": "Function · CHAR"
      },
      {
        "value": "function:CODE",
        "label": "Function · CODE"
      },
      {
        "value": "function:UNICHAR",
        "label": "Function · UNICHAR"
      },
      {
        "value": "function:UNICODE",
        "label": "Function · UNICODE"
      },
      {
        "value": "function:PROPER",
        "label": "Function · PROPER"
      },
      {
        "value": "function:NUMBERVALUE",
        "label": "Function · NUMBERVALUE"
      },
      {
        "value": "function:TIME",
        "label": "Function · TIME"
      },
      {
        "value": "function:TIMEVALUE",
        "label": "Function · TIMEVALUE"
      },
      {
        "value": "function:HOUR",
        "label": "Function · HOUR"
      },
      {
        "value": "function:MINUTE",
        "label": "Function · MINUTE"
      },
      {
        "value": "function:SECOND",
        "label": "Function · SECOND"
      },
      {
        "value": "function:DAYS",
        "label": "Function · DAYS"
      },
      {
        "value": "function:EDATE",
        "label": "Function · EDATE"
      },
      {
        "value": "function:EOMONTH",
        "label": "Function · EOMONTH"
      },
      {
        "value": "function:WEEKDAY",
        "label": "Function · WEEKDAY"
      },
      {
        "value": "function:WEEKNUM",
        "label": "Function · WEEKNUM"
      },
      {
        "value": "function:WORKDAY",
        "label": "Function · WORKDAY"
      },
      {
        "value": "function:NETWORKDAYS",
        "label": "Function · NETWORKDAYS"
      },
      {
        "value": "function:YEARFRAC",
        "label": "Function · YEARFRAC"
      },
      {
        "value": "function:DAYS360",
        "label": "Function · DAYS360"
      },
      {
        "value": "function:MEDIAN",
        "label": "Function · MEDIAN"
      },
      {
        "value": "function:MODE.SNGL",
        "label": "Function · MODE.SNGL"
      },
      {
        "value": "function:LARGE",
        "label": "Function · LARGE"
      },
      {
        "value": "function:SMALL",
        "label": "Function · SMALL"
      },
      {
        "value": "function:RANK.EQ",
        "label": "Function · RANK.EQ"
      },
      {
        "value": "function:PERCENTILE.INC",
        "label": "Function · PERCENTILE.INC"
      },
      {
        "value": "function:QUARTILE.INC",
        "label": "Function · QUARTILE.INC"
      },
      {
        "value": "function:STDEV.S",
        "label": "Function · STDEV.S"
      },
      {
        "value": "function:STDEV.P",
        "label": "Function · STDEV.P"
      },
      {
        "value": "function:VAR.S",
        "label": "Function · VAR.S"
      },
      {
        "value": "function:VAR.P",
        "label": "Function · VAR.P"
      },
      {
        "value": "function:GEOMEAN",
        "label": "Function · GEOMEAN"
      },
      {
        "value": "function:CORREL",
        "label": "Function · CORREL"
      },
      {
        "value": "function:COVARIANCE.S",
        "label": "Function · COVARIANCE.S"
      },
      {
        "value": "function:COVARIANCE.P",
        "label": "Function · COVARIANCE.P"
      },
      {
        "value": "function:COUNTBLANK",
        "label": "Function · COUNTBLANK"
      },
      {
        "value": "function:MAXIFS",
        "label": "Function · MAXIFS"
      },
      {
        "value": "function:MINIFS",
        "label": "Function · MINIFS"
      },
      {
        "value": "function:XMATCH",
        "label": "Function · XMATCH"
      },
      {
        "value": "function:CHOOSE",
        "label": "Function · CHOOSE"
      },
      {
        "value": "function:ROW",
        "label": "Function · ROW"
      },
      {
        "value": "function:ROWS",
        "label": "Function · ROWS"
      },
      {
        "value": "function:COLUMN",
        "label": "Function · COLUMN"
      },
      {
        "value": "function:COLUMNS",
        "label": "Function · COLUMNS"
      },
      {
        "value": "function:ADDRESS",
        "label": "Function · ADDRESS"
      },
      {
        "value": "function:TRANSPOSE",
        "label": "Function · TRANSPOSE"
      },
      {
        "value": "function:SEQUENCE",
        "label": "Function · SEQUENCE"
      },
      {
        "value": "function:TAKE",
        "label": "Function · TAKE"
      },
      {
        "value": "function:DROP",
        "label": "Function · DROP"
      },
      {
        "value": "function:CHOOSECOLS",
        "label": "Function · CHOOSECOLS"
      },
      {
        "value": "function:CHOOSEROWS",
        "label": "Function · CHOOSEROWS"
      },
      {
        "value": "function:PV",
        "label": "Function · PV"
      },
      {
        "value": "function:FV",
        "label": "Function · FV"
      },
      {
        "value": "function:PMT",
        "label": "Function · PMT"
      },
      {
        "value": "function:NPV",
        "label": "Function · NPV"
      },
      {
        "value": "function:IRR",
        "label": "Function · IRR"
      },
      {
        "value": "function:RATE",
        "label": "Function · RATE"
      },
      {
        "value": "function:IPMT",
        "label": "Function · IPMT"
      },
      {
        "value": "function:PPMT",
        "label": "Function · PPMT"
      },
      {
        "value": "operator:subtract",
        "label": "Operator · subtract"
      },
      {
        "value": "operator:multiply",
        "label": "Operator · multiply"
      },
      {
        "value": "operator:divide",
        "label": "Operator · divide"
      },
      {
        "value": "operator:power",
        "label": "Operator · power"
      },
      {
        "value": "operator:concatenate",
        "label": "Operator · concatenate"
      },
      {
        "value": "operator:equal",
        "label": "Operator · equal"
      },
      {
        "value": "operator:not-equal",
        "label": "Operator · not-equal"
      },
      {
        "value": "operator:less-than",
        "label": "Operator · less-than"
      },
      {
        "value": "operator:less-than-or-equal",
        "label": "Operator · less-than-or-equal"
      },
      {
        "value": "operator:greater-than",
        "label": "Operator · greater-than"
      },
      {
        "value": "operator:greater-than-or-equal",
        "label": "Operator · greater-than-or-equal"
      },
      {
        "value": "operator:percent",
        "label": "Operator · percent"
      },
      {
        "value": "operator:unary-plus",
        "label": "Operator · unary-plus"
      },
      {
        "value": "operator:unary-minus",
        "label": "Operator · unary-minus"
      },
      {
        "value": "feature:edit-sequences",
        "label": "Feature · Edit sequences"
      },
      {
        "value": "feature:workbook-changes",
        "label": "Feature · Workbook changes"
      }
    ],
    "behaviors": [
      "shared",
      "excel"
    ],
    "statuses": [
      "local-pass",
      "result-unavailable",
      "reviewed-pass",
      "known-difference",
      "unsupported",
      "warning",
      "regression"
    ]
  },
  "sources": [
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "Arithmetic operators",
      "sha256": "8475ddb0b3d6292a81a5931fc60e1c40cc8228351347c673c4a16d65ffacade5",
      "title": "Calculation operators and precedence in Excel",
      "url": "https://support.microsoft.com/en-us/office/calculation-operators-and-precedence-in-excel-48be406d-4975-4d31-b2b8-7af9e0e2878a"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "The 1900 date system",
      "sha256": "859e35c99cae9a57208ff43501dc9b9877baaee1475d51dd440a04ea15a7a9e0",
      "title": "Date systems in Excel",
      "url": "https://support.microsoft.com/en-us/office/date-systems-in-excel-e7fe7167-48a9-4b96-bb53-5612a800b487"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "6.15.4 IF",
      "sha256": "e1ea5728e89854828d36a9243936c4054b62754c4b6e4bb194cd8251b570f395",
      "title": "OpenDocument v1.3 Part 4 OpenFormula",
      "url": "https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "6.10.9 COUNTIF",
      "sha256": "c9e36ec2f4625f1e9f63a0b933e650fc08e680b928a201fce2e38fdd7d98c034",
      "title": "OpenDocument v1.3 Part 4 OpenFormula",
      "url": "https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "6.14.12 VLOOKUP",
      "sha256": "6c14ced5bbadd4963bd6499a4ed26dc9fae689002e41ef9b52f2989eecd27ac8",
      "title": "OpenDocument v1.3 Part 4 OpenFormula",
      "url": "https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "Lookup and reference functions",
      "sha256": "27f461d2b69a5a64c0bb7261b052c6830e0186602f822ec37eb07d650ba77596",
      "title": "Excel functions (by category)",
      "url": "https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb"
    },
    {
      "authorship": "original",
      "license": "Original; MIT",
      "section": "Part 1, 18.2 workbook and worksheet identity",
      "sha256": "9f11f30359bed08272b74381cd326816bfff4e319db5286a2c2171149d08e896",
      "title": "ECMA-376 Office Open XML File Formats",
      "url": "https://ecma-international.org/publications-and-standards/standards/ecma-376/"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "Math and trigonometry functions",
      "sha256": "efd7f0c45d47bfdb9700ad5cc54d5c2cfd0fa671a7b4418b67e570e6d505fe94",
      "title": "Excel functions (by category)",
      "url": "https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "Statistical functions",
      "sha256": "10c0877d98bf6c64d3e450c9ca85fd3617253878fe850503b067fe24dd412e99",
      "title": "Excel functions (by category)",
      "url": "https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "Logical functions",
      "sha256": "f5972481084585b748b355320ab6c9c1a810b8e323f4c64bfa5d6fa4afd1671c",
      "title": "Excel functions (by category)",
      "url": "https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "Information functions",
      "sha256": "ece7d180ac323de559b80c9dfff3319b09d51a97a977f017270bea5b7c5f8736",
      "title": "Excel functions (by category)",
      "url": "https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "Text functions",
      "sha256": "5e65453a69bd268f930e080fa7f7e9557cccda304bdb8bdb16e98908bf2517fd",
      "title": "Excel functions (by category)",
      "url": "https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "Date and time functions",
      "sha256": "86133289b8e25d02b7d7fbaf022360b6845b14c7294363459d18808311351815",
      "title": "Excel functions (by category)",
      "url": "https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "Financial functions",
      "sha256": "674514f3e0e770566ff99464be47355d7eb540897aa1192af8f99f42f5ef794e",
      "title": "Excel functions (by category)",
      "url": "https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "Text concatenation operator",
      "sha256": "fa987459da61bb34fc3268ecb93179f73496b92e79e187a20d30e79adf4678bc",
      "title": "Calculation operators and precedence in Excel",
      "url": "https://support.microsoft.com/en-us/office/calculation-operators-and-precedence-in-excel-48be406d-4975-4d31-b2b8-7af9e0e2878a"
    },
    {
      "authorship": "spec-derived",
      "license": "Spec metadata; MIT",
      "section": "Comparison operators",
      "sha256": "1d12acad7a28772c785d574e95b69f8cdc713328c0bdb1a5f008f6c331cbabed",
      "title": "Calculation operators and precedence in Excel",
      "url": "https://support.microsoft.com/en-us/office/calculation-operators-and-precedence-in-excel-48be406d-4975-4d31-b2b8-7af9e0e2878a"
    },
    {
      "authorship": "original",
      "license": "Original; MIT",
      "section": "Part 1, 18.3 worksheet state transitions",
      "sha256": "6213c6197f774c04d279b5093261cf343e64b0a8e07911c4e6d1579d7553a452",
      "title": "ECMA-376 Office Open XML File Formats",
      "url": "https://ecma-international.org/publications-and-standards/standards/ecma-376/"
    },
    {
      "authorship": "original",
      "license": "Original; MIT",
      "section": "Part 1, 18.2 workbook and worksheet metadata",
      "sha256": "9f01e02cd8babca141fd19c899192067de46b7c6575fcd23a6fa727e8b5acf9e",
      "title": "ECMA-376 Office Open XML File Formats",
      "url": "https://ecma-international.org/publications-and-standards/standards/ecma-376/"
    }
  ],
  "evidence": [
    {
      "basis": "documented-semantics",
      "kind": "property",
      "description": "Integer addition has the exact identity 1 + 1 = 2."
    },
    {
      "basis": "documented-semantics",
      "kind": "property",
      "description": "The raw serial is preserved while the local formatter uses its documented date fallback."
    },
    {
      "basis": "documented-semantics",
      "kind": "property",
      "description": "IF does not evaluate the unselected division-by-zero branch."
    },
    {
      "basis": "documented-semantics",
      "kind": "property",
      "description": "Only alpha in the independently supplied range matches the a* wildcard."
    },
    {
      "basis": "documented-semantics",
      "kind": "property",
      "description": "An exact lookup for z in the independently supplied a/b table has no match."
    },
    {
      "basis": "property-invariant",
      "kind": "property",
      "description": "A pre-existing C2 literal blocks the selected two-row spill rooted at C1."
    },
    {
      "basis": "property-invariant",
      "kind": "property",
      "description": "One create and one set operation yield one visible Canary sheet containing A1=2."
    },
    {
      "basis": "documented-semantics",
      "kind": "property",
      "description": "Authored documented result."
    },
    {
      "basis": "documented-semantics",
      "kind": "property",
      "description": "Authored result and direct coercion/shape property."
    },
    {
      "basis": "documented-semantics",
      "kind": "property",
      "description": "Category is not applicable to a zero-argument function."
    },
    {
      "basis": "property-invariant",
      "kind": "property",
      "description": "Each declared mutation must produce its independently modeled invariant."
    },
    {
      "basis": "documented-semantics",
      "kind": "property",
      "description": "Each declared workbook feature must survive its explicit document operation."
    }
  ],
  "cases": [
    {
      "position": 1,
      "id": "canary.arithmetic.1-plus-1",
      "label": "add · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:add",
      "featureLabel": "Operator · add",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=1+1",
      "target": "A1",
      "inputs": [],
      "expected": {
        "type": "number",
        "value": 2
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 0,
      "evidenceIndex": 0,
      "testChecksum": "9e35eba6b65be2cbe247f8252d200ba05d9921e9ca84ae5e90d9b02ddae9e45e",
      "observations": []
    },
    {
      "position": 2,
      "id": "canary.date.serial-60",
      "label": "add · Boundary",
      "kind": "formula",
      "area": "formula",
      "category": "boundary",
      "family": "operator",
      "behavior": "excel",
      "featureValue": "operator:add",
      "featureLabel": "Operator · add",
      "statusTags": [
        "local-pass",
        "result-unavailable",
        "known-difference"
      ],
      "formula": "=60+0",
      "target": "B1",
      "inputs": [],
      "expected": {
        "displayedText": "1900-02-28",
        "type": "number",
        "value": 60
      },
      "tolerance": {
        "kind": "exact"
      },
      "knownDifference": {
        "alternate": {
          "displayedText": "1900-02-29",
          "type": "number",
          "value": 60
        },
        "producers": [
          "excel-desktop",
          "excel-web"
        ],
        "reason": "Excel's synthetic serial 60 displays as 1900-02-29; Sheetwrite preserves the raw serial and uses the documented JavaScript-date fallback 1900-02-28."
      },
      "unsupported": false,
      "sourceIndex": 1,
      "evidenceIndex": 1,
      "testChecksum": "6bd5a9fcded7afb23dbb2399172eb4cd1e3e1d962f33c3136d08a44bc94f06d1",
      "observations": []
    },
    {
      "position": 3,
      "id": "canary.if.lazy-error-branch",
      "label": "IF · Error",
      "kind": "formula",
      "area": "formula",
      "category": "error",
      "family": "logical-control",
      "behavior": "shared",
      "featureValue": "function:IF",
      "featureLabel": "Function · IF",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=IF(FALSE,1/0,7)",
      "target": "A1",
      "inputs": [],
      "expected": {
        "type": "number",
        "value": 7
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 2,
      "evidenceIndex": 2,
      "testChecksum": "1587eb31ac31c400103afbbb3c0ecbb34692973270944c39f6bed937e18984aa",
      "observations": []
    },
    {
      "position": 4,
      "id": "canary.criteria.wildcard",
      "label": "COUNTIF · Range Array",
      "kind": "formula",
      "area": "formula",
      "category": "range-array",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:COUNTIF",
      "featureLabel": "Function · COUNTIF",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=COUNTIF(A1:A2,\"a*\")",
      "target": "B1",
      "inputs": [
        {
          "cell": "A1",
          "value": "alpha"
        },
        {
          "cell": "A2",
          "value": "beta"
        }
      ],
      "expected": {
        "type": "number",
        "value": 1
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 3,
      "evidenceIndex": 3,
      "testChecksum": "ee9f63cb610cb444fe5ad9b12cdf0ba4f7eaca17932479a07874e12c22f0a0ce",
      "observations": []
    },
    {
      "position": 5,
      "id": "canary.lookup.not-found",
      "label": "VLOOKUP · Error",
      "kind": "formula",
      "area": "formula",
      "category": "error",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:VLOOKUP",
      "featureLabel": "Function · VLOOKUP",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=VLOOKUP(\"z\",A1:B2,2,FALSE)",
      "target": "C1",
      "inputs": [
        {
          "cell": "A1",
          "value": "a"
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "A2",
          "value": "b"
        },
        {
          "cell": "B2",
          "value": 2
        }
      ],
      "expected": {
        "error": "#N/A",
        "type": "error"
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 4,
      "evidenceIndex": 4,
      "testChecksum": "478871050a991c859c6d6a40698f92f5cd1397cad9ac2cdeae2f6425c050d869",
      "observations": []
    },
    {
      "position": 6,
      "id": "canary.spill.obstruction",
      "label": "FILTER · Range Array",
      "kind": "formula",
      "area": "formula",
      "category": "range-array",
      "family": "array",
      "behavior": "shared",
      "featureValue": "function:FILTER",
      "featureLabel": "Function · FILTER",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=FILTER(A1:A2,B1:B2)",
      "target": "C1",
      "inputs": [
        {
          "cell": "A1",
          "value": 1
        },
        {
          "cell": "A2",
          "value": 2
        },
        {
          "cell": "B1",
          "value": true
        },
        {
          "cell": "B2",
          "value": true
        },
        {
          "cell": "C2",
          "value": "blocker"
        }
      ],
      "expected": {
        "error": "#SPILL!",
        "type": "error"
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 5,
      "testChecksum": "5e6e2b7eda1f66b57e00ea0ca1ba6f38d62553f1c314889c3c7f357df94e32ab",
      "observations": []
    },
    {
      "position": 7,
      "id": "canary.workbook.roundtrip",
      "label": "Create Sheet + Set · Mutation",
      "kind": "workbook",
      "area": "workbook",
      "category": "mutation",
      "family": "workbook-state",
      "behavior": "shared",
      "featureValue": "feature:workbook-round-trip",
      "featureLabel": "Feature · Workbook round-trip",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "operations": [
        {
          "name": "Canary",
          "op": "create-sheet"
        },
        {
          "cell": "A1",
          "op": "set",
          "value": 2
        }
      ],
      "expected": {
        "type": "workbook",
        "value": {
          "activeSheet": "Canary",
          "sheetCount": 1,
          "sheets": [
            {
              "cells": {
                "A1": 2
              },
              "name": "Canary",
              "visibility": "visible"
            }
          ]
        }
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 6,
      "evidenceIndex": 6,
      "testChecksum": "c417bd280c69c46409f9282281820ee517d02399e8f462e97988e14e1a0b53d1",
      "observations": []
    },
    {
      "position": 8,
      "id": "formula.function.sum.normal.1",
      "label": "SUM · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:SUM",
      "featureLabel": "Function · SUM",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUM(1,2,3)=6",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "13e233419b98862c4f349790425b2992985b23c6ad53729aef32a8a0d80f8b3f",
      "observations": []
    },
    {
      "position": 9,
      "id": "formula.function.sum.empty.1",
      "label": "SUM · Empty",
      "kind": "formula",
      "area": "formula",
      "category": "empty",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:SUM",
      "featureLabel": "Function · SUM",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=AND(SUM(1,2,3)=6,IFERROR((SUM(C1,2,3))=(SUM(2,3)),FALSE))",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 8,
      "testChecksum": "7c110726683a74b76a77cba822679a54a9b6c07815a2610d5f4de096ade20a85",
      "observations": []
    },
    {
      "position": 10,
      "id": "formula.function.sum.mixed.1",
      "label": "SUM · Mixed",
      "kind": "formula",
      "area": "formula",
      "category": "mixed",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:SUM",
      "featureLabel": "Function · SUM",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=AND(SUM(1,2,3)=6,IFERROR((SUM(C1,2,3))=(SUM(2,3)),FALSE))",
      "target": "D4",
      "inputs": [
        {
          "cell": "C1",
          "value": "2"
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 8,
      "testChecksum": "047c9d9a701ac6002da1a82f19dadbfe01c3c716906bbe10f25cbd8e9b8f1fb6",
      "observations": []
    },
    {
      "position": 14,
      "id": "formula.function.average.normal.1",
      "label": "AVERAGE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:AVERAGE",
      "featureLabel": "Function · AVERAGE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=AVERAGE(1,2,3)=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "7848c11eb685512f6a0a84d8154f7746a37f01192a20ed67d680d55c2469890a",
      "observations": []
    },
    {
      "position": 20,
      "id": "formula.function.min.normal.1",
      "label": "MIN · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:MIN",
      "featureLabel": "Function · MIN",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MIN(3,-1,2)=-1",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "7ec49c196f8a91606ca8de5c997493f723d87f4210bdd96efc97420f1ca368ee",
      "observations": []
    },
    {
      "position": 26,
      "id": "formula.function.max.normal.1",
      "label": "MAX · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:MAX",
      "featureLabel": "Function · MAX",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MAX(3,-1,2)=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "f3050d0698e86ca6ccfb0864ac9465f20376fe4bbfa9f0bb612daf8c745d78d0",
      "observations": []
    },
    {
      "position": 32,
      "id": "formula.function.count.normal.1",
      "label": "COUNT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:COUNT",
      "featureLabel": "Function · COUNT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=COUNT(1,\"x\",2)=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "c5d2134cd8a04a2d00c55d27c048b8b32cf2da899536be64a67327816a38731c",
      "observations": []
    },
    {
      "position": 44,
      "id": "formula.function.abs.normal.1",
      "label": "ABS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:ABS",
      "featureLabel": "Function · ABS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ABS(-3)=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "b52d90d45d6778fcf1a964623fe992001b7c8bef6bd5b9978faf9093aee1a9de",
      "observations": []
    },
    {
      "position": 50,
      "id": "formula.function.round.normal.1",
      "label": "ROUND · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:ROUND",
      "featureLabel": "Function · ROUND",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ROUND(2.34,1)=2.3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "1f63c15a5cf6f1a3e15a21817f9f3e074a73405d3a727f1156a809afc081ecde",
      "observations": []
    },
    {
      "position": 56,
      "id": "formula.function.sqrt.normal.1",
      "label": "SQRT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:SQRT",
      "featureLabel": "Function · SQRT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SQRT(9)=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "44eb3a9e3a2eae49a8f78d86ae42d398095076f2edb97a6970afe754a75632a7",
      "observations": []
    },
    {
      "position": 62,
      "id": "formula.function.mod.normal.1",
      "label": "MOD · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:MOD",
      "featureLabel": "Function · MOD",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MOD(7,3)=1",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "47d5e6e47b45303c9a2b3c6ea0a5e505babc2cbaf73c69d7708aa3338c1e07e9",
      "observations": []
    },
    {
      "position": 68,
      "id": "formula.function.pow.normal.1",
      "label": "POW · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:POW",
      "featureLabel": "Function · POW",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=POW(2,3)=8",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "19e9a77fe6bb17014fe2c51d11ea29a8af393ad8d345d31b27dffb83d6291082",
      "observations": []
    },
    {
      "position": 74,
      "id": "formula.function.and.normal.1",
      "label": "AND · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "logical-control",
      "behavior": "shared",
      "featureValue": "function:AND",
      "featureLabel": "Function · AND",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=AND(TRUE,TRUE)=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 9,
      "evidenceIndex": 7,
      "testChecksum": "3e7f0156988f3796146153f6f45a9a19517e82a8186f3644100449e70bee4246",
      "observations": []
    },
    {
      "position": 80,
      "id": "formula.function.or.normal.1",
      "label": "OR · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "logical-control",
      "behavior": "shared",
      "featureValue": "function:OR",
      "featureLabel": "Function · OR",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=OR(FALSE,TRUE)=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 9,
      "evidenceIndex": 7,
      "testChecksum": "1eafd75579bf8169aa236f36340947d7fa4a01004f9f159d98d4c5b244198ca6",
      "observations": []
    },
    {
      "position": 86,
      "id": "formula.function.not.normal.1",
      "label": "NOT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "logical-control",
      "behavior": "shared",
      "featureValue": "function:NOT",
      "featureLabel": "Function · NOT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=NOT(TRUE)=FALSE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 9,
      "evidenceIndex": 7,
      "testChecksum": "2dca4425386b58263de89bd85043592889226545d967aa398b3dfccf0aa2e131",
      "observations": []
    },
    {
      "position": 92,
      "id": "formula.function.floor.normal.1",
      "label": "FLOOR · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:FLOOR",
      "featureLabel": "Function · FLOOR",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=FLOOR(7,2)=6",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "724961c313a3ef9a2a1c0a2156af39af6b4db590fd394b776ed09cd376ec8fd0",
      "observations": []
    },
    {
      "position": 98,
      "id": "formula.function.ceiling.normal.1",
      "label": "CEILING · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:CEILING",
      "featureLabel": "Function · CEILING",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=CEILING(7,2)=8",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "257deb63d3b7b75dd853a826e06fec4628dd143803395467e0fd735a8c18f631",
      "observations": []
    },
    {
      "position": 104,
      "id": "formula.function.int.normal.1",
      "label": "INT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:INT",
      "featureLabel": "Function · INT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=INT(2.9)=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "98cd3656493408ee50bca4d5abf84da288fbb0258a344ee6536335cfa2494ef0",
      "observations": []
    },
    {
      "position": 110,
      "id": "formula.function.trunc.normal.1",
      "label": "TRUNC · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:TRUNC",
      "featureLabel": "Function · TRUNC",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=TRUNC(2.9)=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "c566d78e515fc1ef04527dab371208e4fc16261301d97cfa95233b17ff1403e3",
      "observations": []
    },
    {
      "position": 116,
      "id": "formula.function.sign.normal.1",
      "label": "SIGN · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:SIGN",
      "featureLabel": "Function · SIGN",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SIGN(-2)=-1",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "14f74122337db27e55c7f12587305b473c9f3cd816eef19044970f33491a692a",
      "observations": []
    },
    {
      "position": 122,
      "id": "formula.function.pi.normal.1",
      "label": "PI · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:PI",
      "featureLabel": "Function · PI",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=PI()>3.14159",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "8a1516daa9ef289bdb7d0346847c66288e9eb956ac7ffbf776baee9b44e2083c",
      "observations": []
    },
    {
      "position": 123,
      "id": "formula.function.pi.empty.1",
      "label": "PI · Empty",
      "kind": "formula",
      "area": "formula",
      "category": "empty",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:PI",
      "featureLabel": "Function · PI",
      "statusTags": [
        "unsupported"
      ],
      "formula": "=PI()>3.14159",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "unsupported"
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": true,
      "sourceIndex": 7,
      "evidenceIndex": 9,
      "testChecksum": "23bfbb0713d7d908e1d79d63b12900ffb9d07954b0eaf76fd53668a7a0024d8b",
      "observations": []
    },
    {
      "position": 128,
      "id": "formula.function.iferror.normal.1",
      "label": "IFERROR · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:IFERROR",
      "featureLabel": "Function · IFERROR",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=IFERROR(1/0,7)=7",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "a6da00137f9dd8635053a05aee993262f80535b3cfe0bfc19fdb21d19645b057",
      "observations": []
    },
    {
      "position": 134,
      "id": "formula.function.ifna.normal.1",
      "label": "IFNA · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:IFNA",
      "featureLabel": "Function · IFNA",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=IFNA(NA(),7)=7",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "697ebda7f7853d2082434c6e4d685ef36d9ee0588bbadac028215dc8da1d82be",
      "observations": []
    },
    {
      "position": 140,
      "id": "formula.function.ifs.normal.1",
      "label": "IFS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "logical-control",
      "behavior": "shared",
      "featureValue": "function:IFS",
      "featureLabel": "Function · IFS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=IFS(FALSE,1,TRUE,2)=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 9,
      "evidenceIndex": 7,
      "testChecksum": "6f6ab9b93735d3f75507cc50a3c40f10435dedea4d9efb970de44498ec6cad51",
      "observations": []
    },
    {
      "position": 146,
      "id": "formula.function.switch.normal.1",
      "label": "SWITCH · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "logical-control",
      "behavior": "shared",
      "featureValue": "function:SWITCH",
      "featureLabel": "Function · SWITCH",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SWITCH(2,1,3,2,4,5)=4",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 9,
      "evidenceIndex": 7,
      "testChecksum": "87959a9c84986419352e4ef3707e3773a4347bd92028627b8e7069569b3252c9",
      "observations": []
    },
    {
      "position": 152,
      "id": "formula.function.xor.normal.1",
      "label": "XOR · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "logical-control",
      "behavior": "shared",
      "featureValue": "function:XOR",
      "featureLabel": "Function · XOR",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=XOR(TRUE,FALSE)=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 9,
      "evidenceIndex": 7,
      "testChecksum": "2a8984372ed23dee3cd306b4058efd05e31b85efdc90f65690efdf9e51f15223",
      "observations": []
    },
    {
      "position": 158,
      "id": "formula.function.true.normal.1",
      "label": "TRUE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "logical-control",
      "behavior": "shared",
      "featureValue": "function:TRUE",
      "featureLabel": "Function · TRUE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=TRUE()=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 9,
      "evidenceIndex": 7,
      "testChecksum": "70dd18acde893d4c008b8abd2c7043c88c4da704eaa9d08e08c0eb6dabec0d0c",
      "observations": []
    },
    {
      "position": 164,
      "id": "formula.function.false.normal.1",
      "label": "FALSE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "logical-control",
      "behavior": "shared",
      "featureValue": "function:FALSE",
      "featureLabel": "Function · FALSE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=FALSE()=FALSE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 9,
      "evidenceIndex": 7,
      "testChecksum": "5f162ca55ef8360effd4ae4f0eea3cd005f4ed5aec1265f0c448a515fcc3f36d",
      "observations": []
    },
    {
      "position": 170,
      "id": "formula.function.isblank.normal.1",
      "label": "ISBLANK · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:ISBLANK",
      "featureLabel": "Function · ISBLANK",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ISBLANK(C5)=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "06376a3c5111e6b415f89fee28fce474cfec83e3124c56d11e9531004f168b1d",
      "observations": []
    },
    {
      "position": 176,
      "id": "formula.function.isnumber.normal.1",
      "label": "ISNUMBER · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:ISNUMBER",
      "featureLabel": "Function · ISNUMBER",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ISNUMBER(2)=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "d84c71567c4dca810e59bc8d74445c655844f996651ac470cb478c5da2ddfad8",
      "observations": []
    },
    {
      "position": 182,
      "id": "formula.function.istext.normal.1",
      "label": "ISTEXT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:ISTEXT",
      "featureLabel": "Function · ISTEXT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ISTEXT(\"x\")=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "afc6830c1609dba4ef1dd3e800a219a9911e4d611163123237aaa14e9a95e1f5",
      "observations": []
    },
    {
      "position": 188,
      "id": "formula.function.islogical.normal.1",
      "label": "ISLOGICAL · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:ISLOGICAL",
      "featureLabel": "Function · ISLOGICAL",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ISLOGICAL(TRUE)=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "0c6ffe38831d062e837480a6319235f43b272bf8da7d4df2f53d7410cfb7c9fb",
      "observations": []
    },
    {
      "position": 194,
      "id": "formula.function.iserror.normal.1",
      "label": "ISERROR · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:ISERROR",
      "featureLabel": "Function · ISERROR",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ISERROR(1/0)=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "dce3f6ba9e7c4b397b4b9ee80311a7d3fd644c13c48f4a961375e9a4170f61f0",
      "observations": []
    },
    {
      "position": 200,
      "id": "formula.function.iserr.normal.1",
      "label": "ISERR · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:ISERR",
      "featureLabel": "Function · ISERR",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ISERR(1/0)=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "d8dcc0a1a56150d3b993f83e7206e63a4715e4d1fde1cf348792d67b17da44d4",
      "observations": []
    },
    {
      "position": 206,
      "id": "formula.function.isna.normal.1",
      "label": "ISNA · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:ISNA",
      "featureLabel": "Function · ISNA",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ISNA(NA())=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "22c13e5e5b4d1523dfdb6237bab080fc5ce37e0cdd228394848a17ba39ab713a",
      "observations": []
    },
    {
      "position": 212,
      "id": "formula.function.type.normal.1",
      "label": "TYPE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:TYPE",
      "featureLabel": "Function · TYPE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=TYPE(2)=1",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "b91b4ab97f61634b8b3f0367fa0e43cd4cec708b91b03d24ec9e53fbcc1e0286",
      "observations": []
    },
    {
      "position": 218,
      "id": "formula.function.n.normal.1",
      "label": "N · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:N",
      "featureLabel": "Function · N",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=N(TRUE)=1",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "280d5fcb10a398882cd08c750d63e4d65fbb74bea91610521885be25c5e3f7e9",
      "observations": []
    },
    {
      "position": 224,
      "id": "formula.function.t.normal.1",
      "label": "T · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:T",
      "featureLabel": "Function · T",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=T(\"x\")=\"x\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "748cc8d73f7835a079393c7126a41993083f37b4a1b43ea5fcc42c297c9d5b72",
      "observations": []
    },
    {
      "position": 230,
      "id": "formula.function.counta.normal.1",
      "label": "COUNTA · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:COUNTA",
      "featureLabel": "Function · COUNTA",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=COUNTA(1,\"x\",TRUE)=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "8d47d37c5678f73fa70bd6fc5a16ee6c91896029f1a54bd651374248cbd88ed9",
      "observations": []
    },
    {
      "position": 236,
      "id": "formula.function.len.normal.1",
      "label": "LEN · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:LEN",
      "featureLabel": "Function · LEN",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=LEN(\"abc\")=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "7cb826066d7b48a5933fbefad8420f105d2cdabed929972d269d4efa98835ec4",
      "observations": []
    },
    {
      "position": 242,
      "id": "formula.function.left.normal.1",
      "label": "LEFT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:LEFT",
      "featureLabel": "Function · LEFT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=LEFT(\"abc\",2)=\"ab\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "fb68148633e52a8d10688b276a13479ae64d5981c63611480f8b3866f9d5f1e8",
      "observations": []
    },
    {
      "position": 248,
      "id": "formula.function.right.normal.1",
      "label": "RIGHT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:RIGHT",
      "featureLabel": "Function · RIGHT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=RIGHT(\"abc\",2)=\"bc\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "92292ebf4fed4b2e456c22d0d792bac462e23275cbbb04154122390235275202",
      "observations": []
    },
    {
      "position": 254,
      "id": "formula.function.mid.normal.1",
      "label": "MID · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:MID",
      "featureLabel": "Function · MID",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MID(\"abcd\",2,2)=\"bc\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "b26ff637bb4f684f9699bf00b4754e5489321629e21e13d5bb8caa598385214c",
      "observations": []
    },
    {
      "position": 260,
      "id": "formula.function.concat.normal.1",
      "label": "CONCAT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:CONCAT",
      "featureLabel": "Function · CONCAT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=CONCAT(\"a\",\"b\")=\"ab\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "b53528f0cfe2b975b0f19c636716f71b48c52b64416fb4bfdee9e9f06517b2dd",
      "observations": []
    },
    {
      "position": 266,
      "id": "formula.function.upper.normal.1",
      "label": "UPPER · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:UPPER",
      "featureLabel": "Function · UPPER",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=UPPER(\"Abc\")=\"ABC\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "31034c9d34c68963894150b91b2ebf4a0d83f4d3367228926d88800a5759ca2e",
      "observations": []
    },
    {
      "position": 272,
      "id": "formula.function.lower.normal.1",
      "label": "LOWER · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:LOWER",
      "featureLabel": "Function · LOWER",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=LOWER(\"AbC\")=\"abc\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "7061033ea9a97eff951c53d69551fd5dbb5f7d8598596593c5fcc71c41377bf4",
      "observations": []
    },
    {
      "position": 278,
      "id": "formula.function.trim.normal.1",
      "label": "TRIM · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:TRIM",
      "featureLabel": "Function · TRIM",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=TRIM(\" a  b \")=\"a b\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "0e8447e86fdaf27a8fc3f4225252102fb267ead025807772df04380e61af5e40",
      "observations": []
    },
    {
      "position": 284,
      "id": "formula.function.text.normal.1",
      "label": "TEXT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:TEXT",
      "featureLabel": "Function · TEXT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=TEXT(12,\"0\")=\"12\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "320cdbfa1efb3d0332ff628854976aab9eeac53f801caafea3c5e534ae04f046",
      "observations": []
    },
    {
      "position": 290,
      "id": "formula.function.exact.normal.1",
      "label": "EXACT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:EXACT",
      "featureLabel": "Function · EXACT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=EXACT(\"a\",\"a\")=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "905304b0d588aa8fb54cc68c7b237ad5124f12431b7731f6f1ab4f8b2b9d66b4",
      "observations": []
    },
    {
      "position": 296,
      "id": "formula.function.date.normal.1",
      "label": "DATE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:DATE",
      "featureLabel": "Function · DATE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=YEAR(DATE(2020,1,2))=2020",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "24a7d5f0fab4f9bf844330123cf0d5a13d85eb95fedab534fbf9ca657d14a8c4",
      "observations": []
    },
    {
      "position": 302,
      "id": "formula.function.datevalue.normal.1",
      "label": "DATEVALUE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:DATEVALUE",
      "featureLabel": "Function · DATEVALUE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=YEAR(DATEVALUE(\"2020-01-02\"))=2020",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "9caf07e7302ea03386e31fe6f53bab55860c2bf88cd7bb4e3be35c77dfd2327b",
      "observations": []
    },
    {
      "position": 308,
      "id": "formula.function.day.normal.1",
      "label": "DAY · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:DAY",
      "featureLabel": "Function · DAY",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=DAY(DATE(2020,1,2))=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "4beebb19dbbaa0ff325abe03f283d4938998c1d6f24012d3c9ce9192de268bce",
      "observations": []
    },
    {
      "position": 314,
      "id": "formula.function.month.normal.1",
      "label": "MONTH · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:MONTH",
      "featureLabel": "Function · MONTH",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MONTH(DATE(2020,2,1))=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "206bd949a257cf51a34ba3a6d7744b1afb514eaba342145f1d629e9969b51bc5",
      "observations": []
    },
    {
      "position": 320,
      "id": "formula.function.year.normal.1",
      "label": "YEAR · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:YEAR",
      "featureLabel": "Function · YEAR",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=YEAR(DATE(2020,1,1))=2020",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "1186e210a735697508fa0914434dcff4456b947b2b1904dbd8cab395e7593bfb",
      "observations": []
    },
    {
      "position": 326,
      "id": "formula.function.today.normal.1",
      "label": "TODAY · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:TODAY",
      "featureLabel": "Function · TODAY",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ISNUMBER(TODAY())=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "2790dd22926410579665548aa1f575be98d4dd234b9122d80cb93612796f4a93",
      "observations": []
    },
    {
      "position": 332,
      "id": "formula.function.now.normal.1",
      "label": "NOW · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:NOW",
      "featureLabel": "Function · NOW",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ISNUMBER(NOW())=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "895e2e162e9b4714357add8db2d0b6683efa8387108da4223a26b41eda3bfd02",
      "observations": []
    },
    {
      "position": 344,
      "id": "formula.function.countifs.normal.1",
      "label": "COUNTIFS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:COUNTIFS",
      "featureLabel": "Function · COUNTIFS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=COUNTIFS(A1:A3,\">0\",B1:B3,\">1\")=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "3273c62c91f153d699e91ebd5d36ebcc962e9c2d5d0b8f2b9c889c54532276d6",
      "observations": []
    },
    {
      "position": 350,
      "id": "formula.function.sumif.normal.1",
      "label": "SUMIF · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:SUMIF",
      "featureLabel": "Function · SUMIF",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUMIF(A1:A3,\">0\",B1:B3)=5",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "91a01e9bf221663c9a8f47796be42aece07b27ec5059ed18fbb5b12c5f805dc6",
      "observations": []
    },
    {
      "position": 356,
      "id": "formula.function.sumifs.normal.1",
      "label": "SUMIFS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:SUMIFS",
      "featureLabel": "Function · SUMIFS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUMIFS(B1:B3,A1:A3,\">0\")=5",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "f321c1d88534d4c014bb1df4ad7d17ea0f11df12d80ec55b102c1808d36b0c1b",
      "observations": []
    },
    {
      "position": 362,
      "id": "formula.function.averageif.normal.1",
      "label": "AVERAGEIF · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:AVERAGEIF",
      "featureLabel": "Function · AVERAGEIF",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=AVERAGEIF(A1:A3,\">0\",B1:B3)=2.5",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "bec657bcc0add3711495db188ecb254ef830c6716db1134db00d06018b44962e",
      "observations": []
    },
    {
      "position": 368,
      "id": "formula.function.averageifs.normal.1",
      "label": "AVERAGEIFS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:AVERAGEIFS",
      "featureLabel": "Function · AVERAGEIFS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=AVERAGEIFS(B1:B3,A1:A3,\">0\")=2.5",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "163a3fb227b51ee8b30fb8c37f48155db59c9b7d4ef5923de34a26ce81dce519",
      "observations": []
    },
    {
      "position": 374,
      "id": "formula.function.index.normal.1",
      "label": "INDEX · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:INDEX",
      "featureLabel": "Function · INDEX",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=INDEX(A1:B3,2,2)=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "2ee61f9334704ded219f2a386de47fff3007157bf5b948ebecbc81b2c1b14eb5",
      "observations": []
    },
    {
      "position": 380,
      "id": "formula.function.match.normal.1",
      "label": "MATCH · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:MATCH",
      "featureLabel": "Function · MATCH",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MATCH(60,A1:A3,0)=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "f11a76b9b71848d83dced774fb8815bf0ba8826559adad2a5592c1432ced7bae",
      "observations": []
    },
    {
      "position": 392,
      "id": "formula.function.hlookup.normal.1",
      "label": "HLOOKUP · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:HLOOKUP",
      "featureLabel": "Function · HLOOKUP",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=HLOOKUP(-100,A1:B3,2,FALSE)=60",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "6ec5007971ddfde5e1b3cea9e5db7e473c1c936e687a1bfa5f01ce775fd9c956",
      "observations": []
    },
    {
      "position": 398,
      "id": "formula.function.xlookup.normal.1",
      "label": "XLOOKUP · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:XLOOKUP",
      "featureLabel": "Function · XLOOKUP",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=XLOOKUP(60,A1:A3,B1:B3)=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "946f436390ae4acab134968fa560d0460cecc8ef905e5ec200b2eaf4ead7bcad",
      "observations": []
    },
    {
      "position": 404,
      "id": "formula.function.na.normal.1",
      "label": "NA · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "information-error",
      "behavior": "shared",
      "featureValue": "function:NA",
      "featureLabel": "Function · NA",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ISNA(NA())=TRUE",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 10,
      "evidenceIndex": 7,
      "testChecksum": "99d684ecc5401959cc64938fdc11df8f83e04b1ef69615880ec462277ef670e5",
      "observations": []
    },
    {
      "position": 416,
      "id": "formula.function.sort.normal.1",
      "label": "SORT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "array",
      "behavior": "shared",
      "featureValue": "function:SORT",
      "featureLabel": "Function · SORT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=INDEX(SORT(A1:A3),1)=-100",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "4178a86025502fc9caf44e68f0b88b1c1a70b4f23ca7865ab38fc6eb5dc93064",
      "observations": []
    },
    {
      "position": 422,
      "id": "formula.function.unique.normal.1",
      "label": "UNIQUE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "array",
      "behavior": "shared",
      "featureValue": "function:UNIQUE",
      "featureLabel": "Function · UNIQUE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ROWS(UNIQUE(A1:A3))=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "59f4bc2c3f95af8c14712c6667497b590028debc0989adae94c9dd5c300e089d",
      "observations": []
    },
    {
      "position": 428,
      "id": "formula.function.let.normal.1",
      "label": "LET · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "logical-control",
      "behavior": "shared",
      "featureValue": "function:LET",
      "featureLabel": "Function · LET",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=LET(x,2,x+1)=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 9,
      "evidenceIndex": 7,
      "testChecksum": "f5513a065461df6c54113691457c1121187c2250642c1789bbebb13a05b944b4",
      "observations": []
    },
    {
      "position": 434,
      "id": "formula.function.product.normal.1",
      "label": "PRODUCT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:PRODUCT",
      "featureLabel": "Function · PRODUCT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=PRODUCT(2,3,4)=24",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "6073478d7bd8e44eeab6eb8e9d3a932fc85e41b062e514c774fb151131cef186",
      "observations": []
    },
    {
      "position": 440,
      "id": "formula.function.sumproduct.normal.1",
      "label": "SUMPRODUCT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:SUMPRODUCT",
      "featureLabel": "Function · SUMPRODUCT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUMPRODUCT(A1:A3,B1:B3)=200",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "87e5ab56285892486c4d965003e567e52b32712364745d5eb398e59895a1531d",
      "observations": []
    },
    {
      "position": 446,
      "id": "formula.function.power.normal.1",
      "label": "POWER · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:POWER",
      "featureLabel": "Function · POWER",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=POWER(2,3)=8",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "f9fa8feacaac2f8212595eed3fdb4ff8dc91bd2c5c1ce86347dcf260ad074972",
      "observations": []
    },
    {
      "position": 452,
      "id": "formula.function.exp.normal.1",
      "label": "EXP · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:EXP",
      "featureLabel": "Function · EXP",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=EXP(0)=1",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "dfe4591a970ef995fd666afb77f5ad14bdfe6d3026bb86402b6a4293e8871e12",
      "observations": []
    },
    {
      "position": 458,
      "id": "formula.function.ln.normal.1",
      "label": "LN · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:LN",
      "featureLabel": "Function · LN",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=LN(1)=0",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "ad7a24465c20af2badd3db8de9dca3f6c3a378ae10affed5afb728389618a250",
      "observations": []
    },
    {
      "position": 464,
      "id": "formula.function.log.normal.1",
      "label": "LOG · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:LOG",
      "featureLabel": "Function · LOG",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=LOG(8,2)=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "a96a1080fbb239dda8c48275e48cb1b9d66735eae6a83b676c68c0b98cc66d90",
      "observations": []
    },
    {
      "position": 470,
      "id": "formula.function.log10.normal.1",
      "label": "LOG10 · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:LOG10",
      "featureLabel": "Function · LOG10",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=LOG10(100)=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "011899fd85f11be19b8e65ba8a511208e729af469b840d17dad2c24403e8b926",
      "observations": []
    },
    {
      "position": 476,
      "id": "formula.function.roundup.normal.1",
      "label": "ROUNDUP · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:ROUNDUP",
      "featureLabel": "Function · ROUNDUP",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ROUNDUP(2.31,1)=2.4",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "d1476ce571933be733a12a2bbdeedb2de48a577035d1866289550d7944cbc444",
      "observations": []
    },
    {
      "position": 482,
      "id": "formula.function.rounddown.normal.1",
      "label": "ROUNDDOWN · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:ROUNDDOWN",
      "featureLabel": "Function · ROUNDDOWN",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ROUNDDOWN(2.39,1)=2.3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "9f58f774fcf4ac71ae2120429295059769ae1e0ff7b78d1bf92229dc47fcdab2",
      "observations": []
    },
    {
      "position": 488,
      "id": "formula.function.mround.normal.1",
      "label": "MROUND · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:MROUND",
      "featureLabel": "Function · MROUND",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MROUND(10,3)=9",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "fc285a324edf5226ebf76f377a987e57d5f9fab8b87c6c369e02e32a725a2cb8",
      "observations": []
    },
    {
      "position": 494,
      "id": "formula.function.even.normal.1",
      "label": "EVEN · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:EVEN",
      "featureLabel": "Function · EVEN",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=EVEN(3)=4",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "2425120df4744c52d6a56bd0b4eb1a97d0166537f2c20703b88d5276fc69364f",
      "observations": []
    },
    {
      "position": 500,
      "id": "formula.function.odd.normal.1",
      "label": "ODD · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:ODD",
      "featureLabel": "Function · ODD",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ODD(2)=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "47b6a04808fd8ef268fe1318ed51f6b47b78a852bcb3bb88ae8e83c9c33457e9",
      "observations": []
    },
    {
      "position": 506,
      "id": "formula.function.quotient.normal.1",
      "label": "QUOTIENT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:QUOTIENT",
      "featureLabel": "Function · QUOTIENT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=QUOTIENT(7,2)=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "f273a3ffebf4832ea4b10cce30142b7ed316704477d63bf75cdf0fb7d5b2b04c",
      "observations": []
    },
    {
      "position": 512,
      "id": "formula.function.gcd.normal.1",
      "label": "GCD · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:GCD",
      "featureLabel": "Function · GCD",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=GCD(12,18)=6",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "dd319b9a103bc261b5bbfdf0c226ec521404517367117da32786d005851ea14f",
      "observations": []
    },
    {
      "position": 518,
      "id": "formula.function.lcm.normal.1",
      "label": "LCM · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:LCM",
      "featureLabel": "Function · LCM",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=LCM(4,6)=12",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "f77afec2fba635933f9df156ee4726d5d947945dcc2b1fa97b6d8cbd9423d7bf",
      "observations": []
    },
    {
      "position": 524,
      "id": "formula.function.subtotal.normal.1",
      "label": "SUBTOTAL · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "math",
      "behavior": "shared",
      "featureValue": "function:SUBTOTAL",
      "featureLabel": "Function · SUBTOTAL",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUBTOTAL(9,B1:B3)=6",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 7,
      "evidenceIndex": 7,
      "testChecksum": "1b2233d59e3f413451342c195cea5fc9d2a22730e5cec5d34668fe9aa58fb49b",
      "observations": []
    },
    {
      "position": 530,
      "id": "formula.function.textjoin.normal.1",
      "label": "TEXTJOIN · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:TEXTJOIN",
      "featureLabel": "Function · TEXTJOIN",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=TEXTJOIN(\",\",TRUE,\"a\",\"b\")=\"a,b\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "cc3733c9c5802379c6ad1873d92349baaefab68b5e3730420f0dff65f66c40b3",
      "observations": []
    },
    {
      "position": 536,
      "id": "formula.function.substitute.normal.1",
      "label": "SUBSTITUTE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:SUBSTITUTE",
      "featureLabel": "Function · SUBSTITUTE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUBSTITUTE(\"aba\",\"a\",\"x\")=\"xbx\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "d79ba1c1254b44c65b2667495c9a1150e57d876c22d77319b922d720157d56d3",
      "observations": []
    },
    {
      "position": 542,
      "id": "formula.function.replace.normal.1",
      "label": "REPLACE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:REPLACE",
      "featureLabel": "Function · REPLACE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=REPLACE(\"abc\",2,1,\"x\")=\"axc\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "e192c7d4a56fdcce3caeacd8cc109b99ff04d73c8e9c8b2fe73094e8f5200314",
      "observations": []
    },
    {
      "position": 548,
      "id": "formula.function.find.normal.1",
      "label": "FIND · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:FIND",
      "featureLabel": "Function · FIND",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=FIND(\"b\",\"abc\")=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "61b6f1386f6b1fbe96f429772661025b88e99d9fa490af67426d81cfc04c781d",
      "observations": []
    },
    {
      "position": 554,
      "id": "formula.function.search.normal.1",
      "label": "SEARCH · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:SEARCH",
      "featureLabel": "Function · SEARCH",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SEARCH(\"B\",\"abc\")=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "e49ae69fd7954d0cf193ea8bf6c76c8c83a9b7cb4b9cbbe849ca8842db7f6b02",
      "observations": []
    },
    {
      "position": 560,
      "id": "formula.function.value.normal.1",
      "label": "VALUE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:VALUE",
      "featureLabel": "Function · VALUE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=VALUE(\"12.5\")=12.5",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "b1fb9bf00b9a70560845e5c06a589363577731ac7cf5a16e8dea1a99548379a7",
      "observations": []
    },
    {
      "position": 566,
      "id": "formula.function.clean.normal.1",
      "label": "CLEAN · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:CLEAN",
      "featureLabel": "Function · CLEAN",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=CLEAN(CHAR(9)&\"a\")=\"a\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "8ee673d1dd141e33d5b6f8f361e3685a6be377bedb9474e2cb3e1b7e699269b3",
      "observations": []
    },
    {
      "position": 572,
      "id": "formula.function.rept.normal.1",
      "label": "REPT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:REPT",
      "featureLabel": "Function · REPT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=REPT(\"a\",3)=\"aaa\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "00ddbb1e28353752041ce23958516fcfa202894f3b3092a1478d9790145b2128",
      "observations": []
    },
    {
      "position": 578,
      "id": "formula.function.char.normal.1",
      "label": "CHAR · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:CHAR",
      "featureLabel": "Function · CHAR",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=CHAR(65)=\"A\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "79f3cebfbc2f146a4556a539ed0483a44924161b639c32c20f4ff5a3b530c4d2",
      "observations": []
    },
    {
      "position": 584,
      "id": "formula.function.code.normal.1",
      "label": "CODE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:CODE",
      "featureLabel": "Function · CODE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=CODE(\"A\")=65",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "ac637b725b4b61ef8713621d835783343be5d81b70001bf12b48f3cff1ab02bc",
      "observations": []
    },
    {
      "position": 590,
      "id": "formula.function.unichar.normal.1",
      "label": "UNICHAR · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:UNICHAR",
      "featureLabel": "Function · UNICHAR",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=UNICHAR(9731)=\"☃\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "b71413d2c9979bf6c25425bd62c1cb5c6b4b110c43ff6ad1a15ce8b492b78ef9",
      "observations": []
    },
    {
      "position": 596,
      "id": "formula.function.unicode.normal.1",
      "label": "UNICODE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:UNICODE",
      "featureLabel": "Function · UNICODE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=UNICODE(\"☃\")=9731",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "78b2123b51306d5f0e740fc1698cd680064ece408c481bec605e3dbc8d1a7c3e",
      "observations": []
    },
    {
      "position": 602,
      "id": "formula.function.proper.normal.1",
      "label": "PROPER · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:PROPER",
      "featureLabel": "Function · PROPER",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=PROPER(\"hello world\")=\"Hello World\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "e3dab284417dff5e848f7eba5e6f9425788e01bdf66848478388fb1505c33530",
      "observations": []
    },
    {
      "position": 608,
      "id": "formula.function.numbervalue.normal.1",
      "label": "NUMBERVALUE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "text",
      "behavior": "shared",
      "featureValue": "function:NUMBERVALUE",
      "featureLabel": "Function · NUMBERVALUE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=NUMBERVALUE(\"1.5\",\".\",\",\")=1.5",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 11,
      "evidenceIndex": 7,
      "testChecksum": "23ba5b809754798f57384bc789a48a768f11d6b77deb09c05b1bf7bdc216c094",
      "observations": []
    },
    {
      "position": 614,
      "id": "formula.function.time.normal.1",
      "label": "TIME · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:TIME",
      "featureLabel": "Function · TIME",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=TIME(12,0,0)=0.5",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "bcf01e1a8d9f84dadaeaab938d4ab8fce5b5dbcf873e491a039bb6976de55359",
      "observations": []
    },
    {
      "position": 620,
      "id": "formula.function.timevalue.normal.1",
      "label": "TIMEVALUE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:TIMEVALUE",
      "featureLabel": "Function · TIMEVALUE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=TIMEVALUE(\"12:00\")=0.5",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "15f73e17fcb3ce53acbf76ded422e4b0f34e897417ed2df0f57d5aa50ded87f9",
      "observations": []
    },
    {
      "position": 626,
      "id": "formula.function.hour.normal.1",
      "label": "HOUR · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:HOUR",
      "featureLabel": "Function · HOUR",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=HOUR(TIME(7,30,15))=7",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "6295e099a340b76624dac5306b9256377b5951b3ab16ba5ac4cf61ee564b3d4e",
      "observations": []
    },
    {
      "position": 632,
      "id": "formula.function.minute.normal.1",
      "label": "MINUTE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:MINUTE",
      "featureLabel": "Function · MINUTE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MINUTE(TIME(7,30,15))=30",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "7af51dd8858dc4097fe9744fd858f51f7c4cd60ee8627e6079c77f8685a32c1c",
      "observations": []
    },
    {
      "position": 638,
      "id": "formula.function.second.normal.1",
      "label": "SECOND · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:SECOND",
      "featureLabel": "Function · SECOND",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SECOND(TIME(7,30,15))=15",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "acf95303268032f9d635a1587c5e179e6b27195b4673f1281a355244d47bae13",
      "observations": []
    },
    {
      "position": 644,
      "id": "formula.function.days.normal.1",
      "label": "DAYS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:DAYS",
      "featureLabel": "Function · DAYS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=DAYS(DATE(2020,1,3),DATE(2020,1,1))=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "7850dd7a1276ed7a7109dbab07689592edbcc0800630926d2f55d84ba1b7462d",
      "observations": []
    },
    {
      "position": 650,
      "id": "formula.function.edate.normal.1",
      "label": "EDATE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:EDATE",
      "featureLabel": "Function · EDATE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MONTH(EDATE(DATE(2020,1,15),1))=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "6e6cec0ddd198b5d8e2375d5db100d390748da9c5d23d09598609dca05fd49d5",
      "observations": []
    },
    {
      "position": 656,
      "id": "formula.function.eomonth.normal.1",
      "label": "EOMONTH · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:EOMONTH",
      "featureLabel": "Function · EOMONTH",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=DAY(EOMONTH(DATE(2020,1,15),0))=31",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "4069388698bac0bdf8ac1324034f820c5651195adbfbc58c1b428e9af15bc54c",
      "observations": []
    },
    {
      "position": 662,
      "id": "formula.function.weekday.normal.1",
      "label": "WEEKDAY · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:WEEKDAY",
      "featureLabel": "Function · WEEKDAY",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=WEEKDAY(DATE(2020,1,5))=1",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "1844d7efb0cb1d615705232f2e12a34694755dca5f957a7c4a5f561998c94a62",
      "observations": []
    },
    {
      "position": 668,
      "id": "formula.function.weeknum.normal.1",
      "label": "WEEKNUM · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:WEEKNUM",
      "featureLabel": "Function · WEEKNUM",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=WEEKNUM(DATE(2020,1,5))=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "54def1b5958b4d0e052ac6ee1bf39ac90d763196f588ecf6b2ab73364ba287ff",
      "observations": []
    },
    {
      "position": 674,
      "id": "formula.function.workday.normal.1",
      "label": "WORKDAY · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:WORKDAY",
      "featureLabel": "Function · WORKDAY",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=DAYS(WORKDAY(DATE(2020,1,3),1),DATE(2020,1,3))=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "f3dee1325aceb0abce8601534c6bb704cf7d0948b303f120fc5c692b947c8725",
      "observations": []
    },
    {
      "position": 680,
      "id": "formula.function.networkdays.normal.1",
      "label": "NETWORKDAYS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:NETWORKDAYS",
      "featureLabel": "Function · NETWORKDAYS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=NETWORKDAYS(DATE(2020,1,1),DATE(2020,1,3))=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "49b57c874d3b298f3a66c42c8f1c98a617ff005a867a9bcfcbbf8608e6f4305e",
      "observations": []
    },
    {
      "position": 686,
      "id": "formula.function.yearfrac.normal.1",
      "label": "YEARFRAC · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:YEARFRAC",
      "featureLabel": "Function · YEARFRAC",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=YEARFRAC(DATE(2020,1,1),DATE(2020,7,1))=0.5",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "ec351db7e46376a79f4ee05b3e217f3d252e8aab16c71958b21203d276726873",
      "observations": []
    },
    {
      "position": 692,
      "id": "formula.function.days360.normal.1",
      "label": "DAYS360 · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "date-time",
      "behavior": "shared",
      "featureValue": "function:DAYS360",
      "featureLabel": "Function · DAYS360",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=DAYS360(DATE(2020,1,1),DATE(2020,2,1))=30",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 12,
      "evidenceIndex": 7,
      "testChecksum": "61c11a5f4f52a908c506b96d69af62b86515ed153b9287035eadddaa347e8341",
      "observations": []
    },
    {
      "position": 698,
      "id": "formula.function.median.normal.1",
      "label": "MEDIAN · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:MEDIAN",
      "featureLabel": "Function · MEDIAN",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MEDIAN(1,2,9)=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "92e3b297917f05e41e36a39328c1335a0f90e8ab3fc4720f5bb049e6dd0347be",
      "observations": []
    },
    {
      "position": 704,
      "id": "formula.function.mode.sngl.normal.1",
      "label": "MODE.SNGL · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:MODE.SNGL",
      "featureLabel": "Function · MODE.SNGL",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MODE.SNGL(1,2,2,3)=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "5cc9292ea4fd31c028e9dfc76eb8e920c202f231bb159e760ca0135cc35c5f57",
      "observations": []
    },
    {
      "position": 710,
      "id": "formula.function.large.normal.1",
      "label": "LARGE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:LARGE",
      "featureLabel": "Function · LARGE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=LARGE(B1:B3,1)=3",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "3240683eeaff41df5f608b1b86565fa183105efc16067eed144494921bb80424",
      "observations": []
    },
    {
      "position": 716,
      "id": "formula.function.small.normal.1",
      "label": "SMALL · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:SMALL",
      "featureLabel": "Function · SMALL",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SMALL(B1:B3,1)=1",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "8c81f3a4925e11e7549f69796f1f458e60e2b30515ecc047ef7f0e63b0b02dcb",
      "observations": []
    },
    {
      "position": 722,
      "id": "formula.function.rank.eq.normal.1",
      "label": "RANK.EQ · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:RANK.EQ",
      "featureLabel": "Function · RANK.EQ",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=RANK.EQ(3,B1:B3)=1",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "f3d4e8b33517376e197cbfe249e94ad616803cf13fbdfeb297936301a8416947",
      "observations": []
    },
    {
      "position": 728,
      "id": "formula.function.percentile.inc.normal.1",
      "label": "PERCENTILE.INC · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:PERCENTILE.INC",
      "featureLabel": "Function · PERCENTILE.INC",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=PERCENTILE.INC(B1:B3,0.5)=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "30defe17b49d35ceeaf91fc56d1d70ae21c0f6002a955491453666e2a2ed6308",
      "observations": []
    },
    {
      "position": 734,
      "id": "formula.function.quartile.inc.normal.1",
      "label": "QUARTILE.INC · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:QUARTILE.INC",
      "featureLabel": "Function · QUARTILE.INC",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=QUARTILE.INC(B1:B3,2)=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "2b32c7efcf65eec8fe815b537c860a9e9ed5d11b25af2907648ef33f6656a589",
      "observations": []
    },
    {
      "position": 740,
      "id": "formula.function.stdev.s.normal.1",
      "label": "STDEV.S · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:STDEV.S",
      "featureLabel": "Function · STDEV.S",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=STDEV.S(1,2,3)=1",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "8d74cfa47118a7ac669249770a950d7c05775086e06669f27b192363fd78595a",
      "observations": []
    },
    {
      "position": 746,
      "id": "formula.function.stdev.p.normal.1",
      "label": "STDEV.P · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:STDEV.P",
      "featureLabel": "Function · STDEV.P",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ABS(STDEV.P(1,2,3)-SQRT(2/3))<0.000000000001",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "ad03a685e636644baeaa98814bef5884f530b276c11d5f6c513f9ce29528894b",
      "observations": []
    },
    {
      "position": 752,
      "id": "formula.function.var.s.normal.1",
      "label": "VAR.S · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:VAR.S",
      "featureLabel": "Function · VAR.S",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=VAR.S(1,2,3)=1",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "6aef4fec393d5e930e7f0e089d7c8d9cb691e6f53a75fdad7eaafa74f466d7e2",
      "observations": []
    },
    {
      "position": 758,
      "id": "formula.function.var.p.normal.1",
      "label": "VAR.P · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:VAR.P",
      "featureLabel": "Function · VAR.P",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ABS(VAR.P(1,2,3)-2/3)<0.000000000001",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "e87b5a25f3a377ab273e03aa4aeba7ebffa9f7811a6b58ad438c188abd73ab0b",
      "observations": []
    },
    {
      "position": 764,
      "id": "formula.function.geomean.normal.1",
      "label": "GEOMEAN · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:GEOMEAN",
      "featureLabel": "Function · GEOMEAN",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=GEOMEAN(1,4)=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "e29b8af5bbc010a523fd509e60f2700da3a9253c4f285034ca6954c5aa0ba1f1",
      "observations": []
    },
    {
      "position": 770,
      "id": "formula.function.correl.normal.1",
      "label": "CORREL · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:CORREL",
      "featureLabel": "Function · CORREL",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ABS(CORREL(A1:A3,B1:B3)-0.8660254037844386)<0.000000000001",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "0d72faaad0ec295fa13c80ddb62da0d4e60adfe9018ff193687793cc99c05806",
      "observations": []
    },
    {
      "position": 776,
      "id": "formula.function.covariance.s.normal.1",
      "label": "COVARIANCE.S · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:COVARIANCE.S",
      "featureLabel": "Function · COVARIANCE.S",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=COVARIANCE.S(A1:A3,B1:B3)=80",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "da552e150fe88993857aabe4e993d6eec8785dfdc999d5f51c6820fc67cbea70",
      "observations": []
    },
    {
      "position": 782,
      "id": "formula.function.covariance.p.normal.1",
      "label": "COVARIANCE.P · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:COVARIANCE.P",
      "featureLabel": "Function · COVARIANCE.P",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ABS(COVARIANCE.P(A1:A3,B1:B3)-160/3)<0.000000000001",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "c5bb00d3985ae4582072388cf5bfdf4ffe08776a5f1005e424a095c3fe89c342",
      "observations": []
    },
    {
      "position": 788,
      "id": "formula.function.countblank.normal.1",
      "label": "COUNTBLANK · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:COUNTBLANK",
      "featureLabel": "Function · COUNTBLANK",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=COUNTBLANK(C5:C6)=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "eee2f4a0325a43e8b52811f196b9ae584205a979f739b75a13aa583defb93dd4",
      "observations": []
    },
    {
      "position": 794,
      "id": "formula.function.maxifs.normal.1",
      "label": "MAXIFS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:MAXIFS",
      "featureLabel": "Function · MAXIFS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MAXIFS(A1:A3,B1:B3,\">1\")=60",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "f098cd09e7b1ba5b50d9501857a3c696b0bcefa951c882d5d12ddc641a6e69a5",
      "observations": []
    },
    {
      "position": 800,
      "id": "formula.function.minifs.normal.1",
      "label": "MINIFS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "statistical",
      "behavior": "shared",
      "featureValue": "function:MINIFS",
      "featureLabel": "Function · MINIFS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=MINIFS(A1:A3,B1:B3,\">1\")=60",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 8,
      "evidenceIndex": 7,
      "testChecksum": "8cc482cc4ac5ad1832848e1bf8e230c0a14d8ae18743cf381a9947024fac9172",
      "observations": []
    },
    {
      "position": 806,
      "id": "formula.function.xmatch.normal.1",
      "label": "XMATCH · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:XMATCH",
      "featureLabel": "Function · XMATCH",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=XMATCH(60,A1:A3,0)=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "ec37710a6406f23991904982d6bf079a06d4d9a4573210136542fe88d8f9e0eb",
      "observations": []
    },
    {
      "position": 812,
      "id": "formula.function.choose.normal.1",
      "label": "CHOOSE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:CHOOSE",
      "featureLabel": "Function · CHOOSE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=CHOOSE(2,\"a\",\"b\")=\"b\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "14f49cf7aae4478e2e5bb7f90801154d204fed11f8082202b62e941c5e191d0a",
      "observations": []
    },
    {
      "position": 818,
      "id": "formula.function.row.normal.1",
      "label": "ROW · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:ROW",
      "featureLabel": "Function · ROW",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ROW(A2)=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "028000e47ce687f6619067611de7a12b40e602e47b249f614334d9404e867647",
      "observations": []
    },
    {
      "position": 824,
      "id": "formula.function.rows.normal.1",
      "label": "ROWS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:ROWS",
      "featureLabel": "Function · ROWS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ROWS(A1:A3)=3",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "e3b057fadbccedac98ff6cf501e9ad689448d634720c53902634125ccb7522b5",
      "observations": []
    },
    {
      "position": 830,
      "id": "formula.function.column.normal.1",
      "label": "COLUMN · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:COLUMN",
      "featureLabel": "Function · COLUMN",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=COLUMN(B1)=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "9310e577bf3f5f0b949d136dd54db5bae555da97b1d70f5fb25abbfa5c788d37",
      "observations": []
    },
    {
      "position": 836,
      "id": "formula.function.columns.normal.1",
      "label": "COLUMNS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:COLUMNS",
      "featureLabel": "Function · COLUMNS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=COLUMNS(A1:B2)=2",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "77b383388a8f6f68c8ae8119c3fa0e3367f6617f867dfbf5d78c2568bce966ef",
      "observations": []
    },
    {
      "position": 842,
      "id": "formula.function.address.normal.1",
      "label": "ADDRESS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "lookup-reference",
      "behavior": "shared",
      "featureValue": "function:ADDRESS",
      "featureLabel": "Function · ADDRESS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ADDRESS(1,2)=\"$B$1\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "707c7d0b7ebab4f0b322f20b743bb126db1e7aa86eaad2613747b88ad325d3e7",
      "observations": []
    },
    {
      "position": 848,
      "id": "formula.function.transpose.normal.1",
      "label": "TRANSPOSE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "array",
      "behavior": "shared",
      "featureValue": "function:TRANSPOSE",
      "featureLabel": "Function · TRANSPOSE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUM(TRANSPOSE(A1:B2))=-37",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "22bee40564a8fc531e864534a062fa3a1632461d7f076b2c1dfced81f9881049",
      "observations": []
    },
    {
      "position": 854,
      "id": "formula.function.sequence.normal.1",
      "label": "SEQUENCE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "array",
      "behavior": "shared",
      "featureValue": "function:SEQUENCE",
      "featureLabel": "Function · SEQUENCE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUM(SEQUENCE(2,2))=10",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "c2bc3001082c56cc48f9ecede35f1775ab3d7e3aa031fb1a2e96144c53c8aed1",
      "observations": []
    },
    {
      "position": 860,
      "id": "formula.function.take.normal.1",
      "label": "TAKE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "array",
      "behavior": "shared",
      "featureValue": "function:TAKE",
      "featureLabel": "Function · TAKE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUM(TAKE(A1:B3,1))=-99",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "f98afbd611c2fc6202c5e84a7ee705f3f9801cce71eca238f84ce9627d59f85a",
      "observations": []
    },
    {
      "position": 866,
      "id": "formula.function.drop.normal.1",
      "label": "DROP · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "array",
      "behavior": "shared",
      "featureValue": "function:DROP",
      "featureLabel": "Function · DROP",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUM(DROP(A1:B3,1))=125",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "686acda3976bb28858a68456dedff866404cf16a55bfb0f3c8ecc5a23cfe04ab",
      "observations": []
    },
    {
      "position": 872,
      "id": "formula.function.choosecols.normal.1",
      "label": "CHOOSECOLS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "array",
      "behavior": "shared",
      "featureValue": "function:CHOOSECOLS",
      "featureLabel": "Function · CHOOSECOLS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUM(CHOOSECOLS(A1:B3,1))=20",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "4d6b4204a463f929bd93b3e187e5c8c05660cc4aa8a186e846e11bd26a5d65b7",
      "observations": []
    },
    {
      "position": 878,
      "id": "formula.function.chooserows.normal.1",
      "label": "CHOOSEROWS · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "array",
      "behavior": "shared",
      "featureValue": "function:CHOOSEROWS",
      "featureLabel": "Function · CHOOSEROWS",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=SUM(CHOOSEROWS(A1:B3,2))=62",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 5,
      "evidenceIndex": 7,
      "testChecksum": "e9affbba84ed12095669b13af60aa0d50ef7002536a7c42488b4eded04aa7fb7",
      "observations": []
    },
    {
      "position": 884,
      "id": "formula.function.pv.normal.1",
      "label": "PV · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "financial",
      "behavior": "shared",
      "featureValue": "function:PV",
      "featureLabel": "Function · PV",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=PV(0,2,-10)=20",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 13,
      "evidenceIndex": 7,
      "testChecksum": "fda0203ccd15c8efff4b94c71a09a5d7983e32921991d33f74b15980fca5c0f0",
      "observations": []
    },
    {
      "position": 890,
      "id": "formula.function.fv.normal.1",
      "label": "FV · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "financial",
      "behavior": "shared",
      "featureValue": "function:FV",
      "featureLabel": "Function · FV",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=FV(0,2,-10)=20",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 13,
      "evidenceIndex": 7,
      "testChecksum": "37f0837b0316ffa537f51cc03eafb29b2c1629dbb8a341a08c622995bf0570a0",
      "observations": []
    },
    {
      "position": 896,
      "id": "formula.function.pmt.normal.1",
      "label": "PMT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "financial",
      "behavior": "shared",
      "featureValue": "function:PMT",
      "featureLabel": "Function · PMT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=PMT(0,2,20)=-10",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 13,
      "evidenceIndex": 7,
      "testChecksum": "27ddad3c75afda8d0ebb11d0727b8cfc35832247f62a50326899dc219754d1f2",
      "observations": []
    },
    {
      "position": 902,
      "id": "formula.function.npv.normal.1",
      "label": "NPV · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "financial",
      "behavior": "shared",
      "featureValue": "function:NPV",
      "featureLabel": "Function · NPV",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=NPV(0,10,20)=30",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 13,
      "evidenceIndex": 7,
      "testChecksum": "e389ff55848ab547e5fb4c03edab299a65741e3d40e0ce664848beecc8566246",
      "observations": []
    },
    {
      "position": 908,
      "id": "formula.function.irr.normal.1",
      "label": "IRR · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "financial",
      "behavior": "shared",
      "featureValue": "function:IRR",
      "featureLabel": "Function · IRR",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ABS(NPV(IRR(A1:A3),A2:A3)+A1)<0.0000001",
      "target": "D4",
      "inputs": [
        {
          "cell": "A1",
          "value": -100
        },
        {
          "cell": "A2",
          "value": 60
        },
        {
          "cell": "A3",
          "value": 60
        },
        {
          "cell": "B1",
          "value": 1
        },
        {
          "cell": "B2",
          "value": 2
        },
        {
          "cell": "B3",
          "value": 3
        }
      ],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 13,
      "evidenceIndex": 7,
      "testChecksum": "c0279312f024c4afd989e521c9c125c3c48f8dc80342af133dbeaa97921236fb",
      "observations": []
    },
    {
      "position": 914,
      "id": "formula.function.rate.normal.1",
      "label": "RATE · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "financial",
      "behavior": "shared",
      "featureValue": "function:RATE",
      "featureLabel": "Function · RATE",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=ABS(RATE(1,0,-100,110)-0.1)<0.0000001",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 13,
      "evidenceIndex": 7,
      "testChecksum": "eb4b27bdf2597bfdf41f82582b5bfd7c584219236f5851d2ffb0c6c6f2483487",
      "observations": []
    },
    {
      "position": 920,
      "id": "formula.function.ipmt.normal.1",
      "label": "IPMT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "financial",
      "behavior": "shared",
      "featureValue": "function:IPMT",
      "featureLabel": "Function · IPMT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=IPMT(0,1,10,1000)=0",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 13,
      "evidenceIndex": 7,
      "testChecksum": "01c3cf827a716b7db30ce7c25da06dc260445d98a679be99756f7e187a64f1e8",
      "observations": []
    },
    {
      "position": 926,
      "id": "formula.function.ppmt.normal.1",
      "label": "PPMT · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "financial",
      "behavior": "shared",
      "featureValue": "function:PPMT",
      "featureLabel": "Function · PPMT",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=PPMT(0,1,10,1000)=-100",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 13,
      "evidenceIndex": 7,
      "testChecksum": "f0517d7d74aa737d4f572d1998e4f9922db5b67448c863cc70d1211eeb3ac016",
      "observations": []
    },
    {
      "position": 938,
      "id": "formula.operator.subtract.normal.1",
      "label": "subtract · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:subtract",
      "featureLabel": "Operator · subtract",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=5-2=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 0,
      "evidenceIndex": 7,
      "testChecksum": "4e8fecb50fed4f3623abb6bf63946dbdc5d7a4d159eae1f9055c84bcc29809d2",
      "observations": []
    },
    {
      "position": 944,
      "id": "formula.operator.multiply.normal.1",
      "label": "multiply · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:multiply",
      "featureLabel": "Operator · multiply",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=3*4=12",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 0,
      "evidenceIndex": 7,
      "testChecksum": "41ab000e335843d5f35a14f5b84d9425e980320019f3551af62e387aa3fc87b8",
      "observations": []
    },
    {
      "position": 950,
      "id": "formula.operator.divide.normal.1",
      "label": "divide · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:divide",
      "featureLabel": "Operator · divide",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=8/2=4",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 0,
      "evidenceIndex": 7,
      "testChecksum": "6998effd178327cccb8ebc76644821f0e8b9f90842bbee494a9fffcc0ed65aac",
      "observations": []
    },
    {
      "position": 956,
      "id": "formula.operator.power.normal.1",
      "label": "power · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:power",
      "featureLabel": "Operator · power",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=2^3=8",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 0,
      "evidenceIndex": 7,
      "testChecksum": "b0394454d00be69349dd555248cc267ea1c8af017a4c3247d744418c9d2dfbee",
      "observations": []
    },
    {
      "position": 962,
      "id": "formula.operator.concatenate.normal.1",
      "label": "concatenate · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:concatenate",
      "featureLabel": "Operator · concatenate",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=\"a\"&\"b\"=\"ab\"",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 14,
      "evidenceIndex": 7,
      "testChecksum": "a60011fa9ee350d64b5369419553824989c8fa2cf71a28388a337fae40f3bfa5",
      "observations": []
    },
    {
      "position": 968,
      "id": "formula.operator.equal.normal.1",
      "label": "equal · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:equal",
      "featureLabel": "Operator · equal",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=2=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 15,
      "evidenceIndex": 7,
      "testChecksum": "7f4eb695ce6cc21ffdf7120209174300b83d8d02ec7f31c8892734d10d2e4c9c",
      "observations": []
    },
    {
      "position": 974,
      "id": "formula.operator.not-equal.normal.1",
      "label": "not-equal · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:not-equal",
      "featureLabel": "Operator · not-equal",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=2<>3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 15,
      "evidenceIndex": 7,
      "testChecksum": "d8786b163ea55148e5c86d3af6e0017151b484fdeb1057e1aead37c796504c0e",
      "observations": []
    },
    {
      "position": 980,
      "id": "formula.operator.less-than.normal.1",
      "label": "less-than · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:less-than",
      "featureLabel": "Operator · less-than",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=2<3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 15,
      "evidenceIndex": 7,
      "testChecksum": "6a2b0b1e3c6ed1596a1a644de9557ec4dbbebd18aa5cdda6a3676308b0ed7673",
      "observations": []
    },
    {
      "position": 986,
      "id": "formula.operator.less-than-or-equal.normal.1",
      "label": "less-than-or-equal · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:less-than-or-equal",
      "featureLabel": "Operator · less-than-or-equal",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=2<=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 15,
      "evidenceIndex": 7,
      "testChecksum": "d9b89efbad927214a858fcfd01d425f9a6559557dc68b9cd37122d0e75865921",
      "observations": []
    },
    {
      "position": 992,
      "id": "formula.operator.greater-than.normal.1",
      "label": "greater-than · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:greater-than",
      "featureLabel": "Operator · greater-than",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=3>2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 15,
      "evidenceIndex": 7,
      "testChecksum": "e662cab1ff26bf9e5174196f8d05ca043a5957ffb24837fff6ac96b823696a00",
      "observations": []
    },
    {
      "position": 998,
      "id": "formula.operator.greater-than-or-equal.normal.1",
      "label": "greater-than-or-equal · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:greater-than-or-equal",
      "featureLabel": "Operator · greater-than-or-equal",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=3>=3",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 15,
      "evidenceIndex": 7,
      "testChecksum": "3a428c0d22ffa2bbaad0ac2bec60623530b763043b1167e342892b6d11722bad",
      "observations": []
    },
    {
      "position": 1004,
      "id": "formula.operator.percent.normal.1",
      "label": "percent · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:percent",
      "featureLabel": "Operator · percent",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=50%=0.5",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 0,
      "evidenceIndex": 7,
      "testChecksum": "fc4b2d0d5ace06cbe620dd17ba5e1df4991be205ab805a7acc8420f0922827bc",
      "observations": []
    },
    {
      "position": 1010,
      "id": "formula.operator.unary-plus.normal.1",
      "label": "unary-plus · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:unary-plus",
      "featureLabel": "Operator · unary-plus",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=+2=2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 0,
      "evidenceIndex": 7,
      "testChecksum": "2b3d741ab9d6263cb7c664eb1014540618251024a1a34f1bed95fdc6bea539d3",
      "observations": []
    },
    {
      "position": 1016,
      "id": "formula.operator.unary-minus.normal.1",
      "label": "unary-minus · Normal",
      "kind": "formula",
      "area": "formula",
      "category": "normal",
      "family": "operator",
      "behavior": "shared",
      "featureValue": "operator:unary-minus",
      "featureLabel": "Operator · unary-minus",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "formula": "=-2=-2",
      "target": "D4",
      "inputs": [],
      "expected": {
        "type": "boolean",
        "value": true
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 0,
      "evidenceIndex": 7,
      "testChecksum": "5aee69629a3b16dccfbd132f5cdb5c6058621d7e77667aa8699badf0791add4c",
      "observations": []
    },
    {
      "position": 2002,
      "id": "mutation.sequence.001",
      "label": "Edit Precedent + Fill Formula · Mutation",
      "kind": "mutation",
      "area": "mutation",
      "category": "mutation",
      "family": "document-mutation",
      "behavior": "shared",
      "featureValue": "feature:edit-sequences",
      "featureLabel": "Feature · Edit sequences",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "operations": [
        {
          "op": "edit-precedent"
        },
        {
          "op": "fill-formula"
        }
      ],
      "expected": {
        "type": "workbook",
        "value": {
          "passed": 2
        }
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 16,
      "evidenceIndex": 10,
      "testChecksum": "437d4066103b7968bb47f4b57dc87c70062b1a2841d5457f024fd6fe1cc96725",
      "observations": []
    },
    {
      "position": 2252,
      "id": "workbook.scenario.001",
      "label": "Sheets · Normal",
      "kind": "workbook",
      "area": "workbook",
      "category": "normal",
      "family": "workbook-state",
      "behavior": "shared",
      "featureValue": "feature:workbook-changes",
      "featureLabel": "Feature · Workbook changes",
      "statusTags": [
        "local-pass",
        "result-unavailable"
      ],
      "operations": [
        {
          "op": "sheets"
        }
      ],
      "expected": {
        "type": "workbook",
        "value": {
          "passed": 1
        }
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 17,
      "evidenceIndex": 11,
      "testChecksum": "f3cc0a7b5692721e2d36f4a84d05855782e6e76c48a0f36dfaa47e7ab921a405",
      "observations": []
    },
    {
      "position": 2265,
      "id": "workbook.scenario.014",
      "label": "Warnings · Boundary",
      "kind": "workbook",
      "area": "workbook",
      "category": "boundary",
      "family": "workbook-state",
      "behavior": "shared",
      "featureValue": "feature:workbook-changes",
      "featureLabel": "Feature · Workbook changes",
      "statusTags": [
        "local-pass",
        "result-unavailable",
        "warning"
      ],
      "operations": [
        {
          "op": "warnings"
        }
      ],
      "expected": {
        "type": "workbook",
        "value": {
          "passed": 1
        }
      },
      "tolerance": {
        "kind": "exact"
      },
      "unsupported": false,
      "sourceIndex": 17,
      "evidenceIndex": 11,
      "testChecksum": "8477e87b2ca1ae584aeef33eda7c524ff41dc0d543bc2c5be34ea4ae41647481",
      "observations": []
    }
  ]
}
