grammar math;

prog: expr EOF;

expr:

expr '.' ISNUMBER '(' ')' # ISNUMBER_fun

| expr '.' ISTEXT '(' ')' # ISTEXT_fun

| expr '.' ISNONTEXT '(' ')' # ISNONTEXT_fun

| expr '.' ISLOGICAL '(' ')' # ISLOGICAL_fun

| expr '.' ISERROR '(' expr? ')' # ISERROR_fun

| expr '.' ISNULL '(' expr? ')' # ISNULL_fun

| expr '.' ISNULLORERROR '(' expr? ')' # ISNULLORERROR_fun

| expr '.' INT '(' ')' # INT_fun

| expr '.' EXACT '(' expr ')' # EXACT_fun

| expr '.' LEFT '(' expr? ')' # LEFT_fun

| expr '.' LEN '(' ')' # LEN_fun

| expr '.' LOWER '(' ')' # LOWER_fun

| expr '.' MID '(' expr ',' expr ')' # MID_fun

| expr '.' REPLACE '(' expr ',' expr (',' expr)? ')' # REPLACE_fun

| expr '.' RIGHT '(' expr? ')' # RIGHT_fun

| expr '.' RMB '(' ')' # RMB_fun

| expr '.' T '(' ')' # T_fun

| expr '.' TEXT '(' expr ')' # TEXT_fun

| expr '.' TRIM '(' ')' # TRIM_fun

| expr '.' UPPER '(' ')' # UPPER_fun

| expr '.' VALUE '(' ')' # VALUE_fun

| expr '.' DATEVALUE '(' expr? ')' # DATEVALUE_fun

| expr '.' TIMEVALUE '(' ')' # TIMEVALUE_fun

| expr '.' YEAR ('(' ')')? # YEAR_fun

| expr '.' MONTH ('(' ')')? # MONTH_fun

| expr '.' DAY ('(' ')')? # DAY_fun

| expr '.' HOUR ('(' ')')? # HOUR_fun

| expr '.' MINUTE ('(' ')')? # MINUTE_fun

| expr '.' SECOND ('(' ')')? # SECOND_fun

| expr '.' URLENCODE '(' ')' # URLENCODE_fun

| expr '.' URLDECODE '(' ')' # URLDECODE_fun

| expr '.' REGEX '(' expr ')' # REGEX_fun

| expr '.' REGEXREPLACE '(' expr ',' expr ')' # REGEXREPLACE_fun

| expr '.' ISREGEX '(' expr ')' # ISREGEX_fun

| expr '.' MD5 '(' ')' # MD5_fun

| expr '.' SHA1 '(' ')' # SHA1_fun

| expr '.' SHA256 '(' ')' # SHA256_fun

| expr '.' SHA512 '(' ')' # SHA512_fun

| expr '.' TRIMSTART '(' expr? ')' # TRIMSTART_fun

| expr '.' TRIMEND '(' expr? ')' # TRIMEND_fun

| expr '.' INDEXOF '(' expr (',' expr (',' expr)?)? ')' # INDEXOF_fun

| expr '.' LASTINDEXOF '(' expr (',' expr (',' expr)?)? ')' # LASTINDEXOF_fun

| expr '.' SPLIT '(' expr ')' # SPLIT_fun

| expr '.' JOIN '(' expr (',' expr)* ')' # JOIN_fun

| expr '.' SUBSTRING '(' expr (',' expr)? ')' # SUBSTRING_fun

| expr '.' STARTSWITH '(' expr (',' expr)? ')' # STARTSWITH_fun

| expr '.' ENDSWITH '(' expr (',' expr)? ')' # ENDSWITH_fun

| expr '.' ISNULLOREMPTY '(' ')' # ISNULLOREMPTY_fun

| expr '.' ISNULLORWHITESPACE '(' ')' # ISNULLORWHITESPACE_fun

| expr '.' REMOVESTART '(' expr (',' expr)? ')' # REMOVESTART_fun

| expr '.' REMOVEEND '(' expr (',' expr)? ')' # REMOVEEND_fun

| expr '.' JSON '(' ')' # JSON_fun

| expr '.' PARAMETER '(' (expr (',' expr)*)? ')' # DiyFunction_fun

| expr '.' ADDYEARS '(' expr ')' # ADDYEARS_fun

| expr '.' ADDMONTHS '(' expr ')' # ADDMONTHS_fun

| expr '.' ADDDAYS '(' expr ')' # ADDDAYS_fun

| expr '.' ADDHOURS '(' expr ')' # ADDHOURS_fun

| expr '.' ADDMINUTES '(' expr ')' # ADDMINUTES_fun

| expr '.' ADDSECONDS '(' expr ')' # ADDSECONDS_fun

| expr '.' TIMESTAMP '(' expr? ')' # TIMESTAMP_fun

| expr '.' HAS '(' expr ')' # HAS_fun

| expr '.' HASVALUE '(' expr ')' # HASVALUE_fun

| expr '[' PARAMETER ']' # GetJsonValue_fun

| expr '[' expr ']' # GetJsonValue_fun

| expr '.' parameter2 # GetJsonValue_fun

// 运算符优先级 开始

| '(' expr ')' # Bracket_fun

| '!' expr # NOT_fun

| expr '%' # Percentage_fun

| expr op = ('*' | '/' | '%') expr # MulDiv_fun

| expr op = ('+' | '-' | '&') expr # AddSub_fun

| expr op = ('>' | '>=' | '<' | '<=') expr # Judge_fun

| expr op = ('=' | '==' | '===' | '!==' | '!=' | '<>') expr # Judge_fun

| expr op = '&&' expr # AndOr_fun

| expr op = '||' expr # AndOr_fun

| expr '?' expr ':' expr # IF_fun

// 运算符优先级 结束

| ARRAY '(' expr (',' expr)* ')' # Array_fun

| IF '(' expr ',' expr (',' expr)? ')' # IF_fun

| IFS '(' expr ',' expr (',' expr ',' expr)* ')' # IFS_fun

| SWITCH '(' expr ',' expr ',' expr (',' expr ',' expr)* ')' # SWITCH_fun

| ISNUMBER '(' expr ')' # ISNUMBER_fun

| ISTEXT '(' expr ')' # ISTEXT_fun

| ISERROR '(' expr (',' expr)? ')' # ISERROR_fun

| ISNONTEXT '(' expr ')' # ISNONTEXT_fun

| ISLOGICAL '(' expr ')' # ISLOGICAL_fun

| ISEVEN '(' expr ')' # ISEVEN_fun

| ISODD '(' expr ')' # ISODD_fun

| IFERROR '(' expr ',' expr (',' expr)? ')' # IFERROR_fun

| ISNULL '(' expr (',' expr)? ')' # ISNULL_fun

| ISNULLORERROR '(' expr (',' expr)? ')' # ISNULLORERROR_fun

| AND '(' expr (',' expr)* ')' # AND_fun

| OR '(' expr (',' expr)* ')' # OR_fun

| XOR '(' expr (',' expr)* ')' # XOR_fun

| NOT '(' expr ')' # NOT_fun

| TRUE ('(' ')')? # TRUE_fun

| FALSE ('(' ')')? # FALSE_fun

| E ('(' ')')? # E_fun

| PI ('(' ')')? # PI_fun

| DEC2BIN ('(' expr (',' expr)? ')') # DEC2BIN_fun

| DEC2HEX ('(' expr (',' expr)? ')') # DEC2HEX_fun

| DEC2OCT ('(' expr (',' expr)? ')') # DEC2OCT_fun

| HEX2BIN ('(' expr (',' expr)? ')') # HEX2BIN_fun

| HEX2DEC ('(' expr (',' expr)? ')') # HEX2DEC_fun

| HEX2OCT ('(' expr (',' expr)? ')') # HEX2OCT_fun

| OCT2BIN ('(' expr (',' expr)? ')') # OCT2BIN_fun

| OCT2DEC ('(' expr (',' expr)? ')') # OCT2DEC_fun

| OCT2HEX ('(' expr (',' expr)? ')') # OCT2HEX_fun

| BIN2OCT ('(' expr (',' expr)? ')') # BIN2OCT_fun

| BIN2DEC ('(' expr (',' expr)? ')') # BIN2DEC_fun

| BIN2HEX ('(' expr (',' expr)? ')') # BIN2HEX_fun

| ABS '(' expr ')' # ABS_fun

| QUOTIENT '(' expr (',' expr) ')' # QUOTIENT_fun

| MOD '(' expr (',' expr) ')' # MOD_fun

| SIGN '(' expr ')' # SIGN_fun

| SQRT '(' expr ')' # SQRT_fun

| TRUNC '(' expr ')' # TRUNC_fun

| INT '(' expr ')' # INT_fun

| GCD '(' expr (',' expr)* ')' # GCD_fun

| LCM '(' expr (',' expr)* ')' # LCM_fun

| COMBIN '(' expr ',' expr ')' # COMBIN_fun

| PERMUT '(' expr ',' expr ')' # PERMUT_fun

| DEGREES '(' expr ')' # DEGREES_fun

| RADIANS '(' expr ')' # RADIANS_fun

| COS '(' expr ')' # COS_fun

| COSH '(' expr ')' # COSH_fun

| SIN '(' expr ')' # SIN_fun

| SINH '(' expr ')' # SINH_fun

| TAN '(' expr ')' # TAN_fun

| TANH '(' expr ')' # TANH_fun

| COT '(' expr ')' # COT_fun

| COTH '(' expr ')' # COTH_fun

| CSC '(' expr ')' # CSC_fun

| CSCH '(' expr ')' # CSCH_fun

| SEC '(' expr ')' # SEC_fun

| SECH '(' expr ')' # SECH_fun

| ACOS '(' expr ')' # ACOS_fun

| ACOSH '(' expr ')' # ACOSH_fun

| ASIN '(' expr ')' # ASIN_fun

| ASINH '(' expr ')' # ASINH_fun

| ATAN '(' expr ')' # ATAN_fun

| ATANH '(' expr ')' # ATANH_fun

| ACOT '(' expr ')' # ACOT_fun

| ACOTH '(' expr ')' # ACOTH_fun

| ATAN2 '(' expr ',' expr ')' # ATAN2_fun

| ROUND '(' expr (',' expr)? ')' # ROUND_fun

| ROUNDDOWN '(' expr ',' expr ')' # ROUNDDOWN_fun

| ROUNDUP '(' expr ',' expr ')' # ROUNDUP_fun

| CEILING '(' expr (',' expr)? ')' # CEILING_fun

| FLOOR '(' expr (',' expr)? ')' # FLOOR_fun

| EVEN '(' expr ')' # EVEN_fun

| ODD '(' expr ')' # ODD_fun

| MROUND '(' expr ',' expr ')' # MROUND_fun

| RAND '(' ')' # RAND_fun

| RANDBETWEEN '(' expr ',' expr ')' # RANDBETWEEN_fun

| FACT '(' expr ')' # FACT_fun

| FACTDOUBLE '(' expr ')' # FACTDOUBLE_fun

| POWER '(' expr ',' expr ')' # POWER_fun

| EXP '(' expr ')' # EXP_fun

| LN '(' expr ')' # LN_fun

| LOG '(' expr (',' expr)? ')' # LOG_fun

| LOG10 '(' expr ')' # LOG10_fun

| MULTINOMIAL '(' expr (',' expr)* ')' # MULTINOMIAL_fun

| PRODUCT '(' expr (',' expr)* ')' # PRODUCT_fun

| SQRTPI '(' expr ')' # SQRTPI_fun

| ERF '(' expr ')' # ERF_fun

| ERFC '(' expr ')' # ERFC_fun

| BESSELI '(' expr ',' expr ')' # BESSELI_fun

| BESSELJ '(' expr ',' expr ')' # BESSELJ_fun

| BESSELK '(' expr ',' expr ')' # BESSELK_fun

| BESSELY '(' expr ',' expr ')' # BESSELY_fun

| DELTA '(' expr (',' expr)? ')' # DELTA_fun

| GESTEP '(' expr (',' expr)? ')' # GESTEP_fun

| SUMSQ '(' expr (',' expr)* ')' # SUMSQ_fun

| SUMPRODUCT '(' expr (',' expr)* ')' # SUMPRODUCT_fun

| SUMX2MY2 '(' expr ',' expr ')' # SUMX2MY2_fun

| SUMX2PY2 '(' expr ',' expr ')' # SUMX2PY2_fun

| SUMXMY2 '(' expr ',' expr ')' # SUMXMY2_fun

| ARABIC '(' expr ')' # ARABIC_fun

| ROMAN '(' expr (',' expr)? ')' # ROMAN_fun

| SERIESSUM '(' expr ',' expr ',' expr ',' expr ')' # SERIESSUM_fun

| RANK '(' expr ',' expr (',' expr)? ')' # RANK_fun

| FORECAST '(' expr ',' expr ',' expr ')' # FORECAST_fun

| INTERCEPT '(' expr ',' expr ')' # INTERCEPT_fun

| SLOPE '(' expr ',' expr ')' # SLOPE_fun

| CORREL '(' expr ',' expr ')' # CORREL_fun

| PEARSON '(' expr ',' expr ')' # PEARSON_fun

| YEARFRAC '(' expr ',' expr (',' expr)? ')' # YEARFRAC_fun

| ASC '(' expr ')' # ASC_fun

| JIS '(' expr ')' # JIS_fun

| CHAR '(' expr ')' # CHAR_fun

| CLEAN '(' expr ')' # CLEAN_fun

| CODE '(' expr ')' # CODE_fun

| UNICHAR '(' expr ')' # UNICHAR_fun

| UNICODE '(' expr ')' # UNICODE_fun

| CONCATENATE '(' expr (',' expr)* ')' # CONCATENATE_fun

| EXACT '(' expr ',' expr ')' # EXACT_fun

| FIND '(' expr ',' expr (',' expr)? ')' # FIND_fun

| FIXED '(' expr (',' expr (',' expr)?)? ')' # FIXED_fun

| LEFT '(' expr (',' expr)? ')' # LEFT_fun

| LEN '(' expr ')' # LEN_fun

| LOWER '(' expr ')' # LOWER_fun

| MID '(' expr ',' expr ',' expr ')' # MID_fun

| PROPER '(' expr ')' # PROPER_fun

| REPLACE '(' expr ',' expr ',' expr (',' expr)? ')' # REPLACE_fun

| REPT '(' expr ',' expr ')' # REPT_fun

| RIGHT '(' expr (',' expr)? ')' # RIGHT_fun

| RMB '(' expr ')' # RMB_fun

| SEARCH '(' expr ',' expr (',' expr)? ')' # SEARCH_fun

| SUBSTITUTE '(' expr ',' expr ',' expr (',' expr)? ')' # SUBSTITUTE_fun

| T '(' expr ')' # T_fun

| TEXT '(' expr ',' expr ')' # TEXT_fun

| TRIM '(' expr ')' # TRIM_fun

| UPPER '(' expr ')' # UPPER_fun

| VALUE '(' expr ')' # VALUE_fun

| DATEVALUE '(' expr (',' expr)? ')' # DATEVALUE_fun

| TIMEVALUE '(' expr ')' # TIMEVALUE_fun

| DATE '(' expr ',' expr ',' expr (

',' expr (',' expr (',' expr)?)?

)? ')' # DATE_fun

| TIME '(' expr ',' expr (',' expr)? ')' # TIME_fun

| NOW '(' ')' # NOW_fun

| TODAY '(' ')' # TODAY_fun

| YEAR '(' expr ')' # YEAR_fun

| MONTH '(' expr ')' # MONTH_fun

| DAY '(' expr ')' # DAY_fun

| HOUR '(' expr ')' # HOUR_fun

| MINUTE '(' expr ')' # MINUTE_fun

| SECOND '(' expr ')' # SECOND_fun

| WEEKDAY '(' expr (',' expr)? ')' # WEEKDAY_fun

| DATEDIF '(' expr ',' expr ',' expr ')' # DATEDIF_fun

| DAYS '(' expr ',' expr ')' # DAYS_fun

| DAYS360 '(' expr ',' expr (',' expr)? ')' # DAYS360_fun

| EDATE '(' expr ',' expr ')' # EDATE_fun

| EOMONTH '(' expr ',' expr ')' # EOMONTH_fun

| NETWORKDAYS '(' expr ',' expr (',' expr)? ')' # NETWORKDAYS_fun

| WORKDAY '(' expr ',' expr (',' expr)? ')' # WORKDAY_fun

| WEEKNUM '(' expr (',' expr)? ')' # WEEKNUM_fun

| MAX '(' expr (',' expr)* ')' # MAX_fun

| MEDIAN '(' expr (',' expr)* ')' # MEDIAN_fun

| MIN '(' expr (',' expr)* ')' # MIN_fun

| QUARTILE '(' expr ',' expr ')' # QUARTILE_fun

| MODE '(' expr (',' expr)* ')' # MODE_fun

| LARGE '(' expr ',' expr ')' # LARGE_fun

| SMALL '(' expr ',' expr ')' # SMALL_fun

| PERCENTILE '(' expr ',' expr ')' # PERCENTILE_fun

| PERCENTRANK '(' expr ',' expr ')' # PERCENTRANK_fun

| AVERAGE '(' expr (',' expr)* ')' # AVERAGE_fun

| AVERAGEIF '(' expr ',' expr (',' expr)? ')' # AVERAGEIF_fun

| GEOMEAN '(' expr (',' expr)* ')' # GEOMEAN_fun

| HARMEAN '(' expr (',' expr)* ')' # HARMEAN_fun

| COUNT '(' expr (',' expr)* ')' # COUNT_fun

| COUNTIF '(' expr (',' expr)* ')' # COUNTIF_fun

| SUM '(' expr (',' expr)* ')' # SUM_fun

| SUMIF '(' expr ',' expr (',' expr)? ')' # SUMIF_fun

| AVEDEV '(' expr (',' expr)* ')' # AVEDEV_fun

| STDEV '(' expr (',' expr)* ')' # STDEV_fun

| STDEVP '(' expr (',' expr)* ')' # STDEVP_fun

| COVAR '('expr ',' expr')' # COVAR_fun

| COVARIANCES '('expr ',' expr')' # COVARIANCES_fun

| DEVSQ '(' expr (',' expr)* ')' # DEVSQ_fun

| VAR '(' expr (',' expr)* ')' # VAR_fun

| VARP '(' expr (',' expr)* ')' # VARP_fun

| NORMDIST '(' expr ',' expr ',' expr ',' expr ')' # NORMDIST_fun

| NORMINV '(' expr ',' expr ',' expr ')' # NORMINV_fun

| NORMSDIST '(' expr ')' # NORMSDIST_fun

| NORMSINV '(' expr ')' # NORMSINV_fun

| BETADIST '(' expr ',' expr ',' expr ')' # BETADIST_fun

| BETAINV '(' expr ',' expr ',' expr ')' # BETAINV_fun

| BINOMDIST '(' expr ',' expr ',' expr ',' expr ')' # BINOMDIST_fun

| EXPONDIST '(' expr ',' expr ',' expr ')' # EXPONDIST_fun

| FDIST '(' expr ',' expr ',' expr ')' # FDIST_fun

| FINV '(' expr ',' expr ',' expr ')' # FINV_fun

| FISHER '(' expr ')' # FISHER_fun

| FISHERINV '(' expr ')' # FISHERINV_fun

| GAMMADIST '(' expr ',' expr ',' expr ',' expr ')' # GAMMADIST_fun

| GAMMAINV '(' expr ',' expr ',' expr ')' # GAMMAINV_fun

| GAMMALN '(' expr ')' # GAMMALN_fun

| HYPGEOMDIST '(' expr ',' expr ',' expr ',' expr ')' # HYPGEOMDIST_fun

| LOGINV '(' expr ',' expr ',' expr ')' # LOGINV_fun

| LOGNORMDIST '(' expr ',' expr ',' expr ')' # LOGNORMDIST_fun

| NEGBINOMDIST '(' expr ',' expr ',' expr ')' # NEGBINOMDIST_fun

| POISSON '(' expr ',' expr ',' expr ')' # POISSON_fun

| TDIST '(' expr ',' expr ',' expr ')' # TDIST_fun

| TINV '(' expr ',' expr ')' # TINV_fun

| WEIBULL '(' expr ',' expr ',' expr ',' expr ')' # WEIBULL_fun

| PMT '(' expr ',' expr ',' expr (',' expr (',' expr)?)? ')' # PMT_fun

| PPMT '(' expr ',' expr ',' expr ',' expr (',' expr (',' expr)?)? ')' # PPMT_fun

| IPMT '(' expr ',' expr ',' expr ',' expr (',' expr (',' expr)?)? ')' # IPMT_fun

| PV '(' expr ',' expr ',' expr (',' expr (',' expr)?)? ')' # PV_fun

| FV '(' expr ',' expr ',' expr (',' expr (',' expr)?)? ')' # FV_fun

| NPER '(' expr ',' expr ',' expr (',' expr (',' expr)?)? ')' # NPER_fun

| RATE '(' expr ',' expr ',' expr (',' expr (',' expr (',' expr)?)?)? ')' # RATE_fun

| NPV '(' expr ',' expr (',' expr)* ')' # NPV_fun

| XNPV '(' expr ',' expr ',' expr ')' # XNPV_fun

| IRR '(' expr (',' expr)? ')' # IRR_fun

| MIRR '(' expr ',' expr ',' expr ')' # MIRR_fun

| XIRR '(' expr ',' expr (',' expr)? ')' # XIRR_fun

| SLN '(' expr ',' expr ',' expr ')' # SLN_fun

| DB '(' expr ',' expr ',' expr ',' expr (',' expr)? ')' # DB_fun

| DDB '(' expr ',' expr ',' expr ',' expr (',' expr)? ')' # DDB_fun

| SYD '(' expr ',' expr ',' expr ',' expr ')' # SYD_fun

| URLENCODE '(' expr ')' # URLENCODE_fun

| URLDECODE '(' expr ')' # URLDECODE_fun

| HTMLENCODE '(' expr ')' # HTMLENCODE_fun

| HTMLDECODE '(' expr ')' # HTMLDECODE_fun

| BASE64TOTEXT '(' expr ')' # BASE64TOTEXT_fun

| BASE64URLTOTEXT '(' expr ')' # BASE64URLTOTEXT_fun

| TEXTTOBASE64 '(' expr ')' # TEXTTOBASE64_fun

| TEXTTOBASE64URL '(' expr ')' # TEXTTOBASE64URL_fun

| REGEX '(' expr ',' expr ')' # REGEX_fun

| REGEXREPLACE '(' expr ',' expr ',' expr ')' # REGEXREPLACE_fun

| ISREGEX '(' expr ',' expr ')' # ISREGEX_fun

| GUID '(' ')' # GUID_fun

| MD5 '(' expr ')' # MD5_fun

| SHA1 '(' expr ')' # SHA1_fun

| SHA256 '(' expr ')' # SHA256_fun

| SHA512 '(' expr ')' # SHA512_fun

| HMACMD5 '(' expr ',' expr ')' # HMACMD5_fun

| HMACSHA1 '(' expr ',' expr ')' # HMACSHA1_fun

| HMACSHA256 '(' expr ',' expr ')' # HMACSHA256_fun

| HMACSHA512 '(' expr ',' expr ')' # HMACSHA512_fun

| TRIMSTART '(' expr (',' expr)? ')' # TRIMSTART_fun

| TRIMEND '(' expr (',' expr)? ')' # TRIMEND_fun

| INDEXOF '(' expr ',' expr (',' expr (',' expr)?)? ')' # INDEXOF_fun

| LASTINDEXOF '(' expr ',' expr (',' expr (',' expr)?)? ')' # LASTINDEXOF_fun

| SPLIT '(' expr ',' expr ')' # SPLIT_fun

| JOIN '(' expr (',' expr)+ ')' # JOIN_fun

| SUBSTRING '(' expr ',' expr (',' expr)? ')' # SUBSTRING_fun

| STARTSWITH '(' expr ',' expr (',' expr)? ')' # STARTSWITH_fun

| ENDSWITH '(' expr ',' expr (',' expr)? ')' # ENDSWITH_fun

| ISNULLOREMPTY '(' expr ')' # ISNULLOREMPTY_fun

| ISNULLORWHITESPACE '(' expr ')' # ISNULLORWHITESPACE_fun

| REMOVESTART '(' expr (',' expr (',' expr)?)? ')' # REMOVESTART_fun

| REMOVEEND '(' expr (',' expr (',' expr)?)? ')' # REMOVEEND_fun

| JSON '(' expr ')' # JSON_fun

| LOOKCEILING '(' expr ',' expr ')' # LOOKCEILING_fun

| LOOKFLOOR '(' expr ',' expr ')' # LOOKFLOOR_fun

| PARAMETER '(' (expr (',' expr)*)? ')' # DiyFunction_fun

| ADDYEARS '(' expr ',' expr ')' # ADDYEARS_fun

| ADDMONTHS '(' expr ',' expr ')' # ADDMONTHS_fun

| ADDDAYS '(' expr ',' expr ')' # ADDDAYS_fun

| ADDHOURS '(' expr ',' expr ')' # ADDHOURS_fun

| ADDMINUTES '(' expr ',' expr ')' # ADDMINUTES_fun

| ADDSECONDS '(' expr ',' expr ')' # ADDSECONDS_fun

| TIMESTAMP '(' expr (',' expr)? ')' # TIMESTAMP_fun

| PARAM '(' expr (',' expr)? ')' # PARAM_fun

| ERROR '(' expr? ')' # ERROR_fun

| HAS '('expr ',' expr ')' # HAS_fun

| HASVALUE '(' expr ','expr ')' # HASVALUE_fun

| '{' arrayJson (',' arrayJson)* ','* '}' # ArrayJson_fun

| '[' expr (',' expr)* ','* ']' # Array_fun

| ALGORITHMVERSION # Version_fun

| PARAMETER # PARAMETER_fun

| num unit=(UNIT | T)? # NUM_fun

| STRING # STRING_fun

| NULL # NULL_fun;

num: '-'? NUM;

arrayJson: key=(NUM | STRING) ':' expr

| parameter2 ':' expr;

parameter2:

E

| IF

| IFS

| SWITCH

| IFERROR

| ISNUMBER

| ISTEXT

| ISERROR

| ISNONTEXT

| ISLOGICAL

| ISEVEN

| ISODD

| ISNULL

| ISNULLORERROR

| AND

| OR

| XOR

| NOT

| TRUE

| FALSE

| PI

| DEC2BIN

| DEC2HEX

| DEC2OCT

| HEX2BIN

| HEX2DEC

| HEX2OCT

| OCT2BIN

| OCT2DEC

| OCT2HEX

| BIN2OCT

| BIN2DEC

| BIN2HEX

| ABS

| QUOTIENT

| MOD

| SIGN

| SQRT

| TRUNC

| INT

| GCD

| LCM

| COMBIN

| PERMUT

| DEGREES

| RADIANS

| COS

| COSH

| SIN

| SINH

| TAN

| TANH

| COT

| COTH

| CSC

| CSCH

| SEC

| SECH

| ACOS

| ACOSH

| ASIN

| ASINH

| ATAN

| ATANH

| ACOT

| ACOTH

| ATAN2

| ROUND

| ROUNDDOWN

| ROUNDUP

| CEILING

| FLOOR

| EVEN

| ODD

| MROUND

| RAND

| RANDBETWEEN

| FACT

| FACTDOUBLE

| POWER

| EXP

| LN

| LOG

| LOG10

| MULTINOMIAL

| PRODUCT

| SQRTPI

| ERF

| ERFC

| BESSELI

| BESSELJ

| BESSELK

| BESSELY

| DELTA

| GESTEP

| SUMSQ

| SUMPRODUCT

| SUMX2MY2

| SUMX2PY2

| SUMXMY2

| ARABIC

| ROMAN

| SERIESSUM

| RANK

| FORECAST

| INTERCEPT

| SLOPE

| CORREL

| PEARSON

| YEARFRAC

| ASC

| JIS

| CHAR

| CLEAN

| CODE

| UNICHAR

| UNICODE

| CONCATENATE

| EXACT

| FIND

| FIXED

| LEFT

| LEN

| LOWER

| MID

| PROPER

| REPLACE

| REPT

| RIGHT

| RMB

| SEARCH

| SUBSTITUTE

| T

| TEXT

| TRIM

| UPPER

| VALUE

| DATEVALUE

| TIMEVALUE

| DATE

| TIME

| NOW

| TODAY

| YEAR

| MONTH

| DAY

| HOUR

| MINUTE

| SECOND

| WEEKDAY

| DATEDIF

| DAYS

| DAYS360

| EDATE

| EOMONTH

| NETWORKDAYS

| WORKDAY

| WEEKNUM

| MAX

| MEDIAN

| MIN

| QUARTILE

| MODE

| LARGE

| SMALL

| PERCENTILE

| PERCENTRANK

| AVERAGE

| AVERAGEIF

| GEOMEAN

| HARMEAN

| COUNT

| COUNTIF

| SUM

| SUMIF

| AVEDEV

| STDEV

| STDEVP

| COVAR

| COVARIANCES

| DEVSQ

| VAR

| VARP

| NORMDIST

| NORMINV

| NORMSDIST

| NORMSINV

| BETADIST

| BETAINV

| BINOMDIST

| EXPONDIST

| FDIST

| FINV

| FISHER

| FISHERINV

| GAMMADIST

| GAMMAINV

| GAMMALN

| HYPGEOMDIST

| LOGINV

| LOGNORMDIST

| NEGBINOMDIST

| POISSON

| TDIST

| TINV

| WEIBULL

| URLENCODE

| URLDECODE

| HTMLENCODE

| HTMLDECODE

| BASE64TOTEXT

| BASE64URLTOTEXT

| TEXTTOBASE64

| TEXTTOBASE64URL

| REGEX

| REGEXREPLACE

| ISREGEX

| GUID

| MD5

| SHA1

| SHA256

| SHA512

| HMACMD5

| HMACSHA1

| HMACSHA256

| HMACSHA512

| TRIMSTART

| TRIMEND

| INDEXOF

| LASTINDEXOF

| SPLIT

| JOIN

| SUBSTRING

| STARTSWITH

| ENDSWITH

| ISNULLOREMPTY

| ISNULLORWHITESPACE

| REMOVESTART

| REMOVEEND

| JSON

| LOOKCEILING

| LOOKFLOOR

| ADDYEARS

| ADDMONTHS

| ADDDAYS

| ADDHOURS

| ADDMINUTES

| ADDSECONDS

| TIMESTAMP

| PMT

| PPMT

| IPMT

| PV

| FV

| NPER

| RATE

| NPV

| XNPV

| IRR

| MIRR

| XIRR

| SLN

| DB

| DDB

| SYD

| NULL

| ERROR

| UNIT

| HAS

| HASVALUE

| ALGORITHMVERSION

| PARAM

| PARAMETER;

SUB: '-';

NUM:

'0' ('.' [0-9]+)?

| [1-9][0-9]* ('.' [0-9]+)?

| ('0' ('.' [0-9]+)? | [1-9][0-9]* ('.' [0-9]+)?) 'E' [+-]? [0-9][0-9]?;

STRING:

'\'' (~'\'' | '\\\'')* '\''

| '"' ( ~'"' | '\\"')* '"'

| '`' ( ~'`' | '\\`')* '`';

NULL: 'NULL';

ERROR: 'ERROR';

UNIT:

'M'

| 'KM'

| 'DM'

| 'CM'

| 'MM'

| 'M2'

| 'KM2'

| 'DM2'

| 'CM2'

| 'MM2'

| 'M3'

| 'KM3'

| 'DM3'

| 'CM3'

| 'MM3'

| 'L'

| 'ML'

| 'G'

| 'KG';

IF: 'IF';

IFS: 'IFS';

SWITCH: 'SWITCH';

IFERROR: 'IFERROR';

ISNUMBER: 'ISNUMBER';

ISTEXT: 'ISTEXT';

ISERROR: 'ISERROR';

ISNONTEXT: 'ISNONTEXT';

ISLOGICAL: 'ISLOGICAL';

ISEVEN: 'ISEVEN';

ISODD: 'ISODD';

ISNULL: 'ISNULL';

ISNULLORERROR: 'ISNULLORERROR';

AND: 'AND';

OR: 'OR';

XOR: 'XOR';

NOT: 'NOT';

TRUE: 'TRUE' | 'YES';

FALSE: 'FALSE' | 'NO';

E: 'E';

PI: 'PI';

DEC2BIN: 'DEC2BIN';

DEC2HEX: 'DEC2HEX';

DEC2OCT: 'DEC2OCT';

HEX2BIN: 'HEX2BIN'; // 将十六进制数转换为二进制数

HEX2DEC: 'HEX2DEC'; // 将十六进制数转换为十进制数

HEX2OCT: 'HEX2OCT'; // 将十六进制数转换为八进制数

OCT2BIN: 'OCT2BIN'; // 将八进制数转换为二进制数

OCT2DEC: 'OCT2DEC'; // 将八进制数转换为十进制数

OCT2HEX: 'OCT2HEX'; // 将八进制数转换为十六进制数

BIN2OCT: 'BIN2OCT';

BIN2DEC: 'BIN2DEC';

BIN2HEX: 'BIN2HEX';

ABS: 'ABS';

QUOTIENT: 'QUOTIENT';

MOD: 'MOD';

SIGN: 'SIGN';

SQRT: 'SQRT';

TRUNC: 'TRUNC';

INT: 'INT';

GCD: 'GCD';

LCM: 'LCM';

COMBIN: 'COMBIN';

PERMUT: 'PERMUT';

DEGREES: 'DEGREES';

RADIANS: 'RADIANS';

COS: 'COS';

COSH: 'COSH';

SIN: 'SIN';

SINH: 'SINH';

TAN: 'TAN';

TANH: 'TANH';

COT: 'COT';

COTH: 'COTH';

CSC: 'CSC';

CSCH: 'CSCH';

SEC: 'SEC';

SECH: 'SECH';

ACOS: 'ACOS';

ACOSH: 'ACOSH';

ASIN: 'ASIN';

ASINH: 'ASINH';

ATAN: 'ATAN';

ATANH: 'ATANH';

ACOT: 'ACOT';

ACOTH: 'ACOTH';

ATAN2: 'ATAN2';

ROUND: 'ROUND';

ROUNDDOWN: 'ROUNDDOWN';

ROUNDUP: 'ROUNDUP';

CEILING: 'CEILING';

FLOOR: 'FLOOR';

EVEN: 'EVEN';

ODD: 'ODD';

MROUND: 'MROUND';

RAND: 'RAND';

RANDBETWEEN: 'RANDBETWEEN';

FACT: 'FACT';

FACTDOUBLE: 'FACTDOUBLE';

POWER: 'POWER';

EXP: 'EXP';

LN: 'LN';

LOG: 'LOG';

LOG10: 'LOG10';

MULTINOMIAL: 'MULTINOMIAL';

PRODUCT: 'PRODUCT';

SQRTPI: 'SQRTPI';

ERF: 'ERF';

ERFC: 'ERFC';

BESSELI: 'BESSELI';

BESSELJ: 'BESSELJ';

BESSELK: 'BESSELK';

BESSELY: 'BESSELY';

DELTA: 'DELTA';

GESTEP: 'GESTEP';

SUMSQ: 'SUMSQ';

SUMPRODUCT: 'SUMPRODUCT';

SUMX2MY2: 'SUMX2MY2';

SUMX2PY2: 'SUMX2PY2';

SUMXMY2: 'SUMXMY2';

ARABIC: 'ARABIC';

ROMAN: 'ROMAN';

SERIESSUM: 'SERIESSUM';

RANK: 'RANK';

FORECAST: 'FORECAST';

INTERCEPT: 'INTERCEPT';

SLOPE: 'SLOPE';

CORREL: 'CORREL';

PEARSON: 'PEARSON';