Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=Vz2JATnFnnHaIiW8Lv9SrtJ33fjNk5Fo49tHeQ+UmlqeQ3G6FM8d2gSkS+8c0uRJb+HktdOI+GsA8g874xQTgKCrIUtDvHSZ1kKTPPfPQznCxLNfBZpXvIgVOTgmRPR3N03K75KacxPOS8Ppn5gLrOOemRScPBMi3BvOVaYJxJg=;
Message-ID: <693115.9085.qm@web113614.mail.gq1.yahoo.com>
References: <AANLkTim1F-Vm8GE7r3psbACCqNtfXQE12T+APM_KKHjf@mail.gmail.com>
 <alpine.DEB.1.10.1012050959500.20427@urchin.earth.li>
 <AANLkTi=Sj5rA6ipJDq-Rqf1KyuFL34r3VumiYKTwP73s@mail.gmail.com>
 <4CFC98DD.7030302@dinom.ru>
 <AANLkTi=bN0MTQhmxLsYKsec=tE+YCgmF1uuAo78R50kM@mail.gmail.com>
 <4CFD0E3A.2000108@dinom.ru>
 <AANLkTi=Me_1xQJSFgBO0VS_hgKPDf7T0kpc7sgSVFXNL@mail.gmail.com>
 <335744.45102.qm@web113607.mail.gq1.yahoo.com>
 <671717.20030.qm@web113619.mail.gq1.yahoo.com>
 <987085.37359.qm@web113606.mail.gq1.yahoo.com>
 <2A82C1F9-9958-449C-A1F1-891844A8C5D1@consol.de>
 <80508634-064C-40F8-B9C9-2ECC41C3F130@gmail.com>
 <E7CE479E-1922-40DC-938F-E0C219BC22F5@jmlafferty.com>
 <188225.70711.qm@web113605.mail.gq1.yahoo.com>
Date: Wed, 8 Dec 2010 20:28:24 -0800 (PST)
From: Jon Svede <jsvede@yahoo.com>
Subject: Re: NPV bug?
To: POI Users List <user@poi.apache.org>
In-Reply-To: <188225.70711.qm@web113605.mail.gq1.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

I created issue #50437 and attached my .xls file.  Marcel can work from that and 
submit his test case or I can create one.  


Jon


----- Original Message ----
From: Jon Svede <jsvede@yahoo.com>
To: POI Users List <user@poi.apache.org>
Sent: Wed, December 8, 2010 9:10:40 PM
Subject: Re: NPV bug?

Hi all,

Sorry for the delay in responding.

I can create the ticket and the test case,  I'll try to get to this by the end 
of the week.

Thanks for the confirmation!

Jon


----- Original Message ----
From: David Fisher <dfisher@jmlafferty.com>
To: POI Users List <user@poi.apache.org>
Sent: Wed, December 8, 2010 5:42:15 PM
Subject: Re: NPV bug?

Hi Marcel,

Please have a look at http://poi.apache.org/guidelines.html in the "Submitting 
Patches" section.

Thanks and Regards,
Dave

On Dec 8, 2010, at 2:46 PM, Marcel May wrote:

> <npv.patch.txt>
> 
> Oops, the patch got swallowed.
> 
> On Dec 9, 2010, at 2:33 AM, Marcel May wrote:
> 
>> I can confirm this is a bug - just had the same problem.
>> 
>> a)  the NPV computation is wrong
>> -            sum += ds[i] / Math.pow(rate + 1, i);
>> +            sum += ds[i] / Math.pow(rate + 1, i+1);
>>        
>>   I think the computation should actually use the FinanceLib#npv method (which 
>
>>is correct).
>> 
>> b) The impl does not support ranges
>> 
>> I got a patch fix a) and b), including a test case:
>> 
>> 
>> 
>> Jon, do you want to create the bug ticket? Then I'll add my patch for it.
>> 
>> Cheers,
>> Marcel
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org