Programmer-Designer »   Register   Login   Logout   FAQ 
 Buyer-Project Manager »   Signup   Login   Post a Project   Logout   FAQ 
Browse Recent projects :: Post your Project :: Testimonials onmouseover="status='Click in Explorer -OR- press Ctrl and D in Netscape.';return true" onmouseout="status=' ' ">bookmark :: tellafriend :: affiliate programaffiliate program :: contactus :: homepage
programmingbids.com

Project: Optimize Data Set

ID: 1383088206
email this project to your friends
View Message Board for this Project click on the view message board button to post a message for this project View Message Board for this Project
Messages Posted: - You may use the message board to discuss or clarify any further details/requirements regarding this project. Price negotiations and/or direct contact with each others is not allowed including via email, AIM, chat, etc., and until a bidder has been chosen.

Status: Frozen (No bidding. Waiting for action from project owner.)
Budget: N/A
Created: 10/29/2013 at 17:10 (MST)
Bidding Ends: 11/12/2013 at 16:10 (MST)(expired)
Project Creator: markmdill
Rating: (No Feedback Yet) --- login to your account to pick a bid, when you are ready.
Description:
«Login» to edit the description

I would like to have a program that takes a set of data from an Excel spreadsheet, and manipulates to find the optimum solution. There will be a few rules to determine which records can be used, and the idea is to create a way to combine every possible combination, add them up; and then store those optimum combinations (up to 10) so that the user can see which records are optimized when used together.

The program would run on a PC. Ideally using whatever is already on a PC, so don't have buy SQL or something expensive.

The spreadsheet will have 5 columns of data, and will have about 300 to 500 records (rows) to look at.

Column 1 is a reference number, call it Ref Num
Column 2 will have a Type; either Type 1, 2, 3, 4, 5 or 6
Column 3 will have a number (value) (integer, 1 through 25000 We will call it Power
Column 4 will have another value: We will call it Result
Column 5 will have another value; we will call it Volatility

The idea of the program is to get the highest possible "Result" while keeping within the rules. Results are obtained by adding the selected records "Result" Field to get a total.

The Variables:

1. Enter the allowed records to be used to get to the result. This can be from 5 to 15, depending on the situation.
2. Enter the number of each Type that is allowed. So for example, if the total allowable records are 10, the allowed "Type 1" maybe is 2, the allowed "Type 2" is 2, the allowed "Type 3" is 3, "Type 4" is 1, "Type 5" is 1, and "Type 6" is 1. So the total records allowed are 10, and the # of each allowed Types is comes to 10 to match. (Must match. Types are not "up to x", they are"x", so for example, if we allow 2 Type 2's, that means there can't be 1 or 2, only 2 from the selected records.
3. Enter the maximum Power that be reached. A number between 100 and 100,000.

So, here is an example.

Allowed Records = 8
Type 1 = 1, Type 2 =2, Type 3 = 3, Type 4 = 0, Type 5 = 1, and Type 6 = 1 (for a total that matches 8)
Power: 30,000.

The program then looks at every possible combination of the datasheet to find the 8 records that have the highest RESULT (addition of the Result field for each of the 8 records). While keeping to the rules (only using the 8 best records, only using 1 type 1, 2 type 2's, etc, and where the total Power is 30,000 or less.

The next thing the program does is look at Volatility. Volatility represents the lowest or highest variance that may occur against the Result. So for example if result is 8 and volatility is 2, then the minimum possible adjusted result is 6, the maximum is 10.

What we want to do is then run the simulation again; this time, instead of using the "Result" field, use the maximum value of the adjusted Result; in the example above, use 8 this time. Run every possible combination that meets the rules and determine the best result.

The result would be a report that would;

1. First print the variables that were used for the simulation; Example: 10 Records allowed, (Type 1 =2, Type 5 = 8), Power at or below 8000.
2. Second; show the 10 reference Numbers, their power, and volatility.
3. Then, show the next best X results (so x can be anywhere from 1 to 10, entered by the user)
4. Then, show the same thing for volatility, but add the word Volitility to the description, and again, allow the next X results (1 to 10).
Project Type: Desktop App
OS-Platform: None
Programming Language: None
Database Type: None
View Message Board for this Project click on the view message board button to post a message for this project View Message Board for this Project
Messages Posted: 1 - You may use the message board to discuss or clarify any further details/requirements regarding this project. Price negotiations and/or direct contact with each others are not allowed including via email, AIM, chat, etc., and until a bidder has been chosen.

Programmer Bids for this project

Programmers/Freelancers Bid Delivery Within Time of Bid
Rating
(No bids have been placed yet.)


Share |



 Affiliate $19.95/programmer sign-up and 30% commission (every time) - perfect for web hosting providers and programmer resource or service provider websites.

Site Terms : Your use of this website constitutes your agreement to the terms and conditions of Programmer Bids. Any bids/quotes provided by individual freelancers, programmers, web designers and consultants on this website are not recommendations by Programmer Bids - we neither provide any quotes directly to the buyer, nor do we recommend any "specific" service provider registered on our web site. Buyers and corresponding freelancers, programmers, web developers and consultants must assume responsibility for the delivery of work and payment transactions. Programmer Bids.com only provides a buy/sell marketplace for interested buyers, freelance programmers and web designers to buy or sell programming and web development services, on our website. Please read and accept Terms & Conditions before using our service.

 Copyright © 2001-Current, Programmer Bids.comSM ¤ Terms of Use ¤ Contact Us ¤ Tell Friends ¤ Affiliate Program Home