Programming Forums > Projects > Paid Job Offers

scm007 · Jan 9th, 2006, 1:47 AM

I could pay someone for their time if they wrote this program. Essentially there is an Excel spreadsheet with 1000-10000 entries. Each of which has a code, a price, and a risk. Then the program would go through and find a solution set such that the total price as specified by the user is in some range AND the weighted risk, i.e. the sum of (risk*price)/(total price) for all prices in the solution set is in some range. Then the program would output the corresponding codes for the entries which validate these criteria. Could anybody do this?

InfoGeek · Jan 9th, 2006, 6:34 AM

I'm interested. Would you like a separate executable to handle this or would you like it done in VBA? and what are you willing to pay?

Infinite Recursion · Jan 9th, 2006, 8:18 AM

This sounds very easy... something you could probably do yourself, just by asking specific questions on the forums. Check this out... particularly the CheckValues function... http://www.mindspring.com/~tflynn/excelvba.html.

scm007 · Jan 9th, 2006, 7:27 PM

Infogeek, what would be easier?

jayme · Jan 9th, 2006, 8:26 PM

I think he means do you want the program done in code, or do you want him to compile the code and get the executable ready for you.

scm007 · Jan 10th, 2006, 12:33 AM

I know I was asking what would be easier, to create the Executable to incorporate an excel file or just us VBA to make a macro in excel or something of that fashion.

nnxion · Jan 10th, 2006, 2:18 AM

It probably doesn't matter to him, one could say "just give it to me, I don't care how", or one could say "I prefer ... because ... ".

InfoGeek · Jan 10th, 2006, 4:04 AM

Quote:

Originally Posted by scm007

Infogeek, what would be easier?

So, you don't have any preference. I think VBA would be easier for such a thing but from your other post(and the discussion there), it seems that the performance can be a bottleneck with some simple algorithm. So, i guess i would first try it in VBA and if the performance is not good i can move it to C++ or some other language.

HaCkeR · Jan 10th, 2006, 10:04 AM

Yea i think that sounds pretty easy. I mean if it is in exel then you could pretty much do it just using different sums in exel itself. But there is one or two aspects which would need a program to do. VBA is proberly your best hope.

nnxion · Jan 10th, 2006, 10:07 AM

Quote:

Originally Posted by HaCkeR

Yea i think that sounds pretty easy. I mean if it is in exel then you could pretty much do it just using different sums in exel itself. But there is one or two aspects which would need a program to do. VBA is proberly your best hope.

Probably :p.

Jan 9th, 2006, 1:47 AM	#1
scm007 Newbie Join Date: Jan 2006 Posts: 27 Rep Power: 0	Programmer needed, shouldn't be hard I could pay someone for their time if they wrote this program. Essentially there is an Excel spreadsheet with 1000-10000 entries. Each of which has a code, a price, and a risk. Then the program would go through and find a solution set such that the total price as specified by the user is in some range AND the weighted risk, i.e. the sum of (risk*price)/(total price) for all prices in the solution set is in some range. Then the program would output the corresponding codes for the entries which validate these criteria. Could anybody do this?

Jan 9th, 2006, 6:34 AM	#2
InfoGeek Professional Programmer Join Date: Jun 2005 Location: India, The great. Posts: 435 Rep Power: 4	I'm interested. Would you like a separate executable to handle this or would you like it done in VBA? and what are you willing to pay? __________________ PFO - My daily dose of technology.

Jan 9th, 2006, 8:18 AM	#3
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	This sounds very easy... something you could probably do yourself, just by asking specific questions on the forums. Check this out... particularly the CheckValues function... http://www.mindspring.com/~tflynn/excelvba.html. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Jan 10th, 2006, 2:18 AM	#7
nnxion Programming Guru Join Date: Jun 2005 Location: elemental plane Posts: 1,429 Rep Power: 5	It probably doesn't matter to him, one could say "just give it to me, I don't care how", or one could say "I prefer ... because ... ". __________________ "Employ your time in improving yourself by other men's writings, so that you shall gain easily what others have labored hard for." -- Socrates

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jan 9th, 2006, 7:27 PM	#4
scm007 Newbie Join Date: Jan 2006 Posts: 27 Rep Power: 0	Infogeek, what would be easier?

Jan 10th, 2006, 12:33 AM	#6
scm007 Newbie Join Date: Jan 2006 Posts: 27 Rep Power: 0	I know I was asking what would be easier, to create the Executable to incorporate an excel file or just us VBA to make a macro in excel or something of that fashion.

Jan 10th, 2006, 10:04 AM	#9
HaCkeR Hobbyist Programmer Join Date: Nov 2005 Location: UK Posts: 131 Rep Power: 0	Yea i think that sounds pretty easy. I mean if it is in exel then you could pretty much do it just using different sums in exel itself. But there is one or two aspects which would need a program to do. VBA is proberly your best hope.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Projects > Paid Job Offers

Programmer needed, shouldn't be hard