hyperformula icon indicating copy to clipboard operation
hyperformula copied to clipboard

ODFF 1.3 Small Group Evaluator functions

Open wojciechczerniak opened this issue 4 years ago • 2 comments

Description

Extracted from #61. Track the list of functions that we need to implement to meet the ODFF Small Evaluator requirements.

  • [x] ABS 6.16.2 #13
  • [x] ACOS 6.16.3 #13
  • [x] AND 6.15.2 #13
  • [x] ASIN 6.16.7 #13
  • [x] ATAN 6.16.9 #13
  • [x] ATAN2 6.16.10
  • [x] AVERAGE 6.18.3 #13
  • [x] AVERAGEIF 6.18.5 #13
  • [x] CHOOSE 6.14.3
  • [x] COLUMNS 6.13.5
  • [x] COS 6.16.19 #13
  • [x] COUNT 6.13.6
  • [x] COUNTA 6.13.7
  • [x] COUNTBLANK 6.13.8 #13
  • [x] COUNTIF 6.13.9 #13
  • [x] DATE 6.10.2 #13
  • [ ] DAVERAGE 6.9.2
  • [x] DAY 6.10.5 #13
  • [ ] DCOUNT 6.9.3
  • [ ] DCOUNTA 6.9.4
  • [x] DDB 6.12.14
  • [x] DEGREES 6.16.25 #13
  • [ ] DGET 6.9.5
  • [ ] DMAX 6.9.6
  • [ ] DMIN 6.9.7
  • [ ] DPRODUCT 6.9.8
  • [ ] DSTDEV 6.9.9
  • [ ] DSTDEVP 6.9.10
  • [ ] DSUM 6.9.11
  • [ ] DVAR 6.9.12
  • [ ] DVARP 6.9.13
  • [x] EVEN 6.16.30 #13
  • [x] EXACT 6.20.8
  • [x] EXP 6.16.31
  • [x] FACT 6.16.32
  • [x] FALSE 6.15.3 #13
  • [x] FIND 6.20.9
  • [x] FV 6.12.20
  • [x] HLOOKUP 6.14.5
  • [x] HOUR 6.10.10
  • [x] IF 6.15.4 #13
  • [x] INDEX 6.14.6
  • [x] INT 6.17.2 #13
  • [ ] IRR 6.12.24
  • [x] ISBLANK 6.13.14
  • [x] ISERR 6.13.15
  • [x] ISERROR 6.13.16
  • [x] ISLOGICAL 6.13.19
  • [x] ISNA 6.13.20
  • [x] ISNONTEXT 6.13.21
  • [x] ISNUMBER 6.13.22
  • [x] ISTEXT 6.13.25
  • [x] LEFT 6.20.12
  • [x] LEN 6.20.13
  • [x] LN 6.16.39 #13
  • [x] LOG 6.16.40 #13
  • [x] LOG10 6.16.41 #13
  • [x] LOWER 6.20.14
  • [x] MATCH 6.14.9
  • [x] MAX 6.18.45 #13
  • [x] MID 6.20.15
  • [x] MIN 6.18.48 #13
  • [x] MINUTE 6.10.12
  • [x] MOD 6.16.42 #13
  • [x] MONTH 6.10.13
  • [ ] N 6.13.26
  • [x] NA 6.13.27
  • [x] NOT 6.15.7 #13
  • [x] NOW 6.10.15
  • [x] NPER 6.12.29
  • [x] NPV 6.12.30
  • [x] ODD 6.16.44 #13
  • [x] OR 6.15.8 #13
  • [x] PI 6.16.45 #13
  • [x] PMT 6.12.36
  • [x] POWER 6.16.46 #13
  • [x] PRODUCT 6.16.47
  • [x] PROPER 6.20.16
  • [x] PV 6.12.41
  • [x] RADIANS 6.16.49
  • [x] RATE 6.12.42
  • [x] REPLACE 6.20.17
  • [x] REPT 6.20.18
  • [x] RIGHT 6.20.19
  • [x] ROUND 6.17.5 #13
  • [x] ROWS 6.13.30
  • [x] SECOND 6.10.16
  • [x] SIN 6.16.55 #13
  • [x] SLN 6.12.45
  • [x] SQRT 6.16.58 #13
  • [x] STDEV 6.18.72
  • [x] STDEVP 6.18.74
  • [x] SUBSTITUTE 6.20.21
  • [x] SUM 6.16.61 #13
  • [x] SUMIF 6.16.62 #13
  • [x] SYD 6.12.46
  • [x] T 6.20.22
  • [x] TAN 6.16.69 #13
  • [x] TIME 6.10.17
  • [x] TODAY 6.10.19
  • [x] TRIM 6.20.24
  • [x] TRUE 6.15.9 #13
  • [x] TRUNC 6.17.8 #13
  • [x] UPPER 6.20.27
  • [x] VALUE 6.13.34
  • [x] VAR 6.18.82
  • [x] VARP 6.18.84
  • [x] VLOOKUP 6.14.12
  • [x] WEEKDAY 6.10.20
  • [x] YEAR 6.10.23

wojciechczerniak avatar Mar 26 '20 09:03 wojciechczerniak

Any progress on IRR?

lopezjurip avatar Dec 13 '21 20:12 lopezjurip

Hi @lopezjurip IRR is not yet implemented. I will notify you once we add it.

AMBudnik avatar Dec 14 '21 10:12 AMBudnik