Sedang Disiapkan

Finding the least expensive combination

I basically have an optimization problem in hand that needs some programming, hopefully through excel but if can't be done with Excel, please provide the language you'll be using.

Let's say I have 10 stones:

Stone 1: 10kg

Stone 2: 5kg

Stone 3: 8kg

Stone 4: 11kg

Stone 5: 14kg

Stone 6: 23 kg

Stone 7: 1kg

Stone 8: 7kg

Stone 9: 9kg

Stone 10: 12kg

And I have 3 bags to choose:

Bag 1: Max # of stones in the bag is 6, weight limit is 20 and the price for the bag is $50

Bag 2: Max # of stones in the bag is 3, weight limit is 15 and the price for the bag is $30

Bag 3: Max # of stones in the bag is 10, weight limit is 30 and the price is $100

etc..

so I have fixed number of bags (close to 50), and close to 200 different weighted stones. I'm trying to find a way to optimize the money I pay per bag to carry these stones. So basically I'm trying to pay the least amount to carry these stones.

The numbers are on this letter is fictional so I'd like to be able to enter my own data as far as the bags, stones and their features as far as price & weight & max nr of stones.

I hope this is clear.

I will need 2 things:

1- Full excel spreadsheet (or a basic program) that I can edit (add more data, remove data, play with variables, etc.)

2- The algorithm.

Thanks!!

Kemahiran: Pengaturcaraan C, Pengaturcaraan C++, Excel, Javascript, Kejuruteraan Perisian

Lihat lebih lanjut: variables in programming, the d programming language, the algorithm is, the algorithm, spreadsheet javascript, spreadsheet in javascript, programming variables, m.s.i. stone, max programming, i play programming, hand and stone, find-s algorithm in c, excel add in programming, finding expensive combination, excel programming language, optimization algorithm, find the language, algorithm optimization, javascript spreadsheet, excel weight, excel algorithm, weight excel, algorithm find, javascript algorithm, javascript optimize

Tentang Majikan:
( 1 ulasan ) NEW YORK, United States

ID Projek: #1551416

Dianugerahkan kepada:

procoder898

Hi, I am expert at Data Structure and Algorithm, can surely satisfy you. Please check your inbox,

$99 USD dalam 0 hari
(53 Ulasan)
5.7

15 freelancers are bidding on average $127 for this job

dobreiiita

Anyone can say anything, Please check feedbacks and decide, thanks

$80 USD dalam 2 hari
(196 Ulasan)
6.6
usamacpp

We are a very experienced team who can tackle this task. Please check PMB for more details.

$200 USD dalam 5 hari
(28 Ulasan)
6.0
diepbp

I am confident to handle your project. Please check your inbox for details, thank you.

$150 USD dalam 2 hari
(85 Ulasan)
5.8
kevinxiaozi

Dear sir, I am strong in programming especially in algorithm implementation. Based on your project problem, it is an extended Knapsack problem. I am strong in optimization this problem because I have finished simila Lagi

$100 USD dalam sehari
(25 Ulasan)
5.5
ethicalboy

Please see what I said.

$150 USD dalam 5 hari
(41 Ulasan)
4.8
rvector

I am good at algorithms please PM me

$70 USD dalam 2 hari
(12 Ulasan)
4.6
Algotrade

Please see PMB

$250 USD dalam 3 hari
(18 Ulasan)
4.3
nguyenquoc

i will give you demo for this project.

$80 USD dalam sehari
(6 Ulasan)
3.7
rohitpithisaria

Hi... I would like to apply for the job.

$80 USD dalam sehari
(10 Ulasan)
3.6
majithiyad

Dear Sir, I have done similar project before. See PMB for more details.

$50 USD dalam 2 hari
(0 Ulasan)
0.0
Z02oTRZ1d

Pls check PMB.

$250 USD dalam sehari
(0 Ulasan)
0.0
sholyboy

I can write the algorithm, it's relatively easy

$100 USD dalam 3 hari
(0 Ulasan)
0.0
samavacorp

Hi I run a market research firm STPresearch ([url removed, login to view]) focusing on SMB's i am an expert in excel and have designed many sales related excel based solutions. From my experience this is a simple task we Lagi

$30 USD dalam 3 hari
(0 Ulasan)
0.0
jessicatechno

PLEASE CHECK PMB

$220 USD dalam 5 hari
(0 Ulasan)
0.0