[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
[ 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 )
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
was:
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.
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
> 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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]