fj6dZdZeeZddlmZdZdS)z List of builtin formulae (` CUBEKPIMEMBER CUBEMEMBERCUBEMEMBERPROPERTYCUBERANKEDMEMBERCUBESET CUBESETCOUNT CUBEVALUEDAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEVDSTDEVPDSUMDVARDVARPDATEDATEDIF DATEVALUEDAYDAYS360EDATEEOMONTHHOURMINUTEMONTH NETWORKDAYSzNETWORKDAYS.INTLNOWSECONDTIME TIMEVALUETODAYWEEKDAYWEEKNUMzWORKDAY z WORKDAY.INTLYEARYEARFRACBESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABS IMAGINARY IMARGUMENT IMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWER IMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMOCT2BINOCT2DECOCT2HEXACCRINTACCRINTM AMORDEGRCAMORLINC COUPDAYBSCOUPDAYS COUPDAYSNCCOUPNCDCOUPNUMCOUPPCDCUMIPMTCUMPRINCDBDDBDISCDOLLARDEDOLLARFRDURATIONEFFECTFV FVSCHEDULEINTRATEIPMTIRRISPMT MDURATIONMIRRNOMINALNPERNPV ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELDPMTPPMTPRICE PRICEDISCPRICEMATPVRATERECEIVEDSLNSYDTBILLEQ TBILLPRICE TBILLYIELDVDBXIRRXNPVYIELD YIELDDISCYIELDMATCELLz ERROR.TYPEINFOISBLANKISERRISERRORISEVEN ISLOGICALISNA ISNONTEXTISNUMBERISODDISREFISTEXTNNATYPEANDFALSEIFIFERRORNOTORz TRUE ADDRESSAREASCHOOSECOLUMNCOLUMNS 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 STANDARDIZEz STDEV STDEVASTDEVPz STDEVPA STEYXTDISTTINVTRENDTRIMMEANTTESTVARVARAVARPVARPAWEIBULLZTESTASCBAHTTEXTCHARCLEANCODE 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) startswithrZitemstypesubtypevalueFORMULAE ValueErrorformula)rgts kC:\Users\Terasoftware\OneDrive\Desktop\faahhh\fyndo\fyndo\venv\Lib\site-packages\openpyxl/utils/formulas.pyvalidaterjs   c " """"  G ]uu 6V  u V 3 u7%%h// uAGCRCL4P u !sQW!s!s'/!s!s!stttuuN)__doc__re frozensetopenpyxl.formularZrjrkrirpsX o8 9X  '&&&&& u u u u urk