Formulas

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

Fix
~~~
- (excel): Correct function compilation from excel.

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

Feat
~~~~
- (functions): Improve performances caching results.

- (excel): Make replacing missing ref optional in `from_dict` method.

- (excel) :gh:`73`, :gh:`75`: Improve performances to parse full ranges.


Fix
~~~
- (excel): Correct compile function when inputs are computed with a
default function.

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

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.