o j@s(dZdZeeZddlmZddZdS)z List of builtin formulae (c CUBEKPIMEMBER CUBEMEMBERCUBEMEMBERPROPERTYCUBERANKEDMEMBERCUBESET CUBESETCOUNT CUBEVALUEDAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEVDSTDEVPDSUMDVARDVARPDATEDATEDIF DATEVALUEDAYDAYS360EDATEEOMONTHHOURMINUTEMONTH NETWORKDAYSzNETWORKDAYS.INTLNOWSECONDTIME TIMEVALUETODAYWEEKDAYWEEKNUMWORKDAYz WORKDAY.INTLYEARYEARFRACBESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABS IMAGINARY IMARGUMENT IMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWER IMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMOCT2BINOCT2DECOCT2HEXACCRINTACCRINTM AMORDEGRCAMORLINC COUPDAYBSCOUPDAYS COUPDAYSNCCOUPNCDCOUPNUMCOUPPCDCUMIPMTCUMPRINCDBDDBDISCDOLLARDEDOLLARFRDURATIONEFFECTFV FVSCHEDULEINTRATEIPMTIRRISPMT MDURATIONMIRRNOMINALNPERNPV ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELDPMTPPMTPRICE PRICEDISCPRICEMATPVRATERECEIVEDSLNSYDTBILLEQ TBILLPRICE TBILLYIELDVDBXIRRXNPVYIELD YIELDDISCYIELDMATCELLz ERROR.TYPEINFOISBLANKISERRISERRORISEVEN ISLOGICALISNA ISNONTEXTISNUMBERISODDISREFISTEXTNNATYPEANDFALSEIFIFERRORNOTORTRUEADDRESSAREASCHOOSECOLUMNCOLUMNS GETPIVOTDATAHLOOKUP HYPERLINKINDEXINDIRECTLOOKUPMATCHOFFSETROWROWSRTD TRANSPOSEVLOOKUPABSACOSACOSHASINASINHATANATAN2ATANHCEILINGCOMBINCOSCOSHDEGREESz ECMA.CEILINGEVENEXPFACT FACTDOUBLEFLOORGCDINTz ISO.CEILINGLCMLNLOGLOG10MDETERMMINVERSEMMULTMODMROUND MULTINOMIALODDPIPOWERPRODUCTQUOTIENTRADIANSRAND RANDBETWEENROMANROUND ROUNDDOWNROUNDUP SERIESSUMSIGNSINSINHSQRTSQRTPISUBTOTALSUMSUMIFSUMIFS SUMPRODUCTSUMSQSUMX2MY2SUMX2PY2SUMXMY2TANTANHTRUNCAVEDEVAVERAGEAVERAGEA AVERAGEIF AVERAGEIFSBETADISTBETAINV BINOMDISTCHIDISTCHIINVCHITEST CONFIDENCECORRELCOUNTCOUNTA COUNTBLANKCOUNTIFCOUNTIFSCOVAR CRITBINOMDEVSQ EXPONDISTFDISTFINVFISHER FISHERINVFORECAST FREQUENCYFTEST GAMMADISTGAMMAINVGAMMALNGEOMEANGROWTHHARMEAN HYPGEOMDIST INTERCEPTKURTLARGELINESTLOGESTLOGINV LOGNORMDISTMAXMAXAMEDIANMINMINAMODE NEGBINOMDISTNORMDISTNORMINV NORMSDISTNORMSINVPEARSON PERCENTILE PERCENTRANKPERMUTPOISSONPROBQUARTILERANKRSQSKEWSLOPESMALL STANDARDIZESTDEVSTDEVASTDEVPSTDEVPASTEYXTDISTTINVTRENDTRIMMEANTTESTVARVARAVARPVARPAWEIBULLZTESTASCBAHTTEXTCHARCLEANCODE CONCATENATEDOLLAREXACTFINDFINDBFIXEDJISLEFTLEFTBLENLENBLOWERMIDMIDBPHONETICPROPERREPLACEREPLACEBREPTRIGHTRIGHTBSEARCHSEARCHB SUBSTITUTETTEXTTRIMUPPERVALUE) TokenizercCsr|dsJt|}|jD](}|jdkr6|jdkr6|jds6|jddtvr6td|jd|jd qdS) zR Utility function for checking whether a formula is syntactically correct =FUNCOPENz_xlfn.NzUnknown function z in z . The function may need a prefix) startswithr`itemstypesubtypevalueFORMULAE ValueErrorformula)rltrn[/var/www/ticemtrilhas/avaliacao_env/lib/python3.10/site-packages/openpyxl/utils/formulas.pyvalidates rpN)__doc__rj frozensetopenpyxl.formular`rprnrnrnros