# Calc/Drafts/Treatment of new Excel 2010 functions

This article is a workspace for discussing the treatment of new functions of Excel 2010 in OpenOffice.org **code**. For using functions in spreadsheets look at Documentation/How_Tos/Calc:_Functions_listed_alphabetically

Please do not chance the layout to a table. Such table makes it hard to edit a single section.

You want to help collecting the information? Try to add: Which parameters has the function? Does a corresponding OOo function exists already? Does a corresponding function exists in ODF 1.2? How difficult is it to implement a new function if necessary? Do you see any problems or obstacles?

## Contents

- 1 Reference Documents
- 2 AGGREGATE
- 3 BETA.DIST
- 4 BETA.INV
- 5 BINOM.DIST
- 6 BINOM.INV
- 7 CHISQ.DIST
- 8 CHISQ.DIST.RT
- 9 CHISQ.INV
- 10 CHISQ.INV.RT
- 11 CHISQ.TEST
- 12 CONFIDENCE.NORM
- 13 CONFIDENCE.T
- 14 COVARIANCE.P
- 15 COVARIANCE.S
- 16 EXPON.DIST
- 17 F.DIST
- 18 F.DIST.RT
- 19 F.INV
- 20 F.INV.RT
- 21 F.TEST
- 22 GAMMA.DIST
- 23 GAMMA.INV
- 24 HYPGEOM.DIST
- 25 ISO.CEILING
- 26 LOGNORM.DIST
- 27 LOGNORM.INV
- 28 MODE.MULT
- 29 MODE.SNGL
- 30 NEGBINOM.DIST
- 31 NETWORKDAYS.INTL
- 32 NORM.DIST
- 33 NORM.INV
- 34 NORM.S.DIST
- 35 NORM.S.INV
- 36 PERCENTILE.EXC
- 37 PERCENTILE.INC
- 38 PERCENTRANK.EXC
- 39 PERCENTRANK.INC
- 40 POISSON.DIST
- 41 QUARTILE.EXC
- 42 QUARTILE.INC
- 43 RANK.AVG
- 44 RANK.EQ
- 45 STDEV.P
- 46 STDEV.S
- 47 T.DIST
- 48 T.DIST.2T
- 49 T.DIST.RT
- 50 T.INV
- 51 T.INV.2T
- 52 T.TEST
- 53 VAR.P
- 54 VAR.S
- 55 WEIBULL.DIST
- 56 WORKDAY.INTL
- 57 Z.TEST

## Reference Documents

The discussion uses the description of the new functions in Function Improvements in Microsoft Office Excel 2010 and in What's New: Changes made to Excel functions and the connected descriptions of the functions.

For ODF 1.2 the actual document from OpenDocument - Formula SC Public Documents is used.

## AGGREGATE

new

## BETA.DIST

renamed BETADIST

## BETA.INV

renamed BETAINV

## BINOM.DIST

renamed BINOMDIST

## BINOM.INV

renamed CRITBINOM

## CHISQ.DIST

new

- Excel
- CHISQ.DIST(x,deg_freedom,cumulative), all parameters required
- x >= 0
- deg_freedom is truncated to integer, 0<deg_freedom<=10^10
- cumulative is logical, but numbers are accepted too
- ODF1.2
- CHISQDIST( Number x ; Number DegreesOfFreedom [ ; Logical Cumulative = TRUE() ] )
- OOo3.2
- is already implemented as ODF1.2 definies
- no constraints for x
- DegreesOfFreedom are truncated as in Excel, DegreesOfFreedom > 0, no fixed upper bound for DegreesOfFreedom

### Comment

Directly mapping is possible in import.

## CHISQ.DIST.RT

renamed CHIDIST

## CHISQ.INV

new

## CHISQ.INV.RT

renamed CHIINV

## CHISQ.TEST

renamed CHITEST

## CONFIDENCE.NORM

renamed CONFIDENCE

## CONFIDENCE.T

new

## COVARIANCE.P

renamed COVAR

## COVARIANCE.S

new

## EXPON.DIST

renamed EXPONDIST

## F.DIST

new

## F.DIST.RT

renamed FDIST

## F.INV

new

## F.INV.RT

renamed FINV

## F.TEST

renamed FTEST

## GAMMA.DIST

renamed GAMMADIST

## GAMMA.INV

renamed GAMMAINV

## HYPGEOM.DIST

renamed HYPGEOMDIST

## ISO.CEILING

new

## LOGNORM.DIST

renamed LOGNORMDIST

## LOGNORM.INV

renamed LOGINV

## MODE.MULT

new

## MODE.SNGL

renamed MODE

## NEGBINOM.DIST

renamed NEGBINOMDIST

## NETWORKDAYS.INTL

new

## NORM.DIST

renamed NORMDIST

## NORM.INV

renamed NORMINV

## NORM.S.DIST

renamed NORMSDIST

## NORM.S.INV

renamed NORMSINV

## PERCENTILE.EXC

new

## PERCENTILE.INC

renamed PERCENTILE

## PERCENTRANK.EXC

new

## PERCENTRANK.INC

renamed PERCENTRANK

## POISSON.DIST

renamed POISSON

## QUARTILE.EXC

new

## QUARTILE.INC

renamed QUARTILE

## RANK.AVG

new

## RANK.EQ

renamed RANK

## STDEV.P

renamed STDEVP

## STDEV.S

renamed STDEV

## T.DIST

new

## T.DIST.2T

renamed TDIST

## T.DIST.RT

renamed TDIST

## T.INV

new

## T.INV.2T

renamed TINV

## T.TEST

renamed TTEST

## VAR.P

renamed VARP

## VAR.S

renamed VAR

## WEIBULL.DIST

renamed WEIBULL

## WORKDAY.INTL

new

## Z.TEST

renamed ZTEST