The same error remains in Ubuntu Lucid. The estimation input data was removed and this made OpenOffice poor.
On Lucid OpenOffice when I try to calc the interest rate from data bellow, I get wrong answer to i = -185,49% to nper = 12; fv = 0; pv = -1500; pmt = 500; type = 0. I know that both numbers (i = -185,49% and i = 32,16%) solve the problem above. The problem has two solutions and both answers solve the same data problem. But, with my HP 12 C, I do not need to worry about that because it always gives me the wright answer. On OpenOffice Calc I think the function Interest Rate or TAXA() in Br language start to search for a number that solves equation from negative number to positive number and it stops when find the first number that solves equation (i= -185,49% in the case above). I suggest to change the function Interest Rate to the Boolean method to start to search for solution number from zero to negative -10,000 and at the same time (use multiple cores processor) search from zero to positive number +10,000. Keep all possible answers on RAM memory and present all possible answers (in a macro way or flash way) and let users to choose the most likely answer. see boolean http://www.allaboutcircuits.com/vol_4/chpt_7/4.html > Date: Thu, 13 May 2010 22:18:55 +0000 > From: [email protected] > To: [email protected] > Subject: [Bug 420614] Re: [upstream] Bug on OpenOffice Calc Financial > Calculator Formulas gives wrong value to Interest Rate Calc > > ** Tags added: jaunty > > -- > [upstream] Bug on OpenOffice Calc Financial Calculator Formulas gives wrong > value to Interest Rate Calc > https://bugs.launchpad.net/bugs/420614 > You received this bug notification because you are a direct subscriber > of the bug. > > Status in The OpenOffice.org Suite: New > Status in “openoffice.org” package in Ubuntu: Triaged > > Bug description: > Binary package hint: openoffice.org > > When I try to calc the interest rate from data bellow, I get wrong answer to > i = -185,49% > to nper = 12; fv = 0; pv = -1500; pmt = 500; type = 0; estimation = 0%. > But when I change estimation from 0% to 100% I get the write answer i = > 32,16%. > I know that both in mathematics the data above has two solutions and both > answers solve the same data problem. > But, with my HP 12 C, I do not need to worry about that because it always > gives me the wright answer. > > ProblemType: Bug > Architecture: amd64 > DistroRelease: Ubuntu 9.04 > Package: openoffice.org-core 1:3.0.1-9ubuntu3 > ProcEnviron: > PATH=(custom, no user) > LANG=pt_BR.UTF-8 > SHELL=/bin/bash > SourcePackage: openoffice.org > Uname: Linux 2.6.28-15-generic x86_64 > > To unsubscribe from this bug, go to: > https://bugs.launchpad.net/openoffice/+bug/420614/+subscribe _________________________________________________________________ QUEM VOCÊ QUER SER HOJE NO MESSENGER? TRANSFORME SUA FOTO, É GRÁTIS. http://ilm.windowslive.com.br/?ocid=ILM:ILM:Hotmail:Tagline:1x1:Tagline -- [upstream] Bug on OpenOffice Calc Financial Calculator Formulas gives wrong value to Interest Rate Calc https://bugs.launchpad.net/bugs/420614 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
