search

dgorissen / pycel

A library for compiling excel spreadsheets to python code & visualizing them as a graph
GNU General Public License v3.0
565 stars 147 forks source link

Improve LINEST(), add several other stats and info functions #122

Closed stephenrauch closed 3 years ago

stephenrauch commented 3 years ago

Implement ISLOGICAL(), ISNONTEXT(), N() & NA() Implement SUBSTITUTE() Add str_params to excel_helper() Implement CHOOSE() Improve LINEST() Add SLOPE(), INTERCEPT(), FORECAST(), TREND()

codecov-commenter commented 3 years ago

Codecov Report

Merging #122 (c3969fc) into master (b665734) will not change coverage. The diff coverage is 100.00%.

Impacted file tree graph

@@            Coverage Diff             @@
##            master      #122    +/-   ##
==========================================
  Coverage   100.00%   100.00%            
==========================================
  Files           16        17     +1     
  Lines         3263      3420   +157     
  Branches       789       822    +33     
==========================================
+ Hits          3263      3420   +157
Impacted Files Coverage Δ
src/pycel/excelformula.py 100.00% <ø> (ø)
src/pycel/excelutil.py 100.00% <ø> (ø)
src/pycel/lib/date_time.py 100.00% <ø> (ø)
src/pycel/lib/engineering.py 100.00% <ø> (ø)
src/pycel/lib/function_info_data.py 100.00% <ø> (ø)
src/pycel/excelcompiler.py 100.00% <100.00%> (ø)
src/pycel/excellib.py 100.00% <100.00%> (ø)
src/pycel/lib/function_helpers.py 100.00% <100.00%> (ø)
src/pycel/lib/function_info.py 100.00% <100.00%> (ø)
src/pycel/lib/information.py 100.00% <100.00%> (ø)
... and 5 more

Continue to review full report at Codecov.

Legend - Click here to learn more Δ = absolute <relative> (impact), ø = not affected, ? = missing data Powered by Codecov. Last update b665734...c3969fc. Read the comment docs.