Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/openpyxl/utils/__pycache__/formulas.cpython-37.pyc
Назад
B �5�g� � @ s( d Z dZee�ZddlmZ dd� ZdS )z List of builtin formulae (c Z CUBEKPIMEMBERZ CUBEMEMBERZCUBEMEMBERPROPERTYZCUBERANKEDMEMBERZCUBESETZ CUBESETCOUNTZ CUBEVALUEZDAVERAGEZDCOUNTZDCOUNTAZDGETZDMAXZDMINZDPRODUCTZDSTDEVZDSTDEVPZDSUMZDVARZDVARPZDATEZDATEDIFZ DATEVALUEZDAYZDAYS360ZEDATEZEOMONTHZHOURZMINUTEZMONTHZ NETWORKDAYSzNETWORKDAYS.INTLZNOWZSECONDZTIMEZ TIMEVALUEZTODAYZWEEKDAYZWEEKNUMZWORKDAYz WORKDAY.INTLZYEARZYEARFRACZBESSELIZBESSELJZBESSELKZBESSELYZBIN2DECZBIN2HEXZBIN2OCTZCOMPLEXZCONVERTZDEC2BINZDEC2HEXZDEC2OCTZDELTAZERFZERFCZGESTEPZHEX2BINZHEX2DECZHEX2OCTZIMABSZ IMAGINARYZ IMARGUMENTZ IMCONJUGATEZIMCOSZIMDIVZIMEXPZIMLNZIMLOG10ZIMLOG2ZIMPOWERZ IMPRODUCTZIMREALZIMSINZIMSQRTZIMSUBZIMSUMZOCT2BINZOCT2DECZOCT2HEXZACCRINTZACCRINTMZ AMORDEGRCZAMORLINCZ COUPDAYBSZCOUPDAYSZ COUPDAYSNCZCOUPNCDZCOUPNUMZCOUPPCDZCUMIPMTZCUMPRINCZDBZDDBZDISCZDOLLARDEZDOLLARFRZDURATIONZEFFECTZFVZ FVSCHEDULEZINTRATEZIPMTZIRRZISPMTZ MDURATIONZMIRRZNOMINALZNPERZNPVZ ODDFPRICEZ ODDFYIELDZ ODDLPRICEZ ODDLYIELDZPMTZPPMTZPRICEZ PRICEDISCZPRICEMATZPVZRATEZRECEIVEDZSLNZSYDZTBILLEQZ TBILLPRICEZ TBILLYIELDZVDBZXIRRZXNPVZYIELDZ YIELDDISCZYIELDMATZCELLz ERROR.TYPE�INFOZISBLANKZISERRZISERRORZISEVENZ ISLOGICALZISNAZ ISNONTEXTZISNUMBERZISODDZISREFZISTEXT�NZNAZTYPE�AND�FALSEZIFZIFERRORZNOT�OR�TRUEZADDRESSZAREASZCHOOSEZCOLUMN�COLUMNSZ GETPIVOTDATAZHLOOKUPZ HYPERLINKZINDEXZINDIRECTZLOOKUP�MATCHZOFFSETZROWZROWSZRTDZ TRANSPOSEZVLOOKUPZABSZACOSZACOSHZASINZASINHZATANZATAN2ZATANHZCEILINGZCOMBINZCOSZCOSHZDEGREESz ECMA.CEILINGZEVENZEXPZFACTZ FACTDOUBLEZFLOORZGCD�INTz ISO.CEILINGZLCM�LNZLOGZLOG10ZMDETERMZMINVERSEZMMULTZMODZMROUNDZ MULTINOMIAL�ODDZPIZPOWERZPRODUCTZQUOTIENTZRADIANSZRANDZ RANDBETWEENZROMANZROUNDZ ROUNDDOWNZROUNDUPZ SERIESSUMZSIGNZSINZSINHZSQRTZSQRTPIZSUBTOTALZSUMZSUMIFZSUMIFSZ SUMPRODUCTZSUMSQZSUMX2MY2ZSUMX2PY2ZSUMXMY2ZTANZTANHZTRUNCZAVEDEVZAVERAGEZAVERAGEAZ AVERAGEIFZ AVERAGEIFSZBETADISTZBETAINVZ BINOMDISTZCHIDISTZCHIINVZCHITESTZ CONFIDENCEZCORRELZCOUNTZCOUNTAZ COUNTBLANKZCOUNTIFZCOUNTIFSZCOVARZ CRITBINOMZDEVSQZ EXPONDISTZFDISTZFINVZFISHERZ FISHERINVZFORECASTZ FREQUENCYZFTESTZ GAMMADISTZGAMMAINVZGAMMALNZGEOMEANZGROWTHZHARMEANZ HYPGEOMDISTZ INTERCEPTZKURTZLARGEZLINESTZLOGESTZLOGINVZ LOGNORMDIST�MAXZMAXAZMEDIANZMINZMINAZMODEZ NEGBINOMDISTZNORMDISTZNORMINVZ NORMSDISTZNORMSINVZPEARSONZ PERCENTILEZ PERCENTRANKZPERMUTZPOISSONZPROBZQUARTILEZRANKZRSQZSKEWZSLOPEZSMALLZ STANDARDIZEZSTDEVZSTDEVAZSTDEVPZSTDEVPAZSTEYXZTDISTZTINVZTRENDZTRIMMEANZTTESTZVARZVARAZVARPZVARPAZWEIBULLZZTEST�ASCZBAHTTEXTZCHARZCLEANZCODEZ CONCATENATEZDOLLARZEXACTZFINDZFINDBZFIXEDZJIS�LEFTZLEFTBZLENZLENBZLOWERZMIDZMIDBZPHONETICZPROPERZREPLACEZREPLACEBZREPT�RIGHTZRIGHTBZSEARCHZSEARCHBZ SUBSTITUTE�TZTEXTZTRIMZUPPERZVALUE� )� Tokenizerc C sv | � d�st�t| �} xZ| jD ]P}|jdkr |jdkr |j� d�s |jdd� tkr td|j� d| j � d ���q W dS ) zR Utility function for checking whether a formula is syntactically correct �=ZFUNCZOPENz_xlfn.N���zUnknown function z in z . The function may need a prefix) � startswith�AssertionErrorr �items�type�subtype�value�FORMULAE� ValueError�formula)r �t� r �M/home/digitalm-up/venv/lib/python3.7/site-packages/openpyxl/utils/formulas.py�validate s r! N)�__doc__r � frozensetZopenpyxl.formular r! r r r r �<module> s
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.03 |
proxy
|
phpinfo
|
Настройка