Closed

Visual Basic Programmer to Solve The Sorting Problem in Excel Spreadsheet

This project received 19 bids from talented freelancers with an average bid price of $81 USD.

Get free quotes for a project like this
Employer working
Project Budget
N/A
Total Bids
19
Project Description

hi every body,

I am looking for a visual basic programmer who ca solve my sorting of array problem.
this is excel spreadsheet based visual basic script writing to solve the sorting problem

the logic is given bellow with detailed concept involved.

1. list of pieces with different sized is there to save them in an array
2. sort the list in descending order so, maximum size comes first and minimum size at the end
3. find all possible combinations without repetition (permutations) containing list items whose total is less then or equal to some specified size say 278
4. get the total of each combination and sort the list with respect to the total, in descending order
5. pick all those elements whose total is maximum (precaution is already taken to keep the total bellow some specified size say 278)
6. mark those items in original list as "used", so that in next process cycle , those will not be considered
7. assign all picked elements the iteration number (main loop number)
8. repeat the steps from 3 to 7 until all the elements have been marked and iteration number (main loop number) is given

permutation concept : lets say say we have 5 different values in an array
here is the list of all permutations of array indexes (element position)

1
2
3
4
5
1, 2
1,3
1,4
1,5
2,3
2,4
2,5
3,4
3,5
4,5
1,2,3
1,2,4
1,2,5
1,3,4
1,3,5
1,4,5
2,3,4
2,3,5
3,4,5
1,2,3,4
1,2,3,5
1,2,4,5
1,3,4,5
2,3,4,5
1,2,3,4,5

Note: the project will be awarded to the person who will show me the work done completely as per the requirement in a shortest time.
you can give me the result in excel file without formula or macro code (VBA code), just to validate the result with that one i have to confirm.


Thanks,

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online