j6dZdZeeZddlmZdZdS)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) Tokenizerc2|dsJt|}|jD]h}|jdkr[|jdkrP|jds6|jddt vr td|jd|jd idS) zR Utility function for checking whether a formula is syntactically correct =FUNCOPENz_xlfn.NzUnknown function z in z . The function may need a prefix) startswithraitemstypesubtypevalueFORMULAE ValueErrorformula)rnts f/var/www/finuniver-perm.ru/html/portfolio/venv/lib/python3.11/site-packages/openpyxl/utils/formulas.pyvalidaterqs   c " """"  G ]uu 6V   V 3 37%%h// uAGCRCL4P4P !sQW!s!s'/!s!s!stttuuN)__doc__rl frozensetopenpyxl.formulararqrrrprwsX w8 9X  '&&&&& u u u u urr