Formulas

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

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`.

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

Feat
~~~~
- (doc) :gh:`23`: Enhance `ExcelModel` documentation.


Fix
~~~
- (core): Add python 3.7 and drop python 3.4.

- (excel): Make `ExcelModel` dillable and pickable.

- (builder): Avoid FormulaError exception during formulas compilation.

- (excel): Correct bug when compiling excel with circular references.

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

Fix
~~~
- (tokens) :gh:`20`: Improve Number regex.

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

Feat
~~~~
- (excel) :gh:`16`: Solve circular references.

- (setup): Add donate url.


Fix
~~~

- (functions) :gh:`18`: Enable `check_error` in `IF` function just for
the first argument.

- (functions) :gh:`18`: Disable `input_parser` in `IF` function to
return any type of values.

- (rtd): Define `fpath` from `prj_dir` for rtd.

- (rtd): Add missing requirements `openpyxl` for rtd.

- (setup): Patch to use `sphinxcontrib.restbuilder` in setup
`long_description`.


Other
~~~~~
- Update documentation.

- Replace `excel` with `Excel`.

- Create PULL_REQUEST_TEMPLATE.md.

- Update issue templates.

- Update copyright.

- (doc): Update author mail.

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

Feat
~~~~
- (functions) :gh:`14`: Add `ROW` and `COLUMN`.

- (cell): Pass cell reference when compiling cell + new function struct
with dict to add inputs like CELL.

Fix
~~~
- (ranges): Replace system max size with excel max row and col.

- (tokens): Correct number regex.