|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
|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
|Num Lock Functions
I want to set 9 functions to Num Lock for example:
1. Restart PC
2. Shutdown PC
3. Load...another, or change the path of XML file in Number 3 function.
||Apr 26, 2014
||Apr 26, 2014Ended
||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
|php function to test if a URL gives 404 or not
||I need a PHP function that simply takes a URL as an argument and returns a 1 if the URL returns without...without error, and a 0 if the URL gives any error (including 404 for example).
I am aware there is a...this, but every attempt to install this package gives errors on 4 different machines where I've tried
||PHP, Engineering, Software Architecture, Software Testing, MySQL
||Dec 5, 2007
||Dec 5, 2007Ended
|data extraction mobile num from excel
||...to extract numbers from multiple excel sheets. I have around 500 excel sheets with multiple numbers. you...just need to validate 10 digits. Very easy job for excel experts.
only low budget bids please.
||Data Processing, Data Entry, Excel, Web Scraping, Data Mining
||Sep 28, 2012
||Sep 28, 2012Ended
|troubleshoot: hdparm gives ''read(2097152) returned 1572864 bytes''
(or whatever the hard disk is), gives an output something like:
Timing...means that a call to some operating system API function read() returned an unexpected number of bytes...this type of problem or you find a source that gives the solution.
Either (a) you can submit a bid
||Jan 8, 2009
||Jan 8, 2009Ended
|Rate Analysis Project
||...program for doing **rate analysis** & preparation of estimate of construction items. An excel file giving **overview**...of attached file. "Steps in process' worksheet gives you idea of the process. (For convenience the requirements...program for doing **rate analysis** & preparation of estimate of construction items. An excel file giving **o...
||PHP, Visual Basic, .NET, Script Install, Windows Desktop, SQL, Software Architecture, Oracle, Microsoft Access, Software Testing, MySQL, Anything Goes, Database Administration, Visual Basic for Apps
||Oct 17, 2011
||Oct 17, 2011Ended
||Matlab & Mathematica
||Mar 9, 2011
||Mar 9, 2011Ended
|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
|MACRO check in Excel sheet. Gives out errors
||We have got an excel sheet with macro script which gives out debug errors. This is a script which automatically
||Apr 22, 2013
||Apr 22, 2013Ended
|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
||Please work on this function.
||Jan 5, 2014
||Jan 5, 2014Ended
|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
||...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
||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
|Get toggle state of caps, num, and scroll lock
||...GetKeyboardState API calls to return the status of the caps, num, and scroll locks (on or off) will not return accurate...related key to each lock (the caps lock key, the num lock key, the scroll lock key) are pressed or not...know whether caps/scroll/num lock is on or off. What is needed is a function that will return the state
||PHP, C Programming, Visual Basic, Windows Desktop, Engineering, Software Architecture, Software Testing, Microsoft, MySQL
||Oct 25, 2001
||Oct 25, 2001Ended
||...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
|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