OraFAQ Forum: Forms » Use Excel Formulas in oracle forms, report and oracle

Home » Developer & Programmer » Forms » Use Excel Formulas in oracle forms, report and oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Use Excel Formulas in oracle forms, report and oracle [message #466997]

Wed, 21 July 2010 23:43

Farrukh_Shaikh
Messages: 1
Registered: July 2010
Location: Pakistan

Junior Member

Dear All
Assalam-o-Alikum

i want to ask that is there any way to use the excel formulas on oracle forms, reports and database level. if any body know then please share this. for example if we want to use IRR formula of excel to use in oracle forms, database and report.

Thanks.

Report message to a moderator

Re: Use Excel Formulas in oracle forms, report and oracle [message #467007 is a reply to message #466997]

Thu, 22 July 2010 00:41

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, database has its own set of functions and procedures. It means that, if you'd want to use an IRR formula (whatever it is), you'd have to create it (i.e. write a program) in an Oracle database. As a stored function, it can be available (by granting required privileges) to any client that operates with a database (SQL*Plus, Forms, Reports, ...).

Report message to a moderator

Re: Use Excel Formulas in oracle forms, report and oracle [message #467057 is a reply to message #467007]

Thu, 22 July 2010 02:56

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

From OpenOffice

IRR
Calculates the internal rate of return for an investment. The values represent cash flow values at regular intervals, at least one value must be negative (payments), and at least one value must be positive (income).
Syntax
IRR(Values; Guess)
Values represents an array containing the values.
Guess (optional) is the estimated value. An iterative method is used to calculate the internal rate of return. If you can provide only few values, you should provide an initial guess to enable the iteration.
Example
Under the assumption that cell contents are A1=-10000, A2=3500, A3=7600 and A4=1000, the formula =IRR(A1:A4) gives a result of 80.24%.

If you really want to use Excel then you will have to populate cells and then retrieve the answer.

Search this forum for 'Excel', there are plenty of threads. Just remember, your client may not have Excel on their PC.

David

Report message to a moderator

Re: Use Excel Formulas in oracle forms, report and oracle [message #467058 is a reply to message #467057]

Thu, 22 July 2010 02:59

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

It doesn't give 80.24%, it gives 11.33% on my PC.

David

Report message to a moderator

Previous Topic:	utl packages
Next Topic:	Geting Remote client ip or last proxy that sent the request

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 16:29:06 CDT 2024