Bug 52050 - Class to implement internal excel function RATE
Summary: Class to implement internal excel function RATE
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.8-dev
Hardware: All All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-18 16:01 UTC by carlo.traversa
Modified: 2011-10-19 11:32 UTC (History)
0 users


Attachments
Class to implement internal excel function RATE (4.25 KB, text/x-java-source)
2011-10-18 16:01 UTC, carlo.traversa 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description carlo.traversa 2011-10-18 16:01:14 UTC 
Created attachment 27805 [details]
Class to implement internal excel function RATE

Hi all.
It would be great to implement the internal financial excel function RATE. The class in attachement is my own implementation but the most important thing is the method calculateRate(double nper, double pmt, double pv, double fv, double type, double guess) that find root by using the Newton secant method.
In this way it'd be possible to easily adapt the code.
I hope this will help the project with my few rows of code.
Feel free to contact me for any detail.
Regards,
Carlo Traversa.
Comment 1 Nick Burch 2011-10-19 11:32:56 UTC 
Thanks, applied (with a few tweaks) in r1186111.