You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Blake Watson <bl...@pnmac.com> on 2016/11/23 00:14:10 UTC
Bug in RATE
I believe I've found a bug in the RATE implementation. If I call evaluate
with these parameters:
(327, 1156.9, -271000, 0, 0)
I get "0.00216265554813563", which matches Excel.
But if I call with:
(328, 1156.9, -271000, 0, 0)
I get "2.21559209725119E-15".
Which doesn't match (and is suddenly tiny).
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com <me...@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>
Re: Bug in RATE
Posted by Blake Watson <bl...@pnmac.com>.
Thanks, Javen.
On Wed, Nov 23, 2016 at 10:15 AM, Javen O'Neal <on...@apache.org> wrote:
> My email editor deleted a couple links
>
> 1. Svn checkout
> https://urldefense.proofpoint.com/v2/url?u=https-3A__poi.
> apache.org_subversion.html&d=DgIBaQ&c=dmLomitc30UP5j2qU8E1rg&r=
> p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&m=
> ywVjujANmewevZzklsLgayc0tgq6ktSx0CVxUTE6vPc&s=
> GRphm4qmhkNb7G9CsC1HVyMYffimHEge9cMIQKs-Fdg&e=
>
> 2. How to build
> https://urldefense.proofpoint.com/v2/url?u=https-3A__poi.
> apache.org_howtobuild.html&d=DgIBaQ&c=dmLomitc30UP5j2qU8E1rg&r=
> p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&m=
> ywVjujANmewevZzklsLgayc0tgq6ktSx0CVxUTE6vPc&s=
> 3bCky2bau7T19ZZPV8UU5iLHT4gJuCs2xd35ZmGgQ2o&e=
>
> On Nov 23, 2016 10:13 AM, "Javen O'Neal" <on...@apache.org> wrote:
>
> > 1. Check out the code from Subversion
> >
> > 2. Set up your environment (Eclipse works well, as much as people like to
> > hate on it)
> >
> > 3. Test your changes and submit a patch
> > https://urldefense.proofpoint.com/v2/url?u=https-3A__poi.
> apache.org_guidelines.html-23Submitting-2BPatches&d=DgIBaQ&c=
> dmLomitc30UP5j2qU8E1rg&r=p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&m=
> ywVjujANmewevZzklsLgayc0tgq6ktSx0CVxUTE6vPc&s=
> 7b1oMb0IsJCF1MrqFTG8XgPent0N2Nt7O0RUOdvPGpE&e=
> >
> > Someone has already taken a stab at this on Stack Overflow [1], though
> > this code is not ASL 2.0 licensed, so we cannot use it unless the author
> > licenses their snippet as ASL 2.0. Feel free to either contact the author
> > or use their code for 100 km-altitude inspiration.
> >
> > [1] https://urldefense.proofpoint.com/v2/url?u=http-3A__
> stackoverflow.com_questions_14031208_apache-2Dpoi-2D&d=DgIBaQ&c=
> dmLomitc30UP5j2qU8E1rg&r=p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&m=
> ywVjujANmewevZzklsLgayc0tgq6ktSx0CVxUTE6vPc&s=d3BMEzm5wNOjKZ_
> nQazqhOcq5L5X9v6d5i_TtzxwEuo&e=
> > rate-formula-inconsistency-with-long-periods/14087532#14087532
> >
> > On Nov 23, 2016 9:34 AM, "Blake Watson" <bl...@pnmac.com> wrote:
> >
> > I'd be willing to. I don't really have an idea how to start. (I'm coding
> in
> > Clojure.) Is there an orientation document for contributing to POI?
> >
> > On Tue, Nov 22, 2016 at 5:10 PM, Javen O'Neal <on...@apache.org> wrote:
> >
> > > This looks similar to https://urldefense.proofpoint.
> com/v2/url?u=https-3A__urldefense.proofpoint&d=DgIBaQ&c=
> dmLomitc30UP5j2qU8E1rg&r=p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&m=
> ywVjujANmewevZzklsLgayc0tgq6ktSx0CVxUTE6vPc&s=b74IAV-
> UghR790K6imTYNezGm0LAs49m1QYB1PPrvbs&e= .
> > > com/v2/url?u=https-3A__bz.apache.org_bugzilla_show-
> > > 5Fbug.cgi-3Fid-3D54349&d=DgIBaQ&c=dmLomitc30UP5j2qU8E1rg&r=
> > > p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&m=
> > > RpP8zt6OmJVNKxPp3JhDjmMzYY9GiIKif_VSFRATvQc&s=
> > > DT9o5SSkYPR7rbIc5rWtwswHuqfFTAXSKnTNkhfvcuo&e=
> > >
> > > The only thing missing for this bug is some unit tests. Would you be
> > > willing to write up some unit tests and upload to this bug?
> > >
> > > On Nov 22, 2016 4:15 PM, "Blake Watson" <bl...@pnmac.com>
> wrote:
> > >
> > > > I believe I've found a bug in the RATE implementation. If I call
> > evaluate
> > > > with these parameters:
> > > >
> > > > (327, 1156.9, -271000, 0, 0)
> > > >
> > > > I get "0.00216265554813563", which matches Excel.
> > > >
> > > > But if I call with:
> > > >
> > > > (328, 1156.9, -271000, 0, 0)
> > > >
> > > > I get "2.21559209725119E-15".
> > > >
> > > > Which doesn't match (and is suddenly tiny).
> > > >
> > > > --
> > > >
> > > > *Blake Watson*
> > > >
> > > > *PNMAC*
> > > > Application Development Manager
> > > > 5898 Condor Drive
> > > > Moorpark, CA 93021
> > > > (805) 330.4911 x7742
> > > > blake.watson@pnmac.com <me...@pnmac.com>
> > > > www.PennyMacUSA.com <http://www.pennymacusa.com/>
> > > >
> > >
> >
> >
> >
> > --
> >
> > *Blake Watson*
> >
> > *PNMAC*
> > Application Development Manager
> > 5898 Condor Drive
> > Moorpark, CA 93021
> > (805) 330.4911 x7742
> > blake.watson@pnmac.com <me...@pnmac.com>
> > www.PennyMacUSA.com <http://www.pennymacusa.com/>
> >
> >
> >
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com <me...@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>
Re: Bug in RATE
Posted by Javen O'Neal <on...@apache.org>.
My email editor deleted a couple links
1. Svn checkout
https://poi.apache.org/subversion.html
2. How to build
https://poi.apache.org/howtobuild.html
On Nov 23, 2016 10:13 AM, "Javen O'Neal" <on...@apache.org> wrote:
> 1. Check out the code from Subversion
>
> 2. Set up your environment (Eclipse works well, as much as people like to
> hate on it)
>
> 3. Test your changes and submit a patch
> https://poi.apache.org/guidelines.html#Submitting+Patches
>
> Someone has already taken a stab at this on Stack Overflow [1], though
> this code is not ASL 2.0 licensed, so we cannot use it unless the author
> licenses their snippet as ASL 2.0. Feel free to either contact the author
> or use their code for 100 km-altitude inspiration.
>
> [1] http://stackoverflow.com/questions/14031208/apache-poi-
> rate-formula-inconsistency-with-long-periods/14087532#14087532
>
> On Nov 23, 2016 9:34 AM, "Blake Watson" <bl...@pnmac.com> wrote:
>
> I'd be willing to. I don't really have an idea how to start. (I'm coding in
> Clojure.) Is there an orientation document for contributing to POI?
>
> On Tue, Nov 22, 2016 at 5:10 PM, Javen O'Neal <on...@apache.org> wrote:
>
> > This looks similar to https://urldefense.proofpoint.
> > com/v2/url?u=https-3A__bz.apache.org_bugzilla_show-
> > 5Fbug.cgi-3Fid-3D54349&d=DgIBaQ&c=dmLomitc30UP5j2qU8E1rg&r=
> > p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&m=
> > RpP8zt6OmJVNKxPp3JhDjmMzYY9GiIKif_VSFRATvQc&s=
> > DT9o5SSkYPR7rbIc5rWtwswHuqfFTAXSKnTNkhfvcuo&e=
> >
> > The only thing missing for this bug is some unit tests. Would you be
> > willing to write up some unit tests and upload to this bug?
> >
> > On Nov 22, 2016 4:15 PM, "Blake Watson" <bl...@pnmac.com> wrote:
> >
> > > I believe I've found a bug in the RATE implementation. If I call
> evaluate
> > > with these parameters:
> > >
> > > (327, 1156.9, -271000, 0, 0)
> > >
> > > I get "0.00216265554813563", which matches Excel.
> > >
> > > But if I call with:
> > >
> > > (328, 1156.9, -271000, 0, 0)
> > >
> > > I get "2.21559209725119E-15".
> > >
> > > Which doesn't match (and is suddenly tiny).
> > >
> > > --
> > >
> > > *Blake Watson*
> > >
> > > *PNMAC*
> > > Application Development Manager
> > > 5898 Condor Drive
> > > Moorpark, CA 93021
> > > (805) 330.4911 x7742
> > > blake.watson@pnmac.com <me...@pnmac.com>
> > > www.PennyMacUSA.com <http://www.pennymacusa.com/>
> > >
> >
>
>
>
> --
>
> *Blake Watson*
>
> *PNMAC*
> Application Development Manager
> 5898 Condor Drive
> Moorpark, CA 93021
> (805) 330.4911 x7742
> blake.watson@pnmac.com <me...@pnmac.com>
> www.PennyMacUSA.com <http://www.pennymacusa.com/>
>
>
>
Re: Bug in RATE
Posted by Javen O'Neal <on...@apache.org>.
1. Check out the code from Subversion
2. Set up your environment (Eclipse works well, as much as people like to
hate on it)
3. Test your changes and submit a patch
https://poi.apache.org/guidelines.html#Submitting+Patches
Someone has already taken a stab at this on Stack Overflow [1], though this
code is not ASL 2.0 licensed, so we cannot use it unless the author
licenses their snippet as ASL 2.0. Feel free to either contact the author
or use their code for 100 km-altitude inspiration.
[1]
http://stackoverflow.com/questions/14031208/apache-poi-rate-formula-inconsistency-with-long-periods/14087532#14087532
On Nov 23, 2016 9:34 AM, "Blake Watson" <bl...@pnmac.com> wrote:
I'd be willing to. I don't really have an idea how to start. (I'm coding in
Clojure.) Is there an orientation document for contributing to POI?
On Tue, Nov 22, 2016 at 5:10 PM, Javen O'Neal <on...@apache.org> wrote:
> This looks similar to https://urldefense.proofpoint.
> com/v2/url?u=https-3A__bz.apache.org_bugzilla_show-
> 5Fbug.cgi-3Fid-3D54349&d=DgIBaQ&c=dmLomitc30UP5j2qU8E1rg&r=
> p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&m=
> RpP8zt6OmJVNKxPp3JhDjmMzYY9GiIKif_VSFRATvQc&s=
> DT9o5SSkYPR7rbIc5rWtwswHuqfFTAXSKnTNkhfvcuo&e=
>
> The only thing missing for this bug is some unit tests. Would you be
> willing to write up some unit tests and upload to this bug?
>
> On Nov 22, 2016 4:15 PM, "Blake Watson" <bl...@pnmac.com> wrote:
>
> > I believe I've found a bug in the RATE implementation. If I call
evaluate
> > with these parameters:
> >
> > (327, 1156.9, -271000, 0, 0)
> >
> > I get "0.00216265554813563", which matches Excel.
> >
> > But if I call with:
> >
> > (328, 1156.9, -271000, 0, 0)
> >
> > I get "2.21559209725119E-15".
> >
> > Which doesn't match (and is suddenly tiny).
> >
> > --
> >
> > *Blake Watson*
> >
> > *PNMAC*
> > Application Development Manager
> > 5898 Condor Drive
> > Moorpark, CA 93021
> > (805) 330.4911 x7742
> > blake.watson@pnmac.com <me...@pnmac.com>
> > www.PennyMacUSA.com <http://www.pennymacusa.com/>
> >
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com <me...@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>
Re: Bug in RATE
Posted by Blake Watson <bl...@pnmac.com>.
I'd be willing to. I don't really have an idea how to start. (I'm coding in
Clojure.) Is there an orientation document for contributing to POI?
On Tue, Nov 22, 2016 at 5:10 PM, Javen O'Neal <on...@apache.org> wrote:
> This looks similar to https://urldefense.proofpoint.
> com/v2/url?u=https-3A__bz.apache.org_bugzilla_show-
> 5Fbug.cgi-3Fid-3D54349&d=DgIBaQ&c=dmLomitc30UP5j2qU8E1rg&r=
> p42pHJHEwFZOHtVFHKJUdL2fYbroN33stXXb3Psthjw&m=
> RpP8zt6OmJVNKxPp3JhDjmMzYY9GiIKif_VSFRATvQc&s=
> DT9o5SSkYPR7rbIc5rWtwswHuqfFTAXSKnTNkhfvcuo&e=
>
> The only thing missing for this bug is some unit tests. Would you be
> willing to write up some unit tests and upload to this bug?
>
> On Nov 22, 2016 4:15 PM, "Blake Watson" <bl...@pnmac.com> wrote:
>
> > I believe I've found a bug in the RATE implementation. If I call evaluate
> > with these parameters:
> >
> > (327, 1156.9, -271000, 0, 0)
> >
> > I get "0.00216265554813563", which matches Excel.
> >
> > But if I call with:
> >
> > (328, 1156.9, -271000, 0, 0)
> >
> > I get "2.21559209725119E-15".
> >
> > Which doesn't match (and is suddenly tiny).
> >
> > --
> >
> > *Blake Watson*
> >
> > *PNMAC*
> > Application Development Manager
> > 5898 Condor Drive
> > Moorpark, CA 93021
> > (805) 330.4911 x7742
> > blake.watson@pnmac.com <me...@pnmac.com>
> > www.PennyMacUSA.com <http://www.pennymacusa.com/>
> >
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com <me...@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>
Re: Bug in RATE
Posted by Javen O'Neal <on...@apache.org>.
This looks similar to https://bz.apache.org/bugzilla/show_bug.cgi?id=54349
The only thing missing for this bug is some unit tests. Would you be
willing to write up some unit tests and upload to this bug?
On Nov 22, 2016 4:15 PM, "Blake Watson" <bl...@pnmac.com> wrote:
> I believe I've found a bug in the RATE implementation. If I call evaluate
> with these parameters:
>
> (327, 1156.9, -271000, 0, 0)
>
> I get "0.00216265554813563", which matches Excel.
>
> But if I call with:
>
> (328, 1156.9, -271000, 0, 0)
>
> I get "2.21559209725119E-15".
>
> Which doesn't match (and is suddenly tiny).
>
> --
>
> *Blake Watson*
>
> *PNMAC*
> Application Development Manager
> 5898 Condor Drive
> Moorpark, CA 93021
> (805) 330.4911 x7742
> blake.watson@pnmac.com <me...@pnmac.com>
> www.PennyMacUSA.com <http://www.pennymacusa.com/>
>