Formulas

-------------------

Feat
~~~~
- (binder): Refresh environment binder for 2021.

- (look) :gh:`87`: Add `ADDRESS` function.

- (test): Update test cases.

- (financial) :gh:`74`, :gh:`87`: Add `FV`, `PV`, `IPMT`, `PMT`, `PPMT`,
`RATE`, `CUMIPMT`, and `NPER` functions.

- (info, logic): Add `ISNA` and `IFNA` functions.

- (date) :gh:`87`: Add `WEEKDAY`, `WEEKNUM`, `ISOWEEKNUM`, and `DATEDIF`
functions.

- (stat, math) :gh:`87`: Add `SLOPE` and `PRODUCT` functions.

- (stats) :gh:`87`: Add `CORREL` and `MEDIAN` functions.

- (bin): Add `bin` folder.

- (actions): Add test cases.

- (stats) :gh:`80`: Add `FORECAST` and `FORECAST.LINEAR` functions.

- (excel) :gh:`82`: Add inverse of simple references.


Fix
~~~
- (stat): Correct `LARGE` and `SMALL` error handling.

- (actions): Skip `Setup Graphviz` when not needed.

- (actions): Correct coverall setting.

- (actions): Remove unstable test case.

- (actions): Disable fail fast.

- (date, stat): Correct collapsed return value.

- (function) :gh:`78`, :gh:`79`, :gh:`91`: Correct import error.

-------------------

Feat
~~~~
- (excel): Improve performances of `complete` method.

- (setup): Add add python 3.9 in setup.py.

- (functions): Add `SEARCH`, `ISNUMBER`, and `EDATE` functions.

- (travis): Update python version for coveralls.


Fix
~~~
- (doc): Correct missing documentation link.

- (doc): Correct typo.

- (operator) :gh:`70`: Correct `%` operator preceded by space.

-------------------

Feat
~~~~
- (look) :gh:`57`: Add `SINGLE` function.

- (function) :gh:`51`: Add google Excel functions.

- (logic) :gh:`55`, :gh:`57`: Add IFS function.

- (excel) :gh:`65`: Add documentation and rename method to load models
from ranges.

- (excel) :gh:`65`: Add method to load sub-models from range.

- (doc): Update Copyright.

- (excel): Improve performances.

- (excel) :gh:`64`: Read model from outputs.

- (core): Update range definition with path file.

- (excel) :gh:`64`: Add warning for missing reference.

- (excel) :gh:`64`: Add warning message when book loading fails.

- (readme) :gh:`44`: Add example to export and import the model to JSON
format.

- (readme) :gh:`53`: Add instructions to install the development
version.

- (excel) :gh:`44`: Add feature to export and import the model to JSON-
able dict.

- (stat, comp) :gh:`43`: Add `STDEV`, `STDEV.S`, `STDEV.P`, `STDEVA`,
`STDEVPA`, `VAR`, `VAR.S`, `VAR.P`, `VARA`, and `VARPA` functions.


Fix
~~~
- (financial): Correct requirements for `irr` function.

- (excel) :gh:`48`: Correct reference pointing to different workbooks.

- (function) :gh:`67`: Correct compilation of impure functions (e.g.,
`rand`, `now`, etc.).

- (look) :gh:`66`: Correct `check` function did not return value.

- (test): Remove `temp` dir.

- (excel): Correct external link reading.

- (operator) :gh:`63`: Correct operator parser when starts with spaces.

- (text) :gh:`61`: Convert float as int when stringify if it is an
integer.

- (math) :gh:`59`: Convert string to number in math operations.

- (functions): Correct `_xfilter` operating range type.

- (parser) :gh:`61`: Skip `\n` in formula expression.

- (operator) :gh:`58`: Correct operator parser for composed operators.

- (excel): Correct invalid range definition and missing sheet or files.

- (operand) :gh:`52`: Correct range parser.

- (operand) :gh:`50`: Correct sheet name parser with space.

- (tokens): Correct closure parenthesis parser.

- (excel): Skip function compilation for string cells.

- (tokens): Correct error parsing when sheet name is defined.

-------------------

Feat
~~~~
- (core): Add `CODE_OF_CONDUCT.md`.

- (function) :gh:`39`: Transform `NotImplementedError` into `NAME?`.

- (text) :gh:`39`: Add `CONCAT` and `CONCATENATE` functions.

- (logic) :gh:`38`: Add TRUE/FALSE functions.

- (excel) :gh:`42`: Save missing nodes.

- (excel) :gh:`42`: Update logic for `RangesAssembler`.

- (excel): Improve performance of `finish` method.

- (core): Update build script.

- (core): Add support for python 3.8 and drop python 3.5 and drop
`appveyor`.

- (core): Improve memory performance.

- (refact): Update copyright.

- (operand): Add `fast_range2parts_v4` for named ranges.


Fix
~~~
- (math) :gh:`37`: Match excel default rounding algorithm of round half
up.

- (cell): Correct reference in `push` method.

- (readme): Correct doctest.

- (token): Correct separator parser.

- (excel) :gh:`35`: Update logic to parse named ranges.

- (operand): Associate `excel_id==0` to current excel.

- (array): Ensure correct deepcopy of `Array` attributes.

- (operand) :gh:`39`: Correct range parser for named ranges.

- (operand) :gh:`41`: Correct named ranges parser.

-------------------

Feat
~~~~
- (doc): Add binder.

- (setup): Add env `ENABLE_SETUP_LONG_DESCRIPTION`.

- (core): Add useful constants.

- (excel): Add option to write all calculate books inside a folder.

- (stat) :gh:`21`: Add `COUNTBLANK`, `LARGE`, `SMALL` functions.

- (date) :gh:`35`: Add `NPV`, `XNPV`, `IRR`, `XIRR` functions.

- (stat) :gh:`21`: Add `AVERAGEIF`, `COUNT`, `COUNTA`, `COUNTIF`
functions.

- (math) :gh:`21`: Add `SUMIF` function.

- (date) :gh:`21`, :gh:`35`, :gh:`36`: Add `date` functions `DATE`,
`DATEVALUE`, `DAY`, `MONTH`, `YEAR`, `TODAY`, `TIME`, `TIMEVALUE`,
`SECOND`, `MINUTE`, `HOUR`, `NOW`, `YEARFRAC`.

- (info) :gh:`21`: Add `NA` function.

- (date) :gh:`21`, :gh:`35`, :gh:`36`: Add `date` functions `DATE`,
`DATEVALUE`, `DAY`, `MONTH`, `YEAR`, `TODAY`, `TIME`, `TIMEVALUE`,
`SECOND`, `MINUTE`, `HOUR`, `NOW`, `YEARFRAC`.

- (stat) :gh:`35`: Add `MINA`, `AVERAGEA`, `MAXA` functions.


Fix
~~~
- (setup): Update tests requirements.

- (setup): Correct setup dependency (`beautifulsoup4`).

- (stat): Correct round indices.

- (setup) :gh:`34`: Build universal wheels.

- (test): Correct import error.

- (date) :gh:`35`: Correct behaviour of `LOOKUP` function when dealing
with errors.

- (excel) :gh:`35`: Improve cycle detection.

- (excel,date) :gh:`21`, :gh:`35`: Add custom Excel Reader to parse raw
datetime.

- (excel) :gh:`35`: Correct when definedName is relative `REF!`.

-------------------

Feat
~~~~
- (logic) :gh:`27`: Add `OR`, `XOR`, `AND`, `NOT` functions.

- (look) :gh:`27`: Add `INDEX` function.

- (look) :gh:`24`: Improve performances of `look` functions.

- (functions) :gh:`26`: Add `SWITCH`.

- (functions) :gh:`30`: Add `GCD` and `LCM`.

- (chore): Improve performances avoiding `combine_dicts`.

- (chore): Improve performances checking intersection.


Fix
~~~
- (tokens): Correct string nodes ids format adding `"`.

- (ranges): Correct behaviour union of ranges.

- (import): Enable PyCharm autocomplete.

- (import): Save imports.

- (test): Add repo path to system path.

- (parser): Parse empty args for functions.

- (functions) :gh:`30`: Correct implementation of `GCD` and `LCM`.

- (ranges) :gh:`24`: Enable full column and row reference.

- (excel): Correct bugs due to new `openpyxl`.