[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. 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} > 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]