Formulas

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

Feat
~~~~
- (contrib): Add contribution instructions.

- (setup): Add additional project_urls.

- (setup): Update `Development Status` to `4 - Beta`.


Fix
~~~

- (init) :gh:`15`: Replace `FUNCTIONS` and `OPERATORS` objs with
`get_functions`, `SUBMODULES`.

- (doc): Correct link docs_status.

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

Feat
~~~~
- (readme) :gh:`6`, :gh:`7`: Add examples.

- (doc): Add changelog.

- (test): Add info of executed test of `test_excel_model`.

- (functions) :gh:`11`: Add `HEX2OCT`, `HEX2BIN`, `HEX2DEC`, `OCT2HEX`,
`OCT2BIN`, `OCT2DEC`, `BIN2HEX`, `BIN2OCT`, `BIN2DEC`, `DEC2HEX`,
`DEC2OCT`, and `DEC2BIN` functions.

- (setup) :gh:`13`: Add extras_require to setup file.


Fix
~~~
- (excel): Use DispatchPipe to compile a sub model of excel workbook.

- (range) :gh:`11`: Correct range regex to avoid parsing of function
like ranges (e.g., HEX2DEC).

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

Feat
~~~~
- (look): Simplify `_get_type_id` function.


Fix
~~~
- (functions): Correct ImportError for FUNCTIONS.

- (operations): Correct behaviour of the basic operations.

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

Feat
~~~~
- (excel): Improve performances pre-calculating the range format.

- (core): Improve performances using `DispatchPipe` instead
`SubDispatchPipe` when compiling formulas.

- (function): Improve performances setting `errstate` outside
vectorization.

- (core): Improve performances of range2parts function (overall 50%
faster).


Fix
~~~
- (ranges): Minimize conversion str to int and vice versa.

- (functions) :gh:`10`: Avoid returning shapeless array.

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

Feat
~~~~
- (functions): Add `MATCH`, `LOOKUP`, `HLOOKUP`, `VLOOKUP` functions.

- (excel): Add method to compile `ExcelModel`.

- (travis): Run coveralls in python 3.6.

- (functions): Add
`FIND`,`LEFT`,`LEN`,`LOWER`,`MID`,`REPLACE`,`RIGHT`,`TRIM`, and`UPPER`
functions.

- (functions): Add `IRR` function.

- (formulas): Custom reshape to Array class.

- (functions): Add `ISO.CEILING`, `SQRTPI`, `TRUNC` functions.

- (functions): Add `ROUND`, `ROUNDDOWN`, `ROUNDUP`, `SEC`, `SECH`,
`SIGN` functions.

- (functions): Add `DECIMAL`, `EVEN`, `MROUND`, `ODD`, `RAND`,
`RANDBETWEEN` functions.

- (functions): Add `FACT` and `FACTDOUBLE` functions.

- (functions): Add `ARABIC` and `ROMAN` functions.

- (functions): Parametrize function `wrap_ufunc`.

- (functions): Split function `raise_errors` adding `get_error`
function.

- (ranges): Add custom default and error value for defining ranges
Arrays.

- (functions): Add `LOG10` function + fix `LOG`.

- (functions): Add `CSC` and `CSCH` functions.

- (functions): Add `COT` and `COTH` functions.

- (functions): Add `FLOOR`, `FLOOR.MATH`, and `FLOOR.PRECISE` functions.

- (test): Improve log message of test cell.


Fix
~~~
- (rtd): Update installation file for read the docs.

- (functions): Remove unused functions.

- (formulas): Avoid too broad exception.

- (functions.math): Drop scipy dependency for calculate factorial2.

- (functions.logic): Correct error behaviour of `if` and `iferror`
functions + add BroadcastError.

- (functions.info): Correct behaviour of `iserr` function.

- (functions): Correct error behaviour of average function.

- (functions): Correct `iserror` and `iserr` returning a custom Array.

- (functions): Now `xceiling` function returns np.nan instead
Error.errors['NUM!'].

- (functions): Correct `is_number` function, now returns False when
number is a bool.

- (test): Ensure same order of workbook comparisons.

- (functions): Correct behaviour of `min` `max` and `int` function.

- (ranges): Ensure to have a value with correct shape.

- (parser): Change order of parsing to avoid TRUE and FALSE parsed as
ranges or errors as strings.

- (function):Remove unused kwargs n_out.

- (parser): Parse error string as formulas.

- (readme): Remove `downloads_count` because it is no longer available.


Other
~~~~~
- Refact: Update Copyright + minor pep.

- Excel returns 1-indexed string positions???

- Added common string functions.

- Merge pull request :gh:`9` from ecatkins/irr.

- Implemented IRR function using numpy.

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

Feat
~~~~
- (appveyor): Add python 3.6.

- (functions) :gh:`4`: Add `sumproduct` function.


Fix
~~~
- (install): Force update setuptools>=36.0.1.

- (functions): Correct `iserror` `iserr` functions.

- (ranges): Replace 'N/A' with '' as empty value when assemble values.

- (functions) :gh:`4`: Remove check in ufunc when inputs have different
size.

- (functions) :gh:`4`: Correct `power`, `arctan2`, and `mod` error
results.

- (functions) :gh:`4`: Simplify ufunc code.

- (test) :gh:`4`: Check that all results are in the output.

- (functions) :gh:`4`: Correct `atan2` argument order.

- (range) :gh:`5`: Avoid parsing function name as range when it is
followed by `(`.

- (operator) :gh:`3`: Replace `strip` with `replace`.

- (operator) :gh:`3`: Correct valid operators like `^-` or `*+`.


Other
~~~~~
- Made the ufunc wrapper work with multi input functions, e.g., power,
mod, and atan2.

- Created a workbook comparison method in TestExcelModel.

- Added MIN and MAX to the test.xlsx.

- Cleaned up the ufunc wrapper and added min and max to the functions
list.

- Relaxed equality in TestExcelModel and made some small fixes to
functions.py.

- Added a wrapper for numpy ufuncs, mapped some Excel functions to
ufuncs and provided tests.