# Public Comment: Re: [office-comment] ODFF: NPV

XMLWordPrintable

#### Details

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: None
• Fix Version/s:
• Component/s:
• Labels:
None
• Proposal:
Hide

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[1]

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}

Show
For XNPV: Change Syntax from XNPV( Number Rate ; NumberSequence Values ; DateSequence Dates ) to XNPV( Number Rate ; Array Values ; Array Dates ) Add Contraints: 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 [1] Change Semantics: From Dates, remove "The range of Values and Dates must be the same size." Add: If dimensions of arrays Values and Dates differ, evaluators shall match value and date pairs row-wise starting from top left. For additional semantics see OFFICE-2227 Add formula: 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 ) Add to Constraints: 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} Add to See also: XNPV

#### Description

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

#### People

• Assignee:
Eike Rathke (Inactive)
Reporter:
Robert Weir (Inactive)
• Watchers:
0 Start watching this issue

#### Dates

• Created:
Updated:
Resolved: