[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 User er changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED Target milestone|--- |OOo 3.4 --- Additional comments from e...@openoffice.org Fri Dec 3 15:10:00 + 2010 --- In cws dr78: changeset 4ca136c3f3c8 http://hg.services.openoffice.org/cws/dr78/changeset/4ca136c3f3c8 M sc/source/core/tool/interpr2.cxx You can observe the progress and possible integration date of CWS dr78 at http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdr78 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 --- Additional comments from drk...@openoffice.org Fri Dec 3 15:58:17 + 2010 --- Thank you - I updated the function help wiki text accordingly. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 User regina changed the following: What|Old value |New value Assigned to|spreadsheet |er --- Additional comments from reg...@openoffice.org Wed May 5 09:13:00 + 2010 --- Hi Eike, I think, this issue should be yours. If not, please reassign it correctly. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 --- Additional comments from reg...@openoffice.org Sat Aug 15 22:32:10 + 2009 --- Created an attachment (id=64193) increase accuracy for rate near zero using the now available expm1 and log1p - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 User regina changed the following: What|Old value |New value Issue type|DEFECT|PATCH --- Additional comments from reg...@openoffice.org Sat Aug 15 22:36:04 + 2009 --- In addition I have changed the German identifiers inside the function with English terms. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 This issue depends on issue 91602, which changed state: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 User regina changed the following: What|Old value |New value IssuesThisDependsOn| |91602 --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 16:01:29 + 2008 --- Solution needs expm1 and log1p, add dependency. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 Issue #|91870 Summary|PMT function with extremely small rates - #VALUE! Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P4 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Sun Jul 20 17:15:22 + 2008 --- The formula for PMT (payment at end) is [p(1+r)^n - f]r / ((1+r)^n-1) where n = number of periods p = principal (the capital sum borrowed) f = the final balance owing after n periods r = interest rate (fixed rate) per period derived here: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Derivation_ of_Financial_Formulas#PMT With extremely small values for r we get too close to divide by 0 Example: =PMT(1E-016;10;1000;0;0) gives #VALUE! Note that =PMT(4.567E-015;10;1000;0;0) is OK - larger, but with more displayed digits - so we have not run out of precision with the rate. Excel has the same problem, giving #DIV/0!. The solution may be to trap low values and apply another algorithm, also provided on the linked page. rate=0 is trapped anyway. This error will not arise in real life, so this should be low priority and I've marked it enhancement rather than defect. It is bad to have a function that can be beaten though, and there should be a record of the fact. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 User regina changed the following: What|Old value |New value CC|''|'regina' Ever confirmed| |1 Status|UNCONFIRMED |NEW Issue type|ENHANCEMENT |DEFECT Keywords| |oooqa --- Additional comments from [EMAIL PROTECTED] Sun Jul 20 21:18:04 + 2008 --- Yes, the implementation can be improved. But I think, that a solution with expm1 and log1p would be better than cutting the series. I have not yet compared it, but calculating (1+r)^n-1 via expm1(n * log1p(r)) works for me. Such would increase the accuracy in other extreme cases too. For example RATE=1e-12, NPER=600, PV=-3000, FV=0 results in 4,9993660135E+000 but should be 5.150250E+000 (as MuPad and Gnumeric calculate). =PMT(4.567E-015;10;1000;0;0) is not OK. It returns -9,7058450071E+001 but it should be -1,002512E+002. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 --- Additional comments from [EMAIL PROTECTED] Sun Jul 20 22:22:20 + 2008 --- Thanks Regina I think you are the expert here - I'll leave it to you ;) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]