{ "info": { "author": "Gleb Orlov", "author_email": "orlovgb@mail.ru", "bugtrack_url": null, "classifiers": [ "Development Status :: 2 - Pre-Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 2", "Programming Language :: Python :: 3" ], "description": "Quick start\n~~~~~~~~~~~~~\n#. Inherit from efc.interface.BaseExcelInterface in your excel file class and implement methods. This class will be used to get data from excel file using any library you want.\n#. Import from efc get_calculator and call it to get function with arguments \"**formula**, **ws_name**, **source**\". This function will be calculate your formulas.\n\nFunctionality\n~~~~~~~~~~~~~\n* Arithmetic: ``-, +, *, /, ^, ()``\n* Comparison: ``<>, >, >=, <, <=, =``\n* String concatenation: ``&``\n* Functions: ``ABS, AND, AVERAGE, AVERAGEIFS, CONCATENATE, COUNT, COUNTIF, COUNTIFS, COUNTBLANK, IF, IFERROR, ISBLANK, FLOOR, LARGE, LEFT, MAX, MATCH, MID, MIN, MOD, OFFSET, OR, SMALL, RIGHT, ROUND, ROUNDDOWN, SUM, SUMIFS, VLOOKUP``\n* All variations of the spelling of the cell and range addresses (linked docs will be skipped)\n* Formula cell offset - this can be useful when calculating shared formulas\n\n\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/peredryaga/excel-formula-calculator", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "excel-formula-calculator", "package_url": "https://pypi.org/project/excel-formula-calculator/", "platform": "", "project_url": "https://pypi.org/project/excel-formula-calculator/", "project_urls": { "Homepage": "https://github.com/peredryaga/excel-formula-calculator" }, "release_url": "https://pypi.org/project/excel-formula-calculator/0.1.8/", "requires_dist": [ "six" ], "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "summary": "Library to calculate excel formulas", "version": "0.1.8" }, "last_serial": 5318567, "releases": { "0.1.1": [ { "comment_text": "", "digests": { "md5": "2024d97592033dc7519c4b9da0de7b47", "sha256": "99db4116e234e764d506be1d0f3caa62e525435cad14aa9b4bc63a2be16b37f8" }, "downloads": -1, "filename": "excel_formula_calculator-0.1.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "2024d97592033dc7519c4b9da0de7b47", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": "~=2.7, >=3.6.*", "size": 18033, "upload_time": "2019-02-03T13:55:09", "url": "https://files.pythonhosted.org/packages/60/b6/710544157d2308c2c9ebe72894b7d408293799ba92a920e41997e004e6ba/excel_formula_calculator-0.1.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "f5c3516830c47129956b984d77bc87a8", "sha256": "717e4c44fb1c8da7c20ea05b1e5e70489b5aedd865c1366a208d946c75c4dc2b" }, "downloads": -1, "filename": "excel-formula-calculator-0.1.1.tar.gz", "has_sig": false, "md5_digest": "f5c3516830c47129956b984d77bc87a8", "packagetype": "sdist", "python_version": "source", "requires_python": "~=2.7, >=3.6.*", "size": 12179, "upload_time": "2019-02-03T13:55:11", "url": "https://files.pythonhosted.org/packages/3c/60/94ea68174dbfc85813381fc76ec1bf3cf8b1a474e225d5be8382766eabd4/excel-formula-calculator-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "2e6ccd43819e9633d885ecc84de72f62", "sha256": "57cc787451a81f4495e8c2380e74efcb627be7bc2bacbd0f279006da6cad100d" }, "downloads": -1, "filename": "excel_formula_calculator-0.1.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "2e6ccd43819e9633d885ecc84de72f62", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": "~=2.7, >=3.6.*", "size": 17970, "upload_time": "2019-02-03T14:05:45", "url": "https://files.pythonhosted.org/packages/a0/d3/1151c2be58235254a5ace1d8a3e0079ac57499358665d94ada4e64489e5b/excel_formula_calculator-0.1.2-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "c015bd9eb043ae30333f2375cbd130eb", "sha256": "65a02c17d8d3582a773360926013fe9023de6aa323d2fc8675dcc8a398b7bf69" }, "downloads": -1, "filename": "excel-formula-calculator-0.1.2.tar.gz", "has_sig": false, "md5_digest": "c015bd9eb043ae30333f2375cbd130eb", "packagetype": "sdist", "python_version": "source", "requires_python": "~=2.7, >=3.6.*", "size": 12103, "upload_time": "2019-02-03T14:05:47", "url": "https://files.pythonhosted.org/packages/c4/0a/3b32757cf508c55288765307224f575085398e0426a54abff2c6c2cba995/excel-formula-calculator-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "807f4f29a9008473692a95346afcc525", "sha256": "8cec5b4dff9c63acf7111eecfbd9f3bc954bbec1ac7078ea84028696f3d3e447" }, "downloads": -1, "filename": "excel_formula_calculator-0.1.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "807f4f29a9008473692a95346afcc525", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 17989, "upload_time": "2019-02-03T17:25:43", "url": "https://files.pythonhosted.org/packages/35/c0/36fee2066fcf788aabd244bdd5b3b95735468a066bd3a1a82c5e760d3937/excel_formula_calculator-0.1.3-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "cfcbd6da00c43fdf11dc95b02811c57d", "sha256": "fa9921f0639fdc5b73675dd06c66d0f5fdfb259eb8b5440969996daa32f4c646" }, "downloads": -1, "filename": "excel-formula-calculator-0.1.3.tar.gz", "has_sig": false, "md5_digest": "cfcbd6da00c43fdf11dc95b02811c57d", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 12121, "upload_time": "2019-02-03T17:25:45", "url": "https://files.pythonhosted.org/packages/86/b8/692449edcf1395f81f29907399e926fc9cbb87d37f275725b42b7656e0ec/excel-formula-calculator-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "c245fe58fbd8391866e63dfd483c4b76", "sha256": "41c93c3168cfa60275d44a28315ddb79856a7513af735ff02afb790b2d8adcd9" }, "downloads": -1, "filename": "excel_formula_calculator-0.1.4-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "c245fe58fbd8391866e63dfd483c4b76", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 25435, "upload_time": "2019-02-24T15:05:26", "url": "https://files.pythonhosted.org/packages/87/02/a3fad8942b7e7cce451487690831d2bcbb1992bc0227dd01adb6eb6602b8/excel_formula_calculator-0.1.4-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "77ec47521b7e43774162a8d9a21b3e34", "sha256": "61763f8db712f0361a06320eef8f017651239abaab7a7ce1b9138f8f20df5a2f" }, "downloads": -1, "filename": "excel-formula-calculator-0.1.4.tar.gz", "has_sig": false, "md5_digest": "77ec47521b7e43774162a8d9a21b3e34", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 16197, "upload_time": "2019-02-24T15:05:30", "url": "https://files.pythonhosted.org/packages/af/33/8ec42c14abbf32999670332a44bcd7b597f07697cfd9181ca12264382176/excel-formula-calculator-0.1.4.tar.gz" } ], "0.1.5": [ { "comment_text": "", "digests": { "md5": "c5c8cad57df5868f81b129f655e0344d", "sha256": "bbf056d411c7f9ef3a00d989ea6fe8aa83e260b0f53109fd430089cd12a4bbe5" }, "downloads": -1, "filename": "excel_formula_calculator-0.1.5-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "c5c8cad57df5868f81b129f655e0344d", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 32672, "upload_time": "2019-02-24T17:02:28", "url": "https://files.pythonhosted.org/packages/c0/d5/b0605274555e28ebe0ef6ccbb0a15fcc084f8d2cf5a7e3aaceb10b0cae3c/excel_formula_calculator-0.1.5-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "ad76ab59d9c0387aa6a88a87818a83cd", "sha256": "5f5f25c7a60ad0a1f5d967c66b827562ea7da30efd442887f801bfde8d97ccd5" }, "downloads": -1, "filename": "excel-formula-calculator-0.1.5.tar.gz", "has_sig": false, "md5_digest": "ad76ab59d9c0387aa6a88a87818a83cd", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 16472, "upload_time": "2019-02-24T17:02:32", "url": "https://files.pythonhosted.org/packages/b3/ef/d38c47e599144522e624ae092fe6bbb55ed07f73676448e6c43d9f0b4b5c/excel-formula-calculator-0.1.5.tar.gz" } ], "0.1.6": [ { "comment_text": "", "digests": { "md5": "ab30b714c5bd2e1639ae24ad02ebebab", "sha256": "74c2a4e374e12400f2a911537588e4525380277639f2db993a0f69d013cbf5ce" }, "downloads": -1, "filename": "excel_formula_calculator-0.1.6-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "ab30b714c5bd2e1639ae24ad02ebebab", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 25610, "upload_time": "2019-03-11T15:01:48", "url": "https://files.pythonhosted.org/packages/c3/2c/b63c6c97716dff867bf01937bd4b6b842b0eaf84a6e58424f5ea4da55746/excel_formula_calculator-0.1.6-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "4ee0202d9cd00a800c343b3f4ecdf431", "sha256": "c061aaca85682aa8e19a06c4029ba65bbfc508019e22a332689bb70d0ffd44cd" }, "downloads": -1, "filename": "excel-formula-calculator-0.1.6.tar.gz", "has_sig": false, "md5_digest": "4ee0202d9cd00a800c343b3f4ecdf431", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 18072, "upload_time": "2019-03-11T15:01:50", "url": "https://files.pythonhosted.org/packages/12/ad/5aa50cafa7fa66fed5fc9b1ade029cc9262c6e8944cb1e5f60b7bc820f03/excel-formula-calculator-0.1.6.tar.gz" } ], "0.1.7": [ { "comment_text": "", "digests": { "md5": "e22b6b9147de457cc545666f9eb92b64", "sha256": "420108b3c64a580d38f0242138e6923015ac255431830f9abba01c31de022e6c" }, "downloads": -1, "filename": "excel_formula_calculator-0.1.7-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "e22b6b9147de457cc545666f9eb92b64", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 25631, "upload_time": "2019-03-13T09:56:04", "url": "https://files.pythonhosted.org/packages/38/67/d29e9f0b8b218462938cf31c8f08039bba4e0ccd428ba4d0a693ce68317e/excel_formula_calculator-0.1.7-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "f1d4ba31f0ad84cddc30daebeeb2ce1e", "sha256": "fd25f4e81522fb37e5e8f58dbe78c466d71cba767a9790b39065b5a3ed1ee9bd" }, "downloads": -1, "filename": "excel-formula-calculator-0.1.7.tar.gz", "has_sig": false, "md5_digest": "f1d4ba31f0ad84cddc30daebeeb2ce1e", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 18084, "upload_time": "2019-03-13T09:56:07", "url": "https://files.pythonhosted.org/packages/cc/23/8193da99e4dda8d143170b4545c83abc260ad9bb49afc228b1cebad19744/excel-formula-calculator-0.1.7.tar.gz" } ], "0.1.8": [ { "comment_text": "", "digests": { "md5": "3f1d0f569f185dc038e9b16e13d8ab16", "sha256": "79a84a9ea08feaa257a9fd5b4eb99e65ebf34c1c2c7d7aecd734b6cdfeb208f1" }, "downloads": -1, "filename": "excel_formula_calculator-0.1.8-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "3f1d0f569f185dc038e9b16e13d8ab16", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 25757, "upload_time": "2019-03-13T14:09:47", "url": "https://files.pythonhosted.org/packages/8a/f1/4dcc4bf8baa8c8ea0274661efc77053720174f1cfe3b7c75a7a693054b56/excel_formula_calculator-0.1.8-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "16b42b357fdc68317b0b21a293998c81", "sha256": "614d4e1635d1fb5e5abfbe1297bd7bcbea4e2462c6359c493d66bf32e1d1391f" }, "downloads": -1, "filename": "excel-formula-calculator-0.1.8.tar.gz", "has_sig": false, "md5_digest": "16b42b357fdc68317b0b21a293998c81", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 18222, "upload_time": "2019-03-13T14:09:48", "url": "https://files.pythonhosted.org/packages/6a/53/093a141f024775b439da11350a37211d5e745bc87c6194587d4058b5ce36/excel-formula-calculator-0.1.8.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "3f1d0f569f185dc038e9b16e13d8ab16", "sha256": "79a84a9ea08feaa257a9fd5b4eb99e65ebf34c1c2c7d7aecd734b6cdfeb208f1" }, "downloads": -1, "filename": "excel_formula_calculator-0.1.8-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "3f1d0f569f185dc038e9b16e13d8ab16", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 25757, "upload_time": "2019-03-13T14:09:47", "url": "https://files.pythonhosted.org/packages/8a/f1/4dcc4bf8baa8c8ea0274661efc77053720174f1cfe3b7c75a7a693054b56/excel_formula_calculator-0.1.8-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "16b42b357fdc68317b0b21a293998c81", "sha256": "614d4e1635d1fb5e5abfbe1297bd7bcbea4e2462c6359c493d66bf32e1d1391f" }, "downloads": -1, "filename": "excel-formula-calculator-0.1.8.tar.gz", "has_sig": false, "md5_digest": "16b42b357fdc68317b0b21a293998c81", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, <4", "size": 18222, "upload_time": "2019-03-13T14:09:48", "url": "https://files.pythonhosted.org/packages/6a/53/093a141f024775b439da11350a37211d5e745bc87c6194587d4058b5ce36/excel-formula-calculator-0.1.8.tar.gz" } ] }