assay
test suite

parser

34 tests · 29 with documented divergences

Test Subject Formula Category DVs
convert-feet-to-inches CONVERT =CONVERT(1, "ft", "in") value 2
convert-meters-to-feet CONVERT =CONVERT(1, "m", "ft") value
convert-kilograms-to-pounds CONVERT =CONVERT(1, "kg", "lbm") value
convert-celsius-to-fahrenheit CONVERT =CONVERT(100, "C", "F") value 2
convert-hours-to-seconds CONVERT =CONVERT(1, "hr", "sec") value 1
convert-kilometers-to-miles CONVERT =CONVERT(1, "km", "mi") value
convert-invalid-unit-pair CONVERT =CONVERT(1, "ft", "kg") value
convert-unknown-unit CONVERT =CONVERT(1, "xyz", "in") value
to-date-from-serial TO_DATE =TO_DATE(44000) value 2
to-date-zero-serial TO_DATE =TO_DATE(0) value 2
to-date-from-text TO_DATE =TO_DATE("2024-01-15") value 2
to-date-from-boolean TO_DATE =TO_DATE(TRUE) value 2
to-date-from-invalid-text TO_DATE =TO_DATE("not-a-date") value 2
to-dollars-integer TO_DOLLARS =TO_DOLLARS(1234) value 2
to-dollars-decimal TO_DOLLARS =TO_DOLLARS(1234.567) value 2
to-dollars-negative TO_DOLLARS =TO_DOLLARS(-42.5) value 2
to-dollars-from-text TO_DOLLARS =TO_DOLLARS("99.99") value 2
to-dollars-from-boolean TO_DOLLARS =TO_DOLLARS(TRUE) value 2
to-percent-decimal TO_PERCENT =TO_PERCENT(0.25) value 2
to-percent-whole-number TO_PERCENT =TO_PERCENT(1) value 2
to-percent-zero TO_PERCENT =TO_PERCENT(0) value 2
to-percent-from-text TO_PERCENT =TO_PERCENT("0.5") value 2
to-percent-negative TO_PERCENT =TO_PERCENT(-0.1) value 2
to-pure-number-from-percent-literal TO_PURE_NUMBER =TO_PURE_NUMBER(0.25) value 2
to-pure-number-from-integer TO_PURE_NUMBER =TO_PURE_NUMBER(42) value 2
to-pure-number-from-text TO_PURE_NUMBER =TO_PURE_NUMBER("123.45") value 2
to-pure-number-from-boolean TO_PURE_NUMBER =TO_PURE_NUMBER(TRUE) value 2
to-pure-number-from-non-numeric-text TO_PURE_NUMBER =TO_PURE_NUMBER("hello") value 2
to-text-integer TO_TEXT =TO_TEXT(42) value 2
to-text-decimal TO_TEXT =TO_TEXT(3.14159) value 2
to-text-boolean TO_TEXT =TO_TEXT(TRUE) value 2
to-text-already-text TO_TEXT =TO_TEXT("hello") value 2
to-text-from-date-serial TO_TEXT =TO_TEXT(A1) value 2
to-text-negative-number TO_TEXT =TO_TEXT(-1234.5) value 2