OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

# office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Updated: (OFFICE-1075) Public Comment: Re:[office-comment] ODFF: NPV

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Mon, 18 Jan 2010 09:02:15 -0500 (EST)

```
[ http://tools.oasis-open.org/issues/browse/OFFICE-1075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eike Rathke updated OFFICE-1075:
--------------------------------

Proposal:
For XNPV:

Change Syntax from
XNPV( Number Rate ; NumberSequence Values ; DateSequence Dates )
to
XNPV( Number Rate ; Array Values ; Array Dates )

Number of elements in Values equals number of elements in Dates.
All elements of Values of type Number.
All elements of Dates of type Number.
All elements of Dates >= Dates

Change Semantics:
From Dates, remove "The range of Values and Dates must be the same size."
If dimensions of arrays Values and Dates differ, evaluators shall match value and date pairs row-wise starting from top left.

With N being the number of elements in Values and Dates each, the formula is
XNPV = sum from{i=1} to{N} {{Values_i} over { left( 1 + Rate right) ^ {{Dates_i - Dates_1} over 365}}}

For SERIESSUM:

Change Syntax from
SERIESSUM( Number X ; Number N ; Number M ; NumberSequence Coefficients )
to
SERIESSUM( Number X ; Number N ; Number M ; Array Coefficients )

All elements of Coefficients of type Number.

For NPV:

Change text formula to math formula:
from
If n is the number of values in the NumberSequence Value, the formula for NPV is:
NPV = sum (from i=1 to n) ( values[i] / (1+Rate)^i)
to
With N being the number of elements in Values, the formula is
NPV = sum from{i=1} to{N} {Values_i over left( 1 + Rate right) ^ i}

was:
For XNPV:

Change Syntax from
XNPV( Number Rate ; NumberSequence Values ; DateSequence Dates )
to
XNPV( Number Rate ; Array Values ; Array Dates )

Number of elements in Values equals number of elements in Dates.
All elements of Values of type Number.
All elements of Dates of type Number.
All elements of Dates >= Dates

Change Semantics:
From Dates, remove "The range of Values and Dates must be the same size."
If dimensions of arrays Values and Dates differ, evaluators shall match value and date pairs row-wise starting from top left.

With N being the number of elements in Values and Dates each, the formula is
XNPV = sum from{i=1} to{N} {{Values_i} over { left( 1 + Rate right) ^ {{Dates_i - Dates_1} over 365}}}

For SERIESSUM:

Change Syntax from
SERIESSUM( Number X ; Number N ; Number M ; NumberSequence Coefficients )
to
SERIESSUM( Number X ; Number N ; Number M ; Array Coefficients )

All elements of Coefficients of type Number.

For NPV:

Change text formula to math formula:
from
If n is the number of values in the NumberSequence Value, the formula for NPV is:
NPV = sum (from i=1 to n) ( values[i] / (1+Rate)^i)
to
With N being the number of elements in Values, the formula is
NPV = sum from{i=1} to{N} {Values_i over left( 1 + Rate right) ^ i}

> Public Comment: Re: [office-comment] ODFF: NPV
> ----------------------------------------------
>
>                 Key: OFFICE-1075
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1075
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Robert Weir
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2
>
>
> Copied from office-comment list
> Original author: "David King" <openoffice@drking.plus.com>
> Original date: 14 Aug 2008 18:12:53 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200808/msg00045.html

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-