Excel RATE() function defined in Ruby

...over a function I have defined in Ruby. I'm wanting to clone Excel's builtin RATE() function and can't...This job will be considered complete when the function is working flawlessly. 
1 
Ruby on Rails, Algorithm, Software Architecture 
Dec 2, 2010 
Dec 2, 2010Ended 
$30 
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 
1 
PHP, C Programming, Java, Ruby on Rails, Excel 
Jan 15, 2009 
Jan 15, 2009Ended 
$40 
JavaScript function IRR (internal Rate of Return)

I need the IRR calculation from the excel formula to my website in Javascript.
=+(1+IRR(C23:C83;0 
5 
PHP, Javascript, Script Install, HTML 
Nov 25, 2011 
Nov 25, 2011Ended 
$55 
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 
1 
PHP, Javascript, AJAX, MySQL, Anything Goes 
Sep 27, 2007 
Sep 27, 2007Ended 
$25 
Algorithm

...yH, and yL.Give algorithm of this multiplication and implement it as a compact function in a program.The...Deliverables
Give algorithm of this computation & implement it as a compact function in a program.give...multiplication or division operator or the exponentiation function in your functions.These functions should be in 
3 
PHP, Windows Desktop, Linux, Engineering, Software Architecture, Mac OS, Software Testing, Chrome OS, MySQL, UNIX 
Sep 23, 2007 
Sep 23, 2007Ended 
$15 
Algorithm

...functionality in a
newer program. I need a special algorithm to do so.
We have subcontractors who...for
division 1 alone.
I need an algorithm that will calculate the lowest bid path, given...visualize, so I've posted an example bid sheet in Excel format at
<http://www.soltekpacific.com/bidSample 
6 
PHP, Engineering, Software Architecture, Software Testing, Website Testing, MySQL, Website Management, Web Hosting 
Aug 21, 2006 
Aug 21, 2006Ended 
$65 
Algorithm

...either manually or by importing database info from excel spreadsheet. Once original list is populated, would 
12 
PHP, Engineering, SQL, Software Architecture, Software Testing, MySQL, Database Administration 
Apr 10, 2007 
Apr 10, 2007Ended 
$250 
Heart rate algorithm and implementation

...the algorithm and implementation library for building the application that can read the heart rate based...is the Android application called "Instant heart rate".
Here are the requirements:
We own the IP...that uses the algorithm
10 seconds for the reading through the flash light
The algorithm should be as 
2 
Mobile Phone, Android 
Aug 13, 2011 
Aug 13, 2011Ended 
$475 
Algorithm

...each sorting algorithm) Input Generate data set by using the random generator function. Output Repeated 
3 
PHP, C Programming, Engineering, Software Architecture, Software Testing, MySQL 
May 22, 2001 
May 22, 2001Ended 
$30 
Reproduce the algorithm DLL function

...Delphi)
Required:
1. To understand what a function mql() does .
2. Provide results in the form...form of a formal description of the algorithm of the function or to describe the formation of the keys.... In describing the algorithm you should use terms/functions of php, python, C # (by you choice)

1 
C Programming, Delphi 
Mar 1, 2012 
Mar 1, 2012Ended 
$220 
Algorithm/Function in C++

...description:
I need a Function in Visual C++ (no MFC).
Function Name: GetBuffer
Parameters:.../100918906.wmv
"
Description: A simple function which uses LeadTools API and to download the file...and save it in a Buffer or array of bytes.
Function Return Value: Buffer/Array of bytes..

0 
PHP, C Programming, Engineering, Software Architecture, Software Testing, MySQL 
Sep 19, 2006 
Sep 19, 2006Ended 
 
loan repayment reate algorithm

I need algorithm to calculate repayment rate of loan, based on following input data. 1. current loan...loan balance 2. loan interest rate 3. number of days to first repayment 4. number of repayments. 5. repayment...interest is done at date of repayment. I need it as a function in PHP,Perl,Java,C++,Python (I prefer PHP), or 
15 
PHP, Perl, C Programming, Java, Python, Engineering, Technical Writing, Software Architecture, Software Testing, MySQL 
Jun 15, 2007 
Jun 15, 2007Ended 
$58 
Hash Function ( Algorithm)

...need to solve 23 small questions related to algorithm asap. Its related to hash functions. Please let 
6 
C Programming, Algorithm, C++ Programming 
Apr 19, 2014 
Apr 19, 2014Ended 
$53 
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. 
0 
XML, Visual Basic, Anything Goes, HTML 
Mar 19, 2008 
Mar 19, 2008Ended 
 
Website Scoring Algorithm

...looking for a programmer that can create a scoring algorithm for me. The source data is a website and a group...will provide an Excel spreadsheet containing a dataset and your work can be done in Excel for the most part...part although creating a mysql or PHP function that returns the score would be a bonus. (I can create 
4 
PHP, Software Architecture, Software Testing, Website Testing, MySQL, Amazon Web Services, Website Management, Web Hosting 
Jul 14, 2011 
Jul 14, 2011Ended 
$1073 
A Simple Genetic Algorithm

...simple genetic algorithm in C++ and run a series of experiments to test your algorithm for a given problem...up mating pool at random If (rand() < crossover rate) Perform One Point Crossover to create offspring...Random numbers can be generated using the rand() function found in the C standard library. To generate a 
4 
PHP, C Programming, Windows Desktop, Linux, Project Management, Engineering, SQL, Software Architecture, Mac OS, Software Testing, Website Testing, Chrome OS, MySQL, UNIX, Website Management, Database Administration, Web Hosting 
Sep 22, 2005 
Sep 22, 2005Ended 
$7 
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 
3 
Education & Tutoring 
Nov 4, 2010 
Nov 4, 2010Ended 
$96 
VB/VBA Cross Algorithm

Attached is an Excel spreadsheet with 28 columns of data. Each row represents a different day. I would...would like a VB or VBA subroutine/function that will find out how many of the columns cross on any particular...crossed. I would like an efficient well though out function that will return another sheet showing the date 
13 
PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL, Visual Basic for Apps 
Feb 12, 2007 
Feb 12, 2007Ended 
$46 
Algorithm Optimization 3

...we evaluate an objective function.
• Specifically, the objective function is the sum of the target...
Logistics:
• You can find the dataset in the Excel file “Market_Records_1.4.xlsx”.
• You will see...be on a weighted average of them or any other function.
• Make sure to order the timestamp chronologically 
17 
Algorithm, Statistics, Mathematics, Software Development, Database Programming 
May 27, 2014 
May 27, 2014Ended 
$675 
Excel Function

Need a function in Excel spreadsheet that would check to see if a sum of any combination of a specified 
19 
PHP, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL 
Feb 13, 2004 
Feb 13, 2004Ended 
$24 
Excel function

Please work on this function. 
1 
Excel, 
Jan 5, 2014 
Jan 5, 2014Ended 
$5 
Basic function to access VirCurEx using Excel (VBA)

...code that you can find that will perform the SHA2 function.
SHA2 VBA Script
http://bytes.com/topic/acc...com/topic/access/insights/906938sha2cryptographichashalgorithmvbavbscript
The final code should look something...important thing is that you program the GetBalances function to obtain the balances and return the data. The 
3 
Visual Basic for Apps 
May 22, 2013 
May 22, 2013Ended 
$115 
Excel function

...modify Excel function shown in the link below: http://tinyurl.com/ycpzmw9 The current function removes...are upper case letters AZ and numbers. The new function should also allow lowercase letters az and the...Worker Legal Agreement).
## Platform
Microsoft Excel, VBA 
80 
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 
$36 
Algorithm Optimization  Reviewed

Algorithm Optimization  Reviewed
Summary
We are a small group of private individuals developing...solution
We require you to design and build an algorithm (or a combination of methodologies and algorithms)...the dataset on which we evaluate an objective function.
• Your restrictions can be greater than or 
24 
Matlab & Mathematica, Algorithm, Statistics 
May 29, 2014 
May 29, 2014Ended 
$616 
Excel function

Please work on this function. 
1 
Excel, 
Mar 10, 2014 
Mar 10, 2014Ended 
$15 
Excel function

...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 
7 
Excel 
Nov 26, 2008 
Nov 26, 2008Ended 
 
Call Excel xla function in VB (MS Access)

...want to call Excel xla functions in MS Access.
For example:
CUMPRINC function (you need to...to enable Excel Analysis ToolPakVBA first)
=CUMPRINC(5,5,5,5,5,0)
=4.1672
We want to call "cumprinc()"..."cumprinc()" function in MS Access
we tried follows, but both didn't work
1)
Public Function xx(rate 
13 
PHP, Visual Basic, Engineering, Software Architecture, Microsoft Access, Software Testing, MySQL 
Apr 14, 2004 
Apr 14, 2004Ended 
$25 
Translating a given algorithm into a Matlab function

...disparity map function. I already have the algorithm. It is a short and simple disparity map algorithm You just...help in converting the algorithm into Matlab codes and then run the function on 2 pairs of images to...to show that the disparity map function does work. This is a very simple task if you are an expert in Matlab 
23 
Engineering, Matlab & Mathematica, Computer Graphics 
Mar 24, 2013 
Mar 24, 2013Ended 
$31 
Excel function

I would like an excel function that will produce a list which concatenates as follows:
Concatenatelist([Title] 
3 
PHP, Software Architecture 
Sep 25, 2013 
Sep 25, 2013Ended 
$55 
Translating a give algorithm into a Matlab function

...disparity map function. I already have the algorithm. It is a short and simple disparity map algorithm You just...help in converting the algorithm into Matlab codes and then run the function on 2 pairs of images to...to show that the disparity map function does work. This is a very simple task if you are an expert in Matlab 
0 
Matlab & Mathematica, Computer Graphics 
Mar 24, 2013 
Mar 24, 2013Ended 
 
Reverse algorithm function, written in VC++

Hello coders,
I have a function, which is written in Visual C++. You can find it in the attached...project. This function accepts 2 4byte (DWORD) variables and the output of the function are another 2...The goal is to "reverse" this function. This means to create a function (or class, or whatever) which 
2 
PHP, Perl, C Programming, Java, Javascript, Python, Visual Basic, .NET, Windows Desktop, Delphi, Engineering, Matlab & Mathematica, C# Programming, Software Architecture, Software Testing, Microsoft, Assembly 
Mar 1, 2011 
Mar 1, 2011Ended 
$962 
Build a multi function website

...
There needs to be some algorithm as well because I want a percentage rate on certain players because 
14 
PHP, Website Design, Graphic Design, HTML 
Jan 5, 2015 
Jan 5, 2015Ended 
$352 
Excel Function

Hi all,
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 
38 
Excel 
Jul 13, 2010 
Jul 13, 2010Ended 
$60 
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
=IF A3="ALBANY" 
1 
Excel, 
Jul 4, 2012 
Jul 4, 2012Ended 
$27 
Build a multiple function website

...players. There needs to be some algorithm as well because I want a percentage rate on certain players because 
22 
PHP, Website Design, Graphic Design, HTML 
Jan 3, 2015 
Jan 3, 2015Ended 
$322 
Private project or contest #2541899



Software Architecture, C++ Programming 
Oct 5, 2012 
Oct 5, 2012Ended 

Machine Learning Algorithms in Excel / VBA

...Microsoft Excel "Visual Basic for Applications" functions.
This project:
 A basic function (i.e....input
 The network must be saved in a separate Excel Sheet, with the actual output and calculated output...value) displayed.
 The function must arrive at a mathematical function, that can accept new inputs 
11 
Excel, Statistics, Machine Learning, Visual Basic for Apps 
Jun 24, 2014 
Jun 24, 2014Ended 
$113 
315521 Excel algorithm into .exe

...
I am looking for a programmer to convert an algorithm we have created relating to a suitable disciplinary...ultimately print out the final solution. The algorithm currently has approx 15 nodes.
The initial...approx 45 with one button to take them into the algorithm. This will lead people on a series of questions 
0 
C Programming, Delphi, Anything Goes 
Apr 28, 2009 
Apr 28, 2009Ended 
 
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 
8 
PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL 
May 8, 2008 
May 8, 2008Ended 
$246 
Calculate Excel data using SUMIF, SUMIFS functions and calculate conversion rate

...We are trying to add data using SUMIF or SUMIFS function:
1) One column for the criteria has the date 
23 
Data Processing, Excel, Mathematics 
May 6, 2014 
May 6, 2014Ended 
$20 
Calculate algorithm

We need an algorithm that will calculate the rate of success of betting picks. This algorithm should calculate...the algorithm is provided from a database which contains all the needed data to calculate the rate. 
8 
PHP, MySQL 
Dec 16, 2012 
Dec 16, 2012Ended 
$143 
VideoSlots Algorithm

...VideoSlots Algorithm, with bonus and wilds. Algorithm only, nothing visual.
The algorithm needs to receive...to adjust multipliers, symbols, win rate, bonus rate and wild rate.
Previous experience with VideoSlots 
3 
PHP, ASP, Javascript, Software Architecture, ActionScript 
Feb 19, 2015 
Feb 19, 2015Ended 
$626 
GUI using either Excel or Access with complex algorithm database

...application User Interface (UI) which using a dynamic algorithm effectively calculates and prioritises a list...postcode checker (although in this prototype this function is not required there must be an option). Please...Project Two: Transform the access database or excel spreadsheet to a fully functional GUI using an SQL 
13 
PHP, Excel, Microsoft Access, MySQL, Database Administration 
Dec 12, 2013 
Dec 12, 2013Ended 
$1365 
Algorithm, Code, Quiz, Math, Simple, Programming, Easy Questions

...
2. Write a function that takes an integer argument and returns the corresponding Excel column name....medical test for this disease has 1% false positive rate (if a person is healthy, there is a 1% probability...show that the person is ill), and 1% false negative rate (if a person is ill, there is a 1% probability that 
16 
Algorithm, Mathematics 
Oct 25, 2013 
Oct 25, 2013Ended 
$203 
Tutoring Algorithm

Need algorithm expert and also c++ programming.
Excel in both coding and theory.
Need ASAP..
And currently 
8 
C Programming, Algorithm 
Nov 2, 2013 
Nov 2, 2013Ended 
$463 
Add rate

Here is what I need: I have an Excel spreadsheet which contains a column with values in its cells ranging...
## Platform
Windows 2000 Visual Basic 6.0 Excel 2000 
14 
PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL 
May 1, 2003 
May 1, 2003Ended 
$19 
Algorithm design

...some function that grows slower than linearly. Then implement a simulation of how your algorithm would 
2 
Java 
Apr 3, 2014 
Apr 3, 2014Ended 
$35 
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 
1 
PHP, Engineering, Sales, Marketing, Software Architecture, Software Testing, Website Testing, MySQL, Website Management, Web Hosting 
Apr 5, 2006 
Apr 5, 2006Ended 
$1062 
Retrieve algorithm from function in Fortran obj file

...values passed to the function and a real*4 returned.
There should only be 1 function in the obj file...file. The function itself should be relatively short and simple and made up primarily of math operations 
3 
Fortran, Assembly 
Dec 30, 2012 
Dec 30, 2012Ended 
$250 
Algorithm development

...Easylanguage Code (comparable to exel) or other function code.
You can see a graph showing the data 
10 
Engineering, Matlab & Mathematica, Algorithm, Metatrader, Mathematics 
May 4, 2011 
May 4, 2011Ended 
$512 