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

*Subject*: **RE: [office-formula] office-2227: Proposed Resolution**

*From*:**Eric Patterson <ericpa@exchange.microsoft.com>***To*: "office-formula@lists.oasis-open.org"<office-formula@lists.oasis-open.org>*Date*: Mon, 18 Jan 2010 23:18:21 +0000

I've merged my proposed changes with Eike's from Office-1075. I've inserted a math formula object using Eike's formula from Office-1075 (XNPV = sum from{i=1} to{N} {{Values_i} over { left( 1 + Rate right) ^ {{Dates_i - Dates_1} over 365}}}), but the minus sign between Dates_i and Dates_1 doesn't seem to appear in the math formula object. -Eric -----Original Message----- From: Eike Rathke [mailto:erack@sun.com] Sent: Monday, January 18, 2010 8:14 AM To: office-formula@lists.oasis-open.org Subject: Re: [office-formula] office-2227: Proposed Resolution Hi Eric, On Saturday, 2010-01-16 00:02:25 +0000, Eric Patterson wrote: > Attached is the proposed updated to the XNPV function for Office-2227. Thanks. Please see also http://tools.oasis-open.org/issues/browse/OFFICE-1075 for additional changes. I added that to the Proposal field. It isn't quite clear to me what the wording "optional" in | The first cash-flow amount is optional and corresponds to a cost or | payment that occurs at the beginning of the investment, represented by | a negative number. would imply. To my understanding the first amount can't be optional but must be present, it is an element of an Array (note: not NumberSequence, see OFFICE-1075) argument. It think optional here means that the value does not necessarily have to be negative. If yes, shouldn't that be worded different? Btw, for mathematical formulas please use a math formula object instead of an image, and in the formula use variable names corresponding to the parameter names. Thanks Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.

**Follow-Ups**:**Re: [office-formula] office-2227: Proposed Resolution***From:*Eike Rathke <erack@sun.com>

**[office-formula] Test Cases***From:*Eric Patterson <ericpa@exchange.microsoft.com>

**References**:**office-2246***From:*"Andreas J. Guelzow" <aguelzow@math.concordia.ab.ca>

**[office-formula] office-2227: Proposed Resolution***From:*Eric Patterson <ericpa@exchange.microsoft.com>

**Re: [office-formula] office-2227: Proposed Resolution***From:*Eike Rathke <erack@sun.com>

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