Excel RATE() function defined in Ruby
||...over a function I have defined in Ruby. I'm wanting to clone Excel's built-in RATE() function and can't...This job will be considered complete when the function is working flawlessly.
||Ruby on Rails, Algorithm, Software Architecture
||Dec 2, 2010
||Dec 2, 2010Ended
Implement MS Excel RATE function as method/function
||Need the actual formula for the Excel RATE function.
Searching Excel help file reveals the one formula...Excel's finance functions. (Open Excel, go to help, search for PV, the function, open that topic, scroll down)...problem to include Excel rather then, here is formula make rate the subject (rate =).
The way I'm
||PHP, C Programming, Java, Ruby on Rails, Excel
||Jan 15, 2009
||Jan 15, 2009Ended
||Nov 25, 2011
||Nov 25, 2011Ended
168666 Convert Excel RATE() into Code
||...the Excel function RATE(). The RATE() function is used in Excel to calculate the comparison rate (or...(or effective interest rate) where the repayment value, no. of repayments and initial loan value are known...a loan amount and interest rate). You will see that the 'Comparison Rate' is currently not functioning
||Sep 27, 2007
||Sep 27, 2007Ended
208802 Exchange Rate upload
||The current exchange rate upload into our system is a manual process and following steps are involved...copy and paste function which may casue errors.
This template should also have the function to clear the...template for upload
The template can be either in Excel (xls) format and or Tab delimted (Txt) format.
||XML, Visual Basic, Anything Goes, HTML
||Mar 19, 2008
||Mar 19, 2008Ended
Modified Internal Rate Of Return
||...Internal Rate of Return (IRR) would be the correct formula to use. I can't use the normal IRR function in...in Excel since it can only handle one negative number in a fixed stream of cash flows. Excels Modified...Modified Internal Rate of Return (MIRR) formula allows for multiple negative cash flows, but I'm not clear
||Education & Tutoring
||Nov 4, 2010
||Nov 4, 2010Ended
||...the data from an other sheet using the VLOOKUP function.
Suppose to have a list of articles in the "Sheet...have different size and resolution.
So I need Excel to resizes them keeping the aspect ratio, manages...least I guess) and Excel look for the file/s in the folder.
If the file exists Excel analyzes it, resizes
||Nov 26, 2008
||Nov 26, 2008Ended
||Please work on this function.
||Jan 5, 2014
||Jan 5, 2014Ended
||...modify Excel function shown in the link below: http://tinyurl.com/ycpzmw9 The current function removes...are upper case letters A-Z and numbers. The new function should also allow lowercase letters a-z and the...Worker Legal Agreement).
Microsoft Excel, VBA
||PHP, Visual Basic, .NET, Script Install, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL, Visual Basic for Apps
||Apr 10, 2010
||Apr 10, 2010Ended
||Need a function in Excel spreadsheet that would check to see if a sum of any combination of a specified
||PHP, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Feb 13, 2004
||Feb 13, 2004Ended
||Please work on this function.
||Mar 10, 2014
||Mar 10, 2014Ended
||I would like an excel function that will produce a list which concatenates as follows:
||PHP, Software Architecture
||Sep 25, 2013
||Sep 25, 2013Ended
We are looking for an excel expert to help us with a functions/formulas for one of our clients...clients eCommerce solution.
The function we are needing has to link cells AM1 (values in red) to G2...on which values/cells we are linking up, as the excel document will have more than 100 values that need
||Jul 13, 2010
||Jul 13, 2010Ended
Call Excel xla function in VB (MS Access)
||...want to call Excel xla functions in MS Access.
CUMPRINC function (you need to...to enable Excel Analysis ToolPak-VBA first)
We want to call "cumprinc()"..."cumprinc()" function in MS Access
we tried follows, but both didn't work
Public Function xx(rate
||PHP, Visual Basic, Engineering, Software Architecture, Microsoft Access, Software Testing, MySQL
||Apr 14, 2004
||Apr 14, 2004Ended
Excel IF function
||...create 2 Excel IF functions. It is hard for me to explain but here is an example and using the Excel file...provided this will help explain what I need
Excel function 1
Start in cell CV3
=IF A3="ALBANY"...continue until Wyong 2100 ( see line A265 )
Excel function 2
Start in cell CW3
||Jul 4, 2012
||Jul 4, 2012Ended
Excel Rate of Return calc
||Rate of Return (ROR) template/macro in Excel that uses ongoing imported data received via email. The...sample data files that will have to be imported into Excel.
One twist is there are two different sets...current supplier. Both say they’ll provide me? with Excel readable files...which I take to mean CSV files
||PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||May 8, 2008
||May 8, 2008Ended
||Here is what I need: I have an Excel spreadsheet which contains a column with values in its cells ranging...
Windows 2000 Visual Basic 6.0 Excel 2000
||PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL
||May 1, 2003
||May 1, 2003Ended
RATE/PRICE quotes online/email
||I want to do RATE QUOTES through email/online system. I would like to program this for online use (PHP...need to be able to quote customers that are seeking rate/prices etc. The program has to be accessible though...the client accepts the quote it has to be some function that sends the deal to supervisor for acceptance
||PHP, Engineering, Sales, Marketing, Software Architecture, Software Testing, Website Testing, MySQL, Website Management, Web Hosting
||Apr 5, 2006
||Apr 5, 2006Ended
Private project for RomaSant (advanced rate function)
||Private project for RomaSant (Advanced rate function).
||Apr 17, 2010
||Apr 17, 2010Ended
286537 Excel Function - DeleteRows
||We need some help with an Excel function that would delete the entire row(s) based on values of certain...should be fairly simple for someone familiar with excel. PMB any questions or concerns before bidding on
||Visual Basic, Data Entry, SQL, Microsoft Access, Anything Goes
||Feb 5, 2009
||Feb 5, 2009Ended